Something went wrong. Try again.
[READ-ONLY] Mirror of https://github.com/glacials/splits-io. a speedrunning data store and analysis engine splits.io
Something went wrong. Try again.
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595# 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.## This file is the source Rails uses to define your schema when running `bin/rails# db:schema:load`. When creating a new database, `bin/rails db:schema:load` tends to# be faster and is potentially less error prone than running all of your# migrations from scratch. Old migrations may fail to apply correctly if those# migrations use external dependencies or application code.## It's strongly recommended that you check this file into your version control system.
ActiveRecord::Schema[7.1].define(version: 2024_10_11_055926) do # These are extensions that must be enabled in order to support this database enable_extension "citext" enable_extension "pg_trgm" enable_extension "pgcrypto" enable_extension "plpgsql" enable_extension "uuid-ossp"
create_table "active_storage_attachments", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.string "name", null: false t.uuid "record_id", null: false t.string "record_type", null: false t.uuid "blob_id", null: false t.datetime "created_at", precision: nil, null: false t.index ["record_type", "record_id", "name", "blob_id"], name: "index_active_storage_attachments_uniqueness", unique: true end
create_table "active_storage_blobs", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.string "key", null: false t.string "filename", null: false t.string "content_type" t.text "metadata" t.bigint "byte_size", null: false t.string "checksum" t.datetime "created_at", precision: nil, null: false t.string "service_name", null: false t.index ["key"], name: "index_active_storage_blobs_on_key", unique: true end
create_table "active_storage_variant_records", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "blob_id", null: false t.string "variation_digest", null: false t.index ["blob_id", "variation_digest"], name: "index_active_storage_variant_records_uniqueness", unique: true end
create_table "authie_sessions", id: :serial, 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", precision: nil t.datetime "login_at", precision: nil t.string "login_ip" t.datetime "last_activity_at", precision: nil t.string "last_activity_ip" t.string "last_activity_path" t.string "user_agent" t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.string "user_type" t.integer "parent_id" t.datetime "two_factored_at", precision: nil t.string "two_factored_ip" t.integer "requests", default: 0 t.datetime "password_seen_at", precision: nil t.string "token_hash" t.string "host" t.boolean "skip_two_factor", default: false t.string "login_ip_country" t.string "two_factored_ip_country" t.string "last_activity_ip_country" t.index ["browser_id"], name: "index_authie_sessions_on_browser_id" t.index ["token"], name: "index_authie_sessions_on_token" t.index ["token_hash"], name: "index_authie_sessions_on_token_hash" t.index ["user_id"], name: "index_authie_sessions_on_user_id" end
create_table "categories", id: :serial, force: :cascade do |t| t.integer "game_id" t.string "name" t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.string "shortname" t.index ["game_id"], name: "index_categories_on_game_id" t.index ["name"], name: "index_categories_on_name" end
create_table "chat_messages", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "race_id" t.bigint "user_id" t.boolean "from_entrant", null: false t.text "body", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.index ["race_id"], name: "index_chat_messages_on_race_id" t.index ["user_id"], name: "index_chat_messages_on_user_id" end
create_table "delayed_jobs", id: :serial, 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", precision: nil t.datetime "locked_at", precision: nil t.datetime "failed_at", precision: nil t.string "locked_by" t.string "queue" t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.index ["priority", "run_at"], name: "delayed_jobs_priority" end
create_table "entries", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "race_id" t.bigint "runner_id" t.datetime "readied_at", precision: 3 t.datetime "finished_at", precision: 3 t.datetime "forfeited_at", precision: 3 t.datetime "created_at", precision: 3, null: false t.datetime "updated_at", precision: 3, null: false t.bigint "run_id" t.boolean "ghost", default: false, null: false t.bigint "creator_id" t.index ["creator_id"], name: "index_entries_on_creator_id" t.index ["race_id"], name: "index_entries_on_race_id" t.index ["run_id"], name: "index_entries_on_run_id" t.index ["runner_id"], name: "index_entries_on_runner_id" end
create_table "game_aliases", id: :serial, force: :cascade do |t| t.integer "game_id" t.citext "name" t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["game_id"], name: "index_game_aliases_on_game_id" t.index ["name"], name: "index_game_aliases_on_name", unique: true end
create_table "games", id: :serial, force: :cascade do |t| t.string "name" t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.index ["name"], name: "index_games_on_name" end
create_table "google_users", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.string "google_id", null: false t.string "access_token", null: false t.datetime "access_token_expires_at", precision: nil, default: "1970-01-01 00:00:00", null: false t.string "name", null: false t.string "email", null: false t.string "first_name", null: false t.string "last_name" t.string "avatar", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["google_id"], name: "index_google_users_on_google_id", unique: true t.index ["user_id"], name: "index_google_users_on_user_id" end
create_table "highlight_suggestions", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "run_id", null: false t.text "url", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["run_id"], name: "index_highlight_suggestions_on_run_id", unique: true end
create_table "oauth_access_grants", id: :serial, force: :cascade do |t| t.integer "resource_owner_id", null: false t.integer "application_id", null: false t.string "token", null: false t.integer "expires_in", null: false t.text "redirect_uri", null: false t.datetime "created_at", precision: nil, null: false t.datetime "revoked_at", precision: nil t.string "scopes" t.string "code_challenge" t.string "code_challenge_method" t.index ["token"], name: "index_oauth_access_grants_on_token", unique: true end
create_table "oauth_access_tokens", id: :serial, force: :cascade do |t| t.integer "resource_owner_id" t.integer "application_id" t.string "token", null: false t.string "refresh_token" t.integer "expires_in" t.datetime "revoked_at", precision: nil t.datetime "created_at", precision: nil, null: false t.string "scopes" t.string "previous_refresh_token", default: "", null: false t.index ["refresh_token"], name: "index_oauth_access_tokens_on_refresh_token", unique: true t.index ["resource_owner_id"], name: "index_oauth_access_tokens_on_resource_owner_id" t.index ["token"], name: "index_oauth_access_tokens_on_token", unique: true end
create_table "oauth_applications", id: :serial, force: :cascade do |t| t.string "name", null: false t.string "uid", null: false t.string "secret", null: false t.text "redirect_uri", null: false t.string "scopes", default: "", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.integer "owner_id" t.string "owner_type" t.datetime "secret_generated_at", precision: nil, default: -> { "CURRENT_TIMESTAMP" }, null: false t.boolean "confidential", default: true, null: false t.index ["owner_id", "owner_type"], name: "index_oauth_applications_on_owner_id_and_owner_type" t.index ["uid"], name: "index_oauth_applications_on_uid", unique: true end
create_table "password_reset_tokens", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.string "token", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.index ["token"], name: "index_password_reset_tokens_on_token", unique: true t.index ["user_id"], name: "index_password_reset_tokens_on_user_id" end
create_table "patreon_users", id: :uuid, default: -> { "uuid_generate_v4()" }, force: :cascade do |t| t.integer "user_id", null: false t.string "access_token", null: false t.string "refresh_token", null: false t.string "full_name", null: false t.string "patreon_id", null: false t.integer "pledge_cents", null: false t.datetime "pledge_created_at", precision: nil t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["user_id"], name: "index_patreon_users_on_user_id" end
create_table "races", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "category_id" t.bigint "user_id" t.integer "visibility", default: 0, null: false t.string "join_token", null: false t.string "notes" t.datetime "started_at", precision: 3 t.datetime "created_at", precision: 3, null: false t.datetime "updated_at", precision: 3, null: false t.bigint "game_id" t.index ["category_id"], name: "index_races_on_category_id" t.index ["game_id"], name: "index_races_on_game_id" t.index ["user_id"], name: "index_races_on_user_id" end
create_table "rivalries", id: :serial, force: :cascade do |t| t.integer "category_id" t.integer "from_user_id" t.integer "to_user_id" t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["category_id"], name: "index_rivalries_on_category_id" t.index ["from_user_id"], name: "index_rivalries_on_from_user_id" t.index ["to_user_id"], name: "index_rivalries_on_to_user_id" end
create_table "run_histories", id: :uuid, default: -> { "uuid_generate_v4()" }, force: :cascade do |t| t.integer "run_id" t.integer "attempt_number" t.bigint "realtime_duration_ms" t.bigint "gametime_duration_ms" t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.datetime "started_at", precision: nil t.datetime "ended_at", precision: nil t.bigint "pause_duration_ms" t.index ["run_id"], name: "index_run_histories_on_run_id" end
create_table "run_likes", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "run_id", null: false t.bigint "user_id", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["run_id", "user_id"], name: "index_run_likes_on_run_id_and_user_id", unique: true t.index ["run_id"], name: "index_run_likes_on_run_id" t.index ["user_id"], name: "index_run_likes_on_user_id" end
create_table "runs", id: :serial, force: :cascade do |t| t.integer "user_id" t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.string "nick" t.string "image_url" t.integer "category_id" t.string "program" t.string "claim_token" t.boolean "archived", default: false, null: false t.string "srdc_id" t.integer "attempts" t.string "s3_filename", null: false t.bigint "realtime_duration_ms" t.bigint "realtime_sum_of_best_ms" t.datetime "parsed_at", precision: nil t.bigint "gametime_duration_ms" t.bigint "gametime_sum_of_best_ms" t.string "default_timing", default: "real", null: false t.bigint "total_playtime_ms" t.bigint "filesize_bytes", default: 0, null: false t.boolean "uses_emulator", default: false t.uuid "speedrun_dot_com_platform_id" t.uuid "speedrun_dot_com_region_id" t.boolean "uses_autosplitter" t.index ["category_id"], name: "index_runs_on_category_id" t.index ["s3_filename"], name: "index_runs_on_s3_filename" t.index ["user_id"], name: "index_runs_on_user_id" end
create_table "segment_histories", id: :uuid, default: -> { "uuid_generate_v4()" }, force: :cascade do |t| t.uuid "segment_id" t.integer "attempt_number" t.bigint "realtime_duration_ms" t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.bigint "gametime_duration_ms" t.index ["segment_id"], name: "index_segment_histories_on_segment_id" end
create_table "segments", id: :uuid, default: -> { "uuid_generate_v4()" }, force: :cascade do |t| t.integer "run_id", null: false t.integer "segment_number", null: false t.bigint "realtime_duration_ms" t.bigint "realtime_start_ms" t.bigint "realtime_end_ms" t.bigint "realtime_shortest_duration_ms" t.string "name" t.boolean "realtime_gold", default: false, null: false t.boolean "realtime_reduced", default: false, null: false t.boolean "realtime_skipped", default: false, null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.bigint "gametime_start_ms" t.bigint "gametime_end_ms" t.bigint "gametime_duration_ms" t.bigint "gametime_shortest_duration_ms" t.boolean "gametime_gold", default: false, null: false t.boolean "gametime_reduced", default: false, null: false t.boolean "gametime_skipped", default: false, null: false t.index ["run_id"], name: "index_segments_on_run_id" end
create_table "speed_runs_live_games", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "game_id" t.string "srl_id" t.string "name", null: false t.string "shortname", null: false t.float "popularity" t.integer "popularity_rank" t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["game_id"], name: "index_speed_runs_live_games_on_game_id", unique: true t.index ["shortname"], name: "index_speed_runs_live_games_on_shortname", unique: true t.index ["srl_id"], name: "index_speed_runs_live_games_on_srl_id", unique: true end
create_table "speedrun_dot_com_categories", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "category_id", null: false t.string "srdc_id", null: false t.string "name", null: false t.string "url", null: false t.boolean "misc", null: false t.string "rules" t.integer "min_players", null: false t.integer "max_players", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["category_id"], name: "index_speedrun_dot_com_categories_on_category_id", unique: true end
create_table "speedrun_dot_com_game_platforms", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "speedrun_dot_com_game_id" t.uuid "speedrun_dot_com_platform_id" t.index ["speedrun_dot_com_game_id"], name: "index_srdc_game_platforms_on_srdc_games_id" t.index ["speedrun_dot_com_platform_id"], name: "index_srdc_game_platforms_on_srdc_platforms_id" end
create_table "speedrun_dot_com_game_regions", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "speedrun_dot_com_game_id" t.uuid "speedrun_dot_com_region_id" t.index ["speedrun_dot_com_game_id"], name: "index_srdc_game_regions_on_srdc_games_id" t.index ["speedrun_dot_com_region_id"], name: "index_srdc_game_regions_on_srdc_regions_id" end
create_table "speedrun_dot_com_game_variable_values", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "speedrun_dot_com_game_variable_id", null: false t.string "srdc_id", null: false t.string "label", null: false t.string "rules" t.boolean "miscellaneous" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.index ["speedrun_dot_com_game_variable_id"], name: "index_srdc_game_variable_values_on_srdc_game_variables_id" end
create_table "speedrun_dot_com_game_variables", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.string "srdc_id" t.string "name", null: false t.uuid "speedrun_dot_com_game_id", null: false t.uuid "speedrun_dot_com_category_id" t.boolean "mandatory" t.boolean "obsoletes" t.boolean "user_defined" t.string "game_scope", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.uuid "speedrun_dot_com_game_variable_values_id" t.index ["speedrun_dot_com_category_id"], name: "index_srdc_game_variables_on_srdc_category_id" t.index ["speedrun_dot_com_game_id"], name: "index_srdc_game_variables_on_srdc_game_id" t.index ["speedrun_dot_com_game_variable_values_id"], name: "index_srdc_game_variables_on_srdc_game_variable_values_id" end
create_table "speedrun_dot_com_games", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "game_id" t.string "srdc_id", null: false t.string "name", null: false t.string "shortname" t.string "url", null: false t.string "favicon_url" t.string "cover_url" t.string "default_timing", null: false t.boolean "show_ms", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.string "twitch_name" t.boolean "video_required" t.boolean "accepts_realtime" t.boolean "accepts_gametime" t.boolean "emulators_allowed" t.index ["game_id"], name: "index_speedrun_dot_com_games_on_game_id", unique: true t.index ["shortname"], name: "index_speedrun_dot_com_games_on_shortname", unique: true t.index ["srdc_id"], name: "index_speedrun_dot_com_games_on_srdc_id", unique: true end
create_table "speedrun_dot_com_platforms", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.string "srdc_id", null: false t.string "name", null: false end
create_table "speedrun_dot_com_regions", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.string "srdc_id", null: false t.string "name", null: false end
create_table "speedrun_dot_com_run_variables", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.uuid "speedrun_dot_com_game_variable_value_id" t.bigint "run_id" t.datetime "created_at", null: false t.datetime "updated_at", null: false t.index ["run_id"], name: "index_speedrun_dot_com_run_variables_on_run_id" t.index ["speedrun_dot_com_game_variable_value_id"], name: "index_srdc_run_variables_on_srdc_game_variable_value_id" end
create_table "speedrun_dot_com_users", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.string "srdc_id", null: false t.string "name", null: false t.string "url", null: false t.string "api_key", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.index ["api_key"], name: "index_speedrun_dot_com_users_on_api_key", unique: true t.index ["srdc_id"], name: "index_speedrun_dot_com_users_on_srdc_id", unique: true t.index ["user_id"], name: "index_speedrun_dot_com_users_on_user_id", unique: true end
create_table "splits", id: :serial, force: :cascade do |t| t.integer "run_id" t.integer "position" t.string "name" t.float "real_duration" t.float "best_real_duration" t.float "game_duration" t.float "best_game_duration" t.index ["run_id"], name: "index_splits_on_run_id" end
create_table "subscription_trials", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.index ["user_id"], name: "index_subscription_trials_on_user_id" end
create_table "subscriptions", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.string "stripe_session_id" t.string "stripe_plan_id", null: false t.string "stripe_subscription_id" t.string "stripe_payment_intent_id" t.string "stripe_customer_id" t.datetime "canceled_at", precision: nil t.datetime "created_at", null: false t.datetime "updated_at", null: false t.datetime "ended_at", precision: nil t.index ["user_id"], name: "index_subscriptions_on_user_id" end
create_table "twitch_user_follows", force: :cascade do |t| t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.uuid "from_twitch_user_id" t.uuid "to_twitch_user_id" t.index ["from_twitch_user_id"], name: "index_twitch_user_follows_on_from_twitch_user_id" t.index ["to_twitch_user_id"], name: "index_twitch_user_follows_on_to_twitch_user_id" end
create_table "twitch_users", id: :uuid, default: -> { "gen_random_uuid()" }, force: :cascade do |t| t.bigint "user_id", null: false t.string "access_token", null: false t.string "name", null: false t.string "display_name", null: false t.string "twitch_id", null: false t.string "email" t.string "avatar", null: false t.datetime "follows_synced_at", precision: nil, default: "1970-01-01 00:00:00", null: false t.datetime "created_at", precision: nil, null: false t.datetime "updated_at", precision: nil, null: false t.string "url", null: false t.string "refresh_token" t.index ["twitch_id"], name: "index_twitch_users_on_twitch_id", unique: true t.index ["user_id"], name: "index_twitch_users_on_user_id", unique: true end
create_table "users", id: :serial, force: :cascade do |t| t.datetime "created_at", precision: nil t.datetime "updated_at", precision: nil t.citext "name" t.string "email" t.string "password_digest" t.index ["name"], name: "index_users_on_name", unique: true end
create_table "videos", force: :cascade do |t| t.bigint "run_id", null: false t.string "url", null: false t.datetime "created_at", null: false t.datetime "updated_at", null: false t.integer "start_offset_ms", default: 10000, null: false t.index ["run_id"], name: "index_videos_on_run_id" end
add_foreign_key "active_storage_attachments", "active_storage_blobs", column: "blob_id" add_foreign_key "active_storage_variant_records", "active_storage_blobs", column: "blob_id" add_foreign_key "chat_messages", "races" add_foreign_key "chat_messages", "users" add_foreign_key "entries", "races" add_foreign_key "entries", "users", column: "runner_id" add_foreign_key "game_aliases", "games", on_delete: :cascade add_foreign_key "google_users", "users" add_foreign_key "highlight_suggestions", "runs" add_foreign_key "oauth_access_grants", "oauth_applications", column: "application_id" add_foreign_key "oauth_access_tokens", "oauth_applications", column: "application_id" add_foreign_key "password_reset_tokens", "users" add_foreign_key "patreon_users", "users" add_foreign_key "races", "categories" add_foreign_key "races", "games" add_foreign_key "races", "users" add_foreign_key "run_histories", "runs", on_delete: :cascade add_foreign_key "run_likes", "runs" add_foreign_key "run_likes", "users" add_foreign_key "runs", "speedrun_dot_com_platforms" add_foreign_key "runs", "speedrun_dot_com_regions" add_foreign_key "segment_histories", "segments", on_delete: :cascade add_foreign_key "segments", "runs", on_delete: :cascade add_foreign_key "speed_runs_live_games", "games" add_foreign_key "speedrun_dot_com_categories", "categories" add_foreign_key "speedrun_dot_com_game_platforms", "speedrun_dot_com_games" add_foreign_key "speedrun_dot_com_game_platforms", "speedrun_dot_com_platforms" add_foreign_key "speedrun_dot_com_game_regions", "speedrun_dot_com_games" add_foreign_key "speedrun_dot_com_game_regions", "speedrun_dot_com_regions" add_foreign_key "speedrun_dot_com_game_variable_values", "speedrun_dot_com_game_variables" add_foreign_key "speedrun_dot_com_game_variables", "speedrun_dot_com_categories" add_foreign_key "speedrun_dot_com_game_variables", "speedrun_dot_com_games" add_foreign_key "speedrun_dot_com_games", "games" add_foreign_key "speedrun_dot_com_run_variables", "runs" add_foreign_key "speedrun_dot_com_run_variables", "speedrun_dot_com_game_variable_values" add_foreign_key "speedrun_dot_com_users", "users" add_foreign_key "splits", "runs" add_foreign_key "subscription_trials", "users" add_foreign_key "twitch_user_follows", "twitch_users", column: "from_twitch_user_id" add_foreign_key "twitch_user_follows", "twitch_users", column: "to_twitch_user_id" add_foreign_key "twitch_users", "users"end