diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-16 20:55:15 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-16 20:55:15 -0700 |
| commit | 3fce9b2ff8a0daa043357facbbd961a231bd3c02 (patch) | |
| tree | 558fe0c743246b550671d4f5cc9f7130b04cf87e | |
| parent | 39456677cdc9768ad0dea76be4fd36735eec3ed2 (diff) | |
| download | fatcat-3fce9b2ff8a0daa043357facbbd961a231bd3c02.tar.gz fatcat-3fce9b2ff8a0daa043357facbbd961a231bd3c02.zip | |
simplify SQL schema a bit
| -rw-r--r-- | rust/migrations/2018-05-12-001226_init/up.sql | 8 | ||||
| -rw-r--r-- | rust/src/database_schema.rs | 4 |
2 files changed, 6 insertions, 6 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 0952cec3..6d8471eb 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -67,11 +67,12 @@ CREATE TABLE container_rev ( -- extra_json JSON, name TEXT NOT NULL, - parent_ident_id BIGINT REFERENCES container_rev(id), publisher TEXT, issn TEXT -- TODO: varchar ); +CREATE INDEX container_rev_issn_idx ON container_rev(issn) WHERE issn IS NOT NULL; + CREATE TABLE container_ident ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), is_live BOOL NOT NULL DEFAULT false, @@ -122,8 +123,7 @@ CREATE TABLE release_rev ( work_ident_id UUID NOT NULL, -- FOREIGN KEY; see ALRTER below container_ident_id UUID REFERENCES container_ident(id), title TEXT NOT NULL, - license TEXT, -- TODO: ? - release_type TEXT NOT NULL, -- TODO: enum + release_type TEXT, -- TODO: enum date TEXT, -- XXX: datetime doi TEXT, -- TODO: identifier table? volume TEXT, @@ -131,6 +131,8 @@ CREATE TABLE release_rev ( issue TEXT ); +CREATE INDEX release_rev_doi_idx ON release_rev(doi) WHERE doi IS NOT NULL; + CREATE TABLE release_ident ( id UUID PRIMARY KEY DEFAULT uuid_generate_v4(), is_live BOOL NOT NULL DEFAULT false, diff --git a/rust/src/database_schema.rs b/rust/src/database_schema.rs index 789ed1f3..f355107a 100644 --- a/rust/src/database_schema.rs +++ b/rust/src/database_schema.rs @@ -29,7 +29,6 @@ table! { container_rev (id) { id -> Int8, name -> Text, - parent_ident_id -> Nullable<Int8>, publisher -> Nullable<Text>, issn -> Nullable<Text>, } @@ -159,8 +158,7 @@ table! { work_ident_id -> Uuid, container_ident_id -> Nullable<Uuid>, title -> Text, - license -> Nullable<Text>, - release_type -> Text, + release_type -> Nullable<Text>, date -> Nullable<Text>, doi -> Nullable<Text>, volume -> Nullable<Text>, |