diff options
Diffstat (limited to 'migrations/20231003193749_pinussy.sql')
| -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), |