-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 03, 2011 at 03:11 AM
-- Server version: 5.1.41
-- PHP Version: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `joomla`
--

-- --------------------------------------------------------

--
-- Table structure for table `jos_banner`
--

CREATE TABLE IF NOT EXISTS `jos_banner` (
  `bid` int(11) NOT NULL AUTO_INCREMENT,
  `cid` int(11) NOT NULL DEFAULT '0',
  `type` varchar(30) NOT NULL DEFAULT 'banner',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `imptotal` int(11) NOT NULL DEFAULT '0',
  `impmade` int(11) NOT NULL DEFAULT '0',
  `clicks` int(11) NOT NULL DEFAULT '0',
  `imageurl` varchar(100) NOT NULL DEFAULT '',
  `clickurl` varchar(200) NOT NULL DEFAULT '',
  `date` datetime DEFAULT NULL,
  `showBanner` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `custombannercode` text,
  `catid` int(10) unsigned NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `tags` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`bid`),
  KEY `viewbanner` (`showBanner`),
  KEY `idx_banner_catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_banner`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_bannerclient`
--

CREATE TABLE IF NOT EXISTS `jos_bannerclient` (
  `cid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `contact` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `extrainfo` text NOT NULL,
  `checked_out` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out_time` time DEFAULT NULL,
  `editor` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_bannerclient`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_bannertrack`
--

CREATE TABLE IF NOT EXISTS `jos_bannertrack` (
  `track_date` date NOT NULL,
  `track_type` int(10) unsigned NOT NULL,
  `banner_id` int(10) unsigned NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_bannertrack`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_categories`
--

CREATE TABLE IF NOT EXISTS `jos_categories` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` varchar(255) NOT NULL DEFAULT '',
  `section` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `editor` varchar(50) DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cat_idx` (`section`,`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_categories`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_components`
--

CREATE TABLE IF NOT EXISTS `jos_components` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `link` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) unsigned NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `admin_menu_link` varchar(255) NOT NULL DEFAULT '',
  `admin_menu_alt` varchar(255) NOT NULL DEFAULT '',
  `option` varchar(50) NOT NULL DEFAULT '',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `admin_menu_img` varchar(255) NOT NULL DEFAULT '',
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `enabled` tinyint(4) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `parent_option` (`parent`,`option`(32))
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=35 ;

--
-- Dumping data for table `jos_components`
--

UPDATE `jos_components` SET `id` = 1,`name` = 'Banners',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Banner Management',`option` = 'com_banners',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 0,`params` = 'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 1;
UPDATE `jos_components` SET `id` = 2,`name` = 'Banners',`link` = '',`menuid` = 0,`parent` = 1,`admin_menu_link` = 'option=com_banners',`admin_menu_alt` = 'Active Banners',`option` = 'com_banners',`ordering` = 1,`admin_menu_img` = 'js/ThemeOffice/edit.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 2;
UPDATE `jos_components` SET `id` = 3,`name` = 'Clients',`link` = '',`menuid` = 0,`parent` = 1,`admin_menu_link` = 'option=com_banners&c=client',`admin_menu_alt` = 'Manage Clients',`option` = 'com_banners',`ordering` = 2,`admin_menu_img` = 'js/ThemeOffice/categories.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 3;
UPDATE `jos_components` SET `id` = 4,`name` = 'Web Links',`link` = 'option=com_weblinks',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Manage Weblinks',`option` = 'com_weblinks',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 0,`params` = 'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 4;
UPDATE `jos_components` SET `id` = 5,`name` = 'Links',`link` = '',`menuid` = 0,`parent` = 4,`admin_menu_link` = 'option=com_weblinks',`admin_menu_alt` = 'View existing weblinks',`option` = 'com_weblinks',`ordering` = 1,`admin_menu_img` = 'js/ThemeOffice/edit.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 5;
UPDATE `jos_components` SET `id` = 6,`name` = 'Categories',`link` = '',`menuid` = 0,`parent` = 4,`admin_menu_link` = 'option=com_categories&section=com_weblinks',`admin_menu_alt` = 'Manage weblink categories',`option` = '',`ordering` = 2,`admin_menu_img` = 'js/ThemeOffice/categories.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 6;
UPDATE `jos_components` SET `id` = 7,`name` = 'Contacts',`link` = 'option=com_contact',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Edit contact details',`option` = 'com_contact',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 1,`params` = 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 7;
UPDATE `jos_components` SET `id` = 8,`name` = 'Contacts',`link` = '',`menuid` = 0,`parent` = 7,`admin_menu_link` = 'option=com_contact',`admin_menu_alt` = 'Edit contact details',`option` = 'com_contact',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/edit.png',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 8;
UPDATE `jos_components` SET `id` = 9,`name` = 'Categories',`link` = '',`menuid` = 0,`parent` = 7,`admin_menu_link` = 'option=com_categories&section=com_contact_details',`admin_menu_alt` = 'Manage contact categories',`option` = '',`ordering` = 2,`admin_menu_img` = 'js/ThemeOffice/categories.png',`iscore` = 1,`params` = 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 9;
UPDATE `jos_components` SET `id` = 10,`name` = 'Polls',`link` = 'option=com_poll',`menuid` = 0,`parent` = 0,`admin_menu_link` = 'option=com_poll',`admin_menu_alt` = 'Manage Polls',`option` = 'com_poll',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 10;
UPDATE `jos_components` SET `id` = 11,`name` = 'News Feeds',`link` = 'option=com_newsfeeds',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'News Feeds Management',`option` = 'com_newsfeeds',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 11;
UPDATE `jos_components` SET `id` = 12,`name` = 'Feeds',`link` = '',`menuid` = 0,`parent` = 11,`admin_menu_link` = 'option=com_newsfeeds',`admin_menu_alt` = 'Manage News Feeds',`option` = 'com_newsfeeds',`ordering` = 1,`admin_menu_img` = 'js/ThemeOffice/edit.png',`iscore` = 0,`params` = 'show_headings=1\nshow_name=1\nshow_articles=1\nshow_link=1\nshow_cat_description=1\nshow_cat_items=1\nshow_feed_image=1\nshow_feed_description=1\nshow_item_description=1\nfeed_word_count=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 12;
UPDATE `jos_components` SET `id` = 13,`name` = 'Categories',`link` = '',`menuid` = 0,`parent` = 11,`admin_menu_link` = 'option=com_categories&section=com_newsfeeds',`admin_menu_alt` = 'Manage Categories',`option` = '',`ordering` = 2,`admin_menu_img` = 'js/ThemeOffice/categories.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 13;
UPDATE `jos_components` SET `id` = 14,`name` = 'User',`link` = 'option=com_user',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = '',`option` = 'com_user',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 14;
UPDATE `jos_components` SET `id` = 15,`name` = 'Search',`link` = 'option=com_search',`menuid` = 0,`parent` = 0,`admin_menu_link` = 'option=com_search',`admin_menu_alt` = 'Search Statistics',`option` = 'com_search',`ordering` = 0,`admin_menu_img` = 'js/ThemeOffice/component.png',`iscore` = 1,`params` = 'enabled=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 15;
UPDATE `jos_components` SET `id` = 16,`name` = 'Categories',`link` = '',`menuid` = 0,`parent` = 1,`admin_menu_link` = 'option=com_categories&section=com_banner',`admin_menu_alt` = 'Categories',`option` = '',`ordering` = 3,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 16;
UPDATE `jos_components` SET `id` = 17,`name` = 'Wrapper',`link` = 'option=com_wrapper',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Wrapper',`option` = 'com_wrapper',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 17;
UPDATE `jos_components` SET `id` = 18,`name` = 'Mail To',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = '',`option` = 'com_mailto',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 18;
UPDATE `jos_components` SET `id` = 19,`name` = 'Media Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = 'option=com_media',`admin_menu_alt` = 'Media Manager',`option` = 'com_media',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = 'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\nallowed_media_usergroup=3\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\nenable_flash=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 19;
UPDATE `jos_components` SET `id` = 20,`name` = 'Articles',`link` = 'option=com_content',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = '',`option` = 'com_content',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = 'show_noauth=0\nshow_title=1\nlink_titles=0\nshow_intro=1\nshow_section=0\nlink_section=0\nshow_category=0\nlink_category=0\nshow_author=1\nshow_create_date=1\nshow_modify_date=1\nshow_item_navigation=0\nshow_readmore=1\nshow_vote=0\nshow_icons=1\nshow_pdf_icon=1\nshow_print_icon=1\nshow_email_icon=1\nshow_hits=1\nfeed_summary=0\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 20;
UPDATE `jos_components` SET `id` = 21,`name` = 'Configuration Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Configuration',`option` = 'com_config',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 21;
UPDATE `jos_components` SET `id` = 22,`name` = 'Installation Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Installer',`option` = 'com_installer',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 22;
UPDATE `jos_components` SET `id` = 23,`name` = 'Language Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Languages',`option` = 'com_languages',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = 'site=el-GR\nadministrator=en-GB\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 23;
UPDATE `jos_components` SET `id` = 24,`name` = 'Mass mail',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Mass Mail',`option` = 'com_massmail',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = 'mailSubjectPrefix=\nmailBodySuffix=\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 24;
UPDATE `jos_components` SET `id` = 25,`name` = 'Menu Editor',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Menu Editor',`option` = 'com_menus',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 25;
UPDATE `jos_components` SET `id` = 27,`name` = 'Messaging',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Messages',`option` = 'com_messages',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 27;
UPDATE `jos_components` SET `id` = 28,`name` = 'Modules Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Modules',`option` = 'com_modules',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 28;
UPDATE `jos_components` SET `id` = 29,`name` = 'Plugin Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Plugins',`option` = 'com_plugins',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 29;
UPDATE `jos_components` SET `id` = 30,`name` = 'Template Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Templates',`option` = 'com_templates',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 30;
UPDATE `jos_components` SET `id` = 31,`name` = 'User Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Users',`option` = 'com_users',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = 'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n',`enabled` = 1 WHERE `jos_components`.`id` = 31;
UPDATE `jos_components` SET `id` = 32,`name` = 'Cache Manager',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Cache',`option` = 'com_cache',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 32;
UPDATE `jos_components` SET `id` = 33,`name` = 'Control Panel',`link` = '',`menuid` = 0,`parent` = 0,`admin_menu_link` = '',`admin_menu_alt` = 'Control Panel',`option` = 'com_cpanel',`ordering` = 0,`admin_menu_img` = '',`iscore` = 1,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 33;
UPDATE `jos_components` SET `id` = 34,`name` = 'Jumi',`link` = 'option=com_jumi',`menuid` = 0,`parent` = 0,`admin_menu_link` = 'option=com_jumi',`admin_menu_alt` = 'Jumi',`option` = 'com_jumi',`ordering` = 0,`admin_menu_img` = 'components/com_jumi/images/jumi.png',`iscore` = 0,`params` = '',`enabled` = 1 WHERE `jos_components`.`id` = 34;

