DROP TABLE IF EXISTS `evcategories`;
CREATE TABLE `evcategories`(`Category` VARCHAR(50) );
DROP TABLE IF EXISTS `evevents`;
CREATE TABLE `evevents`(`Category` VARCHAR(50) ,`Description` LONGTEXT ,`EventID` INT AUTO_INCREMENT,`FromDate` DATE ,`FromTime` VARCHAR(50) ,`Image` VARCHAR(50) ,`Location` VARCHAR(50) ,`Map` LONGTEXT ,`Note` LONGTEXT ,`Price` DECIMAL ,`Subject` VARCHAR(50) ,`ToDate` DATE ,`ToTime` VARCHAR(50) ,PRIMARY KEY (`EventID`));
DROP TABLE IF EXISTS `evusers`;
CREATE TABLE `evusers`(`Email` VARCHAR(50) ,`Group` VARCHAR(50) ,`ID` INT AUTO_INCREMENT,`Password` VARCHAR(50) ,`Username` VARCHAR(50) ,PRIMARY KEY (`ID`));
DROP TABLE IF EXISTS `evtellfriend`;
CREATE TABLE `evtellfriend`(`EmailAddress1` VARCHAR(50) ,`EmailAddress2` VARCHAR(50) ,`EmailAddress3` VARCHAR(50) ,`EmailAddress4` VARCHAR(50) ,`EmailAddress5` VARCHAR(50) ,`EmailBody` LONGTEXT ,`EmailSubject` VARCHAR(50) ,`FromName` VARCHAR(50) );
INSERT INTO `evcategories`(`Category`) VALUES('Wedding');
INSERT INTO `evcategories`(`Category`) VALUES('Birthday Party');
INSERT INTO `evcategories`(`Category`) VALUES('Concert');
INSERT INTO `evcategories`(`Category`) VALUES('Business Meeting');
INSERT INTO `evcategories`(`Category`) VALUES('Live Show');
INSERT INTO `evcategories`(`Category`) VALUES('Outdoor Event');
INSERT INTO `evcategories`(`Category`) VALUES('Sporting Event');
INSERT INTO `evcategories`(`Category`) VALUES('Trip');
INSERT INTO `evcategories`(`Category`) VALUES('Bridal Shower');
INSERT INTO `evcategories`(`Category`) VALUES('Baby Shower');
INSERT INTO `evcategories`(`Category`) VALUES('Fundraiser');
INSERT INTO `evcategories`(`Category`) VALUES('Pet Show');
INSERT INTO `evevents`(`EventID`,`Category`,`Subject`,`Description`,`FromDate`,`ToDate`,`FromTime`,`ToTime`,`Location`,`Price`,`Map`,`Note`,`Image`) VALUES(1,'Birthday Party','Mike\'s 27th Birthday','<P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>Ladies &amp; Gentlemen.</FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>As you all know it is a great day this Sunday and we are celebrating the birthday of our dearest friend Mike. Through reliable sources we found that Mike would love to have a brand new LCD monitor for a gift and since this is Mike we are talking about here, he wants a gigantic 24\" LCD monitor. He also said that he will be glad to pay the difference if we do not collect enough \"bucks\" If you would be so kind and reply back to me before tomorrow noon if you would like to pitch in for this gift. Contribution amounts are based on how much you would like to give. We are thinking that somewhere between $20 to $30 a person is reasonable. </FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>Please indicate in your response how much you are willing to contribute. If I don\'t hear back from you by noon tomorrow I will assume that you will not partake in this endeavor. Thank you everyone and I will see you all on Sunday. </FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>Regards, </FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>Alex </FONT></P>','2008-2-25 0:0:0',NULL,'4:00 PM','10:00 PM','Mike\'s Houser1111 Garland DrrPlymouth, MN 55446',NULL,'http://maps.google.com/maps?f=q&hl=en&q=1111+Garland+Dr,+Plymouth,+MN+55446&sll=37.0625,-95.677068&sspn=31.701751,58.535156&ie=UTF8&ll=45.037869,-93.495026&spn=0.110385,0.228653&z=12&iwloc=cent&om=1','Dont\' forget the flowers:-)','me.jpg');
INSERT INTO `evevents`(`EventID`,`Category`,`Subject`,`Description`,`FromDate`,`ToDate`,`FromTime`,`ToTime`,`Location`,`Price`,`Map`,`Note`,`Image`) VALUES(2,'Sporting Event','Minnesota Wild Hockey','<FONT color=#333333>Minnesota Wild vs. Phoenix Coyotes</FONT><BR>&nbsp;<BR><IMG src=\"http://wild.com/images/core/01-new.jpg\">&nbsp; ','2007-3-20 0:0:0',NULL,'5:00 PM','11:00 PM','Xcel Energy Center at St.Paul, MN',33.000000,'http://maps.google.com/maps?f=q&hl=en&q=xcel+energy+center,+minnesota&sll=37.0625,-95.677068&sspn=30.048013,59.238281&ie=UTF8&z=16&ll=44.945286,-93.101406&spn=0.006546,0.021501&om=1&iwloc=addr&mid=1172346800','gfdgd',NULL);
INSERT INTO `evevents`(`EventID`,`Category`,`Subject`,`Description`,`FromDate`,`ToDate`,`FromTime`,`ToTime`,`Location`,`Price`,`Map`,`Note`,`Image`) VALUES(3,'Trip','Colorado Ski Trip','<ADDRESS>&nbsp;Time to get your skis ready for our annual Colorado Ski Trip </ADDRESS><ADDRESS><STRONG>&nbsp;What: Ski trip </STRONG></ADDRESS><ADDRESS><STRONG>&nbsp;Where: ABasin, Copper, Vail </STRONG></ADDRESS><ADDRESS><STRONG>&nbsp;When: Feb 14-19, 2007 </STRONG></ADDRESS><ADDRESS><STRONG>&nbsp;Why: Cause we can!</STRONG> </ADDRESS>','2007-2-14 0:0:0','2007-2-19 0:0:0',NULL,NULL,'Colorado',1000.000000,NULL,NULL,'img_0543.jpg');
INSERT INTO `evevents`(`EventID`,`Category`,`Subject`,`Description`,`FromDate`,`ToDate`,`FromTime`,`ToTime`,`Location`,`Price`,`Map`,`Note`,`Image`) VALUES(4,'Sporting Event','7th Annual Golf Outing','<P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>We are having our 7th annual golf outing at Lake Minnetonka Golf Course on May 26th, 2007.</FONT></P><P><STRONG><U><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>Schedule:</FONT></U></STRONG></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>9:00am&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Breakfast</FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>10:00am&nbsp;&nbsp;&nbsp;&nbsp; Tee off</FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>3:00pm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; BBQ Lunch</FONT></P><P><FONT face=\"Arial, Helvetica, sans-serif\" color=#333333 size=2>5:00pm&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Live Concert</FONT></P>','2007-5-26 0:0:0',NULL,'9:00 AM','7:00 PM','Lake Minnetonka Golf and Country Club',0.000000,'http://maps.google.com/maps?f=q&hl=en&q=lake+minnetonka,+mn&sll=44.944775,-93.1014&sspn=0.006546,0.014462&ie=UTF8&z=11&ll=44.940501,-93.600769&spn=0.20948,0.688019&om=1&iwloc=addr','Bring your own clubs. Club rental and golf carts will be provided. All food and drinks are complementary','golf.jpg');
INSERT INTO `evevents`(`EventID`,`Category`,`Subject`,`Description`,`FromDate`,`ToDate`,`FromTime`,`ToTime`,`Location`,`Price`,`Map`,`Note`,`Image`) VALUES(5,'Wedding','John\'s & Melissa\'s Wedding ','<P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"></SPAN><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>We invite you to attend our wedding<?XML:NAMESPACE PREFIX = O /><O:P> </O:P></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>on the 28th of June, 2007 <O:P></O:P></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>at&nbsp;Marriott Hotel<BR>&nbsp; </FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>The Muhurtham is from 8:00 a.m. to 9:30 a.m. <O:P></O:P></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>Please do stay for lunch, a reception at 6:30 p.m.,<BR>and dinner.<O:P> </O:P></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>We request you to also join us for a reception and dinner<BR>on the 19th of November from 6:30 p.m. onwards, <O:P></O:P></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><B style=\"mso-bidi-font-size: 10.0pt; mso-bidi-font-weight: normal\"><FONT face=Verdana size=1>John&nbsp;</FONT></B><FONT face=Verdana size=1><B style=\"mso-bidi-font-weight: normal\">and Melissa</B></FONT></SPAN></P><P class=MsoNormal style=\"TEXT-ALIGN: center\" align=center><SPAN style=\"mso-bidi-font-size: 10.0pt\"><FONT face=Verdana size=1>Please no gifts</FONT></SPAN></P>','2007-6-28 0:0:0',NULL,'8:00 AM','11:00 PM','Marriott Hotelr333 S Figueroa St, Los Angeles, CA',NULL,'http://maps.google.com/maps?f=q&hl=en&q=333+S+Figueroa+St,+Los+Angeles,+CA&sll=34.173749,-118.223877&sspn=0.244845,0.464172&ie=UTF8&z=16&ll=34.055504,-118.254969&spn=0.007662,0.021501&om=1',NULL,NULL);
INSERT INTO `evusers`(`ID`,`Username`,`Password`,`Group`,`Email`) VALUES(1,'admin','admin','admin','bchaplin@xlinesoft.com');