-- MySQL dump 10.13 Distrib 5.1.48, for Win32 (ia32)
--
-- Host: localhost Database: joomla_rodam
-- ------------------------------------------------------
-- Server version 5.1.48-community
/*!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 `rodam_banner`
--
DROP TABLE IF EXISTS `rodam_banner`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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 `rodam_banner`
--
LOCK TABLES `rodam_banner` WRITE;
/*!40000 ALTER TABLE `rodam_banner` DISABLE KEYS */;
INSERT INTO `rodam_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,48,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 `rodam_banner` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_bannerclient`
--
DROP TABLE IF EXISTS `rodam_bannerclient`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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 `rodam_bannerclient`
--
LOCK TABLES `rodam_bannerclient` WRITE;
/*!40000 ALTER TABLE `rodam_bannerclient` DISABLE KEYS */;
INSERT INTO `rodam_bannerclient` VALUES (1,'Open Source Matters','Administrator','admin@opensourcematters.org','',0,'00:00:00',NULL);
/*!40000 ALTER TABLE `rodam_bannerclient` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_bannerfinish`
--
DROP TABLE IF EXISTS `rodam_bannerfinish`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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 `rodam_bannerfinish`
--
LOCK TABLES `rodam_bannerfinish` WRITE;
/*!40000 ALTER TABLE `rodam_bannerfinish` DISABLE KEYS */;
/*!40000 ALTER TABLE `rodam_bannerfinish` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_categories`
--
DROP TABLE IF EXISTS `rodam_categories`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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 `rodam_categories`
--
LOCK TABLES `rodam_categories` WRITE;
/*!40000 ALTER TABLE `rodam_categories` DISABLE KEYS */;
INSERT INTO `rodam_categories` VALUES (1,0,'Latest','Latest News','taking_notes.jpg','1','left','The latest 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 `rodam_categories` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_components`
--
DROP TABLE IF EXISTS `rodam_components`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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=45 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rodam_components`
--
LOCK TABLES `rodam_components` WRITE;
/*!40000 ALTER TABLE `rodam_components` DISABLE KEYS */;
INSERT INTO `rodam_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 `rodam_components` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_contact_details`
--
DROP TABLE IF EXISTS `rodam_contact_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `rodam_contact_details`
--
LOCK TABLES `rodam_contact_details` WRITE;
/*!40000 ALTER TABLE `rodam_contact_details` DISABLE KEYS */;
INSERT INTO `rodam_contact_details` VALUES (1,'Admin','Administrator','(not disclosed)','Vienna','Vienna','Austria','1100','(not disclosed)','n/a','','key.jpg','top','mam@heimam.at',0,1,0,'0000-00-00 00:00:00',1,'menu_image=-1\npageclass_sfx=\nprint=\nback_button=\nname=1\nposition=1\nemail=0\nstreet_address=1\nsuburb=1\nstate=1\ncountry=1\npostcode=1\ntelephone=1\nfax=1\nmisc=1\nimage=1\nvcard=0\nemail_description=1\nemail_description_text=\nemail_form=1\nemail_copy=0\ndrop_down=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=',62,12,0);
/*!40000 ALTER TABLE `rodam_contact_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `rodam_content`
--
DROP TABLE IF EXISTS `rodam_content`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `rodam_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 `rodam_content`
--
LOCK TABLES `rodam_content` WRITE;
/*!40000 ALTER TABLE `rodam_content` DISABLE KEYS */;
INSERT INTO `rodam_content` VALUES (1,'Welcome to Joomla!','Welcome','If you\'ve read anything at all 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 really, I mean really, complicated and lastly Portals are absolutely, outrageously, often unaffordably expensive.
{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. Joomla! has been developed for the masses. It\'s licensed under the GNU/GPL license, easy to install and administer and reliable. Joomla! doesn\'t even 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 templates on which it runs are Copyright 2005 Open Source Matters. All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.
If you want to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU General 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\'.
','',0,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=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=',1,0,11,'','',0,12),(6,'Example News Item 1','News1','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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 sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum.','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\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\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 accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\nNam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\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 eos et accusam et justo 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, consetetur sadipscing 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 justo 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, consetetur sadipscing elitr, 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 gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\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 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 sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. 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 sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, 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 ipsum dolor sit amet.
',0,1,0,1,'2004-07-07 11:54:06',62,'','2008-10-26 20:50:38',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,5),(7,'Example News Item 2','News2','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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 sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt 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 gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod 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 clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',0,1,0,1,'2004-07-07 11:54:06',62,'','2008-10-26 20:50:39',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,3),(8,'Example News Item 3','News3','{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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 sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt 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 gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod 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 clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',0,1,0,1,'2004-04-12 11:54:06',62,'','2008-10-26 20:50:41',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 dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mospagebreak}{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\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 accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\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 eos et accusam et justo 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, consetetur sadipscing 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 justo 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, consetetur sadipscing elitr, 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 gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\n{mospagebreak}Consetetur sadipscing 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 justo 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, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. 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 sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, 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 ipsum dolor sit amet.
',0,1,0,1,'2004-07-07 11:54:06',62,'','2008-10-26 20:50:41',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,7),(10,'Example FAQ Item 1','FAQ1','Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','',0,3,0,7,'2004-05-12 11:54:06',62,'','2008-10-26 20:50:50',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 dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore 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, no sea takimata sanctus est Lorem ipsum dolor sit amet.
','{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\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 accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\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 eos et accusam et justo 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, consetetur sadipscing 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 justo 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, consetetur sadipscing elitr, 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 gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\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 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 sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. 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 sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, 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 ipsum dolor sit amet.
',0,3,0,7,'2004-05-12 11:54:06',62,'Web master','2008-10-26 20:50:48',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,12); /*!40000 ALTER TABLE `rodam_content` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_content_frontpage` -- DROP TABLE IF EXISTS `rodam_content_frontpage`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_content_frontpage` -- LOCK TABLES `rodam_content_frontpage` WRITE; /*!40000 ALTER TABLE `rodam_content_frontpage` DISABLE KEYS */; INSERT INTO `rodam_content_frontpage` VALUES (1,1),(5,2); /*!40000 ALTER TABLE `rodam_content_frontpage` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_content_rating` -- DROP TABLE IF EXISTS `rodam_content_rating`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_content_rating` -- LOCK TABLES `rodam_content_rating` WRITE; /*!40000 ALTER TABLE `rodam_content_rating` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_content_rating` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_acl_aro` -- DROP TABLE IF EXISTS `rodam_core_acl_aro`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_gacl_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `rodam_gacl_hidden_aro` (`hidden`) ) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_core_acl_aro` -- LOCK TABLES `rodam_core_acl_aro` WRITE; /*!40000 ALTER TABLE `rodam_core_acl_aro` DISABLE KEYS */; INSERT INTO `rodam_core_acl_aro` VALUES (10,'users','62',0,'Administrator',0),(11,'users','63',0,'Markus A. Mascelli',0); /*!40000 ALTER TABLE `rodam_core_acl_aro` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_acl_aro_groups` -- DROP TABLE IF EXISTS `rodam_core_acl_aro_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_gacl_parent_id_aro_groups` (`parent_id`), KEY `rodam_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 `rodam_core_acl_aro_groups` -- LOCK TABLES `rodam_core_acl_aro_groups` WRITE; /*!40000 ALTER TABLE `rodam_core_acl_aro_groups` DISABLE KEYS */; INSERT INTO `rodam_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 `rodam_core_acl_aro_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_acl_aro_sections` -- DROP TABLE IF EXISTS `rodam_core_acl_aro_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_gacl_value_aro_sections` (`value`), KEY `hidden_aro_sections` (`hidden`), KEY `rodam_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 `rodam_core_acl_aro_sections` -- LOCK TABLES `rodam_core_acl_aro_sections` WRITE; /*!40000 ALTER TABLE `rodam_core_acl_aro_sections` DISABLE KEYS */; INSERT INTO `rodam_core_acl_aro_sections` VALUES (10,'users',1,'Users',0); /*!40000 ALTER TABLE `rodam_core_acl_aro_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_acl_groups_aro_map` -- DROP TABLE IF EXISTS `rodam_core_acl_groups_aro_map`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_core_acl_groups_aro_map` -- LOCK TABLES `rodam_core_acl_groups_aro_map` WRITE; /*!40000 ALTER TABLE `rodam_core_acl_groups_aro_map` DISABLE KEYS */; INSERT INTO `rodam_core_acl_groups_aro_map` VALUES (18,'',11),(25,'',10); /*!40000 ALTER TABLE `rodam_core_acl_groups_aro_map` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_log_items` -- DROP TABLE IF EXISTS `rodam_core_log_items`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_core_log_items` -- LOCK TABLES `rodam_core_log_items` WRITE; /*!40000 ALTER TABLE `rodam_core_log_items` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_core_log_items` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_core_log_searches` -- DROP TABLE IF EXISTS `rodam_core_log_searches`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_core_log_searches` -- LOCK TABLES `rodam_core_log_searches` WRITE; /*!40000 ALTER TABLE `rodam_core_log_searches` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_core_log_searches` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_groups` -- DROP TABLE IF EXISTS `rodam_groups`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_groups` -- LOCK TABLES `rodam_groups` WRITE; /*!40000 ALTER TABLE `rodam_groups` DISABLE KEYS */; INSERT INTO `rodam_groups` VALUES (0,'Public'),(1,'Registered'),(2,'Special'); /*!40000 ALTER TABLE `rodam_groups` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_mambots` -- DROP TABLE IF EXISTS `rodam_mambots`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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=23 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_mambots` -- LOCK TABLES `rodam_mambots` WRITE; /*!40000 ALTER TABLE `rodam_mambots` DISABLE KEYS */; INSERT INTO `rodam_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',''),(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 `rodam_mambots` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_menu` -- DROP TABLE IF EXISTS `rodam_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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=32 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_menu` -- LOCK TABLES `rodam_menu` WRITE; /*!40000 ALTER TABLE `rodam_menu` DISABLE KEYS */; INSERT INTO `rodam_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 the 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,7,0,'0000-00-00 00:00:00',0,0,0,3,''),(23,'mainmenu','Links','index.php?option=com_weblinks','components',1,0,4,0,6,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=\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,2,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',0,0,11,0,9,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,4,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader='),(8,'mainmenu','Wrapper','index.php?option=com_wrapper','wrapper',0,0,0,0,10,0,'0000-00-00 00:00:00',0,0,0,3,'menu_image=-1\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,5,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\npage_title=1\nleading=0\nintro=6\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid='),(10,'othermenu','Joomla! Home','http://www.joomla.org','url',0,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(11,'othermenu','Joomla! Forums','http://forum.joomla.org','url',0,0,0,0,1,0,'0000-00-00 00:00:00',0,0,0,3,''),(12,'othermenu','OSM Home','http://www.opensourcematters.org','url',0,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,6,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,7,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,8,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',0,0,0,0,9,0,'0000-00-00 00:00:00',0,0,1,2,''),(16,'usermenu','Logout','index.php?option=com_login','components',1,0,15,0,10,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',0,0,7,0,8,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=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1'),(26,'usermenu','Gallery','index.php?option=com_ponygallery','components',-2,0,25,0,2,0,'0000-00-00 00:00:00',0,0,1,0,''),(27,'usermenu','Shoutbox','index.php?option=com_shoutit','components',-2,0,32,0,3,0,'0000-00-00 00:00:00',0,0,1,0,''),(28,'usermenu','Contact List','index.php?option=com_steckbriefe','components',-2,0,36,0,4,0,'0000-00-00 00:00:00',0,0,1,0,'menu_image=-1\npageclass_sfx=\nback_button=1\npage_title=1\nheader=\nother_cat_section=1\nother_cat=1\ncat_description=1\ncat_items=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nheadings=1\nspitzname=1\ngeburtsdatum=1\nemail=0\neigenschaften=1\nzusatz2=1\nzusatz1=1'),(29,'usermenu','Gallery','index.php?option=com_paxgallery','components',-2,0,39,0,1,0,'0000-00-00 00:00:00',0,0,1,0,''),(30,'usermenu','Gallery','index.php?option=com_zoom','components',-2,0,44,0,0,0,'0000-00-00 00:00:00',0,0,1,0,''),(31,'usermenu','Upload Media','index.php?option=com_zoom&page=admin','url',-2,0,0,0,0,0,'0000-00-00 00:00:00',0,0,1,2,''); /*!40000 ALTER TABLE `rodam_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_messages` -- DROP TABLE IF EXISTS `rodam_messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_messages` -- LOCK TABLES `rodam_messages` WRITE; /*!40000 ALTER TABLE `rodam_messages` DISABLE KEYS */; INSERT INTO `rodam_messages` VALUES (1,63,62,0,'2008-10-26 21:04:40',1,0,'New Picture Uploaded','A new content item has been submitted by mam titled September 19 to 22 2008.'); /*!40000 ALTER TABLE `rodam_messages` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_messages_cfg` -- DROP TABLE IF EXISTS `rodam_messages_cfg`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_messages_cfg` -- LOCK TABLES `rodam_messages_cfg` WRITE; /*!40000 ALTER TABLE `rodam_messages_cfg` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_messages_cfg` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_modules` -- DROP TABLE IF EXISTS `rodam_modules`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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=38 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_modules` -- LOCK TABLES `rodam_modules` WRITE; /*!40000 ALTER TABLE `rodam_modules` DISABLE KEYS */; INSERT INTO `rodam_modules` VALUES (1,'Polls','',1,'right',0,'0000-00-00 00:00:00',1,'mod_poll',0,0,1,'',0,0),(2,'User Menu','',4,'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','',5,'left',0,'0000-00-00 00:00:00',1,'mod_login',0,0,1,'',1,0),(5,'Syndicate','',7,'left',0,'0000-00-00 00:00:00',0,'mod_rssfeed',0,0,1,'',1,0),(6,'Latest News','',2,'user1',0,'0000-00-00 00:00:00',1,'mod_latestnews',0,0,1,'',1,0),(7,'Statistics','',6,'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','',2,'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',0,'mod_mostread',0,0,1,'',0,0),(10,'Template Chooser','',8,'left',0,'0000-00-00 00:00:00',0,'mod_templatechooser',0,0,1,'show_preview=1',0,0),(11,'Archive','',9,'left',0,'0000-00-00 00:00:00',0,'mod_archive',0,0,1,'',1,0),(12,'Sections','',10,'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','',11,'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','',4,'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',0,'mod_mainmenu',0,0,0,'menutype=topmenu\nmenu_style=list_flat\nmenu_images=n\nmenu_images_align=left\nexpand_menu=n\nclass_sfx=-nav\nmoduleclass_sfx=\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\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=',0,0),(31,'Wrapper','',12,'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 `rodam_modules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_modules_menu` -- DROP TABLE IF EXISTS `rodam_modules_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_modules_menu` -- LOCK TABLES `rodam_modules_menu` WRITE; /*!40000 ALTER TABLE `rodam_modules_menu` DISABLE KEYS */; INSERT INTO `rodam_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 `rodam_modules_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_newsfeeds` -- DROP TABLE IF EXISTS `rodam_newsfeeds`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_newsfeeds` -- LOCK TABLES `rodam_newsfeeds` WRITE; /*!40000 ALTER TABLE `rodam_newsfeeds` DISABLE KEYS */; INSERT INTO `rodam_newsfeeds` VALUES (4,1,'Joomla! - Official News','http://www.joomla.org/index.php?option=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?option=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 `rodam_newsfeeds` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_poll_data` -- DROP TABLE IF EXISTS `rodam_poll_data`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_poll_data` -- LOCK TABLES `rodam_poll_data` WRITE; /*!40000 ALTER TABLE `rodam_poll_data` DISABLE KEYS */; INSERT INTO `rodam_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 `rodam_poll_data` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_poll_date` -- DROP TABLE IF EXISTS `rodam_poll_date`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_poll_date` -- LOCK TABLES `rodam_poll_date` WRITE; /*!40000 ALTER TABLE `rodam_poll_date` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_poll_date` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_poll_menu` -- DROP TABLE IF EXISTS `rodam_poll_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_poll_menu` -- LOCK TABLES `rodam_poll_menu` WRITE; /*!40000 ALTER TABLE `rodam_poll_menu` DISABLE KEYS */; INSERT INTO `rodam_poll_menu` VALUES (14,1); /*!40000 ALTER TABLE `rodam_poll_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_polls` -- DROP TABLE IF EXISTS `rodam_polls`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_polls` -- LOCK TABLES `rodam_polls` WRITE; /*!40000 ALTER TABLE `rodam_polls` DISABLE KEYS */; INSERT INTO `rodam_polls` VALUES (14,'This Joomla! installation was ....',0,0,'2000-00-00 00:00:00',1,0,86400); /*!40000 ALTER TABLE `rodam_polls` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_rsgallery2_acl` -- DROP TABLE IF EXISTS `rodam_rsgallery2_acl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_rsgallery2_acl` ( `id` int(11) NOT NULL AUTO_INCREMENT, `gallery_id` int(11) NOT NULL DEFAULT '0', `parent_id` int(11) NOT NULL DEFAULT '0', `public_view` tinyint(1) NOT NULL DEFAULT '1', `public_up_mod_img` tinyint(1) NOT NULL DEFAULT '0', `public_del_img` tinyint(1) NOT NULL DEFAULT '0', `public_create_mod_gal` tinyint(1) NOT NULL DEFAULT '0', `public_del_gal` tinyint(1) NOT NULL DEFAULT '0', `public_vote_view` tinyint(1) NOT NULL DEFAULT '1', `public_vote_vote` tinyint(1) NOT NULL DEFAULT '0', `registered_view` tinyint(1) NOT NULL DEFAULT '1', `registered_up_mod_img` tinyint(1) NOT NULL DEFAULT '1', `registered_del_img` tinyint(1) NOT NULL DEFAULT '0', `registered_create_mod_gal` tinyint(1) NOT NULL DEFAULT '1', `registered_del_gal` tinyint(1) NOT NULL DEFAULT '0', `registered_vote_view` tinyint(1) NOT NULL DEFAULT '1', `registered_vote_vote` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_rsgallery2_acl` -- LOCK TABLES `rodam_rsgallery2_acl` WRITE; /*!40000 ALTER TABLE `rodam_rsgallery2_acl` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_rsgallery2_acl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_rsgallery2_comments` -- DROP TABLE IF EXISTS `rodam_rsgallery2_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_rsgallery2_comments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL DEFAULT '0', `user_name` varchar(100) NOT NULL DEFAULT '', `user_ip` varchar(50) NOT NULL DEFAULT '0.0.0.0', `parent_id` int(11) NOT NULL DEFAULT '0', `item_id` int(11) NOT NULL DEFAULT '0', `item_table` varchar(50) DEFAULT NULL, `datetime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `subject` varchar(100) DEFAULT NULL, `comment` text NOT NULL, `published` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) DEFAULT NULL, `checked_out_time` datetime DEFAULT NULL, `ordering` int(11) NOT NULL DEFAULT '0', `params` text, `hits` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_rsgallery2_comments` -- LOCK TABLES `rodam_rsgallery2_comments` WRITE; /*!40000 ALTER TABLE `rodam_rsgallery2_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_rsgallery2_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_rsgallery2_config` -- DROP TABLE IF EXISTS `rodam_rsgallery2_config`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_rsgallery2_config` ( `id` int(9) unsigned NOT NULL AUTO_INCREMENT, `name` text NOT NULL, `value` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_rsgallery2_config` -- LOCK TABLES `rodam_rsgallery2_config` WRITE; /*!40000 ALTER TABLE `rodam_rsgallery2_config` DISABLE KEYS */; INSERT INTO `rodam_rsgallery2_config` VALUES (1,'acl_enabled','1'),(2,'allowedFileTypes','jpg,jpeg,gif,png'),(3,'comment','1'),(4,'comment_allowed_public','1'),(5,'comment_once','0'),(6,'comment_security','1'),(7,'cookie_prefix','rsgvoting_'),(8,'createImgDirs',''),(9,'current_slideshow','slideshow_parth'),(10,'debug','0'),(11,'dispLimitbox','1'),(12,'displayBranding','1'),(13,'displayComments','1'),(14,'displayDesc','1'),(15,'displayDownload','1'),(16,'displayEXIF','1'),(17,'displayHits','0'),(18,'displayLatest','1'),(19,'displayPopup','1'),(20,'displayRandom','1'),(21,'displaySearch','1'),(22,'displaySlideshow','1'),(23,'displayStatus','1'),(24,'displayVoting','1'),(25,'display_img_dynamicResize','0'),(26,'display_thumbs_colsPerPage','3'),(27,'display_thumbs_floatDirection','left'),(28,'display_thumbs_maxPerPage','9'),(29,'display_thumbs_showImgName','1'),(30,'display_thumbs_style','table'),(31,'exifTags','FileName|FileDateTime|resolution'),(32,'filter_order','ordering'),(33,'filter_order_Dir','ASC'),(34,'ftp_path',''),(35,'galcountNrs','5'),(36,'graphicsLib','gd2'),(37,'hideRoot','1'),(38,'imageMagick_path',''),(39,'image_width','400'),(40,'imgPath_display','/images/rsgallery/display'),(41,'imgPath_original','/images/rsgallery/original'),(42,'imgPath_thumb','/images/rsgallery/thumb'),(43,'intro_text','Your images go here
'),(44,'jpegQuality','85'),(45,'keepOriginalImage','1'),(46,'netpbm_path',''),(47,'resize_portrait_by_height','1'),(48,'showGalleryDate','1'),(49,'showGalleryOwner','1'),(50,'showGallerySize','1'),(51,'show_mygalleries','1'),(52,'template','semantic'),(53,'thumb_style','1'),(54,'thumb_width','80'),(55,'uu_createCat','1'),(56,'uu_enabled','0'),(57,'uu_maxCat','10'),(58,'uu_maxImages','100'),(59,'version','1.14.3'),(60,'voting','1'),(61,'voting_once','1'),(62,'watermark','0'),(63,'watermark_angle','0'),(64,'watermark_font','arial.ttf'),(65,'watermark_font_size','20'),(66,'watermark_image','watermark.png'),(67,'watermark_position','5'),(68,'watermark_text','(c) 2007 - RSGallery2'),(69,'watermark_transparency','50'),(70,'watermark_type','text'); /*!40000 ALTER TABLE `rodam_rsgallery2_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_rsgallery2_files` -- DROP TABLE IF EXISTS `rodam_rsgallery2_files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_rsgallery2_files` ( `id` int(9) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `descr` text, `gallery_id` int(9) unsigned NOT NULL DEFAULT '0', `title` varchar(50) NOT NULL DEFAULT '', `hits` int(11) unsigned NOT NULL DEFAULT '0', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `rating` int(10) unsigned NOT NULL DEFAULT '0', `votes` int(10) unsigned NOT NULL DEFAULT '0', `comments` int(10) unsigned NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `checked_out` int(11) NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `ordering` int(9) unsigned NOT NULL DEFAULT '0', `approved` tinyint(1) unsigned NOT NULL DEFAULT '1', `userid` int(10) NOT NULL DEFAULT '0', `params` text NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `UK_name` (`name`), KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_rsgallery2_files` -- LOCK TABLES `rodam_rsgallery2_files` WRITE; /*!40000 ALTER TABLE `rodam_rsgallery2_files` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_rsgallery2_files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_rsgallery2_galleries` -- DROP TABLE IF EXISTS `rodam_rsgallery2_galleries`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_rsgallery2_galleries` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent` int(11) NOT NULL DEFAULT '0', `name` varchar(255) 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', `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `hits` int(11) NOT NULL DEFAULT '0', `params` text NOT NULL, `user` tinyint(4) NOT NULL DEFAULT '0', `uid` int(11) unsigned NOT NULL DEFAULT '0', `allowed` varchar(100) NOT NULL DEFAULT '0', `thumb_id` int(11) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_rsgallery2_galleries` -- LOCK TABLES `rodam_rsgallery2_galleries` WRITE; /*!40000 ALTER TABLE `rodam_rsgallery2_galleries` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_rsgallery2_galleries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_sections` -- DROP TABLE IF EXISTS `rodam_sections`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_sections` -- LOCK TABLES `rodam_sections` WRITE; /*!40000 ALTER TABLE `rodam_sections` DISABLE KEYS */; INSERT INTO `rodam_sections` VALUES (1,'News','The News','articles.jpg','content','right','Select a news topic from 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 FAQ 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 `rodam_sections` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_session` -- DROP TABLE IF EXISTS `rodam_session`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_session` -- LOCK TABLES `rodam_session` WRITE; /*!40000 ALTER TABLE `rodam_session` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_session` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_stats_agents` -- DROP TABLE IF EXISTS `rodam_stats_agents`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_stats_agents` -- LOCK TABLES `rodam_stats_agents` WRITE; /*!40000 ALTER TABLE `rodam_stats_agents` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_stats_agents` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_steckbriefe_details` -- DROP TABLE IF EXISTS `rodam_steckbriefe_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_steckbriefe_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `spitzname` varchar(50) DEFAULT NULL, `geburtsort` varchar(50) DEFAULT NULL, `geburtsdatum` varchar(10) DEFAULT NULL, `hobbies` varchar(50) DEFAULT NULL, `con_position` varchar(50) DEFAULT NULL, `vorbilder` varchar(50) DEFAULT NULL, `lieblingsverein` varchar(50) DEFAULT NULL, `eigenschaften` varchar(50) DEFAULT NULL, `alte_vereine` varchar(50) DEFAULT NULL, `zusatz1` varchar(100) DEFAULT NULL, `zusatz2` varchar(100) DEFAULT NULL, `zusatz3` varchar(100) DEFAULT NULL, `website` varchar(100) DEFAULT NULL, `zusatz4` mediumtext, `motto` 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 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_steckbriefe_details` -- LOCK TABLES `rodam_steckbriefe_details` WRITE; /*!40000 ALTER TABLE `rodam_steckbriefe_details` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_steckbriefe_details` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_template_positions` -- DROP TABLE IF EXISTS `rodam_template_positions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_template_positions` -- LOCK TABLES `rodam_template_positions` WRITE; /*!40000 ALTER TABLE `rodam_template_positions` DISABLE KEYS */; INSERT INTO `rodam_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 `rodam_template_positions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_templates_menu` -- DROP TABLE IF EXISTS `rodam_templates_menu`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_templates_menu` -- LOCK TABLES `rodam_templates_menu` WRITE; /*!40000 ALTER TABLE `rodam_templates_menu` DISABLE KEYS */; INSERT INTO `rodam_templates_menu` VALUES ('owtweb_rodam',0,0),('joomla_admin',0,1); /*!40000 ALTER TABLE `rodam_templates_menu` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_users` -- DROP TABLE IF EXISTS `rodam_users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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=64 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_users` -- LOCK TABLES `rodam_users` WRITE; /*!40000 ALTER TABLE `rodam_users` DISABLE KEYS */; INSERT INTO `rodam_users` VALUES (62,'Administrator','admin','markus.mascelli@chello.at','5a9361b28ee51795f1e82d9054919034','Super Administrator',0,1,25,'2006-06-04 21:35:31','2008-10-26 21:40:34','','editor='),(63,'Markus A. Mascelli','mam','mam@heimam.at','5a9361b28ee51795f1e82d9054919034','',0,0,18,'2008-10-26 19:17:00','2009-03-06 06:33:47','','editor=tinymce'); /*!40000 ALTER TABLE `rodam_users` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_usertypes` -- DROP TABLE IF EXISTS `rodam_usertypes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_usertypes` -- LOCK TABLES `rodam_usertypes` WRITE; /*!40000 ALTER TABLE `rodam_usertypes` DISABLE KEYS */; INSERT INTO `rodam_usertypes` VALUES (0,'superadministrator',''),(1,'administrator',''),(2,'editor',''),(3,'user',''),(4,'author',''),(5,'publisher',''),(6,'manager',''); /*!40000 ALTER TABLE `rodam_usertypes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_weblinks` -- DROP TABLE IF EXISTS `rodam_weblinks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_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 `rodam_weblinks` -- LOCK TABLES `rodam_weblinks` WRITE; /*!40000 ALTER TABLE `rodam_weblinks` DISABLE KEYS */; INSERT INTO `rodam_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 `rodam_weblinks` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom` -- DROP TABLE IF EXISTS `rodam_zoom`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom` ( `catid` int(11) NOT NULL AUTO_INCREMENT, `catname` varchar(50) DEFAULT '0', `catdescr` varchar(255) DEFAULT NULL, `catdir` varchar(50) DEFAULT '0', `catimg` int(11) DEFAULT NULL, `catpassword` varchar(100) NOT NULL DEFAULT '', `catkeywords` varchar(240) NOT NULL DEFAULT '', `subcat_id` int(11) NOT NULL DEFAULT '0', `pos` int(3) NOT NULL DEFAULT '0', `hideMsg` tinyint(1) NOT NULL DEFAULT '0', `shared` tinyint(1) NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `uid` int(11) NOT NULL DEFAULT '0', `catmembers` varchar(240) NOT NULL DEFAULT '', PRIMARY KEY (`catid`), KEY `catdir_search` (`catdir`), KEY `rel_subcats` (`subcat_id`) ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom` -- LOCK TABLES `rodam_zoom` WRITE; /*!40000 ALTER TABLE `rodam_zoom` DISABLE KEYS */; INSERT INTO `rodam_zoom` VALUES (1,'10 Years After - The Rotterdam Erasmus Students Re','','ZEMNKL',NULL,'','',0,0,0,1,1,62,'2'); /*!40000 ALTER TABLE `rodam_zoom` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom_comments` -- DROP TABLE IF EXISTS `rodam_zoom_comments`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom_comments` ( `cmtid` int(11) NOT NULL AUTO_INCREMENT, `imgid` int(11) NOT NULL DEFAULT '0', `cmtname` varchar(40) NOT NULL DEFAULT '', `cmtcontent` text NOT NULL, `cmtdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`cmtid`), KEY `imgid` (`imgid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom_comments` -- LOCK TABLES `rodam_zoom_comments` WRITE; /*!40000 ALTER TABLE `rodam_zoom_comments` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_zoom_comments` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom_ecards` -- DROP TABLE IF EXISTS `rodam_zoom_ecards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom_ecards` ( `ecdid` varchar(25) NOT NULL DEFAULT '', `imgid` int(11) NOT NULL DEFAULT '0', `to_name` varchar(50) NOT NULL DEFAULT '', `from_name` varchar(50) NOT NULL DEFAULT '', `to_email` varchar(75) NOT NULL DEFAULT '', `from_email` varchar(75) NOT NULL DEFAULT '', `message` text NOT NULL, `end_date` date NOT NULL DEFAULT '0000-00-00', `user_ip` varchar(25) NOT NULL DEFAULT '', PRIMARY KEY (`ecdid`), KEY `ecard_img` (`imgid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom_ecards` -- LOCK TABLES `rodam_zoom_ecards` WRITE; /*!40000 ALTER TABLE `rodam_zoom_ecards` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_zoom_ecards` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom_editmon` -- DROP TABLE IF EXISTS `rodam_zoom_editmon`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom_editmon` ( `edtid` int(11) NOT NULL AUTO_INCREMENT, `user_session` varchar(200) NOT NULL DEFAULT '0', `vote_time` varchar(14) DEFAULT NULL, `comment_time` varchar(14) DEFAULT NULL, `pass_time` varchar(14) DEFAULT NULL, `lightbox_time` varchar(14) DEFAULT NULL, `lightbox_file` varchar(40) DEFAULT NULL, `object_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`edtid`), KEY `edit_session` (`user_session`), KEY `object` (`object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom_editmon` -- LOCK TABLES `rodam_zoom_editmon` WRITE; /*!40000 ALTER TABLE `rodam_zoom_editmon` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_zoom_editmon` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom_getid3_cache` -- DROP TABLE IF EXISTS `rodam_zoom_getid3_cache`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom_getid3_cache` ( `filename` varchar(255) NOT NULL DEFAULT '', `filesize` int(11) NOT NULL DEFAULT '0', `filetime` int(11) NOT NULL DEFAULT '0', `analyzetime` int(11) NOT NULL DEFAULT '0', `value` text NOT NULL, PRIMARY KEY (`filename`,`filesize`,`filetime`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom_getid3_cache` -- LOCK TABLES `rodam_zoom_getid3_cache` WRITE; /*!40000 ALTER TABLE `rodam_zoom_getid3_cache` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_zoom_getid3_cache` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoom_priv` -- DROP TABLE IF EXISTS `rodam_zoom_priv`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoom_priv` ( `gid` int(11) NOT NULL DEFAULT '0', `priv_upload` enum('0','1') NOT NULL DEFAULT '1', `priv_editmedium` enum('0','1') NOT NULL DEFAULT '1', `priv_delmedium` enum('0','1') NOT NULL DEFAULT '1', `priv_creategal` enum('0','1') NOT NULL DEFAULT '1', `priv_editgal` enum('0','1') NOT NULL DEFAULT '1', `priv_delgal` enum('0','1') NOT NULL DEFAULT '1', PRIMARY KEY (`gid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoom_priv` -- LOCK TABLES `rodam_zoom_priv` WRITE; /*!40000 ALTER TABLE `rodam_zoom_priv` DISABLE KEYS */; INSERT INTO `rodam_zoom_priv` VALUES (18,'1','0','0','0','0','0'),(19,'1','0','0','0','0','0'),(20,'1','0','0','0','0','0'),(21,'1','0','0','0','0','0'),(23,'1','0','0','0','0','0'),(24,'1','1','1','1','1','1'),(25,'1','1','1','1','1','1'); /*!40000 ALTER TABLE `rodam_zoom_priv` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `rodam_zoomfiles` -- DROP TABLE IF EXISTS `rodam_zoomfiles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `rodam_zoomfiles` ( `imgid` int(11) NOT NULL AUTO_INCREMENT, `imgname` varchar(50) NOT NULL DEFAULT '', `imgfilename` varchar(70) NOT NULL DEFAULT '', `imgdescr` varchar(255) DEFAULT NULL, `imgkeywords` varchar(255) DEFAULT NULL, `imgdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `imghits` bigint(20) NOT NULL DEFAULT '0', `votenum` int(11) NOT NULL DEFAULT '0', `votesum` int(11) NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '1', `catid` int(11) NOT NULL DEFAULT '0', `uid` int(11) NOT NULL DEFAULT '0', `imgmembers` varchar(240) NOT NULL DEFAULT '', PRIMARY KEY (`imgid`), KEY `img_catid` (`catid`), KEY `img_user` (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `rodam_zoomfiles` -- LOCK TABLES `rodam_zoomfiles` WRITE; /*!40000 ALTER TABLE `rodam_zoomfiles` DISABLE KEYS */; /*!40000 ALTER TABLE `rodam_zoomfiles` 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 2017-01-26 8:03:40