--
-- Host: localhost    Database: flowermatic
-- ------------------------------------------------------


--
-- Table structure for table `cartItem`
--

CREATE TABLE `cartItem` (
  `memberID` varchar(40) NOT NULL,
  `orderID` varchar(40) NOT NULL,
  `productID` varchar(40) NOT NULL,
  `size` varchar(20) NOT NULL,
  `profileID` varchar(40) NOT NULL,
  `profileAddress` varchar(40) NOT NULL,
  `profileDates` varchar(40) NOT NULL,
  `chocolate` varchar(40) NOT NULL,
  `animals` varchar(40) NOT NULL,
  `balloons` varchar(40) NOT NULL,
  `cardmessage` text NOT NULL,
  `instructions` text NOT NULL,
  `sent` smallint(6) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cartItem`
--

INSERT INTO `cartItem` VALUES ('m_74719052122','o_92402451643','t10-2','STANDARD','59846601605','HOME ADDRESS','BIRTHDAY','','','','','',0),('m_78767985175','o_302124825284','t10-3','','','','','','','','','',0),('m_409597510085','o_956325530330','t10-2','','384946129786','HOME ADDRESS','HALLOWEEN','0.00','0.00','0.00','fdsfsdfsadfd','',0),('m_409597510085','o_439534830334','t10-2','','384946129786','HOME ADDRESS','HALLOWEEN','0.00','0.00','0.00','fsafdsafsdfsfsafdsa','',0),('m_18452227981','o_57009748506','tev24-4','','','','','','','','','',0),('m_18452227981','o_17737598530','tev24-4','','','','','','','','','',0),('m_74276217611','o_67328157773','t140-1','STANDARD','10471307683','HOME ADDRESS','BIRTHDAY','0.00','0.00','0.00','','',0),('m_606364713392','o_580722513484','T11Z106','','513559413479','HOME ADDRESS','BIRTHDAY','0.00','0.00','0.00','nvbnv','nvv',0),('m_110546326619','o_174061326645','t98-1','','','','','','','','','',0),('m_258437115725','o_80334118161','t10-3','','','','','','','','','',0),('m_433952414569','o_359343516294','t56-1','','504675316699','HOME ADDRESS','','0.00','0.00','0.00','Hope you feel better\r\n\r\n-Kelly Zidik','',0),('m_91229416518','o_528538225037','t10-3','','','','','','','','','',0),('m_90719207915','o_922925929446','t98-2','STANDARD','630949028913','home','MOTHER\'S DAY','0.00','0.00','0.00','Your loving husband and baby daddy.','',0),('m_622425313158','o_113573930685','t140-2','','588843730542','home','anniversary','0.00','0.00','0.00','','',0),('m_622425313158','o_529276431472','t140-1','','536722331213','','anniversary','','','','','',0),('m_39288604755','o_35417615343','t81-2','STANDARD','72589045137','home','birthday','0.00','0.00','4.99','Happy birth month, Carebear!!','',0),('m_92566123910','o_992824312261','t128-2','STANDARD','747003211920','home','VALENTINE\'S DAY','0.00','0.00','0.00','Girl if you are with me then I\'m ready.\r\n\r\nReshettia W Lucas\r\n\r\nWill you marry me?  ','Please deliver before 9am',1),('m_887012826423','o_848302826573','t52-3','','addrecipient','','VALENTINE\'S DAY','0.00','0.00','0.00','Happy Valentines Day Nana and Pop-Pop!\r\nLove, Ally','',0),('m_488800610816','o_42133712594','trs01-1','DELUXE','681019911487','home','name1','','','9.99','','',0),('m_404382030440','o_47667357835','trs03-1','','','','','','','','','',0),('m_276098324720','o_888505225080','t128-2','','','','','','','','','',0),('m_22531563621','o_8714755097','t11-1','','','','','','','','','',0),('m_50576017720','o_584122810511','t46-1','','867816713709','','','0.00','0.00','0.00','To my one and only. These are just a small reminder to you of how grateful I am to have such a beautiful,loving,smart and Godly wife next to me. Ill Love you forever. \r\n\"Charm can be deceiving,\r\n and beauty fades away,\r\nbut a woman who honors the Lord\r\ndeserves to be praised.\"\r\n','',0),('m_163229822717','o_36812917208','T11Z106','','98877723195','home','anniversary','0.00','0.00','0.00','you stink!','',0),('m_163229822717','o_97358353170','t128-2','','','','','','','','','',0),('m_28654583687','o_11932554181','t10-2','STANDARD','74179544058','home','name1','','','','','',0),('m_529041822260','o_79389625119','t142-1','','addrecipient','','','','29.99','14.99','','',0),('m_284731126668','o_273531517473','tev24-4','DELUXE','30521417255','office','anniversary','0.00','0.00','0.00','Jessica, \r\n\r\nHappy Anniversary!! I am so lucky to have married you and these have been the happiest years of my life. \r\n\r\nLove, \r\n\r\nCass ','There is a security gate so the driver needs to tell him that he is delivering for Jessica Fitzgerald, her work number is \r\n305-569-4137.',0),('m_529811823909','o_265269214970','t140-1','','','','','','','','','',0),('m_777764310147','o_445746910496','t407-1','','','','','','','','','',0),('m_818011514531','o_901053314678','t140-1','','459858414965','aname1','name1','0.00','0.00','0.00','The  Entire Production Team of Colgate \"Small Steps\" missed you on Friday and we hope you get well soon.!!!!!\r\n\r\n\r\n','Please send in Vase',1),('m_768620029483','o_417912829703','tev21-1','','','','','','','','','',0),('m_768620029483','o_384331329720','tev21-1','','','','','','','','','',0),('m_287665632476','o_251766632691','t37-1','STANDARD','683198132545','home','birthday','0.00','0.00','0.00','3424234','23424243',0),('m_608206324092','o_497698324565','tev11-3','STANDARD','','','','','','','','',0),('m_608206324092','o_708069724766','t147-1','','addrecipient','','','','','','','',0),('m_955065614142','o_14439015676','t140-1','STANDARD','893030914283','home','MOTHER\'S DAY','0.00','0.00','0.00','Happy mothers day!! You are so wonderful and we are so thankful to have you in our lives!! ','',0),('m_225514712269','o_115200612812','t54-1','','','','','','','','','',0),('m_225514712269','o_143310014412','t400-2','PREMIUM','976732913440','home','birthday','29.99','','','','',0),('m_261418613886','o_707592218997','t10-2','PREMIUM','977724818386','home','birthday','0.00','0.00','0.00','Happy Birthday! We love you so much and hope you have an amazing day and that all your birthday wishes come true!\r\n\r\nLove,\r\nElya and Roman ','',0),('m_261418613886','o_840094219649','t400-2','PREMIUM','977724818386','home','anniversary','0.00','0.00','0.00','Happy Anniversary! Here\'s to many more years of happiness and healthy and to setting a beautiful example!\r\n\r\nLove, \r\nElya and Roman','',0),('m_261418613886','o_977724820415','t404-2','PREMIUM','977724818386','home','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day!\r\nThank you for being such an amazing mom and mom-in-law. We appreciate you so much and feel so lucky to have you!\r\n\r\nLove,\r\nElya and Roman','',0),('m_109157231145','o_783598831223','tev25-3','','','','','','','','','',0),('m_567596814269','o_921714016892','t140-1','','','','','','','','','',0),('m_714398924426','o_194603225914','tev40-2','STANDARD','786989925479','aname1','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day!','',0),('m_714398924426','o_406349325992','t147-1','STANDARD','786989925479','aname1','birthday','0.00','0.00','0.00','Happy Birthday!','',0),('m_681711726784','o_679394229356','tev13-4','STANDARD','addrecipient','','','','','','','',0),('m_294729213197','o_418798413293','t10-3','','','','','','','','','',0),('m_233707119263','o_277545520089','t10-2','','','','','','','','','',0),('m_45006749630','o_514719114170','t141-1','STANDARD','610335214052','home','MOTHER\'S DAY','0.00','0.00','0.00','You are an amazing mother to Jacob and Lauren ','',0),('m_270431927831','o_1544665074','tev11-3','STANDARD','93753324798','aname1','name1','0.00','0.00','0.00','Happy Birthday Amy!\r\n\r\nThanks for all you do.  We hope you have a wonderful Birthday week. \r\n\r\nLove,\r\nAnne and Brice ','Deliver between 10 am - 5 pm CST',0),('m_270431927831','o_98186507020','tev11-3','STANDARD','92214796410','aname1','birthday','0.00','0.00','0.00','Happy Birthday Aly!\r\n\r\nThanks for all you do.  We hope you have a wonderful Birthday week. \r\n\r\nLove,\r\nAnne and Brice ','Deliver between 10 AM - 5 PM EST',0),('m_138297017039','o_714804918474','t140-2','','556317019944','aname1','birthday','0.00','0.00','0.00','Happy Bday!!!!!','',0),('m_319023616343','o_755733316875','t147-1','','507594817315','aname1','birthday','9.99','0.00','0.00','Happy birthday Aunt Cathy!','',0),('m_960517630110','o_9327344599','t409-3','DELUXE','983246896','aname1','name1','0.00','0.00','0.00','Congratulations on your beautiful new addition! Love Momma and Allison Xo','',0),('m_86944497975','o_55695438126','t140-1','DELUXE','addrecipient','','','','','','','',0),('m_660710427844','o_46531901140','t37-1','STANDARD','281550128270','HOME ADDRESS','name1','0.00','0.00','0.00','','',0),('m_786773630732','o_3431997430','tev40-2','STANDARD','571873032594','aname1','birthday','0.00','0.00','0.00','Happy Birthday from your Family at BBI Sports Group','',0),('m_270871816567','o_261601817241','t147-1','','','','','','','','','',0),('m_525595223674','o_823194024406','t37-1','','','','','','','','','',0),('m_525595223674','o_634772624546','tev13-4','','','','','','','','','',0),('m_769750111290','o_284223411460','t10-2','DELUXE','485712611403','','CHRISTMAS','','29.99','','','',0),('m_55191893295','o_82550563634','t409-3','STANDARD','88985783547','office','','9.99','9.99','','','',0),('m_64379284978','o_58042766044','tev40-2','PREMIUM','86214765799','home','birthday','0.00','0.00','0.00','Happy Birthday!\r\n\r\nLove, \r\nMai & Aus','Please call 410-298-3564 to deliver, if no answer, deliver to concierge.',0),('m_186288913294','o_798202414901','t68-3','STANDARD','758655314159','OFFICE ADDRESS','VALENTINE\'S DAY','0.00','0.00','9.99','Dear Inno,\r\n\r\nWishing you a very happy Valentine\'s Day!\r\n\r\nLove you.\r\n\r\nSonu','Office of myVest at 500 Howard St.',0),('m_39671154982','o_5478085210','t46-1','','','','','','','','','',0),('m_39671154982','o_92045475232','t47-1','','','','','','','','','',0),('m_39671154982','o_15833635321','t147-1','','','','','','','','','',0),('m_39671154982','o_81788615898','tev13-4','','','','','','','','','',0),('m_39671154982','o_39671155921','tev13-6','','','','','','','','','',0),('m_39671154982','o_90556285960','tev13-7','','','','','','','','','',0),('m_39671154982','o_30109536091','tev11-3','','','','','','','','','',0),('m_39671154982','o_34212276310','tev12-4','','','','','','','','','',0),('m_39671154982','o_27777066321','t37-1','','','','','','','','','',0),('m_39671154982','o_50258456335','t147-1','','','','','','','','','',0),('m_39671154982','o_51708857186','tev11-3','','','','','','','','','',0),('m_93956273199','o_24559433824','tev40-2','','','','','','','','','',0),('m_25904521708','o_982559623623','t147-1','STANDARD','154608823096','office','birthday','','','','','',0),('m_25904521708','o_826838527731','t147-1','STANDARD','522675023801','home','birthday','','','','','',0),('m_56780819617','o_16995819721','t407-1','DELUXE','16995819660','home','anniversary','0.00','0.00','4.99','Love','',0),('m_69729330337','o_685784330995','t55-2','STANDARD','110756830431','home','name1','0.00','0.00','0.00','I love you!! ','',0),('m_918214010667','o_62934498828','t10-2','STANDARD','addrecipient','','','','','','','',0),('m_924294016324','o_56944264696','t10-3','','79938494690','home','birthday','0.00','0.00','0.00','','',0),('m_868183531149','o_664809310486','T11Z106','','','','','','','','','',0),('m_64071184214','o_86883015049','t15-1','STANDARD','59090795925','home','name1','19.99','9.99','9.99','Dear Sofia,\r\nToday you are becoming 30, just make sure you do one thing...\r\nDon’t tell anyone that you have turned thirty otherwise everyone will start being jealous and hate you for looking so beautifully young – as if you have just turned twenty one. Happy birthday my mirror friend, GET READY !!!','',0),('m_464036215283','o_7340503622','t404-1','','','','','','','','','',0),('m_13144051796','o_539608912864','t147-1','STANDARD','48422728761','home','name1','0.00','0.00','0.00','I\'m so sorry that this is over do.  I feel terrible that I didn\'t attend your Grandfather\'s wake. I\'m sorry for your loss and this difficult time for you and your family. Love Noreen xoxo','Both flower orders are going to the same house in Elmhurst. ',0),('m_13144051796','o_504547014909','t54-1','STANDARD','464999914066','home','name1','0.00','0.00','0.00','With deepest sympathy, I am sorry for your loss Mr. Calderone.  My thoughts and prayers are with you and your family.  Please accept my condolences.  Love Noreen xoxo','This order is going to the same house in Elmhurst.  Both flower orders are for sympathy!',0),('m_868183531149','o_114657713563','t128-2','','','','','','','','','',0),('m_812403219959','o_778821720319','tev13-5','STANDARD','987756820187','home','MOTHER\'S DAY','0.00','0.00','0.00','Hey Mom, I figured you could dry these. Happy Mother\'s Day','',0),('m_704940918827','o_498816719234','t140-1','STANDARD','356551319172','home','','','','4.99','','',0),('m_704940918827','o_806179019529','t140-1','STANDARD','356551319172','home','birthday','','','4.99','','',0),('m_164406724455','o_905967225905','t37-1','STANDARD','866270324579','aname1','name1','0.00','19.99','9.99','Surprise!\r\nI love you so very, very much, my dear Neil! I just couldn\'t resist doing something to surprise you during our vacation. You mean absolutely everything to me, I love you more than anything in the entire world. Thank you for being my love!\r\n\r\nLove, Karen <3','The address given is the hotel we are staying at with a check in on this date. I will have informed the front desk already. I would like these in the room under my name, Karen Bombaro, upon our arrival. Thank you so very much!',0),('m_720160724233','o_152085624422','t10-3','STANDARD','','','','','','','','',0),('m_11534626143','o_94664551441','tev24-2','PREMIUM','1368909684','office','anniversary','0.00','0.00','0.00','Yvonne,\r\n    Thank you for being everything ive always wanted. You make me smile everyday. Youre such a beautiful woman and i am so grateful to have you as mine.\r\n\r\nHappy Anniversary, \r\n\r\nLove Anthoney (your Portuguese Man)\r\n','flowers MUST be delivered on scheduled date between 11am and 3pm. if there is any problems with delivery within that time, please email the provided email on this account prior to delivery.',0),('','o_58563748041','tev24-2','PREMIUM','23675437817','office','anniversary','0.00','0.00','0.00','Yvonne,\r\n    Thank you for being everything ive always wanted. You make me smile everyday. Youre such a beautiful woman and i am so grateful to have you as mine.\r\n\r\nHappy Anniversary, \r\n\r\nLove Anthoney (your Portuguese Man)\r\n','the flowers must be delivered between 11am and 3pm to designated address. if there is any problem please call the number provided',0),('m_18131815426','o_56940465759','t46-1','','83391536528','','','9.99','0.00','0.00','Happy Mother\'s Day!  I hope you have a wonderful and relaxing day.  Looking forward to seeing you soon!  Love you! Andrea (and Kurt)','',0),('m_18131815426','o_41175385801','t55-2','','21638006565','aname1','MOTHER\'S DAY','9.99','0.00','0.00','Happy Mother\'s Day!  We hope you have a wonderful day!!  We are looking forward to seeing you soon!  Love, Kurt and Andrea','',0),('m_86004669167','o_86004669980','t10-2','DELUXE','86004669547','home','MOTHER\'S DAY','','','','','',0),('m_165575520453','o_625310321317','t147-1','','addrecipient','','','','','','','',0),('m_812752922749','o_324071624501','t147-1','STANDARD','377673423776','home','birthday','','','','','',0),('m_812752922749','o_534443024786','t37-1','','377673423776','HOME ADDRESS','MOTHER\'S DAY','0.00','0.00','0.00','HAPPY MOTHERS DAY!! I know you miss me and I sure do miss you, and I can\'t be there to tell you how much I love you. But instead I got some flowers for you!!','',0),('m_834092428748','o_605409931344','t46-1','STANDARD','664977229431','home','name1','0.00','0.00','0.00','No matter how far I am, i still love you. Always','',0),('m_6027988106','o_68556078964','t10-2','','','','','','','','','',0),('m_127735428356','o_13760127920','tev23-5','DELUXE','62081047536','aname1','MOTHER\'S DAY','0.00','0.00','0.00','I love you! \r\nxoxoxoxoxox\r\nJosh','',0),('m_127735428356','o_51611829108','t141-1','DELUXE','13365368663','aname1','MOTHER\'S DAY','0.00','0.00','0.00','I love you!!\r\nxoxoxoxoxo\r\nJosh','',0),('m_90321341533','o_774741231280','tev12-4','','','','','','','','','',0),('m_83362023302','o_285844372','t140-1','','addrecipient','aname1','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day! I love you and I\'ll see you soon!','',0),('m_12040110213','o_231381911495','t147-1','PREMIUM','59676410581','home','birthday','0.00','0.00','0.00','Happy birthday Mom! I love you and I hope you have a great day!\r\n\r\nDavid','If no one is home, leave on back patio',0),('m_12040110213','o_73731111786','t140-1','DELUXE','59676410581','home','MOTHER\'S DAY','9.99','0.00','0.00','Happy Mother\'s Day, Mom!\r\n\r\nI hope you are have a great day and I love you very much!\r\n\r\nDavid','If no one is home, leave on back patio.',0),('m_872187430504','o_328018717335','tev25-3','STANDARD','758031431324','home','MOTHER\'S DAY','','','','','',0),('m_23410241332','o_12408796225','trs03-1','PREMIUM','20579915550','HOME ADDRESS','name1','19.99','0.00','0.00','Mom, I just wanted to let you know that I love you so much! HAPPY MOTHER\'S DAY!!\r\n                                    ~Peeper','',0),('m_23410241332','o_917232210059','tev40-2','DELUXE','60424829848','HOME ADDRESS','name1','0.00','0.00','0.00','Flores hermosas, para una seÃƒÂ±ora encantadora. Ã‚Â¡Espero que estas flores pongan una sonrisa en su cara, y aclaren su dÃƒÂ­a! Ã‚Â¡Feliz dÃƒÂ­a de la madre!\r\n\r\n                                  ~Chris Willis','',0),('m_23410241332','o_439151411923','tev155-1','PREMIUM','697546811716','HOME ADDRESS','name1','9.99','0.00','0.00','We want you to know that we love appreciate and cherish you more than words or  could ever say... We would be lost....and bored.... without you!\r\n      HAPPY MOTHERS DAY!!\r\n                                 ~Your Boys','',0),('m_77341031114','o_162700332016','t55-2','STANDARD','signin','','','','','','','',0),('m_46903826711','o_96364127030','t41-1','STANDARD','979740726861','home','1ST DAY OF HANUKKAH','9.99','','','','',0),('m_46903826711','o_546978727661','t10-2','','addrecipient','','','','','','','',0),('m_613885216775','o_649651917902','t72-3','DELUXE','648665017127','aname1','name1','9.99','0.00','4.99','I love you mom','',0),('m_511589529163','o_328790029538','t140-1','DELUXE','369817429407','home','name1','0.00','0.00','0.00','Happy Mother\'s Day!!!','',0),('m_24982702853','o_45511419928','T11Z106','STANDARD','18266408513','aname1','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day!\r\n\r\nDavid, Cora, and Liz','',0),('m_24982702853','o_380505110100','t140-2','STANDARD','74990199989','aname1','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day!\r\n\r\nLiz, Cora, and David','',0),('m_63600133613','o_9869683790','tev40-2','DELUXE','63600133680','home','name1','0.00','0.00','0.00','Happy Mothers Day!\r\n\r\n\r\nLove,\r\nErin and Sass\r\n\r\n','Leave at front door',0),('m_53506287314','o_96467027566','tev40-2','STANDARD','10925327521','home','MOTHER\'S DAY','0.00','0.00','0.00','Happy Mother\'s Day\r\n\r\n\r\n\r\nLove,\r\nSass and Erin','Leave at front door',0),('m_396504825289','o_342409525710','tev20-1','','947026828477','aname1','name1','0.00','0.00','0.00','I know they\'re going to die, but so are we and we love each other in the meantime, so why not enjoy these too?\r\n\r\nHappy Anniversary \r\n\r\nLove, Emy','When you arrive in the main door of the building (the one of the left if you\'re facing it), use the phone in the lobby to call \"2650\" to reach Brian and have him come get the flowers. Thanks!',0),('m_81362171978','o_92196202372','t404-2','STANDARD','29135892267','home','name1','','9.99','','','',0),('m_363220119702','o_381909820039','tev12-4','','180420620091','home','birthday','0.00','0.00','4.99','Happy Birthday Amma! I love you so much! Thank you for being an amazing mother, best friend, and best cook ever. I love you for supporting me and for all the kisses you give me. I hope you have an amazing birthday!\r\n\r\n- Pinky','',0),('m_74745313130','o_154976213187','t10-3','','613036713764','aname1','birthday','0.00','0.00','0.00','','',0),('m_739297130709','o_1753461722','t74-1','DELUXE','148884330909','aname2','name1','0.00','0.00','0.00','Thinking of you!\r\n\r\nJason','None',0),('m_247240610273','o_354100511577','t37-1','STANDARD','598934610957','aname1','name1','','9.99','4.99','','',0),('m_39062101234','o_174667012682','tev155-1','STANDARD','6759312469','home','birthday','0.00','0.00','0.00','I can\'t believe how lucky i am to have had another year with you.\r\n\r\nWith all my love,\r\n\r\nCurt','',0),('m_39062101234','o_124369513322','t142-1','DELUXE','6759312469','home','MOTHER\'S DAY','9.99','0.00','0.00','Thank you for being the greatest mother I could ever ask for for all of our kids.  \r\nYou do so much, and we all appreciate everything you do.\r\n\r\nI love you,\r\n\r\nCurt','',0),('m_39062101234','o_995665313584','tev23-5','DELUXE','768040513527','aname1','name1','9.99','0.00','0.00','Happy Birthday, Mom.\r\nThanks for being the best mom we could ever ask for.  \r\n\r\nCurt & Pam','',0),('m_704322432645','o_58901222347','tev21-1','DELUXE','329797132766','home','birthday','0.00','9.99','0.00','Ass,\r\n\r\nYou are a beautiful, determined, hilarious, and angelic person.  Every day I am glad we have become so close.  I cherish what we have, and wish you nothing but happiness.  So get LIT for your 21st!\r\n\r\nLove,\r\nJames ','',0),('m_813058626019','o_627448228270','t9-3','DELUXE','565413627244','home','anniversary','','','','','',0),('m_192447631405','o_947120031541','t46-1','','addrecipient','aname1','BIRTHDAY','0.00','0.00','0.00','','',0),('m_876203323488','o_281948429138','tev13-6','','440136824898','HOME ADDRESS','name1','0.00','0.00','0.00','Anonymous','Please knock on the door first. If no answer call her a few times at 303-810-7906. If she is not home, please leave the flowers at the office and send her a text telling her that she has flowers at the office. Thanks!',0),('m_876203323488','o_276820029151','t48-3','','440136824898','HOME ADDRESS','name1','0.00','0.00','0.00','Anonymous','If she doesn\'t answer the door please try calling her at 303-810-7906. Leave the flowers at the office if she isn\'t there and send her a text about them if possible. Thank you very much!',0),('m_268041328749','o_549761428820','t53-1','','','','','','','','','',0),('m_76246771241','o_77553551377','t8-1','STANDARD','','','','','','','','',0),('m_14412035256','o_81624435498','tev24-2','','','','','','','','','',0),('m_22417149303','o_976526310387','t128-2','STANDARD','82119309350','aname1','anniversary','','9.99','','','',0),('m_103721428407','o_402157331231','t128-2','STANDARD','664350530641','aname1','anniversary','0.00','0.00','0.00','To a partner who is so, so, so, loved. I often don\'t have the words to express fully how proud I am of what we have built, and how eager I am to get back to you. Counting down the seconds. I love you, Nana Ama. \r\n\r\nSorry none of these are teal. Will do more research on flowers lmao.\r\n\r\n-Muzz','',0),('m_547716826611','o_104548127633','t65-1','STANDARD','987924827305','home','birthday','0.00','0.00','0.00','Happy Birthday to the most amazing and\r\nbeautiful woman in the world. I hope your day\r\nis filled with joy for the present,hope for\r\nthe future and love forever!!!','',0),('m_62077634583','o_48511965255','t400-2','STANDARD','','','','9.99','9.99','4.99','','',0),('m_829479412425','o_710538612561','t147-1','','','','','','','','','',0),('m_38924320064','o_774263821038','tev40-2','','','','','','','','','',0),('m_246724423146','o_431004223680','tev13-7','STANDARD','143662323362','home','name1','0.00','0.00','4.99','To my soon-to-be wife and the love of my life :)','',0),('m_4584746416','o_80712867409','t65-2','','','','','','','','','',0),('m_24894001062','o_129501322','t141-1','STANDARD','27739311160','office','','','','','','',0),('m_24894001062','o_67573651339','t11-1','','','','','','','','','',0),('m_388145122374','o_876482822466','tev25-3','','','','','','','','','',0),('m_933114026815','o_184063427210','tev24-4','PREMIUM','addrecipient','','','','','','','',0),('m_81973848113','o_781372110357','tev20-1','STANDARD','85598118329','home','name1','0.00','0.00','0.00','I love you so much and I\'m so sorry for everything that I\'ve done.','',0),('m_97589749187','o_566759614518','trs03-1','PREMIUM','84537214308','home','name1','29.99','29.99','4.99','','',0),('m_72053258278','o_82970998646','t147-1','STANDARD','73641128425','aname1','name1','','','','','',0),('m_72053258278','o_82689899474','t409-3','STANDARD','73641128425','aname1','VALENTINE\'S DAY','9.99','9.99','','','',0),('m_770760111454','o_38144651453','t409-3','STANDARD','370592711648','aname1','otrafecha','29.99','29.99','9.99','Hi baby, I love and miss you so much! Cant wait till you\'re back in my arms again. Ps- will you marry me? I want to spend the rest of my life with you. I didn\'t send your ring because I didn\'t want it to get lost. Love you sweetheart, Eli','',0),('m_877608619474','o_748904420661','t9-1','STANDARD','232113619737','aname1','name1','29.99','19.99','','','',0),('m_789260825801','o_102738426174','t128-2','PREMIUM','528548026064','home','name1','0.00','0.00','0.00','My wish is that you two are being tender and gentle with each others hearts while I am away.  Please take 30 minutes tonight for a sacred ritual of gratitude for each other <3\r\n-Shaman Buttaz','',0),('m_10468442722','o_52304813690','tev40-2','STANDARD','91014773430','office','birthday','','','4.99','','',0),('m_2251045909','o_42891121181','t400-2','','52733831813','aname1','name1','0.00','0.00','0.00','Estas en mi cabeza... ','If possible, please deliver after 5:30pm.',0),('m_154459529465','o_291596629772','t147-1','DELUXE','795319629555','home','name1','0.00','9.99','0.00','I love you\r\n\r\nYasir','',0),('m_5045471421','o_22679513470','t46-1','STANDARD','87130322302','aname1','name1','0.00','0.00','0.00','Grandma,\r\nYou and grandpa have done so much for all the grandchildren, so I figured I\'d try and give a little something back. I wish I could be there to spend some time with you, grabbing lunch or coffee (decaf, of course).\r\n\r\nLove,\r\nSchafer','',0),('m_610203713993','o_25526579433','t15-1','STANDARD','78596148688','aname1','name1','9.99','0.00','0.00','you are the sweetest woman have ever know in my entire life sweetheart','',0),('m_742479210051','o_481272910292','tev40-2','STANDARD','463570110113','home','MOTHER\'S DAY','9.99','0.00','0.00','Happy Mother\'s Day! Won\'t be long now.','',0),('m_742479210051','o_943968410551','t19-1','STANDARD','463570110113','home','birthday','0.00','0.00','4.99','Happy birthday, hope to see you soon!','',0),('m_742479210051','o_804513910623','t128-2','STANDARD','463570110113','home','CHRISTMAS','19.99','0.00','0.00','Merry Christmas! Sorry I can\'t be there, but it won\'t be much longer.','',0),('m_634225029045','o_3065255353','t147-1','STANDARD','341754632134','home','name1','0.00','0.00','0.00','Happy day-before-your-birthday-to-make-sure-these-actually-got-delivered!\r\n\r\nSorry i\'m not there, but hope you\'re able to celebrate and have a good day!','',0),('m_90916806343','o_83455906598','t50-1','DELUXE','29444356533','office','birthday','','','','','',0),('m_209725321781','o_75249422457','t65-2','STANDARD','18343222287','home','name1','','','','','',0),('m_344059625879','o_457872025916','tev25-3','','','','','','','','','',0),('m_612418319465','o_338144220178','tev40-2','','','','','','','','','',0),('m_567723215614','o_556179816485','t147-1','STANDARD','431079615850','home','name1','','','','','',0),('m_650332025936','o_275806727340','t10-2','STANDARD','112534027713','','','9.99','19.99','4.99','','',0),('m_72532883826','o_25765464586','t8-1','STANDARD','75856664177','aname1','BIRTHDAY','0.00','0.00','9.99','The best woman a guy could ever wish for!! Love, your boo boo baby bear','',0),('m_688777228921','o_130959029092','t37-1','STANDARD','735426629003','home','name1','0.00','0.00','0.00','Happy 5-Months Karen. These have been the best months of my life and it already feels like 5 years. I am so proud of how hard you\'ve been working and I hope these make you smile today. I will always work every day to make you smile. ','',0),('m_28833159756','o_103364310792','tev13-6','STANDARD','213722510110','aname1','name2','0.00','0.00','4.99','Congratulations!! Love Sheena','',0),('m_411516331984','o_5763711039','tev40-2','DELUXE','683472932745','OFFICE ADDRESS','birthday','0.00','0.00','0.00','May your birthday be just the start of a year filled with good luck, good health, and much happiness! Happy Birthday! Jenn, Chad, and the Second Nature Team\r\n','',0),('m_933180614678','o_267171914796','t10-2','PREMIUM','867991415697','','name1','0.00','0.00','0.00','1 week down. I love you, My Dragon!','',0),('m_417390922826','o_810112423005','t140-1','','addrecipient','aname1','ANNIVERSARY','0.00','0.00','0.00','','',0),('m_65111759309','o_512306110949','tev25-3','','addrecipient','','','','','','','',0),('m_52726778659','o_56282309615','t128-2','STANDARD','1476829512','office','birthday','0.00','0.00','4.99','Happy 24th Birthday baby girl\r\nI love you to the moon and back.\r\n\r\nMom and Woody','',0),('m_465876329642','o_224346630142','t140-1','','298955529801','home','birthday','0.00','0.00','0.00','','',0),('m_957372417374','o_86570119289','tev12-7','STANDARD','474163217785','home','name1','9.99','9.99','14.99','I LOVE U MOM!','',0),('m_38861327086','o_126117220574','t48-2','','','','','','','','','',0),('m_694382927045','o_883641428912','t46-1','STANDARD','278680428804','home','BIRTHDAY','0.00','0.00','0.00','Happy Birthday!!','',0),('m_91181249277','o_17582969615','t11-1','','','','','','','','','',0),('m_77011933152','o_56069085116','t147-1','STANDARD','70626063618','home','birthday','','','','','',0),('m_80654664944','o_57660446800','tev13-4','STANDARD','37511526458','office','name1','0.00','0.00','0.00','I want you to know how loved you truly are. You are so strong and resilient don\'t ever forget that! I am blessed to have you not only as my Aunt but my Best Friend','',0),('m_80059314263','o_90893345883','tev13-5','','','','','','','','','',0),('m_36912579665','o_38500449829','t128-2','','','','','','','','','',0),('m_54816221625','o_33671575036','tev31-5','STANDARD','82224244190','OFFICE ADDRESS','VALENTINE\'S DAY','0.00','0.00','0.00','','',0),('m_54816221625','o_81992495038','tev31-5','STANDARD','82224244190','office','1ST DAY OF HANUKKAH','0.00','0.00','0.00','','',0),('m_54816221625','o_81992495039','tev31-5','STANDARD','82224244190','office','','','','','','',0),('m_46031287793','o_85037318546','t147-1','STANDARD','98736048097','office','name1','0.00','0.00','0.00','You are AMAZING! And we miss you already. But we know that you\'ll do wonderful things. \r\n\r\nBest of Luck on Your Next adventure,\r\nIMPACT Team\r\n','',0),('m_660583023568','o_965627723758','t173-1','PREMIUM','','','','','','','','',0),('m_2037620152','o_41884321101','tev21-1','STANDARD','389630720259','home','anniversary','0.00','0.00','0.00','Happy 1st, Bing and Bong,\r\n\r\nLove Adam','',0),('m_65590285090','o_48336025513','t147-1','STANDARD','addrecipient','','','','','','','',0),('m_56142347774','o_85586758932','t147-1','STANDARD','23783878508','home','birthday','','','','','',0),('m_92179539191','o_66196374036','t47-1','STANDARD','72897704138','home','name1','0.00','0.00','0.00','Hi Mama :) \r\n\r\nI hope you got these flowers okay. I just wanted you to know that I\'m thinking about you and I love you very much. I\'m sorry I\'m not there with you today, but i\'ll see you soon. \r\n\r\nI love you Mama.\r\n\r\nLove,\r\nSierra','',0),('m_62783217495','o_35598119012','t128-2','STANDARD','48517888854','aname1','name1','0.00','0.00','0.00','Happy Birthday baby, and Merry belated Christmas. I really hope these get there on time. I miss you like crazy. I can\'t wait to always have you with me again. I love you so much! Have a great birthday!','',0),('m_726575112772','o_61553314069','t37-1','','','','','','','','','',0),('m_985172620175','o_167778222533','t128-2','PREMIUM','911550520885','aname1','name1','','','','','',0),('m_523211330346','o_8826411526','tev12-4','STANDARD','822290432186','aname1','1ST DAY OF HANUKKAH','','','','','',0),('m_523211330346','o_63134022362','tev13-4','STANDARD','71423231903','aname1','1ST DAY OF HANUKKAH','','','','','',0),('m_523211330346','o_15094193303','t46-1','STANDARD','38601262862','aname1','1ST DAY OF HANUKKAH','','','','','',0),('m_84344523516','o_94685105457','t128-2','STANDARD','85172834885','office','VALENTINE\'S DAY','0.00','0.00','0.00','Thank you for being in my life, and loving me.  \r\n\r\nI love you.\r\nMr. Nathan Ruth\r\n','',0),('m_84344523516','o_81829656558','tev25-3','STANDARD','85172834885','office','name1','0.00','0.00','0.00','We made another year of great happiness and beautiful love.   Thank you for marrying and loving me.  I thank God for you.\r\n\r\nI love you.\r\nMr. Nathan Ruth','',0),('m_84344523516','o_69654477279','t147-1','STANDARD','85172834885','office','birthday','0.00','0.00','0.00','HAPPY BIRTHDAY, MY BABY!\r\n\r\nI love you.\r\nMr. Nathan Ruth','',0),('m_208901512766','o_529631117058','tev13-4','STANDARD','571839313692','home','birthday','0.00','0.00','0.00','HAPPY BIRTHDAY','',0),('m_523211330346','o_27572917241','tev12-4','','','','','','','','','',0),('m_523211330346','o_47258337448','tev13-6','','','','','','','','','',0),('m_747843226310','o_415182526875','tev40-2','STANDARD','','','','','','','','',0),('m_474150816784','o_874318217001','t37-1','','addrecipient','','','','','','','',0),('m_14090845319','o_89804817565','t128-2','STANDARD','76786356295','aname1','name1','0.00','0.00','4.99','Happy birthday!!!\r\nI love you so so much!\r\n','',0),('m_556250419137','o_666414719791','tev12-4','STANDARD','347315319434','home','name1','0.00','0.00','0.00','Looking forward to our date','',0),('m_601462416982','o_176146217679','t68-3','','addrecipient','','','','','','','',0),('m_607717125137','o_423930725709','t46-1','STANDARD','985053425368','aname1','name1','0.00','0.00','0.00','Happy Rodanniversary! \r\nWe are so thankful for your yes 4 years ago! We have loved watching you grow as a leader and as a person and can\'t wait to see what this year brings!\r\nJen & AJ ','',0),('m_879647122468','o_140360024276','tev12-4','STANDARD','928120522914','aname1','name1','0.00','0.00','0.00','Happy Birthday Grandma! We love you so much!','',0),('m_750294230984','o_9042751278','tev30-2','','addrecipient','','','','','','','',0),('m_228797732507','o_31943431370','T11Z106','STANDARD','766102129551','aname1','anniversary','0.00','0.00','0.00','Happy Anniversary- You light up my life with your smile, eyes, and presence. \r\n\r\nI love you!\r\n\r\n-Shane','',0),('m_228797732507','o_766102131552','t409-3','STANDARD','766102129551','aname1','VALENTINE\'S DAY','9.99','0.00','0.00','Happy Valentine\'s Day my love. \r\n\r\n-Shane','',0),('m_913235220342','o_774961421425','t147-1','STANDARD','774961420991','home','birthday','0.00','0.00','0.00','Happy Birthday Mom!\r\nHope you have a wonderful birthday and I will see you soon!\r\nLove you!','',0),('m_821177825861','o_116459126403','t152-2','STANDARD','907030526003','aname1','name2','0.00','9.99','0.00','Dear Emily,\r\nIf all goes well, you\'ll get these on results day. I want you to know that pass or fail I am incredibly proud of you and I love you with every part of my soul. You\'re the most wonderful, perfect, beautiful girl on the planet. 7 more sleeps until back-to-back weekends begin! \r\nLove, Kyle ','',0),('m_82068335777','o_389207713172','tev19-1','STANDARD','78177948300','home','name1','0.00','0.00','0.00','Thought you needed this.','Gravel drive way off road. Has grey deck on front of the house.',0),('m_227141432323','o_682391026165','t142-1','','792899026066','','','','','','','',0),('m_71736361727','o_436365730507','tev33-1','','','','','','','','','',0),('m_448735829889','o_1919114892','tev24-2','STANDARD','182894530006','home','anniversary','9.99','','','','',0),('m_63243408361','o_63524499232','t128-2','STANDARD','addrecipient','aname1','VALENTINE\'S DAY','0.00','0.00','0.00','Happy Valentine\'s day! \r\nI\'m sorry sweet pea that I can\'t be there but I still want you to get some flowers from me. I love you punkin and hope you have a good day today. I\'m almost done sweetie. We will talk soon.','',0),('m_79863854741','o_72402964999','t400-2','STANDARD','72121864869','home','VALENTINE\'S DAY','','','','','',0),('m_79863854741','o_8829805053','t46-1','STANDARD','72121864869','home','anniversary','','','','','',0),('m_919257432498','o_97850781856','tev24-2','PREMIUM','79191051359','office','VALENTINE\'S DAY','0.00','0.00','0.00','Happy Valentines Day Mom\r\n\r\nLove,\r\nSantana ','',0),('m_18230328247','o_783309429289','t147-1','DELUXE','addrecipient','','','','','','','',0);

--
-- Table structure for table `dated`
--

CREATE TABLE `dated` (
  `orderID` varchar(40) NOT NULL,
  `fecha` date NOT NULL,
  PRIMARY KEY (`orderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `dated`
--

INSERT INTO `dated` VALUES ('o_102738426174','2017-08-29'),('o_103364310792','2017-10-02'),('o_104548127633','2017-07-05'),('o_113573930685','2015-02-19'),('o_114657713563','0000-00-00'),('o_115200612812','0000-00-00'),('o_116459126403','2018-01-19'),('o_11932554181','2015-04-06'),('o_12408796225','2017-05-13'),('o_124369513322','2015-05-10'),('o_126117220574','0000-00-00'),('o_129501322','0000-00-00'),('o_130959029092','2017-09-28'),('o_13760127920','2015-05-10'),('o_140360024276','2018-10-21'),('o_140665517356','0000-00-00'),('o_14281810309','0000-00-00'),('o_143310014412','0000-00-00'),('o_14439015676','2015-05-10'),('o_15094193303','2014-12-16'),('o_152085624422','0000-00-00'),('o_1544665074','2016-07-04'),('o_154976213187','2017-06-05'),('o_15833635321','0000-00-00'),('o_159454728929','2015-02-14'),('o_162700332016','0000-00-00'),('o_164542920374','2014-08-21'),('o_167778222533','0000-00-00'),('o_16995819721','2017-03-09'),('o_174061326645','0000-00-00'),('o_174667012682','2018-01-23'),('o_1753461722','2017-06-10'),('o_17582969615','0000-00-00'),('o_176146217679','0000-00-00'),('o_17737598530','0000-00-00'),('o_179425922527','0000-00-00'),('o_184063427210','0000-00-00'),('o_18816263362','0000-00-00'),('o_1919114892','0000-00-00'),('o_194603225914','2015-05-10'),('o_200797821678','2015-05-25'),('o_220658211879','0000-00-00'),('o_224346630142','2017-10-30'),('o_22679513470','2017-09-01'),('o_231381911495','2018-03-13'),('o_231706028272','2014-08-21'),('o_24559433824','0000-00-00'),('o_246579429885','0000-00-00'),('o_24910538294','2015-02-14'),('o_251766632691','2015-10-14'),('o_2546212099','2015-01-30'),('o_25526579433','2017-08-27'),('o_25765464586','2017-09-27'),('o_26010731083','0000-00-00'),('o_261601817241','0000-00-00'),('o_265269214970','0000-00-00'),('o_266120612674','2015-07-03'),('o_267171914796','2017-10-27'),('o_273531517473','2015-04-28'),('o_273952821914','2014-08-06'),('o_27572917241','0000-00-00'),('o_275774626399','0000-00-00'),('o_275806727340','0000-00-00'),('o_276820029151','2017-06-12'),('o_277073114658','2015-02-14'),('o_277545520089','0000-00-00'),('o_27777066321','0000-00-00'),('o_281948429138','2017-06-12'),('o_284223411460','2015-12-25'),('o_285844372','2015-05-10'),('o_291596629772','2017-08-31'),('o_29965738216','0000-00-00'),('o_30109536091','0000-00-00'),('o_302124825284','0000-00-00'),('o_3065255353','2017-09-20'),('o_31943431370','2018-03-20'),('o_324071624501','0000-00-00'),('o_328018717335','2015-05-10'),('o_328790029538','2017-05-13'),('o_33671575036','2015-02-14'),('o_338144220178','0000-00-00'),('o_3382624889','0000-00-00'),('o_34212276310','0000-00-00'),('o_342409525710','2017-06-01'),('o_34305524745','0000-00-00'),('o_3431997430','2017-08-10'),('o_354100511577','2017-06-14'),('o_35417615343','2015-03-02'),('o_35598119012','2017-12-29'),('o_359343516294','0000-00-00'),('o_36812917208','2015-04-18'),('o_380505110100','2015-05-10'),('o_38140616281','0000-00-00'),('o_38144651453','0000-00-00'),('o_381909820039','2017-08-28'),('o_384331329720','0000-00-00'),('o_38500449829','0000-00-00'),('o_387504326570','2015-02-14'),('o_389207713172','2018-01-26'),('o_39671155921','0000-00-00'),('o_402157331231','2017-07-07'),('o_406349325992','2016-09-09'),('o_41175385801','2015-05-10'),('o_415182526875','0000-00-00'),('o_417912829703','0000-00-00'),('o_418798413293','0000-00-00'),('o_41884321101','2017-11-25'),('o_42133712594','0000-00-00'),('o_423930725709','2018-01-31'),('o_42891121181','2017-08-24'),('o_431004223680','2017-08-13'),('o_436365730507','0000-00-00'),('o_439151411923','2017-05-13'),('o_439534830334','2014-10-31'),('o_44532214405','2015-04-22'),('o_445746910496','0000-00-00'),('o_45511419928','2015-05-10'),('o_457872025916','0000-00-00'),('o_460851326744','2015-02-12'),('o_46531901140','2016-09-01'),('o_47258337448','0000-00-00'),('o_47667357835','0000-00-00'),('o_481272910292','2015-05-10'),('o_48336025513','0000-00-00'),('o_48511965255','0000-00-00'),('o_488541116293','0000-00-00'),('o_497698324565','0000-00-00'),('o_498816719234','0000-00-00'),('o_50258456335','0000-00-00'),('o_504547014909','2017-03-27'),('o_512306110949','0000-00-00'),('o_514719114170','2015-05-10'),('o_51611829108','2015-05-10'),('o_51708857186','0000-00-00'),('o_52056858524','2015-02-14'),('o_52304813690','0000-00-00'),('o_52764543116','2015-05-10'),('o_528538225037','0000-00-00'),('o_529276431472','0000-00-00'),('o_529631117058','2017-12-17'),('o_534443024786','2015-05-10'),('o_539608912864','2017-03-27'),('o_546978727661','0000-00-00'),('o_5478085210','0000-00-00'),('o_549761428820','0000-00-00'),('o_556179816485','2017-12-08'),('o_55695438126','0000-00-00'),('o_56069085116','0000-00-00'),('o_56282309615','2017-10-27'),('o_565094228128','2015-02-14'),('o_566759614518','2017-08-16'),('o_56940465759','0000-00-00'),('o_56944264696','2017-05-27'),('o_57009748506','0000-00-00'),('o_574241013062','2015-05-10'),('o_5763711039','2017-10-07'),('o_57660446800','2017-11-07'),('o_577715414896','2015-01-29'),('o_58042766044','2017-01-26'),('o_580722513484','2015-08-11'),('o_581775624117','0000-00-00'),('o_584122810511','0000-00-00'),('o_58563748041','2017-04-19'),('o_58901222347','2017-10-10'),('o_597709219738','0000-00-00'),('o_601059910157','0000-00-00'),('o_605409931344','2017-05-14'),('o_61553314069','0000-00-00'),('o_625310321317','0000-00-00'),('o_627448228270','0000-00-00'),('o_628237231459','0000-00-00'),('o_62934498828','0000-00-00'),('o_63134022362','2014-12-16'),('o_634772624546','0000-00-00'),('o_63524499232','2015-02-14'),('o_649651917902','2017-05-12'),('o_649747717121','2015-02-14'),('o_653446531765','0000-00-00'),('o_66014424855','2015-02-13'),('o_661770314556','2014-08-11'),('o_66196374036','2017-12-03'),('o_664809310486','0000-00-00'),('o_666414719791','2018-01-11'),('o_67328157773','2014-08-25'),('o_67573651339','0000-00-00'),('o_679394229356','0000-00-00'),('o_682391026165','0000-00-00'),('o_68556078964','0000-00-00'),('o_685784330995','2017-03-08'),('o_69208543359','2015-07-01'),('o_69654477279','2018-01-25'),('o_70104019081','2015-02-13'),('o_707592218997','2016-04-19'),('o_708069724766','0000-00-00'),('o_710538612561','0000-00-00'),('o_714804918474','2016-08-23'),('o_718259829604','2015-02-14'),('o_719105126574','0000-00-00'),('o_72402964999','2015-02-14'),('o_7340503622','0000-00-00'),('o_73731111786','2015-05-10'),('o_74467823746','0000-00-00'),('o_748144823906','2015-01-27'),('o_748904420661','2017-08-19'),('o_75249422457','2017-10-02'),('o_755733316875','2016-08-15'),('o_766102131552','2015-02-14'),('o_767705930680','2015-02-14'),('o_774263821038','0000-00-00'),('o_774741231280','0000-00-00'),('o_774961421425','2018-04-07'),('o_77553551377','0000-00-00'),('o_778821720319','2015-05-10'),('o_781372110357','2017-08-13'),('o_783309429289','0000-00-00'),('o_783598831223','0000-00-00'),('o_79389625119','0000-00-00'),('o_79646359346','0000-00-00'),('o_798202414901','2015-02-14'),('o_80334118161','0000-00-00'),('o_804513910623','2015-12-25'),('o_806179019529','0000-00-00'),('o_80712867409','0000-00-00'),('o_810112423005','0000-00-00'),('o_811002430754','2015-02-13'),('o_815368023489','0000-00-00'),('o_81624435498','0000-00-00'),('o_81788615898','0000-00-00'),('o_81829656558','2018-06-15'),('o_81992495038','2014-12-16'),('o_81992495039','0000-00-00'),('o_82051417745','2015-01-29'),('o_823194024406','0000-00-00'),('o_82550563634','0000-00-00'),('o_826838527731','0000-00-00'),('o_82689899474','2015-02-14'),('o_82970998646','2017-09-22'),('o_834116814335','2014-10-24'),('o_83455906598','0000-00-00'),('o_840094219649','2016-09-24'),('o_842260526413','2015-02-13'),('o_848171514457','2015-02-13'),('o_848302826573','2015-02-14'),('o_84951524118','2015-01-27'),('o_85037318546','2017-12-08'),('o_85586758932','0000-00-00'),('o_86004669980','2015-05-10'),('o_863407012985','2015-05-10'),('o_86570119289','2017-11-02'),('o_86883015049','2017-03-16'),('o_8714755097','0000-00-00'),('o_87314388123','2015-02-14'),('o_874318217001','0000-00-00'),('o_876482822466','0000-00-00'),('o_881093620244','2014-08-12'),('o_8826411526','2014-12-16'),('o_8829805053','0000-00-00'),('o_883641428912','2017-11-06'),('o_887544425631','2014-08-13'),('o_888505225080','0000-00-00'),('o_89262356214','0000-00-00'),('o_89804817565','2018-02-12'),('o_901053314678','2015-08-08'),('o_9042751278','0000-00-00'),('o_90556285960','0000-00-00'),('o_905967225905','2017-04-26'),('o_90626565963','2015-02-14'),('o_90893345883','0000-00-00'),('o_917232210059','2017-05-13'),('o_918078629955','2014-08-21'),('o_92045475232','0000-00-00'),('o_921714016892','0000-00-00'),('o_92196202372','2017-07-01'),('o_922925929446','2015-05-10'),('o_92402451643','2014-07-18'),('o_932542914885','0000-00-00'),('o_9327344599','2016-08-12'),('o_943968410551','2018-04-16'),('o_94664551441','2017-04-19'),('o_94685105457','2015-02-14'),('o_947120031541','0000-00-00'),('o_956325530330','2014-10-31'),('o_96364127030','2014-12-16'),('o_96467027566','2015-05-10'),('o_965627723758','0000-00-00'),('o_97358353170','0000-00-00'),('o_976526310387','0000-00-00'),('o_977724820415','2015-05-10'),('o_97850781856','2015-02-14'),('o_98186507020','2016-07-18'),('o_982559623623','0000-00-00'),('o_985027530481','2014-07-02'),('o_9869683790','2017-05-14'),('o_992824312261','2015-02-14'),('o_995665313584','2018-05-09'),('o_995972915570','2014-08-12');

--
-- Table structure for table `holiday`
--

CREATE TABLE `holiday` (
  `holiday` varchar(100) NOT NULL,
  `fecha` date NOT NULL,
  UNIQUE KEY `holiday` (`holiday`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `holiday`
--

INSERT INTO `holiday` VALUES ('1st Day of Hanukkah','2014-12-16'),('1st Day of Kwanzaa','2015-12-26'),('1st Day of Passover','2015-04-03'),('Administrative Professional\'s Day','2015-04-22'),('Christmas','2015-12-25'),('Easter','2015-04-05'),('Father\'s Day','2015-06-21'),('Halloween','2015-10-31'),('Mother\'s Day','2015-05-10'),('National Grandparents Day','2015-09-13'),('Thanksgiving','2015-11-26'),('Valentine\'s Day','2015-02-14'),('Women\'s Day','2015-03-08');

--
-- Table structure for table `otheraddress`
--

CREATE TABLE `otheraddress` (
  `profileID` varchar(50) NOT NULL,
  `address1` varchar(400) NOT NULL,
  `city1` varchar(400) NOT NULL,
  `state1` varchar(100) NOT NULL,
  `zip1` varchar(20) NOT NULL,
  `aname1` varchar(400) NOT NULL,
  `address2` varchar(400) NOT NULL,
  `city2` varchar(400) NOT NULL,
  `state2` varchar(100) NOT NULL,
  `zip2` varchar(20) NOT NULL,
  `aname2` varchar(400) NOT NULL,
  `address3` varchar(400) NOT NULL,
  `city3` varchar(400) NOT NULL,
  `state3` varchar(100) NOT NULL,
  `zip3` varchar(20) NOT NULL,
  `aname3` varchar(400) NOT NULL,
  `address4` varchar(400) NOT NULL,
  `city4` varchar(400) NOT NULL,
  `state4` varchar(100) NOT NULL,
  `zip4` varchar(20) NOT NULL,
  `aname4` varchar(400) NOT NULL,
  `address5` varchar(400) NOT NULL,
  `city5` varchar(400) NOT NULL,
  `state5` varchar(100) NOT NULL,
  `zip5` varchar(20) NOT NULL,
  `aname5` varchar(400) NOT NULL,
  `thisID` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `otheraddress`
--

INSERT INTO `otheraddress` VALUES ('434161829740','','','','','','','','','','','','','','','','','','','','','','','','','',''),('3355012879','','','','','','','','','','','','','','','','','','','','','','','','','',''),('245871613013','','','','','','','','','','','','','','','','','','','','','','','','','',''),('2193215301','','','','','','','','','','','','','','','','','','','','','','','','','',''),('515891029742','','','','','','','','','','','','','','','','','','','','','','','','','',''),('280820329810','','','','','','','','','','','','','','','','','','','','','','','','','',''),('384946129786','','','','','','','','','','','','','','','','','','','','','','','','','',''),('45802736360','','','','','','','','','','','','','','','','','','','','','','','','','',''),('27189017124','','','','','','','','','','','','','','','','','','','','','','','','','',''),('965471416853','','','','','','','','','','','','','','','','','','','','','','','','','',''),('193946414486','','','','','','','','','','','','','','','','','','','','','','','','','',''),('403586314482','','','','','','','','','','','','','','','','','','','','','','','','','',''),('801436215002','','','','','','','','','','','','','','','','','','','','','','','','','',''),('339983025225','','','','','','','','','','','','','','','','','','','','','','','','','',''),('15016412423','','','','','','','','','','','','','','','','','','','','','','','','','',''),('10471307683','','','','','','','','','','','','','','','','','','','','','','','','','',''),('91910267913','','','','','','','','','','','','','','','','','','','','','','','','','',''),('88271017965','','','','','','','','','','','','','','','','','','','','','','','','','',''),('513559413479','','','','','','','','','','','','','','','','','','','','','','','','','',''),('759238923396','','','','','','','','','','','','','','','','','','','','','','','','','',''),('462978819258','','','','','','','','','','','','','','','','','','','','','','','','','',''),('20175183327','','','','','','','','','','','','','','','','','','','','','','','','','',''),('99000583661','','','','','','','','','','','','','','','','','','','','','','','','','',''),('918529626431','','','','','','','','','','','','','','','','','','','','','','','','','',''),('768332928723','','','','','','','','','','','','','','','','','','','','','','','','','',''),('654950821411','','','','','','','','','','','','','','','','','','','','','','','','','',''),('84092203250','','','','','','','','','','','','','','','','','','','','','','','','','',''),('633873016698','','','','','','','','','','','','','','','','','','','','','','','','','',''),('504675316699','','','','','','','','','','','','','','','','','','','','','','','','','',''),('909979424967','','','','','','','','','','','','','','','','','','','','','','','','','',''),('592853825221','','','','','','','','','','','','','','','','','','','','','','','','','',''),('336775925328','','','','','','','','','','','','','','','','','','','','','','','','','',''),('97207347496','','','','','','','','','','','','','','','','','','','','','','','','','',''),('5674548537','','','','','','','','','','','','','','','','','','','','','','','','','',''),('371808921722','','','','','','','','','','','','','','','','','','','','','','','','','',''),('222591022100','','','','','','','','','','','','','','','','','','','','','','','','','',''),('78008022301','','','','','','','','','','','','','','','','','','','','','','','','','',''),('272051322517','','','','','','','','','','','','','','','','','','','','','','','','','',''),('446188128635','','','','','','','','','','','','','','','','','','','','','','','','','',''),('166996815024','','','','','','','','','','','','','','','','','','','','','','','','','',''),('65094576221','','','','','','','','','','','','','','','','','','','','','','','','','',''),('100065319123','','','','','','','','','','','','','','','','','','','','','','','','','',''),('82568567240','','','','','','','','','','','','','','','','','','','','','','','','','',''),('56428538514','','','','','','','','','','','','','','','','','','','','','','','','','',''),('523407714011','','','','','','','','','','','','','','','','','','','','','','','','','',''),('122896624750','test','test','KS','test','test','qwer','qwer','CT','qwer','qwer','','','','','','','','','','','','','','','',''),('556032812097','','','','','','','','','','','','','','','','','','','','','','','','','',''),('552928316805','','','','','','','','','','','','','','','','','','','','','','','','','',''),('59527716881','','','','','','','','','','','','','','','','','','','','','','','','','',''),('55375515545','','','','','','','','','','','','','','','','','','','','','','','','','',''),('68295285546','','','','','','','','','','','','','','','','','','','','','','','','','',''),('55375515547','','','','','','','','','','','','','','','','','','','','','','','','','',''),('3696435557','','','','','','','','','','','','','','','','','','','','','','','','','',''),('3696435559','','','','','','','','','','','','','','','','','','','','','','','','','',''),('16616205558','','','','','','','','','','','','','','','','','','','','','','','','','',''),('55375515561','','','','','','','','','','','','','','','','','','','','','','','','','',''),('55375515562','','','','','','','','','','','','','','','','','','','','','','','','','',''),('55375515563','','','','','','','','','','','','','','','','','','','','','','','','','',''),('92231486805','','','','','','','','','','','','','','','','','','','','','','','','','',''),('701897911054','','','','','','','','','','','','','','','','','','','','','','','','','',''),('156654011224','','','','','','','','','','','','','','','','','','','','','','','','','',''),('231606721759','','','','','','','','','','','','','','','','','','','','','','','','','',''),('253944521804','','','','','','','','','','','','','','','','','','','','','','','','','',''),('925724922694','','','','','','','','','','','','','','','','','','','','','','','','','',''),('151525629594','','','','','','','','','','','','','','','','','','','','','','','','','',''),('634734829670','','','','','','','','','','','','','','','','','','','','','','','','','',''),('316128929982','','','','','','','','','','','','','','','','','','','','','','','','','',''),('3756345165','','','','','','','','','','','','','','','','','','','','','','','','','',''),('99885355184','','','','','','','','','','','','','','','','','','','','','','','','','',''),('2730665228','','','','','','','','','','','','','','','','','','','','','','','','','',''),('876246117762','','','','','','','','','','','','','','','','','','','','','','','','','',''),('804650121790','','','','','','','','','','','','','','','','','','','','','','','','','',''),('369463824783','','','','','','','','','','','','','','','','','','','','','','','','','',''),('41833318322','8460 Dundee Terrace','Miami Lakes','FL','33016','Miami Lakes TownHouse','','','','','','','','','','','','','','','','','','','','',''),('630949028913','','','','','','','','','','','','','','','','','','','','','','','','','',''),('41759021666','','','','','','','','','','','','','','','','','','','','','','','','','',''),('47464623657','','','','','','','','','','','','','','','','','','','','','','','','','',''),('33465476196','','','','','','','','','','','','','','','','','','','','','','','','','',''),('17458891023','','','','','','','','','','','','','','','','','','','','','','','','','',''),('97028882372','','','','','','','','','','','','','','','','','','','','','','','','','',''),('37094962792','','','','','','','','','','','','','','','','','','','','','','','','','',''),('59682830373','6001 ROGER RD','SHAWNEE','KS','66203','Amanda Donley','','','','','','','','','','','','','','','','','','','','',''),('31108985177','','','','','','','','','','','','','','','','','','','','','','','','','',''),('588843730542','','','','','','','','','','','','','','','','','','','','','','','','','',''),('536722331213','','','','','','','','','','','','','','','','','','','','','','','','','',''),('321609222891','','','','','','','','','','','','','','','','','','','','','','','','','',''),('281550128270','2457 Collins Avenue apt 1703','Miami Beach','FL','33140','Jessica Caiafa','','','','','','','','','','','','','','','','','','','','',''),('12128237984','','','','','','','','','','','','','','','','','','','','','','','','','',''),('621313127207','','','','','','','','','','','','','','','','','','','','','','','','','',''),('485013128762','','','','','','','','','','','','','','','','','','','','','','','','','',''),('981783629078','','','','','','','','','','','','','','','','','','','','','','','','','',''),('658516023787','','','','','','','','','','','','','','','','','','','','','','','','','',''),('203759923798','','','','','','','','','','','','','','','','','','','','','','','','','',''),('72589045137','','','','','','','','','','','','','','','','','','','','','','','','','',''),('83004508108','','','','','','','','','','','','','','','','','','','','','','','','','',''),('747003211920','','','','','','','','','','','','','','','','','','','','','','','','','',''),('64602069609','','','','','','','','','','','','','','','','','','','','','','','','','',''),('595873025123','412 Astoria way','McDonough ','GA','30253','Ashley gordon','','','','','','','','','','','','','','','','','','','','',''),('954748319897','','','','','','','','','','','','','','','','','','','','','','','','','',''),('445050512658','10401 West Montgomery Road','Houston','TX','77088','Paradise Funeral Home','','','','','','','','','','','','','','','','','','','','',''),('8955865737','','','','','','','','','','','','','','','','','','','','','','','','','',''),('681019911482','','','','','','','','','','','','','','','','','','','','','','','','','',''),('681019911487','','','','','','','','','','','','','','','','','','','','','','','','','',''),('761346132152','','','','','','','','','','','','','','','','','','','','','','','','','',''),('89054387847','','','','','','','','','','','','','','','','','','','','','','','','','',''),('867816713709','','','','','','','','','','','','','','','','','','','','','','','','','',''),('98877723195','','','','','','','','','','','','','','','','','','','','','','','','','',''),('99690823235','','','','','','','','','','','','','','','','','','','','','','','','','',''),('74179544058','','','','','','','','','','','','','','','','','','','','','','','','','',''),('30521417255','','','','','','','','','','','','','','','','','','','','','','','','','',''),('15080262613','','','','','','','','','','','','','','','','','','','','','','','','','',''),('99983038162','','','','','','','','','','','','','','','','','','','','','','','','','',''),('69156626741','','','','','','','','','','','','','','','','','','','','','','','','','',''),('585213927015','12735 SW 32 terrace','Miami','FL','33175','Other Address','','','','','','','','','','','','','','','','','','','','',''),('90311416103','','','','','','','','','','','','','','','','','','','','','','','','','',''),('292290024181','','','','','','','','','','','','','','','','','','','','','','','','','',''),('459858414965','Apt 501','Miami','FL','33135-4920','987 SW 37th Ave. ','','','','','','','','','','','','','','','','','','','','',''),('523272213930','','','','','','','','','','','','','','','','','','','','','','','','','',''),('683198132545','','','','','','','','','','','','','','','','','','','','','','','','','',''),('786653917346','','','','','','','','','','','','','','','','','','','','','','','','','',''),('107344923442','','','','','','','','','','','','','','','','','','','','','','','','','',''),('9167811194','','','','','','','','','','','','','','','','','','','','','','','','','',''),('6565966190','','','','','','','','','','','','','','','','','','','','','','','','','',''),('893030914283','','','','','','','','','','','','','','','','','','','','','','','','','',''),('303605015604','','','','','','','','','','','','','','','','','','','','','','','','','',''),('976732913440','','','','','','','','','','','','','','','','','','','','','','','','','',''),('977724818386','','','','','','','','','','','','','','','','','','','','','','','','','',''),('2315795582','','','','','','','','','','','','','','','','','','','','','','','','','',''),('23241915890','','','','','','','','','','','','','','','','','','','','','','','','','',''),('45449319352','','','','','','','','','','','','','','','','','','','','','','','','','',''),('979738518359','','','','','','','','','','','','','','','','','','','','','','','','','',''),('786989925479','12101 Lima Rd','Fort Wayne','IN','46818','Mikki Shull','','','','','','','','','','','','','','','','','','','','',''),('862537330402','','','','','','','','','','','','','','','','','','','','','','','','','',''),('610335214052','','','','','','','','','','','','','','','','','','','','','','','','','',''),('22592527481','','','','','','','','','','','','','','','','','','','','','','','','','',''),('93753324798','1200 Villa Place, Suite 108 ','Nashville','TN',' 37212','American Threads Nashville','','','','','','','','','','','','','','','','','','','','',''),('92214796410','1350 Scenic Hwy #314','Snellville','GA','30078','American Threads Snellville ','','','','','','','','','','','','','','','','','','','','',''),('556317019944','Apt 20c','NYC','NY','10128','245 East 87th Street','','','','','','','','','','','','','','','','','','','','',''),('954599410544','','','','','','','','','','','','','','','','','','','','','','','','','',''),('969621527095','','','','','','','','','','','','','','','','','','','','','','','','','',''),('507594817315','346 Avenue B','Ronkonkoma','NY','11779','Cathy Hubner','','','','','','','','','','','','','','','','','','','','',''),('477308431658','725 American Ave Room 3704','Waukesha','WI','53186','Waukesha Memorial Hospital','','','','','','','','','','','','','','','','','','','','',''),('983246896','725 American Ave','Waukesha','WI','53186','Hospital','','','','','','','','','','','','','','','','','','','','',''),('539078933','','','','','','','','','','','','','','','','','','','','','','','','','',''),('308828411729','','','','','','','','','','','','','','','','','','','','','','','','','',''),('50433011735','','','','','','','','','','','','','','','','','','','','','','','','','',''),('209922032425','','','','','','','','','','','','','','','','','','','','','','','','','',''),('571873032594','8888 Elk Alley','Guthrie','OK','730444','Kelsie ','','','','','','','','','','','','','','','','','','','','',''),('889733918960','','','','','','','','','','','','','','','','','','','','','','','','','',''),('782550518269','','','','','','','','','','','','','','','','','','','','','','','','','',''),('485712611403','','','','','','','','','','','','','','','','','','','','','','','','','',''),('990521722795','','','','','','','','','','','','','','','','','','','','','','','','','',''),('88985783547','','','','','','','','','','','','','','','','','','','','','','','','','',''),('963307210909','','','','','','','','','','','','','','','','','','','','','','','','','',''),('980531830959','','','','','','','','','','','','','','','','','','','','','','','','','',''),('86214765799','','','','','','','','','','','','','','','','','','','','','','','','','',''),('8288974852','','','','','','','','','','','','','','','','','','','','','','','','','',''),('62954914677','','','','','','','','','','','','','','','','','','','','','','','','','',''),('758655314159','','','','','','','','','','','','','','','','','','','','','','','','','',''),('58607566625','','','','','','','','','','','','','','','','','','','','','','','','','',''),('703788326125','','','','','','','','','','','','','','','','','','','','','','','','','',''),('17843123951','','','','','','','','','','','','','','','','','','','','','','','','','',''),('154608823096','','','','','','','','','','','','','','','','','','','','','','','','','',''),('522675023801','','','','','','','','','','','','','','','','','','','','','','','','','',''),('78236519659','','','','','','','','','','','','','','','','','','','','','','','','','',''),('16995819660','','','','','','','','','','','','','','','','','','','','','','','','','',''),('919271218088','','','','','','','','','','','','','','','','','','','','','','','','','',''),('110756830431','','','','','','','','','','','','','','','','','','','','','','','','','',''),('309313630328','','','','','','','','','','','','','','','','','','','','','','','','','',''),('79938494690','','','','','','','','','','','','','','','','','','','','','','','','','',''),('712103010422','','','','','','','','','','','','','','','','','','','','','','','','','',''),('200431421255','','','','','','','','','','','','','','','','','','','','','','','','','',''),('834854828255','','','','','','','','','','','','','','','','','','','','','','','','','',''),('59090795925','','','','','','','','','','','','','','','','','','','','','','','','','',''),('48422728761','','','','','','','','','','','','','','','','','','','','','','','','','',''),('464999914066','','','','','','','','','','','','','','','','','','','','','','','','','',''),('987756820187','','','','','','','','','','','','','','','','','','','','','','','','','',''),('356551319172','','','','','','','','','','','','','','','','','','','','','','','','','',''),('253885121135','','','','','','','','','','','','','','','','','','','','','','','','','',''),('866270324579','550 Rte 1 and 9 S','Newark','NJ','07114','Wyndham Garden Hotel Newark Airport','','','','','','','','','','','','','','','','','','','','',''),('246471327','','','','','','','','','','','','','','','','','','','','','','','','','',''),('1368909684','','','','','','','','','','','','','','','','','','','','','','','','','',''),('23675437817','','','','','','','','','','','','','','','','','','','','','','','','','',''),('83391536528','','','','','','','','','','','','','','','','','','','','','','','','','',''),('21638006565','','Santa Clarita','CA','91350','22624 Cardiff Drive','','','','','','','','','','','','','','','','','','','','',''),('49369055284','','','','','','','','','','','','','','','','','','','','','','','','','',''),('86004669547','','','','','','','','','','','','','','','','','','','','','','','','','',''),('905734624908','','','','','','','','','','','','','','','','','','','','','','','','','',''),('377673423776','','','','','','','','','','','','','','','','','','','','','','','','','',''),('664977229431','','','','','','','','','','','','','','','','','','','','','','','','','',''),('62081047536','118 Vivion Drive','Aiken','SC','29803','Linda Hunley','','','','','','','','','','','','','','','','','','','','',''),('13365368663','1911 hallman st ne','atlanta','GA','30317','Jennie Gray Mulligan','','','','','','','','','','','','','','','','','','','','',''),('330207121204','591 Piping Plover Lane','Kiawah island','SC','29455','Kiawah','','','','','','','','','','','','','','','','','','','','',''),('584742024517','','','','','','','','','','','','','','','','','','','','','','','','','',''),('59676410581','','','','','','','','','','','','','','','','','','','','','','','','','',''),('758031431324','','','','','','','','','','','','','','','','','','','','','','','','','',''),('20579915550','','','','','','','','','','','','','','','','','','','','','','','','','',''),('60424829848','','','','','','','','','','','','','','','','','','','','','','','','','',''),('697546811716','','','','','','','','','','','','','','','','','','','','','','','','','',''),('641274623941','','','','','','','','','','','','','','','','','','','','','','','','','',''),('979740726861','','','','','','','','','','','','','','','','','','','','','','','','','',''),('648665017127','2717 Locust Grove Rd.','Bonnieville','KY','42713','Venita Nunn','','','','','','','','','','','','','','','','','','','','',''),('369817429407','','','','','','','','','','','','','','','','','','','','','','','','','',''),('18266408513','1715 Clearbrook Lane','Corsicana, TX','TX','75110','Rose Home','','','','','','','','','','','','','','','','','','','','',''),('74990199989','15 Park Lane','Galveston','TX','77551','Kathy Home','','','','','','','','','','','','','','','','','','','','',''),('63600133680','','','','','','','','','','','','','','','','','','','','','','','','','',''),('10925327521','','','','','','','','','','','','','','','','','','','','','','','','','',''),('947026828477','2800 Milford Sq Pike','Quakertown','PA','18951','Lancer Systems','','','','','','','','','','','','','','','','','','','','',''),('89788039822','','','','','','','','','','','','','','','','','','','','','','','','','',''),('29135892267','','','','','','','','','','','','','','','','','','','','','','','','','',''),('3546930384','','','','','','','','','','','','','','','','','','','','','','','','','',''),('180420620091','','','','','','','','','','','','','','','','','','','','','','','','','',''),('613036713764','656 gfhfh','hgfhf','CA','90755','tyryry yrytr','','','','','','','','','','','','','','','','','','','','',''),('148884330909','2416 capstone ct','Columbus','GA','31909','Other Address','2416 capstone ct','Columbus','GA','31909','River town pediactrics','','','','','','','','','','','','','','','',''),('598934610957','Hartford Hospital','Hartford','CT','06106','Hartford Hospital','','','','','','','','','','','','','','','','','','','','',''),('6759312469','','','','','','','','','','','','','','','','','','','','','','','','','',''),('768040513527','15308 Riviera Shores Drive','Holly','MI','48442','Mom','','','','','','','','','','','','','','','','','','','','',''),('525523913737','Forest Pk E. Cemetary, 3700 St Vincent Ave., Sect 32, lot 299','Shreveport','LA','71103','Forest Park East Cemetary','','','','','','','','','','','','','','','','','','','','',''),('329797132766','','','','','','','','','','','','','','','','','','','','','','','','','',''),('565413627244','','','','','','','','','','','','','','','','','','','','','','','','','',''),('440136824898','','','','','','','','','','','','','','','','','','','','','','','','','',''),('57830111617','','','','','','','','','','','','','','','','','','','','','','','','','',''),('130843815814','','','','','','','','','','','','','','','','','','','','','','','','','',''),('601646531852','','','','','','','','','','','','','','','','','','','','','','','','','',''),('879026817585','','','','','','','','','','','','','','','','','','','','','','','','','',''),('18496808562','','','','','','','','','','','','','','','','','','','','','','','','','',''),('82119309350','7520 Coral Creek Street','Beaumont','TX','77707','Helens','','','','','','','','','','','','','','','','','','','','',''),('82119309351','7520 Coral Creek Street','Beaumont ','TX','77707','Helen\'s ','','','','','','','','','','','','','','','','','','','','',''),('248304330625','','','','','','','','','','','','','','','','','','','','','','','','','',''),('664350530641','7520 Coral Creek Street','Beaumont','TX','77707','Helen\'s','','','','','','','','','','','','','','','','','','','','',''),('987924827305','','','','','','','','','','','','','','','','','','','','','','','','','',''),('626483721586','','','','','','','','','','','','','','','','','','','','','','','','','',''),('68991325907','','','','','','','','','','','','','','','','','','','','','','','','','',''),('929027912675','','','','','','','','','','','','','','','','','','','','','','','','','',''),('605118715629','','','','','','','','','','','','','','','','','','','','','','','','','',''),('141019621845','','','','','','','','','','','','','','','','','','','','','','','','','',''),('143662323362','','','','','','','','','','','','','','','','','','','','','','','','','',''),('164077421500','','','','','','','','','','','','','','','','','','','','','','','','','',''),('27739311160','','','','','','','','','','','','','','','','','','','','','','','','','',''),('67573651357','','','','','','','','','','','','','','','','','','','','','','','','','',''),('85598118329','','','','','','','','','','','','','','','','','','','','','','','','','',''),('370592711648','Apt 13','Laredo','TX','78045','421 hilltop ','','','','','','','','','','','','','','','','','','','','',''),('556996213340','','','','','','','','','','','','','','','','','','','','','','','','','',''),('84537214308','','','','','','','','','','','','','','','','','','','','','','','','','',''),('73641128425','45 Raintree Circle','Groton','CT','06340','House','','','','','','','','','','','','','','','','','','','','',''),('232113619737','20824 Spence road','Salinas','CA','93908','Where you are','','','','','','','','','','','','','','','','','','','','',''),('528548026064','','','','','','','','','','','','','','','','','','','','','','','','','',''),('939332312326','','','','','','','','','','','','','','','','','','','','','','','','','',''),('91014773430','','','','','','','','','','','','','','','','','','','','','','','','','',''),('52733831813','140 Westwich Street','Danville','CA','94506','IF','','','','','','','','','','','','','','','','','','','','',''),('795319629555','','','','','','','','','','','','','','','','','','','','','','','','','',''),('87130322302','292 Parkchester Road','Elk Grove Village','IL','60007','Grandma','','','','','','','','','','','','','','','','','','','','',''),('78596148688','16047 Hwy J','Bowling Green','MO','63334','Christine Zummo','','','','','','','','','','','','','','','','','','','','',''),('78596148689','','','','','','','','','','','','','','','','','','','','','','','','','',''),('92006582601','3420 Yamparika St','Vernon','TX','76384','Sam Petty','','','','','','','','','','','','','','','','','','','','',''),('463570110113','','','','','','','','','','','','','','','','','','','','','','','','','',''),('341754632134','','','','','','','','','','','','','','','','','','','','','','','','','',''),('29444356533','','','','','','','','','','','','','','','','','','','','','','','','','',''),('488634421869','','','','','','','','','','','','','','','','','','','','','','','','','',''),('18343222287','','','','','','','','','','','','','','','','','','','','','','','','','',''),('875942120312','','','','','','','','','','','','','','','','','','','','','','','','','',''),('431079615850','','','','','','','','','','','','','','','','','','','','','','','','','',''),('112534027713','','','','','','','','','','','','','','','','','','','','','','','','','',''),('75856664177','1354 East Worthsville Road','Greenwood','IN','46143','Clark Pleasant Middle School','','','','','','','','','','','','','','','','','','','','',''),('735426629003','','','','','','','','','','','','','','','','','','','','','','','','','',''),('213722510110','1900 n main st','Findlay','OH','45840','Blanchard valley hospital','','','','','','','','','','','','','','','','','','','','',''),('980289032046','','','','','','','','','','','','','','','','','','','','','','','','','',''),('683472932745','','','','','','','','','','','','','','','','','','','','','','','','','',''),('1261307309','','','','','','','','','','','','','','','','','','','','','','','','','',''),('36237795020','','','','','','','','','','','','','','','','','','','','','','','','','',''),('867991415697','','','','','','','','','','','','','','','','','','','','','','','','','',''),('997773524316','','','','','','','','','','','','','','','','','','','','','','','','','',''),('157459615802','','','','','','','','','','','','','','','','','','','','','','','','','',''),('1476829512','','','','','','','','','','','','','','','','','','','','','','','','','',''),('298955529801','','','','','','','','','','','','','','','','','','','','','','','','','',''),('474163217785','','','','','','','','','','','','','','','','','','','','','','','','','',''),('278680428804','','','','','','','','','','','','','','','','','','','','','','','','','',''),('70626063618','','','','','','','','','','','','','','','','','','','','','','','','','',''),('37511526458','','','','','','','','','','','','','','','','','','','','','','','','','',''),('962979616363','','','','','','','','','','','','','','','','','','','','','','','','','',''),('375165310236','','','','','','','','','','','','','','','','','','','','','','','','','',''),('8912515864','','','','','','','','','','','','','','','','','','','','','','','','','',''),('68263926480','','','','','','','','','','','','','','','','','','','','','','','','','',''),('82224244190','','','','','','','','','','','','','','','','','','','','','','','','','',''),('98736048097','','','','','','','','','','','','','','','','','','','','','','','','','',''),('389630720259','','','','','','','','','','','','','','','','','','','','','','','','','',''),('23783878508','','','','','','','','','','','','','','','','','','','','','','','','','',''),('72897704138','','','','','','','','','','','','','','','','','','','','','','','','','',''),('48517888854','18043 W Desert Lane','Surprise','AZ','85388','Ciarra Butler','','','','','','','','','','','','','','','','','','','','',''),('911550520885','701 sumerset park drive','Leesburg','VA','20175','Apartment 303','','','','','','','','','','','','','','','','','','','','',''),('986017928626','','','','','','','','','','','','','','','','','','','','','','','','','',''),('716269825323','','','','','','','','','','','','','','','','','','','','','','','','','',''),('822290432186','1514  W rivershore way','Tampa ','FL','33603','Mom','','','','','','','','','','','','','','','','','','','','',''),('71423231903','1514 W rivershore way','Tampa ','FL','33603','Tia','','','','','','','','','','','','','','','','','','','','',''),('38601262861','','','','','','','','','','','','','','','','','','','','','','','','','',''),('22323342864','','','','','','','','','','','','','','','','','','','','','','','','','',''),('38601262862','1514 W rivershore way','Tampa','FL','33603','My baby brother ','','','','','','','','','','','','','','','','','','','','',''),('31884962869','','','','','','','','','','','','','','','','','','','','','','','','','',''),('51521032854','','','','','','','','','','','','','','','','','','','','','','','','','',''),('85172834885','','','','','','','','','','','','','','','','','','','','','','','','','',''),('571839313692','','','','','','','','','','','','','','','','','','','','','','','','','',''),('23751257813','','','','','','','','','','','','','','','','','','','','','','','','','',''),('98375219713','','','','','','','','','','','','','','','','','','','','','','','','','',''),('76786356295','110 island dr','key biscayne','FL','33149','Gabi\'s House','','','','','','','','','','','','','','','','','','','','',''),('26475386604','','','','','','','','','','','','','','','','','','','','','','','','','',''),('347315319434','','','','','','','','','','','','','','','','','','','','','','','','','',''),('985053425368','215 W Douglas ','Princeville ','IL','61559','Katie Home ','','','','','','','','','','','','','','','','','','','','',''),('928120522914','23102 S Hwy 99E','Canby','OR','97013','Grandma Home','','','','','','','','','','','','','','','','','','','','',''),('888466627170','','','','','','','','','','','','','','','','','','','','','','','','','',''),('766102129551','400 West 30th Street','Los Angeles, CA','CA','90007','Day Work','','','','','','','','','','','','','','','','','','','','',''),('429426822579','','','','','','','','','','','','','','','','','','','','','','','','','',''),('774961420991','','','','','','','','','','','','','','','','','','','','','','','','','',''),('35309021990','','','','','','','','','','','','','','','','','','','','','','','','','',''),('907030526003','113 Kilsyth Road Apartment 5','Brighton','MA','02135','Emily\'s Apartment','','','','','','','','','','','','','','','','','','','','',''),('78177948300','3894 Juniata Gap Road','Altoona','PA','16601','Home Address','','','','','Other Address','','','','','','','','','','','','','','','',''),('384229012126','','','','','','','','','','','','','','','','','','','','','','','','','',''),('9496568627','','','','','','','','','','','','','','','','','','','','','','','','','',''),('792899026066','','','','','','','','','','','','','','','','','','','','','','','','','',''),('277137120933','','','','','','','','','','','','','','','','','','','','','','','','','',''),('182894530006','','','','','','','','','','','','','','','','','','','','','','','','','',''),('526649227250','9057 e mississippi ave apt 21-103','Denver','CO','80247','Darna','','','','','','','','','','','','','','','','','','','','',''),('398976027875','','','','','','','','','','','','','','','','','','','','','','','','','',''),('72121864869','','','','','','','','','','','','','','','','','','','','','','','','','',''),('79191051359','','','','','','','','','','','','','','','','','','','','','','','','','',''),('40261433152','','','','','','','','','','','','','','','','','','','','','','','','','','');

--
-- Table structure for table `otherdates`
--

CREATE TABLE `otherdates` (
  `profileID` varchar(50) NOT NULL,
  `fecha1` date NOT NULL,
  `name1` varchar(400) NOT NULL,
  `fecha2` date NOT NULL,
  `name2` varchar(400) NOT NULL,
  `fecha3` date NOT NULL,
  `name3` varchar(400) NOT NULL,
  `fecha4` date NOT NULL,
  `name4` varchar(400) NOT NULL,
  `fecha5` date NOT NULL,
  `name5` varchar(400) NOT NULL,
  `dateID` varchar(40) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `otherdates`
--

INSERT INTO `otherdates` VALUES ('434161829740','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('3355012879','2016-02-13','Valentine\'s Day (Friday before)','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('245871613013','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('2193215301','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('515891029742','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('280820329810','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('384946129786','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('45802736360','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('27189017124','2014-08-06','Just Because','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('965471416853','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('193946414486','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('403586314482','2015-02-13','Feb 13th','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('801436215002','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('339983025225','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('15016412423','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('10471307683','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('91910267913','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('88271017965','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('513559413479','2014-08-21','yyry','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('759238923396','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('462978819258','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('20175183327','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('99000583661','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('918529626431','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('768332928723','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('654950821411','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('84092203250','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('633873016698','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('504675316699','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('909979424967','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('592853825221','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('336775925328','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('97207347496','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('5674548537','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('371808921722','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('222591022100','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('78008022301','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('272051322517','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('446188128635','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('166996815024','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('65094576221','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('100065319123','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('82568567240','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('56428538514','2015-01-01','','2014-01-01','','2014-01-01','','0000-00-00','','0000-00-00','',''),('523407714011','2015-01-28','Test','2015-01-13','Test2','2015-01-13','extra','2015-01-13','Test','2015-01-27','test',''),('122896624750','2015-01-13','Test','2015-01-26','Test2','2015-01-13','test3','2015-01-13','test4','2015-01-19','qwer',''),('556032812097','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('552928316805','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('59527716881','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('55375515545','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('68295285546','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('55375515547','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('3696435557','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('3696435559','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('16616205558','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('55375515561','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('55375515562','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('55375515563','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('92231486805','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('701897911054','2015-01-29','test','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('156654011224','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('231606721759','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('253944521804','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('925724922694','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('151525629594','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('634734829670','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('316128929982','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('3756345165','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('99885355184','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('2730665228','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('876246117762','2015-02-20','Just Because','2015-02-21','Just Because II','0000-00-00','','0000-00-00','','0000-00-00','',''),('804650121790','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('369463824783','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('41833318322','2015-02-13','Valintines Day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('630949028913','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('41759021666','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('47464623657','2015-02-20','Just Because','2015-02-21','Just Because II','2015-02-13','Feb 13th','0000-00-00','','0000-00-00','',''),('33465476196','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('17458891023','2015-02-09','TEst date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('97028882372','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('37094962792','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('59682830373','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('31108985177','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('588843730542','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('536722331213','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('321609222891','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('281550128270','2016-09-01','just because','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('12128237984','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('621313127207','2015-02-12','Valentine','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('485013128762','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('981783629078','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('658516023787','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('203759923798','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('72589045137','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('83004508108','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('747003211920','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('64602069609','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('595873025123','2015-02-13','Morning','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('954748319897','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('445050512658','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('8955865737','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('681019911482','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('681019911487','0000-00-00','Today','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('761346132152','2016-02-14','Valentines Day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('89054387847','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('867816713709','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('98877723195','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('99690823235','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('74179544058','2015-04-06','Why Not','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('30521417255','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('15080262613','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('99983038162','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('69156626741','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('585213927015','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('90311416103','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('292290024181','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('459858414965','2015-08-08','Today','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('523272213930','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('683198132545','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('786653917346','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('107344923442','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('9167811194','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('6565966190','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('893030914283','2016-10-31','Christmas','2016-05-08','Mothers Day','0000-00-00','','0000-00-00','','0000-00-00','',''),('303605015604','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('976732913440','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('977724818386','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('2315795582','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('23241915890','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('45449319352','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('979738518359','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('786989925479','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('862537330402','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('610335214052','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('22592527481','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('93753324798','2016-07-04','Amy Thomas','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('92214796410','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('556317019944','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('954599410544','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('969621527095','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('507594817315','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('477308431658','2016-08-12','New Baby','2016-08-12','Congratulations','0000-00-00','','0000-00-00','','0000-00-00','',''),('983246896','2016-08-12','Other Date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('539078933','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('308828411729','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('50433011735','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('209922032425','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('571873032594','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('889733918960','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('782550518269','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('485712611403','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('990521722795','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('88985783547','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('963307210909','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('980531830959','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('86214765799','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('8288974852','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('62954914677','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('758655314159','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('58607566625','2017-02-22','February 8','2017-03-22','March 8','2017-04-19','April 5','0000-00-00','','0000-00-00','',''),('703788326125','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('17843123951','0000-00-00','4/10/2017','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('154608823096','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('522675023801','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('78236519659','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('16995819660','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('919271218088','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('110756830431','2017-03-08','Monthly','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('309313630328','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('79938494690','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('712103010422','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('200431421255','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('834854828255','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('59090795925','2017-03-16','Borthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('48422728761','2017-03-27','Rosie Bledsoe','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('464999914066','2017-03-27','Mr. Calderone & Family','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('987756820187','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('356551319172','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('253885121135','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('866270324579','2017-04-26','April 26th, 2017','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('246471327','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('1368909684','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('23675437817','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('83391536528','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('21638006565','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('49369055284','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('86004669547','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('905734624908','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('377673423776','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('664977229431','2017-05-14','Missing me date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('62081047536','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('13365368663','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('330207121204','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('584742024517','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('59676410581','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('758031431324','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('20579915550','2017-05-13','mothers daya','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('60424829848','2017-05-13','motherz day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('697546811716','2017-05-13','motherz day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('641274623941','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('979740726861','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('648665017127','2017-05-12','Venita Nunn','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('369817429407','2017-05-13','Other Date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('18266408513','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('74990199989','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('63600133680','2017-05-14','Other Date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('10925327521','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('947026828477','2017-06-01','Anniversary','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('89788039822','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('29135892267','2017-07-01','Wedding date','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('3546930384','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('180420620091','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('613036713764','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('148884330909','2017-06-10','Just cuz','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('598934610957','2017-06-14','Get Better â¤ï¸','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('6759312469','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('768040513527','2018-05-09','Mom\'s Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('525523913737','2018-05-25','Memorial Day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('329797132766','2017-10-10','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('565413627244','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('440136824898','2017-06-12','06/12/2017','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('57830111617','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('130843815814','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('601646531852','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('879026817585','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('18496808562','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('82119309350','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('82119309351','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('248304330625','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('664350530641','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('987924827305','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('626483721586','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('68991325907','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('929027912675','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('605118715629','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('141019621845','2017-08-13',' ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('143662323362','2017-08-13','Wedding Day','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('164077421500','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('27739311160','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('67573651357','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('85598118329','2017-08-13','Just because','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('370592711648','0000-00-00','Engagement','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('556996213340','2017-08-16','Engagement','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('84537214308','2017-08-16','engagement','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('73641128425','2017-09-22','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('232113619737','2017-08-19','Be happy','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('528548026064','2017-08-29','Tuesday BM','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('939332312326','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('91014773430','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('52733831813','2017-08-24','Just Because -you nailed it','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('795319629555','2017-08-31','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('87130322302','2017-09-01','Just Because (September)','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('78596148688','2017-08-27','James','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('78596148689','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('92006582601','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('463570110113','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('341754632134','2017-09-20','Pre-birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('29444356533','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('488634421869','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('18343222287','2017-10-02','Thinking of you','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('875942120312','2017-11-14','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('431079615850','2017-12-08','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('112534027713','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('75856664177','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('735426629003','2017-09-28','5-Month Anniversary ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('213722510110','2017-10-02','Congratulations','2017-10-02','Other Date','0000-00-00','','0000-00-00','','0000-00-00','',''),('980289032046','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('683472932745','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('1261307309','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('36237795020','2017-10-11','sorry','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('867991415697','2017-10-27','Ranger School Separation','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('997773524316','2017-10-24','Happy Birthday ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('157459615802','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('1476829512','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('298955529801','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('474163217785','2017-11-02','Happy birthday ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('278680428804','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('70626063618','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('37511526458','2017-11-07','Just because','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('962979616363','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('375165310236','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('8912515864','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('68263926480','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('82224244190','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('98736048097','2017-12-08','We will miss you','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('389630720259','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('23783878508','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('72897704138','2017-12-03','Sunday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('48517888854','2017-12-29','Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('911550520885','0000-00-00','Anniversary ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('986017928626','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('716269825323','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('822290432186','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('71423231903','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('38601262861','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('22323342864','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('38601262862','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('31884962869','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('51521032854','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('85172834885','2018-06-15','Nathan Ruth','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('571839313692','0000-00-00','Sara ','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('23751257813','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('98375219713','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('76786356295','2018-02-12','gabi\'s bday!','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('26475386604','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('347315319434','2018-01-11','January','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('985053425368','2018-01-31','Rodanniversary','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('928120522914','2018-10-21','Eva Birthday','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('888466627170','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('766102129551','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('429426822579','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('774961420991','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('35309021990','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('907030526003','2018-01-19','I love you!','2018-01-19','Other Date','0000-00-00','','0000-00-00','','0000-00-00','',''),('78177948300','2018-01-26','Thought of you','0000-00-00','Other Date','0000-00-00','','0000-00-00','','0000-00-00','',''),('384229012126','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('9496568627','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('792899026066','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('277137120933','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('182894530006','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('526649227250','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('398976027875','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('72121864869','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('79191051359','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','',''),('40261433152','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','0000-00-00','','');

--
-- Table structure for table `placedorder`
--

CREATE TABLE `placedorder` (
  `orderID` varchar(30) NOT NULL,
  `fecha` datetime NOT NULL,
  PRIMARY KEY (`orderID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `placedorder`
--

INSERT INTO `placedorder` VALUES ('o_668145918993','2015-08-13 22:53:25');

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `name` varchar(200) NOT NULL,
  `standardimage` varchar(300) NOT NULL,
  `itemNumber` varchar(100) NOT NULL,
  `deluxeimage` varchar(300) NOT NULL,
  `occasion` varchar(100) NOT NULL,
  `holidays` varchar(100) NOT NULL,
  `retail` float NOT NULL,
  `price` float NOT NULL,
  `info` text NOT NULL,
  `includes` varchar(500) NOT NULL,
  `dimensions` varchar(50) NOT NULL,
  `premiumimage` varchar(300) NOT NULL,
  `deluxeRetail` float NOT NULL,
  `deluxePrice` float NOT NULL,
  `premiumRetail` float NOT NULL,
  `premiumPrice` float NOT NULL,
  `color` varchar(100) NOT NULL,
  PRIMARY KEY (`itemNumber`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product`
--

INSERT INTO `product` VALUES ('Enchanted Journey','t10-2.jpg','t10-2','blankFlowerImage.png','Anniversary','Anniversary',57.95,47.95,'<p><span id=\"docs-internal-guid-95219994-94c9-fb64-bd3e-00dc028c2092\">A fairy tale of flowers! Send this whimsical, feminine bouquet to your very own princess - or anyone you especially adore. Beautiful hydrangea, fragrant roses and delicate statice in a modern purple vase ensure your lucky recipient will live happily ever after!</span></p>','Roses|Hydrangeas|Carnations|Assorted',' 9\" W x 9\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95,'Assorted'),('Blushing Beauty','t10-3.jpg','t10-3','blankFlowerImage.png','Anniversary','Valentine\'s Day',64.95,54.95,'<p><span id=\"docs-internal-guid-95219994-958e-0a24-ec3f-3d36af6d5566\">Sometimes all she needs is a little pink me up! An ideal pick for anyone whose favorite color is pink, this stylish mix is full of variety and comes presented in a clear glass bubble bowl she\'ll use again and again.</span></p>','Roses|Lillies|Gerberas|Carnations|Assorted','13 1/4\" W x 14 1/2\" H','blankFlowerImage.png',74.95,64.95,84.95,74.95,'Assorted'),('Wonderous Wishes','t11-1.jpg','t11-1','t11-1_d.jpg','Anniversary','Anniversary',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-95a7-8120-bdea-b67d300550a5\"></span><span id=\"docs-internal-guid-95219994-95a7-8120-bdea-b67d300550a5\">Featuring a wide, wondrous assortment of blooms in one bouquet, this colorful arrangement is always a favorite! Hydrangea, roses, lilies, alstroemeria, gerberas, daisies - they\'re all here in stunning variety.</span></p>','Roses|Lillies|Daisies|Hydrangeas|Gerberas|Assorted','14 1/2\" W x 17\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95,'Assorted'),('Precious Pink Tulips','T11Z106.jpeg','T11Z106','blankFlowerImage.png','Other','Holiday Best Sellers',42.95,32.95,'<p dir=\"ltr\">Beautiful and \"simply said\" light pink tulips are a hip way to show you care.</p>','Tulips','12\" W x 14\" H','blankFlowerImage.png',72.95,62.95,102.95,92.95,'Purple'),('Winter Romance','t128-2.jpeg','t128-2','t128-2_d.jpeg','Holiday','Holiday Best Sellers',49.95,39.95,'<p>&nbsp;Send your love this holiday season with vibrant red roses, snow white lilies and playful daises!</p>','Roses|Lillies|Daisies|Carnations|Assorted','15\" W x 18\" H','t128-2_p.jpeg',59.95,49.95,69.95,59.95,'Assorted'),('Happy Day Tulips','t140-1.jpg','t140-1','t140-1_d.jpg','Other','Mother\'s Day',42.95,32.95,'<p><span id=\"docs-internal-guid-95219994-a53d-976a-faa1-bc6adf100b1c\">Sunny yellow tulips are a sure sign of spring. Even if the weather is not cooperating, you can be sure the person who receives this bright bouquet will feel the warmth of your message.</span></p>','Tulips','12 1/2\" W x 14 3/4\" H','blankFlowerImage.png',72.95,62.95,102.95,92.95,'Yellow'),('Lily Sunshine','t140-2.jpeg','t140-2','t140-2_d.jpg','Other','',57.95,47.95,'<p dir=\"ltr\">When it comes to spring flowers, the lily reigns supreme. It\'s easy to see why in this gorgeous bouquet of bright yellow blooms.</p>','Lillies','16 1/4\" W x 20 1/4\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95,'Yellow'),('Spring Waltz','t141-1.jpeg','t141-1','t141-1_d.jpeg','Other','Mother\'s Day',82.95,72.95,'<p>Dance into spring! Send this feminine bouquet of favorite spring flowers to brighten someone\'s home with the playful beauty of nature. Such a pretty way to say, \"I\'m thinking of you!\"</p>','Roses|Tulips|Lillies|Assorted|Other','17 1/2\" W x 20\" H','blankFlowerImage.png',92.95,82.95,102.95,92.95,'Assorted'),('Spring\'s First Kiss','t142-1.jpeg','t142-1','blankFlowerImage.png','Other','',67.95,57.95,'<p><span id=\"docs-internal-guid-95219994-a56a-8a5c-c97e-52b80297e68d\">Blooms this beautiful don\'t need decoration! Fifteen tantalizing tulips in soft spring colors make a thrilling thank you gift or sweet and innocent reminder of your love or friendship.</span></p>','Tulips','14\" W x 17\" H','blankFlowerImage.png',77.95,67.95,87.95,77.95,'Assorted'),('Birthday Blooms','t147-1.jpeg','t147-1','t147-1_d.jpeg','Birthday','Holiday Best Sellers',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-a56c-98f5-6f37-47d0ba04d267\">A warm terra-cotta pot showcasing vibrant roses and tulips is sure to bring lots of smiles!</span></p>','Roses|Tulips|Carnations|Assorted','10\" W x 9 1/2\" H','t147-1_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Blooming Birthday','t15-1.jpeg','t15-1','t15-1_d.jpeg','Birthday','Birthday',49.95,39.95,'<p>&nbsp;Fun and festive, this arrangement is blooming with colorful roses, carnations and Gerberas!</p>\r\n<p dir=\"ltr\">&nbsp;</p>','Roses|Gerberas|Carnations|Assorted|Other','17\" W x 13 1/2\" H','t15-1_p.jpeg',59.95,49.95,69.95,59.95,'Assorted'),('Sunny Sunflowers','t152-2.jpg','t152-2','t152-2_d.jpg','Birthday','Birthday',44.95,34.95,'<p><span id=\"docs-internal-guid-95219994-a544-d6af-ad4c-ba094c2cbaa4\">Brighten up a table, send get well wishes, or simply sprinkle sunshine on someone\'s day with this summer flower arrangement. Bold sunflowers are arranged in a glass bubble bowl with curly willow curled inside.</span></p>','Sunflowers','12\" W x 10\" H','blankFlowerImage.png',54.95,44.95,64.95,54.95,'Yellow'),('It\'s My Party','t173-1.jpeg','t173-1','t173-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">Rich jewel-toned flowers are arranged in a chic plum colored cube vase for a gift that\'s truly memorable. The modern, feminine composition is sweet without being too romantic, making it a great choice for sisters, mothers and friends.</p>','Roses|Daisies|Gerberas|Assorted|Other','10 1/2\" W x 12\" H','t173-1_p.jpeg',59.95,49.95,69.95,59.95,'Assorted'),('Pretty Pink Present','t19-1.jpeg','t19-1','t19-1_d.jpeg','Birthday','Birthday',49.95,39.95,'<p dir=\"ltr\">Guaranteed to get a birthday smile! Surprise someone special with our pink gift box that\'s tied up with a polka-dotted green bow and packed with bountiful blooms. It\'s the perfect pink-themed pick!</p>','Roses|Lillies|Assorted|Other','12 3/4\" W x 12\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Brilliant Birthday Bliss','t21-1.jpeg','t21-1','t21-1_d.jpeg','Birthday','Birthday',72.95,62.95,'<p dir=\"ltr\">Pure pretty! This classic floral design puts a romantic spin on your birthday wishes in soft shades of pink and yellow. Presented in an antique-style vase, the traditional bouquet is finished with a fun mylar balloon.</p>','Roses|Gerberas|Assorted|Other','17\" W x 19\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95,'Assorted'),('Sweet Surprise','t37-1.jpeg','t37-1','t37-1_d.jpeg','Maternity/Birth','',39.95,29.95,'<p dir=\"ltr\">Sweet as candy! This soft pink and white bouquet is a feminine choice for any occasion.</p>','Roses|Carnations|Assorted|Other','13\" W x 14 1/2\" H','t37-1_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Make Me Blush','t4-1.jpg','t4-1','t4-1_d.jpg','Anniversary','Valentine\'s Day',72.95,62.95,'<p dir=\"ltr\">Blushing pink roses and delicate white limonium add up to a feminine arrangement that\'s at once sweet and innocent - and fabulously flirty!</p>','Roses','17 1/2\" W x 20 1/2\" H','blankFlowerImage.png',92.95,82.95,112.95,102.95,'Purple'),('Rose Garden Romance','t400-2.jpg','t400-2','t400-2_d.jpg','Anniversary','Valentine\'s Day',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-a561-ebcd-01d4-830c53fc0e46\">Sing her a love song - with flowers. This lush, loving rose arrangement tells her just how much you care.</span></p>','Roses','10 1/2\" W x 11\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95,'Assorted'),('Pretty In Pink','t404-1.jpg','t404-1','t404-1_d.jpg','Other','',52.95,42.95,'<p><span id=\"docs-internal-guid-95219994-a565-c3fb-db20-b1072b41bf8a\">Nothing\'s too sweet for the sweetest woman in the world. Surprise her with a delightfully dainty bouquet featuring delicate lavender roses and pink hydrangea in a sparkling silver cube vase. You\'ll make her day, her week, her month!</span></p>','Roses|Hydrangeas|Assorted','11\" W x 11 3/4\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95,'Purple'),('So Pretty','t404-2.jpeg','t404-2','t404-2_d.jpeg','Other','',62.95,52.95,'<p dir=\"ltr\">It\'s like sunshine and moonlight in are gloriously happy gift! Soft yellow roses, white hydrangea and other favorites showcased in a dazzling Silver Reflections vase. She\'ll love it - and so will her envious friends.</p>','Roses|Hydrangeas|Assorted','11 1/2\" W x 16\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95,'Yellow'),('White Elegance','t407-1.jpeg','t407-1','t407-1_d.jpeg','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a570-05fb-6e85-09c6fabcd76c\">So simple, and so breathtakingly beautiful. This holiday flower arrangement features an all-white bouquet of roses, lilies and more in an exquisite silver reflections vase that will be cherished for years.</span></p>','Roses|Lillies|Carnations|Assorted','16\" W x 18 1/2\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95,'White'),('Love That Pink','t409-3.jpeg','t409-3','t409-3_d.jpeg','Anniversary','Valentine\'s Day',54.95,44.95,'<p dir=\"ltr\">\"Luscious\" is the word to describe this gorgeous bouquet of red and pink roses and other romantic favorites in a chic mirrored silver cube. It\'s simple and simply spectacular. Many Valentine kisses are in order.</p>','Roses|Carnations|Assorted','11\" W x 12 1/2\" H','blankFlowerImage.png',64.95,54.95,74.95,64.95,'Assorted'),('Garden Parade','t41-1.jpeg','t41-1','t41-1_d.jpeg','Other','',42.95,42.95,'<p dir=\"ltr\">Everyone loves a parade! Festive blooms in bold, primary colors are a fun way to express your friendship and love.</p>','Roses|Gerberas|Assorted|Other','14\" W x 13 1/2\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95,'Assorted'),('How Sweet It Is','t46-1.jpg','t46-1','t46-1_d.jpg','Other','',34.95,24.95,'<p><span id=\"docs-internal-guid-95219994-952d-a3f3-6cc0-b20569f537be\">A sweet treat any day of the week! Warm, rich colors of pink and orange are contrasted with fresh green - a welcome combination for any occasion. Send it to sweeten a best friend\'s birthday, say \"hi\" to mom, or delight your better half.</span></p>','Roses|Carnations|Assorted','10 1/2\" W x 11\" H','t46-1_p.jpg',44.95,34.95,54.95,44.95,'Orange'),('Sunrise Wishes','t47-1.jpeg','t47-1','t47-1_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Celebrate the wonder of a new day with warm, golden flowers. A modern orange glass vase is the foundation of this stunning, sun-bright bouquet that energizes any occasion.</p>','Roses|Daisies|Gerberas|Carnations|Assorted','8\" W x 9\" H','t47-1_p.jpeg',54.95,44.95,69.95,59.95,'Orange'),('Uniquely Chic','t47-3.jpeg','t47-3','t47-3_d.jpeg','Other','',57.95,47.95,'<p dir=\"ltr\">Tres chic! Send that special someone a stylish sentiment with the bright colors of this modern arrangement. Summery hot pinks and oranges are contrasted by the cool clarity of a simple cube vase. An eye-catching everyday choice!</p>','Roses|Lillies|Carnations|Assorted','13\" W x 11 1/2\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95,'Assorted'),('Exquisite Beauty','t48-2.jpg','t48-2','blankFlowerImage.png','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a542-70b9-63c0-e46d79e41cd8\">This exquisite mix of feminine blooms is like a breath of fresh air! Sweet pinks and purples are contrasted with a modern burst of fresh green hydrangea, and finished off with a pretty lavender cube vase lined with a tropical aspidistra leaf. It\'s a fun pick-me-up to send anytime, anywhere!</span></p>','Roses|Hydrangeas|Assorted','10 1/2\" W x 11 1/2\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95,'Assorted'),('Country Basket Blooms','t48-3.jpeg','t48-3','t48-3_d.jpeg','Other','',57.95,47.95,'<p dir=\"ltr\">Take a walk through a country meadow with this fresh flower basket! Pretty blooms of pink and purple nestle happily inside a natural gift basket as playful purple butterflies flutter overhead.</p>','Daisies|Gerberas|Carnations|Assorted|Other','16 1/2\" W x 16 1/2\" H','t48-3_p.jpeg',67.95,57.95,77.95,67.95,'Assorted'),('Enchanted Cottage','t50-1.jpeg','t50-1','t50-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">As enchanting as coming across a hidden cottage in the countryside! Lush white roses and purple stock mix with delicate lavender waxflower and green pitta negra for an elegant English garden look. The decorative bouquet is finished with a pretty satin ribbon.</p>','Roses|Assorted|Other','14 1/2\" W x 16 1/2\" H','t50-1_p.jpeg',59.95,49.95,69.95,59.95,'Assorted'),('Sweet and Lovely','t50-2.jpg','t50-2','t50-2_d.jpg','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a54d-067b-7f4d-c5f495d0f28c\">Visions of sugar plum fairies dance to life with this magical bouquet. Lush lavenders, frosty whites and silvery greens look romantic and refreshing inside a cool cube vase.</span></p>','Roses|Hydrangeas|Assorted','12 1/2\" W x 11 1/2\" H','t50-2_p.jpg',82.95,72.95,92.95,82.95,'Purple'),('Polka Dots and Posies','t52-3.jpeg','t52-3','t52-3_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Pop, go the flowers! This energetic pink and white bouquet pairs fresh white daisies with hot pink roses in a light pink glass cube vase. It\'s a fun, summery choice for your favorite girly girl!</p>','Roses|Daisies|Assorted','10\" W x 9 1/2\" H','t52-3_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Dazzling Beauty','t53-1.jpeg','t53-1','blankFlowerImage.png','Other','Mother\'s Day',97.95,87.95,'<p dir=\"ltr\">Purple hydrangea, tulips and mokara orchids play with fuchsia roses and lilies in this vibrant bouquet. Sure to delight with its lovely fragrance and fun color palette, this summery assortment is presented in a pale pink glass vase she\'ll keep forever!</p>','Tulips|Lillies|Hydrangeas|Orchids|Assorted','21\" W x 20\" H','blankFlowerImage.png',107.95,97.95,117.95,107.95,'Assorted'),('Romantic Bliss','t54-1.jpg','t54-1','t54-1_d.jpg','Other','',52.95,42.95,'<p><span id=\"docs-internal-guid-95219994-a557-4b9c-bfd4-5ec5a6c121f4\">Turn on the charm with this elegant white and cr&egrave;me bouquet. Delivered in a classic Mercury Glass Vase, the delicate arrangement is as romantic as they come.</span></p>','Roses|Carnations|Assorted','11 1/2\" W x 14 1/2\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95,'White'),('Feminine, Fresh Beauties','t55-2.jpeg','t55-2','t55-2_d.jpeg','Other','',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-9450-fd8b-7e6e-442b94e48b8b\">Feminine and fresh!&nbsp;This fragrant&nbsp;bouquet showcases soft pink roses with white lilies, alstroemeria and mums into a rounded ginger vase.</span></p>','Roses|Lillies|Assorted','10.5\" W x 11\" H','t55-2_p.jpeg',49.95,39.95,59.95,49.95,'White'),('Yellow Fellow','t56-1.jpeg','t56-1','t56-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">This yellow fellow is anything but mellow! Bright yellow lilies are uniquely arranged into a topiary and grounded in a warm terra-cotta pot overflowing with fresh greens. When you want to send something exciting and unexpected, this is your go-to guy.</p>','Roses|Lillies|Assorted|Other','12 1/2\" W x 21 1/2\" H','t56-1_p.jpeg',59.95,49.95,69.95,59.95,'Yellow'),('True Love','t65-1.jpeg','t65-1','blankFlowerImage.png','Holiday','Valentine\'s Day',77.95,67.95,'<p><span id=\"docs-internal-guid-95219994-a568-1d97-bfbb-5d370fc84c0f\">Hold fast to her heart with romantic reminders of your love. This unique rose arrangement speaks to your passion in rich reds and delicate lavender.</span></p>','Roses','12\" W x 11\" H','blankFlowerImage.png',87.95,77.95,97.95,87.95,'Red'),('Rose Classique','t65-2.jpeg','t65-2','t65-2_d.jpeg','Anniversary','Anniversary',69.95,59.95,'<p dir=\"ltr\">As classic as you can get! One dozen iconic red roses are a traditional and heartfelt way to say \"I love you\" - on Valentine\'s Day and all year long. The lush romantic gift is delivered in Teleflora\'s gorgeous Couture Vase that she\'ll treasure forever.</p>','Roses','15\" W x 17\" H','blankFlowerImage.png',89.95,79.95,109.95,99.95,'Red'),('Morning Melody','t68-3.jpeg','t68-3','t68-3_d.jpeg','Other','',44.95,34.95,'<p dir=\"ltr\">Fresh as morning dew. Beautiful blooms in all shades of purple are gathered into a purple glass cube vase and tied with a purple bow. How perfectly purple!</p>','Roses','10 1/2\" W x 11\" H','t68-3_p.jpeg',54.95,44.95,64.95,54.95,'Purple'),('Rosy Glow','t70-1.jpg','t70-1','t70-1_d.jpg','Other','',69.95,59.95,'<p><span id=\"docs-internal-guid-95219994-a54a-868d-4465-fcf7216da81e\">What a bright idea! Send a summery treat to someone special with this cheerful bouquet of one dozen yellow roses. A happy pick for your fellow yellow-lover!</span></p>','Roses','16\" W x 20\" H','blankFlowerImage.png',89.95,79.95,109.95,99.95,'Yellow'),('Uptown Girl','t72-3.jpeg','t72-3','blankFlowerImage.png','Other','Holiday Best Sellers',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-a571-35aa-458a-8f72d70b95fe\">A truly sophisticated rose garden befitting an uptown apartment, this modern rose arrangement pairs dark orange roses with soft peach roses in a dark bamboo vase. Perfectly arranged pitta negra and myrtle add to the upscale look.</span></p>','Roses','14\" W x 9 1/2\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95,'Red'),('Colorful and Chic','t74-1.jpg','t74-1','blankFlowerImage.png','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a555-ce31-b91e-48421ae29f0a\">Colorful and chic, this stunning arrangement featuring roses and other favorites is sure to impress!</span></p>','Roses|Assorted','13\" W x 12\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95,'Assorted'),('Petals of Love','t8-1.jpg','t8-1','t8-1_d.jpg','Anniversary','Anniversary',72.95,62.95,'<p>Show her how much you love her with this beautiful arrangement of pink lilies and elegant white roses</p>','Roses|Lillies|Assorted','15 1/2\" W x 18\" H','t8-1_p.jpg',82.95,72.95,92.95,82.95,'Assorted'),('Exotic Love','t81-2.jpeg','t81-2','t81-2_d.jpeg','Other','',57.95,47.95,'<p><span id=\"docs-internal-guid-95219994-a573-392d-23bd-36fc42c3739f\">Send someone on a tropical honeymoon - if only in their mind - with this exotic, romantic gift. Delicate purple orchids are presented with tropical leaves and ferns in a chic plum-colored glass cube.</span></p>','Orchids','12 1/4\" W x 16 1/2\" H','blankFlowerImage.png',72.95,62.95,87.95,77.95,'Purple'),('New Sensations','t82-3.jpeg','t82-3','t82-3_d.jpeg','Anniversary','Valentine\'s Day',122.95,112.95,'<p dir=\"ltr\">Like a girl\'s getaway to the tropics! Feminine flowers in tropical pastels brighten her day - and her feng shui. She\'ll love the beautiful serenity and balanced, Zen-like feel of the lush pink and green blooms. Perfect for spring, it\'s currently featured in O, The Oprah Magazine, on its O List.</p>','Roses|Tulips|Hydrangeas|Orchids|Assorted','13\" W x 14\" H','blankFlowerImage.png',142.95,132.95,162.95,152.95,'Assorted'),('Isn\'t It Romantic','t9-1.jpeg','t9-1','blankFlowerImage.png','Anniversary','Anniversary',97.95,87.95,'<p dir=\"ltr\">Gorgeous, gorgeous, gorgeous! This lush natural arrangement of royal roses, lilies, lisianthus, sweet pea and stock is stunning in its variety and color palette. Not to mention its fabulous fragrance!</p>','Roses|Lillies|Assorted','19\" W x 17 1/2\" H','blankFlowerImage.png',107.95,97.95,117.95,107.95,'White'),('Delicate Dozen','t9-2.jpeg','t9-2','blankFlowerImage.png','Anniversary','Valentine\'s Day',64.95,54.95,'<p dir=\"ltr\">An entirely feminine and rather modern take on the classic dozen roses, this innocent bouquet of blushing roses is simply breathtaking. A versatile choice for an anniversary or anytime you want to send your very best.</p>','Roses','14\" W x 16 1/2\" H','blankFlowerImage.png',84.95,74.95,104.95,94.95,'White'),('Madly in Love','t9-3.jpg','t9-3','t9-3_d.jpg','Anniversary','Valentine\'s Day',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-9486-05e1-4951-3efb358e8c0a\">Romantic roses in passionate shades of red, pink and purple express love and devotion to that special someone. Dense and dramatic, the classic blooms look especially chic in our modern red cube vase.</span></p>','Roses','11\" W x 10\" H','t9-3_p.jpg',72.95,62.95,82.95,72.95,'Assorted'),('Imperial Purple Orchid','t98-1.jpg','t98-1','blankFlowerImage.png','Other','',64.95,54.95,'<p><span id=\"docs-internal-guid-95219994-a540-0073-e3a9-2a3e4272f832\">Send Zen. A graceful purple phalaenopsis orchid plant potted in a modern bamboo container is an enchanting gift for any occasion.</span></p>','Orchids','13\" W x 22 1/2\" H','blankFlowerImage.png',0,0,0,0,'Purple'),('Opulent Orchids','t98-2.jpeg','t98-2','blankFlowerImage.png','Other','',124.95,114.95,'<p dir=\"ltr\">Send Zen. A graceful white phaleanopsis orchid plant potted in a modern bamboo container is an enchanting gift for any occasion.</p>','Orchids','11 1/2\" W x 25 1/2\" H','blankFlowerImage.png',0,0,0,0,'White'),('Blossoming Romance','tev09-1.jpeg','tev09-1','tev09-1_d.jpeg','Other','',64.95,54.95,'<p>&nbsp;This soft yet stunning bouquet is sure to brighten her day!&nbsp; A gorgeous mix of pink spray roses, white lilies, and other favorites is the perfect way to show her how special she is!</p>','Roses|Lillies|Assorted','17\" W x 17\" H','tev09-1_p.jpeg',74.95,64.95,84.95,74.95,'Assorted'),('Your Sweet Smile','tev11-1.jpg','tev11-1','tev11-1_d.jpg','Other','',54.95,44.95,'<p><span id=\"docs-internal-guid-95219994-a537-87f7-6c64-bde51194fdee\">Let us deliver the glorious gift of sunshine to someone you love. They\'ll adore the yellow and white roses beautifully presented in a sparkling glass vase. The bouquet is called \"Your Sweet Smile.\" You\'re sure to get a big one in return.</span></p>','Roses|Carnations|Assorted','12 1/2\" W x 14\" H','tev11-1_p.jpg',64.95,54.95,74.95,64.95,'Assorted'),('Smile for Me','tev11-3.jpeg','tev11-3','tev11-3_d.jpeg','Other','',44.95,34.95,'<p dir=\"ltr\">Color their week happy with this blazing array of hot pink roses, orange spray roses, purple carnations and more in a sparkling glass bubble bowl. A sweet gift for a birthday, anniversary or any loving occasion. They\'ll be thrilled.</p>','Roses|Carnations|Assorted|Other','12 3/4\" W x 11\" H','blankFlowerImage.png',54.95,44.95,64.95,54.95,'Assorted'),('Pretty Please','tev12-4.jpeg','tev12-4','tev12-4_d.jpeg','Other','',29.99,19.99,'<p dir=\"ltr\">Looking for the prettiest bouquet in town? We\'ve got the perfect all-around choice! Pretty Please is a flower bouquet with all the right stuff - a lovely mix of fresh flowers in breezy shades of pink, white, lavender and more at a wonderfully reasonable price, all tied up with a big pink bow. A great way to make someone smile.</p>','Roses|Daisies|Assorted|Other','11 1/2\" W x 15\" H','tev12-4_p.jpeg',39.95,29.95,49.95,39.95,'Assorted'),('Enduring Passion','tev12-7.jpeg','tev12-7','tev12-7_d.jpg','Anniversary','Valentine\'s Day',54.95,44.95,'<p dir=\"ltr\">Many a heart has been won with a dozen luscious red roses. If there\'s a heart you\'d like to win or re-win, you can\'t go wrong with this legendary gift of love. Contact us in the morning and we can deliver for you - really deliver for you - in the afternoon too.</p>','Roses','14 1/2\" W x 15 3/4\" H','tev12-7_p.jpg',74.95,64.95,94.95,84.95,'Red'),('Steal My Heart','tev13-3.jpg','tev13-3','blankFlowerImage.png','Other','Valentine\'s Day',89.95,79.95,'<p><span id=\"docs-internal-guid-95219994-a55c-db05-899a-c1801df7dd37\">True romance! This unique take on the classic red rose bouquet features lavender waxflower for an ultra-feminine touch. It\'s an original way to celebrate your one-of-a-kind love.</span></p>','Roses','12\" W x 12\" H','blankFlowerImage.png',99.95,89.95,109.95,99.95,'Red'),('Upsy Daisy','tev13-4.jpeg','tev13-4','tev13-4_d.jpeg','Other','',29.99,19.99,'<p dir=\"ltr\">What could be sweeter than a cheerful yellow vase filled with white and yellow daisies? Can\'t think of anything? Then choose this sunny bouquet. It will brighten their day.</p>','Daisies','13\" W x 15\" H','tev13-4_p.jpeg',39.95,29.95,49.95,39.95,'Yellow'),('Perfectly Pastel','tev13-5.jpeg','tev13-5','tev13-5_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">\"Graceful and gorgeous\" describes this stunning array of pastel flowers in a charming lavender vase tied with a pink satin ribbon. It\'s almost too pretty for words. But you\'ll hear many words of praise for sending it.</p>','Roses|Lillies|Carnations|Assorted|Other','13\" W x 14 1/2\" H','tev13-5_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Make A Wish','tev13-6.jpeg','tev13-6','tev13-6_d.jpeg','Other','',32.95,22.95,'<p dir=\"ltr\">All their wishes will come true when they receive this bright and sunny flower arrangement - a summery mix of yellow daisy chrysanthemums, purple asters, red and orange carnations and more, adorned with a cheerful green plaid bow. Send one today, and make someone\'s day!</p>','Daisies|Carnations|Assorted|Other','10 1/2\" W x 12 1/4\" H','tev13-6_p.jpeg',42.95,32.95,52.95,42.95,'Assorted'),('Sweet Thoughts','tev13-7.jpg','tev13-7','tev13-7_d.jpg','Anniversary','Valentine\'s Day',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-a534-1730-e2df-eba17b2e42a9\">A graceful heart of bear grass... tied with purple waxflower blossoms... forms a heart that appears to float above the velvety red roses in this delightful bouquet, arranged in a ruby-red cube vase. Send this beautiful floral arrangement to someone you love, and they\'ll think sweet thoughts about you!</span></p>','Roses|Assorted',' 9 1/2\" W x 10\" H','tev13-7_p.jpg',49.95,39.95,59.95,49.95,'Red'),('Blooming Elegance','tev155-1.jpg','tev155-1','tev155-1_d.jpg','Other','Holiday Best Sellers',69.95,59.95,'<p><span id=\"docs-internal-guid-95219994-a53b-cebb-ae22-4cd50c604280\">Stylish and elegant, this&nbsp;blend of&nbsp;roses, gerberas,&nbsp;hydrangeas and carnations is perfect for any occasion!</span></p>','Roses|Hydrangeas|Gerberas|Carnations|Assorted','10\" W x 11\" H','tev155-1_p.jpg',79.95,69.95,89.95,79.95,'Assorted'),('Radiant Roses','tev19-1.jpg','tev19-1','tev19-1_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a55e-3a70-582d-0a744f3a8a5e\">&nbsp;This radiant bouquet features hot pink roses and dark red spray roses are arranged in our violet cube</span></p>','Roses|Carnations|Assorted','11 1/2\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Garden Romance','tev20-1.jpeg','tev20-1','tev20-1_d.jpeg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a9d8-0ff9-561e-1af92a5f5c0c\">Va-va-bloom! This stunning arrangement of purple hydrangea, light pink spray roses and white asiatic lilies is perfectly presented in our violet cube.</span></p>','Roses|Lillies|Hydrangeas|Assorted','13\" W x 13\" H','tev20-1_p.jpeg',59.95,49.95,69.95,59.95,'Assorted'),('Splendid Surprise','tev20-2.jpg','tev20-2','tev20-2_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a550-86d5-626d-99d7c606e872\">Lovely at first sight. Green miniature hydrangea and lavender roses are a lovely combination! This extra-sweet bouquet comes in our fuchsia glass cube.</span></p>','Roses|Hydrangeas|Carnations|Assorted','10 1/2\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Make Her Day','tev20-3.jpeg','tev20-3','tev20-3_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">This sweet bouquet includes green miniature hydrangea and light pink spray roses arranged in our citrus green glass cube.</p>','Roses|Hydrangeas|Carnations|Assorted','11 1/4\" W x 11\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Blush of Love','tev21-1.jpeg','tev21-1','tev21-1_d.jpeg','Anniversary','Valentine\'s Day',59.95,49.95,'<p dir=\"ltr\">Make her blush with this romantic mix of fragrant lilies and lush hydrangea in dreamy shades of pink. Presented in our elegant couture glass vase, this beautiful bouquet is affection perfection!</p>','Lillies|Hydrangeas|Carnations|Assorted|Other','14\" W x 17\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95,'Assorted'),('So Enchanting','tev23-5.jpeg','tev23-5','tev23-5_d.jpeg','Other','',64.95,54.95,'<p dir=\"ltr\">Paint her world with enchantment! A palette of rich red roses and elegant pink lilies creates a simply stunning statement of love and devotion. It\'s a masterpiece she\'ll always remember.</p>','Roses|Lillies|Assorted','16 1/2\" W x 19\" H','blankFlowerImage.png',74.95,64.95,84.95,74.95,'Assorted'),('Full of Love','tev24-2.jpeg','tev24-2','tev24-2_d.jpeg','Anniversary','Valentine\'s Day',39.95,29.95,'<p>It\'s beauty-full! Bursting with tantalizing tulips and radiant roses, this delightful pink arrangement brings spring joy to that special someone.</p>','Roses|Tulips|Carnations|Assorted','12\" W x 14 1/2\" H','tev24-2_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Spring Romance','tev24-4.jpeg','tev24-4','tev24-4_d.jpeg','Other','Holiday Best Sellers',49.95,39.95,'<p dir=\"ltr\">Spring is the season for romance! Brimming with exquisite tulips and alstroemeria, this bouquet in a classic glass hurricane celebrates the beauty of the season.</p>','Tulips|Assorted|Other','13 1/2\" W x 14 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Sapphire Skies','tev25-3.jpeg','tev25-3','tev25-3_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">Like gazing into a clear blue sky, this serene arrangement soothes the soul and cheers the heart. Its creamy roses and snowy lilies are arranged in our dazzling sapphire cube.</p>','Roses|Lillies|Carnations|Assorted','12\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'White'),('Meant To Be','tev28-1.jpeg','tev28-1','tev28-1_d.jpeg','Other','',59.95,49.95,'<p dir=\"ltr\">Lush and lovely, yet delightfully delicate, the pale pinks, yellows and whites of this gorgeous bouquet look like they were made for one another. Just like the two of you&hellip;</p>','Roses|Carnations|Assorted|Other','16\" W x 17 1/2\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95,'Assorted'),('Pure Love','tev30-2.jpg','tev30-2','tev30-2_d.jpg','Other','',59.95,49.95,'<p><span id=\"docs-internal-guid-95219994-a563-9840-5ed0-a56bc774fadf\">Pure love deserves the pure luxury of this wondrous white bouquet. Fragrant lilies, lush hydrangea and delicate alstroemeria are carefully arranged in our Couture vase for an elegant look they will adore.</span></p>','Lillies|Hydrangeas|Carnations|Assorted','14\" W x 17\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95,'White'),('Pink Elegance','tev31-3.jpeg','tev31-3','tev31-3_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Perfectly pink perfection. Send this sweet, sentimental bouquet on her birthday, Mother\'s Day, or&hellip; any day you want to make her feel extra special.</p>','Carnations|Assorted|Other','12\" W x 16\" H','tev31-3_p.jpeg',49.95,39.95,59.95,49.95,'Assorted'),('Sincerely Yours','tev31-5.jpeg','tev31-5','tev31-5_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Pamper her with pale pink roses, pristine white daisies&hellip; and your thoughtfulness. A sweet, simple statement of your sincere love, this light, delicate bouquet will make her smile.</p>','Roses|Daisies|Assorted|Other','14\" W x 19\" H','blankFlowerImage.png',49.95,39.95,59.95,49.95,'Assorted'),('Turn Up The Pink','tev33-1.jpg','tev33-1','tev33-1_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a547-0bcd-40e9-7d7238384b4a\">Pop goes the pink! A gorgeously chic gift for any occasion, this perky pink and orange bouquet is pure fun, especially when it\'s hand-delivered in our fabulous fuchsia Cube!</span></p>','Roses|Gerberas|Carnations|Assorted','11\" W x 11\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95,'Assorted'),('Pink Grace','tev38-1.jpeg','tev38-1','tev38-1_d.jpeg','Other','',54.95,44.95,'<p dir=\"ltr\" style=\"line-height: 1; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11px; font-family: Arial; color: #373737; background-color: transparent; font-weight: normal; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Celebrate a fabulous woman in your life with a beautiful mixed bouquet featuring pink roses and arranged in a perky pink cube. She\'ll be thrilled with this charmingly feminine gift - and touched by your thoughtfulness because it is also a gift for others!</span></p>','Roses|Carnations|Assorted','13 1/2\" W x 14\" H','tev38-1_p.jpeg',64.95,54.95,74.95,64.95,'Assorted'),('Sophisticated Lady','tev40-1.jpeg','tev40-1','tev40-1_d.jpeg','Other','',64.95,54.95,'<p>A wonderful arrangement for any occasion, this blend of blooms is sure to brighten her day!&nbsp; Featuring hydrangeas, roses, and lilies in a light pink vase</p>','Roses|Lillies|Hydrangeas|Gerberas|Assorted','14\" W x 18\" H','tev40-1_p.jpeg',74.95,64.95,84.95,74.95,'Assorted'),('Fresh Flourish','tev40-2.jpeg','tev40-2','tev40-2_d.jpeg','Birthday','Mother\'s Day',59.95,49.95,'<p><span id=\"docs-internal-guid-95219994-a9d9-2ce5-168f-4882218d8c08\">No one can resist the beauty of this bright bouquet! A sublime way to celebrate any occasion, this special delivery blends hot pink and lavender roses with pink lilies and lime green button mums for a look that\'s pure heaven. It\'s all artfully arranged in our exclusive, lovely lavender glass vase they\'ll always treasure.</span></p>','Roses|Lillies|Assorted','15 1/2\" W x 19 3/4\" H','tev40-2_p.jpeg',69.95,59.95,79.95,69.95,'Assorted'),('Love and Devotion','trs01-1.jpeg','trs01-1','blankFlowerImage.png','Anniversary','Valentine\'s Day',124.95,114.95,'<p dir=\"ltr\">Sweep her off her feet with two dozen red roses in a gracefully flared clear glass vase. Whether for an anniversary, birthday or just because, this gorgeous romantic bouquet of 24 roses will win her heart all over again.</p>','Roses','15\" W x 22\" H','blankFlowerImage.png',149.95,139.95,174.95,164.95,'Red'),('Rose Rapture','trs03-1.jpeg','trs03-1','blankFlowerImage.png','Anniversary','Valentine\'s Day',194.95,184.95,'<p dir=\"ltr\">Feminine and fabulous, this spectacular bouquet of lavender and pink roses in a chic cylinder vase is guaranteed to leave her speechless. Until she says how much she loves you for choosing this absolutely incredible array.</p>','Roses','17\" W x 17\" H','blankFlowerImage.png',214.95,204.95,234.95,224.95,'Assorted');

--
-- Table structure for table `product_bak`
--

CREATE TABLE `product_bak` (
  `name` varchar(200) NOT NULL,
  `standardimage` varchar(300) NOT NULL,
  `itemNumber` varchar(100) NOT NULL,
  `deluxeimage` varchar(300) NOT NULL,
  `occasion` varchar(100) NOT NULL,
  `holidays` varchar(100) NOT NULL,
  `retail` float NOT NULL,
  `price` float NOT NULL,
  `info` text NOT NULL,
  `includes` varchar(500) NOT NULL,
  `dimensions` varchar(50) NOT NULL,
  `premiumimage` varchar(300) NOT NULL,
  `deluxeRetail` float NOT NULL,
  `deluxePrice` float NOT NULL,
  `premiumRetail` float NOT NULL,
  `premiumPrice` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `product_bak`
--

INSERT INTO `product_bak` VALUES ('Enchanted Journey','t10-2.jpg','t10-2','blankFlowerImage.png','Anniversary','Anniversary',57.95,47.95,'<p><span id=\"docs-internal-guid-95219994-94c9-fb64-bd3e-00dc028c2092\">A fairy tale of flowers! Send this whimsical, feminine bouquet to your very own princess - or anyone you especially adore. Beautiful hydrangea, fragrant roses and delicate statice in a modern purple vase ensure your lucky recipient will live happily ever after!</span></p>','Roses|Hydrangeas|Carnations|Assorted',' 9\" W x 9\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95),('Blushing Beauty','t10-3.jpg','t10-3','blankFlowerImage.png','Anniversary','Anniversary',64.95,54.95,'<p><span id=\"docs-internal-guid-95219994-958e-0a24-ec3f-3d36af6d5566\">Sometimes all she needs is a little pink me up! An ideal pick for anyone whose favorite color is pink, this stylish mix is full of variety and comes presented in a clear glass bubble bowl she\'ll use again and again.</span></p>','Roses|Lillies|Gerberas|Carnations|Assorted','13 1/4\" W x 14 1/2\" H','blankFlowerImage.png',74.95,64.95,84.95,74.95),('Peaceful Zen Garden','t101-1.jpeg','t101-1','blankFlowerImage.png','Other','',57.95,47.95,'<p>The gift of Zen. Send peace someone\'s way with this elegant, eye-pleasing arrangement of low-maintenance succulent plants. Presented in a brown bamboo container, the plants are accented with smooth river rocks and natural river canes of bamboo.</p>','Other','13\" W x 12\" H','blankFlowerImage.png',0,0,0,0),('Wonderous Wishes','t11-1.jpg','t11-1','t11-1_d.jpg','Anniversary','Anniversary',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-95a7-8120-bdea-b67d300550a5\"></span><span id=\"docs-internal-guid-95219994-95a7-8120-bdea-b67d300550a5\">Featuring a wide, wondrous assortment of blooms in one bouquet, this colorful arrangement is always a favorite! Hydrangea, roses, lilies, alstroemeria, gerberas, daisies - they\'re all here in stunning variety.</span></p>','Roses|Lillies|Daisies|Hydrangeas|Gerberas|Assorted','14 1/2\" W x 17\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95),('Precious Pink Tulips','T11Z106.jpeg','T11Z106','blankFlowerImage.png','Other','Holiday Best Sellers',42.95,32.95,'<p dir=\"ltr\">Beautiful and \"simply said\" light pink tulips are a hip way to show you care.</p>','Tulips','12\" W x 14\" H','blankFlowerImage.png',72.95,62.95,102.95,92.95),('Winter Romance','t128-2.jpeg','t128-2','t128-2_d.jpeg','Holiday','Holiday Best Sellers',49.95,39.95,'<p>&nbsp;Send your love this holiday season with vibrant red roses, snow white lilies and playful daises!</p>','Roses|Lillies|Daisies|Carnations|Assorted','15\" W x 18\" H','t128-2_p.jpeg',59.95,49.95,69.95,59.95),('Happy Day Tulips','t140-1.jpg','t140-1','t140-1_d.jpg','Other','Mother\'s Day',42.95,32.95,'<p><span id=\"docs-internal-guid-95219994-a53d-976a-faa1-bc6adf100b1c\">Sunny yellow tulips are a sure sign of spring. Even if the weather is not cooperating, you can be sure the person who receives this bright bouquet will feel the warmth of your message.</span></p>','Tulips','12 1/2\" W x 14 3/4\" H','blankFlowerImage.png',72.95,62.95,102.95,92.95),('Lily Sunshine','t140-2.jpeg','t140-2','t140-2_d.jpg','Other','',57.95,47.95,'<p dir=\"ltr\">When it comes to spring flowers, the lily reigns supreme. It\'s easy to see why in this gorgeous bouquet of bright yellow blooms.</p>','Lillies','16 1/4\" W x 20 1/4\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95),('Spring Waltz','t141-1.jpeg','t141-1','t141-1_d.jpeg','Other','Mother\'s Day',82.95,72.95,'<p>Dance into spring! Send this feminine bouquet of favorite spring flowers to brighten someone\'s home with the playful beauty of nature. Such a pretty way to say, \"I\'m thinking of you!\"</p>','Roses|Tulips|Lillies|Assorted|Other','17 1/2\" W x 20\" H','blankFlowerImage.png',92.95,82.95,102.95,92.95),('Spring\'s First Kiss','t142-1.jpeg','t142-1','blankFlowerImage.png','Other','',67.95,57.95,'<p><span id=\"docs-internal-guid-95219994-a56a-8a5c-c97e-52b80297e68d\">Blooms this beautiful don\'t need decoration! Fifteen tantalizing tulips in soft spring colors make a thrilling thank you gift or sweet and innocent reminder of your love or friendship.</span></p>','Tulips','14\" W x 17\" H','blankFlowerImage.png',77.95,67.95,87.95,77.95),('Birthday Blooms','t147-1.jpeg','t147-1','t147-1_d.jpeg','Birthday','Holiday Best Sellers',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-a56c-98f5-6f37-47d0ba04d267\">A warm terra-cotta pot showcasing vibrant roses and tulips is sure to bring lots of smiles!</span></p>','Roses|Tulips|Carnations|Assorted','10\" W x 9 1/2\" H','t147-1_p.jpeg',49.95,39.95,59.95,49.95),('Blooming Birthday','t15-1.jpeg','t15-1','t15-1_d.jpeg','Birthday','Birthday',49.95,39.95,'<p>&nbsp;Fun and festive, this arrangement is blooming with colorful roses, carnations and Gerberas!</p>\r\n<p dir=\"ltr\">&nbsp;</p>','Roses|Gerberas|Carnations|Assorted|Other','17\" W x 13 1/2\" H','t15-1_p.jpeg',59.95,49.95,69.95,59.95),('Sunny Sunflowers','t152-2.jpg','t152-2','t152-2_d.jpg','Birthday','Birthday',44.95,34.95,'<p><span id=\"docs-internal-guid-95219994-a544-d6af-ad4c-ba094c2cbaa4\">Brighten up a table, send get well wishes, or simply sprinkle sunshine on someone\'s day with this summer flower arrangement. Bold sunflowers are arranged in a glass bubble bowl with curly willow curled inside.</span></p>','Sunflowers','12\" W x 10\" H','blankFlowerImage.png',54.95,44.95,64.95,54.95),('It\'s My Party','t173-1.jpeg','t173-1','t173-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">Rich jewel-toned flowers are arranged in a chic plum colored cube vase for a gift that\'s truly memorable. The modern, feminine composition is sweet without being too romantic, making it a great choice for sisters, mothers and friends.</p>','Roses|Daisies|Gerberas|Assorted|Other','10 1/2\" W x 12\" H','t173-1_p.jpeg',59.95,49.95,69.95,59.95),('Pretty Pink Present','t19-1.jpeg','t19-1','t19-1_d.jpeg','Birthday','Birthday',49.95,39.95,'<p dir=\"ltr\">Guaranteed to get a birthday smile! Surprise someone special with our pink gift box that\'s tied up with a polka-dotted green bow and packed with bountiful blooms. It\'s the perfect pink-themed pick!</p>','Roses|Lillies|Assorted|Other','12 3/4\" W x 12\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Brilliant Birthday Bliss','t21-1.jpeg','t21-1','t21-1_d.jpeg','Birthday','Birthday',72.95,62.95,'<p dir=\"ltr\">Pure pretty! This classic floral design puts a romantic spin on your birthday wishes in soft shades of pink and yellow. Presented in an antique-style vase, the traditional bouquet is finished with a fun mylar balloon.</p>','Roses|Gerberas|Assorted|Other','17\" W x 19\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95),('Sweet Surprise','t37-1.jpeg','t37-1','t37-1_d.jpeg','Maternity/Birth','',39.95,29.95,'<p dir=\"ltr\">Sweet as candy! This soft pink and white bouquet is a feminine choice for any occasion.</p>','Roses|Carnations|Assorted|Other','13\" W x 14 1/2\" H','t37-1_p.jpeg',49.95,39.95,59.95,49.95),('Make Me Blush','t4-1.jpg','t4-1','t4-1_d.jpg','Anniversary','Anniversary',72.95,62.95,'<p dir=\"ltr\">Blushing pink roses and delicate white limonium add up to a feminine arrangement that\'s at once sweet and innocent - and fabulously flirty!</p>','Roses','17 1/2\" W x 20 1/2\" H','blankFlowerImage.png',92.95,82.95,112.95,102.95),('Rose Garden Romance','t400-2.jpg','t400-2','t400-2_d.jpg','Anniversary','Anniversary',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-a561-ebcd-01d4-830c53fc0e46\">Sing her a love song - with flowers. This lush, loving rose arrangement tells her just how much you care.</span></p>','Roses','10 1/2\" W x 11\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95),('Pretty In Pink','t404-1.jpg','t404-1','t404-1_d.jpg','Other','',52.95,42.95,'<p><span id=\"docs-internal-guid-95219994-a565-c3fb-db20-b1072b41bf8a\">Nothing\'s too sweet for the sweetest woman in the world. Surprise her with a delightfully dainty bouquet featuring delicate lavender roses and pink hydrangea in a sparkling silver cube vase. You\'ll make her day, her week, her month!</span></p>','Roses|Hydrangeas|Assorted','11\" W x 11 3/4\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95),('So Pretty','t404-2.jpeg','t404-2','t404-2_d.jpeg','Other','',62.95,52.95,'<p dir=\"ltr\">It\'s like sunshine and moonlight in are gloriously happy gift! Soft yellow roses, white hydrangea and other favorites showcased in a dazzling Silver Reflections vase. She\'ll love it - and so will her envious friends.</p>','Roses|Hydrangeas|Assorted','11 1/2\" W x 16\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95),('White Elegance','t407-1.jpeg','t407-1','t407-1_d.jpeg','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a570-05fb-6e85-09c6fabcd76c\">So simple, and so breathtakingly beautiful. This holiday flower arrangement features an all-white bouquet of roses, lilies and more in an exquisite silver reflections vase that will be cherished for years.</span></p>','Roses|Lillies|Carnations|Assorted','16\" W x 18 1/2\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95),('Love That Pink','t409-3.jpeg','t409-3','t409-3_d.jpeg','Holiday','Holiday Best Sellers',54.95,44.95,'<p dir=\"ltr\">\"Luscious\" is the word to describe this gorgeous bouquet of red and pink roses and other romantic favorites in a chic mirrored silver cube. It\'s simple and simply spectacular. Many Valentine kisses are in order.</p>','Roses|Carnations|Assorted','11\" W x 12 1/2\" H','blankFlowerImage.png',64.95,54.95,74.95,64.95),('Garden Parade','t41-1.jpeg','t41-1','t41-1_d.jpeg','Other','',42.95,42.95,'<p dir=\"ltr\">Everyone loves a parade! Festive blooms in bold, primary colors are a fun way to express your friendship and love.</p>','Roses|Gerberas|Assorted|Other','14\" W x 13 1/2\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95),('How Sweet It Is','t46-1.jpg','t46-1','t46-1_d.jpg','Other','',34.95,24.95,'<p><span id=\"docs-internal-guid-95219994-952d-a3f3-6cc0-b20569f537be\">A sweet treat any day of the week! Warm, rich colors of pink and orange are contrasted with fresh green - a welcome combination for any occasion. Send it to sweeten a best friend\'s birthday, say \"hi\" to mom, or delight your better half.</span></p>','Roses|Carnations|Assorted','10 1/2\" W x 11\" H','t46-1_p.jpg',44.95,34.95,54.95,44.95),('Sunrise Wishes','t47-1.jpeg','t47-1','t47-1_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Celebrate the wonder of a new day with warm, golden flowers. A modern orange glass vase is the foundation of this stunning, sun-bright bouquet that energizes any occasion.</p>','Roses|Daisies|Gerberas|Carnations|Assorted','8\" W x 9\" H','blankFlowerImage.png',54.95,44.95,69.95,59.95),('Uniquely Chic','t47-3.jpeg','t47-3','t47-3_d.jpeg','Other','',57.95,47.95,'<p dir=\"ltr\">Tres chic! Send that special someone a stylish sentiment with the bright colors of this modern arrangement. Summery hot pinks and oranges are contrasted by the cool clarity of a simple cube vase. An eye-catching everyday choice!</p>','Roses|Lillies|Carnations|Assorted','13\" W x 11 1/2\" H','blankFlowerImage.png',67.95,57.95,77.95,67.95),('Exquisite Beauty','t48-2.jpg','t48-2','blankFlowerImage.png','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a542-70b9-63c0-e46d79e41cd8\">This exquisite mix of feminine blooms is like a breath of fresh air! Sweet pinks and purples are contrasted with a modern burst of fresh green hydrangea, and finished off with a pretty lavender cube vase lined with a tropical aspidistra leaf. It\'s a fun pick-me-up to send anytime, anywhere!</span></p>','Roses|Hydrangeas|Assorted','10 1/2\" W x 11 1/2\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95),('Country Basket Blooms','t48-3.jpeg','t48-3','t48-3_d.jpeg','Other','',57.95,47.95,'<p dir=\"ltr\">Take a walk through a country meadow with this fresh flower basket! Pretty blooms of pink and purple nestle happily inside a natural gift basket as playful purple butterflies flutter overhead.</p>','Daisies|Gerberas|Carnations|Assorted|Other','16 1/2\" W x 16 1/2\" H','t48-3_p.jpeg',67.95,57.95,77.95,67.95),('Enchanted Cottage','t50-1.jpeg','t50-1','t50-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">As enchanting as coming across a hidden cottage in the countryside! Lush white roses and purple stock mix with delicate lavender waxflower and green pitta negra for an elegant English garden look. The decorative bouquet is finished with a pretty satin ribbon.</p>','Roses|Assorted|Other','14 1/2\" W x 16 1/2\" H','t50-1_p.jpeg',59.95,49.95,69.95,59.95),('Sweet and Lovely','t50-2.jpg','t50-2','t50-2_d.jpg','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a54d-067b-7f4d-c5f495d0f28c\">Visions of sugar plum fairies dance to life with this magical bouquet. Lush lavenders, frosty whites and silvery greens look romantic and refreshing inside a cool cube vase.</span></p>','Roses|Hydrangeas|Assorted','12 1/2\" W x 11 1/2\" H','t50-2_p.jpg',82.95,72.95,92.95,82.95),('Polka Dots and Posies','t52-3.jpeg','t52-3','t52-3_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Pop, go the flowers! This energetic pink and white bouquet pairs fresh white daisies with hot pink roses in a light pink glass cube vase. It\'s a fun, summery choice for your favorite girly girl!</p>','Roses|Daisies|Assorted','10\" W x 9 1/2\" H','t52-3_p.jpeg',49.95,39.95,59.95,49.95),('Dazzling Beauty','t53-1.jpeg','t53-1','blankFlowerImage.png','Other','Mother\'s Day',97.95,87.95,'<p dir=\"ltr\">Purple hydrangea, tulips and mokara orchids play with fuchsia roses and lilies in this vibrant bouquet. Sure to delight with its lovely fragrance and fun color palette, this summery assortment is presented in a pale pink glass vase she\'ll keep forever!</p>','Tulips|Lillies|Hydrangeas|Orchids|Assorted','21\" W x 20\" H','blankFlowerImage.png',107.95,97.95,117.95,107.95),('Romantic Bliss','t54-1.jpg','t54-1','t54-1_d.jpg','Other','',52.95,42.95,'<p><span id=\"docs-internal-guid-95219994-a557-4b9c-bfd4-5ec5a6c121f4\">Turn on the charm with this elegant white and cr&egrave;me bouquet. Delivered in a classic Mercury Glass Vase, the delicate arrangement is as romantic as they come.</span></p>','Roses|Carnations|Assorted','11 1/2\" W x 14 1/2\" H','blankFlowerImage.png',62.95,52.95,72.95,62.95),('Feminine, Fresh Beauties','t55-2.jpeg','t55-2','t55-2_d.jpeg','Other','',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-9450-fd8b-7e6e-442b94e48b8b\">Feminine and fresh!&nbsp;This fragrant&nbsp;bouquet showcases soft pink roses with white lilies, alstroemeria and mums into a rounded ginger vase.</span></p>','Roses|Lillies|Assorted','10.5\" W x 11\" H','t55-2_p.jpeg',49.95,39.95,59.95,49.95),('Yellow Fellow','t56-1.jpeg','t56-1','t56-1_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">This yellow fellow is anything but mellow! Bright yellow lilies are uniquely arranged into a topiary and grounded in a warm terra-cotta pot overflowing with fresh greens. When you want to send something exciting and unexpected, this is your go-to guy.</p>','Roses|Lillies|Assorted|Other','12 1/2\" W x 21 1/2\" H','t56-1_p.jpeg',59.95,49.95,69.95,59.95),('True Love','t65-1.jpeg','t65-1','blankFlowerImage.png','Holiday','Valentine\'s Day',77.95,67.95,'<p><span id=\"docs-internal-guid-95219994-a568-1d97-bfbb-5d370fc84c0f\">Hold fast to her heart with romantic reminders of your love. This unique rose arrangement speaks to your passion in rich reds and delicate lavender.</span></p>','Roses','12\" W x 11\" H','blankFlowerImage.png',87.95,77.95,97.95,87.95),('Rose Classique','t65-2.jpeg','t65-2','t65-2_d.jpeg','Anniversary','Anniversary',69.95,59.95,'<p dir=\"ltr\">As classic as you can get! One dozen iconic red roses are a traditional and heartfelt way to say \"I love you\" - on Valentine\'s Day and all year long. The lush romantic gift is delivered in Teleflora\'s gorgeous Couture Vase that she\'ll treasure forever.</p>','Roses','15\" W x 17\" H','blankFlowerImage.png',89.95,79.95,109.95,99.95),('Morning Melody','t68-3.jpeg','t68-3','t68-3_d.jpeg','Other','',44.95,34.95,'<p dir=\"ltr\">Fresh as morning dew. Beautiful blooms in all shades of purple are gathered into a purple glass cube vase and tied with a purple bow. How perfectly purple!</p>','Roses','10 1/2\" W x 11\" H','t68-3_p.jpeg',54.95,44.95,64.95,54.95),('Rosy Glow','t70-1.jpg','t70-1','t70-1_d.jpg','Other','',69.95,59.95,'<p><span id=\"docs-internal-guid-95219994-a54a-868d-4465-fcf7216da81e\">What a bright idea! Send a summery treat to someone special with this cheerful bouquet of one dozen yellow roses. A happy pick for your fellow yellow-lover!</span></p>','Roses','16\" W x 20\" H','blankFlowerImage.png',89.95,79.95,109.95,99.95),('Uptown Girl','t72-3.jpeg','t72-3','blankFlowerImage.png','Other','Holiday Best Sellers',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-a571-35aa-458a-8f72d70b95fe\">A truly sophisticated rose garden befitting an uptown apartment, this modern rose arrangement pairs dark orange roses with soft peach roses in a dark bamboo vase. Perfectly arranged pitta negra and myrtle add to the upscale look.</span></p>','Roses','14\" W x 9 1/2\" H','blankFlowerImage.png',72.95,62.95,82.95,72.95),('Colorful and Chic','t74-1.jpg','t74-1','blankFlowerImage.png','Other','',72.95,62.95,'<p><span id=\"docs-internal-guid-95219994-a555-ce31-b91e-48421ae29f0a\">Colorful and chic, this stunning arrangement featuring roses and other favorites is sure to impress!</span></p>','Roses|Assorted','13\" W x 12\" H','blankFlowerImage.png',82.95,72.95,92.95,82.95),('Petals of Love','t8-1.jpg','t8-1','t8-1_d.jpg','Anniversary','Anniversary',72.95,62.95,'<p>Show her how much you love her with this beautiful arrangement of pink lilies and elegant white roses</p>','Roses|Lillies|Assorted','15 1/2\" W x 18\" H','t8-1_p.jpg',82.95,72.95,92.95,82.95),('Exotic Love','t81-2.jpeg','t81-2','t81-2_d.jpeg','Other','',57.95,47.95,'<p><span id=\"docs-internal-guid-95219994-a573-392d-23bd-36fc42c3739f\">Send someone on a tropical honeymoon - if only in their mind - with this exotic, romantic gift. Delicate purple orchids are presented with tropical leaves and ferns in a chic plum-colored glass cube.</span></p>','Orchids','12 1/4\" W x 16 1/2\" H','blankFlowerImage.png',72.95,62.95,87.95,77.95),('New Sensations','t82-3.jpeg','t82-3','t82-3_d.jpeg','Other','Mother\'s Day',122.95,112.95,'<p dir=\"ltr\">Like a girl\'s getaway to the tropics! Feminine flowers in tropical pastels brighten her day - and her feng shui. She\'ll love the beautiful serenity and balanced, Zen-like feel of the lush pink and green blooms. Perfect for spring, it\'s currently featured in O, The Oprah Magazine, on its O List.</p>','Roses|Tulips|Hydrangeas|Orchids|Assorted','13\" W x 14\" H','blankFlowerImage.png',142.95,132.95,162.95,152.95),('Isn\'t It Romantic','t9-1.jpeg','t9-1','blankFlowerImage.png','Anniversary','Anniversary',97.95,87.95,'<p dir=\"ltr\">Gorgeous, gorgeous, gorgeous! This lush natural arrangement of royal roses, lilies, lisianthus, sweet pea and stock is stunning in its variety and color palette. Not to mention its fabulous fragrance!</p>','Roses|Lillies|Assorted','19\" W x 17 1/2\" H','blankFlowerImage.png',107.95,97.95,117.95,107.95),('Delicate Dozen','t9-2.jpeg','t9-2','blankFlowerImage.png','Anniversary','Anniversary',64.95,54.95,'<p dir=\"ltr\">An entirely feminine and rather modern take on the classic dozen roses, this innocent bouquet of blushing roses is simply breathtaking. A versatile choice for an anniversary or anytime you want to send your very best.</p>','Roses','14\" W x 16 1/2\" H','blankFlowerImage.png',84.95,74.95,104.95,94.95),('Madly in Love','t9-3.jpg','t9-3','t9-3_d.jpg','Anniversary','Anniversary',62.95,52.95,'<p><span id=\"docs-internal-guid-95219994-9486-05e1-4951-3efb358e8c0a\">Romantic roses in passionate shades of red, pink and purple express love and devotion to that special someone. Dense and dramatic, the classic blooms look especially chic in our modern red cube vase.</span></p>','Roses','11\" W x 10\" H','t9-3_p.jpg',72.95,62.95,82.95,72.95),('Imperial Purple Orchid','t98-1.jpg','t98-1','blankFlowerImage.png','Other','',64.95,54.95,'<p><span id=\"docs-internal-guid-95219994-a540-0073-e3a9-2a3e4272f832\">Send Zen. A graceful purple phalaenopsis orchid plant potted in a modern bamboo container is an enchanting gift for any occasion.</span></p>','Orchids','13\" W x 22 1/2\" H','blankFlowerImage.png',0,0,0,0),('Opulent Orchids','t98-2.jpeg','t98-2','blankFlowerImage.png','Other','',124.95,114.95,'<p dir=\"ltr\">Send Zen. A graceful white phaleanopsis orchid plant potted in a modern bamboo container is an enchanting gift for any occasion.</p>','Orchids','11 1/2\" W x 25 1/2\" H','blankFlowerImage.png',0,0,0,0),('Blossoming Romance','tev09-1.jpeg','tev09-1','tev09-1_d.jpeg','Other','',64.95,54.95,'<p>&nbsp;This soft yet stunning bouquet is sure to brighten her day!&nbsp; A gorgeous mix of pink spray roses, white lilies, and other favorites is the perfect way to show her how special she is!</p>','Roses|Lillies|Assorted','17\" W x 17\" H','tev09-1_p.jpeg',74.95,64.95,84.95,74.95),('Your Sweet Smile','tev11-1.jpg','tev11-1','tev11-1_d.jpg','Other','',54.95,44.95,'<p><span id=\"docs-internal-guid-95219994-a537-87f7-6c64-bde51194fdee\">Let us deliver the glorious gift of sunshine to someone you love. They\'ll adore the yellow and white roses beautifully presented in a sparkling glass vase. The bouquet is called \"Your Sweet Smile.\" You\'re sure to get a big one in return.</span></p>','Roses|Carnations|Assorted','12 1/2\" W x 14\" H','tev11-1_p.jpg',64.95,54.95,74.95,64.95),('Smile for Me','tev11-3.jpeg','tev11-3','tev11-3_d.jpeg','Other','',44.95,34.95,'<p dir=\"ltr\">Color their week happy with this blazing array of hot pink roses, orange spray roses, purple carnations and more in a sparkling glass bubble bowl. A sweet gift for a birthday, anniversary or any loving occasion. They\'ll be thrilled.</p>','Roses|Carnations|Assorted|Other','12 3/4\" W x 11\" H','blankFlowerImage.png',54.95,44.95,64.95,54.95),('Pretty Please','tev12-4.jpeg','tev12-4','tev12-4_d.jpeg','Other','',29.99,19.99,'<p dir=\"ltr\">Looking for the prettiest bouquet in town? We\'ve got the perfect all-around choice! Pretty Please is a flower bouquet with all the right stuff - a lovely mix of fresh flowers in breezy shades of pink, white, lavender and more at a wonderfully reasonable price, all tied up with a big pink bow. A great way to make someone smile.</p>','Roses|Daisies|Assorted|Other','11 1/2\" W x 15\" H','tev12-4_p.jpeg',39.95,29.95,49.95,39.95),('Enduring Passion','tev12-7.jpeg','tev12-7','tev12-7_d.jpg','Anniversary','Valentine\'s Day',54.95,44.95,'<p dir=\"ltr\">Many a heart has been won with a dozen luscious red roses. If there\'s a heart you\'d like to win or re-win, you can\'t go wrong with this legendary gift of love. Contact us in the morning and we can deliver for you - really deliver for you - in the afternoon too.</p>','Roses','14 1/2\" W x 15 3/4\" H','tev12-7_p.jpg',74.95,64.95,94.95,84.95),('Steal My Heart','tev13-3.jpg','tev13-3','blankFlowerImage.png','Other','Valentine\'s Day',89.95,79.95,'<p><span id=\"docs-internal-guid-95219994-a55c-db05-899a-c1801df7dd37\">True romance! This unique take on the classic red rose bouquet features lavender waxflower for an ultra-feminine touch. It\'s an original way to celebrate your one-of-a-kind love.</span></p>','Roses','12\" W x 12\" H','blankFlowerImage.png',99.95,89.95,109.95,99.95),('Upsy Daisy','tev13-4.jpeg','tev13-4','tev13-4_d.jpeg','Other','',29.99,19.99,'<p dir=\"ltr\">What could be sweeter than a cheerful yellow vase filled with white and yellow daisies? Can\'t think of anything? Then choose this sunny bouquet. It will brighten their day.</p>','Daisies','13\" W x 15\" H','tev13-4_p.jpeg',39.95,29.95,49.95,39.95),('Perfectly Pastel','tev13-5.jpeg','tev13-5','tev13-5_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">\"Graceful and gorgeous\" describes this stunning array of pastel flowers in a charming lavender vase tied with a pink satin ribbon. It\'s almost too pretty for words. But you\'ll hear many words of praise for sending it.</p>','Roses|Lillies|Carnations|Assorted|Other','13\" W x 14 1/2\" H','tev13-5_p.jpeg',49.95,39.95,59.95,49.95),('Make A Wish','tev13-6.jpeg','tev13-6','tev13-6_d.jpeg','Other','',32.95,22.95,'<p dir=\"ltr\">All their wishes will come true when they receive this bright and sunny flower arrangement - a summery mix of yellow daisy chrysanthemums, purple asters, red and orange carnations and more, adorned with a cheerful green plaid bow. Send one today, and make someone\'s day!</p>','Daisies|Carnations|Assorted|Other','10 1/2\" W x 12 1/4\" H','tev13-6_p.jpeg',42.95,32.95,52.95,42.95),('Sweet Thoughts','tev13-7.jpg','tev13-7','tev13-7_d.jpg','Other','',39.95,29.95,'<p><span id=\"docs-internal-guid-95219994-a534-1730-e2df-eba17b2e42a9\">A graceful heart of bear grass... tied with purple waxflower blossoms... forms a heart that appears to float above the velvety red roses in this delightful bouquet, arranged in a ruby-red cube vase. Send this beautiful floral arrangement to someone you love, and they\'ll think sweet thoughts about you!</span></p>','Roses|Assorted',' 9 1/2\" W x 10\" H','tev13-7_p.jpg',49.95,39.95,59.95,49.95),('Blooming Elegance','tev155-1.jpg','tev155-1','tev155-1_d.jpg','Other','Holiday Best Sellers',69.95,59.95,'<p><span id=\"docs-internal-guid-95219994-a53b-cebb-ae22-4cd50c604280\">Stylish and elegant, this&nbsp;blend of&nbsp;roses, gerberas,&nbsp;hydrangeas and carnations is perfect for any occasion!</span></p>','Roses|Hydrangeas|Gerberas|Carnations|Assorted','10\" W x 11\" H','tev155-1_p.jpg',79.95,69.95,89.95,79.95),('Radiant Roses','tev19-1.jpg','tev19-1','tev19-1_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a55e-3a70-582d-0a744f3a8a5e\">&nbsp;This radiant bouquet features hot pink roses and dark red spray roses are arranged in our violet cube</span></p>','Roses|Carnations|Assorted','11 1/2\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Garden Romance','tev20-1.jpeg','tev20-1','tev20-1_d.jpeg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a9d8-0ff9-561e-1af92a5f5c0c\">Va-va-bloom! This stunning arrangement of purple hydrangea, light pink spray roses and white asiatic lilies is perfectly presented in our violet cube.</span></p>','Roses|Lillies|Hydrangeas|Assorted','13\" W x 13\" H','tev20-1_p.jpeg',59.95,49.95,69.95,59.95),('Splendid Surprise','tev20-2.jpg','tev20-2','tev20-2_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a550-86d5-626d-99d7c606e872\">Lovely at first sight. Green miniature hydrangea and lavender roses are a lovely combination! This extra-sweet bouquet comes in our fuchsia glass cube.</span></p>','Roses|Hydrangeas|Carnations|Assorted','10 1/2\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Make Her Day','tev20-3.jpeg','tev20-3','tev20-3_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">This sweet bouquet includes green miniature hydrangea and light pink spray roses arranged in our citrus green glass cube.</p>','Roses|Hydrangeas|Carnations|Assorted','11 1/4\" W x 11\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Blush of Love','tev21-1.jpeg','tev21-1','tev21-1_d.jpeg','Anniversary','Valentine\'s Day',59.95,49.95,'<p dir=\"ltr\">Make her blush with this romantic mix of fragrant lilies and lush hydrangea in dreamy shades of pink. Presented in our elegant couture glass vase, this beautiful bouquet is affection perfection!</p>','Lillies|Hydrangeas|Carnations|Assorted|Other','14\" W x 17\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95),('So Enchanting','tev23-5.jpeg','tev23-5','tev23-5_d.jpeg','Other','',64.95,54.95,'<p dir=\"ltr\">Paint her world with enchantment! A palette of rich red roses and elegant pink lilies creates a simply stunning statement of love and devotion. It\'s a masterpiece she\'ll always remember.</p>','Roses|Lillies|Assorted','16 1/2\" W x 19\" H','blankFlowerImage.png',74.95,64.95,84.95,74.95),('Full of Love','tev24-2.jpeg','tev24-2','tev24-2_d.jpeg','Other','Mother\'s Day',39.95,29.95,'<p>It\'s beauty-full! Bursting with tantalizing tulips and radiant roses, this delightful pink arrangement brings spring joy to that special someone.</p>','Roses|Tulips|Carnations|Assorted','12\" W x 14 1/2\" H','tev24-2_p.jpeg',49.95,39.95,59.95,49.95),('Spring Romance','tev24-4.jpeg','tev24-4','tev24-4_d.jpeg','Other','Holiday Best Sellers',49.95,39.95,'<p dir=\"ltr\">Spring is the season for romance! Brimming with exquisite tulips and alstroemeria, this bouquet in a classic glass hurricane celebrates the beauty of the season.</p>','Tulips|Assorted|Other','13 1/2\" W x 14 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Sapphire Skies','tev25-3.jpeg','tev25-3','tev25-3_d.jpeg','Other','',49.95,39.95,'<p dir=\"ltr\">Like gazing into a clear blue sky, this serene arrangement soothes the soul and cheers the heart. Its creamy roses and snowy lilies are arranged in our dazzling sapphire cube.</p>','Roses|Lillies|Carnations|Assorted','12\" W x 11 1/2\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Meant To Be','tev28-1.jpeg','tev28-1','tev28-1_d.jpeg','Other','',59.95,49.95,'<p dir=\"ltr\">Lush and lovely, yet delightfully delicate, the pale pinks, yellows and whites of this gorgeous bouquet look like they were made for one another. Just like the two of you&hellip;</p>','Roses|Carnations|Assorted|Other','16\" W x 17 1/2\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95),('Pure Love','tev30-2.jpg','tev30-2','tev30-2_d.jpg','Other','',59.95,49.95,'<p><span id=\"docs-internal-guid-95219994-a563-9840-5ed0-a56bc774fadf\">Pure love deserves the pure luxury of this wondrous white bouquet. Fragrant lilies, lush hydrangea and delicate alstroemeria are carefully arranged in our Couture vase for an elegant look they will adore.</span></p>','Lillies|Hydrangeas|Carnations|Assorted','14\" W x 17\" H','blankFlowerImage.png',69.95,59.95,79.95,69.95),('Pink Elegance','tev31-3.jpeg','tev31-3','tev31-3_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Perfectly pink perfection. Send this sweet, sentimental bouquet on her birthday, Mother\'s Day, or&hellip; any day you want to make her feel extra special.</p>','Carnations|Assorted|Other','12\" W x 16\" H','tev31-3_p.jpeg',49.95,39.95,59.95,49.95),('Sincerely Yours','tev31-5.jpeg','tev31-5','tev31-5_d.jpeg','Other','',39.95,29.95,'<p dir=\"ltr\">Pamper her with pale pink roses, pristine white daisies&hellip; and your thoughtfulness. A sweet, simple statement of your sincere love, this light, delicate bouquet will make her smile.</p>','Roses|Daisies|Assorted|Other','14\" W x 19\" H','blankFlowerImage.png',49.95,39.95,59.95,49.95),('Turn Up The Pink','tev33-1.jpg','tev33-1','tev33-1_d.jpg','Other','',49.95,39.95,'<p><span id=\"docs-internal-guid-95219994-a547-0bcd-40e9-7d7238384b4a\">Pop goes the pink! A gorgeously chic gift for any occasion, this perky pink and orange bouquet is pure fun, especially when it\'s hand-delivered in our fabulous fuchsia Cube!</span></p>','Roses|Gerberas|Carnations|Assorted','11\" W x 11\" H','blankFlowerImage.png',59.95,49.95,69.95,59.95),('Pink Grace','tev38-1.jpeg','tev38-1','tev38-1_d.jpeg','Other','',54.95,44.95,'\r\n<p dir=\"ltr\" style=\"line-height: 1; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11px; font-family: Arial; color: #373737; background-color: transparent; font-weight: normal; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Celebrate a fabulous woman in your life with a beautiful mixed bouquet featuring pink roses and arranged in a perky pink cube. She\'ll be thrilled with this charmingly feminine gift - and touched by your thoughtfulness because it is also a gift for others!</span></p>','Roses|Carnations|Assorted','13 1/2\" W x 14\" H','tev38-1_p.jpeg',64.95,54.95,74.95,64.95),('Sophisticated Lady','tev40-1.jpeg','tev40-1','tev40-1_d.jpeg','Other','',64.95,54.95,'<p>A wonderful arrangement for any occasion, this blend of blooms is sure to brighten her day!&nbsp; Featuring hydrangeas, roses, and lilies in a light pink vase</p>','Roses|Lillies|Hydrangeas|Gerberas|Assorted','14\" W x 18\" H','tev40-1_p.jpeg',74.95,64.95,84.95,74.95),('Fresh Flourish','tev40-2.jpeg','tev40-2','tev40-2_d.jpeg','Birthday','Mother\'s Day',59.95,49.95,'<p><span id=\"docs-internal-guid-95219994-a9d9-2ce5-168f-4882218d8c08\">No one can resist the beauty of this bright bouquet! A sublime way to celebrate any occasion, this special delivery blends hot pink and lavender roses with pink lilies and lime green button mums for a look that\'s pure heaven. It\'s all artfully arranged in our exclusive, lovely lavender glass vase they\'ll always treasure.</span></p>','Roses|Lillies|Assorted','15 1/2\" W x 19 3/4\" H','tev40-2_p.jpeg',69.95,59.95,79.95,69.95),('Love and Devotion','trs01-1.jpeg','trs01-1','blankFlowerImage.png','Anniversary','Valentine\'s Day',124.95,114.95,'<p dir=\"ltr\">Sweep her off her feet with two dozen red roses in a gracefully flared clear glass vase. Whether for an anniversary, birthday or just because, this gorgeous romantic bouquet of 24 roses will win her heart all over again.</p>','Roses','15\" W x 22\" H','blankFlowerImage.png',149.95,139.95,174.95,164.95),('Rose Rapture','trs03-1.jpeg','trs03-1','blankFlowerImage.png','Anniversary','Anniversary',194.95,184.95,'<p dir=\"ltr\">Feminine and fabulous, this spectacular bouquet of lavender and pink roses in a chic cylinder vase is guaranteed to leave her speechless. Until she says how much she loves you for choosing this absolutely incredible array.</p>','Roses','17\" W x 17\" H','blankFlowerImage.png',214.95,204.95,234.95,224.95);

--
-- Table structure for table `profile`
--

CREATE TABLE `profile` (
  `memberID` varchar(255) NOT NULL,
  `profileID` varchar(244) NOT NULL,
  `fName` varchar(300) NOT NULL,
  `lName` varchar(300) NOT NULL,
  `homeAddress` varchar(400) NOT NULL,
  `homeCity` varchar(100) NOT NULL,
  `homeState` varchar(100) NOT NULL,
  `homeZip` varchar(20) NOT NULL,
  `officeAddress` varchar(400) NOT NULL,
  `officeCity` varchar(100) NOT NULL,
  `officeState` varchar(100) NOT NULL,
  `officeZip` varchar(20) NOT NULL,
  `birthday` date NOT NULL,
  `anniversary` date NOT NULL,
  UNIQUE KEY `profileID` (`profileID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `profile`
--

INSERT INTO `profile` VALUES ('m_74276217611','10471307683','Luisa','Foyo','430 Grand Bay Dr. Apt. 201','Key Biscayne','FL','33149','','','','','2014-08-25','2017-11-24'),('m_53506287314','10925327521','Kimberly ','Grove','2434 40th St NE','Canton','OH','44705-2858','','','','','0000-00-00','0000-00-00'),('m_69729330337','110756830431','Kat','Shnayder','34 Westgate Road, 4','Chestnut Hill','MA','02467','','','','','0000-00-00','0000-00-00'),('m_650332025936','112534027713','Brianna','Savage','','','','','','','','','0000-00-00','0000-00-00'),('m_80389165017','12128237984','Gabriella ','Aballi Miranda','521 Santurce Ave ','Coral Gables','FL','33143','','','','','0000-00-00','2017-11-24'),('m_411516331984','1261307309','Louise','KreinerREINER','PO Box 949\r\n','Amesbury','MA','01913','60 Merrinac St., Unit 608','Amesbury','MA','01913','2017-10-07','0000-00-00'),('m_740439815654','130843815814','Jonathan','Gesin','','','','','','','','','0000-00-00','0000-00-00'),('m_127735428356','13365368663','jennie','mulligan','','','','','','','','','0000-00-00','0000-00-00'),('m_11534626143','1368909684','yvonne','munoz','','','','','630 Bay blvd suite 101','chula vista','CA','9190','0000-00-00','2017-04-19'),('m_463767121689','141019621845','Tracy','Maher','','','','','','','','','0000-00-00','0000-00-00'),('m_246724423146','143662323362','Shifra','Erez','9970 Guilford Rd Apt 201','Jessup','MD','20794','','','','','0000-00-00','0000-00-00'),('m_52726778659','1476829512','Meagan','Anderson','','','','','4242 Sunset Dr','San Angelo','TX','76904','2017-10-27','0000-00-00'),('m_739297130709','148884330909','Dawn','Willis','','','','','','','','','0000-00-00','0000-00-00'),('m_58968002402','15080262613','Laura','Henry','909 Road 68','Pasco','WA','99301','','','','','0000-00-00','2017-11-24'),('m_25904521708','154608823096','Donna','Shafer','','','','','410 W Miami Ave IN ','Logansport','IN','46947','2017-02-20','0000-00-00'),('m_68472878476','164077421500','Kelley','Graham','5878 Cumbre Vista Way','Colorado Springs','CO','80924','','','','','0000-00-00','0000-00-00'),('m_56780819617','16995819660','k','kol','165 E 56th St','long beach','CA','90805','','','','','0000-00-00','2017-03-09'),('m_93956273199','17843123951','Jenna','Huhtala','844 N Bennett','Geneva ','IL','60134','','','','','0000-00-00','2017-04-10'),('m_363220119702','180420620091','Sailaja','Padamati','3916 E. Ridgeview St.','Springfield','MO','65809','','','','','2017-08-28','0000-00-00'),('m_24982702853','18266408513','Rosemary','Dixon','','','','','','','','','0000-00-00','0000-00-00'),('m_448735829889','182894530006','Dina','Abdul-fattah','9057 E Mississippi Ave Apt 21-103','Denver','CO','80247','','','','','2018-04-03','2018-02-05'),('m_209725321781','18343222287','Carleigh','Chaffins','78 Hamilton avenue','Columbus','OH','43203','','','','','0000-00-00','0000-00-00'),('m_93215047850','18496808562','Helen','Gambrah','','','','','','','','','0000-00-00','0000-00-00'),('m_43049754012','193946414486','Suzie','Garcia','50 Menores Ave\r\nApartment 528','Coral Gables','FL','33134','','','','','2015-08-11','2017-11-24'),('m_630556323890','203759923798','vivian ','nunez menocal','','','','','','','','','0000-00-00','2017-11-24'),('m_23410241332','20579915550','Cheron','Willis','127 Douglas St. APT A','Bakersfield','CA','93308','','','','','2018-03-12','0000-00-00'),('m_786773630732','209922032425','Cliff','Ryan','','','','','','','','','0000-00-00','2017-11-24'),('m_28833159756','213722510110','Tesia','Frey','','','','','','','','','0000-00-00','0000-00-00'),('m_18131815426','21638006565','Debbie','Mataisz','','','','','','','','','0000-00-00','0000-00-00'),('m_523211330346','22323342864','Vinh','Ha','','','','','','','','','0000-00-00','0000-00-00'),('m_82659497093','22592527481','Michelle ','Chandler','','','','','','','','','0000-00-00','2017-11-24'),('m_877608619474','232113619737','Sunny','Love','','','','','','','','','0000-00-00','0000-00-00'),('m_415813613132','23241915890','Tawnya','Freckles','','','','','','','','','0000-00-00','2017-11-24'),('','23675437817','Yvonne','Munoz','','','','','630 Bay Blvd suite 101','Chula Vista','CA','9190','0000-00-00','2017-04-19'),('m_523211330346','23751257813','','','','','','','','','','','0000-00-00','0000-00-00'),('m_56142347774','23783878508','Ranjith','Sc','1153 Doyle circle, Santa Clara, CA, 95054','Santa clara','CA','95054','','','','','2017-12-01','0000-00-00'),('m_881109812684','245871613013','Martha','Marrero','305 East 14 Street','Hialeah','FL','33010','','','','','2015-12-01','2017-11-24'),('m_461356832647','246471327','Katherine','Brown','','','','','','','','','0000-00-00','0000-00-00'),('m_103721428407','248304330625',' Helen','Gambrah','','','','','','','','','0000-00-00','0000-00-00'),('','253885121135','','','','','','','','','','','0000-00-00','0000-00-00'),('m_91305986403','26475386604','Emma','Yuan','','','','','','','','','0000-00-00','0000-00-00'),('m_87637613606','27189017124','Sahar','Zodeh','','','','','Weight Watchers International, Inc.\r\n675 Avenue of the Americas, 6th Floor','New York','NY','10010','0000-00-00','2017-11-24'),('m_723953820790','277137120933','Crystal ','Washington ','','','','','','','','','0000-00-00','0000-00-00'),('m_24894001062','27739311160','Linda','Bosman','','','','','asdf','asdf','AK','12312','0000-00-00','0000-00-00'),('m_694382927045','278680428804','Dottie','Gattis','157 N. Gaines Road','Cedar Creek','TX','78612','','','','','2017-11-06','0000-00-00'),('m_660710427844','281550128270','Jessica','Caiafa','2457 Collins Avenue  #1703','Miami Beach','FL','33140','','','','','2017-02-25','2017-11-24'),('m_81362171978','29135892267','Cayla ','Collins','122 glyn oaks drive ','Boiling springs ','SC','29316','','','','','0000-00-00','0000-00-00'),('m_90916806343','29444356533','Sarah','Enderes ','','','','','1672 Route 715, 4 years','Tannersville','PA','18360','0000-00-00','0000-00-00'),('m_465876329642','298955529801','Aneesh','D','8810 w. Rovey','Glendale','AZ','Az','','','','','2017-10-30','0000-00-00'),('m_955065614142','303605015604','Ouida','Boyd','','','','','','','','','0000-00-00','2017-11-24'),('m_284731126668','30521417255','Jessica ','Fitzgerald','','','','','4200 West Flagler St','Miami','FL','33134','0000-00-00','2017-11-24'),('m_458531629993','309313630328','Carolyn','Perry','','','','','','','','','0000-00-00','0000-00-00'),('m_523211330346','31884962869','Vinh','Ha','','','','','','','','','0000-00-00','0000-00-00'),('m_188182830368','321609222891','etwdt','tewryytrew','','','','','','','','','0000-00-00','2017-11-24'),('m_704322432645','329797132766','Vanessa','Capistran','48 Jackson Street','New Rochelle','NY','10801','','','','','2017-10-10','0000-00-00'),('m_495198216076','330207121204','Dorothy','Costello','591 Piping Plover Lane','Kiawah island','SC','29455','','','','','0000-00-00','0000-00-00'),('m_14539623948','33465476196','Jesus','Negron','','','','','','','','','0000-00-00','2017-11-24'),('m_881109812684','3355012879','Maria','DiGiorgio','1795 SW 16 Street','Miami','FL','33145','ADT Law Department\r\n1501 Yamato Road','Boca Raton','FL','33431','2015-10-26','2017-11-24'),('m_34796725159','339983025225','Allyson','Gonzalez','733 Palermo Ave','Coral Gables','FL','33134','','','','','2015-03-24','2017-11-24'),('m_634225029045','341754632134','Pia','Roy','220 East 24th St, Apt 1F','New York','NY','10010','','','','','2017-09-20','0000-00-00'),('m_556250419137','347315319434','Lise','Sentell','615 Perry Way','Zelienople','PA','16063','','','','','0000-00-00','0000-00-00'),('m_1411944461','35309021990','Tereza','Maximo','2118 Sherbrook Park Ln','Katy','TX','77449','','','','','2018-01-16','0000-00-00'),('','3546930384','','','','','','','','','','','0000-00-00','0000-00-00'),('m_704940918827','356551319172','Joanna ','Samolej ','8745 elm drive','des plaines','IL','60016','','','','','2017-04-09','0000-00-00'),('m_82458004665','36237795020','Andi','Holdt','1732 emerald dr apartment 6','davenport','IA','52804','','','','','0000-00-00','0000-00-00'),('m_511589529163','369817429407','Lisa ','Meyer','510 Wood Street','Coraopolis','PA','15108','','','','','0000-00-00','0000-00-00'),('m_770760111454','370592711648','Fay','Gonzalez','421 hilltop dr apt 13','Laredo','TX','78045','','','','','0000-00-00','0000-00-00'),('m_80654664944','37511526458','cathy','graser','','','','','300 W. Clay street','fredricksburg','OH','44627','0000-00-00','0000-00-00'),('m_806596810004','375165310236','Hailey ','Nichols ','','','','','','','','','0000-00-00','0000-00-00'),('m_812752922749','377673423776','Twila','DePasquale','16605 Amelia Ave','Amelia','VA','23002','','','','','2017-07-23','0000-00-00'),('m_82068335777','384229012126','Selene','Bauer','','','','','','','','','0000-00-00','0000-00-00'),('m_409597510085','384946129786','Allie','Allan','184 West 1580 North','lehi','UT','84043','','','','','0000-00-00','2017-11-24'),('m_523211330346','38601262861','Vinh','Ha','','','','','','','','','0000-00-00','0000-00-00'),('m_523211330346','38601262862','Vinh','Ha','','','','','','','','','0000-00-00','0000-00-00'),('m_2037620152','389630720259','Annmarie','Scaglione','3407 Crooks Rd','Royal Oak','MI','48023','','','','','0000-00-00','2017-11-25'),('m_448735829889','398976027875','Dina','Abdul-fattah','','','','','','','','','0000-00-00','0000-00-00'),('m_4529843000','40261433152','Ronda','Carrington','','','','','','','','','0000-00-00','0000-00-00'),('m_911747029281','403586314482','Ashley','Priest','','','','','Herssein Law Group\r\n12000 Biscayne Blvd, Ste 402\r\n','North Miami','FL','33181','2015-08-24','2017-11-24'),('m_638116032671','41833318322','Veronica Carrillo','Espinosa','2530 SW 5 Ave','miami','FL','33129','','Miami Lakes','','3301','2015-10-09','2017-11-24'),('m_80394021862','429426822579','Jasmine','Castillo','','','','','','','','','0000-00-00','0000-00-00'),('m_567723215614','431079615850','Ana','Herrera','','','','','','','','','0000-00-00','0000-00-00'),('m_876203323488','440136824898','Haley','Dirks','363 Inverness Pkwy, APT 8202','Englewood','CO','80112','','','','','0000-00-00','0000-00-00'),('m_898961314696','445050512658','Inez','','','','','','','','','','0000-00-00','2017-11-24'),('m_818011514531','459858414965','Vivian','Tavares','','','','','','','','','0000-00-00','2017-11-24'),('m_616682018429','462978819258','Paige ','Asher','473 Mendez Ave','Coral Galbes','FL','33146','','','','','0000-00-00','2017-11-24'),('m_742479210051','463570110113','Lela','Britt','1511 Scotts Landing','Morehead City','NC','28557','','','','','2018-04-16','0000-00-00'),('m_13144051796','464999914066','Mr. ','Calderone','174 oak st. ','Elmhurst','IL','60126','','','','','0000-00-00','0000-00-00'),('m_957372417374','474163217785','Hazel ','Day','858 Davis chapel rd ','Lafollette ','TN','37766','858 Davis chapel rd ','Lafollette ','TN','37766','0000-00-00','0000-00-00'),('m_924209721883','47464623657','Julie Anne','Miranda','520 Tibidabo Ave.','Coral Gables','FL','33143','17615 SW 97 Avenue (Franjo Rd.)','Palmetto Bay','FL','33157','2015-06-01','2017-11-24'),('m_960517630110','477308431658','Patrice','Payeur','','','','','','','','','0000-00-00','2017-11-24'),('m_13144051796','48422728761','Rosie ','Bledsoe','174 oak st. ','Elmhust','IL','60126','','','','','0000-00-00','0000-00-00'),('m_746369228386','485013128762','Alexa ','Essig','10305 SW 132 Street','Miami','FL','33176','','','','','0000-00-00','2017-11-24'),('m_62783217495','48517888854','Ciarra','Butler','','','','','','','','','0000-00-00','0000-00-00'),('m_769750111290','485712611403','Kimberly','Teggart','','','','','','','','','0000-00-00','2017-11-24'),('m_209725321781','488634421869','Carleigh','Chaffins','78 Hamilton avenue ','Columbus','OH','43203','','','','','0000-00-00','0000-00-00'),('m_70395625072','49369055284','Debora','Kaczynski','5391 Pinnacle Court','Ann Arbor','MI','48108','','','','','0000-00-00','0000-00-00'),('m_786773630732','50433011735','','','','','','','','','','','0000-00-00','2017-11-24'),('m_433952414569','504675316699','Robert ','Fewell','930 S. Greenway Drive Coral Gables','','FL','33134','','','','','0000-00-00','2017-11-24'),('m_319023616343','507594817315','Cathy ','Hubner','','','','','','','','','2016-08-15','2017-11-24'),('m_523211330346','51521032854','Vinh','Ha','','','','','','','','','0000-00-00','0000-00-00'),('m_25904521708','522675023801','Lois','Hills','4996 Mohawk Ave','Clarkston','MI','48348','','','','','2017-08-18','0000-00-00'),('m_39062101234','525523913737','Marc','Fowler','','','','','','','','','0000-00-00','0000-00-00'),('m_448735829889','526649227250','Dina','Abdul-fattah','9057 e mississippi ave apt 21-103','Denver','CO','80247','','','','','2018-04-02','0000-00-00'),('m_2251045909','52733831813','Ingrid','Franzen','','','','','','','','','0000-00-00','0000-00-00'),('m_789260825801','528548026064','Raj Lahoti &','Sarah Churchill','380 Dollimore Rd','Encinitas','CA','92024','','','','','0000-00-00','0000-00-00'),('m_660710427844','539078933','J','Caiafa','','','','','','','','','0000-00-00','2017-11-24'),('m_138297017039','556317019944','Suzanne','Gurney','','','','','','','','','2016-08-23','2017-11-24'),('m_770760111454','556996213340','Fay','Gonzalez- Mcdonald','421 hilltop dr apt 13','Laredo','TX','78045','','','','','0000-00-00','0000-00-00'),('m_813058626019','565413627244','Bob & Cindi','Unger','9127 Weant Drive','Great Falls','VA','22066','','','','','0000-00-00','2017-06-24'),('m_208901512766','571839313692','Nissa','Rasmussen','NE 44th ST, 413','Gainesville','FL','32641','','','','','2017-12-17','0000-00-00'),('m_786773630732','571873032594','Kelsie','Fulmer','','','','','','','','','2017-08-10','2017-11-24'),('m_90321341533','57830111617','Miller','King','465 proatcio st.\r\n','Pasay','','','','','','','0000-00-00','0000-00-00'),('m_450415924423','584742024517','Lisa','Parfelt','817 North Croft Ave','West Hollywood','CA','90046','','','','','2017-05-11','0000-00-00'),('m_414495325405','585213927015','Natalia','Sanz','12735 SW 32 terrace','Miami','FL','33175','','','','','0000-00-00','2017-11-24'),('m_39671154982','58607566625','Lily ','Mogen','3559 S Bannock St #103','Englewood','CO','80110','','','','','2017-08-15','0000-00-00'),('m_64071184214','59090795925','Sofia','Fotini','1045 Piedmont Ave  NE, Apartment 407','Atlanta','GA','30309','','','','','0000-00-00','0000-00-00'),('m_634874321898','595873025123','Ashley','Gordon','','','','','','','','','0000-00-00','2017-11-24'),('m_12040110213','59676410581','Barbara','Lloyd','2221 Plymouth Street','Oshkosh','WI','54901','','','','','2018-03-13','0000-00-00'),('m_619137228470','59682830373','Amanda','Donley','6001 Roger Road','Shawnee','KS','66203','','','','','0000-00-00','2017-11-24'),('m_247240610273','598934610957','Noeliany','Cosme','','','','','','','','','0000-00-00','0000-00-00'),('m_255574331091','601646531852','Mallorie ','Sullivan','','','','','','','','','2017-07-16','0000-00-00'),('m_23410241332','60424829848','Socorro','Arteaga','1920 Radiance Dr','Bskersfield','CA','93304','','','','','0000-00-00','0000-00-00'),('m_255248714771','605118715629','Rebecca','Blauvelt','','','','','','','','','0000-00-00','0000-00-00'),('m_45006749630','610335214052','Linda','Patrick','11712 Palisades Parkway','Austin','TX','78732','','','','','0000-00-00','2017-11-24'),('m_74745313130','613036713764','hfhgf','hgfhf','','','','','','','','','2017-06-05','0000-00-00'),('m_127735428356','62081047536','Linda','Hunley','','','','','','','','','0000-00-00','0000-00-00'),('m_630556323890','621313127207','Arlette ','Nunez Menocal','','','','','4969 sw 72 Ave suite 406','Miami','FL','33156','0000-00-00','2017-11-24'),('m_902088421291','626483721586','Jasmine','Gutierrez','','','','','','','','','0000-00-00','0000-00-00'),('m_49522305327','62954914677','kim','bravo','','','','','','','','','2017-01-31','0000-00-00'),('m_90719207915','630949028913','bibi','miranda','9401 sw 97 ct','miami','FL','33176','','','','','0000-00-00','2017-11-24'),('m_63600133613','63600133680','Kimberly','Grove','2434 40th St NE','Canton','OH','44705','','','','','0000-00-00','0000-00-00'),('m_647733623443','641274623941','Kayla','Sturm','','','','','','','','','0000-00-00','0000-00-00'),('m_883065118847','64602069609','Mariana','Planes','530 SW 21st RD','Miami','FL','33129','','','','','2015-11-15','2017-11-24'),('m_613885216775','648665017127','Venita','Nunn','','','','','','','','','0000-00-00','0000-00-00'),('m_52063118150','6565966190','','','','','','','','','','','0000-00-00','2017-11-24'),('m_630556323890','658516023787','vivian ','nunez menocal','','','','','','','','','0000-00-00','2017-11-24'),('m_103721428407','664350530641',' Helen','Gambrah','','','','','','','','','0000-00-00','2017-07-07'),('m_834092428748','664977229431','Kaley','Wennerholm','113 Woodvalley drive','Kingsland','GA','31548','','','','','0000-00-00','0000-00-00'),('m_27739311165','67573651357','Linda','Bosman','','','','','','','','','0000-00-00','0000-00-00'),('m_39062101234','6759312469','Pam','Felch','15 Devonshire Rd.','Pleasant Ridge','MI','48069','','','','','2018-01-23','0000-00-00'),('m_294729213197','681019911482','Testb','Testb','','','','','','','','','2016-04-29','2017-11-24'),('m_488800610816','681019911487','Andrea ','Gonzalez ','425 NE 22 ST APT 2502','Miami ','FL','33137','','','','','0000-00-00','2017-11-24'),('m_80059314263','68263926480','Melissa','Heckman','','','','','','','','','0000-00-00','0000-00-00'),('m_287665632476','683198132545','tewt','werw','100 EDENFIELD AVENUE','WATERTOWN','MA','02472','','','','','2015-10-14','2017-11-24'),('m_411516331984','683472932745','Jamie','Goodman','','Deerfield','IL','60015','Aspire Group\r\n1320 Carol Ln','Deerfield','IL','60015','2017-10-07','0000-00-00'),('m_62077634583','68991325907','Torin ','Kearney','','','','','','','','','0000-00-00','0000-00-00'),('m_1588640451','69156626741','allen','night','2833 Junction Ave, Suite 100','San Jose','CA','95134','','','','','0000-00-00','2017-11-24'),('m_23410241332','697546811716','Heather','Tramel','1908 Stillman Ave','Bakersfield','CA','93304','','','','','0000-00-00','0000-00-00'),('m_527447825811','703788326125','Hailey','Moss','','','','','','','','','0000-00-00','0000-00-00'),('m_77011933152','70626063618','Kayla','Harper','11850 SW Iron Horse Ln','Beaverton','OR','97008','','','','','2017-11-17','0000-00-00'),('m_52915379126','712103010422','Jeanne','Butler','','','','','','','','','0000-00-00','0000-00-00'),('m_523211330346','71423231903','Christina','Piedrahita ','','','','','','','','','0000-00-00','0000-00-00'),('m_408414125054','716269825323','Samir and Anam','Mazharuddin','1011 Sunningdale','Richardson','TX','75081','','','','','0000-00-00','0000-00-00'),('m_79863854741','72121864869','Denise','Uhlhorn','16715 Redcliff Dr','Huntersville ','NC','28078','','','','','0000-00-00','2019-01-19'),('m_39288604755','72589045137','caRyn','Hitt','3950 West 75th Street  #1118','Bradenton','FL','34209','','','','','2015-03-02','2017-11-24'),('m_92179539191','72897704138','Jamie','Schneider','4939 New England Blvd','New Port Richey','FL','34652','','','','','0000-00-00','0000-00-00'),('m_688777228921','735426629003','Karen','Monuszko ','1311 N Duke Street','Durham ','NC','27701','','','','','0000-00-00','0000-00-00'),('m_72053258278','73641128425','Cassidy','Sapot','','','','','','','','','0000-00-00','0000-00-00'),('m_28654583687','74179544058','Mary','Martindale','270 Stuyvesant Drive','San Anselmo','CA','94960','','','','','0000-00-00','2017-11-24'),('m_92566123910','747003211920','Reshettia ','Lucas ','4282 new hope road','Dekalb ','MS','38328','','','','','0000-00-00','2017-11-24'),('m_24982702853','74990199989','Kathy','Machol','','','','','','','','','0000-00-00','0000-00-00'),('m_872187430504','758031431324','Manju','Thakar','7109 Banjo Court','Columbia','MD','21045','','','','','0000-00-00','0000-00-00'),('m_72532883826','75856664177','Patty','Collins','','','','','','','','','2017-09-27','0000-00-00'),('m_186288913294','758655314159','Namrata','Jha','1 Maple St Apt 1405','Redwood City','CA','94063','500 Howard Street, Suite 425','San Francisco','CA','94105','0000-00-00','0000-00-00'),('m_895672229832','761346132152','Laura','Kwasniewski','2 Regency Plaza, Apt 206W','Providence','RI','02903','','','','','2015-09-27','2017-11-24'),('m_228797732507','766102129551','Dayspring','Cabaniss','','','','','','','','','0000-00-00','2018-03-20'),('m_14090845319','76786356295','Gabi ','Ocner','','','','','','','','','0000-00-00','0000-00-00'),('m_39062101234','768040513527','Lore','Felch','','','','','','','','','2018-05-09','0000-00-00'),('m_913235220342','774961420991','Emma','Yuan','35594 Woodbridge Pl.','Fremont','CA','94536','','','','','2018-04-07','0000-00-00'),('m_82068335777','78177948300','Selene','Bauer','3894 Juniata Gap Road','Altoona','PA','16601','','','','','0000-00-00','0000-00-00'),('m_56780819617','78236519659','k','kol','','','','','','','','','0000-00-00','0000-00-00'),('m_610203713993','78596148688','Christine','Zummo','','','','','','','','','0000-00-00','0000-00-00'),('m_610203713993','78596148689','Christine','Zummo','','','','','','','','','0000-00-00','0000-00-00'),('m_52063118150','786653917346','','','','','','','','','','','0000-00-00','2017-11-24'),('m_714398924426','786989925479','Mikki','Shull','','','','','','','','','2016-09-09','2017-11-24'),('m_919257432498','79191051359','Tracey ','Jeter','','','','','180 North Stetson Ave Suite 3650','Chicago','IL','60601','0000-00-00','0000-00-00'),('m_227141432323','792899026066','Ivonne ','Beautiful','','','','','','','','','0000-00-00','0000-00-00'),('m_154459529465','795319629555','Iram','Iqbal','9131 Hamilton Street','Rancho Cucamonga','CA','91701','','','','','0000-00-00','0000-00-00'),('m_924294016324','79938494690','Matthew','smisson','200 Oak STreet','Lookout Mountain','TN','37350','','','','','2017-05-27','0000-00-00'),('m_911747029281','801436215002','Maria','Llovet','195 SW 84 Ave','Miami','FL','33144','','','','','2015-05-20','2017-11-24'),('m_22417149303','82119309350','Helen','Gambrah ','','','','','','','','','0000-00-00','2017-07-07'),('m_22417149303','82119309351','Helen','Gambrah ','','','','','','','','','0000-00-00','0000-00-00'),('m_54816221625','82224244190','Reina','Hicks','','','','','Education First  Federal Credit Union','Beaumont ','TX','77706','0000-00-00','0000-00-00'),('m_523211330346','822290432186','Miriam ','Betancourt','','','','','','','','','0000-00-00','0000-00-00'),('m_64379284978','8288974852','Doshia','Mitchell','','','','','','','','','0000-00-00','0000-00-00'),('m_43049754012','83004508108','Carla','Prado-Johnsson','1925 Brickell Ave Apartment 501-D','Miami','FL','33129','','','','','0000-00-00','2017-11-24'),('m_18131815426','83391536528','Anne','Waldron','','','','','','','','','0000-00-00','0000-00-00'),('m_630554628117','834854828255','stacey','clay','4701 olentangy river rd','columbus','OH','43214','','','','','0000-00-00','0000-00-00'),('m_97589749187','84537214308','fay','gonzalez-mcdonald','421 hilltop rd apt 13','laredo','TX','78045','','','','','0000-00-00','0000-00-00'),('m_84344523516','85172834885','Gwendolyn','Ruth','','','','','78 South Rentz Street','Varnville','SC','29944','2018-01-25','0000-00-00'),('m_81973848113','85598118329','Ashley','Bevan','2932 Settlers Way Dr','Sealy','TX','77474','','','','','0000-00-00','0000-00-00'),('m_86004669167','86004669547','Ellen','Austria','3941Veselich Ave. #156','Los Angeles','CA','90039','','','','','0000-00-00','0000-00-00'),('m_64379284978','86214765799','Eunice','Hopper','9000 Father\'s Legacy, 333','Ellicott City','MD','21042','','','','','2017-01-26','0000-00-00'),('m_681711726784','862537330402','James','Camacho','','','','','','','','','0000-00-00','2017-11-24'),('m_164406724455','866270324579','Neil','Wallace','','','','','','','','','0000-00-00','0000-00-00'),('m_50576017720','867816713709','Vanessa','Ruiz','','','','','','','','','0000-00-00','2017-11-24'),('m_933180614678','867991415697','Jessica','D\'Amato','','','','','','','','','0000-00-00','0000-00-00'),('m_5045471421','87130322302','Grandma','Dill','292 Parkchester Road','Elk Grove Village','IL','60007','','','','','0000-00-00','0000-00-00'),('m_612418319465','875942120312','Sophia','Rhodes','','','','','','','','','0000-00-00','0000-00-00'),('m_924209721883','876246117762','Jorge','Miranda','520 Tibidabo Ave.','Coral Gables','FL','33143','520 Tibidabo Ave.','Coral Gables','FL','33143','2015-10-05','2017-11-24'),('m_903127016233','879026817585','Alex','Marmureanu','','','','','','','','','0000-00-00','0000-00-00'),('m_74276217611','88271017965','Maria','Vazquez','918 SW 10th Street','Miami','FL','33130','','','','','2015-07-30','2017-11-24'),('m_885655727052','888466627170','Heaven ','Ng','','','','','','','','','0000-00-00','0000-00-00'),('m_69203887616','889733918960','Gowri Sangeetha','Sivanathan','','','','','4420  Rosewood Dr.   Ste # 500','Pleasonton','CA','94588','2016-10-26','2017-11-24'),('m_55191893295','88985783547','Isabel','Garcia','','','','',' 515 North Sam Houston Pkwy E','Houston','TX','77060','0000-00-00','2017-11-24'),('m_6476064145','89054387847','Blanca','pallares','','','','','','','','','0000-00-00','2017-11-24'),('m_86416153719','8912515864','Karanbir','Sandhu','','','','','','','','','0000-00-00','0000-00-00'),('m_955065614142','893030914283','Ouidadf','Felker','729 Apalachicola Road','Venice','FL','34285','','','','','2016-10-31','2017-11-24'),('m_336577831540','8955865737','Isa','Caballero','9965 sw 106 ave','Miami','FL','33176','','','','','0000-00-00','2017-11-24'),('m_56438259598','89788039822','Shannon','Hiratzka','','','','','','','','','0000-00-00','0000-00-00'),('m_505710719336','90311416103','Ashley','Ruggiero','3130 11th St N','St Petersburg','FL','33704','111 2nd Ave NE\r\nSuite 1104','St Petersburg','FL','33701','2017-12-22','2017-11-24'),('m_209299025014','905734624908','Joe ','suck','','','','','','','','','0000-00-00','0000-00-00'),('m_821177825861','907030526003','Emily ','Charbonneau','113 Kilsyth Road','Brighton','MA','02135','','','','','0000-00-00','0000-00-00'),('m_10468442722','91014773430','Vicky','Calimag','','','','','780 N. McDonnell Road','San Francisco ','CA','94128','2017-08-23','0000-00-00'),('m_985172620175','911550520885','Kate ','McCarthy','','','','','','','','','0000-00-00','0000-00-00'),('m_598691113455','9167811194','Diana','Pell','5200 Canyon Crest Dr. #82','Riverside','CA','92507','','','','','0000-00-00','2017-11-24'),('m_74276217611','91910267913','Klara','Mora','321 Island Drive','Key Biscayne','FL','33149','','','','','2015-02-06','2017-11-24'),('m_924294016324','919271218088','MOm','Pelts','200 Oak Street','Lookout Mountain','TN','37350','401 Chestnut STreet','Chattanooga','','','2017-10-10','0000-00-00'),('m_443822118','92006582601','Melody','Petty','','','','','','','','','0000-00-00','0000-00-00'),('m_270431927831','92214796410','Aly','Pugh','','','','','','','','','2016-07-18','2017-11-24'),('m_879647122468','928120522914','Eva','Foley','','','','','','','','','0000-00-00','0000-00-00'),('m_34901012452','929027912675','Maria','Garcia','','','','','','','','','0000-00-00','0000-00-00'),('m_270431927831','93753324798','Amy ','Thomas','','','','','','','','','0000-00-00','2017-11-24'),('m_903089611929','939332312326','Ally','Bires','','','','','','','','','0000-00-00','0000-00-00'),('m_396504825289','947026828477','Brian','Moyer','','','','','','','','','0000-00-00','0000-00-00'),('m_227141432323','9496568627','Ivonne ','Calzada','','','','','','','','','0000-00-00','0000-00-00'),('m_898961314696','954748319897','Paradise Funderal Home','','','','','','','','','','0000-00-00','2017-11-24'),('m_642056115451','962979616363','Tomas','Kozar','','','','','','','','','0000-00-00','0000-00-00'),('m_166470610219','963307210909','Erin ','Murray','','','','','4301 Blair Oaks Drive','The Colony','TX','75056','0000-00-00','2017-11-24'),('m_786773630732','969621527095','','','','','','','','','','','0000-00-00','2017-11-24'),('m_225514712269','976732913440','Mandy','Majeski','3501 E Camelback Rd #106','Phoenix','AZ','85018','','','','','2016-06-22','2017-11-24'),('m_261418613886','977724818386','Nelly','Kras','3102 Sitio Isadora','Carlsbad','CA','92009','3102 Sitio Isadora','Carlsbad','CA','92009','2016-04-19','2017-11-24'),('m_478333117746','979738518359','ate','gafgt','sfhsfd','hsfdh','AL','36310','','','','','0000-00-00','2017-11-24'),('m_46903826711','979740726861','jim','bloom','52 Pilot Lane','Staten Island','NY','10309','','','','','0000-00-00','0000-00-00'),('m_625784131778','980289032046','Amanda ','Evanson','1667 S Balsam Ct','Lakewood','CO','80232','','','','','2018-02-08','0000-00-00'),('m_122303830854','980531830959','Allison','Long','','','','','','','','','0000-00-00','2017-11-24'),('m_746369228386','981783629078','Cristina','Essig','10305 SW 132 Street','Miami','FL','33176','','','','','0000-00-00','2017-11-24'),('m_960517630110','983246896','Savannah','Payeur','','','','','','','','','0000-00-00','2017-11-24'),('m_523211330346','98375219713','Carlos','Betancourt','','','','','','','','','0000-00-00','0000-00-00'),('m_607717125137','985053425368','Katie','Cowser','','','','','','','','','0000-00-00','0000-00-00'),('m_952436328498','986017928626','Matt','Cameron','','','','','','','','','0000-00-00','0000-00-00'),('m_46031287793','98736048097','Mariah','Prince','','','','','111 Church st','Laconia','NH','03246','0000-00-00','0000-00-00'),('m_812403219959','987756820187','Lynn','Cole','29650 US-95, Athol','Athol','ID','83801','','','','','0000-00-00','0000-00-00'),('m_547716826611','987924827305','Kari','Klein','2356 cambridge drive','Sarasota','FL','34323','','','','','2017-07-05','0000-00-00'),('m_163229822717','98877723195','lady','mcbeth','123 elm street','mobile','AL','36602','','','','','0000-00-00','2017-11-24'),('m_505710719336','990521722795','','','','','','','','','','','0000-00-00','2017-11-24'),('m_163229822717','99690823235','mary','jones','','','','','','','','','0000-00-00','2017-11-24'),('m_137228024217','997773524316','Ashley','Reynolds ','','','','','401 N . Cedar Bluff Rd ','Knoxville','TN','37923','2017-10-24','0000-00-00');

--
-- Table structure for table `profile_bak`
--

CREATE TABLE `profile_bak` (
  `memberID` varchar(255) NOT NULL,
  `profileID` varchar(244) NOT NULL,
  `fName` varchar(300) NOT NULL,
  `lName` varchar(300) NOT NULL,
  `homeAddress` varchar(400) NOT NULL,
  `homeCity` varchar(100) NOT NULL,
  `homeState` varchar(100) NOT NULL,
  `homeZip` varchar(20) NOT NULL,
  `officeAddress` varchar(400) NOT NULL,
  `officeCity` varchar(100) NOT NULL,
  `officeState` varchar(100) NOT NULL,
  `officeZip` varchar(20) NOT NULL,
  `birthday` date NOT NULL,
  `anniversary` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `profile_bak`
--

INSERT INTO `profile_bak` VALUES ('m_4011291930','434161829740','Julie Anne','Garcia','520 Tibidabo Ave.','Coral Gables','FL','33143','17615 SW 97 Avenue (Franjo Rd.)\r\nEarly Steps Department','Palmetto Bay','FL','33157','2015-06-01','2015-01-10'),('m_830679124155','76765812263','Lillian','Solis-Silva','625 Biltmore Way\r\nApt 105','Coral Gables','FL','33134','','','','','2015-07-08','2015-07-18'),('m_881109812684','3355012879','Maria','DiGiorgio','1795 SW 16 Street','Miami','FL','33145','ADT Law Department\r\n1501 Yamato Road','Boca Raton','FL','33431','2014-10-26','2015-07-18'),('m_881109812684','245871613013','Martha','Marrero','305 East 14 Street','Hialeah','FL','33010','','','','','2014-12-01','2015-07-18'),('m_830679124155','515891029742','Sylvia','Figueroa','Sissi\'s address','test','','test','','','','','2015-07-02','2015-07-18'),('m_830679124155','280820329810','Lillian','Figueroa','Lillibel\'s address','test','','test','','','','','2015-07-07','2015-07-18'),('m_409597510085','384946129786','Allie','Allan','184 West 1580 North','lehi','UT','84043','','','','','0000-00-00','2015-07-18'),('m_87637613606','27189017124','Sahar','Zodeh','','','','','Weight Watchers International, Inc.\r\n675 Avenue of the Americas, 6th Floor','New York','NY','10010','0000-00-00','2015-07-18'),('m_43049754012','193946414486','Suzie','Garcia','50 Menores Ave\r\nApartment 528','Coral Gables','FL','33134','','','','','2014-08-11','2015-07-18'),('m_44798114872','403586314482','Ashley','Priest','','','','','Herssein law group\r\n12000 Biscayne Blvd, Ste 402\r\n','North Miami','FL','33181','2014-08-24','0000-00-00'),('m_44798114872','801436215002','Maria','Llovet','195 SW 84 Ave','Miami','FL','33144','','','','','2015-05-20','0000-00-00'),('m_419227024955','339983025225','Allyson','Gonzalez','733 Palermo Ave','Coral Gables','FL','33134','','','','','2015-03-24','2015-03-30'),('m_74276217611','10471307683','Luisa','Foyo','430 Grand Bay Dr. Apt. 201','Key Biscayne','FL','33149','','','','','2014-08-25','0000-00-00'),('m_74276217611','91910267913','Klara','Mora','321 Island Drive','Key Biscayne','FL','33149','','','','','2015-02-06','0000-00-00'),('m_74276217611','88271017965','Maria','Vazquez','918 SW 10th Street','Miami','FL','33130','','','','','2015-07-30','0000-00-00'),('m_606364713392','513559413479','hghfgh','fghfghfgh','hgfhfghf','ytrytr','AZ','65454','ututy','ututyuty','IA','74565','2015-08-11','2014-08-21'),('m_831530423223','759238923396','sadf','asdf','823 S Howard St','Corona','CA','92879','','','','','2015-08-06','2014-08-30'),('m_616682018429','462978819258','Paige ','Asher','473 Mendez Ave','Coral Galbes','FL','33146','','','','','0000-00-00','0000-00-00'),('m_433952414569','504675316699','Robert ','Fewell','930 S. Greenway Drive Coral Gables','','FL','33134','','','','','0000-00-00','0000-00-00'),('m_81096356594','848108725854','me','mo','4123 sw 1342 st','Miami','FL','123312','','','','','0000-00-00','0000-00-00'),('m_373647712986','446188128635','asdf','asdf','','','','','','','','','0000-00-00','0000-00-00');

--
-- Dumping events for database 'flowermatic'
--

--
-- Dumping routines for database 'flowermatic'
--


