Query

mealie.db — invite_tokens

SQL

CREATE TABLE "invite_tokens"  (
  id INTEGER NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  token VARCHAR NOT NULL,
  uses_left INTEGER NOT NULL,
  group_id CHAR(32),
  household_id CHAR(32),
  PRIMARY KEY (id),
  CONSTRAINT fk_invite_tokens_household_id FOREIGN KEY(household_id) REFERENCES households (id),
  FOREIGN KEY(group_id) REFERENCES groups (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
created_at DATETIME ✓ Rename | Drop
update_at DATETIME ✓ Rename | Drop
token VARCHAR Rename | Drop
uses_left INTEGER Rename | Drop
group_id CHAR(32) ✓ Rename | Drop
household_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
group_id groups.id
household_id households.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_invite_tokens_created_at created_at SQL 
CREATE INDEX ix_invite_tokens_created_at
ON invite_tokens (created_at)
Drop
ix_invite_tokens_group_id group_id SQL 
CREATE INDEX ix_invite_tokens_group_id
ON invite_tokens (group_id)
Drop
ix_invite_tokens_household_id household_id SQL 
CREATE INDEX ix_invite_tokens_household_id
ON invite_tokens (household_id)
Drop
ix_invite_tokens_token token ✓ SQL 
CREATE UNIQUE INDEX ix_invite_tokens_token
ON invite_tokens (token)
Drop