class CreateEsaTables

# File lib/generators/event_sourced_accounting/templates/migration.rb, line 145
def self.down
  remove_foreign_key :esa_accounts, name: "esa_accounts_chart_id_fk"
  remove_foreign_key :esa_amounts, name: "esa_amounts_account_id_fk"
  remove_foreign_key :esa_amounts, name: "esa_amounts_transaction_id_fk"
  remove_foreign_key :esa_contexts, name: "esa_contexts_account_id_fk"
  remove_foreign_key :esa_contexts, name: "esa_contexts_chart_id_fk"
  remove_foreign_key :esa_contexts, name: "esa_contexts_parent_id_fk"
  remove_foreign_key :esa_events, name: "esa_events_ruleset_id_fk"
  remove_foreign_key :esa_flags, name: "esa_flags_event_id_fk"
  remove_foreign_key :esa_flags, name: "esa_flags_ruleset_id_fk"
  remove_foreign_key :esa_rulesets, name: "esa_rulesets_chart_id_fk"
  remove_foreign_key :esa_transactions, name: "esa_transactions_flag_id_fk"

  drop_table :esa_charts
  drop_table :esa_accounts
  drop_table :esa_events
  drop_table :esa_flags
  drop_table :esa_transactions
  drop_table :esa_rulesets
  drop_table :esa_amounts
  drop_table :esa_contexts
end

# File lib/generators/event_sourced_accounting/templates/migration.rb, line 2
def self.up
  create_table :esa_charts do |t|
    t.string :name

    t.timestamps
  end
  add_index :esa_charts, :name, :unique => true

  create_table :esa_accounts do |t|
    t.string     :code
    t.string     :name
    t.string     :type
    t.boolean    :contra
    t.string     :normal_balance
    t.references :chart

    t.timestamps
  end
  add_index :esa_accounts, [:chart_id, :name], :unique => true
  add_index :esa_accounts, [:chart_id, :name, :type]
  add_index :esa_accounts, :normal_balance

  create_table :esa_events, :force => true do |t|
    t.string     :type
    t.datetime   :time
    t.string     :nature
    t.boolean    :processed
    t.references :accountable, :polymorphic => true
    t.references :ruleset

    t.timestamps
  end
  add_index :esa_events, :type
  add_index :esa_events, :time
  add_index :esa_events, :nature
  add_index :esa_events, [:accountable_id, :accountable_type], :name => "index_accountable_on_events"
  add_index :esa_events, :ruleset_id
  add_index :esa_events, [:time, :nature, :accountable_id, :accountable_type], :unique => true, :name => "unique_contents_on_events"

  create_table :esa_flags, :force => true do |t|
    t.string     :type
    t.datetime   :time
    t.string     :nature
    t.boolean    :state
    t.integer    :transition, :limit => 1
    t.boolean    :processed
    t.boolean    :adjusted
    t.datetime   :adjustment_time
    t.references :accountable, :polymorphic => true
    t.references :event
    t.references :ruleset

    t.timestamps
  end
  add_index :esa_flags, :type
  add_index :esa_flags, :time
  add_index :esa_flags, :nature
  add_index :esa_flags, [:accountable_id, :accountable_type], :name => "index_accountable_on_flags"
  add_index :esa_flags, :event_id
  add_index :esa_flags, :ruleset_id
  add_index :esa_flags, [:time, :nature, :accountable_id, :accountable_type], :unique => true, :name => "unique_contents_on_flags"

  create_table :esa_transactions do |t|
    t.string     :type
    t.datetime   :time
    t.string     :description
    t.references :accountable, :polymorphic => true
    t.references :flag

    t.timestamps
  end
  add_index :esa_transactions, [:accountable_id, :accountable_type], :name => "index_accountable_on_transactions"
  add_index :esa_transactions, [:time, :description, :accountable_id, :accountable_type], :unique => true, :name => "unique_contents_on_transactions"

  create_table :esa_rulesets, :force => true do |t|
    t.string     :type
    t.string     :name
    t.references :chart

    t.timestamps
  end
  add_index :esa_rulesets, :type
  add_index :esa_rulesets, :chart_id

  create_table :esa_amounts do |t|
    t.string     :type
    t.references :account
    t.references :transaction
    t.decimal    :amount, :precision => 20, :scale => 10

    t.timestamps
  end 
  add_index :esa_amounts, :type
  add_index :esa_amounts, [:account_id, :transaction_id]
  add_index :esa_amounts, [:transaction_id, :account_id]
  add_index :esa_amounts, [:type, :account_id, :transaction_id, :amount], :unique => true, :name => "unique_contents_on_amounts"

  create_table :esa_contexts do |t|
    t.string     :type
    t.string     :name
    t.references :chart
    t.references :parent
    t.references :account
    t.references :accountable, :polymorphic => true
    t.string     :namespace
    t.integer    :position
    t.date       :start_date
    t.date       :end_date

    t.datetime   :freshness
    t.decimal    :event_count,       :precision => 16
    t.decimal    :flag_count,        :precision => 16
    t.decimal    :transaction_count, :precision => 16
    t.decimal    :amount_count,      :precision => 16
    t.decimal    :debits_total,    :precision => 20, :scale => 10
    t.decimal    :credits_total,   :precision => 20, :scale => 10
    t.decimal    :opening_balance, :precision => 20, :scale => 10
    t.decimal    :closing_balance, :precision => 20, :scale => 10

    t.timestamps
  end
  add_index :esa_contexts, [:type, :chart_id]
  add_index :esa_contexts, :parent_id
  add_index :esa_contexts, :account_id
  add_index :esa_contexts, [:accountable_id, :accountable_type], :name => "index_accountable_on_contexts"
  add_index :esa_contexts, :namespace
  add_index :esa_contexts, :start_date
  add_index :esa_contexts, :end_date
  add_index :esa_contexts, :freshness

  add_foreign_key :esa_accounts, :esa_charts, column: 'chart_id'
  add_foreign_key :esa_events, :esa_rulesets, column: 'ruleset_id'
  add_foreign_key :esa_flags, :esa_events, column: 'event_id'
  add_foreign_key :esa_flags, :esa_rulesets, column: 'ruleset_id'
  add_foreign_key :esa_transactions, :esa_flags, column: 'flag_id'
  add_foreign_key :esa_rulesets, :esa_charts, column: 'chart_id'
  add_foreign_key :esa_amounts, :esa_accounts, column: 'account_id'
  add_foreign_key :esa_amounts, :esa_transactions, column: 'transaction_id'
  add_foreign_key :esa_contexts, :esa_charts, column: 'chart_id'
  add_foreign_key :esa_contexts, :esa_contexts, column: 'parent_id'
  add_foreign_key :esa_contexts, :esa_accounts, column: 'account_id'
end