From 9bab99871d5054de8dad50fc331a7177060f88e9 Mon Sep 17 00:00:00 2001 From: Tom Smeding Date: Sat, 20 Jun 2020 20:36:25 +0200 Subject: server: Add firebase user foreign key in schema --- schema.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) 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); -- cgit v1.2.3-54-g00ecf