Chris@1464: class CreateQueriesRoles < ActiveRecord::Migration
Chris@1464:   def self.up
Chris@1464:     create_table :queries_roles, :id => false do |t|
Chris@1464:       t.column :query_id, :integer, :null => false
Chris@1464:       t.column :role_id, :integer, :null => false
Chris@1464:     end
Chris@1464:     add_index :queries_roles, [:query_id, :role_id], :unique => true, :name => :queries_roles_ids
Chris@1464:   end
Chris@1464: 
Chris@1464:   def self.down
Chris@1464:     drop_table :queries_roles
Chris@1464:   end
Chris@1464: end