-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathext_tables.sql
382 lines (285 loc) · 10.9 KB
/
ext_tables.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
#
# Table structure for table 'tt_content'
#
CREATE TABLE tt_content (
pbsurvey_access_level tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_anonymous_mode tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_cancel_page int(10) unsigned DEFAULT '0' NOT NULL,
pbsurvey_captcha tinyint(1) DEFAULT '0' NOT NULL,
pbsurvey_completion_action tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_completion_page int(10) unsigned DEFAULT '0' NOT NULL,
pbsurvey_completion_close_button tinyint(1) DEFAULT '0' NOT NULL,
pbsurvey_completion_continue_button tinyint(1) DEFAULT '0' NOT NULL,
pbsurvey_cookie_lifetime smallint(5) unsigned DEFAULT '0' NOT NULL,
pbsurvey_days_for_update smallint(5) unsigned DEFAULT '0' NOT NULL,
pbsurvey_entering_stage tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_first_column_width tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_mail_body text NOT NULL,
pbsurvey_mail_cc varchar(255) DEFAULT '' NOT NULL,
pbsurvey_mail_from_address varchar(255) DEFAULT '' NOT NULL,
pbsurvey_mail_from_name varchar(255) DEFAULT '' NOT NULL,
pbsurvey_mail_send_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_mail_subject varchar(255) DEFAULT '' NOT NULL,
pbsurvey_mail_to varchar(255) DEFAULT '' NOT NULL,
pbsurvey_maximum_responses smallint(5) unsigned DEFAULT '0' NOT NULL,
pbsurvey_navigation_back tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_navigation_cancel tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_numbering_page tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_numbering_question tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_responses_per_user smallint(5) unsigned DEFAULT '0' NOT NULL,
pbsurvey_scoring tinyint(3) unsigned DEFAULT '0' NOT NULL,
pbsurvey_storage_folder int(10) unsigned DEFAULT '0' NOT NULL,
pbsurvey_validation tinyint(3) unsigned DEFAULT '0' NOT NULL
);
#
# Table structure for table 'tx_pbsurvey_answer'
#
CREATE TABLE tx_pbsurvey_answer (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
answer text NOT NULL,
col int(11) unsigned DEFAULT '0' NOT NULL,
question int(11) unsigned DEFAULT '0' NOT NULL,
result int(11) unsigned DEFAULT '0' NOT NULL,
row int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY parent (result)
);
#
# Table structure for table 'tx_pbsurvey_item'
#
CREATE TABLE tx_pbsurvey_item (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
answers int(11) DEFAULT '0' NOT NULL,
answers_additional_allow tinyint(3) unsigned DEFAULT '0' NOT NULL,
answers_additional_text tinytext NOT NULL,
answers_additional_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
answers_none tinyint(3) unsigned DEFAULT '0' NOT NULL,
answers_predefined_group int(11) DEFAULT '0' NOT NULL,
date_default int(11) DEFAULT '0' NOT NULL,
date_maximum int(11) DEFAULT '0',
date_minimum int(11) DEFAULT '0',
display_type tinyint(3) unsigned DEFAULT '0' NOT NULL,
email tinyint(3) unsigned DEFAULT '0' NOT NULL,
heading tinytext NOT NULL,
html text NOT NULL,
image blob NOT NULL,
image_alignment tinyint(3) unsigned DEFAULT '0' NOT NULL,
image_height int(11) DEFAULT '0',
image_width int(11) DEFAULT '0',
images blob NOT NULL,
length_maximum int(11) DEFAULT '0',
message text NOT NULL,
negative_first tinyint(3) unsigned DEFAULT '0' NOT NULL,
number_end int(11) DEFAULT '0',
number_start int(11) DEFAULT '0',
number_total int(11) DEFAULT '0',
options_alignment int(11) unsigned DEFAULT '0' NOT NULL,
options_random tinyint(3) unsigned DEFAULT '0' NOT NULL,
options_required tinyint(3) unsigned DEFAULT '0' NOT NULL,
options_responses_maximum int(11) DEFAULT '0' NOT NULL,
options_responses_minimum int(11) DEFAULT '0' NOT NULL,
options_row_heading_width int(11) DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
question tinytext NOT NULL,
question_alias tinytext NOT NULL,
question_subtext text NOT NULL,
question_type int(11) unsigned DEFAULT '0' NOT NULL,
rows text NOT NULL,
selectbox_height int(11) DEFAULT '0',
styleclass tinytext NOT NULL,
textarea_height int(11) DEFAULT '0',
textarea_width int(11) DEFAULT '0',
value_default_numeric int(11) DEFAULT '0',
value_default_text tinytext NOT NULL,
value_default_true_false tinyint(3) unsigned DEFAULT '0' NOT NULL,
value_default_yes_no tinyint(3) unsigned DEFAULT '0' NOT NULL,
value_minimum int(11) DEFAULT '0',
value_maximum int(11) DEFAULT '0',
PRIMARY KEY (uid),
KEY parent (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_option'
#
CREATE TABLE tx_pbsurvey_option (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
checked tinyint(1) DEFAULT '0' NOT NULL,
points int(11) unsigned DEFAULT '0' NOT NULL,
value tinytext NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_option_predefined'
#
CREATE TABLE tx_pbsurvey_option_predefined (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
label tinytext NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_option_predefined_group'
#
CREATE TABLE tx_pbsurvey_option_predefined_group (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
name tinytext NOT NULL,
options int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid)
);
#
# Table structure for table 'tx_pbsurvey_page'
#
CREATE TABLE tx_pbsurvey_page (
uid int(11) DEFAULT '0' NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l18n_parent int(11) DEFAULT '0' NOT NULL,
l18n_diffsource mediumblob NOT NULL,
condition_groups text NOT NULL,
introduction text NOT NULL,
items int(11) unsigned DEFAULT '0' NOT NULL,
title tinytext NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_pbsurvey_page_condition_group'
#
CREATE TABLE tx_pbsurvey_page_condition_group (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
name tinytext NOT NULL,
rules int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_page_condition_rule'
#
CREATE TABLE tx_pbsurvey_page_condition_rule (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(10) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
item int(11) unsigned DEFAULT '0' NOT NULL,
item_option int(11) unsigned DEFAULT '0' NOT NULL,
item_option_additional tinytext NOT NULL,
name tinytext NOT NULL,
operator varchar(6) NOT NULL DEFAULT '',
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_result'
#
CREATE TABLE tx_pbsurvey_result (
uid int(11) unsigned DEFAULT '0' NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
begintstamp int(11) unsigned DEFAULT '0' NOT NULL,
endtstamp int(11) unsigned DEFAULT '0' NOT NULL,
finished tinyint(4) unsigned DEFAULT '0' NOT NULL,
history text,
ip varchar(78) NOT NULL DEFAULT '',
language_uid tinytext NOT NULL,
user int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
#
# Table structure for table 'tx_pbsurvey_row'
#
CREATE TABLE tx_pbsurvey_row (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
name int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);
#
# Table structure for table 'tx_pbsurvey_score'
#
CREATE TABLE tx_pbsurvey_score (
uid int(11) unsigned NOT NULL auto_increment,
pid int(11) unsigned DEFAULT '0' NOT NULL,
tstamp int(11) unsigned DEFAULT '0' NOT NULL,
crdate int(11) unsigned DEFAULT '0' NOT NULL,
cruser_id int(11) unsigned DEFAULT '0' NOT NULL,
sorting int(11) unsigned DEFAULT '0' NOT NULL,
deleted tinyint(4) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(4) unsigned DEFAULT '0' NOT NULL,
parentid int(11) unsigned DEFAULT '0' NOT NULL,
page int(11) unsigned DEFAULT '0' NOT NULL,
score int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY pid (pid),
KEY parentid (parentid)
);