-- Table structure for table `ngn_articles_photo_usage`
--

CREATE TABLE `ngn_articles_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_articles_photo_usage`
--

INSERT INTO `ngn_articles_photo_usage` VALUES (8,'articles','news_photo',8),(37,'articles','category_photo',188),(40,'articles','news_photo',11),(41,'articles','news_photo',12),(42,'articles','news_photo',13),(43,'articles','news_photo',14),(44,'articles','news_photo',15),(46,'articles','news_photo',18),(47,'articles','news_photo',17),(48,'articles','news_photo',19),(49,'articles','news_photo',20),(50,'articles','news_photo',21),(51,'articles','news_photo',22),(52,'articles','news_photo',23),(53,'articles','news_photo',24),(54,'articles','news_photo',25),(55,'articles','news_photo',26),(56,'articles','news_photo',27),(57,'articles','news_photo',28),(58,'articles','news_photo',30),(59,'articles','news_photo',31),(60,'articles','news_photo',29),(61,'articles','news_photo',33),(62,'articles','news_photo',32),(79,'articles','category_photo',188),(89,'articles','news_photo',61),(90,'articles','news_photo',60),(91,'articles','news_photo',9),(100,'articles','news_gallery',6),(101,'articles','news_gallery',6),(102,'articles','news_gallery',6),(103,'articles','news_gallery',6),(104,'articles','news_photo',16),(117,'articles','news_photo',75),(119,'articles','news_photo',78),(120,'articles','news_photo',77),(121,'articles','news_photo',80),(122,'articles','news_photo',81),(123,'articles','news_photo',79),(124,'articles','news_photo',82),(125,'articles','news_photo',83),(127,'articles','news_photo',84),(129,'articles','news_photo',86),(130,'articles','news_photo',85),(145,'articles','news_photo',76),(147,'articles','news_photo',94),(156,'articles','news_photo',96),(157,'articles','news_photo',97),(161,'articles','news_photo',98),(162,'articles','news_gallery',98),(172,'articles','news_photo',88),(174,'articles','news_photo',91),(175,'articles','news_photo',87),(178,'articles','news_photo',89),(180,'articles','news_photo',90),(189,'articles','news_photo',99),(199,'articles','news_photo',99),(200,'articles','news_photo',99),(202,'articles','news_photo',92),(203,'articles','news_photo',92),(204,'articles','news_photo',93),(206,'articles','news_photo',93),(209,'articles','news_photo',1),(210,'articles','news_photo',2),(211,'articles','news_photo',3),(212,'articles','news_photo',64),(213,'articles','news_photo',4),(214,'articles','news_photo',5),(215,'articles','news_photo',6),(216,'articles','news_photo',7),(218,'articles','news_photo',43),(219,'articles','news_photo',49),(220,'articles','news_photo',62),(221,'articles','news_photo',63),(229,'articles','news_photo',102),(231,'articles','news_gallery',49),(232,'articles','news_gallery',49),(233,'articles','news_gallery',99),(234,'articles','news_gallery',99),(235,'articles','news_gallery',99),(236,'articles','news_gallery',99),(247,'articles','news_photo',103),(254,'articles','news_photo',104),(255,'articles','news_gallery',49),(256,'articles','news_gallery',5),(257,'articles','news_gallery',5),(258,'articles','news_gallery',6),(259,'articles','news_gallery',7),(260,'articles','news_gallery',7),(261,'articles','news_gallery',4),(262,'articles','news_gallery',95),(263,'articles','news_photo',105),(264,'articles','news_photo',106),(265,'articles','news_photo',107),(266,'articles','news_photo',108),(267,'articles','news_photo',109),(269,'articles','news_photo',59);

--
-- Table structure for table `ngn_articles_prices`
--

CREATE TABLE `ngn_articles_prices` (
  `news_id` int(11) NOT NULL,
  `pricing` int(11) NOT NULL,
  `editdate` datetime NOT NULL DEFAULT current_timestamp(),
  `timeout` datetime NOT NULL DEFAULT '9999-01-01 00:00:00',
  `user_group` int(11) NOT NULL DEFAULT 0,
  `price` float NOT NULL,
  PRIMARY KEY (`news_id`,`pricing`,`user_group`),
  KEY `news_id` (`news_id`,`pricing`,`timeout`,`user_group`),
  KEY `news_id_2` (`news_id`,`pricing`,`timeout`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ngn_articles_prices`
--

INSERT INTO `ngn_articles_prices` VALUES (1,42,'2023-06-07 15:01:18','9999-01-01 00:00:00',0,10),(2,42,'2023-06-07 15:00:47','9999-01-01 00:00:00',0,8),(3,42,'2023-06-07 15:00:43','9999-01-01 00:00:00',0,10),(4,42,'2023-06-07 15:02:53','9999-01-01 00:00:00',0,13),(5,42,'2023-08-03 11:00:23','9999-01-01 00:00:00',0,13),(6,42,'2023-06-07 15:01:53','9999-01-01 00:00:00',0,10),(7,42,'2023-06-07 15:02:20','9999-01-01 00:00:00',0,13),(8,42,'2022-08-25 13:47:45','9999-01-01 00:00:00',0,15),(9,42,'2022-10-17 10:43:37','9999-01-01 00:00:00',0,1.22),(11,42,'2023-01-16 11:47:47','9999-01-01 00:00:00',0,15),(12,42,'2023-01-16 12:35:10','9999-01-01 00:00:00',0,7),(13,42,'2023-03-01 08:47:44','9999-01-01 00:00:00',0,15),(14,42,'2023-02-24 11:18:29','9999-01-01 00:00:00',0,15),(15,42,'2023-02-24 11:21:02','9999-01-01 00:00:00',0,15),(16,42,'2023-01-16 11:40:34','9999-01-01 00:00:00',0,25),(17,42,'2023-01-16 11:50:55','9999-01-01 00:00:00',0,15),(18,42,'2023-01-16 11:51:00','9999-01-01 00:00:00',0,15),(19,42,'2023-01-16 11:51:05','9999-01-01 00:00:00',0,15),(20,42,'2023-03-13 09:03:09','9999-01-01 00:00:00',0,15),(21,42,'2023-04-24 10:51:54','9999-01-01 00:00:00',0,10),(22,42,'2023-04-24 10:52:18','9999-01-01 00:00:00',0,10),(23,42,'2023-04-24 10:52:28','9999-01-01 00:00:00',0,10),(24,42,'2023-01-16 11:47:51','9999-01-01 00:00:00',0,15),(25,42,'2023-01-16 11:47:54','9999-01-01 00:00:00',0,15),(26,42,'2023-02-24 11:04:34','9999-01-01 00:00:00',0,15),(27,42,'2023-03-01 08:44:59','9999-01-01 00:00:00',0,15),(28,42,'2023-02-24 11:05:17','9999-01-01 00:00:00',0,15),(29,42,'2023-03-01 08:45:22','9999-01-01 00:00:00',0,15),(30,42,'2023-02-24 11:06:21','9999-01-01 00:00:00',0,15),(31,42,'2023-02-24 11:07:24','9999-01-01 00:00:00',0,15),(32,42,'2023-03-01 08:32:55','9999-01-01 00:00:00',0,15),(33,42,'2023-02-24 10:51:31','9999-01-01 00:00:00',0,15),(34,42,'2023-06-01 15:50:14','9999-01-01 00:00:00',0,10),(35,42,'2023-06-01 15:50:21','9999-01-01 00:00:00',0,13),(36,42,'2023-06-01 15:50:26','9999-01-01 00:00:00',0,20),(37,42,'2023-01-12 10:33:17','9999-01-01 00:00:00',0,10),(38,42,'2023-01-12 10:33:35','9999-01-01 00:00:00',0,13),(39,42,'2023-01-12 10:33:57','9999-01-01 00:00:00',0,20),(40,42,'2023-06-01 15:50:47','9999-01-01 00:00:00',0,8),(41,42,'2023-06-01 15:50:51','9999-01-01 00:00:00',0,10),(42,42,'2023-06-01 15:50:56','9999-01-01 00:00:00',0,15),(43,42,'2023-06-13 11:09:45','9999-01-01 00:00:00',0,10),(44,42,'2023-03-01 08:11:33','9999-01-01 00:00:00',0,10),(45,42,'2023-03-01 08:11:40','9999-01-01 00:00:00',0,13),(46,42,'2023-03-01 08:11:45','9999-01-01 00:00:00',0,20),(47,42,'2023-01-12 11:06:30','9999-01-01 00:00:00',0,13),(48,42,'2023-01-12 11:06:15','9999-01-01 00:00:00',0,20),(49,42,'2023-06-07 15:01:38','9999-01-01 00:00:00',0,13),(50,42,'2023-01-16 09:29:21','9999-01-01 00:00:00',0,13),(51,42,'2023-01-16 09:29:31','9999-01-01 00:00:00',0,20),(52,42,'2023-01-12 10:51:09','9999-01-01 00:00:00',0,10),(53,42,'2023-01-12 10:51:28','9999-01-01 00:00:00',0,15),(54,42,'2023-01-12 10:55:03','9999-01-01 00:00:00',0,15),(55,42,'2023-03-13 10:31:22','9999-01-01 00:00:00',0,20),(56,42,'2023-01-12 11:04:04','9999-01-01 00:00:00',0,13),(57,42,'2023-01-12 11:04:25','9999-01-01 00:00:00',0,20),(58,42,'2022-10-11 15:05:29','9999-01-01 00:00:00',0,45),(59,42,'2023-06-06 13:31:25','9999-01-01 00:00:00',0,75),(60,42,'2023-06-07 15:01:06','9999-01-01 00:00:00',0,25),(61,42,'2022-10-17 11:57:49','9999-01-01 00:00:00',0,30),(62,42,'2023-06-13 11:11:28','9999-01-01 00:00:00',0,13),(63,42,'2023-06-13 11:11:01','9999-01-01 00:00:00',0,13),(64,42,'2023-06-06 08:49:30','9999-01-01 00:00:00',0,10),(65,42,'2023-06-01 15:49:01','9999-01-01 00:00:00',0,10),(66,42,'2023-06-01 15:49:06','9999-01-01 00:00:00',0,13),(67,42,'2023-06-01 15:49:16','9999-01-01 00:00:00',0,20),(68,42,'2023-01-12 10:44:55','9999-01-01 00:00:00',0,13),(69,42,'2023-01-12 10:45:15','9999-01-01 00:00:00',0,20),(70,42,'2023-02-28 14:49:25','9999-01-01 00:00:00',0,13),(71,42,'2023-02-28 14:49:31','9999-01-01 00:00:00',0,20),(72,42,'2023-04-24 10:56:44','9999-01-01 00:00:00',0,4),(73,42,'2023-04-24 10:56:52','9999-01-01 00:00:00',0,25),(74,42,'2023-04-24 10:56:58','9999-01-01 00:00:00',0,5),(75,42,'2023-02-28 14:49:47','9999-01-01 00:00:00',0,90),(76,42,'2023-02-28 14:49:51','9999-01-01 00:00:00',0,50),(77,42,'2023-02-28 14:49:54','9999-01-01 00:00:00',0,10),(78,42,'2023-02-28 14:50:44','9999-01-01 00:00:00',0,50),(79,42,'2023-02-28 14:50:51','9999-01-01 00:00:00',0,35),(80,42,'2023-02-28 14:50:55','9999-01-01 00:00:00',0,10),(81,42,'2023-02-28 14:51:24','9999-01-01 00:00:00',0,15),(82,42,'2023-06-20 07:53:52','9999-01-01 00:00:00',0,10),(83,42,'2023-06-15 14:29:52','9999-01-01 00:00:00',0,25),(84,42,'2023-02-28 15:03:05','9999-01-01 00:00:00',0,1.095),(85,42,'2023-04-24 11:01:54','9999-01-01 00:00:00',0,25),(86,42,'2023-04-24 11:02:01','9999-01-01 00:00:00',0,5),(87,42,'2023-04-24 11:02:08','9999-01-01 00:00:00',0,20),(88,42,'2023-04-24 11:02:14','9999-01-01 00:00:00',0,15),(89,42,'2023-04-24 11:02:22','9999-01-01 00:00:00',0,35),(90,42,'2023-04-24 11:02:29','9999-01-01 00:00:00',0,35),(91,42,'2023-04-24 11:02:35','9999-01-01 00:00:00',0,40),(92,42,'2023-04-24 11:02:41','9999-01-01 00:00:00',0,50),(93,42,'2023-03-01 08:14:02','9999-01-01 00:00:00',0,0.135542),(94,42,'2023-03-01 08:13:47','9999-01-01 00:00:00',0,500),(96,42,'2023-04-24 11:02:46','9999-01-01 00:00:00',0,15),(97,42,'2023-04-24 11:02:51','9999-01-01 00:00:00',0,15),(98,42,'2023-01-06 16:41:00','9999-01-01 00:00:00',0,90),(99,42,'2023-06-15 14:30:28','9999-01-01 00:00:00',0,30),(100,42,'2023-04-07 13:45:29','9999-01-01 00:00:00',0,150),(102,42,'2023-04-24 11:03:00','9999-01-01 00:00:00',0,10),(103,42,'2023-02-07 10:51:59','9999-01-01 00:00:00',0,300),(104,42,'2023-06-07 15:03:01','9999-01-01 00:00:00',0,45),(105,42,'2023-04-07 14:10:28','9999-01-01 00:00:00',0,1000),(106,42,'2023-04-24 11:18:59','9999-01-01 00:00:00',0,25),(107,42,'2023-05-31 08:26:51','9999-01-01 00:00:00',0,60),(108,42,'2023-05-31 08:30:36','9999-01-01 00:00:00',0,30),(109,42,'2023-05-31 08:34:00','9999-01-01 00:00:00',0,40);

--
-- Table structure for table `ngn_articles_restrictions`
--

CREATE TABLE `ngn_articles_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=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_restrictions`
--

INSERT INTO `ngn_articles_restrictions` VALUES (1,'Default',0),(2,'Default',0),(3,'Kozmetika grid',0),(4,'Olja',0);

--
-- Table structure for table `ngn_articles_restrictions_groups`
--

CREATE TABLE `ngn_articles_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_restrictions_groups`
--

INSERT INTO `ngn_articles_restrictions_groups` VALUES (1,3,51,0,0,1);

--
-- Table structure for table `ngn_articles_restrictions_settings`
--

CREATE TABLE `ngn_articles_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_articles_restrictions_settings`
--

INSERT INTO `ngn_articles_restrictions_settings` VALUES (1,'CategoryAddSEOUrlNameRewriteAlways',1,'',0),(1,'CategoryAddSEOUrlNameRewriteIfNeed',1,'',0),(1,'CategoryAddShowDescription',1,'',0),(1,'CategoryAddShowDescriptionAddMedia',1,'',0),(1,'CategoryAddShowEnable',1,'',0),(1,'CategoryAddShowFiles',1,'',0),(1,'CategoryAddShowGallery',1,'',0),(1,'CategoryAddShowGroups',1,'',0),(1,'CategoryAddShowKeywords',1,'',0),(1,'CategoryAddShowLinks',1,'',0),(1,'CategoryAddShowMeta',1,'',0),(1,'CategoryAddShowName',1,'',0),(1,'CategoryAddShowPhoto',1,'',0),(1,'CategoryAddShowPhoto2',1,'',0),(1,'CategoryAddShowUrl',1,'',0),(1,'CategoryDesignerDefault',1,'',0),(1,'CategoryDesignerEditor',1,'',0),(1,'CategoryLanguageEnable',1,'',0),(1,'CategorySEO',1,'',0),(1,'categoryTemplateShow',1,'',0),(1,'NewsAddSEOUrlNameRewriteAlways',1,'',0),(1,'NewsAddSEOUrlNameRewriteIfNeed',1,'',0),(1,'newsCategory',1,'',0),(1,'NewsEditNewsMulticategory',1,'',0),(1,'newsEnable',1,'',0),(1,'newsFiles',1,'',0),(1,'newsGallery',1,'',0),(1,'newsLanguageEnable',1,'',0),(1,'newsLinks',1,'',0),(1,'newsMediaOnPages',1,'',0),(1,'newsName',1,'',0),(1,'newsOwner',1,'',0),(1,'newsPages',1,'',0),(1,'newsPhoto1',1,'',0),(1,'newsPhoto2',1,'',0),(1,'newsSEO',1,'',0),(1,'newsSEOKeywords',1,'',0),(1,'newsSEOMeta',1,'',0),(1,'newsSEOUrl',1,'',0),(1,'newsSource',1,'',0),(1,'newsSourceUrl',1,'',0),(1,'newsTags',1,'',0),(1,'newsTemplate',1,'',0),(2,'CategoryAddSEOUrlNameRewriteAlways',1,'',0),(2,'CategoryAddSEOUrlNameRewriteIfNeed',1,'',0),(2,'CategoryAddShowDescription',1,'',0),(2,'CategoryAddShowDescriptionAddMedia',1,'',0),(2,'CategoryAddShowEnable',1,'',0),(2,'CategoryAddShowFiles',1,'',0),(2,'CategoryAddShowGallery',1,'',0),(2,'CategoryAddShowGroups',1,'',0),(2,'CategoryAddShowKeywords',1,'',0),(2,'CategoryAddShowLinks',1,'',0),(2,'CategoryAddShowMeta',1,'',0),(2,'CategoryAddShowName',1,'',0),(2,'CategoryAddShowPhoto',1,'',0),(2,'CategoryAddShowPhoto2',1,'',0),(2,'CategoryAddShowUrl',1,'',0),(2,'CategoryDesignerDefault',1,'',0),(2,'CategoryDesignerEditor',1,'',0),(2,'CategoryLanguageEnable',1,'',0),(2,'CategorySEO',1,'',0),(2,'categoryTemplateShow',1,'',0),(2,'NewsAddSEOUrlNameRewriteAlways',1,'',0),(2,'NewsAddSEOUrlNameRewriteIfNeed',1,'',0),(2,'newsCategory',1,'',0),(2,'NewsEditNewsMulticategory',1,'',0),(2,'newsEnable',1,'',0),(2,'newsFiles',1,'',0),(2,'newsGallery',1,'',0),(2,'newsLanguageEnable',1,'',0),(2,'newsLinks',1,'',0),(2,'newsMediaOnPages',1,'',0),(2,'newsName',1,'',0),(2,'newsOwner',1,'',0),(2,'newsPages',1,'',0),(2,'newsPhoto1',1,'',0),(2,'newsPhoto2',1,'',0),(2,'newsSEO',1,'',0),(2,'newsSEOKeywords',1,'',0),(2,'newsSEOMeta',1,'',0),(2,'newsSEOUrl',1,'',0),(2,'newsSource',1,'',0),(2,'newsSourceUrl',1,'',0),(2,'newsTags',1,'',0),(2,'newsTemplate',1,'',0),(3,'CategoryAddSEOUrlNameRewriteIfNeed',1,'',0),(3,'CategoryAddShowEnable',1,'',0),(3,'CategoryAddShowKeywords',1,'',0),(3,'CategoryAddShowMeta',1,'',0),(3,'CategoryAddShowName',1,'',0),(3,'CategoryAddShowPhoto',1,'',0),(3,'CategoryAddShowPhoto2',1,'',0),(3,'CategoryAddShowUrl',1,'',0),(3,'CategoryDesignerDefault',1,'',0),(3,'CategoryDesignerEditor',1,'',0),(3,'CategoryLanguageEnable',1,'',0),(3,'CategorySEO',1,'',0),(3,'categoryTemplate',0,'38',0),(3,'categoryTemplateShow',1,'',0),(3,'NewsAddSEOUrlNameRewriteAlways',1,'',0),(3,'NewsAddSEOUrlNameRewriteIfNeed',1,'',0),(3,'newsCategory',1,'',0),(3,'NewsEditNewsMulticategory',1,'',0),(3,'newsEnable',1,'',0),(3,'newsFiles',1,'',0),(3,'newsGallery',1,'',0),(3,'newsLanguageEnable',1,'',0),(3,'newsLinks',1,'',0),(3,'newsMediaOnPages',1,'',0),(3,'newsName',1,'',0),(3,'newsOwner',1,'',0),(3,'newsPages',1,'',0),(3,'newsPhoto1',1,'',0),(3,'newsPhoto2',1,'',0),(3,'newsSEO',1,'',0),(3,'newsSEOKeywords',1,'',0),(3,'newsSEOMeta',1,'',0),(3,'newsSEOUrl',1,'',0),(3,'newsSource',1,'',0),(3,'newsSourceUrl',1,'',0),(3,'newsTags',1,'',0),(3,'newsTemplate',1,'39',0),(4,'CategoryAddSEOUrlNameRewriteIfNeed',1,'',0),(4,'CategoryAddShowEnable',1,'',0),(4,'CategoryAddShowGroups',1,'',0),(4,'CategoryAddShowKeywords',1,'',0),(4,'CategoryAddShowMeta',1,'',0),(4,'CategoryAddShowName',1,'',0),(4,'CategoryAddShowPhoto',1,'',0),(4,'CategoryAddShowPhoto2',1,'',0),(4,'CategoryAddShowUrl',1,'',0),(4,'CategoryDesignerDefault',1,'',0),(4,'CategoryDesignerEditor',1,'',0),(4,'CategoryLanguageEnable',1,'',0),(4,'CategorySEO',1,'',0),(4,'categoryTemplate',0,'41',0),(4,'categoryTemplateShow',1,'',0),(4,'NewsAddSEOUrlNameRewriteIfNeed',1,'',0),(4,'newsCategory',1,'',0),(4,'NewsEditNewsMulticategory',1,'',0),(4,'newsEnable',1,'',0),(4,'newsLanguageEnable',1,'',0),(4,'newsName',1,'',0),(4,'newsOwner',1,'',0),(4,'newsPhoto1',1,'',0),(4,'newsPhoto2',1,'',0),(4,'newsSEO',1,'',0),(4,'newsSEOKeywords',1,'',0),(4,'newsSEOMeta',1,'',0),(4,'newsSEOUrl',1,'',0),(4,'newsTemplate',1,'42',0);

--
-- Table structure for table `ngn_articles_restrictions_settings_multi`
--

CREATE TABLE `ngn_articles_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_articles_restrictions_settings_multi`
--

INSERT INTO `ngn_articles_restrictions_settings_multi` VALUES (3,'categoryTemplate',38,0),(3,'newsTemplate',39,0),(4,'categoryTemplate',41,0),(4,'newsTemplate',42,0);

--
-- Table structure for table `ngn_articles_roles`
--

CREATE TABLE `ngn_articles_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_articles_roles`
--


--
-- Table structure for table `ngn_articles_stock`
--

CREATE TABLE `ngn_articles_stock` (
  `stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `warehouse` int(11) NOT NULL,
  `news_id` int(11) DEFAULT NULL,
  `item_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL DEFAULT 0,
  `document_id` varchar(13) NOT NULL DEFAULT '0',
  `user_id` varchar(45) DEFAULT NULL,
  `stock_insert` datetime NOT NULL DEFAULT current_timestamp(),
  `stock_createdate` datetime DEFAULT current_timestamp(),
  `stock_editdate` datetime DEFAULT current_timestamp(),
  `stock_type` int(11) DEFAULT NULL,
  `stock_value` double DEFAULT NULL,
  `order_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`stock_id`),
  KEY `news_id` (`news_id`),
  KEY `user_id` (`user_id`),
  KEY `stock_type` (`stock_type`),
  KEY `order_id` (`order_id`),
  KEY `stock_value` (`stock_value`),
  KEY `warehouse` (`warehouse`),
  KEY `document_id` (`document_id`),
  KEY `stock_editdate` (`stock_editdate`),
  KEY `invoice_id` (`invoice_id`),
  KEY `get_element_price` (`warehouse`,`news_id`) USING BTREE,
  KEY `get_element_price_item` (`warehouse`,`news_id`,`item_id`) USING BTREE,
  KEY `writeOff` (`invoice_id`,`item_id`),
  KEY `writeOffAutomatic` (`news_id`,`invoice_id`,`item_id`),
  KEY `clearInvoiceStockAll` (`invoice_id`,`stock_type`,`item_id`,`news_id`)
) ENGINE=InnoDB AUTO_INCREMENT=126 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_stock`
--

INSERT INTO `ngn_articles_stock` VALUES (1,1,76,2,2,'0','731','2022-11-14 20:33:27','2022-11-14 20:33:27','2022-11-14 20:33:27',1,-1,0),(2,1,21,302,42,'0','794','2022-12-04 20:26:29','2022-12-04 20:26:29','2022-12-04 20:26:29',1,-1,0),(3,1,86,303,42,'0','794','2022-12-04 20:26:29','2022-12-04 20:26:29','2022-12-04 20:26:29',1,-1,0),(4,1,59,367,54,'0','796','2022-12-05 16:42:48','2022-12-05 16:42:48','2022-12-05 16:44:17',1,-1,0),(5,1,85,373,57,'0','797','2022-12-05 21:44:39','2022-12-05 21:44:39','2022-12-05 21:44:39',1,-2,0),(6,1,86,476,72,'0','852','2022-12-14 18:40:50','2022-12-14 18:40:50','2022-12-16 17:45:58',1,-1,0),(7,1,81,477,72,'0','852','2022-12-14 18:40:50','2022-12-14 18:40:50','2022-12-16 17:45:58',1,-1,0),(8,1,85,478,72,'0','852','2022-12-14 18:40:50','2022-12-14 18:40:50','2022-12-16 17:45:59',1,-1,0),(9,1,85,485,73,'0','852','2022-12-14 18:48:49','2022-12-14 18:48:49','2022-12-14 18:48:49',1,-1,0),(10,1,86,492,73,'0','852','2022-12-14 18:48:49','2022-12-14 18:48:49','2022-12-14 18:48:49',1,-1,0),(11,1,81,493,73,'0','852','2022-12-14 18:48:49','2022-12-14 18:48:49','2022-12-14 18:48:49',1,-1,0),(12,1,15,496,74,'0','867','2022-12-15 12:35:32','2022-12-15 12:35:32','2022-12-16 16:07:11',1,-1,0),(13,1,18,497,74,'0','867','2022-12-15 12:35:32','2022-12-15 12:35:32','2022-12-16 16:07:11',1,-1,0),(14,1,14,498,74,'0','867','2022-12-15 12:35:32','2022-12-15 12:35:32','2022-12-16 16:07:11',1,-2,0),(15,1,9,541,82,'0','903','2022-12-20 00:53:32','2022-12-20 00:53:32','2022-12-20 00:53:59',1,-2,0),(16,1,59,645,93,'0','928','2022-12-27 11:02:44','2022-12-27 11:02:44','2022-12-27 11:03:10',1,-1,0),(17,1,19,685,106,'0','951','2023-01-08 17:27:55','2023-01-08 17:27:55','2023-01-08 17:28:34',1,-1,0),(18,1,17,686,106,'0','951','2023-01-08 17:27:55','2023-01-08 17:27:55','2023-01-08 17:28:34',1,-1,0),(19,1,99,687,106,'0','951','2023-01-08 17:27:55','2023-01-08 17:27:55','2023-01-08 17:28:34',1,-1,0),(20,1,17,699,112,'0','961','2023-01-09 22:59:23','2023-01-09 22:59:23','2023-01-09 23:00:23',1,-1,0),(21,1,33,700,112,'0','961','2023-01-09 22:59:23','2023-01-09 22:59:23','2023-01-09 23:00:23',1,-1,0),(22,1,99,701,112,'0','961','2023-01-09 22:59:23','2023-01-09 22:59:23','2023-01-09 23:00:23',1,-1,0),(23,1,16,705,114,'0','980','2023-01-12 15:57:03','2023-01-12 15:57:03','2023-01-12 15:58:14',1,-2,0),(24,1,14,706,114,'0','980','2023-01-12 15:57:03','2023-01-12 15:57:03','2023-01-12 15:58:14',1,-2,0),(25,1,25,707,114,'0','980','2023-01-12 15:57:03','2023-01-12 15:57:03','2023-01-12 15:58:14',1,-1,0),(26,1,20,708,114,'0','980','2023-01-12 15:57:03','2023-01-12 15:57:03','2023-01-12 15:58:14',1,-1,0),(27,1,9,711,114,'0','980','2023-01-12 15:57:03','2023-01-12 15:57:03','2023-01-12 15:58:14',1,-1,0),(28,1,17,923,138,'0','1022','2023-01-22 16:07:35','2023-01-22 16:07:35','2023-01-22 16:09:05',1,-1,0),(29,1,21,924,138,'0','1022','2023-01-22 16:07:35','2023-01-22 16:07:35','2023-01-22 16:09:05',1,-1,0),(30,1,18,954,145,'0','1084','2023-01-29 10:13:59','2023-01-29 10:13:59','2023-01-29 10:13:59',1,-1,0),(31,1,17,955,145,'0','1084','2023-01-29 10:13:59','2023-01-29 10:13:59','2023-01-29 10:13:59',1,-1,0),(32,1,19,956,145,'0','1084','2023-01-29 10:13:59','2023-01-29 10:13:59','2023-01-29 10:13:59',1,-1,0),(33,1,9,1078,166,'0','1145','2023-02-10 19:15:51','2023-02-10 19:15:51','2023-02-10 19:16:20',1,-1,0),(34,1,59,1134,177,'0','1169','2023-02-13 15:12:12','2023-02-13 15:12:12','2023-02-13 15:14:25',1,-1,0),(35,1,59,1171,179,'0','1179','2023-02-14 19:48:53','2023-02-14 19:48:53','2023-02-14 19:49:57',1,-1,0),(36,1,8,1174,179,'0','1179','2023-02-14 19:48:53','2023-02-14 19:48:53','2023-02-14 19:48:53',1,-1,0),(37,1,8,1175,179,'0','1179','2023-02-14 19:49:06','2023-02-14 19:49:06','2023-02-14 19:49:57',1,-1,0),(38,1,59,1203,183,'0','1190','2023-02-16 19:55:43','2023-02-16 19:55:43','2023-02-16 19:58:45',1,-1,0),(39,1,9,1205,183,'0','1190','2023-02-16 19:55:43','2023-02-16 19:55:43','2023-02-16 19:58:45',1,-1,0),(40,1,99,1368,201,'0','1229','2023-02-22 19:54:15','2023-02-22 19:54:15','2023-02-22 19:55:01',1,-1,0),(41,1,86,1369,201,'0','1229','2023-02-22 19:54:15','2023-02-22 19:54:15','2023-02-22 19:55:01',1,-1,0),(42,1,14,1388,205,'0','1249','2023-02-23 23:48:33','2023-02-23 23:48:33','2023-02-23 23:50:21',1,-1,0),(43,1,59,1390,205,'0','1249','2023-02-23 23:48:33','2023-02-23 23:48:33','2023-02-23 23:50:21',1,-3,0),(44,1,75,1395,207,'0','719','2023-02-24 08:08:29','2023-02-24 08:08:29','2023-02-24 08:08:29',1,-1,0),(45,1,16,1396,207,'0','719','2023-02-24 08:08:29','2023-02-24 08:08:29','2023-02-24 08:08:29',1,-1,0),(46,1,59,1570,215,'0','59','2023-02-24 16:18:25','2023-02-24 16:18:25','2023-02-24 16:18:25',1,-1,0),(47,1,59,1574,216,'0','59','2023-02-24 16:27:00','2023-02-24 16:27:00','2023-02-24 16:27:00',1,-1,0),(48,1,100,1623,220,'0','718','2023-02-24 18:34:14','2023-02-24 18:34:14','2023-02-24 18:34:14',1,-1,0),(49,1,14,1625,222,'0','1275','2023-02-26 03:46:57','2023-02-26 03:46:57','2023-02-26 03:47:45',1,-1,0),(50,1,16,1626,222,'0','1275','2023-02-26 03:46:57','2023-02-26 03:46:57','2023-02-26 03:47:45',1,-1,0),(51,1,15,1628,222,'0','1275','2023-02-26 03:46:57','2023-02-26 03:46:57','2023-02-26 03:47:45',1,-1,0),(52,1,24,1629,222,'0','1275','2023-02-26 03:46:57','2023-02-26 03:46:57','2023-02-26 03:47:45',1,-1,0),(53,1,27,1630,222,'0','1275','2023-02-26 03:46:57','2023-02-26 03:46:57','2023-02-26 03:47:45',1,-1,0),(54,1,17,1720,239,'0','1358','2023-03-03 22:50:35','2023-03-03 22:50:35','2023-03-03 22:50:35',1,-1,0),(55,1,17,1791,251,'0','1358','2023-03-05 12:18:51','2023-03-05 12:18:51','2023-03-05 12:20:40',1,-1,0),(56,1,25,1789,250,'0','1366','2023-03-05 12:31:08','2023-03-05 12:31:08','2023-03-05 12:32:19',1,-1,0),(57,1,15,1790,250,'0','1366','2023-03-05 12:31:08','2023-03-05 12:31:08','2023-03-05 12:32:19',1,-1,0),(58,1,59,1835,264,'0','1415','2023-03-11 07:10:25','2023-03-11 07:10:25','2023-03-11 07:10:25',1,-1,0),(59,1,59,2112,324,'0','1594','2023-03-27 10:30:30','2023-03-27 10:30:30','2023-03-27 10:30:30',1,-1,0),(60,1,23,2113,324,'0','1594','2023-03-27 10:30:30','2023-03-27 10:30:30','2023-03-27 10:30:30',1,-1,0),(61,1,59,2114,325,'0','1595','2023-03-27 15:19:54','2023-03-27 15:19:54','2023-03-27 15:21:28',1,-1,0),(62,1,59,2137,327,'0','1598','2023-03-28 13:42:39','2023-03-28 13:42:39','2023-03-28 13:42:39',1,-1,0),(63,1,59,2138,328,'0','1598','2023-03-28 13:53:01','2023-03-28 13:53:01','2023-03-28 13:53:01',1,-1,0),(64,1,99,2185,342,'0','1644','2023-04-04 08:10:15','2023-04-04 08:10:15','2023-04-04 08:10:15',1,-2,0),(65,1,59,2206,345,'0','1646','2023-04-04 23:41:45','2023-04-04 23:41:45','2023-04-04 23:41:45',1,-1,0),(66,1,9,2210,345,'0','1646','2023-04-04 23:41:45','2023-04-04 23:41:45','2023-04-04 23:41:45',1,-1,0),(67,1,59,2212,347,'0','1646','2023-04-05 00:49:27','2023-04-05 00:49:27','2023-04-05 00:52:19',1,-1,0),(68,1,9,2227,347,'0','1646','2023-04-05 00:49:27','2023-04-05 00:49:27','2023-04-05 00:52:19',1,-1,0),(69,1,99,2232,349,'0','1644','2023-04-05 08:47:26','2023-04-05 08:47:26','2023-04-05 08:47:26',1,-2,0),(70,1,80,2301,362,'0','1700','2023-04-13 08:11:27','2023-04-13 08:11:27','2023-04-13 08:11:27',1,-1,0),(71,1,82,2302,362,'0','1700','2023-04-13 08:11:27','2023-04-13 08:11:27','2023-04-13 08:11:27',1,-1,0),(72,1,77,2303,362,'0','1700','2023-04-13 08:11:27','2023-04-13 08:11:27','2023-04-13 08:11:27',1,-3,0),(73,1,97,2310,362,'0','1700','2023-04-13 08:11:27','2023-04-13 08:11:27','2023-04-13 08:11:27',1,-2,0),(74,1,59,2325,367,'0','1745','2023-04-16 20:28:22','2023-04-16 20:28:22','2023-04-16 20:28:22',1,-1,0),(75,1,59,2326,368,'0','1750','2023-04-16 23:48:50','2023-04-16 23:48:50','2023-04-16 23:49:46',1,-1,0),(76,1,59,2393,381,'0','1780','2023-04-18 16:45:48','2023-04-18 16:45:48','2023-04-18 16:50:03',1,-1,0),(77,1,8,2429,387,'0','1800','2023-04-19 19:16:26','2023-04-19 19:16:26','2023-04-19 19:17:29',1,-1,0),(78,1,59,2449,391,'0','1820','2023-04-21 06:24:30','2023-04-21 06:24:30','2023-04-21 06:26:51',1,-1,0),(79,1,59,2455,394,'0','1854','2023-04-22 12:49:09','2023-04-22 12:49:09','2023-04-22 12:51:41',1,-1,0),(80,1,59,2573,418,'0','1945','2023-05-02 12:13:43','2023-05-02 12:13:43','2023-05-02 12:13:43',1,-1,0),(81,1,59,2589,421,'0','1960','2023-05-04 13:19:27','2023-05-04 13:19:27','2023-05-04 13:19:53',1,-1,0),(82,1,59,2612,430,'0','1981','2023-05-08 12:53:09','2023-05-08 12:53:09','2023-05-08 12:53:47',1,-1,0),(83,1,14,2628,434,'0','1984','2023-05-09 05:27:35','2023-05-09 05:27:35','2023-05-09 05:28:47',1,-2,0),(84,1,9,2635,434,'0','1984','2023-05-09 05:27:35','2023-05-09 05:27:35','2023-05-09 05:28:47',1,-2,0),(85,1,59,2638,436,'0','1985','2023-05-09 10:10:52','2023-05-09 10:10:52','2023-05-09 10:11:40',1,-1,0),(86,1,59,2741,460,'0','2078','2023-05-17 12:25:03','2023-05-17 12:25:03','2023-05-17 12:26:27',1,-1,0),(87,1,59,2931,494,'0','2223','2023-06-02 17:06:52','2023-06-02 17:06:52','2023-06-02 17:08:45',1,-2,0),(88,1,59,3028,525,'0','2270','2023-06-06 19:23:55','2023-06-06 19:23:55','2023-06-06 19:24:45',1,-2,0),(89,1,82,3036,528,'0','2294','2023-06-07 14:17:25','2023-06-07 14:17:25','2023-06-07 14:17:25',1,-1,0),(90,1,82,3042,529,'0','2294','2023-06-07 16:22:58','2023-06-07 16:22:58','2023-06-07 16:23:33',1,-1,0),(91,1,59,3063,540,'0','2358','2023-06-13 16:31:18','2023-06-13 16:31:18','2023-06-13 16:32:53',1,-1,0),(92,1,59,3211,567,'0','2424','2023-06-21 16:46:26','2023-06-21 16:46:26','2023-06-21 16:47:24',1,-1,0),(93,1,14,3224,572,'0','2458','2023-06-23 21:48:22','2023-06-23 21:48:22','2023-06-23 21:50:04',1,-1,0),(94,1,59,3273,581,'0','2478','2023-06-26 15:44:21','2023-06-26 15:44:21','2023-06-26 15:44:59',1,-1,0),(95,1,59,3278,583,'0','2493','2023-06-27 13:19:41','2023-06-27 13:19:41','2023-06-27 13:19:41',1,-1,0),(96,1,59,3298,587,'0','2493','2023-06-28 10:46:46','2023-06-28 10:46:46','2023-06-28 10:46:46',1,-2,0),(97,1,59,3352,596,'0','2539','2023-07-01 10:31:04','2023-07-01 10:31:04','2023-07-01 10:32:20',1,-3,0),(98,1,82,3423,610,'0','1281','2023-07-06 13:45:37','2023-07-06 13:45:37','2023-07-06 13:47:46',1,-1,0),(99,1,59,3441,614,'0','2634','2023-07-08 12:17:58','2023-07-08 12:17:58','2023-07-08 12:19:35',1,-3,0),(100,1,8,3524,621,'0','2669','2023-07-10 22:06:15','2023-07-10 22:06:15','2023-07-10 22:07:17',1,-1,0),(101,1,59,3629,635,'0','2693','2023-07-12 18:42:20','2023-07-12 18:42:20','2023-07-12 18:42:56',1,-1,0),(102,1,9,3651,639,'0','2698','2023-07-13 18:32:23','2023-07-13 18:32:23','2023-07-13 18:34:04',1,-1,0),(103,1,92,3674,647,'0','2738','2023-07-16 11:33:34','2023-07-16 11:33:34','2023-07-16 11:33:34',1,-1,0),(104,1,85,3675,647,'0','2738','2023-07-16 11:33:34','2023-07-16 11:33:34','2023-07-16 11:33:34',1,-1,0),(105,1,9,3699,647,'0','2738','2023-07-16 11:33:34','2023-07-16 11:33:34','2023-07-16 11:33:34',1,-1,0),(106,1,59,3701,651,'0','928','2023-07-16 16:29:22','2023-07-16 16:29:22','2023-07-16 16:29:57',1,-1,0),(107,1,9,3784,661,'0','2807','2023-07-19 16:10:24','2023-07-19 16:10:24','2023-07-19 16:10:24',1,-1,0),(108,1,59,3880,679,'0','2850','2023-07-24 15:27:27','2023-07-24 15:27:27','2023-07-24 15:27:27',1,-1,0),(109,1,59,3897,685,'0','2868','2023-07-26 09:59:53','2023-07-26 09:59:53','2023-07-26 10:01:02',1,-1,0),(110,1,83,3899,685,'0','2868','2023-07-26 09:59:53','2023-07-26 09:59:53','2023-07-26 10:01:02',1,-2,0),(111,1,14,3922,691,'0','2877','2023-07-26 23:14:27','2023-07-26 23:14:27','2023-07-26 23:15:46',1,-1,0),(112,1,9,3931,691,'0','2877','2023-07-26 23:14:27','2023-07-26 23:14:27','2023-07-26 23:15:46',1,-1,0),(113,1,59,3934,693,'0','2879','2023-07-27 13:38:55','2023-07-27 13:38:55','2023-07-27 13:38:55',1,-1,0),(114,1,59,4004,707,'0','2943','2023-08-02 08:14:21','2023-08-02 08:14:21','2023-08-02 08:15:16',1,-1,0),(115,1,83,4033,710,'0','2961','2023-08-03 01:15:15','2023-08-03 01:15:15','2023-08-03 01:15:38',1,-4,0),(116,1,9,4056,710,'0','2961','2023-08-03 01:15:15','2023-08-03 01:15:15','2023-08-03 01:15:38',1,-4,0),(117,1,59,4131,721,'0','3003','2023-08-04 13:33:05','2023-08-04 13:33:05','2023-08-04 13:33:05',1,-1,0),(118,1,9,4147,723,'0','3015','2023-08-05 00:06:52','2023-08-05 00:06:52','2023-08-05 00:07:35',1,-1,0),(119,1,9,4168,725,'0','3020','2023-08-05 05:47:28','2023-08-05 05:47:28','2023-08-05 05:48:55',1,-1,0),(120,1,96,4250,742,'0','3060','2023-08-08 14:27:42','2023-08-08 14:27:42','2023-08-08 14:28:49',1,-3,0),(121,1,14,4251,742,'0','3060','2023-08-08 14:27:42','2023-08-08 14:27:42','2023-08-08 14:28:49',1,-3,0),(122,1,9,4256,742,'0','3060','2023-08-08 14:27:42','2023-08-08 14:27:42','2023-08-08 14:28:49',1,-3,0),(123,1,80,4313,753,'0','3117','2023-08-12 22:17:29','2023-08-12 22:17:29','2023-08-12 22:17:29',1,-2,0),(124,1,59,4337,758,'0','3130','2023-08-14 11:58:04','2023-08-14 11:58:04','2023-08-14 12:01:15',1,-2,0),(125,1,59,4353,763,'0','3137','2023-08-14 21:24:28','2023-08-14 21:24:28','2023-08-14 21:25:38',1,-1,0);

--
-- Table structure for table `ngn_articles_stock_sum`
--

CREATE TABLE `ngn_articles_stock_sum` (
  `news_id` int(11) NOT NULL,
  `warehouse` int(11) NOT NULL,
  `editdate` datetime NOT NULL DEFAULT current_timestamp(),
  `stock_sum` double NOT NULL,
  PRIMARY KEY (`news_id`,`warehouse`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ngn_articles_stock_sum`
