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 '<Diagnosis>Covered in anti-pink splotches.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (1, 1, 'Green liquid', '15 ml', '1 liter', XMLPARSE(DOCUMENT '<Diagnosis>A <b>very</b> bad case of something needing green liquid.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (3, 1, 'Pink and green pills', '15 mg', '27 pills', XMLPARSE(DOCUMENT '<Diagnosis>Ewwwww. Yech.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 1, 'Red pills', '8 mg', '32 pills', XMLPARSE(DOCUMENT '<Diagnosis>Very, very sick.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 2, 'Little striped things', '17.3 mg', '14 things', XMLPARSE(DOCUMENT '<Diagnosis>Little striped things beats eating worms.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 2, 'Pink pills', '8 mg', '53 pills', XMLPARSE(DOCUMENT '<Diagnosis>Hyperhypohippopotamoiditus</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (4, 1, 'Green liquid', '7 ml', '.5 liter', XMLPARSE(DOCUMENT '<Diagnosis>An abundance of slithy toves.</Diagnosis>'));
INSERT INTO PRESCRIPTIONS (PATIENTID, DOCTORID, MEDICATIONNAME, DOSAGE, QUANTITY, DIAGNOSIS) VALUES (5, 3, 'Little striped things', '3.71 mg', '27 things', XMLPARSE(DOCUMENT '<Diagnosis>Lacking mimsy borogoves.</Diagnosis>'));

