56 lines
1.4 KiB
Ruby
56 lines
1.4 KiB
Ruby
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
|