Query

mealie.db — shopping_lists_multi_...

SQL

CREATE TABLE "shopping_lists_multi_purpose_labels"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  shopping_list_id CHAR(32) NOT NULL,
  label_id CHAR(32) NOT NULL,
  position INTEGER NOT NULL,
  PRIMARY KEY (id, shopping_list_id, label_id),
  CONSTRAINT shopping_list_id_label_id_key UNIQUE (shopping_list_id, label_id),
  FOREIGN KEY(shopping_list_id) REFERENCES shopping_lists (id),
  FOREIGN KEY(label_id) REFERENCES multi_purpose_labels (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
id CHAR(32) ✓ Rename | Drop
shopping_list_id CHAR(32) ✓ Rename | Drop
label_id CHAR(32) ✓ Rename | Drop
position INTEGER Rename | Drop

Foreign Keys

Column Destination
label_id multi_purpose_labels.id
shopping_list_id shopping_lists.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_shopping_lists_multi_purpose_labels_created_at created_at SQL 
CREATE INDEX ix_shopping_lists_multi_purpose_labels_created_at
ON shopping_lists_multi_purpose_labels (created_at)
Drop
sqlite_autoindex_shopping_lists_multi_purpose_labels_1
  • id
  • shopping_list_id
  • label_id
 ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_shopping_lists_multi_purpose_labels_2
  • shopping_list_id
  • label_id
 ✓ SQL
-- no sql found --
 Drop