· 7 years ago · Nov 12, 2018, 06:50 PM
1CREATE TABLE IF NOT EXISTS `guild_wars` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `status` int(11) NOT NULL,
4 `guildname_started` varchar(255) NOT NULL,
5 `frags_started` int(11) NOT NULL,
6 `guildname_accepted` varchar(255) NOT NULL,
7 `frags_accepted` int(11) NOT NULL,
8 `frag_limit` int(11) NOT NULL,
9 `datestart` bigint(20) NOT NULL,
10 `dateend` bigint(20) NOT NULL,
11 UNIQUE KEY `id` (`id`)
12) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;