Upcoming database changes RELEASE 24 January 2023

-ActiveRecord::Schema.define(version: 2022_12_19_222241) do
+ActiveRecord::Schema.define(version: 2023_01_12_045621) do

@@ -318,2 +318,4 @@ create_table "bank_transactions", force: :cascade do |t|
     t.string "transaction_code"
+    t.string "account_name"
+    t.index ["account_number", "account_name"], name: "index_bank_transactions_on_account_number_and_account_name"
   end
@@ -602,2 +604,7 @@ create_table "companies", id: :serial, force: :cascade do |t|
     t.bigint "created_by_id"
+    t.text "recruitment_portal_details"
+    t.text "strategy_details"
+    t.bigint "referral_source_id"
+    t.string "sub_source_type"
+    t.bigint "sub_source_id"
     t.index ["account_manager_id"], name: "index_companies_on_account_manager_id"
@@ -611,4 +618,6 @@ create_table "companies", id: :serial, force: :cascade do |t|
     t.index ["recruitment_coordinator_id"], name: "index_companies_on_recruitment_coordinator_id"
+    t.index ["referral_source_id"], name: "index_companies_on_referral_source_id"
     t.index ["region_id"], name: "index_companies_on_region_id"
     t.index ["site_id"], name: "index_companies_on_site_id"
+    t.index ["sub_source_type", "sub_source_id"], name: "index_companies_on_sub_source_type_and_sub_source_id"
   end
@@ -1008,3 +1017,3 @@ create_table "ess_subscriptions", force: :cascade do |t|
     t.boolean "base_subscription"
-    t.integer "updated_by"
+    t.integer "updated_by_id"
     t.boolean "enabled"
@@ -3324,2 +3333,3 @@ create_table "users", id: :serial, force: :cascade do |t|
     t.string "locale"
+    t.boolean "can_send_sms", default: true, null: false
     t.index ["active"], name: "index_users_on_active"
   end