wD7SrteH

1USE `fivem`;
2
3CREATE TABLE IF NOT EXISTS `users` (
4	`identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
5	`license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
6	`money` int(11) DEFAULT NULL,
7	`bank` int(11) DEFAULT NULL,
8	`permission_level` int(11) DEFAULT NULL,
9	`group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
10	PRIMARY KEY (`identifier`)
11);
12
13ALTER TABLE `users`
14	ADD COLUMN `name` VARCHAR(50) NULL DEFAULT '' AFTER `money`,
15	ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
16	ADD COLUMN `job` varchar(50) NULL DEFAULT 'unemployed' AFTER `skin`,
17	ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
18	ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
19	ADD COLUMN `position` VARCHAR(36) NULL AFTER `loadout`
20;
21
22CREATE TABLE `items` (
23	`name` varchar(50) NOT NULL,
24	`label` varchar(50) NOT NULL,
25	`limit` int(11) NOT NULL DEFAULT '-1',
26	`rare` int(11) NOT NULL DEFAULT '0',
27	`can_remove` int(11) NOT NULL DEFAULT '1',
28
29	PRIMARY KEY (`name`)
30);
31
32CREATE TABLE `job_grades` (
33	`id` int(11) NOT NULL AUTO_INCREMENT,
34	`job_name` varchar(50) DEFAULT NULL,
35	`grade` int(11) NOT NULL,
36	`name` varchar(50) NOT NULL,
37	`label` varchar(50) NOT NULL,
38	`salary` int(11) NOT NULL,
39	`skin_male` longtext NOT NULL,
40	`skin_female` longtext NOT NULL,
41
42	PRIMARY KEY (`id`)
43);
44
45INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');
46
47CREATE TABLE `jobs` (
48	`name` varchar(50) NOT NULL,
49	`label` varchar(50) DEFAULT NULL,
50
51	PRIMARY KEY (`name`)
52);
53
54INSERT INTO `jobs` VALUES ('unemployed','Unemployed');
55
56CREATE TABLE `user_accounts` (
57	`id` int(11) NOT NULL AUTO_INCREMENT,
58	`identifier` varchar(22) NOT NULL,
59	`name` varchar(50) NOT NULL,
60	`money` double NOT NULL DEFAULT '0',
61
62	PRIMARY KEY (`id`)
63);
64
65CREATE TABLE `user_inventory` (
66	`id` int(11) NOT NULL AUTO_INCREMENT,
67	`identifier` varchar(22) NOT NULL,
68	`item` varchar(50) NOT NULL,
69	`count` int(11) NOT NULL,
70
71	PRIMARY KEY (`id`)
72);