· 10 years ago · Aug 25, 2016, 09:38 PM
1DROP TABLE IF EXISTS `t_user_guild`;
2CREATE TABLE `t_user_guild` (
3 `guildid` bigint(21) NOT NULL default '0',
4 `deleted` tinyint(4) default '0',
5 `todeletetime` int(11) default '0',
6 `level` int(11) default '0',
7 `bosspv` int(11) default '0',
8 `name` varchar(32) default NULL,
9 `boss` bigint(21) default '0',
10 `bulletin` varchar(255) default NULL,
11 `member` blob,
12 `memberdata` blob,
13 `icon` blob,
14 `guildmoney` int(11) default '0',
15 `membercontrib` blob,
16 `household` blob,
17 `userdata` blob,
18 `bundguild` blob,
19 PRIMARY KEY (`guildid`)
20) ENGINE=MyISAM DEFAULT CHARSET=latin1;