Query

mealie.db — groups

SQL

CREATE TABLE groups  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  name VARCHAR NOT NULL,
  slug VARCHAR,
  PRIMARY KEY (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
name VARCHAR Rename | Drop
slug VARCHAR ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_groups_created_at created_at SQL 
CREATE INDEX ix_groups_created_at
ON groups (created_at)
Drop
ix_groups_name name ✓ SQL 
CREATE UNIQUE INDEX ix_groups_name
ON groups (name)
Drop
ix_groups_slug slug ✓ SQL 
CREATE UNIQUE INDEX ix_groups_slug
ON groups (slug)
Drop
sqlite_autoindex_groups_1 id ✓ SQL
-- no sql found --
 Drop