-- MySQL dump 10.11
--
-- Host: localhost    Database: qmgonlin_jo154
-- ------------------------------------------------------
-- Server version	5.0.45-community-log

/*!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 `jos_avr_player`
--

DROP TABLE IF EXISTS `jos_avr_player`;
CREATE TABLE `jos_avr_player` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `minw` int(11) NOT NULL default '0',
  `minh` int(11) NOT NULL default '0',
  `isjw` int(1) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `code` mediumtext NOT NULL,
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avr_player`
--

LOCK TABLES `jos_avr_player` WRITE;
/*!40000 ALTER TABLE `jos_avr_player` DISABLE KEYS */;
INSERT INTO `jos_avr_player` VALUES (1,0,0,0,1,'flv','<script type=\"text/javascript\">\nswfobject.embedSWF(\'@RLOC@mediaplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'@FLASHVER@\',@XPINST@,\n{file:\'@MURL@\',width:\'@WIDTH@\',height:\'@HEIGHT@\',@IF(ENABLEJS)@javascriptid:\'p_@DIVID@\',\n@/IF@@IFS(PLTHUMBS)@thumbsinplaylist:\'@PLTHUMBS@\',\n@/IFS@@IF(AUTOSCROLL)@autoscroll:\'@AUTOSCROLL@\',\n@/IF@@IFS(TYPE)@type:\'@TYPE@\',\n@/IFS@@IFS(VOLUME)@volume:\'@VOLUME@\',\n@/IFS@@IFS(CFG)@config:\'@CFG@\',\n@/IFS@@IFS(LINK)@link:\'@LINK@\',\n@/IFS@@IFS(IMG)@image:\'@IMG@\',\n@/IFS@@IFS(LINK)@linkfromdisplay:\'@LINKFROMDISPLAY@\',\n@/IFS@@IFS(LINK)@linktarget:\'@LINKTARGET@\',\n@/IFS@@IFS(REPEAT)@repeat:\'@REPEAT@\',\n@/IFS@@IFS(SHUFFLE)@shuffle:\'@SHUFFLE@\',\n@/IFS@@IFS(RECURL)@recommendations:\'@RECURL@\',\n@/IFS@@IFS(DISPLAYWIDTH)@displaywidth:\'@DISPLAYWIDTH@\',\n@/IFS@@IFS(DISPLAYHEIGHT)@displayheight:\'@DISPLAYHEIGHT@\',\n@/IFS@@IFS(LOGO)@logo:\'@LOGO@\',\n@/IFS@@IFS(CAPTIONS)@captions:\'@CAPTIONS@\',\n@/IFS@@IFS(USECAPTIONS)@usecaptions:\'@USECAPTIONS@\',\n@/IFS@@IFS(SEARCHLINK)@searchlink:\'@SEARCHLINK@\',\n@/IFS@showeq:\'@SHOWEQ@\',searchbar:\'@SEARCHBAR@\',enablejs:\'@ENABLEJS@\',autostart:\'@AUTOSTART@\',showicons:\'@SHOWICONS@\',@IF(!SHOWNAV)@shownavigation:\'@SHOWNAV@\',@/IF@@IF(SHOWNAV)@showstop:\'@SHOWSTOP@\',showdigits:\'@SHOWDIGITS@\',\nshowdownload:\'@SHOWDOWNLOAD@\',@/IF@usefullscreen:\'@USEFULLSCREEN@\',backcolor:\'@PBGCOLOR@\',frontcolor:\'@PFGCOLOR@\',\nlightcolor:\'@PHICOLOR@\',screencolor:\'@PSCCOLOR@\',overstretch:\'@STRETCH@\'}\n,{allowscriptaccess:\'always\',seamlesstabbing:\'true\',allowfullscreen:\'true\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},\n{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','JW Media Player'),(2,0,0,0,0,'wmv','<object classid=\"CLSID:6BF52A52-394A-11d3-B153-00C04F79FAA6\"\n type=\"application/x-oleobject\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\">\n<param name=\"URL\" value=\"@MURL@\" />\n<param name=\"stretchToFit\" value=\"1\" />\n<param name=\"showControls\" value=\"1\" />\n<param name=\"showStatusBar\" value=\"0\" />\n<param name=\"animationAtStart\" value=\"1\" />\n<param name=\"autoStart\" value=\"@AUTOSTART!d@\" />\n<param name=\"enableFullScreenControls\" value=\"@USEFULLSCREEN!d@\" \n/><embed src=\"@MURL@\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\" autoStart=\"@AUTOSTART!d@\" animationAtStart=\"1\" enableFullScreenControls=\"@USEFULLSCREEN!d@\" type=\"application/x-mplayer2\"/></embed></object>','Windows Media Player'),(3,0,0,0,0,'mov','<object codebase=\"http://www.apple.com/qtactivex/qtplugin.cab\" classid=\"clsid:02BF25D5-8C17-4B23-BC80-D3488ABDDC6B\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\"><param name=\"src\" value=\"@MURL@\" /><param name=\"controller\" value=\"True\" /><param name=\"cache\" value=\"False\" /><param name=\"autoplay\" value=\"@AUTOSTART@\" /><param name=\"kioskmode\" value=\"False\" /><param name=\"scale\" value=\"tofit\" /><embed src=\"@MURL@\" pluginspage=\"http://www.apple.com/quicktime/download/\" scale=\"tofit\" kioskmode=\"False\" qtsrc=\"@MURL@\" cache=\"False\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\" controller=\"True\" type=\"video/quicktime\" autoplay=\"@AUTOSTART@\" /></object>','QuickTime Player'),(4,0,0,0,0,'rm','<object classid=\"clsid:CFCDAA03-8BE4-11cf-B84B-0020AFBBCCFA\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\"><param name=\"controls\" value=\"ControlPanel\" /><param name=\"autostart\" value=\"@AUTOSTART!d@\" /><param name=\"src\" value=\"@MURL@\" /><embed src=\"@MURL@\" type=\"audio/x-pn-realaudio-plugin\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\" controls=\"ControlPanel\" autostart=\"@AUTOSTART!d@\" /></object>','Real Media Player'),(5,0,0,0,0,'divx','<object classid=\"CLSID:67DABFBF-D0AB-41fa-9C46-CC0F21721616\"\ncodebase=\"http://download.divx.com/webplayer/stage6/windows/AutoDLDivXWebPlayerInstaller.cab\" \n type=\"application/x-oleobject\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\">\n<param name=\"src\" value=\"@MURL@\" />\n<param name=\"custommode\" value=\"Stage6\" />\n<param name=\"showControls\" value=\"1\" />\n<param name=\"showpostplaybackad\" value=\"false\" />\n<param name=\"allowContextMenu\" value=\"@MENU@\" />\n@IFS(IMG)@<param name=\"previewImage\" value=\"@IMG@\" />\n@/IFS@<param name=\"autoplay\" value=\"@AUTOSTART@\" \n/><embed type=\"video/divx\" src=\"@MURL@\" style=\"width: @WIDTH@px; height: @HEIGHT@px;\" pluginspage=\"http://go.divx.com/plugin/download/\" showpostplaybackad=\"false\" custommode=\"Stage6\" autoplay=\"@AUTOSTART@\" allowContextMenu=\"@MENU@\"@@IFS(IMG)@ previewImage=\"@IMG@\"@/IFS@/></object>','DivX Webplayer'),(6,0,0,0,0,'6cn','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://6.cn/player.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{vid:\'@CODE@\',flag:\'1\'},{allowfullscreen:\'true\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','6Cn.com original player'),(7,0,0,0,0,'biku','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.biku.com/opus/player.swf?VideoID=@CODE@&embed=true&autoStart=@AUTOSTART@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',menu:\'@MENU@\',bgcolor:\'@BGCOLOR@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Biku.com original player'),(8,0,0,0,0,'bofunk','<script type=\"text/javascript\">\nswfobject.embedSWF(\'@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{allowfullscreen:\'true\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Bofunk.com original player'),(9,0,0,0,0,'break','<script type=\"text/javascript\">\nswfobject.embedSWF(\'@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Break.com original player'),(10,0,0,0,0,'clipfish','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.clipfish.de/videoplayer.swf?videoid=@CODE@&r=1\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','ClipFish.de original player'),(11,0,0,0,0,'collegehumor','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.collegehumor.com/moogaloop/moogaloop.swf?clip_id=@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','CollegeHumor original player'),(12,0,420,340,0,'currenttv','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://current.com/e/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','CurrentTV original player'),(13,0,0,0,0,'dmotion','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.dailymotion.com/swf/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'8.0.0\',@XPINST@,\n{v3:\'1\',related:\'0\',autoPlay:\'@AUTOSTART!d@\',colors:\'background:DDDDDD;glow:FFFFFF;foreground:333333;special:FFC300;\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',quality:\'high\',allowScriptAccess:\'allways\',allowfullscreen:\'true\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','DailyMotion.com original player'),(14,0,0,0,0,'vidiac','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.vidiac.com/vidiac.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{name:\'ePlayer\',video:\'@CODE@\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Vidiac.com original player'),(15,0,0,0,0,'gametrailers','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.gametrailers.com/remote_wrap.php?mid=@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','GameTrailers.com original player'),(16,0,0,0,0,'google','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://video.google.com/googleplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{@IF(AUTOSTART)@autoPlay:\'true\',@/IF@docId:\'@CODE@\',hl:\'@LANG@\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Google Video original player'),(17,0,0,0,0,'spike','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.spike.com/efp\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{flvBaseClip:\'@CODE@\'},{name:\'efp\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Spike.com original player (previously iFilm.com)'),(18,0,0,0,0,'jumpcut','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.jumpcut.com/media/flash/jump.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{asset_type:\'movie\',asset_id:\'@CODE@\',eb:\'1\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','JumpCut.com original player'),(19,0,0,0,0,'mega','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://wwwstatic.megavideo.com/tmp_mvplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'8.0.0\',@XPINST@,\n{waitingtime:\'0\',flv:\'@CODE@\',k:\'@RRESA@\',poker:\'0\',v:\'@OCODE@\',rel_again:\'Play again\',rel_other:\'Related videos\',u:\'\',user:\'\',from:\'from:\',views:\'views\',vid_time:\'@RRESB@\',vid_name:\'\',videoname:\'\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',quality:\'high\',allowScriptAccess:\'sameDomain\',allowFullScreen:\'@USEFULLSCREEN@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','MegaVideo.com original player'),(20,0,0,0,0,'metacafe','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.metacafe.com/fplayer/@CODE@.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{altServerURL:\'http://www.metacafe.com\',playerVars:\'showStats=no|autoPlay=no|videoTitle=\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','MetaCafe.com original player'),(21,0,0,0,0,'mofile','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://tv.mofile.com/cn/xplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{v:\'@CODE@\',autoplay:\'0\'},{wmode:\'@WMODE@\',allowScriptAccess:\'always\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Mofile.com original player'),(22,0,0,0,0,'myvideo','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.myvideo.de/movie/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','MyVideo.com original player'),(23,0,0,0,0,'quxiu','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.quxiu.com/photo/swf/swfobj.swf?id=@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Quixu.com original player'),(24,0,0,0,0,'revver','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://flash.revver.com/player/1.0/player.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{mediaId:\'@CODE@\',javascriptContext:\'true\',skinURL:\'http://flash.revver.com/player/1.0/skins/Default_Raster.swf\',skinImgURL:\'http://flash.revver.com/player/1.0/skins/night_skin.png\',actionBarSkinURL:\'http://flash.revver.com/player/1.0/skins/DefaultNavBarSkin.swf\',resizeVideo:\'true\'},\n{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Revver.com original player'),(25,0,0,0,0,'seehaha','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.seehaha.com/flash/playvid2.swf?vidID=@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','SeeHaha.com original player'),(26,0,0,0,0,'sevenload','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://de.sevenload.com/pl/@CODE@/503x403/swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',allowscriptaccess:\'always\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'\n},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','SevenLoad.com original player'),(27,0,0,0,0,'stickam','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.stickam.com/flashVarMediaPlayer/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',scale:\'noscale\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','StickAm.com original player'),(28,0,0,0,0,'streetfire','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://videos.streetfire.net/vidiac.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{name:\'ePlayer\',video:\'@CODE@\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','StreetFire original player'),(29,0,432,285,0,'ted','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.ted.com/swf/videoplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'8.0.0\',@XPINST@,\n{jsonStr:\'@CODE@\',flashID:\'swfVideoPlayer\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',quality:\'high\',allowScriptAccess:\'always\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','TED.com original player'),(30,0,0,0,0,'ted2','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://static.videoegg.com/ted/flash/loader.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'8.0.0\',@XPINST@,\n{file:\'@CODE@\',autoPlay:\'@AUTOSTART@\',allowFullscreen:\'@USEFULLSCREEN@\',forcePlay:\'false\',logo:\'\',fullscreenURL:\'http://static.videoegg.com/ted/flash/fullscreen.html\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',quality:\'high\',allowScriptAccess:\'always\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','TED.com alternative player'),(31,0,0,0,0,'tudou','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.tudou.com/v/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Tudou.com original player'),(32,0,0,0,0,'uume','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.uume.com/v/@CODE@_UUME\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Uume.com original player'),(33,0,0,0,0,'vimeo','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.vimeo.com/moogaloop.swf?clip_id=@CODE@&server=www.vimeo.com&show_title=1&show_byline=1&show_portrait=0&autoplay=@AUTOSTART!d@&fullscreen=@USEFULLSCREEN!d@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',allowfullscreen:\'true\',scale:\'showall\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Vimeo.com original player'),(34,0,0,0,0,'virb','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.virb.com/external/video/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',salign:\'tl\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Virb.com original player'),(35,0,0,0,0,'wangyou','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://v.wangyou.com/images/x_player.swf?id=@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\nfalse,{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','WangYou.com original player'),(36,0,0,0,0,'yahoo','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://d.yimg.com/static.video.yahoo.com/yep/YV_YEP.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{onsite:\'0\',embed:\'1\',id:\'@CODE@\'},{allowfullscreen:\'@USEFULLSCREEN@\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Yahoo video original player'),(37,0,0,0,0,'youtube','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.youtube.com/v/@CODE@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{autoplay:\'@AUTOSTART!d@\',color1:\'@PBGCOLOR@\',color2:\'@PHICOLOR@\',rel:\'@YTREL!d@\',egm:\'@YTEGM!d@\',border:\'@YTBORDER!d@\',loop:\'@YTLOOP!d@\'},{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','YouTube original player'),(38,0,0,0,0,'jwwmv','<script type=\"text/javascript\">\nnew jeroenwijering.Player($(\'@DIVID@\'),\'@RLOC@wmvplayer.xaml\',\n{file:\'@MURL@\',width:\'@WIDTH@\',height:\'@HEIGHT@\',@IF(ENABLEJS)@javascriptid:\'p_@DIVID@\',\n@/IF@@IFS(PLTHUMBS)@thumbsinplaylist:\'@PLTHUMBS@\',\n@/IFS@@IF(AUTOSCROLL)@autoscroll:\'@AUTOSCROLL@\',\n@/IF@@IFS(TYPE)@type:\'@TYPE@\',\n@/IFS@@IFS(CFG)@config:\'@CFG@\',\n@/IFS@@IFS(LINK)@link:\'@LINK@\',\n@/IFS@@IFS(IMG)@image:\'@IMG@\',\n@/IFS@@IFS(LINK)@linkfromdisplay:\'@LINKFROMDISPLAY@\',\n@/IFS@@IFS(LINK)@linktarget:\'@LINKTARGET@\',\n@/IFS@@IFS(REPEAT)@repeat:\'@REPEAT@\',\n@/IFS@@IFS(SHUFFLE)@shuffle:\'@SHUFFLE@\',\n@/IFS@@IFS(RECURL)@recommendations:\'@RECURL@\',\n@/IFS@@IFS(DISPLAYWIDTH)@displaywidth:\'@DISPLAYWIDTH@\',\n@/IFS@@IFS(DISPLAYHEIGHT)@displayheight:\'@DISPLAYHEIGHT@\',\n@/IFS@@IFS(LOGO)@logo:\'@LOGO@\',\n@/IFS@@IFS(SEARCHLINK)@searchlink:\'@SEARCHLINK@\',\n@/IFS@showeq:\'@SHOWEQ@\',searchbar:\'@SEARCHBAR@\',enablejs:\'@ENABLEJS@\',autostart:\'@AUTOSTART@\',showicons:\'@SHOWICONS@\',@IF(!SHOWNAV)@shownavigation:\'@SHOWNAV@\',@/IF@@IF(SHOWNAV)@showstop:\'@SHOWSTOP@\',showdigits:\'@SHOWDIGITS@\',\nshowdownload:\'@SHOWDOWNLOAD@\',@/IF@usefullscreen:\'@USEFULLSCREEN@\',backcolor:\'@PBGCOLOR@\',frontcolor:\'@PFGCOLOR@\',\nlightcolor:\'@PHICOLOR@\',screencolor:\'@PSCCOLOR@\',overstretch:\'@STRETCH@\'}\n);\n</script>','JW WMV Player (needs MS-SilverLight)'),(39,0,0,0,0,'swf','<script type=\"text/javascript\">\nswfobject.embedSWF(\'@MURL@\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'@FLASHVER@\',@XPINST@,\nfalse,{allowscriptaccess:\'always\',seamlesstabbing:\'true\',allowfullscreen:\'true\',wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',menu:\'@MENU@\'},\n{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Plain flash embedding (for flash animations)'),(40,0,0,0,0,'brightcove','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.brightcove.tv/playerswf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{initVideoId:\'@CODE@\',servicesURL:\'http://www.brightcove.tv\',\nviewerSecureGatewayURL:\'https://www.brightcove.tv\',\ncdnURL:\'http://admin.brightcove.com\',autoStart:\'@AUTOSTART@\'},\n{base:\'http://admin.brightcove.com\',\nwmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',allowFullScreen:\'true\',\nallowScriptAccess:\'always\',seamlesstabbing:\'false\',swLiveConnect:\'true\'\n,menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Brightcove.tv original player'),(41,0,0,0,0,'myshows','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://www.seehaha.com/flash/player.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'9.0.28\',@XPINST@,\n{vidFileName:\'@CODE@\'},\n{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',allowFullScreen:\'@USEFULLSCREEN@\',menu:\'@MENU@\'},{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Myshows.cn (previouslyly seehaha.com)'),(42,0,0,0,0,'blip','<script type=\"text/javascript\">\nswfobject.embedSWF(\'http://blip.tv/scripts/flash/showplayer.swf\',\'@DIVID@\',\'@WIDTH@\',\'@HEIGHT@\',\'@FLASHVER@\',@XPINST@,\n{file:\'http://blip.tv/rss/flash/@CODE@?referrer=blip.tv&source=1\',enablejs:\'true\',feedurl:\'http://WatchMojo.blip.tv/rss\',\nshowplayerpath:\'showplayerpath=http://blip.tv/scripts/flash/showplayer.swf\'},\n{wmode:\'@WMODE@\',bgcolor:\'@BGCOLOR@\',quality:\'high\',allowScriptAccess:\'sameDomain\',allowFullScreen:\'@USEFULLSCREEN@\',menu:\'@MENU@\'},\n{id:\'p_@DIVID@\',styleclass:\'@AVCSS@\'});\n</script>','Blip.tv original player');
/*!40000 ALTER TABLE `jos_avr_player` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avr_popup`
--

DROP TABLE IF EXISTS `jos_avr_popup`;
CREATE TABLE `jos_avr_popup` (
  `id` int(11) NOT NULL auto_increment,
  `divid` varchar(255) NOT NULL,
  `code` mediumtext NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `wtime` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`,`divid`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avr_popup`
--

LOCK TABLES `jos_avr_popup` WRITE;
/*!40000 ALTER TABLE `jos_avr_popup` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_avr_popup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avr_ripper`
--

DROP TABLE IF EXISTS `jos_avr_ripper`;
CREATE TABLE `jos_avr_ripper` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `flags` int(11) NOT NULL default '0',
  `cindex` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `url` varchar(255) NOT NULL,
  `regex` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avr_ripper`
--

LOCK TABLES `jos_avr_ripper` WRITE;
/*!40000 ALTER TABLE `jos_avr_ripper` DISABLE KEYS */;
INSERT INTO `jos_avr_ripper` VALUES (1,0,0,0,'6cn','http://6.cn/watch/@CODE@.html','pageMessage.evid\\s*=\\s*\'([^\']+)\'\\s*;','6CN.com'),(2,0,0,0,'bofunk','http://www.bofunk.com/video/@CODE@.html','<input\\stype=\'text\'\\svalue=\'<embed\\ssrc=\"([^\"]+)\"','Bofunk.com'),(3,0,0,0,'break','http://www.break.com/index/@CODE@.html','<param name=\"movie\" value=\"([^\"]+)\">','Break.com'),(4,0,0,0,'dropshots','http://www.dropshots.com/V1.0/Media.getList?appid=dropshots&username=@USER@&min_taken_date=@CODE@&passwordprotection=false&output=xml','<video>(.+)</video>','Dropshots.com'),(5,0,0,0,'mega','http://www.megavideo.com/?v=@CODE@','addVariable\\s*\\(\\s*\"flv\"\\s*,\\s*\"([^\"]+)\"[\\s\\S]*?addVariable\\s*\\(\\s*\"k\"\\s*,\\s*\"([^\"]+)\"[\\s\\S]*?addVariable\\s*\\(\\s*\"vid_time\"\\s*,\\s*\"([^\"]+)\"','MegaVideo.com'),(6,0,0,0,'ted','http://www.ted.com/index.php/talks/view/id/@CODE@','firstRun\\s*=\\s*\"([^\"]+)\"','TED.com'),(7,0,0,0,'ted2','http://www.ted.com/index.php/talks/view/id/@CODE@','paste-->.+&file=([^&]+).*</object>','TED.com (for alternate player)'),(8,0,0,0,'yahoo','http://video.yahoo.com/watch/@CODE@','addVariable\\s*\\(\\s*\"id\"\\s*,\\s*\"([^\"]+)\"','Yahoo Video'),(9,0,0,0,'streetfire','http://videos.streetfire.net/video/@CODE@.htm','_embedCodeID.*video=([\\dabcdef\\-]+)','StreetFire'),(10,0,0,0,'myshows','http://www.myshows.cn/myplayvideo.aspx?vid=@CODE@','vidFileName=([^\"]+)','Myshows.cn (previouslyly seehaha.com)'),(11,0,0,0,'virb','http://www.virb.com/@CODE@','external/video/([^&\"]+)','Virb.com'),(12,0,0,0,'blip','http://www.blip.tv/file/@CODE@','setPostsId\\s*\\(\\s*(\\d+)\\s*\\)','Blip.tv'),(13,0,0,0,'apple','http://www.apple.com/trailers/@CODE@','\'(http:\\/\\/movies\\.apple\\.com\\/.*?\\.mov)\'','Apple.com trailers');
/*!40000 ALTER TABLE `jos_avr_ripper` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avr_tags`
--

DROP TABLE IF EXISTS `jos_avr_tags`;
CREATE TABLE `jos_avr_tags` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `player_id` int(11) NOT NULL,
  `ripper_id` int(11) NOT NULL default '0',
  `local` int(1) NOT NULL default '0',
  `plist` int(1) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `postreplace` varchar(255) NOT NULL default '',
  `sampleregex` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `tag` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=94 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avr_tags`
--

LOCK TABLES `jos_avr_tags` WRITE;
/*!40000 ALTER TABLE `jos_avr_tags` DISABLE KEYS */;
INSERT INTO `jos_avr_tags` VALUES (1,0,1,0,1,1,'flv','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.flv\";}','^(.+)\\.flv$','Local FLV'),(2,0,1,0,0,1,'flvremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.flv)$','Generic Remote FLV'),(3,0,1,0,1,1,'swf','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.swf\";}','^(.+)\\.swf$','Local SWF Video'),(4,0,1,0,0,1,'swfremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.swf)$','Generic Remote SWF Video'),(5,0,1,0,1,1,'mp3','a:3:{s:7:\"@WIDTH@\";s:8:\"@AWIDTH@\";s:8:\"@HEIGHT@\";s:9:\"@AHEIGHT@\";s:6:\"@MURL@\";s:16:\"@ALOC@@CODE@.mp3\";}','^(.+)\\.mp3$','Local MP3'),(6,0,1,0,0,1,'mp3remote','a:3:{s:7:\"@WIDTH@\";s:8:\"@AWIDTH@\";s:8:\"@HEIGHT@\";s:9:\"@AHEIGHT@\";s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mp3)$','Generic Remote MP3'),(7,0,1,0,1,1,'mp4-flv','a:2:{s:6:\"@TYPE@\";s:3:\"flv\";s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.mp4\";}','^(.+)\\.mp4$','Local MP4 (JW Media Player)'),(8,0,1,0,0,1,'mp4-flvremote','a:4:{s:7:\"@WIDTH@\";s:7:\"@WIDTH@\";s:8:\"@HEIGHT@\";s:8:\"@HEIGHT@\";s:6:\"@TYPE@\";s:3:\"flv\";s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mp4)$','Generic Remote MP4 (JW Media Player)'),(9,0,1,0,1,1,'m4v','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.m4v\";}','^(.+)\\.m4v$','Local M4V'),(10,0,1,0,0,1,'m4vremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.m4v)$','Generic Remote M4V'),(11,0,1,0,1,1,'3gp','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.3gp\";}','^(.+)\\.3gp$','Local 3GP'),(12,0,1,0,0,1,'3gpremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.3gp)$','Generic Remote 3GP'),(13,0,1,0,1,1,'rbs','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.rbs\";}','^(.+)\\.rbs$','Local RBS'),(14,0,1,0,0,1,'rbsremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.rbs)$','Generic Remote RBS'),(15,0,1,0,1,0,'auto','a:1:{s:6:\"@MURL@\";s:12:\"@VLOC@@CODE@\";}','^(.+\\.xml)$','Local Playlist'),(16,0,1,0,0,0,'autoremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.xml)$','Generic Remote Playlist'),(17,0,2,0,1,0,'wmv','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.wmv\";}','^(.+)\\.wmv$','Local WMV'),(18,0,2,0,0,0,'wmvremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.wmv)$','Generic Remote WMV'),(19,0,2,0,1,0,'wma','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.wma\";}','^(.+)\\.wma$','Local WMA'),(20,0,2,0,0,0,'wmaremote','a:3:{s:7:\"@WIDTH@\";s:8:\"@AWIDTH@\";s:8:\"@HEIGHT@\";s:9:\"@AHEIGHT@\";s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.wma)$','Generic Remote WMA'),(21,0,2,0,1,0,'avi','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.avi\";}','^(.+)\\.avi$','Local AVI'),(22,0,2,0,0,0,'aviremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.avi)$','Generic Remote AVI'),(23,0,2,0,1,0,'mpg','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.mpg\";}','^(.+)\\.mpg$','Local MPG'),(24,0,2,0,0,0,'mpgremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mpg)$','Generic Remote MPG'),(25,0,2,0,1,0,'mpeg','a:1:{s:6:\"@MURL@\";s:17:\"@VLOC@@CODE@.mpeg\";}','^(.+)\\.mpeg$','Local MPEG'),(26,0,2,0,0,0,'mpegremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mpeg)$','Generic Remote MPEG'),(27,0,3,0,1,0,'mov','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.mov\";}','^(.+)\\.mov$','Local MOV (QuickTime)'),(28,0,3,0,0,0,'movremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mov)$','Generic Remote MOV (QuickTime)'),(29,0,3,0,1,0,'mp4','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.mp4\";}','^(.+)\\.mp4','Local MP4 (QuickTime)'),(30,0,3,0,0,0,'mp4remote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.mp4)$','Generic Remote MP4 (QuickTime)'),(31,0,4,0,1,0,'rm','a:1:{s:6:\"@MURL@\";s:15:\"@VLOC@@CODE@.rm\";}','^(.+)\\.rm$','Local RM (RealMedia)'),(32,0,4,0,2,0,'rmremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.rm)$','Generic Remote RM (RealMedia)'),(33,0,4,0,1,0,'ram','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.ram\";}','^(.+)\\.ram$','Local RAM (RealMedia)'),(34,0,4,0,0,0,'ramremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.ram)$','Generic Remote RAM (RealMedia)'),(35,0,5,0,1,0,'divx','a:1:{s:6:\"@MURL@\";s:17:\"@VLOC@@CODE@.divx\";}','^(.+)\\.divx','Local DivX'),(36,0,5,0,0,0,'divxremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.divx)$','Generic Remote DivX'),(37,0,6,1,0,0,'6cn','','http:\\/\\/6\\.cn\\/watch\\/(\\d+)\\.html','6CN.com'),(38,0,7,0,0,0,'biku','','http:\\/\\/www\\.biku\\.com\\/opus\\/(\\d+)\\.html','Biku.com'),(39,0,8,2,0,0,'bofunk','','http:\\/\\/www.bofunk.com\\/video\\/(\\d+\\/[^\\.]+)\\.html$','Bofunk.com'),(40,0,9,3,0,0,'break','','http:\\/\\/www\\.break\\.com\\/index\\/(.*)\\.html$','Break.com'),(41,0,10,0,0,0,'clipfish','','http:\\/\\/www\\.clipfish\\.de\\/player\\.php\\?videoid=(.+)','ClipFish.de'),(42,0,11,0,0,0,'collegehumor','','http:\\/\\/www\\.collegehumor\\.com\\/video:(\\d+)','College Humor'),(43,0,12,0,0,0,'currenttv','','http:\\/\\/current\\.com\\/items\\/(\\d+)_.*','Current-TV'),(44,0,13,0,0,0,'dmotion','','http:\\/\\/www\\.dailymotion\\.com\\/.*video\\/([^_]+)_[^\\/]+$','DailyMotion.com'),(45,0,1,4,0,0,'dropshots','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','','Dropshots.com'),(46,0,14,0,0,0,'freevideoblog','','http:\\/\\/www\\.vidiac\\.com\\/video\\/([\\dabcdef\\-]+)\\.htm$','Vidiac.com (previously FreeVideoBlog)'),(47,0,15,0,0,0,'gametrailers','','http:\\/\\/www\\.gametrailers\\.com\\/player\\/(\\d+)\\.html$','GameTrailers'),(48,0,16,0,0,0,'google','a:1:{s:6:\"@LANG@\";s:2:\"en\";}','http:\\/\\/video\\.google\\.com\\/videoplay\\?docid=(-{0,1}\\d+)','Google Video (international)'),(49,0,16,0,0,0,'google.co.uk','a:1:{s:6:\"@LANG@\";s:5:\"en-GB\";}','http:\\/\\/video\\.google\\.co\\.uk\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (UK)'),(50,0,16,0,0,0,'google.com.au','a:1:{s:6:\"@LANG@\";s:5:\"en-AU\";}','http:\\/\\/video\\.google\\.com\\.au\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Australia)'),(51,0,16,0,0,0,'google.de','a:1:{s:6:\"@LANG@\";s:2:\"de\";}','http:\\/\\/video\\.google\\.de\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Germany)'),(52,0,16,0,0,0,'google.es','a:1:{s:6:\"@LANG@\";s:2:\"es\";}','http:\\/\\/video\\.google\\.es\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Spain)'),(53,0,16,0,0,0,'google.fr','a:1:{s:6:\"@LANG@\";s:2:\"fr\";}','http:\\/\\/video\\.google\\.fr\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (France)'),(54,0,16,0,0,0,'google.it','a:1:{s:6:\"@LANG@\";s:2:\"it\";}','http:\\/\\/video\\.google\\.it\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Italy)'),(55,0,16,0,0,0,'google.nl','a:1:{s:6:\"@LANG@\";s:2:\"nl\";}','http:\\/\\/video\\.google\\.nl\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Netherlands)'),(56,0,16,0,0,0,'google.pl','a:1:{s:6:\"@LANG@\";s:2:\"pl\";}','http:\\/\\/video\\.google\\.pl\\/videoplay\\?docid=(-{0,1}\\d+)$','Google Video (Poland)'),(57,0,17,0,0,0,'ifilm','','','Spike.com (previously iFilm.com)'),(58,0,18,0,0,0,'jumpcut','','http:\\/\\/www\\.jumpcut\\.com\\/view\\/{0,1}\\?id=([A-F\\d]+)$','JumpCut.com'),(59,0,19,5,0,0,'mega','','http:\\/\\/www\\.megavideo\\.com\\/\\?v=(\\w+)$','MegaVideo.com'),(60,0,20,0,0,0,'metacafe','','http:\\/\\/www\\.metacafe\\.com\\/watch\\/(\\d+\\/[a-z_]+)\\/$','Metacafe.com'),(61,0,21,0,0,0,'mofile','','http:\\/\\/tv\\.mofile\\.com\\/([^\\/]+)\\/$','Mofile TV'),(62,0,22,0,0,0,'myvideo','','http:\\/\\/www\\.myvideo\\.de\\/watch\\/(\\d+)','MyVideo.de'),(63,0,23,0,0,0,'quxiu','','http:\\/\\/www\\.quxiu\\.com\\/video\\/play_(\\d+_\\d+)\\.htm$','Quixu.com'),(64,0,24,0,0,0,'revver','','http:\\/\\/www\\.revver\\.com\\/video\\/(\\d+)\\/[^\\/]+\\/$','Revver.com (using Flash)'),(65,0,25,0,0,0,'seehaha','','http:\\/\\/www\\.seehaha\\.com\\/play\\/(\\d+)$','SeeHaha.com'),(66,0,26,0,0,0,'sevenload','','http:\\/\\/de\\.sevenload\\.com\\/videos\\/([^\\/\\-]{1,7})[^\\/\\-]?[\\/\\-][^\\/]+$','SevenLoad.de'),(67,0,27,0,0,0,'stickam','','http:\\/\\/www\\.stickam\\.com\\/editMediaComment\\.do\\?method=load&mId=(\\d+)$','StickAm.com'),(68,0,28,0,0,0,'streetfire','','http:\\/\\/videos\\.streetfire\\.net\\/video\\/([\\dabcdef-]+)\\.htm$','StreetFire Videos (Old variant)'),(69,0,29,6,0,0,'ted','','http:\\/\\/www\\.ted\\.com\\/(?:index\\.php\\/)?talks\\/view\\/id\\/(\\d+)$','TED.com (Original Player)'),(70,0,30,7,0,0,'ted2','','http:\\/\\/www\\.ted\\.com\\/index\\.php\\/talks\\/view\\/id\\/(\\d+)$','TED.com (Foreign Player)'),(71,0,31,0,0,0,'tudou','','http:\\/\\/www\\.tudou\\.com\\/programs\\/view\\/([^\\/]+)\\/$','Tudou.com'),(72,0,32,0,0,0,'uume','','http:\\/\\/www\\.uume\\.com\\/play_([^\\/]+)$','Uume.com'),(73,0,33,0,0,0,'vimeo','','http:\\/\\/(?:www\\.)?vimeo\\.com\\/(\\d+)$','Vimeo'),(74,0,34,0,0,0,'virb','','','Virb.com'),(75,0,1,0,0,0,'wangyou','a:1:{s:6:\"@MURL@\";s:50:\"http://v.wangyou.com/playlistMedia.php%3Fid=@CODE@\";}','http:\\/\\/v\\.wangyou\\.com\\/p([^\\.]+)\\.html','WangYou.com'),(76,0,36,8,0,0,'yahoo','','http:\\/\\/video\\.yahoo\\.com\\/watch\\/(\\d+)\\/.*$','Yahoo Video'),(77,0,37,0,0,0,'youtube','','http:\\/\\/(?:\\w+\\.)?youtube\\.com\\/watch\\?.*v=([^&]+).*$','YouTube (Original Player)'),(78,0,1,0,0,1,'youtubejw','a:2:{s:10:\"@IFS(IMG)@\";s:59:\"image:\'http://i.ytimg.com/vi/@CODE@/default.jpg\',@IFS(IMG)@\";s:6:\"@MURL@\";s:41:\"http://www.youtube.com/watch%3Fv%3D@CODE@\";}','http:\\/\\/(?:\\w+\\.)?youtube\\.com\\/watch\\?.*v=([^&]+).*$','YouTube (JW Media Player)'),(81,0,3,0,0,0,'revver-mov','a:1:{s:6:\"@MURL@\";s:50:\"http://media.revver.com/broadcast/@CODE@/video.mov\";}','','Revver.com (using QuickTime)'),(82,0,28,9,0,0,'streetfire2','','http:\\/\\/videos\\.streetfire\\.net\\/video\\/([^\\/\\.]+)\\.htm$','StreetFire Videos'),(83,0,14,0,0,0,'vidiac','','http:\\/\\/www\\.vidiac\\.com\\/video\\/([\\dabcdef\\-]+)\\.htm$','Vidiac.com (previously FreeVideoBlog)'),(84,0,39,0,1,0,'flash','a:1:{s:6:\"@MURL@\";s:16:\"@VLOC@@CODE@.swf\";}','^(.+)\\.swf$','Plain local flash embedding (for flash animations)'),(85,0,39,0,0,0,'flashremote','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^(https{0,1}:\\/\\/.*\\.swf)$','Plain remote flash embedding (for flash animations)'),(86,0,17,0,0,0,'spike','','^http:\\/\\/www\\.spike\\.com\\/video\\/.*\\/(\\d+)$','Spike.com (previously iFilm.com)'),(87,0,40,0,0,0,'bcove','','^http:\\/\\/www\\.brightcove\\.tv\\/title\\.jsp\\?title=(\\d+).*$','Brightcove.tv'),(88,0,41,10,0,0,'myshows','','http:\\/\\/www\\.myshows\\.cn\\/myplayvideo\\.aspx\\?vid=(\\d+)','Myshows.cn (previouslyly seehaha.com)'),(89,0,34,11,0,0,'virb2','','http:\\/\\/www\\.virb\\.com\\/(.*)$','Virb.com'),(90,0,42,12,0,0,'blip','','^http:\\/\\/(?:www\\.)?blip\\.tv\\/file\\/(\\d+).*','Blip.tv'),(91,0,1,12,0,0,'blipjw','a:1:{s:6:\"@MURL@\";s:57:\"http://blip.tv/rss/flash/@CODE@?referrer=blip.tv&source=1\";}','^http:\\/\\/(?:www\\.)?blip\\.tv\\/file\\/(\\d+)\\?.*','Blip.tv using JW Media Player'),(92,0,3,13,0,0,'apple','a:1:{s:6:\"@MURL@\";s:6:\"@CODE@\";}','^http:\\/\\/www\\.apple\\.com\\/trailers\\/(.*)','Apple.com trailers'),(93,0,39,0,0,0,'movieweb','a:1:{s:6:\"@MURL@\";s:32:\"http://www.movieweb.com/v/@CODE@\";}','http:\\/\\/www\\.movieweb\\.com\\/video\\/(\\w+)$','MovieWeb');
/*!40000 ALTER TABLE `jos_avr_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avrbak_avr_player`
--

DROP TABLE IF EXISTS `jos_avrbak_avr_player`;
CREATE TABLE `jos_avrbak_avr_player` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `minw` int(11) NOT NULL default '0',
  `minh` int(11) NOT NULL default '0',
  `isjw` int(1) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `code` mediumtext NOT NULL,
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avrbak_avr_player`
--

LOCK TABLES `jos_avrbak_avr_player` WRITE;
/*!40000 ALTER TABLE `jos_avrbak_avr_player` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_avrbak_avr_player` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avrbak_avr_ripper`
--

DROP TABLE IF EXISTS `jos_avrbak_avr_ripper`;
CREATE TABLE `jos_avrbak_avr_ripper` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `flags` int(11) NOT NULL default '0',
  `cindex` int(11) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `url` varchar(255) NOT NULL,
  `regex` varchar(255) NOT NULL,
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avrbak_avr_ripper`
--

LOCK TABLES `jos_avrbak_avr_ripper` WRITE;
/*!40000 ALTER TABLE `jos_avrbak_avr_ripper` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_avrbak_avr_ripper` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_avrbak_avr_tags`
--

DROP TABLE IF EXISTS `jos_avrbak_avr_tags`;
CREATE TABLE `jos_avrbak_avr_tags` (
  `id` int(11) NOT NULL auto_increment,
  `version` int(11) NOT NULL default '0',
  `player_id` int(11) NOT NULL,
  `ripper_id` int(11) NOT NULL default '0',
  `local` int(1) NOT NULL default '0',
  `plist` int(1) NOT NULL default '0',
  `name` varchar(25) NOT NULL,
  `postreplace` varchar(255) NOT NULL default '',
  `sampleregex` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `tag` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=83 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_avrbak_avr_tags`
--

LOCK TABLES `jos_avrbak_avr_tags` WRITE;
/*!40000 ALTER TABLE `jos_avrbak_avr_tags` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_avrbak_avr_tags` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_banner`
--

DROP TABLE IF EXISTS `jos_banner`;
CREATE TABLE `jos_banner` (
  `bid` int(11) NOT NULL auto_increment,
  `cid` int(11) NOT NULL default '0',
  `type` varchar(30) NOT NULL default 'banner',
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `imptotal` int(11) NOT NULL default '0',
  `impmade` int(11) NOT NULL default '0',
  `clicks` int(11) NOT NULL default '0',
  `imageurl` varchar(100) NOT NULL default '',
  `clickurl` varchar(200) NOT NULL default '',
  `date` datetime default NULL,
  `showBanner` tinyint(1) NOT NULL default '0',
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `custombannercode` text,
  `catid` int(10) unsigned NOT NULL default '0',
  `description` text NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  `tags` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY  (`bid`),
  KEY `viewbanner` (`showBanner`),
  KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_banner`
--

LOCK TABLES `jos_banner` WRITE;
/*!40000 ALTER TABLE `jos_banner` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_banner` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bannerclient`
--

DROP TABLE IF EXISTS `jos_bannerclient`;
CREATE TABLE `jos_bannerclient` (
  `cid` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `contact` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL default '0',
  `checked_out_time` time default NULL,
  `editor` varchar(50) default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_bannerclient`
--

LOCK TABLES `jos_bannerclient` WRITE;
/*!40000 ALTER TABLE `jos_bannerclient` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bannertrack`
--

DROP TABLE IF EXISTS `jos_bannertrack`;
CREATE TABLE `jos_bannertrack` (
  `track_date` date NOT NULL,
  `track_type` int(10) unsigned NOT NULL,
  `banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_bannertrack`
--

LOCK TABLES `jos_bannertrack` WRITE;
/*!40000 ALTER TABLE `jos_bannertrack` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bannertrack` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_blastchatc`
--

DROP TABLE IF EXISTS `jos_blastchatc`;
CREATE TABLE `jos_blastchatc` (
  `id` int(11) NOT NULL auto_increment,
  `url` varchar(100) default NULL,
  `version` varchar(20) NOT NULL default '2.3',
  `intra_id` varchar(100) default NULL,
  `priv_key` varchar(100) default NULL,
  `detached` binary(1) NOT NULL default '0',
  `adm_expand` binary(1) NOT NULL default '1',
  `width` varchar(6) NOT NULL default '100%',
  `height` varchar(6) NOT NULL default '480',
  `d_width` varchar(6) NOT NULL default '640',
  `d_height` varchar(6) NOT NULL default '480',
  `frame_border` binary(1) NOT NULL default '0',
  `m_width` varchar(6) NOT NULL default '0',
  `m_height` varchar(6) NOT NULL default '0',
  `global_count` int(11) NOT NULL default '0',
  `global_update` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_blastchatc`
--

LOCK TABLES `jos_blastchatc` WRITE;
/*!40000 ALTER TABLE `jos_blastchatc` DISABLE KEYS */;
INSERT INTO `jos_blastchatc` VALUES (1,'gospelmusicomaha.qmgonline.net/radio','2.3','fb81c01bc77c8690f3a5800704ac681a','d2ab38debdaaf648b354caba5bd65b51','1','1','100%','480','640','480','0','0','0',0,0);
/*!40000 ALTER TABLE `jos_blastchatc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_blastchatc_users`
--

DROP TABLE IF EXISTS `jos_blastchatc_users`;
CREATE TABLE `jos_blastchatc_users` (
  `userid` int(11) default '0',
  `serverid` int(11) default '0',
  `sec_code` varchar(100) default NULL,
  `session_id` varchar(200) NOT NULL default '0',
  `logged` binary(1) NOT NULL default '0',
  `last_entry` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_update` int(11) NOT NULL default '0',
  `idle` varchar(5) default NULL,
  `roomid` int(11) NOT NULL default '0',
  `room_serverid` int(11) NOT NULL default '0',
  `roomname` varchar(100) default NULL,
  PRIMARY KEY  (`session_id`),
  UNIQUE KEY `sec_code` (`sec_code`),
  KEY `userid_logged_last_update` (`userid`,`logged`,`last_update`,`session_id`),
  KEY `serverid` (`serverid`,`userid`,`sec_code`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_blastchatc_users`
--

LOCK TABLES `jos_blastchatc_users` WRITE;
/*!40000 ALTER TABLE `jos_blastchatc_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_blastchatc_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_books`
--

DROP TABLE IF EXISTS `jos_bsms_books`;
CREATE TABLE `jos_bsms_books` (
  `id` int(3) NOT NULL auto_increment,
  `bookname` varchar(250) default NULL,
  `booknumber` int(5) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=69 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_books`
--

LOCK TABLES `jos_bsms_books` WRITE;
/*!40000 ALTER TABLE `jos_bsms_books` DISABLE KEYS */;
INSERT INTO `jos_bsms_books` VALUES (1,'Genesis',101,1),(2,'Exodus',102,1),(3,'Leviticus',103,1),(4,'Numbers',104,1),(5,'Deuteronomy',105,1),(6,'Joshua',106,1),(7,'Judges',107,1),(8,'Ruth',108,1),(9,'1Samuel',109,1),(10,'2Samuel',110,1),(11,'1Kings',111,1),(12,'2Kings',112,1),(13,'1Chronicles',113,1),(14,'2Chronicles',114,1),(15,'Ezra',115,1),(16,'Nehemiah',116,1),(17,'Esther',117,1),(18,'Job',118,1),(19,'Psalm',119,1),(20,'Proverbs',120,1),(21,'Ecclesiastes',121,1),(22,'Song of Solomon',122,1),(23,'Isaiah',123,1),(24,'Jeremiah',124,1),(25,'Lamentations',125,1),(26,'Ezekiel',126,1),(27,'Daniel',127,1),(28,'Hosea',128,1),(29,'Joel',129,1),(30,'Amos',130,1),(31,'Obadiah',131,1),(32,'Jonah',132,1),(33,'Micah',133,1),(34,'Nahum',134,1),(35,'Habakkuk',135,1),(36,'Zephaniah',136,1),(37,'Haggai',137,1),(38,'Zechariah',138,1),(39,'Malachi',139,1),(40,'Matthew',140,1),(41,'Mark',141,1),(42,'Luke',142,1),(43,'John',143,1),(44,'Acts',144,1),(45,'Romans',145,1),(46,'1Corinthians',146,1),(47,'2Corinthians',147,1),(48,'Galatians',148,1),(49,'Ephesians',149,1),(50,'Philippians',150,1),(51,'Colossians',151,1),(52,'1Thessalonians',152,1),(53,'2Thessalonians',153,1),(54,'1Timothy',154,1),(55,'2Timothy',155,1),(56,'Titus',156,1),(57,'Philemon',157,1),(58,'Hebrews',158,1),(59,'James',159,1),(60,'1Peter',160,1),(61,'2Peter',161,1),(62,'1John',162,1),(63,'2John',163,1),(64,'3John',164,1),(65,'Jude',165,1),(66,'Revelation',166,1),(67,'Topical',167,1),(68,'Holiday',168,1);
/*!40000 ALTER TABLE `jos_bsms_books` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_folders`
--

DROP TABLE IF EXISTS `jos_bsms_folders`;
CREATE TABLE `jos_bsms_folders` (
  `id` int(11) NOT NULL auto_increment,
  `foldername` varchar(250) default NULL,
  `folderpath` varchar(250) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_folders`
--

LOCK TABLES `jos_bsms_folders` WRITE;
/*!40000 ALTER TABLE `jos_bsms_folders` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bsms_folders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_media`
--

DROP TABLE IF EXISTS `jos_bsms_media`;
CREATE TABLE `jos_bsms_media` (
  `id` int(3) NOT NULL auto_increment,
  `media_text` text,
  `media_image_name` varchar(250) default NULL,
  `media_image_path` varchar(250) default NULL,
  `media_alttext` varchar(250) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_media`
--

LOCK TABLES `jos_bsms_media` WRITE;
/*!40000 ALTER TABLE `jos_bsms_media` DISABLE KEYS */;
INSERT INTO `jos_bsms_media` VALUES (2,'mp3 compressed audio file','mp3','components/com_biblestudy/images/speaker24.png','mp3 audio file',1),(3,'Video','Video File','components/com_biblestudy/images/video24.png','Video File',1),(4,'m4v','Video Podcast','components/com_biblestudy/images/podcast-video24.png','Video Podcast',1),(6,'Streaming Audio','Streaming Audio','components/com_biblestudy/images/streamingaudio24.png','Streaming Audio',1),(7,'Streaming Video','Streaming Video','components/com_biblestudy/images/streamingvideo24.png','Streaming Video',1),(8,'Real Audio','Real Audio','components/com_biblestudy/images/realplayer24.png','Real Audio',1),(9,'Windows Media Audio','Windows Media Audio','components/com_biblestudy/images/windows-media24.png','Windows Media File',1),(10,'Podcast Audio','Podcast Audio','components/com_biblestudy/images/podcast-audio24.png','Podcast Audio',1);
/*!40000 ALTER TABLE `jos_bsms_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_mediafiles`
--

DROP TABLE IF EXISTS `jos_bsms_mediafiles`;
CREATE TABLE `jos_bsms_mediafiles` (
  `id` int(3) NOT NULL auto_increment,
  `study_id` int(5) default NULL,
  `media_image` int(3) default NULL,
  `server` varchar(250) default NULL,
  `path` varchar(250) default NULL,
  `special` varchar(250) default '_self',
  `filename` text,
  `size` varchar(50) default NULL,
  `mime_type` int(3) default NULL,
  `podcast_id` int(3) default NULL,
  `internal_viewer` tinyint(1) default '0',
  `mediacode` varchar(300) default NULL,
  `ordering` int(11) NOT NULL default '0',
  `createdate` datetime default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_mediafiles`
--

LOCK TABLES `jos_bsms_mediafiles` WRITE;
/*!40000 ALTER TABLE `jos_bsms_mediafiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bsms_mediafiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_message_type`
--

DROP TABLE IF EXISTS `jos_bsms_message_type`;
CREATE TABLE `jos_bsms_message_type` (
  `id` int(11) NOT NULL auto_increment,
  `message_type` text,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_message_type`
--

LOCK TABLES `jos_bsms_message_type` WRITE;
/*!40000 ALTER TABLE `jos_bsms_message_type` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bsms_message_type` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_mimetype`
--

DROP TABLE IF EXISTS `jos_bsms_mimetype`;
CREATE TABLE `jos_bsms_mimetype` (
  `id` int(3) NOT NULL auto_increment,
  `mimetype` varchar(50) default NULL,
  `mimetext` varchar(50) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_mimetype`
--

LOCK TABLES `jos_bsms_mimetype` WRITE;
/*!40000 ALTER TABLE `jos_bsms_mimetype` DISABLE KEYS */;
INSERT INTO `jos_bsms_mimetype` VALUES (1,'audio/mpeg3','MP3 Audio',1),(2,'audio/x-pn-realaudio','Real Audio',1),(3,'video/x-m4v','Podcast Video m4v',1),(4,'application/vnd.rn-realmedia','Real Media rm',1),(5,'audio/x-ms-wma','Windows Media Audio WMA',1),(6,'text/html','Text',1),(7,'audio/x-wav','Windows wav File',1),(8,'audio/x-pn-realaudio-plugin',' Real audio Plugin.rpm',1),(9,'audio/x-pn-realaudio','Real Media File .rm',1),(10,'audio/x-realaudio','Rea Audio File .ra',1),(11,'audio/x-pn-realaudio','Read Audio File.ram',1),(12,'video/mpeg',' Mpeg video .mpg',1),(13,'audio/mpeg','Video .mp2 File',1),(14,'video/x-msvideo',' Video .avi File',1),(15,'video/x-flv .flv',' Flash Video FLV',1);
/*!40000 ALTER TABLE `jos_bsms_mimetype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_order`
--

DROP TABLE IF EXISTS `jos_bsms_order`;
CREATE TABLE `jos_bsms_order` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(15) default NULL,
  `text` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_order`
--

LOCK TABLES `jos_bsms_order` WRITE;
/*!40000 ALTER TABLE `jos_bsms_order` DISABLE KEYS */;
INSERT INTO `jos_bsms_order` VALUES (1,'ASC','Ascending'),(2,'DESC','Descending');
/*!40000 ALTER TABLE `jos_bsms_order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_podcast`
--

DROP TABLE IF EXISTS `jos_bsms_podcast`;
CREATE TABLE `jos_bsms_podcast` (
  `id` int(3) NOT NULL auto_increment,
  `title` varchar(100) default NULL,
  `website` varchar(100) default NULL,
  `description` varchar(500) default NULL,
  `image` varchar(130) default NULL,
  `imageh` int(3) default NULL,
  `imagew` int(3) default NULL,
  `author` varchar(100) default NULL,
  `podcastimage` varchar(130) default NULL,
  `podcastsearch` varchar(255) default NULL,
  `filename` varchar(150) default NULL,
  `language` varchar(10) default 'en-us',
  `editor_name` varchar(150) default NULL,
  `editor_email` varchar(150) default NULL,
  `podcastlimit` int(5) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_podcast`
--

LOCK TABLES `jos_bsms_podcast` WRITE;
/*!40000 ALTER TABLE `jos_bsms_podcast` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bsms_podcast` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_schemaVersion`
--

DROP TABLE IF EXISTS `jos_bsms_schemaVersion`;
CREATE TABLE `jos_bsms_schemaVersion` (
  `id` int(3) NOT NULL auto_increment,
  `schemaVersion` int(10) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_schemaVersion`
--

LOCK TABLES `jos_bsms_schemaVersion` WRITE;
/*!40000 ALTER TABLE `jos_bsms_schemaVersion` DISABLE KEYS */;
INSERT INTO `jos_bsms_schemaVersion` VALUES (1,600);
/*!40000 ALTER TABLE `jos_bsms_schemaVersion` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_search`
--

DROP TABLE IF EXISTS `jos_bsms_search`;
CREATE TABLE `jos_bsms_search` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(15) default NULL,
  `text` varchar(15) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_search`
--

LOCK TABLES `jos_bsms_search` WRITE;
/*!40000 ALTER TABLE `jos_bsms_search` DISABLE KEYS */;
INSERT INTO `jos_bsms_search` VALUES (1,'studytitle','Title'),(2,'studytext','Details'),(3,'studyintro','Description');
/*!40000 ALTER TABLE `jos_bsms_search` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_series`
--

DROP TABLE IF EXISTS `jos_bsms_series`;
CREATE TABLE `jos_bsms_series` (
  `id` int(3) NOT NULL auto_increment,
  `series_text` text,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_series`
--

LOCK TABLES `jos_bsms_series` WRITE;
/*!40000 ALTER TABLE `jos_bsms_series` DISABLE KEYS */;
INSERT INTO `jos_bsms_series` VALUES (1,'GMO Study Series',1);
/*!40000 ALTER TABLE `jos_bsms_series` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_servers`
--

DROP TABLE IF EXISTS `jos_bsms_servers`;
CREATE TABLE `jos_bsms_servers` (
  `id` int(3) NOT NULL auto_increment,
  `server_name` varchar(250) default NULL,
  `server_path` varchar(250) default NULL,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_servers`
--

LOCK TABLES `jos_bsms_servers` WRITE;
/*!40000 ALTER TABLE `jos_bsms_servers` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_bsms_servers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_studies`
--

DROP TABLE IF EXISTS `jos_bsms_studies`;
CREATE TABLE `jos_bsms_studies` (
  `id` int(11) NOT NULL auto_increment,
  `studydate` datetime default NULL,
  `teacher_id` int(11) default '1',
  `studynumber` varchar(100) default '',
  `booknumber` int(3) default '101',
  `chapter_begin` int(3) default NULL,
  `verse_begin` int(3) default NULL,
  `chapter_end` int(3) default NULL,
  `secondary_reference` text,
  `verse_end` int(3) default NULL,
  `studytitle` text,
  `studyintro` text,
  `media_hours` varchar(2) default NULL,
  `media_minutes` varchar(2) default NULL,
  `media_seconds` varchar(2) default NULL,
  `messagetype` varchar(100) default '1',
  `series_id` int(3) default NULL,
  `topics_id` int(3) default NULL,
  `studytext` text,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_studies`
--

LOCK TABLES `jos_bsms_studies` WRITE;
/*!40000 ALTER TABLE `jos_bsms_studies` DISABLE KEYS */;
INSERT INTO `jos_bsms_studies` VALUES (1,'2008-10-10 00:00:00',1,'1',146,0,0,0,'',0,'How To Win Against Sin','How To Win Against Sin study series','','','','0',0,87,'',1);
/*!40000 ALTER TABLE `jos_bsms_studies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_teachers`
--

DROP TABLE IF EXISTS `jos_bsms_teachers`;
CREATE TABLE `jos_bsms_teachers` (
  `id` int(11) NOT NULL auto_increment,
  `teachername` varchar(250) default NULL,
  `title` varchar(50) default NULL,
  `phone` varchar(50) default NULL,
  `email` varchar(100) default NULL,
  `website` varchar(300) default NULL,
  `information` text,
  `image` text,
  `imageh` text,
  `imagew` text,
  `thumb` text,
  `thumbw` text,
  `thumbh` text,
  `short` text,
  `ordering` int(3) default NULL,
  `catid` int(3) default '1',
  `list_show` tinyint(1) NOT NULL default '1',
  `published` tinyint(1) default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_teachers`
--

LOCK TABLES `jos_bsms_teachers` WRITE;
/*!40000 ALTER TABLE `jos_bsms_teachers` DISABLE KEYS */;
INSERT INTO `jos_bsms_teachers` VALUES (1,'LuvLuv','','','','','','','','','','','','',0,1,1,1);
/*!40000 ALTER TABLE `jos_bsms_teachers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_bsms_topics`
--

DROP TABLE IF EXISTS `jos_bsms_topics`;
CREATE TABLE `jos_bsms_topics` (
  `id` int(11) NOT NULL auto_increment,
  `topic_text` text,
  `published` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=114 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bsms_topics`
--

LOCK TABLES `jos_bsms_topics` WRITE;
/*!40000 ALTER TABLE `jos_bsms_topics` DISABLE KEYS */;
INSERT INTO `jos_bsms_topics` VALUES (1,'Abortion',1),(3,'Addiction',1),(4,'Afterlife',1),(5,'Apologetics',1),(7,'Baptism',1),(8,'Basics of Christianity',1),(9,'Becoming a Christian',1),(10,'Bible',1),(37,'Blended Family Relationships',1),(12,'Children',1),(13,'Christ',1),(14,'Christian Character/Fruits',1),(15,'Christian Values',1),(16,'Christmas Season',1),(17,'Church',1),(18,'Communication',1),(19,'Communion / Lords Supper',1),(21,'Creation',1),(23,'Cults',1),(113,'Da Vinci Code',1),(24,'Death',1),(26,'Descriptions of God',1),(27,'Disciples',1),(28,'Discipleship',1),(30,'Divorce',1),(32,'Easter Season',1),(33,'Emotions',1),(34,'Entertainment',1),(35,'Evangelism',1),(36,'Faith',1),(103,'Family',1),(39,'Forgiving Others',1),(104,'Freedom',1),(41,'Friendship',1),(42,'Fulfillment in Life',1),(43,'Fund-raising Rally',1),(44,'Funerals',1),(45,'Giving',1),(2,'Gods Activity',1),(6,'Gods Attributes',1),(40,'Gods Forgiveness',1),(58,'Gods Love',1),(65,'Gods Nature',1),(46,'Gods Will',1),(47,'Hardship of Life',1),(107,'Holidays',1),(48,'Holy Spirit',1),(111,'Hot Topics',1),(11,'Jesus Birth',1),(22,'Jesus Cross/Final Week',1),(29,'Jesus Divinity',1),(50,'Jesus Humanity',1),(56,'Jesus Life',1),(61,'Jesus Miracles',1),(84,'Jesus Resurrection',1),(93,'Jesus Teaching',1),(52,'Kingdom of God',1),(55,'Leadership Essentials',1),(57,'Love',1),(59,'Marriage',1),(109,'Men',1),(82,'Messianic Prophecies',1),(62,'Misconceptions of Christianity',1),(63,'Money',1),(112,'Narnia',1),(66,'Our Need for God',1),(69,'Parables',1),(70,'Paranormal',1),(71,'Parenting',1),(73,'Poverty',1),(74,'Prayer',1),(76,'Prominent N.T. Men',1),(77,'Prominent N.T. Women',1),(78,'Prominent O.T. Men',1),(79,'Prominent O.T. Women',1),(83,'Racism',1),(85,'Second Coming',1),(86,'Sexuality',1),(87,'Sin',1),(88,'Singleness',1),(89,'Small Groups',1),(108,'Special Services',1),(90,'Spiritual Disciplines',1),(91,'Spiritual Gifts',1),(105,'Stewardship',1),(92,'Supernatural',1),(94,'Temptation',1),(95,'Ten Commandments',1),(97,'Truth',1),(98,'Twelve Apostles',1),(100,'Weddings',1),(110,'Women',1),(101,'Workplace Issues',1),(102,'World Religions',1),(106,'Worship',1);
/*!40000 ALTER TABLE `jos_bsms_topics` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_categories`
--

DROP TABLE IF EXISTS `jos_categories`;
CREATE TABLE `jos_categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `image` varchar(255) NOT NULL default '',
  `section` varchar(50) NOT NULL default '',
  `image_position` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `editor` varchar(50) default NULL,
  `ordering` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_categories`
--

LOCK TABLES `jos_categories` WRITE;
/*!40000 ALTER TABLE `jos_categories` DISABLE KEYS */;
INSERT INTO `jos_categories` VALUES (1,0,'Latest News','','latest','','1','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(2,0,'Contacts','','contacts','','com_contact_details','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,'');
/*!40000 ALTER TABLE `jos_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_cbmailing_permissions`
--

DROP TABLE IF EXISTS `jos_cbmailing_permissions`;
CREATE TABLE `jos_cbmailing_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `toid` int(11) NOT NULL default '0',
  `fromid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_cbmailing_permissions`
--

LOCK TABLES `jos_cbmailing_permissions` WRITE;
/*!40000 ALTER TABLE `jos_cbmailing_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_cbmailing_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_components`
--

DROP TABLE IF EXISTS `jos_components`;
CREATE TABLE `jos_components` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `link` varchar(255) NOT NULL default '',
  `menuid` int(11) unsigned NOT NULL default '0',
  `parent` int(11) unsigned NOT NULL default '0',
  `admin_menu_link` varchar(255) NOT NULL default '',
  `admin_menu_alt` varchar(255) NOT NULL default '',
  `option` varchar(50) NOT NULL default '',
  `ordering` int(11) NOT NULL default '0',
  `admin_menu_img` varchar(255) NOT NULL default '',
  `iscore` tinyint(4) NOT NULL default '0',
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM AUTO_INCREMENT=92 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_components`
--

LOCK TABLES `jos_components` WRITE;
/*!40000 ALTER TABLE `jos_components` DISABLE KEYS */;
INSERT INTO `jos_components` VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n',1),(2,'Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,'',1),(3,'Clients','',0,1,'option=com_banners&c=client','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,'',1),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/component.png',0,'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n',1),(5,'Links','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,'',1),(6,'Categories','',0,4,'option=com_categories&section=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,'',1),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/component.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(8,'Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,'',1),(9,'Categories','',0,7,'option=com_categories&section=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',1),(10,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,'',1),(11,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,'',1),(12,'Feeds','',0,11,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n',1),(13,'Categories','',0,11,'option=com_categories&section=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,'',1),(14,'User','option=com_user',0,0,'','','com_user',0,'',1,'',1),(15,'Search','option=com_search',0,0,'option=com_search','Search Statistics','com_search',0,'js/ThemeOffice/component.png',1,'enabled=0\n\n',1),(16,'Categories','',0,1,'option=com_categories&section=com_banner','Categories','',3,'',1,'',1),(17,'Wrapper','option=com_wrapper',0,0,'','Wrapper','com_wrapper',0,'',1,'',1),(18,'Mail To','',0,0,'','','com_mailto',0,'',1,'',1),(19,'Media Manager','',0,0,'option=com_media','Media Manager','com_media',0,'',1,'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\nenable_flash=1\n\n',1),(20,'Articles','option=com_content',0,0,'','','com_content',0,'',1,'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=0\nfeed_summary=0\nfilter_tags=\nfilter_attritbutes=\n\n',1),(21,'Configuration Manager','',0,0,'','Configuration','com_config',0,'',1,'',1),(22,'Installation Manager','',0,0,'','Installer','com_installer',0,'',1,'',1),(23,'Language Manager','',0,0,'','Languages','com_languages',0,'',1,'administrator=en-GB\nsite=en-GB',1),(24,'Mass mail','',0,0,'','Mass Mail','com_massmail',0,'',1,'mailSubjectPrefix=\nmailBodySuffix=\n\n',1),(25,'Menu Editor','',0,0,'','Menu Editor','com_menus',0,'',1,'',1),(27,'Messaging','',0,0,'','Messages','com_messages',0,'',1,'',1),(28,'Modules Manager','',0,0,'','Modules','com_modules',0,'',1,'',1),(29,'Plugin Manager','',0,0,'','Plugins','com_plugins',0,'',1,'',1),(30,'Template Manager','',0,0,'','Templates','com_templates',0,'',1,'',1),(31,'User Manager','',0,0,'','Users','com_users',0,'',1,'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=0\nfrontend_userparams=1\n\n',1),(32,'Cache Manager','',0,0,'','Cache','com_cache',0,'',1,'',1),(33,'Control Panel','',0,0,'','Control Panel','com_cpanel',0,'',1,'',1),(34,'Community Builder','option=com_comprofiler',0,0,'option=com_comprofiler','Community Builder','com_comprofiler',0,'js/ThemeOffice/component.png',0,'',1),(35,'User Management','',0,34,'option=com_comprofiler&task=showusers','User Management','com_comprofiler',0,'js/ThemeOffice/users.png',0,'',1),(36,'Tab Management','',0,34,'option=com_comprofiler&task=showTab','Tab Management','com_comprofiler',1,'js/ThemeOffice/content.png',0,'',1),(37,'Field Management','',0,34,'option=com_comprofiler&task=showField','Field Management','com_comprofiler',2,'js/ThemeOffice/content.png',0,'',1),(38,'List Management','',0,34,'option=com_comprofiler&task=showLists','List Management','com_comprofiler',3,'js/ThemeOffice/content.png',0,'',1),(39,'Plugin Management','',0,34,'option=com_comprofiler&task=showPlugins','Plugin Management','com_comprofiler',4,'js/ThemeOffice/install.png',0,'',1),(40,'Tools','',0,34,'option=com_comprofiler&task=tools','Tools','com_comprofiler',5,'js/ThemeOffice/component.png',0,'',1),(41,'Configuration','',0,34,'option=com_comprofiler&task=showconfig','Configuration','com_comprofiler',6,'js/ThemeOffice/config.png',0,'',1),(42,'CbMailing','option=com_cbmailing',0,0,'option=com_cbmailing','CbMailing','com_cbmailing',0,'js/ThemeOffice/component.png',0,'',1),(43,'Send mailing','',0,42,'option=com_cbmailing&task=mailing','Send mailing','com_cbmailing',0,'js/ThemeOffice/component.png',0,'',1),(44,'Manage permissions','',0,42,'option=com_cbmailing&task=permissions','Manage permissions','com_cbmailing',1,'js/ThemeOffice/component.png',0,'',1),(45,'CB Picture Admin','option=com_cbpictureadmin',0,0,'option=com_cbpictureadmin','CB Picture Admin','com_cbpictureadmin',0,'js/ThemeOffice/component.png',0,'',1),(46,'Edit Config','',0,45,'option=com_cbpictureadmin&task=Config','Edit Config','com_cbpictureadmin',0,'js/ThemeOffice/component.png',0,'',1),(47,'Main','',0,45,'option=com_cbpictureadmin&task=Main','Main','com_cbpictureadmin',1,'js/ThemeOffice/component.png',0,'',1),(48,'JoomlaPack','option=com_joomlapack',0,0,'option=com_joomlapack','JoomlaPack','com_joomlapack',0,'js/ThemeOffice/component.png',0,'',1),(49,'Control Panel','',0,48,'option=com_joomlapack&act=cpanel','Control Panel','com_joomlapack',0,'js/ThemeOffice/component.png',0,'',1),(50,'Options','',0,48,'option=com_joomlapack&act=config','Options','com_joomlapack',1,'js/ThemeOffice/component.png',0,'',1),(51,'Exclude Directories','',0,48,'option=com_joomlapack&act=def','Exclude Directories','com_joomlapack',2,'js/ThemeOffice/component.png',0,'',1),(52,'Backup Now','',0,48,'option=com_joomlapack&act=pack','Backup Now','com_joomlapack',3,'js/ThemeOffice/component.png',0,'',1),(53,'Manage Backup Files','',0,48,'option=com_joomlapack&act=backupadmin','Manage Backup Files','com_joomlapack',4,'js/ThemeOffice/component.png',0,'',1),(54,'Backup Log','',0,48,'option=com_joomlapack&act=log','Backup Log','com_joomlapack',5,'js/ThemeOffice/component.png',0,'',1),(55,'LivingWord','option=com_livingword',0,0,'option=com_livingword','LivingWord','com_livingword',0,'js/ThemeOffice/component.png',0,'',1),(56,'Configure','',0,55,'option=com_livingword&task=config','Configure','com_livingword',0,'js/ThemeOffice/config.png',0,'',1),(57,'Support','',0,55,'option=com_livingword&task=support','Support','com_livingword',1,'js/ThemeOffice/component.png',0,'',1),(58,'Bible Study Manager','option=com_biblestudy',0,0,'option=com_biblestudy','Bible Study Manager','com_biblestudy',0,'../components/com_biblestudy/images/biblemenu.png',0,'',1),(59,'Studies','',0,58,'option=com_biblestudy&view=studieslist','Studies','com_biblestudy',0,'js/ThemeOffice/component.png',0,'',1),(60,'Media Files','',0,58,'option=com_biblestudy&view=mediafileslist','Media Files','com_biblestudy',1,'js/ThemeOffice/component.png',0,'',1),(61,'Teachers','',0,58,'option=com_biblestudy&view=teacherlist','Teachers','com_biblestudy',2,'js/ThemeOffice/component.png',0,'',1),(62,'Bible Books','',0,58,'option=com_biblestudy&view=bookslist','Bible Books','com_biblestudy',3,'js/ThemeOffice/component.png',0,'',1),(63,'Media Images','',0,58,'option=com_biblestudy&view=medialist','Media Images','com_biblestudy',4,'js/ThemeOffice/component.png',0,'',1),(64,'Series','',0,58,'option=com_biblestudy&view=serieslist','Series','com_biblestudy',5,'js/ThemeOffice/component.png',0,'',1),(65,'Servers','',0,58,'option=com_biblestudy&view=serverslist','Servers','com_biblestudy',6,'js/ThemeOffice/component.png',0,'',1),(66,'Server Folders','',0,58,'option=com_biblestudy&view=folderslist','Server Folders','com_biblestudy',7,'js/ThemeOffice/component.png',0,'',1),(67,'Message Types','',0,58,'option=com_biblestudy&view=messagetypelist','Message Types','com_biblestudy',8,'js/ThemeOffice/component.png',0,'',1),(68,'Topics','',0,58,'option=com_biblestudy&view=topicslist','Topics','com_biblestudy',9,'js/ThemeOffice/component.png',0,'',1),(69,'Podcasts','',0,58,'option=com_biblestudy&view=podcastlist','Podcasts','com_biblestudy',10,'js/ThemeOffice/component.png',0,'',1),(70,'Podcast Episodes','',0,58,'option=com_biblestudy&view=episodelist','Podcast Episodes','com_biblestudy',11,'js/ThemeOffice/component.png',0,'',1),(71,'Mime Types','',0,58,'option=com_biblestudy&view=mimetypelist','Mime Types','com_biblestudy',12,'js/ThemeOffice/component.png',0,'',1),(72,'SermonSpeaker','option=com_sermonspeaker',0,0,'option=com_sermonspeaker','SermonSpeaker','com_sermonspeaker',0,'js/ThemeOffice/component.png',0,'',1),(73,'Media Manager','',0,72,'option=com_sermonspeaker&task=media','Media Manager','com_sermonspeaker',0,'js/ThemeOffice/component.png',0,'',1),(74,'Series','',0,72,'option=com_sermonspeaker&task=series','Series','com_sermonspeaker',1,'js/ThemeOffice/component.png',0,'',1),(75,'Speaker','',0,72,'option=com_sermonspeaker&task=speakers','Speaker','com_sermonspeaker',2,'js/ThemeOffice/component.png',0,'',1),(76,'Sermon','',0,72,'option=com_sermonspeaker&task=sermons','Sermon','com_sermonspeaker',3,'js/ThemeOffice/component.png',0,'',1),(77,'Statistics','',0,72,'option=com_sermonspeaker&task=stats','Statistics','com_sermonspeaker',4,'js/ThemeOffice/component.png',0,'',1),(78,'Help','',0,72,'option=com_sermonspeaker&task=help','Help','com_sermonspeaker',5,'js/ThemeOffice/component.png',0,'',1),(79,'Configuration','',0,72,'option=com_sermonspeaker&task=config','Configuration','com_sermonspeaker',6,'js/ThemeOffice/component.png',0,'',1),(80,'BlastChat client 2.3','option=com_blastchatc',0,0,'option=com_blastchatc','BlastChat client 2.3','com_blastchatc',0,'js/ThemeOffice/component.png',0,'',1),(81,'Configuration','',0,80,'option=com_blastchatc&task=config','BlastChat Client - Configuration','com_blastchatc',0,'../components/com_blastchatc/images/config.png',0,'',1),(82,'Users','',0,80,'option=com_blastchatc&task=users','BlastChat Client - Users','com_blastchatc',1,'../components/com_blastchatc/images/con_info.png',0,'',1),(83,'Registration','',0,80,'option=com_blastchatc&task=register','BlastChat Client - Registration','com_blastchatc',2,'../components/com_blastchatc/images/credits.png',0,'',1),(84,'Credits','',0,80,'option=com_blastchatc&task=credits','BlastChat Client - Credits','com_blastchatc',3,'../components/com_blastchatc/images/credits.png',0,'',1),(85,'Vivo MeeBo Chat Room','option=com_vivocitimeebochatroom15',0,0,'option=com_vivocitimeebochatroom15','Vivo MeeBo Chat Room','com_vivocitimeebochatroom15',0,'js/ThemeOffice/component.png',0,'',1),(86,'Seyret','option=com_seyret',0,0,'option=com_seyret','Seyret','com_seyret',0,'js/ThemeOffice/component.png',0,'',1),(87,'AvReloaded','',0,0,'','AvReloaded','com_avreloaded',0,'',0,'',1),(88,'AVR_TITLE_MANAGE_PLAYERS','',0,87,'option=com_avreloaded&view=players','AVR_TITLE_MANAGE_PLAYERS','com_avreloaded',0,'components/com_avreloaded/assets/avreloaded-16x16.png',0,'',1),(89,'AVR_TITLE_MANAGE_RIPPERS','',0,87,'option=com_avreloaded&view=rippers','AVR_TITLE_MANAGE_RIPPERS','com_avreloaded',1,'components/com_avreloaded/assets/avreloaded-16x16.png',0,'',1),(90,'AVR_TITLE_MANAGE_TAGS','',0,87,'option=com_avreloaded&view=tags','AVR_TITLE_MANAGE_TAGS','com_avreloaded',2,'components/com_avreloaded/assets/avreloaded-16x16.png',0,'',1),(91,'AVR_TITLE_MANAGE_PLAYLISTS','',0,87,'option=com_avreloaded&view=playlists','AVR_TITLE_MANAGE_PLAYLISTS','com_avreloaded',3,'components/com_avreloaded/assets/avreloaded-16x16.png',0,'',1);
/*!40000 ALTER TABLE `jos_components` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler`
--

DROP TABLE IF EXISTS `jos_comprofiler`;
CREATE TABLE `jos_comprofiler` (
  `id` int(11) NOT NULL default '0',
  `user_id` int(11) NOT NULL default '0',
  `firstname` varchar(100) default NULL,
  `middlename` varchar(100) default NULL,
  `lastname` varchar(100) default NULL,
  `hits` int(11) NOT NULL default '0',
  `message_last_sent` datetime NOT NULL default '0000-00-00 00:00:00',
  `message_number_sent` int(11) NOT NULL default '0',
  `avatar` varchar(255) default NULL,
  `avatarapproved` tinyint(4) default '1',
  `approved` tinyint(4) NOT NULL default '1',
  `confirmed` tinyint(4) NOT NULL default '1',
  `lastupdatedate` datetime NOT NULL default '0000-00-00 00:00:00',
  `registeripaddr` varchar(50) NOT NULL default '',
  `cbactivation` varchar(50) NOT NULL default '',
  `banned` tinyint(4) NOT NULL default '0',
  `banneddate` datetime default NULL,
  `unbanneddate` datetime default NULL,
  `bannedby` int(11) default NULL,
  `unbannedby` int(11) default NULL,
  `bannedreason` mediumtext,
  `acceptedterms` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `apprconfbanid` (`approved`,`confirmed`,`banned`,`id`),
  KEY `avatappr_apr_conf_ban_avatar` (`avatarapproved`,`approved`,`confirmed`,`banned`,`avatar`),
  KEY `lastupdatedate` (`lastupdatedate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler`
--

LOCK TABLES `jos_comprofiler` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler` DISABLE KEYS */;
INSERT INTO `jos_comprofiler` VALUES (62,62,NULL,NULL,NULL,0,'0000-00-00 00:00:00',0,NULL,1,1,1,'0000-00-00 00:00:00','','',0,NULL,NULL,NULL,NULL,NULL,0),(63,63,'','','',0,'0000-00-00 00:00:00',0,NULL,1,1,1,'0000-00-00 00:00:00','199.244.214.30','',0,NULL,NULL,NULL,NULL,NULL,0),(64,64,'','','',0,'0000-00-00 00:00:00',0,NULL,1,1,0,'0000-00-00 00:00:00','129.93.25.78','regeceb561f095a266c92f9c65a9cb2355e0be37a33',0,NULL,NULL,NULL,NULL,NULL,0);
/*!40000 ALTER TABLE `jos_comprofiler` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_field_values`
--

DROP TABLE IF EXISTS `jos_comprofiler_field_values`;
CREATE TABLE `jos_comprofiler_field_values` (
  `fieldvalueid` int(11) NOT NULL auto_increment,
  `fieldid` int(11) NOT NULL default '0',
  `fieldtitle` varchar(255) NOT NULL default '',
  `ordering` int(11) NOT NULL default '0',
  `sys` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`fieldvalueid`),
  KEY `fieldid_ordering` (`fieldid`,`ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_field_values`
--

LOCK TABLES `jos_comprofiler_field_values` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_field_values` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_comprofiler_field_values` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_fields`
--

DROP TABLE IF EXISTS `jos_comprofiler_fields`;
CREATE TABLE `jos_comprofiler_fields` (
  `fieldid` int(11) NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  `table` varchar(50) NOT NULL default '#__comprofiler',
  `title` varchar(255) NOT NULL,
  `description` mediumtext NOT NULL,
  `type` varchar(50) NOT NULL default '',
  `maxlength` int(11) default NULL,
  `size` int(11) default NULL,
  `required` tinyint(4) default '0',
  `tabid` int(11) default NULL,
  `ordering` int(11) default NULL,
  `cols` int(11) default NULL,
  `rows` int(11) default NULL,
  `value` varchar(50) default NULL,
  `default` mediumtext,
  `published` tinyint(1) NOT NULL default '1',
  `registration` tinyint(1) NOT NULL default '0',
  `profile` tinyint(1) NOT NULL default '1',
  `readonly` tinyint(1) NOT NULL default '0',
  `calculated` tinyint(1) NOT NULL default '0',
  `sys` tinyint(4) NOT NULL default '0',
  `pluginid` int(11) default NULL,
  `params` mediumtext,
  PRIMARY KEY  (`fieldid`),
  KEY `tabid_pub_prof_order` (`tabid`,`published`,`profile`,`ordering`),
  KEY `readonly_published_tabid` (`readonly`,`published`,`tabid`),
  KEY `registration_published_order` (`registration`,`published`,`ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=54 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_fields`
--

LOCK TABLES `jos_comprofiler_fields` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_fields` DISABLE KEYS */;
INSERT INTO `jos_comprofiler_fields` VALUES (41,'name','#__users','_UE_NAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(26,'NA','#__comprofiler','_UE_ONLINESTATUS','','status',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(27,'lastvisitDate','#__users','_UE_LASTONLINE','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(28,'registerDate','#__users','_UE_MEMBERSINCE','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(29,'avatar','#__comprofiler','_UE_IMAGE','','image',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(42,'username','#__users','_UE_UNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(45,'NA','#__comprofiler','_UE_FORMATNAME','','formatname',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(46,'firstname','#__comprofiler','_UE_YOUR_FNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(47,'middlename','#__comprofiler','_UE_YOUR_MNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(48,'lastname','#__comprofiler','_UE_YOUR_LNAME','','predefined',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(49,'lastupdatedate','#__comprofiler','_UE_LASTUPDATEDON','','date',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL),(50,'email','#__users','_UE_EMAIL','','primaryemailaddress',NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,0,1,0,1,1,NULL,NULL);
/*!40000 ALTER TABLE `jos_comprofiler_fields` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_lists`
--

DROP TABLE IF EXISTS `jos_comprofiler_lists`;
CREATE TABLE `jos_comprofiler_lists` (
  `listid` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `description` mediumtext,
  `published` tinyint(1) NOT NULL default '0',
  `default` tinyint(1) NOT NULL default '0',
  `usergroupids` varchar(255) default NULL,
  `useraccessgroupid` int(9) NOT NULL default '18',
  `sortfields` varchar(255) default NULL,
  `filterfields` varchar(255) default NULL,
  `ordering` int(11) NOT NULL default '0',
  `col1title` varchar(255) default NULL,
  `col1enabled` tinyint(1) NOT NULL default '0',
  `col1fields` mediumtext,
  `col2title` varchar(255) default NULL,
  `col2enabled` tinyint(1) NOT NULL default '0',
  `col1captions` tinyint(1) NOT NULL default '0',
  `col2fields` mediumtext,
  `col2captions` tinyint(1) NOT NULL default '0',
  `col3title` varchar(255) default NULL,
  `col3enabled` tinyint(1) NOT NULL default '0',
  `col3fields` mediumtext,
  `col3captions` tinyint(1) NOT NULL default '0',
  `col4title` varchar(255) default NULL,
  `col4enabled` tinyint(1) NOT NULL default '0',
  `col4fields` mediumtext,
  `col4captions` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`listid`),
  KEY `pub_ordering` (`published`,`ordering`),
  KEY `default_published` (`default`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_lists`
--

LOCK TABLES `jos_comprofiler_lists` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_lists` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_comprofiler_lists` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_members`
--

DROP TABLE IF EXISTS `jos_comprofiler_members`;
CREATE TABLE `jos_comprofiler_members` (
  `referenceid` int(11) NOT NULL default '0',
  `memberid` int(11) NOT NULL default '0',
  `accepted` tinyint(1) NOT NULL default '1',
  `pending` tinyint(1) NOT NULL default '0',
  `membersince` date NOT NULL default '0000-00-00',
  `reason` mediumtext,
  `description` varchar(255) default NULL,
  `type` mediumtext,
  PRIMARY KEY  (`referenceid`,`memberid`),
  KEY `pamr` (`pending`,`accepted`,`memberid`,`referenceid`),
  KEY `aprm` (`accepted`,`pending`,`referenceid`,`memberid`),
  KEY `membrefid` (`memberid`,`referenceid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_members`
--

LOCK TABLES `jos_comprofiler_members` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_members` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_comprofiler_members` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_plugin`
--

DROP TABLE IF EXISTS `jos_comprofiler_plugin`;
CREATE TABLE `jos_comprofiler_plugin` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `element` varchar(100) NOT NULL default '',
  `type` varchar(100) default '',
  `folder` varchar(100) default '',
  `backend_menu` varchar(255) NOT NULL default '',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(3) NOT NULL default '0',
  `iscore` tinyint(3) NOT NULL default '0',
  `client_id` tinyint(3) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`),
  KEY `type_pub_order` (`type`,`published`,`ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=500 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_plugin`
--

LOCK TABLES `jos_comprofiler_plugin` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_plugin` DISABLE KEYS */;
INSERT INTO `jos_comprofiler_plugin` VALUES (1,'CB Core','cb.core','user','plug_cbcore','',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(2,'CB Connections','cb.connections','user','plug_cbconnections','',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(3,'Content Author','cb.authortab','user','plug_cbmamboauthortab','',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(4,'Simpleboard Forum','cb.simpleboardtab','user','plug_cbsimpleboardtab','',0,5,0,1,0,0,'0000-00-00 00:00:00',''),(5,'Mamblog Blog','cb.mamblogtab','user','plug_cbmamblogtab','',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(6,'YaNC Newsletters','yanc','user','plug_yancintegration','',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(7,'Default','default','templates','default','',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(8,'WinClassic','winclassic','templates','winclassic','',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(9,'WebFX','webfx','templates','webfx','',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(10,'OSX','osx','templates','osx','',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(11,'Luna','luna','templates','luna','',0,5,1,1,0,0,'0000-00-00 00:00:00',''),(12,'Dark','dark','templates','dark','',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(13,'Default language (English)','default_language','language','default_language','',0,-1,1,1,0,0,'0000-00-00 00:00:00',''),(14,'CB Menu','cb.menu','user','plug_cbmenu','',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(15,'PMS MyPMS and Pro','pms.mypmspro','user','plug_pms_mypmspro','',0,8,0,1,0,0,'0000-00-00 00:00:00','');
/*!40000 ALTER TABLE `jos_comprofiler_plugin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_tabs`
--

DROP TABLE IF EXISTS `jos_comprofiler_tabs`;
CREATE TABLE `jos_comprofiler_tabs` (
  `tabid` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL default '',
  `description` text,
  `ordering` int(11) NOT NULL default '0',
  `ordering_register` int(11) NOT NULL default '10',
  `width` varchar(10) NOT NULL default '.5',
  `enabled` tinyint(1) NOT NULL default '1',
  `pluginclass` varchar(255) default NULL,
  `pluginid` int(11) default NULL,
  `fields` tinyint(1) NOT NULL default '1',
  `params` mediumtext,
  `sys` tinyint(4) NOT NULL default '0',
  `displaytype` varchar(255) NOT NULL default '',
  `position` varchar(255) NOT NULL default '',
  `useraccessgroupid` int(9) NOT NULL default '-2',
  PRIMARY KEY  (`tabid`),
  KEY `enabled_position_ordering` (`enabled`,`position`,`ordering`),
  KEY `orderreg_enabled_pos_order` (`enabled`,`ordering_register`,`position`,`ordering`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_tabs`
--

LOCK TABLES `jos_comprofiler_tabs` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_tabs` DISABLE KEYS */;
INSERT INTO `jos_comprofiler_tabs` VALUES (11,'_UE_CONTACT_INFO_HEADER','',-4,10,'1',1,'getContactTab',1,1,NULL,2,'tab','cb_tabmain',-2),(12,'_UE_AUTHORTAB','',-3,10,'1',0,'getAuthorTab',3,0,NULL,1,'tab','cb_tabmain',-2),(13,'_UE_FORUMTAB','',-2,10,'1',0,'getForumTab',4,0,NULL,1,'tab','cb_tabmain',-2),(14,'_UE_BLOGTAB','',-1,10,'1',0,'getBlogTab',5,0,NULL,1,'tab','cb_tabmain',-2),(15,'_UE_CONNECTION','',99,10,'1',0,'getConnectionTab',2,0,NULL,1,'tab','cb_tabmain',-2),(16,'_UE_NEWSLETTER_HEADER','_UE_NEWSLETTER_INTRODCUTION',99,10,'1',0,'getNewslettersTab',6,0,NULL,1,'tab','cb_tabmain',-2),(17,'_UE_MENU','',-10,10,'1',1,'getMenuTab',14,0,NULL,1,'html','cb_head',-2),(18,'_UE_CONNECTIONPATHS','',-9,10,'1',1,'getConnectionPathsTab',2,0,NULL,1,'html','cb_head',-2),(19,'_UE_PROFILE_PAGE_TITLE','',-8,10,'1',1,'getPageTitleTab',1,0,NULL,1,'html','cb_head',-2),(20,'_UE_PORTRAIT','',-7,10,'1',1,'getPortraitTab',1,0,NULL,1,'html','cb_middle',-2),(21,'_UE_USER_STATUS','',-6,10,'.5',1,'getStatusTab',14,0,NULL,1,'html','cb_right',-2),(22,'_UE_PMSTAB','',-5,10,'.5',0,'getmypmsproTab',15,0,NULL,1,'html','cb_right',-2);
/*!40000 ALTER TABLE `jos_comprofiler_tabs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_userreports`
--

DROP TABLE IF EXISTS `jos_comprofiler_userreports`;
CREATE TABLE `jos_comprofiler_userreports` (
  `reportid` int(11) NOT NULL auto_increment,
  `reporteduser` int(11) NOT NULL default '0',
  `reportedbyuser` int(11) NOT NULL default '0',
  `reportedondate` date NOT NULL default '0000-00-00',
  `reportexplaination` text NOT NULL,
  `reportedstatus` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`reportid`),
  KEY `status_user_date` (`reportedstatus`,`reporteduser`,`reportedondate`),
  KEY `reportedbyuser_ondate` (`reportedbyuser`,`reportedondate`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_userreports`
--

LOCK TABLES `jos_comprofiler_userreports` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_userreports` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_comprofiler_userreports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_comprofiler_views`
--

DROP TABLE IF EXISTS `jos_comprofiler_views`;
CREATE TABLE `jos_comprofiler_views` (
  `viewer_id` int(11) NOT NULL default '0',
  `profile_id` int(11) NOT NULL default '0',
  `lastip` varchar(50) NOT NULL default '',
  `lastview` datetime NOT NULL default '0000-00-00 00:00:00',
  `viewscount` int(11) NOT NULL default '0',
  `vote` tinyint(3) default NULL,
  `lastvote` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`viewer_id`,`profile_id`,`lastip`),
  KEY `lastview` (`lastview`),
  KEY `profile_id_lastview` (`profile_id`,`lastview`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_comprofiler_views`
--

LOCK TABLES `jos_comprofiler_views` WRITE;
/*!40000 ALTER TABLE `jos_comprofiler_views` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_comprofiler_views` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_contact_details`
--

DROP TABLE IF EXISTS `jos_contact_details`;
CREATE TABLE `jos_contact_details` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `con_position` varchar(255) default NULL,
  `address` text,
  `suburb` varchar(100) default NULL,
  `state` varchar(100) default NULL,
  `country` varchar(100) default NULL,
  `postcode` varchar(100) default NULL,
  `telephone` varchar(255) default NULL,
  `fax` varchar(255) default NULL,
  `misc` mediumtext,
  `image` varchar(255) default NULL,
  `imagepos` varchar(20) default NULL,
  `email_to` varchar(255) default NULL,
  `default_con` tinyint(1) unsigned NOT NULL default '0',
  `published` tinyint(1) unsigned NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL default '0',
  `catid` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `mobile` varchar(255) NOT NULL default '',
  `webpage` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_contact_details`
--

LOCK TABLES `jos_contact_details` WRITE;
/*!40000 ALTER TABLE `jos_contact_details` DISABLE KEYS */;
INSERT INTO `jos_contact_details` VALUES (1,'Gospel Music Omaha','gmo','','','','','','','402-714-9676','','','',NULL,'GMO@qmgonline.net',0,1,0,'0000-00-00 00:00:00',1,'show_name=1\nshow_position=0\nshow_email=0\nshow_street_address=0\nshow_suburb=0\nshow_state=0\nshow_postcode=0\nshow_country=0\nshow_telephone=1\nshow_mobile=0\nshow_fax=0\nshow_webpage=1\nshow_misc=0\nshow_image=0\nallow_vcard=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_email_form=1\nemail_description=\nshow_email_copy=1\nbanned_email=\nbanned_subject=\nbanned_text=',0,2,0,'','http://www.gospelmusicomaha.com');
/*!40000 ALTER TABLE `jos_contact_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_content`
--

DROP TABLE IF EXISTS `jos_content`;
CREATE TABLE `jos_content` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `title_alias` varchar(255) NOT NULL default '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL default '0',
  `sectionid` int(11) unsigned NOT NULL default '0',
  `mask` int(11) unsigned NOT NULL default '0',
  `catid` int(11) unsigned NOT NULL default '0',
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL default '0',
  `created_by_alias` varchar(255) NOT NULL default '',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified_by` int(11) unsigned NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `attribs` text NOT NULL,
  `version` int(11) unsigned NOT NULL default '1',
  `parentid` int(11) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(11) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0',
  `metadata` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_section` (`sectionid`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_content`
--

LOCK TABLES `jos_content` WRITE;
/*!40000 ALTER TABLE `jos_content` DISABLE KEYS */;
INSERT INTO `jos_content` VALUES (1,'XTC Client','xtc-client','','{loadposition content_xtcclient}','',0,0,0,0,'2008-07-08 21:46:21',62,'','2008-07-08 21:47:11',62,0,'0000-00-00 00:00:00','2008-07-08 21:46:21','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',2,0,3,'','',0,0,'robots=\nauthor='),(2,'Welcome to GospelMusicOmaha','welcome','','<div align=\"center\"><br /><!--url\'s used in the movie--><a href=\"http://www.flashmo.com\"></a><!--text used in the movie--><!-- saved from url=(0013)about:internet --><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0\" id=\"flashmo_112_news_tab\" name=\"flashmo_112_news_tab\" width=\"800\" height=\"400\" align=\"middle\"><param name=\"id\" value=\"flashmo_112_news_tab\" /><param name=\"name\" value=\"flashmo_112_news_tab\" /><param name=\"width\" value=\"800\" /><param name=\"height\" value=\"400\" /><param name=\"bgcolor\" value=\"#FFFFFF\" /><param name=\"align\" value=\"middle\" /><param name=\"allowscriptaccess\" value=\"sameDomain\" /><param name=\"quality\" value=\"high\" /><param name=\"src\" value=\"flashmo_112_news_tab.swf\" /><embed type=\"application/x-shockwave-flash\" id=\"flashmo_112_news_tab\" name=\"flashmo_112_news_tab\" width=\"800\" height=\"400\" bgcolor=\"#FFFFFF\" align=\"middle\" allowscriptaccess=\"sameDomain\" quality=\"high\" src=\"flashmo_112_news_tab.swf\"></embed></object><br /><br /><span class=\"style1\"><a href=\"http://www.flashmo.com\">Free Flash Templates</a></span></div>','',0,0,0,0,'2008-07-29 20:35:54',62,'','0000-00-00 00:00:00',0,0,'0000-00-00 00:00:00','2008-07-29 20:35:54','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',1,0,2,'','',0,0,'robots=\nauthor='),(3,'Welcome to GospelMusicOmaha','welcome','','<h1 align=\"center\"><br /><!--url\'s used in the movie--></h1><div><object classid=\"clsid:d27cdb6e-ae6d-11cf-96b8-444553540000\" codebase=\"http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0\" width=\"425\" height=\"344\"><param name=\"width\" value=\"425\" /><param name=\"height\" value=\"344\" /><param name=\"allowfullscreen\" value=\"true\" /><param name=\"src\" value=\"http://www.youtube.com/v/Ird_NgKHmKY&hl=en&fs=1\" /><embed type=\"application/x-shockwave-flash\" width=\"425\" height=\"344\" allowfullscreen=\"true\" src=\"http://www.youtube.com/v/Ird_NgKHmKY&hl=en&fs=1\"></embed></object></div><h1 align=\"center\">Please bear with us, as our site is under construction to bring you the best gospel music experience!<!--text used in the movie--><!-- saved from url=(0013)about:internet --></h1>','',1,0,0,0,'2008-07-29 20:35:54',62,'','2008-10-03 22:23:13',62,0,'0000-00-00 00:00:00','2008-07-29 20:35:54','0000-00-00 00:00:00','','','show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',7,0,1,'','',0,5,'robots=\nauthor=');
/*!40000 ALTER TABLE `jos_content` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_content_frontpage`
--

DROP TABLE IF EXISTS `jos_content_frontpage`;
CREATE TABLE `jos_content_frontpage` (
  `content_id` int(11) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  PRIMARY KEY  (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_content_frontpage`
--

LOCK TABLES `jos_content_frontpage` WRITE;
/*!40000 ALTER TABLE `jos_content_frontpage` DISABLE KEYS */;
INSERT INTO `jos_content_frontpage` VALUES (1,2),(3,1);
/*!40000 ALTER TABLE `jos_content_frontpage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_content_rating`
--

DROP TABLE IF EXISTS `jos_content_rating`;
CREATE TABLE `jos_content_rating` (
  `content_id` int(11) NOT NULL default '0',
  `rating_sum` int(11) unsigned NOT NULL default '0',
  `rating_count` int(11) unsigned NOT NULL default '0',
  `lastip` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_content_rating`
--

LOCK TABLES `jos_content_rating` WRITE;
/*!40000 ALTER TABLE `jos_content_rating` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_content_rating` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_acl_aro`
--

DROP TABLE IF EXISTS `jos_core_acl_aro`;
CREATE TABLE `jos_core_acl_aro` (
  `id` int(11) NOT NULL auto_increment,
  `section_value` varchar(240) NOT NULL default '0',
  `value` varchar(240) NOT NULL default '',
  `order_value` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `hidden` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
  KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_acl_aro`
--

LOCK TABLES `jos_core_acl_aro` WRITE;
/*!40000 ALTER TABLE `jos_core_acl_aro` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0),(11,'users','63',0,'Tracy',0),(12,'users','64',0,'Jennifer Young',0);
/*!40000 ALTER TABLE `jos_core_acl_aro` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_acl_aro_groups`
--

DROP TABLE IF EXISTS `jos_core_acl_aro_groups`;
CREATE TABLE `jos_core_acl_aro_groups` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `name` varchar(255) NOT NULL default '',
  `lft` int(11) NOT NULL default '0',
  `rgt` int(11) NOT NULL default '0',
  `value` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
  KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_acl_aro_groups`
--

LOCK TABLES `jos_core_acl_aro_groups` WRITE;
/*!40000 ALTER TABLE `jos_core_acl_aro_groups` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro_groups` VALUES (17,0,'ROOT',1,22,'ROOT'),(28,17,'USERS',2,21,'USERS'),(29,28,'Public Frontend',3,12,'Public Frontend'),(18,29,'Registered',4,11,'Registered'),(19,18,'Author',5,10,'Author'),(20,19,'Editor',6,9,'Editor'),(21,20,'Publisher',7,8,'Publisher'),(30,28,'Public Backend',13,20,'Public Backend'),(23,30,'Manager',14,19,'Manager'),(24,23,'Administrator',15,18,'Administrator'),(25,24,'Super Administrator',16,17,'Super Administrator');
/*!40000 ALTER TABLE `jos_core_acl_aro_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_acl_aro_map`
--

DROP TABLE IF EXISTS `jos_core_acl_aro_map`;
CREATE TABLE `jos_core_acl_aro_map` (
  `acl_id` int(11) NOT NULL default '0',
  `section_value` varchar(230) NOT NULL default '0',
  `value` varchar(100) NOT NULL,
  PRIMARY KEY  (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_acl_aro_map`
--

LOCK TABLES `jos_core_acl_aro_map` WRITE;
/*!40000 ALTER TABLE `jos_core_acl_aro_map` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_acl_aro_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_acl_aro_sections`
--

DROP TABLE IF EXISTS `jos_core_acl_aro_sections`;
CREATE TABLE `jos_core_acl_aro_sections` (
  `id` int(11) NOT NULL auto_increment,
  `value` varchar(230) NOT NULL default '',
  `order_value` int(11) NOT NULL default '0',
  `name` varchar(230) NOT NULL default '',
  `hidden` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
  KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_acl_aro_sections`
--

LOCK TABLES `jos_core_acl_aro_sections` WRITE;
/*!40000 ALTER TABLE `jos_core_acl_aro_sections` DISABLE KEYS */;
INSERT INTO `jos_core_acl_aro_sections` VALUES (10,'users',1,'Users',0);
/*!40000 ALTER TABLE `jos_core_acl_aro_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_acl_groups_aro_map`
--

DROP TABLE IF EXISTS `jos_core_acl_groups_aro_map`;
CREATE TABLE `jos_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL default '0',
  `section_value` varchar(240) NOT NULL default '',
  `aro_id` int(11) NOT NULL default '0',
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--

LOCK TABLES `jos_core_acl_groups_aro_map` WRITE;
/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` DISABLE KEYS */;
INSERT INTO `jos_core_acl_groups_aro_map` VALUES (18,'',11),(18,'',12),(25,'',10);
/*!40000 ALTER TABLE `jos_core_acl_groups_aro_map` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_log_items`
--

DROP TABLE IF EXISTS `jos_core_log_items`;
CREATE TABLE `jos_core_log_items` (
  `time_stamp` date NOT NULL default '0000-00-00',
  `item_table` varchar(50) NOT NULL default '',
  `item_id` int(11) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_log_items`
--

LOCK TABLES `jos_core_log_items` WRITE;
/*!40000 ALTER TABLE `jos_core_log_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_log_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_core_log_searches`
--

DROP TABLE IF EXISTS `jos_core_log_searches`;
CREATE TABLE `jos_core_log_searches` (
  `search_term` varchar(128) NOT NULL default '',
  `hits` int(11) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_core_log_searches`
--

LOCK TABLES `jos_core_log_searches` WRITE;
/*!40000 ALTER TABLE `jos_core_log_searches` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_core_log_searches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_groups`
--

DROP TABLE IF EXISTS `jos_groups`;
CREATE TABLE `jos_groups` (
  `id` tinyint(3) unsigned NOT NULL default '0',
  `name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_groups`
--

LOCK TABLES `jos_groups` WRITE;
/*!40000 ALTER TABLE `jos_groups` DISABLE KEYS */;
INSERT INTO `jos_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special');
/*!40000 ALTER TABLE `jos_groups` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_jp_def`
--

DROP TABLE IF EXISTS `jos_jp_def`;
CREATE TABLE `jos_jp_def` (
  `def_id` int(10) unsigned NOT NULL auto_increment,
  `directory` varchar(255) NOT NULL,
  PRIMARY KEY  (`def_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_jp_def`
--

LOCK TABLES `jos_jp_def` WRITE;
/*!40000 ALTER TABLE `jos_jp_def` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_jp_def` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_jp_packvars`
--

DROP TABLE IF EXISTS `jos_jp_packvars`;
CREATE TABLE `jos_jp_packvars` (
  `id` int(11) NOT NULL auto_increment,
  `key` varchar(255) NOT NULL,
  `value` varchar(255) default NULL,
  `value2` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3000 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_jp_packvars`
--

LOCK TABLES `jos_jp_packvars` WRITE;
/*!40000 ALTER TABLE `jos_jp_packvars` DISABLE KEYS */;
INSERT INTO `jos_jp_packvars` VALUES (2998,'CUBEArray',NULL,'a:6:{s:6:\"HasRun\";i:1;s:6:\"Domain\";s:6:\"finale\";s:4:\"Step\";s:0:\"\";s:7:\"Substep\";s:0:\"\";s:5:\"Error\";s:0:\"\";s:9:\"Timestamp\";d:1223066202.208281993865966796875;}'),(2999,'CUBEObject',NULL,'O:5:\"CCUBE\":7:{s:14:\"_currentDomain\";s:6:\"finale\";s:12:\"_currentStep\";s:0:\"\";s:15:\"_currentSubstep\";s:0:\"\";s:14:\"_currentObject\";N;s:11:\"_isFinished\";b:0;s:6:\"_Error\";s:0:\"\";s:11:\"_OnlyDBMode\";b:0;}');
/*!40000 ALTER TABLE `jos_jp_packvars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_livingword`
--

DROP TABLE IF EXISTS `jos_livingword`;
CREATE TABLE `jos_livingword` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(11) NOT NULL default '0',
  `bibleplan` varchar(50) NOT NULL default '',
  `bibleversion` int(11) NOT NULL default '0',
  `audioversion` varchar(50) NOT NULL default '',
  `email` int(11) NOT NULL default '0',
  `emailsent` int(11) NOT NULL default '0',
  `readstate` int(11) NOT NULL default '0',
  `startdate` datetime default '0000-00-00 00:00:00',
  `dateoffset` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_livingword`
--

LOCK TABLES `jos_livingword` WRITE;
/*!40000 ALTER TABLE `jos_livingword` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_livingword` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_meeboroom`
--

DROP TABLE IF EXISTS `jos_meeboroom`;
CREATE TABLE `jos_meeboroom` (
  `html_code` blob,
  `width` varchar(3) NOT NULL default '430',
  `height` varchar(3) NOT NULL default '300',
  `roomid` varchar(15) NOT NULL default 'fSSPjcEmpl'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_meeboroom`
--

LOCK TABLES `jos_meeboroom` WRITE;
/*!40000 ALTER TABLE `jos_meeboroom` DISABLE KEYS */;
INSERT INTO `jos_meeboroom` VALUES ('new','430','300','WoUjPuQBlD');
/*!40000 ALTER TABLE `jos_meeboroom` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_menu`
--

DROP TABLE IF EXISTS `jos_menu`;
CREATE TABLE `jos_menu` (
  `id` int(11) NOT NULL auto_increment,
  `menutype` varchar(75) default NULL,
  `name` varchar(255) default NULL,
  `alias` varchar(255) NOT NULL default '',
  `link` text,
  `type` varchar(50) NOT NULL default '',
  `published` tinyint(1) NOT NULL default '0',
  `parent` int(11) unsigned NOT NULL default '0',
  `componentid` int(11) unsigned NOT NULL default '0',
  `sublevel` int(11) default '0',
  `ordering` int(11) default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL default '0',
  `browserNav` tinyint(4) default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `utaccess` tinyint(3) unsigned NOT NULL default '0',
  `params` text NOT NULL,
  `lft` int(11) unsigned NOT NULL default '0',
  `rgt` int(11) unsigned NOT NULL default '0',
  `home` int(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_menu`
--

LOCK TABLES `jos_menu` WRITE;
/*!40000 ALTER TABLE `jos_menu` DISABLE KEYS */;
INSERT INTO `jos_menu` VALUES (1,'mainmenu','Home','home','index.php?option=com_content&view=frontpage','component',1,0,20,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,1),(2,'biblestudies','Single Media File Layout','single-media-file-layout','index.php?option=com_biblestudy&view=mediaplayer','component',1,0,58,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'allow_deletes=\ndrop_tables=\nlabel_teacher=Latest Messages\npage_title=\npage_width=100%\nshow_page_title=1\npage_image=components/com_biblestudy/images/openbible.png\npimagew=48\npimageh=48\nshow_page_image=\ncolor1=#DDDCEF\ncolor2=#FFFFFF\ndate_format=\ndefault_order=\nshow_full_text=\nshow_pdf_text=\nimageh=24\nimagew=24\ntext_image=components/com_biblestudy/images/textfile24.png\nshow_verses=\nshow_col_1=\nshow_col_2=\nshow_col_3=\nshow_col_4=\nshow_media=\nmedia_width=30\nshow_filesize=\nduration_type=\nshow_teacher_list=\nteacherimage=\nteacherw=\nteacherh=\nteachername=\nwidthcol1=75\nwidthcol2=100\nwidthcol3=250\nwidthcol4=250\nposition_1=\nfontp1=style=\"font-size:0.85em;\"\nposition_2=\nfontp2=style=\"font-size:0.85em;\"\nposition_3=\nfontp3=style=\"font-size:0.85em;\"\nposition_4=\nfontp4=style=\"font-size:0.85em;\"\nposition_5=\nfontp5=style=\"font-size:0.85em;\"\nposition_6=\nfontp6=style=\"font-size:0.85em;\"\nposition_7=\nfontp7=style=\"font-size:0.85em;\"\nposition_8=\nfontp8=style=\"font-size:0.85em;\"\nposition_9=\nfontp9=style=\"font-size:0.85em;\"\nposition_10=\nfontp10=style=\"font-size:0.85em;\"\nposition_11=\nfontp11=style=\"font-size:0.85em;\"\nposition_12=\nfontp12=style=\"font-size:0.85em;\"\npageclass_sfx=\ntooltip=\ndetails_text=Study Details\nshow_book_search=\nshow_teacher_search=\nshow_series_search=\nshow_type_search=\nshow_year_search=\nshow_order_search=\nshow_topic_search=\nshow_title_view=\nshow_verses_view=\nstyle_title_view=style=\"font-size:1.0em;\"\nshow_teacher_view=\nshow_picture_view=\nshow_date_view=\nshow_series_view=\nshow_description_view=\nshow_studynumber_view=\nshow_text_view=\nshow_media_view=\nshow_passage_view=\nlink_text=Return to Studies List\nshow_print_view=\nshow_pdf_view=\nshow_duration=\npodcast_title=\nteacher_title=Our Teachers\nstudies=5\nshow_teacher_studies=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(3,'biblestudies','Studies List Layout','studies-list-layout','index.php?option=com_biblestudy&view=studieslist','component',1,0,58,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'allow_deletes=\ndrop_tables=\nlabel_teacher=Latest Messages\npage_title=\npage_width=100%\nshow_page_title=1\npage_image=components/com_biblestudy/images/openbible.png\npimagew=48\npimageh=48\nshow_page_image=\ncolor1=#DDDCEF\ncolor2=#FFFFFF\ndate_format=\ndefault_order=\nshow_full_text=\nshow_pdf_text=\nimageh=24\nimagew=24\ntext_image=components/com_biblestudy/images/textfile24.png\nshow_verses=\nshow_col_1=\nshow_col_2=\nshow_col_3=\nshow_col_4=\nshow_media=\nmedia_width=30\nshow_filesize=\nduration_type=\nshow_teacher_list=\nteacherimage=\nteacherw=\nteacherh=\nteachername=\nwidthcol1=75\nwidthcol2=100\nwidthcol3=250\nwidthcol4=250\nposition_1=\nfontp1=style=\"font-size:0.85em;\"\nposition_2=\nfontp2=style=\"font-size:0.85em;\"\nposition_3=\nfontp3=style=\"font-size:0.85em;\"\nposition_4=\nfontp4=style=\"font-size:0.85em;\"\nposition_5=\nfontp5=style=\"font-size:0.85em;\"\nposition_6=\nfontp6=style=\"font-size:0.85em;\"\nposition_7=\nfontp7=style=\"font-size:0.85em;\"\nposition_8=\nfontp8=style=\"font-size:0.85em;\"\nposition_9=\nfontp9=style=\"font-size:0.85em;\"\nposition_10=\nfontp10=style=\"font-size:0.85em;\"\nposition_11=\nfontp11=style=\"font-size:0.85em;\"\nposition_12=\nfontp12=style=\"font-size:0.85em;\"\npageclass_sfx=\ntooltip=\ndetails_text=Study Details\nshow_book_search=\nshow_teacher_search=\nshow_series_search=\nshow_type_search=\nshow_year_search=\nshow_order_search=\nshow_topic_search=\nshow_title_view=\nshow_verses_view=\nstyle_title_view=style=\"font-size:1.0em;\"\nshow_teacher_view=\nshow_picture_view=\nshow_date_view=\nshow_series_view=\nshow_description_view=\nshow_studynumber_view=\nshow_text_view=\nshow_media_view=\nshow_passage_view=\nlink_text=Return to Studies List\nshow_print_view=\nshow_pdf_view=\nshow_duration=\npodcast_title=\nteacher_title=Our Teachers\nstudies=5\nshow_teacher_studies=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(4,'biblestudies','Single Study Layout','single-study-layout','index.php?option=com_biblestudy&view=studydetails','component',1,0,58,0,3,62,'2008-10-03 21:01:00',0,0,0,0,'allow_deletes=\ndrop_tables=\nlabel_teacher=Latest Messages\npage_title=\npage_width=100%\nshow_page_title=1\npage_image=components/com_biblestudy/images/openbible.png\npimagew=48\npimageh=48\nshow_page_image=\ncolor1=#DDDCEF\ncolor2=#FFFFFF\ndate_format=\ndefault_order=\nshow_full_text=\nshow_pdf_text=\nimageh=24\nimagew=24\ntext_image=components/com_biblestudy/images/textfile24.png\nshow_verses=\nshow_col_1=\nshow_col_2=\nshow_col_3=\nshow_col_4=\nshow_media=\nmedia_width=30\nshow_filesize=\nduration_type=\nshow_teacher_list=\nteacherimage=\nteacherw=\nteacherh=\nteachername=\nwidthcol1=75\nwidthcol2=100\nwidthcol3=250\nwidthcol4=250\nposition_1=\nfontp1=style=\"font-size:0.85em;\"\nposition_2=\nfontp2=style=\"font-size:0.85em;\"\nposition_3=\nfontp3=style=\"font-size:0.85em;\"\nposition_4=\nfontp4=style=\"font-size:0.85em;\"\nposition_5=\nfontp5=style=\"font-size:0.85em;\"\nposition_6=\nfontp6=style=\"font-size:0.85em;\"\nposition_7=\nfontp7=style=\"font-size:0.85em;\"\nposition_8=\nfontp8=style=\"font-size:0.85em;\"\nposition_9=\nfontp9=style=\"font-size:0.85em;\"\nposition_10=\nfontp10=style=\"font-size:0.85em;\"\nposition_11=\nfontp11=style=\"font-size:0.85em;\"\nposition_12=\nfontp12=style=\"font-size:0.85em;\"\npageclass_sfx=\ntooltip=\ndetails_text=Study Details\nshow_book_search=\nshow_teacher_search=\nshow_series_search=\nshow_type_search=\nshow_year_search=\nshow_order_search=\nshow_topic_search=\nshow_title_view=\nshow_verses_view=\nstyle_title_view=style=\"font-size:1.0em;\"\nshow_teacher_view=\nshow_picture_view=\nshow_date_view=\nshow_series_view=\nshow_description_view=\nshow_studynumber_view=\nshow_text_view=\nshow_media_view=\nshow_passage_view=\nlink_text=Return to Studies List\nshow_print_view=\nshow_pdf_view=\nshow_duration=\npodcast_title=\nteacher_title=Our Teachers\nstudies=5\nshow_teacher_studies=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(5,'biblestudies','Single Teacher Layout','single-teacher-layout','index.php?option=com_biblestudy&view=teacherdisplay','component',1,0,58,0,4,0,'0000-00-00 00:00:00',0,0,0,0,'allow_deletes=\ndrop_tables=\nlabel_teacher=Latest Messages\npage_title=\npage_width=100%\nshow_page_title=1\npage_image=components/com_biblestudy/images/openbible.png\npimagew=48\npimageh=48\nshow_page_image=\ncolor1=#DDDCEF\ncolor2=#FFFFFF\ndate_format=\ndefault_order=\nshow_full_text=\nshow_pdf_text=\nimageh=24\nimagew=24\ntext_image=components/com_biblestudy/images/textfile24.png\nshow_verses=\nshow_col_1=\nshow_col_2=\nshow_col_3=\nshow_col_4=\nshow_media=\nmedia_width=30\nshow_filesize=\nduration_type=\nshow_teacher_list=\nteacherimage=\nteacherw=\nteacherh=\nteachername=\nwidthcol1=75\nwidthcol2=100\nwidthcol3=250\nwidthcol4=250\nposition_1=\nfontp1=style=\"font-size:0.85em;\"\nposition_2=\nfontp2=style=\"font-size:0.85em;\"\nposition_3=\nfontp3=style=\"font-size:0.85em;\"\nposition_4=\nfontp4=style=\"font-size:0.85em;\"\nposition_5=\nfontp5=style=\"font-size:0.85em;\"\nposition_6=\nfontp6=style=\"font-size:0.85em;\"\nposition_7=\nfontp7=style=\"font-size:0.85em;\"\nposition_8=\nfontp8=style=\"font-size:0.85em;\"\nposition_9=\nfontp9=style=\"font-size:0.85em;\"\nposition_10=\nfontp10=style=\"font-size:0.85em;\"\nposition_11=\nfontp11=style=\"font-size:0.85em;\"\nposition_12=\nfontp12=style=\"font-size:0.85em;\"\npageclass_sfx=\ntooltip=\ndetails_text=Study Details\nshow_book_search=\nshow_teacher_search=\nshow_series_search=\nshow_type_search=\nshow_year_search=\nshow_order_search=\nshow_topic_search=\nshow_title_view=\nshow_verses_view=\nstyle_title_view=style=\"font-size:1.0em;\"\nshow_teacher_view=\nshow_picture_view=\nshow_date_view=\nshow_series_view=\nshow_description_view=\nshow_studynumber_view=\nshow_text_view=\nshow_media_view=\nshow_passage_view=\nlink_text=Return to Studies List\nshow_print_view=\nshow_pdf_view=\nshow_duration=\npodcast_title=\nteacher_title=Our Teachers\nstudies=5\nshow_teacher_studies=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(6,'biblestudies','Teachers List Layout','teachers-list-layout','index.php?option=com_biblestudy&view=teacherlist','component',1,0,58,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'allow_deletes=\ndrop_tables=\nlabel_teacher=Latest Messages\npage_title=\npage_width=100%\nshow_page_title=1\npage_image=components/com_biblestudy/images/openbible.png\npimagew=48\npimageh=48\nshow_page_image=\ncolor1=#DDDCEF\ncolor2=#FFFFFF\ndate_format=\ndefault_order=\nshow_full_text=\nshow_pdf_text=\nimageh=24\nimagew=24\ntext_image=components/com_biblestudy/images/textfile24.png\nshow_verses=\nshow_col_1=\nshow_col_2=\nshow_col_3=\nshow_col_4=\nshow_media=\nmedia_width=30\nshow_filesize=\nduration_type=\nshow_teacher_list=\nteacherimage=\nteacherw=\nteacherh=\nteachername=\nwidthcol1=75\nwidthcol2=100\nwidthcol3=250\nwidthcol4=250\nposition_1=\nfontp1=style=\"font-size:0.85em;\"\nposition_2=\nfontp2=style=\"font-size:0.85em;\"\nposition_3=\nfontp3=style=\"font-size:0.85em;\"\nposition_4=\nfontp4=style=\"font-size:0.85em;\"\nposition_5=\nfontp5=style=\"font-size:0.85em;\"\nposition_6=\nfontp6=style=\"font-size:0.85em;\"\nposition_7=\nfontp7=style=\"font-size:0.85em;\"\nposition_8=\nfontp8=style=\"font-size:0.85em;\"\nposition_9=\nfontp9=style=\"font-size:0.85em;\"\nposition_10=\nfontp10=style=\"font-size:0.85em;\"\nposition_11=\nfontp11=style=\"font-size:0.85em;\"\nposition_12=\nfontp12=style=\"font-size:0.85em;\"\npageclass_sfx=\ntooltip=\ndetails_text=Study Details\nshow_book_search=\nshow_teacher_search=\nshow_series_search=\nshow_type_search=\nshow_year_search=\nshow_order_search=\nshow_topic_search=\nshow_title_view=\nshow_verses_view=\nstyle_title_view=style=\"font-size:1.0em;\"\nshow_teacher_view=\nshow_picture_view=\nshow_date_view=\nshow_series_view=\nshow_description_view=\nshow_studynumber_view=\nshow_text_view=\nshow_media_view=\nshow_passage_view=\nlink_text=Return to Studies List\nshow_print_view=\nshow_pdf_view=\nshow_duration=\npodcast_title=\nteacher_title=Our Teachers\nstudies=5\nshow_teacher_studies=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(7,'mainmenu','Separator','separator','','separator',-2,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\n\n',0,0,0),(8,'mainmenu','Live Chat','blastchatc','index.php?option=com_blastchatc','component',0,0,80,0,6,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(9,'mainmenu','Separator','separator','','separator',0,0,0,0,7,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\n\n',0,0,0),(10,'usermenu','Cb Picture Admin','cb-picture-admin','index.php?option=com_cbpictureadmin','component',1,0,45,0,2,0,'0000-00-00 00:00:00',0,0,2,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(11,'usermenu','CB Mailing','cb-mailing','index.php?option=com_cbmailing','component',1,0,42,0,1,0,'0000-00-00 00:00:00',0,0,2,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(12,'usermenu','Update Your Profile','comprofiler','index.php?option=com_comprofiler','component',1,0,34,0,3,0,'0000-00-00 00:00:00',0,0,1,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(13,'mainmenu','Separator','separator','','separator',-2,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\n\n',0,0,0),(14,'mainmenu','LivingWord','livingword','index.php?option=com_livingword','component',1,0,55,0,8,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(15,'mainmenu','SermonSpeaker','sermonspeaker','index.php?option=com_sermonspeaker','component',1,0,72,0,9,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(16,'mainmenu','Live Chat','vivociti-meebo-chat-room-15','index.php?option=com_vivocitimeebochatroom15','component',0,0,85,0,10,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(17,'mainmenu','Gospel Videos!','seyret','index.php?option=com_seyret','component',0,0,86,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'page_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(18,'mainmenu','Request A Song!','request','index.php?option=com_wrapper&view=wrapper','component',-2,0,17,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'url=http://www.jaxtr.com/user/contactpage.jsp?un=gospelmusicomaha\nscrolling=auto\nwidth=100%\nheight=500\nheight_auto=0\nadd_scheme=1\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0),(19,'biblestudies','Bible Studies','bible-studies','','separator',-2,0,0,0,0,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\n\n',0,0,0),(20,'topmenu','Contact Us','contact','index.php?option=com_contact&view=contact&id=1','component',1,0,7,0,1,0,'0000-00-00 00:00:00',0,0,0,0,'show_contact_list=0\nshow_category_crumb=1\ncontact_icons=\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_headings=\nshow_position=\nshow_email=\nshow_telephone=\nshow_mobile=\nshow_fax=\nallow_vcard=\nbanned_email=\nbanned_subject=\nbanned_text=\nvalidate_session=\ncustom_reply=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',0,0,0);
/*!40000 ALTER TABLE `jos_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_menu_types`
--

DROP TABLE IF EXISTS `jos_menu_types`;
CREATE TABLE `jos_menu_types` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `menutype` varchar(75) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_menu_types`
--

LOCK TABLES `jos_menu_types` WRITE;
/*!40000 ALTER TABLE `jos_menu_types` DISABLE KEYS */;
INSERT INTO `jos_menu_types` VALUES (1,'mainmenu','Main Menu','The main menu for the site'),(2,'biblestudies','Bible Studies','Bible Studies'),(3,'usermenu','User Menu','User Menu'),(4,'topmenu','Top Menu','Top Menu');
/*!40000 ALTER TABLE `jos_menu_types` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_messages`
--

DROP TABLE IF EXISTS `jos_messages`;
CREATE TABLE `jos_messages` (
  `message_id` int(10) unsigned NOT NULL auto_increment,
  `user_id_from` int(10) unsigned NOT NULL default '0',
  `user_id_to` int(10) unsigned NOT NULL default '0',
  `folder_id` int(10) unsigned NOT NULL default '0',
  `date_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `state` int(11) NOT NULL default '0',
  `priority` int(1) unsigned NOT NULL default '0',
  `subject` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY  (`message_id`),
  KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_messages`
--

LOCK TABLES `jos_messages` WRITE;
/*!40000 ALTER TABLE `jos_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_messages_cfg`
--

DROP TABLE IF EXISTS `jos_messages_cfg`;
CREATE TABLE `jos_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL default '0',
  `cfg_name` varchar(100) NOT NULL default '',
  `cfg_value` varchar(255) NOT NULL default '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_messages_cfg`
--

LOCK TABLES `jos_messages_cfg` WRITE;
/*!40000 ALTER TABLE `jos_messages_cfg` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_messages_cfg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_migration_backlinks`
--

DROP TABLE IF EXISTS `jos_migration_backlinks`;
CREATE TABLE `jos_migration_backlinks` (
  `itemid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` text NOT NULL,
  `sefurl` text NOT NULL,
  `newurl` text NOT NULL,
  PRIMARY KEY  (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_migration_backlinks`
--

LOCK TABLES `jos_migration_backlinks` WRITE;
/*!40000 ALTER TABLE `jos_migration_backlinks` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_migration_backlinks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_modules`
--

DROP TABLE IF EXISTS `jos_modules`;
CREATE TABLE `jos_modules` (
  `id` int(11) NOT NULL auto_increment,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `ordering` int(11) NOT NULL default '0',
  `position` varchar(50) default NULL,
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `module` varchar(50) default NULL,
  `numnews` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `showtitle` tinyint(3) unsigned NOT NULL default '1',
  `params` text NOT NULL,
  `iscore` tinyint(4) NOT NULL default '0',
  `client_id` tinyint(4) NOT NULL default '0',
  `control` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_modules`
--

LOCK TABLES `jos_modules` WRITE;
/*!40000 ALTER TABLE `jos_modules` DISABLE KEYS */;
INSERT INTO `jos_modules` VALUES (1,'Main Menu','',3,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',1,0,''),(2,'Login','',1,'login',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,1,''),(3,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,2,1,'',0,1,''),(4,'Recent added Articles','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,2,1,'ordering=c_dsc\nuser_id=0\ncache=0\n\n',0,1,''),(5,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,2,1,'',0,1,''),(6,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,2,1,'',1,1,''),(7,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,2,1,'',1,1,''),(8,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,2,1,'',1,1,''),(9,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,2,1,'',1,1,''),(10,'Logged in Users','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,2,1,'',0,1,''),(11,'Footer','',0,'footer',0,'0000-00-00 00:00:00',1,'mod_footer',0,0,1,'',1,1,''),(12,'Admin Menu','',1,'menu',0,'0000-00-00 00:00:00',1,'mod_menu',0,2,1,'',0,1,''),(13,'Admin SubMenu','',1,'submenu',0,'0000-00-00 00:00:00',1,'mod_submenu',0,2,1,'',0,1,''),(14,'User Status','',1,'status',0,'0000-00-00 00:00:00',1,'mod_status',0,2,1,'',0,1,''),(15,'Title','',1,'title',0,'0000-00-00 00:00:00',1,'mod_title',0,2,1,'',0,1,''),(16,'CB Login','',1,'top',0,'0000-00-00 00:00:00',1,'mod_cblogin',0,0,0,'moduleclass_sfx=\nhorizontal=1\ncompact=1\npretext=\nposttext=\nlogin=\nlogout=index.php\nshow_lostpass=1\nshow_newaccount=1\nname_lenght=10\npass_lenght=10\nlogin_message=0\nlogout_message=0\nremember_enabled=1\ngreeting=1\nname=0\nshow_avatar=0\navatar_position=default\npms_type=0\nshow_pms=0\nshow_connection_notifications=0\nhttps_post=0\n\n',0,0,''),(17,'CB Workflows','',7,'right',0,'0000-00-00 00:00:00',0,'mod_comprofilermoderator',0,0,1,'moduleclass_sfx=\npretext=\nposttext=\n\n',0,0,''),(18,'Who\'s Online','',8,'right',0,'0000-00-00 00:00:00',1,'mod_comprofileronline',0,0,1,'moduleclass_sfx=\npretext=\nposttext=\n\n',0,0,''),(19,'Live Users Pro','',6,'left',0,'0000-00-00 00:00:00',0,'mod_liveuserspro',0,0,1,'proCache=1\ncbsupport=1\nnametype=username\ncbnamefield=firstname\ncbgenderfield=cb_gender\ncbfemalevalue=female\ncbmalevalue=male\nnousermsg=No users online\nusergendersort=1\nuserlistlink=cb_profile\ntheme=freunde\nmodulewidth=100%\nmoduleheight=300px\ntooltipshowguest=1\nmousedelay=1000\ntooltipwidth=240px\ntooltiptop=15px\ntooltipleft=5px\ncbuseavatar=1\npmslink=1\npmslinktext=send message\nviewprofilelink=1\nviewprofilelinktext=view user profile\najaxchatlinktext=start private chat\najc_pmwidth=600\najc_pmheight=600\nnantscbgallerylinktext=user has %n additional images\nuserlistlinkcustomcodepre=<img src=\"[avatar]\"/><a href=\"#\" onclick=\"alert(\'Hello [name], thank you for using Live Users Pro!\')\"\nuserlistlinkcustomcodepost=</a>\nsponsorlink=1\n',0,0,''),(20,'CB Superthumb','',7,'left',0,'0000-00-00 00:00:00',0,'mod_cb_superthumb',0,0,1,'@space=General Settings\ncount=10\nwidth_thumbcb=60\nheight_thumbcb=80\niditem=68\nmodulename=2\nshownamedetails=1\n@space=ToolBar Settings\nwidth=15\nheight=15\npmssystem=jim\n',0,0,''),(37,'Bible Studies Menu','',6,'right',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=biblestudies\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',0,0,''),(22,'Request A Song!','',1,'right',0,'0000-00-00 00:00:00',1,'mod_Jaxtr15',0,0,1,'username=gospelmusicomaha\nmode=Button\n\n',0,0,''),(24,'Bible Gateway Verse of the Day','',4,'left',0,'0000-00-00 00:00:00',1,'mod_bg_votd',0,0,1,'moduleclass_sfx=\nversion=31\nmethod=js\n\n',0,0,''),(25,'Daily Bible Reading','',3,'right',0,'0000-00-00 00:00:00',1,'mod_livingword',0,0,1,'moduleclass_sfx=\n\n',0,0,''),(26,'Bible Studies','',1,'banner',0,'0000-00-00 00:00:00',0,'mod_biblestudy',0,0,1,'items=5\nteacher_id=1\nseries_id=0\nbooknumber=0\ntopic_id=0\ncondition=1\nlayouttype=default\nbullets=1\nmod_table_width=500\nmodpos1=1\nspanpos1=\nmodpos2=2\nspanpos2=\nmodpos3=6\nspanpos3=\nmodpos4=9\nspanpos4=\nwidpos1=25%\nwidpos2=25%\nwidpos3=25%\nwidpos4=25%\nshow_description=1\nduration_type=1\nitem_link=1\nshow_media=1\nmedia_colwidth=200\nmedia_width=30\nshow_filesizem=1\nshow_link=1\npagetext=More Bible Studies\nlinebreak=1\nmoduleclass_sfx=\n\n',0,0,''),(27,'Latest Sermons','',4,'right',0,'0000-00-00 00:00:00',1,'mod_latestsermons',0,0,1,'',0,0,''),(28,'Sermoncast','',1,'user7',0,'0000-00-00 00:00:00',0,'mod_sermoncast',0,0,1,'',0,0,''),(29,'JoomlaXTC','',8,'left',0,'0000-00-00 00:00:00',0,'mod_xtcclient',0,0,1,'xtcserver=http://www.mydomain.com/xtcserver.php\nrefid=\nmwst=19\najax=0\nfrequenz=5\n\n',0,0,''),(30,'ElioproMaid','',2,'banner',0,'0000-00-00 00:00:00',0,'mod_eliopromaid',0,0,0,'',0,0,''),(32,'Joomla WebcamXP Module','',9,'left',0,'0000-00-00 00:00:00',0,'mod_jwebcamxp',0,0,1,'cam_url=0.0.0.0\ncam_port=8080\ncam_widht=180\ncam_height=180\ncam_align=middle\ncam_filename=cam_1.jpg\nchat_widht=180\nchat_height=250\n',0,0,''),(33,'Meebo','',9,'right',0,'0000-00-00 00:00:00',0,'mod_meebo1',0,0,1,'meebo_swf=http://widget.meebo.com/mm.swf?kcAOtptTCc\nwidth=250\nheight=330\n',0,0,''),(34,'AB: SMS','',2,'right',0,'0000-00-00 00:00:00',0,'mod_sms',0,0,1,'mailfromname=Gospel Music Omaha\nmailfrom=gmo@qmgonline.net\n\n',0,0,''),(35,'Copy of JoomlaXTC','',1,'content_xtcclient',0,'0000-00-00 00:00:00',0,'mod_xtcclient',0,0,1,'xtcserver=http://www.mydomain.com/xtcserver.php\nrefid=\nmwst=19\najax=0\nfrequenz=5\n\n',0,0,''),(36,'The Flash Module','',5,'left',0,'0000-00-00 00:00:00',0,'mod_flashmod',0,0,0,'moduleclass_sfx=\nfm_path=flash_newstab/\nfm_source=flashmo_112_news_tab.swf\nfm_width=800\nfm_height=400\nfm_name=\nfm_version=8.0.22.0\nfm_quality=autohigh\nfm_loop=yes\nfm_wmode=transparent\nfm_usejs=no\nfm_noscript=flashmovie\nfm_noflash=\n\n',0,0,''),(38,'User Menu','',5,'right',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,1,1,'menutype=usermenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',0,0,''),(39,'Top Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',0,0,''),(40,'Flash Mp3 Player','',1,'user1',0,'0000-00-00 00:00:00',0,'mod_mp3player',0,0,1,'moduleclass_sfx=\nwidth=300\nheight=200\nplaylist=playlist\nstyle=config\nshow=1\nbg_popup=000000\nimage=imagen.gif\n\n',0,0,''),(41,'Listen Now!','',2,'user1',0,'0000-00-00 00:00:00',0,'mod_random_mp3',0,0,1,'count=500\nplayerHeight=80\nordering=random\nfolder=tracks\njscriptDetect=default\ncache=1\ncache_time=900\n\n',0,0,''),(42,'AllVideos Reloaded','',10,'left',0,'0000-00-00 00:00:00',0,'mod_avreloaded',0,0,1,'moduleclass_sfx=\nheader_text=\nmediacode=\nfooter_text=\npopup=0\npwidth=320\npheight=180\nlinktxt=\n\n',0,0,''),(43,'Click to Listen Now!','',1,'left',0,'0000-00-00 00:00:00',1,'mod_glossymp3player',0,0,1,'style=6\nmoduleclass_sfx=\nwidth=130\nheight=130\n\n',0,0,''),(44,'Listen Now - Click \"Pop uP\" for Pop-Up Window','',3,'user1',0,'0000-00-00 00:00:00',0,'mod_jMp3player',0,0,1,'style=10\nmoduleclass_sfx=\nwidth=180\nheight=180\n\n',0,0,''),(45,'AMP3Player','',1,'user2',0,'0000-00-00 00:00:00',0,'mod_amp3player',0,0,1,'style=9\nmoduleclass_sfx=\nwidth=158\nheight=140\n\n',0,0,'');
/*!40000 ALTER TABLE `jos_modules` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_modules_menu`
--

DROP TABLE IF EXISTS `jos_modules_menu`;
CREATE TABLE `jos_modules_menu` (
  `moduleid` int(11) NOT NULL default '0',
  `menuid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_modules_menu`
--

LOCK TABLES `jos_modules_menu` WRITE;
/*!40000 ALTER TABLE `jos_modules_menu` DISABLE KEYS */;
INSERT INTO `jos_modules_menu` VALUES (1,0),(16,0),(17,0),(18,0),(19,0),(20,0),(22,0),(24,0),(25,0),(26,0),(27,0),(28,0),(29,0),(30,0),(32,0),(33,0),(34,0),(35,0),(36,0),(37,0),(38,0),(39,0),(40,0),(41,0),(42,0),(43,0),(44,0),(45,0);
/*!40000 ALTER TABLE `jos_modules_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_newsfeeds`
--

DROP TABLE IF EXISTS `jos_newsfeeds`;
CREATE TABLE `jos_newsfeeds` (
  `catid` int(11) NOT NULL default '0',
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `alias` varchar(255) NOT NULL default '',
  `link` text NOT NULL,
  `filename` varchar(200) default NULL,
  `published` tinyint(1) NOT NULL default '0',
  `numarticles` int(11) unsigned NOT NULL default '1',
  `cache_time` int(11) unsigned NOT NULL default '3600',
  `checked_out` tinyint(3) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `rtl` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `published` (`published`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_newsfeeds`
--

LOCK TABLES `jos_newsfeeds` WRITE;
/*!40000 ALTER TABLE `jos_newsfeeds` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_newsfeeds` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_plugins`
--

DROP TABLE IF EXISTS `jos_plugins`;
CREATE TABLE `jos_plugins` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(100) NOT NULL default '',
  `element` varchar(100) NOT NULL default '',
  `folder` varchar(100) NOT NULL default '',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `published` tinyint(3) NOT NULL default '0',
  `iscore` tinyint(3) NOT NULL default '0',
  `client_id` tinyint(3) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM AUTO_INCREMENT=43 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_plugins`
--

LOCK TABLES `jos_plugins` WRITE;
/*!40000 ALTER TABLE `jos_plugins` DISABLE KEYS */;
INSERT INTO `jos_plugins` VALUES (1,'Authentication - Joomla','joomla','authentication',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(2,'Authentication - LDAP','ldap','authentication',0,2,0,1,0,0,'0000-00-00 00:00:00','host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),(3,'Authentication - GMail','gmail','authentication',0,4,0,0,0,0,'0000-00-00 00:00:00',''),(4,'Authentication - OpenID','openid','authentication',0,3,0,0,0,0,'0000-00-00 00:00:00',''),(5,'User - Joomla!','joomla','user',0,0,1,0,0,0,'0000-00-00 00:00:00','autoregister=1\n\n'),(6,'Search - Content','content','search',0,1,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),(7,'Search - Contacts','contacts','search',0,3,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(8,'Search - Categories','categories','search',0,4,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(9,'Search - Sections','sections','search',0,5,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(10,'Search - Newsfeeds','newsfeeds','search',0,6,1,0,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(11,'Search - Weblinks','weblinks','search',0,2,1,1,0,0,'0000-00-00 00:00:00','search_limit=50\n\n'),(12,'Content - Pagebreak','pagebreak','content',0,10000,1,1,0,0,'0000-00-00 00:00:00','enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),(13,'Content - Rating','vote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(14,'Content - Email Cloaking','emailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00','mode=1\n\n'),(15,'Content - Code Hightlighter (GeSHi)','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),(16,'Content - Load Module','loadmodule','content',0,6,1,0,0,0,'0000-00-00 00:00:00','enabled=1\nstyle=none\n\n'),(17,'Content - Page Navigation','pagenavigation','content',0,2,1,1,0,0,'0000-00-00 00:00:00','position=1\n\n'),(18,'Editor - No Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(19,'Editor - TinyMCE 2.0','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced\ncleanup=1\ncleanup_startup=0\nautosave=0\ncompressed=0\nrelative_urls=1\ntext_direction=ltr\nlang_mode=0\nlang_code=en\ninvalid_elements=applet\ncontent_css=1\ncontent_css_custom=\nnewlines=0\ntoolbar=top\nhr=1\nsmilies=1\ntable=1\nstyle=1\nlayer=1\nxhtmlxtras=0\ntemplate=0\ndirectionality=1\nfullscreen=1\nhtml_height=550\nhtml_width=750\npreview=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\n\n'),(20,'Editor - XStandard Lite 2.0','xstandard','editors',0,0,0,1,0,0,'0000-00-00 00:00:00',''),(21,'Editor Button - Image','image','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(22,'Editor Button - Pagebreak','pagebreak','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(23,'Editor Button - Readmore','readmore','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(24,'XML-RPC - Joomla','joomla','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(25,'XML-RPC - Blogger API','blogger','xmlrpc',0,7,0,1,0,0,'0000-00-00 00:00:00','catid=1\nsectionid=0\n\n'),(27,'System - SEF','sef','system',0,1,1,0,0,0,'0000-00-00 00:00:00',''),(28,'System - Debug','debug','system',0,2,1,0,0,0,'0000-00-00 00:00:00','queries=1\nmemory=1\nlangauge=1\n\n'),(29,'System - Legacy','legacy','system',0,3,1,1,0,0,'0000-00-00 00:00:00','route=0\n\n'),(30,'System - Cache','cache','system',0,4,0,1,0,0,'0000-00-00 00:00:00','browsercache=0\ncachetime=15\n\n'),(31,'System - Log','log','system',0,5,0,1,0,0,'0000-00-00 00:00:00',''),(32,'System - Remember Me','remember','system',0,6,1,1,0,0,'0000-00-00 00:00:00',''),(33,'System - Backlink','backlink','system',0,7,0,1,0,0,'0000-00-00 00:00:00',''),(34,'LazyBackup','lazybackup','system',0,0,0,0,0,0,'0000-00-00 00:00:00','compress=1\ndeletefile=1\ndrop_tables=1\ncreate_tables=1\ncomments=1\nxdays=1\nsubject=Lazybackup Mysql daily backup\nbody=Backup completed successfully at \n'),(35,'Joomla Bible Verse Links','bot_joomlabibleverse','content',0,0,0,0,0,0,'0000-00-00 00:00:00',''),(36,'LivingWord System Plugin','bot_livingword','system',0,0,0,0,0,0,'0000-00-00 00:00:00',''),(37,'System - Bible Study Podcast Publish','bsms_podcast','system',0,0,0,0,0,0,'0000-00-00 00:00:00','xdays=1\nsubject=Bible Study Podcast Publish\nbody=Podcast(s) published successfully.\n'),(38,'Easiertube','easiertube','content',0,0,0,0,0,0,'0000-00-00 00:00:00','fpwidth=217\nfpheight=175\nmpwidth=425\nmpheight=350\nrepeat=no\n'),(39,'AllVideos (by JoomlaWorks)','jw_allvideos','content',0,0,0,0,0,0,'0000-00-00 00:00:00','av_template=Default\n@spacer============ VIDEO PARAMETERS ===========\nvfolder=images/stories/videos\nvwidth=400\nvheight=300\n@spacer============ AUDIO PARAMETERS ===========\nafolder=images/stories/audio\nawidth=300\naheight=20\n@spacer============ GLOBAL PARAMETERS ===========\ntransparency=transparent\nbackground=#ffffff\n@spacer============ FLV PLAYBACK ===========\nav_flvcontroller=bottom\n'),(40,'Content - AllVideos Reloaded','avreloaded','content',0,0,1,0,0,0,'0000-00-00 00:00:00','avcss=allvideos\nwidth=400\nheight=320\nvdir=videos\nwmode=window\nbgcolor=#FFFFFF\nadir=audio\nawidth=300\naheight=20\nripcache=1\ncache_time=3600\n'),(41,'Button - AllVideos Reloaded','avreloaded','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(42,'System - AllVideos Reloaded','avreloaded','system',0,0,1,0,0,0,'0000-00-00 00:00:00','');
/*!40000 ALTER TABLE `jos_plugins` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_poll_data`
--

DROP TABLE IF EXISTS `jos_poll_data`;
CREATE TABLE `jos_poll_data` (
  `id` int(11) NOT NULL auto_increment,
  `pollid` int(11) NOT NULL default '0',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_poll_data`
--

LOCK TABLES `jos_poll_data` WRITE;
/*!40000 ALTER TABLE `jos_poll_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_data` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_poll_date`
--

DROP TABLE IF EXISTS `jos_poll_date`;
CREATE TABLE `jos_poll_date` (
  `id` bigint(20) NOT NULL auto_increment,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL default '0',
  `poll_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_poll_date`
--

LOCK TABLES `jos_poll_date` WRITE;
/*!40000 ALTER TABLE `jos_poll_date` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_date` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_poll_menu`
--

DROP TABLE IF EXISTS `jos_poll_menu`;
CREATE TABLE `jos_poll_menu` (
  `pollid` int(11) NOT NULL default '0',
  `menuid` int(11) NOT NULL default '0',
  PRIMARY KEY  (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_poll_menu`
--

LOCK TABLES `jos_poll_menu` WRITE;
/*!40000 ALTER TABLE `jos_poll_menu` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_poll_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_polls`
--

DROP TABLE IF EXISTS `jos_polls`;
CREATE TABLE `jos_polls` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `voters` int(9) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL default '0',
  `access` int(11) NOT NULL default '0',
  `lag` int(11) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_polls`
--

LOCK TABLES `jos_polls` WRITE;
/*!40000 ALTER TABLE `jos_polls` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_polls` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_sections`
--

DROP TABLE IF EXISTS `jos_sections`;
CREATE TABLE `jos_sections` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `name` varchar(255) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `image` text NOT NULL,
  `scope` varchar(50) NOT NULL default '',
  `image_position` varchar(30) NOT NULL default '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) unsigned NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `access` tinyint(3) unsigned NOT NULL default '0',
  `count` int(11) NOT NULL default '0',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `idx_scope` (`scope`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_sections`
--

LOCK TABLES `jos_sections` WRITE;
/*!40000 ALTER TABLE `jos_sections` DISABLE KEYS */;
INSERT INTO `jos_sections` VALUES (1,'News','','news','','content','left','',1,0,'0000-00-00 00:00:00',1,0,1,'');
/*!40000 ALTER TABLE `jos_sections` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_sermon_avatars`
--

DROP TABLE IF EXISTS `jos_sermon_avatars`;
CREATE TABLE `jos_sermon_avatars` (
  `id` int(11) NOT NULL auto_increment,
  `avatar_name` text NOT NULL,
  `avatar_location` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_sermon_avatars`
--

LOCK TABLES `jos_sermon_avatars` WRITE;
/*!40000 ALTER TABLE `jos_sermon_avatars` DISABLE KEYS */;
INSERT INTO `jos_sermon_avatars` VALUES (1,'None',''),(2,'sharon','/components/com_sermonspeaker/media/avatars/sharon.jpg');
/*!40000 ALTER TABLE `jos_sermon_avatars` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_sermon_series`
--

DROP TABLE IF EXISTS `jos_sermon_series`;
CREATE TABLE `jos_sermon_series` (
  `id` int(11) NOT NULL auto_increment,
  `speaker_id` int(11) NOT NULL,
  `series_title` text NOT NULL,
  `series_description` text NOT NULL,
  `avatar_id` int(11) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `created_by` int(11) NOT NULL,
  `created_on` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10000 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_sermon_series`
--

LOCK TABLES `jos_sermon_series` WRITE;
/*!40000 ALTER TABLE `jos_sermon_series` DISABLE KEYS */;
INSERT INTO `jos_sermon_series` VALUES (9999,9999,'General Topics','Topics of general interest.',1,1,0,3,0,'2006-03-28');
/*!40000 ALTER TABLE `jos_sermon_series` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_sermon_sermons`
--

DROP TABLE IF EXISTS `jos_sermon_sermons`;
CREATE TABLE `jos_sermon_sermons` (
  `id` int(11) NOT NULL auto_increment,
  `speaker_id` int(11) NOT NULL,
  `series_id` int(11) NOT NULL,
  `sermon_path` text NOT NULL,
  `sermon_title` text NOT NULL,
  `sermon_number` text NOT NULL,
  `sermon_scripture` text NOT NULL,
  `sermon_date` date NOT NULL,
  `sermon_time` time default NULL,
  `play` tinyint(1) NOT NULL,
  `notes` longtext NOT NULL,
  `download` tinyint(1) NOT NULL,
  `published` tinyint(1) NOT NULL,
  `ordering` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `created_by` int(11) NOT NULL,
  `created_on` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10000 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_sermon_sermons`
--

LOCK TABLES `jos_sermon_sermons` WRITE;
/*!40000 ALTER TABLE `jos_sermon_sermons` DISABLE KEYS */;
INSERT INTO `jos_sermon_sermons` VALUES (9999,9999,9999,'/components/com_sermonspeaker/media/default_sermon.mp3','The Sin of Booze','1','none','2006-03-28','00:00:05',0,'Borrowed from sermonaudio.com',1,1,0,10,62,'2006-03-28');
/*!40000 ALTER TABLE `jos_sermon_sermons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_sermon_speakers`
--

DROP TABLE IF EXISTS `jos_sermon_speakers`;
CREATE TABLE `jos_sermon_speakers` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `website` text,
  `intro` text,
  `bio` longtext,
  `pic` text,
  `published` tinyint(1) NOT NULL default '0',
  `ordering` int(11) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `created_by` int(11) NOT NULL,
  `created_on` varchar(10) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10000 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_sermon_speakers`
--

LOCK TABLES `jos_sermon_speakers` WRITE;
/*!40000 ALTER TABLE `jos_sermon_speakers` DISABLE KEYS */;
INSERT INTO `jos_sermon_speakers` VALUES (9999,'Billy Sunday','http://joomlacode.org/gf/project/sermon_speaker/','Billy Sunday died in Chicago, November 6, 1935; services were held in the Moody Memorial Church with 4,400 present. Take 15 minutes each day to listen to God talking to you; take 15 minutes each day to talk to God; take 15 minutes each day to talk to others about God.','This young convert was deeply impressed and determined to make these the rules of his life. From that day onward throughout his life he made it a rule to spend the first moments of his day alone with God and God\'s Word. Before he read a letter, looked at a paper or even read a telegram, he went first to the Bible, that the first impression of the day might be what he got directly from God.','./components/com_sermonspeaker/media/default_speaker.jpg',1,0,17,62,'1901-03-28');
/*!40000 ALTER TABLE `jos_sermon_speakers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_session`
--

DROP TABLE IF EXISTS `jos_session`;
CREATE TABLE `jos_session` (
  `username` varchar(150) default '',
  `time` varchar(14) default '',
  `session_id` varchar(200) NOT NULL default '0',
  `guest` tinyint(4) default '1',
  `userid` int(11) default '0',
  `usertype` varchar(50) default '',
  `gid` tinyint(3) unsigned NOT NULL default '0',
  `client_id` tinyint(3) unsigned NOT NULL default '0',
  `data` longtext,
  PRIMARY KEY  (`session_id`(64)),
  KEY `whosonline` (`guest`,`usertype`),
  KEY `userid` (`userid`),
  KEY `time` (`time`),
  KEY `blastchatc` (`usertype`,`guest`,`session_id`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_session`
--

LOCK TABLES `jos_session` WRITE;
/*!40000 ALTER TABLE `jos_session` DISABLE KEYS */;
INSERT INTO `jos_session` VALUES ('','1224667109','581340be8a57b615bd39e754eab88d9e',1,0,'',0,0,'__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1224667109;s:18:\"session.timer.last\";i:1224667109;s:17:\"session.timer.now\";i:1224667109;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:89:\"/home/qmgonlin/public_html/gospelmusicomaha/radio/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'),('','1224666212','d72bbb2037e102e28dfaf6e9db934545',1,0,'',0,0,'__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1224666212;s:18:\"session.timer.last\";i:1224666212;s:17:\"session.timer.now\";i:1224666212;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:89:\"/home/qmgonlin/public_html/gospelmusicomaha/radio/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'),('','1224666827','8b122287c27aa059e01ce6eb6686bf3b',1,0,'',0,0,'__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1224666827;s:18:\"session.timer.last\";i:1224666827;s:17:\"session.timer.now\";i:1224666827;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:89:\"/home/qmgonlin/public_html/gospelmusicomaha/radio/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}'),('','1224666955','ad50c9dd8a73129ff0e0f6eb5ab1ae20',1,0,'',0,0,'__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1224666955;s:18:\"session.timer.last\";i:1224666955;s:17:\"session.timer.now\";i:1224666955;s:22:\"session.client.browser\";s:72:\"Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:89:\"/home/qmgonlin/public_html/gospelmusicomaha/radio/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}}');
/*!40000 ALTER TABLE `jos_session` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_ads`
--

DROP TABLE IF EXISTS `jos_seyret_ads`;
CREATE TABLE `jos_seyret_ads` (
  `id` int(11) NOT NULL auto_increment,
  `catid` text,
  `adlink` text,
  `published` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_ads`
--

LOCK TABLES `jos_seyret_ads` WRITE;
/*!40000 ALTER TABLE `jos_seyret_ads` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_seyret_ads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_categories`
--

DROP TABLE IF EXISTS `jos_seyret_categories`;
CREATE TABLE `jos_seyret_categories` (
  `id` int(11) NOT NULL auto_increment,
  `categoryname` varchar(50) NOT NULL,
  `parentcat` text NOT NULL,
  `categoryinfo` text NOT NULL,
  `catid` text NOT NULL,
  `categoryfilesdirectory` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_categories`
--

LOCK TABLES `jos_seyret_categories` WRITE;
/*!40000 ALTER TABLE `jos_seyret_categories` DISABLE KEYS */;
INSERT INTO `jos_seyret_categories` VALUES (1,'Gospel Artists','','gospel music videos','*1*#','/seyretfiles/localvideos/gospel_music'),(2,'Gospel Concerts','','','*2*#','/seyretfiles/localvideos/gospel_concerts'),(3,'Holy Hip Hop','','','*3*#','/seyretfiles/localvideos/holy_hip_hop'),(4,'R&P Rhythm & Praise','','','*4*#','/seyretfiles/localvideos/rp_rhythm__praise'),(5,'Sermons','','','*5*#','/seyretfiles/localvideos/sermons'),(6,'Choirs','','','*6*#','/seyretfiles/localvideos/choirs'),(7,'Ensembles','','','*7*#','/seyretfiles/localvideos/ensembles'),(8,'Quartets','','','*8*#','/seyretfiles/localvideos/quartets'),(9,'Solo Artists','','','*9*#','/seyretfiles/localvideos/solo_artists'),(10,'Musicians Shed','','','*10*#','/seyretfiles/localvideos/musicians_shed');
/*!40000 ALTER TABLE `jos_seyret_categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_check`
--

DROP TABLE IF EXISTS `jos_seyret_check`;
CREATE TABLE `jos_seyret_check` (
  `id` int(11) NOT NULL auto_increment,
  `joomlaalemtrack` int(1) default '0',
  `joomlaalemuserid` varchar(15) default NULL,
  `jalemdonated` int(1) default '0',
  `seyrethelp` text,
  `seyretsnippet` text,
  `dbversion` char(10) default NULL,
  `seyretpro` int(1) default '0',
  `prophpdate` datetime NOT NULL default '0000-00-00 00:00:00',
  `dfltdownloader` tinytext,
  `prophpmd5` tinytext,
  `accepttermsofuse` int(1) default '0',
  `savedconfig` text,
  `securitycode1` varchar(20) default NULL,
  `securitycode2` varchar(20) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_check`
--

LOCK TABLES `jos_seyret_check` WRITE;
/*!40000 ALTER TABLE `jos_seyret_check` DISABLE KEYS */;
INSERT INTO `jos_seyret_check` VALUES (1,1,'55361a8cwy9jufo',0,'You can create your own help page. Just edit from Seyret administration panel.',NULL,'0.2.8',0,'0000-00-00 00:00:00',NULL,NULL,1,'<?php\n$youtubedeveloperid = \"_dd6hWCoal8\";\n$videolisttitlelettercount = \"15\";\n$videolistdescriptionlettercount = \"100\";\n$videowidth = \"290\";\n$videoheight = \"240\";\n$orderingkey = \"addeddate\";\n$orderingtype = \"DESC\";\n$popupvideowidth = \"100%\";\n$popupvideoheight = \"100%\";\n$theme = \"default\";\n$enabledownloads = \"\";\n$videocountinvideolist = \"10\";\n$videomaxuploadsize = \"1600\";\n$thumbmaxuploadsize = \"2\";\n$configthumbwidth = \"120\";\n$embedboxwidth = \"500\";\n$screenname = \"username\";\n$remoteservervideosupport = \"0\";\n$remoteserver_ads_directory = \"http://74.53.13.43\";\n$remoteserver_videos_directory = \"http://74.53.13.43\";\n$responseseyretcheckitstring = \"as_mustafa_lsnndhh12334_joomlaalemextraoridnarycomponents_453457785678FDDfweqwe\";\n$useajaxbrowsing = \"1\";\n$usemulticolumnsvideolisting = \"0\";\n$multicolumncount = \"2\";\n$videoaccesslevelsconf = \"2\";\n$accesslevelupgradelink = \"http://www.joomlaholic.com/index.php?task=denemeyapbeaclamca\";\n$localfilesdirectory = \"/seyretfiles/localvideos\";\n$useimageadsystem = \"0\";\n$imageadduration = \"3000\";\n$defaultimagead = \"http://www.joomlaholic.com/joomlaholic_ad.png\";\n$usevideoadsystem = \"0\";\n$showthumbwidth = \"90\";\n$commentingsystem = \"nocomment\";\n$showvideotooltips = \"1\";\n$showcategorytooltips = \"0\";\n$fbdiscusscategoryforseyret = \"17\";\n$leavevideolinkfordiscuss = \"1\";\n$local_ads_directory = \"seyretfiles/ads/videoads\";\n$disablepro = \"1\";\n$ffmpegpath = \"C:/oldedit/seyretfiles/tools/converter/ffmpeg.exe\";\n$enableflvconversion = \"0\";\n$enablethumbnailextraction = \"0\";\n$setflvdimensions = \"320x240\";\n$audiosamplingfrequency = \"44100\";\n$audiobitrate = \"8\";\n$videoframerate = \"25\";\n$videobitrate = \"200\";\n$setthumbdimensions = \"320x240\";\n$setthumbdimensionsbig = \"0\";\n$instantvideoprocess = \"1\";\n$instantthumbprocess = \"1\";\n$usejoomlaeditor = \"0\";\n$showoriginallink = \"1\";\n$ffmpegpreexec = \"\";\n$errorreporting = \"noreport\";\n$forcelamesupport = \"0\";\n?>',NULL,NULL);
/*!40000 ALTER TABLE `jos_seyret_check` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_imageads`
--

DROP TABLE IF EXISTS `jos_seyret_imageads`;
CREATE TABLE `jos_seyret_imageads` (
  `id` int(11) NOT NULL auto_increment,
  `catid` text,
  `imageadlink` text,
  `published` tinyint(1) NOT NULL default '0',
  `clicklink` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_imageads`
--

LOCK TABLES `jos_seyret_imageads` WRITE;
/*!40000 ALTER TABLE `jos_seyret_imageads` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_seyret_imageads` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_items`
--

DROP TABLE IF EXISTS `jos_seyret_items`;
CREATE TABLE `jos_seyret_items` (
  `id` int(11) NOT NULL auto_increment,
  `catid` text NOT NULL,
  `title` text,
  `itemcomment` text,
  `videoservertype` varchar(20) default NULL,
  `videoservercode` text,
  `picturelink` text,
  `ordering` int(11) default NULL,
  `hit` int(11) NOT NULL,
  `votetotal` int(11) NOT NULL,
  `voteclick` int(11) NOT NULL,
  `addedby` int(11) NOT NULL,
  `addeddate` datetime NOT NULL default '0000-00-00 00:00:00',
  `published` int(1) default '0',
  `downloadcount` int(11) default NULL,
  `accesslevel` int(3) default '0',
  `hasbackup` tinyint(1) default NULL,
  `isdownloadable` tinyint(1) default '1',
  `backupid` int(11) default '0',
  `videourl` text,
  `featured` int(1) default '0',
  `fbthread` int(11) default '0',
  `videotags` text,
  `lastclicktime` datetime NOT NULL default '0000-00-00 00:00:00',
  `playtime` text,
  `isreplyto` int(11) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_items`
--

LOCK TABLES `jos_seyret_items` WRITE;
/*!40000 ALTER TABLE `jos_seyret_items` DISABLE KEYS */;
INSERT INTO `jos_seyret_items` VALUES (3,'','Kirk Franklin','','GospelTube','e926456240b2ff0100bd','',NULL,1,0,0,62,'2008-07-08 21:18:46',1,NULL,0,NULL,1,0,NULL,0,0,NULL,'2008-07-08 21:19:50',NULL,0),(2,'','Gospel Music Omaha Promo - 24/7 FM Urban Gospel Radio','Gospel Music Omaha Promo - 24/7 FM Urban Gospel Radio','youtube','Ird_NgKHmKY','http://i.ytimg.com/vi/Ird_NgKHmKY/default.jpg',NULL,6,0,0,62,'2008-07-08 20:46:27',1,NULL,0,NULL,1,0,'http://www.youtube.com/watch?v=Ird_NgKHmKY',1,0,'gospel music omaha gospel music omaha  fm radio  internet radio  web radio  gospel music  holy hip hop  gospel rap  r&p  urban gospel  black gospel','2008-10-03 15:06:43',NULL,0);
/*!40000 ALTER TABLE `jos_seyret_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_permissions`
--

DROP TABLE IF EXISTS `jos_seyret_permissions`;
CREATE TABLE `jos_seyret_permissions` (
  `id` int(11) NOT NULL auto_increment,
  `jaclname` tinytext,
  `canseeadmintoolbar` int(1) default NULL,
  `canseereportedvideosbutton` int(1) default NULL,
  `canseependingvideosbutton` int(1) default NULL,
  `canseeaddvideobutton` int(1) default NULL,
  `canaddvideos` int(1) default NULL,
  `canseeuploadvideobutton` int(1) default NULL,
  `canuploadvideos` int(1) default NULL,
  `canseemyvideosbutton` int(1) default NULL,
  `canseefeaturedvideosbutton` int(1) default NULL,
  `canseesearchvideosbutton` int(1) default NULL,
  `canseehelpbutton` int(1) default NULL,
  `canseedeletevideobutton` int(1) default NULL,
  `candeletevideo` int(1) default NULL,
  `canseeeditvideobutton` int(1) default NULL,
  `caneditvideo` int(1) default NULL,
  `canseefullscreenbutton` int(1) default NULL,
  `canseedownloadbutton` int(1) default NULL,
  `candownloadvideo` int(1) default NULL,
  `canseereportbutton` int(1) default NULL,
  `canreportvideos` int(1) default NULL,
  `canseedirectlinkbox` int(1) default NULL,
  `canseeembedbox` int(1) default NULL,
  `canseevotestars` int(1) default NULL,
  `canvote` int(1) default NULL,
  `canseecomments` int(1) default NULL,
  `canpublishvideo` int(1) default NULL,
  `canseevideoservercodes` int(1) default NULL,
  `uservideoaccesslevel` int(3) default NULL,
  `caneditownvideos` int(1) default '0',
  `candeleteownvideos` int(1) default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_permissions`
--

LOCK TABLES `jos_seyret_permissions` WRITE;
/*!40000 ALTER TABLE `jos_seyret_permissions` DISABLE KEYS */;
INSERT INTO `jos_seyret_permissions` VALUES (1,'public frontend',0,0,0,1,1,1,0,0,1,1,1,0,0,0,0,1,1,1,1,0,1,1,1,1,1,1,0,NULL,0,0);
/*!40000 ALTER TABLE `jos_seyret_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_seyret_reports`
--

DROP TABLE IF EXISTS `jos_seyret_reports`;
CREATE TABLE `jos_seyret_reports` (
  `id` int(11) NOT NULL auto_increment,
  `videoid` int(11) default NULL,
  `reportedby` int(11) default NULL,
  `reporteddate` datetime default NULL,
  `reportreason` text,
  `reportread` int(1) default '0',
  `reportprocessed` int(1) default '0',
  `reportprocessedby` int(11) default NULL,
  `reportreply` text,
  `reportreplydate` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_seyret_reports`
--

LOCK TABLES `jos_seyret_reports` WRITE;
/*!40000 ALTER TABLE `jos_seyret_reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_seyret_reports` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_stats_agents`
--

DROP TABLE IF EXISTS `jos_stats_agents`;
CREATE TABLE `jos_stats_agents` (
  `agent` varchar(255) NOT NULL default '',
  `type` tinyint(1) unsigned NOT NULL default '0',
  `hits` int(11) unsigned NOT NULL default '1'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_stats_agents`
--

LOCK TABLES `jos_stats_agents` WRITE;
/*!40000 ALTER TABLE `jos_stats_agents` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_stats_agents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_templates_menu`
--

DROP TABLE IF EXISTS `jos_templates_menu`;
CREATE TABLE `jos_templates_menu` (
  `template` varchar(255) NOT NULL default '',
  `menuid` int(11) NOT NULL default '0',
  `client_id` tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_templates_menu`
--

LOCK TABLES `jos_templates_menu` WRITE;
/*!40000 ALTER TABLE `jos_templates_menu` DISABLE KEYS */;
INSERT INTO `jos_templates_menu` VALUES ('jsn_epic_free',0,0),('khepri',0,1);
/*!40000 ALTER TABLE `jos_templates_menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_users`
--

DROP TABLE IF EXISTS `jos_users`;
CREATE TABLE `jos_users` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `username` varchar(150) NOT NULL default '',
  `email` varchar(100) NOT NULL default '',
  `password` varchar(100) NOT NULL default '',
  `usertype` varchar(25) NOT NULL default '',
  `block` tinyint(4) NOT NULL default '0',
  `sendEmail` tinyint(4) default '0',
  `gid` tinyint(3) unsigned NOT NULL default '1',
  `registerDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL default '',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`),
  KEY `gid_block` (`gid`,`block`),
  KEY `username` (`username`),
  KEY `email` (`email`)
) ENGINE=MyISAM AUTO_INCREMENT=65 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_users`
--

LOCK TABLES `jos_users` WRITE;
/*!40000 ALTER TABLE `jos_users` DISABLE KEYS */;
INSERT INTO `jos_users` VALUES (62,'GMO','gmo','gmo@qmgonline.net','3c40cdb557fd8d024c858d52d1d9fddd:CEzeBvz0KClNsLEHuJdp9FtE4cVvSp6y','Super Administrator',0,1,25,'2008-07-03 10:12:49','2008-10-03 22:25:05','',''),(63,'Tracy','tlewis3boyz','tlewis3boyz@aol.com','40514469719094968c2b927e42b20f84:96GsMpHGLoo80jEWBC4mwiMg26VTOw2p','Registered',0,0,18,'2008-10-08 08:14:56','2008-10-08 14:22:53','',''),(64,'Jennifer Young','jdyoung','jenniferdian@gmail.com','4ea756f99c93661e3a78d657e71c8bd0:SVsWeJZpcbn6famfZnjQrZ8Zsc2gyFeB','Registered',1,0,18,'2008-10-16 12:20:09','0000-00-00 00:00:00','','');
/*!40000 ALTER TABLE `jos_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jos_weblinks`
--

DROP TABLE IF EXISTS `jos_weblinks`;
CREATE TABLE `jos_weblinks` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '0',
  `sid` int(11) NOT NULL default '0',
  `title` varchar(250) NOT NULL default '',
  `alias` varchar(255) NOT NULL default '',
  `url` varchar(250) NOT NULL default '',
  `description` text NOT NULL,
  `date` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL default '0',
  `published` tinyint(1) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL default '0',
  `archived` tinyint(1) NOT NULL default '0',
  `approved` tinyint(1) NOT NULL default '1',
  `params` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `jos_weblinks`
--

LOCK TABLES `jos_weblinks` WRITE;
/*!40000 ALTER TABLE `jos_weblinks` DISABLE KEYS */;
/*!40000 ALTER TABLE `jos_weblinks` 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 2008-10-22 20:40:45