class CreateOrders < ActiveRecord::Migration
  def change
    create_table :orders do |t|
      t.string :email
      t.string :subtotal, :precision => 15, :scale => 10
      t.string :partner_id
      t.string :total, :precision => 15, :scale => 10
      t.string :firstname
      t.string :name
      t.string :street1
      t.string :street2
      t.string :cityname
      t.string :state_or_province 
      t.string :country
      t.string :payment_type
      t.datetime :paid_at
      t.boolean :paid
      t.string :postal_code
      t.string :token
      t.string :sheet_token
      
      
      t.string :paypal_test_ipn

      t.string :paypal_txn_type
      t.string :paypal_txn_id
      t.datetime :paypal_payment_date

      t.string :paypal_payment_status
      t.string :paypal_reason_code
      t.string :paypal_payment_type

      t.string :paypal_mc_currency
      t.string :paypal_mc_fee
      t.string :paypal_mc_gross
  
      t.string :paypal_residence_country
      t.string :paypal_last_name
      t.string :paypal_first_name
      t.string :paypal_payer_email
      t.string :paypal_payer_id
      t.string :paypal_payer_status

      t.string :paypal_receiver_id
      t.string :paypal_receiver_email

      t.string :paypal_protection_eligibility
      t.string :paypal_ipn_track_id

      t.integer :downloads_count
      
      t.timestamps
    end
  end
end