-- --------------------------------------------------------

--
-- Table structure for table `jos_contact_details`
--

CREATE TABLE IF NOT EXISTS `jos_contact_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `con_position` varchar(255) DEFAULT NULL,
  `address` text,
  `suburb` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `postcode` varchar(100) DEFAULT NULL,
  `telephone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `misc` mediumtext,
  `image` varchar(255) DEFAULT NULL,
  `imagepos` varchar(20) DEFAULT NULL,
  `email_to` varchar(255) DEFAULT NULL,
  `default_con` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `published` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `user_id` int(11) NOT NULL DEFAULT '0',
  `catid` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mobile` varchar(255) NOT NULL DEFAULT '',
  `webpage` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_contact_details`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_content`
--

CREATE TABLE IF NOT EXISTS `jos_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `title_alias` varchar(255) NOT NULL DEFAULT '',
  `introtext` mediumtext NOT NULL,
  `fulltext` mediumtext NOT NULL,
  `state` tinyint(3) NOT NULL DEFAULT '0',
  `sectionid` int(11) unsigned NOT NULL DEFAULT '0',
  `mask` int(11) unsigned NOT NULL DEFAULT '0',
  `catid` int(11) unsigned NOT NULL DEFAULT '0',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int(11) unsigned NOT NULL DEFAULT '0',
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `attribs` text NOT NULL,
  `version` int(11) unsigned NOT NULL DEFAULT '1',
  `parentid` int(11) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `metakey` text NOT NULL,
  `metadesc` text NOT NULL,
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0',
  `metadata` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_section` (`sectionid`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `jos_content`
--

UPDATE `jos_content` SET `id` = 1,`title` = 'Ατομικά Στοιχεία Εκπαιδευτικού',`alias` = 'educatorview',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/example.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 15:35:36',`created_by` = 62,`created_by_alias` = '',`modified` = '2011-05-02 23:02:49',`modified_by` = 62,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 15:35:36',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 7,`parentid` = 0,`ordering` = 7,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 141,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 1;
UPDATE `jos_content` SET `id` = 2,`title` = 'Σπουδές Εκπαιδευτικού',`alias` = '2011-05-02-22-59-49',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/degree.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 22:57:42',`created_by` = 62,`created_by_alias` = '',`modified` = '2011-05-02 23:10:30',`modified_by` = 62,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 22:57:42',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 3,`parentid` = 0,`ordering` = 6,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 43,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 2;
UPDATE `jos_content` SET `id` = 3,`title` = 'Ξένες Γλώσσες Εκπαιδευτικού',`alias` = '2011-05-02-23-16-22',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/language.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 23:15:17',`created_by` = 62,`created_by_alias` = '',`modified` = '2011-05-02 23:17:41',`modified_by` = 62,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 23:15:17',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 2,`parentid` = 0,`ordering` = 5,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 20,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 3;
UPDATE `jos_content` SET `id` = 4,`title` = 'Επαγγελματική Εμπειρία Εκπαιδευτικού',`alias` = '2011-05-02-23-21-59',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/proExperience.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 23:20:45',`created_by` = 62,`created_by_alias` = '',`modified` = '0000-00-00 00:00:00',`modified_by` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 23:20:45',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 1,`parentid` = 0,`ordering` = 4,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 11,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 4;
UPDATE `jos_content` SET `id` = 5,`title` = 'Εκπαιδευτική Εμπειρία Εκπαιδευτικού',`alias` = '2011-05-02-23-23-16',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/eduExperience.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 23:22:13',`created_by` = 62,`created_by_alias` = '',`modified` = '0000-00-00 00:00:00',`modified_by` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 23:22:13',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 1,`parentid` = 0,`ordering` = 3,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 11,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 5;
UPDATE `jos_content` SET `id` = 6,`title` = 'Ώρες Απασχόλησης Εκπαιδευτικού',`alias` = '2011-05-02-23-24-12',`title_alias` = '',`introtext` = '<p>{jumi [externalpages/availableHours.php]}</p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 23:23:24',`created_by` = 62,`created_by_alias` = '',`modified` = '0000-00-00 00:00:00',`modified_by` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 23:23:24',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 1,`parentid` = 0,`ordering` = 2,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 6,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 6;
UPDATE `jos_content` SET `id` = 7,`title` = 'Σύστημα Διαχείρισης Αιτήσεων',`alias` = '2011-05-02-23-35-41',`title_alias` = '',`introtext` = '<p><img src="images/stories/ums_image.jpg" border="0" /></p>',`fulltext` = '',`state` = 1,`sectionid` = 0,`mask` = 0,`catid` = 0,`created` = '2011-05-02 23:33:01',`created_by` = 62,`created_by_alias` = '',`modified` = '2011-05-02 23:37:18',`modified_by` = 62,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`publish_up` = '2011-05-02 23:33:01',`publish_down` = '0000-00-00 00:00:00',`images` = '',`urls` = '',`attribs` = 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=',`version` = 4,`parentid` = 0,`ordering` = 1,`metakey` = '',`metadesc` = '',`access` = 0,`hits` = 0,`metadata` = 'robots=\nauthor=' WHERE `jos_content`.`id` = 7;

-- --------------------------------------------------------

--
-- Table structure for table `jos_content_frontpage`
--

CREATE TABLE IF NOT EXISTS `jos_content_frontpage` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content_frontpage`
--

