-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)