This repository has been archived by the owner on Nov 19, 2017. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathext_tables.sql
200 lines (186 loc) · 6.35 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
#
# Table structure for table 'tx_myquizpoll_question'
#
CREATE TABLE tx_myquizpoll_question (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
t3ver_oid int(11) DEFAULT '0' NOT NULL,
t3ver_id int(11) DEFAULT '0' NOT NULL,
t3ver_wsid int(11) DEFAULT '0' NOT NULL,
t3ver_label varchar(30) DEFAULT '' NOT NULL,
t3ver_state tinyint(4) DEFAULT '0' NOT NULL,
t3ver_stage tinyint(4) DEFAULT '0' NOT NULL,
t3ver_count int(11) DEFAULT '0' NOT NULL,
t3ver_tstamp int(11) DEFAULT '0' NOT NULL,
t3_origuid int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
fe_group int(11) DEFAULT '0' NOT NULL,
title varchar(255) DEFAULT '' NOT NULL,
title_hide tinyint(3) DEFAULT '0' NOT NULL,
name text,
qtype int(11) DEFAULT '0' NOT NULL,
category int(11) DEFAULT '0' NOT NULL,
answer1 tinytext,
correct1 tinyint(3) DEFAULT '0' NOT NULL,
points1 int(11) DEFAULT '0' NOT NULL,
joker1_1 tinyint(3) DEFAULT '0' NOT NULL,
joker2_1 int(11) DEFAULT '0' NOT NULL,
category1 int(11) DEFAULT '0' NOT NULL,
answer2 tinytext,
correct2 tinyint(3) DEFAULT '0' NOT NULL,
points2 int(11) DEFAULT '0' NOT NULL,
joker1_2 tinyint(3) DEFAULT '0' NOT NULL,
joker2_2 int(11) DEFAULT '0' NOT NULL,
category2 int(11) DEFAULT '0' NOT NULL,
answer3 tinytext,
correct3 tinyint(3) DEFAULT '0' NOT NULL,
points3 int(11) DEFAULT '0' NOT NULL,
joker1_3 tinyint(3) DEFAULT '0' NOT NULL,
joker2_3 int(11) DEFAULT '0' NOT NULL,
category3 int(11) DEFAULT '0' NOT NULL,
answer4 tinytext,
correct4 tinyint(3) DEFAULT '0' NOT NULL,
points4 int(11) DEFAULT '0' NOT NULL,
joker1_4 tinyint(3) DEFAULT '0' NOT NULL,
joker2_4 int(11) DEFAULT '0' NOT NULL,
category4 int(11) DEFAULT '0' NOT NULL,
answer5 tinytext,
correct5 tinyint(3) DEFAULT '0' NOT NULL,
points5 int(11) DEFAULT '0' NOT NULL,
joker1_5 tinyint(3) DEFAULT '0' NOT NULL,
joker2_5 int(11) DEFAULT '0' NOT NULL,
category5 int(11) DEFAULT '0' NOT NULL,
answer6 tinytext,
correct6 tinyint(3) DEFAULT '0' NOT NULL,
points6 int(11) DEFAULT '0' NOT NULL,
joker1_6 tinyint(3) DEFAULT '0' NOT NULL,
joker2_6 int(11) DEFAULT '0' NOT NULL,
category6 int(11) DEFAULT '0' NOT NULL,
explanation text,
joker3 varchar(255) DEFAULT '' NOT NULL,
points int(11) DEFAULT '0' NOT NULL,
category_next int(11) DEFAULT '0' NOT NULL,
image text,
alt_text varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
);
#
# Table structure for table 'tx_myquizpoll_voting'
#
CREATE TABLE tx_myquizpoll_voting (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
hidden tinyint(4) DEFAULT '0' NOT NULL,
answer_no tinyint(4) DEFAULT '0' NOT NULL,
question_id int(11) DEFAULT '0' NOT NULL,
foreign_val varchar(255) DEFAULT '' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY my_voting_answer (answer_no),
KEY my_voting_foreign (foreign_val),
KEY my_voting_question (question_id)
);
#
# Table structure for table 'tx_myquizpoll_result'
#
CREATE TABLE tx_myquizpoll_result (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
hidden tinyint(4) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
homepage varchar(255) DEFAULT '' NOT NULL,
ip varchar(255) DEFAULT '' NOT NULL,
p_or_a int(11) DEFAULT '0' NOT NULL,
p_max int(11) DEFAULT '0' NOT NULL,
percent int(11) DEFAULT '0' NOT NULL,
o_max int(11) DEFAULT '0' NOT NULL,
o_percent int(11) DEFAULT '0' NOT NULL,
qids text,
cids text,
fids text,
sids text,
joker1 tinyint(3) DEFAULT '0' NOT NULL,
joker2 tinyint(3) DEFAULT '0' NOT NULL,
joker3 tinyint(3) DEFAULT '0' NOT NULL,
firsttime int(11) DEFAULT '0' NOT NULL,
lasttime int(11) DEFAULT '0' NOT NULL,
lastcat int(11) DEFAULT '0' NOT NULL,
nextcat int(11) DEFAULT '0' NOT NULL,
fe_uid int(11) DEFAULT '0' NOT NULL,
start_uid int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);
# CREATE INDEX my_res_qids_index ON tx_myquizpoll_result (qids);
# CREATE INDEX my_res_fids_index ON tx_myquizpoll_result (fids);
#
# Table structure for table 'tx_myquizpoll_relation'
#
CREATE TABLE tx_myquizpoll_relation (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
l10n_parent int(11) DEFAULT '0' NOT NULL,
l10n_diffsource mediumtext,
hidden tinyint(4) DEFAULT '0' NOT NULL,
user_id int(11) DEFAULT '0' NOT NULL,
question_id int(11) DEFAULT '0' NOT NULL,
textinput text,
checked1 tinyint(3) DEFAULT '0' NOT NULL,
checked2 tinyint(3) DEFAULT '0' NOT NULL,
checked3 tinyint(3) DEFAULT '0' NOT NULL,
checked4 tinyint(3) DEFAULT '0' NOT NULL,
checked5 tinyint(3) DEFAULT '0' NOT NULL,
checked6 tinyint(3) DEFAULT '0' NOT NULL,
points int(11) DEFAULT '0' NOT NULL,
nextcat int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY my_user (user_id),
KEY my_question (question_id)
);
# CREATE INDEX my_rel_user_index ON tx_myquizpoll_relation (user_id);
# CREATE INDEX my_rel_quest_index ON tx_myquizpoll_relation (question_id);
#
# Table structure for table 'tx_myquizpoll_category'
#
CREATE TABLE tx_myquizpoll_category (
uid int(11) NOT NULL auto_increment,
pid int(11) DEFAULT '0' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
cruser_id int(11) DEFAULT '0' NOT NULL,
name varchar(255) DEFAULT '' NOT NULL,
notes text,
celement int(11) DEFAULT '0' NOT NULL,
pagetime int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid)
);