diff options
author | Yorhel <git@yorhel.nl> | 2019-08-25 15:21:21 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-25 15:31:01 +0200 |
commit | 7ff1182b5b2d3838945cf72609fbc596581cc110 (patch) | |
tree | ffb548495a11831cf0239fedc6d9d64e16ef50e3 /util/sql/schema.sql | |
parent | 1befcd9ef905f114c8e9b8408292c110d58f992e (diff) |
Add PlayAsia shop crawler
Most of this code isn't new - there's been a hidden 'Affiliates.pm'
module for a while. This just consolidates the code with the other shops
and opens up the code. The API endpoint is hidden. :)
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 15 |
1 files changed, 15 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index c68ddcf9..cb150030 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -504,6 +504,21 @@ CREATE TABLE shop_mg ( price text NOT NULL DEFAULT '' ); +-- shop_playasia +CREATE TABLE shop_playasia ( + pax text NOT NULL PRIMARY KEY, + gtin bigint NOT NULL, + lastfetch timestamptz, + url text NOT NULL DEFAULT '', + price text NOT NULL DEFAULT '' +); + +-- shop_playasia_gtin +CREATE TABLE shop_playasia_gtin ( + gtin bigint NOT NULL PRIMARY KEY, + lastfetch timestamptz +); + -- staff CREATE TABLE staff ( -- dbentry_type=s id SERIAL PRIMARY KEY, -- [pub] |