Subversion Repositories SmartDukaan

Rev

Blame | Last modification | View Log | RSS feed 

-- RECORD ONLY - applied on hadb1 2026-10-05 ~17:19 IST. Do not re-run (the backup table already exists).
-- Brand region mapping for the 13 warehouses suspended on 2026-10-05
-- (7573 7720 7678 9349 9470 9513 9514 9213 10010 10516 10519 10520 10521).
-- Rule (user): each HR warehouse inherits its Delhi counterpart's mapping 1:1, ids swapped on BOTH sides -
-- 7720->13368, 7573->13370, 9514->13372; every other suspended warehouse is removed with no replacement.
-- Result: 1,062 rows deleted, the 51 substituted rows not already present inserted, 1,741 -> 730 rows.
-- Followed by 20261005_hr_ggn_central_brand_mapping.sql (13368 central, +532 rows).
USE inventory;
CREATE TABLE _bak_warehouseBrandMapping_inactive_20261005 AS SELECT * FROM warehouseBrandMapping;
START TRANSACTION;
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);
SELECT ROW_COUNT() deleted;
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('ai+',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('ai+',13368,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('alcatel',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('alcatel',13368,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8468,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8889,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('flix',8947,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hmd',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hmd',13368,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hot deal',13370,13368,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('hot deal',13370,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('jio',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('jio',13368,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8468,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8889,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('kodak',8947,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13370,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('lava',13372,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('live demo',8468,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('live demo',13372,8468,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('motorola',13370,13368,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('motorola',13368,13370,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nokia',8468,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8468,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8889,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,8947,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,9203,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13370,12595,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8468,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8889,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',8947,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',9203,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('nothing',13372,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('oneplus',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('oneplus',13368,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('realme',13370,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('realme',13372,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13370,13368,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('samsung',13368,13370,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13370,13368,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13370,13372,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('tecno',13372,13370,0);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8468,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8889,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('treeview',8947,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('vivo',8468,13372,1);
INSERT INTO warehouseBrandMapping (brand,warehouseFrom,warehouseTo,isAccessory) VALUES ('xiaomi',13370,13368,0);
SELECT COUNT(*) total_after FROM warehouseBrandMapping;
COMMIT;