ZJWMfdwF

1/*
2Navicat MySQL Data Transfer
3
4Source Server         : localhost
5Source Server Version : 50508
6Source Host           : localhost:3306
7Source Database       : ragnarok
8
9Target Server Type    : MYSQL
10Target Server Version : 50508
11File Encoding         : 65001
12
13Date: 2011-10-14 17:51:34
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for `mod_1x1`
20-- ----------------------------
21DROP TABLE IF EXISTS `mod_1x1`;
22CREATE TABLE `mod_1x1` (
23  `char_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
24  `name` varchar(255) NOT NULL DEFAULT '0',
25  `kills` int(10) unsigned NOT NULL DEFAULT '0',
26  `deaths` int(10) unsigned NOT NULL DEFAULT '0',
27  PRIMARY KEY (`char_id`)
28) ENGINE=InnoDB AUTO_INCREMENT=150003 DEFAULT CHARSET=latin1;
29
30-- ----------------------------
31-- Records of mod_1x1
32-- ----------------------------
33
34-- ----------------------------
35-- Table structure for `mod_gvg`
36-- ----------------------------
37DROP TABLE IF EXISTS `mod_gvg`;
38CREATE TABLE `mod_gvg` (
39  `guild_id` int(11) NOT NULL,
40  `deaths` int(11) NOT NULL,
41  `kills` int(11) NOT NULL,
42  `name` varchar(30) NOT NULL
43) ENGINE=MyISAM DEFAULT CHARSET=latin1;
44
45-- ----------------------------
46-- Records of mod_gvg
47-- ----------------------------
48
49-- ----------------------------
50-- Table structure for `mod_pvp`
51-- ----------------------------
52DROP TABLE IF EXISTS `mod_pvp`;
53CREATE TABLE `mod_pvp` (
54  `char_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
55  `name` varchar(255) NOT NULL DEFAULT '0',
56  `kills` int(10) unsigned NOT NULL DEFAULT '0',
57  `deaths` int(10) unsigned NOT NULL DEFAULT '0',
58  PRIMARY KEY (`char_id`)
59) ENGINE=InnoDB AUTO_INCREMENT=150003 DEFAULT CHARSET=latin1;
60
61-- ----------------------------
62-- Records of mod_pvp
63-- ----------------------------