X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=skvidarlang.sql;h=63f537c75784db5676796f26696f07f96fc029da;hb=96b7fad9045165418862b9611128413167a35f7f;hp=d52ed9d8b13c3d133a31f78c4c01b543588eeba0;hpb=fc827b42d333d4f7b4c5014d5decd2e64562fc5b;p=skvidarsync

diff --git a/skvidarlang.sql b/skvidarlang.sql
index d52ed9d..63f537c 100644
--- 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)
 );
 
@@ -35,7 +36,7 @@ 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;