tJhKb90U

1
2CREATE DATABASE IF NOT EXISTS `fivem` /*!40100 DEFAULT CHARACTER SET latin1 */;
3USE `fivem`;
4
5-- Dumping structure for table fivem.vrp_srv_data
6CREATE TABLE IF NOT EXISTS `vrp_srv_data` (
7  `dkey` varchar(255) NOT NULL,
8  `dvalue` text,
9  PRIMARY KEY (`dkey`)
10) ENGINE=InnoDB DEFAULT CHARSET=latin1;
11
12-- Dumping data for table fivem.vrp_srv_data: ~1 rows (approximately)
13/*!40000 ALTER TABLE `vrp_srv_data` DISABLE KEYS */;
14INSERT INTO `vrp_srv_data` (`dkey`, `dvalue`) VALUES
15	('vRP:hidden_trs', '{"weed field":{"timestamp":1523927812,"position":[1873.3690185547,3658.4621582031,33.802974700928]},"ems":{"timestamp":1523947437,"position":[-1145.8566894531,4939.5083007813,222.2686920166]},"police1":{"timestamp":1523947437,"position":[439.57083129883,-995.072265625,30.689596176147]},"lsd bar":{"timestamp":1523947437,"position":[1992.5993652344,3044.1806640625,47.215068817139]},"cocaine dealer":{"timestamp":1523947437,"position":[-631.00543212891,-229.42568969727,38.057052612305]},"police2":{"timestamp":1523947437,"position":[1851.6605224609,3690.6713867188,34.267044067383]},"police3":{"timestamp":1523947437,"position":[-449.43395996094,6010.796875,31.716377258301]}}');
16/*!40000 ALTER TABLE `vrp_srv_data` ENABLE KEYS */;
17
18-- Dumping structure for table fivem.vrp_users
19CREATE TABLE IF NOT EXISTS `vrp_users` (
20  `id` int(11) NOT NULL AUTO_INCREMENT,
21  `last_login` varchar(255) DEFAULT NULL,
22  `whitelisted` tinyint(1) DEFAULT NULL,
23  `banned` tinyint(1) DEFAULT NULL,
24  PRIMARY KEY (`id`)
25) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
26
27-- Dumping data for table fivem.vrp_users: ~3 rows (approximately)
28/*!40000 ALTER TABLE `vrp_users` DISABLE KEYS */;
29/*!40000 ALTER TABLE `vrp_users` ENABLE KEYS */;
30
31-- Dumping structure for table fivem.vrp_user_business
32CREATE TABLE IF NOT EXISTS `vrp_user_business` (
33  `user_id` int(11) NOT NULL,
34  `name` varchar(30) DEFAULT NULL,
35  `description` text,
36  `capital` int(11) DEFAULT NULL,
37  `laundered` int(11) DEFAULT NULL,
38  `reset_timestamp` int(11) DEFAULT NULL,
39  PRIMARY KEY (`user_id`),
40  CONSTRAINT `fk_user_business_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
41) ENGINE=InnoDB DEFAULT CHARSET=latin1;
42
43-- Dumping data for table fivem.vrp_user_business: ~0 rows (approximately)
44/*!40000 ALTER TABLE `vrp_user_business` DISABLE KEYS */;
45/*!40000 ALTER TABLE `vrp_user_business` ENABLE KEYS */;
46
47-- Dumping structure for table fivem.vrp_user_data
48CREATE TABLE IF NOT EXISTS `vrp_user_data` (
49  `user_id` int(11) NOT NULL,
50  `dkey` varchar(255) NOT NULL,
51  `dvalue` text,
52  PRIMARY KEY (`user_id`,`dkey`),
53  CONSTRAINT `fk_user_data_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
54) ENGINE=InnoDB DEFAULT CHARSET=latin1;
55
56-- Dumping data for table fivem.vrp_user_data: ~4 rows (approximately)
57/*!40000 ALTER TABLE `vrp_user_data` DISABLE KEYS */;
58/*!40000 ALTER TABLE `vrp_user_data` ENABLE KEYS */;
59
60-- Dumping structure for table fivem.vrp_user_homes
61CREATE TABLE IF NOT EXISTS `vrp_user_homes` (
62  `user_id` int(11) NOT NULL,
63  `home` varchar(255) DEFAULT NULL,
64  `number` int(11) DEFAULT NULL,
65  PRIMARY KEY (`user_id`),
66  UNIQUE KEY `home` (`home`,`number`),
67  CONSTRAINT `fk_user_homes_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70-- Dumping data for table fivem.vrp_user_homes: ~0 rows (approximately)
71/*!40000 ALTER TABLE `vrp_user_homes` DISABLE KEYS */;
72/*!40000 ALTER TABLE `vrp_user_homes` ENABLE KEYS */;
73
74-- Dumping structure for table fivem.vrp_user_identities
75CREATE TABLE IF NOT EXISTS `vrp_user_identities` (
76  `user_id` int(11) NOT NULL,
77  `registration` varchar(20) DEFAULT NULL,
78  `phone` varchar(20) DEFAULT NULL,
79  `firstname` varchar(50) DEFAULT NULL,
80  `name` varchar(50) DEFAULT NULL,
81  `age` int(11) DEFAULT NULL,
82  PRIMARY KEY (`user_id`),
83  KEY `registration` (`registration`),
84  KEY `phone` (`phone`),
85  CONSTRAINT `fk_user_identities_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
86) ENGINE=InnoDB DEFAULT CHARSET=latin1;
87
88-- Dumping data for table fivem.vrp_user_identities: ~3 rows (approximately)
89/*!40000 ALTER TABLE `vrp_user_identities` DISABLE KEYS */;
90/*!40000 ALTER TABLE `vrp_user_identities` ENABLE KEYS */;
91
92-- Dumping structure for table fivem.vrp_user_ids
93CREATE TABLE IF NOT EXISTS `vrp_user_ids` (
94  `identifier` varchar(255) NOT NULL,
95  `user_id` int(11) DEFAULT NULL,
96  PRIMARY KEY (`identifier`),
97  KEY `fk_user_ids_users` (`user_id`),
98  CONSTRAINT `fk_user_ids_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
99) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101-- Dumping data for table fivem.vrp_user_ids: ~6 rows (approximately)
102/*!40000 ALTER TABLE `vrp_user_ids` DISABLE KEYS */;
103/*!40000 ALTER TABLE `vrp_user_ids` ENABLE KEYS */;
104
105-- Dumping structure for table fivem.vrp_user_moneys
106CREATE TABLE IF NOT EXISTS `vrp_user_moneys` (
107  `user_id` int(11) NOT NULL,
108  `wallet` int(11) DEFAULT NULL,
109  `bank` int(11) DEFAULT NULL,
110  PRIMARY KEY (`user_id`),
111  CONSTRAINT `fk_user_moneys_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
112) ENGINE=InnoDB DEFAULT CHARSET=latin1;
113
114-- Dumping data for table fivem.vrp_user_moneys: ~3 rows (approximately)
115/*!40000 ALTER TABLE `vrp_user_moneys` DISABLE KEYS */;
116/*!40000 ALTER TABLE `vrp_user_moneys` ENABLE KEYS */;
117
118-- Dumping structure for table fivem.vrp_user_vehicles
119CREATE TABLE IF NOT EXISTS `vrp_user_vehicles` (
120  `user_id` int(11) NOT NULL,
121  `vehicle` varchar(255) NOT NULL,
122  PRIMARY KEY (`user_id`,`vehicle`),
123  CONSTRAINT `fk_user_vehicles_users` FOREIGN KEY (`user_id`) REFERENCES `vrp_users` (`id`) ON DELETE CASCADE
124) ENGINE=InnoDB DEFAULT CHARSET=latin1;
125
126-- Dumping data for table fivem.vrp_user_vehicles: ~0 rows (approximately)
127/*!40000 ALTER TABLE `vrp_user_vehicles` DISABLE KEYS */;
128/*!40000 ALTER TABLE `vrp_user_vehicles` ENABLE KEYS */;
129
130/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
131/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
132/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;