20191218000612_add_guid_and_timestamps_to_spaces_auditors.rb

Sequel.migration do
  up do
    unless self[:spaces_auditors].columns.include?(:role_guid)
      alter_table :spaces_auditors do
        add_column :role_guid, String, size: 255
        add_column :created_at, :timestamp, null: false, default: Sequel::CURRENT_TIMESTAMP
        add_column :updated_at, :timestamp, null: false, default: Sequel::CURRENT_TIMESTAMP
        add_index :role_guid, name: :spaces_auditors_role_guid_index
        add_index :created_at, name: :spaces_auditors_created_at_index
        add_index :updated_at, name: :spaces_auditors_updated_at_index
      end
    end
  end

  down do
    alter_table :spaces_auditors do
      drop_index :updated_at, name: :spaces_auditors_role_guid_index
      drop_index :created_at, name: :spaces_auditors_created_at_index
      drop_index :role_guid, name: :spaces_auditors_updated_at_index
      drop_column :updated_at
      drop_column :created_at
      drop_column :role_guid
    end
  end
end