3scale/porta

class AddPrimaryKeyToBackendEvents < ActiveRecord::Migration[5.2]
  def up
    if System::Database.mysql?
      execute 'ALTER TABLE backend_events ADD PRIMARY KEY (id)'
      remove_index :backend_events, :id
    elsif System::Database.postgres?
      execute 'ALTER TABLE backend_events ADD CONSTRAINT backend_events_pk PRIMARY KEY (id)'
      remove_index :backend_events, :id
    else
      remove_index :backend_events, :id
      execute 'ALTER TABLE BACKEND_EVENTS MODIFY ID PRIMARY KEY'
    end
  end
end