diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-07-25 14:38:57 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-07-25 14:39:09 -0700 |
| commit | 24f323669212735f3facbe4f417b5f20ba1c5c00 (patch) | |
| tree | 7617d99a76cf8357d0730d96722dbbfc21dd7b21 /rust/migrations/2018-05-12-001226_init | |
| parent | c4618dd2fb070eefcdb38bca7b92fe32da766702 (diff) | |
| download | fatcat-24f323669212735f3facbe4f417b5f20ba1c5c00.tar.gz fatcat-24f323669212735f3facbe4f417b5f20ba1c5c00.zip | |
contribs: raw -> raw_name
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init')
| -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 7b344dc0..f96df38a 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -267,7 +267,7 @@ CREATE TABLE release_contrib ( id BIGSERIAL PRIMARY KEY, release_rev UUID REFERENCES release_rev(id) NOT NULL, creator_ident_id UUID REFERENCES creator_ident(id), - raw TEXT, + raw_name TEXT, role TEXT, -- TODO: enum? index BIGINT, extra_json JSON @@ -282,7 +282,7 @@ CREATE TABLE release_ref ( target_release_ident_id UUID REFERENCES release_ident(id), -- or work? index BIGINT, key TEXT, - extra_json JSON, -- title, year, container_title, locator (aka, page) + extra_json JSON, -- title, year, container_title, locator (aka, page), oci_id container_title TEXT, year BIGINT, title TEXT, @@ -425,7 +425,7 @@ INSERT INTO release_rev_abstract (release_rev, abstract_sha1, mimetype, lang) VA ('00000000-0000-0000-4444-FFF000000001', '1ba86bf8c2979a62d29b18b537e50b2b093be27e', 'text/plain', 'en'), ('00000000-0000-0000-4444-FFF000000002', '0da908ab584b5e445a06beb172e3fab8cb5169e3', 'application/xml+jats', 'en'); -INSERT INTO release_contrib (release_rev, creator_ident_id, raw, role, index) VALUES +INSERT INTO release_contrib (release_rev, creator_ident_id, raw_name, role, index) VALUES ('00000000-0000-0000-4444-FFF000000002', null, null, null, null), ('00000000-0000-0000-4444-FFF000000002', '00000000-0000-0000-2222-000000000002', 'some contrib', 'editor', 4), ('00000000-0000-0000-4444-FFF000000003', '00000000-0000-0000-2222-000000000003', 'John P. A. Ioannidis', 'author', 0); |