<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 that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20150413010844) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "authie_sessions", force: :cascade do |t|
    t.string   "token"
    t.string   "browser_id"
    t.integer  "user_id"
    t.boolean  "active",             default: true
    t.text     "data"
    t.datetime "expires_at"
    t.datetime "login_at"
    t.string   "login_ip"
    t.datetime "last_activity_at"
    t.string   "last_activity_ip"
    t.string   "last_activity_path"
    t.string   "user_agent"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "user_type"
    t.integer  "parent_id"
    t.datetime "two_factored_at"
    t.string   "two_factored_ip"
    t.integer  "requests",           default: 0
    t.datetime "password_seen_at"
  end

  add_index "authie_sessions", ["browser_id"], name: "index_authie_sessions_on_browser_id", using: :btree
  add_index "authie_sessions", ["token"], name: "index_authie_sessions_on_token", using: :btree
  add_index "authie_sessions", ["user_id"], name: "index_authie_sessions_on_user_id", using: :btree

  create_table "categories", force: :cascade do |t|
    t.integer  "game_id"
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "shortname"
  end

  add_index "categories", ["game_id"], name: "index_categories_on_game_id", using: :btree
  add_index "categories", ["name"], name: "index_categories_on_name", using: :btree

  create_table "delayed_jobs", force: :cascade do |t|
    t.integer  "priority",   default: 0, null: false
    t.integer  "attempts",   default: 0, null: false
    t.text     "handler",                null: false
    t.text     "last_error"
    t.datetime "run_at"
    t.datetime "locked_at"
    t.datetime "failed_at"
    t.string   "locked_by"
    t.string   "queue"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree

  create_table "games", force: :cascade do |t|
    t.string   "name"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "shortname"
    t.integer  "srl_id"
  end

  add_index "games", ["name"], name: "index_games_on_name", using: :btree
  add_index "games", ["shortname"], name: "index_games_on_shortname", using: :btree

  create_table "rivalries", force: :cascade do |t|
    t.integer "category_id"
    t.integer "from_user_id"
    t.integer "to_user_id"
  end

  add_index "rivalries", ["category_id"], name: "index_rivalries_on_category_id", using: :btree
  add_index "rivalries", ["from_user_id"], name: "index_rivalries_on_from_user_id", using: :btree
  add_index "rivalries", ["to_user_id"], name: "index_rivalries_on_to_user_id", using: :btree

  create_table "run_files", force: :cascade do |t|
    t.string "digest"
    t.text   "file"
  end

  add_index "run_files", ["digest"], name: "index_run_files_on_digest", using: :btree

  create_table "runs", force: :cascade do |t|
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "nick"
    t.string   "image_url"
    t.integer  "category_id"
    t.text     "file"
    t.string   "name"
    t.decimal  "time"
    t.string   "program"
    t.boolean  "visited",         default: false, null: false
    t.string   "claim_token"
    t.decimal  "sum_of_best"
    t.boolean  "archived"
    t.string   "video_url"
    t.string   "run_file_digest"
  end

  add_index "runs", ["category_id"], name: "index_runs_on_category_id", using: :btree
  add_index "runs", ["user_id"], name: "index_runs_on_user_id", using: :btree

  create_table "users", force: :cascade do |t|
    t.string   "email",        default: ""
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "twitch_token"
    t.integer  "twitch_id"
    t.string   "name"
    t.string   "avatar"
  end

  add_index "users", ["email"], name: "index_users_on_email", using: :btree

end<commit_msg>Update schema<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 that you check this file into your version control system.

ActiveRecord::Schema.define(version: 20150413010844) do

  # These are extensions that must be enabled in order to support this database
  enable_extension "plpgsql"

  create_table "authie_sessions", force: :cascade do |t|
    t.string   "token"
    t.string   "browser_id"
    t.integer  "user_id"
    t.boolean  "active",             default: true
    t.text     "data"
    t.datetime "expires_at"
    t.datetime "login_at"
    t.string   "login_ip"
    t.datetime "last_activity_at"
    t.string   "last_activity_ip"
    t.string   "last_activity_path"
    t.string   "user_agent"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "user_type"
    t.integer  "parent_id"
    t.datetime "two_factored_at"
    t.string   "two_factored_ip"
    t.integer  "requests",           default: 0
    t.datetime "password_seen_at"
  end

  add_index "authie_sessions", ["browser_id"], name: "index_authie_sessions_on_browser_id", using: :btree
  add_index "authie_sessions", ["token"], name: "index_authie_sessions_on_token", using: :btree
  add_index "authie_sessions", ["user_id"], name: "index_authie_sessions_on_user_id", using: :btree

  create_table "categories", force: :cascade do |t|
    t.integer  "game_id"
    t.string   "name",       limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "shortname",  limit: 255
  end

  add_index "categories", ["game_id"], name: "index_categories_on_game_id", using: :btree
  add_index "categories", ["name"], name: "index_categories_on_name", using: :btree

  create_table "delayed_jobs", force: :cascade do |t|
    t.integer  "priority",               default: 0, null: false
    t.integer  "attempts",               default: 0, null: false
    t.text     "handler",                            null: false
    t.text     "last_error"
    t.datetime "run_at"
    t.datetime "locked_at"
    t.datetime "failed_at"
    t.string   "locked_by",  limit: 255
    t.string   "queue",      limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree

  create_table "games", force: :cascade do |t|
    t.string   "name",       limit: 255
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "shortname",  limit: 255
    t.integer  "srl_id"
  end

  add_index "games", ["name"], name: "index_games_on_name", using: :btree
  add_index "games", ["shortname"], name: "index_games_on_shortname", using: :btree

  create_table "rivalries", force: :cascade do |t|
    t.integer "category_id"
    t.integer "from_user_id"
    t.integer "to_user_id"
  end

  add_index "rivalries", ["category_id"], name: "index_rivalries_on_category_id", using: :btree
  add_index "rivalries", ["from_user_id"], name: "index_rivalries_on_from_user_id", using: :btree
  add_index "rivalries", ["to_user_id"], name: "index_rivalries_on_to_user_id", using: :btree

  create_table "run_files", force: :cascade do |t|
    t.string "digest", limit: 255
    t.text   "file"
  end

  add_index "run_files", ["digest"], name: "index_run_files_on_digest", using: :btree

  create_table "runs", force: :cascade do |t|
    t.integer  "user_id"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "nick",            limit: 255
    t.string   "image_url",       limit: 255
    t.integer  "category_id"
    t.text     "file"
    t.string   "name",            limit: 255
    t.decimal  "time"
    t.string   "program",         limit: 255
    t.boolean  "visited",                     default: false, null: false
    t.string   "claim_token",     limit: 255
    t.decimal  "sum_of_best"
    t.boolean  "archived"
    t.string   "video_url",       limit: 255
    t.string   "run_file_digest", limit: 255
  end

  add_index "runs", ["category_id"], name: "index_runs_on_category_id", using: :btree
  add_index "runs", ["user_id"], name: "index_runs_on_user_id", using: :btree

  create_table "users", force: :cascade do |t|
    t.string   "email",        limit: 255, default: ""
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "twitch_token", limit: 255
    t.integer  "twitch_id"
    t.string   "name",         limit: 255
    t.string   "avatar",       limit: 255
  end

  add_index "users", ["email"], name: "index_users_on_email", using: :btree

end
{'fraction_non_alphanumeric': 0.11337502521686504, 'fraction_numerical': 0.009078071414161792, 'mean_word_length': 3.4184491978609626, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, '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': '3567310', 'n_tokens_mistral': 3526, 'n_tokens_neox': 3361, 'n_words': 932}