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)
)