Query

mealie.db — report_entries

SQL

CREATE TABLE report_entries  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  success BOOLEAN,
  message VARCHAR,
  exception VARCHAR,
  timestamp DATETIME NOT NULL,
  report_id CHAR(32) NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY(report_id) REFERENCES group_reports (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
success BOOLEAN ✓ Rename | Drop
message VARCHAR ✓ Rename | Drop
exception VARCHAR ✓ Rename | Drop
timestamp DATETIME Rename | Drop
report_id CHAR(32) Rename | Drop

Foreign Keys

Column Destination
report_id group_reports.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_report_entries_created_at created_at SQL 
CREATE INDEX ix_report_entries_created_at
ON report_entries (created_at)
Drop
ix_report_entries_report_id report_id SQL 
CREATE INDEX ix_report_entries_report_id
ON report_entries (report_id)
Drop
sqlite_autoindex_report_entries_1 id ✓ SQL
-- no sql found --
 Drop