diff options
| author | Yorhel <git@yorhel.nl> | 2019-08-26 11:21:50 +0200 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2019-08-26 11:21:50 +0200 |
| commit | f4cbd0c722a92ce249a2a4a74bc153868553847c (patch) | |
| tree | 646b7274416bc2ea3209498fadc1548b539e62b7 /util | |
| parent | 7ff1182b5b2d3838945cf72609fbc596581cc110 (diff) | |
Display PlayAsia links on release pages + use crawled info to correct shop links
Diffstat (limited to 'util')
| -rw-r--r-- | util/sql/perms.sql | 5 | ||||
| -rw-r--r-- | util/updates/update_20190824.sql | 6 |
2 files changed, 11 insertions, 0 deletions
diff --git a/util/sql/perms.sql b/util/sql/perms.sql index 7197970f..a94b7374 100644 --- a/util/sql/perms.sql +++ b/util/sql/perms.sql @@ -39,6 +39,11 @@ GRANT SELECT ON relgraphs TO vndb_site; GRANT SELECT, INSERT, UPDATE, DELETE ON rlists TO vndb_site; GRANT SELECT, INSERT, UPDATE ON screenshots TO vndb_site; -- No access to the 'sessions' table, managed by the user_* functions. +GRANT SELECT ON shop_denpa TO vndb_site; +GRANT SELECT ON shop_dlsite TO vndb_site; +GRANT SELECT ON shop_jlist TO vndb_site; +GRANT SELECT ON shop_mg TO vndb_site; +GRANT SELECT ON shop_playasia TO vndb_site; GRANT SELECT, INSERT, UPDATE ON staff TO vndb_site; GRANT SELECT, INSERT, DELETE ON staff_alias TO vndb_site; GRANT SELECT, INSERT ON staff_alias_hist TO vndb_site; diff --git a/util/updates/update_20190824.sql b/util/updates/update_20190824.sql index 6a8b5330..bf7e0913 100644 --- a/util/updates/update_20190824.sql +++ b/util/updates/update_20190824.sql @@ -43,6 +43,12 @@ CREATE TABLE shop_playasia_gtin ( lastfetch timestamptz ); +GRANT SELECT ON shop_denpa TO vndb_site; +GRANT SELECT ON shop_dlsite TO vndb_site; +GRANT SELECT ON shop_jlist TO vndb_site; +GRANT SELECT ON shop_mg TO vndb_site; +GRANT SELECT ON shop_playasia TO vndb_site; + 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; |