projects / GitHub / WoltLab / WCF.git / blame
| Commit | Line | Data |
|---|---|---|
| ae03c54e AE |
1 | DROP TABLE IF EXISTS wcf1_media; |
| 2 | CREATE TABLE wcf1_media ( | |
| 3 | mediaID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 4 | ||
| 5 | filename VARCHAR(255) NOT NULL DEFAULT '', | |
| 6 | filesize INT(10) NOT NULL DEFAULT 0, | |
| 7 | fileType VARCHAR(255) NOT NULL DEFAULT '', | |
| 8 | fileHash VARCHAR(255) NOT NULL DEFAULT '', | |
| 9 | uploadTime INT(10) NOT NULL DEFAULT 0, | |
| 10 | userID INT(10), | |
| 11 | username VARCHAR(255) NOT NULL, | |
| 12 | languageID INT(10), | |
| 13 | isMultilingual TINYINT(1) NOT NULL DEFAULT 0, | |
| 14 | ||
| 15 | isImage TINYINT(1) NOT NULL DEFAULT 0, | |
| 16 | width SMALLINT(5) NOT NULL DEFAULT 0, | |
| 17 | height SMALLINT(5) NOT NULL DEFAULT 0, | |
| 18 | ||
| 19 | tinyThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
| 20 | tinyThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
| 21 | tinyThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
| 22 | tinyThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
| 23 | ||
| 24 | smallThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
| 25 | smallThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
| 26 | smallThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
| 27 | smallThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
| 28 | ||
| 29 | mediumThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
| 30 | mediumThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
| 31 | mediumThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
| 32 | mediumThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0, | |
| 33 | ||
| 34 | largeThumbnailType VARCHAR(255) NOT NULL DEFAULT '', | |
| 35 | largeThumbnailSize INT(10) NOT NULL DEFAULT 0, | |
| 36 | largeThumbnailWidth SMALLINT(5) NOT NULL DEFAULT 0, | |
| 37 | largeThumbnailHeight SMALLINT(5) NOT NULL DEFAULT 0 | |
| 38 | ); | |
| 39 | ||
| 40 | DROP TABLE IF EXISTS wcf1_media_content; | |
| 41 | CREATE TABLE wcf1_media_content ( | |
| 42 | mediaID INT(10) NOT NULL, | |
| 43 | languageID INT(10), | |
| 44 | title VARCHAR(255) NOT NULL, | |
| 45 | caption TEXT, | |
| 46 | altText VARCHAR(255) NOT NULL DEFAULT '', | |
| 47 | UNIQUE KEY (mediaID, languageID) | |
| 48 | ); | |
| 49 | ||
| 50 | DROP TABLE IF EXISTS wcf1_menu; | |
| 51 | CREATE TABLE wcf1_menu ( | |
| 52 | menuID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 53 | identifier VARCHAR(255) NOT NULL, | |
| 54 | title VARCHAR(255) NOT NULL, | |
| 55 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
| 56 | packageID INT(10) NOT NULL | |
| 57 | ); | |
| 58 | ||
| 59 | DROP TABLE IF EXISTS wcf1_menu_item; | |
| 60 | CREATE TABLE wcf1_menu_item ( | |
| 61 | itemID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, | |
| 62 | menuID INT(10) NOT NULL, | |
| 63 | parentItemID INT(10), | |
| 64 | identifier VARCHAR(255) NOT NULL, | |
| 65 | title VARCHAR(255) NOT NULL, | |
| 66 | pageID INT(10), | |
| 67 | pageObjectID INT(10) NOT NULL DEFAULT 0, | |
| 68 | externalURL VARCHAR(255) NOT NULL DEFAULT '', | |
| 69 | showOrder INT(10) NOT NULL DEFAULT 0, | |
| 70 | isDisabled TINYINT(1) NOT NULL DEFAULT 0, | |
| 71 | originIsSystem TINYINT(1) NOT NULL DEFAULT 0, | |
| 72 | packageID INT(10) NOT NULL | |
| 73 | ); | |
| 74 | ||
| 75 | ALTER TABLE wcf1_modification_log ADD parentObjectID INT(10); | |
| 76 | ||
| 77 | ALTER TABLE wcf1_package_update_version DROP COLUMN isCritical; | |
| 78 | ||
| 79 | DROP TABLE IF EXISTS wcf1_page_menu_item; |