-- MySQL dump 10.13 Distrib 5.1.50, for pc-linux-gnu (i686) -- -- Host: localhost Database: mcc_wcln1 -- ------------------------------------------------------ -- Server version 5.1.50 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `share_holders` -- DROP TABLE IF EXISTS `share_holders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `share_holders` ( `member_id` varchar(8) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0', `member_fullname` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `member_surname` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `member_email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `status` varchar(48) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', PRIMARY KEY (`member_id`), KEY `member_surname` (`member_surname`), KEY `status` (`status`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `share_holders` -- LOCK TABLES `share_holders` WRITE; /*!40000 ALTER TABLE `share_holders` DISABLE KEYS */; INSERT INTO `share_holders` VALUES ('0217','Helen B. Colonna','Colonna','',''),('0398','John G. Lambert','Lambert','',''),('0886','Mrs. Elliott Bernstein','Bernstein','',''),('0081','Theodore Baker, Jr.','Baker','',''),('0189','J. Hume Taylor, Jr.','Taylor','',''),('0416','James W. Griffin','Griffin','',''),('0445','Rita P. Reeves','Reeves','',''),('0305','Sylvan Goldstein','Goldstein','',''),('0636','Olive Pridgen','Pridgen','',''),('0296','Alan P. Owens & Joan Skeppstrom','Skeppstrom','',''),('0630','Harold Wilson','Wilson','',''),('0374','Beatrice Gibbs','Gibbs','',''),('H5','John & Ellen Ankerson','Ankerson','',''),('H7','Barclay & Janet Winn','Winn','',''),('H3','Mr. & Mrs. G. Conoly Phillips','Phillips','',''),('H4','Mr. & Mrs. William Thomas','Thomas','',''),('H6','Tim & Deane Sobol','Sobol','',''),('1428','John H. & Jill E. Fox','Fox','',''),('1566','Marcus & Jillian Jones','Jones','',''),('1363','Christopher T & Catherine H. Martin','Martin','',''),('1517','David & Rosemary Randolph','Randolph','',''),('1727','Perry & Paige Frazer','Frazer','',''),('1420','Ted & Lisa Waters','Waters','',''),('1669','Dan & Brenda Uhls','Uhls','',''),('1440','Dave & Erin Wickersham','Wickersham','',''),('1690','David & Diana Foster','Foster','',''),('1535','Todd Fifield & Jamie Walker','Walker','',''),('1641','Scott & Maria Silsdorf','Silsdorf','',''),('1320','Thomas Joseph & Trisha Lynne Knox','Knox','',''),('1050','Douglas E. & Kathy B. Knack','Knack','',''),('1201','Elizabeth Blair Clark Smith (Swoop)','Smith','',''),('1154','Patricia Dominique Link','Link','',''),('1025','Mark Evan Skees','Skees','',''),('1618','Brad & Jennifer Smith','Smith','',''),('1200','Philip Kessler','Kessler','',''),('1476','Ty & Allison Cook','Cook','',''),('1667','David & Paula Norley','Norley','',''),('1558','John & Yvette Konstanzer','Konstanzer','',''),('1247','Carole M. Dalton','Dalton','',''),('1285','T. Michael & Deborah G. D\'Angelo','D\'Angelo','',''),('1237','H. Brian & Stephanie W. Davenport','Davenport','',''),('1542','John & Elizabeth Herr','Herr','',''),('1168','Daniel Patrick Hassett','Hassett','',''),('1377','Garland & Jo White','White','',''),('1315','David & Elizabeth Foster','Foster','',''),('1116','William McCardell Furr','Furr','',''),('0827','Charles Milton Goldman','Goldman','',''),('1223','Nicholas & Kim Georges','Georges','',''),('1562','James L. & Mary B. Wade','Wade','',''),('1126','Mark & Linda Rienerth','Rienerth','',''),('1356','Kevin & Jill O\'Meara','O\'Meara','',''),('1143','Richard G. Radford','Radford','',''),('1095','Jeff & Dana Rosen','Rosen','',''),('1107','David L. Mayfield','Mayfield','',''),('1359','C. Steven Sale & Jennifer B. Sale','Sale','',''),('1625','Sandra Paxson','Paxson','',''),('0389','Frederick J. Bariteau','Bariteau','',''),('1058','William James Magnan','Magnan','',''),('1460','Brian & Stacy Hennessy','Hennessy','',''),('1009','Ronald B. & Sally K. Hartman','Hartman','',''),('1382','Ed & Mary McPhillips','McPhillips','',''),('0845','John C. McLemore','McLemore','',''),('1511','James R. Harvey III & Kimberlee W.H. Harvey','Harvey','',''),('1568','Michael D. & Virginia W.E. Harvey','Harvey','',''),('1270','Scott & Jane Harper','Harper','',''),('1548','Jeffrey & Julieanne Hastings','Hastings','',''),('1395','David Wilson Hamberg','Hamberg','',''),('1463','Robert & Harriet McCullough','McCullough','',''),('1131','George (Brick) & Louise Hill','Hill','',''),('1423','Richard & Sherry Hill','Hill','',''),('1626','Craig & Amanda Hill','Hill','',''),('1520','Timothy B. & Janet M. Hixson','Hixson','',''),('1627','William & Catherine Hollowell','Hollowell','',''),('1352','Timothy & Meredith McGlone','McGlone','',''),('1083','Alice Ward Allen-Grimes & Junius Summerfield Grimes, IV','Grimes','',''),('1657','James Morrison','Morrison','',''),('1335','Walter & Andrea Moore','Moore','',''),('1704','Carter & Anne Smith','Smith','',''),('1345','John A. & Stephanie Hanna Moore','Moore','',''),('1292','Michelle & Bill Moore','Moore','',''),('1306','Kenneth & Ann Golski','Golski','',''),('1376','Michael J. Goretsky, M.D. & Sharon A. Goretsky','Goretsky','',''),('1576','Kim Thomas Miller','Miller','',''),('1022','Saul & Sara Mednick','Mednick','',''),('0882','Jeffrey A. Miller','Miller','',''),('1541','Porter & Kim Hardy','Hardy','',''),('1301','Mr. & Mrs. Randolph Grinnan, IV','Grinnan','',''),('1414','Robert V. & Martha T. Gusentine','Gusentine','',''),('1150','Marc D. & Theresa Gutterman','Gutterman','',''),('1355','Christina & David Hagn','Hagn','',''),('1612','Larry & Nicole Michelon','Michelon','',''),('1338','Dean & Kay Merritt','Merritt','',''),('1092','Bobby L. Howlett','Howlett','',''),('0880','Charles Paul Hanbury, Jr.','Hanbury','',''),('1327','Pete & Claire McCrary','McCrary','',''),('1453','Paul Henri Gregoire & Adelia Furr Gregoire','Gregoire','',''),('1082','Douglas A. Lyons & Mary Margaret Callahan Lyons','Lyons','',''),('1470','Michael E. Glenn','Glenn','',''),('1565','Fred J. & Mira H. Mariano','Mariano','',''),('1065','Anne S. Maloney','Maloney','',''),('1654','Kevin & Sasha Krigsvold','Krigsvold','',''),('1416','Anthony & Diane Krueger','Krueger','',''),('1509','Wallace & Annette Mack','Mack','',''),('1549','David & Juliet Kuehl','Kuehl','',''),('1328','Jack & Rebecca Howell','Howell','',''),('1452','Patrick & Nancy Lacore','Lacore','',''),('1403','Richard & Susan Klein','Klein','',''),('1055','Joseph Roy Lassiter, Jr.','Lassiter','',''),('1464','Matthew Lynch','Lynch','',''),('1610','Christopher & Kristen Lassalle','Lassalle','',''),('1241','Ned & Susan Lilly','Lilly','',''),('1234','T.J. & Lisa Lynch','Lynch','',''),('1526','Eric & Susan Lowe','Lowe','',''),('1130','Joseph Francis Link','Link','',''),('1705','John & Karen Jacklich','Jacklich','',''),('1519','Dr. & Mrs. Walter & Jessica LaBrie','LaBrie','',''),('1635','C Peronneau & Melanie L Mathewes','Mathewes','',''),('1613','Mark & Melanie Horgan','Horgan','',''),('1571','Robert & Yasmeen Knowles','Knowles','',''),('1206','John & Melissa McCormick','McCormick','',''),('1236','Elizabeth B. Lloyd','Lloyd','',''),('1448','Mike and Andria McClellan','McClellan','',''),('1274','Timmy & Lauren Howlett','Howlett','',''),('1342','Cynthia Mayer','Mayer','',''),('1242','Victoria E. Ihrman & Kent Nicholas Ihrman','Ihrman','',''),('1437','Bjorn Marshall','Marshall','',''),('1601','Albert & Elizabeth Mauzy','Mauzy','',''),('1280','Honey & Ron Kloster','Kloster','',''),('1606','Michael Kaplan & Kim Schock','Schock','',''),('1256','Natalie & Marty Kaszubowski','Kaszubowski','',''),('1481','Michael & Elizabeth Mather','Mather','',''),('1232','Mark & Dixcy Kilduff','Kilduff','',''),('1060','Kenneth Michael Kimidy','Kimidy','',''),('1059','C. Ben Mason','Mason','',''),('1477','Adam & Andrea Kinnear','Kinnear','',''),('1350','George & Audrey Honeycutt','Honeycutt','',''),('1567','Deborah Smith Johnson','Johnson','',''),('1323','Thomas & Elizabeth Brasek','Brasek','',''),('1188','Peter F. & Kathryn J. Bariteau','Bariteau','',''),('1703','Adam & Stefanie Levensalor','Levensalor','',''),('1436','Fred & Jane Bashara','Bashara','',''),('1287','Barbara & Rob Baxter','Baxter','',''),('1439','Rob and Liz Becker','Becker','',''),('0991','Linwood D. & Frances W. Beckner','Beckner','',''),('1578','Kim Bentley','Bentley','',''),('1433','Michael & Jennifer Bibbo','Bibbo','',''),('1533','Lindsay & Koggie Bilisoly','Bilisoly','',''),('0977','Stephen & Judith Blevins','Blevins','',''),('1513','Francis Christopher & Elizabeth Ferris Bodner','Bodner','',''),('1590','Andrew & Anne Carney','Carney','',''),('1461','David & Kelly Bose','Bose','',''),('1380','Mr. & Mrs. Claude Wood Anderson, Jr.','Anderson','',''),('1582','Matthew & Krista Braun','Braun','',''),('1650','Brian Brennan & Ellen Fitzenrider','Fitzenrider','',''),('1374','Dr. Bruce S. & May B. Britton','Britton','',''),('1072','Mr. & Mrs. Patrick Michael Brogan','Brogan','',''),('1575','Richard N. Brown III & Janine E.B. Brown','Brown','',''),('1514','David Burdige & Juliana Homstead','Homstead','',''),('1544','Robert & Frances Burger','Burger','',''),('1623','Christopher Burgess & Mary Evans McMillion-Burgess','McMillion-Burgess','',''),('0799','Francis Sullivan Callahan','Callahan','',''),('1616','Brian & Janis Campbell','Campbell','',''),('1536','Ronald A. & Michelle G. Foy','Foy','',''),('1183','Vernon Bradford Bonney, Jr.','Bonney','',''),('1551','Eric & Amy Preuss','Preuss','',''),('1372','James & Elizabeth Old','Old','',''),('1310','Clark & Carol Olsen','Olsen','',''),('0897','Michael & Megan Padden','Padden','',''),('1040','Mr. & Mrs. John D. Padgett','Padgett','',''),('1543','David M. Parker & Theresa C. Parker','Parker','',''),('1429','Christopher & Margot Patzer','Patzer','',''),('1384','George & Roxanne Pegram','Pegram','',''),('1508','David & Jennifer Peronnet','Peronnet','',''),('1524','James Grey (Sr.) & Debra Persons','Persons','',''),('1346','James M. Pickrell, Jr. & Amber W.D. Pickrell','Pickrell','',''),('1413','Doug Pilley','Pilley','',''),('1220','Mike & Jane Barclift','Barclift','',''),('1263','Peter & Karen Pope','Pope','',''),('1591','Suanne Armstrong','Armstrong','',''),('1587','Chad & Kinder Pulling','Pulling','',''),('1521','Karl & Dana Quist','Quist','',''),('1617','Sara & Adam Rafal','Rafal','',''),('1579','Joe & Kelly Raia','Raia','',''),('1611','James & Ruth Rainey','Rainey','',''),('1639','Dan & Elizabeth Raphael','Raphael','',''),('1534','Timothy & Joan P. Redfearn','Redfearn','',''),('1679','Kerry J. Richardson','Richardson','',''),('1389','John & Mary Beth Rickman','Rickman','',''),('1563','John & Heather Adams','Adams','',''),('1455','Steve & Jody Alperin','Alperin','',''),('1266','Chuck & Ellen Carpenter','Carpenter','',''),('1458','Alex H. & Susan K. Pincus','Pincus','',''),('1502','Vernon L. & Amy S. Flora','Flora','',''),('1426','Jack & Courtney Doyle','Doyle','',''),('1128','Sherwood T. Duffy, Jr.','Duffy','',''),('1628','Bryan & Candace Dunleavy','Dunleavy','',''),('1631','Tim & Teresa Duvall','Duvall','',''),('0683','R. Thomas & Mary Landon Edwards, Jr.','Edwards','',''),('0982','Mark Wood & Dorothy Lawless Edwards, Jr.','Edwards','',''),('1081','Rebecca Jo Elliott','Elliott','',''),('1471','Christopher Ellingson & Stacy Quail-Ellingson','Quail-Ellingson','',''),('1456','Gregory D. & Blair B. Ellson','Ellson','',''),('1411','Joel & Katherine English','English','',''),('1178','James G. Farrell & Jamie B. Farrell','Farrell','',''),('1589','Catherine Carney','Carney','',''),('1583','Bill and Mary Carter Fiveash','Fiveash','',''),('1319','William Docalovich & Lynn Tiedge','Tiedge','',''),('1531','James & Elena Mucciarone','Mucciarone','',''),('1584','Andy & Colleen Fox','Fox','',''),('1447','James B. & RoseMary N. Morton','Morton','',''),('1500','David W. & Catherine C. Francis','Francis','',''),('1027','Richard Cameron Freeman','Freeman','',''),('1630','Rosa Lee Furr','Furr','',''),('1640','Rob & Ruland Gagne','Gagne','',''),('1111','Sharron Pilcher Gallagher','Gallagher','',''),('1496','Victor & Cathy Gargano','Gargano','',''),('1216','Lewis J. & Amy F. Georges','Georges','',''),('1522','Scott & Amy Gilman','Gilman','',''),('1547','Mr. & Mrs. Tim Faulkner','Faulkner','',''),('1300','Scott & Melanie Cramer','Cramer','',''),('1550','Jennifer Nancy Carson','Carson','',''),('1291','Julianne & Brian Casey','Casey','',''),('1581','Dr. David Castaldo & Dr. Shannon McCole','McCole','',''),('1109','William D. & Jenny E. Cavender','Cavender','',''),('1141','David William Chapman','Chapman','',''),('1417','Neil Cheatwood & Tammy Braun','Braun','',''),('0985','Helene Colonna Childress','Childress','',''),('1402','Christian H. Chiles & Patricia A. Holt','Holt','',''),('1572','James & Sara Clinton','Clinton','',''),('1016','Lawrence Wilder Coleman','Coleman','',''),('1604','David & Carrie Coleman','Coleman','',''),('1366','John & Anne Donnelly','Donnelly','',''),('1100','Kathleen & Joseph Cosco','Cosco','',''),('0819','Wilson & Ann Dodson','Dodson','',''),('1451','Michael & Rebecca Crockett','Crockett','',''),('1569','Rob & Amy Crofoot','Crofoot','',''),('1469','Jeff & Amy Danielson','Danielson','',''),('1472','Jason & Leigh Davis','Davis','',''),('1580','Robert & Linda Desantis','Desantis','',''),('1156','Brian Douglas Deutsch','Deutsch','',''),('1636','William F. & Alicia S. Devine','Devine','',''),('0984','Mr. & Mrs. Daniel David Dickenson, III','Dickenson','',''),('1577','James William & Elisabeth Vadnais Dickie','Dickie','',''),('0966','James & Frances Dille','Dille','',''),('1288','Christopher & Michele Dinsmore','Dinsmore','',''),('1515','Jon Glass & Elizabeth Evans','Evans','',''),('1278','William D. & Helen D. Conner','Conner','',''),('1713','Jim & Christie Seerden','Seerden','',''),('1698','James & Cecilia Cornelius','Cornelius','',''),('1707','Jeff & Danielle Miskill','Miskill','',''),('1709','Thomas F. Mooney, III & Nancy C. Mooney','Mooney','',''),('1708','Michael & Amy Walls','Walls','',''),('1692','Mr. & Mrs. Barclay C. Winn, Jr.','Winn','',''),('1720','Hal & Mary Yuill','Yuill','',''),('1710','Jonathan & Jennifer Mann','Mann','',''),('1418','Daniel J. O\'Donnell & Robyn L. Neal','Neal','',''),('1638','Andy & Erika McCullough','McCullough','',''),('1295','Mark A. Moses & Renee M. Nahan','Nahan','',''),('1637','Harlan & Kathleen Rust','Rust','',''),('1714','Bennett W. & Cheryl H. Miles','Miles','',''),('1715','Jeff Hutson','Hutson','',''),('1716','Sandra Sherrill','Sherrill','',''),('1644','Thomas & Margaret Leeman','Leeman','',''),('1645','David & Aimee Sullivan','Sullivan','',''),('1648','Murray & Amy Bishop','Bishop','',''),('1651','Sarah B. Cox','Cox','',''),('1652','Graham & Helen Kessler','Kessler','',''),('1643','Robert & Marcia Landman','Landman','',''),('1712','Roger & Laura Slaymaker','Slaymaker','',''),('1691','Jay & Jen Livingood','Livingood','',''),('1683','William & Bonnie Beckner','Beckner','',''),('1689','Penny & Chris Thomas','Thomas','',''),('1681','Dale Bartlett & Tracy Reiman','Reiman','',''),('1693','Scott & Patricia Hennessy','Hennessy','',''),('1685','Pete & Jean Ashton','Ashton','',''),('1687','John & Laura Fitzwilliam','Fitzwilliam','',''),('1688','Kenneth & Ashley Hubert','Hubert','',''),('1686','Mindy Conrad','Conrad','',''),('1649','Thad & Jennifer McDonald','McDonald','',''),('1695','Robert & Jennifer Edwards','Edwards','',''),('1656','Andrew & Ann Larkin','Larkin','',''),('1696','Todd & Mimi Owens','Owens','',''),('1697','Andrew & Michelle Casiello','Casiello','',''),('1642','Lynn Waltz','Waltz','',''),('1700','Scott & Tamara Schwerin','Schwerin','',''),('1561','F. Guy Wilson III and Star Anne Wilson','Wilson','',''),('1634','Michael & Lindsay Wise','Wise','',''),('1286','Rev. James M. & Sheryl S. Wood','Wood','',''),('1276','Neal T. & Missy S. Wright','Wright','',''),('1293','Mr. & Mrs. Joseph Ziemian','Ziemian','',''),('1699','Robert & Kay Nesmith','Nesmith','',''),('1497','Patricia Yanaga','Yanaga','',''),('1722','Jeremy & Anne Leigh Bailey','Bailey','',''),('1719','Julia Ayres & Brian Guerrieri','Guerrieri','',''),('1723','Rob & Amy Warren','Warren','',''),('1718','Steve & Ali Carmel','Carmel','',''),('1425','Faith A. Florence','Florence','',''),('1725','Nicolas & Lisa Valcour','Valcour','',''),('1726','Vince & Kim O\'Brien','O\'Brien','',''),('1728','William Kordyjak & Karen Kowalski','Kowalski','',''),('1646','David McLaren & Kimberly McNeil','McNeil','',''),('1661','Thomas & Heather Van Benschoten','Benschoten','',''),('1730','Howard & Kelly Brenner','Brenner','',''),('1733','Richard & Melissa Rogers','Rogers','',''),('1732','Pete & Jennie Schrider','Schrider','',''),('1731','Michael & Gabrielle Shumate','Shumate','',''),('1737','Richard & Grace Carroll','Carroll','',''),('1736','Nick & Dana Garcia','Garcia','',''),('1738','Norman Grose & Gail Dodge','Dodge','',''),('1729','Lara A. Dickenson','Dickenson','',''),('1724','Gail Temple','Temple','',''),('1735','Seth Edwards','Edwards','',''),('1734','Sean & Ava McDermott','McDermott','',''),('1671','James & Bernadette Ferguson','Ferguson','',''),('1711','Ron & Elizabeth Chupik','Chupik','',''),('1660','Matthew & Myong Winston','Winston','',''),('1662','Shawn & Christy Everett','Everett','',''),('1663','Kurt & Bonnie Johnson','Johnson','',''),('1680','John & Meg Mahoney','Mahoney','',''),('1664','Kingsley & Kathie Hart','Hart','',''),('1665','Thomas & Robyn Mathas','Mathas','',''),('1677','Peyton & Denise Lex','Lex','',''),('1666','Jim & Tina Larkin','Larkin','',''),('1721','James & Valena Hoy','Hoy','',''),('1670','Scott & Michelle Nottingham','Nottingham','',''),('1717','Jean & Paul Farrell','Farrell','',''),('1672','Steven & Lisa Litwiller','Litwiller','',''),('1673','Dr. Mohit & Tanya Bhasin','Bhasin','',''),('1676','Matthew & Rebecca Louth','Louth','',''),('1674','Michael & Julia Mitchell','Mitchell','',''),('1675','Jim & Becky Peterson','Peterson','',''),('1694','John & Dana Ramirez','Ramirez','',''),('1702','Jonathan & Jessica Kliner','Kliner','',''),('1701','Warren & Jennifer Warsaw','Warsaw','',''),('1653','Scott & Jennifer McMonagle','McMonagle','',''),('1668','Michael & Anne Cummings','Cummings','',''),('1289','Scott D. & Dr. Lee W. Slater','Slater','',''),('1614','John & Sheryl Searing','Searing','',''),('1479','Frank & Jennifer Seemar','Seemar','',''),('1503','John & Karen Shaffer','Shaffer','',''),('1361','Kevin & Kathleen Sharp','Sharp','',''),('1351','Nicholas & Kyla Shawyer','Shawyer','',''),('1407','Herman & Patricia Shelanski','Shelanski','',''),('1564','Taylor & Carrie Short','Short','',''),('1243','Rudie L. & Anya Y. Simpson','Simpson','',''),('1432','William A. Stiles, Jr. & Margaret R. Mulholland','Mulholland','',''),('1118','Christina Pilcher Skees','Skees','',''),('1445','George Schaefer & Paula Miller','Miller','',''),('1386','Robin & Christopher Slopnick','Slopnick','',''),('1186','Fred C. Dobbs & Elizabeth Anne Smith','Smith','',''),('1415','Randall W. & Shawn K. Smith','Smith','',''),('1331','Mr. & Mrs. Brook J. Smith','Smith','',''),('1442','Douglas C. & Cynthia W. Smith','Smith','',''),('1603','Woody & Joan Smith','Smith','',''),('1512','Robert Winston & Sybil Louise Spurgeon','Spurgeon','',''),('1308','William & Megan Stackhouse','Stackhouse','',''),('1586','Clark & Rebecca Simpson','Simpson','',''),('1179','Stephen James Robinson','Robinson','',''),('1706','Brandon & Jennifer Scheel','Scheel','',''),('1555','Thomas R. & Donna Marie Murphy','Murphy','',''),('1362','Albert & Stephanie Musgrove','Musgrove','',''),('1314','Dr. Edward & Kristina Neukrug','Neukrug','',''),('1501','Daniel & Lynn Neumann','Neumann','',''),('1169','Donald R. Newbold','Newbold','',''),('1265','Vince & Penny Newbold','Newbold','',''),('1193','Mr. & Mrs. Richard R. Nixon','Nixon','',''),('1552','Chad & Sara Schroeder','Schroeder','',''),('1145','Thomas & Deborah Robinson','Robinson','',''),('1507','David & Michele Schinderle','Schinderle','',''),('1137','Mr. & Mrs. Thomas J. Robotham','Robotham','',''),('1622','Stephen & Katherine Rocca','Rocca','',''),('1462','D. Lindsay & Sue G. Russell','Russell','',''),('1682','Sheila Drucker-Zimm & Melvin Zimm','Zimm','',''),('1505','Kenneth & Joanne Saal','Saal','',''),('1202','Jamshid A. Samareh & Diane F. Samareh','Samareh','',''),('1044','Bradley R. & Karen Gormley Sanford','Sanford','',''),('1209','Ruth Conte-Scarpelli & Thomas James Scarpelli','Scarpelli','',''),('1441','Kirsti Ryan','Ryan','',''),('1244','George U. Nottingham','Nottingham','',''),('1499','Jac H. & Virginia G. White','White','',''),('1412','Donna & David Wagnon','Wagnon','',''),('1015','Walter Wallingford & Donna Briggs','Briggs','',''),('1207','Eric & Joanne Warner','Warner','',''),('1482','Tristan Carter Warren','Warren','',''),('1518','Richard S. & Dianna S. Wassell','Wassell','',''),('1530','Joel T. and Page Weaver','Weaver','',''),('1537','Nathaniel & Kathryn West','West','',''),('1608','Sean & Jeni Wetmore','Wetmore','',''),('1230','C. Andrew & Charlotte White','White','',''),('1368','Richard & Chrisley Voter','Voter','',''),('1468','Mr. & Mrs. Denva Layton White IV','White','',''),('1160','Nora Elizabeth White','White','',''),('0999','James Theodore White','White','',''),('1245','James A. & Jennifer B. Whitham','Whitham','',''),('1504','Ronald Howard & Elizabeth Roller Williams Jr.','Williams','',''),('1255','Laura F. Williams','Williams','',''),('1296','Lee & Vicki Williams','Williams','',''),('1134','Richard T. Strauss','Strauss','',''),('1473','David & Norah Rowland','Rowland','',''),('1309','Lauren & Jeff Willis','Willis','',''),('1624','Michael & Kelly Willette','Willette','',''),('0944','Peter & Daryl White','White','',''),('1297','Kimberly & Jesse Thompson','Thompson','',''),('1393','Michael & Tina Swan','Swan','',''),('1120','Elizabeth Dickenson Swartley','Swartley','',''),('1633','William & Laura Taliaferro','Taliaferro','',''),('1525','David & Judith C. Taylor-Fishwick','Taylor-Fishwick','',''),('1430','John & Lori Thomas','Thomas','',''),('1559','Chuck & Marie Timney','Timney','',''),('1383','Mr. & Mrs. C. Andrew Tysinger','Tysinger','',''),('1466','Todd & Elizabeth Vandegrift','Vandegrift','',''),('1222','Jay & Cathy Turpin','Turpin','',''),('1489','Tazewell & Nancy Hubard','Hubard','',''),('0917','W. A. Prince','Prince','',''),('1424','Michael & Sue Doviak','Doviak','',''),('1484','Gene & Margaret Belvin','Belvin','',''),('0779','Joseph F. Ambrosio,II','Ambrosio,II','',''),('0915','Edward P. Stilwell','Stilwell','',''),('0924','Anne B. Stanfield','Stanfield','',''),('1493','Donald Nuss','Nuss','',''),('1486','Timothy & Betty Wade Coyle','Coyle','',''),('1254','Carol Hanna Branch','Branch','',''),('0878','Robert & Nancy King','King','',''),('0349','Joseph George','George','',''),('0613','Hugh (Kelly) Wood','Wood','',''),('1487','Patricia Delk','Delk','',''),('1490','Darryl & Pamela Katrancha','Katrancha','',''),('0912','Leonard & Nancy Weireter','Weireter','',''),('0776','Mr. & Mrs. Ellis M. Jones','Jones','',''),('1494','Dean & Susan Rogis','Rogis','',''),('1492','Barbara Murphy','Murphy','',''),('0907','Gerald C. Kevorkian','Kevorkian','',''),('0589','Craig E. Reilly','Reilly','',''),('0804','Mr. & Mrs. Allan S. Reynolds, Jr.','Reynolds','',''),('1488','Martha deMontpellier','deMontpellier','',''),('0792','James H. & Amy E. Rhodes','Rhodes','',''),('0691','Joseph Michael Young','Young','',''),('W43','John & Lauren Raheb','Raheb','',''),('W50','Carroll & Amy Neville','Neville','',''),('W38','Stephen & LeeAnn Azar','Azar','',''),('W46','Don & Jennifer Cunningham','Cunningham','',''),('W36','Mike & Amy Cutter','Cutter','',''),('W42','Timothy & Michelle Barry','Barry','',''),('W48','Joe & Sandy Michael','Michael','',''),('W37','John & Ruth Avelis','Avelis','',''),('W49','Douglas & Allie Ford','Ford','',''),('W44','Jerry & Chris Meyers','Meyers','',''),('W34','Tyler & Rebecca Ross','Ross','',''),('W47','Michael & Alexandra Babb','Babb','',''),('W45','Micah & Sarah Bumps','Bumps','',''),('W09','John D. & Jacqueline C. McIntyre','McIntyre','',''),('W33','Andrew & Jennifer Barkan','Barkan','',''),('W53','Thomas & Sondra Bashara','Bashara','',''),('W56','Roger & Amy Stinnette','Stinnette','',''),('W40','Evans & Rebecca Poston','Poston','',''),('W35','John & Mary Quinlan','Quinlan','',''),('W51','Leslie & Angie Satchivi','Satchivi','',''),('W55','Jason & Michelle Henry','Henry','',''),('W59','Mr. & Mrs. James T. Wright','Wright','',''),('W39','Charlie & Ann Marie Gunter','Gunter','',''),('W57','Kevin Snode & Stephanie Gutridge -Snode','Snode','',''),('W54','Lon & Cheryl Wagner','Wagner','',''),('W52','Jordan & Carrie Crisman','Crisman','',''),('W41','William & Jennifer Burke','Burke','',''),('W18','David J., Esq & Tanya S. Harris, MD','Harris','',''),('W04','Christian & Allison Templeton','Templeton','',''),('W03','Patrick S. & Martha H. Roebuck','Roebuck','',''),('W02','Preston & Kristen Williams','Williams','',''),('W05','Roger & Sara Burnette','Burnette','',''),('W06','Grady & Debbie Dunn','Dunn','',''),('W07','Tim & Mary Francis Bellman','Bellman','',''),('W08','James R. Holden & Suzanne P. Starling','Starling','',''),('W10','John R. & Virginia E. Alexander','Alexander','',''),('W12','Anthony & Karen Califano','Califano','',''),('W13','Dr. Jeanne Burger','Burger','',''),('W14','Kevin & Erin Corrie','Corrie','',''),('W15','Robert A. & Katherine L. Collins','Collins','',''),('W11','Jesse Grady & Angela Hill','Hill','',''),('W17','David & Lori Baccanari, Jr.','Baccanari','',''),('W32','Keith & Julie Walsh','Walsh','',''),('W19','Mark & Margie Tekamp','Tekamp','',''),('W20','Daniel & Beverly Vincent','Vincent','',''),('W21','Colin & Alyssa Bowser','Bowser','',''),('W22','David Kidd & Lisa Kilczewski','Kilczewski','',''),('W58','Stuart & Frances Stone','Stone','',''),('W24','David & Rebecca Britt','Britt','',''),('W25','John & Julie Malcolm','Malcolm','',''),('W26','Christopher & Sarah Smythe','Smythe','',''),('W28','Shelby & Leslie Mounts','Mounts','',''),('W29','Christian & Laura Case','Case','',''),('W30','John & Dani Crumpler','Crumpler','',''),('W31','K.I. Pagach & Dana M. Fuqua','Fuqua','',''),('W16','Chaffin Brandon','Brandon','',''); /*!40000 ALTER TABLE `share_holders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_access_function` -- DROP TABLE IF EXISTS `webcal_access_function`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_access_function` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_permissions` varchar(64) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_access_function` -- LOCK TABLES `webcal_access_function` WRITE; /*!40000 ALTER TABLE `webcal_access_function` DISABLE KEYS */; INSERT INTO `webcal_access_function` VALUES ('admin','YYYYYYYYYYYYYYYYYYYYYYYYYYY'); /*!40000 ALTER TABLE `webcal_access_function` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_access_user` -- DROP TABLE IF EXISTS `webcal_access_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_access_user` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_other_user` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_can_view` int(11) NOT NULL DEFAULT '0', `cal_can_edit` int(11) NOT NULL DEFAULT '0', `cal_can_approve` int(11) NOT NULL DEFAULT '0', `cal_can_invite` char(1) COLLATE utf8_unicode_ci DEFAULT 'Y', `cal_can_email` char(1) COLLATE utf8_unicode_ci DEFAULT 'Y', `cal_see_time_only` char(1) COLLATE utf8_unicode_ci DEFAULT 'N', PRIMARY KEY (`cal_login`,`cal_other_user`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_access_user` -- LOCK TABLES `webcal_access_user` WRITE; /*!40000 ALTER TABLE `webcal_access_user` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_access_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_asst` -- DROP TABLE IF EXISTS `webcal_asst`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_asst` ( `cal_boss` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_assistant` varchar(25) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cal_boss`,`cal_assistant`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_asst` -- LOCK TABLES `webcal_asst` WRITE; /*!40000 ALTER TABLE `webcal_asst` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_asst` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_blob` -- DROP TABLE IF EXISTS `webcal_blob`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_blob` ( `cal_blob_id` int(11) NOT NULL, `cal_id` int(11) DEFAULT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_name` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_description` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_size` int(11) DEFAULT NULL, `cal_mime_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `cal_mod_date` int(11) NOT NULL, `cal_mod_time` int(11) NOT NULL, `cal_blob` longblob, PRIMARY KEY (`cal_blob_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_blob` -- LOCK TABLES `webcal_blob` WRITE; /*!40000 ALTER TABLE `webcal_blob` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_blob` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_categories` -- DROP TABLE IF EXISTS `webcal_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_categories` ( `cat_id` int(11) NOT NULL, `cat_owner` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cat_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, `cat_color` varchar(8) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cat_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_categories` -- LOCK TABLES `webcal_categories` WRITE; /*!40000 ALTER TABLE `webcal_categories` DISABLE KEYS */; INSERT INTO `webcal_categories` VALUES (1,NULL,'Closures','#cc0000'),(2,NULL,'Special Events','#404040'),(3,NULL,'Swim Practice/Meets','#404040'),(4,'webcal','VolleyBall','#404040'); /*!40000 ALTER TABLE `webcal_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_config` -- DROP TABLE IF EXISTS `webcal_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_config` ( `cal_setting` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `cal_value` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_setting`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_config` -- LOCK TABLES `webcal_config` WRITE; /*!40000 ALTER TABLE `webcal_config` DISABLE KEYS */; INSERT INTO `webcal_config` VALUES ('WEBCAL_TZ_CONVERSION','Y'),('ADD_LINK_IN_VIEWS','N'),('ADMIN_OVERRIDE_UAC','Y'),('ALLOW_ATTACH','N'),('ALLOW_ATTACH_ANY','N'),('ALLOW_ATTACH_PART','N'),('ALLOW_COLOR_CUSTOMIZATION','Y'),('ALLOW_COMMENTS','N'),('ALLOW_COMMENTS_ANY','N'),('ALLOW_COMMENTS_PART','N'),('ALLOW_CONFLICT_OVERRIDE','Y'),('ALLOW_CONFLICTS','N'),('ALLOW_EXTERNAL_HEADER','N'),('ALLOW_EXTERNAL_USERS','N'),('ALLOW_HTML_DESCRIPTION','Y'),('ALLOW_SELF_REGISTRATION','N'),('ALLOW_USER_HEADER','N'),('ALLOW_USER_THEMES','Y'),('ALLOW_VIEW_OTHER','Y'),('APPLICATION_NAME','Mallory Calendar'),('APPROVE_ASSISTANT_EVENT','Y'),('AUTO_REFRESH','N'),('AUTO_REFRESH_TIME','0'),('BGCOLOR','#FFFFFF'),('BGREPEAT','repeat fixed center'),('BOLD_DAYS_IN_YEAR','Y'),('CAPTIONS','#B04040'),('CATEGORIES_ENABLED','Y'),('CELLBG','#C0C0C0'),('CONFLICT_REPEAT_MONTHS','6'),('CUSTOM_HEADER','Y'),('CUSTOM_SCRIPT','Y'),('CUSTOM_TRAILER','Y'),('DATE_FORMAT','LANGUAGE_DEFINED'),('DATE_FORMAT_MD','LANGUAGE_DEFINED'),('DATE_FORMAT_MY','LANGUAGE_DEFINED'),('DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('DEMO_MODE','N'),('DISABLE_ACCESS_FIELD','N'),('DISABLE_CROSSDAY_EVENTS','N'),('DISABLE_LOCATION_FIELD','N'),('DISABLE_PARTICIPANTS_FIELD','N'),('DISABLE_POPUPS','N'),('DISABLE_PRIORITY_FIELD','N'),('DISABLE_REMINDER_FIELD','N'),('DISABLE_REPEATING_FIELD','N'),('DISABLE_URL_FIELD','Y'),('DISPLAY_ALL_DAYS_IN_MONTH','N'),('DISPLAY_CREATED_BYPROXY','Y'),('DISPLAY_DESC_PRINT_DAY','Y'),('DISPLAY_END_TIMES','N'),('DISPLAY_LOCATION','N'),('DISPLAY_LONG_DAYS','N'),('DISPLAY_MINUTES','N'),('DISPLAY_MOON_PHASES','N'),('DISPLAY_SM_MONTH','Y'),('DISPLAY_TASKS','N'),('DISPLAY_TASKS_IN_GRID','N'),('DISPLAY_UNAPPROVED','Y'),('DISPLAY_WEEKENDS','Y'),('DISPLAY_WEEKNUMBER','Y'),('EMAIL_ASSISTANT_EVENTS','Y'),('EMAIL_EVENT_ADDED','Y'),('EMAIL_EVENT_CREATE','N'),('EMAIL_EVENT_DELETED','Y'),('EMAIL_EVENT_REJECTED','Y'),('EMAIL_EVENT_UPDATED','Y'),('EMAIL_HTML','N'),('EMAIL_MAILER','mail'),('EMAIL_REMINDER','Y'),('ENABLE_CAPTCHA','N'),('ENABLE_GRADIENTS','N'),('ENABLE_ICON_UPLOADS','N'),('ENTRY_SLOTS','144'),('EXTERNAL_NOTIFICATIONS','N'),('EXTERNAL_REMINDERS','N'),('FONTS','Arial, Helvetica, sans-serif'),('FREEBUSY_ENABLED','N'),('GENERAL_USE_GMT','Y'),('GROUPS_ENABLED','N'),('H2COLOR','#000000'),('HASEVENTSBG','#FFFF33'),('IMPORT_CATEGORIES','Y'),('LANGUAGE','English-US'),('LIMIT_APPTS','N'),('LIMIT_APPTS_NUMBER','6'),('LIMIT_DESCRIPTION_SIZE','N'),('MENU_DATE_TOP','Y'),('MENU_ENABLED','Y'),('MENU_THEME','default'),('MYEVENTS','#006000'),('NONUSER_AT_TOP','Y'),('NONUSER_ENABLED','Y'),('OTHERMONTHBG','#D0D0D0'),('OVERRIDE_PUBLIC','N'),('SMTP_USERNAME',''),('PARTICIPANTS_IN_POPUP','N'),('PLUGINS_ENABLED','N'),('POPUP_BG','#FFFFFF'),('POPUP_FG','#000000'),('PUBLIC_ACCESS','Y'),('PUBLIC_ACCESS_ADD_NEEDS_APPROVAL','N'),('PUBLIC_ACCESS_CAN_ADD','N'),('PUBLIC_ACCESS_DEFAULT_SELECTED','Y'),('PUBLIC_ACCESS_DEFAULT_VISIBLE','Y'),('PUBLIC_ACCESS_OTHERS','N'),('PUBLIC_ACCESS_VIEW_PART','N'),('PUBLISH_ENABLED','Y'),('PULLDOWN_WEEKNUMBER','N'),('REMEMBER_LAST_LOGIN','N'),('REMINDER_DEFAULT','N'),('REMINDER_OFFSET','240'),('REMINDER_WITH_DATE','N'),('REMOTES_ENABLED','N'),('REPORTS_ENABLED','N'),('REQUIRE_APPROVALS','Y'),('RSS_ENABLED','N'),('SELF_REGISTRATION_BLACKLIST','N'),('SELF_REGISTRATION_FULL','Y'),('SEND_EMAIL','N'),('SERVER_TIMEZONE','America/New_York'),('SITE_EXTRAS_IN_POPUP','N'),('SMTP_AUTH','N'),('SMTP_HOST','localhost'),('SMTP_PORT','25'),('STARTVIEW','month.php'),('SUMMARY_LENGTH','80'),('TABLEBG','#000000'),('TEXTCOLOR','#000000'),('THBG','#FFFFFF'),('THFG','#000000'),('TIME_FORMAT','12'),('TIME_SLOTS','24'),('TIME_SPACER','» '),('TIMED_EVT_LEN','D'),('TIMEZONE','America/New_York'),('TODAYCELLBG','#FFFF33'),('UAC_ENABLED','N'),('USER_PUBLISH_ENABLED','Y'),('USER_PUBLISH_RW_ENABLED','Y'),('USER_RSS_ENABLED','N'),('USER_SEES_ONLY_HIS_GROUPS','Y'),('USER_SORT_ORDER','cal_lastname, cal_firstname'),('BGIMAGE',''),('WEEK_START','0'),('WEEKEND_START','6'),('WEEKENDBG','#D0D0D0'),('WEEKNUMBER','#FF6633'),('WORK_DAY_END_HOUR','17'),('WORK_DAY_START_HOUR','8'),('SERVER_URL','http://mallorycountryclub.com/calendar/'),('THEME','none'),('UPCOMING_EVENTS','N'),('UPCOMING_ALLOW_OVR','N'),('UPCOMING_DISPLAY_CAT_ICONS','Y'),('UPCOMING_DISPLAY_LAYERS','N'),('UPCOMING_DISPLAY_LINKS','Y'),('UPCOMING_DISPLAY_POPUPS','Y'),('SMTP_PASSWORD',''),('EMAIL_FALLBACK_FROM','youremailhere'),('OVERRIDE_PUBLIC_TEXT','Mallory Country Club'),('WEBCAL_PROGRAM_VERSION','v1.2.1'); /*!40000 ALTER TABLE `webcal_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry` -- DROP TABLE IF EXISTS `webcal_entry`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry` ( `cal_id` int(11) NOT NULL, `cal_group_id` int(11) DEFAULT NULL, `cal_ext_for_id` int(11) DEFAULT NULL, `cal_create_by` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_date` int(11) NOT NULL, `cal_time` int(11) DEFAULT NULL, `cal_mod_date` int(11) DEFAULT NULL, `cal_mod_time` int(11) DEFAULT NULL, `cal_duration` int(11) NOT NULL, `cal_due_date` int(11) DEFAULT NULL, `cal_due_time` int(11) DEFAULT NULL, `cal_priority` int(11) DEFAULT '5', `cal_type` char(1) COLLATE utf8_unicode_ci DEFAULT 'E', `cal_access` char(1) COLLATE utf8_unicode_ci DEFAULT 'P', `cal_name` varchar(80) COLLATE utf8_unicode_ci NOT NULL, `cal_location` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_url` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_completed` int(11) DEFAULT NULL, `cal_description` text COLLATE utf8_unicode_ci, PRIMARY KEY (`cal_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry` -- LOCK TABLES `webcal_entry` WRITE; /*!40000 ALTER TABLE `webcal_entry` DISABLE KEYS */; INSERT INTO `webcal_entry` VALUES (1,NULL,NULL,'webcal',20100416,-1,20100416,171110,0,20100416,0,5,'E','P','WebSite Calendar',NULL,NULL,NULL,'WebSite Calendar added to mallorycountryclub.com'),(2,NULL,NULL,'webcal',20100509,-1,20100419,235941,0,20100509,0,5,'E','P','Mother\'s Day',NULL,NULL,NULL,'Mother\'s Day'),(3,NULL,NULL,'webcal',20100419,-1,20100420,203,0,20100419,0,5,'E','P','Swim Team Registration At Taylor Elementary 5-7pm',NULL,NULL,NULL,'Swim Team Registration At Taylor Elementary 5-7pm'),(4,NULL,NULL,'webcal',20100419,-1,20100420,444,0,20100419,0,5,'E','P','Swimteam Registration at Taylor Elementary School, 5-7pm',NULL,NULL,NULL,'Swimteam Registration at Taylor Elementary School, 5-7pm'),(5,NULL,NULL,'webcal',20100520,-1,20100420,1036,0,20100520,0,5,'E','P','Swimteam Registration at Taylor Elementary School, 5-7pm',NULL,NULL,NULL,'Swim Team Registration at Taylor Elementary School, 5-7pm'),(6,NULL,NULL,'webcal',20100511,-1,20100420,954,0,20100511,0,5,'E','P','Swim Team Registration at Taylor Elementary School 5-7pm',NULL,NULL,NULL,'Swim Team Registration at Taylor Elementary School 5-7pm'),(7,NULL,NULL,'webcal',20100529,-1,20100420,1249,0,20100529,0,5,'E','P','Opening Day Party 11-4pm',NULL,NULL,NULL,'Opening Day Party 11-4pm'),(8,NULL,NULL,'webcal',20100525,-1,20100420,1401,0,20100525,0,5,'E','P','VBSL League Meeting @ NYCC 6:30pm',NULL,NULL,NULL,'VBSL League Meeting @ NYCC 6:30pm'),(9,NULL,NULL,'webcal',20100530,-1,20100420,1440,0,20100530,0,5,'E','P','Memorial Day',NULL,NULL,NULL,'Memorial Day'),(10,NULL,NULL,'webcal',20100419,-1,20100420,1547,0,20100419,0,5,'E','P','Pre-Opening Adult Party',NULL,NULL,NULL,'Pre-Opening Adult Party'),(11,NULL,NULL,'webcal',20100515,-1,20100420,1712,0,20100515,0,5,'E','P','Pre-Opening ADULT Party',NULL,NULL,NULL,'Pre-Opening ADULT Party'),(12,NULL,NULL,'webcal',20100601,-1,20100423,134306,0,20100601,0,5,'E','P','Afternoon Swim Team Practices Start',NULL,NULL,NULL,'Afternoon Swim Team Practices Start'),(14,NULL,NULL,'webcal',20100606,-1,20100420,3340,0,20100606,0,5,'E','P','Men\'s Volleyball Annual Draft 6pm',NULL,NULL,NULL,'Men\'s Volleyball Annual Draft 6pm'),(15,NULL,NULL,'webcal',20100607,-1,20100420,3423,0,20100607,0,5,'E','P','Morning Swim Team Practice Starts',NULL,NULL,NULL,'Morning Swim Team Practice Starts'),(16,NULL,NULL,'webcal',20100608,-1,20100420,3716,0,20100608,0,5,'E','P','Swim Team Parents Meeting During Practices',NULL,NULL,NULL,'Swim Team Parents Meeting During Practices'),(17,NULL,NULL,'webcal',20100609,-1,20100420,4013,0,20100609,0,5,'E','P','VBSL Training Clinic 6-9pm (facility closed at 5:30 to members)',NULL,NULL,NULL,'VBSL Training Clinic 6-9pm (facility closed at 5:30 to members)'),(13,NULL,NULL,'webcal',20100604,-1,20100420,4144,0,20100604,0,5,'E','P','Teen Party 7-10pm (facility closed to members @ 6pm)',NULL,NULL,NULL,'Teen Party 7-10pm\r\nPool closes @ 6pm'),(18,NULL,NULL,'webcal',20100610,-1,20100420,4247,0,20100610,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(19,NULL,NULL,'webcal',20100610,-1,20100420,4322,0,20100610,0,5,'E','P','Swim Team Time Trials During Practices',NULL,NULL,NULL,'Swim Team Time Trials During Practices'),(20,NULL,NULL,'webcal',20100615,-1,20100420,4418,0,20100615,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(21,NULL,NULL,'webcal',20100617,-1,20100420,5546,0,20100617,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(22,NULL,NULL,'webcal',20100618,-1,20100420,5640,0,20100618,0,5,'E','P','Swim Team Lunch Time Pep Rally',NULL,NULL,NULL,'Swim Team Lunch Time Pep Rally'),(23,NULL,NULL,'webcal',20100619,-1,20100420,5755,0,20100619,0,5,'E','P','Home Swim Meet @ MCC against Princess Anne',NULL,NULL,NULL,'Home Swim Meet @ MCC against Princess Anne'),(24,NULL,NULL,'webcal',20100620,-1,20100420,5832,0,20100620,0,5,'E','P','Father\'s Day',NULL,NULL,NULL,'Father\'s Day'),(25,NULL,NULL,'webcal',20100622,-1,20100420,5937,0,20100622,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(26,NULL,NULL,'webcal',20100623,-1,20100420,10012,0,20100623,0,5,'E','P','Swim Team Naro Movie Afternoon',NULL,NULL,NULL,'Swim Team Naro Movie Afternoon'),(27,NULL,NULL,'webcal',20100624,-1,20100420,10043,0,20100624,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(28,NULL,NULL,'webcal',20100625,-1,20100420,10135,0,20100625,0,5,'E','P','Swim Team TGIF Fundraiser',NULL,NULL,NULL,'Swim Team TGIF Fundraiser'),(29,NULL,NULL,'webcal',20100626,-1,20100420,10229,0,20100626,0,5,'E','P','Away Swim Meet @ Chesapeake Golf',NULL,NULL,NULL,'Away Swim Meet @ Chesapeake Golf'),(30,NULL,NULL,'webcal',20100628,-1,20100420,10331,0,20100628,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(31,NULL,NULL,'webcal',20100629,-1,20100420,10356,0,20100629,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(32,NULL,NULL,'webcal',20100630,-1,20100420,10437,0,20100630,0,5,'E','P','Swim Team Bike Day',NULL,NULL,NULL,'Swim Team Bike Day'),(33,NULL,NULL,'webcal',20100701,-1,20100420,10627,0,20100701,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(34,NULL,NULL,'webcal',20100419,-1,20100420,10703,0,20100419,0,5,'E','P','July 4th Party 11-4pm',NULL,NULL,NULL,'July 4th Party 11-4pm'),(35,NULL,NULL,'webcal',20100704,-1,20100420,10806,0,20100704,0,5,'E','P','July 4th Party 11-4pm',NULL,NULL,NULL,'July 4th Party 11-4pm'),(36,NULL,NULL,'webcal',20100706,-1,20100420,10850,0,20100706,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(37,NULL,NULL,'webcal',20100707,-1,20100420,10933,0,20100707,0,5,'E','P','Swim Team Ocen View Day',NULL,NULL,NULL,'Swim Team Ocen View Day'),(38,NULL,NULL,'webcal',20100708,-1,20100420,11022,0,20100708,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(39,NULL,NULL,'webcal',20100709,-1,20100420,11054,0,20100709,0,5,'E','P','Swim Team Lunch Time Pep Rally',NULL,NULL,NULL,'Swim Team Lunch Time Pep Rally'),(40,NULL,NULL,'webcal',20100710,-1,20100420,11204,0,20100710,0,5,'E','P','Home Swim Meet @ MCC against Great Bridge',NULL,NULL,NULL,'Home Swim Meet @ MCC against Great Bridge'),(41,NULL,NULL,'webcal',20100720,-1,20100420,11331,0,20100720,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(42,NULL,NULL,'webcal',20100712,-1,20100420,11413,0,20100712,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(43,NULL,NULL,'webcal',20100713,-1,20100420,11441,0,20100713,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(44,NULL,NULL,'webcal',20100714,-1,20100420,11536,0,20100714,0,5,'E','P','Swim Team Ocean Breeze (No Afternoon Practices)',NULL,NULL,NULL,'Swim Team Ocean Breeze (No Afternoon Practices)'),(45,NULL,NULL,'webcal',20100715,-1,20100420,11640,0,20100715,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(46,NULL,NULL,'webcal',20100715,-1,20100420,11728,0,20100715,0,5,'E','P','Pups Meet & Swim Team Car Wash',NULL,NULL,NULL,'Pups Meet & Swim Team Car Wash'),(47,NULL,NULL,'webcal',20100716,-1,20100420,11821,0,20100716,0,5,'E','P','Swim Team TGIF Fundraiser',NULL,NULL,NULL,'Swim Team TGIF Fundraiser'),(48,NULL,NULL,'webcal',20100717,-1,20100420,11913,0,20100717,0,5,'E','P','Swim Meet Away against VBTCC',NULL,NULL,NULL,'Swim Meet Away against VBTCC'),(49,NULL,NULL,'webcal',20100722,-1,20100420,12004,0,20100722,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(50,NULL,NULL,'webcal',20100723,-1,20100420,12042,0,20100723,0,5,'E','P','Swim Team Pancake Breakfast',NULL,NULL,NULL,'Swim Team Pancake Breakfast'),(51,NULL,NULL,'webcal',20100724,-1,20100420,12142,0,20100724,0,5,'E','P','Swim Team Divisional Meet @ Chesapeake Golf',NULL,NULL,NULL,'Swim Team Divisional Meet @ Chesapeake Golf'),(52,NULL,NULL,'webcal',20100725,-1,20100420,12317,0,20100725,0,5,'E','P','Swim Team Banquet 5pm (Pavillion closed to members @ 4pm)',NULL,NULL,NULL,'Swim Team Banquet 5pm (Pavillion closed to members @ 4pm)'),(53,NULL,NULL,'webcal',20100727,-1,20100420,12358,0,20100727,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(54,NULL,NULL,'webcal',20100729,-1,20100420,12430,0,20100729,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(55,NULL,NULL,'webcal',20100730,-1,20100420,12519,0,20100730,0,5,'E','P','Teen Party 7-10pm (facility closed to members @ 6pm)',NULL,NULL,NULL,'Teen Party 7-10pm\r\nPool closes @ 6pm'),(56,NULL,NULL,'webcal',20100731,-1,20100420,12612,0,20100731,0,5,'E','P','ALL STAR Swim Meet (AWAY)',NULL,NULL,NULL,'ALL STAR Swim Meet (AWAY)'),(57,NULL,NULL,'webcal',20100801,-1,20100526,155904,0,20100801,0,5,'E','P','Sunday Entertainment w/ Steve Forss 5-8pm',NULL,NULL,NULL,'Sunday Entertainment w/ Steve Forss 5-8pm'),(58,NULL,NULL,'webcal',20100802,-1,20100420,12913,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(59,NULL,NULL,'webcal',20100802,-1,20100420,12914,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(60,NULL,NULL,'webcal',20100802,-1,20100420,12914,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(61,NULL,NULL,'webcal',20100802,-1,20100420,12914,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(62,NULL,NULL,'webcal',20100802,-1,20100420,12914,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(63,NULL,NULL,'webcal',20100802,-1,20100420,12915,0,20100802,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(64,NULL,NULL,'webcal',20100803,-1,20100420,13232,0,20100803,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(65,NULL,NULL,'webcal',20100805,-1,20100420,13812,0,20100805,0,5,'E','P','MEN\'S VB Knock-Out Tournament',NULL,NULL,NULL,'MEN\'S VB Knock-Out Tournament'),(66,NULL,NULL,'webcal',20100808,-1,20100526,155949,0,20100808,0,5,'E','P','Sunday Entertainment w/ Lewis McGehee 5-8pm',NULL,NULL,NULL,'Sunday Entertainment w/ Lewis McGehee 5-8pm'),(67,NULL,NULL,'webcal',20100810,-1,20100420,13948,0,20100810,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(68,NULL,NULL,'webcal',20100812,-1,20100420,14052,0,20100812,0,5,'E','P','MEN\'S VB Double Elimination Tournament',NULL,NULL,NULL,'MEN\'S VB Double Elimination Tournament'),(69,NULL,NULL,'webcal',20100815,-1,20100420,14210,0,20100815,0,5,'E','P','Sunday Entertainment w/ TBA',NULL,NULL,NULL,'Sunday Entertainment w/ TBA'),(70,NULL,NULL,'__public__',20100816,-1,20100420,14530,0,20100816,0,5,'E','P','MEN\'S VB Double Elimination Tournament',NULL,NULL,NULL,'MEN\'S VB Double Elimination Tournament'),(71,NULL,NULL,'__public__',20100817,-1,20100420,14611,0,20100817,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(72,NULL,NULL,'webcal',20100818,-1,20100420,14652,0,20100818,0,5,'E','P','MEN\'S VB CHAMPIONSHIP TOURNAMENT',NULL,NULL,NULL,'MEN\'S VB CHAMPIONSHIP TOURNAMENT'),(73,NULL,NULL,'__public__',20100822,-1,20100420,14727,0,20100822,0,5,'E','P','Sunday Entertainment w/ TBA',NULL,NULL,NULL,'Sunday Entertainment w/ TBA'),(74,NULL,NULL,'__public__',20100824,-1,20100420,14819,0,20100824,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(75,NULL,NULL,'__public__',20100829,-1,20100526,160058,0,20100829,0,5,'E','P','Sunday Entertainment w/ David Carter 6-9pm',NULL,NULL,NULL,'Sunday Entertainment w/ David Carter 6-9pm'),(76,NULL,NULL,'__public__',20100831,-1,20100420,14908,0,20100831,0,5,'E','P','WOMEN\'S VB',NULL,NULL,NULL,'WOMEN\'S VB'),(77,NULL,NULL,'webcal',20100905,-1,20100420,15015,0,20100905,0,5,'E','P','Closing Day Party 11-4pm',NULL,NULL,NULL,'Closing Day Party 11-4pm'),(78,NULL,NULL,'webcal',20100906,-1,20100420,15202,0,20100906,0,5,'E','P','Labor Day',NULL,NULL,NULL,'Labor Day'),(79,NULL,NULL,'webcal',20100910,-1,20100420,15247,0,20100910,0,5,'E','P','Teen Party 7-10pm',NULL,NULL,NULL,'Teen Party 7-10pm'),(80,NULL,NULL,'webcal',20100911,-1,20100420,15324,0,20100911,0,5,'E','P','Pool Open 12-9:15pm',NULL,NULL,NULL,'Pool Open 12-9:15pm'),(81,NULL,NULL,'webcal',20100912,-1,20100420,15355,0,20100912,0,5,'E','P','Pool Open 12-6pm',NULL,NULL,NULL,'Pool Open 12-6pm'),(82,NULL,NULL,'__public__',20100918,-1,20100420,15423,0,20100918,0,5,'E','P','Pool Open 12-9:15pm',NULL,NULL,NULL,'Pool Open 12-9:15pm'),(83,NULL,NULL,'__public__',20100919,-1,20100420,15453,0,20100919,0,5,'E','P','Pool Open 12-6pm',NULL,NULL,NULL,'Pool Open 12-6pm'),(84,NULL,NULL,'webcal',20100820,-1,20100420,15537,0,20100820,0,5,'E','P','MCC closed for the season',NULL,NULL,NULL,'MCC closed for the season'),(85,NULL,NULL,'__public__',20100920,-1,20100420,15656,0,20100920,0,5,'E','P','MCC closed for the season',NULL,NULL,NULL,'MCC closed for the season'),(86,NULL,NULL,'webcal',20100613,-1,20100503,150315,0,20100613,0,5,'E','P','Men\'s Volleyball Annual Draft 6pm',NULL,NULL,NULL,'Men\'s Volleyball Annual Draft 6pm'),(87,NULL,NULL,'__public__',20100705,-1,20100503,150525,0,20100705,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(88,NULL,NULL,'__public__',20100726,-1,20100503,150615,0,20100726,0,5,'E','P','MEN\'S VB',NULL,NULL,NULL,'MEN\'S VB'),(89,NULL,NULL,'webcal',20100620,-1,20100503,223327,0,20100620,0,5,'E','P','Coed Pick-Up Adult Volleyball 3-5pm',NULL,NULL,NULL,'coed pick-up Adult Volleyball 3-5pm'),(90,NULL,NULL,'webcal',20100627,-1,20100503,223347,0,20100627,0,5,'E','P','Coed Pick-Up Adult Volleyball 3-5pm',NULL,NULL,NULL,'coed pick-up Adult Volleyball 3-5pm'),(91,NULL,NULL,'__public__',20100711,-1,20100503,223451,0,20100711,0,5,'E','P','Coed Pick-Up Adult Volleyball 3-5pm',NULL,NULL,NULL,'coed pick-up Adult Volleyball 3-5pm'),(92,NULL,NULL,'__public__',20100718,-1,20100503,223553,0,20100718,0,5,'E','P','Coed Pick-Up Adult Volleyball 3-5pm',NULL,NULL,NULL,'coed pick-up Adult Volleyball 3-5pm'),(93,NULL,NULL,'__public__',20100725,-1,20100503,223621,0,20100725,0,5,'E','P','Coed Pick-Up Adult Volleyball 3-5pm',NULL,NULL,NULL,'coed pick-up Adult Volleyball 3-5pm'),(94,NULL,NULL,'webcal',20100611,-1,20100503,224219,0,20100611,0,5,'E','P','Men\'s VB Sign-Ups CLOSED',NULL,NULL,NULL,'Men\'s VB Sign-Ups CLOSED'),(95,NULL,NULL,'webcal',20100718,-1,20100526,160205,0,20100718,0,5,'E','P','Sunday Entertainment w/ Slightly Bent 5-8pm',NULL,NULL,NULL,'Sunday Entertainment w/ Slightly Bent 5-8pm'),(96,NULL,NULL,'webcal',20100609,-1,20100609,202105,0,20100609,0,5,'E','P','Men\'s VB',NULL,NULL,NULL,'Men\'s VB'),(97,NULL,NULL,'webcal',20100719,-1,20100609,202158,0,20100719,0,5,'E','P','Men\'s VB',NULL,NULL,NULL,'Men\'s VB'),(98,NULL,NULL,'webcal',20100621,-1,20100609,202237,0,20100621,0,5,'E','P','Men\'s VB',NULL,NULL,NULL,'Men\'s VB'),(99,NULL,NULL,'webcal',20100802,-1,20100609,202339,0,20100802,0,5,'E','P','Men\'s VB',NULL,NULL,NULL,'Men\'s VB'),(100,NULL,NULL,'__public__',20100809,-1,20100609,203058,0,20100809,0,5,'E','P','MEN\'S VB Knock-Out Tournament',NULL,NULL,NULL,'MEN\'S VB Knock-Out Tournament'),(101,NULL,NULL,'webcal',20100815,-1,20100721,173348,0,20100815,0,5,'E','P','Sunday Entertainment w/ Prometheon 5-8pm',NULL,NULL,NULL,'Sunday Entertainment w/ Prometheon 5-8pm'),(102,NULL,NULL,'webcal',20100822,-1,20100721,173435,0,20100822,0,5,'E','P','Sunday Entertainment w/ Dino Seretis 5-8pm',NULL,NULL,NULL,'Sunday Entertainment w/ Dino Seretis 5-8pm'); /*!40000 ALTER TABLE `webcal_entry` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_categories` -- DROP TABLE IF EXISTS `webcal_entry_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_categories` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cat_id` int(11) NOT NULL DEFAULT '0', `cat_order` int(11) NOT NULL DEFAULT '0', `cat_owner` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_categories` -- LOCK TABLES `webcal_entry_categories` WRITE; /*!40000 ALTER TABLE `webcal_entry_categories` DISABLE KEYS */; INSERT INTO `webcal_entry_categories` VALUES (12,3,99,NULL); /*!40000 ALTER TABLE `webcal_entry_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_ext_user` -- DROP TABLE IF EXISTS `webcal_entry_ext_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_ext_user` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cal_fullname` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `cal_email` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_id`,`cal_fullname`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_ext_user` -- LOCK TABLES `webcal_entry_ext_user` WRITE; /*!40000 ALTER TABLE `webcal_entry_ext_user` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_entry_ext_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_log` -- DROP TABLE IF EXISTS `webcal_entry_log`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_log` ( `cal_log_id` int(11) NOT NULL, `cal_entry_id` int(11) NOT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_user_cal` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `cal_date` int(11) NOT NULL, `cal_time` int(11) DEFAULT NULL, `cal_text` text COLLATE utf8_unicode_ci, PRIMARY KEY (`cal_log_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_log` -- LOCK TABLES `webcal_entry_log` WRITE; /*!40000 ALTER TABLE `webcal_entry_log` DISABLE KEYS */; INSERT INTO `webcal_entry_log` VALUES (1,1,'webcal','webcal','C',20100416,170941,NULL),(2,1,'webcal','webcal','U',20100416,171110,NULL),(3,2,'webcal','webcal','C',20100419,235857,NULL),(4,2,'webcal','webcal','U',20100419,235941,NULL),(5,3,'webcal','webcal','C',20100420,203,NULL),(6,1,'webcal','webcal','D',20100420,257,NULL),(7,3,'webcal','webcal','X',20100420,324,NULL),(8,3,'webcal','webcal','D',20100420,344,NULL),(9,4,'webcal','webcal','C',20100420,444,NULL),(10,5,'webcal','webcal','C',20100420,600,NULL),(11,4,'webcal','__public__','D',20100420,734,NULL),(12,4,'webcal','webcal','D',20100420,734,NULL),(13,6,'webcal','webcal','C',20100420,858,NULL),(14,6,'webcal','webcal','U',20100420,954,NULL),(15,5,'webcal','webcal','U',20100420,1036,NULL),(16,7,'webcal','webcal','C',20100420,1249,NULL),(17,8,'webcal','webcal','C',20100420,1401,NULL),(18,9,'webcal','webcal','C',20100420,1440,NULL),(19,10,'webcal','webcal','C',20100420,1547,NULL),(20,10,'webcal','webcal','X',20100420,1616,NULL),(21,10,'webcal','webcal','D',20100420,1629,NULL),(22,11,'webcal','webcal','C',20100420,1712,NULL),(23,12,'webcal','webcal','C',20100420,1939,NULL),(24,13,'webcal','webcal','C',20100420,2016,NULL),(25,8,'webcal','__public__','D',20100420,2045,NULL),(26,8,'webcal','webcal','D',20100420,2045,NULL),(27,13,'webcal','webcal','U',20100420,3251,NULL),(28,14,'webcal','webcal','C',20100420,3340,NULL),(29,15,'webcal','webcal','C',20100420,3423,NULL),(30,16,'webcal','webcal','C',20100420,3716,NULL),(31,17,'webcal','webcal','C',20100420,4013,NULL),(32,13,'webcal','webcal','U',20100420,4110,NULL),(33,13,'webcal','webcal','U',20100420,4144,NULL),(34,18,'webcal','webcal','C',20100420,4247,NULL),(35,19,'webcal','webcal','C',20100420,4322,NULL),(36,20,'webcal','webcal','C',20100420,4418,NULL),(37,21,'webcal','webcal','C',20100420,5546,NULL),(38,22,'webcal','webcal','C',20100420,5640,NULL),(39,23,'webcal','webcal','C',20100420,5755,NULL),(40,24,'webcal','webcal','C',20100420,5832,NULL),(41,25,'webcal','webcal','C',20100420,5937,NULL),(42,26,'webcal','webcal','C',20100420,10012,NULL),(43,27,'webcal','webcal','C',20100420,10043,NULL),(44,28,'webcal','webcal','C',20100420,10135,NULL),(45,29,'webcal','webcal','C',20100420,10229,NULL),(46,30,'webcal','webcal','C',20100420,10331,NULL),(47,31,'webcal','webcal','C',20100420,10356,NULL),(48,32,'webcal','webcal','C',20100420,10437,NULL),(49,33,'webcal','webcal','C',20100420,10627,NULL),(50,34,'webcal','webcal','C',20100420,10703,NULL),(51,34,'webcal','__public__','D',20100420,10728,NULL),(52,34,'webcal','webcal','D',20100420,10728,NULL),(53,35,'webcal','webcal','C',20100420,10806,NULL),(54,36,'webcal','webcal','C',20100420,10850,NULL),(55,37,'webcal','webcal','C',20100420,10933,NULL),(56,38,'webcal','webcal','C',20100420,11022,NULL),(57,39,'webcal','webcal','C',20100420,11054,NULL),(58,40,'webcal','webcal','C',20100420,11204,NULL),(59,41,'webcal','webcal','C',20100420,11255,NULL),(60,41,'webcal','webcal','U',20100420,11331,NULL),(61,42,'webcal','webcal','C',20100420,11413,NULL),(62,43,'webcal','webcal','C',20100420,11441,NULL),(63,44,'webcal','webcal','C',20100420,11536,NULL),(64,45,'webcal','webcal','C',20100420,11640,NULL),(65,46,'webcal','webcal','C',20100420,11728,NULL),(66,47,'webcal','webcal','C',20100420,11821,NULL),(67,48,'webcal','webcal','C',20100420,11913,NULL),(68,49,'webcal','webcal','C',20100420,12004,NULL),(69,50,'webcal','webcal','C',20100420,12042,NULL),(70,51,'webcal','webcal','C',20100420,12142,NULL),(71,52,'webcal','webcal','C',20100420,12317,NULL),(72,53,'webcal','webcal','C',20100420,12358,NULL),(73,54,'webcal','webcal','C',20100420,12430,NULL),(74,55,'webcal','webcal','C',20100420,12519,NULL),(75,56,'webcal','webcal','C',20100420,12612,NULL),(76,57,'webcal','webcal','C',20100420,12835,NULL),(77,58,'webcal','webcal','C',20100420,12913,NULL),(78,59,'webcal','webcal','C',20100420,12914,NULL),(79,60,'webcal','webcal','C',20100420,12914,NULL),(80,61,'webcal','webcal','C',20100420,12914,NULL),(81,62,'webcal','webcal','C',20100420,12914,NULL),(82,63,'webcal','webcal','C',20100420,12915,NULL),(83,58,'webcal','__public__','D',20100420,12930,NULL),(84,58,'webcal','webcal','D',20100420,12930,NULL),(85,59,'webcal','__public__','D',20100420,12942,NULL),(86,59,'webcal','webcal','D',20100420,12942,NULL),(87,60,'webcal','__public__','D',20100420,12959,NULL),(88,60,'webcal','webcal','D',20100420,12959,NULL),(89,61,'webcal','__public__','D',20100420,13035,NULL),(90,61,'webcal','webcal','D',20100420,13035,NULL),(91,62,'webcal','__public__','D',20100420,13045,NULL),(92,62,'webcal','webcal','D',20100420,13045,NULL),(93,64,'webcal','webcal','C',20100420,13232,NULL),(94,65,'webcal','webcal','C',20100420,13812,NULL),(95,66,'webcal','webcal','C',20100420,13857,NULL),(96,67,'webcal','webcal','C',20100420,13948,NULL),(97,68,'webcal','webcal','C',20100420,14052,NULL),(98,69,'webcal','webcal','C',20100420,14137,NULL),(99,69,'webcal','webcal','U',20100420,14210,NULL),(100,70,'webcal','webcal','C',20100420,14530,NULL),(101,71,'webcal','webcal','C',20100420,14611,NULL),(102,72,'webcal','webcal','C',20100420,14652,NULL),(103,73,'webcal','webcal','C',20100420,14727,NULL),(104,74,'webcal','webcal','C',20100420,14819,NULL),(105,75,'webcal','webcal','C',20100420,14844,NULL),(106,76,'webcal','webcal','C',20100420,14908,NULL),(107,77,'webcal','webcal','C',20100420,15015,NULL),(108,78,'webcal','webcal','C',20100420,15202,NULL),(109,79,'webcal','webcal','C',20100420,15247,NULL),(110,80,'webcal','webcal','C',20100420,15324,NULL),(111,81,'webcal','webcal','C',20100420,15355,NULL),(112,82,'webcal','webcal','C',20100420,15423,NULL),(113,83,'webcal','webcal','C',20100420,15453,NULL),(114,84,'webcal','webcal','C',20100420,15537,NULL),(115,85,'webcal','webcal','C',20100420,15656,NULL),(116,84,'webcal','webcal','X',20100420,15714,NULL),(117,84,'webcal','webcal','D',20100420,15728,NULL),(118,0,'system',NULL,'x',20100422,3253,'Username: webcal, IP: 72.218.133.12'),(119,0,'system',NULL,'x',20100422,144843,'Username: mccelist, IP: 70.177.224.101'),(120,0,'system',NULL,'x',20100423,14357,'Username: webcal, IP: 72.218.133.12'),(121,12,'webcal','webcal','U',20100423,134306,NULL),(122,0,'system',NULL,'x',20100503,145950,'Username: mcc, IP: 72.218.133.12'),(123,86,'webcal','webcal','C',20100503,150315,NULL),(124,14,'webcal','webcal','X',20100503,150330,NULL),(125,14,'webcal','webcal','D',20100503,150346,NULL),(126,87,'webcal','webcal','C',20100503,150525,NULL),(127,88,'webcal','webcal','C',20100503,150615,NULL),(128,63,'webcal','webcal','X',20100503,150657,NULL),(129,63,'webcal','webcal','D',20100503,150717,NULL),(130,20,'webcal','webcal','X',20100503,223031,NULL),(131,20,'webcal','webcal','D',20100503,223048,NULL),(132,89,'webcal','webcal','C',20100503,223257,NULL),(133,89,'webcal','webcal','U',20100503,223327,NULL),(134,90,'webcal','webcal','C',20100503,223347,NULL),(135,91,'webcal','webcal','C',20100503,223451,NULL),(136,92,'webcal','webcal','C',20100503,223553,NULL),(137,93,'webcal','webcal','C',20100503,223621,NULL),(138,94,'webcal','webcal','C',20100503,224219,NULL),(139,0,'system',NULL,'x',20100526,154454,'Username: mcc, IP: 72.218.133.12'),(140,0,'system',NULL,'x',20100526,154503,'Username: mcc, IP: 72.218.133.12'),(141,57,'webcal','webcal','U',20100526,155904,NULL),(142,66,'webcal','webcal','U',20100526,155949,NULL),(143,69,'webcal','webcal','X',20100526,160000,NULL),(144,69,'webcal','webcal','D',20100526,160008,NULL),(145,73,'webcal','__public__','D',20100526,160018,NULL),(146,73,'webcal','webcal','D',20100526,160018,NULL),(147,75,'webcal','webcal','U',20100526,160058,NULL),(148,95,'webcal','webcal','C',20100526,160205,NULL),(149,0,'system',NULL,'x',20100531,131752,'Username: hillstimesfive@cox.net, IP: 72.218.132.49'),(150,0,'system',NULL,'x',20100607,182337,'Username: mcc, IP: 72.218.133.12'),(151,0,'system',NULL,'x',20100607,182359,'Username: webcal, IP: 72.218.133.12'),(152,18,'webcal','webcal','X',20100607,182519,NULL),(153,18,'webcal','webcal','D',20100607,182540,NULL),(154,0,'system',NULL,'x',20100609,201949,'Username: webcal, IP: 72.218.133.12'),(155,96,'webcal','webcal','C',20100609,202105,NULL),(156,97,'webcal','webcal','C',20100609,202158,NULL),(157,98,'webcal','webcal','C',20100609,202237,NULL),(158,99,'webcal','webcal','C',20100609,202339,NULL),(159,100,'webcal','webcal','C',20100609,203058,NULL),(160,0,'system',NULL,'x',20100609,203153,'Username: webcal, IP: 72.218.133.12'),(161,96,'webcal','webcal','X',20100609,203223,NULL),(162,96,'webcal','webcal','D',20100609,203232,NULL),(163,0,'system',NULL,'x',20100624,1528,'Username: webcal, IP: 72.218.133.12'),(164,0,'system',NULL,'x',20100624,1546,'Username: webcal, IP: 72.218.133.12'),(165,101,'webcal','webcal','C',20100721,173318,NULL),(166,101,'webcal','webcal','U',20100721,173348,NULL),(167,102,'webcal','webcal','C',20100721,173435,NULL); /*!40000 ALTER TABLE `webcal_entry_log` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_repeats` -- DROP TABLE IF EXISTS `webcal_entry_repeats`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_repeats` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cal_type` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_end` int(11) DEFAULT NULL, `cal_endtime` int(11) DEFAULT NULL, `cal_frequency` int(11) DEFAULT '1', `cal_days` char(7) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_bymonth` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_bymonthday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_byday` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_bysetpos` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_byweekno` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_byyearday` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_wkst` char(2) COLLATE utf8_unicode_ci DEFAULT 'MO', `cal_count` int(11) DEFAULT NULL, PRIMARY KEY (`cal_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_repeats` -- LOCK TABLES `webcal_entry_repeats` WRITE; /*!40000 ALTER TABLE `webcal_entry_repeats` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_entry_repeats` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_repeats_not` -- DROP TABLE IF EXISTS `webcal_entry_repeats_not`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_repeats_not` ( `cal_id` int(11) NOT NULL, `cal_date` int(11) NOT NULL, `cal_exdate` int(1) NOT NULL DEFAULT '1', PRIMARY KEY (`cal_id`,`cal_date`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_repeats_not` -- LOCK TABLES `webcal_entry_repeats_not` WRITE; /*!40000 ALTER TABLE `webcal_entry_repeats_not` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_entry_repeats_not` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_entry_user` -- DROP TABLE IF EXISTS `webcal_entry_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_entry_user` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_status` char(1) COLLATE utf8_unicode_ci DEFAULT 'A', `cal_category` int(11) DEFAULT NULL, `cal_percent` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`cal_id`,`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_entry_user` -- LOCK TABLES `webcal_entry_user` WRITE; /*!40000 ALTER TABLE `webcal_entry_user` DISABLE KEYS */; INSERT INTO `webcal_entry_user` VALUES (1,'webcal','D',NULL,0),(2,'__public__','A',NULL,0),(2,'webcal','A',NULL,0),(3,'__public__','D',NULL,0),(3,'webcal','D',NULL,0),(4,'__public__','D',NULL,0),(4,'webcal','D',NULL,0),(5,'__public__','A',NULL,0),(6,'__public__','A',NULL,0),(6,'webcal','A',NULL,0),(5,'webcal','A',NULL,0),(7,'__public__','A',NULL,0),(7,'webcal','A',NULL,0),(8,'__public__','D',NULL,0),(8,'webcal','D',NULL,0),(9,'__public__','A',NULL,0),(9,'webcal','A',NULL,0),(10,'__public__','D',NULL,0),(10,'webcal','D',NULL,0),(11,'__public__','A',NULL,0),(11,'webcal','A',NULL,0),(12,'__public__','A',NULL,0),(13,'webcal','A',NULL,0),(14,'__public__','D',NULL,0),(14,'webcal','D',NULL,0),(15,'__public__','A',NULL,0),(15,'webcal','A',NULL,0),(16,'__public__','A',NULL,0),(16,'webcal','A',NULL,0),(17,'__public__','A',NULL,0),(17,'webcal','A',NULL,0),(13,'__public__','A',NULL,0),(18,'__public__','D',NULL,0),(18,'webcal','D',NULL,0),(19,'__public__','A',NULL,0),(19,'webcal','A',NULL,0),(20,'__public__','D',NULL,0),(20,'webcal','D',NULL,0),(21,'__public__','A',NULL,0),(21,'webcal','A',NULL,0),(22,'__public__','A',NULL,0),(22,'webcal','A',NULL,0),(23,'__public__','A',NULL,0),(23,'webcal','A',NULL,0),(24,'__public__','A',NULL,0),(24,'webcal','A',NULL,0),(25,'__public__','A',NULL,0),(25,'webcal','A',NULL,0),(26,'__public__','A',NULL,0),(26,'webcal','A',NULL,0),(27,'__public__','A',NULL,0),(27,'webcal','A',NULL,0),(28,'__public__','A',NULL,0),(28,'webcal','A',NULL,0),(29,'__public__','A',NULL,0),(29,'webcal','A',NULL,0),(30,'__public__','A',NULL,0),(30,'webcal','A',NULL,0),(31,'__public__','A',NULL,0),(31,'webcal','A',NULL,0),(32,'__public__','A',NULL,0),(32,'webcal','A',NULL,0),(33,'__public__','A',NULL,0),(33,'webcal','A',NULL,0),(34,'__public__','D',NULL,0),(34,'webcal','D',NULL,0),(35,'__public__','A',NULL,0),(35,'webcal','A',NULL,0),(36,'__public__','A',NULL,0),(36,'webcal','A',NULL,0),(37,'__public__','A',NULL,0),(37,'webcal','A',NULL,0),(38,'__public__','A',NULL,0),(38,'webcal','A',NULL,0),(39,'__public__','A',NULL,0),(39,'webcal','A',NULL,0),(40,'__public__','A',NULL,0),(40,'webcal','A',NULL,0),(41,'__public__','A',NULL,0),(41,'webcal','A',NULL,0),(42,'__public__','A',NULL,0),(42,'webcal','A',NULL,0),(43,'__public__','A',NULL,0),(43,'webcal','A',NULL,0),(44,'__public__','A',NULL,0),(44,'webcal','A',NULL,0),(45,'__public__','A',NULL,0),(45,'webcal','A',NULL,0),(46,'__public__','A',NULL,0),(46,'webcal','A',NULL,0),(47,'__public__','A',NULL,0),(47,'webcal','A',NULL,0),(48,'__public__','A',NULL,0),(48,'webcal','A',NULL,0),(49,'__public__','A',NULL,0),(49,'webcal','A',NULL,0),(50,'__public__','A',NULL,0),(50,'webcal','A',NULL,0),(51,'__public__','A',NULL,0),(51,'webcal','A',NULL,0),(52,'__public__','A',NULL,0),(52,'webcal','A',NULL,0),(53,'__public__','A',NULL,0),(53,'webcal','A',NULL,0),(54,'__public__','A',NULL,0),(54,'webcal','A',NULL,0),(55,'__public__','A',NULL,0),(55,'webcal','A',NULL,0),(56,'__public__','A',NULL,0),(56,'webcal','A',NULL,0),(57,'__public__','A',NULL,0),(58,'__public__','D',NULL,0),(58,'webcal','D',NULL,0),(59,'__public__','D',NULL,0),(59,'webcal','D',NULL,0),(60,'__public__','D',NULL,0),(60,'webcal','D',NULL,0),(61,'__public__','D',NULL,0),(61,'webcal','D',NULL,0),(62,'__public__','D',NULL,0),(62,'webcal','D',NULL,0),(63,'__public__','D',NULL,0),(63,'webcal','D',NULL,0),(64,'__public__','A',NULL,0),(64,'webcal','A',NULL,0),(65,'__public__','A',NULL,0),(65,'webcal','A',NULL,0),(66,'__public__','A',NULL,0),(67,'__public__','A',NULL,0),(67,'webcal','A',NULL,0),(68,'__public__','A',NULL,0),(68,'webcal','A',NULL,0),(69,'__public__','D',NULL,0),(69,'webcal','D',NULL,0),(70,'__public__','A',NULL,0),(70,'webcal','A',NULL,0),(71,'__public__','A',NULL,0),(71,'webcal','A',NULL,0),(72,'__public__','A',NULL,0),(72,'webcal','A',NULL,0),(73,'__public__','D',NULL,0),(73,'webcal','D',NULL,0),(74,'__public__','A',NULL,0),(74,'webcal','A',NULL,0),(75,'__public__','A',NULL,0),(76,'__public__','A',NULL,0),(76,'webcal','A',NULL,0),(77,'__public__','A',NULL,0),(77,'webcal','A',NULL,0),(78,'__public__','A',NULL,0),(78,'webcal','A',NULL,0),(79,'__public__','A',NULL,0),(79,'webcal','A',NULL,0),(80,'__public__','A',NULL,0),(80,'webcal','A',NULL,0),(81,'__public__','A',NULL,0),(81,'webcal','A',NULL,0),(82,'__public__','A',NULL,0),(82,'webcal','A',NULL,0),(83,'__public__','A',NULL,0),(83,'webcal','A',NULL,0),(84,'__public__','D',NULL,0),(84,'webcal','D',NULL,0),(85,'__public__','A',NULL,0),(85,'webcal','A',NULL,0),(12,'webcal','A',NULL,0),(86,'__public__','A',NULL,0),(86,'webcal','A',NULL,0),(87,'__public__','A',NULL,0),(87,'webcal','A',NULL,0),(88,'__public__','A',NULL,0),(88,'webcal','A',NULL,0),(89,'__public__','A',NULL,0),(89,'webcal','A',NULL,0),(90,'__public__','A',NULL,0),(90,'webcal','A',NULL,0),(91,'__public__','A',NULL,0),(91,'webcal','A',NULL,0),(92,'__public__','A',NULL,0),(92,'webcal','A',NULL,0),(93,'__public__','A',NULL,0),(93,'webcal','A',NULL,0),(94,'__public__','A',NULL,0),(94,'webcal','A',NULL,0),(57,'webcal','A',NULL,0),(66,'webcal','A',NULL,0),(75,'webcal','A',NULL,0),(95,'__public__','A',NULL,0),(95,'webcal','A',NULL,0),(96,'__public__','D',NULL,0),(96,'webcal','D',NULL,0),(97,'__public__','A',NULL,0),(97,'webcal','A',NULL,0),(98,'__public__','A',NULL,0),(98,'webcal','A',NULL,0),(99,'__public__','A',NULL,0),(99,'webcal','A',NULL,0),(100,'__public__','A',NULL,0),(100,'webcal','A',NULL,0),(101,'__public__','A',NULL,0),(101,'webcal','A',NULL,0),(102,'__public__','A',NULL,0),(102,'webcal','A',NULL,0); /*!40000 ALTER TABLE `webcal_entry_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_group` -- DROP TABLE IF EXISTS `webcal_group`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_group` ( `cal_group_id` int(11) NOT NULL, `cal_owner` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `cal_last_update` int(11) NOT NULL, PRIMARY KEY (`cal_group_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_group` -- LOCK TABLES `webcal_group` WRITE; /*!40000 ALTER TABLE `webcal_group` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_group` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_group_user` -- DROP TABLE IF EXISTS `webcal_group_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_group_user` ( `cal_group_id` int(11) NOT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cal_group_id`,`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_group_user` -- LOCK TABLES `webcal_group_user` WRITE; /*!40000 ALTER TABLE `webcal_group_user` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_group_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_import` -- DROP TABLE IF EXISTS `webcal_import`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_import` ( `cal_import_id` int(11) NOT NULL, `cal_name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_date` int(11) NOT NULL, `cal_type` varchar(10) COLLATE utf8_unicode_ci NOT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_import_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_import` -- LOCK TABLES `webcal_import` WRITE; /*!40000 ALTER TABLE `webcal_import` DISABLE KEYS */; INSERT INTO `webcal_import` VALUES (1,NULL,20100502,'publish','__public__'),(2,NULL,20100503,'publish','__public__'),(3,NULL,20100616,'publish','__public__'),(4,NULL,20100705,'publish','__public__'),(5,NULL,20100705,'publish','__public__'),(6,NULL,20100908,'publish','__public__'); /*!40000 ALTER TABLE `webcal_import` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_import_data` -- DROP TABLE IF EXISTS `webcal_import_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_import_data` ( `cal_import_id` int(11) NOT NULL, `cal_id` int(11) NOT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_import_type` varchar(15) COLLATE utf8_unicode_ci NOT NULL, `cal_external_id` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_id`,`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_import_data` -- LOCK TABLES `webcal_import_data` WRITE; /*!40000 ALTER TABLE `webcal_import_data` DISABLE KEYS */; INSERT INTO `webcal_import_data` VALUES (1,11,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000011'),(2,7,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000007'),(3,15,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000015'),(4,46,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000046'),(5,50,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000050'),(6,79,'__public__','publish','-MALLORYCOUNTRYCLUB-COM-CALENDAR-__PUBLIC__-0000000079'); /*!40000 ALTER TABLE `webcal_import_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_nonuser_cals` -- DROP TABLE IF EXISTS `webcal_nonuser_cals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_nonuser_cals` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_lastname` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_firstname` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_admin` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_is_public` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N', `cal_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_nonuser_cals` -- LOCK TABLES `webcal_nonuser_cals` WRITE; /*!40000 ALTER TABLE `webcal_nonuser_cals` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_nonuser_cals` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_reminders` -- DROP TABLE IF EXISTS `webcal_reminders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_reminders` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cal_date` int(11) NOT NULL DEFAULT '0', `cal_offset` int(11) NOT NULL DEFAULT '0', `cal_related` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'S', `cal_before` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y', `cal_last_sent` int(11) NOT NULL DEFAULT '0', `cal_repeats` int(11) NOT NULL DEFAULT '0', `cal_duration` int(11) NOT NULL DEFAULT '0', `cal_times_sent` int(11) NOT NULL DEFAULT '0', `cal_action` varchar(12) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'EMAIL', PRIMARY KEY (`cal_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_reminders` -- LOCK TABLES `webcal_reminders` WRITE; /*!40000 ALTER TABLE `webcal_reminders` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_reminders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_report` -- DROP TABLE IF EXISTS `webcal_report`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_report` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_report_id` int(11) NOT NULL, `cal_is_global` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N', `cal_report_type` varchar(20) COLLATE utf8_unicode_ci NOT NULL, `cal_include_header` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Y', `cal_report_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `cal_time_range` int(11) NOT NULL, `cal_user` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_allow_nav` char(1) COLLATE utf8_unicode_ci DEFAULT 'Y', `cal_cat_id` int(11) DEFAULT NULL, `cal_include_empty` char(1) COLLATE utf8_unicode_ci DEFAULT 'N', `cal_show_in_trailer` char(1) COLLATE utf8_unicode_ci DEFAULT 'N', `cal_update_date` int(11) NOT NULL, PRIMARY KEY (`cal_report_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_report` -- LOCK TABLES `webcal_report` WRITE; /*!40000 ALTER TABLE `webcal_report` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_report` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_report_template` -- DROP TABLE IF EXISTS `webcal_report_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_report_template` ( `cal_report_id` int(11) NOT NULL, `cal_template_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `cal_template_text` text COLLATE utf8_unicode_ci, PRIMARY KEY (`cal_report_id`,`cal_template_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_report_template` -- LOCK TABLES `webcal_report_template` WRITE; /*!40000 ALTER TABLE `webcal_report_template` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_report_template` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_site_extras` -- DROP TABLE IF EXISTS `webcal_site_extras`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_site_extras` ( `cal_id` int(11) NOT NULL DEFAULT '0', `cal_name` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_type` int(11) NOT NULL, `cal_date` int(11) DEFAULT '0', `cal_remind` int(11) DEFAULT '0', `cal_data` text COLLATE utf8_unicode_ci ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_site_extras` -- LOCK TABLES `webcal_site_extras` WRITE; /*!40000 ALTER TABLE `webcal_site_extras` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_site_extras` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_timezones` -- DROP TABLE IF EXISTS `webcal_timezones`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_timezones` ( `tzid` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '', `dtstart` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `dtend` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `vtimezone` text COLLATE utf8_unicode_ci, PRIMARY KEY (`tzid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_timezones` -- LOCK TABLES `webcal_timezones` WRITE; /*!40000 ALTER TABLE `webcal_timezones` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_timezones` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_user` -- DROP TABLE IF EXISTS `webcal_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_user` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_passwd` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_lastname` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_firstname` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_is_admin` char(1) COLLATE utf8_unicode_ci DEFAULT 'N', `cal_email` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_enabled` char(1) COLLATE utf8_unicode_ci DEFAULT 'Y', `cal_telephone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_address` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_title` varchar(75) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_birthday` int(11) DEFAULT NULL, `cal_last_login` int(11) DEFAULT NULL, PRIMARY KEY (`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_user` -- LOCK TABLES `webcal_user` WRITE; /*!40000 ALTER TABLE `webcal_user` DISABLE KEYS */; INSERT INTO `webcal_user` VALUES ('webcal','e3796d9389150266ec7439ec7c8333c5','Board','Mallory','Y','','Y',NULL,NULL,NULL,NULL,NULL); /*!40000 ALTER TABLE `webcal_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_user_layers` -- DROP TABLE IF EXISTS `webcal_user_layers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_user_layers` ( `cal_layerid` int(11) NOT NULL DEFAULT '0', `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_layeruser` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_color` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_dups` char(1) COLLATE utf8_unicode_ci DEFAULT 'N', PRIMARY KEY (`cal_login`,`cal_layeruser`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_user_layers` -- LOCK TABLES `webcal_user_layers` WRITE; /*!40000 ALTER TABLE `webcal_user_layers` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_user_layers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_user_pref` -- DROP TABLE IF EXISTS `webcal_user_pref`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_user_pref` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_setting` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_value` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL, PRIMARY KEY (`cal_login`,`cal_setting`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_user_pref` -- LOCK TABLES `webcal_user_pref` WRITE; /*!40000 ALTER TABLE `webcal_user_pref` DISABLE KEYS */; INSERT INTO `webcal_user_pref` VALUES ('webcal','LANGUAGE','English-US'),('blahblahblah','LANGUAGE','none'),('__public__','LANGUAGE','English-US'),('__public__','TIMEZONE','America/New_York'),('__public__','DATE_FORMAT','LANGUAGE_DEFINED'),('__public__','DATE_FORMAT_MY','LANGUAGE_DEFINED'),('__public__','DATE_FORMAT_MD','LANGUAGE_DEFINED'),('__public__','DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('__public__','TIME_FORMAT','12'),('__public__','WEEK_START','0'),('__public__','WEEKEND_START','6'),('__public__','WORK_DAY_START_HOUR','8'),('__public__','WORK_DAY_END_HOUR','22'),('__public__','STARTVIEW','month.php'),('__public__','FONTS','Arial, Helvetica, sans-serif'),('__public__','DISPLAY_SM_MONTH','Y'),('__public__','DISPLAY_WEEKENDS','Y'),('__public__','DISPLAY_LONG_DAYS','N'),('__public__','DISPLAY_MINUTES','N'),('__public__','DISPLAY_END_TIMES','N'),('__public__','DISPLAY_ALL_DAYS_IN_MONTH','N'),('__public__','DISPLAY_WEEKNUMBER','N'),('__public__','DISPLAY_TASKS','N'),('__public__','DISPLAY_TASKS_IN_GRID','N'),('__public__','DISPLAY_MOON_PHASES','Y'),('__public__','DISPLAY_UNAPPROVED','Y'),('__public__','TIMED_EVT_LEN','D'),('__public__','CATEGORY_VIEW','0'),('__public__','DISABLE_CROSSDAY_EVENTS','Y'),('__public__','DISPLAY_DESC_PRINT_DAY','Y'),('__public__','ENTRY_SLOTS','144'),('__public__','TIME_SLOTS','24'),('__public__','AUTO_REFRESH','N'),('__public__','AUTO_REFRESH_TIME','0'),('__public__','THEME','none'),('__public__','MENU_THEME','default'),('__public__','USER_REMOTE_ACCESS','0'),('__public__','USER_PUBLISH_ENABLED','Y'),('__public__','USER_PUBLISH_RW_ENABLED','Y'),('__public__','FREEBUSY_ENABLED','N'),('__public__','BGCOLOR','#FFFFFF'),('__public__','H2COLOR','#000000'),('__public__','TEXTCOLOR','#000000'),('__public__','MYEVENTS','#000000'),('__public__','TABLEBG','#000000'),('__public__','THBG','#FFFFFF'),('__public__','THFG','#000000'),('__public__','CELLBG','#1388B9'),('__public__','TODAYCELLBG','#80FF80'),('__public__','HASEVENTSBG','#ccffee'),('__public__','WEEKENDBG','#00a2d5'),('__public__','OTHERMONTHBG','#0066cb'),('__public__','WEEKNUMBER','#0066cb'),('__public__','POPUP_BG','#FFFFFF'),('__public__','POPUP_FG','#404040'),('webcal','TIMEZONE','America/New_York'),('webcal','DATE_FORMAT','LANGUAGE_DEFINED'),('webcal','DATE_FORMAT_MY','LANGUAGE_DEFINED'),('webcal','DATE_FORMAT_MD','LANGUAGE_DEFINED'),('webcal','DATE_FORMAT_TASK','LANGUAGE_DEFINED'),('webcal','TIME_FORMAT','12'),('webcal','WEEK_START','0'),('webcal','WEEKEND_START','6'),('webcal','WORK_DAY_START_HOUR','8'),('webcal','WORK_DAY_END_HOUR','17'),('webcal','STARTVIEW','month.php'),('webcal','FONTS','Arial, Helvetica, sans-serif'),('webcal','DISPLAY_SM_MONTH','Y'),('webcal','DISPLAY_WEEKENDS','Y'),('webcal','DISPLAY_LONG_DAYS','N'),('webcal','DISPLAY_MINUTES','N'),('webcal','DISPLAY_END_TIMES','N'),('webcal','DISPLAY_ALL_DAYS_IN_MONTH','N'),('webcal','DISPLAY_WEEKNUMBER','N'),('webcal','DISPLAY_TASKS','N'),('webcal','DISPLAY_TASKS_IN_GRID','N'),('webcal','DISPLAY_MOON_PHASES','N'),('webcal','DISPLAY_UNAPPROVED','Y'),('webcal','TIMED_EVT_LEN','D'),('webcal','CATEGORY_VIEW','0'),('webcal','DISABLE_CROSSDAY_EVENTS','N'),('webcal','DISPLAY_DESC_PRINT_DAY','Y'),('webcal','ENTRY_SLOTS','144'),('webcal','TIME_SLOTS','24'),('webcal','AUTO_REFRESH','N'),('webcal','AUTO_REFRESH_TIME','0'),('webcal','APPROVE_ASSISTANT_EVENT','Y'),('webcal','DISPLAY_CREATED_BYPROXY','Y'),('webcal','USER_REMOTE_ACCESS','0'),('webcal','USER_PUBLISH_ENABLED','Y'),('webcal','USER_PUBLISH_RW_ENABLED','Y'),('webcal','FREEBUSY_ENABLED','N'),('webcal','BGCOLOR','#FFFFFF'),('webcal','H2COLOR','#000000'),('webcal','TEXTCOLOR','#202020'),('webcal','MYEVENTS','#404040'),('webcal','TABLEBG','#404040'),('webcal','THBG','#FFFFFF'),('webcal','THFG','#404040'),('webcal','CELLBG','#0869C4'),('webcal','TODAYCELLBG','#ccffcc'),('webcal','HASEVENTSBG','#ccffee'),('webcal','WEEKENDBG','#00a2d5'),('webcal','OTHERMONTHBG','#0066cb'),('webcal','WEEKNUMBER','#0066cb'),('webcal','POPUP_BG','#FFFFFF'),('webcal','POPUP_FG','#404040'),('webcal','MENU_THEME','office2003'),('webcal','THEME','none'); /*!40000 ALTER TABLE `webcal_user_pref` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_user_template` -- DROP TABLE IF EXISTS `webcal_user_template`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_user_template` ( `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_type` char(1) COLLATE utf8_unicode_ci NOT NULL, `cal_template_text` text COLLATE utf8_unicode_ci, PRIMARY KEY (`cal_login`,`cal_type`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_user_template` -- LOCK TABLES `webcal_user_template` WRITE; /*!40000 ALTER TABLE `webcal_user_template` DISABLE KEYS */; INSERT INTO `webcal_user_template` VALUES ('__system__','H','\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\"\"
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n \r\n \r\n
 \r\n + Home\r\n + Contacts Us\r\n + Swim Team\r\n + Men\'s Volleyball\r\n + Women\'s Volleyball\r\n + Party & Entertainment\r\n + Snack Bar\r\n + Membership\r\n + Sports Program\r\n + Documents
\r\n\r\n
\r\n\r\n\r\n
\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
\r\n\r\n Subscribe to Mallory Emails!
\r\n\r\n\r\n Follow the Mallory on Twitter!
\r\n\r\n Map to the Mallory
\r\n\r\n Mallory Calendar
\r\n
\r\n'),('__system__','T','
\r\n
\r\n\r\n
\r\n\r\n\r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n \r\n \r\n \r\n \r\n \r\n\r\n \r\n \r\n
\r\n Home\r\n Contacts Us\r\n Swim Team\r\n Men\'s Volleyball\r\n Women\'s Volleyball\r\n Party & Entertainment\r\n\r\n Snack Bar\r\n Membership\r\n Sports Program\r\n Documents
\r\n
Home of the Dolphins!

\r\n'),('__system__','S','\r\n'); /*!40000 ALTER TABLE `webcal_user_template` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_view` -- DROP TABLE IF EXISTS `webcal_view`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_view` ( `cal_view_id` int(11) NOT NULL, `cal_owner` varchar(25) COLLATE utf8_unicode_ci NOT NULL, `cal_name` varchar(50) COLLATE utf8_unicode_ci NOT NULL, `cal_view_type` char(1) COLLATE utf8_unicode_ci DEFAULT NULL, `cal_is_global` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'N', PRIMARY KEY (`cal_view_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_view` -- LOCK TABLES `webcal_view` WRITE; /*!40000 ALTER TABLE `webcal_view` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_view` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `webcal_view_user` -- DROP TABLE IF EXISTS `webcal_view_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `webcal_view_user` ( `cal_view_id` int(11) NOT NULL, `cal_login` varchar(25) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`cal_view_id`,`cal_login`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `webcal_view_user` -- LOCK TABLES `webcal_view_user` WRITE; /*!40000 ALTER TABLE `webcal_view_user` DISABLE KEYS */; /*!40000 ALTER TABLE `webcal_view_user` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2010-10-25 18:41:21