merchant

commit d9f28461130cc74809c7aaab767f8285089d78c0
parent 5d2a00bda6d5ef3a9a0443fb4376d4919470076a
Author: bohdan-potuzhnyi <bohdan.potuzhnyi@gmail.com>
Date:   Fri, 28 Nov 2025 20:03:24 +0100

fix 0010682

Diffstat:
M
src/backenddb/merchant-0026.sql
 | 
6
++++++

1 file changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/backenddb/merchant-0026.sql b/src/backenddb/merchant-0026.sql
@@ -41,6 +41,9 @@ ALTER TABLE merchant_inventory
 COMMENT ON COLUMN merchant_inventory.image_hash
   IS 'SHA-256 hash of the base64-encoded image data, used by wallets to fetch product images.';
 
+ALTER TABLE merchant_inventory
+    DISABLE TRIGGER trigger_inventory_changes;
+
 UPDATE merchant_inventory
    SET image_hash = CASE
                       WHEN (image IS NULL) OR (image = '')
@@ -54,6 +57,9 @@ UPDATE merchant_inventory
                            )
                     END;
 
+ALTER TABLE merchant_inventory
+    ENABLE TRIGGER trigger_inventory_changes;
+
 CREATE INDEX merchant_inventory_by_image_hash
   ON merchant_inventory
     (merchant_serial, image_hash);