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 9bb31f09f156c2c467f57f001390150b84bc06f2..4d30972ee404aa5b0f4bda5bdeed476360d136e3 100644 (file)
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -346,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;
@@ -934,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 +1320,8 @@ CREATE TABLE wcf1_style (
        packageName VARCHAR(255) NOT NULL DEFAULT '',
        isTainted TINYINT(1) NOT NULL DEFAULT 0,
        hasFavicon TINYINT(1) NOT NULL DEFAULT 0,
-       coverPhotoExtension VARCHAR(4) NOT NULL DEFAULT ''
+       coverPhotoExtension VARCHAR(4) NOT NULL DEFAULT '',
+       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;