diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-14 23:17:53 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-14 23:17:53 -0700 |
| commit | 4a1d8f20ab91fda0f4794131144915d0c5214268 (patch) | |
| tree | d6c28019567176894703b318ab55b041671eff4a /rust/migrations/2018-05-12-001226_init/up.sql | |
| parent | b552cba6b45fa547a5b90b3fc3af7bfc98d3e289 (diff) | |
| download | fatcat-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.sql | 6 |
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) ); |