5TqQ6Fp4

1/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
2/*!40101 SET NAMES utf8 */;
3/*!50503 SET NAMES utf8mb4 */;
4/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
5/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
6
7CREATE DATABASE IF NOT EXISTS `qalle` /*!40100 DEFAULT CHARACTER SET utf8 */;
8USE `qalle`;
9
10CREATE TABLE IF NOT EXISTS `addon_account` (
11  `id` int(11) NOT NULL AUTO_INCREMENT,
12  `name` varchar(255) NOT NULL,
13  `label` varchar(255) NOT NULL,
14  `shared` int(11) NOT NULL,
15  PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=utf8;
17
18CREATE TABLE IF NOT EXISTS `addon_account_data` (
19  `id` int(11) NOT NULL AUTO_INCREMENT,
20  `account_name` varchar(255) DEFAULT NULL,
21  `money` double NOT NULL,
22  `owner` varchar(255) DEFAULT NULL,
23  PRIMARY KEY (`id`)
24) ENGINE=InnoDB DEFAULT CHARSET=utf8;
25
26CREATE TABLE IF NOT EXISTS `cardealer_vehicles` (
27  `id` int(11) NOT NULL AUTO_INCREMENT,
28  `vehicle` varchar(255) NOT NULL,
29  `price` int(11) NOT NULL,
30  `state` int(1) NOT NULL,
31  PRIMARY KEY (`id`)
32) ENGINE=InnoDB DEFAULT CHARSET=utf8;
33
34CREATE TABLE IF NOT EXISTS `characters` (
35  `id` varchar(50) NOT NULL DEFAULT '1337',
36  `identifier` varchar(50) NOT NULL DEFAULT 'steam:undefined',
37  `firstname` varchar(50) NOT NULL,
38  `lastname` varchar(50) NOT NULL,
39  `dateofbirth` varchar(20) NOT NULL DEFAULT '0000-00-00',
40  `lastdigits` int(4) NOT NULL DEFAULT '0',
41  `phonenumber` char(50) NOT NULL DEFAULT '0',
42  `cash` bigint(20) NOT NULL DEFAULT '0',
43  `bank` bigint(20) NOT NULL DEFAULT '0',
44  `dirty` bigint(20) NOT NULL DEFAULT '0',
45  `inventory` longtext NOT NULL,
46  `health` int(11) NOT NULL DEFAULT '100',
47  `armor` int(11) NOT NULL DEFAULT '0',
48  `job` varchar(50) NOT NULL DEFAULT 'unemployed',
49  `job_grade` varchar(50) NOT NULL DEFAULT '0',
50  `status` longtext NOT NULL,
51  `appearance` longtext NOT NULL,
52  `position` longtext NOT NULL,
53  `tattoos` longtext NOT NULL,
54  `created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
55  `lastUpdated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
56  PRIMARY KEY (`id`)
57) ENGINE=InnoDB DEFAULT CHARSET=latin1;
58
59CREATE TABLE IF NOT EXISTS `characters_animations` (
60  `cid` varchar(50) NOT NULL,
61  `anims` longtext NOT NULL
62) ENGINE=InnoDB DEFAULT CHARSET=utf8;
63
64CREATE TABLE IF NOT EXISTS `characters_creditcards` (
65  `cid` varchar(50) NOT NULL,
66  `creditNumber` int(25) NOT NULL DEFAULT '1337420911',
67  `creditCode` int(4) NOT NULL
68) ENGINE=InnoDB DEFAULT CHARSET=utf8;
69
70CREATE TABLE IF NOT EXISTS `characters_furnishings` (
71  `apartment` varchar(50) NOT NULL,
72  `furnishings` longtext NOT NULL,
73  PRIMARY KEY (`apartment`)
74) ENGINE=InnoDB DEFAULT CHARSET=utf8;
75
76CREATE TABLE IF NOT EXISTS `characters_invoices` (
77  `invoiceId` int(11) NOT NULL AUTO_INCREMENT,
78  `cid` varchar(50) NOT NULL,
79  `invoiceSender` varchar(50) NOT NULL,
80  `invoiceType` varchar(50) NOT NULL,
81  `invoiceAmount` int(50) NOT NULL DEFAULT '0',
82  `invoiceText` varchar(500) NOT NULL,
83  `invoiceCreated` varchar(255) NOT NULL,
84  PRIMARY KEY (`invoiceId`)
85) ENGINE=InnoDB DEFAULT CHARSET=utf8;
86
87CREATE TABLE IF NOT EXISTS `characters_jail` (
88  `characterId` int(11) NOT NULL,
89  `jailTime` int(11) NOT NULL DEFAULT '1',
90  `jailReason` varchar(50) NOT NULL DEFAULT 'Fängslad'
91) ENGINE=InnoDB DEFAULT CHARSET=utf8;
92
93CREATE TABLE IF NOT EXISTS `characters_keys` (
94  `id` int(11) NOT NULL AUTO_INCREMENT,
95  `identifier` varchar(50) NOT NULL,
96  `keyName` varchar(50) NOT NULL,
97  `keyUnit` varchar(50) NOT NULL,
98  PRIMARY KEY (`id`)
99) ENGINE=InnoDB DEFAULT CHARSET=latin1;
100
101CREATE TABLE IF NOT EXISTS `characters_licenses` (
102  `characterId` varchar(50) NOT NULL,
103  `licenseName` longtext NOT NULL
104) ENGINE=InnoDB DEFAULT CHARSET=utf8;
105
106CREATE TABLE IF NOT EXISTS `characters_messages` (
107  `messageHolder` varchar(50) NOT NULL,
108  `messageSender` varchar(50) NOT NULL,
109  `messageData` longtext NOT NULL
110) ENGINE=InnoDB DEFAULT CHARSET=utf8;
111
112CREATE TABLE IF NOT EXISTS `characters_motels` (
113  `characterId` varchar(50) NOT NULL,
114  `motelNumber` int(100) NOT NULL,
115  `motelOwnerName` varchar(50) NOT NULL,
116  PRIMARY KEY (`characterId`)
117) ENGINE=InnoDB DEFAULT CHARSET=utf8;
118
119CREATE TABLE IF NOT EXISTS `characters_plants` (
120  `plantId` int(11) NOT NULL,
121  `plantLevel` int(11) NOT NULL DEFAULT '1',
122  `plantWaterLeft` int(11) NOT NULL DEFAULT '1',
123  `plantTime` int(11) NOT NULL DEFAULT '30',
124  `plantCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
125  `plantEdited` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
126  PRIMARY KEY (`plantId`)
127) ENGINE=InnoDB DEFAULT CHARSET=utf8;
128
129CREATE TABLE IF NOT EXISTS `characters_properties` (
130  `propertyName` varchar(50) NOT NULL,
131  `propertyData` longtext NOT NULL,
132  `propertyCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
133  PRIMARY KEY (`propertyName`)
134) ENGINE=InnoDB DEFAULT CHARSET=utf8;
135
136CREATE TABLE IF NOT EXISTS `characters_shops` (
137  `cidOwner` varchar(50) NOT NULL,
138  `shopName` varchar(50) NOT NULL,
139  `shopLabel` varchar(50) NOT NULL,
140  `shopStock` longtext NOT NULL,
141  `shopVault` int(50) NOT NULL DEFAULT '0',
142  PRIMARY KEY (`shopName`)
143) ENGINE=InnoDB DEFAULT CHARSET=utf8;
144
145CREATE TABLE IF NOT EXISTS `characters_skills` (
146  `cid` varchar(50) NOT NULL,
147  `skills` longtext NOT NULL,
148  PRIMARY KEY (`cid`)
149) ENGINE=InnoDB DEFAULT CHARSET=utf8;
150
151CREATE TABLE IF NOT EXISTS `characters_storages` (
152  `storageName` varchar(50) NOT NULL,
153  `storageItems` longtext NOT NULL,
154  PRIMARY KEY (`storageName`)
155) ENGINE=InnoDB DEFAULT CHARSET=utf8;
156
157CREATE TABLE IF NOT EXISTS `characters_vehicles` (
158  `plate` varchar(12) COLLATE utf8mb4_bin NOT NULL,
159  `vehicle` longtext COLLATE utf8mb4_bin NOT NULL,
160  `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
161  `currentGarage` varchar(50) COLLATE utf8mb4_bin NOT NULL DEFAULT 'A',
162  `impoundedTime` longtext COLLATE utf8mb4_bin NOT NULL,
163  PRIMARY KEY (`plate`)
164) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
165
166CREATE TABLE IF NOT EXISTS `characters_vehicles_sale` (
167  `characterId` varchar(50) NOT NULL,
168  `vehicleProps` longtext NOT NULL,
169  `price` int(11) NOT NULL DEFAULT '0'
170) ENGINE=InnoDB DEFAULT CHARSET=utf8;
171
172CREATE TABLE IF NOT EXISTS `datastore` (
173  `id` int(11) NOT NULL AUTO_INCREMENT,
174  `name` varchar(255) NOT NULL,
175  `label` varchar(255) NOT NULL,
176  `shared` int(11) NOT NULL,
177  PRIMARY KEY (`id`)
178) ENGINE=InnoDB DEFAULT CHARSET=utf8;
179
180CREATE TABLE IF NOT EXISTS `datastore_data` (
181  `id` int(11) NOT NULL AUTO_INCREMENT,
182  `name` varchar(255) NOT NULL,
183  `owner` varchar(50) DEFAULT NULL,
184  `data` longtext,
185  PRIMARY KEY (`id`)
186) ENGINE=InnoDB DEFAULT CHARSET=utf8;
187
188CREATE TABLE IF NOT EXISTS `fine_types` (
189  `id` int(11) NOT NULL AUTO_INCREMENT,
190  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
191  `amount` int(11) DEFAULT NULL,
192  `category` int(11) DEFAULT NULL,
193  PRIMARY KEY (`id`)
194) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
195
196CREATE TABLE IF NOT EXISTS `jobs` (
197  `id` int(11) NOT NULL AUTO_INCREMENT,
198  `name` varchar(255) NOT NULL,
199  `label` varchar(255) DEFAULT NULL,
200  `whitelisted` tinyint(1) NOT NULL DEFAULT '0',
201  PRIMARY KEY (`id`)
202) ENGINE=InnoDB DEFAULT CHARSET=utf8;
203
204CREATE TABLE IF NOT EXISTS `job_grades` (
205  `id` int(11) NOT NULL AUTO_INCREMENT,
206  `job_name` varchar(255) DEFAULT NULL,
207  `grade` int(11) NOT NULL,
208  `name` varchar(255) NOT NULL,
209  `label` varchar(255) NOT NULL,
210  `salary` int(11) NOT NULL,
211  `skin_male` longtext NOT NULL,
212  `skin_female` longtext NOT NULL,
213  PRIMARY KEY (`id`)
214) ENGINE=InnoDB DEFAULT CHARSET=utf8;
215
216CREATE TABLE IF NOT EXISTS `jsfour_criminalrecord` (
217  `offense` varchar(160) NOT NULL,
218  `date` varchar(255) DEFAULT NULL,
219  `institution` varchar(255) DEFAULT NULL,
220  `charge` varchar(255) DEFAULT NULL,
221  `description` mediumtext,
222  `term` varchar(255) DEFAULT NULL,
223  `classified` int(2) NOT NULL DEFAULT '0',
224  `identifier` varchar(255) DEFAULT NULL,
225  `dob` varchar(255) DEFAULT NULL,
226  `warden` varchar(255) DEFAULT NULL,
227  PRIMARY KEY (`offense`)
228) ENGINE=InnoDB DEFAULT CHARSET=utf8;
229
230CREATE TABLE IF NOT EXISTS `jsfour_criminaluserinfo` (
231  `identifier` varchar(160) NOT NULL,
232  `aliases` varchar(255) DEFAULT NULL,
233  `recordid` varchar(255) DEFAULT NULL,
234  `weight` varchar(255) DEFAULT NULL,
235  `eyecolor` varchar(255) DEFAULT NULL,
236  `haircolor` varchar(255) DEFAULT NULL,
237  `firstname` varchar(255) DEFAULT NULL,
238  `lastname` varchar(255) DEFAULT NULL,
239  `dob` varchar(255) DEFAULT NULL,
240  `sex` varchar(255) DEFAULT NULL,
241  `height` varchar(255) DEFAULT NULL,
242  PRIMARY KEY (`identifier`)
243) ENGINE=InnoDB DEFAULT CHARSET=utf8;
244
245CREATE TABLE IF NOT EXISTS `jsfour_dna` (
246  `pk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
247  `killer` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
248  `dead` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
249  `weapon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
250  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT 'murder',
251  `lastdigits` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
252  `uploader` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
253  `datum` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL
254) ENGINE=InnoDB DEFAULT CHARSET=utf8;
255
256CREATE TABLE IF NOT EXISTS `owned_properties` (
257  `id` int(11) NOT NULL AUTO_INCREMENT,
258  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
259  `price` double NOT NULL,
260  `rented` int(11) NOT NULL,
261  `owner` varchar(60) COLLATE utf8mb4_bin NOT NULL,
262  PRIMARY KEY (`id`)
263) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
264
265CREATE TABLE IF NOT EXISTS `phone_blocked` (
266  `id` int(11) NOT NULL AUTO_INCREMENT,
267  `identifier` varchar(50) NOT NULL,
268  `number` int(11) NOT NULL,
269  PRIMARY KEY (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=utf8;
271
272CREATE TABLE IF NOT EXISTS `phone_favorites` (
273  `id` int(11) NOT NULL AUTO_INCREMENT,
274  `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
275  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
276  `number` varchar(50) COLLATE utf8mb4_bin NOT NULL,
277  `time` bigint(20) NOT NULL DEFAULT '0',
278  PRIMARY KEY (`id`)
279) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
280
281CREATE TABLE IF NOT EXISTS `phone_images` (
282  `cid` varchar(50) NOT NULL,
283  `photos` longtext NOT NULL,
284  PRIMARY KEY (`cid`)
285) ENGINE=InnoDB DEFAULT CHARSET=utf8;
286
287CREATE TABLE IF NOT EXISTS `phone_latest` (
288  `id` int(11) NOT NULL AUTO_INCREMENT,
289  `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
290  `name` varchar(50) COLLATE utf8mb4_bin NOT NULL,
291  `number` varchar(50) COLLATE utf8mb4_bin NOT NULL,
292  `incoming` tinyint(1) NOT NULL DEFAULT '1',
293  `missed` tinyint(1) NOT NULL DEFAULT '0',
294  `time` bigint(20) NOT NULL DEFAULT '0',
295  PRIMARY KEY (`id`)
296) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
297
298CREATE TABLE IF NOT EXISTS `phone_settings` (
299  `id` int(11) NOT NULL AUTO_INCREMENT,
300  `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
301  `settings` text COLLATE utf8mb4_bin NOT NULL,
302  PRIMARY KEY (`id`),
303  UNIQUE KEY `identifier` (`identifier`)
304) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
305
306CREATE TABLE IF NOT EXISTS `properties` (
307  `id` int(11) NOT NULL AUTO_INCREMENT,
308  `name` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
309  `label` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL,
310  `price` int(11) NOT NULL,
311  PRIMARY KEY (`id`)
312) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
313
314CREATE TABLE IF NOT EXISTS `queuesystem` (
315  `id` int(11) NOT NULL AUTO_INCREMENT,
316  `user` varchar(255) NOT NULL,
317  `ip` varchar(255) NOT NULL,
318  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
319  PRIMARY KEY (`id`)
320) ENGINE=InnoDB DEFAULT CHARSET=utf8;
321
322CREATE TABLE IF NOT EXISTS `storageunits` (
323  `storageUnit` int(11) NOT NULL,
324  `storageItems` longtext NOT NULL,
325  `storageOwner` varchar(50) NOT NULL
326) ENGINE=InnoDB DEFAULT CHARSET=utf8;
327
328CREATE TABLE IF NOT EXISTS `twitter_posts` (
329  `id` int(11) NOT NULL AUTO_INCREMENT,
330  `sender` varchar(50) COLLATE utf8mb4_bin NOT NULL,
331  `at` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
332  `message` varchar(250) COLLATE utf8mb4_bin NOT NULL,
333  `img` varchar(50) COLLATE utf8mb4_bin NOT NULL,
334  `time` bigint(20) NOT NULL,
335  `verified` bigint(20) NOT NULL,
336  PRIMARY KEY (`id`)
337) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
338
339CREATE TABLE IF NOT EXISTS `twitter_users` (
340  `id` int(11) NOT NULL AUTO_INCREMENT,
341  `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
342  `name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
343  `img` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
344  `verified` tinyint(1) NOT NULL DEFAULT '0',
345  `time` bigint(20) NOT NULL,
346  PRIMARY KEY (`id`)
347) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPACT;
348
349CREATE TABLE IF NOT EXISTS `users` (
350  `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
351  `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
352  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
353  `permission_level` int(11) DEFAULT NULL,
354  `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
355) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
356
357CREATE TABLE IF NOT EXISTS `user_contacts` (
358  `id` int(11) NOT NULL AUTO_INCREMENT,
359  `characterId` varchar(50) COLLATE utf8mb4_bin NOT NULL,
360  `name` varchar(255) COLLATE utf8mb4_bin NOT NULL,
361  `number` char(50) COLLATE utf8mb4_bin NOT NULL,
362  PRIMARY KEY (`id`)
363) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
364
365CREATE TABLE IF NOT EXISTS `user_quests` (
366  `id` int(11) NOT NULL AUTO_INCREMENT,
367  `characterId` varchar(50) NOT NULL,
368  `quests` longtext NOT NULL,
369  PRIMARY KEY (`id`)
370) ENGINE=InnoDB DEFAULT CHARSET=utf8;
371
372CREATE TABLE IF NOT EXISTS `user_races` (
373  `name` varchar(50) NOT NULL,
374  `time` double NOT NULL,
375  `race` varchar(50) NOT NULL
376) ENGINE=InnoDB DEFAULT CHARSET=utf8;
377
378CREATE TABLE IF NOT EXISTS `user_whitelist` (
379  `identifier` varchar(255) NOT NULL,
380  PRIMARY KEY (`identifier`)
381) ENGINE=InnoDB DEFAULT CHARSET=utf8;
382
383CREATE TABLE IF NOT EXISTS `vehicles` (
384  `id` int(11) NOT NULL AUTO_INCREMENT,
385  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
386  `model` varchar(60) COLLATE utf8mb4_bin NOT NULL,
387  `price` int(11) NOT NULL,
388  `category` varchar(60) COLLATE utf8mb4_bin DEFAULT NULL,
389  PRIMARY KEY (`id`)
390) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
391
392CREATE TABLE IF NOT EXISTS `vehicle_categories` (
393  `id` int(11) NOT NULL AUTO_INCREMENT,
394  `name` varchar(60) COLLATE utf8mb4_bin NOT NULL,
395  `label` varchar(60) COLLATE utf8mb4_bin NOT NULL,
396  PRIMARY KEY (`id`)
397) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
398
399CREATE TABLE IF NOT EXISTS `world_furnishings` (
400  `motelId` bigint(20) NOT NULL DEFAULT '0',
401  `furnishingData` longtext,
402  `ownedFurnishingData` longtext,
403  PRIMARY KEY (`motelId`)
404) ENGINE=InnoDB DEFAULT CHARSET=latin1;
405
406CREATE TABLE IF NOT EXISTS `world_journals` (
407  `journalJob` varchar(50) NOT NULL DEFAULT 'police',
408  `journalData` longtext NOT NULL,
409  PRIMARY KEY (`journalJob`)
410) ENGINE=InnoDB DEFAULT CHARSET=utf8;
411
412CREATE TABLE IF NOT EXISTS `world_keys` (
413  `uuid` bigint(20) NOT NULL DEFAULT '0',
414  `owner` varchar(50) NOT NULL,
415  `keyData` longtext NOT NULL,
416  PRIMARY KEY (`uuid`)
417) ENGINE=InnoDB DEFAULT CHARSET=latin1;
418
419CREATE TABLE IF NOT EXISTS `world_motels` (
420  `userIdentifier` varchar(50) NOT NULL,
421  `motelData` longtext NOT NULL,
422  `motelCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
423) ENGINE=InnoDB DEFAULT CHARSET=latin1;
424
425CREATE TABLE IF NOT EXISTS `world_notes` (
426  `noteTitle` varchar(50) NOT NULL,
427  `noteText` varchar(255) NOT NULL,
428  `noteCoords` varchar(255) NOT NULL
429) ENGINE=InnoDB DEFAULT CHARSET=utf8;
430
431CREATE TABLE IF NOT EXISTS `world_police_lockers` (
432  `lockerOwner` varchar(50) NOT NULL,
433  `lockerDisplay` varchar(150) NOT NULL,
434  `lockerCreator` varchar(50) NOT NULL,
435  `lockerCreated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
436  PRIMARY KEY (`lockerOwner`)
437) ENGINE=InnoDB DEFAULT CHARSET=utf8;
438
439CREATE TABLE IF NOT EXISTS `world_storages` (
440  `storageId` varchar(255) NOT NULL,
441  `storageData` longtext NOT NULL,
442  PRIMARY KEY (`storageId`)
443) ENGINE=InnoDB DEFAULT CHARSET=latin1;
444
445CREATE TABLE IF NOT EXISTS `world_storage_logs` (
446  `storageName` varchar(50) NOT NULL,
447  `characterName` varchar(50) NOT NULL,
448  `itemLabel` varchar(50) NOT NULL,
449  `itemCount` int(25) NOT NULL,
450  `type` varchar(50) NOT NULL,
451  `date` varchar(255) NOT NULL
452) ENGINE=InnoDB DEFAULT CHARSET=utf8;
453
454/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
455/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
456/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;