CALL bd_hospital.add_doctorByName('вася');
CALL bd_hospital.add_doctorByName('петя');
CALL bd_hospital.add_doctorByName('игорь');
CALL bd_hospital.add_doctorByName('Настя');
CALL bd_hospital.add_doctorByName('Злой чувак');
CALL bd_hospital.add_doctorByName('Федя');
CALL bd_hospital.add_doctorByName('Сергей');
CALL bd_hospital.add_doctorByName('Какойто китаец');
CALL bd_hospital.add_doctorByName('Таня');
CALL bd_hospital.add_doctorByName('Ира');
CALL bd_hospital.add_doctorByName('Дима');
CALL bd_hospital.add_doctorByName('Кирилл');
CALL bd_hospital.add_doctorByName('Владимир Путин');
CALL bd_hospital.add_doctorByName('Саша Грей');
CALL bd_hospital.add_doctorByName('Пупки');
CALL bd_hospital.add_doctorByName('Абама');

INSERT bd_hospital.job (name) VALUES('Хирург');
INSERT bd_hospital.job (name) VALUES('Патологонатом');
INSERT bd_hospital.job (name) VALUES('Бездельник');
INSERT bd_hospital.job (name) VALUES('Бос');
INSERT bd_hospital.job (name) VALUES('Терапевт');

INSERT bd_hospital.specialization (name) VALUES('Хирургия');
INSERT bd_hospital.specialization (name) VALUES('Диагностика');
INSERT bd_hospital.specialization (name) VALUES('Кардиология');


INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(1,'Хирург');
INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(1,'Патологонатом');
INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(2,'Хирург');
INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(2,'Бос');
INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(3,'Терапевт');
INSERT bd_hospital.map_doctor_job (id_doctor,job_name) VALUES(3,'Бездельник');

INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(1,'Хирургия');
INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(1,'Кардиология');
INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(2,'Кардиология');
INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(2,'Хирургия');
INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(3,'Диагностика');
INSERT bd_hospital.map_doctor_specialization (id_doctor,specialization_name) VALUES(3,'Кардиология');

CALL bd_hospital.add_patientByName("Анатолий Генадьевич");
CALL bd_hospital.add_patientByName("Анатолий Петров");
CALL bd_hospital.add_patientByName("Вася смирнов");
CALL bd_hospital.add_patientByName("Генадий анатольев");
CALL bd_hospital.add_patientByName("Степаша");
CALL bd_hospital.add_patientByName("Хрюша");
CALL bd_hospital.add_patientByName("Безруков");
CALL bd_hospital.add_patientByName("Безногов");
CALL bd_hospital.add_patientByName("Безтоловещнен");

UPDATE bd_hospital.patient SET id_doctor = 1 WHERE id = 1;
UPDATE bd_hospital.patient SET id_doctor = 1 WHERE id = 2;
UPDATE bd_hospital.patient SET id_doctor = 1 WHERE id = 3;
UPDATE bd_hospital.patient SET id_doctor = 2 WHERE id = 4;
UPDATE bd_hospital.patient SET id_doctor = 2 WHERE id = 5;
UPDATE bd_hospital.patient SET id_doctor = 3 WHERE id = 6;
UPDATE bd_hospital.patient SET id_doctor = 3 WHERE id = 7;

INSERT bd_hospital.illness(name) VALUES('Простуда');
INSERT bd_hospital.illness(name) VALUES('Гангрена');
INSERT bd_hospital.illness(name) VALUES('Диарея');
INSERT bd_hospital.illness(name) VALUES('Скалероз');
INSERT bd_hospital.illness(name) VALUES('Ревматизм');
INSERT bd_hospital.illness(name) VALUES('Криворукие');
INSERT bd_hospital.illness(name) VALUES('Амнезия');

INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(1,1,FALSE, '1997-1-1','1999-1-1');
INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(2,2,FALSE, '1991-1-1','1997-1-1');
INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(3,3,TRUE, '1991-1-1','1997-1-1');
INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(4,4,FALSE, '1997-1-1','1999-1-1');
INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(5,5,TRUE, '1991-1-1',NULL);
INSERT bd_hospital.diagnosis(id_doctor,id_patient, need_dispensary, open_date,close_date)
VALUES(6,6,FALSE, '1991-1-1','1997-1-1');

INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(1,'ПРОСТУДА');
INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(2,'ПРОСТУДА');
INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(3,'ДИАРЕЯ');
INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(4,'СКАЛЕРОЗ');
INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(5,'ПРОСТУДА');
INSERT bd_hospital.map_diagnosis_illness(id_diagnosis,illness_name) VALUES(6,'АМНЕЗИЯ');