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;
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;
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;