UPDATE `jos_content_frontpage` SET `content_id` = 7,`ordering` = 1 WHERE `jos_content_frontpage`.`content_id` = 7;

-- --------------------------------------------------------

--
-- Table structure for table `jos_content_rating`
--

CREATE TABLE IF NOT EXISTS `jos_content_rating` (
  `content_id` int(11) NOT NULL DEFAULT '0',
  `rating_sum` int(11) unsigned NOT NULL DEFAULT '0',
  `rating_count` int(11) unsigned NOT NULL DEFAULT '0',
  `lastip` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`content_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_content_rating`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_core_acl_aro`
--

CREATE TABLE IF NOT EXISTS `jos_core_acl_aro` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `section_value` varchar(240) NOT NULL DEFAULT '0',
  `value` varchar(240) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_section_value_value_aro` (`section_value`(100),`value`(100)),
  KEY `jos_gacl_hidden_aro` (`hidden`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

--
-- Dumping data for table `jos_core_acl_aro`
--

UPDATE `jos_core_acl_aro` SET `id` = 10,`section_value` = 'users',`value` = '62',`order_value` = 0,`name` = 'Administrator',`hidden` = 0 WHERE `jos_core_acl_aro`.`id` = 10;
UPDATE `jos_core_acl_aro` SET `id` = 11,`section_value` = 'users',`value` = '63',`order_value` = 0,`name` = 'Dimitris',`hidden` = 0 WHERE `jos_core_acl_aro`.`id` = 11;
UPDATE `jos_core_acl_aro` SET `id` = 13,`section_value` = 'users',`value` = '65',`order_value` = 0,`name` = 'George',`hidden` = 0 WHERE `jos_core_acl_aro`.`id` = 13;
UPDATE `jos_core_acl_aro` SET `id` = 14,`section_value` = 'users',`value` = '66',`order_value` = 0,`name` = 'Γεώργιος',`hidden` = 0 WHERE `jos_core_acl_aro`.`id` = 14;

-- --------------------------------------------------------

--
-- Table structure for table `jos_core_acl_aro_groups`
--

CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT '0',
  `name` varchar(255) NOT NULL DEFAULT '',
  `lft` int(11) NOT NULL DEFAULT '0',
  `rgt` int(11) NOT NULL DEFAULT '0',
  `value` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `jos_gacl_parent_id_aro_groups` (`parent_id`),
  KEY `jos_gacl_lft_rgt_aro_groups` (`lft`,`rgt`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=31 ;

--
-- Dumping data for table `jos_core_acl_aro_groups`
--

UPDATE `jos_core_acl_aro_groups` SET `id` = 17,`parent_id` = 0,`name` = 'ROOT',`lft` = 1,`rgt` = 22,`value` = 'ROOT' WHERE `jos_core_acl_aro_groups`.`id` = 17;
UPDATE `jos_core_acl_aro_groups` SET `id` = 28,`parent_id` = 17,`name` = 'USERS',`lft` = 2,`rgt` = 21,`value` = 'USERS' WHERE `jos_core_acl_aro_groups`.`id` = 28;
UPDATE `jos_core_acl_aro_groups` SET `id` = 29,`parent_id` = 28,`name` = 'Public Frontend',`lft` = 3,`rgt` = 12,`value` = 'Public Frontend' WHERE `jos_core_acl_aro_groups`.`id` = 29;
UPDATE `jos_core_acl_aro_groups` SET `id` = 18,`parent_id` = 29,`name` = 'Registered',`lft` = 4,`rgt` = 11,`value` = 'Registered' WHERE `jos_core_acl_aro_groups`.`id` = 18;
UPDATE `jos_core_acl_aro_groups` SET `id` = 19,`parent_id` = 18,`name` = 'Author',`lft` = 5,`rgt` = 10,`value` = 'Author' WHERE `jos_core_acl_aro_groups`.`id` = 19;
UPDATE `jos_core_acl_aro_groups` SET `id` = 20,`parent_id` = 19,`name` = 'Editor',`lft` = 6,`rgt` = 9,`value` = 'Editor' WHERE `jos_core_acl_aro_groups`.`id` = 20;
UPDATE `jos_core_acl_aro_groups` SET `id` = 21,`parent_id` = 20,`name` = 'Publisher',`lft` = 7,`rgt` = 8,`value` = 'Publisher' WHERE `jos_core_acl_aro_groups`.`id` = 21;
UPDATE `jos_core_acl_aro_groups` SET `id` = 30,`parent_id` = 28,`name` = 'Public Backend',`lft` = 13,`rgt` = 20,`value` = 'Public Backend' WHERE `jos_core_acl_aro_groups`.`id` = 30;
UPDATE `jos_core_acl_aro_groups` SET `id` = 23,`parent_id` = 30,`name` = 'Manager',`lft` = 14,`rgt` = 19,`value` = 'Manager' WHERE `jos_core_acl_aro_groups`.`id` = 23;
UPDATE `jos_core_acl_aro_groups` SET `id` = 24,`parent_id` = 23,`name` = 'Administrator',`lft` = 15,`rgt` = 18,`value` = 'Administrator' WHERE `jos_core_acl_aro_groups`.`id` = 24;
UPDATE `jos_core_acl_aro_groups` SET `id` = 25,`parent_id` = 24,`name` = 'Super Administrator',`lft` = 16,`rgt` = 17,`value` = 'Super Administrator' WHERE `jos_core_acl_aro_groups`.`id` = 25;

-- --------------------------------------------------------

--
-- Table structure for table `jos_core_acl_aro_map`
--

CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_map` (
  `acl_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(230) NOT NULL DEFAULT '0',
  `value` varchar(100) NOT NULL,
  PRIMARY KEY (`acl_id`,`section_value`,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_aro_map`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_core_acl_aro_sections`
--

CREATE TABLE IF NOT EXISTS `jos_core_acl_aro_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(230) NOT NULL DEFAULT '',
  `order_value` int(11) NOT NULL DEFAULT '0',
  `name` varchar(230) NOT NULL DEFAULT '',
  `hidden` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `jos_gacl_value_aro_sections` (`value`),
  KEY `jos_gacl_hidden_aro_sections` (`hidden`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=11 ;

--
-- Dumping data for table `jos_core_acl_aro_sections`
--

UPDATE `jos_core_acl_aro_sections` SET `id` = 10,`value` = 'users',`order_value` = 1,`name` = 'Users',`hidden` = 0 WHERE `jos_core_acl_aro_sections`.`id` = 10;

-- --------------------------------------------------------

--
-- Table structure for table `jos_core_acl_groups_aro_map`
--

CREATE TABLE IF NOT EXISTS `jos_core_acl_groups_aro_map` (
  `group_id` int(11) NOT NULL DEFAULT '0',
  `section_value` varchar(240) NOT NULL DEFAULT '',
  `aro_id` int(11) NOT NULL DEFAULT '0',
  UNIQUE KEY `group_id_aro_id_groups_aro_map` (`group_id`,`section_value`,`aro_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_acl_groups_aro_map`
--

UPDATE `jos_core_acl_groups_aro_map` SET `group_id` = 18,`section_value` = '',`aro_id` = 11 WHERE `jos_core_acl_groups_aro_map`.`group_id` = 18 AND `jos_core_acl_groups_aro_map`.`section_value` = '' AND `jos_core_acl_groups_aro_map`.`aro_id` = 11;
UPDATE `jos_core_acl_groups_aro_map` SET `group_id` = 18,`section_value` = '',`aro_id` = 13 WHERE `jos_core_acl_groups_aro_map`.`group_id` = 18 AND `jos_core_acl_groups_aro_map`.`section_value` = '' AND `jos_core_acl_groups_aro_map`.`aro_id` = 13;
UPDATE `jos_core_acl_groups_aro_map` SET `group_id` = 18,`section_value` = '',`aro_id` = 14 WHERE `jos_core_acl_groups_aro_map`.`group_id` = 18 AND `jos_core_acl_groups_aro_map`.`section_value` = '' AND `jos_core_acl_groups_aro_map`.`aro_id` = 14;
UPDATE `jos_core_acl_groups_aro_map` SET `group_id` = 25,`section_value` = '',`aro_id` = 10 WHERE `jos_core_acl_groups_aro_map`.`group_id` = 25 AND `jos_core_acl_groups_aro_map`.`section_value` = '' AND `jos_core_acl_groups_aro_map`.`aro_id` = 10;

-- --------------------------------------------------------

--
-- Table structure for table `jos_core_log_items`
--

CREATE TABLE IF NOT EXISTS `jos_core_log_items` (
  `time_stamp` date NOT NULL DEFAULT '0000-00-00',
  `item_table` varchar(50) NOT NULL DEFAULT '',
  `item_id` int(11) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_items`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_core_log_searches`
--

CREATE TABLE IF NOT EXISTS `jos_core_log_searches` (
  `search_term` varchar(128) NOT NULL DEFAULT '',
  `hits` int(11) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_core_log_searches`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_groups`
--

CREATE TABLE IF NOT EXISTS `jos_groups` (
  `id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `name` varchar(50) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_groups`
--

UPDATE `jos_groups` SET `id` = 0,`name` = 'Public' WHERE `jos_groups`.`id` = 0;
UPDATE `jos_groups` SET `id` = 1,`name` = 'Registered' WHERE `jos_groups`.`id` = 1;
UPDATE `jos_groups` SET `id` = 2,`name` = 'Special' WHERE `jos_groups`.`id` = 2;

-- --------------------------------------------------------

--
-- Table structure for table `jos_jumi`
--

CREATE TABLE IF NOT EXISTS `jos_jumi` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  `custom_script` text,
  `access` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `published` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `jos_jumi`
--

UPDATE `jos_jumi` SET `id` = 1,`title` = 'Hello Jumi!',`alias` = 'hello-jumi',`path` = '',`custom_script` = '<!-- Jumi intro including some php code (sitename, username) - see below. -->\r\n\r\n<?php\r\nfunction sitename() { //gets sitename\r\n $config = new JConfig();\r\n return $config->sitename;\r\n}\r\n$user =& JFactory::getUser(); //gets user object\r\n?>\r\n\r\n<h3>Hello in the world of Jumi!</h3>\r\n<p>Jumi is a set of Joomla! extensions enabling to include custom codes (html, php, css, js, ...) into Joomla!</p>\r\n<ul>\r\n<li>Jumi <b>module</b> includes codes into Joomla! module positions,</li>\r\n<li>Jumi <b>plugin</b> includes codes into Joomla! articles,</li>\r\n<li>Jumi <b>component</b> creates separate Joomla! components from custom codes.</li>\r\n</ul>\r\n<p>We hope Jumi will be useful for your <strong><?php echo sitename(); ?></strong> site. As it is for more then 100.000 other webmasters and developers.<p>\r\n<h4>Jumi resources</h4>\r\n<p>You can also visit following resources for Jumi native extensions for Joomla! 1.0.x and 1.5.x:</p>\r\n<ul>\r\n<li><a href="http://edo.webmaster.am/jumi" title="Jumi downloads">Jumi downloads</a>,</li>\r\n<li><a href="http://edo.webmaster.am/jumi/concise-guide" title="Concise guide">Jumi concise guide</a>,</li>\r\n<li><a href="http://edo.webmaster.am/jumi/tutorial" title="Jumi Tips, tricks, snippet">Jumi tips, tricks and snippets</a>,</li>\r\n<li>Jumi support can be found at <a href="http://forum.joomla.org/viewforum.php?f=470" title="Jumi support">Joomla! extensions forum</a>,</li>\r\n<li><a href="http://extensions.joomla.org/component/option,com_mtree/task,viewlink/link_id,1023/Itemid,35/" title="Jumi feedbacks and opinions">Jumi feedbacks and opinions</a>.</li>\r\n</ul>\r\n<p>Dear \r\n<?php\r\nif ($user->name == '''')\r\n echo "unknown, not logged, friend";\r\nelse\r\n echo $user->name;\r\n?>\r\n!<br />Have a nice day, weeks, months and years with Jumi!\r\n<br />\r\nWhat next? Try <a href="index.php?option=com_jumi&fileid=2">Joomla!-Jumi blogspot component</a> in your pages now!\r\n</p>',`access` = 0,`checked_out` = 0,`published` = 1 WHERE `jos_jumi`.`id` = 1;
UPDATE `jos_jumi` SET `id` = 2,`title` = 'Blogspot',`alias` = 'blogspot',`path` = 'components/com_jumi/files/blogger.php',`custom_script` = '<?php\r\n//Display joomla-jumi.blogspot.com\r\n//You can change following variables so you can display your own blog.\r\n$blogId = ''1748567850225926498'';\r\n$login = ''joomla-jumi'';\r\n$cacheTime = 86400;\r\n?>',`access` = 0,`checked_out` = 0,`published` = 1 WHERE `jos_jumi`.`id` = 2;

-- --------------------------------------------------------

--
-- Table structure for table `jos_menu`
--

CREATE TABLE IF NOT EXISTS `jos_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text,
  `type` varchar(50) NOT NULL DEFAULT '',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `parent` int(11) unsigned NOT NULL DEFAULT '0',
  `componentid` int(11) unsigned NOT NULL DEFAULT '0',
  `sublevel` int(11) DEFAULT '0',
  `ordering` int(11) DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `pollid` int(11) NOT NULL DEFAULT '0',
  `browserNav` tinyint(4) DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `utaccess` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  `lft` int(11) unsigned NOT NULL DEFAULT '0',
  `rgt` int(11) unsigned NOT NULL DEFAULT '0',
  `home` int(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `componentid` (`componentid`,`menutype`,`published`,`access`),
  KEY `menutype` (`menutype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;

--
-- Dumping data for table `jos_menu`
--

UPDATE `jos_menu` SET `id` = 1,`menutype` = 'mainmenu',`name` = 'Αρχική',`alias` = 'home',`link` = 'index.php?option=com_content&view=frontpage',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 1,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 3,`params` = 'num_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_pri=\norderby_sec=front\nmulti_column_order=1\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\nshow_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 1 WHERE `jos_menu`.`id` = 1;
UPDATE `jos_menu` SET `id` = 2,`menutype` = 'mainmenu',`name` = 'Ατομικά Στοιχεία',`alias` = 'educatorpage',`link` = 'index.php?option=com_content&view=article&id=1',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 2,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 2;
UPDATE `jos_menu` SET `id` = 3,`menutype` = 'mainmenu',`name` = 'Σπουδές',`alias` = '2011-05-02-23-00-36',`link` = 'index.php?option=com_content&view=article&id=2',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 3,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 3;
UPDATE `jos_menu` SET `id` = 4,`menutype` = 'mainmenu',`name` = 'Ξένες Γλώσσες',`alias` = '2011-05-02-23-16-50',`link` = 'index.php?option=com_content&view=article&id=3',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 4,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 4;
UPDATE `jos_menu` SET `id` = 5,`menutype` = 'mainmenu',`name` = 'Επαγγελματική Εμπειρία',`alias` = '2011-05-02-23-24-56',`link` = 'index.php?option=com_content&view=article&id=4',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 5,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 5;
UPDATE `jos_menu` SET `id` = 6,`menutype` = 'mainmenu',`name` = 'Εκπαιδευτική Εμπειρία',`alias` = '2011-05-02-23-25-21',`link` = 'index.php?option=com_content&view=article&id=5',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 6,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 6;
UPDATE `jos_menu` SET `id` = 7,`menutype` = 'mainmenu',`name` = 'Ώρες Απασχόλησης',`alias` = '2011-05-02-23-25-42',`link` = 'index.php?option=com_content&view=article&id=6',`type` = 'component',`published` = 1,`parent` = 0,`componentid` = 20,`sublevel` = 0,`ordering` = 7,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`pollid` = 0,`browserNav` = 0,`access` = 0,`utaccess` = 0,`params` = 'show_noauth=\nshow_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_item_navigation=\nshow_readmore=\nshow_vote=\nshow_icons=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nshow_hits=\nfeed_summary=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n',`lft` = 0,`rgt` = 0,`home` = 0 WHERE `jos_menu`.`id` = 7;

-- --------------------------------------------------------

--
-- Table structure for table `jos_menu_types`
--

CREATE TABLE IF NOT EXISTS `jos_menu_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `menutype` varchar(75) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `menutype` (`menutype`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `jos_menu_types`
--

UPDATE `jos_menu_types` SET `id` = 1,`menutype` = 'mainmenu',`title` = 'Main Menu',`description` = 'The main menu for the site' WHERE `jos_menu_types`.`id` = 1;

-- --------------------------------------------------------

--
-- Table structure for table `jos_messages`
--

CREATE TABLE IF NOT EXISTS `jos_messages` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id_from` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id_to` int(10) unsigned NOT NULL DEFAULT '0',
  `folder_id` int(10) unsigned NOT NULL DEFAULT '0',
  `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `state` int(11) NOT NULL DEFAULT '0',
  `priority` int(1) unsigned NOT NULL DEFAULT '0',
  `subject` text NOT NULL,
  `message` text NOT NULL,
  PRIMARY KEY (`message_id`),
  KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_messages`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_messages_cfg`
--

CREATE TABLE IF NOT EXISTS `jos_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  `cfg_name` varchar(100) NOT NULL DEFAULT '',
  `cfg_value` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_messages_cfg`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_migration_backlinks`
--

CREATE TABLE IF NOT EXISTS `jos_migration_backlinks` (
  `itemid` int(11) NOT NULL,
  `name` varchar(100) NOT NULL,
  `url` text NOT NULL,
  `sefurl` text NOT NULL,
  `newurl` text NOT NULL,
  PRIMARY KEY (`itemid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_migration_backlinks`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_modules`
--

CREATE TABLE IF NOT EXISTS `jos_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` text NOT NULL,
  `content` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT '0',
  `position` varchar(50) DEFAULT NULL,
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `module` varchar(50) DEFAULT NULL,
  `numnews` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  `iscore` tinyint(4) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  `control` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;

--
-- Dumping data for table `jos_modules`
--

UPDATE `jos_modules` SET `id` = 1,`title` = 'Main Menu',`content` = '',`ordering` = 0,`position` = 'left',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_mainmenu',`numnews` = 0,`access` = 0,`showtitle` = 1,`params` = 'menutype=mainmenu\nmenu_style=vert_indent\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=-sidenav\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nmenu_images_link=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n',`iscore` = 1,`client_id` = 0,`control` = '' WHERE `jos_modules`.`id` = 1;
UPDATE `jos_modules` SET `id` = 2,`title` = 'Login',`content` = '',`ordering` = 1,`position` = 'login',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_login',`numnews` = 0,`access` = 0,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 2;
UPDATE `jos_modules` SET `id` = 3,`title` = 'Popular',`content` = '',`ordering` = 3,`position` = 'cpanel',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_popular',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 3;
UPDATE `jos_modules` SET `id` = 4,`title` = 'Recent added Articles',`content` = '',`ordering` = 4,`position` = 'cpanel',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_latest',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = 'ordering=c_dsc\nuser_id=0\ncache=0\n\n',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 4;
UPDATE `jos_modules` SET `id` = 5,`title` = 'Menu Stats',`content` = '',`ordering` = 5,`position` = 'cpanel',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_stats',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 5;
UPDATE `jos_modules` SET `id` = 6,`title` = 'Unread Messages',`content` = '',`ordering` = 1,`position` = 'header',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_unread',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 6;
UPDATE `jos_modules` SET `id` = 7,`title` = 'Online Users',`content` = '',`ordering` = 2,`position` = 'header',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_online',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 7;
UPDATE `jos_modules` SET `id` = 8,`title` = 'Toolbar',`content` = '',`ordering` = 1,`position` = 'toolbar',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_toolbar',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 8;
UPDATE `jos_modules` SET `id` = 9,`title` = 'Quick Icons',`content` = '',`ordering` = 1,`position` = 'icon',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_quickicon',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 9;
UPDATE `jos_modules` SET `id` = 10,`title` = 'Logged in Users',`content` = '',`ordering` = 2,`position` = 'cpanel',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_logged',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = 'cache=0\n\n',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 10;
UPDATE `jos_modules` SET `id` = 11,`title` = 'Footer',`content` = '',`ordering` = 0,`position` = 'footer',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_footer',`numnews` = 0,`access` = 0,`showtitle` = 1,`params` = '',`iscore` = 1,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 11;
UPDATE `jos_modules` SET `id` = 12,`title` = 'Admin Menu',`content` = '',`ordering` = 1,`position` = 'menu',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_menu',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 12;
UPDATE `jos_modules` SET `id` = 13,`title` = 'Admin SubMenu',`content` = '',`ordering` = 1,`position` = 'submenu',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_submenu',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 13;
UPDATE `jos_modules` SET `id` = 14,`title` = 'User Status',`content` = '',`ordering` = 1,`position` = 'status',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_status',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 14;
UPDATE `jos_modules` SET `id` = 15,`title` = 'Title',`content` = '',`ordering` = 1,`position` = 'title',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_title',`numnews` = 0,`access` = 2,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 1,`control` = '' WHERE `jos_modules`.`id` = 15;
UPDATE `jos_modules` SET `id` = 16,`title` = 'Σύνδεση',`content` = '',`ordering` = 2,`position` = 'left',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 1,`module` = 'mod_login',`numnews` = 0,`access` = 0,`showtitle` = 1,`params` = 'cache=0\nmoduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\ngreeting=1\nname=0\nusesecure=0\n\n',`iscore` = 0,`client_id` = 0,`control` = '' WHERE `jos_modules`.`id` = 16;
UPDATE `jos_modules` SET `id` = 17,`title` = 'Jumi',`content` = '',`ordering` = 3,`position` = 'left',`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`published` = 0,`module` = 'mod_jumi',`numnews` = 0,`access` = 0,`showtitle` = 1,`params` = '',`iscore` = 0,`client_id` = 0,`control` = '' WHERE `jos_modules`.`id` = 17;

-- --------------------------------------------------------

--
-- Table structure for table `jos_modules_menu`
--

CREATE TABLE IF NOT EXISTS `jos_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_modules_menu`
--

UPDATE `jos_modules_menu` SET `moduleid` = 1,`menuid` = 0 WHERE `jos_modules_menu`.`moduleid` = 1 AND `jos_modules_menu`.`menuid` = 0;
UPDATE `jos_modules_menu` SET `moduleid` = 16,`menuid` = 0 WHERE `jos_modules_menu`.`moduleid` = 16 AND `jos_modules_menu`.`menuid` = 0;
UPDATE `jos_modules_menu` SET `moduleid` = 17,`menuid` = 0 WHERE `jos_modules_menu`.`moduleid` = 17 AND `jos_modules_menu`.`menuid` = 0;

-- --------------------------------------------------------

--
-- Table structure for table `jos_newsfeeds`
--

CREATE TABLE IF NOT EXISTS `jos_newsfeeds` (
  `catid` int(11) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `alias` varchar(255) NOT NULL DEFAULT '',
  `link` text NOT NULL,
  `filename` varchar(200) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `numarticles` int(11) unsigned NOT NULL DEFAULT '1',
  `cache_time` int(11) unsigned NOT NULL DEFAULT '3600',
  `checked_out` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `rtl` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `published` (`published`),
  KEY `catid` (`catid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_newsfeeds`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_plugins`
--

CREATE TABLE IF NOT EXISTS `jos_plugins` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `element` varchar(100) NOT NULL DEFAULT '',
  `folder` varchar(100) NOT NULL DEFAULT '',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(3) NOT NULL DEFAULT '0',
  `iscore` tinyint(3) NOT NULL DEFAULT '0',
  `client_id` tinyint(3) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_folder` (`published`,`client_id`,`access`,`folder`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=37 ;

--
-- Dumping data for table `jos_plugins`
--

UPDATE `jos_plugins` SET `id` = 1,`name` = 'Authentication - Joomla',`element` = 'joomla',`folder` = 'authentication',`access` = 0,`ordering` = 1,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 1;
UPDATE `jos_plugins` SET `id` = 2,`name` = 'Authentication - LDAP',`element` = 'ldap',`folder` = 'authentication',`access` = 0,`ordering` = 2,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'host=\nport=389\nuse_ldapV3=0\nnegotiate_tls=0\nno_referrals=0\nauth_method=bind\nbase_dn=\nsearch_string=\nusers_dn=\nusername=\npassword=\nldap_fullname=fullName\nldap_email=mail\nldap_uid=uid\n\n' WHERE `jos_plugins`.`id` = 2;
UPDATE `jos_plugins` SET `id` = 3,`name` = 'Authentication - GMail',`element` = 'gmail',`folder` = 'authentication',`access` = 0,`ordering` = 4,`published` = 0,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 3;
UPDATE `jos_plugins` SET `id` = 4,`name` = 'Authentication - OpenID',`element` = 'openid',`folder` = 'authentication',`access` = 0,`ordering` = 3,`published` = 0,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 4;
UPDATE `jos_plugins` SET `id` = 5,`name` = 'User - Joomla!',`element` = 'joomla',`folder` = 'user',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'autoregister=1\n\n' WHERE `jos_plugins`.`id` = 5;
UPDATE `jos_plugins` SET `id` = 6,`name` = 'Search - Content',`element` = 'content',`folder` = 'search',`access` = 0,`ordering` = 1,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\nsearch_content=1\nsearch_uncategorised=1\nsearch_archived=1\n\n' WHERE `jos_plugins`.`id` = 6;
UPDATE `jos_plugins` SET `id` = 7,`name` = 'Search - Contacts',`element` = 'contacts',`folder` = 'search',`access` = 0,`ordering` = 3,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\n\n' WHERE `jos_plugins`.`id` = 7;
UPDATE `jos_plugins` SET `id` = 8,`name` = 'Search - Categories',`element` = 'categories',`folder` = 'search',`access` = 0,`ordering` = 4,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\n\n' WHERE `jos_plugins`.`id` = 8;
UPDATE `jos_plugins` SET `id` = 9,`name` = 'Search - Sections',`element` = 'sections',`folder` = 'search',`access` = 0,`ordering` = 5,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\n\n' WHERE `jos_plugins`.`id` = 9;
UPDATE `jos_plugins` SET `id` = 10,`name` = 'Search - Newsfeeds',`element` = 'newsfeeds',`folder` = 'search',`access` = 0,`ordering` = 6,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\n\n' WHERE `jos_plugins`.`id` = 10;
UPDATE `jos_plugins` SET `id` = 11,`name` = 'Search - Weblinks',`element` = 'weblinks',`folder` = 'search',`access` = 0,`ordering` = 2,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'search_limit=50\n\n' WHERE `jos_plugins`.`id` = 11;
UPDATE `jos_plugins` SET `id` = 12,`name` = 'Content - Pagebreak',`element` = 'pagebreak',`folder` = 'content',`access` = 0,`ordering` = 10000,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'enabled=1\ntitle=1\nmultipage_toc=1\nshowall=1\n\n' WHERE `jos_plugins`.`id` = 12;
UPDATE `jos_plugins` SET `id` = 13,`name` = 'Content - Rating',`element` = 'vote',`folder` = 'content',`access` = 0,`ordering` = 4,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 13;
UPDATE `jos_plugins` SET `id` = 14,`name` = 'Content - Email Cloaking',`element` = 'emailcloak',`folder` = 'content',`access` = 0,`ordering` = 5,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'mode=1\n\n' WHERE `jos_plugins`.`id` = 14;
UPDATE `jos_plugins` SET `id` = 15,`name` = 'Content - Code Hightlighter (GeSHi)',`element` = 'geshi',`folder` = 'content',`access` = 0,`ordering` = 5,`published` = 0,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 15;
UPDATE `jos_plugins` SET `id` = 16,`name` = 'Content - Load Module',`element` = 'loadmodule',`folder` = 'content',`access` = 0,`ordering` = 6,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'enabled=1\nstyle=0\n\n' WHERE `jos_plugins`.`id` = 16;
UPDATE `jos_plugins` SET `id` = 17,`name` = 'Content - Page Navigation',`element` = 'pagenavigation',`folder` = 'content',`access` = 0,`ordering` = 2,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'position=1\n\n' WHERE `jos_plugins`.`id` = 17;
UPDATE `jos_plugins` SET `id` = 18,`name` = 'Editor - No Editor',`element` = 'none',`folder` = 'editors',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 18;
UPDATE `jos_plugins` SET `id` = 19,`name` = 'Editor - TinyMCE',`element` = 'tinymce',`folder` = 'editors',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'mode=advanced\nskin=0\ncompressed=0\ncleanup_startup=0\ncleanup_save=2\nentity_encoding=raw\nlang_mode=0\nlang_code=en\ntext_direction=ltr\ncontent_css=1\ncontent_css_custom=\nrelative_urls=1\nnewlines=0\ninvalid_elements=applet\nextended_elements=\ntoolbar=top\ntoolbar_align=left\nhtml_height=550\nhtml_width=750\nelement_path=1\nfonts=1\npaste=1\nsearchreplace=1\ninsertdate=1\nformat_date=%Y-%m-%d\ninserttime=1\nformat_time=%H:%M:%S\ncolors=1\ntable=1\nsmilies=1\nmedia=1\nhr=1\ndirectionality=1\nfullscreen=1\nstyle=1\nlayer=1\nxhtmlxtras=1\nvisualchars=1\nnonbreaking=1\ntemplate=0\nadvimage=1\nadvlink=1\nautosave=1\ncontextmenu=1\ninlinepopups=1\nsafari=1\ncustom_plugin=\ncustom_button=\n\n' WHERE `jos_plugins`.`id` = 19;
UPDATE `jos_plugins` SET `id` = 20,`name` = 'Editor - XStandard Lite 2.0',`element` = 'xstandard',`folder` = 'editors',`access` = 0,`ordering` = 0,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 20;
UPDATE `jos_plugins` SET `id` = 21,`name` = 'Editor Button - Image',`element` = 'image',`folder` = 'editors-xtd',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 21;
UPDATE `jos_plugins` SET `id` = 22,`name` = 'Editor Button - Pagebreak',`element` = 'pagebreak',`folder` = 'editors-xtd',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 22;
UPDATE `jos_plugins` SET `id` = 23,`name` = 'Editor Button - Readmore',`element` = 'readmore',`folder` = 'editors-xtd',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 23;
UPDATE `jos_plugins` SET `id` = 24,`name` = 'XML-RPC - Joomla',`element` = 'joomla',`folder` = 'xmlrpc',`access` = 0,`ordering` = 7,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 24;
UPDATE `jos_plugins` SET `id` = 25,`name` = 'XML-RPC - Blogger API',`element` = 'blogger',`folder` = 'xmlrpc',`access` = 0,`ordering` = 7,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'catid=1\nsectionid=0\n\n' WHERE `jos_plugins`.`id` = 25;
UPDATE `jos_plugins` SET `id` = 27,`name` = 'System - SEF',`element` = 'sef',`folder` = 'system',`access` = 0,`ordering` = 1,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 27;
UPDATE `jos_plugins` SET `id` = 28,`name` = 'System - Debug',`element` = 'debug',`folder` = 'system',`access` = 0,`ordering` = 2,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'queries=1\nmemory=1\nlangauge=1\n\n' WHERE `jos_plugins`.`id` = 28;
UPDATE `jos_plugins` SET `id` = 29,`name` = 'System - Legacy',`element` = 'legacy',`folder` = 'system',`access` = 0,`ordering` = 3,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'route=0\n\n' WHERE `jos_plugins`.`id` = 29;
UPDATE `jos_plugins` SET `id` = 30,`name` = 'System - Cache',`element` = 'cache',`folder` = 'system',`access` = 0,`ordering` = 4,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = 'browsercache=0\ncachetime=15\n\n' WHERE `jos_plugins`.`id` = 30;
UPDATE `jos_plugins` SET `id` = 31,`name` = 'System - Log',`element` = 'log',`folder` = 'system',`access` = 0,`ordering` = 5,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 31;
UPDATE `jos_plugins` SET `id` = 32,`name` = 'System - Remember Me',`element` = 'remember',`folder` = 'system',`access` = 0,`ordering` = 6,`published` = 1,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 32;
UPDATE `jos_plugins` SET `id` = 33,`name` = 'System - Backlink',`element` = 'backlink',`folder` = 'system',`access` = 0,`ordering` = 7,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 33;
UPDATE `jos_plugins` SET `id` = 34,`name` = 'System - Mootools Upgrade',`element` = 'mtupgrade',`folder` = 'system',`access` = 0,`ordering` = 8,`published` = 0,`iscore` = 1,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 34;
UPDATE `jos_plugins` SET `id` = 35,`name` = 'Jumi',`element` = 'jumi',`folder` = 'content',`access` = 0,`ordering` = 0,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 35;
UPDATE `jos_plugins` SET `id` = 36,`name` = 'System - Jumi Router',`element` = 'jumirouter',`folder` = 'system',`access` = 0,`ordering` = 100,`published` = 1,`iscore` = 0,`client_id` = 0,`checked_out` = 0,`checked_out_time` = '0000-00-00 00:00:00',`params` = '' WHERE `jos_plugins`.`id` = 36;

-- --------------------------------------------------------

--
-- Table structure for table `jos_polls`
--

CREATE TABLE IF NOT EXISTS `jos_polls` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `voters` int(9) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `access` int(11) NOT NULL DEFAULT '0',
  `lag` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_polls`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_poll_data`
--

CREATE TABLE IF NOT EXISTS `jos_poll_data` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pollid` int(11) NOT NULL DEFAULT '0',
  `text` text NOT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `pollid` (`pollid`,`text`(1))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_poll_data`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_poll_date`
--

CREATE TABLE IF NOT EXISTS `jos_poll_date` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `vote_id` int(11) NOT NULL DEFAULT '0',
  `poll_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `poll_id` (`poll_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_poll_date`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_poll_menu`
--

CREATE TABLE IF NOT EXISTS `jos_poll_menu` (
  `pollid` int(11) NOT NULL DEFAULT '0',
  `menuid` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pollid`,`menuid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_poll_menu`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_sections`
--

CREATE TABLE IF NOT EXISTS `jos_sections` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `image` text NOT NULL,
  `scope` varchar(50) NOT NULL DEFAULT '',
  `image_position` varchar(30) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `access` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `count` int(11) NOT NULL DEFAULT '0',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_scope` (`scope`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_sections`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_session`
--

CREATE TABLE IF NOT EXISTS `jos_session` (
  `username` varchar(150) DEFAULT '',
  `time` varchar(14) DEFAULT '',
  `session_id` varchar(200) NOT NULL DEFAULT '0',
  `guest` tinyint(4) DEFAULT '1',
  `userid` int(11) DEFAULT '0',
  `usertype` varchar(50) DEFAULT '',
  `gid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `client_id` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `data` longtext,
  PRIMARY KEY (`session_id`(64)),
  KEY `whosonline` (`guest`,`usertype`),
  KEY `userid` (`userid`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_session`
--

UPDATE `jos_session` SET `username` = '',`time` = '1304380772',`session_id` = 'j5633iqgnfkk152184mqpvh3e2',`guest` = 1,`userid` = 0,`usertype` = '',`gid` = 0,`client_id` = 0,`data` = '__default|a:9:{s:15:"session.counter";i:37;s:19:"session.timer.start";i:1304380387;s:18:"session.timer.last";i:1304380770;s:17:"session.timer.now";i:1304380772;s:22:"session.client.browser";s:74:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:67:"D:\\xampp\\htdocs\\temp\\joomla\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:16:"com_mailto.links";a:8:{s:40:"593d38bf571837485aca0117ab34006c1a78736f";O:8:"stdClass":2:{s:4:"link";s:95:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=7:2011-05-02-23-35-41";s:6:"expiry";i:1304380612;}s:40:"45c712c2ca27f7891fd492e75bdafe038b086847";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=2:2011-05-02-22-59-49&Itemid=3";s:6:"expiry";i:1304380764;}s:40:"03f2702abe4abf0e0b6f41e664550f9c07c1d45c";O:8:"stdClass":2:{s:4:"link";s:97:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=1:educatorview&Itemid=2";s:6:"expiry";i:1304380764;}s:40:"c573fdd8aeee95fa0d81a6011626d22821d770fd";O:8:"stdClass":2:{s:4:"link";s:106:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=7%3A2011-05-02-23-35-41&Itemid=1";s:6:"expiry";i:1304380773;}s:40:"939691e1d32449aa242ffc12cf6c553417bd1e24";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=4:2011-05-02-23-21-59&Itemid=5";s:6:"expiry";i:1304380766;}s:40:"ea4f2d642702b4b3dc70605fd9ae582e4414cced";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=3:2011-05-02-23-16-22&Itemid=4";s:6:"expiry";i:1304380765;}s:40:"c75f3d4f6dac86304daebf9ecfedc680a13a1d17";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=5:2011-05-02-23-23-16&Itemid=6";s:6:"expiry";i:1304380766;}s:40:"dc9dd4e5c85cddea59dacfbc12c7cd9afd0ef67f";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=6:2011-05-02-23-24-12&Itemid=7";s:6:"expiry";i:1304380766;}}s:13:"session.token";s:32:"9f62a6587707bb05de3e4bcde6fb0c77";}' WHERE `jos_session`.`session_id` = 'j5633iqgnfkk152184mqpvh3e2';
UPDATE `jos_session` SET `username` = '',`time` = '1304380983',`session_id` = 'gq8g1auntqreao51ujbuhflq75',`guest` = 1,`userid` = 0,`usertype` = '',`gid` = 0,`client_id` = 0,`data` = '__default|a:9:{s:15:"session.counter";i:22;s:19:"session.timer.start";i:1304380904;s:18:"session.timer.last";i:1304380961;s:17:"session.timer.now";i:1304380983;s:22:"session.client.browser";s:74:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0.1) Gecko/20100101 Firefox/4.0.1";s:8:"registry";O:9:"JRegistry":3:{s:17:"_defaultNameSpace";s:7:"session";s:9:"_registry";a:1:{s:7:"session";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:4:"user";O:5:"JUser":19:{s:2:"id";i:0;s:4:"name";N;s:8:"username";N;s:5:"email";N;s:8:"password";N;s:14:"password_clear";s:0:"";s:8:"usertype";N;s:5:"block";N;s:9:"sendEmail";i:0;s:3:"gid";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:3:"aid";i:0;s:5:"guest";i:1;s:7:"_params";O:10:"JParameter":7:{s:4:"_raw";s:0:"";s:4:"_xml";N;s:9:"_elements";a:0:{}s:12:"_elementPath";a:1:{i:0;s:67:"D:\\xampp\\htdocs\\temp\\joomla\\libraries\\joomla\\html\\parameter\\element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:16:"com_mailto.links";a:8:{s:40:"593d38bf571837485aca0117ab34006c1a78736f";O:8:"stdClass":2:{s:4:"link";s:95:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=7:2011-05-02-23-35-41";s:6:"expiry";i:1304380933;}s:40:"45c712c2ca27f7891fd492e75bdafe038b086847";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=2:2011-05-02-22-59-49&Itemid=3";s:6:"expiry";i:1304380983;}s:40:"03f2702abe4abf0e0b6f41e664550f9c07c1d45c";O:8:"stdClass":2:{s:4:"link";s:97:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=1:educatorview&Itemid=2";s:6:"expiry";i:1304380961;}s:40:"ea4f2d642702b4b3dc70605fd9ae582e4414cced";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=3:2011-05-02-23-16-22&Itemid=4";s:6:"expiry";i:1304380959;}s:40:"939691e1d32449aa242ffc12cf6c553417bd1e24";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=4:2011-05-02-23-21-59&Itemid=5";s:6:"expiry";i:1304380959;}s:40:"c75f3d4f6dac86304daebf9ecfedc680a13a1d17";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=5:2011-05-02-23-23-16&Itemid=6";s:6:"expiry";i:1304380959;}s:40:"c573fdd8aeee95fa0d81a6011626d22821d770fd";O:8:"stdClass":2:{s:4:"link";s:106:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=7%3A2011-05-02-23-35-41&Itemid=1";s:6:"expiry";i:1304380961;}s:40:"dc9dd4e5c85cddea59dacfbc12c7cd9afd0ef67f";O:8:"stdClass":2:{s:4:"link";s:104:"http://localhost/temp/joomla/index.php?option=com_content&view=article&id=6:2011-05-02-23-24-12&Itemid=7";s:6:"expiry";i:1304380960;}}s:13:"session.token";s:32:"00d0e26f8d05e1c0d4d53b71fe112a15";}' WHERE `jos_session`.`session_id` = 'gq8g1auntqreao51ujbuhflq75';

-- --------------------------------------------------------

--
-- Table structure for table `jos_stats_agents`
--

CREATE TABLE IF NOT EXISTS `jos_stats_agents` (
  `agent` varchar(255) NOT NULL DEFAULT '',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `hits` int(11) unsigned NOT NULL DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_stats_agents`
--


-- --------------------------------------------------------

--
-- Table structure for table `jos_templates_menu`
--

CREATE TABLE IF NOT EXISTS `jos_templates_menu` (
  `template` varchar(255) NOT NULL DEFAULT '',
  `menuid` int(11) NOT NULL DEFAULT '0',
  `client_id` tinyint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`menuid`,`client_id`,`template`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `jos_templates_menu`
--

UPDATE `jos_templates_menu` SET `template` = 'js_jamba',`menuid` = 0,`client_id` = 0 WHERE `jos_templates_menu`.`template` = 'js_jamba' AND `jos_templates_menu`.`menuid` = 0 AND `jos_templates_menu`.`client_id` = 0;
UPDATE `jos_templates_menu` SET `template` = 'khepri',`menuid` = 0,`client_id` = 1 WHERE `jos_templates_menu`.`template` = 'khepri' AND `jos_templates_menu`.`menuid` = 0 AND `jos_templates_menu`.`client_id` = 1;

-- --------------------------------------------------------

--
-- Table structure for table `jos_users`
--

CREATE TABLE IF NOT EXISTS `jos_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `username` varchar(150) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `usertype` varchar(25) NOT NULL DEFAULT '',
  `block` tinyint(4) NOT NULL DEFAULT '0',
  `sendEmail` tinyint(4) DEFAULT '0',
  `gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `activation` varchar(100) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `surname` varchar(255) DEFAULT NULL,
  `idNumber` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `phoneNumber` varchar(255) DEFAULT NULL,
  `mobileNumber` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `postCode` int(11) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `usertype` (`usertype`),
  KEY `idx_name` (`name`),
  KEY `gid_block` (`gid`,`block`),
  KEY `username` (`username`),
  KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=67 ;

--
-- Dumping data for table `jos_users`
--

UPDATE `jos_users` SET `id` = 62,`name` = 'Administrator',`username` = 'admin',`email` = 'mr.reklos@gmail.com',`password` = 'e61217340b2e43c8ba5c1beb40e79b53:uMl96qxJvCnsLVUuzqGPszUQmVp42KeV',`usertype` = 'Super Administrator',`block` = 0,`sendEmail` = 1,`gid` = 25,`registerDate` = '2011-04-28 15:27:39',`lastvisitDate` = '2011-05-02 23:26:59',`activation` = '',`params` = '',`surname` = NULL,`idNumber` = NULL,`birthday` = NULL,`phoneNumber` = NULL,`mobileNumber` = NULL,`address` = NULL,`postCode` = NULL,`city` = NULL,`status` = NULL WHERE `jos_users`.`id` = 62;
UPDATE `jos_users` SET `id` = 66,`name` = 'Γεώργιος',`username` = 'reklonious',`email` = 'overcloker_@hotmail.com',`password` = '2dd806a8c86399753e62eeaf8f8b5565:yvdqfX3nn4B2k8PhUIISn7WDqwZ23MGo',`usertype` = 'Registered',`block` = 1,`sendEmail` = 0,`gid` = 18,`registerDate` = '2011-05-02 22:33:47',`lastvisitDate` = '0000-00-00 00:00:00',`activation` = '98ef887cc52d1a34e48761e26ea65f5f',`params` = '',`surname` = 'Ρέκλος',`idNumber` = 'X 473287',`birthday` = '1986-08-02',`phoneNumber` = '2321023272',`mobileNumber` = '6997188356',`address` = 'Φιλίπποι 12',`postCode` = 62100,`city` = 'Σέρρες',`status` = NULL WHERE `jos_users`.`id` = 66;

-- --------------------------------------------------------

--
-- Table structure for table `jos_weblinks`
--

CREATE TABLE IF NOT EXISTS `jos_weblinks` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `catid` int(11) NOT NULL DEFAULT '0',
  `sid` int(11) NOT NULL DEFAULT '0',
  `title` varchar(250) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `url` varchar(250) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `hits` int(11) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `archived` tinyint(1) NOT NULL DEFAULT '0',
  `approved` tinyint(1) NOT NULL DEFAULT '1',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `catid` (`catid`,`published`,`archived`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_weblinks`
--


/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;