![](\\"..\\/templates\\/smartone\\/template_thumbnail.png\\")
\\n\\tJoomla Template developed by JoomlaTemplates.me<\\/a>, released under the GNU\\/GPL<\\/a> license.\\n\\t
Need help to set up your template? Check out the documentation<\\/a> page.\\n\\t
Download free joomla extensions from jExtensions.com<\\/a>,\\n\\t
Copyright © 2013 JoomlaTemplates.me - All Rights Reserved<\\/b>\\n\\t","group":""}', '{"scrolltop":"yes","logotype":"image","sitetitle":"SmartOne","sitedesc":"","menuid":"0","animation":"fade","Caption1":"","Caption2":"","Caption3":"","Caption4":"","Caption5":"","Caption6":"","Caption7":"","Caption8":"","Caption9":"","Caption10":"","Caption11":"","Caption12":"","Caption13":"","Caption14":"","Caption15":"","Caption16":"","Caption17":"","Caption18":"","Caption19":"","Caption20":""}', '', '', 0, '0000-00-00 00:00:00', 0, 0), (10001, 'joomgallery', 'component', 'com_joomgallery', '', 1, 1, 0, 0, '{"name":"JoomGallery","type":"component","creationDate":"2014\\/02\\/08","author":"JoomGallery::ProjectTeam","copyright":"This component is released under the GNU\\/GPL License","authorEmail":"team@joomgallery.net","authorUrl":"http:\\/\\/www.joomgallery.net","version":"3.1.1","description":"JoomGallery 3 is a native Joomla! 3.x gallery component","group":""}', '{}', '', '', 0, '0000-00-00 00:00:00', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_filters` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_filters` ( `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(255) NOT NULL, `alias` varchar(255) NOT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) unsigned NOT NULL, `created_by_alias` varchar(255) NOT NULL, `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_by` int(10) unsigned NOT NULL DEFAULT '0', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `map_count` int(10) unsigned NOT NULL DEFAULT '0', `data` text NOT NULL, `params` mediumtext, PRIMARY KEY (`filter_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links` ( `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `url` varchar(255) NOT NULL, `route` varchar(255) NOT NULL, `title` varchar(255) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `md5sum` varchar(32) DEFAULT NULL, `published` tinyint(1) NOT NULL DEFAULT '1', `state` int(5) DEFAULT '1', `access` int(5) DEFAULT '0', `language` varchar(8) NOT NULL, `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `list_price` double unsigned NOT NULL DEFAULT '0', `sale_price` double unsigned NOT NULL DEFAULT '0', `type_id` int(11) NOT NULL, `object` mediumblob NOT NULL, PRIMARY KEY (`link_id`), KEY `idx_type` (`type_id`), KEY `idx_title` (`title`), KEY `idx_md5` (`md5sum`), KEY `idx_url` (`url`(75)), KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`), KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms0` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms0` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms1` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms1` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms2` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms2` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms3` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms3` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms4` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms4` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms5` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms5` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms6` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms6` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms7` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms7` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms8` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms8` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_terms9` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_terms9` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termsa` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termsa` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termsb` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termsb` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termsc` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termsc` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termsd` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termsd` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termse` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termse` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_links_termsf` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_links_termsf` ( `link_id` int(10) unsigned NOT NULL, `term_id` int(10) unsigned NOT NULL, `weight` float unsigned NOT NULL, PRIMARY KEY (`link_id`,`term_id`), KEY `idx_term_weight` (`term_id`,`weight`), KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_taxonomy` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_taxonomy` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL, `state` tinyint(1) unsigned NOT NULL DEFAULT '1', `access` tinyint(1) unsigned NOT NULL DEFAULT '0', `ordering` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), KEY `state` (`state`), KEY `ordering` (`ordering`), KEY `access` (`access`), KEY `idx_parent_published` (`parent_id`,`state`,`access`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `nn34x_finder_taxonomy` -- INSERT INTO `nn34x_finder_taxonomy` (`id`, `parent_id`, `title`, `state`, `access`, `ordering`) VALUES (1, 0, 'ROOT', 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_taxonomy_map` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_taxonomy_map` ( `link_id` int(10) unsigned NOT NULL, `node_id` int(10) unsigned NOT NULL, PRIMARY KEY (`link_id`,`node_id`), KEY `link_id` (`link_id`), KEY `node_id` (`node_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_terms` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_terms` ( `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `term` varchar(75) NOT NULL, `stem` varchar(75) NOT NULL, `common` tinyint(1) unsigned NOT NULL DEFAULT '0', `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0', `weight` float unsigned NOT NULL DEFAULT '0', `soundex` varchar(75) NOT NULL, `links` int(10) NOT NULL DEFAULT '0', `language` char(3) NOT NULL DEFAULT '', PRIMARY KEY (`term_id`), UNIQUE KEY `idx_term` (`term`), KEY `idx_term_phrase` (`term`,`phrase`), KEY `idx_stem_phrase` (`stem`,`phrase`), KEY `idx_soundex_phrase` (`soundex`,`phrase`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_terms_common` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_terms_common` ( `term` varchar(75) NOT NULL, `language` varchar(3) NOT NULL, KEY `idx_word_lang` (`term`,`language`), KEY `idx_lang` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nn34x_finder_terms_common` -- INSERT INTO `nn34x_finder_terms_common` (`term`, `language`) VALUES ('a', 'en'), ('about', 'en'), ('after', 'en'), ('ago', 'en'), ('all', 'en'), ('am', 'en'), ('an', 'en'), ('and', 'en'), ('ani', 'en'), ('any', 'en'), ('are', 'en'), ('aren''t', 'en'), ('as', 'en'), ('at', 'en'), ('be', 'en'), ('but', 'en'), ('by', 'en'), ('for', 'en'), ('from', 'en'), ('get', 'en'), ('go', 'en'), ('how', 'en'), ('if', 'en'), ('in', 'en'), ('into', 'en'), ('is', 'en'), ('isn''t', 'en'), ('it', 'en'), ('its', 'en'), ('me', 'en'), ('more', 'en'), ('most', 'en'), ('must', 'en'), ('my', 'en'), ('new', 'en'), ('no', 'en'), ('none', 'en'), ('not', 'en'), ('noth', 'en'), ('nothing', 'en'), ('of', 'en'), ('off', 'en'), ('often', 'en'), ('old', 'en'), ('on', 'en'), ('onc', 'en'), ('once', 'en'), ('onli', 'en'), ('only', 'en'), ('or', 'en'), ('other', 'en'), ('our', 'en'), ('ours', 'en'), ('out', 'en'), ('over', 'en'), ('page', 'en'), ('she', 'en'), ('should', 'en'), ('small', 'en'), ('so', 'en'), ('some', 'en'), ('than', 'en'), ('thank', 'en'), ('that', 'en'), ('the', 'en'), ('their', 'en'), ('theirs', 'en'), ('them', 'en'), ('then', 'en'), ('there', 'en'), ('these', 'en'), ('they', 'en'), ('this', 'en'), ('those', 'en'), ('thus', 'en'), ('time', 'en'), ('times', 'en'), ('to', 'en'), ('too', 'en'), ('true', 'en'), ('under', 'en'), ('until', 'en'), ('up', 'en'), ('upon', 'en'), ('use', 'en'), ('user', 'en'), ('users', 'en'), ('veri', 'en'), ('version', 'en'), ('very', 'en'), ('via', 'en'), ('want', 'en'), ('was', 'en'), ('way', 'en'), ('were', 'en'), ('what', 'en'), ('when', 'en'), ('where', 'en'), ('whi', 'en'), ('which', 'en'), ('who', 'en'), ('whom', 'en'), ('whose', 'en'), ('why', 'en'), ('wide', 'en'), ('will', 'en'), ('with', 'en'), ('within', 'en'), ('without', 'en'), ('would', 'en'), ('yes', 'en'), ('yet', 'en'), ('you', 'en'), ('your', 'en'), ('yours', 'en'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_tokens` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_tokens` ( `term` varchar(75) NOT NULL, `stem` varchar(75) NOT NULL, `common` tinyint(1) unsigned NOT NULL DEFAULT '0', `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0', `weight` float unsigned NOT NULL DEFAULT '1', `context` tinyint(1) unsigned NOT NULL DEFAULT '2', `language` char(3) NOT NULL DEFAULT '', KEY `idx_word` (`term`), KEY `idx_context` (`context`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_tokens_aggregate` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_tokens_aggregate` ( `term_id` int(10) unsigned NOT NULL, `map_suffix` char(1) NOT NULL, `term` varchar(75) NOT NULL, `stem` varchar(75) NOT NULL, `common` tinyint(1) unsigned NOT NULL DEFAULT '0', `phrase` tinyint(1) unsigned NOT NULL DEFAULT '0', `term_weight` float unsigned NOT NULL, `context` tinyint(1) unsigned NOT NULL DEFAULT '2', `context_weight` float unsigned NOT NULL, `total_weight` float unsigned NOT NULL, `language` char(3) NOT NULL DEFAULT '', KEY `token` (`term`), KEY `keyword_id` (`term_id`) ) ENGINE=MEMORY DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_finder_types` -- CREATE TABLE IF NOT EXISTS `nn34x_finder_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `title` varchar(100) NOT NULL, `mime` varchar(100) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `title` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(10) NOT NULL DEFAULT '0', `catid` int(11) NOT NULL DEFAULT '0', `imgtitle` text NOT NULL, `alias` varchar(255) NOT NULL DEFAULT '', `imgauthor` varchar(50) DEFAULT NULL, `imgtext` text NOT NULL, `imgdate` datetime NOT NULL, `hits` int(11) NOT NULL DEFAULT '0', `downloads` int(11) NOT NULL DEFAULT '0', `imgvotes` int(11) NOT NULL DEFAULT '0', `imgvotesum` int(11) NOT NULL DEFAULT '0', `access` tinyint(3) NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '0', `hidden` tinyint(1) NOT NULL DEFAULT '0', `imgfilename` varchar(100) NOT NULL DEFAULT '', `imgthumbname` varchar(100) NOT NULL DEFAULT '', `checked_out` int(11) NOT NULL DEFAULT '0', `owner` int(11) unsigned NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '0', `useruploaded` tinyint(1) NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', `params` text NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_catid` (`catid`), KEY `idx_owner` (`owner`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `nn34x_joomgallery` -- INSERT INTO `nn34x_joomgallery` (`id`, `asset_id`, `catid`, `imgtitle`, `alias`, `imgauthor`, `imgtext`, `imgdate`, `hits`, `downloads`, `imgvotes`, `imgvotesum`, `access`, `published`, `hidden`, `imgfilename`, `imgthumbname`, `checked_out`, `owner`, `approved`, `useruploaded`, `ordering`, `params`, `metakey`, `metadesc`) VALUES (1, 63, 2, 'Manče_1', 'mance-1-1', 'Sandi', '', '2014-05-21 17:21:07', 0, 0, 0, 0, 1, 1, 0, 'mane_1_20140521_1786930718.jpg', 'mane_1_20140521_1786930718.jpg', 0, 0, 1, 0, 1, '', '', ''), (2, 64, 2, 'Manče_2', 'mance-2-2', 'Sandi', '', '2014-05-21 17:21:13', 0, 0, 0, 0, 1, 1, 0, 'mane_2_20140521_1089857824.jpg', 'mane_2_20140521_1089857824.jpg', 0, 0, 1, 0, 2, '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_category_details` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_category_details` ( `id` int(11) NOT NULL, `details_key` varchar(255) NOT NULL, `details_value` text NOT NULL, `ordering` int(11) NOT NULL, PRIMARY KEY (`id`,`details_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_catg` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_catg` ( `cid` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(10) NOT NULL DEFAULT '0', `name` varchar(255) NOT NULL DEFAULT '', `alias` varchar(255) NOT NULL DEFAULT '', `parent_id` int(11) NOT NULL DEFAULT '0', `lft` int(11) NOT NULL DEFAULT '0', `rgt` int(11) NOT NULL DEFAULT '0', `level` int(1) unsigned NOT NULL DEFAULT '0', `description` text, `access` tinyint(3) unsigned NOT NULL DEFAULT '0', `published` tinyint(1) NOT NULL DEFAULT '0', `hidden` tinyint(1) NOT NULL DEFAULT '0', `in_hidden` tinyint(1) NOT NULL DEFAULT '0', `password` varchar(100) NOT NULL DEFAULT '', `owner` int(11) DEFAULT '0', `thumbnail` int(11) DEFAULT NULL, `img_position` int(10) DEFAULT '0', `catpath` varchar(255) NOT NULL DEFAULT '', `params` text NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, `exclude_toplists` int(1) NOT NULL, `exclude_search` int(1) NOT NULL, PRIMARY KEY (`cid`), KEY `idx_parent_id` (`parent_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `nn34x_joomgallery_catg` -- INSERT INTO `nn34x_joomgallery_catg` (`cid`, `asset_id`, `name`, `alias`, `parent_id`, `lft`, `rgt`, `level`, `description`, `access`, `published`, `hidden`, `in_hidden`, `password`, `owner`, `thumbnail`, `img_position`, `catpath`, `params`, `metakey`, `metadesc`, `exclude_toplists`, `exclude_search`) VALUES (1, 0, 'ROOT', 'root', 0, 0, 4, 0, NULL, 1, 1, 0, 0, '', 0, NULL, 0, '', '', '', '', 0, 0), (2, 56, 'Manče', 'mane', 1, 1, 2, 1, '
Obsežna galerija Manč
', 1, 1, 0, 0, '', 0, 0, -1, 'mane_2', '', '', '', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_comments` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_comments` ( `cmtid` int(11) NOT NULL AUTO_INCREMENT, `cmtpic` int(11) NOT NULL DEFAULT '0', `cmtip` varchar(15) NOT NULL DEFAULT '', `userid` int(11) unsigned NOT NULL DEFAULT '0', `cmtname` varchar(50) NOT NULL DEFAULT '', `cmttext` text NOT NULL, `cmtdate` datetime NOT NULL, `published` tinyint(1) NOT NULL DEFAULT '0', `approved` tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (`cmtid`), KEY `idx_cmtpic` (`cmtpic`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_config` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_config` ( `id` int(1) NOT NULL AUTO_INCREMENT, `group_id` int(11) NOT NULL, `ordering` int(11) NOT NULL, `jg_pathimages` varchar(100) NOT NULL, `jg_pathoriginalimages` varchar(100) NOT NULL, `jg_paththumbs` varchar(100) NOT NULL, `jg_pathftpupload` varchar(100) NOT NULL, `jg_pathtemp` varchar(100) NOT NULL, `jg_wmpath` varchar(100) NOT NULL, `jg_wmfile` varchar(50) NOT NULL, `jg_use_real_paths` int(1) NOT NULL, `jg_checkupdate` int(1) NOT NULL, `jg_filenamewithjs` int(1) NOT NULL, `jg_filenamereplace` text NOT NULL, `jg_thumbcreation` varchar(5) NOT NULL, `jg_fastgd2thumbcreation` int(1) NOT NULL, `jg_impath` varchar(50) NOT NULL, `jg_resizetomaxwidth` int(1) NOT NULL, `jg_maxwidth` int(5) NOT NULL, `jg_picturequality` int(3) NOT NULL, `jg_useforresizedirection` int(1) NOT NULL, `jg_cropposition` int(1) NOT NULL, `jg_thumbwidth` int(5) NOT NULL, `jg_thumbheight` int(5) NOT NULL, `jg_thumbquality` int(3) NOT NULL, `jg_uploadorder` int(1) NOT NULL, `jg_useorigfilename` int(1) NOT NULL, `jg_filenamenumber` int(1) NOT NULL, `jg_delete_original` int(1) NOT NULL, `jg_msg_upload_type` int(1) NOT NULL, `jg_msg_upload_recipients` text NOT NULL, `jg_msg_download_type` int(1) NOT NULL, `jg_msg_download_recipients` text NOT NULL, `jg_msg_zipdownload` int(1) NOT NULL, `jg_msg_comment_type` int(1) NOT NULL, `jg_msg_comment_recipients` text NOT NULL, `jg_msg_comment_toowner` int(1) NOT NULL, `jg_msg_nametag_type` int(1) NOT NULL, `jg_msg_nametag_recipients` text NOT NULL, `jg_msg_nametag_totaggeduser` int(1) NOT NULL, `jg_msg_nametag_toowner` int(1) NOT NULL, `jg_msg_report_type` int(1) NOT NULL, `jg_msg_report_recipients` text NOT NULL, `jg_msg_report_toowner` int(1) NOT NULL, `jg_msg_rejectimg_type` int(1) NOT NULL, `jg_msg_global_from` int(1) NOT NULL, `jg_realname` int(1) NOT NULL, `jg_cooliris` int(1) NOT NULL, `jg_coolirislink` int(1) NOT NULL, `jg_contentpluginsenabled` int(1) NOT NULL, `jg_itemid` varchar(10) NOT NULL, `jg_ajaxcategoryselection` int(1) NOT NULL, `jg_disableunrequiredchecks` int(1) NOT NULL, `jg_userspace` int(1) NOT NULL, `jg_useruploaddefaultcat` int(1) NOT NULL, `jg_approve` int(1) NOT NULL, `jg_unregistered_permissions` int(1) NOT NULL, `jg_maxusercat` int(5) NOT NULL, `jg_maxuserimage` int(9) NOT NULL, `jg_maxuserimage_timespan` int(9) NOT NULL, `jg_maxfilesize` int(9) NOT NULL, `jg_usercatacc` int(1) NOT NULL, `jg_usercatthumbalign` int(1) NOT NULL, `jg_useruploadsingle` int(1) NOT NULL, `jg_maxuploadfields` int(3) NOT NULL, `jg_useruploadajax` int(1) NOT NULL, `jg_useruploadbatch` int(1) NOT NULL, `jg_useruploadjava` int(1) NOT NULL, `jg_useruseorigfilename` int(1) NOT NULL, `jg_useruploadnumber` int(1) NOT NULL, `jg_special_gif_upload` int(1) NOT NULL, `jg_delete_original_user` int(1) NOT NULL, `jg_newpiccopyright` int(1) NOT NULL, `jg_newpicnote` int(1) NOT NULL, `jg_redirect_after_upload` int(1) NOT NULL, `jg_download` int(1) NOT NULL, `jg_download_unreg` int(1) NOT NULL, `jg_download_hint` int(1) NOT NULL, `jg_downloadfile` int(1) NOT NULL, `jg_downloadwithwatermark` int(1) NOT NULL, `jg_showrating` int(1) NOT NULL, `jg_maxvoting` int(1) NOT NULL, `jg_ratingcalctype` int(1) NOT NULL, `jg_ratingdisplaytype` int(1) NOT NULL, `jg_ajaxrating` int(1) NOT NULL, `jg_votingonlyonce` int(1) NOT NULL, `jg_votingonlyreg` int(1) NOT NULL, `jg_showcomment` int(1) NOT NULL, `jg_anoncomment` int(1) NOT NULL, `jg_namedanoncomment` int(1) NOT NULL, `jg_anonapprovecom` int(1) NOT NULL, `jg_approvecom` int(1) NOT NULL, `jg_bbcodesupport` int(1) NOT NULL, `jg_smiliesupport` int(1) NOT NULL, `jg_anismilie` int(1) NOT NULL, `jg_smiliescolor` varchar(10) NOT NULL, `jg_report_images` int(1) NOT NULL, `jg_report_unreg` int(1) NOT NULL, `jg_report_hint` int(1) NOT NULL, `jg_alternative_layout` varchar(255) NOT NULL, `jg_anchors` int(1) NOT NULL, `jg_tooltips` int(1) NOT NULL, `jg_dyncrop` int(1) NOT NULL, `jg_dyncropposition` int(1) NOT NULL, `jg_dyncropwidth` int(5) NOT NULL, `jg_dyncropheight` int(5) NOT NULL, `jg_dyncropbgcol` varchar(12) NOT NULL, `jg_hideemptycats` int(1) NOT NULL, `jg_skipcatview` int(1) NOT NULL, `jg_imgalign` int(3) NOT NULL, `jg_showrestrictedcats` int(1) NOT NULL, `jg_showrestrictedhint` int(1) NOT NULL, `jg_firstorder` varchar(20) NOT NULL, `jg_secondorder` varchar(20) NOT NULL, `jg_thirdorder` varchar(20) NOT NULL, `jg_pagetitle_cat` text NOT NULL, `jg_pagetitle_detail` text NOT NULL, `jg_showgalleryhead` int(1) NOT NULL, `jg_showpathway` int(1) NOT NULL, `jg_completebreadcrumbs` int(1) NOT NULL, `jg_search` int(1) NOT NULL, `jg_searchcols` int(1) NOT NULL, `jg_searchthumbalign` int(1) NOT NULL, `jg_searchtextalign` int(1) NOT NULL, `jg_showsearchdownload` int(1) NOT NULL, `jg_showsearchfavourite` int(1) NOT NULL, `jg_search_report_images` int(1) NOT NULL, `jg_showsearcheditorlinks` int(1) NOT NULL, `jg_showallpics` int(1) NOT NULL, `jg_showallhits` int(1) NOT NULL, `jg_showbacklink` int(1) NOT NULL, `jg_suppresscredits` int(1) NOT NULL, `jg_showuserpanel` int(1) NOT NULL, `jg_showuserpanel_hint` int(1) NOT NULL, `jg_showuserpanel_unreg` int(1) NOT NULL, `jg_showallpicstoadmin` int(1) NOT NULL, `jg_showminithumbs` int(1) NOT NULL, `jg_openjs_padding` int(3) NOT NULL, `jg_openjs_background` varchar(12) NOT NULL, `jg_dhtml_border` varchar(12) NOT NULL, `jg_show_title_in_popup` int(1) NOT NULL, `jg_show_description_in_popup` int(1) NOT NULL, `jg_lightbox_speed` int(3) NOT NULL, `jg_lightbox_slide_all` int(1) NOT NULL, `jg_resize_js_image` int(1) NOT NULL, `jg_disable_rightclick_original` int(1) NOT NULL, `jg_showgallerysubhead` int(1) NOT NULL, `jg_showallcathead` int(1) NOT NULL, `jg_colcat` int(1) NOT NULL, `jg_catperpage` int(1) NOT NULL, `jg_ordercatbyalpha` int(1) NOT NULL, `jg_showgallerypagenav` int(1) NOT NULL, `jg_showcatcount` int(1) NOT NULL, `jg_showcatthumb` int(1) NOT NULL, `jg_showrandomcatthumb` int(1) NOT NULL, `jg_ctalign` int(1) NOT NULL, `jg_showtotalcatimages` int(1) NOT NULL, `jg_showtotalcathits` int(1) NOT NULL, `jg_showcatasnew` int(1) NOT NULL, `jg_catdaysnew` int(3) NOT NULL, `jg_showdescriptioningalleryview` int(1) NOT NULL, `jg_uploadicongallery` int(1) NOT NULL, `jg_showsubsingalleryview` int(1) NOT NULL, `jg_category_rss` int(9) NOT NULL, `jg_category_rss_icon` varchar(10) NOT NULL, `jg_uploadiconcategory` int(1) NOT NULL, `jg_showcathead` int(1) NOT NULL, `jg_usercatorder` int(1) NOT NULL, `jg_usercatorderlist` varchar(50) NOT NULL, `jg_showcatdescriptionincat` int(1) NOT NULL, `jg_showpagenav` int(1) NOT NULL, `jg_showpiccount` int(1) NOT NULL, `jg_perpage` int(3) NOT NULL, `jg_catthumbalign` int(1) NOT NULL, `jg_colnumb` int(3) NOT NULL, `jg_detailpic_open` varchar(50) NOT NULL, `jg_lightboxbigpic` int(1) NOT NULL, `jg_showtitle` int(1) NOT NULL, `jg_showpicasnew` int(1) NOT NULL, `jg_daysnew` int(3) NOT NULL, `jg_showhits` int(1) NOT NULL, `jg_showdownloads` int(1) NOT NULL, `jg_showauthor` int(1) NOT NULL, `jg_showowner` int(1) NOT NULL, `jg_showcatcom` int(1) NOT NULL, `jg_showcatrate` int(1) NOT NULL, `jg_showcatdescription` int(1) NOT NULL, `jg_showcategorydownload` int(1) NOT NULL, `jg_showcategoryfavourite` int(1) NOT NULL, `jg_category_report_images` int(1) NOT NULL, `jg_showcategoryeditorlinks` int(1) NOT NULL, `jg_showsubcathead` int(1) NOT NULL, `jg_showsubcatcount` int(1) NOT NULL, `jg_colsubcat` int(3) NOT NULL, `jg_subperpage` int(3) NOT NULL, `jg_showpagenavsubs` int(1) NOT NULL, `jg_subcatthumbalign` int(1) NOT NULL, `jg_showsubthumbs` int(1) NOT NULL, `jg_showrandomsubthumb` int(1) NOT NULL, `jg_showdescriptionincategoryview` int(1) NOT NULL, `jg_ordersubcatbyalpha` int(1) NOT NULL, `jg_showtotalsubcatimages` int(1) NOT NULL, `jg_showtotalsubcathits` int(1) NOT NULL, `jg_uploadiconsubcat` int(1) NOT NULL, `jg_showdetailpage` int(1) NOT NULL, `jg_disabledetailpage` int(1) NOT NULL, `jg_showdetailnumberofpics` int(1) NOT NULL, `jg_cursor_navigation` int(1) NOT NULL, `jg_disable_rightclick_detail` int(1) NOT NULL, `jg_detail_report_images` int(1) NOT NULL, `jg_showdetaileditorlinks` int(1) NOT NULL, `jg_showdetailtitle` int(1) NOT NULL, `jg_showdetail` int(1) NOT NULL, `jg_showdetailaccordion` int(1) NOT NULL, `jg_accordionduration` int(3) NOT NULL, `jg_accordiondisplay` int(3) NOT NULL, `jg_accordionopacity` int(1) NOT NULL, `jg_accordionalwayshide` int(1) NOT NULL, `jg_accordioninitialeffect` int(1) NOT NULL, `jg_showdetaildescription` int(1) NOT NULL, `jg_showdetaildatum` int(1) NOT NULL, `jg_showdetailhits` int(1) NOT NULL, `jg_showdetaildownloads` int(1) NOT NULL, `jg_showdetailrating` int(1) NOT NULL, `jg_showdetailfilesize` int(1) NOT NULL, `jg_showdetailauthor` int(1) NOT NULL, `jg_showoriginalfilesize` int(1) NOT NULL, `jg_showdetaildownload` int(1) NOT NULL, `jg_watermark` int(1) NOT NULL, `jg_watermarkpos` int(1) NOT NULL, `jg_bigpic` int(1) NOT NULL, `jg_bigpic_unreg` int(1) NOT NULL, `jg_bigpic_open` varchar(50) NOT NULL, `jg_bbcodelink` int(1) NOT NULL, `jg_showcommentsunreg` int(1) NOT NULL, `jg_showcommentsarea` int(1) NOT NULL, `jg_send2friend` int(1) NOT NULL, `jg_minis` int(1) NOT NULL, `jg_motionminis` int(1) NOT NULL, `jg_motionminiWidth` int(3) NOT NULL, `jg_motionminiHeight` int(3) NOT NULL, `jg_miniWidth` int(3) NOT NULL, `jg_miniHeight` int(3) NOT NULL, `jg_minisprop` int(1) NOT NULL, `jg_nameshields` int(1) NOT NULL, `jg_nameshields_others` int(1) NOT NULL, `jg_nameshields_unreg` int(1) NOT NULL, `jg_show_nameshields_unreg` int(1) NOT NULL, `jg_nameshields_height` int(3) NOT NULL, `jg_nameshields_width` int(3) NOT NULL, `jg_slideshow` int(1) NOT NULL, `jg_slideshow_timer` int(3) NOT NULL, `jg_slideshow_transition` int(1) NOT NULL, `jg_slideshow_transtime` int(3) NOT NULL, `jg_slideshow_maxdimauto` int(1) NOT NULL, `jg_slideshow_width` int(3) NOT NULL, `jg_slideshow_heigth` int(3) NOT NULL, `jg_slideshow_infopane` int(1) NOT NULL, `jg_slideshow_carousel` int(1) NOT NULL, `jg_slideshow_arrows` int(1) NOT NULL, `jg_slideshow_repeat` int(1) NOT NULL, `jg_showexifdata` int(1) NOT NULL, `jg_showgeotagging` int(1) NOT NULL, `jg_geotaggingkey` text NOT NULL, `jg_subifdtags` text NOT NULL, `jg_ifdotags` text NOT NULL, `jg_gpstags` text NOT NULL, `jg_showiptcdata` int(1) NOT NULL, `jg_iptctags` text NOT NULL, `jg_showtoplist` int(1) NOT NULL, `jg_toplist` int(3) NOT NULL, `jg_topthumbalign` int(1) NOT NULL, `jg_toptextalign` int(1) NOT NULL, `jg_toplistcols` int(3) NOT NULL, `jg_whereshowtoplist` int(1) NOT NULL, `jg_showrate` int(1) NOT NULL, `jg_showlatest` int(1) NOT NULL, `jg_showcom` int(1) NOT NULL, `jg_showthiscomment` int(1) NOT NULL, `jg_showmostviewed` int(1) NOT NULL, `jg_showtoplistdownload` int(1) NOT NULL, `jg_showtoplistfavourite` int(1) NOT NULL, `jg_toplist_report_images` int(1) NOT NULL, `jg_showtoplisteditorlinks` int(1) NOT NULL, `jg_favourites` int(1) NOT NULL, `jg_showdetailfavourite` int(1) NOT NULL, `jg_favouritesshownotauth` int(1) NOT NULL, `jg_maxfavourites` int(5) NOT NULL, `jg_zipdownload` int(1) NOT NULL, `jg_usefavouritesforpubliczip` int(1) NOT NULL, `jg_usefavouritesforzip` int(1) NOT NULL, `jg_allimagesofcategory` int(1) NOT NULL, `jg_showfavouritesdownload` int(1) NOT NULL, `jg_showfavouriteseditorlinks` int(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `nn34x_joomgallery_config` -- INSERT INTO `nn34x_joomgallery_config` (`id`, `group_id`, `ordering`, `jg_pathimages`, `jg_pathoriginalimages`, `jg_paththumbs`, `jg_pathftpupload`, `jg_pathtemp`, `jg_wmpath`, `jg_wmfile`, `jg_use_real_paths`, `jg_checkupdate`, `jg_filenamewithjs`, `jg_filenamereplace`, `jg_thumbcreation`, `jg_fastgd2thumbcreation`, `jg_impath`, `jg_resizetomaxwidth`, `jg_maxwidth`, `jg_picturequality`, `jg_useforresizedirection`, `jg_cropposition`, `jg_thumbwidth`, `jg_thumbheight`, `jg_thumbquality`, `jg_uploadorder`, `jg_useorigfilename`, `jg_filenamenumber`, `jg_delete_original`, `jg_msg_upload_type`, `jg_msg_upload_recipients`, `jg_msg_download_type`, `jg_msg_download_recipients`, `jg_msg_zipdownload`, `jg_msg_comment_type`, `jg_msg_comment_recipients`, `jg_msg_comment_toowner`, `jg_msg_nametag_type`, `jg_msg_nametag_recipients`, `jg_msg_nametag_totaggeduser`, `jg_msg_nametag_toowner`, `jg_msg_report_type`, `jg_msg_report_recipients`, `jg_msg_report_toowner`, `jg_msg_rejectimg_type`, `jg_msg_global_from`, `jg_realname`, `jg_cooliris`, `jg_coolirislink`, `jg_contentpluginsenabled`, `jg_itemid`, `jg_ajaxcategoryselection`, `jg_disableunrequiredchecks`, `jg_userspace`, `jg_useruploaddefaultcat`, `jg_approve`, `jg_unregistered_permissions`, `jg_maxusercat`, `jg_maxuserimage`, `jg_maxuserimage_timespan`, `jg_maxfilesize`, `jg_usercatacc`, `jg_usercatthumbalign`, `jg_useruploadsingle`, `jg_maxuploadfields`, `jg_useruploadajax`, `jg_useruploadbatch`, `jg_useruploadjava`, `jg_useruseorigfilename`, `jg_useruploadnumber`, `jg_special_gif_upload`, `jg_delete_original_user`, `jg_newpiccopyright`, `jg_newpicnote`, `jg_redirect_after_upload`, `jg_download`, `jg_download_unreg`, `jg_download_hint`, `jg_downloadfile`, `jg_downloadwithwatermark`, `jg_showrating`, `jg_maxvoting`, `jg_ratingcalctype`, `jg_ratingdisplaytype`, `jg_ajaxrating`, `jg_votingonlyonce`, `jg_votingonlyreg`, `jg_showcomment`, `jg_anoncomment`, `jg_namedanoncomment`, `jg_anonapprovecom`, `jg_approvecom`, `jg_bbcodesupport`, `jg_smiliesupport`, `jg_anismilie`, `jg_smiliescolor`, `jg_report_images`, `jg_report_unreg`, `jg_report_hint`, `jg_alternative_layout`, `jg_anchors`, `jg_tooltips`, `jg_dyncrop`, `jg_dyncropposition`, `jg_dyncropwidth`, `jg_dyncropheight`, `jg_dyncropbgcol`, `jg_hideemptycats`, `jg_skipcatview`, `jg_imgalign`, `jg_showrestrictedcats`, `jg_showrestrictedhint`, `jg_firstorder`, `jg_secondorder`, `jg_thirdorder`, `jg_pagetitle_cat`, `jg_pagetitle_detail`, `jg_showgalleryhead`, `jg_showpathway`, `jg_completebreadcrumbs`, `jg_search`, `jg_searchcols`, `jg_searchthumbalign`, `jg_searchtextalign`, `jg_showsearchdownload`, `jg_showsearchfavourite`, `jg_search_report_images`, `jg_showsearcheditorlinks`, `jg_showallpics`, `jg_showallhits`, `jg_showbacklink`, `jg_suppresscredits`, `jg_showuserpanel`, `jg_showuserpanel_hint`, `jg_showuserpanel_unreg`, `jg_showallpicstoadmin`, `jg_showminithumbs`, `jg_openjs_padding`, `jg_openjs_background`, `jg_dhtml_border`, `jg_show_title_in_popup`, `jg_show_description_in_popup`, `jg_lightbox_speed`, `jg_lightbox_slide_all`, `jg_resize_js_image`, `jg_disable_rightclick_original`, `jg_showgallerysubhead`, `jg_showallcathead`, `jg_colcat`, `jg_catperpage`, `jg_ordercatbyalpha`, `jg_showgallerypagenav`, `jg_showcatcount`, `jg_showcatthumb`, `jg_showrandomcatthumb`, `jg_ctalign`, `jg_showtotalcatimages`, `jg_showtotalcathits`, `jg_showcatasnew`, `jg_catdaysnew`, `jg_showdescriptioningalleryview`, `jg_uploadicongallery`, `jg_showsubsingalleryview`, `jg_category_rss`, `jg_category_rss_icon`, `jg_uploadiconcategory`, `jg_showcathead`, `jg_usercatorder`, `jg_usercatorderlist`, `jg_showcatdescriptionincat`, `jg_showpagenav`, `jg_showpiccount`, `jg_perpage`, `jg_catthumbalign`, `jg_colnumb`, `jg_detailpic_open`, `jg_lightboxbigpic`, `jg_showtitle`, `jg_showpicasnew`, `jg_daysnew`, `jg_showhits`, `jg_showdownloads`, `jg_showauthor`, `jg_showowner`, `jg_showcatcom`, `jg_showcatrate`, `jg_showcatdescription`, `jg_showcategorydownload`, `jg_showcategoryfavourite`, `jg_category_report_images`, `jg_showcategoryeditorlinks`, `jg_showsubcathead`, `jg_showsubcatcount`, `jg_colsubcat`, `jg_subperpage`, `jg_showpagenavsubs`, `jg_subcatthumbalign`, `jg_showsubthumbs`, `jg_showrandomsubthumb`, `jg_showdescriptionincategoryview`, `jg_ordersubcatbyalpha`, `jg_showtotalsubcatimages`, `jg_showtotalsubcathits`, `jg_uploadiconsubcat`, `jg_showdetailpage`, `jg_disabledetailpage`, `jg_showdetailnumberofpics`, `jg_cursor_navigation`, `jg_disable_rightclick_detail`, `jg_detail_report_images`, `jg_showdetaileditorlinks`, `jg_showdetailtitle`, `jg_showdetail`, `jg_showdetailaccordion`, `jg_accordionduration`, `jg_accordiondisplay`, `jg_accordionopacity`, `jg_accordionalwayshide`, `jg_accordioninitialeffect`, `jg_showdetaildescription`, `jg_showdetaildatum`, `jg_showdetailhits`, `jg_showdetaildownloads`, `jg_showdetailrating`, `jg_showdetailfilesize`, `jg_showdetailauthor`, `jg_showoriginalfilesize`, `jg_showdetaildownload`, `jg_watermark`, `jg_watermarkpos`, `jg_bigpic`, `jg_bigpic_unreg`, `jg_bigpic_open`, `jg_bbcodelink`, `jg_showcommentsunreg`, `jg_showcommentsarea`, `jg_send2friend`, `jg_minis`, `jg_motionminis`, `jg_motionminiWidth`, `jg_motionminiHeight`, `jg_miniWidth`, `jg_miniHeight`, `jg_minisprop`, `jg_nameshields`, `jg_nameshields_others`, `jg_nameshields_unreg`, `jg_show_nameshields_unreg`, `jg_nameshields_height`, `jg_nameshields_width`, `jg_slideshow`, `jg_slideshow_timer`, `jg_slideshow_transition`, `jg_slideshow_transtime`, `jg_slideshow_maxdimauto`, `jg_slideshow_width`, `jg_slideshow_heigth`, `jg_slideshow_infopane`, `jg_slideshow_carousel`, `jg_slideshow_arrows`, `jg_slideshow_repeat`, `jg_showexifdata`, `jg_showgeotagging`, `jg_geotaggingkey`, `jg_subifdtags`, `jg_ifdotags`, `jg_gpstags`, `jg_showiptcdata`, `jg_iptctags`, `jg_showtoplist`, `jg_toplist`, `jg_topthumbalign`, `jg_toptextalign`, `jg_toplistcols`, `jg_whereshowtoplist`, `jg_showrate`, `jg_showlatest`, `jg_showcom`, `jg_showthiscomment`, `jg_showmostviewed`, `jg_showtoplistdownload`, `jg_showtoplistfavourite`, `jg_toplist_report_images`, `jg_showtoplisteditorlinks`, `jg_favourites`, `jg_showdetailfavourite`, `jg_favouritesshownotauth`, `jg_maxfavourites`, `jg_zipdownload`, `jg_usefavouritesforpubliczip`, `jg_usefavouritesforzip`, `jg_allimagesofcategory`, `jg_showfavouritesdownload`, `jg_showfavouriteseditorlinks`) VALUES (1, 1, 1, 'images/joomgallery/details/', 'images/joomgallery/originals/', 'images/joomgallery/thumbnails/', 'administrator/components/com_joomgallery/temp/ftp_upload/', 'administrator/components/com_joomgallery/temp/', 'media/joomgallery/images/', 'watermark.png', 0, 1, 1, 'Š|S, Œ|O, Ž|Z, š|s, œ|oe, ž|z, Ÿ|Y, ¥|Y, µ|u, À|A, Á|A, Â|A, Ã|A, Ä|AE, Å|A, Æ|A, Ç|C, È|E, É|E, Ê|E, Ë|E, Ì|I, Í|I, Î|I, Ï|I, Ð|D, Ñ|N, Ò|O, Ó|O, Ô|O, Õ|O, Ö|OE, Ø|O, Ù|U, Ú|U, Û|U, Ü|UE, Ý|Y, à|a, á|a, â|a, ã|a, ä|ae, å|a, æ|a, ç|c, è|e, é|e, ê|e, ë|e, ì|i, í|i, î|i, ï|i, ð|o, ñ|n, ò|o, ó|o, ô|o, õ|o, ö|oe, ø|o, ù|u, ú|u, û|u, ü|ue, ý|y, ÿ|y, ß|ss, ă|a, ş|s, ţ|t, ț|t, Ț|T, Ș|S, ș|s, Ş|S', 'gd2', 1, '', 1, 400, 100, 0, 2, 133, 100, 100, 2, 0, 1, 0, 2, '-1', 2, '-1', 0, 2, '-1', 0, 2, '-1', 1, 0, 2, '-1', 0, 1, 0, 0, 0, 0, 1, '', 0, 0, 1, 0, 0, 0, 10, 500, 0, 2000000, 1, 1, 1, 3, 1, 1, 1, 0, 1, 1, 2, 1, 1, 1, 1, 1, 1, 2, 1, 1, 5, 0, 0, 0, 1, 0, 1, 1, 1, 1, 0, 1, 1, 0, 'grey', 1, 1, 1, '', 1, 2, 0, 2, 100, 100, '#ffffff', 0, 0, 0, 1, 1, 'ordering ASC', 'imgdate DESC', 'imgtitle DESC', '#page_title - [! COM_JOOMGALLERY_COMMON_CATEGORY!]: #cat', '#page_title - [! COM_JOOMGALLERY_COMMON_CATEGORY!]: #cat - [! COM_JOOMGALLERY_COMMON_IMAGE!]: #img', 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 3, 1, 3, 1, 1, 1, 0, 1, 1, 10, '#ffffff', '#808080', 1, 1, 5, 1, 1, 1, 1, 1, 3, 9, 0, 1, 1, 1, 3, 1, 1, 1, 1, 7, 1, 0, 0, 10, 'rss', 0, 1, 1, 'date,title', 1, 2, 1, 8, 1, 2, '0', 1, 1, 1, 10, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 1, 2, 8, 1, 3, 2, 3, 1, 0, 1, 1, 0, 1, 1, 1, 1, 0, 1, 1, 1, 1, 0, 300, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 9, 1, 1, '6', 3, 1, 2, 1, 1, 2, 400, 50, 28, 28, 2, 0, 1, 1, 0, 10, 6, 1, 6000, 0, 2000, 0, 640, 480, 0, 0, 0, 0, 0, 0, '', '', '', '', 0, '', 2, 12, 1, 1, 1, 0, 1, 1, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_countstop` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_countstop` ( `cspicid` int(11) NOT NULL DEFAULT '0', `csip` varchar(20) NOT NULL, `cssessionid` varchar(200) DEFAULT NULL, `cstime` datetime DEFAULT NULL, KEY `idx_cspicid` (`cspicid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_image_details` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_image_details` ( `id` int(11) NOT NULL, `details_key` varchar(255) NOT NULL, `details_value` text NOT NULL, `ordering` int(11) NOT NULL, PRIMARY KEY (`id`,`details_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_maintenance` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_maintenance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `refid` int(11) NOT NULL, `catid` int(11) NOT NULL, `owner` int(11) NOT NULL, `title` text NOT NULL, `thumb` varchar(255) NOT NULL, `img` varchar(255) NOT NULL, `orig` varchar(255) NOT NULL, `thumborphan` int(11) NOT NULL, `imgorphan` int(11) NOT NULL, `origorphan` int(11) NOT NULL, `type` tinyint(1) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_nameshields` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_nameshields` ( `nid` int(11) NOT NULL AUTO_INCREMENT, `npicid` int(11) NOT NULL DEFAULT '0', `nuserid` int(11) unsigned NOT NULL DEFAULT '0', `nxvalue` int(11) NOT NULL DEFAULT '0', `nyvalue` int(11) NOT NULL DEFAULT '0', `by` int(11) NOT NULL DEFAULT '0', `nuserip` varchar(15) NOT NULL DEFAULT '0', `ndate` datetime NOT NULL, `nzindex` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`nid`), KEY `idx_picid` (`npicid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_orphans` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_orphans` ( `id` int(11) NOT NULL AUTO_INCREMENT, `fullpath` varchar(255) NOT NULL, `type` varchar(7) NOT NULL, `refid` int(11) NOT NULL, `title` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_users` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_users` ( `uid` int(11) NOT NULL AUTO_INCREMENT, `uuserid` int(11) NOT NULL DEFAULT '0', `piclist` text, `layout` int(1) NOT NULL, `time` datetime NOT NULL, `zipname` varchar(70) NOT NULL, PRIMARY KEY (`uid`), KEY `idx_uid` (`uuserid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_joomgallery_votes` -- CREATE TABLE IF NOT EXISTS `nn34x_joomgallery_votes` ( `voteid` int(11) NOT NULL AUTO_INCREMENT, `picid` int(11) NOT NULL DEFAULT '0', `userid` int(11) unsigned NOT NULL DEFAULT '0', `userip` varchar(15) NOT NULL DEFAULT '0', `datevoted` datetime NOT NULL, `vote` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`voteid`), KEY `idx_picid` (`picid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_languages` -- CREATE TABLE IF NOT EXISTS `nn34x_languages` ( `lang_id` int(11) unsigned NOT NULL AUTO_INCREMENT, `lang_code` char(7) NOT NULL, `title` varchar(50) NOT NULL, `title_native` varchar(50) NOT NULL, `sef` varchar(50) NOT NULL, `image` varchar(50) NOT NULL, `description` varchar(512) NOT NULL, `metakey` text NOT NULL, `metadesc` text NOT NULL, `sitename` varchar(1024) NOT NULL DEFAULT '', `published` int(11) NOT NULL DEFAULT '0', `access` int(10) unsigned NOT NULL DEFAULT '0', `ordering` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`lang_id`), UNIQUE KEY `idx_sef` (`sef`), UNIQUE KEY `idx_image` (`image`), UNIQUE KEY `idx_langcode` (`lang_code`), KEY `idx_access` (`access`), KEY `idx_ordering` (`ordering`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `nn34x_languages` -- INSERT INTO `nn34x_languages` (`lang_id`, `lang_code`, `title`, `title_native`, `sef`, `image`, `description`, `metakey`, `metadesc`, `sitename`, `published`, `access`, `ordering`) VALUES (1, 'en-GB', 'English (UK)', 'English (UK)', 'en', 'en', '', '', '', '', 1, 1, 1); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_menu` -- CREATE TABLE IF NOT EXISTS `nn34x_menu` ( `id` int(11) NOT NULL AUTO_INCREMENT, `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype', `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.', `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The SEF alias of the menu item.', `note` varchar(255) NOT NULL DEFAULT '', `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.', `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.', `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator', `published` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The published state of the menu link.', `parent_id` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'The parent menu item in the menu tree.', `level` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The relative level in the tree.', `component_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__extensions.id', `checked_out` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to #__users.id', `checked_out_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'The time the menu item was checked out.', `browserNav` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'The click behaviour of the link.', `access` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'The access level required to view the menu item.', `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.', `template_style_id` int(10) unsigned NOT NULL DEFAULT '0', `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `home` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Indicates if this menu item is the home or default page.', `language` char(7) NOT NULL DEFAULT '', `client_id` tinyint(4) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`,`language`), KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`), KEY `idx_menutype` (`menutype`), KEY `idx_left_right` (`lft`,`rgt`), KEY `idx_alias` (`alias`), KEY `idx_path` (`path`(255)), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=120 ; -- -- Dumping data for table `nn34x_menu` -- INSERT INTO `nn34x_menu` (`id`, `menutype`, `title`, `alias`, `note`, `path`, `link`, `type`, `published`, `parent_id`, `level`, `component_id`, `checked_out`, `checked_out_time`, `browserNav`, `access`, `img`, `template_style_id`, `params`, `lft`, `rgt`, `home`, `language`, `client_id`) VALUES (1, '', 'Menu_Item_Root', 'root', '', '', '', '', 1, 0, 0, 0, 0, '0000-00-00 00:00:00', 0, 0, '', 0, '', 0, 85, 0, '*', 0), (2, 'menu', 'com_banners', 'Banners', '', 'Banners', 'index.php?option=com_banners', 'component', 0, 1, 1, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 1, 10, 0, '*', 1), (3, 'menu', 'com_banners', 'Banners', '', 'Banners/Banners', 'index.php?option=com_banners', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners', 0, '', 2, 3, 0, '*', 1), (4, 'menu', 'com_banners_categories', 'Categories', '', 'Banners/Categories', 'index.php?option=com_categories&extension=com_banners', 'component', 0, 2, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-cat', 0, '', 4, 5, 0, '*', 1), (5, 'menu', 'com_banners_clients', 'Clients', '', 'Banners/Clients', 'index.php?option=com_banners&view=clients', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-clients', 0, '', 6, 7, 0, '*', 1), (6, 'menu', 'com_banners_tracks', 'Tracks', '', 'Banners/Tracks', 'index.php?option=com_banners&view=tracks', 'component', 0, 2, 2, 4, 0, '0000-00-00 00:00:00', 0, 0, 'class:banners-tracks', 0, '', 8, 9, 0, '*', 1), (7, 'menu', 'com_contact', 'Contacts', '', 'Contacts', 'index.php?option=com_contact', 'component', 0, 1, 1, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 11, 16, 0, '*', 1), (8, 'menu', 'com_contact', 'Contacts', '', 'Contacts/Contacts', 'index.php?option=com_contact', 'component', 0, 7, 2, 8, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact', 0, '', 12, 13, 0, '*', 1), (9, 'menu', 'com_contact_categories', 'Categories', '', 'Contacts/Categories', 'index.php?option=com_categories&extension=com_contact', 'component', 0, 7, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:contact-cat', 0, '', 14, 15, 0, '*', 1), (10, 'menu', 'com_messages', 'Messaging', '', 'Messaging', 'index.php?option=com_messages', 'component', 0, 1, 1, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages', 0, '', 17, 22, 0, '*', 1), (11, 'menu', 'com_messages_add', 'New Private Message', '', 'Messaging/New Private Message', 'index.php?option=com_messages&task=message.add', 'component', 0, 10, 2, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-add', 0, '', 18, 19, 0, '*', 1), (12, 'menu', 'com_messages_read', 'Read Private Message', '', 'Messaging/Read Private Message', 'index.php?option=com_messages', 'component', 0, 10, 2, 15, 0, '0000-00-00 00:00:00', 0, 0, 'class:messages-read', 0, '', 20, 21, 0, '*', 1), (13, 'menu', 'com_newsfeeds', 'News Feeds', '', 'News Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 1, 1, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 23, 28, 0, '*', 1), (14, 'menu', 'com_newsfeeds_feeds', 'Feeds', '', 'News Feeds/Feeds', 'index.php?option=com_newsfeeds', 'component', 0, 13, 2, 17, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds', 0, '', 24, 25, 0, '*', 1), (15, 'menu', 'com_newsfeeds_categories', 'Categories', '', 'News Feeds/Categories', 'index.php?option=com_categories&extension=com_newsfeeds', 'component', 0, 13, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:newsfeeds-cat', 0, '', 26, 27, 0, '*', 1), (16, 'menu', 'com_redirect', 'Redirect', '', 'Redirect', 'index.php?option=com_redirect', 'component', 0, 1, 1, 24, 0, '0000-00-00 00:00:00', 0, 0, 'class:redirect', 0, '', 29, 30, 0, '*', 1), (17, 'menu', 'com_search', 'Basic Search', '', 'Basic Search', 'index.php?option=com_search', 'component', 0, 1, 1, 19, 0, '0000-00-00 00:00:00', 0, 0, 'class:search', 0, '', 31, 32, 0, '*', 1), (18, 'menu', 'com_weblinks', 'Weblinks', '', 'Weblinks', 'index.php?option=com_weblinks', 'component', 0, 1, 1, 21, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 33, 38, 0, '*', 1), (19, 'menu', 'com_weblinks_links', 'Links', '', 'Weblinks/Links', 'index.php?option=com_weblinks', 'component', 0, 18, 2, 21, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks', 0, '', 34, 35, 0, '*', 1), (20, 'menu', 'com_weblinks_categories', 'Categories', '', 'Weblinks/Categories', 'index.php?option=com_categories&extension=com_weblinks', 'component', 0, 18, 2, 6, 0, '0000-00-00 00:00:00', 0, 0, 'class:weblinks-cat', 0, '', 36, 37, 0, '*', 1), (21, 'menu', 'com_finder', 'Smart Search', '', 'Smart Search', 'index.php?option=com_finder', 'component', 0, 1, 1, 27, 0, '0000-00-00 00:00:00', 0, 0, 'class:finder', 0, '', 39, 40, 0, '*', 1), (22, 'menu', 'com_joomlaupdate', 'Joomla! Update', '', 'Joomla! Update', 'index.php?option=com_joomlaupdate', 'component', 1, 1, 1, 28, 0, '0000-00-00 00:00:00', 0, 0, 'class:joomlaupdate', 0, '', 41, 42, 0, '*', 1), (23, 'main', 'com_tags', 'Tags', '', 'Tags', 'index.php?option=com_tags', 'component', 0, 1, 1, 29, 0, '0000-00-00 00:00:00', 0, 1, 'class:tags', 0, '', 43, 44, 0, '', 1), (24, 'main', 'com_postinstall', 'Post-installation messages', '', 'Post-installation messages', 'index.php?option=com_postinstall', 'component', 0, 1, 1, 32, 0, '0000-00-00 00:00:00', 0, 1, 'class:postinstall', 0, '', 45, 46, 0, '*', 1), (101, 'mainmenu', 'Domov', 'home', '', 'home', 'index.php?option=com_content&view=article&id=1', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"show_title":"","link_titles":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_vote":"","show_tags":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_hits":"","show_noauth":"","urls_position":"","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":1,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 47, 48, 1, '*', 0), (102, 'mainmenu', 'Prispevki', 'prispevki', '', 'prispevki', 'index.php?option=com_content&view=category&layout=blog&id=9', 'component', 1, 1, 1, 22, 0, '0000-00-00 00:00:00', 0, 2, '', 0, '{"layout_type":"blog","show_category_heading_title_text":"","show_category_title":"","show_description":"","show_description_image":"","maxLevel":"","show_empty_categories":"","show_no_articles":"","show_subcat_desc":"","show_cat_num_articles":"","page_subheading":"","num_leading_articles":"","num_intro_articles":"","num_columns":"","num_links":"","multi_column_order":"","show_subcategory_content":"","orderby_pri":"","orderby_sec":"alpha","order_date":"created","show_pagination":"","show_pagination_results":"","show_title":"","link_titles":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_vote":"","show_readmore":"","show_readmore_title":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_hits":"","show_noauth":"","show_feed_link":"","feed_summary":"","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 49, 54, 0, '*', 0), (103, 'mainmenu', 'Galerija', 'galerija', '', 'galerija', 'index.php?option=com_joomgallery&view=category&catid=2', 'component', 1, 1, 1, 10001, 0, '0000-00-00 00:00:00', 0, 2, '', 0, '{"disable_global_info":"0","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 55, 56, 0, '*', 0), (104, 'main', 'COM_JOOMGALLERY', 'com-joomgallery', '', 'com-joomgallery', 'index.php?option=com_joomgallery', 'component', 0, 1, 1, 10001, 0, '0000-00-00 00:00:00', 0, 1, '../media/joomgallery/images/joom_main.png', 0, '', 57, 84, 0, '', 1), (105, 'main', 'COM_JOOMGALLERY_CATEGORY_MANAGER', 'com-joomgallery-category-manager', '', 'com-joomgallery/com-joomgallery-category-manager', 'index.php?option=com_joomgallery&controller=categories', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_categories.png', 0, '', 58, 59, 0, '', 1), (106, 'main', 'COM_JOOMGALLERY_IMAGE_MANAGER', 'com-joomgallery-image-manager', '', 'com-joomgallery/com-joomgallery-image-manager', 'index.php?option=com_joomgallery&controller=images', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_pictures.png', 0, '', 60, 61, 0, '', 1), (107, 'main', 'COM_JOOMGALLERY_COMMENTS_MANAGER', 'com-joomgallery-comments-manager', '', 'com-joomgallery/com-joomgallery-comments-manager', 'index.php?option=com_joomgallery&controller=comments', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_comments.png', 0, '', 62, 63, 0, '', 1), (108, 'main', 'COM_JOOMGALLERY_IMAGE_UPLOAD', 'com-joomgallery-image-upload', '', 'com-joomgallery/com-joomgallery-image-upload', 'index.php?option=com_joomgallery&controller=upload', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_pictureupload.png', 0, '', 64, 65, 0, '', 1), (109, 'main', 'COM_JOOMGALLERY_AJAX_UPLOAD', 'com-joomgallery-ajax-upload', '', 'com-joomgallery/com-joomgallery-ajax-upload', 'index.php?option=com_joomgallery&controller=ajaxupload', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_ajaxupload.png', 0, '', 66, 67, 0, '', 1), (110, 'main', 'COM_JOOMGALLERY_BATCH_UPLOAD', 'com-joomgallery-batch-upload', '', 'com-joomgallery/com-joomgallery-batch-upload', 'index.php?option=com_joomgallery&controller=batchupload', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_batchupload.png', 0, '', 68, 69, 0, '', 1), (111, 'main', 'COM_JOOMGALLERY_FTP_UPLOAD', 'com-joomgallery-ftp-upload', '', 'com-joomgallery/com-joomgallery-ftp-upload', 'index.php?option=com_joomgallery&controller=ftpupload', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_ftpupload.png', 0, '', 70, 71, 0, '', 1), (112, 'main', 'COM_JOOMGALLERY_JAVA_UPLOAD', 'com-joomgallery-java-upload', '', 'com-joomgallery/com-joomgallery-java-upload', 'index.php?option=com_joomgallery&controller=jupload', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_jupload.png', 0, '', 72, 73, 0, '', 1), (113, 'main', 'COM_JOOMGALLERY_CONFIGURATION_MANAGER', 'com-joomgallery-configuration-manager', '', 'com-joomgallery/com-joomgallery-configuration-manager', 'index.php?option=com_joomgallery&controller=config', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_config.png', 0, '', 74, 75, 0, '', 1), (114, 'main', 'COM_JOOMGALLERY_CUSTOMIZE_CSS', 'com-joomgallery-customize-css', '', 'com-joomgallery/com-joomgallery-customize-css', 'index.php?option=com_joomgallery&controller=cssedit', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_css.png', 0, '', 76, 77, 0, '', 1), (115, 'main', 'COM_JOOMGALLERY_MIGRATION_MANAGER', 'com-joomgallery-migration-manager', '', 'com-joomgallery/com-joomgallery-migration-manager', 'index.php?option=com_joomgallery&controller=migration', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_migration.png', 0, '', 78, 79, 0, '', 1), (116, 'main', 'COM_JOOMGALLERY_MAINTENANCE_MANAGER', 'com-joomgallery-maintenance-manager', '', 'com-joomgallery/com-joomgallery-maintenance-manager', 'index.php?option=com_joomgallery&controller=maintenance', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_maintenance.png', 0, '', 80, 81, 0, '', 1), (117, 'main', 'COM_JOOMGALLERY_HELP', 'com-joomgallery-help', '', 'com-joomgallery/com-joomgallery-help', 'index.php?option=com_joomgallery&controller=help', 'component', 0, 104, 2, 10001, 0, '0000-00-00 00:00:00', 0, 1, 'media/joomgallery/images/joom_information.png', 0, '', 82, 83, 0, '', 1), (118, 'mainmenu', 'Vsi prispevki', 'vsi-prispevki', '', 'prispevki/vsi-prispevki', 'index.php?option=com_content&view=featured', 'component', 1, 102, 2, 22, 324, '2014-05-21 14:31:07', 0, 1, '', 0, '{"featured_categories":[""],"layout_type":"blog","num_leading_articles":"","num_intro_articles":"","num_columns":"","num_links":"","multi_column_order":"","orderby_pri":"","orderby_sec":"","order_date":"","show_pagination":"","show_pagination_results":"","show_title":"","link_titles":"","show_intro":"","info_block_position":"","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_vote":"","show_readmore":"","show_readmore_title":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_hits":"","show_noauth":"","show_feed_link":"","feed_summary":"","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 50, 51, 0, '*', 0), (119, 'mainmenu', 'Nov prispevek', 'nov-prispevek', '', 'prispevki/nov-prispevek', 'index.php?option=com_content&view=form&layout=edit', 'component', 1, 102, 2, 22, 0, '0000-00-00 00:00:00', 0, 1, '', 0, '{"enable_category":"0","catid":"2","menu-anchor_title":"","menu-anchor_css":"","menu_image":"","menu_text":1,"page_title":"","show_page_heading":0,"page_heading":"","pageclass_sfx":"","menu-meta_description":"","menu-meta_keywords":"","robots":"","secure":0}', 52, 53, 0, '*', 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_menu_types` -- CREATE TABLE IF NOT EXISTS `nn34x_menu_types` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `menutype` varchar(24) NOT NULL, `title` varchar(48) NOT NULL, `description` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_menutype` (`menutype`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `nn34x_menu_types` -- INSERT INTO `nn34x_menu_types` (`id`, `menutype`, `title`, `description`) VALUES (1, 'mainmenu', 'Main Menu', 'The main menu for the site'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_messages` -- CREATE TABLE IF NOT EXISTS `nn34x_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` tinyint(3) unsigned NOT NULL DEFAULT '0', `date_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `state` tinyint(1) NOT NULL DEFAULT '0', `priority` tinyint(1) unsigned NOT NULL DEFAULT '0', `subject` varchar(255) NOT NULL DEFAULT '', `message` text NOT NULL, PRIMARY KEY (`message_id`), KEY `useridto_state` (`user_id_to`,`state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ; -- -- Dumping data for table `nn34x_messages` -- INSERT INTO `nn34x_messages` (`message_id`, `user_id_from`, `user_id_to`, `folder_id`, `date_time`, `state`, `priority`, `subject`, `message`) VALUES (1, 325, 324, 0, '2014-05-21 16:17:35', 0, 0, 'New Article', 'A new Article has been submitted by ''Sara'' entitled ''Premik smetnjakov''.'), (2, 326, 324, 0, '2014-05-21 16:40:14', 0, 0, 'New Article', 'A new Article has been submitted by ''Sandi'' entitled ''Vista ''.'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_messages_cfg` -- CREATE TABLE IF NOT EXISTS `nn34x_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=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_modules` -- CREATE TABLE IF NOT EXISTS `nn34x_modules` ( `id` int(11) NOT NULL AUTO_INCREMENT, `asset_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.', `title` varchar(100) NOT NULL DEFAULT '', `note` varchar(255) NOT NULL DEFAULT '', `content` text NOT NULL, `ordering` int(11) NOT NULL DEFAULT '0', `position` varchar(50) NOT NULL DEFAULT '', `checked_out` int(10) 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', `published` tinyint(1) NOT NULL DEFAULT '0', `module` varchar(50) DEFAULT NULL, `access` int(10) unsigned NOT NULL DEFAULT '0', `showtitle` tinyint(3) unsigned NOT NULL DEFAULT '1', `params` text NOT NULL, `client_id` tinyint(4) NOT NULL DEFAULT '0', `language` char(7) NOT NULL, PRIMARY KEY (`id`), KEY `published` (`published`,`access`), KEY `newsfeeds` (`module`,`published`), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=88 ; -- -- Dumping data for table `nn34x_modules` -- INSERT INTO `nn34x_modules` (`id`, `asset_id`, `title`, `note`, `content`, `ordering`, `position`, `checked_out`, `checked_out_time`, `publish_up`, `publish_down`, `published`, `module`, `access`, `showtitle`, `params`, `client_id`, `language`) VALUES (1, 39, 'Main Menu', '', '', 1, 'menu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_menu', 1, 1, '{"menutype":"mainmenu","base":"","startLevel":"1","endLevel":"0","showAllChildren":"0","tag_id":"","class_sfx":"","window_open":"","layout":"_:default","moduleclass_sfx":"_menu","cache":"1","cache_time":"900","cachemode":"itemid","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}', 0, '*'), (2, 56, 'Login', '', '', 1, 'login', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_login', 1, 1, '', 1, '*'), (3, 57, 'Popular Articles', '', '', 3, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_popular', 3, 1, '{"count":"5","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'), (4, 58, 'Recently Added Articles', '', '', 4, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_latest', 3, 1, '{"count":"5","ordering":"c_dsc","catid":"","user_id":"0","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'), (8, 59, 'Toolbar', '', '', 1, 'toolbar', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_toolbar', 3, 1, '', 1, '*'), (9, 60, 'Quick Icons', '', '', 1, 'icon', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_quickicon', 3, 1, '', 1, '*'), (10, 61, 'Logged-in Users', '', '', 2, 'cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_logged', 3, 1, '{"count":"5","name":"1","layout":"_:default","moduleclass_sfx":"","cache":"0","automatic_title":"1"}', 1, '*'), (12, 62, 'Admin Menu', '', '', 1, 'menu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_menu', 3, 1, '{"layout":"","moduleclass_sfx":"","shownew":"1","showhelp":"1","cache":"0"}', 1, '*'), (13, 63, 'Admin Submenu', '', '', 1, 'submenu', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_submenu', 3, 1, '', 1, '*'), (14, 64, 'User Status', '', '', 2, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_status', 3, 1, '', 1, '*'), (15, 65, 'Title', '', '', 1, 'title', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_title', 3, 1, '', 1, '*'), (16, 50, 'Login Form', '', '', 1, 'right', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_login', 1, 1, '{"pretext":"","posttext":"","login":"","logout":"","greeting":"1","name":"0","usesecure":"0","usetext":"0","layout":"_:default","moduleclass_sfx":"","cache":"0","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}', 0, '*'), (17, 51, 'Breadcrumbs', '', '', 1, 'top', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_breadcrumbs', 1, 1, '{"showHere":"1","showHome":"1","homeText":"","showLast":"1","separator":"","layout":"_:default","moduleclass_sfx":"","cache":"1","cache_time":"900","cachemode":"itemid","module_tag":"div","bootstrap_size":"0","header_tag":"h3","header_class":"","style":"0"}', 0, '*'), (79, 68, 'Multilanguage status', '', '', 1, 'status', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 'mod_multilangstatus', 3, 1, '{"layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'), (86, 69, 'Joomla Version', '', '', 1, 'footer', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_version', 3, 1, '{"format":"short","product":"1","layout":"_:default","moduleclass_sfx":"","cache":"0"}', 1, '*'), (87, 54, 'JoomGallery News', '', '', 1, 'joom_cpanel', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1, 'mod_feed', 1, 1, 'cache=1\n cache_time=15\n moduleclass_sfx=\n rssurl=http://www.en.joomgallery.net/feed/rss.html\n rssrtl=0\n rsstitle=1\n rssdesc=0\n rssimage=1\n rssitems=3\n rssitemdesc=1\n word_count=200', 1, '*'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_modules_menu` -- CREATE TABLE IF NOT EXISTS `nn34x_modules_menu` ( `moduleid` int(11) NOT NULL DEFAULT '0', `menuid` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`moduleid`,`menuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nn34x_modules_menu` -- INSERT INTO `nn34x_modules_menu` (`moduleid`, `menuid`) VALUES (1, 0), (2, 0), (3, 0), (4, 0), (6, 0), (7, 0), (8, 0), (9, 0), (10, 0), (12, 0), (13, 0), (14, 0), (15, 0), (16, 0), (17, 0), (79, 0), (86, 0), (87, 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_newsfeeds` -- CREATE TABLE IF NOT EXISTS `nn34x_newsfeeds` ( `catid` int(11) NOT NULL DEFAULT '0', `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(100) NOT NULL DEFAULT '', `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `link` varchar(200) NOT NULL DEFAULT '', `published` tinyint(1) NOT NULL DEFAULT '0', `numarticles` int(10) unsigned NOT NULL DEFAULT '1', `cache_time` int(10) unsigned NOT NULL DEFAULT '3600', `checked_out` int(10) 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', `access` int(10) unsigned NOT NULL DEFAULT '0', `language` char(7) NOT NULL DEFAULT '', `params` text NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) 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(10) unsigned NOT NULL DEFAULT '0', `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `description` text NOT NULL, `version` int(10) unsigned NOT NULL DEFAULT '1', `hits` int(10) unsigned NOT NULL DEFAULT '0', `images` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`published`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_overrider` -- CREATE TABLE IF NOT EXISTS `nn34x_overrider` ( `id` int(10) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `constant` varchar(255) NOT NULL, `string` text NOT NULL, `file` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_postinstall_messages` -- CREATE TABLE IF NOT EXISTS `nn34x_postinstall_messages` ( `postinstall_message_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `extension_id` bigint(20) NOT NULL DEFAULT '700' COMMENT 'FK to #__extensions', `title_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for the title', `description_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for description', `action_key` varchar(255) NOT NULL DEFAULT '', `language_extension` varchar(255) NOT NULL DEFAULT 'com_postinstall' COMMENT 'Extension holding lang keys', `language_client_id` tinyint(3) NOT NULL DEFAULT '1', `type` varchar(10) NOT NULL DEFAULT 'link' COMMENT 'Message type - message, link, action', `action_file` varchar(255) DEFAULT '' COMMENT 'RAD URI to the PHP file containing action method', `action` varchar(255) DEFAULT '' COMMENT 'Action method name or URL', `condition_file` varchar(255) DEFAULT NULL COMMENT 'RAD URI to file holding display condition method', `condition_method` varchar(255) DEFAULT NULL COMMENT 'Display condition method, must return boolean', `version_introduced` varchar(50) NOT NULL DEFAULT '3.2.0' COMMENT 'Version when this message was introduced', `enabled` tinyint(3) NOT NULL DEFAULT '1', PRIMARY KEY (`postinstall_message_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ; -- -- Dumping data for table `nn34x_postinstall_messages` -- INSERT INTO `nn34x_postinstall_messages` (`postinstall_message_id`, `extension_id`, `title_key`, `description_key`, `action_key`, `language_extension`, `language_client_id`, `type`, `action_file`, `action`, `condition_file`, `condition_method`, `version_introduced`, `enabled`) VALUES (1, 700, 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_TITLE', 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_BODY', 'PLG_TWOFACTORAUTH_TOTP_POSTINSTALL_ACTION', 'plg_twofactorauth_totp', 1, 'action', 'site://plugins/twofactorauth/totp/postinstall/actions.php', 'twofactorauth_postinstall_action', 'site://plugins/twofactorauth/totp/postinstall/actions.php', 'twofactorauth_postinstall_condition', '3.2.0', 1), (2, 700, 'COM_CPANEL_MSG_EACCELERATOR_TITLE', 'COM_CPANEL_MSG_EACCELERATOR_BODY', 'COM_CPANEL_MSG_EACCELERATOR_BUTTON', 'com_cpanel', 1, 'action', 'admin://components/com_admin/postinstall/eaccelerator.php', 'admin_postinstall_eaccelerator_action', 'admin://components/com_admin/postinstall/eaccelerator.php', 'admin_postinstall_eaccelerator_condition', '3.2.0', 1), (3, 700, 'COM_CPANEL_WELCOME_BEGINNERS_TITLE', 'COM_CPANEL_WELCOME_BEGINNERS_MESSAGE', '', 'com_cpanel', 1, 'message', '', '', '', '', '3.2.0', 1), (4, 700, 'COM_CPANEL_MSG_PHPVERSION_TITLE', 'COM_CPANEL_MSG_PHPVERSION_BODY', '', 'com_cpanel', 1, 'message', '', '', 'admin://components/com_admin/postinstall/phpversion.php', 'admin_postinstall_phpversion_condition', '3.2.2', 1); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_redirect_links` -- CREATE TABLE IF NOT EXISTS `nn34x_redirect_links` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `old_url` varchar(255) NOT NULL, `new_url` varchar(255) NOT NULL, `referer` varchar(150) NOT NULL, `comment` varchar(255) NOT NULL, `hits` int(10) unsigned NOT NULL DEFAULT '0', `published` tinyint(4) NOT NULL, `created_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), UNIQUE KEY `idx_link_old` (`old_url`), KEY `idx_link_modifed` (`modified_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_schemas` -- CREATE TABLE IF NOT EXISTS `nn34x_schemas` ( `extension_id` int(11) NOT NULL, `version_id` varchar(20) NOT NULL, PRIMARY KEY (`extension_id`,`version_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nn34x_schemas` -- INSERT INTO `nn34x_schemas` (`extension_id`, `version_id`) VALUES (700, '3.3.0-2014-04-02'), (10001, '3.1.0'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_session` -- CREATE TABLE IF NOT EXISTS `nn34x_session` ( `session_id` varchar(200) NOT NULL DEFAULT '', `client_id` tinyint(3) unsigned NOT NULL DEFAULT '0', `guest` tinyint(4) unsigned DEFAULT '1', `time` varchar(14) DEFAULT '', `data` mediumtext, `userid` int(11) DEFAULT '0', `username` varchar(150) DEFAULT '', PRIMARY KEY (`session_id`), KEY `userid` (`userid`), KEY `time` (`time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nn34x_session` -- INSERT INTO `nn34x_session` (`session_id`, `client_id`, `guest`, `time`, `data`, `userid`, `username`) VALUES ('do72s1h104hfkooe24fcpi2gs1', 1, 0, '1400693351', '__default|a:8:{s:15:"session.counter";i:309;s:19:"session.timer.start";i:1400685963;s:18:"session.timer.last";i:1400693349;s:17:"session.timer.now";i:1400693351;s:22:"session.client.browser";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0";s:8:"registry";O:24:"Joomla\\Registry\\Registry":1:{s:7:"\\0\\0\\0data";O:8:"stdClass":11:{s:11:"application";O:8:"stdClass":1:{s:4:"lang";s:5:"en-GB";}s:13:"com_installer";O:8:"stdClass":3:{s:7:"message";s:0:"";s:17:"extension_message";s:0:"";s:12:"redirect_url";N;}s:11:"com_modules";O:8:"stdClass":3:{s:4:"edit";O:8:"stdClass":1:{s:6:"module";O:8:"stdClass":2:{s:2:"id";a:0:{}s:4:"data";N;}}s:3:"add";O:8:"stdClass":1:{s:6:"module";O:8:"stdClass":2:{s:12:"extension_id";N;s:6:"params";N;}}s:7:"modules";O:8:"stdClass":1:{s:6:"filter";O:8:"stdClass":1:{s:18:"client_id_previous";i:0;}}}s:9:"com_menus";O:8:"stdClass":2:{s:5:"items";O:8:"stdClass":3:{s:8:"menutype";s:8:"mainmenu";s:10:"limitstart";i:0;s:4:"list";a:4:{s:9:"direction";s:3:"asc";s:5:"limit";s:2:"20";s:8:"ordering";s:5:"a.lft";s:5:"start";d:0;}}s:4:"edit";O:8:"stdClass":1:{s:4:"item";O:8:"stdClass":5:{s:4:"data";N;s:4:"type";N;s:4:"link";N;s:2:"id";a:1:{i:3;i:118;}s:8:"menutype";s:8:"mainmenu";}}}s:4:"item";O:8:"stdClass":1:{s:6:"filter";O:8:"stdClass":1:{s:8:"menutype";s:8:"mainmenu";}}s:4:"joom";O:8:"stdClass":5:{s:7:"version";O:8:"stdClass":1:{s:6:"string";s:5:"3.1.1";}s:6:"update";O:8:"stdClass":1:{s:7:"checked";i:1;}s:6:"upload";O:8:"stdClass":8:{s:5:"debug";b:0;s:5:"catid";i:2;s:5:"title";s:6:"Manče";s:11:"filecounter";i:0;s:18:"create_special_gif";b:0;s:4:"post";a:16:{s:5:"catid";s:1:"2";s:8:"imgtitle";s:6:"Manče";s:11:"filecounter";s:1:"2";s:7:"imgtext";s:0:"";s:9:"imgauthor";s:5:"Sandi";s:9:"published";s:1:"1";s:6:"access";s:1:"1";s:18:"create_special_gif";s:1:"0";s:5:"debug";s:1:"0";s:11:"qqpartindex";s:1:"3";s:16:"qqpartbyteoffset";s:7:"1500000";s:11:"qqchunksize";s:5:"15615";s:12:"qqtotalparts";s:1:"4";s:15:"qqtotalfilesize";s:7:"1515615";s:10:"qqfilename";s:12:"IMAG0084.jpg";s:6:"qquuid";s:36:"c38d4dfc-7cbf-4033-bb5e-30fd401ba90e";}s:15:"delete_original";b:0;s:11:"debugoutput";N;}s:6:"images";O:8:"stdClass":1:{s:10:"limitstart";i:0;}s:9:"migration";O:8:"stdClass":1:{s:6:"output";N;}}s:11:"com_content";O:8:"stdClass":1:{s:4:"edit";O:8:"stdClass":1:{s:7:"article";O:8:"stdClass":2:{s:4:"data";N;s:2:"id";a:0:{}}}}s:14:"com_categories";O:8:"stdClass":2:{s:10:"categories";O:8:"stdClass":1:{s:6:"filter";O:8:"stdClass":1:{s:9:"extension";s:11:"com_content";}}s:4:"edit";O:8:"stdClass":1:{s:8:"category";O:8:"stdClass":2:{s:4:"data";N;s:2:"id";a:0:{}}}}s:13:"com_templates";O:8:"stdClass":1:{s:4:"edit";O:8:"stdClass":1:{s:5:"style";O:8:"stdClass":2:{s:2:"id";a:1:{i:0;i:9;}s:4:"data";N;}}}s:9:"com_users";O:8:"stdClass":1:{s:4:"edit";O:8:"stdClass":1:{s:4:"user";O:8:"stdClass":2:{s:4:"data";N;s:2:"id";a:0:{}}}}s:11:"com_banners";O:8:"stdClass":1:{s:4:"edit";O:8:"stdClass":1:{s:6:"banner";O:8:"stdClass":1:{s:4:"data";N;}}}}}s:4:"user";O:5:"JUser":27:{s:9:"\\0\\0\\0isRoot";b:1;s:2:"id";s:3:"324";s:4:"name";s:10:"Super User";s:8:"username";s:5:"admin";s:5:"email";s:23:"sandi.pangerc@gmail.com";s:8:"password";s:60:"$2y$10$yXn6AXuBAydy9yqeFfWqIuSl8bPM.v.YKz5JGiBjiYlAjJrnJCzhy";s:14:"password_clear";s:0:"";s:5:"block";s:1:"0";s:9:"sendEmail";s:1:"1";s:12:"registerDate";s:19:"2014-05-21 15:24:03";s:13:"lastvisitDate";s:19:"0000-00-00 00:00:00";s:10:"activation";s:1:"0";s:6:"params";s:0:"";s:6:"groups";a:1:{i:8;s:1:"8";}s:5:"guest";i:0;s:13:"lastResetTime";s:19:"0000-00-00 00:00:00";s:10:"resetCount";s:1:"0";s:12:"requireReset";s:1:"0";s:10:"\\0\\0\\0_params";O:24:"Joomla\\Registry\\Registry":1:{s:7:"\\0\\0\\0data";O:8:"stdClass":0:{}}s:14:"\\0\\0\\0_authGroups";a:2:{i:0;i:1;i:1;i:8;}s:14:"\\0\\0\\0_authLevels";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}s:15:"\\0\\0\\0_authActions";N;s:12:"\\0\\0\\0_errorMsg";N;s:10:"\\0\\0\\0_errors";a:0:{}s:3:"aid";i:0;s:6:"otpKey";s:0:"";s:4:"otep";s:0:"";}s:13:"session.token";s:32:"40b07b4acd744cfa170a0af919cb1f2e";}', 324, 'admin'), ('rmh7ltkqrolo79vle7k22i3pa0', 0, 1, '1400693361', '__default|a:9:{s:15:"session.counter";i:13;s:19:"session.timer.start";i:1400693203;s:18:"session.timer.last";i:1400693357;s:17:"session.timer.now";i:1400693361;s:22:"session.client.browser";s:72:"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:20.0) Gecko/20100101 Firefox/20.0";s:8:"registry";O:24:"Joomla\\Registry\\Registry":1:{s:7:"\\0\\0\\0data";O:8:"stdClass":1:{s:5:"users";O:8:"stdClass":1:{s:5:"login";O:8:"stdClass":1:{s:4:"form";O:8:"stdClass":1:{s:4:"data";a:1:{s:6:"return";s:43:"http://localhost/joomla3/index.php/galerija";}}}}}}s:4:"user";O:5:"JUser":25:{s:9:"\\0\\0\\0isRoot";b:0;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:5:"block";N;s:9:"sendEmail";i:0;s:12:"registerDate";N;s:13:"lastvisitDate";N;s:10:"activation";N;s:6:"params";N;s:6:"groups";a:1:{i:0;s:1:"9";}s:5:"guest";i:1;s:13:"lastResetTime";N;s:10:"resetCount";N;s:12:"requireReset";N;s:10:"\\0\\0\\0_params";O:24:"Joomla\\Registry\\Registry":1:{s:7:"\\0\\0\\0data";O:8:"stdClass":0:{}}s:14:"\\0\\0\\0_authGroups";a:2:{i:0;i:1;i:1;i:9;}s:14:"\\0\\0\\0_authLevels";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:"\\0\\0\\0_authActions";N;s:12:"\\0\\0\\0_errorMsg";N;s:10:"\\0\\0\\0_errors";a:0:{}s:3:"aid";i:0;}s:16:"com_mailto.links";a:4:{s:40:"d7094eb689939dddbd61016dc1a3d13f829b9f56";O:8:"stdClass":2:{s:4:"link";s:25:"http://localhost/joomla3/";s:6:"expiry";i:1400693361;}s:40:"17a826240df19b90dae43f33ef86ba22006f315d";O:8:"stdClass":2:{s:4:"link";s:63:"http://localhost/joomla3/index.php/prispevki/3-kmecke-igre-2014";s:6:"expiry";i:1400693211;}s:40:"df41445d1f575e355fb9b38147ac7bd07e7dd3fd";O:8:"stdClass":2:{s:4:"link";s:64:"http://localhost/joomla3/index.php/prispevki/2-premik-smetnjakov";s:6:"expiry";i:1400693211;}s:40:"4806d4b170ed7963e30eeb7ede98a5b1bb63b0c2";O:8:"stdClass":2:{s:4:"link";s:52:"http://localhost/joomla3/index.php/prispevki/4-vista";s:6:"expiry";i:1400693211;}}s:13:"session.token";s:32:"4c263eef4d8480fff64722279be14967";}', 0, ''); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_tags` -- CREATE TABLE IF NOT EXISTS `nn34x_tags` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0', `lft` int(11) NOT NULL DEFAULT '0', `rgt` int(11) NOT NULL DEFAULT '0', `level` int(10) unsigned NOT NULL DEFAULT '0', `path` varchar(255) NOT NULL DEFAULT '', `title` varchar(255) NOT NULL, `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `note` varchar(255) NOT NULL DEFAULT '', `description` mediumtext 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', `access` int(10) unsigned NOT NULL DEFAULT '0', `params` text NOT NULL, `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.', `metakey` varchar(1024) NOT NULL COMMENT 'The meta keywords for the page.', `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.', `created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by_alias` varchar(255) NOT NULL DEFAULT '', `modified_user_id` int(10) unsigned NOT NULL DEFAULT '0', `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `images` text NOT NULL, `urls` text NOT NULL, `hits` int(10) unsigned NOT NULL DEFAULT '0', `language` char(7) NOT NULL, `version` int(10) unsigned NOT NULL DEFAULT '1', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`), KEY `tag_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_path` (`path`), KEY `idx_left_right` (`lft`,`rgt`), KEY `idx_alias` (`alias`), KEY `idx_language` (`language`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ; -- -- Dumping data for table `nn34x_tags` -- INSERT INTO `nn34x_tags` (`id`, `parent_id`, `lft`, `rgt`, `level`, `path`, `title`, `alias`, `note`, `description`, `published`, `checked_out`, `checked_out_time`, `access`, `params`, `metadesc`, `metakey`, `metadata`, `created_user_id`, `created_time`, `created_by_alias`, `modified_user_id`, `modified_time`, `images`, `urls`, `hits`, `language`, `version`, `publish_up`, `publish_down`) VALUES (1, 0, 0, 1, 0, '', 'ROOT', 'root', '', '', 1, 0, '0000-00-00 00:00:00', 1, '', '', '', '', 0, '2011-01-01 00:00:01', '', 0, '0000-00-00 00:00:00', '', '', 0, '*', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_template_styles` -- CREATE TABLE IF NOT EXISTS `nn34x_template_styles` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `template` varchar(50) NOT NULL DEFAULT '', `client_id` tinyint(1) unsigned NOT NULL DEFAULT '0', `home` char(7) NOT NULL DEFAULT '0', `title` varchar(255) NOT NULL DEFAULT '', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_template` (`template`), KEY `idx_home` (`home`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `nn34x_template_styles` -- INSERT INTO `nn34x_template_styles` (`id`, `template`, `client_id`, `home`, `title`, `params`) VALUES (4, 'beez3', 0, '0', 'Beez3 - Default', '{"wrapperSmall":"53","wrapperLarge":"72","logo":"images\\/joomla_black.gif","sitetitle":"Joomla!","sitedescription":"Open Source Content Management","navposition":"left","templatecolor":"personal","html5":"0"}'), (5, 'hathor', 1, '0', 'Hathor - Default', '{"showSiteName":"0","colourChoice":"","boldText":"0"}'), (7, 'protostar', 0, '0', 'protostar - Default', '{"templateColor":"","logoFile":"","googleFont":"1","googleFontName":"Open+Sans","fluidContainer":"0"}'), (8, 'isis', 1, '1', 'isis - Default', '{"templateColor":"","logoFile":""}'), (9, 'smartone', 0, '1', 'SmartOne - Default', '{"scrolltop":"yes","logotype":"text","logo":"","sitetitle":"Man\\u010de","sitedesc":"","menuid":["0"],"animation":"fade","Image1":"","Link1":"","Caption1":"","Image2":"","Link2":"","Caption2":"","Image3":"","Link3":"","Caption3":"","Image4":"","Link4":"","Caption4":"","Image5":"","Link5":"","Caption5":"","Image6":"","Link6":"","Caption6":"","Image7":"","Link7":"","Caption7":"","Image8":"","Link8":"","Caption8":"","Image9":"","Link9":"","Caption9":"","Image10":"","Link10":"","Caption10":"","Image11":"","Link11":"","Caption11":"","Image12":"","Link12":"","Caption12":"","Image13":"","Link13":"","Caption13":"","Image14":"","Link14":"","Caption14":"","Image15":"","Link15":"","Caption15":"","Image16":"","Link16":"","Caption16":"","Image17":"","Link17":"","Caption17":"","Image18":"","Link18":"","Caption18":"","Image19":"","Link19":"","Caption19":"","Image20":"","Link20":"","Caption20":"","SocialLink1":"","SocialLink2":"","SocialLink3":"","SocialLink4":"","SocialLink5":"","SocialLink6":"","SocialLink7":"","SocialLink8":"","SocialLink9":"","SocialLink10":""}'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_ucm_base` -- CREATE TABLE IF NOT EXISTS `nn34x_ucm_base` ( `ucm_id` int(10) unsigned NOT NULL, `ucm_item_id` int(10) NOT NULL, `ucm_type_id` int(11) NOT NULL, `ucm_language_id` int(11) NOT NULL, PRIMARY KEY (`ucm_id`), KEY `idx_ucm_item_id` (`ucm_item_id`), KEY `idx_ucm_type_id` (`ucm_type_id`), KEY `idx_ucm_language_id` (`ucm_language_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_ucm_content` -- CREATE TABLE IF NOT EXISTS `nn34x_ucm_content` ( `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `core_type_alias` varchar(255) NOT NULL DEFAULT '' COMMENT 'FK to the content types table', `core_title` varchar(255) NOT NULL, `core_alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `core_body` mediumtext NOT NULL, `core_state` tinyint(1) NOT NULL DEFAULT '0', `core_checked_out_time` varchar(255) NOT NULL DEFAULT '', `core_checked_out_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_access` int(10) unsigned NOT NULL DEFAULT '0', `core_params` text NOT NULL, `core_featured` tinyint(4) unsigned NOT NULL DEFAULT '0', `core_metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.', `core_created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `core_created_by_alias` varchar(255) NOT NULL DEFAULT '', `core_created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Most recent user that modified', `core_modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `core_language` char(7) NOT NULL, `core_publish_up` datetime NOT NULL, `core_publish_down` datetime NOT NULL, `core_content_item_id` int(10) unsigned DEFAULT NULL COMMENT 'ID from the individual type table', `asset_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to the #__assets table.', `core_images` text NOT NULL, `core_urls` text NOT NULL, `core_hits` int(10) unsigned NOT NULL DEFAULT '0', `core_version` int(10) unsigned NOT NULL DEFAULT '1', `core_ordering` int(11) NOT NULL DEFAULT '0', `core_metakey` text NOT NULL, `core_metadesc` text NOT NULL, `core_catid` int(10) unsigned NOT NULL DEFAULT '0', `core_xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `core_type_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`core_content_id`), KEY `tag_idx` (`core_state`,`core_access`), KEY `idx_access` (`core_access`), KEY `idx_alias` (`core_alias`), KEY `idx_language` (`core_language`), KEY `idx_title` (`core_title`), KEY `idx_modified_time` (`core_modified_time`), KEY `idx_created_time` (`core_created_time`), KEY `idx_content_type` (`core_type_alias`), KEY `idx_core_modified_user_id` (`core_modified_user_id`), KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`), KEY `idx_core_created_user_id` (`core_created_user_id`), KEY `idx_core_type_id` (`core_type_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contains core content data in name spaced fields' AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_ucm_history` -- CREATE TABLE IF NOT EXISTS `nn34x_ucm_history` ( `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT, `ucm_item_id` int(10) unsigned NOT NULL, `ucm_type_id` int(10) unsigned NOT NULL, `version_note` varchar(255) NOT NULL DEFAULT '' COMMENT 'Optional version name', `save_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `editor_user_id` int(10) unsigned NOT NULL DEFAULT '0', `character_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of characters in this version.', `sha1_hash` varchar(50) NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.', `version_data` mediumtext NOT NULL COMMENT 'json-encoded string of version data', `keep_forever` tinyint(4) NOT NULL DEFAULT '0' COMMENT '0=auto delete; 1=keep', PRIMARY KEY (`version_id`), KEY `idx_ucm_item_id` (`ucm_type_id`,`ucm_item_id`), KEY `idx_save_date` (`save_date`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 ; -- -- Dumping data for table `nn34x_ucm_history` -- INSERT INTO `nn34x_ucm_history` (`version_id`, `ucm_item_id`, `ucm_type_id`, `version_note`, `save_date`, `editor_user_id`, `character_count`, `sha1_hash`, `version_data`, `keep_forever`) VALUES (1, 1, 1, '', '2014-05-21 15:53:17', 324, 2096, 'fe8a85eb84e58bf5a5447d10564a8e01c8156273', '{"id":1,"asset_id":57,"title":"Predstavitev Man\\u010d","alias":"predstavitev-manc","introtext":"Man\\u010de so manj\\u0161a strnjena vas v zgornji Vipavski dolini. Zelo je raz\\u0161irjeno vinogradni\\u0161tvo in kletarstvo, saj Man\\u010de le\\u017eiijo v odli\\u010dnem obmo\\u010dju za pridelavo trt. Skozi vas poteka Vipavska vinska cesta, ki vabi razne popotnike, da poiskusijo doma\\u010do vinsko kapljico. Drugi pa v mesecu maju tudi radi poiskusijo kak\\u0161no \\u010de\\u0161njo ali dve, na katere vedno vabijo doma\\u010dini. <\\/p>","fulltext":"","state":1,"catid":"2","created":"2014-05-21 15:53:17","created_by":"324","created_by_alias":"","modified":"","modified_by":null,"checked_out":null,"checked_out_time":null,"publish_up":"2014-05-21 15:53:17","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":1,"ordering":null,"metakey":"","metadesc":"","access":"1","hits":null,"metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0), (2, 2, 1, '', '2014-05-21 16:17:35', 325, 803, '34d8acd70302b07163c751bafadef550d7a1960f', '{"id":2,"asset_id":58,"title":"Premik smetnjakov","alias":"premik-smetnjakov","introtext":"
Kot ste mnogi \\u017ee lahko sami okusili nam je va\\u0161\\u010danska dru\\u0161\\u010dina premaknila smeti\\u0161\\u010de. Sama se s to lokaciijo ne strinjam saj je preprosto predale\\u010d za ve\\u010dino va\\u0161\\u010danov. Za novo lokacijo se bomo tudi borili.<\\/p>","fulltext":"","state":"1","catid":"2","created":"2014-05-21 16:17:35","created_by":"325","created_by_alias":"","modified":null,"modified_by":null,"checked_out":null,"checked_out_time":null,"publish_up":"2014-05-21 16:17:35","publish_down":"0000-00-00 00:00:00","images":null,"urls":null,"attribs":null,"version":1,"ordering":null,"metakey":"","metadesc":"","access":"1","hits":null,"metadata":null,"featured":"0","language":"*","xreference":null}', 0), (3, 2, 1, '', '2014-05-21 16:19:55', 324, 1957, '9589f5798e1987367a8a225f69541384694dc94c', '{"id":2,"asset_id":"58","title":"Premik smetnjakov","alias":"premik-smetnjakov","introtext":"
Kot ste mnogi \\u017ee lahko sami okusili nam je va\\u0161\\u010danska dru\\u0161\\u010dina premaknila smeti\\u0161\\u010de. Sama se s to lokaciijo ne strinjam saj je preprosto predale\\u010d za ve\\u010dino va\\u0161\\u010danov. Za novo lokacijo se bomo tudi borili.<\\/p>","fulltext":"","state":1,"catid":"2","created":"2014-05-21 16:17:35","created_by":"325","created_by_alias":"","modified":"2014-05-21 16:19:55","modified_by":"324","checked_out":"324","checked_out_time":"2014-05-21 16:19:24","publish_up":"2014-05-21 16:17:35","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":2,"ordering":"0","metakey":"","metadesc":"","access":"1","hits":"0","metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"1","language":"*","xreference":""}', 0), (4, 3, 1, '', '2014-05-21 16:27:09', 324, 1825, '36ecfa0f2f8c8bf553513b035635460ecc74de24', '{"id":3,"asset_id":59,"title":"Kme\\u010dke igre 2014","alias":"kmecke-igre-2014","introtext":"
Bli\\u017eajo se kme\\u010dke igre treh vasi: Man\\u010de, Lo\\u017ee in Go\\u010de. Potekale bodo junija v Lo\\u017eah za \\u0161olo. To leto pripeljemo domov zlato!<\\/p>","fulltext":"","state":1,"catid":"2","created":"2014-05-21 16:27:09","created_by":"324","created_by_alias":"","modified":"","modified_by":null,"checked_out":null,"checked_out_time":null,"publish_up":"2014-05-21 16:27:09","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":1,"ordering":null,"metakey":"","metadesc":"","access":"1","hits":null,"metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0), (5, 8, 6, '', '2014-05-21 16:27:45', 324, 571, '10c78d53c972b23dbcdbc548e5aa761a66599bfc', '{"id":8,"asset_id":60,"parent_id":"1","lft":"13","rgt":14,"level":1,"path":null,"extension":"com_content","title":"Predstavitev","alias":"predstavitev","note":"","description":"
Prispevki, ki predstavljajo Man\\u010de<\\/p>","published":"1","checked_out":null,"checked_out_time":null,"access":"1","params":"{\\"category_layout\\":\\"\\",\\"image\\":\\"\\"}","metadesc":"","metakey":"","metadata":"{\\"author\\":\\"\\",\\"robots\\":\\"\\"}","created_user_id":"324","created_time":"2014-05-21 16:27:45","modified_user_id":null,"modified_time":null,"hits":"0","language":"*","version":null}', 0), (6, 9, 6, '', '2014-05-21 16:29:44', 324, 625, '5fe27f6d73531405074ae9abf58b83fc5a3b284a', '{"id":9,"asset_id":61,"parent_id":"1","lft":"15","rgt":16,"level":1,"path":null,"extension":"com_content","title":"Prispevki o dogodkih ","alias":"prispevki-o-dogodkih","note":"","description":"
Ti prispevki sledijo vsem dogodkom, ki se dogajajo v bli\\u017eini Man\\u010d<\\/p>","published":"1","checked_out":null,"checked_out_time":null,"access":"1","params":"{\\"category_layout\\":\\"\\",\\"image\\":\\"\\"}","metadesc":"","metakey":"","metadata":"{\\"author\\":\\"\\",\\"robots\\":\\"\\"}","created_user_id":"324","created_time":"2014-05-21 16:29:44","modified_user_id":null,"modified_time":null,"hits":"0","language":"*","version":null}', 0), (7, 3, 1, '', '2014-05-21 16:30:26', 324, 1863, '98e55d51a24d059ff9d826025c507fefe4c462d6', '{"id":3,"asset_id":"59","title":"Kme\\u010dke igre 2014","alias":"kmecke-igre-2014","introtext":"
Bli\\u017eajo se kme\\u010dke igre treh vasi: Man\\u010de, Lo\\u017ee in Go\\u010de. Potekale bodo junija v Lo\\u017eah za \\u0161olo. To leto pripeljemo domov zlato!<\\/p>","fulltext":"","state":1,"catid":"9","created":"2014-05-21 16:27:09","created_by":"324","created_by_alias":"","modified":"2014-05-21 16:30:26","modified_by":"324","checked_out":"324","checked_out_time":"2014-05-21 16:30:15","publish_up":"2014-05-21 16:27:09","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":2,"ordering":"0","metakey":"","metadesc":"","access":"1","hits":"0","metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0), (8, 2, 1, '', '2014-05-21 16:30:31', 324, 1957, 'd61a409ee50563972a3b3c970a30c0a90589d175', '{"id":2,"asset_id":"58","title":"Premik smetnjakov","alias":"premik-smetnjakov","introtext":"
Kot ste mnogi \\u017ee lahko sami okusili nam je va\\u0161\\u010danska dru\\u0161\\u010dina premaknila smeti\\u0161\\u010de. Sama se s to lokaciijo ne strinjam saj je preprosto predale\\u010d za ve\\u010dino va\\u0161\\u010danov. Za novo lokacijo se bomo tudi borili.<\\/p>","fulltext":"","state":1,"catid":"9","created":"2014-05-21 16:17:35","created_by":"325","created_by_alias":"","modified":"2014-05-21 16:30:31","modified_by":"324","checked_out":"324","checked_out_time":"2014-05-21 16:30:16","publish_up":"2014-05-21 16:17:35","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":3,"ordering":"1","metakey":"","metadesc":"","access":"1","hits":"1","metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0), (9, 1, 1, '', '2014-05-21 16:30:36', 324, 2134, '84b48f3507849b97c7d80bc1e45916b0e47a5301', '{"id":1,"asset_id":"57","title":"Predstavitev Man\\u010d","alias":"predstavitev-manc","introtext":"
Man\\u010de so manj\\u0161a strnjena vas v zgornji Vipavski dolini. Zelo je raz\\u0161irjeno vinogradni\\u0161tvo in kletarstvo, saj Man\\u010de le\\u017eiijo v odli\\u010dnem obmo\\u010dju za pridelavo trt. Skozi vas poteka Vipavska vinska cesta, ki vabi razne popotnike, da poiskusijo doma\\u010do vinsko kapljico. Drugi pa v mesecu maju tudi radi poiskusijo kak\\u0161no \\u010de\\u0161njo ali dve, na katere vedno vabijo doma\\u010dini.<\\/p>","fulltext":"","state":1,"catid":"8","created":"2014-05-21 15:53:17","created_by":"324","created_by_alias":"","modified":"2014-05-21 16:30:36","modified_by":"324","checked_out":"324","checked_out_time":"2014-05-21 16:30:17","publish_up":"2014-05-21 15:53:17","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":2,"ordering":"2","metakey":"","metadesc":"","access":"1","hits":"12","metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0), (10, 4, 1, '', '2014-05-21 16:40:14', 326, 792, 'd7d9b051fe702aefec33e633af0c5c5158c0a69d', '{"id":4,"asset_id":62,"title":"Vista ","alias":"vista","introtext":"
V petek so mladi vojaki, rojeni 1996, imeli visto. Lepo so okrasili svoj voz in se pokazali v Vipavski voja\\u0161nici. Enako lepo so tudi o\\u010dedili na\\u0161e ceste in makedamske poti. Prosimo \\u010de lahko na\\u0161i vistarji na\\u0161e poti spet o\\u010dedijo. Hvala.<\\/p>","fulltext":"","state":"1","catid":"9","created":"2014-05-21 16:40:14","created_by":"326","created_by_alias":"","modified":null,"modified_by":null,"checked_out":null,"checked_out_time":null,"publish_up":"2014-05-21 16:40:14","publish_down":"0000-00-00 00:00:00","images":null,"urls":null,"attribs":null,"version":1,"ordering":null,"metakey":"","metadesc":"","access":"1","hits":null,"metadata":null,"featured":"0","language":"*","xreference":null}', 0), (11, 1, 1, '', '2014-05-21 17:29:09', 324, 2275, 'a96a140d3e1a27f015439b9dbb589ea785032b07', '{"id":1,"asset_id":"57","title":"Predstavitev Man\\u010d","alias":"predstavitev-manc","introtext":"
Man\\u010de so manj\\u0161a strnjena vas v zgornji Vipavski dolini. Zelo je raz\\u0161irjeno vinogradni\\u0161tvo in kletarstvo, saj Man\\u010de le\\u017eiijo v odli\\u010dnem obmo\\u010dju za pridelavo trt. Skozi vas poteka Vipavska vinska cesta, ki vabi razne popotnike, da poiskusijo doma\\u010do vinsko kapljico. Drugi pa v mesecu maju tudi radi poiskusijo kak\\u0161no \\u010de\\u0161njo ali dve, na katere vedno vabijo doma\\u010dini.<\\/p>\\r\\n
\\u010ce bi \\u017eeleli prebrati \\u0161e kak\\u0161no novico ve\\u010d ali si ogledati kak\\u0161no sliko Man\\u010d se registrirajte.<\\/p>","fulltext":"","state":1,"catid":"8","created":"2014-05-21 15:53:17","created_by":"324","created_by_alias":"","modified":"2014-05-21 17:29:09","modified_by":"324","checked_out":"324","checked_out_time":"2014-05-21 17:28:17","publish_up":"2014-05-21 15:53:17","publish_down":"0000-00-00 00:00:00","images":"{\\"image_intro\\":\\"\\",\\"float_intro\\":\\"\\",\\"image_intro_alt\\":\\"\\",\\"image_intro_caption\\":\\"\\",\\"image_fulltext\\":\\"\\",\\"float_fulltext\\":\\"\\",\\"image_fulltext_alt\\":\\"\\",\\"image_fulltext_caption\\":\\"\\"}","urls":"{\\"urla\\":false,\\"urlatext\\":\\"\\",\\"targeta\\":\\"\\",\\"urlb\\":false,\\"urlbtext\\":\\"\\",\\"targetb\\":\\"\\",\\"urlc\\":false,\\"urlctext\\":\\"\\",\\"targetc\\":\\"\\"}","attribs":"{\\"show_title\\":\\"\\",\\"link_titles\\":\\"\\",\\"show_tags\\":\\"\\",\\"show_intro\\":\\"\\",\\"info_block_position\\":\\"\\",\\"show_category\\":\\"\\",\\"link_category\\":\\"\\",\\"show_parent_category\\":\\"\\",\\"link_parent_category\\":\\"\\",\\"show_author\\":\\"\\",\\"link_author\\":\\"\\",\\"show_create_date\\":\\"\\",\\"show_modify_date\\":\\"\\",\\"show_publish_date\\":\\"\\",\\"show_item_navigation\\":\\"\\",\\"show_icons\\":\\"\\",\\"show_print_icon\\":\\"\\",\\"show_email_icon\\":\\"\\",\\"show_vote\\":\\"\\",\\"show_hits\\":\\"\\",\\"show_noauth\\":\\"\\",\\"urls_position\\":\\"\\",\\"alternative_readmore\\":\\"\\",\\"article_layout\\":\\"\\",\\"show_publishing_options\\":\\"\\",\\"show_article_options\\":\\"\\",\\"show_urls_images_backend\\":\\"\\",\\"show_urls_images_frontend\\":\\"\\"}","version":3,"ordering":"2","metakey":"","metadesc":"","access":"1","hits":"27","metadata":"{\\"robots\\":\\"\\",\\"author\\":\\"\\",\\"rights\\":\\"\\",\\"xreference\\":\\"\\"}","featured":"0","language":"*","xreference":""}', 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_updates` -- CREATE TABLE IF NOT EXISTS `nn34x_updates` ( `update_id` int(11) NOT NULL AUTO_INCREMENT, `update_site_id` int(11) DEFAULT '0', `extension_id` int(11) DEFAULT '0', `name` varchar(100) DEFAULT '', `description` text NOT NULL, `element` varchar(100) DEFAULT '', `type` varchar(20) DEFAULT '', `folder` varchar(20) DEFAULT '', `client_id` tinyint(3) DEFAULT '0', `version` varchar(32) DEFAULT '', `data` text NOT NULL, `detailsurl` text NOT NULL, `infourl` text NOT NULL, `extra_query` varchar(1000) DEFAULT '', PRIMARY KEY (`update_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Available Updates' AUTO_INCREMENT=80 ; -- -- Dumping data for table `nn34x_updates` -- INSERT INTO `nn34x_updates` (`update_id`, `update_site_id`, `extension_id`, `name`, `description`, `element`, `type`, `folder`, `client_id`, `version`, `data`, `detailsurl`, `infourl`, `extra_query`) VALUES (1, 3, 0, 'Montenegrin', '', 'pkg_srp-ME', 'package', '', 0, '3.2.1.1', '', 'http://update.joomla.org/language/details3/srp-ME_details.xml', '', ''), (2, 3, 0, 'EnglishCA', '', 'pkg_en-CA', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/en-CA_details.xml', '', ''), (3, 3, 0, 'FrenchCA', '', 'pkg_fr-CA', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/fr-CA_details.xml', '', ''), (4, 3, 0, 'Welsh', '', 'pkg_cy-GB', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/cy-GB_details.xml', '', ''), (5, 4, 0, 'JoomAutoCat', '', 'joomautocat', 'plugin', 'user', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomautocat.xml', '', ''), (6, 3, 0, 'Malay', '', 'pkg_ms-MY', 'package', '', 0, '3.2.2.1', '', 'http://update.joomla.org/language/details3/ms-MY_details.xml', '', ''), (7, 4, 0, 'JoomPlu', '', 'joomplu', 'plugin', 'content', 0, '3.1', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomplu.xml', '', ''), (8, 3, 0, 'Romanian', '', 'pkg_ro-RO', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/ro-RO_details.xml', '', ''), (9, 4, 0, 'JoomBu', '', 'joombu', 'plugin', 'editors-xtd', 0, '3.2', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joombu.xml', '', ''), (10, 3, 0, 'Flemish', '', 'pkg_nl-BE', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/nl-BE_details.xml', '', ''), (11, 4, 0, 'JoomFancybox', '', 'joomfancybox', 'plugin', 'joomgallery', 0, '1.1', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomfancybox.xml', '', ''), (12, 3, 0, 'Chinese Traditional', '', 'pkg_zh-TW', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/zh-TW_details.xml', '', ''), (13, 4, 0, 'JoomLightbox2', '', 'joomlightbox2', 'plugin', 'joomgallery', 0, '1.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomlightbox2.xml', '', ''), (14, 3, 0, 'French', '', 'pkg_fr-FR', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/fr-FR_details.xml', '', ''), (15, 4, 0, 'JoomSearchPlugin', '', 'joomgallery', 'plugin', 'search', 0, '3.1 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomsearchplugin.xml', '', ''), (16, 3, 0, 'German', '', 'pkg_de-DE', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/de-DE_details.xml', '', ''), (17, 4, 0, 'JoomColorbox', '', 'joomcolorbox', 'plugin', 'joomgallery', 0, '3.0 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomcolorbox.xml', '', ''), (18, 3, 0, 'Greek', '', 'pkg_el-GR', 'package', '', 0, '3.2.0.1', '', 'http://update.joomla.org/language/details3/el-GR_details.xml', '', ''), (19, 4, 0, 'JoomLytebox', '', 'joomlytebox', 'plugin', 'joomgallery', 0, '3.0 BETA2', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomlytebox.xml', '', ''), (20, 3, 0, 'Japanese', '', 'pkg_ja-JP', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/ja-JP_details.xml', '', ''), (21, 4, 0, 'JoomQuickicon', '', 'joomgallery', 'plugin', 'quickicon', 0, '3.0 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomquickicon.xml', '', ''), (22, 3, 0, 'Hebrew', '', 'pkg_he-IL', 'package', '', 0, '3.1.1.1', '', 'http://update.joomla.org/language/details3/he-IL_details.xml', '', ''), (23, 4, 0, 'JoomTreeview', '', 'mod_jgreeview', 'module', '', 0, '3.1 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomtreeview.xml', '', ''), (24, 3, 0, 'EnglishAU', '', 'pkg_en-AU', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/en-AU_details.xml', '', ''), (25, 4, 0, 'JoomStats', '', 'mod_joomstats', 'module', '', 0, '3.0 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomstats.xml', '', ''), (26, 3, 0, 'EnglishUS', '', 'pkg_en-US', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/en-US_details.xml', '', ''), (27, 4, 0, 'JoomSearchModule', '', 'mod_joomsearch', 'module', '', 0, '3.0 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomsearchmodule.xml', '', ''), (28, 3, 0, 'Hungarian', '', 'pkg_hu-HU', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/hu-HU_details.xml', '', ''), (29, 4, 0, 'JoomCategories', '', 'mod_joomcat', 'module', '', 0, '3.0 BETA2', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomcategories.xml', '', ''), (30, 3, 0, 'Afrikaans', '', 'pkg_af-ZA', 'package', '', 0, '3.2.0.1', '', 'http://update.joomla.org/language/details3/af-ZA_details.xml', '', ''), (31, 4, 0, 'JoomImages', '', 'mod_joomimg', 'module', '', 0, '3.0 BETA3', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomimages.xml', '', ''), (32, 3, 0, 'Arabic Unitag', '', 'pkg_ar-AA', 'package', '', 0, '3.3.0.2', '', 'http://update.joomla.org/language/details3/ar-AA_details.xml', '', ''), (33, 4, 0, 'XmapPlugin', '', 'com_joomgallery', 'plugin', 'xmap', 0, '2.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/xmapplugin.xml', '', ''), (34, 3, 0, 'Belarusian', '', 'pkg_be-BY', 'package', '', 0, '3.2.1.1', '', 'http://update.joomla.org/language/details3/be-BY_details.xml', '', ''), (35, 4, 0, 'JoomAdditionalImageFields', '', 'joomadditionalimagefields', 'plugin', 'joomgallery', 0, '1.1', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomadditionalimagefields.xml', '', ''), (36, 3, 0, 'Bulgarian', '', 'pkg_bg-BG', 'package', '', 0, '3.2.1.1', '', 'http://update.joomla.org/language/details3/bg-BG_details.xml', '', ''), (37, 4, 0, 'JoomAdditionalCategoryFields', '', 'joomadditionalcategoryfields', 'plugin', 'joomgallery', 0, '1.1', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomadditionalcategoryfields.xml', '', ''), (38, 3, 0, 'Catalan', '', 'pkg_ca-ES', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/ca-ES_details.xml', '', ''), (39, 4, 0, 'JoomreCaptcha', '', 'joomrecaptcha', 'plugin', 'joomgallery', 0, '2.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomrecaptcha.xml', '', ''), (40, 3, 0, 'Chinese Simplified', '', 'pkg_zh-CN', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/zh-CN_details.xml', '', ''), (41, 4, 0, 'JoomShadowbox', '', 'joomshadowbox', 'plugin', 'joomgallery', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomshadowbox.xml', '', ''), (42, 3, 0, 'Croatian', '', 'pkg_hr-HR', 'package', '', 0, '3.1.5.1', '', 'http://update.joomla.org/language/details3/hr-HR_details.xml', '', ''), (43, 4, 0, 'JoomHighslide', '', 'joomhighslide', 'plugin', 'joomgallery', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomhighslide.xml', '', ''), (44, 3, 0, 'Czech', '', 'pkg_cs-CZ', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/cs-CZ_details.xml', '', ''), (45, 4, 0, 'JoomRokBox', '', 'joomrokbox', 'plugin', 'joomgallery', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomrokbox.xml', '', ''), (46, 3, 0, 'Danish', '', 'pkg_da-DK', 'package', '', 0, '3.3.0.2', '', 'http://update.joomla.org/language/details3/da-DK_details.xml', '', ''), (47, 4, 0, 'JoomprettyPhoto', '', 'joomprettyphoto', 'plugin', 'joomgallery', 0, '1.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomprettyphoto.xml', '', ''), (48, 3, 0, 'Dutch', '', 'pkg_nl-NL', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/nl-NL_details.xml', '', ''), (49, 4, 0, 'JoomPhotoswipe', '', 'joomphotoswipe', 'plugin', 'joomgallery', 0, '3.0 BETA', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/joomphotoswipe.xml', '', ''), (50, 3, 0, 'Estonian', '', 'pkg_et-EE', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/et-EE_details.xml', '', ''), (51, 4, 0, 'MigrateMVC2JUX', '', 'joomgallery_migratemvc2jux', 'file', '', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/migratemvc2jux.xml', '', ''), (52, 3, 0, 'Italian', '', 'pkg_it-IT', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/it-IT_details.xml', '', ''), (53, 4, 0, 'Migrate4Images2Joom', '', 'joomgallery_migrate4images2joo', 'file', '', 0, '3.0 Beta', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/migrate4images2joom.xml', '', ''), (54, 3, 0, 'Korean', '', 'pkg_ko-KR', 'package', '', 0, '3.2.3.1', '', 'http://update.joomla.org/language/details3/ko-KR_details.xml', '', ''), (55, 4, 0, 'MigratePhoca2Joom', '', 'joomgallery_migratephoca2joom', 'file', '', 0, '3.0', '', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3/migratephoca2joom.xml', '', ''), (56, 3, 0, 'Latvian', '', 'pkg_lv-LV', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/lv-LV_details.xml', '', ''), (57, 3, 0, 'Macedonian', '', 'pkg_mk-MK', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/mk-MK_details.xml', '', ''), (58, 3, 0, 'Norwegian Bokmal', '', 'pkg_nb-NO', 'package', '', 0, '3.2.2.1', '', 'http://update.joomla.org/language/details3/nb-NO_details.xml', '', ''), (59, 3, 0, 'Persian', '', 'pkg_fa-IR', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/fa-IR_details.xml', '', ''), (60, 3, 0, 'Polish', '', 'pkg_pl-PL', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/pl-PL_details.xml', '', ''), (61, 3, 0, 'Russian', '', 'pkg_ru-RU', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/ru-RU_details.xml', '', ''), (62, 3, 0, 'Slovak', '', 'pkg_sk-SK', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/sk-SK_details.xml', '', ''), (63, 3, 0, 'Swedish', '', 'pkg_sv-SE', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/sv-SE_details.xml', '', ''), (64, 3, 0, 'Syriac', '', 'pkg_sy-IQ', 'package', '', 0, '3.2.3.1', '', 'http://update.joomla.org/language/details3/sy-IQ_details.xml', '', ''), (65, 3, 0, 'Tamil', '', 'pkg_ta-IN', 'package', '', 0, '3.3.0.2', '', 'http://update.joomla.org/language/details3/ta-IN_details.xml', '', ''), (66, 3, 0, 'Thai', '', 'pkg_th-TH', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/th-TH_details.xml', '', ''), (67, 3, 0, 'Turkish', '', 'pkg_tr-TR', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/tr-TR_details.xml', '', ''), (68, 3, 0, 'Ukrainian', '', 'pkg_uk-UA', 'package', '', 0, '3.2.0.6', '', 'http://update.joomla.org/language/details3/uk-UA_details.xml', '', ''), (69, 3, 0, 'Uyghur', '', 'pkg_ug-CN', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/ug-CN_details.xml', '', ''), (70, 3, 0, 'Albanian', '', 'pkg_sq-AL', 'package', '', 0, '3.1.1.1', '', 'http://update.joomla.org/language/details3/sq-AL_details.xml', '', ''), (71, 3, 0, 'Portuguese Brazil', '', 'pkg_pt-BR', 'package', '', 0, '3.0.2.1', '', 'http://update.joomla.org/language/details3/pt-BR_details.xml', '', ''), (72, 3, 0, 'Serbian Latin', '', 'pkg_sr-YU', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/sr-YU_details.xml', '', ''), (73, 3, 0, 'Spanish', '', 'pkg_es-ES', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/es-ES_details.xml', '', ''), (74, 3, 0, 'Bosnian', '', 'pkg_bs-BA', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/bs-BA_details.xml', '', ''), (75, 3, 0, 'Serbian Cyrillic', '', 'pkg_sr-RS', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/sr-RS_details.xml', '', ''), (76, 3, 0, 'Vietnamese', '', 'pkg_vi-VN', 'package', '', 0, '3.2.1.1', '', 'http://update.joomla.org/language/details3/vi-VN_details.xml', '', ''), (77, 3, 0, 'Bahasa Indonesia', '', 'pkg_id-ID', 'package', '', 0, '3.3.0.2', '', 'http://update.joomla.org/language/details3/id-ID_details.xml', '', ''), (78, 3, 0, 'Finnish', '', 'pkg_fi-FI', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/fi-FI_details.xml', '', ''), (79, 3, 0, 'Swahili', '', 'pkg_sw-KE', 'package', '', 0, '3.3.0.1', '', 'http://update.joomla.org/language/details3/sw-KE_details.xml', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_update_sites` -- CREATE TABLE IF NOT EXISTS `nn34x_update_sites` ( `update_site_id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(100) DEFAULT '', `type` varchar(20) DEFAULT '', `location` text NOT NULL, `enabled` int(11) DEFAULT '0', `last_check_timestamp` bigint(20) DEFAULT '0', `extra_query` varchar(1000) DEFAULT '', PRIMARY KEY (`update_site_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Update Sites' AUTO_INCREMENT=5 ; -- -- Dumping data for table `nn34x_update_sites` -- INSERT INTO `nn34x_update_sites` (`update_site_id`, `name`, `type`, `location`, `enabled`, `last_check_timestamp`, `extra_query`) VALUES (1, 'Joomla Core', 'collection', 'http://update.joomla.org/core/list.xml', 1, 1400693222, ''), (2, 'Joomla Extension Directory', 'collection', 'http://update.joomla.org/jed/list.xml', 1, 1400693222, ''), (3, 'Accredited Joomla! Translations', 'collection', 'http://update.joomla.org/language/translationlist_3.xml', 1, 1400693222, ''), (4, 'JoomGallery Update Service', 'collection', 'http://www.en.joomgallery.net/components/com_newversion/xml/extensions3.xml', 1, 1400693222, ''); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_update_sites_extensions` -- CREATE TABLE IF NOT EXISTS `nn34x_update_sites_extensions` ( `update_site_id` int(11) NOT NULL DEFAULT '0', `extension_id` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`update_site_id`,`extension_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Links extensions to update sites'; -- -- Dumping data for table `nn34x_update_sites_extensions` -- INSERT INTO `nn34x_update_sites_extensions` (`update_site_id`, `extension_id`) VALUES (1, 700), (2, 700), (3, 600), (4, 10001); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_usergroups` -- CREATE TABLE IF NOT EXISTS `nn34x_usergroups` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id', `lft` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set lft.', `rgt` int(11) NOT NULL DEFAULT '0' COMMENT 'Nested set rgt.', `title` varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (`id`), UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`), KEY `idx_usergroup_title_lookup` (`title`), KEY `idx_usergroup_adjacency_lookup` (`parent_id`), KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; -- -- Dumping data for table `nn34x_usergroups` -- INSERT INTO `nn34x_usergroups` (`id`, `parent_id`, `lft`, `rgt`, `title`) VALUES (1, 0, 1, 18, 'Public'), (2, 1, 8, 15, 'Registered'), (3, 2, 9, 14, 'Author'), (4, 3, 10, 13, 'Editor'), (5, 4, 11, 12, 'Publisher'), (6, 1, 4, 7, 'Manager'), (7, 6, 5, 6, 'Administrator'), (8, 1, 16, 17, 'Super Users'), (9, 1, 2, 3, 'Guest'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_users` -- CREATE TABLE IF NOT EXISTS `nn34x_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 '', `block` tinyint(4) NOT NULL DEFAULT '0', `sendEmail` tinyint(4) DEFAULT '0', `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, `lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset', `resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime', `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys', `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords', `requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login', PRIMARY KEY (`id`), KEY `idx_name` (`name`), KEY `idx_block` (`block`), KEY `username` (`username`), KEY `email` (`email`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=327 ; -- -- Dumping data for table `nn34x_users` -- INSERT INTO `nn34x_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (324, 'Super User', 'admin', 'sandi.pangerc@gmail.com', '$2y$10$yXn6AXuBAydy9yqeFfWqIuSl8bPM.v.YKz5JGiBjiYlAjJrnJCzhy', 0, 1, '2014-05-21 15:24:03', '2014-05-21 15:26:12', '0', '', '0000-00-00 00:00:00', 0, '', '', 0), (325, 'Sara', 'Sara', 'sara@pohaj.ga', '$2y$10$HsQjq00028NQ0TaeXACtr.h1qb93QAGKeUDrCIhxOt/Rn4m6PQZrG', 0, 0, '2014-05-21 16:14:17', '2014-05-21 16:38:25', '', '{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}', '0000-00-00 00:00:00', 0, '', '', 0), (326, 'Sandi', 'Sandi', 'izmanc@gmail.com', '$2y$10$nLIX1hDeH1SPd2VSNA9VFuWsNgf3uI.Tr7QhWa0sy3hwT.bZdZ/Oy', 0, 0, '2014-05-21 16:14:37', '2014-05-21 17:26:41', '', '{"admin_style":"","admin_language":"","language":"","editor":"","helpsite":"","timezone":""}', '0000-00-00 00:00:00', 0, '', '', 0); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_user_keys` -- CREATE TABLE IF NOT EXISTS `nn34x_user_keys` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` varchar(255) NOT NULL, `token` varchar(255) NOT NULL, `series` varchar(255) NOT NULL, `invalid` tinyint(4) NOT NULL, `time` varchar(200) NOT NULL, `uastring` varchar(255) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `series` (`series`), UNIQUE KEY `series_2` (`series`), UNIQUE KEY `series_3` (`series`), KEY `user_id` (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_user_notes` -- CREATE TABLE IF NOT EXISTS `nn34x_user_notes` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `user_id` int(10) unsigned NOT NULL DEFAULT '0', `catid` int(10) unsigned NOT NULL DEFAULT '0', `subject` varchar(100) NOT NULL DEFAULT '', `body` text NOT NULL, `state` tinyint(3) NOT NULL DEFAULT '0', `checked_out` int(10) unsigned NOT NULL DEFAULT '0', `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_user_id` int(10) unsigned NOT NULL DEFAULT '0', `created_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `modified_user_id` int(10) unsigned NOT NULL, `modified_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `review_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', PRIMARY KEY (`id`), KEY `idx_user_id` (`user_id`), KEY `idx_category_id` (`catid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_user_profiles` -- CREATE TABLE IF NOT EXISTS `nn34x_user_profiles` ( `user_id` int(11) NOT NULL, `profile_key` varchar(100) NOT NULL, `profile_value` varchar(255) NOT NULL, `ordering` int(11) NOT NULL DEFAULT '0', UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Simple user profile storage table'; -- -------------------------------------------------------- -- -- Table structure for table `nn34x_user_usergroup_map` -- CREATE TABLE IF NOT EXISTS `nn34x_user_usergroup_map` ( `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__users.id', `group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Foreign Key to #__usergroups.id', PRIMARY KEY (`user_id`,`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `nn34x_user_usergroup_map` -- INSERT INTO `nn34x_user_usergroup_map` (`user_id`, `group_id`) VALUES (324, 8), (325, 2), (325, 6), (326, 1), (326, 2), (326, 5), (326, 6), (326, 7), (326, 9); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_viewlevels` -- CREATE TABLE IF NOT EXISTS `nn34x_viewlevels` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key', `title` varchar(100) NOT NULL DEFAULT '', `ordering` int(11) NOT NULL DEFAULT '0', `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.', PRIMARY KEY (`id`), UNIQUE KEY `idx_assetgroup_title_lookup` (`title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ; -- -- Dumping data for table `nn34x_viewlevels` -- INSERT INTO `nn34x_viewlevels` (`id`, `title`, `ordering`, `rules`) VALUES (1, 'Public', 0, '[1]'), (2, 'Registered', 1, '[6,2,8]'), (3, 'Special', 2, '[6,3,8]'), (5, 'Guest', 0, '[9]'), (6, 'Super Users', 0, '[8]'); -- -------------------------------------------------------- -- -- Table structure for table `nn34x_weblinks` -- CREATE TABLE IF NOT EXISTS `nn34x_weblinks` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `catid` int(11) NOT NULL DEFAULT '0', `title` varchar(250) NOT NULL DEFAULT '', `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', `url` varchar(250) NOT NULL DEFAULT '', `description` text NOT NULL, `hits` int(11) NOT NULL DEFAULT '0', `state` 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', `access` int(11) NOT NULL DEFAULT '1', `params` text NOT NULL, `language` char(7) NOT NULL DEFAULT '', `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `created_by` int(10) 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(10) unsigned NOT NULL DEFAULT '0', `metakey` text NOT NULL, `metadesc` text NOT NULL, `metadata` text NOT NULL, `featured` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Set if link is featured.', `xreference` varchar(50) NOT NULL COMMENT 'A reference to enable linkages to external data sets.', `publish_up` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `publish_down` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `version` int(10) unsigned NOT NULL DEFAULT '1', `images` text NOT NULL, PRIMARY KEY (`id`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`), KEY `idx_state` (`state`), KEY `idx_catid` (`catid`), KEY `idx_createdby` (`created_by`), KEY `idx_featured_catid` (`featured`,`catid`), KEY `idx_language` (`language`), KEY `idx_xreference` (`xreference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;