Cache the title and userid of the notifications

These aren't likely to change anyway, and things will become less easy
to display when other types of notifications are added.

1 files changed, 4 insertions, 1 deletions

diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index 557b75a1..c496e01d 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -34,7 +34,9 @@ CREATE TABLE notifications (
   ntype notification_ntype NOT NULL,
   ltype notification_ltype NOT NULL,
   iid integer NOT NULL,
-  subid integer
+  subid integer,
+  c_title text NOT NULL,
+  c_byuser integer
 );
 
 -- producers
@@ -354,6 +356,7 @@ CREATE TABLE wlists (
 
 ALTER TABLE changes             ADD FOREIGN KEY (requester) REFERENCES users         (id);
 ALTER TABLE notifications       ADD FOREIGN KEY (uid)       REFERENCES users         (id);
+ALTER TABLE notifications       ADD FOREIGN KEY (c_byuser)  REFERENCES users         (id);
 ALTER TABLE producers           ADD FOREIGN KEY (latest)    REFERENCES producers_rev (id) DEFERRABLE INITIALLY DEFERRED;
 ALTER TABLE producers           ADD FOREIGN KEY (rgraph)    REFERENCES relgraphs     (id);
 ALTER TABLE producers_relations ADD FOREIGN KEY (pid1)      REFERENCES producers_rev (id);