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 0
/
ext_tables.sql
393 lines (373 loc) · 13.3 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
383
384
385
386
387
388
389
390
391
392
393
#
# Table structure for table 'tx_toctoc_comments_comments'
#
CREATE TABLE tx_toctoc_comments_comments (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
hidden tinyint(1) unsigned DEFAULT '0' NOT NULL,
approved int(1) DEFAULT '0' NOT NULL,
external_ref varchar(255) DEFAULT '' NOT NULL,
external_prefix varchar(255) DEFAULT '' NOT NULL,
gender int(1) DEFAULT '0' NOT NULL,
commenttitle varchar(255) DEFAULT '' NOT NULL,
firstname varchar(255) DEFAULT '' NOT NULL,
lastname varchar(255) DEFAULT '' NOT NULL,
email varchar(255) DEFAULT '' NOT NULL,
homepage text NOT NULL,
location varchar(255) DEFAULT '' NOT NULL,
content text NOT NULL,
remote_addr varchar(255) DEFAULT '' NOT NULL,
double_post_check varchar(32) DEFAULT '' NOT NULL,
external_ref_uid varchar(255) DEFAULT '' NOT NULL,
toctoc_commentsfeuser_feuser int(11) DEFAULT '0' NOT NULL,
toctoc_comments_user varchar(100) DEFAULT '' NOT NULL,
tx_commentsnotify_notify tinyint(1) unsigned default '0' NOT NULL,
attachment_id int(11) DEFAULT '0' NOT NULL,
attachment_subid int(11) DEFAULT '0' NOT NULL,
parentuid int(11) unsigned DEFAULT '0' NOT NULL,
tx_commentsresponse_response text NOT NULL,
isreview int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY fastaccess (deleted,hidden,approved,pid,external_ref_uid,crdate),
KEY commoncomm (parentuid,uid),
KEY tcemainhookcid (external_ref_uid,deleted),
KEY tcemainhook (external_ref,deleted)
);
#
# Table structure for table 'tx_toctoc_comments_feuser_mm'
#
CREATE TABLE tx_toctoc_comments_feuser_mm (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
ilike int(1) DEFAULT '0' NOT NULL,
idislike int(1) DEFAULT '0' NOT NULL,
myrating decimal(19,8) DEFAULT '0.00000000' NOT NULL,
seen int(11) DEFAULT '0' NOT NULL,
remote_addr varchar(255) DEFAULT '' NOT NULL,
toctoc_commentsfeuser_feuser int(11) DEFAULT '0' NOT NULL,
toctoc_comments_user varchar(100) DEFAULT '' NOT NULL,
reference varchar(55) DEFAULT '' NOT NULL,
reference_scope int(11) DEFAULT '0' NOT NULL,
tstampilike int(11) unsigned DEFAULT '0' NOT NULL,
tstampidislike int(11) unsigned DEFAULT '0' NOT NULL,
tstampmyrating int(11) unsigned DEFAULT '0' NOT NULL,
tstampseen int(11) unsigned DEFAULT '0' NOT NULL,
pagetstampilike int(11) unsigned DEFAULT '0' NOT NULL,
pagetstampidislike int(11) unsigned DEFAULT '0' NOT NULL,
pagetstampmyrating int(11) unsigned DEFAULT '0' NOT NULL,
pagetstampseen int(11) unsigned DEFAULT '0' NOT NULL,
isreview int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (reference,reference_scope,toctoc_comments_user,pid),
KEY uid (uid),
KEY idxcntilike (ilike),
KEY idxcntidislike (idislike),
KEY idxcntseen (seen),
KEY fastaccess (deleted,reference,reference_scope,toctoc_commentsfeuser_feuser)
);
#
# Table structure for table 'tx_toctoc_comments_user'
#
CREATE TABLE tx_toctoc_comments_user (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
toctoc_comments_user varchar(100) DEFAULT '' NOT NULL,
ip varchar(255) DEFAULT '0' NOT NULL,
ipresolved varchar(255) DEFAULT '0' NOT NULL,
initial_firstname varchar(255) DEFAULT '' NOT NULL,
initial_lastname varchar(255) DEFAULT '' NOT NULL,
initial_email varchar(255) DEFAULT '' NOT NULL,
initial_homepage varchar(255) DEFAULT '' NOT NULL,
initial_location varchar(255) DEFAULT '' NOT NULL,
comment_count int(11) DEFAULT '0' NOT NULL,
average_rating decimal(19,8) DEFAULT '0.00000000' NOT NULL,
vote_count int(11) DEFAULT '0' NOT NULL,
like_count int(11) DEFAULT '0' NOT NULL,
dislike_count int(11) DEFAULT '0' NOT NULL,
current_firstname varchar(255) DEFAULT '' NOT NULL,
current_lastname varchar(255) DEFAULT '' NOT NULL,
current_email varchar(255) DEFAULT '' NOT NULL,
current_homepage varchar(255) DEFAULT '' NOT NULL,
current_location varchar(255) DEFAULT '' NOT NULL,
current_ip varchar(255) DEFAULT '0' NOT NULL,
tstamp_lastupdate int(11) unsigned DEFAULT '0' NOT NULL,
optindate int(11) unsigned DEFAULT '0' NOT NULL,
optin_email varchar(255) DEFAULT '' NOT NULL,
optin_ip varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (toctoc_comments_user,pid),
KEY parent (pid),
KEY uid (uid)
);
#
# Table structure for table 'tx_toctoc_comments_urllog'
#
CREATE TABLE tx_toctoc_comments_urllog (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
external_ref varchar(255) DEFAULT '' NOT NULL,
url text NOT NULL,
external_ref_uid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY tcemainhookcid (external_ref_uid,deleted),
KEY tcemainhook (external_ref,deleted)
);
#
# Table structure for table 'tx_toctoc_ratings_data'
#
CREATE TABLE tx_toctoc_ratings_data (
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,
reference varchar(55) DEFAULT '' NOT NULL,
rating decimal(19,6) DEFAULT '0.000000' NOT NULL,
vote_count decimal(19,6) DEFAULT '0.000000' NOT NULL,
reference_scope int(11) DEFAULT '0' NOT NULL,
isreview int(1) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY reference (reference,reference_scope)
);
#
# Table structure for table 'tx_toctoc_ratings_iplog'
#
CREATE TABLE tx_toctoc_ratings_iplog (
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,
reference varchar(55) DEFAULT '' NOT NULL,
ip varchar(255) DEFAULT '0' NOT NULL,
reference_scope int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY parent (pid),
KEY ip_check (reference,reference_scope,ip(64))
);
#
# Table structure for table 'tx_toctoc_ratings_scope'
#
CREATE TABLE tx_toctoc_ratings_scope (
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,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
scope_title varchar(255) DEFAULT '' NOT NULL,
scope_description varchar(255) DEFAULT '' NOT NULL,
display_order tinyint(10) 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,
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,
PRIMARY KEY (uid),
KEY scope (sys_language_uid,scope_title),
KEY t3ver_oid (t3ver_oid,t3ver_wsid)
);
#
# Table structure for table 'tx_toctoc_comments_spamwords'
#
CREATE TABLE tx_toctoc_comments_spamwords (
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,
sorting int(10) DEFAULT '0' NOT NULL,
deleted tinyint(4) DEFAULT '0' NOT NULL,
hidden tinyint(4) DEFAULT '0' NOT NULL,
spamword varchar(255) DEFAULT '' NOT NULL,
sys_language_uid int(11) DEFAULT '0' NOT NULL,
spamvalue int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY spamword (sys_language_uid,spamword)
);
#
# Table structure for table 'tx_toctoc_comments_attachment'
#
CREATE TABLE tx_toctoc_comments_attachment (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
attachmentvariant int(11) DEFAULT '0' NOT NULL,
systemurltext tinytext NOT NULL,
photo_main blob NOT NULL,
photos_etc blob NOT NULL,
title tinytext NOT NULL,
description tinytext NOT NULL,
attachmentfilesize int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY att_url (attachmentvariant,systemurltext(64))
);
#
# Table structure for table 'tx_toctoc_comments_attachment_mm'
#
CREATE TABLE tx_toctoc_comments_attachment_mm (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
attachmentid int(11) DEFAULT '0' NOT NULL,
userurltext tinytext NOT NULL,
reference varchar(55) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY att_mmref (reference,attachmentid)
KEY att_mmurl (userurltext(64))
);
#
# Table structure for table 'tx_toctoc_comments_sharing'
#
CREATE TABLE tx_toctoc_comments_sharing (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
reference int(11) unsigned DEFAULT '0' NOT NULL,
external_ref varchar(255) DEFAULT '' NOT NULL,
external_prefix varchar(255) DEFAULT '' NOT NULL,
sharer varchar(255) DEFAULT '' NOT NULL,
shareurl tinytext NOT NULL,
sharecount int(11) DEFAULT '0' NOT NULL,
sys_language_uid int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY shr_sharer (sharer,shareurl(64))
KEY shr_url (shareurl(64))
);
#
# Table structure for table 'tx_toctoc_comments_prefixtotable'
#
CREATE TABLE tx_toctoc_comments_prefixtotable (
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,
deleted tinyint(1) unsigned DEFAULT '0' NOT NULL,
pi1_key tinytext NOT NULL,
pi1_table tinytext NOT NULL,
show_uid tinytext NOT NULL,
displayfields tinytext NOT NULL,
topratingsimagesfolder tinytext NOT NULL,
topratingsdetailpage int(11) unsigned DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
KEY pi1_key (pi1_key(64))
KEY pi1_table (pi1_table(64))
);
#
# Table structure for table 'tx_toctoc_comments_ipbl_local'
#
CREATE TABLE tx_toctoc_comments_ipbl_local (
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,
ipaddr varchar(255) DEFAULT '' NOT NULL,
blockfe int(11) DEFAULT '0' NOT NULL,
comment text,
PRIMARY KEY (uid),
KEY parent (pid),
KEY ipaddr (ipaddr(50))
);
#
# Table structure for table 'tx_toctoc_comments_ipbl_static'
#
CREATE TABLE tx_toctoc_comments_ipbl_static (
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,
ipaddr varchar(80) DEFAULT '' NOT NULL,
comment text,
PRIMARY KEY (uid),
KEY parent (pid),
KEY ipaddr (ipaddr)
);
#
# Table structure for table 'tx_toctoc_comments_plugincachecontrol'
#
CREATE TABLE tx_toctoc_comments_plugincachecontrol (
uid int(11) NOT NULL auto_increment,
external_ref_uid char(100) DEFAULT '' NOT NULL,
tstamp int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (uid),
UNIQUE KEY external_ref_uid (external_ref_uid)
);
CREATE TABLE tx_toctoc_comments_cache (
id int(11) NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
crdate int(11) DEFAULT '0' NOT NULL,
content mediumblob,
lifetime int(11) DEFAULT '0' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier)
);
#
# TABLE STRUCTURE FOR TABLE 'tx_toctoc_comments_cache_tags'
#
CREATE TABLE tx_toctoc_comments_cache_tags (
id int(11) NOT NULL auto_increment,
identifier varchar(250) DEFAULT '' NOT NULL,
tag varchar(250) DEFAULT '' NOT NULL,
PRIMARY KEY (id),
KEY cache_id (identifier),
KEY cache_tag (tag)
);
#
# TABLE STRUCTURE FOR TABLE 'tx_toctoc_comments_cache_mailconf'
#
CREATE TABLE tx_toctoc_comments_cache_mailconf (
id int(11) NOT NULL auto_increment,
mailconf text NOT NULL,
PRIMARY KEY (id)
);
#
# TABLE STRUCTURE FOR TABLE 'tx_toctoc_comments_longuidreference'
#
CREATE TABLE tx_toctoc_comments_longuidreference (
uid int(11) NOT NULL auto_increment,
externaluid varchar(255) DEFAULT '' NOT NULL,
PRIMARY KEY (uid),
KEY external_uid (externaluid)
);
#
# Table structure for table 'fe_users'
#
CREATE TABLE fe_users (
gender int(11) unsigned DEFAULT '0' NOT NULL,
tx_toctoc_comments_facebook_id tinytext,
tx_toctoc_comments_facebook_link tinytext,
tx_toctoc_comments_facebook_gender tinytext,
tx_toctoc_comments_facebook_email tinytext,
tx_toctoc_comments_facebook_locale varchar(5) DEFAULT '' NOT NULL,
tx_toctoc_comments_facebook_updated_time varchar(25) DEFAULT '' NOT NULL
);