class CreateUsers < ActiveRecord::Migration
  def self.up
    create_table "users", :force => true do |t|
      t.column :type,                       :string
      t.column :users,                      :string
      t.column :email,                      :string
      t.column :firstname,                  :string
      t.column :middlename,                 :string
      t.column :lastname,                   :string
      t.column :phone,                      :integer, :limit => 10
      t.column :crypted_password,           :string, :limit => 40
      t.column :salt,                       :string, :limit => 40
      t.column :created_at,                 :datetime
      t.column :updated_at,                 :datetime
      t.column :remember_token,             :string
      t.column :remember_token_expires_at,  :datetime
      t.column :activation_code,            :string, :limit => 40
      t.column :activated_at,               :datetime
      # admin info

      # sponsor info
      t.column :title,                      :string
      t.column :department,                 :string
      t.column :sponsor_name,               :string
      t.column :sponsor_type,               :string
      t.column :address1,                   :string
      t.column :address2,                   :string
      t.column :city,                       :string
      t.column :state,                      :string
      t.column :zip,                        :integer, :limit => 9
      t.column :website,                    :string
      # student info
      t.column :major,                      :string
      t.timestamps
    end
  end

  def self.down
    drop_table "users"
  end
end