Query

mealie.db — group_data_exports

SQL

CREATE TABLE group_data_exports  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  group_id CHAR(32),
  name VARCHAR NOT NULL,
  filename VARCHAR NOT NULL,
  path VARCHAR NOT NULL,
  size VARCHAR NOT NULL,
  expires VARCHAR NOT NULL,
  PRIMARY KEY (id),
  FOREIGN KEY(group_id) REFERENCES groups (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
group_id CHAR(32) ✓ Rename | Drop
name VARCHAR Rename | Drop
filename VARCHAR Rename | Drop
path VARCHAR Rename | Drop
size VARCHAR Rename | Drop
expires VARCHAR Rename | Drop

Foreign Keys

Column Destination
group_id groups.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_group_data_exports_created_at created_at SQL 
CREATE INDEX ix_group_data_exports_created_at
ON group_data_exports (created_at)
Drop
ix_group_data_exports_group_id group_id SQL 
CREATE INDEX ix_group_data_exports_group_id
ON group_data_exports (group_id)
Drop
sqlite_autoindex_group_data_exports_1 id ✓ SQL
-- no sql found --
 Drop