summaryrefslogtreecommitdiffstats
path: root/server/migrations/2019-02-26-002946_create_user
diff options
context:
space:
mode:
authorDessalines <tyhou13@gmx.com>2019-03-22 18:42:57 -0700
committerDessalines <tyhou13@gmx.com>2019-03-22 18:42:57 -0700
commite570c70701e1c66dad12bef76821f6d94c717a02 (patch)
tree070d5ba322226acd5fe0d0a7757cb936462ab2ff /server/migrations/2019-02-26-002946_create_user
parent816aa0b15f3766e340d8722f03e8b3a7633ab6fb (diff)
Adding login and Register
- Login and Register mostly working. - Starting to work on creating communities.
Diffstat (limited to 'server/migrations/2019-02-26-002946_create_user')
-rw-r--r--server/migrations/2019-02-26-002946_create_user/up.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/server/migrations/2019-02-26-002946_create_user/up.sql b/server/migrations/2019-02-26-002946_create_user/up.sql
index 577ff136..d4edb370 100644
--- a/server/migrations/2019-02-26-002946_create_user/up.sql
+++ b/server/migrations/2019-02-26-002946_create_user/up.sql
@@ -1,9 +1,9 @@
create table user_ (
id serial primary key,
- name varchar(20) not null,
+ name varchar(20) not null unique,
preferred_username varchar(20),
password_encrypted text not null,
- email text,
+ email text unique,
icon bytea,
published timestamp not null default now(),
updated timestamp