diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-25 18:43:38 -0700 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2018-05-25 18:43:38 -0700 |
| commit | 79807ca16c98c5f75e08624a514ba2afe585373a (patch) | |
| tree | ae92957724d3d0cd56a4d0d31188603111cf635c /rust/migrations/2018-05-12-001226_init/up.sql | |
| parent | f8d9d4f92bcb491d54360e335745056be0de19e2 (diff) | |
| download | fatcat-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.sql | 11 |
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), |