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, | |
7638be52 | 50 | icon VARCHAR(255) NOT NULL DEFAULT '', |
158bd3ca TD |
51 | UNIQUE KEY menuItem (menuItem, packageID) |
52 | ); | |
53 | ||
e9311b98 AE |
54 | DROP TABLE IF EXISTS wcf1_acp_search_provider; |
55 | CREATE TABLE wcf1_acp_search_provider ( | |
56 | providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
57 | packageID INT(10) NOT NULL, | |
58 | providerName VARCHAR(255) NOT NULL DEFAULT '', | |
59 | className VARCHAR(255) NOT NULL DEFAULT '', | |
60 | showOrder INT(10) NOT NULL DEFAULT 0, | |
61 | UNIQUE KEY providerName (providerName, packageID) | |
62 | ); | |
63 | ||
158bd3ca TD |
64 | DROP TABLE IF EXISTS wcf1_acp_session; |
65 | CREATE TABLE wcf1_acp_session ( | |
66 | sessionID CHAR(40) NOT NULL PRIMARY KEY, | |
158bd3ca TD |
67 | userID INT(10), |
68 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
69 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
70 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
71 | requestURI VARCHAR(255) NOT NULL DEFAULT '', | |
98f447b0 | 72 | requestMethod VARCHAR(7) NOT NULL DEFAULT '', |
7aa1a486 | 73 | controller VARCHAR(255) NOT NULL DEFAULT '', |
596e20e2 MW |
74 | parentObjectType VARCHAR(255) NOT NULL DEFAULT '', |
75 | parentObjectID INT(10) NOT NULL DEFAULT 0, | |
76 | objectType VARCHAR(255) NOT NULL DEFAULT '', | |
34c95e16 | 77 | objectID INT(10) NOT NULL DEFAULT 0 |
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 | ||
e1622bfa TD |
105 | DROP TABLE IF EXISTS wcf1_acp_session_virtual; |
106 | CREATE TABLE wcf1_acp_session_virtual ( | |
107 | virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
108 | sessionID CHAR(40) NOT NULL, | |
109 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
110 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
111 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
34c95e16 | 112 | sessionVariables MEDIUMTEXT, |
e1622bfa TD |
113 | UNIQUE KEY (sessionID, ipAddress, userAgent) |
114 | ); | |
115 | ||
158bd3ca TD |
116 | DROP TABLE IF EXISTS wcf1_acp_template; |
117 | CREATE TABLE wcf1_acp_template ( | |
118 | templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
119 | packageID INT(10), | |
04727c8b | 120 | templateName VARCHAR(255) NOT NULL, |
567fa8b8 | 121 | application VARCHAR(20) NOT NULL, |
04727c8b | 122 | UNIQUE KEY applicationTemplate (application, templateName) |
158bd3ca TD |
123 | ); |
124 | ||
e866b80e MS |
125 | DROP TABLE IF EXISTS wcf1_ad; |
126 | CREATE TABLE wcf1_ad ( | |
127 | adID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
128 | objectTypeID INT(10) NOT NULL, | |
129 | adName VARCHAR(255) NOT NULL, | |
130 | ad MEDIUMTEXT, | |
131 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
132 | showOrder INT(10) NOT NULL DEFAULT 0 | |
133 | ); | |
134 | ||
158bd3ca TD |
135 | DROP TABLE IF EXISTS wcf1_application; |
136 | CREATE TABLE wcf1_application ( | |
137 | packageID INT(10) NOT NULL PRIMARY KEY, | |
138 | domainName VARCHAR(255) NOT NULL, | |
139 | domainPath VARCHAR(255) NOT NULL DEFAULT '/', | |
668cf125 | 140 | cookieDomain VARCHAR(255) NOT NULL, |
a80873d5 | 141 | cookiePath VARCHAR(255) NOT NULL DEFAULT '/' |
158bd3ca TD |
142 | ); |
143 | ||
f0bc263f MW |
144 | DROP TABLE IF EXISTS wcf1_attachment; |
145 | CREATE TABLE wcf1_attachment ( | |
146 | attachmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
147 | objectTypeID INT(10) NOT NULL, | |
148 | objectID INT(10), | |
149 | userID INT(10), | |
150 | tmpHash VARCHAR(40) NOT NULL DEFAULT '', | |
151 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
152 | filesize INT(10) NOT NULL DEFAULT 0, | |
153 | fileType VARCHAR(255) NOT NULL DEFAULT '', | |
154 | fileHash VARCHAR(40) NOT NULL DEFAULT '', | |
155 | ||
156 | isImage TINYINT(1) NOT NULL DEFAULT 0, | |
157 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
59ab4d0f | 158 | height SMALLINT(5) NOT NULL DEFAULT 0, |
f0bc263f MW |
159 | |
160 | tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
161 | tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
162 | tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
163 | tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
164 | ||
165 | thumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
166 | thumbnailSize INT(10) NOT NULL DEFAULT 0, | |
167 | thumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
168 | thumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
169 | ||
170 | downloads INT(10) NOT NULL DEFAULT 0, | |
171 | lastDownloadTime INT(10) NOT NULL DEFAULT 0, | |
172 | uploadTime INT(10) NOT NULL DEFAULT 0, | |
173 | showOrder SMALLINT(5) NOT NULL DEFAULT 0, | |
174 | KEY (objectTypeID, objectID), | |
175 | KEY (objectTypeID, tmpHash), | |
176 | KEY (objectID, uploadTime) | |
177 | ); | |
178 | ||
db6698ad TD |
179 | DROP TABLE IF EXISTS wcf1_background_job; |
180 | CREATE TABLE wcf1_background_job ( | |
181 | jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
182 | job MEDIUMTEXT NOT NULL, | |
183 | status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready', | |
184 | time INT(10) NOT NULL, | |
185 | KEY (status, time) | |
186 | ); | |
187 | ||
dcc2332d MW |
188 | DROP TABLE IF EXISTS wcf1_bbcode; |
189 | CREATE TABLE wcf1_bbcode ( | |
190 | bbcodeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
191 | bbcodeTag VARCHAR(255) NOT NULL, | |
192 | packageID INT(10) NOT NULL, | |
193 | htmlOpen VARCHAR(255) NOT NULL DEFAULT '', | |
194 | htmlClose VARCHAR(255) NOT NULL DEFAULT '', | |
dcc2332d MW |
195 | className VARCHAR(255) NOT NULL DEFAULT '', |
196 | wysiwygIcon varchar(255) NOT NULL DEFAULT '', | |
197 | buttonLabel VARCHAR(255) NOT NULL DEFAULT '', | |
ece28c21 | 198 | isBlockElement TINYINT(1) NOT NULL DEFAULT 0, |
dcc2332d MW |
199 | isSourceCode TINYINT(1) NOT NULL DEFAULT 0, |
200 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
201 | showButton TINYINT(1) NOT NULL DEFAULT 0, | |
31378fd1 | 202 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
dcc2332d MW |
203 | UNIQUE KEY bbcodeTag (bbcodeTag) |
204 | ); | |
205 | ||
206 | DROP TABLE IF EXISTS wcf1_bbcode_attribute; | |
207 | CREATE TABLE wcf1_bbcode_attribute ( | |
208 | attributeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
209 | bbcodeID INT(10) NOT NULL, | |
210 | attributeNo TINYINT(3) NOT NULL DEFAULT 0, | |
211 | attributeHtml VARCHAR(255) NOT NULL DEFAULT '', | |
212 | validationPattern VARCHAR(255) NOT NULL DEFAULT '', | |
213 | required TINYINT(1) NOT NULL DEFAULT 0, | |
214 | useText TINYINT(1) NOT NULL DEFAULT 0, | |
215 | UNIQUE KEY attributeNo (bbcodeID, attributeNo) | |
216 | ); | |
217 | ||
218 | DROP TABLE IF EXISTS wcf1_bbcode_media_provider; | |
219 | CREATE TABLE wcf1_bbcode_media_provider ( | |
220 | providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
221 | title VARCHAR(255) NOT NULL, | |
222 | regex TEXT NOT NULL, | |
223 | html TEXT NOT NULL | |
224 | ); | |
225 | ||
11fd4618 MW |
226 | DROP TABLE IF EXISTS wcf1_box; |
227 | CREATE TABLE wcf1_box ( | |
228 | boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
91317611 | 229 | objectTypeID INT(10), |
11fd4618 MW |
230 | identifier VARCHAR(255) NOT NULL, |
231 | name VARCHAR(255) NOT NULL, | |
232 | boxType VARCHAR(255) NOT NULL, | |
233 | position VARCHAR(255) NOT NULL, | |
234 | showOrder INT(10) NOT NULL DEFAULT 0, | |
235 | visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1, | |
236 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
237 | cssClassName VARCHAR(255) NOT NULL DEFAULT '', | |
238 | showHeader TINYINT(1) NOT NULL DEFAULT 1, | |
239 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
240 | packageID INT(10) NOT NULL, | |
91317611 | 241 | menuID INT(10) NULL, |
5636588a MW |
242 | linkPageID INT(10), |
243 | linkPageObjectID INT(10) NOT NULL DEFAULT 0, | |
91317611 MS |
244 | externalURL VARCHAR(255) NOT NULL DEFAULT '', |
245 | additionalData TEXT | |
11fd4618 MW |
246 | ); |
247 | ||
248 | DROP TABLE IF EXISTS wcf1_box_content; | |
249 | CREATE TABLE wcf1_box_content ( | |
250 | boxID INT(10) NOT NULL, | |
251 | languageID INT(10), | |
252 | title VARCHAR(255) NOT NULL, | |
253 | content MEDIUMTEXT, | |
56eb7314 | 254 | imageID INT(10), |
11fd4618 MW |
255 | |
256 | KEY (boxID, languageID) | |
257 | ); | |
258 | ||
53cf1c00 MW |
259 | DROP TABLE IF EXISTS wcf1_box_to_page; |
260 | CREATE TABLE wcf1_box_to_page ( | |
261 | boxID INT(10) NOT NULL, | |
262 | pageID INT(10) NOT NULL, | |
263 | visible TINYINT(1) NOT NULL DEFAULT 1, | |
264 | ||
265 | UNIQUE KEY (pageID, boxID), | |
266 | KEY (pageID, visible) | |
267 | ); | |
268 | ||
96714cab MS |
269 | DROP TABLE IF EXISTS wcf1_captcha_question; |
270 | CREATE TABLE wcf1_captcha_question ( | |
271 | questionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
272 | question VARCHAR(255) NOT NULL, | |
273 | answers MEDIUMTEXT, | |
274 | isDisabled TINYINT(1) NOT NULL DEFAULT 0 | |
275 | ); | |
276 | ||
13d8b49b MS |
277 | DROP TABLE IF EXISTS wcf1_category; |
278 | CREATE TABLE wcf1_category ( | |
279 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
280 | objectTypeID INT(10) NOT NULL, | |
da06d70c | 281 | parentCategoryID INT(10) NOT NULL DEFAULT 0, |
13d8b49b MS |
282 | title VARCHAR(255) NOT NULL, |
283 | description TEXT, | |
da06d70c MW |
284 | showOrder INT(10) NOT NULL DEFAULT 0, |
285 | time INT(10) NOT NULL DEFAULT 0, | |
13d8b49b | 286 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
045f075b | 287 | additionalData TEXT |
13d8b49b MS |
288 | ); |
289 | ||
054db725 TD |
290 | DROP TABLE IF EXISTS wcf1_cli_history; |
291 | CREATE TABLE wcf1_cli_history ( | |
292 | historyItem INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
293 | userID INT(10) NOT NULL, | |
294 | command VARCHAR(255) NOT NULL, | |
295 | KEY (userID) | |
296 | ); | |
297 | ||
0d6ea23f AE |
298 | DROP TABLE IF EXISTS wcf1_clipboard_action; |
299 | CREATE TABLE wcf1_clipboard_action ( | |
300 | actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
301 | packageID INT(10) NOT NULL DEFAULT 0, | |
302 | actionName VARCHAR(50) NOT NULL DEFAULT '', | |
303 | actionClassName VARCHAR(200) NOT NULL DEFAULT '', | |
d6bfc90e | 304 | showOrder INT(10) NOT NULL DEFAULT 0, |
656718fc | 305 | UNIQUE KEY actionName (packageID, actionName, actionClassName) |
0d6ea23f AE |
306 | ); |
307 | ||
308 | DROP TABLE IF EXISTS wcf1_clipboard_item; | |
309 | CREATE TABLE wcf1_clipboard_item ( | |
25cf4d11 | 310 | objectTypeID INT(10) NOT NULL DEFAULT 0, |
0d6ea23f | 311 | userID INT(10) NOT NULL DEFAULT 0, |
25cf4d11 AE |
312 | objectID INT(10) NOT NULL DEFAULT 0, |
313 | UNIQUE KEY (objectTypeID, userID, objectID) | |
0d6ea23f AE |
314 | ); |
315 | ||
316 | DROP TABLE IF EXISTS wcf1_clipboard_page; | |
317 | CREATE TABLE wcf1_clipboard_page ( | |
318 | pageClassName VARCHAR(80) NOT NULL DEFAULT '', | |
319 | packageID INT(10) NOT NULL DEFAULT 0, | |
320 | actionID INT(10) NOT NULL DEFAULT 0 | |
321 | ); | |
322 | ||
285b1d92 MW |
323 | DROP TABLE IF EXISTS wcf1_comment; |
324 | CREATE TABLE wcf1_comment ( | |
325 | commentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
326 | objectTypeID INT(10) NOT NULL, | |
327 | objectID INT(10) NOT NULL, | |
328 | time INT(10) NOT NULL DEFAULT '0', | |
329 | userID INT(10), | |
330 | username VARCHAR(255) NOT NULL, | |
331 | message TEXT NOT NULL, | |
332 | responses MEDIUMINT(7) NOT NULL DEFAULT '0', | |
6f874ba8 | 333 | responseIDs VARCHAR(255) NOT NULL DEFAULT '', |
285b1d92 | 334 | |
e36dbd69 AE |
335 | KEY (objectTypeID, objectID, time), |
336 | KEY lastCommentTime (userID, time) | |
285b1d92 MW |
337 | ); |
338 | ||
339 | DROP TABLE IF EXISTS wcf1_comment_response; | |
340 | CREATE TABLE wcf1_comment_response ( | |
341 | responseID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
342 | commentID INT(10) NOT NULL, | |
343 | time INT(10) NOT NULL DEFAULT '0', | |
344 | userID INT(10), | |
345 | username VARCHAR(255) NOT NULL, | |
346 | message TEXT NOT NULL, | |
347 | ||
e36dbd69 AE |
348 | KEY (commentID, time), |
349 | KEY lastResponseTime (userID, time) | |
285b1d92 MW |
350 | ); |
351 | ||
87d3a054 MS |
352 | DROP TABLE IF EXISTS wcf1_condition; |
353 | CREATE TABLE wcf1_condition ( | |
354 | conditionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
355 | objectTypeID INT(10) NOT NULL, | |
356 | objectID INT(10) NOT NULL, | |
357 | conditionData MEDIUMTEXT | |
358 | ); | |
359 | ||
158bd3ca TD |
360 | DROP TABLE IF EXISTS wcf1_core_object; |
361 | CREATE TABLE wcf1_core_object ( | |
362 | objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
363 | packageID INT(10) NOT NULL, | |
364 | objectName VARCHAR(255) NOT NULL DEFAULT '', | |
365 | UNIQUE KEY object (packageID, objectName) | |
366 | ); | |
367 | ||
368 | DROP TABLE IF EXISTS wcf1_cronjob; | |
369 | CREATE TABLE wcf1_cronjob ( | |
370 | cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
371 | className varchar(255) NOT NULL DEFAULT '', | |
372 | packageID INT(10) NOT NULL, | |
22c4b081 | 373 | cronjobName VARCHAR(255) NOT NULL, |
158bd3ca TD |
374 | description varchar(255) NOT NULL DEFAULT '', |
375 | startMinute varchar(255) NOT NULL DEFAULT '*', | |
376 | startHour varchar(255) NOT NULL DEFAULT '*', | |
377 | startDom varchar(255) NOT NULL DEFAULT '*', | |
378 | startMonth varchar(255) NOT NULL DEFAULT '*', | |
379 | startDow varchar(255) NOT NULL DEFAULT '*', | |
380 | lastExec INT(10) NOT NULL DEFAULT 0, | |
381 | nextExec INT(10) NOT NULL DEFAULT 0, | |
382 | afterNextExec INT(10) NOT NULL DEFAULT 0, | |
8f08c7d0 | 383 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
c9117aad MS |
384 | canBeEdited TINYINT(1) NOT NULL DEFAULT 1, |
385 | canBeDisabled TINYINT(1) NOT NULL DEFAULT 1, | |
386 | state TINYINT(1) NOT NULL DEFAULT 0, | |
0fb52d6b | 387 | failCount TINYINT(1) NOT NULL DEFAULT 0, |
22c4b081 MS |
388 | options TEXT, |
389 | ||
390 | UNIQUE KEY cronjobName (cronjobName, packageID) | |
158bd3ca TD |
391 | ); |
392 | ||
393 | DROP TABLE IF EXISTS wcf1_cronjob_log; | |
394 | CREATE TABLE wcf1_cronjob_log ( | |
395 | cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
396 | cronjobID INT(10) NOT NULL, | |
397 | execTime INT(10) NOT NULL DEFAULT 0, | |
c9117aad | 398 | success TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
399 | error TEXT |
400 | ); | |
401 | ||
81aa6374 TD |
402 | DROP TABLE IF EXISTS wcf1_edit_history_entry; |
403 | CREATE TABLE wcf1_edit_history_entry ( | |
404 | entryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
405 | objectTypeID INT(10) NOT NULL, | |
406 | objectID INT(10) NOT NULL, | |
407 | userID INT(10), | |
408 | username VARCHAR(255) NOT NULL DEFAULT '', | |
988618d9 | 409 | time INT(10) NOT NULL DEFAULT 0, -- time the version was created, displayed to the user |
f86d7ff7 TD |
410 | obsoletedAt INT(10) NOT NULL DEFAULT 0, -- time the version was inserted into the edit history, used for clean up |
411 | obsoletedByUserID INT(10), | |
81aa6374 TD |
412 | message MEDIUMTEXT, |
413 | editReason TEXT, | |
414 | ||
f86d7ff7 TD |
415 | KEY (objectTypeID, objectID), |
416 | KEY (obsoletedAt, obsoletedByUserID) | |
81aa6374 TD |
417 | ); |
418 | ||
158bd3ca TD |
419 | DROP TABLE IF EXISTS wcf1_event_listener; |
420 | CREATE TABLE wcf1_event_listener ( | |
421 | listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
422 | packageID INT(10) NOT NULL, | |
7e6405f8 | 423 | environment ENUM('user', 'admin') NOT NULL DEFAULT 'user', |
e0497659 | 424 | listenerName VARCHAR(255) NOT NULL, |
158bd3ca | 425 | eventClassName VARCHAR(80) NOT NULL DEFAULT '', |
c9ebc679 | 426 | eventName TEXT, |
158bd3ca TD |
427 | listenerClassName VARCHAR(200) NOT NULL DEFAULT '', |
428 | inherit TINYINT(1) NOT NULL DEFAULT 0, | |
429 | niceValue TINYINT(3) NOT NULL DEFAULT 0, | |
ffdebe9c MS |
430 | permissions TEXT, |
431 | options TEXT, | |
432 | ||
c9ebc679 | 433 | UNIQUE KEY listenerName (listenerName, packageID) |
158bd3ca TD |
434 | ); |
435 | ||
78db8ddf MW |
436 | DROP TABLE IF EXISTS wcf1_import_mapping; |
437 | CREATE TABLE wcf1_import_mapping ( | |
8d8368ee | 438 | importHash CHAR(8) NOT NULL, |
78db8ddf MW |
439 | objectTypeID INT(10) NOT NULL, |
440 | oldID VARCHAR(255) NOT NULL, | |
441 | newID INT(10) NOT NULL, | |
8d8368ee | 442 | UNIQUE KEY (importHash, objectTypeID, oldID) |
78db8ddf MW |
443 | ); |
444 | ||
3b75466f MW |
445 | DROP TABLE IF EXISTS wcf1_label; |
446 | CREATE TABLE wcf1_label ( | |
447 | labelID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
448 | groupID INT(10) NOT NULL, | |
449 | label VARCHAR(80) NOT NULL, | |
d8475f48 MS |
450 | cssClassName VARCHAR(255) NOT NULL DEFAULT '', |
451 | showOrder INT(10) NOT NULL DEFAULT 0 | |
3b75466f MW |
452 | ); |
453 | ||
454 | DROP TABLE IF EXISTS wcf1_label_group; | |
455 | CREATE TABLE wcf1_label_group ( | |
456 | groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
457 | groupName VARCHAR(80) NOT NULL, | |
f3db386c | 458 | groupDescription VARCHAR(255) NOT NULL DEFAULT '', |
e76c454b AE |
459 | forceSelection TINYINT(1) NOT NULL DEFAULT 0, |
460 | showOrder INT(10) NOT NULL DEFAULT 0 | |
3b75466f MW |
461 | ); |
462 | ||
463 | DROP TABLE IF EXISTS wcf1_label_group_to_object; | |
464 | CREATE TABLE wcf1_label_group_to_object ( | |
465 | groupID INT(10) NOT NULL, | |
466 | objectTypeID INT(10) NOT NULL, | |
467 | objectID INT(10) NULL | |
468 | ); | |
469 | ||
470 | DROP TABLE IF EXISTS wcf1_label_object; | |
471 | CREATE TABLE wcf1_label_object ( | |
472 | labelID INT(10) NOT NULL, | |
473 | objectTypeID INT(10) NOT NULL, | |
474 | objectID INT(10) NOT NULL, | |
475 | ||
476 | KEY (objectTypeID, labelID), | |
477 | KEY (objectTypeID, objectID) | |
478 | ); | |
479 | ||
158bd3ca TD |
480 | DROP TABLE IF EXISTS wcf1_language; |
481 | CREATE TABLE wcf1_language ( | |
482 | languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
483 | languageCode VARCHAR(20) NOT NULL DEFAULT '', | |
a74df36b | 484 | languageName VARCHAR(255) NOT NULL DEFAULT '', |
6675b340 | 485 | countryCode VARCHAR(10) NOT NULL DEFAULT '', |
158bd3ca TD |
486 | isDefault TINYINT(1) NOT NULL DEFAULT 0, |
487 | hasContent TINYINT(1) NOT NULL DEFAULT 0, | |
488 | UNIQUE KEY languageCode (languageCode) | |
489 | ); | |
490 | ||
491 | DROP TABLE IF EXISTS wcf1_language_category; | |
492 | CREATE TABLE wcf1_language_category ( | |
493 | languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
494 | languageCategory VARCHAR(255) NOT NULL DEFAULT '', | |
495 | UNIQUE KEY languageCategory (languageCategory) | |
496 | ); | |
497 | ||
498 | DROP TABLE IF EXISTS wcf1_language_item; | |
499 | CREATE TABLE wcf1_language_item ( | |
500 | languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
501 | languageID INT(10) NOT NULL, | |
502 | languageItem VARCHAR(255) NOT NULL DEFAULT '', | |
503 | languageItemValue MEDIUMTEXT NOT NULL, | |
504 | languageCustomItemValue MEDIUMTEXT, | |
505 | languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0, | |
506 | languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1, | |
507 | languageCategoryID INT(10) NOT NULL, | |
508 | packageID INT(10), | |
f1c1fc65 | 509 | UNIQUE KEY languageItem (languageItem, languageID), |
158bd3ca TD |
510 | KEY languageItemOriginIsSystem (languageItemOriginIsSystem) |
511 | ); | |
512 | ||
00b6f956 MW |
513 | DROP TABLE IF EXISTS wcf1_like; |
514 | CREATE TABLE wcf1_like ( | |
515 | likeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
516 | objectID INT(10) NOT NULL DEFAULT 0, | |
517 | objectTypeID INT(10) NOT NULL, | |
518 | objectUserID INT(10), | |
519 | userID INT(10) NOT NULL, | |
1ba3f564 | 520 | time INT(10) NOT NULL DEFAULT 1, |
00b6f956 MW |
521 | likeValue TINYINT(1) NOT NULL DEFAULT 1, |
522 | UNIQUE KEY (objectTypeID, objectID, userID) | |
523 | ); | |
524 | ||
525 | DROP TABLE IF EXISTS wcf1_like_object; | |
526 | CREATE TABLE wcf1_like_object ( | |
527 | likeObjectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
528 | objectTypeID INT(10) NOT NULL, | |
529 | objectID INT(10) NOT NULL DEFAULT 0, | |
530 | objectUserID INT(10), | |
531 | likes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
532 | dislikes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
533 | cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
534 | cachedUsers TEXT, | |
535 | UNIQUE KEY (objectTypeID, objectID) | |
536 | ); | |
537 | ||
59ab4d0f MS |
538 | DROP TABLE IF EXISTS wcf1_media; |
539 | CREATE TABLE wcf1_media ( | |
540 | mediaID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
541 | ||
542 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
543 | filesize INT(10) NOT NULL DEFAULT 0, | |
544 | fileType VARCHAR(255) NOT NULL DEFAULT '', | |
545 | fileHash VARCHAR(255) NOT NULL DEFAULT '', | |
546 | uploadTime INT(10) NOT NULL DEFAULT 0, | |
547 | userID INT(10), | |
548 | username VARCHAR(255) NOT NULL, | |
549 | languageID INT(10), | |
550 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
551 | ||
552 | isImage TINYINT(1) NOT NULL DEFAULT 0, | |
553 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
554 | height SMALLINT(5) NOT NULL DEFAULT 0, | |
555 | ||
556 | tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
557 | tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
558 | tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
559 | tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
560 | ||
561 | smallThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
562 | smallThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
563 | smallThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
564 | smallThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
565 | ||
566 | mediumThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
567 | mediumThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
568 | mediumThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
569 | mediumThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
570 | ||
571 | largeThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
572 | largeThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
573 | largeThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
574 | largeThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0 | |
575 | ); | |
576 | ||
577 | DROP TABLE IF EXISTS wcf1_media_content; | |
578 | CREATE TABLE wcf1_media_content ( | |
579 | mediaID INT(10) NOT NULL, | |
580 | languageID INT(10), | |
581 | title VARCHAR(255) NOT NULL, | |
582 | caption TEXT, | |
583 | altText VARCHAR(255) NOT NULL DEFAULT '', | |
584 | UNIQUE KEY (mediaID, languageID) | |
585 | ); | |
586 | ||
e7fb3339 MW |
587 | DROP TABLE IF EXISTS wcf1_menu; |
588 | CREATE TABLE wcf1_menu ( | |
589 | menuID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
590 | identifier VARCHAR(255) NOT NULL, | |
591 | title VARCHAR(255) NOT NULL, | |
592 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
593 | packageID INT(10) NOT NULL | |
594 | ); | |
595 | ||
596 | DROP TABLE IF EXISTS wcf1_menu_item; | |
597 | CREATE TABLE wcf1_menu_item ( | |
598 | itemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
599 | menuID INT(10) NOT NULL, | |
600 | parentItemID INT(10), | |
601 | identifier VARCHAR(255) NOT NULL, | |
602 | title VARCHAR(255) NOT NULL, | |
603 | pageID INT(10), | |
86dbae33 | 604 | pageObjectID INT(10) NOT NULL DEFAULT 0, |
e7fb3339 MW |
605 | externalURL VARCHAR(255) NOT NULL DEFAULT '', |
606 | showOrder INT(10) NOT NULL DEFAULT 0, | |
607 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
effc9389 AE |
608 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
609 | packageID INT(10) NOT NULL | |
e7fb3339 MW |
610 | ); |
611 | ||
0a2b09a2 MW |
612 | DROP TABLE IF EXISTS wcf1_message_embedded_object; |
613 | CREATE TABLE wcf1_message_embedded_object ( | |
614 | messageObjectTypeID INT(10) NOT NULL, | |
615 | messageID INT(10) NOT NULL, | |
616 | embeddedObjectTypeID INT(10) NOT NULL, | |
617 | embeddedObjectID INT(10) NOT NULL, | |
618 | ||
619 | KEY (messageObjectTypeID, messageID) | |
620 | ); | |
621 | ||
fc69b61d MW |
622 | DROP TABLE IF EXISTS wcf1_moderation_queue; |
623 | CREATE TABLE wcf1_moderation_queue ( | |
624 | queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
625 | objectTypeID INT(10) NOT NULL, | |
626 | objectID INT(10) NOT NULL, | |
627 | containerID INT(10) NOT NULL DEFAULT 0, | |
628 | userID INT(10) NULL, | |
629 | time INT(10) NOT NULL DEFAULT 0, | |
630 | ||
631 | -- internal | |
632 | assignedUserID INT(10) NULL, | |
633 | status TINYINT(1) NOT NULL DEFAULT 0, | |
166d2b91 | 634 | comments SMALLINT(5) NOT NULL DEFAULT 0, |
fc69b61d MW |
635 | lastChangeTime INT(10) NOT NULL DEFAULT 0, |
636 | ||
637 | -- additional data, e.g. message if reporting content | |
71b3faba | 638 | additionalData TEXT |
fc69b61d MW |
639 | ); |
640 | ||
641 | DROP TABLE IF EXISTS wcf1_moderation_queue_to_user; | |
642 | CREATE TABLE wcf1_moderation_queue_to_user ( | |
643 | queueID INT(10) NOT NULL, | |
644 | userID INT(10) NOT NULL, | |
645 | isAffected TINYINT(1) NOT NULL DEFAULT 0, | |
646 | ||
647 | UNIQUE KEY queue (queueID, userID), | |
648 | KEY affected (queueID, userID, isAffected) | |
649 | ); | |
650 | ||
3a2de7fd AE |
651 | DROP TABLE IF EXISTS wcf1_modification_log; |
652 | CREATE TABLE wcf1_modification_log ( | |
653 | logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
654 | objectTypeID INT(10) NOT NULL, | |
655 | objectID INT(10) NOT NULL, | |
34e6993d | 656 | parentObjectID INT(10), |
3a2de7fd AE |
657 | userID INT(10), |
658 | username VARCHAR(255) NOT NULL DEFAULT '', | |
659 | time INT(10) NOT NULL DEFAULT 0, | |
660 | action VARCHAR(80) NOT NULL, | |
661 | additionalData MEDIUMTEXT | |
662 | ); | |
663 | ||
20933e61 MS |
664 | DROP TABLE IF EXISTS wcf1_notice; |
665 | CREATE TABLE wcf1_notice ( | |
666 | noticeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
667 | noticeName VARCHAR(255) NOT NULL, | |
668 | notice MEDIUMTEXT, | |
669 | noticeUseHtml TINYINT(1) NOT NULL DEFAULT 0, | |
e70b5175 | 670 | cssClassName VARCHAR(255) NOT NULL DEFAULT 'info', |
20933e61 MS |
671 | showOrder INT(10) NOT NULL DEFAULT 0, |
672 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
673 | isDismissible TINYINT(1) NOT NULL DEFAULT 0 | |
674 | ); | |
675 | ||
676 | DROP TABLE IF EXISTS wcf1_notice_dismissed; | |
677 | CREATE TABLE wcf1_notice_dismissed ( | |
678 | noticeID INT(10) NOT NULL, | |
679 | userID INT(10) NOT NULL, | |
680 | PRIMARY KEY (noticeID, userID) | |
681 | ); | |
682 | ||
7fcc7676 MW |
683 | DROP TABLE IF EXISTS wcf1_object_type; |
684 | CREATE TABLE wcf1_object_type ( | |
685 | objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
686 | definitionID INT(10) NOT NULL, | |
687 | packageID INT(10) NOT NULL, | |
688 | objectType VARCHAR(255) NOT NULL, | |
689 | className VARCHAR(255) NOT NULL DEFAULT '', | |
690 | additionalData MEDIUMTEXT, | |
691 | UNIQUE KEY objectType (objectType, definitionID, packageID) | |
692 | ); | |
693 | ||
694 | DROP TABLE IF EXISTS wcf1_object_type_definition; | |
695 | CREATE TABLE wcf1_object_type_definition ( | |
696 | definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
697 | definitionName VARCHAR(255) NOT NULL, | |
698 | packageID INT(10) NOT NULL, | |
699 | interfaceName VARCHAR(255) NOT NULL DEFAULT '', | |
16bd0d85 | 700 | categoryName VARCHAR(80) NOT NULL DEFAULT '', |
c404ff5f | 701 | UNIQUE KEY definitionName (definitionName) |
7fcc7676 MW |
702 | ); |
703 | ||
158bd3ca TD |
704 | DROP TABLE IF EXISTS wcf1_option; |
705 | CREATE TABLE wcf1_option ( | |
706 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
707 | packageID INT(10) NOT NULL, | |
708 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
709 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
710 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
711 | optionValue MEDIUMTEXT, | |
712 | validationPattern TEXT, | |
713 | selectOptions MEDIUMTEXT, | |
714 | enableOptions MEDIUMTEXT, | |
715 | showOrder INT(10) NOT NULL DEFAULT 0, | |
716 | hidden TINYINT(1) NOT NULL DEFAULT 0, | |
717 | permissions TEXT, | |
718 | options TEXT, | |
cd6220f2 | 719 | supportI18n TINYINT(1) NOT NULL DEFAULT 0, |
6b45d041 | 720 | requireI18n TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca | 721 | additionalData MEDIUMTEXT, |
0eafcb83 AE |
722 | |
723 | UNIQUE KEY optionName (optionName) | |
158bd3ca TD |
724 | ); |
725 | ||
726 | DROP TABLE IF EXISTS wcf1_option_category; | |
727 | CREATE TABLE wcf1_option_category ( | |
728 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
729 | packageID INT(10) NOT NULL, | |
730 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
731 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', | |
732 | showOrder INT(10) NOT NULL DEFAULT 0, | |
733 | permissions TEXT, | |
734 | options TEXT, | |
0e580f32 | 735 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
736 | ); |
737 | ||
738 | DROP TABLE IF EXISTS wcf1_package; | |
739 | CREATE TABLE wcf1_package ( | |
740 | packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
741 | package VARCHAR(255) NOT NULL DEFAULT '', | |
742 | packageDir VARCHAR(255) NOT NULL DEFAULT '', | |
743 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
158bd3ca TD |
744 | packageDescription VARCHAR(255) NOT NULL DEFAULT '', |
745 | packageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
746 | packageDate INT(10) NOT NULL DEFAULT 0, | |
747 | installDate INT(10) NOT NULL DEFAULT 0, | |
748 | updateDate INT(10) NOT NULL DEFAULT 0, | |
749 | packageURL VARCHAR(255) NOT NULL DEFAULT '', | |
aac1247e | 750 | isApplication TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
751 | author VARCHAR(255) NOT NULL DEFAULT '', |
752 | authorURL VARCHAR(255) NOT NULL DEFAULT '', | |
753 | KEY package (package) | |
754 | ); | |
755 | ||
158bd3ca TD |
756 | DROP TABLE IF EXISTS wcf1_package_exclusion; |
757 | CREATE TABLE wcf1_package_exclusion ( | |
758 | packageID INT(10) NOT NULL, | |
759 | excludedPackage VARCHAR(255) NOT NULL DEFAULT '', | |
760 | excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
761 | UNIQUE KEY packageID (packageID, excludedPackage) | |
762 | ); | |
763 | ||
764 | DROP TABLE IF EXISTS wcf1_package_installation_file_log; | |
765 | CREATE TABLE wcf1_package_installation_file_log ( | |
766 | packageID INT(10), | |
04727c8b | 767 | filename VARCHAR(255) NOT NULL, |
567fa8b8 | 768 | application VARCHAR(20) NOT NULL, |
04727c8b | 769 | UNIQUE KEY applicationFile (application, filename) |
158bd3ca TD |
770 | ); |
771 | ||
772 | DROP TABLE IF EXISTS wcf1_package_installation_form; | |
773 | CREATE TABLE wcf1_package_installation_form ( | |
774 | queueID INT(10) NOT NULL, | |
775 | formName VARCHAR(80) NOT NULL DEFAULT '', | |
776 | document TEXT NOT NULL, | |
777 | UNIQUE KEY formDocument (queueID, formName) | |
778 | ); | |
779 | ||
780 | DROP TABLE IF EXISTS wcf1_package_installation_node; | |
781 | CREATE TABLE wcf1_package_installation_node ( | |
782 | queueID INT(10) NOT NULL, | |
783 | processNo INT(10) NOT NULL DEFAULT 0, | |
784 | sequenceNo SMALLINT(4) NOT NULL DEFAULT 0, | |
785 | node CHAR(8) NOT NULL DEFAULT '', | |
786 | parentNode CHAR(8) NOT NULL DEFAULT '', | |
456008db | 787 | nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package', |
158bd3ca TD |
788 | nodeData TEXT NOT NULL, |
789 | done TINYINT(1) NOT NULL DEFAULT 0 | |
790 | ); | |
791 | ||
792 | DROP TABLE IF EXISTS wcf1_package_installation_plugin; | |
793 | CREATE TABLE wcf1_package_installation_plugin ( | |
794 | pluginName VARCHAR(255) NOT NULL PRIMARY KEY, | |
795 | packageID INT(10), | |
796 | priority TINYINT(1) NOT NULL DEFAULT 0, | |
797 | className VARCHAR(255) NOT NULL | |
798 | ); | |
799 | ||
800 | DROP TABLE IF EXISTS wcf1_package_installation_queue; | |
801 | CREATE TABLE wcf1_package_installation_queue ( | |
802 | queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
803 | parentQueueID INT(10) NOT NULL DEFAULT 0, | |
804 | processNo INT(10) NOT NULL DEFAULT 0, | |
805 | userID INT(10) NOT NULL, | |
806 | package VARCHAR(255) NOT NULL DEFAULT '', | |
807 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
808 | packageID INT(10), | |
809 | archive VARCHAR(255) NOT NULL DEFAULT '', | |
17221357 | 810 | action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install', |
158bd3ca | 811 | done TINYINT(1) NOT NULL DEFAULT 0, |
b33c97d2 | 812 | isApplication TINYINT(1) NOT NULL DEFAULT 0 |
158bd3ca TD |
813 | ); |
814 | ||
815 | DROP TABLE IF EXISTS wcf1_package_installation_sql_log; | |
816 | CREATE TABLE wcf1_package_installation_sql_log ( | |
817 | packageID INT(10), | |
818 | sqlTable VARCHAR(100) NOT NULL DEFAULT '', | |
819 | sqlColumn VARCHAR(100) NOT NULL DEFAULT '', | |
820 | sqlIndex VARCHAR(100) NOT NULL DEFAULT '', | |
821 | UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex) | |
822 | ); | |
823 | ||
1b4f5112 AE |
824 | /* SQL_PARSER_OFFSET */ |
825 | ||
158bd3ca TD |
826 | DROP TABLE IF EXISTS wcf1_package_requirement; |
827 | CREATE TABLE wcf1_package_requirement ( | |
828 | packageID INT(10) NOT NULL, | |
829 | requirement INT(10) NOT NULL, | |
830 | UNIQUE KEY packageID (packageID, requirement) | |
831 | ); | |
832 | ||
158bd3ca TD |
833 | DROP TABLE IF EXISTS wcf1_package_update; |
834 | CREATE TABLE wcf1_package_update ( | |
835 | packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
836 | packageUpdateServerID INT(10) NOT NULL, | |
837 | package VARCHAR(255) NOT NULL DEFAULT '', | |
838 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
839 | packageDescription VARCHAR(255) NOT NULL DEFAULT '', | |
840 | author VARCHAR(255) NOT NULL DEFAULT '', | |
841 | authorURL VARCHAR(255) NOT NULL DEFAULT '', | |
29139546 | 842 | isApplication TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
843 | UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package) |
844 | ); | |
845 | ||
846 | DROP TABLE IF EXISTS wcf1_package_update_exclusion; | |
847 | CREATE TABLE wcf1_package_update_exclusion ( | |
848 | packageUpdateVersionID INT(10) NOT NULL, | |
849 | excludedPackage VARCHAR(255) NOT NULL DEFAULT '', | |
850 | excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '', | |
851 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage) | |
852 | ); | |
853 | ||
854 | DROP TABLE IF EXISTS wcf1_package_update_fromversion; | |
855 | CREATE TABLE wcf1_package_update_fromversion ( | |
856 | packageUpdateVersionID INT(10) NOT NULL DEFAULT 0, | |
857 | fromversion VARCHAR(50) NOT NULL DEFAULT '', | |
858 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion) | |
859 | ); | |
860 | ||
411d6f1a AE |
861 | DROP TABLE IF EXISTS wcf1_package_update_optional; |
862 | CREATE TABLE wcf1_package_update_optional ( | |
863 | packageUpdateVersionID INT(10) NOT NULL DEFAULT 0, | |
864 | package VARCHAR(255) NOT NULL DEFAULT '' | |
865 | ); | |
866 | ||
158bd3ca TD |
867 | DROP TABLE IF EXISTS wcf1_package_update_requirement; |
868 | CREATE TABLE wcf1_package_update_requirement ( | |
869 | packageUpdateVersionID INT(10) NOT NULL, | |
870 | package VARCHAR(255) NOT NULL DEFAULT '', | |
871 | minversion VARCHAR(50) NOT NULL DEFAULT '', | |
872 | UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package) | |
873 | ); | |
874 | ||
875 | DROP TABLE IF EXISTS wcf1_package_update_server; | |
876 | CREATE TABLE wcf1_package_update_server ( | |
877 | packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
878 | serverURL VARCHAR(255) NOT NULL DEFAULT '', | |
879 | loginUsername VARCHAR(255) NOT NULL DEFAULT '', | |
880 | loginPassword VARCHAR(255) NOT NULL DEFAULT '', | |
8f08c7d0 | 881 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
882 | lastUpdateTime INT(10) NOT NULL DEFAULT 0, |
883 | status ENUM('online', 'offline') NOT NULL DEFAULT 'online', | |
2c49099b | 884 | errorMessage TEXT, |
b1701dd0 AE |
885 | apiVersion ENUM('2.0', '2.1') NOT NULL DEFAULT '2.0', |
886 | metaData TEXT | |
158bd3ca TD |
887 | ); |
888 | ||
889 | DROP TABLE IF EXISTS wcf1_package_update_version; | |
890 | CREATE TABLE wcf1_package_update_version ( | |
891 | packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
892 | packageUpdateID INT(10) NOT NULL, | |
893 | packageVersion VARCHAR(50) NOT NULL DEFAULT '', | |
158bd3ca TD |
894 | packageDate INT(10) NOT NULL DEFAULT 0, |
895 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
411d6f1a AE |
896 | license VARCHAR(255) NOT NULL DEFAULT '', |
897 | licenseURL VARCHAR(255) NOT NULL DEFAULT '', | |
b4f1ea02 | 898 | isAccessible TINYINT(1) NOT NULL DEFAULT 1, |
507f6f5b | 899 | isCritical TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
900 | UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion) |
901 | ); | |
902 | ||
0bdb3cdf MW |
903 | DROP TABLE IF EXISTS wcf1_page; |
904 | CREATE TABLE wcf1_page ( | |
905 | pageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
906 | parentPageID INT(10), | |
a0fdb136 | 907 | identifier VARCHAR(255) NOT NULL, |
c8b05efe | 908 | name VARCHAR(255) NOT NULL, |
3fd6b125 | 909 | pageType VARCHAR(255) NOT NULL, |
0bdb3cdf MW |
910 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
911 | isLandingPage TINYINT(1) NOT NULL DEFAULT 0, | |
912 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
913 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
914 | packageID INT(10) NOT NULL, | |
19dadfda | 915 | applicationPackageID INT(10), |
0bdb3cdf | 916 | controller VARCHAR(255) NOT NULL DEFAULT '', |
72604b0d | 917 | handler VARCHAR(255) NOT NULL DEFAULT '', |
0bdb3cdf | 918 | controllerCustomURL VARCHAR(255) NOT NULL DEFAULT '', |
86dbae33 | 919 | requireObjectID TINYINT(1) NOT NULL DEFAULT 0, |
afba9daf MW |
920 | lastUpdateTime INT(10) NOT NULL DEFAULT 0, |
921 | permissions TEXT NULL, | |
922 | options TEXT NULL | |
0bdb3cdf MW |
923 | ); |
924 | ||
925 | DROP TABLE IF EXISTS wcf1_page_content; | |
926 | CREATE TABLE wcf1_page_content ( | |
927 | pageID INT(10) NOT NULL, | |
928 | languageID INT(10), | |
929 | title VARCHAR(255) NOT NULL, | |
930 | content MEDIUMTEXT, | |
931 | metaDescription TEXT, | |
932 | metaKeywords TEXT, | |
933 | customURL VARCHAR(255) NOT NULL, | |
934 | ||
fe851d2a | 935 | UNIQUE KEY (pageID, languageID) |
0bdb3cdf MW |
936 | ); |
937 | ||
4d8036f5 MW |
938 | DROP TABLE IF EXISTS wcf1_paid_subscription; |
939 | CREATE TABLE wcf1_paid_subscription ( | |
940 | subscriptionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
941 | title VARCHAR(255) NOT NULL DEFAULT '', | |
942 | description TEXT, | |
943 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
944 | showOrder INT(10) NOT NULL DEFAULT 0, | |
945 | cost DECIMAL(10,2) NOT NULL DEFAULT 0, | |
946 | currency VARCHAR(3) NOT NULL DEFAULT 'EUR', | |
947 | subscriptionLength SMALLINT(3) NOT NULL DEFAULT 0, | |
948 | subscriptionLengthUnit ENUM('', 'D', 'M', 'Y') NOT NULL DEFAULT '', | |
949 | isRecurring TINYINT(1) NOT NULL DEFAULT 0, | |
950 | groupIDs TEXT, | |
951 | excludedSubscriptionIDs TEXT | |
952 | ); | |
953 | ||
954 | DROP TABLE IF EXISTS wcf1_paid_subscription_user; | |
955 | CREATE TABLE wcf1_paid_subscription_user ( | |
956 | subscriptionUserID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
957 | subscriptionID INT(10) NOT NULL, | |
958 | userID INT(10) NOT NULL, | |
959 | startDate INT(10) NOT NULL DEFAULT 0, | |
960 | endDate INT(10) NOT NULL DEFAULT 0, | |
961 | isActive TINYINT(1) NOT NULL DEFAULT 1, | |
962 | ||
963 | UNIQUE KEY (subscriptionID, userID), | |
964 | KEY (isActive) | |
965 | ); | |
966 | ||
967 | DROP TABLE IF EXISTS wcf1_paid_subscription_transaction_log; | |
968 | CREATE TABLE wcf1_paid_subscription_transaction_log ( | |
969 | logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
970 | subscriptionUserID INT(10), | |
971 | userID INT(10), | |
972 | subscriptionID INT(10), | |
973 | paymentMethodObjectTypeID INT(10) NOT NULL, | |
974 | logTime INT(10) NOT NULL DEFAULT 0, | |
975 | transactionID VARCHAR(255) NOT NULL DEFAULT '', | |
976 | transactionDetails MEDIUMTEXT, | |
977 | logMessage VARCHAR(255) NOT NULL DEFAULT '' | |
978 | ); | |
979 | ||
e25b7b61 MW |
980 | DROP TABLE IF EXISTS wcf1_poll; |
981 | CREATE TABLE wcf1_poll ( | |
982 | pollID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
983 | objectTypeID INT(10) NOT NULL, | |
984 | objectID INT(10) NOT NULL DEFAULT 0, | |
985 | question VARCHAR(255) DEFAULT '', | |
986 | time INT(10) NOT NULL DEFAULT 0, | |
987 | endTime INT(10) NOT NULL DEFAULT 0, | |
988 | isChangeable TINYINT(1) NOT NULL DEFAULT 0, | |
989 | isPublic TINYINT(1) NOT NULL DEFAULT 0, | |
990 | sortByVotes TINYINT(1) NOT NULL DEFAULT 0, | |
991 | resultsRequireVote TINYINT(1) NOT NULL DEFAULT 0, | |
992 | maxVotes INT(10) NOT NULL DEFAULT 1, | |
993 | votes INT(10) NOT NULL DEFAULT 0 | |
994 | ); | |
995 | ||
996 | DROP TABLE IF EXISTS wcf1_poll_option; | |
997 | CREATE TABLE wcf1_poll_option ( | |
998 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
999 | pollID INT(10) NOT NULL, | |
1000 | optionValue VARCHAR(255) NOT NULL DEFAULT '', | |
1001 | votes INT(10) NOT NULL DEFAULT 0, | |
1002 | showOrder INT(10) NOT NULL DEFAULT 0 | |
1003 | ); | |
1004 | ||
1005 | DROP TABLE IF EXISTS wcf1_poll_option_vote; | |
1006 | CREATE TABLE wcf1_poll_option_vote ( | |
1007 | pollID INT(10) NOT NULL, | |
1008 | optionID INT(10) NOT NULL, | |
1009 | userID INT(10) NOT NULL, | |
1010 | ||
1011 | KEY (optionID, userID), | |
1012 | UNIQUE KEY vote (pollID, optionID, userID) | |
1013 | ); | |
1014 | ||
158bd3ca TD |
1015 | DROP TABLE IF EXISTS wcf1_search; |
1016 | CREATE TABLE wcf1_search ( | |
1017 | searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1018 | userID INT(10), | |
1019 | searchData MEDIUMTEXT NOT NULL, | |
1020 | searchTime INT(10) NOT NULL DEFAULT 0, | |
1021 | searchType VARCHAR(255) NOT NULL DEFAULT '', | |
1022 | searchHash CHAR(40) NOT NULL DEFAULT '', | |
1023 | KEY searchHash (searchHash) | |
1024 | ); | |
1025 | ||
749cca08 MW |
1026 | DROP TABLE IF EXISTS wcf1_search_keyword; |
1027 | CREATE TABLE wcf1_search_keyword ( | |
1028 | keywordID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1029 | keyword VARCHAR(255) NOT NULL, | |
1030 | searches INT(10) NOT NULL DEFAULT 0, | |
1031 | lastSearchTime INT(10) NOT NULL DEFAULT 0, | |
1032 | UNIQUE KEY (keyword), | |
1033 | KEY (searches, lastSearchTime) | |
1034 | ); | |
1035 | ||
158bd3ca TD |
1036 | DROP TABLE IF EXISTS wcf1_session; |
1037 | CREATE TABLE wcf1_session ( | |
1038 | sessionID CHAR(40) NOT NULL PRIMARY KEY, | |
158bd3ca TD |
1039 | userID INT(10), |
1040 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1041 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
1042 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
1043 | requestURI VARCHAR(255) NOT NULL DEFAULT '', | |
98f447b0 | 1044 | requestMethod VARCHAR(7) NOT NULL DEFAULT '', |
7aa1a486 | 1045 | controller VARCHAR(255) NOT NULL DEFAULT '', |
596e20e2 MW |
1046 | parentObjectType VARCHAR(255) NOT NULL DEFAULT '', |
1047 | parentObjectID INT(10) NOT NULL DEFAULT 0, | |
1048 | objectType VARCHAR(255) NOT NULL DEFAULT '', | |
1049 | objectID INT(10) NOT NULL DEFAULT 0, | |
e8d26212 | 1050 | spiderID INT(10), |
46dd7463 | 1051 | KEY packageID (lastActivityTime, spiderID), |
6a0a959c | 1052 | UNIQUE KEY uniqueUserID (userID) |
158bd3ca TD |
1053 | ); |
1054 | ||
5a05fde9 AE |
1055 | DROP TABLE IF EXISTS wcf1_session_virtual; |
1056 | CREATE TABLE wcf1_session_virtual ( | |
d905faf6 | 1057 | virtualSessionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
5a05fde9 AE |
1058 | sessionID CHAR(40) NOT NULL, |
1059 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1060 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
1061 | lastActivityTime INT(10) NOT NULL DEFAULT 0, | |
34c95e16 | 1062 | sessionVariables MEDIUMTEXT, |
5a05fde9 AE |
1063 | UNIQUE KEY (sessionID, ipAddress, userAgent) |
1064 | ); | |
1065 | ||
46bd110b AE |
1066 | DROP TABLE IF EXISTS wcf1_sitemap; |
1067 | CREATE TABLE wcf1_sitemap ( | |
1068 | sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1069 | packageID INT(10) NOT NULL, | |
1070 | sitemapName VARCHAR(80) NOT NULL DEFAULT '', | |
1071 | className VARCHAR(255) NOT NULL DEFAULT '', | |
68541bb5 | 1072 | showOrder INT(10) NOT NULL DEFAULT 0, |
a3e0f4f3 MW |
1073 | permissions TEXT NULL, |
1074 | options TEXT NULL, | |
46bd110b AE |
1075 | UNIQUE KEY sitemapName (packageID, sitemapName) |
1076 | ); | |
1077 | ||
dcc2332d MW |
1078 | DROP TABLE IF EXISTS wcf1_smiley; |
1079 | CREATE TABLE wcf1_smiley ( | |
1080 | smileyID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1081 | packageID INT(10) NOT NULL, | |
1082 | categoryID INT(10), | |
1083 | smileyPath VARCHAR(255) NOT NULL DEFAULT '', | |
1084 | smileyTitle VARCHAR(255) NOT NULL DEFAULT '', | |
1085 | smileyCode VARCHAR(255) NOT NULL DEFAULT '', | |
1086 | aliases TEXT NOT NULL, | |
1087 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1088 | UNIQUE KEY smileyCode (smileyCode) | |
1089 | ); | |
1090 | ||
158bd3ca TD |
1091 | DROP TABLE IF EXISTS wcf1_spider; |
1092 | CREATE TABLE wcf1_spider ( | |
1093 | spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1094 | spiderIdentifier VARCHAR(255) DEFAULT '', | |
1095 | spiderName VARCHAR(255) DEFAULT '', | |
1096 | spiderURL VARCHAR(255) DEFAULT '', | |
1097 | UNIQUE KEY spiderIdentifier (spiderIdentifier) | |
1098 | ); | |
1099 | ||
891de7a0 MW |
1100 | DROP TABLE IF EXISTS wcf1_stat_daily; |
1101 | CREATE TABLE wcf1_stat_daily ( | |
e1fe9453 | 1102 | statID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
891de7a0 MW |
1103 | objectTypeID INT(10) NOT NULL, |
1104 | date DATE NOT NULL, | |
1105 | counter INT(10) NOT NULL DEFAULT 0, | |
1106 | total INT(10) NOT NULL DEFAULT 0, | |
1107 | ||
1108 | UNIQUE KEY (objectTypeID, date) | |
1109 | ); | |
1110 | ||
158bd3ca TD |
1111 | DROP TABLE IF EXISTS wcf1_style; |
1112 | CREATE TABLE wcf1_style ( | |
1113 | styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1114 | packageID INT(10) NOT NULL, | |
1115 | styleName VARCHAR(255) NOT NULL DEFAULT '', | |
1116 | templateGroupID INT(10) NOT NULL DEFAULT 0, | |
1117 | isDefault TINYINT(1) NOT NULL DEFAULT 0, | |
8f08c7d0 | 1118 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
d3478df7 | 1119 | styleDescription VARCHAR(30) NOT NULL DEFAULT '', |
158bd3ca TD |
1120 | styleVersion VARCHAR(255) NOT NULL DEFAULT '', |
1121 | styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00', | |
1122 | image VARCHAR(255) NOT NULL DEFAULT '', | |
1123 | copyright VARCHAR(255) NOT NULL DEFAULT '', | |
1124 | license VARCHAR(255) NOT NULL DEFAULT '', | |
1125 | authorName VARCHAR(255) NOT NULL DEFAULT '', | |
fa83e8f7 | 1126 | authorURL VARCHAR(255) NOT NULL DEFAULT '', |
90b4b964 AE |
1127 | imagePath VARCHAR(255) NOT NULL DEFAULT '', |
1128 | packageName VARCHAR(255) NOT NULL DEFAULT '', | |
1129 | isTainted TINYINT(1) NOT NULL DEFAULT 0 | |
158bd3ca TD |
1130 | ); |
1131 | ||
158bd3ca TD |
1132 | DROP TABLE IF EXISTS wcf1_style_variable; |
1133 | CREATE TABLE wcf1_style_variable ( | |
4d9f6058 AE |
1134 | variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
1135 | variableName VARCHAR(50) NOT NULL, | |
1136 | defaultValue MEDIUMTEXT, | |
1137 | UNIQUE KEY variableName (variableName) | |
158bd3ca TD |
1138 | ); |
1139 | ||
4d9f6058 AE |
1140 | DROP TABLE IF EXISTS wcf1_style_variable_value; |
1141 | CREATE TABLE wcf1_style_variable_value ( | |
158bd3ca | 1142 | styleID INT(10) NOT NULL, |
4d9f6058 | 1143 | variableID INT(10) NOT NULL, |
158bd3ca | 1144 | variableValue MEDIUMTEXT, |
4d9f6058 | 1145 | UNIQUE KEY (styleID, variableID) |
158bd3ca TD |
1146 | ); |
1147 | ||
04c06e85 MW |
1148 | DROP TABLE IF EXISTS wcf1_tag; |
1149 | CREATE TABLE wcf1_tag ( | |
1150 | tagID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1151 | languageID INT(10) NOT NULL DEFAULT 0, | |
1152 | name VARCHAR(255) NOT NULL, | |
1153 | synonymFor INT(10), | |
1154 | UNIQUE KEY (languageID, name) | |
1155 | ); | |
1156 | ||
1157 | DROP TABLE IF EXISTS wcf1_tag_to_object; | |
1158 | CREATE TABLE wcf1_tag_to_object ( | |
1159 | objectID INT(10) NOT NULL, | |
1160 | tagID INT(10) NOT NULL, | |
1161 | objectTypeID INT(10) NOT NULL, | |
1162 | languageID INT(10) NOT NULL, | |
1163 | UNIQUE KEY (objectTypeID, languageID, objectID, tagID), | |
1164 | KEY (objectTypeID, languageID, tagID), | |
1165 | KEY (tagID, objectTypeID) | |
1166 | ); | |
1167 | ||
158bd3ca TD |
1168 | DROP TABLE IF EXISTS wcf1_template; |
1169 | CREATE TABLE wcf1_template ( | |
1170 | templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1171 | packageID INT(10) NOT NULL, | |
04727c8b | 1172 | templateName VARCHAR(255) NOT NULL, |
567fa8b8 | 1173 | application VARCHAR(20) NOT NULL, |
158bd3ca | 1174 | templateGroupID INT(10), |
6570e38e | 1175 | lastModificationTime INT(10) NOT NULL DEFAULT 0, |
e568316b | 1176 | UNIQUE KEY applicationTemplate (application, templateGroupID, templateName), |
158bd3ca TD |
1177 | KEY templateGroupID (packageID, templateGroupID, templateName) |
1178 | ); | |
1179 | ||
1180 | DROP TABLE IF EXISTS wcf1_template_group; | |
1181 | CREATE TABLE wcf1_template_group ( | |
1182 | templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
6570e38e | 1183 | parentTemplateGroupID INT(10), |
158bd3ca TD |
1184 | templateGroupName VARCHAR(255) NOT NULL DEFAULT '', |
1185 | templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT '' | |
1186 | ); | |
1187 | ||
0a67f96c MS |
1188 | DROP TABLE IF EXISTS wcf1_template_listener; |
1189 | CREATE TABLE wcf1_template_listener ( | |
1190 | listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1191 | packageID INT(10) NOT NULL, | |
1192 | name VARCHAR(80) NOT NULL DEFAULT '', | |
1193 | environment ENUM('user','admin') NOT NULL DEFAULT 'user', | |
1194 | templateName VARCHAR(80) NOT NULL DEFAULT '', | |
1195 | eventName VARCHAR(50) NOT NULL DEFAULT '', | |
1196 | templateCode TEXT NOT NULL, | |
da84cf75 | 1197 | niceValue TINYINT(3) NOT NULL DEFAULT 0, |
512b7176 MS |
1198 | permissions TEXT, |
1199 | options TEXT, | |
1200 | ||
0a67f96c MS |
1201 | KEY templateName (environment, templateName) |
1202 | ); | |
1203 | ||
320f4a6d MW |
1204 | DROP TABLE IF EXISTS wcf1_tracked_visit; |
1205 | CREATE TABLE wcf1_tracked_visit ( | |
1206 | objectTypeID INT(10) NOT NULL, | |
1207 | objectID INT(10) NOT NULL, | |
1208 | userID INT(10) NOT NULL, | |
1209 | visitTime INT(10) NOT NULL DEFAULT 0, | |
1210 | UNIQUE KEY (objectTypeID, objectID, userID), | |
1211 | KEY (userID, visitTime) | |
1212 | ); | |
1213 | ||
1214 | DROP TABLE IF EXISTS wcf1_tracked_visit_type; | |
1215 | CREATE TABLE wcf1_tracked_visit_type ( | |
1216 | objectTypeID INT(10) NOT NULL, | |
1217 | userID INT(10) NOT NULL, | |
1218 | visitTime INT(10) NOT NULL DEFAULT 0, | |
1219 | UNIQUE KEY (objectTypeID, userID), | |
1220 | KEY (userID, visitTime) | |
1221 | ); | |
1222 | ||
158bd3ca TD |
1223 | DROP TABLE IF EXISTS wcf1_user; |
1224 | CREATE TABLE wcf1_user ( | |
1225 | userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1226 | username VARCHAR(255) NOT NULL DEFAULT '', | |
1227 | email VARCHAR(255) NOT NULL DEFAULT '', | |
4e273b1f | 1228 | password VARCHAR(100) NOT NULL DEFAULT '', |
6a41a21e | 1229 | accessToken CHAR(40) NOT NULL DEFAULT '', |
158bd3ca TD |
1230 | languageID INT(10) NOT NULL DEFAULT 0, |
1231 | registrationDate INT(10) NOT NULL DEFAULT 0, | |
1232 | styleID INT(10) NOT NULL DEFAULT 0, | |
b1356a27 MW |
1233 | banned TINYINT(1) NOT NULL DEFAULT 0, |
1234 | banReason MEDIUMTEXT NULL, | |
f034d0ec | 1235 | banExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1236 | activationCode INT(10) NOT NULL DEFAULT 0, |
1237 | lastLostPasswordRequestTime INT(10) NOT NULL DEFAULT 0, | |
1238 | lostPasswordKey VARCHAR(40) NOT NULL DEFAULT '', | |
1239 | lastUsernameChange INT(10) NOT NULL DEFAULT 0, | |
1240 | newEmail VARCHAR(255) NOT NULL DEFAULT '', | |
1241 | oldUsername VARCHAR(255) NOT NULL DEFAULT '', | |
1242 | quitStarted INT(10) NOT NULL DEFAULT 0, | |
1243 | reactivationCode INT(10) NOT NULL DEFAULT 0, | |
1244 | registrationIpAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1245 | avatarID INT(10), | |
1246 | disableAvatar TINYINT(1) NOT NULL DEFAULT 0, | |
1247 | disableAvatarReason TEXT, | |
f034d0ec | 1248 | disableAvatarExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d | 1249 | enableGravatar TINYINT(1) NOT NULL DEFAULT 0, |
4ae7fdc1 | 1250 | gravatarFileExtension VARCHAR(3) NOT NULL DEFAULT '', |
320f4a6d MW |
1251 | signature TEXT, |
1252 | signatureEnableBBCodes TINYINT(1) NOT NULL DEFAULT 1, | |
1253 | signatureEnableHtml TINYINT(1) NOT NULL DEFAULT 0, | |
1254 | signatureEnableSmilies TINYINT(1) NOT NULL DEFAULT 1, | |
1255 | disableSignature TINYINT(1) NOT NULL DEFAULT 0, | |
1256 | disableSignatureReason TEXT, | |
f034d0ec | 1257 | disableSignatureExpires INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1258 | lastActivityTime INT(10) NOT NULL DEFAULT 0, |
1259 | profileHits INT(10) NOT NULL DEFAULT 0, | |
1260 | rankID INT(10), | |
1261 | userTitle VARCHAR(255) NOT NULL DEFAULT '', | |
1262 | userOnlineGroupID INT(10), | |
1263 | activityPoints INT(10) NOT NULL DEFAULT 0, | |
1264 | notificationMailToken VARCHAR(20) NOT NULL DEFAULT '', | |
1265 | authData VARCHAR(255) NOT NULL DEFAULT '', | |
00b6f956 | 1266 | likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0, |
9ed42d00 | 1267 | socialNetworkPrivacySettings TEXT, |
158bd3ca TD |
1268 | |
1269 | KEY username (username), | |
1270 | KEY registrationDate (registrationDate), | |
320f4a6d MW |
1271 | KEY styleID (styleID), |
1272 | KEY activationCode (activationCode), | |
1273 | KEY registrationData (registrationIpAddress, registrationDate), | |
00b6f956 | 1274 | KEY activityPoints (activityPoints), |
e80b96ef SF |
1275 | KEY likesReceived (likesReceived), |
1276 | KEY authData (authData) | |
320f4a6d MW |
1277 | ); |
1278 | ||
1279 | DROP TABLE IF EXISTS wcf1_user_activity_event; | |
1280 | CREATE TABLE wcf1_user_activity_event ( | |
1281 | eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1282 | objectTypeID INT(10) NOT NULL, | |
1283 | objectID INT(10) NOT NULL, | |
1284 | languageID INT(10), | |
1285 | userID INT(10) NOT NULL, | |
1286 | time INT(10) NOT NULL, | |
1287 | additionalData TEXT, | |
1288 | ||
1289 | KEY (time), | |
1290 | KEY (userID, time), | |
1291 | KEY (objectTypeID, objectID) | |
1292 | ); | |
1293 | ||
1294 | DROP TABLE IF EXISTS wcf1_user_activity_point; | |
1295 | CREATE TABLE wcf1_user_activity_point ( | |
1296 | userID INT(10) NOT NULL, | |
1297 | objectTypeID INT(10) NOT NULL, | |
1298 | activityPoints INT(10) NOT NULL DEFAULT 0, | |
a16ee110 | 1299 | items INT(10) NOT NULL DEFAULT 0, |
320f4a6d MW |
1300 | PRIMARY KEY (userID, objectTypeID), |
1301 | KEY (objectTypeID) | |
1302 | ); | |
1303 | ||
359f3c53 MW |
1304 | DROP TABLE IF EXISTS wcf1_user_authentication_failure; |
1305 | CREATE TABLE wcf1_user_authentication_failure ( | |
1306 | failureID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1307 | environment ENUM('user', 'admin') NOT NULL DEFAULT 'user', | |
1308 | userID INT(10), | |
1309 | username VARCHAR(255) NOT NULL DEFAULT '', | |
1310 | time INT(10) NOT NULL DEFAULT 0, | |
1311 | ipAddress VARCHAR(39) NOT NULL DEFAULT '', | |
1312 | userAgent VARCHAR(255) NOT NULL DEFAULT '', | |
1313 | KEY (ipAddress, time), | |
1314 | KEY (time) | |
1315 | ); | |
1316 | ||
320f4a6d MW |
1317 | DROP TABLE IF EXISTS wcf1_user_avatar; |
1318 | CREATE TABLE wcf1_user_avatar ( | |
1319 | avatarID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1320 | avatarName VARCHAR(255) NOT NULL DEFAULT '', | |
1321 | avatarExtension VARCHAR(7) NOT NULL DEFAULT '', | |
1322 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
1323 | height SMALLINT(5) NOT NULL DEFAULT 0, | |
1324 | userID INT(10), | |
1325 | fileHash VARCHAR(40) NOT NULL DEFAULT '', | |
1326 | cropX SMALLINT(5) NOT NULL DEFAULT 0, | |
1327 | cropY SMALLINT(5) NOT NULL DEFAULT 0 | |
158bd3ca TD |
1328 | ); |
1329 | ||
a8e8aa21 AE |
1330 | DROP TABLE IF EXISTS wcf1_user_collapsible_content; |
1331 | CREATE TABLE wcf1_user_collapsible_content ( | |
1332 | objectTypeID INT(10) NOT NULL, | |
644b0ee3 | 1333 | objectID VARCHAR(255) NOT NULL, |
a8e8aa21 AE |
1334 | userID INT(10) NOT NULL, |
1335 | UNIQUE KEY (objectTypeID, objectID, userID) | |
1336 | ); | |
1337 | ||
320f4a6d MW |
1338 | DROP TABLE IF EXISTS wcf1_user_follow; |
1339 | CREATE TABLE wcf1_user_follow ( | |
1340 | followID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1341 | userID INT(10) NOT NULL, | |
1342 | followUserID INT(10) NOT NULL, | |
1343 | time INT(10) NOT NULL DEFAULT 0, | |
1344 | UNIQUE KEY (userID, followUserID) | |
1345 | ); | |
1346 | ||
158bd3ca TD |
1347 | DROP TABLE IF EXISTS wcf1_user_group; |
1348 | CREATE TABLE wcf1_user_group ( | |
1349 | groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1350 | groupName VARCHAR(255) NOT NULL DEFAULT '', | |
005f6926 | 1351 | groupDescription TEXT, |
320f4a6d MW |
1352 | groupType TINYINT(1) NOT NULL DEFAULT 4, |
1353 | priority MEDIUMINT(8) NOT NULL DEFAULT 0, | |
1354 | userOnlineMarking VARCHAR(255) NOT NULL DEFAULT '%s', | |
1355 | showOnTeamPage TINYINT(1) NOT NULL DEFAULT 0 | |
158bd3ca TD |
1356 | ); |
1357 | ||
87d3a054 MS |
1358 | DROP TABLE IF EXISTS wcf1_user_group_assignment; |
1359 | CREATE TABLE wcf1_user_group_assignment ( | |
1360 | assignmentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1361 | groupID INT(10) NOT NULL, | |
1362 | title VARCHAR(255) NOT NULL, | |
1363 | isDisabled TINYINT(1) NOT NULL DEFAULT 0 | |
1364 | ); | |
1365 | ||
158bd3ca | 1366 | DROP TABLE IF EXISTS wcf1_user_group_option; |
01bd2eff | 1367 | CREATE TABLE wcf1_user_group_option ( |
158bd3ca TD |
1368 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, |
1369 | packageID INT(10), | |
1370 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
1371 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1372 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
1373 | defaultValue MEDIUMTEXT, | |
158bd3ca TD |
1374 | validationPattern TEXT, |
1375 | enableOptions MEDIUMTEXT, | |
1376 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1377 | permissions TEXT, | |
1378 | options TEXT, | |
ae6b590f | 1379 | usersOnly TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1380 | additionalData MEDIUMTEXT, |
1381 | UNIQUE KEY optionName (optionName, packageID) | |
1382 | ); | |
1383 | ||
1384 | DROP TABLE IF EXISTS wcf1_user_group_option_category; | |
1385 | CREATE TABLE wcf1_user_group_option_category ( | |
1386 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1387 | packageID INT(10) NOT NULL, | |
1388 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1389 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1390 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1391 | permissions TEXT, | |
1392 | options TEXT, | |
0e580f32 | 1393 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
1394 | ); |
1395 | ||
1396 | DROP TABLE IF EXISTS wcf1_user_group_option_value; | |
01bd2eff | 1397 | CREATE TABLE wcf1_user_group_option_value ( |
158bd3ca TD |
1398 | groupID INT(10) NOT NULL, |
1399 | optionID INT(10) NOT NULL, | |
1400 | optionValue MEDIUMTEXT NOT NULL, | |
1401 | UNIQUE KEY groupID (groupID, optionID) | |
1402 | ); | |
1403 | ||
320f4a6d MW |
1404 | DROP TABLE IF EXISTS wcf1_user_ignore; |
1405 | CREATE TABLE wcf1_user_ignore ( | |
1406 | ignoreID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1407 | userID INT(10) NOT NULL, | |
1408 | ignoreUserID INT(10) NOT NULL, | |
1409 | time INT(10) NOT NULL DEFAULT 0, | |
1410 | UNIQUE KEY (userID, ignoreUserID) | |
1411 | ); | |
1412 | ||
1413 | DROP TABLE IF EXISTS wcf1_user_menu_item; | |
1414 | CREATE TABLE wcf1_user_menu_item ( | |
1415 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1416 | packageID INT(10) NOT NULL, | |
1417 | menuItem VARCHAR(255) NOT NULL DEFAULT '', | |
1418 | parentMenuItem VARCHAR(255) NOT NULL DEFAULT '', | |
1419 | menuItemController VARCHAR(255) NOT NULL DEFAULT '', | |
1420 | menuItemLink VARCHAR(255) NOT NULL DEFAULT '', | |
1421 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1422 | permissions TEXT, | |
1423 | options TEXT, | |
1424 | className VARCHAR(255) NOT NULL DEFAULT '', | |
a82bf781 | 1425 | iconClassName VARCHAR(255) NOT NULL DEFAULT '', |
320f4a6d MW |
1426 | UNIQUE KEY menuItem (menuItem, packageID) |
1427 | ); | |
1428 | ||
1429 | -- notifications | |
1430 | DROP TABLE IF EXISTS wcf1_user_notification; | |
1431 | CREATE TABLE wcf1_user_notification ( | |
1432 | notificationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
8a4289f5 | 1433 | packageID INT(10) NOT NULL, -- DEPRECATED |
320f4a6d MW |
1434 | eventID INT(10) NOT NULL, |
1435 | objectID INT(10) NOT NULL DEFAULT 0, | |
6db83ca9 | 1436 | baseObjectID INT(10) NOT NULL DEFAULT 0, -- base object ID for generic implementations referencing the origin, e.g. the object being liked |
68206b3f | 1437 | eventHash VARCHAR(40) NOT NULL DEFAULT '', |
4341fcab | 1438 | authorID INT(10) NULL, |
68206b3f | 1439 | timesTriggered INT(10) NOT NULL DEFAULT 0, |
afb18fa2 | 1440 | guestTimesTriggered INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1441 | userID INT(10) NOT NULL, |
320f4a6d | 1442 | time INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1443 | mailNotified TINYINT(1) NOT NULL DEFAULT 0, |
078256b5 | 1444 | confirmTime INT(10) NOT NULL DEFAULT 0, |
320f4a6d | 1445 | additionalData TEXT, |
078256b5 AE |
1446 | KEY (userID, eventID, objectID, confirmTime), |
1447 | KEY (userID, confirmTime) | |
4341fcab AE |
1448 | ); |
1449 | ||
1450 | -- notification authors (stacking) | |
1451 | DROP TABLE IF EXISTS wcf1_user_notification_author; | |
1452 | CREATE TABLE wcf1_user_notification_author ( | |
1453 | notificationID INT(10) NOT NULL, | |
afb18fa2 | 1454 | authorID INT(10), |
4341fcab | 1455 | time INT(10) NOT NULL DEFAULT 0, |
4341fcab | 1456 | UNIQUE KEY (notificationID, authorID) |
320f4a6d MW |
1457 | ); |
1458 | ||
1459 | -- notification recipients | |
4341fcab | 1460 | -- DEPRECATED |
320f4a6d MW |
1461 | DROP TABLE IF EXISTS wcf1_user_notification_to_user; |
1462 | CREATE TABLE wcf1_user_notification_to_user ( | |
1463 | notificationID INT(10) NOT NULL, | |
1464 | userID INT(10) NOT NULL, | |
320f4a6d MW |
1465 | UNIQUE KEY notificationID (notificationID, userID) |
1466 | ); | |
1467 | ||
1468 | -- events that create notifications | |
1469 | DROP TABLE IF EXISTS wcf1_user_notification_event; | |
1470 | CREATE TABLE wcf1_user_notification_event ( | |
1471 | eventID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1472 | packageID INT(10) NOT NULL, | |
1473 | eventName VARCHAR(255) NOT NULL DEFAULT '', | |
1474 | objectTypeID INT(10) NOT NULL, | |
1475 | className VARCHAR(255) NOT NULL DEFAULT '', | |
1476 | permissions TEXT, | |
1477 | options TEXT, | |
2d7c568a | 1478 | preset TINYINT(1) NOT NULL DEFAULT 0, |
0ceb9e95 | 1479 | presetMailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none', |
320f4a6d MW |
1480 | UNIQUE KEY eventName (eventName, objectTypeID) |
1481 | ); | |
1482 | ||
1483 | -- user configuration for events | |
1484 | DROP TABLE IF EXISTS wcf1_user_notification_event_to_user; | |
1485 | CREATE TABLE wcf1_user_notification_event_to_user ( | |
1486 | userID INT(10) NOT NULL, | |
1487 | eventID INT(10) NOT NULL, | |
1488 | mailNotificationType ENUM('none', 'instant', 'daily') NOT NULL DEFAULT 'none', | |
1489 | UNIQUE KEY (eventID, userID) | |
1490 | ); | |
1491 | ||
1492 | DROP TABLE IF EXISTS wcf1_user_object_watch; | |
1493 | CREATE TABLE wcf1_user_object_watch ( | |
1494 | watchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1495 | objectTypeID INT(10) NOT NULL, | |
1496 | objectID INT(10) NOT NULL, | |
1497 | userID INT(10) NOT NULL, | |
1498 | notification TINYINT(1) NOT NULL DEFAULT 0, | |
1499 | ||
1500 | UNIQUE KEY (objectTypeID, userID, objectID), | |
1501 | KEY (objectTypeID, objectID) | |
1502 | ); | |
1503 | ||
158bd3ca TD |
1504 | DROP TABLE IF EXISTS wcf1_user_option; |
1505 | CREATE TABLE wcf1_user_option ( | |
1506 | optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1507 | packageID INT(10) NOT NULL, | |
1508 | optionName VARCHAR(255) NOT NULL DEFAULT '', | |
1509 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
1510 | optionType VARCHAR(255) NOT NULL DEFAULT '', | |
1511 | defaultValue MEDIUMTEXT, | |
1512 | validationPattern TEXT, | |
1513 | selectOptions MEDIUMTEXT, | |
1514 | enableOptions MEDIUMTEXT, | |
1515 | required TINYINT(1) NOT NULL DEFAULT 0, | |
1516 | askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0, | |
1517 | editable TINYINT(1) NOT NULL DEFAULT 0, | |
1518 | visible TINYINT(1) NOT NULL DEFAULT 0, | |
1519 | outputClass VARCHAR(255) NOT NULL DEFAULT '', | |
1520 | searchable TINYINT(1) NOT NULL DEFAULT 0, | |
1521 | showOrder INT(10) NOT NULL DEFAULT 0, | |
8f08c7d0 | 1522 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1523 | permissions TEXT, |
1524 | options TEXT, | |
1525 | additionalData MEDIUMTEXT, | |
31378fd1 | 1526 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, |
158bd3ca TD |
1527 | UNIQUE KEY optionName (optionName, packageID), |
1528 | KEY categoryName (categoryName) | |
1529 | ); | |
1530 | ||
1531 | DROP TABLE IF EXISTS wcf1_user_option_category; | |
1532 | CREATE TABLE wcf1_user_option_category ( | |
1533 | categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1534 | packageID INT(10) NOT NULL, | |
1535 | categoryName VARCHAR(255) NOT NULL DEFAULT '', | |
158bd3ca TD |
1536 | parentCategoryName VARCHAR(255) NOT NULL DEFAULT '', |
1537 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1538 | permissions TEXT, | |
1539 | options TEXT, | |
0e580f32 | 1540 | UNIQUE KEY categoryName (categoryName) |
158bd3ca TD |
1541 | ); |
1542 | ||
1543 | DROP TABLE IF EXISTS wcf1_user_option_value; | |
1544 | CREATE TABLE wcf1_user_option_value ( | |
1545 | userID INT(10) NOT NULL PRIMARY KEY | |
1546 | ); | |
1547 | ||
320f4a6d MW |
1548 | DROP TABLE IF EXISTS wcf1_user_profile_menu_item; |
1549 | CREATE TABLE wcf1_user_profile_menu_item ( | |
1550 | menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
1551 | packageID INT(10) NOT NULL, | |
1552 | menuItem VARCHAR(255) NOT NULL, | |
1553 | showOrder INT(10) NOT NULL DEFAULT 0, | |
1554 | permissions TEXT NULL, | |
1555 | options TEXT NULL, | |
1556 | className VARCHAR(255) NOT NULL, | |
1557 | UNIQUE KEY (packageID, menuItem) | |
1558 | ); | |
1559 | ||
1560 | DROP TABLE IF EXISTS wcf1_user_profile_visitor; | |
1561 | CREATE TABLE wcf1_user_profile_visitor ( | |
1562 | visitorID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
85a3822b MS |
1563 | ownerID INT(10) NOT NULL, |
1564 | userID INT(10) NOT NULL, | |
320f4a6d MW |
1565 | time INT(10) NOT NULL DEFAULT 0, |
1566 | UNIQUE KEY (ownerID, userID), | |
1567 | KEY (time) | |
1568 | ); | |
1569 | ||
1570 | DROP TABLE IF EXISTS wcf1_user_rank; | |
1571 | CREATE TABLE wcf1_user_rank ( | |
1572 | rankID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
d2fbb3b5 | 1573 | groupID INT(10) NOT NULL, |
320f4a6d MW |
1574 | requiredPoints INT(10) NOT NULL DEFAULT 0, |
1575 | rankTitle VARCHAR(255) NOT NULL DEFAULT '', | |
1576 | cssClassName VARCHAR(255) NOT NULL DEFAULT '', | |
1577 | rankImage VARCHAR(255) NOT NULL DEFAULT '', | |
1578 | repeatImage TINYINT(3) NOT NULL DEFAULT 1, | |
1579 | requiredGender TINYINT(1) NOT NULL DEFAULT 0 | |
1580 | ); | |
1581 | ||
0a67f96c MS |
1582 | DROP TABLE IF EXISTS wcf1_user_storage; |
1583 | CREATE TABLE wcf1_user_storage ( | |
1584 | userID INT(10) NOT NULL, | |
1585 | field VARCHAR(80) NOT NULL DEFAULT '', | |
064caa4a | 1586 | fieldValue MEDIUMTEXT, |
0b30544a | 1587 | UNIQUE KEY userStorageData (userID, field) |
0a67f96c MS |
1588 | ); |
1589 | ||
158bd3ca TD |
1590 | DROP TABLE IF EXISTS wcf1_user_to_group; |
1591 | CREATE TABLE wcf1_user_to_group ( | |
1592 | userID INT(10) NOT NULL, | |
1593 | groupID INT(10) NOT NULL, | |
1594 | UNIQUE KEY userID (userID, groupID) | |
1595 | ); | |
1596 | ||
1597 | DROP TABLE IF EXISTS wcf1_user_to_language; | |
1598 | CREATE TABLE wcf1_user_to_language ( | |
1599 | userID INT(10) NOT NULL, | |
1600 | languageID INT(10) NOT NULL, | |
1601 | UNIQUE KEY userID (userID, languageID) | |
1602 | ); | |
1603 | ||
2fbf5046 AE |
1604 | /* SQL_PARSER_OFFSET */ |
1605 | ||
9f959ced | 1606 | /* foreign keys */ |
092bdf82 AE |
1607 | ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1608 | ALTER TABLE wcf1_acl_option ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1609 | ||
1610 | ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1611 | ALTER TABLE wcf1_acl_option_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1612 | ||
1613 | ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE; | |
1614 | ALTER TABLE wcf1_acl_option_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1615 | ||
1616 | ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (optionID) REFERENCES wcf1_acl_option (optionID) ON DELETE CASCADE; | |
1617 | ALTER TABLE wcf1_acl_option_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1618 | ||
158bd3ca TD |
1619 | ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1620 | ||
e9311b98 AE |
1621 | ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1622 | ||
158bd3ca | 1623 | ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
158bd3ca TD |
1624 | |
1625 | ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE; | |
158bd3ca | 1626 | |
158bd3ca TD |
1627 | ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
1628 | ||
e1622bfa TD |
1629 | ALTER TABLE wcf1_acp_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_acp_session (sessionID) ON DELETE CASCADE ON UPDATE CASCADE; |
1630 | ||
158bd3ca TD |
1631 | ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1632 | ||
e866b80e MS |
1633 | ALTER TABLE wcf1_ad ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1634 | ||
158bd3ca | 1635 | ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
158bd3ca | 1636 | |
f0bc263f MW |
1637 | ALTER TABLE wcf1_attachment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1638 | ALTER TABLE wcf1_attachment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1639 | ||
dcc2332d MW |
1640 | ALTER TABLE wcf1_bbcode ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1641 | ||
1642 | ALTER TABLE wcf1_bbcode_attribute ADD FOREIGN KEY (bbcodeID) REFERENCES wcf1_bbcode (bbcodeID) ON DELETE CASCADE; | |
1643 | ||
91317611 | 1644 | ALTER TABLE wcf1_box ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
11fd4618 | 1645 | ALTER TABLE wcf1_box ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
39abe192 | 1646 | ALTER TABLE wcf1_box ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE; |
5636588a | 1647 | ALTER TABLE wcf1_box ADD FOREIGN KEY (linkPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL; |
11fd4618 MW |
1648 | |
1649 | ALTER TABLE wcf1_box_content ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE; | |
56eb7314 MS |
1650 | ALTER TABLE wcf1_box_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; |
1651 | ALTER TABLE wcf1_box_content ADD FOREIGN KEY (imageID) REFERENCES wcf1_media (mediaID) ON DELETE SET NULL; | |
11fd4618 | 1652 | |
53cf1c00 MW |
1653 | ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (boxID) REFERENCES wcf1_box (boxID) ON DELETE CASCADE; |
1654 | ALTER TABLE wcf1_box_to_page ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE; | |
1655 | ||
13d8b49b MS |
1656 | ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1657 | ||
054db725 TD |
1658 | ALTER TABLE wcf1_cli_history ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1659 | ||
0e6741f8 AE |
1660 | ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1661 | ||
25cf4d11 | 1662 | ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
0e6741f8 AE |
1663 | |
1664 | ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE; | |
1665 | ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1666 | ||
87d3a054 MS |
1667 | ALTER TABLE wcf1_condition ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1668 | ||
158bd3ca TD |
1669 | ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1670 | ||
1671 | ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1672 | ||
1673 | ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE; | |
1674 | ||
81aa6374 TD |
1675 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1676 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
f86d7ff7 | 1677 | ALTER TABLE wcf1_edit_history_entry ADD FOREIGN KEY (obsoletedByUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
81aa6374 | 1678 | |
158bd3ca TD |
1679 | ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1680 | ||
1681 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1682 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE; | |
1683 | ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1684 | ||
59ab4d0f MS |
1685 | ALTER TABLE wcf1_media ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
1686 | ALTER TABLE wcf1_media ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL; | |
1687 | ||
1688 | ALTER TABLE wcf1_media_content ADD FOREIGN KEY (mediaID) REFERENCES wcf1_media (mediaID) ON DELETE CASCADE; | |
1689 | ALTER TABLE wcf1_media_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1690 | ||
e7fb3339 MW |
1691 | ALTER TABLE wcf1_menu ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1692 | ||
1693 | ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (menuID) REFERENCES wcf1_menu (menuID) ON DELETE CASCADE; | |
1694 | ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (parentItemID) REFERENCES wcf1_menu_item (itemID) ON DELETE SET NULL; | |
effc9389 AE |
1695 | ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE; |
1696 | ALTER TABLE wcf1_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
e7fb3339 | 1697 | |
3a2de7fd AE |
1698 | ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1699 | ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1700 | ||
7fcc7676 MW |
1701 | ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE; |
1702 | ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1703 | ||
1704 | ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1705 | ||
158bd3ca TD |
1706 | ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1707 | ||
1708 | ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1709 | ||
158bd3ca TD |
1710 | ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1711 | ||
1712 | ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1713 | ||
1714 | ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE; | |
1715 | ||
1716 | ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE; | |
1717 | ||
1718 | ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1719 | ||
1720 | ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1721 | ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL; | |
1722 | ||
1723 | ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1724 | ||
1b4f5112 AE |
1725 | /* SQL_PARSER_OFFSET */ |
1726 | ||
158bd3ca TD |
1727 | ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1728 | ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1729 | ||
158bd3ca TD |
1730 | ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE; |
1731 | ||
1732 | ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1733 | ||
1734 | ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1735 | ||
1736 | ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; | |
1737 | ||
b4f1ea02 | 1738 | ALTER TABLE wcf1_package_update_optional ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; |
158bd3ca TD |
1739 | |
1740 | ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE; | |
1741 | ||
4d8036f5 MW |
1742 | ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE CASCADE; |
1743 | ALTER TABLE wcf1_paid_subscription_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1744 | ||
1745 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionUserID) REFERENCES wcf1_paid_subscription_user (subscriptionUserID) ON DELETE SET NULL; | |
1746 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1747 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (subscriptionID) REFERENCES wcf1_paid_subscription (subscriptionID) ON DELETE SET NULL; | |
1748 | ALTER TABLE wcf1_paid_subscription_transaction_log ADD FOREIGN KEY (paymentMethodObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1749 | ||
0bdb3cdf MW |
1750 | ALTER TABLE wcf1_page ADD FOREIGN KEY (parentPageID) REFERENCES wcf1_page (pageID) ON DELETE SET NULL; |
1751 | ALTER TABLE wcf1_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
19dadfda | 1752 | ALTER TABLE wcf1_page ADD FOREIGN KEY (applicationPackageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL; |
0bdb3cdf MW |
1753 | |
1754 | ALTER TABLE wcf1_page_content ADD FOREIGN KEY (pageID) REFERENCES wcf1_page (pageID) ON DELETE CASCADE; | |
1755 | ALTER TABLE wcf1_page_content ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1756 | ||
158bd3ca TD |
1757 | ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1758 | ||
158bd3ca | 1759 | ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
e8d26212 | 1760 | ALTER TABLE wcf1_session ADD FOREIGN KEY (spiderID) REFERENCES wcf1_spider (spiderID) ON DELETE CASCADE; |
158bd3ca | 1761 | |
281ac362 | 1762 | ALTER TABLE wcf1_session_virtual ADD FOREIGN KEY (sessionID) REFERENCES wcf1_session (sessionID) ON DELETE CASCADE ON UPDATE CASCADE; |
5a05fde9 | 1763 | |
46bd110b AE |
1764 | ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1765 | ||
dcc2332d MW |
1766 | ALTER TABLE wcf1_smiley ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1767 | ALTER TABLE wcf1_smiley ADD FOREIGN KEY (categoryID) REFERENCES wcf1_category (categoryID) ON DELETE SET NULL; | |
1768 | ||
461a69ea | 1769 | ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
158bd3ca TD |
1770 | |
1771 | ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1772 | ||
4d9f6058 AE |
1773 | ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE; |
1774 | ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE; | |
158bd3ca TD |
1775 | |
1776 | ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1777 | ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE; | |
1778 | ||
6570e38e MW |
1779 | ALTER TABLE wcf1_template_group ADD FOREIGN KEY (parentTemplateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE SET NULL; |
1780 | ||
158bd3ca TD |
1781 | ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1782 | ||
a8e8aa21 AE |
1783 | ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1784 | ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1785 | ||
87d3a054 MS |
1786 | ALTER TABLE wcf1_user_group_assignment ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; |
1787 | ||
158bd3ca TD |
1788 | ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1789 | ||
1790 | ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1791 | ||
1792 | ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1793 | ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE; | |
1794 | ||
2fbf5046 AE |
1795 | /* SQL_PARSER_OFFSET */ |
1796 | ||
158bd3ca TD |
1797 | ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
1798 | ||
1799 | ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1800 | ||
1801 | ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1802 | ||
1803 | ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1804 | ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; | |
1805 | ||
1806 | ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1807 | ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1808 | ||
78db8ddf MW |
1809 | ALTER TABLE wcf1_import_mapping ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1810 | ||
320f4a6d MW |
1811 | ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1812 | ALTER TABLE wcf1_tracked_visit ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1813 | ||
1814 | ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1815 | ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1816 | ||
1817 | ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL; | |
1818 | ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL; | |
1819 | ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL; | |
1820 | ||
1821 | ALTER TABLE wcf1_user_avatar ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1822 | ||
1823 | ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1824 | ALTER TABLE wcf1_user_follow ADD FOREIGN KEY (followUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1825 | ||
1826 | ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1827 | ALTER TABLE wcf1_user_ignore ADD FOREIGN KEY (ignoreUserID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1828 | ||
1829 | ALTER TABLE wcf1_user_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1830 | ||
320f4a6d MW |
1831 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE; |
1832 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
4341fcab AE |
1833 | ALTER TABLE wcf1_user_notification ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1834 | ||
1835 | ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE; | |
1836 | ALTER TABLE wcf1_user_notification_author ADD FOREIGN KEY (authorID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
320f4a6d MW |
1837 | |
1838 | ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (notificationID) REFERENCES wcf1_user_notification (notificationID) ON DELETE CASCADE; | |
1839 | ALTER TABLE wcf1_user_notification_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1840 | ||
1841 | ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1842 | ALTER TABLE wcf1_user_notification_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1843 | ||
1844 | ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1845 | ALTER TABLE wcf1_user_notification_event_to_user ADD FOREIGN KEY (eventID) REFERENCES wcf1_user_notification_event (eventID) ON DELETE CASCADE; | |
1846 | ||
1847 | ALTER TABLE wcf1_user_profile_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; | |
1848 | ||
1b4f5112 AE |
1849 | /* SQL_PARSER_OFFSET */ |
1850 | ||
d2fbb3b5 | 1851 | ALTER TABLE wcf1_user_rank ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE; |
320f4a6d MW |
1852 | |
1853 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1854 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1855 | ALTER TABLE wcf1_user_activity_event ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE SET NULL; | |
1856 | ||
1857 | ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1858 | ALTER TABLE wcf1_user_activity_point ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1859 | ||
359f3c53 MW |
1860 | ALTER TABLE wcf1_user_authentication_failure ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; |
1861 | ||
320f4a6d MW |
1862 | ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (ownerID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; |
1863 | ALTER TABLE wcf1_user_profile_visitor ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1864 | ||
1865 | ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1866 | ALTER TABLE wcf1_user_object_watch ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1867 | ||
0a2b09a2 MW |
1868 | ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (messageObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1869 | ALTER TABLE wcf1_message_embedded_object ADD FOREIGN KEY (embeddedObjectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1870 | ||
fc69b61d MW |
1871 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1872 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1873 | ALTER TABLE wcf1_moderation_queue ADD FOREIGN KEY (assignedUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1874 | ||
1875 | ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (queueID) REFERENCES wcf1_moderation_queue (queueID) ON DELETE CASCADE; | |
1876 | ALTER TABLE wcf1_moderation_queue_to_user ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1877 | ||
00b6f956 MW |
1878 | ALTER TABLE wcf1_like ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1879 | ALTER TABLE wcf1_like ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1880 | ALTER TABLE wcf1_like ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1881 | ||
1882 | ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1883 | ALTER TABLE wcf1_like_object ADD FOREIGN KEY (objectUserID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1884 | ||
285b1d92 MW |
1885 | ALTER TABLE wcf1_comment ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1886 | ALTER TABLE wcf1_comment ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1887 | ||
1888 | ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (commentID) REFERENCES wcf1_comment (commentID) ON DELETE CASCADE; | |
1889 | ALTER TABLE wcf1_comment_response ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL; | |
1890 | ||
3b75466f MW |
1891 | ALTER TABLE wcf1_label ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE; |
1892 | ||
1893 | ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (groupID) REFERENCES wcf1_label_group (groupID) ON DELETE CASCADE; | |
1894 | ALTER TABLE wcf1_label_group_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1895 | ||
1896 | ALTER TABLE wcf1_label_object ADD FOREIGN KEY (labelID) REFERENCES wcf1_label (labelID) ON DELETE CASCADE; | |
1897 | ALTER TABLE wcf1_label_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1898 | ||
04c06e85 MW |
1899 | ALTER TABLE wcf1_tag ADD FOREIGN KEY (synonymFor) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE; |
1900 | ||
1901 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (tagID) REFERENCES wcf1_tag (tagID) ON DELETE CASCADE; | |
1902 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE; | |
1903 | ALTER TABLE wcf1_tag_to_object ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; | |
1904 | ||
891de7a0 MW |
1905 | ALTER TABLE wcf1_stat_daily ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1906 | ||
e25b7b61 MW |
1907 | ALTER TABLE wcf1_poll ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE; |
1908 | ||
1909 | ALTER TABLE wcf1_poll_option ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE; | |
1910 | ||
1911 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (pollID) REFERENCES wcf1_poll (pollID) ON DELETE CASCADE; | |
1912 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (optionID) REFERENCES wcf1_poll_option (optionID) ON DELETE CASCADE; | |
1913 | ALTER TABLE wcf1_poll_option_vote ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1914 | ||
20933e61 MS |
1915 | ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (noticeID) REFERENCES wcf1_notice (noticeID) ON DELETE CASCADE; |
1916 | ALTER TABLE wcf1_notice_dismissed ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE; | |
1917 | ||
2fbf5046 AE |
1918 | /* SQL_PARSER_OFFSET */ |
1919 | ||
9f959ced | 1920 | /* default inserts */ |
158bd3ca | 1921 | -- default user groups |
3f69fee7 AE |
1922 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (1, 'wcf.acp.group.group1', 1); -- Everyone |
1923 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (2, 'wcf.acp.group.group2', 2); -- Guests | |
1924 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (3, 'wcf.acp.group.group3', 3); -- Registered Users | |
1925 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (4, 'wcf.acp.group.group4', 4); -- Administrators | |
1926 | INSERT INTO wcf1_user_group (groupID, groupName, groupType) VALUES (5, 'wcf.acp.group.group5', 4); -- Moderators | |
47459aed | 1927 | |
158bd3ca | 1928 | -- default user group options |
ae6b590f | 1929 | INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (1, 'admin.general.canUseAcp', 'admin.general', 'boolean', '0', 1, 1); |
6476e7a1 | 1930 | INSERT INTO wcf1_user_group_option (optionID, optionName, categoryName, optionType, defaultValue, showOrder, usersOnly) VALUES (2, 'admin.configuration.package.canInstallPackage', 'admin.configuration.package', 'boolean', '0', 1, 1); |
ae6b590f | 1931 | 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 |
1932 | |
1933 | -- default user group option values | |
1934 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone | |
1935 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone | |
1936 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone | |
1937 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators | |
1938 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators | |
1939 | INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators | |
47459aed | 1940 | |
158bd3ca | 1941 | -- default update servers |
37089cb5 AE |
1942 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', ''); |
1943 | 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 |
1944 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/typhoon/', 'online', 0, NULL, 0, '', ''); |
1945 | 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 |
1946 | |
1947 | -- style default values | |
3321b9c6 | 1948 | |
97ec0367 | 1949 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualScss', ''); |
3321b9c6 | 1950 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('messageSidebarOrientation', 'left'); |
97ec0367 | 1951 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideScss', ''); |
ed8c9052 AE |
1952 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', ''); |
1953 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1'); | |
1954 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useGoogleFont', '1'); | |
95cc4d01 AE |
1955 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackground', 'rgba(224, 224, 224, 1)'); |
1956 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundActive', 'rgba(213, 213, 213, 1)'); | |
1957 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorder', 'rgba(127, 140, 141, 1)'); -- no longer in use (ACP style editor needs to be updated first) | |
1958 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderActive', 'rgba(52, 73, 94, 1)'); -- no longer in use (ACP style editor needs to be updated first) | |
1959 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledBackground', 'rgba(223, 223, 223, 1)'); | |
487db634 | 1960 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledBorder', 'rgba(173, 176, 179, 1)'); |
95cc4d01 AE |
1961 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonDisabledText', 'rgba(165, 165, 165, 1)'); |
1962 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackground', 'rgba(33, 150, 243, 1)'); | |
1963 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundActive', 'rgba(26, 119, 201, 1)'); | |
1964 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorder', 'rgba(79, 129, 189, 1)'); -- no longer in use (ACP style editor needs to be updated first) | |
1965 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderActive', 'rgba(79, 129, 189, 1)'); -- no longer in use (ACP style editor needs to be updated first) | |
1966 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryText', 'rgba(255, 255, 255, 1)'); | |
ed8c9052 | 1967 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryTextActive', 'rgba(255, 255, 255, 1)'); |
95cc4d01 AE |
1968 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonText', 'rgba(33, 33, 33, 1)'); |
1969 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonTextActive', 'rgba(33, 33, 33, 1)'); | |
ed8c9052 | 1970 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackground', 'rgba(255, 255, 255, 1)'); |
e2368a74 | 1971 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorder', 'rgba(79, 129, 189, 1)'); |
ed8c9052 | 1972 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBorderInner', 'rgba(238, 238, 238, 1)'); |
962f1164 AE |
1973 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLink', 'rgba(52, 73, 94, 1)'); |
1974 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedLinkActive', 'rgba(52, 73, 94, 1)'); | |
487db634 | 1975 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentDimmedText', 'rgba(125, 130, 135, 1)'); |
962f1164 AE |
1976 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineBorder', 'rgba(238, 238, 238, 1)'); |
1977 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLink', 'rgba(44, 62, 80, 1)'); | |
1978 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineLinkActive', 'rgba(44, 62, 80, 1)'); | |
1979 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentHeadlineText', 'rgba(44, 62, 80, 1)'); | |
1980 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLink', 'rgba(231, 76, 60, 1)'); | |
ed8c9052 AE |
1981 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentLinkActive', 'rgba(192, 57, 43, 1)'); |
1982 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentText', 'rgba(44, 62, 80, 1)'); | |
1983 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackground', 'rgba(255, 255, 255, 1)'); | |
c1956b1c AE |
1984 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundActive', 'rgba(238, 238, 238, 1)'); |
1985 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorder', 'rgba(55, 73, 95, 1)'); -- no longer in use (ACP style editor needs to be updated first) | |
962f1164 | 1986 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderInner', 'rgba(238, 238, 238, 1)'); |
c1956b1c AE |
1987 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLink', 'rgba(33, 33, 33, 1)'); |
1988 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownLinkActive', 'rgba(33, 33, 33, 1)'); | |
1989 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownText', 'rgba(33, 33, 33, 1)'); | |
ed8c9052 AE |
1990 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyFallback', '"Segoe UI", "Lucida Grande", "Helveltica", sans-serif'); |
1991 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontFamilyGoogle', 'Open Sans'); | |
852e099f | 1992 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontLineHeight', '1.48'); |
962f1164 | 1993 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeDefault', '14px'); |
ed8c9052 | 1994 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeHeadline', '18px'); |
f6fc939a | 1995 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSection', '23px'); |
ed8c9052 | 1996 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeSmall', '12px'); |
487db634 | 1997 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFontSizeTitle', '28px'); |
6063a7ec AE |
1998 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBackground', 'rgba(44, 62, 80, 1)'); |
1999 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxBackground', 'rgba(247, 248, 250, 1)'); | |
2000 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLink', 'rgba(44, 62, 80, 1)'); | |
2001 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineLinkActive', 'rgba(44, 62, 80, 1)'); | |
2002 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxHeadlineText', 'rgba(44, 62, 80, 1)'); | |
2003 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLink', 'rgba(231, 76, 60, 1)'); | |
2004 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxLinkActive', 'rgba(192, 57, 43, 1)'); | |
2005 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterBoxText', 'rgba(44, 62, 80, 1)'); | |
2006 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightBackground', 'rgba(52, 73, 94, 1)'); | |
2007 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLink', 'rgba(255, 255, 255, 1)'); | |
2008 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightLinkActive', 'rgba(255, 255, 255, 1)'); | |
2009 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterCopyrightText', 'rgba(189, 195, 199, 1)'); | |
f6fc939a AE |
2010 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLink', 'rgba(255, 255, 255, 1)'); |
2011 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineLinkActive', 'rgba(255, 255, 255, 1)'); | |
2012 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterHeadlineText', 'rgba(189, 195, 199, 1)'); | |
ed8c9052 AE |
2013 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLink', 'rgba(255, 255, 255, 1)'); |
2014 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterLinkActive', 'rgba(255, 255, 255, 1)'); | |
f6fc939a | 2015 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfFooterText', 'rgba(189, 195, 199, 1)'); |
ed8c9052 AE |
2016 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px'); |
2017 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px'); | |
2018 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px'); | |
2019 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px'); | |
80786168 | 2020 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderBackground', 'rgba(52, 73, 94, 1)'); |
55b402a0 | 2021 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderText', 'rgba(255, 255, 255, 1)'); |
e2368a74 | 2022 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLink', 'rgba(255, 255, 255, .8)'); |
ed8c9052 | 2023 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderLinkActive', 'rgba(255, 255, 255, 1)'); |
80786168 AE |
2024 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuBackground', 'rgba(44, 62, 80, 1)'); |
2025 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuBackgroundActive', 'rgba(34, 49, 63, 1)'); | |
f6fc939a | 2026 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLink', 'rgba(255, 255, 255, 1)'); |
ed8c9052 | 2027 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuLinkActive', 'rgba(255, 255, 255, 1)'); |
80786168 | 2028 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackground', 'rgba(34, 49, 63, 1)'); |
f6fc939a AE |
2029 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBackgroundActive', 'rgba(55, 73, 95, 1)'); |
2030 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownBorder', 'rgba(55, 73, 95, 1)'); | |
a9e43634 | 2031 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLink', 'rgba(255, 255, 255, 1)'); |
f6fc939a | 2032 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderMenuDropdownLinkActive', 'rgba(255, 255, 255, 1)'); |
80786168 AE |
2033 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackground', 'rgba(44, 62, 80, 1)'); |
2034 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBackgroundActive', 'rgba(34, 49, 63, 1)'); | |
ed8c9052 | 2035 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxText', 'rgba(255, 255, 255, 1)'); |
a9026680 | 2036 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxTextActive', 'rgba(255, 255, 255, 1)'); |
487db634 | 2037 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBorder', 'rgba(128, 139, 150, 1)'); |
a9026680 | 2038 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxBorderActive', 'rgba(255, 255, 255, 1)'); |
6e6b849f | 2039 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholder', 'rgba(169, 169, 169, 1)'); |
5d0e8b3f | 2040 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeaderSearchBoxPlaceholderActive', 'rgba(204, 204, 204, 1)'); |
487db634 MW |
2041 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackground', 'rgba(241, 246, 251, 1)'); |
2042 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundActive', 'rgba(241, 246, 251, 1)'); | |
2043 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorder', 'rgba(176, 200, 224, 1)'); | |
962f1164 | 2044 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderActive', 'rgba(41, 128, 185, 1)'); |
487db634 MW |
2045 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBackground', 'rgba(245, 245, 245, 1)'); |
2046 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledBorder', 'rgba(174, 176, 179, 1)'); | |
2047 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputDisabledText', 'rgba(125, 130, 100, 1)'); | |
b4f2a6be | 2048 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputLabel', 'rgba(59, 109, 169, 1)'); |
487db634 MW |
2049 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputText', 'rgba(44, 62, 80, 1)'); |
2050 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputTextActive', 'rgba(44, 62, 80, 1)'); | |
6e6b849f | 2051 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholder', 'rgba(169, 169, 169, 1)'); |
5d0e8b3f | 2052 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputPlaceholderActive', 'rgba(204, 204, 204, 1)'); |
ed8c9052 | 2053 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px'); |
962f1164 | 2054 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMaxWidth', '1400px'); |
5c448cc2 | 2055 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutMinWidth', '1240px'); |
80786168 AE |
2056 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationBackground', 'rgba(247, 248, 250, 1)'); |
2057 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLink', 'rgba(44, 62, 80, 1)'); | |
2058 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationLinkActive', 'rgba(44, 62, 80, 1)'); | |
962f1164 | 2059 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationText', 'rgba(170, 170, 170, 1)'); |
487db634 | 2060 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackground', 'rgba(247, 248, 250, 1)'); |
962f1164 AE |
2061 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLink', 'rgba(44, 62, 80, 1)'); |
2062 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedLinkActive', 'rgba(44, 62, 80, 1)'); | |
2063 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarDimmedText', 'rgba(127, 140, 141, 1)'); | |
487db634 MW |
2064 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLink', 'rgba(44, 62, 80, 1)'); |
2065 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineLinkActive', 'rgba(44, 62, 80, 1)'); | |
2066 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarHeadlineText', 'rgba(44, 62, 80, 1)'); | |
2067 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLink', 'rgba(231, 76, 60, 1)'); | |
2068 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarLinkActive', 'rgba(192, 57, 43, 1)'); | |
2069 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarText', 'rgba(44, 62, 80, 1)'); | |
962f1164 AE |
2070 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBackground', 'rgba(242, 222, 222, 1)'); |
2071 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorBorder', 'rgba(235, 204, 204, 1)'); | |
2072 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLink', 'rgba(169, 68, 66, 1)'); | |
2073 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorLinkActive', 'rgba(169, 68, 66, 1)'); | |
2074 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusErrorText', 'rgba(169, 68, 66, 1)'); | |
2075 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBackground', 'rgba(217, 237, 247, 1)'); | |
2076 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoBorder', 'rgba(188, 223, 241, 1)'); | |
2077 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLink', 'rgba(49, 112, 143, 1)'); | |
2078 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoLinkActive', 'rgba(49, 112, 143, 1)'); | |
2079 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusInfoText', 'rgba(49, 112, 143, 1)'); | |
2080 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBackground', 'rgba(223, 240, 216, 1)'); | |
2081 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessBorder', 'rgba(208, 233, 198, 1)'); | |
2082 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLink', 'rgba(60, 118, 61, 1)'); | |
2083 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessLinkActive', 'rgba(60, 118, 61, 1)'); | |
2084 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusSuccessText', 'rgba(60, 118, 61, 1)'); | |
2085 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBackground', 'rgba(252, 248, 227, 1)'); | |
2086 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningBorder', 'rgba(250, 242, 204, 1)'); | |
2087 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLink', 'rgba(138, 109, 59, 1)'); | |
2088 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningLinkActive', 'rgba(138, 109, 59, 1)'); | |
2089 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfStatusWarningText', 'rgba(138, 109, 59, 1)'); | |
2090 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundActive', 'rgba(242, 242, 242, 1)'); | |
2091 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBorderInner', 'rgba(238, 238, 238, 1)'); | |
2092 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadline', 'rgba(79, 129, 189, 1)'); | |
2093 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHeadlineActive', 'rgba(192, 57, 43, 1)'); | |
ed8c9052 AE |
2094 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowDark', 'rgba(0, 0, 0, .8)'); |
2095 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTextShadowLight', 'rgba(255, 255, 255, .8)'); | |
2096 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackground', 'rgba(0, 0, 0, .8)'); | |
2097 | INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipText', 'rgba(255, 255, 255, 1)'); | |
dcc2332d MW |
2098 | |
2099 | -- media providers | |
2100 | -- Videos | |
2101 | -- Youtube | |
c38e96cf | 2102 | 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 | 2103 | -- Vimeo |
d90e8793 | 2104 | 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 | 2105 | -- MyVideo |
fc9a1748 | 2106 | 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 | 2107 | -- Clipfish |
eab82f4c | 2108 | 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 | 2109 | -- Veoh |
fc9a1748 | 2110 | 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 | 2111 | -- DailyMotion |
eab82f4c | 2112 | 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 |
2113 | -- Misc |
2114 | -- github gist | |
eab82f4c | 2115 | 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 | 2116 | -- soundcloud |
c0587328 MW |
2117 | 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>'); |
2118 | -- soundcloud set | |
2119 | 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>'); | |
2120 | ||
320f4a6d MW |
2121 | -- default priorities |
2122 | UPDATE wcf1_user_group SET priority = 10 WHERE groupID = 3; | |
2123 | UPDATE wcf1_user_group SET priority = 1000 WHERE groupID = 4; | |
c3ab3fe0 | 2124 | UPDATE wcf1_user_group SET priority = 100 WHERE groupID = 5; |
320f4a6d MW |
2125 | |
2126 | -- default 'showOnTeamPage' setting | |
c3ab3fe0 | 2127 | UPDATE wcf1_user_group SET showOnTeamPage = 1 WHERE groupID IN (4, 5); |
320f4a6d MW |
2128 | |
2129 | -- default ranks | |
2130 | INSERT INTO wcf1_user_rank (groupID, requiredPoints, rankTitle, cssClassName) VALUES | |
2131 | (4, 0, 'wcf.user.rank.administrator', 'blue'), | |
2132 | (5, 0, 'wcf.user.rank.moderator', 'blue'), | |
320f4a6d MW |
2133 | (3, 0, 'wcf.user.rank.user0', ''), |
2134 | (3, 300, 'wcf.user.rank.user1', ''), | |
2135 | (3, 900, 'wcf.user.rank.user2', ''), | |
2136 | (3, 3000, 'wcf.user.rank.user3', ''), | |
2137 | (3, 9000, 'wcf.user.rank.user4', ''), | |
861451f4 | 2138 | (3, 15000, 'wcf.user.rank.user5', ''); |