<commit_before># This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of ActiveRecord 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 => 20) do

  create_table "cms_posts", :force => true do |t|
    t.string   "title"
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "container_id"
    t.string   "container_type"
    t.integer  "agent_id"
    t.string   "agent_type"
    t.integer  "content_id"
    t.string   "content_type"
    t.integer  "parent_id"
    t.string   "parent_type"
    t.boolean  "public_read"
    t.boolean  "public_write"
  end

  create_table "cms_uris", :force => true do |t|
    t.string "uri"
  end

  add_index "cms_uris", ["uri"], :name => "index_cms_uris_on_uri"

  create_table "event_datetimes", :force => true do |t|
    t.integer  "event_id",   :null => false
    t.datetime "start_date", :null => false
    t.datetime "end_date",   :null => false
    t.integer  "at_job"
  end

  create_table "events", :force => true do |t|
    t.string "name",        :limit => 40, :null => false
    t.string "password",    :limit => 40, :null => false
    t.string "service",     :limit => 40, :null => false
    t.string "quality",     :limit => 8,  :null => false
    t.text   "description"
    t.string "uri",         :limit => 80, :null => false
  end

  create_table "events_users", :id => false, :force => true do |t|
    t.integer "user_id",  :null => false
    t.integer "event_id", :null => false
  end

  create_table "machines", :force => true do |t|
    t.string "name",     :limit => 40, :null => false
    t.string "nickname", :limit => 40, :null => false
  end

  create_table "machines_users", :id => false, :force => true do |t|
    t.integer "user_id",    :null => false
    t.integer "machine_id", :null => false
  end

  create_table "open_id_associations", :force => true do |t|
    t.binary  "server_url"
    t.string  "handle"
    t.binary  "secret"
    t.integer "issued"
    t.integer "lifetime"
    t.string  "assoc_type"
  end

  create_table "open_id_nonces", :force => true do |t|
    t.string  "server_url", :null => false
    t.integer "timestamp",  :null => false
    t.string  "salt",       :null => false
  end

  create_table "open_id_ownings", :force => true do |t|
    t.integer "agent_id"
    t.string  "agent_type"
    t.integer "uri_id"
  end

  create_table "participants", :force => true do |t|
    t.integer "event_id",                                             :null => false
    t.integer "machine_id",                                           :null => false
    t.integer "machine_id_connected_to",                              :null => false
    t.string  "role",                    :limit => 40,                :null => false
    t.integer "fec",                     :limit => 2,  :default => 0, :null => false
    t.integer "radiate_multicast",       :limit => 1,  :default => 0, :null => false
    t.text    "description"
  end

  create_table "profiles", :force => true do |t|
    t.string  "name"
    t.string  "lastname"
    t.string  "organization"
    t.string  "phone"
    t.string  "mobile"
    t.string  "fax"
    t.string  "address"
    t.string  "city"
    t.string  "zipcode"
    t.string  "province"
    t.string  "country"
    t.integer "users_id"
  end

  create_table "simple_captcha_data", :force => true do |t|
    t.string   "key",        :limit => 40
    t.string   "value",      :limit => 6
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "taggings", :force => true do |t|
    t.integer "tag_id",        :null => false
    t.integer "taggable_id",   :null => false
    t.string  "taggable_type", :null => false
  end

  add_index "taggings", ["tag_id", "taggable_id", "taggable_type"], :name => "index_taggings_on_tag_id_and_taggable_id_and_taggable_type", :unique => true

  create_table "tags", :force => true do |t|
    t.string "name", :null => false
  end

  add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true

  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email"
    t.string   "crypted_password",          :limit => 40<commit_msg>Dejar el db/schema.rb como estaba antes<commit_after># This file is auto-generated from the current state of the database. Instead of editing this file, 
