· 8 years ago · Jul 24, 2018, 02:08 PM
1CREATE TABLE IF NOT EXISTS `factions` (
2 `id` int(6) NOT NULL AUTO_INCREMENT,
3 `leader` varchar(17) NOT NULL,
4 `type` varchar(50) NOT NULL,
5 `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',
6 PRIMARY KEY (`id`)
7) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
8
9INSERT INTO `factions` (`id`, `leader`, `type`, `max_rank`) VALUES
10 (1, '211', 'POLICE', '8'),
11 (2, '38', 'USCG', '14'),
12 (3, '162', 'FIFR', '11'),
13 (4, '133', 'DOJ', '6'),
14 (5, '40', 'DMV', '3'),
15 (6, '1', 'FAA', '1');
16
17CREATE TABLE IF NOT EXISTS `faction_ranks` (
18 `id` int(6) NOT NULL AUTO_INCREMENT,
19 `fid` int(6) NOT NULL,
20 `name` varchar(50) NOT NULL,
21 `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',
22 `paycheck` int(100) NOT NULL DEFAULT '1000',
23 PRIMARY KEY (`id`)
24) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4;
25
26INSERT INTO `faction_ranks` (`id`, `fid`, `name`, `level`, `paycheck`) VALUES
27 (1, 2, 'Seaman Recruit', '1', 1000),
28 (2, 2, 'Seaman Apprentice', '2', 1000),
29 (3, 2, 'Seaman', '3', 1000),
30 (4, 2, 'Petty Officer', '4', 1000),
31 (5, 2, 'Chief Petty Officer', '5', 1000),
32 (6, 2, 'Senior Chief Petty Officer', '6', 1000),
33 (7, 2, 'Master Chief Petty Officer', '7', 1000),
34 (8, 2, 'Command Master Chief Petty Officer', '8', 1000),
35 (9, 2, 'Ensign', '9', 1000),
36 (10, 2, 'Lieutenant, Junior Grade', '10', 1000),
37 (11, 2, 'Lieutenant', '11', 1000),
38 (12, 2, 'Lieutenant Commander ', '12', 1000),
39 (13, 2, 'Commander', '13', 1000),
40 (14, 2, 'Captain', '14', 1000),
41 (15, 1, 'Cadet', '1', 1000),
42 (16, 1, 'Deputy', '2', 1000),
43 (17, 1, 'Corporal', '3', 1000),
44 (18, 1, 'Sergeant', '4', 1000),
45 (19, 1, 'Detective', '5', 1000),
46 (20, 1, 'Lieutenant', '6', 1000),
47 (21, 1, 'UnderSheriff', '7', 1000),
48 (22, 1, 'Sheriff', '8', 1000),
49 (23, 3, 'Chief', '11', 1000),
50 (24, 3, 'Deputy Chief', '10', 1000),
51 (25, 3, 'Battalion Chief', '9', 1000),
52 (26, 3, 'Captin', '8', 1000),
53 (27, 3, 'Lieutenant', '7', 1000),
54 (28, 3, 'Engineer / Paramedic', '6', 1000),
55 (29, 3, 'Firefighter / Paramedic', '5', 1000),
56 (30, 3, 'Firefighter / EMT', '4', 1000),
57 (31, 3, 'Probationary', '3', 1000),
58 (32, 3, 'Recruit', '2', 1000),
59 (33, 3, 'Volunteer', '1', 1000),
60 (34, 4, 'Chief Justice', '6', 1000),
61 (35, 4, 'Assistant Chief Justice', '5', 1000),
62 (36, 4, 'Executive Judge', '4', 1000),
63 (37, 4, 'District Attorney', '3', 1000),
64 (38, 4, 'State Prosecutor', '2', 1000),
65 (39, 4, 'Lawyer', '1', 1000),
66 (40, 5, 'Manager', '3', 1000),
67 (41, 5, 'Assistant Manager', '2', 1000),
68 (42, 5, 'Employee', '1', 1000);
69
70ALTER TABLE `players` ADD `stafftitle` VARCHAR(50) NOT NULL AFTER `adminpowers`;
71ALTER 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`;
72
73CREATE TABLE IF NOT EXISTS `government_balances` (
74DELETE FROM `government_balances`;
75
76INSERT INTO `government_balances` (`id`, `var`, `balance`) VALUES
77 (1, 'FEDERAL_GRANT', 100000000),
78 (2, 'PD_BUDGET', 100000000),
79 (3, 'FD_BUDGET', 100000000),
80 (4, 'CG_BUDGET', 100000000),
81 (5, 'SALES_TAX_BAL', 0),
82 (6, 'INCOME_TAX_BAL', 0),
83 (7, 'PROPERTY_TAX_BAL', 0),
84 (8, 'IMPORT_TAX_BAL', 0),
85 (9, 'INCOME_TAX', 5),
86 (10, 'PROPERTY_TAX', 10),
87 (11, 'SALES_TAX', 5),
88 (12, 'IMPORT_TAX', 5),
89 (13, 'DMV_BUDGET', 100000000),
90 (14, 'DOJ_BUDGET', 100000000),
91 (15, 'FAA_BUDGET', 100000000);
92
93DELETE FROM `faction_vehicle_shop`;
94
95
96INSERT INTO `faction_vehicle_shop` (`id`, `var`, `type`, `stock`) VALUES
97 (1, 'FIFR_VEHICLE_STOCK', 'fifr', '[80,80,30,30,30,30,30,30]'),
98 (2, 'USCG_VEHICLE_STOCK', 'uscg', '[30,30,30,30,30,30]'),
99 (3, 'POLICE_VEHICLE_STOCK', 'police', '[30,30,30,30,30,30,30,30,30,30]'),
100 (4, 'USCG_BOAT_STOCK', 'uscg', '[30,30,30,29,30,30]'),
101 (5, 'USCG_HELI_STOCK', 'uscg', '[30,30,30,29,30,30]'),
102 (6, 'DMV_VEHICLE_STOCK', 'dmv', '[30,30,30]'),
103 (7, 'FAA_VEHICLE_STOCK', 'faa', '[30,30,30,30,30]'),
104 (8, 'DOJ_VEHICLE_STOCK', 'doj', '[30,30]');
105
106CREATE TABLE IF NOT EXISTS `referal_system` (
107 `id` int(11) NOT NULL AUTO_INCREMENT,
108 `token` varchar(50) DEFAULT NULL,
109 `reward` text,
110 `limit` int(11) DEFAULT '0',
111 `count` int(11) DEFAULT '0',
112 `uid` varchar(50) DEFAULT NULL,
113 `rewardCreator` int(11) DEFAULT '0',
114 PRIMARY KEY (`id`),
115 UNIQUE KEY `token` (`token`)
116) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
117
118INSERT INTO `persistent_vars` (`var`, `value`, `pv`) VALUES
119 ('FACTION_JOBS_LIST', '[`police`, `uscg`, `fifr`,`dmv`,`doj`,`faa`]', 1),
120 ('REFERAL_DEFAULT_REWARDS', '[[`money`, `empty`, 50], [`money`, `empty`, 500], [`money`, `empty`, 5000], [`money`, `empty`, 50000]]', 1),
121 ('REFERAL_DEFAULT_REWARD_WEIGHTS', '[1, 0.6, 0.3, 0.1]', 1);