class CreateDebTables

Public Class Methods

down() click to toggle source
# File lib/generators/deb/templates/migration.rb, line 36
def self.down
  drop_table :deb_accounts
  drop_table :deb_transactions
  drop_table :deb_items
end
up() click to toggle source
# File lib/generators/deb/templates/migration.rb, line 2
def self.up
  create_table :deb_accounts do |t|
    t.string :name
    t.string :kind
    t.string :short_name, limit: 16
    t.references :accountable, polymorphic: true
    t.boolean :contra
    t.decimal :current_balance, precision: 20, scale: 2, default: 0
    t.timestamps
  end
  add_index :deb_accounts, :short_name
  add_index :deb_accounts, [:accountable_type, :accountable_id, :kind], name: "deb_accounts_default"

  create_table :deb_transactions do |t|
    t.string :description
    t.string :kind, limit: 16
    t.references :transactionable, polymorphic: true
    t.integer :rollback_transaction_id
    t.timestamps
  end
  add_index :deb_transactions, [:transactionable_type, :transactionable_id, :kind], name: "deb_transactions_default"

  create_table :deb_items do |t|
    t.string :kind
    t.integer :account_id
    t.integer :transaction_id
    t.decimal :amount, precision: 20, scale: 2, default: 0
    t.decimal :balance_before, precision: 20, scale: 2, default: 0
    t.decimal :balance_after, precision: 20, scale: 2, default: 0
  end 
  add_index :deb_items, :account_id
  add_index :deb_items, [:transaction_id, :kind]
end