ALTER TABLE `users` CHANGE `city` `city` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `users` CHANGE `state` `state` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `postcode` `postcode` VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `training_assign_user` ADD `email_alert_count` BIGINT(20) UNSIGNED NULL DEFAULT '0' AFTER `certificate_status`; ALTER TABLE `training_assign_user` ADD `sms_alert_count` BIGINT(20) UNSIGNED NULL DEFAULT '0' AFTER `email_alert_count`; -- -------------------------------------------------------- -- -- Table structure for table `training_module_files` -- CREATE TABLE `training_module_files` ( `id` bigint(20) UNSIGNED NOT NULL, `training_module_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) NOT NULL, `seq` int(11) NOT NULL, `created_at` timestamp NOT NULL DEFAULT current_timestamp(), `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Indexes for dumped tables -- -- -- Indexes for table `training_module_files` -- ALTER TABLE `training_module_files` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `training_module_files` -- ALTER TABLE `training_module_files` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; COMMIT; ALTER TABLE `shift_case_goal` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `medication_admin_record_prn` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `medication_admin_record_shortterm` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `food_and_drink_chart` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `behaviour_log_add_option` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `sleep_record_chart` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `abc_log_sheet` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `medication_admin_record_sheet_option` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `bgl_chart` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `weight_recording_chart` ADD `report_id` BIGINT(20) UNSIGNED NOT NULL AFTER `id`; ALTER TABLE `weight_recording_chart` CHANGE `january` `january` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `february` `february` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `march` `march` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `april` `april` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `may` `may` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `june` `june` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `july` `july` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `august` `august` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `september` `september` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `october` `october` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `november` `november` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL, CHANGE `december` `december` VARCHAR(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL; ALTER TABLE `client` CHANGE `status` `status` TINYINT(1) NOT NULL DEFAULT '1'; -- -- Table structure for table `client_referral_emails` -- CREATE TABLE `client_referral_emails` ( `id` bigint(20) UNSIGNED NOT NULL, `email` varchar(200) NOT NULL, `code` varchar(200) NOT NULL, `datetime` datetime NOT NULL DEFAULT current_timestamp(), `status` varchar(200) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; -- -- Indexes for dumped tables -- -- -- Indexes for table `client_referral_emails` -- ALTER TABLE `client_referral_emails` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `client_referral_emails` -- ALTER TABLE `client_referral_emails` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `roster_management` ADD `parent_row_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `id`; ALTER TABLE `roster_management` ADD INDEX(`parent_row_id`); -- -- Table structure for table `settings` -- CREATE TABLE `settings` ( `id` bigint(20) UNSIGNED NOT NULL, `name` text COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `settings` -- ALTER TABLE `settings` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `settings` -- ALTER TABLE `settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `leave_request_header` ADD `is_long_leave` TINYINT(1) NOT NULL DEFAULT '0' AFTER `certificate`, ADD `type` TINYINT(1) NULL DEFAULT NULL AFTER `is_long_leave`, ADD `leave_status` TINYINT(1) NOT NULL DEFAULT '0' AFTER `type`, ADD `start_date` DATE NULL DEFAULT NULL AFTER `leave_status`, ADD `end_date` DATE NULL DEFAULT NULL AFTER `start_date`, ADD `start_time` TIME NULL DEFAULT NULL AFTER `end_date`, ADD `end_time` TIME NULL DEFAULT NULL AFTER `start_time`, ADD `total_time` BIGINT(20) NULL DEFAULT NULL AFTER `end_time`; ALTER TABLE `leave_request_header` ADD `declined_reason_why` TEXT NULL DEFAULT NULL AFTER `total_time`; ALTER TABLE `leave_request_header` ADD `working_days` TEXT NULL DEFAULT NULL AFTER `declined_reason_why`; ALTER TABLE `users` CHANGE `personal_leave_hours` `current_personal_leave_hours` DOUBLE NULL DEFAULT NULL, CHANGE `sick_leave_hours` `current_sick_leave_hours` DOUBLE NULL DEFAULT NULL; ALTER TABLE `users` ADD `future_personal_leave_hours` DOUBLE NULL DEFAULT NULL AFTER `current_sick_leave_hours`, ADD `future_sick_leave_hours` DOUBLE NULL DEFAULT NULL AFTER `future_personal_leave_hours`; ALTER TABLE `users` ADD `xero_employee_id` VARCHAR(255) NULL DEFAULT NULL AFTER `xero_sick_leave_hours`; ALTER TABLE `users` ADD `xero_leave_updated_at` DATETIME NULL DEFAULT NULL AFTER `xero_employee_id`; ALTER TABLE `roster_week_manager` DROP `weekno`; ALTER TABLE `roster_week_manager` ADD `created_at` DATETIME NULL DEFAULT NULL AFTER `weekend`, ADD `updated_at` DATETIME NULL DEFAULT NULL AFTER `created_at`; ALTER TABLE `roster_holiday_manager` DROP `zone_id`; ALTER TABLE `roster_holiday_manager` ADD `created_at` DATETIME NULL DEFAULT NULL AFTER `holiday`, ADD `updated_at` DATETIME NULL DEFAULT NULL AFTER `created_at`; ALTER TABLE `roster_clients` ADD `notes` TEXT NULL DEFAULT NULL AFTER `save_as`; ALTER TABLE `health_information` CHANGE `health_condition` `health_condition` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `secondary_health_issue` `secondary_health_issue` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `forensic_history` `forensic_history` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `network_issues` `network_issues` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `any_current_health_concerns` `any_current_health_concerns` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `current_medications` `current_medications` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `medication_administration_method` `medication_administration_method` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `medication_compliance` `medication_compliance` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `mental_health_condition` `mental_health_condition` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `psychiatric_mental_health_intervention` `psychiatric_mental_health_intervention` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `treatment_order` `treatment_order` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `identified_substance` `identified_substance` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `current_professional_service` `current_professional_service` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `risks_identified` `risks_identified` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `nature_of_required_care_delivery` `nature_of_required_care_delivery` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `mobility` `mobility` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `mobility_comments` `mobility_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `communication` `communication` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `communication_comments` `communication_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `elimination_issue` `elimination_issue` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `elimination_issue_comments` `elimination_issue_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `nutritional` `nutritional` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `nutritional_comments` `nutritional_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `personal_care` `personal_care` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `personal_care_comments` `personal_care_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `behaviour` `behaviour` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `behaviour_comments` `behaviour_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `challenging_behaviour` `challenging_behaviour` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `challenging_behaviour_comments` `challenging_behaviour_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `financial_management_issues` `financial_management_issues` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `significant_incidents` `significant_incidents` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `community_environment` `community_environment` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `support_level_classification` `support_level_classification` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `conditions` `conditions` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `conditions_comments` `conditions_comments` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `recommendations` `recommendations` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `referral_accepted` `referral_accepted` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `decision_maker` `decision_maker` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `reasons` `reasons` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `disability_funding_service` `disability_funding_service` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `participant_name` `participant_name` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `venue` `venue` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `stakeholders` `stakeholders` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; CREATE TABLE `roster_part_day_holiday_manager` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT , `description` VARCHAR(200) NULL DEFAULT NULL , `holiday` DATE NOT NULL , `start_time` TIME NULL DEFAULT NULL , `end_time` TIME NULL DEFAULT NULL , `created_at` INT NULL DEFAULT NULL , `updated_at` INT NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX (`holiday`)) ENGINE = InnoDB; ALTER TABLE `roster_part_day_holiday_manager` CHANGE `created_at` `created_at` DATETIME NULL DEFAULT NULL, CHANGE `updated_at` `updated_at` DATETIME NULL DEFAULT NULL; INSERT INTO `roster_part_day_holiday_manager` (`id`, `description`, `holiday`, `start_time`, `end_time`, `created_at`, `updated_at`) VALUES (NULL, 'Christmas Eve', '2021-12-24', '19:00:00', '00:00:00', NULL, NULL); ALTER TABLE `medication_authority_form_regular` CHANGE `upload_file` `upload_file` VARCHAR(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `service_agreement` CHANGE `participant_reprentative` `participant_reprentative` VARCHAR(255) NULL DEFAULT NULL, CHANGE `provider` `provider` VARCHAR(255) NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_update_emails` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL; -- -- 18-01-2022 library tables -- ALTER TABLE `library_all_places_for_behaviour_log` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_all_posible_triger_for_behaviour_log` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_incident_type` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_action_taken_manager` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_all_places_for_behaviour_log` ADD `status` TINYINT(1) NULL DEFAULT '1' AFTER `title`; ALTER TABLE `library_all_posible_triger_for_behaviour_log` ADD `status` TINYINT(1) NULL DEFAULT '1' AFTER `title`; ALTER TABLE `library_incident_type` ADD `status` TINYINT(1) NULL DEFAULT '1' AFTER `title`; ALTER TABLE `library_action_taken_manager` ADD `status` TINYINT(1) NULL DEFAULT '1' AFTER `title`; -- -- created at and updated at changes -- ALTER TABLE `abc_log_sheet` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `action_plan` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `action_taken_to_manage_behaviour` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `app_pages` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `assign_behaviour_log_library` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `assign_case_note` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `behaviour_log_add_option` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `behaviour_of_concern_list` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `bgl_chart` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `client` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `client_assign` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `food_and_drink_chart` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `health_information` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; -- -- ALTER TABLE `incident_additional_comments_and_findings` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_management_ackno` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_person_involved_in_event` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_report` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_settings_events` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_strategies_used_to_manage_behaviour` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_triggers` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `incident_types` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `information_sharing` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `insident_report_types` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `leave_request` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `leave_request_header` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_action_taken_manager` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_all_places_for_behaviour_log` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_all_posible_triger_for_behaviour_log` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `library_incident_type` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `management_meeting` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `management_meeting_description` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; -- -- ALTER TABLE `master_behaviour` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_case_note` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_communication` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_designations` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_disability_funding_service` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_elimination` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_goal` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_incident_possible_cause` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_incident_setting_event` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_incident_strategies` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_incident_trigger` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_incident_type` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_management_action` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_mobility` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_nature_of_required_care_delivery` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_ndis_commission_reportable_incidents` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_nutritional` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; -- -- ALTER TABLE `master_personal_care` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `master_support_level` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medicationstore` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_admin_record_medications_regular` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_admin_record_prn` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_admin_record_prn_medications` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_admin_record_sheet_option` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_admin_record_shortterm` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_authority_form` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `medication_authority_form_regular` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `notifications` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `notifications_acknowledgment` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `notifications_permissions` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `possible_triggers` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `profile_certificate` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `register_business_risk` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `register_feedback_and_complain` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_add_hours` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_add_hours_description` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_clients` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_holiday_manager` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_management` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_part_day_holiday_manager` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `roster_update_emails` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; -- -- ALTER TABLE `roster_week_manager` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `service_aggrement_supports` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `service_agreement` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `settings` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `shiftcasenote` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `shift_case_goal` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `sleep_record_chart` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `staff_meating` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `staff_meeting_description` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_answer` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_assign_user` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_category` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_marks` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_module` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_module_files` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `training_question` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `users` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `vehicle_assign` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `weekly_client_house_meeting` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; ALTER TABLE `weight_recording_chart` CHANGE `updated_at` `updated_at` TIMESTAMP NULL DEFAULT NULL, CHANGE `created_at` `created_at` TIMESTAMP NULL DEFAULT NULL; -- -- 28-01-2022 -- ALTER TABLE `roster_holiday_manager` ADD INDEX(`holiday`); -- -- 01-02-2022 -- ALTER TABLE `management_meeting_description` CHANGE `issue` `issue` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `date_reporting_back` `date_reporting_back` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; -- -- 03-02-2022 -- ALTER TABLE `settings` ADD `is_text` TINYINT(1) NULL DEFAULT '0' AFTER `value`; -- -- 07-02-2022 -- CREATE TABLE `email_templates` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `slug` VARCHAR(255) NOT NULL , `subject` VARCHAR(255) NULL DEFAULT NULL , `bcc` TEXT NULL DEFAULT NULL , `html` TEXT NULL DEFAULT NULL , `status` TINYINT(1) NOT NULL DEFAULT '1' , `attachments` TEXT NULL DEFAULT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `email_templates` ADD INDEX(`slug`); ALTER TABLE `email_templates` ADD `keywords` TEXT NULL DEFAULT NULL AFTER `html`; -- -- 14-02-2022 -- ALTER TABLE `client` CHANGE `reference_name` `reference_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `referre_contact_details` `referre_contact_details` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `address` `address` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `email` `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `cultural_identity` `cultural_identity` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `does_ndis_plan` `does_ndis_plan` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `ndis_plan_period` `ndis_plan_period` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `ndis_funding_management` `ndis_funding_management` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `ndis_plan_manager_detail` `ndis_plan_manager_detail` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `available_core_supports_budget` `available_core_supports_budget` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `ndis_number` `ndis_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `alternative_contact_number` `alternative_contact_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `contact_detail_kin` `contact_detail_kin` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `phone` `phone` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `guardian` `guardian` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `public_trustee` `public_trustee` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `support_linker` `support_linker` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `gp` `gp` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `other_involved_professionals` `other_involved_professionals` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `psychiatrist` `psychiatrist` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `psychologist` `psychologist` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `religion` `religion` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `restrictive_practise` `restrictive_practise` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `funding_level_hours` `funding_level_hours` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `funding_level_amount` `funding_level_amount` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `service_type` `service_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `reason_for_referral` `reason_for_referral` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `current_accommodation_type` `current_accommodation_type` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `future_housing_needs` `future_housing_needs` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `service_history` `service_history` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `general_health_stability` `general_health_stability` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `incident_additional_comments_and_findings` CHANGE `client_id` `client_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `user_id` `user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `incident_report_id` `incident_report_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `possible_cause_id` `possible_cause_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `shiftcasenote` CHANGE `shift_summary_report` `shift_summary_report` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, CHANGE `public_transport_house_vehicle_used` `public_transport_house_vehicle_used` LONGTEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL; -- -- 15-02-2022 -- ALTER TABLE `information_sharing` ADD `parent_surname` VARCHAR(255) NULL DEFAULT NULL AFTER `given_name`, ADD `parent_givenname` VARCHAR(255) NULL DEFAULT NULL AFTER `parent_surname`; ALTER TABLE `library_all_places_for_behaviour_log` CHANGE `title` `title` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `library_all_posible_triger_for_behaviour_log` CHANGE `title` `title` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `sleep_record_chart` CHANGE `description` `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `behaviour_of_concern_list` ADD `status` TINYINT(1) NULL DEFAULT '1' AFTER `client_id`; -- -- 16-02-2022 -- ALTER TABLE `medication_authority_form` CHANGE `upload_file` `upload_file` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `medic_alert_number` `medic_alert_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `allergies` `allergies` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `medicare_no` `medicare_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `concession_card_no` `concession_card_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_health_practitioner` `name_of_health_practitioner` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `professional_role` `professional_role` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `signature` `signature` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `contact_details` `contact_details` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_parent_carer` `name_of_parent_carer` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `parent_sign` `parent_sign` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `medication_authority_form_regular` CHANGE `upload_file` `upload_file` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `medic_alert_number` `medic_alert_number` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `allergies` `allergies` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `medicare_no` `medicare_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `concession_card_no` `concession_card_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_health_practitioner` `name_of_health_practitioner` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `professional_role` `professional_role` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `signature` `signature` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `contact_details` `contact_details` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_parent_carer` `name_of_parent_carer` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `parent_sign` `parent_sign` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `service_agreement` CHANGE `upload_file` `upload_file` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `support_provided` `support_provided` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `signature_participant` `signature_participant` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `sign_of` `sign_of` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `sign_of_authorized_person` `sign_of_authorized_person` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_authorized` `name_of_authorized` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `information_sharing` CHANGE `upload_file` `upload_file` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `surname` `surname` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `given_name` `given_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `relationship` `relationship` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `postal_address` `postal_address` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `email` `email` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `aus_dept` `aus_dept` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `crn` `crn` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `state` `state` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `medical` `medical` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `service_provider` `service_provider` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `school_attend` `school_attend` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name_of_third_party` `name_of_third_party` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `third_party_details` `third_party_details` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `agree1` `agree1` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `agree2` `agree2` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `agree3` `agree3` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `signature` `signature` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `date` `date` DATE NULL DEFAULT NULL, CHANGE `agree4` `agree4` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `incident_person_involved_in_event` CHANGE `status` `status` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `contact_no` `contact_no` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `age` `age` INT(15) NULL DEFAULT NULL; ALTER TABLE `incident_person_involved_in_event` CHANGE `contact_no` `contact_no` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `incident_report` CHANGE `region` `region` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `what_happened` `what_happened` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `happen_location` `happen_location` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `upload_file` `upload_file` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; -- -- 17-02-2022 -- CREATE TABLE `certificate_reminder_sent` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT , `certificate_id` BIGINT(20) NOT NULL , `expiry_date` DATE NOT NULL , `days` BIGINT(20) NOT NULL , `days_type` VARCHAR(20) NOT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX (`certificate_id`, `expiry_date`, `days`, `days_type`)) ENGINE = InnoDB; -- -- 19-02-2022 -- TRUNCATE `training_answer`; TRUNCATE `training_assign_user`; TRUNCATE `training_marks`; TRUNCATE `training_module`; TRUNCATE `training_module_files`; TRUNCATE `training_question`; ALTER TABLE `training_module` CHANGE `category_id` `category_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `training_module` ADD FOREIGN KEY (`category_id`) REFERENCES `training_category`(`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `training_module` CHANGE `file` `file` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `link` `link` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL, CHANGE `status` `status` TINYINT(1) NULL DEFAULT '1'; SET foreign_key_checks = 0; ALTER TABLE `training_question` CHANGE `training_module_id` `training_module_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `status` `status` TINYINT(1) NULL DEFAULT '1'; ALTER TABLE `training_assign_user` CHANGE `training_module_id` `training_module_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL, CHANGE `user_id` `user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; ALTER TABLE `training_assign_user` ADD FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `training_answer` CHANGE `user_id` `user_id` BIGINT(20) UNSIGNED NOT NULL, CHANGE `answer` `answer` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `training_answer` ADD FOREIGN KEY (`user_id`) REFERENCES `users`(`id`) ON DELETE CASCADE ON UPDATE CASCADE; ALTER TABLE `training_category` CHANGE `category_name` `category_name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `training_marks` CHANGE `tot_questions` `tot_questions` BIGINT(20) NULL DEFAULT NULL, CHANGE `marks_per_question` `marks_per_question` BIGINT(20) NULL DEFAULT NULL, CHANGE `passing_mark` `passing_mark` BIGINT(20) NULL DEFAULT NULL, CHANGE `status` `status` TINYINT(1) NULL DEFAULT '1', CHANGE `training_module_id` `training_module_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL; -- -- 19-04-2022 -- UPDATE `library_incident_type` SET `title` = 'Refused to go back to house' WHERE `library_incident_type`.`id` = 1; -- -- 05-05-2022 -- DELETE FROM `shiftcasenote` WHERE `client_id` != 2028; DELETE FROM `incident_report` WHERE `client_id` != 2028; DELETE FROM `shift_case_goal` WHERE `client_id` != 2028; -- -- 13-05-2022 -- ALTER TABLE `settings` CHANGE `name` `name` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL; ALTER TABLE `settings` ADD INDEX(`name`); -- -- Table structure for table `user_settings` -- CREATE TABLE `user_settings` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `value` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `is_text` tinyint(1) DEFAULT 0, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `user_settings` -- ALTER TABLE `user_settings` ADD PRIMARY KEY (`id`), ADD KEY `name` (`name`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `user_settings` -- ALTER TABLE `user_settings` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; ALTER TABLE `user_settings` ADD `user_id` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `id`; -- -- HR Module -- 13-05-2022 -- CREATE TABLE `applicants` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT , `first_name` VARCHAR(255) NOT NULL , `last_name` VARCHAR(255) NOT NULL , `gender` VARCHAR(1) NOT NULL , `date_of_birth` DATE NOT NULL , `email` VARCHAR(255) NOT NULL , `contact_number` VARCHAR(100) NULL DEFAULT NULL , `address` TEXT NULL DEFAULT NULL , `suburb` VARCHAR(255) NULL DEFAULT NULL , `state` VARCHAR(255) NULL DEFAULT NULL , `postcode` VARCHAR(100) NULL DEFAULT NULL , `emergency_contact_name` VARCHAR(255) NULL DEFAULT NULL , `emergency_contact_number` VARCHAR(100) NULL DEFAULT NULL , `qualification_in_disability` BIGINT(20) UNSIGNED NULL DEFAULT NULL , `experience_as_a_disability_support_worker` TINYINT(1) NULL DEFAULT '0' , `national_police_certificate_for_employment` TINYINT(1) NULL DEFAULT '0' , `current_working_with_children_wwc_check` TINYINT(1) NULL DEFAULT '0' , `ndis_worker_screening_check` TINYINT(1) NULL DEFAULT '0' , `first_aid_accreditations` BIGINT(20) UNSIGNED NULL DEFAULT NULL , `current_australian_drivers_licence` TINYINT(1) NULL DEFAULT '0' , `regular_access_to_a_car` TINYINT(1) NULL DEFAULT '0' , `covid_19_vaccination_status` BIGINT(20) UNSIGNED NULL DEFAULT NULL , `right_to_work_in_australia` BIGINT(20) UNSIGNED NULL DEFAULT NULL , `hours_available_to_work_per_week` BIGINT(20) UNSIGNED NULL DEFAULT NULL , `ip_address` VARCHAR(100) NULL DEFAULT NULL , `status` TINYINT(1) NULL DEFAULT '0' , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `applicants` ADD `country` VARCHAR(100) NULL DEFAULT NULL AFTER `postcode`; ALTER TABLE `applicants` ADD `when_can_you_join_the_team` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `hours_available_to_work_per_week`; ALTER TABLE `applicants` ADD `application_id` VARCHAR(255) NULL DEFAULT NULL AFTER `id`; ALTER TABLE `applicants` ADD `job_position` BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER `application_id`, ADD INDEX (`job_position`); CREATE TABLE `applicants_first_aid_accreditations` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT , `first_aid_accreditations_id` BIGINT(20) UNSIGNED NOT NULL , `user_id` BIGINT(20) UNSIGNED NOT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX (`user_id`), INDEX (`first_aid_accreditations_id`)) ENGINE = InnoDB; ALTER TABLE `applicants` DROP `first_aid_accreditations`; ALTER TABLE `applicants_first_aid_accreditations` ADD FOREIGN KEY (`user_id`) REFERENCES `applicants`(`id`) ON DELETE CASCADE ON UPDATE CASCADE; -- -- 28-03-2022 -- ALTER TABLE `applicants_first_aid_accreditations` DROP FOREIGN KEY `applicants_first_aid_accreditations_ibfk_1`; CREATE TABLE `hr_static_numbers` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT , `name` VARCHAR(255) NOT NULL , `value` TEXT NULL DEFAULT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB; ALTER TABLE `hr_static_numbers` CHANGE `value` `value` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; INSERT INTO `hr_static_numbers` (`id`, `name`, `value`, `created_at`, `updated_at`) VALUES (NULL, 'application_count', '1000', '2022-03-28 16:25:11', '2022-03-28 16:25:11'); -- -- Table structure for table `hr_documents` -- CREATE TABLE `hr_documents` ( `id` bigint(20) NOT NULL, `name` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `issue_date` date DEFAULT NULL, `expiry_date` date DEFAULT NULL, `certificate` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notification` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `notification_trigger` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(5) DEFAULT NULL, `user_id` bigint(20) UNSIGNED DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `hr_documents` -- ALTER TABLE `hr_documents` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `hr_documents` -- ALTER TABLE `hr_documents` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; -- -- 01-04-2022 -- ALTER TABLE `applicants` ADD `first_aid_accreditations` TEXT NULL DEFAULT NULL AFTER `ndis_worker_screening_check`; DROP TABLE `applicants_first_aid_accreditations`; -- -- Table structure for table `hr_templates` -- CREATE TABLE `hr_templates` ( `id` bigint(20) NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `subject` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `html` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `keywords` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` tinyint(1) NOT NULL DEFAULT 1, `attachments` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `suggested_roles` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, `created_by` bigint(20) UNSIGNED DEFAULT NULL, `updated_by` bigint(20) UNSIGNED DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Indexes for dumped tables -- -- -- Indexes for table `hr_templates` -- ALTER TABLE `hr_templates` ADD PRIMARY KEY (`id`), ADD KEY `slug` (`slug`); -- -- AUTO_INCREMENT for table `hr_templates` -- ALTER TABLE `hr_templates` MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT; ALTER TABLE `hr_templates` CHANGE `html` `html` LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `hr_templates` CHANGE `suggested_roles` `designations` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `hr_templates` CHANGE `subject` `description` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL; ALTER TABLE `hr_templates` ADD `document_file` TEXT NULL DEFAULT NULL AFTER `html`; INSERT INTO `hr_master` (`id`, `title`, `type`, `status`, `created_at`, `updated_at`) VALUES (NULL, 'Qualification Certificates', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'NDIS Worker Screening', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'DHS - Working with Children Check', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Driving Licence', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'First Aid', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Medication Certificate', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'NDIS Worker Orientation Module', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Covid - 19 Infection Control Training', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Covid Vaccination Digital Certificate', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Visa Status Document ', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Birth Certificate', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Passport', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Citizen certificate', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Medicare card', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Bills', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'), (NULL, 'Other', 'document_name', '1', '2022-04-12 11:44:49', '2022-04-12 11:44:49'); CREATE TABLE `user_interview_schedules` ( `id` BIGINT(20) NOT NULL AUTO_INCREMENT , `user_id` BIGINT(20) NOT NULL , `date` DATE NOT NULL , `time` TIME NOT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX (`user_id`)) ENGINE = InnoDB; CREATE TABLE `user_details` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT , `user_id` BIGINT(20) UNSIGNED NOT NULL , `qualification_in_disability` BIGINT(20) NULL DEFAULT NULL , `experience_as_a_disability_support_worker` TINYINT(1) NULL DEFAULT NULL , `national_police_certificate_for_employment` TINYINT(1) NULL DEFAULT NULL , `current_working_with_children_wwc_check` TINYINT(1) NULL DEFAULT NULL , `ndis_worker_screening_check` TINYINT(1) NULL DEFAULT NULL , `first_aid_accreditations` TEXT NULL DEFAULT NULL , `current_australian_drivers_licence` TINYINT(1) NULL DEFAULT NULL , `regular_access_to_a_car` TINYINT(1) NULL DEFAULT NULL , `covid_19_vaccination_status` BIGINT(20) NULL DEFAULT NULL , `right_to_work_in_australia` BIGINT(20) NULL DEFAULT NULL , `hours_available_to_work_per_week` BIGINT(20) NULL DEFAULT NULL , `when_can_you_join_the_team` BIGINT(20) NULL DEFAULT NULL , `pay_rate` DOUBLE NULL DEFAULT NULL , `hours` DOUBLE NULL DEFAULT NULL , `incentives` VARCHAR(255) NOT NULL , `created_at` DATETIME NULL DEFAULT NULL , `updated_at` DATETIME NULL DEFAULT NULL , `updated_by` BIGINT(20) UNSIGNED NULL DEFAULT NULL , PRIMARY KEY (`id`), INDEX (`user_id`)) ENGINE = InnoDB; ALTER TABLE `users` ADD `application_id` VARCHAR(255) NULL DEFAULT NULL AFTER `status`; ALTER TABLE `user_details` CHANGE `incentives` `incentives` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL; ALTER TABLE `user_details` ADD `level` VARCHAR(255) NULL DEFAULT NULL AFTER `hours`; ALTER TABLE `training_category` ADD `email_title` VARCHAR(255) NULL DEFAULT NULL AFTER `category_image`; -- -- 04-08-2022 -- UPDATE `users` SET name=CONCAT(`first_name`,' ',`last_name`) WHERE 1 = 1 -- -- 01-09-2022 -- ALTER TABLE `settings` ADD `key` VARCHAR(255) NULL DEFAULT NULL AFTER `name`; -- -- 05-09-2022 -- ALTER TABLE `users` ADD `otp_settings` VARCHAR(255) NULL DEFAULT NULL AFTER `is_system`; ALTER TABLE `users` ADD `country_code` VARCHAR(100) NULL DEFAULT NULL AFTER `password`;