Get more of the sheet, so that we get the headings (will be needed soon).

[skvidarsync] / skvidarlang.sql

diff --git a/skvidarlang.sql b/skvidarlang.sql
index 78e39e8679e640b0c51bf110a3fe53db5f88f421..536a1d3e905d914a9083a9a1b7b8f18905f2667b 100644 (file)
--- a/skvidarlang.sql
+++ b/skvidarlang.sql
@@ -15,6 +15,13 @@ CREATE TABLE reaction_log (
 );
 CREATE INDEX lookup_idx ON reaction_log USING btree (channel, ts, userid, reaction, event_ts DESC);
 
+CREATE TABLE message_sheet_link (
+    channel VARCHAR NOT NULL,
+    ts VARCHAR NOT NULL,
+    sheet_title VARCHAR NOT NULL,
+    PRIMARY KEY (channel, ts)
+);
+
 CREATE VIEW current_reactions AS
   SELECT userid, channel, ts, reaction
     FROM ( SELECT DISTINCT ON (channel, ts, userid, reaction)
@@ -22,16 +29,9 @@ CREATE VIEW current_reactions AS
            FROM reaction_log ORDER BY channel, ts, userid, reaction, event_ts DESC ) t1
   WHERE event_type = 'reaction_added';
 
-CREATE TABLE reactions (
-    userid VARCHAR NOT NULL,
-    channel VARCHAR NOT NULL,
-    ts VARCHAR NOT NULL,
-    reaction VARCHAR NOT NULL,
-    PRIMARY KEY (userid, channel, ts, reaction)
-);
-
 GRANT SELECT,INSERT,DELETE ON TABLE applied TO skvidarlang;
 GRANT SELECT,INSERT ON TABLE reaction_log TO skvidarlang;
 GRANT SELECT ON TABLE current_reactions TO skvidarlang;
-GRANT SELECT,INSERT,DELETE ON TABLE reactions TO skvidarlang;
+GRANT SELECT,UPDATE,INSERT ON TABLE message_sheet_link TO skvidarlang;
+