summaryrefslogtreecommitdiff
path: root/util/sql
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-24 15:48:59 +0200
committerYorhel <git@yorhel.nl>2019-08-24 15:48:59 +0200
commitbe85ef9586335ce22192349bfe8adb2ce80fd5a5 (patch)
tree46b3ea2773f320d9b1d545e8f118fa8e8706cb18 /util/sql
parent2f80723a876c1a865dd529be6642a7b5b6d420f0 (diff)
Add MangaGamer price info crawler
Diffstat (limited to 'util/sql')
-rw-r--r--util/sql/perms.sql1
-rw-r--r--util/sql/schema.sql9
2 files changed, 10 insertions, 0 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql
index 4feed316..79e4bb92 100644
--- a/util/sql/perms.sql
+++ b/util/sql/perms.sql
@@ -122,6 +122,7 @@ 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, INSERT, UPDATE, DELETE ON shop_mg 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 0dd8b3f5..ae32e01d 100644
--- a/util/sql/schema.sql
+++ b/util/sql/schema.sql
@@ -477,6 +477,15 @@ CREATE TABLE shop_jlist (
price text NOT NULL DEFAULT '' -- empty when unknown or not in stock
);
+-- shop_mg
+CREATE TABLE shop_mg (
+ id integer NOT NULL PRIMARY KEY,
+ lastfetch timestamptz,
+ found boolean NOT NULL DEFAULT false,
+ r18 boolean NOT NULL DEFAULT true,
+ price text NOT NULL DEFAULT ''
+);
+
-- staff
CREATE TABLE staff ( -- dbentry_type=s
id SERIAL PRIMARY KEY, -- [pub]