Query

mealie.db — long_live_tokens

SQL

CREATE TABLE long_live_tokens  (
  id INTEGER NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  name VARCHAR NOT NULL,
  token VARCHAR NOT NULL,
  user_id CHAR(32),
  PRIMARY KEY (id),
  FOREIGN KEY(user_id) REFERENCES users (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
name VARCHAR Rename | Drop
token VARCHAR Rename | Drop
user_id CHAR(32) ✓ Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_long_live_tokens_created_at created_at SQL 
CREATE INDEX ix_long_live_tokens_created_at
ON long_live_tokens (created_at)
Drop
ix_long_live_tokens_token token SQL 
CREATE INDEX ix_long_live_tokens_token
ON long_live_tokens (token)
Drop
ix_long_live_tokens_user_id user_id SQL 
CREATE INDEX ix_long_live_tokens_user_id
ON long_live_tokens (user_id)
Drop