Query

mealie.db — users

SQL

CREATE TABLE "users"  (
  created_at DATETIME,
  update_at DATETIME,
  id CHAR(32) NOT NULL,
  full_name VARCHAR,
  username VARCHAR,
  email VARCHAR,
  password VARCHAR,
  admin BOOLEAN,
  advanced BOOLEAN,
  group_id CHAR(32) NOT NULL,
  cache_key VARCHAR,
  can_manage BOOLEAN,
  can_invite BOOLEAN,
  can_organize BOOLEAN,
  owned_recipes_id CHAR(32),
  login_attemps INTEGER,
  locked_at DATETIME,
  auth_method VARCHAR(6) DEFAULT 'MEALIE' NOT NULL,
  household_id CHAR(32),
  can_manage_household BOOLEAN,
  PRIMARY KEY (id),
  CONSTRAINT fk_users_household_id FOREIGN KEY(household_id) REFERENCES households (id),
  FOREIGN KEY(group_id) REFERENCES groups (id),
  FOREIGN KEY(owned_recipes_id) REFERENCES recipes (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
full_name VARCHAR ✓ Rename | Drop
username VARCHAR ✓ Rename | Drop
email VARCHAR ✓ Rename | Drop
password VARCHAR ✓ Rename | Drop
admin BOOLEAN ✓ Rename | Drop
advanced BOOLEAN ✓ Rename | Drop
group_id CHAR(32) Rename | Drop
cache_key VARCHAR ✓ Rename | Drop
can_manage BOOLEAN ✓ Rename | Drop
can_invite BOOLEAN ✓ Rename | Drop
can_organize BOOLEAN ✓ Rename | Drop
owned_recipes_id CHAR(32) ✓ Rename | Drop
login_attemps INTEGER ✓ Rename | Drop
locked_at DATETIME ✓ Rename | Drop
auth_method VARCHAR(6) Rename | Drop
household_id CHAR(32) ✓ Rename | Drop
can_manage_household BOOLEAN ✓ Rename | Drop

Foreign Keys

Column Destination
owned_recipes_id recipes.id
group_id groups.id
household_id households.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
ix_users_created_at created_at SQL 
CREATE INDEX ix_users_created_at
ON users (created_at)
Drop
ix_users_email email ✓ SQL 
CREATE UNIQUE INDEX ix_users_email
ON users (email)
Drop
ix_users_full_name full_name SQL 
CREATE INDEX ix_users_full_name
ON users (full_name)
Drop
ix_users_group_id group_id SQL 
CREATE INDEX ix_users_group_id
ON users (group_id)
Drop
ix_users_household_id household_id SQL 
CREATE INDEX ix_users_household_id
ON users (household_id)
Drop
ix_users_username username ✓ SQL 
CREATE UNIQUE INDEX ix_users_username
ON users (username)
Drop
sqlite_autoindex_users_1 id ✓ SQL
-- no sql found --
 Drop