-- Table structure for table `nc5n2_finder_filters`
--

CREATE TABLE `nc5n2_finder_filters` (
  `filter_id` int UNSIGNED NOT NULL,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `state` tinyint(1) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `created_by` int UNSIGNED NOT NULL,
  `created_by_alias` varchar(255) NOT NULL,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int UNSIGNED NOT NULL DEFAULT '0',
  `checked_out` int UNSIGNED NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `map_count` int UNSIGNED NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `params` mediumtext
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

--
-- Table structure for table `nc5n2_finder_links`
--

CREATE TABLE `nc5n2_finder_links` (
  `link_id` int UNSIGNED NOT NULL,
  `url` varchar(255) NOT NULL,
  `route` varchar(255) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `indexdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `md5sum` varchar(32) DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '1',
  `state` int DEFAULT '1',
  `access` int DEFAULT '0',
  `language` varchar(8) NOT NULL,
  `publish_start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `publish_end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `list_price` double UNSIGNED NOT NULL DEFAULT '0',
  `sale_price` double UNSIGNED NOT NULL DEFAULT '0',
  `type_id` int NOT NULL,
  `object` mediumblob NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `nc5n2_finder_links`
--

INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(1, 'index.php?option=com_k2&view=item&id=1', 'index.php?option=com_k2&view=item&id=1:literature', 'Literature', 'OPURA            OPURA is CFIA approved          OPURA is FDA approved          OPURA is SGS approved          OPURA isstyle=\"color: #0000cd;\"> EXOVA-UAE approved          OPURA Bodycote test results          OPURA efficacy in vivo - University of Guelph ', '2012-08-18 15:17:23', '9b7970373ff943fcdcd43a3e45bcccba', 1, 1, 1, '*', '2012-06-29 11:01:11', '0000-00-00 00:00:00', '2012-06-29 11:01:11', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 25664 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(2, 'index.php?option=com_k2&view=item&id=2', 'index.php?option=com_k2&view=item&id=2:ozone-laundry-system&Itemid=191', 'Ozone Laundry System', 'ClearWater Tech’s EcoTex™ Advanced Laundry Oxidation Systems for commercial laundries are PROVEN to reduce utilities while providing superior disinfection By using mostly cold water, business operational costs can be reduced up to 50%. These unique system', '2012-08-20 00:07:55', 'e0ebf9b7fda4f9c123e501caa4688b54', 1, 1, 1, '*', '2012-06-29 11:02:37', '0000-00-00 00:00:00', '2012-06-29 11:02:37', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 27640 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(11, 'index.php?option=com_k2&view=item&id=3', 'index.php?option=com_k2&view=item&id=3:opura-ozone-generator&Itemid=190', 'OPURA™', 'Introducing OPURA ™ , a revolutionary way of cleaning and sanitizing without the use of dangerous chemicals or cleaners! OPURA ™ has been proven safe and effective in eradicating bacteria, viruses, fungus, mold sporesand other potential hazards commonly f', '2014-04-20 17:40:13', '7b5169b0c8f09f3107e01a78ed08059d', 1, 1, 1, '*', '2012-06-29 11:03:45', '0000-00-00 00:00:00', '2012-06-29 11:03:45', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 63404 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(4, 'index.php?option=com_k2&view=item&id=4', 'index.php?option=com_k2&view=item&id=4:ozone-applications-benefits', 'Ozone Applications', 'These characteristics and advantages make ozone extremely effective in a wide variety of applications including but not limited to the following. Medical (Equipment Sterilization, Hand Washing, Laundry) SOLUTIONS: OPURA , Ozone Laundry System Hotels and R', '2012-08-18 15:17:24', '736f2403e81f726ea7e9f03df9ce0087', 1, 1, 1, '*', '2012-06-29 11:05:09', '0000-00-00 00:00:00', '2012-06-29 11:05:09', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 43664 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(5, 'index.php?option=com_k2&view=item&id=5', 'index.php?option=com_k2&view=item&id=5:the-ozone-sanitation-advantages', 'The Ozone Sanitation Advantages', '·         Ozone kills bacteria 3000 times faster than chlorine ·         Ozone is the most powerful broad spectrum microbiological control agent available for safe usage ·         Ozone is 51% more powerful on bacterial cell walls than chlorine ·         ', '2012-08-18 15:17:24', 'e335932c0e27d86c3656fbae424125c1', 1, 1, 1, '*', '2012-06-29 11:06:23', '0000-00-00 00:00:00', '2012-06-29 11:06:23', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 20962 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(6, 'index.php?option=com_k2&view=item&id=6', 'index.php?option=com_k2&view=item&id=6:organisms-killed-by-ozone', 'Organisms Killed By Ozone', ':Ozone has the ability to kill most known bacteria and other common organisms BACTERIA Achromobacter butyri NCI-9404 Aeromonas harveyi NC-2 Aeromonas salmonicida NC-1102 Bacillus anthracis Bacillus cereus B. coagulans Bacillus globigii Bacillus lichenifor', '2012-08-23 01:30:36', 'da92eff664c7ef88207bf2a306c0de10', 1, 0, 1, '*', '2012-06-29 11:07:02', '0000-00-00 00:00:00', '2012-06-29 11:07:02', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 32784 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(7, 'index.php?option=com_k2&view=item&id=7', 'index.php?option=com_k2&view=item&id=7:why-ozone', 'Why Ozone?', '· Ozone kills bacteria 3000 times faster than chlorine · Ozone is the most powerful broad spectrum microbiological control agent available for safe usage · Ozone is 51% more powerful on bacterial cell walls than chlorine · Ozone REPLACES the use of hot wa', '2012-08-23 01:30:36', '69ecf75dc535271a00085a92fb94410e', 1, 0, 1, '*', '2012-06-29 11:08:20', '0000-00-00 00:00:00', '2012-06-29 11:08:20', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 21562 characters]),
(8, 'index.php?option=com_k2&view=item&id=8', 'index.php?option=com_k2&view=item&id=8:ozone-history', 'Ozone History', 'Originally discovered in the 19th Century, ozone, a form of activated oxygen generally produced during lighting storms and continuously occurring in the stratosphere due to the action of ultraviolet (UV) rays, is being rediscovered in the 21st century. Th', '2012-08-23 01:30:36', 'e08238a94e2e8dfc01e43acc92a348be', 1, 0, 1, '*', '2012-06-29 11:08:59', '0000-00-00 00:00:00', '2012-06-29 11:08:59', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 21172 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(9, 'index.php?option=com_k2&view=item&id=9', 'index.php?option=com_k2&view=item&id=9:what-is-ozone', 'What Is Ozone?', 'Ozone is a naturally produced chemical and is generated at every occurrence of a lightning strike during a thunderstorm. It is nature’s way of cleaning the air and water, removing germs and other contaminants and ensures that pollutants do not reach exces', '2012-08-23 01:30:36', 'f08d9f6a6044862a53093a0f73a59422', 1, 0, 1, '*', '2012-06-29 11:09:34', '0000-00-00 00:00:00', '2012-06-29 11:09:34', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 30858 characters]);
INSERT INTO `nc5n2_finder_links` (`link_id`, `url`, `route`, `title`, `description`, `indexdate`, `md5sum`, `published`, `state`, `access`, `language`, `publish_start_date`, `publish_end_date`, `start_date`, `end_date`, `list_price`, `sale_price`, `type_id`, `object`) VALUES
(10, 'index.php?option=com_k2&view=item&id=10', 'index.php?option=com_k2&view=item&id=10:water-purification', 'Water Purification', 'Ozone purifies water by destroying all bacterium, including trace levels of e.Coli and other pathogens, stabilizes chlorine residues and bonds to heavy metal ions negating their effect. Ozone has the additional benefit of eliminating all unpleasant smells', '2012-08-18 15:17:25', '4612619dc0912b340093a4e50f42c001', 1, 0, 1, '*', '2012-06-29 11:10:26', '0000-00-00 00:00:00', '2012-06-29 11:10:26', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 18954 characters]);

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

--
