4K5Dk3t1

1-- --------------------------------------------------------
2-- Vært:                         185.168.8.167
3-- Server-version:               5.7.23-0ubuntu0.16.04.1 - (Ubuntu)
4-- ServerOS:                     Linux
5-- HeidiSQL Version:             9.5.0.5196
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 vrpfx
16CREATE DATABASE IF NOT EXISTS `vrpfx` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `vrpfx`;
18
19-- Dumping structure for tabel vrpfx.vrp_srv_data
20CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
21  `dkey` varchar(255) NOT NULL,
22  `dvalue` text,
23  PRIMARY KEY (`dkey`)
24) ENGINE=InnoDB DEFAULT CHARSET=latin1;
25
26-- Data exporting was unselected.
27-- Dumping structure for tabel vrpfx.vrp_users
28CREATE TABLE IF NOT EXISTS `vrp_users` (
29  `id` int(11) NOT NULL AUTO_INCREMENT,
30  `last_login` varchar(255) DEFAULT NULL,
31  `whitelisted` tinyint(1) DEFAULT NULL,
32  `banned` tinyint(1) DEFAULT NULL,
33  `DmvTest` varchar(50) NOT NULL DEFAULT 'Required',
34  PRIMARY KEY (`id`)
35) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
36
37-- Data exporting was unselected.
38-- Dumping structure for tabel vrpfx.vrp_user_business
39CREATE TABLE IF NOT EXISTS `vrp_user_business` (
40  `user_id` int(11) NOT NULL,
41  `name` varchar(30) DEFAULT NULL,
42  `description` text,
43  `capital` int(11) DEFAULT NULL,
44  `laundered` int(11) DEFAULT NULL,
45  `reset_timestamp` int(11) DEFAULT NULL,
46  PRIMARY KEY (`user_id`),
47  CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
48) ENGINE=InnoDB DEFAULT CHARSET=latin1;
49
50-- Data exporting was unselected.
51-- Dumping structure for tabel vrpfx.vrp_user_data
52CREATE TABLE IF NOT EXISTS `vrp_user_data` (
53  `user_id` int(11) NOT NULL,
54  `dkey` varchar(255) NOT NULL,
55  `dvalue` text,
56  PRIMARY KEY (`user_id`,`dkey`),
57  CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60-- Data exporting was unselected.
61-- Dumping structure for tabel vrpfx.vrp_user_homes
62CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
63  `user_id` int(11) NOT NULL,
64  `home` varchar(255) DEFAULT NULL,
65  `number` int(11) DEFAULT NULL,
66  PRIMARY KEY (`user_id`),
67  UNIQUE KEY `home` (`home`,`number`),
68  CONSTRAINT `fk_user_homes_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
69) ENGINE=InnoDB DEFAULT CHARSET=latin1;
70
71-- Data exporting was unselected.
72-- Dumping structure for tabel vrpfx.vrp_user_identities
73CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
74  `user_id` int(11) NOT NULL,
75  `registration` varchar(20) DEFAULT NULL,
76  `phone` varchar(20) DEFAULT NULL,
77  `firstname` varchar(50) DEFAULT NULL,
78  `name` varchar(50) DEFAULT NULL,
79  `age` int(11) DEFAULT NULL,
80  PRIMARY KEY (`user_id`),
81  KEY `registration` (`registration`),
82  KEY `phone` (`phone`),
83  CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
84) ENGINE=InnoDB DEFAULT CHARSET=latin1;
85
86-- Data exporting was unselected.
87-- Dumping structure for tabel vrpfx.vrp_user_ids
88CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
89  `identifier` varchar(255) NOT NULL,
90  `user_id` int(11) DEFAULT NULL,
91  PRIMARY KEY (`identifier`),
92  KEY `fk_user_ids_users` (`user_id`),
93  CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
94) ENGINE=InnoDB DEFAULT CHARSET=latin1;
95
96-- Data exporting was unselected.
97-- Dumping structure for tabel vrpfx.vrp_user_moneys
98CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
99  `user_id` int(11) NOT NULL,
100  `wallet` int(11) DEFAULT NULL,
101  `bank` int(11) DEFAULT NULL,
102  PRIMARY KEY (`user_id`),
103  CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106-- Data exporting was unselected.
107-- Dumping structure for tabel vrpfx.vrp_user_vehicles
108CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
109  `user_id` int(11) NOT NULL,
110  `vehicle` varchar(255) NOT NULL,
111  `veh_type` varchar(255) NOT NULL DEFAULT 'default',
112  `vehicle_plate` varchar(255) NOT NULL,
113  `vehicle_colorprimary` varchar(255) DEFAULT NULL,
114  `vehicle_colorsecondary` varchar(255) DEFAULT NULL,
115  `vehicle_pearlescentcolor` varchar(255) DEFAULT NULL,
116  `vehicle_wheelcolor` varchar(255) DEFAULT NULL,
117  `vehicle_plateindex` varchar(255) DEFAULT NULL,
118  `vehicle_neoncolor1` varchar(255) DEFAULT NULL,
119  `vehicle_neoncolor2` varchar(255) DEFAULT NULL,
120  `vehicle_neoncolor3` varchar(255) DEFAULT NULL,
121  `vehicle_windowtint` varchar(255) DEFAULT NULL,
122  `vehicle_wheeltype` varchar(255) DEFAULT NULL,
123  `vehicle_mods0` varchar(255) DEFAULT NULL,
124  `vehicle_mods1` varchar(255) DEFAULT NULL,
125  `vehicle_mods2` varchar(255) DEFAULT NULL,
126  `vehicle_mods3` varchar(255) DEFAULT NULL,
127  `vehicle_mods4` varchar(255) DEFAULT NULL,
128  `vehicle_mods5` varchar(255) DEFAULT NULL,
129  `vehicle_mods6` varchar(255) DEFAULT NULL,
130  `vehicle_mods7` varchar(255) DEFAULT NULL,
131  `vehicle_mods8` varchar(255) DEFAULT NULL,
132  `vehicle_mods9` varchar(255) DEFAULT NULL,
133  `vehicle_mods10` varchar(255) DEFAULT NULL,
134  `vehicle_mods11` varchar(255) DEFAULT NULL,
135  `vehicle_mods12` varchar(255) DEFAULT NULL,
136  `vehicle_mods13` varchar(255) DEFAULT NULL,
137  `vehicle_mods14` varchar(255) DEFAULT NULL,
138  `vehicle_mods15` varchar(255) DEFAULT NULL,
139  `vehicle_mods16` varchar(255) DEFAULT NULL,
140  `vehicle_turbo` varchar(255) NOT NULL DEFAULT 'off',
141  `vehicle_tiresmoke` varchar(255) NOT NULL DEFAULT 'off',
142  `vehicle_xenon` varchar(255) NOT NULL DEFAULT 'off',
143  `vehicle_mods23` varchar(255) DEFAULT NULL,
144  `vehicle_mods24` varchar(255) DEFAULT NULL,
145  `vehicle_neon0` varchar(255) DEFAULT NULL,
146  `vehicle_neon1` varchar(255) DEFAULT NULL,
147  `vehicle_neon2` varchar(255) DEFAULT NULL,
148  `vehicle_neon3` varchar(255) DEFAULT NULL,
149  `vehicle_bulletproof` varchar(255) DEFAULT NULL,
150  `vehicle_smokecolor1` varchar(255) DEFAULT NULL,
151  `vehicle_smokecolor2` varchar(255) DEFAULT NULL,
152  `vehicle_smokecolor3` varchar(255) DEFAULT NULL,
153  `vehicle_modvariation` varchar(255) NOT NULL DEFAULT 'off',
154  PRIMARY KEY (`user_id`,`vehicle`),
155  CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
156) ENGINE=InnoDB DEFAULT CHARSET=latin1;
157
158-- Data exporting was unselected.
159/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
160/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
161/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;