diff options
| -rw-r--r-- | src/backenddb/merchant-0006.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backenddb/merchant-0006.sql b/src/backenddb/merchant-0006.sql index d68927c0..2b24e526 100644 --- 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'; |