pic_vert_app/db/migrate/20190314212933_create_renews.rb
Nicolas Bally 429325823c suite
2019-06-02 18:48:14 +02:00

46 lines
1.1 KiB
Ruby

class CreateRenews < ActiveRecord::Migration
def change
create_table :renews do |t|
t.integer :year
t.references :sheet, index: true
t.string :sheet_number
t.integer :join_type
t.boolean :ok, :default => false
t.integer :payment_type_id
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.string :email
t.decimal :price, :precision => 10, :scale => 2
t.boolean :return_done, :default => false
t.timestamps
end
end
end