-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 21, 2007 at 11:58 AM
-- Server version: 5.0.19
-- PHP Version: 5.1.6
--
-- Database: `skaczkowski`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_autostand`
--
DROP TABLE IF EXISTS `jos_autostand`;
CREATE TABLE `jos_autostand` (
`id` int(10) NOT NULL auto_increment,
`obj_id` varchar(25) NOT NULL default '',
`cat` tinyint(4) NOT NULL default '0',
`type` tinyint(2) NOT NULL default '0',
`title` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`location` text NOT NULL,
`condition` text NOT NULL,
`other` text NOT NULL,
`fuel` varchar(20) NOT NULL default '0',
`Power` smallint(4) NOT NULL default '0',
`doors` smallint(4) NOT NULL default '2',
`space` varchar(10) NOT NULL default '0',
`homes` smallint(5) NOT NULL default '0',
`homes_size` decimal(10,2) NOT NULL default '0.00',
`pp_size` decimal(10,2) NOT NULL default '0.00',
`trade_units` smallint(5) NOT NULL default '0',
`trade_size` decimal(10,2) NOT NULL default '0.00',
`mileage` varchar(10) NOT NULL default '',
`ABS` tinyint(1) NOT NULL default '0',
`airbagc` tinyint(1) NOT NULL default '0',
`airbagp` tinyint(1) NOT NULL default '0',
`airbagl` tinyint(1) NOT NULL default '0',
`alarme` tinyint(1) NOT NULL default '0',
`apoiob` tinyint(1) NOT NULL default '0',
`arcond` tinyint(1) NOT NULL default '0',
`bancaq` tinyint(1) NOT NULL default '0',
`bancco` tinyint(1) NOT NULL default '0',
`comdir` tinyint(1) NOT NULL default '0',
`compbo` tinyint(1) NOT NULL default '0',
`cxaut` tinyint(1) NOT NULL default '0',
`direass` tinyint(1) NOT NULL default '0',
`encostr` tinyint(1) NOT NULL default '0',
`esp` tinyint(1) NOT NULL default '0',
`farnev` tinyint(1) NOT NULL default '0',
`fechce` tinyint(1) NOT NULL default '0',
`ganreb` tinyint(1) NOT NULL default '0',
`gps` tinyint(1) NOT NULL default '0',
`intpele` tinyint(1) NOT NULL default '0',
`jantll` tinyint(1) NOT NULL default '0',
`kittel` tinyint(1) NOT NULL default '0',
`luzxen` tinyint(1) NOT NULL default '0',
`pintmet` tinyint(1) NOT NULL default '0',
`radio` tinyint(1) NOT NULL default '0',
`rcasset` tinyint(1) NOT NULL default '0',
`rcd` tinyint(1) NOT NULL default '0',
`rdvd` tinyint(1) NOT NULL default '0',
`rdmp3` tinyint(1) NOT NULL default '0',
`rtv` tinyint(1) NOT NULL default '0',
`reguvel` tinyint(1) NOT NULL default '0',
`retele` tinyint(1) NOT NULL default '0',
`senspar` tinyint(1) NOT NULL default '0',
`tecele` tinyint(1) NOT NULL default '0',
`tecman` tinyint(1) NOT NULL default '0',
`videlef` tinyint(1) NOT NULL default '0',
`videleft` tinyint(1) NOT NULL default '0',
`volreg` tinyint(1) NOT NULL default '0',
`handicap` tinyint(1) NOT NULL default '0',
`yobuilt` varchar(10) NOT NULL default '',
`colour` varchar(20) NOT NULL default '0',
`fireside` tinyint(1) NOT NULL default '0',
`aircondition` tinyint(1) NOT NULL default '0',
`tv` tinyint(1) NOT NULL default '0',
`dsl` tinyint(1) NOT NULL default '0',
`swpool` tinyint(1) NOT NULL default '0',
`balcony` tinyint(1) NOT NULL default '0',
`terrace` tinyint(1) NOT NULL default '0',
`garden` tinyint(1) NOT NULL default '0',
`parkarea` tinyint(1) NOT NULL default '0',
`garage` tinyint(1) NOT NULL default '0',
`rent` decimal(10,2) NOT NULL default '0.00',
`rent_extra` decimal(10,2) NOT NULL default '0.00',
`price` decimal(10,2) NOT NULL default '0.00',
`commis` varchar(15) NOT NULL default '',
`secure` decimal(10,2) NOT NULL default '0.00',
`receipts` decimal(10,2) NOT NULL default '0.00',
`street` varchar(255) NOT NULL default '',
`streetnr` varchar(5) NOT NULL default '',
`pcode` varchar(10) NOT NULL default '',
`town` tinytext NOT NULL,
`district` tinytext NOT NULL,
`state` tinytext NOT NULL,
`country` tinytext NOT NULL,
`hits` int(6) NOT NULL default '0',
`hot` tinyint(1) NOT NULL default '0',
`metadesc` varchar(255) NOT NULL default '',
`metakey` varchar(255) NOT NULL default '',
`created` date NOT NULL default '0000-00-00',
`created_by` int(11) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`publish_up` date NOT NULL default '0000-00-00',
`publish_down` date NOT NULL default '0000-00-00',
`publish` tinyint(1) NOT NULL default '1',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_autostand`
--
INSERT INTO `jos_autostand` (`id`, `obj_id`, `cat`, `type`, `title`, `description`, `location`, `condition`, `other`, `fuel`, `Power`, `doors`, `space`, `homes`, `homes_size`, `pp_size`, `trade_units`, `trade_size`, `mileage`, `ABS`, `airbagc`, `airbagp`, `airbagl`, `alarme`, `apoiob`, `arcond`, `bancaq`, `bancco`, `comdir`, `compbo`, `cxaut`, `direass`, `encostr`, `esp`, `farnev`, `fechce`, `ganreb`, `gps`, `intpele`, `jantll`, `kittel`, `luzxen`, `pintmet`, `radio`, `rcasset`, `rcd`, `rdvd`, `rdmp3`, `rtv`, `reguvel`, `retele`, `senspar`, `tecele`, `tecman`, `videlef`, `videleft`, `volreg`, `handicap`, `yobuilt`, `colour`, `fireside`, `aircondition`, `tv`, `dsl`, `swpool`, `balcony`, `terrace`, `garden`, `parkarea`, `garage`, `rent`, `rent_extra`, `price`, `commis`, `secure`, `receipts`, `street`, `streetnr`, `pcode`, `town`, `district`, `state`, `country`, `hits`, `hot`, `metadesc`, `metakey`, `created`, `created_by`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (1, 'DDGE001', 4, 2, 'DODGE CALIBER 2.0 SE', 'Nowy DODGE Caliber, serwisowany z pełną dokumentacją. Samochód funkconował w naszej firmie jako pojazd demo.', '', 'Bardzo dobry, serwisowany, pełna dokumentacja', 'dodatkowo: ekran LCD 15,4 " zamontowany na tylnym fotelu', 'Diesel', 160, 5, '2.0-litre ', 0, 0.00, 0.00, 0, 0.00, '20000', 1, 1, 1, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 0, 1, 0, 1, 0, 0, 1, 0, 0, 0, 0, 1, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, '2006', 'BLACK', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.00, 0.00, 55000.00, '', 0.00, 0.00, '', '', '', '', '', 'Caliber', 'DOD', 13, 0, '', '', '2007-10-05', 62, 0, '2007-10-05', '0000-00-00', 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_autostand_categories`
--
DROP TABLE IF EXISTS `jos_autostand_categories`;
CREATE TABLE `jos_autostand_categories` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` varchar(255) NOT NULL default '',
`entries` int(10) NOT NULL default '0',
`parent` int(10) NOT NULL default '0',
`ordering` tinyint(4) NOT NULL default '0',
`access` tinyint(3) NOT NULL default '0',
`publish_up` date NOT NULL default '0000-00-00',
`publish_down` date NOT NULL default '0000-00-00',
`publish` tinyint(1) NOT NULL default '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `jos_autostand_categories`
--
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (1, 'Samochody Demo', 'Kategoria zawiera oferty samochodów demo.', 0, 0, 1, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (2, 'Chrysler', '', 0, 1, 3, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (3, 'Jeep', '', 0, 1, 1, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (4, 'Dodge', '', 0, 1, 2, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (5, 'Smochody second hand', 'Kategoria zawiera samochody używane', 0, 0, 2, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (6, 'Pierwszy właściciel', '', 0, 5, 1, 0, '2007-10-05', '0000-00-00', 1);
INSERT INTO `jos_autostand_categories` (`id`, `name`, `description`, `entries`, `parent`, `ordering`, `access`, `publish_up`, `publish_down`, `publish`) VALUES (7, 'Drugi właściciel', '', 0, 5, 2, 0, '2007-10-05', '0000-00-00', 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_autostand_images`
--
DROP TABLE IF EXISTS `jos_autostand_images`;
CREATE TABLE `jos_autostand_images` (
`id` int(10) NOT NULL auto_increment,
`objid` int(10) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`description` varchar(100) NOT NULL default '',
`fname` varchar(30) NOT NULL default '',
`type` varchar(5) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`owner` int(11) NOT NULL default '0',
`ordering` tinyint(4) NOT NULL default '0',
`publish` tinyint(1) default '1',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `jos_autostand_images`
--
INSERT INTO `jos_autostand_images` (`id`, `objid`, `title`, `description`, `fname`, `type`, `path`, `owner`, `ordering`, `publish`) VALUES (7, 1, '01', '', 'ea1191580224', '.jpg', '/components/com_autostand/pictures/', 62, 1, 1);
INSERT INTO `jos_autostand_images` (`id`, `objid`, `title`, `description`, `fname`, `type`, `path`, `owner`, `ordering`, `publish`) VALUES (6, 1, '02', '', 'ea1191580215', '.jpg', '/components/com_autostand/pictures/', 62, 2, 1);
INSERT INTO `jos_autostand_images` (`id`, `objid`, `title`, `description`, `fname`, `type`, `path`, `owner`, `ordering`, `publish`) VALUES (5, 1, '03', '', 'ea1191580202', '.jpg', '/components/com_autostand/pictures/', 62, 3, 1);
-- --------------------------------------------------------
--
-- Table structure for table `jos_banner`
--
DROP TABLE IF EXISTS `jos_banner`;
CREATE TABLE `jos_banner` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default 'banner',
`name` varchar(50) NOT NULL default '',
`imptotal` int(11) NOT NULL default '0',
`impmade` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(100) NOT NULL default '',
`clickurl` varchar(200) NOT NULL default '',
`date` datetime default NULL,
`showBanner` tinyint(1) NOT NULL default '0',
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`custombannercode` text,
PRIMARY KEY (`bid`),
KEY `viewbanner` (`showBanner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `jos_banner`
--
INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`) VALUES (1, 1, 'banner', 'OSM 1', 0, 112, 0, 'osmbanner1.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', NULL, NULL);
INSERT INTO `jos_banner` (`bid`, `cid`, `type`, `name`, `imptotal`, `impmade`, `clicks`, `imageurl`, `clickurl`, `date`, `showBanner`, `checked_out`, `checked_out_time`, `editor`, `custombannercode`) VALUES (2, 1, 'banner', 'OSM 2', 0, 112, 0, 'osmbanner2.png', 'http://www.opensourcematters.org', '2004-07-07 15:31:29', 1, 0, '0000-00-00 00:00:00', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jos_bannerclient`
--
DROP TABLE IF EXISTS `jos_bannerclient`;
CREATE TABLE `jos_bannerclient` (
`cid` int(11) NOT NULL auto_increment,
`name` varchar(60) NOT NULL default '',
`contact` varchar(60) NOT NULL default '',
`email` varchar(60) NOT NULL default '',
`extrainfo` text NOT NULL,
`checked_out` tinyint(1) NOT NULL default '0',
`checked_out_time` time default NULL,
`editor` varchar(50) default NULL,
PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_bannerclient`
--
INSERT INTO `jos_bannerclient` (`cid`, `name`, `contact`, `email`, `extrainfo`, `checked_out`, `checked_out_time`, `editor`) VALUES (1, 'Open Source Matters', 'Administrator', 'admin@opensourcematters.org', '', 0, '00:00:00', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `jos_bannerfinish`
--
DROP TABLE IF EXISTS `jos_bannerfinish`;
CREATE TABLE `jos_bannerfinish` (
`bid` int(11) NOT NULL auto_increment,
`cid` int(11) NOT NULL default '0',
`type` varchar(10) NOT NULL default '',
`name` varchar(50) NOT NULL default '',
`impressions` int(11) NOT NULL default '0',
`clicks` int(11) NOT NULL default '0',
`imageurl` varchar(50) NOT NULL default '',
`datestart` datetime default NULL,
`dateend` datetime default NULL,
PRIMARY KEY (`bid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `jos_bannerfinish`
--
-- --------------------------------------------------------
--
-- Table structure for table `jos_categories`
--
DROP TABLE IF EXISTS `jos_categories`;
CREATE TABLE `jos_categories` (
`id` int(11) NOT NULL auto_increment,
`parent_id` int(11) NOT NULL default '0',
`title` varchar(50) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`image` varchar(100) NOT NULL default '',
`section` varchar(50) NOT NULL default '',
`image_position` varchar(10) NOT NULL default '',
`description` text NOT NULL,
`published` tinyint(1) NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`editor` varchar(50) default NULL,
`ordering` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
`count` int(11) NOT NULL default '0',
`params` text NOT NULL,
PRIMARY KEY (`id`),
KEY `cat_idx` (`section`,`published`,`access`),
KEY `idx_section` (`section`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Dumping data for table `jos_categories`
--
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (1, 0, 'Latest', 'Latest News', 'taking_notes.jpg', '1', 'left', 'The latest news from the Joomla! Team', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 1, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (2, 0, 'Joomla!', 'Joomla!', 'clock.jpg', 'com_weblinks', 'left', 'A selection of links that are all related to the Joomla! Project.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (3, 0, 'Newsflash', 'Newsflash', '', '2', 'left', '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (4, 0, 'Joomla!', 'Joomla!', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 2, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (5, 0, 'Business: general', 'Business: general', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (7, 0, 'Examples', 'Example FAQs', 'key.jpg', '3', 'left', 'Here you will find an example set of FAQs.', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 2, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (9, 0, 'Finance', 'Finance', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (10, 0, 'Linux', 'Linux', '', 'com_newsfeeds', 'left', '
\r\n', 1, 0, '0000-00-00 00:00:00', NULL, 6, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (11, 0, 'Internet', 'Internet', '', 'com_newsfeeds', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (12, 0, 'Contacts', 'Contacts', '', 'com_contact_details', 'left', 'Contact Details for this website', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');
INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES (13, 0, 'AutoStand', 'AutoStands', '', 'com_contact_details', '', 'AS Contacts', 1, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_components`
--
DROP TABLE IF EXISTS `jos_components`;
CREATE TABLE `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,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=24 ;
--
-- Dumping data for table `jos_components`
--
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (2, 'Manage Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (3, 'Manage Clients', '', 0, 1, 'option=com_banners&task=listclients', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/globe2.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (5, 'Web Link Items', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (6, 'Web Link Categories', '', 0, 4, 'option=categories§ion=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/user.png', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (8, 'Manage Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (9, 'Contact Categories', '', 0, 7, 'option=categories§ion=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (10, 'Front Page', 'option=com_frontpage', 0, 0, '', 'Manage Front Page Items', 'com_frontpage', 0, 'js/ThemeOffice/component.png', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (11, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (12, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (13, 'Manage News Feeds', '', 0, 12, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (14, 'Manage Categories', '', 0, 12, 'option=com_categories§ion=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (15, 'Login', 'option=com_login', 0, 0, '', '', 'com_login', 0, '', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (16, 'Search', 'option=com_search', 0, 0, '', '', 'com_search', 0, '', 1, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (17, 'Syndicate', '', 0, 0, 'option=com_syndicate&hidemainmenu=1', 'Manage Syndication Settings', 'com_syndicate', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (18, 'Mass Mail', '', 0, 0, 'option=com_massmail&hidemainmenu=1', 'Send Mass Mail', 'com_massmail', 0, 'js/ThemeOffice/mass_email.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (19, 'AutoStand', 'option=com_autostand', 0, 0, 'option=com_autostand', 'AutoStand', 'com_autostand', 0, 'js/ThemeOffice/component.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (20, 'Manage Vehicles', '', 0, 19, 'option=com_autostand&act=manageObj', 'Manage Vehicles', 'com_autostand', 0, 'js/ThemeOffice/edit.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (21, 'Manage Categories', '', 0, 19, 'option=com_autostand&act=manageCat', 'Manage Categories', 'com_autostand', 1, 'js/ThemeOffice/categories.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (22, 'Configuration', '', 0, 19, 'option=com_autostand&act=configAS', 'Configuration', 'com_autostand', 2, 'js/ThemeOffice/config.png', 0, '');
INSERT INTO `jos_components` (`id`, `name`, `link`, `menuid`, `parent`, `admin_menu_link`, `admin_menu_alt`, `option`, `ordering`, `admin_menu_img`, `iscore`, `params`) VALUES (23, 'About AS', '', 0, 19, 'option=com_autostand&act=ASinfo', 'About AS', 'com_autostand', 3, 'js/ThemeOffice/credits.png', 0, '');
-- --------------------------------------------------------
--
-- Table structure for table `jos_contact_details`
--
DROP TABLE IF EXISTS `jos_contact_details`;
CREATE TABLE `jos_contact_details` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(100) NOT NULL default '',
`con_position` varchar(50) default NULL,
`address` text,
`suburb` varchar(50) default NULL,
`state` varchar(20) default NULL,
`country` varchar(50) default NULL,
`postcode` varchar(10) default NULL,
`telephone` varchar(25) default NULL,
`fax` varchar(25) default NULL,
`misc` mediumtext,
`image` varchar(100) default NULL,
`imagepos` varchar(20) default NULL,
`email_to` varchar(100) default NULL,
`default_con` tinyint(1) unsigned NOT NULL default '0',
`published` tinyint(1) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`ordering` int(11) NOT NULL default '0',
`params` text NOT NULL,
`user_id` int(11) NOT NULL default '0',
`catid` int(11) NOT NULL default '0',
`access` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `jos_contact_details`
--
INSERT INTO `jos_contact_details` (`id`, `name`, `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`) VALUES (1, 'Name', 'Position', 'Street', 'Suburb', 'State', 'Country', 'Zip Code', 'Telephone', 'Fax', 'Miscellanous info', 'asterisk.png', 'top', 'email@email.com', 1, 1, 0, '0000-00-00 00:00:00', 1, '', 0, 12, 0);
-- --------------------------------------------------------
--
-- Table structure for table `jos_content`
--
DROP TABLE IF EXISTS `jos_content`;
CREATE TABLE `jos_content` (
`id` int(11) unsigned NOT NULL auto_increment,
`title` varchar(100) NOT NULL default '',
`title_alias` varchar(100) NOT NULL default '',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`state` tinyint(3) NOT NULL default '0',
`sectionid` int(11) unsigned NOT NULL default '0',
`mask` int(11) unsigned NOT NULL default '0',
`catid` int(11) unsigned NOT NULL default '0',
`created` datetime NOT NULL default '0000-00-00 00:00:00',
`created_by` int(11) unsigned NOT NULL default '0',
`created_by_alias` varchar(100) NOT NULL default '',
`modified` datetime NOT NULL default '0000-00-00 00:00:00',
`modified_by` int(11) unsigned NOT NULL default '0',
`checked_out` int(11) unsigned NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_up` datetime NOT NULL default '0000-00-00 00:00:00',
`publish_down` datetime NOT NULL default '0000-00-00 00:00:00',
`images` text NOT NULL,
`urls` text NOT NULL,
`attribs` text NOT NULL,
`version` int(11) unsigned NOT NULL default '1',
`parentid` int(11) unsigned NOT NULL default '0',
`ordering` int(11) NOT NULL default '0',
`metakey` text NOT NULL,
`metadesc` text NOT NULL,
`access` int(11) unsigned NOT NULL default '0',
`hits` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `idx_section` (`sectionid`),
KEY `idx_access` (`access`),
KEY `idx_checkout` (`checked_out`),
KEY `idx_state` (`state`),
KEY `idx_catid` (`catid`),
KEY `idx_mask` (`mask`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `jos_content`
--
INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (1, 'Witamy w witrynie Auto Skaczkowski', 'Welcome', '
This website is powered by Joomla! The software and default templates on which it runs are Copyright 2005 Open Source Matters. All other content and data, including data entered into this website and templates added after installation, are copyrighted by their respective copyright owners.
If you want to distribute, copy or modify Joomla!, you are welcome to do so under the terms of the GNU General Public License. If you are unfamiliar with this license, you might want to read ''How To Apply These Terms To Your Program'' and the ''GNU General Public License FAQ''.
', '', 1, 0, 0, 0, '2004-08-19 20:11:07', 62, '', '2004-08-19 20:14:49', 62, 0, '0000-00-00 00:00:00', '2004-08-19 00:00:00', '0000-00-00 00:00:00', '', '', 'menu_image=\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 11, '', '', 0, 32); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (6, 'Example News Item 1', 'News1', '{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum.', '{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\nUt wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\nNam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\nConsetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.
', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:05:05', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/coffee.jpg|left||0\r\nfood/bread.jpg|right||0', '', '', 1, 0, 2, '', '', 0, 10); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (7, 'Example News Item 2', 'News2', '{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
', '', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:11:30', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'food/bun.jpg|right||0', '', '', 1, 0, 3, '', '', 0, 3); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (8, 'Example News Item 3', 'News3', '{mosimage}Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit\r\namet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem\r\nipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
', '', 1, 1, 0, 1, '2004-04-12 11:54:06', 62, '', '2004-07-07 18:08:23', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/pears.jpg|right||0', '', '', 1, 0, 4, '', '', 0, 1); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (9, 'Example News Item 4', 'News4', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
', '{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mospagebreak}{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\n{mospagebreak}Consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.
', 1, 1, 0, 1, '2004-07-07 11:54:06', 62, '', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-07-07 00:00:00', '0000-00-00 00:00:00', 'fruit/strawberry.jpg|left||0\r\nfruit/pears.jpg|right||0\r\nfruit/cherry.jpg|left||0', '', '', 1, 0, 5, '', '', 0, 6); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (10, 'Example FAQ Item 1', 'FAQ1', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
', '', 1, 3, 0, 7, '2004-05-12 11:54:06', 62, '', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', '', '', '', 1, 0, 5, '', '', 0, 8); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (11, 'Example FAQ Item 2', 'FAQ2', 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat,\r\nsed diam voluptua. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam\r\nvoluptua. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.
', '{mosimage}Duis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis at\r\nvero eros et accumsan et iusto odio dignissim qui blandit praesent luptatum\r\nzzril delenit augue duis dolore te feugait nulla facilisi. Lorem ipsum dolor\r\nsit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod tincidunt\r\nut laoreet dolore magna aliquam erat volutpat.
\r\n\r\n{mosimage}Ut wisi enim ad minim veniam, quis nostrud exerci tation\r\nullamcorper suscipit lobortis nisl ut aliquip ex ea commodo consequat. Duis\r\nautem vel eum iriure dolor in hendrerit in vulputate velit esse molestie\r\nconsequat, vel illum dolore eu feugiat nulla facilisis at vero eros et accumsan\r\net iusto odio dignissim qui blandit praesent luptatum zzril delenit augue duis\r\ndolore te feugait nulla facilisi.
\r\n\r\n{mosimage}Nam liber tempor cum soluta nobis eleifend option congue\r\nnihil imperdiet doming id quod mazim placerat facer possim assum. Lorem ipsum\r\ndolor sit amet, consectetuer adipiscing elit, sed diam nonummy nibh euismod\r\ntincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim\r\nveniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut\r\naliquip ex ea commodo consequat.
\r\n\r\nDuis autem vel eum iriure dolor in hendrerit in vulputate\r\nvelit esse molestie consequat, vel illum dolore eu feugiat nulla facilisis. At\r\nvero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd\r\ngubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum\r\ndolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, At accusam aliquyam diam diam dolore dolores\r\nduo eirmod eos erat, et nonumy sed tempor et et invidunt justo labore Stet\r\nclita ea et gubergren, kasd magna no rebum. sanctus sea sed takimata ut vero\r\nvoluptua. est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet,\r\nconsetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore\r\net dolore magna aliquyam erat.
\r\n\r\nConsetetur sadipscing elitr, sed diam nonumy eirmod tempor\r\ninvidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero\r\neos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no\r\nsea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit\r\namet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut\r\nlabore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam\r\net justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata\r\nsanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur\r\nsadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore\r\nmagna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo\r\ndolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est\r\nLorem ipsum dolor sit amet.
', 1, 3, 0, 7, '2004-05-12 11:54:06', 62, 'Web master', '2004-07-07 18:10:23', 62, 0, '0000-00-00 00:00:00', '2004-01-01 00:00:00', '0000-00-00 00:00:00', 'fruit/cherry.jpg|left||0\r\nfruit/peas.jpg|right||0\r\nfood/milk.jpg|left||0', '', '', 1, 0, 5, '', '', 0, 10); INSERT INTO `jos_content` (`id`, `title`, `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`) VALUES (12, 'Static1', 'Static1', '', '', 1, 0, 0, 0, '2007-10-07 11:29:37', 62, '', '2007-10-07 11:29:38', 62, 0, '0000-00-00 00:00:00', '2007-10-07 11:29:19', '0000-00-00 00:00:00', '', '', 'menu_image=-1\nitem_title=1\npageclass_sfx=\nback_button=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=', 1, 0, 0, '', '', 0, 11); -- -------------------------------------------------------- -- -- Table structure for table `jos_content_frontpage` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_content_frontpage` -- INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (1, 1); INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (2, 2); INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (3, 3); INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (4, 4); INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES (5, 5); -- -------------------------------------------------------- -- -- Table structure for table `jos_content_rating` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_content_rating` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_core_acl_aro` -- DROP TABLE IF EXISTS `jos_core_acl_aro`; CREATE TABLE `jos_core_acl_aro` ( `aro_id` int(11) NOT NULL auto_increment, `section_value` varchar(240) NOT NULL default '0', `value` varchar(240) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`aro_id`), UNIQUE KEY `jos_gacl_section_value_value_aro` (`section_value`(100),`value`(100)), KEY `jos_gacl_hidden_aro` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `jos_core_acl_aro` -- INSERT INTO `jos_core_acl_aro` (`aro_id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', '62', 0, 'Administrator', 0); -- -------------------------------------------------------- -- -- Table structure for table `jos_core_acl_aro_groups` -- DROP TABLE IF EXISTS `jos_core_acl_aro_groups`; CREATE TABLE `jos_core_acl_aro_groups` ( `group_id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `name` varchar(255) NOT NULL default '', `lft` int(11) NOT NULL default '0', `rgt` int(11) NOT NULL default '0', PRIMARY KEY (`group_id`), KEY `parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_parent_id_aro_groups` (`parent_id`), KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ; -- -- Dumping data for table `jos_core_acl_aro_groups` -- INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (17, 0, 'ROOT', 1, 22); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (28, 17, 'USERS', 2, 21); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (29, 28, 'Public Frontend', 3, 12); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (18, 29, 'Registered', 4, 11); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (19, 18, 'Author', 5, 10); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (20, 19, 'Editor', 6, 9); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (21, 20, 'Publisher', 7, 8); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (30, 28, 'Public Backend', 13, 20); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (23, 30, 'Manager', 14, 19); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (24, 23, 'Administrator', 15, 18); INSERT INTO `jos_core_acl_aro_groups` (`group_id`, `parent_id`, `name`, `lft`, `rgt`) VALUES (25, 24, 'Super Administrator', 16, 17); -- -------------------------------------------------------- -- -- Table structure for table `jos_core_acl_aro_sections` -- DROP TABLE IF EXISTS `jos_core_acl_aro_sections`; CREATE TABLE `jos_core_acl_aro_sections` ( `section_id` int(11) NOT NULL auto_increment, `value` varchar(230) NOT NULL default '', `order_value` int(11) NOT NULL default '0', `name` varchar(230) NOT NULL default '', `hidden` int(11) NOT NULL default '0', PRIMARY KEY (`section_id`), UNIQUE KEY `value_aro_sections` (`value`), UNIQUE KEY `jos_gacl_value_aro_sections` (`value`), KEY `hidden_aro_sections` (`hidden`), KEY `jos_gacl_hidden_aro_sections` (`hidden`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `jos_core_acl_aro_sections` -- INSERT INTO `jos_core_acl_aro_sections` (`section_id`, `value`, `order_value`, `name`, `hidden`) VALUES (10, 'users', 1, 'Users', 0); -- -------------------------------------------------------- -- -- Table structure for table `jos_core_acl_groups_aro_map` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_core_acl_groups_aro_map` -- INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES (25, '', 10); -- -------------------------------------------------------- -- -- Table structure for table `jos_core_log_items` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_core_log_items` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_core_log_searches` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_core_log_searches` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_groups` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_groups` -- INSERT INTO `jos_groups` (`id`, `name`) VALUES (0, 'Public'); INSERT INTO `jos_groups` (`id`, `name`) VALUES (1, 'Registered'); INSERT INTO `jos_groups` (`id`, `name`) VALUES (2, 'Special'); -- -------------------------------------------------------- -- -- Table structure for table `jos_mambots` -- DROP TABLE IF EXISTS `jos_mambots`; CREATE TABLE `jos_mambots` ( `id` int(11) NOT NULL auto_increment, `name` varchar(100) NOT NULL default '', `element` varchar(100) NOT NULL default '', `folder` varchar(100) NOT NULL default '', `access` tinyint(3) unsigned NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `published` tinyint(3) NOT NULL default '0', `iscore` tinyint(3) NOT NULL default '0', `client_id` tinyint(3) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_folder` (`published`,`client_id`,`access`,`folder`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `jos_mambots` -- INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (1, 'MOS Image', 'mosimage', 'content', 0, -10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (2, 'MOS Pagination', 'mospaging', 'content', 0, 10000, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (3, 'Legacy Mambot Includer', 'legacybots', 'content', 0, 1, 0, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (4, 'SEF', 'mossef', 'content', 0, 3, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (5, 'MOS Rating', 'mosvote', 'content', 0, 4, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (6, 'Search Content', 'content.searchbot', 'search', 0, 1, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (7, 'Search Weblinks', 'weblinks.searchbot', 'search', 0, 2, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (8, 'Code support', 'moscode', 'content', 0, 2, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (9, 'No WYSIWYG Editor', 'none', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (10, 'TinyMCE WYSIWYG Editor', 'tinymce', 'editors', 0, 0, 1, 1, 0, 0, '0000-00-00 00:00:00', 'theme=advanced'); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (11, 'MOS Image Editor Button', 'mosimage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (12, 'MOS Pagebreak Editor Button', 'mospage.btn', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (13, 'Search Contacts', 'contacts.searchbot', 'search', 0, 3, 1, 1, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (14, 'Search Categories', 'categories.searchbot', 'search', 0, 4, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (15, 'Search Sections', 'sections.searchbot', 'search', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (16, 'Email Cloaking', 'mosemailcloak', 'content', 0, 5, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (17, 'GeSHi', 'geshi', 'content', 0, 5, 0, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (18, 'Search Newsfeeds', 'newsfeeds.searchbot', 'search', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); INSERT INTO `jos_mambots` (`id`, `name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`) VALUES (19, 'Load Module Positions', 'mosloadposition', 'content', 0, 6, 1, 0, 0, 0, '0000-00-00 00:00:00', ''); -- -------------------------------------------------------- -- -- Table structure for table `jos_menu` -- DROP TABLE IF EXISTS `jos_menu`; CREATE TABLE `jos_menu` ( `id` int(11) NOT NULL auto_increment, `menutype` varchar(25) default NULL, `name` varchar(100) default NULL, `link` text, `type` varchar(50) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `parent` int(11) unsigned NOT NULL default '0', `componentid` int(11) unsigned NOT NULL default '0', `sublevel` int(11) default '0', `ordering` int(11) default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `pollid` int(11) NOT NULL default '0', `browserNav` tinyint(4) default '0', `access` tinyint(3) unsigned NOT NULL default '0', `utaccess` tinyint(3) unsigned NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `componentid` (`componentid`,`menutype`,`published`,`access`), KEY `menutype` (`menutype`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `jos_menu` -- INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (1, 'mainmenu', 'Home', 'index.php?option=com_frontpage', 'components', 1, 0, 10, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nheader=Welcome\npage_title=0\nback_button=0\nleading=1\nintro=12\ncolumns=1\nlink=8\norderby_pri=\norderby_sec=front\npagination=2\npagination_results=1\nimage=1\nsection=0\nsection_link=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=0\nprint=0\nemail=0\nunpublished=0'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (2, 'mainmenu', 'News', 'index.php?option=com_content&task=section&id=1', 'content_section', 1, 0, 1, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (3, 'mainmenu', 'Contact Us', 'index.php?option=com_contact', 'components', 1, 0, 7, 0, 6, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (23, 'mainmenu', 'Links', 'index.php?option=com_weblinks', 'components', 1, 0, 4, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=web_links.jpg\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nheadings=1\nhits=\nitem_description=1\nother_cat=1\ndescription=1\ndescription_text=\nimage=-1\nimage_align=right\nweblink_icons='); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (5, 'mainmenu', 'Search', 'index.php?option=com_search', 'components', 1, 0, 16, 0, 7, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (6, 'mainmenu', 'License', 'index.php?option=com_content&task=view&id=5', 'content_typed', 1, 0, 5, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\nunique_itemid=0'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (7, 'mainmenu', 'News Feeds', 'index.php?option=com_newsfeeds', 'components', 1, 0, 12, 0, 8, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader='); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (8, 'mainmenu', 'Wrapper', 'index.php?option=com_wrapper', 'wrapper', 1, 0, 0, 0, 10, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\npage_title=1\nheader=\nscrolling=auto\nwidth=100%\nheight=600\nheight_auto=0\nurl=www.joomla.org'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (9, 'mainmenu', 'Blog', 'index.php?option=com_content&task=blogsection&id=0', 'content_blog_section', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1\npageclass_sfx=\nback_button=\nheader=A blog of all sections with no images\npage_title=1\nleading=0\nintro=6\ncolumns=2\nlink=4\norderby_pri=\norderby_sec=\npagination=2\npagination_results=1\nimage=0\ndescription=0\ndescription_image=0\ncategory=0\ncategory_link=0\nitem_title=1\nlink_titles=\nreadmore=\nrating=\nauthor=\ncreatedate=\nmodifydate=\npdf=\nprint=\nemail=\nsectionid='); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (10, 'othermenu', 'Joomla! Home', 'http://www.joomla.org', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (11, 'othermenu', 'Joomla! Forums', 'http://forum.joomla.org', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (12, 'othermenu', 'OSM Home', 'http://www.opensourcematters.org', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (24, 'othermenu', 'Administrator', 'administrator/', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (21, 'usermenu', 'Your Details', 'index.php?option=com_user&task=UserDetails', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (13, 'usermenu', 'Submit News', 'index.php?option=com_content&task=new§ionid=1&Itemid=0', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (14, 'usermenu', 'Submit WebLink', 'index.php?option=com_weblinks&task=new', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (15, 'usermenu', 'Check-In My Items', 'index.php?option=com_user&task=CheckIn', 'url', 1, 0, 0, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 2, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (16, 'usermenu', 'Logout', 'index.php?option=com_login', 'components', 1, 0, 15, 0, 5, 0, '0000-00-00 00:00:00', 0, 0, 1, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (17, 'topmenu', 'Home', 'index.php', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (18, 'topmenu', 'Contact Us', 'index.php?option=com_contact&Itemid=3', 'url', 1, 0, 0, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (19, 'topmenu', 'News', 'index.php?option=com_content&task=section&id=1&Itemid=2', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (20, 'topmenu', 'Links', 'index.php?option=com_weblinks&Itemid=23', 'url', 1, 0, 0, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'menu_image=-1'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (25, 'mainmenu', 'FAQs', 'index.php?option=com_content&task=category§ionid=3&id=7', 'content_category', 1, 0, 7, 0, 9, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\npage_title=1\npageclass_sfx=\nback_button=\norderby=\ndate_format=\ndate=\nauthor=\ntitle=1\nhits=\nheadings=1\nnavigation=1\norder_select=1\ndisplay=1\ndisplay_num=50\nfilter=1\nfilter_type=title\nother_cat=1\nempty_cat=0\ncat_items=1\ncat_description=1'); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (26, 'mainmenu', 'Second hand', 'index.php?option=com_autostand', 'components', 1, 0, 19, 0, 11, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''); INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`) VALUES (27, 'mainmenu', 'Static 1', 'index.php?option=com_content&task=view&id=12', 'content_typed', 1, 0, 12, 0, 12, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `jos_messages` -- DROP TABLE IF EXISTS `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` varchar(230) NOT NULL default '', `message` text NOT NULL, PRIMARY KEY (`message_id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `jos_messages` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_messages_cfg` -- DROP TABLE IF EXISTS `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=latin1; -- -- Dumping data for table `jos_messages_cfg` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_modules` -- DROP TABLE IF EXISTS `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(10) default NULL, `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `module` varchar(50) default NULL, `numnews` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `showtitle` tinyint(3) unsigned NOT NULL default '1', `params` text NOT NULL, `iscore` tinyint(4) NOT NULL default '0', `client_id` tinyint(4) NOT NULL default '0', PRIMARY KEY (`id`), KEY `published` (`published`,`access`), KEY `newsfeeds` (`module`,`published`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ; -- -- Dumping data for table `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`) VALUES (1, 'Polls', '', 1, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_poll', 0, 0, 1, '', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (2, 'User Menu', '', 6, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=usermenu', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (3, 'Main Menu', '', 1, 'user6', 62, '2007-10-14 18:02:18', 1, 'mod_mainmenu', 0, 0, 1, 'class_sfx=\nmoduleclass_sfx=\nmenutype=mainmenu\nmenu_style=vert_indent\nfull_active_id=0\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (4, 'Login Form', '', 1, 'user4', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, 'moduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\nlogin_message=0\nlogout_message=0\ngreeting=1\nname=0', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (5, 'Syndicate', '', 9, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_rssfeed', 0, 0, 1, '', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (6, 'Latest News', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_latestnews', 0, 0, 1, 'moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (7, 'Statistics', '', 10, '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); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (8, 'Who''s Online', '', 4, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_whosonline', 0, 0, 1, 'online=1\nusers=1\nmoduleclass_sfx=', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (9, 'Popular', '', 5, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mostread', 0, 0, 1, 'moduleclass_sfx=\ncache=0\ntype=1\nshow_front=1\ncount=5\ncatid=\nsecid=', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (10, 'Template Chooser', '', 11, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_templatechooser', 0, 0, 1, 'show_preview=1', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (11, 'Archive', '', 12, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_archive', 0, 0, 1, '', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (12, 'Sections', '', 13, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_sections', 0, 0, 1, '', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (13, 'Newsflash', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_newsflash', 0, 0, 1, 'catid=3\nstyle=random\nimage=0\nlink_titles=\nreadmore=0\nitem_title=0\nitems=\ncache=0\nmoduleclass_sfx=', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (14, 'Related Items', '', 14, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_related_items', 0, 0, 1, '', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (15, 'Search', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_search', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nset_itemid=\nwidth=20\ntext=\nbutton=\nbutton_pos=right\nbutton_text=', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (16, 'Random Image', '', 5, 'right', 0, '0000-00-00 00:00:00', 1, 'mod_random_image', 0, 0, 1, '', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (17, 'Top Menu', '', 4, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'class_sfx=-nav\nmoduleclass_sfx=\nmenutype=topmenu\nmenu_style=list_flat\nfull_active_id=0\ncache=0\nactivate_parent=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (18, 'Banners', '', 1, 'banner', 0, '0000-00-00 00:00:00', 1, 'mod_banners', 0, 0, 0, 'banner_cids=\nmoduleclass_sfx=\n', 1, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (19, 'Components', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_components', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (20, 'Popular', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 99, 1, '', 0, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (21, 'Latest Items', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 99, 1, '', 0, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (22, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 99, 1, '', 0, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (23, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (24, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (25, 'Full Menu', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_fullmenu', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (26, 'Pathway', '', 1, 'pathway', 0, '0000-00-00 00:00:00', 1, 'mod_pathway', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (27, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (28, 'System Message', '', 1, 'inset', 0, '0000-00-00 00:00:00', 1, 'mod_mosmsg', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (29, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 99, 1, '', 1, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (30, 'Other Menu', '', 7, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=othermenu\nmenu_style=vert_indent\ncache=0\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nclass_sfx=\nmoduleclass_sfx=\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (31, 'Wrapper', '', 15, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_wrapper', 0, 0, 1, '', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (32, 'Logged', '', 0, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 99, 1, '', 0, 1); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (33, 'Lorem ipsum dolor', '', 1, 'user5', 0, '0000-00-00 00:00:00', 0, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (41, 'A1', 'Proin at eros non eros adipiscing mollis. Donec semper turpis sed diam.', 1, 'user1', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (34, 'Second Hand Cars', '', 2, 'right', 0, '0000-00-00 00:00:00', 0, 'mod_as_random_img', 0, 0, 1, 'moduleclass_sfx=\nshowtitle=1', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (35, 'AS Latest ', '', 16, 'left', 0, '0000-00-00 00:00:00', 0, 'mod_as_latest', 0, 0, 1, '', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (36, 'AA1 TOP FLASH', '', 1, 'top', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (37, 'BB1 SYCT', '', 1, 'bottom', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (38, 'MMCT CONTENT VIEW CONTEINER', '', 1, 'advert3', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (39, 'headerB1 ADVERT1', '', 1, 'advert1', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); INSERT INTO `jos_modules` (`id`, `title`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `published`, `module`, `numnews`, `access`, `showtitle`, `params`, `iscore`, `client_id`) VALUES (42, 'TOP B1', '', 2, 'top', 0, '0000-00-00 00:00:00', 1, '', 0, 0, 0, 'moduleclass_sfx=\ncache=0\nfirebots=1\nrssurl=\nrsstitle=1\nrssdesc=1\nrssimage=1\nrssitems=3\nrssitemdesc=1\nword_count=0\nrsscache=3600', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `jos_modules_menu` -- DROP TABLE IF EXISTS `jos_modules_menu`; CREATE TABLE `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=latin1; -- -- Dumping data for table `jos_modules_menu` -- INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (1, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (2, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (3, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (4, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (5, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (6, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (6, 2); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (8, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (9, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (9, 2); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (10, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 2); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 3); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 5); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 6); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 7); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 8); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 9); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 23); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (13, 25); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (15, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (17, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (18, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (30, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (33, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (34, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (35, 0); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (36, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (36, 27); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (37, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (37, 27); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 2); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 3); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 5); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 6); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 7); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 8); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 9); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 10); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 11); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 12); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 17); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 21); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 23); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 24); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 25); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (38, 26); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 2); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 3); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 5); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 6); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 7); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 8); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 9); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 10); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 11); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 12); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 23); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 24); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 25); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (39, 26); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (41, 1); INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES (42, 1); -- -------------------------------------------------------- -- -- Table structure for table `jos_newsfeeds` -- DROP TABLE IF EXISTS `jos_newsfeeds`; CREATE TABLE `jos_newsfeeds` ( `catid` int(11) NOT NULL default '0', `id` int(11) NOT NULL auto_increment, `name` text NOT NULL, `link` text NOT NULL, `filename` varchar(200) default NULL, `published` tinyint(1) NOT NULL default '0', `numarticles` int(11) unsigned NOT NULL default '1', `cache_time` int(11) unsigned NOT NULL default '3600', `checked_out` tinyint(3) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `published` (`published`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ; -- -- Dumping data for table `jos_newsfeeds` -- INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (4, 1, 'Joomla! - Official News', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_frontpage&Itemid=1', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 8); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (4, 2, 'Joomla! - Community News', 'http://www.joomla.org/index.php?option=com_rss_xtd&feed=RSS2.0&type=com_content&task=blogcategory&id=0&Itemid=33', '', 1, 5, 3600, 0, '0000-00-00 00:00:00', 9); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (10, 4, 'Linux Today', 'http://linuxtoday.com/backend/my-netscape.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 1); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (5, 5, 'Business News', 'http://headlines.internet.com/internetnews/bus-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 2); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (11, 6, 'Web Developer News', 'http://headlines.internet.com/internetnews/wd-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 3); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (10, 7, 'Linux Central:New Products', 'http://linuxcentral.com/backend/lcnew.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 4); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (10, 8, 'Linux Central:Best Selling', 'http://linuxcentral.com/backend/lcbestns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 5); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (10, 9, 'Linux Central:Daily Specials', 'http://linuxcentral.com/backend/lcspecialns.rdf', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 6); INSERT INTO `jos_newsfeeds` (`catid`, `id`, `name`, `link`, `filename`, `published`, `numarticles`, `cache_time`, `checked_out`, `checked_out_time`, `ordering`) VALUES (9, 10, 'Internet:Finance News', 'http://headlines.internet.com/internetnews/fina-news/news.rss', '', 1, 3, 3600, 0, '0000-00-00 00:00:00', 7); -- -------------------------------------------------------- -- -- Table structure for table `jos_poll_data` -- DROP TABLE IF EXISTS `jos_poll_data`; CREATE TABLE `jos_poll_data` ( `id` int(11) NOT NULL auto_increment, `pollid` int(4) NOT NULL default '0', `text` text NOT NULL, `hits` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `pollid` (`pollid`,`text`(1)) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ; -- -- Dumping data for table `jos_poll_data` -- INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (1, 14, 'Absolutely simple', 1); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (2, 14, 'Reasonably easy', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (3, 14, 'Not straight-forward but I worked it out', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (4, 14, 'I had to install extra server stuff', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (5, 14, 'I had no idea and got my friend to do it', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (6, 14, 'My dog ran away with the README ...', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (7, 14, '', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (8, 14, '', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (9, 14, '', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (10, 14, '', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (11, 14, '', 0); INSERT INTO `jos_poll_data` (`id`, `pollid`, `text`, `hits`) VALUES (12, 14, '', 0); -- -------------------------------------------------------- -- -- Table structure for table `jos_poll_date` -- DROP TABLE IF EXISTS `jos_poll_date`; CREATE TABLE `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=latin1 AUTO_INCREMENT=1 ; -- -- Dumping data for table `jos_poll_date` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_poll_menu` -- DROP TABLE IF EXISTS `jos_poll_menu`; CREATE TABLE `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=latin1; -- -- Dumping data for table `jos_poll_menu` -- INSERT INTO `jos_poll_menu` (`pollid`, `menuid`) VALUES (14, 1); -- -------------------------------------------------------- -- -- Table structure for table `jos_polls` -- DROP TABLE IF EXISTS `jos_polls`; CREATE TABLE `jos_polls` ( `id` int(11) unsigned NOT NULL auto_increment, `title` varchar(100) NOT NULL default '', `voters` int(9) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `access` int(11) NOT NULL default '0', `lag` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ; -- -- Dumping data for table `jos_polls` -- INSERT INTO `jos_polls` (`id`, `title`, `voters`, `checked_out`, `checked_out_time`, `published`, `access`, `lag`) VALUES (14, 'This Joomla! installation was ....', 1, 0, '0000-00-00 00:00:00', 1, 0, 86400); -- -------------------------------------------------------- -- -- Table structure for table `jos_sections` -- DROP TABLE IF EXISTS `jos_sections`; CREATE TABLE `jos_sections` ( `id` int(11) NOT NULL auto_increment, `title` varchar(50) NOT NULL default '', `name` varchar(255) NOT NULL default '', `image` varchar(100) NOT NULL default '', `scope` varchar(50) NOT NULL default '', `image_position` varchar(10) NOT NULL default '', `description` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_scope` (`scope`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `jos_sections` -- INSERT INTO `jos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES (1, 'News', 'The News', 'articles.jpg', 'content', 'right', 'Select a news topic from the list below, then select a news article to read.', 1, 0, '0000-00-00 00:00:00', 1, 0, 1, ''); INSERT INTO `jos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES (2, 'Newsflashes', 'Newsflashes', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, ''); INSERT INTO `jos_sections` (`id`, `title`, `name`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES (3, 'FAQs', 'Frequently Asked Questions', 'pastarchives.jpg', 'content', 'left', 'From the list below choose one of our FAQs topics, then select an FAQ to read. If you have a question which is not in this section, please contact us.', 1, 0, '0000-00-00 00:00:00', 2, 0, 1, ''); -- -------------------------------------------------------- -- -- Table structure for table `jos_session` -- DROP TABLE IF EXISTS `jos_session`; CREATE TABLE `jos_session` ( `username` varchar(50) default '', `time` varchar(14) default '', `session_id` varchar(200) NOT NULL default '0', `guest` tinyint(4) default '1', `userid` int(11) default '0', `usertype` varchar(50) default '', `gid` tinyint(3) unsigned NOT NULL default '0', PRIMARY KEY (`session_id`), KEY `whosonline` (`guest`,`usertype`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `jos_session` -- INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`) VALUES ('admin', '1192377738', '43f7cc482cf6551c7dbedf0c2634943d', 1, 62, 'Super Administrator', 0); -- -------------------------------------------------------- -- -- Table structure for table `jos_stats_agents` -- DROP TABLE IF EXISTS `jos_stats_agents`; CREATE TABLE `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=latin1; -- -- Dumping data for table `jos_stats_agents` -- -- -------------------------------------------------------- -- -- Table structure for table `jos_template_positions` -- DROP TABLE IF EXISTS `jos_template_positions`; CREATE TABLE `jos_template_positions` ( `id` int(11) NOT NULL auto_increment, `position` varchar(10) NOT NULL default '', `description` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=28 ; -- -- Dumping data for table `jos_template_positions` -- INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (1, 'left', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (2, 'right', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (3, 'top', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (4, 'bottom', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (5, 'inset', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (6, 'banner', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (7, 'header', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (8, 'footer', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (9, 'newsflash', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (10, 'legals', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (11, 'pathway', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (12, 'toolbar', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (13, 'cpanel', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (14, 'user1', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (15, 'user2', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (16, 'user3', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (17, 'user4', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (18, 'user5', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (19, 'user6', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (20, 'user7', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (21, 'user8', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (22, 'user9', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (23, 'advert1', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (24, 'advert2', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (25, 'advert3', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (26, 'icon', ''); INSERT INTO `jos_template_positions` (`id`, `position`, `description`) VALUES (27, 'debug', ''); -- -------------------------------------------------------- -- -- Table structure for table `jos_templates_menu` -- DROP TABLE IF EXISTS `jos_templates_menu`; CREATE TABLE `jos_templates_menu` ( `template` varchar(50) NOT NULL default '', `menuid` int(11) NOT NULL default '0', `client_id` tinyint(4) NOT NULL default '0', PRIMARY KEY (`template`,`menuid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `jos_templates_menu` -- INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES ('hugo', 0, 0); INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES ('joomla_admin', 0, 1); -- -------------------------------------------------------- -- -- Table structure for table `jos_users` -- DROP TABLE IF EXISTS `jos_users`; CREATE TABLE `jos_users` ( `id` int(11) NOT NULL auto_increment, `name` varchar(50) NOT NULL default '', `username` varchar(25) NOT NULL default '', `email` varchar(100) NOT NULL default '', `password` varchar(100) NOT NULL default '', `usertype` varchar(25) NOT NULL default '', `block` tinyint(4) NOT NULL default '0', `sendEmail` tinyint(4) default '0', `gid` tinyint(3) unsigned NOT NULL default '1', `registerDate` datetime NOT NULL default '0000-00-00 00:00:00', `lastvisitDate` datetime NOT NULL default '0000-00-00 00:00:00', `activation` varchar(100) NOT NULL default '', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `usertype` (`usertype`), KEY `idx_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ; -- -- Dumping data for table `jos_users` -- INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES (62, 'Administrator', 'admin', 'admin@sandner.com.pl', 'f5c3dd7514bf620a1b85450d2ae374b1', 'Super Administrator', 0, 1, 25, '2007-09-23 16:19:04', '2007-10-14 16:48:30', '', 'expired=\nexpired_time='); -- -------------------------------------------------------- -- -- Table structure for table `jos_usertypes` -- DROP TABLE IF EXISTS `jos_usertypes`; CREATE TABLE `jos_usertypes` ( `id` tinyint(3) unsigned NOT NULL default '0', `name` varchar(50) NOT NULL default '', `mask` varchar(11) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `jos_usertypes` -- INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (0, 'superadministrator', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (1, 'administrator', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (2, 'editor', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (3, 'user', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (4, 'author', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (5, 'publisher', ''); INSERT INTO `jos_usertypes` (`id`, `name`, `mask`) VALUES (6, 'manager', ''); -- -------------------------------------------------------- -- -- Table structure for table `jos_weblinks` -- DROP TABLE IF EXISTS `jos_weblinks`; CREATE TABLE `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 '', `url` varchar(250) NOT NULL default '', `description` varchar(250) NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `archived` tinyint(1) NOT NULL default '0', `approved` tinyint(1) NOT NULL default '1', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`,`archived`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `jos_weblinks` -- INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (1, 2, 0, 'Joomla!', 'http://www.joomla.org', 'Home of Joomla!', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'); INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (2, 2, 0, 'php.net', 'http://www.php.net', 'The language that Joomla! is developed in', '2004-07-07 11:33:24', 0, 1, 0, '0000-00-00 00:00:00', 3, 0, 1, ''); INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (3, 2, 0, 'MySQL', 'http://www.mysql.com', 'The database that Joomla! uses', '2004-07-07 10:18:31', 0, 1, 0, '0000-00-00 00:00:00', 5, 0, 1, ''); INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (4, 2, 0, 'OpenSourceMatters', 'http://www.opensourcematters.org', 'Home of OSM', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0'); INSERT INTO `jos_weblinks` (`id`, `catid`, `sid`, `title`, `url`, `description`, `date`, `hits`, `published`, `checked_out`, `checked_out_time`, `ordering`, `archived`, `approved`, `params`) VALUES (5, 2, 0, 'Joomla! - Forums', 'http://forum.joomla.org', 'Joomla! Forums', '2005-02-14 15:19:02', 2, 1, 0, '0000-00-00 00:00:00', 1, 0, 1, 'target=0');