class InitialSchema < ActiveRecord::Migration
  def self.up  
    create_table "accounts", :force => true do |t|
      t.column "created_on", :timestamp
      t.column "updated_on", :timestamp
      t.column "login", :string, :limit => 45, :default => "", :null => false
      t.column "password", :string, :limit => 45
      t.column "name", :string, :limit => 45
      t.column "company_id", :integer
      t.column "admin", :boolean, :default => false
    end
  
    add_index "accounts", ["login"], :name => "login", :unique => true
    add_index "accounts", ["company_id"], :name => "company_id"
    add_index "accounts", ["admin"], :name => "admin"
    add_index "accounts", ["name"], :name => "name"
  
    create_table "companies", :force => true do |t|
      t.column "name", :string, :default => "", :null => false
      t.column "url", :string, :default => "", :null => false
      t.column "account_id", :integer, :default => 0, :null => false
      t.column "description", :text
      t.column "developer_count", :integer
      t.column "technologies", :string
      t.column "phone", :string, :limit => 18
      t.column "email", :string, :limit => 50
      t.column "address", :string
      t.column "city", :string, :limit => 40
      t.column "state", :string, :limit => 20
      t.column "country", :string, :limit => 40, :default => "United States"
      t.column "postal_code", :string, :limit => 20
      t.column "created_on", :timestamp
      t.column "updated_on", :timestamp
    end
  
    add_index "companies", ["name"], :name => "name"
  
    create_table "events", :force => true do |t|
      t.column "name", :string, :default => "", :null => false
      t.column "description", :text
      t.column "time", :timestamp
      t.column "location", :text
      t.column "note", :text
      t.column "special_request_choices", :text
      t.column "created_on", :timestamp
      t.column "updated_on", :timestamp
    end
  
    add_index "events", ["time"], :name => "time"
  
    create_table "notes", :force => true do |t|
      t.column "created_on", :timestamp
    end
  
    create_table "payments", :force => true do |t|
      t.column "created_on", :timestamp
      t.column "updated_on", :timestamp
      t.column "amount", :float, :default => 40.0, :null => false
      t.column "medium", :string, :limit => 15, :default => "", :null => false
      t.column "notation", :string, :limit => 45, :default => "", :null => false
      t.column "account_id", :integer, :limit => 10, :default => 0, :null => false
      t.column "company_id", :integer, :limit => 10, :default => 0
    end
  
    add_index "payments", ["account_id"], :name => "account_id"
    add_index "payments", ["created_on"], :name => "created_on"
    add_index "payments", ["updated_on"], :name => "updated_on"
    add_index "payments", ["amount"], :name => "amount"
    add_index "payments", ["medium"], :name => "medium"
  
    create_table "rsvps", :force => true do |t|
      t.column "created_on", :timestamp
      t.column "updated_on", :timestamp
      t.column "account_id", :integer, :default => 0, :null => false
      t.column "event_id", :integer, :default => 0, :null => false
      t.column "guest_count", :integer, :default => 0, :null => false
      t.column "comment", :string
      t.column "status", :string, :limit => 10, :default => "Yes"
      t.column "special_request", :text
    end
  
    add_index "rsvps", ["account_id"], :name => "account_id"
    add_index "rsvps", ["event_id"], :name => "event_id"
    add_index "rsvps", ["status"], :name => "status"
  end

  def self.down
  end
end