· 5 years ago · Oct 12, 2020, 12:56 AM
1-- ----------------------------
2-- Table structure for guild
3-- ----------------------------
4DROP TABLE IF EXISTS `guild`;
5CREATE TABLE `guild` (
6 `GuildId` int(11) NOT NULL AUTO_INCREMENT,
7 `GuildName` varchar(12) DEFAULT NULL,
8 `Owner` varchar(16) DEFAULT NULL,
9 `GuildRank` int(11) DEFAULT NULL,
10 `MemberCount` int(11) DEFAULT NULL,
11 `GuildScore` int(11) DEFAULT NULL,
12 `GuildBio` blob,
13 `MinRankReq` int(11) DEFAULT NULL,
14 `MaxRankReq` int(11) DEFAULT NULL,
15 `Active` int(11) DEFAULT '1',
16 PRIMARY KEY (`GuildId`)
17) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
18
19SET FOREIGN_KEY_CHECKS = 1;
20