From ebc8cff3b4f15242ebed2bacf3811606171c1a38 Mon Sep 17 00:00:00 2001 From: lonkaars Date: Thu, 18 Mar 2021 09:52:46 +0100 Subject: remove avatar column from users table --- api/auth/signup.py | 2 +- database/init_db.sql | 1 - 2 files changed, 1 insertion(+), 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 ); -- cgit v1.2.3