Contents

class UniqueMetasploitCredentialCores < ActiveRecord::Migration[4.2]
  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

29 entries across 29 versions & 1 rubygems

Version	Path
metasploit-credential-6.0.12	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.11	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.10	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.9	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.8	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.7	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.6	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.5	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.4	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.3	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.2	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.1	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-6.0.0	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.9	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.8	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.7	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.6	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.5	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.4	db/migrate/20140728191933_unique_metasploit_credential_cores.rb
metasploit-credential-5.0.3	db/migrate/20140728191933_unique_metasploit_credential_cores.rb