· 7 years ago · Dec 05, 2018, 02:34 PM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.3.8-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 9.4.0.5125
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=22701 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
29
30-- Data exporting was unselected.
31-- Dumping structure for table life.chatlog
32CREATE TABLE IF NOT EXISTS `chatlog` (
33 `name` tinytext DEFAULT NULL,
34 `steamid` tinytext DEFAULT NULL,
35 `chatmessage` tinytext DEFAULT NULL,
36 `messageinfo` varchar(500) DEFAULT '[``,`#ed7202`,`#B5B5B5`]',
37 `date` timestamp NULL DEFAULT current_timestamp()
38) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
39
40-- Data exporting was unselected.
41-- Dumping structure for table life.factions
42CREATE TABLE IF NOT EXISTS `factions` (
43 `id` int(6) NOT NULL AUTO_INCREMENT,
44 `leader` varchar(17) NOT NULL,
45 `type` varchar(50) NOT NULL,
46 `max_rank` int(11) NOT NULL DEFAULT 1,
47 PRIMARY KEY (`id`)
48) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
49
50
51INSERT INTO government_balances VALUES (1,'FEDERAL_GRANT',1000000),(2,'PD_BUDGET',1483250),(3,'FD_BUDGET',510776),(4,'CG_BUDGET',704564),(5,'DMV_BUDGET',617007),(6,'DOJ_BUDGET',98180),(7,'FAA_BUDGET',316228),(8,'SALES_TAX',10),(9,'INCOME_TAX',5),(10,'PROPERTY_TAX',10),(11,'IMPORT_TAX',10),(12,'SALES_TAX_BAL',823629),(13,'INCOME_TAX_BAL',287969),(14,'PROPERTY_TAX_BAL',237500),(15,'IMPORT_TAX_BAL',40429);
52
53-- Data exporting was unselected.
54-- Dumping structure for table life.faction_ranks
55CREATE TABLE IF NOT EXISTS `faction_ranks` (
56 `id` int(6) NOT NULL AUTO_INCREMENT,
57 `fid` int(6) NOT NULL,
58 `name` varchar(50) NOT NULL,
59 `level` int(11) NOT NULL DEFAULT 1,
60 `paycheck` int(100) NOT NULL DEFAULT 1000,
61 `cap` int(100) NOT NULL DEFAULT 1000,
62 PRIMARY KEY (`id`)
63) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
64
65-- Data exporting was unselected.
66-- Dumping structure for table life.faction_vehicle_shop
67CREATE TABLE IF NOT EXISTS `faction_vehicle_shop` (
68 `id` int(11) NOT NULL AUTO_INCREMENT,
69 `var` varchar(50) NOT NULL,
70 `type` enum('fifr','police','uscg','uscg_h','uscg_b','dmv','faa','doj') NOT NULL,
71 `stock` varchar(50) NOT NULL,
72 PRIMARY KEY (`id`)
73) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
74
75-- Data exporting was unselected.
76-- Dumping structure for table life.government_balances
77CREATE TABLE IF NOT EXISTS `government_balances` (
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `var` varchar(50) DEFAULT NULL,
80 `balance` bigint(20) DEFAULT 0,
81 PRIMARY KEY (`id`)
82) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COMMENT='Contains balances for government fund and the current tax rates';
83
84-- Data exporting was unselected.
85-- Dumping structure for table life.government_laws
86CREATE TABLE IF NOT EXISTS `government_laws` (
87 `id` int(11) NOT NULL AUTO_INCREMENT,
88 `law` text NOT NULL,
89 `added` datetime NOT NULL DEFAULT current_timestamp(),
90 PRIMARY KEY (`id`)
91) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
92
93-- Data exporting was unselected.
94-- Dumping structure for table life.houses
95CREATE TABLE IF NOT EXISTS `houses` (
96 `uid` varchar(50) DEFAULT NULL,
97 `location` varchar(50) DEFAULT NULL,
98 `doorid` varchar(50) DEFAULT NULL,
99 `items` varchar(7000) DEFAULT '[[],[],[]]',
100 `vitems` varchar(7000) DEFAULT '[]',
101 `pitems` varchar(7000) DEFAULT '[]',
102 UNIQUE KEY `location` (`location`) USING BTREE
103) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
104
105-- Data exporting was unselected.
106-- Dumping structure for table life.import_export
107CREATE TABLE IF NOT EXISTS `import_export` (
108 `item` varchar(50) DEFAULT NULL,
109 `import` int(25) DEFAULT NULL,
110 `export` int(25) DEFAULT NULL
111) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
112
113-- Data exporting was unselected.
114-- Dumping structure for table life.logs
115CREATE TABLE IF NOT EXISTS `logs` (
116 `ID` int(255) NOT NULL AUTO_INCREMENT,
117 `uid` varchar(50) NOT NULL,
118 `type` varchar(50) NOT NULL,
119 `data` text NOT NULL,
120 `time` timestamp NOT NULL DEFAULT current_timestamp(),
121 PRIMARY KEY (`ID`) USING BTREE
122) ENGINE=InnoDB AUTO_INCREMENT=35809 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
123
124-- Data exporting was unselected.
125-- Dumping structure for table life.objects
126CREATE TABLE IF NOT EXISTS `objects` (
127 `aiid` int(11) NOT NULL AUTO_INCREMENT,
128 `id` varchar(50) NOT NULL,
129 `type` varchar(50) NOT NULL DEFAULT 'object',
130 `class` varchar(50) NOT NULL,
131 `uid` varchar(50) NOT NULL,
132 `plystorage` tinyint(1) NOT NULL DEFAULT 0,
133 `spawn` tinyint(1) NOT NULL DEFAULT 0,
134 `pos` varchar(50) NOT NULL DEFAULT '[]',
135 `vars` varchar(50) NOT NULL DEFAULT '[]',
136 `impounded` tinyint(1) NOT NULL DEFAULT 0,
137 `fuel` float NOT NULL DEFAULT 1,
138 `color` varchar(300) NOT NULL DEFAULT '#(argb,8,8,3)color(1,1,1,1.0,co)',
139 PRIMARY KEY (`aiid`),
140 UNIQUE KEY `id` (`id`) USING BTREE
141) ENGINE=InnoDB AUTO_INCREMENT=749 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
142
143-- Data exporting was unselected.
144-- Dumping structure for table life.persistent_vars
145CREATE TABLE IF NOT EXISTS `persistent_vars` (
146 `var` varchar(50) DEFAULT NULL,
147 `value` varchar(5000) DEFAULT '[]',
148 `pv` tinyint(1) DEFAULT 0,
149 UNIQUE KEY `var` (`var`) USING BTREE
150) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
151
152-- Data exporting was unselected.
153-- Dumping structure for table life.players
154CREATE TABLE IF NOT EXISTS `players` (
155 `ID` int(10) NOT NULL AUTO_INCREMENT,
156 `uid` varchar(50) DEFAULT NULL,
157 `name` varchar(50) DEFAULT '',
158 `job` varchar(50) DEFAULT 'unemployed',
159 `gender` varchar(50) DEFAULT 'male',
160 `dob` varchar(50) DEFAULT '1/1/1990',
161 `pasportdate` varchar(50) DEFAULT NULL,
162 `lastseen` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
163 `cash` int(11) DEFAULT 0,
164 `bank` int(11) DEFAULT 500,
165 `faction` varchar(50) DEFAULT 'citizen',
166 `faction_rank` int(11) NOT NULL DEFAULT 0,
167 `position` varchar(50) DEFAULT '[2786.83,5387.44,0.00146484]',
168 `userkey` varchar(500) DEFAULT '[]',
169 `licenses` varchar(75) DEFAULT '[]',
170 `loadout` varchar(3000) DEFAULT '[]',
171 `virtualinv` varchar(2000) DEFAULT '[]',
172 `player_fstorage` varchar(5000) DEFAULT '[]',
173 `jail` int(20) unsigned DEFAULT 0,
174 `adminpowers` varchar(750) DEFAULT '[]',
175 `stafftitle` varchar(50) NOT NULL,
176 `twitterprofile` varchar(500) NOT NULL DEFAULT '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`,[[`\\A3PL_Common\\icons\\citizen.paa`,`Citizen Tag`]],[[`#ed7202`,`Citizen`]],[[`#B5B5B5`,`Default`]]]',
177 PRIMARY KEY (`ID`) USING BTREE,
178 UNIQUE KEY `uid` (`uid`) USING BTREE
179) ENGINE=InnoDB AUTO_INCREMENT=230 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`]],[]]';
180
181-- Data exporting was unselected.
182-- Dumping structure for table life.policedatabase
183CREATE TABLE IF NOT EXISTS `policedatabase` (
184 `ID` int(20) NOT NULL AUTO_INCREMENT,
185 `UID` varchar(50) DEFAULT NULL,
186 `Actiontype` varchar(50) DEFAULT NULL,
187 `Info` varchar(500) DEFAULT NULL,
188 `Time` varchar(50) DEFAULT NULL,
189 `Title` varchar(100) DEFAULT NULL,
190 `Amount` mediumint(20) unsigned DEFAULT 0,
191 `IssuedBy` varchar(50) DEFAULT NULL,
192 UNIQUE KEY `ID` (`ID`) USING BTREE
193) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
194
195-- Data exporting was unselected.
196-- Dumping structure for table life.referal_system
197CREATE TABLE IF NOT EXISTS `referal_system` (
198 `id` int(11) NOT NULL AUTO_INCREMENT,
199 `token` varchar(50) DEFAULT NULL,
200 `reward` text DEFAULT NULL,
201 `limit` int(11) DEFAULT 0,
202 `count` int(11) DEFAULT 0,
203 `uid` varchar(50) DEFAULT NULL,
204 `rewardCreator` int(11) DEFAULT 0,
205 PRIMARY KEY (`id`),
206 UNIQUE KEY `token` (`token`)
207) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
208
209INSERT INTO `shops` VALUES (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]');
210INSERT INTO `shops` VALUES (2, 'Shop_Supermarket', 'npc_supermarket_1', '[496,0,0,0,0,0,35,1426,0,0]');
211
212-- Data exporting was unselected.
213-- Dumping structure for table life.shops
214CREATE TABLE IF NOT EXISTS `shops` (
215 `id` smallint(6) NOT NULL AUTO_INCREMENT,
216 `shop` varchar(50) NOT NULL DEFAULT 'Shop_Vehicles_Supplies_Vendor',
217 `object` varchar(30) NOT NULL DEFAULT '',
218 `stock` varchar(500) NOT NULL DEFAULT '[]',
219 UNIQUE KEY `id` (`id`) USING BTREE
220) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
221
222-- Data exporting was unselected.
223/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
224/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
225/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;