· 7 years ago · Dec 03, 2018, 06:44 PM
1CREATE TABLE IF NOT EXISTS `users` (
2 `identifier` varchar(50) COLLATE utf8mb4_bin NOT NULL,
3 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
4 `money` int(11) DEFAULT NULL,
5 `bank` int(11) DEFAULT NULL,
6 `permission_level` int(11) DEFAULT NULL,
7 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
8 PRIMARY KEY (`identifier`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
10
11ALTER TABLE `users`
12 ADD COLUMN `name` VARCHAR(255) NULL DEFAULT '' AFTER `money`,
13 ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
14 ADD COLUMN `job` varchar(255) NULL DEFAULT 'unemployed' AFTER `skin`,
15 ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
16 ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
17 ADD COLUMN `position` VARCHAR(255) NULL AFTER `loadout`
18;
19
20CREATE TABLE `items` (
21 `name` varchar(50) NOT NULL,
22 `label` varchar(255) NOT NULL,
23 `limit` int(11) NOT NULL DEFAULT '-1',
24 `rare` int(11) NOT NULL DEFAULT '0',
25 `can_remove` int(11) NOT NULL DEFAULT '1',
26
27 PRIMARY KEY (`name`)
28);
29
30CREATE TABLE `job_grades` (
31 `id` int(11) NOT NULL AUTO_INCREMENT,
32 `job_name` varchar(255) DEFAULT NULL,
33 `grade` int(11) NOT NULL,
34 `name` varchar(255) NOT NULL,
35 `label` varchar(255) NOT NULL,
36 `salary` int(11) NOT NULL,
37 `skin_male` longtext NOT NULL,
38 `skin_female` longtext NOT NULL,
39
40 PRIMARY KEY (`id`)
41);
42
43INSERT INTO `job_grades` VALUES (1,'unemployed',0,'unemployed','Unemployed',200,'{}','{}');
44
45CREATE TABLE `jobs` (
46 `name` varchar(50) NOT NULL,
47 `label` varchar(255) DEFAULT NULL,
48
49 PRIMARY KEY (`name`)
50);
51
52INSERT INTO `jobs` VALUES ('unemployed','Unemployed');
53
54CREATE TABLE `user_accounts` (
55 `id` int(11) NOT NULL AUTO_INCREMENT,
56 `identifier` varchar(255) NOT NULL,
57 `name` varchar(255) NOT NULL,
58 `money` double NOT NULL DEFAULT '0',
59
60 PRIMARY KEY (`id`)
61);
62
63CREATE TABLE `user_inventory` (
64 `id` int(11) NOT NULL AUTO_INCREMENT,
65 `identifier` varchar(255) NOT NULL,
66 `item` varchar(255) NOT NULL,
67 `count` int(11) NOT NULL,
68
69 PRIMARY KEY (`id`)
70);
71
72
73CREATE TABLE `addon_account` (
74 `name` varchar(60) NOT NULL,
75 `label` varchar(255) NOT NULL,
76 `shared` int(11) NOT NULL,
77
78 PRIMARY KEY (`name`)
79);
80
81CREATE TABLE `addon_account_data` (
82 `id` int(11) NOT NULL AUTO_INCREMENT,
83 `account_name` varchar(255) DEFAULT NULL,
84 `money` double NOT NULL,
85 `owner` varchar(255) DEFAULT NULL,
86
87 PRIMARY KEY (`id`)
88);
89
90INSERT INTO `addon_account` (name, label, shared) VALUES
91 ('caution', 'Caution', 0)
92;
93
94INSERT INTO `jobs` (name, label) VALUES
95 ('slaughterer', 'Abatteur'),
96 ('fisherman', 'Pêcheur'),
97 ('miner', 'Mineur'),
98 ('lumberjack', 'Bûcheron'),
99 ('fueler', 'Raffineur'),
100 ('reporter', 'Journaliste'),
101 ('tailor', 'Couturier')
102;
103
104INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
105 ('lumberjack', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
106 ('fisherman', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
107 ('fueler', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
108 ('reporter', 0, 'employee', 'Intérimaire', 0, '{}', '{}'),
109 ('tailor',0,'employee','Intérimaire',0,'{\"mask_1\":0,\"arms\":1,\"glasses_1\":0,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":0,\"torso_1\":24,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":0,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":0,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":36,\"tshirt_2\":0,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":48,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}','{\"mask_1\":0,\"arms\":5,\"glasses_1\":5,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":1,\"torso_1\":52,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":1,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":23,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":42,\"tshirt_2\":4,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":36,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}'),
110 ('miner', 0, 'employee', 'Intérimaire', 0, '{"tshirt_2":1,"ears_1":8,"glasses_1":15,"torso_2":0,"ears_2":2,"glasses_2":3,"shoes_2":1,"pants_1":75,"shoes_1":51,"bags_1":0,"helmet_2":0,"pants_2":7,"torso_1":71,"tshirt_1":59,"arms":2,"bags_2":0,"helmet_1":0}', '{}'),
111 ('slaughterer',0,'employee','Intérimaire',0,'{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":67,\"pants_1\":36,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":0,\"torso_1\":56,\"beard_2\":6,\"shoes_1\":12,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":15,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":0,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}','{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":72,\"pants_1\":45,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":1,\"torso_1\":49,\"beard_2\":6,\"shoes_1\":24,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":9,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":5,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}')
112;
113
114INSERT INTO `items` (`name`, `label`, `limit`) VALUES
115 ('alive_chicken', 'Poulet vivant', 20),
116 ('slaughtered_chicken', 'Poulet abattu', 20),
117 ('packaged_chicken', 'Poulet en barquette', 100),
118 ('fish', 'Poisson', 100),
119 ('stone', 'Pierre', 7),
120 ('washed_stone', 'Pierre Lavée', 7),
121 ('copper', 'Cuivre', 56),
122 ('iron', 'Fer', 42),
123 ('gold', 'Or', 21),
124 ('diamond', 'Diamant', 50),
125 ('wood', 'Bois', 20),
126 ('cutted_wood', 'Bois coupé', 20),
127 ('packaged_plank', 'Paquet de planches', 100),
128 ('petrol', 'Pétrole', 24),
129 ('petrol_raffin', 'Pétrole Raffiné', 24),
130 ('essence', 'Essence', 24),
131 ('wool', 'Laine', 40),
132 ('fabric', 'Tissu', 80),
133('clothe', 'Vêtement', 40)