Eine Mischung aus Ausdauer- und Kräftigungsübungen mit leichter Choreographie, auch mit Einsatz verschiedener Trainingsgeräte wie Gewichtsmanschetten, Therabändern o.ä.
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. Juni 2011 um 19:24
-- Server Version: 5.1.41
-- PHP-Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Datenbank: `heropitdb`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_banner`
--
CREATE TABLE IF NOT EXISTS `jos_banner` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`type` varchar(30) NOT NULL DEFAULT 'banner',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`imptotal` int(11) NOT NULL DEFAULT '0',
`impmade` int(11) NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`imageurl` varchar(100) NOT NULL DEFAULT '',
`clickurl` varchar(200) NOT NULL DEFAULT '',
`date` datetime DEFAULT NULL,
`showBanner` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` tinyint(1) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` varchar(50) DEFAULT NULL,
`custombannercode` text,
`catid` int(10) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`tags` text NOT NULL,
`params` text NOT NULL,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`),
KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Daten für Tabelle `jos_banner`
--
INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES
(1, 1, 'banner', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(2, 1, 'banner', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(3, 1, '', 'Joomla!', 'joomla', 0, 34, 0, '', 'http://www.joomla.org', '2006-05-29 14:21:28', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla!, das bekannteste und meistgenutzte Open-Source-CMS-Projekt der Welt.', 14, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(4, 1, '', 'JoomlaCode', 'joomlacode', 0, 34, 0, '', 'http://joomlacode.org', '2006-05-29 14:19:26', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomlaCode - Entwicklung und Verbreitung einfach gemacht.', 14, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(5, 1, '', 'Joomla!-Erweitungen', 'joomla-erweitungen', 0, 29, 0, '', 'http://extensions.joomla.org', '2006-05-29 14:23:21', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla!-Komponenten, Module, Plugins und Übersetzungen zentral.', 14, '', 0, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(6, 1, '', 'Joomla!-Shop', 'joomla-shop', 0, 29, 0, '', 'http://shop.joomla.org', '2006-05-29 14:23:21', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nFür alle Ihre Joomla!-Artikel.', 14, '', 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(7, 1, '', 'Joomla! Promo-Artikel', 'joomla-promo-artikel', 0, 8, 1, 'shop-ad.jpg', 'http://shop.joomla.org', '2007-09-19 17:26:24', 1, 0, '0000-00-00 00:00:00', '', '', 33, '', 0, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(8, 1, '', 'Joomla!-Bücher', 'joomla-buecher', 0, 9, 0, 'shop-ad-books.jpg', 'http://shop.joomla.org/amazoncom-bookstores.html', '2007-09-19 17:28:01', 1, 0, '0000-00-00 00:00:00', '', '', 33, '', 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_bannerclient`
--
CREATE TABLE IF NOT EXISTS `jos_bannerclient` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`contact` varchar(255) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL DEFAULT '0',
`checked_out_time` time DEFAULT NULL,
`editor` varchar(50) DEFAULT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `jos_bannerclient`
--
INSERT INTO `jos_bannerclient` (`cid`, `name`, `contact`, `email`, `extrainfo`, `checked_out`, `checked_out_time`, `editor`) VALUES
(1, 'Open Source Matters', 'Administrator', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', '', 0, '00:00:00', NULL);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_bannertrack`
--
CREATE TABLE IF NOT EXISTS `jos_bannertrack` (
`track_date` date NOT NULL,
`track_type` int(10) unsigned NOT NULL,
`banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_bannertrack`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_categories`
--
CREATE TABLE IF NOT EXISTS `jos_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`image` varchar(255) NOT NULL DEFAULT '',
`section` varchar(50) NOT NULL DEFAULT '',
`image_position` varchar(30) NOT NULL DEFAULT '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` varchar(50) DEFAULT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
--
-- Daten für Tabelle `jos_categories`
--
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES
(2, 0, 'Links rund um Joomla!', '', 'links-rund-um-joomla', 'clock.jpg', 'com_weblinks', 'left', 'Eine Auswahl an Weblinks, die mit dem Joomla!-Projekt zu tun haben.', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(4, 0, 'Joomla!', '', 'joomla', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(5, 0, 'Freie und Open Source-Software', '', 'freie-und-open-source-software', '', 'com_newsfeeds', 'left', 'Lesen Sie das Neueste über Freie und Open Source Software von einigen der führenden Verfechtern.', 1, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(6, 0, 'Related Projects', '', 'related-projects', '', 'com_newsfeeds', 'left', 'Joomla basiert auf andere Freie und Open Source Projekte und arbeitet mit vielen zusammen. Wir haben einige ausgewählt, damit Sie auf dem Laufenden bleiben.', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(12, 0, 'Kontakte', '', 'kontakte', '', 'com_contact_details', 'left', 'Details zu den Kontakten dieser Webseite', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(13, 0, 'Joomla', '', 'joomla', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(14, 0, 'Text-Werbung', '', 'text-werbung', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(15, 0, 'Merkmale', '', 'merkmale', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, ''),
(17, 0, 'Benefits', '', 'benefits', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(18, 0, 'Plattformen', '', 'plattformen', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(19, 0, 'Andere Quellen', '', 'andere-quellen', '', 'com_weblinks', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(34, 0, 'Dafne von der Wallmey', '', 'dafne-von-der-wallmey', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(35, 0, 'Amber vom Hollingerbach', '', 'amber-vom-hollingerbach', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(36, 0, 'Cora von Wext', '', 'cora-von-wext', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(37, 0, 'Gina vom Besterfeld', '', 'gina-vom-besterfeld', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(38, 0, 'Biene von Neibur', '', 'biene-von-neibur', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, ''),
(39, 0, 'Linda von Pannonia', '', 'linda-von-pannonia', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, ''),
(33, 0, 'Joomla! Promo', '', 'joomla-promo', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_components`
--
CREATE TABLE IF NOT EXISTS `jos_components` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`link` varchar(255) NOT NULL DEFAULT '',
`menuid` int(11) unsigned NOT NULL DEFAULT '0',
`parent` int(11) unsigned NOT NULL DEFAULT '0',
`admin_menu_link` varchar(255) NOT NULL DEFAULT '',
`admin_menu_alt` varchar(255) NOT NULL DEFAULT '',
`option` varchar(50) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL DEFAULT '0',
`admin_menu_img` varchar(255) NOT NULL DEFAULT '',
`iscore` tinyint(4) NOT NULL DEFAULT '0',
`params` text NOT NULL,
`enabled` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
--
-- Daten für Tabelle `jos_components`
--
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES
(1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, 'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n', 1),
(2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/component.png', 0, 'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n', 1),
(5, 'Links', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(6, 'Categories', '', 0, 4, 'option=com_categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1),
(8, 'Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '', 1),
(9, 'Categories', '', 0, 7, 'option=com_categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1),
(10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(12, 'Feeds', '', 0, 11, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, 'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n', 1),
(13, 'Categories', '', 0, 11, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(14, 'User', 'option=com_user', 0, 0, '', '', 'com_user', 0, '', 1, '', 1),
(15, 'Search', 'option=com_search', 0, 0, 'option=com_search', 'Search Statistics', 'com_search', 0, 'js/ThemeOffice/component.png', 1, 'enabled=0\n\n', 1),
(16, 'Categories', '', 0, 1, 'option=com_categories§ion=com_banner', 'Categories', '', 3, '', 1, '', 1),
(17, 'Wrapper', 'option=com_wrapper', 0, 0, '', 'Wrapper', 'com_wrapper', 0, '', 1, '', 1),
(18, 'Mail To', '', 0, 0, '', '', 'com_mailto', 0, '', 1, '', 1),
(19, 'Media Manager', '', 0, 0, 'option=com_media', 'Media Manager', 'com_media', 0, '', 1, 'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html', 1),
(20, 'Articles', 'option=com_content', 0, 0, '', '', 'com_content', 0, '', 1, 'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=0\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_item_navigation=0\nshow_readmore=0\nshow_vote=0\nshow_icons=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nshow_hits=0\nfeed_summary=0\nfilter_tags=\nfilter_attritbutes=\n\n', 1),
(21, 'Configuration Manager', '', 0, 0, '', 'Configuration', 'com_config', 0, '', 1, '', 1),
(22, 'Installation Manager', '', 0, 0, '', 'Installer', 'com_installer', 0, '', 1, '', 1),
(23, 'Language Manager', '', 0, 0, '', 'Languages', 'com_languages', 0, '', 1, 'administrator=de-DE\nsite=de-DE', 1),
(24, 'Mass mail', '', 0, 0, '', 'Mass Mail', 'com_massmail', 0, '', 1, 'mailSubjectPrefix=\nmailBodySuffix=\n\n', 1),
(25, 'Menu Editor', '', 0, 0, '', 'Menu Editor', 'com_menus', 0, '', 1, '', 1),
(27, 'Messaging', '', 0, 0, '', 'Messages', 'com_messages', 0, '', 1, '', 1),
(28, 'Modules Manager', '', 0, 0, '', 'Modules', 'com_modules', 0, '', 1, '', 1),
(29, 'Plugin Manager', '', 0, 0, '', 'Plugins', 'com_plugins', 0, '', 1, '', 1),
(30, 'Template Manager', '', 0, 0, '', 'Templates', 'com_templates', 0, '', 1, '', 1),
(31, 'User Manager', '', 0, 0, '', 'Users', 'com_users', 0, '', 1, 'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n', 1),
(32, 'Cache Manager', '', 0, 0, '', 'Cache', 'com_cache', 0, '', 1, '', 1),
(33, 'Control Panel', '', 0, 0, '', 'Control Panel', 'com_cpanel', 0, '', 1, '', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_contact_details`
--
CREATE TABLE IF NOT EXISTS `jos_contact_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`con_position` varchar(255) DEFAULT NULL,
`address` text,
`suburb` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`postcode` varchar(100) DEFAULT NULL,
`telephone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`misc` mediumtext,
`image` varchar(255) DEFAULT NULL,
`imagepos` varchar(20) DEFAULT NULL,
`email_to` varchar(255) DEFAULT NULL,
`default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
`published` tinyint(1) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`catid` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mobile` varchar(255) NOT NULL DEFAULT '',
`webpage` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `jos_contact_details`
--
INSERT INTO `jos_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`) VALUES
(1, 'Hero Pit von Niedersachsenstein', 'hero-pit-von-niedersachsenstein', 'Inhaber Ansgar Vosskötter', 'Hauptstr. 12', '27384 Visshausen', '', '', '', '01234-567263', '', '', 'kontaktbild.png', 'top', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', 0, 1, 0, '0000-00-00 00:00:00', 1, 'show_name=1\nshow_position=1\nshow_email=1\nshow_street_address=1\nshow_suburb=1\nshow_state=0\nshow_postcode=0\nshow_country=0\nshow_telephone=1\nshow_mobile=0\nshow_fax=0\nshow_webpage=1\nshow_misc=0\nshow_image=0\nallow_vcard=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_email_form=1\nemail_description=1\nshow_email_copy=1\nbanned_email=\nbanned_subject=\nbanned_text=', 0, 12, 0, '', 'http://www.hero-pit.de');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content`
--
CREATE TABLE IF NOT EXISTS `jos_content` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`title_alias` varchar(255) NOT NULL DEFAULT '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL DEFAULT '0',
`sectionid` int(11) unsigned NOT NULL DEFAULT '0',
`mask` int(11) unsigned NOT NULL DEFAULT '0',
`catid` int(11) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL DEFAULT '0',
`created_by_alias` varchar(255) NOT NULL DEFAULT '',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL DEFAULT '1',
`parentid` int(11) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '0',
`metadata` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;
--
-- Daten für Tabelle `jos_content`
--
INSERT INTO `jos_content` (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`) VALUES
(50, 'Cora von Wext', 'cora-von-wext', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Dack von Wext</strong></td>\r\n<td width="101" align="RIGHT"><strong>13.10.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Dolly von Wext</strong></td>\r\n<td align="RIGHT"><strong>13.10.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 36, '2011-06-20 06:54:52', 62, '', '2011-06-20 07:01:35', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:54:52', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 6, 'robots=\nauthor='),
(51, 'Gina vom Besterfeld', 'gina-vom-besterfeld', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Hanjo vom Bester Feld</strong></td>\r\n<td width="101" align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Heik vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hero vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Heron vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hedda vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hella vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hera vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hilde vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 37, '2011-06-20 06:56:27', 62, '', '2011-06-20 07:01:52', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:56:27', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 5, 'robots=\nauthor='),
(52, 'Biene von Neibur', 'biene-von-neibur', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Ecky von Neibur</strong></td>\r\n<td width="101" align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Eddy von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ede von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Erick von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ella von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Elly von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 38, '2011-06-20 06:57:47', 62, '', '2011-06-20 07:01:14', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:57:47', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 2, 'robots=\nauthor='),
(53, 'Linda von Pannonia', 'linda-von-pannonia', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>ALF vom Eulenfelsen</strong></td>\r\n<td width="101" align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Arco vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Artus vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Asko vom eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Aika vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Amsel vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Anka vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 39, '2011-06-20 06:59:11', 62, '', '2011-06-20 07:01:59', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:59:11', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 2, 'robots=\nauthor='),
(46, 'Leistungsdaten', 'leistungsdaten', '', '<p>Hero Pit vom Niedersachsenstein</p>\r\n<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="82"></col><col width="82"></col><col width="88"></col><col width="107"></col><col width="92"></col><col width="94"></col><col width="82"></col><col width="82"></col><col width="97"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td style="border: 1px solid #000000;" width="82" height="50" align="LEFT"><span style="font-family: Tahoma;">VJP</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">HZP</span></td>\r\n<td style="border: 1px solid #000000;" width="88" align="CENTER"><span style="font-family: Tahoma;">Rauhwolf ZuchtausleseHZP</span></td>\r\n<td style="border: 1px solid #000000;" width="107" align="LEFT"><span style="font-family: Tahoma;">VGP</span></td>\r\n<td style="border: 1px solid #000000;" width="92" align="LEFT"><span style="font-family: Tahoma;">HD-Untersuchung</span></td>\r\n<td style="border: 1px solid #000000;" width="94" align="LEFT"><span style="font-family: Tahoma;">Augen-untersuchung</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">Formwert/ Haarwert</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">Größe</span></td>\r\n<td style="border: 1px solid #000000;" width="97" align="LEFT"><span style="font-family: Tahoma;">weitere Prüfungen</span></td>\r\n</tr>\r\n<tr>\r\n<td height="18" align="RIGHT">71</td>\r\n<td align="LEFT"><br /></td>\r\n<td align="LEFT">184+ 30</td>\r\n<td align="LEFT">327/1PR</td>\r\n<td align="CENTER">A</td>\r\n<td align="LEFT">frei 2010</td>\r\n<td align="LEFT">Sg V</td>\r\n<td align="RIGHT">57</td>\r\n<td align="LEFT">Btr/AH</td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 0, 0, 0, '2011-06-15 10:11:24', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2011-06-15 10:11:24', '0000-00-00 00:00:00', '', '', 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 1, 0, 4, '', '', 0, 21, 'robots=\nauthor='),
(47, 'Dafne von der Wallmey', 'dafne-von-der-wallmey', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Aaron vom Albrock</strong></td>\r\n<td width="101" align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ares vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Amie vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Annie vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Aruscha vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 34, '2011-06-15 10:14:52', 62, '', '2011-06-20 07:01:43', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:14:52', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 3, 0, 1, '', '', 0, 35, 'robots=\nauthor='),
(48, 'Amber vom Hollingerbach', 'amber-vom-hollingerbach', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Xandor vom Rauhenbusch</strong></td>\r\n<td width="101" align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xaver vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xana vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xandra vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xara vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xeli vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xenia vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xilla vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xilly vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 35, '2011-06-15 10:17:28', 62, '', '2011-06-20 07:01:06', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:17:28', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 3, 0, 1, '', '', 0, 12, 'robots=\nauthor='),
(49, 'Willkommen', 'willkommen', '', '<p>Willkommen auf der Website von Hero Pit von Niedersachsenstein!</p>', '', 1, 0, 0, 0, '2011-06-15 10:19:49', 62, '', '2011-06-15 12:07:09', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:19:49', '0000-00-00 00:00:00', '', '', 'show_title=0\nlink_titles=0\nshow_intro=0\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_vote=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nlanguage=de-DE\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 207, 'robots=\nauthor=');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content_frontpage`
--
CREATE TABLE IF NOT EXISTS `jos_content_frontpage` (
`content_id` int(11) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_content_frontpage`
--
INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES
(49, 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content_rating`
--
CREATE TABLE IF NOT EXISTS `jos_content_rating` (
`content_id` int(11) NOT NULL DEFAULT '0',
`rating_sum` int(11) unsigned NOT NULL DEFAULT '0',
`rating_count` int(11) unsigned NOT NULL DEFAULT '0',
`lastip` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_content_rating`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`section_value` varchar(240) NOT NULL DEFAULT '0',
`value` varchar(240) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Daten für Tabelle `jos_core_acl_aro`
--
INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_groups`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`lft` int(11) NOT NULL DEFAULT '0',
`rgt` int(11) NOT NULL DEFAULT '0',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Daten für Tabelle `jos_core_acl_aro_groups`
--
INSERT INTO `jos_core_acl_aro_groups` (`id`, `parent_id`, `name`, `lft`, `rgt`, `value`) VALUES
(17, 0, 'ROOT', 1, 22, 'ROOT'),
(28, 17, 'USERS', 2, 21, 'USERS'),
(29, 28, 'Public Frontend', 3, 12, 'Public Frontend'),
(18, 29, 'Registered', 4, 11, 'Registered'),
(19, 18, 'Author', 5, 10, 'Author'),
(20, 19, 'Editor', 6, 9, 'Editor'),
(21, 20, 'Publisher', 7, 8, 'Publisher'),
(30, 28, 'Public Backend', 13, 20, 'Public Backend'),
(23, 30, 'Manager', 14, 19, 'Manager'),
(24, 23, 'Administrator', 15, 18, 'Administrator'),
(25, 24, 'Super Administrator', 16, 17, 'Super Administrator');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_map` (
`acl_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(230) NOT NULL DEFAULT '0',
`value` varchar(100) NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_acl_aro_map`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_sections`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(230) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(230) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Daten für Tabelle `jos_core_acl_aro_sections`
--
INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_groups_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(240) NOT NULL DEFAULT '',
`aro_id` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_acl_groups_aro_map`
--
INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(25, '', 10);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_log_items`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_items` (
`time_stamp` date NOT NULL DEFAULT '0000-00-00',
`item_table` varchar(50) NOT NULL DEFAULT '',
`item_id` int(11) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_log_items`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_log_searches`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_searches` (
`search_term` varchar(128) NOT NULL DEFAULT '',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_log_searches`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_groups`
--
CREATE TABLE IF NOT EXISTS `jos_groups` (
`id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_groups`
--
INSERT INTO `jos_groups` (`id`, `name`) VALUES
(0, 'Public'),
(1, 'Registered'),
(2, 'Special');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_menu`
--
CREATE TABLE IF NOT EXISTS `jos_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`menutype` varchar(75) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`link` text,
`type` varchar(50) NOT NULL DEFAULT '',
`published` tinyint(1) NOT NULL DEFAULT '0',
`parent` int(11) unsigned NOT NULL DEFAULT '0',
`componentid` int(11) unsigned NOT NULL DEFAULT '0',
`sublevel` int(11) DEFAULT '0',
`ordering` int(11) DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL DEFAULT '0',
`browserNav` tinyint(4) DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`utaccess` tinyint(3) unsigned NOT NULL DEFAULT '0',
`params` text NOT NULL,
`lft` int(11) unsigned NOT NULL DEFAULT '0',
`rgt` int(11) unsigned NOT NULL DEFAULT '0',
`home` int(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
--
-- Daten für Tabelle `jos_menu`
--
INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `alias`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`, `lft`, `rgt`, `home`) VALUES
(1, 'mainmenu', 'Startseite', 'home', 'index.php?option=com_content&view=article&id=49', 'component', 1, 0, 20, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=\npage_title=Willkommen auf der Startseite\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 1),
(18, 'mainmenu', 'Würfe', 'wuerfe', 'index.php?option=com_content&view=section&id=5', 'component', 0, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'show_description=1\nshow_description_image=0\nshow_categories=0\nshow_empty_categories=0\nshow_cat_num_articles=0\nshow_category_description=0\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(20, 'usermenu', 'Ihre Details', 'ihre-details', 'index.php?option=com_user&view=user&task=edit', 'component', 1, 0, 14, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, '', 0, 0, 0),
(24, 'usermenu', 'Abmelden', 'abmelden', 'index.php?option=com_user&view=login', 'component', 1, 0, 14, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, '', 0, 0, 0),
(61, 'mainmenu', 'Gina vom Besterfeld', 'gina-vom-besterfeld', 'index.php?option=com_content&view=article&id=51', 'component', 1, 0, 20, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(60, 'mainmenu', 'Cora von Wext', 'cora-von-wext', 'index.php?option=com_content&view=article&id=50', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(66, 'Menu-oben', 'Leistungsdaten', 'leistungsdaten', 'index.php?option=com_content&view=article&id=46', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(68, 'Menu-oben', 'Willkommen', 'willkommen', 'index.php?option=com_content&view=article&id=49', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(67, 'Menu-oben', 'Kontakt', 'kontakt', 'index.php?option=com_contact&view=contact&id=1', 'component', 1, 0, 7, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_contact_list=0\nshow_category_crumb=0\ncontact_icons=\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_headings=\nshow_position=\nshow_email=\nshow_telephone=\nshow_mobile=\nshow_fax=\nallow_vcard=\nbanned_email=\nbanned_subject=\nbanned_text=\nvalidate_session=\ncustom_reply=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(51, 'usermenu', 'Beitrag einreichen', 'beitrag-einreichen', 'index.php?option=com_content&view=article&layout=form', 'component', 1, 0, 20, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, '', 0, 0, 0),
(52, 'usermenu', 'Weblink einreichen', 'weblink-einreichen', 'index.php?option=com_weblinks&view=weblink&layout=form', 'component', 1, 0, 4, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, '', 0, 0, 0),
(62, 'mainmenu', 'Biene von Neibur', 'biene-von-neibur', 'index.php?option=com_content&view=article&id=52', 'component', 1, 0, 20, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(63, 'mainmenu', 'Linda von Pannonia', 'linda-von-pannonia', 'index.php?option=com_content&view=article&id=53', 'component', 1, 0, 20, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(64, 'mainmenu', 'Dafne von der Wallmey', 'dafne-von-der-wallmey', 'index.php?option=com_content&view=article&id=47', 'component', 1, 0, 20, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(65, 'mainmenu', 'Amber vom Hollingerbach', 'amber-vom-hollingerbach', 'index.php?option=com_content&view=article&id=48', 'component', 1, 0, 20, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_menu_types`
--
CREATE TABLE IF NOT EXISTS `jos_menu_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menutype` varchar(75) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Daten für Tabelle `jos_menu_types`
--
INSERT INTO `jos_menu_types` (`id`, `menutype`, `title`, `description`) VALUES
(1, 'mainmenu', 'Würfe', 'Das Hauptmenü dieser Website'),
(2, 'usermenu', 'Benutzermenü', 'Ein Menü für angemeldete Benutzer'),
(7, 'Menu-oben', 'Menu oben', 'Menu oben');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_messages`
--
CREATE TABLE IF NOT EXISTS `jos_messages` (
`message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
`user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
`folder_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`state` int(11) NOT NULL DEFAULT '0',
`priority` int(1) unsigned NOT NULL DEFAULT '0',
`subject` text NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`message_id`),
KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `jos_messages`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_messages_cfg`
--
CREATE TABLE IF NOT EXISTS `jos_messages_cfg` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`cfg_name` varchar(100) NOT NULL DEFAULT '',
`cfg_value` varchar(255) NOT NULL DEFAULT '',
UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_messages_cfg`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_migration_backlinks`
--
CREATE TABLE IF NOT EXISTS `jos_migration_backlinks` (
`itemid` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`url` text NOT NULL,
`sefurl` text NOT NULL,
`newurl` text NOT NULL,
PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_migration_backlinks`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_modules`
--
CREATE TABLE IF NOT EXISTS `jos_modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`position` varchar(50) DEFAULT NULL,
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`module` varchar(50) DEFAULT NULL,
`numnews` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL DEFAULT '0',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
`control` text NOT NULL,
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
--
-- Daten für Tabelle `jos_modules`
--
INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) VALUES
(1, 'Würfe', '', 0, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=1\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 1, 0, ''),
(2, 'Anmeldung', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, ''),
(3, 'Beliebt', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 2, 1, '', 0, 1, ''),
(4, 'Neue Beiträge', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 2, 1, 'ordering=c_dsc\nuser_id=0\ncache=0\n\n', 0, 1, ''),
(5, 'Statistiken', '', 6, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 2, 1, '', 0, 1, ''),
(6, 'Ungelesene Nachrichten', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 2, 1, '', 1, 1, ''),
(7, 'Benutzer online', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 2, 1, '', 1, 1, ''),
(8, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 2, 1, '', 1, 1, ''),
(9, 'Quick-Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 2, 1, '', 1, 1, ''),
(10, 'Angemeldete Benutzer', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 2, 1, '', 0, 1, ''),
(11, 'Fußzeile', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, ''),
(12, 'Admin-Menü', '', 1, 'menu', 0, '0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1, '', 0, 1, ''),
(13, 'Admin-Untermenü', '', 1, 'submenu', 0, '0000-00-00 00:00:00', 1, 'mod_submenu', 0, 2, 1, '', 0, 1, ''),
(14, 'Benutzerstatus', '', 1, 'status', 0, '0000-00-00 00:00:00', 1, 'mod_status', 0, 2, 1, '', 0, 1, ''),
(15, 'Titel', '', 1, 'title', 0, '0000-00-00 00:00:00', 1, 'mod_title', 0, 2, 1, '', 0, 1, ''),
(43, 'Update nötig?', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_jgerman', 0, 2, 1, 'select_language=de-DE\nauto_check=auto_check_no\ncheck_core=check_core_show\ndelete_notice=delete_notice_show\nimage_size=middle\ncache=0\n\n', 0, 1, ''),
(16, 'Umfragen', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_poll', 0, 0, 1, 'id=14\ncache=1', 0, 0, ''),
(17, 'Benutzermenü', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu\nmoduleclass_sfx=_menu\ncache=1', 1, 0, ''),
(18, 'Anmeldung', '', 5, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, 'greeting=1\nname=0', 1, 0, ''),
(19, 'Neueste Nachrichten', '', 4, 'user1', 0, '0000-00-00 00:00:00', 0, 'mod_latestnews', 0, 0, 1, 'cache=1', 1, 0, ''),
(20, 'Statistiken', '', 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, ''),
(21, 'Wer ist online', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0, ''),
(22, 'Meist gelesen', '', 6, 'user2', 0, '0000-00-00 00:00:00', 0, 'mod_mostread', 0, 0, 1, 'cache=1', 0, 0, ''),
(23, 'Archiv', '', 6, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, 'cache=1', 1, 0, ''),
(24, 'Bereiche', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, 'cache=1', 1, 0, ''),
(25, 'Schlagzeilen', '', 1, 'top', 0, '0000-00-00 00:00:00', 0, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0, ''),
(26, 'Verwandte Beiträge', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0, ''),
(27, 'Suche', '', 1, 'user4', 0, '0000-00-00 00:00:00', 0, 'mod_search', 0, 0, 0, 'cache=1', 0, 0, ''),
(28, 'Zufallsbild', '', 9, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_random_image', 0, 0, 1, '', 0, 0, ''),
(30, 'Banner', '', 1, 'footer', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 0, 'target=1\ncount=1\ncid=1\ncatid=33\ntag_search=0\nordering=random\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n', 1, 0, ''),
(32, 'Wrapper', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0, ''),
(33, 'Fußzeile', '', 2, 'footer', 0, '0000-00-00 00:00:00', 0, 'mod_footer', 0, 0, 0, 'cache=1\n\n', 1, 0, ''),
(34, 'Feed-Anzeige', '', 10, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_feed', 0, 0, 1, '', 1, 0, ''),
(35, 'Navigationspfad (Breadcrumb)', '', 1, 'breadcrumb', 0, '0000-00-00 00:00:00', 0, 'mod_breadcrumbs', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nshowHome=1\nhomeText=Start\nshowComponent=1\nseparator=\n\n', 1, 0, ''),
(36, 'Syndication', '', 3, 'syndicate', 0, '0000-00-00 00:00:00', 0, 'mod_syndicate', 0, 0, 0, '', 1, 0, ''),
(38, 'Werbung', '', 3, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 1, 'count=4\r\nrandomise=0\r\ncid=0\r\ncatid=14\r\nheader_text=Empfohlene Links:\r\nfooter_text=<a href="http://www.joomla.org">Inserate von Joomla!</a>\r\nmoduleclass_sfx=_text\r\ncache=0\r\n\r\n', 0, 0, ''),
(44, 'Menu oben', '', 0, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=Menu-oben\nmenu_style=list_flat\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=-nav\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''),
(41, 'Willkommen bei Joomla!', '<div style="padding: 5px"><p>Gratulation, dass Sie Joomla! als Ihr Content-Management-System gewählt haben. Wir hoffen, dass es Ihnen mit unserem Programm gelingt eine erfolgreiche Website zu erstellen und der Gemeinschaft vielleicht zu einem späteren Punkt etwas zurückgeben können.</p><p>Um Ihren Anfang mit Joomla! so einfach wie möglich zu gestalten, möchten wir Ihnen einige Punkte aufzeigen, wie z.B. allgemeinen Fragen, Hilfen und Sicherheit Ihres Server.</p><p>Sie sollten mit dem "<a href="http://docs.joomla.org/beginners" target="_blank">Absolute Beginners Guide to Joomla!</a>" anfangen und dann, um die Sicherheit Ihres Servers zu gewährleisten, die "<a href="http://forum.joomla.org/viewtopic.php?t=81058" target="_blank">Security Checklist</a>" lesen.</p><p>Für Ihre häufig gestellten Fragen sollten Sie zuerst ins <a href="http://forum.joomla.org" target="_blank">Forum</a> schauen und die <a href="http://docs.joomla.org/Category:FAQ" target="_blank">FAQ</a> im Wiki lesen. Im Forum finden Sie eine Antwort auf fast alle Ihre Fragen. Auch wenn diese bisher nur einmal von anderen beantwortet wurden, so ist das Forum ein großes Nachschlagewerk für Anfänger und Profis. Bitte benutzen Sie die Suchfunktion des Forums bevor Sie Ihre Frage stellen, es könnte nämlich sein, dass diese schon einmal gestellt wurde. <img alt="Lächeln" border="0" src="/../plugins/editors/tinymce/jscripts/tiny_mce/plugins/emotions/images/smiley-smile.gif" title="Lächeln" /></p><p>Die Sicherheit ist ein großes Anliegen für uns, deshalb würden wir es begrüßen, wenn Sie das "<a href="http://forum.joomla.org/viewforum.php?f=8" target="_blank">Announcement-Forum</a>" abonnieren würden, damit Sie immer aktuelle Informationen über neue Joomla!-Versionen bekommen. Sie sollten aber auch regelmäßig das "<a href="http://forum.joomla.org/viewforum.php?f=432" target="_blank">Security-Forum</a>" besuchen.</p><p>Wir hoffen, dass Sie viel Spaß und Erfolg mit Joomla! haben und Sie bald unter den Hunderten bzw. Tausenden an Joomla!-Benutzern sind, die Anfängern helfen können.</p><p>Ihr Joomla!-Team</p><p>P.S.: Um diese Anzeige zu entfernen, löschen Sie einfach das "Willkommen bei Joomla!"-Modul unter "Erweiterungen"->"Module" ->"Administrator".</p></div>', 1, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 2, 1, 'moduleclass_sfx=\n\n', 1, 1, ''),
(42, 'Joomla! Security Newsfeed', '', 6, 'cpanel', 62, '2008-10-25 20:15:17', 1, 'mod_feed', 0, 0, 1, 'cache=1\ncache_time=15\nmoduleclass_sfx=\nrssurl=http://feeds.joomla.org/JoomlaSecurityNews\nrssrtl=0\nrsstitle=1\nrssdesc=0\nrssimage=1\nrssitems=1\nrssitemdesc=1\nword_count=0\n\n', 0, 1, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_modules_menu`
--
CREATE TABLE IF NOT EXISTS `jos_modules_menu` (
`moduleid` int(11) NOT NULL DEFAULT '0',
`menuid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_modules_menu`
--
INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES
(1, 0),
(16, 1),
(17, 0),
(18, 1),
(19, 1),
(19, 2),
(19, 4),
(19, 27),
(19, 36),
(21, 1),
(22, 1),
(22, 2),
(22, 4),
(22, 27),
(22, 36),
(25, 0),
(27, 0),
(29, 0),
(30, 0),
(31, 1),
(32, 0),
(33, 0),
(34, 0),
(35, 0),
(36, 0),
(38, 1),
(39, 43),
(39, 44),
(39, 45),
(39, 46),
(39, 47),
(40, 0),
(44, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_newsfeeds`
--
CREATE TABLE IF NOT EXISTS `jos_newsfeeds` (
`catid` int(11) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`link` text NOT NULL,
`filename` varchar(200) DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`numarticles` int(11) unsigned NOT NULL DEFAULT '1',
`cache_time` int(11) unsigned NOT NULL DEFAULT '3600',
`checked_out` tinyint(3) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`rtl` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `published` (`published`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Daten für Tabelle `jos_newsfeeds`
--
INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `alias`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`, `rtl`) VALUES
(4, 1, 'Joomla! Ankündigungen', 'joomla-ankuendigungen', 'http://feeds.joomla.org/JoomlaAnnouncements', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(4, 2, 'Joomla! Core-Team Blog', 'joomla-core-team-blog', 'http://feeds.joomla.org/JoomlaCommunityCoreTeamBlog', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(4, 3, 'Joomla! Community-Magazin', 'joomla-community-magazin', 'http://feeds.joomla.org/JoomlaMagazine', '', 1, 20, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(4, 4, 'Joomla! Developer-News', 'joomla-developer-news', 'http://feeds.joomla.org/JoomlaDeveloper', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(4, 5, 'Joomla! Sicherheits-News', 'joomla-sicherheits-news', 'http://feeds.joomla.org/JoomlaSecurityNews', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 5, 0),
(5, 6, 'Free Software Foundation Blogs', 'free-software-foundation-blogs', 'http://www.fsf.org/blogs/RSS', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(5, 7, 'Free Software Foundation', 'free-software-foundation', 'http://www.fsf.org/news/RSS', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(5, 8, 'Software Freedom Law Center Blog', 'software-freedom-law-center-blog', 'http://www.softwarefreedom.org/feeds/blog/', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(5, 9, 'Software Freedom Law Center News', 'software-freedom-law-center', 'http://www.softwarefreedom.org/feeds/news/', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(5, 10, 'Open Source Initiative Blog', 'open-source-initiative-blog', 'http://www.opensource.org/blog/feed', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 5, 0),
(6, 11, 'PHP-News und Ankündigungen', 'php-news-und-ankuendigungen', 'http://www.php.net/feed.atom', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(6, 12, 'Planet MySQL', 'planet-mysql', 'http://www.planetmysql.org/rss20.xml', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(6, 13, 'Linux Foundation Ankündigungen', 'linux-foundation-ankuendigungen', 'http://www.linuxfoundation.org/press/rss20.xml', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(6, 14, 'Mootools Blog', 'mootools-blog', 'http://feeds.feedburner.com/mootools-blog', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(4, 15, 'J!German News', 'jgerman-news', 'http://www.jgerman.de/feed/rss.html', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 6, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_plugins`
--
CREATE TABLE IF NOT EXISTS `jos_plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`element` varchar(100) NOT NULL DEFAULT '',
`folder` varchar(100) NOT NULL DEFAULT '',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`published` tinyint(3) NOT NULL DEFAULT '0',
`iscore` tinyint(3) NOT NULL DEFAULT '0',
`client_id` tinyint(3) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
--
-- Daten für Tabelle `jos_plugins`
--
INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Authentifikation - Joomla', 'joomla', 'authentication', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(2, 'Authentifikation - LDAP', 'ldap', 'authentication', 0, 2, 0, 1, 0, 0, '0000-00-00 00:00:00', 'host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),
(3, 'Authentifikation - GMail', 'gmail', 'authentication', 0, 4, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(4, 'Authentifikation - OpenID', 'openid', 'authentication', 0, 3, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(5, 'Benutzer - Joomla!', 'joomla', 'user', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'autoregister=1\n\n'),
(6, 'Suche - Inhalte', 'content', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),
(7, 'Suche - Kontakte', 'contacts', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(8, 'Suche - Kategorien', 'categories', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(9, 'Suche - Bereiche', 'sections', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(10, 'Suche - Newsfeeds', 'newsfeeds', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(11, 'Suche - Weblinks', 'weblinks', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(12, 'Inhalt - Seitenumbruch', 'pagebreak', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', 'enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),
(13, 'Inhalt - Bewertung', 'vote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Inhalt - E-Mail-Verschleierung', 'emailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'mode=1\n\n'),
(15, 'Inhalt - Code-Hervorhebung (GeSHi)', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(16, 'Inhalt - Modul laden', 'loadmodule', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'enabled=1\nstyle=0\n\n'),
(17, 'Inhalt - Seitennavigation', 'pagenavigation', 'content', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'position=1\n\n'),
(18, 'Editor - Kein Editor', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Editor - TinyMCE', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'mode=advanced\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nentity_encoding=raw\nlang_mode=0\nlang_code=de\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%d.%m.%Y\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n'),
(20, 'Editor - XStandard Lite 2.0', 'xstandard', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(21, 'Editorbutton - Bild', 'image', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(22, 'Editorbutton - Seitenumbruch', 'pagebreak', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(23, 'Editorbutton - Weiterlesen', 'readmore', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(24, 'XML-RPC - Joomla', 'joomla', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(25, 'XML-RPC - Blogger-API', 'blogger', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', 'catid=1\nsectionid=0\n\n'),
(27, 'System - SEF', 'sef', 'system', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(28, 'System - Debug', 'debug', 'system', 0, 2, 1, 0, 0, 0, '0000-00-00 00:00:00', 'queries=1\nmemory=1\nlangauge=1\n\n'),
(29, 'System - Legacy', 'legacy', 'system', 0, 3, 0, 1, 0, 0, '0000-00-00 00:00:00', 'route=0\n\n'),
(30, 'System - Cache', 'cache', 'system', 0, 4, 0, 1, 0, 0, '0000-00-00 00:00:00', 'browsercache=0\ncachetime=15\n\n'),
(31, 'System - Protokoll', 'log', 'system', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(32, 'System - Angemeldet bleiben', 'remember', 'system', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(33, 'System - Backlink', 'backlink', 'system', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(34, 'System - Mootools Upgrade', 'mtupgrade', 'system', 0, 8, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_polls`
--
CREATE TABLE IF NOT EXISTS `jos_polls` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`voters` int(9) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`access` int(11) NOT NULL DEFAULT '0',
`lag` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Daten für Tabelle `jos_polls`
--
INSERT INTO `jos_polls` (`id`, `title`, `alias`, `voters`, `checked_out`, `checked_out_time`, `published`, `access`, `lag`) VALUES
(14, 'Wozu nutzen Sie Joomla!?', 'wozu-nutzen-sie-joomla', 11, 0, '0000-00-00 00:00:00', 1, 0, 86400);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_data`
--
CREATE TABLE IF NOT EXISTS `jos_poll_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pollid` int(11) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Daten für Tabelle `jos_poll_data`
--
INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES
(1, 14, 'Community-Seiten', 2),
(2, 14, 'Öffentliche Firmenseiten', 3),
(3, 14, 'eCommerce', 1),
(4, 14, 'Blogs', 0),
(5, 14, 'Intranets', 0),
(6, 14, 'Foto- und Medienseiten', 2),
(7, 14, 'Alles oben genannte!', 3),
(8, 14, '', 0),
(9, 14, '', 0),
(10, 14, '', 0),
(11, 14, '', 0),
(12, 14, '', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_date`
--
CREATE TABLE IF NOT EXISTS `jos_poll_date` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL DEFAULT '0',
`poll_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Daten für Tabelle `jos_poll_date`
--
INSERT INTO `jos_poll_date` (`id`, `date`, `vote_id`, `poll_id`) VALUES
(1, '2007-10-09 13:01:58', 1, 14),
(2, '2007-10-10 15:19:43', 7, 14),
(3, '2007-10-11 11:08:16', 7, 14),
(4, '2007-10-11 15:02:26', 2, 14),
(5, '2007-10-11 15:43:03', 7, 14),
(6, '2007-10-11 15:43:38', 7, 14),
(7, '2007-10-12 00:51:13', 2, 14),
(8, '2008-05-10 19:12:29', 3, 14),
(9, '2008-05-14 14:18:00', 6, 14),
(10, '2008-06-10 15:20:29', 6, 14),
(11, '2008-07-03 12:37:53', 2, 14);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_menu`
--
CREATE TABLE IF NOT EXISTS `jos_poll_menu` (
`pollid` int(11) NOT NULL DEFAULT '0',
`menuid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_poll_menu`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_sections`
--
CREATE TABLE IF NOT EXISTS `jos_sections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`image` text NOT NULL,
`scope` varchar(50) NOT NULL DEFAULT '',
`image_position` varchar(30) NOT NULL DEFAULT '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `jos_sections`
--
INSERT INTO `jos_sections` (`id`, `title`, `name`, `alias`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(5, 'Würfe', '', 'wuerfe', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 6, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_session`
--
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(150) DEFAULT '',
`time` varchar(14) DEFAULT '',
`session_id` varchar(200) NOT NULL DEFAULT '0',
`guest` tinyint(4) DEFAULT '1',
`userid` int(11) DEFAULT '0',
`usertype` varchar(50) DEFAULT '',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`client_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_session`
--
INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
('', '1309281561', 'cr5t821u0oo0gcsds8r74pldp3', 1, 0, '', 0, 0, '__default|a:7:{s:15:"session.counter";i:2;s:19:"session.timer.start";i:1309281550;s:18:"session.timer.last";i:1309281550;s:17:"session.timer.now";i:1309281561;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}}'),
('', '1309281508', 'l0ctl6jdm3ollqmpah88t4qmi5', 1, 0, '', 0, 1, '__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1309281504;s:18:"session.timer.last";i:1309281504;s:17:"session.timer.now";i:1309281504;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"e9f472033cbead189588a90b4111167c";}'),
('', '1309281570', 'ui88p4em1dvr3ktpca4m6o1tv4', 1, 0, '', 0, 1, '__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1309281570;s:18:"session.timer.last";i:1309281570;s:17:"session.timer.now";i:1309281570;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"fb34e38f247bdbd424138df4962eb522";}');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_stats_agents`
--
CREATE TABLE IF NOT EXISTS `jos_stats_agents` (
`agent` varchar(255) NOT NULL DEFAULT '',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_stats_agents`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_templates_menu`
--
CREATE TABLE IF NOT EXISTS `jos_templates_menu` (
`template` varchar(255) NOT NULL DEFAULT '',
`menuid` int(11) NOT NULL DEFAULT '0',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_templates_menu`
--
INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('nld_064_1.5', 0, 0),
('khepri', 0, 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_users`
--
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`username` varchar(150) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`usertype` varchar(25) NOT NULL DEFAULT '',
`block` tinyint(4) NOT NULL DEFAULT '0',
`sendEmail` tinyint(4) DEFAULT '0',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
`registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL DEFAULT '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
--
-- Daten für Tabelle `jos_users`
--
INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', '41e281394bb6e193fbf396692ecd5bb6:xo0bQOdZLFycfAy1HcMbVtIl3BaparTK', 'Super Administrator', 0, 1, 25, '2011-06-14 08:25:35', '2011-06-28 17:19:30', '', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_weblinks`
--
CREATE TABLE IF NOT EXISTS `jos_weblinks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(250) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`url` varchar(250) NOT NULL DEFAULT '',
`description` text NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`hits` int(11) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '1',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Daten für Tabelle `jos_weblinks`
--
INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES
(1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Das Zuhause von Joomla!', '2005-02-14 15:19:02', 3, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'),
(2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'Die Sprache, mit der Joomla! entwickelt wird', '2004-07-07 11:33:24', 6, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''),
(3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'Die Datenbank, die Joomla! nutzt', '2004-07-07 10:18:31', 1, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''),
(4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Das Zuhause von OSM', '2005-02-14 15:19:02', 11, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0'),
(5, 2, 0, 'Joomla!-Foren', 'joomla-foren', 'http://forum.joomla.org', 'Joomla! Foren', '2005-02-14 15:19:02', 4, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0'),
(6, 2, 0, 'Ohloh über Joomla!', 'ohloh-ueber-joomla', 'http://www.ohloh.net/projects/20', 'Sachliche Berichte von Ohloo über die Aktivitäten der Joomla-Entwicklung. Joomla! hat einige ernsthaft anerkannte Star-Programmierer.', '2007-07-19 09:28:31', 1, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');
/*!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 */;
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 28. Juni 2011 um 19:24
-- Server Version: 5.1.41
-- PHP-Version: 5.3.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!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 */;
--
-- Datenbank: `heropitdb`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_banner`
--
CREATE TABLE IF NOT EXISTS `jos_banner` (
`bid` int(11) NOT NULL AUTO_INCREMENT,
`cid` int(11) NOT NULL DEFAULT '0',
`type` varchar(30) NOT NULL DEFAULT 'banner',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`imptotal` int(11) NOT NULL DEFAULT '0',
`impmade` int(11) NOT NULL DEFAULT '0',
`clicks` int(11) NOT NULL DEFAULT '0',
`imageurl` varchar(100) NOT NULL DEFAULT '',
`clickurl` varchar(200) NOT NULL DEFAULT '',
`date` datetime DEFAULT NULL,
`showBanner` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` tinyint(1) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` varchar(50) DEFAULT NULL,
`custombannercode` text,
`catid` int(10) unsigned NOT NULL DEFAULT '0',
`description` text NOT NULL,
`sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`tags` text NOT NULL,
`params` text NOT NULL,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`),
KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
--
-- Daten für Tabelle `jos_banner`
--
INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `alias`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`, `catid`, `description`, `sticky`, `ordering`, `publish_up`, `publish_down`, `tags`, `params`) VALUES
(1, 1, 'banner', 'OSM 1', 'osm-1', 0, 43, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(2, 1, 'banner', 'OSM 2', 'osm-2', 0, 49, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', '', '', 13, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(3, 1, '', 'Joomla!', 'joomla', 0, 34, 0, '', 'http://www.joomla.org', '2006-05-29 14:21:28', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla!, das bekannteste und meistgenutzte Open-Source-CMS-Projekt der Welt.', 14, '', 0, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(4, 1, '', 'JoomlaCode', 'joomlacode', 0, 34, 0, '', 'http://joomlacode.org', '2006-05-29 14:19:26', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomlaCode - Entwicklung und Verbreitung einfach gemacht.', 14, '', 0, 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(5, 1, '', 'Joomla!-Erweitungen', 'joomla-erweitungen', 0, 29, 0, '', 'http://extensions.joomla.org', '2006-05-29 14:23:21', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nJoomla!-Komponenten, Module, Plugins und Übersetzungen zentral.', 14, '', 0, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(6, 1, '', 'Joomla!-Shop', 'joomla-shop', 0, 29, 0, '', 'http://shop.joomla.org', '2006-05-29 14:23:21', 1, 0, '0000-00-00 00:00:00', '', '<a href="/{CLICKURL}" target="_blank">{NAME}</a>\r\n<br/>\r\nFür alle Ihre Joomla!-Artikel.', 14, '', 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(7, 1, '', 'Joomla! Promo-Artikel', 'joomla-promo-artikel', 0, 8, 1, 'shop-ad.jpg', 'http://shop.joomla.org', '2007-09-19 17:26:24', 1, 0, '0000-00-00 00:00:00', '', '', 33, '', 0, 3, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', ''),
(8, 1, '', 'Joomla!-Bücher', 'joomla-buecher', 0, 9, 0, 'shop-ad-books.jpg', 'http://shop.joomla.org/amazoncom-bookstores.html', '2007-09-19 17:28:01', 1, 0, '0000-00-00 00:00:00', '', '', 33, '', 0, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_bannerclient`
--
CREATE TABLE IF NOT EXISTS `jos_bannerclient` (
`cid` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`contact` varchar(255) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL DEFAULT '0',
`checked_out_time` time DEFAULT NULL,
`editor` varchar(50) DEFAULT NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `jos_bannerclient`
--
INSERT INTO `jos_bannerclient` (`cid`, `name`, `contact`, `email`, `extrainfo`, `checked_out`, `checked_out_time`, `editor`) VALUES
(1, 'Open Source Matters', 'Administrator', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', '', 0, '00:00:00', NULL);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_bannertrack`
--
CREATE TABLE IF NOT EXISTS `jos_bannertrack` (
`track_date` date NOT NULL,
`track_type` int(10) unsigned NOT NULL,
`banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_bannertrack`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_categories`
--
CREATE TABLE IF NOT EXISTS `jos_categories` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`image` varchar(255) NOT NULL DEFAULT '',
`section` varchar(50) NOT NULL DEFAULT '',
`image_position` varchar(30) NOT NULL DEFAULT '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`editor` varchar(50) DEFAULT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=40 ;
--
-- Daten für Tabelle `jos_categories`
--
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES
(2, 0, 'Links rund um Joomla!', '', 'links-rund-um-joomla', 'clock.jpg', 'com_weblinks', 'left', 'Eine Auswahl an Weblinks, die mit dem Joomla!-Projekt zu tun haben.', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(4, 0, 'Joomla!', '', 'joomla', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(5, 0, 'Freie und Open Source-Software', '', 'freie-und-open-source-software', '', 'com_newsfeeds', 'left', 'Lesen Sie das Neueste über Freie und Open Source Software von einigen der führenden Verfechtern.', 1, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(6, 0, 'Related Projects', '', 'related-projects', '', 'com_newsfeeds', 'left', 'Joomla basiert auf andere Freie und Open Source Projekte und arbeitet mit vielen zusammen. Wir haben einige ausgewählt, damit Sie auf dem Laufenden bleiben.', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(12, 0, 'Kontakte', '', 'kontakte', '', 'com_contact_details', 'left', 'Details zu den Kontakten dieser Webseite', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(13, 0, 'Joomla', '', 'joomla', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(14, 0, 'Text-Werbung', '', 'text-werbung', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(15, 0, 'Merkmale', '', 'merkmale', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, ''),
(17, 0, 'Benefits', '', 'benefits', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(18, 0, 'Plattformen', '', 'plattformen', '', 'com_content', 'left', '', 0, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(19, 0, 'Andere Quellen', '', 'andere-quellen', '', 'com_weblinks', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(34, 0, 'Dafne von der Wallmey', '', 'dafne-von-der-wallmey', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(35, 0, 'Amber vom Hollingerbach', '', 'amber-vom-hollingerbach', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, ''),
(36, 0, 'Cora von Wext', '', 'cora-von-wext', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 3, 0, 0, ''),
(37, 0, 'Gina vom Besterfeld', '', 'gina-vom-besterfeld', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(38, 0, 'Biene von Neibur', '', 'biene-von-neibur', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, ''),
(39, 0, 'Linda von Pannonia', '', 'linda-von-pannonia', '', '5', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, ''),
(33, 0, 'Joomla! Promo', '', 'joomla-promo', '', 'com_banner', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_components`
--
CREATE TABLE IF NOT EXISTS `jos_components` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL DEFAULT '',
`link` varchar(255) NOT NULL DEFAULT '',
`menuid` int(11) unsigned NOT NULL DEFAULT '0',
`parent` int(11) unsigned NOT NULL DEFAULT '0',
`admin_menu_link` varchar(255) NOT NULL DEFAULT '',
`admin_menu_alt` varchar(255) NOT NULL DEFAULT '',
`option` varchar(50) NOT NULL DEFAULT '',
`ordering` int(11) NOT NULL DEFAULT '0',
`admin_menu_img` varchar(255) NOT NULL DEFAULT '',
`iscore` tinyint(4) NOT NULL DEFAULT '0',
`params` text NOT NULL,
`enabled` tinyint(4) NOT NULL DEFAULT '1',
PRIMARY KEY (`id`),
KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=34 ;
--
-- Daten für Tabelle `jos_components`
--
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`, `enabled`) VALUES
(1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, 'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n', 1),
(2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/component.png', 0, 'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n', 1),
(5, 'Links', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(6, 'Categories', '', 0, 4, 'option=com_categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1),
(8, 'Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '', 1),
(9, 'Categories', '', 0, 7, 'option=com_categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1),
(10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(12, 'Feeds', '', 0, 11, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, 'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n', 1),
(13, 'Categories', '', 0, 11, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(14, 'User', 'option=com_user', 0, 0, '', '', 'com_user', 0, '', 1, '', 1),
(15, 'Search', 'option=com_search', 0, 0, 'option=com_search', 'Search Statistics', 'com_search', 0, 'js/ThemeOffice/component.png', 1, 'enabled=0\n\n', 1),
(16, 'Categories', '', 0, 1, 'option=com_categories§ion=com_banner', 'Categories', '', 3, '', 1, '', 1),
(17, 'Wrapper', 'option=com_wrapper', 0, 0, '', 'Wrapper', 'com_wrapper', 0, '', 1, '', 1),
(18, 'Mail To', '', 0, 0, '', '', 'com_mailto', 0, '', 1, '', 1),
(19, 'Media Manager', '', 0, 0, 'option=com_media', 'Media Manager', 'com_media', 0, '', 1, 'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html', 1),
(20, 'Articles', 'option=com_content', 0, 0, '', '', 'com_content', 0, '', 1, 'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=0\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_item_navigation=0\nshow_readmore=0\nshow_vote=0\nshow_icons=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nshow_hits=0\nfeed_summary=0\nfilter_tags=\nfilter_attritbutes=\n\n', 1),
(21, 'Configuration Manager', '', 0, 0, '', 'Configuration', 'com_config', 0, '', 1, '', 1),
(22, 'Installation Manager', '', 0, 0, '', 'Installer', 'com_installer', 0, '', 1, '', 1),
(23, 'Language Manager', '', 0, 0, '', 'Languages', 'com_languages', 0, '', 1, 'administrator=de-DE\nsite=de-DE', 1),
(24, 'Mass mail', '', 0, 0, '', 'Mass Mail', 'com_massmail', 0, '', 1, 'mailSubjectPrefix=\nmailBodySuffix=\n\n', 1),
(25, 'Menu Editor', '', 0, 0, '', 'Menu Editor', 'com_menus', 0, '', 1, '', 1),
(27, 'Messaging', '', 0, 0, '', 'Messages', 'com_messages', 0, '', 1, '', 1),
(28, 'Modules Manager', '', 0, 0, '', 'Modules', 'com_modules', 0, '', 1, '', 1),
(29, 'Plugin Manager', '', 0, 0, '', 'Plugins', 'com_plugins', 0, '', 1, '', 1),
(30, 'Template Manager', '', 0, 0, '', 'Templates', 'com_templates', 0, '', 1, '', 1),
(31, 'User Manager', '', 0, 0, '', 'Users', 'com_users', 0, '', 1, 'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n', 1),
(32, 'Cache Manager', '', 0, 0, '', 'Cache', 'com_cache', 0, '', 1, '', 1),
(33, 'Control Panel', '', 0, 0, '', 'Control Panel', 'com_cpanel', 0, '', 1, '', 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_contact_details`
--
CREATE TABLE IF NOT EXISTS `jos_contact_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`con_position` varchar(255) DEFAULT NULL,
`address` text,
`suburb` varchar(100) DEFAULT NULL,
`state` varchar(100) DEFAULT NULL,
`country` varchar(100) DEFAULT NULL,
`postcode` varchar(100) DEFAULT NULL,
`telephone` varchar(255) DEFAULT NULL,
`fax` varchar(255) DEFAULT NULL,
`misc` mediumtext,
`image` varchar(255) DEFAULT NULL,
`imagepos` varchar(20) DEFAULT NULL,
`email_to` varchar(255) DEFAULT NULL,
`default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
`published` tinyint(1) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL DEFAULT '0',
`catid` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mobile` varchar(255) NOT NULL DEFAULT '',
`webpage` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
--
-- Daten für Tabelle `jos_contact_details`
--
INSERT INTO `jos_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`) VALUES
(1, 'Hero Pit von Niedersachsenstein', 'hero-pit-von-niedersachsenstein', 'Inhaber Ansgar Vosskötter', 'Hauptstr. 12', '27384 Visshausen', '', '', '', '01234-567263', '', '', 'kontaktbild.png', 'top', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', 0, 1, 0, '0000-00-00 00:00:00', 1, 'show_name=1\nshow_position=1\nshow_email=1\nshow_street_address=1\nshow_suburb=1\nshow_state=0\nshow_postcode=0\nshow_country=0\nshow_telephone=1\nshow_mobile=0\nshow_fax=0\nshow_webpage=1\nshow_misc=0\nshow_image=0\nallow_vcard=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_email_form=1\nemail_description=1\nshow_email_copy=1\nbanned_email=\nbanned_subject=\nbanned_text=', 0, 12, 0, '', 'http://www.hero-pit.de');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content`
--
CREATE TABLE IF NOT EXISTS `jos_content` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`title_alias` varchar(255) NOT NULL DEFAULT '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL DEFAULT '0',
`sectionid` int(11) unsigned NOT NULL DEFAULT '0',
`mask` int(11) unsigned NOT NULL DEFAULT '0',
`catid` int(11) unsigned NOT NULL DEFAULT '0',
`created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL DEFAULT '0',
`created_by_alias` varchar(255) NOT NULL DEFAULT '',
`modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL DEFAULT '1',
`parentid` int(11) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '0',
`metadata` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=54 ;
--
-- Daten für Tabelle `jos_content`
--
INSERT INTO `jos_content` (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`) VALUES
(50, 'Cora von Wext', 'cora-von-wext', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Dack von Wext</strong></td>\r\n<td width="101" align="RIGHT"><strong>13.10.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Dolly von Wext</strong></td>\r\n<td align="RIGHT"><strong>13.10.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 36, '2011-06-20 06:54:52', 62, '', '2011-06-20 07:01:35', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:54:52', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 6, 'robots=\nauthor='),
(51, 'Gina vom Besterfeld', 'gina-vom-besterfeld', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Hanjo vom Bester Feld</strong></td>\r\n<td width="101" align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Heik vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hero vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Heron vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hedda vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hella vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hera vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Hilde vom Bester Feld</strong></td>\r\n<td align="RIGHT"><strong>28.02.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 37, '2011-06-20 06:56:27', 62, '', '2011-06-20 07:01:52', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:56:27', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 5, 'robots=\nauthor='),
(52, 'Biene von Neibur', 'biene-von-neibur', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Ecky von Neibur</strong></td>\r\n<td width="101" align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Eddy von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ede von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Erick von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ella von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Elly von Neibur</strong></td>\r\n<td align="RIGHT"><strong>10.05.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 38, '2011-06-20 06:57:47', 62, '', '2011-06-20 07:01:14', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:57:47', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 2, 'robots=\nauthor='),
(53, 'Linda von Pannonia', 'linda-von-pannonia', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>ALF vom Eulenfelsen</strong></td>\r\n<td width="101" align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Arco vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Artus vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Asko vom eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Aika vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Amsel vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Anka vom Eulenfelsen</strong></td>\r\n<td align="RIGHT"><strong>16.06.2010</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 39, '2011-06-20 06:59:11', 62, '', '2011-06-20 07:01:59', 62, 0, '0000-00-00 00:00:00', '2011-06-20 06:59:11', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 2, 'robots=\nauthor='),
(46, 'Leistungsdaten', 'leistungsdaten', '', '<p>Hero Pit vom Niedersachsenstein</p>\r\n<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="82"></col><col width="82"></col><col width="88"></col><col width="107"></col><col width="92"></col><col width="94"></col><col width="82"></col><col width="82"></col><col width="97"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td style="border: 1px solid #000000;" width="82" height="50" align="LEFT"><span style="font-family: Tahoma;">VJP</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">HZP</span></td>\r\n<td style="border: 1px solid #000000;" width="88" align="CENTER"><span style="font-family: Tahoma;">Rauhwolf ZuchtausleseHZP</span></td>\r\n<td style="border: 1px solid #000000;" width="107" align="LEFT"><span style="font-family: Tahoma;">VGP</span></td>\r\n<td style="border: 1px solid #000000;" width="92" align="LEFT"><span style="font-family: Tahoma;">HD-Untersuchung</span></td>\r\n<td style="border: 1px solid #000000;" width="94" align="LEFT"><span style="font-family: Tahoma;">Augen-untersuchung</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">Formwert/ Haarwert</span></td>\r\n<td style="border: 1px solid #000000;" width="82" align="LEFT"><span style="font-family: Tahoma;">Größe</span></td>\r\n<td style="border: 1px solid #000000;" width="97" align="LEFT"><span style="font-family: Tahoma;">weitere Prüfungen</span></td>\r\n</tr>\r\n<tr>\r\n<td height="18" align="RIGHT">71</td>\r\n<td align="LEFT"><br /></td>\r\n<td align="LEFT">184+ 30</td>\r\n<td align="LEFT">327/1PR</td>\r\n<td align="CENTER">A</td>\r\n<td align="LEFT">frei 2010</td>\r\n<td align="LEFT">Sg V</td>\r\n<td align="RIGHT">57</td>\r\n<td align="LEFT">Btr/AH</td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 0, 0, 0, '2011-06-15 10:11:24', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2011-06-15 10:11:24', '0000-00-00 00:00:00', '', '', 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 1, 0, 4, '', '', 0, 21, 'robots=\nauthor='),
(47, 'Dafne von der Wallmey', 'dafne-von-der-wallmey', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Aaron vom Albrock</strong></td>\r\n<td width="101" align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Ares vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Amie vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Annie vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Aruscha vom Albrock</strong></td>\r\n<td align="RIGHT"><strong>14.02.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 34, '2011-06-15 10:14:52', 62, '', '2011-06-20 07:01:43', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:14:52', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 3, 0, 1, '', '', 0, 35, 'robots=\nauthor='),
(48, 'Amber vom Hollingerbach', 'amber-vom-hollingerbach', '', '<p> </p>\r\n<table border="0" cellspacing="0" frame="VOID" rules="NONE">\r\n<colgroup><col width="178"></col><col width="101"></col></colgroup> \r\n<tbody>\r\n<tr>\r\n<td width="178" height="17" align="LEFT"><strong>Xandor vom Rauhenbusch</strong></td>\r\n<td width="101" align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xaver vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xana vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xandra vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xara vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xeli vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xenia vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xilla vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n<tr>\r\n<td height="17" align="LEFT"><strong>Xilly vom Rauhenbusch</strong></td>\r\n<td align="RIGHT"><strong>31.05.2009</strong></td>\r\n</tr>\r\n</tbody>\r\n</table>', '', 1, 5, 0, 35, '2011-06-15 10:17:28', 62, '', '2011-06-20 07:01:06', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:17:28', '0000-00-00 00:00:00', '', '', 'show_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 3, 0, 1, '', '', 0, 12, 'robots=\nauthor='),
(49, 'Willkommen', 'willkommen', '', '<p>Willkommen auf der Website von Hero Pit von Niedersachsenstein!</p>', '', 1, 0, 0, 0, '2011-06-15 10:19:49', 62, '', '2011-06-15 12:07:09', 62, 0, '0000-00-00 00:00:00', '2011-06-15 10:19:49', '0000-00-00 00:00:00', '', '', 'show_title=0\nlink_titles=0\nshow_intro=0\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_vote=0\nshow_author=0\nshow_create_date=0\nshow_modify_date=0\nshow_pdf_icon=0\nshow_print_icon=0\nshow_email_icon=0\nlanguage=de-DE\nkeyref=\nreadmore=', 2, 0, 1, '', '', 0, 207, 'robots=\nauthor=');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content_frontpage`
--
CREATE TABLE IF NOT EXISTS `jos_content_frontpage` (
`content_id` int(11) NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_content_frontpage`
--
INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES
(49, 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_content_rating`
--
CREATE TABLE IF NOT EXISTS `jos_content_rating` (
`content_id` int(11) NOT NULL DEFAULT '0',
`rating_sum` int(11) unsigned NOT NULL DEFAULT '0',
`rating_count` int(11) unsigned NOT NULL DEFAULT '0',
`lastip` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_content_rating`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`section_value` varchar(240) NOT NULL DEFAULT '0',
`value` varchar(240) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Daten für Tabelle `jos_core_acl_aro`
--
INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_groups`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`parent_id` int(11) NOT NULL DEFAULT '0',
`name` varchar(255) NOT NULL DEFAULT '',
`lft` int(11) NOT NULL DEFAULT '0',
`rgt` int(11) NOT NULL DEFAULT '0',
`value` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;
--
-- Daten für Tabelle `jos_core_acl_aro_groups`
--
INSERT INTO `jos_core_acl_aro_groups` (`id`, `parent_id`, `name`, `lft`, `rgt`, `value`) VALUES
(17, 0, 'ROOT', 1, 22, 'ROOT'),
(28, 17, 'USERS', 2, 21, 'USERS'),
(29, 28, 'Public Frontend', 3, 12, 'Public Frontend'),
(18, 29, 'Registered', 4, 11, 'Registered'),
(19, 18, 'Author', 5, 10, 'Author'),
(20, 19, 'Editor', 6, 9, 'Editor'),
(21, 20, 'Publisher', 7, 8, 'Publisher'),
(30, 28, 'Public Backend', 13, 20, 'Public Backend'),
(23, 30, 'Manager', 14, 19, 'Manager'),
(24, 23, 'Administrator', 15, 18, 'Administrator'),
(25, 24, 'Super Administrator', 16, 17, 'Super Administrator');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_map` (
`acl_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(230) NOT NULL DEFAULT '0',
`value` varchar(100) NOT NULL,
PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_acl_aro_map`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_aro_sections`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(230) NOT NULL DEFAULT '',
`order_value` int(11) NOT NULL DEFAULT '0',
`name` varchar(230) NOT NULL DEFAULT '',
`hidden` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;
--
-- Daten für Tabelle `jos_core_acl_aro_sections`
--
INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_acl_groups_aro_map`
--
CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` (
`group_id` int(11) NOT NULL DEFAULT '0',
`section_value` varchar(240) NOT NULL DEFAULT '',
`aro_id` int(11) NOT NULL DEFAULT '0',
UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_acl_groups_aro_map`
--
INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(25, '', 10);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_log_items`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_items` (
`time_stamp` date NOT NULL DEFAULT '0000-00-00',
`item_table` varchar(50) NOT NULL DEFAULT '',
`item_id` int(11) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_log_items`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_core_log_searches`
--
CREATE TABLE IF NOT EXISTS `jos_core_log_searches` (
`search_term` varchar(128) NOT NULL DEFAULT '',
`hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_core_log_searches`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_groups`
--
CREATE TABLE IF NOT EXISTS `jos_groups` (
`id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_groups`
--
INSERT INTO `jos_groups` (`id`, `name`) VALUES
(0, 'Public'),
(1, 'Registered'),
(2, 'Special');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_menu`
--
CREATE TABLE IF NOT EXISTS `jos_menu` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`menutype` varchar(75) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`link` text,
`type` varchar(50) NOT NULL DEFAULT '',
`published` tinyint(1) NOT NULL DEFAULT '0',
`parent` int(11) unsigned NOT NULL DEFAULT '0',
`componentid` int(11) unsigned NOT NULL DEFAULT '0',
`sublevel` int(11) DEFAULT '0',
`ordering` int(11) DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`pollid` int(11) NOT NULL DEFAULT '0',
`browserNav` tinyint(4) DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`utaccess` tinyint(3) unsigned NOT NULL DEFAULT '0',
`params` text NOT NULL,
`lft` int(11) unsigned NOT NULL DEFAULT '0',
`rgt` int(11) unsigned NOT NULL DEFAULT '0',
`home` int(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=69 ;
--
-- Daten für Tabelle `jos_menu`
--
INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `alias`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`, `lft`, `rgt`, `home`) VALUES
(1, 'mainmenu', 'Startseite', 'home', 'index.php?option=com_content&view=article&id=49', 'component', 1, 0, 20, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=\npage_title=Willkommen auf der Startseite\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 1),
(18, 'mainmenu', 'Würfe', 'wuerfe', 'index.php?option=com_content&view=section&id=5', 'component', 0, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'show_description=1\nshow_description_image=0\nshow_categories=0\nshow_empty_categories=0\nshow_cat_num_articles=0\nshow_category_description=0\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=1\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(20, 'usermenu', 'Ihre Details', 'ihre-details', 'index.php?option=com_user&view=user&task=edit', 'component', 1, 0, 14, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, '', 0, 0, 0),
(24, 'usermenu', 'Abmelden', 'abmelden', 'index.php?option=com_user&view=login', 'component', 1, 0, 14, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, '', 0, 0, 0),
(61, 'mainmenu', 'Gina vom Besterfeld', 'gina-vom-besterfeld', 'index.php?option=com_content&view=article&id=51', 'component', 1, 0, 20, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(60, 'mainmenu', 'Cora von Wext', 'cora-von-wext', 'index.php?option=com_content&view=article&id=50', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(66, 'Menu-oben', 'Leistungsdaten', 'leistungsdaten', 'index.php?option=com_content&view=article&id=46', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(68, 'Menu-oben', 'Willkommen', 'willkommen', 'index.php?option=com_content&view=article&id=49', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(67, 'Menu-oben', 'Kontakt', 'kontakt', 'index.php?option=com_contact&view=contact&id=1', 'component', 1, 0, 7, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_contact_list=0\nshow_category_crumb=0\ncontact_icons=\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_headings=\nshow_position=\nshow_email=\nshow_telephone=\nshow_mobile=\nshow_fax=\nallow_vcard=\nbanned_email=\nbanned_subject=\nbanned_text=\nvalidate_session=\ncustom_reply=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(51, 'usermenu', 'Beitrag einreichen', 'beitrag-einreichen', 'index.php?option=com_content&view=article&layout=form', 'component', 1, 0, 20, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, '', 0, 0, 0),
(52, 'usermenu', 'Weblink einreichen', 'weblink-einreichen', 'index.php?option=com_weblinks&view=weblink&layout=form', 'component', 1, 0, 4, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, '', 0, 0, 0),
(62, 'mainmenu', 'Biene von Neibur', 'biene-von-neibur', 'index.php?option=com_content&view=article&id=52', 'component', 1, 0, 20, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(63, 'mainmenu', 'Linda von Pannonia', 'linda-von-pannonia', 'index.php?option=com_content&view=article&id=53', 'component', 1, 0, 20, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(64, 'mainmenu', 'Dafne von der Wallmey', 'dafne-von-der-wallmey', 'index.php?option=com_content&view=article&id=47', 'component', 1, 0, 20, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(65, 'mainmenu', 'Amber vom Hollingerbach', 'amber-vom-hollingerbach', 'index.php?option=com_content&view=article&id=48', 'component', 1, 0, 20, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_menu_types`
--
CREATE TABLE IF NOT EXISTS `jos_menu_types` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`menutype` varchar(75) NOT NULL DEFAULT '',
`title` varchar(255) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Daten für Tabelle `jos_menu_types`
--
INSERT INTO `jos_menu_types` (`id`, `menutype`, `title`, `description`) VALUES
(1, 'mainmenu', 'Würfe', 'Das Hauptmenü dieser Website'),
(2, 'usermenu', 'Benutzermenü', 'Ein Menü für angemeldete Benutzer'),
(7, 'Menu-oben', 'Menu oben', 'Menu oben');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_messages`
--
CREATE TABLE IF NOT EXISTS `jos_messages` (
`message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
`user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
`folder_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`state` int(11) NOT NULL DEFAULT '0',
`priority` int(1) unsigned NOT NULL DEFAULT '0',
`subject` text NOT NULL,
`message` text NOT NULL,
PRIMARY KEY (`message_id`),
KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `jos_messages`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_messages_cfg`
--
CREATE TABLE IF NOT EXISTS `jos_messages_cfg` (
`user_id` int(10) unsigned NOT NULL DEFAULT '0',
`cfg_name` varchar(100) NOT NULL DEFAULT '',
`cfg_value` varchar(255) NOT NULL DEFAULT '',
UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_messages_cfg`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_migration_backlinks`
--
CREATE TABLE IF NOT EXISTS `jos_migration_backlinks` (
`itemid` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`url` text NOT NULL,
`sefurl` text NOT NULL,
`newurl` text NOT NULL,
PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_migration_backlinks`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_modules`
--
CREATE TABLE IF NOT EXISTS `jos_modules` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` text NOT NULL,
`content` text NOT NULL,
`ordering` int(11) NOT NULL DEFAULT '0',
`position` varchar(50) DEFAULT NULL,
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`module` varchar(50) DEFAULT NULL,
`numnews` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
`params` text NOT NULL,
`iscore` tinyint(4) NOT NULL DEFAULT '0',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
`control` text NOT NULL,
PRIMARY KEY (`id`),
KEY `published` (`published`,`access`),
KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;
--
-- Daten für Tabelle `jos_modules`
--
INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`, `control`) VALUES
(1, 'Würfe', '', 0, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=1\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 1, 0, ''),
(2, 'Anmeldung', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, ''),
(3, 'Beliebt', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 2, 1, '', 0, 1, ''),
(4, 'Neue Beiträge', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 2, 1, 'ordering=c_dsc\nuser_id=0\ncache=0\n\n', 0, 1, ''),
(5, 'Statistiken', '', 6, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 2, 1, '', 0, 1, ''),
(6, 'Ungelesene Nachrichten', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 2, 1, '', 1, 1, ''),
(7, 'Benutzer online', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 2, 1, '', 1, 1, ''),
(8, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 2, 1, '', 1, 1, ''),
(9, 'Quick-Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 2, 1, '', 1, 1, ''),
(10, 'Angemeldete Benutzer', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 2, 1, '', 0, 1, ''),
(11, 'Fußzeile', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, ''),
(12, 'Admin-Menü', '', 1, 'menu', 0, '0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1, '', 0, 1, ''),
(13, 'Admin-Untermenü', '', 1, 'submenu', 0, '0000-00-00 00:00:00', 1, 'mod_submenu', 0, 2, 1, '', 0, 1, ''),
(14, 'Benutzerstatus', '', 1, 'status', 0, '0000-00-00 00:00:00', 1, 'mod_status', 0, 2, 1, '', 0, 1, ''),
(15, 'Titel', '', 1, 'title', 0, '0000-00-00 00:00:00', 1, 'mod_title', 0, 2, 1, '', 0, 1, ''),
(43, 'Update nötig?', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_jgerman', 0, 2, 1, 'select_language=de-DE\nauto_check=auto_check_no\ncheck_core=check_core_show\ndelete_notice=delete_notice_show\nimage_size=middle\ncache=0\n\n', 0, 1, ''),
(16, 'Umfragen', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_poll', 0, 0, 1, 'id=14\ncache=1', 0, 0, ''),
(17, 'Benutzermenü', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu\nmoduleclass_sfx=_menu\ncache=1', 1, 0, ''),
(18, 'Anmeldung', '', 5, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_login', 0, 0, 1, 'greeting=1\nname=0', 1, 0, ''),
(19, 'Neueste Nachrichten', '', 4, 'user1', 0, '0000-00-00 00:00:00', 0, 'mod_latestnews', 0, 0, 1, 'cache=1', 1, 0, ''),
(20, 'Statistiken', '', 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, ''),
(21, 'Wer ist online', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0, ''),
(22, 'Meist gelesen', '', 6, 'user2', 0, '0000-00-00 00:00:00', 0, 'mod_mostread', 0, 0, 1, 'cache=1', 0, 0, ''),
(23, 'Archiv', '', 6, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, 'cache=1', 1, 0, ''),
(24, 'Bereiche', '', 7, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, 'cache=1', 1, 0, ''),
(25, 'Schlagzeilen', '', 1, 'top', 0, '0000-00-00 00:00:00', 0, 'mod_newsflash', 0, 0, 1, 'catid=3\r\nstyle=random\r\nitems=\r\nmoduleclass_sfx=', 0, 0, ''),
(26, 'Verwandte Beiträge', '', 8, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0, ''),
(27, 'Suche', '', 1, 'user4', 0, '0000-00-00 00:00:00', 0, 'mod_search', 0, 0, 0, 'cache=1', 0, 0, ''),
(28, 'Zufallsbild', '', 9, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_random_image', 0, 0, 1, '', 0, 0, ''),
(30, 'Banner', '', 1, 'footer', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 0, 'target=1\ncount=1\ncid=1\ncatid=33\ntag_search=0\nordering=random\nheader_text=\nfooter_text=\nmoduleclass_sfx=\ncache=1\ncache_time=900\n\n', 1, 0, ''),
(32, 'Wrapper', '', 9, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0, ''),
(33, 'Fußzeile', '', 2, 'footer', 0, '0000-00-00 00:00:00', 0, 'mod_footer', 0, 0, 0, 'cache=1\n\n', 1, 0, ''),
(34, 'Feed-Anzeige', '', 10, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_feed', 0, 0, 1, '', 1, 0, ''),
(35, 'Navigationspfad (Breadcrumb)', '', 1, 'breadcrumb', 0, '0000-00-00 00:00:00', 0, 'mod_breadcrumbs', 0, 0, 1, 'moduleclass_sfx=\ncache=0\nshowHome=1\nhomeText=Start\nshowComponent=1\nseparator=\n\n', 1, 0, ''),
(36, 'Syndication', '', 3, 'syndicate', 0, '0000-00-00 00:00:00', 0, 'mod_syndicate', 0, 0, 0, '', 1, 0, ''),
(38, 'Werbung', '', 3, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_banners', 0, 0, 1, 'count=4\r\nrandomise=0\r\ncid=0\r\ncatid=14\r\nheader_text=Empfohlene Links:\r\nfooter_text=<a href="http://www.joomla.org">Inserate von Joomla!</a>\r\nmoduleclass_sfx=_text\r\ncache=0\r\n\r\n', 0, 0, ''),
(44, 'Menu oben', '', 0, 'user3', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=Menu-oben\nmenu_style=list_flat\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=-nav\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''),
(41, 'Willkommen bei Joomla!', '<div style="padding: 5px"><p>Gratulation, dass Sie Joomla! als Ihr Content-Management-System gewählt haben. Wir hoffen, dass es Ihnen mit unserem Programm gelingt eine erfolgreiche Website zu erstellen und der Gemeinschaft vielleicht zu einem späteren Punkt etwas zurückgeben können.</p><p>Um Ihren Anfang mit Joomla! so einfach wie möglich zu gestalten, möchten wir Ihnen einige Punkte aufzeigen, wie z.B. allgemeinen Fragen, Hilfen und Sicherheit Ihres Server.</p><p>Sie sollten mit dem "<a href="http://docs.joomla.org/beginners" target="_blank">Absolute Beginners Guide to Joomla!</a>" anfangen und dann, um die Sicherheit Ihres Servers zu gewährleisten, die "<a href="http://forum.joomla.org/viewtopic.php?t=81058" target="_blank">Security Checklist</a>" lesen.</p><p>Für Ihre häufig gestellten Fragen sollten Sie zuerst ins <a href="http://forum.joomla.org" target="_blank">Forum</a> schauen und die <a href="http://docs.joomla.org/Category:FAQ" target="_blank">FAQ</a> im Wiki lesen. Im Forum finden Sie eine Antwort auf fast alle Ihre Fragen. Auch wenn diese bisher nur einmal von anderen beantwortet wurden, so ist das Forum ein großes Nachschlagewerk für Anfänger und Profis. Bitte benutzen Sie die Suchfunktion des Forums bevor Sie Ihre Frage stellen, es könnte nämlich sein, dass diese schon einmal gestellt wurde. <img alt="Lächeln" border="0" src="/../plugins/editors/tinymce/jscripts/tiny_mce/plugins/emotions/images/smiley-smile.gif" title="Lächeln" /></p><p>Die Sicherheit ist ein großes Anliegen für uns, deshalb würden wir es begrüßen, wenn Sie das "<a href="http://forum.joomla.org/viewforum.php?f=8" target="_blank">Announcement-Forum</a>" abonnieren würden, damit Sie immer aktuelle Informationen über neue Joomla!-Versionen bekommen. Sie sollten aber auch regelmäßig das "<a href="http://forum.joomla.org/viewforum.php?f=432" target="_blank">Security-Forum</a>" besuchen.</p><p>Wir hoffen, dass Sie viel Spaß und Erfolg mit Joomla! haben und Sie bald unter den Hunderten bzw. Tausenden an Joomla!-Benutzern sind, die Anfängern helfen können.</p><p>Ihr Joomla!-Team</p><p>P.S.: Um diese Anzeige zu entfernen, löschen Sie einfach das "Willkommen bei Joomla!"-Modul unter "Erweiterungen"->"Module" ->"Administrator".</p></div>', 1, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_custom', 0, 2, 1, 'moduleclass_sfx=\n\n', 1, 1, ''),
(42, 'Joomla! Security Newsfeed', '', 6, 'cpanel', 62, '2008-10-25 20:15:17', 1, 'mod_feed', 0, 0, 1, 'cache=1\ncache_time=15\nmoduleclass_sfx=\nrssurl=http://feeds.joomla.org/JoomlaSecurityNews\nrssrtl=0\nrsstitle=1\nrssdesc=0\nrssimage=1\nrssitems=1\nrssitemdesc=1\nword_count=0\n\n', 0, 1, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_modules_menu`
--
CREATE TABLE IF NOT EXISTS `jos_modules_menu` (
`moduleid` int(11) NOT NULL DEFAULT '0',
`menuid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_modules_menu`
--
INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES
(1, 0),
(16, 1),
(17, 0),
(18, 1),
(19, 1),
(19, 2),
(19, 4),
(19, 27),
(19, 36),
(21, 1),
(22, 1),
(22, 2),
(22, 4),
(22, 27),
(22, 36),
(25, 0),
(27, 0),
(29, 0),
(30, 0),
(31, 1),
(32, 0),
(33, 0),
(34, 0),
(35, 0),
(36, 0),
(38, 1),
(39, 43),
(39, 44),
(39, 45),
(39, 46),
(39, 47),
(40, 0),
(44, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_newsfeeds`
--
CREATE TABLE IF NOT EXISTS `jos_newsfeeds` (
`catid` int(11) NOT NULL DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` text NOT NULL,
`alias` varchar(255) NOT NULL DEFAULT '',
`link` text NOT NULL,
`filename` varchar(200) DEFAULT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`numarticles` int(11) unsigned NOT NULL DEFAULT '1',
`cache_time` int(11) unsigned NOT NULL DEFAULT '3600',
`checked_out` tinyint(3) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`rtl` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `published` (`published`),
KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;
--
-- Daten für Tabelle `jos_newsfeeds`
--
INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `alias`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`, `rtl`) VALUES
(4, 1, 'Joomla! Ankündigungen', 'joomla-ankuendigungen', 'http://feeds.joomla.org/JoomlaAnnouncements', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(4, 2, 'Joomla! Core-Team Blog', 'joomla-core-team-blog', 'http://feeds.joomla.org/JoomlaCommunityCoreTeamBlog', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(4, 3, 'Joomla! Community-Magazin', 'joomla-community-magazin', 'http://feeds.joomla.org/JoomlaMagazine', '', 1, 20, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(4, 4, 'Joomla! Developer-News', 'joomla-developer-news', 'http://feeds.joomla.org/JoomlaDeveloper', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(4, 5, 'Joomla! Sicherheits-News', 'joomla-sicherheits-news', 'http://feeds.joomla.org/JoomlaSecurityNews', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 5, 0),
(5, 6, 'Free Software Foundation Blogs', 'free-software-foundation-blogs', 'http://www.fsf.org/blogs/RSS', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(5, 7, 'Free Software Foundation', 'free-software-foundation', 'http://www.fsf.org/news/RSS', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(5, 8, 'Software Freedom Law Center Blog', 'software-freedom-law-center-blog', 'http://www.softwarefreedom.org/feeds/blog/', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(5, 9, 'Software Freedom Law Center News', 'software-freedom-law-center', 'http://www.softwarefreedom.org/feeds/news/', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(5, 10, 'Open Source Initiative Blog', 'open-source-initiative-blog', 'http://www.opensource.org/blog/feed', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 5, 0),
(6, 11, 'PHP-News und Ankündigungen', 'php-news-und-ankuendigungen', 'http://www.php.net/feed.atom', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 1, 0),
(6, 12, 'Planet MySQL', 'planet-mysql', 'http://www.planetmysql.org/rss20.xml', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 2, 0),
(6, 13, 'Linux Foundation Ankündigungen', 'linux-foundation-ankuendigungen', 'http://www.linuxfoundation.org/press/rss20.xml', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 3, 0),
(6, 14, 'Mootools Blog', 'mootools-blog', 'http://feeds.feedburner.com/mootools-blog', NULL, 1, 5, 3600, 0, '0000-00-00 00:00:00', 4, 0),
(4, 15, 'J!German News', 'jgerman-news', 'http://www.jgerman.de/feed/rss.html', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 6, 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_plugins`
--
CREATE TABLE IF NOT EXISTS `jos_plugins` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL DEFAULT '',
`element` varchar(100) NOT NULL DEFAULT '',
`folder` varchar(100) NOT NULL DEFAULT '',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`ordering` int(11) NOT NULL DEFAULT '0',
`published` tinyint(3) NOT NULL DEFAULT '0',
`iscore` tinyint(3) NOT NULL DEFAULT '0',
`client_id` tinyint(3) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;
--
-- Daten für Tabelle `jos_plugins`
--
INSERT INTO `jos_plugins` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES
(1, 'Authentifikation - Joomla', 'joomla', 'authentication', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(2, 'Authentifikation - LDAP', 'ldap', 'authentication', 0, 2, 0, 1, 0, 0, '0000-00-00 00:00:00', 'host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n'),
(3, 'Authentifikation - GMail', 'gmail', 'authentication', 0, 4, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(4, 'Authentifikation - OpenID', 'openid', 'authentication', 0, 3, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(5, 'Benutzer - Joomla!', 'joomla', 'user', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'autoregister=1\n\n'),
(6, 'Suche - Inhalte', 'content', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n'),
(7, 'Suche - Kontakte', 'contacts', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(8, 'Suche - Kategorien', 'categories', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(9, 'Suche - Bereiche', 'sections', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(10, 'Suche - Newsfeeds', 'newsfeeds', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(11, 'Suche - Weblinks', 'weblinks', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'search_limit=50\n\n'),
(12, 'Inhalt - Seitenumbruch', 'pagebreak', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', 'enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n'),
(13, 'Inhalt - Bewertung', 'vote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(14, 'Inhalt - E-Mail-Verschleierung', 'emailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', 'mode=1\n\n'),
(15, 'Inhalt - Code-Hervorhebung (GeSHi)', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''),
(16, 'Inhalt - Modul laden', 'loadmodule', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', 'enabled=1\nstyle=0\n\n'),
(17, 'Inhalt - Seitennavigation', 'pagenavigation', 'content', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', 'position=1\n\n'),
(18, 'Editor - Kein Editor', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(19, 'Editor - TinyMCE', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'mode=advanced\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nentity_encoding=raw\nlang_mode=0\nlang_code=de\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%d.%m.%Y\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n'),
(20, 'Editor - XStandard Lite 2.0', 'xstandard', 'editors', 0, 0, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(21, 'Editorbutton - Bild', 'image', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(22, 'Editorbutton - Seitenumbruch', 'pagebreak', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(23, 'Editorbutton - Weiterlesen', 'readmore', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(24, 'XML-RPC - Joomla', 'joomla', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(25, 'XML-RPC - Blogger-API', 'blogger', 'xmlrpc', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', 'catid=1\nsectionid=0\n\n'),
(27, 'System - SEF', 'sef', 'system', 0, 1, 1, 0, 0, 0, '0000-00-00 00:00:00', ''),
(28, 'System - Debug', 'debug', 'system', 0, 2, 1, 0, 0, 0, '0000-00-00 00:00:00', 'queries=1\nmemory=1\nlangauge=1\n\n'),
(29, 'System - Legacy', 'legacy', 'system', 0, 3, 0, 1, 0, 0, '0000-00-00 00:00:00', 'route=0\n\n'),
(30, 'System - Cache', 'cache', 'system', 0, 4, 0, 1, 0, 0, '0000-00-00 00:00:00', 'browsercache=0\ncachetime=15\n\n'),
(31, 'System - Protokoll', 'log', 'system', 0, 5, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(32, 'System - Angemeldet bleiben', 'remember', 'system', 0, 6, 1, 1, 0, 0, '0000-00-00 00:00:00', ''),
(33, 'System - Backlink', 'backlink', 'system', 0, 7, 0, 1, 0, 0, '0000-00-00 00:00:00', ''),
(34, 'System - Mootools Upgrade', 'mtupgrade', 'system', 0, 8, 0, 1, 0, 0, '0000-00-00 00:00:00', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_polls`
--
CREATE TABLE IF NOT EXISTS `jos_polls` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`voters` int(9) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`published` tinyint(1) NOT NULL DEFAULT '0',
`access` int(11) NOT NULL DEFAULT '0',
`lag` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;
--
-- Daten für Tabelle `jos_polls`
--
INSERT INTO `jos_polls` (`id`, `title`, `alias`, `voters`, `checked_out`, `checked_out_time`, `published`, `access`, `lag`) VALUES
(14, 'Wozu nutzen Sie Joomla!?', 'wozu-nutzen-sie-joomla', 11, 0, '0000-00-00 00:00:00', 1, 0, 86400);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_data`
--
CREATE TABLE IF NOT EXISTS `jos_poll_data` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pollid` int(11) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`hits` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Daten für Tabelle `jos_poll_data`
--
INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES
(1, 14, 'Community-Seiten', 2),
(2, 14, 'Öffentliche Firmenseiten', 3),
(3, 14, 'eCommerce', 1),
(4, 14, 'Blogs', 0),
(5, 14, 'Intranets', 0),
(6, 14, 'Foto- und Medienseiten', 2),
(7, 14, 'Alles oben genannte!', 3),
(8, 14, '', 0),
(9, 14, '', 0),
(10, 14, '', 0),
(11, 14, '', 0),
(12, 14, '', 0);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_date`
--
CREATE TABLE IF NOT EXISTS `jos_poll_date` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`vote_id` int(11) NOT NULL DEFAULT '0',
`poll_id` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ;
--
-- Daten für Tabelle `jos_poll_date`
--
INSERT INTO `jos_poll_date` (`id`, `date`, `vote_id`, `poll_id`) VALUES
(1, '2007-10-09 13:01:58', 1, 14),
(2, '2007-10-10 15:19:43', 7, 14),
(3, '2007-10-11 11:08:16', 7, 14),
(4, '2007-10-11 15:02:26', 2, 14),
(5, '2007-10-11 15:43:03', 7, 14),
(6, '2007-10-11 15:43:38', 7, 14),
(7, '2007-10-12 00:51:13', 2, 14),
(8, '2008-05-10 19:12:29', 3, 14),
(9, '2008-05-14 14:18:00', 6, 14),
(10, '2008-06-10 15:20:29', 6, 14),
(11, '2008-07-03 12:37:53', 2, 14);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_poll_menu`
--
CREATE TABLE IF NOT EXISTS `jos_poll_menu` (
`pollid` int(11) NOT NULL DEFAULT '0',
`menuid` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_poll_menu`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_sections`
--
CREATE TABLE IF NOT EXISTS `jos_sections` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL DEFAULT '',
`name` varchar(255) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`image` text NOT NULL,
`scope` varchar(50) NOT NULL DEFAULT '',
`image_position` varchar(30) NOT NULL DEFAULT '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) unsigned NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`access` tinyint(3) unsigned NOT NULL DEFAULT '0',
`count` int(11) NOT NULL DEFAULT '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
--
-- Daten für Tabelle `jos_sections`
--
INSERT INTO `jos_sections` (`id`, `title`, `name`, `alias`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(5, 'Würfe', '', 'wuerfe', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 6, '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_session`
--
CREATE TABLE IF NOT EXISTS `jos_session` (
`username` varchar(150) DEFAULT '',
`time` varchar(14) DEFAULT '',
`session_id` varchar(200) NOT NULL DEFAULT '0',
`guest` tinyint(4) DEFAULT '1',
`userid` int(11) DEFAULT '0',
`usertype` varchar(50) DEFAULT '',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '0',
`client_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
`data` longtext,
PRIMARY KEY (`session_id`(64)),
KEY `whosonline` (`guest`,`usertype`),
KEY `userid` (`userid`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_session`
--
INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
('', '1309281561', 'cr5t821u0oo0gcsds8r74pldp3', 1, 0, '', 0, 0, '__default|a:7:{s:15:"session.counter";i:2;s:19:"session.timer.start";i:1309281550;s:18:"session.timer.last";i:1309281550;s:17:"session.timer.now";i:1309281561;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}}'),
('', '1309281508', 'l0ctl6jdm3ollqmpah88t4qmi5', 1, 0, '', 0, 1, '__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1309281504;s:18:"session.timer.last";i:1309281504;s:17:"session.timer.now";i:1309281504;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"e9f472033cbead189588a90b4111167c";}'),
('', '1309281570', 'ui88p4em1dvr3ktpca4m6o1tv4', 1, 0, '', 0, 1, '__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1309281570;s:18:"session.timer.last";i:1309281570;s:17:"session.timer.now";i:1309281570;s:22:"session.client.browser";s:70:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:5.0) Gecko/20100101 Firefox/5.0";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:69:"C:\\xampp\\xampp\\htdocs\\heropit\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"fb34e38f247bdbd424138df4962eb522";}');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_stats_agents`
--
CREATE TABLE IF NOT EXISTS `jos_stats_agents` (
`agent` varchar(255) NOT NULL DEFAULT '',
`type` tinyint(1) unsigned NOT NULL DEFAULT '0',
`hits` int(11) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_stats_agents`
--
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_templates_menu`
--
CREATE TABLE IF NOT EXISTS `jos_templates_menu` (
`template` varchar(255) NOT NULL DEFAULT '',
`menuid` int(11) NOT NULL DEFAULT '0',
`client_id` tinyint(4) NOT NULL DEFAULT '0',
PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Daten für Tabelle `jos_templates_menu`
--
INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('nld_064_1.5', 0, 0),
('khepri', 0, 1);
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_users`
--
CREATE TABLE IF NOT EXISTS `jos_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`username` varchar(150) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`usertype` varchar(25) NOT NULL DEFAULT '',
`block` tinyint(4) NOT NULL DEFAULT '0',
`sendEmail` tinyint(4) DEFAULT '0',
`gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
`registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL DEFAULT '',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `usertype` (`usertype`),
KEY `idx_name` (`name`),
KEY `gid_block` (`gid`,`block`),
KEY `username` (`username`),
KEY `email` (`email`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=63 ;
--
-- Daten für Tabelle `jos_users`
--
INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
(62, 'Administrator', 'admin', Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!', '41e281394bb6e193fbf396692ecd5bb6:xo0bQOdZLFycfAy1HcMbVtIl3BaparTK', 'Super Administrator', 0, 1, 25, '2011-06-14 08:25:35', '2011-06-28 17:19:30', '', '');
-- --------------------------------------------------------
--
-- Tabellenstruktur für Tabelle `jos_weblinks`
--
CREATE TABLE IF NOT EXISTS `jos_weblinks` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`catid` int(11) NOT NULL DEFAULT '0',
`sid` int(11) NOT NULL DEFAULT '0',
`title` varchar(250) NOT NULL DEFAULT '',
`alias` varchar(255) NOT NULL DEFAULT '',
`url` varchar(250) NOT NULL DEFAULT '',
`description` text NOT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`hits` int(11) NOT NULL DEFAULT '0',
`published` tinyint(1) NOT NULL DEFAULT '0',
`checked_out` int(11) NOT NULL DEFAULT '0',
`checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL DEFAULT '0',
`archived` tinyint(1) NOT NULL DEFAULT '0',
`approved` tinyint(1) NOT NULL DEFAULT '1',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
--
-- Daten für Tabelle `jos_weblinks`
--
INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `alias`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES
(1, 2, 0, 'Joomla!', 'joomla', 'http://www.joomla.org', 'Das Zuhause von Joomla!', '2005-02-14 15:19:02', 3, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'),
(2, 2, 0, 'php.net', 'php', 'http://www.php.net', 'Die Sprache, mit der Joomla! entwickelt wird', '2004-07-07 11:33:24', 6, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''),
(3, 2, 0, 'MySQL', 'mysql', 'http://www.mysql.com', 'Die Datenbank, die Joomla! nutzt', '2004-07-07 10:18:31', 1, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''),
(4, 2, 0, 'OpenSourceMatters', 'opensourcematters', 'http://www.opensourcematters.org', 'Das Zuhause von OSM', '2005-02-14 15:19:02', 11, 1, 0, '0000-00-00 00:00:00', 2, 0, 1, 'target=0'),
(5, 2, 0, 'Joomla!-Foren', 'joomla-foren', 'http://forum.joomla.org', 'Joomla! Foren', '2005-02-14 15:19:02', 4, 1, 0, '0000-00-00 00:00:00', 4, 0, 1, 'target=0'),
(6, 2, 0, 'Ohloh über Joomla!', 'ohloh-ueber-joomla', 'http://www.ohloh.net/projects/20', 'Sachliche Berichte von Ohloo über die Aktivitäten der Joomla-Entwicklung. Joomla! hat einige ernsthaft anerkannte Star-Programmierer.', '2007-07-19 09:28:31', 1, 1, 0, '0000-00-00 00:00:00', 6, 0, 1, 'target=0\n\n');
/*!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 */;