summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-05-14 23:17:53 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-05-14 23:17:53 -0700
commit4a1d8f20ab91fda0f4794131144915d0c5214268 (patch)
treed6c28019567176894703b318ab55b041671eff4a /rust/migrations/2018-05-12-001226_init/up.sql
parentb552cba6b45fa547a5b90b3fc3af7bfc98d3e289 (diff)
downloadfatcat-4a1d8f20ab91fda0f4794131144915d0c5214268.tar.gz
fatcat-4a1d8f20ab91fda0f4794131144915d0c5214268.zip
tweaks to SQL schema
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql6
1 files changed, 3 insertions, 3 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index 1a8c25b5..fabd2c3f 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -69,8 +69,7 @@ CREATE TABLE container_rev (
name TEXT,
parent_ident_id BIGINT REFERENCES container_rev(id),
publisher TEXT,
- sortname TEXT,
- issn TEXT -- TODO: char
+ issn TEXT -- TODO: varchar
);
CREATE TABLE container_ident (
@@ -122,6 +121,7 @@ CREATE TABLE release_rev (
work_ident_id UUID, -- FOREIGN KEY; see ALRTER below
container_ident_id UUID REFERENCES container_ident(id),
+ title TEXT,
license TEXT, -- TODO: ?
release_type TEXT, -- TODO: enum
date TEXT, -- XXX: datetime
@@ -152,7 +152,7 @@ CREATE TABLE work_rev (
id BIGSERIAL PRIMARY KEY,
extra_json JSON,
- title TEXT,
+ -- not even a work, for now
work_type TEXT, -- TODO: enum?
primary_release_id UUID REFERENCES release_ident(id)
);