· 8 years ago · Aug 07, 2018, 10:54 AM
1-- --------------------------------------------------------
2-- Host: localhost
3-- Server version: 10.1.34-MariaDB - mariadb.org binary distribution
4-- Server OS: Win32
5-- HeidiSQL Version: 9.5.0.5284
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 life
16CREATE DATABASE IF NOT EXISTS `life` /*!40100 DEFAULT CHARACTER SET latin1 */;
17USE `life`;
18
19-- Dumping structure for table life.adminlogs
20CREATE TABLE IF NOT EXISTS `adminlogs` (
21 `ID` int(255) NOT NULL AUTO_INCREMENT,
22 `adminname` varchar(50) NOT NULL,
23 `uid` varchar(50) NOT NULL,
24 `type` enum('cursortarget','mapmarkers','spectate','factories','globalmessage','mapteleporting','players','objects','vehicles','debug','menu') NOT NULL,
25 `data` text NOT NULL,
26 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
27 PRIMARY KEY (`ID`) USING BTREE
28) ENGINE=InnoDB AUTO_INCREMENT=22790 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
29
30-- Dumping data for table life.adminlogs: ~0 rows (approximately)
31/*!40000 ALTER TABLE `adminlogs` DISABLE KEYS */;
32INSERT INTO `adminlogs` (`ID`, `adminname`, `uid`, `type`, `data`, `time`) VALUES
33 (22701, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:04:15'),
34 (22702, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:04:23'),
35 (22703, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:04:28'),
36 (22704, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:04:31'),
37 (22705, 'Eli Rees (yetif)', '76561198119367976', 'vehicles', 'A3PL_F150_Marker_PD AT [2557.09,5649.36,0.0014472]', '2018-08-07 06:04:43'),
38 (22706, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:04:58'),
39 (22707, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:02'),
40 (22708, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:06'),
41 (22709, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Opened Debug', '2018-08-07 06:05:09'),
42 (22710, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:09'),
43 (22711, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:15'),
44 (22712, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:19'),
45 (22713, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:24'),
46 (22714, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:05:27'),
47 (22715, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:05:28'),
48 (22716, 'Eli Rees (yetif)', '76561198119367976', 'vehicles', 'A3PL_Tahoe_PD AT [2557.33,5659.52,0.0014596]', '2018-08-07 06:05:36'),
49 (22717, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:06:22'),
50 (22718, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:06:25'),
51 (22719, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:06:43'),
52 (22720, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Opened Debug', '2018-08-07 06:06:45'),
53 (22721, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:09:42'),
54 (22722, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Opened Debug', '2018-08-07 06:09:46'),
55 (22723, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Excecuted Code In Debug - Code = (skipTime 10;)', '2018-08-07 06:09:51'),
56 (22724, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Excecuted Code In Debug - Code = (skipTime 10;)', '2018-08-07 06:09:55'),
57 (22725, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:10:39'),
58 (22726, 'Eli Rees (yetif)', '76561198119367976', '', 'Toggled Admin Mode On', '2018-08-07 06:10:42'),
59 (22727, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:10:43'),
60 (22728, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Global Message Menu', '2018-08-07 06:10:45'),
61 (22729, 'Eli Rees (yetif)', '76561198119367976', 'globalmessage', 'yall are ugly', '2018-08-07 06:10:55'),
62 (22730, 'Eli Rees (yetif)', '76561198119367976', 'globalmessage', 'yall are ugly', '2018-08-07 06:10:57'),
63 (22731, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:10:59'),
64 (22732, 'Eli Rees (yetif)', '76561198119367976', 'factories', 'Searched for ', '2018-08-07 06:11:09'),
65 (22733, 'Eli Rees (yetif)', '76561198119367976', 'factories', 'Searched for ', '2018-08-07 06:11:11'),
66 (22734, 'Eli Rees (yetif)', '76561198119367976', 'factories', 'Added 1 Synthetic_Fibre(s) ADDED TO Eli Rees(76561198119367976) (Chemical Plant)', '2018-08-07 06:11:14'),
67 (22735, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:12:44'),
68 (22736, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:12:49'),
69 (22737, 'Eli Rees (yetif)', '76561198119367976', 'mapteleporting', 'FROM [2596.83,5432.6,0.715881] TO [3871.77,6883.62,0]', '2018-08-07 06:12:49'),
70 (22738, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:12:57'),
71 (22739, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:01'),
72 (22740, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Start Cursortargeting', '2018-08-07 06:13:04'),
73 (22741, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Finish Cursortargeting', '2018-08-07 06:13:08'),
74 (22742, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:09'),
75 (22743, 'Eli Rees (yetif)', '76561198119367976', 'mapmarkers', 'true', '2018-08-07 06:13:13'),
76 (22744, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:24'),
77 (22745, 'Eli Rees (yetif)', '76561198119367976', 'mapmarkers', 'false', '2018-08-07 06:13:27'),
78 (22746, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:28'),
79 (22747, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:39'),
80 (22748, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:42'),
81 (22749, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:13:52'),
82 (22750, 'Eli Rees (yetif)', '76561198119367976', 'spectate', 'ENABLED', '2018-08-07 06:13:57'),
83 (22751, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:14:06'),
84 (22752, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:14:22'),
85 (22753, 'Eli Rees (yetif)', '76561198119367976', '', 'Toggled Admin Mode Off', '2018-08-07 06:14:24'),
86 (22754, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:14:25'),
87 (22755, 'Eli Rees (yetif)', '76561198119367976', '', 'Toggled Admin Mode On', '2018-08-07 06:14:27'),
88 (22756, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:14:33'),
89 (22757, 'Eli Rees (yetif)', '76561198119367976', '', 'Toggled Admin Mode Off', '2018-08-07 06:14:34'),
90 (22758, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:15:03'),
91 (22759, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:19:55'),
92 (22760, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:19:56'),
93 (22761, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Start Cursortargeting', '2018-08-07 06:20:07'),
94 (22762, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Finish Cursortargeting', '2018-08-07 06:20:15'),
95 (22763, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:20:17'),
96 (22764, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:20:19'),
97 (22765, 'Eli Rees (yetif)', '76561198119367976', 'vehicles', 'A3PL_Boat_Trailer AT [2821.22,5572.61,0.00143909]', '2018-08-07 06:20:31'),
98 (22766, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:20:38'),
99 (22767, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:20:42'),
100 (22768, 'Eli Rees (yetif)', '76561198119367976', 'vehicles', 'A3PL_P362 AT [2828.85,5578.71,0.00143909]', '2018-08-07 06:20:52'),
101 (22769, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:29:30'),
102 (22770, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:29:44'),
103 (22771, 'Eli Rees (yetif)', '76561198119367976', 'mapteleporting', 'FROM [2818.21,5578.07,0.00143814] TO [3441.93,7500.6,0]', '2018-08-07 06:29:44'),
104 (22772, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:30:50'),
105 (22773, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:30:56'),
106 (22774, 'Eli Rees (yetif)', '76561198119367976', 'mapteleporting', 'FROM [3469.83,7496.43,0.00143886] TO [2569.33,5660.6,0]', '2018-08-07 06:30:56'),
107 (22775, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:31:06'),
108 (22776, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Start Cursortargeting', '2018-08-07 06:31:09'),
109 (22777, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Finish Cursortargeting', '2018-08-07 06:31:17'),
110 (22778, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:32:12'),
111 (22779, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Vehicle Menu', '2018-08-07 06:32:14'),
112 (22780, 'Eli Rees (yetif)', '76561198119367976', 'vehicles', 'A3PL_911GT2 AT [2568.25,5649.05,0.00146437]', '2018-08-07 06:32:18'),
113 (22781, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:34:30'),
114 (22782, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Start Cursortargeting', '2018-08-07 06:34:34'),
115 (22783, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Finish Cursortargeting', '2018-08-07 06:34:41'),
116 (22784, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:35:12'),
117 (22785, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Opened Debug', '2018-08-07 06:35:20'),
118 (22786, 'Eli Rees (yetif)', '76561198119367976', 'debug', 'Excecuted Code In Debug - Code = (setHealth 100;)', '2018-08-07 06:35:32'),
119 (22787, 'Eli Rees (yetif)', '76561198119367976', 'menu', 'Opened Menu', '2018-08-07 06:36:02'),
120 (22788, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Start Cursortargeting', '2018-08-07 06:36:06'),
121 (22789, 'Eli Rees (yetif)', '76561198119367976', 'cursortarget', 'Finish Cursortargeting', '2018-08-07 06:36:12');
122/*!40000 ALTER TABLE `adminlogs` ENABLE KEYS */;
123
124-- Dumping structure for table life.chatlog
125CREATE TABLE IF NOT EXISTS `chatlog` (
126 `name` tinytext,
127 `steamid` tinytext,
128 `chatmessage` tinytext,
129 `messageinfo` varchar(500) DEFAULT '[``,`#ed7202`,`#B5B5B5`]',
130 `date` timestamp NULL DEFAULT CURRENT_TIMESTAMP
131) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
132
133-- Dumping data for table life.chatlog: ~2 rows (approximately)
134/*!40000 ALTER TABLE `chatlog` DISABLE KEYS */;
135INSERT INTO `chatlog` (`name`, `steamid`, `chatmessage`, `messageinfo`, `date`) VALUES
136 ('[AD] Eli Rees', '76561198119367976', 'Test [9367976]', '[`\\A3PL_Common\\icons\\citizen.paa`,`#00bfbf`,`#4cffff`]', '2018-08-07 04:13:56'),
137 ('Eli Rees', '76561198119367976', 'y', '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`]', '2018-08-07 04:50:28'),
138 ('Eli Rees', '76561198119367976', 'ye', '[`\\A3PL_Common\\icons\\police.paa`,`#556B2F`,`#B5B5B5`]', '2018-08-07 06:34:09');
139/*!40000 ALTER TABLE `chatlog` ENABLE KEYS */;
140
141-- Dumping structure for table life.factions
142CREATE TABLE IF NOT EXISTS `factions` (
143 `id` int(6) NOT NULL AUTO_INCREMENT,
144 `leader` varchar(17) NOT NULL,
145 `type` varchar(50) NOT NULL,
146 `max_rank` int(11) NOT NULL DEFAULT '1',
147 PRIMARY KEY (`id`)
148) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
149
150-- Dumping data for table life.factions: ~6 rows (approximately)
151/*!40000 ALTER TABLE `factions` DISABLE KEYS */;
152INSERT INTO `factions` (`id`, `leader`, `type`, `max_rank`) VALUES
153 (1, '230', 'POLICE', 8),
154 (2, '38', 'USCG', 14),
155 (3, '162', 'FIFR', 11),
156 (4, '133', 'DOJ', 6),
157 (5, '40', 'DMV', 3),
158 (6, '1', 'FAA', 1);
159/*!40000 ALTER TABLE `factions` ENABLE KEYS */;
160
161-- Dumping structure for table life.faction_ranks
162CREATE TABLE IF NOT EXISTS `faction_ranks` (
163 `id` int(6) NOT NULL AUTO_INCREMENT,
164 `fid` int(6) NOT NULL,
165 `name` varchar(50) NOT NULL,
166 `level` int(11) NOT NULL DEFAULT '1',
167 `paycheck` int(100) NOT NULL DEFAULT '1000',
168 `cap` int(100) NOT NULL DEFAULT '1000',
169 PRIMARY KEY (`id`)
170) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
171
172-- Dumping data for table life.faction_ranks: ~42 rows (approximately)
173/*!40000 ALTER TABLE `faction_ranks` DISABLE KEYS */;
174INSERT INTO `faction_ranks` (`id`, `fid`, `name`, `level`, `paycheck`, `cap`) VALUES
175 (1, 2, 'Seaman Recruit', 1, 1000, 4000),
176 (2, 2, 'Seaman Apprentice', 2, 1000, 5000),
177 (3, 2, 'Seaman', 3, 1000, 6000),
178 (4, 2, 'Petty Officer', 4, 1000, 7000),
179 (5, 2, 'Chief Petty Officer', 5, 1000, 8000),
180 (6, 2, 'Senior Chief Petty Officer', 6, 1000, 9000),
181 (7, 2, 'Master Chief Petty Officer', 7, 1000, 10000),
182 (8, 2, 'Command Master Chief Petty Officer', 8, 1000, 11000),
183 (9, 2, 'Ensign', 9, 1000, 12000),
184 (10, 2, 'Lieutenant, Junior Grade', 10, 1000, 13000),
185 (11, 2, 'Lieutenant', 11, 1000, 14000),
186 (12, 2, 'Lieutenant Commander ', 12, 1000, 15000),
187 (13, 2, 'Commander', 13, 1000, 16000),
188 (14, 2, 'Captain', 14, 1000, 17000),
189 (15, 1, 'Cadet', 1, 500, 4000),
190 (16, 1, 'Deputy', 2, 1000, 5500),
191 (17, 1, 'Corporal', 3, 1500, 6500),
192 (18, 1, 'Sergeant', 4, 2000, 7500),
193 (19, 1, 'Detective', 5, 2500, 8500),
194 (20, 1, 'Lieutenant', 6, 3000, 9500),
195 (21, 1, 'UnderSheriff', 7, 3500, 13250),
196 (22, 1, 'Sheriff', 8, 4000, 17000),
197 (23, 3, 'Chief', 11, 1000, 17000),
198 (24, 3, 'Deputy Chief', 10, 1000, 14250),
199 (25, 3, 'Battalion Chief', 9, 1000, 11500),
200 (26, 3, 'Captin', 8, 1000, 10500),
201 (27, 3, 'Lieutenant', 7, 1000, 9500),
202 (28, 3, 'Engineer / Paramedic', 6, 1000, 8500),
203 (29, 3, 'Firefighter / Paramedic', 5, 1000, 7500),
204 (30, 3, 'Firefighter / EMT', 4, 1000, 6500),
205 (31, 3, 'Probationary', 3, 1000, 5500),
206 (32, 3, 'Recruit', 2, 1000, 4000),
207 (33, 3, 'Volunteer', 1, 1000, 2000),
208 (34, 4, 'Chief Justice', 6, 1000, 17000),
209 (35, 4, 'Assistant Chief Justice', 5, 1000, 13500),
210 (36, 4, 'Executive Judge', 4, 1000, 10000),
211 (37, 4, 'District Attorney', 3, 1000, 8000),
212 (38, 4, 'State Prosecutor', 2, 1000, 6000),
213 (39, 4, 'Lawyer', 1, 1000, 4000),
214 (40, 5, 'Manager', 3, 74500, 17000),
215 (41, 5, 'Assistant Manager', 2, 44500, 10500),
216 (42, 5, 'Employee', 1, 14500, 4000);
217/*!40000 ALTER TABLE `faction_ranks` ENABLE KEYS */;
218
219-- Dumping structure for table life.faction_vehicle_shop
220CREATE TABLE IF NOT EXISTS `faction_vehicle_shop` (
221 `id` int(11) NOT NULL AUTO_INCREMENT,
222 `var` varchar(50) NOT NULL,
223 `type` enum('fifr','police','uscg','uscg_h','uscg_b','dmv','faa','doj') NOT NULL,
224 `stock` varchar(50) NOT NULL,
225 PRIMARY KEY (`id`)
226) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
227
228-- Dumping data for table life.faction_vehicle_shop: ~8 rows (approximately)
229/*!40000 ALTER TABLE `faction_vehicle_shop` DISABLE KEYS */;
230INSERT INTO `faction_vehicle_shop` (`id`, `var`, `type`, `stock`) VALUES
231 (1, 'FIFR_VEHICLE_STOCK', 'fifr', '[0,0,0,0,0,0,0,0]'),
232 (2, 'USCG_VEHICLE_STOCK', 'uscg', '[30,30,30,30,30,30,30]'),
233 (3, 'POLICE_VEHICLE_STOCK', 'police', '[30,29,30,30,30,30,30,30,30,30]'),
234 (4, 'USCG_BOAT_STOCK', 'uscg', '[30,30,30,29,30,30]'),
235 (5, 'USCG_HELI_STOCK', 'uscg', '[30,30,30,29,30,30]'),
236 (6, 'DMV_VEHICLE_STOCK', 'dmv', '[30,30,30,30,30]'),
237 (7, 'FAA_VEHICLE_STOCK', 'faa', '[30,30,30,30,30]'),
238 (8, 'DOJ_VEHICLE_STOCK', 'doj', '[30,30]');
239/*!40000 ALTER TABLE `faction_vehicle_shop` ENABLE KEYS */;
240
241-- Dumping structure for table life.government_balances
242CREATE TABLE IF NOT EXISTS `government_balances` (
243 `id` int(11) NOT NULL AUTO_INCREMENT,
244 `var` varchar(50) DEFAULT NULL,
245 `balance` bigint(20) DEFAULT '0',
246 PRIMARY KEY (`id`)
247) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COMMENT='Contains balances for government fund and the current tax rates';
248
249-- Dumping data for table life.government_balances: ~0 rows (approximately)
250/*!40000 ALTER TABLE `government_balances` DISABLE KEYS */;
251INSERT INTO `government_balances` (`id`, `var`, `balance`) VALUES
252 (1, 'FEDERAL_GRANT', 400000000),
253 (2, 'PD_BUDGET', 399980000),
254 (3, 'FD_BUDGET', 399930016),
255 (4, 'CG_BUDGET', 399983008),
256 (5, 'SALES_TAX_BAL', 20402),
257 (6, 'INCOME_TAX_BAL', 26135),
258 (7, 'PROPERTY_TAX_BAL', 65000),
259 (8, 'IMPORT_TAX_BAL', 15487),
260 (9, 'INCOME_TAX', 5),
261 (10, 'PROPERTY_TAX', 10),
262 (11, 'SALES_TAX', 5),
263 (12, 'IMPORT_TAX', 5),
264 (13, 'DMV_BUDGET', 400000000),
265 (14, 'DOJ_BUDGET', 400000000),
266 (15, 'FAA_BUDGET', 400000000);
267/*!40000 ALTER TABLE `government_balances` ENABLE KEYS */;
268
269-- Dumping structure for table life.government_laws
270CREATE TABLE IF NOT EXISTS `government_laws` (
271 `id` int(11) NOT NULL AUTO_INCREMENT,
272 `law` text NOT NULL,
273 `added` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
274 PRIMARY KEY (`id`)
275) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
276
277-- Dumping data for table life.government_laws: ~0 rows (approximately)
278/*!40000 ALTER TABLE `government_laws` DISABLE KEYS */;
279INSERT INTO `government_laws` (`id`, `law`, `added`) VALUES
280 (5, 'Speed Laws City Limits 25km per hour Outer City 60 km per hour Backroads 30 km per hour Suburbs 20 km per hour.', '2018-06-24 23:49:47'),
281 (6, 'Everyone must have a DMV issued driving license', '2018-06-25 22:10:26'),
282 (7, 'Everyone must provide licences when requested by DMV', '2018-07-08 15:39:52');
283/*!40000 ALTER TABLE `government_laws` ENABLE KEYS */;
284
285-- Dumping structure for table life.houses
286CREATE TABLE IF NOT EXISTS `houses` (
287 `uid` varchar(50) DEFAULT NULL,
288 `location` varchar(50) DEFAULT NULL,
289 `doorid` varchar(50) DEFAULT NULL,
290 `items` varchar(7000) DEFAULT '[[],[],[]]',
291 `vitems` varchar(7000) DEFAULT '[]',
292 `pitems` varchar(7000) DEFAULT '[]',
293 UNIQUE KEY `location` (`location`) USING BTREE
294) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
295
296-- Dumping data for table life.houses: ~0 rows (approximately)
297/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
298/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
299
300-- Dumping structure for table life.import_export
301CREATE TABLE IF NOT EXISTS `import_export` (
302 `item` varchar(50) DEFAULT NULL,
303 `import` int(25) DEFAULT NULL,
304 `export` int(25) DEFAULT NULL
305) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
306
307-- Dumping data for table life.import_export: ~0 rows (approximately)
308/*!40000 ALTER TABLE `import_export` DISABLE KEYS */;
309INSERT INTO `import_export` (`item`, `import`, `export`) VALUES
310 ('Crude_Oil', 2925, 488),
311 ('Gunpowder', 544, 91),
312 ('Glass_Fibre', 8, 4),
313 ('Fibreglass', 270, 45),
314 ('Plastic', 214, 36),
315 ('Glass', 135, 23),
316 ('Polyester', 81, 14),
317 ('Aramid', 177, 30),
318 ('Iron_Ingot_Pellet', 115425, 19237),
319 ('Coal_Ingot_Pellet', 115425, 19237),
320 ('Aluminium_Ingot_Pellet', 2308500, 384750),
321 ('Titanium_Ingot_Pellet', 4809375, 801562),
322 ('Steel_Pellet', 3510, 585),
323 ('Aluminium_Pellet', 6583, 1097),
324 ('Titanium_Pellet', 9560, 1593),
325 ('Rubber', 461, 77),
326 ('Petrol', 993, 165),
327 ('LPG', 604, 100),
328 ('Kerosene', 14718, 2453),
329 ('CanisterOil', 165, 27),
330 ('Synthetic_Fibre', 74, 12),
331 ('Crude_Oil', 2925, 488),
332 ('Gunpowder', 544, 91),
333 ('Glass_Fibre', 8, 4),
334 ('Fibreglass', 270, 45),
335 ('Plastic', 214, 36),
336 ('Glass', 135, 23),
337 ('Polyester', 81, 14),
338 ('Aramid', 177, 30),
339 ('Iron_Ingot_Pellet', 115425, 19237),
340 ('Coal_Ingot_Pellet', 115425, 19237),
341 ('Aluminium_Ingot_Pellet', 2308500, 384750),
342 ('Titanium_Ingot_Pellet', 4809375, 801562),
343 ('Steel_Pellet', 3510, 585),
344 ('Aluminium_Pellet', 6583, 1097),
345 ('Titanium_Pellet', 9560, 1593),
346 ('Rubber', 461, 77),
347 ('Petrol', 993, 165),
348 ('LPG', 604, 100),
349 ('Kerosene', 14718, 2453),
350 ('CanisterOil', 165, 27),
351 ('Synthetic_Fibre', 74, 12);
352/*!40000 ALTER TABLE `import_export` ENABLE KEYS */;
353
354-- Dumping structure for table life.logs
355CREATE TABLE IF NOT EXISTS `logs` (
356 `ID` int(255) NOT NULL AUTO_INCREMENT,
357 `uid` varchar(50) NOT NULL,
358 `type` varchar(50) NOT NULL,
359 `data` text NOT NULL,
360 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
361 PRIMARY KEY (`ID`) USING BTREE
362) ENGINE=InnoDB AUTO_INCREMENT=35816 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
363
364-- Dumping data for table life.logs: ~0 rows (approximately)
365/*!40000 ALTER TABLE `logs` DISABLE KEYS */;
366INSERT INTO `logs` (`ID`, `uid`, `type`, `data`, `time`) VALUES
367 (35809, '76561198119367976', 'Admin', 'GlobalMessage-yall are ugly', '2018-08-07 06:10:55'),
368 (35810, '76561198119367976', 'Admin', 'GlobalMessage-yall are ugly', '2018-08-07 06:10:57'),
369 (35811, '76561198119367976', 'DropItem', 'stinger-1', '2018-08-07 06:14:52'),
370 (35812, '76561198119367976', 'PickupItem', 'stinger-1', '2018-08-07 06:14:58'),
371 (35813, '76561198119367976', 'DropItem', 'stinger-1', '2018-08-07 06:15:24'),
372 (35814, '76561198119367976', 'PickupItem', 'stinger-1', '2018-08-07 06:15:31'),
373 (35815, '76561198119367976', 'DropItem', 'stinger-1', '2018-08-07 06:15:49');
374/*!40000 ALTER TABLE `logs` ENABLE KEYS */;
375
376-- Dumping structure for table life.objects
377CREATE TABLE IF NOT EXISTS `objects` (
378 `aiid` int(11) NOT NULL AUTO_INCREMENT,
379 `id` varchar(50) NOT NULL,
380 `type` varchar(50) NOT NULL DEFAULT 'object',
381 `class` varchar(50) NOT NULL,
382 `uid` varchar(50) NOT NULL,
383 `plystorage` tinyint(1) NOT NULL DEFAULT '0',
384 `spawn` tinyint(1) NOT NULL DEFAULT '0',
385 `pos` varchar(50) NOT NULL DEFAULT '[]',
386 `vars` varchar(50) NOT NULL DEFAULT '[]',
387 `impounded` tinyint(1) NOT NULL DEFAULT '0',
388 `fuel` float NOT NULL DEFAULT '1',
389 `color` varchar(300) NOT NULL DEFAULT '#(argb,8,8,3)color(1,1,1,1.0,co)',
390 PRIMARY KEY (`aiid`),
391 UNIQUE KEY `id` (`id`) USING BTREE
392) ENGINE=InnoDB AUTO_INCREMENT=750 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
393
394-- Dumping data for table life.objects: ~1 rows (approximately)
395/*!40000 ALTER TABLE `objects` DISABLE KEYS */;
396INSERT INTO `objects` (`aiid`, `id`, `type`, `class`, `uid`, `plystorage`, `spawn`, `pos`, `vars`, `impounded`, `fuel`, `color`) VALUES
397 (749, 'gmidabi', 'vehicle', 'A3PL_CVPI_Rusty', '76561198119367976', 0, 0, '[]', '[]', 0, 0.995308, '#(argb,8,8,3)color(1,1,1,1.0,co)');
398/*!40000 ALTER TABLE `objects` ENABLE KEYS */;
399
400-- Dumping structure for table life.persistent_vars
401CREATE TABLE IF NOT EXISTS `persistent_vars` (
402 `var` varchar(50) DEFAULT NULL,
403 `value` varchar(5000) DEFAULT '[]',
404 `pv` tinyint(1) DEFAULT '0',
405 UNIQUE KEY `var` (`var`) USING BTREE
406) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
407
408-- Dumping data for table life.persistent_vars: ~0 rows (approximately)
409/*!40000 ALTER TABLE `persistent_vars` DISABLE KEYS */;
410/*!40000 ALTER TABLE `persistent_vars` ENABLE KEYS */;
411
412-- Dumping structure for table life.players
413CREATE TABLE IF NOT EXISTS `players` (
414 `ID` int(10) NOT NULL AUTO_INCREMENT,
415 `uid` varchar(50) DEFAULT NULL,
416 `name` varchar(50) DEFAULT '',
417 `job` varchar(50) DEFAULT 'unemployed',
418 `gender` varchar(50) DEFAULT 'male',
419 `dob` varchar(50) DEFAULT '1/1/1990',
420 `pasportdate` varchar(50) DEFAULT NULL,
421 `lastseen` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
422 `cash` int(11) DEFAULT '0',
423 `bank` int(11) DEFAULT '500',
424 `faction` varchar(50) DEFAULT 'citizen',
425 `faction_rank` int(11) NOT NULL DEFAULT '0',
426 `position` varchar(50) DEFAULT '[2786.83,5387.44,0.00146484]',
427 `userkey` varchar(500) DEFAULT '[]',
428 `licenses` varchar(75) DEFAULT '[]',
429 `loadout` varchar(3000) DEFAULT '[]',
430 `virtualinv` varchar(2000) DEFAULT '[]',
431 `player_fstorage` varchar(5000) DEFAULT '[]',
432 `jail` int(20) unsigned DEFAULT '0',
433 `adminpowers` varchar(750) DEFAULT '[]',
434 `stafftitle` varchar(50) NOT NULL,
435 `twitterprofile` varchar(500) NOT NULL DEFAULT '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`,[[`\\A3PL_Common\\icons\\citizen.paa`,`Citizen Tag`]],[[`#ed7202`,`Citizen`]],[[`#B5B5B5`,`Default`]]]',
436 PRIMARY KEY (`ID`) USING BTREE,
437 UNIQUE KEY `uid` (`uid`) USING BTREE
438) ENGINE=InnoDB AUTO_INCREMENT=231 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Admin powers: [`debug`,`spectate`,`players`,`editplayer`,`vehicles`,`cursortarget`,`admintag`,`globalmessage`,`factories`,`mapmarkers`,`mapteleporting`,`twitter`,`createfire`,`removefire`,`mayorvote`]\r\nTwitter Profile: [`DIRECTORTAG`,`#fff200`,[[`DIRECTORTAG`,Director`],[`CIVTAG`,`Civ`]],[]]';
439
440-- Dumping data for table life.players: ~1 rows (approximately)
441/*!40000 ALTER TABLE `players` DISABLE KEYS */;
442INSERT INTO `players` (`ID`, `uid`, `name`, `job`, `gender`, `dob`, `pasportdate`, `lastseen`, `cash`, `bank`, `faction`, `faction_rank`, `position`, `userkey`, `licenses`, `loadout`, `virtualinv`, `player_fstorage`, `jail`, `adminpowers`, `stafftitle`, `twitterprofile`) VALUES
443 (230, '76561198119367976', 'Eli Rees', 'unemployed', 'male', '1/1/1990', '2018-08-07 04:05:34', '2018-08-07 06:11:14', 3993, 1800, 'police', 8, '[2569.81,5651.29,0.00141144]', '[`door_1`]', '[]', '[[],[],[],[`A3PL_SD_Sheriff_Test_Uniform`,[]],[`A3PL_SD_Detective_Vest_Lite`,[]],[`A3PL_LR`,[]],`A3PL_Sheriff_Hat_Black`,``,[],[`ItemMap`,``,`A3PL_Cellphone_1`,`ItemCompass`,`tf_microdagr`,``]]', '[[`burger_full_cooked`,3],[`coke`,5],[`repairwrench`,2],[`handcuffs`,1],[`stinger`,1]]', '[[`Chemical Plant`,[[`Synthetic_Fibre`,1]]]]', 0, '[`debug`,`spectate`,`players`,`editplayer`,`vehicles`,`cursortarget`,`admintag`,`globalmessage`,`factories`,`mapmarkers`,`mapteleporting`,`twitter`,`createfire`,`removefire`,`mayorvote`]', 'player', '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`,[[`\\A3PL_Common\\icons\\citizen.paa`,`Citizen Tag`]],[[`#ed7202`,`Citizen`]],[[`#B5B5B5`,`Default`]]]');
444/*!40000 ALTER TABLE `players` ENABLE KEYS */;
445
446-- Dumping structure for table life.policedatabase
447CREATE TABLE IF NOT EXISTS `policedatabase` (
448 `ID` int(20) NOT NULL AUTO_INCREMENT,
449 `UID` varchar(50) DEFAULT NULL,
450 `Actiontype` varchar(50) DEFAULT NULL,
451 `Info` varchar(500) DEFAULT NULL,
452 `Time` varchar(50) DEFAULT NULL,
453 `Title` varchar(100) DEFAULT NULL,
454 `Amount` mediumint(20) unsigned DEFAULT '0',
455 `IssuedBy` varchar(50) DEFAULT NULL,
456 UNIQUE KEY `ID` (`ID`) USING BTREE
457) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
458
459-- Dumping data for table life.policedatabase: ~0 rows (approximately)
460/*!40000 ALTER TABLE `policedatabase` DISABLE KEYS */;
461/*!40000 ALTER TABLE `policedatabase` ENABLE KEYS */;
462
463-- Dumping structure for table life.referal_system
464CREATE TABLE IF NOT EXISTS `referal_system` (
465 `id` int(11) NOT NULL AUTO_INCREMENT,
466 `token` varchar(50) DEFAULT NULL,
467 `reward` text,
468 `limit` int(11) DEFAULT '0',
469 `count` int(11) DEFAULT '0',
470 `uid` varchar(50) DEFAULT NULL,
471 `rewardCreator` int(11) DEFAULT '0',
472 PRIMARY KEY (`id`),
473 UNIQUE KEY `token` (`token`)
474) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
475
476-- Dumping data for table life.referal_system: ~0 rows (approximately)
477/*!40000 ALTER TABLE `referal_system` DISABLE KEYS */;
478/*!40000 ALTER TABLE `referal_system` ENABLE KEYS */;
479
480-- Dumping structure for table life.shops
481CREATE TABLE IF NOT EXISTS `shops` (
482 `id` smallint(6) NOT NULL AUTO_INCREMENT,
483 `shop` varchar(50) NOT NULL DEFAULT 'Shop_Vehicles_Supplies_Vendor',
484 `object` varchar(30) NOT NULL DEFAULT '',
485 `stock` varchar(500) NOT NULL DEFAULT '[]',
486 UNIQUE KEY `id` (`id`) USING BTREE
487) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
488
489-- Dumping data for table life.shops: ~0 rows (approximately)
490/*!40000 ALTER TABLE `shops` DISABLE KEYS */;
491INSERT INTO `shops` (`id`, `shop`, `object`, `stock`) VALUES
492 (1, 'Shop_Vehicles_Supplies_Vendor', 'NPC_vehicles_1', '[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]'),
493 (2, 'Shop_Supermarket', 'npc_supermarket_1', '[496,100,100,100,100,100,35,1426,100,100]');
494/*!40000 ALTER TABLE `shops` ENABLE KEYS */;
495
496/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
497/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
498/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;