Sha256: 2a251e73fb5cac46694c3019380f991e6c1c15cbd2a3ff30777dffac0d13d51a

Contents?: true

Size: 874 Bytes

Versions: 20

Compression:

Stored size: 874 Bytes

Contents

class ChangeVClassTableIntoRoles < ActiveRecord::Migration
  def self.up
    add_column(:virtual_classes, :type, :string, :limit => 32)
    add_column(:virtual_classes, :created_at, :datetime)
    add_column(:virtual_classes, :updated_at, :datetime)

    rename_table(:virtual_classes, :roles)

    create_table(:stored_columns, :options => Zena::Db.table_options) do |t|
      t.integer 'stored_role_id'
      t.string 'name'
      # Property Type
      t.string 'ptype'
    end
    execute "UPDATE roles SET type = 'VirtualClass'"
    execute "UPDATE roles SET created_at = #{Zena::Db::NOW}"
    execute "UPDATE roles SET updated_at = #{Zena::Db::NOW}"
  end

  def self.down
    remove_column(:roles, :updated_at)
    remove_column(:roles, :created_at)
    remove_column(:roles, :type)
    rename_table(:roles, :virtual_classes)
    drop_table(:stored_columns)
  end
end

Version data entries

20 entries across 20 versions & 1 rubygems

Version Path
zena-1.2.8 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.7 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.6 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.5 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.4 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.3 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.2 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.1 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.2.0 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.1.3 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.1.2 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.1.1 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.1.0 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.rc3 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.rc2 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.rc1 db/fix/old_migrations/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.beta3 db/migrate/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.beta2 db/migrate/20100422091606_change_v_class_table_into_roles.rb
zena-1.0.0.beta1 db/migrate/20100422091606_change_v_class_table_into_roles.rb