· 6 years ago · Sep 25, 2019, 01:46 PM
1-- --------------------------------------------------------
2-- Host: 54.229.115.1
3-- Server version: 5.7.27 - MySQL Community Server (GPL)
4-- Server OS: Linux
5-- HeidiSQL Version: 10.1.0.5464
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for table fivem.boats
15CREATE TABLE IF NOT EXISTS `boats` (
16 `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
17 `model` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
18 `price` int(11) NOT NULL,
19 `category` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
20 PRIMARY KEY (`model`)
21) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
22
23-- Dumping data for table fivem.boats: ~16 rows (approximately)
24/*!40000 ALTER TABLE `boats` DISABLE KEYS */;
25INSERT INTO `boats` (`name`, `model`, `price`, `category`) VALUES
26 ('Dinghy 4Seat', 'dinghy', 25000, 'boat'),
27 ('Dinghy 2Seat', 'dinghy2', 20000, 'boat'),
28 ('Dinghy Yacht', 'dinghy4', 25000, 'boat'),
29 ('Jetmax', 'jetmax', 30000, 'boat'),
30 ('Marquis', 'marquis', 45000, 'boat'),
31 ('Seashark', 'seashark', 10000, 'boat'),
32 ('Seashark Yacht', 'seashark3', 10000, 'boat'),
33 ('Speeder', 'speeder', 40000, 'boat'),
34 ('Squalo', 'squalo', 32000, 'boat'),
35 ('Submarine', 'submersible', 29000, 'subs'),
36 ('Kraken', 'submersible2', 31000, 'subs'),
37 ('Suntrap', 'suntrap', 34000, 'boat'),
38 ('Toro', 'toro', 38000, 'boat'),
39 ('Toro Yacht', 'toro2', 38000, 'boat'),
40 ('Tropic', 'tropic', 27000, 'boat'),
41 ('Tropic Yacht', 'tropic2', 27000, 'boat');
42/*!40000 ALTER TABLE `boats` ENABLE KEYS */;
43
44-- Dumping structure for table fivem.boat_categories
45CREATE TABLE IF NOT EXISTS `boat_categories` (
46 `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
47 `label` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
48 PRIMARY KEY (`name`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
50
51-- Dumping data for table fivem.boat_categories: ~2 rows (approximately)
52/*!40000 ALTER TABLE `boat_categories` DISABLE KEYS */;
53INSERT INTO `boat_categories` (`name`, `label`) VALUES
54 ('boat', 'Boats'),
55 ('subs', 'Submersibles');
56/*!40000 ALTER TABLE `boat_categories` ENABLE KEYS */;
57
58-- Dumping structure for table fivem.trucks
59CREATE TABLE IF NOT EXISTS `trucks` (
60 `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
61 `model` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
62 `price` int(11) NOT NULL,
63 `category` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
64 PRIMARY KEY (`model`)
65) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
66
67-- Dumping data for table fivem.trucks: ~28 rows (approximately)
68/*!40000 ALTER TABLE `trucks` DISABLE KEYS */;
69INSERT INTO `trucks` (`name`, `model`, `price`, `category`) VALUES
70 ('Airport Bus', 'airbus', 50000, 'trans'),
71 ('Benson', 'benson', 55000, 'box'),
72 ('Biff', 'biff', 30000, 'other'),
73 ('Boxville 1', 'boxville', 45000, 'box'),
74 ('Boxville 2', 'boxville2', 45000, 'box'),
75 ('Boxville 3', 'boxville3', 45000, 'box'),
76 ('Boxville 4', 'boxville4', 45000, 'box'),
77 ('Dozer', 'bulldozer', 20000, 'other'),
78 ('Bus', 'bus', 50000, 'trans'),
79 ('Dashound', 'coach', 50000, 'trans'),
80 ('Hauler', 'hauler', 100000, 'haul'),
81 ('Mixer 1', 'mixer', 30000, 'other'),
82 ('Mixer 2', 'mixer2', 30000, 'other'),
83 ('Mule 1', 'mule', 40000, 'box'),
84 ('Mule 2', 'mule2', 40000, 'box'),
85 ('Mule 3', 'mule3', 40000, 'box'),
86 ('Packer', 'packer', 100000, 'haul'),
87 ('Festival Bus', 'pbus2', 125000, 'trans'),
88 ('Phantom', 'phantom', 105000, 'haul'),
89 ('Phantom Custom', 'phantom3', 110000, 'haul'),
90 ('Pounder', 'pounder', 55000, 'box'),
91 ('Rental Bus', 'rentalbus', 35000, 'trans'),
92 ('Rubble', 'rubble', 30000, 'other'),
93 ('Scrap Truck', 'scrap', 10000, 'other'),
94 ('Tipper 1', 'tiptruck', 30000, 'other'),
95 ('Tipper 2', 'tiptruck2', 30000, 'other'),
96 ('Tour Bus', 'tourbus', 35000, 'trans'),
97 ('Field Master', 'tractor2', 15000, 'other');
98/*!40000 ALTER TABLE `trucks` ENABLE KEYS */;
99
100-- Dumping structure for table fivem.truck_categories
101CREATE TABLE IF NOT EXISTS `truck_categories` (
102 `name` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
103 `label` varchar(60) COLLATE utf8mb4_unicode_ci NOT NULL,
104 PRIMARY KEY (`name`)
105) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
106
107-- Dumping data for table fivem.truck_categories: ~4 rows (approximately)
108/*!40000 ALTER TABLE `truck_categories` DISABLE KEYS */;
109INSERT INTO `truck_categories` (`name`, `label`) VALUES
110 ('box', 'Boxed Trucks'),
111 ('haul', 'Haulers'),
112 ('other', 'Other Trucks'),
113 ('trans', 'Transport Trucks');
114/*!40000 ALTER TABLE `truck_categories` ENABLE KEYS */;
115
116/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
117/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
118/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;