-- MySQL dump 10.13 Distrib 5.6.25, for Win32 (x86)
--
-- Host: localhost Database: joomla_mamfm
-- ------------------------------------------------------
-- Server version 5.6.36
/*!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 `mamfm_banner`
--
DROP TABLE IF EXISTS `mamfm_banner`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_banner` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL DEFAULT 'banner',
`name` varchar(50) 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,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_banner`
--
LOCK TABLES `mamfm_banner` WRITE;
/*!40000 ALTER TABLE `mamfm_banner` DISABLE KEYS */;
INSERT INTO `mamfm_banner` VALUES (1,1,'banner','OSM 1',0,42,0,'osmbanner1.png','http://www.opensourcematters.org','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL),(2,1,'banner','OSM 2',0,49,0,'osmbanner2.png','http://www.opensourcematters.org','2004-07-07 15:31:29',1,0,'2000-00-00 00:00:00',NULL,NULL);
/*!40000 ALTER TABLE `mamfm_banner` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_bannerclient`
--
DROP TABLE IF EXISTS `mamfm_bannerclient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_bannerclient` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(60) NOT NULL DEFAULT '',
`contact` varchar(60) NOT NULL DEFAULT '',
`email` varchar(60) 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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_bannerclient`
--
LOCK TABLES `mamfm_bannerclient` WRITE;
/*!40000 ALTER TABLE `mamfm_bannerclient` DISABLE KEYS */;
INSERT INTO `mamfm_bannerclient` VALUES (1,'Open \r\n\r\nSource Matters','Administrator','admin@opensourcematters.org','',0,'00:00:00',NULL);
/*!40000 ALTER TABLE `mamfm_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_bannerfinish`
--
DROP TABLE IF EXISTS `mamfm_bannerfinish`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_bannerfinish` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`type` varchar(10) NOT NULL DEFAULT '',
`name` varchar(50) NOT NULL DEFAULT '',
`impressions` int(11) NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`imageurl` varchar(50) NOT NULL DEFAULT '',
`datestart` datetime DEFAULT NULL,
`dateend` datetime DEFAULT NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_bannerfinish`
--
LOCK TABLES `mamfm_bannerfinish` WRITE;
/*!40000 ALTER TABLE `mamfm_bannerfinish` DISABLE KEYS */;
/*!40000 ALTER TABLE `mamfm_bannerfinish` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_categories`
--
DROP TABLE IF EXISTS `mamfm_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(50) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`image` varchar(100) NOT NULL DEFAULT '',
`section` varchar(50) NOT NULL DEFAULT '',
`image_position` varchar(10) 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_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_categories`
--
LOCK TABLES `mamfm_categories` WRITE;
/*!40000 ALTER TABLE `mamfm_categories` DISABLE KEYS */;
INSERT INTO `mamfm_categories` VALUES (1,0,'Latest','Latest News','taking_notes.jpg','1','left','The \r\n\r\nlatest news from the Joomla! Team',1,0,'0000-00-00 00:00:00','',0,0,1,''),(2,0,'Joomla!','Joomla!','clock.jpg','com_weblinks','left','A selection of links that are all related to the Joomla! Project.',1,0,'0000-00-00 00:00:00',NULL,0,0,0,''),(3,0,'Newsflash','Newsflash','','2','left','',1,0,'0000-00-00 00:00:00','',0,0,0,''),(4,0,'Joomla!','Joomla!','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,2,0,0,''),(5,0,'Business: general','Business: general','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,1,0,0,''),(7,0,'Examples','Example FAQs','key.jpg','3','left','Here you will find an example set of FAQs.',1,0,'0000-00-00 00:00:00',NULL,0,0,2,''),(9,0,'Finance','Finance','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,5,0,0,''),(10,0,'Linux','Linux','','com_newsfeeds','left','
\r\n',1,0,'0000-00-00 00:00:00',NULL,6,0,0,''),(11,0,'Internet','Internet','','com_newsfeeds','left','',1,0,'0000-00-00 00:00:00',NULL,7,0,0,''),(12,0,'Contacts','Contacts','','com_contact_details','left','Contact Details for this website',1,0,'0000-00-00 00:00:00',NULL,0,0,0,'');
/*!40000 ALTER TABLE `mamfm_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_components`
--
DROP TABLE IF EXISTS `mamfm_components`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_components`
--
LOCK TABLES `mamfm_components` WRITE;
/*!40000 ALTER TABLE `mamfm_components` DISABLE KEYS */;
INSERT INTO `mamfm_components` VALUES (1,'Banners','',0,0,'','Banner Management','com_banners',0,'js/ThemeOffice/component.png',0,''),(2,'Manage Banners','',0,1,'option=com_banners','Active Banners','com_banners',1,'js/ThemeOffice/edit.png',0,''),(3,'Manage Clients','',0,1,'option=com_banners&task=listclients','Manage Clients','com_banners',2,'js/ThemeOffice/categories.png',0,''),(4,'Web Links','option=com_weblinks',0,0,'','Manage Weblinks','com_weblinks',0,'js/ThemeOffice/globe2.png',0,''),(5,'Weblink Items','',0,4,'option=com_weblinks','View existing weblinks','com_weblinks',1,'js/ThemeOffice/edit.png',0,''),(6,'Weblink Categories','',0,4,'option=categories§ion=com_weblinks','Manage weblink categories','',2,'js/ThemeOffice/categories.png',0,''),(7,'Contacts','option=com_contact',0,0,'','Edit contact details','com_contact',0,'js/ThemeOffice/user.png',1,''),(8,'Manage Contacts','',0,7,'option=com_contact','Edit contact details','com_contact',0,'js/ThemeOffice/edit.png',1,''),(9,'Contact Categories','',0,7,'option=categories§ion=com_contact_details','Manage contact categories','',2,'js/ThemeOffice/categories.png',1,''),(10,'FrontPage','option=com_frontpage',0,0,'','Manage Front Page Items','com_frontpage',0,'js/ThemeOffice/component.png',1,''),(11,'Polls','option=com_poll',0,0,'option=com_poll','Manage Polls','com_poll',0,'js/ThemeOffice/component.png',0,''),(12,'News Feeds','option=com_newsfeeds',0,0,'','News Feeds Management','com_newsfeeds',0,'js/ThemeOffice/component.png',0,''),(13,'Manage News Feeds','',0,12,'option=com_newsfeeds','Manage News Feeds','com_newsfeeds',1,'js/ThemeOffice/edit.png',0,''),(14,'Manage Categories','',0,12,'option=com_categories§ion=com_newsfeeds','Manage Categories','',2,'js/ThemeOffice/categories.png',0,''),(15,'Login','option=com_login',0,0,'','','com_login',0,'',1,''),(16,'Search','option=com_search',0,0,'','','com_search',0,'',1,''),(17,'Syndicate','',0,0,'option=com_syndicate&hidemainmenu=1','Manage Syndication Settings','com_syndicate',0,'js/ThemeOffice/component.png',0,''),(18,'Mass Mail','',0,0,'option=com_massmail&hidemainmenu=1','Send Mass Mail','com_massmail',0,'js/ThemeOffice/mass_email.png',0,'');
/*!40000 ALTER TABLE `mamfm_components` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_contact_details`
--
DROP TABLE IF EXISTS `mamfm_contact_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_contact_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`con_position` varchar(50) DEFAULT NULL,
`address` text,
`suburb` varchar(50) DEFAULT NULL,
`state` varchar(20) DEFAULT NULL,
`country` varchar(50) DEFAULT NULL,
`postcode` varchar(10) DEFAULT NULL,
`telephone` varchar(25) DEFAULT NULL,
`fax` varchar(25) DEFAULT NULL,
`misc` mediumtext,
`image` varchar(100) DEFAULT NULL,
`imagepos` varchar(20) DEFAULT NULL,
`email_to` varchar(100) 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',
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_contact_details`
--
LOCK TABLES `mamfm_contact_details` WRITE;
/*!40000 ALTER TABLE `mamfm_contact_details` DISABLE KEYS */;
INSERT INTO `mamfm_contact_details` VALUES (1,'Name','Position','Street','Suburb','State','Country','Zip Code','Telephone','Fax','Miscellanous info','asterisk.png','top','email@email.com',1,1,0,'0000-00-00 00:00:00',1,'',0,12,0);
/*!40000 ALTER TABLE `mamfm_contact_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `mamfm_content`
--
DROP TABLE IF EXISTS `mamfm_content`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `mamfm_content` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(100) NOT NULL DEFAULT '',
`title_alias` varchar(100) 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(100) 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',
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_mask` (`mask`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `mamfm_content`
--
LOCK TABLES `mamfm_content` WRITE;
/*!40000 ALTER TABLE `mamfm_content` DISABLE KEYS */;
INSERT INTO `mamfm_content` VALUES (1,'Welcome to Joomla!','Welcome','If you\'ve read anything at \r\n\r\nall about Content Management Systems (CMS), you\'ll probably know at least three things: CMS are the most exciting way to do business, CMS can be \r\n\r\nreally, I mean really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive.
\r\n\r\n{mosimage}Joomla! is set to change all that ... Joomla! is different from the normal models for portal software. For a start, it\'s not complicated. \r\n\r\nJoomla! has been developed for the masses. It\'s licensed under the GNU/GPL license, easy to install and administer and reliable. Joomla! doesn\'t \r\n\r\neven require the user or administrator of the system to know HTML to operate it once it\'s up and running.','
This website is powered by Joomla! The software and default \r\n\r\ntemplates on which it runs are Copyright 2005 Open Source Matters. All other content and data, \r\n\r\nincluding data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.
If you \r\n\r\nwant to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU \r\n\r\nGeneral Public License. If you are unfamiliar with this license, you might want to read \'How To Apply These Terms To Your Program\' and the \'GNU General Public License FAQ\'.
','',1,0,0,0,'2004-08-19 20:11:07',62,'','2004-08-19 20:14:49',62,0,'0000-00-00 00:00:00','2004-08-19 00:00:00','0000-00-00 00:00:00','','','menu_image=\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\r\n\r\n\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=',1,0,11,'','',0,10),(6,'Example News Item 1','News1','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no \r\n\r\nsea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum.','{mosimage}\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero \r\n\r\neros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum \r\n\r\ndolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n\r\n\r\nUt wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\r\n\r\n\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et \r\n\r\naccumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\nNam \r\n\r\nliber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit \r\n\r\namet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\n\r\n\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum \r\n\r\niriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et \r\n\r\njusto duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, \r\n\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et \r\n\r\naccusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor \r\n\r\nsit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt \r\n\r\njusto labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem \r\n\r\nipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\r\n\r\n\nConsetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\r\n\r\n\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum \r\n\r\ndolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam \r\n\r\nvoluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor \r\n\r\nsit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam \r\n\r\nerat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem \r\n\r\nipsum dolor sit amet.
',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:05:05',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','food/coffee.jpg|left||0\r\nfood/bread.jpg|right||0','','',1,0,2,'','',0,4),(7,'Example News Item 2','News2','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no \r\n\r\nsea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd \r\n\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy \r\n\r\neirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\nclita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:11:30',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','food/bun.jpg|right||0','','',1,0,3,'','',0,2),(8,'Example News Item 3','News3','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no \r\n\r\nsea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor \r\n\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd \r\n\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy \r\n\r\neirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet \r\n\r\nclita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',1,1,0,1,'2004-04-12 11:54:06',62,'','2004-07-07 18:08:23',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','fruit/pears.jpg|right||0','','',1,0,4,'','',0,1),(9,'Example News Item 4','News4','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, \r\n\r\nno sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse \r\n\r\nmolestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\r\n\r\n\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh \r\n\r\neuismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mospagebreak}{mosimage}Ut wisi enim ad minim veniam, quis nostrud \r\n\r\nexerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate \r\n\r\nvelit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit \r\n\r\npraesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend \r\n\r\noption congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed \r\n\r\ndiam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation \r\n\r\nullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\r\n\r\n\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita \r\n\r\nkasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam \r\n\r\nnonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea \r\n\r\nrebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing \r\n\r\nelitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et \r\n\r\ngubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\r\n\r\n\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\n{mospagebreak}\r\n\r\nConsetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos \r\n\r\net accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor \r\n\r\nsit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At \r\n\r\nvero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem \r\n\r\nipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam \r\n\r\nvoluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor \r\n\r\nsit amet.
',1,1,0,1,'2004-07-07 11:54:06',62,'','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-07-07 00:00:00','0000-00-00 00:00:00','fruit/strawberry.jpg|left||0\r\nfruit/pears.jpg|right||0\r\nfruit/cherry.jpg|left||0','','',1,0,5,'','',0,6),(10,'Example FAQ Item 1','FAQ1','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, \r\n\r\nno sea takimata sanctus est Lorem ipsum dolor sit amet.
','',1,3,0,7,'2004-05-12 11:54:06',62,'','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','','','',1,0,5,'','',0,8),(11,'Example FAQ Item 2','FAQ2','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et \r\n\r\ndolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut \r\n\r\nlabore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, \r\n\r\nno sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse \r\n\r\nmolestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\r\n\r\n\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh \r\n\r\neuismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci \r\n\r\ntation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit \r\n\r\nesse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent \r\n\r\nluptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option \r\n\r\ncongue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam \r\n\r\nnonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation \r\n\r\nullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\r\n\r\n\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita \r\n\r\nkasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam \r\n\r\nnonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea \r\n\r\nrebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing \r\n\r\nelitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et \r\n\r\ngubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\r\n\r\n\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\nConsetetur \r\n\r\nsadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et \r\n\r\njusto duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, \r\n\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et \r\n\r\naccusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor \r\n\r\nsit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At \r\n\r\nvero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.
',1,3,0,7,'2004-05-12 11:54:06',62,'Web master','2004-07-07 18:10:23',62,0,'0000-00-00 00:00:00','2004-01-01 00:00:00','0000-00-00 00:00:00','fruit/cherry.jpg|left||0\r\nfruit/peas.jpg|right||0\r\nfood/milk.jpg|left||0','','',1,0,5,'','',0,10); /*!40000 ALTER TABLE `mamfm_content` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_content_frontpage` -- DROP TABLE IF EXISTS `mamfm_content_frontpage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_content_frontpage` -- LOCK TABLES `mamfm_content_frontpage` WRITE; /*!40000 ALTER TABLE `mamfm_content_frontpage` DISABLE KEYS */; INSERT INTO `mamfm_content_frontpage` VALUES (1,1),(2,2),(3,3),(4,4),(5,5); /*!40000 ALTER TABLE `mamfm_content_frontpage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_content_rating` -- DROP TABLE IF EXISTS `mamfm_content_rating`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_content_rating` -- LOCK TABLES `mamfm_content_rating` WRITE; /*!40000 ALTER TABLE `mamfm_content_rating` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_content_rating` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_acl_aro` -- DROP TABLE IF EXISTS `mamfm_core_acl_aro`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_core_acl_aro` ( `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 (`aro_id`), UNIQUE KEY `mamfm_gacl_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `mamfm_gacl_hidden_aro` (`hidden`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_acl_aro` -- LOCK TABLES `mamfm_core_acl_aro` WRITE; /*!40000 ALTER TABLE `mamfm_core_acl_aro` DISABLE KEYS */; INSERT INTO `mamfm_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0); /*!40000 ALTER TABLE `mamfm_core_acl_aro` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_acl_aro_groups` -- DROP TABLE IF EXISTS `mamfm_core_acl_aro_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_core_acl_aro_groups` ( `group_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', PRIMARY KEY (`group_id`), KEY `parent_id_aro_groups` (`parent_id`), KEY `mamfm_gacl_parent_id_aro_groups` (`parent_id`), KEY `mamfm_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_acl_aro_groups` -- LOCK TABLES `mamfm_core_acl_aro_groups` WRITE; /*!40000 ALTER TABLE `mamfm_core_acl_aro_groups` DISABLE KEYS */; INSERT INTO `mamfm_core_acl_aro_groups` VALUES (17,0,'ROOT',1,22),(28,17,'USERS',2,21),(29,28,'Public Frontend',3,12),(18,29,'Registered',4,11),(19,18,'Author',5,10),(20,19,'Editor',6,9),(21,20,'Publisher',7,8),(30,28,'Public Backend',13,20),(23,30,'Manager',14,19),(24,23,'Administrator',15,18),(25,24,'Super Administrator',16,17); /*!40000 ALTER TABLE `mamfm_core_acl_aro_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_acl_aro_sections` -- DROP TABLE IF EXISTS `mamfm_core_acl_aro_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_core_acl_aro_sections` ( `section_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 (`section_id`), UNIQUE KEY `value_aro_sections` (`value`), UNIQUE KEY `mamfm_gacl_value_aro_sections` (`value`), KEY `hidden_aro_sections` (`hidden`), KEY `mamfm_gacl_hidden_aro_sections` (`hidden`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_acl_aro_sections` -- LOCK TABLES `mamfm_core_acl_aro_sections` WRITE; /*!40000 ALTER TABLE `mamfm_core_acl_aro_sections` DISABLE KEYS */; INSERT INTO `mamfm_core_acl_aro_sections` VALUES (10,'users',1,'Users',0); /*!40000 ALTER TABLE `mamfm_core_acl_aro_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_acl_groups_aro_map` -- DROP TABLE IF EXISTS `mamfm_core_acl_groups_aro_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_acl_groups_aro_map` -- LOCK TABLES `mamfm_core_acl_groups_aro_map` WRITE; /*!40000 ALTER TABLE `mamfm_core_acl_groups_aro_map` DISABLE KEYS */; INSERT INTO `mamfm_core_acl_groups_aro_map` VALUES (25,'',10); /*!40000 ALTER TABLE `mamfm_core_acl_groups_aro_map` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_log_items` -- DROP TABLE IF EXISTS `mamfm_core_log_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_log_items` -- LOCK TABLES `mamfm_core_log_items` WRITE; /*!40000 ALTER TABLE `mamfm_core_log_items` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_core_log_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_core_log_searches` -- DROP TABLE IF EXISTS `mamfm_core_log_searches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_core_log_searches` ( `search_term` varchar(128) NOT NULL DEFAULT '', `hits` int(11) unsigned NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_core_log_searches` -- LOCK TABLES `mamfm_core_log_searches` WRITE; /*!40000 ALTER TABLE `mamfm_core_log_searches` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_core_log_searches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_groups` -- DROP TABLE IF EXISTS `mamfm_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_groups` ( `id` tinyint(3) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_groups` -- LOCK TABLES `mamfm_groups` WRITE; /*!40000 ALTER TABLE `mamfm_groups` DISABLE KEYS */; INSERT INTO `mamfm_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special'); /*!40000 ALTER TABLE `mamfm_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_mambots` -- DROP TABLE IF EXISTS `mamfm_mambots`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_mambots` ( `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=20 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_mambots` -- LOCK TABLES `mamfm_mambots` WRITE; /*!40000 ALTER TABLE `mamfm_mambots` DISABLE KEYS */; INSERT INTO `mamfm_mambots` VALUES (1,'MOS Image','mosimage','content',0,-10000,1,1,0,0,'0000-00-00 00:00:00',''),(2,'MOS Pagination','mospaging','content',0,10000,1,1,0,0,'0000-00-00 00:00:00',''),(3,'Legacy Mambot Includer','legacybots','content',0,1,0,1,0,0,'0000-00-00 00:00:00',''),(4,'SEF','mossef','content',0,3,1,0,0,0,'0000-00-00 00:00:00',''),(5,'MOS Rating','mosvote','content',0,4,1,1,0,0,'0000-00-00 00:00:00',''),(6,'Search Content','content.searchbot','search',0,1,1,1,0,0,'0000-00-00 00:00:00',''),(7,'Search Weblinks','weblinks.searchbot','search',0,2,1,1,0,0,'0000-00-00 00:00:00',''),(8,'Code support','moscode','content',0,2,0,0,0,0,'0000-00-00 00:00:00',''),(9,'No WYSIWYG Editor','none','editors',0,0,1,1,0,0,'0000-00-00 00:00:00',''),(10,'TinyMCE WYSIWYG Editor','tinymce','editors',0,0,1,1,0,0,'0000-00-00 00:00:00','theme=advanced'),(11,'MOS Image Editor Button','mosimage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(12,'MOS Pagebreak Editor Button','mospage.btn','editors-xtd',0,0,1,0,0,0,'0000-00-00 00:00:00',''),(13,'Search Contacts','contacts.searchbot','search',0,3,1,1,0,0,'0000-00-00 00:00:00',''),(14,'Search Categories','categories.searchbot','search',0,4,1,0,0,0,'0000-00-00 00:00:00',''),(15,'Search Sections','sections.searchbot','search',0,5,1,0,0,0,'0000-00-00 00:00:00',''),(16,'Email Cloaking','mosemailcloak','content',0,5,1,0,0,0,'0000-00-00 00:00:00',''),(17,'GeSHi','geshi','content',0,5,0,0,0,0,'0000-00-00 00:00:00',''),(18,'Search Newsfeeds','newsfeeds.searchbot','search',0,6,1,0,0,0,'0000-00-00 00:00:00',''),(19,'Load Module Positions','mosloadposition','content',0,6,1,0,0,0,'0000-00-00 00:00:00',''); /*!40000 ALTER TABLE `mamfm_mambots` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_menu` -- DROP TABLE IF EXISTS `mamfm_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `menutype` varchar(25) DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `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, PRIMARY KEY (`id`), KEY `componentid` (`componentid`,`menutype`,`published`,`access`), KEY `menutype` (`menutype`) ) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_menu` -- LOCK TABLES `mamfm_menu` WRITE; /*!40000 ALTER TABLE `mamfm_menu` DISABLE KEYS */; INSERT INTO `mamfm_menu` VALUES (1,'mainmenu','Home','index.php?option=com_frontpage','components',1,0,10,0,1,0,'0000-00-00 00:00:00',0,0,0,3,'leading=1\r\nintro=2\r\nlink=1\r\nimage=1\r\npage_title=0\r\nheader=Welcome to \r\n\r\nthe Frontpage\r\norderby_sec=front\r\nprint=0\r\npdf=0\r\nemail=0\r\nback_button=0'),(2,'mainmenu','News','index.php?option=com_content&task=section&id=1','content_section',1,0,1,0,3,0,'0000-00-00 00:00:00',0,0,0,3,''),(3,'mainmenu','Contact Us','index.php?option=com_contact','components',1,0,7,0,6,0,'0000-00-00 00:00:00',0,0,0,3,''),(23,'mainmenu','Links','index.php?option=com_weblinks','components',1,0,4,0,5,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\r\n\r\n\nitem_description=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='),(5,'mainmenu','Search','index.php?option=com_search','components',1,0,16,0,7,0,'0000-00-00 00:00:00',0,0,0,3,''),(6,'mainmenu','Joomla! License','index.php?option=com_content&task=view&id=5','content_typed',1,0,11,0,2,0,'0000-00-00 00:00:00',0,0,0,0,''),(7,'mainmenu','News Feeds','index.php?option=com_newsfeeds','components',1,0,12,0,8,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-\r\n\r\n1\npageclass_sfx=\nback_button=\npage_title=1\nheader='),(8,'mainmenu','Wrapper','index.php?option=com_wrapper','wrapper',1,0,0,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-\r\n\r\n1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=0\nurl=www.joomla.org'),(9,'mainmenu','Blog','index.php?option=com_content&task=blogsection&id=0','content_blog_section',1,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog of all section with no images\r\n\r\n\npage_title=1\nleading=0\nintro=6\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\r\n\r\n\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\r\n\r\n\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid='),(10,'othermenu','Joomla! Home','http://www.joomla.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(11,'othermenu','Joomla! Forums','http://forum.joomla.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(12,'othermenu','OSM Home','http://www.opensourcematters.org','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(24,'othermenu','Administrator','administrator/','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),(21,'usermenu','Your Details','index.php?option=com_user&task=UserDetails','url',1,0,0,0,1,0,'2000-00-00 00:00:00',0,0,1,3,''),(13,'usermenu','Submit News','index.php?option=com_content&task=new§ionid=1&Itemid=0','url',1,0,0,0,2,0,'2000-00-00 00:00:00',0,0,1,2,''),(14,'usermenu','Submit WebLink','index.php?option=com_weblinks&task=new','url',1,0,0,0,4,0,'2000-00-00 00:00:00',0,0,1,2,''),(15,'usermenu','Check-In My Items','index.php?option=com_user&task=CheckIn','url',1,0,0,0,5,0,'0000-00-00 00:00:00',0,0,1,2,''),(16,'usermenu','Logout','index.php?option=com_login','components',1,0,15,0,5,0,'0000-00-00 00:00:00',0,0,1,3,''),(17,'topmenu','Home','index.php','url',1,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(18,'topmenu','Contact Us','index.php?option=com_contact&Itemid=3','url',1,0,0,0,2,0,'0000-00-00 00:00:00',0,0,0,3,''),(19,'topmenu','News','index.php?option=com_content&task=section&id=1&Itemid=2','url',1,0,0,0,3,0,'0000-00-00 00:00:00',0,0,0,3,''),(20,'topmenu','Links','index.php?option=com_weblinks&Itemid=23','url',1,0,0,0,4,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1'),(25,'mainmenu','FAQs','index.php?option=com_content&task=category§ionid=3&id=7','content_category',1,0,7,0,9,0,'0000-00-00 00:00:00',0,0,0,0,'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\ntitle=1\nhits=\r\n\r\n\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\r\n\r\n\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1'); /*!40000 ALTER TABLE `mamfm_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_messages` -- DROP TABLE IF EXISTS `mamfm_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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` varchar(230) NOT NULL DEFAULT '', `message` text NOT NULL, PRIMARY KEY (`message_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_messages` -- LOCK TABLES `mamfm_messages` WRITE; /*!40000 ALTER TABLE `mamfm_messages` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_messages_cfg` -- DROP TABLE IF EXISTS `mamfm_messages_cfg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_messages_cfg` -- LOCK TABLES `mamfm_messages_cfg` WRITE; /*!40000 ALTER TABLE `mamfm_messages_cfg` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_messages_cfg` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_modules` -- DROP TABLE IF EXISTS `mamfm_modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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(10) 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', PRIMARY KEY (`id`), KEY `published` (`published`,`access`), KEY `newsfeeds` (`module`,`published`) ) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_modules` -- LOCK TABLES `mamfm_modules` WRITE; /*!40000 ALTER TABLE `mamfm_modules` DISABLE KEYS */; INSERT INTO `mamfm_modules` VALUES (1,'Polls','',1,'right',0,'0000-00-00 00:00:00',1,'mod_poll',0,0,1,'',0,0),(2,'User Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,1,1,'menutype=usermenu',1,0),(3,'Main Menu','',1,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,1,'menutype=mainmenu',1,0),(4,'Login Form','',3,'left',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,0),(5,'Syndicate','',4,'left',0,'0000-00-00 00:00:00',1,'mod_rssfeed',0,0,1,'',1,0),(6,'Latest News','',4,'user1',0,'0000-00-00 00:00:00',1,'mod_latestnews',0,0,1,'',1,0),(7,'Statistics','',4,'left',0,'0000-00-00 00:00:00',0,'mod_stats',0,0,1,'serverinfo=1\nsiteinfo=1\ncounter=1\nincrease=0\nmoduleclass_sfx=',0,0),(8,'Who\'s Online','',1,'right',0,'0000-00-00 00:00:00',1,'mod_whosonline',0,0,1,'online=1\nusers=1\nmoduleclass_sfx=',0,0),(9,'Popular','',6,'user2',0,'0000-00-00 00:00:00',1,'mod_mostread',0,0,1,'',0,0),(10,'Template Chooser','',6,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),(11,'Archive','',7,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),(12,'Sections','',8,'left',0,'0000-00-00 00:00:00',0,'mod_sections',0,0,1,'',1,0),(13,'Newsflash','',1,'top',0,'0000-00-00 00:00:00',1,'mod_newsflash',0,0,1,'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=',0,0),(14,'Related Items','',9,'left',0,'0000-00-00 00:00:00',0,'mod_related_items',0,0,1,'',0,0),(15,'Search','',1,'user4',0,'0000-00-00 00:00:00',1,'mod_search',0,0,0,'',0,0),(16,'Random Image','',9,'right',0,'0000-00-00 00:00:00',1,'mod_random_image',0,0,1,'',0,0),(17,'Top Menu','',1,'user3',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\r\n\r\n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\r\n\r\n\nindent_image1=0\nindent_image2=0\nindent_image3=0\nindent_image4=0\nindent_image5=0\nindent_image6=0',1,0),(18,'Banners','',1,'banner',0,'0000-00-00 00:00:00',1,'mod_banners',0,0,0,'banner_cids=\nmoduleclass_sfx=\n',1,0),(19,'Components','',2,'cpanel',0,'0000-00-00 00:00:00',1,'mod_components',0,99,1,'',1,1),(20,'Popular','',3,'cpanel',0,'0000-00-00 00:00:00',1,'mod_popular',0,99,1,'',0,1),(21,'Latest Items','',4,'cpanel',0,'0000-00-00 00:00:00',1,'mod_latest',0,99,1,'',0,1),(22,'Menu Stats','',5,'cpanel',0,'0000-00-00 00:00:00',1,'mod_stats',0,99,1,'',0,1),(23,'Unread Messages','',1,'header',0,'0000-00-00 00:00:00',1,'mod_unread',0,99,1,'',1,1),(24,'Online Users','',2,'header',0,'0000-00-00 00:00:00',1,'mod_online',0,99,1,'',1,1),(25,'Full Menu','',1,'top',0,'0000-00-00 00:00:00',1,'mod_fullmenu',0,99,1,'',1,1),(26,'Pathway','',1,'pathway',0,'0000-00-00 00:00:00',1,'mod_pathway',0,99,1,'',1,1),(27,'Toolbar','',1,'toolbar',0,'0000-00-00 00:00:00',1,'mod_toolbar',0,99,1,'',1,1),(28,'System Message','',1,'inset',0,'0000-00-00 00:00:00',1,'mod_mosmsg',0,99,1,'',1,1),(29,'Quick Icons','',1,'icon',0,'0000-00-00 00:00:00',1,'mod_quickicon',0,99,1,'',1,1),(30,'Other Menu','',2,'left',0,'0000-00-00 00:00:00',1,'mod_mainmenu',0,0,0,'menutype=othermenu\nmenu_style=vert_indent\r\n\r\n\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\r\n\r\n\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=',0,0),(31,'Wrapper','',10,'left',0,'0000-00-00 00:00:00',0,'mod_wrapper',0,0,1,'',0,0),(32,'Logged','',0,'cpanel',0,'0000-00-00 00:00:00',1,'mod_logged',0,99,1,'',0,1); /*!40000 ALTER TABLE `mamfm_modules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_modules_menu` -- DROP TABLE IF EXISTS `mamfm_modules_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_modules_menu` -- LOCK TABLES `mamfm_modules_menu` WRITE; /*!40000 ALTER TABLE `mamfm_modules_menu` DISABLE KEYS */; INSERT INTO `mamfm_modules_menu` VALUES (1,1),(2,0),(3,0),(4,1),(5,1),(6,1),(6,2),(6,4),(6,27),(6,36),(8,1),(9,1),(9,2),(9,4),(9,27),(9,36),(10,1),(13,0),(15,0),(17,0),(18,0),(30,0); /*!40000 ALTER TABLE `mamfm_modules_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_newsfeeds` -- DROP TABLE IF EXISTS `mamfm_newsfeeds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_newsfeeds` ( `catid` int(11) NOT NULL DEFAULT '0', `id` int(11) NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `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', PRIMARY KEY (`id`), KEY `published` (`published`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_newsfeeds` -- LOCK TABLES `mamfm_newsfeeds` WRITE; /*!40000 ALTER TABLE `mamfm_newsfeeds` DISABLE KEYS */; INSERT INTO `mamfm_newsfeeds` VALUES (4,1,'Joomla! - Official News','http://www.joomla.org/index.php?\r\n\r\noption=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1','',1,5,3600,0,'0000-00-00 00:00:00',8),(4,2,'Joomla! - Community News','http://www.joomla.org/index.php?\r\n\r\noption=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33','',1,5,3600,0,'0000-00-00 00:00:00',9),(4,3,'OpenSourceMatters','http://www.opensourcematters.org/index2.php?option=com_rss&feed=RSS2.0&no_html=1','',1,5,3600,0,'0000-00-00 00:00:00',10),(10,4,'Linux Today','http://linuxtoday.com/backend/my-netscape.rdf','',1,3,3600,0,'0000-00-00 00:00:00',1),(5,5,'Business News','http://headlines.internet.com/internetnews/bus-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',2),(11,6,'Web Developer News','http://headlines.internet.com/internetnews/wd-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',3),(10,7,'Linux Central:New Products','http://linuxcentral.com/backend/lcnew.rdf','',1,3,3600,0,'0000-00-00 00:00:00',4),(10,8,'Linux Central:Best Selling','http://linuxcentral.com/backend/lcbestns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',5),(10,9,'Linux Central:Daily Specials','http://linuxcentral.com/backend/lcspecialns.rdf','',1,3,3600,0,'0000-00-00 00:00:00',6),(9,10,'Internet:Finance News','http://headlines.internet.com/internetnews/fina-news/news.rss','',1,3,3600,0,'0000-00-00 00:00:00',7); /*!40000 ALTER TABLE `mamfm_newsfeeds` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_poll_data` -- DROP TABLE IF EXISTS `mamfm_poll_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_poll_data` ( `id` int(11) NOT NULL AUTO_INCREMENT, `pollid` int(4) 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 AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_poll_data` -- LOCK TABLES `mamfm_poll_data` WRITE; /*!40000 ALTER TABLE `mamfm_poll_data` DISABLE KEYS */; INSERT INTO `mamfm_poll_data` VALUES (1,14,'Absolutely simple',1),(2,14,'Reasonably easy',0),(3,14,'Not straight-forward but I worked it out',0),(4,14,'I had to install extra server stuff',0),(5,14,'I had no idea and got my friend to do it',0),(6,14,'My dog ran away with the README ...',0),(7,14,'',0),(8,14,'',0),(9,14,'',0),(10,14,'',0),(11,14,'',0),(12,14,'',0); /*!40000 ALTER TABLE `mamfm_poll_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_poll_date` -- DROP TABLE IF EXISTS `mamfm_poll_date`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_poll_date` -- LOCK TABLES `mamfm_poll_date` WRITE; /*!40000 ALTER TABLE `mamfm_poll_date` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_poll_date` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_poll_menu` -- DROP TABLE IF EXISTS `mamfm_poll_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_poll_menu` -- LOCK TABLES `mamfm_poll_menu` WRITE; /*!40000 ALTER TABLE `mamfm_poll_menu` DISABLE KEYS */; INSERT INTO `mamfm_poll_menu` VALUES (14,1); /*!40000 ALTER TABLE `mamfm_poll_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_polls` -- DROP TABLE IF EXISTS `mamfm_polls`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_polls` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) 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 AUTO_INCREMENT=15 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_polls` -- LOCK TABLES `mamfm_polls` WRITE; /*!40000 ALTER TABLE `mamfm_polls` DISABLE KEYS */; INSERT INTO `mamfm_polls` VALUES (14,'This Joomla! \r\n\r\ninstallation was ....',0,0,'2000-00-00 00:00:00',1,0,86400); /*!40000 ALTER TABLE `mamfm_polls` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_sections` -- DROP TABLE IF EXISTS `mamfm_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_sections` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(50) NOT NULL DEFAULT '', `name` varchar(255) NOT NULL DEFAULT '', `image` varchar(100) NOT NULL DEFAULT '', `scope` varchar(50) NOT NULL DEFAULT '', `image_position` varchar(10) 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=4 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_sections` -- LOCK TABLES `mamfm_sections` WRITE; /*!40000 ALTER TABLE `mamfm_sections` DISABLE KEYS */; INSERT INTO `mamfm_sections` VALUES (1,'News','The News','articles.jpg','content','right','Select a news topic \r\n\r\nfrom the list below, then select a news article to read.',1,0,'0000-00-00 00:00:00',1,0,1,''),(2,'Newsflashes','Newsflashes','','content','left','',1,0,'0000-00-00 00:00:00',2,0,1,''),(3,'FAQs','Frequently Asked Questions','pastarchives.jpg','content','left','From the list below choose one of our FAQs topics, then select an \r\n\r\nFAQ to read. If you have a question which is not in this section, please contact us.',1,0,'0000-00-00 00:00:00',2,0,1,''); /*!40000 ALTER TABLE `mamfm_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_session` -- DROP TABLE IF EXISTS `mamfm_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_session` ( `username` varchar(50) 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', PRIMARY KEY (`session_id`), KEY `whosonline` (`guest`,`usertype`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_session` -- LOCK TABLES `mamfm_session` WRITE; /*!40000 ALTER TABLE `mamfm_session` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_stats_agents` -- DROP TABLE IF EXISTS `mamfm_stats_agents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_stats_agents` -- LOCK TABLES `mamfm_stats_agents` WRITE; /*!40000 ALTER TABLE `mamfm_stats_agents` DISABLE KEYS */; /*!40000 ALTER TABLE `mamfm_stats_agents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_template_positions` -- DROP TABLE IF EXISTS `mamfm_template_positions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_template_positions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `position` varchar(10) NOT NULL DEFAULT '', `description` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_template_positions` -- LOCK TABLES `mamfm_template_positions` WRITE; /*!40000 ALTER TABLE `mamfm_template_positions` DISABLE KEYS */; INSERT INTO `mamfm_template_positions` VALUES (1,'left',''),(2,'right',''),(3,'top',''),(4,'bottom',''),(5,'inset',''),(6,'banner',''),(7,'header',''),(8,'footer',''),(9,'newsflash',''),(10,'legals',''),(11,'pathway',''),(12,'toolbar',''),(13,'cpanel',''),(14,'user1',''),(15,'user2',''),(16,'user3',''),(17,'user4',''),(18,'user5',''),(19,'user6',''),(20,'user7',''),(21,'user8',''),(22,'user9',''),(23,'advert1',''),(24,'advert2',''),(25,'advert3',''),(26,'icon',''),(27,'debug',''); /*!40000 ALTER TABLE `mamfm_template_positions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_templates_menu` -- DROP TABLE IF EXISTS `mamfm_templates_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_templates_menu` ( `template` varchar(50) NOT NULL DEFAULT '', `menuid` int(11) NOT NULL DEFAULT '0', `client_id` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`template`,`menuid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_templates_menu` -- LOCK TABLES `mamfm_templates_menu` WRITE; /*!40000 ALTER TABLE `mamfm_templates_menu` DISABLE KEYS */; INSERT INTO `mamfm_templates_menu` VALUES ('corporate',0,0),('joomla_admin',0,1); /*!40000 ALTER TABLE `mamfm_templates_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_users` -- DROP TABLE IF EXISTS `mamfm_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL DEFAULT '', `username` varchar(25) 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`) ) ENGINE=MyISAM AUTO_INCREMENT=63 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_users` -- LOCK TABLES `mamfm_users` WRITE; /*!40000 ALTER TABLE `mamfm_users` DISABLE KEYS */; INSERT INTO `mamfm_users` VALUES (62,'Administrator','admin','mam@heimam.at','5a9361b28ee51795f1e82d9054919034','Super Administrator',0,1,25,'2006-06-04 21:30:38','2006-06-04 21:44:45','',''); /*!40000 ALTER TABLE `mamfm_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_usertypes` -- DROP TABLE IF EXISTS `mamfm_usertypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_usertypes` ( `id` tinyint(3) unsigned NOT NULL DEFAULT '0', `name` varchar(50) NOT NULL DEFAULT '', `mask` varchar(11) NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_usertypes` -- LOCK TABLES `mamfm_usertypes` WRITE; /*!40000 ALTER TABLE `mamfm_usertypes` DISABLE KEYS */; INSERT INTO `mamfm_usertypes` VALUES (0,'superadministrator',''),(1,'administrator',''),(2,'editor',''),(3,'user',''),(4,'author',''),(5,'publisher',''),(6,'manager',''); /*!40000 ALTER TABLE `mamfm_usertypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `mamfm_weblinks` -- DROP TABLE IF EXISTS `mamfm_weblinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `mamfm_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 '', `url` varchar(250) NOT NULL DEFAULT '', `description` varchar(250) NOT NULL DEFAULT '', `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 AUTO_INCREMENT=6 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `mamfm_weblinks` -- LOCK TABLES `mamfm_weblinks` WRITE; /*!40000 ALTER TABLE `mamfm_weblinks` DISABLE KEYS */; INSERT INTO `mamfm_weblinks` VALUES (1,2,0,'Joomla!','http://www.joomla.org','Home of Joomla!','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'),(2,2,0,'php.net','http://www.php.net','The language that Joomla! is developed in','2004-07-07 11:33:24',0,1,0,'0000-00-00 00:00:00',3,0,1,''),(3,2,0,'MySQL','http://www.mysql.com','The database that Joomla! uses','2004-07-07 10:18:31',0,1,0,'0000-00-00 00:00:00',5,0,1,''),(4,2,0,'OpenSourceMatters','http://www.opensourcematters.org','Home of OSM','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'),(5,2,0,'Joomla! - Forums','http://forum.joomla.org','Joomla! Forums','2005-02-14 15:19:02',2,1,0,'0000-00-00 00:00:00',1,0,1,'target=0'); /*!40000 ALTER TABLE `mamfm_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 2024-02-01 2:00:07