-
Notifications
You must be signed in to change notification settings - Fork 1
/
driftmode.sql
44 lines (37 loc) · 15.6 KB
/
driftmode.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
/*
Navicat Premium Data Transfer
Source Server : drift
Source Server Type : MySQL
Source Server Version : 80021
Source Host : 74.91.116.62:3306
Source Schema : driftmode
Target Server Type : MySQL
Target Server Version : 80021
File Encoding : 65001
Date: 17/10/2020 15:14:13
*/
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` int NOT NULL AUTO_INCREMENT,
`playerid` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`name` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`rank` int NOT NULL DEFAULT 0,
`points` int NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 66 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
-- ----------------------------
-- Table structure for vehicles
-- ----------------------------
DROP TABLE IF EXISTS `vehicles`;
CREATE TABLE `vehicles` (
`id` int NOT NULL AUTO_INCREMENT,
`identifier` text CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
`vehicles` varchar(60000) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '[{\"name\":\"Dukes\", \"id\":\"dukes\", \"price\":\"1000\", \"owned\":\"1\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Sultan\", \"id\":\"sultan\", \"price\":\"100000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Sultan RS\", \"id\":\"sultanrs\", \"price\":\"225000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Hot Knife\", \"id\":\"hotknife\", \"price\":\"75000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Blista\", \"id\":\"blista\", \"price\":\"1000\", \"owned\":\"1\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Blista #2\", \"id\":\"blista2\", \"price\":\"35000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Banshee\", \"id\":\"banshee\", \"price\":\"115000\", \"owned\":\"1\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Banshee #2\", \"id\":\"banshee2\", \"price\":\"235000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Buffalo\", \"id\":\"buffalo\", \"price\":\"65000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Buffalo #2\", \"id\":\"buffalo2\", \"price\":\"1000\", \"owned\":\"1\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Buffalo #3\", \"id\":\"buffalo3\", \"price\":\"85000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Gauntlet\", \"id\":\"gauntlet\", \"price\":\"110000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Gauntlet #2\", \"id\":\"gauntlet2\", \"price\":\"145000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Stalion\", \"id\":\"stalion\", \"price\":\"85000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Stalion #2\", \"id\":\"stalion2\", \"price\":\"95000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Coquette\", \"id\":\"coquette\", \"price\":\"125000\", \"owned\":\"1\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Coquette #2\", \"id\":\"coquette2\", \"price\":\"155000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Coquette #3\", \"id\":\"coquette3\", \"price\":\"175000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Furore GT\", \"id\":\"furoregt\", \"price\":\"325000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Comet #2\", \"id\":\"comet2\", \"price\":\"210000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Comet #3\", \"id\":\"comet3\", \"price\":\"275000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Warrener\", \"id\":\"warrener\", \"price\":\"210000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Glendale\", \"id\":\"glendale\", \"price\":\"185000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Panto\", \"id\":\"panto\", \"price\":\"165000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Pigalle\", \"id\":\"pigalle\", \"price\":\"195000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Elegy\", \"id\":\"elegy\", \"price\":\"425000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Faction\", \"id\":\"faction\", \"price\":\"230000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Faction #3\", \"id\":\"faction3\", \"price\":\"275000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Minivan\", \"id\":\"minivan2\", \"price\":\"90000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Slamvan\", \"id\":\"slamvan\", \"price\":\"65000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Slamvan #2\", \"id\":\"slamvan2\", \"price\":\"85000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Slamvan #3\", \"id\":\"slamvan3\", \"price\":\"95000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Sabre GT #2\", \"id\":\"sabregt2\", \"price\":\"245000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Virgo\", \"id\":\"virgo\", \"price\":\"125000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Virgo #2\", \"id\":\"virgo2\", \"price\":\"175000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Virgo #3\", \"id\":\"virgo3\", \"price\":\"201000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Buccaneer #2\", \"id\":\"buccaneer2\", \"price\":\"215000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Chino\", \"id\":\"chino\", \"price\":\"115000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Chino #2\", \"id\":\"chino2\", \"price\":\"166000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Primo\", \"id\":\"primo\", \"price\":\"125000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Primo #2\", \"id\":\"primo2\", \"price\":\"162000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Voodoo\", \"id\":\"voodoo\", \"price\":\"105000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Seven 70\", \"id\":\"seven70\", \"price\":\"420000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Bestia GTS\", \"id\":\"bestiagts\", \"price\":\"475000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Reaper\", \"id\":\"reaper\", \"price\":\"375000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Verlierer #2\", \"id\":\"verlierer2\", \"price\":\"295000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Sight Shade\", \"id\":\"nightshade\", \"price\":\"265000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Schafter #3\", \"id\":\"schafter3\", \"price\":\"420000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Schafter #4\", \"id\":\"schafter4\", \"price\":\"495000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Mamba\", \"id\":\"mamba\", \"price\":\"172000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Windsor\", \"id\":\"windsor\", \"price\":\"145000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Rat Loader #2\", \"id\":\"ratloader2\", \"price\":\"165000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Jester #2\", \"id\":\"jester2\", \"price\":\"385000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Massacro #2\", \"id\":\"massacro2\", \"price\":\"235000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Trophy Truck\", \"id\":\"trophytruck\", \"price\":\"375000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Trophy Truck #2\", \"id\":\"trophytruck2\", \"price\":\"535000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Omnis\", \"id\":\"omnis\", \"price\":\"195000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Tropos\", \"id\":\"tropos\", \"price\":\"465000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Brioso\", \"id\":\"brioso\", \"price\":\"495000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Lynx\", \"id\":\"lynx\", \"price\":\"625000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Sheava\", \"id\":\"sheava\", \"price\":\"870000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Specter\", \"id\":\"specter\", \"price\":\"545000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Specter #2\", \"id\":\"specter2\", \"price\":\"725000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Toyotal AE86\", \"id\":\"ae86\", \"price\":\"1400000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Nissan 180sx\", \"id\":\"180sx\", \"price\":\"1300000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Nissan 180sxrb\", \"id\":\"180sxrb\", \"price\":\"1500000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Tampa #3\", \"id\":\"tampa3\", \"price\":\"375000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Tampa #4\", \"id\":\"tampa4\", \"price\":\"565000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Fordh\", \"id\":\"fordh\", \"price\":\"1750000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW E30\", \"id\":\"blze30\", \"price\":\"1250000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Austin Martin AM3\", \"id\":\"amm3\", \"price\":\"2210000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW M5 E34\", \"id\":\"e34\", \"price\":\"1210000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW M3 E36\", \"id\":\"m3e36\", \"price\":\"1620000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota Supra\", \"id\":\"supra2\", \"price\":\"3250000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota GT86\", \"id\":\"gt86\", \"price\":\"1420000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota GT86 RB\", \"id\":\"gt86rb\", \"price\":\"1440000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota GTR 32RB\", \"id\":\"gtr32rb\", \"price\":\"1450000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota GTR 32RBCAM\", \"id\":\"gtr32rbcam\", \"price\":\"1990000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Skyline R33\", \"id\":\"r33\", \"price\":\"2990000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW Drift\", \"id\":\"bmdrift\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW Race\", \"id\":\"bmwrace\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Audio Quattros\", \"id\":\"quattros\", \"price\":\"1150000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Silva S14\", \"id\":\"s14kouki\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Silva S15TEX\", \"id\":\"s15tex\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Silva S15\", \"id\":\"s15\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Mazda RX7RB\", \"id\":\"rx7rb\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Mazda RX7\", \"id\":\"rx7asuka\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mazda RX7 FC3S\", \"id\":\"fc3s\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"3\", \"vehicledata\":\"0\"},{\"name\":\"Silvia 180SX\", \"id\":\"sil80\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Skyline R30\", \"id\":\"r30rsx\", \"price\":\"1850000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"BMW M4\", \"id\":\"f82\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"BMW M4 #2\", \"id\":\"f82hs\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW M4 #3\", \"id\":\"f82lw\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"BMW M4 #4\", \"id\":\"f82duke\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW M4 #5\", \"id\":\"f824slw\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Ford GT\", \"id\":\"fordgt\", \"price\":\"3350000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Toyota JZX100\", \"id\":\"jzx100\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Warrener #3\", \"id\":\"warrener3\", \"price\":\"750000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mitsubishi Eclipse\", \"id\":\"eclipse\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"2\", \"vehicledata\":\"0\"},{\"name\":\"Vivio\", \"id\":\"vivio\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Lexus RCF\", \"id\":\"rcf\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Lexus GS350\", \"id\":\"gs350\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Subura BRZ\", \"id\":\"brzrbv3\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Nissan 350z RB\", \"id\":\"350zrb\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"Nissan FairLady\", \"id\":\"ps30\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mazda Miata\", \"id\":\"na6\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Toyota Cresta\", \"id\":\"cresta\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Ruiner FD\", \"id\":\"ruinerfd\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mazda S2K\", \"id\":\"s2k\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Nissan 180 TypeX\", \"id\":\"180typex\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"0\", \"vehicledata\":\"0\"},{\"name\":\"BMW E36DM\", \"id\":\"e36dm\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"BMW E36DMCAM\", \"id\":\"e36dmcam\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mazda RX7\", \"id\":\"rx7\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Mazda RX7 #2\", \"id\":\"rx72\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Nissan S13\", \"id\":\"ns13\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Daewoo Tico\", \"id\":\"tico\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Lexy\", \"id\":\"lexy\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"},{\"name\":\"Lexus SC300\", \"id\":\"sc300\", \"price\":\"1350000\", \"owned\":\"0\", \"rank\":\"1\", \"vehicledata\":\"0\"}]',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 138 CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;