diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-25 13:25:50 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-25 14:16:52 +0200 |
| commit | 1befcd9ef905f114c8e9b8408292c110d58f992e (patch) | |
| tree | 4d089e4e00feaf2c61a256c28df525436499a51f /util | |
| parent | 8f836645ba4e5353dae466a0e184bef46cd95765 (diff) | |
Add DLsite price & shop info crawler
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/perms.sql | 1 | ||||
| -rw-r--r-- | util/sql/schema.sql | 9 | ||||
| -rw-r--r-- | util/updates/update_20190824.sql | 9 |
3 files changed, 19 insertions, 0 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql index 1c5bde51..5b512471 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_denpa TO vndb_multi; +GRANT SELECT, INSERT, UPDATE, DELETE ON shop_dlsite 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; diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 1bccc5ed..c68ddcf9 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -477,6 +477,15 @@ CREATE TABLE shop_denpa ( price text NOT NULL DEFAULT '' ); +-- shop_dlsite +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 '' +); + -- shop_jlist CREATE TABLE shop_jlist ( id text NOT NULL PRIMARY KEY, 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; |