2011-12-29 17:28:57 +01:00
|
|
|
CREATE TABLE IF NOT EXISTS `profilextraction` (
|
|
|
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
|
|
|
`idClient` int(11) NOT NULL,
|
2012-01-11 12:11:33 +01:00
|
|
|
`login` VARCHAR( 50 ) NOT NULL,
|
2011-12-29 17:28:57 +01:00
|
|
|
`reference` varchar(50) NOT NULL,
|
|
|
|
|
`criteres` text NOT NULL,
|
|
|
|
|
`tarifLigne` float NOT NULL,
|
|
|
|
|
`dateAjout` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
|
|
|
`dateModif` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
|
|
|
`dateSuppr` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
|
|
|
|
|
`actif` tinyint(4) NOT NULL,
|
|
|
|
|
PRIMARY KEY (`id`),
|
|
|
|
|
KEY `idClient` (`idClient`)
|
|
|
|
|
) DEFAULT CHARSET=utf8 COMMENT='Profil d''extraction' AUTO_INCREMENT=1 ;
|
