rendered paste bodyDROP TABLE IF EXISTS `charters`;
CREATE TABLE `charters` (
`charterId` int(30) NOT NULL default '0',
`leaderGuid` int(20) unsigned NOT NULL default '0',
`guildName` varchar(32) NOT NULL default '',
`itemGuid` bigint(40) unsigned NOT NULL default '0',
`signer1` int(10) unsigned NOT NULL default '0',
`signer2` int(10) unsigned NOT NULL default '0',
`signer3` int(10) unsigned NOT NULL default '0',
`signer4` int(10) unsigned NOT NULL default '0',
`signer5` int(10) unsigned NOT NULL default '0',
`signer6` int(10) unsigned NOT NULL default '0',
`signer7` int(10) unsigned NOT NULL default '0',
`signer8` int(10) unsigned NOT NULL default '0',
`signer9` int(10) unsigned NOT NULL default '0',
KEY `index` (`charterId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;