chocula early work

(non-functional)

1 files changed, 80 insertions, 0 deletions

diff --git a/chocula_schema.sql b/chocula_schema.sql
new file mode 100644
index 0000000..e03907a
--- /dev/null
+++ b/chocula_schema.sql
@@ -0,0 +1,80 @@
+
+
+CREATE TABLE IF NOT EXISTS journal_summary
+    (issnl TEXT NOT NULL PRIMARY KEY,
+     issne TEXT,
+     issnp TEXT,
+     country TEXT,
+     lang TEXT,
+     langs TEXT,
+     publisher_type TEXT,
+     is_active BOOLEAN,
+     is_oa BOOLEAN default false,
+     is_longtail BOOLEAN default false,
+     vor_pdf BOOLEAN,
+     vor_html BOOLEAN,
+     vor_jats BOOLEAN,
+     has_dois BOOLEAN,
+     any_live_homepage BOOLEAN,
+     any_preservation BOOLEAN,
+     any_ia BOOLEAN
+    );
+
+CREATE TABLE IF NOT EXISTS journal_index
+    (issnl TEXT NOT NULL,
+     slug TEXT NOT NULL,
+     identifier TEXT,
+     name TEXT,
+     work_count INTEGER,
+     extra TEXT,
+     PRIMARY KEY(issnl, slug)
+    );
+
+CREATE TABLE IF NOT EXISTS fatcat_container
+    (issnl TEXT NOT NULL PRIMARY KEY,
+     ident TEXT NOT NULL,
+     revision TEXT NOT NULL,
+     name TEXT,
+     container_type TEXT,
+     publisher TEXT,
+     country TEXT,
+     lang TEXT,
+     release_count INTEGER,
+     ia_count INTEGER,
+     ia_frac float,
+     kbart_count INTEGER,
+     kbart_frac float
+    );
+
+CREATE TABLE IF NOT EXISTS homepage
+    (id INTEGER PRIMARY KEY,
+     issnl TEXT NOT NULL,
+     surt TEXT NOT NULL,
+     url TEXT NOT NULL,
+     host TEXT NOT NULL,
+     domain TEXT NOT NULL,
+     suffix TEXT NOT NULL,
+     status_code INTEGER,
+     terminal_url TEXT,
+     terminal_status_code INTEGER,
+     platform_software TEXT,
+     scope TEXT,
+     has_issn BOOLEAN,
+     blocked BOOLEAN,
+     UNIQUE(issnl, surt)
+    );
+
+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
+    );
+
+CREATE TABLE IF NOT EXISTS title 
+    (id INTEGER PRIMARY KEY,
+     issnl TEXT NOT NULL,
+     title TEXT NOT NULL
+    );