diff options
author | Dessalines <tyhou13@gmx.com> | 2019-02-27 22:02:55 -0800 |
---|---|---|
committer | Dessalines <tyhou13@gmx.com> | 2019-02-27 22:02:55 -0800 |
commit | 92ea945619a512d9c301492f81a8a017e73654f4 (patch) | |
tree | 237693b87188d95b24a4805b157566454d3fce6e /server/migrations/2019-02-26-002946_create_user | |
parent | d008e5fe5505caa7deb241b0fa073d259d7aaad9 (diff) |
Starting to work on Rust Diesel Schema. #5
Diffstat (limited to 'server/migrations/2019-02-26-002946_create_user')
-rw-r--r-- | server/migrations/2019-02-26-002946_create_user/down.sql | 1 | ||||
-rw-r--r-- | server/migrations/2019-02-26-002946_create_user/up.sql | 8 |
2 files changed, 9 insertions, 0 deletions
diff --git a/server/migrations/2019-02-26-002946_create_user/down.sql b/server/migrations/2019-02-26-002946_create_user/down.sql new file mode 100644 index 00000000..606be6e1 --- /dev/null +++ b/server/migrations/2019-02-26-002946_create_user/down.sql @@ -0,0 +1 @@ +drop table user_ diff --git a/server/migrations/2019-02-26-002946_create_user/up.sql b/server/migrations/2019-02-26-002946_create_user/up.sql new file mode 100644 index 00000000..4f9984b7 --- /dev/null +++ b/server/migrations/2019-02-26-002946_create_user/up.sql @@ -0,0 +1,8 @@ +create table user_ ( + id serial primary key, + name varchar(20) not null, + password_encrypted varchar(200) not null, + email varchar(200), + icon bytea, + startTime timestamp not null default now() +) |