Display PlayAsia links on release pages + use crawled info to correct shop links

1 files changed, 6 insertions, 0 deletions

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;