summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
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)
);