From 2407c1a4a55d17817b31f7ca5cac9d68b27f536c Mon Sep 17 00:00:00 2001
From: cel 🌸 <cel@blos.sm>
Date: Mon, 11 Dec 2023 06:02:00 +0000
Subject: implement signup

---
 migrations/20231003193749_pinussy.sql | 6 +-----
 1 file changed, 1 insertion(+), 5 deletions(-)

(limited to 'migrations/20231003193749_pinussy.sql')

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),
-- 
cgit 

