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