· 6 years ago · Jul 29, 2019, 04:16 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Versión del servidor: 5.7.13-log - MySQL Community Server (GPL)
4-- SO del servidor: Win64
5-- HeidiSQL Versión: 9.4.0.5164
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-- Volcando estructura de base de datos para rpframework
16CREATE DATABASE IF NOT EXISTS `rpframework` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `rpframework`;
18
19-- Volcando estructura para tabla rpframework.crimecategories
20CREATE TABLE IF NOT EXISTS `crimecategories` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `name` varchar(255) NOT NULL,
23 PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26-- Volcando datos para la tabla rpframework.crimecategories: ~10 rows (aproximadamente)
27/*!40000 ALTER TABLE `crimecategories` DISABLE KEYS */;
28INSERT INTO `crimecategories` (`id`, `name`) VALUES
29 (1, 'Anticipatory offenses'),
30 (2, 'Offenses against persons'),
31 (3, 'Offenses involving theft'),
32 (4, 'Offenses involving fraud'),
33 (5, 'Offenses involving damage to property'),
34 (6, 'Offenses against public administration'),
35 (7, 'Offenses against public order'),
36 (8, 'Offenses against public health and morals'),
37 (9, 'Offenses against public safety'),
38 (10, 'Offenses involving operation of a vehicle');
39/*!40000 ALTER TABLE `crimecategories` ENABLE KEYS */;
40
41-- Volcando estructura para tabla rpframework.crimeclasses
42CREATE TABLE IF NOT EXISTS `crimeclasses` (
43 `id` int(11) NOT NULL AUTO_INCREMENT,
44 `class` varchar(255) NOT NULL,
45 `punishment` int(15) NOT NULL,
46 `maxpunishment` int(15) NOT NULL,
47 PRIMARY KEY (`id`)
48) ENGINE=InnoDB DEFAULT CHARSET=utf8;
49
50-- Volcando datos para la tabla rpframework.crimeclasses: ~8 rows (aproximadamente)
51/*!40000 ALTER TABLE `crimeclasses` DISABLE KEYS */;
52INSERT INTO `crimeclasses` (`id`, `class`, `punishment`, `maxpunishment`) VALUES
53 (1, 'Infraction', 0, 0),
54 (2, 'B Misdemeanor', 5, 10),
55 (3, 'A Misdemeanor', 11, 15),
56 (4, 'D Felony', 11, 15),
57 (5, 'C Felony', 16, 20),
58 (6, 'B Felony', 21, 25),
59 (7, 'A Felony', 26, 35),
60 (8, 'Unclassified', 0, 0);
61/*!40000 ALTER TABLE `crimeclasses` ENABLE KEYS */;
62
63-- Volcando estructura para tabla rpframework.crimes
64CREATE TABLE IF NOT EXISTS `crimes` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `category` int(11) NOT NULL,
67 `class` int(15) NOT NULL,
68 `penalty` int(15) NOT NULL,
69 `name` varchar(255) NOT NULL,
70 `description` mediumtext NOT NULL,
71 PRIMARY KEY (`id`)
72) ENGINE=InnoDB DEFAULT CHARSET=utf8;
73
74-- Volcando datos para la tabla rpframework.crimes: ~83 rows (aproximadamente)
75/*!40000 ALTER TABLE `crimes` DISABLE KEYS */;
76INSERT INTO `crimes` (`id`, `category`, `class`, `penalty`, `name`, `description`) VALUES
77 (1, 1, 8, 0, 'Accessory', 'A person is guilty of Accessory when he renders aid to a person who commits such crime.'),
78 (2, 1, 8, 0, 'Attempt', 'A person is guilty of Attempt when he engages in conduct which tends to affect commission of such crime.'),
79 (3, 1, 8, 0, 'Solicitation', 'A person is guilty of Solicitation when he solicits, requests, or commands a person to commit such crime.'),
80 (4, 1, 8, 0, 'Conspiracy', 'A person is guilty of Conspiracy when he plans to commit a crime before the action happens.'),
81 (5, 2, 2, 0, 'Assault, 2nd degree', 'A person is guilty of Assault, 2nd degree when he threatens to kill another person.'),
82 (6, 2, 4, 0, 'Assault, 1st degree', 'A person is guilty of Assault, 1st degree when he physically hurts another person.'),
83 (7, 2, 5, 0, 'Assault, aggravated', 'A person is guilty of Assault, aggravated when he 1) physically hurts another person with a weapon, or 2) threatens to kill a Public Official.'),
84 (8, 2, 4, 0, 'Manslaughter, involuntary', 'A person is guilty of Manslaughter, involuntary when he 1) recklessly or accidentally kills another person, or \r\n2) causes or aids another person in suicide.'),
85 (9, 2, 5, 0, 'Manslaughter, voluntary', 'A person is guilty of Manslaughter, voluntary when he recklessly or accidentally kills another person with intent to physically hurt the person.'),
86 (10, 2, 6, 0, 'Murder, 2nd degree', 'A person is guilty of Murder, 2nd degree when he kills another person with the intent to kill.'),
87 (11, 2, 7, 0, 'Murder, 1st degree', 'A person is guilty of Murder, 1st degree when he kills another person with the intent to kill, along with premeditation and deliberation.'),
88 (12, 2, 3, 0, 'Unlawful imprisonment', 'A person is guilty of Unlawful imprisonment when he restricts a person\'s movement within any area without justification or consent.'),
89 (13, 2, 6, 0, 'Kidnapping, 2nd degree', 'A person is guilty of Kidnapping, 2nd degree when he abducts another person and holds them against their will.'),
90 (14, 2, 7, 0, 'Kidnapping, 1st degree', 'A person is guilty of Kidnapping, 1st degree when he abducts a law enforcement officer and holds them against their will.'),
91 (15, 3, 6, 0, 'Bank robbery', 'A person is guilty of Bank robbery when he robs a bank.'),
92 (16, 3, 4, 0, 'Grand larceny', 'A person is guilty of Grand larceny when he steals a vehicle.'),
93 (17, 3, 5, 0, 'Government grand larceny', 'A person is guilty of Government grand larceny when he steals a vehicle that belongs to the government'),
94 (18, 3, 4, 0, 'Larceny', 'A person is guilty of Larceny when he steals property excluding vehicles.'),
95 (19, 3, 6, 0, 'Robbery', 'A person is guilty of Robbery when he forcibly steals property with a weapon.'),
96 (20, 5, 5, 0, 'Burglary', 'A person is guilty of Burglary when he enters knowingly or remains unlawfully in a building with intent to commit a crime.'),
97 (21, 5, 3, 0, 'Trespassing', 'A person is guilty of Trespassing when he enters knowingly or remains unlawfully in or upon government premises or private property.'),
98 (22, 6, 1, 1000, 'Unlicensed fishing', 'A person is guilty of Unlicensed fishing when he fishes without a proper license.'),
99 (23, 6, 4, 0, 'Bribery', 'A person is guilty of Bribery when he confers, or agrees to confer, any benefit upon a public servant upon an\nagreement or understanding that such public servant`s vote, opinion,\njudgment, action, decision or exercise of discretion as a public servant\nwill thereby be influenced.'),
100 (24, 6, 7, 0, 'Criminal contempt', 'A person is guilty of Criminal contempt when he acts disruptively in judicial proceedings or intentionally disobeys or resists to the lawful process or other mandate of a court.'),
101 (25, 6, 5, 0, 'Criminal possession of stolen property', 'A person is guilty of Criminal possession of stolen property when he possesses any items from a police officer or public official including clothing or weapons.'),
102 (26, 6, 5, 0, 'Escaping', 'A person is guilty of Escaping when he escapes the custody of the government.'),
103 (27, 6, 7, 0, 'Jailbreak', 'A person is guilty of Jailbreak when he breaks into government buildings designated for detainment or imprisonment with intent to break a prisoner out.'),
104 (28, 6, 7, 0, 'Perjury', 'A person is guilty of Perjury when he knowingly lies under oath in judicial proceedings.'),
105 (29, 6, 1, 1000, 'Unauthorized practice of law', 'A person is guilty of Unauthorized practice of law when he practices law without a proper bar certification.'),
106 (30, 4, 5, 0, 'Extortion', 'A person is guilty of Extortion when he uses threats or force to obtain monetary or material gain.'),
107 (31, 4, 4, 0, 'Fraud', 'A person is guilty of Fraud when he wrongfully deceits intending to receive financial or personal gain.'),
108 (32, 4, 5, 0, 'Impersonating', 'A person is guilty of Impersonating when he impersonates a law enforcement officer, an emergency medical technician, or other public official.'),
109 (33, 7, 3, 0, 'Disobeying a lawful order of police officer', 'A person is guilty of Disobeying a lawful order of police officer when he does not obey an order given by an police officer. '),
110 (34, 7, 3, 0, 'Disorderly conduct', 'A person is guilty of Disorderly conduct when he engages in behavior intending to cause public inconvenience.'),
111 (35, 7, 1, 2500, 'Disturbing the peace', 'A person is guilty of Disturbing the peace when he plays loud and disturbing music in public.'),
112 (36, 7, 2, 0, 'False reporting', 'A person is guilty of False reporting when he reports a false or non existent crime.'),
113 (37, 7, 3, 0, 'Harassment', 'A person is guilty of Harassment when he intimidates or pressures another person aggressively with unwelcome words, deeds, actions, or gestures.'),
114 (38, 7, 3, 0, 'Obstruction of justice', 'A person is guilty of Obstruction of justice when he hinders the discovery, apprehension, conviction, or punishment of a person who committed a crime.'),
115 (39, 7, 2, 0, 'Riot', 'A person is guilty of Riot when he engages in violent conduct or creates a risk of causing public harm with a group of at least four people.'),
116 (40, 7, 5, 0, 'Unlawful Surveillance', 'A person is guilty of Unlawful Surveillance when he utilizes a tracking device or taps into a phone.'),
117 (41, 9, 5, 0, 'Criminal possession of firearm', 'A person is guilty of Criminal possession of firearm when he possess a class 2 or class 3 weapon.'),
118 (42, 9, 5, 0, 'Criminal sale of firearm ', 'A person is guilty of Criminal sale of firearm when he sells a class 2 or class 3 weapon.'),
119 (43, 9, 2, 0, 'Criminal use of firearm', 'A person is guilty of Criminal use of firearm when he discharges a firearm for no legal reason or displays it in a city or town.'),
120 (44, 9, 3, 0, 'Evading', 'A person is guilty of Evading when he flees from a police officer to avoid being apprehended, detained, or arrested in a vehicle.'),
121 (45, 9, 3, 0, 'Fleeing and eluding', 'A person is guilty of Fleeing and eluding when he flees from a police officer to avoid being apprehended, detained, or arrested while on foot.'),
122 (46, 9, 1, 500, 'Jaywalking', 'A person is guilty of Jaywalking when he crosses a road without the use of a crosswalk.'),
123 (47, 9, 7, 0, 'Terrorism', 'A person is guilty of Terrorism when he causes mass destruction using explosives, sickness, or extreme violence.'),
124 (48, 9, 3, 0, 'Unlicensed possession of a class 2 firearm', 'A person is guilty of Unlicensed possession of a class 2 firearm when he posses a class 2 weapon without a proper license.'),
125 (49, 9, 3, 0, 'Unlicensed possession of a class 1 firearm', 'A person is guilty of Unlicensed possession of a class 1 firearm when he posses a class 1 weapon without a proper license.'),
126 (50, 10, 3, 0, 'Driving while intoxicated', 'A person is guilty of Driving while intoxicated when he drives while affected by drug or alcohol and intoxication level is 5 or above.'),
127 (51, 10, 3, 0, 'Failure to yield to emergency vehicle', 'A person is guilty of Failure to yield to emergency vehicle when he does not pull to the side of the road when an emergency vehicle is trying to pass with sirens enabled.'),
128 (52, 10, 1, 1000, 'Failure to yield to stop sign', 'A person is guilty of Failure to yield to stop sign when he does not halt at a stop sign.'),
129 (53, 10, 1, 100, 'Failure to use turn signal', 'A person is guilty of Failure to use turn signal when he does not use a turn signal when necessary.'),
130 (54, 10, 1, 1000, 'Negligent driving', 'A person is guilty of Negligent driving when he drives in a way that is negligent.'),
131 (55, 10, 1, 1000, 'Nonfunctional lights', 'A person is guilty of Nonfunctional lights when he drives with nonfunctional lights at night time.'),
132 (56, 10, 1, 250, 'Speeding, 3rd degree ', 'A person is guilty of Speeding, 3rd degree when he speeds in excess of less than 35 km/h.'),
133 (57, 10, 1, 500, 'Speeding, 2nd degree', 'A person is guilty of Speeding, 2nd degree when he speeds in excess of 35 km/h to 70 km/h.'),
134 (58, 10, 1, 750, 'Speeding, 1st degree', 'A person is guilty of Speeding, 1st degree when he speeds in excess of more than 70 km/h.'),
135 (59, 10, 1, 1000, 'Unauthorized parking', 'A person is guilty of Unauthorized parking when he parks in an area that is unsafe or on government property.'),
136 (60, 10, 2, 0, 'Unlicensed operation of aircraft', 'A person is guilty of Unlicensed operation of aircraft when he pilots an aircraft without a proper license.'),
137 (61, 10, 1, 2000, 'Unlicensed operation of bus', 'A person is guilty of Unlicensed operation of bus when he drives a bus without a proper license.'),
138 (62, 10, 1, 5000, 'Unlicensed operation of truck', 'A person is guilty of Unlicensed operation of truck when he drives a truck without a proper license.'),
139 (63, 10, 1, 1000, 'Unlicensed operation of vehicle', 'A person is guilty of Unlicensed operation of vehicle when he drives a car without a proper license.'),
140 (64, 10, 1, 1000, 'Window tints', 'A person is guilty of Window tints when he drives with windows above a fifty tint percentage.'),
141 (78, 8, 5, 0, 'Manufacturing of controlled substance', 'A person is guilty of Manufacturing of controlled substance when he cooks or posses tools to cook a controlled substance.'),
142 (79, 8, 2, 0, 'Possession of controlled substance, 3rd degree', 'A person is guilty of Possession of controlled substance, 3rd degree when he possesses a controlled substance in the amount of one to five.'),
143 (80, 8, 3, 0, 'Possession of controlled substance, 2nd degree', 'A person is guilty of Possession of controlled substance, 2nd degree when he possesses a controlled substance in the amount of six to fifteen.'),
144 (81, 8, 5, 0, 'Possession of controlled substance, 1st degree', 'A person is guilty of Possession of controlled substance, 1st degree when he possesses a controlled substance in the amount of sixteen or more.'),
145 (82, 8, 1, 2500, 'Possession of marijuana, 2nd degree', 'A person is guilty of Possession of marijuana, 2nd degree when he possesses marijuana in the amount of six to fifteen.'),
146 (83, 8, 3, 0, 'Possession of marijuana, 1st degree', 'A person is guilty of Possession of marijuana, 1st degree when he possesses marijuana in the amount of sixteen or more.'),
147 (84, 8, 3, 0, 'Sale of controlled substance, 3rd degree', 'A person is guilty of Sale of controlled substance, 3rd degree when he sells a controlled substance in the amount of one to five.'),
148 (85, 8, 4, 0, 'Sale of controlled substance, 2nd degree', 'A person is guilty of Sale of controlled substance, 2nd degree when he sells a controlled substance in the amount of six to ten.'),
149 (86, 8, 5, 0, 'Sale of controlled substance, 1st degree', 'A person is guilty of Sale of controlled substance, 1st degree when he sells a controlled substance in the amount of eleven or more.'),
150 (87, 8, 2, 0, 'Sale of marijuana, 3rd degree', 'A person is guilty of Sale of marijuana, 3rd degree when he sells marijuana in the amount of one to five.'),
151 (88, 8, 3, 0, 'Sale of marijuana, 2nd degree', 'A person is guilty of Sale of marijuana, 2nd degree when he sells marijuana in the amount of six to ten.'),
152 (89, 8, 4, 0, 'Sale of marijuana, 1st degree', 'A person is guilty of Sale of marijuana, 1st degree when he sells marijuana in the amount of eleven or more.'),
153 (96, 6, 1, 1000, 'Unlicensed logging', 'A person is guilty of Unlicensed logging when he logs without a proper license.'),
154 (97, 6, 1, 1000, 'Unlicensed mining', 'A person is guilty of Unlicensed mining when he mines without a proper license.'),
155 (98, 6, 1, 7500, 'Unlicensed oil trading', 'A person is guilty of Unlicensed oil trading when he trades oil without a proper license.'),
156 (99, 6, 3, 0, 'Tax evasion, 2nd degree', 'A person is guilty of Tax Evasion, 2nd degree when he has an unpaid amount of $1,000 to $2,000'),
157 (100, 6, 5, 0, 'Tax evasion, 1st degree', 'A person is guilty of Tax Evasion, 1st degree when he has an unpaid amount of $2,001 or more.'),
158 (101, 6, 7, 0, 'Embezzlement', 'A person is guilty of Embezzlement when he steals or misappropriates funds that are used for a specific purpose.'),
159 (102, 6, 5, 0, 'Ethical violation', 'A person is guilty of Ethical violation when, while acting as a sworn law enforcement officer or a public official, he knowingly manipulates the judicial system to benefit a person charged with a crime.');
160/*!40000 ALTER TABLE `crimes` ENABLE KEYS */;
161
162-- Volcando estructura para tabla rpframework.garage
163CREATE TABLE IF NOT EXISTS `garage` (
164 `id` int(11) NOT NULL AUTO_INCREMENT,
165 `license` varchar(45) DEFAULT NULL,
166 `class` varchar(45) DEFAULT NULL,
167 `color` varchar(45) DEFAULT NULL,
168 `finish` varchar(45) DEFAULT NULL,
169 `rims` varchar(45) DEFAULT NULL,
170 `windows` varchar(45) DEFAULT NULL,
171 `lights` varchar(45) DEFAULT NULL,
172 `owner` varchar(45) DEFAULT NULL,
173 `statuses` varchar(45) DEFAULT NULL,
174 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
175 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
176 `spoiler` varchar(45) NOT NULL,
177 `fuel` varchar(45) NOT NULL,
178 `damage` varchar(1000) NOT NULL,
179 PRIMARY KEY (`id`),
180 UNIQUE KEY `vehicleID_UNIQUE` (`id`)
181) ENGINE=InnoDB DEFAULT CHARSET=utf8;
182
183-- Volcando datos para la tabla rpframework.garage: ~1 rows (aproximadamente)
184/*!40000 ALTER TABLE `garage` DISABLE KEYS */;
185INSERT INTO `garage` (`id`, `license`, `class`, `color`, `finish`, `rims`, `windows`, `lights`, `owner`, `statuses`, `created_at`, `updated_at`, `spoiler`, `fuel`, `damage`) VALUES
186 (1, 'vnm7095', 'FerrariF40_Car1', 'awesome', 'PearlescentGreen', 'amaranth', '0.5', '0.5', '76561197995693059', '1', '2017-12-25 19:33:59', '2018-02-10 10:34:15', '0', '0.857645', '[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]');
187/*!40000 ALTER TABLE `garage` ENABLE KEYS */;
188
189-- Volcando estructura para tabla rpframework.general
190CREATE TABLE IF NOT EXISTS `general` (
191 `id` int(11) NOT NULL AUTO_INCREMENT,
192 `key` varchar(255) DEFAULT NULL,
193 `value` varchar(10000) DEFAULT NULL,
194 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
195 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
196 PRIMARY KEY (`id`),
197 UNIQUE KEY `id_UNIQUE` (`id`)
198) ENGINE=InnoDB DEFAULT CHARSET=utf8;
199
200-- Volcando datos para la tabla rpframework.general: ~13 rows (aproximadamente)
201/*!40000 ALTER TABLE `general` DISABLE KEYS */;
202INSERT INTO `general` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
203 (1, 'casinoRate', '60', '2017-02-12 07:32:41', '2018-03-10 22:35:23'),
204 (2, 'taxRate', '5', '2017-02-12 07:32:41', '2017-04-23 17:13:25'),
205 (3, 'mafiaStash', '[[["RH_g17"],[1]],[["np_tequila","np_beer","np_ironbar1","NP_Wood","np_copperbar1","np_silverbar1","CG_wheel","np_MetalFenceGrey","RH_17Rnd_9x19_g17"],[3,7,256,114,229,44,2,2,2]],[["TRYK_Headphone_NV","TRYK_TAC_EARMUFF_SHADE","TRYK_Headset_NV","TRYK_G_Shades_Black_NV","CUP_U_C_Labcoat_02","H_Hat_grey","ItemGPS","H_Hat_tan","vvv_traje_mafioso_F_1","TRYK_Kio_Balaclava","TRYK_U_B_wh_blk_Rollup_CombatUniform","TRYK_balaclava_BLACK_NV"],[2,6,2,8,1,1,1,1,1,1,1,1]],[[],[]]]', '2017-02-12 20:02:07', '2017-05-04 09:21:54'),
206 (4, 'bikerStash', '[[["CG_PICKAXE","RH_Deagleg","Binocular","epic_fishing_rod","RH_gsh18","CG_BAT","Press_Mic_ZDF_F","RH_Deaglem","RH_g17"],[2,1,4,1,1,2,1,1,2]],[["np_copperbar1","CG_OilCanister","CG_wheel","Fish_Mackerel_7","NP_Wood","np_ironbar1","NP_kPelt","NP_drillitem","RH_7Rnd_50_AE","np_silverbar1","NP_Pelt","np_tequila","NP_uPelt","RH_18Rnd_9x19_gsh","np_tuna","np_chickensoup","np_psoup","np_peasoup","sharp_swing","np_water","CG_Lockpick","RH_6Rnd_357_Mag","nonlethal_swing","NP_DrugTable","NP_GrowingPlot"],[320,274,24,10,193,209,21,2,4,210,200,2,10,10,213,2,3,1,3,1,1,1,1,1,1]],[["Kio_Pirate_Hat","TRYK_balaclava_BLACK_NV","female_default_1","TRYK_H_Bandana_wig_g","acj_casco_calavera","acj_casco_espider","acj_casco_germani"],[2,1,2,1,1,1,1]],[[],[]]]', '2017-02-12 20:02:07', '2017-05-04 16:39:57'),
207 (5, 'mobsterStash', '[[["arifle_mas_ww2_mp44","hlc_rifle_M21","arifle_mas_ww2_ppsh","bnae_M97_virtual"],[83,1,1,1]],[["CG_Lockpick","CG_MethBag100","30Rnd_mas_ww2_mp44","NP_DrugTable","np_goldscanner","np_groceries","CG_Cocaine","CG_MetalWire","np_SatchelCharge","CG_C4","np_goldbar","6Rnd_B_00_buckshot","CG_WeedBag4"],[2,6,540,1,2,10,39,1,19,1,84,4,2]],[["U_B_Wetsuit","V_RebreatherB","CUP_U_O_SLA_MixedCamo","TRYK_balaclava_BLACK_NV","TRYK_bandana_NV","CUP_H_RUS_Beret_VDV","vvv_traje_mafioso_F_1"],[1,1,2,1,3,1,1]],[[],[]]]', '2017-02-12 20:02:07', '2018-03-10 22:34:24'),
208 (6, 'mafiaBank', '13501', '2017-02-12 20:02:07', '2017-04-28 22:19:37'),
209 (7, 'bikerBank', '276625', '2017-02-12 20:02:07', '2017-05-04 18:52:33'),
210 (8, 'mobsterBank', '3.03463e+006', '2017-02-12 20:02:07', '2017-05-04 16:47:08'),
211 (9, 'currentMayorGUID', '""', '2017-02-12 20:02:07', '2017-04-26 05:59:11'),
212 (10, 'currentPresidentSenateGUID', '""', '2017-02-12 20:02:07', '2017-04-26 05:58:59'),
213 (11, 'govtBank', '2.18972e+006', '2017-02-12 20:25:30', '2018-03-10 22:32:59'),
214 (14, 'currentSenatorsGUID', '[]', '2017-03-24 17:46:43', '2017-04-26 05:59:05'),
215 (15, 'casinoVault', '3851', '2017-03-27 02:30:53', '2017-05-04 16:47:11');
216/*!40000 ALTER TABLE `general` ENABLE KEYS */;
217
218-- Volcando estructura para tabla rpframework.licenses
219CREATE TABLE IF NOT EXISTS `licenses` (
220 `id` int(11) NOT NULL AUTO_INCREMENT,
221 `steamid` varchar(255) NOT NULL,
222 `license` int(11) NOT NULL,
223 `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
224 PRIMARY KEY (`id`)
225) ENGINE=InnoDB DEFAULT CHARSET=utf8;
226
227-- Volcando datos para la tabla rpframework.licenses: ~7 rows (aproximadamente)
228/*!40000 ALTER TABLE `licenses` DISABLE KEYS */;
229INSERT INTO `licenses` (`id`, `steamid`, `license`, `created_at`) VALUES
230 (1, '76561197995693059', 0, '2017-12-23 20:04:05'),
231 (2, '76561197995693059', 18, '2018-01-27 07:00:10'),
232 (3, '76561197995693059', 22, '2018-01-27 07:00:25'),
233 (4, '76561197995693059', 5, '2018-01-27 07:00:31'),
234 (5, '76561197995693059', 21, '2018-01-27 07:00:34'),
235 (6, '76561197995693059', 6, '2018-01-27 07:00:38'),
236 (7, '76561197995693059', 4, '2018-01-27 07:00:43');
237/*!40000 ALTER TABLE `licenses` ENABLE KEYS */;
238
239-- Volcando estructura para tabla rpframework.logs
240CREATE TABLE IF NOT EXISTS `logs` (
241 `id` int(11) NOT NULL AUTO_INCREMENT,
242 `type` varchar(45) DEFAULT NULL,
243 `description` longtext,
244 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
245 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
246 PRIMARY KEY (`id`),
247 UNIQUE KEY `id_UNIQUE` (`id`)
248) ENGINE=InnoDB DEFAULT CHARSET=utf8;
249
250-- Volcando datos para la tabla rpframework.logs: ~33 rows (aproximadamente)
251/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
252INSERT INTO `logs` (`id`, `type`, `description`, `created_at`, `updated_at`) VALUES
253 (1, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2017-12-23 20:08:52', '2017-12-23 20:08:52'),
254 (2, 'govtBank', 'florentino perez (76561197995693059) removed $3.58 into the Government bank account because of salary.', '2017-12-23 20:13:52', '2017-12-23 20:13:52'),
255 (3, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2017-12-23 20:18:54', '2017-12-23 20:18:54'),
256 (4, 'govtBank', 'florentino perez (76561197995693059) removed $3.57 into the Government bank account because of salary.', '2017-12-23 20:23:53', '2017-12-23 20:23:53'),
257 (5, 'govtBank', 'florentino perez (76561197995693059) removed $3.57 into the Government bank account because of salary.', '2017-12-25 19:41:06', '2017-12-25 19:41:06'),
258 (6, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2017-12-25 19:46:08', '2017-12-25 19:46:08'),
259 (7, 'govtBank', 'florentino perez (76561197995693059) removed $3.56 into the Government bank account because of salary.', '2017-12-25 19:51:08', '2017-12-25 19:51:08'),
260 (8, 'govtBank', 'florentino perez (76561197995693059) removed $3.55 into the Government bank account because of salary.', '2017-12-25 19:56:08', '2017-12-25 19:56:08'),
261 (9, 'govtBank', 'florentino perez (76561197995693059) removed $3.55 into the Government bank account because of salary.', '2017-12-25 20:03:37', '2017-12-25 20:03:37'),
262 (10, 'govtBank', 'florentino perez (76561197995693059) elimino $3.54 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-26 21:47:20', '2018-01-26 21:47:20'),
263 (11, 'govtBank', 'florentino perez (76561197995693059) elimino $3.55 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-26 21:52:20', '2018-01-26 21:52:20'),
264 (12, 'govtBank', 'florentino perez (76561197995693059) elimino $3.55 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-26 22:10:41', '2018-01-26 22:10:41'),
265 (13, 'govtBank', 'florentino perez (76561197995693059) elimino $3.55 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-27 06:45:46', '2018-01-27 06:45:46'),
266 (14, 'govtBank', 'florentino perez (76561197995693059) elimino $3.53 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-27 06:50:46', '2018-01-27 06:50:46'),
267 (15, 'govtBank', 'florentino perez (76561197995693059) elimino $3.54 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-27 06:55:47', '2018-01-27 06:55:47'),
268 (16, 'govtBank', 'florentino perez (76561197995693059) añadio $750.00 a la cuenta bancaria del gobierno.', '2018-01-27 06:58:56', '2018-01-27 06:58:56'),
269 (17, 'govtBank', 'florentino perez (76561197995693059) añadio $500.00 a la cuenta bancaria del gobierno.', '2018-01-27 06:59:00', '2018-01-27 06:59:00'),
270 (18, 'govtBank', 'florentino perez (76561197995693059) añadio $250.00 a la cuenta bancaria del gobierno.', '2018-01-27 06:59:03', '2018-01-27 06:59:03'),
271 (19, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:10', '2018-01-27 07:00:10'),
272 (20, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:25', '2018-01-27 07:00:25'),
273 (21, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:31', '2018-01-27 07:00:31'),
274 (22, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:34', '2018-01-27 07:00:34'),
275 (23, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:38', '2018-01-27 07:00:38'),
276 (24, 'govtBank', 'florentino perez (76561197995693059) añadio any a la cuenta bancaria del gobierno.', '2018-01-27 07:00:43', '2018-01-27 07:00:43'),
277 (25, 'govtBank', 'florentino perez (76561197995693059) elimino $17.50 de la cuenta del banco del gobierno debido a los salarios.', '2018-01-27 07:00:46', '2018-01-27 07:00:46'),
278 (26, 'govtBank', 'florentino perez (76561197995693059) elimino $3.55 de la cuenta del banco del gobierno debido a los salarios.', '2018-02-10 10:29:14', '2018-02-10 10:29:14'),
279 (27, 'govtBank', 'florentino perez (76561197995693059) elimino $3.55 de la cuenta del banco del gobierno debido a los salarios.', '2018-02-10 10:34:15', '2018-02-10 10:34:15'),
280 (28, 'govtBank', 'florentino perez (76561197995693059) removed $3.57 into the Government bank account because of salary.', '2018-03-10 21:42:05', '2018-03-10 21:42:05'),
281 (29, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2018-03-10 21:47:05', '2018-03-10 21:47:05'),
282 (30, 'govtBank', 'florentino perez (76561197995693059) removed $3.56 into the Government bank account because of salary.', '2018-03-10 21:52:05', '2018-03-10 21:52:05'),
283 (31, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2018-03-10 22:12:42', '2018-03-10 22:12:42'),
284 (32, 'govtBank', 'florentino perez (76561197995693059) removed $3.55 into the Government bank account because of salary.', '2018-03-10 22:27:58', '2018-03-10 22:27:58'),
285 (33, 'govtBank', 'florentino perez (76561197995693059) removed $3.54 into the Government bank account because of salary.', '2018-03-10 22:32:59', '2018-03-10 22:32:59');
286/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
287
288-- Volcando estructura para tabla rpframework.mail
289CREATE TABLE IF NOT EXISTS `mail` (
290 `idmail` int(11) NOT NULL AUTO_INCREMENT,
291 `message` varchar(10000) DEFAULT NULL,
292 `title` varchar(145) DEFAULT NULL,
293 `sender` varchar(145) DEFAULT NULL,
294 `receiver` varchar(45) DEFAULT NULL,
295 `readmail` int(11) DEFAULT '0',
296 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
297 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
298 PRIMARY KEY (`idmail`),
299 UNIQUE KEY `idmail_UNIQUE` (`idmail`)
300) ENGINE=InnoDB DEFAULT CHARSET=utf8;
301
302-- Volcando datos para la tabla rpframework.mail: ~4 rows (aproximadamente)
303/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
304INSERT INTO `mail` (`idmail`, `message`, `title`, `sender`, `receiver`, `readmail`, `created_at`, `updated_at`) VALUES
305 (1, 'You have been issued a ticket for speeding. Go to the court house to pay it off or face legal consequences.', 'Ticket', 'Silver Lake', '76561197995693059', 1, '2017-12-23 20:14:03', '2017-12-25 19:36:33'),
306 (2, 'You have been issued a ticket for speeding. Go to the court house to pay it off or face legal consequences.', 'Ticket', 'Silver Lake', '76561197995693059', 0, '2017-12-25 20:00:50', '2017-12-25 20:00:50'),
307 (3, 'You have been issued a ticket for speeding. Go to the court house to pay it off or face legal consequences.', 'Ticket', 'Silver Lake', '76561197995693059', 0, '2017-12-25 20:02:38', '2017-12-25 20:02:38'),
308 (4, 'Le han emitido una multa por exceso de velocidad. Vaya al juzgado a pagarla o puede tener consecuencias legales.', 'Ticket', 'Silver Lake', '76561197995693059', 0, '2018-01-27 06:57:32', '2018-01-27 06:57:32');
309/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
310
311-- Volcando estructura para tabla rpframework.messages
312CREATE TABLE IF NOT EXISTS `messages` (
313 `idmessages` int(11) NOT NULL AUTO_INCREMENT,
314 `message` varchar(10000) DEFAULT NULL,
315 `title` varchar(145) DEFAULT NULL,
316 `sender` varchar(145) DEFAULT NULL,
317 `receiver` varchar(45) DEFAULT NULL,
318 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
319 `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
320 PRIMARY KEY (`idmessages`),
321 UNIQUE KEY `idmessages_UNIQUE` (`idmessages`)
322) ENGINE=InnoDB DEFAULT CHARSET=utf8;
323
324-- Volcando datos para la tabla rpframework.messages: ~0 rows (aproximadamente)
325/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
326/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
327
328-- Volcando estructura para tabla rpframework.racetimes
329CREATE TABLE IF NOT EXISTS `racetimes` (
330 `id` int(11) NOT NULL AUTO_INCREMENT,
331 `time` varchar(45) DEFAULT NULL,
332 `name` varchar(245) DEFAULT NULL,
333 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
334 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
335 PRIMARY KEY (`id`),
336 UNIQUE KEY `id_UNIQUE` (`id`)
337) ENGINE=InnoDB DEFAULT CHARSET=utf8;
338
339-- Volcando datos para la tabla rpframework.racetimes: ~0 rows (aproximadamente)
340/*!40000 ALTER TABLE `racetimes` DISABLE KEYS */;
341/*!40000 ALTER TABLE `racetimes` ENABLE KEYS */;
342
343-- Volcando estructura para tabla rpframework.rallyracetimes
344CREATE TABLE IF NOT EXISTS `rallyracetimes` (
345 `id` int(11) NOT NULL AUTO_INCREMENT,
346 `time` varchar(45) DEFAULT NULL,
347 `name` varchar(245) DEFAULT NULL,
348 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
349 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
350 PRIMARY KEY (`id`),
351 UNIQUE KEY `id_UNIQUE` (`id`)
352) ENGINE=InnoDB DEFAULT CHARSET=utf8;
353
354-- Volcando datos para la tabla rpframework.rallyracetimes: ~0 rows (aproximadamente)
355/*!40000 ALTER TABLE `rallyracetimes` DISABLE KEYS */;
356/*!40000 ALTER TABLE `rallyracetimes` ENABLE KEYS */;
357
358-- Volcando estructura para tabla rpframework.users
359CREATE TABLE IF NOT EXISTS `users` (
360 `bankaccount` int(11) NOT NULL AUTO_INCREMENT,
361 `uid` varchar(50) DEFAULT NULL,
362 `battleyeid` varchar(255) DEFAULT NULL,
363 `name` varchar(50) DEFAULT NULL,
364 `cash` decimal(13,2) DEFAULT NULL,
365 `bank` decimal(13,2) DEFAULT NULL,
366 `cop` int(13) DEFAULT NULL,
367 `ems` int(13) DEFAULT NULL,
368 `mafia` int(13) DEFAULT NULL,
369 `legal` int(13) DEFAULT NULL,
370 `fire` int(13) DEFAULT NULL,
371 `mobster` int(13) DEFAULT NULL,
372 `biker` int(13) DEFAULT NULL,
373 `dmv` int(13) DEFAULT NULL,
374 `doc` int(13) DEFAULT NULL,
375 `da` int(13) DEFAULT NULL,
376 `admin` int(13) DEFAULT NULL,
377 `position` varchar(50) DEFAULT NULL,
378 `items` varchar(1500) DEFAULT NULL,
379 `phoneBackground` varchar(55) DEFAULT NULL,
380 `messages` varchar(2500) DEFAULT NULL,
381 `statuses` varchar(2500) DEFAULT NULL,
382 `houselevel` int(11) DEFAULT NULL,
383 `housecontent` varchar(10000) DEFAULT NULL,
384 `shopcontent` varchar(10000) DEFAULT NULL,
385 `shopname` varchar(45) DEFAULT NULL,
386 `prison` varchar(45) DEFAULT NULL,
387 `prisonreason` varchar(500) DEFAULT NULL,
388 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
389 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
390 PRIMARY KEY (`bankaccount`),
391 UNIQUE KEY `uid` (`uid`)
392) ENGINE=InnoDB DEFAULT CHARSET=latin1;
393
394-- Volcando datos para la tabla rpframework.users: ~1 rows (aproximadamente)
395/*!40000 ALTER TABLE `users` DISABLE KEYS */;
396INSERT INTO `users` (`bankaccount`, `uid`, `battleyeid`, `name`, `cash`, `bank`, `cop`, `ems`, `mafia`, `legal`, `fire`, `mobster`, `biker`, `dmv`, `doc`, `da`, `admin`, `position`, `items`, `phoneBackground`, `messages`, `statuses`, `houselevel`, `housecontent`, `shopcontent`, `shopname`, `prison`, `prisonreason`, `created_at`, `updated_at`) VALUES
397 (2, '76561197995693059', NULL, 'florentino perez', 666835.81, 20000820.00, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, 10, '[6789.02,4636.34,0.00143814]', '[[],["CG_BAT","","","",[],[],""],[],["U_C_TeeSurfer_shorts_1",[]],["brotherhood_10",[]],[],"acj_casco_gris","",[],["ItemMap","","cg_tabletd_1","ItemCompass","tf_microdagr",""]]', '[80001,1]', '[]', '[[21,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],75,72.5,92,0,0,0,[0,0,0,0,0,0,0,0,0,0,0],[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],2,[0,0,0,0,0],["nobody",0,"no reason","NO DATE"],["76561197995693059","0"],7.1]', 1, '[[[],[]],[[],[]],[[],[]],[[],[]]]', '[[[],[],[]],[[],[],[]],[[],[],[]],[[],[],[]]]', 'florentino perez\'s Store', '0', 'none', '2017-12-25 19:33:58', '2018-03-10 22:36:48');
398/*!40000 ALTER TABLE `users` ENABLE KEYS */;
399
400-- Volcando estructura para tabla rpframework.wanted
401CREATE TABLE IF NOT EXISTS `wanted` (
402 `caseID` int(10) NOT NULL AUTO_INCREMENT,
403 `suspect` varchar(45) DEFAULT NULL,
404 `suspectGUID` varchar(45) DEFAULT NULL,
405 `officer` varchar(45) DEFAULT NULL,
406 `officerGUID` varchar(45) DEFAULT NULL,
407 `approved` varchar(45) DEFAULT NULL,
408 `approvedGUID` varchar(45) DEFAULT NULL,
409 `closed` varchar(45) DEFAULT NULL,
410 `closedGUID` varchar(45) DEFAULT NULL,
411 `charges` varchar(3000) DEFAULT NULL,
412 `status` varchar(45) DEFAULT NULL,
413 `evidence` varchar(45) DEFAULT NULL,
414 `active` varchar(45) DEFAULT NULL,
415 `jailtime` varchar(45) DEFAULT NULL,
416 `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
417 `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
418 PRIMARY KEY (`caseID`),
419 UNIQUE KEY `caseID_UNIQUE` (`caseID`)
420) ENGINE=InnoDB DEFAULT CHARSET=utf8;
421
422-- Volcando datos para la tabla rpframework.wanted: ~3 rows (aproximadamente)
423/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
424INSERT INTO `wanted` (`caseID`, `suspect`, `suspectGUID`, `officer`, `officerGUID`, `approved`, `approvedGUID`, `closed`, `closedGUID`, `charges`, `status`, `evidence`, `active`, `jailtime`, `created_at`, `updated_at`) VALUES
425 (1, 'florentino perez', '76561197995693059', 'Silver Lake', '0', '', '', 'florentino perez', '76561197995693059', '1x Speeding, 3rd degree.', '2', '1', '0', '250', '2017-12-25 20:00:50', '2018-01-27 06:59:03'),
426 (2, 'florentino perez', '76561197995693059', 'Silver Lake', '0', '', '', 'florentino perez', '76561197995693059', '1x Speeding, 2nd degree.', '2', '1', '0', '500', '2017-12-25 20:02:38', '2018-01-27 06:59:00'),
427 (3, 'florentino perez', '76561197995693059', 'Silver Lake', '0', '', '', 'florentino perez', '76561197995693059', '1x Speeding, 1st degree.', '2', '1', '0', '750', '2018-01-27 06:57:32', '2018-01-27 06:58:56');
428/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
429
430/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
431/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
432/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;