· 5 years ago · Mar 28, 2020, 10:28 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.4.11-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 10.3.0.5771
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
15-- Dumping database structure for vrp
16CREATE DATABASE IF NOT EXISTS `vrp` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `vrp`;
18
19-- Dumping structure for table vrp.vrp_users
20CREATE TABLE IF NOT EXISTS `vrp_users` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `last_login` varchar(100) DEFAULT NULL,
23 `last_date` text CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
24 `whitelisted` tinyint(1) DEFAULT NULL,
25 `banned` tinyint(1) DEFAULT NULL,
26 `reason` text CHARACTER SET utf8 DEFAULT NULL,
27 `DmvTest` int(11) NOT NULL DEFAULT 1,
28 `warnings` int(11) DEFAULT 0,
29 `bankPin` int(11) DEFAULT 0,
30 `diedleft` int(11) DEFAULT 0,
31 `brugernavn` varchar(50) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
32 `kode` varchar(50) CHARACTER SET utf8 COLLATE utf8_danish_ci DEFAULT NULL,
33 `_updated` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=latin1;
36
37-- Dumping structure for table vrp.vrp_user_business
38CREATE TABLE IF NOT EXISTS `vrp_user_business` (
39 `user_id` int(11) NOT NULL,
40 `name` varchar(30) DEFAULT NULL,
41 `description` text DEFAULT NULL,
42 `capital` int(11) DEFAULT NULL,
43 `laundered` int(11) DEFAULT NULL,
44 `reset_timestamp` int(11) DEFAULT NULL,
45 PRIMARY KEY (`user_id`),
46 CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49-- Dumping data for table vrp.vrp_user_business: ~0 rows (approximately)
50/*!40000 ALTER TABLE `vrp_user_business` DISABLE KEYS */;
51/*!40000 ALTER TABLE `vrp_user_business` ENABLE KEYS */;
52
53-- Dumping structure for table vrp.vrp_user_data
54CREATE TABLE IF NOT EXISTS `vrp_user_data` (
55 `user_id` int(11) NOT NULL,
56 `dkey` varchar(100) NOT NULL,
57 `dvalue` text DEFAULT NULL,
58 PRIMARY KEY (`user_id`,`dkey`),
59 CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
60) ENGINE=InnoDB DEFAULT CHARSET=latin1;
61
62
63-- Dumping structure for table vrp.vrp_user_homes
64CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
65 `user_id` int(11) NOT NULL,
66 `home` varchar(100) DEFAULT NULL,
67 `number` int(11) DEFAULT NULL,
68 PRIMARY KEY (`user_id`),
69 UNIQUE KEY `home` (`home`,`number`),
70 CONSTRAINT `fk_user_homes_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
71) ENGINE=InnoDB DEFAULT CHARSET=latin1;
72
73-- Dumping data for table vrp.vrp_user_homes: ~1 rows (approximately)
74/*!40000 ALTER TABLE `vrp_user_homes` DISABLE KEYS */;
75INSERT INTO `vrp_user_homes` (`user_id`, `home`, `number`) VALUES
76 (7, 'Villa Wm Dri.', 1);
77/*!40000 ALTER TABLE `vrp_user_homes` ENABLE KEYS */;
78
79-- Dumping structure for table vrp.vrp_user_identities
80CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
81 `user_id` int(11) NOT NULL,
82 `registration` varchar(20) DEFAULT NULL,
83 `phone` varchar(20) DEFAULT NULL,
84 `firstname` varchar(50) DEFAULT NULL,
85 `name` varchar(50) DEFAULT NULL,
86 `age` int(11) DEFAULT NULL,
87 PRIMARY KEY (`user_id`),
88 KEY `registration` (`registration`),
89 KEY `phone` (`phone`),
90 CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
91) ENGINE=InnoDB DEFAULT CHARSET=latin1;
92
93-- Dumping structure for table vrp.vrp_user_ids
94CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
95 `identifier` varchar(100) NOT NULL,
96 `user_id` int(11) DEFAULT NULL,
97 PRIMARY KEY (`identifier`),
98 KEY `fk_user_ids_users` (`user_id`),
99 CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101
102-- Dumping structure for table vrp.vrp_user_moneys
103CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
104 `user_id` int(11) NOT NULL,
105 `wallet` int(11) DEFAULT NULL,
106 `bank` int(11) DEFAULT NULL,
107 PRIMARY KEY (`user_id`),
108 CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
109) ENGINE=InnoDB DEFAULT CHARSET=latin1;
110
111
112-- Dumping structure for table vrp.vrp_user_vehicles
113CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
114 `user_id` int(11) NOT NULL DEFAULT 0,
115 `vehicle` varchar(255) NOT NULL DEFAULT '',
116 `vehicle_name` varchar(255) NOT NULL,
117 `vehicle_plate` varchar(15) NOT NULL,
118 `veh_type` varchar(255) NOT NULL DEFAULT 'default',
119 `vehicle_colorprimary` varchar(255) DEFAULT NULL,
120 `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
121 `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
122 `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
123 `vehicle_plateindex` varchar(255) DEFAULT NULL,
124 `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
125 `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
126 `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
127 `vehicle_windowtint` varchar(255) DEFAULT NULL,
128 `vehicle_wheeltype` varchar(255) DEFAULT NULL,
129 `vehicle_mods0` varchar(255) DEFAULT NULL,
130 `vehicle_mods1` varchar(255) DEFAULT NULL,
131 `vehicle_mods2` varchar(255) DEFAULT NULL,
132 `vehicle_mods3` varchar(255) DEFAULT NULL,
133 `vehicle_mods4` varchar(255) DEFAULT NULL,
134 `vehicle_mods5` varchar(255) DEFAULT NULL,
135 `vehicle_mods6` varchar(255) DEFAULT NULL,
136 `vehicle_mods7` varchar(255) DEFAULT NULL,
137 `vehicle_mods8` varchar(255) DEFAULT NULL,
138 `vehicle_mods9` varchar(255) DEFAULT NULL,
139 `vehicle_mods10` varchar(255) DEFAULT NULL,
140 `vehicle_mods11` varchar(255) DEFAULT NULL,
141 `vehicle_mods12` varchar(255) DEFAULT NULL,
142 `vehicle_mods13` varchar(255) DEFAULT NULL,
143 `vehicle_mods14` varchar(255) DEFAULT NULL,
144 `vehicle_mods15` varchar(255) DEFAULT NULL
145 `vehicle_mods16` varchar(255) DEFAULT NULL,
146 `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
147 `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
148 `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
149 `vehicle_mods23` varchar(255) DEFAULT NULL,
150 `vehicle_mods24` varchar(255) DEFAULT NULL,
151 `vehicle_neon0` varchar(255) DEFAULT NULL,
152 `vehicle_neon1` varchar(255) DEFAULT NULL,
153 `vehicle_neon2` varchar(255) DEFAULT NULL,
154 `vehicle_neon3` varchar(255) DEFAULT NULL,
155 `vehicle_bulletproof` varchar(255) DEFAULT NULL,
156 `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
157 `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
158 `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
159 `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
160 `vehicle_price` int(60) NOT NULL DEFAULT 0,
161 PRIMARY KEY (`user_id`,`vehicle_plate`,`vehicle`) USING BTREE,
162 CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
163) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
164
165-- Dumping structure for table vrp.vrp_wanted
166CREATE TABLE IF NOT EXISTS `vrp_wanted` (
167 `user_id` int(11) DEFAULT NULL,
168 `wantedreason` varchar(100) DEFAULT NULL,
169 `wantedby` int(11) DEFAULT NULL,
170 `timestamp` int(11) DEFAULT NULL,
171 `count` int(11) DEFAULT NULL
172) ENGINE=InnoDB DEFAULT CHARSET=latin1;
173
174-- Dumping data for table vrp.vrp_wanted: ~2 rows (approximately)
175/*!40000 ALTER TABLE `vrp_wanted` DISABLE KEYS */;
176INSERT INTO `vrp_wanted` (`user_id`, `wantedreason`, `wantedby`, `timestamp`, `count`) VALUES
177 (45, '<br />1: Flugt Fra politiet\n', 0, 1584655026, 1),
178 (30, '<br />1: Flugt fra politiet', 0, 1584730716, 1);
179/*!40000 ALTER TABLE `vrp_wanted` ENABLE KEYS */;
180
181-- Dumping structure for table vrp.wanted
182CREATE TABLE IF NOT EXISTS `wanted` (
183 `wantedID` varchar(64) NOT NULL,
184 `wantedName` varchar(32) NOT NULL,
185 `wantedCrimes` text NOT NULL,
186 `wantedBounty` int(100) NOT NULL,
187 `active` tinyint(1) NOT NULL DEFAULT 0,
188 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
189 PRIMARY KEY (`wantedID`) USING BTREE
190) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
191
192-- Dumping data for table vrp.wanted: ~0 rows (approximately)
193/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
194/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
195
196/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
197/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
198/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;