Arvados-DCO-1.1-Signed-off-by: Radhika Chippada <radhika@curoverse.com>
[arvados.git] / services / api / db / migrate / 20140817035914_add_unique_name_constraints.rb
index f84c6352e0963188826c7bf562c1e904ffdb4e5e..a226836b6b6aa29766ec8098a9897acfe0bf9318 100644 (file)
@@ -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