projects / GitHub / WoltLab / WCF.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Enhanced application management and removed RELATIVE_WCF_DIR in templates
[GitHub/WoltLab/WCF.git] / wcfsetup / setup / db / install.sql
CommitLineData
9f959ced 1/* tables */
158bd3ca
TD		 2DROP TABLE IF EXISTS wcf1_acp_menu_item;
3CREATE TABLE wcf1_acp_menu_item (
4 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
5 packageID INT(10) NOT NULL,
6 menuItem VARCHAR(255) NOT NULL DEFAULT '',
7 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
8 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
9 showOrder INT(10) NOT NULL DEFAULT 0,
10 permissions TEXT,
11 options TEXT,
12 UNIQUE KEY menuItem (menuItem, packageID)
13);
14
e9311b98
AE		 15DROP TABLE IF EXISTS wcf1_acp_search_provider;
16CREATE TABLE wcf1_acp_search_provider (
17 providerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
18 packageID INT(10) NOT NULL,
19 providerName VARCHAR(255) NOT NULL DEFAULT '',
20 className VARCHAR(255) NOT NULL DEFAULT '',
21 showOrder INT(10) NOT NULL DEFAULT 0,
22 UNIQUE KEY providerName (providerName, packageID)
23);
24
158bd3ca
TD		 25DROP TABLE IF EXISTS wcf1_acp_session;
26CREATE TABLE wcf1_acp_session (
27 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 28 userID INT(10),
29 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
30 userAgent VARCHAR(255) NOT NULL DEFAULT '',
31 lastActivityTime INT(10) NOT NULL DEFAULT 0,
32 requestURI VARCHAR(255) NOT NULL DEFAULT '',
33 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
7aa1a486 34 controller VARCHAR(255) NOT NULL DEFAULT '',
596e20e2
MW		 35 parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
36 parentObjectID INT(10) NOT NULL DEFAULT 0,
37 objectType VARCHAR(255) NOT NULL DEFAULT '',
38 objectID INT(10) NOT NULL DEFAULT 0,
0b30544a 39 sessionVariables MEDIUMTEXT
158bd3ca
TD		 40);
41
158bd3ca
TD		 42DROP TABLE IF EXISTS wcf1_acp_session_access_log;
43CREATE TABLE wcf1_acp_session_access_log (
44 sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
45 sessionLogID INT(10) NOT NULL,
158bd3ca
TD		 46 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
47 time INT(10) NOT NULL DEFAULT 0,
48 requestURI VARCHAR(255) NOT NULL DEFAULT '',
49 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
50 className VARCHAR(255) NOT NULL DEFAULT '',
51 KEY sessionLogID (sessionLogID)
52);
53
54DROP TABLE IF EXISTS wcf1_acp_session_log;
55CREATE TABLE wcf1_acp_session_log (
56 sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
57 sessionID CHAR(40) NOT NULL DEFAULT '',
58 userID INT(10),
59 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
60 hostname VARCHAR(255) NOT NULL DEFAULT '',
61 userAgent VARCHAR(255) NOT NULL DEFAULT '',
62 time INT(10) NOT NULL DEFAULT 0,
63 lastActivityTime INT(10) NOT NULL DEFAULT 0,
64 KEY sessionID (sessionID)
65);
66
67DROP TABLE IF EXISTS wcf1_acp_template;
68CREATE TABLE wcf1_acp_template (
69 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
70 packageID INT(10),
71 templateName VARCHAR(255) NOT NULL DEFAULT '',
72 UNIQUE KEY (packageID, templateName)
73);
74
75DROP TABLE IF EXISTS wcf1_application;
76CREATE TABLE wcf1_application (
77 packageID INT(10) NOT NULL PRIMARY KEY,
78 domainName VARCHAR(255) NOT NULL,
79 domainPath VARCHAR(255) NOT NULL DEFAULT '/',
668cf125 80 cookieDomain VARCHAR(255) NOT NULL,
de44b893 81 cookiePath VARCHAR(255) NOT NULL DEFAULT '/',
158bd3ca
TD		 82 isPrimary TINYINT(1) NOT NULL DEFAULT 0
83);
84
158bd3ca
TD		 85DROP TABLE IF EXISTS wcf1_cache_resource;
86CREATE TABLE wcf1_cache_resource (
87 cacheResource VARCHAR(255) NOT NULL PRIMARY KEY
88);
89
13d8b49b
MS		 90DROP TABLE IF EXISTS wcf1_category;
91CREATE TABLE wcf1_category (
92 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
93 objectTypeID INT(10) NOT NULL,
13d8b49b
MS		 94 parentCategoryID INT(10) NOT NULL,
95 title VARCHAR(255) NOT NULL,
96 description TEXT,
97 showOrder INT(10) NOT NULL,
98 time INT(10) NOT NULL,
99 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
045f075b 100 additionalData TEXT
13d8b49b
MS		 101);
102
158bd3ca
TD		 103DROP TABLE IF EXISTS wcf1_cleanup_listener;
104CREATE TABLE wcf1_cleanup_listener (
105 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
106 packageID INT(10) NOT NULL,
107 className VARCHAR(255) NOT NULL DEFAULT '',
108 objectType VARCHAR(255) NOT NULL DEFAULT '',
109 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
110 UNIQUE KEY (className, packageID)
111);
112
0a67f96c
MS		 113DROP TABLE IF EXISTS wcf1_cleanup_log;
114CREATE TABLE wcf1_cleanup_log (
115 packageID INT(10) NOT NULL DEFAULT 0,
116 objectType VARCHAR(255) NOT NULL DEFAULT '',
117 objectID INT(10) NOT NULL DEFAULT 0,
118 deleteTime INT(10) NOT NULL DEFAULT 0,
119 KEY objectType (objectType)
120);
121
0d6ea23f
AE		 122DROP TABLE IF EXISTS wcf1_clipboard_action;
123CREATE TABLE wcf1_clipboard_action (
124 actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
125 packageID INT(10) NOT NULL DEFAULT 0,
126 actionName VARCHAR(50) NOT NULL DEFAULT '',
127 actionClassName VARCHAR(200) NOT NULL DEFAULT '',
d6bfc90e 128 showOrder INT(10) NOT NULL DEFAULT 0,
656718fc 129 UNIQUE KEY actionName (packageID, actionName, actionClassName)
0d6ea23f
AE		 130);
131
132DROP TABLE IF EXISTS wcf1_clipboard_item;
133CREATE TABLE wcf1_clipboard_item (
25cf4d11 134 objectTypeID INT(10) NOT NULL DEFAULT 0,
0d6ea23f 135 userID INT(10) NOT NULL DEFAULT 0,
25cf4d11
AE		 136 objectID INT(10) NOT NULL DEFAULT 0,
137 UNIQUE KEY (objectTypeID, userID, objectID)
0d6ea23f
AE		 138);
139
140DROP TABLE IF EXISTS wcf1_clipboard_page;
141CREATE TABLE wcf1_clipboard_page (
142 pageClassName VARCHAR(80) NOT NULL DEFAULT '',
143 packageID INT(10) NOT NULL DEFAULT 0,
144 actionID INT(10) NOT NULL DEFAULT 0
145);
146
158bd3ca
TD		 147DROP TABLE IF EXISTS wcf1_core_object;
148CREATE TABLE wcf1_core_object (
149 objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
150 packageID INT(10) NOT NULL,
151 objectName VARCHAR(255) NOT NULL DEFAULT '',
152 UNIQUE KEY object (packageID, objectName)
153);
154
155DROP TABLE IF EXISTS wcf1_cronjob;
156CREATE TABLE wcf1_cronjob (
157 cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
158 className varchar(255) NOT NULL DEFAULT '',
159 packageID INT(10) NOT NULL,
160 description varchar(255) NOT NULL DEFAULT '',
161 startMinute varchar(255) NOT NULL DEFAULT '*',
162 startHour varchar(255) NOT NULL DEFAULT '*',
163 startDom varchar(255) NOT NULL DEFAULT '*',
164 startMonth varchar(255) NOT NULL DEFAULT '*',
165 startDow varchar(255) NOT NULL DEFAULT '*',
166 lastExec INT(10) NOT NULL DEFAULT 0,
167 nextExec INT(10) NOT NULL DEFAULT 0,
168 afterNextExec INT(10) NOT NULL DEFAULT 0,
c9117aad
MS		 169 active TINYINT(1) NOT NULL DEFAULT 1,
170 canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
171 canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
172 state TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 173 failCount TINYINT(1) NOT NULL DEFAULT 0
174);
175
176DROP TABLE IF EXISTS wcf1_cronjob_log;
177CREATE TABLE wcf1_cronjob_log (
178 cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
179 cronjobID INT(10) NOT NULL,
180 execTime INT(10) NOT NULL DEFAULT 0,
c9117aad 181 success TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 182 error TEXT
183);
184
185DROP TABLE IF EXISTS wcf1_event_listener;
186CREATE TABLE wcf1_event_listener (
187 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
188 packageID INT(10) NOT NULL,
7e6405f8 189 environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
158bd3ca
TD		 190 eventClassName VARCHAR(80) NOT NULL DEFAULT '',
191 eventName VARCHAR(50) NOT NULL DEFAULT '',
192 listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
193 inherit TINYINT(1) NOT NULL DEFAULT 0,
194 niceValue TINYINT(3) NOT NULL DEFAULT 0,
7e6405f8 195 UNIQUE KEY packageID (packageID, environment, eventClassName, eventName, listenerClassName)
158bd3ca
TD		 196);
197
198DROP TABLE IF EXISTS wcf1_language;
199CREATE TABLE wcf1_language (
200 languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
201 languageCode VARCHAR(20) NOT NULL DEFAULT '',
a74df36b 202 languageName VARCHAR(255) NOT NULL DEFAULT '',
6675b340 203 countryCode VARCHAR(10) NOT NULL DEFAULT '',
158bd3ca
TD		 204 isDefault TINYINT(1) NOT NULL DEFAULT 0,
205 hasContent TINYINT(1) NOT NULL DEFAULT 0,
206 UNIQUE KEY languageCode (languageCode)
207);
208
209DROP TABLE IF EXISTS wcf1_language_category;
210CREATE TABLE wcf1_language_category (
211 languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
212 languageCategory VARCHAR(255) NOT NULL DEFAULT '',
213 UNIQUE KEY languageCategory (languageCategory)
214);
215
216DROP TABLE IF EXISTS wcf1_language_item;
217CREATE TABLE wcf1_language_item (
218 languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
219 languageID INT(10) NOT NULL,
220 languageItem VARCHAR(255) NOT NULL DEFAULT '',
221 languageItemValue MEDIUMTEXT NOT NULL,
222 languageCustomItemValue MEDIUMTEXT,
223 languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
224 languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
225 languageCategoryID INT(10) NOT NULL,
226 packageID INT(10),
f1c1fc65 227 UNIQUE KEY languageItem (languageItem, languageID),
158bd3ca
TD		 228 KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
229);
230
231DROP TABLE IF EXISTS wcf1_language_server;
232CREATE TABLE wcf1_language_server (
233 languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
234 serverURL VARCHAR(255) NOT NULL DEFAULT '',
235 disabled TINYINT(1) NOT NULL DEFAULT 0
236);
237
3a2de7fd
AE		 238DROP TABLE IF EXISTS wcf1_modification_log;
239CREATE TABLE wcf1_modification_log (
240 logID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
241 objectTypeID INT(10) NOT NULL,
242 objectID INT(10) NOT NULL,
243 userID INT(10),
244 username VARCHAR(255) NOT NULL DEFAULT '',
245 time INT(10) NOT NULL DEFAULT 0,
246 action VARCHAR(80) NOT NULL,
247 additionalData MEDIUMTEXT
248);
249
7fcc7676
MW		 250DROP TABLE IF EXISTS wcf1_object_type;
251CREATE TABLE wcf1_object_type (
252 objectTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
253 definitionID INT(10) NOT NULL,
254 packageID INT(10) NOT NULL,
255 objectType VARCHAR(255) NOT NULL,
256 className VARCHAR(255) NOT NULL DEFAULT '',
257 additionalData MEDIUMTEXT,
258 UNIQUE KEY objectType (objectType, definitionID, packageID)
259);
260
261DROP TABLE IF EXISTS wcf1_object_type_definition;
262CREATE TABLE wcf1_object_type_definition (
263 definitionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
264 definitionName VARCHAR(255) NOT NULL,
265 packageID INT(10) NOT NULL,
266 interfaceName VARCHAR(255) NOT NULL DEFAULT '',
16bd0d85 267 categoryName VARCHAR(80) NOT NULL DEFAULT '',
7fcc7676
MW		 268 UNIQUE KEY definitionName (definitionName, packageID)
269);
270
158bd3ca
TD		 271DROP TABLE IF EXISTS wcf1_option;
272CREATE TABLE wcf1_option (
273 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
274 packageID INT(10) NOT NULL,
275 optionName VARCHAR(255) NOT NULL DEFAULT '',
276 categoryName VARCHAR(255) NOT NULL DEFAULT '',
277 optionType VARCHAR(255) NOT NULL DEFAULT '',
278 optionValue MEDIUMTEXT,
279 validationPattern TEXT,
280 selectOptions MEDIUMTEXT,
281 enableOptions MEDIUMTEXT,
282 showOrder INT(10) NOT NULL DEFAULT 0,
283 hidden TINYINT(1) NOT NULL DEFAULT 0,
284 permissions TEXT,
285 options TEXT,
cd6220f2 286 supportI18n TINYINT(1) NOT NULL DEFAULT 0,
6b45d041 287 requireI18n TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 288 additionalData MEDIUMTEXT,
289 UNIQUE KEY optionName (optionName, packageID)
290);
291
292DROP TABLE IF EXISTS wcf1_option_category;
293CREATE TABLE wcf1_option_category (
294 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
295 packageID INT(10) NOT NULL,
296 categoryName VARCHAR(255) NOT NULL DEFAULT '',
297 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
298 showOrder INT(10) NOT NULL DEFAULT 0,
299 permissions TEXT,
300 options TEXT,
301 UNIQUE KEY categoryName (categoryName, packageID)
302);
303
304DROP TABLE IF EXISTS wcf1_package;
305CREATE TABLE wcf1_package (
306 packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
307 package VARCHAR(255) NOT NULL DEFAULT '',
308 packageDir VARCHAR(255) NOT NULL DEFAULT '',
309 packageName VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 310 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
311 packageVersion VARCHAR(255) NOT NULL DEFAULT '',
312 packageDate INT(10) NOT NULL DEFAULT 0,
313 installDate INT(10) NOT NULL DEFAULT 0,
314 updateDate INT(10) NOT NULL DEFAULT 0,
315 packageURL VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca 316 isUnique TINYINT(1) NOT NULL DEFAULT 0,
aac1247e 317 isApplication TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 318 author VARCHAR(255) NOT NULL DEFAULT '',
319 authorURL VARCHAR(255) NOT NULL DEFAULT '',
180d226b 320 packageIcon VARCHAR(30) NOT NULL DEFAULT '',
158bd3ca
TD		 321 KEY package (package)
322);
323
158bd3ca
TD		 324DROP TABLE IF EXISTS wcf1_package_exclusion;
325CREATE TABLE wcf1_package_exclusion (
326 packageID INT(10) NOT NULL,
327 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
328 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
329 UNIQUE KEY packageID (packageID, excludedPackage)
330);
331
332DROP TABLE IF EXISTS wcf1_package_installation_file_log;
333CREATE TABLE wcf1_package_installation_file_log (
334 packageID INT(10),
335 filename VARCHAR(255) NOT NULL DEFAULT '',
336 UNIQUE KEY packageID (packageID, filename)
337);
338
339DROP TABLE IF EXISTS wcf1_package_installation_form;
340CREATE TABLE wcf1_package_installation_form (
341 queueID INT(10) NOT NULL,
342 formName VARCHAR(80) NOT NULL DEFAULT '',
343 document TEXT NOT NULL,
344 UNIQUE KEY formDocument (queueID, formName)
345);
346
347DROP TABLE IF EXISTS wcf1_package_installation_node;
348CREATE TABLE wcf1_package_installation_node (
349 queueID INT(10) NOT NULL,
350 processNo INT(10) NOT NULL DEFAULT 0,
351 sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
352 node CHAR(8) NOT NULL DEFAULT '',
353 parentNode CHAR(8) NOT NULL DEFAULT '',
456008db 354 nodeType ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
158bd3ca
TD		 355 nodeData TEXT NOT NULL,
356 done TINYINT(1) NOT NULL DEFAULT 0
357);
358
359DROP TABLE IF EXISTS wcf1_package_installation_plugin;
360CREATE TABLE wcf1_package_installation_plugin (
361 pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
362 packageID INT(10),
363 priority TINYINT(1) NOT NULL DEFAULT 0,
364 className VARCHAR(255) NOT NULL
365);
366
367DROP TABLE IF EXISTS wcf1_package_installation_queue;
368CREATE TABLE wcf1_package_installation_queue (
369 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
370 parentQueueID INT(10) NOT NULL DEFAULT 0,
371 processNo INT(10) NOT NULL DEFAULT 0,
372 userID INT(10) NOT NULL,
373 package VARCHAR(255) NOT NULL DEFAULT '',
374 packageName VARCHAR(255) NOT NULL DEFAULT '',
375 packageID INT(10),
376 archive VARCHAR(255) NOT NULL DEFAULT '',
377 action ENUM('install', 'update', 'uninstall', 'rollback') NOT NULL DEFAULT 'install',
378 cancelable TINYINT(1) NOT NULL DEFAULT 1,
379 done TINYINT(1) NOT NULL DEFAULT 0,
380 confirmInstallation TINYINT(1) NOT NULL DEFAULT 0,
381 packageType ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
382);
383
384DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
385CREATE TABLE wcf1_package_installation_sql_log (
386 packageID INT(10),
387 sqlTable VARCHAR(100) NOT NULL DEFAULT '',
388 sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
389 sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
390 UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
391);
392
393DROP TABLE IF EXISTS wcf1_package_requirement;
394CREATE TABLE wcf1_package_requirement (
395 packageID INT(10) NOT NULL,
396 requirement INT(10) NOT NULL,
397 UNIQUE KEY packageID (packageID, requirement)
398);
399
400DROP TABLE IF EXISTS wcf1_package_requirement_map;
401CREATE TABLE wcf1_package_requirement_map (
402 packageID INT(10) NOT NULL,
403 requirement INT(10) NOT NULL,
404 level INT(10) NOT NULL DEFAULT 0,
405 UNIQUE KEY packageID (packageID, requirement)
406);
407
408DROP TABLE IF EXISTS wcf1_package_update;
409CREATE TABLE wcf1_package_update (
410 packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
411 packageUpdateServerID INT(10) NOT NULL,
412 package VARCHAR(255) NOT NULL DEFAULT '',
413 packageName VARCHAR(255) NOT NULL DEFAULT '',
414 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
415 author VARCHAR(255) NOT NULL DEFAULT '',
416 authorURL VARCHAR(255) NOT NULL DEFAULT '',
aac1247e 417 isApplication TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 418 plugin VARCHAR(255) NOT NULL DEFAULT '',
419 UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
420);
421
422DROP TABLE IF EXISTS wcf1_package_update_exclusion;
423CREATE TABLE wcf1_package_update_exclusion (
424 packageUpdateVersionID INT(10) NOT NULL,
425 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
426 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
427 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
428);
429
430DROP TABLE IF EXISTS wcf1_package_update_fromversion;
431CREATE TABLE wcf1_package_update_fromversion (
432 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
433 fromversion VARCHAR(50) NOT NULL DEFAULT '',
434 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
435);
436
437DROP TABLE IF EXISTS wcf1_package_update_requirement;
438CREATE TABLE wcf1_package_update_requirement (
439 packageUpdateVersionID INT(10) NOT NULL,
440 package VARCHAR(255) NOT NULL DEFAULT '',
441 minversion VARCHAR(50) NOT NULL DEFAULT '',
442 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
443);
444
445DROP TABLE IF EXISTS wcf1_package_update_server;
446CREATE TABLE wcf1_package_update_server (
447 packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
448 serverURL VARCHAR(255) NOT NULL DEFAULT '',
449 loginUsername VARCHAR(255) NOT NULL DEFAULT '',
450 loginPassword VARCHAR(255) NOT NULL DEFAULT '',
451 disabled TINYINT(1) NOT NULL DEFAULT 0,
452 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
453 status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
454 errorMessage TEXT
455);
456
457DROP TABLE IF EXISTS wcf1_package_update_version;
458CREATE TABLE wcf1_package_update_version (
459 packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
460 packageUpdateID INT(10) NOT NULL,
461 packageVersion VARCHAR(50) NOT NULL DEFAULT '',
462 updateType VARCHAR(10) NOT NULL DEFAULT '',
463 packageDate INT(10) NOT NULL DEFAULT 0,
464 filename VARCHAR(255) NOT NULL DEFAULT '',
465 UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
466);
467
158bd3ca
TD		 468DROP TABLE IF EXISTS wcf1_page_menu_item;
469CREATE TABLE wcf1_page_menu_item (
470 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
471 packageID INT(10) NOT NULL,
472 menuItem VARCHAR(255) NOT NULL DEFAULT '',
473 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
474 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
475 menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
476 showOrder INT(10) NOT NULL DEFAULT 0,
477 permissions TEXT NULL,
478 options TEXT NULL,
479 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
480 className VARCHAR(255) NOT NULL DEFAULT '',
0b074a0c 481 isLandingPage TINYINT(1) NOT NULL DEFAULT 0,
9495a3b5 482 newWindow TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 483 UNIQUE KEY (packageID, menuItem)
484);
485
486DROP TABLE IF EXISTS wcf1_search;
487CREATE TABLE wcf1_search (
488 searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
489 userID INT(10),
490 searchData MEDIUMTEXT NOT NULL,
491 searchTime INT(10) NOT NULL DEFAULT 0,
492 searchType VARCHAR(255) NOT NULL DEFAULT '',
493 searchHash CHAR(40) NOT NULL DEFAULT '',
494 KEY searchHash (searchHash)
495);
496
497DROP TABLE IF EXISTS wcf1_session;
498CREATE TABLE wcf1_session (
499 sessionID CHAR(40) NOT NULL PRIMARY KEY,
158bd3ca
TD		 500 userID INT(10),
501 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
502 userAgent VARCHAR(255) NOT NULL DEFAULT '',
503 lastActivityTime INT(10) NOT NULL DEFAULT 0,
504 requestURI VARCHAR(255) NOT NULL DEFAULT '',
505 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
7aa1a486 506 controller VARCHAR(255) NOT NULL DEFAULT '',
596e20e2
MW		 507 parentObjectType VARCHAR(255) NOT NULL DEFAULT '',
508 parentObjectID INT(10) NOT NULL DEFAULT 0,
509 objectType VARCHAR(255) NOT NULL DEFAULT '',
510 objectID INT(10) NOT NULL DEFAULT 0,
75cf36c3 511 sessionVariables MEDIUMTEXT,
158bd3ca 512 spiderID INT(10) NOT NULL DEFAULT 0,
0b30544a 513 KEY packageID (lastActivityTime, spiderID)
158bd3ca
TD		 514);
515
46bd110b
AE		 516DROP TABLE IF EXISTS wcf1_sitemap;
517CREATE TABLE wcf1_sitemap (
518 sitemapID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
519 packageID INT(10) NOT NULL,
520 sitemapName VARCHAR(80) NOT NULL DEFAULT '',
521 className VARCHAR(255) NOT NULL DEFAULT '',
68541bb5 522 showOrder INT(10) NOT NULL DEFAULT 0,
46bd110b
AE		 523 UNIQUE KEY sitemapName (packageID, sitemapName)
524);
525
158bd3ca
TD		 526DROP TABLE IF EXISTS wcf1_spider;
527CREATE TABLE wcf1_spider (
528 spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
529 spiderIdentifier VARCHAR(255) DEFAULT '',
530 spiderName VARCHAR(255) DEFAULT '',
531 spiderURL VARCHAR(255) DEFAULT '',
532 UNIQUE KEY spiderIdentifier (spiderIdentifier)
533);
534
535DROP TABLE IF EXISTS wcf1_style;
536CREATE TABLE wcf1_style (
537 styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
538 packageID INT(10) NOT NULL,
539 styleName VARCHAR(255) NOT NULL DEFAULT '',
540 templateGroupID INT(10) NOT NULL DEFAULT 0,
541 isDefault TINYINT(1) NOT NULL DEFAULT 0,
542 disabled TINYINT(1) NOT NULL DEFAULT 0,
543 styleDescription TEXT,
544 styleVersion VARCHAR(255) NOT NULL DEFAULT '',
545 styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
546 image VARCHAR(255) NOT NULL DEFAULT '',
547 copyright VARCHAR(255) NOT NULL DEFAULT '',
548 license VARCHAR(255) NOT NULL DEFAULT '',
549 authorName VARCHAR(255) NOT NULL DEFAULT '',
fa83e8f7
AE		 550 authorURL VARCHAR(255) NOT NULL DEFAULT '',
551 iconPath VARCHAR(255) NOT NULL DEFAULT '',
ee013cde 552 imagePath VARCHAR(255) NOT NULL DEFAULT ''
158bd3ca
TD		 553);
554
158bd3ca
TD		 555DROP TABLE IF EXISTS wcf1_style_variable;
556CREATE TABLE wcf1_style_variable (
4d9f6058
AE		 557 variableID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
558 variableName VARCHAR(50) NOT NULL,
559 defaultValue MEDIUMTEXT,
560 UNIQUE KEY variableName (variableName)
158bd3ca
TD		 561);
562
4d9f6058
AE		 563DROP TABLE IF EXISTS wcf1_style_variable_value;
564CREATE TABLE wcf1_style_variable_value (
158bd3ca 565 styleID INT(10) NOT NULL,
4d9f6058 566 variableID INT(10) NOT NULL,
158bd3ca 567 variableValue MEDIUMTEXT,
4d9f6058 568 UNIQUE KEY (styleID, variableID)
158bd3ca
TD		 569);
570
571DROP TABLE IF EXISTS wcf1_template;
572CREATE TABLE wcf1_template (
573 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
574 packageID INT(10) NOT NULL,
575 templateName VARCHAR(255) NOT NULL DEFAULT '',
576 templateGroupID INT(10),
577 obsolete TINYINT(1) NOT NULL DEFAULT 0,
578 KEY packageID (packageID, templateName),
579 KEY templateGroupID (packageID, templateGroupID, templateName)
580);
581
582DROP TABLE IF EXISTS wcf1_template_group;
583CREATE TABLE wcf1_template_group (
584 templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
585 parentTemplateGroupID INT(10) NOT NULL DEFAULT 0,
586 templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
587 templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
588);
589
0a67f96c
MS		 590DROP TABLE IF EXISTS wcf1_template_listener;
591CREATE TABLE wcf1_template_listener (
592 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
593 packageID INT(10) NOT NULL,
594 name VARCHAR(80) NOT NULL DEFAULT '',
595 environment ENUM('user','admin') NOT NULL DEFAULT 'user',
596 templateName VARCHAR(80) NOT NULL DEFAULT '',
597 eventName VARCHAR(50) NOT NULL DEFAULT '',
598 templateCode TEXT NOT NULL,
599 KEY templateName (environment, templateName)
600);
601
158bd3ca
TD		 602DROP TABLE IF EXISTS wcf1_user;
603CREATE TABLE wcf1_user (
604 userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
605 username VARCHAR(255) NOT NULL DEFAULT '',
606 email VARCHAR(255) NOT NULL DEFAULT '',
607 password VARCHAR(40) NOT NULL DEFAULT '',
608 salt VARCHAR(40) NOT NULL DEFAULT '',
6a41a21e 609 accessToken CHAR(40) NOT NULL DEFAULT '',
158bd3ca
TD		 610 languageID INT(10) NOT NULL DEFAULT 0,
611 registrationDate INT(10) NOT NULL DEFAULT 0,
612 styleID INT(10) NOT NULL DEFAULT 0,
613
614 KEY username (username),
615 KEY registrationDate (registrationDate),
616 KEY styleID (styleID)
617);
618
a8e8aa21
AE		 619DROP TABLE IF EXISTS wcf1_user_collapsible_content;
620CREATE TABLE wcf1_user_collapsible_content (
621 objectTypeID INT(10) NOT NULL,
44105eda 622 objectID VARCHAR(50) NOT NULL,
a8e8aa21
AE		 623 userID INT(10) NOT NULL,
624 UNIQUE KEY (objectTypeID, objectID, userID)
625);
626
158bd3ca
TD		 627DROP TABLE IF EXISTS wcf1_user_group;
628CREATE TABLE wcf1_user_group (
629 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
630 groupName VARCHAR(255) NOT NULL DEFAULT '',
c6187fd3 631 groupType TINYINT(1) NOT NULL DEFAULT 4
158bd3ca
TD		 632);
633
634DROP TABLE IF EXISTS wcf1_user_group_option;
01bd2eff 635CREATE TABLE wcf1_user_group_option (
158bd3ca
TD		 636 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
637 packageID INT(10),
638 optionName VARCHAR(255) NOT NULL DEFAULT '',
639 categoryName VARCHAR(255) NOT NULL DEFAULT '',
640 optionType VARCHAR(255) NOT NULL DEFAULT '',
641 defaultValue MEDIUMTEXT,
642 adminDefaultValue MEDIUMTEXT,
643 validationPattern TEXT,
644 enableOptions MEDIUMTEXT,
645 showOrder INT(10) NOT NULL DEFAULT 0,
646 permissions TEXT,
647 options TEXT,
648 additionalData MEDIUMTEXT,
649 UNIQUE KEY optionName (optionName, packageID)
650);
651
652DROP TABLE IF EXISTS wcf1_user_group_option_category;
653CREATE TABLE wcf1_user_group_option_category (
654 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
655 packageID INT(10) NOT NULL,
656 categoryName VARCHAR(255) NOT NULL DEFAULT '',
657 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
658 showOrder INT(10) NOT NULL DEFAULT 0,
659 permissions TEXT,
660 options TEXT,
661 UNIQUE KEY categoryName (categoryName, packageID)
662);
663
664DROP TABLE IF EXISTS wcf1_user_group_option_value;
01bd2eff 665CREATE TABLE wcf1_user_group_option_value (
158bd3ca
TD		 666 groupID INT(10) NOT NULL,
667 optionID INT(10) NOT NULL,
668 optionValue MEDIUMTEXT NOT NULL,
669 UNIQUE KEY groupID (groupID, optionID)
670);
671
672DROP TABLE IF EXISTS wcf1_user_option;
673CREATE TABLE wcf1_user_option (
674 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
675 packageID INT(10) NOT NULL,
676 optionName VARCHAR(255) NOT NULL DEFAULT '',
677 categoryName VARCHAR(255) NOT NULL DEFAULT '',
678 optionType VARCHAR(255) NOT NULL DEFAULT '',
679 defaultValue MEDIUMTEXT,
680 validationPattern TEXT,
681 selectOptions MEDIUMTEXT,
682 enableOptions MEDIUMTEXT,
683 required TINYINT(1) NOT NULL DEFAULT 0,
684 askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
685 editable TINYINT(1) NOT NULL DEFAULT 0,
686 visible TINYINT(1) NOT NULL DEFAULT 0,
687 outputClass VARCHAR(255) NOT NULL DEFAULT '',
688 searchable TINYINT(1) NOT NULL DEFAULT 0,
689 showOrder INT(10) NOT NULL DEFAULT 0,
690 disabled TINYINT(1) NOT NULL DEFAULT 0,
691 permissions TEXT,
692 options TEXT,
693 additionalData MEDIUMTEXT,
694 UNIQUE KEY optionName (optionName, packageID),
695 KEY categoryName (categoryName)
696);
697
698DROP TABLE IF EXISTS wcf1_user_option_category;
699CREATE TABLE wcf1_user_option_category (
700 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
701 packageID INT(10) NOT NULL,
702 categoryName VARCHAR(255) NOT NULL DEFAULT '',
158bd3ca
TD		 703 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
704 showOrder INT(10) NOT NULL DEFAULT 0,
705 permissions TEXT,
706 options TEXT,
707 UNIQUE KEY categoryName (categoryName, packageID)
708);
709
710DROP TABLE IF EXISTS wcf1_user_option_value;
711CREATE TABLE wcf1_user_option_value (
712 userID INT(10) NOT NULL PRIMARY KEY
713);
714
0a67f96c
MS		 715DROP TABLE IF EXISTS wcf1_user_storage;
716CREATE TABLE wcf1_user_storage (
717 userID INT(10) NOT NULL,
718 field VARCHAR(80) NOT NULL DEFAULT '',
719 fieldValue TEXT,
0b30544a 720 UNIQUE KEY userStorageData (userID, field)
0a67f96c
MS		 721);
722
158bd3ca
TD		 723DROP TABLE IF EXISTS wcf1_user_to_group;
724CREATE TABLE wcf1_user_to_group (
725 userID INT(10) NOT NULL,
726 groupID INT(10) NOT NULL,
727 UNIQUE KEY userID (userID, groupID)
728);
729
730DROP TABLE IF EXISTS wcf1_user_to_language;
731CREATE TABLE wcf1_user_to_language (
732 userID INT(10) NOT NULL,
733 languageID INT(10) NOT NULL,
734 UNIQUE KEY userID (userID, languageID)
735);
736
9f959ced 737/* foreign keys */
158bd3ca
TD		 738ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
739
e9311b98
AE		 740ALTER TABLE wcf1_acp_search_provider ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
741
158bd3ca 742ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 743
744ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
158bd3ca 745
158bd3ca
TD		 746ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
747
748ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
749
750ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
158bd3ca 751
13d8b49b
MS		 752ALTER TABLE wcf1_category ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
753
158bd3ca
TD		 754ALTER TABLE wcf1_cleanup_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
755
756ALTER TABLE wcf1_cleanup_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
757
0e6741f8
AE		 758ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
759
25cf4d11 760ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
0e6741f8
AE		 761
762ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
763ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
764
158bd3ca
TD		 765ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
766
767ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
768
769ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
770
771ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
772
773ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
774ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
775ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
776
3a2de7fd
AE		 777ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
778ALTER TABLE wcf1_modification_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
779
7fcc7676
MW		 780ALTER TABLE wcf1_object_type ADD FOREIGN KEY (definitionID) REFERENCES wcf1_object_type_definition (definitionID) ON DELETE CASCADE;
781ALTER TABLE wcf1_object_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
782
783ALTER TABLE wcf1_object_type_definition ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
784
158bd3ca
TD		 785ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
786
787ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
788
158bd3ca
TD		 789ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
790
791ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
792
793ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
794
795ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
796
797ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
798
799ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
800ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
801
802ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
803
804ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
805ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
806
807ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
808ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
809
810ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
811
812ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
813
814ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
815
816ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
817
818ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
819
158bd3ca
TD		 820ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
821
822ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
823
158bd3ca
TD		 824ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
825
46bd110b
AE		 826ALTER TABLE wcf1_sitemap ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
827
461a69ea 828ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
158bd3ca
TD		 829
830ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
831
4d9f6058
AE		 832ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
833ALTER TABLE wcf1_style_variable_value ADD FOREIGN KEY (variableID) REFERENCES wcf1_style_variable (variableID) ON DELETE CASCADE;
158bd3ca
TD		 834
835ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
836ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
837
838ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
839
a8e8aa21
AE		 840ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (objectTypeID) REFERENCES wcf1_object_type (objectTypeID) ON DELETE CASCADE;
841ALTER TABLE wcf1_user_collapsible_content ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
842
158bd3ca
TD		 843ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
844
845ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
846
847ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
848ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
849
850ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
851
852ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
853
854ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
855
856ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
857ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
858
859ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
860ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
861
9f959ced 862/* default inserts */
158bd3ca 863-- default user groups
18c05238
MS		 864INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group1', 1);
865INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group2', 2);
866INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group3', 3);
867INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group4', 4);
868INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group5', 4);
869INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('wcf.acp.group.group6', 4);
47459aed 870
158bd3ca
TD		 871-- default user group options
872INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
873INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
874INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
875
876-- default user group option values
877INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone
878INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone
879INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone
880INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators
881INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators
882INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators
47459aed 883
158bd3ca 884-- default update servers
158bd3ca 885INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
158bd3ca 886INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
4d9f6058
AE		 887
888-- style default values
baa4743d
AE		 889INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
890INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
891INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
892INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
893INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
894INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
895INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
896INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
cdb161b9 897INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfContainerBorderRadius', '0');
baa4743d
AE		 898INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
899INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
900INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
901INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
902INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
903INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
904INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
905INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
906INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
90a67f4f
MW		 907INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
908INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
baa4743d 909INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
90a67f4f
MW		 910INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
911INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
912INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
91143353
MW		 913INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
914INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
cdb161b9 915INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
baa4743d
AE		 916INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
917INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
918INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
f9788d30
K		 919INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
920INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
4d9f6058
AE		 921INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontSize', '13px');
922INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
8b9077a6 923INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFluidGap', '30px');
4d9f6058 924INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLayoutFixedWidth', '1200px');
baa4743d
AE		 925INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
926INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
927INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
928INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
cdb161b9 929INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
90a67f4f 930INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
cdb161b9
MW		 931INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfLabelColor', '@wcfColor');
932INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineColor', '@wcfColor');
baa4743d 933INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
cdb161b9
MW		 934INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
935INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownColor', '@wcfColor');
936INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
937INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
fdfb7df4 938INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfBaseLineHeight', '1.27');
4d9f6058
AE		 939INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfHeadlineFontSize', '170%');
940INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSubHeadlineFontSize', '140%');
941INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTitleFontSize', '120%');
942INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSmallFontSize', '85%');
90a67f4f
MW		 943INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
944INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
945INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
946INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
947INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
948INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
949INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
950INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
951INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
952INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
953INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
954INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
4d9f6058 955INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
baa4743d 956INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
4d9f6058
AE		 957INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapTiny', '4px');
958INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapSmall', '7px');
959INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapMedium', '14px');
960INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfGapLarge', '21px');
cdb161b9
MW		 961INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
962INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
963INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
964INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
965INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuColor', '@wcfColor');
966INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
baa4743d 967INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
baa4743d 968INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('wcfMarkedBackgroundColor', 'rgba(255, 255, 200, 1)');
ee013cde 969INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('useFluidLayout', '1');
160bfe44 970INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogo', '');
fc5e2dab
AE		 971INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoHeight', 'auto');
972INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('pageLogoWidth', 'auto');
160bfe44
AE		 973INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('individualLess', '');
974INSERT INTO wcf1_style_variable (variableName, defaultValue) VALUES ('overrideLess', '');
WoltLab Suite Core (previously WoltLab Community Framework)