remove avatar column from users table

2 files changed, 1 insertions, 2 deletions

diff --git a/api/auth/signup.py b/api/auth/signup.py
index 210ba94..0cd7628 100644
--- a/api/auth/signup.py
+++ b/api/auth/signup.py
@@ -48,7 +48,7 @@ def index():
     password_hash = passwords.password_hash(password)
     registered = int( time.time() * 1000 )
 
-    cursor.execute("insert into users values (?, ?, ?, NULL, NULL, ?, ?, \"[]\", FALSE, \"user\", \"{}\", NULL, \"online\") ",
+    cursor.execute("insert into users values (?, ?, ?, NULL, NULL, ?, ?, \"[]\", FALSE, \"user\", \"{}\", \"online\") ",
             (user_id, username, email, password_hash, registered))
     connection.commit()
 
diff --git a/database/init_db.sql b/database/init_db.sql
index d05af6e..cd52e2e 100644
--- a/database/init_db.sql
+++ b/database/init_db.sql
@@ -12,7 +12,6 @@ create table if not exists users (
 	verified_email boolean not null,
 	type text not null,
 	preferences text not null,
-	avatar text,
 	presence text
 );