X-Git-Url: https://git.arvados.org/arvados.git/blobdiff_plain/86c4b60b5f9e8ab1f20eeee1da0afce3db57ab3b..0eb72b526bf8bbb011551ecf019f604e17a534f1:/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb diff --git a/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb b/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb index f84c6352e0..a226836b6b 100644 --- a/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb +++ b/services/api/db/migrate/20140817035914_add_unique_name_constraints.rb @@ -1,7 +1,11 @@ +# Copyright (C) The Arvados Authors. All rights reserved. +# +# SPDX-License-Identifier: AGPL-3.0 + class AddUniqueNameConstraints < ActiveRecord::Migration def change # Ensure uniqueness before adding constraints. - ["collections", "pipeline_templates", "pipeline_instances", "jobs", "groups"].each do |table| + ["collections", "pipeline_templates", "groups"].each do |table| rows = ActiveRecord::Base.connection.select_all %{ select uuid, owner_uuid, name from #{table} order by owner_uuid, name } @@ -24,10 +28,6 @@ update #{table} set name='#{r["name"]} #{n}' where uuid='#{r["uuid"]}' name: 'collection_owner_uuid_name_unique') add_index(:pipeline_templates, [:owner_uuid, :name], unique: true, name: 'pipeline_template_owner_uuid_name_unique') - add_index(:pipeline_instances, [:owner_uuid, :name], unique: true, - name: 'pipeline_instance_owner_uuid_name_unique') - add_index(:jobs, [:owner_uuid, :name], unique: true, - name: 'jobs_owner_uuid_name_unique') add_index(:groups, [:owner_uuid, :name], unique: true, name: 'groups_owner_uuid_name_unique') end