From 79807ca16c98c5f75e08624a514ba2afe585373a Mon Sep 17 00:00:00 2001
From: Bryan Newbold <bnewbold@robocracy.org>
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

