Upcoming database changes RELEASE 14 December 2022

-ActiveRecord::Schema.define(version: 2022_11_22_230809) do
+ActiveRecord::Schema.define(version: 2022_12_01_015853) do

   # These are extensions that must be enabled in order to support this database
   enable_extension "citext"
@@ -484,6 +484,7 @@
     t.index ["ess_identifier"], name: "index_claims_on_ess_identifier"
     t.index ["expense_id"], name: "index_claims_on_expense_id"
     t.index ["invoice_number"], name: "index_claims_on_invoice_number"
+    t.index ["jobseeker_id", "type", "due_on", "amount", "approved_amount", "gst", "programme", "site_id"], name: "unique_projected_claims", unique: true, where: "(((type)::text = 'Ongoing support'::text) AND (deleted_at IS NULL) AND (submitted_to_ccu_at IS NULL) AND (ess_identifier IS NULL) AND (((state)::text <> 'approved'::text) OR (state IS NULL)))"
     t.index ["jobseeker_id"], name: "index_claims_on_jobseeker_id"
     t.index ["placement_id"], name: "index_claims_on_placement_id"
     t.index ["site_id"], name: "index_claims_on_site_id"
@@ -748,7 +749,9 @@
     t.string "filters"
     t.string "resource_type"
     t.string "tag"
+    t.string "priority", default: "business_as_usual"
     t.datetime "deleted_at"
+    t.index ["priority"], name: "index_custom_alerts_on_priority"
     t.index ["deleted_at"], name: "index_custom_alerts_on_deleted_at"
     t.index ["resource_type"], name: "index_custom_alerts_on_resource_type"
   end
@@ -996,6 +999,23 @@
     t.datetime "updated_at", null: false
   end

+  create_table "ess_subscriptions", force: :cascade do |t|
+    t.string "programme"
+    t.string "type"
+    t.string "common_name"
+    t.integer "code"
+    t.string "report_name"
+    t.boolean "base_subscription"
+    t.integer "updated_by"
+    t.boolean "enabled"
+    t.string "sync_status"
+    t.datetime "last_synced_at"
+    t.string "subscription_footer"
+    t.string "ess_org_code"
+    t.datetime "created_at", null: false
+    t.datetime "updated_at", null: false
+  end
+
   create_table "ess_users", id: :serial, force: :cascade do |t|
     t.integer "site_id", null: false
     t.string "ess_identifier", null: false
@@ -3295,6 +3315,7 @@
     t.integer "consumed_timestep"
     t.boolean "otp_required_for_login"
     t.integer "manageable_query_type_ids", default: [], array: true
+    t.string "locale"
     t.index ["active"], name: "index_users_on_active"
     t.index ["confirmation_token"], name: "index_users_on_confirmation_token", unique: true
     t.index ["delegate_id"], name: "index_users_on_delegate_id"
(END)