-- Dumping data for table `ngn_postal_atribute_values`
--

INSERT INTO `ngn_postal_atribute_values` VALUES (1,5,0,'1','',0),(2,5,0,'2','',0),(3,5,0,'3','',0),(4,6,0,'BANKTRANSFER','',18),(5,6,0,'POSTPAID','',0),(6,6,1,'UPN','',19),(7,6,1,'CASH','',1),(8,6,1,'VISA','',2),(9,6,0,'PAYPAL','',3),(10,6,1,'MONETA','',4),(11,6,1,'MONEYBOOKERS','',5),(12,6,1,'3DSECURE_BANKART','',6),(13,6,1,'ACTIVA','',7),(14,6,1,'REVERZ','',8),(15,6,1,'AMERICAN','',9),(16,6,1,'MASTERCARD','',10),(17,6,1,'MAESTRO','',11),(18,6,1,'DINERS','',12),(19,6,1,'KARANTA','',13),(20,6,0,'BRAINTREE','',14),(21,6,1,'INDASHOP','',15),(22,6,1,'PAYUNITY','',16),(23,6,1,'INDASHOP','',17),(24,11,1,'1','',0),(25,11,1,'2','',1),(26,11,1,'4','',3),(27,11,1,'3','',2),(28,6,0,'STRIPE','',0);

--
-- Table structure for table `ngn_postal_atribute_values_language`
--

CREATE TABLE `ngn_postal_atribute_values_language` (
  `value_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`value_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_atribute_values_language`
--

INSERT INTO `ngn_postal_atribute_values_language` VALUES (1,1,'2022-10-24 14:11:12',0,0,'Višja stopnja',NULL,NULL,NULL,'visja-stopnja',''),(1,2,'2022-10-24 14:11:12',0,0,'Višja stopnja',NULL,NULL,NULL,'visja-stopnja',''),(1,3,'2020-05-18 14:15:59',0,0,'Višja stopnja',NULL,NULL,NULL,'visja-stopnja',''),(2,1,'2022-10-24 14:11:12',0,0,'Nižja stopnja',NULL,NULL,NULL,'nizja-stopnja',''),(2,2,'2022-10-24 14:11:12',0,0,'Nižja stopnja',NULL,NULL,NULL,'nizja-stopnja',''),(2,3,'2020-05-18 14:15:59',0,0,'Nižja stopnja',NULL,NULL,NULL,'nizja-stopnja',''),(3,1,'2022-10-24 14:11:12',0,0,'Brez davka',NULL,NULL,NULL,'brez-davka',''),(3,2,'2022-10-24 14:11:12',0,0,'Brez davka',NULL,NULL,NULL,'brez-davka',''),(3,3,'2020-05-18 14:15:59',0,0,'Brez davka',NULL,NULL,NULL,'brez-davka',''),(4,1,'2022-12-06 09:21:56',0,0,'Bančno nakazilo',NULL,NULL,NULL,'bancno-nakazilo',''),(4,2,'2022-12-06 09:21:56',0,0,'Bank transfer',NULL,NULL,NULL,'bank-transfer',''),(4,3,'2020-06-18 14:59:13',0,0,'Bank transfer upon proforma invoice',NULL,NULL,NULL,'bank-transfer-upon-proforma-invoice',''),(5,1,'2022-12-06 09:21:55',0,0,'Pay at pickup',NULL,NULL,NULL,'pay-at-pickup',''),(5,2,'2022-12-06 09:21:55',0,0,'Plačilo po povzetju',NULL,NULL,NULL,'placilo-po-povzetju',''),(5,3,'2020-06-18 14:59:12',0,0,'',NULL,NULL,NULL,'5-',''),(6,1,'2022-12-06 09:21:56',0,0,'Plačilo z UPN obrazcem',NULL,NULL,NULL,'placilo-z-upn-obrazcem',''),(6,2,'2022-12-06 09:21:56',0,0,'Plačilo z UPN obrazcem',NULL,NULL,NULL,'placilo-z-upn-obrazcem',''),(6,3,'2020-06-18 14:59:13',0,0,'Plačilo z UPN obrazcem',NULL,NULL,NULL,'placilo-z-upn-obrazcem',''),(7,1,'2022-12-06 09:21:55',0,0,'Gotovina',NULL,NULL,NULL,'gotovina',''),(7,2,'2022-12-06 09:21:55',0,0,'Gotovina',NULL,NULL,NULL,'gotovina',''),(7,3,'2020-06-18 14:59:12',0,0,'Gotovina',NULL,NULL,NULL,'gotovina',''),(8,1,'2022-12-06 09:21:55',0,0,'Plačilo z VISA kartico',NULL,NULL,NULL,'placilo-z-visa-kartico',''),(8,2,'2022-12-06 09:21:55',0,0,'Plačilo z VISA kartico',NULL,NULL,NULL,'placilo-z-visa-kartico',''),(8,3,'2020-06-18 14:59:12',0,0,'Plačilo z VISA kartico',NULL,NULL,NULL,'placilo-z-visa-kartico',''),(9,1,'2022-12-06 09:21:56',0,0,'PayPal',NULL,NULL,NULL,'paypal',''),(9,2,'2022-12-06 09:21:56',0,0,'PayPal',NULL,NULL,NULL,'paypal',''),(9,3,'2020-06-18 14:59:12',0,0,'',NULL,NULL,NULL,'9-',''),(10,1,'2022-12-06 09:21:56',0,0,'Plačilo z MONETO',NULL,NULL,NULL,'placilo-z-moneto',''),(10,2,'2022-12-06 09:21:56',0,0,'Plačilo z MONETO',NULL,NULL,NULL,'placilo-z-moneto',''),(10,3,'2020-06-18 14:59:12',0,0,'Plačilo z MONETO',NULL,NULL,NULL,'placilo-z-moneto',''),(11,1,'2022-12-06 09:21:56',0,0,'Plačilo z Moneybookers',NULL,NULL,NULL,'placilo-z-moneybookers',''),(11,2,'2022-12-06 09:21:56',0,0,'Plačilo z Moneybookers',NULL,NULL,NULL,'placilo-z-moneybookers',''),(11,3,'2020-06-18 14:59:12',0,0,'Plačilo z Moneybookers',NULL,NULL,NULL,'placilo-z-moneybookers',''),(12,1,'2022-12-06 09:21:56',0,0,'Plačilo z 3D secure bankart',NULL,NULL,NULL,'placilo-z-3d-secure-bankart',''),(12,2,'2022-12-06 09:21:56',0,0,'Plačilo z 3D secure bankart',NULL,NULL,NULL,'placilo-z-3d-secure-bankart',''),(12,3,'2020-06-18 14:59:12',0,0,'Plačilo z 3D secure bankart',NULL,NULL,NULL,'placilo-z-3d-secure-bankart',''),(13,1,'2022-12-06 09:21:56',0,0,'Plačilo z ACTIVA kartico',NULL,NULL,NULL,'placilo-z-activa-kartico',''),(13,2,'2022-12-06 09:21:56',0,0,'Plačilo z ACTIVA kartico',NULL,NULL,NULL,'placilo-z-activa-kartico',''),(13,3,'2020-06-18 14:59:12',0,0,'Plačilo z ACTIVA kartico',NULL,NULL,NULL,'placilo-z-activa-kartico',''),(14,1,'2022-12-06 09:21:56',0,0,'Plačilo na reverz',NULL,NULL,NULL,'placilo-na-reverz',''),(14,2,'2022-12-06 09:21:56',0,0,'Plačilo na reverz',NULL,NULL,NULL,'placilo-na-reverz',''),(14,3,'2020-06-18 14:59:12',0,0,'Plačilo na reverz',NULL,NULL,NULL,'placilo-na-reverz',''),(15,1,'2022-12-06 09:21:56',0,0,'Plačilo z AMERICAN EXPRESS kartico',NULL,NULL,NULL,'placilo-z-american-express-kartico',''),(15,2,'2022-12-06 09:21:56',0,0,'Plačilo z AMERICAN EXPRESS kartico',NULL,NULL,NULL,'placilo-z-american-express-kartico',''),(15,3,'2020-06-18 14:59:12',0,0,'Plačilo z AMERICAN EXPRESS kartico',NULL,NULL,NULL,'placilo-z-american-express-kartico',''),(16,1,'2022-12-06 09:21:56',0,0,'Plačilo z MASTERCARD kartico',NULL,NULL,NULL,'placilo-z-mastercard-kartico',''),(16,2,'2022-12-06 09:21:56',0,0,'Plačilo z MASTERCARD kartico',NULL,NULL,NULL,'placilo-z-mastercard-kartico',''),(16,3,'2020-06-18 14:59:12',0,0,'Plačilo z MASTERCARD kartico',NULL,NULL,NULL,'placilo-z-mastercard-kartico',''),(17,1,'2022-12-06 09:21:56',0,0,'Plačilo z MAESTRO kartico',NULL,NULL,NULL,'placilo-z-maestro-kartico',''),(17,2,'2022-12-06 09:21:56',0,0,'Plačilo z MAESTRO kartico',NULL,NULL,NULL,'placilo-z-maestro-kartico',''),(17,3,'2020-06-18 14:59:12',0,0,'Plačilo z MAESTRO kartico',NULL,NULL,NULL,'placilo-z-maestro-kartico',''),(18,1,'2022-12-06 09:21:56',0,0,'Plačilo z DINERS kartico',NULL,NULL,NULL,'placilo-z-diners-kartico',''),(18,2,'2022-12-06 09:21:56',0,0,'Plačilo z DINERS kartico',NULL,NULL,NULL,'placilo-z-diners-kartico',''),(18,3,'2020-06-18 14:59:12',0,0,'Plačilo z DINERS kartico',NULL,NULL,NULL,'placilo-z-diners-kartico',''),(19,1,'2022-12-06 09:21:56',0,0,'Plačilo z KARANTA kartico',NULL,NULL,NULL,'placilo-z-karanta-kartico',''),(19,2,'2022-12-06 09:21:56',0,0,'Plačilo z KARANTA kartico',NULL,NULL,NULL,'placilo-z-karanta-kartico',''),(19,3,'2020-06-18 14:59:12',0,0,'Plačilo z KARANTA kartico',NULL,NULL,NULL,'placilo-z-karanta-kartico',''),(20,1,'2022-12-06 09:21:56',0,0,'Kreditna kartica (braintree)',NULL,NULL,NULL,'kreditna-kartica-braintree',''),(20,2,'2022-12-06 09:21:56',0,0,'Credit card',NULL,NULL,NULL,'20-credit-card',''),(20,3,'2020-06-18 14:59:12',0,0,'Credit card payment',NULL,NULL,NULL,'credit-card-payment',''),(21,1,'2022-12-06 09:21:56',0,0,'Plačilo na recepciji',NULL,NULL,NULL,'placilo-na-recepciji',''),(21,2,'2022-12-06 09:21:56',0,0,'Plačilo na recepciji',NULL,NULL,NULL,'placilo-na-recepciji',''),(21,3,'2020-06-18 14:59:13',0,0,'Plačilo na recepciji',NULL,NULL,NULL,'placilo-na-recepciji',''),(22,1,'2022-12-06 09:21:56',0,0,'Credit card (PAYUNITY)',NULL,NULL,NULL,'credit-card-payunity',''),(22,2,'2022-12-06 09:21:56',0,0,'Credit card (PAYUNITY)',NULL,NULL,NULL,'credit-card-payunity',''),(22,3,'2020-06-18 14:59:13',0,0,'Credit card (PAYUNITY)',NULL,NULL,NULL,'credit-card-payunity',''),(23,1,'2022-12-06 09:21:56',0,0,'Brez plačila, brezplačna vstopnica na e-poštni naslov.',NULL,NULL,NULL,'brez-placila-brezplacna-vstopnica-na-e-postni-naslov',''),(23,2,'2022-12-06 09:21:56',0,0,'Brez plačila, brezplačna vstopnica na e-poštni naslov.',NULL,NULL,NULL,'brez-placila-brezplacna-vstopnica-na-e-postni-naslov',''),(23,3,'2020-06-18 14:59:13',0,0,'Brez plačila, brezplačna vstopnica na e-poštni naslov.',NULL,NULL,NULL,'brez-placila-brezplacna-vstopnica-na-e-postni-naslov',''),(24,1,'2020-05-29 09:13:08',0,0,'Slovenija',NULL,NULL,NULL,'slovenija',''),(24,2,'2020-05-29 09:13:08',0,0,'Slovenija',NULL,NULL,NULL,'slovenija',''),(24,3,'2020-05-29 09:13:08',0,0,'Slovenija',NULL,NULL,NULL,'slovenija',''),(25,1,'2020-05-29 09:13:08',0,0,'EU',NULL,NULL,NULL,'eu',''),(25,2,'2020-05-29 09:13:08',0,0,'EU',NULL,NULL,NULL,'eu',''),(25,3,'2020-05-29 09:13:08',0,0,'EU',NULL,NULL,NULL,'eu',''),(26,1,'2020-05-29 09:13:08',0,0,'Ostali svet',NULL,NULL,NULL,'ostali-svet',''),(26,2,'2020-05-29 09:13:08',0,0,'Ostali svet',NULL,NULL,NULL,'ostali-svet',''),(26,3,'2020-05-29 09:13:08',0,0,'Ostali svet',NULL,NULL,NULL,'ostali-svet',''),(27,1,'2020-05-29 09:13:08',0,0,'Ostale države Evrope',NULL,NULL,NULL,'ostale-drzave-evrope',''),(27,2,'2020-05-29 09:13:08',0,0,'Ostale države Evrope',NULL,NULL,NULL,'ostale-drzave-evrope',''),(27,3,'2020-05-29 09:13:08',0,0,'Ostale države Evrope',NULL,NULL,NULL,'ostale-drzave-evrope',''),(28,1,'2022-12-06 09:21:55',0,0,'Kreditna kartica',NULL,NULL,NULL,'28-kreditna-kartica',''),(28,2,'2022-12-06 09:21:55',0,0,'Credit card',NULL,NULL,NULL,'credit-card','');

--
-- Table structure for table `ngn_postal_categories`
--

CREATE TABLE `ngn_postal_categories` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`,`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_categories`
--

INSERT INTO `ngn_postal_categories` VALUES (3,1,-1),(7,1,-1),(8,1,-1),(9,1,-1),(10,1,-1);

--
-- Table structure for table `ngn_postal_category`
--

CREATE TABLE `ngn_postal_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_enable` int(11) DEFAULT NULL,
  `category_createdate` datetime DEFAULT NULL,
  `category_showdate` datetime DEFAULT NULL,
  `category_hidedate` datetime DEFAULT NULL,
  `category_hide` tinyint(1) NOT NULL,
  `category_editdate` datetime DEFAULT NULL,
  `category_position` int(11) DEFAULT NULL,
  `category_type` int(11) NOT NULL,
  `category_parent` int(11) DEFAULT NULL,
  `category_photo` varchar(100) DEFAULT NULL,
  `category_restriction` int(11) NOT NULL,
  `category_photo2` int(11) NOT NULL,
  `category_photo_language1` int(11) NOT NULL,
  `category_photo_language2` int(11) NOT NULL,
  `category_template` int(11) NOT NULL,
  `category_template_news` int(11) NOT NULL,
  `category_source` varchar(200) NOT NULL,
  `category_source_url` varchar(200) NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_enable` (`category_enable`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`),
  KEY `category_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category`
--

INSERT INTO `ngn_postal_category` VALUES (1,1,'2016-07-28 16:08:13',NULL,NULL,0,'2022-10-20 16:12:09',0,0,0,'',1,0,0,0,0,0,'','');

--
-- Table structure for table `ngn_postal_category_file`
--

CREATE TABLE `ngn_postal_category_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_file`
--


--
-- Table structure for table `ngn_postal_category_files`
--

CREATE TABLE `ngn_postal_category_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `category_id` (`category_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`),
  CONSTRAINT `ngn_postal_category_files_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_postal_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_files`
--


--
-- Table structure for table `ngn_postal_category_files_language`
--

CREATE TABLE `ngn_postal_category_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_category_files_languageibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_postal_category_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_files_language`
--


--
-- Table structure for table `ngn_postal_category_groups`
--

CREATE TABLE `ngn_postal_category_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_id_2` (`category_id`,`group_id`),
  KEY `group_id` (`group_id`),
  KEY `category_id` (`category_id`),
  KEY `position` (`position`),
  CONSTRAINT `ngn_postal_category_groups_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_postal_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_postal_category_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `ngn_postal_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_groups`
--

INSERT INTO `ngn_postal_category_groups` VALUES (1,1,3,0,1,0);

--
-- Table structure for table `ngn_postal_category_groups_atribute`
--

