Add flag to styles that provide a dark mode

[GitHub/WoltLab/WCF.git] / wcfsetup / setup / db / install.sql

diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index f1e2bc5df69bde3e5f2fd58e4382927215165d87..4d30972ee404aa5b0f4bda5bdeed476360d136e3 100644 (file)
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -159,6 +159,7 @@ CREATE TABLE wcf1_article (
        enableComments TINYINT(1) NOT NULL DEFAULT 1,
        views MEDIUMINT(7) NOT NULL DEFAULT 0,
        cumulativeLikes MEDIUMINT(7) NOT NULL DEFAULT 0,
+       attachments SMALLINT(5) NOT NULL DEFAULT 0,
        isDeleted TINYINT(1) NOT NULL DEFAULT 0,
        hasLabels TINYINT(1) NOT NULL DEFAULT 0,
 
@@ -345,7 +346,10 @@ CREATE TABLE wcf1_captcha_question (
        questionID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        question VARCHAR(255) NOT NULL,
        answers MEDIUMTEXT,
-       isDisabled TINYINT(1) NOT NULL DEFAULT 0
+       isDisabled TINYINT(1) NOT NULL DEFAULT 0,
+       views INT(10) NOT NULL DEFAULT 0,
+       correctSubmissions INT(10) NOT NULL DEFAULT 0,
+       incorrectSubmissions INT(10) NOT NULL DEFAULT 0
 );
 
 DROP TABLE IF EXISTS wcf1_category;
@@ -933,7 +937,8 @@ CREATE TABLE wcf1_package_audit_log (
        logID BIGINT(20) NOT NULL AUTO_INCREMENT PRIMARY KEY,
        payload MEDIUMTEXT NOT NULL,
        time VARCHAR(255) NOT NULL,
-       wcfVersion VARCHAR(255) NOT NULL
+       wcfVersion VARCHAR(255) NOT NULL,
+       requestId VARCHAR(255) NOT NULL
 );
 
 DROP TABLE IF EXISTS wcf1_package_exclusion;
@@ -1316,7 +1321,7 @@ CREATE TABLE wcf1_style (
        isTainted TINYINT(1) NOT NULL DEFAULT 0,
        hasFavicon TINYINT(1) NOT NULL DEFAULT 0,
        coverPhotoExtension VARCHAR(4) NOT NULL DEFAULT '',
-       apiVersion ENUM('3.0', '3.1', '5.2', '5.5') NOT NULL DEFAULT '3.0'
+       hasDarkMode TINYINT(1) NOT NULL DEFAULT 0
 );
 
 DROP TABLE IF EXISTS wcf1_style_variable;
@@ -1399,8 +1404,8 @@ CREATE TABLE wcf1_tracked_visit (
        objectID INT(10) NOT NULL,
        userID INT(10) NOT NULL,
        visitTime INT(10) NOT NULL DEFAULT 0,
-       UNIQUE KEY (objectTypeID, objectID, userID),
-       KEY (userID, visitTime)
+       UNIQUE KEY userID_objectTypeID_objectID (userID, objectTypeID, objectID),
+       KEY visitTime (visitTime)
 );
 
 DROP TABLE IF EXISTS wcf1_tracked_visit_type;
@@ -1408,8 +1413,8 @@ CREATE TABLE wcf1_tracked_visit_type (
        objectTypeID INT(10) NOT NULL,
        userID INT(10) NOT NULL,
        visitTime INT(10) NOT NULL DEFAULT 0,
-       UNIQUE KEY (objectTypeID, userID),
-       KEY (userID, visitTime)
+       UNIQUE KEY userID_objectTypeID (userID, objectTypeID),
+       KEY visitTime (visitTime)
 );
 
 DROP TABLE IF EXISTS wcf1_trophy;