21 lines
726 B
SQL
21 lines
726 B
SQL
CREATE TABLE IF NOT EXISTS `seven_signs_festival` (
|
|
`festivalId` int(1) NOT NULL default '0',
|
|
`cabal` varchar(4) NOT NULL default '',
|
|
`cycle` int(4) NOT NULL default '0',
|
|
`date` bigint(13) unsigned NOT NULL DEFAULT '0',
|
|
`score` int(5) NOT NULL default '0',
|
|
`members` varchar(255) NOT NULL default '',
|
|
PRIMARY KEY (`festivalId`,`cabal`,`cycle`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
INSERT IGNORE INTO `seven_signs_festival` VALUES
|
|
(0, "dawn", 1, 0, 0, ""),
|
|
(1, "dawn", 1, 0, 0, ""),
|
|
(2, "dawn", 1, 0, 0, ""),
|
|
(3, "dawn", 1, 0, 0, ""),
|
|
(4, "dawn", 1, 0, 0, ""),
|
|
(0, "dusk", 1, 0, 0, ""),
|
|
(1, "dusk", 1, 0, 0, ""),
|
|
(2, "dusk", 1, 0, 0, ""),
|
|
(3, "dusk", 1, 0, 0, ""),
|
|
(4, "dusk", 1, 0, 0, ""); |