· 3 years ago · Nov 04, 2021, 01:10 AM
1-- phpMyAdmin SQL Dump
2-- version 4.9.4deb1
3-- https://www.phpmyadmin.net/
4--
5-- Host: localhost
6-- Generation Time: Mar 11, 2020 at 01:58 PM
7-- Server version: 10.3.22-MariaDB-0ubuntu0.19.10.1
8-- PHP Version: 7.3.11-0ubuntu0.19.10.3
9
10-- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11set sql_mode='MYSQL40';
12SET AUTOCOMMIT = 0;
13START TRANSACTION;
14SET time_zone = "-06:00";
15
16
17/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
18/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
19/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
20/*!40101 SET NAMES utf8mb4 */;
21
22--
23-- Database: `server`
24--
25
26-- --------------------------------------------------------
27
28--
29-- Table structure for table `chat_permissions`
30--
31DROP TABLE IF EXISTS `chat_permissions`;
32CREATE TABLE `chat_permissions` (
33 `id` int(11) NOT NULL,
34 `userId` int(11) NOT NULL,
35 `type` int(11) NOT NULL
36) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
37
38--
39-- Dumping data for table `chat_permissions`
40--
41
42INSERT INTO `chat_permissions` (`id`, `userId`, `type`) VALUES
43(1, 1, 1);
44
45-- --------------------------------------------------------
46
47--
48-- Table structure for table `log_event_jpb`
49--
50DROP TABLE IF EXISTS `log_event_jpb`;
51CREATE TABLE `log_event_jpb` (
52 `id` int(11) NOT NULL,
53 `players` text COLLATE utf8_bin NOT NULL,
54 `finalists` text COLLATE utf8_bin NOT NULL,
55 `winner_id` int(11) NOT NULL,
56 `start_date` datetime NOT NULL,
57 `end_date` datetime NOT NULL
58) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
59
60-- --------------------------------------------------------
61
62--
63-- Table structure for table `log_player_kills`
64--
65DROP TABLE IF EXISTS `log_player_kills`;
66CREATE TABLE `log_player_kills` (
67 `id` int(11) NOT NULL,
68 `killer_id` int(11) NOT NULL,
69 `target_id` int(11) NOT NULL,
70 `pushing` tinyint(1) NOT NULL,
71 `date_added` timestamp NOT NULL DEFAULT current_timestamp()
72) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `player_accounts`
78--
79DROP TABLE IF EXISTS `player_accounts`;
80CREATE TABLE `player_accounts` (
81 `userId` bigint(20) NOT NULL,
82 `sessionId` varchar(32) COLLATE utf8_bin NOT NULL,
83 `data` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '{"uridium":0,"credits":0,"honor":0,"experience":0,"jackpot":0}',
84 `bootyKeys` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '{"greenKeys": 0, "redKeys": 0, "blueKeys": 0}',
85 `info` text COLLATE utf8_bin NOT NULL,
86 `destructions` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '{"fpd":0,"dbrz":0}',
87 `username` varchar(20) COLLATE utf8_bin NOT NULL,
88 `pilotName` varchar(20) COLLATE utf8_bin NOT NULL,
89 `petName` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT 'P.E.T 15',
90 `password` varchar(255) COLLATE utf8_bin NOT NULL,
91 `email` varchar(260) COLLATE utf8_bin NOT NULL,
92 `shipId` int(11) NOT NULL DEFAULT 10,
93 `premium` tinyint(1) NOT NULL DEFAULT 0,
94 `title` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
95 `factionId` int(1) NOT NULL DEFAULT 0,
96 `clanId` int(11) NOT NULL DEFAULT 0,
97 `rankId` int(2) NOT NULL DEFAULT 1,
98 `rankPoints` bigint(20) NOT NULL DEFAULT 0,
99 `rank` int(11) NOT NULL DEFAULT 0,
100 `warPoints` bigint(20) NOT NULL DEFAULT 0,
101 `warRank` int(11) DEFAULT 0,
102 `extraEnergy` int(11) NOT NULL DEFAULT 0,
103 `nanohull` int(11) NOT NULL DEFAULT 0,
104 `verification` text COLLATE utf8_bin NOT NULL,
105 `oldPilotNames` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '[]',
106 `version` tinyint(4) NOT NULL DEFAULT 1
107) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
108
109-- INSERT INTO `player_accounts` (
110-- `data`, `bootyKeys`, `destructions`,`username`,`petName`,`shipId`,`premium`,`title`,`factionId`,`clanId`,
111-- `rankPoints`,`rank`,`warPoints`,`warRank`,`extraEnergy`,`nanohull`,`oldPilotNames`,`version`) VALUES
112-- (
113-- '{"uridium":0,"credits":0,"honor":0,"experience":0,"jackpot":0}',
114-- '{"greenKeys": 0, "redKeys": 0, "blueKeys": 0}',
115-- ' {"fpd":0,"dbrz":0}','','','','P.E.T 15',10,0,'',0,0,1,0,0,0,0,'[]',1);
116
117-- --------------------------------------------------------
118
119--
120-- Table structure for table `player_equipment`
121--
122DROP TABLE IF EXISTS `player_equipment`;
123CREATE TABLE `player_equipment` (
124 `userId` int(11) NOT NULL,
125 `config1_lasers` text COLLATE utf8_bin NOT NULL,
126 `config1_generators` text COLLATE utf8_bin NOT NULL ,
127 `config1_drones` text COLLATE utf8_bin NOT NULL,
128 `config2_lasers` text COLLATE utf8_bin NOT NULL,
129 `config2_generators` text COLLATE utf8_bin NOT NULL,
130 `config2_drones` text COLLATE utf8_bin NOT NULL,
131 `items` text COLLATE utf8_bin NOT NULL,
132 `skill_points` text COLLATE utf8_bin NOT NULL,
133 `modules` longtext COLLATE utf8_bin NOT NULL,
134 `boosters` longtext COLLATE utf8_bin NOT NULL
135) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
136
137
138-- --------------------------------------------------------
139
140--
141-- Table structure for table `player_galaxygates`
142--
143DROP TABLE IF EXISTS `player_galaxygates`;
144CREATE TABLE `player_galaxygates` (
145 `id` int(11) NOT NULL,
146 `userId` int(11) NOT NULL,
147 `gateId` int(11) NOT NULL,
148 `parts` longtext COLLATE utf8_bin NOT NULL,
149 `multiplier` int(11) NOT NULL,
150 `lives` int(11) NOT NULL ,
151 `prepared` tinyint(4) NOT NULL
152) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
153
154
155-- --------------------------------------------------------
156
157--
158-- Table structure for table `player_settings`
159--
160DROP TABLE IF EXISTS `player_settings`;
161CREATE TABLE `player_settings` (
162 `userId` int(11) NOT NULL,
163 `audio` text COLLATE utf8_bin NOT NULL DEFAULT '',
164 `quality` text COLLATE utf8_bin NOT NULL DEFAULT '',
165 `classY2T` text COLLATE utf8_bin NOT NULL DEFAULT '',
166 `display` text COLLATE utf8_bin NOT NULL DEFAULT '',
167 `gameplay` text COLLATE utf8_bin NOT NULL DEFAULT '',
168 `window` text COLLATE utf8_bin NOT NULL DEFAULT '',
169 `boundKeys` text COLLATE utf8_bin NOT NULL DEFAULT '',
170 `inGameSettings` text COLLATE utf8_bin NOT NULL DEFAULT '',
171 `cooldowns` text COLLATE utf8_bin NOT NULL DEFAULT '',
172 `slotbarItems` text COLLATE utf8_bin NOT NULL DEFAULT '',
173 `premiumSlotbarItems` text COLLATE utf8_bin NOT NULL DEFAULT '',
174 `proActionBarItems` text COLLATE utf8_bin NOT NULL DEFAULT ''
175) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
176
177-- --------------------------------------------------------
178
179--
180-- Table structure for table `player_titles`
181--
182DROP TABLE IF EXISTS `player_titles`;
183CREATE TABLE `player_titles` (
184 `userID` int(11) NOT NULL,
185 `titles` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '[]'
186) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
187
188-- --------------------------------------------------------
189
190--
191-- Table structure for table `server_bans`
192--
193DROP TABLE IF EXISTS `server_bans`;
194CREATE TABLE `server_bans` (
195 `id` bigint(20) NOT NULL,
196 `userId` int(11) NOT NULL,
197 `modId` int(11) NOT NULL,
198 `reason` text COLLATE utf8_bin NOT NULL,
199 `typeId` tinyint(4) NOT NULL,
200 `ended` tinyint(1) NOT NULL,
201 `end_date` datetime NOT NULL,
202 `date_added` datetime NOT NULL DEFAULT current_timestamp()
203) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
204
205-- --------------------------------------------------------
206
207--
208-- Table structure for table `server_battlestations`
209--
210DROP TABLE IF EXISTS `server_battlestations`;
211CREATE TABLE `server_battlestations` (
212 `id` int(11) NOT NULL,
213 `name` text COLLATE utf8_bin NOT NULL,
214 `mapId` int(11) NOT NULL,
215 `clanId` int(11) NOT NULL,
216 `positionX` int(11) NOT NULL,
217 `positionY` int(11) NOT NULL,
218 `inBuildingState` tinyint(4) NOT NULL,
219 `buildTimeInMinutes` int(11) NOT NULL,
220 `buildTime` datetime NOT NULL,
221 `deflectorActive` tinyint(4) NOT NULL,
222 `deflectorSecondsLeft` int(11) NOT NULL,
223 `deflectorTime` datetime NOT NULL,
224 `visualModifiers` text COLLATE utf8_bin NOT NULL,
225 `modules` longtext COLLATE utf8_bin NOT NULL,
226 `active` tinyint(4) NOT NULL
227) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
228
229--
230-- Dumping data for table `server_battlestations`
231--
232
233INSERT INTO `server_battlestations` (`id`, `name`, `mapId`, `clanId`, `positionX`, `positionY`, `inBuildingState`, `buildTimeInMinutes`, `buildTime`, `deflectorActive`, `deflectorSecondsLeft`, `deflectorTime`, `visualModifiers`, `modules`, `active`) VALUES
234(1, 'Julius', 15, 0, 16400, 11400, 0, 0, '0000-00-00 00:00:00', 0, 0, '0001-01-01 00:00:00', '[]', '[]', 0);
235
236-- --------------------------------------------------------
237
238--
239-- Table structure for table `server_clans`
240--
241DROP TABLE IF EXISTS `server_clans`;
242CREATE TABLE `server_clans` (
243 `id` int(11) NOT NULL,
244 `name` varchar(50) CHARACTER SET utf8 NOT NULL ,
245 `tag` varchar(4) CHARACTER SET utf8 NOT NULL,
246 `description` varchar(16000) COLLATE utf8_bin NOT NULL,
247 `factionId` tinyint(4) NOT NULL ,
248 `recruiting` tinyint(4) NOT NULL ,
249 `leaderId` int(11) NOT NULL,
250 `news` text COLLATE utf8_bin NOT NULL ,
251 `join_dates` text COLLATE utf8_bin NOT NULL,
252 `rankPoints` bigint(20) ,
253 `rank` int(11) NOT NULL,
254 `date` datetime NOT NULL DEFAULT current_timestamp(),
255 `profile` varchar(255) COLLATE utf8_bin NOT NULL
256) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
257
258INSERT INTO `server_clans` (`name`,`tag`,`description`,`factionID`,`recruiting`,`leaderId`,`news`,`join_dates`,`rankPoints`,`rank`,`profile`)
259VALUES
260('','','',0,1,0,'[]','{}',0,0,'default.jpg');
261-- --------------------------------------------------------
262
263--
264-- Table structure for table `server_clan_applications`
265--
266DROP TABLE IF EXISTS `server_clan_applications`;
267CREATE TABLE `server_clan_applications` (
268 `id` int(11) NOT NULL,
269 `clanId` int(11) NOT NULL,
270 `userId` int(11) NOT NULL,
271 `text` varchar(255) COLLATE utf8_bin NOT NULL,
272 `date` timestamp NOT NULL DEFAULT current_timestamp()
273) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
274
275-- --------------------------------------------------------
276
277--
278-- Table structure for table `server_clan_diplomacy`
279--
280DROP TABLE IF EXISTS `server_clan_diplomacy`;
281CREATE TABLE `server_clan_diplomacy` (
282 `id` bigint(20) NOT NULL,
283 `senderClanId` int(11) NOT NULL,
284 `toClanId` int(11) NOT NULL,
285 `diplomacyType` tinyint(4) NOT NULL,
286 `date` datetime DEFAULT current_timestamp()
287) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
288
289-- --------------------------------------------------------
290
291--
292-- Table structure for table `server_clan_diplomacy_applications`
293--
294DROP TABLE IF EXISTS `server_clan_diplomacy_applications`;
295CREATE TABLE `server_clan_diplomacy_applications` (
296 `id` bigint(20) NOT NULL,
297 `senderClanId` int(11) NOT NULL,
298 `toClanId` int(11) NOT NULL,
299 `diplomacyType` tinyint(4) NOT NULL,
300 `date` datetime NOT NULL DEFAULT current_timestamp()
301) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
302
303-- --------------------------------------------------------
304
305--
306-- Table structure for table `server_maps`
307--
308DROP TABLE IF EXISTS `server_maps`;
309CREATE TABLE `server_maps` (
310 `mapID` int(11) NOT NULL,
311 `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
312 `npcs` longtext COLLATE utf8_bin NOT NULL,
313 `stations` longtext COLLATE utf8_bin NOT NULL,
314 `portals` longtext COLLATE utf8_bin NOT NULL,
315 `collectables` longtext COLLATE utf8_bin NOT NULL,
316 `options` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '{"StarterMap":false,"PvpMap":false,"RangeDisabled":false,"CloakBlocked":false,"LogoutBlocked":false,"DeathLocationRepair":true}',
317 `factionID` int(1) NOT NULL DEFAULT 0
318) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
319
320--
321-- Dumping data for table `server_maps`
322--
323
324INSERT INTO `server_maps` (`mapID`, `name`, `npcs`, `stations`, `portals`, `collectables`, `options`, `factionID`) VALUES
325(1, '1-1', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
326(2, '1-2', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
327(3, '1-3', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
328(4, '1-4', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
329(5, '2-1', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
330(6, '2-2', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
331(7, '2-3', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
332(8, '2-4', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
333(9, '3-1', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
334(10, '3-2', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
335(11, '3-3', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
336(12, '3-4', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
337(13, '4-1', '[{ \"ShipId\": 79, \"Amount\": 7},{ \"ShipId\": 78, \"Amount\":12},{ \"ShipId\": 35, \"Amount\":2},{ \"ShipId\": 29, \"Amount\":4}]', '[{ \"TypeId\": 46, \"FactionId\": 1, \"Position\": [1600,1600] }]', '[{ \"TargetSpaceMapId\": 16, \"Position\": [10000, 6200], \"TargetPosition\": [19200,13400], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true },{ \"TargetSpaceMapId\": 14, \"Position\": [18900, 1900], \"TargetPosition\": [2500,10900], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true },{ \"TargetSpaceMapId\": 15, \"Position\": [18900, 11300], \"TargetPosition\": [2000,11200], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }]', '[{ \"TypeId\": 2, \"Amount\": 100, \"TopLeft\": [18300,1100], \"BottomRight\": [18300,1100], \"Respawnable\":true }]', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
338(14, '4-2', '[{ \"ShipId\": 79, \"Amount\": 7},{ \"ShipId\": 78, \"Amount\":12},{ \"ShipId\": 35, \"Amount\":2},{ \"ShipId\": 29, \"Amount\":4}]', '[{ \"TypeId\": 46, \"FactionId\": 2, \"Position\": [19500,1500] }]', '[{ \"TargetSpaceMapId\": 16, \"Position\": [10400, 6300], \"TargetPosition\": [21900,11900], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 13, \"Position\": [2500, 10900], \"TargetPosition\": [18900,1900], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 15, \"Position\": [18900, 10900], \"TargetPosition\": [2000,1900], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }]', '[{ \"TypeId\": 2, \"Amount\": 100, \"TopLeft\": [18300,1100], \"BottomRight\": [18300,1100], \"Respawnable\":true }]', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
339(15, '4-3', '[{ \"ShipId\": 79, \"Amount\": 7},{ \"ShipId\": 78, \"Amount\":12},{ \"ShipId\": 35, \"Amount\":2},{ \"ShipId\": 29, \"Amount\":4}]', '[{ \"TypeId\": 46, \"FactionId\": 3, \"Position\": [19500,11600] }]', '[{ \"TargetSpaceMapId\": 16, \"Position\": [10300, 6600], \"TargetPosition\": [21900,14500], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 13, \"Position\": [2000,11200], \"TargetPosition\": [18900,11300], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 14, \"Position\": [2000,1900], \"TargetPosition\": [18700,10900], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }]', '[{ \"TypeId\": 2, \"Amount\": 100, \"TopLeft\": [18300,1100], \"BottomRight\": [18300,1100], \"Respawnable\":true }]', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
340(16, '4-4', '', '', '[{ \"TargetSpaceMapId\": 13, \"Position\": [19200,13400], \"TargetPosition\": [10000,6200], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 14, \"Position\": [21900,11900], \"TargetPosition\": [10400,6300], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }, { \"TargetSpaceMapId\": 15, \"Position\": [21900,14500], \"TargetPosition\": [10300,6600], \"GraphicId\": 1, \"FactionId\": 1, \"Visible\": true, \"Working\": true }]', '', '{\"StarterMap\":false,\"PvpMap\":true,\"RangeDisabled\":true,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
341(17, '1-5', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
342(18, '1-6', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
343(19, '1-7', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
344(20, '1-8', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
345(21, '2-5', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
346(22, '2-6', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
347(23, '2-7', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
348(24, '2-8', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
349(25, '3-5', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
350(26, '3-6', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
351(27, '3-7', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
352(28, '3-8', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
353(42, '???', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":true,\"CloakBlocked\":true,\"LogoutBlocked\":true,\"DeathLocationRepair\":false}', 0),
354(71, 'GG Zeta', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
355(74, 'GG Kappa', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
356(101, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":true,\"CloakBlocked\":true,\"LogoutBlocked\":true,\"DeathLocationRepair\":false}', 0),
357(102, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
358(103, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
359(104, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
360(105, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
361(106, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
362(107, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
363(108, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
364(109, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
365(110, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
366(111, 'JP', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
367(121, 'TA', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":true,\"CloakBlocked\":true,\"LogoutBlocked\":true,\"DeathLocationRepair\":false}', 0),
368(200, 'LoW', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0),
369(224, 'Custom Tournament', '', '', '', '', '{\"StarterMap\":false,\"PvpMap\":false,\"RangeDisabled\":false,\"CloakBlocked\":false,\"LogoutBlocked\":false,\"DeathLocationRepair\":true}', 0);
370
371-- --------------------------------------------------------
372
373--
374-- Table structure for table `server_ships`
375--
376DROP TABLE IF EXISTS `server_ships`;
377CREATE TABLE `server_ships` (
378 `id` int(11) NOT NULL,
379 `shipID` int(11) NOT NULL,
380 `baseShipId` int(11) NOT NULL,
381 `lootID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
382 `name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
383 `health` int(11) NOT NULL DEFAULT 0,
384 `shield` int(11) NOT NULL DEFAULT 0,
385 `speed` int(11) NOT NULL DEFAULT 300,
386 `lasers` int(11) NOT NULL DEFAULT 1,
387 `generators` int(11) NOT NULL DEFAULT 1,
388 `cargo` int(11) NOT NULL DEFAULT 100,
389 `aggressive` tinyint(1) NOT NULL DEFAULT 0,
390 `damage` int(11) NOT NULL DEFAULT 20,
391 `respawnable` tinyint(1) NOT NULL,
392 `reward` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '{"Experience":0,"Honor":0,"Credits":0,"Uridium":0}'
393) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
394
395--
396-- Dumping data for table `server_ships`
397--
398
399INSERT INTO `server_ships` (`id`, `shipID`, `baseShipId`, `lootID`, `name`, `health`, `shield`, `speed`, `lasers`, `generators`, `cargo`, `aggressive`, `damage`, `respawnable`, `reward`) VALUES
400(18, 1, 0, 'ship_phoenix', 'Phoenix', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
401(19, 2, 0, 'ship_yamato', 'Yamato', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
402(20, 3, 0, 'ship_leonov', 'Leonov', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
403(21, 4, 0, 'ship_defcom', 'Defcom', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
404(22, 5, 0, 'ship_liberator', 'Liberator', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
405(23, 6, 0, 'ship_piranha', 'Piranha', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
406(24, 7, 0, 'ship_nostromo', 'Nostromo', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
407(25, 8, 8, 'ship_vengeance', 'Vengeance', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
408(26, 9, 0, 'ship_bigboy', 'Bigboy', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
409(27, 10, 10, 'ship_goliath', 'Goliath', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
410(28, 12, 0, 'pet', 'P.E.T. Level 1-3', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":150,\"Credits\":0,\"Uridium\":0}'),
411(29, 13, 0, 'pet', 'P.E.T. Red', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":150,\"Credits\":0,\"Uridium\":0}'),
412(30, 15, 0, 'pet', 'P.E.T. Frozen', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":150,\"Credits\":0,\"Uridium\":0}'),
413(31, 16, 8, 'ship_vengeance_design_adept', 'Adept', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
414(32, 17, 8, 'ship_vengeance_design_corsair', 'Corsair', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
415(33, 18, 8, 'ship_vengeance_design_lightning', 'Lightning', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
416(34, 19, 10, 'ship_goliath_design_jade', 'Jade', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
417(35, 20, 0, 'ship_admin', 'Ufo', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
418(36, 22, 0, 'pet', 'P.E.T. Normal', 0, 50000, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":150,\"Credits\":0,\"Uridium\":0}'),
419(37, 49, 49, 'ship_aegis', 'Aegis', 275000, 0, 300, 10, 15, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":250,\"Credits\":0,\"Uridium\":250}'),
420(38, 52, 10, 'ship_goliath_design_amber', 'Amber', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
421(39, 53, 10, 'ship_goliath_design_crimson', 'Crimson', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
422(40, 54, 10, 'ship_goliath_design_sapphire', 'Sapphire', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
423(41, 56, 10, 'ship_goliath_design_enforcer', 'Enforcer', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
424(42, 57, 10, 'ship_goliath_design_independence', 'Independence', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
425(43, 58, 8, 'ship_vengeance_design_revenge', 'Revenge', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
426(44, 59, 10, 'ship_goliath_design_bastion', 'Bastion', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
427(45, 60, 8, 'ship_vengeance_design_avenger', 'Avenger', 180000, 0, 380, 10, 10, 0, 0, 0, 0, '{\"Experience\":25600,\"Honor\":256,\"Credits\":0,\"Uridium\":256}'),
428(46, 14, 0, 'pet', 'P.E.T. Green', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":150,\"Credits\":0,\"Uridium\":0}'),
429(47, 62, 10, 'ship_goliath_design_exalted', 'Exalted', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
430(48, 63, 10, 'ship_goliath_design_solace', 'Solace', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
431(49, 64, 10, 'ship_goliath_design_diminisher', 'Diminisher', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
432(50, 65, 10, 'ship_goliath_design_spectrum', 'Spectrum', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
433(51, 66, 10, 'ship_goliath_design_sentinel', 'Sentinel', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
434(52, 67, 10, 'ship_goliath_design_venom', 'Venom', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
435(53, 68, 10, 'ship_goliath_design_ignite', 'Ignite', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
436(54, 69, 69, 'ship_citadel', 'Citadel', 550000, 0, 240, 7, 20, 0, 0, 0, 0, '{\"Experience\":120000,\"Honor\":1200,\"Credits\":0,\"Uridium\":1200}'),
437(55, 70, 70, 'ship_spearhead', 'Spearhead', 100000, 0, 370, 5, 12, 0, 0, 0, 0, '{\"Experience\":7500,\"Honor\":75,\"Credits\":0,\"Uridium\":75}'),
438(56, 81, 81, 'ship_vengeance_design_pusat', 'Pusat', 125000, 0, 370, 16, 12, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
439(57, 86, 10, 'ship_goliath_design_kick', 'Kick', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
440(58, 87, 10, 'ship_goliath_design_referee', 'Referee', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
441(59, 88, 10, 'ship_goliath_design_goal', 'Goal', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
442(60, 98, 98, 'ship_police', 'PoliceShip', 1000000, 0, 300, 35, 35, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
443(61, 109, 10, 'ship_goliath_design_saturn', 'Saturn', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
444(62, 110, 10, 'ship_goliath_design_centaur', 'Centaur', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
445(63, 61, 10, 'ship_goliath_design_veteran', 'Veteran', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
446(64, 140, 10, 'ship_goliath_design_vanquisher', 'Vanquisher', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
447(65, 141, 10, 'ship_goliath_design_sovereign', 'Sovereign', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
448(66, 142, 10, 'ship_goliath_design_peacemaker', 'Peacemaker', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
449(67, 150, 0, 'ship_nostromo_design_diplomat', 'Nostromo Diplomat', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
450(68, 151, 0, 'ship_nostromo_design_envoy', 'Nostromo Envoy', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
451(69, 152, 0, 'ship_nostromo_design_ambassador', 'Nostromo Ambassador', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
452(70, 153, 10, 'ship_goliath_design_goliath-razer', 'Razer', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
453(71, 154, 0, 'ship_nostromo_design_nostromo-razer', 'Nostromo Razer', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
454(72, 155, 10, 'ship_goliath_design_turkish', 'Hezarfen', 256000, 0, 300, 15, 15, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
455(73, 156, 156, 'ship_g-surgeon', 'Surgeon', 256000, 0, 300, 15, 16, 0, 0, 0, 0, '{\"Experience\":51200,\"Honor\":512,\"Credits\":0,\"Uridium\":512}'),
456(74, 157, 49, 'ship_aegis_design_aegis-elite', 'Aegis Veteran', 275000, 0, 300, 10, 15, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":250,\"Credits\":0,\"Uridium\":250}'),
457(75, 158, 49, 'ship_aegis_design_aegis-superelite', 'Aegis Super Elite', 275000, 0, 300, 10, 15, 0, 0, 0, 0, '{\"Experience\":25000,\"Honor\":250,\"Credits\":0,\"Uridium\":250}'),
458(76, 159, 69, 'ship_citadel_design_citadel-elite', 'Citadel Veteran', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
459(77, 160, 69, 'ship_citadel_design_citadel-superelite', 'Citadel Super Elite', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
460(78, 161, 70, 'ship_aegis_design_aegis-elite', 'Spearhead Veteran', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
461(79, 162, 70, 'ship_aegis_design_aegis-superelite', 'Spearhead Super Elite', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
462(80, 442, 0, 'spaceball_summer', '..::{Spaceball}::..', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
463(81, 443, 0, 'spaceball_winter', '..::{Spaceball}::..', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
464(82, 444, 0, 'spaceball_soccer', '..::{Spaceball}::..', 0, 0, 0, 0, 0, 0, 0, 0, 0, '{\"Experience\":0,\"Honor\":0,\"Credits\":0,\"Uridium\":0}'),
465(83, 79, 0, 'ship79', '-=[ Kristallon ]=-', 400000, 300000, 250, 1, 1, 100, 0, 4500, 1, '{\"Experience\":51200,\"Honor\":256,\"Credits\":409600,\"Uridium\":128}'),
466(84, 78, 0, 'ship78', '-=[ Kristallin ]=-', 50000, 40000, 320, 1, 1, 100, 1, 1100, 1, '{\"Experience\":6400,\"Honor\":32,\"Credits\":12800,\"Uridium\":16}'),
467(85, 35, 0, 'ship35', '..::{ Boss Kristallon }::..', 1600000, 1200000, 250, 1, 1, 100, 0, 18000, 1, '{\"Experience\":204800,\"Honor\":1024,\"Credits\":1638400,\"Uridium\":512}'),
468(86, 29, 0, 'ship29', '..::{ Boss Kristallin }::..', 200000, 160000, 320, 1, 1, 100, 1, 4000, 1, '{\"Experience\":25600,\"Honor\":128,\"Credits\":51200,\"Uridium\":64}');
469
470--
471-- Indexes for dumped tables
472--
473
474--
475-- Indexes for table `chat_permissions`
476--
477ALTER TABLE `chat_permissions`
478 ADD PRIMARY KEY (`id`);
479
480--
481-- Indexes for table `log_event_jpb`
482--
483ALTER TABLE `log_event_jpb`
484 ADD PRIMARY KEY (`id`);
485
486--
487-- Indexes for table `log_player_kills`
488--
489ALTER TABLE `log_player_kills`
490 ADD PRIMARY KEY (`id`);
491
492--
493-- Indexes for table `player_accounts`
494--
495-- ALTER TABLE `player_accounts`
496-- ADD PRIMARY KEY (`userId`);
497
498--
499-- Indexes for table `player_equipment`
500--
501-- ALTER TABLE `player_equipment`
502-- ADD PRIMARY KEY (`userId`);
503
504--
505-- Indexes for table `player_galaxygates`
506--
507-- ALTER TABLE `player_galaxygates`
508-- ADD PRIMARY KEY (`id`);
509
510--
511-- Indexes for table `player_settings`
512--
513ALTER TABLE `player_settings`
514 ADD PRIMARY KEY (`userId`);
515
516--
517-- Indexes for table `player_titles`
518--
519ALTER TABLE `player_titles`
520 ADD PRIMARY KEY (`userID`);
521
522--
523-- Indexes for table `server_bans`
524--
525ALTER TABLE `server_bans`
526 ADD PRIMARY KEY (`id`);
527
528--
529-- Indexes for table `server_battlestations`
530--
531ALTER TABLE `server_battlestations`
532 ADD PRIMARY KEY (`id`);
533
534--
535-- Indexes for table `server_clans`
536--
537ALTER TABLE `server_clans`
538 ADD PRIMARY KEY (`id`);
539
540--
541-- Indexes for table `server_clan_applications`
542--
543ALTER TABLE `server_clan_applications`
544 ADD PRIMARY KEY (`id`);
545
546--
547-- Indexes for table `server_clan_diplomacy`
548--
549ALTER TABLE `server_clan_diplomacy`
550 ADD PRIMARY KEY (`id`);
551
552--
553-- Indexes for table `server_clan_diplomacy_applications`
554--
555ALTER TABLE `server_clan_diplomacy_applications`
556 ADD PRIMARY KEY (`id`);
557
558--
559-- Indexes for table `server_maps`
560--
561ALTER TABLE `server_maps`
562 ADD PRIMARY KEY (`mapID`);
563
564--
565-- Indexes for table `server_ships`
566--
567ALTER TABLE `server_ships`
568 ADD PRIMARY KEY (`id`),
569 ADD UNIQUE KEY `shipID` (`shipID`);
570
571--
572-- AUTO_INCREMENT for dumped tables
573--
574
575--
576-- AUTO_INCREMENT for table `chat_permissions`
577--
578ALTER TABLE `chat_permissions`
579 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
580
581--
582-- AUTO_INCREMENT for table `log_event_jpb`
583--
584ALTER TABLE `log_event_jpb`
585 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
586
587--
588-- AUTO_INCREMENT for table `log_player_kills`
589--
590ALTER TABLE `log_player_kills`
591 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
592
593--
594-- AUTO_INCREMENT for table `player_accounts`
595--
596ALTER TABLE `player_accounts`
597 MODIFY `userId` bigint(20) NOT NULL AUTO_INCREMENT PRIMARY KEY;
598
599--
600-- AUTO_INCREMENT for table `player_equipment`
601--
602ALTER TABLE `player_equipment`
603 MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY;
604
605--
606-- AUTO_INCREMENT for table `player_galaxygates`
607--
608ALTER TABLE `player_galaxygates`
609 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY;
610
611--
612-- AUTO_INCREMENT for table `player_settings`
613--
614ALTER TABLE `player_settings`
615 MODIFY `userId` int(11) NOT NULL AUTO_INCREMENT;
616
617--
618-- AUTO_INCREMENT for table `player_titles`
619--
620ALTER TABLE `player_titles`
621 MODIFY `userID` int(11) NOT NULL AUTO_INCREMENT;
622
623--
624-- AUTO_INCREMENT for table `server_bans`
625--
626ALTER TABLE `server_bans`
627 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
628
629--
630-- AUTO_INCREMENT for table `server_battlestations`
631--
632ALTER TABLE `server_battlestations`
633 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
634
635--
636-- AUTO_INCREMENT for table `server_clans`
637--
638ALTER TABLE `server_clans`
639 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
640
641--
642-- AUTO_INCREMENT for table `server_clan_applications`
643--
644ALTER TABLE `server_clan_applications`
645 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
646
647--
648-- AUTO_INCREMENT for table `server_clan_diplomacy`
649--
650ALTER TABLE `server_clan_diplomacy`
651 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
652
653--
654-- AUTO_INCREMENT for table `server_clan_diplomacy_applications`
655--
656ALTER TABLE `server_clan_diplomacy_applications`
657 MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT;
658
659--
660-- AUTO_INCREMENT for table `server_maps`
661--
662ALTER TABLE `server_maps`
663 MODIFY `mapID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=225;
664
665--
666-- AUTO_INCREMENT for table `server_ships`
667--
668ALTER TABLE `server_ships`
669 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=118;
670COMMIT;
671
672/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
673/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
674/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
675