('users','values_data_83',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"83\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"albanija\",\"same\":null}'),('articles','values_data_84',1,'2023-01-06 09:40:08','2024-01-05 09:40:08','{\"id\":\"84\",\"cached\":true,\"name\":\"roza\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"pink\",\"same\":\"1\"}'),('users','values_data_84',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"84\",\"cached\":true,\"name\":\"Al\\u017eirija\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"al\\u017eirija\",\"same\":null}'),('articles','values_data_84',2,'2022-10-24 11:16:35','2023-10-23 11:16:35','{\"id\":\"84\",\"cached\":true,\"name\":\"roza\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"pink\",\"same\":\"1\"}'),('users','values_data_84',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"84\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"al\\u017eirija\",\"same\":null}'),('articles','values_data_85',1,'2023-01-06 09:40:08','2024-01-05 09:40:08','{\"id\":\"85\",\"cached\":true,\"name\":\"rjava\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"brown\",\"same\":\"1\"}'),('users','values_data_85',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"85\",\"cached\":true,\"name\":\"Andora\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"andora\",\"same\":null}'),('articles','values_data_85',2,'2022-10-24 11:16:35','2023-10-23 11:16:35','{\"id\":\"85\",\"cached\":true,\"name\":\"rjava\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"brown\",\"same\":\"1\"}'),('users','values_data_85',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"85\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"andora\",\"same\":null}'),('articles','values_data_86',1,'2023-01-06 09:40:08','2024-01-05 09:40:08','{\"id\":\"86\",\"cached\":true,\"name\":\"rde\\u010da\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"red\",\"same\":\"1\"}'),('users','values_data_86',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"86\",\"cached\":true,\"name\":\"Angola\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"angola\",\"same\":null}'),('articles','values_data_86',2,'2022-10-24 11:16:35','2023-10-23 11:16:35','{\"id\":\"86\",\"cached\":true,\"name\":\"rde\\u010da\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-08-22 11:04:21\",\"value\":\"red\",\"same\":\"1\"}'),('users','values_data_86',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"86\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"angola\",\"same\":null}'),('articles','values_data_87',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"87\",\"cached\":true,\"name\":\"Pica\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"pizza\",\"same\":null}'),('users','values_data_87',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"87\",\"cached\":true,\"name\":\"Antigva in Barbuda\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"antigva_in_barbuda\",\"same\":null}'),('users','values_data_87',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"87\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"antigva_in_barbuda\",\"same\":null}'),('articles','values_data_88',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"88\",\"cached\":true,\"name\":\"Kozice\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"shrimp\",\"same\":null}'),('users','values_data_88',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"88\",\"cached\":true,\"name\":\"Argentina\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"argentina\",\"same\":null}'),('users','values_data_88',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"88\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"argentina\",\"same\":null}'),('articles','values_data_89',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"89\",\"cached\":true,\"name\":\"Riba\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"fish\",\"same\":null}'),('users','values_data_89',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"89\",\"cached\":true,\"name\":\"Armenija\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"armenija\",\"same\":null}'),('users','values_data_89',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"89\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"armenija\",\"same\":null}'),('articles','values_data_90',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"90\",\"cached\":true,\"name\":\"\\u0160koljke\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"shell\",\"same\":null}'),('users','values_data_90',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"90\",\"cached\":true,\"name\":\"Avstralija\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"avstralija\",\"same\":null}'),('users','values_data_90',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"90\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"avstralija\",\"same\":null}'),('articles','values_data_91',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"91\",\"cached\":true,\"name\":\"Solata\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"salad\",\"same\":null}'),('users','values_data_91',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"91\",\"cached\":true,\"name\":\"Azerbajd\\u017ean\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"azerbajd\\u017ean\",\"same\":null}'),('users','values_data_91',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"91\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"azerbajd\\u017ean\",\"same\":null}'),('articles','values_data_92',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"92\",\"cached\":true,\"name\":\"Koko\\u0161\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"chicken\",\"same\":null}'),('users','values_data_92',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"92\",\"cached\":true,\"name\":\"Bahami\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"bahami\",\"same\":null}'),('users','values_data_92',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"92\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"bahami\",\"same\":null}'),('articles','values_data_93',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"93\",\"cached\":true,\"name\":\"\\u0160pageti\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"spaghetti\",\"same\":null}'),('users','values_data_93',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"93\",\"cached\":true,\"name\":\"Bahrajn\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"bahrajn\",\"same\":null}'),('users','values_data_93',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"93\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"bahrajn\",\"same\":null}'),('articles','values_data_94',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"94\",\"cached\":true,\"name\":\"Brokoli\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"broccoli\",\"same\":null}'),('users','values_data_94',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"94\",\"cached\":true,\"name\":\"Banglade\\u0161\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"banglade\\u0161\",\"same\":null}'),('users','values_data_94',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"94\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"banglade\\u0161\",\"same\":null}'),('articles','values_data_95',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"95\",\"cached\":true,\"name\":\"Raca\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"goose\",\"same\":null}'),('users','values_data_95',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"95\",\"cached\":true,\"name\":\"Barbados\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"barbados\",\"same\":null}'),('users','values_data_95',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"95\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"barbados\",\"same\":null}'),('articles','values_data_96',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"96\",\"cached\":true,\"name\":\"Vaniljev sladoled\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"vanilla_ice_cream\",\"same\":null}'),('users','values_data_96',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"96\",\"cached\":true,\"name\":\"Baskovska republika\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"baskovska_republika\",\"same\":null}'),('users','values_data_96',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"96\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"baskovska_republika\",\"same\":null}'),('articles','values_data_97',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"97\",\"cached\":true,\"name\":\"\\u010cokoladni sladoled\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"chocolate_ice_cream\",\"same\":null}'),('users','values_data_97',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"97\",\"cached\":true,\"name\":\"Belgija\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"belgija\",\"same\":null}'),('users','values_data_97',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"97\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"belgija\",\"same\":null}'),('articles','values_data_98',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"98\",\"cached\":true,\"name\":\"Enolon\\u010dnica\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"soup\",\"same\":null}'),('users','values_data_98',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"98\",\"cached\":true,\"name\":\"Belize\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"belize\",\"same\":null}'),('users','values_data_98',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"98\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"belize\",\"same\":null}'),('articles','values_data_99',1,'2022-10-24 11:16:36','2023-10-23 11:16:36','{\"id\":\"99\",\"cached\":true,\"name\":\"Smoothie\",\"photo\":null,\"photos\":[],\"editdate\":\"2022-10-14 11:48:44\",\"value\":\"smoothie\",\"same\":null}'),('users','values_data_99',1,'2022-12-16 14:45:10','2023-12-15 14:45:10','{\"id\":\"99\",\"cached\":true,\"name\":\"Belorusija\",\"photo\":null,\"photos\":[],\"editdate\":\"0000-00-00 00:00:00\",\"value\":\"belorusija\",\"same\":null}'),('users','values_data_99',2,'2022-10-24 10:33:05','2023-10-23 10:33:05','{\"id\":\"99\",\"cached\":true,\"name\":null,\"photo\":null,\"photos\":[],\"editdate\":null,\"value\":\"belorusija\",\"same\":null}');

--
-- Table structure for table `ngn_wishlist_activity`
--

CREATE TABLE `ngn_wishlist_activity` (
  `activity_id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_module` varchar(30) NOT NULL,
  `parent_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL DEFAULT 0,
  `date` datetime NOT NULL,
  `date_end` datetime NOT NULL,
  `notification` int(11) NOT NULL,
  `activity_type` int(11) DEFAULT NULL,
  PRIMARY KEY (`activity_id`),
  KEY `news_id` (`parent_id`),
  KEY `user_id` (`user_id`),
  KEY `user_id_idx` (`activity_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_activity`
--


--
-- Table structure for table `ngn_wishlist_activity_language`
--

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

--
-- Dumping data for table `ngn_wishlist_activity_language`
--


--
-- Table structure for table `ngn_wishlist_atribute`
--

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

--
-- Dumping data for table `ngn_wishlist_atribute`
--

INSERT INTO `ngn_wishlist_atribute` VALUES (1,0,NULL,'','','','',1,0,'type','','','',0,'0000-00-00 00:00:00'),(2,1,NULL,'','','','',1,0,'extra_invoice','','','',0,'0000-00-00 00:00:00');

--
-- Table structure for table `ngn_wishlist_atribute_language`
--

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

--
-- Dumping data for table `ngn_wishlist_atribute_language`
--

INSERT INTO `ngn_wishlist_atribute_language` VALUES (1,1,'0000-00-00 00:00:00',0,1,'Tip daril','','','','',''),(2,1,'0000-00-00 00:00:00',0,1,'Povezan dokument','','','','',''),(2,2,'0000-00-00 00:00:00',0,0,'','','','','','');

--
-- Table structure for table `ngn_wishlist_atribute_links`
--

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

--
-- Dumping data for table `ngn_wishlist_atribute_links`
--


--
-- Table structure for table `ngn_wishlist_atribute_values`
--

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

--
-- Dumping data for table `ngn_wishlist_atribute_values`
--


--
-- Table structure for table `ngn_wishlist_atribute_values_language`
--

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

--
-- Dumping data for table `ngn_wishlist_atribute_values_language`
--


--
-- Table structure for table `ngn_wishlist_categories`
--

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

--
-- Dumping data for table `ngn_wishlist_categories`
--


--
-- Table structure for table `ngn_wishlist_category`
--

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

--
-- Dumping data for table `ngn_wishlist_category`
--


--
-- Table structure for table `ngn_wishlist_category_file`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_file`
--


--
-- Table structure for table `ngn_wishlist_category_files`
--

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

--
-- Dumping data for table `ngn_wishlist_category_files`
--


--
-- Table structure for table `ngn_wishlist_category_files_language`
--

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

--
-- Dumping data for table `ngn_wishlist_category_files_language`
--


--
-- Table structure for table `ngn_wishlist_category_groups`
--

CREATE TABLE `ngn_wishlist_category_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `position` int(11) NOT NULL,
  `transfer` int(11) NOT NULL DEFAULT 1,
  `category` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_id_2` (`category_id`,`group_id`),
  KEY `group_id` (`group_id`),
  KEY `category_id` (`category_id`),
  KEY `position` (`position`),
  CONSTRAINT `ngn_wishlist_category_groups_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_wishlist_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_wishlist_category_groups_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `ngn_wishlist_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_category_groups`
--


--
-- Table structure for table `ngn_wishlist_category_groups_atribute`
--

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

--
-- Dumping data for table `ngn_wishlist_category_groups_atribute`
--


--
-- Table structure for table `ngn_wishlist_category_groups_atribute_multi`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_groups_atribute_multi`
--


--
-- Table structure for table `ngn_wishlist_category_language`
--

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

--
-- Dumping data for table `ngn_wishlist_category_language`
--


--
-- Table structure for table `ngn_wishlist_category_links`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_links`
--


--
-- Table structure for table `ngn_wishlist_category_multi`
--

CREATE TABLE `ngn_wishlist_category_multi` (
  `user_id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `position` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`user_id`,`category_id`),
  KEY `category_id` (`category_id`),
  CONSTRAINT `ngn_wishlist_category_multi_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_wishlist_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_category_multi`
--


--
-- Table structure for table `ngn_wishlist_category_pages`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_pages`
--


--
-- Table structure for table `ngn_wishlist_category_photo`
--

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

--
-- Dumping data for table `ngn_wishlist_category_photo`
--


--
-- Table structure for table `ngn_wishlist_category_photo_gallery`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_photo_gallery`
--


--
-- Table structure for table `ngn_wishlist_category_photo_gallery_language`
--

CREATE TABLE `ngn_wishlist_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_wishlist_category_photo_gallery_language`
--


--
-- Table structure for table `ngn_wishlist_category_photo_language`
--

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

--
-- Dumping data for table `ngn_wishlist_category_photo_language`
--


--
-- Table structure for table `ngn_wishlist_category_roles`
--

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

--
-- Dumping data for table `ngn_wishlist_category_roles`
--


--
-- Table structure for table `ngn_wishlist_comments`
--

CREATE TABLE `ngn_wishlist_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_wishlist_comments`
--


--
-- Table structure for table `ngn_wishlist_comments_admin`
--

CREATE TABLE `ngn_wishlist_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_wishlist_comments_admin`
--


--
-- Table structure for table `ngn_wishlist_comments_files`
--

CREATE TABLE `ngn_wishlist_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_wishlist_comments_files`
--


--
-- Table structure for table `ngn_wishlist_comments_files_language`
--

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

--
-- Dumping data for table `ngn_wishlist_comments_files_language`
--


--
-- Table structure for table `ngn_wishlist_comments_language`
--

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

--
-- Dumping data for table `ngn_wishlist_comments_language`
--


--
-- Table structure for table `ngn_wishlist_comments_votes`
--

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

--
-- Dumping data for table `ngn_wishlist_comments_votes`
--


--
-- Table structure for table `ngn_wishlist_coupons`
--

CREATE TABLE `ngn_wishlist_coupons` (
  `coupon_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_name` varchar(100) NOT NULL,
  `coupon_code` varchar(100) NOT NULL,
  `coupon_createdate` datetime NOT NULL,
  `coupon_owner` int(11) NOT NULL,
  `coupon_enable` tinyint(1) NOT NULL,
  PRIMARY KEY (`coupon_id`),
  KEY `coupon_createdate` (`coupon_createdate`,`coupon_owner`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons`
--


--
-- Table structure for table `ngn_wishlist_coupons_items`
--

CREATE TABLE `ngn_wishlist_coupons_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon_id` int(11) NOT NULL,
  `item_createdate` datetime NOT NULL,
  `item_startdate` datetime NOT NULL,
  `item_enddate` datetime NOT NULL,
  `item_enable` tinyint(1) NOT NULL,
  `item_type` int(11) NOT NULL,
  `item_r1` int(11) NOT NULL,
  `item_r2` int(11) NOT NULL,
  `item_r3` int(11) NOT NULL,
  `item_bonus` double NOT NULL,
  `item_value` float NOT NULL,
  `item_tax` int(11) NOT NULL,
  `item_users` tinyint(1) NOT NULL,
  `item_links` tinyint(1) NOT NULL,
  `item_categories` tinyint(1) NOT NULL,
  `item_max_usage` int(11) NOT NULL,
  `item_max_usage_user` int(11) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `coupon_id` (`coupon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons_items`
--


--
-- Table structure for table `ngn_wishlist_coupons_items_categories`
--

CREATE TABLE `ngn_wishlist_coupons_items_categories` (
  `item_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `link_module` int(11) NOT NULL,
  `childs` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`link_id`,`link_module`),
  KEY `link_module` (`link_module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons_items_categories`
--


--
-- Table structure for table `ngn_wishlist_coupons_items_links`
--

CREATE TABLE `ngn_wishlist_coupons_items_links` (
  `item_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `link_module` int(11) NOT NULL,
  `exclude` tinyint(1) NOT NULL,
  PRIMARY KEY (`item_id`,`link_id`,`link_module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons_items_links`
--


--
-- Table structure for table `ngn_wishlist_coupons_items_links_variations`
--

CREATE TABLE `ngn_wishlist_coupons_items_links_variations` (
  `item_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `variation_id` int(11) NOT NULL,
  `module` int(11) NOT NULL,
  `exclude` int(11) NOT NULL,
  PRIMARY KEY (`item_id`,`link_id`,`variation_id`,`module`),
  KEY `module` (`module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons_items_links_variations`
--


--
-- Table structure for table `ngn_wishlist_coupons_items_users`
--

CREATE TABLE `ngn_wishlist_coupons_items_users` (
  `item_id` int(11) NOT NULL,
  `link_id` int(11) NOT NULL,
  `link_module` int(11) NOT NULL,
  `exclude` tinyint(1) NOT NULL,
  PRIMARY KEY (`item_id`,`link_id`),
  KEY `link_module` (`link_module`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_coupons_items_users`
--


--
-- Table structure for table `ngn_wishlist_coupons_language`
--

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

--
-- Dumping data for table `ngn_wishlist_coupons_language`
--


--
-- Table structure for table `ngn_wishlist_custom_values`
--

CREATE TABLE `ngn_wishlist_custom_values` (
  `user_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 (`user_id`,`category_id`,`gaid`,`language_id`),
  KEY `category_id` (`category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`),
  CONSTRAINT `ngn_wishlist_custom_values_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `ngn_users` (`user_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_wishlist_custom_values_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_wishlist_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_custom_values`
--


--
-- Table structure for table `ngn_wishlist_custom_values_multi`
--

CREATE TABLE `ngn_wishlist_custom_values_multi` (
  `user_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 (`user_id`,`category_id`,`gaid`,`language_id`,`valueInt`),
  KEY `item_order` (`item_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_custom_values_multi`
--


--
-- Table structure for table `ngn_wishlist_file`
--

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

--
-- Dumping data for table `ngn_wishlist_file`
--

INSERT INTO `ngn_wishlist_file` VALUES (2,'PDF','pdf','',1,'fa-file-pdf-o');

--
-- Table structure for table `ngn_wishlist_files`
--

CREATE TABLE `ngn_wishlist_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_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 `user_id` (`user_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_wishlist_files`
--


--
-- Table structure for table `ngn_wishlist_files_language`
--

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

--
-- Dumping data for table `ngn_wishlist_files_language`
--


--
-- Table structure for table `ngn_wishlist_friends`
--

CREATE TABLE `ngn_wishlist_friends` (
  `wishlist_id` int(11) NOT NULL,
  `friend_firstname` varchar(50) NOT NULL,
  `friend_lastname` varchar(50) NOT NULL,
  `friend_email` varchar(50) NOT NULL,
  `friend_hash` varchar(50) NOT NULL,
  `wishlist_confirmed` int(1) NOT NULL,
  `wishlist_sent` int(1) NOT NULL,
  `wishlist_sent_time` datetime NOT NULL,
  `wishlist_rsvp` int(11) NOT NULL,
  PRIMARY KEY (`wishlist_id`,`friend_email`),
  KEY `friend_hash` (`friend_hash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_friends`
--


--
-- Table structure for table `ngn_wishlist_friends_messages`
--

CREATE TABLE `ngn_wishlist_friends_messages` (
  `wishlist_id` int(11) NOT NULL,
  `wishlist_message` text NOT NULL,
  `wishlist_type` varchar(50) NOT NULL,
  `wishlist_years` int(11) NOT NULL,
  `wishlist_event` datetime NOT NULL,
  `wishlist_name` varchar(50) NOT NULL,
  `wishlist_gender` varchar(50) NOT NULL,
  PRIMARY KEY (`wishlist_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_friends_messages`
--


--
-- Table structure for table `ngn_wishlist_groups`
--

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

--
-- Dumping data for table `ngn_wishlist_groups`
--

INSERT INTO `ngn_wishlist_groups` VALUES (1,''),(2,'');

--
-- Table structure for table `ngn_wishlist_groups_atribute`
--

CREATE TABLE `ngn_wishlist_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_wishlist_groups_atribute_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `ngn_wishlist_groups` (`group_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_groups_atribute`
--

INSERT INTO `ngn_wishlist_groups_atribute` VALUES (1,1,1,0),(2,2,2,0);

--
-- Table structure for table `ngn_wishlist_groups_language`
--

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

--
-- Dumping data for table `ngn_wishlist_groups_language`
--

INSERT INTO `ngn_wishlist_groups_language` VALUES (1,1,'0000-00-00 00:00:00',0,1,'Tip daril','',NULL,NULL,NULL,''),(2,1,'0000-00-00 00:00:00',0,1,'Povezani dokument','',NULL,NULL,NULL,''),(2,2,'0000-00-00 00:00:00',0,0,'','','','','','');

--
-- Table structure for table `ngn_wishlist_invoice`
--

CREATE TABLE `ngn_wishlist_invoice` (
  `invoice_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `invoice_company` int(11) NOT NULL,
  `invoice_category` int(11) NOT NULL,
  `invoice_number` text NOT NULL,
  `invoice_year` int(11) NOT NULL,
  `invoice_counter` int(11) NOT NULL,
  `invoice_location` varchar(10) NOT NULL,
  `invoice_type` int(11) NOT NULL,
  `invoice_date` datetime DEFAULT NULL,
  `invoice_duedate` datetime DEFAULT NULL,
  `invoice_datepaid` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `invoice_datefinish` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `invoice_subtotal` decimal(10,2) NOT NULL,
  `invoice_credit` decimal(10,2) NOT NULL,
  `invoice_tax` decimal(10,2) NOT NULL,
  `invoice_tax2` decimal(10,2) NOT NULL,
  `invoice_total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `invoice_taxrate` decimal(10,2) NOT NULL,
  `invoice_taxrate2` decimal(10,2) NOT NULL,
  `invoice_status` varchar(40) NOT NULL,
  `invoice_substatus` int(11) NOT NULL,
  `invoice_sent` int(11) NOT NULL,
  `invoice_visible` int(11) NOT NULL,
  `invoice_paymentmethod` text NOT NULL,
  `invoice_notes` text NOT NULL,
  `invoice_delivery` varchar(100) NOT NULL,
  `invoice_reversal_relid` int(11) NOT NULL,
  `invoice_preforma_id` int(11) NOT NULL,
  `invoice_zoi` varchar(100) NOT NULL,
  `invoice_eor` varchar(100) NOT NULL,
  `invoice_qr` varchar(100) NOT NULL,
  `invoice_copy` int(11) NOT NULL,
  `invoice_address` int(11) NOT NULL,
  `invoice_billing` int(11) NOT NULL,
  `invoice_shipping` int(11) NOT NULL,
  `invoice_warehouse` int(11) NOT NULL,
  `invoice_transfer` int(11) NOT NULL,
  `invoice_email` varchar(200) NOT NULL,
  `imported` int(11) NOT NULL,
  `invoice_parcel` varchar(50) NOT NULL,
  `invoice_parcel_type` varchar(50) NOT NULL,
  `invoice_parcel_status` varchar(50) NOT NULL,
  PRIMARY KEY (`invoice_id`),
  KEY `userid` (`user_id`),
  KEY `status` (`invoice_status`(3)),
  KEY `user_id` (`user_id`),
  KEY `owner_id` (`owner_id`),
  KEY `invoice_reversal_relid` (`invoice_reversal_relid`),
  KEY `company_id` (`invoice_company`),
  KEY `invoice_type` (`invoice_type`),
  KEY `invoice_year` (`invoice_year`,`invoice_counter`),
  KEY `invoice_address` (`invoice_address`,`invoice_billing`,`invoice_shipping`),
  KEY `invoice_visible` (`invoice_visible`),
  KEY `invoice_preforma_id` (`invoice_preforma_id`),
  KEY `invoice_billing` (`invoice_billing`),
  KEY `invoice_shipping` (`invoice_shipping`),
  KEY `invoice_warehouse` (`invoice_warehouse`),
  KEY `invoice_transfer` (`invoice_transfer`),
  KEY `invoice_company` (`invoice_company`),
  KEY `imported` (`imported`),
  KEY `invoice_substatus` (`invoice_substatus`),
  KEY `language_id` (`language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice`
--


--
-- Table structure for table `ngn_wishlist_invoice_category`
--

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

--
-- Dumping data for table `ngn_wishlist_invoice_category`
--

INSERT INTO `ngn_wishlist_invoice_category` VALUES (2,1,'2017-03-09 18:46:13',NULL,NULL,0,NULL,0,0,0,0,0,NULL),(3,1,'2017-05-11 19:22:51',NULL,NULL,0,NULL,0,0,0,0,0,NULL);

--
-- Table structure for table `ngn_wishlist_invoice_category_language`
--

CREATE TABLE `ngn_wishlist_invoice_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`),
  CONSTRAINT `ngn_wishlist_invoice_category_language_ibfk_1` FOREIGN KEY (`category_id`) REFERENCES `ngn_wishlist_invoice_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_category_language`
--

INSERT INTO `ngn_wishlist_invoice_category_language` VALUES (2,1,'0000-00-00 00:00:00',0,0,'Želje','','','','zelje',''),(3,1,'0000-00-00 00:00:00',0,0,'Vabila','','','','vabila','');

--
-- Table structure for table `ngn_wishlist_invoice_company`
--

CREATE TABLE `ngn_wishlist_invoice_company` (
  `company_id` int(11) NOT NULL AUTO_INCREMENT,
  `company_default` int(11) NOT NULL DEFAULT 0,
  `company_name` varchar(200) NOT NULL,
  `company_note` varchar(200) NOT NULL,
  `company_address1` varchar(200) NOT NULL,
  `company_address2` varchar(200) NOT NULL,
  `company_city` varchar(200) NOT NULL,
  `company_country` int(11) NOT NULL,
  `company_street` varchar(100) NOT NULL,
  `company_number` varchar(100) NOT NULL,
  `company_additional` varchar(100) NOT NULL,
  `company_community` varchar(100) NOT NULL,
  `company_postal_name` varchar(100) NOT NULL,
  `company_postal` varchar(100) NOT NULL,
  `company_cadastral` int(11) NOT NULL,
  `company_building` int(11) NOT NULL,
  `company_section` int(11) NOT NULL,
  `company_type` int(11) NOT NULL,
  `company_prefix` varchar(200) NOT NULL,
  `company_device` varchar(200) NOT NULL,
  `company_date` date NOT NULL,
  `company_moving_name` varchar(200) NOT NULL,
  `company_moving_type` varchar(1) NOT NULL,
  `company_tax_id` varchar(50) NOT NULL,
  `company_logo` varchar(50) NOT NULL,
  `company_tel` varchar(50) NOT NULL,
  `company_gsm` varchar(50) NOT NULL,
  `company_trr` varchar(50) NOT NULL,
  `company_bank` varchar(200) NOT NULL,
  `company_preforma_numbering` varchar(200) NOT NULL,
  `company_invoice_numbering` varchar(200) NOT NULL,
  `company_credit_numbering` varchar(200) NOT NULL,
  `company_production_order_numbering` varchar(200) NOT NULL,
  `company_delivery_numbering` varchar(200) NOT NULL,
  `company_prepayment_invoice_numbering` varchar(200) NOT NULL,
  `company_order_form_numbering` varchar(200) NOT NULL,
  `company_reversal_numbering` varchar(200) NOT NULL,
  `company_tax` int(11) NOT NULL,
  `company_crc` varchar(30) NOT NULL,
  `company_fiscal_crc` varchar(30) NOT NULL,
  PRIMARY KEY (`company_id`),
  KEY `company_default` (`company_default`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_company`
--

INSERT INTO `ngn_wishlist_invoice_company` VALUES (1,1,'Firma','','Test 1','','Ljubljana',0,'','','','','','',0,0,0,0,'','','0000-00-00','','C','','','','','','','WP - {$number|%08d} - {$year|y}','WR - {$number|%08d} - {$year|y}','','','','','','',0,'1037565863','');

--
-- Table structure for table `ngn_wishlist_invoice_company_custom_counting`
--

CREATE TABLE `ngn_wishlist_invoice_company_custom_counting` (
  `counting_id` int(11) NOT NULL AUTO_INCREMENT,
  `counting_type` varchar(10) NOT NULL,
  `company_id` int(11) NOT NULL,
  `counting_name` varchar(100) NOT NULL,
  `counting_format` varchar(100) NOT NULL,
  PRIMARY KEY (`counting_id`),
  KEY `counting_type` (`counting_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_company_custom_counting`
--


--
-- Table structure for table `ngn_wishlist_invoice_counting`
--

CREATE TABLE `ngn_wishlist_invoice_counting` (
  `company_id` int(11) NOT NULL,
  `year` int(11) NOT NULL,
  `preforma_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `credit_id` int(11) NOT NULL DEFAULT 0,
  `production_order_id` int(11) NOT NULL DEFAULT 0,
  `delivery_id` int(11) NOT NULL DEFAULT 0,
  `prepayment_invoice_id` int(11) NOT NULL DEFAULT 0,
  `order_form_id` int(11) NOT NULL DEFAULT 0,
  `reversal_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`company_id`,`year`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_counting`
--


--
-- Table structure for table `ngn_wishlist_invoice_coupons`
--

CREATE TABLE `ngn_wishlist_invoice_coupons` (
  `invoice_id` int(11) NOT NULL,
  `coupon_id` int(11) NOT NULL,
  `coupon_date` datetime NOT NULL,
  `coupon_owner` int(11) NOT NULL,
  PRIMARY KEY (`invoice_id`,`coupon_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_coupons`
--


--
-- Table structure for table `ngn_wishlist_invoice_custom_values`
--

CREATE TABLE `ngn_wishlist_invoice_custom_values` (
  `invoice_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 (`invoice_id`,`category_id`,`gaid`,`language_id`),
  KEY `category_id` (`category_id`),
  KEY `gaid` (`gaid`),
  KEY `language_id` (`language_id`),
  KEY `valueInt` (`valueInt`),
  CONSTRAINT `ngn_wishlist_invoice_custom_values_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `ngn_wishlist_invoice` (`invoice_id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `ngn_wishlist_invoice_custom_values_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `ngn_wishlist_invoice_category` (`category_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_custom_values`
--


--
-- Table structure for table `ngn_wishlist_invoice_file`
--

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

--
-- Dumping data for table `ngn_wishlist_invoice_file`
--

INSERT INTO `ngn_wishlist_invoice_file` VALUES (2,'PDF','pdf','',1,'fa-file-pdf-o');

--
-- Table structure for table `ngn_wishlist_invoice_files`
--

CREATE TABLE `ngn_wishlist_invoice_files` (
  `file_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_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 `invoice_id` (`invoice_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_wishlist_invoice_files`
--


--
-- Table structure for table `ngn_wishlist_invoice_files_language`
--

CREATE TABLE `ngn_wishlist_invoice_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_wishlist_invoice_files_language`
--


--
-- Table structure for table `ngn_wishlist_invoice_groups`
--

CREATE TABLE `ngn_wishlist_invoice_groups` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_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 `invoice_category_id` (`invoice_category_id`),
  KEY `position` (`position`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_groups`
--

INSERT INTO `ngn_wishlist_invoice_groups` VALUES (1,1,1,0,1,0),(2,2,1,0,1,0),(3,3,1,0,1,0),(4,2,2,0,1,0);

--
-- Table structure for table `ngn_wishlist_invoice_groups_atribute`
--

CREATE TABLE `ngn_wishlist_invoice_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_wishlist_invoice_groups_atribute`
--


--
-- Table structure for table `ngn_wishlist_invoice_items`
--

CREATE TABLE `ngn_wishlist_invoice_items` (
  `item_id` int(11) NOT NULL AUTO_INCREMENT,
  `invoice_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `item_order` int(11) NOT NULL,
  `item_type` int(11) NOT NULL DEFAULT 0,
  `item_relid` int(11) NOT NULL,
  `item_parent` int(11) NOT NULL,
  `item_link` int(11) NOT NULL DEFAULT 0,
  `item_relmodule` varchar(30) NOT NULL,
  `item_description` text NOT NULL,
  `item_quantity` double NOT NULL,
  `item_multiplier` int(11) NOT NULL DEFAULT 1,
  `item_price` double NOT NULL,
  `item_amount` double NOT NULL,
  `item_taxed` int(1) NOT NULL,
  `item_em` int(11) NOT NULL,
  `item_total` double(10,2) NOT NULL,
  `item_purchase` double NOT NULL,
  `item_r1` double NOT NULL,
  `item_r2` double NOT NULL,
  `item_r3` double NOT NULL,
  `item_rabat` int(11) NOT NULL,
  `item_duedate` date DEFAULT NULL,
  `item_paymentmethod` text NOT NULL,
  `item_notes` text NOT NULL,
  `item_dispatched` int(1) NOT NULL DEFAULT 0,
  `item_relitem` int(11) NOT NULL,
  `item_relvariation` int(11) NOT NULL,
  PRIMARY KEY (`item_id`),
  KEY `invoiceid` (`invoice_id`),
  KEY `user_id` (`user_id`),
  KEY `item_relid` (`item_relid`),
  KEY `owner_id` (`owner_id`),
  KEY `item_order` (`item_order`),
  KEY `item_parent` (`item_parent`),
  KEY `item_relitem` (`item_relitem`),
  KEY `item_relvariation` (`item_relvariation`),
  KEY `item_purchase` (`item_purchase`),
  KEY `item_dispatched` (`item_dispatched`),
  KEY `item_link` (`item_link`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_items`
--


--
-- Table structure for table `ngn_wishlist_invoice_items_coupons`
--

CREATE TABLE `ngn_wishlist_invoice_items_coupons` (
  `item_id` int(11) NOT NULL,
  `item_r1` double NOT NULL,
  `item_r2` double NOT NULL,
  `item_r3` double NOT NULL,
  `item_price` double NOT NULL,
  `item_coupon_item` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_items_coupons`
--


--
-- Table structure for table `ngn_wishlist_invoice_items_custom_values`
--

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

--
-- Dumping data for table `ngn_wishlist_invoice_items_custom_values`
--


--
-- Table structure for table `ngn_wishlist_invoice_items_custom_values_multi`
--

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

--
-- Dumping data for table `ngn_wishlist_invoice_items_custom_values_multi`
--


--
-- Table structure for table `ngn_wishlist_invoice_items_log`
--

CREATE TABLE `ngn_wishlist_invoice_items_log` (
  `log_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL DEFAULT 0,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `item_type` int(11) NOT NULL,
  `item_parent` int(11) NOT NULL,
  `item_relid` int(11) NOT NULL,
  `item_relmodule` varchar(30) NOT NULL,
  `item_description` text NOT NULL,
  `item_quantity` double NOT NULL,
  `item_price` double NOT NULL,
  `item_amount` double NOT NULL,
  `item_taxed` int(1) NOT NULL,
  `item_em` int(11) NOT NULL,
  `item_total` double(10,2) NOT NULL,
  `item_purchase` double NOT NULL,
  `item_r1` double NOT NULL,
  `item_r2` double NOT NULL,
  `item_r3` double NOT NULL,
  `item_duedate` date DEFAULT NULL,
  `item_paymentmethod` text NOT NULL,
  `item_notes` text NOT NULL,
  `item_dispatched` int(1) NOT NULL DEFAULT 0,
  `item_relitem` int(11) NOT NULL,
  `item_relvariation` int(11) NOT NULL,
  PRIMARY KEY (`log_id`,`item_id`),
  KEY `itemid` (`item_id`),
  KEY `invoiceid` (`invoice_id`),
  KEY `user_id` (`user_id`),
  KEY `item_relid` (`item_relid`),
  KEY `owner_id` (`owner_id`),
  KEY `item_relitem` (`item_relitem`),
  KEY `item_relvariation` (`item_relvariation`),
  KEY `item_purchase` (`item_purchase`),
  KEY `item_dispatched` (`item_dispatched`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_items_log`
--


--
-- Table structure for table `ngn_wishlist_invoice_locations`
--

CREATE TABLE `ngn_wishlist_invoice_locations` (
  `location_id` int(11) NOT NULL AUTO_INCREMENT,
  `location_owner` int(11) NOT NULL,
  `location_enable` int(1) NOT NULL DEFAULT 0,
  `location_default` int(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`location_id`),
  KEY `location_owner` (`location_owner`),
  KEY `location_enable` (`location_enable`),
  KEY `location_default` (`location_default`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_locations`
--


--
-- Table structure for table `ngn_wishlist_invoice_locations_language`
--

CREATE TABLE `ngn_wishlist_invoice_locations_language` (
  `location_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 (`location_id`,`language_id`),
  KEY `language_id` (`language_id`),
  KEY `editdate` (`editdate`),
  CONSTRAINT `ngn_wishlist_invoice_locations_language_ibfk_1` FOREIGN KEY (`location_id`) REFERENCES `ngn_wishlist_invoice_locations` (`location_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_locations_language`
--


--
-- Table structure for table `ngn_wishlist_invoice_log`
--

CREATE TABLE `ngn_wishlist_invoice_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT,
  `log_user` int(11) NOT NULL,
  `log_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `invoice_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `owner_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `invoice_category` int(11) NOT NULL,
  `invoice_number` text NOT NULL,
  `invoice_date` datetime DEFAULT NULL,
  `invoice_duedate` datetime DEFAULT NULL,
  `invoice_datepaid` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `invoice_datefinish` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `invoice_subtotal` decimal(10,2) NOT NULL,
  `invoice_credit` decimal(10,2) NOT NULL,
  `invoice_tax` decimal(10,2) NOT NULL,
  `invoice_tax2` decimal(10,2) NOT NULL,
  `invoice_total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `invoice_taxrate` decimal(10,2) NOT NULL,
  `invoice_taxrate2` decimal(10,2) NOT NULL,
  `invoice_status` varchar(40) NOT NULL,
  `invoice_sent` int(11) NOT NULL,
  `invoice_paymentmethod` text NOT NULL,
  `invoice_notes` text NOT NULL,
  `invoice_delivery` varchar(100) NOT NULL,
  `invoice_reversal_relid` int(11) NOT NULL,
  `invoice_zoi` varchar(100) NOT NULL,
  `invoice_eor` varchar(100) NOT NULL,
  `invoice_qr` varchar(100) NOT NULL,
  `invoice_copy` int(11) NOT NULL,
  PRIMARY KEY (`log_id`),
  KEY `invoiceid` (`invoice_id`),
  KEY `userid` (`user_id`),
  KEY `status` (`invoice_status`(3)),
  KEY `user_id` (`user_id`),
  KEY `owner_id` (`owner_id`),
  KEY `invoice_reversal_relid` (`invoice_reversal_relid`),
  KEY `log_user` (`log_user`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_log`
--


--
-- Table structure for table `ngn_wishlist_invoice_substatus`
--

CREATE TABLE `ngn_wishlist_invoice_substatus` (
  `status_id` int(11) NOT NULL AUTO_INCREMENT,
  `status_var` varchar(100) CHARACTER SET latin1 NOT NULL,
  `status_enable` int(11) NOT NULL DEFAULT 0,
  `status_name` text CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`status_id`),
  KEY `status_var` (`status_var`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_substatus`
--

INSERT INTO `ngn_wishlist_invoice_substatus` VALUES (1,'PROCESSING',1,'V obdelavi'),(2,'CANCELLED',1,'Preklicano'),(3,'WITHELD',1,'Zadržano'),(4,'PRINTED',1,'Natisnjeno'),(5,'FINISHED',1,'Zaklju?eno');

--
-- Table structure for table `ngn_wishlist_invoice_tax`
--

CREATE TABLE `ngn_wishlist_invoice_tax` (
  `invoice_id` int(11) NOT NULL,
  `tax_id` int(11) NOT NULL,
  `tax_value` double NOT NULL,
  `tax_taxable` double NOT NULL,
  PRIMARY KEY (`invoice_id`,`tax_id`),
  KEY `tax_id` (`tax_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_tax`
--


--
-- Table structure for table `ngn_wishlist_invoice_templates`
--

CREATE TABLE `ngn_wishlist_invoice_templates` (
  `template_id` int(11) NOT NULL AUTO_INCREMENT,
  `template_owner` int(11) NOT NULL DEFAULT 0,
  `template_enable` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`template_id`),
  KEY `template_enable` (`template_enable`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_templates`
--


--
-- Table structure for table `ngn_wishlist_invoice_templates_language`
--

CREATE TABLE `ngn_wishlist_invoice_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`),
  CONSTRAINT `ngn_wishlist_invoice_templates_language_ibfk_1` FOREIGN KEY (`template_id`) REFERENCES `ngn_wishlist_invoice_templates` (`template_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_templates_language`
--


--
-- Table structure for table `ngn_wishlist_invoice_transactions`
--

CREATE TABLE `ngn_wishlist_invoice_transactions` (
  `transaction_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `currency` int(10) NOT NULL,
  `transaction_gateway` text NOT NULL,
  `transaction_date` datetime DEFAULT NULL,
  `transaction_description` text NOT NULL,
  `transaction_amountin` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transaction_fees` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transaction_amountout` decimal(10,2) NOT NULL DEFAULT 0.00,
  `transaction_reservation` decimal(10,2) NOT NULL,
  `transaction_rate` decimal(10,5) NOT NULL DEFAULT 1.00000,
  `transaction_transid` text NOT NULL,
  `transaction_trackid` text NOT NULL,
  `transaction_invoice_id` int(10) NOT NULL DEFAULT 0,
  `transaction_refund_id` int(10) NOT NULL DEFAULT 0,
  `transaction_ip` varchar(16) NOT NULL,
  `transaction_paymentid` varchar(45) NOT NULL,
  `transaction_result` varchar(45) NOT NULL,
  `transaction_error` text NOT NULL,
  PRIMARY KEY (`transaction_id`),
  KEY `invoiceid` (`transaction_invoice_id`),
  KEY `userid` (`user_id`),
  KEY `date` (`transaction_date`),
  KEY `transid` (`transaction_transid`(32))
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_invoice_transactions`
--


--
-- Table structure for table `ngn_wishlist_orders`
--

CREATE TABLE `ngn_wishlist_orders` (
  `order_id` int(10) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) NOT NULL,
  `order_package` int(10) NOT NULL,
  `order_registration_date` date NOT NULL,
  `order_paymentmethod` text NOT NULL,
  `order_firstpaymentamount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `order_amount` decimal(10,2) NOT NULL DEFAULT 0.00,
  `order_tax` decimal(10,2) NOT NULL DEFAULT 0.00,
  `order_billingcycle` text NOT NULL,
  `order_nextduedate` date DEFAULT NULL,
  `order_nextinvoicedate` date NOT NULL,
  `order_overidesuspend` int(11) NOT NULL,
  `order_overidesuspenddate` date NOT NULL,
  `order_status` varchar(60) NOT NULL,
  `order_promotion` int(11) NOT NULL,
  `order_promotion_type` int(11) NOT NULL,
  `order_promotion_value` decimal(2,0) NOT NULL,
  `order_note` text NOT NULL,
  `order_link` int(11) NOT NULL,
  PRIMARY KEY (`order_id`),
  KEY `domainstatus` (`order_status`),
  KEY `order_link` (`order_link`),
  KEY `productid` (`order_package`),
  KEY `userid` (`user_id`),
  KEY `order_nextduedate` (`order_nextduedate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_orders`
--


--
-- Table structure for table `ngn_wishlist_orders_custom_values`
--

CREATE TABLE `ngn_wishlist_orders_custom_values` (
  `order_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 (`order_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_wishlist_orders_custom_values`
--


--
-- Table structure for table `ngn_wishlist_photo`
--

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

--
-- Dumping data for table `ngn_wishlist_photo`
--


--
-- Table structure for table `ngn_wishlist_photo_album`
--

CREATE TABLE `ngn_wishlist_photo_album` (
  `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_wishlist_photo_album`
--


--
-- Table structure for table `ngn_wishlist_photo_gallery_language`
--

CREATE TABLE `ngn_wishlist_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_wishlist_photo_gallery_language`
--


--
-- Table structure for table `ngn_wishlist_photo_language`
--

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

--
-- Dumping data for table `ngn_wishlist_photo_language`
--


--
-- Table structure for table `ngn_wishlist_photo_sizes`
--

CREATE TABLE `ngn_wishlist_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_wishlist_photo_sizes`
--


--
-- Table structure for table `ngn_wishlist_photo_usage`
--

CREATE TABLE `ngn_wishlist_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_wishlist_photo_usage`
--


--
-- Table structure for table `ngn_wishlist_roles`
--

CREATE TABLE `ngn_wishlist_roles` (
  `role_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `user_edit` tinyint(11) NOT NULL DEFAULT 0,
  `user_delete` tinyint(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`role_id`,`user_id`),
  KEY `category_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `ngn_wishlist_roles`
--



