18 lines
623 B
SQL
18 lines
623 B
SQL
CREATE TABLE IF NOT EXISTS `events` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`token` varchar(36) NOT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `token` (`token`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|
|
|
|
CREATE TABLE IF NOT EXISTS `hashes` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`event` int(11) NOT NULL,
|
|
`vote_round` int(11) NOT NULL,
|
|
`name` varchar(128) NOT NULL,
|
|
`hash` varchar(128) DEFAULT NULL,
|
|
PRIMARY KEY (`id`),
|
|
UNIQUE KEY `event` (`event`,`vote_round`,`name`),
|
|
CONSTRAINT `hashes_ibfk_1` FOREIGN KEY (`event`) REFERENCES `events` (`id`) ON DELETE CASCADE
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|