diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-31 14:01:31 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-31 14:01:31 -0700 |
commit | fa657c6e1046aa8ffc8f6c59eebf9797d914c31a (patch) | |
tree | 981d8f76023bebe25255021e726ce323c3850771 /chocula_schema.sql | |
parent | ed452c219ca29c06426b03691a9369724aa7e251 (diff) | |
download | chocula-fa657c6e1046aa8ffc8f6c59eebf9797d914c31a.tar.gz chocula-fa657c6e1046aa8ffc8f6c59eebf9797d914c31a.zip |
more issn URL checker fixes
Diffstat (limited to 'chocula_schema.sql')
-rw-r--r-- | chocula_schema.sql | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/chocula_schema.sql b/chocula_schema.sql index 9946279..46b282d 100644 --- a/chocula_schema.sql +++ b/chocula_schema.sql @@ -74,13 +74,14 @@ CREATE TABLE IF NOT EXISTS homepage domain TEXT NOT NULL, suffix TEXT NOT NULL, status_code INTEGER, + crawl_error TEXT, terminal_url TEXT, terminal_status_code INTEGER, platform_software TEXT, - scope TEXT, - has_issn BOOLEAN, + issnl_in_body BOOLEAN, blocked BOOLEAN, - latest_gwb_success TEXT, + gwb_url_success_dt TEXT, + gwb_terminal_url_success_dt TEXT, UNIQUE(issnl, surt) ); CREATE INDEX IF NOT EXISTS homepage_url_idx ON homepage(url); |