· 7 years ago · Dec 28, 2018, 05:22 AM
1SET NAMES utf8mb4;
2SET FOREIGN_KEY_CHECKS = 0;
3
4CREATE DATABASE IF NOT EXISTS `life` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
5USE `life`;
6
7DROP TABLE IF EXISTS `adminlogs`;
8CREATE TABLE `adminlogs` (
9 `ID` int(255) NOT NULL AUTO_INCREMENT,
10 `adminname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
11 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
12 `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
13 `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
14 `time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
15 PRIMARY KEY (`ID`) USING BTREE
16) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
17
18DROP TABLE IF EXISTS `chatlog`;
19CREATE TABLE `chatlog` (
20 `name` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
21 `steamid` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
22 `chatmessage` tinytext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
23 `messageinfo` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[``,`#ed7202`,`#B5B5B5`]',
24 `date` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP
25) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
26
27DROP TABLE IF EXISTS `houses`;
28CREATE TABLE `houses` (
29 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
30 `location` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
31 `doorid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
32 `items` varchar(7000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[[],[],[]]',
33 `vitems` varchar(7000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
34 `pitems` varchar(7000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
35 UNIQUE INDEX `location`(`location`) USING BTREE
36) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
37
38DROP TABLE IF EXISTS `import_export`;
39CREATE TABLE `import_export` (
40 `item` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
41 `import` int(25) NULL DEFAULT NULL,
42 `export` int(25) NULL DEFAULT NULL
43) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
44
45DROP TABLE IF EXISTS `logs`;
46CREATE TABLE `logs` (
47 `ID` int(255) NOT NULL AUTO_INCREMENT,
48 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
49 `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
50 `data` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
51 `time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
52 PRIMARY KEY (`ID`) USING BTREE
53) ENGINE = InnoDB AUTO_INCREMENT = 4509827 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
54
55DROP TABLE IF EXISTS `shops`;
56CREATE TABLE `shops` (
57 `id` smallint(6) NOT NULL AUTO_INCREMENT,
58 `shop` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'Shop_Vehicles_Supplies_Vendor',
59 `object` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
60 `stock` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]',
61 UNIQUE INDEX `id`(`id`) USING BTREE
62) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
63
64INSERT 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]');
65INSERT INTO `shops` VALUES (2, 'Shop_Supermarket', 'npc_supermarket_1', '[496,0,0,0,0,0,35,1426,0,0]');
66
67DROP TABLE IF EXISTS `policedatabase`;
68CREATE TABLE `policedatabase` (
69 `ID` int(20) NOT NULL AUTO_INCREMENT,
70 `UID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
71 `Actiontype` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
72 `Info` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
73 `Time` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
74 `Title` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
75 `Amount` mediumint(20) UNSIGNED NULL DEFAULT 0,
76 `IssuedBy` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
77 UNIQUE INDEX `ID`(`ID`) USING BTREE
78) ENGINE = InnoDB AUTO_INCREMENT = 14118 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
79
80DROP TABLE IF EXISTS `players`;
81CREATE TABLE `players` (
82 `ID` int(10) NOT NULL AUTO_INCREMENT,
83 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
84 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '',
85 `job` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'unemployed',
86 `gender` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'male',
87 `dob` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '1/1/1990',
88 `pasportdate` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
89 `lastseen` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
90 `cash` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '0',
91 `bank` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '500',
92 `faction` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'citizen',
93 `position` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[2786.83,5387.44,0.00146484]',
94 `userkey` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
95 `licenses` varchar(75) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
96 `loadout` varchar(3000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
97 `virtualinv` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
98 `player_fstorage` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
99 `jail` int(20) UNSIGNED NULL DEFAULT 0,
100 `adminpowers` varchar(750) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
101 `twitterprofile` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[\`\\A3PL_Common\\icons\\citizen.paa\`,\`#ed7202\`,\`#B5B5B5\`,[[\`\\A3PL_Common\\icons\\citizen.paa\`,\`Citizen Tag\`]],[[\`#ed7202\`,\`Citizen\`]],[[\`#B5B5B5\`,\`Default\`]]]',
102 PRIMARY KEY (`ID`) USING BTREE,
103 UNIQUE INDEX `uid`(`uid`) USING BTREE
104) ENGINE = InnoDB AUTO_INCREMENT = 4193 CHARACTER SET = utf8 COLLATE = utf8_general_ci 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`]],[]]' ROW_FORMAT = Compact;
105
106DROP TABLE IF EXISTS `persistent_vars`;
107CREATE TABLE `persistent_vars` (
108 `var` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
109 `value` varchar(5000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '[]',
110 `pv` tinyint(1) NULL DEFAULT 0,
111 UNIQUE INDEX `var`(`var`) USING BTREE
112) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
113
114-- ----------------------------
115-- Records of persistent_vars
116-- ----------------------------
117INSERT INTO `persistent_vars` VALUES ('Server_JobVDelivery_JobList', '[]', 0);
118INSERT INTO `persistent_vars` VALUES ('A3PL_Mayor', '[`76561198096687678`,`David White`]', 1);
119INSERT INTO `persistent_vars` VALUES ('Config_Government_Taxes', '[[`Property tax`,0],[`Income tax`,0],[`Sales tax`,0]]', 1);
120INSERT INTO `persistent_vars` VALUES ('Config_Government_Balances', '[[`Property`,50],[`Income`,25],[`Sales`,0],[`Sheriff Department`,1.27833e+007],[`Fire Department`,4.83434e+006],[`EMS`,929505],[`USCG`,55000]]', 1);
121INSERT INTO `persistent_vars` VALUES ('Config_Government_Laws', '[]', 1);
122INSERT INTO `persistent_vars` VALUES ('Server_Government_Candidates', '[[`Tarvis Yelnats`,`76561198337629759`,0],[`Chris Frost`,`76561198156027137`,0],[`Jamie Freeman`,`76561198258127426`,0],[`Jackson Murray`,`76561198149721039`,0],[`Todd Gold`,`76561198098259274`,0],[`Chance Ross`,`76561198079605755`,0],[`Brian Rodriguez`,`76561198189367157`,0],[`Jonathan Winchester`,`76561198259139641`,0],[`Scott Davidson`,`76561198116673275`,0],[`Ethan Freeman`,`76561198217493932`,0],[`Stevey Turner`,`76561198065187500`,0],[`Patrizio Veloucci`,`76561198360987974`,0],[`Dariusz Kolski`,`76561198024843663`,0],[`Saddam Najail`,`76561198044558610`,0],[`Bryan Kimble`,`76561198335384656`,0],[`Trevyane King`,`76561198156121819`,0],[`Kenne Lexington`,`76561198125086726`,0],[`Bundy Sinatra`,`76561198233338148`,0],[`Geno Sinatra`,`76561198082985244`,0],[`Billy Blackbeard`,`76561198206360225`,0],[`Justin Woods`,`76561198271678450`,0],[`Joshua Cook`,`76561198122473008`,0],[`Jack Dudeson`,`76561198098695638`,0],[`James Clarke`,`76561198127211592`,0],[`Owen Parks`,`76561198131392912`,0],[`Rob Daeux`,`76561198095913990`,0],[`Ray King`,`76561198213784672`,0],[`Desmen Narco`,`76561198108249230`,0],[`Scott Freeman`,`76561198241303332`,0],[`Brian McCaffrey`,`76561198108517267`,0],[`James Axel`,`76561198155438174`,0],[`Steiner Mcflaren`,`76561198116340278`,0],[`James Armstrong`,`76561198143650213`,0],[`Jaycee Smith`,`76561198284027841`,0],[`Josh Deal`,`76561198069677973`,0],[`Ian Valentine`,`76561198260328340`,0],[`Jack King`,`76561198406447291`,0],[`Ryan Jefferson`,`76561198315530435`,0],[`Demitry Freeman`,`76561198159335513`,0],[`Damion OConnor`,`76561198077963369`,0],[`Mavrick Whisky`,`76561198084473560`,0],[`Jasper Calandra`,`76561198137187873`,0],[`William Slater`,`76561198139714859`,0],[`Jack Che`,`76561198085629244`,0],[`Brice Brown`,`76561198397469585`,0],[`Nathaniel Mitchell`,`76561198097784648`,0],[`Abner Edmunds`,`76561198055681914`,0],[`Will Danger`,`76561198247113122`,0],[`Peyton Weber`,`76561198053106823`,0],[`Alex Rosewood`,`76561198134462494`,0],[`Benito Granado`,`76561198168063059`,0],[`Tyler Veloucci`,`76561198079110818`,0],[`Jimmy Fung`,`76561198162736077`,0],[`Rick Walkins`,`76561198258516410`,0],[`Ryan Vincent`,`76561198143516972`,0],[`Jake Ortiz`,`76561198058598756`,0],[`Dylan Whed`,`76561197972075186`,0],[`Christopher Silversmith`,`76561198059220148`,0],[`Christian Williams`,`76561198183158678`,0],[`Matt Hayden`,`76561198436941843`,0],[`Negan Jones`,`76561198299515851`,0],[`Steve Atwood`,`76561198080135465`,0],[`Luke Little`,`76561198143574045`,0],[`Mile Stark`,`76561198056364339`,0],[`Gary Wong`,`76561198120734229`,0],[`James Belfort`,`76561198156365845`,0],[`Jimmy King`,`76561197963981973`,0],[`Ted Parker`,`76561198173305534`,0],[`Dustin Stewart`,`76561198092659432`,0],[`Arnold Grimes`,`76561198050936226`,0],[`Fraser Blackwater`,`76561198407039286`,0],[`John Radeno`,`76561198134461863`,0],[`Steve Walton`,`76561198193625762`,0],[`James Barroso`,`76561198349306859`,0],[`Rian Cooper`,`76561198355296720`,0],[`Joseph Ibney`,`76561198027023134`,0],[`Jason Force`,`76561198168813942`,0],[`Alex Davis`,`76561198211134371`,0],[`Malagasy Anchovy`,`76561198265151967`,0],[`Reece May`,`76561198278188412`,0],[`Gibson Gray`,`76561198055436292`,0],[`Konstantinos Woods`,`76561198119480283`,0],[`John Lestner`,`76561198024467969`,0],[`Ricky Booker`,`76561198338683183`,0],[`Rome Smith`,`76561198015418874`,0],[`Cody Robertson`,`76561198122612955`,0],[`Sean Kale`,`76561198322474824`,0],[`John Collier`,`76561198026397805`,0],[`Jim Pickett`,`76561198202253530`,0],[`Tyler Dent`,`76561198098397315`,0]]', 0);
123INSERT INTO `persistent_vars` VALUES ('Config_Government_FactionLead', '[[`police`,`76561198021843042`],[`ems`,`76561198031533755`],[`fd`,`76561198022915753`],[`uscg`,`76561198106704278`]]', 1);
124INSERT INTO `persistent_vars` VALUES ('Server_Government_FactionRanks', '[[`police`,[]],[`ems`,[]],[`fd`,[]],[`uscg`,[]]]', 0);
125
126CREATE TABLE IF NOT EXISTS `factions` (
127 `id` int(6) NOT NULL AUTO_INCREMENT,
128 `leader` varchar(17) NOT NULL,
129 `type` varchar(50) NOT NULL,
130 `max_rank` enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NOT NULL DEFAULT '1',
131 PRIMARY KEY (`id`)
132) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
133
134INSERT INTO `factions` (`id`, `leader`, `type`, `max_rank`) VALUES
135 (1, '211', 'POLICE', '8'),
136 (2, '38', 'USCG', '14'),
137 (3, '162', 'FIFR', '11'),
138 (4, '133', 'DOJ', '6'),
139 (5, '40', 'DMV', '3'),
140 (6, '1', 'FAA', '1');
141
142CREATE TABLE IF NOT EXISTS `faction_ranks` (
143 `id` int(6) NOT NULL AUTO_INCREMENT,
144 `fid` int(6) NOT NULL,
145 `name` varchar(50) NOT NULL,
146 `level` enum('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NOT NULL DEFAULT '1',
147 `paycheck` int(100) NOT NULL DEFAULT '1000',
148 PRIMARY KEY (`id`)
149) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
150
151INSERT INTO `faction_ranks` (`id`, `fid`, `name`, `level`, `paycheck`) VALUES
152 (1, 2, 'Seaman Recruit', '1', 1000),
153 (2, 2, 'Seaman Apprentice', '2', 1000),
154 (3, 2, 'Seaman', '3', 1000),
155 (4, 2, 'Petty Officer', '4', 1000),
156 (5, 2, 'Chief Petty Officer', '5', 1000),
157 (6, 2, 'Senior Chief Petty Officer', '6', 1000),
158 (7, 2, 'Master Chief Petty Officer', '7', 1000),
159 (8, 2, 'Command Master Chief Petty Officer', '8', 1000),
160 (9, 2, 'Ensign', '9', 1000),
161 (10, 2, 'Lieutenant, Junior Grade', '10', 1000),
162 (11, 2, 'Lieutenant', '11', 1000),
163 (12, 2, 'Lieutenant Commander ', '12', 1000),
164 (13, 2, 'Commander', '13', 1000),
165 (14, 2, 'Captain', '14', 1000),
166 (15, 1, 'Cadet', '1', 1000),
167 (16, 1, 'Deputy', '2', 1000),
168 (17, 1, 'Corporal', '3', 1000),
169 (18, 1, 'Sergeant', '4', 1000),
170 (19, 1, 'Detective', '5', 1000),
171 (20, 1, 'Lieutenant', '6', 1000),
172 (21, 1, 'UnderSheriff', '7', 1000),
173 (22, 1, 'Sheriff', '8', 1000),
174 (23, 3, 'Chief', '11', 1000),
175 (24, 3, 'Deputy Chief', '10', 1000),
176 (25, 3, 'Battalion Chief', '9', 1000),
177 (26, 3, 'Captin', '8', 1000),
178 (27, 3, 'Lieutenant', '7', 1000),
179 (28, 3, 'Engineer / Paramedic', '6', 1000),
180 (29, 3, 'Firefighter / Paramedic', '5', 1000),
181 (30, 3, 'Firefighter / EMT', '4', 1000),
182 (31, 3, 'Probationary', '3', 1000),
183 (32, 3, 'Recruit', '2', 1000),
184 (33, 3, 'Volunteer', '1', 1000),
185 (34, 4, 'Chief Justice', '6', 1000),
186 (35, 4, 'Assistant Chief Justice', '5', 1000),
187 (36, 4, 'Executive Judge', '4', 1000),
188 (37, 4, 'District Attorney', '3', 1000),
189 (38, 4, 'State Prosecutor', '2', 1000),
190 (39, 4, 'Lawyer', '1', 1000),
191 (40, 5, 'Manager', '3', 1000),
192 (41, 5, 'Assistant Manager', '2', 1000),
193 (42, 5, 'Employee', '1', 1000);
194
195ALTER TABLE `players` ADD `stafftitle` VARCHAR(50) NOT NULL AFTER `adminpowers`;
196ALTER TABLE `players` ADD `faction_rank` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20') NOT NULL DEFAULT '0' AFTER `faction`;
197
198DELETE FROM `faction_vehicle_shop`;
199
200INSERT INTO `faction_vehicle_shop` (`id`, `var`, `type`, `stock`) VALUES
201 (1, 'FIFR_VEHICLE_STOCK', 'fifr', '[80,80,30,30,30,30,30,30]'),
202 (2, 'USCG_VEHICLE_STOCK', 'uscg', '[30,30,30,30,30,30]'),
203 (3, 'POLICE_VEHICLE_STOCK', 'police', '[30,30,30,30,30,30,30,30,30,30]'),
204 (4, 'USCG_BOAT_STOCK', 'uscg', '[30,30,30,29,30,30]'),
205 (5, 'USCG_HELI_STOCK', 'uscg', '[30,30,30,29,30,30]'),
206 (6, 'DMV_VEHICLE_STOCK', 'dmv', '[30,30,30]'),
207 (7, 'FAA_VEHICLE_STOCK', 'faa', '[30,30,30,30,30]'),
208 (8, 'DOJ_VEHICLE_STOCK', 'doj', '[30,30]');
209
210CREATE TABLE IF NOT EXISTS `referal_system` (
211 `id` int(11) NOT NULL AUTO_INCREMENT,
212 `token` varchar(50) DEFAULT NULL,
213 `reward` text,
214 `limit` int(11) DEFAULT '0',
215 `count` int(11) DEFAULT '0',
216 `uid` varchar(50) DEFAULT NULL,
217 `rewardCreator` int(11) DEFAULT '0',
218 PRIMARY KEY (`id`),
219 UNIQUE KEY `token` (`token`)
220) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
221
222INSERT INTO `persistent_vars` (`var`, `value`, `pv`) VALUES
223 ('FACTION_JOBS_LIST', '[`police`, `uscg`, `fifr`,`dmv`,`doj`,`faa`]', 1),
224 ('REFERAL_DEFAULT_REWARDS', '[[`money`, `empty`, 50], [`money`, `empty`, 500], [`money`, `empty`, 5000], [`money`, `empty`, 50000]]', 1),
225 ('REFERAL_DEFAULT_REWARD_WEIGHTS', '[1, 0.6, 0.3, 0.1]', 1);
226
227
228
229
230DROP TABLE IF EXISTS `objects`;
231CREATE TABLE `objects` (
232 `id` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
233 `type` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'object',
234 `class` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
235 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
236 `plystorage` tinyint(1) NOT NULL DEFAULT 0,
237 `spawn` tinyint(1) NOT NULL DEFAULT 0,
238 `pos` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]',
239 `vars` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[]',
240 `impounded` tinyint(1) NOT NULL DEFAULT 0,
241 `fuel` float NOT NULL DEFAULT 1,
242 `color` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '#(argb,8,8,3)color(1,1,1,1.0,co)',
243 UNIQUE INDEX `id`(`id`) USING BTREE
244) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;