com.woltlab.wcf/update_2.sql

   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;