19 lines
607 B
SQL
19 lines
607 B
SQL
--
|
|
-- Structure de la table `commandes_pieces`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `commandes_pieces` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`idUser` int(11) NOT NULL,
|
|
`login` varchar(32) NOT NULL,
|
|
`email` varchar(80) NOT NULL,
|
|
`raisonSociale` varchar(200) NOT NULL,
|
|
`siren` varchar(9) NOT NULL,
|
|
`type` char(1) NOT NULL,
|
|
`document` varchar(200) NOT NULL,
|
|
`info` text NOT NULL,
|
|
`statutCommande` int(11) NOT NULL,
|
|
`dateCommande` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateReception` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`id`)
|
|
) DEFAULT CHARSET=utf8; |