PqWDgwS2

1-- OBS: Preste atenção nos updates, eles são por versão.
2
3-- v1.0.0+
4DROP TABLE IF EXISTS `pvpm_data`;
5CREATE TABLE `pvpm_data` (
6`id` int(11) unsigned NOT NULL default '0',
7`name` varchar(255) NOT NULL default '',
8`kills` int(11) unsigned NOT NULL default '0',
9`dies` int(11) unsigned NOT NULL default '0',
10`leader` int(11) unsigned NOT NULL default '0',
11`annc` int(11) unsigned NOT NULL default '0',
12`ban` int(11) unsigned NOT NULL default '0',
13`type` int(11) unsigned NOT NULL default '0',
14KEY `id` (`id`),
15KEY `kills` (`kills`),
16KEY `dies` (`dies`)
17) ENGINE=MyISAM;
18
19-- v1.1.1+
20alter table pvpm_data add ratio int(11) not null default '0' after dies;
21
22-- v1.1.7+
23DROP TABLE IF EXISTS `pvpm_map`;
24CREATE TABLE `pvpm_map` (
25`id` int(11) unsigned NOT NULL default '0',
26`map` varchar(255) NOT NULL default 'NULL',
27`type` int(11) unsigned NOT NULL default '0',
28KEY `id` (`id`)
29) ENGINE=MyISAM;
30insert into pvpm_map (id,map,type) values (0,'arena01',0);
31insert into pvpm_map (id,map,type) values (1,'arena_pvp',0);
32insert into pvpm_map (id,map,type) values (2,'guild_vs1',2);
33insert into pvpm_map (id,map,type) values (3,'guild_vs2',2);
34insert into pvpm_map (id,map,type) values (4,'dali',1);
35
36-- v1.2.3+
37alter table pvpm_map add noguild int(11) not null default '0';
38update pvpm_map set noguild=1 where map='guild_vs1';
39
40-- v1.3.0+
41
42DROP TABLE IF EXISTS `pvpm_lang`;
43CREATE TABLE IF NOT EXISTS `pvpm_lang` (
44  `id` int(11) unsigned NOT NULL,
45  `lang` int(11) unsigned NOT NULL default '0',
46  `str` varchar(255) NOT NULL default '',
47  KEY `id` (`id`)
48) ENGINE=MyISAM DEFAULT CHARSET=latin1;