--
-- Tabellenstruktur für Tabelle `#__categories`
--

CREATE TABLE IF NOT EXISTS `#__categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `level` int(10) unsigned NOT NULL DEFAULT '0',
  `path` varchar(255) NOT NULL DEFAULT '',
  `extension` varchar(50) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext 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',
  `access` int(10) unsigned NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
  `metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.',
  `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
  `created_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(10) unsigned NOT NULL DEFAULT '0',
  `language` char(7) NOT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`extension`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_path` (`path`),
  KEY `idx_left_right` (`lft`,`rgt`),
  KEY `idx_alias` (`alias`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=94 ;

--
-- Daten für Tabelle `#__categories`
--

INSERT INTO `#__categories` (`id`, `asset_id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `extension`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `modified_user_id`, `modified_time`, `hits`, `language`, `version`) VALUES
(1, 0, 0, 0, 92, 0, '', 'system', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '', 42, '2011-01-01 00:00:01', 0, '0000-00-00 00:00:00', 0, '*', 1),
(2, 2, 80, 46, 47, 2, 'inhalt/der-kiga', 'com_content', 'Der KiGa', 'der-kiga', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*2*"}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(3, 41, 80, 50, 51, 2, 'inhalt/organisatorisches', 'com_content', 'Organisatorisches', 'organisatorisches', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*2*"}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(4, 29, 1, 4, 5, 1, 'kita', 'com_contact', 'KiTa', 'kita', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 0, '2009-10-18 16:07:09', 273, '2015-10-17 09:16:31', 0, '*', 1),
(5, 40, 80, 48, 49, 2, 'inhalt/der-trr', 'com_content', 'Der Träger', 'der-trr', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*2*"}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(9, 43, 79, 40, 41, 2, 'allgemein/allgemein', 'com_content', 'Allgemein', 'allgemein', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*2*"}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(50, 42, 79, 38, 39, 2, 'allgemein/formulare', 'com_content', 'Formulare', 'formulare', '', 'Hier können Sie Formulare herunterladen.\r\n', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":""}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(52, 55, 81, 54, 55, 2, 'rueckblick-tagebuch-kiga/hort', 'com_content', 'Hort', 'hort', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 0, '0000-00-00 00:00:00', 63, '2015-10-15 05:34:53', 0, '*', 1),
(54, 51, 78, 28, 29, 2, 'comkita/september-2007', 'com_content', 'September 2007', 'september-2007', '', '<p>\r\n<b>Was ist bei uns im September los?</b>\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p align="center">\r\n<span style="color: #ffffff"><b> <span style="color: #ffffff">-</span> </b><b>Drachen steigen <span style="color: #ffffff">-</span></b></span>\r\n</p>\r\n<p align="center">\r\n<span style="color: #ffffff"><b> <span style="color: #ffffff">-</span> </b><b>Laub raschelt <span style="color: #ffffff">-</span> </b></span>\r\n</p>\r\n<p align="center">\r\n<span style="color: #ffffff"><b> <span style="color: #ffffff">-</span> </b><b>Pilze wachsen im Wald <span style="color: #ffffff">-</span> </b></span>\r\n</p>\r\n<div align="center">\r\n<span style="color: #ffffff"><b> <span style="color: #ffffff">-</span> </b><b>Kastanien sind sch&ouml;n braun</b><b> <span style="color: #ffffff">-</span></b></span>\r\n</div>\r\n<p>\r\n<b> </b>\r\n</p>\r\n<p align="center">\r\n<i><b>Was ist das f&uuml;r eine Jahreszeit?</b></i>\r\n</p>\r\n<div style="text-align: center" align="center">\r\n<img src="images/stories/termine/herbst-kinder.gif" alt="Der Herbst ist da!" style="border: 2px solid #ffffff; margin: 5px; width: 150px; height: 107px" title="Der Herbst ist da!" height="107" width="150" />\r\n</div>\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2007-09-01 00:00:00","end":"2007-09-30 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(55, 50, 78, 26, 27, 2, 'comkita/november-2007', 'com_content', 'November 2007', 'november-2007', '', '<b>November 2007</b> - unsere Aktionen im KiGa\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2007-11-01 00:00:00","end":"2007-11-30 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(56, 52, 78, 30, 31, 2, 'comkita/weihnachtsmonat-dezember', 'com_content', 'Weihnachtsmonat Dezember', 'weihnachtsmonat-dezember', '', '<p align="center">\r\n<a href="images/stories/allgemein/lachender-schneemann.jpg" title="Wir vom KiGa Thierfeld w&uuml;nschen allen ruhige und besinnliche Feiertage!" class="jcebox"><img src="images/stories/allgemein/thumbnails/thumb_lachender-schneemann.jpg" alt="Wir vom KiGa Thierfeld w&uuml;nschen allen ruhige und besinnliche Feiertage!" style="border: 2px solid #ffffff; margin: 5px; width: 150px; height: 112px" title="Wir vom KiGa Thierfeld w&uuml;nschen allen ruhige und besinnliche Feiertage!" align="middle" height="112" width="150" /></a>\r\n</p>\r\n<div align="center">\r\nWir vom KiGa Thierfeld w&uuml;nschen allen ruhige und besinnliche Feiertage!\r\n</div>\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2007-12-01 00:00:00","end":"2007-12-31 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(57, 53, 78, 32, 33, 2, 'comkita/winter-2008', 'com_content', 'Winter 2008', 'winter-2008', '', '<p>\r\n<a href="images/stories/termine/schneeballschlacht.jpg" title="Schneeballschlacht im Winter ist immer lustig..." class="jcebox"><img src="images/stories/termine/thumbnails/thumb_schneeballschlacht.jpg" alt="Schneeballschlacht im Winter ist immer lustig..." style="border: 1px solid #ffffff; margin: 5px; float: right; width: 99px; height: 150px" title="Schneeballschlacht im Winter ist immer lustig..." height="150" width="99" /></a>\r\nUnsere Vorhaben im Januar und Februar:\r\n</p>\r\n<p>\r\nbei passendem Wetter wollen wir so oft wie m&ouml;glich rodeln gehen, Schneeballschlacht machen, bauen im und mit Schnee uvm...\r\n</p>\r\n<p>\r\nWir haben vom letzten Winter (ohne Schnee) viel nachzuholen un hoffen in diesem Jahr auf mehr Schnee!&nbsp;\r\n</p>\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2008-01-01 00:00:00","end":"2008-02-29 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(59, 47, 78, 20, 21, 2, 'comkita/frng-april-mai-juni', 'com_content', 'Frühling (April, Mai, Juni)', 'frng-april-mai-juni', '', '<p>\r\n<a href="images/stories/termine/erst-einmal-ausruhn.jpg" title="&quot;Erst einmal ausruhn&quot; &copy; Conny-T. / PIXELIO" class="jcebox"><img src="images/stories/termine/thumbnails/thumb_erst-einmal-ausruhn.jpg" title="&quot;Erst einmal ausruhn&quot; &copy; Conny-T. / PIXELIO" alt=" &quot;Erst einmal ausruhn&quot; &copy; Conny-T. / PIXELIO" style="border: 2px solid #ffffff; margin: 5px; float: right; width: 150px; height: 112px" height="112" width="150" /></a>\r\n<b>Was wollen wir im sch&ouml;nen Fr&uuml;hjahr tun?</b>\r\n</p>\r\n<p>\r\nAuf Wunsch unserer Kinder soll sich alles um die <b>TIERE</b> drehen.\r\n</p>\r\n<p>\r\nWir m&ouml;chten lernen:\r\n</p>\r\n<ul>\r\n	<li>wie und wo unsere Tiere leben,</li>\r\n	<li>wie sie schlafen und ihr Futter beschaffen</li>\r\n	<li>mit welchen Mitteln sie manches Mal k&auml;mpfen m&uuml;ssen, um sich zu verteidigen und</li>\r\n	<li>von welchen Tieren wir Nahrungsmittel bekommen und wie das funktioniert.</li>\r\n</ul>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p>\r\nDazu m&ouml;chten wir\r\n</p>\r\n<ul>\r\n	<li>auf dem Bauernhof dem Melken zusehen,</li>\r\n	<li>den <a href="http://www.wollhandel.net/" target="_blank" title="www.wollhandel.net">Wollhandel G&uuml;nther</a> in Hartenstein besuchen und erfahren, wie man Wolle spinnt</li>\r\n</ul>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p>\r\nWir wollen von unseren Haustieren erz&auml;hlen und eine Wandzeitung mit Fotos unserer Tiere gestalten.\r\n</p>\r\n<p>\r\n(<i><b>D</b><b>azu bitte Fotos mitbringen!</b></i>)\r\n</p>\r\n<p>\r\nWir wollen Tiergeschichten lesen und erfinden, Tierlieder und Gedichte lernen und einen Bauernhof basteln.\r\n</p>\r\n<p>\r\nAu&szlig;erdem trainieren wir f&uuml;rs Sportfest.\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n<p>\r\nWir freuen uns sehr auf diese Zeit und hoffen auf sch&ouml;nes Fr&uuml;hlingswetter f&uuml;r unsere vielen Vorhaben.&nbsp;\r\n</p>\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2008-04-01 00:00:00","end":"2008-07-31 23:59:59","size":"A4","format":"landscape","margin":1}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(60, 48, 78, 22, 23, 2, 'comkita/sommerzeit-im-kiga-ferienzeit-juli-august', 'com_content', 'Sommerzeit im Kiga (Ferienzeit Juli - August)', 'sommerzeit-im-kiga-ferienzeit-juli-august', '', '<p>\r\n<span style="font-size: 10pt"><b><span style="color: #ff0000">Thema: Sommer, Sonne, Strand und Wasser</span></b></span>\r\n</p>\r\n<p>\r\nWir wollen den Sommer genie&szlig;en und haben viele Ideen...&nbsp;\r\n</p>\r\n<p>\r\n&nbsp;\r\n</p>\r\n', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2008-07-01 00:00:00","end":"2008-08-31 23:59:59","size":"A4","format":"landscape","margin":1}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(61, 49, 78, 24, 25, 2, 'comkita/herbst-und-winter-nov08-feb-09', 'com_content', 'Herbst und Winter (Nov.08 - Feb. 09)', 'herbst-und-winter-nov08-feb-09', '', '', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2008-12-11 00:00:00","end":"2009-02-28 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(63, 39, 80, 44, 45, 2, 'inhalt/projekte', 'com_content', 'Projekte', 'projekte', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*2*"}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(64, 45, 78, 16, 17, 2, 'comkita/winter', 'com_content', 'Winter', 'winter', '', '', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2008-11-01 00:00:00","end":"2009-02-28 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(65, 46, 78, 18, 19, 2, 'comkita/winter-und-frng-2009', 'com_content', 'Winter und Frühling 2009', 'winter-und-frng-2009', '', '', 0, 0, '0000-00-00 00:00:00', 1, '{"begin":"2009-02-19 00:00:00","end":"2009-05-31 23:59:59","size":"A4","format":"landscape","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(66, 44, 78, 14, 15, 2, 'comkita/frng-und-sommer-2009', 'com_content', 'Frühling und Sommer 2009', 'frng-und-sommer-2009', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"begin":"2009-03-25 00:00:00","end":"2009-09-22 23:59:59","size":"A4","format":"portrait","margin":2}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(77, 54, 78, 34, 35, 2, 'comkita/herbst-und-winter-2010', 'com_content', 'Herbst und Winter 2010', 'herbst-und-winter-2010', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{}', '', '', '', 0, '0000-00-00 00:00:00', 0, '2015-06-30 10:49:56', 0, '*', 1),
(78, 35, 1, 13, 36, 1, 'comkita', 'com_content', 'com_kita', 'comkita', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*1*"}', '', '', '', 0, '2015-06-30 10:49:56', 0, '0000-00-00 00:00:00', 0, '*', 1),
(79, 36, 1, 37, 42, 1, 'allgemein', 'com_content', 'Allgemein', 'allgemein', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*1*"}', '', '', '', 0, '2015-06-30 10:49:56', 0, '0000-00-00 00:00:00', 0, '*', 1),
(80, 37, 1, 43, 52, 1, 'inhalt', 'com_content', 'Inhalt', 'inhalt', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"imagefolders":"*1*"}', '', '', '', 0, '2015-06-30 10:49:56', 0, '0000-00-00 00:00:00', 0, '*', 1),
(81, 38, 1, 53, 60, 1, 'rueckblick-tagebuch-kiga', 'com_content', 'Rückblick (Tagebuch KiGa)', 'rueckblick-tagebuch-kiga', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 0, '2015-06-30 10:49:56', 63, '2015-10-15 05:34:27', 0, '*', 1),
(82, 27, 1, 1, 2, 1, 'uncategorised', 'com_content', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:26:37', 0, '0000-00-00 00:00:00', 0, '*', 1),
(83, 28, 1, 3, 4, 1, 'uncategorised', 'com_banners', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":"","foobar":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:27:35', 0, '0000-00-00 00:00:00', 0, '*', 1),
(84, 127, 1, 5, 6, 1, 'uncategorised', 'com_contact', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 42, '2010-06-28 13:27:57', 273, '2015-10-17 09:16:38', 0, '*', 1),
(85, 30, 1, 7, 8, 1, 'uncategorised', 'com_newsfeeds', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:15', 0, '0000-00-00 00:00:00', 0, '*', 1),
(86, 31, 1, 9, 10, 1, 'uncategorised', 'com_weblinks', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:33', 0, '0000-00-00 00:00:00', 0, '*', 1),
(87, 32, 1, 11, 12, 1, 'uncategorised', 'com_users', 'Uncategorised', 'uncategorised', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"target":"","image":""}', '', '', '{"page_title":"","author":"","robots":""}', 42, '2010-06-28 13:28:33', 0, '0000-00-00 00:00:00', 0, '*', 1),
(88, 338, 1, 61, 62, 1, 'startseite-querbeet', 'com_djimageslider', 'Startseite - Querbeet', 'startseite-querbeet', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 63, '2015-10-11 09:32:52', 0, '2015-10-11 09:32:52', 0, '*', 1),
(89, 342, 81, 56, 57, 2, 'rueckblick-tagebuch-kiga/krippe', 'com_content', 'Krippe', 'krippe', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 63, '2015-10-15 05:35:13', 0, '2015-10-15 05:35:13', 0, '*', 1),
(90, 343, 81, 58, 59, 2, 'rueckblick-tagebuch-kiga/vorschule', 'com_content', 'Vorschule', 'vorschule', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 63, '2015-10-15 05:35:42', 63, '2015-10-15 05:35:46', 0, '*', 1),
(91, 344, 1, 63, 66, 1, 'tagebuch-kindergarten-thierfeld', 'com_content', 'Tagebuch Kindergarten Thierfeld', 'tagebuch-kindergarten-thierfeld', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 63, '2015-10-15 05:40:31', 0, '2015-10-15 05:40:31', 0, '*', 1),
(92, 345, 91, 64, 65, 2, 'tagebuch-kindergarten-thierfeld/hort', 'com_content', 'Hort', 'hort', '', '', 1, 0, '0000-00-00 00:00:00', 1, '{"category_layout":"","image":"","image_alt":""}', '', '', '{"author":"","robots":""}', 63, '2015-10-15 05:40:46', 0, '2015-10-15 05:40:46', 0, '*', 1);