All pastes #618910 Raw Edit

Someone

public text v1 · immutable
·published 2007-07-14 08:35 UTC
rendered paste body
DROP 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',      
            PRIMARY KEY  (`charterId`),                           
            UNIQUE KEY `leaderGuid` (`leaderGuid`)                
          ) ENGINE=MyISAM DEFAULT CHARSET=latin1