From 4a1d8f20ab91fda0f4794131144915d0c5214268 Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 14 May 2018 23:17:53 -0700 Subject: tweaks to SQL schema --- rust/migrations/2018-05-12-001226_init/up.sql | 6 +++--- 1 file 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) ); -- cgit v1.2.3