class CreateOrders < ActiveRecord::Migration
  def change
    create_table :orders do |t|
      t.string :customer_name
      t.string :customer_contact
      t.text :comment
      t.boolean :ordered,   :null => false, :default => false
      t.boolean :processed, :null => false, :default => false
      t.timestamps
    end

    create_table :orders_products, :id => false do |t|
      t.references :order,   :null => false
      t.references :product, :null => false
    end
    add_index :orders_products, [:order_id, :product_id]

  end
end