5
by azammitdcarf
Import from DCARF SVN |
1 |
-- phpMyAdmin SQL Dump |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
2 |
-- version 2.11.8.1deb5+lenny9 |
5
by azammitdcarf
Import from DCARF SVN |
3 |
-- http://www.phpmyadmin.net |
4 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
5 |
-- Host: localhost |
285.1.35
by Adam Zammit
Updated database schema for new features |
6 |
-- Generation Time: Feb 28, 2013 at 09:35 AM |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
7 |
-- Server version: 5.0.51 |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
8 |
-- PHP Version: 5.2.6-1+lenny16 |
5
by azammitdcarf
Import from DCARF SVN |
9 |
|
10 |
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; |
|
11 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
12 |
|
13 |
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; |
|
14 |
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; |
|
15 |
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; |
|
16 |
/*!40101 SET NAMES utf8 */; |
|
17 |
||
5
by azammitdcarf
Import from DCARF SVN |
18 |
--
|
285.1.35
by Adam Zammit
Updated database schema for new features |
19 |
-- Database: `quexs_ictest` |
5
by azammitdcarf
Import from DCARF SVN |
20 |
--
|
285.1.35
by Adam Zammit
Updated database schema for new features |
21 |
|
5
by azammitdcarf
Import from DCARF SVN |
22 |
-- -------------------------------------------------------- |
23 |
||
24 |
--
|
|
25 |
-- Table structure for table `appointment` |
|
26 |
--
|
|
27 |
||
28 |
CREATE TABLE `appointment` ( |
|
29 |
`appointment_id` bigint(20) NOT NULL auto_increment, |
|
30 |
`case_id` bigint(20) NOT NULL, |
|
31 |
`contact_phone_id` bigint(20) NOT NULL, |
|
32 |
`call_attempt_id` bigint(20) NOT NULL, |
|
33 |
`start` datetime NOT NULL, |
|
34 |
`end` datetime NOT NULL, |
|
35 |
`require_operator_id` bigint(20) default NULL, |
|
36 |
`respondent_id` bigint(20) NOT NULL, |
|
37 |
`completed_call_id` bigint(20) default NULL, |
|
38 |
PRIMARY KEY (`appointment_id`), |
|
39 |
KEY `completed_call_id` (`completed_call_id`), |
|
143
by azammitdcarf
Added missing comma |
40 |
KEY `call_attempt_id` (`call_attempt_id`), |
133
by azammitdcarf
Added index to appointment table to speed up case selection criteria |
41 |
KEY `case_id` (`case_id`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
42 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
43 |
|
44 |
--
|
|
45 |
-- Dumping data for table `appointment` |
|
46 |
--
|
|
47 |
||
48 |
||
49 |
-- -------------------------------------------------------- |
|
50 |
||
51 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
52 |
-- Table structure for table `availability` |
53 |
--
|
|
54 |
||
55 |
CREATE TABLE `availability` ( |
|
56 |
`availability_id` bigint(20) NOT NULL auto_increment, |
|
57 |
`availability_group_id` bigint(20) NOT NULL, |
|
58 |
`start` time NOT NULL, |
|
59 |
`end` time NOT NULL, |
|
60 |
`day_of_week` tinyint(1) NOT NULL, |
|
61 |
PRIMARY KEY (`availability_id`), |
|
62 |
KEY `availability_group_id` (`availability_group_id`) |
|
63 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
64 |
||
65 |
--
|
|
66 |
-- Dumping data for table `availability` |
|
67 |
--
|
|
68 |
||
69 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(1, 1, '00:00:00', '11:59:59', 2); |
|
70 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(2, 1, '00:00:00', '11:59:59', 3); |
|
71 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(3, 1, '00:00:00', '11:59:59', 4); |
|
72 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(4, 1, '00:00:00', '11:59:59', 5); |
|
73 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(5, 1, '00:00:00', '11:59:59', 6); |
|
74 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(6, 2, '12:00:00', '17:59:59', 2); |
|
75 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(7, 2, '12:00:00', '17:59:59', 3); |
|
76 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(8, 2, '12:00:00', '17:59:59', 4); |
|
77 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(9, 2, '12:00:00', '17:59:59', 5); |
|
78 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(10, 2, '12:00:00', '17:59:59', 6); |
|
79 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(11, 3, '18:00:00', '23:59:59', 2); |
|
80 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(12, 3, '18:00:00', '23:59:59', 3); |
|
81 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(13, 3, '18:00:00', '23:59:59', 4); |
|
82 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(14, 3, '18:00:00', '23:59:59', 5); |
|
83 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(15, 3, '18:00:00', '23:59:59', 6); |
|
84 |
INSERT INTO `availability` (`availability_id`, `availability_group_id`, `start`, `end`, `day_of_week`) VALUES(16, 4, '00:00:00', '23:59:59', 7); |
|
85 |
||
86 |
-- -------------------------------------------------------- |
|
87 |
||
88 |
--
|
|
89 |
-- Table structure for table `availability_group` |
|
90 |
--
|
|
91 |
||
92 |
CREATE TABLE `availability_group` ( |
|
93 |
`availability_group_id` bigint(20) NOT NULL auto_increment, |
|
94 |
`description` text collate utf8_unicode_ci NOT NULL, |
|
95 |
PRIMARY KEY (`availability_group_id`) |
|
96 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
97 |
||
98 |
--
|
|
99 |
-- Dumping data for table `availability_group` |
|
100 |
--
|
|
101 |
||
102 |
INSERT INTO `availability_group` (`availability_group_id`, `description`) VALUES(1, 'Weekday mornings (Before 12pm)'); |
|
103 |
INSERT INTO `availability_group` (`availability_group_id`, `description`) VALUES(2, 'Weekday afternoons (After 12pm but before 6pm)'); |
|
104 |
INSERT INTO `availability_group` (`availability_group_id`, `description`) VALUES(3, 'Evenings (After 6pm)'); |
|
105 |
INSERT INTO `availability_group` (`availability_group_id`, `description`) VALUES(4, 'Saturdays'); |
|
106 |
||
107 |
-- -------------------------------------------------------- |
|
108 |
||
109 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
110 |
-- Table structure for table `call` |
111 |
--
|
|
112 |
||
113 |
CREATE TABLE `call` ( |
|
114 |
`call_id` bigint(20) NOT NULL auto_increment, |
|
115 |
`operator_id` bigint(20) NOT NULL, |
|
116 |
`respondent_id` bigint(20) NOT NULL, |
|
117 |
`case_id` bigint(20) NOT NULL, |
|
118 |
`contact_phone_id` bigint(20) NOT NULL, |
|
119 |
`call_attempt_id` bigint(20) NOT NULL, |
|
120 |
`start` datetime NOT NULL, |
|
121 |
`end` datetime default NULL, |
|
122 |
`outcome_id` int(11) NOT NULL default '0', |
|
123 |
`state` tinyint(1) NOT NULL default '0' COMMENT '0 not called, 1 requesting call, 2 ringing, 3 answered, 4 requires coding, 5 done', |
|
124 |
PRIMARY KEY (`call_id`), |
|
125 |
KEY `operator_id` (`operator_id`), |
|
126 |
KEY `case_id` (`case_id`), |
|
127 |
KEY `call_attempt_id` (`call_attempt_id`), |
|
232
by azammitdcarf
Added database optimisations and keys |
128 |
KEY `contact_phone_id` (`contact_phone_id`), |
129 |
KEY `start` (`start`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
130 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
131 |
|
132 |
--
|
|
133 |
-- Dumping data for table `call` |
|
134 |
--
|
|
135 |
||
136 |
||
137 |
-- -------------------------------------------------------- |
|
138 |
||
139 |
--
|
|
140 |
-- Table structure for table `call_attempt` |
|
141 |
--
|
|
142 |
||
143 |
CREATE TABLE `call_attempt` ( |
|
144 |
`call_attempt_id` bigint(20) NOT NULL auto_increment, |
|
145 |
`case_id` bigint(20) NOT NULL, |
|
146 |
`operator_id` bigint(20) NOT NULL, |
|
147 |
`respondent_id` bigint(20) NOT NULL, |
|
148 |
`start` datetime NOT NULL, |
|
149 |
`end` datetime default NULL, |
|
150 |
PRIMARY KEY (`call_attempt_id`), |
|
151 |
KEY `case_id` (`case_id`), |
|
152 |
KEY `end` (`end`), |
|
153 |
KEY `respondent_id` (`respondent_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
154 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
155 |
|
156 |
--
|
|
157 |
-- Dumping data for table `call_attempt` |
|
158 |
--
|
|
159 |
||
160 |
||
161 |
-- -------------------------------------------------------- |
|
162 |
||
163 |
--
|
|
164 |
-- Table structure for table `call_note` |
|
165 |
--
|
|
166 |
||
167 |
CREATE TABLE `call_note` ( |
|
168 |
`call_note_id` bigint(20) NOT NULL auto_increment, |
|
169 |
`call_id` bigint(20) NOT NULL, |
|
170 |
`operator_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
171 |
`note` text collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
172 |
`datetime` datetime NOT NULL, |
173 |
PRIMARY KEY (`call_note_id`), |
|
174 |
KEY `call_id` (`call_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
175 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
176 |
|
177 |
--
|
|
178 |
-- Dumping data for table `call_note` |
|
179 |
--
|
|
180 |
||
181 |
||
182 |
-- -------------------------------------------------------- |
|
183 |
||
184 |
--
|
|
185 |
-- Table structure for table `call_restrict` |
|
186 |
--
|
|
187 |
||
188 |
CREATE TABLE `call_restrict` ( |
|
189 |
`day_of_week` tinyint(1) NOT NULL, |
|
190 |
`start` time NOT NULL, |
|
191 |
`end` time NOT NULL, |
|
192 |
KEY `day_of_week` (`day_of_week`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
193 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
194 |
|
195 |
--
|
|
196 |
-- Dumping data for table `call_restrict` |
|
197 |
--
|
|
198 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
199 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(1, '09:00:00', '17:00:00'); |
200 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(2, '09:00:00', '20:30:00'); |
|
201 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(3, '09:00:00', '20:30:00'); |
|
202 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(4, '09:00:00', '20:30:00'); |
|
203 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(5, '09:00:00', '20:30:00'); |
|
204 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(6, '09:00:00', '20:30:00'); |
|
205 |
INSERT INTO `call_restrict` (`day_of_week`, `start`, `end`) VALUES(7, '09:00:00', '17:00:00'); |
|
5
by azammitdcarf
Import from DCARF SVN |
206 |
|
207 |
-- -------------------------------------------------------- |
|
208 |
||
209 |
--
|
|
210 |
-- Table structure for table `call_state` |
|
211 |
--
|
|
212 |
||
213 |
CREATE TABLE `call_state` ( |
|
214 |
`call_state_id` tinyint(1) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
215 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
216 |
PRIMARY KEY (`call_state_id`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
217 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
218 |
|
219 |
--
|
|
220 |
-- Dumping data for table `call_state` |
|
221 |
--
|
|
222 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
223 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(0, 'Not called'); |
224 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(1, 'Requesting call'); |
|
225 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(2, 'Ringing'); |
|
226 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(3, 'Answered'); |
|
227 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(4, 'Requires coding'); |
|
228 |
INSERT INTO `call_state` (`call_state_id`, `description`) VALUES(5, 'Done'); |
|
5
by azammitdcarf
Import from DCARF SVN |
229 |
|
230 |
-- -------------------------------------------------------- |
|
231 |
||
232 |
--
|
|
233 |
-- Table structure for table `case` |
|
234 |
--
|
|
235 |
||
236 |
CREATE TABLE `case` ( |
|
237 |
`case_id` bigint(20) NOT NULL auto_increment, |
|
238 |
`sample_id` bigint(20) NOT NULL, |
|
239 |
`questionnaire_id` bigint(20) NOT NULL, |
|
240 |
`last_call_id` bigint(20) default NULL, |
|
241 |
`current_operator_id` bigint(20) default NULL, |
|
242 |
`current_call_id` bigint(20) default NULL, |
|
243 |
`current_outcome_id` int(11) NOT NULL default '1', |
|
191
by azammitdcarf
Added a "system sort" process which sorts cases and the sample file from enabled questionnaires periodically (based on SYSTEM_SORT_MINUTES config directive). Enabling this may improve performance where there is a large number of interviewers, a large sample or complex quotas as the sort doesn't need to be done for each interviewer at each case. |
244 |
`sortorder` int(11) default NULL, |
285.1.35
by Adam Zammit
Updated database schema for new features |
245 |
`token` varchar(36) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
246 |
PRIMARY KEY (`case_id`), |
247 |
UNIQUE KEY `onecasepersample` (`sample_id`,`questionnaire_id`), |
|
285.1.35
by Adam Zammit
Updated database schema for new features |
248 |
UNIQUE KEY `token` (`token`), |
5
by azammitdcarf
Import from DCARF SVN |
249 |
UNIQUE KEY `current_operator_id` (`current_operator_id`), |
250 |
UNIQUE KEY `current_call_id` (`current_call_id`), |
|
251 |
KEY `sample_id` (`sample_id`), |
|
191
by azammitdcarf
Added a "system sort" process which sorts cases and the sample file from enabled questionnaires periodically (based on SYSTEM_SORT_MINUTES config directive). Enabling this may improve performance where there is a large number of interviewers, a large sample or complex quotas as the sort doesn't need to be done for each interviewer at each case. |
252 |
KEY `questionnaire_id` (`questionnaire_id`), |
232
by azammitdcarf
Added database optimisations and keys |
253 |
KEY `sortorder` (`sortorder`), |
254 |
KEY `last_call_id` (`last_call_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
255 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
256 |
|
257 |
--
|
|
258 |
-- Dumping data for table `case` |
|
259 |
--
|
|
260 |
||
261 |
||
262 |
-- -------------------------------------------------------- |
|
263 |
||
264 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
265 |
-- Table structure for table `case_availability` |
266 |
--
|
|
267 |
||
268 |
CREATE TABLE `case_availability` ( |
|
269 |
`case_id` bigint(20) NOT NULL, |
|
270 |
`availability_group_id` bigint(20) NOT NULL, |
|
271 |
PRIMARY KEY (`case_id`,`availability_group_id`) |
|
272 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
273 |
||
274 |
--
|
|
275 |
-- Dumping data for table `case_availability` |
|
276 |
--
|
|
277 |
||
278 |
||
279 |
-- -------------------------------------------------------- |
|
280 |
||
281 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
282 |
-- Table structure for table `case_note` |
283 |
--
|
|
284 |
||
285 |
CREATE TABLE `case_note` ( |
|
286 |
`case_note_id` bigint(20) NOT NULL auto_increment, |
|
287 |
`case_id` bigint(20) NOT NULL, |
|
288 |
`operator_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
289 |
`note` text collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
290 |
`datetime` datetime NOT NULL, |
291 |
PRIMARY KEY (`case_note_id`), |
|
292 |
KEY `case_id` (`case_id`), |
|
293 |
KEY `operator_id` (`operator_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
294 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
295 |
|
296 |
--
|
|
298.1.53
by Adam Zammit
Updated database schema |
297 |
-- Table structure for table `case_queue` |
5
by azammitdcarf
Import from DCARF SVN |
298 |
--
|
299 |
||
298.1.53
by Adam Zammit
Updated database schema |
300 |
CREATE TABLE `case_queue` ( |
301 |
`case_queue_id` bigint(20) NOT NULL auto_increment, |
|
302 |
`case_id` bigint(20) NOT NULL, |
|
303 |
`operator_id` bigint(20) NOT NULL, |
|
304 |
`sortorder` int(11) NOT NULL, |
|
305 |
PRIMARY KEY (`case_queue_id`), |
|
306 |
UNIQUE KEY `case_id` (`case_id`), |
|
307 |
KEY `operator_id` (`operator_id`) |
|
308 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
5
by azammitdcarf
Import from DCARF SVN |
309 |
|
310 |
-- -------------------------------------------------------- |
|
311 |
||
312 |
--
|
|
313 |
-- Table structure for table `client` |
|
314 |
--
|
|
315 |
||
316 |
CREATE TABLE `client` ( |
|
317 |
`client_id` bigint(20) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
318 |
`username` varchar(255) collate utf8_unicode_ci NOT NULL, |
319 |
`firstName` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
320 |
`lastName` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
321 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
322 |
PRIMARY KEY (`client_id`), |
323 |
UNIQUE KEY `username` (`username`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
324 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
325 |
|
326 |
--
|
|
327 |
-- Dumping data for table `client` |
|
328 |
--
|
|
329 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
330 |
|
5
by azammitdcarf
Import from DCARF SVN |
331 |
-- -------------------------------------------------------- |
332 |
||
333 |
--
|
|
334 |
-- Table structure for table `client_questionnaire` |
|
335 |
--
|
|
336 |
||
337 |
CREATE TABLE `client_questionnaire` ( |
|
338 |
`client_id` bigint(20) NOT NULL, |
|
339 |
`questionnaire_id` bigint(20) NOT NULL, |
|
340 |
PRIMARY KEY (`client_id`,`questionnaire_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
341 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
342 |
|
343 |
--
|
|
344 |
-- Dumping data for table `client_questionnaire` |
|
345 |
--
|
|
346 |
||
347 |
||
348 |
-- -------------------------------------------------------- |
|
349 |
||
350 |
--
|
|
351 |
-- Table structure for table `contact_phone` |
|
352 |
--
|
|
353 |
||
354 |
CREATE TABLE `contact_phone` ( |
|
355 |
`contact_phone_id` bigint(20) NOT NULL auto_increment, |
|
356 |
`case_id` bigint(20) NOT NULL, |
|
357 |
`priority` tinyint(1) NOT NULL default '1', |
|
289
by Adam Zammit
Changed phone field to be a char to handle starting with 0 correctly |
358 |
`phone` char(30) collate utf8_unicode_ci NOT NULL, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
359 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
360 |
PRIMARY KEY (`contact_phone_id`), |
361 |
KEY `case_id` (`case_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
362 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
363 |
|
364 |
--
|
|
365 |
-- Dumping data for table `contact_phone` |
|
366 |
--
|
|
367 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
368 |
|
369 |
-- -------------------------------------------------------- |
|
370 |
||
18
by azammitdcarf
Added day_of_week table and data |
371 |
--
|
372 |
-- Table structure for table `day_of_week` |
|
373 |
--
|
|
374 |
||
375 |
CREATE TABLE `day_of_week` ( |
|
376 |
`day_of_week` tinyint(1) NOT NULL, |
|
377 |
PRIMARY KEY (`day_of_week`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
378 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
18
by azammitdcarf
Added day_of_week table and data |
379 |
|
380 |
--
|
|
381 |
-- Dumping data for table `day_of_week` |
|
382 |
--
|
|
383 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
384 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(1); |
385 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(2); |
|
386 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(3); |
|
387 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(4); |
|
388 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(5); |
|
389 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(6); |
|
390 |
INSERT INTO `day_of_week` (`day_of_week`) VALUES(7); |
|
5
by azammitdcarf
Import from DCARF SVN |
391 |
|
392 |
-- -------------------------------------------------------- |
|
393 |
||
394 |
--
|
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
395 |
-- Table structure for table `lime_answers` |
396 |
--
|
|
397 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
398 |
CREATE TABLE `lime_answers` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
399 |
`qid` int(11) NOT NULL default '0', |
400 |
`code` varchar(5) collate utf8_unicode_ci NOT NULL default '', |
|
401 |
`answer` text collate utf8_unicode_ci NOT NULL, |
|
402 |
`assessment_value` int(11) NOT NULL default '0', |
|
403 |
`sortorder` int(11) NOT NULL, |
|
404 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL default 'en', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
405 |
`scale_id` tinyint(4) NOT NULL default '0', |
406 |
PRIMARY KEY (`qid`,`code`,`language`,`scale_id`), |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
407 |
KEY `answers_idx2` (`sortorder`) |
408 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
409 |
||
410 |
--
|
|
411 |
-- Dumping data for table `lime_answers` |
|
412 |
--
|
|
413 |
||
414 |
||
415 |
-- -------------------------------------------------------- |
|
416 |
||
417 |
--
|
|
418 |
-- Table structure for table `lime_assessments` |
|
419 |
--
|
|
420 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
421 |
CREATE TABLE `lime_assessments` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
422 |
`id` int(11) NOT NULL auto_increment, |
423 |
`sid` int(11) NOT NULL default '0', |
|
424 |
`scope` varchar(5) collate utf8_unicode_ci NOT NULL default '', |
|
425 |
`gid` int(11) NOT NULL default '0', |
|
426 |
`name` text collate utf8_unicode_ci NOT NULL, |
|
427 |
`minimum` varchar(50) collate utf8_unicode_ci NOT NULL default '', |
|
428 |
`maximum` varchar(50) collate utf8_unicode_ci NOT NULL default '', |
|
429 |
`message` text collate utf8_unicode_ci NOT NULL, |
|
430 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL default 'en', |
|
431 |
PRIMARY KEY (`id`,`language`), |
|
432 |
KEY `assessments_idx2` (`sid`), |
|
433 |
KEY `assessments_idx3` (`gid`) |
|
434 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
435 |
||
436 |
--
|
|
437 |
-- Dumping data for table `lime_assessments` |
|
438 |
--
|
|
439 |
||
440 |
||
441 |
-- -------------------------------------------------------- |
|
442 |
||
443 |
--
|
|
444 |
-- Table structure for table `lime_conditions` |
|
445 |
--
|
|
446 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
447 |
CREATE TABLE `lime_conditions` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
448 |
`cid` int(11) NOT NULL auto_increment, |
449 |
`qid` int(11) NOT NULL default '0', |
|
450 |
`scenario` int(11) NOT NULL default '1', |
|
451 |
`cqid` int(11) NOT NULL default '0', |
|
452 |
`cfieldname` varchar(50) collate utf8_unicode_ci NOT NULL default '', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
453 |
`method` char(5) collate utf8_unicode_ci NOT NULL default '', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
454 |
`value` varchar(255) collate utf8_unicode_ci NOT NULL default '', |
455 |
PRIMARY KEY (`cid`), |
|
456 |
KEY `conditions_idx2` (`qid`), |
|
457 |
KEY `conditions_idx3` (`cqid`) |
|
458 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
459 |
||
460 |
--
|
|
461 |
-- Dumping data for table `lime_conditions` |
|
462 |
--
|
|
463 |
||
464 |
||
465 |
-- -------------------------------------------------------- |
|
466 |
||
467 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
468 |
-- Table structure for table `lime_defaultvalues` |
469 |
--
|
|
470 |
||
471 |
CREATE TABLE `lime_defaultvalues` ( |
|
472 |
`qid` int(11) NOT NULL default '0', |
|
473 |
`specialtype` varchar(20) collate utf8_unicode_ci NOT NULL default '', |
|
474 |
`scale_id` int(11) NOT NULL default '0', |
|
475 |
`sqid` int(11) NOT NULL default '0', |
|
476 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL, |
|
477 |
`defaultvalue` text collate utf8_unicode_ci, |
|
478 |
PRIMARY KEY (`qid`,`scale_id`,`language`,`specialtype`,`sqid`) |
|
479 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
480 |
||
481 |
--
|
|
482 |
-- Dumping data for table `lime_defaultvalues` |
|
483 |
--
|
|
484 |
||
485 |
||
486 |
-- -------------------------------------------------------- |
|
487 |
||
488 |
--
|
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
489 |
-- Table structure for table `lime_expression_errors` |
490 |
--
|
|
491 |
||
492 |
CREATE TABLE `lime_expression_errors` ( |
|
493 |
`id` int(9) NOT NULL auto_increment, |
|
494 |
`errortime` varchar(50) collate utf8_unicode_ci default NULL, |
|
495 |
`sid` int(11) default NULL, |
|
496 |
`gid` int(11) default NULL, |
|
497 |
`qid` int(11) default NULL, |
|
498 |
`gseq` int(11) default NULL, |
|
499 |
`qseq` int(11) default NULL, |
|
500 |
`type` varchar(50) collate utf8_unicode_ci default NULL, |
|
501 |
`eqn` text collate utf8_unicode_ci, |
|
502 |
`prettyprint` text collate utf8_unicode_ci, |
|
503 |
PRIMARY KEY (`id`) |
|
504 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
505 |
||
506 |
--
|
|
507 |
-- Dumping data for table `lime_expression_errors` |
|
508 |
--
|
|
509 |
||
510 |
||
511 |
-- -------------------------------------------------------- |
|
512 |
||
513 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
514 |
-- Table structure for table `lime_failed_login_attempts` |
515 |
--
|
|
516 |
||
517 |
CREATE TABLE `lime_failed_login_attempts` ( |
|
518 |
`id` int(11) NOT NULL auto_increment, |
|
519 |
`ip` varchar(37) collate utf8_unicode_ci NOT NULL, |
|
520 |
`last_attempt` varchar(20) collate utf8_unicode_ci NOT NULL, |
|
521 |
`number_attempts` int(11) NOT NULL, |
|
522 |
PRIMARY KEY (`id`) |
|
523 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
524 |
||
525 |
--
|
|
526 |
-- Dumping data for table `lime_failed_login_attempts` |
|
527 |
--
|
|
528 |
||
529 |
||
530 |
-- -------------------------------------------------------- |
|
531 |
||
532 |
--
|
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
533 |
-- Table structure for table `lime_groups` |
534 |
--
|
|
535 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
536 |
CREATE TABLE `lime_groups` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
537 |
`gid` int(11) NOT NULL auto_increment, |
538 |
`sid` int(11) NOT NULL default '0', |
|
539 |
`group_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', |
|
540 |
`group_order` int(11) NOT NULL default '0', |
|
541 |
`description` text collate utf8_unicode_ci, |
|
542 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL default 'en', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
543 |
`randomization_group` varchar(20) collate utf8_unicode_ci NOT NULL default '', |
544 |
`grelevance` text collate utf8_unicode_ci, |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
545 |
PRIMARY KEY (`gid`,`language`), |
546 |
KEY `groups_idx2` (`sid`) |
|
547 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
548 |
||
549 |
--
|
|
550 |
-- Dumping data for table `lime_groups` |
|
551 |
--
|
|
552 |
||
553 |
||
554 |
-- -------------------------------------------------------- |
|
555 |
||
556 |
--
|
|
557 |
-- Table structure for table `lime_labels` |
|
558 |
--
|
|
559 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
560 |
CREATE TABLE `lime_labels` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
561 |
`lid` int(11) NOT NULL default '0', |
562 |
`code` varchar(5) collate utf8_unicode_ci NOT NULL default '', |
|
563 |
`title` text collate utf8_unicode_ci, |
|
564 |
`sortorder` int(11) NOT NULL, |
|
565 |
`assessment_value` int(11) NOT NULL default '0', |
|
566 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL default 'en', |
|
567 |
PRIMARY KEY (`lid`,`sortorder`,`language`), |
|
568 |
KEY `ixcode` (`code`) |
|
569 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
570 |
||
571 |
--
|
|
572 |
-- Dumping data for table `lime_labels` |
|
573 |
--
|
|
574 |
||
575 |
||
576 |
-- -------------------------------------------------------- |
|
577 |
||
578 |
--
|
|
579 |
-- Table structure for table `lime_labelsets` |
|
580 |
--
|
|
581 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
582 |
CREATE TABLE `lime_labelsets` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
583 |
`lid` int(11) NOT NULL auto_increment, |
584 |
`label_name` varchar(100) collate utf8_unicode_ci NOT NULL default '', |
|
585 |
`languages` varchar(200) collate utf8_unicode_ci default 'en', |
|
586 |
PRIMARY KEY (`lid`) |
|
587 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
588 |
||
589 |
--
|
|
590 |
-- Dumping data for table `lime_labelsets` |
|
591 |
--
|
|
592 |
||
593 |
||
594 |
-- -------------------------------------------------------- |
|
595 |
||
596 |
--
|
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
597 |
-- Table structure for table `lime_participants` |
598 |
--
|
|
599 |
||
600 |
CREATE TABLE `lime_participants` ( |
|
601 |
`participant_id` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
602 |
`firstname` varchar(40) collate utf8_unicode_ci default NULL, |
|
603 |
`lastname` varchar(40) collate utf8_unicode_ci default NULL, |
|
604 |
`email` varchar(80) collate utf8_unicode_ci default NULL, |
|
605 |
`language` varchar(40) collate utf8_unicode_ci default NULL, |
|
606 |
`blacklisted` varchar(1) collate utf8_unicode_ci NOT NULL, |
|
607 |
`owner_uid` int(20) NOT NULL, |
|
608 |
PRIMARY KEY (`participant_id`) |
|
609 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
610 |
||
611 |
--
|
|
612 |
-- Dumping data for table `lime_participants` |
|
613 |
--
|
|
614 |
||
615 |
||
616 |
-- -------------------------------------------------------- |
|
617 |
||
618 |
--
|
|
619 |
-- Table structure for table `lime_participant_attribute` |
|
620 |
--
|
|
621 |
||
622 |
CREATE TABLE `lime_participant_attribute` ( |
|
623 |
`participant_id` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
624 |
`attribute_id` int(11) NOT NULL, |
|
625 |
`value` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
626 |
PRIMARY KEY (`participant_id`,`attribute_id`) |
|
627 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
628 |
||
629 |
--
|
|
630 |
-- Dumping data for table `lime_participant_attribute` |
|
631 |
--
|
|
632 |
||
633 |
||
634 |
-- -------------------------------------------------------- |
|
635 |
||
636 |
--
|
|
637 |
-- Table structure for table `lime_participant_attribute_names` |
|
638 |
--
|
|
639 |
||
640 |
CREATE TABLE `lime_participant_attribute_names` ( |
|
641 |
`attribute_id` int(11) NOT NULL auto_increment, |
|
642 |
`attribute_type` varchar(4) collate utf8_unicode_ci NOT NULL, |
|
643 |
`visible` char(5) collate utf8_unicode_ci NOT NULL, |
|
644 |
PRIMARY KEY (`attribute_id`,`attribute_type`) |
|
645 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
646 |
||
647 |
--
|
|
648 |
-- Dumping data for table `lime_participant_attribute_names` |
|
649 |
--
|
|
650 |
||
651 |
||
652 |
-- -------------------------------------------------------- |
|
653 |
||
654 |
--
|
|
655 |
-- Table structure for table `lime_participant_attribute_names_lang` |
|
656 |
--
|
|
657 |
||
658 |
CREATE TABLE `lime_participant_attribute_names_lang` ( |
|
659 |
`attribute_id` int(11) NOT NULL, |
|
660 |
`attribute_name` varchar(30) collate utf8_unicode_ci NOT NULL, |
|
661 |
`lang` varchar(20) collate utf8_unicode_ci NOT NULL, |
|
662 |
PRIMARY KEY (`attribute_id`,`lang`) |
|
663 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
664 |
||
665 |
--
|
|
666 |
-- Dumping data for table `lime_participant_attribute_names_lang` |
|
667 |
--
|
|
668 |
||
669 |
||
670 |
-- -------------------------------------------------------- |
|
671 |
||
672 |
--
|
|
673 |
-- Table structure for table `lime_participant_attribute_values` |
|
674 |
--
|
|
675 |
||
676 |
CREATE TABLE `lime_participant_attribute_values` ( |
|
677 |
`value_id` int(11) NOT NULL auto_increment, |
|
678 |
`attribute_id` int(11) NOT NULL, |
|
679 |
`value` varchar(20) collate utf8_unicode_ci NOT NULL, |
|
680 |
PRIMARY KEY (`value_id`) |
|
681 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
682 |
||
683 |
--
|
|
684 |
-- Dumping data for table `lime_participant_attribute_values` |
|
685 |
--
|
|
686 |
||
687 |
||
688 |
-- -------------------------------------------------------- |
|
689 |
||
690 |
--
|
|
691 |
-- Table structure for table `lime_participant_shares` |
|
692 |
--
|
|
693 |
||
694 |
CREATE TABLE `lime_participant_shares` ( |
|
695 |
`participant_id` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
696 |
`share_uid` int(11) NOT NULL, |
|
697 |
`date_added` datetime NOT NULL, |
|
698 |
`can_edit` varchar(5) collate utf8_unicode_ci NOT NULL, |
|
699 |
PRIMARY KEY (`participant_id`,`share_uid`) |
|
700 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
701 |
||
702 |
--
|
|
703 |
-- Dumping data for table `lime_participant_shares` |
|
704 |
--
|
|
705 |
||
706 |
||
707 |
-- -------------------------------------------------------- |
|
708 |
||
709 |
--
|
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
710 |
-- Table structure for table `lime_questions` |
711 |
--
|
|
712 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
713 |
CREATE TABLE `lime_questions` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
714 |
`qid` int(11) NOT NULL auto_increment, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
715 |
`parent_qid` int(11) NOT NULL default '0', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
716 |
`sid` int(11) NOT NULL default '0', |
717 |
`gid` int(11) NOT NULL default '0', |
|
718 |
`type` char(1) collate utf8_unicode_ci NOT NULL default 'T', |
|
719 |
`title` varchar(20) collate utf8_unicode_ci NOT NULL default '', |
|
720 |
`question` text collate utf8_unicode_ci NOT NULL, |
|
721 |
`preg` text collate utf8_unicode_ci, |
|
722 |
`help` text collate utf8_unicode_ci, |
|
723 |
`other` char(1) collate utf8_unicode_ci NOT NULL default 'N', |
|
724 |
`mandatory` char(1) collate utf8_unicode_ci default NULL, |
|
725 |
`question_order` int(11) NOT NULL, |
|
726 |
`language` varchar(20) collate utf8_unicode_ci NOT NULL default 'en', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
727 |
`scale_id` tinyint(4) NOT NULL default '0', |
728 |
`same_default` tinyint(4) NOT NULL default '0' COMMENT 'Saves if user set to use the same default value across languages in default options dialog', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
729 |
`relevance` text collate utf8_unicode_ci, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
730 |
PRIMARY KEY (`qid`,`language`), |
731 |
KEY `questions_idx2` (`sid`), |
|
732 |
KEY `questions_idx3` (`gid`), |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
733 |
KEY `questions_idx4` (`type`), |
734 |
KEY `parent_qid_idx` (`parent_qid`) |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
735 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
736 |
||
737 |
--
|
|
738 |
-- Dumping data for table `lime_questions` |
|
739 |
--
|
|
740 |
||
741 |
||
742 |
-- -------------------------------------------------------- |
|
743 |
||
744 |
--
|
|
745 |
-- Table structure for table `lime_question_attributes` |
|
746 |
--
|
|
747 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
748 |
CREATE TABLE `lime_question_attributes` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
749 |
`qaid` int(11) NOT NULL auto_increment, |
750 |
`qid` int(11) NOT NULL default '0', |
|
751 |
`attribute` varchar(50) collate utf8_unicode_ci default NULL, |
|
752 |
`value` text collate utf8_unicode_ci, |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
753 |
`language` varchar(20) collate utf8_unicode_ci default NULL, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
754 |
PRIMARY KEY (`qaid`), |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
755 |
KEY `question_attributes_idx2` (`qid`), |
756 |
KEY `question_attributes_idx3` (`attribute`) |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
757 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
758 |
||
759 |
--
|
|
760 |
-- Dumping data for table `lime_question_attributes` |
|
761 |
--
|
|
762 |
||
763 |
||
764 |
-- -------------------------------------------------------- |
|
765 |
||
766 |
--
|
|
767 |
-- Table structure for table `lime_quota` |
|
768 |
--
|
|
769 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
770 |
CREATE TABLE `lime_quota` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
771 |
`id` int(11) NOT NULL auto_increment, |
772 |
`sid` int(11) default NULL, |
|
773 |
`name` varchar(255) collate utf8_unicode_ci default NULL, |
|
774 |
`qlimit` int(8) default NULL, |
|
775 |
`action` int(2) default NULL, |
|
776 |
`active` int(1) NOT NULL default '1', |
|
777 |
`autoload_url` int(1) NOT NULL default '0', |
|
778 |
PRIMARY KEY (`id`), |
|
779 |
KEY `quota_idx2` (`sid`) |
|
780 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
781 |
||
782 |
--
|
|
783 |
-- Dumping data for table `lime_quota` |
|
784 |
--
|
|
785 |
||
786 |
||
787 |
-- -------------------------------------------------------- |
|
788 |
||
789 |
--
|
|
790 |
-- Table structure for table `lime_quota_languagesettings` |
|
791 |
--
|
|
792 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
793 |
CREATE TABLE `lime_quota_languagesettings` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
794 |
`quotals_id` int(11) NOT NULL auto_increment, |
795 |
`quotals_quota_id` int(11) NOT NULL default '0', |
|
796 |
`quotals_language` varchar(45) collate utf8_unicode_ci NOT NULL default 'en', |
|
797 |
`quotals_name` varchar(255) collate utf8_unicode_ci default NULL, |
|
798 |
`quotals_message` text collate utf8_unicode_ci NOT NULL, |
|
799 |
`quotals_url` varchar(255) collate utf8_unicode_ci default NULL, |
|
800 |
`quotals_urldescrip` varchar(255) collate utf8_unicode_ci default NULL, |
|
801 |
PRIMARY KEY (`quotals_id`) |
|
802 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
803 |
||
804 |
--
|
|
805 |
-- Dumping data for table `lime_quota_languagesettings` |
|
806 |
--
|
|
807 |
||
808 |
||
809 |
-- -------------------------------------------------------- |
|
810 |
||
811 |
--
|
|
812 |
-- Table structure for table `lime_quota_members` |
|
813 |
--
|
|
814 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
815 |
CREATE TABLE `lime_quota_members` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
816 |
`id` int(11) NOT NULL auto_increment, |
817 |
`sid` int(11) default NULL, |
|
818 |
`qid` int(11) default NULL, |
|
819 |
`quota_id` int(11) default NULL, |
|
820 |
`code` varchar(11) collate utf8_unicode_ci default NULL, |
|
821 |
PRIMARY KEY (`id`), |
|
822 |
UNIQUE KEY `sid` (`sid`,`qid`,`quota_id`,`code`) |
|
823 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
824 |
||
825 |
--
|
|
826 |
-- Dumping data for table `lime_quota_members` |
|
827 |
--
|
|
828 |
||
829 |
||
830 |
-- -------------------------------------------------------- |
|
831 |
||
832 |
--
|
|
833 |
-- Table structure for table `lime_saved_control` |
|
834 |
--
|
|
835 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
836 |
CREATE TABLE `lime_saved_control` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
837 |
`scid` int(11) NOT NULL auto_increment, |
838 |
`sid` int(11) NOT NULL default '0', |
|
839 |
`srid` int(11) NOT NULL default '0', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
840 |
`identifier` bigint(20) NOT NULL, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
841 |
`access_code` text collate utf8_unicode_ci NOT NULL, |
842 |
`email` varchar(320) collate utf8_unicode_ci default NULL, |
|
843 |
`ip` text collate utf8_unicode_ci NOT NULL, |
|
844 |
`saved_thisstep` text collate utf8_unicode_ci NOT NULL, |
|
845 |
`status` char(1) collate utf8_unicode_ci NOT NULL default '', |
|
846 |
`saved_date` datetime NOT NULL, |
|
847 |
`refurl` text collate utf8_unicode_ci, |
|
848 |
PRIMARY KEY (`scid`), |
|
232
by azammitdcarf
Added database optimisations and keys |
849 |
KEY `saved_control_idx2` (`sid`), |
850 |
KEY `identifier` (`identifier`), |
|
851 |
KEY `srid` (`srid`) |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
852 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
853 |
||
854 |
--
|
|
855 |
-- Dumping data for table `lime_saved_control` |
|
856 |
--
|
|
857 |
||
858 |
||
859 |
-- -------------------------------------------------------- |
|
860 |
||
861 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
862 |
-- Table structure for table `lime_sessions` |
863 |
--
|
|
864 |
||
865 |
CREATE TABLE `lime_sessions` ( |
|
866 |
`sesskey` varchar(64) collate utf8_unicode_ci NOT NULL default '', |
|
867 |
`expiry` datetime NOT NULL, |
|
868 |
`expireref` varchar(250) collate utf8_unicode_ci default '', |
|
869 |
`created` datetime NOT NULL, |
|
870 |
`modified` datetime NOT NULL, |
|
871 |
`sessdata` longtext collate utf8_unicode_ci, |
|
872 |
PRIMARY KEY (`sesskey`), |
|
873 |
KEY `sess2_expiry` (`expiry`), |
|
874 |
KEY `sess2_expireref` (`expireref`) |
|
875 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
876 |
||
877 |
--
|
|
878 |
-- Dumping data for table `lime_sessions` |
|
879 |
--
|
|
880 |
||
881 |
||
882 |
-- -------------------------------------------------------- |
|
883 |
||
884 |
--
|
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
885 |
-- Table structure for table `lime_settings_global` |
886 |
--
|
|
887 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
888 |
CREATE TABLE `lime_settings_global` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
889 |
`stg_name` varchar(50) collate utf8_unicode_ci NOT NULL default '', |
890 |
`stg_value` varchar(255) collate utf8_unicode_ci NOT NULL default '', |
|
891 |
PRIMARY KEY (`stg_name`) |
|
892 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
893 |
||
894 |
--
|
|
895 |
-- Dumping data for table `lime_settings_global` |
|
896 |
--
|
|
897 |
||
285.1.35
by Adam Zammit
Updated database schema for new features |
898 |
INSERT INTO `lime_settings_global` (`stg_name`, `stg_value`) VALUES('DBVersion', '155.6'); |
899 |
INSERT INTO `lime_settings_global` (`stg_name`, `stg_value`) VALUES('SessionName', 'ls28629164789259281352'); |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
900 |
|
901 |
-- -------------------------------------------------------- |
|
902 |
||
903 |
--
|
|
904 |
-- Table structure for table `lime_surveys` |
|
905 |
--
|
|
906 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
907 |
CREATE TABLE `lime_surveys` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
908 |
`sid` int(11) NOT NULL, |
909 |
`owner_id` int(11) NOT NULL, |
|
910 |
`admin` varchar(50) collate utf8_unicode_ci default NULL, |
|
911 |
`active` char(1) collate utf8_unicode_ci NOT NULL default 'N', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
912 |
`expires` datetime default NULL, |
913 |
`startdate` datetime default NULL, |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
914 |
`adminemail` varchar(320) collate utf8_unicode_ci default NULL, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
915 |
`anonymized` char(1) collate utf8_unicode_ci NOT NULL default 'N', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
916 |
`faxto` varchar(20) collate utf8_unicode_ci default NULL, |
917 |
`format` char(1) collate utf8_unicode_ci default NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
918 |
`savetimings` char(1) collate utf8_unicode_ci default 'N', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
919 |
`template` varchar(100) collate utf8_unicode_ci default 'default', |
920 |
`language` varchar(50) collate utf8_unicode_ci default NULL, |
|
921 |
`additional_languages` varchar(255) collate utf8_unicode_ci default NULL, |
|
922 |
`datestamp` char(1) collate utf8_unicode_ci default 'N', |
|
923 |
`usecookie` char(1) collate utf8_unicode_ci default 'N', |
|
924 |
`allowregister` char(1) collate utf8_unicode_ci default 'N', |
|
925 |
`allowsave` char(1) collate utf8_unicode_ci default 'Y', |
|
926 |
`autonumber_start` bigint(11) default '0', |
|
927 |
`autoredirect` char(1) collate utf8_unicode_ci default 'N', |
|
928 |
`allowprev` char(1) collate utf8_unicode_ci default 'Y', |
|
929 |
`printanswers` char(1) collate utf8_unicode_ci default 'N', |
|
930 |
`ipaddr` char(1) collate utf8_unicode_ci default 'N', |
|
931 |
`refurl` char(1) collate utf8_unicode_ci default 'N', |
|
932 |
`datecreated` date default NULL, |
|
933 |
`publicstatistics` char(1) collate utf8_unicode_ci default 'N', |
|
934 |
`publicgraphs` char(1) collate utf8_unicode_ci default 'N', |
|
935 |
`listpublic` char(1) collate utf8_unicode_ci default 'N', |
|
936 |
`htmlemail` char(1) collate utf8_unicode_ci default 'N', |
|
937 |
`tokenanswerspersistence` char(1) collate utf8_unicode_ci default 'N', |
|
938 |
`assessments` char(1) collate utf8_unicode_ci default 'N', |
|
939 |
`usecaptcha` char(1) collate utf8_unicode_ci default 'N', |
|
940 |
`usetokens` char(1) collate utf8_unicode_ci default 'N', |
|
941 |
`bounce_email` varchar(320) collate utf8_unicode_ci default NULL, |
|
942 |
`attributedescriptions` text collate utf8_unicode_ci, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
943 |
`emailresponseto` text collate utf8_unicode_ci, |
944 |
`emailnotificationto` text collate utf8_unicode_ci, |
|
945 |
`tokenlength` tinyint(2) default '15', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
946 |
`showxquestions` char(1) collate utf8_unicode_ci default 'Y', |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
947 |
`showgroupinfo` char(1) collate utf8_unicode_ci default 'B', |
948 |
`shownoanswer` char(1) collate utf8_unicode_ci default 'Y', |
|
949 |
`showqnumcode` char(1) collate utf8_unicode_ci default 'X', |
|
950 |
`bouncetime` bigint(20) default NULL, |
|
951 |
`bounceprocessing` varchar(1) collate utf8_unicode_ci default 'N', |
|
952 |
`bounceaccounttype` varchar(4) collate utf8_unicode_ci default NULL, |
|
953 |
`bounceaccounthost` varchar(200) collate utf8_unicode_ci default NULL, |
|
954 |
`bounceaccountpass` varchar(100) collate utf8_unicode_ci default NULL, |
|
955 |
`bounceaccountencryption` varchar(3) collate utf8_unicode_ci default NULL, |
|
956 |
`bounceaccountuser` varchar(200) collate utf8_unicode_ci default NULL, |
|
957 |
`showwelcome` char(1) collate utf8_unicode_ci default 'Y', |
|
958 |
`showprogress` char(1) collate utf8_unicode_ci default 'Y', |
|
959 |
`allowjumps` char(1) collate utf8_unicode_ci default 'N', |
|
960 |
`navigationdelay` tinyint(2) default '0', |
|
961 |
`nokeyboard` char(1) collate utf8_unicode_ci default 'N', |
|
962 |
`alloweditaftercompletion` char(1) collate utf8_unicode_ci default 'N', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
963 |
`googleanalyticsstyle` char(1) collate utf8_unicode_ci default NULL, |
964 |
`googleanalyticsapikey` varchar(25) collate utf8_unicode_ci default NULL, |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
965 |
PRIMARY KEY (`sid`) |
966 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
967 |
||
968 |
--
|
|
969 |
-- Dumping data for table `lime_surveys` |
|
970 |
--
|
|
971 |
||
972 |
||
973 |
-- -------------------------------------------------------- |
|
974 |
||
975 |
--
|
|
976 |
-- Table structure for table `lime_surveys_languagesettings` |
|
977 |
--
|
|
978 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
979 |
CREATE TABLE `lime_surveys_languagesettings` ( |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
980 |
`surveyls_survey_id` int(11) NOT NULL default '0', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
981 |
`surveyls_language` varchar(45) collate utf8_unicode_ci NOT NULL default 'en', |
982 |
`surveyls_title` varchar(200) collate utf8_unicode_ci NOT NULL, |
|
983 |
`surveyls_description` text collate utf8_unicode_ci, |
|
984 |
`surveyls_welcometext` text collate utf8_unicode_ci, |
|
985 |
`surveyls_endtext` text collate utf8_unicode_ci, |
|
986 |
`surveyls_url` varchar(255) collate utf8_unicode_ci default NULL, |
|
987 |
`surveyls_urldescription` varchar(255) collate utf8_unicode_ci default NULL, |
|
988 |
`surveyls_email_invite_subj` varchar(255) collate utf8_unicode_ci default NULL, |
|
989 |
`surveyls_email_invite` text collate utf8_unicode_ci, |
|
990 |
`surveyls_email_remind_subj` varchar(255) collate utf8_unicode_ci default NULL, |
|
991 |
`surveyls_email_remind` text collate utf8_unicode_ci, |
|
992 |
`surveyls_email_register_subj` varchar(255) collate utf8_unicode_ci default NULL, |
|
993 |
`surveyls_email_register` text collate utf8_unicode_ci, |
|
994 |
`surveyls_email_confirm_subj` varchar(255) collate utf8_unicode_ci default NULL, |
|
995 |
`surveyls_email_confirm` text collate utf8_unicode_ci, |
|
996 |
`surveyls_dateformat` int(10) unsigned NOT NULL default '1', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
997 |
`email_admin_notification_subj` varchar(255) collate utf8_unicode_ci default NULL, |
998 |
`email_admin_notification` text collate utf8_unicode_ci, |
|
999 |
`email_admin_responses_subj` varchar(255) collate utf8_unicode_ci default NULL, |
|
1000 |
`email_admin_responses` text collate utf8_unicode_ci, |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1001 |
`surveyls_numberformat` int(11) NOT NULL default '0', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1002 |
PRIMARY KEY (`surveyls_survey_id`,`surveyls_language`) |
1003 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1004 |
||
1005 |
--
|
|
1006 |
-- Dumping data for table `lime_surveys_languagesettings` |
|
1007 |
--
|
|
1008 |
||
1009 |
||
1010 |
-- -------------------------------------------------------- |
|
1011 |
||
1012 |
--
|
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1013 |
-- Table structure for table `lime_survey_links` |
1014 |
--
|
|
1015 |
||
1016 |
CREATE TABLE `lime_survey_links` ( |
|
1017 |
`participant_id` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
1018 |
`token_id` int(11) NOT NULL, |
|
1019 |
`survey_id` int(11) NOT NULL, |
|
1020 |
`date_created` datetime NOT NULL, |
|
1021 |
PRIMARY KEY (`participant_id`,`token_id`,`survey_id`) |
|
1022 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1023 |
||
1024 |
--
|
|
1025 |
-- Dumping data for table `lime_survey_links` |
|
1026 |
--
|
|
1027 |
||
1028 |
||
1029 |
-- -------------------------------------------------------- |
|
1030 |
||
1031 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1032 |
-- Table structure for table `lime_survey_permissions` |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1033 |
--
|
1034 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1035 |
CREATE TABLE `lime_survey_permissions` ( |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1036 |
`sid` int(11) NOT NULL, |
1037 |
`uid` int(11) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1038 |
`permission` varchar(20) collate utf8_unicode_ci NOT NULL, |
1039 |
`create_p` tinyint(1) NOT NULL default '0', |
|
1040 |
`read_p` tinyint(1) NOT NULL default '0', |
|
1041 |
`update_p` tinyint(1) NOT NULL default '0', |
|
1042 |
`delete_p` tinyint(1) NOT NULL default '0', |
|
1043 |
`import_p` tinyint(1) NOT NULL default '0', |
|
1044 |
`export_p` tinyint(1) NOT NULL default '0', |
|
1045 |
PRIMARY KEY (`sid`,`uid`,`permission`) |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1046 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1047 |
||
1048 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1049 |
-- Dumping data for table `lime_survey_permissions` |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1050 |
--
|
1051 |
||
1052 |
||
1053 |
-- -------------------------------------------------------- |
|
1054 |
||
1055 |
--
|
|
1056 |
-- Table structure for table `lime_templates` |
|
1057 |
--
|
|
1058 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1059 |
CREATE TABLE `lime_templates` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1060 |
`folder` varchar(255) collate utf8_unicode_ci NOT NULL, |
1061 |
`creator` int(11) NOT NULL, |
|
1062 |
PRIMARY KEY (`folder`) |
|
1063 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1064 |
||
1065 |
--
|
|
1066 |
-- Dumping data for table `lime_templates` |
|
1067 |
--
|
|
1068 |
||
1069 |
||
1070 |
-- -------------------------------------------------------- |
|
1071 |
||
1072 |
--
|
|
1073 |
-- Table structure for table `lime_templates_rights` |
|
1074 |
--
|
|
1075 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1076 |
CREATE TABLE `lime_templates_rights` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1077 |
`uid` int(11) NOT NULL, |
1078 |
`folder` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1079 |
`use` int(1) NOT NULL, |
|
1080 |
PRIMARY KEY (`uid`,`folder`) |
|
1081 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1082 |
||
1083 |
--
|
|
1084 |
-- Dumping data for table `lime_templates_rights` |
|
1085 |
--
|
|
1086 |
||
1087 |
||
1088 |
-- -------------------------------------------------------- |
|
1089 |
||
1090 |
--
|
|
1091 |
-- Table structure for table `lime_users` |
|
1092 |
--
|
|
1093 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1094 |
CREATE TABLE `lime_users` ( |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1095 |
`uid` int(11) NOT NULL auto_increment, |
1096 |
`users_name` varchar(64) collate utf8_unicode_ci NOT NULL default '', |
|
1097 |
`password` blob NOT NULL, |
|
1098 |
`full_name` varchar(50) collate utf8_unicode_ci NOT NULL, |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1099 |
`parent_id` int(11) NOT NULL, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1100 |
`lang` varchar(20) collate utf8_unicode_ci default NULL, |
1101 |
`email` varchar(320) collate utf8_unicode_ci default NULL, |
|
1102 |
`create_survey` tinyint(1) NOT NULL default '0', |
|
1103 |
`create_user` tinyint(1) NOT NULL default '0', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1104 |
`participant_panel` tinyint(1) NOT NULL default '0', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1105 |
`delete_user` tinyint(1) NOT NULL default '0', |
1106 |
`superadmin` tinyint(1) NOT NULL default '0', |
|
1107 |
`configurator` tinyint(1) NOT NULL default '0', |
|
1108 |
`manage_template` tinyint(1) NOT NULL default '0', |
|
1109 |
`manage_label` tinyint(1) NOT NULL default '0', |
|
1110 |
`htmleditormode` varchar(7) collate utf8_unicode_ci default 'default', |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1111 |
`templateeditormode` varchar(7) collate utf8_unicode_ci default 'default', |
1112 |
`questionselectormode` varchar(7) collate utf8_unicode_ci default 'default', |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1113 |
`one_time_pw` blob, |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1114 |
`dateformat` int(11) NOT NULL default '1', |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1115 |
PRIMARY KEY (`uid`), |
1116 |
UNIQUE KEY `users_name` (`users_name`) |
|
1117 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1118 |
||
1119 |
--
|
|
1120 |
-- Dumping data for table `lime_users` |
|
1121 |
--
|
|
1122 |
||
285.1.35
by Adam Zammit
Updated database schema for new features |
1123 |
INSERT INTO `lime_users` (`uid`, `users_name`, `password`, `full_name`, `parent_id`, `lang`, `email`, `create_survey`, `create_user`, `participant_panel`, `delete_user`, `superadmin`, `configurator`, `manage_template`, `manage_label`, `htmleditormode`, `templateeditormode`, `questionselectormode`, `one_time_pw`, `dateformat`) VALUES(1, 'admin', 0x35653838343839386461323830343731353164306535366638646336323932373733363033643064366161626264643632613131656637323164313534326438, 'Your Name', 0, 'en', 'your-email@example.net', 1, 1, 0, 1, 1, 1, 1, 1, 'default', 'default', 'default', NULL, 1); |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1124 |
|
1125 |
-- -------------------------------------------------------- |
|
1126 |
||
1127 |
--
|
|
1128 |
-- Table structure for table `lime_user_groups` |
|
1129 |
--
|
|
1130 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1131 |
CREATE TABLE `lime_user_groups` ( |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1132 |
`ugid` int(11) NOT NULL auto_increment, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1133 |
`name` varchar(20) collate utf8_unicode_ci NOT NULL, |
1134 |
`description` text collate utf8_unicode_ci NOT NULL, |
|
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1135 |
`owner_id` int(11) NOT NULL, |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1136 |
PRIMARY KEY (`ugid`), |
1137 |
UNIQUE KEY `name` (`name`) |
|
1138 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1139 |
||
1140 |
--
|
|
1141 |
-- Dumping data for table `lime_user_groups` |
|
1142 |
--
|
|
1143 |
||
1144 |
||
1145 |
-- -------------------------------------------------------- |
|
1146 |
||
1147 |
--
|
|
1148 |
-- Table structure for table `lime_user_in_groups` |
|
1149 |
--
|
|
1150 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1151 |
CREATE TABLE `lime_user_in_groups` ( |
280
by azammitdcarf
Merging the updated Limesurvey 1.92+ branch of queXS to trunk |
1152 |
`ugid` int(11) NOT NULL, |
1153 |
`uid` int(11) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1154 |
PRIMARY KEY (`ugid`,`uid`) |
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1155 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1156 |
||
1157 |
--
|
|
1158 |
-- Dumping data for table `lime_user_in_groups` |
|
1159 |
--
|
|
1160 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1161 |
|
212
by azammitdcarf
Added limesurvey structure to database file to reduce installation steps |
1162 |
-- -------------------------------------------------------- |
1163 |
||
1164 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
1165 |
-- Table structure for table `operator` |
1166 |
--
|
|
1167 |
||
1168 |
CREATE TABLE `operator` ( |
|
1169 |
`operator_id` bigint(20) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1170 |
`username` varchar(255) collate utf8_unicode_ci NOT NULL, |
1171 |
`firstName` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1172 |
`lastName` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1173 |
`extension` varchar(10) collate utf8_unicode_ci NOT NULL, |
|
1174 |
`extension_password` varchar(255) collate utf8_unicode_ci default NULL, |
|
1175 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1176 |
`enabled` tinyint(1) NOT NULL default '1', |
96
by azammitdcarf
VoIP is done on an operator by operator basis |
1177 |
`voip` tinyint(1) NOT NULL default '1', |
125
by azammitdcarf
VoIP status is now part of VoIP monitoring so we don't query the Asterisk server often |
1178 |
`voip_status` tinyint(1) NOT NULL default '0', |
221
by azammitdcarf
New feature: Assign the next case to an operator specifically using the administrative functions |
1179 |
`next_case_id` bigint(20) default NULL, |
298.1.63
by Adam Zammit
Added chat details to operator list and editing |
1180 |
`chat_enable` tinyint(1) default '0', |
1181 |
`chat_user` varchar(255) collate utf8_unicode_ci default NULL, |
|
1182 |
`chat_password` varchar(255) collate utf8_unicode_ci default NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1183 |
PRIMARY KEY (`operator_id`), |
1184 |
UNIQUE KEY `username` (`username`), |
|
1185 |
UNIQUE KEY `extension` (`extension`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1186 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1187 |
|
1188 |
--
|
|
1189 |
-- Dumping data for table `operator` |
|
1190 |
--
|
|
1191 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1192 |
|
5
by azammitdcarf
Import from DCARF SVN |
1193 |
-- -------------------------------------------------------- |
1194 |
||
1195 |
--
|
|
1196 |
-- Table structure for table `operator_questionnaire` |
|
1197 |
--
|
|
1198 |
||
1199 |
CREATE TABLE `operator_questionnaire` ( |
|
1200 |
`operator_id` bigint(20) NOT NULL, |
|
1201 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1202 |
PRIMARY KEY (`operator_id`,`questionnaire_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1203 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1204 |
|
1205 |
--
|
|
1206 |
-- Dumping data for table `operator_questionnaire` |
|
1207 |
--
|
|
1208 |
||
1209 |
||
1210 |
-- -------------------------------------------------------- |
|
1211 |
||
1212 |
--
|
|
1213 |
-- Table structure for table `operator_skill` |
|
1214 |
--
|
|
1215 |
||
1216 |
CREATE TABLE `operator_skill` ( |
|
1217 |
`operator_id` bigint(20) NOT NULL, |
|
1218 |
`outcome_type_id` int(11) NOT NULL, |
|
1219 |
PRIMARY KEY (`operator_id`,`outcome_type_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1220 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1221 |
|
1222 |
--
|
|
1223 |
-- Dumping data for table `operator_skill` |
|
1224 |
--
|
|
1225 |
||
1226 |
||
1227 |
-- -------------------------------------------------------- |
|
1228 |
||
1229 |
--
|
|
1230 |
-- Table structure for table `outcome` |
|
1231 |
--
|
|
1232 |
||
1233 |
CREATE TABLE `outcome` ( |
|
1234 |
`outcome_id` int(11) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1235 |
`aapor_id` char(6) collate utf8_unicode_ci NOT NULL, |
1236 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1237 |
`default_delay_minutes` bigint(20) NOT NULL, |
1238 |
`outcome_type_id` int(11) NOT NULL default '1', |
|
1239 |
`tryanother` tinyint(1) NOT NULL default '1' COMMENT 'Whether to try the next number on the list', |
|
1240 |
`contacted` tinyint(1) NOT NULL default '1' COMMENT 'Whether a person was contacted', |
|
1241 |
`tryagain` tinyint(1) NOT NULL default '1' COMMENT 'Whether to try this number ever again', |
|
1242 |
`eligible` tinyint(1) NOT NULL default '1' COMMENT 'If the respondent is eligible to participate', |
|
1243 |
`require_note` tinyint(1) NOT NULL default '0' COMMENT 'Whether to require a note to be entered', |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1244 |
`calc` char(2) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1245 |
PRIMARY KEY (`outcome_id`), |
1246 |
KEY `calc` (`calc`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1247 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1248 |
|
1249 |
--
|
|
1250 |
-- Dumping data for table `outcome` |
|
1251 |
--
|
|
1252 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1253 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(1, '3.11', 'Not attempted or worked', 0, 1, 1, 0, 1, 0, 0, 'UH'); |
1254 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(2, '3.13', 'No answer', 180, 1, 1, 0, 1, 1, 0, 'UH'); |
|
1255 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(3, '3.16', 'Technical phone problems', 180, 1, 1, 0, 1, 0, 0, 'UH'); |
|
1256 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(4, '2.34', 'Other, Referred to Supervisor (Eligible)', 0, 2, 0, 1, 1, 1, 1, 'O'); |
|
1257 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(5, '3.91', 'Other, Referred to Supervisor (Unknown eligibility)', 0, 2, 0, 0, 1, 0, 1, 'UO'); |
|
1258 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(6, '2.111a', 'Soft Refusal, Other', 10080, 3, 0, 1, 1, 1, 1, 'R'); |
|
1259 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(7, '2.111b', 'Hard Refusal, Other', 10080, 3, 0, 1, 1, 1, 1, 'R'); |
|
1260 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(8, '2.112a', 'Soft Refusal, Respondent', 10080, 3, 0, 1, 1, 1, 1, 'R'); |
|
1261 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(9, '2.112b', 'Hard Refusal, Respondent', 10080, 3, 0, 1, 1, 1, 1, 'R'); |
|
1262 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(10, '1.1', 'Complete', 0, 4, 0, 1, 1, 1, 0, 'I'); |
|
1263 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(11, '2.112', 'Known respondent refusal', 0, 4, 0, 1, 1, 1, 0, 'R'); |
|
1264 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(12, '2.111', 'Household-level refusal', 0, 4, 0, 1, 1, 1, 0, 'R'); |
|
1265 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(13, '2.112c', 'Broken appointment (Implicit refusal)', 10080, 3, 1, 0, 1, 1, 0, 'R'); |
|
1266 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(14, '4.32', 'Disconnected number', 0, 4, 1, 0, 0, 0, 0, ''); |
|
1267 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(15, '4.20', 'Fax/data line', 0, 4, 1, 1, 0, 0, 0, ''); |
|
1268 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(16, '4.51', 'Business, government office, other organization', 0, 4, 1, 1, 0, 0, 0, ''); |
|
1269 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(17, '4.70', 'No eligible respondent', 0, 4, 1, 1, 0, 0, 0, ''); |
|
1270 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(18, '2.35a', 'Accidental hang up or temporary phone problem', 0, 1, 1, 1, 1, 1, 0, 'O'); |
|
1271 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(19, '2.12a', 'Definite Appointment - Respondent', 0, 5, 0, 1, 1, 1, 0, 'R'); |
|
1272 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(20, '2.12b', 'Definite Appointment - Other', 0, 5, 0, 1, 1, 1, 0, 'R'); |
|
1273 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(21, '2.13a', 'Unspecified Appointment - Respondent', 0, 5, 0, 1, 1, 1, 0, 'R'); |
|
1274 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(22, '2.13b', 'Unspecified Appointment - Other', 0, 5, 0, 1, 1, 1, 0, 'R'); |
|
1275 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(23, '2.221', 'Household answering machine - Message left', 180, 1, 1, 1, 1, 1, 0, 'NC'); |
|
1276 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(24, '2.222', 'Household answering machine - No message left', 180, 1, 1, 1, 1, 1, 0, 'NC'); |
|
1277 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(25, '2.31', 'Respondent Dead', 0, 4, 0, 1, 0, 1, 0, 'O'); |
|
1278 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(26, '2.32', 'Physically or mentally unable/incompetent', 0, 4, 0, 1, 0, 1, 0, 'O'); |
|
1279 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(27, '2.331', 'Household level language problem', 0, 4, 1, 1, 0, 1, 0, 'O'); |
|
1280 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(28, '2.332', 'Respondent language problem', 0, 4, 0, 1, 0, 1, 0, 'O'); |
|
1281 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(29, '3.14', 'Answering machine - Not a household', 0, 4, 1, 1, 0, 0, 0, 'UH'); |
|
1282 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(30, '4.10', 'Out of sample', 0, 4, 0, 1, 0, 0, 0, ''); |
|
1283 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(31, '2.20', 'Non contact', 180, 1, 1, 1, 1, 1, 0, 'NC'); |
|
1284 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(32, '4.80', 'Quota filled', 0, 4, 0, 1, 0, 0, 0, ''); |
|
1285 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(33, '2.36', 'Miscellaneous - Unavailable for a week', 10080, 1, 0, 1, 1, 1, 0, 'O'); |
|
285.1.35
by Adam Zammit
Updated database schema for new features |
1286 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(40, '1.1', 'Self completed online', 0, 4, 0, 1, 1, 1, 0, 'I'); |
1287 |
INSERT INTO `outcome` (`outcome_id`, `aapor_id`, `description`, `default_delay_minutes`, `outcome_type_id`, `tryanother`, `contacted`, `tryagain`, `eligible`, `require_note`, `calc`) VALUES(41, '2.36', 'Self completion email invitation sent', 10080, 1, 0, 1, 1, 1, 0, 'O'); |
|
5
by azammitdcarf
Import from DCARF SVN |
1288 |
|
1289 |
-- -------------------------------------------------------- |
|
1290 |
||
1291 |
--
|
|
1292 |
-- Table structure for table `outcome_type` |
|
1293 |
--
|
|
1294 |
||
1295 |
CREATE TABLE `outcome_type` ( |
|
1296 |
`outcome_type_id` int(11) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1297 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1298 |
PRIMARY KEY (`outcome_type_id`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1299 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1300 |
|
1301 |
--
|
|
1302 |
-- Dumping data for table `outcome_type` |
|
1303 |
--
|
|
1304 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1305 |
INSERT INTO `outcome_type` (`outcome_type_id`, `description`) VALUES(1, 'Temporary Outcomes (normal cases)'); |
1306 |
INSERT INTO `outcome_type` (`outcome_type_id`, `description`) VALUES(2, 'Supervisor Outcomes (referred to supervisor)'); |
|
1307 |
INSERT INTO `outcome_type` (`outcome_type_id`, `description`) VALUES(3, 'Refusal Outcomes (respondent refused)'); |
|
1308 |
INSERT INTO `outcome_type` (`outcome_type_id`, `description`) VALUES(4, 'Final Outcomes (completed, final refusal, etc)'); |
|
1309 |
INSERT INTO `outcome_type` (`outcome_type_id`, `description`) VALUES(5, 'Appointments'); |
|
5
by azammitdcarf
Import from DCARF SVN |
1310 |
|
1311 |
-- -------------------------------------------------------- |
|
1312 |
||
1313 |
--
|
|
27
by azammitdcarf
Added VoIP watch from browser (executes background PHP file process.php) |
1314 |
-- Table structure for table `process` |
1315 |
--
|
|
1316 |
||
1317 |
CREATE TABLE `process` ( |
|
1318 |
`process_id` bigint(20) NOT NULL auto_increment, |
|
191
by azammitdcarf
Added a "system sort" process which sorts cases and the sample file from enabled questionnaires periodically (based on SYSTEM_SORT_MINUTES config directive). Enabling this may improve performance where there is a large number of interviewers, a large sample or complex quotas as the sort doesn't need to be done for each interviewer at each case. |
1319 |
`type` int(11) NOT NULL default '1', |
27
by azammitdcarf
Added VoIP watch from browser (executes background PHP file process.php) |
1320 |
`start` datetime NOT NULL, |
1321 |
`stop` datetime default NULL, |
|
1322 |
`kill` tinyint(1) NOT NULL default '0', |
|
1323 |
`data` longtext collate utf8_unicode_ci NOT NULL, |
|
1324 |
PRIMARY KEY (`process_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1325 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1326 |
||
1327 |
--
|
|
1328 |
-- Dumping data for table `process` |
|
1329 |
--
|
|
1330 |
||
27
by azammitdcarf
Added VoIP watch from browser (executes background PHP file process.php) |
1331 |
|
1332 |
-- -------------------------------------------------------- |
|
1333 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1334 |
--
|
1335 |
-- Table structure for table `process_log` |
|
1336 |
--
|
|
1337 |
||
208
by azammitdcarf
Added process_log table to database |
1338 |
CREATE TABLE `process_log` ( |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1339 |
`process_log_id` bigint(20) NOT NULL auto_increment, |
1340 |
`process_id` bigint(20) NOT NULL, |
|
1341 |
`datetime` datetime NOT NULL, |
|
1342 |
`data` text collate utf8_unicode_ci NOT NULL, |
|
1343 |
PRIMARY KEY (`process_log_id`), |
|
1344 |
KEY `process_id` (`process_id`) |
|
1345 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1346 |
||
1347 |
--
|
|
1348 |
-- Dumping data for table `process_log` |
|
1349 |
--
|
|
1350 |
||
1351 |
||
1352 |
-- -------------------------------------------------------- |
|
208
by azammitdcarf
Added process_log table to database |
1353 |
|
27
by azammitdcarf
Added VoIP watch from browser (executes background PHP file process.php) |
1354 |
--
|
5
by azammitdcarf
Import from DCARF SVN |
1355 |
-- Table structure for table `questionnaire` |
1356 |
--
|
|
1357 |
||
1358 |
CREATE TABLE `questionnaire` ( |
|
1359 |
`questionnaire_id` bigint(20) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1360 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1361 |
`lime_sid` int(11) NOT NULL, |
1362 |
`restrict_appointments_shifts` tinyint(1) NOT NULL default '1', |
|
1363 |
`restrict_work_shifts` tinyint(1) NOT NULL default '1', |
|
1364 |
`testing` tinyint(1) NOT NULL default '0' COMMENT 'Whether this questionnaire is just for testing', |
|
1365 |
`respondent_selection` tinyint(1) NOT NULL default '1', |
|
99
by azammitdcarf
Changed varchars to text in respondent selection text |
1366 |
`rs_intro` text collate utf8_unicode_ci NOT NULL, |
1367 |
`rs_project_intro` text collate utf8_unicode_ci NOT NULL, |
|
1368 |
`rs_project_end` text collate utf8_unicode_ci NOT NULL, |
|
1369 |
`rs_callback` text collate utf8_unicode_ci NOT NULL, |
|
1370 |
`rs_answeringmachine` text collate utf8_unicode_ci NOT NULL, |
|
147
by azammitdcarf
New feature: Seperate limesurvey instrument for respondent selection |
1371 |
`lime_rs_sid` int(11) default NULL, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1372 |
`info` text collate utf8_unicode_ci, |
285.1.35
by Adam Zammit
Updated database schema for new features |
1373 |
`self_complete` tinyint(1) NOT NULL default '0', |
1374 |
`lime_mode` varchar(64) collate utf8_unicode_ci default NULL COMMENT 'Limesurvey mode for respondent self completion', |
|
1375 |
`lime_template` varchar(128) collate utf8_unicode_ci default NULL COMMENT 'Limesurvey template for respondent self completion', |
|
1376 |
`lime_endurl` varchar(256) collate utf8_unicode_ci default NULL COMMENT 'Forwarding end URL for respondent self completion', |
|
207
by azammitdcarf
Missing comma |
1377 |
`enabled` tinyint(1) NOT NULL default '1', |
5
by azammitdcarf
Import from DCARF SVN |
1378 |
PRIMARY KEY (`questionnaire_id`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1379 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1380 |
|
1381 |
--
|
|
1382 |
-- Dumping data for table `questionnaire` |
|
1383 |
--
|
|
1384 |
||
1385 |
||
1386 |
-- -------------------------------------------------------- |
|
1387 |
||
1388 |
--
|
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1389 |
-- Table structure for table `questionnaire_availability` |
1390 |
--
|
|
1391 |
||
1392 |
CREATE TABLE `questionnaire_availability` ( |
|
1393 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1394 |
`availability_group_id` bigint(20) NOT NULL, |
|
1395 |
PRIMARY KEY (`questionnaire_id`,`availability_group_id`) |
|
1396 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1397 |
||
1398 |
--
|
|
1399 |
-- Dumping data for table `questionnaire_availability` |
|
1400 |
--
|
|
1401 |
||
1402 |
||
1403 |
-- -------------------------------------------------------- |
|
1404 |
||
1405 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
1406 |
-- Table structure for table `questionnaire_prefill` |
1407 |
--
|
|
1408 |
||
1409 |
CREATE TABLE `questionnaire_prefill` ( |
|
1410 |
`questionnaire_prefill_id` bigint(20) NOT NULL auto_increment, |
|
1411 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1412 |
`lime_sgqa` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1413 |
`value` varchar(2048) collate utf8_unicode_ci NOT NULL, |
|
1414 |
PRIMARY KEY (`questionnaire_prefill_id`), |
|
1415 |
KEY `questionnaire_id` (`questionnaire_id`) |
|
1416 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1417 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1418 |
--
|
1419 |
-- Dumping data for table `questionnaire_prefill` |
|
1420 |
--
|
|
1421 |
||
1422 |
||
1423 |
-- -------------------------------------------------------- |
|
1424 |
||
1425 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
1426 |
-- Table structure for table `questionnaire_sample` |
1427 |
--
|
|
1428 |
||
1429 |
CREATE TABLE `questionnaire_sample` ( |
|
1430 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1431 |
`sample_import_id` bigint(20) NOT NULL, |
|
1432 |
`call_max` int(11) NOT NULL default '0', |
|
1433 |
`call_attempt_max` int(11) NOT NULL default '0', |
|
1434 |
`random_select` tinyint(1) NOT NULL default '0', |
|
1435 |
`answering_machine_messages` int(11) NOT NULL default '1', |
|
1436 |
PRIMARY KEY (`questionnaire_id`,`sample_import_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1437 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1438 |
|
1439 |
--
|
|
1440 |
-- Dumping data for table `questionnaire_sample` |
|
1441 |
--
|
|
1442 |
||
140
by azammitdcarf
Merged changes from quota performance branch |
1443 |
|
1444 |
-- -------------------------------------------------------- |
|
1445 |
||
1446 |
--
|
|
1447 |
-- Table structure for table `questionnaire_sample_exclude_priority` |
|
1448 |
--
|
|
1449 |
||
1450 |
CREATE TABLE `questionnaire_sample_exclude_priority` ( |
|
1451 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1452 |
`sample_id` bigint(20) NOT NULL, |
|
1453 |
`exclude` tinyint(1) NOT NULL default '0', |
|
1454 |
`priority` tinyint(3) NOT NULL default '50', |
|
191
by azammitdcarf
Added a "system sort" process which sorts cases and the sample file from enabled questionnaires periodically (based on SYSTEM_SORT_MINUTES config directive). Enabling this may improve performance where there is a large number of interviewers, a large sample or complex quotas as the sort doesn't need to be done for each interviewer at each case. |
1455 |
`sortorder` int(11) default NULL, |
140
by azammitdcarf
Merged changes from quota performance branch |
1456 |
PRIMARY KEY (`questionnaire_id`,`sample_id`), |
1457 |
KEY `exclude` (`exclude`), |
|
1458 |
KEY `priority` (`priority`), |
|
191
by azammitdcarf
Added a "system sort" process which sorts cases and the sample file from enabled questionnaires periodically (based on SYSTEM_SORT_MINUTES config directive). Enabling this may improve performance where there is a large number of interviewers, a large sample or complex quotas as the sort doesn't need to be done for each interviewer at each case. |
1459 |
KEY `questionnaire_id` (`questionnaire_id`), |
1460 |
KEY `sortorder` (`sortorder`) |
|
140
by azammitdcarf
Merged changes from quota performance branch |
1461 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1462 |
||
1463 |
--
|
|
1464 |
-- Dumping data for table `questionnaire_sample_exclude_priority` |
|
1465 |
--
|
|
1466 |
||
1467 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1468 |
-- -------------------------------------------------------- |
1469 |
||
65
by azammitdcarf
Added quota functionality |
1470 |
--
|
1471 |
-- Table structure for table `questionnaire_sample_quota` |
|
1472 |
--
|
|
1473 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1474 |
CREATE TABLE `questionnaire_sample_quota` ( |
65
by azammitdcarf
Added quota functionality |
1475 |
`questionnaire_sample_quota_id` bigint(20) NOT NULL auto_increment, |
1476 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1477 |
`sample_import_id` bigint(20) NOT NULL, |
|
1478 |
`lime_sgqa` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1479 |
`value` varchar(2048) collate utf8_unicode_ci NOT NULL, |
|
1480 |
`comparison` varchar(15) collate utf8_unicode_ci NOT NULL default 'LIKE', |
|
1481 |
`completions` int(11) NOT NULL, |
|
1482 |
`quota_reached` tinyint(1) NOT NULL default '0', |
|
1483 |
PRIMARY KEY (`questionnaire_sample_quota_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1484 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1485 |
||
1486 |
--
|
|
1487 |
-- Dumping data for table `questionnaire_sample_quota` |
|
1488 |
--
|
|
1489 |
||
1490 |
||
1491 |
-- -------------------------------------------------------- |
|
65
by azammitdcarf
Added quota functionality |
1492 |
|
69
by azammitdcarf
Added quota row functionality (ability to assign a quota to remove records by row from a sample) |
1493 |
--
|
1494 |
-- Table structure for table `questionnaire_sample_quota_row` |
|
1495 |
--
|
|
1496 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1497 |
CREATE TABLE `questionnaire_sample_quota_row` ( |
69
by azammitdcarf
Added quota row functionality (ability to assign a quota to remove records by row from a sample) |
1498 |
`questionnaire_sample_quota_row_id` bigint(20) NOT NULL auto_increment, |
1499 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1500 |
`sample_import_id` bigint(20) NOT NULL, |
|
1501 |
`lime_sgqa` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1502 |
`value` varchar(2048) collate utf8_unicode_ci NOT NULL, |
|
1503 |
`comparison` varchar(15) collate utf8_unicode_ci NOT NULL default 'LIKE', |
|
1504 |
`completions` int(11) NOT NULL, |
|
1505 |
`exclude_var` char(128) collate utf8_unicode_ci NOT NULL, |
|
1506 |
`exclude_val` varchar(256) collate utf8_unicode_ci NOT NULL, |
|
1507 |
`quota_reached` tinyint(1) NOT NULL default '0', |
|
144
by azammitdcarf
Added missing row from table for quota performance update |
1508 |
`current_completions` int(11) NOT NULL default '0', |
98
by azammitdcarf
Merged from McMasterReports branch |
1509 |
`description` text collate utf8_unicode_ci NOT NULL, |
146
by azammitdcarf
Quota priority feature added including auto priority calculation (Sponsor: Zimi) |
1510 |
`priority` tinyint(3) NOT NULL default '50' COMMENT 'Priority from 0 - 100', |
1511 |
`autoprioritise` tinyint(1) NOT NULL default '0' COMMENT 'Should this row have it''s priority automatically adjusted to 100 - (completions %)', |
|
69
by azammitdcarf
Added quota row functionality (ability to assign a quota to remove records by row from a sample) |
1512 |
PRIMARY KEY (`questionnaire_sample_quota_row_id`), |
1513 |
KEY `questionnaire_id` (`questionnaire_id`), |
|
1514 |
KEY `sample_import_id` (`sample_import_id`), |
|
1515 |
KEY `exclude_var` (`exclude_var`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1516 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1517 |
||
1518 |
--
|
|
1519 |
-- Dumping data for table `questionnaire_sample_quota_row` |
|
1520 |
--
|
|
69
by azammitdcarf
Added quota row functionality (ability to assign a quota to remove records by row from a sample) |
1521 |
|
5
by azammitdcarf
Import from DCARF SVN |
1522 |
|
1523 |
-- -------------------------------------------------------- |
|
1524 |
||
1525 |
--
|
|
80
by azammitdcarf
Changed method of quota row calculation to be by listing in database |
1526 |
-- Table structure for table `questionnaire_sample_quota_row_exclude` |
1527 |
--
|
|
1528 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1529 |
CREATE TABLE `questionnaire_sample_quota_row_exclude` ( |
80
by azammitdcarf
Changed method of quota row calculation to be by listing in database |
1530 |
`questionnaire_sample_quota_row_id` bigint(20) NOT NULL, |
1531 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1532 |
`sample_id` bigint(20) NOT NULL, |
|
1533 |
PRIMARY KEY (`questionnaire_sample_quota_row_id`,`questionnaire_id`,`sample_id`), |
|
1534 |
KEY `questionnaire_id` (`questionnaire_id`), |
|
1535 |
KEY `sample_id` (`sample_id`) |
|
1536 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1537 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1538 |
--
|
1539 |
-- Dumping data for table `questionnaire_sample_quota_row_exclude` |
|
1540 |
--
|
|
80
by azammitdcarf
Changed method of quota row calculation to be by listing in database |
1541 |
|
1542 |
||
1543 |
-- -------------------------------------------------------- |
|
1544 |
||
1545 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
1546 |
-- Table structure for table `respondent` |
1547 |
--
|
|
1548 |
||
1549 |
CREATE TABLE `respondent` ( |
|
1550 |
`respondent_id` bigint(20) NOT NULL auto_increment, |
|
1551 |
`case_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1552 |
`firstName` varchar(255) collate utf8_unicode_ci NOT NULL, |
1553 |
`lastName` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1554 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1555 |
PRIMARY KEY (`respondent_id`), |
1556 |
KEY `case_id` (`case_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1557 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1558 |
|
1559 |
--
|
|
1560 |
-- Dumping data for table `respondent` |
|
1561 |
--
|
|
1562 |
||
1563 |
||
1564 |
-- -------------------------------------------------------- |
|
1565 |
||
1566 |
--
|
|
1567 |
-- Table structure for table `respondent_not_available` |
|
1568 |
--
|
|
1569 |
||
1570 |
CREATE TABLE `respondent_not_available` ( |
|
1571 |
`respondent_not_available_id` bigint(20) NOT NULL auto_increment, |
|
1572 |
`respondent_id` bigint(20) NOT NULL, |
|
1573 |
`start` datetime NOT NULL, |
|
1574 |
`end` datetime NOT NULL, |
|
1575 |
PRIMARY KEY (`respondent_not_available_id`), |
|
1576 |
KEY `respondent_id` (`respondent_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1577 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1578 |
|
1579 |
--
|
|
1580 |
-- Dumping data for table `respondent_not_available` |
|
1581 |
--
|
|
1582 |
||
1583 |
||
1584 |
-- -------------------------------------------------------- |
|
1585 |
||
1586 |
--
|
|
1587 |
-- Table structure for table `sample` |
|
1588 |
--
|
|
1589 |
||
1590 |
CREATE TABLE `sample` ( |
|
1591 |
`sample_id` bigint(20) NOT NULL auto_increment, |
|
1592 |
`import_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1593 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
1594 |
`phone` char(30) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1595 |
PRIMARY KEY (`sample_id`), |
1596 |
KEY `import_id` (`import_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1597 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1598 |
|
1599 |
--
|
|
1600 |
-- Dumping data for table `sample` |
|
1601 |
--
|
|
1602 |
||
1603 |
||
1604 |
-- -------------------------------------------------------- |
|
1605 |
||
1606 |
--
|
|
1607 |
-- Table structure for table `sample_import` |
|
1608 |
--
|
|
1609 |
||
1610 |
CREATE TABLE `sample_import` ( |
|
1611 |
`sample_import_id` bigint(20) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1612 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1613 |
`call_restrict` tinyint(1) NOT NULL default '1', |
1614 |
`refusal_conversion` tinyint(1) NOT NULL default '1', |
|
288
by Adam Zammit
Merged from internetcomplete |
1615 |
`enabled` tinyint(1) NOT NULL default '1', |
5
by azammitdcarf
Import from DCARF SVN |
1616 |
PRIMARY KEY (`sample_import_id`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1617 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1618 |
|
1619 |
--
|
|
298.1.53
by Adam Zammit
Updated database schema |
1620 |
-- Table structure for table `sample_import_var_restrict` |
5
by azammitdcarf
Import from DCARF SVN |
1621 |
--
|
1622 |
||
298.1.53
by Adam Zammit
Updated database schema |
1623 |
CREATE TABLE `sample_import_var_restrict` ( |
1624 |
`sample_import_id` bigint(20) NOT NULL, |
|
1625 |
`var` char(128) collate utf8_unicode_ci NOT NULL, |
|
1626 |
`restrict` tinyint(1) NOT NULL default '0', |
|
1627 |
PRIMARY KEY (`sample_import_id`,`var`) |
|
1628 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1629 |
|
5
by azammitdcarf
Import from DCARF SVN |
1630 |
-- -------------------------------------------------------- |
1631 |
||
1632 |
--
|
|
1633 |
-- Table structure for table `sample_postcode_timezone` |
|
1634 |
--
|
|
1635 |
||
1636 |
CREATE TABLE `sample_postcode_timezone` ( |
|
1637 |
`val` int(4) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1638 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
1639 |
PRIMARY KEY (`val`) |
|
1640 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1641 |
||
1642 |
--
|
|
1643 |
-- Dumping data for table `sample_postcode_timezone` |
|
1644 |
--
|
|
199
by azammitdcarf
Moved Australian data from base structure file to additional file |
1645 |
|
5
by azammitdcarf
Import from DCARF SVN |
1646 |
|
1647 |
-- -------------------------------------------------------- |
|
1648 |
||
1649 |
--
|
|
1650 |
-- Table structure for table `sample_prefix_timezone` |
|
1651 |
--
|
|
1652 |
||
1653 |
CREATE TABLE `sample_prefix_timezone` ( |
|
285.1.35
by Adam Zammit
Updated database schema for new features |
1654 |
`val` char(10) collate utf8_unicode_ci NOT NULL, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1655 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
1656 |
PRIMARY KEY (`val`) |
|
1657 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1658 |
||
1659 |
--
|
|
1660 |
-- Dumping data for table `sample_prefix_timezone` |
|
1661 |
--
|
|
1662 |
||
1663 |
||
1664 |
-- -------------------------------------------------------- |
|
1665 |
||
1666 |
--
|
|
1667 |
-- Table structure for table `sample_state_timezone` |
|
1668 |
--
|
|
1669 |
||
1670 |
CREATE TABLE `sample_state_timezone` ( |
|
1671 |
`val` varchar(64) collate utf8_unicode_ci NOT NULL, |
|
1672 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
|
1673 |
PRIMARY KEY (`val`) |
|
1674 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
|
1675 |
||
1676 |
--
|
|
1677 |
-- Dumping data for table `sample_state_timezone` |
|
1678 |
--
|
|
5
by azammitdcarf
Import from DCARF SVN |
1679 |
|
1680 |
||
1681 |
-- -------------------------------------------------------- |
|
1682 |
||
1683 |
--
|
|
1684 |
-- Table structure for table `sample_var` |
|
1685 |
--
|
|
1686 |
||
1687 |
CREATE TABLE `sample_var` ( |
|
1688 |
`sample_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1689 |
`var` char(128) collate utf8_unicode_ci NOT NULL, |
1690 |
`val` varchar(256) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1691 |
`type` int(11) NOT NULL, |
1692 |
PRIMARY KEY (`sample_id`,`var`), |
|
1693 |
KEY `sample_id` (`sample_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1694 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1695 |
|
1696 |
--
|
|
1697 |
-- Dumping data for table `sample_var` |
|
1698 |
--
|
|
1699 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1700 |
|
5
by azammitdcarf
Import from DCARF SVN |
1701 |
-- -------------------------------------------------------- |
1702 |
||
1703 |
--
|
|
1704 |
-- Table structure for table `sample_var_type` |
|
1705 |
--
|
|
1706 |
||
1707 |
CREATE TABLE `sample_var_type` ( |
|
1708 |
`type` int(11) NOT NULL auto_increment, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1709 |
`description` varchar(255) collate utf8_unicode_ci NOT NULL, |
1710 |
`table` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
5
by azammitdcarf
Import from DCARF SVN |
1711 |
PRIMARY KEY (`type`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1712 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1713 |
|
1714 |
--
|
|
1715 |
-- Dumping data for table `sample_var_type` |
|
1716 |
--
|
|
1717 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1718 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(1, 'String', ''); |
1719 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(2, 'Phone number', 'sample_prefix_timezone'); |
|
1720 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(3, 'Primary phone number', 'sample_prefix_timezone'); |
|
1721 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(4, 'State', 'sample_state_timezone'); |
|
1722 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(5, 'Postcode', 'sample_postcode_timezone'); |
|
1723 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(6, 'Respondent first name', ''); |
|
1724 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(7, 'Respondent last name', ''); |
|
285.1.35
by Adam Zammit
Updated database schema for new features |
1725 |
INSERT INTO `sample_var_type` (`type`, `description`, `table`) VALUES(8, 'Email address', ''); |
5
by azammitdcarf
Import from DCARF SVN |
1726 |
|
1727 |
-- -------------------------------------------------------- |
|
1728 |
||
1729 |
--
|
|
1730 |
-- Table structure for table `sessions2` |
|
1731 |
--
|
|
1732 |
||
1733 |
CREATE TABLE `sessions2` ( |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1734 |
`sesskey` varchar(64) collate utf8_unicode_ci NOT NULL default '', |
5
by azammitdcarf
Import from DCARF SVN |
1735 |
`expiry` datetime NOT NULL, |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1736 |
`expireref` varchar(250) collate utf8_unicode_ci default '', |
5
by azammitdcarf
Import from DCARF SVN |
1737 |
`created` datetime NOT NULL, |
1738 |
`modified` datetime NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1739 |
`sessdata` longtext collate utf8_unicode_ci, |
5
by azammitdcarf
Import from DCARF SVN |
1740 |
PRIMARY KEY (`sesskey`), |
1741 |
KEY `sess2_expiry` (`expiry`), |
|
1742 |
KEY `sess2_expireref` (`expireref`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1743 |
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1744 |
||
1745 |
--
|
|
1746 |
-- Dumping data for table `sessions2` |
|
1747 |
--
|
|
1748 |
||
5
by azammitdcarf
Import from DCARF SVN |
1749 |
|
171
by azammitdcarf
Can define centre and project information in administrative menu |
1750 |
-- -------------------------------------------------------- |
1751 |
||
1752 |
--
|
|
1753 |
-- Table structure for table `setting` |
|
1754 |
--
|
|
1755 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1756 |
CREATE TABLE `setting` ( |
171
by azammitdcarf
Can define centre and project information in administrative menu |
1757 |
`setting_id` int(11) NOT NULL auto_increment, |
1758 |
`field` varchar(255) collate utf8_unicode_ci NOT NULL, |
|
1759 |
`value` text collate utf8_unicode_ci NOT NULL, |
|
1760 |
PRIMARY KEY (`setting_id`), |
|
1761 |
UNIQUE KEY `field` (`field`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1762 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Serialised table of settings'; |
1763 |
||
1764 |
--
|
|
1765 |
-- Dumping data for table `setting` |
|
1766 |
--
|
|
1767 |
||
5
by azammitdcarf
Import from DCARF SVN |
1768 |
|
1769 |
-- -------------------------------------------------------- |
|
1770 |
||
1771 |
--
|
|
1772 |
-- Table structure for table `shift` |
|
1773 |
--
|
|
1774 |
||
1775 |
CREATE TABLE `shift` ( |
|
1776 |
`shift_id` bigint(20) NOT NULL auto_increment, |
|
1777 |
`questionnaire_id` bigint(20) NOT NULL, |
|
1778 |
`start` datetime NOT NULL, |
|
1779 |
`end` datetime NOT NULL, |
|
1780 |
PRIMARY KEY (`shift_id`), |
|
1781 |
KEY `questionnaire_id` (`questionnaire_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1782 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1783 |
|
1784 |
--
|
|
1785 |
-- Dumping data for table `shift` |
|
1786 |
--
|
|
1787 |
||
1788 |
||
1789 |
-- -------------------------------------------------------- |
|
1790 |
||
1791 |
--
|
|
1792 |
-- Table structure for table `shift_report` |
|
1793 |
--
|
|
1794 |
||
1795 |
CREATE TABLE `shift_report` ( |
|
1796 |
`shift_report_id` bigint(20) NOT NULL auto_increment, |
|
1797 |
`shift_id` bigint(20) NOT NULL, |
|
1798 |
`operator_id` bigint(20) NOT NULL, |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1799 |
`report` text collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1800 |
`datetime` datetime NOT NULL, |
1801 |
PRIMARY KEY (`shift_report_id`), |
|
1802 |
KEY `shift_id` (`shift_id`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1803 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1804 |
|
1805 |
--
|
|
1806 |
-- Dumping data for table `shift_report` |
|
1807 |
--
|
|
1808 |
||
1809 |
||
1810 |
-- -------------------------------------------------------- |
|
1811 |
||
1812 |
--
|
|
1813 |
-- Table structure for table `shift_template` |
|
1814 |
--
|
|
1815 |
||
1816 |
CREATE TABLE `shift_template` ( |
|
1817 |
`day_of_week` tinyint(1) NOT NULL, |
|
1818 |
`start` time NOT NULL, |
|
1819 |
`end` time NOT NULL, |
|
1820 |
KEY `day_of_week` (`day_of_week`) |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1821 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
5
by azammitdcarf
Import from DCARF SVN |
1822 |
|
1823 |
--
|
|
1824 |
-- Dumping data for table `shift_template` |
|
1825 |
--
|
|
1826 |
||
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1827 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(2, '17:00:00', '20:30:00'); |
1828 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(3, '17:00:00', '20:30:00'); |
|
1829 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(4, '17:00:00', '20:30:00'); |
|
1830 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(5, '17:00:00', '20:30:00'); |
|
1831 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(6, '17:00:00', '20:30:00'); |
|
1832 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(7, '09:00:00', '13:00:00'); |
|
1833 |
INSERT INTO `shift_template` (`day_of_week`, `start`, `end`) VALUES(7, '13:00:00', '17:00:00'); |
|
5
by azammitdcarf
Import from DCARF SVN |
1834 |
|
1835 |
-- -------------------------------------------------------- |
|
1836 |
||
1837 |
--
|
|
1838 |
-- Table structure for table `timezone_template` |
|
1839 |
--
|
|
1840 |
||
1841 |
CREATE TABLE `timezone_template` ( |
|
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1842 |
`Time_zone_name` char(64) collate utf8_unicode_ci NOT NULL, |
5
by azammitdcarf
Import from DCARF SVN |
1843 |
PRIMARY KEY (`Time_zone_name`) |
237
by azammitdcarf
Merging the Limesurvey 1.91+ branch of queXS in to the trunk |
1844 |
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; |
1845 |
||
1846 |
--
|
|
1847 |
-- Dumping data for table `timezone_template` |
|
1848 |
--
|
|
1849 |