Commit | Line | Data |
---|---|---|
9f959ced | 1 | /* tables */ |
092bdf82 AE |
2 | DROP TABLE IF EXISTS wcf1_acl_option; |
3 | CREATE TABLE wcf1_acl_option ( | |
4 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
5 | packageID INT(10) NOT NULL, | |
6 | objectTypeID INT(10) NOT NULL, | |
7 | optionName VARCHAR(255) NOT NULL, | |
8 | categoryName VARCHAR(255) NOT NULL, | |
9 | UNIQUE KEY (packageID, objectTypeID, optionName) | |
10 | ); | |
11 | ||
12 | DROP TABLE IF EXISTS wcf1_acl_option_category; | |
13 | CREATE TABLE wcf1_acl_option_category ( | |
14 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
15 | packageID INT(10) NOT NULL, | |
16 | objectTypeID INT(10) NOT NULL, | |
17 | categoryName VARCHAR(255) NOT NULL, | |
18 | UNIQUE KEY (packageID, objectTypeID, categoryName) | |
19 | ); | |
20 | ||
21 | DROP TABLE IF EXISTS wcf1_acl_option_to_user; | |
22 | CREATE TABLE wcf1_acl_option_to_user ( | |
23 | optionID INT(10) NOT NULL, | |
24 | objectID INT(10) NOT NULL, | |
25 | userID INT(10) NOT NULL, | |
26 | optionValue TINYINT(1) NOT NULL DEFAULT 0, | |
27 | UNIQUE KEY userID (userID, objectID, optionID) | |
28 | ); | |
29 | ||
30 | DROP TABLE IF EXISTS wcf1_acl_option_to_group; | |
31 | CREATE TABLE wcf1_acl_option_to_group ( | |
32 | optionID INT(10) NOT NULL, | |
33 | objectID INT(10) NOT NULL, | |
34 | groupID INT(10) NOT NULL, | |
35 | optionValue TINYINT(1) NOT NULL DEFAULT 0, | |
36 | UNIQUE KEY groupID (groupID, objectID, optionID) | |
37 | ); | |
38 | ||
158bd3ca TD |
39 | DROP TABLE IF EXISTS wcf1_acp_menu_item; |
40 | CREATE TABLE wcf1_acp_menu_item ( | |
41 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
42 | packageID INT(10) NOT NULL, | |
43 | menuItem VARCHAR(255) NOT NULL DEFAULT '', | |
44 | parentMenuItem VARCHAR(255) NOT NULL DEFAULT '', | |
b6169da5 | 45 | menuItemController VARCHAR(255) NOT NULL DEFAULT '', |
158bd3ca TD |
46 | menuItemLink VARCHAR(255) NOT NULL DEFAULT '', |
47 | showOrder INT(10) NOT NULL DEFAULT 0, | |
48 | permissions TEXT, | |
49 | options TEXT, | |
50 | UNIQUE KEY menuItem (menuItem, packageID) | |
51 | ); | |
52 | ||
e9311b98 AE |
53 | DROP TABLE IF EXISTS wcf1_acp_search_provider; |
54 | CREATE TABLE wcf1_acp_search_provider ( | |
55 | providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
56 | packageID INT(10) NOT NULL, | |
57 | providerName VARCHAR(255) NOT NULL DEFAULT '', | |
58 | className VARCHAR(255) NOT NULL DEFAULT '', | |
59 | showOrder INT(10) NOT NULL DEFAULT 0, | |
60 | UNIQUE KEY providerName (providerName, packageID) | |
61 | ); | |
62 | ||
158bd3ca TD |
63 | DROP TABLE IF EXISTS wcf1_acp_session; |
64 | CREATE TABLE wcf1_acp_session ( | |
65 | sessionID CHAR(40) NOT NULL PRIMARY KEY, | |
158bd3ca TD |
66 | userID INT(10), |
67 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
68 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
69 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
70 | requestURI VARCHAR(255) NOT NULL DEFAULT '', | |
98f447b0 | 71 | requestMethod VARCHAR(7) NOT NULL DEFAULT '', |
7aa1a486 | 72 | controller VARCHAR(255) NOT NULL DEFAULT '', |
596e20e2 MW |
73 | parentObjectType VARCHAR(255) NOT NULL DEFAULT '', |
74 | parentObjectID INT(10) NOT NULL DEFAULT 0, | |
75 | objectType VARCHAR(255) NOT NULL DEFAULT '', | |
76 | objectID INT(10) NOT NULL DEFAULT 0, | |
0b30544a | 77 | sessionVariables MEDIUMTEXT |
158bd3ca TD |
78 | ); |
79 | ||
158bd3ca TD |
80 | DROP TABLE IF EXISTS wcf1_acp_session_access_log; |
81 | CREATE TABLE wcf1_acp_session_access_log ( | |
82 | sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
83 | sessionLogID INT(10) NOT NULL, | |
158bd3ca TD |
84 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', |
85 | time INT(10) NOT NULL DEFAULT 0, | |
86 | requestURI VARCHAR(255) NOT NULL DEFAULT '', | |
98f447b0 | 87 | requestMethod VARCHAR(7) NOT NULL DEFAULT '', |
158bd3ca TD |
88 | className VARCHAR(255) NOT NULL DEFAULT '', |
89 | KEY sessionLogID (sessionLogID) | |
90 | ); | |
91 | ||
92 | DROP TABLE IF EXISTS wcf1_acp_session_log; | |
93 | CREATE TABLE wcf1_acp_session_log ( | |
94 | sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
95 | sessionID CHAR(40) NOT NULL DEFAULT '', | |
96 | userID INT(10), | |
97 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
98 | hostname VARCHAR(255) NOT NULL DEFAULT '', | |
99 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
100 | time INT(10) NOT NULL DEFAULT 0, | |
101 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
102 | KEY sessionID (sessionID) | |
103 | ); | |
104 | ||
105 | DROP TABLE IF EXISTS wcf1_acp_template; | |
106 | CREATE TABLE wcf1_acp_template ( | |
107 | templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
108 | packageID INT(10), | |
04727c8b | 109 | templateName VARCHAR(255) NOT NULL, |
567fa8b8 | 110 | application VARCHAR(20) NOT NULL, |
04727c8b | 111 | UNIQUE KEY applicationTemplate (application, templateName) |
158bd3ca TD |
112 | ); |
113 | ||
e866b80e MS |
114 | DROP TABLE IF EXISTS wcf1_ad; |
115 | CREATE TABLE wcf1_ad ( | |
116 | adID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
117 | objectTypeID INT(10) NOT NULL, | |
118 | adName VARCHAR(255) NOT NULL, | |
119 | ad MEDIUMTEXT, | |
120 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
121 | showOrder INT(10) NOT NULL DEFAULT 0 | |
122 | ); | |
123 | ||
158bd3ca TD |
124 | DROP TABLE IF EXISTS wcf1_application; |
125 | CREATE TABLE wcf1_application ( | |
126 | packageID INT(10) NOT NULL PRIMARY KEY, | |
127 | domainName VARCHAR(255) NOT NULL, | |
128 | domainPath VARCHAR(255) NOT NULL DEFAULT '/', | |
668cf125 | 129 | cookieDomain VARCHAR(255) NOT NULL, |
de44b893 | 130 | cookiePath VARCHAR(255) NOT NULL DEFAULT '/', |
158bd3ca TD |
131 | isPrimary TINYINT(1) NOT NULL DEFAULT 0 |
132 | ); | |
133 | ||
f0bc263f MW |
134 | DROP TABLE IF EXISTS wcf1_attachment; |
135 | CREATE TABLE wcf1_attachment ( | |
136 | attachmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
137 | objectTypeID INT(10) NOT NULL, | |
138 | objectID INT(10), | |
139 | userID INT(10), | |
140 | tmpHash VARCHAR(40) NOT NULL DEFAULT '', | |
141 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
142 | filesize INT(10) NOT NULL DEFAULT 0, | |
143 | fileType VARCHAR(255) NOT NULL DEFAULT '', | |
144 | fileHash VARCHAR(40) NOT NULL DEFAULT '', | |
145 | ||
146 | isImage TINYINT(1) NOT NULL DEFAULT 0, | |
147 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
148 | height SMALLINT(5) NOT NULL DEFAULT 0, | |
149 | ||
150 | tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
151 | tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
152 | tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
153 | tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
154 | ||
155 | thumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
156 | thumbnailSize INT(10) NOT NULL DEFAULT 0, | |
157 | thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
158 | thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
159 | ||
160 | downloads INT(10) NOT NULL DEFAULT 0, | |
161 | lastDownloadTime INT(10) NOT NULL DEFAULT 0, | |
162 | uploadTime INT(10) NOT NULL DEFAULT 0, | |
163 | showOrder SMALLINT(5) NOT NULL DEFAULT 0, | |
164 | KEY (objectTypeID, objectID), | |
165 | KEY (objectTypeID, tmpHash), | |
166 | KEY (objectID, uploadTime) | |
167 | ); | |
168 | ||
dcc2332d MW |
169 | DROP TABLE IF EXISTS wcf1_bbcode; |
170 | CREATE TABLE wcf1_bbcode ( | |
171 | bbcodeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
172 | bbcodeTag VARCHAR(255) NOT NULL, | |
173 | packageID INT(10) NOT NULL, | |
174 | htmlOpen VARCHAR(255) NOT NULL DEFAULT '', | |
175 | htmlClose VARCHAR(255) NOT NULL DEFAULT '', | |
176 | allowedChildren VARCHAR(255) NOT NULL DEFAULT 'all', | |
177 | className VARCHAR(255) NOT NULL DEFAULT '', | |
178 | wysiwygIcon varchar(255) NOT NULL DEFAULT '', | |
179 | buttonLabel VARCHAR(255) NOT NULL DEFAULT '', | |
180 | isSourceCode TINYINT(1) NOT NULL DEFAULT 0, | |
181 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
182 | showButton TINYINT(1) NOT NULL DEFAULT 0, | |
31378fd1 | 183 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
dcc2332d MW |
184 | UNIQUE KEY bbcodeTag (bbcodeTag) |
185 | ); | |
186 | ||
187 | DROP TABLE IF EXISTS wcf1_bbcode_attribute; | |
188 | CREATE TABLE wcf1_bbcode_attribute ( | |
189 | attributeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
190 | bbcodeID INT(10) NOT NULL, | |
191 | attributeNo TINYINT(3) NOT NULL DEFAULT 0, | |
192 | attributeHtml VARCHAR(255) NOT NULL DEFAULT '', | |
193 | validationPattern VARCHAR(255) NOT NULL DEFAULT '', | |
194 | required TINYINT(1) NOT NULL DEFAULT 0, | |
195 | useText TINYINT(1) NOT NULL DEFAULT 0, | |
196 | UNIQUE KEY attributeNo (bbcodeID, attributeNo) | |
197 | ); | |
198 | ||
199 | DROP TABLE IF EXISTS wcf1_bbcode_media_provider; | |
200 | CREATE TABLE wcf1_bbcode_media_provider ( | |
201 | providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
202 | title VARCHAR(255) NOT NULL, | |
203 | regex TEXT NOT NULL, | |
204 | html TEXT NOT NULL | |
205 | ); | |
206 | ||
96714cab MS |
207 | DROP TABLE IF EXISTS wcf1_captcha_question; |
208 | CREATE TABLE wcf1_captcha_question ( | |
209 | questionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
210 | question VARCHAR(255) NOT NULL, | |
211 | answers MEDIUMTEXT, | |
212 | isDisabled TINYINT(1) NOT NULL DEFAULT 0 | |
213 | ); | |
214 | ||
13d8b49b MS |
215 | DROP TABLE IF EXISTS wcf1_category; |
216 | CREATE TABLE wcf1_category ( | |
217 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
218 | objectTypeID INT(10) NOT NULL, | |
da06d70c | 219 | parentCategoryID INT(10) NOT NULL DEFAULT 0, |
13d8b49b MS |
220 | title VARCHAR(255) NOT NULL, |
221 | description TEXT, | |
da06d70c MW |
222 | showOrder INT(10) NOT NULL DEFAULT 0, |
223 | time INT(10) NOT NULL DEFAULT 0, | |
13d8b49b | 224 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
045f075b | 225 | additionalData TEXT |
13d8b49b MS |
226 | ); |
227 | ||
054db725 TD |
228 | DROP TABLE IF EXISTS wcf1_cli_history; |
229 | CREATE TABLE wcf1_cli_history ( | |
230 | historyItem INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
231 | userID INT(10) NOT NULL, | |
232 | command VARCHAR(255) NOT NULL, | |
233 | KEY (userID) | |
234 | ); | |
235 | ||
0d6ea23f AE |
236 | DROP TABLE IF EXISTS wcf1_clipboard_action; |
237 | CREATE TABLE wcf1_clipboard_action ( | |
238 | actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
239 | packageID INT(10) NOT NULL DEFAULT 0, | |
240 | actionName VARCHAR(50) NOT NULL DEFAULT '', | |
241 | actionClassName VARCHAR(200) NOT NULL DEFAULT '', | |
d6bfc90e | 242 | showOrder INT(10) NOT NULL DEFAULT 0, |
656718fc | 243 | UNIQUE KEY actionName (packageID, actionName, actionClassName) |
0d6ea23f AE |
244 | ); |
245 | ||
246 | DROP TABLE IF EXISTS wcf1_clipboard_item; | |
247 | CREATE TABLE wcf1_clipboard_item ( | |
25cf4d11 | 248 | objectTypeID INT(10) NOT NULL DEFAULT 0, |
0d6ea23f | 249 | userID INT(10) NOT NULL DEFAULT 0, |
25cf4d11 AE |
250 | objectID INT(10) NOT NULL DEFAULT 0, |
251 | UNIQUE KEY (objectTypeID, userID, objectID) | |
0d6ea23f AE |
252 | ); |
253 | ||
254 | DROP TABLE IF EXISTS wcf1_clipboard_page; | |
255 | CREATE TABLE wcf1_clipboard_page ( | |
256 | pageClassName VARCHAR(80) NOT NULL DEFAULT '', | |
257 | packageID INT(10) NOT NULL DEFAULT 0, | |
258 | actionID INT(10) NOT NULL DEFAULT 0 | |
259 | ); | |
260 | ||
285b1d92 MW |
261 | DROP TABLE IF EXISTS wcf1_comment; |
262 | CREATE TABLE wcf1_comment ( | |
263 | commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
264 | objectTypeID INT(10) NOT NULL, | |
265 | objectID INT(10) NOT NULL, | |
266 | time INT(10) NOT NULL DEFAULT '0', | |
267 | userID INT(10), | |
268 | username VARCHAR(255) NOT NULL, | |
269 | message TEXT NOT NULL, | |
270 | responses MEDIUMINT(7) NOT NULL DEFAULT '0', | |
6f874ba8 | 271 | responseIDs VARCHAR(255) NOT NULL DEFAULT '', |
285b1d92 | 272 | |
e36dbd69 AE |
273 | KEY (objectTypeID, objectID, time), |
274 | KEY lastCommentTime (userID, time) | |
285b1d92 MW |
275 | ); |
276 | ||
277 | DROP TABLE IF EXISTS wcf1_comment_response; | |
278 | CREATE TABLE wcf1_comment_response ( | |
279 | responseID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
280 | commentID INT(10) NOT NULL, | |
281 | time INT(10) NOT NULL DEFAULT '0', | |
282 | userID INT(10), | |
283 | username VARCHAR(255) NOT NULL, | |
284 | message TEXT NOT NULL, | |
285 | ||
e36dbd69 AE |
286 | KEY (commentID, time), |
287 | KEY lastResponseTime (userID, time) | |
285b1d92 MW |
288 | ); |
289 | ||
87d3a054 MS |
290 | DROP TABLE IF EXISTS wcf1_condition; |
291 | CREATE TABLE wcf1_condition ( | |
292 | conditionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
293 | objectTypeID INT(10) NOT NULL, | |
294 | objectID INT(10) NOT NULL, | |
295 | conditionData MEDIUMTEXT | |
296 | ); | |
297 | ||
158bd3ca TD |
298 | DROP TABLE IF EXISTS wcf1_core_object; |
299 | CREATE TABLE wcf1_core_object ( | |
300 | objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
301 | packageID INT(10) NOT NULL, | |
302 | objectName VARCHAR(255) NOT NULL DEFAULT '', | |
303 | UNIQUE KEY object (packageID, objectName) | |
304 | ); | |
305 | ||
306 | DROP TABLE IF EXISTS wcf1_cronjob; | |
307 | CREATE TABLE wcf1_cronjob ( | |
308 | cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
309 | className varchar(255) NOT NULL DEFAULT '', | |
310 | packageID INT(10) NOT NULL, | |
311 | description varchar(255) NOT NULL DEFAULT '', | |
312 | startMinute varchar(255) NOT NULL DEFAULT '*', | |
313 | startHour varchar(255) NOT NULL DEFAULT '*', | |
314 | startDom varchar(255) NOT NULL DEFAULT '*', | |
315 | startMonth varchar(255) NOT NULL DEFAULT '*', | |
316 | startDow varchar(255) NOT NULL DEFAULT '*', | |
317 | lastExec INT(10) NOT NULL DEFAULT 0, | |
318 | nextExec INT(10) NOT NULL DEFAULT 0, | |
319 | afterNextExec INT(10) NOT NULL DEFAULT 0, | |
8f08c7d0 | 320 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
c9117aad MS |
321 | canBeEdited TINYINT(1) NOT NULL DEFAULT 1, |
322 | canBeDisabled TINYINT(1) NOT NULL DEFAULT 1, | |
323 | state TINYINT(1) NOT NULL DEFAULT 0, | |
158bd3ca TD |
324 | failCount TINYINT(1) NOT NULL DEFAULT 0 |
325 | ); | |
326 | ||
327 | DROP TABLE IF EXISTS wcf1_cronjob_log; | |
328 | CREATE TABLE wcf1_cronjob_log ( | |
329 | cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
330 | cronjobID INT(10) NOT NULL, | |
331 | execTime INT(10) NOT NULL DEFAULT 0, | |
c9117aad | 332 | success TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
333 | error TEXT |
334 | ); | |
335 | ||
320f4a6d MW |
336 | DROP TABLE IF EXISTS wcf1_dashboard_box; |
337 | CREATE TABLE wcf1_dashboard_box ( | |
338 | boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
339 | packageID INT(10) NOT NULL, | |
340 | boxName VARCHAR(255) NOT NULL DEFAULT '', | |
341 | boxType VARCHAR(30) NOT NULL DEFAULT 'sidebar', -- can be 'content' or 'sidebar' | |
342 | className VARCHAR(255) NOT NULL DEFAULT '' | |
343 | ); | |
344 | ||
345 | DROP TABLE IF EXISTS wcf1_dashboard_option; | |
346 | CREATE TABLE wcf1_dashboard_option ( | |
347 | objectTypeID INT(10) NOT NULL, | |
348 | boxID INT(10) NOT NULL, | |
349 | showOrder INT(10) NOT NULL, | |
350 | UNIQUE KEY dashboardOption (objectTypeID, boxID) | |
351 | ); | |
352 | ||
81aa6374 TD |
353 | DROP TABLE IF EXISTS wcf1_edit_history_entry; |
354 | CREATE TABLE wcf1_edit_history_entry ( | |
355 | entryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
356 | objectTypeID INT(10) NOT NULL, | |
357 | objectID INT(10) NOT NULL, | |
358 | userID INT(10), | |
359 | username VARCHAR(255) NOT NULL DEFAULT '', | |
988618d9 | 360 | time INT(10) NOT NULL DEFAULT 0, -- time the version was created, displayed to the user |
f86d7ff7 TD |
361 | obsoletedAt INT(10) NOT NULL DEFAULT 0, -- time the version was inserted into the edit history, used for clean up |
362 | obsoletedByUserID INT(10), | |
81aa6374 TD |
363 | message MEDIUMTEXT, |
364 | editReason TEXT, | |
365 | ||
f86d7ff7 TD |
366 | KEY (objectTypeID, objectID), |
367 | KEY (obsoletedAt, obsoletedByUserID) | |
81aa6374 TD |
368 | ); |
369 | ||
158bd3ca TD |
370 | DROP TABLE IF EXISTS wcf1_event_listener; |
371 | CREATE TABLE wcf1_event_listener ( | |
372 | listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
373 | packageID INT(10) NOT NULL, | |
7e6405f8 | 374 | environment ENUM('user', 'admin') NOT NULL DEFAULT 'user', |
158bd3ca TD |
375 | eventClassName VARCHAR(80) NOT NULL DEFAULT '', |
376 | eventName VARCHAR(50) NOT NULL DEFAULT '', | |
377 | listenerClassName VARCHAR(200) NOT NULL DEFAULT '', | |
378 | inherit TINYINT(1) NOT NULL DEFAULT 0, | |
379 | niceValue TINYINT(3) NOT NULL DEFAULT 0, | |
ffdebe9c MS |
380 | permissions TEXT, |
381 | options TEXT, | |
382 | ||
7e6405f8 | 383 | UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName) |
158bd3ca TD |
384 | ); |
385 | ||
78db8ddf MW |
386 | DROP TABLE IF EXISTS wcf1_import_mapping; |
387 | CREATE TABLE wcf1_import_mapping ( | |
8d8368ee | 388 | importHash CHAR(8) NOT NULL, |
78db8ddf MW |
389 | objectTypeID INT(10) NOT NULL, |
390 | oldID VARCHAR(255) NOT NULL, | |
391 | newID INT(10) NOT NULL, | |
8d8368ee | 392 | UNIQUE KEY (importHash, objectTypeID, oldID) |
78db8ddf MW |
393 | ); |
394 | ||
3b75466f MW |
395 | DROP TABLE IF EXISTS wcf1_label; |
396 | CREATE TABLE wcf1_label ( | |
397 | labelID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
398 | groupID INT(10) NOT NULL, | |
399 | label VARCHAR(80) NOT NULL, | |
221eee4b | 400 | cssClassName VARCHAR(255) NOT NULL DEFAULT '' |
3b75466f MW |
401 | ); |
402 | ||
403 | DROP TABLE IF EXISTS wcf1_label_group; | |
404 | CREATE TABLE wcf1_label_group ( | |
405 | groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
406 | groupName VARCHAR(80) NOT NULL, | |
f3db386c | 407 | groupDescription VARCHAR(255) NOT NULL DEFAULT '', |
e76c454b AE |
408 | forceSelection TINYINT(1) NOT NULL DEFAULT 0, |
409 | showOrder INT(10) NOT NULL DEFAULT 0 | |
3b75466f MW |
410 | ); |
411 | ||
412 | DROP TABLE IF EXISTS wcf1_label_group_to_object; | |
413 | CREATE TABLE wcf1_label_group_to_object ( | |
414 | groupID INT(10) NOT NULL, | |
415 | objectTypeID INT(10) NOT NULL, | |
416 | objectID INT(10) NULL | |
417 | ); | |
418 | ||
419 | DROP TABLE IF EXISTS wcf1_label_object; | |
420 | CREATE TABLE wcf1_label_object ( | |
421 | labelID INT(10) NOT NULL, | |
422 | objectTypeID INT(10) NOT NULL, | |
423 | objectID INT(10) NOT NULL, | |
424 | ||
425 | KEY (objectTypeID, labelID), | |
426 | KEY (objectTypeID, objectID) | |
427 | ); | |
428 | ||
158bd3ca TD |
429 | DROP TABLE IF EXISTS wcf1_language; |
430 | CREATE TABLE wcf1_language ( | |
431 | languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
432 | languageCode VARCHAR(20) NOT NULL DEFAULT '', | |
a74df36b | 433 | languageName VARCHAR(255) NOT NULL DEFAULT '', |
6675b340 | 434 | countryCode VARCHAR(10) NOT NULL DEFAULT '', |
158bd3ca TD |
435 | isDefault TINYINT(1) NOT NULL DEFAULT 0, |
436 | hasContent TINYINT(1) NOT NULL DEFAULT 0, | |
437 | UNIQUE KEY languageCode (languageCode) | |
438 | ); | |
439 | ||
440 | DROP TABLE IF EXISTS wcf1_language_category; | |
441 | CREATE TABLE wcf1_language_category ( | |
442 | languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
443 | languageCategory VARCHAR(255) NOT NULL DEFAULT '', | |
444 | UNIQUE KEY languageCategory (languageCategory) | |
445 | ); | |
446 | ||
447 | DROP TABLE IF EXISTS wcf1_language_item; | |
448 | CREATE TABLE wcf1_language_item ( | |
449 | languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
450 | languageID INT(10) NOT NULL, | |
451 | languageItem VARCHAR(255) NOT NULL DEFAULT '', | |
452 | languageItemValue MEDIUMTEXT NOT NULL, | |
453 | languageCustomItemValue MEDIUMTEXT, | |
454 | languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0, | |
455 | languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1, | |
456 | languageCategoryID INT(10) NOT NULL, | |
457 | packageID INT(10), | |
f1c1fc65 | 458 | UNIQUE KEY languageItem (languageItem, languageID), |
158bd3ca TD |
459 | KEY languageItemOriginIsSystem (languageItemOriginIsSystem) |
460 | ); | |
461 | ||
462 | DROP TABLE IF EXISTS wcf1_language_server; | |
463 | CREATE TABLE wcf1_language_server ( | |
464 | languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
465 | serverURL VARCHAR(255) NOT NULL DEFAULT '', | |
8f08c7d0 | 466 | isDisabled TINYINT(1) NOT NULL DEFAULT 0 |
158bd3ca TD |
467 | ); |
468 | ||
00b6f956 MW |
469 | DROP TABLE IF EXISTS wcf1_like; |
470 | CREATE TABLE wcf1_like ( | |
471 | likeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
472 | objectID INT(10) NOT NULL DEFAULT 0, | |
473 | objectTypeID INT(10) NOT NULL, | |
474 | objectUserID INT(10), | |
475 | userID INT(10) NOT NULL, | |
1ba3f564 | 476 | time INT(10) NOT NULL DEFAULT 1, |
00b6f956 MW |
477 | likeValue TINYINT(1) NOT NULL DEFAULT 1, |
478 | UNIQUE KEY (objectTypeID, objectID, userID) | |
479 | ); | |
480 | ||
481 | DROP TABLE IF EXISTS wcf1_like_object; | |
482 | CREATE TABLE wcf1_like_object ( | |
483 | likeObjectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
484 | objectTypeID INT(10) NOT NULL, | |
485 | objectID INT(10) NOT NULL DEFAULT 0, | |
486 | objectUserID INT(10), | |
487 | likes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
488 | dislikes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
489 | cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
490 | cachedUsers TEXT, | |
491 | UNIQUE KEY (objectTypeID, objectID) | |
492 | ); | |
493 | ||
0a2b09a2 MW |
494 | DROP TABLE IF EXISTS wcf1_message_embedded_object; |
495 | CREATE TABLE wcf1_message_embedded_object ( | |
496 | messageObjectTypeID INT(10) NOT NULL, | |
497 | messageID INT(10) NOT NULL, | |
498 | embeddedObjectTypeID INT(10) NOT NULL, | |
499 | embeddedObjectID INT(10) NOT NULL, | |
500 | ||
501 | KEY (messageObjectTypeID, messageID) | |
502 | ); | |
503 | ||
fc69b61d MW |
504 | DROP TABLE IF EXISTS wcf1_moderation_queue; |
505 | CREATE TABLE wcf1_moderation_queue ( | |
506 | queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
507 | objectTypeID INT(10) NOT NULL, | |
508 | objectID INT(10) NOT NULL, | |
509 | containerID INT(10) NOT NULL DEFAULT 0, | |
510 | userID INT(10) NULL, | |
511 | time INT(10) NOT NULL DEFAULT 0, | |
512 | ||
513 | -- internal | |
514 | assignedUserID INT(10) NULL, | |
515 | status TINYINT(1) NOT NULL DEFAULT 0, | |
166d2b91 | 516 | comments SMALLINT(5) NOT NULL DEFAULT 0, |
fc69b61d MW |
517 | lastChangeTime INT(10) NOT NULL DEFAULT 0, |
518 | ||
519 | -- additional data, e.g. message if reporting content | |
71b3faba | 520 | additionalData TEXT |
fc69b61d MW |
521 | ); |
522 | ||
523 | DROP TABLE IF EXISTS wcf1_moderation_queue_to_user; | |
524 | CREATE TABLE wcf1_moderation_queue_to_user ( | |
525 | queueID INT(10) NOT NULL, | |
526 | userID INT(10) NOT NULL, | |
527 | isAffected TINYINT(1) NOT NULL DEFAULT 0, | |
528 | ||
529 | UNIQUE KEY queue (queueID, userID), | |
530 | KEY affected (queueID, userID, isAffected) | |
531 | ); | |
532 | ||
3a2de7fd AE |
533 | DROP TABLE IF EXISTS wcf1_modification_log; |
534 | CREATE TABLE wcf1_modification_log ( | |
535 | logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
536 | objectTypeID INT(10) NOT NULL, | |
537 | objectID INT(10) NOT NULL, | |
538 | userID INT(10), | |
539 | username VARCHAR(255) NOT NULL DEFAULT '', | |
540 | time INT(10) NOT NULL DEFAULT 0, | |
541 | action VARCHAR(80) NOT NULL, | |
542 | additionalData MEDIUMTEXT | |
543 | ); | |
544 | ||
20933e61 MS |
545 | DROP TABLE IF EXISTS wcf1_notice; |
546 | CREATE TABLE wcf1_notice ( | |
547 | noticeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
548 | noticeName VARCHAR(255) NOT NULL, | |
549 | notice MEDIUMTEXT, | |
550 | noticeUseHtml TINYINT(1) NOT NULL DEFAULT 0, | |
e70b5175 | 551 | cssClassName VARCHAR(255) NOT NULL DEFAULT 'info', |
20933e61 MS |
552 | showOrder INT(10) NOT NULL DEFAULT 0, |
553 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
554 | isDismissible TINYINT(1) NOT NULL DEFAULT 0 | |
555 | ); | |
556 | ||
557 | DROP TABLE IF EXISTS wcf1_notice_dismissed; | |
558 | CREATE TABLE wcf1_notice_dismissed ( | |
559 | noticeID INT(10) NOT NULL, | |
560 | userID INT(10) NOT NULL, | |
561 | PRIMARY KEY (noticeID, userID) | |
562 | ); | |
563 | ||
7fcc7676 MW |
564 | DROP TABLE IF EXISTS wcf1_object_type; |
565 | CREATE TABLE wcf1_object_type ( | |
566 | objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
567 | definitionID INT(10) NOT NULL, | |
568 | packageID INT(10) NOT NULL, | |
569 | objectType VARCHAR(255) NOT NULL, | |
570 | className VARCHAR(255) NOT NULL DEFAULT '', | |
571 | additionalData MEDIUMTEXT, | |
572 | UNIQUE KEY objectType (objectType, definitionID, packageID) | |
573 | ); | |
574 | ||
575 | DROP TABLE IF EXISTS wcf1_object_type_definition; | |
576 | CREATE TABLE wcf1_object_type_definition ( | |
577 | definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
578 | definitionName VARCHAR(255) NOT NULL, | |
579 | packageID INT(10) NOT NULL, | |
580 | interfaceName VARCHAR(255) NOT NULL DEFAULT '', | |
16bd0d85 | 581 | categoryName VARCHAR(80) NOT NULL DEFAULT '', |
c404ff5f | 582 | UNIQUE KEY definitionName (definitionName) |
7fcc7676 MW |
583 | ); |
584 | ||
158bd3ca TD |
585 | DROP TABLE IF EXISTS wcf1_option; |
586 | CREATE TABLE wcf1_option ( | |
587 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
588 | packageID INT(10) NOT NULL, | |
589 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
590 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
591 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
592 | optionValue MEDIUMTEXT, | |
593 | validationPattern TEXT, | |
594 | selectOptions MEDIUMTEXT, | |
595 | enableOptions MEDIUMTEXT, | |
596 | showOrder INT(10) NOT NULL DEFAULT 0, | |
597 | hidden TINYINT(1) NOT NULL DEFAULT 0, | |
598 | permissions TEXT, | |
599 | options TEXT, | |
cd6220f2 | 600 | supportI18n TINYINT(1) NOT NULL DEFAULT 0, |
6b45d041 | 601 | requireI18n TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca | 602 | additionalData MEDIUMTEXT, |
0eafcb83 AE |
603 | |
604 | UNIQUE KEY optionName (optionName) | |
158bd3ca TD |
605 | ); |
606 | ||
607 | DROP TABLE IF EXISTS wcf1_option_category; | |
608 | CREATE TABLE wcf1_option_category ( | |
609 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
610 | packageID INT(10) NOT NULL, | |
611 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
612 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', | |
613 | showOrder INT(10) NOT NULL DEFAULT 0, | |
614 | permissions TEXT, | |
615 | options TEXT, | |
0e580f32 | 616 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
617 | ); |
618 | ||
619 | DROP TABLE IF EXISTS wcf1_package; | |
620 | CREATE TABLE wcf1_package ( | |
621 | packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
622 | package VARCHAR(255) NOT NULL DEFAULT '', | |
623 | packageDir VARCHAR(255) NOT NULL DEFAULT '', | |
624 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
158bd3ca TD |
625 | packageDescription VARCHAR(255) NOT NULL DEFAULT '', |
626 | packageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
627 | packageDate INT(10) NOT NULL DEFAULT 0, | |
628 | installDate INT(10) NOT NULL DEFAULT 0, | |
629 | updateDate INT(10) NOT NULL DEFAULT 0, | |
630 | packageURL VARCHAR(255) NOT NULL DEFAULT '', | |
aac1247e | 631 | isApplication TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
632 | author VARCHAR(255) NOT NULL DEFAULT '', |
633 | authorURL VARCHAR(255) NOT NULL DEFAULT '', | |
634 | KEY package (package) | |
635 | ); | |
636 | ||
158bd3ca TD |
637 | DROP TABLE IF EXISTS wcf1_package_exclusion; |
638 | CREATE TABLE wcf1_package_exclusion ( | |
639 | packageID INT(10) NOT NULL, | |
640 | excludedPackage VARCHAR(255) NOT NULL DEFAULT '', | |
641 | excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
642 | UNIQUE KEY packageID (packageID, excludedPackage) | |
643 | ); | |
644 | ||
645 | DROP TABLE IF EXISTS wcf1_package_installation_file_log; | |
646 | CREATE TABLE wcf1_package_installation_file_log ( | |
647 | packageID INT(10), | |
04727c8b | 648 | filename VARCHAR(255) NOT NULL, |
567fa8b8 | 649 | application VARCHAR(20) NOT NULL, |
04727c8b | 650 | UNIQUE KEY applicationFile (application, filename) |
158bd3ca TD |
651 | ); |
652 | ||
653 | DROP TABLE IF EXISTS wcf1_package_installation_form; | |
654 | CREATE TABLE wcf1_package_installation_form ( | |
655 | queueID INT(10) NOT NULL, | |
656 | formName VARCHAR(80) NOT NULL DEFAULT '', | |
657 | document TEXT NOT NULL, | |
658 | UNIQUE KEY formDocument (queueID, formName) | |
659 | ); | |
660 | ||
661 | DROP TABLE IF EXISTS wcf1_package_installation_node; | |
662 | CREATE TABLE wcf1_package_installation_node ( | |
663 | queueID INT(10) NOT NULL, | |
664 | processNo INT(10) NOT NULL DEFAULT 0, | |
665 | sequenceNo SMALLINT(4) NOT NULL DEFAULT 0, | |
666 | node CHAR(8) NOT NULL DEFAULT '', | |
667 | parentNode CHAR(8) NOT NULL DEFAULT '', | |
456008db | 668 | nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package', |
158bd3ca TD |
669 | nodeData TEXT NOT NULL, |
670 | done TINYINT(1) NOT NULL DEFAULT 0 | |
671 | ); | |
672 | ||
673 | DROP TABLE IF EXISTS wcf1_package_installation_plugin; | |
674 | CREATE TABLE wcf1_package_installation_plugin ( | |
675 | pluginName VARCHAR(255) NOT NULL PRIMARY KEY, | |
676 | packageID INT(10), | |
677 | priority TINYINT(1) NOT NULL DEFAULT 0, | |
678 | className VARCHAR(255) NOT NULL | |
679 | ); | |
680 | ||
681 | DROP TABLE IF EXISTS wcf1_package_installation_queue; | |
682 | CREATE TABLE wcf1_package_installation_queue ( | |
683 | queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
684 | parentQueueID INT(10) NOT NULL DEFAULT 0, | |
685 | processNo INT(10) NOT NULL DEFAULT 0, | |
686 | userID INT(10) NOT NULL, | |
687 | package VARCHAR(255) NOT NULL DEFAULT '', | |
688 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
689 | packageID INT(10), | |
690 | archive VARCHAR(255) NOT NULL DEFAULT '', | |
17221357 | 691 | action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install', |
158bd3ca | 692 | done TINYINT(1) NOT NULL DEFAULT 0, |
b33c97d2 | 693 | isApplication TINYINT(1) NOT NULL DEFAULT 0 |
158bd3ca TD |
694 | ); |
695 | ||
696 | DROP TABLE IF EXISTS wcf1_package_installation_sql_log; | |
697 | CREATE TABLE wcf1_package_installation_sql_log ( | |
698 | packageID INT(10), | |
699 | sqlTable VARCHAR(100) NOT NULL DEFAULT '', | |
700 | sqlColumn VARCHAR(100) NOT NULL DEFAULT '', | |
701 | sqlIndex VARCHAR(100) NOT NULL DEFAULT '', | |
702 | UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex) | |
703 | ); | |
704 | ||
1b4f5112 AE |
705 | /* SQL_PARSER_OFFSET */ |
706 | ||
158bd3ca TD |
707 | DROP TABLE IF EXISTS wcf1_package_requirement; |
708 | CREATE TABLE wcf1_package_requirement ( | |
709 | packageID INT(10) NOT NULL, | |
710 | requirement INT(10) NOT NULL, | |
711 | UNIQUE KEY packageID (packageID, requirement) | |
712 | ); | |
713 | ||
158bd3ca TD |
714 | DROP TABLE IF EXISTS wcf1_package_update; |
715 | CREATE TABLE wcf1_package_update ( | |
716 | packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
717 | packageUpdateServerID INT(10) NOT NULL, | |
718 | package VARCHAR(255) NOT NULL DEFAULT '', | |
719 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
720 | packageDescription VARCHAR(255) NOT NULL DEFAULT '', | |
721 | author VARCHAR(255) NOT NULL DEFAULT '', | |
722 | authorURL VARCHAR(255) NOT NULL DEFAULT '', | |
29139546 | 723 | isApplication TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
724 | UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package) |
725 | ); | |
726 | ||
727 | DROP TABLE IF EXISTS wcf1_package_update_exclusion; | |
728 | CREATE TABLE wcf1_package_update_exclusion ( | |
729 | packageUpdateVersionID INT(10) NOT NULL, | |
730 | excludedPackage VARCHAR(255) NOT NULL DEFAULT '', | |
731 | excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
732 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage) | |
733 | ); | |
734 | ||
735 | DROP TABLE IF EXISTS wcf1_package_update_fromversion; | |
736 | CREATE TABLE wcf1_package_update_fromversion ( | |
737 | packageUpdateVersionID INT(10) NOT NULL DEFAULT 0, | |
738 | fromversion VARCHAR(50) NOT NULL DEFAULT '', | |
739 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion) | |
740 | ); | |
741 | ||
411d6f1a AE |
742 | DROP TABLE IF EXISTS wcf1_package_update_optional; |
743 | CREATE TABLE wcf1_package_update_optional ( | |
744 | packageUpdateVersionID INT(10) NOT NULL DEFAULT 0, | |
745 | package VARCHAR(255) NOT NULL DEFAULT '' | |
746 | ); | |
747 | ||
158bd3ca TD |
748 | DROP TABLE IF EXISTS wcf1_package_update_requirement; |
749 | CREATE TABLE wcf1_package_update_requirement ( | |
750 | packageUpdateVersionID INT(10) NOT NULL, | |
751 | package VARCHAR(255) NOT NULL DEFAULT '', | |
752 | minversion VARCHAR(50) NOT NULL DEFAULT '', | |
753 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package) | |
754 | ); | |
755 | ||
756 | DROP TABLE IF EXISTS wcf1_package_update_server; | |
757 | CREATE TABLE wcf1_package_update_server ( | |
758 | packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
759 | serverURL VARCHAR(255) NOT NULL DEFAULT '', | |
760 | loginUsername VARCHAR(255) NOT NULL DEFAULT '', | |
761 | loginPassword VARCHAR(255) NOT NULL DEFAULT '', | |
8f08c7d0 | 762 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
763 | lastUpdateTime INT(10) NOT NULL DEFAULT 0, |
764 | status ENUM('online', 'offline') NOT NULL DEFAULT 'online', | |
2c49099b | 765 | errorMessage TEXT, |
b1701dd0 AE |
766 | apiVersion ENUM('2.0', '2.1') NOT NULL DEFAULT '2.0', |
767 | metaData TEXT | |
158bd3ca TD |
768 | ); |
769 | ||
770 | DROP TABLE IF EXISTS wcf1_package_update_version; | |
771 | CREATE TABLE wcf1_package_update_version ( | |
772 | packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
773 | packageUpdateID INT(10) NOT NULL, | |
774 | packageVersion VARCHAR(50) NOT NULL DEFAULT '', | |
158bd3ca TD |
775 | packageDate INT(10) NOT NULL DEFAULT 0, |
776 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
411d6f1a AE |
777 | license VARCHAR(255) NOT NULL DEFAULT '', |
778 | licenseURL VARCHAR(255) NOT NULL DEFAULT '', | |
b4f1ea02 | 779 | isAccessible TINYINT(1) NOT NULL DEFAULT 1, |
507f6f5b | 780 | isCritical TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
781 | UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion) |
782 | ); | |
783 | ||
158bd3ca TD |
784 | DROP TABLE IF EXISTS wcf1_page_menu_item; |
785 | CREATE TABLE wcf1_page_menu_item ( | |
786 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
787 | packageID INT(10) NOT NULL, | |
788 | menuItem VARCHAR(255) NOT NULL DEFAULT '', | |
789 | parentMenuItem VARCHAR(255) NOT NULL DEFAULT '', | |
1278b477 | 790 | menuItemController VARCHAR(255) NOT NULL DEFAULT '', |
158bd3ca TD |
791 | menuItemLink VARCHAR(255) NOT NULL DEFAULT '', |
792 | menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header', | |
793 | showOrder INT(10) NOT NULL DEFAULT 0, | |
794 | permissions TEXT NULL, | |
795 | options TEXT NULL, | |
796 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
797 | className VARCHAR(255) NOT NULL DEFAULT '', | |
0b074a0c | 798 | isLandingPage TINYINT(1) NOT NULL DEFAULT 0, |
31378fd1 | 799 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
800 | UNIQUE KEY (packageID, menuItem) |
801 | ); | |
802 | ||
4d8036f5 MW |
803 | DROP TABLE IF EXISTS wcf1_paid_subscription; |
804 | CREATE TABLE wcf1_paid_subscription ( | |
805 | subscriptionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
806 | title VARCHAR(255) NOT NULL DEFAULT '', | |
807 | description TEXT, | |
808 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
809 | showOrder INT(10) NOT NULL DEFAULT 0, | |
810 | cost DECIMAL(10,2) NOT NULL DEFAULT 0, | |
811 | currency VARCHAR(3) NOT NULL DEFAULT 'EUR', | |
812 | subscriptionLength SMALLINT(3) NOT NULL DEFAULT 0, | |
813 | subscriptionLengthUnit ENUM('', 'D', 'M', 'Y') NOT NULL DEFAULT '', | |
814 | isRecurring TINYINT(1) NOT NULL DEFAULT 0, | |
815 | groupIDs TEXT, | |
816 | excludedSubscriptionIDs TEXT | |
817 | ); | |
818 | ||
819 | DROP TABLE IF EXISTS wcf1_paid_subscription_user; | |
820 | CREATE TABLE wcf1_paid_subscription_user ( | |
821 | subscriptionUserID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
822 | subscriptionID INT(10) NOT NULL, | |
823 | userID INT(10) NOT NULL, | |
824 | startDate INT(10) NOT NULL DEFAULT 0, | |
825 | endDate INT(10) NOT NULL DEFAULT 0, | |
826 | isActive TINYINT(1) NOT NULL DEFAULT 1, | |
827 | ||
828 | UNIQUE KEY (subscriptionID, userID), | |
829 | KEY (isActive) | |
830 | ); | |
831 | ||
832 | DROP TABLE IF EXISTS wcf1_paid_subscription_transaction_log; | |
833 | CREATE TABLE wcf1_paid_subscription_transaction_log ( | |
834 | logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
835 | subscriptionUserID INT(10), | |
836 | userID INT(10), | |
837 | subscriptionID INT(10), | |
838 | paymentMethodObjectTypeID INT(10) NOT NULL, | |
839 | logTime INT(10) NOT NULL DEFAULT 0, | |
840 | transactionID VARCHAR(255) NOT NULL DEFAULT '', | |
841 | transactionDetails MEDIUMTEXT, | |
842 | logMessage VARCHAR(255) NOT NULL DEFAULT '' | |
843 | ); | |
844 | ||
e25b7b61 MW |
845 | DROP TABLE IF EXISTS wcf1_poll; |
846 | CREATE TABLE wcf1_poll ( | |
847 | pollID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
848 | objectTypeID INT(10) NOT NULL, | |
849 | objectID INT(10) NOT NULL DEFAULT 0, | |
850 | question VARCHAR(255) DEFAULT '', | |
851 | time INT(10) NOT NULL DEFAULT 0, | |
852 | endTime INT(10) NOT NULL DEFAULT 0, | |
853 | isChangeable TINYINT(1) NOT NULL DEFAULT 0, | |
854 | isPublic TINYINT(1) NOT NULL DEFAULT 0, | |
855 | sortByVotes TINYINT(1) NOT NULL DEFAULT 0, | |
856 | resultsRequireVote TINYINT(1) NOT NULL DEFAULT 0, | |
857 | maxVotes INT(10) NOT NULL DEFAULT 1, | |
858 | votes INT(10) NOT NULL DEFAULT 0 | |
859 | ); | |
860 | ||
861 | DROP TABLE IF EXISTS wcf1_poll_option; | |
862 | CREATE TABLE wcf1_poll_option ( | |
863 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
864 | pollID INT(10) NOT NULL, | |
865 | optionValue VARCHAR(255) NOT NULL DEFAULT '', | |
866 | votes INT(10) NOT NULL DEFAULT 0, | |
867 | showOrder INT(10) NOT NULL DEFAULT 0 | |
868 | ); | |
869 | ||
870 | DROP TABLE IF EXISTS wcf1_poll_option_vote; | |
871 | CREATE TABLE wcf1_poll_option_vote ( | |
872 | pollID INT(10) NOT NULL, | |
873 | optionID INT(10) NOT NULL, | |
874 | userID INT(10) NOT NULL, | |
875 | ||
876 | KEY (optionID, userID), | |
877 | UNIQUE KEY vote (pollID, optionID, userID) | |
878 | ); | |
879 | ||
158bd3ca TD |
880 | DROP TABLE IF EXISTS wcf1_search; |
881 | CREATE TABLE wcf1_search ( | |
882 | searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
883 | userID INT(10), | |
884 | searchData MEDIUMTEXT NOT NULL, | |
885 | searchTime INT(10) NOT NULL DEFAULT 0, | |
886 | searchType VARCHAR(255) NOT NULL DEFAULT '', | |
887 | searchHash CHAR(40) NOT NULL DEFAULT '', | |
888 | KEY searchHash (searchHash) | |
889 | ); | |
890 | ||
749cca08 MW |
891 | DROP TABLE IF EXISTS wcf1_search_keyword; |
892 | CREATE TABLE wcf1_search_keyword ( | |
893 | keywordID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
894 | keyword VARCHAR(255) NOT NULL, | |
895 | searches INT(10) NOT NULL DEFAULT 0, | |
896 | lastSearchTime INT(10) NOT NULL DEFAULT 0, | |
897 | UNIQUE KEY (keyword), | |
898 | KEY (searches, lastSearchTime) | |
899 | ); | |
900 | ||
158bd3ca TD |
901 | DROP TABLE IF EXISTS wcf1_session; |
902 | CREATE TABLE wcf1_session ( | |
903 | sessionID CHAR(40) NOT NULL PRIMARY KEY, | |
158bd3ca TD |
904 | userID INT(10), |
905 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
906 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
907 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
908 | requestURI VARCHAR(255) NOT NULL DEFAULT '', | |
98f447b0 | 909 | requestMethod VARCHAR(7) NOT NULL DEFAULT '', |
7aa1a486 | 910 | controller VARCHAR(255) NOT NULL DEFAULT '', |
596e20e2 MW |
911 | parentObjectType VARCHAR(255) NOT NULL DEFAULT '', |
912 | parentObjectID INT(10) NOT NULL DEFAULT 0, | |
913 | objectType VARCHAR(255) NOT NULL DEFAULT '', | |
914 | objectID INT(10) NOT NULL DEFAULT 0, | |
75cf36c3 | 915 | sessionVariables MEDIUMTEXT, |
e8d26212 | 916 | spiderID INT(10), |
46dd7463 | 917 | KEY packageID (lastActivityTime, spiderID), |
6a0a959c | 918 | UNIQUE KEY uniqueUserID (userID) |
158bd3ca TD |
919 | ); |
920 | ||
5a05fde9 AE |
921 | DROP TABLE IF EXISTS wcf1_session_virtual; |
922 | CREATE TABLE wcf1_session_virtual ( | |
d905faf6 | 923 | virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
5a05fde9 AE |
924 | sessionID CHAR(40) NOT NULL, |
925 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
926 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
927 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
928 | UNIQUE KEY (sessionID, ipAddress, userAgent) | |
929 | ); | |
930 | ||
46bd110b AE |
931 | DROP TABLE IF EXISTS wcf1_sitemap; |
932 | CREATE TABLE wcf1_sitemap ( | |
933 | sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
934 | packageID INT(10) NOT NULL, | |
935 | sitemapName VARCHAR(80) NOT NULL DEFAULT '', | |
936 | className VARCHAR(255) NOT NULL DEFAULT '', | |
68541bb5 | 937 | showOrder INT(10) NOT NULL DEFAULT 0, |
a3e0f4f3 MW |
938 | permissions TEXT NULL, |
939 | options TEXT NULL, | |
46bd110b AE |
940 | UNIQUE KEY sitemapName (packageID, sitemapName) |
941 | ); | |
942 | ||
dcc2332d MW |
943 | DROP TABLE IF EXISTS wcf1_smiley; |
944 | CREATE TABLE wcf1_smiley ( | |
945 | smileyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
946 | packageID INT(10) NOT NULL, | |
947 | categoryID INT(10), | |
948 | smileyPath VARCHAR(255) NOT NULL DEFAULT '', | |
949 | smileyTitle VARCHAR(255) NOT NULL DEFAULT '', | |
950 | smileyCode VARCHAR(255) NOT NULL DEFAULT '', | |
951 | aliases TEXT NOT NULL, | |
952 | showOrder INT(10) NOT NULL DEFAULT 0, | |
953 | UNIQUE KEY smileyCode (smileyCode) | |
954 | ); | |
955 | ||
158bd3ca TD |
956 | DROP TABLE IF EXISTS wcf1_spider; |
957 | CREATE TABLE wcf1_spider ( | |
958 | spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
959 | spiderIdentifier VARCHAR(255) DEFAULT '', | |
960 | spiderName VARCHAR(255) DEFAULT '', | |
961 | spiderURL VARCHAR(255) DEFAULT '', | |
962 | UNIQUE KEY spiderIdentifier (spiderIdentifier) | |
963 | ); | |
964 | ||
891de7a0 MW |
965 | DROP TABLE IF EXISTS wcf1_stat_daily; |
966 | CREATE TABLE wcf1_stat_daily ( | |
e1fe9453 | 967 | statID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
891de7a0 MW |
968 | objectTypeID INT(10) NOT NULL, |
969 | date DATE NOT NULL, | |
970 | counter INT(10) NOT NULL DEFAULT 0, | |
971 | total INT(10) NOT NULL DEFAULT 0, | |
972 | ||
973 | UNIQUE KEY (objectTypeID, date) | |
974 | ); | |
975 | ||
158bd3ca TD |
976 | DROP TABLE IF EXISTS wcf1_style; |
977 | CREATE TABLE wcf1_style ( | |
978 | styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
979 | packageID INT(10) NOT NULL, | |
980 | styleName VARCHAR(255) NOT NULL DEFAULT '', | |
981 | templateGroupID INT(10) NOT NULL DEFAULT 0, | |
982 | isDefault TINYINT(1) NOT NULL DEFAULT 0, | |
8f08c7d0 | 983 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
d3478df7 | 984 | styleDescription VARCHAR(30) NOT NULL DEFAULT '', |
158bd3ca TD |
985 | styleVersion VARCHAR(255) NOT NULL DEFAULT '', |
986 | styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00', | |
987 | image VARCHAR(255) NOT NULL DEFAULT '', | |
988 | copyright VARCHAR(255) NOT NULL DEFAULT '', | |
989 | license VARCHAR(255) NOT NULL DEFAULT '', | |
990 | authorName VARCHAR(255) NOT NULL DEFAULT '', | |
fa83e8f7 | 991 | authorURL VARCHAR(255) NOT NULL DEFAULT '', |
ee013cde | 992 | imagePath VARCHAR(255) NOT NULL DEFAULT '' |
158bd3ca TD |
993 | ); |
994 | ||
158bd3ca TD |
995 | DROP TABLE IF EXISTS wcf1_style_variable; |
996 | CREATE TABLE wcf1_style_variable ( | |
4d9f6058 AE |
997 | variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
998 | variableName VARCHAR(50) NOT NULL, | |
999 | defaultValue MEDIUMTEXT, | |
1000 | UNIQUE KEY variableName (variableName) | |
158bd3ca TD |
1001 | ); |
1002 | ||
4d9f6058 AE |
1003 | DROP TABLE IF EXISTS wcf1_style_variable_value; |
1004 | CREATE TABLE wcf1_style_variable_value ( | |
158bd3ca | 1005 | styleID INT(10) NOT NULL, |
4d9f6058 | 1006 | variableID INT(10) NOT NULL, |
158bd3ca | 1007 | variableValue MEDIUMTEXT, |
4d9f6058 | 1008 | UNIQUE KEY (styleID, variableID) |
158bd3ca TD |
1009 | ); |
1010 | ||
04c06e85 MW |
1011 | DROP TABLE IF EXISTS wcf1_tag; |
1012 | CREATE TABLE wcf1_tag ( | |
1013 | tagID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1014 | languageID INT(10) NOT NULL DEFAULT 0, | |
1015 | name VARCHAR(255) NOT NULL, | |
1016 | synonymFor INT(10), | |
1017 | UNIQUE KEY (languageID, name) | |
1018 | ); | |
1019 | ||
1020 | DROP TABLE IF EXISTS wcf1_tag_to_object; | |
1021 | CREATE TABLE wcf1_tag_to_object ( | |
1022 | objectID INT(10) NOT NULL, | |
1023 | tagID INT(10) NOT NULL, | |
1024 | objectTypeID INT(10) NOT NULL, | |
1025 | languageID INT(10) NOT NULL, | |
1026 | UNIQUE KEY (objectTypeID, languageID, objectID, tagID), | |
1027 | KEY (objectTypeID, languageID, tagID), | |
1028 | KEY (tagID, objectTypeID) | |
1029 | ); | |
1030 | ||
158bd3ca TD |
1031 | DROP TABLE IF EXISTS wcf1_template; |
1032 | CREATE TABLE wcf1_template ( | |
1033 | templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1034 | packageID INT(10) NOT NULL, | |
04727c8b | 1035 | templateName VARCHAR(255) NOT NULL, |
567fa8b8 | 1036 | application VARCHAR(20) NOT NULL, |
158bd3ca | 1037 | templateGroupID INT(10), |
6570e38e | 1038 | lastModificationTime INT(10) NOT NULL DEFAULT 0, |
e568316b | 1039 | UNIQUE KEY applicationTemplate (application, templateGroupID, templateName), |
158bd3ca TD |
1040 | KEY templateGroupID (packageID, templateGroupID, templateName) |
1041 | ); | |
1042 | ||
1043 | DROP TABLE IF EXISTS wcf1_template_group; | |
1044 | CREATE TABLE wcf1_template_group ( | |
1045 | templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
6570e38e | 1046 | parentTemplateGroupID INT(10), |
158bd3ca TD |
1047 | templateGroupName VARCHAR(255) NOT NULL DEFAULT '', |
1048 | templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT '' | |
1049 | ); | |
1050 | ||
0a67f96c MS |
1051 | DROP TABLE IF EXISTS wcf1_template_listener; |
1052 | CREATE TABLE wcf1_template_listener ( | |
1053 | listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1054 | packageID INT(10) NOT NULL, | |
1055 | name VARCHAR(80) NOT NULL DEFAULT '', | |
1056 | environment ENUM('user','admin') NOT NULL DEFAULT 'user', | |
1057 | templateName VARCHAR(80) NOT NULL DEFAULT '', | |
1058 | eventName VARCHAR(50) NOT NULL DEFAULT '', | |
1059 | templateCode TEXT NOT NULL, | |
da84cf75 | 1060 | niceValue TINYINT(3) NOT NULL DEFAULT 0, |
0a67f96c MS |
1061 | KEY templateName (environment, templateName) |
1062 | ); | |
1063 | ||
320f4a6d MW |
1064 | DROP TABLE IF EXISTS wcf1_tracked_visit; |
1065 | CREATE TABLE wcf1_tracked_visit ( | |
1066 | objectTypeID INT(10) NOT NULL, | |
1067 | objectID INT(10) NOT NULL, | |
1068 | userID INT(10) NOT NULL, | |
1069 | visitTime INT(10) NOT NULL DEFAULT 0, | |
1070 | UNIQUE KEY (objectTypeID, objectID, userID), | |
1071 | KEY (userID, visitTime) | |
1072 | ); | |
1073 | ||
1074 | DROP TABLE IF EXISTS wcf1_tracked_visit_type; | |
1075 | CREATE TABLE wcf1_tracked_visit_type ( | |
1076 | objectTypeID INT(10) NOT NULL, | |
1077 | userID INT(10) NOT NULL, | |
1078 | visitTime INT(10) NOT NULL DEFAULT 0, | |
1079 | UNIQUE KEY (objectTypeID, userID), | |
1080 | KEY (userID, visitTime) | |
1081 | ); | |
1082 | ||
158bd3ca TD |
1083 | DROP TABLE IF EXISTS wcf1_user; |
1084 | CREATE TABLE wcf1_user ( | |
1085 | userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1086 | username VARCHAR(255) NOT NULL DEFAULT '', | |
1087 | email VARCHAR(255) NOT NULL DEFAULT '', | |
4e273b1f | 1088 | password VARCHAR(100) NOT NULL DEFAULT '', |
6a41a21e | 1089 | accessToken CHAR(40) NOT NULL DEFAULT '', |
158bd3ca TD |
1090 | languageID INT(10) NOT NULL DEFAULT 0, |
1091 | registrationDate INT(10) NOT NULL DEFAULT 0, | |
1092 | styleID INT(10) NOT NULL DEFAULT 0, | |
b1356a27 MW |
1093 | banned TINYINT(1) NOT NULL DEFAULT 0, |
1094 | banReason MEDIUMTEXT NULL, | |
f034d0ec | 1095 | banExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1096 | activationCode INT(10) NOT NULL DEFAULT 0, |
1097 | lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0, | |
1098 | lostPasswordKey VARCHAR(40) NOT NULL DEFAULT '', | |
1099 | lastUsernameChange INT(10) NOT NULL DEFAULT 0, | |
1100 | newEmail VARCHAR(255) NOT NULL DEFAULT '', | |
1101 | oldUsername VARCHAR(255) NOT NULL DEFAULT '', | |
1102 | quitStarted INT(10) NOT NULL DEFAULT 0, | |
1103 | reactivationCode INT(10) NOT NULL DEFAULT 0, | |
1104 | registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1105 | avatarID INT(10), | |
1106 | disableAvatar TINYINT(1) NOT NULL DEFAULT 0, | |
1107 | disableAvatarReason TEXT, | |
f034d0ec | 1108 | disableAvatarExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d | 1109 | enableGravatar TINYINT(1) NOT NULL DEFAULT 0, |
4ae7fdc1 | 1110 | gravatarFileExtension VARCHAR(3) NOT NULL DEFAULT '', |
320f4a6d MW |
1111 | signature TEXT, |
1112 | signatureEnableBBCodes TINYINT(1) NOT NULL DEFAULT 1, | |
1113 | signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0, | |
1114 | signatureEnableSmilies TINYINT(1) NOT NULL DEFAULT 1, | |
1115 | disableSignature TINYINT(1) NOT NULL DEFAULT 0, | |
1116 | disableSignatureReason TEXT, | |
f034d0ec | 1117 | disableSignatureExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1118 | lastActivityTime INT(10) NOT NULL DEFAULT 0, |
1119 | profileHits INT(10) NOT NULL DEFAULT 0, | |
1120 | rankID INT(10), | |
1121 | userTitle VARCHAR(255) NOT NULL DEFAULT '', | |
1122 | userOnlineGroupID INT(10), | |
1123 | activityPoints INT(10) NOT NULL DEFAULT 0, | |
1124 | notificationMailToken VARCHAR(20) NOT NULL DEFAULT '', | |
1125 | authData VARCHAR(255) NOT NULL DEFAULT '', | |
00b6f956 | 1126 | likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0, |
9ed42d00 | 1127 | socialNetworkPrivacySettings TEXT, |
158bd3ca TD |
1128 | |
1129 | KEY username (username), | |
1130 | KEY registrationDate (registrationDate), | |
320f4a6d MW |
1131 | KEY styleID (styleID), |
1132 | KEY activationCode (activationCode), | |
1133 | KEY registrationData (registrationIpAddress, registrationDate), | |
00b6f956 MW |
1134 | KEY activityPoints (activityPoints), |
1135 | KEY likesReceived (likesReceived) | |
320f4a6d MW |
1136 | ); |
1137 | ||
1138 | DROP TABLE IF EXISTS wcf1_user_activity_event; | |
1139 | CREATE TABLE wcf1_user_activity_event ( | |
1140 | eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1141 | objectTypeID INT(10) NOT NULL, | |
1142 | objectID INT(10) NOT NULL, | |
1143 | languageID INT(10), | |
1144 | userID INT(10) NOT NULL, | |
1145 | time INT(10) NOT NULL, | |
1146 | additionalData TEXT, | |
1147 | ||
1148 | KEY (time), | |
1149 | KEY (userID, time), | |
1150 | KEY (objectTypeID, objectID) | |
1151 | ); | |
1152 | ||
1153 | DROP TABLE IF EXISTS wcf1_user_activity_point; | |
1154 | CREATE TABLE wcf1_user_activity_point ( | |
1155 | userID INT(10) NOT NULL, | |
1156 | objectTypeID INT(10) NOT NULL, | |
1157 | activityPoints INT(10) NOT NULL DEFAULT 0, | |
a16ee110 | 1158 | items INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1159 | PRIMARY KEY (userID, objectTypeID), |
1160 | KEY (objectTypeID) | |
1161 | ); | |
1162 | ||
359f3c53 MW |
1163 | DROP TABLE IF EXISTS wcf1_user_authentication_failure; |
1164 | CREATE TABLE wcf1_user_authentication_failure ( | |
1165 | failureID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1166 | environment ENUM('user', 'admin') NOT NULL DEFAULT 'user', | |
1167 | userID INT(10), | |
1168 | username VARCHAR(255) NOT NULL DEFAULT '', | |
1169 | time INT(10) NOT NULL DEFAULT 0, | |
1170 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1171 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
1172 | KEY (ipAddress, time), | |
1173 | KEY (time) | |
1174 | ); | |
1175 | ||
320f4a6d MW |
1176 | DROP TABLE IF EXISTS wcf1_user_avatar; |
1177 | CREATE TABLE wcf1_user_avatar ( | |
1178 | avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1179 | avatarName VARCHAR(255) NOT NULL DEFAULT '', | |
1180 | avatarExtension VARCHAR(7) NOT NULL DEFAULT '', | |
1181 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
1182 | height SMALLINT(5) NOT NULL DEFAULT 0, | |
1183 | userID INT(10), | |
1184 | fileHash VARCHAR(40) NOT NULL DEFAULT '', | |
1185 | cropX SMALLINT(5) NOT NULL DEFAULT 0, | |
1186 | cropY SMALLINT(5) NOT NULL DEFAULT 0 | |
158bd3ca TD |
1187 | ); |
1188 | ||
a8e8aa21 AE |
1189 | DROP TABLE IF EXISTS wcf1_user_collapsible_content; |
1190 | CREATE TABLE wcf1_user_collapsible_content ( | |
1191 | objectTypeID INT(10) NOT NULL, | |
644b0ee3 | 1192 | objectID VARCHAR(255) NOT NULL, |
a8e8aa21 AE |
1193 | userID INT(10) NOT NULL, |
1194 | UNIQUE KEY (objectTypeID, objectID, userID) | |
1195 | ); | |
1196 | ||
320f4a6d MW |
1197 | DROP TABLE IF EXISTS wcf1_user_follow; |
1198 | CREATE TABLE wcf1_user_follow ( | |
1199 | followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1200 | userID INT(10) NOT NULL, | |
1201 | followUserID INT(10) NOT NULL, | |
1202 | time INT(10) NOT NULL DEFAULT 0, | |
1203 | UNIQUE KEY (userID, followUserID) | |
1204 | ); | |
1205 | ||
158bd3ca TD |
1206 | DROP TABLE IF EXISTS wcf1_user_group; |
1207 | CREATE TABLE wcf1_user_group ( | |
1208 | groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1209 | groupName VARCHAR(255) NOT NULL DEFAULT '', | |
005f6926 | 1210 | groupDescription TEXT, |
320f4a6d MW |
1211 | groupType TINYINT(1) NOT NULL DEFAULT 4, |
1212 | priority MEDIUMINT(8) NOT NULL DEFAULT 0, | |
1213 | userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s', | |
1214 | showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0 | |
158bd3ca TD |
1215 | ); |
1216 | ||
87d3a054 MS |
1217 | DROP TABLE IF EXISTS wcf1_user_group_assignment; |
1218 | CREATE TABLE wcf1_user_group_assignment ( | |
1219 | assignmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1220 | groupID INT(10) NOT NULL, | |
1221 | title VARCHAR(255) NOT NULL, | |
1222 | isDisabled TINYINT(1) NOT NULL DEFAULT 0 | |
1223 | ); | |
1224 | ||
158bd3ca | 1225 | DROP TABLE IF EXISTS wcf1_user_group_option; |
01bd2eff | 1226 | CREATE TABLE wcf1_user_group_option ( |
158bd3ca TD |
1227 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
1228 | packageID INT(10), | |
1229 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
1230 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1231 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
1232 | defaultValue MEDIUMTEXT, | |
158bd3ca TD |
1233 | validationPattern TEXT, |
1234 | enableOptions MEDIUMTEXT, | |
1235 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1236 | permissions TEXT, | |
1237 | options TEXT, | |
ae6b590f | 1238 | usersOnly TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1239 | additionalData MEDIUMTEXT, |
1240 | UNIQUE KEY optionName (optionName, packageID) | |
1241 | ); | |
1242 | ||
1243 | DROP TABLE IF EXISTS wcf1_user_group_option_category; | |
1244 | CREATE TABLE wcf1_user_group_option_category ( | |
1245 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1246 | packageID INT(10) NOT NULL, | |
1247 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1248 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1249 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1250 | permissions TEXT, | |
1251 | options TEXT, | |
0e580f32 | 1252 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
1253 | ); |
1254 | ||
1255 | DROP TABLE IF EXISTS wcf1_user_group_option_value; | |
01bd2eff | 1256 | CREATE TABLE wcf1_user_group_option_value ( |
158bd3ca TD |
1257 | groupID INT(10) NOT NULL, |
1258 | optionID INT(10) NOT NULL, | |
1259 | optionValue MEDIUMTEXT NOT NULL, | |
1260 | UNIQUE KEY groupID (groupID, optionID) | |
1261 | ); | |
1262 | ||
320f4a6d MW |
1263 | DROP TABLE IF EXISTS wcf1_user_ignore; |
1264 | CREATE TABLE wcf1_user_ignore ( | |
1265 | ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1266 | userID INT(10) NOT NULL, | |
1267 | ignoreUserID INT(10) NOT NULL, | |
1268 | time INT(10) NOT NULL DEFAULT 0, | |
1269 | UNIQUE KEY (userID, ignoreUserID) | |
1270 | ); | |
1271 | ||
1272 | DROP TABLE IF EXISTS wcf1_user_menu_item; | |
1273 | CREATE TABLE wcf1_user_menu_item ( | |
1274 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1275 | packageID INT(10) NOT NULL, | |
1276 | menuItem VARCHAR(255) NOT NULL DEFAULT '', | |
1277 | parentMenuItem VARCHAR(255) NOT NULL DEFAULT '', | |
1278 | menuItemController VARCHAR(255) NOT NULL DEFAULT '', | |
1279 | menuItemLink VARCHAR(255) NOT NULL DEFAULT '', | |
1280 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1281 | permissions TEXT, | |
1282 | options TEXT, | |
1283 | className VARCHAR(255) NOT NULL DEFAULT '', | |
a82bf781 | 1284 | iconClassName VARCHAR(255) NOT NULL DEFAULT '', |
320f4a6d MW |
1285 | UNIQUE KEY menuItem (menuItem, packageID) |
1286 | ); | |
1287 | ||
1288 | -- notifications | |
1289 | DROP TABLE IF EXISTS wcf1_user_notification; | |
1290 | CREATE TABLE wcf1_user_notification ( | |
1291 | notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
8a4289f5 | 1292 | packageID INT(10) NOT NULL, -- DEPRECATED |
320f4a6d MW |
1293 | eventID INT(10) NOT NULL, |
1294 | objectID INT(10) NOT NULL DEFAULT 0, | |
6db83ca9 | 1295 | baseObjectID INT(10) NOT NULL DEFAULT 0, -- base object ID for generic implementations referencing the origin, e.g. the object being liked |
68206b3f | 1296 | eventHash VARCHAR(40) NOT NULL DEFAULT '', |
4341fcab | 1297 | authorID INT(10) NULL, |
68206b3f | 1298 | timesTriggered INT(10) NOT NULL DEFAULT 0, |
afb18fa2 | 1299 | guestTimesTriggered INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1300 | userID INT(10) NOT NULL, |
320f4a6d | 1301 | time INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1302 | mailNotified TINYINT(1) NOT NULL DEFAULT 0, |
078256b5 | 1303 | confirmTime INT(10) NOT NULL DEFAULT 0, |
320f4a6d | 1304 | additionalData TEXT, |
078256b5 AE |
1305 | KEY (userID, eventID, objectID, confirmTime), |
1306 | KEY (userID, confirmTime) | |
4341fcab AE |
1307 | ); |
1308 | ||
1309 | -- notification authors (stacking) | |
1310 | DROP TABLE IF EXISTS wcf1_user_notification_author; | |
1311 | CREATE TABLE wcf1_user_notification_author ( | |
1312 | notificationID INT(10) NOT NULL, | |
afb18fa2 | 1313 | authorID INT(10), |
4341fcab | 1314 | time INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1315 | UNIQUE KEY (notificationID, authorID) |
320f4a6d MW |
1316 | ); |
1317 | ||
1318 | -- notification recipients | |
4341fcab | 1319 | -- DEPRECATED |
320f4a6d MW |
1320 | DROP TABLE IF EXISTS wcf1_user_notification_to_user; |
1321 | CREATE TABLE wcf1_user_notification_to_user ( | |
1322 | notificationID INT(10) NOT NULL, | |
1323 | userID INT(10) NOT NULL, | |
320f4a6d MW |
1324 | UNIQUE KEY notificationID (notificationID, userID) |
1325 | ); | |
1326 | ||
1327 | -- events that create notifications | |
1328 | DROP TABLE IF EXISTS wcf1_user_notification_event; | |
1329 | CREATE TABLE wcf1_user_notification_event ( | |
1330 | eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1331 | packageID INT(10) NOT NULL, | |
1332 | eventName VARCHAR(255) NOT NULL DEFAULT '', | |
1333 | objectTypeID INT(10) NOT NULL, | |
1334 | className VARCHAR(255) NOT NULL DEFAULT '', | |
1335 | permissions TEXT, | |
1336 | options TEXT, | |
2d7c568a | 1337 | preset TINYINT(1) NOT NULL DEFAULT 0, |
0ceb9e95 | 1338 | presetMailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none', |
320f4a6d MW |
1339 | UNIQUE KEY eventName (eventName, objectTypeID) |
1340 | ); | |
1341 | ||
1342 | -- user configuration for events | |
1343 | DROP TABLE IF EXISTS wcf1_user_notification_event_to_user; | |
1344 | CREATE TABLE wcf1_user_notification_event_to_user ( | |
1345 | userID INT(10) NOT NULL, | |
1346 | eventID INT(10) NOT NULL, | |
1347 | mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none', | |
1348 | UNIQUE KEY (eventID, userID) | |
1349 | ); | |
1350 | ||
1351 | DROP TABLE IF EXISTS wcf1_user_object_watch; | |
1352 | CREATE TABLE wcf1_user_object_watch ( | |
1353 | watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1354 | objectTypeID INT(10) NOT NULL, | |
1355 | objectID INT(10) NOT NULL, | |
1356 | userID INT(10) NOT NULL, | |
1357 | notification TINYINT(1) NOT NULL DEFAULT 0, | |
1358 | ||
1359 | UNIQUE KEY (objectTypeID, userID, objectID), | |
1360 | KEY (objectTypeID, objectID) | |
1361 | ); | |
1362 | ||
158bd3ca TD |
1363 | DROP TABLE IF EXISTS wcf1_user_option; |
1364 | CREATE TABLE wcf1_user_option ( | |
1365 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1366 | packageID INT(10) NOT NULL, | |
1367 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
1368 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1369 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
1370 | defaultValue MEDIUMTEXT, | |
1371 | validationPattern TEXT, | |
1372 | selectOptions MEDIUMTEXT, | |
1373 | enableOptions MEDIUMTEXT, | |
1374 | required TINYINT(1) NOT NULL DEFAULT 0, | |
1375 | askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0, | |
1376 | editable TINYINT(1) NOT NULL DEFAULT 0, | |
1377 | visible TINYINT(1) NOT NULL DEFAULT 0, | |
1378 | outputClass VARCHAR(255) NOT NULL DEFAULT '', | |
1379 | searchable TINYINT(1) NOT NULL DEFAULT 0, | |
1380 | showOrder INT(10) NOT NULL DEFAULT 0, | |
8f08c7d0 | 1381 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1382 | permissions TEXT, |
1383 | options TEXT, | |
1384 | additionalData MEDIUMTEXT, | |
31378fd1 | 1385 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1386 | UNIQUE KEY optionName (optionName, packageID), |
1387 | KEY categoryName (categoryName) | |
1388 | ); | |
1389 | ||
1390 | DROP TABLE IF EXISTS wcf1_user_option_category; | |
1391 | CREATE TABLE wcf1_user_option_category ( | |
1392 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1393 | packageID INT(10) NOT NULL, | |
1394 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
158bd3ca TD |
1395 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', |
1396 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1397 | permissions TEXT, | |
1398 | options TEXT, | |
0e580f32 | 1399 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
1400 | ); |
1401 | ||
1402 | DROP TABLE IF EXISTS wcf1_user_option_value; | |
1403 | CREATE TABLE wcf1_user_option_value ( | |
1404 | userID INT(10) NOT NULL PRIMARY KEY | |
1405 | ); | |
1406 | ||
320f4a6d MW |
1407 | DROP TABLE IF EXISTS wcf1_user_profile_menu_item; |
1408 | CREATE TABLE wcf1_user_profile_menu_item ( | |
1409 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1410 | packageID INT(10) NOT NULL, | |
1411 | menuItem VARCHAR(255) NOT NULL, | |
1412 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1413 | permissions TEXT NULL, | |
1414 | options TEXT NULL, | |
1415 | className VARCHAR(255) NOT NULL, | |
1416 | UNIQUE KEY (packageID, menuItem) | |
1417 | ); | |
1418 | ||
1419 | DROP TABLE IF EXISTS wcf1_user_profile_visitor; | |
1420 | CREATE TABLE wcf1_user_profile_visitor ( | |
1421 | visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1422 | ownerID INT(10), | |
1423 | userID INT(10), | |
1424 | time INT(10) NOT NULL DEFAULT 0, | |
1425 | UNIQUE KEY (ownerID, userID), | |
1426 | KEY (time) | |
1427 | ); | |
1428 | ||
1429 | DROP TABLE IF EXISTS wcf1_user_rank; | |
1430 | CREATE TABLE wcf1_user_rank ( | |
1431 | rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
d2fbb3b5 | 1432 | groupID INT(10) NOT NULL, |
320f4a6d MW |
1433 | requiredPoints INT(10) NOT NULL DEFAULT 0, |
1434 | rankTitle VARCHAR(255) NOT NULL DEFAULT '', | |
1435 | cssClassName VARCHAR(255) NOT NULL DEFAULT '', | |
1436 | rankImage VARCHAR(255) NOT NULL DEFAULT '', | |
1437 | repeatImage TINYINT(3) NOT NULL DEFAULT 1, | |
1438 | requiredGender TINYINT(1) NOT NULL DEFAULT 0 | |
1439 | ); | |
1440 | ||
0a67f96c MS |
1441 | DROP TABLE IF EXISTS wcf1_user_storage; |
1442 | CREATE TABLE wcf1_user_storage ( | |
1443 | userID INT(10) NOT NULL, | |
1444 | field VARCHAR(80) NOT NULL DEFAULT '', | |
064caa4a | 1445 | fieldValue MEDIUMTEXT, |
0b30544a | 1446 | UNIQUE KEY userStorageData (userID, field) |
0a67f96c MS |
1447 | ); |
1448 | ||
158bd3ca TD |
1449 | DROP TABLE IF EXISTS wcf1_user_to_group; |
1450 | CREATE TABLE wcf1_user_to_group ( | |
1451 | userID INT(10) NOT NULL, | |
1452 | groupID INT(10) NOT NULL, | |
1453 | UNIQUE KEY userID (userID, groupID) | |
1454 | ); | |
1455 | ||
1456 | DROP TABLE IF EXISTS wcf1_user_to_language; | |
1457 | CREATE TABLE wcf1_user_to_language ( | |
1458 | userID INT(10) NOT NULL, | |
1459 | languageID INT(10) NOT NULL, | |
1460 | UNIQUE KEY userID (userID, languageID) | |
1461 | ); | |
1462 | ||
2fbf5046 AE |
1463 | /* SQL_PARSER_OFFSET */ |
1464 | ||
9f959ced | 1465 | /* foreign keys */ |
092bdf82 AE |
1466 | ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1467 | ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1468 | ||
1469 | ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1470 | ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1471 | ||
1472 | ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE; | |
1473 | ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1474 | ||
1475 | ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE; | |
1476 | ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1477 | ||
158bd3ca TD |
1478 | ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1479 | ||
e9311b98 AE |
1480 | ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1481 | ||
158bd3ca | 1482 | ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
158bd3ca TD |
1483 | |
1484 | ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE; | |
158bd3ca | 1485 | |
158bd3ca TD |
1486 | ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
1487 | ||
1488 | ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1489 | ||
e866b80e MS |
1490 | ALTER TABLE wcf1_ad ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1491 | ||
158bd3ca | 1492 | ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
158bd3ca | 1493 | |
f0bc263f MW |
1494 | ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1495 | ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1496 | ||
dcc2332d MW |
1497 | ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1498 | ||
1499 | ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE; | |
1500 | ||
13d8b49b MS |
1501 | ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1502 | ||
054db725 TD |
1503 | ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1504 | ||
0e6741f8 AE |
1505 | ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1506 | ||
25cf4d11 | 1507 | ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
0e6741f8 AE |
1508 | |
1509 | ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE; | |
1510 | ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1511 | ||
87d3a054 MS |
1512 | ALTER TABLE wcf1_condition ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1513 | ||
158bd3ca TD |
1514 | ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1515 | ||
1516 | ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1517 | ||
1518 | ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE; | |
1519 | ||
81aa6374 TD |
1520 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1521 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
f86d7ff7 | 1522 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (obsoletedByUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
81aa6374 | 1523 | |
158bd3ca TD |
1524 | ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1525 | ||
1526 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1527 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE; | |
1528 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1529 | ||
3a2de7fd AE |
1530 | ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1531 | ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1532 | ||
7fcc7676 MW |
1533 | ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE; |
1534 | ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1535 | ||
1536 | ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1537 | ||
158bd3ca TD |
1538 | ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1539 | ||
1540 | ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1541 | ||
158bd3ca TD |
1542 | ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1543 | ||
1544 | ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1545 | ||
1546 | ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE; | |
1547 | ||
1548 | ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE; | |
1549 | ||
1550 | ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1551 | ||
1552 | ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1553 | ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL; | |
1554 | ||
1555 | ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1556 | ||
1b4f5112 AE |
1557 | /* SQL_PARSER_OFFSET */ |
1558 | ||
158bd3ca TD |
1559 | ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1560 | ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1561 | ||
158bd3ca TD |
1562 | ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE; |
1563 | ||
1564 | ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1565 | ||
1566 | ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1567 | ||
1568 | ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1569 | ||
b4f1ea02 | 1570 | ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; |
158bd3ca TD |
1571 | |
1572 | ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE; | |
1573 | ||
4d8036f5 MW |
1574 | ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE CASCADE; |
1575 | ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1576 | ||
1577 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionUserID) REFERENCES wcf1_paid_subscription_user (subscriptionUserID) ON DELETE SET NULL; | |
1578 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1579 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE SET NULL; | |
1580 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (paymentMethodObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1581 | ||
158bd3ca TD |
1582 | ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1583 | ||
1584 | ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1585 | ||
158bd3ca | 1586 | ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
e8d26212 | 1587 | ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE; |
158bd3ca | 1588 | |
281ac362 | 1589 | ALTER TABLE wcf1_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_session (sessionID) ON DELETE CASCADE ON UPDATE CASCADE; |
5a05fde9 | 1590 | |
46bd110b AE |
1591 | ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1592 | ||
dcc2332d MW |
1593 | ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1594 | ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL; | |
1595 | ||
461a69ea | 1596 | ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
158bd3ca TD |
1597 | |
1598 | ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1599 | ||
4d9f6058 AE |
1600 | ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE; |
1601 | ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE; | |
158bd3ca TD |
1602 | |
1603 | ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1604 | ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE; | |
1605 | ||
6570e38e MW |
1606 | ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL; |
1607 | ||
158bd3ca TD |
1608 | ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1609 | ||
a8e8aa21 AE |
1610 | ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1611 | ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1612 | ||
87d3a054 MS |
1613 | ALTER TABLE wcf1_user_group_assignment ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; |
1614 | ||
158bd3ca TD |
1615 | ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1616 | ||
1617 | ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1618 | ||
1619 | ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1620 | ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE; | |
1621 | ||
2fbf5046 AE |
1622 | /* SQL_PARSER_OFFSET */ |
1623 | ||
158bd3ca TD |
1624 | ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1625 | ||
1626 | ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1627 | ||
1628 | ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1629 | ||
1630 | ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1631 | ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1632 | ||
1633 | ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1634 | ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1635 | ||
320f4a6d MW |
1636 | ALTER TABLE wcf1_dashboard_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1637 | ||
1638 | ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1639 | ALTER TABLE wcf1_dashboard_option ADD FOREIGN KEY (boxID) REFERENCES wcf1_dashboard_box (boxID) ON DELETE CASCADE; | |
1640 | ||
78db8ddf MW |
1641 | ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1642 | ||
320f4a6d MW |
1643 | ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1644 | ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1645 | ||
1646 | ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1647 | ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1648 | ||
1649 | ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL; | |
1650 | ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL; | |
1651 | ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL; | |
1652 | ||
1653 | ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1654 | ||
1655 | ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1656 | ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1657 | ||
1658 | ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1659 | ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1660 | ||
1661 | ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1662 | ||
320f4a6d MW |
1663 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE; |
1664 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
4341fcab AE |
1665 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1666 | ||
1667 | ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE; | |
1668 | ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
320f4a6d MW |
1669 | |
1670 | ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE; | |
1671 | ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1672 | ||
1673 | ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1674 | ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1675 | ||
1676 | ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1677 | ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE; | |
1678 | ||
1679 | ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1680 | ||
1b4f5112 AE |
1681 | /* SQL_PARSER_OFFSET */ |
1682 | ||
d2fbb3b5 | 1683 | ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; |
320f4a6d MW |
1684 | |
1685 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1686 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1687 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL; | |
1688 | ||
1689 | ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1690 | ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1691 | ||
359f3c53 MW |
1692 | ALTER TABLE wcf1_user_authentication_failure ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
1693 | ||
320f4a6d MW |
1694 | ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1695 | ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1696 | ||
1697 | ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1698 | ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1699 | ||
0a2b09a2 MW |
1700 | ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (messageObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1701 | ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (embeddedObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1702 | ||
fc69b61d MW |
1703 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1704 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1705 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1706 | ||
1707 | ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE; | |
1708 | ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1709 | ||
00b6f956 MW |
1710 | ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1711 | ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1712 | ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1713 | ||
1714 | ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1715 | ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1716 | ||
285b1d92 MW |
1717 | ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1718 | ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1719 | ||
1720 | ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE; | |
1721 | ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1722 | ||
3b75466f MW |
1723 | ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE; |
1724 | ||
1725 | ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE; | |
1726 | ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1727 | ||
1728 | ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE; | |
1729 | ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1730 | ||
04c06e85 MW |
1731 | ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE; |
1732 | ||
1733 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE; | |
1734 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1735 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1736 | ||
891de7a0 MW |
1737 | ALTER TABLE wcf1_stat_daily ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1738 | ||
e25b7b61 MW |
1739 | ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1740 | ||
1741 | ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE; | |
1742 | ||
1743 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE; | |
1744 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE; | |
1745 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1746 | ||
20933e61 MS |
1747 | ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (noticeID) REFERENCES wcf1_notice (noticeID) ON DELETE CASCADE; |
1748 | ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1749 | ||
2fbf5046 AE |
1750 | /* SQL_PARSER_OFFSET */ |
1751 | ||
9f959ced | 1752 | /* default inserts */ |
158bd3ca | 1753 | -- default user groups |
3f69fee7 AE |
1754 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone |
1755 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests | |
1756 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users | |
1757 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators | |
1758 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators | |
47459aed | 1759 | |
158bd3ca | 1760 | -- default user group options |
ae6b590f MS |
1761 | INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1, 1); |
1762 | INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (2, 'admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', 1, 1); | |
1763 | INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (3, 'admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', 1, 1); | |
158bd3ca TD |
1764 | |
1765 | -- default user group option values | |
1766 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone | |
1767 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone | |
1768 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone | |
1769 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators | |
1770 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators | |
1771 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators | |
47459aed | 1772 | |
158bd3ca | 1773 | -- default update servers |
37089cb5 AE |
1774 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', ''); |
1775 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', ''); | |
37111120 AE |
1776 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/typhoon/', 'online', 0, NULL, 0, '', ''); |
1777 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/typhoon/', 'online', 0, NULL, 0, '', ''); | |
4d9f6058 AE |
1778 | |
1779 | -- style default values | |
baa4743d AE |
1780 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)'); |
1781 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)'); | |
1782 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)'); | |
1783 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)'); | |
1784 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)'); | |
1785 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)'); | |
1786 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)'); | |
1787 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)'); | |
372c77c4 | 1788 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0px'); |
baa4743d AE |
1789 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)'); |
1790 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)'); | |
1791 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)'); | |
1792 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)'); | |
1793 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)'); | |
1794 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)'); | |
1795 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)'); | |
1796 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)'); | |
09f7100b | 1797 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderRadius', '3px'); |
8ce85e3a | 1798 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallButtonBorderRadius', '3px'); |
baa4743d | 1799 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)'); |
90a67f4f MW |
1800 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)'); |
1801 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)'); | |
baa4743d | 1802 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)'); |
90a67f4f MW |
1803 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)'); |
1804 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)'); | |
1805 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor'); | |
91143353 MW |
1806 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)'); |
1807 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)'); | |
cdb161b9 | 1808 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)'); |
baa4743d AE |
1809 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)'); |
1810 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)'); | |
1811 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)'); | |
f9788d30 K |
1812 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)'); |
1813 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)'); | |
8ce85e3a | 1814 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderRadius', '0'); |
4d9f6058 AE |
1815 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px'); |
1816 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif'); | |
a78137a1 | 1817 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '980px'); |
f9fa1d11 | 1818 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '90%'); |
4d9f6058 | 1819 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px'); |
baa4743d AE |
1820 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)'); |
1821 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)'); | |
1822 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)'); | |
1823 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)'); | |
cdb161b9 | 1824 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor'); |
90a67f4f | 1825 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)'); |
46944117 | 1826 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfExtraDimmedColor', 'lighten(@wcfDimmedColor, 20%)'); |
cdb161b9 MW |
1827 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor'); |
1828 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor'); | |
baa4743d | 1829 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif'); |
cdb161b9 MW |
1830 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor'); |
1831 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor'); | |
1832 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor'); | |
1833 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor'); | |
9b363755 | 1834 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.28'); |
28283ef7 MW |
1835 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '1.7rem'); |
1836 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '1.4rem'); | |
1837 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '1.2rem'); | |
1838 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '.85rem'); | |
90a67f4f MW |
1839 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)'); |
1840 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)'); | |
1841 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)'); | |
1842 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)'); | |
1843 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)'); | |
1844 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)'); | |
1845 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)'); | |
1846 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)'); | |
1847 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)'); | |
1848 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)'); | |
1849 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)'); | |
1850 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)'); | |
4d9f6058 | 1851 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)'); |
baa4743d | 1852 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)'); |
79e7fbed | 1853 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHighlightBackgroundColor', 'rgba(255, 255, 102, 1)'); |
4d9f6058 AE |
1854 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px'); |
1855 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px'); | |
1856 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px'); | |
1857 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px'); | |
cdb161b9 MW |
1858 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor'); |
1859 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor'); | |
1860 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor'); | |
cdb161b9 MW |
1861 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor'); |
1862 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor'); | |
baa4743d | 1863 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)'); |
3a16de9d MW |
1864 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedBackgroundColor', 'rgba(255, 255, 200, 1)'); |
1865 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSelectedColor', '@wcfColor'); | |
1866 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedBackgroundColor', 'rgba(255, 238, 238, 1)'); | |
1867 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDeletedColor', 'rgba(204, 0, 0, 1)'); | |
1868 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledBackgroundColor', 'rgba(238, 255, 238, 1)'); | |
1869 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDisabledColor', 'rgba(0, 153, 0, 1)'); | |
a78137a1 MW |
1870 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLightColor', 'transparent'); |
1871 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDarkColor', 'transparent'); | |
ee013cde | 1872 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1'); |
160bfe44 AE |
1873 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', ''); |
1874 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', ''); | |
1875 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', ''); | |
1e18b5ed | 1876 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left'); |
dcc2332d MW |
1877 | |
1878 | -- media providers | |
1879 | -- Videos | |
1880 | -- Youtube | |
c38e96cf | 1881 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('YouTube', 'https?://(?:.+?\\.)?youtu(?:\\.be/|be\\.com/(?:#/)?watch\\?(?:.*?&)?v=)(?P<ID>[a-zA-Z0-9_-]+)(?P<start>(?:#a?t=(?:\\d+|(?:\\d+h(?:\\d+m)?(?:\\d+s)?)|(?:\\d+m(?:\\d+s)?)|(?:\\d+s))$)?)', '<iframe style="max-width:100%;" width="560" height="315" src="https://www.youtube.com/embed/{$ID}?wmode=transparent{$start}" allowfullscreen></iframe>'); |
dcc2332d | 1882 | -- Vimeo |
d90e8793 | 1883 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Vimeo', 'https?://vimeo\\.com/(?P<ID>\\d+)', '<iframe src="https://player.vimeo.com/video/{$ID}" width="400" height="225" webkitAllowFullScreen mozallowfullscreen allowFullScreen></iframe>'); |
dcc2332d | 1884 | -- MyVideo |
fc9a1748 | 1885 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('MyVideo', 'http://(?:www\\.)?myvideo\\.de/watch/(?P<ID>\\d+)', '<object width="611" height="383" type="application/x-shockwave-flash" data="http://www.myvideo.de/movie/{$ID}"><param name="movie" value="http://www.myvideo.de/movie/{$ID}" /><param name="AllowFullscreen" value="true" /><param name="AllowScriptAccess" value="always" /><param name="wmode" value="transparent" /></object>'); |
dcc2332d | 1886 | -- Clipfish |
eab82f4c | 1887 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Clipfish', 'http://(?:www\\.)?clipfish\\.de/(?:.*?/)?video/(?P<ID>\\d+)/', '<div style="width:464px; height:404px;"><div style="width:464px; height:384px;"><iframe src="http://www.clipfish.de/embed_video/?vid={$ID}&as=0&col=990000" name="Clipfish Embedded Video" width="464" height="384" align="left" marginheight="0" marginwidth="0" scrolling="no"></iframe></div></div>'); |
dcc2332d | 1888 | -- Veoh |
fc9a1748 | 1889 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Veoh', 'http://(?:www\\.)?veoh\\.com/watch/v(?P<ID>\\d+[a-zA-Z0-9]+)', '<object width="410" height="341" id="veohFlashPlayer" name="veohFlashPlayer" type="application/x-shockwave-flash" data="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&permalinkId=v{$ID}&player=videodetailsembedded&videoAutoPlay=0&id=anonymous"><param name="movie" value="http://www.veoh.com/swf/webplayer/WebPlayer.swf?version=AFrontend.5.7.0.1308&permalinkId=v{$ID}&player=videodetailsembedded&videoAutoPlay=0&id=anonymous" /><param name="allowFullScreen" value="true" /><param name="allowscriptaccess" value="always" /><param name="wmode" value="transparent" /></object>'); |
dcc2332d | 1890 | -- DailyMotion |
eab82f4c | 1891 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('DailyMotion', 'https?://(?:www\\.)?dailymotion\\.com/video/(?P<ID>[a-zA-Z0-9]+)', '<iframe width="480" height="208" src="http://www.dailymotion.com/embed/video/{$ID}"></iframe>'); |
dcc2332d MW |
1892 | -- Misc |
1893 | -- github gist | |
eab82f4c | 1894 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('github gist', 'https://gist.github.com/(?P<ID>[^/]+/[0-9a-zA-Z]+)', '<script src="https://gist.github.com/{$ID}.js"> </script>'); |
dcc2332d | 1895 | -- soundcloud |
c0587328 MW |
1896 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud', 'https?://soundcloud.com/(?P<artist>[a-zA-Z0-9_-]+)/(?!sets/)(?P<song>[a-zA-Z0-9_-]+)', '<iframe width="100%" height="166" scrolling="no" src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fsoundcloud.com%2F{$artist}%2F{$song}"></iframe>'); |
1897 | -- soundcloud set | |
1898 | INSERT INTO wcf1_bbcode_media_provider (title, regex, html) VALUES ('Soundcloud set', 'https?://soundcloud.com/(?P<artist>[a-zA-Z0-9_-]+)/sets/(?P<name>[a-zA-Z0-9_-]+)', '<iframe width="100%" height="450" scrolling="no" src="https://w.soundcloud.com/player/?url=http%3A%2F%2Fsoundcloud.com%2F{$artist}%2Fsets%2F{$name}"></iframe>'); | |
1899 | ||
320f4a6d MW |
1900 | -- default priorities |
1901 | UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3; | |
1902 | UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4; | |
c3ab3fe0 | 1903 | UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 5; |
320f4a6d MW |
1904 | |
1905 | -- default 'showOnTeamPage' setting | |
c3ab3fe0 | 1906 | UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5); |
320f4a6d MW |
1907 | |
1908 | -- default ranks | |
1909 | INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES | |
1910 | (4, 0, 'wcf.user.rank.administrator', 'blue'), | |
1911 | (5, 0, 'wcf.user.rank.moderator', 'blue'), | |
320f4a6d MW |
1912 | (3, 0, 'wcf.user.rank.user0', ''), |
1913 | (3, 300, 'wcf.user.rank.user1', ''), | |
1914 | (3, 900, 'wcf.user.rank.user2', ''), | |
1915 | (3, 3000, 'wcf.user.rank.user3', ''), | |
1916 | (3, 9000, 'wcf.user.rank.user4', ''), | |
861451f4 | 1917 | (3, 15000, 'wcf.user.rank.user5', ''); |