CREATE TABLE `ngn_postal_category_groups_atribute` (
  `cgid` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL DEFAULT 0,
  `valueFloat` double NOT NULL DEFAULT 0,
  `valueText` text NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `gaid` (`gaid`),
  KEY `cgid` (`cgid`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_groups_atribute`
--


--
-- Table structure for table `ngn_postal_category_groups_atribute_multi`
--

CREATE TABLE `ngn_postal_category_groups_atribute_multi` (
  `cgid` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_groups_atribute_multi`
--


--
-- Table structure for table `ngn_postal_category_language`
--

CREATE TABLE `ngn_postal_category_language` (
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `photo1` int(11) NOT NULL,
  `photo2` int(11) NOT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  `language_photo2` varchar(100) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`category_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  FULLTEXT KEY `language_html` (`language_html`),
  CONSTRAINT `ngn_postal_category_language_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_postal_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_language`
--

INSERT INTO `ngn_postal_category_language` VALUES (1,1,'2022-10-20 16:12:02',1,1,'Po&scaron;ta','','','','posta',0,0,'','',''),(1,2,'2022-10-20 16:12:09',1,1,'Shipping','','','','shipping',0,0,'','','');

--
-- Table structure for table `ngn_postal_category_links`
--

CREATE TABLE `ngn_postal_category_links` (
  `category_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `category_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`link_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `category_position` (`category_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_links`
--


--
-- Table structure for table `ngn_postal_category_multi`
--

CREATE TABLE `ngn_postal_category_multi` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`,`category_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `ngn_postal_category_multi_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_postal_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_multi`
--


--
-- Table structure for table `ngn_postal_category_pages`
--

CREATE TABLE `ngn_postal_category_pages` (
  `category_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `category_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`link_id`,`language_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `category_position` (`category_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_pages`
--


--
-- Table structure for table `ngn_postal_category_photo`
--

CREATE TABLE `ngn_postal_category_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `category_id` (`category_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`),
  CONSTRAINT `ngn_postal_category_photo_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_postal_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_photo`
--


--
-- Table structure for table `ngn_postal_category_photo_gallery`
--

CREATE TABLE `ngn_postal_category_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_photo_gallery`
--


--
-- Table structure for table `ngn_postal_category_photo_gallery_language`
--

CREATE TABLE `ngn_postal_category_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`category_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_photo_gallery_language`
--


--
-- Table structure for table `ngn_postal_category_photo_language`
--

CREATE TABLE `ngn_postal_category_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_category_photo_language_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `ngn_postal_category_photo` (`photo_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_photo_language`
--


--
-- Table structure for table `ngn_postal_category_roles`
--

CREATE TABLE `ngn_postal_category_roles` (
  `role_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `childs` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`role_id`,`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_category_roles`
--


--
-- Table structure for table `ngn_postal_comments`
--

CREATE TABLE `ngn_postal_comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `user_ip` varchar(60) NOT NULL,
  `date` datetime NOT NULL,
  `votes` int(11) NOT NULL,
  `reported` int(11) NOT NULL,
  `enable` int(11) NOT NULL DEFAULT 1,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`),
  KEY `news_id` (`parent_id`),
  KEY `user_id` (`user_id`),
  KEY `category_id` (`category_id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments`
--


--
-- Table structure for table `ngn_postal_comments_admin`
--

CREATE TABLE `ngn_postal_comments_admin` (
  `comment_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`,`role_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments_admin`
--


--
-- Table structure for table `ngn_postal_comments_files`
--

CREATE TABLE `ngn_postal_comments_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `comment_id` (`comment_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments_files`
--


--
-- Table structure for table `ngn_postal_comments_files_language`
--

CREATE TABLE `ngn_postal_comments_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_comments_files_language_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_postal_comments_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments_files_language`
--


--
-- Table structure for table `ngn_postal_comments_language`
--

CREATE TABLE `ngn_postal_comments_language` (
  `comment_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`comment_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_comments_language_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_postal_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments_language`
--


--
-- Table structure for table `ngn_postal_comments_votes`
--

CREATE TABLE `ngn_postal_comments_votes` (
  `comment_id` int(11) NOT NULL,
  `vote_date` datetime DEFAULT NULL,
  `vote_ip` varchar(50) NOT NULL,
  `vote_value` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`,`vote_ip`),
  CONSTRAINT `ngn_postal_comments_votes_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_postal_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_comments_votes`
--


--
-- Table structure for table `ngn_postal_custom_values`
--

CREATE TABLE `ngn_postal_custom_values` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueAutomatic` int(11) NOT NULL DEFAULT 0,
  `valueInt` int(11) NOT NULL,
  `valueFloat` double NOT NULL,
  `valueText` text NOT NULL,
  PRIMARY KEY (`news_id`,`category_id`,`gaid`,`language_id`),
  KEY `category_id` (`category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_custom_values`
--

INSERT INTO `ngn_postal_custom_values` VALUES (3,1,1,1,0,943916400,0,''),(3,1,3,1,0,943916400,0,''),(3,1,9,1,0,0,0,''),(3,1,10,1,0,1,0,''),(3,1,12,1,0,0,0,'25'),(7,1,1,1,0,943916400,0,''),(7,1,3,1,0,943916400,0,''),(7,1,9,1,0,0,0,''),(7,1,10,1,0,1,0,''),(7,1,12,1,0,0,0,'24'),(8,1,1,1,0,943916400,0,''),(8,1,3,1,0,943916400,0,''),(8,1,9,1,0,0,0,''),(8,1,10,1,0,1,0,''),(8,1,12,1,0,0,0,'27'),(9,1,1,1,0,943916400,0,''),(9,1,3,1,0,943916400,0,''),(9,1,9,1,0,0,0,''),(9,1,10,1,0,1,0,''),(9,1,12,1,0,0,0,'26'),(10,1,1,1,0,943916400,0,''),(10,1,3,1,0,943916400,0,''),(10,1,9,1,0,0,0,''),(10,1,10,1,0,0,0,'');

--
-- Table structure for table `ngn_postal_custom_values_multi`
--

CREATE TABLE `ngn_postal_custom_values_multi` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`category_id`,`gaid`,`language_id`,`valueInt`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_custom_values_multi`
--

INSERT INTO `ngn_postal_custom_values_multi` VALUES (3,1,12,1,25,0),(7,1,12,1,24,0),(8,1,12,1,27,0),(9,1,12,1,26,0);

--
-- Table structure for table `ngn_postal_file`
--

CREATE TABLE `ngn_postal_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_file`
--


--
-- Table structure for table `ngn_postal_files`
--

CREATE TABLE `ngn_postal_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `news_id` (`news_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_files`
--


--
-- Table structure for table `ngn_postal_files_groups`
--

CREATE TABLE `ngn_postal_files_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_photo` varchar(50) NOT NULL,
  `group_enable` int(11) NOT NULL DEFAULT 0,
  `group_order` int(11) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_files_groups`
--


--
-- Table structure for table `ngn_postal_files_groups_language`
--

CREATE TABLE `ngn_postal_files_groups_language` (
  `group_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`group_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_files_groups_language`
--


--
-- Table structure for table `ngn_postal_files_language`
--

CREATE TABLE `ngn_postal_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_files_language_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_postal_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_files_language`
--


--
-- Table structure for table `ngn_postal_gallery`
--

CREATE TABLE `ngn_postal_gallery` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL,
  `gallery_template` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_gallery`
--


--
-- Table structure for table `ngn_postal_gallery_photo`
--

CREATE TABLE `ngn_postal_gallery_photo` (
  `gallery_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`,`photo_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_gallery_photo`
--


--
-- Table structure for table `ngn_postal_groups`
--

CREATE TABLE `ngn_postal_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_var` varchar(50) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_groups`
--

INSERT INTO `ngn_postal_groups` VALUES (1,'_2'),(2,'payment'),(3,'personal'),(4,'');

--
-- Table structure for table `ngn_postal_groups_atribute`
--

CREATE TABLE `ngn_postal_groups_atribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `atribute_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `atribute_id` (`atribute_id`),
  CONSTRAINT `ngn_postal_groups_atribute_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `ngn_postal_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_groups_atribute`
--

INSERT INTO `ngn_postal_groups_atribute` VALUES (1,1,1,0),(2,1,2,1),(3,1,3,2),(4,1,4,3),(5,1,5,4),(6,2,6,0),(7,2,4,1),(8,2,3,2),(9,3,7,0),(10,3,8,1),(11,2,10,3),(12,3,11,2),(13,4,1,0),(14,4,2,1),(15,4,12,2),(16,4,4,3),(17,4,5,4);

--
-- Table structure for table `ngn_postal_groups_language`
--

CREATE TABLE `ngn_postal_groups_language` (
  `group_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_groups_language`
--

INSERT INTO `ngn_postal_groups_language` VALUES (1,1,'2020-05-18 14:19:34',0,1,'Lastnosti','',NULL,NULL,NULL,''),(1,2,'2020-05-18 14:19:37',0,1,'Lastnosti','',NULL,NULL,NULL,''),(1,3,'2020-05-18 14:19:39',0,1,'Lastnosti','',NULL,NULL,NULL,''),(2,1,'2020-05-18 14:19:42',0,1,'Tip plačila','',NULL,NULL,NULL,''),(2,2,'2020-05-18 14:19:44',0,1,'Tip plačila','',NULL,NULL,NULL,''),(2,3,'2020-05-18 14:19:47',0,1,'Tip plačila','',NULL,NULL,NULL,''),(3,1,'2020-05-18 14:20:48',0,1,'Nastavitve poštne storitve','',NULL,NULL,NULL,''),(3,2,'2020-05-18 14:19:52',0,1,'Nastavitve poštne storitve','','','','',''),(3,3,'2020-05-18 14:20:50',0,1,'Nastavitve poštne storitve','',NULL,NULL,NULL,''),(4,1,'2020-05-18 14:20:29',0,1,'Lastnosti (odkupnine)','',NULL,NULL,NULL,''),(4,2,'2020-05-18 14:20:33',0,1,'Lastnosti (odkupnine)','','','','',''),(4,3,'2020-05-18 14:20:36',0,1,'Lastnosti (odkupnine)','',NULL,NULL,NULL,'');

--
-- Table structure for table `ngn_postal_item`
--

CREATE TABLE `ngn_postal_item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_category` int(11) NOT NULL,
  `news_id` int(11) NOT NULL DEFAULT 0,
  `item_order` int(11) NOT NULL,
  `item_createdate` datetime DEFAULT NULL,
  `item_showdate` datetime DEFAULT NULL,
  `item_editdate` datetime NOT NULL,
  `item_hidedate` datetime NOT NULL,
  `item_hide` tinyint(1) NOT NULL,
  `item_enable` int(11) NOT NULL DEFAULT 0,
  `item_photo1` varchar(100) NOT NULL,
  `item_photo2` varchar(100) NOT NULL,
  `item_viewed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`item_id`),
  KEY `item_category` (`item_category`),
  KEY `news_id` (`news_id`),
  KEY `item_enable` (`item_enable`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item`
--

INSERT INTO `ngn_postal_item` VALUES (3,1,9,100,'1970-01-01 01:01:00','1970-01-01 01:01:00','2023-04-05 15:37:59','2023-04-05 15:37:00',0,1,'','',0),(5,3,3,120,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-10-24 14:30:21','2022-10-24 14:30:00',0,1,'','',0),(6,2,3,130,'1970-01-01 01:32:50','1970-01-01 01:32:50','2020-08-17 16:49:33','2020-08-17 16:49:00',0,0,'','',0),(8,4,3,150,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-12-06 09:22:36','2022-12-06 09:22:00',0,1,'','',0),(15,2,7,220,'1970-01-01 01:33:40','1970-01-01 01:33:40','2020-08-17 16:49:33','2020-08-17 16:49:00',0,0,'','',0),(16,3,7,230,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-10-24 14:07:08','2022-10-24 14:07:00',0,1,'','',0),(17,3,8,240,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-10-13 09:32:06','2022-10-13 09:32:00',0,1,'','',0),(18,3,9,250,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-10-13 12:14:41','2022-10-13 12:14:00',0,1,'','',0),(19,4,7,260,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-10-24 14:06:59','2022-10-24 14:06:00',0,1,'','',0),(20,4,8,270,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-12-06 09:23:11','2022-12-06 09:23:00',0,1,'','',0),(21,4,9,280,'1970-01-01 01:01:00','1970-01-01 01:01:00','2022-12-06 09:22:21','2022-12-06 09:22:00',0,1,'','',0);

--
-- Table structure for table `ngn_postal_item_category`
--

CREATE TABLE `ngn_postal_item_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_enable` int(11) DEFAULT NULL,
  `category_createdate` datetime DEFAULT NULL,
  `category_showdate` datetime DEFAULT NULL,
  `category_hidedate` datetime DEFAULT NULL,
  `category_hide` tinyint(1) NOT NULL,
  `category_editdate` datetime DEFAULT NULL,
  `category_position` int(11) DEFAULT NULL,
  `category_parent` int(11) DEFAULT NULL,
  `category_photo` varchar(100) DEFAULT NULL,
  `category_template` int(11) NOT NULL,
  `category_template_news` int(11) NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_enable` (`category_enable`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`),
  KEY `category_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_category`
--

INSERT INTO `ngn_postal_item_category` VALUES (1,1,'2016-07-28 16:08:57',NULL,NULL,0,'2016-07-29 15:30:10',0,0,'',0,0),(2,1,'2016-07-28 16:09:08',NULL,NULL,0,'2017-01-27 15:57:06',0,0,'',0,0),(3,1,'2016-07-29 15:30:01',NULL,NULL,0,NULL,0,0,'',0,0),(4,1,'2017-01-27 15:56:56',NULL,NULL,0,NULL,0,0,'',0,0);

--
-- Table structure for table `ngn_postal_item_category_language`
--

CREATE TABLE `ngn_postal_item_category_language` (
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  `language_photo2` varchar(100) NOT NULL,
  PRIMARY KEY (`category_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_category_language`
--

INSERT INTO `ngn_postal_item_category_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Poštnina na težo','','','','postnina-na-tezo','',''),(2,1,'0000-00-00 00:00:00',0,0,'Odkupnine','','','','odkupnine','',''),(3,1,'0000-00-00 00:00:00',0,0,'Poštnina na ceno','','','','postnina-na-ceno','',''),(4,1,'0000-00-00 00:00:00',0,0,'Tipi plačila','','','','tipi-placila','','');

--
-- Table structure for table `ngn_postal_item_custom_values`
--

CREATE TABLE `ngn_postal_item_custom_values` (
  `item_id` int(11) NOT NULL,
  `item_category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueAutomatic` int(11) NOT NULL DEFAULT 0,
  `valueInt` int(11) NOT NULL,
  `valueFloat` double NOT NULL,
  `valueText` text NOT NULL,
  PRIMARY KEY (`item_id`,`item_category_id`,`gaid`,`language_id`),
  KEY `item_category_id` (`item_category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_custom_values`
--

INSERT INTO `ngn_postal_item_custom_values` VALUES (3,1,1,1,0,0,0,''),(3,1,2,1,0,0,4600,''),(3,1,3,1,0,0,0,'2.60'),(3,1,4,1,0,0,0,'+ 3,17&euro;'),(3,1,5,1,0,1,0,''),(4,1,1,1,0,0,4600,''),(4,1,2,1,0,0,14600,''),(4,1,3,1,0,0,0,'2.86'),(4,1,4,1,0,0,0,'+ 3,49&euro;'),(4,1,5,1,0,1,0,''),(5,1,1,1,0,0,14600,''),(5,1,2,1,0,0,999999999,''),(5,1,3,1,0,0,0,'5.78'),(5,1,4,1,0,0,0,'+ 7,05&euro;'),(5,1,5,1,0,1,0,''),(6,2,1,1,0,0,0,''),(6,2,2,1,0,0,50,''),(6,2,3,1,0,0,0,'+0.65'),(6,2,4,1,0,0,0,'+ 0,65&euro;'),(6,2,5,1,0,3,0,''),(7,2,1,1,0,0,50,''),(7,2,2,1,0,0,2000,''),(7,2,3,1,0,0,0,'+0.65'),(7,2,4,1,0,0,0,'+ 0,65&euro;'),(7,2,5,1,0,3,0,''),(8,2,1,1,0,0,2000,''),(8,2,2,1,0,0,999999999,''),(8,2,3,1,0,0,0,'*1.014'),(8,2,4,1,0,0,0,'* 1,4%'),(8,2,5,1,0,3,0,''),(9,1,1,1,0,0,0,''),(9,1,2,1,0,0,250,''),(9,1,3,1,0,0,0,'1.639344262295082'),(9,1,4,1,0,0,0,'+ 2,00 &euro;'),(9,1,5,1,0,1,0,''),(11,3,1,1,0,0,0,''),(11,3,2,1,0,0,50,''),(11,3,3,1,0,0,0,'2.38'),(11,3,4,1,0,0,0,'+ 2.90 &euro;'),(11,3,5,1,0,1,0,''),(12,3,1,1,0,0,50,''),(12,3,2,1,0,0,99999999999,''),(12,3,3,1,0,0,0,'0'),(12,3,4,1,0,0,0,'0 &euro;'),(12,3,5,1,0,1,0,''),(14,3,1,1,0,0,0,''),(14,3,2,1,0,0,99.99,''),(14,3,3,1,0,0,9.01639344,''),(14,3,4,1,0,0,0,'+ 11,00 &euro;'),(14,3,4,2,0,0,0,'+ 11,00 &euro;'),(14,3,5,1,0,1,0,''),(15,2,1,1,0,0,0,''),(15,2,2,1,0,0,999999999999,''),(15,2,3,1,0,0,1,''),(15,2,4,1,0,0,0,'+ 1,22 &euro;'),(15,2,5,1,0,1,0,''),(15,2,13,1,0,0,0,''),(15,2,14,1,0,0,199.99,''),(15,2,15,1,0,0,0,'9.8360656'),(15,2,16,1,0,0,0,'+ 12 &euro;'),(15,2,16,2,0,0,0,''),(15,2,17,1,0,1,0,''),(18,3,1,1,0,0,0,''),(18,3,2,1,0,0,9999999,''),(18,3,3,1,0,0,0,''),(18,3,4,1,0,0,0,'0 &euro;'),(18,3,5,1,0,1,0,''),(19,4,6,1,0,4,0,''),(19,4,7,1,0,0,0,'0 &euro;'),(19,4,8,1,0,0,0,''),(19,4,11,1,0,0,0,''),(21,4,6,1,0,4,0,''),(21,4,7,1,0,0,0,'0 &euro;'),(21,4,8,1,0,0,0,''),(21,4,11,1,0,0,0,''),(22,4,6,1,0,5,0,''),(22,4,7,1,0,0,0,'0 &euro;'),(22,4,8,1,0,0,0,''),(22,4,11,1,0,0,0,''),(23,4,6,1,0,4,0,''),(23,4,7,1,0,0,0,''),(23,4,7,2,0,0,0,''),(23,4,8,1,0,0,0,''),(23,4,11,1,0,0,0,''),(23,4,11,2,0,0,0,''),(24,3,1,1,0,0,0,''),(24,3,2,1,0,0,999999999,''),(24,3,3,1,0,0,0,'0 &euro;'),(24,3,4,1,0,0,0,'0'),(24,3,5,1,0,3,0,''),(33,4,6,1,0,9,0,''),(33,4,7,1,0,0,0,''),(33,4,8,1,0,0,0,''),(33,4,11,1,0,0,0,''),(34,4,6,1,0,9,0,''),(34,4,7,1,0,0,0,''),(34,4,7,2,0,0,0,''),(34,4,8,1,0,0,0,''),(34,4,11,1,0,0,0,''),(34,4,11,2,0,0,0,''),(35,3,1,1,0,0,0,''),(35,3,2,1,0,0,999999999,''),(35,3,3,1,0,0,0,'0'),(35,3,4,1,0,0,0,'0'),(35,3,5,1,0,3,0,''),(36,4,6,1,0,9,0,''),(36,4,7,1,0,0,0,''),(36,4,8,1,0,0,0,'0'),(36,4,11,1,0,0,0,''),(37,4,6,1,0,4,0,''),(37,4,7,1,0,0,0,''),(37,4,8,1,0,0,0,'0'),(37,4,11,1,0,0,0,''),(38,4,6,1,0,22,0,''),(38,4,7,1,0,0,0,''),(38,4,8,1,0,0,0,''),(38,4,11,1,0,0,0,''),(39,4,6,1,0,22,0,''),(39,4,7,1,0,0,0,''),(39,4,8,1,0,0,0,'0'),(39,4,11,1,0,0,0,''),(40,4,6,1,0,28,0,''),(40,4,7,1,0,0,0,''),(40,4,7,2,0,0,0,''),(40,4,8,1,0,0,0,''),(40,4,11,1,0,0,0,''),(40,4,11,2,0,0,0,''),(45,4,6,1,0,23,0,''),(45,4,7,1,0,0,0,'0'),(45,4,8,1,0,0,0,'0'),(45,4,11,1,0,0,0,''),(47,2,13,1,0,0,0,''),(47,2,14,1,0,0,49.99,''),(47,2,15,1,0,0,0,'3,27868852'),(47,2,16,1,0,0,0,'+ 4 &euro;'),(47,2,16,2,0,0,0,''),(47,2,17,1,0,1,0,''),(48,2,13,1,0,0,50,''),(48,2,14,1,0,0,9000000,''),(48,2,15,1,0,0,0,'0'),(48,2,16,1,0,0,0,'0'),(48,2,16,2,0,0,0,''),(48,2,17,1,0,1,0,''),(49,2,13,1,0,0,200,''),(49,2,14,1,0,0,90000000,''),(49,2,15,1,0,0,0,'0'),(49,2,16,1,0,0,0,'0'),(49,2,16,2,0,0,0,''),(49,2,17,1,0,1,0,''),(50,3,1,1,0,0,100,''),(50,3,2,1,0,0,99999999999,''),(50,3,3,1,0,0,0,''),(50,3,4,1,0,0,0,'+ 0 &euro;'),(50,3,4,2,0,0,0,'+ 0 &euro;'),(50,3,5,1,0,1,0,''),(51,3,1,1,0,0,0,''),(51,3,2,1,0,0,49.999,''),(51,3,3,1,0,0,2.86885245,''),(51,3,4,1,0,0,0,'+ 3,50 &euro;'),(51,3,4,2,0,0,0,''),(51,3,4,3,0,0,0,''),(51,3,5,1,0,1,0,''),(52,3,1,1,0,0,50,''),(52,3,2,1,0,0,900000,''),(52,3,3,1,0,0,0,''),(52,3,4,1,0,0,0,'+ 0 &euro;'),(52,3,4,2,0,0,0,''),(52,3,4,3,0,0,0,''),(52,3,5,1,0,1,0,''),(53,3,1,1,0,0,0,''),(53,3,2,1,0,0,99.99,''),(53,3,3,1,0,0,9.01639344,''),(53,3,4,1,0,0,0,'+ 11,00 &euro;'),(53,3,4,2,0,0,0,''),(53,3,5,1,0,1,0,''),(54,3,1,1,0,0,100,''),(54,3,2,1,0,0,900000,''),(54,3,3,1,0,0,0,''),(54,3,4,1,0,0,0,'+ 0 &euro;'),(54,3,4,2,0,0,0,''),(54,3,5,1,0,1,0,''),(55,3,1,1,0,0,0,''),(55,3,2,1,0,0,900000,''),(55,3,3,1,0,0,24.59016393,''),(55,3,4,1,0,0,0,'+ 30,00 &euro;'),(55,3,4,2,0,0,0,''),(55,3,5,1,0,1,0,''),(56,3,1,1,0,0,500,''),(56,3,2,1,0,0,900000,''),(56,3,3,1,0,0,0,''),(56,3,4,1,0,0,0,'+ 0 &euro;'),(56,3,4,2,0,0,0,''),(56,3,5,1,0,1,0,''),(57,4,6,1,0,4,0,''),(57,4,7,1,0,0,0,''),(57,4,7,2,0,0,0,''),(57,4,8,1,0,0,0,''),(57,4,11,1,0,0,0,''),(57,4,11,2,0,0,0,''),(58,4,6,1,0,28,0,''),(58,4,7,1,0,0,0,''),(58,4,7,2,0,0,0,''),(58,4,8,1,0,0,0,''),(58,4,11,1,0,0,0,''),(58,4,11,2,0,0,0,''),(59,4,6,1,0,9,0,''),(59,4,7,1,0,0,0,''),(59,4,7,2,0,0,0,''),(59,4,8,1,0,0,0,''),(59,4,11,1,0,0,0,''),(59,4,11,2,0,0,0,''),(60,4,6,1,0,9,0,''),(60,4,7,1,0,0,0,''),(60,4,7,2,0,0,0,''),(60,4,8,1,0,0,0,''),(60,4,11,1,0,0,0,''),(60,4,11,2,0,0,0,''),(61,4,6,1,0,28,0,''),(61,4,7,1,0,0,0,''),(61,4,7,2,0,0,0,''),(61,4,8,1,0,0,0,''),(61,4,11,1,0,0,0,''),(61,4,11,2,0,0,0,''),(62,4,6,1,0,4,0,''),(62,4,7,1,0,0,0,''),(62,4,7,2,0,0,0,''),(62,4,8,1,0,0,0,''),(62,4,11,1,0,0,0,''),(62,4,11,2,0,0,0,''),(63,4,6,1,0,9,0,''),(63,4,7,1,0,0,0,''),(63,4,7,2,0,0,0,''),(63,4,8,1,0,0,0,''),(63,4,11,1,0,0,0,''),(63,4,11,2,0,0,0,''),(64,4,6,1,0,28,0,''),(64,4,7,1,0,0,0,''),(64,4,7,2,0,0,0,''),(64,4,8,1,0,0,0,''),(64,4,11,1,0,0,0,''),(64,4,11,2,0,0,0,''),(65,4,6,1,0,4,0,''),(65,4,7,1,0,0,0,''),(65,4,7,2,0,0,0,''),(65,4,8,1,0,0,0,''),(65,4,11,1,0,0,0,''),(65,4,11,2,0,0,0,''),(66,1,1,1,0,0,0,''),(66,1,2,1,0,0,1000,''),(66,1,3,1,0,0,12.29508196721311,''),(66,1,4,1,0,0,0,''),(66,1,4,2,0,0,0,''),(66,1,5,1,0,1,0,''),(67,1,1,1,0,0,1000,''),(67,1,2,1,0,0,2000,''),(67,1,3,1,0,0,24.59016393442623,''),(67,1,4,1,0,0,0,''),(67,1,4,2,0,0,0,''),(67,1,5,1,0,1,0,''),(72,1,1,1,0,0,0,''),(72,1,2,1,0,0,0,''),(72,1,3,1,0,0,0,''),(72,1,4,1,0,0,0,''),(72,1,5,1,0,0,0,''),(73,1,1,1,0,0,0,''),(73,1,2,1,0,0,0,''),(73,1,3,1,0,0,0,''),(73,1,4,1,0,0,0,''),(73,1,5,1,0,0,0,''),(77,1,1,1,0,0,2001,''),(77,1,2,1,0,0,3000,''),(77,1,3,1,0,0,0,''),(77,1,4,2,0,0,0,'1'),(78,1,1,1,0,0,2001,''),(78,1,2,1,0,0,3000,''),(78,1,3,1,0,0,0,''),(78,1,4,2,0,0,0,'1'),(79,1,1,1,0,0,2001,''),(79,1,2,1,0,0,3000,''),(79,1,3,1,0,0,0,''),(79,1,4,2,0,0,0,'1'),(80,1,1,1,0,0,2001,''),(80,1,2,1,0,0,3000,''),(80,1,3,1,0,0,0,''),(80,1,4,1,0,0,0,'1'),(81,1,1,1,0,0,2001,''),(81,1,2,1,0,0,3000,''),(81,1,3,1,0,0,0,''),(81,1,4,1,0,0,0,'1'),(82,1,1,1,0,0,2001,''),(82,1,2,1,0,0,3000,''),(82,1,3,1,0,0,0,''),(82,1,4,1,0,0,0,'1'),(83,1,1,1,0,0,2001,''),(83,1,2,1,0,0,3000,''),(83,1,3,1,0,0,0,''),(83,1,4,1,0,0,0,'1'),(84,1,1,1,0,0,2001,''),(84,1,2,1,0,0,3000,''),(84,1,3,1,0,0,0,''),(84,1,4,1,0,0,0,'1'),(85,1,1,1,0,0,2001,''),(85,1,2,1,0,0,3000,''),(85,1,3,1,0,0,0,''),(85,1,4,1,0,0,0,''),(86,1,1,1,0,0,2001,''),(86,1,2,1,0,0,3000,''),(86,1,3,1,0,0,0,''),(86,1,4,1,0,0,0,''),(87,1,1,1,0,0,2001,''),(87,1,2,1,0,0,3000,''),(87,1,3,1,0,0,0,''),(87,1,4,1,0,0,0,''),(88,1,1,1,0,0,2001,''),(88,1,2,1,0,0,3000,''),(88,1,3,1,0,0,0,''),(88,1,4,1,0,0,0,''),(89,1,1,1,0,0,2001,''),(89,1,2,1,0,0,3000,''),(89,1,3,1,0,0,0,''),(89,1,4,1,0,0,0,''),(90,1,1,1,0,0,2000,''),(90,1,2,1,0,0,3000,''),(90,1,3,1,0,0,36.885245901639,''),(90,1,4,1,0,0,0,''),(90,1,4,2,0,0,0,''),(90,1,5,1,0,1,0,''),(91,1,1,1,0,0,3000,''),(91,1,2,1,0,0,4000,''),(91,1,3,1,0,0,49.180327868852,''),(91,1,4,1,0,0,0,''),(91,1,4,2,0,0,0,''),(91,1,5,1,0,1,0,''),(92,1,1,1,0,0,4000,''),(92,1,2,1,0,0,5000,''),(92,1,3,1,0,0,61.475409836066,''),(92,1,4,1,0,0,0,''),(92,1,4,2,0,0,0,''),(92,1,5,1,0,1,0,''),(93,1,1,1,0,0,5000,''),(93,1,2,1,0,0,6000,''),(93,1,3,1,0,0,73.770491803279,''),(93,1,4,1,0,0,0,''),(93,1,4,2,0,0,0,''),(93,1,5,1,0,1,0,''),(94,1,1,1,0,0,6000,''),(94,1,2,1,0,0,7000,''),(94,1,3,1,0,0,86.065573770492,''),(94,1,4,1,0,0,0,''),(94,1,4,2,0,0,0,''),(94,1,5,1,0,1,0,''),(95,1,1,1,0,0,7000,''),(95,1,2,1,0,0,8000,''),(95,1,3,1,0,0,98.360655737705,''),(95,1,4,1,0,0,0,''),(95,1,4,2,0,0,0,''),(95,1,5,1,0,1,0,''),(96,1,1,1,0,0,8000,''),(96,1,2,1,0,0,9000,''),(96,1,3,1,0,0,110.65573770492,''),(96,1,4,1,0,0,0,''),(96,1,4,2,0,0,0,''),(96,1,5,1,0,1,0,''),(97,1,1,1,0,0,9000,''),(97,1,2,1,0,0,10000,''),(97,1,3,1,0,0,122.95081967213,''),(97,1,4,1,0,0,0,''),(97,1,4,2,0,0,0,''),(97,1,5,1,0,1,0,''),(98,1,1,1,0,0,10000,''),(98,1,2,1,0,0,11000,''),(98,1,3,1,0,0,135.24590163934,''),(98,1,4,1,0,0,0,''),(98,1,4,2,0,0,0,''),(98,1,5,1,0,1,0,''),(99,1,1,1,0,0,11000,''),(99,1,2,1,0,0,12000,''),(99,1,3,1,0,0,147.54098360656,''),(99,1,4,1,0,0,0,''),(99,1,4,2,0,0,0,''),(99,1,5,1,0,1,0,''),(100,1,1,1,0,0,12000,''),(100,1,2,1,0,0,13000,''),(100,1,3,1,0,0,159.83606557377,''),(100,1,4,1,0,0,0,''),(100,1,4,2,0,0,0,''),(100,1,5,1,0,1,0,''),(101,1,1,1,0,0,13000,''),(101,1,2,1,0,0,14000,''),(101,1,3,1,0,0,172.13114754098,''),(101,1,4,1,0,0,0,''),(101,1,4,2,0,0,0,''),(101,1,5,1,0,1,0,''),(102,1,1,1,0,0,14000,''),(102,1,2,1,0,0,15000,''),(102,1,3,1,0,0,184.4262295082,''),(102,1,4,1,0,0,0,''),(102,1,4,2,0,0,0,''),(102,1,5,1,0,1,0,''),(103,1,1,1,0,0,15000,''),(103,1,2,1,0,0,16000,''),(103,1,3,1,0,0,196.72131147541,''),(103,1,4,1,0,0,0,''),(103,1,4,2,0,0,0,''),(103,1,5,1,0,1,0,''),(104,1,1,1,0,0,16000,''),(104,1,2,1,0,0,17000,''),(104,1,3,1,0,0,209.01639344262,''),(104,1,4,1,0,0,0,''),(104,1,4,2,0,0,0,''),(104,1,5,1,0,1,0,''),(105,1,1,1,0,0,17000,''),(105,1,2,1,0,0,18000,''),(105,1,3,1,0,0,221.31147540984,''),(105,1,4,1,0,0,0,''),(105,1,4,2,0,0,0,''),(105,1,5,1,0,1,0,''),(106,1,1,1,0,0,18000,''),(106,1,2,1,0,0,19000,''),(106,1,3,1,0,0,233.60655737705,''),(106,1,4,1,0,0,0,''),(106,1,4,2,0,0,0,''),(106,1,5,1,0,1,0,''),(107,1,1,1,0,0,19000,''),(107,1,2,1,0,0,20000,''),(107,1,3,1,0,0,245.90163934426,''),(107,1,4,1,0,0,0,''),(107,1,4,2,0,0,0,''),(107,1,5,1,0,1,0,''),(108,1,1,1,0,0,20000,''),(108,1,2,1,0,0,21000,''),(108,1,3,1,0,0,258.19672131148,''),(108,1,4,1,0,0,0,''),(108,1,4,2,0,0,0,''),(108,1,5,1,0,1,0,''),(109,1,1,1,0,0,21000,''),(109,1,2,1,0,0,22000,''),(109,1,3,1,0,0,270.49180327869,''),(109,1,4,1,0,0,0,''),(109,1,4,2,0,0,0,''),(109,1,5,1,0,1,0,''),(110,1,1,1,0,0,22000,''),(110,1,2,1,0,0,23000,''),(110,1,3,1,0,0,282.7868852459,''),(110,1,4,1,0,0,0,''),(110,1,4,2,0,0,0,''),(110,1,5,1,0,1,0,''),(111,1,1,1,0,0,23000,''),(111,1,2,1,0,0,24000,''),(111,1,3,1,0,0,295.08196721311,''),(111,1,4,1,0,0,0,''),(111,1,4,2,0,0,0,''),(111,1,5,1,0,1,0,''),(112,1,1,1,0,0,24000,''),(112,1,2,1,0,0,25000,''),(112,1,3,1,0,0,307.37704918033,''),(112,1,4,1,0,0,0,''),(112,1,4,2,0,0,0,''),(112,1,5,1,0,1,0,''),(113,1,1,1,0,0,25000,''),(113,1,2,1,0,0,26000,''),(113,1,3,1,0,0,319.67213114754,''),(113,1,4,1,0,0,0,''),(113,1,4,2,0,0,0,''),(113,1,5,1,0,1,0,''),(114,1,1,1,0,0,26000,''),(114,1,2,1,0,0,27000,''),(114,1,3,1,0,0,331.96721311475,''),(114,1,4,1,0,0,0,''),(114,1,4,2,0,0,0,''),(114,1,5,1,0,1,0,''),(115,1,1,1,0,0,27000,''),(115,1,2,1,0,0,28000,''),(115,1,3,1,0,0,344.26229508197,''),(115,1,4,1,0,0,0,''),(115,1,4,2,0,0,0,''),(115,1,5,1,0,1,0,''),(116,1,1,1,0,0,28000,''),(116,1,2,1,0,0,29000,''),(116,1,3,1,0,0,356.55737704918,''),(116,1,4,1,0,0,0,''),(116,1,4,2,0,0,0,''),(116,1,5,1,0,1,0,''),(117,1,1,1,0,0,29000,''),(117,1,2,1,0,0,30000,''),(117,1,3,1,0,0,368.85245901639,''),(117,1,4,1,0,0,0,''),(117,1,4,2,0,0,0,''),(117,1,5,1,0,1,0,''),(118,1,1,1,0,0,30000,''),(118,1,2,1,0,0,31000,''),(118,1,3,1,0,0,381.14754098361,''),(118,1,4,1,0,0,0,''),(118,1,4,2,0,0,0,''),(118,1,5,1,0,1,0,''),(119,1,1,1,0,0,31000,''),(119,1,2,1,0,0,32000,''),(119,1,3,1,0,0,393.44262295082,''),(119,1,4,1,0,0,0,''),(119,1,4,2,0,0,0,''),(119,1,5,1,0,1,0,''),(120,1,1,1,0,0,32000,''),(120,1,2,1,0,0,33000,''),(120,1,3,1,0,0,405.73770491803,''),(120,1,4,1,0,0,0,''),(120,1,4,2,0,0,0,''),(120,1,5,1,0,1,0,''),(121,1,1,1,0,0,33000,''),(121,1,2,1,0,0,34000,''),(121,1,3,1,0,0,418.03278688525,''),(121,1,4,1,0,0,0,''),(121,1,4,2,0,0,0,''),(121,1,5,1,0,1,0,''),(122,1,1,1,0,0,34000,''),(122,1,2,1,0,0,35000,''),(122,1,3,1,0,0,430.32786885246,''),(122,1,4,1,0,0,0,''),(122,1,4,2,0,0,0,''),(122,1,5,1,0,1,0,''),(123,1,1,1,0,0,35000,''),(123,1,2,1,0,0,36000,''),(123,1,3,1,0,0,442.62295081967,''),(123,1,4,1,0,0,0,''),(123,1,4,2,0,0,0,''),(123,1,5,1,0,1,0,''),(124,1,1,1,0,0,36000,''),(124,1,2,1,0,0,37000,''),(124,1,3,1,0,0,454.91803278689,''),(124,1,4,1,0,0,0,''),(124,1,4,2,0,0,0,''),(124,1,5,1,0,1,0,''),(125,1,1,1,0,0,37000,''),(125,1,2,1,0,0,38000,''),(125,1,3,1,0,0,467.2131147541,''),(125,1,4,1,0,0,0,''),(125,1,4,2,0,0,0,''),(125,1,5,1,0,1,0,''),(126,1,1,1,0,0,38000,''),(126,1,2,1,0,0,39000,''),(126,1,3,1,0,0,479.50819672131,''),(126,1,4,1,0,0,0,''),(126,1,4,2,0,0,0,''),(126,1,5,1,0,1,0,''),(127,1,1,1,0,0,39000,''),(127,1,2,1,0,0,40000,''),(127,1,3,1,0,0,491.80327868852,''),(127,1,4,1,0,0,0,''),(127,1,4,2,0,0,0,''),(127,1,5,1,0,1,0,''),(128,1,1,1,0,0,40000,''),(128,1,2,1,0,0,41000,''),(128,1,3,1,0,0,504.09836065574,''),(128,1,4,1,0,0,0,''),(128,1,4,2,0,0,0,''),(128,1,5,1,0,1,0,''),(129,1,1,1,0,0,41000,''),(129,1,2,1,0,0,42000,''),(129,1,3,1,0,0,516.39344262295,''),(129,1,4,1,0,0,0,''),(129,1,4,2,0,0,0,''),(129,1,5,1,0,1,0,''),(130,1,1,1,0,0,42000,''),(130,1,2,1,0,0,43000,''),(130,1,3,1,0,0,528.68852459016,''),(130,1,4,1,0,0,0,''),(130,1,4,2,0,0,0,''),(130,1,5,1,0,1,0,''),(131,1,1,1,0,0,43000,''),(131,1,2,1,0,0,44000,''),(131,1,3,1,0,0,540.98360655738,''),(131,1,4,1,0,0,0,''),(131,1,4,2,0,0,0,''),(131,1,5,1,0,1,0,''),(132,1,1,1,0,0,44000,''),(132,1,2,1,0,0,45000,''),(132,1,3,1,0,0,553.27868852459,''),(132,1,4,1,0,0,0,''),(132,1,4,2,0,0,0,''),(132,1,5,1,0,1,0,''),(133,1,1,1,0,0,45000,''),(133,1,2,1,0,0,46000,''),(133,1,3,1,0,0,565.5737704918,''),(133,1,4,1,0,0,0,''),(133,1,4,2,0,0,0,''),(133,1,5,1,0,1,0,''),(134,1,1,1,0,0,46000,''),(134,1,2,1,0,0,47000,''),(134,1,3,1,0,0,577.86885245902,''),(134,1,4,1,0,0,0,''),(134,1,4,2,0,0,0,''),(134,1,5,1,0,1,0,''),(135,1,1,1,0,0,47000,''),(135,1,2,1,0,0,48000,''),(135,1,3,1,0,0,590.16393442623,''),(135,1,4,1,0,0,0,''),(135,1,4,2,0,0,0,''),(135,1,5,1,0,1,0,''),(136,1,1,1,0,0,48000,''),(136,1,2,1,0,0,49000,''),(136,1,3,1,0,0,602.45901639344,''),(136,1,4,1,0,0,0,''),(136,1,4,2,0,0,0,''),(136,1,5,1,0,1,0,''),(137,1,1,1,0,0,49000,''),(137,1,2,1,0,0,50000,''),(137,1,3,1,0,0,614.75409836066,''),(137,1,4,1,0,0,0,''),(137,1,4,2,0,0,0,''),(137,1,5,1,0,1,0,''),(138,1,1,1,0,0,50000,''),(138,1,2,1,0,0,51000,''),(138,1,3,1,0,0,627.04918032787,''),(138,1,4,1,0,0,0,''),(138,1,4,2,0,0,0,''),(138,1,5,1,0,1,0,''),(139,1,1,1,0,0,51000,''),(139,1,2,1,0,0,52000,''),(139,1,3,1,0,0,639.34426229508,''),(139,1,4,1,0,0,0,''),(139,1,4,2,0,0,0,''),(139,1,5,1,0,1,0,''),(140,1,1,1,0,0,52000,''),(140,1,2,1,0,0,53000,''),(140,1,3,1,0,0,651.6393442623,''),(140,1,4,1,0,0,0,''),(140,1,4,2,0,0,0,''),(140,1,5,1,0,1,0,''),(141,1,1,1,0,0,53000,''),(141,1,2,1,0,0,54000,''),(141,1,3,1,0,0,663.93442622951,''),(141,1,4,1,0,0,0,''),(141,1,4,2,0,0,0,''),(141,1,5,1,0,1,0,''),(142,1,1,1,0,0,54000,''),(142,1,2,1,0,0,55000,''),(142,1,3,1,0,0,676.22950819672,''),(142,1,4,1,0,0,0,''),(142,1,4,2,0,0,0,''),(142,1,5,1,0,1,0,''),(143,1,1,1,0,0,55000,''),(143,1,2,1,0,0,56000,''),(143,1,3,1,0,0,688.52459016393,''),(143,1,4,1,0,0,0,''),(143,1,4,2,0,0,0,''),(143,1,5,1,0,1,0,''),(144,1,1,1,0,0,56000,''),(144,1,2,1,0,0,57000,''),(144,1,3,1,0,0,700.81967213115,''),(144,1,4,1,0,0,0,''),(144,1,4,2,0,0,0,''),(144,1,5,1,0,1,0,''),(145,1,1,1,0,0,57000,''),(145,1,2,1,0,0,58000,''),(145,1,3,1,0,0,713.11475409836,''),(145,1,4,1,0,0,0,''),(145,1,4,2,0,0,0,''),(145,1,5,1,0,1,0,''),(146,1,1,1,0,0,58000,''),(146,1,2,1,0,0,59000,''),(146,1,3,1,0,0,725.40983606557,''),(146,1,4,1,0,0,0,''),(146,1,4,2,0,0,0,''),(146,1,5,1,0,1,0,''),(147,1,1,1,0,0,59000,''),(147,1,2,1,0,0,60000,''),(147,1,3,1,0,0,737.70491803279,''),(147,1,4,1,0,0,0,''),(147,1,4,2,0,0,0,''),(147,1,5,1,0,1,0,''),(148,1,1,1,0,0,60000,''),(148,1,2,1,0,0,61000,''),(148,1,3,1,0,0,750,''),(148,1,4,1,0,0,0,''),(148,1,4,2,0,0,0,''),(148,1,5,1,0,1,0,''),(149,1,1,1,0,0,61000,''),(149,1,2,1,0,0,62000,''),(149,1,3,1,0,0,762.29508196721,''),(149,1,4,1,0,0,0,''),(149,1,4,2,0,0,0,''),(149,1,5,1,0,1,0,''),(150,1,1,1,0,0,62000,''),(150,1,2,1,0,0,63000,''),(150,1,3,1,0,0,774.59016393443,''),(150,1,4,1,0,0,0,''),(150,1,4,2,0,0,0,''),(150,1,5,1,0,1,0,''),(151,1,1,1,0,0,63000,''),(151,1,2,1,0,0,64000,''),(151,1,3,1,0,0,786.88524590164,''),(151,1,4,1,0,0,0,''),(151,1,4,2,0,0,0,''),(151,1,5,1,0,1,0,''),(152,1,1,1,0,0,64000,''),(152,1,2,1,0,0,65000,''),(152,1,3,1,0,0,799.18032786885,''),(152,1,4,1,0,0,0,''),(152,1,4,2,0,0,0,''),(152,1,5,1,0,1,0,''),(153,1,1,1,0,0,65000,''),(153,1,2,1,0,0,66000,''),(153,1,3,1,0,0,811.47540983607,''),(153,1,4,1,0,0,0,''),(153,1,4,2,0,0,0,''),(153,1,5,1,0,1,0,''),(154,1,1,1,0,0,66000,''),(154,1,2,1,0,0,67000,''),(154,1,3,1,0,0,823.77049180328,''),(154,1,4,1,0,0,0,''),(154,1,4,2,0,0,0,''),(154,1,5,1,0,1,0,''),(155,1,1,1,0,0,67000,''),(155,1,2,1,0,0,68000,''),(155,1,3,1,0,0,836.06557377049,''),(155,1,4,1,0,0,0,''),(155,1,4,2,0,0,0,''),(155,1,5,1,0,1,0,''),(156,1,1,1,0,0,68000,''),(156,1,2,1,0,0,69000,''),(156,1,3,1,0,0,848.3606557377,''),(156,1,4,1,0,0,0,''),(156,1,4,2,0,0,0,''),(156,1,5,1,0,1,0,''),(157,1,1,1,0,0,69000,''),(157,1,2,1,0,0,70000,''),(157,1,3,1,0,0,860.65573770492,''),(157,1,4,1,0,0,0,''),(157,1,4,2,0,0,0,''),(157,1,5,1,0,1,0,''),(158,1,1,1,0,0,70000,''),(158,1,2,1,0,0,71000,''),(158,1,3,1,0,0,872.95081967213,''),(158,1,4,1,0,0,0,''),(158,1,4,2,0,0,0,''),(158,1,5,1,0,1,0,''),(159,1,1,1,0,0,71000,''),(159,1,2,1,0,0,72000,''),(159,1,3,1,0,0,885.24590163934,''),(159,1,4,1,0,0,0,''),(159,1,4,2,0,0,0,''),(159,1,5,1,0,1,0,''),(160,1,1,1,0,0,72000,''),(160,1,2,1,0,0,73000,''),(160,1,3,1,0,0,897.54098360656,''),(160,1,4,1,0,0,0,''),(160,1,4,2,0,0,0,''),(160,1,5,1,0,1,0,''),(161,1,1,1,0,0,73000,''),(161,1,2,1,0,0,74000,''),(161,1,3,1,0,0,909.83606557377,''),(161,1,4,1,0,0,0,''),(161,1,4,2,0,0,0,''),(161,1,5,1,0,1,0,''),(162,1,1,1,0,0,74000,''),(162,1,2,1,0,0,75000,''),(162,1,3,1,0,0,922.13114754098,''),(162,1,4,1,0,0,0,''),(162,1,4,2,0,0,0,''),(162,1,5,1,0,1,0,''),(163,1,1,1,0,0,75000,''),(163,1,2,1,0,0,76000,''),(163,1,3,1,0,0,934.4262295082,''),(163,1,4,1,0,0,0,''),(163,1,4,2,0,0,0,''),(163,1,5,1,0,1,0,''),(164,1,1,1,0,0,76000,''),(164,1,2,1,0,0,77000,''),(164,1,3,1,0,0,946.72131147541,''),(164,1,4,1,0,0,0,''),(164,1,4,2,0,0,0,''),(164,1,5,1,0,1,0,''),(165,1,1,1,0,0,77000,''),(165,1,2,1,0,0,78000,''),(165,1,3,1,0,0,959.01639344262,''),(165,1,4,1,0,0,0,''),(165,1,4,2,0,0,0,''),(165,1,5,1,0,1,0,''),(166,1,1,1,0,0,78000,''),(166,1,2,1,0,0,79000,''),(166,1,3,1,0,0,971.31147540984,''),(166,1,4,1,0,0,0,''),(166,1,4,2,0,0,0,''),(166,1,5,1,0,1,0,''),(167,1,1,1,0,0,79000,''),(167,1,2,1,0,0,80000,''),(167,1,3,1,0,0,983.60655737705,''),(167,1,4,1,0,0,0,''),(167,1,4,2,0,0,0,''),(167,1,5,1,0,1,0,''),(168,1,1,1,0,0,80000,''),(168,1,2,1,0,0,81000,''),(168,1,3,1,0,0,995.90163934426,''),(168,1,4,1,0,0,0,''),(168,1,4,2,0,0,0,''),(168,1,5,1,0,1,0,''),(169,1,1,1,0,0,81000,''),(169,1,2,1,0,0,82000,''),(169,1,3,1,0,0,1008.1967213115,''),(169,1,4,1,0,0,0,''),(169,1,4,2,0,0,0,''),(169,1,5,1,0,1,0,''),(170,1,1,1,0,0,82000,''),(170,1,2,1,0,0,83000,''),(170,1,3,1,0,0,1020.4918032787,''),(170,1,4,1,0,0,0,''),(170,1,4,2,0,0,0,''),(170,1,5,1,0,1,0,''),(171,1,1,1,0,0,83000,''),(171,1,2,1,0,0,84000,''),(171,1,3,1,0,0,1032.7868852459,''),(171,1,4,1,0,0,0,''),(171,1,4,2,0,0,0,''),(171,1,5,1,0,1,0,''),(172,1,1,1,0,0,84000,''),(172,1,2,1,0,0,85000,''),(172,1,3,1,0,0,1045.0819672131,''),(172,1,4,1,0,0,0,''),(172,1,4,2,0,0,0,''),(172,1,5,1,0,1,0,''),(173,1,1,1,0,0,85000,''),(173,1,2,1,0,0,86000,''),(173,1,3,1,0,0,1057.3770491803,''),(173,1,4,1,0,0,0,''),(173,1,4,2,0,0,0,''),(173,1,5,1,0,1,0,''),(174,1,1,1,0,0,86000,''),(174,1,2,1,0,0,87000,''),(174,1,3,1,0,0,1069.6721311475,''),(174,1,4,1,0,0,0,''),(174,1,4,2,0,0,0,''),(174,1,5,1,0,1,0,''),(175,1,1,1,0,0,87000,''),(175,1,2,1,0,0,88000,''),(175,1,3,1,0,0,1081.9672131148,''),(175,1,4,1,0,0,0,''),(175,1,4,2,0,0,0,''),(175,1,5,1,0,1,0,''),(176,1,1,1,0,0,88000,''),(176,1,2,1,0,0,89000,''),(176,1,3,1,0,0,1094.262295082,''),(176,1,4,1,0,0,0,''),(176,1,4,2,0,0,0,''),(176,1,5,1,0,1,0,''),(177,1,1,1,0,0,89000,''),(177,1,2,1,0,0,90000,''),(177,1,3,1,0,0,1106.5573770492,''),(177,1,4,1,0,0,0,''),(177,1,4,2,0,0,0,''),(177,1,5,1,0,1,0,''),(178,1,1,1,0,0,90000,''),(178,1,2,1,0,0,91000,''),(178,1,3,1,0,0,1118.8524590164,''),(178,1,4,1,0,0,0,''),(178,1,4,2,0,0,0,''),(178,1,5,1,0,1,0,''),(179,1,1,1,0,0,91000,''),(179,1,2,1,0,0,92000,''),(179,1,3,1,0,0,1131.1475409836,''),(179,1,4,1,0,0,0,''),(179,1,4,2,0,0,0,''),(179,1,5,1,0,1,0,''),(180,1,1,1,0,0,92000,''),(180,1,2,1,0,0,93000,''),(180,1,3,1,0,0,1143.4426229508,''),(180,1,4,1,0,0,0,''),(180,1,4,2,0,0,0,''),(180,1,5,1,0,1,0,''),(181,1,1,1,0,0,93000,''),(181,1,2,1,0,0,94000,''),(181,1,3,1,0,0,1155.737704918,''),(181,1,4,1,0,0,0,''),(181,1,4,2,0,0,0,''),(181,1,5,1,0,1,0,''),(182,1,1,1,0,0,94000,''),(182,1,2,1,0,0,95000,''),(182,1,3,1,0,0,1168.0327868852,''),(182,1,4,1,0,0,0,''),(182,1,4,2,0,0,0,''),(182,1,5,1,0,1,0,''),(183,1,1,1,0,0,95000,''),(183,1,2,1,0,0,96000,''),(183,1,3,1,0,0,1180.3278688525,''),(183,1,4,1,0,0,0,''),(183,1,4,2,0,0,0,''),(183,1,5,1,0,1,0,''),(184,1,1,1,0,0,96000,''),(184,1,2,1,0,0,97000,''),(184,1,3,1,0,0,1192.6229508197,''),(184,1,4,1,0,0,0,''),(184,1,4,2,0,0,0,''),(184,1,5,1,0,1,0,''),(185,1,1,1,0,0,97000,''),(185,1,2,1,0,0,98000,''),(185,1,3,1,0,0,1204.9180327869,''),(185,1,4,1,0,0,0,''),(185,1,4,2,0,0,0,''),(185,1,5,1,0,1,0,''),(186,1,1,1,0,0,98000,''),(186,1,2,1,0,0,99000,''),(186,1,3,1,0,0,1217.2131147541,''),(186,1,4,1,0,0,0,''),(186,1,4,2,0,0,0,''),(186,1,5,1,0,1,0,'');

--
-- Table structure for table `ngn_postal_item_custom_values_multi`
--

CREATE TABLE `ngn_postal_item_custom_values_multi` (
  `item_id` int(11) NOT NULL,
  `item_category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`item_category_id`,`gaid`,`language_id`,`valueInt`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_custom_values_multi`
--


--
-- Table structure for table `ngn_postal_item_file`
--

CREATE TABLE `ngn_postal_item_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_file`
--


--
-- Table structure for table `ngn_postal_item_files`
--

CREATE TABLE `ngn_postal_item_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `item_id` (`item_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_files`
--


--
-- Table structure for table `ngn_postal_item_files_language`
--

CREATE TABLE `ngn_postal_item_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_files_language`
--


--
-- Table structure for table `ngn_postal_item_groups`
--

CREATE TABLE `ngn_postal_item_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_category_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `item_category_id` (`item_category_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_groups`
--

INSERT INTO `ngn_postal_item_groups` VALUES (1,1,1,0,1,0),(3,3,1,0,1,0),(4,5,2,0,1,0),(5,6,2,0,1,0),(6,7,2,0,1,0),(7,4,2,0,1,0),(8,2,4,0,1,0);

--
-- Table structure for table `ngn_postal_item_groups_atribute`
--

CREATE TABLE `ngn_postal_item_groups_atribute` (
  `cgid` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL DEFAULT 0,
  `valueFloat` double NOT NULL DEFAULT 0,
  `valueText` text NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `gaid` (`gaid`),
  KEY `cgid` (`cgid`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_groups_atribute`
--

INSERT INTO `ngn_postal_item_groups_atribute` VALUES (4,6,1,5,0,''),(5,6,1,4,0,''),(6,6,1,8,0,'');

--
-- Table structure for table `ngn_postal_item_language`
--

CREATE TABLE `ngn_postal_item_language` (
  `item_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo1` varchar(100) NOT NULL,
  `language_photo2` varchar(100) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`item_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  FULLTEXT KEY `language_html` (`language_html`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_language`
--

INSERT INTO `ngn_postal_item_language` VALUES (3,1,'2023-04-05 15:37:59',1,0,'Po&scaron;tnina na težo (rest of the world)','','','','','','',''),(3,2,'2022-10-24 15:56:00',1,0,'Po&scaron;ta Slovenije na težo','','','','','','',''),(5,1,'2022-10-24 14:24:04',1,0,'Po&scaron;ta Slovenije na ceno - EU','','','','','','',''),(5,2,'2022-10-24 14:30:21',1,0,'Po&scaron;ta Slovenije na ceno - EU','','','','','','',''),(6,1,'2020-08-17 16:48:04',1,0,'Odkupnine - Po&scaron;ta Slovenije EU','','','','','','',''),(6,2,'2020-08-17 16:49:33',1,0,'Odkupnine - Po&scaron;ta Slovenije EU','','','','','','',''),(8,1,'2022-12-06 09:22:36',1,0,'Tipi plačila Po&scaron;ta Slovenije - EU','','','','','','',''),(8,2,'2020-08-17 16:49:33',1,0,'Tipi plačila Po&scaron;ta Slovenije - EU','','','','','','',''),(15,1,'2020-08-17 16:48:03',1,0,'Odkupnine - Po&scaron;ta Slovenije SLO','','','','','','',''),(15,2,'2020-08-17 16:49:33',1,0,'Odkupnine - Po&scaron;ta Slovenije SLO','','','','','','',''),(16,1,'2022-10-24 14:07:08',1,0,'Po&scaron;ta Slovenije na ceno - SLO','','','','','','',''),(16,2,'2020-08-17 16:49:32',1,0,'Po&scaron;ta Slovenije na ceno - SLO','','','','','','',''),(16,3,'2020-05-18 14:33:59',0,0,'Po&scaron;ta Slovenije na ceno - SLO','','','','','','',''),(17,1,'2022-10-13 09:32:06',1,0,'Po&scaron;ta Slovenije na ceno - Ostale države Evrope','','','','','','',''),(17,2,'2020-08-17 16:49:31',1,0,'Po&scaron;ta Slovenije na ceno - Ostale države Evrope','','','','','','',''),(18,1,'2022-10-13 12:14:41',1,0,'Po&scaron;ta Slovenije na ceno - svet','','','','','','',''),(18,2,'2020-08-17 16:49:30',1,0,'Po&scaron;ta Slovenije na ceno - svet','','','','','','',''),(19,1,'2022-10-24 14:06:59',1,0,'Tipi plačila - Slovenia','','','','','','',''),(19,2,'2020-08-17 16:49:32',1,0,'Tipi plačila - Slovenia','','','','','','',''),(20,1,'2022-12-06 09:23:11',1,0,'Tipi plačila - Ostale države Evrope','','','','','','',''),(20,2,'2020-08-17 16:49:31',1,0,'Tipi plačila - Ostale države Evrope','','','','','','',''),(21,1,'2022-12-06 09:22:21',1,0,'Tipi plačila - Rest of the world','','','','','','',''),(21,2,'2020-08-17 16:49:30',1,0,'Tipi plačila - Rest of the world','','','','','','','');

--
-- Table structure for table `ngn_postal_item_photo`
--

CREATE TABLE `ngn_postal_item_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `item_id` (`item_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_photo`
--


--
-- Table structure for table `ngn_postal_item_photo_gallery`
--

CREATE TABLE `ngn_postal_item_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_photo_gallery`
--


--
-- Table structure for table `ngn_postal_item_photo_gallery_language`
--

CREATE TABLE `ngn_postal_item_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`item_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_photo_gallery_language`
--


--
-- Table structure for table `ngn_postal_item_photo_language`
--

CREATE TABLE `ngn_postal_item_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_photo_language`
--


--
-- Table structure for table `ngn_postal_item_variations`
--

CREATE TABLE `ngn_postal_item_variations` (
  `variations_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `variation_order` int(11) NOT NULL,
  `enable` tinyint(1) NOT NULL,
  PRIMARY KEY (`variations_id`),
  KEY `item_id` (`item_id`),
  KEY `enable` (`enable`)
) ENGINE=InnoDB AUTO_INCREMENT=187 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_variations`
--

INSERT INTO `ngn_postal_item_variations` VALUES (3,1,1,1),(4,1,2,1),(5,1,3,1),(6,2,1,1),(7,2,2,1),(8,2,3,1),(11,4,1,1),(12,4,2,1),(14,5,0,1),(15,6,1,1),(18,9,1,1),(19,10,1,1),(21,7,1,1),(22,7,0,1),(23,8,2,1),(24,11,1,0),(33,10,3,0),(34,8,0,1),(35,12,1,0),(36,13,1,0),(37,13,2,0),(38,10,4,0),(39,13,3,0),(40,8,1,1),(45,14,1,0),(47,15,1,1),(48,15,2,1),(49,6,2,1),(50,5,1,1),(51,16,1,1),(52,16,2,1),(53,17,1,1),(54,17,2,1),(55,18,1,1),(57,19,2,1),(58,19,0,1),(59,19,1,1),(60,20,1,1),(61,20,2,1),(62,20,3,1),(63,21,1,1),(64,21,2,1),(65,21,3,1),(66,3,1,1),(67,3,2,1),(90,3,3,1),(91,3,4,1),(92,3,5,1),(93,3,6,1),(94,3,7,1),(95,3,8,1),(96,3,9,1),(97,3,10,1),(98,3,11,1),(99,3,12,1),(100,3,13,1),(101,3,14,1),(102,3,15,1),(103,3,16,1),(104,3,17,1),(105,3,18,1),(106,3,19,1),(107,3,20,1),(108,3,21,1),(109,3,22,1),(110,3,23,1),(111,3,24,1),(112,3,25,1),(113,3,26,1),(114,3,27,1),(115,3,28,1),(116,3,29,1),(117,3,30,1),(118,3,31,1),(119,3,32,1),(120,3,33,1),(121,3,34,1),(122,3,35,1),(123,3,36,1),(124,3,37,1),(125,3,38,1),(126,3,39,1),(127,3,40,1),(128,3,41,1),(129,3,42,1),(130,3,43,1),(131,3,44,1),(132,3,45,1),(133,3,46,1),(134,3,47,1),(135,3,48,1),(136,3,49,1),(137,3,50,1),(138,3,51,1),(139,3,52,1),(140,3,53,1),(141,3,54,1),(142,3,55,1),(143,3,56,1),(144,3,57,1),(145,3,58,1),(146,3,59,1),(147,3,60,1),(148,3,61,1),(149,3,62,1),(150,3,63,1),(151,3,64,1),(152,3,65,1),(153,3,66,1),(154,3,67,1),(155,3,68,1),(156,3,69,1),(157,3,70,1),(158,3,71,1),(159,3,72,1),(160,3,73,1),(161,3,74,1),(162,3,75,1),(163,3,76,1),(164,3,77,1),(165,3,78,1),(166,3,79,1),(167,3,80,1),(168,3,81,1),(169,3,82,1),(170,3,83,1),(171,3,84,1),(172,3,85,1),(173,3,86,1),(174,3,87,1),(175,3,88,1),(176,3,89,1),(177,3,90,1),(178,3,91,1),(179,3,92,1),(180,3,93,1),(181,3,94,1),(182,3,95,1),(183,3,96,1),(184,3,97,1),(185,3,98,1),(186,3,99,1);

--
-- Table structure for table `ngn_postal_item_variations_language`
--

CREATE TABLE `ngn_postal_item_variations_language` (
  `variation_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`variation_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_item_variations_language`
--

INSERT INTO `ngn_postal_item_variations_language` VALUES (3,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(3,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(4,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(4,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(5,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(5,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(6,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(6,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(7,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(7,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(8,1,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(8,2,'0000-00-00 00:00:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(11,1,'2020-05-11 11:48:13',1,0,NULL,NULL,NULL,NULL,NULL,''),(11,2,'2020-05-11 11:48:13',1,0,NULL,NULL,NULL,NULL,NULL,''),(12,1,'2020-05-11 11:48:13',1,0,NULL,NULL,NULL,NULL,NULL,''),(12,2,'2020-05-11 11:48:13',1,0,NULL,NULL,NULL,NULL,NULL,''),(14,1,'2022-10-24 14:24:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(14,2,'2022-10-24 14:24:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(15,1,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(15,2,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(18,1,'2020-04-10 15:58:56',1,0,NULL,NULL,NULL,NULL,NULL,''),(18,2,'2020-04-10 15:58:56',1,0,NULL,NULL,NULL,NULL,NULL,''),(19,1,'2020-04-30 17:10:35',1,0,NULL,NULL,NULL,NULL,NULL,''),(19,2,'2020-04-30 17:10:35',1,0,NULL,NULL,NULL,NULL,NULL,''),(21,1,'2020-04-10 15:58:52',1,0,NULL,NULL,NULL,NULL,NULL,''),(21,2,'2020-04-10 15:58:52',1,0,NULL,NULL,NULL,NULL,NULL,''),(22,1,'2020-04-10 15:58:52',1,0,NULL,NULL,NULL,NULL,NULL,''),(22,2,'2020-04-10 15:58:52',1,0,NULL,NULL,NULL,NULL,NULL,''),(23,1,'2022-12-06 09:22:36',1,0,NULL,NULL,NULL,NULL,NULL,''),(23,2,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(33,1,'2020-04-30 17:10:35',0,0,NULL,NULL,NULL,NULL,NULL,''),(33,2,'2020-04-30 17:10:35',0,0,NULL,NULL,NULL,NULL,NULL,''),(34,1,'2022-12-06 09:22:36',1,0,NULL,NULL,NULL,NULL,NULL,''),(34,2,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(38,1,'2020-04-30 17:10:35',0,0,NULL,NULL,NULL,NULL,NULL,''),(38,2,'2020-04-30 17:10:35',0,0,NULL,NULL,NULL,NULL,NULL,''),(40,1,'2022-12-06 09:22:36',1,0,NULL,NULL,NULL,NULL,NULL,''),(40,2,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(47,1,'2020-08-17 16:48:03',1,0,NULL,NULL,NULL,NULL,NULL,''),(47,2,'2020-08-17 16:48:03',1,0,NULL,NULL,NULL,NULL,NULL,''),(48,1,'2020-08-17 16:48:03',1,0,NULL,NULL,NULL,NULL,NULL,''),(48,2,'2020-08-17 16:48:03',1,0,NULL,NULL,NULL,NULL,NULL,''),(49,1,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(49,2,'2020-08-17 16:48:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(50,1,'2022-10-24 14:24:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(50,2,'2022-10-24 14:24:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(51,1,'2022-10-24 14:07:08',1,0,NULL,NULL,NULL,NULL,NULL,''),(51,2,'2022-10-24 14:07:08',1,0,NULL,NULL,NULL,NULL,NULL,''),(51,3,'2020-05-18 14:33:59',0,0,NULL,NULL,NULL,NULL,NULL,''),(52,1,'2022-10-24 14:07:08',1,0,NULL,NULL,NULL,NULL,NULL,''),(52,2,'2022-10-24 14:07:08',1,0,NULL,NULL,NULL,NULL,NULL,''),(52,3,'2020-05-18 14:33:59',0,0,NULL,NULL,NULL,NULL,NULL,''),(53,1,'2022-10-13 09:32:06',1,0,NULL,NULL,NULL,NULL,NULL,''),(53,2,'2022-10-13 09:32:06',1,0,NULL,NULL,NULL,NULL,NULL,''),(54,1,'2022-10-13 09:32:06',1,0,NULL,NULL,NULL,NULL,NULL,''),(54,2,'2022-10-13 09:32:06',1,0,NULL,NULL,NULL,NULL,NULL,''),(55,1,'2022-10-13 12:14:41',1,0,NULL,NULL,NULL,NULL,NULL,''),(55,2,'2022-10-13 12:14:41',1,0,NULL,NULL,NULL,NULL,NULL,''),(57,1,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(57,2,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(58,1,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(58,2,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(59,1,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(59,2,'2022-10-24 14:06:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(60,1,'2022-12-06 09:23:11',1,0,NULL,NULL,NULL,NULL,NULL,''),(60,2,'2020-08-17 16:48:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(61,1,'2022-12-06 09:23:11',1,0,NULL,NULL,NULL,NULL,NULL,''),(61,2,'2020-08-17 16:48:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(62,1,'2022-12-06 09:23:11',1,0,NULL,NULL,NULL,NULL,NULL,''),(62,2,'2020-08-17 16:48:00',1,0,NULL,NULL,NULL,NULL,NULL,''),(63,1,'2022-12-06 09:22:21',1,0,NULL,NULL,NULL,NULL,NULL,''),(63,2,'2020-08-17 16:47:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(64,1,'2022-12-06 09:22:21',1,0,NULL,NULL,NULL,NULL,NULL,''),(64,2,'2020-08-17 16:47:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(65,1,'2022-12-06 09:22:21',1,0,NULL,NULL,NULL,NULL,NULL,''),(65,2,'2020-08-17 16:47:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(66,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(66,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(67,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(67,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(90,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(90,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(91,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(91,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(92,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(92,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(93,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(93,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(94,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(94,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(95,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(95,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(96,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(96,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(97,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(97,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(98,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(98,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(99,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(99,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(100,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(100,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(101,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(101,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(102,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(102,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(103,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(103,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(104,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(104,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(105,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(105,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(106,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(106,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(107,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(107,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(108,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(108,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(109,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(109,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(110,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(110,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(111,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(111,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(112,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(112,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(113,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(113,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(114,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(114,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(115,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(115,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(116,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(116,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(117,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(117,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(118,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(118,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(119,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(119,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(120,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(120,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(121,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(121,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(122,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(122,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(123,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(123,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(124,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(124,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(125,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(125,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(126,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(126,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(127,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(127,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(128,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(128,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(129,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(129,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(130,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(130,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(131,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(131,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(132,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(132,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(133,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(133,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(134,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(134,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(135,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(135,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(136,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(136,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(137,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(137,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(138,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(138,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(139,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(139,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(140,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(140,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(141,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(141,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(142,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(142,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(143,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(143,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(144,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(144,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(145,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(145,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(146,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(146,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(147,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(147,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(148,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(148,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(149,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(149,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(150,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(150,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(151,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(151,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(152,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(152,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(153,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(153,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(154,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(154,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(155,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(155,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(156,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(156,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(157,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(157,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(158,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(158,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(159,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(159,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(160,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(160,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(161,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(161,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(162,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(162,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(163,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(163,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(164,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(164,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(165,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(165,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(166,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(166,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(167,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(167,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(168,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(168,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(169,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(169,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(170,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(170,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(171,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(171,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(172,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(172,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(173,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(173,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(174,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(174,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(175,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(175,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(176,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(176,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(177,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(177,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(178,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(178,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(179,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(179,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(180,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(180,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(181,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(181,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(182,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(182,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(183,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(183,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(184,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(184,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(185,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(185,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,''),(186,1,'2023-04-05 15:37:59',1,0,NULL,NULL,NULL,NULL,NULL,''),(186,2,'2022-10-24 15:56:04',1,0,NULL,NULL,NULL,NULL,NULL,'');

--
-- Table structure for table `ngn_postal_language`
--

CREATE TABLE `ngn_postal_language` (
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `photo1` int(11) NOT NULL,
  `photo2` int(11) NOT NULL,
  `language_photo1` varchar(200) NOT NULL,
  `language_photo2` varchar(200) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`news_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  KEY `photo1` (`photo1`),
  KEY `photo2` (`photo2`),
  FULLTEXT KEY `language_html` (`language_html`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_language`
--

INSERT INTO `ngn_postal_language` VALUES (3,1,'2022-10-25 10:28:57',1,1,'Dostava na dom','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','dostava-na-dom',0,0,'','',''),(3,2,'2022-10-25 10:28:58',1,1,'Shipping fee','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','3-home-delivery',0,0,'','',''),(3,3,'2020-05-20 15:27:31',1,1,'Shipping fee (EU)','&lt;p&gt;&lt;span&gt;Po&amp;scaron;tar iz Po&amp;scaron;te Slovenije&amp;nbsp;dostavi va&amp;scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','',0,0,'','',''),(7,1,'2022-10-25 10:28:49',1,1,'Dostava na dom','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','posta-slovenije',0,0,'','',''),(7,2,'2022-10-25 10:28:53',1,1,'Shipping fee','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','7-home-delivery',0,0,'','',''),(7,3,'2020-05-20 15:27:32',1,1,'Shipping fee (SLO)','&lt;p&gt;&lt;span&gt;Po&amp;scaron;tar iz Po&amp;scaron;te Slovenije&amp;nbsp;dostavi va&amp;scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','',0,0,'','',''),(8,1,'2022-10-25 10:28:40',1,1,'Dostava na dom','','','','shipping-fee',0,0,'','',''),(8,2,'2022-10-25 10:28:04',1,1,'Shipping fee','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','shipping-fee',0,0,'','',''),(8,3,'2020-05-20 15:27:33',1,1,'Shipping fee (Rest of EU)','&lt;p&gt;&lt;span&gt;Po&amp;scaron;tar iz Po&amp;scaron;te Slovenije&amp;nbsp;dostavi va&amp;scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','',0,0,'','',''),(9,1,'2022-10-25 10:28:28',1,1,'Dostava na dom','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','shipping-fee-rest-of-the-world',0,0,'','',''),(9,2,'2022-10-25 10:28:18',1,1,'Shipping fee','&lt;p&gt;&lt;span&gt;Po&scaron;tar iz Po&scaron;te Slovenije&nbsp;dostavi va&scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','shipping-fee-rest-of-the-world',0,0,'','',''),(9,3,'2020-05-20 15:27:36',1,1,'Shipping fee (Rest of the world)','&lt;p&gt;&lt;span&gt;Po&amp;scaron;tar iz Po&amp;scaron;te Slovenije&amp;nbsp;dostavi va&amp;scaron;e naročilo na izbrani naslov.&lt;/span&gt;&lt;/p&gt;','','','',0,0,'','',''),(10,1,'2022-10-20 16:13:30',1,1,'Osebni prevzem','','','','osebni-prevzem',0,0,'','',''),(10,2,'2022-10-20 16:13:34',1,1,'Personal pickup','','','','home-delivery',0,0,'','','');

--
-- Table structure for table `ngn_postal_links`
--

CREATE TABLE `ngn_postal_links` (
  `news_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `news_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`link_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `news_position` (`news_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_links`
--


--
-- Table structure for table `ngn_postal_media`
--

CREATE TABLE `ngn_postal_media` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `id` int(11) NOT NULL,
  `template` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_media`
--


--
-- Table structure for table `ngn_postal_media_gallery`
--

CREATE TABLE `ngn_postal_media_gallery` (
  `gallery_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`,`photo_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_media_gallery`
--


--
-- Table structure for table `ngn_postal_pages`
--

CREATE TABLE `ngn_postal_pages` (
  `news_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `news_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`link_id`,`language_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `news_position` (`news_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_pages`
--


--
-- Table structure for table `ngn_postal_photo`
--

CREATE TABLE `ngn_postal_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `news_id` (`news_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo`
--


--
-- Table structure for table `ngn_postal_photo_gallery`
--

CREATE TABLE `ngn_postal_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo_gallery`
--


--
-- Table structure for table `ngn_postal_photo_gallery_language`
--

CREATE TABLE `ngn_postal_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`news_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo_gallery_language`
--


--
-- Table structure for table `ngn_postal_photo_language`
--

CREATE TABLE `ngn_postal_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_photo_language_id1` FOREIGN KEY (`photo_id`) REFERENCES `ngn_postal_photo` (`photo_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo_language`
--


--
-- Table structure for table `ngn_postal_photo_sizes`
--

CREATE TABLE `ngn_postal_photo_sizes` (
  `photo_id` int(11) NOT NULL,
  `size_id` int(11) NOT NULL,
  `photo_width` int(11) NOT NULL,
  `photo_height` int(11) NOT NULL,
  `photo_photo` varchar(100) NOT NULL,
  `photo_path` varchar(200) NOT NULL,
  PRIMARY KEY (`photo_id`,`size_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo_sizes`
--


--
-- Table structure for table `ngn_postal_photo_usage`
--

CREATE TABLE `ngn_postal_photo_usage` (
  `photo_id` int(11) NOT NULL,
  `module_name` varchar(50) NOT NULL,
  `usage_type` varchar(50) NOT NULL,
  `link_id` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`module_name`,`usage_type`,`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_photo_usage`
--


--
-- Table structure for table `ngn_postal_restrictions`
--

CREATE TABLE `ngn_postal_restrictions` (
  `restrictions_id` int(11) NOT NULL AUTO_INCREMENT,
  `restrictions_name` varchar(100) NOT NULL,
  `restrictions_default` int(11) NOT NULL,
  PRIMARY KEY (`restrictions_id`),
  FULLTEXT KEY `restrictions_name` (`restrictions_name`),
  FULLTEXT KEY `restrictions_name_2` (`restrictions_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_restrictions`
--

INSERT INTO `ngn_postal_restrictions` VALUES (1,'Default',1);

--
-- Table structure for table `ngn_postal_restrictions_groups`
--

CREATE TABLE `ngn_postal_restrictions_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `restriction_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `restriction_id_2` (`restriction_id`,`group_id`),
  KEY `group_id` (`group_id`),
  KEY `restriction_id` (`restriction_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_restrictions_groups`
--


--
-- Table structure for table `ngn_postal_restrictions_settings`
--

CREATE TABLE `ngn_postal_restrictions_settings` (
  `restriction_id` int(11) NOT NULL,
  `restriction_var` varchar(100) NOT NULL,
  `restriction_value_int` int(11) NOT NULL,
  `restriction_value_text` text NOT NULL,
  `restriction_value_float` float NOT NULL,
  PRIMARY KEY (`restriction_id`,`restriction_var`),
  KEY `restriction_var` (`restriction_var`),
  KEY `restriction_id` (`restriction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_restrictions_settings`
--


--
-- Table structure for table `ngn_postal_restrictions_settings_multi`
--

CREATE TABLE `ngn_postal_restrictions_settings_multi` (
  `restriction_id` int(11) NOT NULL,
  `restriction_var` varchar(100) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`restriction_id`,`restriction_var`,`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_restrictions_settings_multi`
--


--
-- Table structure for table `ngn_postal_roles`
--

CREATE TABLE `ngn_postal_roles` (
  `role_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `news_edit` tinyint(11) NOT NULL DEFAULT 0,
  `news_delete` tinyint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`role_id`,`news_id`),
  KEY `category_id` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_roles`
--


--
-- Table structure for table `ngn_postal_tags`
--

CREATE TABLE `ngn_postal_tags` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_createdate` datetime DEFAULT NULL,
  `tag_showdate` datetime DEFAULT NULL,
  `tag_hidedate` datetime DEFAULT NULL,
  `tag_hide` int(11) NOT NULL,
  `tag_editdate` datetime DEFAULT NULL,
  `tag_owner` int(11) NOT NULL,
  `tag_order` int(11) NOT NULL,
  PRIMARY KEY (`tag_id`),
  KEY `tag_hide` (`tag_hide`),
  KEY `tag_order` (`tag_order`),
  KEY `tag_owner` (`tag_owner`),
  KEY `tag_createdate` (`tag_createdate`),
  KEY `tag_editdate` (`tag_editdate`),
  KEY `tag_hidedate` (`tag_hidedate`),
  KEY `tag_showdate` (`tag_showdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_tags`
--


--
-- Table structure for table `ngn_postal_tags_language`
--

CREATE TABLE `ngn_postal_tags_language` (
  `tag_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`tag_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_postal_tags_language_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_postal_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_tags_language`
--


--
-- Table structure for table `ngn_postal_tags_links`
--

CREATE TABLE `ngn_postal_tags_links` (
  `tag_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`tag_id`,`news_id`,`language_id`),
  KEY `news_id` (`news_id`),
  CONSTRAINT `ngn_postal_tags_links_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_postal_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_postal_tags_links`
--


--
-- Table structure for table `ngn_region`
--

CREATE TABLE `ngn_region` (
  `region_id` int(11) NOT NULL AUTO_INCREMENT,
  `region_country` int(11) DEFAULT NULL,
  PRIMARY KEY (`region_id`),
  KEY `FK_ngn_region_ngn_country_country_id` (`region_country`),
  CONSTRAINT `FK_ngn_region_id` FOREIGN KEY (`region_country`) REFERENCES `ngn_country` (`country_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_region`
--


--
-- Table structure for table `ngn_region_language`
--

CREATE TABLE `ngn_region_language` (
  `region_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `language_name` varchar(100) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  PRIMARY KEY (`region_id`,`language_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `ngn_region_language_ibfk_1` FOREIGN KEY (`region_id`) REFERENCES `ngn_region` (`region_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_region_language`
--


--
-- Table structure for table `ngn_reservation`
--

CREATE TABLE `ngn_reservation` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_order` int(11) NOT NULL,
  `news_type` int(11) NOT NULL,
  `news_owner` int(11) NOT NULL DEFAULT 0,
  `news_createdate` datetime DEFAULT NULL,
  `news_showdate` datetime DEFAULT NULL,
  `news_hidedate` datetime DEFAULT NULL,
  `news_removedate` datetime NOT NULL,
  `news_hide` tinyint(4) NOT NULL DEFAULT 0,
  `news_editdate` datetime DEFAULT NULL,
  `news_category` int(11) NOT NULL DEFAULT 0,
  `news_photo1` varchar(100) NOT NULL DEFAULT '',
  `news_photo2` varchar(100) NOT NULL DEFAULT '',
  `news_photo_language1` int(11) NOT NULL DEFAULT 0,
  `news_photo_language2` int(11) NOT NULL DEFAULT 0,
  `news_enable` int(11) NOT NULL DEFAULT 0,
  `news_source` varchar(200) NOT NULL DEFAULT '',
  `news_source_url` varchar(200) NOT NULL DEFAULT '',
  `news_viewed` int(11) NOT NULL DEFAULT 0,
  `news_template` int(11) NOT NULL,
  PRIMARY KEY (`news_id`),
  KEY `news_category` (`news_category`),
  KEY `news_enable` (`news_enable`),
  KEY `news_hide` (`news_hide`),
  KEY `news_template` (`news_template`),
  KEY `news_removedate` (`news_removedate`),
  KEY `news_createdate` (`news_createdate`),
  KEY `news_editdate` (`news_editdate`),
  KEY `news_hidedate` (`news_hidedate`),
  KEY `news_showdate` (`news_showdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation`
--


--
-- Table structure for table `ngn_reservation_atribute`
--

CREATE TABLE `ngn_reservation_atribute` (
  `atribute_id` int(11) NOT NULL AUTO_INCREMENT,
  `atribute_type` int(11) DEFAULT NULL,
  `atribute_link` int(11) DEFAULT NULL,
  `atribute_color` varchar(10) NOT NULL,
  `atribute_font` varchar(10) NOT NULL,
  `atribute_condition` varchar(200) NOT NULL,
  `atribute_default` varchar(200) NOT NULL,
  `atribute_priority` int(11) NOT NULL,
  `atribute_required` int(11) DEFAULT NULL,
  `atribute_var` varchar(50) DEFAULT NULL,
  `atribute_format` varchar(50) NOT NULL,
  `atribute_prefix` varchar(100) NOT NULL,
  `atribute_postfix` varchar(100) NOT NULL,
  `atribute_language` tinyint(1) NOT NULL DEFAULT 0,
  `atribute_editdate` datetime NOT NULL,
  PRIMARY KEY (`atribute_id`),
  KEY `atribute_var` (`atribute_var`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute`
--

INSERT INTO `ngn_reservation_atribute` VALUES (1,0,NULL,'','','','',0,0,'color','','','',0,'0000-00-00 00:00:00'),(2,0,NULL,'','','','',0,0,'emails','','','',0,'0000-00-00 00:00:00'),(3,1,NULL,'','','','',1,0,'invoice_id','','','',0,'0000-00-00 00:00:00'),(4,5,NULL,'','','','',1,0,'payment','','','',0,'0000-00-00 00:00:00'),(5,5,NULL,'','','','',1,0,'language','','','',0,'0000-00-00 00:00:00'),(6,1,NULL,'','','','',1,0,'attendant','','','',0,'0000-00-00 00:00:00'),(7,2,NULL,'','','VISITOR_ATTENDANT','',1,0,'attendant_price','','','',0,'0000-00-00 00:00:00'),(8,1,NULL,'','','','',1,0,'adult','','','',0,'0000-00-00 00:00:00'),(9,2,NULL,'','','VISITOR_ADULT','',1,0,'adult_price','','','',0,'0000-00-00 00:00:00'),(10,1,NULL,'','','','',1,0,'children','','','',0,'0000-00-00 00:00:00'),(11,2,NULL,'','','VISITOR_CHILD','',1,0,'children_price','','','',0,'0000-00-00 00:00:00'),(12,2,NULL,'','','Vodenje','',1,0,'guiding_price','','','',0,'0000-00-00 00:00:00'),(13,2,NULL,'','','Najem','',1,0,'room_price','','','',0,'0000-00-00 00:00:00'),(14,2,NULL,'','','Tematski','',1,0,'package_price','','','',0,'0000-00-00 00:00:00'),(15,0,NULL,'','','','',1,0,'email','','','',0,'0000-00-00 00:00:00'),(16,8,NULL,'','','','',1,0,'approved','','','',0,'0000-00-00 00:00:00'),(17,8,NULL,'','','','',1,0,'finished','','','',0,'0000-00-00 00:00:00'),(18,1,NULL,'','','','',1,0,'added','','','',0,'0000-00-00 00:00:00'),(19,1,NULL,'','','','',1,0,'last_edit','','','',0,'0000-00-00 00:00:00'),(20,0,NULL,'','','','',1,0,'order_form','','','',0,'0000-00-00 00:00:00'),(21,5,NULL,'#ffffff','','','',1,0,'reservation_color','','','',0,'0000-00-00 00:00:00'),(22,3,NULL,'','','','',1,0,'program_end','','','',0,'2022-09-07 15:41:06');

--
-- Table structure for table `ngn_reservation_atribute_display`
--

CREATE TABLE `ngn_reservation_atribute_display` (
  `atribute_id` int(11) NOT NULL,
  `display_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`atribute_id`),
  KEY `display_id_idx` (`display_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_display`
--


--
-- Table structure for table `ngn_reservation_atribute_display_values`
--

CREATE TABLE `ngn_reservation_atribute_display_values` (
  `display_id` int(11) NOT NULL,
  PRIMARY KEY (`display_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_display_values`
--


--
-- Table structure for table `ngn_reservation_atribute_display_values_language`
--

CREATE TABLE `ngn_reservation_atribute_display_values_language` (
  `display_id` int(11) NOT NULL,
  `language_id` int(11) DEFAULT NULL,
  `language_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`display_id`),
  KEY `language_id_idx` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_display_values_language`
--


--
-- Table structure for table `ngn_reservation_atribute_language`
--

CREATE TABLE `ngn_reservation_atribute_language` (
  `atribute_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`atribute_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_language`
--

INSERT INTO `ngn_reservation_atribute_language` VALUES (1,1,'0000-00-00 00:00:00',0,1,'Barva','','','','',''),(2,1,'0000-00-00 00:00:00',0,1,'Obveščanje preko e-mail','','','','',''),(2,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(3,1,'0000-00-00 00:00:00',0,1,'Invoice id','','','','',''),(3,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(4,1,'0000-00-00 00:00:00',0,1,'Način plačila','','','','',''),(4,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(5,1,'0000-00-00 00:00:00',0,1,'Jezik','','','','',''),(5,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(6,1,'0000-00-00 00:00:00',0,1,'Št. spremljevalcev','','','','',''),(6,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(7,1,'0000-00-00 00:00:00',0,1,'Cena spremljevalec','','','','',''),(7,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(8,1,'0000-00-00 00:00:00',0,1,'Št. odraslih','','','','',''),(8,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(9,1,'0000-00-00 00:00:00',0,1,'Cena odrasli','','','','',''),(9,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(10,1,'0000-00-00 00:00:00',0,1,'Št. otrok','','','','',''),(10,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(11,1,'0000-00-00 00:00:00',0,1,'Cena otrok','','','','',''),(11,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(12,1,'0000-00-00 00:00:00',0,1,'Vodenje','','','','',''),(12,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(13,1,'0000-00-00 00:00:00',0,1,'Najem sobe','','','','',''),(13,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(14,1,'0000-00-00 00:00:00',0,1,'Izbrani paket','','','','',''),(14,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(15,1,'0000-00-00 00:00:00',0,1,'E-mail kontakta','','','','',''),(15,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(16,1,'0000-00-00 00:00:00',0,1,'Potrjen','','','','',''),(16,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(17,1,'0000-00-00 00:00:00',0,1,'Zaključen','','','','',''),(17,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(18,1,'0000-00-00 00:00:00',0,1,'Dodal','','','','',''),(18,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(19,1,'0000-00-00 00:00:00',0,1,'Zadnji spreminjal','','','','',''),(19,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(20,1,'0000-00-00 00:00:00',0,1,'Št. naročilnice','','','','',''),(20,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(21,1,'2020-07-10 11:15:11',0,1,'Barva rezervacije','','','','',''),(21,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(22,1,'2022-09-07 15:41:06',0,1,'Datum zaključka','','','','',''),(22,2,'0000-00-00 00:00:00',0,0,'','','','','','');

--
-- Table structure for table `ngn_reservation_atribute_links`
--

CREATE TABLE `ngn_reservation_atribute_links` (
  `atribute_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `link_date` datetime NOT NULL,
  PRIMARY KEY (`atribute_id`,`link_id`),
  KEY `atribute_id_idx` (`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_links`
--


--
-- Table structure for table `ngn_reservation_atribute_values`
--

CREATE TABLE `ngn_reservation_atribute_values` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT,
  `atribute_id` int(11) NOT NULL,
  `value_same` int(11) NOT NULL,
  `value_value` varchar(50) DEFAULT NULL,
  `value_photo` varchar(100) NOT NULL,
  `value_order` int(11) NOT NULL,
  PRIMARY KEY (`value_id`,`atribute_id`),
  KEY `atribute_id` (`atribute_id`),
  KEY `value_order` (`value_order`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_values`
--

INSERT INTO `ngn_reservation_atribute_values` VALUES (1,4,1,'','',0),(2,4,1,'','',0),(3,4,1,'','',0),(4,4,1,'','',0),(5,4,1,'BANKTRANSFER','',0),(6,4,1,'','',0),(7,5,1,'','',0),(8,5,1,'','',0),(9,21,0,'#ff0000','',0),(10,21,0,'#f4ec0d','',0),(11,21,0,'#04dd04','',0),(12,21,0,'#00dfff','',0);

--
-- Table structure for table `ngn_reservation_atribute_values_language`
--

CREATE TABLE `ngn_reservation_atribute_values_language` (
  `value_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`value_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_atribute_values_language`
--

INSERT INTO `ngn_reservation_atribute_values_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Na licu mesta',NULL,NULL,NULL,'na-licu-mesta',''),(1,2,'0000-00-00 00:00:00',0,0,'Na licu mesta',NULL,NULL,NULL,'na-licu-mesta',''),(2,1,'0000-00-00 00:00:00',0,0,'Naročilnica',NULL,NULL,NULL,'narocilnica',''),(2,2,'0000-00-00 00:00:00',0,0,'Naročilnica',NULL,NULL,NULL,'narocilnica',''),(3,1,'0000-00-00 00:00:00',0,0,'Voucher',NULL,NULL,NULL,'voucher',''),(3,2,'0000-00-00 00:00:00',0,0,'Voucher',NULL,NULL,NULL,'voucher',''),(4,1,'0000-00-00 00:00:00',0,0,'Ljubljana card',NULL,NULL,NULL,'ljubljana-card',''),(4,2,'0000-00-00 00:00:00',0,0,'Ljubljana card',NULL,NULL,NULL,'ljubljana-card',''),(5,1,'0000-00-00 00:00:00',0,0,'TRR',NULL,NULL,NULL,'trr',''),(5,2,'0000-00-00 00:00:00',0,0,'TRR',NULL,NULL,NULL,'trr',''),(6,1,'0000-00-00 00:00:00',0,0,'Predračun',NULL,NULL,NULL,'predracun',''),(6,2,'0000-00-00 00:00:00',0,0,'Predračun',NULL,NULL,NULL,'predracun',''),(7,1,'0000-00-00 00:00:00',0,0,'SI',NULL,NULL,NULL,'si',''),(7,2,'0000-00-00 00:00:00',0,0,'SI',NULL,NULL,NULL,'si',''),(8,1,'0000-00-00 00:00:00',0,0,'EN',NULL,NULL,NULL,'en',''),(8,2,'0000-00-00 00:00:00',0,0,'EN',NULL,NULL,NULL,'en',''),(9,1,'2020-07-10 11:15:11',0,0,'Rdeča',NULL,NULL,NULL,'rdeca',''),(9,2,'2020-07-10 11:15:11',0,0,'Red',NULL,NULL,NULL,'red',''),(10,1,'2020-07-10 11:15:11',0,0,'Rumena',NULL,NULL,NULL,'rumena',''),(10,2,'2020-07-10 11:15:11',0,0,'Yellow',NULL,NULL,NULL,'yellow',''),(11,1,'2020-07-10 11:15:11',0,0,'Zelena',NULL,NULL,NULL,'zelena',''),(11,2,'2020-07-10 11:15:11',0,0,'Green',NULL,NULL,NULL,'green',''),(12,1,'2020-07-10 11:15:11',0,0,'Modra',NULL,NULL,NULL,'modra',''),(12,2,'2020-07-10 11:15:11',0,0,'Blue',NULL,NULL,NULL,'blue','');

--
-- Table structure for table `ngn_reservation_categories`
--

CREATE TABLE `ngn_reservation_categories` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`,`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_categories`
--


--
-- Table structure for table `ngn_reservation_category`
--

CREATE TABLE `ngn_reservation_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_enable` int(11) DEFAULT NULL,
  `category_createdate` datetime DEFAULT NULL,
  `category_showdate` datetime DEFAULT NULL,
  `category_hidedate` datetime DEFAULT NULL,
  `category_hide` tinyint(1) NOT NULL,
  `category_editdate` datetime DEFAULT NULL,
  `category_position` int(11) DEFAULT NULL,
  `category_type` int(11) NOT NULL,
  `category_parent` int(11) DEFAULT NULL,
  `category_photo` int(11) DEFAULT NULL,
  `category_restriction` int(11) NOT NULL,
  `category_template` int(11) NOT NULL,
  `category_template_news` int(11) NOT NULL,
  `category_source` varchar(200) NOT NULL,
  `category_source_url` varchar(200) NOT NULL,
  `category_photo2` int(11) DEFAULT NULL,
  `category_photo_language1` int(11) NOT NULL,
  `category_photo_language2` int(11) NOT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_enable` (`category_enable`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`),
  KEY `category_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category`
--

INSERT INTO `ngn_reservation_category` VALUES (9,1,'2016-09-23 10:54:03',NULL,NULL,0,'2019-05-31 10:49:28',0,0,0,0,1,0,0,'','',NULL,0,0),(15,1,'2019-05-30 11:35:08',NULL,NULL,0,'2019-05-31 09:08:04',0,0,9,0,1,0,0,'','',NULL,0,0),(16,1,'2019-05-30 11:35:33',NULL,NULL,0,'2019-05-31 09:09:53',0,0,9,0,1,0,0,'','',NULL,0,0),(17,1,'2019-05-30 11:43:04',NULL,NULL,0,'2019-05-31 09:10:01',0,0,9,0,1,0,0,'','',NULL,0,0),(18,1,'2019-05-30 11:43:12',NULL,NULL,0,'2019-05-31 09:10:06',0,0,9,0,1,0,0,'','',NULL,0,0),(19,1,'2019-05-30 11:43:25',NULL,NULL,0,'2019-07-25 12:38:48',0,0,9,0,1,0,0,'','',NULL,0,0),(20,1,'2019-05-30 11:43:36',NULL,NULL,0,'2019-05-31 09:10:16',0,0,9,0,1,0,0,'','',NULL,0,0);

--
-- Table structure for table `ngn_reservation_category_file`
--

CREATE TABLE `ngn_reservation_category_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_file`
--


--
-- Table structure for table `ngn_reservation_category_files`
--

CREATE TABLE `ngn_reservation_category_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `category_id` (`category_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`),
  CONSTRAINT `ngn_reservation_category_files_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_reservation_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_files`
--


--
-- Table structure for table `ngn_reservation_category_files_language`
--

CREATE TABLE `ngn_reservation_category_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_category_files_languageibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_reservation_category_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_files_language`
--


--
-- Table structure for table `ngn_reservation_category_groups`
--

CREATE TABLE `ngn_reservation_category_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_id_2` (`category_id`,`group_id`),
  KEY `group_id` (`group_id`),
  KEY `category_id` (`category_id`),
  KEY `position` (`position`),
  CONSTRAINT `ngn_reservation_category_groups_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_reservation_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_reservation_category_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `ngn_reservation_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_groups`
--

INSERT INTO `ngn_reservation_category_groups` VALUES (28,9,1,0,1,1),(29,9,3,1,0,1),(34,15,1,0,1,1),(35,15,3,1,0,1),(36,16,1,0,1,1),(37,16,3,1,0,1),(38,17,1,0,1,1),(39,17,3,1,0,1),(40,18,1,0,1,1),(41,18,3,1,0,1),(42,19,1,0,1,1),(43,19,3,1,0,1),(44,20,1,0,1,1),(45,20,3,1,0,1),(46,15,4,2,1,0),(47,9,4,2,1,0),(48,16,4,2,1,0),(49,17,4,2,1,0),(50,18,4,2,1,0),(51,19,4,2,1,0),(52,20,4,2,1,0),(53,15,5,3,1,0),(54,18,5,3,1,0),(55,16,5,3,1,0),(56,17,5,3,1,0),(57,19,5,3,1,0),(58,20,5,3,1,0),(59,15,6,4,1,0),(60,16,6,4,1,0),(61,17,6,4,1,0),(62,18,6,4,1,0),(63,19,6,4,1,0),(64,20,6,4,1,0),(65,9,6,4,1,0),(66,9,5,3,1,0);

--
-- Table structure for table `ngn_reservation_category_groups_atribute`
--

CREATE TABLE `ngn_reservation_category_groups_atribute` (
  `cgid` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL DEFAULT 0,
  `valueFloat` double NOT NULL DEFAULT 0,
  `valueText` text NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `gaid` (`gaid`),
  KEY `cgid` (`cgid`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_groups_atribute`
--

INSERT INTO `ngn_reservation_category_groups_atribute` VALUES (1,1,1,0,0,'#ff0000'),(2,1,1,0,0,'#0000ff'),(3,2,1,0,0,'#ff0000'),(4,2,1,0,0,'#000000'),(7,5,1,0,0,'matevz@ngn.si;miha@ngn.si'),(8,1,1,0,0,'#826d6d'),(9,5,1,0,0,''),(22,1,1,0,0,''),(23,5,1,0,0,''),(24,1,1,0,0,'#5156cc'),(25,5,1,0,0,''),(26,1,1,0,0,'#57e554'),(27,5,1,0,0,''),(28,1,1,0,0,''),(29,5,1,0,0,''),(30,1,1,0,0,'#ff0000'),(31,5,1,0,0,''),(32,1,1,0,0,'#57e554'),(33,5,1,0,0,''),(34,1,1,0,0,'#3b9c3e'),(35,5,1,0,0,''),(36,1,1,0,0,'#5a62ab'),(37,5,1,0,0,''),(38,1,1,0,0,'#4fb9c7'),(39,5,1,0,0,''),(40,1,1,0,0,'#ff0000'),(41,5,1,0,0,''),(42,1,1,0,0,'#ffd600'),(43,5,1,0,0,''),(44,1,1,0,0,'#aa20ad'),(45,5,1,0,0,''),(47,6,1,0,0,''),(47,7,1,0,0,''),(47,8,1,0,0,''),(47,9,1,0,0,''),(47,10,1,0,0,''),(47,11,1,0,0,''),(47,12,1,0,0,''),(47,13,1,0,0,''),(47,14,1,0,0,''),(47,15,1,0,0,''),(47,16,1,0,0,''),(47,17,1,0,0,'');

--
-- Table structure for table `ngn_reservation_category_groups_atribute_multi`
--

CREATE TABLE `ngn_reservation_category_groups_atribute_multi` (
  `cgid` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_groups_atribute_multi`
--


--
-- Table structure for table `ngn_reservation_category_language`
--

CREATE TABLE `ngn_reservation_category_language` (
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `photo1` int(11) NOT NULL,
  `photo2` int(11) NOT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  `language_photo2` varchar(100) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`category_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  FULLTEXT KEY `language_html` (`language_html`),
  CONSTRAINT `ngn_reservation_category_language_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_reservation_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_language`
--

INSERT INTO `ngn_reservation_category_language` VALUES (9,1,'0000-00-00 00:00:00',1,1,'Obiski','','','','obiski',0,0,'','',''),(9,2,'0000-00-00 00:00:00',0,0,'','','','','',0,0,'','',''),(9,3,'0000-00-00 00:00:00',0,0,'','','','','',0,0,'','',''),(9,5,'0000-00-00 00:00:00',0,0,'','','','','',0,0,'','',''),(15,1,'0000-00-00 00:00:00',0,1,'Rojstni dan','','','','rojstni-dan',0,0,'','',''),(15,2,'0000-00-00 00:00:00',0,0,'','','','','',0,0,'','',''),(16,1,'0000-00-00 00:00:00',0,0,'Osnovne šole','','','','osnovne-sole',0,0,'','',''),(17,1,'0000-00-00 00:00:00',0,0,'Srednje šole','','','','srednje-sole',0,0,'','',''),(18,1,'0000-00-00 00:00:00',0,0,'Podjetje','','','','podjetje',0,0,'','',''),(19,1,'0000-00-00 00:00:00',0,0,'Fizična oseba','','','','fizicna-oseba',0,0,'','',''),(20,1,'0000-00-00 00:00:00',0,0,'Ostalo','','','','ostalo',0,0,'','','');

--
-- Table structure for table `ngn_reservation_category_links`
--

CREATE TABLE `ngn_reservation_category_links` (
  `category_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `category_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`link_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `category_position` (`category_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_links`
--


--
-- Table structure for table `ngn_reservation_category_multi`
--

CREATE TABLE `ngn_reservation_category_multi` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`,`category_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `ngn_reservation_category_multi_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_reservation_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_multi`
--


--
-- Table structure for table `ngn_reservation_category_pages`
--

CREATE TABLE `ngn_reservation_category_pages` (
  `category_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `category_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`link_id`,`language_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `category_position` (`category_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_pages`
--


--
-- Table structure for table `ngn_reservation_category_photo`
--

CREATE TABLE `ngn_reservation_category_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `category_id` (`category_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`),
  CONSTRAINT `ngn_reservation_category_photo_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_reservation_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_photo`
--


--
-- Table structure for table `ngn_reservation_category_photo_gallery`
--

CREATE TABLE `ngn_reservation_category_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`category_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_photo_gallery`
--


--
-- Table structure for table `ngn_reservation_category_photo_gallery_language`
--

CREATE TABLE `ngn_reservation_category_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`category_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_photo_gallery_language`
--


--
-- Table structure for table `ngn_reservation_category_photo_language`
--

CREATE TABLE `ngn_reservation_category_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_category_photo_language_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `ngn_reservation_category_photo` (`photo_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_photo_language`
--


--
-- Table structure for table `ngn_reservation_category_roles`
--

CREATE TABLE `ngn_reservation_category_roles` (
  `role_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `childs` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`role_id`,`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_roles`
--


--
-- Table structure for table `ngn_reservation_category_videos`
--

CREATE TABLE `ngn_reservation_category_videos` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `file_photo` varchar(200) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  PRIMARY KEY (`file_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_videos`
--


--
-- Table structure for table `ngn_reservation_category_videos_language`
--

CREATE TABLE `ngn_reservation_category_videos_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `enable` int(11) NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_category_videos_language`
--


--
-- Table structure for table `ngn_reservation_comments`
--

CREATE TABLE `ngn_reservation_comments` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  `user_ip` varchar(60) NOT NULL,
  `date` datetime NOT NULL,
  `votes` int(11) NOT NULL,
  `reported` int(11) NOT NULL,
  `enable` int(11) NOT NULL DEFAULT 1,
  `owner_id` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`),
  KEY `news_id` (`parent_id`),
  KEY `user_id` (`user_id`),
  KEY `category_id` (`category_id`),
  KEY `owner_id` (`owner_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments`
--


--
-- Table structure for table `ngn_reservation_comments_admin`
--

CREATE TABLE `ngn_reservation_comments_admin` (
  `comment_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`,`role_id`),
  KEY `role_id` (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments_admin`
--


--
-- Table structure for table `ngn_reservation_comments_files`
--

CREATE TABLE `ngn_reservation_comments_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `comment_id` (`comment_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments_files`
--


--
-- Table structure for table `ngn_reservation_comments_files_language`
--

CREATE TABLE `ngn_reservation_comments_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_comments_files_language_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_reservation_comments_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments_files_language`
--


--
-- Table structure for table `ngn_reservation_comments_language`
--

CREATE TABLE `ngn_reservation_comments_language` (
  `comment_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`comment_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_comments_language_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_reservation_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments_language`
--


--
-- Table structure for table `ngn_reservation_comments_votes`
--

CREATE TABLE `ngn_reservation_comments_votes` (
  `comment_id` int(11) NOT NULL,
  `vote_date` datetime DEFAULT NULL,
  `vote_ip` varchar(50) NOT NULL,
  `vote_value` int(11) NOT NULL,
  PRIMARY KEY (`comment_id`,`vote_ip`),
  CONSTRAINT `ngn_reservation_comments_votes_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_reservation_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_comments_votes`
--


--
-- Table structure for table `ngn_reservation_custom_values`
--

CREATE TABLE `ngn_reservation_custom_values` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueAutomatic` int(11) NOT NULL DEFAULT 0,
  `valueInt` int(11) NOT NULL,
  `valueFloat` double NOT NULL,
  `valueText` text NOT NULL,
  PRIMARY KEY (`news_id`,`category_id`,`gaid`,`language_id`),
  KEY `category_id` (`category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_custom_values`
--


--
-- Table structure for table `ngn_reservation_custom_values_multi`
--

CREATE TABLE `ngn_reservation_custom_values_multi` (
  `news_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`category_id`,`gaid`,`language_id`,`valueInt`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_custom_values_multi`
--


--
-- Table structure for table `ngn_reservation_file`
--

CREATE TABLE `ngn_reservation_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_file`
--


--
-- Table structure for table `ngn_reservation_files`
--

CREATE TABLE `ngn_reservation_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `news_id` (`news_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_files`
--


--
-- Table structure for table `ngn_reservation_files_groups`
--

CREATE TABLE `ngn_reservation_files_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_photo` varchar(50) NOT NULL,
  `group_enable` int(11) NOT NULL DEFAULT 0,
  `group_order` int(11) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_files_groups`
--


--
-- Table structure for table `ngn_reservation_files_groups_language`
--

CREATE TABLE `ngn_reservation_files_groups_language` (
  `group_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`group_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_files_groups_language`
--


--
-- Table structure for table `ngn_reservation_files_language`
--

CREATE TABLE `ngn_reservation_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_files_language_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_reservation_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_files_language`
--


--
-- Table structure for table `ngn_reservation_gallery`
--

CREATE TABLE `ngn_reservation_gallery` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL,
  `gallery_template` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_gallery`
--


--
-- Table structure for table `ngn_reservation_gallery_photo`
--

CREATE TABLE `ngn_reservation_gallery_photo` (
  `gallery_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`,`photo_id`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_gallery_photo`
--


--
-- Table structure for table `ngn_reservation_groups`
--

CREATE TABLE `ngn_reservation_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_var` varchar(50) NOT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_groups`
--

INSERT INTO `ngn_reservation_groups` VALUES (1,''),(3,''),(4,'invoice'),(5,'extra_data'),(6,'hidden');

--
-- Table structure for table `ngn_reservation_groups_atribute`
--

CREATE TABLE `ngn_reservation_groups_atribute` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `atribute_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `atribute_id` (`atribute_id`),
  CONSTRAINT `ngn_reservation_groups_atribute_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `ngn_reservation_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_groups_atribute`
--

INSERT INTO `ngn_reservation_groups_atribute` VALUES (1,1,1,0),(5,3,2,0),(6,4,3,0),(7,4,5,1),(8,4,4,2),(9,4,6,4),(10,4,7,3),(11,4,8,6),(12,4,9,5),(13,4,10,8),(14,4,11,7),(15,4,12,10),(16,4,13,11),(17,4,14,9),(20,5,15,0),(21,5,17,1),(22,5,16,2),(23,6,19,2),(24,6,18,1),(26,6,20,0),(27,1,21,1);

--
-- Table structure for table `ngn_reservation_groups_language`
--

CREATE TABLE `ngn_reservation_groups_language` (
  `group_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`group_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_groups_language`
--

INSERT INTO `ngn_reservation_groups_language` VALUES (1,1,'0000-00-00 00:00:00',0,1,'Barva','',NULL,NULL,NULL,''),(3,1,'0000-00-00 00:00:00',0,1,'Obveščanje sprememb','',NULL,NULL,NULL,''),(4,1,'0000-00-00 00:00:00',0,1,'Invoice data','',NULL,NULL,NULL,''),(4,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(5,1,'0000-00-00 00:00:00',0,1,'Dodatni podatki','',NULL,NULL,NULL,''),(5,2,'0000-00-00 00:00:00',0,0,'','','','','',''),(6,1,'0000-00-00 00:00:00',0,1,'Skriti atributi','',NULL,NULL,NULL,''),(6,2,'0000-00-00 00:00:00',0,0,'','','','','','');

--
-- Table structure for table `ngn_reservation_item`
--

CREATE TABLE `ngn_reservation_item` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_category` int(11) NOT NULL,
  `news_id` int(11) NOT NULL DEFAULT 0,
  `item_order` int(11) NOT NULL,
  `item_createdate` datetime DEFAULT NULL,
  `item_showdate` datetime DEFAULT NULL,
  `item_editdate` datetime NOT NULL,
  `item_hidedate` datetime NOT NULL,
  `item_hide` tinyint(1) NOT NULL,
  `item_enable` int(11) NOT NULL DEFAULT 0,
  `item_photo1` varchar(100) NOT NULL,
  `item_photo2` varchar(100) NOT NULL,
  `item_viewed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`item_id`),
  KEY `item_category` (`item_category`),
  KEY `news_id` (`news_id`),
  KEY `item_enable` (`item_enable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item`
--


--
-- Table structure for table `ngn_reservation_item_category`
--

CREATE TABLE `ngn_reservation_item_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT,
  `category_enable` int(11) DEFAULT NULL,
  `category_createdate` datetime DEFAULT NULL,
  `category_showdate` datetime DEFAULT NULL,
  `category_hidedate` datetime DEFAULT NULL,
  `category_hide` tinyint(1) NOT NULL,
  `category_editdate` datetime DEFAULT NULL,
  `category_position` int(11) DEFAULT NULL,
  `category_parent` int(11) DEFAULT NULL,
  `category_photo` int(11) DEFAULT NULL,
  `category_template` int(11) NOT NULL,
  `category_template_news` int(11) NOT NULL,
  `category_photo2` int(11) DEFAULT NULL,
  PRIMARY KEY (`category_id`),
  KEY `category_enable` (`category_enable`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`),
  KEY `category_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_category`
--


--
-- Table structure for table `ngn_reservation_item_category_language`
--

CREATE TABLE `ngn_reservation_item_category_language` (
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`category_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_category_language`
--


--
-- Table structure for table `ngn_reservation_item_custom_values`
--

CREATE TABLE `ngn_reservation_item_custom_values` (
  `item_id` int(11) NOT NULL,
  `item_category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueAutomatic` int(11) NOT NULL DEFAULT 0,
  `valueInt` int(11) NOT NULL,
  `valueFloat` double NOT NULL,
  `valueText` text NOT NULL,
  PRIMARY KEY (`item_id`,`item_category_id`,`gaid`,`language_id`),
  KEY `item_category_id` (`item_category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`),
  CONSTRAINT `ngn_reservation_item_custom_values_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ngn_reservation_item_variations` (`variations_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_custom_values`
--


--
-- Table structure for table `ngn_reservation_item_custom_values_multi`
--

CREATE TABLE `ngn_reservation_item_custom_values_multi` (
  `item_id` int(11) NOT NULL,
  `item_category_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`item_category_id`,`gaid`,`language_id`,`valueInt`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_custom_values_multi`
--


--
-- Table structure for table `ngn_reservation_item_file`
--

CREATE TABLE `ngn_reservation_item_file` (
  `type_id` int(11) NOT NULL AUTO_INCREMENT,
  `type_name` varchar(200) NOT NULL DEFAULT '',
  `type_extension` varchar(200) NOT NULL DEFAULT '',
  `type_type` varchar(200) NOT NULL DEFAULT '',
  `type_enable` int(11) NOT NULL DEFAULT 0,
  `type_photo` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_file`
--


--
-- Table structure for table `ngn_reservation_item_files`
--

CREATE TABLE `ngn_reservation_item_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT 0,
  `file_type` int(11) NOT NULL DEFAULT 0,
  `file_group` int(11) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_list` int(11) NOT NULL DEFAULT 1,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  `file_createdate` datetime NOT NULL,
  `file_showdate` datetime NOT NULL,
  `file_hidedate` datetime NOT NULL,
  `file_hide` smallint(1) NOT NULL,
  `file_owner` int(11) NOT NULL,
  `file_order` int(11) NOT NULL,
  PRIMARY KEY (`file_id`),
  KEY `item_id` (`item_id`),
  KEY `file_type` (`file_type`),
  KEY `file_createdate` (`file_createdate`),
  KEY `file_owner` (`file_owner`),
  KEY `file_group` (`file_group`),
  KEY `file_showdate` (`file_showdate`),
  KEY `file_hidedate` (`file_hidedate`),
  KEY `file_hide` (`file_hide`),
  KEY `file_order` (`file_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_files`
--


--
-- Table structure for table `ngn_reservation_item_files_language`
--

CREATE TABLE `ngn_reservation_item_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_files_language`
--


--
-- Table structure for table `ngn_reservation_item_groups`
--

CREATE TABLE `ngn_reservation_item_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item_category_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `item_category_id` (`item_category_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_groups`
--


--
-- Table structure for table `ngn_reservation_item_groups_atribute`
--

CREATE TABLE `ngn_reservation_item_groups_atribute` (
  `cgid` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL DEFAULT 0,
  `valueFloat` double NOT NULL DEFAULT 0,
  `valueText` text NOT NULL,
  PRIMARY KEY (`cgid`,`gaid`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `gaid` (`gaid`),
  KEY `cgid` (`cgid`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_groups_atribute`
--


--
-- Table structure for table `ngn_reservation_item_language`
--

CREATE TABLE `ngn_reservation_item_language` (
  `item_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo1` varchar(100) NOT NULL,
  `language_photo2` varchar(100) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`item_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  FULLTEXT KEY `language_html` (`language_html`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_language`
--


--
-- Table structure for table `ngn_reservation_item_photo`
--

CREATE TABLE `ngn_reservation_item_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `item_id` (`item_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_photo`
--


--
-- Table structure for table `ngn_reservation_item_photo_gallery`
--

CREATE TABLE `ngn_reservation_item_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_photo_gallery`
--


--
-- Table structure for table `ngn_reservation_item_photo_gallery_language`
--

CREATE TABLE `ngn_reservation_item_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`item_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_photo_gallery_language`
--


--
-- Table structure for table `ngn_reservation_item_photo_language`
--

CREATE TABLE `ngn_reservation_item_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_photo_language`
--


--
-- Table structure for table `ngn_reservation_item_variations`
--

CREATE TABLE `ngn_reservation_item_variations` (
  `variations_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL,
  `variation_order` int(11) NOT NULL,
  `enable` tinyint(1) NOT NULL,
  PRIMARY KEY (`variations_id`),
  KEY `item_id` (`item_id`),
  KEY `enable` (`enable`),
  CONSTRAINT `ngn_reservation_item_variations_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ngn_reservation_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_variations`
--


--
-- Table structure for table `ngn_reservation_item_variations_language`
--

CREATE TABLE `ngn_reservation_item_variations_language` (
  `variation_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`variation_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_variations_language`
--


--
-- Table structure for table `ngn_reservation_item_videos`
--

CREATE TABLE `ngn_reservation_item_videos` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `item_id` int(11) NOT NULL DEFAULT 0,
  `file_photo` varchar(200) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  PRIMARY KEY (`file_id`),
  KEY `item_id` (`item_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_videos`
--


--
-- Table structure for table `ngn_reservation_item_videos_language`
--

CREATE TABLE `ngn_reservation_item_videos_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `enable` int(11) NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_item_videos_language`
--


--
-- Table structure for table `ngn_reservation_language`
--

CREATE TABLE `ngn_reservation_language` (
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `photo1` int(11) NOT NULL,
  `photo2` int(11) NOT NULL,
  `language_photo1` varchar(200) NOT NULL,
  `language_photo2` varchar(200) NOT NULL,
  `language_html` text NOT NULL,
  PRIMARY KEY (`news_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  KEY `photo1` (`photo1`),
  KEY `photo2` (`photo2`),
  FULLTEXT KEY `language_html` (`language_html`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_language`
--


--
-- Table structure for table `ngn_reservation_links`
--

CREATE TABLE `ngn_reservation_links` (
  `news_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `news_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`link_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `news_position` (`news_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_links`
--


--
-- Table structure for table `ngn_reservation_media`
--

CREATE TABLE `ngn_reservation_media` (
  `gallery_id` int(11) NOT NULL AUTO_INCREMENT,
  `module` varchar(50) NOT NULL,
  `id` int(11) NOT NULL,
  `template` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_media`
--


--
-- Table structure for table `ngn_reservation_media_gallery`
--

CREATE TABLE `ngn_reservation_media_gallery` (
  `gallery_id` int(11) NOT NULL,
  `photo_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`gallery_id`,`photo_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_media_gallery`
--


--
-- Table structure for table `ngn_reservation_pages`
--

CREATE TABLE `ngn_reservation_pages` (
  `news_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `news_position` int(11) NOT NULL DEFAULT 0,
  `link_position` int(11) NOT NULL,
  `link_date` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`link_id`,`language_id`),
  KEY `link_position` (`link_position`),
  KEY `link_id` (`link_id`),
  KEY `news_position` (`news_position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_pages`
--


--
-- Table structure for table `ngn_reservation_photo`
--

CREATE TABLE `ngn_reservation_photo` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) DEFAULT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL DEFAULT 1,
  `photo_photo` varchar(100) DEFAULT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_source` varchar(255) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `news_id` (`news_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_source` (`photo_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo`
--


--
-- Table structure for table `ngn_reservation_photo_gallery`
--

CREATE TABLE `ngn_reservation_photo_gallery` (
  `photo_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `photo_gallery` int(11) NOT NULL,
  `photo_order` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo_gallery`
--


--
-- Table structure for table `ngn_reservation_photo_gallery_language`
--

CREATE TABLE `ngn_reservation_photo_gallery_language` (
  `photo_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`news_id`,`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo_gallery_language`
--


--
-- Table structure for table `ngn_reservation_photo_language`
--

CREATE TABLE `ngn_reservation_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`photo_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_photo_language_id1` FOREIGN KEY (`photo_id`) REFERENCES `ngn_reservation_photo` (`photo_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo_language`
--


--
-- Table structure for table `ngn_reservation_photo_sizes`
--

CREATE TABLE `ngn_reservation_photo_sizes` (
  `photo_id` int(11) NOT NULL,
  `size_id` int(11) NOT NULL,
  `photo_width` int(11) NOT NULL,
  `photo_height` int(11) NOT NULL,
  `photo_photo` varchar(100) NOT NULL,
  `photo_path` varchar(200) NOT NULL,
  PRIMARY KEY (`photo_id`,`size_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo_sizes`
--


--
-- Table structure for table `ngn_reservation_photo_usage`
--

CREATE TABLE `ngn_reservation_photo_usage` (
  `photo_id` int(11) NOT NULL,
  `module_name` varchar(50) NOT NULL,
  `usage_type` varchar(50) NOT NULL,
  `link_id` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`,`module_name`,`usage_type`,`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_photo_usage`
--


--
-- Table structure for table `ngn_reservation_restrictions`
--

CREATE TABLE `ngn_reservation_restrictions` (
  `restrictions_id` int(11) NOT NULL AUTO_INCREMENT,
  `restrictions_name` varchar(100) NOT NULL,
  `restrictions_default` int(11) NOT NULL,
  PRIMARY KEY (`restrictions_id`),
  FULLTEXT KEY `restrictions_name` (`restrictions_name`),
  FULLTEXT KEY `restrictions_name_2` (`restrictions_name`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_restrictions`
--

INSERT INTO `ngn_reservation_restrictions` VALUES (1,'Default',1);

--
-- Table structure for table `ngn_reservation_restrictions_groups`
--

CREATE TABLE `ngn_reservation_restrictions_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `restriction_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `restriction_id_2` (`restriction_id`,`group_id`),
  KEY `group_id` (`group_id`),
  KEY `restriction_id` (`restriction_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_restrictions_groups`
--


--
-- Table structure for table `ngn_reservation_restrictions_settings`
--

CREATE TABLE `ngn_reservation_restrictions_settings` (
  `restriction_id` int(11) NOT NULL,
  `restriction_var` varchar(100) NOT NULL,
  `restriction_value_int` int(11) NOT NULL,
  `restriction_value_text` text NOT NULL,
  `restriction_value_float` float NOT NULL,
  PRIMARY KEY (`restriction_id`,`restriction_var`),
  KEY `restriction_var` (`restriction_var`),
  KEY `restriction_id` (`restriction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_restrictions_settings`
--


--
-- Table structure for table `ngn_reservation_restrictions_settings_multi`
--

CREATE TABLE `ngn_reservation_restrictions_settings_multi` (
  `restriction_id` int(11) NOT NULL,
  `restriction_var` varchar(100) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  PRIMARY KEY (`restriction_id`,`restriction_var`,`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_restrictions_settings_multi`
--


--
-- Table structure for table `ngn_reservation_roles`
--

CREATE TABLE `ngn_reservation_roles` (
  `role_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `news_edit` tinyint(11) NOT NULL DEFAULT 0,
  `news_delete` tinyint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`role_id`,`news_id`),
  KEY `category_id` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_roles`
--


--
-- Table structure for table `ngn_reservation_tags`
--

CREATE TABLE `ngn_reservation_tags` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `tag_createdate` datetime DEFAULT NULL,
  `tag_showdate` datetime DEFAULT NULL,
  `tag_hidedate` datetime DEFAULT NULL,
  `tag_hide` int(11) NOT NULL,
  `tag_editdate` datetime DEFAULT NULL,
  `tag_owner` int(11) NOT NULL,
  `tag_order` int(11) NOT NULL,
  PRIMARY KEY (`tag_id`),
  KEY `tag_hide` (`tag_hide`),
  KEY `tag_order` (`tag_order`),
  KEY `tag_owner` (`tag_owner`),
  KEY `tag_createdate` (`tag_createdate`),
  KEY `tag_editdate` (`tag_editdate`),
  KEY `tag_hidedate` (`tag_hidedate`),
  KEY `tag_showdate` (`tag_showdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_tags`
--


--
-- Table structure for table `ngn_reservation_tags_language`
--

CREATE TABLE `ngn_reservation_tags_language` (
  `tag_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`tag_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_reservation_tags_language_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_reservation_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_tags_language`
--


--
-- Table structure for table `ngn_reservation_tags_links`
--

CREATE TABLE `ngn_reservation_tags_links` (
  `tag_id` int(11) NOT NULL,
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  PRIMARY KEY (`tag_id`,`news_id`,`language_id`),
  KEY `news_id` (`news_id`),
  CONSTRAINT `ngn_reservation_tags_links_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_reservation_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_tags_links`
--


--
-- Table structure for table `ngn_reservation_videos`
--

CREATE TABLE `ngn_reservation_videos` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) NOT NULL DEFAULT 0,
  `file_photo` varchar(200) NOT NULL,
  `file_size` int(11) NOT NULL DEFAULT 0,
  `file_file` varchar(100) NOT NULL DEFAULT '',
  `file_original_name` varchar(200) NOT NULL DEFAULT '0',
  PRIMARY KEY (`file_id`),
  KEY `news_id` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_videos`
--


--
-- Table structure for table `ngn_reservation_videos_language`
--

CREATE TABLE `ngn_reservation_videos_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `enable` int(11) NOT NULL,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`file_id`,`language_id`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservation_videos_language`
--


--
-- Table structure for table `ngn_reservations_delete`
--

CREATE TABLE `ngn_reservations_delete` (
  `invoice_id` int(11) NOT NULL,
  `date_added` datetime NOT NULL,
  `date_timeout` datetime NOT NULL,
  PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_reservations_delete`
--


--
-- Table structure for table `ngn_selling_regions`
--

CREATE TABLE `ngn_selling_regions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `pricing` int(11) NOT NULL,
  `currency` varchar(20) NOT NULL,
  `tax` int(11) NOT NULL,
  `user_address` int(11) NOT NULL,
  `default_language` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_selling_regions`
--

INSERT INTO `ngn_selling_regions` VALUES (1,'slovenia',42,'euro',1,2,0),(2,'eu',42,'euro',1,16632,0),(3,'noneu',48,'euro',10,16633,0),(4,'world',65,'euro',53,16641,0);

--
-- Table structure for table `ngn_selling_regions_countries`
--

CREATE TABLE `ngn_selling_regions_countries` (
  `selling_region` int(11) NOT NULL,
  `country_id` int(11) NOT NULL,
  PRIMARY KEY (`selling_region`,`country_id`),
  KEY `country` (`country_id`),
  CONSTRAINT `ngn_selling_regions_countries_ibfk_1` FOREIGN KEY (`selling_region`) REFERENCES `ngn_selling_regions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_selling_regions_countries_ibfk_2` FOREIGN KEY (`country_id`) REFERENCES `ngn_country` (`country_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_selling_regions_countries`
--

INSERT INTO `ngn_selling_regions_countries` VALUES (1,1),(2,6),(2,7),(2,9),(2,11),(2,12),(2,14),(2,15),(2,18),(2,19),(2,21),(2,23),(2,24),(2,26),(2,27),(2,29),(2,30),(2,31),(2,33),(2,36),(2,37),(2,39),(2,40),(2,41),(2,44),(2,46),(2,47),(3,3),(3,4),(3,8),(3,10),(3,13),(3,17),(3,20),(3,22),(3,25),(3,28),(3,32),(3,34),(3,35),(3,38),(3,43),(3,45),(3,48),(3,49),(3,50),(3,51),(3,52),(3,139),(3,247),(4,2),(4,5),(4,16),(4,42),(4,53),(4,54),(4,57),(4,58),(4,60),(4,61),(4,62),(4,63),(4,64),(4,66),(4,67),(4,69),(4,70),(4,71),(4,72),(4,73),(4,76),(4,77),(4,78),(4,79),(4,80),(4,81),(4,83),(4,84),(4,85),(4,86),(4,87),(4,89),(4,90),(4,91),(4,92),(4,93),(4,94),(4,95),(4,96),(4,97),(4,98),(4,99),(4,100),(4,101),(4,102),(4,103),(4,104),(4,105),(4,106),(4,107),(4,109),(4,110),(4,114),(4,115),(4,116),(4,117),(4,118),(4,119),(4,120),(4,121),(4,123),(4,126),(4,129),(4,130),(4,131),(4,132),(4,133),(4,136),(4,140),(4,228),(4,229),(4,230),(4,231),(4,232),(4,233),(4,234),(4,235),(4,236),(4,238),(4,239),(4,242),(4,243),(4,244),(4,245),(4,248),(4,250),(4,251),(4,252),(4,253),(4,254),(4,255),(4,256),(4,257),(4,258),(4,259),(4,261),(4,262),(4,263),(4,264),(4,268),(4,270),(4,271),(4,272),(4,273),(4,274),(4,276),(4,277),(4,278),(4,279),(4,280),(4,281),(4,282),(4,285),(4,287),(4,288),(4,289),(4,290),(4,291),(4,292),(4,293),(4,295),(4,296),(4,297),(4,298),(4,299),(4,300),(4,301),(4,302),(4,304),(4,305),(4,306),(4,307),(4,308),(4,309),(4,310),(4,311),(4,312),(4,313),(4,316),(4,317),(4,318),(4,321),(4,322),(4,323),(4,324),(4,325),(4,326),(4,327),(4,328),(4,329),(4,331),(4,332),(4,333),(4,335),(4,336),(4,337),(4,338),(4,341),(4,342),(4,343),(4,344),(4,345),(4,347),(4,348),(4,349),(4,350),(4,351),(4,354),(4,355),(4,356),(4,357),(4,358),(4,359),(4,360),(4,361),(4,362),(4,363),(4,364),(4,366),(4,367),(4,368),(4,369),(4,371),(4,374),(4,375),(4,376),(4,377),(4,378),(4,379),(4,380),(4,381),(4,382),(4,383),(4,384),(4,385),(4,386);

--
-- Table structure for table `ngn_selling_regions_language`
--

CREATE TABLE `ngn_selling_regions_language` (
  `selling_region` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `language_name` text NOT NULL,
  PRIMARY KEY (`selling_region`,`language_id`),
  KEY `language_id` (`language_id`),
  CONSTRAINT `ngn_selling_regions_language_ibfk_1` FOREIGN KEY (`selling_region`) REFERENCES `ngn_selling_regions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_selling_regions_language`
--

INSERT INTO `ngn_selling_regions_language` VALUES (1,1,'Slovenija'),(1,2,'Slovenia'),(2,1,'European Union'),(2,2,'European Union'),(3,1,'Other European countries'),(3,2,'Other European countries'),(4,1,'Rest of The World'),(4,2,'Rest of The World');

--
-- Table structure for table `ngn_static`
--

CREATE TABLE `ngn_static` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_order` int(11) NOT NULL,
  `news_type` int(11) NOT NULL,
  `news_owner` int(11) NOT NULL DEFAULT 0,
  `news_createdate` datetime DEFAULT NULL,
  `news_showdate` datetime DEFAULT NULL,
  `news_hidedate` datetime DEFAULT NULL,
  `news_removedate` datetime NOT NULL,
  `news_hide` tinyint(4) NOT NULL DEFAULT 0,
  `news_editdate` datetime DEFAULT NULL,
  `news_category` int(11) NOT NULL DEFAULT 0,
  `news_photo1` varchar(100) NOT NULL DEFAULT '',
  `news_photo2` varchar(100) NOT NULL DEFAULT '',
  `news_photo_language1` int(11) NOT NULL DEFAULT 0,
  `news_photo_language2` int(11) NOT NULL DEFAULT 0,
  `news_enable` int(11) NOT NULL DEFAULT 0,
  `news_source` varchar(200) NOT NULL DEFAULT '',
  `news_source_url` varchar(200) NOT NULL DEFAULT '',
  `news_viewed` int(11) NOT NULL DEFAULT 0,
  `news_template` int(11) NOT NULL,
  PRIMARY KEY (`news_id`),
  KEY `news_category` (`news_category`),
  KEY `news_enable` (`news_enable`),
  KEY `news_hide` (`news_hide`),
  KEY `news_template` (`news_template`),
  KEY `news_removedate` (`news_removedate`),
  KEY `news_createdate` (`news_createdate`),
  KEY `news_editdate` (`news_editdate`),
  KEY `news_hidedate` (`news_hidedate`),
  KEY `news_showdate` (`news_showdate`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_static`
--

INSERT INTO `ngn_static` VALUES (1,10,1,718,'2022-03-09 10:51:00','2022-03-09 10:51:00','2022-03-09 10:52:03','0000-00-00 00:00:00',0,'2023-03-13 13:23:39',8,'','',0,0,1,'','',0,15),(2,20,0,718,'2022-03-10 09:17:00','2022-03-10 09:17:00','2022-03-10 09:17:41','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',9,'','',0,0,1,'','',0,20),(3,30,0,718,'2022-03-10 09:22:00','2022-03-10 09:22:00','2022-03-10 09:22:33','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',9,'','',0,0,1,'','',0,20),(4,40,0,718,'2022-03-11 14:38:00','2022-03-11 14:38:00','2022-03-11 14:38:30','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',12,'12','',0,0,1,'','',0,22),(5,50,0,718,'2022-03-11 15:29:00','2022-03-11 15:29:00','2022-03-11 15:30:09','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',12,'11','',0,0,1,'','',0,22),(6,60,0,718,'2022-03-11 15:35:00','2022-03-11 15:35:00','2022-03-11 15:35:24','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',12,'5','',0,0,1,'','',0,22),(7,70,0,718,'2022-03-17 09:51:00','2022-03-17 09:51:00','2022-03-17 09:51:18','0000-00-00 00:00:00',0,'2022-10-28 13:00:10',7,'','',0,0,1,'','',0,15),(8,80,0,718,'2022-03-22 10:10:00','2022-03-22 10:10:00','2022-03-22 10:10:49','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',20,'','',0,0,1,'','',0,15),(9,90,0,718,'2022-03-25 14:45:00','2022-03-25 14:45:00','2022-03-25 14:45:48','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',2,'','',0,0,1,'','',0,15),(10,100,1,718,'2022-04-15 15:18:00','2022-04-15 15:18:00','2022-04-15 15:20:15','0000-00-00 00:00:00',0,'2022-09-06 14:34:51',32,'15','',0,0,1,'','',0,15),(11,110,0,718,'2022-04-15 15:20:00','2022-04-15 15:20:00','2022-04-15 15:20:39','0000-00-00 00:00:00',0,'2022-09-06 14:32:37',32,'4','',0,0,1,'','',0,17),(12,120,1,719,'2022-06-23 15:05:00','2022-06-23 15:05:00','2022-06-23 15:05:47','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',23,'','',0,0,1,'','',0,15),(13,130,1,719,'2022-06-23 15:07:00','2022-06-23 15:07:00','2022-06-23 15:07:50','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',24,'','',0,0,1,'','',0,15),(14,140,1,719,'2022-06-23 15:09:00','2022-06-23 15:09:00','2022-06-23 15:10:00','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',27,'','',0,0,1,'','',0,15),(15,150,1,719,'2022-06-23 15:25:00','2022-06-23 15:25:00','2022-06-23 15:25:26','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',49,'','',0,0,1,'','',0,15),(16,160,1,719,'2022-06-23 15:28:00','2022-06-23 15:28:00','2022-06-23 15:28:47','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',50,'','',0,0,1,'','',0,15),(17,170,1,719,'2022-06-23 15:32:00','2022-06-23 15:32:00','2022-06-23 15:32:59','0000-00-00 00:00:00',0,'2022-08-25 08:22:01',28,'','',0,0,1,'','',0,15),(18,180,0,718,'2022-07-04 15:45:00','2022-07-04 15:45:00','2022-07-04 15:45:27','2022-07-04 16:04:12',0,'2022-08-18 00:00:00',12,'78','',0,0,1,'','',0,22),(19,190,0,719,'2022-07-08 09:30:00','2022-07-08 09:30:00','2022-07-08 09:30:09','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',51,'','',0,0,1,'','',0,15),(20,200,1,719,'2022-07-08 10:25:00','2022-07-08 10:25:00','2022-07-08 10:25:23','2022-07-08 10:30:21',0,'2022-08-18 00:00:00',52,'','',0,0,0,'','',0,15),(21,210,1,719,'2022-07-08 10:25:00','2022-07-08 10:25:00','2022-07-08 10:25:24','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',52,'','',0,0,1,'','',0,15),(22,220,1,719,'2022-07-08 10:40:00','2022-07-08 10:40:00','2022-07-08 10:41:05','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',26,'','',0,0,1,'','',0,15),(23,230,0,719,'2022-07-08 11:00:00','2022-07-08 11:00:00','2022-07-08 11:00:53','0000-00-00 00:00:00',0,'2022-08-18 00:00:00',53,'','',0,0,1,'','',0,15),(24,240,0,719,'2022-09-30 10:26:00','2022-09-30 10:26:00','2022-09-30 10:26:50','0000-00-00 00:00:00',0,'2022-09-30 10:27:04',66,'','',0,0,1,'','',0,20),(25,250,1,719,'2022-09-30 10:29:00','2022-09-30 10:29:00','2022-09-30 10:29:38','0000-00-00 00:00:00',0,'2023-05-18 22:57:53',31,'','',0,0,0,'','',0,15),(26,260,1,719,'2022-09-30 10:31:00','2022-09-30 10:31:00','2022-09-30 10:31:33','0000-00-00 00:00:00',0,'2022-09-30 11:26:53',33,'','',0,0,1,'','',0,18),(27,270,0,719,'2022-09-30 10:38:00','2022-09-30 10:38:00','2022-09-30 10:38:50','0000-00-00 00:00:00',0,'2022-09-30 10:45:15',5,'','',0,0,1,'','',0,15),(28,280,1,719,'2022-09-30 10:40:00','2022-09-30 10:40:00','2022-09-30 10:40:29','0000-00-00 00:00:00',0,'2022-10-11 10:35:01',6,'','',0,0,1,'','',0,15),(29,290,0,719,'2022-09-30 11:15:00','2022-09-30 11:15:00','2022-09-30 11:15:16','0000-00-00 00:00:00',0,'2022-09-30 11:46:00',4,'143','',0,0,1,'','',0,20),(30,300,1,719,'2022-10-20 08:41:00','2022-10-20 08:41:00','2022-10-20 08:41:51','0000-00-00 00:00:00',0,'2022-11-07 14:46:03',73,'','',0,0,1,'','',0,15),(31,310,1,719,'2022-10-20 08:46:00','2022-10-20 08:46:00','2022-10-20 08:46:34','0000-00-00 00:00:00',0,'2023-02-22 08:27:57',71,'','',0,0,1,'','',0,15),(32,320,1,719,'2022-10-20 08:51:00','2022-10-20 08:51:00','2022-10-20 08:51:19','0000-00-00 00:00:00',0,'2023-02-21 13:42:09',69,'','',0,0,1,'','',0,20),(33,330,1,719,'2022-10-20 08:59:00','2022-10-20 08:59:00','2022-10-20 08:59:28','0000-00-00 00:00:00',0,'2023-02-23 10:54:12',70,'','',0,0,1,'','',0,20),(34,340,1,718,'2022-10-27 13:39:00','2022-10-27 13:39:00','2022-10-27 13:39:54','0000-00-00 00:00:00',0,'2023-02-22 08:27:21',68,'','',0,0,1,'','',0,15),(35,350,1,719,'2022-10-27 15:59:00','2022-10-27 15:59:00','2022-10-27 15:59:59','0000-00-00 00:00:00',0,'2023-02-21 10:38:42',72,'','',0,0,1,'','',0,15),(36,360,0,945,'2023-01-16 08:51:00','2023-01-16 08:51:00','2023-01-16 08:59:14','0000-00-00 00:00:00',0,'2023-03-13 13:34:24',87,'','',0,0,0,'','',0,43),(37,370,1,718,'2023-06-06 14:12:00','2023-06-06 14:12:00','2023-06-06 14:12:30','0000-00-00 00:00:00',0,'2023-06-06 14:13:18',0,'','',0,0,0,'','',0,15);

--
-- Table structure for table `ngn_static_atribute`
--

CREATE TABLE `ngn_static_atribute` (
  `atribute_id` int(11) NOT NULL AUTO_INCREMENT,
  `atribute_type` int(11) DEFAULT NULL,
  `atribute_link` int(11) DEFAULT NULL,
  `atribute_color` varchar(10) NOT NULL,
  `atribute_font` varchar(10) NOT NULL,
  `atribute_condition` varchar(200) NOT NULL,
  `atribute_default` varchar(200) NOT NULL,
  `atribute_priority` int(11) NOT NULL,
  `atribute_required` int(11) DEFAULT NULL,
  `atribute_var` varchar(50) DEFAULT NULL,
  `atribute_format` varchar(50) NOT NULL,
  `atribute_prefix` varchar(100) NOT NULL,
  `atribute_postfix` varchar(100) NOT NULL,
  `atribute_language` tinyint(1) NOT NULL DEFAULT 0,
  `atribute_editdate` datetime NOT NULL,
  PRIMARY KEY (`atribute_id`),
  KEY `atribute_var` (`atribute_var`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_static_atribute`
--

INSERT INTO `ngn_static_atribute` VALUES (1,8,NULL,'','','','',0,0,'hide_in_menu','','','',0,'0000-00-00 00:00:00'),(2,5,NULL,'','','','',1,0,'order','','','',0,'0000-00-00 00:00:00'),(3,5,NULL,'','','','',1,0,'order_type','','','',0,'0000-00-00 00:00:00'),(4,1,NULL,'','','','',0,0,'limit','','','',0,'0000-00-00 00:00:00'),(5,1,NULL,'','','','',0,0,'source','','','',0,'0000-00-00 00:00:00'),(6,8,NULL,'','','','',0,0,'force_static','','','',0,'0000-00-00 00:00:00'),(7,0,NULL,'','','','',1,0,'big_text','','','',1,'0000-00-00 00:00:00'),(8,0,NULL,'','','','',1,0,'small_text','','','',1,'0000-00-00 00:00:00'),(9,7,NULL,'','','','',1,0,'text','','','',1,'0000-00-00 00:00:00'),(10,8,NULL,'','','','',1,0,'twist','','','',1,'0000-00-00 00:00:00'),(11,0,NULL,'','','','',1,0,'btn_text','','','',1,'0000-00-00 00:00:00'),(12,0,NULL,'','','','',1,0,'btn_url','','','',1,'0000-00-00 00:00:00'),(13,0,NULL,'','','','',1,0,'lon','','','',0,'2022-09-30 11:44:28'),(14,0,NULL,'','','','',1,0,'lat','','','',0,'2022-09-30 11:44:30'),(15,7,NULL,'','','','',1,0,'short_desc','','','',1,'0000-00-00 00:00:00'),(16,0,NULL,'','','','',1,0,'upper_text','','','',1,'2022-08-18 15:04:05'),(17,0,NULL,'','','','',1,0,'lower_text','','','',1,'2022-08-18 15:04:08'),(18,0,NULL,'','','','',1,0,'photo_text','','','',1,'2022-08-18 15:04:18'),(19,0,NULL,'','','','',1,0,'video_url','','','',0,'2022-03-14 12:06:01'),(20,0,NULL,'','','','',1,0,'form_text','','','',1,'2022-08-18 15:04:27'),(21,0,NULL,'','','','',1,0,'breadcrumbs_upper_text','','','',1,'2022-08-18 15:04:30'),(22,0,NULL,'','','','',1,0,'breadcrumbs_lower_text','','','',1,'2022-08-18 15:04:33'),(23,8,NULL,'','','','',1,0,'subpage_menu','','','',0,'2022-03-22 10:23:35'),(24,8,NULL,'','','','',1,0,'skip_grid','','','',0,'2022-03-22 13:29:57'),(25,16,NULL,'','','','',1,0,'iframe','','','',0,'2022-07-07 13:54:31'),(27,5,NULL,'','','','20',1,0,'btn_position','','','',0,'2022-10-20 14:36:21'),(28,6,NULL,'','','','',1,0,'banner_elements','','','',0,'2022-09-26 15:55:05'),(29,5,NULL,'','','','18',1,0,'btn_color','','','',1,'2022-10-20 11:03:27'),(30,8,NULL,'','','','',1,0,'show_only_on_mobile','','','',0,'2022-10-27 14:31:30'),(31,0,NULL,'','','','',1,0,'url','','','',1,'2023-03-01 08:34:43'),(32,6,NULL,'','','','',1,0,'test','','','',0,'2023-06-27 09:21:31');

--
-- Table structure for table `ngn_static_atribute_language`
--

CREATE TABLE `ngn_static_atribute_language` (
  `atribute_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL,
  `enable` int(11) NOT NULL,
  `approved` int(1) NOT NULL DEFAULT 0,
  `language_name` varchar(200) DEFAULT NULL,
  `language_description` text DEFAULT NULL,
  `language_meta` text DEFAULT NULL,
  `language_keywords` varchar(100) DEFAULT NULL,
  `language_url` varchar(100) DEFAULT NULL,
  `language_photo` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`atribute_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
