 medication_price,
 supplier,
 clinic_clinic_id) VALUES
-('JASC-MED-UH43HJNG343', 'for pain', 100, 'IZuprina', 3.20, 'MED Pact', 'CH-PLATINUM-JASC');+('JASC-MED-UH43HJNG343', 'Surgical Anaesthetic', 100, 'I-Zuprina', 3.20, 'MED Pact', 'CH-PLATINUM-JASC');
meeting_place,
meeting_time,
meeting_title) VALUES
('CH-PLATINUM-JASC', 'JASC-M-NY934WHRC3', 'Make plans for charity event', 'Meeting Room 102', '2016-11-12 08:00:00', 'JASC Cancer Charity');

INSERT INTO  meetings_attendees (meeting_meeting_id, attendees_contact_id) VALUES ('JASC-M-NY934WHRC3', 'JASC-STAFF-PAULINA');
INSERT INTO  meetings_attendees (meeting_meeting_id, attendees_contact_id) VALUES ('JASC-M-NY934WHRC3', 'JASC-STAFF-ASTRID');

INSERT INTO appointments(clinic_clinic_id, appointment_id, appointment_time, patient_patient_id, appointment_description, appointment_access_from, appointment_type, appointment_status) VALUES (
'CH-PLATINUM-JASC',
'JASC123452',
'2016-11-14 11:10:00',
'JASC-P-BVN3DF43WED32',
'Botox and face lift',
0,
0,
0);
