-- phpMyAdmin SQL Dump
-- version 4.2.6
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 22, 2014 at 10:14 AM
-- Server version: 5.5.38
-- PHP Version: 5.5.15

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


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

--
-- Database: `klimatskepromene`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE IF NOT EXISTS `admins` (
`id` int(10) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(64) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `language` varchar(255) NOT NULL,
  `privilege_admin` tinyint(1) NOT NULL,
  `privilege_pages` tinyint(1) NOT NULL,
  `privilege_news` tinyint(1) NOT NULL,
  `privilege_events` tinyint(1) NOT NULL,
  `privilege_gallery` tinyint(1) NOT NULL,
  `privilege_newsletter` tinyint(1) NOT NULL,
  `privilege_banners` tinyint(1) NOT NULL,
  `privilege_polls` tinyint(1) NOT NULL,
  `privilege_support` tinyint(1) NOT NULL,
  `privilege_documents` tinyint(1) NOT NULL,
  `last_action` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=45 ;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`id`, `email`, `password`, `first_name`, `last_name`, `language`, `privilege_admin`, `privilege_pages`, `privilege_news`, `privilege_events`, `privilege_gallery`, `privilege_newsletter`, `privilege_banners`, `privilege_polls`, `privilege_support`, `privilege_documents`, `last_action`) VALUES
(29, 'dragan@nbgteam.com', '59170012a60f45c465cfaf6697526f3dded22cb5', 'Dragan', 'Nedeljkovic', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1413964807),
(36, 'aleksandarpop@gmail.com', '1ea132a8f19b5da73a3848585abf67c14d6c32a3', 'Aleksandar', 'Popovic', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0),
(41, 'ivan@nbgteam.com', '261fa6709d92cde3879c174d147a54b5a4a9efb4', 'ivan', 'selimbegovic', 'srpski', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1413900309),
(43, 'ivanmijatovic2307@gmail.com', 'a15f8b81a160b4eebe5c84e9e3b65c87b9b2f18e', 'Ivan', 'Mijatovic', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1413889935),
(44, 'nikolamijajlovic1990@gmail.com', '2d6641a64bd07878c8b82b7459b79b798281c870', 'Nikola', 'Mijajlovic', '', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0);

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

--
-- Table structure for table `banners`
--

