· 8 years ago · Nov 15, 2017, 06:58 PM
1CREATE TABLE IF NOT EXISTS `pocketvote_checks` (
2 `server_hash` VARCHAR(255) NOT NULL,
3 `vote_id` INT(10) UNSIGNED NOT NULL DEFAULT 0,
4 `timestamp` INT(10) UNSIGNED NOT NULL DEFAULT 0,
5 INDEX `server_hash` (`server_hash`),
6 INDEX `FK_vote_id_pocketvote_votes` (`vote_id`),
7 CONSTRAINT `FK_vote_id_pocketvote_votes` FOREIGN KEY (`vote_id`) REFERENCES `pocketvote_votes` (`id`) ON UPDATE CASCADE ON DELETE CASCADE
8)
9ENGINE=InnoDB
10;