 product_name,
 product_price,
 clinic_clinic_id) VALUES
-('JASC-P-HUJBUYHH778', 'Goodside Bras', 54, 'Bra', 432.42, 'CH-PLATINUM-JASC');
+('JASC-P-HUJBUYHH778', 'Mayers Braseir', 54, 'Bra', 432.42, 'CH-PLATINUM-JASC');
 
 INSERT INTO medications (
 medication_id,

medication_price,
supplier,
clinic_clinic_id) VALUES
('JASC-MED-UHGYHJNG343', 'for pain', 200, 'Ibuprofen', 43.20, 'MED Pact', 'CH-PLATINUM-JASC');

INSERT INTO medications (
medication_id,

  patient_nationality,
  patient_registered_date,
  patient_telephone_number) VALUES
('CH-PLATINUM-JASC', 'JASC-P-BVN309WDHN32', 'Vetenarian', 'Sience', '1982-11-19', 'Paris',
'829xxxyyyy', 'FR', 'eva45@gmail.com', 'Eva', 0, '12oih7g 323',
'Soraya', 'Dominicana', '2015-10-28', '809xxxyyyy');

INSERT INTO records (record_id, patient_patient_id) VALUES ('JASC-R-EVA', 'JASC-P-BVN309WDHN32');

INSERT INTO contact (clinic_clinic_id, contact_id, first_name, last_name, email, birth_date, has_account) VALUES ('CH-PLATINUM-JASC', 'JASC-STAFF-PAULINA', 'Paulina', 'Reyes', 'p@gmail.com', '1985-03-23', TRUE );
INSERT INTO contact (clinic_clinic_id, contact_id, first_name, last_name, email, birth_date, has_account) VALUES ('CH-PLATINUM-JASC', 'JASC-STAFF-SICARD', 'Julio', 'Sicard', 'js@gmail.com', '1980-11-18', FALSE);
INSERT INTO contact (clinic_clinic_id, contact_id, first_name, last_name, email, birth_date, has_account) VALUES ('CH-PLATINUM-JASC', 'JASC-STAFF-ADELSO', 'Adelso', 'Tejada', 'at@gmail.com', '1990-02-02', FALSE);
INSERT INTO contact (clinic_clinic_id, contact_id, first_name, last_name, email, birth_date, has_account) VALUES ('CH-PLATINUM-JASC', 'JASC-STAFF-ASTRID', 'Astrid', 'Incarnacion', 'ai@gmail.com', '1990-11-22', FALSE);

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',
'JASC123456',
'2016-11-14 10:10:00',
'JASC-P-BVN309WJHN32',
'Rhinoplasti for facial reconstruction',
0,
0,
0);
