GvGpLCm9

1DROP TABLE IF EXISTS `twinklero`.`pvpladder`;
2CREATE TABLE  `twinklero`.`pvpladder` (
3  `char_id` int(11) NOT NULL default '0',
4  `name` varchar(30) NOT NULL default '',
5  `streaks` smallint(6) unsigned NOT NULL default '0',
6  `kills` smallint(6) unsigned NOT NULL default '0',
7  `deaths` smallint(6) unsigned NOT NULL default '0',
8  `streaktime` datetime default NULL,
9  PRIMARY KEY  (`char_id`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1;
11
12
13DROP TABLE IF EXISTS `twinklero`.`ownladder`;
14CREATE TABLE  `twinklero`.`ownladder` (
15  `guild_id` int(11) NOT NULL default '0',
16  `name` varchar(24) NOT NULL default '',
17  `currentown` smallint(6) unsigned NOT NULL default '0',
18  `highestown` smallint(6) unsigned NOT NULL default '0',
19  `owntime` datetime default NULL,
20  PRIMARY KEY  (`guild_id`)
21) ENGINE=MyISAM DEFAULT CHARSET=latin1;
22
23
24DROP TABLE IF EXISTS `twinklero`.`mvp`;
25CREATE TABLE  `twinklero`.`mvp` (
26  `char_id` int(11) unsigned NOT NULL auto_increment,
27  `name` varchar(255) NOT NULL default '0',
28  `kills` int(11) unsigned NOT NULL default '0',
29  `points` int(11) unsigned NOT NULL default '0',
30  `level` int(11) unsigned NOT NULL default '0',
31  KEY `char_id` (`char_id`),
32  KEY `kills` (`kills`),
33  KEY `points` (`level`),
34  KEY `level` (`level`)
35) ENGINE=MyISAM AUTO_INCREMENT=156262 DEFAULT CHARSET=latin1;