class CreateEffectiveEvents < ActiveRecord::Migration[6.0]
  def change
    create_table <%= @events_table_name %> do |t|
      t.string :title

      t.string :slug
      t.boolean :draft, default: false

      t.datetime :start_at
      t.datetime :end_at

      t.datetime :registration_start_at
      t.datetime :registration_end_at
      t.datetime :early_bird_end_at

      t.integer :event_registrants_count, default: 0
      t.integer :event_purchases_count, default: 0

      t.integer :roles_mask
      t.boolean :authenticate_user, default: false

      t.timestamps
    end

    add_index <%= @events_table_name %>, :title
    add_index <%= @events_table_name %>, :end_at

    create_table <%= @event_tickets_table_name %> do |t|
      t.integer :event_id

      t.string :title
      t.integer :capacity

      t.integer :regular_price
      t.integer :early_bird_price

      t.string :qb_item_name
      t.boolean :tax_exempt, default: false

      t.integer :position
      t.boolean :archived, default: false

      t.timestamps
    end

    create_table <%= @event_registrants_table_name %> do |t|
      t.integer :event_id
      t.integer :event_ticket_id

      t.integer :owner_id
      t.string :owner_type

      t.integer :event_registration_id
      t.string :event_registration_type

      t.string :first_name
      t.string :last_name
      t.string :email

      t.string :company
      t.string :number
      t.text :notes

      t.integer :purchased_order_id
      t.integer :price

      t.timestamps
    end

    create_table <%= @event_products_table_name %> do |t|
      t.integer :event_id

      t.string :title
      t.integer :capacity

      t.integer :price

      t.string :qb_item_name
      t.boolean :tax_exempt, default: false

      t.integer :position
      t.boolean :archived, default: false

      t.timestamps
    end

    create_table <%= @event_purchases_table_name %> do |t|
      t.integer :event_id
      t.integer :event_product_id

      t.integer :owner_id
      t.string :owner_type

      t.integer :event_registration_id
      t.string :event_registration_type

      t.text :notes

      t.integer :purchased_order_id
      t.integer :price

      t.timestamps
    end

    create_table <%= @event_registrations_table_name %> do |t|
      t.string :token

      t.integer :event_id

      t.integer :owner_id
      t.string :owner_type

      t.integer :user_id
      t.string :user_type

      # Acts as Statused
      t.string :status
      t.text :status_steps

      # Acts as Wizard
      t.text :wizard_steps

      # Dates
      t.datetime :submitted_at

      t.datetime :updated_at
      t.datetime :created_at
    end

    add_index <%= @event_registrations_table_name %>, [:owner_id, :owner_type]
    add_index <%= @event_registrations_table_name %>, :status
    add_index <%= @event_registrations_table_name %>, :token

  end
end