CREATE TABLE `guildwar_arenas` (
`name` varchar(40) NOT NULL DEFAULT 'Default Arena Name',
`inuse` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL DEFAULT '0',
`guild1` int(11) DEFAULT NULL,
`guild2` int(11) DEFAULT NULL,
`start` bigint(15) NOT NULL,
`end` bigint(15) NOT NULL,
`team_a_posx` int(11) NOT NULL,
`team_a_posy` int(11) NOT NULL,
`team_a_posz` int(11) NOT NULL,
`team_b_posx` int(11) NOT NULL,
`team_b_posy` int(11) NOT NULL,
`team_b_posz` int(11) NOT NULL,
`maxplayers` int(11) DEFAULT NULL,
`pending` int(11) NOT NULL,
`duration` int(11) NOT NULL,
`challenger` int(11) NOT NULL,
`arena_team_a_pos` int(1) NOT NULL DEFAULT '0',
`playersOnTeamA` int(1) DEFAULT '0',
`playersOnTeamB` int(1) NOT NULL DEFAULT '0',
`disablepotions` int(11) DEFAULT NULL,
`exaust_ssa` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Estrutura da tabela `guildwar_kills`
--
CREATE TABLE `guildwar_kills` (
`id` int(11) NOT NULL,
`killer` varchar(50) NOT NULL,
`target` varchar(50) NOT NULL,
`killerguild` int(11) NOT NULL DEFAULT '0',
`targetguild` int(11) NOT NULL DEFAULT '0',
`warid` int(11) NOT NULL DEFAULT '0',
`time` bigint(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;