merchant

commit 79c0c75009f9d292949382db02e3a2331d005bd8
parent 3b78742b50d0b5122ab81a0fcd1ff3619e25f119
Author: Christian Grothoff <christian@grothoff.org>
Date:   Sat, 25 May 2024 23:16:56 +0200

-fix index

Diffstat:
M
src/backenddb/merchant-0006.sql
 | 
4
++--

1 file changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/backenddb/merchant-0006.sql b/src/backenddb/merchant-0006.sql
@@ -41,9 +41,9 @@ CREATE TABLE merchant_product_categories
   ,product_serial BIGINT NOT NULL
     REFERENCES merchant_inventory (product_serial) ON DELETE CASCADE);
 CREATE INDEX merchant_categories_by_category
-  ON merchant_categories (category_serial);
+  ON merchant_product_categories (category_serial);
 CREATE INDEX merchant_categories_by_product
-  ON merchant_categories (product_serial);
+  ON merchant_product_categories (product_serial);
 
 COMMENT ON COLUMN merchant_product_categories.category_serial
   IS 'Reference to a category the product is part of';