Software Público Brasileiro

# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
# database schema. If you need to create the application database on another
# system, you should be using db:schema:load, not running all the migrations
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended to check this file into your version control system.

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

  create_table "cities", :force => true do |t|
    t.integer  "state_id"
    t.string   "uf"
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  add_index "cities", ["state_id"], :name => "index_cities_on_state_id"

  create_table "ckeditor_assets", :force => true do |t|
    t.string   "data_file_name",                  :null => false
    t.string   "data_content_type"
    t.integer  "data_file_size"
    t.integer  "assetable_id"
    t.string   "assetable_type",    :limit => 30
    t.string   "type",              :limit => 30
    t.datetime "created_at",                      :null => false
    t.datetime "updated_at",                      :null => false
  end

  add_index "ckeditor_assets", ["assetable_type", "assetable_id"], :name => "idx_ckeditor_assetable"
  add_index "ckeditor_assets", ["assetable_type", "type", "assetable_id"], :name => "idx_ckeditor_assetable_type"

  create_table "members", :force => true do |t|
    t.string   "email",                                 :default => "", :null => false
    t.string   "encrypted_password",     :limit => 128, :default => "", :null => false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",                         :default => 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.datetime "created_at",                                            :null => false
    t.datetime "updated_at",                                            :null => false
  end

  add_index "members", ["email"], :name => "index_members_on_email", :unique => true
  add_index "members", ["reset_password_token"], :name => "index_members_on_reset_password_token", :unique => true

  create_table "pages", :force => true do |t|
    t.string   "title"
    t.text     "text"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
    t.string   "video"
  end

  create_table "rails_admin_histories", :force => true do |t|
    t.text     "message"
    t.string   "username"
    t.integer  "item"
    t.string   "table"
    t.integer  "month",      :limit => 2
    t.integer  "year",       :limit => 8
    t.datetime "created_at",              :null => false
    t.datetime "updated_at",              :null => false
  end

  add_index "rails_admin_histories", ["item", "table", "month", "year"], :name => "index_rails_admin_histories"

  create_table "states", :force => true do |t|
    t.string   "uf"
    t.string   "name"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "users", :force => true do |t|
    t.string   "email",                                 :default => "", :null => false
    t.string   "encrypted_password",     :limit => 128, :default => "", :null => false
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",                         :default => 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.string   "confirmation_token"
    t.datetime "confirmed_at"
    t.datetime "confirmation_sent_at"
    t.string   "name"
    t.integer  "state_id"
    t.integer  "city_id"
    t.text     "address"
    t.string   "zipcode"
    t.string   "phone"
    t.datetime "created_at",                                            :null => false
    t.datetime "updated_at",                                            :null => false
  end

  add_index "users", ["city_id"], :name => "index_users_on_city_id"
  add_index "users", ["confirmation_token"], :name => "index_users_on_confirmation_token", :unique => true
  add_index "users", ["email"], :name => "index_users_on_email", :unique => true
  add_index "users", ["reset_password_token"], :name => "index_users_on_reset_password_token", :unique => true
  add_index "users", ["state_id"], :name => "index_users_on_state_id"

  create_table "videos", :force => true do |t|
    t.string   "url"
    t.string   "legend"
    t.string   "window_size"
    t.string   "window_position"
    t.datetime "created_at",      :null => false
    t.datetime "updated_at",      :null => false
    t.integer  "closed_caption"
    t.integer  "transparency"
    t.integer  "user_id"
  end

  add_index "videos", ["user_id"], :name => "index_videos_on_user_id"

  create_table "wikivideos", :force => true do |t|
    t.string   "signal_name"
    t.string   "movement_type"
    t.string   "amount_of_hands"
    t.string   "facial_expression"
    t.string   "repeat_flag_primary"
    t.string   "primary_configuration_fingers"
    t.string   "primary_orientation_of_hands"
    t.string   "localization_of_articulation_primary"
    t.string   "primary_configuration_fingers_left"
    t.string   "primary_orientation_of_hands_left"
    t.string   "localization_of_articulation_primary_left"
    t.string   "time_spent"
    t.string   "path_signal"
    t.string   "radius"
    t.string   "clockwise"
    t.string   "orientation"
    t.string   "direction"
    t.string   "radius_secondary"
    t.string   "clockwise_secondary"
    t.string   "orientation_secondary"
    t.string   "direction_secondary"
    t.string   "secondary_configuration_fingers"
    t.string   "secondary_orientation_of_hands"
    t.string   "localization_of_articulation_secondary"
    t.string   "secondary_configuration_fingers_left"
    t.string   "secondary_orientation_of_hands_left"
    t.string   "localization_of_articulation_secondary_left"
    t.string   "repeat_flag_secondary"
    t.integer  "user_id"
    t.datetime "created_at",                                  :null => false
    t.datetime "updated_at",                                  :null => false
  end

  add_index "wikivideos", ["user_id"], :name => "index_wikivideos_on_user_id"

end