Upcoming database changes RELEASE 05 April 2022

-ActiveRecord::Schema.define(version: 2022_03_14_053851) do
+ActiveRecord::Schema.define(version: 2022_03_18_031817) do

@@ -304,2 +304,16 @@ create_table "bank_transactions", force: :cascade do |t|

+ create_table "basic_benefit_rates", force: :cascade do |t|
+ t.string "name"
+ t.integer "base_rate"
+ t.date "effective_from_date"
+ t.decimal "lower_percentage", default: "0.6"
+ t.integer "lower_rate"
+ t.decimal "mid_percentage", default: "0.85"
+ t.integer "mid_rate"
+ t.decimal "upper_percentage", default: "1.0"
+ t.integer "upper_rate"
+ t.datetime "created_at", null: false
+ t.datetime "updated_at", null: false
+ end
+
create_table "batches", id: :serial, force: :cascade do |t|
@@ -646,2 +660,3 @@ create_table "contacts", id: :serial, force: :cascade do |t|
t.boolean "unsubscribed_from_email", default: false
+ t.boolean "unsubscribed_from_sms", default: false
t.index ["contact_type_id"], name: "index_contacts_on_contact_type_id"
@@ -1119,2 +1134,3 @@ create_table "expenses", id: :serial, force: :cascade do |t|
t.boolean "goods_received", default: false
+ t.datetime "goods_received_confirmation_requested_at"
t.index ["approver_id"], name: "index_expenses_on_approver_id"
@@ -1587,2 +1603,3 @@ create_table "jobseekers", id: :serial, force: :cascade do |t|
t.string "marketo_lead_id"
+ t.boolean "unsubscribed_from_bulk_sms", default: false
t.index ["deleted_at"], name: "index_jobseekers_on_deleted_at"
@@ -1853,3 +1870,3 @@ create_table "placements", id: :serial, force: :cascade do |t|
t.integer "basic_rate_upper"
- t.string "basic_rate_circumstance"
+ t.string "basic_rate_name"
t.integer "basic_rate_base"
@@ -2577,2 +2594,3 @@ create_table "settings", id: :serial, force: :cascade do |t|
t.integer "wage_subsidy_payment_portal_session_timeout_in_seconds"
+ t.boolean "marketo_sync_enabled", default: false, null: false
end
@@ -3041,2 +3059,3 @@ create_table "users", id: :serial, force: :cascade do |t|
t.boolean "can_end_placement", default: true, null: false
+ t.boolean "can_manage_basic_benefit_rates", default: false, null: false
t.index ["active"], name: "index_users_on_active"

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.