Add fields for users

1 files changed, 7 insertions, 4 deletions

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
 );