1 DROP TABLE IF EXISTS `guild_charter`;
2 CREATE TABLE `guild_charter` (
3 `ownerguid` int(10) unsigned NOT NULL,
4 `charterguid` int(10) unsigned default '0',
5 `guildname` varchar(255) NOT NULL default '',
6 PRIMARY KEY (`ownerguid`),
7 UNIQUE KEY `index_ownerguid_charterguid` (`ownerguid`,`charterguid`)
8 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
10 DROP TABLE IF EXISTS `guild_charter_sign`;
11 CREATE TABLE `guild_charter_sign` (
12 `ownerguid` int(10) unsigned NOT NULL,
13 `charterguid` int(11) unsigned default '0',
14 `playerguid` int(11) unsigned default '0',
15 PRIMARY KEY (`charterguid`,`playerguid`)
16 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';