# This file is autogenerated. Instead of editing this file, please use the
# migrations feature of ActiveRecord to incrementally modify your database, and
# then regenerate this schema definition.

ActiveRecord::Schema.define(:version => 16) do

  create_table "cargos", :force => true do |t|
    t.column "nombre", :string, :limit => 30
    t.column "interno", :boolean
    t.column "alias", :string, :limit => 20
  end

  create_table "cargos_tareas", :id => false, :force => true do |t|
    t.column "cargo_id", :integer
    t.column "tarea_id", :integer
  end

  create_table "charlie_brown", :force => true do |t|
    t.column "tarea_id", :integer
    t.column "socio_actual_id", :integer
  end

  create_table "direcciones", :force => true do |t|
    t.column "socio_id", :integer
    t.column "direccion", :string, :limit => 60
    t.column "prioridad", :integer
    t.column "observaciones", :text
    t.column "type", :string, :limit => 20
  end

  create_table "mandatos", :force => true do |t|
    t.column "socio_id", :integer
    t.column "cargo_id", :integer
    t.column "fecha_inicio", :datetime
    t.column "fecha_fin", :datetime
    t.column "observaciones", :text
  end

  create_table "socio_tareas", :force => true do |t|
    t.column "socio_id", :integer
    t.column "tarea_id", :integer
    t.column "orden", :integer
    t.column "asignacion", :string, :limit => 10, :default => "potencial"
  end

  create_table "socios", :force => true do |t|
    t.column "nick", :string, :limit => 20
    t.column "nombre", :string, :limit => 30
    t.column "apellidos", :string, :limit => 60
    t.column "dni", :string, :limit => 10
    t.column "fecha_nacimiento", :date
    t.column "direccion", :string, :limit => 250
    t.column "provincia_id", :integer
    t.column "municipio_id", :integer
    t.column "localidad", :string, :limit => 250
    t.column "codigo_postal", :string, :limit => 10
    t.column "id_gpg", :string, :limit => 10
    t.column "observaciones", :text
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
  end

  create_table "subscripciones", :force => true do |t|
    t.column "socio_id", :integer
    t.column "tipo", :string, :limit => nil
    t.column "cuota", :integer
    t.column "fecha_inicio", :datetime
    t.column "fecha_fin", :datetime
  end

  create_table "tareas", :force => true do |t|
    t.column "titulo", :string, :limit => 50
    t.column "descripcion", :text
    t.column "fecha_limite", :date
    t.column "responsable_id", :integer
    t.column "created_at", :datetime
    t.column "updated_at", :datetime
  end

  create_table "telefonos", :force => true do |t|
    t.column "socio_id", :integer
    t.column "numero", :string, :limit => 12
    t.column "tipo", :string, :limit => 20
    t.column "observaciones", :text
    t.column "prioridad", :integer
  end

  create_table "users", :force => true do |t|
    t.column "login", :string
    t.column "email", :string
    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
  end

end