1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
CREATE TABLE `sondage` (
`id` SMALLINT NOT NULL AUTO_INCREMENT,
ip char(50),
lang char(50),
`question` TEXT NOT NULL ,
`proposition1` VARCHAR( 100 ) NOT NULL ,
`proposition2` VARCHAR( 100 ) NOT NULL ,
`proposition3` VARCHAR( 100 ) NOT NULL ,
`proposition4` VARCHAR( 100 ) NOT NULL ,
`proposition5` VARCHAR( 100 ) NOT NULL ,
`resultats1` SMALLINT NOT NULL ,
`resultats2` SMALLINT NOT NULL ,
`resultats3` SMALLINT NOT NULL ,
`resultats4` SMALLINT NOT NULL ,
`resultats5` SMALLINT NOT NULL ,
PRIMARY KEY ( `id` )
) ENGINE = InnoDB |
Partager