· 10 years ago · Sep 18, 2016, 11:02 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:59:36
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- ----------------------------
19-- Table structure for admins
20-- ----------------------------
21DROP TABLE IF EXISTS `admins`;
22CREATE TABLE `admins` (
23 `id` int(11) NOT NULL AUTO_INCREMENT,
24 `steamid` bigint(64) NOT NULL,
25 PRIMARY KEY (`id`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8;
27
28-- ----------------------------
29-- Records of admins
30-- ----------------------------
31
32-- ----------------------------
33-- Table structure for announcements
34-- ----------------------------
35DROP TABLE IF EXISTS `announcements`;
36CREATE TABLE `announcements` (
37 `id` int(11) NOT NULL AUTO_INCREMENT,
38 `message` varchar(255) DEFAULT '',
39 `colour` varchar(50) DEFAULT 'Red',
40 PRIMARY KEY (`id`)
41) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
42
43-- ----------------------------
44-- Records of announcements
45-- ----------------------------
46INSERT INTO `announcements` VALUES ('1', 'Welcome to my server!', 'Red');
47
48-- ----------------------------
49-- Table structure for marketplace
50-- ----------------------------
51DROP TABLE IF EXISTS `marketplace`;
52CREATE TABLE `marketplace` (
53 `id` int(11) NOT NULL AUTO_INCREMENT,
54 `name` varchar(50) DEFAULT 'Default',
55 `price_buy` int(11) DEFAULT '0',
56 `price_sell` int(11) DEFAULT '0',
57 `amount` int(11) DEFAULT '0',
58 PRIMARY KEY (`id`)
59) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
60
61-- ----------------------------
62-- Records of marketplace
63-- ----------------------------
64INSERT INTO `marketplace` VALUES ('1', 'Steel Crest', '1500', '1500', '5');
65
66-- ----------------------------
67-- Table structure for players
68-- ----------------------------
69DROP TABLE IF EXISTS `players`;
70CREATE TABLE `players` (
71 `id` bigint(20) NOT NULL,
72 `currency` int(11) DEFAULT '1500',
73 `originalname` varchar(255) DEFAULT '',
74 `currentname` varchar(255) DEFAULT '',
75 `has_protection` enum('1','0') DEFAULT '1',
76 `protection_left` int(11) DEFAULT '900',
77 `warnings` int(11) DEFAULT '0',
78 `kills` int(11) DEFAULT '0',
79 PRIMARY KEY (`id`)
80) ENGINE=InnoDB DEFAULT CHARSET=utf8;
81
82-- ----------------------------
83-- Records of players
84-- ----------------------------
85
86-- ----------------------------
87-- Table structure for plugin_settings
88-- ----------------------------
89DROP TABLE IF EXISTS `plugin_settings`;
90CREATE TABLE `plugin_settings` (
91 `disable_decresting` int(1) NOT NULL DEFAULT '0',
92 `announce_interval` int(11) DEFAULT '300',
93 `currency_interval` int(11) DEFAULT '800',
94 `currency_interval_amount` int(11) DEFAULT '150',
95 PRIMARY KEY (`disable_decresting`)
96) ENGINE=InnoDB DEFAULT CHARSET=utf8;
97
98-- ----------------------------
99-- Records of plugin_settings
100-- ----------------------------
101INSERT INTO `plugin_settings` VALUES ('0', '300', '800', '150');
102
103-- ----------------------------
104-- Table structure for rules
105-- ----------------------------
106DROP TABLE IF EXISTS `rules`;
107CREATE TABLE `rules` (
108 `id` int(11) NOT NULL AUTO_INCREMENT,
109 `rule` varchar(255) DEFAULT 'Do not eat humans',
110 PRIMARY KEY (`id`)
111) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
112
113-- ----------------------------
114-- Records of rules
115-- ----------------------------
116INSERT INTO `rules` VALUES ('1', 'Do not eat humans');
117SET FOREIGN_KEY_CHECKS=1;