Commit | Line | Data |
---|---|---|
ae03c54e AE |
1 | DROP TABLE IF EXISTS wcf1_acl_simple_to_user; |
2 | CREATE TABLE wcf1_acl_simple_to_user ( | |
3 | objectTypeID INT(10) NOT NULL, | |
4 | objectID INT(10) NOT NULL, | |
5 | userID INT(10) NOT NULL, | |
6 | UNIQUE KEY userKey (objectTypeID, objectID, userID) | |
7 | ); | |
8 | ||
9 | DROP TABLE IF EXISTS wcf1_acl_simple_to_group; | |
10 | CREATE TABLE wcf1_acl_simple_to_group ( | |
11 | objectTypeID INT(10) NOT NULL, | |
12 | objectID INT(10) NOT NULL, | |
13 | groupID INT(10) NOT NULL, | |
14 | UNIQUE KEY groupKey (objectTypeID, objectID, groupID) | |
15 | ); | |
16 | ||
17 | ALTER TABLE wcf1_acp_menu_item ADD icon VARCHAR(255) NOT NULL DEFAULT ''; | |
18 | ||
19 | ALTER TABLE wcf1_acp_session DROP COLUMN controller; | |
20 | ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectType; | |
21 | ALTER TABLE wcf1_acp_session DROP COLUMN parentObjectID; | |
22 | ALTER TABLE wcf1_acp_session DROP COLUMN objectType; | |
23 | ALTER TABLE wcf1_acp_session DROP COLUMN objectID; | |
ae03c54e AE |
24 | |
25 | ALTER TABLE wcf1_application DROP COLUMN cookiePath; | |
26 | ALTER TABLE wcf1_application DROP COLUMN isPrimary; | |
27 | ALTER TABLE wcf1_application ADD isTainted TINYINT(1) NOT NULL DEFAULT 0; | |
28 | ||
29 | DROP TABLE IF EXISTS wcf1_article; | |
30 | CREATE TABLE wcf1_article ( | |
31 | articleID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
32 | userID INT(10), | |
33 | username VARCHAR(255) NOT NULL DEFAULT '', | |
34 | time INT(10) NOT NULL DEFAULT 0, | |
35 | categoryID INT(10), | |
36 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
37 | publicationStatus TINYINT(1) NOT NULL DEFAULT 1, | |
38 | publicationDate INT(10) NOT NULL DEFAULT 0, | |
39 | enableComments TINYINT(1) NOT NULL DEFAULT 1, | |
40 | comments SMALLINT(5) NOT NULL DEFAULT 0, | |
41 | views MEDIUMINT(7) NOT NULL DEFAULT 0, | |
42 | cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0, | |
43 | ||
44 | KEY (time) | |
45 | ); | |
46 | ||
47 | DROP TABLE IF EXISTS wcf1_article_content; | |
48 | CREATE TABLE wcf1_article_content ( | |
49 | articleContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
50 | articleID INT(10) NOT NULL, | |
51 | languageID INT(10), | |
52 | title VARCHAR(255) NOT NULL, | |
53 | teaser TEXT, | |
54 | content MEDIUMTEXT, | |
55 | imageID INT(10), | |
56 | hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, | |
57 | ||
58 | UNIQUE KEY (articleID, languageID) | |
59 | ); | |
60 | ||
61 | DROP TABLE IF EXISTS wcf1_background_job; | |
62 | CREATE TABLE wcf1_background_job ( | |
63 | jobID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
64 | job MEDIUMBLOB NOT NULL, | |
65 | status ENUM('ready', 'processing') NOT NULL DEFAULT 'ready', | |
66 | time INT(10) NOT NULL, | |
67 | KEY (status, time) | |
68 | ); | |
69 | ||
70 | ALTER TABLE wcf1_bbcode DROP COLUMN allowedChildren; | |
71 | ALTER TABLE wcf1_bbcode DROP COLUMN isDisabled; | |
72 | ALTER TABLE wcf1_bbcode ADD isBlockElement TINYINT(1) NOT NULL DEFAULT 0; | |
73 | ||
74 | DROP TABLE IF EXISTS wcf1_box; | |
75 | CREATE TABLE wcf1_box ( | |
76 | boxID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
77 | objectTypeID INT(10), | |
78 | identifier VARCHAR(255) NOT NULL, | |
79 | name VARCHAR(255) NOT NULL, | |
80 | boxType VARCHAR(255) NOT NULL, | |
81 | position VARCHAR(255) NOT NULL, | |
82 | showOrder INT(10) NOT NULL DEFAULT 0, | |
83 | visibleEverywhere TINYINT(1) NOT NULL DEFAULT 1, | |
84 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
85 | cssClassName VARCHAR(255) NOT NULL DEFAULT '', | |
86 | showHeader TINYINT(1) NOT NULL DEFAULT 1, | |
87 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
88 | packageID INT(10) NOT NULL, | |
89 | menuID INT(10) NULL, | |
90 | linkPageID INT(10), | |
91 | linkPageObjectID INT(10) NOT NULL DEFAULT 0, | |
92 | externalURL VARCHAR(255) NOT NULL DEFAULT '', | |
93 | additionalData TEXT | |
94 | ); | |
95 | ||
96 | DROP TABLE IF EXISTS wcf1_box_content; | |
97 | CREATE TABLE wcf1_box_content ( | |
98 | boxContentID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
99 | boxID INT(10) NOT NULL, | |
100 | languageID INT(10), | |
101 | title VARCHAR(255) NOT NULL, | |
102 | content MEDIUMTEXT, | |
103 | imageID INT(10), | |
104 | hasEmbeddedObjects TINYINT(1) NOT NULL DEFAULT 0, | |
105 | ||
106 | UNIQUE KEY (boxID, languageID) | |
107 | ); | |
108 | ||
109 | DROP TABLE IF EXISTS wcf1_box_to_page; | |
110 | CREATE TABLE wcf1_box_to_page ( | |
111 | boxID INT(10) NOT NULL, | |
112 | pageID INT(10) NOT NULL, | |
113 | visible TINYINT(1) NOT NULL DEFAULT 1, | |
114 | ||
115 | UNIQUE KEY (pageID, boxID), | |
116 | KEY (pageID, visible) | |
117 | ); | |
118 | ||
119 | ALTER TABLE wcf1_clipboard_item ADD KEY (userID); | |
120 | ||
121 | ALTER TABLE wcf1_cronjob ADD cronjobName VARCHAR(191) NOT NULL; | |
122 | ALTER TABLE wcf1_cronjob ADD options TEXT; | |
123 | UPDATE wcf1_cronjob SET cronjobName = CONCAT('com.woltlab.wcf.generic', cronjobID); | |
124 | ALTER TABLE wcf1_cronjob ADD UNIQUE KEY cronjobName (cronjobName, packageID); | |
125 | ||
126 | DROP TABLE IF EXISTS wcf1_dashboard_option; | |
127 | DROP TABLE IF EXISTS wcf1_dashboard_box; | |
128 | ||
129 | -- we have to drop the foreign key first to drop the normal key | |
130 | ALTER TABLE wcf1_event_listener DROP FOREIGN KEY packageID; | |
131 | ALTER TABLE wcf1_event_listener DROP KEY packageID; | |
132 | ALTER TABLE wcf1_event_listener ADD listenerName VARCHAR(191) NOT NULL; | |
133 | ALTER TABLE wcf1_event_listener CHANGE eventName eventName TEXT; | |
134 | ALTER TABLE wcf1_event_listener ADD permissions TEXT; | |
135 | ALTER TABLE wcf1_event_listener ADD options TEXT; | |
136 | ||
137 | UPDATE wcf1_event_listener SET listenerName = CONCAT('com.woltlab.wcf.generic', listenerID); | |
138 | ALTER TABLE wcf1_event_listener ADD UNIQUE KEY listenerName (listenerName, packageID); | |
139 | ||
140 | ALTER TABLE wcf1_label ADD showOrder INT(10) NOT NULL DEFAULT 0; | |
141 | ||
142 | ALTER TABLE wcf1_language ADD isDisabled TINYINT(1) NOT NULL DEFAULT 0; | |
143 | ||
144 | DROP TABLE IF EXISTS wcf1_language_server; |