mooka sql

DROP TABLE IF EXISTS `pvpm_data`;
DROP TABLE IF EXISTS `pvpm_map`;
DROP TABLE IF EXISTS `pvpm_lang`;

CREATE TABLE `pvpm_data` (
`id` int(11) unsigned NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`kills` int(11) unsigned NOT NULL default '0',
`dies` int(11) unsigned NOT NULL default '0',
`ratio` int(11) not null default '0',
`leader` int(11) unsigned NOT NULL default '0',
`annc` int(11) unsigned NOT NULL default '0',
`ban` int(11) unsigned NOT NULL default '0',
`type` int(11) unsigned NOT NULL default '0',
KEY `id` (`id`),
KEY `kills` (`kills`),
KEY `dies` (`dies`)
) ENGINE=MyISAM;

CREATE TABLE `pvpm_map` (
`id` int(11) unsigned NOT NULL default '0',
`map` varchar(255) NOT NULL default 'NULL',
`type` int(11) unsigned NOT NULL default '0',
`noguild` int(11) not null default '0',
KEY `id` (`id`)
) ENGINE=MyISAM;

CREATE TABLE `pvpm_lang` (
`id` int(11) unsigned NOT NULL default '0',
`lang` int(11) unsigned NOT NULL default '0',
`str` varchar(255) NOT NULL default '',
KEY `id` (`id`)
) ENGINE=MyISAM;

UPDATE `pvpm_map` SET `noguild`='1' WHERE `map` = 'guild_vs1';
INSERT INTO pvpm_map (`id`,`map`,`type`) VALUES (0,'guild_vs3',0);
INSERT INTO pvpm_map (`id`,`map`,`type`) VALUES (1,'pvp_n_1-5',0);
INSERT INTO pvpm_map (`id`,`map`,`type`) VALUES (2,'guild_vs1',2);
INSERT INTO pvpm_map (`id`,`map`,`type`) VALUES (3,'prt_are01',2);
INSERT INTO pvpm_map (`id`,`map`,`type`) VALUES (4,'guild_vs2',1);