Upcoming database changes RELEASE 30 August 2023

-ActiveRecord::Schema.define(version: 2023_08_06_144702) do
+ActiveRecord::Schema.define(version: 2023_08_24_051646) do

   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
@@ -3143,6 +3143,8 @@
     t.integer "leads_kanban_day_limit", default: 7, null: false
     t.integer "jobseeker_leads_auto_close_days", default: 30
     t.integer "company_leads_auto_close_days", default: 30
+    t.string "time_zone", default: "Australia/Sydney"
+    t.string "locale", default: "en"
   end

   create_table "short_message_replies", id: :serial, force: :cascade do |t|
@@ -3513,6 +3515,16 @@
     t.index ["user_id"], name: "index_time_logs_on_user_id"
   end

+  create_table "transports", force: :cascade do |t|
+    t.string "name"
+    t.boolean "system", default: false
+    t.datetime "deleted_at"
+    t.bigint "employment_property_option_id"
+    t.datetime "created_at", precision: 6, null: false
+    t.datetime "updated_at", precision: 6, null: false
+    t.index ["employment_property_option_id"], name: "index_transports_on_employment_property_option_id"
+  end
+
   create_table "user_expense_approval_limits", id: :serial, force: :cascade do |t|
     t.integer "user_id"
     t.string "programme", null: false
@@ -3742,6 +3754,7 @@
     t.string "address_line_2"
     t.text "duties"
     t.boolean "send_automated_communications", default: true
+    t.integer "transport_ids", default: [], array: true
     t.index ["company_id"], name: "index_vacancies_on_company_id"
     t.index ["contact_id"], name: "index_vacancies_on_contact_id"
     t.index ["employer_campaign_id"], name: "index_vacancies_on_employer_campaign_id"
@@ -3817,7 +3830,7 @@
     t.datetime "created_at", null: false
     t.datetime "updated_at", null: false
     t.integer "verification_source_id"
-    t.integer "attachment_id"
+    t.integer "attachment_ids", default: [], array: true
     t.string "previous_system_identifier"
     t.integer "user_id"
     t.integer "updated_by_id"
@@ -4189,6 +4202,7 @@
   add_foreign_key "supplier_purchase_orders", "expense_credit_cards"
   add_foreign_key "supplier_purchase_orders", "expense_payment_types"
   add_foreign_key "supplier_purchase_orders", "purchase_orders"
+  add_foreign_key "transports", "employment_property_options"
   add_foreign_key "user_expense_approval_limits", "users"
   add_foreign_key "user_sets", "users"
   add_foreign_key "users", "sites"
(END)