· 8 years ago · Nov 26, 2017, 12:40 PM
1DROP TABLE IF EXISTS `guild_news`;
2CREATE TABLE `guild_news` (
3 `guildid` int(12) NOT NULL,
4 `type` int(10) NOT NULL,
5 `date` int(12) NOT NULL,
6 `value1` int(10) NOT NULL,
7 `value2` int(10) NOT NULL,
8 `source_guid` int(12) NOT NULL,
9 `flags` int(10) NOT NULL,
10 PRIMARY KEY (`guildid`)
11) ENGINE=InnoDB DEFAULT CHARSET=utf8;