mysql 5 queries

DROP TABLE `Ward`; CREATE TABLE `Ward` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `WardID` varchar(11) default NULL, `ailment` varchar(255) default NULL, `bedQuantity` mediumint default NULL, `private` varchar(255) default NULL, `charge` varchar(100) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("51311376899","general",43,"No","276.15"),("70756171799","cancer",132,"Yes","48.12"),("35950877399","cancer",151,"Yes","237.19"),("68881624199","cancer",103,"Yes","179.07"),("39336593999","heart",100,"No","282.63"),("24875945599","heart",61,"Yes","82.90"),("82558807299","cancer",36,"Yes","209.27"),("77660362999","heart",47,"Yes","250.28"),("00474282199","cancer",176,"No","207.64"),("30331625599","general",130,"No","152.62"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("27690458099","heart",113,"Yes","171.45"),("41424458799","cancer",160,"Yes","261.76"),("08667822999","general",120,"Yes","275.14"),("27492075899","heart",21,"No","296.91"),("43314656899","general",103,"No","96.68"),("13472232299","general",31,"Yes","36.19"),("18736802999","heart",3,"No","137.00"),("58318403899","general",179,"Yes","201.76"),("92739765899","general",102,"No","143.07"),("42367653399","cancer",73,"No","154.72"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("88494248399","heart",185,"No","203.94"),("55342757999","cancer",99,"No","263.97"),("33404544699","heart",162,"No","76.14"),("77583048999","general",106,"Yes","67.53"),("18575884699","general",78,"Yes","292.00"),("24795434299","heart",182,"No","266.84"),("38987211399","cancer",189,"Yes","64.72"),("28267929699","general",65,"Yes","183.86"),("20355883099","general",81,"Yes","49.01"),("15431687999","cancer",64,"Yes","185.58"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("83696561899","general",44,"Yes","215.01"),("94687616699","general",99,"No","68.20"),("92395415599","heart",80,"No","67.39"),("33412104399","general",101,"No","135.82"),("41833151399","heart",68,"Yes","86.97"),("03228582999","heart",189,"Yes","295.89"),("05992795699","general",35,"Yes","35.39"),("73247248299","general",73,"No","220.14"),("36725460299","general",7,"Yes","43.20"),("14615070999","general",23,"No","238.06"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("15276287599","heart",54,"Yes","264.90"),("75899827099","general",61,"Yes","230.36"),("39447584799","cancer",103,"No","195.58"),("52750412599","general",126,"No","131.78"),("95781906499","general",139,"Yes","182.81"),("67513753799","general",77,"Yes","53.92"),("54756990499","general",122,"No","204.65"),("92455319299","heart",114,"No","62.71"),("44474490199","heart",34,"No","217.49"),("72917642699","heart",65,"Yes","145.86"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("23908927599","heart",100,"Yes","164.75"),("65467928199","general",154,"Yes","219.67"),("19637611099","heart",53,"No","137.45"),("97415946499","heart",110,"No","194.21"),("85638505699","heart",68,"No","292.32"),("54867821499","cancer",97,"Yes","242.63"),("89945307999","cancer",195,"No","269.47"),("14315375699","cancer",8,"No","72.45"),("23568937999","general",130,"Yes","236.51"),("50548186599","general",56,"Yes","240.96"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("66555838999","general",36,"No","54.22"),("92762548199","general",64,"No","255.49"),("71513882099","heart",19,"No","170.90"),("44991810199","general",83,"No","224.68"),("85979248099","cancer",155,"No","44.74"),("71335678199","cancer",24,"Yes","82.95"),("03205585799","general",60,"Yes","47.06"),("14393851799","cancer",37,"No","153.19"),("52491000299","general",49,"Yes","179.57"),("47605048799","cancer",58,"Yes","223.96"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("73535843099","general",176,"No","243.76"),("28997789899","general",195,"No","205.43"),("30749610099","heart",117,"No","298.96"),("36710719899","cancer",108,"Yes","234.93"),("91672406699","heart",156,"Yes","231.74"),("48326422099","heart",191,"Yes","230.86"),("92658900399","general",152,"No","136.88"),("34339498199","general",13,"Yes","250.82"),("35971472199","general",126,"No","234.92"),("82311721699","general",63,"Yes","287.34"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("67749835899","general",72,"Yes","262.47"),("42230115199","heart",197,"No","108.13"),("82920760099","cancer",29,"Yes","159.16"),("68359440399","heart",155,"No","47.68"),("81876283399","general",125,"No","297.04"),("59566492699","heart",96,"Yes","44.99"),("54662482499","general",139,"No","167.12"),("16561297399","heart",8,"No","68.12"),("04651340499","cancer",119,"Yes","37.98"),("20739797099","cancer",174,"No","143.96"); INSERT INTO `Ward` (`WardID`,`ailment`,`bedQuantity`,`private`,`charge`) VALUES ("92543761099","cancer",21,"No","115.18"),("26937555599","general",151,"No","258.20"),("83217702799","general",76,"No","194.59"),("55527981799","heart",95,"Yes","60.44"),("03594316399","cancer",37,"No","117.10"),("54860245099","general",45,"Yes","171.47"),("37834544099","general",75,"No","291.72"),("02371022699","cancer",103,"No","96.13"),("22760152199","heart",188,"No","248.36"),("03682498199","cancer",157,"Yes","238.77"); DROP TABLE `Ward_Sister`; CREATE TABLE `Ward_Sister` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `wardID` varchar(11) default NULL, `wardSisID` varchar(13) default NULL, `name` varchar(255) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("71911968099","16980803 0218","Olympia Singleton"),("77881056499","16960610 6798","Colleen Mcclain"),("34728495499","16840916 4178","Stacey Figueroa"),("15992435899","16580315 7840","Serina Huffman"),("66792126099","16040529 2764","Maxine Johnston"),("58588358299","16280630 6748","Daryl Haley"),("93982318899","16481205 5129","Vanna Obrien"),("51975250299","16960616 6537","Iliana Green"),("14724351899","16120227 9491","Blair Guerrero"),("78391990999","16480816 2731","Lisandra Stokes"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("69286415899","16291007 4091","Ramona Cash"),("30266022699","16131025 2927","Guinevere Phelps"),("42947456799","16390822 7436","Gail Maddox"),("64772619099","16201109 5573","Delilah Tate"),("73553029299","16501110 9898","Gay Strickland"),("33761229899","16730614 2113","Carla Evans"),("04966131999","16060913 9464","Mechelle Alvarado"),("43829791699","16540822 6511","Mara Hammond"),("50620012399","16290708 2891","Xandra Figueroa"),("55297779299","16130425 0432","Lois Serrano"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("36219918399","16890323 6118","Marny Bradley"),("77989662299","16730612 4046","Brianna Baker"),("22928441799","16641030 0708","Sonia Hopkins"),("15252543699","16930120 3494","Farrah Le"),("50851379199","16570808 5039","Nina Pitts"),("33340892099","16461026 9187","Lani Collins"),("24895188099","16870504 3795","Blaine Leon"),("03518993399","16130208 2324","McKenzie Brady"),("86381763799","16200927 1426","Rana Aguirre"),("45606740799","16550923 6674","Christine Kidd"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("68930143299","16540319 7345","Maris Juarez"),("07661836399","16040708 3237","Camilla Harrell"),("68954637199","16530304 7665","Anne Baldwin"),("78972953999","16110718 5140","Tatyana Campbell"),("40450547299","16640607 2345","Grace Bennett"),("56504599599","16480505 6977","Hannah Hays"),("12761833199","16880110 2552","Germane Brady"),("17807386099","16880904 7148","Tashya Copeland"),("75607257699","16650906 4264","Brynne Strong"),("66237931799","16061129 5791","Tatiana Oliver"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("69876144199","16590928 7640","Alisa Livingston"),("48895971799","16650414 8393","Shoshana Hodges"),("89300451199","16021017 4892","Cleo Burch"),("62832246799","16470712 3172","Alea Phelps"),("33700259599","16830216 9969","Idola Rowland"),("19617670099","16901118 6716","Charlotte Dotson"),("29360965199","16070917 1151","Mercedes Hamilton"),("45506479299","16401007 1217","Jada Mccormick"),("73684536999","16230101 9440","Christen Noble"),("07794095899","16080110 6378","Angela Rivers"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("25499326599","16040607 2181","Joelle Warren"),("83997319699","16730801 5093","Madeline Perkins"),("89283227299","16120419 4276","Maxine Oneill"),("81242149899","16330626 4122","Martena Macias"),("25357213999","16420910 8770","Helen Grant"),("82781723399","16961026 2231","Brynn Ferrell"),("34246936999","16720230 1979","Grace Lowe"),("96399050399","16070530 8914","Minerva Ray"),("75403485999","16811203 6721","Clio Juarez"),("11811003699","16781212 5651","Shoshana Beck"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("57801194099","16360920 6960","Leila Chen"),("14318858899","16980415 8138","Imelda Horne"),("08455196599","16920410 5424","Calista Padilla"),("36427631199","16210828 8164","Charity Moses"),("22457634999","16250728 7908","Colleen Ashley"),("98586070299","16781017 1772","Kerry Kennedy"),("60488630299","16501016 6253","Jillian Pena"),("25363908199","16470904 5480","Jessica Lambert"),("92890826599","16120421 4751","Mia Pierce"),("57948082299","16440118 5865","Breanna Odonnell"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("08976977699","16001112 9608","Susan Pratt"),("19764129899","16011029 8288","Whitney Avila"),("41583244099","16861227 6157","Calista Hurley"),("98934213499","16670810 7963","Haley Potter"),("07216206399","16690422 0586","Lacey Carr"),("46919262799","16671225 6137","Shelby Rodriquez"),("84980362299","16911215 2658","Clare Pope"),("37664376699","16311117 5828","MacKensie Hayes"),("83621398099","16231225 4333","Courtney Pruitt"),("30858159599","16960802 2290","Gail Best"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("35826200199","16281224 0261","Lacota Rhodes"),("51825625899","16761214 8879","Laurel Howe"),("68344852499","16630403 2128","Zephr Garcia"),("82562183899","16190308 6013","Katell Avila"),("89803371099","16800325 8921","Angela Pugh"),("09376389999","16081218 3713","Hyacinth Barrera"),("60349067599","16080914 2086","Noelle Dawson"),("03554026799","16050317 4013","Zenia Clayton"),("99583535599","16690117 9819","Shaine Dyer"),("23797036499","16691211 5141","Marcia Soto"); INSERT INTO `Ward_Sister` (`wardID`,`wardSisID`,`name`) VALUES ("58322177699","16130306 0048","Courtney Russo"),("27565266799","16770524 0484","Ginger Noble"),("91828361699","16100923 7247","Madeson Elliott"),("39785774099","16300710 2654","Karly Morrison"),("12979165499","16211210 3250","Jessica Guy"),("31651245799","16480224 4741","Yuri Lindsey"),("43263232399","16940929 7398","Illana Nixon"),("84388266399","16710915 8969","Idola Rhodes"),("28270261499","16440707 4964","Colette Melendez"),("77758264199","16920408 4512","Evangeline Ochoa"); DROP TABLE `Nurse`; CREATE TABLE `Nurse` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `wardID` varchar(11) default NULL, `nurseID` varchar(13) default NULL, `name` varchar(255) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("36368006699","16690115 4390","Tanek Wall"),("83758012299","16150307 3452","Charles Burton"),("72237156499","16120714 8469","Bradley Dorsey"),("25910317399","16470614 3007","Ryder Reed"),("77517724599","16670214 3642","Paul Skinner"),("81614869699","16960608 8699","Isaac Stokes"),("86508816399","16210318 7965","Amal Odonnell"),("07594382599","16180823 8826","Reese Moody"),("02946730599","16380417 2439","Zeph Weber"),("78356101299","16420804 5759","Wallace Washington"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("65871424099","16680729 8077","Cole Huber"),("68990122299","16000924 4831","Adam Mclean"),("13630813199","16050618 4290","Emmanuel Ballard"),("50959544799","16280726 1363","Henry Mcbride"),("24854561099","16060812 2008","Garrison Hatfield"),("30410445299","16530912 8493","Chaim Roy"),("74854211399","16320106 0252","Leonard Riggs"),("55707385899","16861015 1444","Nathan Mercer"),("57887247599","16380315 6748","Amos Horn"),("53865177199","16840312 2966","Ryder Mercer"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("61285620099","16820923 5582","Phillip Mccarty"),("35465853499","16481001 0167","Todd Burch"),("86594053299","16430818 7469","Elijah Lott"),("58255210099","16420410 0319","Noble Oneill"),("77273492199","16470521 9949","Upton Espinoza"),("45343621399","16180315 4234","Brennan Buckner"),("93410963399","16201026 1853","Zeph Wilkins"),("06993861099","16111005 6411","Plato Duffy"),("83436686899","16920516 9544","Colin Hudson"),("98775355599","16250902 8888","Jameson Soto"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("92245473999","16220924 0882","Garrison Lynn"),("44402507399","16550618 8993","Hyatt Cooley"),("07466233499","16420601 9996","Dane Nielsen"),("59863288699","16070106 4149","Byron Burnett"),("14458356399","16151028 1585","Ulric Macdonald"),("84912370399","16540511 8653","Gabriel Sharp"),("69795570999","16331213 0184","Magee Hurley"),("57256863799","16210407 2364","Todd Castaneda"),("21416294899","16371220 5347","Ivor Wiggins"),("16945036699","16850824 9672","Ivor Huffman"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("15480269399","16600114 2931","Demetrius Merritt"),("66659573399","16640401 3598","Wylie Steele"),("91508203299","16201112 9158","Nash Mcclain"),("44948819099","16370112 8500","Kasper Woods"),("17215280399","16130508 1778","Erasmus Avila"),("41503549099","16540625 3475","Cody Clemons"),("29811775899","16511030 2675","Lucian Prince"),("11299132299","16020511 0125","Drake Lopez"),("16623334399","16540329 6402","Brendan Cote"),("22729294199","16660630 8713","Uriah Rodriquez"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("31873380199","16470310 5165","Tanek Workman"),("77271347199","16261229 9269","Micah Logan"),("05612564499","16950930 1611","Declan Joyner"),("38411840599","16140106 8133","Barrett Donaldson"),("85865581899","16761207 1493","Dolan Berg"),("01643940799","16580911 7186","Phillip Kelly"),("82857593899","16701222 0534","Jared Acosta"),("38720955999","16310613 7718","Hasad Farley"),("42789701899","16151112 2044","Reese Dejesus"),("34793064599","16870315 0071","Jerry Walker"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("62310022199","16991125 0273","Harlan Kerr"),("72626191799","16751216 4729","Trevor Arnold"),("33497132599","16990123 8726","Lucian Vega"),("09856624699","16821220 3718","Jameson Underwood"),("56899317199","16090119 0306","Hammett Martin"),("57616176499","16820611 5308","Dalton Parker"),("83409072699","16110804 3173","Norman Herrera"),("81349247199","16171120 5276","Jesse Ellison"),("66619857699","16191110 1192","Austin Haley"),("64302915199","16621029 7351","Lars Yates"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("80768371699","16341020 5623","Ashton Levine"),("60242755699","16471208 9426","Clarke Nguyen"),("06437027999","16171204 0748","Alec Melendez"),("61434575299","16040414 4404","Marsden Craft"),("35264010799","16450613 8728","Jermaine Soto"),("78732050799","16520305 5321","Robert Kline"),("17472820299","16820129 2565","Lucius Williamson"),("37630823699","16110201 7421","Hamish Walls"),("69865828599","16961011 5777","Merrill Ramirez"),("84633074699","16851210 6090","Moses Chambers"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("99388054699","16280330 5354","Reese Washington"),("50323065299","16291220 9679","Gabriel Ramsey"),("32601217799","16980813 6106","Charles Vargas"),("35627285299","16620202 9283","John Robbins"),("57781733799","16830907 8494","Callum Butler"),("01661312999","16500410 9335","Declan Fox"),("20586466199","16251015 5100","Hakeem Browning"),("37868025499","16911214 1784","Griffin Scott"),("57896811899","16810330 4260","Brennan Roman"),("19906294899","16270403 5977","Rafael Mack"); INSERT INTO `Nurse` (`wardID`,`nurseID`,`name`) VALUES ("06481046199","16121227 3716","Drake Hanson"),("28279989599","16760906 3180","Melvin Hobbs"),("57861286699","16791123 4545","Callum Mccray"),("06669270599","16601103 8996","Elmo Mann"),("49859048199","16570118 0928","Bradley Horne"),("50870939899","16850524 4973","Cain Nicholson"),("26623154699","16100313 6767","Patrick Porter"),("55435813499","16330615 6757","Hakeem Hess"),("63621879899","16390415 5987","Noble Frazier"),("99692593199","16061018 1406","Dean Cook"); DROP TABLE `Patient`; CREATE TABLE `Patient` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `patientID` varchar(11) default NULL, `name` varchar(255) default NULL, `DoB` varchar(255), `address` varchar(255) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("57581379399","Porter","04/03/2013","Ap #433-8384 Mauris St."),("12635153699","Amelia","05/06/1994","8444 Ac Street"),("39300150399","Colby","10/06/2004","P.O. Box 110, 7106 Morbi Ave"),("22271260999","Xanthus","31/01/1988","Ap #628-5419 Faucibus Road"),("23617224199","Rogan","21/04/1981","P.O. Box 375, 6948 In, Rd."),("81306153899","Hunter","18/11/2018","8678 Hendrerit Av."),("74711909199","Dale","21/01/2010","6300 Orci Road"),("51956683099","Tobias","16/08/2000","240-8327 Cras Rd."),("53322841699","Victor","18/07/2002","5332 Pede, Ave"),("49341514499","Ursula","19/01/1983","295-3707 Consectetuer Ave"); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("27445911899","Margaret","02/04/1976","P.O. Box 377, 9597 Praesent Avenue"),("77685108799","Daquan","19/05/1982","647-3346 Et, St."),("18686025199","Ivor","26/12/2009","P.O. Box 249, 1678 Bibendum Ave"),("74707554199","Lillian","22/11/2017","8615 Non Rd."),("71583558399","Abbot","28/06/1992","458-2847 Convallis Av."),("99353731299","Charlotte","07/07/2018","336-7155 Eget Av."),("03257247099","Ruby","09/09/2000","Ap #683-3366 Vulputate, Rd."),("48536581799","Wynne","16/08/1983","206-7340 Lectus St."),("35281421399","Amity","02/06/1983","Ap #798-8889 In Rd."),("75549711099","Athena","29/06/1993","P.O. Box 531, 8383 Interdum Av."); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("80581182599","Kyle","12/08/2010","149-4741 Per Av."),("97393053699","Ezra","08/01/2003","P.O. Box 505, 6227 Tortor, Rd."),("85859948799","Justina","09/04/1971","Ap #835-710 Nam Road"),("56864594399","Bruce","23/07/2009","9897 In Rd."),("31393032999","Xenos","15/02/1980","362-7029 Enim Rd."),("44683370899","Nasim","10/10/1977","P.O. Box 224, 6297 Dolor Av."),("48777714199","Eaton","31/05/2014","Ap #528-2850 Vel Rd."),("03345300099","Elijah","18/01/1996","P.O. Box 564, 9238 A, Rd."),("97414954799","Macon","14/12/2018","Ap #889-7894 Cras Road"),("29305510299","Xenos","05/12/1991","Ap #893-7566 Ligula. St."); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("32396864899","Fiona","22/04/1978","Ap #493-116 Adipiscing St."),("85458659799","Shelby","06/06/1988","1342 Ultrices. Av."),("51516380999","Althea","27/11/2018","Ap #749-2593 Iaculis Rd."),("60936181599","Minerva","02/08/1997","Ap #619-2117 Amet St."),("68815893199","Clarke","14/05/1986","Ap #431-4198 Felis, Ave"),("22210844199","Ila","15/11/1988","P.O. Box 286, 8272 Quisque Rd."),("85304349299","Phyllis","04/07/1995","301-3676 Sit Rd."),("41971516199","India","10/01/2015","460-4932 Consequat Rd."),("85767378999","Abdul","10/10/1975","3825 Quam Road"),("68452662199","Madison","05/04/1973","6597 Consectetuer St."); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("33898478699","Mary","27/10/2015","P.O. Box 728, 5208 Rutrum St."),("44564512899","Clayton","28/01/1982","935-2933 Nunc Road"),("46568228399","Xavier","18/12/1980","Ap #420-7881 Posuere St."),("16876049599","Jakeem","08/09/1982","6631 Vel, Av."),("49387868899","Rhonda","02/09/1978","335-9383 Porttitor Road"),("23323540999","Ria","20/02/2000","625-4490 In St."),("45720608999","Eve","31/07/1981","P.O. Box 850, 8200 Eros. St."),("55883944999","Donovan","15/08/2011","P.O. Box 687, 7798 Cursus. Ave"),("95282637999","Audra","02/07/1994","307-7492 In Road"),("28505410999","Rinah","12/03/1982","197-8574 Enim. Ave"); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("40742695099","Robin","30/04/2017","P.O. Box 848, 7710 Pede, Rd."),("01681174299","Whoopi","25/02/1971","7529 Netus Avenue"),("38357147299","Camille","19/01/1988","Ap #934-8623 Ullamcorper Rd."),("95408108199","Tyler","26/03/1992","105 Scelerisque St."),("97217280799","Jena","25/02/1983","5329 Suscipit Rd."),("50239424299","Hillary","03/11/2004","612-3572 Semper Street"),("05522211899","Xaviera","08/04/2014","Ap #832-4698 Donec St."),("03691708399","Kenneth","09/01/1995","9706 Sed Av."),("04376207199","Bevis","08/02/2018","786-8626 Lectus. Rd."),("53834722999","MacKenzie","10/10/2006","Ap #511-8942 Magna. Street"); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("95533721799","Teegan","17/12/1987","P.O. Box 559, 9544 Dignissim Rd."),("40528088499","Colt","15/10/2016","932-6785 Dui, Av."),("78838362799","Camden","23/08/2014","687-9221 Montes, Road"),("80358073599","Rachel","30/12/2000","4337 Fusce Rd."),("95951356499","Kevin","26/08/2015","6321 Aenean Ave"),("29293072199","Germaine","03/07/1975","P.O. Box 886, 914 Nulla St."),("99684687199","Graiden","27/12/1998","806-209 Duis Rd."),("21235418999","Candice","17/01/2014","849-381 Elit, Av."),("12981309599","Arthur","04/03/1974","Ap #442-7649 Tristique St."),("20542385499","Sacha","11/03/1991","327-8121 Porttitor Rd."); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("34341836099","Kyle","18/02/2001","Ap #273-7019 Auctor Ave"),("85605140899","Derek","01/09/1974","968 Lobortis Street"),("92591432099","Carol","21/08/1988","P.O. Box 825, 4988 Mauris St."),("28621116199","Piper","03/10/1972","Ap #293-4969 Feugiat Ave"),("14515898999","Owen","05/08/2004","332-2397 Vel, St."),("50858433399","Simone","30/11/2015","1439 Sit Ave"),("43377727499","Callum","24/10/2014","7264 Ligula. Rd."),("55828095399","Alden","18/07/1995","239-9402 Massa. Av."),("64640142599","Lillith","15/05/1983","Ap #156-3231 Eu Ave"),("87620585599","Bernard","22/06/1998","P.O. Box 112, 997 Mi. Avenue"); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("62728856199","Paki","12/05/1991","P.O. Box 935, 1208 Ut Rd."),("39631693199","Whitney","09/04/2001","573-9815 Nonummy Ave"),("14685726899","Echo","13/02/2010","784-1970 Iaculis, St."),("82364483899","Maxwell","04/03/1974","P.O. Box 578, 4585 Cras Av."),("23508583199","Samuel","30/11/1995","652-9609 Justo Ave"),("32228696399","Tarik","04/01/2016","Ap #291-8855 Eget St."),("39527206799","Drake","15/05/1994","584-2463 Donec Rd."),("56636974699","Joseph","25/12/1991","477-8006 Velit St."),("94222740399","Jerry","21/03/2008","415-9444 At Road"),("71628283599","Michael","30/05/1982","5092 Vitae Av."); INSERT INTO `Patient` (`patientID`,`name`,`DoB`,`address`) VALUES ("49980948699","Hamilton","09/03/2013","9521 Elit. Road"),("61986996799","Quin","06/03/2001","7302 Pede, St."),("98266968999","Robin","26/09/1991","Ap #274-9412 Ridiculus St."),("71437270399","Kay","24/01/1995","2472 Cras St."),("06559774099","Kathleen","14/09/1990","P.O. Box 145, 1772 Velit. Av."),("41772814299","Nolan","26/02/1973","P.O. Box 337, 8685 Integer Rd."),("91811646699","Honorato","22/03/1975","P.O. Box 325, 4063 Quam Rd."),("33968330399","Armando","01/09/1970","164-6149 Proin St."),("13621326599","Alfreda","03/05/1974","2183 Urna. St."),("22201780599","Deanna","05/02/2006","Ap #563-4225 Per St."); DROP TABLE `treatment`; CREATE TABLE `treatment` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `treatmentID` varchar(13) default NULL, `patientID` varchar(11) default NULL, `startDate` varchar(255), `endDate` varchar(255), PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16290320 6726","00229757199","22-12-1999","15/08/2019"),("16261226 0238","06218880999","22-12-1999","05/05/2019"),("16610229 2809","34796335999","22-12-1999","19/07/2019"),("16070630 3591","22428616199","22-12-1999","25/02/2019"),("16411208 1858","40603945699","22-12-1999","13/04/2019"),("16600224 4306","13393316199","22-12-1999","21/09/2019"),("16210822 7139","52893619299","22-12-1999","06/12/2019"),("16520510 2725","39557239999","22-12-1999","14/11/2019"),("16851003 6596","62464541599","22-12-1999","31/10/2019"),("16370506 3406","88815655999","22-12-1999","25/01/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16230927 1035","99292925299","22-12-1999","15/12/2018"),("16131020 7400","03342199299","22-12-1999","10/10/2019"),("16100307 0156","87432252999","22-12-1999","10/04/2019"),("16060926 1011","39436490299","22-12-1999","15/04/2019"),("16950524 2520","91257829299","22-12-1999","25/12/2019"),("16020323 3242","12808967399","22-12-1999","08/09/2019"),("16050505 4494","24898062299","22-12-1999","07/02/2019"),("16500423 3218","43715458599","22-12-1999","04/08/2019"),("16060717 4752","57679588199","22-12-1999","11/07/2019"),("16770513 3937","90674340099","22-12-1999","08/11/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16641218 4704","03431549399","22-12-1999","17/09/2019"),("16371115 0759","71521336799","22-12-1999","10/05/2019"),("16390421 0238","76669883199","22-12-1999","13/10/2019"),("16650627 7521","46301011199","22-12-1999","13/08/2019"),("16091101 1302","37832123099","22-12-1999","12/03/2019"),("16481205 7695","41981141899","22-12-1999","12/10/2019"),("16700807 9373","37818685899","22-12-1999","28/02/2019"),("16930220 4277","66205578399","22-12-1999","07/11/2019"),("16770404 0331","07970492299","22-12-1999","20/03/2019"),("16260305 8997","72813568499","22-12-1999","09/09/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16211007 1137","79206025899","22-12-1999","28/09/2019"),("16870414 1988","71955852699","22-12-1999","04/12/2019"),("16731223 5489","97765431599","22-12-1999","19/02/2019"),("16120921 0937","39502707499","22-12-1999","28/06/2019"),("16810312 8388","13563124599","22-12-1999","04/03/2019"),("16400802 1059","66569469999","22-12-1999","01/02/2019"),("16931007 3664","08908502399","22-12-1999","30/10/2019"),("16580805 5452","66254136399","22-12-1999","29/05/2019"),("16020502 8541","12430615699","22-12-1999","04/04/2019"),("16260409 2235","92787828299","22-12-1999","26/08/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16850118 1815","55835020799","22-12-1999","17/01/2019"),("16430419 2372","25406363399","22-12-1999","14/12/2018"),("16210330 8678","60531067099","22-12-1999","29/08/2019"),("16621206 9584","96705062999","22-12-1999","05/10/2019"),("16810911 4952","24608344099","22-12-1999","30/06/2019"),("16370525 2421","97202178499","22-12-1999","11/02/2019"),("16800818 4312","15440212799","22-12-1999","27/09/2019"),("16060611 9055","55610722799","22-12-1999","29/08/2019"),("16291011 9623","34594138099","22-12-1999","20/09/2019"),("16970806 2006","18665705799","22-12-1999","21/12/2018"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16870430 5229","13296589899","22-12-1999","16/04/2019"),("16720410 6327","46663755999","22-12-1999","22/11/2019"),("16320608 1196","50817075899","22-12-1999","13/04/2019"),("16620108 3935","83989395899","22-12-1999","28/11/2019"),("16140310 8937","53380616199","22-12-1999","09/12/2018"),("16970620 6290","78890171999","22-12-1999","24/11/2019"),("16760713 0726","85307081399","22-12-1999","19/12/2018"),("16910622 7433","60501877399","22-12-1999","01/04/2019"),("16020922 2249","87382425499","22-12-1999","16/02/2019"),("16030303 5075","96598710599","22-12-1999","11/12/2018"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16020409 6986","57994710299","22-12-1999","10/08/2019"),("16950303 8235","36715309699","22-12-1999","30/12/2018"),("16100602 7468","30786364599","22-12-1999","06/12/2019"),("16560810 8402","95745590899","22-12-1999","19/10/2019"),("16691229 2577","91329009699","22-12-1999","10/01/2019"),("16600625 8591","70285165099","22-12-1999","31/07/2019"),("16930902 3795","27772075999","22-12-1999","24/01/2019"),("16920317 3753","47209202099","22-12-1999","28/04/2019"),("16310723 8929","76923400599","22-12-1999","26/06/2019"),("16370108 3143","76590390799","22-12-1999","13/02/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16280707 0988","02953615499","22-12-1999","11/04/2019"),("16260221 1753","17226054599","22-12-1999","03/05/2019"),("16760612 6287","58575906299","22-12-1999","29/04/2019"),("16330805 7110","41374654199","22-12-1999","28/01/2019"),("16210703 0245","24658797499","22-12-1999","05/01/2019"),("16540927 7661","21780188699","22-12-1999","28/04/2019"),("16520419 3972","35258209899","22-12-1999","17/09/2019"),("16290313 2567","94306020799","22-12-1999","13/09/2019"),("16950128 6398","60513044799","22-12-1999","21/12/2019"),("16571119 7706","96947883499","22-12-1999","10/11/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16180905 3547","95670545499","22-12-1999","25/04/2019"),("16820907 4155","70551417799","22-12-1999","23/12/2019"),("16261204 1844","41548594999","22-12-1999","17/10/2019"),("16630322 1714","60428063999","22-12-1999","03/06/2019"),("16851205 8887","95542359999","22-12-1999","17/08/2019"),("16101111 6330","43919703899","22-12-1999","11/08/2019"),("16451219 9995","38398666799","22-12-1999","23/08/2019"),("16750909 3287","68650194399","22-12-1999","09/12/2019"),("16240516 6899","78238505699","22-12-1999","20/10/2019"),("16781023 9645","40818886499","22-12-1999","28/11/2019"); INSERT INTO `treatment` (`treatmentID`,`patientID`,`startDate`,`endDate`) VALUES ("16070311 5063","03608893299","22-12-1999","03/01/2019"),("16990521 3014","58859559699","22-12-1999","22/12/2018"),("16601230 6897","89909486299","22-12-1999","20/12/2018"),("16610721 4493","43869373099","22-12-1999","24/07/2019"),("16830503 2735","76961493899","22-12-1999","12/04/2019"),("16080919 2511","38445250699","22-12-1999","09/12/2019"),("16420130 5374","30456959999","22-12-1999","25/11/2019"),("16920926 7666","45976038499","22-12-1999","24/03/2019"),("16400728 9913","31476002699","22-12-1999","11/12/2019"),("16250908 0095","91959007699","22-12-1999","10/12/2019"); DROP TABLE `Ward_Log`; CREATE TABLE `Ward_Log` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `wardID` varchar(13) default NULL, `treatmentID` varchar(11) default NULL, `startDate` varchar(255), `endDate` varchar(255), PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16470712 0475","04732385299","22-1-1990","24/06/2019"),("16581107 3146","96341612799","22-1-1990","13/08/2019"),("16891204 3380","71731374699","22-1-1990","28/10/2019"),("16460621 5723","76799352299","22-1-1990","08/01/2019"),("16341116 1395","56666886199","22-1-1990","01/06/2019"),("16520213 7864","26809280499","22-1-1990","24/08/2019"),("16910123 5076","09625061099","22-1-1990","08/08/2019"),("16940927 1559","19872643899","22-1-1990","16/06/2019"),("16190930 8908","52427292599","22-1-1990","18/09/2019"),("16211221 1418","63267666199","22-1-1990","19/12/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16330516 2798","44265962399","22-1-1990","22/10/2019"),("16520903 7778","54452760299","22-1-1990","06/12/2019"),("16720303 0296","83965156599","22-1-1990","05/09/2019"),("16700230 9107","78537256799","22-1-1990","05/01/2019"),("16330217 8599","86954765999","22-1-1990","22/01/2019"),("16651221 1860","03323900199","22-1-1990","12/03/2019"),("16050312 0255","91639333099","22-1-1990","15/01/2019"),("16020606 4768","14850684199","22-1-1990","19/02/2019"),("16770816 1299","69646956499","22-1-1990","08/12/2019"),("16160406 2453","20384883899","22-1-1990","09/08/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16181007 2601","93881425299","22-1-1990","07/05/2019"),("16950924 6550","45797209199","22-1-1990","02/05/2019"),("16680830 6655","62585644399","22-1-1990","26/07/2019"),("16500317 7085","86383763199","22-1-1990","26/04/2019"),("16500616 8610","95484076899","22-1-1990","19/12/2018"),("16390309 8675","38768204899","22-1-1990","12/01/2019"),("16690214 1685","79541008199","22-1-1990","15/01/2019"),("16870607 0011","92868357099","22-1-1990","30/12/2018"),("16760529 9697","29392987199","22-1-1990","04/08/2019"),("16180120 0336","37853721399","22-1-1990","04/01/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16710120 4563","33947820699","22-1-1990","21/08/2019"),("16591216 1303","31800576999","22-1-1990","18/09/2019"),("16250211 8785","46681641199","22-1-1990","22/04/2019"),("16950621 5855","86204857099","22-1-1990","14/08/2019"),("16770323 3465","52369553499","22-1-1990","15/06/2019"),("16190227 3687","26942164599","22-1-1990","10/05/2019"),("16480913 3723","45690022099","22-1-1990","22/02/2019"),("16600527 3435","62920469299","22-1-1990","30/07/2019"),("16081128 3217","91496219699","22-1-1990","01/08/2019"),("16911105 0374","05241609199","22-1-1990","16/06/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16801208 2171","63427907999","22-1-1990","29/01/2019"),("16321024 8575","34308469699","22-1-1990","28/11/2019"),("16971229 4272","25543239199","22-1-1990","28/07/2019"),("16790130 9174","19510404399","22-1-1990","10/03/2019"),("16551012 6856","80966735699","22-1-1990","11/11/2019"),("16460919 4149","84522116699","22-1-1990","02/04/2019"),("16291214 9826","62563293099","22-1-1990","26/01/2019"),("16740311 2761","76218242799","22-1-1990","10/11/2019"),("16300725 1725","93435551599","22-1-1990","25/01/2019"),("16360412 4382","87655382399","22-1-1990","17/12/2018"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16711122 7539","77508926599","22-1-1990","08/09/2019"),("16580823 1988","45302857199","22-1-1990","11/02/2019"),("16760325 0320","00605197499","22-1-1990","12/02/2019"),("16451203 8607","59362425999","22-1-1990","20/11/2019"),("16910515 8613","28746273599","22-1-1990","22/11/2019"),("16620915 8333","12609950399","22-1-1990","29/09/2019"),("16040526 3716","85552843199","22-1-1990","24/12/2019"),("16040524 0805","17240620999","22-1-1990","16/09/2019"),("16130228 6834","44943133799","22-1-1990","18/12/2018"),("16321022 3743","69406867999","22-1-1990","08/12/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16511214 3796","62726542499","22-1-1990","04/11/2019"),("16130722 4137","01526290899","22-1-1990","22/06/2019"),("16630203 9505","59495991399","22-1-1990","20/09/2019"),("16501018 7309","67289351399","22-1-1990","17/04/2019"),("16061111 4745","33442073999","22-1-1990","09/03/2019"),("16370506 4784","89970598099","22-1-1990","26/11/2019"),("16011030 5976","58394749599","22-1-1990","28/12/2018"),("16840902 4430","89458414799","22-1-1990","25/05/2019"),("16770812 0709","09745148699","22-1-1990","22/02/2019"),("16770305 6783","43892988599","22-1-1990","22/07/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16900707 7978","02735955599","22-1-1990","04/04/2019"),("16050607 6108","60575165799","22-1-1990","14/06/2019"),("16290414 4686","68507517499","22-1-1990","30/11/2019"),("16300904 9390","05370089599","22-1-1990","11/06/2019"),("16430515 4124","84477430599","22-1-1990","04/05/2019"),("16110230 9836","80526035599","22-1-1990","23/12/2019"),("16100419 0391","87211477899","22-1-1990","04/06/2019"),("16641214 0797","20952739699","22-1-1990","23/11/2019"),("16730116 0425","54415564799","22-1-1990","10/02/2019"),("16500403 8773","74652057299","22-1-1990","04/12/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16470417 9607","67708834999","22-1-1990","22/03/2019"),("16581027 8423","34864888199","22-1-1990","26/07/2019"),("16671102 7752","04373457899","22-1-1990","11/06/2019"),("16740106 3495","27817174299","22-1-1990","02/09/2019"),("16130218 4187","74517181399","22-1-1990","12/05/2019"),("16550405 1748","91853234799","22-1-1990","15/11/2019"),("16650528 3678","93997412699","22-1-1990","19/05/2019"),("16820105 5210","23419776199","22-1-1990","07/11/2019"),("16220526 8200","74528978599","22-1-1990","28/03/2019"),("16490424 3286","68638948399","22-1-1990","06/06/2019"); INSERT INTO `Ward_Log` (`wardID`,`treatmentID`,`startDate`,`endDate`) VALUES ("16080713 2451","76281434399","22-1-1990","21/04/2019"),("16561019 2337","31267797999","22-1-1990","14/02/2019"),("16530111 8732","58299692199","22-1-1990","16/07/2019"),("16010922 6654","85452358799","22-1-1990","22/07/2019"),("16290723 0896","64337988299","22-1-1990","06/11/2019"),("16761107 4803","21807632599","22-1-1990","08/02/2019"),("16730717 6458","96429760799","22-1-1990","18/04/2019"),("16640320 1038","16892166399","22-1-1990","31/08/2019"),("16010202 1250","95518795499","22-1-1990","23/12/2018"),("16011117 5485","93405300299","22-1-1990","14/06/2019"); DROP TABLE `Consultant`; CREATE TABLE `Consultant` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `consultantID` varchar(13) default NULL, `name` varchar(255) default NULL, `DoB` varchar(255), `title` varchar(255) default NULL, `profession` varchar(255), `fee` varchar(100) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16350525 9105","Brock","28/08/94","Lawrence","Phasellus Elit Pede Consulting","591.54"),("16530706 0250","Abbot","21/03/75","Mcconnell","Porttitor PC","613.26"),("16540701 5287","Lara","15/04/89","Perkins","Est Mollis Inc.","959.15"),("16581222 0092","Colette","14/03/16","Bonner","Fringilla Ornare Foundation","989.78"),("16090404 5200","Harlan","04/02/17","Harrison","Imperdiet Ullamcorper Duis Incorporated","262.42"),("16121024 3315","Wallace","20/04/09","Cannon","Libero Morbi Consulting","950.82"),("16030514 0378","Andrew","04/07/00","Cox","Cubilia Curae; Donec Inc.","809.41"),("16860925 2278","Frances","18/09/14","Wagner","Rhoncus Id Industries","347.50"),("16071211 1343","Colt","10/09/75","Lara","Ultrices Iaculis Odio Inc.","673.03"),("16610730 5069","Karly","24/07/99","Santos","Donec Tincidunt Ltd","597.70"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16500402 9293","Melvin","22/05/76","Ratliff","Tempus Associates","254.91"),("16821011 6607","Leandra","12/06/75","Rivers","Lacus Institute","752.43"),("16260220 4949","Pearl","24/08/78","Fuller","Eu Eros Nam Industries","331.29"),("16920906 4220","Lillith","23/07/00","Ramos","Vehicula Aliquet Associates","856.58"),("16070902 7585","India","03/05/19","Wiggins","Sem Mollis Company","242.47"),("16230430 0219","Robin","22/07/83","Mcdaniel","Et Magnis Institute","371.72"),("16170204 4650","Ali","27/05/07","Potter","Ac Mi Eleifend Industries","188.01"),("16510629 9356","Kyla","02/04/97","Nielsen","At Fringilla Purus Ltd","615.39"),("16261014 7809","Leandra","23/03/81","Aguirre","Et Arcu Imperdiet Ltd","478.23"),("16241201 7663","Daquan","07/04/96","Ellis","Vehicula Aliquet Libero Industries","446.74"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16781012 6818","Callum","27/02/75","Anthony","Purus Corp.","665.56"),("16470125 7836","Quail","20/11/95","Stanley","Vitae Erat Vel Ltd","216.35"),("16801219 8019","Judah","05/02/06","Lang","Purus Maecenas Institute","267.35"),("16480717 7821","Damon","05/11/96","Weaver","Primis In Faucibus LLP","492.23"),("16880826 8992","Denton","27/01/03","Cash","Malesuada Malesuada Integer LLC","490.33"),("16820430 2452","Veronica","05/01/73","Cannon","Vulputate Corporation","606.61"),("16460626 3996","Bert","25/09/81","Stephenson","Nisi Industries","591.65"),("16700817 3341","Alexa","30/05/02","Deleon","Interdum Nunc Sollicitudin Ltd","110.10"),("16651003 1732","Bethany","08/04/18","Gates","Nulla PC","715.67"),("16540421 9114","Ainsley","16/12/05","Bond","Sit Amet Inc.","490.36"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16270508 0253","Chaim","16/08/97","Whitfield","In Felis Nulla Incorporated","560.17"),("16530714 2512","Carly","26/12/18","William","Vitae Incorporated","807.73"),("16141106 7596","Palmer","18/11/11","Herring","Auctor Quis Tristique LLC","212.25"),("16970717 9850","Aimee","25/07/73","Petersen","Nam Foundation","713.52"),("16130710 1327","Kameko","04/04/87","Ferguson","Blandit Congue In Corporation","722.09"),("16271110 1630","Alan","22/06/08","Fitzgerald","Sapien Cursus LLC","946.57"),("16150221 2499","Beau","14/05/11","Salinas","Enim Commodo Hendrerit Incorporated","780.18"),("16420610 4376","Hanae","11/02/81","Ford","Tristique PC","903.09"),("16230224 1142","Todd","20/03/78","Whitley","Ipsum Suspendisse Non Institute","819.41"),("16481014 5450","Coby","14/06/17","Hubbard","Cum PC","799.67"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16130926 1111","Micah","18/10/19","Gaines","In Corp.","862.19"),("16430815 6100","Martin","13/02/93","Roth","Pretium Et Rutrum Ltd","218.14"),("16181228 8791","Keiko","21/11/78","Palmer","Luctus Consulting","170.42"),("16081124 9044","Daphne","24/03/73","Byrd","Sagittis Augue PC","263.63"),("16940101 6705","Hamilton","13/04/96","Watts","Cubilia Curae; Consulting","756.49"),("16230120 3549","Rosalyn","16/05/19","Compton","Molestie LLC","933.21"),("16090118 9365","Maggie","25/10/00","Greene","Odio Semper Company","489.14"),("16330413 4830","Rashad","12/02/92","Pratt","Lectus Pede Ltd","163.43"),("16860420 0397","Catherine","04/10/07","Odom","Ut LLC","830.06"),("16660306 4004","Keefe","25/10/09","Barker","Dolor Institute","329.63"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16620212 6113","Phillip","11/07/15","Henson","Mattis Velit Justo Ltd","398.83"),("16620419 7153","Berk","13/06/83","Hickman","Odio Aliquam Vulputate Inc.","968.16"),("16870828 7019","Cassady","29/03/13","Smith","Gravida Sagittis Foundation","628.59"),("16290630 7521","Nelle","16/07/78","Young","Quam Institute","684.73"),("16930625 3304","Phelan","28/11/09","Puckett","Mollis Duis Company","316.72"),("16320501 4925","Harriet","14/04/71","Middleton","Tempus PC","397.01"),("16500524 2960","Cynthia","08/09/76","Ware","Facilisis Non Bibendum Associates","508.01"),("16240802 8799","Vernon","27/01/17","Bernard","Dignissim Magna A LLC","860.64"),("16241018 1479","Constance","23/04/06","Hayden","Donec Egestas Company","743.84"),("16260818 6611","Lucian","11/03/19","Kelly","Luctus Institute","363.00"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16820303 9030","Haley","21/04/75","Christian","Velit Inc.","469.77"),("16280119 0444","Elijah","06/07/81","Davenport","Feugiat LLC","804.53"),("16760802 0082","Joan","11/11/93","Chavez","Torquent Institute","103.58"),("16270409 3299","Galena","28/11/79","Williams","Ornare Incorporated","606.76"),("16471019 2651","Fay","19/12/93","Lindsey","Placerat Eget Venenatis Limited","577.74"),("16720427 5643","Nicole","21/11/83","Charles","Et Rutrum Non Institute","442.11"),("16350216 7939","Alfonso","23/03/85","Pace","Lobortis Class LLP","989.68"),("16470517 4995","Kyla","06/05/89","Klein","Nunc Ac Foundation","241.36"),("16400717 3067","Emerson","01/09/14","Miranda","Malesuada Consulting","187.80"),("16430526 9872","Christine","24/12/15","Hoffman","Lacinia Mattis Associates","633.17"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16270214 5703","Nehru","08/07/19","Emerson","Mauris Blandit Enim Ltd","920.42"),("16340505 9829","Cherokee","02/02/85","Woodward","Cursus Vestibulum Corporation","567.40"),("16640609 4232","Cade","11/09/80","Pickett","Nec LLP","709.88"),("16501007 0372","Robin","19/04/80","Vargas","Tempor Diam PC","752.57"),("16610704 9311","Chancellor","09/05/06","Bradford","Hendrerit Neque Associates","658.97"),("16870524 3841","Merrill","15/07/72","Hester","Posuere Enim PC","424.81"),("16390316 6811","Hyacinth","28/06/08","Johns","Dignissim Pharetra Nam Ltd","886.48"),("16850818 6098","Pascale","10/10/99","Sharp","Luctus Sit Amet Incorporated","714.90"),("16350124 4408","Tobias","04/01/98","Martin","Proin Incorporated","655.23"),("16540213 7292","Ezekiel","01/10/80","Massey","Pede Ultrices Limited","847.45"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16181109 3333","Cullen","17/07/84","Harper","Egestas Lacinia Limited","128.69"),("16690506 0304","Olympia","29/09/99","Robinson","Auctor Inc.","295.16"),("16680723 8883","Drake","02/04/88","Howard","At Libero Morbi Limited","923.52"),("16990821 1205","Madeline","21/02/79","Malone","Nunc Nulla Vulputate Institute","290.17"),("16550102 8889","Fleur","07/05/01","Mitchell","Aliquam Erat Institute","394.89"),("16821024 8061","Amethyst","06/11/90","Pittman","Nec Leo Morbi Foundation","142.85"),("16160215 1431","Galena","18/04/93","Kline","Libero Ltd","895.39"),("16711225 7816","Chanda","16/02/84","Chandler","Curabitur Associates","138.61"),("16550914 7962","Lester","21/12/09","Reeves","Ipsum Dolor Sit Associates","893.70"),("16010326 9569","Aidan","28/03/99","Taylor","Vel Company","176.22"); INSERT INTO `Consultant` (`consultantID`,`name`,`DoB`,`title`,`profession`,`fee`) VALUES ("16940605 5377","Madeline","19/03/86","Burton","Dui LLC","969.53"),("16110722 9807","Cecilia","22/04/05","Moss","Interdum Libero Dui LLC","925.63"),("16940413 7425","Taylor","02/05/82","Austin","Proin Dolor Nulla LLP","439.91"),("16890207 4643","Paloma","25/11/86","Stuart","Sit Corp.","976.59"),("16880211 6403","Flynn","07/03/14","Pratt","Blandit Corp.","306.26"),("16390221 5932","Aristotle","24/06/76","Williams","Vitae Inc.","133.11"),("16530916 7301","Jolie","18/12/73","Hawkins","Non LLC","918.11"),("16990909 3917","Dorian","05/09/11","Espinoza","Iaculis Enim Company","615.58"),("16160824 5286","Mikayla","07/07/03","Boyer","Duis At Lacus Institute","495.54"),("16210223 5203","Brody","29/07/05","Bell","Tortor Integer Institute","989.14"); DROP TABLE `Consultant_Log`; CREATE TABLE `Consultant_Log` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `treatmentID` varchar(11) default NULL, `consultantID` varchar(13) default NULL, `date` varchar(255), PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("996015-8385","16390526 3525","02/05/13"),("723355-1311","16181229 7198","11/11/06"),("785240-4446","16680305 4128","16/06/87"),("237759-6156","16871118 7669","13/05/00"),("917079-3351","16800321 6630","22/01/77"),("178812-9508","16470617 0265","07/02/89"),("658801-5690","16611008 9643","24/03/92"),("454495-2056","16330208 7725","19/09/72"),("144822-4970","16401018 5173","25/01/77"),("492971-6266","16310228 9612","14/06/97"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("182268-1142","16020517 1986","14/06/84"),("282012-2832","16390224 1763","14/11/93"),("859090-7641","16960917 7549","31/01/90"),("055911-0747","16840427 7496","04/05/04"),("978136-3156","16670109 3871","25/02/16"),("083258-6903","16070702 0046","06/08/09"),("523315-0696","16160428 5518","08/10/73"),("823641-4929","16570130 3033","12/04/73"),("923466-1818","16230102 5579","13/02/75"),("556177-3481","16940401 2560","09/03/78"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("382307-3204","16770616 5425","07/01/88"),("934322-8962","16350211 1580","07/01/72"),("508679-6876","16760214 5869","02/01/11"),("503568-9958","16950702 4272","19/10/91"),("923042-7800","16080324 4763","23/10/87"),("763156-5897","16330226 6899","12/12/84"),("175840-8197","16530213 3912","07/02/93"),("203056-4047","16570105 3364","10/04/88"),("946084-2116","16010801 6106","19/05/18"),("603671-9653","16370816 5596","10/08/86"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("676272-1220","16580630 5446","15/01/18"),("475004-9738","16020312 0530","09/09/14"),("284245-3488","16600421 4570","25/03/18"),("096787-7689","16410616 6236","04/08/17"),("848269-5346","16080117 3956","14/11/19"),("747647-0856","16331118 4877","10/01/87"),("839010-3565","16051024 6200","07/02/90"),("618238-6448","16460311 6767","02/06/03"),("095973-6422","16710106 8315","28/06/18"),("684497-1504","16400301 0990","12/09/91"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("994253-5338","16790716 8962","05/04/82"),("988034-5294","16631126 7808","13/01/91"),("348643-0188","16080102 5735","13/02/90"),("216895-8730","16210218 4948","28/06/95"),("727621-6368","16710405 7869","15/10/87"),("304598-8007","16660625 6326","09/08/15"),("594096-9784","16720413 8411","17/01/96"),("679273-6925","16360126 0064","21/12/09"),("428442-3151","16460414 6649","18/12/85"),("315141-5944","16480529 8199","25/09/07"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("287591-5908","16270714 5278","07/11/90"),("072999-5589","16520822 4161","06/10/01"),("839218-8986","16040408 5516","27/07/80"),("719993-6613","16040220 6304","10/03/92"),("392956-8115","16650914 0064","28/08/07"),("192190-7224","16470224 0724","07/09/02"),("329881-8638","16380109 5062","03/05/87"),("615081-8778","16950423 4791","28/12/05"),("325271-6653","16640102 1768","04/06/04"),("567747-1822","16900805 0339","03/07/01"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("578790-0942","16610830 7171","21/12/71"),("837310-5959","16760811 1014","27/08/93"),("013460-6672","16470809 9884","20/08/16"),("048272-9126","16230724 5395","15/09/91"),("148155-9621","16070518 0420","25/06/71"),("448951-4911","16721018 9531","03/12/89"),("567199-4134","16700518 6676","21/07/99"),("224666-2940","16890401 2476","15/12/15"),("329353-9973","16131012 2799","05/02/15"),("572126-6855","16560711 6570","29/06/92"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("573200-1994","16101103 3543","29/03/97"),("722824-3114","16800617 8951","12/03/82"),("998355-8678","16121108 8503","22/05/09"),("047203-6185","16720221 4925","13/07/73"),("418798-7419","16520309 1961","09/02/05"),("095789-8059","16560310 9744","09/10/82"),("148176-4049","16761229 1737","19/09/84"),("776831-6155","16281208 3927","18/11/99"),("957999-2786","16270512 1982","07/09/95"),("738362-0411","16571104 6093","03/10/85"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("896970-6020","16960126 2398","24/07/77"),("459019-2730","16621228 0678","30/04/10"),("993530-0005","16770806 2596","03/05/75"),("356257-8892","16150701 0856","22/01/00"),("108676-0418","16740429 7306","30/07/90"),("469803-5609","16840208 0975","13/07/12"),("082710-9992","16600126 6607","05/12/14"),("399950-6656","16270516 9429","29/06/00"),("066656-8431","16070425 4218","07/03/02"),("698703-9317","16281113 3822","20/12/93"); INSERT INTO `Consultant_Log` (`treatmentID`,`consultantID`,`date`) VALUES ("882131-0607","16800221 8553","24/12/73"),("274787-5058","16080107 1887","24/08/01"),("995668-0699","16080511 2968","25/02/81"),("267296-2509","16490228 2302","06/12/79"),("922588-2449","16130618 4258","05/05/89"),("587164-3176","16641206 0771","24/07/12"),("819058-9815","16210912 6777","01/10/16"),("338744-3504","16701019 9060","30/03/13"),("423696-7263","16170219 6021","21/12/00"),("129125-0999","16941027 2471","18/10/72"); DROP TABLE `Medicine`; CREATE TABLE `Medicine` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `medicineID` varchar(11) default NULL, `name` varchar(255) default NULL, `cost` varchar(100) default NULL, PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("095501-1879","Althea","203.72"),("729778-7140","Amela","20.40"),("724904-0358","Anthony","54.34"),("892456-3649","Cameran","107.68"),("836049-2238","Carolyn","154.56"),("424453-6225","Justina","19.01"),("779924-8286","Alvin","157.67"),("365084-6912","Lani","16.66"),("403504-7820","Aubrey","182.25"),("439654-7400","Blossom","231.77"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("828156-7837","Georgia","76.56"),("827180-0354","Kelsey","49.15"),("335867-4806","Ariana","128.35"),("258120-1213","Colton","49.49"),("426237-2313","Erasmus","142.64"),("029126-8910","Herman","215.06"),("294067-3078","Althea","231.88"),("943500-9270","Jermaine","186.68"),("126762-6495","Knox","203.68"),("532987-9935","Brennan","227.08"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("757362-4991","Stewart","166.67"),("274413-2586","Sigourney","194.50"),("574426-1719","Allegra","201.59"),("957912-8647","Simon","116.23"),("947507-2220","Mallory","152.45"),("997721-9394","Rigel","170.97"),("694037-8745","Mona","76.42"),("068832-3930","Thaddeus","65.24"),("854845-7004","Elizabeth","169.98"),("912874-7814","Lewis","58.18"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("572498-5113","Reagan","223.71"),("992916-9978","Helen","227.98"),("573606-6555","Maite","144.60"),("708939-6860","Myles","132.74"),("815809-5045","Xerxes","159.89"),("148102-6266","Madaline","68.71"),("444753-0777","Nicholas","149.91"),("409675-6244","Holmes","54.96"),("277336-2542","Keaton","105.74"),("739653-1563","Rhoda","121.03"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("882163-0723","Yvette","100.07"),("416063-7346","Gannon","49.26"),("687735-9874","Rebekah","146.62"),("295700-0785","Belle","179.74"),("039993-2359","Denton","137.32"),("409788-5034","Charity","165.29"),("987684-2874","Basil","116.75"),("187535-9422","Althea","17.54"),("356736-3357","Imogene","237.98"),("645310-9784","Ralph","156.97"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("153169-0657","Norman","27.67"),("768689-1131","Helen","78.31"),("408422-4023","Nolan","79.48"),("592222-8639","Laith","211.45"),("148130-3558","Lionel","48.34"),("813170-0901","Teagan","25.49"),("205439-7308","Tana","63.83"),("822512-3820","Dante","57.17"),("264777-4682","Hiroko","181.59"),("999034-7743","Inga","207.30"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("087083-7986","Rashad","62.35"),("216640-1733","Bruce","167.40"),("493407-4677","Wesley","240.59"),("183115-1996","Inez","70.03"),("816852-4679","Charles","70.35"),("318103-9151","Shana","149.08"),("577716-5829","Channing","241.02"),("812587-4803","Jordan","127.28"),("427321-4389","Noel","41.24"),("136464-0795","Harlan","231.65"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("204226-6078","Zelda","227.94"),("105235-3305","Minerva","154.53"),("749387-2019","Aquila","113.58"),("634994-4337","Cooper","212.92"),("298761-6394","Uta","57.99"),("533918-1637","Latifah","158.29"),("307281-2484","Kibo","132.73"),("746426-9914","Alan","49.15"),("482830-7241","Lucian","173.87"),("518043-4242","Tasha","166.14"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("752135-5284","Sybill","47.55"),("593962-5272","Sloane","233.96"),("002529-7425","Fritz","168.35"),("943292-5098","Igor","66.46"),("829550-3562","Lucian","50.69"),("964284-8825","Yen","213.18"),("633670-3761","Sloane","173.12"),("186069-8255","Emmanuel","83.85"),("564910-3529","Joseph","165.22"),("787697-1131","Moses","204.74"); INSERT INTO `Medicine` (`medicineID`,`name`,`cost`) VALUES ("477366-2574","Zeph","86.44"),("987220-7106","Yasir","142.67"),("918334-5009","Delilah","242.88"),("325821-3671","Octavius","140.33"),("595557-2796","Angelica","165.88"),("184933-1093","Medge","61.26"),("678623-7997","Allistair","39.24"),("053106-8757","Ian","150.33"),("692080-6772","Lee","149.56"),("689631-5386","Rhona","109.93"); DROP TABLE `Medicine_Log`; CREATE TABLE `Medicine_Log` ( `id` mediumint(8) unsigned NOT NULL auto_increment, `treatmentID` varchar(11) default NULL, `medicineID` varchar(11) default NULL, `quantity` mediumint default NULL, `date` varchar(255), PRIMARY KEY (`id`) ) AUTO_INCREMENT=1; INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("71967207199","822276-3628",281,"21/05/14"),("11329996999","166045-5187",11,"07/12/13"),("96766689799","787384-3432",139,"27/07/16"),("78987307599","466970-9562",287,"01/11/10"),("56419166599","693621-3823",70,"04/08/16"),("83288406999","908635-3704",111,"06/01/15"),("88729693599","048929-6608",15,"30/09/17"),("10419165899","482062-8719",221,"21/08/11"),("01557552499","105369-3212",256,"06/12/18"),("34347913399","489075-5095",48,"03/08/15"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("61670684499","436339-4745",96,"05/10/19"),("68326128199","284839-9560",6,"01/10/13"),("81857520799","008309-7980",236,"23/03/11"),("29780973999","956582-3193",112,"03/08/19"),("29621304999","677217-2455",36,"03/05/11"),("03200559999","089872-4661",141,"19/03/13"),("23868093499","882656-3507",204,"14/01/14"),("80832643799","162107-9225",185,"05/08/18"),("82412362299","684992-8830",4,"13/12/17"),("84596660399","955253-1072",133,"30/11/13"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("50222271199","239814-7583",280,"25/04/14"),("29880117499","027491-2468",33,"06/12/10"),("27257942999","357146-0116",11,"11/10/17"),("01413632999","118768-0143",293,"16/09/17"),("04652674699","907252-5190",257,"13/02/13"),("50784676099","909898-2417",242,"14/06/14"),("83575931199","592391-5747",251,"26/12/14"),("49532282799","997936-0139",291,"31/01/13"),("24838787599","879035-1392",239,"25/09/13"),("19650715099","942109-6786",168,"30/06/10"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("31739579599","127277-8810",194,"22/03/15"),("62448366299","366587-0915",214,"15/07/10"),("26279147199","849452-6893",86,"19/10/11"),("96224964399","782979-4663",233,"02/06/10"),("26349588499","378550-6027",262,"16/09/12"),("40920113799","797758-6481",265,"15/02/18"),("81975122999","627370-8112",235,"28/12/14"),("45629325799","974377-6362",60,"27/06/13"),("92629479299","807445-7923",125,"11/06/16"),("12486675299","468745-3854",240,"27/09/11"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("39308747799","125671-4542",28,"11/04/16"),("63302321899","304441-0888",134,"01/12/11"),("92501848199","455953-6943",250,"24/03/17"),("48971270899","725818-2018",268,"03/09/12"),("15902378599","822198-4589",29,"17/12/18"),("09858735199","088944-5912",260,"04/07/19"),("07683807699","254385-7284",105,"07/04/10"),("30953059099","538586-0852",120,"19/06/10"),("25871095399","819049-8090",65,"17/05/16"),("59480807399","714860-4692",53,"06/10/11"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("03499382699","746469-2545",235,"26/02/10"),("93597729799","168892-7308",201,"13/03/17"),("43868134799","288881-2704",95,"31/07/10"),("70708272699","259564-1875",28,"19/06/15"),("52315814899","483718-5760",148,"13/12/18"),("18238275999","613381-2880",196,"30/03/11"),("49281033899","389211-1521",12,"11/11/17"),("77385758499","207763-1949",32,"16/12/15"),("16431245399","264658-5584",63,"29/03/12"),("50945705099","828962-9266",233,"21/05/19"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("64244383599","789143-2945",82,"20/04/12"),("06308366099","004439-9558",100,"17/08/11"),("44992257899","873881-3412",177,"12/04/16"),("50492053599","336128-6101",119,"08/01/12"),("40220805899","025493-4912",188,"20/02/15"),("14847058699","826854-5368",211,"20/11/10"),("06872472899","829556-9449",27,"17/12/11"),("49738278499","739667-1179",226,"11/06/10"),("54648261699","928185-7996",181,"03/01/14"),("48585462399","475678-0245",30,"04/02/19"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("02647667499","375065-1733",68,"05/09/16"),("94325168999","127683-4726",151,"19/04/13"),("80573252399","389805-9013",204,"17/08/16"),("18458050999","045289-7226",144,"15/09/16"),("94745357499","575949-5087",17,"04/07/11"),("48335158199","236330-3344",177,"16/12/18"),("06282383899","095372-6577",187,"24/04/15"),("67774393799","753971-6659",143,"11/09/14"),("34965224299","906747-8918",221,"23/10/15"),("68259413899","953577-2231",43,"27/09/15"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("66458721199","512468-0371",282,"02/01/12"),("72875544299","783086-4877",262,"23/08/14"),("30776846099","104876-4284",172,"25/06/11"),("45732863899","584936-8013",103,"27/08/11"),("27225702099","548844-9843",43,"14/01/15"),("02896871899","325631-1204",241,"17/04/19"),("61915957099","442261-2780",288,"02/08/13"),("33379630899","533397-9887",162,"18/06/15"),("97748609099","766493-8417",246,"03/11/11"),("65896715699","516807-2501",128,"04/12/18"); INSERT INTO `Medicine_Log` (`treatmentID`,`medicineID`,`quantity`,`date`) VALUES ("96879501999","769935-6874",279,"16/07/17"),("65419600499","932153-6782",204,"24/02/18"),("86695479199","026492-7765",117,"17/03/11"),("77211119399","042312-6366",152,"19/05/10"),("84343480599","584736-5821",26,"14/08/19"),("55430105199","996902-1378",153,"17/02/14"),("64714683099","428746-1802",233,"15/05/12"),("54636022699","655410-8701",2,"31/07/18"),("15768373399","047114-6704",81,"23/06/12"),("79510760799","564655-1225",155,"22/09/12");