1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
|
CREATE TABLE `lldiffusion_commande` (
`id` int(10) unsigned NOT NULL auto_increment,
`client` varchar(128) NOT NULL default '',
`date` timestamp(14) NOT NULL,
`total_ht` decimal(10,2) unsigned NOT NULL default '0.00',
`total_ttc` decimal(10,2) unsigned NOT NULL default '0.00',
`total_ttc_ref` decimal(10,2) unsigned NOT NULL default '0.00',
`expedition` varchar(128) NOT NULL default '',
`etat` varchar(128) NOT NULL default '',
`type_paiement` varchar(128) default NULL,
`envoi` varchar(128) default NULL,
`mail_envoi` char(2) default NULL,
`frais_port` varchar(30) default NULL,
`frais_port_ref` varchar(30) default NULL,
`dom_tom` char(3) NOT NULL default '',
`contexte` varchar(128) default NULL,
PRIMARY KEY (`id`),
KEY `client` (`client`)
) TYPE=MyISAM COMMENT='Table de la commande globale' |
Partager