· 8 years ago · Jul 04, 2018, 10:26 AM
1DROP TABLE IF EXISTS `pvp`;
2CREATE TABLE `pvp` (
3 `char_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
4 `name` varchar(255) NOT NULL DEFAULT '0',
5 `kills` int(11) UNSIGNED NOT NULL DEFAULT '0',
6 `deaths` int(11) UNSIGNED NOT NULL DEFAULT '0',
7 KEY `char_id` (`char_id`),
8 KEY `kills` (`kills`),
9 KEY `deaths` (`deaths`)
10) TYPE=MyISAM;
11
12DROP TABLE IF EXISTS `gvg`;
13CREATE TABLE `gvg` (
14 `guild_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
15 `name` varchar(255) NOT NULL DEFAULT '0',
16 `kills` int(11) UNSIGNED NOT NULL DEFAULT '0',
17 `deaths` int(11) UNSIGNED NOT NULL DEFAULT '0',
18 KEY `guild_id` (`guild_id`),
19 KEY `kills` (`kills`),
20 KEY `deaths` (`deaths`)
21) TYPE=MyISAM;