<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.
#
# Added to assist tests.

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

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

  create_table "diabetic_toolbox_achievements", force: :cascade do |t|
    t.integer  "member_id"
    t.string   "name"
    t.integer  "points"
    t.integer  "level"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "diabetic_toolbox_achievements", ["member_id"], name: "index_diabetic_toolbox_achievements_on_member_id", using: :btree

  create_table "diabetic_toolbox_ingredients", force: :cascade do |t|
    t.integer  "recipe_id"
    t.string   "name"
    t.float    "volume"
    t.integer  "unit"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "diabetic_toolbox_ingredients", ["recipe_id"], name: "index_diabetic_toolbox_ingredients_on_recipe_id", using: :btree

  create_table "diabetic_toolbox_members", force: :cascade do |t|
    t.string   "first_name",               default: "",    null: false
    t.string   "last_name",                default: "",    null: false
    t.string   "username",                 default: "",    null: false
    t.string   "slug",                     default: "",    null: false
    t.string   "email",                    default: "",    null: false
    t.string   "encrypted_password",       default: "",    null: false
    t.string   "encryption_salt",          default: "",    null: false
    t.string   "session_token"
    t.integer  "recipes_count",            default: 0,     null: false
    t.integer  "achievements_count",       default: 0,     null: false
    t.integer  "settings_count",           default: 0,     null: false
    t.integer  "readings_count",           default: 0,     null: false
    t.date     "dob"
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remembered_at"
    t.datetime "current_session_began_at"
    t.string   "current_session_ip"
    t.datetime "last_session_began_at"
    t.string   "last_session_ip"
    t.string   "confirmation_token"
    t.datetime "confirmation_sent_at"
    t.datetime "confirmed_at"
    t.string   "unconfirmed_email"
    t.integer  "failed_attempts"
    t.string   "unlock_token"
    t.datetime "last_locked_at"
    t.datetime "created_at",                               null: false
    t.datetime "updated_at",                               null: false
    t.integer  "gender"
    t.boolean  "accepted_tos",             default: false, null: false
  end

  add_index "diabetic_toolbox_members", ["confirmation_token"], name: "index_diabetic_toolbox_members_on_confirmation_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["email"], name: "index_diabetic_toolbox_members_on_email", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["reset_password_token"], name: "index_diabetic_toolbox_members_on_reset_password_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["session_token"], name: "index_diabetic_toolbox_members_on_session_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["slug"], name: "index_diabetic_toolbox_members_on_slug", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["unlock_token"], name: "index_diabetic_toolbox_members_on_unlock_token", unique: true, using: :btree

  create_table "diabetic_toolbox_readings", force: :cascade do |t|
    t.integer  "member_id"
    t.float    "glucometer_value"
    t.datetime "test_time"
    t.integer  "meal"
    t.integer  "intake"
    t.datetime "created_at",       null: false
    t.datetime "updated_at",       null: false
  end

  add_index "diabetic_toolbox_readings", ["glucometer_value"], name: "index_diabetic_toolbox_readings_on_glucometer_value", using: :btree
  add_index "diabetic_toolbox_readings", ["meal"], name: "index_diabetic_toolbox_readings_on_meal", using: :btree
  add_index "diabetic_toolbox_readings", ["member_id"], name: "index_diabetic_toolbox_readings_on_member_id", using: :btree
  add_index "diabetic_toolbox_readings", ["test_time"], name: "index_diabetic_toolbox_readings_on_test_time", using: :btree

  create_table "diabetic_toolbox_recipes", force: :cascade do |t|
    t.integer  "member_id"
    t.string   "name"<commit_msg>Updated for remembrance token; last fixed change I promise :D<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: 20150819220213) do

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

  create_table "diabetic_toolbox_achievements", force: :cascade do |t|
    t.integer  "member_id"
    t.string   "name"
    t.integer  "points"
    t.integer  "level"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "diabetic_toolbox_achievements", ["member_id"], name: "index_diabetic_toolbox_achievements_on_member_id", using: :btree

  create_table "diabetic_toolbox_ingredients", force: :cascade do |t|
    t.integer  "recipe_id"
    t.string   "name"
    t.float    "volume"
    t.integer  "unit"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  add_index "diabetic_toolbox_ingredients", ["recipe_id"], name: "index_diabetic_toolbox_ingredients_on_recipe_id", using: :btree

  create_table "diabetic_toolbox_members", force: :cascade do |t|
    t.string   "first_name",               default: "",    null: false
    t.string   "last_name",                default: "",    null: false
    t.string   "username",                 default: "",    null: false
    t.string   "slug",                     default: "",    null: false
    t.string   "email",                    default: "",    null: false
    t.string   "encrypted_password",       default: "",    null: false
    t.string   "encryption_salt",          default: "",    null: false
    t.string   "session_token"
    t.integer  "recipes_count",            default: 0,     null: false
    t.integer  "achievements_count",       default: 0,     null: false
    t.integer  "settings_count",           default: 0,     null: false
    t.integer  "readings_count",           default: 0,     null: false
    t.date     "dob"
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remembered_at"
    t.string   "remembrance_token"
    t.datetime "current_session_began_at"
    t.string   "current_session_ip"
    t.datetime "last_session_began_at"
    t.string   "last_session_ip"
    t.string   "confirmation_token"
    t.datetime "confirmation_sent_at"
    t.datetime "confirmed_at"
    t.string   "unconfirmed_email"
    t.integer  "failed_attempts"
    t.string   "unlock_token"
    t.datetime "last_locked_at"
    t.datetime "created_at",                               null: false
    t.datetime "updated_at",                               null: false
    t.integer  "gender"
    t.boolean  "accepted_tos",             default: false, null: false
  end

  add_index "diabetic_toolbox_members", ["confirmation_token"], name: "index_diabetic_toolbox_members_on_confirmation_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["email"], name: "index_diabetic_toolbox_members_on_email", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["remembrance_token"], name: "index_diabetic_toolbox_members_on_remembrance_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["reset_password_token"], name: "index_diabetic_toolbox_members_on_reset_password_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["session_token"], name: "index_diabetic_toolbox_members_on_session_token", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["slug"], name: "index_diabetic_toolbox_members_on_slug", unique: true, using: :btree
  add_index "diabetic_toolbox_members", ["unlock_token"], name: "index_diabetic_toolbox_members_on_unlock_token", unique: true, using: :btree

  create_table "diabetic_toolbox_readings", force: :cascade do |t|
    t.integer  "member_id"
    t.float    "glucometer_value"
    t.datetime "test_time"
    t.integer  "meal"
    t.integer  "intake"
    t.datetime "created_at",       null: false
    t.datetime "updated_at",       null: false
  end

  add_index "diabetic_toolbox_readings", ["glucometer_value"], name: "index_diabetic_toolbox_readings_on_glucometer_value", using: :btree
  add_index "diabetic_toolbox_readings", ["meal"], name: "index_diabetic_toolbox_readings_on_meal", using: :btree
  add_index "diabetic_toolbox_readings", ["member_id"], name: "index_diabetic_toolbox_readings_on_member_id", using: :btree
  add_index "diabetic_toolbox_readings", ["test_time"], name: "index_diabetic_toolbox_readings_on_test_time", using: :btree

  create_table "diabetic_toolbox_recipes", force: :cascade do |t|
    t.integer  "member_id"
    t.string   "name"
{'fraction_non_alphanumeric': 0.09664506290507054, 'fraction_numerical': 0.0036218070911170418, 'mean_word_length': 3.771714415643474, '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': '2324217', 'n_tokens_mistral': 3451, 'n_tokens_neox': 3307, 'n_words': 861}