db/migrations/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