Upcoming database changes RELEASE 4 July 2023

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

@@ -713,2 +713,3 @@
     t.boolean "unsubscribed_from_bulk_emails", default: false
+    t.bigint "lead_substatus_id"
     t.index ["created_by_id"], name: "index_company_leads_on_created_by_id"
@@ -717,2 +718,3 @@
     t.index ["lead_sub_stage_id"], name: "index_company_leads_on_lead_sub_stage_id"
+    t.index ["lead_substatus_id"], name: "index_company_leads_on_lead_substatus_id"
     t.index ["referral_source_id"], name: "index_company_leads_on_referral_source_id"
@@ -731,2 +733,30 @@

+  create_table "contact_portal_users", force: :cascade do |t|
+    t.string "contact_id", null: false
+    t.boolean "active", default: false, null: false
+    t.string "email", null: false
+    t.string "crypted_password"
+    t.string "password_salt"
+    t.string "persistence_token"
+    t.string "perishable_token"
+    t.integer "login_count", default: 0, null: false
+    t.integer "failed_login_count", default: 0, null: false
+    t.datetime "last_request_at"
+    t.datetime "current_login_at"
+    t.datetime "last_login_at"
+    t.string "current_login_ip"
+    t.string "last_login_ip"
+    t.datetime "password_changed_at"
+    t.datetime "deleted_at"
+    t.datetime "locked_at"
+    t.integer "locked_by_id"
+    t.string "unique_session_id", limit: 32
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["contact_id"], name: "index_contact_portal_users_on_contact_id", unique: true
+    t.index ["email"], name: "index_contact_portal_users_on_email", unique: true
+    t.index ["locked_by_id"], name: "index_contact_portal_users_on_locked_by_id"
+    t.index ["persistence_token"], name: "index_contact_portal_users_on_persistence_token"
+  end
+
   create_table "contact_types", id: :serial, force: :cascade do |t|
@@ -1630,8 +1660,6 @@
     t.datetime "updated_at", null: false
-    t.string "reason_for_holding"
-    t.string "reason_for_closing"
-    t.datetime "on_hold_at"
-    t.datetime "closed_at"
     t.bigint "lead_stage_id"
     t.bigint "lead_sub_stage_id"
+    t.datetime "on_hold_at"
+    t.datetime "closed_at"
     t.bigint "created_by_id"
@@ -1642,2 +1670,6 @@
     t.boolean "unsubscribed_from_bulk_sms", default: false
+    t.bigint "lead_substatus_id"
+    t.string "reason_for_closing"
+    t.string "reason_for_holding"
+    t.boolean "potential_duplicate", default: false
     t.index ["created_by_id"], name: "index_jobseeker_leads_on_created_by_id"
@@ -1646,2 +1678,3 @@
     t.index ["lead_sub_stage_id"], name: "index_jobseeker_leads_on_lead_sub_stage_id"
+    t.index ["lead_substatus_id"], name: "index_jobseeker_leads_on_lead_substatus_id"
     t.index ["referral_source_id"], name: "index_jobseeker_leads_on_referral_source_id"
@@ -2905,2 +2938,19 @@

+  create_table "requested_signature_histories", force: :cascade do |t|
+    t.bigint "attachment_id"
+    t.bigint "requested_by_id"
+    t.bigint "jobseeker_id"
+    t.string "status", default: "requested"
+    t.datetime "viewed_at"
+    t.datetime "signed_at"
+    t.bigint "signed_attachment_id"
+    t.jsonb "additional_data", default: {}, null: false
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["attachment_id"], name: "index_requested_signature_histories_on_attachment_id"
+    t.index ["jobseeker_id"], name: "index_requested_signature_histories_on_jobseeker_id"
+    t.index ["requested_by_id"], name: "index_requested_signature_histories_on_requested_by_id"
+    t.index ["signed_attachment_id"], name: "index_requested_signature_histories_on_signed_attachment_id"
+  end
+
   create_table "resume_attachments", id: :serial, force: :cascade do |t|
@@ -3079,2 +3129,3 @@
     t.integer "lead_days_for_reminder", default: 3, null: false
+    t.integer "leads_kanban_day_limit", default: 7, null: false
   end
@@ -3985,2 +4036,3 @@
   add_foreign_key "company_leads", "lead_sub_stages"
+  add_foreign_key "company_leads", "lead_substatuses"
   add_foreign_key "company_leads", "referral_sources"
@@ -4034,2 +4086,3 @@
   add_foreign_key "jobseeker_leads", "lead_sub_stages"
+  add_foreign_key "jobseeker_leads", "lead_substatuses"
   add_foreign_key "jobseeker_leads", "referral_sources"
@@ -4100,2 +4153,6 @@
   add_foreign_key "requested_attachment_histories", "users", column: "requested_by_id"
+  add_foreign_key "requested_signature_histories", "attachments"
+  add_foreign_key "requested_signature_histories", "attachments", column: "signed_attachment_id"
+  add_foreign_key "requested_signature_histories", "jobseekers"
+  add_foreign_key "requested_signature_histories", "users", column: "requested_by_id"
   add_foreign_key "scanned_document_images", "scanned_documents"
   end