diff options
| author | Christian Grothoff <christian@grothoff.org> | 2024-05-25 23:16:56 +0200 |
|---|---|---|
| committer | Christian Grothoff <christian@grothoff.org> | 2024-05-25 23:16:56 +0200 |
| commit | 79c0c75009f9d292949382db02e3a2331d005bd8 (patch) | |
| tree | c0a7e7f2825b3752699fd36e13d4c2fcabd5a8da | |
| parent | 3b78742b50d0b5122ab81a0fcd1ff3619e25f119 (diff) | |
-fix index
| -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'; |