Sha256: 9deaba1f5d9737f2dd55fec66f56ce69e46ab55d7beab2a0d1a193207d2c4414
Contents?: true
Size: 1.22 KB
Versions: 20
Compression:
Stored size: 1.22 KB
Contents
class CreateParticipation < ActiveRecord::Migration
def self.up
create_table(:participations, :options => Zena::Db.table_options) do |t|
t.column :user_id, :integer
t.column :site_id, :integer
t.column :status, :integer
t.column :contact_id, :integer
end
values = select_all("SELECT * FROM sites_users").map do |r|
"(#{['user_id','site_id','status','contact_id'].map {|k| quote(r[k])}.join(', ')})"
end
execute "INSERT INTO participations (user_id,site_id,status,contact_id) VALUES #{values.join(', ')}" unless values == []
Zena::Db.add_unique_key('participations', %w{user_id site_id})
drop_table :sites_users
end
def self.down
create_table(:sites_users, :id=>false,:options => Zena::Db.table_options) do |t|
t.column :user_id, :integer
t.column :site_id, :integer
t.column :status, :integer
t.column :contact_id, :integer
end
values = select_all("SELECT * FROM participations").map do |r|
"(#{['user_id','site_id','status','contact_id'].map {|k| quote(r[k])}.join(', ')})"
end
execute "INSERT INTO sites_users (user_id,site_id,status,contact_id) VALUES #{values.join(', ')}" unless values == []
drop_table :participations
end
end
Version data entries
20 entries across 20 versions & 1 rubygems