diff options
author | Yorhel <git@yorhel.nl> | 2019-08-24 15:48:59 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-24 15:48:59 +0200 |
commit | be85ef9586335ce22192349bfe8adb2ce80fd5a5 (patch) | |
tree | 46b3ea2773f320d9b1d545e8f118fa8e8706cb18 /util/sql | |
parent | 2f80723a876c1a865dd529be6642a7b5b6d420f0 (diff) |
Add MangaGamer price info crawler
Diffstat (limited to 'util/sql')
-rw-r--r-- | util/sql/perms.sql | 1 | ||||
-rw-r--r-- | util/sql/schema.sql | 9 |
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] |