-- phpMyAdmin SQL Dump -- version 2.9.2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generatie Tijd: 02 Oct 2008 om 16:25 -- Server versie: 5.0.27 -- PHP Versie: 5.2.1 -- -- Database: `ctg_joomla` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_banner` -- CREATE TABLE `jos_banner` ( `bid` int(11) NOT NULL auto_increment, `cid` int(11) NOT NULL default '0', `type` varchar(30) NOT NULL default 'banner', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `imptotal` int(11) NOT NULL default '0', `impmade` int(11) NOT NULL default '0', `clicks` int(11) NOT NULL default '0', `imageurl` varchar(100) NOT NULL default '', `clickurl` varchar(200) NOT NULL default '', `date` datetime default NULL, `showBanner` tinyint(1) NOT NULL default '0', `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `custombannercode` text, `catid` int(10) unsigned NOT NULL default '0', `description` text NOT NULL, `sticky` tinyint(1) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `tags` text NOT NULL, `params` text NOT NULL, PRIMARY KEY (`bid`), KEY `viewbanner` (`showBanner`), KEY `idx_banner_catid` (`catid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_banner` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_bannerclient` -- CREATE TABLE `jos_bannerclient` ( `cid` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL default '', `contact` varchar(255) NOT NULL default '', `email` varchar(255) NOT NULL default '', `extrainfo` text NOT NULL, `checked_out` tinyint(1) NOT NULL default '0', `checked_out_time` time default NULL, `editor` varchar(50) default NULL, PRIMARY KEY (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_bannerclient` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_bannertrack` -- CREATE TABLE `jos_bannertrack` ( `track_date` date NOT NULL, `track_type` int(10) unsigned NOT NULL, `banner_id` int(10) unsigned NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_bannertrack` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_categories` -- CREATE TABLE `jos_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `title` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `image` varchar(255) NOT NULL default '', `section` varchar(50) NOT NULL default '', `image_position` varchar(30) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `editor` varchar(50) default NULL, `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`section`,`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; -- -- Gegevens worden uitgevoerd voor tabel `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 (4, 0, 'Holidays', 'Holidays', 'holidays', 'Sinterklaas.gif', 'com_events', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 4, ''), (3, 0, 'Birthdays', 'Birthdays', 'birthdays', 'birthdays.gif', 'com_events', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 8, ''), (5, 0, 'Traffic', '', 'traffic', '', '1', 'left', '
\r\n \r\n\r\n \r\n \r\n | \r\n||
\r\n | \r\n | \r\n |
\r\n | \r\n | \r\n |
\r\n\r\n
October 2008
\r\n\r\n\r\n
\r\n
', '', 1, 0, 0, 0, '2008-09-08 11:54:51', 62, '', '2008-09-18 14:57:19', 62, 62, '2008-09-22 08:08:50', '2008-09-08 11:54:51', '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=', 5, 0, 3, '', '', 0, 0, 'robots=\nauthor='), (5, 'emergency services', 'emergency-services', '', '
\r\n
\r\n\r\n | \r\n|
\r\n | \r\n |
\r\n | \r\n |
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
\r\n
', '', 1, 1, 0, 5, '2008-09-15 09:54:10', 62, '', '2008-09-18 14:39:32', 62, 0, '0000-00-00 00:00:00', '2008-09-15 09:54:10', '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=', 9, 0, 8, '', '', 0, 20, 'robots=\nauthor='), (6, 'Police', 'police', '', '
\r\n\r\n \r\n | \r\n||
\r\n | \r\n | \r\n |
\r\n | \r\n | \r\n |
\r\n\r\n \r\n | \r\n||
\r\n | \r\n | \r\n |
\r\n | \r\n | \r\n |
\r\n | \r\n | \r\n |
\r\n | ||
\r\n |
\r\n\r\n | \r\n
worksheets
\r\nhttp://www.digischool.nl/po/community12/Bijdragen%20community%201_bestanden/Politie/politieagent.jpg
\r\nhttp://www.digischool.nl/po/community12/Bijdragen%20community%201_bestanden/Politie/politiepet.jpg
\r\nhttp://www.kleurplaten.nl/index2.asp
\r\nhttp://www.verkeerskalender.nl/vk_kleurplaat_april.htm
\r\nhttp://www.coloring.ws/police.htm
http://www.lauffer.nl/marilyn/kleurplaten/politieauto.htm
\r\nhttp://www.digischool.nl/po/community12/?page=custom&file=politie.html#kralenplanken\r\nhttp://www.kleutergroep.nl/112/112%20index.htm
\r\n\r\n
Construction plates
\r\nhttp://cms.qlictonline.nl/users/deakker_07pi//docs/Webjes/Weetje_politie-bouwplaat.pdf
\r\nhttp://www.knutselpagina.nl/toon.php?Action=Show&Taal=NL&KPID=1311
\r\nPictures
\r\nhttp://funhuispagina.sytes.net/animatiepag/politie.html
\r\nhttp://home.scarlet.be/~cl898452/index/politie/
\r\nhttp://www.animatieplaatjes.nl/politieauto.html
\r\n\r\n
Digibord
\r\nhttp://www.ictveenplas.nl/websites/Verkeer.htm
\r\n
Implementing police in school lessons
\r\nhttp://www.doe-effe-normaal.nl/SAP%202006/lesbrieven%20definitief%202005/Vrienden.pdf
', '', 1, 1, 0, 5, '2008-09-15 14:52:42', 62, '', '2008-09-22 08:34:19', 62, 0, '0000-00-00 00:00:00', '2008-09-15 14:52:42', '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=', 5, 0, 4, '', '', 0, 14, 'robots=\nauthor='), (10, 'Police_Worksheets', 'policeworksheets', '', 'text', '', 1, 1, 0, 5, '2008-09-15 14:53:14', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-09-15 14:53:14', '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, 3, '', '', 0, 0, 'robots=\nauthor='), (11, 'Police_Online Excercises', 'policeonline-excercises', '', 'text', '', 1, 1, 0, 5, '2008-09-15 14:53:46', 62, '', '0000-00-00 00:00:00', 0, 62, '2008-09-22 08:08:35', '2008-09-15 14:53:46', '0000-00-00 00:00:00', '', '', 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 1, 0, 2, '', '', 0, 0, 'robots=\nauthor='), (12, 'Police_Photo''s&Films', 'policephotosafilms', '', 'text', '', 1, 1, 0, 5, '2008-09-15 14:54:34', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-09-15 14:54:34', '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, 1, '', '', 0, 1, 'robots=\nauthor='), (13, 'guide', 'guide', '', 'Guide', '', 1, 0, 0, 0, '2008-09-24 08:32:57', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-09-24 08:32:57', '0000-00-00 00:00:00', '', '', 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 1, 0, 2, '', '', 0, 0, 'robots=\nauthor='), (14, 'test', 'test', '', '', '', 1, 0, 0, 0, '2008-09-25 13:22:35', 62, '', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '2008-09-25 13:22:35', '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, 1, '', '', 0, 0, 'robots=\nauthor='); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_content_frontpage` -- CREATE TABLE `jos_content_frontpage` ( `content_id` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`content_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_content_frontpage` -- INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (1, 1); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_content_rating` -- CREATE TABLE `jos_content_rating` ( `content_id` int(11) NOT NULL default '0', `rating_sum` int(11) unsigned NOT NULL default '0', `rating_count` int(11) unsigned NOT NULL default '0', `lastip` varchar(50) NOT NULL default '', PRIMARY KEY (`content_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_content_rating` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_acl_aro` -- CREATE TABLE `jos_core_acl_aro` ( `id` int(11) NOT NULL auto_increment, `section_value` varchar(240) NOT NULL default '0', `value` varchar(240) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `jos_gacl_hidden_aro` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ; -- -- Gegevens worden uitgevoerd voor tabel `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), (12, 'users', '64', 0, 'user', 0); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_acl_aro_groups` -- CREATE TABLE `jos_core_acl_aro_groups` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `lft` int(11) NOT NULL default '0', `rgt` int(11) NOT NULL default '0', `value` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), KEY `jos_gacl_parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ; -- -- Gegevens worden uitgevoerd voor tabel `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'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_acl_aro_map` -- CREATE TABLE `jos_core_acl_aro_map` ( `acl_id` int(11) NOT NULL default '0', `section_value` varchar(230) NOT NULL default '0', `value` varchar(100) NOT NULL, PRIMARY KEY (`acl_id`,`section_value`,`value`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_core_acl_aro_map` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_acl_aro_sections` -- CREATE TABLE `jos_core_acl_aro_sections` ( `id` int(11) NOT NULL auto_increment, `value` varchar(230) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(230) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `jos_gacl_value_aro_sections` (`value`), KEY `jos_gacl_hidden_aro_sections` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_core_acl_aro_sections` -- INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', 1, 'Users', 0); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_acl_groups_aro_map` -- CREATE TABLE `jos_core_acl_groups_aro_map` ( `group_id` int(11) NOT NULL default '0', `section_value` varchar(240) NOT NULL default '', `aro_id` int(11) NOT NULL default '0', UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_core_acl_groups_aro_map` -- INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES (25, '', 10), (25, '', 12); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_log_items` -- CREATE TABLE `jos_core_log_items` ( `time_stamp` date NOT NULL default '0000-00-00', `item_table` varchar(50) NOT NULL default '', `item_id` int(11) unsigned NOT NULL default '0', `hits` int(11) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_core_log_items` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_core_log_searches` -- CREATE TABLE `jos_core_log_searches` ( `search_term` varchar(128) NOT NULL default '', `hits` int(11) unsigned NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_core_log_searches` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_eventlist_settings` -- CREATE TABLE `jos_eventlist_settings` ( `id` int(11) NOT NULL, `oldevent` tinyint(4) NOT NULL, `minus` tinyint(4) NOT NULL, `showtime` tinyint(4) NOT NULL, `showtitle` tinyint(4) NOT NULL, `showlocate` tinyint(4) NOT NULL, `showcity` tinyint(4) NOT NULL, `showmapserv` tinyint(4) NOT NULL, `map24id` varchar(20) NOT NULL, `gmapkey` varchar(255) NOT NULL, `tablewidth` varchar(20) NOT NULL, `datewidth` varchar(20) NOT NULL, `titlewidth` varchar(20) NOT NULL, `locationwidth` varchar(20) NOT NULL, `citywidth` varchar(20) NOT NULL, `datename` varchar(100) NOT NULL, `titlename` varchar(100) NOT NULL, `locationname` varchar(100) NOT NULL, `cityname` varchar(100) NOT NULL, `formatdate` varchar(100) NOT NULL, `formattime` varchar(100) NOT NULL, `timename` varchar(50) NOT NULL, `showdetails` tinyint(4) NOT NULL, `showtimedetails` tinyint(4) NOT NULL, `showevdescription` tinyint(4) NOT NULL, `showdetailstitle` tinyint(4) NOT NULL, `showdetailsadress` tinyint(4) NOT NULL, `showlocdescription` tinyint(4) NOT NULL, `showlinkvenue` tinyint(4) NOT NULL, `showdetlinkvenue` tinyint(4) NOT NULL, `delivereventsyes` tinyint(4) NOT NULL, `mailinform` tinyint(4) NOT NULL, `mailinformrec` varchar(150) NOT NULL, `mailinformuser` tinyint(4) NOT NULL, `datdesclimit` varchar(15) NOT NULL, `autopubl` tinyint(4) NOT NULL, `deliverlocsyes` tinyint(4) NOT NULL, `autopublocate` tinyint(4) NOT NULL, `showcat` tinyint(4) NOT NULL, `catfrowidth` varchar(20) NOT NULL, `catfroname` varchar(100) NOT NULL, `evdelrec` tinyint(4) NOT NULL, `evpubrec` tinyint(4) NOT NULL, `locdelrec` tinyint(4) NOT NULL, `locpubrec` tinyint(4) NOT NULL, `sizelimit` varchar(20) NOT NULL, `imagehight` varchar(20) NOT NULL, `imagewidth` varchar(20) NOT NULL, `gddisabled` tinyint(4) NOT NULL, `imageenabled` tinyint(4) NOT NULL, `comunsolution` tinyint(4) NOT NULL, `comunoption` tinyint(4) NOT NULL, `catlinklist` tinyint(4) NOT NULL, `showfroregistra` tinyint(4) NOT NULL, `showfrounregistra` tinyint(4) NOT NULL, `eventedit` tinyint(4) NOT NULL, `eventeditrec` tinyint(4) NOT NULL, `eventowner` tinyint(4) NOT NULL, `venueedit` tinyint(4) NOT NULL, `venueeditrec` tinyint(4) NOT NULL, `venueowner` tinyint(4) NOT NULL, `lightbox` tinyint(4) NOT NULL, `meta_keywords` varchar(255) NOT NULL, `meta_description` varchar(255) NOT NULL, `showstate` tinyint(4) NOT NULL, `statename` varchar(100) NOT NULL, `statewidth` varchar(20) NOT NULL, `regname` tinyint(4) NOT NULL, `storeip` tinyint(4) NOT NULL, `commentsystem` tinyint(4) NOT NULL, `lastupdate` varchar(20) NOT NULL default '', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_eventlist_settings` -- INSERT INTO `jos_eventlist_settings` (`id`, `oldevent`, `minus`, `showtime`, `showtitle`, `showlocate`, `showcity`, `showmapserv`, `map24id`, `gmapkey`, `tablewidth`, `datewidth`, `titlewidth`, `locationwidth`, `citywidth`, `datename`, `titlename`, `locationname`, `cityname`, `formatdate`, `formattime`, `timename`, `showdetails`, `showtimedetails`, `showevdescription`, `showdetailstitle`, `showdetailsadress`, `showlocdescription`, `showlinkvenue`, `showdetlinkvenue`, `delivereventsyes`, `mailinform`, `mailinformrec`, `mailinformuser`, `datdesclimit`, `autopubl`, `deliverlocsyes`, `autopublocate`, `showcat`, `catfrowidth`, `catfroname`, `evdelrec`, `evpubrec`, `locdelrec`, `locpubrec`, `sizelimit`, `imagehight`, `imagewidth`, `gddisabled`, `imageenabled`, `comunsolution`, `comunoption`, `catlinklist`, `showfroregistra`, `showfrounregistra`, `eventedit`, `eventeditrec`, `eventowner`, `venueedit`, `venueeditrec`, `venueowner`, `lightbox`, `meta_keywords`, `meta_description`, `showstate`, `statename`, `statewidth`, `regname`, `storeip`, `commentsystem`, `lastupdate`, `checked_out`, `checked_out_time`) VALUES (1, 0, 1, 0, 1, 1, 1, 0, '', '', '100%', '15%', '25%', '20%', '20%', 'Date', 'Title', 'Venue', 'City', '%d.%m.%Y', '%H.%M', 'h', 1, 0, 1, 1, 1, 1, 1, 2, -2, 0, 'example@example.com', 0, '1000', -2, -2, -2, 1, '20%', 'Type', 1, 1, 1, 1, '100', '100', '100', 0, 1, 0, 0, 1, 2, 2, -2, 1, 0, -2, 1, 0, 0, '[title], [a_name], [catsid], [times]', 'The event titled [title] starts on [dates]!', 0, 'State', '0', 0, 1, 0, '1174491851', 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_events` -- CREATE TABLE `jos_events` ( `id` int(12) NOT NULL auto_increment, `sid` int(11) NOT NULL default '0', `catid` int(11) NOT NULL default '1', `title` varchar(100) NOT NULL default '', `content` longtext NOT NULL, `adresse_info` varchar(120) NOT NULL default '', `contact_info` varchar(120) NOT NULL default '', `extra_info` varchar(240) NOT NULL default '', `color_bar` varchar(8) NOT NULL default '', `useCatColor` tinyint(1) NOT NULL default '0', `state` tinyint(3) NOT NULL default '0', `mask` int(11) unsigned NOT NULL default '0', `created` datetime NOT NULL default '0000-00-00 00:00:00', `created_by` int(11) unsigned NOT NULL default '0', `created_by_alias` varchar(100) NOT NULL default '', `modified` datetime NOT NULL default '0000-00-00 00:00:00', `modified_by` int(11) unsigned NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `images` text NOT NULL, `reccurtype` tinyint(1) NOT NULL default '0', `reccurday` varchar(4) NOT NULL default '', `reccurweekdays` varchar(20) NOT NULL default '', `reccurweeks` varchar(10) NOT NULL default '', `approved` tinyint(1) NOT NULL default '1', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `access` int(11) unsigned NOT NULL default '0', `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_events` -- INSERT INTO `jos_events` (`id`, `sid`, `catid`, `title`, `content`, `adresse_info`, `contact_info`, `extra_info`, `color_bar`, `useCatColor`, `state`, `mask`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `reccurtype`, `reccurday`, `reccurweekdays`, `reccurweeks`, `approved`, `ordering`, `archived`, `access`, `hits`) VALUES (1, 0, 3, 'Piet', '', '', '', '', '', 1, 1, 0, '2008-09-12 12:15:45', 62, '', '2008-09-12 12:38:54', 62, 0, '0000-00-00 00:00:00', '2008-09-15 00:01:00', '2008-09-15 00:01:00', 'birthdays.gif', 0, '', '', '', 1, 2, 0, 0, 1), (2, 0, 4, 'Sinterklaas', '', '', '', '', '#FF0000', 1, 1, 0, '2008-09-12 12:29:43', 62, '', '2008-09-16 07:32:04', 62, 0, '0000-00-00 00:00:00', '2008-12-05 00:01:00', '2008-12-05 00:01:00', 'Sinterklaas.gif', 0, '', '', '', 1, 1, 0, 0, 0), (3, 0, 3, 'Jan', '', '', '', '', '#3366FF', 1, 1, 0, '2008-09-16 07:28:52', 62, '', '2008-09-16 07:39:14', 62, 0, '0000-00-00 00:00:00', '2008-09-17 00:01:00', '2008-09-17 00:01:00', 'birthdays.gif', 0, '', '', '', 1, 1, 0, 0, 3); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_events_categories` -- CREATE TABLE `jos_events_categories` ( `id` int(12) NOT NULL default '0', `color` varchar(8) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_events_categories` -- INSERT INTO `jos_events_categories` (`id`, `color`) VALUES (3, '#3366FF'), (4, '#FF0000'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_groups` -- CREATE TABLE `jos_groups` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_groups` -- INSERT INTO `jos_groups` (`id`, `name`) VALUES (0, 'Public'), (1, 'Registered'), (2, 'Special'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jce_extensions` -- CREATE TABLE `jos_jce_extensions` ( `id` int(11) NOT NULL auto_increment, `pid` int(11) NOT NULL, `name` varchar(100) NOT NULL, `extension` varchar(255) NOT NULL, `folder` varchar(255) NOT NULL, `published` tinyint(3) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jce_extensions` -- INSERT INTO `jos_jce_extensions` (`id`, `pid`, `name`, `extension`, `folder`, `published`) VALUES (1, 15, 'Joomla Links for Advanced Link', 'joomlalinks', 'links', 1); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jce_groups` -- CREATE TABLE `jos_jce_groups` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `users` text NOT NULL, `types` varchar(255) NOT NULL, `components` text NOT NULL, `rows` text NOT NULL, `plugins` varchar(255) NOT NULL, `published` tinyint(3) NOT NULL, `ordering` int(11) NOT NULL, `checked_out` tinyint(3) NOT NULL, `checked_out_time` datetime NOT NULL, `params` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jce_groups` -- INSERT INTO `jos_jce_groups` (`id`, `name`, `description`, `users`, `types`, `components`, `rows`, `plugins`, `published`, `ordering`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'Default', 'Default group for all users with edit access', '', '19,20,21,23,24,25', '', '28,27,32,33,19,20,21,29,45,44,43,46,26,49,36,37,30,31,39,40;56,47,38,5,9,48,42,24,25,22,18,2;7,17,13,10,3;23,15,14,59,16,4,6,8,12,54,34,41,11', '1,52,53,55,57,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,28,54,59', 1, 1, 62, '2008-08-01 18:52:15', ''); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jce_plugins` -- CREATE TABLE `jos_jce_plugins` ( `id` int(11) NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `name` varchar(100) NOT NULL, `type` varchar(100) NOT NULL default 'plugin', `icon` varchar(255) NOT NULL default '', `layout` varchar(255) NOT NULL, `row` int(11) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `published` tinyint(3) NOT NULL default '0', `editable` tinyint(3) NOT NULL default '0', `elements` varchar(255) NOT NULL default '', `params` text NOT NULL, `iscore` tinyint(3) 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', PRIMARY KEY (`id`), UNIQUE KEY `plugin` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jce_plugins` -- INSERT INTO `jos_jce_plugins` (`id`, `title`, `name`, `type`, `icon`, `layout`, `row`, `ordering`, `published`, `editable`, `elements`, `params`, `iscore`, `checked_out`, `checked_out_time`) VALUES (1, 'Context Menu', 'contextmenu', 'plugin', '', '', 0, 19, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (2, 'Directionality', 'directionality', 'plugin', 'ltr,rtl', 'directionality', 3, 26, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (3, 'Emotions', 'emotions', 'plugin', 'emotions', 'emotions', 3, 24, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (4, 'Fullscreen', 'fullscreen', 'plugin', 'fullscreen', 'fullscreen', 3, 27, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (5, 'Paste', 'paste', 'plugin', 'pasteword,pastetext', 'paste', 2, 15, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (6, 'Preview', 'preview', 'plugin', 'preview', 'preview', 3, 29, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (7, 'Tables', 'table', 'plugin', 'tablecontrols', 'buttons', 3, 11, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (8, 'Print', 'print', 'plugin', 'print', 'print', 3, 25, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (9, 'Search Replace', 'searchreplace', 'plugin', 'search,replace', 'searchreplace', 2, 18, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (10, 'Styles', 'style', 'plugin', 'styleprops', 'style', 4, 16, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (11, 'Non-Breaking', 'nonbreaking', 'plugin', 'nonbreaking', 'nonbreaking', 4, 21, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (12, 'Visual Characters', 'visualchars', 'plugin', 'visualchars', 'visualchars', 4, 20, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (13, 'XHTML Xtras', 'xhtmlxtras', 'plugin', 'cite,abbr,acronym,del,ins,attribs', 'xhtmlxtras', 4, 17, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (14, 'Image Manager', 'imgmanager', 'plugin', 'imgmanager', 'imgmanager', 4, 30, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (15, 'Advanced Link', 'advlink', 'plugin', 'advlink', 'advlink', 4, 31, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (16, 'Spell Checker', 'spellchecker', 'plugin', 'spellchecker', 'spellchecker', 4, 22, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (17, 'Layers', 'layer', 'plugin', 'insertlayer,moveforward,movebackward,absolute', 'layer', 4, 10, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (18, 'Font ForeColour', 'forecolor', 'command', 'forecolor', 'forecolor', 2, 17, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (19, 'Bold', 'bold', 'command', 'bold', 'bold', 1, 2, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (20, 'Italic', 'italic', 'command', 'italic', 'italic', 1, 3, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (21, 'Underline', 'underline', 'command', 'underline', 'underline', 1, 4, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (22, 'Font BackColour', 'backcolor', 'command', 'backcolor', 'backcolor', 2, 18, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (23, 'Unlink', 'unlink', 'command', 'unlink', 'unlink', 2, 11, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (24, 'Font Select', 'fontselect', 'command', 'fontselect', 'fontselect', 1, 12, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (25, 'Font Size Select', 'fontsizeselect', 'command', 'fontsizeselect', 'fontsizeselect', 1, 13, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (26, 'Style Select', 'styleselect', 'command', 'styleselect', 'styleselect', 1, 10, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (27, 'New Document', 'newdocument', 'command', 'newdocument', 'newdocument', 1, 1, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (28, 'Help', 'help', 'plugin', 'help', 'help', 1, 6, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (29, 'StrikeThrough', 'strikethrough', 'command', 'strikethrough', 'strikethrough', 1, 5, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (30, 'Indent', 'indent', 'command', 'indent', 'indent', 2, 7, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (31, 'Outdent', 'outdent', 'command', 'outdent', 'outdent', 2, 6, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (32, 'Undo', 'undo', 'command', 'undo', 'undo', 2, 8, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (33, 'Redo', 'redo', 'command', 'redo', 'redo', 2, 9, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (34, 'Horizontal Rule', 'hr', 'command', 'hr', 'hr', 3, 2, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (35, 'HTML', 'html', 'command', 'code', 'code', 2, 16, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (36, 'Numbered List', 'numlist', 'command', 'numlist', 'numlist', 2, 5, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (37, 'Bullet List', 'bullist', 'command', 'bullist', 'bullist', 2, 4, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (38, 'Clipboard Actions', 'clipboard', 'command', 'cut,copy,paste', 'clipboard', 2, 1, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (39, 'Subscript', 'sub', 'command', 'sub', 'sub', 3, 5, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (40, 'Superscript', 'sup', 'command', 'sup', 'sup', 3, 6, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (41, 'Visual Aid', 'visualaid', 'command', 'visualaid', 'visualaid', 3, 4, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (42, 'Character Map', 'charmap', 'command', 'charmap', 'charmap', 3, 7, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (43, 'Justify Full', 'full', 'command', 'justifyfull', 'justifyfull', 1, 8, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (44, 'Justify Center', 'center', 'command', 'justifycenter', 'justifycenter', 1, 7, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (45, 'Justify Left', 'left', 'command', 'justifyleft', 'justifyleft', 1, 6, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (46, 'Justify Right', 'right', 'command', 'justifyright', 'justifyright', 1, 9, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (47, 'Remove Format', 'removeformat', 'command', 'removeformat', 'removeformat', 3, 3, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (48, 'Anchor', 'anchor', 'command', 'anchor', 'anchor', 2, 12, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (49, 'Format Select', 'formatselect', 'command', 'formatselect', 'formatselect', 1, 11, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (50, 'Image', 'image', 'command', 'image', 'image', 2, 13, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (51, 'Link', 'link', 'command', 'link', 'link', 2, 10, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (52, 'File Browser', 'browser', 'plugin', '', '', 0, 28, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (53, 'Inline Popups', 'inlinepopups', 'plugin', '', '', 0, 12, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (54, 'Read More', 'readmore', 'plugin', 'readmore', 'readmore', 4, 23, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (55, 'Media Support', 'media', 'plugin', '', '', 0, 9, 1, 1, '', '', 1, 0, '0000-00-00 00:00:00'), (56, 'Code Cleanup', 'cleanup', 'command', 'cleanup', 'cleanup', 2, 14, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (57, 'Safari Browser Support', 'safari', 'plugin', '', '', 0, 13, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'), (59, 'Advanced Code Editor', 'advcode', 'plugin', 'advcode', 'advcode', 4, 8, 1, 0, '', '', 1, 0, '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jp_exclusion` -- CREATE TABLE `jos_jp_exclusion` ( `id` bigint(20) NOT NULL auto_increment, `class` varchar(255) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jp_exclusion` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jp_inclusion` -- CREATE TABLE `jos_jp_inclusion` ( `id` bigint(20) NOT NULL auto_increment, `class` varchar(255) NOT NULL, `value` longtext NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jp_inclusion` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_jp_packvars` -- CREATE TABLE `jos_jp_packvars` ( `id` int(11) NOT NULL auto_increment, `key` varchar(255) NOT NULL, `value` varchar(255) default NULL, `value2` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_jp_packvars` -- INSERT INTO `jos_jp_packvars` (`id`, `key`, `value`, `value2`) VALUES (19, 'CUBETempFiles', NULL, 'a:1:{i:0;s:8:"c3c7f58e";}'), (20, 'CUBEObject', NULL, 'O:14:"JoomlapackCUBE":15:{s:14:"_currentDomain";s:7:"Packing";s:12:"_currentStep";s:0:"";s:15:"_currentSubstep";s:0:"";s:14:"_currentObject";O:20:"JoomlapackDomainPack":17:{s:12:"_ExcludeDirs";N;s:13:"_ExcludeFiles";N;s:14:"_directoryList";N;s:9:"_fileList";N;s:13:"_doneScanning";b:0;s:11:"_isPrepared";b:0;s:10:"_isRunning";b:0;s:11:"_isFinished";b:0;s:7:"_hasRan";b:0;s:8:"_isError";b:0;s:13:"_errorMessage";s:0:"";s:11:"_DomainName";s:7:"Packing";s:5:"_Step";s:0:"";s:8:"_Substep";s:0:"";s:16:"_parametersArray";a:0:{}s:6:"_error";N;s:9:"_warnings";N;}s:11:"_isFinished";b:0;s:6:"_Error";s:0:"";s:11:"_OnlyDBMode";b:0;s:13:"FilterManager";O:23:"JoomlapackFilterManager":1:{s:8:"_filters";N;}s:17:"_archiveExtension";s:4:".zip";s:17:"_archiverInstance";O:19:"JoomlapackPackerZIP":12:{s:8:"_methods";a:8:{i:0;s:4:"None";i:1;s:6:"Shrunk";i:2;s:10:"Super Fast";i:3;s:4:"Fast";i:4;s:6:"Normal";i:5;s:7:"Maximum";i:6;s:8:"Imploded";i:8;s:8:"Deflated";}s:14:"_ctrlDirHeader";s:4:"PK";s:11:"_ctrlDirEnd";s:8:"PK\0\0\0\0";s:11:"_fileHeader";s:4:"PK";s:16:"_ctrlDirFileName";s:78:"C:/wamp/www/ctg-joomla/administrator/components/com_joomlapack/backup\\jpzA.tmp";s:13:"_dataFileName";s:104:"C:/wamp/www/ctg-joomla/administrator/components/com_joomlapack/backup/site-localhost-20080923-102723.zip";s:17:"_totalFileEntries";i:20;s:30:"JoomlapackPackerZIP_CHUNK_SIZE";d:644264;s:13:"_xform_source";s:89:"C:\\wamp\\www\\ctg-joomla\\administrator\\components\\com_joomlapack\\assets\\installers\\jpi2.jpa";s:9:"_xform_fp";i:0;s:6:"_error";N;s:9:"_warnings";N;}s:15:"_dumperInstance";N;s:15:"_listerInstance";N;s:9:"_Warnings";N;s:6:"_error";N;s:9:"_warnings";N;}'), (21, 'CUBELock', NULL, '1222158444'), (22, 'CUBEEngineIncludes', NULL, 'a:3:{i:0;s:25:"classes.engine.packer.zip";i:1;s:29:"classes.engine.dumper.default";i:2;s:29:"classes.engine.lister.default";}'); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_menu` -- CREATE TABLE `jos_menu` ( `id` int(11) NOT NULL auto_increment, `menutype` varchar(75) default NULL, `name` varchar(255) default NULL, `alias` varchar(255) NOT NULL default '', `link` text, `type` varchar(50) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `parent` int(11) unsigned NOT NULL default '0', `componentid` int(11) unsigned NOT NULL default '0', `sublevel` int(11) default '0', `ordering` int(11) default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `pollid` int(11) NOT NULL default '0', `browserNav` tinyint(4) default '0', `access` tinyint(3) unsigned NOT NULL default '0', `utaccess` tinyint(3) unsigned NOT NULL default '0', `params` text NOT NULL, `lft` int(11) unsigned NOT NULL default '0', `rgt` int(11) unsigned NOT NULL default '0', `home` int(1) unsigned NOT NULL default '0', PRIMARY KEY (`id`), KEY `componentid` (`componentid`,`menutype`,`published`,`access`), KEY `menutype` (`menutype`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ; -- -- Gegevens worden uitgevoerd voor tabel `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', 'Home', 'home', 'index.php?option=com_content&view=frontpage', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=home.jpg\nsecure=0\n\n', 0, 0, 1), (2, 'mainmenu', 'Courses', 'courses', 'index.php?option=com_content&view=section&id=1', 'component', 1, 0, 20, 0, 2, 62, '2008-09-12 13:17:30', 0, 0, 0, 0, 'show_description=1\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=courses betere versie 2.jpg\nsecure=0\n\n', 0, 0, 0), (3, 'mainmenu', 'Games', 'games', 'index.php?option=com_content&view=section&id=2', 'component', 1, 0, 20, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_description=0\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=Games.jpg\nsecure=0\n\n', 0, 0, 0), (5, 'mainmenu', 'Gallery', 'gallery', 'index.php?option=com_content&view=section&id=4', 'component', 1, 0, 20, 0, 4, 62, '2008-09-10 08:01:18', 0, 0, 0, 0, 'show_description=1\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=Gallery.jpg\nsecure=0\n\n', 0, 0, 0), (6, 'mainmenu', 'Search', 'search', 'index.php?option=com_content&view=section&id=5', 'component', 1, 0, 20, 0, 5, 62, '2008-09-10 11:29:50', 0, 0, 0, 0, 'show_description=1\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=Search.jpg\nsecure=0\n\n', 0, 0, 0), (7, 'mainmenu', 'Group', 'group', 'index.php?option=com_content&view=section&id=6', 'component', 1, 0, 20, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_description=0\nshow_description_image=0\nshow_categories=1\nshow_empty_categories=0\nshow_cat_num_articles=1\nshow_category_description=1\norderby=\norderby_sec=\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=Group.jpg\nsecure=0\n\n', 0, 0, 0), (13, 'how-does-it-work', 'A beginners guide', 'a-beginners-guide', 'http://docs.joomla.org/Beginners', 'url', 1, 0, 0, 0, 1, 62, '2008-09-16 07:54:48', 0, 0, 0, 0, 'menu_image=-1\n\n', 0, 0, 0), (14, 'how-does-it-work', 'Template tutorial', 'template-tutorial', 'http://www.compassdesigns.net/tutorials/208-joomla-15-template-tutorial.html?start=5', 'url', 1, 0, 0, 0, 2, 62, '2008-09-16 07:48:16', 0, 0, 0, 0, 'menu_image=-1\n\n', 0, 0, 0), (15, 'how-does-it-work', 'Our guide', 'our-guide', 'http://192.168.0.79/Installation guide Joomla.doc', 'url', 1, 0, 0, 0, 3, 62, '2008-09-24 08:31:04', 0, 0, 0, 0, 'menu_image=-1\n\n', 0, 0, 0), (10, 'mainmenu', 'Admin Pages', 'admin-pages', 'http://localhost/administrator', 'url', 1, 0, 0, 0, 7, 62, '2008-09-25 13:13:39', 0, 0, 0, 0, 'menu_image=administrator.gif\n\n', 0, 0, 0); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_menu_types` -- CREATE TABLE `jos_menu_types` ( `id` int(10) unsigned NOT NULL auto_increment, `menutype` varchar(75) NOT NULL default '', `title` varchar(255) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `menutype` (`menutype`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_menu_types` -- INSERT INTO `jos_menu_types` (`id`, `menutype`, `title`, `description`) VALUES (1, 'mainmenu', 'Main Menu', 'The main menu for the site'), (4, 'how-does-it-work', 'How does it work?', ''); -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_messages` -- CREATE TABLE `jos_messages` ( `message_id` int(10) unsigned NOT NULL auto_increment, `user_id_from` int(10) unsigned NOT NULL default '0', `user_id_to` int(10) unsigned NOT NULL default '0', `folder_id` int(10) unsigned NOT NULL default '0', `date_time` datetime NOT NULL default '0000-00-00 00:00:00', `state` int(11) NOT NULL default '0', `priority` int(1) unsigned NOT NULL default '0', `subject` text NOT NULL, `message` text NOT NULL, PRIMARY KEY (`message_id`), KEY `useridto_state` (`user_id_to`,`state`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -- Gegevens worden uitgevoerd voor tabel `jos_messages` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_messages_cfg` -- CREATE TABLE `jos_messages_cfg` ( `user_id` int(10) unsigned NOT NULL default '0', `cfg_name` varchar(100) NOT NULL default '', `cfg_value` varchar(255) NOT NULL default '', UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_messages_cfg` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_migration_backlinks` -- CREATE TABLE `jos_migration_backlinks` ( `itemid` int(11) NOT NULL, `name` varchar(100) NOT NULL, `url` text NOT NULL, `sefurl` text NOT NULL, `newurl` text NOT NULL, PRIMARY KEY (`itemid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Gegevens worden uitgevoerd voor tabel `jos_migration_backlinks` -- -- -------------------------------------------------------- -- -- Tabel structuur voor tabel `jos_modules` -- CREATE TABLE `jos_modules` ( `id` int(11) NOT NULL auto_increment, `title` text NOT NULL, `content` text NOT NULL, `ordering` int(11) NOT NULL default '0', `position` varchar(50) default NULL, `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `module` varchar(50) default NULL, `numnews` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `showtitle` tinyint(3) unsigned NOT NULL default '1', `params` text NOT NULL, `iscore` tinyint(4) NOT NULL default '0', `client_id` tinyint(4) NOT NULL default '0', `control` text NOT NULL, PRIMARY KEY (`id`), KEY `published` (`published`,`access`), KEY `newsfeeds` (`module`,`published`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ; -- -- Gegevens worden uitgevoerd voor tabel `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 (2, 'Login', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, ''), (3, 'Popular', '', 3, 'cpanel', 62, '2008-09-16 11:10:33', 1, 'mod_popular', 0, 2, 1, '', 0, 1, ''), (4, 'Recent added Articles', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 0, 'mod_latest', 0, 2, 1, 'ordering=c_dsc\nuser_id=0\ncache=0\n\n', 0, 1, ''), (5, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 2, 1, '', 0, 1, ''), (6, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 2, 1, '', 1, 1, ''), (7, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 2, 1, '', 1, 1, ''), (8, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 2, 1, '', 1, 1, ''), (9, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 2, 1, '', 1, 1, ''), (10, 'Logged in Users', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 2, 1, '', 0, 1, ''), (11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, ''), (12, 'Admin Menu', '', 1, 'menu', 0, '0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1, '', 0, 1, ''), (13, 'Admin SubMenu', '', 1, 'submenu', 0, '0000-00-00 00:00:00', 1, 'mod_submenu', 0, 2, 1, '', 0, 1, ''), (14, 'User Status', '', 1, 'status', 0, '0000-00-00 00:00:00', 1, 'mod_status', 0, 2, 1, '', 0, 1, ''), (15, 'Title', '', 1, 'title', 0, '0000-00-00 00:00:00', 1, 'mod_title', 0, 2, 1, '', 0, 1, ''), (16, 'Menu', '', 0, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_j15mainmenuimages', 0, 0, 1, 'menutype=mainmenu\nmenu_style=list\nhide_bullet=0\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\nexpand_menu=0\nactivate_parent=1\nfull_active_id=1\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''), (20, 'Birthdays&Holidays', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_events_latest', 0, 0, 1, 'cache=0\nmoduleclass_sfx=\ncatid0=3\ncatid1=4\ncatid2=0\ncatid3=0\ncatid4=0\nmodlatest_inccss=1\nmodlatest_useLocalParam=0\nmodlatest_CustFmtStr=${eventDate}[!a: - ${endDate(%I:%M%p)}]\r\n\r\n \r\n\r\n | \r\n|||
\r\n | \r\n | \r\n | \r\n |
\r\n | \r\n | \r\n | \r\n |
\r\n | \r\n | \r\n | \r\n |
\r\n | \r\n | \r\n | \r\n |
\r\n | \r\n | \r\n | \r\n |
\r\n | \r\n | \r\n | \r\n |
\r\n
\r\n\r\n | \r\n\r\n |
\r\n
\r\n
\r\n
\r\n
\r\n | \r\n |
\r\n
\r\n
A site where you can find everything you want:
http://mytroos.yurls.net/index.php?mod=yurlspage&pageId=22702
Search with Google:
|
A Dutch search machine: