diff options
author | Yorhel <git@yorhel.nl> | 2019-08-26 13:31:03 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-26 13:31:36 +0200 |
commit | 27ff73213928994e7e1117293c4a751fe99b215b (patch) | |
tree | 23ef55a51d44c91eae6d6da83410ff5bac6e80e0 /util/updates | |
parent | f4cbd0c722a92ce249a2a4a74bc153868553847c (diff) |
Display shop+price info on VN pages + delete old affiliate code
The current affiliate links format doesn't display as much information
as before but it's also a lot less messy.
Diffstat (limited to 'util/updates')
-rw-r--r-- | util/updates/update_20190824.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/update_20190824.sql b/util/updates/update_20190824.sql index bf7e0913..5aeb779c 100644 --- a/util/updates/update_20190824.sql +++ b/util/updates/update_20190824.sql @@ -64,3 +64,8 @@ INSERT INTO shop_playasia (pax, gtin, lastfetch, url, price) JOIN releases ON affiliate_links.rid = releases.id WHERE affiliate = 0 AND NOT affiliate_links.hidden AND price <> 'US$ 0.00' GROUP BY data; + + +-- Whenever: +-- DROP TABLE affiliate_links; +-- DROP TABLE multi_affiliate_gtin; |