diff options
| author |  cel 🌸 <cel@blos.sm> | 2023-12-11 06:02:00 +0000 |
|---|---|---|
| committer | cel 🌸 <cel@blos.sm> | 2023-12-11 06:02:00 +0000 |
| commit | 2407c1a4a55d17817b31f7ca5cac9d68b27f536c (patch) | |
| tree | fc91c3c3ebde6e5124ff9c1830eac2fcbff68c1f /migrations | |
| parent | 85874ab158e1f91fd75aceb70a4c14d36284ec13 (diff) | |
| download | pinussy-2407c1a4a55d17817b31f7ca5cac9d68b27f536c.tar.gz pinussy-2407c1a4a55d17817b31f7ca5cac9d68b27f536c.tar.bz2 pinussy-2407c1a4a55d17817b31f7ca5cac9d68b27f536c.zip | |
implement signup
Diffstat (limited to '')
| -rw-r--r-- | migrations/20231003193749_pinussy.sql | 6 |
1 files changed, 1 insertions, 5 deletions
diff --git a/migrations/20231003193749_pinussy.sql b/migrations/20231003193749_pinussy.sql index 24f3aa1..cba545e 100644 --- a/migrations/20231003193749_pinussy.sql +++ b/migrations/20231003193749_pinussy.sql @@ -4,7 +4,7 @@ create type file_type as enum ('image', 'video', 'audio', 'text', 'document', 's create table users ( id integer primary key generated always as identity, username varchar(32) not null, - unique(id, username), + unique(username), password varchar(128) not null, email varchar(128), bio text, @@ -23,7 +23,6 @@ create table sessions ( create table boards ( id integer primary key generated always as identity, idname varchar(256), - unique(id, idname), name varchar(256), description text, privacy privacy @@ -40,7 +39,6 @@ create table board_ownership ( create table pins ( id integer primary key generated always as identity, idname varchar(256), - unique(id, idname), subject varchar(256), notes text, privacy privacy @@ -65,7 +63,6 @@ create table pins_boards ( create table sources ( id integer primary key generated always as identity, idname varchar(256), - unique(id, idname), title varchar(256), author varchar(256), url varchar(256), @@ -85,7 +82,6 @@ create table pin_sources ( create table files ( id integer primary key generated always as identity, idname varchar(256), - unique(id, idname), thumbnail varchar(256), path varchar(256) not null, title varchar(256), |