summaryrefslogtreecommitdiff
path: root/util/updates
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2019-08-25 13:25:50 +0200
committerYorhel <git@yorhel.nl>2019-08-25 14:16:52 +0200
commit1befcd9ef905f114c8e9b8408292c110d58f992e (patch)
tree4d089e4e00feaf2c61a256c28df525436499a51f /util/updates
parent8f836645ba4e5353dae466a0e184bef46cd95765 (diff)
Add DLsite price & shop info crawler
Diffstat (limited to 'util/updates')
-rw-r--r--util/updates/update_20190824.sql9
1 files changed, 9 insertions, 0 deletions
diff --git a/util/updates/update_20190824.sql b/util/updates/update_20190824.sql
index a99db9fa..f5a80231 100644
--- a/util/updates/update_20190824.sql
+++ b/util/updates/update_20190824.sql
@@ -22,6 +22,15 @@ CREATE TABLE shop_denpa (
price text NOT NULL DEFAULT ''
);
+CREATE TABLE shop_dlsite (
+ id text NOT NULL PRIMARY KEY,
+ lastfetch timestamptz,
+ found boolean NOT NULL DEFAULT false,
+ shop text NOT NULL DEFAULT '',
+ price text NOT NULL DEFAULT ''
+);
+
GRANT SELECT, INSERT, UPDATE, DELETE ON shop_jlist TO vndb_multi;
GRANT SELECT, INSERT, UPDATE, DELETE ON shop_mg TO vndb_multi;
GRANT SELECT, INSERT, UPDATE, DELETE ON shop_denpa TO vndb_multi;
+GRANT SELECT, INSERT, UPDATE, DELETE ON shop_dlsite TO vndb_multi;