aboutsummaryrefslogtreecommitdiffstats
path: root/crates/atuin-server-sqlite/migrations/20240621110730_create-users.sql
diff options
context:
space:
mode:
Diffstat (limited to 'crates/atuin-server-sqlite/migrations/20240621110730_create-users.sql')
-rw-r--r--crates/atuin-server-sqlite/migrations/20240621110730_create-users.sql12
1 files changed, 0 insertions, 12 deletions
diff --git a/crates/atuin-server-sqlite/migrations/20240621110730_create-users.sql b/crates/atuin-server-sqlite/migrations/20240621110730_create-users.sql
deleted file mode 100644
index 852c159d..00000000
--- a/crates/atuin-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));