wG4VsiR0

1-- --------------------------------------------------------
2-- Server version:               5.7.16-log - MySQL Community Server (GPL)
3-- Server OS:                    Win64
4-- --------------------------------------------------------
5
6/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
7/*!40101 SET NAMES utf8 */;
8/*!50503 SET NAMES utf8mb4 */;
9/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
10/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
11
12
13-- Dumping structure for table rust.stats_player
14DROP TABLE IF EXISTS `stats_player`;
15CREATE TABLE IF NOT EXISTS `stats_player` (
16  `id` bigint(20) NOT NULL,
17  `name` text NOT NULL,
18  `online_seconds` bigint(20) DEFAULT '0',
19  `ip` varchar(50) NOT NULL,
20  `online` bit(1) NOT NULL DEFAULT b'0',
21  `lastconnection` datetime DEFAULT CURRENT_TIMESTAMP,
22  `online_seconds_lastwipe` bigint(20) DEFAULT '0',
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
25
26-- Data exporting was unselected.
27-- Dumping structure for table rust.stats_player_animal_kill
28DROP TABLE IF EXISTS `stats_player_animal_kill`;
29CREATE TABLE IF NOT EXISTS `stats_player_animal_kill` (
30  `id` bigint(20) NOT NULL AUTO_INCREMENT,
31  `player` bigint(20) NOT NULL,
32  `animal` varchar(32) NOT NULL,
33  `date` datetime NOT NULL,
34  `distance` int(11) DEFAULT NULL,
35  `weapon` varchar(128) DEFAULT NULL,
36  PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
38
39-- Data exporting was unselected.
40-- Dumping structure for table rust.stats_player_craft_item
41DROP TABLE IF EXISTS `stats_player_craft_item`;
42CREATE TABLE IF NOT EXISTS `stats_player_craft_item` (
43  `id` bigint(20) NOT NULL AUTO_INCREMENT,
44  `player` bigint(20) NOT NULL,
45  `item` varchar(32) NOT NULL,
46  `date` date NOT NULL,
47  `count` int(11) NOT NULL DEFAULT '1',
48  PRIMARY KEY (`id`),
49  UNIQUE KEY `PlayerItemDate` (`player`,`item`,`date`)
50) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
51
52-- Data exporting was unselected.
53-- Dumping structure for table rust.stats_player_death
54DROP TABLE IF EXISTS `stats_player_death`;
55CREATE TABLE IF NOT EXISTS `stats_player_death` (
56  `id` bigint(20) NOT NULL AUTO_INCREMENT,
57  `player` bigint(20) NOT NULL,
58  `cause` varchar(32) NOT NULL,
59  `date` datetime NOT NULL,
60  `count` int(11) NOT NULL DEFAULT '1',
61  `x` int(11) DEFAULT NULL,
62  `z` int(11) DEFAULT NULL,
63  `grid` varchar(5) DEFAULT NULL,
64  PRIMARY KEY (`id`),
65  UNIQUE KEY `PlayerCauseDate` (`player`,`cause`,`date`,`x`,`z`)
66) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
67
68-- Data exporting was unselected.
69-- Dumping structure for table rust.stats_player_destroy_building
70DROP TABLE IF EXISTS `stats_player_destroy_building`;
71CREATE TABLE IF NOT EXISTS `stats_player_destroy_building` (
72  `id` bigint(20) NOT NULL AUTO_INCREMENT,
73  `player` bigint(20) NOT NULL,
74  `owner` bigint(20) DEFAULT NULL,
75  `building` varchar(128) NOT NULL,
76  `date` datetime NOT NULL,
77  `tier` varchar(20) DEFAULT NULL,
78  `weapon` varchar(128) DEFAULT NULL,
79  `grid` varchar(5) DEFAULT NULL,
80  PRIMARY KEY (`id`)
81) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
82
83-- Data exporting was unselected.
84-- Dumping structure for table rust.stats_player_destroy_container
85DROP TABLE IF EXISTS `stats_player_destroy_container`;
86CREATE TABLE IF NOT EXISTS `stats_player_destroy_container` (
87  `id` bigint(20) NOT NULL AUTO_INCREMENT,
88  `player` bigint(20) NOT NULL,
89  `owner` bigint(20) DEFAULT NULL,
90  `title` varchar(128) NOT NULL,
91  `date` datetime NOT NULL,
92  `weapon` varchar(128) DEFAULT NULL,
93  `x` int(11) DEFAULT NULL,
94  `z` int(11) DEFAULT NULL,
95  `grid` varchar(5) DEFAULT NULL,
96  PRIMARY KEY (`id`)
97) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
98
99-- Data exporting was unselected.
100-- Dumping structure for table rust.stats_player_fire_bullet
101DROP TABLE IF EXISTS `stats_player_fire_bullet`;
102CREATE TABLE IF NOT EXISTS `stats_player_fire_bullet` (
103  `id` bigint(20) NOT NULL AUTO_INCREMENT,
104  `player` bigint(20) NOT NULL,
105  `bullet` varchar(32) NOT NULL,
106  `weapon` varchar(128) NOT NULL,
107  `date` date NOT NULL,
108  `count` int(11) NOT NULL DEFAULT '1',
109  PRIMARY KEY (`id`),
110  UNIQUE KEY `PlayerBulletWeaponDate` (`player`,`bullet`,`weapon`,`date`)
111) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
112
113-- Data exporting was unselected.
114-- Dumping structure for table rust.stats_player_gather_resource
115DROP TABLE IF EXISTS `stats_player_gather_resource`;
116CREATE TABLE IF NOT EXISTS `stats_player_gather_resource` (
117  `id` bigint(20) NOT NULL AUTO_INCREMENT,
118  `player` bigint(20) NOT NULL,
119  `resource` varchar(32) NOT NULL,
120  `count` bigint(20) NOT NULL,
121  `date` date NOT NULL,
122  PRIMARY KEY (`id`),
123  UNIQUE KEY `PlayerResourceCountDate` (`player`,`resource`,`date`)
124) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
125
126-- Data exporting was unselected.
127-- Dumping structure for table rust.stats_player_kill
128DROP TABLE IF EXISTS `stats_player_kill`;
129CREATE TABLE IF NOT EXISTS `stats_player_kill` (
130  `id` bigint(20) NOT NULL AUTO_INCREMENT,
131  `killid` char(36) NOT NULL DEFAULT '0',
132  `killer` bigint(20) NOT NULL,
133  `victim` bigint(20) NOT NULL,
134  `weapon` varchar(128) NOT NULL,
135  `bodypart` varchar(2000) NOT NULL DEFAULT '',
136  `date` datetime NOT NULL,
137  `distance` int(11) DEFAULT NULL,
138  `points` int(11) NOT NULL DEFAULT '0',
139  PRIMARY KEY (`id`)
140) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
141
142-- Data exporting was unselected.
143-- Dumping structure for table rust.stats_player_kill_combatlog
144DROP TABLE IF EXISTS `stats_player_kill_combatlog`;
145CREATE TABLE IF NOT EXISTS `stats_player_kill_combatlog` (
146  `id` bigint(20) NOT NULL AUTO_INCREMENT,
147  `killid` char(36) NOT NULL DEFAULT '0',
148  `time` char(64) NOT NULL DEFAULT '0',
149  `attacker` char(128) NOT NULL DEFAULT '0',
150  `attacker_id` int(11) NOT NULL DEFAULT '0',
151  `target` char(128) NOT NULL DEFAULT '0',
152  `target_id` int(11) NOT NULL DEFAULT '0',
153  `weapon` char(128) NOT NULL DEFAULT '0',
154  `ammo` char(128) NOT NULL DEFAULT '0',
155  `area` char(64) NOT NULL DEFAULT '0',
156  `distance` char(32) NOT NULL DEFAULT '0',
157  `old_hp` decimal(10,2) NOT NULL DEFAULT '0.00',
158  `new_hp` decimal(10,2) NOT NULL DEFAULT '0.00',
159  `info` char(128) NOT NULL DEFAULT '0',
160  `dataFrom` char(32) NOT NULL DEFAULT '0',
161  PRIMARY KEY (`id`)
162) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
163
164-- Data exporting was unselected.
165-- Dumping structure for table rust.stats_player_place_building
166DROP TABLE IF EXISTS `stats_player_place_building`;
167CREATE TABLE IF NOT EXISTS `stats_player_place_building` (
168  `id` bigint(20) NOT NULL AUTO_INCREMENT,
169  `player` bigint(20) NOT NULL,
170  `building` varchar(128) NOT NULL,
171  `date` date NOT NULL,
172  `count` int(11) NOT NULL DEFAULT '1',
173  PRIMARY KEY (`id`),
174  UNIQUE KEY `PlayerBuildingDate` (`player`,`building`,`date`)
175) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
176
177-- Data exporting was unselected.
178-- Dumping structure for table rust.stats_player_place_deployable
179DROP TABLE IF EXISTS `stats_player_place_deployable`;
180CREATE TABLE IF NOT EXISTS `stats_player_place_deployable` (
181  `id` bigint(20) NOT NULL AUTO_INCREMENT,
182  `player` bigint(20) NOT NULL,
183  `deployable` varchar(128) NOT NULL,
184  `date` date NOT NULL,
185  `count` int(11) NOT NULL DEFAULT '1',
186  PRIMARY KEY (`id`),
187  UNIQUE KEY `PlayerDeployableDate` (`player`,`deployable`,`date`)
188) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
189
190-- Data exporting was unselected.
191-- Dumping structure for table rust.stats_player_destroy_door
192DROP TABLE IF EXISTS `stats_player_destroy_door`;
193CREATE TABLE IF NOT EXISTS `stats_player_destroy_door` (
194   `id` bigint(20) NOT NULL AUTO_INCREMENT,
195   `player` bigint(20) NOT NULL,
196   `owner` bigint(20) DEFAULT NULL,
197   `title` varchar(128) NOT NULL,
198   `date` datetime NOT NULL,
199   `weapon` varchar(128) DEFAULT NULL,
200   `x` int(11) DEFAULT NULL,
201   `z` int(11) DEFAULT NULL,
202   `grid` varchar(5) DEFAULT NULL,
203   PRIMARY KEY (`id`)
204) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
205
206-- Data exporting was unselected.
207/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
208/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
209/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;