From 53e0cd6508e722042faeda77aaedb2a7372e8f83 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Thu, 7 May 2020 16:01:18 -0700 Subject: schema: removed unused/commented lines --- chocula_schema.sql | 19 ------------------- 1 file changed, 19 deletions(-) (limited to 'chocula_schema.sql') 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 --- ); -- cgit v1.2.3