--

INSERT INTO `ngn_articles_stock_sum` VALUES (8,0,'2022-08-25 13:47:45',-3),(8,1,'2022-08-25 13:47:45',-3),(9,0,'2022-10-17 10:43:37',-1),(9,1,'2022-10-17 10:43:37',-1),(14,0,'2023-02-24 11:18:29',-5),(14,1,'2023-02-24 11:18:29',-5),(15,0,'2023-02-24 11:21:02',-1),(15,1,'2023-02-24 11:21:02',-1),(16,0,'2023-01-16 11:40:34',-2),(16,1,'2023-01-16 11:40:34',-2),(17,0,'2023-01-16 11:50:55',-2),(17,1,'2023-01-16 11:50:55',-2),(18,0,'2023-01-16 11:51:00',-1),(18,1,'2023-01-16 11:51:00',-1),(19,0,'2023-01-16 11:51:05',-1),(19,1,'2023-01-16 11:51:05',-1),(20,0,'2023-03-13 09:03:09',-1),(20,1,'2023-03-13 09:03:09',-1),(21,0,'2023-04-24 10:51:54',-2),(21,1,'2023-04-24 10:51:54',-2),(23,0,'2023-04-24 10:52:28',-1),(23,1,'2023-04-24 10:52:28',-1),(25,0,'2023-01-16 11:47:54',-1),(25,1,'2023-01-16 11:47:54',-1),(27,0,'2023-03-01 08:44:59',-1),(27,1,'2023-03-01 08:44:59',-1),(33,0,'2023-02-24 10:51:31',-1),(33,1,'2023-02-24 10:51:31',-1),(59,0,'2023-06-06 13:31:25',-29),(59,1,'2023-06-06 13:31:25',-29),(75,0,'2023-02-28 14:49:47',-1),(75,1,'2023-02-28 14:49:47',-1),(76,0,'2023-02-28 14:49:51',-1),(76,1,'2023-02-28 14:49:51',-1),(81,0,'2023-02-28 14:51:24',-2),(81,1,'2023-02-28 14:51:24',-2),(82,0,'2023-06-20 07:53:52',-3),(82,1,'2023-06-20 07:53:52',-3),(85,0,'2023-04-24 11:01:54',-4),(85,1,'2023-04-24 11:01:54',-4),(86,0,'2023-04-24 11:02:01',-4),(86,1,'2023-04-24 11:02:01',-4),(97,0,'2023-04-24 11:02:51',-2),(97,1,'2023-04-24 11:02:51',-2),(99,0,'2023-06-15 14:30:28',-7),(99,1,'2023-06-15 14:30:28',-7),(100,0,'2023-04-07 13:45:29',-1),(100,1,'2023-04-07 13:45:29',-1);

--
-- Table structure for table `ngn_articles_tags`
--

CREATE TABLE `ngn_articles_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 AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_tags`
--

INSERT INTO `ngn_articles_tags` VALUES (1,'2023-01-25 11:02:11','2023-01-25 11:02:11','2023-01-25 11:02:11',0,'2023-01-25 11:02:11',945,0);

--
-- Table structure for table `ngn_articles_tags_language`
--

CREATE TABLE `ngn_articles_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_articles_tags_language_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_articles_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_tags_language`
--

