· 10 years ago · Sep 18, 2016, 10:52 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : local
5Source Server Version : 50715
6Source Host : localhost:3306
7Source Database : rok
8
9Target Server Type : MYSQL
10Target Server Version : 50715
11File Encoding : 65001
12
13Date: 2016-09-19 10:50:01
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for announcements
20-- ----------------------------
21DROP TABLE IF EXISTS `announcements`;
22CREATE TABLE `announcements` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `message` varchar(255) DEFAULT '',
25 `colour` varchar(50) DEFAULT 'Red',
26 PRIMARY KEY (`id`)
27) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
28
29-- ----------------------------
30-- Records of announcements
31-- ----------------------------
32INSERT INTO `announcements` VALUES ('1', 'Welcome to my server!', 'Red');
33
34-- ----------------------------
35-- Table structure for marketplace
36-- ----------------------------
37DROP TABLE IF EXISTS `marketplace`;
38CREATE TABLE `marketplace` (
39 `id` int(11) NOT NULL AUTO_INCREMENT,
40 `name` varchar(50) DEFAULT 'Default',
41 `price_buy` int(11) DEFAULT '0',
42 `price_sell` int(11) DEFAULT '0',
43 `amount` int(11) DEFAULT '0',
44 PRIMARY KEY (`id`)
45) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
46
47-- ----------------------------
48-- Records of marketplace
49-- ----------------------------
50INSERT INTO `marketplace` VALUES ('1', 'Steel Crest', '1500', '1500', '5');
51
52-- ----------------------------
53-- Table structure for players
54-- ----------------------------
55DROP TABLE IF EXISTS `players`;
56CREATE TABLE `players` (
57 `id` bigint(20) NOT NULL,
58 `has_protection` enum('1','0') DEFAULT '1',
59 `protection_left` int(11) DEFAULT '900',
60 `currency` int(11) DEFAULT '1500',
61 `kills` int(11) DEFAULT '0',
62 `warnings` int(11) DEFAULT '0',
63 `originalname` varchar(255) DEFAULT '',
64 `currentname` varchar(255) DEFAULT '',
65 PRIMARY KEY (`id`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8;
67
68-- ----------------------------
69-- Records of players
70-- ----------------------------
71
72-- ----------------------------
73-- Table structure for plugin_settings
74-- ----------------------------
75DROP TABLE IF EXISTS `plugin_settings`;
76CREATE TABLE `plugin_settings` (
77 `disable_decresting` int(1) NOT NULL DEFAULT '0',
78 `announce_interval` int(11) DEFAULT '300',
79 `currency_interval` int(11) DEFAULT '800',
80 `currency_interval_amount` int(11) DEFAULT '150',
81 PRIMARY KEY (`disable_decresting`)
82) ENGINE=InnoDB DEFAULT CHARSET=utf8;
83
84-- ----------------------------
85-- Records of plugin_settings
86-- ----------------------------
87INSERT INTO `plugin_settings` VALUES ('0', '300', '800', '150');
88
89-- ----------------------------
90-- Table structure for rules
91-- ----------------------------
92DROP TABLE IF EXISTS `rules`;
93CREATE TABLE `rules` (
94 `id` int(11) NOT NULL AUTO_INCREMENT,
95 `rule` varchar(255) DEFAULT 'Do not eat humans',
96 PRIMARY KEY (`id`)
97) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
98
99-- ----------------------------
100-- Records of rules
101-- ----------------------------
102INSERT INTO `rules` VALUES ('1', 'Do not eat humans');
103SET FOREIGN_KEY_CHECKS=1;