2 DROP TABLE IF EXISTS wcf1_acl_option
;
3 CREATE TABLE wcf1_acl_option (
4 optionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
5 packageID
INT(10) NOT NULL,
6 objectTypeID
INT(10) NOT NULL,
7 optionName
VARCHAR(255) NOT NULL,
8 categoryName
VARCHAR(255) NOT NULL,
9 UNIQUE KEY (packageID
, objectTypeID
, optionName
)
12 DROP TABLE IF EXISTS wcf1_acl_option_category
;
13 CREATE TABLE wcf1_acl_option_category (
14 categoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
15 packageID
INT(10) NOT NULL,
16 objectTypeID
INT(10) NOT NULL,
17 categoryName
VARCHAR(255) NOT NULL,
18 UNIQUE KEY (packageID
, objectTypeID
, categoryName
)
21 DROP TABLE IF EXISTS wcf1_acl_option_to_user
;
22 CREATE TABLE wcf1_acl_option_to_user (
23 optionID
INT(10) NOT NULL,
24 objectID
INT(10) NOT NULL,
25 userID
INT(10) NOT NULL,
26 optionValue
TINYINT(1) NOT NULL DEFAULT 0,
27 UNIQUE KEY userID (userID
, objectID
, optionID
)
30 DROP TABLE IF EXISTS wcf1_acl_option_to_group
;
31 CREATE TABLE wcf1_acl_option_to_group (
32 optionID
INT(10) NOT NULL,
33 objectID
INT(10) NOT NULL,
34 groupID
INT(10) NOT NULL,
35 optionValue
TINYINT(1) NOT NULL DEFAULT 0,
36 UNIQUE KEY groupID (groupID
, objectID
, optionID
)
39 DROP TABLE IF EXISTS wcf1_acp_menu_item
;
40 CREATE TABLE wcf1_acp_menu_item (
41 menuItemID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
42 packageID
INT(10) NOT NULL,
43 menuItem
VARCHAR(255) NOT NULL DEFAULT '',
44 parentMenuItem
VARCHAR(255) NOT NULL DEFAULT '',
45 menuItemController
VARCHAR(255) NOT NULL DEFAULT '',
46 menuItemLink
VARCHAR(255) NOT NULL DEFAULT '',
47 showOrder
INT(10) NOT NULL DEFAULT 0,
50 UNIQUE KEY menuItem (menuItem
, packageID
)
53 DROP TABLE IF EXISTS wcf1_acp_search_provider
;
54 CREATE TABLE wcf1_acp_search_provider (
55 providerID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
56 packageID
INT(10) NOT NULL,
57 providerName
VARCHAR(255) NOT NULL DEFAULT '',
58 className
VARCHAR(255) NOT NULL DEFAULT '',
59 showOrder
INT(10) NOT NULL DEFAULT 0,
60 UNIQUE KEY providerName (providerName
, packageID
)
63 DROP TABLE IF EXISTS wcf1_acp_session
;
64 CREATE TABLE wcf1_acp_session (
65 sessionID
CHAR(40) NOT NULL PRIMARY KEY,
67 ipAddress
VARCHAR(39) NOT NULL DEFAULT '',
68 userAgent
VARCHAR(255) NOT NULL DEFAULT '',
69 lastActivityTime
INT(10) NOT NULL DEFAULT 0,
70 requestURI
VARCHAR(255) NOT NULL DEFAULT '',
71 requestMethod
VARCHAR(4) NOT NULL DEFAULT '',
72 controller
VARCHAR(255) NOT NULL DEFAULT '',
73 parentObjectType
VARCHAR(255) NOT NULL DEFAULT '',
74 parentObjectID
INT(10) NOT NULL DEFAULT 0,
75 objectType
VARCHAR(255) NOT NULL DEFAULT '',
76 objectID
INT(10) NOT NULL DEFAULT 0,
77 sessionVariables MEDIUMTEXT
80 DROP TABLE IF EXISTS wcf1_acp_session_access_log
;
81 CREATE TABLE wcf1_acp_session_access_log (
82 sessionAccessLogID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
83 sessionLogID
INT(10) NOT NULL,
84 ipAddress
VARCHAR(39) NOT NULL DEFAULT '',
85 time INT(10) NOT NULL DEFAULT 0,
86 requestURI
VARCHAR(255) NOT NULL DEFAULT '',
87 requestMethod
VARCHAR(4) NOT NULL DEFAULT '',
88 className
VARCHAR(255) NOT NULL DEFAULT '',
89 KEY sessionLogID (sessionLogID
)
92 DROP TABLE IF EXISTS wcf1_acp_session_log
;
93 CREATE TABLE wcf1_acp_session_log (
94 sessionLogID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
95 sessionID
CHAR(40) NOT NULL DEFAULT '',
97 ipAddress
VARCHAR(39) NOT NULL DEFAULT '',
98 hostname
VARCHAR(255) NOT NULL DEFAULT '',
99 userAgent
VARCHAR(255) NOT NULL DEFAULT '',
100 time INT(10) NOT NULL DEFAULT 0,
101 lastActivityTime
INT(10) NOT NULL DEFAULT 0,
102 KEY sessionID (sessionID
)
105 DROP TABLE IF EXISTS wcf1_acp_template
;
106 CREATE TABLE wcf1_acp_template (
107 templateID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
109 templateName
VARCHAR(255) NOT NULL DEFAULT '',
110 UNIQUE KEY (packageID
, templateName
)
113 DROP TABLE IF EXISTS wcf1_application
;
114 CREATE TABLE wcf1_application (
115 packageID
INT(10) NOT NULL PRIMARY KEY,
116 domainName
VARCHAR(255) NOT NULL,
117 domainPath
VARCHAR(255) NOT NULL DEFAULT '/',
118 cookieDomain
VARCHAR(255) NOT NULL,
119 cookiePath
VARCHAR(255) NOT NULL DEFAULT '/',
120 isPrimary
TINYINT(1) NOT NULL DEFAULT 0
123 DROP TABLE IF EXISTS wcf1_category
;
124 CREATE TABLE wcf1_category (
125 categoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
126 objectTypeID
INT(10) NOT NULL,
127 parentCategoryID
INT(10) NOT NULL,
128 title
VARCHAR(255) NOT NULL,
130 showOrder
INT(10) NOT NULL,
131 time INT(10) NOT NULL,
132 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
136 DROP TABLE IF EXISTS wcf1_clipboard_action
;
137 CREATE TABLE wcf1_clipboard_action (
138 actionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
139 packageID
INT(10) NOT NULL DEFAULT 0,
140 actionName
VARCHAR(50) NOT NULL DEFAULT '',
141 actionClassName
VARCHAR(200) NOT NULL DEFAULT '',
142 showOrder
INT(10) NOT NULL DEFAULT 0,
143 UNIQUE KEY actionName (packageID
, actionName
, actionClassName
)
146 DROP TABLE IF EXISTS wcf1_clipboard_item
;
147 CREATE TABLE wcf1_clipboard_item (
148 objectTypeID
INT(10) NOT NULL DEFAULT 0,
149 userID
INT(10) NOT NULL DEFAULT 0,
150 objectID
INT(10) NOT NULL DEFAULT 0,
151 UNIQUE KEY (objectTypeID
, userID
, objectID
)
154 DROP TABLE IF EXISTS wcf1_clipboard_page
;
155 CREATE TABLE wcf1_clipboard_page (
156 pageClassName
VARCHAR(80) NOT NULL DEFAULT '',
157 packageID
INT(10) NOT NULL DEFAULT 0,
158 actionID
INT(10) NOT NULL DEFAULT 0
161 DROP TABLE IF EXISTS wcf1_core_object
;
162 CREATE TABLE wcf1_core_object (
163 objectID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
164 packageID
INT(10) NOT NULL,
165 objectName
VARCHAR(255) NOT NULL DEFAULT '',
166 UNIQUE KEY object (packageID
, objectName
)
169 DROP TABLE IF EXISTS wcf1_cronjob
;
170 CREATE TABLE wcf1_cronjob (
171 cronjobID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
172 className
varchar(255) NOT NULL DEFAULT '',
173 packageID
INT(10) NOT NULL,
174 description
varchar(255) NOT NULL DEFAULT '',
175 startMinute
varchar(255) NOT NULL DEFAULT '*',
176 startHour
varchar(255) NOT NULL DEFAULT '*',
177 startDom
varchar(255) NOT NULL DEFAULT '*',
178 startMonth
varchar(255) NOT NULL DEFAULT '*',
179 startDow
varchar(255) NOT NULL DEFAULT '*',
180 lastExec
INT(10) NOT NULL DEFAULT 0,
181 nextExec
INT(10) NOT NULL DEFAULT 0,
182 afterNextExec
INT(10) NOT NULL DEFAULT 0,
183 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
184 canBeEdited
TINYINT(1) NOT NULL DEFAULT 1,
185 canBeDisabled
TINYINT(1) NOT NULL DEFAULT 1,
186 state TINYINT(1) NOT NULL DEFAULT 0,
187 failCount
TINYINT(1) NOT NULL DEFAULT 0
190 DROP TABLE IF EXISTS wcf1_cronjob_log
;
191 CREATE TABLE wcf1_cronjob_log (
192 cronjobLogID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
193 cronjobID
INT(10) NOT NULL,
194 execTime
INT(10) NOT NULL DEFAULT 0,
195 success
TINYINT(1) NOT NULL DEFAULT 0,
199 DROP TABLE IF EXISTS wcf1_event_listener
;
200 CREATE TABLE wcf1_event_listener (
201 listenerID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
202 packageID
INT(10) NOT NULL,
203 environment
ENUM('user', 'admin') NOT NULL DEFAULT 'user',
204 eventClassName
VARCHAR(80) NOT NULL DEFAULT '',
205 eventName
VARCHAR(50) NOT NULL DEFAULT '',
206 listenerClassName
VARCHAR(200) NOT NULL DEFAULT '',
207 inherit TINYINT(1) NOT NULL DEFAULT 0,
208 niceValue
TINYINT(3) NOT NULL DEFAULT 0,
209 UNIQUE KEY packageID (packageID
, environment
, eventClassName
, eventName
, listenerClassName
)
212 DROP TABLE IF EXISTS wcf1_language
;
213 CREATE TABLE wcf1_language (
214 languageID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
215 languageCode
VARCHAR(20) NOT NULL DEFAULT '',
216 languageName
VARCHAR(255) NOT NULL DEFAULT '',
217 countryCode
VARCHAR(10) NOT NULL DEFAULT '',
218 isDefault
TINYINT(1) NOT NULL DEFAULT 0,
219 hasContent
TINYINT(1) NOT NULL DEFAULT 0,
220 UNIQUE KEY languageCode (languageCode
)
223 DROP TABLE IF EXISTS wcf1_language_category
;
224 CREATE TABLE wcf1_language_category (
225 languageCategoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
226 languageCategory
VARCHAR(255) NOT NULL DEFAULT '',
227 UNIQUE KEY languageCategory (languageCategory
)
230 DROP TABLE IF EXISTS wcf1_language_item
;
231 CREATE TABLE wcf1_language_item (
232 languageItemID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
233 languageID
INT(10) NOT NULL,
234 languageItem
VARCHAR(255) NOT NULL DEFAULT '',
235 languageItemValue MEDIUMTEXT
NOT NULL,
236 languageCustomItemValue MEDIUMTEXT
,
237 languageUseCustomValue
TINYINT(1) NOT NULL DEFAULT 0,
238 languageItemOriginIsSystem
TINYINT(1) NOT NULL DEFAULT 1,
239 languageCategoryID
INT(10) NOT NULL,
241 UNIQUE KEY languageItem (languageItem
, languageID
),
242 KEY languageItemOriginIsSystem (languageItemOriginIsSystem
)
245 DROP TABLE IF EXISTS wcf1_language_server
;
246 CREATE TABLE wcf1_language_server (
247 languageServerID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
248 serverURL
VARCHAR(255) NOT NULL DEFAULT '',
249 isDisabled
TINYINT(1) NOT NULL DEFAULT 0
252 DROP TABLE IF EXISTS wcf1_modification_log
;
253 CREATE TABLE wcf1_modification_log (
254 logID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
255 objectTypeID
INT(10) NOT NULL,
256 objectID
INT(10) NOT NULL,
258 username
VARCHAR(255) NOT NULL DEFAULT '',
259 time INT(10) NOT NULL DEFAULT 0,
260 action VARCHAR(80) NOT NULL,
261 additionalData MEDIUMTEXT
264 DROP TABLE IF EXISTS wcf1_object_type
;
265 CREATE TABLE wcf1_object_type (
266 objectTypeID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
267 definitionID
INT(10) NOT NULL,
268 packageID
INT(10) NOT NULL,
269 objectType
VARCHAR(255) NOT NULL,
270 className
VARCHAR(255) NOT NULL DEFAULT '',
271 additionalData MEDIUMTEXT
,
272 UNIQUE KEY objectType (objectType
, definitionID
, packageID
)
275 DROP TABLE IF EXISTS wcf1_object_type_definition
;
276 CREATE TABLE wcf1_object_type_definition (
277 definitionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
278 definitionName
VARCHAR(255) NOT NULL,
279 packageID
INT(10) NOT NULL,
280 interfaceName
VARCHAR(255) NOT NULL DEFAULT '',
281 categoryName
VARCHAR(80) NOT NULL DEFAULT '',
282 UNIQUE KEY definitionName (definitionName
)
285 DROP TABLE IF EXISTS wcf1_option
;
286 CREATE TABLE wcf1_option (
287 optionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
288 packageID
INT(10) NOT NULL,
289 optionName
VARCHAR(255) NOT NULL DEFAULT '',
290 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
291 optionType
VARCHAR(255) NOT NULL DEFAULT '',
292 optionValue MEDIUMTEXT
,
293 validationPattern
TEXT,
294 selectOptions MEDIUMTEXT
,
295 enableOptions MEDIUMTEXT
,
296 showOrder
INT(10) NOT NULL DEFAULT 0,
297 hidden
TINYINT(1) NOT NULL DEFAULT 0,
300 supportI18n
TINYINT(1) NOT NULL DEFAULT 0,
301 requireI18n
TINYINT(1) NOT NULL DEFAULT 0,
302 additionalData MEDIUMTEXT
,
304 UNIQUE KEY optionName (optionName
)
307 DROP TABLE IF EXISTS wcf1_option_category
;
308 CREATE TABLE wcf1_option_category (
309 categoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
310 packageID
INT(10) NOT NULL,
311 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
312 parentCategoryName
VARCHAR(255) NOT NULL DEFAULT '',
313 showOrder
INT(10) NOT NULL DEFAULT 0,
316 UNIQUE KEY categoryName (categoryName
)
319 DROP TABLE IF EXISTS wcf1_package
;
320 CREATE TABLE wcf1_package (
321 packageID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
322 package
VARCHAR(255) NOT NULL DEFAULT '',
323 packageDir
VARCHAR(255) NOT NULL DEFAULT '',
324 packageName
VARCHAR(255) NOT NULL DEFAULT '',
325 packageDescription
VARCHAR(255) NOT NULL DEFAULT '',
326 packageVersion
VARCHAR(255) NOT NULL DEFAULT '',
327 packageDate
INT(10) NOT NULL DEFAULT 0,
328 installDate
INT(10) NOT NULL DEFAULT 0,
329 updateDate
INT(10) NOT NULL DEFAULT 0,
330 packageURL
VARCHAR(255) NOT NULL DEFAULT '',
331 isApplication
TINYINT(1) NOT NULL DEFAULT 0,
332 author
VARCHAR(255) NOT NULL DEFAULT '',
333 authorURL
VARCHAR(255) NOT NULL DEFAULT '',
334 KEY package (package
)
337 DROP TABLE IF EXISTS wcf1_package_exclusion
;
338 CREATE TABLE wcf1_package_exclusion (
339 packageID
INT(10) NOT NULL,
340 excludedPackage
VARCHAR(255) NOT NULL DEFAULT '',
341 excludedPackageVersion
VARCHAR(255) NOT NULL DEFAULT '',
342 UNIQUE KEY packageID (packageID
, excludedPackage
)
345 DROP TABLE IF EXISTS wcf1_package_installation_file_log
;
346 CREATE TABLE wcf1_package_installation_file_log (
348 filename
VARCHAR(255) NOT NULL DEFAULT '',
349 UNIQUE KEY packageID (packageID
, filename
)
352 DROP TABLE IF EXISTS wcf1_package_installation_form
;
353 CREATE TABLE wcf1_package_installation_form (
354 queueID
INT(10) NOT NULL,
355 formName
VARCHAR(80) NOT NULL DEFAULT '',
356 document TEXT NOT NULL,
357 UNIQUE KEY formDocument (queueID
, formName
)
360 DROP TABLE IF EXISTS wcf1_package_installation_node
;
361 CREATE TABLE wcf1_package_installation_node (
362 queueID
INT(10) NOT NULL,
363 processNo
INT(10) NOT NULL DEFAULT 0,
364 sequenceNo
SMALLINT(4) NOT NULL DEFAULT 0,
365 node
CHAR(8) NOT NULL DEFAULT '',
366 parentNode
CHAR(8) NOT NULL DEFAULT '',
367 nodeType
ENUM('optionalPackages','package', 'pip') NOT NULL DEFAULT 'package',
368 nodeData
TEXT NOT NULL,
369 done
TINYINT(1) NOT NULL DEFAULT 0
372 DROP TABLE IF EXISTS wcf1_package_installation_plugin
;
373 CREATE TABLE wcf1_package_installation_plugin (
374 pluginName
VARCHAR(255) NOT NULL PRIMARY KEY,
376 priority
TINYINT(1) NOT NULL DEFAULT 0,
377 className
VARCHAR(255) NOT NULL
380 DROP TABLE IF EXISTS wcf1_package_installation_queue
;
381 CREATE TABLE wcf1_package_installation_queue (
382 queueID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
383 parentQueueID
INT(10) NOT NULL DEFAULT 0,
384 processNo
INT(10) NOT NULL DEFAULT 0,
385 userID
INT(10) NOT NULL,
386 package
VARCHAR(255) NOT NULL DEFAULT '',
387 packageName
VARCHAR(255) NOT NULL DEFAULT '',
389 archive
VARCHAR(255) NOT NULL DEFAULT '',
390 action ENUM('install', 'update', 'uninstall') NOT NULL DEFAULT 'install',
391 done
TINYINT(1) NOT NULL DEFAULT 0,
392 confirmInstallation
TINYINT(1) NOT NULL DEFAULT 0,
393 packageType
ENUM('default', 'requirement', 'optional') NOT NULL DEFAULT 'default'
396 DROP TABLE IF EXISTS wcf1_package_installation_sql_log
;
397 CREATE TABLE wcf1_package_installation_sql_log (
399 sqlTable
VARCHAR(100) NOT NULL DEFAULT '',
400 sqlColumn
VARCHAR(100) NOT NULL DEFAULT '',
401 sqlIndex
VARCHAR(100) NOT NULL DEFAULT '',
402 UNIQUE KEY packageID (packageID
, sqlTable
, sqlColumn
, sqlIndex
)
405 DROP TABLE IF EXISTS wcf1_package_requirement
;
406 CREATE TABLE wcf1_package_requirement (
407 packageID
INT(10) NOT NULL,
408 requirement
INT(10) NOT NULL,
409 UNIQUE KEY packageID (packageID
, requirement
)
412 DROP TABLE IF EXISTS wcf1_package_update
;
413 CREATE TABLE wcf1_package_update (
414 packageUpdateID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
415 packageUpdateServerID
INT(10) NOT NULL,
416 package
VARCHAR(255) NOT NULL DEFAULT '',
417 packageName
VARCHAR(255) NOT NULL DEFAULT '',
418 packageDescription
VARCHAR(255) NOT NULL DEFAULT '',
419 author
VARCHAR(255) NOT NULL DEFAULT '',
420 authorURL
VARCHAR(255) NOT NULL DEFAULT '',
421 isApplication
TINYINT(1) NOT NULL DEFAULT 0
422 UNIQUE KEY packageUpdateServerID (packageUpdateServerID
, package
)
425 DROP TABLE IF EXISTS wcf1_package_update_exclusion
;
426 CREATE TABLE wcf1_package_update_exclusion (
427 packageUpdateVersionID
INT(10) NOT NULL,
428 excludedPackage
VARCHAR(255) NOT NULL DEFAULT '',
429 excludedPackageVersion
VARCHAR(255) NOT NULL DEFAULT '',
430 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID
, excludedPackage
)
433 DROP TABLE IF EXISTS wcf1_package_update_fromversion
;
434 CREATE TABLE wcf1_package_update_fromversion (
435 packageUpdateVersionID
INT(10) NOT NULL DEFAULT 0,
436 fromversion
VARCHAR(50) NOT NULL DEFAULT '',
437 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID
, fromversion
)
440 DROP TABLE IF EXISTS wcf1_package_update_optional
;
441 CREATE TABLE wcf1_package_update_optional (
442 packageUpdateVersionID
INT(10) NOT NULL DEFAULT 0,
443 package
VARCHAR(255) NOT NULL DEFAULT ''
446 DROP TABLE IF EXISTS wcf1_package_update_requirement
;
447 CREATE TABLE wcf1_package_update_requirement (
448 packageUpdateVersionID
INT(10) NOT NULL,
449 package
VARCHAR(255) NOT NULL DEFAULT '',
450 minversion
VARCHAR(50) NOT NULL DEFAULT '',
451 UNIQUE KEY packageUpdateVersionID (packageUpdateVersionID
, package
)
454 DROP TABLE IF EXISTS wcf1_package_update_server
;
455 CREATE TABLE wcf1_package_update_server (
456 packageUpdateServerID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
457 serverURL
VARCHAR(255) NOT NULL DEFAULT '',
458 loginUsername
VARCHAR(255) NOT NULL DEFAULT '',
459 loginPassword
VARCHAR(255) NOT NULL DEFAULT '',
460 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
461 lastUpdateTime
INT(10) NOT NULL DEFAULT 0,
462 status
ENUM('online', 'offline') NOT NULL DEFAULT 'online',
466 DROP TABLE IF EXISTS wcf1_package_update_version
;
467 CREATE TABLE wcf1_package_update_version (
468 packageUpdateVersionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
469 packageUpdateID
INT(10) NOT NULL,
470 packageVersion
VARCHAR(50) NOT NULL DEFAULT '',
471 packageDate
INT(10) NOT NULL DEFAULT 0,
472 filename
VARCHAR(255) NOT NULL DEFAULT '',
473 license
VARCHAR(255) NOT NULL DEFAULT '',
474 licenseURL
VARCHAR(255) NOT NULL DEFAULT '',
475 isAccessible
TINYINT(1) NOT NULL DEFAULT 1,
476 isCritical
TINYINT(1) NOT NULL DEFAULT 0,
477 UNIQUE KEY packageUpdateID (packageUpdateID
, packageVersion
)
480 DROP TABLE IF EXISTS wcf1_page_menu_item
;
481 CREATE TABLE wcf1_page_menu_item (
482 menuItemID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
483 packageID
INT(10) NOT NULL,
484 menuItem
VARCHAR(255) NOT NULL DEFAULT '',
485 parentMenuItem
VARCHAR(255) NOT NULL DEFAULT '',
486 menuItemController
VARCHAR(255) NOT NULL DEFAULT '',
487 menuItemLink
VARCHAR(255) NOT NULL DEFAULT '',
488 menuPosition
ENUM('header', 'footer') NOT NULL DEFAULT 'header',
489 showOrder
INT(10) NOT NULL DEFAULT 0,
490 permissions
TEXT NULL,
492 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
493 className
VARCHAR(255) NOT NULL DEFAULT '',
494 isLandingPage
TINYINT(1) NOT NULL DEFAULT 0,
495 UNIQUE KEY (packageID
, menuItem
)
498 DROP TABLE IF EXISTS wcf1_search
;
499 CREATE TABLE wcf1_search (
500 searchID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
502 searchData MEDIUMTEXT
NOT NULL,
503 searchTime
INT(10) NOT NULL DEFAULT 0,
504 searchType
VARCHAR(255) NOT NULL DEFAULT '',
505 searchHash
CHAR(40) NOT NULL DEFAULT '',
506 KEY searchHash (searchHash
)
509 DROP TABLE IF EXISTS wcf1_session
;
510 CREATE TABLE wcf1_session (
511 sessionID
CHAR(40) NOT NULL PRIMARY KEY,
513 ipAddress
VARCHAR(39) NOT NULL DEFAULT '',
514 userAgent
VARCHAR(255) NOT NULL DEFAULT '',
515 lastActivityTime
INT(10) NOT NULL DEFAULT 0,
516 requestURI
VARCHAR(255) NOT NULL DEFAULT '',
517 requestMethod
VARCHAR(4) NOT NULL DEFAULT '',
518 controller
VARCHAR(255) NOT NULL DEFAULT '',
519 parentObjectType
VARCHAR(255) NOT NULL DEFAULT '',
520 parentObjectID
INT(10) NOT NULL DEFAULT 0,
521 objectType
VARCHAR(255) NOT NULL DEFAULT '',
522 objectID
INT(10) NOT NULL DEFAULT 0,
523 sessionVariables MEDIUMTEXT
,
525 KEY packageID (lastActivityTime
, spiderID
)
528 DROP TABLE IF EXISTS wcf1_sitemap
;
529 CREATE TABLE wcf1_sitemap (
530 sitemapID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
531 packageID
INT(10) NOT NULL,
532 sitemapName
VARCHAR(80) NOT NULL DEFAULT '',
533 className
VARCHAR(255) NOT NULL DEFAULT '',
534 showOrder
INT(10) NOT NULL DEFAULT 0,
535 UNIQUE KEY sitemapName (packageID
, sitemapName
)
538 DROP TABLE IF EXISTS wcf1_spider
;
539 CREATE TABLE wcf1_spider (
540 spiderID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
541 spiderIdentifier
VARCHAR(255) DEFAULT '',
542 spiderName
VARCHAR(255) DEFAULT '',
543 spiderURL
VARCHAR(255) DEFAULT '',
544 UNIQUE KEY spiderIdentifier (spiderIdentifier
)
547 DROP TABLE IF EXISTS wcf1_style
;
548 CREATE TABLE wcf1_style (
549 styleID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
550 packageID
INT(10) NOT NULL,
551 styleName
VARCHAR(255) NOT NULL DEFAULT '',
552 templateGroupID
INT(10) NOT NULL DEFAULT 0,
553 isDefault
TINYINT(1) NOT NULL DEFAULT 0,
554 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
555 styleDescription
VARCHAR(30) NOT NULL DEFAULT '',
556 styleVersion
VARCHAR(255) NOT NULL DEFAULT '',
557 styleDate
CHAR(10) NOT NULL DEFAULT '0000-00-00',
558 image
VARCHAR(255) NOT NULL DEFAULT '',
559 copyright
VARCHAR(255) NOT NULL DEFAULT '',
560 license
VARCHAR(255) NOT NULL DEFAULT '',
561 authorName
VARCHAR(255) NOT NULL DEFAULT '',
562 authorURL
VARCHAR(255) NOT NULL DEFAULT '',
563 imagePath
VARCHAR(255) NOT NULL DEFAULT ''
566 DROP TABLE IF EXISTS wcf1_style_variable
;
567 CREATE TABLE wcf1_style_variable (
568 variableID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
569 variableName
VARCHAR(50) NOT NULL,
570 defaultValue MEDIUMTEXT
,
571 UNIQUE KEY variableName (variableName
)
574 DROP TABLE IF EXISTS wcf1_style_variable_value
;
575 CREATE TABLE wcf1_style_variable_value (
576 styleID
INT(10) NOT NULL,
577 variableID
INT(10) NOT NULL,
578 variableValue MEDIUMTEXT
,
579 UNIQUE KEY (styleID
, variableID
)
582 DROP TABLE IF EXISTS wcf1_template
;
583 CREATE TABLE wcf1_template (
584 templateID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
585 packageID
INT(10) NOT NULL,
586 templateName
VARCHAR(255) NOT NULL DEFAULT '',
587 templateGroupID
INT(10),
588 obsolete
TINYINT(1) NOT NULL DEFAULT 0,
589 KEY packageID (packageID
, templateName
),
590 KEY templateGroupID (packageID
, templateGroupID
, templateName
)
593 DROP TABLE IF EXISTS wcf1_template_group
;
594 CREATE TABLE wcf1_template_group (
595 templateGroupID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
596 parentTemplateGroupID
INT(10) NOT NULL DEFAULT 0,
597 templateGroupName
VARCHAR(255) NOT NULL DEFAULT '',
598 templateGroupFolderName
VARCHAR(255) NOT NULL DEFAULT ''
601 DROP TABLE IF EXISTS wcf1_template_listener
;
602 CREATE TABLE wcf1_template_listener (
603 listenerID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
604 packageID
INT(10) NOT NULL,
605 name VARCHAR(80) NOT NULL DEFAULT '',
606 environment
ENUM('user','admin') NOT NULL DEFAULT 'user',
607 templateName
VARCHAR(80) NOT NULL DEFAULT '',
608 eventName
VARCHAR(50) NOT NULL DEFAULT '',
609 templateCode
TEXT NOT NULL,
610 KEY templateName (environment
, templateName
)
613 DROP TABLE IF EXISTS wcf1_user
;
614 CREATE TABLE wcf1_user (
615 userID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
616 username
VARCHAR(255) NOT NULL DEFAULT '',
617 email
VARCHAR(255) NOT NULL DEFAULT '',
618 password VARCHAR(100) NOT NULL DEFAULT '',
619 accessToken
CHAR(40) NOT NULL DEFAULT '',
620 languageID
INT(10) NOT NULL DEFAULT 0,
621 registrationDate
INT(10) NOT NULL DEFAULT 0,
622 styleID
INT(10) NOT NULL DEFAULT 0,
623 banned
TINYINT(1) NOT NULL DEFAULT 0,
624 banReason MEDIUMTEXT
NULL,
626 KEY username (username
),
627 KEY registrationDate (registrationDate
),
628 KEY styleID (styleID
)
631 DROP TABLE IF EXISTS wcf1_user_collapsible_content
;
632 CREATE TABLE wcf1_user_collapsible_content (
633 objectTypeID
INT(10) NOT NULL,
634 objectID
VARCHAR(50) NOT NULL,
635 userID
INT(10) NOT NULL,
636 UNIQUE KEY (objectTypeID
, objectID
, userID
)
639 DROP TABLE IF EXISTS wcf1_user_group
;
640 CREATE TABLE wcf1_user_group (
641 groupID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
642 groupName
VARCHAR(255) NOT NULL DEFAULT '',
643 groupType
TINYINT(1) NOT NULL DEFAULT 4
646 DROP TABLE IF EXISTS wcf1_user_group_option
;
647 CREATE TABLE wcf1_user_group_option (
648 optionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
650 optionName
VARCHAR(255) NOT NULL DEFAULT '',
651 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
652 optionType
VARCHAR(255) NOT NULL DEFAULT '',
653 defaultValue MEDIUMTEXT
,
654 adminDefaultValue MEDIUMTEXT
,
655 validationPattern
TEXT,
656 enableOptions MEDIUMTEXT
,
657 showOrder
INT(10) NOT NULL DEFAULT 0,
660 additionalData MEDIUMTEXT
,
661 UNIQUE KEY optionName (optionName
, packageID
)
664 DROP TABLE IF EXISTS wcf1_user_group_option_category
;
665 CREATE TABLE wcf1_user_group_option_category (
666 categoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
667 packageID
INT(10) NOT NULL,
668 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
669 parentCategoryName
VARCHAR(255) NOT NULL DEFAULT '',
670 showOrder
INT(10) NOT NULL DEFAULT 0,
673 UNIQUE KEY categoryName (categoryName
)
676 DROP TABLE IF EXISTS wcf1_user_group_option_value
;
677 CREATE TABLE wcf1_user_group_option_value (
678 groupID
INT(10) NOT NULL,
679 optionID
INT(10) NOT NULL,
680 optionValue MEDIUMTEXT
NOT NULL,
681 UNIQUE KEY groupID (groupID
, optionID
)
684 DROP TABLE IF EXISTS wcf1_user_option
;
685 CREATE TABLE wcf1_user_option (
686 optionID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
687 packageID
INT(10) NOT NULL,
688 optionName
VARCHAR(255) NOT NULL DEFAULT '',
689 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
690 optionType
VARCHAR(255) NOT NULL DEFAULT '',
691 defaultValue MEDIUMTEXT
,
692 validationPattern
TEXT,
693 selectOptions MEDIUMTEXT
,
694 enableOptions MEDIUMTEXT
,
695 required
TINYINT(1) NOT NULL DEFAULT 0,
696 askDuringRegistration
TINYINT(1) NOT NULL DEFAULT 0,
697 editable
TINYINT(1) NOT NULL DEFAULT 0,
698 visible
TINYINT(1) NOT NULL DEFAULT 0,
699 outputClass
VARCHAR(255) NOT NULL DEFAULT '',
700 searchable
TINYINT(1) NOT NULL DEFAULT 0,
701 showOrder
INT(10) NOT NULL DEFAULT 0,
702 isDisabled
TINYINT(1) NOT NULL DEFAULT 0,
705 additionalData MEDIUMTEXT
,
706 UNIQUE KEY optionName (optionName
, packageID
),
707 KEY categoryName (categoryName
)
710 DROP TABLE IF EXISTS wcf1_user_option_category
;
711 CREATE TABLE wcf1_user_option_category (
712 categoryID
INT(10) NOT NULL AUTO_INCREMENT
PRIMARY KEY,
713 packageID
INT(10) NOT NULL,
714 categoryName
VARCHAR(255) NOT NULL DEFAULT '',
715 parentCategoryName
VARCHAR(255) NOT NULL DEFAULT '',
716 showOrder
INT(10) NOT NULL DEFAULT 0,
719 UNIQUE KEY categoryName (categoryName
)
722 DROP TABLE IF EXISTS wcf1_user_option_value
;
723 CREATE TABLE wcf1_user_option_value (
724 userID
INT(10) NOT NULL PRIMARY KEY
727 DROP TABLE IF EXISTS wcf1_user_storage
;
728 CREATE TABLE wcf1_user_storage (
729 userID
INT(10) NOT NULL,
730 field
VARCHAR(80) NOT NULL DEFAULT '',
732 UNIQUE KEY userStorageData (userID
, field
)
735 DROP TABLE IF EXISTS wcf1_user_to_group
;
736 CREATE TABLE wcf1_user_to_group (
737 userID
INT(10) NOT NULL,
738 groupID
INT(10) NOT NULL,
739 UNIQUE KEY userID (userID
, groupID
)
742 DROP TABLE IF EXISTS wcf1_user_to_language
;
743 CREATE TABLE wcf1_user_to_language (
744 userID
INT(10) NOT NULL,
745 languageID
INT(10) NOT NULL,
746 UNIQUE KEY userID (userID
, languageID
)
750 ALTER TABLE wcf1_acl_option
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
751 ALTER TABLE wcf1_acl_option
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
753 ALTER TABLE wcf1_acl_option_category
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
754 ALTER TABLE wcf1_acl_option_category
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
756 ALTER TABLE wcf1_acl_option_to_user
ADD FOREIGN KEY (optionID
) REFERENCES wcf1_acl_option (optionID
) ON DELETE CASCADE;
757 ALTER TABLE wcf1_acl_option_to_user
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
759 ALTER TABLE wcf1_acl_option_to_group
ADD FOREIGN KEY (optionID
) REFERENCES wcf1_acl_option (optionID
) ON DELETE CASCADE;
760 ALTER TABLE wcf1_acl_option_to_group
ADD FOREIGN KEY (groupID
) REFERENCES wcf1_user_group (groupID
) ON DELETE CASCADE;
762 ALTER TABLE wcf1_acp_menu_item
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
764 ALTER TABLE wcf1_acp_search_provider
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
766 ALTER TABLE wcf1_acp_session
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
768 ALTER TABLE wcf1_acp_session_access_log
ADD FOREIGN KEY (sessionLogID
) REFERENCES wcf1_acp_session_log (sessionLogID
) ON DELETE CASCADE;
770 ALTER TABLE wcf1_acp_session_log
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE SET NULL;
772 ALTER TABLE wcf1_acp_template
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
774 ALTER TABLE wcf1_application
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
776 ALTER TABLE wcf1_category
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
778 ALTER TABLE wcf1_clipboard_action
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
780 ALTER TABLE wcf1_clipboard_item
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
782 ALTER TABLE wcf1_clipboard_page
ADD FOREIGN KEY (actionID
) REFERENCES wcf1_clipboard_action (actionID
) ON DELETE CASCADE;
783 ALTER TABLE wcf1_clipboard_page
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
785 ALTER TABLE wcf1_core_object
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
787 ALTER TABLE wcf1_cronjob
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
789 ALTER TABLE wcf1_cronjob_log
ADD FOREIGN KEY (cronjobID
) REFERENCES wcf1_cronjob (cronjobID
) ON DELETE CASCADE;
791 ALTER TABLE wcf1_event_listener
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
793 ALTER TABLE wcf1_language_item
ADD FOREIGN KEY (languageID
) REFERENCES wcf1_language (languageID
) ON DELETE CASCADE;
794 ALTER TABLE wcf1_language_item
ADD FOREIGN KEY (languageCategoryID
) REFERENCES wcf1_language_category (languageCategoryID
) ON DELETE CASCADE;
795 ALTER TABLE wcf1_language_item
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
797 ALTER TABLE wcf1_modification_log
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
798 ALTER TABLE wcf1_modification_log
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE SET NULL;
800 ALTER TABLE wcf1_object_type
ADD FOREIGN KEY (definitionID
) REFERENCES wcf1_object_type_definition (definitionID
) ON DELETE CASCADE;
801 ALTER TABLE wcf1_object_type
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
803 ALTER TABLE wcf1_object_type_definition
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
805 ALTER TABLE wcf1_option
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
807 ALTER TABLE wcf1_option_category
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
809 ALTER TABLE wcf1_package_exclusion
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
811 ALTER TABLE wcf1_package_installation_file_log
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
813 ALTER TABLE wcf1_package_installation_form
ADD FOREIGN KEY (queueID
) REFERENCES wcf1_package_installation_queue (queueID
) ON DELETE CASCADE;
815 ALTER TABLE wcf1_package_installation_node
ADD FOREIGN KEY (queueID
) REFERENCES wcf1_package_installation_queue (queueID
) ON DELETE CASCADE;
817 ALTER TABLE wcf1_package_installation_plugin
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
819 ALTER TABLE wcf1_package_installation_queue
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
820 ALTER TABLE wcf1_package_installation_queue
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE SET NULL;
822 ALTER TABLE wcf1_package_installation_sql_log
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
824 ALTER TABLE wcf1_package_requirement
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
825 ALTER TABLE wcf1_package_requirement
ADD FOREIGN KEY (requirement
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
827 ALTER TABLE wcf1_package_update
ADD FOREIGN KEY (packageUpdateServerID
) REFERENCES wcf1_package_update_server (packageUpdateServerID
) ON DELETE CASCADE;
829 ALTER TABLE wcf1_package_update_exclusion
ADD FOREIGN KEY (packageUpdateVersionID
) REFERENCES wcf1_package_update_version (packageUpdateVersionID
) ON DELETE CASCADE;
831 ALTER TABLE wcf1_package_update_fromversion
ADD FOREIGN KEY (packageUpdateVersionID
) REFERENCES wcf1_package_update_version (packageUpdateVersionID
) ON DELETE CASCADE;
833 ALTER TABLE wcf1_package_update_requirement
ADD FOREIGN KEY (packageUpdateVersionID
) REFERENCES wcf1_package_update_version (packageUpdateVersionID
) ON DELETE CASCADE;
835 ALTER TABLE wcf1_package_update_optional
ADD FOREIGN KEY (packageUpdateVersionID
) REFERENCES wcf1_package_update_version (packageUpdateVersionID
) ON DELETE CASCADE;
837 ALTER TABLE wcf1_package_update_version
ADD FOREIGN KEY (packageUpdateID
) REFERENCES wcf1_package_update (packageUpdateID
) ON DELETE CASCADE;
839 ALTER TABLE wcf1_page_menu_item
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
841 ALTER TABLE wcf1_search
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
843 ALTER TABLE wcf1_session
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
844 ALTER TABLE wcf1_session
ADD FOREIGN KEY (spiderID
) REFERENCES wcf1_spider (spiderID
) ON DELETE CASCADE;
846 ALTER TABLE wcf1_sitemap
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
848 ALTER TABLE wcf1_user_storage
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
850 ALTER TABLE wcf1_style
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
852 ALTER TABLE wcf1_style_variable_value
ADD FOREIGN KEY (styleID
) REFERENCES wcf1_style (styleID
) ON DELETE CASCADE;
853 ALTER TABLE wcf1_style_variable_value
ADD FOREIGN KEY (variableID
) REFERENCES wcf1_style_variable (variableID
) ON DELETE CASCADE;
855 ALTER TABLE wcf1_template
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
856 ALTER TABLE wcf1_template
ADD FOREIGN KEY (templateGroupID
) REFERENCES wcf1_template_group (templateGroupID
) ON DELETE CASCADE;
858 ALTER TABLE wcf1_template_listener
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
860 ALTER TABLE wcf1_user_collapsible_content
ADD FOREIGN KEY (objectTypeID
) REFERENCES wcf1_object_type (objectTypeID
) ON DELETE CASCADE;
861 ALTER TABLE wcf1_user_collapsible_content
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
863 ALTER TABLE wcf1_user_group_option
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
865 ALTER TABLE wcf1_user_group_option_category
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
867 ALTER TABLE wcf1_user_group_option_value
ADD FOREIGN KEY (groupID
) REFERENCES wcf1_user_group (groupID
) ON DELETE CASCADE;
868 ALTER TABLE wcf1_user_group_option_value
ADD FOREIGN KEY (optionID
) REFERENCES wcf1_user_group_option (optionID
) ON DELETE CASCADE;
870 ALTER TABLE wcf1_user_option
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
872 ALTER TABLE wcf1_user_option_category
ADD FOREIGN KEY (packageID
) REFERENCES wcf1_package (packageID
) ON DELETE CASCADE;
874 ALTER TABLE wcf1_user_option_value
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
876 ALTER TABLE wcf1_user_to_group
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
877 ALTER TABLE wcf1_user_to_group
ADD FOREIGN KEY (groupID
) REFERENCES wcf1_user_group (groupID
) ON DELETE CASCADE;
879 ALTER TABLE wcf1_user_to_language
ADD FOREIGN KEY (userID
) REFERENCES wcf1_user (userID
) ON DELETE CASCADE;
880 ALTER TABLE wcf1_user_to_language
ADD FOREIGN KEY (languageID
) REFERENCES wcf1_language (languageID
) ON DELETE CASCADE;
882 /* default inserts */
883 -- default user groups
884 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group1', 1);
885 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group2', 2);
886 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group3', 3);
887 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group4', 4);
888 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group5', 4);
889 INSERT INTO wcf1_user_group (groupName
, groupType
) VALUES ('wcf.acp.group.group6', 4);
891 -- default user group options
892 INSERT INTO wcf1_user_group_option (optionName
, categoryName
, optionType
, defaultValue
, adminDefaultValue
, showOrder
) VALUES ('admin.general.canUseAcp', 'admin.general', 'boolean', '0', '1', 1);
893 INSERT INTO wcf1_user_group_option (optionName
, categoryName
, optionType
, defaultValue
, adminDefaultValue
, showOrder
) VALUES ('admin.system.package.canInstallPackage', 'admin.system.package', 'boolean', '0', '1', 1);
894 INSERT INTO wcf1_user_group_option (optionName
, categoryName
, optionType
, defaultValue
, adminDefaultValue
, showOrder
) VALUES ('admin.user.canEditGroup', 'admin.user.group', 'boolean', '0', '1', 1);
896 -- default user group option values
897 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (1, 1, '0'); -- Everyone
898 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (1, 2, '0'); -- Everyone
899 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (1, 3, '0'); -- Everyone
900 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (4, 1, '1'); -- Administrators
901 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (4, 2, '1'); -- Administrators
902 INSERT INTO wcf1_user_group_option_value (groupID
, optionID
, optionValue
) VALUES (4, 3, '1'); -- Administrators
904 -- default update servers
905 INSERT INTO wcf1_package_update_server (serverURL
, status
, isDisabled
, errorMessage
, lastUpdateTime
, loginUsername
, loginPassword
) VALUES ('http://update.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
906 INSERT INTO wcf1_package_update_server (serverURL
, status
, isDisabled
, errorMessage
, lastUpdateTime
, loginUsername
, loginPassword
) VALUES ('http://store.woltlab.com/maelstrom/', 'online', 0, NULL, 0, '', '');
908 -- style default values
909 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContentBackgroundColor', 'rgba(255, 255, 255, 1)');
910 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfColor', 'rgba(102, 102, 102, 1)');
911 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfLinkColor', 'rgba(63, 127, 191, 1)');
912 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfLinkHoverColor', 'rgba(15, 79, 143, 1)');
913 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContainerBackgroundColor', 'rgba(255, 255, 255, 1)');
914 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContainerAccentBackgroundColor', 'rgba(249, 249, 249, 1)');
915 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContainerHoverBackgroundColor', 'rgba(244, 244, 244, 1)');
916 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContainerBorderColor', 'rgba(221, 221, 221, 1)');
917 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfContainerBorderRadius', '0');
918 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTabularBoxBackgroundColor', 'rgba(63, 127, 191, 1)');
919 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTabularBoxColor', 'rgba(255, 255, 255, 1)');
920 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTabularBoxHoverColor', 'rgba(255, 255, 255, 1)');
921 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfUserPanelBackgroundColor', 'rgba(45, 45, 45, 1)');
922 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfUserPanelColor', 'rgba(255, 255, 255, 1)');
923 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfUserPanelHoverColor', 'rgba(255, 255, 255, 1)');
924 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonBackgroundColor', 'rgba(249, 249, 249, 1)');
925 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonBorderColor', 'rgba(221, 221, 221, 1)');
926 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonColor', 'rgba(102, 102, 102, 1)');
927 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryBackgroundColor', 'rgba(211, 232, 254, 1)');
928 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryBorderColor', 'rgba(136, 194, 255, 1)');
929 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryColor', 'rgba(102, 153, 204, 1)');
930 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryHoverBackgroundColor', 'darken(@wcfButtonPrimaryBackgroundColor, 3%)');
931 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryHoverBorderColor', 'darken(@wcfButtonPrimaryBorderColor, 10%)');
932 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonPrimaryHoverColor', '@wcfButtonPrimaryColor');
933 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonHoverBackgroundColor', 'rgba(241, 241, 241, 1)');
934 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonHoverBorderColor', 'rgba(224, 224, 224, 1)');
935 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfButtonHoverColor', 'rgba(102, 102, 102, 1)');
936 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInputBackgroundColor', 'rgba(255, 255, 255, 1)');
937 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInputColor', 'rgba(102, 102, 102, 1)');
938 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInputBorderColor', 'rgba(204, 204, 204, 1)');
939 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInputHoverBackgroundColor', 'rgba(239, 247, 255, 1)');
940 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInputHoverBorderColor', 'rgba(198, 222, 248, 1)');
941 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfBaseFontSize', '13px');
942 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfBaseFontFamily', '"Trebuchet MS", Arial, sans-serif');
943 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfLayoutFluidGap', '30px');
944 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfLayoutFixedWidth', '1200px');
945 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfPageBackgroundColor', 'rgba(224, 224, 224, 1)');
946 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfPageColor', 'rgba(102, 102, 102, 1)');
947 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfPageLinkColor', 'rgba(63, 127, 191, 1)');
948 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfPageLinkHoverColor', 'rgba(15, 79, 143, 1)');
949 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSidebarBackgroundColor', '@wcfContainerHoverBackgroundColor');
950 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDimmedColor', 'rgba(136, 136, 136, 1)');
951 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfExtraDimmedColor', 'lighten(@wcfDimmedColor, 20%)');
952 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfLabelColor', '@wcfColor');
953 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfHeadlineColor', '@wcfColor');
954 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfHeadlineFontFamily', '"Trebuchet MS", Arial, sans-serif');
955 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDropdownBackgroundColor', '@wcfContentBackgroundColor');
956 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDropdownColor', '@wcfColor');
957 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDropdownBorderColor', '@wcfContainerBorderColor');
958 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDropdownHoverBackgroundColor', '@wcfContainerHoverBackgroundColor');
959 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfBaseLineHeight', '1.27');
960 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfHeadlineFontSize', '170%');
961 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSubHeadlineFontSize', '140%');
962 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTitleFontSize', '120%');
963 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSmallFontSize', '85%');
964 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfWarningColor', 'rgba(153, 153, 0, 1)');
965 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfWarningBackgroundColor', 'rgba(255, 255, 221, 1)');
966 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfWarningBorderColor', 'rgba(204, 204, 0, 1)');
967 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfErrorColor', 'rgba(204, 0, 0, 1)');
968 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfErrorBackgroundColor', 'rgba(255, 238, 238, 1)');
969 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfErrorBorderColor', 'rgba(255, 153, 153, 1)');
970 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSuccessColor', 'rgba(0, 153, 0, 1)');
971 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSuccessBackgroundColor', 'rgba(238, 255, 238, 1)');
972 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSuccessBorderColor', 'rgba(0, 204, 0, 1)');
973 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInfoColor', 'rgba(102, 136, 187, 1)');
974 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInfoBackgroundColor', 'rgba(221, 238, 255, 1)');
975 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfInfoBorderColor', 'rgba(153, 187, 238, 1)');
976 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTooltipBackgroundColor', 'rgba(0, 0, 0, .8)');
977 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfTooltipColor', 'rgba(255, 255, 255, 1)');
978 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfHighlightBackgroundColor', 'rgba(255, 255, 102, 1)');
979 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfGapTiny', '4px');
980 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfGapSmall', '7px');
981 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfGapMedium', '14px');
982 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfGapLarge', '21px');
983 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfNavigationHeaderBackgroundColor', '@wcfContentBackgroundColor');
984 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfNavigationFooterBackgroundColor', '@wcfContainerAccentBackgroundColor');
985 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfMainMenuBackgroundColor', '@wcfContainerAccentBackgroundColor');
986 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfMainMenuHoverBackgroundColor', '@wcfContainerAccentBackgroundColor');
987 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfMainMenuColor', '@wcfColor');
988 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfMainMenuActiveColor', '@wcfLinkColor');
989 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfUserPanelHoverBackgroundColor', 'rgba(60, 60, 60, 1)');
990 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSelectedBackgroundColor', 'rgba(255, 255, 200, 1)');
991 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfSelectedColor', '@wcfColor');
992 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDeletedBackgroundColor', 'rgba(255, 238, 238, 1)');
993 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDeletedColor', 'rgba(204, 0, 0, 1)');
994 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDisabledBackgroundColor', 'rgba(238, 255, 238, 1)');
995 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('wcfDisabledColor', 'rgba(0, 153, 0, 1)');
996 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('useFluidLayout', '1');
997 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('pageLogo', '');
998 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('individualLess', '');
999 INSERT INTO wcf1_style_variable (variableName
, defaultValue
) VALUES ('overrideLess', '');