-- MySQL dump 9.11
--
-- Host: localhost Database: jordan6_wcln1
-- ------------------------------------------------------
-- Server version 4.0.27-standard
--
-- Table structure for table `webcal_asst`
--
CREATE TABLE webcal_asst (
cal_boss varchar(25) NOT NULL default '',
cal_assistant varchar(25) NOT NULL default '',
PRIMARY KEY (cal_boss,cal_assistant)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_asst`
--
--
-- Table structure for table `webcal_categories`
--
CREATE TABLE webcal_categories (
cat_id int(11) NOT NULL default '0',
cat_owner varchar(25) default NULL,
cat_name varchar(80) NOT NULL default '',
PRIMARY KEY (cat_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_categories`
--
--
-- Table structure for table `webcal_config`
--
CREATE TABLE webcal_config (
cal_setting varchar(50) NOT NULL default '',
cal_value varchar(100) default NULL,
PRIMARY KEY (cal_setting)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_config`
--
INSERT INTO webcal_config VALUES ('application_name','WebCalendar');
INSERT INTO webcal_config VALUES ('LANGUAGE','English-US');
INSERT INTO webcal_config VALUES ('demo_mode','N');
INSERT INTO webcal_config VALUES ('require_approvals','Y');
INSERT INTO webcal_config VALUES ('groups_enabled','N');
INSERT INTO webcal_config VALUES ('user_sees_only_his_groups','N');
INSERT INTO webcal_config VALUES ('categories_enabled','N');
INSERT INTO webcal_config VALUES ('allow_conflicts','N');
INSERT INTO webcal_config VALUES ('conflict_repeat_months','6');
INSERT INTO webcal_config VALUES ('disable_priority_field','N');
INSERT INTO webcal_config VALUES ('disable_access_field','N');
INSERT INTO webcal_config VALUES ('disable_participants_field','N');
INSERT INTO webcal_config VALUES ('disable_repeating_field','N');
INSERT INTO webcal_config VALUES ('allow_view_other','Y');
INSERT INTO webcal_config VALUES ('remember_last_login','Y');
INSERT INTO webcal_config VALUES ('allow_color_customization','Y');
INSERT INTO webcal_config VALUES ('BGCOLOR','#FF9900');
INSERT INTO webcal_config VALUES ('TEXTCOLOR','#000000');
INSERT INTO webcal_config VALUES ('H2COLOR','#000000');
INSERT INTO webcal_config VALUES ('CELLBG','#C0C0C0');
INSERT INTO webcal_config VALUES ('WEEKENDBG','#D0D0D0');
INSERT INTO webcal_config VALUES ('TABLEBG','#000000');
INSERT INTO webcal_config VALUES ('THBG','#FFFFFF');
INSERT INTO webcal_config VALUES ('THFG','#000000');
INSERT INTO webcal_config VALUES ('POPUP_FG','#000000');
INSERT INTO webcal_config VALUES ('POPUP_BG','#FF9900');
INSERT INTO webcal_config VALUES ('TODAYCELLBG','#FFFF33');
INSERT INTO webcal_config VALUES ('STARTVIEW','week.php');
INSERT INTO webcal_config VALUES ('WEEK_START','0');
INSERT INTO webcal_config VALUES ('TIME_FORMAT','12');
INSERT INTO webcal_config VALUES ('DISPLAY_UNAPPROVED','Y');
INSERT INTO webcal_config VALUES ('DISPLAY_WEEKNUMBER','Y');
INSERT INTO webcal_config VALUES ('WORK_DAY_START_HOUR','8');
INSERT INTO webcal_config VALUES ('WORK_DAY_END_HOUR','23');
INSERT INTO webcal_config VALUES ('send_email','N');
INSERT INTO webcal_config VALUES ('EMAIL_REMINDER','Y');
INSERT INTO webcal_config VALUES ('EMAIL_EVENT_ADDED','Y');
INSERT INTO webcal_config VALUES ('EMAIL_EVENT_UPDATED','Y');
INSERT INTO webcal_config VALUES ('EMAIL_EVENT_DELETED','Y');
INSERT INTO webcal_config VALUES ('EMAIL_EVENT_REJECTED','Y');
INSERT INTO webcal_config VALUES ('auto_refresh','N');
INSERT INTO webcal_config VALUES ('nonuser_enabled','N');
INSERT INTO webcal_config VALUES ('allow_html_description','Y');
INSERT INTO webcal_config VALUES ('reports_enabled','N');
INSERT INTO webcal_config VALUES ('DISPLAY_WEEKENDS','Y');
INSERT INTO webcal_config VALUES ('DISPLAY_DESC_PRINT_DAY','N');
INSERT INTO webcal_config VALUES ('DATE_FORMAT','__month__ __dd__, __yyyy__');
INSERT INTO webcal_config VALUES ('TIME_SLOTS','24');
INSERT INTO webcal_config VALUES ('TIMED_EVT_LEN','D');
INSERT INTO webcal_config VALUES ('PUBLISH_ENABLED','N');
INSERT INTO webcal_config VALUES ('DATE_FORMAT_MY','__month__ __yyyy__');
INSERT INTO webcal_config VALUES ('DATE_FORMAT_MD','__month__ __dd__');
INSERT INTO webcal_config VALUES ('CUSTOM_SCRIPT','N');
INSERT INTO webcal_config VALUES ('CUSTOM_HEADER','Y');
INSERT INTO webcal_config VALUES ('CUSTOM_TRAILER','N');
INSERT INTO webcal_config VALUES ('bold_days_in_year','Y');
INSERT INTO webcal_config VALUES ('site_extras_in_popup','N');
INSERT INTO webcal_config VALUES ('add_link_in_views','Y');
INSERT INTO webcal_config VALUES ('allow_conflict_override','Y');
INSERT INTO webcal_config VALUES ('limit_appts','N');
INSERT INTO webcal_config VALUES ('limit_appts_number','12');
INSERT INTO webcal_config VALUES ('public_access','Y');
INSERT INTO webcal_config VALUES ('public_access_default_visible','Y');
INSERT INTO webcal_config VALUES ('public_access_default_selected','N');
INSERT INTO webcal_config VALUES ('public_access_others','Y');
INSERT INTO webcal_config VALUES ('public_access_can_add','N');
INSERT INTO webcal_config VALUES ('public_access_add_needs_approval','Y');
INSERT INTO webcal_config VALUES ('public_access_view_part','N');
INSERT INTO webcal_config VALUES ('nonuser_at_top','Y');
INSERT INTO webcal_config VALUES ('allow_external_users','N');
INSERT INTO webcal_config VALUES ('external_notifications','N');
INSERT INTO webcal_config VALUES ('external_reminders','N');
INSERT INTO webcal_config VALUES ('enable_gradients','N');
INSERT INTO webcal_config VALUES ('server_url','http://www.jordanslounge.com/calendar1/');
INSERT INTO webcal_config VALUES ('FONTS','Arial, Helvetica, sans-serif');
INSERT INTO webcal_config VALUES ('auto_refresh_time','0');
--
-- Table structure for table `webcal_entry`
--
CREATE TABLE webcal_entry (
cal_id int(11) NOT NULL default '0',
cal_group_id int(11) default NULL,
cal_ext_for_id int(11) default NULL,
cal_create_by varchar(25) NOT NULL default '',
cal_date int(11) NOT NULL default '0',
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 default '0',
cal_priority int(11) default '2',
cal_type char(1) default 'E',
cal_access char(1) default 'P',
cal_name varchar(80) NOT NULL default '',
cal_description text,
PRIMARY KEY (cal_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry`
--
INSERT INTO webcal_entry VALUES (2,NULL,NULL,'jordan6',20061205,170000,20061204,165711,60,2,'E','P','jig test 2','jig test 2');
INSERT INTO webcal_entry VALUES (3,NULL,NULL,'jordan6',20061205,180000,20061204,170143,60,2,'E','P','jig test 3','jig test 3');
INSERT INTO webcal_entry VALUES (4,NULL,NULL,'jordan6',20061205,180000,20061204,170223,60,2,'E','P','Jig Test 3','Jig Test 3');
INSERT INTO webcal_entry VALUES (5,NULL,NULL,'jordan6',20061205,180000,20061204,170231,60,2,'E','P','Jig Test 3','Jig Test 3');
INSERT INTO webcal_entry VALUES (6,NULL,NULL,'jordan6',20061205,190000,20061204,170306,60,2,'E','P','jig test 3','jig test 3');
INSERT INTO webcal_entry VALUES (7,NULL,NULL,'jordan6',20061206,140000,20061204,170358,60,2,'E','P','jig test 4','jig test 4');
INSERT INTO webcal_entry VALUES (8,NULL,NULL,'jordan6',20061207,140000,20061204,173452,0,2,'E','P','jig test 4','jig test 4');
INSERT INTO webcal_entry VALUES (1,NULL,NULL,'jordan6',20061205,210000,20061204,185139,300,2,'E','P','Jig Test','Jig Test\r\nhttp://www.jordanslounge.com');
INSERT INTO webcal_entry VALUES (9,NULL,NULL,'jordan6',20061206,120000,20061204,185810,0,2,'E','P','asdf','sadf');
INSERT INTO webcal_entry VALUES (10,NULL,NULL,'jordan6',20061203,-1,20061204,213115,0,2,'E','P','Monday Night Football & “Hot Wings” and “Cold Beer”','Doors open at 4pm and Close 2 am\r\nComplimentary Hot Wing Buffet from 4 pm to 7 pm\r\nCome watch Monday Night Football on a Big screen TV with surround sound\r\nHappy Hour from 4 pm to 7 pm\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $ 4.00\r\n');
INSERT INTO webcal_entry VALUES (11,NULL,NULL,'jordan6',20061204,-1,20070108,170955,0,2,'M','P','Monday Night Movies & Old School Hip Hop Music','Doors open at 4pm and Close 2 am\r\nComplimentary Hot Dogs and Chips from 4 pm to 1 am\r\nCome watch your Favorite Movies on a Big screen TV with surround sound and Listen to Old School Hip Hop Music \r\nHappy Hour from 4 pm to 7 pm\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $ 4.00\r\n');
INSERT INTO webcal_entry VALUES (12,NULL,NULL,'jordan6',20061203,210000,20061204,213815,240,2,'E','P','“Karaoke Sunday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n');
INSERT INTO webcal_entry VALUES (13,NULL,NULL,'jordan6',20061203,-1,20061204,233919,0,2,'M','P','Karaoke Sunday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n');
INSERT INTO webcal_entry VALUES (14,NULL,NULL,'jordan6',20061206,-1,20061204,230123,0,2,'M','P','“Karaoke Wednesday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n');
INSERT INTO webcal_entry VALUES (15,NULL,NULL,'jordan6',20061207,-1,20071204,132959,0,2,'M','P','Thursdays After Work Comedy HOSTED BY: MARLON RANDOLPH','Hosted by Comedian \'MARLON RANDOLPH\r\nAdmission $7.00 \r\nDoors open at 6:00 pm\r\nShow time 7:30 pm\r\nTwo Drink Minimum per person (No Exceptions)\r\n');
INSERT INTO webcal_entry VALUES (16,NULL,NULL,'jordan6',20061208,-1,20061204,230631,0,2,'M','P','Jordan’s “Fish Fry” Friday (Dress Code Enforced)','Doors open at 4 pm and Close 3 am\r\nComplimentary Fish Buffet from 4 pm to 7 pm \r\nMusic By: JC finest Angelo and Brian \r\nHappy Hour from 4 pm to 7 pm\r\nAll Wines $4.50 Glass \r\nLong Island Ice tea $6.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n');
INSERT INTO webcal_entry VALUES (17,NULL,NULL,'jordan6',20061209,-1,20061204,230926,0,2,'M','P','Saturday Music By: JC finest Angelo and Brian (9 pm to 2am) (Dress Code Enforced','Doors open at 4 pm and Close 3 am\r\nMusic By: JC finest Angelo and Brian \r\nHappy Hour from 4 pm to 7 pm\r\nLong Island Ice Tea $6.50\r\n\"Sex on the Beach’ $5.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n\r\n');
INSERT INTO webcal_entry VALUES (18,NULL,NULL,'jordan6',20061222,-1,20061204,232131,0,2,'M','P','Cypher Movement Poetry Slam','Door open 6 pm\r\n\r\nShow time at 7 pm\r\n\r\nAdmission $5.00');
INSERT INTO webcal_entry VALUES (19,13,NULL,'jordan6',20061231,-1,20061204,233225,0,2,'E','P','NEW YEARS EVE MASQUERADE BALL',' RING IN THE NEW YEAR\r\n @\r\n JERSEY CITY’S HOTTEST SPOT\r\n JORDAN’S LOUNGE\r\n MASQUERADE BALL\r\n 247 NEWARK AVE J.C.N.J.\r\n DECEMBER 31,2006 9 pm UNTIL NEXT YEAR. \r\n WATCH THE BALL DROP ON J.C. LARGEST TV SCREEN\r\n TWO ROOMS OF NON-STOP ENTERTAINMENT \r\n \r\n HOT & COLD HORES D’OEUVRES\r\n CHAMPAGNE TOAST AT MIDNIGHT\r\n FREE PARTY FAVORS\r\n\r\nTICKETS $35 IN ADVANCE \r\nCOUPLES $60 IN ADVANCE\r\nMORE @ THE DOOR NO TICKETS SOLD DAY OF EVENT\r\nDRESS CODE IS CLASSY FOR MORE INFO AND TICKETS CONTACT:\r\nJORDANSLOUNGE.COM 201-418-0900\r\n');
INSERT INTO webcal_entry VALUES (20,NULL,NULL,'jordan6',20061210,-1,20061204,234233,0,2,'M','P','“Karaoke Sunday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n');
INSERT INTO webcal_entry VALUES (21,20,NULL,'jordan6',20061231,-1,20061204,234952,0,2,'E','P','NEW YEARS EVE \'MASQUERADE BALL\'',' RING IN THE NEW YEAR\r\n @\r\n JERSEY CITY’S HOTTEST SPOT\r\n JORDAN’S LOUNGE \r\n NEW YEARS EVE MASQUERADE BALL\r\n 247 NEWARK AVE J.C.N.J.\r\n DECEMBER 31 9 pm UNTIL NEXT YEAR \r\n WATCH THE BALL DROP ON J.C. LARGEST TV SCREEN\r\n TWO ROOMS OF NON-STOP ENTERTAINMENT \r\n HOT & COLD HORES D’OEUVRES\r\n CHAMPAGNE TOAST AT MIDNIGHT\r\n FREE PARTY FAVORS\r\n\r\nTICKETS $35 IN ADVANCE \r\nCOUPLES $60 IN ADVANCE\r\nMORE @ THE DOOR NO TICKETS SOLD DAY OF EVENT\r\nDRESS CODE IS CLASSY FOR MORE INFO AND TICKETS CONTACT:\r\nJORDANSLOUNGE.COM 201-418-0900\r\n \r\n');
INSERT INTO webcal_entry VALUES (22,NULL,NULL,'jordan6',20070110,210000,20070108,172244,240,2,'E','P','“Karaoke Wednesday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\n');
INSERT INTO webcal_entry VALUES (24,NULL,NULL,'jordan6',20070103,-1,20070108,171913,0,2,'E','P','“Karaoke Wednesday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\n');
INSERT INTO webcal_entry VALUES (23,NULL,NULL,'jordan6',20070117,180000,20070108,172744,330,2,'M','P','\'SOULFUL WEDNESDAYS\' Hosted By: UNEEEK ENTERTAINMENT','Featuring Live Entertainment\r\n\r\nJazz, R&B, and Poetry\r\n\r\nCover Charge is $10.00 (2 Drink Minimum)\r\n\r\nShow Time at 6 pm\r\n\r\nFor more information contact:\r\n\r\nRhonda 862-579-9104\r\nRHONDA879@YAHOO.COM \r\n\r\nSEC 201-892-0105\r\nwww.uneeekentertainment.com\r\n\r\nDirection visit: www.jordanslounge.com');
INSERT INTO webcal_entry VALUES (25,20,NULL,'jordan6',20070128,-1,20070131,161159,0,2,'E','P','“SUPER BOWL PARTY”','COME WATCH THE GAME IN TWO ROOMS WITH HD PROJECTOR SCREEN TV’S\'\r\n \r\nAdmission - $10.00\r\n\r\nStarts at 5 pm\r\n\r\nFree Buffet \r\n\r\nAfter Party Following The Game\r\n\r\nKaraoke from 9pm to 1 am\r\n\r\n');
INSERT INTO webcal_entry VALUES (26,20,NULL,'jordan6',20070204,-1,20070131,161435,0,2,'E','P','“SUPER BOWL PARTY”','COME WATCH THE GAME IN TWO ROOMS WITH HD PROJECTOR SCREEN TV’S\'\r\n \r\nAdmission - $10.00\r\n\r\nStarts at 5 pm\r\n\r\nFree Buffet \r\n\r\nAfter Party Following The Game\r\n\r\nKaraoke from 9pm to 1 am\r\n\r\n');
INSERT INTO webcal_entry VALUES (27,NULL,NULL,'jordan6',20060128,-1,20070131,161538,0,2,'M','P','“Karaoke Sunday’s” Come Sing with MO JO HOSTED BY: KISHA','Doors open at 4 pm and Close 2 am\r\nKaraoke from 9pm to 1 am\r\nHappy Hour from 4 pm to 7 pm\r\nAll Martini $7.00\r\nLong Island Ice tea $7.00\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n');
INSERT INTO webcal_entry VALUES (28,NULL,NULL,'jordan6',20070228,-1,20070221,210547,0,2,'E','P','WEST INDIAN ‘WHAT A GWAN WEDNESDAYS’','357 PRODUCTIONS\r\nPRESENTS WEST INDIAN\r\n\r\n\r\n‘WHAT A GWAN WEDNESDAYS’\r\n\r\nAT\r\n\r\nJORDAN’S LOUNGE\r\n247 NEWARK AVE.\r\nJERSEY CITY NJ\r\n201-418-0900\r\n\r\n\r\n\r\nSTARTING WEDNESDAY FEBRUARY 28, 2007 & EVERY WEDNESDAY AFTER\r\n\r\nWEST INDIAN BUFFET\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nMUSIC BY: \r\nJV 357 OF BLACKTALONS 357 & \r\nDJ SUPA-DICE & \r\nNATURAL PROMOTIONS \r\n\r\nPRICE: $5.00\r\n\r\nDOORS OPEN AT 9 PM\r\n\r\n\r\n');
INSERT INTO webcal_entry VALUES (29,NULL,NULL,'jordan6',20070307,-1,20070425,142415,0,2,'M','P','WEST INDIAN \'HOT_WUK\' WEDNESDAYS’','FIRST CLASS ENTERTAINMENT\r\n\r\nPRESENTS WEST INDIAN ‘HOT_WUK WEDNESDAYS’\r\n\r\nAT\r\n\r\nJORDAN’S LOUNGE\r\n247 NEWARK AVE.\r\nJERSEY CITY NJ\r\n201-418-0900\r\n\r\nEVERY WEDNESDAY \r\n\r\nMUSIC BY: \r\nPLATINUM VYBZ SOUNDS\r\n\r\nPRICE: $5.00\r\n\r\nDOORS OPEN AT 9 PM\r\n\r\nDIRECTIONS VISIT: www.jordanslounge.com\r\n');
INSERT INTO webcal_entry VALUES (30,NULL,NULL,'jordan6',20070424,-1,20070425,144151,0,2,'M','P','\'CHICKEN & WAFFLES\' TUESDAYS','COME JOIN US FOR SOME \"FREE\" HARLEM\'S FAMOUS FRIED CHICKEN & WAFFLES AND WATCH MOVIES OR LISTEN TO MUSIC FROM THE 70\'s, 80\'s AND 90\'s');
INSERT INTO webcal_entry VALUES (31,30,NULL,'jordan6',20070626,-1,20070628,135302,0,2,'M','P','\'CHICKEN & WAFFLES\' TUESDAYS','COME JOIN US FOR SOME \"FREE\" HARLEM\'S FAMOUS FRIED CHICKEN & WAFFLES AND WATCH MOVIES OR LISTEN TO MUSIC FROM THE 70\'s, 80\'s AND 90\'s');
INSERT INTO webcal_entry VALUES (32,29,NULL,'jordan6',20070627,-1,20070628,135427,0,2,'M','P','WEST INDIAN \'HOT_WUK\' WEDNESDAYS’','FIRST CLASS ENTERTAINMENT\r\n\r\nPRESENTS WEST INDIAN ‘HOT_WUK WEDNESDAYS’\r\n\r\nAT\r\n\r\nJORDAN’S LOUNGE\r\n247 NEWARK AVE.\r\nJERSEY CITY NJ\r\n201-418-0900\r\n\r\nEVERY WEDNESDAY \r\n\r\nMUSIC BY: \r\nPLATINUM VYBZ SOUNDS\r\n\r\nPRICE: $5.00\r\n\r\nDOORS OPEN AT 9 PM\r\n\r\nDIRECTIONS VISIT: www.jordanslounge.com\r\n');
INSERT INTO webcal_entry VALUES (33,16,NULL,'jordan6',20070629,-1,20070628,140914,0,2,'M','P','T.G.I.Fridays (Dress Code Enforced)','Doors open at 4 pm and Close 3 am\r\nFree B4 11 pm, $5.00 after with proper attire, and $10.00 or more without proper attire\r\nMusic By: JC finest Angelo and Brian \r\nHappy Hour from 4 pm to 7 pm\r\nAll Wines $4.50 Glass \r\nLong Island Ice tea $6.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n');
INSERT INTO webcal_entry VALUES (34,NULL,NULL,'jordan6',20061201,-1,20070628,141734,0,2,'M','P','Jordan’s “Fish Fry Friday \"(Dress Code Enforced)','Doors open at 4 pm and Close 3 am\r\nComplimentary Fish Buffet from 4 pm to 7 pm \r\nMusic By: JC finest Angelo and Brian \r\nHappy Hour from 4 pm to 7 pm\r\nAll Wines $4.50 Glass \r\nLong Island Ice tea $6.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES. THE PURCHASER OF THE RENTAL AGREEMENT IS RESPONSIBLE FOR INFORMING THEIR GUEST NOT TO SMOKE IN JORDAN’S LOUNGE OR THEIR BATHROOMS. \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n \r\n');
INSERT INTO webcal_entry VALUES (35,NULL,NULL,'jordan6',20070629,-1,20070628,142707,0,2,'M','P','T.G.I.Fridays (Dress Code Enforced)','Doors open at 4 pm and Close 3 am\r\n\r\nFree B4 11 pm, $5.00 after with proper attire, and $10.00 or more without proper attire\r\n\r\nMusic By: JC finest Swift and Brian \r\n\r\nHappy Hour from 4 pm to 7 pm\r\nAll Wines $4.50 Glass \r\nLong Island Ice tea $6.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES. THE PURCHASER OF THE RENTAL AGREEMENT IS RESPONSIBLE FOR INFORMING THEIR GUEST NOT TO SMOKE IN JORDAN’S LOUNGE OR THEIR BATHROOMS. \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n \r\n\r\n');
INSERT INTO webcal_entry VALUES (36,35,NULL,'jordan6',20071228,-1,20070628,143346,0,2,'M','P','T.G.I.Fridays (Dress Code Enforced)','Doors open at 4 pm and Close 3 am\r\n\r\nFree B4 11 pm, $5.00 after with proper attire, and $10.00 or more without proper attire\r\n\r\nMusic By: JC finest Swift and Brian \r\n\r\nHappy Hour from 4 pm to 7 pm\r\nAll Wines $4.50 Glass \r\nLong Island Ice tea $6.50\r\nAll Domestic Beers $3.00\r\nAll Imported Beers $4.00\r\n\r\nDEAR PATRONS,\r\n\r\nIN ORDER TO PROMOTE A MORE UNIFORMED ATMOSPHERE AT JORDAN’S LOUNGE, WE ASK THAT YOU PLEASE ADHERE TO THE FOLLOWING RULES OF THE LOUNGE POLICY REGARDING OUR DRESS CODE AND AGE REQUIREMENTS:\r\n\r\nLADIES AND GENTLEMEN: WE RESERVE THE RIGHT TO “UN-INVITE” ANYONE WEARING THE FOLLOWING APPAREL:\r\n\r\nDO-RAGS OR BASEBALL CAPS OF ANY KIND (UNACCEPTABLE) DRESS HAT ARE ACCEPTABLE\r\n\r\nWHITE OR COLOR TEE - SHIRTS (UNACCEPTABLE, A DRESS SHIRT OR A SHIRT WITH A COLLAR IS PREFERRED)\r\n\r\n*JERSEYS OR HOODED SHIRTS (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n**WORK BOOTS & SNEAKERS OF ANY KIND (UNACCEPTABLE ON THURSDAYS, FRIDAYS & SATURDAYS NIGHTS OR NIGHTS OF EVENTS)\r\n\r\n*** ALL LADIES MUST BE 28 AND GENTLEMEN MUST BE 28 YEARS OF AGE AND OLDER AND EVERYONE MUST SHOW AND CARRY A VALID NEW JERSEY STATE ID. NO EXCEPTIONS (ONLY STATE ID ARE ACCEPTABLE)\r\n\r\n**** NEW JERSEY STATE LAW PROHIBITS SMOKING IN BARS, RESTAURANTS, AND ALL PUBLIC PLACES. THE PURCHASER OF THE RENTAL AGREEMENT IS RESPONSIBLE FOR INFORMING THEIR GUEST NOT TO SMOKE IN JORDAN’S LOUNGE OR THEIR BATHROOMS. \r\n\r\nTHERE WILL BE ABSOLUTELY “NO EXCEPTIONS” TO THE ABOVE DOOR POLICY!\r\nWE ASK THAT YOU PLEASE “RESPECT” THIS POLICY. WE WANT EVERYONE TO FEEL WELCOMED IN ENJOYING A RELAXED AND SOCIAL ENVIRONMENT.\r\n\r\nAT JORDAN’S LOUNGE, WE THANK YOU FOR YOUR PATRONAGE!\r\n\r\n\r\nOWNER: JORDAN\r\n \r\n\r\n');
INSERT INTO webcal_entry VALUES (37,15,NULL,'jordan6',20070628,-1,20070628,145316,0,2,'M','P','Thursdays After Work Comedy HOSTED BY: \'MARLON RANDOLPH\'','Hosted by Comedian \'MARLON RANDOLPH\'\r\n\r\nAdmission $7.00 B4 7 pm with flyer and $10.00 after 7 pm \r\n\r\nDoors open at 6:00 pm\r\nShow time 7:30 pm\r\n\r\nTwo Drink Minimum per person (No Exceptions)\r\n\r\nFor more information visit\r\n\r\nwww.partiesinnj.com\r\n\r\nwww.myspace.com/jordanscomedynight.com\r\n');
INSERT INTO webcal_entry VALUES (38,15,NULL,'jordan6',20070705,-1,20070628,150953,0,2,'M','P','Thursdays After Work Comedy HOSTED BY: MARLON RANDOLPH','Hosted by Comedian \'MARLON RANDOLPH’\r\n\r\nAdmission $7.00 B4 7 pm with flyer, and $10.00 after 7 pm.\r\n \r\nDoors open at 6:00 pm\r\n\r\nShow time 7:30 pm\r\n\r\nTwo Drink Minimum per person (No Exceptions)\r\n\r\nFor information visit\r\n\r\nwww.partiesinnj.com\r\n\r\nwww.myspace.com/jordanscomedynight.com\r\n');
INSERT INTO webcal_entry VALUES (39,NULL,NULL,'jordan6',20070628,-1,20070628,151459,0,2,'E','P','Thursdays After Work Comedy Hosted By \'MARLON RANDOLPH\'','Admission $7.00 B4 7 pm with flyer, and $10.00 after 7 pm.\r\n\r\nDoors open at 6:00 pm\r\n\r\nShow time 7:30 pm\r\n\r\nTwo Drink Minimum per person (No Exceptions)\r\n\r\nFor information visit\r\n\r\nwww.partiesinnj.com\r\n\r\nwww.myspace.com/jordanscomedynight.com');
INSERT INTO webcal_entry VALUES (40,11,NULL,'jordan6',20071231,-1,20071214,151335,0,2,'E','P','JORDAN\'S LOUNGE \'NEW YEARS EVE\' CELEBRATION','Jordan\'s Lounge Presents\r\n\r\n\'WE B POPPIN\'\r\n\r\nNEW YEAR\'S EVE CELEBRATION\r\n\r\nChampagne Toast @ Midnite\r\n\r\nComplimentary Open Buffet, Party Favors.\r\n \r\nTWO ROOMS OF MUSIC. \r\n\r\nDoors open at 8pm \r\n\r\nTHIS IS A CUSTOMER APPRECIATION EVENT\r\n\r\nAdmission $15.00 per person at the door or $15.00 to be on our guest list. \r\n\r\n\r\n\r\n\r\n');
INSERT INTO webcal_entry VALUES (41,NULL,NULL,'jordan6',20071206,-1,20071204,140945,0,2,'M','P','Thursdays After Work Comedy HOSTED BY: MARLON RANDOLPH','Hosted by Comedian Personality ‘MARLON’\r\nAdmission $7.00 B4 7pm and $10.00 after 7 pm \r\nDoors open at 6:00 pm\r\nShow time 7:30 pm\r\nTwo Drink Minimum per person (No Exceptions)\r\n\r\nThursday’s Night After Party” (Dress Code Enforced)\r\n\r\nStarts at10 pm \r\nMusic By: JC finest Angelo and Brian \r\n');
INSERT INTO webcal_entry VALUES (42,NULL,NULL,'jordan6',20080125,-1,20071224,145806,0,2,'M','P','Cypher Movement Poetry Slam','The Cypher Movement \r\n\r\nDoor open 6 pm\r\n\r\nShow time at 7 pm\r\n\r\nAdmission $7.00\r\n\r\n\r\nCypher Movement\r\nwww.cyphermovement.com\r\n\r\nSound Lounge\r\nwww.myspace.com/cypherstudio\r\n\r\nDujuana\r\n\r\n\r\n\r\n\r\n\r\n\r\n');
INSERT INTO webcal_entry VALUES (43,NULL,NULL,'jordan6',20080111,-1,20071224,150944,0,2,'M','P','The Cypher Movement and Sound Lounge','The Sound Lounge\r\n\r\nDoor open 6 pm\r\n\r\nShow time at 7 pm\r\n\r\nAdmission $7.00\r\n\r\n\r\nCypher Movement\r\nwww.cyphermovement.com\r\n\r\nSound Lounge\r\nwww.myspace.com/cypherstudio\r\n\r\nDujuana\r\n\r\n\r\n\r\n\r\n\r\n\r\n');
--
-- Table structure for table `webcal_entry_ext_user`
--
CREATE TABLE webcal_entry_ext_user (
cal_id int(11) NOT NULL default '0',
cal_fullname varchar(50) NOT NULL default '',
cal_email varchar(75) default NULL,
PRIMARY KEY (cal_id,cal_fullname)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry_ext_user`
--
--
-- Table structure for table `webcal_entry_log`
--
CREATE TABLE webcal_entry_log (
cal_log_id int(11) NOT NULL default '0',
cal_entry_id int(11) NOT NULL default '0',
cal_login varchar(25) NOT NULL default '',
cal_user_cal varchar(25) default NULL,
cal_type char(1) NOT NULL default '',
cal_date int(11) NOT NULL default '0',
cal_time int(11) default NULL,
cal_text text,
PRIMARY KEY (cal_log_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry_log`
--
INSERT INTO webcal_entry_log VALUES (1,1,'jordan6','jordan6','C',20061204,163128,NULL);
INSERT INTO webcal_entry_log VALUES (2,1,'jordan6','jordan6','U',20061204,165258,NULL);
INSERT INTO webcal_entry_log VALUES (3,1,'jordan6','__public__','A',20061204,165428,NULL);
INSERT INTO webcal_entry_log VALUES (4,2,'jordan6','jordan6','C',20061204,165626,NULL);
INSERT INTO webcal_entry_log VALUES (5,2,'jordan6','jordan6','U',20061204,165711,NULL);
INSERT INTO webcal_entry_log VALUES (6,2,'jordan6','__public__','A',20061204,165750,NULL);
INSERT INTO webcal_entry_log VALUES (7,1,'jordan6','jordan6','U',20061204,165834,NULL);
INSERT INTO webcal_entry_log VALUES (8,3,'jordan6','jordan6','C',20061204,170111,NULL);
INSERT INTO webcal_entry_log VALUES (9,3,'jordan6','jordan6','U',20061204,170143,NULL);
INSERT INTO webcal_entry_log VALUES (10,3,'jordan6','__public__','D',20061204,170157,NULL);
INSERT INTO webcal_entry_log VALUES (11,4,'jordan6','jordan6','C',20061204,170223,NULL);
INSERT INTO webcal_entry_log VALUES (12,5,'jordan6','jordan6','C',20061204,170231,NULL);
INSERT INTO webcal_entry_log VALUES (13,5,'jordan6','__public__','D',20061204,170240,NULL);
INSERT INTO webcal_entry_log VALUES (14,6,'jordan6','jordan6','C',20061204,170306,NULL);
INSERT INTO webcal_entry_log VALUES (15,7,'jordan6','jordan6','C',20061204,170358,NULL);
INSERT INTO webcal_entry_log VALUES (16,8,'jordan6','jordan6','C',20061204,173452,NULL);
INSERT INTO webcal_entry_log VALUES (17,1,'jordan6','jordan6','U',20061204,185029,NULL);
INSERT INTO webcal_entry_log VALUES (18,1,'jordan6','jordan6','U',20061204,185139,NULL);
INSERT INTO webcal_entry_log VALUES (19,9,'jordan6','jordan6','C',20061204,185810,NULL);
INSERT INTO webcal_entry_log VALUES (20,10,'jordan6','jordan6','C',20061204,213115,NULL);
INSERT INTO webcal_entry_log VALUES (21,11,'jordan6','jordan6','C',20061204,213423,NULL);
INSERT INTO webcal_entry_log VALUES (22,12,'jordan6','jordan6','C',20061204,213815,NULL);
INSERT INTO webcal_entry_log VALUES (23,10,'jordan6','__public__','D',20061204,213949,NULL);
INSERT INTO webcal_entry_log VALUES (24,9,'jordan6','__public__','D',20061204,214011,NULL);
INSERT INTO webcal_entry_log VALUES (25,2,'jordan6','__public__','D',20061204,214027,NULL);
INSERT INTO webcal_entry_log VALUES (26,7,'jordan6','__public__','D',20061204,214039,NULL);
INSERT INTO webcal_entry_log VALUES (27,8,'jordan6','__public__','D',20061204,214105,NULL);
INSERT INTO webcal_entry_log VALUES (28,6,'jordan6','__public__','D',20061204,214122,NULL);
INSERT INTO webcal_entry_log VALUES (29,1,'jordan6','__public__','D',20061204,214139,NULL);
INSERT INTO webcal_entry_log VALUES (30,13,'jordan6','jordan6','C',20061204,225902,NULL);
INSERT INTO webcal_entry_log VALUES (31,14,'jordan6','jordan6','C',20061204,230123,NULL);
INSERT INTO webcal_entry_log VALUES (32,11,'jordan6','jordan6','U',20061204,230152,NULL);
INSERT INTO webcal_entry_log VALUES (33,15,'jordan6','jordan6','C',20061204,230352,NULL);
INSERT INTO webcal_entry_log VALUES (34,16,'jordan6','jordan6','C',20061204,230631,NULL);
INSERT INTO webcal_entry_log VALUES (35,17,'jordan6','jordan6','C',20061204,230805,NULL);
INSERT INTO webcal_entry_log VALUES (36,17,'jordan6','jordan6','U',20061204,230926,NULL);
INSERT INTO webcal_entry_log VALUES (37,12,'jordan6','__public__','D',20061204,231000,NULL);
INSERT INTO webcal_entry_log VALUES (38,18,'jordan6','jordan6','C',20061204,232131,NULL);
INSERT INTO webcal_entry_log VALUES (39,19,'jordan6','jordan6','C',20061204,233225,NULL);
INSERT INTO webcal_entry_log VALUES (40,13,'jordan6','jordan6','U',20061204,233814,NULL);
INSERT INTO webcal_entry_log VALUES (41,13,'jordan6','jordan6','U',20061204,233919,NULL);
INSERT INTO webcal_entry_log VALUES (42,13,'jordan6','__public__','D',20061204,234102,NULL);
INSERT INTO webcal_entry_log VALUES (43,19,'jordan6','__public__','D',20061204,234102,NULL);
INSERT INTO webcal_entry_log VALUES (44,20,'jordan6','jordan6','C',20061204,234233,NULL);
INSERT INTO webcal_entry_log VALUES (45,21,'jordan6','jordan6','C',20061204,234952,NULL);
INSERT INTO webcal_entry_log VALUES (46,14,'jordan6','__public__','D',20070108,164532,NULL);
INSERT INTO webcal_entry_log VALUES (47,22,'jordan6','jordan6','C',20070108,164820,NULL);
INSERT INTO webcal_entry_log VALUES (48,23,'jordan6','jordan6','C',20070108,170539,NULL);
INSERT INTO webcal_entry_log VALUES (49,11,'jordan6','jordan6','U',20070108,170955,NULL);
INSERT INTO webcal_entry_log VALUES (50,23,'jordan6','jordan6','U',20070108,171701,NULL);
INSERT INTO webcal_entry_log VALUES (51,22,'jordan6','jordan6','U',20070108,171745,NULL);
INSERT INTO webcal_entry_log VALUES (52,24,'jordan6','jordan6','C',20070108,171913,NULL);
INSERT INTO webcal_entry_log VALUES (53,22,'jordan6','jordan6','U',20070108,172244,NULL);
INSERT INTO webcal_entry_log VALUES (54,23,'jordan6','jordan6','U',20070108,172604,NULL);
INSERT INTO webcal_entry_log VALUES (55,23,'jordan6','jordan6','U',20070108,172744,NULL);
INSERT INTO webcal_entry_log VALUES (56,22,'jordan6','__public__','A',20070108,172925,NULL);
INSERT INTO webcal_entry_log VALUES (57,23,'jordan6','__public__','A',20070108,172931,NULL);
INSERT INTO webcal_entry_log VALUES (58,23,'jordan6','__public__','D',20070124,181036,NULL);
INSERT INTO webcal_entry_log VALUES (59,25,'jordan6','jordan6','C',20070131,161159,NULL);
INSERT INTO webcal_entry_log VALUES (60,26,'jordan6','jordan6','C',20070131,161435,NULL);
INSERT INTO webcal_entry_log VALUES (61,27,'jordan6','jordan6','C',20070131,161538,NULL);
INSERT INTO webcal_entry_log VALUES (62,25,'jordan6','__public__','D',20070131,161653,NULL);
INSERT INTO webcal_entry_log VALUES (63,20,'jordan6','__public__','D',20070131,161723,NULL);
INSERT INTO webcal_entry_log VALUES (64,27,'jordan6','__public__','D',20070131,161734,NULL);
INSERT INTO webcal_entry_log VALUES (65,28,'jordan6','jordan6','C',20070221,210547,NULL);
INSERT INTO webcal_entry_log VALUES (66,29,'jordan6','jordan6','C',20070221,210824,NULL);
INSERT INTO webcal_entry_log VALUES (67,29,'jordan6','jordan6','U',20070221,211042,NULL);
INSERT INTO webcal_entry_log VALUES (68,27,'jordan6','__public__','D',20070221,211143,NULL);
INSERT INTO webcal_entry_log VALUES (69,28,'jordan6','__public__','D',20070225,221133,NULL);
INSERT INTO webcal_entry_log VALUES (70,29,'jordan6','jordan6','U',20070425,142243,NULL);
INSERT INTO webcal_entry_log VALUES (71,29,'jordan6','jordan6','U',20070425,142415,NULL);
INSERT INTO webcal_entry_log VALUES (72,30,'jordan6','jordan6','C',20070425,144151,NULL);
INSERT INTO webcal_entry_log VALUES (73,31,'jordan6','jordan6','C',20070628,135302,NULL);
INSERT INTO webcal_entry_log VALUES (74,32,'jordan6','jordan6','C',20070628,135427,NULL);
INSERT INTO webcal_entry_log VALUES (75,33,'jordan6','jordan6','C',20070628,140914,NULL);
INSERT INTO webcal_entry_log VALUES (76,16,'jordan6','__public__','D',20070628,141106,NULL);
INSERT INTO webcal_entry_log VALUES (77,16,'jordan6','__public__','D',20070628,141151,NULL);
INSERT INTO webcal_entry_log VALUES (78,33,'jordan6','__public__','D',20070628,141151,NULL);
INSERT INTO webcal_entry_log VALUES (79,34,'jordan6','jordan6','C',20070628,141734,NULL);
INSERT INTO webcal_entry_log VALUES (80,35,'jordan6','jordan6','C',20070628,142707,NULL);
INSERT INTO webcal_entry_log VALUES (81,36,'jordan6','jordan6','C',20070628,143346,NULL);
INSERT INTO webcal_entry_log VALUES (82,37,'jordan6','jordan6','C',20070628,145316,NULL);
INSERT INTO webcal_entry_log VALUES (83,37,'jordan6','__public__','D',20070628,150432,NULL);
INSERT INTO webcal_entry_log VALUES (84,38,'jordan6','jordan6','C',20070628,150953,NULL);
INSERT INTO webcal_entry_log VALUES (85,39,'jordan6','jordan6','C',20070628,151314,NULL);
INSERT INTO webcal_entry_log VALUES (86,39,'jordan6','jordan6','U',20070628,151403,NULL);
INSERT INTO webcal_entry_log VALUES (87,39,'jordan6','jordan6','U',20070628,151459,NULL);
INSERT INTO webcal_entry_log VALUES (88,32,'jordan6','__public__','D',20071204,132634,NULL);
INSERT INTO webcal_entry_log VALUES (89,15,'jordan6','jordan6','U',20071204,132959,NULL);
INSERT INTO webcal_entry_log VALUES (90,40,'jordan6','jordan6','C',20071204,134957,NULL);
INSERT INTO webcal_entry_log VALUES (91,32,'jordan6','__public__','D',20071204,135110,NULL);
INSERT INTO webcal_entry_log VALUES (92,15,'jordan6','__public__','D',20071204,135239,NULL);
INSERT INTO webcal_entry_log VALUES (93,15,'jordan6','__public__','D',20071204,135303,NULL);
INSERT INTO webcal_entry_log VALUES (94,15,'jordan6','__public__','D',20071204,135320,NULL);
INSERT INTO webcal_entry_log VALUES (95,32,'jordan6','__public__','D',20071204,135334,NULL);
INSERT INTO webcal_entry_log VALUES (96,32,'jordan6','__public__','D',20071204,135357,NULL);
INSERT INTO webcal_entry_log VALUES (97,15,'jordan6','__public__','D',20071204,135410,NULL);
INSERT INTO webcal_entry_log VALUES (98,32,'jordan6','__public__','D',20071204,135431,NULL);
INSERT INTO webcal_entry_log VALUES (99,15,'jordan6','__public__','D',20071204,135443,NULL);
INSERT INTO webcal_entry_log VALUES (100,32,'jordan6','__public__','D',20071204,135509,NULL);
INSERT INTO webcal_entry_log VALUES (101,15,'jordan6','__public__','D',20071204,135521,NULL);
INSERT INTO webcal_entry_log VALUES (102,32,'jordan6','__public__','D',20071204,135555,NULL);
INSERT INTO webcal_entry_log VALUES (103,15,'jordan6','__public__','D',20071204,135617,NULL);
INSERT INTO webcal_entry_log VALUES (104,32,'jordan6','__public__','D',20071204,135635,NULL);
INSERT INTO webcal_entry_log VALUES (105,15,'jordan6','__public__','D',20071204,135647,NULL);
INSERT INTO webcal_entry_log VALUES (106,32,'jordan6','__public__','D',20071204,135711,NULL);
INSERT INTO webcal_entry_log VALUES (107,15,'jordan6','__public__','D',20071204,135721,NULL);
INSERT INTO webcal_entry_log VALUES (108,32,'jordan6','__public__','D',20071204,135826,NULL);
INSERT INTO webcal_entry_log VALUES (109,15,'jordan6','__public__','D',20071204,135843,NULL);
INSERT INTO webcal_entry_log VALUES (110,32,'jordan6','__public__','D',20071204,135944,NULL);
INSERT INTO webcal_entry_log VALUES (111,15,'jordan6','__public__','D',20071204,135958,NULL);
INSERT INTO webcal_entry_log VALUES (112,32,'jordan6','__public__','D',20071204,140038,NULL);
INSERT INTO webcal_entry_log VALUES (113,15,'jordan6','__public__','D',20071204,140134,NULL);
INSERT INTO webcal_entry_log VALUES (114,37,'jordan6','__public__','D',20071204,140134,NULL);
INSERT INTO webcal_entry_log VALUES (115,38,'jordan6','__public__','D',20071204,140134,NULL);
INSERT INTO webcal_entry_log VALUES (116,41,'jordan6','jordan6','C',20071204,140945,NULL);
INSERT INTO webcal_entry_log VALUES (117,40,'jordan6','jordan6','U',20071214,151335,NULL);
INSERT INTO webcal_entry_log VALUES (118,42,'jordan6','jordan6','C',20071224,145806,NULL);
INSERT INTO webcal_entry_log VALUES (119,43,'jordan6','jordan6','C',20071224,150747,NULL);
INSERT INTO webcal_entry_log VALUES (120,43,'jordan6','jordan6','U',20071224,150944,NULL);
--
-- Table structure for table `webcal_entry_repeats`
--
CREATE TABLE webcal_entry_repeats (
cal_id int(11) NOT NULL default '0',
cal_type varchar(20) default NULL,
cal_end int(11) default NULL,
cal_frequency int(11) default '1',
cal_days varchar(7) default NULL,
PRIMARY KEY (cal_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry_repeats`
--
INSERT INTO webcal_entry_repeats VALUES (11,'weekly',NULL,1,'nynnnnn');
INSERT INTO webcal_entry_repeats VALUES (13,'weekly',NULL,1,'ynnnnnn');
INSERT INTO webcal_entry_repeats VALUES (14,'weekly',NULL,1,'nnnynnn');
INSERT INTO webcal_entry_repeats VALUES (15,'weekly',NULL,1,'nnnnynn');
INSERT INTO webcal_entry_repeats VALUES (16,'weekly',NULL,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (17,'weekly',NULL,1,'nnnnnny');
INSERT INTO webcal_entry_repeats VALUES (18,'monthlyByDay',NULL,1,'nnnnnnn');
INSERT INTO webcal_entry_repeats VALUES (20,'weekly',NULL,1,'ynnnnnn');
INSERT INTO webcal_entry_repeats VALUES (23,'weekly',20070627,1,'nnnynnn');
INSERT INTO webcal_entry_repeats VALUES (27,'weekly',NULL,1,'ynnnnnn');
INSERT INTO webcal_entry_repeats VALUES (29,'weekly',20070627,1,'nnnynnn');
INSERT INTO webcal_entry_repeats VALUES (30,'weekly',20070626,1,'nnynnnn');
INSERT INTO webcal_entry_repeats VALUES (31,'weekly',NULL,1,'nnynnnn');
INSERT INTO webcal_entry_repeats VALUES (32,'weekly',NULL,1,'nnnynnn');
INSERT INTO webcal_entry_repeats VALUES (33,'weekly',NULL,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (34,'weekly',20070622,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (35,'weekly',20071228,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (36,'weekly',20091225,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (37,'weekly',20091224,1,'nnnnnyn');
INSERT INTO webcal_entry_repeats VALUES (38,'weekly',NULL,1,'nnnnynn');
INSERT INTO webcal_entry_repeats VALUES (41,'weekly',20081225,1,'nnnnynn');
INSERT INTO webcal_entry_repeats VALUES (42,'monthlyByDay',20081226,1,'nnnnnnn');
INSERT INTO webcal_entry_repeats VALUES (43,'monthlyByDay',20081212,1,'nnnnnnn');
--
-- Table structure for table `webcal_entry_repeats_not`
--
CREATE TABLE webcal_entry_repeats_not (
cal_id int(11) NOT NULL default '0',
cal_date int(11) NOT NULL default '0',
PRIMARY KEY (cal_id,cal_date)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry_repeats_not`
--
INSERT INTO webcal_entry_repeats_not VALUES (11,20071231);
INSERT INTO webcal_entry_repeats_not VALUES (13,20061231);
INSERT INTO webcal_entry_repeats_not VALUES (15,20070628);
INSERT INTO webcal_entry_repeats_not VALUES (15,20070705);
INSERT INTO webcal_entry_repeats_not VALUES (15,20071206);
INSERT INTO webcal_entry_repeats_not VALUES (15,20071213);
INSERT INTO webcal_entry_repeats_not VALUES (15,20071220);
INSERT INTO webcal_entry_repeats_not VALUES (15,20071227);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080103);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080110);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080117);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080124);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080131);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080207);
INSERT INTO webcal_entry_repeats_not VALUES (15,20080214);
INSERT INTO webcal_entry_repeats_not VALUES (16,20070629);
INSERT INTO webcal_entry_repeats_not VALUES (16,20070706);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080125);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080222);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080328);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080425);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080523);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080627);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080725);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080822);
INSERT INTO webcal_entry_repeats_not VALUES (18,20080926);
INSERT INTO webcal_entry_repeats_not VALUES (18,20081024);
INSERT INTO webcal_entry_repeats_not VALUES (18,20081128);
INSERT INTO webcal_entry_repeats_not VALUES (18,20081226);
INSERT INTO webcal_entry_repeats_not VALUES (20,20061231);
INSERT INTO webcal_entry_repeats_not VALUES (20,20070128);
INSERT INTO webcal_entry_repeats_not VALUES (20,20070204);
INSERT INTO webcal_entry_repeats_not VALUES (27,20070204);
INSERT INTO webcal_entry_repeats_not VALUES (29,20070627);
INSERT INTO webcal_entry_repeats_not VALUES (30,20070626);
INSERT INTO webcal_entry_repeats_not VALUES (32,20071205);
INSERT INTO webcal_entry_repeats_not VALUES (32,20071212);
INSERT INTO webcal_entry_repeats_not VALUES (32,20071219);
INSERT INTO webcal_entry_repeats_not VALUES (32,20071226);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080102);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080109);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080116);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080123);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080130);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080206);
INSERT INTO webcal_entry_repeats_not VALUES (32,20080213);
INSERT INTO webcal_entry_repeats_not VALUES (35,20071228);
--
-- Table structure for table `webcal_entry_user`
--
CREATE TABLE webcal_entry_user (
cal_id int(11) NOT NULL default '0',
cal_login varchar(25) NOT NULL default '',
cal_status char(1) default 'A',
cal_category int(11) default NULL,
PRIMARY KEY (cal_id,cal_login)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_entry_user`
--
INSERT INTO webcal_entry_user VALUES (1,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (2,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (3,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (4,'jordan6','D',NULL);
INSERT INTO webcal_entry_user VALUES (5,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (6,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (7,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (8,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (9,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (10,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (11,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (12,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (14,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (15,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (16,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (17,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (18,'jordan6','A',NULL);
INSERT INTO webcal_entry_user VALUES (19,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (13,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (20,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (21,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (23,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (22,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (24,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (25,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (26,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (27,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (28,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (29,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (30,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (31,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (32,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (33,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (34,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (35,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (36,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (37,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (38,'__public__','D',NULL);
INSERT INTO webcal_entry_user VALUES (39,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (40,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (41,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (42,'__public__','A',NULL);
INSERT INTO webcal_entry_user VALUES (43,'__public__','A',NULL);
--
-- Table structure for table `webcal_group`
--
CREATE TABLE webcal_group (
cal_group_id int(11) NOT NULL default '0',
cal_owner varchar(25) default NULL,
cal_name varchar(50) NOT NULL default '',
cal_last_update int(11) NOT NULL default '0',
PRIMARY KEY (cal_group_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_group`
--
--
-- Table structure for table `webcal_group_user`
--
CREATE TABLE webcal_group_user (
cal_group_id int(11) NOT NULL default '0',
cal_login varchar(25) NOT NULL default '',
PRIMARY KEY (cal_group_id,cal_login)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_group_user`
--
--
-- Table structure for table `webcal_import`
--
CREATE TABLE webcal_import (
cal_import_id int(11) NOT NULL default '0',
cal_name varchar(50) default NULL,
cal_date int(11) NOT NULL default '0',
cal_type varchar(10) NOT NULL default '',
cal_login varchar(25) default NULL,
PRIMARY KEY (cal_import_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_import`
--
--
-- Table structure for table `webcal_import_data`
--
CREATE TABLE webcal_import_data (
cal_import_id int(11) NOT NULL default '0',
cal_id int(11) NOT NULL default '0',
cal_login varchar(25) NOT NULL default '',
cal_import_type varchar(15) NOT NULL default '',
cal_external_id varchar(200) default NULL,
PRIMARY KEY (cal_id,cal_login)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_import_data`
--
--
-- Table structure for table `webcal_nonuser_cals`
--
CREATE TABLE webcal_nonuser_cals (
cal_login varchar(25) NOT NULL default '',
cal_lastname varchar(25) default NULL,
cal_firstname varchar(25) default NULL,
cal_admin varchar(25) NOT NULL default '',
PRIMARY KEY (cal_login)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_nonuser_cals`
--
--
-- Table structure for table `webcal_reminder_log`
--
CREATE TABLE webcal_reminder_log (
cal_id int(11) NOT NULL default '0',
cal_name varchar(25) NOT NULL default '',
cal_event_date int(11) NOT NULL default '0',
cal_last_sent int(11) NOT NULL default '0',
PRIMARY KEY (cal_id,cal_name,cal_event_date)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_reminder_log`
--
--
-- Table structure for table `webcal_report`
--
CREATE TABLE webcal_report (
cal_login varchar(25) NOT NULL default '',
cal_report_id int(11) NOT NULL default '0',
cal_is_global char(1) NOT NULL default 'N',
cal_report_type varchar(20) NOT NULL default '',
cal_include_header char(1) NOT NULL default 'Y',
cal_report_name varchar(50) NOT NULL default '',
cal_time_range int(11) NOT NULL default '0',
cal_user varchar(25) default NULL,
cal_allow_nav char(1) default 'Y',
cal_cat_id int(11) default NULL,
cal_include_empty char(1) default 'N',
cal_show_in_trailer char(1) default 'N',
cal_update_date int(11) NOT NULL default '0',
PRIMARY KEY (cal_report_id)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_report`
--
--
-- Table structure for table `webcal_report_template`
--
CREATE TABLE webcal_report_template (
cal_report_id int(11) NOT NULL default '0',
cal_template_type char(1) NOT NULL default '',
cal_template_text text,
PRIMARY KEY (cal_report_id,cal_template_type)
) TYPE=MyISAM;
--
-- Dumping data for table `webcal_report_template`
--
INSERT INTO webcal_report_template VALUES (0,'H','\r\n\r\n\r\n\r\nTop Frame\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
![](\"http://www.jordanslounge.com/menus/Banner1.jpg\")