Contents

class UniqueMetasploitCredentialCores < ActiveRecord::Migration
  def down
    execute 'DROP INDEX unique_complete_metasploit_credential_cores'
    execute 'DROP INDEX unique_private_metasploit_credential_cores'
    execute 'DROP INDEX unique_public_metasploit_credential_cores'
  end

  def up
    execute 'CREATE UNIQUE INDEX unique_complete_metasploit_credential_cores ' \
            'ON metasploit_credential_cores (workspace_id, private_id, public_id) ' \
            'WHERE private_id IS NOT NULL AND ' \
                  'public_id IS NOT NULL'

    execute 'CREATE UNIQUE INDEX unique_private_metasploit_credential_cores ' \
            'ON metasploit_credential_cores (workspace_id, private_id) ' \
            'WHERE private_id IS NOT NULL AND ' \
                  'public_id IS NULL'

    execute 'CREATE UNIQUE INDEX unique_public_metasploit_credential_cores ' \
            'ON metasploit_credential_cores (workspace_id, public_id) ' \
            'WHERE private_id IS NULL AND ' \
                  'public_id IS NOT NULL'
  end
end

Version data entries

75 entries across 75 versions & 1 rubygems

Version	Path
metasploit-credential-3.0.4	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-3.0.3	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-3.0.2	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-3.0.1	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-3.0.0	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.14	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.13	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.12	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.11	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.10	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.9	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.8	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.7	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.6	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.5	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.4	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.3	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.2	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.1	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-2.0.0	db/migrate/20140728191933_unique_metasploit_credential_cores.rb