| 37853 |
amit |
1 |
-- RECORD ONLY - applied on hadb1 2026-10-05 ~17:19 IST. Do not re-run (the backup table already exists).
|
|
|
2 |
-- Brand region mapping for the 13 warehouses suspended on 2026-10-05
|
|
|
3 |
-- (7573 7720 7678 9349 9470 9513 9514 9213 10010 10516 10519 10520 10521).
|
|
|
4 |
-- Rule (user): each HR warehouse inherits its Delhi counterpart's mapping 1:1, ids swapped on BOTH sides -
|
|
|
5 |
-- 7720->13368, 7573->13370, 9514->13372; every other suspended warehouse is removed with no replacement.
|
|
|
6 |
-- Result: 1,062 rows deleted, the 51 substituted rows not already present inserted, 1,741 -> 730 rows.
|
|
|
7 |
-- Followed by 20261005_hr_ggn_central_brand_mapping.sql (13368 central, +532 rows).
|
|
|
8 |
USE inventory;
|
|
|
9 |
CREATE TABLE _bak_warehouseBrandMapping_inactive_20261005 AS SELECT * FROM warehouseBrandMapping;
|
|
|
10 |
START TRANSACTION;
|
|
|
11 |
DELETE FROM warehouseBrandMapping WHERE warehouseFrom IN (7573,7720,7678,9349,9470,9513,9514,9213,10010,10516,10519,10520,10521) OR warehouseTo IN (7573,7720,7678,9349,9470,9513,9514,9213,10010,10516,10519,10520,10521);
|
|
|
12 |
SELECT ROW_COUNT() deleted;
|
|
|
13 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('ai+',13370,13368,0);
|
|
|
14 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('ai+',13368,13370,0);
|
|
|
15 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('alcatel',13370,13368,0);
|
|
|
16 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('alcatel',13368,13370,0);
|
|
|
17 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8468,13372,1);
|
|
|
18 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8889,13372,1);
|
|
|
19 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8947,13372,1);
|
|
|
20 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hmd',13370,13368,0);
|
|
|
21 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hmd',13368,13370,0);
|
|
|
22 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hot deal',13370,13368,1);
|
|
|
23 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hot deal',13370,13372,1);
|
|
|
24 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('jio',13370,13368,0);
|
|
|
25 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('jio',13368,13370,0);
|
|
|
26 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8468,13372,1);
|
|
|
27 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8889,13372,1);
|
|
|
28 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8947,13372,1);
|
|
|
29 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13370,13368,0);
|
|
|
30 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13370,13372,0);
|
|
|
31 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13372,13370,0);
|
|
|
32 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('live demo',8468,13372,0);
|
|
|
33 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('live demo',13372,8468,0);
|
|
|
34 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('motorola',13370,13368,1);
|
|
|
35 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('motorola',13368,13370,1);
|
|
|
36 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nokia',8468,13372,0);
|
|
|
37 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,13368,0);
|
|
|
38 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8468,0);
|
|
|
39 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8889,0);
|
|
|
40 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8947,0);
|
|
|
41 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,9203,0);
|
|
|
42 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,13372,0);
|
|
|
43 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,12595,0);
|
|
|
44 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8468,13370,0);
|
|
|
45 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8889,13370,0);
|
|
|
46 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8947,13370,0);
|
|
|
47 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',9203,13370,0);
|
|
|
48 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13372,13370,0);
|
|
|
49 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('oneplus',13370,13368,0);
|
|
|
50 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('oneplus',13368,13370,0);
|
|
|
51 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('realme',13370,13372,0);
|
|
|
52 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('realme',13372,13370,0);
|
|
|
53 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13370,13368,0);
|
|
|
54 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13370,13368,1);
|
|
|
55 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13368,13370,1);
|
|
|
56 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13370,13368,0);
|
|
|
57 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13370,13372,0);
|
|
|
58 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13372,13370,0);
|
|
|
59 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8468,13372,1);
|
|
|
60 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8889,13372,1);
|
|
|
61 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8947,13372,1);
|
|
|
62 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('vivo',8468,13372,1);
|
|
|
63 |
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('xiaomi',13370,13368,0);
|
|
|
64 |
SELECT COUNT(*) total_after FROM warehouseBrandMapping;
|
|
|
65 |
COMMIT;
|