Query

mealie.db — server_tasks

SQL

CREATE TABLE server_tasks  (
  id INTEGER NOT NULL,
  created_at DATETIME,
  update_at DATETIME,
  name VARCHAR NOT NULL,
  completed_date DATETIME,
  status VARCHAR NOT NULL,
  log VARCHAR,
  group_id CHAR(32) NOT NULL,
  PRIMARY KEY (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
name VARCHAR Rename | Drop
completed_date DATETIME ✓ Rename | Drop
status VARCHAR Rename | Drop
log VARCHAR ✓ Rename | Drop
group_id CHAR(32) Rename | Drop

Foreign Keys

Column Destination
group_id groups.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_server_tasks_created_at created_at SQL 
CREATE INDEX ix_server_tasks_created_at
ON server_tasks (created_at)
Drop
ix_server_tasks_group_id group_id SQL 
CREATE INDEX ix_server_tasks_group_id
ON server_tasks (group_id)
Drop