· 8 years ago · Jul 24, 2018, 06:48 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` (
74 `id` int(6) NOT NULL AUTO_INCREMENT,
75 `var` varchar(17) NOT NULL,
76 `balance` int(10) NOT NULL,
77 PRIMARY KEY (`id`)
78) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
79
80DELETE FROM `government_balances`;
81
82INSERT INTO `government_balances` (`id`, `var`, `balance`) VALUES
83 (1, 'FEDERAL_GRANT', 100000000),
84 (2, 'PD_BUDGET', 100000000),
85 (3, 'FD_BUDGET', 100000000),
86 (4, 'CG_BUDGET', 100000000),
87 (5, 'SALES_TAX_BAL', 0),
88 (6, 'INCOME_TAX_BAL', 0),
89 (7, 'PROPERTY_TAX_BAL', 0),
90 (8, 'IMPORT_TAX_BAL', 0),
91 (9, 'INCOME_TAX', 5),
92 (10, 'PROPERTY_TAX', 10),
93 (11, 'SALES_TAX', 5),
94 (12, 'IMPORT_TAX', 5),
95 (13, 'DMV_BUDGET', 100000000),
96 (14, 'DOJ_BUDGET', 100000000),
97 (15, 'FAA_BUDGET', 100000000);
98
99CREATE TABLE IF NOT EXISTS `faction_vehicle_shop` (
100 `id` int(6) NOT NULL AUTO_INCREMENT,
101 `var` varchar(17) NOT NULL,
102 `type` varchar(10) NOT NULL,
103 `stock` varchar(35) NOT NULL,
104 PRIMARY KEY (`id`)
105) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
106
107DELETE FROM `faction_vehicle_shop`;
108
109INSERT INTO `faction_vehicle_shop` (`id`, `var`, `type`, `stock`) VALUES
110 (1, 'FIFR_VEHICLE_STOCK', 'fifr', '[80,80,30,30,30,30,30,30]'),
111 (2, 'USCG_VEHICLE_STOCK', 'uscg', '[30,30,30,30,30,30]'),
112 (3, 'POLICE_VEHICLE_STOCK', 'police', '[30,30,30,30,30,30,30,30,30,30]'),
113 (4, 'USCG_BOAT_STOCK', 'uscg', '[30,30,30,29,30,30]'),
114 (5, 'USCG_HELI_STOCK', 'uscg', '[30,30,30,29,30,30]'),
115 (6, 'DMV_VEHICLE_STOCK', 'dmv', '[30,30,30]'),
116 (7, 'FAA_VEHICLE_STOCK', 'faa', '[30,30,30,30,30]'),
117 (8, 'DOJ_VEHICLE_STOCK', 'doj', '[30,30]');
118
119CREATE TABLE IF NOT EXISTS `referal_system` (
120 `id` int(11) NOT NULL AUTO_INCREMENT,
121 `token` varchar(50) DEFAULT NULL,
122 `reward` text,
123 `limit` int(11) DEFAULT '0',
124 `count` int(11) DEFAULT '0',
125 `uid` varchar(50) DEFAULT NULL,
126 `rewardCreator` int(11) DEFAULT '0',
127 PRIMARY KEY (`id`),
128 UNIQUE KEY `token` (`token`)
129) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
130
131INSERT INTO `persistent_vars` (`var`, `value`, `pv`) VALUES
132 ('FACTION_JOBS_LIST', '[`police`, `uscg`, `fifr`,`dmv`,`doj`,`faa`]', 1),
133 ('REFERAL_DEFAULT_REWARDS', '[[`money`, `empty`, 50], [`money`, `empty`, 500], [`money`, `empty`, 5000], [`money`, `empty`, 50000]]', 1),
134 ('REFERAL_DEFAULT_REWARD_WEIGHTS', '[1, 0.6, 0.3, 0.1]', 1);