20 lines
801 B
SQL
20 lines
801 B
SQL
--
|
|
-- Structure de la table `commandes`
|
|
--
|
|
|
|
CREATE TABLE IF NOT EXISTS `commandes` (
|
|
`idCommande` int(11) NOT NULL AUTO_INCREMENT,
|
|
`idUser` int(11) NOT NULL DEFAULT '0',
|
|
`login` varchar(32) NOT NULL DEFAULT '',
|
|
`emailCommande` varchar(80) NOT NULL DEFAULT '',
|
|
`siren` int(9) unsigned zerofill NOT NULL DEFAULT '000000000',
|
|
`refDocument` varchar(255) NOT NULL DEFAULT '',
|
|
`libDocument` varchar(255) NOT NULL DEFAULT '',
|
|
`typeCommande` varchar(255) NOT NULL,
|
|
`statutCommande` tinyint(4) NOT NULL DEFAULT '0',
|
|
`commentaire` varchar(255) NOT NULL DEFAULT '',
|
|
`dateCommande` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
`dateReception` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
PRIMARY KEY (`idCommande`),
|
|
KEY `dateReception` (`dateReception`)
|
|
) DEFAULT CHARSET=utf8; |