diff options
Diffstat (limited to 'crates/turtle/db/server-sqlite-migrations/20240621110730_create-users.sql')
| -rw-r--r-- | crates/turtle/db/server-sqlite-migrations/20240621110730_create-users.sql | 12 |
1 files changed, 0 insertions, 12 deletions
diff --git a/crates/turtle/db/server-sqlite-migrations/20240621110730_create-users.sql b/crates/turtle/db/server-sqlite-migrations/20240621110730_create-users.sql deleted file mode 100644 index 852c159d..00000000 --- a/crates/turtle/db/server-sqlite-migrations/20240621110730_create-users.sql +++ /dev/null @@ -1,12 +0,0 @@ -create table users ( - id integer primary key autoincrement, -- also store our own ID - username text not null unique, -- being able to contact users is useful - email text not null unique, -- being able to contact users is useful - password text not null unique, - created_at timestamp not null default (datetime('now','localtime')), - verified_at timestamp with time zone default null -); - --- the prior index is case sensitive :( -CREATE UNIQUE INDEX email_unique_idx on users (LOWER(email)); -CREATE UNIQUE INDEX username_unique_idx on users (LOWER(username)); |
