INSERT INTO `hilis4`.`parent_organisations` (`parent_code`, `description`, `referral_type_id`)
VALUES ('MSDMDH', 'MATER DEI MALTA', '4');
SELECT @org_id := id FROM parent_organisations WHERE parent_code = 'MSDMDH';
INSERT INTO `hilis4`.`referral_sources` (`display_name`, `organisation_code`, `parent_organisation_id`, `referral_type_id`)
VALUES ('Mater Dei Hospital, Malta', 'MSDMDH', @org_id, 4);
INSERT INTO `hilis4`.`referrers` (`name`, `national_code`, `referral_type_id`) VALUES ('Betts, A', 'X0000001', 1);
SELECT @ref_id := id FROM referrers WHERE national_code = 'X0000001';
INSERT INTO `hilis4`.`referrer_department` (`referrer_id`, `parent_organisation_id`, `hospital_department_code`)
VALUES (@ref_id, @org_id, 824);
SELECT @refdept_id := id FROM referrer_department WHERE parent_organisation_id = @org_id;
UPDATE requests r SET r.referrer_department_id = @refdept_id, r.updated_at = r.updated_at
WHERE r.id IN (
/* from scripts/mater-dei/find_and_replace.pl */
226843,
226844,
233796,
233798,
233926,
233927,
241679,
244104,
244105,
244106,
255765,
252987,
256891,
263982,
265699,
266724,
268029,
296265,
296588,
303125,
298335,
301020,
304544,
305086,
309994,
311903,
311904,
316508,
317200,
317201,
317202,
319894,
327058,
328143,
229654 /* manual addition - hand-written form */
);
SELECT @src_id := id FROM referral_sources WHERE organisation_code = 'MSDMDH';
UPDATE patient_case SET referral_source_id = @src_id, time = time WHERE id IN (
SELECT patient_case_id FROM requests WHERE referrer_department_id = @refdept_id );
SELECT @user_id := id FROM users WHERE username = 'hmds-lth';
INSERT INTO request_history(request_id, action, user_id) VALUES
(226843, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(226844, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(233796, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(233798, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(233926, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(233927, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(241679, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(244104, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(244105, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(244106, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(255765, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(252987, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(256891, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(263982, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(265699, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(266724, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(268029, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(296265, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(296588, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(303125, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(298335, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(301020, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(304544, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(305086, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(309994, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(311903, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(311904, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(316508, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(317200, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(317201, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(317202, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(319894, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(327058, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(328143, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id),
(229654, 'amended referral source [Unknown -> Mater Dei Hospital]', @user_id);
