-
Notifications
You must be signed in to change notification settings - Fork 0
/
4-Convertion.sql
22 lines (22 loc) · 1.8 KB
/
4-Convertion.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
UPDATE players SET civ_licenses = REPLACE ( civ_licenses, '`license_civ_truck`', '`license_civ_trucking`');
UPDATE players SET aliases = REPLACE ( aliases, '`]]', '`]');
UPDATE players SET aliases = REPLACE ( aliases, '[[`', '[`');
UPDATE players SET aliases = REPLACE ( aliases, '"]]', '`]');
UPDATE players SET aliases = REPLACE ( aliases, '[["', '[`');
UPDATE houses SET inventory = REPLACE ( inventory, '`heroinu`', '`heroin_unprocessed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`heroinp`', '`heroin_processed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`cocaine`', '`cocaine_unprocessed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`cocainep`', '`cocaine_processed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`ironore`', '`iron_unrefined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`iron_r`', '`iron_refined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`salt`', '`salt_unrefined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`salt_r`', '`salt_refined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`diamond`', '`diamond_uncut`');
UPDATE houses SET inventory = REPLACE ( inventory, '`diamondc`', '`diamond_cut`');
UPDATE houses SET inventory = REPLACE ( inventory, '`oilu`', '`oil_unprocessed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`oilp`', '`oil_processed`');
UPDATE houses SET inventory = REPLACE ( inventory, '`copperore`', '`copper_unrefined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`copper_r`', '`copper_refined`');
UPDATE houses SET inventory = REPLACE ( inventory, '`fuelF`', '`fuelEmpty`');
UPDATE houses SET inventory = REPLACE ( inventory, '`fuelF`', '`fuelFull`');
UPDATE houses SET inventory = REPLACE ( inventory, '`turtle`', '`turtle_raw`');