Sha256: 16bec94165e8a91754089e64a623bd9b2e1180b7d5c9d8e349d578113a7f84ac

Contents?: true

Size: 930 Bytes

Versions: 33

Compression:

Stored size: 930 Bytes

Contents

class MergeParticipationIntoUsers < ActiveRecord::Migration
  def self.up
    add_column :users, :site_id, :integer
    Zena::Db.update_value('users.site_id', :from => 'participations.site_id',
                          :where => "users.id=participations.user_id")

    add_column :users, :status, :integer
    Zena::Db.update_value('users.status', :from => 'participations.status',
                          :where => "users.id=participations.user_id")

    add_column :users, :contact_id, :integer
    Zena::Db.update_value('users.contact_id', :from => 'participations.contact_id',
                          :where => "users.id=participations.user_id")

    add_column    :users, :lang, :string, :limit => 10, :default => "", :null => false
    Zena::Db.update_value('users.lang', :from => 'participations.lang',
                          :where => 'users.id = participations.user_id')

    drop_table :participations
  end
end

Version data entries

33 entries across 33 versions & 1 rubygems

Version Path
zena-1.2.8 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.7 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.6 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.5 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.4 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.3 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.2 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.1 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.2.0 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.1.3 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.1.2 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.1.1 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.1.0 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.0.0 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.0.0.rc3 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.0.0.rc2 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-1.0.0.rc1 db/fix/old_migrations/20091014183726_merge_participation_into_users.rb
zena-0.16.9 db/migrate/20091014183726_merge_participation_into_users.rb
zena-1.0.0.beta3 db/migrate/20091014183726_merge_participation_into_users.rb
zena-0.16.8 db/migrate/20091014183726_merge_participation_into_users.rb