class CreateEffectiveOrders < ActiveRecord::Migration[4.2]
  def self.up
    create_table <%= @orders_table_name %> do |t|
      t.integer   :user_id
      t.string    :purchase_state
      t.datetime  :purchased_at

      t.text      :note
      t.text      :note_to_buyer
      t.text      :note_internal

      t.text      :payment

      t.string    :payment_provider
      t.string    :payment_card

      t.decimal   :tax_rate, :precision => 6, :scale => 3

      t.integer   :subtotal
      t.integer   :tax
      t.integer   :total

      t.timestamps
    end

    add_index <%= @orders_table_name %>, :user_id


    create_table <%= @order_items_table_name %> do |t|
      t.integer   :order_id
      t.integer   :seller_id
      t.string    :purchasable_type
      t.integer   :purchasable_id

      t.string    :title
      t.integer   :quantity
      t.integer   :price, :default => 0
      t.boolean   :tax_exempt

      t.timestamps
    end

    add_index <%= @order_items_table_name %>, :order_id
    add_index <%= @order_items_table_name %>, :purchasable_id
    add_index <%= @order_items_table_name %>, [:purchasable_type, :purchasable_id]


    create_table <%= @carts_table_name %> do |t|
      t.integer   :user_id
      t.timestamps
    end

    add_index <%= @carts_table_name %>, :user_id

    create_table <%= @cart_items_table_name %> do |t|
      t.integer   :cart_id
      t.string    :purchasable_type
      t.integer   :purchasable_id

      t.integer   :quantity

      t.timestamps
    end

    add_index <%= @cart_items_table_name %>, :cart_id
    add_index <%= @cart_items_table_name %>, :purchasable_id
    add_index <%= @cart_items_table_name %>, [:purchasable_type, :purchasable_id]

    create_table <%= @customers_table_name %> do |t|
      t.integer   :user_id
      t.string    :stripe_customer_id
      t.string    :stripe_active_card
      t.string    :stripe_connect_access_token

      t.timestamps
    end

    add_index <%= @customers_table_name %>, :user_id

    create_table <%= @subscriptions_table_name %> do |t|
      t.integer   :customer_id
      t.string    :stripe_plan_id
      t.string    :stripe_subscription_id
      t.string    :stripe_coupon_id
      t.string    :title
      t.integer   :price, :default => 0

      t.timestamps
    end

    add_index <%= @subscriptions_table_name %>, :customer_id
    add_index <%= @subscriptions_table_name %>, :stripe_subscription_id

    create_table <%= @products_table_name %> do |t|
      t.string    :title
      t.integer   :price, :default => 0
      t.boolean   :tax_exempt, :default => false

      t.timestamps
    end
  end

  def self.down
    drop_table <%= @orders_table_name %>
    drop_table <%= @order_items_table_name %>
    drop_table <%= @carts_table_name %>
    drop_table <%= @cart_items_table_name %>
    drop_table <%= @customers_table_name %>
    drop_table <%= @subscriptions_table_name %>
    drop_table <%= @products_table_name %>
  end
end