diff options
| -rw-r--r-- | database/init_db.sql | 11 |
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) ); |