diff options
author | Yorhel <git@yorhel.nl> | 2019-08-24 17:29:21 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-24 17:29:21 +0200 |
commit | 8f836645ba4e5353dae466a0e184bef46cd95765 (patch) | |
tree | bdbb05f2f29bdf75bafec2b19dc9a098f95b240a /util/sql | |
parent | be85ef9586335ce22192349bfe8adb2ce80fd5a5 (diff) |
Add DenpaSoft 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 79e4bb92..1c5bde51 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_denpa 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 ae32e01d..1bccc5ed 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -468,6 +468,15 @@ CREATE TABLE sessions ( PRIMARY KEY (uid, token) ); +-- shop_denpa +CREATE TABLE shop_denpa ( + id text NOT NULL PRIMARY KEY, + lastfetch timestamptz, + found boolean NOT NULL DEFAULT false, + sku text NOT NULL DEFAULT '', + price text NOT NULL DEFAULT '' +); + -- shop_jlist CREATE TABLE shop_jlist ( id text NOT NULL PRIMARY KEY, |