From 53e0cd6508e722042faeda77aaedb2a7372e8f83 Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@archive.org>
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

