· 4 years ago · Mar 30, 2021, 06:32 PM
1CREATE DATABASE IF NOT EXISTS `gtav_rp2` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
2USE `gtav_rp2`;
3
4
5
6
7CREATE TABLE IF NOT EXISTS `fine_types` (
8 `id` int(150) NOT NULL AUTO_INCREMENT,
9 `label` varchar(255) DEFAULT NULL,
10 `amount` int(11) DEFAULT NULL,
11 `jailtime` int(11) DEFAULT 0,
12 `category` int(11) DEFAULT NULL,
13 PRIMARY KEY (`id`)
14) ENGINE=InnoDB AUTO_INCREMENT=132 DEFAULT CHARSET=utf8mb4;
15
16
17INSERT INTO `fine_types` (`id`, `label`, `amount`, `jailtime`, `category`) VALUES
18 (1, 'Speeding 1st Degree (0-15)', 200, 0, 1),
19 (2, 'Speeding 2nd Degree (15-30', 750, 1, 1),
20 (3, 'Speeding 3rd Degree (30+)', 2000, 2, 1),
21 (4, 'Illegal Parking', 500, 0, 1),
22 (5, 'Illegal U Turn', 100, 0, 1),
23 (6, 'Failure To Maintain Lane', 300, 0, 1),
24 (7, 'Failure To Yield To Emergency Vehicles', 3000, 0, 1),
25 (8, 'Failure To Yield to a TCD', 500, 0, 1),
26 (9, 'Following an Emergency Vehicle', 1000, 0, 1),
27 (10, 'Operating a Vehicle Without A License On Your Person', 500, 0, 1),
28 (11, 'Blocking Intersection', 500, 0, 1),
29 (12, 'Unroadworthy Vehicle', 500, 0, 1),
30 (13, 'Loitering', 750, 1, 1),
31 (14, 'Jaywalking', 250, 1, 1),
32 (15, 'Animal Cruelty', 500, 25, 1),
33 (16, 'Open Intox', 750, 3, 1),
34 (17, 'Blocking Intersection', 600, 0, 1),
35 (18, 'Operating a Vehicle without a Valid License', 1000, 2, 4),
36 (19, 'Operating a Vehicle with a Suspended License', 1500, 2, 4),
37 (20, 'Reckless Operation of a Road or Marine Vehicle', 2000, 3, 4),
38 (21, 'Impeding Traffic', 500, 2, 4),
39 (22, 'Drunk, Impaired, or Distracted Driving', 500, 4, 4),
40 (23, 'Street Competition', 2000, 6, 4),
41 (24, 'Joyriding', 2500, 6, 4),
42 (26, 'Felony Hit and Run', 4000, 3, 4),
43 (27, 'Operating a Chop Shop', 2000, 2, 4),
44 (28, 'Felony Public Endangerment', 2000, 4, 4),
45 (29, 'Vehicular Manslaughter', 5000, 5, 4),
46 (30, 'Reckless Operation of an Aircraft', 10000, 5, 4),
47 (31, 'Assault', 500, 3, 2),
48 (32, 'Battery', 500, 3, 2),
49 (33, 'Possession of a Blade', 750, 2, 2),
50 (34, 'Resisting Arrest', 1000, 3, 2),
51 (35, 'Receiving Stolen Property', 500, 3, 2),
52 (36, 'Petty Theft', 1000, 3, 2),
53 (37, 'Possession of a Fake Operator License or ID Card', 750, 2, 2),
54 (38, 'Identity Theft', 1000, 3, 2),
55 (39, 'Vandalism', 750, 3, 2),
56 (40, 'Vigilantism', 259, 3, 2),
57 (41, 'Failure to Comply / Identify', 750, 2, 2),
58 (42, 'Predatory Lending', 2000, 2, 2),
59 (43, 'Giving False Information to a Police Officer', 500, 2, 2),
60 (44, 'Criminal Threats', 500, 3, 2),
61 (45, 'Obstruction of Justice', 500, 3, 2),
62 (46, 'Animal Abuse', 1000, 3, 2),
63 (47, 'Failure to Pay a Fine', 1000, 3, 2),
64 (48, 'Bribery', 1000, 3, 2),
65 (49, 'Reckless Driving', 2000, 3, 2),
66 (50, 'Inciting a Riot', 1000, 240, 3),
67 (51, 'Participating in a Riot', 500, 2, 3),
68 (52, 'Unlawful Assembly', 500, 3, 3),
69 (53, 'Disturbing The Peace', 500, 3, 3),
70 (54, 'Indecent Exposure', 1500, 2, 3),
71 (55, 'Stalking', 750, 3, 3),
72 (56, 'Public Intoxication', 750, 2, 3),
73 (57, 'Trespassing', 750, 3, 3),
74 (58, 'Prostitution', 1000, 2, 3),
75 (59, 'Loitering with Intent to Commit Prostitution', 750, 2, 3),
76 (60, 'Misuse of Government Public Safety Radio Frequencies or Hotlines', 1000, 4, 3),
77 (61, 'Controlled Substance Possession', 500, 2, 6),
78 (62, 'Possession of a Controlled Substance While Armed', 750, 3, 6),
79 (63, 'Illegal Drug Possession with Intent of Sales', 1000, 4, 6),
80 (64, 'Sale of Illegal Drugs', 1500, 5, 6),
81 (65, 'Manufacturing Narcotics', 3000, 5, 6),
82 (66, 'Drug Trafficking', 2500, 6, 6),
83 (67, 'Brandishing a Firearm or Weapon', 1000, 3, 7),
84 (68, 'Carrying an Unlicensed Firearm or Weapon', 500, 1, 7),
85 (69, 'Possession of Weapon Modifications', 1000, 1, 7),
86 (70, 'Possession of Body Armor As A Felon', 500, 1, 7),
87 (71, 'Possession of a Firearm while Intoxicated', 1500, 2, 7),
88 (72, 'Assault with a Deadly Weapon', 6000, 5, 7),
89 (73, 'Shooting from a Vehicle (Drive-By)', 3000, 9, 7),
90 (74, 'Possession of Illegal Firearms/Weapons', 3000, 5, 7),
91 (75, 'Illegal Sale of an Unlicensed Firearm / Ammunation', 5000, 5, 7),
92 (76, 'Sale of Illegal Firearms / Ammunation', 7500, 5, 7),
93 (77, 'Firearms Trafficking', 7500, 5, 7),
94 (78, 'Robbery', 1000, 5, 5),
95 (79, 'Armed Robbery', 2000, 5, 5),
96 (80, 'Criminal Sexual Contact', 1000, 5, 5),
97 (81, 'Extortion', 1000, 5, 5),
98 (82, 'Blackmail', 750, 4, 5),
99 (83, 'Fraud', 1000, 5, 5),
100 (84, 'Embezzlement', 3000, 5, 5),
101 (85, 'Grand Theft', 4000, 5, 5),
102 (86, 'Grand Theft Auto', 5000, 5, 5),
103 (87, 'Forgery or Counterfeiting', 500, 3, 5),
104 (88, 'Arson', 500, 2, 5),
105 (89, 'False Impersonation', 1000, 5, 5),
106 (90, 'False Impersonation of a Police Officer or Government Worker', 1000, 5, 5),
107 (91, 'Burglary / Property Damage', 1000, 5, 5),
108 (92, 'Tampering with Evidence', 2000, 5, 5),
109 (93, 'Driving Under Infulence', 2000, 5, 5),
110 (94, 'Unlawful Detention', 2000, 5, 5),
111 (95, 'Felony Evading', 3000, 5, 4),
112 (96, 'Domestic Terrorism', 15000, 20, 8),
113 (97, 'Attempted Murder', 3000, 5, 8),
114 (98, 'Murder', 7000, 10, 8),
115 (99, 'Involuntary Manslaughter', 5000, 4, 8),
116 (100, 'Kidnapping', 10000, 8, 8),
117 (101, 'Torture', 10000, 20, 8),
118 (102, 'Possessing Destructive Devices or Explosives', 10000, 9, 8),
119 (103, 'Bank Robbery', 8000, 20, 8),
120 (105, 'Aggravated Battery', 300, 3, 4),
121 (107, 'Trespassing within a Restricted Facility', 1000, 3, 3),
122 (108, 'Pimping', 600, 4, 4),
123 (109, 'Dissuading A Victim', 1000, 5, 4),
124 (110, 'Filing A False Police Report', 1500, 6, 2),
125 (113, 'Impersonation of a Lawyer', 500, 2, 4),
126 (115, 'Maintaining A Place For The Purpose Of Distribution', 1500, 5, 4),
127 (117, 'Aggravated Driving Under The Influence', 4000, 7, 4),
128 (118, 'Illegal Left Turn', 200, 0, 1),
129 (119, 'Weapons Discharge Violation', 1000, 3, 4),
130 (121, 'Accessory After the Fact', 500, 2, 2),
131 (123, 'Interference with a Transit System', 1000, 3, 3),
132 (124, 'Desecration of a Human Corpse', 1500, 5, 5),
133 (125, 'Possession Of Burglary Tools', 1500, 2, 3),
134 (127, 'Possession Of Firearm As A Felon ', 2500, 6, 5),
135 (126, 'Excessive Use Of A Horn', 250, 0, 5),
136 (128, 'Harrasment With A Electronic Device', 1000, 2, 5),
137 (129, 'Perjury', 7000, 15, 2),
138 (130, 'Tailgating', 200, 0, 2),
139 (131, 'Possession of endangered species', 2000, 5, 5),
140 (132, 'Hunting / Fishing without a license ', 600, 1, 5);
141