qPXVr8n4

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