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 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58
| CREATE TABLE IF NOT EXISTS `lime_survey_45784` (
`id` int(11) NOT NULL auto_increment,
`submitdate` datetime default NULL,
`startlanguage` varchar(20) collate utf8_unicode_ci NOT NULL,
`45784X6X15` text collate utf8_unicode_ci,
`45784X6X16` text collate utf8_unicode_ci,
`45784X6X17` text collate utf8_unicode_ci,
`45784X6X18` text collate utf8_unicode_ci,
`45784X1X1Opi1` varchar(5) collate utf8_unicode_ci default NULL,
`45784X1X1Opi2` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X2Vis1` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X2Vis2` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X3` varchar(1) collate utf8_unicode_ci default NULL,
`45784X2X4vit1` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit3` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit4` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit5` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit6` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit7` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit8` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit9` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X4vit2` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X5` double default NULL,
`45784X2X6att1` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X6att2` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X6att3` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X6att4` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X6att5` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X6att6` varchar(5) collate utf8_unicode_ci default NULL,
`45784X2X12` text collate utf8_unicode_ci,
`45784X3X7am1` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am2` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am3` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am4` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am5` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am6` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am7` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am8` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am9` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am10` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am11` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am12` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am13` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am14` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X7am15` varchar(5) collate utf8_unicode_ci default NULL,
`45784X3X8` varchar(1) collate utf8_unicode_ci default NULL,
`45784X3X9` varchar(1) collate utf8_unicode_ci default NULL,
`45784X3X10` double default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;
--
-- Contenu de la table `lime_survey_45784`
--
INSERT INTO `lime_survey_45784` (`id`, `submitdate`, `startlanguage`, `45784X6X15`, `45784X6X16`, `45784X6X17`, `45784X6X18`, `45784X1X1Opi1`, `45784X1X1Opi2`, `45784X2X2Vis1`, `45784X2X2Vis2`, `45784X2X3`, `45784X2X4vit1`, `45784X2X4vit3`, `45784X2X4vit4`, `45784X2X4vit5`, `45784X2X4vit6`, `45784X2X4vit7`, `45784X2X4vit8`, `45784X2X4vit9`, `45784X2X4vit2`, `45784X2X5`, `45784X2X6att1`, `45784X2X6att2`, `45784X2X6att3`, `45784X2X6att4`, `45784X2X6att5`, `45784X2X6att6`, `45784X2X12`, `45784X3X7am1`, `45784X3X7am2`, `45784X3X7am3`, `45784X3X7am4`, `45784X3X7am5`, `45784X3X7am6`, `45784X3X7am7`, `45784X3X7am8`, `45784X3X7am9`, `45784X3X7am10`, `45784X3X7am11`, `45784X3X7am12`, `45784X3X7am13`, `45784X3X7am14`, `45784X3X7am15`, `45784X3X8`, `45784X3X9`, `45784X3X10`) VALUES
(1, '1980-01-01 00:00:00', 'fr', 'magasin Bastille', 'Place de la bastille', '11 Novembre 2009 / 15h30 / 45 min', 'toto', 'R4', 'R4', 'R1', 'R1', 'N', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 2, 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'gfdg', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'Y', 'Y', 2),
(2, '1980-01-01 00:00:00', 'fr', 'magasin Opéra', 'Place de l''opéra', '14 Juillet 2009 / 12h10 / 30 min', 'tutu', 'R3', 'R4', 'R2', 'R4', 'N', 'R2', 'R2', 'R2', 'R2', 'R2', 'R2', 'R2', 'R2', 'R2', 2, 'R3', 'R2', 'R1', 'R2', 'R2', 'R2', '21', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'R1', 'N', 'N', NULL); |
Partager