· 7 years ago · Jan 07, 2019, 07:50 PM
1/*
2 Navicat MySQL Data Transfer
3
4 Source Server : Fivem
5 Source Server Type : MySQL
6 Source Server Version : 80013
7 Source Host : localhost:3306
8 Source Schema : fivem
9
10 Target Server Type : MySQL
11 Target Server Version : 80013
12 File Encoding : 65001
13
14 Date: 07/01/2019 20:45:50
15*/
16
17SET NAMES utf8mb4;
18SET FOREIGN_KEY_CHECKS = 0;
19
20-- ----------------------------
21-- Table structure for trucks
22-- ----------------------------
23DROP TABLE IF EXISTS `trucks`;
24CREATE TABLE `trucks` (
25 `name` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
26 `model` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
27 `price` int(11) NOT NULL,
28 `category` varchar(60) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
29 PRIMARY KEY (`model`) USING BTREE
30) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
31
32-- ----------------------------
33-- Records of trucks
34-- ----------------------------
35INSERT INTO `trucks` VALUES ('Challenger', '16challenger', 1, 'import');
36INSERT INTO `trucks` VALUES ('Porshe', '911turbos', 1, 'import');
37INSERT INTO `trucks` VALUES ('AMG Classe A', 'a45', 1, 'import');
38INSERT INTO `trucks` VALUES ('Adder', 'adder', 1, 'super');
39INSERT INTO `trucks` VALUES ('Alpha', 'alpha', 1, 'sports');
40INSERT INTO `trucks` VALUES ('Ardent', 'ardent', 1, 'sportsclassics');
41INSERT INTO `trucks` VALUES ('Banshee', 'banshee', 1, 'sports');
42INSERT INTO `trucks` VALUES ('Banshee 900R', 'banshee2', 1, 'super');
43INSERT INTO `trucks` VALUES ('Bestia GTS', 'bestiagts', 1, 'sports');
44INSERT INTO `trucks` VALUES ('Btype', 'btype', 1, 'sportsclassics');
45INSERT INTO `trucks` VALUES ('Btype Hotroad', 'btype2', 1, 'sportsclassics');
46INSERT INTO `trucks` VALUES ('Btype Luxe', 'btype3', 1, 'sportsclassics');
47INSERT INTO `trucks` VALUES ('Buffalo', 'buffalo', 1, 'sports');
48INSERT INTO `trucks` VALUES ('Buffalo S', 'buffalo2', 1, 'sports');
49INSERT INTO `trucks` VALUES ('Bullet', 'bullet', 1, 'super');
50INSERT INTO `trucks` VALUES ('Carbonizzare', 'carbonizzare', 1, 'sports');
51INSERT INTO `trucks` VALUES ('Casco', 'casco', 1, 'sportsclassics');
52INSERT INTO `trucks` VALUES ('Honda 500', 'cb500x', 1, 'import');
53INSERT INTO `trucks` VALUES ('Honda', 'CBTWISTER', 1, 'import');
54INSERT INTO `trucks` VALUES ('Cheetah', 'cheetah', 1, 'super');
55INSERT INTO `trucks` VALUES ('Comet', 'comet2', 1, 'sports');
56INSERT INTO `trucks` VALUES ('Comet SR', 'comet5', 1, 'sports');
57INSERT INTO `trucks` VALUES ('Coquette', 'coquette', 1, 'sports');
58INSERT INTO `trucks` VALUES ('Coquette Classic', 'coquette2', 1, 'sportsclassics');
59INSERT INTO `trucks` VALUES ('Cyclone', 'cyclone', 1, 'super');
60INSERT INTO `trucks` VALUES ('Dominator GTX', 'dominator3', 1, 'sports');
61INSERT INTO `trucks` VALUES ('Elegy', 'elegy2', 1, 'sports');
62INSERT INTO `trucks` VALUES ('Entity XF', 'entityxf', 1, 'super');
63INSERT INTO `trucks` VALUES ('Feltzer', 'feltzer2', 1, 'sports');
64INSERT INTO `trucks` VALUES ('Stirling GT', 'feltzer3', 1, 'sportsclassics');
65INSERT INTO `trucks` VALUES ('FMJ', 'fmj', 1, 'super');
66INSERT INTO `trucks` VALUES ('Furore GT', 'furoregt', 1, 'sports');
67INSERT INTO `trucks` VALUES ('Fusilade', 'fusilade', 1, 'sports');
68INSERT INTO `trucks` VALUES ('NissanGtr', 'gtr', 1, 'import');
69INSERT INTO `trucks` VALUES ('Infernus', 'infernus', 1, 'super');
70INSERT INTO `trucks` VALUES ('Jester', 'jester', 1, 'sports');
71INSERT INTO `trucks` VALUES ('Jester course', 'jester2', 1, 'sports');
72INSERT INTO `trucks` VALUES ('Khamelion', 'khamelion', 1, 'sports');
73INSERT INTO `trucks` VALUES ('Kuruma', 'kuruma', 1, 'sports');
74INSERT INTO `trucks` VALUES ('Lynx', 'lynx', 1, 'sports');
75INSERT INTO `trucks` VALUES ('BMW M3', 'm3f80', 1, 'import');
76INSERT INTO `trucks` VALUES ('Mamba', 'mamba', 1, 'sports');
77INSERT INTO `trucks` VALUES ('Manana', 'manana', 1, 'sportsclassics');
78INSERT INTO `trucks` VALUES ('Massacro', 'massacro', 1, 'sports');
79INSERT INTO `trucks` VALUES ('Massacro(Racecar)', 'massacro2', 1, 'sports');
80INSERT INTO `trucks` VALUES ('Monroe', 'monroe', 1, 'sportsclassics');
81INSERT INTO `trucks` VALUES ('Neon', 'neon', 1, 'sports');
82INSERT INTO `trucks` VALUES ('9F', 'ninef', 1, 'sports');
83INSERT INTO `trucks` VALUES ('9F Cabrio', 'ninef2', 1, 'sports');
84INSERT INTO `trucks` VALUES ('Omnis', 'omnis', 1, 'sports');
85INSERT INTO `trucks` VALUES ('Osiris', 'osiris', 1, 'super');
86INSERT INTO `trucks` VALUES ('P1', 'p1', 1, 'import');
87INSERT INTO `trucks` VALUES ('Pariah', 'pariah', 1, 'sports');
88INSERT INTO `trucks` VALUES ('Penumbra', 'penumbra', 1, 'sports');
89INSERT INTO `trucks` VALUES ('Pfister', 'pfister811', 1, 'super');
90INSERT INTO `trucks` VALUES ('Pigalle', 'pigalle', 1, 'sportsclassics');
91INSERT INTO `trucks` VALUES ('X80 Proto', 'prototipo', 1, 'super');
92INSERT INTO `trucks` VALUES ('raiden', 'raiden', 1, 'sports');
93INSERT INTO `trucks` VALUES ('Rapid GT', 'rapidgt', 1, 'sports');
94INSERT INTO `trucks` VALUES ('Rapid GT Convertible', 'rapidgt2', 1, 'sports');
95INSERT INTO `trucks` VALUES ('Rapid GT3', 'rapidgt3', 1, 'sportsclassics');
96INSERT INTO `trucks` VALUES ('Reaper', 'reaper', 1, 'super');
97INSERT INTO `trucks` VALUES ('Retinue', 'retinue', 1, 'sportsclassics');
98INSERT INTO `trucks` VALUES ('Revolter', 'revolter', 1, 'sports');
99INSERT INTO `trucks` VALUES ('Audi RS5', 'rs5r', 1, 'import');
100INSERT INTO `trucks` VALUES ('Dodge', 'rt70', 1, 'import');
101INSERT INTO `trucks` VALUES ('Jeep', 'rubi3d', 1, 'import');
102INSERT INTO `trucks` VALUES ('Savestra', 'savestra', 1, 'sportsclassics');
103INSERT INTO `trucks` VALUES ('SC 1', 'sc1', 1, 'super');
104INSERT INTO `trucks` VALUES ('Schafter V12', 'schafter3', 1, 'sports');
105INSERT INTO `trucks` VALUES ('Sentinel3', 'sentinel3', 1, 'sports');
106INSERT INTO `trucks` VALUES ('Seven 70', 'seven70', 1, 'sports');
107INSERT INTO `trucks` VALUES ('Stinger', 'stinger', 1, 'sportsclassics');
108INSERT INTO `trucks` VALUES ('Stinger GT', 'stingergt', 1, 'sportsclassics');
109INSERT INTO `trucks` VALUES ('Streiter', 'streiter', 1, 'sports');
110INSERT INTO `trucks` VALUES ('Sultan', 'sultan', 1, 'sports');
111INSERT INTO `trucks` VALUES ('Sultan RS', 'sultanrs', 1, 'super');
112INSERT INTO `trucks` VALUES ('Surano', 'surano', 1, 'sports');
113INSERT INTO `trucks` VALUES ('T20', 't20', 1, 'super');
114INSERT INTO `trucks` VALUES ('Drift Tampa', 'tampa2', 1, 'sports');
115INSERT INTO `trucks` VALUES ('Turismo R', 'turismor', 1, 'super');
116INSERT INTO `trucks` VALUES ('Vacca', 'vacca', 1, 'super');
117INSERT INTO `trucks` VALUES ('Verlierer', 'verlierer2', 1, 'sports');
118INSERT INTO `trucks` VALUES ('Viseris', 'viseris', 1, 'sportsclassics');
119INSERT INTO `trucks` VALUES ('Visione', 'visione', 1, 'super');
120INSERT INTO `trucks` VALUES ('Voltic', 'voltic', 1, 'super');
121INSERT INTO `trucks` VALUES ('Z190', 'z190', 1, 'sportsclassics');
122INSERT INTO `trucks` VALUES ('Zentorno', 'zentorno', 1, 'super');
123INSERT INTO `trucks` VALUES ('Z-Type', 'ztype', 1, 'sportsclassics');
124
125SET FOREIGN_KEY_CHECKS = 1;