Store OAuth tokens in the database instead of asking for them for every single sync.

[skvidarsync] / skvidarlang.sql

diff --git a/skvidarlang.sql b/skvidarlang.sql
index e317b3e7f23bb316f9e7ae7591d2519fc0d31b90..e1249c13a978f4bda311d9189e3f5d25984a976f 100644 (file)
--- a/skvidarlang.sql
+++ b/skvidarlang.sql
@@ -39,6 +39,13 @@ CREATE TABLE group_membership_history (
 );
 CREATE INDEX gmh_lookup_idx ON group_membership_history (channel, ts, name, change_seen DESC);
 
+CREATE TABLE oauth_tokens (
+    token VARCHAR NOT NULL,
+    acquired TIMESTAMP WITH TIME ZONE NOT NULL,
+    expiry TIMESTAMP WITH TIME ZONE NOT NULL
+);
+CREATE INDEX oauth_tokens_exp_idx ON oauth_tokens ( expiry );
+
 CREATE VIEW current_reactions AS
   SELECT userid, channel, ts, reaction
     FROM ( SELECT DISTINCT ON (channel, ts, userid, reaction)
@@ -59,3 +66,4 @@ GRANT SELECT,UPDATE,INSERT ON TABLE message_sheet_link TO skvidarlang;
 GRANT SELECT,INSERT ON TABLE users_nagged TO skvidarlang;
 GRANT SELECT,INSERT ON TABLE group_membership_history TO skvidarlang;
 GRANT SELECT ON TABLE current_group_membership_history TO skvidarlang;
+GRANT SELECT,INSERT ON TABLE oauth_tokens TO skvidarlang;