diff options
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 5d11191e..5acd7e9d 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -124,11 +124,12 @@ CREATE TABLE release_rev ( container_ident_id UUID REFERENCES container_ident(id), title TEXT NOT NULL, release_type TEXT, -- TODO: enum - date TEXT, -- XXX: datetime - doi TEXT, -- TODO: identifier table? + date DATE, + doi TEXT, volume TEXT, pages TEXT, issue TEXT + -- TODO: identifier table? ); CREATE INDEX release_rev_doi_idx ON release_rev(doi) WHERE doi IS NOT NULL; |