projects / GitHub / WoltLab / WCF.git / blame
? search:
summary | shortlog | log | commit | commitdiff | tree
blob | blame (incremental) | history | HEAD
Modifyed Buttons, disabled elements, tables
[GitHub/WoltLab/WCF.git] / wcfsetup / setup / db / install.sql
CommitLineData
158bd3ca
TD		 1/**** tables ****/
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
15DROP TABLE IF EXISTS wcf1_acp_session;
16CREATE TABLE wcf1_acp_session (
17 sessionID CHAR(40) NOT NULL PRIMARY KEY,
18 packageID INT(10),
19 userID INT(10),
20 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
21 userAgent VARCHAR(255) NOT NULL DEFAULT '',
22 lastActivityTime INT(10) NOT NULL DEFAULT 0,
23 requestURI VARCHAR(255) NOT NULL DEFAULT '',
24 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
25 username VARCHAR(255) NOT NULL DEFAULT '',
26 KEY sessionID (sessionID, packageID)
27);
28
29DROP TABLE IF EXISTS wcf1_acp_session_data;
30CREATE TABLE wcf1_acp_session_data (
31 sessionID CHAR(40) NOT NULL PRIMARY KEY,
32 sessionVariables MEDIUMTEXT
33);
34
35DROP TABLE IF EXISTS wcf1_acp_session_access_log;
36CREATE TABLE wcf1_acp_session_access_log (
37 sessionAccessLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
38 sessionLogID INT(10) NOT NULL,
39 packageID INT(10),
40 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
41 time INT(10) NOT NULL DEFAULT 0,
42 requestURI VARCHAR(255) NOT NULL DEFAULT '',
43 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
44 className VARCHAR(255) NOT NULL DEFAULT '',
45 KEY sessionLogID (sessionLogID)
46);
47
48DROP TABLE IF EXISTS wcf1_acp_session_log;
49CREATE TABLE wcf1_acp_session_log (
50 sessionLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
51 sessionID CHAR(40) NOT NULL DEFAULT '',
52 userID INT(10),
53 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
54 hostname VARCHAR(255) NOT NULL DEFAULT '',
55 userAgent VARCHAR(255) NOT NULL DEFAULT '',
56 time INT(10) NOT NULL DEFAULT 0,
57 lastActivityTime INT(10) NOT NULL DEFAULT 0,
58 KEY sessionID (sessionID)
59);
60
61DROP TABLE IF EXISTS wcf1_acp_template;
62CREATE TABLE wcf1_acp_template (
63 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
64 packageID INT(10),
65 templateName VARCHAR(255) NOT NULL DEFAULT '',
66 UNIQUE KEY (packageID, templateName)
67);
68
69DROP TABLE IF EXISTS wcf1_application;
70CREATE TABLE wcf1_application (
71 packageID INT(10) NOT NULL PRIMARY KEY,
72 domainName VARCHAR(255) NOT NULL,
73 domainPath VARCHAR(255) NOT NULL DEFAULT '/',
74 groupID INT(10),
75 isPrimary TINYINT(1) NOT NULL DEFAULT 0
76);
77
78DROP TABLE IF EXISTS wcf1_application_group;
79CREATE TABLE wcf1_application_group (
80 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
81 groupName VARCHAR(255) NOT NULL
82);
83
84DROP TABLE IF EXISTS wcf1_cache_resource;
85CREATE TABLE wcf1_cache_resource (
86 cacheResource VARCHAR(255) NOT NULL PRIMARY KEY
87);
88
89DROP TABLE IF EXISTS wcf1_cleanup_listener;
90CREATE TABLE wcf1_cleanup_listener (
91 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
92 packageID INT(10) NOT NULL,
93 className VARCHAR(255) NOT NULL DEFAULT '',
94 objectType VARCHAR(255) NOT NULL DEFAULT '',
95 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
96 UNIQUE KEY (className, packageID)
97);
98
0d6ea23f
AE		 99DROP TABLE IF EXISTS wcf1_clipboard_action;
100CREATE TABLE wcf1_clipboard_action (
101 actionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
102 packageID INT(10) NOT NULL DEFAULT 0,
103 actionName VARCHAR(50) NOT NULL DEFAULT '',
104 actionClassName VARCHAR(200) NOT NULL DEFAULT '',
d6bfc90e 105 showOrder INT(10) NOT NULL DEFAULT 0,
0e6741f8 106 UNIQUE KEY actionName (packageID, actionName)
0d6ea23f
AE		 107);
108
109DROP TABLE IF EXISTS wcf1_clipboard_item;
110CREATE TABLE wcf1_clipboard_item (
111 typeID INT(10) NOT NULL DEFAULT 0,
112 userID INT(10) NOT NULL DEFAULT 0,
113 objectID INT(10) NOT NULL DEFAULT 0
114);
115
116DROP TABLE IF EXISTS wcf1_clipboard_item_type;
117CREATE TABLE wcf1_clipboard_item_type (
118 typeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
119 packageID INT(10) NOT NULL DEFAULT 0,
120 typeName VARCHAR(80) NOT NULL DEFAULT '',
0e6741f8
AE		 121 listClassName VARCHAR(200) NOT NULL DEFAULT '',
122 UNIQUE KEY typeName (typeName)
0d6ea23f
AE		 123);
124
125DROP TABLE IF EXISTS wcf1_clipboard_page;
126CREATE TABLE wcf1_clipboard_page (
127 pageClassName VARCHAR(80) NOT NULL DEFAULT '',
128 packageID INT(10) NOT NULL DEFAULT 0,
129 actionID INT(10) NOT NULL DEFAULT 0
130);
131
158bd3ca
TD		 132DROP TABLE IF EXISTS wcf1_cleanup_log;
133CREATE TABLE wcf1_cleanup_log (
134 packageID INT(10) NOT NULL DEFAULT 0,
135 objectType VARCHAR(255) NOT NULL DEFAULT '',
136 objectID INT(10) NOT NULL DEFAULT 0,
137 deleteTime INT(10) NOT NULL DEFAULT 0,
138 KEY objectType (objectType)
139);
140
141DROP TABLE IF EXISTS wcf1_core_object;
142CREATE TABLE wcf1_core_object (
143 objectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
144 packageID INT(10) NOT NULL,
145 objectName VARCHAR(255) NOT NULL DEFAULT '',
146 UNIQUE KEY object (packageID, objectName)
147);
148
149DROP TABLE IF EXISTS wcf1_cronjob;
150CREATE TABLE wcf1_cronjob (
151 cronjobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
152 className varchar(255) NOT NULL DEFAULT '',
153 packageID INT(10) NOT NULL,
154 description varchar(255) NOT NULL DEFAULT '',
155 startMinute varchar(255) NOT NULL DEFAULT '*',
156 startHour varchar(255) NOT NULL DEFAULT '*',
157 startDom varchar(255) NOT NULL DEFAULT '*',
158 startMonth varchar(255) NOT NULL DEFAULT '*',
159 startDow varchar(255) NOT NULL DEFAULT '*',
160 lastExec INT(10) NOT NULL DEFAULT 0,
161 nextExec INT(10) NOT NULL DEFAULT 0,
162 afterNextExec INT(10) NOT NULL DEFAULT 0,
c9117aad
MS		 163 active TINYINT(1) NOT NULL DEFAULT 1,
164 canBeEdited TINYINT(1) NOT NULL DEFAULT 1,
165 canBeDisabled TINYINT(1) NOT NULL DEFAULT 1,
166 state TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 167 failCount TINYINT(1) NOT NULL DEFAULT 0
168);
169
170DROP TABLE IF EXISTS wcf1_cronjob_log;
171CREATE TABLE wcf1_cronjob_log (
172 cronjobLogID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
173 cronjobID INT(10) NOT NULL,
174 execTime INT(10) NOT NULL DEFAULT 0,
c9117aad 175 success TINYINT(1) NOT NULL DEFAULT 0,
158bd3ca
TD		 176 error TEXT
177);
178
179DROP TABLE IF EXISTS wcf1_event_listener;
180CREATE TABLE wcf1_event_listener (
181 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
182 packageID INT(10) NOT NULL,
183 eventClassName VARCHAR(80) NOT NULL DEFAULT '',
184 eventName VARCHAR(50) NOT NULL DEFAULT '',
185 listenerClassName VARCHAR(200) NOT NULL DEFAULT '',
186 inherit TINYINT(1) NOT NULL DEFAULT 0,
187 niceValue TINYINT(3) NOT NULL DEFAULT 0,
188 UNIQUE KEY packageID (packageID, eventClassName, eventName, listenerClassName)
189);
190
191DROP TABLE IF EXISTS wcf1_language;
192CREATE TABLE wcf1_language (
193 languageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
194 languageCode VARCHAR(20) NOT NULL DEFAULT '',
195 isDefault TINYINT(1) NOT NULL DEFAULT 0,
196 hasContent TINYINT(1) NOT NULL DEFAULT 0,
197 UNIQUE KEY languageCode (languageCode)
198);
199
200DROP TABLE IF EXISTS wcf1_language_category;
201CREATE TABLE wcf1_language_category (
202 languageCategoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
203 languageCategory VARCHAR(255) NOT NULL DEFAULT '',
204 UNIQUE KEY languageCategory (languageCategory)
205);
206
207DROP TABLE IF EXISTS wcf1_language_item;
208CREATE TABLE wcf1_language_item (
209 languageItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
210 languageID INT(10) NOT NULL,
211 languageItem VARCHAR(255) NOT NULL DEFAULT '',
212 languageItemValue MEDIUMTEXT NOT NULL,
213 languageCustomItemValue MEDIUMTEXT,
214 languageUseCustomValue TINYINT(1) NOT NULL DEFAULT 0,
215 languageItemOriginIsSystem TINYINT(1) NOT NULL DEFAULT 1,
216 languageCategoryID INT(10) NOT NULL,
217 packageID INT(10),
218 UNIQUE KEY languageItem (languageItem, packageID, languageID),
219 KEY languageItemOriginIsSystem (languageItemOriginIsSystem)
220);
221
222DROP TABLE IF EXISTS wcf1_language_server;
223CREATE TABLE wcf1_language_server (
224 languageServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
225 serverURL VARCHAR(255) NOT NULL DEFAULT '',
226 disabled TINYINT(1) NOT NULL DEFAULT 0
227);
228
229DROP TABLE IF EXISTS wcf1_language_to_package;
230CREATE TABLE wcf1_language_to_package (
231 languageID INT(10) NOT NULL,
232 packageID INT(10),
233 UNIQUE KEY languageID (languageID, packageID)
234);
235
236DROP TABLE IF EXISTS wcf1_option;
237CREATE TABLE wcf1_option (
238 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
239 packageID INT(10) NOT NULL,
240 optionName VARCHAR(255) NOT NULL DEFAULT '',
241 categoryName VARCHAR(255) NOT NULL DEFAULT '',
242 optionType VARCHAR(255) NOT NULL DEFAULT '',
243 optionValue MEDIUMTEXT,
244 validationPattern TEXT,
245 selectOptions MEDIUMTEXT,
246 enableOptions MEDIUMTEXT,
247 showOrder INT(10) NOT NULL DEFAULT 0,
248 hidden TINYINT(1) NOT NULL DEFAULT 0,
249 permissions TEXT,
250 options TEXT,
251 additionalData MEDIUMTEXT,
252 UNIQUE KEY optionName (optionName, packageID)
253);
254
255DROP TABLE IF EXISTS wcf1_option_category;
256CREATE TABLE wcf1_option_category (
257 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
258 packageID INT(10) NOT NULL,
259 categoryName VARCHAR(255) NOT NULL DEFAULT '',
260 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
261 showOrder INT(10) NOT NULL DEFAULT 0,
262 permissions TEXT,
263 options TEXT,
264 UNIQUE KEY categoryName (categoryName, packageID)
265);
266
267DROP TABLE IF EXISTS wcf1_package;
268CREATE TABLE wcf1_package (
269 packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
270 package VARCHAR(255) NOT NULL DEFAULT '',
271 packageDir VARCHAR(255) NOT NULL DEFAULT '',
272 packageName VARCHAR(255) NOT NULL DEFAULT '',
273 instanceName VARCHAR(255) NOT NULL DEFAULT '',
274 instanceNo INT(10) NOT NULL DEFAULT 1,
275 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
276 packageVersion VARCHAR(255) NOT NULL DEFAULT '',
277 packageDate INT(10) NOT NULL DEFAULT 0,
278 installDate INT(10) NOT NULL DEFAULT 0,
279 updateDate INT(10) NOT NULL DEFAULT 0,
280 packageURL VARCHAR(255) NOT NULL DEFAULT '',
281 parentPackageID INT(10) NOT NULL DEFAULT 0,
282 isUnique TINYINT(1) NOT NULL DEFAULT 0,
283 standalone TINYINT(1) NOT NULL DEFAULT 0,
284 author VARCHAR(255) NOT NULL DEFAULT '',
285 authorURL VARCHAR(255) NOT NULL DEFAULT '',
286 KEY package (package)
287);
288
289DROP TABLE IF EXISTS wcf1_package_dependency;
290CREATE TABLE wcf1_package_dependency (
291 packageID INT(10) NOT NULL,
292 dependency INT(10) NOT NULL,
293 priority INT(10) NOT NULL DEFAULT 0,
294 UNIQUE KEY packageID (packageID, dependency)
295);
296
297DROP TABLE IF EXISTS wcf1_package_exclusion;
298CREATE TABLE wcf1_package_exclusion (
299 packageID INT(10) NOT NULL,
300 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
301 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
302 UNIQUE KEY packageID (packageID, excludedPackage)
303);
304
305DROP TABLE IF EXISTS wcf1_package_installation_file_log;
306CREATE TABLE wcf1_package_installation_file_log (
307 packageID INT(10),
308 filename VARCHAR(255) NOT NULL DEFAULT '',
309 UNIQUE KEY packageID (packageID, filename)
310);
311
312DROP TABLE IF EXISTS wcf1_package_installation_form;
313CREATE TABLE wcf1_package_installation_form (
314 queueID INT(10) NOT NULL,
315 formName VARCHAR(80) NOT NULL DEFAULT '',
316 document TEXT NOT NULL,
317 UNIQUE KEY formDocument (queueID, formName)
318);
319
320DROP TABLE IF EXISTS wcf1_package_installation_node;
321CREATE TABLE wcf1_package_installation_node (
322 queueID INT(10) NOT NULL,
323 processNo INT(10) NOT NULL DEFAULT 0,
324 sequenceNo SMALLINT(4) NOT NULL DEFAULT 0,
325 node CHAR(8) NOT NULL DEFAULT '',
326 parentNode CHAR(8) NOT NULL DEFAULT '',
327 nodeType ENUM('package', 'pip') NOT NULL DEFAULT 'package',
328 nodeData TEXT NOT NULL,
329 done TINYINT(1) NOT NULL DEFAULT 0
330);
331
332DROP TABLE IF EXISTS wcf1_package_installation_plugin;
333CREATE TABLE wcf1_package_installation_plugin (
334 pluginName VARCHAR(255) NOT NULL PRIMARY KEY,
335 packageID INT(10),
336 priority TINYINT(1) NOT NULL DEFAULT 0,
337 className VARCHAR(255) NOT NULL
338);
339
340DROP TABLE IF EXISTS wcf1_package_installation_queue;
341CREATE TABLE wcf1_package_installation_queue (
342 queueID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
343 parentQueueID INT(10) NOT NULL DEFAULT 0,
344 processNo INT(10) NOT NULL DEFAULT 0,
345 userID INT(10) NOT NULL,
346 package VARCHAR(255) NOT NULL DEFAULT '',
347 packageName VARCHAR(255) NOT NULL DEFAULT '',
348 packageID INT(10),
349 archive VARCHAR(255) NOT NULL DEFAULT '',
350 action ENUM('install', 'update', 'uninstall', 'rollback') NOT NULL DEFAULT 'install',
351 cancelable TINYINT(1) NOT NULL DEFAULT 1,
352 done TINYINT(1) NOT NULL DEFAULT 0,
353 confirmInstallation TINYINT(1) NOT NULL DEFAULT 0,
354 packageType ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
355);
356
357DROP TABLE IF EXISTS wcf1_package_installation_sql_log;
358CREATE TABLE wcf1_package_installation_sql_log (
359 packageID INT(10),
360 sqlTable VARCHAR(100) NOT NULL DEFAULT '',
361 sqlColumn VARCHAR(100) NOT NULL DEFAULT '',
362 sqlIndex VARCHAR(100) NOT NULL DEFAULT '',
363 UNIQUE KEY packageID (packageID, sqlTable, sqlColumn, sqlIndex)
364);
365
366DROP TABLE IF EXISTS wcf1_package_requirement;
367CREATE TABLE wcf1_package_requirement (
368 packageID INT(10) NOT NULL,
369 requirement INT(10) NOT NULL,
370 UNIQUE KEY packageID (packageID, requirement)
371);
372
373DROP TABLE IF EXISTS wcf1_package_requirement_map;
374CREATE TABLE wcf1_package_requirement_map (
375 packageID INT(10) NOT NULL,
376 requirement INT(10) NOT NULL,
377 level INT(10) NOT NULL DEFAULT 0,
378 UNIQUE KEY packageID (packageID, requirement)
379);
380
381DROP TABLE IF EXISTS wcf1_package_update;
382CREATE TABLE wcf1_package_update (
383 packageUpdateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
384 packageUpdateServerID INT(10) NOT NULL,
385 package VARCHAR(255) NOT NULL DEFAULT '',
386 packageName VARCHAR(255) NOT NULL DEFAULT '',
387 packageDescription VARCHAR(255) NOT NULL DEFAULT '',
388 author VARCHAR(255) NOT NULL DEFAULT '',
389 authorURL VARCHAR(255) NOT NULL DEFAULT '',
390 standalone TINYINT(1) NOT NULL DEFAULT 0,
391 plugin VARCHAR(255) NOT NULL DEFAULT '',
392 UNIQUE KEY packageUpdateServerID (packageUpdateServerID, package)
393);
394
395DROP TABLE IF EXISTS wcf1_package_update_exclusion;
396CREATE TABLE wcf1_package_update_exclusion (
397 packageUpdateVersionID INT(10) NOT NULL,
398 excludedPackage VARCHAR(255) NOT NULL DEFAULT '',
399 excludedPackageVersion VARCHAR(255) NOT NULL DEFAULT '',
400 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, excludedPackage)
401);
402
403DROP TABLE IF EXISTS wcf1_package_update_fromversion;
404CREATE TABLE wcf1_package_update_fromversion (
405 packageUpdateVersionID INT(10) NOT NULL DEFAULT 0,
406 fromversion VARCHAR(50) NOT NULL DEFAULT '',
407 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, fromversion)
408);
409
410DROP TABLE IF EXISTS wcf1_package_update_requirement;
411CREATE TABLE wcf1_package_update_requirement (
412 packageUpdateVersionID INT(10) NOT NULL,
413 package VARCHAR(255) NOT NULL DEFAULT '',
414 minversion VARCHAR(50) NOT NULL DEFAULT '',
415 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID, package)
416);
417
418DROP TABLE IF EXISTS wcf1_package_update_server;
419CREATE TABLE wcf1_package_update_server (
420 packageUpdateServerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
421 serverURL VARCHAR(255) NOT NULL DEFAULT '',
422 loginUsername VARCHAR(255) NOT NULL DEFAULT '',
423 loginPassword VARCHAR(255) NOT NULL DEFAULT '',
424 disabled TINYINT(1) NOT NULL DEFAULT 0,
425 lastUpdateTime INT(10) NOT NULL DEFAULT 0,
426 status ENUM('online', 'offline') NOT NULL DEFAULT 'online',
427 errorMessage TEXT
428);
429
430DROP TABLE IF EXISTS wcf1_package_update_version;
431CREATE TABLE wcf1_package_update_version (
432 packageUpdateVersionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
433 packageUpdateID INT(10) NOT NULL,
434 packageVersion VARCHAR(50) NOT NULL DEFAULT '',
435 updateType VARCHAR(10) NOT NULL DEFAULT '',
436 packageDate INT(10) NOT NULL DEFAULT 0,
437 filename VARCHAR(255) NOT NULL DEFAULT '',
438 UNIQUE KEY packageUpdateID (packageUpdateID, packageVersion)
439);
440
441DROP TABLE IF EXISTS wcf1_page_location;
442CREATE TABLE wcf1_page_location (
443 locationID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
444 locationPattern VARCHAR(255) NOT NULL DEFAULT '',
445 locationName VARCHAR(255) NOT NULL DEFAULT '',
446 packageID INT(10) NOT NULL,
447 className varchar(255) NOT NULL DEFAULT '',
448 UNIQUE KEY (packageID, locationName)
449);
450
451DROP TABLE IF EXISTS wcf1_page_menu_item;
452CREATE TABLE wcf1_page_menu_item (
453 menuItemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
454 packageID INT(10) NOT NULL,
455 menuItem VARCHAR(255) NOT NULL DEFAULT '',
456 parentMenuItem VARCHAR(255) NOT NULL DEFAULT '',
457 menuItemLink VARCHAR(255) NOT NULL DEFAULT '',
458 menuPosition ENUM('header', 'footer') NOT NULL DEFAULT 'header',
459 showOrder INT(10) NOT NULL DEFAULT 0,
460 permissions TEXT NULL,
461 options TEXT NULL,
462 isDisabled TINYINT(1) NOT NULL DEFAULT 0,
463 className VARCHAR(255) NOT NULL DEFAULT '',
464 UNIQUE KEY (packageID, menuItem)
465);
466
467DROP TABLE IF EXISTS wcf1_search;
468CREATE TABLE wcf1_search (
469 searchID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
470 userID INT(10),
471 searchData MEDIUMTEXT NOT NULL,
472 searchTime INT(10) NOT NULL DEFAULT 0,
473 searchType VARCHAR(255) NOT NULL DEFAULT '',
474 searchHash CHAR(40) NOT NULL DEFAULT '',
475 KEY searchHash (searchHash)
476);
477
478DROP TABLE IF EXISTS wcf1_session;
479CREATE TABLE wcf1_session (
480 sessionID CHAR(40) NOT NULL PRIMARY KEY,
481 packageID INT(10) NOT NULL,
482 userID INT(10),
483 ipAddress VARCHAR(39) NOT NULL DEFAULT '',
484 userAgent VARCHAR(255) NOT NULL DEFAULT '',
485 lastActivityTime INT(10) NOT NULL DEFAULT 0,
486 requestURI VARCHAR(255) NOT NULL DEFAULT '',
487 requestMethod VARCHAR(4) NOT NULL DEFAULT '',
488 username VARCHAR(255) NOT NULL DEFAULT '',
489 spiderID INT(10) NOT NULL DEFAULT 0,
490 KEY packageID (packageID, lastActivityTime, spiderID)
491);
492
493DROP TABLE IF EXISTS wcf1_session_data;
494CREATE TABLE wcf1_session_data (
495 sessionID CHAR(40) NOT NULL PRIMARY KEY,
496 sessionVariables MEDIUMTEXT
497);
498
499DROP TABLE IF EXISTS wcf1_spider;
500CREATE TABLE wcf1_spider (
501 spiderID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
502 spiderIdentifier VARCHAR(255) DEFAULT '',
503 spiderName VARCHAR(255) DEFAULT '',
504 spiderURL VARCHAR(255) DEFAULT '',
505 UNIQUE KEY spiderIdentifier (spiderIdentifier)
506);
507
508DROP TABLE IF EXISTS wcf1_style;
509CREATE TABLE wcf1_style (
510 styleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
511 packageID INT(10) NOT NULL,
512 styleName VARCHAR(255) NOT NULL DEFAULT '',
513 templateGroupID INT(10) NOT NULL DEFAULT 0,
514 isDefault TINYINT(1) NOT NULL DEFAULT 0,
515 disabled TINYINT(1) NOT NULL DEFAULT 0,
516 styleDescription TEXT,
517 styleVersion VARCHAR(255) NOT NULL DEFAULT '',
518 styleDate CHAR(10) NOT NULL DEFAULT '0000-00-00',
519 image VARCHAR(255) NOT NULL DEFAULT '',
520 copyright VARCHAR(255) NOT NULL DEFAULT '',
521 license VARCHAR(255) NOT NULL DEFAULT '',
522 authorName VARCHAR(255) NOT NULL DEFAULT '',
523 authorURL VARCHAR(255) NOT NULL DEFAULT ''
524);
525
526DROP TABLE IF EXISTS wcf1_style_to_package;
527CREATE TABLE wcf1_style_to_package (
528 styleID INT(10) NOT NULL,
529 packageID INT(10) NOT NULL,
530 isDefault TINYINT(1) NOT NULL DEFAULT 0,
531 disabled TINYINT(1) NOT NULL DEFAULT 0,
532 UNIQUE KEY (styleID, packageID)
533);
534
535DROP TABLE IF EXISTS wcf1_style_variable;
536CREATE TABLE wcf1_style_variable (
537 styleID INT(10) NOT NULL,
538 variableName VARCHAR(50) NOT NULL DEFAULT '',
539 variableValue MEDIUMTEXT,
540 UNIQUE KEY (styleID, variableName)
541);
542
543DROP TABLE IF EXISTS wcf1_style_variable_to_attribute;
544CREATE TABLE wcf1_style_variable_to_attribute (
545 packageID INT(10) NOT NULL,
546 cssSelector VARCHAR(200) NOT NULL DEFAULT '',
547 attributeName VARCHAR(50) NOT NULL DEFAULT '',
548 variableName VARCHAR(50) NOT NULL DEFAULT '',
549 UNIQUE KEY (packageID, cssSelector, attributeName, variableName)
550);
551
552DROP TABLE IF EXISTS wcf1_template;
553CREATE TABLE wcf1_template (
554 templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
555 packageID INT(10) NOT NULL,
556 templateName VARCHAR(255) NOT NULL DEFAULT '',
557 templateGroupID INT(10),
558 obsolete TINYINT(1) NOT NULL DEFAULT 0,
559 KEY packageID (packageID, templateName),
560 KEY templateGroupID (packageID, templateGroupID, templateName)
561);
562
563DROP TABLE IF EXISTS wcf1_template_group;
564CREATE TABLE wcf1_template_group (
565 templateGroupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
566 parentTemplateGroupID INT(10) NOT NULL DEFAULT 0,
567 templateGroupName VARCHAR(255) NOT NULL DEFAULT '',
568 templateGroupFolderName VARCHAR(255) NOT NULL DEFAULT ''
569);
570
571DROP TABLE IF EXISTS wcf1_user;
572CREATE TABLE wcf1_user (
573 userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
574 username VARCHAR(255) NOT NULL DEFAULT '',
575 email VARCHAR(255) NOT NULL DEFAULT '',
576 password VARCHAR(40) NOT NULL DEFAULT '',
577 salt VARCHAR(40) NOT NULL DEFAULT '',
578 languageID INT(10) NOT NULL DEFAULT 0,
579 registrationDate INT(10) NOT NULL DEFAULT 0,
580 styleID INT(10) NOT NULL DEFAULT 0,
581
582 KEY username (username),
583 KEY registrationDate (registrationDate),
584 KEY styleID (styleID)
585);
586
587DROP TABLE IF EXISTS wcf1_user_group;
588CREATE TABLE wcf1_user_group (
589 groupID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
590 groupName VARCHAR(255) NOT NULL DEFAULT '',
591 groupType TINYINT(1) NOT NULL DEFAULT 0
592);
593
594DROP TABLE IF EXISTS wcf1_user_group_option;
595CREATE TABLE wcf1_user_group_option (
596 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
597 packageID INT(10),
598 optionName VARCHAR(255) NOT NULL DEFAULT '',
599 categoryName VARCHAR(255) NOT NULL DEFAULT '',
600 optionType VARCHAR(255) NOT NULL DEFAULT '',
601 defaultValue MEDIUMTEXT,
602 adminDefaultValue MEDIUMTEXT,
603 validationPattern TEXT,
604 enableOptions MEDIUMTEXT,
605 showOrder INT(10) NOT NULL DEFAULT 0,
606 permissions TEXT,
607 options TEXT,
608 additionalData MEDIUMTEXT,
609 UNIQUE KEY optionName (optionName, packageID)
610);
611
612DROP TABLE IF EXISTS wcf1_user_group_option_category;
613CREATE TABLE wcf1_user_group_option_category (
614 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
615 packageID INT(10) NOT NULL,
616 categoryName VARCHAR(255) NOT NULL DEFAULT '',
617 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
618 showOrder INT(10) NOT NULL DEFAULT 0,
619 permissions TEXT,
620 options TEXT,
621 UNIQUE KEY categoryName (categoryName, packageID)
622);
623
624DROP TABLE IF EXISTS wcf1_user_group_option_value;
625CREATE TABLE wcf1_user_group_option_value (
626 groupID INT(10) NOT NULL,
627 optionID INT(10) NOT NULL,
628 optionValue MEDIUMTEXT NOT NULL,
629 UNIQUE KEY groupID (groupID, optionID)
630);
631
632DROP TABLE IF EXISTS wcf1_user_option;
633CREATE TABLE wcf1_user_option (
634 optionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
635 packageID INT(10) NOT NULL,
636 optionName VARCHAR(255) NOT NULL DEFAULT '',
637 categoryName VARCHAR(255) NOT NULL DEFAULT '',
638 optionType VARCHAR(255) NOT NULL DEFAULT '',
639 defaultValue MEDIUMTEXT,
640 validationPattern TEXT,
641 selectOptions MEDIUMTEXT,
642 enableOptions MEDIUMTEXT,
643 required TINYINT(1) NOT NULL DEFAULT 0,
644 askDuringRegistration TINYINT(1) NOT NULL DEFAULT 0,
645 editable TINYINT(1) NOT NULL DEFAULT 0,
646 visible TINYINT(1) NOT NULL DEFAULT 0,
647 outputClass VARCHAR(255) NOT NULL DEFAULT '',
648 searchable TINYINT(1) NOT NULL DEFAULT 0,
649 showOrder INT(10) NOT NULL DEFAULT 0,
650 disabled TINYINT(1) NOT NULL DEFAULT 0,
651 permissions TEXT,
652 options TEXT,
653 additionalData MEDIUMTEXT,
654 UNIQUE KEY optionName (optionName, packageID),
655 KEY categoryName (categoryName)
656);
657
658DROP TABLE IF EXISTS wcf1_user_option_category;
659CREATE TABLE wcf1_user_option_category (
660 categoryID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
661 packageID INT(10) NOT NULL,
662 categoryName VARCHAR(255) NOT NULL DEFAULT '',
663 categoryIconS VARCHAR(255) NOT NULL DEFAULT '',
664 categoryIconM VARCHAR(255) NOT NULL DEFAULT '',
665 parentCategoryName VARCHAR(255) NOT NULL DEFAULT '',
666 showOrder INT(10) NOT NULL DEFAULT 0,
667 permissions TEXT,
668 options TEXT,
669 UNIQUE KEY categoryName (categoryName, packageID)
670);
671
672DROP TABLE IF EXISTS wcf1_user_option_value;
673CREATE TABLE wcf1_user_option_value (
674 userID INT(10) NOT NULL PRIMARY KEY
675);
676
677DROP TABLE IF EXISTS wcf1_user_to_group;
678CREATE TABLE wcf1_user_to_group (
679 userID INT(10) NOT NULL,
680 groupID INT(10) NOT NULL,
681 UNIQUE KEY userID (userID, groupID)
682);
683
684DROP TABLE IF EXISTS wcf1_user_to_language;
685CREATE TABLE wcf1_user_to_language (
686 userID INT(10) NOT NULL,
687 languageID INT(10) NOT NULL,
688 UNIQUE KEY userID (userID, languageID)
689);
690
691DROP TABLE IF EXISTS wcf1_template_listener;
692CREATE TABLE wcf1_template_listener (
693 listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
694 packageID INT(10) NOT NULL,
695 name VARCHAR(80) NOT NULL DEFAULT '',
696 environment ENUM('user','admin') NOT NULL DEFAULT 'user',
697 templateName VARCHAR(80) NOT NULL DEFAULT '',
698 eventName VARCHAR(50) NOT NULL DEFAULT '',
699 templateCode TEXT NOT NULL,
700 KEY templateName (environment, templateName)
701);
702
461a69ea
MS		 703DROP TABLE IF EXISTS wcf1_user_storage;
704CREATE TABLE wcf1_user_storage (
158bd3ca
TD		 705 userID INT(10) NOT NULL,
706 field VARCHAR(80) NOT NULL DEFAULT '',
707 fieldValue TEXT,
708 packageID INT(10),
461a69ea 709 UNIQUE KEY userStorageData (userID, field, packageID)
158bd3ca
TD		 710);
711
712/**** foreign keys ****/
713ALTER TABLE wcf1_acp_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
714
715ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
716ALTER TABLE wcf1_acp_session ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
717
718ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (sessionLogID) REFERENCES wcf1_acp_session_log (sessionLogID) ON DELETE CASCADE;
719ALTER TABLE wcf1_acp_session_access_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
720
721ALTER TABLE wcf1_acp_session_data ADD FOREIGN KEY (sessionID) REFERENCES wcf1_acp_session (sessionID) ON DELETE CASCADE;
722
723ALTER TABLE wcf1_acp_session_log ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE SET NULL;
724
725ALTER TABLE wcf1_acp_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
726
727ALTER TABLE wcf1_application ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
728ALTER TABLE wcf1_application ADD FOREIGN KEY (groupID) REFERENCES wcf1_application_group (groupID) ON DELETE SET NULL;
729
730ALTER TABLE wcf1_cleanup_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
731
732ALTER TABLE wcf1_cleanup_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
733
0e6741f8
AE		 734ALTER TABLE wcf1_clipboard_action ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
735
736ALTER TABLE wcf1_clipboard_item ADD FOREIGN KEY (typeID) REFERENCES wcf1_clipboard_item_type (typeID) ON DELETE CASCADE;
737
738ALTER TABLE wcf1_clipboard_item_type ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
739
740ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (actionID) REFERENCES wcf1_clipboard_action (actionID) ON DELETE CASCADE;
741ALTER TABLE wcf1_clipboard_page ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
742
158bd3ca
TD		 743ALTER TABLE wcf1_core_object ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
744
745ALTER TABLE wcf1_cronjob ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
746
747ALTER TABLE wcf1_cronjob_log ADD FOREIGN KEY (cronjobID) REFERENCES wcf1_cronjob (cronjobID) ON DELETE CASCADE;
748
749ALTER TABLE wcf1_event_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
750
751ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
752ALTER TABLE wcf1_language_item ADD FOREIGN KEY (languageCategoryID) REFERENCES wcf1_language_category (languageCategoryID) ON DELETE CASCADE;
753ALTER TABLE wcf1_language_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
754
755ALTER TABLE wcf1_language_to_package ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
756ALTER TABLE wcf1_language_to_package ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
757
758ALTER TABLE wcf1_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
759
760ALTER TABLE wcf1_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
761
762ALTER TABLE wcf1_package_dependency ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
763ALTER TABLE wcf1_package_dependency ADD FOREIGN KEY (dependency) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
764
765ALTER TABLE wcf1_package_exclusion ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
766
767ALTER TABLE wcf1_package_installation_file_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
768
769ALTER TABLE wcf1_package_installation_form ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
770
771ALTER TABLE wcf1_package_installation_node ADD FOREIGN KEY (queueID) REFERENCES wcf1_package_installation_queue (queueID) ON DELETE CASCADE;
772
773ALTER TABLE wcf1_package_installation_plugin ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
774
775ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
776ALTER TABLE wcf1_package_installation_queue ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE SET NULL;
777
778ALTER TABLE wcf1_package_installation_sql_log ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
779
780ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
781ALTER TABLE wcf1_package_requirement ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
782
783ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
784ALTER TABLE wcf1_package_requirement_map ADD FOREIGN KEY (requirement) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
785
786ALTER TABLE wcf1_package_update ADD FOREIGN KEY (packageUpdateServerID) REFERENCES wcf1_package_update_server (packageUpdateServerID) ON DELETE CASCADE;
787
788ALTER TABLE wcf1_package_update_exclusion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
789
790ALTER TABLE wcf1_package_update_fromversion ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
791
792ALTER TABLE wcf1_package_update_requirement ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE;
793
794ALTER TABLE wcf1_package_update_version ADD FOREIGN KEY (packageUpdateID) REFERENCES wcf1_package_update (packageUpdateID) ON DELETE CASCADE;
795
796ALTER TABLE wcf1_page_location ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
797
798ALTER TABLE wcf1_page_menu_item ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
799
800ALTER TABLE wcf1_search ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
801
802ALTER TABLE wcf1_session ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
803ALTER TABLE wcf1_session ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
804
805ALTER TABLE wcf1_session_data ADD FOREIGN KEY (sessionID) REFERENCES wcf1_session (sessionID) ON DELETE CASCADE;
806
461a69ea
MS		 807ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
808ALTER TABLE wcf1_user_storage ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
158bd3ca
TD		 809
810ALTER TABLE wcf1_style ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
811
812ALTER TABLE wcf1_style_to_package ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
813ALTER TABLE wcf1_style_to_package ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
814
815ALTER TABLE wcf1_style_variable ADD FOREIGN KEY (styleID) REFERENCES wcf1_style (styleID) ON DELETE CASCADE;
816
817ALTER TABLE wcf1_style_variable_to_attribute ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
818
819ALTER TABLE wcf1_template ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
820ALTER TABLE wcf1_template ADD FOREIGN KEY (templateGroupID) REFERENCES wcf1_template_group (templateGroupID) ON DELETE CASCADE;
821
822ALTER TABLE wcf1_template_listener ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
823
824ALTER TABLE wcf1_user_group_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
825
826ALTER TABLE wcf1_user_group_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
827
828ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
829ALTER TABLE wcf1_user_group_option_value ADD FOREIGN KEY (optionID) REFERENCES wcf1_user_group_option (optionID) ON DELETE CASCADE;
830
831ALTER TABLE wcf1_user_option ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
832
833ALTER TABLE wcf1_user_option_category ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE;
834
835ALTER TABLE wcf1_user_option_value ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
836
837ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
838ALTER TABLE wcf1_user_to_group ADD FOREIGN KEY (groupID) REFERENCES wcf1_user_group (groupID) ON DELETE CASCADE;
839
840ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (userID) REFERENCES wcf1_user (userID) ON DELETE CASCADE;
841ALTER TABLE wcf1_user_to_language ADD FOREIGN KEY (languageID) REFERENCES wcf1_language (languageID) ON DELETE CASCADE;
842
843/**** default inserts ****/
844-- default user groups
845INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Everyone', 1);
846INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Guests', 2);
847INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Users', 3);
848INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Administrators', 4);
849INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Moderators', 4);
850INSERT INTO wcf1_user_group (groupName, groupType) VALUES ('Super Moderators', 4);
851
852-- default user group options
853INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
854INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
855INSERT INTO wcf1_user_group_option (optionName, categoryName, optionType, defaultValue, adminDefaultValue, showOrder) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
856
857-- default user group option values
858INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 1, '0'); -- Everyone
859INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 2, '0'); -- Everyone
860INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (1, 3, '0'); -- Everyone
861INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 1, '1'); -- Administrators
862INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 2, '1'); -- Administrators
863INSERT INTO wcf1_user_group_option_value (groupID, optionID, optionValue) VALUES (4, 3, '1'); -- Administrators
864
865-- default update servers
866INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/tempest/', 'online', 0, NULL, 0, '', '');
867INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
868INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/tempest/', 'online', 0, NULL, 0, '', '');
869INSERT INTO wcf1_package_update_server (serverURL, status, disabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
WoltLab Suite Core (previously WoltLab Community Framework)