summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-08-20 01:18:10 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-08-20 01:18:10 -0700
commitb8ca8ebdae304dcc2a694e5dfbc9070003f0df8a (patch)
treea54dfa8362341907ca38bd3e1bdd671b4e55097d /rust/migrations/2018-05-12-001226_init/up.sql
parent657c1e7d4d6f07762bc1f6a7b24e9512e0089987 (diff)
downloadfatcat-b8ca8ebdae304dcc2a694e5dfbc9070003f0df8a.tar.gz
fatcat-b8ca8ebdae304dcc2a694e5dfbc9070003f0df8a.zip
use index_val, not index, in 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.sql8
1 files changed, 4 insertions, 4 deletions
diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql
index 024273a7..b0733576 100644
--- a/rust/migrations/2018-05-12-001226_init/up.sql
+++ b/rust/migrations/2018-05-12-001226_init/up.sql
@@ -276,7 +276,7 @@ CREATE TABLE release_contrib (
creator_ident_id UUID REFERENCES creator_ident(id),
raw_name TEXT,
role TEXT, -- TODO: enum?
- index BIGINT,
+ index_val BIGINT,
extra_json JSON
);
@@ -287,7 +287,7 @@ CREATE TABLE release_ref (
id BIGSERIAL PRIMARY KEY,
release_rev UUID REFERENCES release_rev(id) NOT NULL,
target_release_ident_id UUID REFERENCES release_ident(id), -- or work?
- index BIGINT,
+ index_val BIGINT,
key TEXT,
extra_json JSON, -- title, year, container_title, locator (aka, page), oci_id
container_title TEXT,
@@ -432,12 +432,12 @@ 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_name, role, index) VALUES
+INSERT INTO release_contrib (release_rev, creator_ident_id, raw_name, role, index_val) 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);
-INSERT INTO release_ref (release_rev, target_release_ident_id, index, extra_json) VALUES
+INSERT INTO release_ref (release_rev, target_release_ident_id, index_val, extra_json) VALUES
('00000000-0000-0000-4444-FFF000000002', null, null, null),
('00000000-0000-0000-4444-FFF000000002', '00000000-0000-0000-4444-000000000001', 4, '{"unstructured":"citation note"}'),
('00000000-0000-0000-4444-FFF000000003', null, 0, '{"unstructured": "Ioannidis JP, Haidich AB, Lau J. Any casualties in the clash of randomised and observational evidence? BMJ. 2001;322:879–880"}'),