# -*- coding: utf-8 -*-
class CreateCompanies < ActiveRecord::Migration

  def self.up
    create_table :companies do |t|
      t.string :name
      t.integer :code
      t.decimal :inn, :precision => 12, :scale => 0
    end
    
    add_column :reports, :customer_id, :integer
    add_column :reports, :contractor_id, :integer
    add_column :category, :customer_id, :integer
    add_column :category, :contractor_id, :integer

 
   #  Company.create(:name => "Сторонняя организация", :code => "0")
   #  Company.create(:name => "Оператор", :code => "10")
   #  Company.create(:name => "Кроникс Плюс", :code => "1")
   #  Company.create(:name => "РуссНет", :code => "2")
   #  Company.create(:name => "Кроникс Сервис", :code => "3")
   #  Company.create(:name => "Рицентр", :code => "4")
   #  Company.create(:name => "Центрдом", :code => "5")
   #  Company.create(:name => "НКС", :code => "6")
   # Company.create(:name => "ССТ", :code => "7")

  end 

  def self.down
#    drop_table :companies
#    remove_column :reports, :customer_id
#    remove_column :reports, :contractor_id
#    remove_column :category, :customer_id
#   remove_column :category, :contractor_id
  end

end