Upcoming database changes RELEASE 16 August 2023


-ActiveRecord::Schema.define(version: 2023_07_14_010552) do
+ActiveRecord::Schema.define(version: 2023_08_06_144702) do
 
@@ -2033,2 +2033,4 @@ create_table "licence_requirements", id: :serial, force: :cascade do |t|
     t.datetime "deleted_at"
+    t.bigint "employment_property_option_id"
+    t.index ["employment_property_option_id"], name: "index_licence_requirements_on_employment_property_option_id"
     t.index ["requirement"], name: "index_licence_requirements_on_requirement", unique: true
@@ -3679,3 +3681,3 @@ create_table "vacancies", id: :serial, force: :cascade do |t|
     t.string "status", default: "Active", null: false
-    t.string "work_type"
+    t.string "work_type", default: [], array: true
     t.string "type"
@@ -3714,3 +3716,3 @@ create_table "vacancies", id: :serial, force: :cascade do |t|
     t.string "salary"
-    t.integer "licence_requirement_id"
+    t.integer "licence_requirement_id", default: [], array: true
     t.json "jobs_board_custom_fields", default: {}, null: false
@@ -4115,2 +4117,3 @@ create_table "work_for_doles", force: :cascade do |t|
   add_foreign_key "lead_sub_stages", "lead_stages"
+  add_foreign_key "licence_requirements", "employment_property_options"
   add_foreign_key "line_items", "expenses"
@@ -4196,3 +4199,2 @@ create_table "work_for_doles", force: :cascade do |t|
   add_foreign_key "vacancies", "employer_campaigns"
-  add_foreign_key "vacancies", "licence_requirements"
   add_foreign_key "vacancies", "occupations"
end

Did you find it helpful? Yes No

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