aboutsummaryrefslogtreecommitdiffstats
path: root/extra/journal_metadata/chocula_schema.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-07-26 15:49:13 -0700
committerBryan Newbold <bnewbold@robocracy.org>2019-07-26 15:49:13 -0700
commit568edcb7c1d7b4d52732b66c584576030b508491 (patch)
tree2e97eb075cdd2b7e731158c434e717d6dcfa7a2b /extra/journal_metadata/chocula_schema.sql
parentac4db073e0305e864778a306309f073d94524886 (diff)
downloadfatcat-568edcb7c1d7b4d52732b66c584576030b508491.tar.gz
fatcat-568edcb7c1d7b4d52732b66c584576030b508491.zip
shorter/simpler table names
Diffstat (limited to 'extra/journal_metadata/chocula_schema.sql')
-rw-r--r--extra/journal_metadata/chocula_schema.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/extra/journal_metadata/chocula_schema.sql b/extra/journal_metadata/chocula_schema.sql
index 015b46b7..25a2ae33 100644
--- a/extra/journal_metadata/chocula_schema.sql
+++ b/extra/journal_metadata/chocula_schema.sql
@@ -1,6 +1,6 @@
-CREATE TABLE IF NOT EXISTS journal_summary
+CREATE TABLE IF NOT EXISTS journal
(issnl TEXT NOT NULL PRIMARY KEY,
issne TEXT,
issnp TEXT,
@@ -22,7 +22,7 @@ CREATE TABLE IF NOT EXISTS journal_summary
any_ia BOOLEAN
);
-CREATE TABLE IF NOT EXISTS journal_index
+CREATE TABLE IF NOT EXISTS directory
(issnl TEXT NOT NULL,
slug TEXT NOT NULL,
identifier TEXT,