CREATE TABLE IF NOT EXISTS `i370d_finder_filters` (
  `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `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(10) unsigned NOT NULL,
  `created_by_alias` varchar(255) NOT NULL,
  `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `modified_by` int(10) unsigned NOT NULL DEFAULT '0',
  `checked_out` int(10) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `map_count` int(10) unsigned NOT NULL DEFAULT '0',
  `data` text NOT NULL,
  `params` mediumtext,
  PRIMARY KEY (`filter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

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

--
-- Структура таблицы `i370d_finder_links`
--

CREATE TABLE IF NOT EXISTS `i370d_finder_links` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `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(5) DEFAULT '1',
  `access` int(5) 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(11) NOT NULL,
  `object` mediumblob NOT NULL,
  PRIMARY KEY (`link_id`),
  KEY `idx_type` (`type_id`),
  KEY `idx_title` (`title`),
  KEY `idx_md5` (`md5sum`),
  KEY `idx_url` (`url`(75)),
  KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
  KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=24 ;

--
-- Дамп данных таблицы `i370d_finder_links`
--

INSERT INTO `i370d_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=27', 'index.php?option=com_k2&view=item&id=27:word-from-the-founder&Itemid=504', 'Word From The Founder', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 13:39:29', 'f9d892598a7f52090a9070e99b87f503', 1, 1, 1, '*', '2012-06-20 03:09:03', '0000-00-00 00:00:00', '2012-06-20 03:09:03', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 21500 characters]),
(2, 'index.php?option=com_k2&view=item&id=28', 'index.php?option=com_k2&view=item&id=28:misson-an-goals&Itemid=504', 'Misson an Goals', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 13:39:30', '274637b6f5fe284c5eadc1c388e4c0cc', 1, 1, 1, '*', '2012-06-20 03:10:42', '0000-00-00 00:00:00', '2012-06-20 03:10:42', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 21602 characters]);
INSERT INTO `i370d_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
(3, 'index.php?option=com_k2&view=item&id=29', 'index.php?option=com_k2&view=item&id=29:about-the-company&Itemid=504', 'About the Company', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 13:39:30', 'f9449921f5841ff587bebaf5f9c0a8dd', 1, 1, 1, '*', '2012-06-20 03:11:30', '0000-00-00 00:00:00', '2012-06-20 03:11:30', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 20476 characters]),
(4, 'index.php?option=com_k2&view=item&id=26', 'index.php?option=com_k2&view=item&id=26:content-demo-135', 'Content Demo 1.3.5', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:42:15', '41eabda7628d7e17afa2f340258605bf', 1, 1, 1, '*', '2012-06-20 03:06:52', '0000-00-00 00:00:00', '2012-06-20 03:06:52', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 20386 characters]);
INSERT INTO `i370d_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=25', 'index.php?option=com_k2&view=item&id=25:content-demo-134', 'Content Demo 1.3.4', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:42:44', '86053aa83b144f2fade4a81b4ae5553f', 1, 1, 1, '*', '2012-06-20 03:06:13', '0000-00-00 00:00:00', '2012-06-20 03:06:13', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 20386 characters]),
(6, 'index.php?option=com_k2&view=item&id=24', 'index.php?option=com_k2&view=item&id=24:content-demo-133', 'Content Demo 1.3.3', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:43:16', '5c28b5eb2be7f5a09d31bd56ee726edc', 1, 1, 1, '*', '2012-06-20 03:05:20', '0000-00-00 00:00:00', '2012-06-20 03:05:20', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
INSERT INTO `i370d_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=23', 'index.php?option=com_k2&view=item&id=23:content-demo-132', 'Content Demo 1.3.2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:44:01', '51a886816b78cf27b44f014265369faa', 1, 1, 1, '*', '2012-06-20 03:04:29', '0000-00-00 00:00:00', '2012-06-20 03:04:29', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
INSERT INTO `i370d_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
(8, 'index.php?option=com_k2&view=item&id=22', 'index.php?option=com_k2&view=item&id=22:content-demo-131', 'Content Demo 1.3.1', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:44:33', '2077688d418811867449bc33148dfb54', 1, 1, 1, '*', '2012-06-20 03:03:39', '0000-00-00 00:00:00', '2012-06-20 03:03:39', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
INSERT INTO `i370d_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=21', 'index.php?option=com_k2&view=item&id=21:content-demo-125&Itemid=499', 'Content Demo 1.2.5', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:44:59', '3fecae4981cb43d175d33189d5394a18', 1, 1, 1, '*', '2012-06-20 03:01:17', '0000-00-00 00:00:00', '2012-06-20 03:01:17', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26958 characters]);
INSERT INTO `i370d_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=20', 'index.php?option=com_k2&view=item&id=20:content-demo-124&Itemid=499', 'Content Demo 1.2.4', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:45:22', '3952c207fc84d6020ffe3fdbedcaf244', 1, 1, 1, '*', '2012-06-20 03:00:07', '0000-00-00 00:00:00', '2012-06-20 03:00:07', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26958 characters]);
INSERT INTO `i370d_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=19', 'index.php?option=com_k2&view=item&id=19:content-demo-123&Itemid=499', 'Content Demo 1.2.3', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:45:46', '594e9a9f91ffbc767fc3359ef1eb53b5', 1, 1, 1, '*', '2012-06-20 02:58:54', '0000-00-00 00:00:00', '2012-06-20 02:58:54', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26958 characters]);
INSERT INTO `i370d_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
(12, 'index.php?option=com_k2&view=item&id=18', 'index.php?option=com_k2&view=item&id=18:content-demo-122&Itemid=499', 'Content Demo 1.2.2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:46:21', '8ea0d64e383b8ab370a5d3952c121d64', 1, 1, 1, '*', '2012-06-20 02:58:11', '0000-00-00 00:00:00', '2012-06-20 02:58:11', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26958 characters]);
INSERT INTO `i370d_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
(13, 'index.php?option=com_k2&view=item&id=17', 'index.php?option=com_k2&view=item&id=17:content-demo-121&Itemid=499', 'Content Demo 1.2.1', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:47:06', '16e139208ad0a0ff24957daab8c30382', 1, 1, 1, '*', '2012-06-20 02:57:24', '0000-00-00 00:00:00', '2012-06-20 02:57:24', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26958 characters]);
INSERT INTO `i370d_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
(14, 'index.php?option=com_k2&view=item&id=16', 'index.php?option=com_k2&view=item&id=16:content-demo-222', 'Content Demo 2.2.2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:47:34', '16beb7aabf7ed6088611527ff9841dd3', 1, 1, 1, '*', '2012-06-20 02:38:44', '0000-00-00 00:00:00', '2012-06-20 02:38:44', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
INSERT INTO `i370d_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
(15, 'index.php?option=com_k2&view=item&id=15', 'index.php?option=com_k2&view=item&id=15:content-demo-221', 'Content Demo 2.2.1', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:50:32', '8d279e4ae69af27d8204bc56439f8a66', 1, 1, 1, '*', '2012-06-20 02:38:11', '0000-00-00 00:00:00', '2012-06-20 02:38:11', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
INSERT INTO `i370d_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
(16, 'index.php?option=com_k2&view=item&id=14', 'index.php?option=com_k2&view=item&id=14:content-demo-212', 'Content Demo 2.1.2', 'Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor ', '2012-08-08 15:51:00', 'c2f53dee227a58323215db5d70135265', 1, 1, 1, '*', '2012-06-20 02:36:08', '0000-00-00 00:00:00', '2012-06-20 02:36:08', '0000-00-00 00:00:00', 0, 0, 1, 0x[encoded data, 26894 characters]);