INSERT INTO `ngn_articles_tags_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Recipe_with Orange','','','','recipe_with-orange','');

--
-- Table structure for table `ngn_articles_tags_links`
--

CREATE TABLE `ngn_articles_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_articles_tags_links_ibfk_1` FOREIGN KEY (`tag_id`) REFERENCES `ngn_articles_tags` (`tag_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_tags_links`
--

INSERT INTO `ngn_articles_tags_links` VALUES (1,49,0);

--
-- Table structure for table `ngn_articles_topnews`
--

CREATE TABLE `ngn_articles_topnews` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_owner` int(11) NOT NULL DEFAULT 0,
  `news_createdate` datetime DEFAULT NULL,
  `news_showdate` datetime DEFAULT NULL,
  `news_hidedate` datetime DEFAULT NULL,
  `news_hide` tinyint(4) NOT NULL DEFAULT 0,
  `news_editdate` datetime DEFAULT NULL,
  `news_removedate` datetime NOT NULL,
  `news_category` int(11) NOT NULL DEFAULT 0,
  `news_enable` int(11) NOT NULL DEFAULT 0,
  `news_order` int(11) NOT NULL DEFAULT 0,
  `news_viewed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`),
  KEY `news_category` (`news_category`),
  KEY `news_enable` (`news_enable`),
  KEY `news_hide` (`news_hide`),
  KEY `news_order` (`news_order`),
  KEY `news_createdate` (`news_createdate`),
  KEY `news_editdate` (`news_editdate`),
  KEY `news_hidedate` (`news_hidedate`),
  KEY `news_showdate` (`news_showdate`),
  KEY `news_removedate` (`news_removedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_topnews`
--


--
-- Table structure for table `ngn_articles_topnews_language`
--

CREATE TABLE `ngn_articles_topnews_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,
  `language_photo1` varchar(200) NOT NULL,
  `language_photo2` varchar(200) NOT NULL,
  PRIMARY KEY (`news_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_topnews_language`
--


--
-- Table structure for table `ngn_articles_topnews_positions`
--

CREATE TABLE `ngn_articles_topnews_positions` (
  `news_id` int(11) NOT NULL,
  `element_id` int(11) NOT NULL,
  `dimX` int(11) NOT NULL,
  `dimY` int(11) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `linked_id` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`element_id`),
  KEY `linked_id` (`linked_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_articles_topnews_positions`
--


--
-- Table structure for table `ngn_articles_transfer`
--

CREATE TABLE `ngn_articles_transfer` (
  `transfer_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `filename` varchar(200) COLLATE utf8_bin NOT NULL,
  `hash_filename` varchar(200) COLLATE utf8_bin NOT NULL,
  `template` varchar(30) COLLATE utf8_bin NOT NULL,
  `status` varchar(20) COLLATE utf8_bin NOT NULL,
  `progress` int(11) NOT NULL DEFAULT 0,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  `editdate` datetime NOT NULL DEFAULT current_timestamp(),
  `enddate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `removedate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `type` varchar(20) COLLATE utf8_bin NOT NULL,
  `start_row` int(11) NOT NULL DEFAULT 0,
  `end_row` int(11) NOT NULL DEFAULT 0,
  `attempts` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`transfer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

--
-- Dumping data for table `ngn_articles_transfer`
--


--
-- Table structure for table `ngn_articles_transfer_queue`
--

CREATE TABLE `ngn_articles_transfer_queue` (
  `id` int(11) NOT NULL,
  `transfer_id` int(11) NOT NULL,
  `data` blob NOT NULL,
  `status` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`,`transfer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ngn_articles_transfer_queue`
--


--
-- Table structure for table `ngn_articles_videos`
--

CREATE TABLE `ngn_articles_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_articles_videos`
--


--
-- Table structure for table `ngn_articles_videos_language`
--

CREATE TABLE `ngn_articles_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_articles_videos_language`
--


--
-- Table structure for table `ngn_calculation`
--

CREATE TABLE `ngn_calculation` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_order` 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_hide` tinyint(4) NOT NULL DEFAULT 0,
  `news_editdate` datetime DEFAULT NULL,
  `news_removedate` datetime NOT NULL,
  `news_category` int(11) NOT NULL DEFAULT 0,
  `news_photo1` varchar(100) NOT NULL DEFAULT '',
  `news_photo2` varchar(100) NOT NULL DEFAULT '',
  `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_createdate` (`news_createdate`),
  KEY `news_editdate` (`news_editdate`),
  KEY `news_hidedate` (`news_hidedate`),
  KEY `news_showdate` (`news_showdate`),
  KEY `news_template` (`news_template`),
  KEY `news_removedate` (`news_removedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation`
--


--
-- Table structure for table `ngn_calculation_atribute`
--

CREATE TABLE `ngn_calculation_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` text 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) DEFAULT 0,
  `atribute_editdate` datetime NOT NULL,
  PRIMARY KEY (`atribute_id`),
  KEY `atribute_var` (`atribute_var`),
  KEY `atribute_var_2` (`atribute_var`),
  KEY `atribute_var_3` (`atribute_var`),
  KEY `atribute_var_4` (`atribute_var`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_atribute`
--

INSERT INTO `ngn_calculation_atribute` VALUES (1,0,NULL,'','','','',0,0,'_2','','','',0,'0000-00-00 00:00:00'),(2,7,NULL,'','','','',0,0,'','','','',0,'0000-00-00 00:00:00'),(3,7,NULL,'','','','',0,NULL,NULL,'','','',0,'0000-00-00 00:00:00'),(4,7,NULL,'','','','',0,NULL,NULL,'','','',0,'0000-00-00 00:00:00'),(5,7,NULL,'','','','',0,NULL,NULL,'','','',0,'0000-00-00 00:00:00'),(6,7,NULL,'','','','',0,NULL,NULL,'','','',0,'0000-00-00 00:00:00'),(7,7,NULL,'','','','',0,NULL,NULL,'','','',0,'0000-00-00 00:00:00');

--
-- Table structure for table `ngn_calculation_atribute_display`
--

CREATE TABLE `ngn_calculation_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_calculation_atribute_display`
--


--
-- Table structure for table `ngn_calculation_atribute_display_values`
--

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

--
-- Dumping data for table `ngn_calculation_atribute_display_values`
--


--
-- Table structure for table `ngn_calculation_atribute_display_values_language`
--

CREATE TABLE `ngn_calculation_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_calculation_atribute_display_values_language`
--


--
-- Table structure for table `ngn_calculation_atribute_language`
--

CREATE TABLE `ngn_calculation_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 `atribute_id` (`atribute_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_atribute_language`
--

INSERT INTO `ngn_calculation_atribute_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Poz','','','','',''),(2,1,'0000-00-00 00:00:00',0,0,'Akcija','','','','',''),(3,1,'0000-00-00 00:00:00',0,0,'Pogoj','','','','',''),(4,1,'0000-00-00 00:00:00',0,0,'Količina','','','','',''),(5,1,'0000-00-00 00:00:00',0,0,'X','','','','',''),(6,1,'0000-00-00 00:00:00',0,0,'Y','','','','',''),(7,1,'0000-00-00 00:00:00',0,0,'Z','','','','','');

--
-- Table structure for table `ngn_calculation_atribute_links`
--

CREATE TABLE `ngn_calculation_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 `news_id_idx` (`link_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_atribute_links`
--


--
-- Table structure for table `ngn_calculation_atribute_values`
--

CREATE TABLE `ngn_calculation_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) NOT 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 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_atribute_values`
--


--
-- Table structure for table `ngn_calculation_atribute_values_language`
--

CREATE TABLE `ngn_calculation_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 `value_id` (`value_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_atribute_values_language`
--


--
-- Table structure for table `ngn_calculation_categories`
--

CREATE TABLE `ngn_calculation_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_calculation_categories`
--


--
-- Table structure for table `ngn_calculation_category`
--

CREATE TABLE `ngn_calculation_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_photo2` int(11) NOT 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_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category`
--

INSERT INTO `ngn_calculation_category` VALUES (1,0,'2015-02-06 12:19:48','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'2015-02-06 12:19:48',0,0,'',0,0,0);

--
-- Table structure for table `ngn_calculation_category_file`
--

CREATE TABLE `ngn_calculation_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_calculation_category_file`
--


--
-- Table structure for table `ngn_calculation_category_files`
--

CREATE TABLE `ngn_calculation_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,
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_files`
--


--
-- Table structure for table `ngn_calculation_category_files_language`
--

CREATE TABLE `ngn_calculation_category_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_files_language`
--


--
-- Table structure for table `ngn_calculation_category_groups`
--

CREATE TABLE `ngn_calculation_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,
  PRIMARY KEY (`id`),
  KEY `group_id` (`group_id`),
  KEY `category_id` (`category_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_groups`
--


--
-- Table structure for table `ngn_calculation_category_groups_atribute`
--

CREATE TABLE `ngn_calculation_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`),
  KEY `language_id` (`language_id`),
  KEY `gaid` (`gaid`),
  KEY `cgid` (`cgid`),
  KEY `valueInt` (`valueInt`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_groups_atribute`
--


--
-- Table structure for table `ngn_calculation_category_groups_atribute_multi`
--

CREATE TABLE `ngn_calculation_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_calculation_category_groups_atribute_multi`
--


--
-- Table structure for table `ngn_calculation_category_language`
--

CREATE TABLE `ngn_calculation_category_language` (
  `category_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_language`
--

INSERT INTO `ngn_calculation_category_language` VALUES (1,1,0,0,'Glavna kategorija','','','','glavna-kategorija','');

--
-- Table structure for table `ngn_calculation_category_links`
--

CREATE TABLE `ngn_calculation_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_calculation_category_links`
--


--
-- Table structure for table `ngn_calculation_category_multi`
--

CREATE TABLE `ngn_calculation_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_calculation_category_multi_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_articles_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_multi`
--


--
-- Table structure for table `ngn_calculation_category_pages`
--

CREATE TABLE `ngn_calculation_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_calculation_category_pages`
--


--
-- Table structure for table `ngn_calculation_category_photo`
--

CREATE TABLE `ngn_calculation_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,
  PRIMARY KEY (`photo_id`),
  KEY `category_id` (`category_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_photo`
--


--
-- Table structure for table `ngn_calculation_category_photo_gallery`
--

CREATE TABLE `ngn_calculation_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_calculation_category_photo_gallery`
--


--
-- Table structure for table `ngn_calculation_category_photo_gallery_language`
--

CREATE TABLE `ngn_calculation_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_calculation_category_photo_gallery_language`
--


--
-- Table structure for table `ngn_calculation_category_photo_language`
--

CREATE TABLE `ngn_calculation_category_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_photo_language`
--


--
-- Table structure for table `ngn_calculation_category_roles`
--

CREATE TABLE `ngn_calculation_category_roles` (
  `role_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `category_edit` tinyint(11) NOT NULL DEFAULT 0,
  `category_delete` tinyint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`role_id`,`category_id`),
  KEY `category_id` (`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_category_roles`
--


--
-- Table structure for table `ngn_calculation_category_videos`
--

CREATE TABLE `ngn_calculation_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_calculation_category_videos`
--


--
-- Table structure for table `ngn_calculation_category_videos_language`
--

CREATE TABLE `ngn_calculation_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_calculation_category_videos_language`
--


--
-- Table structure for table `ngn_calculation_comments`
--

CREATE TABLE `ngn_calculation_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_calculation_comments`
--


--
-- Table structure for table `ngn_calculation_comments_admin`
--

CREATE TABLE `ngn_calculation_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_calculation_comments_admin`
--


--
-- Table structure for table `ngn_calculation_comments_files`
--

CREATE TABLE `ngn_calculation_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_calculation_comments_files`
--


--
-- Table structure for table `ngn_calculation_comments_files_language`
--

CREATE TABLE `ngn_calculation_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_calculation_comments_files_language_ibfk_1` FOREIGN KEY (`file_id`) REFERENCES `ngn_calculation_comments_files` (`file_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_comments_files_language`
--


--
-- Table structure for table `ngn_calculation_comments_language`
--

CREATE TABLE `ngn_calculation_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 `comment_id` (`comment_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_calculation_comments_language_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_calculation_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_comments_language`
--


--
-- Table structure for table `ngn_calculation_comments_votes`
--

CREATE TABLE `ngn_calculation_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_calculation_comments_votes_ibfk_1` FOREIGN KEY (`comment_id`) REFERENCES `ngn_calculation_comments` (`comment_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_comments_votes`
--


--
-- Table structure for table `ngn_calculation_custom_values`
--

CREATE TABLE `ngn_calculation_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_calculation_custom_values`
--


--
-- Table structure for table `ngn_calculation_custom_values_multi`
--

CREATE TABLE `ngn_calculation_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_calculation_custom_values_multi`
--


--
-- Table structure for table `ngn_calculation_file`
--

CREATE TABLE `ngn_calculation_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_calculation_file`
--


--
-- Table structure for table `ngn_calculation_files`
--

CREATE TABLE `ngn_calculation_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,
  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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_files`
--


--
-- Table structure for table `ngn_calculation_files_groups`
--

CREATE TABLE `ngn_calculation_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_calculation_files_groups`
--


--
-- Table structure for table `ngn_calculation_files_groups_language`
--

CREATE TABLE `ngn_calculation_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_calculation_files_groups_language`
--


--
-- Table structure for table `ngn_calculation_files_language`
--

CREATE TABLE `ngn_calculation_files_language` (
  `file_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_files_language`
--


--
-- Table structure for table `ngn_calculation_gallery`
--

CREATE TABLE `ngn_calculation_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_calculation_gallery`
--


--
-- Table structure for table `ngn_calculation_gallery_photo`
--

CREATE TABLE `ngn_calculation_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_calculation_gallery_photo`
--


--
-- Table structure for table `ngn_calculation_groups`
--

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

--
-- Dumping data for table `ngn_calculation_groups`
--

INSERT INTO `ngn_calculation_groups` VALUES (1,'');

--
-- Table structure for table `ngn_calculation_groups_atribute`
--

CREATE TABLE `ngn_calculation_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_calculation_groups_atribute_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `ngn_calculation_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_groups_atribute`
--

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

--
-- Table structure for table `ngn_calculation_groups_language`
--

CREATE TABLE `ngn_calculation_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 `atribute_id` (`group_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_groups_language`
--

INSERT INTO `ngn_calculation_groups_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Lastnosti','',NULL,NULL,NULL,'');

--
-- Table structure for table `ngn_calculation_item`
--

CREATE TABLE `ngn_calculation_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(4) 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 `item_category_2` (`item_category`),
  KEY `item_category_3` (`item_category`),
  KEY `item_category_4` (`item_category`),
  KEY `news_id` (`news_id`),
  KEY `item_enable` (`item_enable`)
) ENGINE=InnoDB AUTO_INCREMENT=143 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_item`
--

INSERT INTO `ngn_calculation_item` VALUES (1,1,1,0,'2022-03-28 10:38:34','2022-03-28 10:38:34','2022-03-28 10:38:34','2022-03-28 10:38:34',0,1,'','',0),(2,1,2,0,'2022-03-28 15:38:49','2022-03-28 15:38:49','2022-03-28 15:38:49','2022-03-28 15:38:49',0,1,'','',0),(3,1,3,0,'2022-03-30 15:14:46','2022-03-30 15:14:46','2022-03-30 15:14:46','2022-03-30 15:14:46',0,1,'','',0),(4,1,4,0,'2022-03-30 15:17:03','2022-03-30 15:17:03','2022-03-30 15:17:03','2022-03-30 15:17:03',0,1,'','',0),(5,1,5,0,'2022-03-30 15:18:29','2022-03-30 15:18:29','2022-03-30 15:18:29','2022-03-30 15:18:29',0,1,'','',0),(6,1,6,0,'2022-03-30 15:20:26','2022-03-30 15:20:26','2022-03-30 15:20:26','2022-03-30 15:20:26',0,1,'','',0),(7,1,7,0,'2022-03-30 15:21:28','2022-03-30 15:21:28','2022-03-30 15:21:28','2022-03-30 15:21:28',0,1,'','',0),(8,1,8,0,'2022-03-30 15:22:31','2022-03-30 15:22:31','2022-03-30 15:22:31','2022-03-30 15:22:31',0,1,'','',0),(9,1,9,0,'2022-03-30 15:26:09','2022-03-30 15:26:09','2022-03-30 15:26:09','2022-03-30 15:26:09',0,1,'','',0),(10,1,1,0,'2022-04-07 10:07:17','2022-04-07 10:07:17','2022-04-07 10:07:17','2022-04-07 10:07:17',0,1,'','',0),(11,1,1,0,'2022-04-08 13:13:56','2022-04-08 13:13:56','2022-04-08 13:13:56','2022-04-08 13:13:56',0,1,'','',0),(12,1,2,0,'2022-07-14 10:47:16','2022-07-14 10:47:16','2022-07-14 10:47:16','2022-07-14 10:47:16',0,1,'','',0),(13,1,6,0,'2022-07-14 10:47:18','2022-07-14 10:47:18','2022-07-14 10:47:18','2022-07-14 10:47:18',0,1,'','',0),(14,1,7,0,'2022-07-14 10:47:26','2022-07-14 10:47:26','2022-07-14 10:47:26','2022-07-14 10:47:26',0,1,'','',0),(15,1,3,0,'2022-07-14 10:47:45','2022-07-14 10:47:45','2022-07-14 10:47:45','2022-07-14 10:47:45',0,1,'','',0),(16,1,1,0,'2022-07-14 10:47:50','2022-07-14 10:47:50','2022-07-14 10:47:50','2022-07-14 10:47:50',0,1,'','',0),(17,1,11,0,'2022-08-11 11:27:12','2022-08-11 11:27:12','2022-08-11 11:27:12','2022-08-11 11:27:12',0,1,'','',0),(18,1,12,0,'2022-08-11 11:29:39','2022-08-11 11:29:39','2022-08-11 11:29:39','2022-08-11 11:29:39',0,1,'','',0),(19,1,13,0,'2022-08-11 11:31:05','2022-08-11 11:31:05','2022-08-11 11:31:05','2022-08-11 11:31:05',0,1,'','',0),(20,1,14,0,'2022-08-11 11:34:54','2022-08-11 11:34:54','2022-08-11 11:34:54','2022-08-11 11:34:54',0,1,'','',0),(21,1,15,0,'2022-08-11 11:36:51','2022-08-11 11:36:51','2022-08-11 11:36:51','2022-08-11 11:36:51',0,1,'','',0),(22,1,1,0,'2022-08-11 11:46:08','2022-08-11 11:46:08','2022-08-11 11:46:08','2022-08-11 11:46:08',0,1,'','',0),(23,1,16,0,'2022-08-11 11:51:23','2022-08-11 11:51:23','2022-08-11 11:51:23','2022-08-11 11:51:23',0,1,'','',0),(24,1,17,0,'2022-08-11 11:53:35','2022-08-11 11:53:35','2022-08-11 11:53:35','2022-08-11 11:53:35',0,1,'','',0),(25,1,18,0,'2022-08-11 11:54:41','2022-08-11 11:54:41','2022-08-11 11:54:41','2022-08-11 11:54:41',0,1,'','',0),(26,1,19,0,'2022-08-11 11:55:27','2022-08-11 11:55:27','2022-08-11 11:55:27','2022-08-11 11:55:27',0,1,'','',0),(27,1,20,0,'2022-08-11 11:56:10','2022-08-11 11:56:10','2022-08-11 11:56:10','2022-08-11 11:56:10',0,1,'','',0),(28,1,21,0,'2022-08-11 11:57:19','2022-08-11 11:57:19','2022-08-11 11:57:19','2022-08-11 11:57:19',0,1,'','',0),(29,1,22,0,'2022-08-11 11:58:10','2022-08-11 11:58:10','2022-08-11 11:58:10','2022-08-11 11:58:10',0,1,'','',0),(30,1,23,0,'2022-08-11 11:59:12','2022-08-11 11:59:12','2022-08-11 11:59:12','2022-08-11 11:59:12',0,1,'','',0),(31,1,24,0,'2022-08-11 12:03:14','2022-08-11 12:03:14','2022-08-11 12:03:14','2022-08-11 12:03:14',0,1,'','',0),(32,1,23,0,'2022-08-11 13:36:42','2022-08-11 13:36:42','2022-08-11 13:36:42','2022-08-11 13:36:42',0,1,'','',0),(33,1,25,0,'2022-08-11 13:49:32','2022-08-11 13:49:32','2022-08-11 13:49:32','2022-08-11 13:49:32',0,1,'','',0),(34,1,26,0,'2022-08-11 13:53:14','2022-08-11 13:53:14','2022-08-11 13:53:14','2022-08-11 13:53:14',0,1,'','',0),(35,1,27,0,'2022-08-11 13:54:20','2022-08-11 13:54:20','2022-08-11 13:54:20','2022-08-11 13:54:20',0,1,'','',0),(36,1,28,0,'2022-08-11 13:55:10','2022-08-11 13:55:10','2022-08-11 13:55:10','2022-08-11 13:55:10',0,1,'','',0),(37,1,29,0,'2022-08-11 13:55:57','2022-08-11 13:55:57','2022-08-11 13:55:57','2022-08-11 13:55:57',0,1,'','',0),(38,1,30,0,'2022-08-11 13:56:46','2022-08-11 13:56:46','2022-08-11 13:56:46','2022-08-11 13:56:46',0,1,'','',0),(39,1,31,0,'2022-08-11 13:57:39','2022-08-11 13:57:39','2022-08-11 13:57:39','2022-08-11 13:57:39',0,1,'','',0),(40,1,32,0,'2022-08-11 13:58:23','2022-08-11 13:58:23','2022-08-11 13:58:23','2022-08-11 13:58:23',0,1,'','',0),(41,1,33,0,'2022-08-11 13:59:05','2022-08-11 13:59:05','2022-08-11 13:59:05','2022-08-11 13:59:05',0,1,'','',0),(42,1,24,0,'2022-08-18 13:47:38','2022-08-18 13:47:38','2022-08-18 13:47:38','2022-08-18 13:47:38',0,1,'','',0),(43,1,24,0,'2022-08-18 13:50:18','2022-08-18 13:50:18','2022-08-18 13:50:18','2022-08-18 13:50:18',0,1,'','',0),(44,1,11,0,'2022-08-18 13:52:37','2022-08-18 13:52:37','2022-08-18 13:52:37','2022-08-18 13:52:37',0,1,'','',0),(45,1,34,0,'2022-08-18 14:21:06','2022-08-18 14:21:06','2022-08-18 14:21:06','2022-08-18 14:21:06',0,1,'','',0),(46,1,35,0,'2022-08-18 14:22:15','2022-08-18 14:22:15','2022-08-18 14:22:15','2022-08-18 14:22:15',0,1,'','',0),(47,1,36,0,'2022-08-18 14:23:03','2022-08-18 14:23:03','2022-08-18 14:23:03','2022-08-18 14:23:03',0,1,'','',0),(48,1,24,0,'2022-08-19 08:55:56','2022-08-19 08:55:56','2022-08-19 08:55:56','2022-08-19 08:55:56',0,1,'','',0),(49,1,24,0,'2022-08-19 09:09:57','2022-08-19 09:09:57','2022-08-19 09:09:57','2022-08-19 09:09:57',0,1,'','',0),(50,1,24,0,'2022-08-19 09:13:13','2022-08-19 09:13:13','2022-08-19 09:13:13','2022-08-19 09:13:13',0,1,'','',0),(51,1,24,0,'2022-08-22 09:33:43','2022-08-22 09:33:43','2022-08-22 09:33:43','2022-08-22 09:33:43',0,1,'','',0),(52,1,14,0,'2022-08-22 09:37:53','2022-08-22 09:37:53','2022-08-22 09:37:53','2022-08-22 09:37:53',0,1,'','',0),(53,1,14,0,'2022-08-22 09:38:29','2022-08-22 09:38:29','2022-08-22 09:38:29','2022-08-22 09:38:29',0,1,'','',0),(54,1,15,0,'2022-08-22 09:39:51','2022-08-22 09:39:51','2022-08-22 09:39:51','2022-08-22 09:39:51',0,1,'','',0),(55,1,25,0,'2022-08-22 09:40:08','2022-08-22 09:40:08','2022-08-22 09:40:08','2022-08-22 09:40:08',0,1,'','',0),(56,1,22,0,'2022-08-22 11:21:40','2022-08-22 11:21:40','2022-08-22 11:21:40','2022-08-22 11:21:40',0,1,'','',0),(57,1,22,0,'2022-08-22 11:23:16','2022-08-22 11:23:16','2022-08-22 11:23:16','2022-08-22 11:23:16',0,1,'','',0),(58,1,22,0,'2022-08-22 11:23:35','2022-08-22 11:23:35','2022-08-22 11:23:35','2022-08-22 11:23:35',0,1,'','',0),(59,1,22,0,'2022-08-22 11:23:37','2022-08-22 11:23:37','2022-08-22 11:23:37','2022-08-22 11:23:37',0,1,'','',0),(60,1,22,0,'2022-08-22 11:24:07','2022-08-22 11:24:07','2022-08-22 11:24:07','2022-08-22 11:24:07',0,1,'','',0),(61,1,27,0,'2022-08-22 11:53:30','2022-08-22 11:53:30','2022-08-22 11:53:30','2022-08-22 11:53:30',0,1,'','',0),(62,1,29,0,'2022-08-22 11:53:41','2022-08-22 11:53:41','2022-08-22 11:53:41','2022-08-22 11:53:41',0,1,'','',0),(63,1,26,0,'2022-08-22 11:53:52','2022-08-22 11:53:52','2022-08-22 11:53:52','2022-08-22 11:53:52',0,1,'','',0),(64,1,28,0,'2022-08-22 11:54:02','2022-08-22 11:54:02','2022-08-22 11:54:02','2022-08-22 11:54:02',0,1,'','',0),(65,1,30,0,'2022-08-22 11:54:14','2022-08-22 11:54:14','2022-08-22 11:54:14','2022-08-22 11:54:14',0,1,'','',0),(66,1,37,0,'2022-08-24 11:08:05','2022-08-24 11:08:05','2022-08-24 11:08:05','2022-08-24 11:08:05',0,1,'','',0),(67,1,38,0,'2022-08-24 11:09:41','2022-08-24 11:09:41','2022-08-24 11:09:41','2022-08-24 11:09:41',0,1,'','',0),(68,1,39,0,'2022-08-24 11:10:41','2022-08-24 11:10:41','2022-08-24 11:10:41','2022-08-24 11:10:41',0,1,'','',0),(69,1,40,0,'2022-08-24 11:12:53','2022-08-24 11:12:53','2022-08-24 11:12:53','2022-08-24 11:12:53',0,1,'','',0),(70,1,41,0,'2022-08-24 11:13:47','2022-08-24 11:13:47','2022-08-24 11:13:47','2022-08-24 11:13:47',0,1,'','',0),(71,1,42,0,'2022-08-24 11:14:39','2022-08-24 11:14:39','2022-08-24 11:14:39','2022-08-24 11:14:39',0,1,'','',0),(72,1,43,0,'2022-08-24 11:16:03','2022-08-24 11:16:03','2022-08-24 11:16:03','2022-08-24 11:16:03',0,1,'','',0),(73,1,44,0,'2022-08-24 11:17:11','2022-08-24 11:17:11','2022-08-24 11:17:11','2022-08-24 11:17:11',0,1,'','',0),(74,1,45,0,'2022-08-24 11:20:10','2022-08-24 11:20:10','2022-08-24 11:20:10','2022-08-24 11:20:10',0,1,'','',0),(75,1,46,0,'2022-08-24 11:21:13','2022-08-24 11:21:13','2022-08-24 11:21:13','2022-08-24 11:21:13',0,1,'','',0),(76,1,47,0,'2022-08-24 11:24:01','2022-08-24 11:24:01','2022-08-24 11:24:01','2022-08-24 11:24:01',0,1,'','',0),(77,1,48,0,'2022-08-24 11:24:43','2022-08-24 11:24:43','2022-08-24 11:24:43','2022-08-24 11:24:43',0,1,'','',0),(78,1,49,0,'2022-08-24 11:26:31','2022-08-24 11:26:31','2022-08-24 11:26:31','2022-08-24 11:26:31',0,1,'','',0),(79,1,50,0,'2022-08-24 11:27:28','2022-08-24 11:27:28','2022-08-24 11:27:28','2022-08-24 11:27:28',0,1,'','',0),(80,1,51,0,'2022-08-24 11:28:26','2022-08-24 11:28:26','2022-08-24 11:28:26','2022-08-24 11:28:26',0,1,'','',0),(81,1,52,0,'2022-08-24 11:30:03','2022-08-24 11:30:03','2022-08-24 11:30:03','2022-08-24 11:30:03',0,1,'','',0),(82,1,53,0,'2022-08-24 11:30:47','2022-08-24 11:30:47','2022-08-24 11:30:47','2022-08-24 11:30:47',0,1,'','',0),(83,1,54,0,'2022-08-24 11:32:23','2022-08-24 11:32:23','2022-08-24 11:32:23','2022-08-24 11:32:23',0,1,'','',0),(84,1,55,0,'2022-08-24 11:33:09','2022-08-24 11:33:09','2022-08-24 11:33:09','2022-08-24 11:33:09',0,1,'','',0),(85,1,56,0,'2022-08-24 11:34:43','2022-08-24 11:34:43','2022-08-24 11:34:43','2022-08-24 11:34:43',0,1,'','',0),(86,1,57,0,'2022-08-24 11:35:27','2022-08-24 11:35:27','2022-08-24 11:35:27','2022-08-24 11:35:27',0,1,'','',0),(87,1,58,0,'2022-08-24 11:42:55','2022-08-24 11:42:55','2022-08-24 11:42:55','2022-08-24 11:42:55',0,1,'','',0),(88,1,59,0,'2022-08-24 11:43:46','2022-08-24 11:43:46','2022-08-24 11:43:46','2022-08-24 11:43:46',0,1,'','',0),(89,1,60,0,'2022-08-24 11:46:06','2022-08-24 11:46:06','2022-08-24 11:46:06','2022-08-24 11:46:06',0,1,'','',0),(90,1,61,0,'2022-08-24 11:47:26','2022-08-24 11:47:26','2022-08-24 11:47:26','2022-08-24 11:47:26',0,1,'','',0),(91,1,62,0,'2022-08-24 11:48:27','2022-08-24 11:48:27','2022-08-24 11:48:27','2022-08-24 11:48:27',0,1,'','',0),(92,1,63,0,'2022-08-24 11:48:58','2022-08-24 11:48:58','2022-08-24 11:48:58','2022-08-24 11:48:58',0,1,'','',0),(93,1,64,0,'2022-08-24 11:49:22','2022-08-24 11:49:22','2022-08-24 11:49:22','2022-08-24 11:49:22',0,1,'','',0),(94,1,65,0,'2022-08-24 14:13:01','2022-08-24 14:13:01','2022-08-24 14:13:01','2022-08-24 14:13:01',0,1,'','',0),(95,1,66,0,'2022-08-24 14:16:59','2022-08-24 14:16:59','2022-08-24 14:16:59','2022-08-24 14:16:59',0,1,'','',0),(96,1,67,0,'2022-08-24 14:18:06','2022-08-24 14:18:06','2022-08-24 14:18:06','2022-08-24 14:18:06',0,1,'','',0),(97,1,68,0,'2022-08-24 14:19:17','2022-08-24 14:19:17','2022-08-24 14:19:17','2022-08-24 14:19:17',0,1,'','',0),(98,1,69,0,'2022-08-24 14:20:26','2022-08-24 14:20:26','2022-08-24 14:20:26','2022-08-24 14:20:26',0,1,'','',0),(99,1,70,0,'2022-08-24 14:24:19','2022-08-24 14:24:19','2022-08-24 14:24:19','2022-08-24 14:24:19',0,1,'','',0),(100,1,71,0,'2022-08-24 14:25:34','2022-08-24 14:25:34','2022-08-24 14:25:34','2022-08-24 14:25:34',0,1,'','',0),(101,1,63,0,'2022-09-28 15:43:36','2022-09-28 15:43:36','2022-09-28 15:43:36','2022-09-28 15:43:36',0,1,'','',0),(102,1,72,0,'2022-10-13 15:26:35','2022-10-13 15:26:35','2022-10-13 15:26:35','2022-10-13 15:26:35',0,1,'','',0),(103,1,73,0,'2022-10-17 09:21:41','2022-10-17 09:21:41','2022-10-17 09:21:41','2022-10-17 09:21:41',0,1,'','',0),(104,1,74,0,'2022-10-17 11:23:56','2022-10-17 11:23:56','2022-10-17 11:23:56','2022-10-17 11:23:56',0,1,'','',0),(105,1,75,0,'2022-10-21 15:22:24','2022-10-21 15:22:24','2022-10-21 15:22:24','2022-10-21 15:22:24',0,1,'','',0),(106,1,76,0,'2022-10-21 15:25:21','2022-10-21 15:25:21','2022-10-21 15:25:21','2022-10-21 15:25:21',0,1,'','',0),(107,1,77,0,'2022-10-21 15:27:29','2022-10-21 15:27:29','2022-10-21 15:27:29','2022-10-21 15:27:29',0,1,'','',0),(108,1,78,0,'2022-10-21 15:28:33','2022-10-21 15:28:33','2022-10-21 15:28:33','2022-10-21 15:28:33',0,1,'','',0),(109,1,79,0,'2022-10-21 15:57:59','2022-10-21 15:57:59','2022-10-21 15:57:59','2022-10-21 15:57:59',0,1,'','',0),(110,1,80,0,'2022-10-21 15:58:52','2022-10-21 15:58:52','2022-10-21 15:58:52','2022-10-21 15:58:52',0,1,'','',0),(111,1,81,0,'2022-10-21 16:00:25','2022-10-21 16:00:25','2022-10-21 16:00:25','2022-10-21 16:00:25',0,1,'','',0),(112,1,82,0,'2022-10-25 15:20:30','2022-10-25 15:20:30','2022-10-25 15:20:30','2022-10-25 15:20:30',0,1,'','',0),(113,1,83,0,'2022-10-25 15:23:07','2022-10-25 15:23:07','2022-10-25 15:23:07','2022-10-25 15:23:07',0,1,'','',0),(114,1,84,0,'2022-10-28 11:47:31','2022-10-28 11:47:31','2022-10-28 11:47:31','2022-10-28 11:47:31',0,1,'','',0),(115,1,85,0,'2022-11-09 11:07:32','2022-11-09 11:07:32','2022-11-09 11:07:32','2022-11-09 11:07:32',0,1,'','',0),(116,1,86,0,'2022-11-09 11:08:58','2022-11-09 11:08:58','2022-11-09 11:08:58','2022-11-09 11:08:58',0,1,'','',0),(117,1,87,0,'2023-01-06 09:59:54','2023-01-06 09:59:54','2023-01-06 09:59:54','2023-01-06 09:59:54',0,1,'','',0),(118,1,88,0,'2023-01-06 10:13:00','2023-01-06 10:13:00','2023-01-06 10:13:00','2023-01-06 10:13:00',0,1,'','',0),(119,1,89,0,'2023-01-06 10:18:37','2023-01-06 10:18:37','2023-01-06 10:18:37','2023-01-06 10:18:37',0,1,'','',0),(120,1,90,0,'2023-01-06 10:42:34','2023-01-06 10:42:34','2023-01-06 10:42:34','2023-01-06 10:42:34',0,1,'','',0),(121,1,91,0,'2023-01-06 10:50:41','2023-01-06 10:50:41','2023-01-06 10:50:41','2023-01-06 10:50:41',0,1,'','',0),(122,1,92,0,'2023-01-06 11:19:53','2023-01-06 11:19:53','2023-01-06 11:19:53','2023-01-06 11:19:53',0,1,'','',0),(123,1,93,0,'2023-01-06 12:09:24','2023-01-06 12:09:24','2023-01-06 12:09:24','2023-01-06 12:09:24',0,1,'','',0),(124,1,94,0,'2023-01-06 12:52:08','2023-01-06 12:52:08','2023-01-06 12:52:08','2023-01-06 12:52:08',0,1,'','',0),(125,1,95,0,'2023-01-06 13:06:07','2023-01-06 13:06:07','2023-01-06 13:06:07','2023-01-06 13:06:07',0,1,'','',0),(126,1,96,0,'2023-01-06 13:50:37','2023-01-06 13:50:37','2023-01-06 13:50:37','2023-01-06 13:50:37',0,1,'','',0),(127,1,97,0,'2023-01-06 13:54:56','2023-01-06 13:54:56','2023-01-06 13:54:56','2023-01-06 13:54:56',0,1,'','',0),(128,1,98,0,'2023-01-06 14:22:05','2023-01-06 14:22:05','2023-01-06 14:22:05','2023-01-06 14:22:05',0,1,'','',0),(129,1,99,0,'2023-01-06 15:24:23','2023-01-06 15:24:23','2023-01-06 15:24:23','2023-01-06 15:24:23',0,1,'','',0),(130,1,95,0,'2023-01-09 11:12:43','2023-01-09 11:12:43','2023-01-09 11:12:43','2023-01-09 11:12:43',0,1,'','',0),(131,1,100,0,'2023-01-09 12:00:45','2023-01-09 12:00:45','2023-01-09 12:00:45','2023-01-09 12:00:45',0,1,'','',0),(132,1,99,0,'2023-01-09 13:49:40','2023-01-09 13:49:40','2023-01-09 13:49:40','2023-01-09 13:49:40',0,1,'','',0),(133,1,101,0,'2023-01-17 11:00:26','2023-01-17 11:00:26','2023-01-17 11:00:26','2023-01-17 11:00:26',0,1,'','',0),(134,1,102,0,'2023-01-23 15:02:30','2023-01-23 15:02:30','2023-01-23 15:02:30','2023-01-23 15:02:30',0,1,'','',0),(135,1,103,0,'2023-02-07 10:44:12','2023-02-07 10:44:12','2023-02-07 10:44:12','2023-02-07 10:44:12',0,1,'','',0),(136,1,104,0,'2023-02-14 09:54:31','2023-02-14 09:54:31','2023-02-14 09:54:31','2023-02-14 09:54:31',0,1,'','',0),(137,1,95,0,'2023-04-07 13:39:17','2023-04-07 13:39:17','2023-04-07 13:39:17','2023-04-07 13:39:17',0,1,'','',0),(138,1,105,0,'2023-04-07 14:09:05','2023-04-07 14:09:05','2023-04-07 14:09:05','2023-04-07 14:09:05',0,1,'','',0),(139,1,106,0,'2023-04-24 10:27:52','2023-04-24 10:27:52','2023-04-24 10:27:52','2023-04-24 10:27:52',0,1,'','',0),(140,1,107,0,'2023-05-31 08:19:51','2023-05-31 08:19:51','2023-05-31 08:19:51','2023-05-31 08:19:51',0,1,'','',0),(141,1,108,0,'2023-05-31 08:25:07','2023-05-31 08:25:07','2023-05-31 08:25:07','2023-05-31 08:25:07',0,1,'','',0),(142,1,109,0,'2023-05-31 08:27:58','2023-05-31 08:27:58','2023-05-31 08:27:58','2023-05-31 08:27:58',0,1,'','',0);

--
-- Table structure for table `ngn_calculation_item_category`
--

CREATE TABLE `ngn_calculation_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_createdate` (`category_createdate`),
  KEY `category_editdate` (`category_editdate`),
  KEY `category_hidedate` (`category_hidedate`),
  KEY `category_showdate` (`category_showdate`),
  KEY `category_createdate_2` (`category_createdate`),
  KEY `category_editdate_2` (`category_editdate`),
  KEY `category_hidedate_2` (`category_hidedate`),
  KEY `category_showdate_2` (`category_showdate`),
  KEY `category_createdate_3` (`category_createdate`),
  KEY `category_editdate_3` (`category_editdate`),
  KEY `category_hidedate_3` (`category_hidedate`),
  KEY `category_showdate_3` (`category_showdate`),
  KEY `category_createdate_4` (`category_createdate`),
  KEY `category_editdate_4` (`category_editdate`),
  KEY `category_hidedate_4` (`category_hidedate`),
  KEY `category_showdate_4` (`category_showdate`),
  KEY `category_createdate_5` (`category_createdate`),
  KEY `category_editdate_5` (`category_editdate`),
  KEY `category_hidedate_5` (`category_hidedate`),
  KEY `category_showdate_5` (`category_showdate`),
  KEY `category_createdate_6` (`category_createdate`),
  KEY `category_editdate_6` (`category_editdate`),
  KEY `category_hidedate_6` (`category_hidedate`),
  KEY `category_showdate_6` (`category_showdate`),
  KEY `category_createdate_7` (`category_createdate`),
  KEY `category_editdate_7` (`category_editdate`),
  KEY `category_hidedate_7` (`category_hidedate`),
  KEY `category_showdate_7` (`category_showdate`),
  KEY `category_template` (`category_template`),
  KEY `category_template_news` (`category_template_news`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_item_category`
--

INSERT INTO `ngn_calculation_item_category` VALUES (1,0,'2015-02-06 12:28:10','0000-00-00 00:00:00','0000-00-00 00:00:00',0,'0000-00-00 00:00:00',0,0,'',0,0);

--
-- Table structure for table `ngn_calculation_item_category_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_category_language`
--

INSERT INTO `ngn_calculation_item_category_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'Kategorija pozicij','','','','kategorija-pozicij','');

--
-- Table structure for table `ngn_calculation_item_custom_values`
--

CREATE TABLE `ngn_calculation_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 `category_id` (`item_category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`),
  KEY `valueInt_2` (`valueInt`),
  KEY `valueInt_3` (`valueInt`),
  KEY `valueInt_4` (`valueInt`),
  KEY `valueInt_5` (`valueInt`),
  KEY `valueInt_6` (`valueInt`),
  CONSTRAINT `ngn_calculation_item_custom_values_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ngn_calculation_item_variations` (`variations_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_item_custom_values`
--

INSERT INTO `ngn_calculation_item_custom_values` VALUES (1,1,1,1,0,0,0,'price.ARTICLE'),(1,1,3,1,0,0,0,'PRICE(&quot;&quot;);\nVALUE([m]);'),(1,1,5,1,0,0,0,'1'),(1,1,6,1,0,0,0,''),(1,1,7,1,0,0,0,''),(1,1,8,1,0,0,0,''),(2,1,1,1,0,0,0,'price.test'),(2,1,3,1,0,0,0,'1'),(2,1,5,1,0,0,0,'1'),(2,1,6,1,0,0,0,''),(2,1,7,1,0,0,0,''),(2,1,8,1,0,0,0,''),(3,1,1,1,0,0,0,'price.TESTER'),(3,1,3,1,0,0,0,'test'),(3,1,5,1,0,0,0,'1'),(3,1,6,1,0,0,0,''),(3,1,7,1,0,0,0,''),(3,1,8,1,0,0,0,''),(4,1,1,1,0,0,0,'price.OIL_BE'),(4,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(4,1,5,1,0,0,0,'[m]'),(4,1,6,1,0,0,0,''),(4,1,7,1,0,0,0,''),(4,1,8,1,0,0,0,''),(5,1,1,1,0,0,0,'price.GIFTBOX'),(5,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(5,1,5,1,0,0,0,'[m]'),(5,1,6,1,0,0,0,''),(5,1,7,1,0,0,0,''),(5,1,8,1,0,0,0,'[giftbox]'),(7,1,1,1,0,0,0,'price.OIL'),(7,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE([m]);\nTYPE(0);'),(7,1,5,1,0,0,0,'1'),(7,1,6,1,0,0,0,''),(7,1,7,1,0,0,0,''),(7,1,8,1,0,0,0,''),(9,1,1,1,0,0,0,'price.OIL_CUV'),(9,1,3,1,0,0,0,'PRICE(&quot;OIL-CUV-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-CUV-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(9,1,5,1,0,0,0,'[m]'),(9,1,6,1,0,0,0,''),(9,1,7,1,0,0,0,''),(9,1,8,1,0,0,0,''),(10,1,1,1,0,0,0,'price.GIFTBOX'),(10,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(10,1,5,1,0,0,0,'[m]'),(10,1,6,1,0,0,0,''),(10,1,7,1,0,0,0,''),(10,1,8,1,0,0,0,'[giftbox]'),(15,1,1,1,0,0,0,'price.OIL_TRU'),(15,1,3,1,0,0,0,'PRICE(&quot;OIL-TRU-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-TRU-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(15,1,5,1,0,0,0,'[m]'),(15,1,6,1,0,0,0,''),(15,1,7,1,0,0,0,''),(15,1,8,1,0,0,0,''),(16,1,1,1,0,0,0,'price.GIFTBOX'),(16,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(16,1,5,1,0,0,0,'[m]'),(16,1,6,1,0,0,0,''),(16,1,7,1,0,0,0,''),(16,1,8,1,0,0,0,'[giftbox]'),(18,1,1,1,0,0,0,'price.OIL_LEM'),(18,1,3,1,0,0,0,'PRICE(&quot;OIL-LEM-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-LEM-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(18,1,5,1,0,0,0,'[m]'),(18,1,6,1,0,0,0,''),(18,1,7,1,0,0,0,''),(18,1,8,1,0,0,0,''),(19,1,1,1,0,0,0,'price.GIFTBOX'),(19,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(19,1,5,1,0,0,0,'[m]'),(19,1,6,1,0,0,0,''),(19,1,7,1,0,0,0,''),(19,1,8,1,0,0,0,'[giftbox]'),(21,1,1,1,0,0,0,'price.OIL_CHI'),(21,1,3,1,0,0,0,'PRICE(&quot;OIL-CHI-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-CHI-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(21,1,5,1,0,0,0,'[m]'),(21,1,6,1,0,0,0,''),(21,1,7,1,0,0,0,''),(21,1,8,1,0,0,0,''),(22,1,1,1,0,0,0,'price.GIFTBOX'),(22,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(22,1,5,1,0,0,0,'[m]'),(22,1,6,1,0,0,0,''),(22,1,7,1,0,0,0,''),(22,1,8,1,0,0,0,'[giftbox]'),(24,1,1,1,0,0,0,'price.OIL_GAR'),(24,1,3,1,0,0,0,'PRICE(&quot;OIL-GAR-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-GAR-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(24,1,5,1,0,0,0,'[m]'),(24,1,6,1,0,0,0,''),(24,1,7,1,0,0,0,''),(24,1,8,1,0,0,0,''),(25,1,1,1,0,0,0,'price.GIFTBOX'),(25,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(25,1,5,1,0,0,0,'[m]'),(25,1,6,1,0,0,0,''),(25,1,7,1,0,0,0,''),(25,1,8,1,0,0,0,'[giftbox]'),(30,1,1,1,0,0,0,'price.OIL_BE'),(30,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(30,1,5,1,0,0,0,'[m]'),(30,1,6,1,0,0,0,''),(30,1,7,1,0,0,0,''),(30,1,8,1,0,0,0,''),(31,1,1,1,0,0,0,'price.GIFTBOX'),(31,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(31,1,5,1,0,0,0,'[m]'),(31,1,6,1,0,0,0,''),(31,1,7,1,0,0,0,''),(31,1,8,1,0,0,0,'[giftbox]'),(33,1,1,1,0,0,0,'price.OIL_BE'),(33,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(33,1,5,1,0,0,0,'[m]'),(33,1,6,1,0,0,0,''),(33,1,7,1,0,0,0,''),(33,1,8,1,0,0,0,''),(34,1,1,1,0,0,0,'price.GIFTBOX'),(34,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(34,1,5,1,0,0,0,'[m]'),(34,1,6,1,0,0,0,''),(34,1,7,1,0,0,0,''),(34,1,8,1,0,0,0,'[giftbox]'),(36,1,1,1,0,0,0,'price.OIL_BE'),(36,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(36,1,5,1,0,0,0,'[m]'),(36,1,6,1,0,0,0,''),(36,1,7,1,0,0,0,''),(36,1,8,1,0,0,0,''),(37,1,1,1,0,0,0,'price.GIFTBOX'),(37,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(37,1,5,1,0,0,0,'[m]'),(37,1,6,1,0,0,0,''),(37,1,7,1,0,0,0,''),(37,1,8,1,0,0,0,'[giftbox]'),(42,1,1,1,0,0,0,'price.OIL_BE'),(42,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(42,1,5,1,0,0,0,'[m]'),(42,1,6,1,0,0,0,''),(42,1,7,1,0,0,0,''),(42,1,8,1,0,0,0,''),(43,1,1,1,0,0,0,'price.GIFTBOX'),(43,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(43,1,5,1,0,0,0,'[m]'),(43,1,6,1,0,0,0,''),(43,1,7,1,0,0,0,''),(43,1,8,1,0,0,0,'[giftbox]'),(45,1,1,1,0,0,0,'price.OIL_GOL'),(45,1,3,1,0,0,0,'PRICE(&quot;OIL-GOL-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-GOL-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(45,1,5,1,0,0,0,'[m]'),(45,1,6,1,0,0,0,''),(45,1,7,1,0,0,0,''),(45,1,8,1,0,0,0,''),(46,1,1,1,0,0,0,'price.GIFTBOX'),(46,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(46,1,5,1,0,0,0,'[m]'),(46,1,6,1,0,0,0,''),(46,1,7,1,0,0,0,''),(46,1,8,1,0,0,0,'[giftbox]'),(48,1,1,1,0,0,0,'price.OIL_BE'),(48,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(48,1,5,1,0,0,0,'[m]'),(48,1,6,1,0,0,0,''),(48,1,7,1,0,0,0,''),(48,1,8,1,0,0,0,''),(49,1,1,1,0,0,0,'price.GIFTBOX'),(49,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(49,1,5,1,0,0,0,'[m]'),(49,1,6,1,0,0,0,''),(49,1,7,1,0,0,0,''),(49,1,8,1,0,0,0,'[giftbox]'),(52,1,1,1,0,0,0,'price.OIL_OLO'),(52,1,3,1,0,0,0,'PRICE(&quot;OIL-OLO-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-OLO-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(52,1,5,1,0,0,0,'[m]'),(52,1,6,1,0,0,0,''),(52,1,7,1,0,0,0,''),(52,1,8,1,0,0,0,''),(53,1,1,1,0,0,0,'price.GIFTBOX'),(53,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(53,1,5,1,0,0,0,'[m]'),(53,1,6,1,0,0,0,''),(53,1,7,1,0,0,0,''),(53,1,8,1,0,0,0,'[giftbox]'),(55,1,1,1,0,0,0,'price.OIL_ORA'),(55,1,3,1,0,0,0,'PRICE(&quot;OIL-ORA-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-ORA-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(55,1,5,1,0,0,0,'[m]'),(55,1,6,1,0,0,0,''),(55,1,7,1,0,0,0,''),(55,1,8,1,0,0,0,''),(56,1,1,1,0,0,0,'price.GIFTBOX'),(56,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(56,1,5,1,0,0,0,'[m]'),(56,1,6,1,0,0,0,''),(56,1,7,1,0,0,0,''),(56,1,8,1,0,0,0,'[giftbox]'),(58,1,1,1,0,0,0,'price.OIL_POI'),(58,1,3,1,0,0,0,'PRICE(&quot;OIL-POI-0500&quot;);\nNAME(&quot;OIL-IBE&quot;);\nVALUE(1);'),(58,1,5,1,0,0,0,'[m]'),(58,1,6,1,0,0,0,''),(58,1,7,1,0,0,0,''),(58,1,8,1,0,0,0,''),(59,1,1,1,0,0,0,'price.GIFTBOX_POISON'),(59,1,3,1,0,0,0,'PRICE(&quot;GIFTBOX-POISON&quot;);\nVALUE(1);'),(59,1,5,1,0,0,0,'[m]'),(59,1,6,1,0,0,0,''),(59,1,7,1,0,0,0,''),(59,1,8,1,0,0,0,'[poison_giftbox]'),(61,1,1,1,0,0,0,'price.OIL_HER'),(61,1,3,1,0,0,0,'PRICE(&quot;OIL-HER-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-HER-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(61,1,5,1,0,0,0,'[m]'),(61,1,6,1,0,0,0,''),(61,1,7,1,0,0,0,''),(61,1,8,1,0,0,0,''),(62,1,1,1,0,0,0,'price.GIFTBOX'),(62,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(62,1,5,1,0,0,0,'[m]'),(62,1,6,1,0,0,0,''),(62,1,7,1,0,0,0,''),(62,1,8,1,0,0,0,'[giftbox]'),(67,1,1,1,0,0,0,'price.OIL_BE'),(67,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(67,1,5,1,0,0,0,'[m]'),(67,1,6,1,0,0,0,''),(67,1,7,1,0,0,0,''),(67,1,8,1,0,0,0,''),(68,1,1,1,0,0,0,'price.GIFTBOX'),(68,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(68,1,5,1,0,0,0,'[m]'),(68,1,6,1,0,0,0,''),(68,1,7,1,0,0,0,''),(68,1,8,1,0,0,0,'[giftbox]'),(70,1,1,1,0,0,0,'price.test'),(70,1,3,1,0,0,0,'233'),(70,1,5,1,0,0,0,''),(70,1,6,1,0,0,0,''),(70,1,7,1,0,0,0,''),(70,1,8,1,0,0,0,''),(71,1,1,1,0,0,0,'price.OIL_BE'),(71,1,3,1,0,0,0,'PRICE(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-IBE-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(71,1,5,1,0,0,0,'[m]'),(71,1,6,1,0,0,0,''),(71,1,7,1,0,0,0,''),(71,1,8,1,0,0,0,''),(72,1,1,1,0,0,0,'price.GIFTBOX'),(72,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(72,1,5,1,0,0,0,'[m]'),(72,1,6,1,0,0,0,''),(72,1,7,1,0,0,0,''),(72,1,8,1,0,0,0,'[giftbox]'),(74,1,1,1,0,0,0,'price.tester'),(74,1,3,1,0,0,0,'1'),(74,1,5,1,0,0,0,''),(74,1,6,1,0,0,0,''),(74,1,7,1,0,0,0,''),(74,1,8,1,0,0,0,''),(75,1,1,1,0,0,0,'price.OIL_ONI'),(75,1,3,1,0,0,0,'PRICE(&quot;OIL-ONI-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-ONI-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(75,1,5,1,0,0,0,'[m]'),(75,1,6,1,0,0,0,''),(75,1,7,1,0,0,0,''),(75,1,8,1,0,0,0,''),(76,1,1,1,0,0,0,'price.GIFTBOX'),(76,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(76,1,5,1,0,0,0,'[m]'),(76,1,6,1,0,0,0,''),(76,1,7,1,0,0,0,''),(76,1,8,1,0,0,0,'[giftbox]'),(78,1,1,1,0,0,0,'price.OIL_AME'),(78,1,3,1,0,0,0,'PRICE(&quot;OIL-AME-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nNAME(&quot;OIL-AME-&quot; . str_replace(&quot;L&quot;, &quot;&quot;, [article_packaging]));\nVALUE(1);'),(78,1,5,1,0,0,0,'[m]'),(78,1,6,1,0,0,0,''),(78,1,7,1,0,0,0,''),(78,1,8,1,0,0,0,''),(79,1,1,1,0,0,0,'price.GIFTBOX'),(79,1,3,1,0,0,0,'PRICE(&quot;OIL-GIFTBOX&quot;);\nVALUE(1);'),(79,1,5,1,0,0,0,'[m]'),(79,1,6,1,0,0,0,''),(79,1,7,1,0,0,0,''),(79,1,8,1,0,0,0,'[giftbox]');

--
-- Table structure for table `ngn_calculation_item_custom_values_multi`
--

CREATE TABLE `ngn_calculation_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_calculation_item_custom_values_multi`
--


--
-- Table structure for table `ngn_calculation_item_file`
--

CREATE TABLE `ngn_calculation_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_calculation_item_file`
--


--
-- Table structure for table `ngn_calculation_item_files`
--

CREATE TABLE `ngn_calculation_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 `news_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_calculation_item_files`
--


--
-- Table structure for table `ngn_calculation_item_files_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_files_language`
--


--
-- Table structure for table `ngn_calculation_item_groups`
--

CREATE TABLE `ngn_calculation_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 `category_id` (`item_category_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_item_groups`
--

INSERT INTO `ngn_calculation_item_groups` VALUES (1,1,1,0,1,0);

--
-- Table structure for table `ngn_calculation_item_groups_atribute`
--

CREATE TABLE `ngn_calculation_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_calculation_item_groups_atribute`
--


--
-- Table structure for table `ngn_calculation_item_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_language`
--

INSERT INTO `ngn_calculation_item_language` VALUES (1,1,'0000-00-00 00:00:00',1,0,'Istrska belica','','','','','','',''),(2,1,'0000-00-00 00:00:00',1,0,'Cuv&eacute;e - 2','','','','','','',''),(3,1,'0000-00-00 00:00:00',1,0,'Gold - 3','','','','','','',''),(4,1,'0000-00-00 00:00:00',1,0,'Truffle','','','','','','',''),(5,1,'0000-00-00 00:00:00',1,0,'Lemon','','','','','','',''),(6,1,'0000-00-00 00:00:00',1,0,'Chili - 6','','','','','','',''),(7,1,'0000-00-00 00:00:00',1,0,'Garlic - 7','','','','','','',''),(8,1,'0000-00-00 00:00:00',1,0,'Za otroke - 8','','','','','','',''),(9,1,'0000-00-00 00:00:00',1,0,'Lisjak - 9','','','','','','',''),(10,1,'0000-00-00 00:00:00',1,0,'Istrska belica - 1','','','','','','',''),(11,1,'0000-00-00 00:00:00',1,0,'Istrska belica - 1','','','','','','',''),(12,1,'0000-00-00 00:00:00',1,0,'Cuv&amp;eacute;e','','','','','','',''),(13,1,'0000-00-00 00:00:00',1,0,'Chilli','','','','','','',''),(14,1,'0000-00-00 00:00:00',1,0,'Garlic','','','','','','',''),(15,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(16,1,'0000-00-00 00:00:00',1,0,'Istrska belica - 1','','','','','','',''),(17,1,'0000-00-00 00:00:00',1,0,'Body cream neutrum - 11','','','','','','',''),(18,1,'0000-00-00 00:00:00',1,0,'Gift box - 12','','','','','','',''),(19,1,'0000-00-00 00:00:00',1,0,'Masage oil neutrum - 13','','','','','','',''),(20,1,'0000-00-00 00:00:00',1,0,'Massage oil orchid - 14','','','','','','',''),(21,1,'0000-00-00 00:00:00',1,0,'Massage oil roses - 15','','','','','','',''),(22,1,'0000-00-00 00:00:00',1,0,'Istrska belica','','','','','','',''),(23,1,'0000-00-00 00:00:00',1,0,'Body scrub - 16','','','','','','',''),(24,1,'0000-00-00 00:00:00',1,0,'Face cream neutrum - 17','','','','','','',''),(25,1,'0000-00-00 00:00:00',1,0,'Face cream citreum - 18','','','','','','',''),(26,1,'0000-00-00 00:00:00',1,0,'Face cream arantium - 19','','','','','','',''),(27,1,'0000-00-00 00:00:00',1,0,'Face scrub - 20','','','','','','',''),(28,1,'0000-00-00 00:00:00',1,0,'Hand cream neutrum - 21','','','','','','',''),(29,1,'0000-00-00 00:00:00',1,0,'Hands cream citreum - 22','','','','','','',''),(30,1,'0000-00-00 00:00:00',1,0,'Hand cream arantium - 23','','','','','','',''),(31,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(32,1,'0000-00-00 00:00:00',1,0,'Hand cream arantium - 23','','','','','','',''),(33,1,'0000-00-00 00:00:00',1,0,'Body cream arantium - 25','','','','','','',''),(34,1,'0000-00-00 00:00:00',1,0,'Hair shampoo neutrum - 26','','','','','','',''),(35,1,'0000-00-00 00:00:00',1,0,'Hair shampoo citreum - 27','','','','','','',''),(36,1,'0000-00-00 00:00:00',1,0,'Hair shampoo arantium - 28','','','','','','',''),(37,1,'0000-00-00 00:00:00',1,0,'Hair shampoo chilli - 29','','','','','','',''),(38,1,'0000-00-00 00:00:00',1,0,'Hair conditioner neutrum - 30','','','','','','',''),(39,1,'0000-00-00 00:00:00',1,0,'Hair conditioner citreum - 31','','','','','','',''),(40,1,'0000-00-00 00:00:00',1,0,'Hair conditioner arantium - 32','','','','','','',''),(41,1,'0000-00-00 00:00:00',1,0,'Hair conditioner chilli - 33','','','','','','',''),(42,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(43,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(44,1,'0000-00-00 00:00:00',1,0,'Body cream neutrum - 11','','','','','','',''),(45,1,'0000-00-00 00:00:00',1,0,'Gold 0,1L - 34','','','','','','',''),(46,1,'0000-00-00 00:00:00',1,0,'Gold 0,25L - 35','','','','','','',''),(47,1,'0000-00-00 00:00:00',1,0,'Gold 0,5L - 36','','','','','','',''),(48,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(49,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(50,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(51,1,'0000-00-00 00:00:00',1,0,'Body cream citreum - 24','','','','','','',''),(52,1,'0000-00-00 00:00:00',1,0,'Massage oil orchid - 14','','','','','','',''),(53,1,'0000-00-00 00:00:00',1,0,'Massage oil orchid - 14','','','','','','',''),(54,1,'0000-00-00 00:00:00',1,0,'Massage oil roses - 15','','','','','','',''),(55,1,'0000-00-00 00:00:00',1,0,'Body cream arantium - 25','','','','','','',''),(56,1,'0000-00-00 00:00:00',1,0,'Hands cream citreum - 22','','','','','','',''),(57,1,'0000-00-00 00:00:00',1,0,'Hand cream citreum - 22','','','','','','',''),(58,1,'0000-00-00 00:00:00',1,0,'Hand cream citreum - 22','','','','','','',''),(59,1,'0000-00-00 00:00:00',1,0,'Hand cream citreum - 22','','','','','','',''),(60,1,'0000-00-00 00:00:00',1,0,'Hand cream citreum - 22','','','','','','',''),(61,1,'0000-00-00 00:00:00',1,0,'Hair shampoo citreum - 27','','','','','','',''),(62,1,'0000-00-00 00:00:00',1,0,'Hair shampoo chilli - 29','','','','','','',''),(63,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(64,1,'0000-00-00 00:00:00',1,0,'Hair shampoo arantium - 28','','','','','','',''),(65,1,'0000-00-00 00:00:00',1,0,'Hair conditioner neutrum - 30','','','','','','',''),(66,1,'0000-00-00 00:00:00',1,0,'Istrska belica 0,1l - 37','','','','','','',''),(67,1,'0000-00-00 00:00:00',1,0,'Istrska belica 0,25L - 38','','','','','','',''),(68,1,'0000-00-00 00:00:00',1,0,'Istrska belica 0,5L - 39','','','','','','',''),(69,1,'0000-00-00 00:00:00',1,0,'Cuv&eacute;e 0,1L - 40','','','','','','',''),(70,1,'0000-00-00 00:00:00',1,0,'Cuv&eacute;e 0,1L - 41','','','','','','',''),(71,1,'0000-00-00 00:00:00',1,0,'Cuv&eacute;e 0,5L - 42','','','','','','',''),(72,1,'0000-00-00 00:00:00',1,0,'One love','','','','','','',''),(73,1,'0000-00-00 00:00:00',1,0,'One love 0,1L - 44','','','','','','',''),(74,1,'0000-00-00 00:00:00',1,0,'One love 0,25L - 45','','','','','','',''),(75,1,'0000-00-00 00:00:00',1,0,'One love 0,5L - 46','','','','','','',''),(76,1,'0000-00-00 00:00:00',1,0,'Lemon 0,1L - 47','','','','','','',''),(77,1,'0000-00-00 00:00:00',1,0,'Lemon 0,25L - 48','','','','','','',''),(78,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(79,1,'0000-00-00 00:00:00',1,0,'Orange 0,1L - 50','','','','','','',''),(80,1,'0000-00-00 00:00:00',1,0,'Orange 0,25L - 51','','','','','','',''),(81,1,'0000-00-00 00:00:00',1,0,'Chili 0,1L - 52','','','','','','',''),(82,1,'0000-00-00 00:00:00',1,0,'Chili 0,25L - 53','','','','','','',''),(83,1,'0000-00-00 00:00:00',1,0,'Truffle 0,1L - 54','','','','','','',''),(84,1,'0000-00-00 00:00:00',1,0,'Truffle 0,25L - 55','','','','','','',''),(85,1,'0000-00-00 00:00:00',1,0,'Garlic 0,1L - 56','','','','','','',''),(86,1,'0000-00-00 00:00:00',1,0,'Garlic 0,25L - 57','','','','','','',''),(87,1,'0000-00-00 00:00:00',1,0,'Evoo 2021 3L - 58','','','','','','',''),(88,1,'0000-00-00 00:00:00',1,0,'Evoo 2021 5L - 59','','','','','','',''),(89,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(90,1,'0000-00-00 00:00:00',1,0,'Posion with gift box - 61','','','','','','',''),(91,1,'0000-00-00 00:00:00',1,0,'Herbs','','','','','','',''),(92,1,'0000-00-00 00:00:00',1,0,'Onion - 63','','','','','','',''),(93,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(94,1,'0000-00-00 00:00:00',1,0,'Am&eacute;lie 0,1L - 65','','','','','','',''),(95,1,'0000-00-00 00:00:00',1,0,'Am&eacute;lie 0,25L - 66','','','','','','',''),(96,1,'0000-00-00 00:00:00',1,0,'Am&eacute;lie 0,5L - 67','','','','','','',''),(97,1,'0000-00-00 00:00:00',1,0,'Herbs 0,1L - 68','','','','','','',''),(98,1,'0000-00-00 00:00:00',1,0,'Herbs 0,25L - 69','','','','','','',''),(99,1,'0000-00-00 00:00:00',1,0,'Onion 0,1L - 70','','','','','','',''),(100,1,'0000-00-00 00:00:00',1,0,'Onino 0,25L - 71','','','','','','',''),(101,1,'0000-00-00 00:00:00',1,0,'','','','','','','',''),(102,1,'0000-00-00 00:00:00',1,0,'Darilna embalaža - 72','','','','','','',''),(103,1,'0000-00-00 00:00:00',1,0,'Poison 0,5L - 73','','','','','','',''),(104,1,'0000-00-00 00:00:00',1,0,'Darilna embalaža - 74','','','','','','',''),(105,1,'0000-00-00 00:00:00',1,0,'Velika skleda - 75','','','','','','',''),(106,1,'0000-00-00 00:00:00',1,0,'Bended board - 76','','','','','','',''),(107,1,'0000-00-00 00:00:00',1,0,'Dosa pasta - 77','','','','','','',''),(108,1,'0000-00-00 00:00:00',1,0,'Podolgovata skleda - 78','','','','','','',''),(109,1,'0000-00-00 00:00:00',1,0,'Posodica za solni cvet - 79','','','','','','',''),(110,1,'0000-00-00 00:00:00',1,0,'Srečk - 80','','','','','','',''),(111,1,'0000-00-00 00:00:00',1,0,'Velike vilice - 81','','','','','','',''),(112,1,'0000-00-00 00:00:00',1,0,'Olives in brine - 82','','','','','','',''),(113,1,'0000-00-00 00:00:00',1,0,'Penina - 83','','','','','','',''),(114,1,'0000-00-00 00:00:00',1,0,'Personalizirano olje - 84','','','','','','',''),(115,1,'0000-00-00 00:00:00',1,0,'Board with handle - 85','','','','','','',''),(116,1,'0000-00-00 00:00:00',1,0,'Wooden spoon - 86','','','','','','',''),(117,1,'0000-00-00 00:00:00',1,0,'Fruit bowl - medium - 87','','','','','','',''),(118,1,'0000-00-00 00:00:00',1,0,'Small oval platter - 88','','','','','','',''),(119,1,'0000-00-00 00:00:00',1,0,'Bowl medium rough edge - 89','','','','','','',''),(120,1,'0000-00-00 00:00:00',1,0,'Spices grinding bowl - 90','','','','','','',''),(121,1,'0000-00-00 00:00:00',1,0,'Bread bowl large - 91','','','','','','',''),(122,1,'0000-00-00 00:00:00',1,0,'Prosciutto - 92','','','','','','',''),(123,1,'0000-00-00 00:00:00',1,0,'Personalised olive wood table *by request - 93','','','','','','',''),(124,1,'0000-00-00 00:00:00',1,0,'Olive wood simple coffee table - 94','','','','','','',''),(125,1,'0000-00-00 00:00:00',1,0,'Olive wood coffee table ROOT - 95','','','','','','',''),(126,1,'0000-00-00 00:00:00',1,0,'Apetizers board 3x - 96','','','','','','',''),(127,1,'0000-00-00 00:00:00',1,0,'Apetizers board 2x - 97','','','','','','',''),(128,1,'0000-00-00 00:00:00',1,0,'EVOO 5L - 98','','','','','','',''),(129,1,'0000-00-00 00:00:00',1,0,'Gin - 99','','','','','','',''),(130,1,'0000-00-00 00:00:00',1,0,'Olive wood coffee table ROOT - 95','','','','','','',''),(131,1,'0000-00-00 00:00:00',1,0,'Olive basket - 100','','','','','','',''),(132,1,'0000-00-00 00:00:00',1,0,'Gin - 99','','','','','','',''),(133,1,'0000-00-00 00:00:00',1,0,'TEST - 101','','','','','','',''),(134,1,'0000-00-00 00:00:00',1,0,'OLIVE SOAP - 102','','','','','','',''),(135,1,'0000-00-00 00:00:00',1,0,'TOUR_OLIVE - 103','','','','','','',''),(136,1,'0000-00-00 00:00:00',1,0,'try out set - 104','','','','','','',''),(137,1,'0000-00-00 00:00:00',1,0,'Olive wood coffee table ROOT - 95','','','','','','',''),(138,1,'0000-00-00 00:00:00',1,0,'Olive wood coffee table ROOT - 105','','','','','','',''),(139,1,'0000-00-00 00:00:00',1,0,'Gel za tu&scaron;iranje - 106','','','','','','',''),(140,1,'0000-00-00 00:00:00',1,0,'Pladenj s plo&scaron;čicami - 107','','','','','','',''),(141,1,'0000-00-00 00:00:00',1,0,'Sveča v oljčnem lesu (vonj beli mo&scaron;us) - 108','','','','','','',''),(142,1,'0000-00-00 00:00:00',1,0,'Tray with ceramic tiles and rope handles - 109','','','','','','','');

--
-- Table structure for table `ngn_calculation_item_photo`
--

CREATE TABLE `ngn_calculation_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_calculation_item_photo`
--


--
-- Table structure for table `ngn_calculation_item_photo_gallery`
--

CREATE TABLE `ngn_calculation_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_calculation_item_photo_gallery`
--


--
-- Table structure for table `ngn_calculation_item_photo_gallery_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_photo_gallery_language`
--


--
-- Table structure for table `ngn_calculation_item_photo_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_photo_language`
--


--
-- Table structure for table `ngn_calculation_item_variations`
--

CREATE TABLE `ngn_calculation_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_calculation_item_variations_ibfk_1` FOREIGN KEY (`item_id`) REFERENCES `ngn_calculation_item` (`item_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=81 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_item_variations`
--

INSERT INTO `ngn_calculation_item_variations` VALUES (1,22,1,0),(2,22,2,0),(3,22,3,0),(4,1,1,0),(5,1,2,0),(7,22,4,0),(9,2,1,0),(10,2,2,0),(15,4,1,0),(16,4,2,0),(18,5,1,0),(19,5,2,0),(21,6,1,0),(22,6,2,0),(24,7,1,0),(25,7,2,0),(30,49,1,0),(31,49,2,0),(33,60,1,0),(34,60,2,0),(36,62,1,0),(37,62,2,0),(42,64,1,0),(43,64,2,0),(45,3,1,0),(46,3,2,0),(48,43,1,0),(49,43,2,0),(52,72,1,0),(53,72,2,0),(55,78,1,0),(56,78,2,0),(58,89,1,0),(59,89,2,0),(61,91,1,0),(62,91,2,0),(67,101,1,0),(68,101,2,0),(70,101,3,0),(71,63,1,0),(72,63,2,0),(74,63,3,0),(75,92,1,0),(76,92,2,0),(78,93,1,0),(79,93,2,0);

--
-- Table structure for table `ngn_calculation_item_variations_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_variations_language`
--

INSERT INTO `ngn_calculation_item_variations_language` VALUES (1,1,'2022-10-13 15:35:07',0,0,NULL,NULL,NULL,NULL,NULL,''),(2,1,'2022-10-13 15:38:12',0,0,NULL,NULL,NULL,NULL,NULL,''),(3,1,'2022-10-13 15:44:55',0,0,NULL,NULL,NULL,NULL,NULL,''),(4,1,'2022-10-13 15:48:08',0,0,NULL,NULL,NULL,NULL,NULL,''),(5,1,'2022-10-13 15:50:40',0,0,NULL,NULL,NULL,NULL,NULL,''),(7,1,'2022-10-14 13:59:39',0,0,NULL,NULL,NULL,NULL,NULL,''),(9,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(10,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(15,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(16,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(18,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(19,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(21,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(22,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(24,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(25,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(30,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(31,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(33,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(34,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(36,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(37,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(42,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(43,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(45,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(46,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(48,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(49,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(52,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(53,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(55,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(56,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(58,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(59,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(61,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(62,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(67,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(68,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(70,1,'2022-10-17 09:25:48',0,0,NULL,NULL,NULL,NULL,NULL,''),(71,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(72,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(74,1,'2022-10-17 09:38:07',0,0,NULL,NULL,NULL,NULL,NULL,''),(75,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(76,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(78,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,''),(79,1,'2022-08-18 00:00:00',0,0,NULL,NULL,NULL,NULL,NULL,'');

--
-- Table structure for table `ngn_calculation_item_videos`
--

CREATE TABLE `ngn_calculation_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_calculation_item_videos`
--


--
-- Table structure for table `ngn_calculation_item_videos_language`
--

CREATE TABLE `ngn_calculation_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_calculation_item_videos_language`
--


--
-- Table structure for table `ngn_calculation_language`
--

CREATE TABLE `ngn_calculation_language` (
  `news_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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(200) NOT NULL,
  `language_photo2` varchar(200) NOT NULL,
  PRIMARY KEY (`news_id`,`language_id`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_language`
--


--
-- Table structure for table `ngn_calculation_links`
--

CREATE TABLE `ngn_calculation_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_calculation_links`
--


--
-- Table structure for table `ngn_calculation_media`
--

CREATE TABLE `ngn_calculation_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_calculation_media`
--


--
-- Table structure for table `ngn_calculation_media_gallery`
--

CREATE TABLE `ngn_calculation_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_calculation_media_gallery`
--


--
-- Table structure for table `ngn_calculation_pages`
--

CREATE TABLE `ngn_calculation_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_calculation_pages`
--


--
-- Table structure for table `ngn_calculation_photo`
--

CREATE TABLE `ngn_calculation_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,
  PRIMARY KEY (`photo_id`),
  KEY `news_id` (`news_id`),
  KEY `photo_date` (`photo_date`),
  KEY `photo_owner` (`photo_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_photo`
--


--
-- Table structure for table `ngn_calculation_photo_gallery`
--

CREATE TABLE `ngn_calculation_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_calculation_photo_gallery`
--


--
-- Table structure for table `ngn_calculation_photo_gallery_language`
--

CREATE TABLE `ngn_calculation_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_calculation_photo_gallery_language`
--


--
-- Table structure for table `ngn_calculation_photo_language`
--

CREATE TABLE `ngn_calculation_photo_language` (
  `photo_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_photo_language`
--


--
-- Table structure for table `ngn_calculation_photo_sizes`
--

CREATE TABLE `ngn_calculation_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_calculation_photo_sizes`
--


--
-- Table structure for table `ngn_calculation_photo_usage`
--

CREATE TABLE `ngn_calculation_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_calculation_photo_usage`
--

INSERT INTO `ngn_calculation_photo_usage` VALUES (1,'calculation','news_photo',1),(2,'calculation','news_photo',2),(3,'calculation','news_photo',3),(4,'calculation','news_photo',4),(5,'calculation','news_photo',5),(6,'calculation','news_photo',6),(7,'calculation','news_photo',7),(8,'calculation','news_photo',8),(9,'calculation','news_photo',9),(36,'calculation','category_photo',188),(40,'calculation','news_photo',11),(41,'calculation','news_photo',12),(42,'calculation','news_photo',13),(43,'calculation','news_photo',14),(44,'calculation','news_photo',15),(45,'calculation','news_photo',16),(46,'calculation','news_photo',18),(47,'calculation','news_photo',17),(48,'calculation','news_photo',19),(49,'calculation','news_photo',20),(50,'calculation','news_photo',21),(51,'calculation','news_photo',22),(52,'calculation','news_photo',23),(53,'calculation','news_photo',24),(54,'calculation','news_photo',25),(55,'calculation','news_photo',26),(56,'calculation','news_photo',27),(57,'calculation','news_photo',28),(58,'calculation','news_photo',30),(59,'calculation','news_photo',31),(60,'calculation','news_photo',29),(61,'calculation','news_photo',33),(62,'calculation','news_photo',32),(63,'calculation','news_photo',3),(64,'calculation','news_photo',1),(65,'calculation','news_photo',43),(66,'calculation','news_photo',5),(67,'calculation','news_photo',49),(68,'calculation','news_photo',6),(69,'calculation','news_photo',4),(70,'calculation','news_photo',7),(71,'calculation','news_photo',2),(72,'calculation','news_photo',9),(73,'calculation','news_photo',60),(74,'calculation','news_photo',61),(75,'calculation','news_photo',62),(76,'calculation','news_photo',63),(77,'calculation','news_photo',64);

--
-- Table structure for table `ngn_calculation_restrictions`
--

CREATE TABLE `ngn_calculation_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_calculation_restrictions`
--

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

--
-- Table structure for table `ngn_calculation_restrictions_groups`
--

CREATE TABLE `ngn_calculation_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_calculation_restrictions_groups`
--


--
-- Table structure for table `ngn_calculation_restrictions_settings`
--

CREATE TABLE `ngn_calculation_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_calculation_restrictions_settings`
--


--
-- Table structure for table `ngn_calculation_restrictions_settings_multi`
--

CREATE TABLE `ngn_calculation_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_calculation_restrictions_settings_multi`
--


--
-- Table structure for table `ngn_calculation_roles`
--

CREATE TABLE `ngn_calculation_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_calculation_roles`
--


--
-- Table structure for table `ngn_calculation_stock`
--

CREATE TABLE `ngn_calculation_stock` (
  `stock_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_id` int(11) DEFAULT NULL,
  `user_id` varchar(45) DEFAULT NULL,
  `stock_createdate` datetime DEFAULT NULL,
  `stock_editdate` datetime DEFAULT NULL,
  `stock_type` int(11) DEFAULT NULL,
  `stock_value` double DEFAULT NULL,
  PRIMARY KEY (`stock_id`),
  KEY `news_id` (`news_id`),
  KEY `user_id` (`user_id`),
  KEY `stock_type` (`stock_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_stock`
--


--
-- Table structure for table `ngn_calculation_tags`
--

CREATE TABLE `ngn_calculation_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_calculation_tags`
--


--
-- Table structure for table `ngn_calculation_tags_language`
--

CREATE TABLE `ngn_calculation_tags_language` (
  `tag_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL DEFAULT 0,
  `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`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_tags_language`
--


--
-- Table structure for table `ngn_calculation_tags_links`
--

CREATE TABLE `ngn_calculation_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`),
  KEY `news_id` (`news_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_tags_links`
--


--
-- Table structure for table `ngn_calculation_topnews`
--

CREATE TABLE `ngn_calculation_topnews` (
  `news_id` int(11) NOT NULL AUTO_INCREMENT,
  `news_owner` int(11) NOT NULL DEFAULT 0,
  `news_createdate` int(11) NOT NULL DEFAULT 0,
  `news_showdate` int(11) NOT NULL DEFAULT 0,
  `news_hidedate` int(11) NOT NULL,
  `news_hide` tinyint(4) NOT NULL DEFAULT 0,
  `news_category` int(11) NOT NULL DEFAULT 0,
  `news_enable` int(11) NOT NULL DEFAULT 0,
  `news_viewed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`news_id`),
  KEY `news_createdate` (`news_createdate`),
  KEY `news_showdate` (`news_showdate`),
  KEY `news_hidedate` (`news_hidedate`),
  KEY `news_category` (`news_category`),
  KEY `news_enable` (`news_enable`),
  KEY `news_hide` (`news_hide`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_topnews`
--


--
-- Table structure for table `ngn_calculation_topnews_language`
--

CREATE TABLE `ngn_calculation_topnews_language` (
  `news_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_photo1` varchar(200) NOT NULL,
  `language_photo2` varchar(200) NOT NULL,
  PRIMARY KEY (`news_id`,`language_id`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_topnews_language`
--


--
-- Table structure for table `ngn_calculation_topnews_positions`
--

CREATE TABLE `ngn_calculation_topnews_positions` (
  `news_id` int(11) NOT NULL,
  `element_id` int(11) NOT NULL,
  `dimX` int(11) NOT NULL,
  `dimY` int(11) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `linked_id` int(11) NOT NULL,
  PRIMARY KEY (`news_id`,`element_id`),
  KEY `linked_id` (`linked_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_calculation_topnews_positions`
--


--
-- Table structure for table `ngn_calculation_videos`
--

CREATE TABLE `ngn_calculation_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_calculation_videos`
--


--
-- Table structure for table `ngn_calculation_videos_language`
--

CREATE TABLE `ngn_calculation_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_calculation_videos_language`
--


--
-- Table structure for table `ngn_call`
--

CREATE TABLE `ngn_call` (
  `call_id` int(11) NOT NULL AUTO_INCREMENT,
  `call_date` datetime NOT NULL,
  `call_data` varchar(200) NOT NULL,
  `caller_id` int(11) NOT NULL,
  `caller_phone` int(11) NOT NULL,
  `called_id` int(11) NOT NULL,
  `called_phone` int(11) NOT NULL,
  `amswered` int(11) NOT NULL DEFAULT 0,
  `showed` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`call_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_call`
--


--
-- Table structure for table `ngn_city_cards`
--

CREATE TABLE `ngn_city_cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `busy` int(1) NOT NULL DEFAULT 0,
  `editdate` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cards`
--


--
-- Table structure for table `ngn_city_cashier`
--

CREATE TABLE `ngn_city_cashier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `counter` int(11) NOT NULL,
  `company` int(11) NOT NULL,
  `createdate` datetime NOT NULL,
  `editdate` datetime NOT NULL,
  `user` int(11) NOT NULL,
  `note_user` int(11) NOT NULL,
  `note_createdate` datetime NOT NULL,
  `note` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `createdate` (`createdate`),
  KEY `note_user` (`note_user`),
  KEY `company` (`company`),
  KEY `company_2` (`company`,`createdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier`
--


--
-- Table structure for table `ngn_city_cashier_invoices`
--

CREATE TABLE `ngn_city_cashier_invoices` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type_id` (`type_id`,`invoice_id`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier_invoices`
--


--
-- Table structure for table `ngn_city_cashier_invoices_old`
--

CREATE TABLE `ngn_city_cashier_invoices_old` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `type_id` (`type_id`,`invoice_id`),
  KEY `invoice_id` (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier_invoices_old`
--


--
-- Table structure for table `ngn_city_cashier_invoices_types`
--

CREATE TABLE `ngn_city_cashier_invoices_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `close_id` int(11) NOT NULL,
  `invoice_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `close_id` (`close_id`,`invoice_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier_invoices_types`
--


--
-- Table structure for table `ngn_city_cashier_invoices_types_old`
--

CREATE TABLE `ngn_city_cashier_invoices_types_old` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `close_id` int(11) NOT NULL,
  `invoice_type` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `close_id` (`close_id`,`invoice_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier_invoices_types_old`
--


--
-- Table structure for table `ngn_city_cashier_old`
--

CREATE TABLE `ngn_city_cashier_old` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdate` datetime NOT NULL,
  `editdate` datetime NOT NULL,
  `user` int(11) NOT NULL,
  `note_user` int(11) NOT NULL,
  `note_createdate` datetime NOT NULL,
  `note` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user` (`user`),
  KEY `createdate` (`createdate`),
  KEY `note_user` (`note_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_cashier_old`
--


--
-- Table structure for table `ngn_city_credits`
--

CREATE TABLE `ngn_city_credits` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `credit_number` varchar(50) NOT NULL,
  `invoice_id` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL DEFAULT current_timestamp(),
  `used` int(1) NOT NULL DEFAULT 0,
  `time_used` datetime DEFAULT NULL,
  `valid` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `credit_number_2` (`credit_number`),
  KEY `credit_number` (`credit_number`),
  KEY `time_used` (`time_used`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_credits`
--


--
-- Table structure for table `ngn_city_custom_gifts`
--

CREATE TABLE `ngn_city_custom_gifts` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice` int(11) NOT NULL,
  `start` int(11) NOT NULL,
  `counter` int(11) NOT NULL,
  `done` int(11) NOT NULL,
  `valid_date` datetime NOT NULL,
  `email` varchar(100) NOT NULL,
  `custom_text` varchar(50) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `counter` (`counter`),
  KEY `custom_text` (`custom_text`),
  KEY `invoice` (`invoice`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_custom_gifts`
--


--
-- Table structure for table `ngn_city_event_users`
--

CREATE TABLE `ngn_city_event_users` (
  `event_id` int(11) NOT NULL,
  `email` varchar(50) NOT NULL,
  `added` datetime NOT NULL DEFAULT current_timestamp(),
  PRIMARY KEY (`event_id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_event_users`
--


--
-- Table structure for table `ngn_city_gift`
--

CREATE TABLE `ngn_city_gift` (
  `gift_id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `ticket_id` int(11) NOT NULL,
  PRIMARY KEY (`gift_id`,`group_id`,`ticket_id`),
  UNIQUE KEY `group_id` (`group_id`,`ticket_id`),
  KEY `ticket_id` (`ticket_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_gift`
--


--
-- Table structure for table `ngn_city_gift_groups`
--

CREATE TABLE `ngn_city_gift_groups` (
  `group_id` int(11) NOT NULL AUTO_INCREMENT,
  `card_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  `expiredate` datetime DEFAULT NULL,
  PRIMARY KEY (`group_id`),
  UNIQUE KEY `card_id` (`card_id`,`invoice_id`),
  KEY `ngn_city_gift_groups_ibfk_2` (`invoice_id`),
  KEY `owner` (`owner`),
  KEY `createdate` (`createdate`),
  KEY `expiredate` (`expiredate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_gift_groups`
--


--
-- Table structure for table `ngn_city_ticket_types`
--

CREATE TABLE `ngn_city_ticket_types` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_ticket_types`
--

INSERT INTO `ngn_city_ticket_types` VALUES (1,'hourly'),(2,'daily'),(3,'daily_year'),(4,'family'),(7,'extra_kid'),(11,'parent_hourly'),(12,'parent_daily'),(13,'parent_daily_year'),(17,'parent_extra');

--
-- Table structure for table `ngn_city_tickets`
--

CREATE TABLE `ngn_city_tickets` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket_code` varchar(70) NOT NULL,
  `buyer` int(11) NOT NULL,
  `owner` int(11) NOT NULL,
  `type` int(1) NOT NULL,
  `item` int(11) NOT NULL,
  `date_create` datetime NOT NULL DEFAULT current_timestamp(),
  `date_due` datetime NOT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `ticket_unique` (`ticket_code`),
  KEY `type` (`type`),
  KEY `buyer` (`buyer`),
  KEY `owner` (`owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets`
--


--
-- Table structure for table `ngn_city_tickets_data`
--

CREATE TABLE `ngn_city_tickets_data` (
  `ticket_id` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `valueFloat` float NOT NULL,
  `valueText` varchar(100) NOT NULL,
  PRIMARY KEY (`ticket_id`,`type`) USING BTREE,
  KEY `type` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets_data`
--


--
-- Table structure for table `ngn_city_tickets_event`
--

CREATE TABLE `ngn_city_tickets_event` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createdate` datetime NOT NULL DEFAULT current_timestamp(),
  `event_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `attr_id` int(11) NOT NULL,
  `gaid` int(11) NOT NULL,
  `value` varchar(100) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `event_id` (`event_id`,`invoice_id`,`attr_id`,`gaid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets_event`
--


--
-- Table structure for table `ngn_city_tickets_import`
--

CREATE TABLE `ngn_city_tickets_import` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `process` int(1) DEFAULT 0,
  `DateValidFrom` datetime DEFAULT NULL,
  `DateValidTo` datetime DEFAULT NULL,
  `Remark` varchar(81) DEFAULT NULL,
  `GroupName` varchar(16) DEFAULT NULL,
  `TicketName` varchar(49) DEFAULT NULL,
  `quantity` int(11) NOT NULL DEFAULT 1,
  `idContact` int(5) DEFAULT NULL,
  `id_inserted` varchar(50) NOT NULL,
  `group_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idContact` (`idContact`),
  KEY `process` (`process`),
  KEY `TicketName` (`TicketName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets_import`
--


--
-- Table structure for table `ngn_city_tickets_import_ids`
--

CREATE TABLE `ngn_city_tickets_import_ids` (
  `idContact` int(5) NOT NULL AUTO_INCREMENT,
  `Contact` varchar(53) DEFAULT NULL,
  `Address` varchar(35) DEFAULT NULL,
  `Phone` varchar(12) DEFAULT NULL,
  `Mobile` varchar(24) DEFAULT NULL,
  `Email` varchar(39) DEFAULT NULL,
  `idPost` varchar(35) DEFAULT NULL,
  `Code` varchar(11) DEFAULT NULL,
  `CardValidTill` datetime DEFAULT NULL,
  `DateInsert` datetime DEFAULT NULL,
  `DateBirth` datetime DEFAULT NULL,
  `TaxNumber` varchar(11) DEFAULT NULL,
  `DateLastChange` datetime DEFAULT NULL,
  `DateMembership` datetime DEFAULT NULL,
  PRIMARY KEY (`idContact`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets_import_ids`
--


--
-- Table structure for table `ngn_city_tickets_settings`
--

CREATE TABLE `ngn_city_tickets_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_tickets_settings`
--

INSERT INTO `ngn_city_tickets_settings` VALUES (1,'remaining','valueInt'),(3,'used','valueInt'),(4,'valid','valueInt'),(5,'validHours','valueInt'),(6,'ticketType','valueInt'),(7,'reservationSlot','valueInt'),(8,'date','valueInt');

--
-- Table structure for table `ngn_city_visitor_groups`
--

CREATE TABLE `ngn_city_visitor_groups` (
  `visitor_group` int(11) NOT NULL AUTO_INCREMENT,
  `group_name` varchar(50) NOT NULL,
  PRIMARY KEY (`visitor_group`),
  UNIQUE KEY `group_name` (`group_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_visitor_groups`
--


--
-- Table structure for table `ngn_city_visitors`
--

CREATE TABLE `ngn_city_visitors` (
  `visit_id` int(11) NOT NULL AUTO_INCREMENT,
  `ticket` int(11) NOT NULL,
  `card` int(11) NOT NULL,
  `visitor_group` int(11) NOT NULL,
  `time_enter` datetime NOT NULL DEFAULT current_timestamp(),
  `time_valid` datetime NOT NULL,
  `time_exit` datetime DEFAULT NULL,
  `first_time` int(11) NOT NULL,
  `extended` int(11) NOT NULL,
  `extending_counter` int(11) NOT NULL,
  PRIMARY KEY (`visit_id`),
  KEY `City visit` (`time_enter`,`time_exit`),
  KEY `first_time` (`first_time`),
  KEY `extended` (`extended`),
  KEY `extending_counter` (`extending_counter`),
  KEY `visitor_group` (`visitor_group`),
  KEY `card` (`card`),
  KEY `ticket` (`ticket`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_visitors`
--


--
-- Table structure for table `ngn_city_visitors_childcare`
--

CREATE TABLE `ngn_city_visitors_childcare` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `group_id` int(11) NOT NULL,
  `care_start` datetime NOT NULL DEFAULT current_timestamp(),
  `care_end` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `visit_id` (`group_id`,`care_start`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_visitors_childcare`
--


--
-- Table structure for table `ngn_city_visitors_data`
--

CREATE TABLE `ngn_city_visitors_data` (
  `visit_group` int(11) NOT NULL,
  `type` int(11) NOT NULL,
  `valueInt` int(11) NOT NULL,
  `valueFloat` float NOT NULL,
  `valueText` varchar(100) NOT NULL,
  PRIMARY KEY (`visit_group`,`type`) USING BTREE,
  KEY `ngn_city_visitors_data_ibfk_3` (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_visitors_data`
--


--
-- Table structure for table `ngn_city_visitors_settings`
--

CREATE TABLE `ngn_city_visitors_settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `type` varchar(10) NOT NULL,
  `attr_type` varchar(10) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_visitors_settings`
--


--
-- Table structure for table `ngn_city_zip`
--

CREATE TABLE `ngn_city_zip` (
  `zip_id` int(11) NOT NULL AUTO_INCREMENT,
  `country_id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL,
  PRIMARY KEY (`zip_id`,`country_id`),
  KEY `country_id` (`country_id`),
  KEY `zip_id` (`zip_id`),
  KEY `name` (`name`),
  CONSTRAINT `ngn_city_zip_ibfk_1` FOREIGN KEY (`country_id`) REFERENCES `ngn_country` (`country_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9601 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_city_zip`
--

INSERT INTO `ngn_city_zip` VALUES (1517,1,'Abanka Vipa, Ljubljana'),(8341,1,'Adlešiči'),(6503,1,'Adriatic Slovenica, Zavarovalna družba, Koper'),(5270,1,'Ajdovščina'),(6280,1,'Ankaran/Ancarano'),(9253,1,'Apače'),(8253,1,'Artiče'),(6502,1,'Banka Koper, Koper'),(1505,1,'Banka Slovenije, Ljubljana'),(4275,1,'Begunje na Gorenjskem'),(1382,1,'Begunje pri Cerknici'),(9231,1,'Beltinci'),(2234,1,'Benedikt'),(2345,1,'Bistrica ob Dravi'),(3256,1,'Bistrica ob Sotli'),(8259,1,'Bizeljsko'),(1223,1,'Blagovica'),(8283,1,'Blanca'),(4260,1,'Bled'),(4273,1,'Blejska Dobrava'),(9265,1,'Bodonci'),(9222,1,'Bogojina'),(4263,1,'Bohinjska Bela'),(4264,1,'Bohinjska Bistrica'),(4265,1,'Bohinjsko jezero'),(1353,1,'Borovnica'),(8294,1,'Boštanj'),(5230,1,'Bovec'),(5295,1,'Branik'),(3314,1,'Braslovče'),(5223,1,'Breginj'),(8280,1,'Brestanica'),(2354,1,'Bresternica'),(8250,1,'Brežice'),(4243,1,'Brezje'),(1351,1,'Brezovica pri Ljubljani'),(4210,1,'Brnik - Aerodrom'),(8321,1,'Brusnice'),(1533,1,'BTC, Ljubljana'),(3255,1,'Buče'),(8276,1,'Bučka'),(1512,1,'Cankarjeva založba, Ljubljana'),(9261,1,'Cankova'),(1524,1,'Carinarnica Ljubljana, Ljubljana'),(1523,1,'Carinska uprava Republike Slovenije, Ljubljana'),(8251,1,'Čatež ob Savi'),(3000,1,'Celje'),(3001,1,'Celje - poštni predali'),(1413,1,'Čemšenik'),(5253,1,'Čepovan'),(4207,1,'Cerklje na Gorenjskem'),(8263,1,'Cerklje ob Krki'),(1380,1,'Cerknica'),(5282,1,'Cerkno'),(2236,1,'Cerkvenjak'),(2215,1,'Ceršak'),(1522,1,'Chemo, Ljubljana'),(2326,1,'Cirkovce'),(2282,1,'Cirkulane'),(5273,1,'Col'),(9232,1,'Črenšovci'),(2393,1,'Črna na Koroškem'),(6275,1,'Črni Kal'),(5274,1,'Črni Vrh nad Idrijo'),(5262,1,'Črniče'),(8340,1,'Črnomelj'),(6271,1,'Dekani'),(1509,1,'Delo, Ljubljana'),(5210,1,'Deskle'),(2253,1,'Destrnik'),(6215,1,'Divača'),(1510,1,'Dnevnik, Ljubljana'),(1233,1,'Dob'),(3224,1,'Dobje pri Planini'),(8257,1,'Dobova'),(1423,1,'Dobovec'),(5263,1,'Dobravlje'),(3204,1,'Dobrna'),(8211,1,'Dobrnič'),(1356,1,'Dobrova'),(9223,1,'Dobrovnik/Dobronak'),(5212,1,'Dobrovo v Brdih'),(1431,1,'Dol pri Hrastniku'),(1262,1,'Dol pri Ljubljani'),(1273,1,'Dole pri Litiji'),(1331,1,'Dolenja vas'),(8350,1,'Dolenjske Toplice'),(1230,1,'Domžale'),(2252,1,'Dornava'),(5294,1,'Dornberk'),(1319,1,'Draga'),(8343,1,'Dragatuš'),(3222,1,'Dramlje'),(2370,1,'Dravograd'),(1544,1,'Droga Kolinska, Ljubljana'),(4203,1,'Duplje'),(2502,1,'DURS, Davčni urad Maribor, Maribor'),(6221,1,'Dutovlje'),(8361,1,'Dvor'),(1538,1,'DZS, Ljubljana'),(1516,1,'Elektro Ljubljana, Ljubljana'),(2509,1,'Elektro Maribor, Maribor'),(1528,1,'Emona, Ljubljana'),(1540,1,'EPPS - Elektronsko pismo Pošte Slovenije, Ljubljan'),(3504,1,'ERA, Velenje'),(2343,1,'Fala'),(9208,1,'Fokovci'),(2313,1,'Fram'),(3213,1,'Frankolovo'),(1274,1,'Gabrovka'),(8254,1,'Globoko'),(5275,1,'Godovič'),(4204,1,'Golnik'),(3303,1,'Gomilsko'),(4224,1,'Gorenja vas'),(3503,1,'Gorenje, Velenje'),(3263,1,'Gorica pri Slivnici'),(2272,1,'Gorišnica'),(9250,1,'Gornja Radgona'),(3342,1,'Gornji Grad'),(1504,1,'Gospodarska zbornica Slovenije, Ljubljana'),(4282,1,'Gozd Martuljek'),(6272,1,'Gračišče'),(9264,1,'Grad'),(8332,1,'Gradac'),(1384,1,'Grahovo'),(5242,1,'Grahovo ob Bači'),(5251,1,'Grgar'),(3302,1,'Griže'),(3231,1,'Grobelno'),(1290,1,'Grosuplje'),(2288,1,'Hajdina'),(2506,1,'Henkel Slovenija, Maribor'),(8362,1,'Hinje'),(2311,1,'Hoče'),(9205,1,'Hodoš/Hodos'),(1354,1,'Horjul'),(1372,1,'Hotedršica'),(1430,1,'Hrastnik'),(6225,1,'Hruševje'),(4276,1,'Hrušica'),(5280,1,'Idrija'),(1292,1,'Ig'),(6250,1,'Ilirska Bistrica'),(6251,1,'Ilirska Bistrica-Trnovo'),(6504,1,'Intereuropa, Koper'),(1521,1,'Iskra Invest, Ljubljana'),(1295,1,'Ivančna Gorica'),(2259,1,'Ivanjkovci'),(1411,1,'Izlake'),(6310,1,'Izola/Isola'),(2222,1,'Jakobski Dol'),(2221,1,'Jarenina'),(6254,1,'Jelšane'),(4270,1,'Jesenice'),(8261,1,'Jesenice na Dolenjskem'),(3273,1,'Jurklošter'),(2223,1,'Jurovski Dol'),(2256,1,'Juršinci'),(5214,1,'Kal nad Kanalom'),(3233,1,'Kalobje'),(4246,1,'Kamna Gorica'),(2351,1,'Kamnica'),(1241,1,'Kamnik'),(5213,1,'Kanal'),(1545,1,'Kanal A, Ljubljana'),(8258,1,'Kapele'),(2362,1,'Kapla'),(1542,1,'KDD - Centralna klirinško depotna družba, Ljubljan'),(2325,1,'Kidričevo'),(1412,1,'Kisovec'),(1525,1,'Klinični center Ljubljana, Ljubljana'),(6253,1,'Knežak'),(5222,1,'Kobarid'),(9227,1,'Kobilje'),(1330,1,'Kočevje'),(1338,1,'Kočevska Reka'),(2276,1,'Kog'),(5211,1,'Kojsko'),(6223,1,'Komen'),(1218,1,'Komenda'),(1514,1,'Kompas, Ljubljana'),(6000,1,'Koper/Capodistria'),(6001,1,'Koper/Capodistria - poštni predali'),(8282,1,'Koprivnica'),(6256,1,'Košana'),(5296,1,'Kostanjevica na Krasu'),(8311,1,'Kostanjevica na Krki'),(1336,1,'Kostel'),(2394,1,'Kotlje'),(6240,1,'Kozina'),(3260,1,'Kozje'),(4000,1,'Kranj'),(4001,1,'Kranj - poštni predali'),(4280,1,'Kranjska Gora'),(1281,1,'Kresnice'),(4294,1,'Križe'),(9206,1,'Križevci'),(9242,1,'Križevci pri Ljutomeru'),(1301,1,'Krka'),(8501,1,'Krka, Novo mesto'),(8296,1,'Krmelj'),(4245,1,'Kropa'),(8262,1,'Krška vas'),(8270,1,'Krško'),(9263,1,'Kuzma'),(2318,1,'Laporje'),(3270,1,'Laško'),(1219,1,'Laze v Tuhinju'),(1526,1,'Lek, Ljubljana'),(2230,1,'Lenart v Slovenskih goricah'),(9220,1,'Lendava/Lendva'),(4248,1,'Lesce'),(3261,1,'Lesično'),(8273,1,'Leskovec pri Krškem'),(2372,1,'Libeliče'),(2341,1,'Limbuš'),(1270,1,'Litija'),(3202,1,'Ljubečna'),(1000,1,'Ljubljana'),(1231,1,'Ljubljana - Črnuče'),(1261,1,'Ljubljana - Dobrunje'),(1260,1,'Ljubljana - Polje'),(1001,1,'Ljubljana - poštni predali'),(1210,1,'Ljubljana - Šentvid'),(1211,1,'Ljubljana - Šmartno'),(3333,1,'Ljubno ob Savinji'),(9240,1,'Ljutomer'),(3215,1,'Loče'),(5231,1,'Log pod Mangartom'),(1358,1,'Log pri Brezovici'),(1370,1,'Logatec'),(1371,1,'Logatec'),(1434,1,'Loka pri Zidanem Mostu'),(3223,1,'Loka pri Žusmu'),(6219,1,'Lokev'),(1318,1,'Loški Potok'),(2324,1,'Lovrenc na Dravskem polju'),(2344,1,'Lovrenc na Pohorju'),(3334,1,'Luče'),(6501,1,'Luka Koper, Koper'),(1225,1,'Lukovica'),(9202,1,'Mačkovci'),(2322,1,'Majšperk'),(2321,1,'Makole'),(9243,1,'Mala Nedelja'),(2229,1,'Malečnik'),(6273,1,'Marezige'),(2000,1,'Maribor'),(2001,1,'Maribor - poštni predali'),(2206,1,'Marjeta na Dravskem polju'),(2281,1,'Markovci'),(9221,1,'Martjanci'),(6242,1,'Materija'),(4211,1,'Mavčiče'),(1215,1,'Medvode'),(1234,1,'Mengeš'),(3505,1,'Merkur, Celje'),(4501,1,'Merkur, Naklo'),(8330,1,'Metlika'),(2392,1,'Mežica'),(2204,1,'Miklavž na Dravskem polju'),(2275,1,'Miklavž pri Ormožu'),(1502,1,'Ministrstvo za finance, Ljubljana'),(1501,1,'Ministrstvo za notranje zadeve, Ljubljana'),(1535,1,'Ministrstvo za promet, Ljubljana'),(5291,1,'Miren'),(8233,1,'Mirna'),(8216,1,'Mirna Peč'),(2382,1,'Mislinja'),(1536,1,'Mladinska knjiga Založba, Ljubljana'),(1537,1,'Mobitel, Ljubljana'),(4281,1,'Mojstrana'),(8230,1,'Mokronog'),(1251,1,'Moravče'),(9226,1,'Moravske Toplice'),(5216,1,'Most na Soči'),(1221,1,'Motnik'),(3330,1,'Mozirje'),(9501,1,'Mura, Murska Sobota'),(9000,1,'Murska Sobota'),(9001,1,'Murska Sobota - poštni predali'),(2366,1,'Muta'),(4202,1,'Naklo'),(3331,1,'Nazarje'),(1357,1,'Notranje Gorice'),(3203,1,'Nova Cerkev'),(5000,1,'Nova Gorica'),(5001,1,'Nova Gorica - poštni predali'),(2505,1,'Nova Kreditna banka Maribor, Maribor'),(1520,1,'Nova Ljubljanska banka, Ljubljana'),(1385,1,'Nova vas'),(8000,1,'Novo mesto'),(8001,1,'Novo mesto - poštni predali'),(6243,1,'Obrov'),(9233,1,'Odranci'),(1534,1,'Okrajno sodišče v Ljubljani, Ljubljana'),(2508,1,'Okrajno sodišče v Mariboru, Maribor'),(1503,1,'Okrožno sodišče v Ljubljani, Ljubljana'),(2503,1,'Okrožno sodišče v Mariboru, Maribor'),(2317,1,'Oplotnica'),(2312,1,'Orehova vas'),(2270,1,'Ormož'),(1316,1,'Ortnek'),(1337,1,'Osilnica'),(8222,1,'Otočec'),(2361,1,'Ožbalt'),(2231,1,'Pernica'),(2211,1,'Pesnica pri Mariboru'),(1527,1,'Petrol, Ljubljana'),(3301,1,'Petrovče'),(9203,1,'Petrovci'),(6330,1,'Piran/Pirano'),(8255,1,'Pišece'),(6257,1,'Pivka'),(6232,1,'Planina'),(3225,1,'Planina pri Sevnici'),(6276,1,'Pobegi'),(8312,1,'Podbočje'),(5243,1,'Podbrdo'),(3254,1,'Podčetrtek'),(2273,1,'Podgorci'),(6216,1,'Podgorje'),(2381,1,'Podgorje pri Slovenj Gradcu'),(6244,1,'Podgrad'),(1414,1,'Podkum'),(2286,1,'Podlehnik'),(5272,1,'Podnanos'),(4244,1,'Podnart'),(3241,1,'Podplat'),(3257,1,'Podsreda'),(2363,1,'Podvelka'),(2208,1,'Pohorje'),(2257,1,'Polenšak'),(1355,1,'Polhov Gradec'),(4223,1,'Poljane nad Škofjo Loko'),(2319,1,'Poljčane'),(1272,1,'Polšnik'),(3313,1,'Polzela'),(3232,1,'Ponikva'),(6320,1,'Portorož/Portorose'),(2610,1,'Pošta Slovenije, Centralna RA pisarna, Maribor'),(3600,1,'Pošta Slovenije, PE Celje, Celje'),(6600,1,'Pošta Slovenije, PE Koper, Koper'),(4600,1,'Pošta Slovenije, PE Kranj, Kranj'),(1600,1,'Pošta Slovenije, PE Ljubljana, Ljubljana'),(2600,1,'Pošta Slovenije, PE Maribor, Maribor'),(9600,1,'Pošta Slovenije, PE Murska Sobota, Murska Sobota'),(5600,1,'Pošta Slovenije, PE Nova Gorica, Nova Gorica'),(8600,1,'Pošta Slovenije, PE Novo mesto, Novo mesto'),(1002,1,'Pošta Slovenije, PE PLC Ljubljana, Ljubljana'),(2603,1,'Pošta Slovenije, PE PLC Maribor, Centralno skladiš'),(2002,1,'Pošta Slovenije, PE PLC Maribor, Maribor'),(2609,1,'Pošta Slovenije, PE PLC Maribor, Paketni ekspedit,'),(6200,1,'Pošta Slovenije, PPP Koper, Koper'),(4200,1,'Pošta Slovenije, PPP Šenčur, Kranj'),(2500,1,'Pošta Slovenije, uprava, Maribor'),(6230,1,'Postojna'),(2331,1,'Pragersko'),(3312,1,'Prebold'),(4205,1,'Preddvor'),(6255,1,'Prem'),(1352,1,'Preserje'),(6258,1,'Prestranek'),(2391,1,'Prevalje'),(3262,1,'Prevorje'),(1276,1,'Primskovo'),(3253,1,'Pristava pri Mestinju'),(9207,1,'Prosenjakovci/Partosfalva'),(5297,1,'Prvačina'),(2250,1,'Ptuj'),(2323,1,'Ptujska Gora'),(9201,1,'Puconci'),(2327,1,'Rače'),(1433,1,'Radeče'),(9252,1,'Radenci'),(9502,1,'Radenska d.d., Radenci'),(2360,1,'Radlje ob Dravi'),(1235,1,'Radomlje'),(4240,1,'Radovljica'),(8274,1,'Raka'),(1381,1,'Rakek'),(4283,1,'Rateče - Planica'),(2390,1,'Ravne na Koroškem'),(9246,1,'Razkrižje'),(3332,1,'Rečica ob Savinji'),(5292,1,'Renče'),(1310,1,'Ribnica'),(2364,1,'Ribnica na Pohorju'),(3272,1,'Rimske Toplice'),(1314,1,'Rob'),(5215,1,'Ročinj'),(3250,1,'Rogaška Slatina'),(9262,1,'Rogašovci'),(3252,1,'Rogatec'),(1373,1,'Rovte'),(1550,1,'RTV Slovenija, Ljubljana'),(2342,1,'Ruše'),(1532,1,'Salamonov oglasnik, Ljubljana'),(9204,1,'Šalovci'),(1282,1,'Sava'),(4502,1,'Sava, Kranj'),(6333,1,'Sečovlje/Sicciole'),(4227,1,'Selca'),(2352,1,'Selnica ob Dravi'),(8333,1,'Semič'),(5261,1,'Šempas'),(5290,1,'Šempeter pri Gorici'),(3311,1,'Šempeter v Savinjski dolini'),(4208,1,'Šenčur'),(8281,1,'Senovo'),(6224,1,'Senožeče'),(2212,1,'Šentilj v Slovenskih goricah'),(8297,1,'Šentjanž'),(2373,1,'Šentjanž pri Dravogradu'),(8310,1,'Šentjernej'),(3230,1,'Šentjur'),(3271,1,'Šentrupert'),(8232,1,'Šentrupert'),(1296,1,'Šentvid pri Stični'),(8290,1,'Sevnica'),(6210,1,'Sežana'),(1513,1,'SKB banka, Ljubljana'),(8275,1,'Škocjan'),(6281,1,'Škofije'),(4220,1,'Škofja Loka'),(3211,1,'Škofja vas'),(1291,1,'Škofljica'),(2214,1,'Sladki Vrh'),(5283,1,'Slap ob Idrijci'),(1511,1,'Slovenijales, Ljubljana'),(2380,1,'Slovenj Gradec'),(2310,1,'Slovenska Bistrica'),(3210,1,'Slovenske Konjice'),(1506,1,'Slovenske železnice, Ljubljana'),(6274,1,'Šmarje'),(1293,1,'Šmarje - Sap'),(3240,1,'Šmarje pri Jelšah'),(8220,1,'Šmarješke Toplice'),(2315,1,'Šmartno na Pohorju'),(3341,1,'Šmartno ob Dreti'),(3327,1,'Šmartno ob Paki'),(1275,1,'Šmartno pri Litiji'),(2383,1,'Šmartno pri Slovenj Gradcu'),(3201,1,'Šmartno v Rožni dolini'),(1216,1,'Smlednik'),(5232,1,'Soča'),(1317,1,'Sodražica'),(3335,1,'Solčava'),(5250,1,'Solkan'),(4229,1,'Sorica'),(3325,1,'Šoštanj'),(4225,1,'Sovodenj'),(1519,1,'SPL Ljubljana, Ljubljana'),(5281,1,'Spodnja Idrija'),(2241,1,'Spodnji Duplek'),(9245,1,'Spodnji Ivanjci'),(1543,1,'Športna loterija, Ljubljana'),(2277,1,'Središče ob Dravi'),(4267,1,'Srednja vas v Bohinju'),(8256,1,'Sromlje'),(5224,1,'Srpenica'),(1242,1,'Stahovica'),(6222,1,'Štanjel'),(1332,1,'Stara Cerkev'),(8342,1,'Stari trg ob Kolpi'),(1386,1,'Stari trg pri Ložu'),(2205,1,'Starše'),(2289,1,'Stoperce'),(8322,1,'Stopiče'),(3220,1,'Štore'),(3206,1,'Stranice'),(8351,1,'Straža'),(1313,1,'Struge'),(8293,1,'Studenec'),(8331,1,'Suhor'),(2233,1,'Sv. Ana v Slovenskih goricah'),(2235,1,'Sv. Trojica v Slovenskih goricah'),(2353,1,'Sveti Duh na Ostrem Vrhu'),(9244,1,'Sveti Jurij ob Ščavnici'),(3264,1,'Sveti Štefan'),(2258,1,'Sveti Tomaž'),(3304,1,'Tabor'),(3221,1,'Teharje'),(1546,1,'Telekom Slovenije, Ljubljana'),(1547,1,'Telekom Slovenije, PE Ljubljana, Ljubljana'),(9251,1,'Tišina'),(5220,1,'Tolmin'),(3326,1,'Topolšica'),(2371,1,'Trbonje'),(1420,1,'Trbovlje'),(8231,1,'Trebelno'),(8210,1,'Trebnje'),(5252,1,'Trnovo pri Gorici'),(2254,1,'Trnovska vas'),(1222,1,'Trojane'),(4290,1,'Tržič'),(1236,1,'Trzin'),(8295,1,'Tržišče'),(1311,1,'Turjak'),(9224,1,'Turnišče'),(2501,1,'Upravna enota Maribor, Maribor'),(8323,1,'Uršna sela'),(1252,1,'Vače'),(2504,1,'Večer, Maribor'),(3320,1,'Velenje'),(3322,1,'Velenje - poštni predali'),(8212,1,'Velika Loka'),(2274,1,'Velika Nedelja'),(9225,1,'Velika Polana'),(1315,1,'Velike Lašče'),(8213,1,'Veliki Gaber'),(9241,1,'Veržej'),(1312,1,'Videm - Dobrepolje'),(2284,1,'Videm pri Ptuju'),(8344,1,'Vinica'),(5271,1,'Vipava'),(1294,1,'Višnja Gora'),(4212,1,'Visoko'),(3205,1,'Vitanje'),(2255,1,'Vitomarci'),(1217,1,'Vodice'),(3212,1,'Vojnik'),(5293,1,'Volčja Draga'),(2232,1,'Voličina'),(3305,1,'Vransko'),(6217,1,'Vremski Britof'),(1360,1,'Vrhnika'),(2365,1,'Vuhred'),(2367,1,'Vuzenica'),(4209,1,'Žabnica'),(8292,1,'Zabukovje'),(1410,1,'Zagorje ob Savi'),(1303,1,'Zagradec'),(3310,1,'Žalec'),(2507,1,'Zavarovalnica Maribor, Maribor'),(2283,1,'Zavrč'),(8272,1,'Zdole'),(4228,1,'Železniki'),(2287,1,'Žetale'),(4201,1,'Zgornja Besnica'),(2242,1,'Zgornja Korena'),(2201,1,'Zgornja Kungota'),(2316,1,'Zgornja Ložnica'),(2314,1,'Zgornja Polskava'),(2213,1,'Zgornja Velka'),(4247,1,'Zgornje Gorje'),(4206,1,'Zgornje Jezersko'),(2285,1,'Zgornji Leskovec'),(1432,1,'Zidani Most'),(4226,1,'Žiri'),(4274,1,'Žirovnica'),(1529,1,'Žito, Ljubljana'),(1518,1,'ZPIZ, Zavod za pokoj. in inval. zav. Slov., Ljublj'),(3214,1,'Zreče'),(8360,1,'Žužemberk'),(1507,1,'ZZZS, Zavod za zdrav. zav. Slov., Ljubljana');

--
-- Table structure for table `ngn_company`
--

CREATE TABLE `ngn_company` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tax_id` int(8) NOT NULL,
  `registration_id` varchar(20) NOT NULL,
  `edit_date` datetime NOT NULL DEFAULT current_timestamp(),
  `date` datetime NOT NULL,
  `type` varchar(6) NOT NULL,
  `name` varchar(100) NOT NULL,
  `address` varchar(50) NOT NULL,
  `zip` int(4) NOT NULL,
  `city` varchar(30) NOT NULL,
  `tax_office` int(11) NOT NULL,
  `tax_no` int(11) NOT NULL,
  `tax_commitment` int(11) NOT NULL,
  PRIMARY KEY (`id`,`tax_id`,`registration_id`),
  UNIQUE KEY `IDs` (`tax_id`,`registration_id`),
  KEY `tax_id` (`tax_id`),
  KEY `registration_id` (`registration_id`),
  KEY `name` (`name`),
  KEY `address` (`address`),
  KEY `zip` (`zip`,`city`),
  KEY `edit_date` (`edit_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_company`
--


--
-- Table structure for table `ngn_core_gallery_templates`
--

CREATE TABLE `ngn_core_gallery_templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_url` varchar(100) NOT NULL,
  `template_order` int(11) NOT NULL,
  `template_owner` int(11) NOT NULL,
  `template_date` datetime NOT NULL,
  `template_enable` int(11) NOT NULL,
  `template_photo` varchar(200) NOT NULL,
  PRIMARY KEY (`template_id`),
  KEY `template_url` (`template_url`),
  KEY `template_order` (`template_order`),
  KEY `template_owner` (`template_owner`),
  KEY `template_enable` (`template_enable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_gallery_templates`
--


--
-- Table structure for table `ngn_core_gallery_templates_language`
--

CREATE TABLE `ngn_core_gallery_templates_language` (
  `template_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 (`template_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_gallery_templates_language`
--


--
-- Table structure for table `ngn_core_photos`
--

CREATE TABLE `ngn_core_photos` (
  `photo_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo_width` int(11) NOT NULL,
  `photo_height` int(11) NOT NULL,
  `photo_extension` int(11) NOT NULL,
  `photo_function` int(11) NOT NULL,
  `photo_quality` int(11) NOT NULL,
  `photo_type` int(11) NOT NULL,
  `photo_url` varchar(100) NOT NULL,
  `photo_order` int(11) NOT NULL,
  `photo_owner` int(11) NOT NULL,
  `photo_date` datetime NOT NULL,
  `photo_enable` int(11) NOT NULL,
  `photo_bw` int(11) NOT NULL,
  `photo_white` int(11) NOT NULL,
  `photo_resize` int(11) NOT NULL,
  `photo_path` varchar(200) NOT NULL,
  `photo_watermark` int(2) NOT NULL,
  `photo_watermark_path` varchar(200) NOT NULL,
  `photo_watermark_left` int(11) NOT NULL,
  `photo_watermark_right` int(11) NOT NULL,
  `photo_watermark_top` int(11) NOT NULL,
  `photo_watermark_opacity` int(11) NOT NULL,
  `photo_watermark_bottom` int(11) NOT NULL,
  PRIMARY KEY (`photo_id`),
  KEY `photo_url` (`photo_url`),
  KEY `photo_order` (`photo_order`),
  KEY `photo_owner` (`photo_owner`),
  KEY `photo_enable` (`photo_enable`),
  KEY `photo_bw` (`photo_bw`),
  KEY `photo_white` (`photo_white`),
  KEY `photo_resize` (`photo_resize`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_photos`
--

INSERT INTO `ngn_core_photos` VALUES (1,1920,680,2,2,90,0,'index_slider',500,718,'2022-03-11 13:53:55',1,0,0,0,'/data/albums/index_slider/',0,'',0,0,0,0,0),(2,430,545,2,2,90,0,'index_slider_mobile',501,718,'2022-03-11 13:56:10',1,0,0,0,'/data/albums/index_slider_mobile/',0,'',0,0,0,0,0),(3,545,355,2,2,90,0,'index_services',502,718,'2022-03-11 14:43:39',1,0,0,0,'/data/albums/index_services/',0,'',0,0,0,0,0),(4,392,255,2,2,90,0,'index_services_mobile',503,718,'2022-03-11 14:45:28',1,0,0,0,'/data/albums/index_services_mobile/',0,'',0,0,0,0,0),(5,713,476,2,2,90,0,'index_photo_text_horizontal',504,718,'2022-03-11 15:54:01',1,0,0,0,'/data/albums/index_photo_text_horizontal/',0,'',0,0,0,0,0),(6,392,261,2,2,90,0,'index_photo_text_horizontal_mobile',505,718,'2022-03-11 15:57:40',1,0,0,0,'/data/albums/index_photo_text_horizontal_mobile/',0,'',0,0,0,0,0),(7,615,615,2,2,90,0,'index_photo_text_square',506,718,'2022-03-14 10:59:02',1,0,0,0,'/data/albums/index_photo_text_square/',0,'',0,0,0,0,0),(8,392,380,2,2,90,0,'index_photo_text_square_mobile',507,718,'2022-03-14 11:01:27',1,0,0,0,'/data/albums/index_photo_text_square_mobile/',0,'',0,0,0,0,0),(9,410,615,2,2,90,0,'index_photo_text_vertical',508,718,'2022-03-14 11:05:50',1,0,0,0,'/data/albums/index_photo_text_vertical/',0,'',0,0,0,0,0),(10,392,588,2,2,90,0,'index_photo_text_vertical_mobile',509,718,'2022-03-14 11:08:58',1,0,0,0,'/data/albums/index_photo_text_vertical_mobile/',0,'',0,0,0,0,0),(11,2000,300,2,6,100,0,'designer_photo',510,718,'2022-03-15 09:50:21',1,0,0,0,'/data/albums/designer_photo/',0,'',0,0,0,0,0),(12,392,200,2,6,90,0,'designer_photo_mobile',511,718,'2022-03-15 10:03:38',1,0,0,0,'/data/albums/designer_photo_mobile/',0,'',0,0,0,0,0),(13,623,291,2,6,90,0,'designer_text_photo',512,718,'2022-03-15 11:15:30',1,0,0,0,'/data/albums/designer_text_photo/',0,'',0,0,0,0,0),(14,392,183,2,6,90,0,'designer_text_photo_mobile',513,718,'2022-03-15 11:16:33',1,0,0,0,'/data/albums/designer_text_photo_mobile/',0,'',0,0,0,0,0),(15,862,400,2,6,90,0,'designer_text_photo_2',514,718,'2022-03-15 11:24:51',1,0,0,0,'/data/albums/designer_text_photo_2/',0,'',0,0,0,0,0),(16,392,200,2,6,90,0,'designer_text_photo_2_mobile',515,718,'2022-03-15 11:25:48',1,0,0,0,'/data/albums/designer_text_photo_2_mobile/',0,'',0,0,0,0,0),(17,459,612,2,2,90,0,'designer_text_photo_links',516,718,'2022-03-16 11:52:22',1,0,0,0,'/data/albums/designer_text_photo_links/',0,'',0,0,0,0,0),(18,250,300,2,2,90,0,'designer_text_photo_links_mobile',517,718,'2022-03-16 11:55:01',1,0,0,0,'/data/albums/designer_text_photo_links_mobile/',0,'',0,0,0,0,0),(19,1100,750,2,6,90,0,'designer_text_photo_big',518,718,'2022-03-16 14:29:18',1,0,0,0,'/data/albums/designer_text_photo_big/',0,'',0,0,0,0,0),(20,416,284,2,6,90,0,'designer_text_photo_big_mobile',519,718,'2022-03-16 14:31:24',1,0,0,0,'/data/albums/designer_text_photo_big_mobile/',0,'',0,0,0,0,0),(21,493,510,2,2,90,0,'designer_linked_news',520,718,'2022-03-16 14:50:37',1,0,0,0,'/data/albums/designer_linked_news/',0,'',0,0,0,0,0),(22,772,514,2,6,90,0,'designer_text_photo_3',521,718,'2022-03-16 15:23:10',1,0,0,0,'/data/albums/designer_text_photo_3/',0,'',0,0,0,0,0),(23,254,236,2,6,90,0,'designer_text_photo_3_mobile',522,718,'2022-03-16 15:24:44',1,0,0,0,'/data/albums/designer_text_photo_3_mobile/',0,'',0,0,0,0,0),(24,1920,680,2,2,100,0,'header_photo',523,718,'2022-03-17 09:53:20',1,0,0,0,'/data/albums/header_photo/',0,'',0,0,0,0,0),(25,1000,1000,2,0,85,0,'preview',3000,718,'2022-03-24 15:19:20',1,0,0,0,'/data/albums/preview/',0,'',0,0,0,0,0),(26,40,40,1,2,80,1,'map_marker',3001,718,'2022-03-24 15:24:40',1,0,0,0,'/data/albums/map_marker/',0,'',0,0,0,0,0),(27,1000,1000,2,0,90,0,'popup',1000,718,'2022-03-28 09:24:14',1,0,0,0,'/data/albums/popup/',0,'',0,0,0,0,0),(28,495,655,2,2,100,1,'shop_grid',400,718,'2022-03-28 14:53:58',1,0,0,1,'/data/albums/shop_grid/',0,'',0,0,0,0,0),(29,222,222,2,2,95,0,'cart_photo',1000,718,'2022-03-29 15:25:04',1,0,0,1,'/data/albums/cart_photo/',0,'',0,0,0,0,0),(30,545,355,2,2,90,0,'blog_grid',600,718,'2022-04-15 15:50:51',1,0,0,0,'/data/albums/blog_grid/',0,'',0,0,0,0,0),(31,255,605,2,2,100,1,'shop_grid_oil',105,718,'2022-09-21 15:00:53',1,0,0,0,'/data/albums/shop_grid_oil/',0,'',0,0,0,0,0),(32,1920,300,2,6,100,0,'index_banner',400,718,'2022-09-22 14:23:34',1,0,0,0,'/data/albums/index_banner/',0,'',0,0,0,0,0),(33,550,85,2,6,100,0,'index_banner_mobile',401,718,'2022-09-28 15:39:53',1,0,0,0,'/data/albums/index_banner_mobile/',0,'',0,0,0,0,0),(34,580,650,2,2,100,0,'header_photo_mobile',524,718,'2022-09-29 09:04:54',1,0,0,0,'/data/albums/header_photo_mobile/',0,'',0,0,0,0,0),(35,200,200,2,2,100,0,'product_gallery',203,718,'2023-01-27 14:55:31',1,0,0,0,'/data/albums/product_gallery/',0,'',0,0,0,0,0),(36,581,844,2,2,100,0,'gallery_recipe',600,718,'2023-03-13 10:45:02',1,0,1,0,'/data/albums/gallery_recipe/',0,'',0,0,0,0,0);

--
-- Table structure for table `ngn_core_photos_language`
--

CREATE TABLE `ngn_core_photos_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_core_photos_language_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `ngn_core_photos` (`photo_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_core_photos_language_ibfk_2` FOREIGN KEY (`language_id`) REFERENCES `ngn_language` (`language_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_photos_language`
--

INSERT INTO `ngn_core_photos_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'{i} Slider','','','','i-slider',''),(1,2,'0000-00-00 00:00:00',0,0,'{i} Slider','','','','i-slider',''),(2,1,'0000-00-00 00:00:00',0,0,'{i} Slider (mobile)','','','','i-slider-mobile',''),(2,2,'0000-00-00 00:00:00',0,0,'{i} Slider (mobile)','','','','i-slider-mobile',''),(3,1,'0000-00-00 00:00:00',0,0,'{i} Storitve','','','','i-storitve',''),(3,2,'0000-00-00 00:00:00',0,0,'{i} Storitve','','','','i-storitve',''),(4,1,'0000-00-00 00:00:00',0,0,'{i} Storitve (mobile)','','','','i-storitve-mobile',''),(4,2,'0000-00-00 00:00:00',0,0,'{i} Storitve (mobile)','','','','i-storitve-mobile',''),(5,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)','','','','i-slika-tekst-vodoravna',''),(5,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)','','','','i-slika-tekst-vodoravna',''),(6,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)(mobile)','','','','i-slika-tekst-vodoravnamobile',''),(6,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)(mobile)','','','','i-slika-tekst-vodoravnamobile',''),(7,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat) ','','','','i-slika-tekst-kvadrat-',''),(7,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat) ','','','','i-slika-tekst-kvadrat-',''),(8,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat)(mobile)','','','','i-slika-tekst-kvadratmobile',''),(8,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat)(mobile)','','','','i-slika-tekst-kvadratmobile',''),(9,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)','','','','i-slika-tekst-navpicna',''),(9,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)','','','','i-slika-tekst-navpicna',''),(10,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)(mobile)','','','','i-slika-tekst-navpicnamobile',''),(10,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)(mobile)','','','','i-slika-tekst-navpicnamobile',''),(11,1,'0000-00-00 00:00:00',0,0,'Slika','','','','slika',''),(11,2,'0000-00-00 00:00:00',0,0,'Slika','','','','slika',''),(12,1,'0000-00-00 00:00:00',0,0,'Slika (mobile)','','','','slika-mobile',''),(12,2,'0000-00-00 00:00:00',0,0,'Slika (mobile)','','','','slika-mobile',''),(13,1,'0000-00-00 00:00:00',0,0,'Tekst - slika','','','','tekst-slika',''),(13,2,'0000-00-00 00:00:00',0,0,'Tekst - slika','','','','tekst-slika',''),(14,1,'0000-00-00 00:00:00',0,0,'Tekst - slika (mobile)','','','','tekst-slika-mobile',''),(14,2,'0000-00-00 00:00:00',0,0,'Tekst - slika (mobile)','','','','tekst-slika-mobile',''),(15,1,'0000-00-00 00:00:00',0,0,'Tekst - slika (2)','','','','tekst-slika-2',''),(15,2,'0000-00-00 00:00:00',0,0,'Tekst - slika (2)','','','','tekst-slika-2',''),(16,1,'0000-00-00 00:00:00',0,0,'Tekst - slika (2)(mobile)','','','','tekst-slika-2mobile',''),(16,2,'0000-00-00 00:00:00',0,0,'Tekst - slika (2)(mobile)','','','','tekst-slika-2mobile',''),(17,1,'0000-00-00 00:00:00',0,0,'Tekst - slika z povezavami','','','','tekst-slika-z-povezavami',''),(17,2,'0000-00-00 00:00:00',0,0,'Tekst - slika z povezavami','','','','tekst-slika-z-povezavami',''),(18,1,'0000-00-00 00:00:00',0,0,'Tekst - slika z povezavami (mobile)','','','','tekst-slika-z-povezavami-mobile',''),(18,2,'0000-00-00 00:00:00',0,0,'Tekst - slika z povezavami (mobile)','','','','tekst-slika-z-povezavami-mobile',''),(19,1,'0000-00-00 00:00:00',0,0,'Velik tekst - slika','','','','velik-tekst-slika',''),(19,2,'0000-00-00 00:00:00',0,0,'Velik tekst - slika','','','','velik-tekst-slika',''),(20,1,'0000-00-00 00:00:00',0,0,'Velik tekst - slika (mobile)','','','','velik-tekst-slika-mobile',''),(20,2,'0000-00-00 00:00:00',0,0,'Velik tekst - slika (mobile)','','','','velik-tekst-slika-mobile',''),(21,1,'0000-00-00 00:00:00',0,0,'Designer povezana vsebina','','','','designer-povezana-vsebina',''),(21,2,'0000-00-00 00:00:00',0,0,'Designer povezana vsebina','','','','designer-povezana-vsebina',''),(22,1,'0000-00-00 00:00:00',0,0,'Tekst - Slika (3)','','','','tekst-slika-3',''),(22,2,'0000-00-00 00:00:00',0,0,'Tekst - Slika (3)','','','','tekst-slika-3',''),(23,1,'0000-00-00 00:00:00',0,0,'Tekst - Slika (3)(mobile)','','','','tekst-slika-3mobile',''),(23,2,'0000-00-00 00:00:00',0,0,'Tekst - Slika (3)(mobile)','','','','tekst-slika-3mobile',''),(24,1,'0000-00-00 00:00:00',0,0,'Header slika','','','','header-slika',''),(24,2,'0000-00-00 00:00:00',0,0,'Header slika','','','','header-slika',''),(25,1,'0000-00-00 00:00:00',0,0,'Preview','','','','preview',''),(25,2,'0000-00-00 00:00:00',0,0,'Preview','','','','preview',''),(26,1,'0000-00-00 00:00:00',0,0,'Map marker','','','','map-marker',''),(26,2,'0000-00-00 00:00:00',0,0,'Map marker','','','','map-marker',''),(27,1,'0000-00-00 00:00:00',0,0,'Popup','','','','popup',''),(27,2,'0000-00-00 00:00:00',0,0,'Popup','','','','popup',''),(28,1,'0000-00-00 00:00:00',0,0,'Shop grid','','','','shop-grid',''),(28,2,'0000-00-00 00:00:00',0,0,'Shop grid','','','','shop-grid',''),(29,1,'0000-00-00 00:00:00',0,0,'Cart photo','','','','cart-photo',''),(29,2,'0000-00-00 00:00:00',0,0,'Cart photo','','','','cart-photo',''),(30,1,'0000-00-00 00:00:00',0,0,'Blog grid','','','','blog-grid',''),(30,2,'0000-00-00 00:00:00',0,0,'Blog grid','','','','blog-grid',''),(31,1,'0000-00-00 00:00:00',0,0,'Shop grid (olja)','','','','shop-grid-olja',''),(31,2,'0000-00-00 00:00:00',0,0,'Shop grid (olja)','','','','shop-grid-olja',''),(32,1,'0000-00-00 00:00:00',0,0,'{i} Banner','','','','i-banner',''),(32,2,'0000-00-00 00:00:00',0,0,'{i} Banner','','','','i-banner',''),(33,1,'0000-00-00 00:00:00',0,0,'{i} Banner (m)','','','','i-banner-m',''),(33,2,'0000-00-00 00:00:00',0,0,'{i} Banner (m)','','','','i-banner-m',''),(34,1,'0000-00-00 00:00:00',0,0,'Header photo (mobile)','','','','header-photo-mobile',''),(34,2,'0000-00-00 00:00:00',0,0,'Header photo (mobile)','','','','header-photo-mobile',''),(35,1,'0000-00-00 00:00:00',0,0,'Galerija (produkt)','','','','galerija-produkt',''),(35,2,'0000-00-00 00:00:00',0,0,'Galerija (produkt)','','','','galerija-produkt',''),(36,1,'0000-00-00 00:00:00',0,0,'Galerija za recepte','','','','galerija-za-recepte',''),(36,2,'0000-00-00 00:00:00',0,0,'Galerija za recepte','','','','galerija-za-recepte','');

--
-- Table structure for table `ngn_core_photos_links`
--

CREATE TABLE `ngn_core_photos_links` (
  `link_id` int(11) NOT NULL AUTO_INCREMENT,
  `photo_id` int(11) NOT NULL,
  `link_module` int(11) NOT NULL,
  `link_type` varchar(10) NOT NULL,
  `link_enable` int(11) NOT NULL,
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `template_id_2` (`photo_id`,`link_module`,`link_type`),
  KEY `photo_id` (`photo_id`),
  KEY `link_module` (`link_module`),
  KEY `link_type` (`link_type`),
  KEY `link_enable` (`link_enable`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_photos_links`
--

INSERT INTO `ngn_core_photos_links` VALUES (2,1,5,'category',1),(4,2,5,'category',1),(5,3,5,'news',1),(6,4,5,'news',1),(9,5,5,'category',1),(11,7,5,'category',1),(12,8,5,'category',1),(13,6,5,'category',1),(14,9,5,'category',1),(15,10,5,'category',1),(16,11,6,'news',1),(17,12,6,'news',1),(18,13,6,'news',1),(19,14,6,'news',1),(20,15,6,'news',1),(21,16,6,'news',1),(22,17,6,'news',1),(23,18,6,'news',1),(24,19,6,'news',1),(25,20,6,'news',1),(26,21,5,'news',1),(27,21,6,'news',1),(28,22,6,'news',1),(29,23,6,'news',1),(30,24,5,'news',1),(31,24,5,'category',1),(32,25,6,'category',1),(33,26,5,'news',1),(34,26,5,'category',1),(35,3,6,'news',1),(36,4,6,'news',1),(37,27,6,'news',1),(38,28,9,'news',1),(39,29,9,'news',1),(40,30,5,'news',1),(41,24,9,'news',1),(42,24,2,'category',1),(43,31,9,'news',1),(44,32,5,'category',1),(45,33,5,'category',1),(46,33,6,'news',1),(47,34,5,'news',1),(48,34,5,'category',1),(49,34,9,'category',1),(50,33,6,'category',1),(51,35,9,'news',1),(52,27,9,'news',1),(53,36,6,'news',1);

--
-- Table structure for table `ngn_core_photos_links_category`
--

CREATE TABLE `ngn_core_photos_links_category` (
  `link_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `childs` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`link_id`,`category_id`),
  CONSTRAINT `ngn_core_photos_links_category_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `ngn_core_photos_links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_photos_links_category`
--

INSERT INTO `ngn_core_photos_links_category` VALUES (2,11,0,0),(4,11,0,0),(9,1,1,0),(11,1,1,0),(12,1,1,0),(13,1,1,0),(14,1,1,0),(15,1,1,0),(31,0,1,0),(32,0,1,0),(34,4,1,0),(42,0,1,0),(44,1,1,0),(45,1,1,0),(48,0,1,0),(49,52,1,0),(50,1,1,0);

--
-- Table structure for table `ngn_core_photos_links_news`
--

CREATE TABLE `ngn_core_photos_links_news` (
  `link_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `childs` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`link_id`,`category_id`),
  CONSTRAINT `ngn_core_photos_links_news_ibfk_1` FOREIGN KEY (`link_id`) REFERENCES `ngn_core_photos_links` (`link_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_photos_links_news`
--

INSERT INTO `ngn_core_photos_links_news` VALUES (5,12,0,0),(6,12,0,0),(16,12,0,0),(17,12,0,0),(18,13,0,0),(19,13,0,0),(20,21,0,0),(21,21,0,0),(22,22,0,0),(23,22,0,0),(24,23,0,0),(25,23,0,0),(26,1,1,0),(26,2,1,0),(26,3,1,0),(26,30,1,0),(27,1,1,0),(28,25,0,0),(29,25,0,0),(30,0,1,0),(33,4,1,0),(35,14,0,0),(36,14,0,0),(37,14,0,0),(38,1,0,0),(39,1,0,0),(40,32,0,0),(41,0,1,0),(43,1,0,0),(46,1,1,0),(47,7,0,0),(51,1,0,0),(52,1,0,0),(53,31,0,0);

--
-- Table structure for table `ngn_core_templates`
--

CREATE TABLE `ngn_core_templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_url` varchar(100) NOT NULL,
  `template_order` int(11) NOT NULL,
  `template_owner` int(11) NOT NULL,
  `template_date` datetime NOT NULL,
  `template_enable` int(11) NOT NULL,
  PRIMARY KEY (`template_id`),
  KEY `template_url` (`template_url`),
  KEY `template_order` (`template_order`),
  KEY `template_owner` (`template_owner`),
  KEY `template_enable` (`template_enable`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_templates`
--

INSERT INTO `ngn_core_templates` VALUES (1,'heading_1',100,718,'2021-02-01 12:09:00',1),(2,'heading_2',101,718,'2021-02-01 12:09:41',1),(3,'heading_3',102,718,'2021-02-01 12:10:34',1),(4,'column_one',103,718,'2021-02-01 12:12:19',1),(5,'column_two',104,718,'2021-02-01 12:13:25',1),(6,'photo',105,718,'2021-02-01 12:14:19',1),(7,'text_photo',106,718,'2021-02-01 12:14:43',1),(8,'gallery',107,718,'2021-02-01 12:15:06',1),(9,'files',108,718,'2021-02-01 12:15:25',1),(10,'quote',109,718,'2021-02-01 12:15:57',1),(11,'spacing_small',110,718,'2021-02-01 12:16:43',1),(12,'spacing_medium',111,718,'2021-02-01 12:17:03',1),(13,'spacing_large',112,718,'2021-02-01 12:17:24',1),(14,'grid',30,718,'2021-01-28 12:26:20',0),(15,'news',31,718,'2021-01-28 12:26:48',1),(16,'blog_grid',32,718,'2021-01-28 12:27:49',1),(17,'blog',33,718,'2021-01-28 12:27:17',1),(18,'contact',500,718,'2021-01-28 12:27:49',1),(19,'shop_grid',200,718,'2022-03-10 09:16:25',1),(20,'product',201,718,'2022-03-10 09:16:42',1),(21,'index_slider',300,718,'2022-03-11 13:28:35',1),(22,'index_services',301,718,'2022-03-11 13:28:58',1),(23,'index_text',302,718,'2022-03-11 13:29:22',1),(24,'index_photo_text_horizontal',303,718,'2022-03-11 13:30:26',1),(25,'index_video_text',306,718,'2022-03-11 13:31:11',1),(26,'index_contact',307,718,'2022-03-11 13:31:36',1),(27,'index_photo_text_square',304,718,'2022-03-14 10:55:13',1),(28,'index_photo_text_vertical',305,718,'2022-03-14 10:55:40',1),(29,'index_instagram',306,718,'2022-03-14 15:18:06',1),(30,'text_photo_2',113,718,'2022-03-14 16:02:51',1),(31,'text_photo_links',114,718,'2022-03-14 16:03:39',1),(32,'text_photo_big',115,718,'2022-03-14 16:04:07',1),(33,'linked_news',116,718,'2022-03-14 16:04:36',1),(34,'text_photo_3',117,718,'2022-03-14 16:05:13',1),(35,'statistics',118,718,'2022-03-14 16:05:47',1),(36,'product_add_item',119,718,'2022-04-07 14:29:29',1),(37,'video',120,718,'2022-07-04 16:17:57',1),(38,'cosmetics_grid',205,718,'2022-08-18 11:22:45',1),(39,'cosmetics_product',206,718,'2022-08-19 14:51:05',1),(40,'divider',121,718,'2022-08-25 08:07:21',1),(41,'oil_grid',207,718,'2022-09-21 09:31:28',1),(42,'oil_product',208,718,'2022-09-21 09:31:44',1),(43,'index_banner_with_designer',50,718,'2022-09-22 14:11:38',1),(44,'designer_subcategories',199,718,'2022-10-19 14:25:48',1),(45,'gallery_recipe',122,718,'2023-03-13 10:37:11',1),(46,'reservation_form',123,718,'2023-03-13 11:06:20',1);

--
-- Table structure for table `ngn_core_templates_language`
--

CREATE TABLE `ngn_core_templates_language` (
  `template_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 (`template_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_core_templates_language`
--

INSERT INTO `ngn_core_templates_language` VALUES (1,1,'0000-00-00 00:00:00',0,0,'{d} Naslov H1','','','','d-naslov-h1',''),(2,1,'0000-00-00 00:00:00',0,0,'{d} Naslov H2','','','','d-naslov-h2',''),(3,1,'0000-00-00 00:00:00',0,0,'{d} Naslov H3','','','','d-naslov-h3',''),(4,1,'0000-00-00 00:00:00',0,0,'{d} En stolpec','','','','d-en-stolpec',''),(5,1,'0000-00-00 00:00:00',0,0,'{d} Dva stolpca','','','','d-dva-stolpca',''),(6,1,'0000-00-00 00:00:00',0,0,'{d} Slika','','','','d-slika',''),(7,1,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika','','','','d-tekst--slika',''),(8,1,'0000-00-00 00:00:00',0,0,'{d} Galerija','','','','d-galerija',''),(9,1,'0000-00-00 00:00:00',0,0,'{d} Datoteke','','','','d-datoteke',''),(10,1,'0000-00-00 00:00:00',0,0,'{d} Citat','','','','d-citat',''),(11,1,'0000-00-00 00:00:00',0,0,'{d} Majhen razmak','','','','d-majhen-razmak',''),(12,1,'0000-00-00 00:00:00',0,0,'{d} Srednji razmak','','','','d-srednji-razmak',''),(13,1,'0000-00-00 00:00:00',0,0,'{d} Velik razmak','','','','d-velik-razmak',''),(14,1,'0000-00-00 00:00:00',0,0,'Grid','','','','grid',''),(14,2,'0000-00-00 00:00:00',0,0,'Grid','','','','grid',''),(15,1,'0000-00-00 00:00:00',0,0,'News','','','','news',''),(16,1,'0000-00-00 00:00:00',0,0,'Blog grid','','','','blog-grid',''),(17,1,'0000-00-00 00:00:00',0,0,'Blog','','','','blog',''),(18,1,'0000-00-00 00:00:00',0,0,'Kontakt','','','','kontakt',''),(19,1,'0000-00-00 00:00:00',0,0,'Shop grid','','','','shop-grid',''),(19,2,'0000-00-00 00:00:00',0,0,'Shop grid','','','','shop-grid',''),(20,1,'0000-00-00 00:00:00',0,0,'Produkt','','','','produkt',''),(20,2,'0000-00-00 00:00:00',0,0,'Produkt','','','','produkt',''),(21,1,'0000-00-00 00:00:00',0,0,'{i} Slider','','','','i-slider',''),(21,2,'0000-00-00 00:00:00',0,0,'{i} Slider','','','','i-slider',''),(22,1,'0000-00-00 00:00:00',0,0,'{i} Storitve','','','','i-storitve',''),(22,2,'0000-00-00 00:00:00',0,0,'{i} Storitve','','','','i-storitve',''),(23,1,'0000-00-00 00:00:00',0,0,'{i} Tekst','','','','i-tekst',''),(23,2,'0000-00-00 00:00:00',0,0,'{i} Tekst','','','','i-tekst',''),(24,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)','','','','i-slika-tekst-vodoravna',''),(24,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (vodoravna)','','','','i-slika-tekst-vodoravna',''),(25,1,'0000-00-00 00:00:00',0,0,'{i} Video - tekst','','','','i-video-tekst',''),(25,2,'0000-00-00 00:00:00',0,0,'{i} Video - tekst','','','','i-video-tekst',''),(26,1,'0000-00-00 00:00:00',0,0,'{i} Kontakt','','','','i-kontakt',''),(26,2,'0000-00-00 00:00:00',0,0,'{i} Kontakt','','','','i-kontakt',''),(27,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat)','','','','i-slika-tekst-kvadrat',''),(27,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (kvadrat)','','','','i-slika-tekst-kvadrat',''),(28,1,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)','','','','i-slika-tekst-navpicna',''),(28,2,'0000-00-00 00:00:00',0,0,'{i} Slika - tekst (navpična)','','','','i-slika-tekst-navpicna',''),(29,1,'0000-00-00 00:00:00',0,0,'{i} Instagram','','','','i-instagram',''),(29,2,'0000-00-00 00:00:00',0,0,'{i} Instagram','','','','i-instagram',''),(30,1,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika (2)','','','','d-tekst-slika-2',''),(30,2,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika (2)','','','','d-tekst-slika-2',''),(31,1,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika z linki','','','','d-tekst-slika-z-linki',''),(31,2,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika z linki','','','','d-tekst-slika-z-linki',''),(32,1,'0000-00-00 00:00:00',0,0,'{d} Velik tekst - Slika','','','','d-velik-tekst-slika',''),(32,2,'0000-00-00 00:00:00',0,0,'{d} Velik tekst - Slika','','','','d-velik-tekst-slika',''),(33,1,'0000-00-00 00:00:00',0,0,'{d} Povezana vsebina','','','','d-povezana-vsebina',''),(33,2,'0000-00-00 00:00:00',0,0,'{d} Povezana vsebina','','','','d-povezana-vsebina',''),(34,1,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika (3)','','','','d-tekst-slika-3',''),(34,2,'0000-00-00 00:00:00',0,0,'{d} Tekst - Slika (3)','','','','d-tekst-slika-3',''),(35,1,'0000-00-00 00:00:00',0,0,'{d} Statistika','','','','d-statistika',''),(35,2,'0000-00-00 00:00:00',0,0,'{d} Statistika','','','','d-statistika',''),(36,1,'0000-00-00 00:00:00',0,0,'{d} Produkt','','','','d-produkt',''),(36,2,'0000-00-00 00:00:00',0,0,'{d} Produkt','','','','d-produkt',''),(37,1,'0000-00-00 00:00:00',0,0,'{d} Video','','','','d-video',''),(37,2,'0000-00-00 00:00:00',0,0,'{d} Video','','','','d-video',''),(38,1,'0000-00-00 00:00:00',0,0,'Kozmetika grid','','','','kozmetika-grid',''),(38,2,'0000-00-00 00:00:00',0,0,'Kozmetika grid','','','','kozmetika-grid',''),(39,1,'0000-00-00 00:00:00',0,0,'Kozmetika produkt','','','','kozmetika-produkt',''),(39,2,'0000-00-00 00:00:00',0,0,'Kozmetika produkt','','','','kozmetika-produkt',''),(40,1,'0000-00-00 00:00:00',0,0,'{d} Divider','','','','d-divider',''),(40,2,'0000-00-00 00:00:00',0,0,'{d} Divider','','','','d-divider',''),(41,1,'0000-00-00 00:00:00',0,0,'Olja grid','','','','olja-grid',''),(41,2,'0000-00-00 00:00:00',0,0,'Oil grid','','','','oil-grid',''),(42,1,'0000-00-00 00:00:00',0,0,'Olja produkt','','','','olja-produkt',''),(42,2,'0000-00-00 00:00:00',0,0,'Oil product','','','','oil-product',''),(43,1,'0000-00-00 00:00:00',0,0,'{i} Banner z designerjem','','','','i-banner-z-designerjem',''),(43,2,'0000-00-00 00:00:00',0,0,'{i} Banner z designerjem','','','','i-banner-z-designerjem',''),(44,1,'0000-00-00 00:00:00',0,0,'Designerji podkategorij','','','','designerji-podkategorij',''),(44,2,'0000-00-00 00:00:00',0,0,'Designerji podkategorij','','','','designerji-podkategorij',''),(45,1,'0000-00-00 00:00:00',0,0,'{d} Galerija za recepte','','','','d-galerija-za-recepte',''),(45,2,'0000-00-00 00:00:00',0,0,'{d} Galerija za recepte','','','','d-galerija-za-recepte',''),(46,1,'0000-00-00 00:00:00',0,0,'{d} Forma za rezervacijo','','','','d-forma-za-rezervacijo',''),(46,2,'0000-00-00 00:00:00',0,0,'{d} Forma za rezervacijo','','','','d-forma-za-rezervacijo','');

--
