From 3d36847211e37c5aed0a7fdda5c2a00399fdc66e Mon Sep 17 00:00:00 2001 From: lonkaars Date: Fri, 12 Mar 2021 14:05:54 +0100 Subject: social table update --- database/init_db.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'database') diff --git a/database/init_db.sql b/database/init_db.sql index 2ce8a1e..d05af6e 100644 --- a/database/init_db.sql +++ b/database/init_db.sql @@ -38,10 +38,11 @@ create table if not exists games ( ); create table if not exists social ( - user_id text not null, - friends text, - blocked text, - pending text, - foreign key(user_id) references users(user_id) + user_1_id text not null, + user_2_id text not null, + type text not null, + timestamp integer not null, + foreign key(user_1_id) references users(user_id), + foreign key(user_2_id) references users(user_id) ); -- cgit v1.2.3