-- -- Table structure for table `hr_master` -- CREATE TABLE `hr_master` ( `id` bigint(20) UNSIGNED NOT NULL, `title` text COLLATE utf8mb4_unicode_ci DEFAULT NULL, `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `status` tinyint(1) DEFAULT 1, `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data for table `hr_master` -- INSERT INTO `hr_master` (`id`, `title`, `type`, `status`, `created_at`, `updated_at`) VALUES (1, 'Yes, Certificate IV\r\n', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (2, 'Yes, Certificate III', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (3, 'Yes, Diploma', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (4, 'Yes, Advanced Diploma', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (5, 'Yes, Bachelor Degree', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (6, 'Yes, Bachelor Degree (Honours)', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (7, 'Yes, Graduate Certificate', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (8, 'Yes, Masters Degree', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (9, 'Yes, Doctoral Degree', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (10, 'I have a qualification in disability which isn\'t listed', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (11, 'I don\'t have a qualification in disability', 'qualification_in_disability', 1, '2022-03-24 12:20:20', '2022-03-24 12:20:20'), (12, 'Provide First Aid', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (13, 'Provide CPR', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (14, 'Asthma Management', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (15, 'Anaphylaxis Management', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (16, 'Epilepsy Management', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (17, 'None of these', 'first_aid_accreditations', 1, '2022-03-24 12:23:27', '2022-03-24 12:23:27'), (18, 'I\'m fully vaccinated', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (19, 'I have a medical exemption', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (20, 'I\'m partially vaccinated', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (21, 'I\'m planning to be vaccinated as soon as possible', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (22, 'I haven\'t been vaccinated', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (23, 'I\'d prefer not to say', 'covid_19_vaccination_status', 1, '2022-03-24 13:28:51', '2022-03-24 13:28:51'), (24, 'I\'m an Australian citizen', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (25, 'I\'m a permanent resident and/or NZ citizen', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (26, 'I have a family/partner visa with no restrictions', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (27, 'I have a graduate temporary work visa', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (28, 'I have a holiday temporary work visa', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (29, 'I have a temporary visa with restrictions on work location (e.g. skilled regional visa 489)', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (30, 'I have a temporary protection or safe haven enterprise work visa', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (31, 'I have a temporary visa with no restrictions (e.g. doctoral student)', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (32, 'I have a temporary visa with restrictions on work hours (e.g. student visa, retirement visa)', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (33, 'I have a temporary visa with restrictions on industry (e.g. temporary activity visa 408)\r\n', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (34, 'I require sponsorship to work for a new employer (e.g. 482, 457)', 'right_to_work_in_australia', 1, '2022-03-24 13:33:56', '2022-03-24 13:33:56'), (39, '21 - 25', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (40, '26 - 30', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (41, '31 - 35', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (42, '36 - 40', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (43, '41 - 45', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (44, '46 - 50', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (45, '50+', 'hours_available_to_work_per_week', 1, '2022-03-24 13:37:48', '2022-03-24 13:37:48'), (46, 'within 7 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (47, '7 to 10 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (48, '10 to 15 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (49, '15 to 30 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (50, '30 to 45 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (51, '45 to 60 days', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (52, '60 days or more', 'when_can_you_join_the_team', 1, '2022-03-24 14:50:55', '2022-03-24 14:50:55'), (53, 'Support worker', 'job_position', 1, '2022-03-25 11:32:37', '2022-03-25 11:32:37'), (54, 'House manager', 'job_position', 1, '2022-03-25 11:32:37', '2022-03-25 11:32:37'); -- -- Indexes for dumped tables -- -- -- Indexes for table `hr_master` -- ALTER TABLE `hr_master` ADD PRIMARY KEY (`id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `hr_master` -- ALTER TABLE `hr_master` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=55; -- -- 28-04-2022 -- INSERT INTO `hr_master` (`id`, `title`, `type`, `status`, `created_at`, `updated_at`) VALUES (NULL, 'I\'m fully vaccinated (with Booster dose)', 'covid_19_vaccination_status', '1', '2022-03-24 13:28:51', '2022-03-24 13:28:51'); UPDATE `hr_master` SET `title` = 'I\'m fully vaccinated (without Booster dose)' WHERE `hr_master`.`id` = 18; UPDATE `hr_master` SET `status` = '0' WHERE `hr_master`.`id` = 54; -- -- 01-08-2023 -- INSERT INTO `hr_master` (`id`, `title`, `type`, `status`, `created_at`, `updated_at`) VALUES (NULL, 'Medication Administration', 'first_aid_accreditations', '1', '2023-08-01 10:11:42', '2023-08-01 10:11:42'), (NULL, 'Manual handling', 'first_aid_accreditations', '1', '2023-08-01 10:11:42', '2023-08-01 10:11:42');