Subversion Repositories SmartDukaan

-- HR-UK is not needed (2026-10-01): remove internal store HRGN1715 "New Spice Solutions Pvt. Ltd. Haryana-HR-UK"

-- (175140566, on 7720, GSTIN 06AACCN9802G2ZI). No transactions, no wallet rows, empty cart.

-- Backups already taken: fofo._bak_hrgn1715_{store,payopt,ptc,pincode}_20261001,

-- dtr._bak_hrgn1715_{retailer,regaddr,shop,shopaddr}_20261001, user._bak_hrgn1715_{user,address,cart}_20261001.

-- dtr.document 100467 (GST - Haryna New.pdf) / 100468 (Company Pan.jpg) are kept on purpose.

START TRANSACTION;

DELETE FROM fofo.fofo_partner_payment_option WHERE fofo_id = 175140566;

DELETE FROM fofo.partner_type_change WHERE id = 94760 AND fofo_id = 175140566;

DELETE FROM fofo.pincode_partner WHERE id = 6792 AND fofo_id = 175140566;

DELETE FROM fofo.fofo_store WHERE id = 175140566 AND code = 'HRGN1715';

DELETE FROM dtr.shop_address WHERE shop_id = 7032;

DELETE FROM dtr.shop WHERE id = 7032 AND retailer_id = 175140566;

DELETE FROM dtr.retailer_registered_address WHERE retailer_id = 175140566 AND address_id = 656846;

DELETE FROM dtr.retailer WHERE id = 175140566;

-- user.user.active_cart_id -> user.cart (FK): the user goes before its cart

DELETE FROM user.user WHERE id = 175140566;

DELETE FROM user.cart WHERE id = 175181447;

DELETE FROM user.address WHERE id = 656846 AND user_id = 175140566;

COMMIT;

SELECT 'fofo_store', COUNT(*) FROM fofo.fofo_store WHERE id = 175140566

UNION ALL SELECT 'user', COUNT(*) FROM user.user WHERE id = 175140566

UNION ALL SELECT 'retailer', COUNT(*) FROM dtr.retailer WHERE id = 175140566

UNION ALL SELECT 'shop', COUNT(*) FROM dtr.shop WHERE id = 7032

UNION ALL SELECT 'cart', COUNT(*) FROM user.cart WHERE id = 175181447;