summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-24 15:29:48 +0200
committerYorhel <git@yorhel.nl>2019-08-24 15:47:54 +0200
commit2f80723a876c1a865dd529be6642a7b5b6d420f0 (patch)
treec604abcfd426db19e058d47e3b905cfc4632c4c9 /util
parent9de176a9234b56870ba175f7261d8fed9800beec (diff)
Add J-List price info crawler
Diffstat (limited to 'util')
-rw-r--r--util/sql/perms.sql1
-rw-r--r--util/sql/schema.sql9
-rw-r--r--util/updates/update_20190824.sql9
3 files changed, 19 insertions, 0 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql
index 93c8e241..4feed316 100644
--- a/util/sql/perms.sql
+++ b/util/sql/perms.sql
@@ -121,6 +121,7 @@ GRANT SELECT, INSERT, UPDATE, DELETE ON rlists TO vndb_multi;
GRANT SELECT ON screenshots TO vndb_multi;
GRANT SELECT (lastused) ON sessions TO vndb_multi;
GRANT DELETE ON sessions TO vndb_multi;
+GRANT SELECT, INSERT, UPDATE, DELETE ON shop_jlist TO vndb_multi;
GRANT SELECT ON staff TO vndb_multi;
GRANT SELECT ON staff_alias TO vndb_multi;
GRANT SELECT ON staff_alias_hist TO vndb_multi;
diff --git a/util/sql/schema.sql b/util/sql/schema.sql
index ca843309..0dd8b3f5 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -468,6 +468,15 @@ CREATE TABLE sessions (
PRIMARY KEY (uid, token)
);
+-- shop_jlist
+CREATE TABLE shop_jlist (
+ id text NOT NULL PRIMARY KEY,
+ lastfetch timestamptz,
+ found boolean NOT NULL DEFAULT false,
+ jbox boolean NOT NULL DEFAULT false,
+ price text NOT NULL DEFAULT '' -- empty when unknown or not in stock
+);
+
-- staff
CREATE TABLE staff ( -- dbentry_type=s
id SERIAL PRIMARY KEY, -- [pub]
diff --git a/util/updates/update_20190824.sql b/util/updates/update_20190824.sql
new file mode 100644
index 00000000..31930604
--- /dev/null
+++ b/util/updates/update_20190824.sql
@@ -0,0 +1,9 @@
+CREATE TABLE shop_jlist (
+ id text NOT NULL PRIMARY KEY,
+ lastfetch timestamptz,
+ found boolean NOT NULL DEFAULT false,
+ jbox boolean NOT NULL DEFAULT false,
+ price text NOT NULL DEFAULT ''
+);
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON shop_jlist TO vndb_multi;