<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: 20141118070603) do

  create_table "addresses", force: true do |t|
    t.string   "text"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "addresses", ["text"], name: "index_addresses_on_text", using: :btree

  create_table "admins", force: true do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: ""
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "invitation_token"
    t.datetime "invitation_sent_at"
    t.datetime "invitation_accepted_at"
    t.integer  "invitation_limit"
    t.integer  "invited_by_id"
    t.string   "invited_by_type"
    t.datetime "invitation_created_at"
  end

  add_index "admins", ["email"], name: "index_admins_on_email", unique: true, using: :btree
  add_index "admins", ["invitation_token"], name: "index_admins_on_invitation_token", unique: true, using: :btree
  add_index "admins", ["invited_by_id"], name: "index_admins_on_invited_by_id", using: :btree
  add_index "admins", ["reset_password_token"], name: "index_admins_on_reset_password_token", unique: true, using: :btree

  create_table "apps", force: true do |t|
    t.string   "smtp_username"
    t.string   "name"
    t.string   "url"
    t.string   "smtp_password"
    t.string   "custom_tracking_domain"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "smtp_password_locked",   default: false, null: false
    t.boolean  "open_tracking_enabled",  default: true,  null: false
    t.boolean  "click_tracking_enabled", default: true,  null: false
    t.text     "dkim_private_key"
    t.string   "from_domain"
    t.boolean  "dkim_enabled",           default: false, null: false
  end

  create_table "black_lists", force: true do |t|
    t.integer  "address_id"
    t.integer  "caused_by_delivery_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "black_lists", ["address_id"], name: "black_lists_address_id_fk", using: :btree
  add_index "black_lists", ["caused_by_delivery_id"], name: "black_lists_caused_by_delivery_id_fk", using: :btree

  create_table "click_events", force: true do |t|
    t.integer  "delivery_link_id"
    t.text     "user_agent"
    t.text     "referer"<commit_msg>Fix up schema.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 that you check this file into your version control system.

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

  create_table "addresses", force: true do |t|
    t.string   "text"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "addresses", ["text"], name: "index_addresses_on_text", using: :btree

  create_table "admins", force: true do |t|
    t.string   "email",                  default: "", null: false
    t.string   "encrypted_password",     default: ""
    t.string   "reset_password_token"
    t.datetime "reset_password_sent_at"
    t.datetime "remember_created_at"
    t.integer  "sign_in_count",          default: 0
    t.datetime "current_sign_in_at"
    t.datetime "last_sign_in_at"
    t.string   "current_sign_in_ip"
    t.string   "last_sign_in_ip"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "invitation_token"
    t.datetime "invitation_sent_at"
    t.datetime "invitation_accepted_at"
    t.integer  "invitation_limit"
    t.integer  "invited_by_id"
    t.string   "invited_by_type"
    t.datetime "invitation_created_at"
  end

  add_index "admins", ["email"], name: "index_admins_on_email", unique: true, using: :btree
  add_index "admins", ["invitation_token"], name: "index_admins_on_invitation_token", unique: true, using: :btree
  add_index "admins", ["invited_by_id"], name: "index_admins_on_invited_by_id", using: :btree
  add_index "admins", ["reset_password_token"], name: "index_admins_on_reset_password_token", unique: true, using: :btree

  create_table "apps", force: true do |t|
    t.string   "smtp_username"
    t.string   "name"
    t.string   "url"
    t.string   "smtp_password"
    t.string   "custom_tracking_domain"
    t.datetime "created_at"
    t.datetime "updated_at"
    t.boolean  "smtp_password_locked",   default: false, null: false
    t.boolean  "open_tracking_enabled",  default: true,  null: false
    t.boolean  "click_tracking_enabled", default: true,  null: false
    t.text     "dkim_private_key"
    t.string   "from_domain"
    t.boolean  "dkim_enabled",           default: false, null: false
  end

  create_table "black_lists", force: true do |t|
    t.integer  "address_id"
    t.integer  "caused_by_delivery_id"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  create_table "click_events", force: true do |t|
    t.integer  "delivery_link_id"
    t.text     "user_agent"
    t.text     "referer"
{'fraction_non_alphanumeric': 0.09769230769230769, 'fraction_numerical': 0.004923076923076923, 'mean_word_length': 3.8623784592370978, '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': '1397459', 'n_tokens_mistral': 2208, 'n_tokens_neox': 2126, 'n_words': 603}