-- phpMyAdmin SQL Dump
-- version 2.11.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 13, 2008 at 03:23 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_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');
