<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 => 20120316003041) do

  create_table "affiliate_event_applications", :force => true do |t|
    t.string   "first_name",           :null => false
    t.string   "last_name",            :null => false
    t.string   "organization_name",    :null => false
    t.string   "website"
    t.string   "job_title"
    t.string   "email",                :null => false
    t.string   "phone_number",         :null => false
    t.string   "event_name",           :null => false
    t.string   "event_date",           :null => false
    t.string   "event_location",       :null => false
    t.string   "event_capacity",       :null => false
    t.text     "event_overview",       :null => false
    t.string   "recurring"
    t.string   "paid_event"
    t.string   "event_cost"
    t.string   "rsvp_required"
    t.string   "rsvp_directions"
    t.boolean  "promote_event",        :null => false
    t.boolean  "event_info_available", :null => false
    t.boolean  "not_make_changes",     :null => false
    t.integer  "user_id",              :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "description_25words",  :null => false
    t.text     "description_10words",  :null => false
    t.string   "pdf_file_name"
    t.string   "pdf_content_type"
    t.integer  "pdf_file_size"
    t.datetime "pdf_updated_at"
  end

  add_index "affiliate_event_applications", ["user_id"], :name => "index_affiliate_event_applilcations_on_user_id"

  create_table "bhsi_applications", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "first_name",                                             :null => false
    t.string   "last_name",                                              :null => false
    t.string   "address1",                                               :null => false
    t.string   "address2"
    t.string   "city",                                                   :null => false
    t.string   "state",                                                  :null => false
    t.string   "country",                              :default => "US", :null => false
    t.string   "email",                                                  :null => false
    t.string   "gender",                                                 :null => false
    t.string   "birthdate",                                              :null => false
    t.string   "title",                                                  :null => false
    t.string   "social_venture_name",                                    :null => false
    t.string   "legal_structure",                                        :null => false
    t.string   "url",                                                    :null => false
    t.string   "twitter_handle",                                         :null => false
    t.string   "video_url",                                              :null => false
    t.string   "applied_before",                                         :null => false
    t.text     "about_yourself",                                         :null => false
    t.text     "social_venture_description",                             :null => false
    t.string   "venture_launched",                                       :null => false
    t.string   "number_people_affected",                                 :null => false
    t.text     "explain_number",                                         :null => false
    t.text     "organizational_development",                             :null => false
    t.text     "makes_social_innovation",                                :null => false
    t.text     "inspiration",                                            :null => false
    t.text     "sustainability_model",                                   :null => false
    t.text     "improvements",                                           :null => false
    t.text     "distinguish_yourself",                                   :null => false
    t.text     "strong_midwest_connections_explained"
    t.text     "additional_comments"
    t.string   "reference_1_name",                                       :null => false
    t.string   "reference_1_relationship",                               :null => false
    t.string   "reference_1_phone",                                      :null => false
    t.string   "reference_1_email",                                      :null => false
    t.string   "reference_2_name",                                       :null => false
    t.string   "reference_2_relationship",                               :null => false
    t.string   "reference_2_phone",                                      :null => false
    t.string   "reference_2_email",                                      :null => false
    t.integer  "user_id",                                                :null => false
    t.boolean  "agreement_accepeted",                                    :null => false
    t.string   "pdf_file_name"
    t.string   "pdf_content_type"
    t.integer  "pdf_file_size"
    t.datetime "pdf_updated_at"
    t.text     "three_standout_statistics",                              :null => false
    t.string   "phone_number",                                           :null => false
    t.string   "previous_budget_file_name"
    t.string   "previous_budget_content_type"
    t.integer  "previous_budget_file_size"
    t.datetime "previous_budget_updated_at"
    t.string   "press_clipping_1_file_name"
    t.string   "press_clipping_1_content_type"
    t.integer  "press_clipping_1_file_size"
    t.datetime "press_clipping_1_updated_at"
    t.string   "press_clipping_2_file_name"
    t.string   "press_clipping_2_content_type"
    t.integer  "press_clipping_2_file_size"
    t.datetime "press_clipping_2_updated_at"
    t.string   "press_clipping_3_file_name"
    t.string   "press_clipping_3_content_type"
    t.integer  "press_clipping_3_file_size"
    t.datetime "press_clipping_3_updated_at"
    t.string   "zipcode",                                                :null => false
  end

  create_table "chapter_photos", :force => true do |t|
    t.string   "photo_file_name",    :null => false
    t.string   "photo_content_type", :null => false
    t.integer  "photo_file_size",    :null => false
    t.datetime "photo_updated_at",   :null => false
    t.integer  "chapter_id",         :null => false
    t.string   "caption"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "chapter_photos", ["chapter_id"], :name => "index_chapter_photos_on_chapter_id"

  create_table "chapters", :force => true do |t|
    t.integer  "sort",                                            :null => false
    t.string   "title"
    t.text     "description"
    t.integer  "talk_id",                                         :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "vimeo_id"
    t.boolean  "featured_on_talk",             :default => false, :null => false
    t.boolean  "featured_on_homepage",         :default => false, :null => false
    t.text     "homepage_caption"
    t.string   "banner_file_name"
    t.string   "banner_content_type"<commit_msg>updating limits to the bhsi application form columns<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 => 20120316005636) do

  create_table "affiliate_event_applications", :force => true do |t|
    t.string   "first_name",           :null => false
    t.string   "last_name",            :null => false
    t.string   "organization_name",    :null => false
    t.string   "website"
    t.string   "job_title"
    t.string   "email",                :null => false
    t.string   "phone_number",         :null => false
    t.string   "event_name",           :null => false
    t.string   "event_date",           :null => false
    t.string   "event_location",       :null => false
    t.string   "event_capacity",       :null => false
    t.text     "event_overview",       :null => false
    t.string   "recurring"
    t.string   "paid_event"
    t.string   "event_cost"
    t.string   "rsvp_required"
    t.string   "rsvp_directions"
    t.boolean  "promote_event",        :null => false
    t.boolean  "event_info_available", :null => false
    t.boolean  "not_make_changes",     :null => false
    t.integer  "user_id",              :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.text     "description_25words",  :null => false
    t.text     "description_10words",  :null => false
    t.string   "pdf_file_name"
    t.string   "pdf_content_type"
    t.integer  "pdf_file_size"
    t.datetime "pdf_updated_at"
  end

  add_index "affiliate_event_applications", ["user_id"], :name => "index_affiliate_event_applilcations_on_user_id"

  create_table "bhsi_applications", :force => true do |t|
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "first_name",                           :limit => 25,                    :null => false
    t.string   "last_name",                            :limit => 25,                    :null => false
    t.string   "address1",                             :limit => 100,                   :null => false
    t.string   "address2",                             :limit => 55
    t.string   "city",                                 :limit => 55,                    :null => false
    t.string   "state",                                :limit => 15,                    :null => false
    t.string   "country",                                             :default => "US", :null => false
    t.string   "email",                                :limit => 50,                    :null => false
    t.string   "gender",                                                                :null => false
    t.string   "birthdate",                                                             :null => false
    t.string   "title",                                :limit => 50,                    :null => false
    t.string   "social_venture_name",                                                   :null => false
    t.string   "legal_structure",                      :limit => 100,                   :null => false
    t.string   "url",                                  :limit => 100,                   :null => false
    t.string   "twitter_handle",                       :limit => 20,                    :null => false
    t.string   "video_url",                                                             :null => false
    t.string   "applied_before",                       :limit => 3,                     :null => false
    t.text     "about_yourself",                                                        :null => false
    t.text     "social_venture_description",                                            :null => false
    t.string   "venture_launched",                     :limit => 50,                    :null => false
    t.string   "number_people_affected",               :limit => 20,                    :null => false
    t.text     "explain_number",                                                        :null => false
    t.text     "organizational_development",                                            :null => false
    t.text     "makes_social_innovation",                                               :null => false
    t.text     "inspiration",                                                           :null => false
    t.text     "sustainability_model",                                                  :null => false
    t.text     "improvements",                                                          :null => false
    t.text     "distinguish_yourself",                                                  :null => false
    t.text     "strong_midwest_connections_explained"
    t.text     "additional_comments"
    t.string   "reference_1_name",                     :limit => 50,                    :null => false
    t.string   "reference_1_relationship",             :limit => 100,                   :null => false
    t.string   "reference_1_phone",                    :limit => 15,                    :null => false
    t.string   "reference_1_email",                    :limit => 50,                    :null => false
    t.string   "reference_2_name",                     :limit => 50,                    :null => false
    t.string   "reference_2_relationship",             :limit => 100,                   :null => false
    t.string   "reference_2_phone",                    :limit => 15,                    :null => false
    t.string   "reference_2_email",                    :limit => 50,                    :null => false
    t.integer  "user_id",                                                               :null => false
    t.boolean  "agreement_accepeted",                                                   :null => false
    t.string   "pdf_file_name"
    t.string   "pdf_content_type"
    t.integer  "pdf_file_size"
    t.datetime "pdf_updated_at"
    t.text     "three_standout_statistics",                                             :null => false
    t.string   "phone_number",                         :limit => 11,                    :null => false
    t.string   "previous_budget_file_name"
    t.string   "previous_budget_content_type"
    t.integer  "previous_budget_file_size"
    t.datetime "previous_budget_updated_at"
    t.string   "press_clipping_1_file_name"
    t.string   "press_clipping_1_content_type"
    t.integer  "press_clipping_1_file_size"
    t.datetime "press_clipping_1_updated_at"
    t.string   "press_clipping_2_file_name"
    t.string   "press_clipping_2_content_type"
    t.integer  "press_clipping_2_file_size"
    t.datetime "press_clipping_2_updated_at"
    t.string   "press_clipping_3_file_name"
    t.string   "press_clipping_3_content_type"
    t.integer  "press_clipping_3_file_size"
    t.datetime "press_clipping_3_updated_at"
    t.string   "zipcode",                              :limit => 11,                    :null => false
  end

  create_table "chapter_photos", :force => true do |t|
    t.string   "photo_file_name",    :null => false
    t.string   "photo_content_type", :null => false
    t.integer  "photo_file_size",    :null => false
    t.datetime "photo_updated_at",   :null => false
    t.integer  "chapter_id",         :null => false
    t.string   "caption"
    t.datetime "created_at"
    t.datetime "updated_at"
  end

  add_index "chapter_photos", ["chapter_id"], :name => "index_chapter_photos_on_chapter_id"

  create_table "chapters", :force => true do |t|
    t.integer  "sort",                                            :null => false
    t.string   "title"
    t.text     "description"
    t.integer  "talk_id",                                         :null => false
    t.datetime "created_at"
    t.datetime "updated_at"
    t.string   "vimeo_id"
    t.boolean  "featured_on_talk",             :default => false, :null => false
    t.boolean  "featured_on_homepage",         :default => false, :null => false
    t.text     "homepage_caption"
    t.string   "banner_file_name"
    t.string   "banner_content_type"
{'fraction_non_alphanumeric': 0.09229288249804464, 'fraction_numerical': 0.008062090126947837, 'mean_word_length': 1.4329625292740047, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 177, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 97, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4348319', 'n_tokens_mistral': 4549, 'n_tokens_neox': 4344, 'n_words': 1080}