aboutsummaryrefslogtreecommitdiffstats
path: root/migrations/2021-03-20-171007_create_users/up.sql
diff options
context:
space:
mode:
authorEllie Huxtable <e@elm.sh>2021-04-25 18:21:52 +0100
committerGitHub <noreply@github.com>2021-04-25 17:21:52 +0000
commit156893d774b4da5b541fdbb08428f9ec392949a0 (patch)
tree9185d94384aa62eb6eb099ddc4ca9408df6f90d1 /migrations/2021-03-20-171007_create_users/up.sql
parentAdd to Cargo.toml (diff)
downloadatuin-156893d774b4da5b541fdbb08428f9ec392949a0.zip
Update docs, unify on SQLx, bugfixes (#40)
* Begin moving to sqlx for local too * Stupid scanners should just have a nice cup of tea Random internet shit searching for /.env or whatever * Remove diesel and rusqlite fully
Diffstat (limited to 'migrations/2021-03-20-171007_create_users/up.sql')
-rw-r--r--migrations/2021-03-20-171007_create_users/up.sql11
1 files changed, 0 insertions, 11 deletions
diff --git a/migrations/2021-03-20-171007_create_users/up.sql b/migrations/2021-03-20-171007_create_users/up.sql
deleted file mode 100644
index 46c6a372..00000000
--- a/migrations/2021-03-20-171007_create_users/up.sql
+++ /dev/null
@@ -1,11 +0,0 @@
--- Your SQL goes here
-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));