aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@archive.org>2020-05-07 16:01:18 -0700
committerBryan Newbold <bnewbold@archive.org>2020-05-07 16:01:18 -0700
commit53e0cd6508e722042faeda77aaedb2a7372e8f83 (patch)
tree8f4fb79ebbdadc2673a0bc8bf53dff99dc802751
parent4d701f4f2ea99ac95bd4235adef1998f3abdc9f9 (diff)
downloadchocula-53e0cd6508e722042faeda77aaedb2a7372e8f83.tar.gz
chocula-53e0cd6508e722042faeda77aaedb2a7372e8f83.zip
schema: removed unused/commented lines
-rw-r--r--chocula_schema.sql19
1 files changed, 0 insertions, 19 deletions
diff --git a/chocula_schema.sql b/chocula_schema.sql
index 2db1065..7698c8c 100644
--- a/chocula_schema.sql
+++ b/chocula_schema.sql
@@ -23,9 +23,6 @@ CREATE TABLE IF NOT EXISTS journal
is_oa BOOLEAN default false,
is_longtail BOOLEAN default false,
sherpa_color TEXT,
- --vor_pdf BOOLEAN,
- --vor_html BOOLEAN,
- --vor_jats BOOLEAN,
has_dois BOOLEAN,
any_homepage BOOLEAN,
any_live_homepage BOOLEAN,
@@ -85,19 +82,3 @@ CREATE TABLE IF NOT EXISTS homepage
UNIQUE(issnl, surt)
);
CREATE INDEX IF NOT EXISTS homepage_url_idx ON homepage(url);
-
--- CREATE TABLE IF NOT EXISTS name
--- (id INTEGER PRIMARY KEY,
--- issnl TEXT NOT NULL,
--- name TEXT NOT NULL
--- -- sluggy (lower-case, no special chars)
--- );
-
--- CREATE TABLE IF NOT EXISTS fulltext_pattern
--- (id INTEGER PRIMARY KEY,
--- issnl TEXT NOT NULL,
--- surt_glob TEXT,
--- mimetype TEXT,
--- state_date TEXT,
--- end_date TEXT
--- );