INSERT INTO PATIENTS (ID, FIRSTNAME, LASTNAME, SEX, BIRTHDATE) VALUES (1, 'Sam', 'Jones', 'M', '1958-10-29');
INSERT INTO PATIENTS (ID, FIRSTNAME, LASTNAME, SEX, BIRTHDATE) VALUES (2, 'Susan', 'Johnson', 'F', '2001-05-26');
INSERT INTO PATIENTS (ID, FIRSTNAME, LASTNAME, SEX, BIRTHDATE) VALUES (3, 'Sally', 'Johannson', 'F', '1962-02-09');
INSERT INTO PATIENTS (ID, FIRSTNAME, LASTNAME, SEX, BIRTHDATE) VALUES (4, 'Santiago', 'Jimenez', 'M', '1925-09-09');
INSERT INTO PATIENTS (ID, FIRSTNAME, LASTNAME, SEX, BIRTHDATE) VALUES (5, 'Sun', 'Jiang', 'F', 2003-11-12);
INSERT INTO DOCTORS (ID, FIRSTNAME, LASTNAME, SPECIALTY) VALUES (1, 'Sean', 'Wilson', 'Hematology');
INSERT INTO DOCTORS (ID, FIRSTNAME, LASTNAME, SPECIALTY) VALUES (2, 'Kim', 'Gonzales', 'Hidrosis');
INSERT INTO DOCTORS (ID, FIRSTNAME, LASTNAME, SPECIALTY) VALUES (3, 'Devin', 'Liu', 'Lachrimation');
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (1, 1);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (1, 2);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (2, 2);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (3, 1);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (4, 1);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (4, 2);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (5, 3);
INSERT INTO PATIENTSDOCTORS (PATIENTID, DOCTORID) VALUES (5, 2);
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (1, 1, 'Pink pills', '10 mg', '13 pills', XMLPARSE(DOCUMENT 'Covered in anti-pink splotches.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (1, 1, 'Green liquid', '15 ml', '1 liter', XMLPARSE(DOCUMENT 'A very bad case of something needing green liquid.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (3, 1, 'Pink and green pills', '15 mg', '27 pills', XMLPARSE(DOCUMENT 'Ewwwww. Yech.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 1, 'Red pills', '8 mg', '32 pills', XMLPARSE(DOCUMENT 'Very, very sick.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 2, 'Little striped things', '17.3 mg', '14 things', XMLPARSE(DOCUMENT 'Little striped things beats eating worms.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 2, 'Pink pills', '8 mg', '53 pills', XMLPARSE(DOCUMENT 'Hyperhypohippopotamoiditus'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 1, 'Green liquid', '7 ml', '.5 liter', XMLPARSE(DOCUMENT 'An abundance of slithy toves.'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (5, 3, 'Little striped things', '3.71 mg', '27 things', XMLPARSE(DOCUMENT 'Lacking mimsy borogoves.'));