diff options
author | Yorhel <git@yorhel.nl> | 2019-08-24 15:48:59 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2019-08-24 15:48:59 +0200 |
commit | be85ef9586335ce22192349bfe8adb2ce80fd5a5 (patch) | |
tree | 46b3ea2773f320d9b1d545e8f118fa8e8706cb18 /util/sql/schema.sql | |
parent | 2f80723a876c1a865dd529be6642a7b5b6d420f0 (diff) |
Add MangaGamer price info crawler
Diffstat (limited to 'util/sql/schema.sql')
-rw-r--r-- | util/sql/schema.sql | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/util/sql/schema.sql b/util/sql/schema.sql index 0dd8b3f5..ae32e01d 100644 --- a/util/sql/schema.sql +++ b/util/sql/schema.sql @@ -477,6 +477,15 @@ CREATE TABLE shop_jlist ( price text NOT NULL DEFAULT '' -- empty when unknown or not in stock ); +-- shop_mg +CREATE TABLE shop_mg ( + id integer NOT NULL PRIMARY KEY, + lastfetch timestamptz, + found boolean NOT NULL DEFAULT false, + r18 boolean NOT NULL DEFAULT true, + price text NOT NULL DEFAULT '' +); + -- staff CREATE TABLE staff ( -- dbentry_type=s id SERIAL PRIMARY KEY, -- [pub] |