Upcoming database changes RELEASE 20 June 2023

-ActiveRecord::Schema.define(version: 2023_05_29_023632) do
+ActiveRecord::Schema.define(version: 2023_06_12_053304) do

   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
@@ -710,6 +710,7 @@
     t.bigint "lead_sub_stage_id"
     t.bigint "created_by_id"
     t.datetime "created_by"
+    t.boolean "unsubscribed_from_bulk_emails", default: false
     t.index ["created_by_id"], name: "index_company_leads_on_created_by_id"
     t.index ["lead_manager_id"], name: "index_company_leads_on_lead_manager_id"
     t.index ["lead_stage_id"], name: "index_company_leads_on_lead_stage_id"
@@ -2881,6 +2882,19 @@
     t.index ["to"], name: "index_repeats_on_to"
   end

+  create_table "requested_attachment_histories", force: :cascade do |t|
+    t.bigint "attachment_id"
+    t.bigint "requested_by_id"
+    t.bigint "jobseeker_id"
+    t.string "status", default: "requested"
+    t.string "document_type"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["attachment_id"], name: "index_requested_attachment_histories_on_attachment_id"
+    t.index ["jobseeker_id"], name: "index_requested_attachment_histories_on_jobseeker_id"
+    t.index ["requested_by_id"], name: "index_requested_attachment_histories_on_requested_by_id"
+  end
+
   create_table "resume_attachments", id: :serial, force: :cascade do |t|
     t.string "file"
     t.integer "user_id"
@@ -3053,6 +3067,8 @@
     t.boolean "allied_health_activity_mandatory_delivery_mode", default: false, null: false
     t.text "jobseeker_suggestion_sms_engagement_body"
     t.boolean "comment_mandatory", default: false, null: false
+    t.boolean "auto_create_reminders_for_transfer_leads", default: false, null: false
+    t.integer "lead_days_for_reminder", default: 3, null: false
   end

   create_table "short_message_replies", id: :serial, force: :cascade do |t|
@@ -4071,6 +4087,9 @@
   add_foreign_key "reminders", "users", column: "assigned_to_id"
   add_foreign_key "reminders", "users", column: "completed_by_id"
   add_foreign_key "reminders", "users", column: "created_by_id"
+  add_foreign_key "requested_attachment_histories", "attachments"
+  add_foreign_key "requested_attachment_histories", "jobseekers"
+  add_foreign_key "requested_attachment_histories", "users", column: "requested_by_id"
   add_foreign_key "scanned_document_images", "scanned_documents"
   add_foreign_key "scanned_documents", "batches"
   add_foreign_key "short_messages", "reminders"
(END)