# please use the migrations feature of ActiveRecord 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 => 20) do

  create_table "cms_posts", :force => true do |t|
    t.string   "title"
    t.text     "description"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "container_id"
    t.string   "container_type"
    t.integer  "agent_id"
    t.string   "agent_type"
    t.integer  "content_id"
    t.string   "content_type"
    t.integer  "parent_id"
    t.string   "parent_type"
    t.boolean  "public_read"
    t.boolean  "public_write"
  end

  create_table "cms_uris", :force => true do |t|
    t.string "uri"
  end

  add_index "cms_uris", ["uri"], :name => "index_cms_uris_on_uri"

  create_table "event_datetimes", :force => true do |t|
    t.integer  "event_id",   :null => false
    t.datetime "start_date", :null => false
    t.datetime "end_date",   :null => false
    t.integer  "at_job"
  end

  create_table "events", :force => true do |t|
    t.string "name",        :limit => 40, :default => "", :null => false
    t.string "password",    :limit => 40, :default => "", :null => false
    t.string "service",     :limit => 40, :default => "", :null => false
    t.string "quality",     :limit => 8,  :default => "", :null => false
    t.text   "description"
    t.string "uri",         :limit => 80, :default => "", :null => false
  end

  create_table "events_users", :id => false, :force => true do |t|
    t.integer "user_id",  :null => false
    t.integer "event_id", :null => false
  end

  create_table "globalize_countries", :force => true do |t|
    t.string "code",                   :limit => 2
    t.string "english_name"
    t.string "date_format"
    t.string "currency_format"
    t.string "currency_code",          :limit => 3
    t.string "thousands_sep",          :limit => 2
    t.string "decimal_sep",            :limit => 2
    t.string "currency_decimal_sep",   :limit => 2
    t.string "number_grouping_scheme"
  end

  add_index "globalize_countries", ["code"], :name => "index_globalize_countries_on_code"

  create_table "globalize_languages", :force => true do |t|
    t.string  "iso_639_1",             :limit => 2
    t.string  "iso_639_2",             :limit => 3
    t.string  "iso_639_3",             :limit => 3
    t.string  "rfc_3066"
    t.string  "english_name"
    t.string  "english_name_locale"
    t.string  "english_name_modifier"
    t.string  "native_name"
    t.string  "native_name_locale"
    t.string  "native_name_modifier"
    t.boolean "macro_language"
    t.string  "direction"
    t.string  "pluralization"
    t.string  "scope",                 :limit => 1
  end

  add_index "globalize_languages", ["iso_639_1"], :name => "index_globalize_languages_on_iso_639_1"
  add_index "globalize_languages", ["iso_639_2"], :name => "index_globalize_languages_on_iso_639_2"
  add_index "globalize_languages", ["iso_639_3"], :name => "index_globalize_languages_on_iso_639_3"
  add_index "globalize_languages", ["rfc_3066"], :name => "index_globalize_languages_on_rfc_3066"

  create_table "globalize_translations", :force => true do |t|
    t.string  "type"
    t.string  "tr_key"
    t.string  "table_name"
    t.integer "item_id"
    t.string  "facet"
    t.boolean "built_in",            :default => true
    t.integer "language_id"
    t.integer "pluralization_index"
    t.text    "text"
    t.string  "namespace"
  end

  add_index "globalize_translations", ["tr_key", "language_id"], :name => "index_globalize_translations_on_tr_key_and_language_id"
  add_index "globalize_translations", ["table_name", "item_id", "language_id"], :name => "globalize_translations_table_name_and_item_and_language"

  create_table "machines", :force => true do |t|
    t.string "name",     :limit => 40, :default => "", :null => false
    t.string "nickname", :limit => 40, :default => "", :null => false
  end

  create_table "machines_users", :id => false, :force => true do |t|
    t.integer "user_id",    :null => false
    t.integer "machine_id", :null => false
  end

  create_table "open_id_associations", :force => true do |t|
    t.binary  "server_url"
    t.string  "handle"
    t.binary  "secret"
    t.integer "issued"
    t.integer "lifetime"
    t.string  "assoc_type"
  end

  create_table "open_id_nonces", :force => true do |t|
    t.string  "server_url", :default => "", :null => false
    t.integer "timestamp",                  :null => false
    t.string  "salt",       :default => "", :null => false
  end

  create_table "open_id_ownings", :force => true do |t|
    t.integer "agent_id"
    t.string  "agent_type"
    t.integer "uri_id"
  end

  create_table "participants", :force => true do |t|
    t.integer "event_id",                                              :null => false
    t.integer "machine_id",                                            :null => false
    t.integer "machine_id_connected_to",                               :null => false
    t.string  "role",                    :limit => 40, :default => "", :null => false
    t.integer "fec",                     :limit => 2,  :default => 0,  :null => false
    t.integer "radiate_multicast",       :limit => 1,  :default => 0,  :null => false
    t.text    "description"
  end

  create_table "profiles", :force => true do |t|
    t.string  "name"
    t.string  "lastname"
    t.string  "organization"
    t.string  "phone"
    t.string  "mobile"
    t.string  "fax"
    t.string  "address"
    t.string  "city"
    t.string  "zipcode"
    t.string  "province"
    t.string  "country"
    t.integer "users_id"
  end

  create_table "simple_captcha_data", :force => true do |t|
    t.string   "key",        :limit => 40
    t.string   "value",      :limit => 6
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "taggings", :force => true do |t|
    t.integer "tag_id",                        :null => false
    t.integer "taggable_id",                   :null => false
    t.string  "taggable_type", :default => "", :null => false
  end

  add_index "taggings", ["tag_id", "taggable_id", "taggable_type"], :name => "index_taggings_on_tag_id_and_taggable_id_and_taggable_type", :unique => true

  create_table "tags", :force => true do |t|
    t.string "name", :default => "", :null => false
  end

  add_index "tags", ["name"], :name => "index_tags_on_name", :unique => true

  create_table "users", :force => true do |t|
    t.string   "login"
    t.string   "email"
    t.string   "crypted_password",          :limit => 40
{'fraction_non_alphanumeric': 0.13070970962642484, 'fraction_numerical': 0.009068974124303186, 'mean_word_length': 2.731760322881093, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 167, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 8, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6664124', 'n_tokens_mistral': 4145, 'n_tokens_neox': 3972, 'n_words': 1111}