Query

mealie.db — group_to_categories

SQL

CREATE TABLE "group_to_categories"  (
  group_id CHAR(32),
  category_id CHAR(32),
  CONSTRAINT group_id_category_id_key UNIQUE (group_id, category_id),
  FOREIGN KEY(category_id) REFERENCES categories (id),
  FOREIGN KEY(group_id) REFERENCES groups (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
group_id CHAR(32) ✓ Rename | Drop
category_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
group_id groups.id
category_id categories.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_group_to_categories_category_id category_id SQL 
CREATE INDEX ix_group_to_categories_category_id
ON group_to_categories (category_id)
Drop
ix_group_to_categories_group_id group_id SQL 
CREATE INDEX ix_group_to_categories_group_id
ON group_to_categories (group_id)
Drop
sqlite_autoindex_group_to_categories_1
  • group_id
  • category_id
 ✓ SQL
-- no sql found --
 Drop