server: WIP firebase

1 files changed, 6 insertions, 0 deletions

diff --git a/schema.sql b/schema.sql
index 009308e..6291102 100644
--- a/schema.sql
+++ b/schema.sql
@@ -31,3 +31,9 @@ create table Messages (
 	foreign key(user) references Users(id) on delete set null
 );
 create index messages_time_index on Messages(time);
+
+create table Firebase (
+	user integer,
+	token text
+);
+create index firebase_user_index on Firebase(user);