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