From 93241149e646f546e9a4406e85ced66c8d54099f Mon Sep 17 00:00:00 2001 From: Grzegorz Bizon Date: Thu, 31 May 2018 16:05:40 +0200 Subject: Make pipeline / stage position index not unique --- db/migrate/20180530135500_add_index_to_stages_position.rb | 2 +- db/schema.rb | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/db/migrate/20180530135500_add_index_to_stages_position.rb b/db/migrate/20180530135500_add_index_to_stages_position.rb index e60b742a59b..61150f33a25 100644 --- a/db/migrate/20180530135500_add_index_to_stages_position.rb +++ b/db/migrate/20180530135500_add_index_to_stages_position.rb @@ -6,7 +6,7 @@ class AddIndexToStagesPosition < ActiveRecord::Migration disable_ddl_transaction! def up - add_concurrent_index :ci_stages, [:pipeline_id, :position], unique: true + add_concurrent_index :ci_stages, [:pipeline_id, :position] end def down diff --git a/db/schema.rb b/db/schema.rb index a3f27f87ff1..ebb4fa6c533 100644 --- a/db/schema.rb +++ b/db/schema.rb @@ -518,7 +518,7 @@ ActiveRecord::Schema.define(version: 20180530135500) do end add_index "ci_stages", ["pipeline_id", "name"], name: "index_ci_stages_on_pipeline_id_and_name", unique: true, using: :btree - add_index "ci_stages", ["pipeline_id", "position"], name: "index_ci_stages_on_pipeline_id_and_position", unique: true, using: :btree + add_index "ci_stages", ["pipeline_id", "position"], name: "index_ci_stages_on_pipeline_id_and_position", using: :btree add_index "ci_stages", ["pipeline_id"], name: "index_ci_stages_on_pipeline_id", using: :btree add_index "ci_stages", ["project_id"], name: "index_ci_stages_on_project_id", using: :btree -- cgit v1.2.3