class AddExtraFieldsToUsers < ActiveRecord::Migration[5.0]
  def change

    add_column :users, :full_name,	 :string, 	null: false, default: ""
    add_column :users, :dob, 		 :date
    add_column :users, :bio, 		 :text
    add_column :users, :avatar,      :string, default: ""
    add_column :users, :safe_url,    :string, default: ""

    # info extra
    add_column :users, :objective,   :string, default: "" #null: false, 
    add_column :users, :tel, 		 :string, default: "" #null: false, 
    add_column :users, :height, 	 :string, default: "" #null: false, 
    add_column :users, :sex, 		 :string, default: "" #null: false, 
	
  	#    
  	add_column :users, :presencial,  :boolean,	null: false, default: true
  	add_column :users, :role,		 :string,	  null: false, default: "patient"

    # api
    add_column :users, :auth_token, :string, default: ""

    # confirmation
    add_column :users, :confirmation_token, :string
    add_column :users, :confirmed_at, :datetime
    add_column :users, :confirmation_sent_at, :datetime
    add_column :users, :unconfirmed_email, :string

    # fotos iniciales, peso y grasa
    add_column :users, :back,       :string,  default: ""
    add_column :users, :side,       :string,  default: ""
    add_column :users, :front,      :string,  default: ""
    add_column :users, :corporal_fat, :decimal
    add_column :users, :kg,          :integer
    add_column :users, :tmb,         :integer
    add_column :users, :customer_id, :string # conekta

    # Para control de expiración de planes ordenados por y entrenador
    add_column :users, :last_plan,  :date
    add_column :users, :status,  :string, default: "inactive"
    add_column :users, :coach_id, :integer
    add_index :users, :coach_id

  end
end