CREATE TABLE IF NOT EXISTS `banners` (
`id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `type` enum('top','left_nav','left_newsletter','right_top','right_news','right_poll','homepage','right_column') NOT NULL,
  `pages` text NOT NULL,
  `all_pages` tinyint(1) NOT NULL,
  `html_english` text NOT NULL,
  `html_srpski` text NOT NULL,
  `status` tinyint(1) NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `name`, `type`, `pages`, `all_pages`, `html_english`, `html_srpski`, `status`, `position`) VALUES
(1, 'Naslovan strana1', 'homepage', 'a:1:{i:0;s:10:"1000000006";}', 0, '', '<p>\n	<a href="http://google.rs/" target="_blank"><img alt="" height="166" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/banner1.jpg" width="250" /></a></p>\n<h5>\n	<a href="http://google.rs/" target="_blank">Lorem ipsum dolor sit amet, dolor sit amet</a></h5>\n<h6>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula</h6>\n', 1, 0),
(2, 'Naslovan strana2', 'homepage', 'a:1:{i:0;s:10:"1000000006";}', 0, '', '<p>\n	<a href="http://google.rs/" target="_blank"><img alt="" height="166" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/banner2.jpg" width="251" /></a></p>\n<h5>\n	<a href="http://google.rs/" target="_blank">Lorem ipsum dolor sit amet, dolor sit amet</a></h5>\n<h6>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula</h6>\n', 1, 0),
(3, 'Naslovan strana3', 'homepage', 'a:1:{i:0;s:10:"1000000006";}', 0, '', '<p>\n	<a href="http://google.rs/" target="_blank"><img alt="" height="166" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/banner3.jpg" width="250" /></a></p>\n<h5>\n	<a href="http://google.rs/" target="_blank">Lorem ipsum dolor sit amet, dolor sit amet</a></h5>\n<h6>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula</h6>\n', 1, 0),
(4, 'Desni baner 1', 'right_column', 'a:0:{}', 1, '', '<p>\n	<a href="http://google.rs/" target="_blank"><img alt="" height="166" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/right_banner1.jpg" width="250" /></a></p>\n<h4>\n	<a href="http://google.rs/" target="_blank">Info o UNFCCC i Kjoto protokolu</a></h4>\n', 1, 0),
(5, 'Desni baner 2', 'right_column', 'a:0:{}', 1, '', '<p>\n	<a href="http://google.rs/" target="_blank"><img alt="" height="166" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/right_banner2.jpg" width="250" /></a></p>\n<h4>\n	<a href="http://google.rs/" target="_blank">Initial National Communication</a></h4>\n', 1, 0);

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

--
-- Table structure for table `ci_sessions`
--

CREATE TABLE IF NOT EXISTS `ci_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ci_sessions`
--

INSERT INTO `ci_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES
('09eb4338ee1193c6f86b30cecc4dcc0f', '109.93.47.239', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) App', 1330615784, ''),
('21085ae2e8192170fe2f397a8b4d2738', '109.93.47.239', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_7_3) App', 1330615790, '');

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

--
-- Table structure for table `config`
--

CREATE TABLE IF NOT EXISTS `config` (
  `key` varchar(255) NOT NULL,
  `value` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `config`
--

INSERT INTO `config` (`key`, `value`) VALUES
('news_per_page', '5'),
('news_home_limit', '5'),
('news_home_auto', 'TRUE'),
('background_color', '#FFFFFF'),
('background_image', 'uploads/bg.jpg'),
('background_repeat', 'repeat-x'),
('background_attachment', '0'),
('footer_background_image', 'uploads/footer.gif'),
('footer_background_repeat', 'repeat-x'),
('footer_background_attachment', 'scroll'),
('footer_background_color', '#F6F4F4'),
('footer_text_color', '#D6D6D6'),
('footer_text', 'Copyright © 2010 nbgteam.'),
('custom_css', '/* CSS Document - Important Note !!!\n  In this document the structure of the site is defined.\n  For all the problems caused by editing this document, we are not responsible.\n  Changes of the name of the class or id name, may cause structural problems.\n  Adding class with same name will cause problems.\n  Making changes are recommended only to professionals.\n  For your convenience, styles are defined starting from the top of the pages.\n*/\n\n/* ############## General Styles ###############*/\nbody {\n	margin:0;\n	padding:0;\n	font-family: ''Open Sans'', sans-serif; /* All pages */\n	font-size: 11px; /* All pages */\n	color: #000; /* All pages */\n}\n\n/* Headers */\nh1 {\n	font-family: ''Open Sans'', sans-serif;\n	font-size: 20px;\n	font-weight: bold;\n	margin:0px; padding:0; display:inline-block;\n	color: #000;\n}\n h2 {\n\n 	font-size: 20px;\n 	font-weight: normal;\n	color: #333;\n	margin: 0px; padding:0; display:inline;\n}\nh3 {\n	color: #333;\n	font-size: 13px;\n	font-weight: normal;\n	margin: 0px; padding:0; display:inline;\n}\nh4 {\n	color: #999999;\n	text-align: right;\n	font-size: 12px;\n	font-weight: normal;\n	margin: 0px; padding:0; display:inline;\n}\n\nh5 {\n	color: #FFFFFF;\n	font-size: 11px;\n	font-weight: normal;\n	margin: 0px; padding:0; display:inline;\n}\nh6 {\n	color: #333;\n	font-size: 11px;\n	font-weight: normal;\n	margin: 0px; padding:0; display:inline;\n}\n\n/* Links */\na {color: #000; font-size: 14px;}\na:hover {color:#009344;}\n\n/* Titles of Gallery and News pages */\n.page_title{\n	font-family: "Open Sans", sans-serif;\n	font-size: 20px;\n	font-weight: bold;\n	color: #000;\n}\n\n'),
('events_home_auto', '0'),
('newsletter_unsubscribed_again', 'You have already unsubscribed.'),
('custom_header', '<script type="text/javascript">\n/* Some JavaScript code */\n</script>'),
('custom_footer', '<script type="text/javascript">\n/* Google Analytics code */\n</script>'),
('main_menu_float', 'right'),
('main_submenu_bg', '#000000'),
('main_submenu_color', '#BDBDBD'),
('main_submenu_bg_mo', '#96873B'),
('main_submenu_color_mo', '#FFFFFF'),
('main_menu_color', '#FFFFFF'),
('main_menu_color_mo', '#C7C78D'),
('main_menu_bg_image', 'uploads/main_menu.gif'),
('left_menu_color', '#FFFFFF'),
('left_menu_color_mo', '#FFFFFF'),
('left_menu_bg', 'uploads/left_menu1.gif'),
('left_menu_bg_mo', 'uploads/left_menu.gif'),
('left_submenu_color', '#363636'),
('left_submenu_color_mo', '#000000'),
('left_submenu_bg', 'uploads/left_submenu1.gif'),
('left_submenu_bg_mo', 'uploads/left_submenu2.gif'),
('button_color', '#FFFFFF'),
('button_color_mo', '#EBEBEB'),
('button_bg', 'uploads/button_black.gif'),
('button_bg_mo', 'uploads/black_button2.gif'),
('newsletter_english_name', 'Your Name'),
('newsletter_english_email', 'E-mail Address'),
('newsletter_english_subscribe', 'Subscribe'),
('newsletter_english_header', '<p>\n	<img alt="Newsletter" height="65" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/newsletter_header.gif" width="194" /></p>\n'),
('newsletter_english_thank_you', 'Thank you for subscribing.'),
('polls_english_results', 'Results'),
('newsletter_english_unsubscribed', 'You have successfully unsubscribed.'),
('news_english_latest', 'Latest News'),
('polls_english_vote', 'Vote'),
('news_english_read_more', 'Read more ...'),
('news_english_back', 'Back'),
('news_english_title', ''),
('news_english_next_page', 'Next Page'),
('news_english_prev_page', 'Previous Page'),
('news_english_all', 'All News'),
('polls_english_title', 'Poll'),
('newsletter_srpski_name', 'Ime'),
('newsletter_srpski_email', 'E-mail'),
('newsletter_srpski_subscribe', 'Prijavi se'),
('newsletter_srpski_header', '<p>\n	Newsletter</p>\n'),
('newsletter_srpski_thank_you', 'Hvala što ste se prijavili na našu mejling listu.'),
('polls_srpski_results', 'Results'),
('newsletter_srpski_unsubscribed', 'Uspešno ste se odjavili sa naše mejling liste.'),
('news_srpski_latest', 'Poslednje Vesti'),
('polls_srpski_vote', 'Vote'),
('news_srpski_read_more', '>>'),
('news_srpski_back', 'Nazad'),
('news_srpski_title', ''),
('news_srpski_next_page', '>'),
('news_srpski_prev_page', '<'),
('events_srpski_all', 'All Events'),
('polls_srpski_title', 'Poll'),
('main_menu_repeat', 'repeat'),
('news_social', '4'),
('news_social_1', '<!-- AddThis Button BEGIN -->\n<div class="addthis_toolbox addthis_default_style">\n<a class="addthis_button_facebook_share" fb:share:layout="button_count"></a>\n<a class="addthis_button_facebook_like" fb:like:layout="button_count"></a>\n<a class="addthis_button_tweet"></a>\n<a class="addthis_button_google_plusone" g:plusone:size="medium"></a>\n<a class="addthis_counter addthis_pill_style"></a>\n</div>\n<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-4e9afd581f0517a6"></script>\n<!-- AddThis Button END -->'),
('news_social_2', '<!-- AddThis Button BEGIN -->\n<div class="addthis_toolbox addthis_default_style addthis_32x32_style">\n<a class="addthis_button_facebook"></a>\n<a class="addthis_button_twitter"></a>\n<a class="addthis_button_google_plusone_share"></a>\n<a class="addthis_button_compact"></a><a class="addthis_counter addthis_bubble_style"></a>\n</div>\n<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-4e9afd581f0517a6"></script>\n<!-- AddThis Button END -->'),
('news_social_3', '<!-- AddThis Button BEGIN -->\n<div class="addthis_toolbox addthis_default_style addthis_16x16_style">\n<a class="addthis_button_facebook"></a>\n<a class="addthis_button_twitter"></a>\n<a class="addthis_button_google_plusone_share"></a>\n<a class="addthis_button_compact"></a><a class="addthis_counter addthis_bubble_style"></a>\n</div>\n<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-4e9afd581f0517a6"></script>\n<!-- AddThis Button END -->'),
('news_social_4', '<style>\r\n.addthis_floating_style.addthis_counter_style {\r\n    width: auto;\r\n}\r\n.addthis_floating_style.addthis_counter_style .addthis_internal_container {\r\n    width: auto;\r\n}\r\n\r\n.addthis_floating_style .at300b, .addthis_floating_style .at300bo, .addthis_floating_style .at300m {\r\n    float: left;\r\n    padding: 0 3px;\r\n}\r\n.addthis_floating_style.addthis_counter_style .addthis_counter {\r\n    float: left;\r\n    padding-left: 3px;\r\n}\r\n</style>\r\n<!-- AddThis Button BEGIN -->\r\n<div class="addthis_toolbox addthis_floating_style addthis_counter_style addthis_bar_horisontal" style="position:relative;">\r\n<a class="addthis_button_facebook_share" fb:share:layout="box_count"></a>\r\n<a class="addthis_button_facebook_like" fb:like:layout="box_count"></a>\r\n<a class="addthis_button_tweet" tw:count="vertical"></a>\r\n<a class="addthis_button_google_plusone" g:plusone:size="tall"></a>\r\n<a class="addthis_counter"></a>\r\n</div>\r\n<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-4e9afd581f0517a6"></script>\r\n<!-- AddThis Button END -->'),
('news_social_5', ''),
('news_srpski_comments', 'Komentari'),
('news_english_comments', 'Comments'),
('news_srpski_add_comment', 'Pošalji >>'),
('news_english_add_comment', 'Write a Comment'),
('news_srpski_name', 'Ime >'),
('news_english_name', 'Your Name'),
('news_srpski_comment', 'Komentar >'),
('news_english_comment', 'Comment'),
('news_srpski_comment_sent', 'Komentar je poslat.'),
('news_english_comment_sent', 'Your comment has been submitted.'),
('comments_enabled', '1'),
('comments_approval', '1'),
('news_thumb_width', '150'),
('news_thumb_height', '120'),
('news_thumb_main', 'width'),
('gallery_thumb_width', '200'),
('gallery_thumb_height', '150'),
('gallery_thumb_main', 'width'),
('gallery_width', '800'),
('gallery_height', '600'),
('events_thumb_width', '150'),
('events_thumb_height', '120'),
('events_thumb_main', 'width'),
('events_per_page', '5'),
('events_home_limit', '5'),
('events_english_latest', 'Latest News'),
('events_english_read_more', 'Read more ...'),
('events_english_back', 'Back'),
('events_english_title', ''),
('events_english_next_page', 'Next Page'),
('events_english_prev_page', 'Previous Page'),
('events_english_all', 'All Events'),
('events_srpski_read_more', '>>'),
('events_srpski_back', 'Back'),
('events_srpski_title', ''),
('events_srpski_prev_page', 'Previous Page'),
('news_srpski_all', 'Sve vesti'),
('events_srpski_latest', 'Latest Events'),
('events_srpski_next_page', 'Next Page'),
('events_calendar_title_srpski', 'Događaji'),
('events_calendar_title_english', 'Events'),
('comments_events_enabled', '1'),
('comments_events_approval', '1'),
('events_social', '4'),
('news_srpski_related', 'Povezani dogadjaji'),
('news_english_related', 'Releted events'),
('comments_news_per_page', '2'),
('comments_events_per_page', '20'),
('footer_html_srpski', '<p>\n	© 2014 United Nations Development Programme</p>\n'),
('footer_html_english', '<table border="0" cellpadding="0" cellspacing="5" width="100%">\n	<tbody>\n		<tr>\n			<td align="left">\n				<div style="padding-left:25px;">\n					Copyright © 2012 nbgteam - nbgcreator.</div>\n			</td>\n			<td align="right">\n				<div style="padding-right:25px;">\n					<a class="nbg" href="http://www.nbgcreator.com" target="self" title="Web and Graphic Design - *nbgteam"><img alt="Powered by nbgteam" border="0" src="http://www.nbgcreator.com/images/nbgteamlogo_cms.jpg" /></a></div>\n			</td>\n			<td width="5">\n				 </td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	 </p>\n'),
('logo_html_srpski', '<p>\n	<a href="http://klimatskepromene.dev2.nbgcreator.com/"><img alt="" height="60" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/logo.png" width="143" /><br />\n	</a></p>\n'),
('logo_html_english', '<p>\n	<a href="/"><img alt="" height="57" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/logo_nbgcreator_v3-300dpi.png" width="300" /></a></p>\n'),
('events_srpski_related', 'Povezani dogadjaji'),
('events_english_related', 'Releted events'),
('products_header_english', '<p style="padding-bottom: 0px; padding-left: 0px; font-weight: bold;">\r\n	<font class="Apple-style-span" color="#b22222"><img alt="" height="52" src="http://www.biromarket.nbgcreator.com/uploads/useruploads/Photos/leftMenu_heder_eng.jpg" width="277" /><br />\r\n	</font></p>\r\n'),
('products_header_id', '0'),
('products_header_srpski', '<p style="padding-bottom: 0px; padding-left: 0px; font-weight: bold;">\n	<span style="color: rgb(178, 34, 34);"><br />\n	</span></p>\n'),
('products_per_page', '6'),
('eur_to_rsd', '10'),
('newsletter_deutsch_name', ''),
('newsletter_deutsch_email', ''),
('newsletter_deutsch_subscribe', ''),
('newsletter_deutsch_header', ''),
('newsletter_deutsch_thank_you', ''),
('polls_deutsch_results', ''),
('newsletter_deutsch_unsubscribed', ''),
('news_deutsch_latest', ''),
('polls_deutsch_vote', ''),
('news_deutsch_read_more', ''),
('news_deutsch_back', ''),
('news_deutsch_title', ''),
('news_deutsch_next_page', ''),
('news_deutsch_prev_page', ''),
('events_deutsch_all', ''),
('polls_deutsch_title', ''),
('news_deutsch_comments', ''),
('news_deutsch_add_comment', ''),
('news_deutsch_name', ''),
('news_deutsch_comment', ''),
('news_deutsch_comment_sent', ''),
('events_deutsch_read_more', ''),
('events_deutsch_back', ''),
('events_deutsch_title', ''),
('events_deutsch_prev_page', ''),
('news_deutsch_all', ''),
('events_deutsch_latest', ''),
('events_deutsch_next_page', ''),
('events_calendar_title_deutsch', ''),
('news_deutsch_related', ''),
('footer_html_deutsch', ''),
('logo_html_deutsch', ''),
('events_deutsch_related', ''),
('products_header_deutsch', ''),
('products_srpski_all', 'Svi proizvodi'),
('products_english_all', 'All productsssss'),
('logo_filepath', 'uploads/fblogo/mugen_mali.jpg');

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

--
-- Table structure for table `documents`
--

CREATE TABLE IF NOT EXISTS `documents` (
`id` int(11) NOT NULL,
  `filepath` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `size` float NOT NULL,
  `timestamp` int(11) NOT NULL,
  `uploader` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=13 ;

--
-- Dumping data for table `documents`
--

INSERT INTO `documents` (`id`, `filepath`, `name`, `type`, `size`, `timestamp`, `uploader`) VALUES
(1, 'uploads/useruploads/Documents/champ23.jpg', 'champ23.jpg', 'image/jpeg', 352.727, 1413809855, 'ivan selimbegovic'),
(2, 'uploads/useruploads/Documents/stampa.pdf', 'stampa.pdf', 'application/pdf', 218.784, 1413813153, 'ivan selimbegovic'),
(3, 'uploads/useruploads/Documents/llp.jpg', 'llp.jpg', 'image/jpeg', 23.2725, 1413894475, 'Ivan Selimbegovic'),
(4, 'uploads/useruploads/Documents/llp-2.jpg', 'llp-2.jpg', 'image/jpeg', 23.2725, 1413894533, 'Ivan Selimbegovic'),
(5, 'uploads/useruploads/Documents/mugen-mali.jpg', 'mugen-mali.jpg', 'image/jpeg', 5.99512, 1413894628, 'ivan '),
(6, 'uploads/useruploads/Documents/mugen-mali-2.jpg', 'mugen-mali-2.jpg', 'image/jpeg', 5.99512, 1413894669, 'ivan '),
(7, 'uploads/useruploads/Documents/mugen-mali-2.jpg', 'mugen-mali-2.jpg', 'image/jpeg', 5.99512, 1413894714, 'ivan '),
(8, 'uploads/useruploads/Documents/schamp2.jpg', 'schamp2.jpg', 'image/jpeg', 124.941, 1413894740, 'mile kitić'),
(9, 'uploads/useruploads/Documents/schamp2-2.jpg', 'schamp2-2.jpg', 'image/jpeg', 124.941, 1413894759, 'mile kitić'),
(10, 'uploads/useruploads/Documents/schamp2-2-2.jpg', 'schamp2-2-2.jpg', 'image/jpeg', 124.941, 1413894807, 'Ivan Selimbegovic'),
(11, 'uploads/useruploads/Documents/puma.jpg', 'puma.jpg', 'image/jpeg', 2.42969, 1413896266, 'fafafa sesese'),
(12, 'uploads/useruploads/Documents/pic-blog.jpg', 'pic-blog.jpg', 'image/jpeg', 150.534, 1413926585, 'Mika Mikic');

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

--
-- Table structure for table `documents_profile`
--

CREATE TABLE IF NOT EXISTS `documents_profile` (
`id` int(11) NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Dumping data for table `documents_profile`
--

INSERT INTO `documents_profile` (`id`, `username`, `password`) VALUES
(1, 'undp', '1f780b68e0ab7084c4b3c2e0533bdd9fbe25bb1b');

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

--
-- Table structure for table `events`
--

CREATE TABLE IF NOT EXISTS `events` (
`id` int(10) NOT NULL,
  `category` int(10) NOT NULL,
  `tags` text NOT NULL,
  `gallery_album` int(10) NOT NULL,
  `header` int(10) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `title_english` varchar(255) NOT NULL,
  `uri_english` varchar(255) NOT NULL,
  `seo_title_english` varchar(255) NOT NULL,
  `short_english` text NOT NULL,
  `long_english` text NOT NULL,
  `keywords_english` varchar(255) NOT NULL,
  `desc_english` varchar(255) NOT NULL,
  `title_srpski` varchar(255) NOT NULL,
  `uri_srpski` varchar(255) NOT NULL,
  `seo_title_srpski` varchar(255) NOT NULL,
  `short_srpski` text NOT NULL,
  `long_srpski` text NOT NULL,
  `keywords_srpski` varchar(255) NOT NULL,
  `desc_srpski` varchar(255) NOT NULL,
  `homepage` tinyint(1) NOT NULL,
  `timestamp` datetime NOT NULL,
  `search_column` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `events`
--

INSERT INTO `events` (`id`, `category`, `tags`, `gallery_album`, `header`, `photo`, `thumbnail`, `title_english`, `uri_english`, `seo_title_english`, `short_english`, `long_english`, `keywords_english`, `desc_english`, `title_srpski`, `uri_srpski`, `seo_title_srpski`, `short_srpski`, `long_srpski`, `keywords_srpski`, `desc_srpski`, `homepage`, `timestamp`, `search_column`) VALUES
(1, 1, '["prvi tag"]', 0, 0, 'uploads/events/1413888635-banner1.jpg', 'uploads/events/thumb_1413888635-banner1.jpg', '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet', '', '<p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n', '<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 0, '2014-10-21 00:00:00', ' Lorem ipsum dolor sit amet, dolor sit amet <p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n <p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n   '),
(2, 1, '["prvi tag"]', 0, 0, 'uploads/events/1413888674-banner1.jpg', 'uploads/events/thumb_1413888674-banner1.jpg', '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet-2', '', '<p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n', '<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 0, '2014-10-21 00:00:00', ' Lorem ipsum dolor sit amet, dolor sit amet <p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n <p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n   ');

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

--
-- Table structure for table `events_categories`
--

CREATE TABLE IF NOT EXISTS `events_categories` (
`id` int(10) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `uri_english` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `uri_srpski` varchar(255) NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `events_categories`
--

INSERT INTO `events_categories` (`id`, `name_english`, `uri_english`, `name_srpski`, `uri_srpski`, `position`) VALUES
(1, '', '', 'Aktivnosti', 'aktivnosti', 0);

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

--
-- Table structure for table `events_comments`
--

CREATE TABLE IF NOT EXISTS `events_comments` (
`id` int(10) NOT NULL,
  `event` int(10) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `timestamp` datetime NOT NULL,
  `author` varchar(255) NOT NULL,
  `comment` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `events_comments`
--

INSERT INTO `events_comments` (`id`, `event`, `approved`, `timestamp`, `author`, `comment`) VALUES
(1, 1, 1, '2014-10-21 12:52:08', 'Ivan Mijatović', 'Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum'),
(2, 1, 1, '2014-10-21 12:52:16', 'Ivan Mijatović', ' Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum Lorem ipsum'),
(3, 1, 0, '2014-10-21 12:59:57', 'fhjfghfghfgh', 'cvxcvxcvxcvxcvxcvcxvxcvxcvxcvxcv');

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

--
-- Table structure for table `events_tags`
--

CREATE TABLE IF NOT EXISTS `events_tags` (
  `tag` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `events_tags`
--

INSERT INTO `events_tags` (`tag`) VALUES
('prvi tag');

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

--
-- Table structure for table `gallery_albums`
--

CREATE TABLE IF NOT EXISTS `gallery_albums` (
`id` int(10) NOT NULL,
  `parent` int(10) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `header` int(10) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `uri_english` varchar(255) NOT NULL,
  `html_english` text NOT NULL,
  `desc_english` text NOT NULL,
  `meta_title_english` varchar(255) NOT NULL,
  `meta_desc_english` varchar(255) NOT NULL,
  `meta_keywords_english` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `uri_srpski` varchar(255) NOT NULL,
  `html_srpski` text NOT NULL,
  `desc_srpski` text NOT NULL,
  `meta_title_srpski` varchar(255) NOT NULL,
  `meta_desc_srpski` varchar(255) NOT NULL,
  `meta_keywords_srpski` varchar(255) NOT NULL,
  `position` int(10) NOT NULL,
  `search_column` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=49 ;

--
-- Dumping data for table `gallery_albums`
--

INSERT INTO `gallery_albums` (`id`, `parent`, `thumbnail`, `header`, `name_english`, `uri_english`, `html_english`, `desc_english`, `meta_title_english`, `meta_desc_english`, `meta_keywords_english`, `name_srpski`, `uri_srpski`, `html_srpski`, `desc_srpski`, `meta_title_srpski`, `meta_desc_srpski`, `meta_keywords_srpski`, `position`, `search_column`) VALUES
(16, 0, '', 0, 'Gallery on page', 'Gallery-on-page', '', '', '', '', '', 'Galerije na stranama', 'Galerije-na-stranama', '', '', '', '', '', 6, ' Galerije na stranama   Gallery on page  '),
(47, 0, 'uploads/gallery/albums/thumb_gallery2.jpg', 0, '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet-2', '<p>\n	 </p>\n', '', '', '', '', 0, ' Lorem ipsum dolor sit amet, dolor sit amet  <p>\n	 </p>\n   '),
(48, 0, 'uploads/gallery/albums/thumb_gallery3.jpg', 0, '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet-3', '<p>\n	 </p>\n', '', '', '', '', 0, ' Lorem ipsum dolor sit amet, dolor sit amet  <p>\n	 </p>\n   '),
(46, 0, 'uploads/gallery/albums/thumb_gallery1.jpg', 0, '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet', '<p>\n	 </p>\n', '', '', '', '', 0, ' Lorem ipsum dolor sit amet, dolor sit amet  <p>\n	 </p>\n   ');

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

--
-- Table structure for table `gallery_items`
--

CREATE TABLE IF NOT EXISTS `gallery_items` (
`id` int(10) NOT NULL,
  `album` int(10) NOT NULL,
  `type` enum('photo','video','youtube') NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `desc_english` text NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `desc_srpski` text NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;

--
-- Dumping data for table `gallery_items`
--

INSERT INTO `gallery_items` (`id`, `album`, `type`, `thumbnail`, `filename`, `youtube`, `name_english`, `desc_english`, `name_srpski`, `desc_srpski`, `position`) VALUES
(1, 47, 'photo', 'uploads/gallery/photos/thumb_23534-gallery_album.jpg', 'uploads/gallery/photos/23534-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 0),
(2, 47, 'photo', 'uploads/gallery/photos/thumb_16912-gallery_album.jpg', 'uploads/gallery/photos/16912-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 1),
(3, 47, 'photo', 'uploads/gallery/photos/thumb_63698-gallery_album.jpg', 'uploads/gallery/photos/63698-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 2),
(4, 47, 'photo', 'uploads/gallery/photos/thumb_39413-gallery_album.jpg', 'uploads/gallery/photos/39413-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 3),
(5, 47, 'photo', 'uploads/gallery/photos/thumb_90268-gallery_album.jpg', 'uploads/gallery/photos/90268-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 4),
(6, 47, 'photo', 'uploads/gallery/photos/thumb_30248-gallery_album.jpg', 'uploads/gallery/photos/30248-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 5),
(7, 47, 'photo', 'uploads/gallery/photos/thumb_46465-gallery_album.jpg', 'uploads/gallery/photos/46465-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 6),
(8, 47, 'photo', 'uploads/gallery/photos/thumb_11434-gallery_album.jpg', 'uploads/gallery/photos/11434-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 7),
(9, 47, 'photo', 'uploads/gallery/photos/thumb_64140-gallery_album.jpg', 'uploads/gallery/photos/64140-gallery_album.jpg', '', '', '', 'Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero.', '', 8);

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

--
-- Table structure for table `headers`
--

CREATE TABLE IF NOT EXISTS `headers` (
`id` int(10) NOT NULL,
  `type` enum('photo','flash','flash2','nivo') NOT NULL,
  `filename_english` varchar(255) NOT NULL,
  `filename_srpski` varchar(255) NOT NULL,
  `effect` int(1) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `transition_speed` int(10) NOT NULL,
  `pause_time` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `headers`
--

INSERT INTO `headers` (`id`, `type`, `filename_english`, `filename_srpski`, `effect`, `width`, `height`, `transition_speed`, `pause_time`) VALUES
(1, 'nivo', '', '', 0, 0, 0, 500, 10000);

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

--
-- Table structure for table `header_slides`
--

CREATE TABLE IF NOT EXISTS `header_slides` (
`id` int(10) NOT NULL,
  `header` int(10) NOT NULL,
  `language` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `video` varchar(255) NOT NULL,
  `youtube` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `text` varchar(255) NOT NULL,
  `link` varchar(255) NOT NULL,
  `effect` varchar(255) NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `header_slides`
--

INSERT INTO `header_slides` (`id`, `header`, `language`, `photo`, `video`, `youtube`, `title`, `text`, `link`, `effect`, `position`) VALUES
(1, 1, 'srpski', 'uploads/headers/slides/1413394349--slide1.jpg', '', 'http://www.youtube.com/watch?v=', 'Vreme je za promene', '', '', 'sliceDown', 0),
(2, 1, 'srpski', 'uploads/headers/slides/1413394349--slide2.png', '', 'http://www.youtube.com/watch?v=', 'Vreme je za promene Vreme je za promene', '', '', 'sliceDown', 1);

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

--
-- Table structure for table `newsletters`
--

CREATE TABLE IF NOT EXISTS `newsletters` (
`id` int(10) NOT NULL,
  `count` int(10) NOT NULL,
  `subject_english` varchar(255) NOT NULL,
  `message_english` text NOT NULL,
  `subject_srpski` varchar(255) NOT NULL,
  `message_srpski` text NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newsletter_lists`
--

CREATE TABLE IF NOT EXISTS `newsletter_lists` (
`id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newsletter_outbox`
--

CREATE TABLE IF NOT EXISTS `newsletter_outbox` (
`id` int(10) NOT NULL,
  `recipient` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newsletter_subscribers`
--

CREATE TABLE IF NOT EXISTS `newsletter_subscribers` (
`id` int(10) NOT NULL,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `list` int(10) NOT NULL,
  `language` varchar(255) NOT NULL,
  `count` int(10) NOT NULL,
  `timestamp` datetime NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `newsletter_templates`
--

CREATE TABLE IF NOT EXISTS `newsletter_templates` (
`id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `subject_english` varchar(255) NOT NULL,
  `message_english` text NOT NULL,
  `subject_srpski` varchar(255) NOT NULL,
  `message_srpski` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `news_articles`
--

CREATE TABLE IF NOT EXISTS `news_articles` (
`id` int(10) NOT NULL,
  `category` int(10) NOT NULL,
  `tags` text NOT NULL,
  `views` int(10) NOT NULL,
  `gallery_album` int(10) NOT NULL,
  `header` int(10) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `thumbnail` varchar(255) NOT NULL,
  `title_english` varchar(255) NOT NULL,
  `uri_english` varchar(255) NOT NULL,
  `seo_title_english` varchar(255) NOT NULL,
  `short_english` text NOT NULL,
  `long_english` text NOT NULL,
  `keywords_english` varchar(255) NOT NULL,
  `desc_english` varchar(255) NOT NULL,
  `title_srpski` varchar(255) NOT NULL,
  `uri_srpski` varchar(255) NOT NULL,
  `seo_title_srpski` varchar(255) NOT NULL,
  `short_srpski` text NOT NULL,
  `long_srpski` text NOT NULL,
  `keywords_srpski` varchar(255) NOT NULL,
  `desc_srpski` varchar(255) NOT NULL,
  `homepage` tinyint(1) NOT NULL,
  `timestamp` datetime NOT NULL,
  `search_column` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `news_articles`
--

INSERT INTO `news_articles` (`id`, `category`, `tags`, `views`, `gallery_album`, `header`, `photo`, `thumbnail`, `title_english`, `uri_english`, `seo_title_english`, `short_english`, `long_english`, `keywords_english`, `desc_english`, `title_srpski`, `uri_srpski`, `seo_title_srpski`, `short_srpski`, `long_srpski`, `keywords_srpski`, `desc_srpski`, `homepage`, `timestamp`, `search_column`) VALUES
(1, 1, '["prvi tag"]', 2, 0, 0, 'uploads/news/1413565857-banner1.jpg', 'uploads/news/thumb_1413565857-banner1.jpg', '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet', '', '<p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n', '<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 0, '2014-10-17 19:09:55', ' Lorem ipsum dolor sit amet, dolor sit amet <p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n <p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n   '),
(2, 1, '["prvi tag"]', 0, 0, 0, 'uploads/news/1413565903-banner1.jpg', 'uploads/news/thumb_1413565903-banner1.jpg', '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet-2', '', '<p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n', '<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 0, '2014-10-17 19:11:02', ' Lorem ipsum dolor sit amet, dolor sit amet <p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n <p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n   '),
(3, 1, '["prvi tag"]', 50, 0, 0, 'uploads/news/1413565939-banner1.jpg', 'uploads/news/thumb_1413565939-banner1.jpg', '', '', '', '', '', '', '', 'Lorem ipsum dolor sit amet, dolor sit amet', 'lorem-ipsum-dolor-sit-amet-dolor-sit-amet-3', '', '<p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n', '<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 0, '2014-10-17 19:11:47', ' Lorem ipsum dolor sit amet, dolor sit amet <p>\n	Lorem ipsum dolor sit amet, nisl esse suavitate ea vis. Sit eu cibo nobis. Duo ad vidit natum. Mei et mutat ipsum pericula...</p>\n <p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad. Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n   ');

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

--
-- Table structure for table `news_categories`
--

CREATE TABLE IF NOT EXISTS `news_categories` (
`id` int(10) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `uri_english` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `uri_srpski` varchar(255) NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `news_categories`
--

INSERT INTO `news_categories` (`id`, `name_english`, `uri_english`, `name_srpski`, `uri_srpski`, `position`) VALUES
(1, '', '', 'Blog', 'blog', 0),
(2, '', '', 'NAMA projekti cat', 'nama-projekti-cat', 0);

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

--
-- Table structure for table `news_comments`
--

CREATE TABLE IF NOT EXISTS `news_comments` (
`id` int(10) NOT NULL,
  `article` int(10) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `timestamp` datetime NOT NULL,
  `author` varchar(255) NOT NULL,
  `comment` text NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;

--
-- Dumping data for table `news_comments`
--

INSERT INTO `news_comments` (`id`, `article`, `approved`, `timestamp`, `author`, `comment`) VALUES
(1, 3, 1, '2014-10-17 19:14:16', 'Ivan Mijatović', 'Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.'),
(2, 3, 1, '2014-10-17 19:14:22', 'Ivan Mijatović', 'Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.'),
(3, 3, 1, '2014-10-17 19:14:27', 'Ivan Mijatović', 'Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.'),
(4, 3, 1, '2014-10-17 19:14:32', 'Ivan Mijatović', 'Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.'),
(5, 3, 1, '2014-10-17 19:14:37', 'Ivan Mijatović', 'Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.');

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

--
-- Table structure for table `news_tags`
--

CREATE TABLE IF NOT EXISTS `news_tags` (
`id` int(11) NOT NULL,
  `article_id` int(11) NOT NULL,
  `tag` varchar(255) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `news_tags`
--

INSERT INTO `news_tags` (`id`, `article_id`, `tag`) VALUES
(1, 1, 'prvi tag'),
(2, 2, 'prvi tag'),
(3, 3, 'prvi tag');

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

--
-- Table structure for table `pages`
--

CREATE TABLE IF NOT EXISTS `pages` (
`id` int(10) NOT NULL,
  `type` enum('main','left','other') NOT NULL,
  `parent` int(10) NOT NULL,
  `header` int(10) NOT NULL,
  `gallery_album` int(10) NOT NULL,
  `no_content` tinyint(1) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `title_english` varchar(255) NOT NULL,
  `seo_title_english` varchar(255) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `html_english` text NOT NULL,
  `keywords_english` varchar(255) NOT NULL,
  `desc_english` varchar(255) NOT NULL,
  `title_srpski` varchar(255) NOT NULL,
  `seo_title_srpski` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `html_srpski` text NOT NULL,
  `keywords_srpski` varchar(255) NOT NULL,
  `desc_srpski` varchar(255) NOT NULL,
  `position` int(10) NOT NULL,
  `timestamp` datetime NOT NULL,
  `search_column` text NOT NULL,
  `show_social_icons` tinyint(4) NOT NULL,
  `show_comments` tinyint(4) NOT NULL
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1000000158 ;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `type`, `parent`, `header`, `gallery_album`, `no_content`, `status`, `title_english`, `seo_title_english`, `name_english`, `html_english`, `keywords_english`, `desc_english`, `title_srpski`, `seo_title_srpski`, `name_srpski`, `html_srpski`, `keywords_srpski`, `desc_srpski`, `position`, `timestamp`, `search_column`, `show_social_icons`, `show_comments`) VALUES
(1000000001, 'other', 0, 0, 0, 0, 'active', 'Gallery', '', '', '<p>\n	Test</p>\n', '', '', 'Galerija', '', 'srpski/', '<p>\n	Test</p>\n', '', '', 2, '2014-04-02 13:10:03', ' Galerija <p>\n	Test</p>\n Gallery <p>\n	Test</p>\n', 0, 0),
(1000000002, 'main', 0, 0, 0, 0, 'active', 'News', '', '', '', '', '', 'Blog', 'Klimatske promene :: Blog', 'srpski/', '', '', '', 8, '2014-10-17 19:20:53', ' Blog  News ', 0, 0),
(1000000006, 'main', 0, 1, 0, 0, 'active', 'Home', 'Home', 'english/home', '<table cellpadding="0" cellspacing="0">\n	<tbody>\n		<tr>\n			<td width="13">\n				<img src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/title1_29.gif" /></td>\n			<td>\n				<h1>\n					Main Title Sample</h1>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Subtitle sample</h2>\n<p>\n	 </p>\n<p>\n	<span style="color: rgb(255, 0, 0);"><strong><span style="font-weight: bold;">All of the wording </span></strong></span>are just examples. <span style="color: rgb(255, 0, 0);"><strong>All of the photos</strong></span> are used as examples and are not to be copied.</p>\n<p>\n	 </p>\n<p>\n	<span style="color: rgb(255, 0, 0);"><strong>All of the pages</strong></span> are made as examples to facilitate the use of our web site / system / product.</p>\n<p>\n	 </p>\n<p>\n	<br />\n	<br />\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo1_34.jpg" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo2.jpg" /></p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<p>\n	<img align="right" alt=" " src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo3.jpg" /><span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n', '', '', 'Početna', 'Početna', 'srpski/pocetna', '', '', '', 0, '2014-10-15 19:32:54', ' Početna  Home <table cellpadding="0" cellspacing="0">\n	<tbody>\n		<tr>\n			<td width="13">\n				<img src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/title1_29.gif" /></td>\n			<td>\n				<h1>\n					Main Title Sample</h1>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Subtitle sample</h2>\n<p>\n	 </p>\n<p>\n	<span style="color: rgb(255, 0, 0);"><strong><span style="font-weight: bold;">All of the wording </span></strong></span>are just examples. <span style="color: rgb(255, 0, 0);"><strong>All of the photos</strong></span> are used as examples and are not to be copied.</p>\n<p>\n	 </p>\n<p>\n	<span style="color: rgb(255, 0, 0);"><strong>All of the pages</strong></span> are made as examples to facilitate the use of our web site / system / product.</p>\n<p>\n	 </p>\n<p>\n	<br />\n	<br />\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo1_34.jpg" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo2.jpg" /></p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<h2>\n	<img longdesc="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/arrow_subtitle.gif" />Lorem ipsum dolor consectetuer adipiscing elit</h2>\n<p>\n	 </p>\n<p>\n	<span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi <a class="black" href="#" target="self">enim ad minim veniam</a> enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n<p>\n	 </p>\n<p>\n	<img align="right" alt=" " src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/photo3.jpg" /><span class="black_line">Lorem ipsum dolor consectetuer</span> sed diam nonummy nibh euismod tincidunt ut laoreet dolore magna aliquam erat volutpat. Ut wisi enim ad minim veniam enim ad minim veniam, quis nostrud exerci tation ullamcorper suscipit lobortis nisl ut aliquip consequat hendrerit in vulputate velit esse molestie consequat, vel illum dolore.</p>\n', 1, 1),
(1000000155, 'other', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Razmena dokumenata', 'Razmena dokumenata', 'srpski/razmena-dokumenata', '<p>\n	 </p>\n', '', '', 7, '2014-10-20 19:36:21', ' Razmena dokumenata <p>\n	 </p>\n  ', 0, 0),
(1000000157, 'left', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'O nama', 'O nama', 'srpski/o-nama', '<p>\n	 </p>\n', '', '', 0, '2014-10-20 19:58:16', ' O nama <p>\n	 </p>\n  ', 0, 0),
(1000000099, 'other', 0, 0, 0, 0, 'active', 'Error page', '', 'english/error-page', '<p>\n	 </p>\n', '', '', 'Error page', '', 'srpski/error-page', '<p>\n	 </p>\n', '', '', 6, '2013-02-06 14:10:05', ' Error page <p>\n	 </p>\n Error page <p>\n	 </p>\n', 0, 0),
(1000000053, 'left', 0, 0, 0, 0, 'active', 'Contact', 'Contact', 'english/contact', '<p>\n	 </p>\n', '', '', 'Kontakt', 'Kontakt', 'srpski/kontakt', '<p>\n	Ovde kontakt podaci</p>\n<p>\n	 </p>\n', '', '', 0, '2014-04-08 15:43:24', ' Kontakt <p>\n	Ovde kontakt podaci</p>\n<p>\n	 </p>\n Contact <p>\n	 </p>\n', 0, 0),
(1000000154, 'main', 1000000136, 0, 0, 0, 'active', '', '', '', '', '', '', 'Istraživanja i osmatranja', 'Klimatske promene :: Istraživanja i osmatranja', 'srpski/istrazivanja-i-osmatranja', '<p>\n	 </p>\n', '', '', 4, '2014-10-14 13:15:42', '', 0, 0),
(1000000152, 'main', 1000000136, 0, 0, 0, 'active', '', '', '', '', '', '', 'Mere mitigacije', 'Klimatske promene :: Mere mitigacije', 'srpski/mere-mitigacije-2-2', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 13:14:42', '', 0, 0),
(1000000153, 'main', 1000000136, 0, 0, 0, 'active', '', '', '', '', '', '', 'Ranjivost i adaptacija', 'Klimatske promene :: Ranjivost i adaptacija', 'srpski/ranjivost-i-adaptacija', '<p>\n	 </p>\n', '', '', 3, '2014-10-14 13:15:13', '', 0, 0),
(1000000147, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'CDM Strategija', 'Klimatske promene :: CDM Strategija', 'srpski/cdm-strategija-2', '<p>\n	 </p>\n', '', '', 5, '2014-10-14 12:43:43', '', 0, 0),
(1000000148, 'main', 1000000125, 0, 0, 0, 'active', '', '', '', '', '', '', 'Serbian Guideline', 'Klimatske promene :: Serbian Guideline', 'srpski/serbian-guideline', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 12:44:16', '', 0, 0),
(1000000149, 'main', 1000000125, 0, 0, 0, 'active', '', '', '', '', '', '', 'NAMA projekti', 'Klimatske promene :: NAMA projekti', 'srpski/nama-projekti', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:44:36', '', 0, 0),
(1000000150, 'main', 1000000136, 0, 0, 0, 'active', '', '', '', '', '', '', 'Nacionalne karakteristike', 'Klimatske promene :: Nacionalne karakteristike', 'srpski/nacionalne-karakteristike-2', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 13:13:11', '', 0, 0),
(1000000151, 'main', 1000000136, 0, 0, 0, 'active', '', '', '', '', '', '', 'GHG Inventar', 'Klimatske promene :: GHG Inventar ', 'srpski/ghg-inventar-2-2', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 13:13:57', '', 0, 0),
(1000000062, 'other', 0, 0, 0, 0, 'active', 'Search', '', 'english/search', '', '', '', 'Pretraga', '', 'srpski/pretraga', '', '', '', 4, '2012-08-08 13:02:19', ' Pretraga  Search ', 0, 0),
(1000000120, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Obaveze prema UN', 'Klimatske promene :: Obaveze prema UN', 'srpski/obaveze-prema-un', '<h1>\n	Obaveze prema UN</h1>\n<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. </strong></p>\n<p>\n	<br />\n	Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis.</p>\n<p>\n	 </p>\n<p>\n	Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. <a href="http://google.rs" target="_blank">Quo an case suscipit lobortis</a>. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.</p>\n<p>\n	 </p>\n<p>\n	Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n', '', '', 1, '2014-10-21 12:56:01', ' Obaveze prema UN <h1>\n	Obaveze prema UN</h1>\n<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. </strong></p>\n<p>\n	<br />\n	Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis.</p>\n<p>\n	 </p>\n<p>\n	Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. <a href="http://google.rs" target="_blank">Quo an case suscipit lobortis</a>. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.</p>\n<p>\n	 </p>\n<p>\n	Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n  ', 0, 0),
(1000000121, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Obaveze prema EU', 'Klimatske promene :: Obaveye prema EU', 'srpski/obaveze-prema-eu', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 12:26:34', ' Obaveze prema EU <p>\n	 </p>\n  ', 0, 0),
(1000000122, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Aktivnosti', 'Klimatske promene :: Aktivnosti', 'srpski/aktivnosti', '<p>\n	 </p>\n', '', '', 3, '2014-10-14 12:27:54', ' Aktivnosti <p>\n	 </p>\n  ', 0, 0),
(1000000123, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Projekti', 'Klimatske promene :: Projekti', 'srpski/projekti', '<p>\n	 </p>\n', '', '', 4, '2014-10-14 12:28:18', ' Projekti <p>\n	 </p>\n  ', 0, 0),
(1000000124, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'DNA', 'Klimatske promene :: DNA', 'srpski/dna', '<p>\n	 </p>\n', '', '', 5, '2014-10-14 12:29:21', ' DNA <p>\n	 </p>\n  ', 0, 0),
(1000000125, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'NAMA', 'Klimatske promene :: NAMA', 'srpski/nama', '', '', '', 6, '2014-10-20 13:43:22', ' NAMA   ', 0, 0),
(1000000126, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Linkovi', 'Klimatske promene :: Linkovi', 'srpski/linkovi', '<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	<a href="http://google.rs/" target="_blank">Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</a></p>\n<hr />\n<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	<a href="http://google.rs/" target="_blank">Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</a></p>\n<hr />\n', '', '', 7, '2014-10-20 12:51:24', ' Linkovi <p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	<a href="http://google.rs/" target="_blank">Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</a></p>\n<hr />\n<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n<p>\n	&nbsp;</p>\n<p>\n	<a href="http://google.rs/" target="_blank">Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</a></p>\n<hr />\n  ', 0, 0),
(1000000127, 'main', 0, 0, 0, 0, 'active', '', '', '', '', '', '', 'Registrovani korisnici', 'Klimatske promene :: Registrovani korisnici', 'srpski/registrovani-korisnici', '<p>\n	 </p>\n', '', '', 9, '2014-10-14 12:32:34', ' Registrovani korisnici <p>\n	 </p>\n  ', 0, 0),
(1000000128, 'main', 1000000120, 0, 0, 0, 'active', '', '', '', '', '', '', 'Info o UNFCCC i Kjoto protokolu', 'Klimatske promene :: Info o UNFCCC i Kjoto protokolu', 'srpski/info-o-unfccc-i-kjoto-protokolu', '<h1>\n	NAMA</h1>\n<p>\n	<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. </strong></p>\n<p>\n	<br />\n	Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis.</p>\n<p>\n	<img alt="" height="336" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/article.jpg" width="509" /></p>\n<p>\n	Lorem ipsum dolor sit amet, justo efficiantur usu ne, vero definiebas sit ei, ex porro dignissim sed. At mel essent prodesset intellegam, ut quis appetere posidonium sit. Natum accusam ne usu. Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis.</p>\n<p>\n	 </p>\n<p>\n	Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no, vis case modus reformidans te. Vis ea dolor delicata. Quo an case suscipit lobortis. Vis quot dolorum te. Qui soluta accusam ex, sed ei debet dolore. Amet dicit sit ex. His ut labores platonem delicatissimi, inani nemore fabellas ut his. An ipsum choro nullam sed. Vis voluptua explicari ad.</p>\n<p>\n	 </p>\n<p>\n	Cu aliquip meliore epicuri nam, et mei inimicus perpetua appellantur. Et quot lorem iracundia sed. Pro et quod viderer hendrerit, essent contentiones no vim, vim ad commodo persius. Libris doctus sit et, ne sanctus habemus offendit sed, ad duo minim possim.</p>\n\n', '', '', 0, '2014-10-20 13:44:30', '', 0, 0),
(1000000065, 'other', 0, 0, 0, 0, 'active', 'Events', '', '', '', '', '', 'Dogadjaji', 'Dogadjaji', 'srpski/', '', '', '', 1, '2014-10-21 12:51:34', ' Dogadjaji  Events ', 0, 0),
(1000000143, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'PDD', 'Klimatske promene :: PDD', 'srpski/pdd', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:42:27', '', 0, 0),
(1000000144, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'Poslovnik DNA', 'Klimatske promene :: Poslovnik DNA', 'srpski/poslovnik-dna', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 12:42:47', '', 0, 0),
(1000000145, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'Uredba', 'Klimatske promene :: Uredba', 'srpski/uredba', '<p>\n	 </p>\n', '', '', 3, '2014-10-14 12:43:06', '', 0, 0),
(1000000146, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'Odluka', 'Klimatske promene :: Odluka', 'srpski/odluka', '<p>\n	 </p>\n', '', '', 4, '2014-10-14 12:43:22', '', 0, 0),
(1000000142, 'main', 1000000124, 0, 0, 0, 'active', '', '', '', '', '', '', 'PIN', 'Klimatske promene :: PIN', 'srpski/pin', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 12:42:11', '', 0, 0),
(1000000140, 'main', 1000000137, 0, 0, 0, 'active', '', '', '', '', '', '', 'Mere mitigacije', 'Klimatske promene :: Mere mitigacije', 'srpski/mere-mitigacije', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 12:41:17', '', 0, 0),
(1000000141, 'main', 1000000137, 0, 0, 0, 'active', '', '', '', '', '', '', 'MRV', 'Klimatske promene :: MRV', 'srpski/mrv', '<p>\n	 </p>\n', '', '', 3, '2014-10-14 12:41:34', '', 0, 0),
(1000000090, 'other', 0, 0, 0, 0, 'active', 'Newsletter', '', 'english/newsletter', '<p>\n	 </p>\n', '', '', 'Newsletter', '', 'srpski/newsletter', '<p>\n	 </p>\n', '', '', 5, '2012-12-09 20:53:31', ' Newsletter <p>\n	 </p>\n Newsletter <p>\n	 </p>\n', 0, 0),
(1000000139, 'main', 1000000137, 0, 0, 0, 'active', '', '', '', '', '', '', 'GHG Inventar', 'Klimatske promene :: GHG Inventar', 'srpski/ghg-inventar', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:40:49', '', 0, 0),
(1000000138, 'main', 1000000137, 0, 0, 0, 'active', '', '', '', '', '', '', 'Nacionalne karakteristike', 'Klimatske promene :: Nacionalne karakteristike', 'srpski/nacionalne-karakteristike', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 12:40:24', '', 0, 0),
(1000000129, 'main', 1000000120, 0, 0, 0, 'active', '', '', '', '', '', '', 'Initial National Communication', 'Klimatske promene :: Initial National Communication', 'srpski/initial-national-communication', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:35:05', '', 0, 0),
(1000000130, 'main', 1000000120, 0, 0, 0, 'active', '', '', '', '', '', '', 'CDM strategija', 'Klimatske promene :: CDM strategija', 'srpski/cdm-strategija', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 12:35:42', '', 0, 0),
(1000000131, 'main', 1000000120, 0, 0, 0, 'active', '', '', '', '', '', '', 'Dosadašnji izveštaji sa Cop', 'Klimatske promene :: Dosadašnji izveštaji sa Cop', 'srpski/dosadasnji-izvestaji-sa-cop', '<table align="left" border="0" cellpadding="0" cellspacing="0" style="width: 100%;">\n	<tbody>\n		<tr>\n			<td align="left" style="width: 160px;" valign="top">\n				<img alt="" height="100" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/un-img.jpg" width="150" /></td>\n			<td align="left" style="width: 350px;" valign="top">\n				<p>\n					<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n				<p>\n					&nbsp;</p>\n				<p>\n					Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</p>\n				<p>\n					&nbsp;</p>\n				<p>\n					<a href="#">Preuzmite .PDF dokument</a></p>\n			</td>\n		</tr>\n		<tr>\n			<td align="left" style="width: 160px;" valign="top">\n				<img alt="" height="100" src="http://klimatskepromene.dev2.nbgcreator.com/uploads/useruploads/Photos/un-img.jpg" width="150" /></td>\n			<td align="left" style="width: 350px;" valign="top">\n				<p>\n					<strong>Lorem ipsum dolor sit amet, justo efficiantur usu ne, justo efficiantur.</strong></p>\n				<p>\n					&nbsp;</p>\n				<p>\n					Vidit dicant detracto no nec. Ei etiam mollis appetere vix, reque partem sea eu. No pri sapientem honestatis. Doming alterum ex quo, veniam everti dissentiunt ea vim. Ne omittam menandri vituperatoribus nam, ullum erant sit no.</p>\n				<p>\n					&nbsp;</p>\n				<p>\n					<a href="#">Preuzmite .PDF dokument</a></p>\n			</td>\n		</tr>\n	</tbody>\n</table>\n<p>\n	 </p>\n', '', '', 3, '2014-10-20 23:23:11', '', 0, 0),
(1000000132, 'main', 1000000121, 0, 0, 0, 'active', '', '', '', '', '', '', 'EU Paket za klimu i energiju', 'Klimatske promene :: EU Paket za klimu i energiju', 'srpski/eu-paket-za-klimu-i-energiju', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 12:37:05', '', 0, 0),
(1000000133, 'main', 1000000121, 0, 0, 0, 'active', '', '', '', '', '', '', 'EU ETS projekat', 'Klimatske promene :: EU ETS projekat', 'srpski/eu-ets-projekat', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:37:31', '', 0, 0),
(1000000134, 'main', 1000000121, 0, 0, 0, 'active', '', '', '', '', '', '', 'MMR projekat', 'Klimatske promene :: MMR projekat', 'srpski/mmr-projekat', '<p>\n	 </p>\n', '', '', 2, '2014-10-14 12:38:00', '', 0, 0),
(1000000135, 'main', 1000000121, 0, 0, 0, 'active', '', '', '', '', '', '', 'Strategija IPA', 'Klimatske promene :: Strategija IPA', 'srpski/strategija-ipa', '<p>\n	 </p>\n', '', '', 3, '2014-10-14 12:38:28', '', 0, 0),
(1000000136, 'main', 1000000123, 0, 0, 0, 'active', '', '', '', '', '', '', 'Second National Communication', 'Klimatske promene :: Second National Communication', 'srpski/second-national-communication', '<p>\n	 </p>\n', '', '', 0, '2014-10-14 12:39:29', '', 0, 0),
(1000000137, 'main', 1000000123, 0, 0, 0, 'active', '', '', '', '', '', '', 'First Biennial Update Report', 'Klimatske promene :: First Biennial Update Report', 'srpski/first-biennial-update-report', '<p>\n	 </p>\n', '', '', 1, '2014-10-14 12:40:02', '', 0, 0),
(1000000118, 'other', 0, 0, 0, 0, 'active', 'Products', '', 'english/products', '<p>\n	 </p>\n', '', '', 'Proizvodi', 'Proizvodi', 'srpski/proizvodi', '<p>\n	 </p>\n', '', '', 3, '2014-10-11 00:11:06', ' Proizvodi <p>\n	 </p>\n Products <p>\n	 </p>\n', 0, 0);

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

--
-- Table structure for table `pages_comments`
--

CREATE TABLE IF NOT EXISTS `pages_comments` (
`id` int(10) NOT NULL,
  `page_id` int(10) NOT NULL,
  `approved` tinyint(1) NOT NULL,
  `timestamp` datetime NOT NULL,
  `author` varchar(255) NOT NULL,
  `comment` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `pages_history`
--

CREATE TABLE IF NOT EXISTS `pages_history` (
`id` int(10) NOT NULL,
  `type` enum('main','left','other') NOT NULL,
  `parent` int(10) NOT NULL,
  `header` int(10) NOT NULL,
  `gallery_album` int(10) NOT NULL,
  `no_content` tinyint(1) NOT NULL,
  `status` enum('active','inactive') NOT NULL,
  `title_english` varchar(255) NOT NULL,
  `seo_title_english` varchar(255) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `html_english` text NOT NULL,
  `keywords_english` varchar(255) NOT NULL,
  `desc_english` varchar(255) NOT NULL,
  `title_srpski` varchar(255) NOT NULL,
  `seo_title_srpski` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `html_srpski` text NOT NULL,
  `keywords_srpski` varchar(255) NOT NULL,
  `desc_srpski` varchar(255) NOT NULL,
  `position` int(10) NOT NULL,
  `timestamp` datetime NOT NULL,
  `search_column` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `polls`
--

CREATE TABLE IF NOT EXISTS `polls` (
`id` int(10) NOT NULL,
  `type` enum('single','multiple') NOT NULL,
  `question_english` varchar(255) NOT NULL,
  `answers_english` text NOT NULL,
  `question_srpski` varchar(255) NOT NULL,
  `answers_srpski` text NOT NULL,
  `results` text NOT NULL,
  `active` tinyint(1) NOT NULL,
  `timestamp` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `products_brands`
--

CREATE TABLE IF NOT EXISTS `products_brands` (
`id` int(10) NOT NULL,
  `name` varchar(255) NOT NULL,
  `logo` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `products_categories`
--

CREATE TABLE IF NOT EXISTS `products_categories` (
`id` int(10) NOT NULL,
  `parent` int(10) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `title_tag_srpski` varchar(255) NOT NULL,
  `title_tag_english` varchar(255) NOT NULL,
  `position` int(10) NOT NULL,
  `photo` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `products_items`
--

CREATE TABLE IF NOT EXISTS `products_items` (
`id` int(10) NOT NULL,
  `category` int(10) NOT NULL,
  `brand` int(10) NOT NULL,
  `custom_id` varchar(255) NOT NULL,
  `special_offer` tinyint(1) NOT NULL,
  `name_english` varchar(255) NOT NULL,
  `additional_name_english` varchar(255) NOT NULL,
  `name_srpski` varchar(255) NOT NULL,
  `additional_name_srpski` varchar(255) NOT NULL,
  `description_english` text NOT NULL,
  `description_srpski` text NOT NULL,
  `title_tag_srpski` varchar(255) NOT NULL,
  `title_tag_english` varchar(255) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `youtube` text NOT NULL,
  `position` int(10) NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `specs_srpski` varchar(255) NOT NULL,
  `specs_english` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `products_photos`
--

CREATE TABLE IF NOT EXISTS `products_photos` (
`id` int(10) NOT NULL,
  `product` int(10) NOT NULL,
  `photo` varchar(255) NOT NULL,
  `position` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ci_sessions`
--
ALTER TABLE `ci_sessions`
 ADD PRIMARY KEY (`session_id`);

--
-- Indexes for table `config`
--
ALTER TABLE `config`
 ADD KEY `key` (`key`);

--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `documents_profile`
--
ALTER TABLE `documents_profile`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events`
--
ALTER TABLE `events`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `long_english` (`long_english`), ADD FULLTEXT KEY `long_srpski` (`long_srpski`), ADD FULLTEXT KEY `short_srpski` (`short_srpski`), ADD FULLTEXT KEY `short_srpski_2` (`short_srpski`), ADD FULLTEXT KEY `long_srpski_2` (`long_srpski`), ADD FULLTEXT KEY `search_column` (`search_column`), ADD FULLTEXT KEY `search_column_2` (`search_column`);

--
-- Indexes for table `events_categories`
--
ALTER TABLE `events_categories`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `events_comments`
--
ALTER TABLE `events_comments`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `gallery_albums`
--
ALTER TABLE `gallery_albums`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `search_column` (`search_column`);

--
-- Indexes for table `gallery_items`
--
ALTER TABLE `gallery_items`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `headers`
--
ALTER TABLE `headers`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `header_slides`
--
ALTER TABLE `header_slides`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletters`
--
ALTER TABLE `newsletters`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletter_lists`
--
ALTER TABLE `newsletter_lists`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletter_outbox`
--
ALTER TABLE `newsletter_outbox`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletter_templates`
--
ALTER TABLE `newsletter_templates`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news_articles`
--
ALTER TABLE `news_articles`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `long_english` (`long_english`), ADD FULLTEXT KEY `long_srpski` (`long_srpski`), ADD FULLTEXT KEY `short_srpski` (`short_srpski`), ADD FULLTEXT KEY `short_srpski_2` (`short_srpski`), ADD FULLTEXT KEY `long_srpski_2` (`long_srpski`), ADD FULLTEXT KEY `search_column` (`search_column`), ADD FULLTEXT KEY `search_column_2` (`search_column`);

--
-- Indexes for table `news_categories`
--
ALTER TABLE `news_categories`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news_comments`
--
ALTER TABLE `news_comments`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `news_tags`
--
ALTER TABLE `news_tags`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `html_english` (`html_english`), ADD FULLTEXT KEY `html_srpski` (`html_srpski`), ADD FULLTEXT KEY `search_column` (`search_column`);

--
-- Indexes for table `pages_comments`
--
ALTER TABLE `pages_comments`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `pages_history`
--
ALTER TABLE `pages_history`
 ADD PRIMARY KEY (`id`), ADD FULLTEXT KEY `html_english` (`html_english`), ADD FULLTEXT KEY `html_srpski` (`html_srpski`), ADD FULLTEXT KEY `search_column` (`search_column`);

--
-- Indexes for table `polls`
--
ALTER TABLE `polls`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_brands`
--
ALTER TABLE `products_brands`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_categories`
--
ALTER TABLE `products_categories`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_items`
--
ALTER TABLE `products_items`
 ADD PRIMARY KEY (`id`);

--
-- Indexes for table `products_photos`
--
ALTER TABLE `products_photos`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `documents_profile`
--
ALTER TABLE `documents_profile`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `events`
--
ALTER TABLE `events`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `events_categories`
--
ALTER TABLE `events_categories`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `events_comments`
--
ALTER TABLE `events_comments`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `gallery_albums`
--
ALTER TABLE `gallery_albums`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=49;
--
-- AUTO_INCREMENT for table `gallery_items`
--
ALTER TABLE `gallery_items`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
--
-- AUTO_INCREMENT for table `headers`
--
ALTER TABLE `headers`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `header_slides`
--
ALTER TABLE `header_slides`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `newsletters`
--
ALTER TABLE `newsletters`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `newsletter_lists`
--
ALTER TABLE `newsletter_lists`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `newsletter_outbox`
--
ALTER TABLE `newsletter_outbox`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `newsletter_templates`
--
ALTER TABLE `newsletter_templates`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `news_articles`
--
ALTER TABLE `news_articles`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `news_categories`
--
ALTER TABLE `news_categories`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `news_comments`
--
ALTER TABLE `news_comments`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `news_tags`
--
ALTER TABLE `news_tags`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1000000158;
--
-- AUTO_INCREMENT for table `pages_comments`
--
ALTER TABLE `pages_comments`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pages_history`
--
ALTER TABLE `pages_history`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `polls`
--
ALTER TABLE `polls`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products_brands`
--
ALTER TABLE `products_brands`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products_categories`
--
ALTER TABLE `products_categories`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products_items`
--
ALTER TABLE `products_items`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `products_photos`
--
ALTER TABLE `products_photos`
MODIFY `id` int(10) NOT NULL AUTO_INCREMENT;
/*!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 */;