· 6 years ago · May 19, 2019, 09:06 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-- Data exporting was unselected.
51-- Dumping structure for table life.faction_ranks
52CREATE TABLE IF NOT EXISTS `faction_ranks` (
53 `id` int(6) NOT NULL AUTO_INCREMENT,
54 `fid` int(6) NOT NULL,
55 `name` varchar(50) NOT NULL,
56 `level` int(11) NOT NULL DEFAULT 1,
57 `paycheck` int(100) NOT NULL DEFAULT 1000,
58 `cap` int(100) NOT NULL DEFAULT 1000,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
61
62-- Data exporting was unselected.
63-- Dumping structure for table life.faction_vehicle_shop
64CREATE TABLE IF NOT EXISTS `faction_vehicle_shop` (
65 `id` int(11) NOT NULL AUTO_INCREMENT,
66 `var` varchar(50) NOT NULL,
67 `type` enum('fifr','police','uscg','uscg_h','uscg_b','dmv','faa','doj') NOT NULL,
68 `stock` varchar(50) NOT NULL,
69 PRIMARY KEY (`id`)
70) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
71
72-- Data exporting was unselected.
73-- Dumping structure for table life.government_balances
74CREATE TABLE IF NOT EXISTS `government_balances` (
75 `id` int(11) NOT NULL AUTO_INCREMENT,
76 `var` varchar(50) DEFAULT NULL,
77 `balance` bigint(20) DEFAULT 0,
78 PRIMARY KEY (`id`)
79) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1 COMMENT='Contains balances for government fund and the current tax rates';
80
81-- Data exporting was unselected.
82-- Dumping structure for table life.government_laws
83CREATE TABLE IF NOT EXISTS `government_laws` (
84 `id` int(11) NOT NULL AUTO_INCREMENT,
85 `law` text NOT NULL,
86 `added` datetime NOT NULL DEFAULT current_timestamp(),
87 PRIMARY KEY (`id`)
88) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
89
90-- Data exporting was unselected.
91-- Dumping structure for table life.houses
92CREATE TABLE IF NOT EXISTS `houses` (
93 `uid` varchar(50) DEFAULT NULL,
94 `location` varchar(50) DEFAULT NULL,
95 `doorid` varchar(50) DEFAULT NULL,
96 `items` varchar(7000) DEFAULT '[[],[],[]]',
97 `vitems` varchar(7000) DEFAULT '[]',
98 `pitems` varchar(7000) DEFAULT '[]',
99 UNIQUE KEY `location` (`location`) USING BTREE
100) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
101
102-- Data exporting was unselected.
103-- Dumping structure for table life.import_export
104CREATE TABLE IF NOT EXISTS `import_export` (
105 `item` varchar(50) DEFAULT NULL,
106 `import` int(25) DEFAULT NULL,
107 `export` int(25) DEFAULT NULL
108) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
109
110-- Data exporting was unselected.
111-- Dumping structure for table life.logs
112CREATE TABLE IF NOT EXISTS `logs` (
113 `ID` int(255) NOT NULL AUTO_INCREMENT,
114 `uid` varchar(50) NOT NULL,
115 `type` varchar(50) NOT NULL,
116 `data` text NOT NULL,
117 `time` timestamp NOT NULL DEFAULT current_timestamp(),
118 PRIMARY KEY (`ID`) USING BTREE
119) ENGINE=InnoDB AUTO_INCREMENT=35809 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
120
121-- Data exporting was unselected.
122-- Dumping structure for table life.objects
123CREATE TABLE IF NOT EXISTS `objects` (
124 `aiid` int(11) NOT NULL AUTO_INCREMENT,
125 `id` varchar(50) NOT NULL,
126 `type` varchar(50) NOT NULL DEFAULT 'object',
127 `class` varchar(50) NOT NULL,
128 `uid` varchar(50) NOT NULL,
129 `plystorage` tinyint(1) NOT NULL DEFAULT 0,
130 `spawn` tinyint(1) NOT NULL DEFAULT 0,
131 `pos` varchar(50) NOT NULL DEFAULT '[]',
132 `vars` varchar(50) NOT NULL DEFAULT '[]',
133 `impounded` tinyint(1) NOT NULL DEFAULT 0,
134 `fuel` float NOT NULL DEFAULT 1,
135 `color` varchar(300) NOT NULL DEFAULT '#(argb,8,8,3)color(1,1,1,1.0,co)',
136 PRIMARY KEY (`aiid`),
137 UNIQUE KEY `id` (`id`) USING BTREE
138) ENGINE=InnoDB AUTO_INCREMENT=749 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
139
140-- Data exporting was unselected.
141-- Dumping structure for table life.persistent_vars
142CREATE TABLE IF NOT EXISTS `persistent_vars` (
143 `var` varchar(50) DEFAULT NULL,
144 `value` varchar(5000) DEFAULT '[]',
145 `pv` tinyint(1) DEFAULT 0,
146 UNIQUE KEY `var` (`var`) USING BTREE
147) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
148
149-- Data exporting was unselected.
150-- Dumping structure for table life.players
151CREATE TABLE IF NOT EXISTS `players` (
152 `ID` int(10) NOT NULL AUTO_INCREMENT,
153 `uid` varchar(50) DEFAULT NULL,
154 `name` varchar(50) DEFAULT '',
155 `job` varchar(50) DEFAULT 'unemployed',
156 `gender` varchar(50) DEFAULT 'male',
157 `dob` varchar(50) DEFAULT '1/1/1990',
158 `pasportdate` varchar(50) DEFAULT NULL,
159 `lastseen` timestamp NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
160 `cash` int(11) DEFAULT 0,
161 `bank` int(11) DEFAULT 500,
162 `faction` varchar(50) DEFAULT 'citizen',
163 `faction_rank` int(11) NOT NULL DEFAULT 0,
164 `position` varchar(50) DEFAULT '[2786.83,5387.44,0.00146484]',
165 `userkey` varchar(500) DEFAULT '[]',
166 `licenses` varchar(75) DEFAULT '[]',
167 `loadout` varchar(3000) DEFAULT '[]',
168 `virtualinv` varchar(2000) DEFAULT '[]',
169 `player_fstorage` varchar(5000) DEFAULT '[]',
170 `jail` int(20) unsigned DEFAULT 0,
171 `adminpowers` varchar(750) DEFAULT '[]',
172 `stafftitle` varchar(50) NOT NULL,
173 `twitterprofile` varchar(500) NOT NULL DEFAULT '[`\\A3PL_Common\\icons\\citizen.paa`,`#ed7202`,`#B5B5B5`,[[`\\A3PL_Common\\icons\\citizen.paa`,`Citizen Tag`]],[[`#ed7202`,`Citizen`]],[[`#B5B5B5`,`Default`]]]',
174 PRIMARY KEY (`ID`) USING BTREE,
175 UNIQUE KEY `uid` (`uid`) USING BTREE
176) 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`]],[]]';
177
178-- Data exporting was unselected.
179-- Dumping structure for table life.policedatabase
180CREATE TABLE IF NOT EXISTS `policedatabase` (
181 `ID` int(20) NOT NULL AUTO_INCREMENT,
182 `UID` varchar(50) DEFAULT NULL,
183 `Actiontype` varchar(50) DEFAULT NULL,
184 `Info` varchar(500) DEFAULT NULL,
185 `Time` varchar(50) DEFAULT NULL,
186 `Title` varchar(100) DEFAULT NULL,
187 `Amount` mediumint(20) unsigned DEFAULT 0,
188 `IssuedBy` varchar(50) DEFAULT NULL,
189 UNIQUE KEY `ID` (`ID`) USING BTREE
190) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
191
192-- Data exporting was unselected.
193-- Dumping structure for table life.referal_system
194CREATE TABLE IF NOT EXISTS `referal_system` (
195 `id` int(11) NOT NULL AUTO_INCREMENT,
196 `token` varchar(50) DEFAULT NULL,
197 `reward` text DEFAULT NULL,
198 `limit` int(11) DEFAULT 0,
199 `count` int(11) DEFAULT 0,
200 `uid` varchar(50) DEFAULT NULL,
201 `rewardCreator` int(11) DEFAULT 0,
202 PRIMARY KEY (`id`),
203 UNIQUE KEY `token` (`token`)
204) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
205
206-- Data exporting was unselected.
207-- Dumping structure for table life.shops
208CREATE TABLE IF NOT EXISTS `shops` (
209 `id` smallint(6) NOT NULL AUTO_INCREMENT,
210 `shop` varchar(50) NOT NULL DEFAULT 'Shop_Vehicles_Supplies_Vendor',
211 `object` varchar(30) NOT NULL DEFAULT '',
212 `stock` varchar(500) NOT NULL DEFAULT '[]',
213 UNIQUE KEY `id` (`id`) USING BTREE
214) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
215
216-- Data exporting was unselected.
217/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
218/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
219/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;