-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 13, 2008 at 03:22 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `unireg`
--

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

--
-- 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=50 ;

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

INSERT INTO `jos_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES
(1, 0, 'Dokumenty', 'Dokumenty', '', '', 'com_docman', 'left', 'V&scaron;eobecn&aacute; kateg&oacute;ria pre dokumenty', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, ''),
(3, 0, 'Obrázky', 'Obrázky', '', '', 'com_docman', 'left', 'Obr&aacute;zky', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(5, 1, 'Specialne Dokumenty', 'Specialne Dokumenty', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(6, 0, 'Other', 'Other', '', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, 'imagefolders=*2*'),
(7, 0, 'Všeobecná agenda', 'Všeobecná agenda', '', 'paragraf.png', 'com_docman', 'left', '', 1, 62, '2008-03-25 18:24:20', NULL, 1, 1, 0, ''),
(8, 7, 'Zakladateľské...', 'Zakladateľské listiny, ...', '', '', 'com_docman', 'left', 'Zakladateľsk&eacute; listiny k.s., spoločensk&aacute; zmluva, v&yacute;pisy z Obchodn&eacute;ho registra, Živnostensk&yacute; list', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(9, 7, 'Valná hromada', 'Valné zhromaždenia, ...', '', '', 'com_docman', 'left', 'Z&aacute;pisy z valn&yacute;ch zhromažden&iacute;, rozhodnutia spoločn&iacute;kov mimo valn&yacute;ch zhromažden&iacute;, konatelia', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(10, 7, 'Organizačné...', 'Organizačná štruktúra, ...', '', '', 'com_docman', 'left', 'Organizačn&aacute; &scaron;trukt&uacute;ra, organizačn&yacute; poriadok, vn&uacute;torn&eacute; smernice', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(11, 7, 'Porady vedenia', 'Porady vedenia vrátane príloh', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(30, 26, 'F. dodávateľské', 'Faktúry dodávateľské, ...', '', '', 'com_docman', 'left', 'Fakt&uacute;ry dod&aacute;vateľsk&eacute;, kniha do&scaron;l&yacute;ch fakt&uacute;r', 1, 0, '0000-00-00 00:00:00', NULL, 4, 1, 0, ''),
(12, 7, 'Stanoviská, ...', 'Stanoviská, správy, návrhy', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 1, 0, ''),
(13, 7, 'Z. o spolupráci', 'Zmluvy o spolupráci', '', '', 'com_docman', 'left', 'Zmluvy o&nbsp;spolupr&aacute;ci s&nbsp;in&yacute;mi in&scaron;tit&uacute;ciami', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(14, 7, 'Zmluvy s $$', 'Zmluvy s peňažnými ústavmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(17, 7, 'Rokovania', 'Záznamy z rokovaní s klientmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 9, 1, 0, ''),
(16, 7, 'Poistné z.', 'Zmluvy poistné', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(18, 7, 'Spory', 'Právne záležitosti, ...', '', '', 'com_docman', 'left', 'Pr&aacute;vne z&aacute;ležitosti, spisy o&nbsp;v&yacute;znamn&yacute;ch sporoch vr&aacute;tane rozhodnut&iacute; s&uacute;dov a odvolan&iacute;', 1, 0, '0000-00-00 00:00:00', NULL, 10, 1, 0, ''),
(19, 7, 'Malé spory', 'Právne zastupovania, ...', '', '', 'com_docman', 'left', 'Pr&aacute;vne zastupovania, drobn&eacute; pr&aacute;vne spory', 1, 0, '0000-00-00 00:00:00', NULL, 11, 1, 0, ''),
(20, 7, 'Štatistika', 'Štátne štatistické výkazy', '', '', 'com_docman', 'left', '&Scaron;t&aacute;tne &scaron;tatistick&eacute; v&yacute;kazy &ndash; ročn&eacute; aj&nbsp;kr&aacute;tkodob&eacute;', 1, 0, '0000-00-00 00:00:00', NULL, 12, 1, 0, ''),
(21, 7, 'Listy', 'Korešpondencia bežná', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 13, 1, 0, ''),
(22, 7, 'Pošta', 'Knihy došlej a odoslanej pošty', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 14, 1, 0, ''),
(23, 7, 'Z. s dodávateľmi', 'Zmluvy s dodávateľmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 15, 1, 0, ''),
(24, 7, 'Z. s odberateľmi', 'Zmluvy s odberateľmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 16, 1, 0, ''),
(25, 7, 'Kontrola', 'Kontrolné, revízne správy, protokoly', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 17, 1, 0, ''),
(26, 0, 'Účtovníctvo', 'Účtovníctvo', '', 'coins.png', 'com_docman', 'left', 'Ekonomick&yacute; &uacute;sek - &Uacute;čtovn&iacute;ctvo', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(27, 26, 'Osvedčenia', 'Osvedčenia o registrácii k daniam', '', '', 'com_docman', 'left', '', 1, 62, '2008-02-05 16:51:58', NULL, 1, 1, 0, ''),
(28, 26, 'Daňové priznania', 'Daňové priznania ...', '', '', 'com_docman', 'left', 'Daňov&eacute; priznania riadne, dodatočn&eacute;, opravn&eacute;: daň z&nbsp;pr&iacute;jmu pr&aacute;vnick&yacute;ch os&ocirc;b, daň&nbsp;pridanej hodnoty,&nbsp;cestn&aacute; daň,&nbsp;daň z nehnuteľnosti', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(29, 26, 'Podklady k DP', 'Počítačové podklady k DP', '', '', 'com_docman', 'left', 'Poč&iacute;tačov&eacute; podklady k daňov&yacute;m priznaniam', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(31, 26, 'F. odberateľské', 'Faktúry odberateľské, ...', '', '', 'com_docman', 'left', 'Fakt&uacute;ry odberateľsk&eacute;, kniha odoslan&yacute;ch fakt&uacute;r', 1, 0, '0000-00-00 00:00:00', NULL, 5, 1, 0, ''),
(32, 26, 'Pohľadávaky', 'Vymáhanie pohľadávok, ...', '', '', 'com_docman', 'left', 'Vym&aacute;hanie pohľad&aacute;vok, kore&scaron;pondencia s&nbsp;dod&aacute;vateľmi', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(33, 26, 'Pokladnička', 'Pokladničné doklady a kniha', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(34, 26, 'B. výpisy', 'Bankové výpisy z účtov', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(35, 26, 'Interné ...', 'Interné účtovné doklady', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 9, 1, 0, ''),
(36, 26, 'Účtovné závierky', 'Účtovné závierky, ...', '', '', 'com_docman', 'left', 'Uacute;čtovn&eacute; z&aacute;vierky, n&aacute;vrhy na rozdelenie zisku', 1, 0, '0000-00-00 00:00:00', NULL, 10, 1, 0, ''),
(37, 26, 'Tl. zostavy', 'Účtovné tlačové zostavy', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 11, 1, 0, ''),
(38, 26, 'Inventúry', 'Inventúry základných prostriedkov', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 12, 1, 0, ''),
(39, 26, 'Majetok', 'Odhady a oceňovanie majetku, ...', '', '', 'com_docman', 'left', 'Odhady a&nbsp;oceňovanie majetku, s&uacute;pisy a&nbsp;zmeny majetku', 1, 0, '0000-00-00 00:00:00', NULL, 13, 1, 0, ''),
(40, 0, 'Mzdová agenda', 'Mzdová agenda', '', '', 'com_docman', 'left', 'Ekonomický úsek - Mzdová agenda', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(41, 40, 'Mzdové listy', 'Evidenčné a mzdové listy', '', '', 'com_docman', 'left', 'Evidenčné listy zamestnancov, mzdové listy', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(42, 40, 'Výplatné listiny', 'Výplatné listiny, ...', '', '', 'com_docman', 'left', 'Výplatné listiny, vyúčtovanie miezd', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(43, 40, 'Prihlášky do SP,ZP,ÚP', 'Prihlášky a odhlášky do SP, ZP, ÚP', '', '', 'com_docman', 'left', 'Prihl&aacute;&scaron;ky a&nbsp;odhl&aacute;&scaron;ky do soci&aacute;lnej poisťovne, zdravotn&yacute;ch poisťovn&iacute;, &uacute;radu pr&aacute;ce', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(44, 40, 'DDP', 'DDP', '', '', 'com_docman', 'left', 'Doplnkov&eacute; d&ocirc;chodkov&eacute; poistenie', 1, 0, '0000-00-00 00:00:00', NULL, 4, 1, 0, ''),
(45, 40, 'Hlásenia DÚ', 'Hlásenia DÚ o zrazenej dani zo ZČ', '', '', 'com_docman', 'left', 'Hl&aacute;senia daňov&eacute;mu &uacute;radu o&nbsp;zrazenej dani zo z&aacute;vislej činnosti', 1, 62, '2008-02-05 15:27:21', NULL, 5, 1, 0, ''),
(46, 40, 'Výkazy do SP, ZP, ÚP', 'Mesačné výkazy do SP, ZP, ÚP', '', '', 'com_docman', 'left', 'Mesačn&eacute; v&yacute;kazy do soci&aacute;lnej poisťovne, zdravotn&yacute;ch poisťovn&iacute;, &uacute;radu pr&aacute;ce', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(47, 40, 'Dochádzka', 'Evidencia dochádzky, ...', '', '', 'com_docman', 'left', 'Evidencia doch&aacute;dzky, dovolenky', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(48, 40, 'Spisy zamestnancov', 'Osobné spisy zamestnancov', '', '', 'com_docman', 'left', 'Osobn&eacute; spisy zamestnancov, evidenčn&eacute; listy, platov&eacute; v&yacute;mery, žiadosti o&nbsp;prijatie do pracovn&eacute;ho pomeru, v&yacute;stupn&eacute; listy', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(49, 0, 'Default', '', 'default', '', 'com_contact_details', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, '');

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

--
-- 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=58 ;

--
-- 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`, `enabled`) VALUES
(1, 'Banners', '', 0, 0, '', 'Banner Management', 'com_banners', 0, 'js/ThemeOffice/component.png', 0, 'track_impressions=0\ntrack_clicks=0\ntag_prefix=\n\n', 1),
(2, 'Banners', '', 0, 1, 'option=com_banners', 'Active Banners', 'com_banners', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(3, 'Clients', '', 0, 1, 'option=com_banners&c=client', 'Manage Clients', 'com_banners', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(4, 'Web Links', 'option=com_weblinks', 0, 0, '', 'Manage Weblinks', 'com_weblinks', 0, 'js/ThemeOffice/component.png', 0, 'show_comp_description=1\ncomp_description=\nshow_link_hits=1\nshow_link_description=1\nshow_other_cats=1\nshow_headings=1\nshow_page_title=1\nlink_target=0\nlink_icons=\n\n', 1),
(5, 'Links', '', 0, 4, 'option=com_weblinks', 'View existing weblinks', 'com_weblinks', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(6, 'Categories', '', 0, 4, 'option=com_categories&section=com_weblinks', 'Manage weblink categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(7, 'Contacts', 'option=com_contact', 0, 0, '', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/component.png', 1, 'contact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_fax=\nicon_misc=\nshow_headings=1\nshow_position=1\nshow_email=0\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nbannedEmail=\nbannedSubject=\nbannedText=\nsession=1\ncustomReply=0\n\n', 1),
(8, 'Contacts', '', 0, 7, 'option=com_contact', 'Edit contact details', 'com_contact', 0, 'js/ThemeOffice/edit.png', 1, '', 1),
(9, 'Categories', '', 0, 7, 'option=com_categories&section=com_contact_details', 'Manage contact categories', '', 2, 'js/ThemeOffice/categories.png', 1, '', 1),
(10, 'Polls', 'option=com_poll', 0, 0, 'option=com_poll', 'Manage Polls', 'com_poll', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(11, 'News Feeds', 'option=com_newsfeeds', 0, 0, '', 'News Feeds Management', 'com_newsfeeds', 0, 'js/ThemeOffice/component.png', 0, '', 1),
(12, 'Feeds', '', 0, 11, 'option=com_newsfeeds', 'Manage News Feeds', 'com_newsfeeds', 1, 'js/ThemeOffice/edit.png', 0, '', 1),
(13, 'Categories', '', 0, 11, 'option=com_categories&section=com_newsfeeds', 'Manage Categories', '', 2, 'js/ThemeOffice/categories.png', 0, '', 1),
(14, 'User', 'option=com_user', 0, 0, '', '', 'com_user', 0, '', 1, '', 1),
(15, 'Search', 'option=com_search', 0, 0, 'option=com_search', 'Search Statistics', 'com_search', 0, 'js/ThemeOffice/component.png', 1, 'enabled=0\n\n', 1),
(16, 'Categories', '', 0, 1, 'option=com_categories&section=com_banner', 'Categories', '', 3, '', 1, '', 1),
(17, 'Wrapper', 'option=com_wrapper', 0, 0, '', 'Wrapper', 'com_wrapper', 0, '', 1, '', 1),
(18, 'Mail To', '', 0, 0, '', '', 'com_mailto', 0, '', 1, '', 1),
(19, 'Media Manager', '', 0, 0, 'option=com_media', 'Media Manager', 'com_media', 0, '', 1, 'upload_extensions=bmp,csv,doc,epg,gif,ico,jpg,odg,odp,ods,odt,pdf,png,ppt,swf,txt,xcf,xls,BMP,CSV,DOC,EPG,GIF,ICO,JPG,ODG,ODP,ODS,ODT,PDF,PNG,PPT,SWF,TXT,XCF,XLS\nupload_maxsize=10000000\nfile_path=images\nimage_path=images/stories\nrestrict_uploads=1\ncheck_mime=1\nimage_extensions=bmp,gif,jpg,png\nignore_extensions=\nupload_mime=image/jpeg,image/gif,image/png,image/bmp,application/x-shockwave-flash,application/msword,application/excel,application/pdf,application/powerpoint,text/plain,application/x-zip\nupload_mime_illegal=text/html\n\n', 1),
(20, 'Articles', 'option=com_content', 0, 0, '', '', 'com_content', 0, '', 1, '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', 1),
(21, 'Configuration Manager', '', 0, 0, '', 'Configuration', 'com_config', 0, '', 1, '', 1),
(22, 'Installation Manager', '', 0, 0, '', 'Installer', 'com_installer', 0, '', 1, '', 1),
(23, 'Language Manager', '', 0, 0, '', 'Languages', 'com_languages', 0, '', 1, 'administrator=en-GB\nsite=en-GB', 1),
(24, 'Mass mail', '', 0, 0, '', 'Mass Mail', 'com_massmail', 0, '', 1, 'mailSubjectPrefix=\nmailBodySuffix=\n\n', 1),
(25, 'Menu Editor', '', 0, 0, '', 'Menu Editor', 'com_menus', 0, '', 1, '', 1),
(27, 'Messaging', '', 0, 0, '', 'Messages', 'com_messages', 0, '', 1, '', 1),
(28, 'Modules Manager', '', 0, 0, '', 'Modules', 'com_modules', 0, '', 1, '', 1),
(29, 'Plugin Manager', '', 0, 0, '', 'Plugins', 'com_plugins', 0, '', 1, '', 1),
(30, 'Template Manager', '', 0, 0, '', 'Templates', 'com_templates', 0, '', 1, '', 1),
(31, 'User Manager', '', 0, 0, '', 'Users', 'com_users', 0, '', 1, 'allowUserRegistration=1\nnew_usertype=Registered\nuseractivation=1\nfrontend_userparams=1\n\n', 1),
(32, 'Cache Manager', '', 0, 0, '', 'Cache', 'com_cache', 0, '', 1, '', 1),
(33, 'Control Panel', '', 0, 0, '', 'Control Panel', 'com_cpanel', 0, '', 1, '', 1);

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

--
-- 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=2 ;

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

INSERT INTO `jos_contact_details` (`id`, `name`, `alias`, `con_position`, `address`, `suburb`, `state`, `country`, `postcode`, `telephone`, `fax`, `misc`, `image`, `imagepos`, `email_to`, `default_con`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `user_id`, `catid`, `access`, `mobile`, `webpage`) VALUES
(1, 'Pavel Struhár', 'pavel-struhar', '', '', '', '', '', '', '', '', '', '', NULL, '', 0, 1, 0, '0000-00-00 00:00:00', 1, 'show_name=1\nshow_position=1\nshow_email=0\nshow_street_address=1\nshow_suburb=1\nshow_state=1\nshow_postcode=1\nshow_country=1\nshow_telephone=1\nshow_mobile=1\nshow_fax=1\nshow_webpage=1\nshow_misc=1\nshow_image=1\nallow_vcard=0\ncontact_icons=0\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_email_form=1\nemail_description=\nshow_email_copy=1\nbanned_email=\nbanned_subject=\nbanned_text=', 67, 49, 0, '', '');

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

--
-- 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=2 ;

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

INSERT INTO `jos_content` (`id`, `title`, `alias`, `title_alias`, `introtext`, `fulltext`, `state`, `sectionid`, `mask`, `catid`, `created`, `created_by`, `created_by_alias`, `modified`, `modified_by`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `images`, `urls`, `attribs`, `version`, `parentid`, `ordering`, `metakey`, `metadesc`, `access`, `hits`, `metadata`) VALUES
(1, 'Vitajte', 'vitajte', '', '<font face="arial,helvetica,sans-serif">Dobrý deň, toto je testovacia stránka projektu UNIREG, ktorého autorom je Pavel Struhár. Na samotný projekt sa dostanete kliknutím na <a href="index.php?option=com_unireg&Itemid=3">Unireg</a>. Samozrejme, funguje to až keď ste prihlásení. Reakcie píšte cez rozhranie vytvorené <a href="index.php?option=com_contact&view=contact&id=1&Itemid=4">tu</a>.</font>', '', 1, 0, 0, 0, '2008-06-08 22:35:22', 67, '', '2008-06-13 00:07:52', 66, 0, '0000-00-00 00:00:00', '2008-06-08 22:35:22', '0000-00-00 00:00:00', '', '', 'show_title=\nlink_titles=\nshow_intro=\nshow_section=\nlink_section=\nshow_category=\nlink_category=\nshow_vote=\nshow_author=\nshow_create_date=\nshow_modify_date=\nshow_pdf_icon=\nshow_print_icon=\nshow_email_icon=\nlanguage=\nkeyref=\nreadmore=', 5, 0, 1, '', '', 0, 6, 'robots=\nauthor=');

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

--
-- 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`
--

INSERT INTO `jos_content_frontpage` (`content_id`, `ordering`) VALUES
(1, 1);

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

--
-- 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=16 ;

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

INSERT INTO `jos_core_acl_aro` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', '62', 0, 'Administrator', 0),
(11, 'users', '63', 0, 'Author', 0),
(12, 'users', '64', 0, 'Publisher', 0),
(13, 'users', '65', 0, 'Editor', 0),
(14, 'users', '66', 0, 'Správca', 0),
(15, 'users', '67', 0, 'Pavel Struhár', 0);

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

--
-- 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`
--

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

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

--
-- 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`
--

INSERT INTO `jos_core_acl_aro_sections` (`id`, `value`, `order_value`, `name`, `hidden`) VALUES
(10, 'users', 1, 'Users', 0);

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

--
-- 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`
--

INSERT INTO `jos_core_acl_groups_aro_map` (`group_id`, `section_value`, `aro_id`) VALUES
(19, '', 11),
(20, '', 13),
(21, '', 12),
(21, '', 14),
(21, '', 15),
(25, '', 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_docman`
--

CREATE TABLE IF NOT EXISTS `jos_docman` (
  `id` int(11) NOT NULL auto_increment,
  `catid` int(11) NOT NULL default '1',
  `dmname` text NOT NULL,
  `dmdescription` longtext,
  `dmdate_published` datetime NOT NULL default '0000-00-00 00:00:00',
  `dmowner` int(4) NOT NULL default '-1',
  `dmfilename` text NOT NULL,
  `published` tinyint(1) NOT NULL default '0',
  `dmurl` text,
  `dmcounter` int(11) default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `approved` tinyint(1) NOT NULL default '0',
  `dmthumbnail` text,
  `dmlastupdateon` datetime default '0000-00-00 00:00:00',
  `dmlastupdateby` int(5) NOT NULL default '-1',
  `dmsubmitedby` int(5) NOT NULL default '-1',
  `dmmantainedby` int(5) default '0',
  `dmlicense_id` int(5) default '0',
  `dmlicense_display` tinyint(1) NOT NULL default '0',
  `access` int(11) unsigned NOT NULL default '0',
  `attribs` text NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `pub_appr_own_cat_name` (`published`,`approved`,`dmowner`,`catid`,`dmname`(64)),
  KEY `appr_pub_own_cat_date` (`approved`,`published`,`dmowner`,`catid`,`dmdate_published`),
  KEY `own_pub_appr_cat_count` (`dmowner`,`published`,`approved`,`catid`,`dmcounter`),
  KEY `own_pub_appr_cat_id` (`dmowner`,`published`,`approved`,`catid`,`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `jos_docman`
--


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

--
-- Table structure for table `jos_docman_groups`
--

CREATE TABLE IF NOT EXISTS `jos_docman_groups` (
  `groups_id` int(11) NOT NULL auto_increment,
  `groups_name` text NOT NULL,
  `groups_description` longtext,
  `groups_access` tinyint(4) NOT NULL default '1',
  `groups_members` text,
  PRIMARY KEY  (`groups_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `jos_docman_groups`
--

INSERT INTO `jos_docman_groups` (`groups_id`, `groups_name`, `groups_description`, `groups_access`, `groups_members`) VALUES
(1, 'Účtovníčky', 'Do tejto skupiny spadajú všetci registrovaní používateľia, ktorí majú prístup k účtovníckym položkám', 1, '68,69,70');

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

--
-- Table structure for table `jos_docman_history`
--

CREATE TABLE IF NOT EXISTS `jos_docman_history` (
  `id` int(11) NOT NULL auto_increment,
  `doc_id` int(11) NOT NULL,
  `revision` int(5) NOT NULL default '1',
  `his_date` datetime NOT NULL,
  `his_who` int(11) NOT NULL,
  `his_obs` longtext,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_docman_history`
--


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

--
-- Table structure for table `jos_docman_licenses`
--

CREATE TABLE IF NOT EXISTS `jos_docman_licenses` (
  `id` int(11) NOT NULL auto_increment,
  `name` text NOT NULL,
  `license` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_docman_licenses`
--


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

--
-- Table structure for table `jos_docman_log`
--

CREATE TABLE IF NOT EXISTS `jos_docman_log` (
  `id` int(11) NOT NULL auto_increment,
  `log_docid` int(11) NOT NULL,
  `log_ip` text NOT NULL,
  `log_datetime` datetime NOT NULL,
  `log_user` int(11) NOT NULL default '0',
  `log_browser` text,
  `log_os` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `jos_docman_log`
--


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

--
-- 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`
--

INSERT INTO `jos_groups` (`id`, `name`) VALUES
(0, 'Public'),
(1, 'Registered'),
(2, 'Special');

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

--
-- 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=7 ;

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

INSERT INTO `jos_menu` (`id`, `menutype`, `name`, `alias`, `link`, `type`, `published`, `parent`, `componentid`, `sublevel`, `ordering`, `checked_out`, `checked_out_time`, `pollid`, `browserNav`, `access`, `utaccess`, `params`, `lft`, `rgt`, `home`) VALUES
(1, 'mainmenu', 'Home', 'home', 'index.php?option=com_content&view=frontpage', 'component', 1, 0, 20, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 0, 3, 'show_page_title=1\npage_title=Welcome to the Frontpage\nshow_description=0\nshow_description_image=0\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\nshow_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\norderby_pri=\norderby_sec=front\nshow_pagination=2\nshow_pagination_results=1\nshow_noauth=0\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\n\n', 0, 0, 1),
(2, 'mainmenu', 'Docman', 'docman', 'index.php?option=com_docman', 'component', 0, 0, 46, 0, 2, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'cat_id=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(3, 'mainmenu', 'Unireg', 'unireg', '/unireg/index.php?option=com_unireg', 'url', 1, 0, 0, 0, 3, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'menu_image=-1\n\n', 0, 0, 0),
(4, 'mainmenu', 'Kontakt', 'kontakt', 'index.php?option=com_contact&view=contact&id=1', 'component', 1, 0, 7, 0, 4, 0, '0000-00-00 00:00:00', 0, 0, 0, 0, 'show_contact_list=0\nshow_category_crumb=0\ncontact_icons=\nicon_address=\nicon_email=\nicon_telephone=\nicon_mobile=\nicon_fax=\nicon_misc=\nshow_headings=\nshow_position=\nshow_email=\nshow_telephone=\nshow_mobile=\nshow_fax=\nallow_vcard=\nbanned_email=\nbanned_subject=\nbanned_text=\nvalidate_session=\ncustom_reply=\npage_title=\nshow_page_title=1\npageclass_sfx=\nmenu_image=-1\nsecure=0\n\n', 0, 0, 0),
(5, 'uniregmenu', 'Štruktúra kategórií', 'struktura-kategorii', 'index.php?option=com_unireg&controller=&Itemid=3', 'url', 1, 0, 0, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 'menu_image=-1\n\n', 0, 0, 0),
(6, 'uniregmenu', 'Záznamy', 'zaznamy', 'index.php?option=com_unireg&controller=records&Itemid=3', 'url', 1, 0, 0, 0, 2, 62, '2008-06-10 11:27:40', 0, 0, 1, 0, 'menu_image=-1\n\n', 0, 0, 0);

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

--
-- 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=3 ;

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

INSERT INTO `jos_menu_types` (`id`, `menutype`, `title`, `description`) VALUES
(1, 'mainmenu', 'Main Menu', 'The main menu for the site'),
(2, 'uniregmenu', 'Unireg menu', 'Unireg menu');

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

--
-- 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=31 ;

--
-- 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`, `control`) VALUES
(1, 'Main Menu', '', 3, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 0, 1, 'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 1, 0, ''),
(2, 'Login', '', 1, 'login', 0, '0000-00-00 00:00:00', 1, 'mod_login', 0, 0, 1, '', 1, 1, ''),
(3, 'Popular', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_popular', 0, 2, 1, '', 0, 1, ''),
(4, 'Recent added Articles', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_latest', 0, 2, 1, 'ordering=c_dsc\nuser_id=0\ncache=0\n\n', 0, 1, ''),
(5, 'Menu Stats', '', 5, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_stats', 0, 2, 1, '', 0, 1, ''),
(6, 'Unread Messages', '', 1, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_unread', 0, 2, 1, '', 1, 1, ''),
(7, 'Online Users', '', 2, 'header', 0, '0000-00-00 00:00:00', 1, 'mod_online', 0, 2, 1, '', 1, 1, ''),
(8, 'Toolbar', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', 1, 'mod_toolbar', 0, 2, 1, '', 1, 1, ''),
(9, 'Quick Icons', '', 1, 'icon', 0, '0000-00-00 00:00:00', 1, 'mod_quickicon', 0, 2, 1, '', 1, 1, ''),
(10, 'Logged in Users', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', 1, 'mod_logged', 0, 2, 1, '', 0, 1, ''),
(11, 'Footer', '', 0, 'footer', 0, '0000-00-00 00:00:00', 1, 'mod_footer', 0, 0, 1, '', 1, 1, ''),
(12, 'Admin Menu', '', 1, 'menu', 0, '0000-00-00 00:00:00', 1, 'mod_menu', 0, 2, 1, '', 0, 1, ''),
(13, 'Admin SubMenu', '', 1, 'submenu', 0, '0000-00-00 00:00:00', 1, 'mod_submenu', 0, 2, 1, '', 0, 1, ''),
(14, 'User Status', '', 1, 'status', 0, '0000-00-00 00:00:00', 1, 'mod_status', 0, 2, 1, '', 0, 1, ''),
(15, 'Title', '', 1, 'title', 0, '0000-00-00 00:00:00', 1, 'mod_title', 0, 2, 1, '', 0, 1, ''),
(26, 'Login', '', 0, 'top', 0, '0000-00-00 00:00:00', 1, 'mod_signallogin', 0, 0, 1, 'cache=0\nmoduleclass_sfx=\nmodule_theme=hivemind-light\nhorizontal=1\npretext=\nposttext=\nlogin=\nlogout=\nshow_lostpass=0\nshow_lostname=0\nshow_newaccount=0\nname_lenght=10\npass_lenght=10\nremember_enabled=0\ngreeting=1\nname=0\nusesecure=0\n\n', 0, 0, ''),
(27, 'Top menu', '', 0, 'user3', 62, '2008-04-25 03:01:05', 1, 'mod_mainmenu', 0, 0, 0, 'menutype=mainmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, ''),
(29, 'Browse Unireg', '', 1, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_browseunireg', 0, 1, 1, 'cache=0\nmoduleclass_sfx=\npretext=\nposttext=\nlogin=\nlogout=\ngreeting=1\nname=0\nusesecure=0\n\n', 0, 0, ''),
(30, 'Unireg menu', '', 2, 'left', 0, '0000-00-00 00:00:00', 1, 'mod_mainmenu', 0, 1, 1, 'menutype=uniregmenu\nmenu_style=list\nstartLevel=0\nendLevel=0\nshowAllChildren=0\nwindow_open=\nshow_whitespace=0\ncache=1\ntag_id=\nclass_sfx=\nmoduleclass_sfx=_menu\nmaxdepth=10\nmenu_images=0\nmenu_images_align=0\nexpand_menu=0\nactivate_parent=0\nfull_active_id=0\nindent_image=0\nindent_image1=\nindent_image2=\nindent_image3=\nindent_image4=\nindent_image5=\nindent_image6=\nspacer=\nend_spacer=\n\n', 0, 0, '');

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

--
-- 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`
--

INSERT INTO `jos_modules_menu` (`moduleid`, `menuid`) VALUES
(1, 1),
(1, 4),
(26, 0),
(27, 0),
(29, 0),
(30, 3);

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

--
-- 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=36 ;

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

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

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

--
-- 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=2 ;

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

INSERT INTO `jos_sections` (`id`, `title`, `name`, `alias`, `image`, `scope`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `ordering`, `access`, `count`, `params`) VALUES
(1, 'default', '', 'default', '', 'content', 'left', '', 1, 0, '0000-00-00 00:00:00', 1, 0, 0, '');

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

--
-- 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`
--

INSERT INTO `jos_session` (`username`, `time`, `session_id`, `guest`, `userid`, `usertype`, `gid`, `client_id`, `data`) VALUES
('', '1213362626', '5a4c84fc6ef88c8dea1ec419a3310e76', 1, 0, '', 0, 1, '__default|a:8:{s:15:"session.counter";i:1;s:19:"session.timer.start";i:1213362626;s:18:"session.timer.last";i:1213362626;s:17:"session.timer.now";i:1213362626;s:22:"session.client.browser";s:104:"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.14) Gecko/20080418 Ubuntu/7.10 (gutsy) Firefox/2.0.0.14";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:81:"/home/palino/eclipseHome/workspace/unireg/libraries/joomla/html/parameter/element";}s:17:"_defaultNameSpace";s:8:"_default";s:9:"_registry";a:1:{s:8:"_default";a:1:{s:4:"data";O:8:"stdClass":0:{}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"10ac3fb9fe7b26497ed058649f02ce1d";}'),
('admin', '1213362823', '76f7a588552b61cc7c2db53781c309af', 0, 62, 'Super Administrator', 25, 0, '__default|a:8:{s:15:"session.counter";i:24;s:19:"session.timer.start";i:1213362630;s:18:"session.timer.last";i:1213362823;s:17:"session.timer.now";i:1213362823;s:22:"session.client.browser";s:104:"Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.8.1.14) Gecko/20080418 Ubuntu/7.10 (gutsy) Firefox/2.0.0.14";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";s:2:"62";s:4:"name";s:13:"Administrator";s:8:"username";s:5:"admin";s:5:"email";s:16:"nejaka@adresa.sk";s:8:"password";s:65:"81b8c3634b29e5299beeef408c484c21:RBg8u2LPqHo5v3aKVpal31eIbOhqmW9l";s:14:"password_clear";s:0:"";s:8:"usertype";s:19:"Super Administrator";s:5:"block";s:1:"0";s:9:"sendEmail";s:1:"1";s:3:"gid";s:2:"25";s:12:"registerDate";s:19:"2008-03-25 18:21:26";s:13:"lastvisitDate";s:19:"2008-06-13 13:10:26";s:10:"activation";s:0:"";s:6:"params";s:56:"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n";s:3:"aid";i:2;s:5:"guest";i:0;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:81:"/home/palino/eclipseHome/workspace/unireg/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":5:{s:14:"admin_language";s:0:"";s:8:"language";s:0:"";s:6:"editor";s:0:"";s:8:"helpsite";s:0:"";s:8:"timezone";s:1:"0";}}}s:7:"_errors";a:0:{}}s:9:"_errorMsg";N;s:7:"_errors";a:0:{}}s:13:"session.token";s:32:"429eb46feb598043a72d20bf8a1d5ccc";}');

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

--
-- 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`
--

INSERT INTO `jos_templates_menu` (`template`, `menuid`, `client_id`) VALUES
('rhuk_milkyway', 0, 0),
('khepri', 0, 1);

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

--
-- Table structure for table `jos_unireg_categories`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_categories` (
  `id` int(11) NOT NULL auto_increment,
  `parent_id` int(11) NOT NULL default '0',
  `title` varchar(255) NOT NULL,
  `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=67 ;

--
-- Dumping data for table `jos_unireg_categories`
--

INSERT INTO `jos_unireg_categories` (`id`, `parent_id`, `title`, `name`, `alias`, `image`, `section`, `image_position`, `description`, `published`, `checked_out`, `checked_out_time`, `editor`, `ordering`, `access`, `count`, `params`) VALUES
(1, 0, 'Dokumenty', 'Dokumenty', '', '', 'com_docman', 'left', 'V&scaron;eobecn&aacute; kateg&oacute;ria pre dokumenty', 1, 0, '0000-00-00 00:00:00', NULL, 5, 0, 0, ''),
(3, 0, 'Obrázky', 'Obrázky', '', '', 'com_docman', 'left', 'Obr&aacute;zky', 1, 0, '0000-00-00 00:00:00', NULL, 4, 0, 0, ''),
(5, 1, 'Specialne Dokumenty', 'Specialne Dokumenty', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, ''),
(6, 0, 'Other', 'Other', '', '', '1', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 1, 0, 0, 'imagefolders=*2*'),
(7, 0, 'Všeobecná agenda', 'Všeobecná agenda', '', 'paragraf.png', 'com_docman', 'left', '', 1, 62, '2008-03-25 18:24:20', NULL, 1, 1, 0, ''),
(8, 7, 'Zakladateľské...', 'Zakladateľské listiny, ...', '', '', 'com_docman', 'left', 'Zakladateľsk&eacute; listiny k.s., spoločensk&aacute; zmluva, v&yacute;pisy z Obchodn&eacute;ho registra, Živnostensk&yacute; list', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(9, 7, 'Valná hromada', 'Valné zhromaždenia, ...', '', '', 'com_docman', 'left', 'Z&aacute;pisy z valn&yacute;ch zhromažden&iacute;, rozhodnutia spoločn&iacute;kov mimo valn&yacute;ch zhromažden&iacute;, konatelia', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(10, 7, 'Organizačné...', 'Organizačná štruktúra, ...', '', '', 'com_docman', 'left', 'Organizačn&aacute; &scaron;trukt&uacute;ra, organizačn&yacute; poriadok, vn&uacute;torn&eacute; smernice', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(11, 7, 'Porady vedenia', 'Porady vedenia vrátane príloh', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(30, 26, 'F. dodávateľské', 'Faktúry dodávateľské, ...', '', '', 'com_docman', 'left', 'Fakt&uacute;ry dod&aacute;vateľsk&eacute;, kniha do&scaron;l&yacute;ch fakt&uacute;r', 1, 0, '0000-00-00 00:00:00', NULL, 4, 1, 0, ''),
(12, 7, 'Stanoviská, ...', 'Stanoviská, správy, návrhy', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 5, 1, 0, ''),
(13, 7, 'Z. o spolupráci', 'Zmluvy o spolupráci', '', '', 'com_docman', 'left', 'Zmluvy o&nbsp;spolupr&aacute;ci s&nbsp;in&yacute;mi in&scaron;tit&uacute;ciami', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(14, 7, 'Zmluvy s $$', 'Zmluvy s peňažnými ústavmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(17, 7, 'Rokovania', 'Záznamy z rokovaní s klientmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 9, 1, 0, ''),
(16, 7, 'Poistné z.', 'Zmluvy poistné', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(18, 7, 'Spory', 'Právne záležitosti, ...', '', '', 'com_docman', 'left', 'Pr&aacute;vne z&aacute;ležitosti, spisy o&nbsp;v&yacute;znamn&yacute;ch sporoch vr&aacute;tane rozhodnut&iacute; s&uacute;dov a odvolan&iacute;', 1, 0, '0000-00-00 00:00:00', NULL, 10, 1, 0, ''),
(19, 7, 'Malé spory', 'Právne zastupovania, ...', '', '', 'com_docman', 'left', 'Pr&aacute;vne zastupovania, drobn&eacute; pr&aacute;vne spory', 1, 0, '0000-00-00 00:00:00', NULL, 11, 1, 0, ''),
(20, 7, 'Štatistika', 'Štátne štatistické výkazy', '', '', 'com_docman', 'left', '&Scaron;t&aacute;tne &scaron;tatistick&eacute; v&yacute;kazy &ndash; ročn&eacute; aj&nbsp;kr&aacute;tkodob&eacute;', 1, 0, '0000-00-00 00:00:00', NULL, 12, 1, 0, ''),
(21, 7, 'Listy', 'Korešpondencia bežná', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 13, 1, 0, ''),
(22, 7, 'Pošta', 'Knihy došlej a odoslanej pošty', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 14, 1, 0, ''),
(23, 7, 'Z. s dodávateľmi', 'Zmluvy s dodávateľmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 15, 1, 0, ''),
(24, 7, 'Z. s odberateľmi', 'Zmluvy s odberateľmi', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 16, 1, 0, ''),
(25, 7, 'Kontrola', 'Kontrolné, revízne správy, protokoly', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 17, 1, 0, ''),
(26, 0, 'Účtovníctvo', 'Účtovníctvo', '', 'coins.png', 'com_docman', 'left', 'Ekonomický úsek - Účtovníctvo', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(27, 26, 'Osvedčenia', 'Osvedčenia o registrácii k daniam', '', '', 'com_docman', 'left', '', 1, 62, '2008-02-05 16:51:58', NULL, 1, 1, 0, ''),
(28, 26, 'Daňové priznania', 'Daňové priznania ...', '', '', 'com_docman', 'left', 'Daňové priznania riadne, dodatočné, opravné: daň z príjmu právnických osôb, daň pridanej hodnoty, cestná daň, daň z nehnuteľnosti', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(49, 0, 'Moja', 'Moja', '', '', '', '', 'Moja kategória', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(29, 26, 'Podklady k DP', 'Počítačové podklady k DP', '', '', 'com_docman', 'left', 'Poč&iacute;tačov&eacute; podklady k daňov&yacute;m priznaniam', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(31, 26, 'F. odberateľské', 'Faktúry odberateľské, ...', '', '', 'com_docman', 'left', 'Fakt&uacute;ry odberateľsk&eacute;, kniha odoslan&yacute;ch fakt&uacute;r', 1, 0, '0000-00-00 00:00:00', NULL, 5, 1, 0, ''),
(32, 26, 'Pohľadávaky', 'Vymáhanie pohľadávok, ...', '', '', 'com_docman', 'left', 'Vym&aacute;hanie pohľad&aacute;vok, kore&scaron;pondencia s&nbsp;dod&aacute;vateľmi', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(33, 26, 'Pokladnička', 'Pokladničné doklady a kniha', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(34, 26, 'B. výpisy', 'Bankové výpisy z účtov', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(35, 26, 'Interné ...', 'Interné účtovné doklady', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 9, 1, 0, ''),
(36, 26, 'Účtovné závierky', 'Účtovné závierky, ...', '', '', 'com_docman', 'left', 'Uacute;čtovn&eacute; z&aacute;vierky, n&aacute;vrhy na rozdelenie zisku', 1, 0, '0000-00-00 00:00:00', NULL, 10, 1, 0, ''),
(37, 26, 'Tl. zostavy', 'Účtovné tlačové zostavy', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 11, 1, 0, ''),
(38, 26, 'Inventúry', 'Inventúry základných prostriedkov', '', '', 'com_docman', 'left', '', 1, 0, '0000-00-00 00:00:00', NULL, 12, 1, 0, ''),
(39, 26, 'Majetok', 'Odhady a oceňovanie majetku, ...', '', '', 'com_docman', 'left', 'Odhady a&nbsp;oceňovanie majetku, s&uacute;pisy a&nbsp;zmeny majetku', 1, 0, '0000-00-00 00:00:00', NULL, 13, 1, 0, ''),
(40, 0, 'Mzdová agenda', 'Mzdová agenda', '', '', 'com_docman', 'left', 'Ekonomický úsek - Mzdová agenda', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(41, 40, 'Mzdové listy', 'Evidenčné a mzdové listy', '', '', 'com_docman', 'left', 'Evidenčné listy zamestnancov, mzdové listy', 1, 0, '0000-00-00 00:00:00', NULL, 1, 1, 0, ''),
(42, 40, 'Výplatné listiny', 'Výplatné listiny, ...', '', '', 'com_docman', 'left', 'Výplatné listiny, vyúčtovanie miezd', 1, 0, '0000-00-00 00:00:00', NULL, 2, 1, 0, ''),
(43, 40, 'Prihlášky do SP,ZP,ÚP', 'Prihlášky a odhlášky do SP, ZP, ÚP', '', '', 'com_docman', 'left', 'Prihl&aacute;&scaron;ky a&nbsp;odhl&aacute;&scaron;ky do soci&aacute;lnej poisťovne, zdravotn&yacute;ch poisťovn&iacute;, &uacute;radu pr&aacute;ce', 1, 0, '0000-00-00 00:00:00', NULL, 3, 1, 0, ''),
(44, 40, 'DDP', 'DDP', '', '', 'com_docman', 'left', 'Doplnkov&eacute; d&ocirc;chodkov&eacute; poistenie', 1, 0, '0000-00-00 00:00:00', NULL, 4, 1, 0, ''),
(45, 40, 'Hlásenia DÚ', 'Hlásenia DÚ o zrazenej dani zo ZČ', '', '', 'com_docman', 'left', 'Hl&aacute;senia daňov&eacute;mu &uacute;radu o&nbsp;zrazenej dani zo z&aacute;vislej činnosti', 1, 62, '2008-02-05 15:27:21', NULL, 5, 1, 0, ''),
(46, 40, 'Výkazy do SP, ZP, ÚP', 'Mesačné výkazy do SP, ZP, ÚP', '', '', 'com_docman', 'left', 'Mesačn&eacute; v&yacute;kazy do soci&aacute;lnej poisťovne, zdravotn&yacute;ch poisťovn&iacute;, &uacute;radu pr&aacute;ce', 1, 0, '0000-00-00 00:00:00', NULL, 6, 1, 0, ''),
(47, 40, 'Dochádzka', 'Evidencia dochádzky, ...', '', '', 'com_docman', 'left', 'Evidencia doch&aacute;dzky, dovolenky', 1, 0, '0000-00-00 00:00:00', NULL, 7, 1, 0, ''),
(48, 40, 'Spisy zamestnancov', 'Osobné spisy zamestnancov', '', '', 'com_docman', 'left', 'Osobn&eacute; spisy zamestnancov, evidenčn&eacute; listy, platov&eacute; v&yacute;mery, žiadosti o&nbsp;prijatie do pracovn&eacute;ho pomeru, v&yacute;stupn&eacute; listy', 1, 0, '0000-00-00 00:00:00', NULL, 8, 1, 0, ''),
(50, 0, 'Moje', 'Moja', '', '', '', '', 'Mojo', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(51, 0, 'asda', 'fsasgdg', '', '', '', '', 'dsaggsd', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(52, 0, 'asda', 'fsasgdg', '', '', '', '', 'dsaggsd', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(62, 0, 'Sub1', 'Sub5', '', '', '', '', 'Subtesting 1', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(65, 0, '', 'test', '', '', '', '', 'test', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(64, 0, '1', '1', '', '', '', '', '1', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(63, 0, 'Sub2', 'Sub2', '', '', '', '', 'Subtesting 2', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, ''),
(61, 0, 'Testing', 'Testing', '', '', '', '', 'Testing', 0, 0, '0000-00-00 00:00:00', NULL, 0, 0, 0, '');

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

--
-- Table structure for table `jos_unireg_entries`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_entries` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `public_id` varchar(255) NOT NULL,
  `created` datetime NOT NULL default '0000-00-00 00:00:00',
  `modified` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `jos_unireg_entries`
--

INSERT INTO `jos_unireg_entries` (`id`, `name`, `description`, `public_id`, `created`, `modified`) VALUES
(1, 'nejaky email', 'Toto je nejaký email', '', '2008-06-06 00:00:00', '2008-06-10 17:57:31'),
(3, 'Len tak', 'Len taký záznam', '', '2008-06-10 13:00:00', '2008-06-10 11:03:30'),
(7, '2', '2', '', '2008-06-10 11:11:02', '2008-06-10 11:11:02'),
(12, 'asdas', 'dagds', '', '2008-06-12 23:57:00', '2008-06-12 23:57:00'),
(14, 'test', 'test', '', '2008-06-13 08:14:05', '2008-06-13 08:14:05'),
(15, 'DELL Latitude D600', 'Kupa notebooku', '', '2008-06-13 08:49:23', '2008-06-13 08:49:23');

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

--
-- Table structure for table `jos_unireg_folders`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_folders` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) character set utf8 NOT NULL,
  `description` text character set utf8 NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=23 ;

--
-- Dumping data for table `jos_unireg_folders`
--

INSERT INTO `jos_unireg_folders` (`id`, `name`, `description`) VALUES
(21, 'hahahahaha', 'hahahahaha'),
(22, '2007', 'uctovnictvo za ro 2007');

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

--
-- Table structure for table `jos_unireg_hierarchies`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_hierarchies` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) collate utf8_slovak_ci NOT NULL,
  `alias` varchar(25) collate utf8_slovak_ci NOT NULL,
  `description` text collate utf8_slovak_ci NOT NULL,
  `ismain` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci COMMENT='Table for storing hierarchies' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `jos_unireg_hierarchies`
--

INSERT INTO `jos_unireg_hierarchies` (`id`, `name`, `alias`, `description`, `ismain`) VALUES
(1, 'Hlavná', 'hlavna', 'Hlavná registratúrna hierarchia', 1);

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

--
-- Table structure for table `jos_unireg_items`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_items` (
  `id` int(11) NOT NULL auto_increment,
  `hid` int(11) NOT NULL default '1',
  `pid` int(11) NOT NULL default '0',
  `type_id` int(11) NOT NULL,
  `rid` int(11) NOT NULL,
  `mounted` tinyint(2) NOT NULL default '0',
  `id_name` varchar(255) collate utf8_slovak_ci NOT NULL,
  `pid_name` varchar(255) collate utf8_slovak_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci COMMENT='Table to join all the tables into one tree structure' AUTO_INCREMENT=97 ;

--
-- Dumping data for table `jos_unireg_items`
--

INSERT INTO `jos_unireg_items` (`id`, `hid`, `pid`, `type_id`, `rid`, `mounted`, `id_name`, `pid_name`) VALUES
(1, 1, 0, 1, 7, 0, '', ''),
(2, 1, 0, 1, 26, 0, '', ''),
(3, 1, 0, 1, 40, 0, '', ''),
(4, 1, 1, 1, 8, 0, '', ''),
(5, 1, 1, 1, 9, 0, '', ''),
(6, 1, 1, 1, 10, 0, '', ''),
(7, 1, 1, 1, 11, 0, '', ''),
(8, 1, 1, 1, 12, 0, '', ''),
(9, 1, 1, 1, 13, 0, '', ''),
(10, 1, 1, 1, 13, 0, '', ''),
(11, 1, 1, 1, 14, 0, '', ''),
(12, 1, 1, 1, 16, 0, '', ''),
(13, 1, 1, 1, 17, 0, '', ''),
(14, 1, 1, 1, 18, 0, '', ''),
(15, 1, 1, 1, 19, 0, '', ''),
(16, 1, 1, 1, 20, 0, '', ''),
(17, 1, 1, 1, 21, 0, '', ''),
(18, 1, 1, 1, 22, 0, '', ''),
(19, 1, 1, 1, 23, 0, '', ''),
(20, 1, 1, 1, 24, 0, '', ''),
(21, 1, 1, 1, 25, 0, '', ''),
(22, 1, 2, 1, 27, 0, '', ''),
(23, 1, 2, 1, 28, 0, '', ''),
(24, 1, 2, 1, 29, 0, '', ''),
(25, 1, 2, 1, 30, 0, '', ''),
(26, 1, 3, 1, 41, 0, '', ''),
(27, 1, 2, 1, 31, 0, '', ''),
(28, 1, 2, 1, 32, 0, '', ''),
(29, 1, 2, 1, 33, 0, '', ''),
(30, 1, 2, 1, 34, 0, '', ''),
(31, 1, 2, 1, 35, 0, '', ''),
(32, 1, 2, 1, 36, 0, '', ''),
(33, 1, 2, 1, 37, 0, '', ''),
(34, 1, 2, 1, 38, 0, '', ''),
(35, 1, 2, 1, 39, 0, '', ''),
(36, 1, 3, 1, 42, 0, '', ''),
(37, 1, 3, 1, 43, 0, '', ''),
(38, 1, 3, 1, 44, 0, '', ''),
(39, 1, 3, 1, 45, 0, '', ''),
(40, 1, 3, 1, 46, 0, '', ''),
(41, 1, 3, 1, 47, 0, '', ''),
(42, 1, 3, 1, 48, 0, '', ''),
(84, 1, 69, 1, 64, 0, '', ''),
(78, 1, 71, 3, 3, 0, '', ''),
(82, 1, 71, 3, 7, 0, '', ''),
(89, 1, 69, 2, 21, 0, '', ''),
(74, 1, 70, 3, 1, 0, '', ''),
(69, 1, 0, 1, 61, 0, '', ''),
(70, 1, 69, 1, 62, 0, '', ''),
(71, 1, 69, 1, 63, 0, '', ''),
(90, 1, 69, 3, 12, 0, '', ''),
(92, 1, 3, 3, 14, 0, '', ''),
(93, 1, 0, 1, 65, 0, '', ''),
(95, 1, 93, 2, 22, 0, '', ''),
(96, 1, 93, 3, 15, 0, '', '');

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

--
-- Table structure for table `jos_unireg_recfiles`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_recfiles` (
  `id` int(11) NOT NULL auto_increment,
  `entry_id` int(11) NOT NULL,
  `name` varchar(255) collate utf8_slovak_ci NOT NULL,
  `note` text collate utf8_slovak_ci NOT NULL,
  `filename` varchar(255) collate utf8_slovak_ci NOT NULL,
  `path` varchar(255) collate utf8_slovak_ci NOT NULL,
  `mime` varchar(255) collate utf8_slovak_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=16 ;

--
-- Dumping data for table `jos_unireg_recfiles`
--

INSERT INTO `jos_unireg_recfiles` (`id`, `entry_id`, `name`, `note`, `filename`, `path`, `mime`) VALUES
(9, 1, 'apriori_2008-05-04.sql', '', 'apriori_2008-05-04.sql', '/home/palino/eclipseHome/tmp', 'text/x-sql'),
(10, 11, '2007-10-16_alenkin_mail.txt', '', '2007-10-16_alenkin_mail.txt', '/home/palino/eclipseHome/tmp', 'text/plain'),
(14, 11, 'joomla.ods', '', 'joomla.ods', '/home/palino/eclipseHome/tmp', 'application/vnd.oasis.opendocument.spreadsheet');

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

--
-- Table structure for table `jos_unireg_rules`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_rules` (
  `id` int(11) NOT NULL auto_increment,
  `parent` int(11) NOT NULL,
  `child` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci COMMENT='Rules for subitem creation.' AUTO_INCREMENT=6 ;

--
-- Dumping data for table `jos_unireg_rules`
--

INSERT INTO `jos_unireg_rules` (`id`, `parent`, `child`, `active`) VALUES
(1, 1, 1, 1),
(2, 0, 1, 1),
(3, 1, 2, 1),
(4, 1, 3, 1),
(5, 2, 3, 1);

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

--
-- Table structure for table `jos_unireg_types`
--

CREATE TABLE IF NOT EXISTS `jos_unireg_types` (
  `id` int(11) NOT NULL auto_increment,
  `single` varchar(255) collate utf8_slovak_ci NOT NULL,
  `tablename` varchar(255) collate utf8_slovak_ci NOT NULL,
  `title` varchar(255) collate utf8_slovak_ci NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_slovak_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `jos_unireg_types`
--

INSERT INTO `jos_unireg_types` (`id`, `single`, `tablename`, `title`) VALUES
(1, 'category', 'unireg_categories', 'Kategórie'),
(2, 'folder', 'unireg_folders', 'Priečinky'),
(3, 'entry', 'unireg_entries', 'Záznamy');

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

--
-- 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,
  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=68 ;

--
-- 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', 'nejaka@adresa.sk', '81b8c3634b29e5299beeef408c484c21:RBg8u2LPqHo5v3aKVpal31eIbOhqmW9l', 'Super Administrator', 0, 1, 25, '2008-03-25 18:21:26', '2008-06-13 13:10:35', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n'),
(63, 'Author', 'author', 'author@unireg.wellmail.sk', 'edb2f49ecc4c4c0265610ecdeafff520:pfsam1ARxtNAE9cYwh9PFSdYR6fSvLO5', 'Author', 0, 0, 19, '2008-03-26 01:17:36', '2008-04-25 01:42:12', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n'),
(64, 'Publisher', 'publisher', 'publisher@unireg.sk', '6c41ae87b607706bfce37be6669d007c:ORIWao8wZKCQfxFtN509o9IKkU42WGmQ', 'Publisher', 0, 0, 21, '2008-03-26 01:18:36', '2008-06-09 19:03:25', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n'),
(65, 'Editor', 'editor', 'editor@unireg.wellmail.sk', 'b9c795ca6e0ce8ab1bb4a98a4f6c0f42:DSMhSp01ni1Fcg77o6R0cO8brNd85mIs', 'Editor', 0, 0, 20, '2008-03-26 01:19:09', '0000-00-00 00:00:00', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n'),
(66, 'Správca', 'spravca', 'spravca@blablablabla.sk', '8da69b5c20cd8aebf9258d2e62fd87f6:FoKllVTT2KINYpMEjIQh4cZkqSyeKQE8', 'Publisher', 0, 0, 21, '2008-06-09 19:11:35', '2008-06-13 08:47:05', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=1\n\n'),
(67, 'Pavel Struhár', 'palino', 'pstruhar@gmail.com', '0d99a6ab80da7507e003437818c99061:mRYlX25WIRaxVhKHoMwK90kZVQHfosA4', 'Publisher', 0, 0, 21, '2008-06-09 19:12:41', '2008-06-13 06:03:01', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n');

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

--
-- 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`
--

