server: Add firebase user foreign key in schema

1 files changed, 2 insertions, 1 deletions

diff --git a/schema.sql b/schema.sql
index 55fe091..1592bdd 100644
--- a/schema.sql
+++ b/schema.sql
@@ -38,6 +38,7 @@ create index messages_time_index on Messages(time);
 
 create table Firebase (
 	user integer,
-	token text
+	token text,
+	foreign key(user) references Users(id) on delete cascade
 );
 create index firebase_user_index on Firebase(user);