diff options
Diffstat (limited to 'crates/atuin-server-postgres/migrations/20210425153757_create_users.sql')
| -rw-r--r-- | crates/atuin-server-postgres/migrations/20210425153757_create_users.sql | 10 |
1 files changed, 0 insertions, 10 deletions
diff --git a/crates/atuin-server-postgres/migrations/20210425153757_create_users.sql b/crates/atuin-server-postgres/migrations/20210425153757_create_users.sql deleted file mode 100644 index a25dcced..00000000 --- a/crates/atuin-server-postgres/migrations/20210425153757_create_users.sql +++ /dev/null @@ -1,10 +0,0 @@ -create table users ( - id bigserial primary key, -- also store our own ID - username varchar(32) not null unique, -- being able to contact users is useful - email varchar(128) not null unique, -- being able to contact users is useful - password varchar(128) not null unique -); - --- 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)); |