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 9eac8fb585ae7bf5cba24f3d2b9d428050c99e1f..4d30972ee404aa5b0f4bda5bdeed476360d136e3 100644 (file)
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -1320,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;
@@ -1403,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;
@@ -1412,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;