1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34
|
CREATE TABLE `table` (
`operation_type` varchar(8) NOT NULL default '',
`site` varchar(50) default NULL,
`site_code` varchar(20) default NULL,
`dept` varchar(100) default NULL,
`dept_code` varchar(20) default NULL,
`n_client` varchar(10) NOT NULL default '0',
`ref_option` varchar(50) NOT NULL,
`code` char(3) NOT NULL default '',
`qte` tinyint(2) NOT NULL default '1',
`mtht` decimal(12,3) NOT NULL default '0.000',
`tva` decimal(4,2) default '0.00',
`ident_cc2` varchar(8) NOT NULL default '',
`date_enr` datetime NOT NULL default '1000-01-01 00:00:00',
`cc_init` varchar(100) NOT NULL,
`histo_valideur` longtext NOT NULL,
`dernier_valideur` varchar(10) NOT NULL default 'nonvalidé',
`date_valideur` datetime default NULL,
`ident_integrateur` varchar(20) NOT NULL default '',
`date_integration` datetime default NULL,
`valide` tinyint(1) unsigned zerofill NOT NULL default '0',
`refusN4` tinyint(4) NOT NULL default '0',
`integre` tinyint(1) unsigned zerofill NOT NULL default '0',
`rejete` tinyint(1) unsigned zerofill NOT NULL default '0',
`plateforme` varchar(15) NOT NULL default '',
`ref_lot` varchar(20) NOT NULL default '0',
`ocv04` longtext NOT NULL,
PRIMARY KEY (`n_client`,`date_enr`),
KEY `date1` (`date_valideur`),
KEY `ident_cc2` (`ident_cc2`),
KEY `site` (`site`),
KEY `date2` (`date_enr`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1; |
Partager