<commit_before># 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 => 20130517024119) do

  create_table "assignments", :force => true do |t|
    t.integer "user_id"
    t.integer "race_id"
  end

  create_table "authentications", :force => true do |t|
    t.string   "user_id"
    t.string   "provider"
    t.string   "uid"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "custom_attributes"
  end

  create_table "comments", :force => true do |t|
    t.integer  "trip_id"
    t.integer  "user_id"
    t.text     "body"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "country_distances", :force => true do |t|
    t.integer "distance"
    t.integer "trip_id"
    t.string  "country"
  end

  create_table "future_trips", :force => true do |t|
    t.string   "from"
    t.string   "to"
    t.integer  "user_id"
    t.datetime "departure"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
    t.text     "description"
    t.float    "from_lng"
    t.float    "from_lat"
    t.float    "to_lng"
    t.float    "to_lat"
    t.string   "from_city"
    t.string   "from_country_code"
    t.string   "from_country"
    t.string   "to_city"
    t.string   "to_country_code"
    t.string   "to_country"
  end

  create_table "people", :force => true do |t|
    t.string  "occupation"
    t.string  "mission"
    t.string  "origin"
    t.integer "ride_id"
  end

  create_table "photos", :force => true do |t|
    t.integer  "trip_id"
    t.string   "photo"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "races", :force => true do |t|
    t.string   "name"
    t.string   "from_location"
    t.string   "to_location"
    t.float    "from_lat"
    t.float    "to_lat"
    t.string   "from_address"
    t.string   "to_address"
    t.string   "from_country"
    t.string   "to_country"
    t.string   "from_city"
    t.string   "to_city"
    t.string   "from_postal_code"
    t.string   "to_postal_code"
    t.string   "from_formatted_address"
    t.string   "to_formatted_address"
    t.datetime "created_at",             :null => false
    t.datetime "updated_at",             :null => false
  end

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

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

  create_table "rides", :force => true do |t|
    t.string   "title"
    t.string   "mission"
    t.string   "photo_file_name"
    t.string   "photo_content_type"
    t.string   "photo_file_size"
    t.string   "photo_updated_at"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
    t.text     "story"
    t.integer  "waiting_time"
    t.datetime "date"
    t.integer  "trip_id"
    t.float    "duration"
    t.integer  "number"
    t.string   "experience",         :default => "positive"
    t.string   "gender"
    t.string   "photo_caption"
  end

  add_index "rides", ["experience"], :name => "index_rides_on_experience"
  add_index "rides", ["gender"], :name => "index_rides_on_gender"
  add_index "rides", ["photo_file_name"], :name => "index_hitchhikes_on_photo_file_name"
  add_index "rides", ["trip_id"], :name => "index_rides_on_trip_id"
  add_index "rides", ["user_id"], :name => "index_rides_on_user_id"

  create_table "slugs", :force => true do |t|
    t.string   "name"
    t.integer  "sluggable_id"
    t.integer  "sequence",                     :default => 1, :null => false
    t.string   "sluggable_type", :limit => 40
    t.string   "scope"
    t.datetime "created_at"
  end

  add_index "slugs", ["name", "sluggable_type", "sequence", "scope"], :name => "index_slugs_on_n_s_s_and_s", :unique => true
  add_index "slugs", ["sluggable_id"], :name => "index_slugs_on_sluggable_id"

  create_table "trips", :force => true do |t|
    t.integer  "distance"
    t.datetime "departure"<commit_msg>schmea.rb<commit_after># 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 => 20130623151814) do

  create_table "assignments", :force => true do |t|
    t.integer "user_id"
    t.integer "race_id"
  end

  create_table "authentications", :force => true do |t|
    t.string   "user_id"
    t.string   "provider"
    t.string   "uid"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "custom_attributes"
  end

  create_table "comments", :force => true do |t|
    t.integer  "trip_id"
    t.integer  "user_id"
    t.text     "body"
    t.datetime "created_at", :null => false
    t.datetime "updated_at", :null => false
  end

  create_table "country_distances", :force => true do |t|
    t.integer "distance"
    t.integer "trip_id"
    t.string  "country"
  end

  create_table "future_trips", :force => true do |t|
    t.string   "from"
    t.string   "to"
    t.integer  "user_id"
    t.datetime "departure"
    t.datetime "created_at",        :null => false
    t.datetime "updated_at",        :null => false
    t.text     "description"
    t.float    "from_lng"
    t.float    "from_lat"
    t.float    "to_lng"
    t.float    "to_lat"
    t.string   "from_city"
    t.string   "from_country_code"
    t.string   "from_country"
    t.string   "to_city"
    t.string   "to_country_code"
    t.string   "to_country"
  end

  create_table "people", :force => true do |t|
    t.string  "occupation"
    t.string  "mission"
    t.string  "origin"
    t.integer "ride_id"
  end

  create_table "photos", :force => true do |t|
    t.integer  "trip_id"
    t.string   "photo"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "posts", :force => true do |t|
    t.string   "title"
    t.string   "body"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "races", :force => true do |t|
    t.string   "name"
    t.string   "from_location"
    t.string   "to_location"
    t.float    "from_lat"
    t.float    "to_lat"
    t.string   "from_address"
    t.string   "to_address"
    t.string   "from_country"
    t.string   "to_country"
    t.string   "from_city"
    t.string   "to_city"
    t.string   "from_postal_code"
    t.string   "to_postal_code"
    t.string   "from_formatted_address"
    t.string   "to_formatted_address"
    t.datetime "created_at",             :null => false
    t.datetime "updated_at",             :null => false
  end

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

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

  create_table "rides", :force => true do |t|
    t.string   "title"
    t.string   "mission"
    t.string   "photo_file_name"
    t.string   "photo_content_type"
    t.string   "photo_file_size"
    t.string   "photo_updated_at"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.integer  "user_id"
    t.text     "story"
    t.integer  "waiting_time"
    t.datetime "date"
    t.integer  "trip_id"
    t.float    "duration"
    t.integer  "number"
    t.string   "experience",         :default => "positive"
    t.string   "gender"
    t.string   "photo_caption"
  end

  add_index "rides", ["experience"], :name => "index_rides_on_experience"
  add_index "rides", ["gender"], :name => "index_rides_on_gender"
  add_index "rides", ["number"], :name => "index_rides_on_number"
  add_index "rides", ["photo_file_name"], :name => "index_hitchhikes_on_photo_file_name"
  add_index "rides", ["trip_id"], :name => "index_rides_on_trip_id"
  add_index "rides", ["user_id"], :name => "index_rides_on_user_id"

  create_table "slugs", :force => true do |t|
    t.string   "name"
    t.integer  "sluggable_id"
    t.integer  "sequence",                     :default => 1, :null => false
    t.string   "sluggable_type", :limit => 40
    t.string   "scope"
    t.datetime "created_at"
  end

  add_index "slugs", ["name", "sluggable_type", "sequence", "scope"], :name => "index_slugs_on_n_s_s_and_s", :unique => true
  add_index "slugs", ["sluggable_id"], :name => "index_slugs_on_sluggable_id"

  create_table "trips", :force => true do |t|
    t.integer  "distance"
    t.datetime "departure"
{'fraction_non_alphanumeric': 0.1200314836678473, 'fraction_numerical': 0.003935458480913027, 'mean_word_length': 2.969152674736431, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 73, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '1008369', 'n_tokens_mistral': 3628, 'n_tokens_neox': 3547, 'n_words': 921}