Contents

class AddSitesUsers < ActiveRecord::Migration
  def self.up
    create_table :sites_users, :id => false do |t|
      t.column :site_id, :integer
      t.column :user_id, :integer
    end
    
    add_index :sites_users, [:site_id, :user_id], :unique => true
    add_index :sites_users, :user_id
  end
  
  
  def self.down
    remove_index :sites_users, [:site_id, :user_id]
    remove_index :sites_users, :user_id
    drop_table :sites_users
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
radiant-vhost-extension-2.3.1	db/migrate/002_add_sites_users.rb
radiant-vhost-extension-2.3.0	db/migrate/002_add_sites_users.rb
radiant-vhost-extension-2.2.0	db/migrate/002_add_sites_users.rb
radiant-vhost-extension-2.1.0	db/migrate/002_add_sites_users.rb