From 79807ca16c98c5f75e08624a514ba2afe585373a Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Fri, 25 May 2018 18:43:38 -0700 Subject: index for contribs --- rust/migrations/2018-05-12-001226_init/up.sql | 11 ++++++----- 1 file changed, 6 insertions(+), 5 deletions(-) (limited to 'rust/migrations/2018-05-12-001226_init/up.sql') diff --git a/rust/migrations/2018-05-12-001226_init/up.sql b/rust/migrations/2018-05-12-001226_init/up.sql index 41df87ea..1fbd7c09 100644 --- a/rust/migrations/2018-05-12-001226_init/up.sql +++ b/rust/migrations/2018-05-12-001226_init/up.sql @@ -187,8 +187,9 @@ CREATE TABLE release_contrib ( id BIGSERIAL PRIMARY KEY, release_rev BIGSERIAL REFERENCES release_rev(id) NOT NULL, creator_ident_id UUID REFERENCES creator_ident(id), - stub TEXT, - contrib_type TEXT + contrib_type TEXT, + index BIGINT, + stub TEXT ); CREATE TABLE release_ref ( @@ -301,9 +302,9 @@ INSERT INTO release_edit (ident_id, rev_id, redirect_id, editgroup_id) VALUES ('f1f046a3-45c9-4b99-4444-000000000001', 1, null, 4), ('f1f046a3-45c9-4b99-4444-000000000002', 2, null, 5); -INSERT INTO release_contrib (release_rev, creator_ident_id, stub, contrib_type) VALUES - (2, null, null, null), - (2, 'f1f046a3-45c9-4b99-adce-000000000002', 'some contrib', 'editor'); +INSERT INTO release_contrib (release_rev, creator_ident_id, stub, contrib_type, index) VALUES + (2, null, null, null, null), + (2, 'f1f046a3-45c9-4b99-adce-000000000002', 'some contrib', 'editor', 4); INSERT INTO release_ref (release_rev, target_release_ident_id, index, stub) VALUES (2, null, null, null), -- cgit v1.2.3