Commit | Line | Data |
---|---|---|
fdc818f0 MW |
1 | DROP TABLE IF EXISTS wcf1_page; |
2 | CREATE TABLE wcf1_page ( | |
3 | pageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
4 | parentPageID INT(10), | |
5 | identifier VARCHAR(255) NOT NULL, | |
6 | name VARCHAR(255) NOT NULL, | |
7 | pageType VARCHAR(255) NOT NULL, | |
8 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
9 | isLandingPage TINYINT(1) NOT NULL DEFAULT 0, | |
10 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
11 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
12 | packageID INT(10) NOT NULL, | |
13 | applicationPackageID INT(10), | |
14 | controller VARCHAR(255) NOT NULL DEFAULT '', | |
15 | handler VARCHAR(255) NOT NULL DEFAULT '', | |
16 | controllerCustomURL VARCHAR(255) NOT NULL DEFAULT '', | |
17 | requireObjectID TINYINT(1) NOT NULL DEFAULT 0, | |
18 | hasFixedParent TINYINT(1) NOT NULL DEFAULT 0, | |
19 | lastUpdateTime INT(10) NOT NULL DEFAULT 0, | |
20 | permissions TEXT NULL, | |
21 | options TEXT NULL | |
22 | ); | |
23 | ||
24 | DROP TABLE IF EXISTS wcf1_page_content; | |
25 | CREATE TABLE wcf1_page_content ( | |
26 | pageContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
27 | pageID INT(10) NOT NULL, | |
28 | languageID INT(10), | |
29 | title VARCHAR(255) NOT NULL, | |
30 | content MEDIUMTEXT, | |
31 | metaDescription TEXT, | |
32 | metaKeywords TEXT, | |
33 | customURL VARCHAR(255) NOT NULL, | |
34 | hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, | |
35 | ||
36 | UNIQUE KEY (pageID, languageID) | |
37 | ); | |
2e19e2c7 MW |
38 | |
39 | UPDATE wcf1_user_group_option SET optionName = 'admin.configuration.package.canInstallPackage', categoryName = 'admin.configuration.package' WHERE optionName = 'admin.system.package.canInstallPackage'; |