Correct cell names for duplicate detection.

[skvidarsync] / skvidarlang.sql

diff --git a/skvidarlang.sql b/skvidarlang.sql
index 536a1d3e905d914a9083a9a1b7b8f18905f2667b..63f537c75784db5676796f26696f07f96fc029da 100644 (file)
--- a/skvidarlang.sql
+++ b/skvidarlang.sql
@@ -2,6 +2,7 @@ CREATE TABLE applied (
     channel VARCHAR NOT NULL,
     ts VARCHAR NOT NULL,
     name VARCHAR NOT NULL,
+    color VARCHAR NOT NULL DEFAULT 'yellow',
     PRIMARY KEY (channel, ts, name)
 );
 
@@ -22,6 +23,12 @@ CREATE TABLE message_sheet_link (
     PRIMARY KEY (channel, ts)
 );
 
+CREATE TABLE users_nagged (
+    userid VARCHAR NOT NULL,
+    last_nag TIMESTAMP WITH TIME ZONE NOT NULL,
+    PRIMARY KEY (userid)
+);
+
 CREATE VIEW current_reactions AS
   SELECT userid, channel, ts, reaction
     FROM ( SELECT DISTINCT ON (channel, ts, userid, reaction)
@@ -29,9 +36,8 @@ CREATE VIEW current_reactions AS
            FROM reaction_log ORDER BY channel, ts, userid, reaction, event_ts DESC ) t1
   WHERE event_type = 'reaction_added';
 
-GRANT SELECT,INSERT,DELETE ON TABLE applied TO skvidarlang;
+GRANT SELECT,UPDATE,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,UPDATE,INSERT ON TABLE message_sheet_link TO skvidarlang;
-
-
+GRANT SELECT,INSERT ON TABLE users_nagged TO skvidarlang;