-- Only prefixed tables with: lime_
-- Date of Dump: 14-Jan-2020
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_answer_l10ns`
--
DROP TABLE IF EXISTS `lime_answer_l10ns`;
CREATE TABLE `lime_answer_l10ns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`aid` int(11) NOT NULL,
`answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `lime_answer_l10ns_idx` (`aid`,`language`)
) ENGINE=MyISAM AUTO_INCREMENT=1234 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_answer_l10ns`
--
INSERT INTO `lime_answer_l10ns` (`id`,`aid`,`answer`,`language`) VALUES
('289', '291', 'g', 'en'),
('290', '292', 'Yes', 'en'),
('989', '496', 'Yes', 'en'),
('990', '497', 'No', 'en'),
('991', '498', 'Yes', 'en'),
('993', '500', 'Yes', 'en'),
('994', '501', 'No', 'en'),
('995', '502', 'AA', 'en'),
('996', '503', 'C', 'en'),
('997', '504', 'A', 'en'),
('998', '505', 'B', 'en'),
('999', '506', 'B', 'en'),
('1000', '507', 'C', 'en'),
('1001', '508', 'A1', 'en'),
('1002', '509', 'A2', 'en'),
('1003', '510', 'A3', 'en'),
('1004', '511', 'An error', 'en'),
('1005', '512', 'A3', 'en'),
('1006', '513', 'An error', 'en'),
('1007', '514', 'A1', 'en'),
('1008', '515', 'second category - Last answer option', 'en'),
('1009', '515', 'seconda categoria - Ultima opzione di risposta di esempio', 'it'),
('1010', '515', 'deuxième catégorie - Dernière option de réponse', 'fr'),
('1011', '516', 'Last answer option', 'en'),
('1012', '517', 'Beispielantwort', 'de-informal'),
('1013', '518', 'New answer option', 'en'),
('1014', '519', 'New answer option', 'en'),
('1015', '519', 'Nouvelle option de réponse', 'fr'),
('1016', '520', 'erste Kategorie - Neue Antwortoption', 'de-informal'),
('1017', '521', 'first category - Third answer option', 'en'),
('1018', '521', 'première catégorie - Troisième option de réponse', 'fr'),
('1019', '521', 'prima categoria - Terza opzione di risposta di esempio', 'it'),
('1020', '522', 'Nouvelle option de réponse', 'fr'),
('1021', '516', 'Ultima opzione di risposta di esempio', 'it'),
('1022', '516', 'Letzte Antwortoption', 'de-informal'),
('1023', '523', 'Third answer option', 'en'),
('1024', '524', 'Neue Antwortoption', 'de-informal'),
('1025', '525', 'Some example answer scale 2', 'en'),
('1026', '526', 'Quarta opzione di risposta di esempio - scala 1', 'it'),
('1027', '527', 'Letzte Antwortoption', 'de-informal'),
('1028', '525', 'Un exemple d\'option de réponse - Échelle 2', 'fr'),
('1029', '525', 'Opzione di risposta di esempio - scala 2', 'it'),
('1030', '525', 'Beispielantwort - Skala 2', 'de-informal'),
('1031', '528', 'New answer scale 2', 'en'),
('1032', '529', 'Dritte Antwortoption', 'de-informal'),
('1033', '530', 'Default option', 'en'),
('1034', '531', 'Neue Antwortoption', 'de-informal'),
('1035', '527', 'Dernière option de réponse', 'fr'),
('1036', '532', 'Un exemple d\'option de réponse', 'fr'),
('1037', '533', 'seconda categoria - Terza opzione di risposta di esempio', 'it'),
('1038', '534', 'prima categoria - Ultima opzione di risposta di esempio', 'it'),
('1039', '535', 'Some example answer option', 'en'),
('1040', '535', 'Un exemple d\'option de réponse', 'fr'),
('1041', '517', 'Un exemple d\'option de réponse', 'fr'),
('1042', '536', 'Third answer option', 'en'),
('1043', '522', 'Neue Antwortoption', 'de-informal'),
('1044', '537', 'Ultima opzione di risposta di esempio', 'it'),
('1045', '526', 'Last answer option - scale 1', 'en'),
('1046', '526', 'Dernière option de réponse - Échelle 1', 'fr'),
('1047', '538', 'Nuova opzione di risposta di esempio - scala 1', 'it'),
('1048', '538', 'Neue Antwortoption - Skala 1', 'de-informal'),
('1049', '539', 'Third answer option - scale 1', 'en'),
('1050', '540', 'Some example answer option', 'en'),
('1051', '540', 'Un exemple d\'option de réponse', 'fr'),
('1052', '540', 'Opzione di risposta di esempio', 'it'),
('1053', '516', 'Dernière option de réponse', 'fr'),
('1054', '541', 'Troisième option de réponse', 'fr'),
('1055', '541', 'Third answer option', 'en'),
('1056', '527', 'Ultima opzione di risposta di esempio', 'it'),
('1057', '523', 'Troisième option de réponse', 'fr'),
('1058', '530', 'Opzione di default', 'it'),
('1059', '542', 'seconda categoria - Opzione di risposta di esempio', 'it'),
('1060', '542', 'zweite Kategorie - Beispielantwort', 'de-informal'),
('1061', '542', 'second category - Some example answer option', 'en'),
('1062', '533', 'zweite Kategorie - Dritte Antwortoption', 'de-informal'),
('1063', '533', 'deuxième catégorie - Troisième option de réponse', 'fr'),
('1064', '543', 'Opzione di default', 'it'),
('1065', '519', 'Neue Antwortoption', 'de-informal'),
('1066', '519', 'Nuova opzione di risposta di esempio', 'it'),
('1067', '544', 'Opzione di default', 'it'),
('1068', '518', 'Nouvelle option de réponse', 'fr'),
('1069', '518', 'Nuova opzione di risposta di esempio', 'it'),
('1070', '524', 'Nouvelle option de réponse', 'fr'),
('1071', '524', 'Nuova opzione di risposta di esempio', 'it'),
('1072', '545', 'Un exemple d\'option de réponse', 'fr'),
('1073', '539', 'Troisième option de réponse - Échelle 1', 'fr'),
('1074', '539', 'Terza opzione di risposta di esempio - scala 1', 'it'),
('1075', '529', 'Troisième option de réponse', 'fr'),
('1076', '529', 'Terza opzione di risposta di esempio', 'it'),
('1077', '546', 'Troisième option de réponse', 'fr'),
('1078', '546', 'Third answer option', 'en'),
('1079', '531', 'Nouvelle option de réponse', 'fr'),
('1080', '523', 'Dritte Antwortoption', 'de-informal'),
('1081', '527', 'Last answer option', 'en'),
('1082', '532', 'Beispielantwort', 'de-informal'),
('1083', '531', 'New answer option', 'en'),
('1084', '547', 'zweite Kategorie - Neue Antwortoption', 'de-informal'),
('1085', '547', 'seconda categoria - Seconda opzione di risposta di esempio', 'it'),
('1086', '543', 'Option par défaut', 'fr'),
('1087', '543', 'Default option', 'en'),
('1088', '544', 'Option par défaut', 'fr'),
('1089', '544', 'Default option', 'en'),
('1090', '522', 'Nuova opzione di risposta di esempio', 'it'),
('1091', '545', 'Beispielantwort', 'de-informal'),
('1092', '537', 'Last answer option', 'en'),
('1093', '537', 'Dernière option de réponse', 'fr'),
('1094', '536', 'Troisième option de réponse', 'fr'),
('1095', '535', 'Opzione di risposta di esempio', 'it'),
('1096', '538', 'Nouvelle option de réponse - Échelle 1', 'fr'),
('1097', '548', 'Beispielantwort - Skala 1', 'de-informal'),
('1098', '538', 'New answer option - scale 1', 'en'),
('1099', '548', 'Opzione di risposta di esempio - scala 1', 'it'),
('1100', '548', 'Un exemple d\'option de réponse - Échelle 1', 'fr'),
('1101', '524', 'New answer option', 'en'),
('1102', '549', 'Neue Antwortoption', 'de-informal'),
('1103', '550', 'Opzione di risposta di esempio', 'it'),
('1104', '550', 'Beispielantwort', 'de-informal'),
('1105', '549', 'New answer option', 'en'),
('1106', '549', 'Nouvelle option de réponse', 'fr'),
('1107', '549', 'Nuova opzione di risposta di esempio', 'it'),
('1108', '547', 'deuxième catégorie - Nouvelle option de réponse', 'fr'),
('1109', '547', 'second category - New answer option', 'en'),
('1110', '542', 'deuxième catégorie - Un exemple d\'option de réponse', 'fr'),
('1111', '534', 'erste Kategorie - Letzte Antwortoption', 'de-informal'),
('1112', '521', 'erste Kategorie - Dritte Antwortoption', 'de-informal'),
('1113', '534', 'first category - Last answer option', 'en'),
('1114', '534', 'première catégorie - Dernière option de réponse', 'fr'),
('1115', '535', 'Beispielantwort', 'de-informal'),
('1116', '518', 'Neue Antwortoption', 'de-informal'),
('1117', '517', 'Opzione di risposta di esempio', 'it'),
('1118', '517', 'Some example answer option', 'en'),
('1119', '541', 'Terza opzione di risposta di esempio', 'it'),
('1120', '541', 'Dritte Antwortoption', 'de-informal'),
('1121', '522', 'New answer option', 'en'),
('1122', '545', 'Opzione di risposta di esempio', 'it'),
('1123', '545', 'Some example answer option', 'en'),
('1124', '528', 'Nouvelle option de réponse - Échelle 2', 'fr'),
('1125', '526', 'Letzte Antwortoption - Skala 1', 'de-informal'),
('1126', '539', 'Dritte Antwortoption - Skala 1', 'de-informal'),
('1127', '548', 'Some example answer option - scale 1', 'en'),
('1128', '540', 'Beispielantwort', 'de-informal'),
('1129', '550', 'Some example answer option', 'en'),
('1130', '550', 'Un exemple d\'option de réponse', 'fr'),
('1131', '537', 'Letzte Antwortoption', 'de-informal'),
('1132', '551', 'Neue Antwortoption', 'de-informal'),
('1133', '529', 'Third answer option', 'en'),
('1134', '530', 'Default-Wert', 'de-informal'),
('1135', '530', 'Option par défaut', 'fr'),
('1136', '531', 'Nuova opzione di risposta di esempio', 'it'),
('1137', '532', 'Opzione di risposta di esempio', 'it'),
('1138', '532', 'Some example answer option', 'en'),
('1139', '523', 'Terza opzione di risposta di esempio', 'it'),
('1140', '546', 'Terza opzione di risposta di esempio', 'it'),
('1141', '546', 'Dritte Antwortoption', 'de-informal'),
('1142', '552', 'Last answer option', 'en'),
('1143', '552', 'Dernière option de réponse', 'fr'),
('1144', '552', 'Ultima opzione di risposta di esempio', 'it'),
('1145', '552', 'Letzte Antwortoption', 'de-informal'),
('1146', '533', 'second category - Third answer option', 'en'),
('1147', '520', 'prima categoria - Seconda opzione di risposta di esempio', 'it'),
('1148', '520', 'première catégorie - Nouvelle option de réponse', 'fr'),
('1149', '520', 'first category - New answer option', 'en'),
('1150', '553', 'erste Kategorie - Beispielantwort', 'de-informal'),
('1151', '553', 'prima categoria - Opzione di risposta di esempio', 'it'),
('1152', '553', 'première catégorie - Un exemple d\'option de réponse', 'fr'),
('1153', '553', 'first category - Some example answer option', 'en'),
('1154', '515', 'zweite Kategorie - Letzte Antwortoption', 'de-informal'),
('1155', '544', 'Default-Wert', 'de-informal'),
('1156', '554', 'Third answer option', 'en'),
('1157', '554', 'Troisième option de réponse', 'fr'),
('1158', '554', 'Terza opzione di risposta di esempio', 'it'),
('1159', '554', 'Dritte Antwortoption', 'de-informal'),
('1160', '555', 'Last answer option', 'en'),
('1161', '555', 'Dernière option de réponse', 'fr'),
('1162', '555', 'Ultima opzione di risposta di esempio', 'it'),
('1163', '555', 'Letzte Antwortoption', 'de-informal'),
('1164', '543', 'Default-Wert', 'de-informal'),
('1165', '556', 'Third answer option', 'en'),
('1166', '556', 'Troisième option de réponse', 'fr'),
('1167', '556', 'Terza opzione di risposta di esempio', 'it'),
('1168', '556', 'Dritte Antwortoption', 'de-informal'),
('1169', '557', 'Last answer option', 'en'),
('1170', '557', 'Dernière option de réponse', 'fr'),
('1171', '557', 'Ultima opzione di risposta di esempio', 'it'),
('1172', '557', 'Letzte Antwortoption', 'de-informal'),
('1173', '536', 'Terza opzione di risposta di esempio', 'it'),
('1174', '536', 'Dritte Antwortoption', 'de-informal'),
('1175', '558', 'Last answer option', 'en'),
('1176', '558', 'Dernière option de réponse', 'fr'),
('1177', '558', 'Ultima opzione di risposta di esempio', 'it'),
('1178', '558', 'Letzte Antwortoption', 'de-informal'),
('1179', '551', 'Nuova opzione di risposta di esempio', 'it'),
('1180', '551', 'Nouvelle option de réponse', 'fr'),
('1181', '559', 'Beispielantwort', 'de-informal'),
('1182', '551', 'New answer option', 'en'),
('1183', '559', 'Opzione di risposta di esempio', 'it'),
('1184', '559', 'Some example answer option', 'en'),
('1185', '559', 'Un exemple d\'option de réponse', 'fr'),
('1186', '528', 'Nuova opzione di risposta di esempio - scala 2', 'it'),
('1187', '528', 'Neue Antwortoption - Skala 2', 'de-informal');
INSERT INTO `lime_answer_l10ns` (`id`,`aid`,`answer`,`language`) VALUES
('1188', '560', 'Third answer scale 2', 'en'),
('1189', '560', 'Troisième option de réponse - Échelle 2', 'fr'),
('1190', '560', 'Terza opzione di risposta di esempio - scala 2', 'it'),
('1191', '560', 'Dritte Antwortoption - Skala 2', 'de-informal'),
('1192', '561', 'Last answer scale 2', 'en'),
('1193', '561', 'Dernière option de réponse - Échelle 2', 'fr'),
('1194', '561', 'Quarta opzione di risposta di esempio - scala 2', 'it'),
('1195', '561', 'Letzte Antwortoption - Skala 2', 'de-informal'),
('1196', '562', 'Beispielantwort - Skala 1', 'de-informal'),
('1197', '562', 'Some example answer option - scale 1', 'en'),
('1198', '562', 'Un exemple d\'option de réponse - Échelle 1', 'fr'),
('1199', '562', 'Opzione di risposta di esempio - scala 1', 'it'),
('1200', '563', 'Neue Antwortoption - Skala 1', 'de-informal'),
('1201', '563', 'New answer option - scale 1', 'en'),
('1202', '563', 'Nouvelle option de réponse - Échelle 1', 'fr'),
('1203', '563', 'Nuova opzione di risposta di esempio - scala 1', 'it'),
('1204', '564', 'Dritte Antwortoption - Skala 1', 'de-informal'),
('1205', '564', 'Third answer option - scale 1', 'en'),
('1206', '564', 'Troisième option de réponse - Échelle 1', 'fr'),
('1207', '564', 'Terza opzione di risposta di esempio - scala 1', 'it'),
('1208', '565', 'Letzte Antwortoption - Skala 1', 'de-informal'),
('1209', '565', 'Last answer option - scale 1', 'en'),
('1210', '565', 'Dernière option de réponse - Échelle 1', 'fr'),
('1211', '565', 'Quarta opzione di risposta di esempio - scala 1', 'it'),
('1212', '566', 'Beispielantwort - Skala 2', 'de-informal'),
('1213', '566', 'Some example answer scale 2', 'en'),
('1214', '566', 'Un exemple d\'option de réponse - Échelle 2', 'fr'),
('1215', '566', 'Opzione di risposta di esempio - scala 2', 'it'),
('1216', '567', 'Neue Antwortoption - Skala 2', 'de-informal'),
('1217', '567', 'New answer scale 2', 'en'),
('1218', '567', 'Nouvelle option de réponse - Échelle 2', 'fr'),
('1219', '567', 'Nuova opzione di risposta di esempio - scala 2', 'it'),
('1220', '568', 'Dritte Antwortoption - Skala 2', 'de-informal'),
('1221', '568', 'Third answer scale 2', 'en'),
('1222', '568', 'Troisième option de réponse - Échelle 2', 'fr'),
('1223', '568', 'Terza opzione di risposta di esempio - scala 2', 'it'),
('1224', '569', 'Letzte Antwortoption - Skala 2', 'de-informal'),
('1225', '569', 'Last answer scale 2', 'en'),
('1226', '569', 'Dernière option de réponse - Échelle 2', 'fr'),
('1227', '569', 'Quarta opzione di risposta di esempio - scala 2', 'it'),
('1228', '570', 'Yes', 'en'),
('1229', '571', 'No', 'en'),
('1230', '572', 'dddd', 'en'),
('1231', '573', 'ddddd', 'en'),
('1232', '574', 'ddddd', 'en'),
('1233', '575', 'ddddd', 'en');
-- --------------------------------------------------------
--
-- Table structure for table `lime_answers`
--
DROP TABLE IF EXISTS `lime_answers`;
CREATE TABLE `lime_answers` (
`aid` int(11) NOT NULL AUTO_INCREMENT,
`qid` int(11) NOT NULL,
`code` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`sortorder` int(11) NOT NULL,
`assessment_value` int(11) NOT NULL DEFAULT 0,
`scale_id` int(11) NOT NULL DEFAULT 0,
PRIMARY KEY (`aid`),
UNIQUE KEY `lime_answers_idx` (`qid`,`code`,`scale_id`),
KEY `lime_answers_idx2` (`sortorder`)
) ENGINE=MyISAM AUTO_INCREMENT=576 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_answers`
--
INSERT INTO `lime_answers` (`aid`,`qid`,`code`,`sortorder`,`assessment_value`,`scale_id`) VALUES
('291', '1914', 'AO1', '1', '0', '0'),
('500', '2504', 'Y', '2', '0', '0'),
('501', '2504', 'N', '1', '0', '0'),
('502', '2508', 'AA1', '1', '0', '0'),
('498', '2496', 'Y', '2', '0', '0'),
('497', '2496', 'N', '1', '0', '0'),
('504', '2509', 'A02', '2', '0', '0'),
('506', '2509', 'A03', '3', '0', '0'),
('507', '2509', 'A01', '1', '0', '0'),
('512', '2510', 'A03', '3', '0', '0'),
('509', '2510', 'A02', '2', '0', '0'),
('513', '2510', 'A04', '4', '0', '0'),
('514', '2510', 'A1', '1', '0', '0'),
('515', '2536', 'A24', '8', '1', '0'),
('516', '2544', 'A4', '4', '1', '0'),
('517', '2538', 'A1', '1', '1', '0'),
('518', '2538', 'A2', '2', '1', '0'),
('519', '2537', 'A2', '2', '1', '0'),
('520', '2536', 'A12', '2', '1', '0'),
('521', '2536', 'A13', '3', '1', '0'),
('522', '2545', 'A2', '2', '1', '0'),
('523', '2558', 'A3', '3', '1', '0'),
('524', '2558', 'A2', '2', '1', '0'),
('525', '2553', 'A21', '1', '1', '1'),
('526', '2553', 'A14', '4', '1', '0'),
('527', '2558', 'A4', '4', '1', '0'),
('528', '2553', 'A22', '2', '1', '1'),
('529', '2554', 'A3', '3', '1', '0'),
('530', '2556', 'A0', '3', '1', '0'),
('531', '2556', 'A2', '2', '1', '0'),
('532', '2556', 'A1', '1', '1', '0'),
('533', '2536', 'A23', '7', '1', '0'),
('534', '2536', 'A14', '4', '1', '0'),
('535', '2537', 'A1', '1', '1', '0'),
('536', '2545', 'A3', '3', '1', '0'),
('537', '2554', 'A4', '4', '1', '0'),
('538', '2553', 'A12', '2', '1', '0'),
('539', '2553', 'A13', '3', '1', '0'),
('540', '2558', 'A1', '1', '1', '0'),
('541', '2544', 'A3', '3', '1', '0'),
('542', '2536', 'A21', '5', '1', '0'),
('543', '2537', 'A0', '3', '1', '0'),
('544', '2538', 'A0', '3', '1', '0'),
('545', '2545', 'A1', '1', '1', '0'),
('546', '2556', 'A3', '4', '1', '0'),
('547', '2536', 'A22', '6', '1', '0'),
('548', '2553', 'A11', '1', '1', '0'),
('549', '2544', 'A2', '2', '1', '0'),
('550', '2544', 'A1', '1', '1', '0'),
('551', '2554', 'A2', '2', '1', '0'),
('552', '2556', 'A4', '5', '1', '0'),
('553', '2536', 'A11', '1', '1', '0'),
('554', '2538', 'A3', '4', '1', '0'),
('555', '2538', 'A4', '5', '1', '0'),
('556', '2537', 'A3', '4', '1', '0'),
('557', '2537', 'A4', '5', '1', '0'),
('558', '2545', 'A4', '4', '1', '0'),
('559', '2554', 'A1', '1', '1', '0'),
('560', '2553', 'A23', '3', '1', '1'),
('561', '2553', 'A24', '4', '1', '1'),
('562', '2576', 'A11', '1', '1', '0'),
('563', '2576', 'A12', '2', '1', '0'),
('564', '2576', 'A13', '3', '1', '0'),
('565', '2576', 'A14', '4', '1', '0'),
('566', '2576', 'A21', '1', '1', '1'),
('567', '2576', 'A22', '2', '1', '1'),
('568', '2576', 'A23', '3', '1', '1'),
('569', '2576', 'A24', '4', '1', '1'),
('570', '2723', 'Y', '2', '0', '0'),
('571', '2723', 'N', '1', '0', '0'),
('572', '2727', 'SQ00', '0', '0', '0'),
('575', '2727', 'SQ01', '0', '0', '0');
-- --------------------------------------------------------
--
-- Table structure for table `lime_assessments`
--
DROP TABLE IF EXISTS `lime_assessments`;
CREATE TABLE `lime_assessments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) NOT NULL DEFAULT 0,
`scope` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
`gid` int(11) NOT NULL DEFAULT 0,
`name` text COLLATE utf8mb4_unicode_ci NOT NULL,
`minimum` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`maximum` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`message` text COLLATE utf8mb4_unicode_ci NOT NULL,
`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
PRIMARY KEY (`id`,`language`),
KEY `lime_assessments_idx2` (`sid`),
KEY `lime_assessments_idx3` (`gid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_assessments`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_asset_version`
--
DROP TABLE IF EXISTS `lime_asset_version`;
CREATE TABLE `lime_asset_version` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`path` text COLLATE utf8mb4_unicode_ci NOT NULL,
`version` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_asset_version`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_auditlog_log`
--
DROP TABLE IF EXISTS `lime_auditlog_log`;
CREATE TABLE `lime_auditlog_log` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`created` datetime DEFAULT NULL,
`uid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entity` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`entityid` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`action` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`fields` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`oldvalues` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`newvalues` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_auditlog_log`
--
INSERT INTO `lime_auditlog_log` (`id`,`created`,`uid`,`entity`,`entityid`,`action`,`fields`,`oldvalues`,`newvalues`) VALUES
('1', '2019-07-15 15:04:33', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-14 13:06:22\",\"lastLogin\":\"2019-07-14 11:06:21\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 13:04:33\"}'),
('2', '2019-07-15 15:04:33', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('3', '2019-07-15 15:14:54', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 15:04:33\",\"lastLogin\":\"2019-07-15 13:04:33\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 13:14:54\"}'),
('4', '2019-07-15 15:14:54', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('5', '2019-07-15 15:29:51', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 15:14:54\",\"lastLogin\":\"2019-07-15 13:14:54\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 13:29:51\"}'),
('6', '2019-07-15 15:29:51', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('7', '2019-07-15 15:35:21', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 15:29:51\",\"lastLogin\":\"2019-07-15 13:29:51\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 13:35:21\"}'),
('8', '2019-07-15 15:35:21', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('9', '2019-07-15 16:46:34', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 15:35:21\",\"lastLogin\":\"2019-07-15 13:35:21\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 14:46:34\"}'),
('10', '2019-07-15 16:46:34', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('11', '2019-07-15 16:48:25', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 16:46:34\",\"lastLogin\":\"2019-07-15 14:46:34\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 14:48:25\"}'),
('12', '2019-07-15 16:48:25', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('13', '2019-07-15 17:02:08', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 16:48:25\",\"lastLogin\":\"2019-07-15 14:48:25\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 15:02:08\"}'),
('14', '2019-07-15 17:02:08', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('15', '2019-07-15 17:17:01', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 17:02:08\",\"lastLogin\":\"2019-07-15 15:02:08\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 15:17:01\"}'),
('16', '2019-07-15 17:17:01', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('17', '2019-07-15 17:39:36', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 17:17:01\",\"lastLogin\":\"2019-07-15 15:17:01\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-15 15:39:36\"}'),
('18', '2019-07-15 17:39:37', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('19', '2019-07-16 09:17:11', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-15 17:39:37\",\"lastLogin\":\"2019-07-15 15:39:36\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-16 07:17:11\"}'),
('20', '2019-07-16 09:17:11', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('21', '2019-07-20 17:52:34', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-16 09:17:11\",\"lastLogin\":\"2019-07-16 07:17:11\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-20 15:52:34\"}'),
('22', '2019-07-20 17:52:35', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('23', '2019-07-23 13:06:17', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-20 17:52:35\",\"lastLogin\":\"2019-07-20 15:52:34\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-23 11:06:17\"}'),
('24', '2019-07-23 13:06:17', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('25', '2019-07-23 13:12:28', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-23 13:06:17\",\"lastLogin\":\"2019-07-23 11:06:17\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-23 11:12:28\"}'),
('26', '2019-07-23 13:12:28', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('27', '2019-07-24 19:21:40', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-23 13:12:28\",\"lastLogin\":\"2019-07-23 11:12:28\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-24 17:21:40\"}'),
('28', '2019-07-24 19:21:40', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('29', '2019-07-24 19:22:37', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"MHEJKTSIXZNDHBX\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('30', '2019-07-24 19:22:37', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"DYXODPKHHVMGACI\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('31', '2019-07-24 19:22:37', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"XRYDNHDBSHWAAWG\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('32', '2019-07-24 19:22:51', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"241435871849312\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('33', '2019-07-24 19:22:51', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"577383945891582\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('34', '2019-07-24 19:22:51', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"491253346275458\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('35', '2019-07-24 19:23:07', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"EnSyXUaZkWwSNA4\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('36', '2019-07-24 19:23:07', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"F2XnKFw87M2Rs2c\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('37', '2019-07-24 19:23:07', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"FUzN2yLCSmR2L7g\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('38', '2019-07-24 19:23:07', '1', 'token_497896', NULL, 'create', 'sent,remindersent,remindercount,completed,usesleft,validfrom,validuntil,firstname,lastname,email,token,language,tid,participant_id,emailstatus,blacklisted,mpid', '[]', '{\"sent\":\"N\",\"remindersent\":\"N\",\"remindercount\":0,\"completed\":\"N\",\"usesleft\":\"1\",\"validfrom\":null,\"validuntil\":null,\"firstname\":\"\",\"lastname\":\"\",\"email\":\"\",\"token\":\"gm7xX3x5Epot5L7\",\"language\":\"en\",\"tid\":null,\"participant_id\":null,\"emailstatus\":null,\"blacklisted\":null,\"mpid\":null}'),
('39', '2019-07-25 10:34:11', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-24 19:21:40\",\"lastLogin\":\"2019-07-24 17:21:40\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-25 08:34:11\"}'),
('40', '2019-07-25 10:34:11', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('41', '2019-07-25 15:10:54', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-25 10:34:11\",\"lastLogin\":\"2019-07-25 08:34:11\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-25 13:10:54\"}'),
('42', '2019-07-25 15:10:54', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL),
('43', '2019-07-26 11:25:49', '1', 'user', '1', 'update', 'modified,lastLogin', '{\"modified\":\"2019-07-25 15:10:54\",\"lastLogin\":\"2019-07-25 13:10:54\"}', '{\"modified\":{\"expression\":\"NOW()\",\"params\":[]},\"lastLogin\":\"2019-07-26 09:25:49\"}'),
('44', '2019-07-26 11:25:49', '1', 'user', '1', 'afterSuccessfulLogin', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_boxes`
--
DROP TABLE IF EXISTS `lime_boxes`;
CREATE TABLE `lime_boxes` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`position` int(11) DEFAULT NULL,
`url` text COLLATE utf8mb4_unicode_ci NOT NULL,
`title` text COLLATE utf8mb4_unicode_ci NOT NULL,
`ico` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`desc` text COLLATE utf8mb4_unicode_ci NOT NULL,
`page` text COLLATE utf8mb4_unicode_ci NOT NULL,
`usergroup` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_boxes`
--
INSERT INTO `lime_boxes` (`id`,`position`,`url`,`title`,`ico`,`desc`,`page`,`usergroup`) VALUES
('1', '1', 'admin/survey/sa/newsurvey', 'Create survey', 'icon-add', 'Create a new survey', 'welcome', '-2'),
('2', '2', 'admin/survey/sa/listsurveys', 'List surveys', 'icon-list', 'List available surveys', 'welcome', '-1'),
('3', '3', 'admin/globalsettings', 'Global settings', 'icon-settings', 'Edit global settings', 'welcome', '-2'),
('4', '4', 'admin/update', 'ComfortUpdate', 'icon-shield', 'Stay safe and up to date', 'welcome', '-2'),
('5', '5', 'admin/labels/sa/view', 'Label sets', 'icon-label', 'Edit label sets', 'welcome', '-2'),
('6', '6', 'admin/themeoptions', 'Themes', 'icon-templates', 'Themes', 'welcome', '-2');
-- --------------------------------------------------------
--
-- Table structure for table `lime_conditions`
--
DROP TABLE IF EXISTS `lime_conditions`;
CREATE TABLE `lime_conditions` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`qid` int(11) NOT NULL DEFAULT 0,
`cqid` int(11) NOT NULL DEFAULT 0,
`cfieldname` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`method` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`scenario` int(11) NOT NULL DEFAULT 1,
PRIMARY KEY (`cid`),
KEY `lime_conditions_idx` (`qid`),
KEY `lime_conditions_idx3` (`cqid`)
) ENGINE=MyISAM AUTO_INCREMENT=61 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_conditions`
--
INSERT INTO `lime_conditions` (`cid`,`qid`,`cqid`,`cfieldname`,`method`,`value`,`scenario`) VALUES
('46', '2569', '2565', '282267X127X2565', '==', 'SH101', '2'),
('47', '2567', '2569', '282267X127X2569', '!=', 'Y', '3'),
('48', '2568', '2569', '282267X127X2569', '!=', 'Y', '3'),
('49', '2567', '2566', '282267X127X2566', '==', 'SQ201', '3'),
('50', '2569', '2566', '282267X127X2566', '==', 'SQ202', '3'),
('51', '2569', '2566', '282267X127X2566', '==', 'SQ201', '3'),
('52', '2569', '2565', '282267X127X2565', '==', 'SH102', '2'),
('53', '2567', '2565', '+282267X127X2565SH101', '==', 'Y', '2'),
('54', '2562', '2561', '282267X127X2561', '==', 'Y', '1'),
('55', '2563', '2561', '282267X127X2561', '==', 'N', '1'),
('56', '2564', '2561', '282267X127X2561', '==', ' ', '1'),
('57', '2568', '2569', '282267X127X2569', '!=', 'Y', '2'),
('58', '2568', '2565', '+282267X127X2565SH102', '==', 'Y', '2'),
('59', '2568', '2566', '+282267X127X2566SQ202', '==', 'Y', '3'),
('60', '2567', '2569', '282267X127X2569', '!=', 'Y', '2');
-- --------------------------------------------------------
--
-- Table structure for table `lime_defaultvalue_l10ns`
--
DROP TABLE IF EXISTS `lime_defaultvalue_l10ns`;
CREATE TABLE `lime_defaultvalue_l10ns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`dvid` int(11) NOT NULL DEFAULT 0,
`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`defaultvalue` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `lime_idx1_defaultvalue_l10ns` (`dvid`,`language`)
) ENGINE=InnoDB AUTO_INCREMENT=73 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
--
-- Dumping data for table `lime_defaultvalue_l10ns`
--
INSERT INTO `lime_defaultvalue_l10ns` (`id`,`dvid`,`language`,`defaultvalue`) VALUES
('54', '24', 'en', 'Y'),
('55', '24', 'fr', 'Y'),
('56', '24', 'it', 'Y'),
('57', '25', 'en', 'Y'),
('58', '25', 'fr', 'Y'),
('59', '25', 'it', 'Y'),
('60', '26', 'en', 'Y'),
('61', '26', 'fr', 'Y'),
('62', '26', 'it', 'Y'),
('63', '27', 'en', 'Y'),
('64', '27', 'fr', 'Y'),
('65', '27', 'it', 'Y'),
('66', '28', 'en', 'A0'),
('67', '28', 'fr', 'A0'),
('68', '28', 'de-informal', 'A0'),
('69', '29', 'en', 'check'),
('70', '30', 'en', 'Crypted data'),
('71', '31', 'en', 'Uncrypted data'),
('72', '32', 'en', 'Uncrypted data');
-- --------------------------------------------------------
--
-- Table structure for table `lime_defaultvalues`
--
DROP TABLE IF EXISTS `lime_defaultvalues`;
CREATE TABLE `lime_defaultvalues` (
`dvid` int(11) NOT NULL AUTO_INCREMENT,
`qid` int(11) NOT NULL DEFAULT 0,
`scale_id` int(11) NOT NULL DEFAULT 0,
`sqid` int(11) NOT NULL DEFAULT 0,
`specialtype` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`dvid`),
KEY `lime_idx1_defaultvalue` (`qid`,`scale_id`,`sqid`,`specialtype`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
--
-- Dumping data for table `lime_defaultvalues`
--
INSERT INTO `lime_defaultvalues` (`dvid`,`qid`,`scale_id`,`sqid`,`specialtype`) VALUES
('29', '2508', '0', '0', ''),
('27', '2541', '0', '2580', ''),
('26', '2541', '0', '2581', ''),
('25', '2541', '0', '2582', ''),
('24', '2541', '0', '2583', ''),
('28', '2556', '0', '0', ''),
('31', '2754', '0', '0', ''),
('32', '2754', '0', '0', ''),
('30', '2755', '0', '0', '');
-- --------------------------------------------------------
--
-- Table structure for table `lime_expression_errors`
--
DROP TABLE IF EXISTS `lime_expression_errors`;
CREATE TABLE `lime_expression_errors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`errortime` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
`gid` int(11) DEFAULT NULL,
`qid` int(11) DEFAULT NULL,
`gseq` int(11) DEFAULT NULL,
`qseq` int(11) DEFAULT NULL,
`type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`eqn` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`prettyprint` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_expression_errors`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_failed_login_attempts`
--
DROP TABLE IF EXISTS `lime_failed_login_attempts`;
CREATE TABLE `lime_failed_login_attempts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
`last_attempt` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`number_attempts` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_failed_login_attempts`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_group_l10ns`
--
DROP TABLE IF EXISTS `lime_group_l10ns`;
CREATE TABLE `lime_group_l10ns` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`gid` int(11) NOT NULL,
`group_name` text COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`language` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `lime_idx1_group_ls` (`gid`,`language`)
) ENGINE=MyISAM AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_group_l10ns`
--
INSERT INTO `lime_group_l10ns` (`id`,`gid`,`group_name`,`description`,`language`) VALUES
('57', '77', 'My first question group', NULL, 'en'),
('58', '78', 'My first question group', NULL, 'en'),
('59', '79', 'My first question group', NULL, 'en'),
('66', '86', 'Groupe', '', 'fr'),
('62', '82', 'My first question group', '', 'en'),
('63', '83', 'Some can be no in HTML source', '', 'en'),
('67', '87', 'My first question group', '', 'en'),
('68', '88', 'My first question group', '', 'en'),
('157', '119', 'My first question group', '', 'en'),
('158', '120', 'Groupe multiple', '', 'en'),
('159', '121', 'My first survey page', NULL, 'en'),
('160', '122', 'My first survey page', NULL, 'en'),
('161', '123', 'Text question', 'This is the description for text question group.', 'en'),
('162', '123', 'Question de type texte', 'Ceci est la description du groupe de questions de type texte.', 'fr'),
('152', '114', 'My first survey page', NULL, 'en'),
('153', '115', 'Page', '', 'en'),
('154', '116', 'Page1', '', 'en'),
('155', '117', 'My first question group', '', 'en'),
('156', '118', 'Groupe multiple', '', 'en'),
('163', '123', 'Textfragen', 'r453q26ier steht die Beschreibung für die Gruppe der Textfragen.', 'de-informal'),
('164', '123', 'Domande di tipo Testo', 'Questa è la descrizione per questo gruppo.', 'it'),
('165', '124', 'Numerische Fragen', 'r453q26ier steht die Beschreibung für die Gruppe der numerischen Fragen.', 'de-informal'),
('166', '124', 'Question de type numérique', 'Ceci est la description des questions de type numérique', 'fr'),
('167', '124', 'Numeric question', 'This is the description for numeric question group.', 'en'),
('168', '124', 'Domande numeriche', 'Questa è la descrizione del gruppo di domande numeriche', 'it'),
('169', '125', 'Single choice question', 'The single choice questions group description', 'en'),
('170', '125', 'Question à réponse unique', 'Ceci est la description du groupe des questions à réponse unique', 'fr'),
('171', '125', 'Einfachauswahl', 'r453q26ier steht die Beschreibung für die Gruppe der Einfachauswahl-Fragen.', 'de-informal'),
('172', '125', 'Domande a scelta singola', 'Descrizione del gruppo dedicato alle Domande a scelta singola', 'it'),
('173', '126', 'Mehrfachauswahl', 'r453q26ier steht die Beschreibung für die Gruppe der Mehrfachauswahl-Fragen.', 'de-informal'),
('174', '126', 'QSuestions à réponses multiples', 'Ceci est la description du groupe des questions à réponses multiples', 'fr'),
('175', '126', 'Multi choice question', 'This is the description for multi choice question', 'en'),
('176', '126', 'Domande a scelta multipla', 'Questa è la descrizione del gruppo di domande a scelta multipla', 'it'),
('177', '127', 'Bedingungen und Filter', '
Limesurvey unterstützt eine Vielzahl von Bedingungen und Filtern zum Anzeigen und Vestecken von Fragen. Dies umfasst Bedingungen mit UND- sowie ODER-Verknüpfungen. Weitere Informationen finden sich in der LimeSurvey Dokumentation.
\n', 'de-informal'),
('178', '127', 'Condition and scenario', '
LimeSurvey can use a lot of condition and filter to show or hide question. You an use AND or OR condition. You can use previous question answers and tokens.
\n', 'en'),
('179', '127', 'Conditions and scenario', '
LimeSurvey peut utiliser de nombreuses conditions et filtres pour masquer certaines questions. Il est possible d\'utiliser des conditions de type OR ou AND. Vous pouvez utiliser les réponses précédentes mais aussi les attributs des invitations.
\n', 'fr'),
('180', '127', 'Condizioni e scenari', '
LimeSurvey consente l\'utilizzo di molte condizioni e filtri per nascondere e mostrare domande. Puoi usare le condizioni in AND e in OR, e utilizzare le risposte fornite alle domande precedenti oppure le informazioni dei partecipanti (tokens).
', '', 'en', ''),
('4788', '2502', 'How many answer at total for next question. Entre a big value to see next question.', 'Already {statCount(self.sgqa)} answer in this question and {statCount(Q01.sgqa)} in next question', 'en', ''),
('4946', '2555', 'Tableau (Nombres) ( Valeur minimum: -2, Valeur maximum: 2, Valeur du pas : 2)', 'Un seul choix dans une liste de nombres', 'fr', NULL),
('4945', '2554', 'Array per colonna', 'Stessa domanda di prima, cambia solo l\'orientamento', 'it', NULL),
('4943', '2554', 'Array by column', 'Same question than before, just the orientation has changed', 'en', NULL),
('4944', '2554', 'Matrix nach Spalten', 'Gleiche Frage wie zuvor, nur die Achsen sind vertauscht', 'de-informal', NULL),
('4932', '2551', 'Zahlen-Matrix (Text-Eingabefelder)', 'Dies ist eine Matrix-Frage', 'de-informal', ''),
('4931', '2551', 'Array numbers (text input)', 'This is an array type question', 'en', ''),
('4933', '2551', 'Array (Numeri)', 'Questa è una domanda di tipo Array', 'it', ''),
('4934', '2552', 'Array Numbers (Checkbox layout)', '', 'en', NULL),
('4935', '2552', 'Tableau (Nombres) (Utilisation de cases à cocher)', '', 'fr', NULL),
('4936', '2552', 'Array Zahlen (0/1) (Checkbox-Layout)', '', 'de-informal', NULL),
('4937', '2552', 'Array Numeri (con layout del Checkbox)', '', 'it', NULL),
('4938', '2553', 'Tableau double échelle', '', 'fr', NULL),
('4939', '2553', 'Array dual scale', '', 'en', NULL),
('4940', '2553', 'Dual-Matrix', '', 'de-informal', NULL),
('4941', '2553', 'Array con doppia scala', '', 'it', NULL),
('4942', '2554', 'Afficher en colonnes', 'C\'est exactement la même que question que précédemment, seule l\'orientation à était modifiée.', 'fr', NULL),
('4852', '2531', 'Mehrfache numerische Eingabe mit Slider-Layout und Sliderdetails \nGenauigkeit = 0,1 \nMinimumwert \nMaximumwert \nNutzung des Text-Separators', '', 'de-informal', NULL),
('4781', '2495', 'Condition is Q00.NAOK < 4, current is {4}, with not submitted {4}', '', 'en', ''),
('4776', '2490', '', '', 'en', ''),
('4775', '2489', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('4777', '2491', 'aaaaa', '', 'en', NULL),
('4778', '2492', 'bbbbb', '', 'en', NULL),
('4779', '2493', 'ccccc', '', 'en', NULL),
('4780', '2494', 'How many answer at total for next question. Entre a big value to see next question.', 'Already {4} answer in this question and {5} in next question', 'en', ''),
('4787', '2501', 'Event #2 (still {2 - 2} places)', '', 'en', NULL),
('4786', '2500', 'Event #2 (still {5 - 3} places)', '', 'en', NULL),
('4783', '2497', 'Event #1 (still {10 - 4} places)', '', 'en', NULL),
('4782', '2496', 'Did you participate to this events : ', 'Array filter style : hidden', 'en', ''),
('4796', '2510', 'Another way to loose data !\nMake a lot … of update …', 'Make a lot …', 'en', 'Acomplex script here ? '),
('4797', '2511', 'SQ01', '', 'en', NULL),
('4805', '2519', 'ssss', '', 'en', NULL),
('4806', '2520', 'Short free text', 'This is the help text', 'en', ''),
('4807', '2520', 'Zone de texte court', 'Un texte d\'aide pour les personnes interrogées.', 'fr', ''),
('4808', '2520', 'Kurzer freier Text', 'Hilfetext', 'de-informal', ''),
('4809', '2520', 'Testo breve', 'Questo è il testo per spiegare meglio la domanda.', 'it', ''),
('4810', '2521', 'Long free text', '', 'en', NULL),
('4811', '2521', 'Zone de texte long', '', 'fr', NULL),
('4812', '2521', 'Langer freier Text', '', 'de-informal', NULL),
('4813', '2521', 'Testo lungo', '', 'it', NULL),
('4814', '2522', 'Huge free text', '', 'en', NULL),
('4815', '2522', 'Zone de texte très long', '', 'fr', NULL),
('4816', '2522', 'Ausführlicher freier Text', '', 'de-informal', NULL),
('4817', '2522', 'Testo libero maxi', '', 'it', NULL),
('4818', '2523', 'Short free text (Numbers only)', '', 'en', NULL),
('4819', '2523', 'Zone de texte court ( Nombres uniquement, avec un minuteur )', '', 'fr', NULL),
('4820', '2523', 'Kurzer freier Text beschränkt auf numerische Eingaben, mit zusätzlicher Timerfunktion', '', 'de-informal', NULL),
('4821', '2523', 'Testo breve (Solo numeri)', '', 'it', NULL),
('4822', '2524', 'Long free text (Input box width :3, Display rows : 2 , Maximum characters : 6)', '', 'en', NULL),
('4823', '2524', 'Zone de texte long (Lignes à afficher : 2 , Largeur de la zone de saisie : 3, Nombre maximum de caractères : 6)', '', 'fr', NULL),
('4824', '2524', '
Langer freier Text, Eingabefeld mit Größenangaben:
This question change the language of the actual survey : don\'t use for other thing.
\n\n
It can be interesting to use it at survey start
\n', 'en', NULL),
('4868', '2535', 'Sprachwechsler-Baustein', 'Dieser Fragetyp fragt keine Informationen ab sondern bietet lediglich die Möglichkeit, bei mehrsprachigen Fragebögen die Sprache zu wechseln, weshalb sich seine Verwendung insbesondere am Beginn des Fragebogens empfiehlt.', 'de-informal', NULL),
('4869', '2535', 'Cambio lingua', '
Questa domanda permette di cambiare la lingua del questionario, non altro.
\n\n
Può essere interessante inserirla a inizio questionario.
\n', '', 'de-informal', NULL),
('4889', '2540', 'Scelta multipla (con opzione esclusiva)', '', 'it', NULL),
('4890', '2541', 'Multiples cases à cocher avec commentaires (Valeurs par défaut et nombre de réponses minimum)', '', 'fr', NULL),
('4891', '2541', 'Multiple option with comments (default answers and 1 Minimum Answer)', '', 'en', NULL),
('4892', '2541', 'Mehrfachauswahl mit Kommentarfeldern (Defaultantworten und Minimum Antworten = 1)', '', 'de-informal', NULL),
('4893', '2541', 'Scelta multipla con commenti (risposte di default e 1 risposta minima)', '', 'it', NULL),
('4894', '2542', 'Date', '', 'fr', NULL),
('4895', '2542', 'Date', '', 'en', NULL),
('4896', '2542', 'Datumsangabe', '', 'de-informal', NULL),
('4897', '2542', 'Data', '', 'it', NULL),
('4898', '2543', 'Date (Afficher les boites de sélection , Année minimal et maximale)', '', 'fr', NULL),
('4899', '2543', 'Date (Display select boxes , year Maximum and Minimum)', '', 'en', NULL),
('4900', '2543', 'Datumsangabe über Drop-Down-Felder mit Minimum und Maximum für die Jahresangabe', '', 'de-informal', NULL),
('4901', '2543', 'Data (visualizzazione riquadri, anno minimo e massimo)', '', 'it', NULL),
('4902', '2544', 'Classement', '', 'fr', NULL),
('4903', '2544', 'Ranking', '', 'en', NULL),
('4904', '2544', 'Ranking', '', 'de-informal', NULL),
('4905', '2544', 'Classifica', '', 'it', NULL),
('4906', '2545', 'Tableau', '', 'fr', NULL),
('4907', '2545', 'Array', '', 'en', NULL),
('4908', '2545', 'Matrix', '', 'de-informal', NULL),
('4909', '2545', 'Array', '', 'it', NULL),
('4910', '2546', 'Tableau (5 boutons radio)', '', 'fr', NULL),
('4911', '2546', 'Array 5 point choice', '', 'en', NULL),
('4912', '2546', 'Matrix 5-Punkte-Skala', '', 'de-informal', NULL),
('4913', '2546', 'Array (punteggio 1-5)', '', 'it', NULL),
('4914', '2547', 'Tableau (10 boutons radio)', '', 'fr', NULL),
('4915', '2547', 'Array 10 point choice', '', 'en', NULL),
('4916', '2547', 'Matrix 10-Punkte-Skala', '', 'de-informal', NULL),
('4917', '2547', 'Array (punteggio 1-10)', '', 'it', NULL),
('4918', '2548', 'Tableau (Augmenter, Sans changement, Diminuer)', '', 'fr', NULL),
('4919', '2548', 'Array (Increase/Same/Decrease)', '', 'en', NULL),
('4920', '2548', 'Matrix (Zunahme/gleichbleibend/Abnahme)', '', 'de-informal', NULL),
('4921', '2548', 'Array (Aumenta, Uguale, Diminuisce)', '', 'it', NULL),
('4922', '2549', 'A la suite, les tableaux de questions à réponses uniques', 'Ceci est une question de type \"question sans réponse\", nous l\'utilisons pour effectuer une séparation.', 'fr', NULL),
('4923', '2549', 'Next is the array single choice question type', 'This is a boilerplate question, we use it to make a separation', 'en', NULL),
('4924', '2549', 'Textbaustein: \"Die nächste Frage kommt gleich...\"', 'Dies ist nur ein Textbaustein mit Hinweistexten.', 'de-informal', NULL),
('4925', '2549', 'La prossima è una domanda di tipo array - scelta singola', 'Questa è una domanda di visualizzazione testo, usata per separare la prossima batteria di domande', 'it', NULL),
('4926', '2550', 'Tableau (texte)', 'Ceci est une question de type tableau', 'fr', NULL),
('4927', '2550', 'Array Texts', 'This is an array question', 'en', NULL),
('4928', '2550', 'Array von Textfeldern', 'Dies ist eine Frage vom Typ \"Array\"', 'de-informal', NULL),
('4929', '2550', 'Array (Testi)', 'Questa è una domanda di tipo Array (Testi)', 'it', NULL),
('4930', '2551', 'Tableau (Nombres) (Saisies de texte)', 'Ceci est une question de type tableau', 'fr', ''),
('5096', '2592', 'Beispiel Teilfrage - X', '', 'de-informal', NULL),
('5095', '2592', 'Un exemple de sous-question - Échelle X', '', 'fr', NULL),
('5094', '2592', 'Some example subquestion - X-Scale', '', 'en', NULL),
('5525', '2699', 'letzte Teilfrage - X', '', 'de-informal', NULL),
('5526', '2700', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('5522', '2699', 'X-axis last subquestion', '', 'en', NULL),
('5523', '2699', 'X-axis last subquestion', '', 'fr', NULL),
('5524', '2699', 'Asse-X: Quarta sotto-domanda di esempio', '', 'it', NULL),
('5518', '2698', 'X-axis third subquestion', '', 'en', NULL),
('5519', '2698', 'X-axis third subquestion', '', 'fr', NULL),
('5520', '2698', 'Asse-X: third Terza sotto-domanda di esempio', '', 'it', NULL),
('5521', '2698', 'Teilfrage drei - X', '', 'de-informal', NULL),
('5081', '2588', 'Asse-Y: Prima sotto-domanda di esempio', '', 'it', NULL),
('5080', '2588', 'Beispiel Teilfrage - Y', '', 'de-informal', NULL),
('5079', '2588', 'Y-axis example subquestion', '', 'en', NULL),
('5078', '2588', 'Y-axis example subquestion', '', 'fr', NULL),
('5514', '2697', 'X-axis new answer subquestion', '', 'en', NULL),
('5515', '2697', 'X-axis new answer subquestion', '', 'fr', NULL),
('5516', '2697', 'Asse-X: Seconda sotto-domanda di esempio', '', 'it', NULL),
('5517', '2697', 'weitere Teilfrage - X', '', 'de-informal', NULL),
('5508', '2695', 'Asse-Y: Quarta sotto-domanda di esempio', '', 'it', NULL),
('5509', '2695', 'letzte Teilfrage - Y', '', 'de-informal', NULL),
('5510', '2696', 'X-axis example subquestion', '', 'en', NULL),
('5511', '2696', 'X-axis example subquestion', '', 'fr', NULL),
('5512', '2696', 'Asse-X: Prima sotto-domanda di esempio', '', 'it', NULL),
('5513', '2696', 'Beispiel Teilfrage - X', '', 'de-informal', NULL),
('5503', '2694', 'Y-axis third subquestion', '', 'fr', NULL),
('5504', '2694', 'Asse-Y: Terza sotto-domanda di esempio', '', 'it', NULL),
('5505', '2694', 'Teilfrage drei - Y ', '', 'de-informal', NULL),
('5506', '2695', 'Y-axis last subquestion', '', 'en', NULL),
('5507', '2695', 'Y-axis last subquestion', '', 'fr', NULL),
('5498', '2693', 'Y-axis new answer subquestion', '', 'en', NULL),
('5499', '2693', 'Y-axis new answer subquestion', '', 'fr', NULL),
('5500', '2693', 'Asse-Y: Seconda sotto-domanda di esempio', '', 'it', NULL),
('5501', '2693', 'weitere Teilfrage - Y', '', 'de-informal', NULL),
('5502', '2694', 'Y-axis third subquestion', '', 'en', NULL),
('5061', '2583', 'LimeSurvey è facile come', '', 'it', NULL),
('5060', '2583', 'LimeSurvey est facile comme ', '', 'fr', NULL),
('5059', '2583', 'LimeSurvey ist leicht zu nutzen, weil...', '', 'de-informal', NULL),
('5058', '2583', 'LimeSurvey is easy like ', '', 'en', NULL),
('5057', '2582', 'LimeSurvey è bello come', '', 'it', NULL),
('5056', '2582', 'LimeSurvey est beau comme ', '', 'fr', NULL),
('5055', '2582', 'LimeSurvey is beautiful like ', '', 'en', NULL),
('5054', '2582', 'LimeSurvey ist wunderbar, weil...', '', 'de-informal', NULL),
('5053', '2581', 'LimeSurvey è il meglio di ', '', 'it', NULL),
('5052', '2581', 'LimeSurvey est meilleur que ', '', 'fr', NULL),
('5051', '2581', 'LimeSurvey is best than ', '', 'en', NULL),
('5050', '2581', 'LimeSurvey ist das Beste, weil...', '', 'de-informal', NULL),
('5049', '2580', 'LimeSurvey è grande perchè', '', 'it', NULL),
('5048', '2580', 'LimeSurvey is great because ', '', 'en', NULL),
('5047', '2580', 'LimeSurvey est excellent parceque ', '', 'fr', NULL),
('5046', '2580', 'LimeSurvey ist toll, weil...', '', 'de-informal', NULL),
('5045', '2579', 'Banane', '', 'it', NULL),
('5044', '2579', 'Bananas', '', 'en', NULL),
('5043', '2579', 'Bananas', '', 'fr', NULL),
('5042', '2579', 'Bananen', '', 'de-informal', NULL),
('5041', '2578', 'Arance', '', 'it', NULL),
('5040', '2578', 'Orangen', '', 'de-informal', NULL),
('5039', '2578', 'Oranges', '', 'fr', NULL),
('5038', '2578', 'Oranges', '', 'en', NULL),
('5037', '2577', 'Mele', '', 'it', NULL),
('5036', '2577', 'Äpfel', '', 'de-informal', NULL),
('5035', '2577', 'Apples', '', 'en', NULL),
('5034', '2577', 'Apples', '', 'fr', NULL),
('5033', '2576', 'Dual-Matrix (Dropdown)', '', 'de-informal', NULL),
('5032', '2576', 'Array con doppia scala (menù dropdown)', '', 'it', NULL),
('5031', '2576', 'Tableau double échelle (Double menu déroulant)', '', 'fr', NULL),
('5030', '2576', 'Array dual scale (dropdown)', '', 'en', NULL),
('5029', '2575', 'Questo è visualizzato solo se nessuna risposta è selezionata. (default)', 'Rilevanza definita con Expression Manager', 'it', NULL),
('5028', '2575', 'Diese Frage wird nur angezeigt, wenn \"keine Antwort\" gewählt wurde (Default).', '', 'de-informal', NULL),
('5027', '2575', 'Ceci est affiché en cas de Non réponse, donc affiché par défaut', 'En utilisant le gestionnaire d\'expression', 'fr', NULL),
('5026', '2575', 'This is displayed only if no answer is checked. (by default)', 'Using Expression manager', 'en', NULL),
('5025', '2574', 'Questo viene visualizzato solo se si seleziona No.', 'Rilevanza definita con Expression Manager', 'it', NULL),
('5024', '2574', 'Diese Frage wird nur angezeigt, wenn zuvor \"Nein\" gewählt wurde.', '', 'de-informal', NULL),
('5023', '2574', 'Ceci est affiché si vous sélectionnez Non', 'En utilisant le gestionnaire d\'expression', 'fr', NULL),
('5022', '2574', 'This is displayed only if you select no.', 'Using Expression Manager', 'en', NULL),
('5021', '2573', 'Questo viene visualizzato solo se si seleziona Sì.', 'Rilevanza definita con Expression Manager', 'it', NULL),
('5020', '2573', 'Diese Frage wird nur angezeigt, wenn zuvor \"Ja\" ausgewählt wurde.', '', 'de-informal', NULL),
('5019', '2573', 'Ceci est affiché uniquement si vous sélectionnez OUI.', 'En utilisant le gestionnaire d\'expression', 'fr', NULL),
('5018', '2573', 'This is displayed only if you select yes.', 'Using Expression manager', 'en', NULL),
('5017', '2572', 'Puoi escludere alcune opzioni in base alla scelta multipla della domanda precedente, usando il Filtro array di esclusione.', '', 'it', NULL),
('5016', '2572', 'Über das Attribut \"Array Filter Exclusion\" werden nur diejenigen Einträge angezeigt, die bei der vorherigen Mehrfachauswahl nicht ausgewählt wurden.', '', 'de-informal', NULL),
('5015', '2572', 'You can exclude some option with Array Filter Exclusion.', '', 'en', NULL),
('5014', '2572', 'Filtre d\'exclusion du tableau avec la question précédente', '', 'fr', NULL),
('5013', '2571', 'Domanda array filtrata dalla domanda precedente.', '', 'it', NULL),
('5012', '2571', 'Antwortoptionen gefiltert auf Basis der Auswahl in der vorherigen Frage.', '', 'de-informal', NULL),
('5011', '2571', 'Filtre de tableau avec la question précédente', '', 'fr', NULL),
('5010', '2571', 'Filtered array with previous question.', '', 'en', NULL),
('5009', '2570', 'Puoi filtrare alcune domande con le opzioni di risposta multipla.', '', 'it', NULL),
('5008', '2570', 'Auf Basis einer Mehrfachauswahl können Optionen in folgenden Fragen gefiltert werden.', '', 'de-informal', NULL),
('5007', '2570', 'Une question à choix multiple permet de filtrer les sous questions suivantes', '', 'fr', NULL),
('5006', '2570', 'You can filter some question with a multi choice option.', '', 'en', NULL),
('5005', '2569', 'Nasconde le domande 1 e 2 anche se hai selezionato \"visualizza\" alla domanda precedente.', '
Questa domanda si visualizza solo se hai scelto di visualizzare le domande 1 o 2
\n', 'it', NULL),
('5004', '2569', 'Verstecke die beiden folgenden Fragen?', 'Diese Frage wird nur angezeigt, wenn bei der vorherigen Frage eine Option gewählt wurde.', 'de-informal', NULL),
('5003', '2569', 'Hide question 1 and 2 even if you select display an previous question.', 'This is displayed only of you choose to display question 1 or question 2.', 'en', NULL),
('5002', '2569', 'Cacher les questions 1 et 2 même si vous avez coché Afficher sur l\'une des questions précédentes.', 'Ceci est affiché uniquement si vous choisissez d\'afficher la question 1 ou 2.', 'fr', NULL),
('5001', '2568', 'Domanda 2: è visualizzata se si seleziona \"Visualizza domanda 2\" in una delle domande precedenti', 'E\' sempre possibile usare un qualsiasi tipo di domanda di LimeSurvey', 'it', NULL),
('5000', '2568', 'Question 2 : displayed if you select Show question 2 at one of previous question.', '', 'en', NULL),
('4999', '2568', 'Question 2 : affichée si vous sélectionner Afficher la question 1 sur l\'une des questions précédentes.', '', 'fr', NULL),
('4998', '2568', 'Frage 2: Wird angezeigt bei entsprechender Auswahl der vorherigen Mehrfachauswahl.', '', 'de-informal', NULL),
('4997', '2567', '
Domanda 1: è visualizzata se si seleziona \"Visualizza domanda 1\" in una delle domande precedenti
\n', '
E\' sempre possibile usare un qualsiasi tipo di domanda di LimeSurvey
\n', 'it', NULL),
('4996', '2567', 'Frage 1: Wird angezeigt bei entsprechender Auswahl der vorherigen Mehrfachauswahl.', '', 'de-informal', NULL),
('4995', '2567', 'Question 1 : displayed if you select Show question 1 at one of previous question', 'Again, you can use all question type of LimeSurvey.', 'en', NULL),
('4994', '2567', 'Question 1 : affichée si vous sélectionner Afficher la question 1 sur l\'une des questions précédentes.', 'N\'importe quel type de question peut être utilisé, ici c\'est une question sans réponse.', 'fr', NULL),
('4993', '2566', 'Viasualizza le domande 1 e 2 con le condizioni.', 'Sono stati usati gli scenari per impostare le condizioni in OR.', 'it', NULL),
('4992', '2566', 'Afficher la question 1 ou 2 selon les conditions', 'Nous utilisons les scénario pour avoir une conditions de type OU.', 'fr', NULL),
('4991', '2566', 'Display question 1 and 2 under condition.', 'We use scenario to have OR condition.', 'en', NULL),
('4990', '2566', 'Zeige Fragen 1 und 2 je nach erfüllter Bedingung.', 'Hier werden Szenarien genutzt, um die Bedingungen mit ODER zu verknüpfen.', 'de-informal', NULL),
('4989', '2565', 'Per condizioni complesse è possibile usare gli Scenari nel pannello delle condizioni.', '', 'it', NULL),
('4988', '2565', 'For complex condition , you can use scenario.', '', 'en', NULL),
('4987', '2565', 'Für komplexe Bedingungen können Szenarien genutzt werden.', '', 'de-informal', NULL),
('4986', '2565', 'Pour des conditions plus complexes , il est possible d\'utiliser les scénarios.', '', 'fr', NULL),
('4985', '2564', 'Questo è visualizzato solo se nessuna risposta è selezionata. (default)', 'E\' possibile usare tutte le tipologie di domanda', 'it', NULL),
('4984', '2564', 'Ceci est affiché en cas de Non réponse, donc affiché par défaut', 'Vous pouvez utiliser tous les types de questions de LimeSurvey', 'fr', NULL),
('4983', '2564', 'This is displayed only if no answer is checked. (by default)', 'You can use all question type of LimeSurvey.', 'en', NULL),
('4981', '2563', 'Questo viene visualizzato solo se si seleziona No.', 'E\' possibile usare tutti i tipi di domanda', 'it', NULL),
('4982', '2564', 'Diese Frage wird nur angezeigt, wenn \"keine Antwort\" gewählt wurde (Default).', '', 'de-informal', NULL),
('4980', '2563', 'Ceci est affiché si vous sélectionnez Non', 'Vous pouvez utiliser tous les types de questions de LimeSurvey', 'fr', NULL),
('4979', '2563', 'This is displayed only if you select no.', 'You can use all question type of LimeSurvey', 'en', NULL),
('4978', '2563', 'Diese Frage wird nur angezeigt, wenn zuvor \"Nein\" gewählt wurde.', '', 'de-informal', NULL),
('4977', '2562', 'Questo viene visualizzato solo se si seleziona Sì.', 'E\' possibile usare tutte le tipologie di domande', 'it', NULL),
('4976', '2562', 'Diese Frage wird nur angezeigt, wenn zuvor \"Ja\" ausgewählt wurde.', '', 'de-informal', NULL),
('4975', '2562', 'This is displayed only if you select yes.', 'You can use all question type of LimeSurvey.', 'en', NULL),
('4974', '2562', 'Ceci est affiché uniquement si vous sélectionnez OUI.', 'Il est possible d\'utiliser tous les types de questions de LimeSurvey.', 'fr', NULL),
('4973', '2561', '
Questa è una domanda Si/No non obbligatoria per nescondere o mostrare la domanda successiva
\n', '', 'it', NULL),
('4972', '2561', 'Eine Ja/Nein Pflichtfrage, die Folgefragen anziegt/versteckt je nach Auswahl.', '', 'de-informal', NULL),
('4971', '2561', 'Une question oui/non pour afficher ou masquer les réponses suivantes', '', 'fr', NULL),
('4970', '2561', 'A Yes/No non mandatory question to show or hide next question.', '', 'en', NULL),
('4969', '2560', 'Domande a scelta multipla con opzione di Classifica', '', 'it', NULL),
('4966', '2560', 'Multichoice question with ranking option', '', 'en', NULL);
INSERT INTO `lime_question_l10ns` (`id`,`qid`,`question`,`help`,`language`,`script`) VALUES
('4967', '2560', 'Réponses multiples avec notion d\'ordre', '', 'fr', NULL),
('4968', '2560', 'Mehrfachauswahl als Ranking-Fragetyp', '', 'de-informal', NULL),
('4960', '2558', 'Ranking (Minimale und maximale Antwortanzahl)', '', 'de-informal', NULL),
('4961', '2558', 'Classifica (risposte minime e massime=2)', '', 'it', NULL),
('4962', '2559', 'Si certaines questions ont les mêmes options, il est possible d\'utiliser un tableau pour représenter les différentes questions.', 'Une question sans réponse', 'fr', NULL),
('4963', '2559', 'If some question have the same option, you can use array to show a question list.', 'A boiler plate question', 'en', NULL),
('4964', '2559', 'Wenn Fragen die gleichen Antwortoptionen nutzen, kann eine Frage vom Typ Array genutzt werden.', 'Ein Textbaustein...', 'de-informal', NULL),
('4965', '2559', '
Se alcune domande hanno le stesse opzioni, puoi usare un array per mostrare la lista di domande.
{GID}{if(self.NAOK gt 3,\"OK great, i do a big thinkgs\",\"What the fuck ?.??\")}
', '', 'en', ''),
('5531', '2705', '
zed
eaz
aze
aze
aze
aze
aze
aze
zea
eza
az
za
zea
zae
eza
zea
zea
zea
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Aenean id lectus vulputate, euismod neque ut, porta massa. Etiam placerat ligula a justo sodales fermentum et vitae ligula. Mauris sapien augue, eleifend quis consequat quis, iaculis ac ex. Vestibulum faucibus molestie urna, a varius lacus pharetra vitae. Pellentesque id ipsum ac nunc rutrum mattis ut sit amet metus. Nunc vestibulum lorem sapien, ac porttitor magna luctus in. Pellentesque pharetra ultrices nulla. Donec id mi justo. Morbi hendrerit quis enim eget condimentum. Donec pretium finibus enim vitae vulputate. Maecenas et diam urna. Sed tristique risus lobortis enim mattis vulputate. Aenean a rhoncus lectus. Nulla scelerisque in arcu eu congue. Duis varius dui id mauris luctus, imperdiet finibus nulla ultrices. Vivamus gravida, ligula id lobortis dapibus, nunc ex egestas ligula, ac pretium massa nulla nec tellus.
Praesent pulvinar justo quis elit ornare, non egestas lectus tincidunt. Donec blandit gravida lorem, at fermentum elit rhoncus ut. Etiam ornare blandit justo, at elementum ligula hendrerit sit amet. Proin enim enim, tincidunt sit amet felis non, tincidunt mattis mauris. Proin finibus tincidunt magna, malesuada vulputate lectus. Maecenas mauris sem, consequat sed porta at, laoreet sodales quam. Nullam faucibus egestas neque, eu molestie augue. Nullam fermentum pretium luctus. Vivamus imperdiet, augue at efficitur iaculis, augue mi tempus libero, sed aliquet ipsum dolor in diam. Nullam vel vehicula magna, vel molestie diam. Nulla ac libero justo. Suspendisse non semper enim. Maecenas sed sodales mauris, nec tempus purus.
Suspendisse potenti. Etiam porta felis in dui consectetur, vel vehicula tellus blandit. Ut id commodo urna. Integer egestas hendrerit convallis. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus non urna at est dignissim blandit vel congue purus. Sed vel ultrices nibh.
', '', 'en', ''),
('5537', '2711', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('5538', '2712', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', NULL),
('5539', '2713', 'Some example subquestion', '', 'en', NULL),
('5578', '2752', 'Last subquestion', '', 'en', NULL),
('5577', '2751', 'Third subquestion', '', 'en', NULL),
('5576', '2750', 'New answer subquestion', '', 'en', NULL),
('5543', '2717', 'Last subquestion', '', 'en', NULL),
('5544', '2718', 'Third subquestion', '', 'en', NULL),
('5545', '2719', 'New answer subquestion', '', 'en', NULL),
('5546', '2720', 'Some example subquestion', '', 'en', NULL),
('5547', '2721', 'How many answer at total for next question. Entre a big value to see next question.', 'Already {statCount(self.sgqa)} answer in this question and {statCount(Q01.sgqa)} in next question', 'en', ''),
('5548', '2722', 'Condition is Q00.NAOK > statCount(\"Q01\"), current is {statCount(Q01.sgqa)}, with not submitted {statCount(Q01.sgqa,0)}', '', 'en', ''),
('5549', '2723', 'Did you participate to this events : ', '
Array filter style : disable
', 'en', ''),
('5550', '2724', 'Event #1 (still {10 - statCountIf(Q03_SQ001.sgqa,\'Y\')} places)', '', 'en', NULL),
('5551', '2725', 'Event #2 (still {5 - statCountIf(Q03_SQ002.sgqa,\'Y\')} places)', '', 'en', NULL),
('5552', '2726', 'Event #2 (still {2 - statCountIf(Q03_SQ003.sgqa,\'Y\')} places)', '', 'en', NULL),
('5553', '2727', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('5554', '2728', 'Hide next group and question', '', 'en', NULL),
('5555', '2729', 'Hide next question', '', 'en', NULL),
('5556', '2730', 'Not hidden', '', 'en', NULL),
('5557', '2731', 'Hidden by Q01', '', 'en', NULL),
('5558', '2732', 'Hidden by Q02', '', 'en', NULL),
('5559', '2733', 'Hidden by G2Q01', '', 'en', NULL),
('5560', '2734', 'Hide sub question', '', 'en', NULL),
('5561', '2735', 'Array filter', '', 'en', NULL),
('5562', '2736', 'Hidden by Q01', '', 'en', NULL),
('5563', '2737', 'Hidden by Q01, Sub question hidden by Q03', '', 'en', NULL),
('5564', '2738', 'Hidden by Q01, filter by Q04', '', 'en', NULL),
('5565', '2739', 'SQ001', '', 'en', NULL),
('5566', '2740', 'SQ002', '', 'en', NULL),
('5567', '2741', 'SQ001', '', 'en', NULL),
('5568', '2742', 'SQ002', '', 'en', NULL),
('5569', '2743', 'SQ001', '', 'en', NULL),
('5570', '2744', 'SQ002', '', 'en', NULL),
('5571', '2745', 'SQ003 not in Q04', '', 'en', NULL),
('5572', '2746', 'SQ003', '', 'en', NULL),
('5579', '2753', '', '', 'en', ''),
('5580', '2754', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('5581', '2755', '
Crypted data
', '', 'en', ''),
('5582', '2756', 'A first example question. Please answer this question:', 'This is a question help text.', 'en', ''),
('5583', '2757', '', '', 'fr', 'alert(\"XSS\");\nalert(\"dee\");'),
('5584', '2758', 'A first example question. Please answer this question:', '', 'en', ''),
('5595', '2769', 'Float ( 42.42)', '', 'en', NULL),
('5624', '2798', 'Negative float : (-3.5)', '', 'en', NULL),
('5621', '2795', 'Text (LimeSurvey)', '', 'en', NULL),
('5622', '2796', 'Float followed by text (42.42LimeSurvey)', '', 'en', NULL),
('5623', '2797', 'Float followed by operation (+42.42 + 33)', '', 'en', NULL),
('5594', '2768', '
Vous avez été invité à participer à un questionnaire.
Celui-ci est intitulé : \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
Pour participer, veuillez cliquer sur le lien ci-dessous.
Cordialement,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Cliquez ici pour remplir ce questionnaire : {SURVEYURL}
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant : {OPTOUTURL}', 'Rappel pour participer à un questionnaire', 'Cher(e) {FIRSTNAME},
Vous avez été invité à participer à un questionnaire récemment.
Nous avons pris en compte que vous n\'avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.
Le questionnaire est intitulé : \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
Pour participer, veuillez cliquer sur le lien ci-dessous.
Cordialement,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Cliquez ici pour faire le questionnaire: {SURVEYURL}
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant : {OPTOUTURL}', 'Confirmation d\'enregistrement au questionnaire', 'Cher(e){FIRSTNAME},
Vous (ou quelqu\'un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.
Pour compléter ce questionnaire, cliquez sur le lien suivant :
{SURVEYURL}
Si vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce courriel est une erreur, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}', 'Confirmation de votre participation à notre questionnaire', 'Cher(e) {FIRSTNAME},
Ce courriel vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.
Si vous avez des questions à propos de ce courriel, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}.
Cordialement,
{ADMINNAME}', '1', NULL, 'Soumission de réponse pour le questionnaire {SURVEYNAME}', 'Bonjour,
Une nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.
Cliquer sur le lien suivant pour recharger votre questionnaire : {RELOADURL}
Cliquer sur le lien suivant pour voir la réponse : {VIEWRESPONSEURL}
Cliquer sur le lien suivant pour éditer la réponse : {EDITRESPONSEURL}
Visualiser les statistiques en cliquant ici : {STATISTICSURL}
les réponses suivantes ont été données par le participant : {ANSWERTABLE}', 'Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats', 'Bonjour,
Une nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.
Cliquer sur le lien suivant pour recharger votre questionnaire : {RELOADURL}
Cliquer sur le lien suivant pour voir la réponse : {VIEWRESPONSEURL}
Cliquez sur le lien suivant pour éditer la réponse individuelle : {EDITRESPONSEURL}
Visualiser les statistiques en cliquant ici : {STATISTICSURL}
les réponses suivantes ont été données par le participant : {ANSWERTABLE}', '1', NULL),
('953473', 'en', 'Must not add all lines', '', '', '', '', '', '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME}, \n \nyou have been invited to participate in a survey. \n SID : {SID}\nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL} \n \nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: \n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n SID : {SID}\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', '\"\"'),
('454883', 'en', 'Line can be hidden', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('937358', 'en', 'countFunctions test', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('628525', 'en', 'countFunctions test', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME}, \n \nyou have been invited to participate in a survey. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL} \n \nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: \n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n \nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', NULL),
('152176', 'en', 'Check default values', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('485593', 'en', 'Answer order', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('944142', 'en', 'Check Testing Quick', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('963358', 'en', 'Check sub questions relevance', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('737773', 'en', 'count survey without count', '', '', '', '', '', '', '', '', 'Invitation to participate in a survey', '
Dear {FIRSTNAME},
you have been invited to participate in a survey.
The survey is titled: \"{SURVEYNAME}\" {SID}
\"{SURVEYDESCRIPTION}\"
To participate, please click on the link below.
Sincerely,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Click here to do the survey: {SURVEYURL}
If you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: {OPTOUTURL}
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: {OPTINURL}
', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n \nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', '\"\"'),
('282267', 'de-informal', 'Beispielfragebogen für Limesurvey EN/FR/DE', '
Dies ist die Willkommensnachricht des Fragebogens. Sie kann unter Fragebogeneinstellungen -> Texte angepasst werden.
\n', 'Dieser Beispielfragebogen demonstriert alle in Limesurvey vorhanden Fragetypen sowie zusätzliche Frageoptionen.', '', '', '', '', 'http://www.limesurvey.org', '', 'Einladung zur einer Umfrage', 'Hallo {FIRSTNAME},\n\nHiermit möchten wir dich zu einer Umfrage einladen.\n\nDer Titel der Umfrage ist \n\'{SURVEYNAME}\'\n\n\'{SURVEYDESCRIPTION}\'\n\nUm an dieser Umfrage teilzunehmen, klicke bitte auf den unten stehenden Link.\n\nMit freundlichen Grüßen,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nKlicke hier um die Umfrage zu starten:\n{SURVEYURL}\n\nWenn Du an dieser Umfrage nicht teilnehmen und keine weiteren Erinnerungen erhalten möchtest, klicke bitte auf den folgenden Link:\n{OPTOUTURL}', 'Erinnerung an die Teilnahme an einer Umfrage', 'Hallo {FIRSTNAME},\n\nVor kurzem haben wir Dich zu einer Umfrage eingeladen.\n\nZu unserem Bedauern haben wir bemerkt, dass Du die Umfrage noch nicht ausgefüllt hast. Wir möchten Dir mitteilen, dass die Umfrage noch aktiv ist und würden uns freuen, wenn Du teilnehmen könntest.\n\nDer Titel der Umfrage ist \n\'{SURVEYNAME}\'\n\n\'{SURVEYDESCRIPTION}\'\n\nUm an dieser Umfrage teilzunehmen, klicke bitte auf den unten stehenden Link.\n\n Mit freundlichen Grüßen,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nKlicken Du hier um die Umfrage zu starten:\n{SURVEYURL}\n\nWenn Du an dieser Umfrage nicht teilnehmen und keine weiteren Erinnerungen erhalten möchtest, klicke bitte auf den folgenden Link:\n{OPTOUTURL}', 'Registrierungsbestätigung für Teilnahmeumfrage', 'Hallo {FIRSTNAME},\n\nDu (oder jemand, der Deine E-Mail benutzt hat) hat sich für eine Umfrage mit dem Titel {SURVEYNAME} angemeldet.\n\nUm an dieser Umfrage teilzunehmen, klicke bitte auf den folgenden Link.nn{SURVEYURL}\n\nWenn Du irgendwelche Fragen zu dieser Umfrage hast oder wenn Du Dich _nicht_ für diese Umfrage angemeldet hast und Du glaubst, dass Dir diese E-Mail irrtümlicherweise zugeschickt worden ist, kontaktiere bitte {ADMINNAME} unter {ADMINEMAIL}.', 'Bestätigung für die Teilnahme an unserer Umfrage', 'Hallo {FIRSTNAME},\n\nVielen Dank für die Teilnahme an der Umfrage mit dem Titel {SURVEYNAME}. Deine Antworten wurden bei uns gespeichert.\n\nWenn du irgendwelche Fragen zu dieser E-Mail hast, kontaktiere bitte {ADMINNAME} unter {ADMINEMAIL}.\n\nMit freundlichen Grüßen,\n\n{ADMINNAME}', '1', NULL, 'Antwortabsendung für Umfrage {SURVEYNAME}', 'Hallo,\n\nEine neue Antwort wurde für die Umfrage \'{SURVEYNAME}\' abgegeben.\n\nKlicke auf den folgenden Link um die Umfrage neu zu laden:\n{RELOADURL}\n\nKlicke auf den folgenden Link um den Antwortdatensatz anzusehen:\n{VIEWRESPONSEURL}\n\nKlicke auf den folgenden Link um den Antwortdatensatz zu bearbeiten:\n{EDITRESPONSEURL}\n\nUm die Statistik zu sehen, klicke hier:\n{STATISTICSURL}', 'Antwortabsendung für Umfrage %s', 'Hallo,\n\nEine neue Antwort wurde für die Umfrage \'{SURVEYNAME}\' abgegeben.\n\nKlicke auf den folgenden Link um die Umfrage neu zu laden:\n{RELOADURL}\n\nKlicke auf den folgenden Link um den Antwortdatensatz anzusehen:\n{VIEWRESPONSEURL}\n\nKlicke auf den folgenden Link um den Antwortdatensatz zu bearbeiten:\n{EDITRESPONSEURL}\n\nUm die Statistik zu sehen, klicke hier:\n{STATISTICSURL}\n\n\nDie folgenden Antworten wurden vom Teilnehmer gegeben:\n{ANSWERTABLE}', '0', NULL),
('282267', 'en', 'Sample LimeSurvey EN/FR/DE/IT', '
This is the welcome text for the survey!
You can can edit it in the survey properties.
', 'This survey show all question type of LimeSurvey with some option', '
This is the end message for the survey! A good place to thank you to answer to this survey.
\n', '', '', '', 'http://www.limesurvey.org', 'The end URL description of your survey. This URL can be automatically load when survey is completed.', 'Invitation to participate in survey', 'Dear {FIRSTNAME},
You have been invited to participate in a survey.
The survey is titled: \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
To participate, please click on the link below.
Sincerely,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Click here to do the survey: {SURVEYURL}
If you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: {OPTOUTURL}', 'Reminder to participate in survey', 'Dear {FIRSTNAME},
Recently we invited you to participate in a survey.
We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.
The survey is titled: \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
To participate, please click on the link below.
Sincerely,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Click here to do the survey: {SURVEYURL}
If you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: {OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.
To complete this survey, click on the following URL:
{SURVEYURL}
If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of completed survey', 'Dear {FIRSTNAME},
This email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.
If you have any further questions about this email, please contact {ADMINNAME} at {ADMINEMAIL}.
Sincerely,
{ADMINNAME}', '5', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to reload the survey: \n{RELOADURL} \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to reload the survey: \n{RELOADURL} \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', NULL),
('282267', 'fr', 'Exemple de questionnaire EN/FR/DE', '
Ceci est le message d\'accueil de votre sondage !!
Vous pouvez l\'éditer dans les paramètres du questionnaire.
', '
Ce sondage montre toutes les types de questions de LimeSurvey et quelques options.
', '
Ceci est le message de fin de votre questionnaire ! Un bon endroit pour vous remercier d\'avoir répondu à ce questionnaire.
', '', '', '', 'http://www.limesurvey.org', 'La description de l\'URL de fin, ce sondage est distribué sous Licence GPL', 'Invitation à participer à un questionnaire', 'Cher(e) {FIRSTNAME},
Vous avez été invité à participer à un questionnaire.
Celui-ci est intitulé : \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
Pour participer, veuillez cliquer sur le lien ci-dessous.
Cordialement,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Cliquez ici pour remplir ce questionnaire : {SURVEYURL}
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant : {OPTOUTURL}', 'Rappel pour participer à un questionnaire', 'Cher(e) {FIRSTNAME},
Vous avez été invité à participer à un questionnaire récemment.
Nous avons pris en compte que vous n\'avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.
Le questionnaire est intitulé : \"{SURVEYNAME}\"
\"{SURVEYDESCRIPTION}\"
Pour participer, veuillez cliquer sur le lien ci-dessous.
Cordialement,
{ADMINNAME} ({ADMINEMAIL})
---------------------------------------------- Cliquez ici pour faire le questionnaire: {SURVEYURL}
Si vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant : {OPTOUTURL}', 'Confirmation de l\'inscription au questionnaire', 'Cher(e){FIRSTNAME},
Vous (ou quelqu\'un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.
Pour compléter ce questionnaire, cliquez sur le lien suivant :
{SURVEYURL}
Si vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce courriel est une erreur, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}', 'Confirmation de questionnaire complété', 'Cher(e) {FIRSTNAME},
Ce courriel vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.
Si vous avez des questions à propos de ce courriel, veuillez contacter {ADMINNAME} sur {ADMINEMAIL}.
Cordialement,
{ADMINNAME}', '5', NULL, 'Soumission de réponse pour le questionnaire {SURVEYNAME}', 'Bonjour, \n \nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'. \n \nCliquer sur le lien suivant pour recharger votre questionnaire : \n{RELOADURL} \n \nCliquer sur le lien suivant pour voir la réponse : \n{VIEWRESPONSEURL} \n \nCliquer sur le lien suivant pour éditer la réponse : \n{EDITRESPONSEURL} \n \nVisualiser les statistiques en cliquant ici : \n{STATISTICSURL} \n \nles réponses suivantes ont été données par le participant : \n{ANSWERTABLE}', 'Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats', 'Bonjour, \n \nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'. \n \nCliquer sur le lien suivant pour recharger votre questionnaire : \n{RELOADURL} \n \nCliquer sur le lien suivant pour voir la réponse : \n{VIEWRESPONSEURL} \n \nCliquez sur le lien suivant pour éditer la réponse individuelle : \n{EDITRESPONSEURL} \n \nVisualiser les statistiques en cliquant ici : \n{STATISTICSURL} \n \n \nles réponses suivantes ont été données par le participant : \n{ANSWERTABLE}', '1', NULL),
('282267', 'it', 'Sample LimeSurvey EN/FR/DE/IT', '
Questo è il messaggio di benvenuto dell\'indagine!!!
E\' possibile modificarlo nelle impostazioni di indagine
', '
Questa indagine presenta tutti i tipi di domanda di LimeSurvey con alcune opzioni aggiuntive
', '
Questo è il messaggio di chiusura dell\'indagine, dopo che il rispondente ha premuto INVIA.
E\' possibile modificarlo nelle impostazioni di indagine
', 'Questo è il messaggio sui termini dei dati dell\'indagine', 'Questo è il messaggio di errore sui termini dei dati dell\'indagine', 'Questa etichetta spiega i termini dei dati di indagine', '', '', 'Invito per partecipare all\'indagine', 'Egregio/a {FIRSTNAME}, \n \nè invitato a partecipare ad un\'indagine on line. \n \nL\'indagine è intitolata: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nPer partecipare fare click sul link in basso. \n \nCordiali saluti,{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nFare click qui per accedere al questionario e rispondere alle domande relative: \n{SURVEYURL} \n \nSe non si intende partecipare a questa indagine e non si vogliono ricevere altri inviti, si può cliccare sul seguente collegamento: \n{OPTOUTURL} \n \nSe è presente in blacklist ma vuole partecipare a questa indagine e ricevere inviti, vada al seguente link: \n{OPTINURL}', 'Promemoria per partecipare all\'indagine', 'Egregio/a {FIRSTNAME}, \nRecentemente ha ricevuto un invito a partecipare ad un\'indagine on line. \n \nAbbiamo notato che non ha ancora completato il questionario. Con l\'occasione Le ricordiamo che il questionario è ancora disponibile. \n \nL\'indagine è intitolata: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nPer partecipare fare clic sul link qui sotto. \n \nCordiali saluti, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nFare clic qui per accedere all\'indagine e rispondere al questionario: \n{SURVEYURL} \n \nSe non si intende partecipare a questa indagine e non si vogliono ricevere altri inviti, si può cliccare sul seguente collegamento: \n{OPTOUTURL}', 'Conferma di registrazione all\'indagine', 'Egregio/a {FIRSTNAME}, \n \nLei (o qualcuno che ha utilizzato il suo indirizzo e-mail) si è registrato per partecipare all\'indagine on line intitolata {SURVEYNAME}. \n \nPer completare il questionario fare clic sul seguente indirizzo: \n \n{SURVEYURL} \n \nSe ha qualche domanda, o se non si è registrato e ritiene che questa e-mail ti sia pervenuta per errore, la preghiamo di contattare {ADMINNAME} all\'indirizzo {ADMINEMAIL}.', 'Confermare la partecipazione all'indagine', 'Egregio/a {FIRSTNAME}, \n \nQuesta e-mail le è stata inviata per confermarle che ha completato correttamente il questionario intitolato {SURVEYNAME} e che le sue risposte sono state salvate. Grazie per la partecipazione. \n \nSe ha ulteriori domande circa questo messaggio, la prego di contattare {ADMINNAME} all\'indirizzo e-mail {ADMINEMAIL}. \n \nCordiali saluti \n \n{ADMINNAME}', '5', NULL, 'Invio di una risposta all\'indagine {SURVEYNAME}', 'Salve, \n \nUna nuova risposta é stata inviata per l\'indagine \'{SURVEYNAME}\'. \n \nFare click sul link seguente per vedere le risposte individuali: \n{VIEWRESPONSEURL} \n \nFare click sul link seguente per modificare le risposte individuali: \n{EDITRESPONSEURL} \n \nFare clic sul link seguente per visualizzare le statistiche: \n{STATISTICSURL}', 'Invio di una risposta all\'indagine {SURVEYNAME} con risultati', 'Salve, \n \nUna nuova risposta è stata inviata dall\'indagine \'{SURVEYNAME}\'. \n \nFare clic sul link seguente per vedere la risposta individuale: \n{VIEWRESPONSEURL} \n \nFare clic sul link seguente per modificare la risposta individuale: \n{EDITRESPONSEURL} \n \nFare clic sul link seguente per visualizzare le statistiche: \n{STATISTICSURL} \n \n \nLe seguenti risposte sono state date dal partecipante: \n{ANSWERTABLE}', '0', NULL),
('218495', 'en', 'organizeSurvey test survey', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('826659', 'en', 'Check filter', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME}, \n \nyou have been invited to participate in a survey. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL} \n \nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: \n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n \nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', NULL),
('823512', 'en', 'countFunctions test', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME}, \n \nyou have been invited to participate in a survey. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL} \n \nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: \n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n \nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', NULL),
('992119', 'en', 'Test', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('247399', 'en', 'ddddd', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('892498', 'en', 'Test Preview GROUP and QUESTION', '', '', '', NULL, NULL, NULL, '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME}, \n \nyou have been invited to participate in a survey. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL} \n \nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link: \n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME}, \n \nRecently we invited you to participate in a survey. \n \nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part. \n \nThe survey is titled: \n\"{SURVEYNAME}\" \n \n\"{SURVEYDESCRIPTION}\" \n \nTo participate, please click on the link below. \n \nSincerely, \n \n{ADMINNAME} ({ADMINEMAIL}) \n \n---------------------------------------------- \nClick here to do the survey: \n{SURVEYURL} \n \nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link: \n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME}, \n \nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}. \n \nTo complete this survey, click on the following URL: \n \n{SURVEYURL} \n \nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME}, \n \nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating. \n \nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}. \n \nSincerely, \n \n{ADMINNAME}', '1', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello, \n \nA new response was submitted for your survey \'{SURVEYNAME}\'. \n \nClick the following link to see the individual response: \n{VIEWRESPONSEURL} \n \nClick the following link to edit the individual response: \n{EDITRESPONSEURL} \n \nView statistics by clicking here: \n{STATISTICSURL} \n \n \nThe following answers were given by the participant: \n{ANSWERTABLE}', '0', NULL),
('275719', 'en', 'TEST', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', '', 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('445479', 'en', 'qqqq', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL),
('137892', 'fr', 'Check XSS user', '', '', '', '', '', '', '', '', 'Invitation à participer à un questionnaire', 'Cher(e) {FIRSTNAME},\n\nVous avez été invité(e) à participer à un questionnaire.\n\nCelui-ci est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour remplir ce questionnaire :\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}\n\nSi vous êtes sur liste noire mais que vous voulez participer à ce questionnaire et recevoir les invitations, merci de cliquer sur le lien suivant :\n{OPTINURL}', 'Rappel pour participer à un questionnaire', 'Cher(e) {FIRSTNAME},\n\nVous avez été invité(e) à participer à un questionnaire récemment.\n\nNous avons pris en compte que vous n’avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.\n\nLe questionnaire est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour faire le questionnaire :\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}', 'Confirmation d’enregistrement pour le questionnaire', 'Bonjour {FIRSTNAME},\n\nVous (ou quelqu’un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.\n\nPour compléter ce questionnaire, cliquez sur le lien suivant :\n{SURVEYURL}\n\nSi vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce message est une erreur, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}', 'Confirmation de votre participation à notre questionnaire', 'Bonjour {FIRSTNAME},\n\nCe message vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.\n\nSi vous avez des questions à propos de ce message, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}.\n\nCordialement,\n\n{ADMINNAME}', '9', NULL, 'Soumission de réponse pour le questionnaire {SURVEYNAME}', 'Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquez sur le lien suivant pour voir la réponse :\n{VIEWRESPONSEURL}\n\nCliquez sur le lien suivant pour éditer la réponse :\n{EDITRESPONSEURL}\n\nVisualisez les statistiques en cliquant ici :\n{STATISTICSURL}', 'Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats', 'Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquez sur le lien suivant pour voir cette réponse :\n{VIEWRESPONSEURL}\n\nCliquez sur le lien suivant pour éditer cette réponse individuelle :\n{EDITRESPONSEURL}\n\nVisualisez les statistiques en cliquant ici :\n{STATISTICSURL}\n\n\nLes réponses suivantes ont été données par le participant :\n{ANSWERTABLE}', '0', NULL),
('768158', 'fr', 'Check XSS user', '
Test
I want include uploaded image :
', '', '', '', '', '', '', '', 'Invitation à participer à un questionnaire', 'Cher(e) {FIRSTNAME},\n\nVous avez été invité(e) à participer à un questionnaire.\n\nCelui-ci est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour remplir ce questionnaire :\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}\n\nSi vous êtes sur liste noire mais que vous voulez participer à ce questionnaire et recevoir les invitations, merci de cliquer sur le lien suivant :\n{OPTINURL}', 'Rappel pour participer à un questionnaire', 'Cher(e) {FIRSTNAME},\n\nVous avez été invité(e) à participer à un questionnaire récemment.\n\nNous avons pris en compte que vous n’avez pas encore complété le questionnaire, et nous vous rappelons que celui-ci est toujours disponible si vous souhaitez participer.\n\nLe questionnaire est intitulé :\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nPour participer, veuillez cliquer sur le lien ci-dessous.\n\nCordialement,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nCliquez ici pour faire le questionnaire :\n{SURVEYURL}\n\nSi vous ne souhaitez pas participer à ce questionnaire et ne souhaitez plus recevoir aucune invitation, veuillez cliquer sur le lien suivant :\n{OPTOUTURL}', 'Confirmation d’enregistrement pour le questionnaire', 'Bonjour {FIRSTNAME},\n\nVous (ou quelqu’un utilisant votre adresse électronique) vous êtes enregistré pour participer à un questionnaire en ligne intitulé {SURVEYNAME}.\n\nPour compléter ce questionnaire, cliquez sur le lien suivant :\n{SURVEYURL}\n\nSi vous avez des questions à propos de ce questionnaire, ou si vous ne vous êtes pas enregistré pour participer à celui-ci et croyez que ce message est une erreur, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}', 'Confirmation de votre participation à notre questionnaire', 'Bonjour {FIRSTNAME},\n\nCe message vous confirme que vous avez complété le questionnaire intitulé {SURVEYNAME} et que votre réponse a été enregistrée. Merci pour votre participation.\n\nSi vous avez des questions à propos de ce message, veuillez contacter {ADMINNAME} à l’adresse {ADMINEMAIL}.\n\nCordialement,\n\n{ADMINNAME}', '9', NULL, 'Soumission de réponse pour le questionnaire {SURVEYNAME}', 'Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquez sur le lien suivant pour voir la réponse :\n{VIEWRESPONSEURL}\n\nCliquez sur le lien suivant pour éditer la réponse :\n{EDITRESPONSEURL}\n\nVisualisez les statistiques en cliquant ici :\n{STATISTICSURL}', 'Soumission de réponse pour le questionnaire {SURVEYNAME} avec résultats', 'Bonjour,\n\nUne nouvelle réponse a été soumise pour votre questionnaire \'{SURVEYNAME}\'.\n\nCliquez sur le lien suivant pour voir cette réponse :\n{VIEWRESPONSEURL}\n\nCliquez sur le lien suivant pour éditer cette réponse individuelle :\n{EDITRESPONSEURL}\n\nVisualisez les statistiques en cliquant ici :\n{STATISTICSURL}\n\n\nLes réponses suivantes ont été données par le participant :\n{ANSWERTABLE}', '0', NULL),
('769299', 'en', 'Test intval and floatval', '', '', '', '', NULL, '', '', '', 'Invitation to participate in a survey', 'Dear {FIRSTNAME},\n\nyou have been invited to participate in a survey.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}\n\nIf you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:\n{OPTINURL}', 'Reminder to participate in a survey', 'Dear {FIRSTNAME},\n\nRecently we invited you to participate in a survey.\n\nWe note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.\n\nThe survey is titled:\n\"{SURVEYNAME}\"\n\n\"{SURVEYDESCRIPTION}\"\n\nTo participate, please click on the link below.\n\nSincerely,\n\n{ADMINNAME} ({ADMINEMAIL})\n\n----------------------------------------------\nClick here to do the survey:\n{SURVEYURL}\n\nIf you do not want to participate in this survey and don\'t want to receive any more invitations please click the following link:\n{OPTOUTURL}', 'Survey registration confirmation', 'Dear {FIRSTNAME},\n\nYou, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.\n\nTo complete this survey, click on the following URL:\n\n{SURVEYURL}\n\nIf you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.', 'Confirmation of your participation in our survey', 'Dear {FIRSTNAME},\n\nthis email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.\n\nIf you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.\n\nSincerely,\n\n{ADMINNAME}', '9', NULL, 'Response submission for survey {SURVEYNAME}', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}', 'Response submission for survey {SURVEYNAME} with results', 'Hello,\n\nA new response was submitted for your survey \'{SURVEYNAME}\'.\n\nClick the following link to see the individual response:\n{VIEWRESPONSEURL}\n\nClick the following link to edit the individual response:\n{EDITRESPONSEURL}\n\nView statistics by clicking here:\n{STATISTICSURL}\n\n\nThe following answers were given by the participant:\n{ANSWERTABLE}', '0', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_template_configuration`
--
DROP TABLE IF EXISTS `lime_template_configuration`;
CREATE TABLE `lime_template_configuration` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`template_name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`sid` int(11) DEFAULT NULL,
`gsid` int(11) DEFAULT NULL,
`uid` int(11) DEFAULT NULL,
`files_css` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`files_js` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`files_print_css` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`options` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cssframework_name` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cssframework_css` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`cssframework_js` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`packages_to_load` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`packages_ltr` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`packages_rtl` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `lime_idx1_template_configuration` (`template_name`),
KEY `lime_idx2_template_configuration` (`sid`),
KEY `lime_idx3_template_configuration` (`gsid`),
KEY `lime_idx4_template_configuration` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_template_configuration`
--
INSERT INTO `lime_template_configuration` (`id`,`template_name`,`sid`,`gsid`,`uid`,`files_css`,`files_js`,`files_print_css`,`options`,`cssframework_name`,`cssframework_css`,`cssframework_js`,`packages_to_load`,`packages_ltr`,`packages_rtl`) VALUES
('1', 'vanilla', NULL, NULL, NULL, '{\"add\":[\"css/ajaxify.css\",\"css/theme.css\",\"css/custom.css\"]}', '{\"add\":[\"scripts/theme.js\",\"scripts/ajaxify.js\",\"scripts/custom.js\"]}', '{\"add\":[\"css/print_theme.css\"]}', '{\"ajaxmode\":\"off\",\"brandlogo\":\"on\",\"container\":\"off\",\"hideprivacyinfo\":\"off\",\"brandlogofile\":null,\"font\":\"noto\",\"animatebody\":\"off\",\"showpopups\":\"0\",\"showclearall\":\"on\",\"questionhelptextposition\":\"top\",\"fixnumauto\":\"enable\"}', 'bootstrap', '{}', '', '{\"add\":[\"pjax\",\"font-noto\",\"moment\"]}', NULL, NULL),
('2', 'fruity', NULL, NULL, NULL, '{\"add\":[\"css/ajaxify.css\",\"css/animate.css\",\"css/variations/sea_green.css\",\"css/theme.css\",\"css/custom.css\"]}', '{\"add\":[\"scripts/theme.js\",\"scripts/ajaxify.js\",\"scripts/custom.js\"]}', '{\"add\":[\"css/print_theme.css\"]}', '{\"ajaxmode\":\"on\",\"brandlogo\":\"on\",\"brandlogofile\":\"./files/logo.png\",\"container\":\"on\",\"backgroundimage\":\"off\",\"backgroundimagefile\":null,\"animatebody\":\"off\",\"bodyanimation\":\"fadeInRight\",\"bodyanimationduration\":\"500\",\"animatequestion\":\"off\",\"questionanimation\":\"flipInX\",\"questionanimationduration\":\"500\",\"animatealert\":\"off\",\"alertanimation\":\"shake\",\"alertanimationduration\":\"500\",\"font\":\"noto\",\"bodybackgroundcolor\":\"#ffffff\",\"fontcolor\":\"#444444\",\"questionbackgroundcolor\":\"#ffffff\",\"questionborder\":\"on\",\"questioncontainershadow\":\"on\",\"checkicon\":\"f00c\",\"animatecheckbox\":\"on\",\"checkboxanimation\":\"rubberBand\",\"checkboxanimationduration\":\"500\",\"animateradio\":\"on\",\"radioanimation\":\"zoomIn\",\"radioanimationduration\":\"500\",\"zebrastriping\":\"off\",\"stickymatrixheaders\":\"off\",\"greyoutselected\":\"off\",\"hideprivacyinfo\":\"off\",\"crosshover\":\"off\",\"showpopups\":\"1\"}', 'bootstrap', '{}', '', '{\"add\":[\"pjax\",\"font-noto\",\"moment\"]}', NULL, NULL),
('3', 'bootswatch', NULL, NULL, NULL, '{\"add\":[\"css/ajaxify.css\",\"css/theme.css\",\"css/custom.css\"]}', '{\"add\":[\"scripts/theme.js\",\"scripts/ajaxify.js\",\"scripts/custom.js\"]}', '{\"add\":[\"css/print_theme.css\"]}', '{\"ajaxmode\":\"on\",\"brandlogo\":\"on\",\"container\":\"on\",\"brandlogofile\":\"./files/logo.png\"}', 'bootstrap', '{\"replace\":[[\"css/bootstrap.css\",\"css/variations/flatly.min.css\"]]}', '', '{\"add\":[\"pjax\",\"font-noto\",\"moment\"]}', NULL, NULL),
('4', 'fruity', '38345', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"bodybackgroundcolor\":\"inherit\",\"fontcolor\":\"inherit\",\"questionbackgroundcolor\":\"inherit\",\"checkicon\":\"inherit\",\"backgroundimagefile\":\"inherit\",\"brandlogofile\":\"inherit\",\"bodyanimation\":\"inherit\",\"bodyanimationduration\":\"inherit\",\"questionanimation\":\"inherit\",\"questionanimationduration\":\"inherit\",\"alertanimation\":\"inherit\",\"alertanimationduration\":\"inherit\",\"checkboxanimation\":\"inherit\",\"checkboxanimationduration\":\"inherit\",\"radioanimation\":\"inherit\",\"radioanimationduration\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"questionborder\":\"inherit\",\"questioncontainershadow\":\"inherit\",\"showpopups\":\"inherit\",\"zebrastriping\":\"inherit\",\"stickymatrixheaders\":\"inherit\",\"greyoutselected\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"crosshover\":\"inherit\",\"backgroundimage\":\"inherit\",\"brandlogo\":\"inherit\",\"animatebody\":\"inherit\",\"animatequestion\":\"inherit\",\"animatealert\":\"inherit\",\"animatecheckbox\":\"inherit\",\"animateradio\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('5', 'fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('6', 'fruity', '83948', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('7', 'fruity', '647542', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('8', 'fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('9', 'fruity', '23627', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('10', 'fruity', '812357', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('11', 'fruity', '945457', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('12', 'fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('13', 'vanilla', '647542', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('14', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('15', 'fruity', '241216', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('16', 'fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('17', 'fruity', '476281', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('18', 'extends_fruity', NULL, NULL, NULL, '{\"add\":[\"css\\/variations\\/sea_green.css\"],\"remove\":[\"css\\/noTablesOnMobile.css\"],\"replace\":[\"css\\/animate.css\",\"css\\/theme.css\",\"css\\/custom.css\"]}', '{\"replace\":[\"scripts\\/theme.js\",\"scripts\\/ajaxify.js\",\"scripts\\/custom.js\"]}', '{\"replace\":[\"css\\/print_theme.css\"]}', '{\"comment\":[{},{},{},{},{}],\"ajaxmode\":\"on\",\"container\":\"on\",\"zebrastriping\":\"off\",\"stickymatrixheaders\":\"off\",\"greyoutselected\":\"off\",\"hideprivacyinfo\":\"off\",\"crosshover\":\"off\",\"showpopups\":\"1\",\"notables\":\"1\",\"showclearall\":\"off\",\"questionhelptextposition\":\"top\",\"fixnumauto\":\"off\",\"questionborder\":\"on\",\"questioncontainershadow\":\"on\",\"bodybackgroundcolor\":\"#ffffff\",\"fontcolor\":\"#444444\",\"questionbackgroundcolor\":\"#ffffff\",\"checkicon\":null,\"backgroundimage\":\"off\",\"backgroundimagefile\":null,\"brandlogo\":\"on\",\"brandlogofile\":null,\"animatebody\":\"off\",\"bodyanimation\":null,\"bodyanimationduration\":\"500\",\"animatequestion\":\"off\",\"questionanimation\":null,\"questionanimationduration\":\"500\",\"animatealert\":\"off\",\"alertanimation\":null,\"alertanimationduration\":\"500\",\"animatecheckbox\":\"on\",\"checkboxanimation\":null,\"checkboxanimationduration\":\"500\",\"animateradio\":\"on\",\"radioanimation\":null,\"radioanimationduration\":\"500\",\"font\":null,\"cssframework\":\"noto\\n \\n \"}', '', '{}', '[]', '[]', NULL, NULL),
('29', 'vanilla', '497896', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('19', 'vanilla', '616724', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('20', 'extends_fruity', '886739', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('21', 'extends_fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('22', 'fruity', '886739', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('23', 'extends_fruity', '447935', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('24', 'extends_fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('25', 'fruity', '447935', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('26', 'extends_fruity', '766726', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('27', 'extends_fruity', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('28', 'fruity', '766726', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('30', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('31', 'fruity', '497896', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('32', 'vanilla', '453176', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('33', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('34', 'fruity', '453176', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('35', 'vanilla', '594577', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('36', 'vanilla', '594577', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('37', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('38', 'fruity', '594577', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('39', 'fruity', '334427', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('40', 'fruity', '252746', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('41', 'fruity', '272217', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('42', 'vanilla', '132218', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"on\",\"container\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"showpopups\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('43', 'vanilla', '834477', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('44', 'vanilla', '186734', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('45', 'vanilla', NULL, '2', NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"on\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"on\",\"container\":\"on\",\"showpopups\":\"0\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"bottom\",\"fixnumauto\":\"partial\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('46', 'vanilla', '583999', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('47', 'vanilla', '366446', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('48', 'vanilla', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('49', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('50', 'fruity', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('51', 'vanilla', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('52', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('53', 'vanilla', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('54', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('55', 'vanilla', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('56', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('57', 'vanilla', '539342', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('58', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('59', 'vanilla', '647542', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('60', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('61', 'vanilla', '647542', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('62', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('63', 'vanilla', '294982', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('64', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('65', 'fruity', '294982', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('66', 'vanilla', '647542', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('67', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('68', 'vanilla', '461543', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('69', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('70', 'fruity', '461543', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('71', 'fruity', '671748', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('72', 'vanilla', '671748', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('73', 'vanilla', '671748', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('74', 'vanilla', '671748', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('75', 'vanilla', '671748', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('76', 'vanilla', '415875', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('77', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('78', 'fruity', '415875', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('79', 'vanilla', '415875', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('80', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('81', 'fruity', '187194', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('82', 'vanilla', '187194', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('83', 'vanilla', '187194', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('84', 'fruity', '527121', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('85', 'vanilla', '527121', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"animatebody\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"container\":\"inherit\",\"showpopups\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('86', 'vanilla', '527121', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('87', 'vanilla', '176858', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('88', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('89', 'fruity', '176858', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('90', 'vanilla', '567976', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('91', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('92', 'fruity', '567976', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('93', 'vanilla', '953473', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"showpopups\":\"inherit\",\"fixnumauto\":\"off\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('94', 'vanilla', '68284', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('95', 'vanilla', '767283', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('96', 'vanilla', '767283', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('97', 'vanilla', '454883', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('98', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('99', 'fruity', '454883', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('100', 'vanilla', '937358', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('101', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('102', 'fruity', '937358', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('103', 'vanilla', '398476', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('104', 'vanilla', '398476', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('105', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('106', 'fruity', '398476', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"general_inherit\":1,\"font\":\"inherit\",\"bodybackgroundcolor\":\"inherit\",\"fontcolor\":\"inherit\",\"questionbackgroundcolor\":\"inherit\",\"checkicon\":\"inherit\",\"backgroundimagefile\":\"inherit\",\"brandlogofile\":\"inherit\",\"bodyanimation\":\"inherit\",\"inherit\":\"inherit\",\"questionanimation\":\"inherit\",\"alertanimation\":\"inherit\",\"checkboxanimation\":\"inherit\",\"radioanimation\":\"inherit\",\"cssframework\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"zebrastriping\":\"inherit\",\"stickymatrixheaders\":\"inherit\",\"greyoutselected\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"crosshover\":\"inherit\",\"showpopups\":\"inherit\",\"notables\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"questionborder\":\"inherit\",\"questioncontainershadow\":\"inherit\",\"backgroundimage\":\"inherit\",\"brandlogo\":\"inherit\",\"animatebody\":\"inherit\",\"animatequestion\":\"inherit\",\"animatealert\":\"inherit\",\"animatecheckbox\":\"inherit\",\"animateradio\":\"inherit\",\"generalInherit\":null}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('107', 'vanilla', '398476', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('108', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('109', 'vanilla', '398476', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('110', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('111', 'vanilla', '282267', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('112', 'vanilla', '921218', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('113', 'vanilla', '844846', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('114', 'fruity', '157447', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('115', 'vanilla', '157447', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"brandlogofile\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"showpopups\":\"inherit\",\"fixnumauto\":\"inherit\",\"brandlogo\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('116', 'fruity', '745459', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"font\":\"inherit\",\"bodybackgroundcolor\":\"inherit\",\"fontcolor\":\"inherit\",\"questionbackgroundcolor\":\"inherit\",\"checkicon\":\"inherit\",\"backgroundimagefile\":\"inherit\",\"brandlogofile\":\"inherit\",\"bodyanimation\":\"inherit\",\"bodyanimationduration\":\"inherit\",\"questionanimation\":\"inherit\",\"questionanimationduration\":\"inherit\",\"alertanimation\":\"inherit\",\"alertanimationduration\":\"inherit\",\"checkboxanimation\":\"inherit\",\"checkboxanimationduration\":\"inherit\",\"radioanimation\":\"inherit\",\"radioanimationduration\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"questionborder\":\"inherit\",\"questioncontainershadow\":\"inherit\",\"showpopups\":\"inherit\",\"fixnumauto\":\"inherit\",\"zebrastriping\":\"inherit\",\"stickymatrixheaders\":\"inherit\",\"greyoutselected\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"crosshover\":\"inherit\",\"backgroundimage\":\"inherit\",\"brandlogo\":\"inherit\",\"animatebody\":\"inherit\",\"animatequestion\":\"inherit\",\"animatealert\":\"inherit\",\"animatecheckbox\":\"inherit\",\"animateradio\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('117', 'vanilla', '248894', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('118', 'extends_vanilla', NULL, NULL, NULL, '{\"add\":[\"css\\/base.css\",\"css\\/ajaxify.css\",\"css\\/theme.css\",\"css\\/noTablesOnMobile.css\",\"css\\/custom.css\"]}', '{\"add\":[\"scripts\\/theme.js\",\"scripts\\/ajaxify.js\",\"scripts\\/custom.js\"]}', '{\"add\":[\"css\\/print_theme.css\"]}', '{\"comment\":[{},{},{}],\"ajaxmode\":\"on\",\"animatebody\":\"off\",\"hideprivacyinfo\":\"off\",\"container\":\"on\",\"showpopups\":\"1\",\"showclearall\":\"off\",\"questionhelptextposition\":\"top\",\"fixnumauto\":\"off\",\"brandlogo\":\"on\",\"brandlogofile\":\"themes\\/survey\\/vanilla\\/files\\/logo.png\",\"font\":\"noto\\n \\n \"}', 'bootstrap', '{}', '[]', '{\"add\":[\"pjax\",\"moment\",\"font-noto\"]}', NULL, NULL),
('119', 'vanilla', '944142', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('120', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('121', 'fruity', '944142', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('122', 'extends_bootswatch', NULL, NULL, NULL, '{\"replace\":[\"css\\/theme.css\",\"css\\/custom.css\"]}', '{\"replace\":[\"scripts\\/theme.js\",\"scripts\\/custom.js\"]}', '{\"replace\":[\"css\\/print_theme.css\"]}', '{\"comment\":[{},{}],\"container\":\"on\",\"showpopups\":\"1\",\"showclearall\":\"off\",\"questionhelptextposition\":\"top\",\"fixnumauto\":\"off\",\"brandlogo\":\"on\",\"brandlogofile\":\"themes\\/survey\\/bootswatch\\/files\\/logo.png\",\"hideprivacyinfo\":\"off\"}', 'bootstrap', '{\"replace\":[[\"css\\/bootstrap.css\",\"css\\/variations\\/flatly.min.css\"]]}', '[]', '{\"add\":[\"pjax\",\"moment\"]}', NULL, NULL),
('123', 'vanilla', '963358', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('124', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('125', 'fruity', '963358', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('126', 'fruity', '737773', NULL, NULL, 'inherit', 'inherit', 'inherit', '{\"general_inherit\":\"1\",\"font\":\"inherit\",\"bodybackgroundcolor\":\"inherit\",\"fontcolor\":\"inherit\",\"questionbackgroundcolor\":\"inherit\",\"checkicon\":\"inherit\",\"backgroundimagefile\":\"inherit\",\"brandlogofile\":\"inherit\",\"bodyanimation\":\"inherit\",\"inherit\":\"inherit\",\"questionanimation\":\"inherit\",\"alertanimation\":\"inherit\",\"checkboxanimation\":\"inherit\",\"radioanimation\":\"inherit\",\"cssframework\":\"inherit\",\"ajaxmode\":\"off\",\"container\":\"inherit\",\"zebrastriping\":\"inherit\",\"stickymatrixheaders\":\"inherit\",\"greyoutselected\":\"inherit\",\"hideprivacyinfo\":\"inherit\",\"crosshover\":\"inherit\",\"showpopups\":\"inherit\",\"notables\":\"inherit\",\"showclearall\":\"inherit\",\"questionhelptextposition\":\"inherit\",\"fixnumauto\":\"inherit\",\"questionborder\":\"inherit\",\"questioncontainershadow\":\"inherit\",\"backgroundimage\":\"inherit\",\"brandlogo\":\"inherit\",\"animatebody\":\"inherit\",\"animatequestion\":\"inherit\",\"animatealert\":\"inherit\",\"animatecheckbox\":\"inherit\",\"animateradio\":\"inherit\"}', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('127', 'vanilla', '737773', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('128', 'vanilla', '737773', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('129', 'vanilla', '737773', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('130', 'vanilla', '737773', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('131', 'fruity', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('132', 'fruity', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('133', 'vanilla', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('134', 'vanilla', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('135', 'vanilla', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('136', 'vanilla', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('137', 'vanilla', '628525', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('138', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('139', 'vanilla', '152176', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('140', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('141', 'fruity', '152176', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('142', 'vanilla', '485593', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('143', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('144', 'fruity', '485593', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('145', 'vanilla', '218495', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('146', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('147', 'fruity', '218495', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('148', 'vanilla', '826659', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('149', 'fruity', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('150', 'fruity', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('151', 'vanilla', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('152', 'vanilla', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('153', 'vanilla', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('154', 'vanilla', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('155', 'vanilla', '823512', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('156', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('157', 'vanilla', '992119', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('158', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('159', 'fruity', '992119', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('160', 'vanilla', '247399', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('161', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('162', 'fruity', '247399', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('163', 'vanilla', '892498', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('164', 'vanilla', '275719', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('165', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('166', 'fruity', '275719', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('167', 'vanilla', '445479', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('168', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('169', 'vanilla', '275719', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('170', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('171', 'vanilla', '137892', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('172', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('173', 'fruity', '137892', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('174', 'vanilla', '768158', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('175', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('176', 'fruity', '768158', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('177', 'vanilla', '769299', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('178', 'vanilla', NULL, '1', NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL),
('179', 'fruity', '769299', NULL, NULL, 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', 'inherit', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_templates`
--
DROP TABLE IF EXISTS `lime_templates`;
CREATE TABLE `lime_templates` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
`folder` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
`creation_date` datetime DEFAULT NULL,
`author` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`author_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`copyright` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`license` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`version` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`api_version` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`view_folder` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`files_folder` varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`last_update` datetime DEFAULT NULL,
`owner_id` int(11) DEFAULT NULL,
`extends` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `lime_idx1_templates` (`name`),
KEY `lime_idx2_templates` (`title`),
KEY `lime_idx3_templates` (`owner_id`),
KEY `lime_idx4_templates` (`extends`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_templates`
--
INSERT INTO `lime_templates` (`id`,`name`,`folder`,`title`,`creation_date`,`author`,`author_email`,`author_url`,`copyright`,`license`,`version`,`api_version`,`view_folder`,`files_folder`,`description`,`last_update`,`owner_id`,`extends`) VALUES
('1', 'vanilla', 'vanilla', 'Vanilla Theme', '2019-06-03 08:28:55', 'Louis Gac', 'louis.gac@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2019 The LimeSurvey Project Team\r\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'LimeSurvey Bootstrap Vanilla Survey Theme A clean and simple base that can be used by developers to create their own Bootstrap based theme.', NULL, '1', ''),
('2', 'fruity', 'fruity', 'Fruity Theme', '2019-06-03 08:28:55', 'Louis Gac', 'louis.gac@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2019 The LimeSurvey Project Team\r\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'LimeSurvey Fruity Theme A fruity theme for a flexible use. This theme offers monochromes variations and many options for easy customizations.', NULL, '1', 'vanilla'),
('3', 'bootswatch', 'bootswatch', 'Bootswatch Theme', '2019-06-03 08:28:55', 'Louis Gac', 'louis.gac@limesurvey.org', 'https://www.limesurvey.org/', 'Copyright (C) 2007-2017 The LimeSurvey Project Team\\r\\nAll rights reserved.', 'License: GNU/GPL License v2 or later, see LICENSE.php\\r\\n\\r\\nLimeSurvey is free software. This version may have been modified pursuant to the GNU General Public License, and as distributed it includes or is derivative of works licensed under the GNU General Public License or other free or open source software licenses. See COPYRIGHT.php for copyright notices and details.', '3.0', '3.0', 'views', 'files', 'LimeSurvey Bootwatch Theme Based on BootsWatch Themes: Visit BootsWatch page ', NULL, '1', 'vanilla'),
('4', 'extends_fruity', 'extends_fruity', 'extends_fruity', '2019-07-15 14:46:42', 'DenisChenu', '', '', NULL, NULL, NULL, '3.0', 'views', 'files', 'LimeSurvey Fruity Theme A fruity theme for a flexible use. This theme offers monochromes variations and many options for easy customizations.', NULL, '1', 'fruity'),
('5', 'extends_vanilla', 'extends_vanilla', 'extends_vanilla', '2019-10-17 17:23:28', 'DenisChenu', '', '', NULL, NULL, NULL, '3.0', 'views', 'files', 'LimeSurvey Bootstrap Vanilla Survey Theme A clean and simple base that can be used by developers to create their own Bootstrap based theme.', NULL, '1', 'vanilla'),
('6', 'extends_bootswatch', 'extends_bootswatch', 'extends_bootswatch', '2019-10-22 16:45:19', 'DenisChenu', '', '', NULL, NULL, NULL, '3.0', 'views', 'files', '{{gT(\"LimeSurvey Bootwatch Theme\")}} {{gT(\"Based on BootsWatch Themes:\")}} {{gT(\"Visit BootsWatch page\")}} ', NULL, '1', 'bootswatch');
-- --------------------------------------------------------
--
-- Table structure for table `lime_tokens_187194`
--
DROP TABLE IF EXISTS `lime_tokens_187194`;
CREATE TABLE `lime_tokens_187194` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailstatus` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`language` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`blacklisted` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindersent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindercount` int(11) DEFAULT 0,
`completed` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`usesleft` int(11) DEFAULT 1,
`validfrom` datetime DEFAULT NULL,
`validuntil` datetime DEFAULT NULL,
`mpid` int(11) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `idx_token_token_187194_11405` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tokens_187194`
--
INSERT INTO `lime_tokens_187194` (`tid`,`participant_id`,`firstname`,`lastname`,`email`,`emailstatus`,`token`,`language`,`blacklisted`,`sent`,`remindersent`,`remindercount`,`completed`,`usesleft`,`validfrom`,`validuntil`,`mpid`) VALUES
('1', NULL, '', '', '', 'OK', 'tokenTest', 'en', NULL, 'N', 'N', '0', '2019-08-05 00:10', '-1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_tokens_275719`
--
DROP TABLE IF EXISTS `lime_tokens_275719`;
CREATE TABLE `lime_tokens_275719` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailstatus` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`language` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`blacklisted` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindersent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindercount` int(11) DEFAULT 0,
`completed` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`usesleft` int(11) DEFAULT 1,
`validfrom` datetime DEFAULT NULL,
`validuntil` datetime DEFAULT NULL,
`mpid` int(11) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `idx_token_token_275719_18258` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tokens_275719`
--
INSERT INTO `lime_tokens_275719` (`tid`,`participant_id`,`firstname`,`lastname`,`email`,`emailstatus`,`token`,`language`,`blacklisted`,`sent`,`remindersent`,`remindercount`,`completed`,`usesleft`,`validfrom`,`validuntil`,`mpid`) VALUES
('1', NULL, NULL, NULL, '', 'OK', 'NjPmhTN2M1N7xLB', 'en', NULL, 'N', 'N', '0', '2019-12-17 17:16', '0', NULL, NULL, NULL),
('2', NULL, NULL, NULL, '', 'OK', '4rXRaPBMuJFKnq7', 'en', NULL, 'N', 'N', '0', '2019-12-17 17:19', '0', NULL, NULL, NULL),
('3', NULL, NULL, NULL, '', NULL, 'SaOigae7AQF5zB5', 'en', NULL, 'N', 'N', '0', 'N', '1', NULL, NULL, NULL),
('4', NULL, NULL, NULL, '', NULL, 'SyOm0HPAKz07Ngs', 'en', NULL, 'N', 'N', '0', 'N', '1', NULL, NULL, NULL),
('5', NULL, 'vmu84wkrqo6jO/EZr5rZg6B9b2zI62p4oBCfZ6hpykuGuDOyOyYfhiEWqsKB0RHfJulPBZaZfIaAcusBrvLDAkZpcnN0IG5hbWU6', 'wReuZ6nnJfyNmiSHaHSnWo8Lyovn9Qxx93FVFjp5es0JCOXoqSKqC6XZee92vyN9rG8DFBaL3ArsMfKoLL6NBm5hbWU=', '', 'OK', '', 'en', NULL, 'N', 'N', '0', 'N', '1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_tokens_415875`
--
DROP TABLE IF EXISTS `lime_tokens_415875`;
CREATE TABLE `lime_tokens_415875` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailstatus` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`language` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`blacklisted` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindersent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindercount` int(11) DEFAULT 0,
`completed` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`usesleft` int(11) DEFAULT 1,
`validfrom` datetime DEFAULT NULL,
`validuntil` datetime DEFAULT NULL,
`mpid` int(11) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `idx_token_token_415875_5439` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tokens_415875`
--
INSERT INTO `lime_tokens_415875` (`tid`,`participant_id`,`firstname`,`lastname`,`email`,`emailstatus`,`token`,`language`,`blacklisted`,`sent`,`remindersent`,`remindercount`,`completed`,`usesleft`,`validfrom`,`validuntil`,`mpid`) VALUES
('1', NULL, '', '', '', 'OK', 'tokenTest', 'en', NULL, 'N', 'N', '0', '2019-08-05 00:10', '-1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_tokens_527121`
--
DROP TABLE IF EXISTS `lime_tokens_527121`;
CREATE TABLE `lime_tokens_527121` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailstatus` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`language` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`blacklisted` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindersent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindercount` int(11) DEFAULT 0,
`completed` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`usesleft` int(11) DEFAULT 1,
`validfrom` datetime DEFAULT NULL,
`validuntil` datetime DEFAULT NULL,
`mpid` int(11) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `idx_token_token_527121_38444` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tokens_527121`
--
INSERT INTO `lime_tokens_527121` (`tid`,`participant_id`,`firstname`,`lastname`,`email`,`emailstatus`,`token`,`language`,`blacklisted`,`sent`,`remindersent`,`remindercount`,`completed`,`usesleft`,`validfrom`,`validuntil`,`mpid`) VALUES
('1', NULL, '', '', '', 'OK', 'tokenTest', 'en', NULL, 'N', 'N', '0', '2019-08-05 00:10', '-1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_tokens_953473`
--
DROP TABLE IF EXISTS `lime_tokens_953473`;
CREATE TABLE `lime_tokens_953473` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`participant_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`firstname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`lastname` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`emailstatus` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`token` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
`language` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`blacklisted` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`sent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindersent` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`remindercount` int(11) DEFAULT 0,
`completed` varchar(17) COLLATE utf8mb4_unicode_ci DEFAULT 'N',
`usesleft` int(11) DEFAULT 1,
`validfrom` datetime DEFAULT NULL,
`validuntil` datetime DEFAULT NULL,
`mpid` int(11) DEFAULT NULL,
PRIMARY KEY (`tid`),
KEY `idx_token_token_953473_16458` (`token`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tokens_953473`
--
INSERT INTO `lime_tokens_953473` (`tid`,`participant_id`,`firstname`,`lastname`,`email`,`emailstatus`,`token`,`language`,`blacklisted`,`sent`,`remindersent`,`remindercount`,`completed`,`usesleft`,`validfrom`,`validuntil`,`mpid`) VALUES
('1', NULL, 'Test', 'Test', 'denis@sondages.pro', 'OK', 'TEST', 'en', NULL, '2019-10-17 14:04', '2020-01-10 07:01', '3', 'N', '1', NULL, NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `lime_tutorial_entries`
--
DROP TABLE IF EXISTS `lime_tutorial_entries`;
CREATE TABLE `lime_tutorial_entries` (
`teid` int(11) NOT NULL AUTO_INCREMENT,
`ordering` int(11) DEFAULT NULL,
`title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
PRIMARY KEY (`teid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tutorial_entries`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_tutorial_entry_relation`
--
DROP TABLE IF EXISTS `lime_tutorial_entry_relation`;
CREATE TABLE `lime_tutorial_entry_relation` (
`teid` int(11) NOT NULL,
`tid` int(11) NOT NULL,
`uid` int(11) DEFAULT NULL,
`sid` int(11) DEFAULT NULL,
PRIMARY KEY (`teid`,`tid`),
KEY `lime_idx1_tutorial_entry_relation` (`uid`),
KEY `lime_idx2_tutorial_entry_relation` (`sid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tutorial_entry_relation`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_tutorials`
--
DROP TABLE IF EXISTS `lime_tutorials`;
CREATE TABLE `lime_tutorials` (
`tid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`title` varchar(192) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`icon` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`active` int(11) DEFAULT 0,
`settings` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`permission` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
`permission_grade` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`tid`),
UNIQUE KEY `lime_idx1_tutorials` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_tutorials`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_user_groups`
--
DROP TABLE IF EXISTS `lime_user_groups`;
CREATE TABLE `lime_user_groups` (
`ugid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
`description` text COLLATE utf8mb4_unicode_ci NOT NULL,
`owner_id` int(11) NOT NULL,
PRIMARY KEY (`ugid`),
UNIQUE KEY `lime_idx1_user_groups` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_user_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_user_in_groups`
--
DROP TABLE IF EXISTS `lime_user_in_groups`;
CREATE TABLE `lime_user_in_groups` (
`ugid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`ugid`,`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_user_in_groups`
--
-- --------------------------------------------------------
--
-- Table structure for table `lime_user_in_permissionrole`
--
DROP TABLE IF EXISTS `lime_user_in_permissionrole`;
CREATE TABLE `lime_user_in_permissionrole` (
`ptid` int(11) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`ptid`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
--
-- Dumping data for table `lime_user_in_permissionrole`
--
INSERT INTO `lime_user_in_permissionrole` (`ptid`,`uid`) VALUES
('1', '2');
-- --------------------------------------------------------
--
-- Table structure for table `lime_users`
--
DROP TABLE IF EXISTS `lime_users`;
CREATE TABLE `lime_users` (
`uid` int(11) NOT NULL AUTO_INCREMENT,
`users_name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
`password` text COLLATE utf8mb4_unicode_ci NOT NULL,
`full_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
`parent_id` int(11) NOT NULL,
`lang` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`email` varchar(192) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`htmleditormode` varchar(7) COLLATE utf8mb4_unicode_ci DEFAULT 'default',
`templateeditormode` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`questionselectormode` varchar(7) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'default',
`one_time_pw` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`dateformat` int(11) NOT NULL DEFAULT 1,
`created` datetime DEFAULT NULL,
`modified` datetime DEFAULT NULL,
`lastLogin` datetime DEFAULT NULL,
PRIMARY KEY (`uid`),
UNIQUE KEY `lime_idx1_users` (`users_name`),
KEY `lime_idx2_users` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
--
-- Dumping data for table `lime_users`
--
INSERT INTO `lime_users` (`uid`,`users_name`,`password`,`full_name`,`parent_id`,`lang`,`email`,`htmleditormode`,`templateeditormode`,`questionselectormode`,`one_time_pw`,`dateformat`,`created`,`modified`,`lastLogin`) VALUES
('1', 'DenisChenu', '$2y$10$HRIwuGuO/LtLW1YipSHGP.pubaLOQS9suqZxjtaNh4YmxR/OTHKjq', 'Administrator', '0', 'en', 'your-email@example.net', 'source', 'full', 'none', NULL, '1', '2019-06-03 10:29:09', '2020-01-14 16:18:50', '2020-01-14 10:28:24'),
('2', 'Test', '$2y$10$SULEvb2DCIiYECVPMYEwTOwIPWrf7iyUFA8Cny.Acp8PqmFA2Vglm', 'Test', '1', 'auto', 'test@sondages.pro', 'source', 'default', 'default', NULL, '1', '2019-07-28 15:52:29', '2020-01-13 09:05:18', '2020-01-13 08:05:18'),
('3', 'rcuser', '$2y$10$L03SKt9MRaiRTT2SMVhHre0ZqWsbFM5cpdX5oNG1a2DrJX.jF63DC', 'rcuser', '1', 'auto', 'rcuser@sondages.pro', 'default', 'default', 'default', NULL, '1', '2019-10-17 16:06:58', '2020-01-10 11:49:18', '2020-01-10 10:48:36');
![](\"/develop/upload/surveys/768158//Capture)