diff options
author | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-30 20:50:18 -0700 |
---|---|---|
committer | Bryan Newbold <bnewbold@robocracy.org> | 2019-07-30 20:50:18 -0700 |
commit | c47acaee8a339f358c5f39bcbc99ee1519811a93 (patch) | |
tree | 5586308c4a0e430426508b13b60616bc3f7f1a8e /chocula_schema.sql | |
parent | 6a00a6f4ac3a2d1f029bae6402d1dd117a58416e (diff) | |
download | chocula-c47acaee8a339f358c5f39bcbc99ee1519811a93.tar.gz chocula-c47acaee8a339f358c5f39bcbc99ee1519811a93.zip |
chocula: better ISSN-L handling
Diffstat (limited to 'chocula_schema.sql')
-rw-r--r-- | chocula_schema.sql | 9 |
1 files changed, 6 insertions, 3 deletions
diff --git a/chocula_schema.sql b/chocula_schema.sql index e7e857a..24adb5e 100644 --- a/chocula_schema.sql +++ b/chocula_schema.sql @@ -28,7 +28,9 @@ CREATE TABLE IF NOT EXISTS journal has_dois BOOLEAN, any_homepage BOOLEAN, any_live_homepage BOOLEAN, - bad_issnl BOOLEAN + any_gwb_homepage BOOLEAN, + known_issnl BOOLEAN, + valid_issnl BOOLEAN ); CREATE TABLE IF NOT EXISTS directory @@ -41,9 +43,9 @@ CREATE TABLE IF NOT EXISTS directory ); CREATE TABLE IF NOT EXISTS fatcat_container - (issnl TEXT NOT NULL PRIMARY KEY, - ident TEXT NOT NULL, + (ident TEXT NOT NULL PRIMARY KEY, revision TEXT NOT NULL, + issnl TEXT, issne TEXT, issnp TEXT, wikidata_qid TEXT, @@ -60,6 +62,7 @@ CREATE TABLE IF NOT EXISTS fatcat_container preserved_count INTEGER, preserved_frac FLOAT ); +CREATE INDEX IF NOT EXISTS fatcat_container_issnl_idx ON fatcat_container(issnl); CREATE TABLE IF NOT EXISTS homepage (id INTEGER PRIMARY KEY, |