schema.rb.diff

diff --git i/db/schema.rb w/db/schema.rb
index 8052e88..7617614 100644
--- i/db/schema.rb
+++ w/db/schema.rb
@@ -610,7 +610,7 @@ ActiveRecord::Schema.define(version: 20160408155519) do
 
   add_index "builder_recipients", ["account_id"], name: "index_builder_recipients_on_account_id", using: :btree
   add_index "builder_recipients", ["email"], name: "index_builder_recipients_on_email", using: :btree
-  add_index "builder_recipients", ["opted_token"], name: "index_builder_recipients_on_opted_token", unique: true, using: :btree
+  add_index "builder_recipients", ["opted_token"], name: "index_builder_recipients_on_opted_token", unique: true, length: {"opted_token"=>100}, using: :btree
 
   create_table "builder_settings", force: :cascade do |t|
     t.integer "identity_id",   limit: 4
@@ -720,15 +720,15 @@ ActiveRecord::Schema.define(version: 20160408155519) do
 
   create_table "checklist_blacklist_items", force: :cascade do |t|
     t.string   "slug",       limit: 100, null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",             null: false
+    t.datetime "updated_at",             null: false
   end
 
   create_table "checklist_custom_rules", force: :cascade do |t|
     t.string   "title",      limit: 255, null: false
     t.integer  "account_id", limit: 4,   null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",             null: false
+    t.datetime "updated_at",             null: false
   end
 
   create_table "checklist_email_service_providers", force: :cascade do |t|
@@ -761,15 +761,15 @@ ActiveRecord::Schema.define(version: 20160408155519) do
     t.datetime "pdf_generated_at"
   end
 
-  add_index "checklist_emails", ["account_id"], name: "index_checklist_emails_on_account_id", using: :btree
-  add_index "checklist_emails", ["token"], name: "index_checklist_emails_on_token", unique: true, using: :btree
-  add_index "checklist_emails", ["user_id"], name: "index_checklist_emails_on_user_id", using: :btree
+  add_index "checklist_emails", ["account_id"], name: "index_checklist_reports_on_account_id", using: :btree
+  add_index "checklist_emails", ["token"], name: "index_checklist_reports_on_token", unique: true, using: :btree
+  add_index "checklist_emails", ["user_id"], name: "index_checklist_reports_on_user_id", using: :btree
 
   create_table "checklist_rules", force: :cascade do |t|
     t.integer  "account_id", limit: 4,   null: false
     t.string   "key",        limit: 255, null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",             null: false
+    t.datetime "updated_at",             null: false
     t.string   "slug",       limit: 255
   end
 
@@ -778,8 +778,8 @@ ActiveRecord::Schema.define(version: 20160408155519) do
   create_table "checklist_timeouts", force: :cascade do |t|
     t.string   "domain",     limit: 255, null: false
     t.string   "path",       limit: 255, null: false
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at",             null: false
+    t.datetime "updated_at",             null: false
   end
 
   create_table "collections", force: :cascade do |t|
@@ -825,12 +825,6 @@ ActiveRecord::Schema.define(version: 20160408155519) do
 
   add_index "community_articles_topics", ["topic_id", "article_id"], name: "index_community_articles_topics_on_topic_id_and_article_id", unique: true, using: :btree
 
-  create_table "community_beta_newer", id: false, force: :cascade do |t|
-    t.string "key", limit: 255
-  end
-
-  add_index "community_beta_newer", ["key"], name: "key", using: :btree
-
   create_table "community_comments", force: :cascade do |t|
     t.integer  "identity_id",      limit: 4,                                       null: false
     t.integer  "votes",            limit: 4
@@ -849,6 +843,19 @@ ActiveRecord::Schema.define(version: 20160408155519) do
   add_index "community_comments", ["commentable_id", "commentable_type"], name: "index_community_comments_on_commentable_id_and_commentable_type", using: :btree
   add_index "community_comments", ["identity_id"], name: "index_community_comments_on_identity_id", using: :btree
 
+  create_table "community_content_metadata", force: :cascade do |t|
+    t.string   "user_ip",         limit: 255
+    t.string   "user_agent",      limit: 255
+    t.string   "referrer",        limit: 255
+    t.boolean  "spam",            limit: 1,   default: false, null: false
+    t.integer  "recordable_id",   limit: 4,                   null: false
+    t.string   "recordable_type", limit: 255,                 null: false
+    t.datetime "created_at",                                  null: false
+    t.datetime "updated_at",                                  null: false
+  end
+
+  add_index "community_content_metadata", ["recordable_id", "recordable_type"], name: "ix_community_content_recordable", using: :btree
+
   create_table "community_discussions", force: :cascade do |t|
     t.integer  "identity_id",       limit: 4,                                       null: false
     t.string   "title",             limit: 175,                                     null: false
@@ -1782,14 +1789,6 @@ ActiveRecord::Schema.define(version: 20160408155519) do
 
   add_index "qa_custom_approvals", ["account_id"], name: "index_qa_custom_approvals_on_account_id", using: :btree
 
-  create_table "qa_published_sections", force: :cascade do |t|
-    t.integer "test_id",       limit: 4
-    t.integer "qa_section_id", limit: 4
-  end
-
-  add_index "qa_published_sections", ["qa_section_id"], name: "index_qa_published_sections_on_qa_section_id", using: :btree
-  add_index "qa_published_sections", ["test_id"], name: "index_qa_published_sections_on_test_id", using: :btree
-
   create_table "qa_section_metadata", force: :cascade do |t|
     t.integer "test_id",  limit: 4, default: 0,     null: false
     t.integer "section",  limit: 4, default: 0,     null: false
@@ -2217,7 +2216,6 @@ ActiveRecord::Schema.define(version: 20160408155519) do
     t.boolean  "share_subject_line",  limit: 1
     t.boolean  "share_link_check",    limit: 1
     t.boolean  "share_spam_filters",  limit: 1
-    t.boolean  "spam_test",           limit: 1,   default: false
     t.boolean  "show_in_qa",          limit: 1,   default: false, null: false
   end