summaryrefslogtreecommitdiffstats
path: root/rust/migrations/2018-05-12-001226_init/up.sql
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2018-05-25 18:43:38 -0700
committerBryan Newbold <bnewbold@robocracy.org>2018-05-25 18:43:38 -0700
commit79807ca16c98c5f75e08624a514ba2afe585373a (patch)
treeae92957724d3d0cd56a4d0d31188603111cf635c /rust/migrations/2018-05-12-001226_init/up.sql
parentf8d9d4f92bcb491d54360e335745056be0de19e2 (diff)
downloadfatcat-79807ca16c98c5f75e08624a514ba2afe585373a.tar.gz
fatcat-79807ca16c98c5f75e08624a514ba2afe585373a.zip
index for contribs
Diffstat (limited to 'rust/migrations/2018-05-12-001226_init/up.sql')
-rw-r--r--rust/migrations/2018-05-12-001226_init/up.sql11
1 files changed, 6 insertions, 5 deletions
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),