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.sql5
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;