| 1 | DROP TABLE IF EXISTS wcf1_package_compatibility; |
| 2 | CREATE TABLE wcf1_package_compatibility ( |
| 3 | packageID INT(10) NOT NULL, |
| 4 | version SMALLINT(4) NOT NULL, |
| 5 | UNIQUE KEY compatibleVersion (packageID, version) |
| 6 | ); |
| 7 | |
| 8 | DROP TABLE IF EXISTS wcf1_package_update_compatibility; |
| 9 | CREATE TABLE wcf1_package_update_compatibility ( |
| 10 | packageUpdateVersionID INT(10) NOT NULL, |
| 11 | version SMALLINT(4) NOT NULL, |
| 12 | UNIQUE KEY compatibleVersion (packageUpdateVersionID, version) |
| 13 | ); |
| 14 | |
| 15 | ALTER TABLE wcf1_package_compatibility ADD FOREIGN KEY (packageID) REFERENCES wcf1_package (packageID) ON DELETE CASCADE; |
| 16 | |
| 17 | ALTER TABLE wcf1_package_update_compatibility ADD FOREIGN KEY (packageUpdateVersionID) REFERENCES wcf1_package_update_version (packageUpdateVersionID) ON DELETE CASCADE; |
| 18 | |
| 19 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://update.woltlab.com/tornado/', 'online', 0, NULL, 0, '', ''); |
| 20 | INSERT INTO wcf1_package_update_server (serverURL, status, isDisabled, errorMessage, lastUpdateTime, loginUsername, loginPassword) VALUES ('http://store.woltlab.com/tornado/', 'online', 0, NULL, 0, '', ''); |