From 23cf79911e20eac981a25dc1c2f839d37f98c296 Mon Sep 17 00:00:00 2001
From: Santo Cariotti <santo@dcariotti.me>
Date: Mon, 21 Nov 2022 12:11:38 +0100
Subject: Add fields for users

---
 server/migrations/20220822142548_add-users-table.sql | 11 +++++++----
 1 file changed, 7 insertions(+), 4 deletions(-)

(limited to 'server/migrations/20220822142548_add-users-table.sql')

diff --git a/server/migrations/20220822142548_add-users-table.sql b/server/migrations/20220822142548_add-users-table.sql
index 4798d7e..c9571ec 100644
--- a/server/migrations/20220822142548_add-users-table.sql
+++ b/server/migrations/20220822142548_add-users-table.sql
@@ -1,6 +1,9 @@
 create table users (
-    id serial unique,
-    email varchar(100) unique not null,
-    password varchar(100) not null,
-    is_staff boolean default false
+    id SERIAL PRIMARY KEY,
+    name VARCHAR(100),
+    email VARCHAR(100) UNIQUE NOT NULL,
+    username VARCHAR(100) UNIQUE NOT NULL,
+    password VARCHAR(100) NOT NULL,
+    avatar VARCHAR,
+    is_staff BOOLEAN DEFAULT false
 );
-- 
cgit v1.2.3-18-g5258

