social table update

1 files changed, 6 insertions, 5 deletions

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