Есть такое.
INSTALL_SQL_BASE_FILE:
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch` (
`id_search` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_hook` int(10) unsigned NOT NULL,
`active` tinyint(4) NOT NULL DEFAULT '0',
`internal_name` varchar(255) NOT NULL,
`height` smallint(4) unsigned NOT NULL DEFAULT '0',
`width` smallint(4) unsigned NOT NULL DEFAULT '0',
`display_nb_result_on_blc` tinyint(3) unsigned NOT NULL DEFAULT '0',
`display_nb_result_criterion` tinyint(3) unsigned NOT NULL DEFAULT '0',
`save_selection` tinyint(3) unsigned NOT NULL DEFAULT '0',
`remind_selection` tinyint(3) unsigned NOT NULL DEFAULT '0',
`show_hide_crit_method` tinyint(3) unsigned NOT NULL DEFAULT '0',
`filter_by_emplacement` tinyint(3) unsigned NOT NULL DEFAULT '0',
`search_on_stock` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hide_empty_crit_group` tinyint(3) unsigned NOT NULL DEFAULT '0',
`search_method` tinyint(3) unsigned NOT NULL DEFAULT '0',
`dynamic_criterion` tinyint(3) unsigned NOT NULL DEFAULT '0',
`step_search` tinyint(3) unsigned NOT NULL DEFAULT '0',
`share` tinyint(3) unsigned NOT NULL DEFAULT '1',
`unique_search` tinyint(3) unsigned NOT NULL DEFAULT '0',
`scrolltop_active` tinyint(3) unsigned NOT NULL DEFAULT '1',
`id_category_root` int(10) unsigned NOT NULL DEFAULT '0',
`redirect_one_product` tinyint(3) unsigned NOT NULL DEFAULT '1',
`add_anchor_to_url` tinyint(3) unsigned NOT NULL DEFAULT '0',
`reset_group` tinyint(3) unsigned NOT NULL DEFAULT '1',
`collapsable_criterias` tinyint(3) unsigned NOT NULL DEFAULT '1',
`insert_in_center_column` tinyint(3) unsigned NOT NULL DEFAULT '0',
`smarty_var_name` varchar(64) NOT NULL,
`search_results_selector` varchar(64) NOT NULL DEFAULT '#center_column',
`recursing_indexing` tinyint(3) unsigned NOT NULL DEFAULT '0',
`display_empty_criteria` tinyint(3) unsigned NOT NULL DEFAULT '0',
`keep_category_information` tinyint(3) unsigned NOT NULL DEFAULT '0',
`priority_on_combination_image` tinyint(3) unsigned NOT NULL DEFAULT '0',
`use_cache` tinyint(3) unsigned NOT NULL DEFAULT '0',
`products_per_page` tinyint(3) unsigned NOT NULL DEFAULT '0',
`products_order_by` tinyint(3) unsigned NOT NULL DEFAULT '0',
`products_order_way` tinyint(3) unsigned NOT NULL DEFAULT '0',
`background_color` varchar(15) NULL,
`border_color` varchar(7) NULL,
`border_size` varchar(24) NULL,
`color_group_title` varchar(7) NULL,
`font_size_group_title` smallint(4) unsigned NULL DEFAULT '0',
`border_radius` smallint(4) unsigned NULL DEFAULT '0',
`color_title` varchar(7) NULL,
`font_size_title` smallint(4) unsigned NULL DEFAULT '0',
PRIMARY KEY (`id_search`),
KEY `id_hook` (`id_hook`),
KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_lang` (
`id_search` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`title` varchar(255) NOT NULL,
`description` text NOT NULL,
PRIMARY KEY (`id_search`, `id_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_shop` (
`id_search` int(11) NOT NULL,
`id_shop` int(11) NOT NULL,
PRIMARY KEY (`id_search`, `id_shop`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_category` (
`id_search` int(10) unsigned NOT NULL,
`id_category` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_search`, `id_category`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_cms` (
`id_search` int(10) unsigned NOT NULL,
`id_cms` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_search`, `id_cms`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_products` (
`id_search` int(10) unsigned NOT NULL,
`id_product` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_search`, `id_product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_manufacturers` (
`id_search` int(10) unsigned NOT NULL,
`id_manufacturer` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_search`, `id_manufacturer`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_suppliers` (
`id_search` int(10) unsigned NOT NULL,
`id_supplier` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_search`, `id_supplier`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_special_pages` (
`id_search` int(10) unsigned NOT NULL,
`page` varchar(255) NOT NULL,
PRIMARY KEY (`id_search`, `page`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_seo` (
`id_seo` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_search` int(10) unsigned NOT NULL,
`id_currency` int(10) unsigned NOT NULL,
`criteria` text NOT NULL,
`seo_key` varchar(32) NOT NULL,
`deleted` tinyint(3) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_seo`),
KEY `id_search` (`id_search`),
KEY `deleted` (`deleted`),
UNIQUE KEY `seo_key` (`seo_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_seo_lang` (
`id_seo` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`meta_title` varchar(128) NOT NULL,
`meta_description` varchar(255) NOT NULL,
`meta_keywords` varchar(255) NOT NULL,
`title` varchar(128) NOT NULL,
`description` text NOT NULL,
`seo_url` varchar(128) NOT NULL,
UNIQUE KEY `id_seo` (`id_seo`, `id_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_seo_crosslinks` (
`id_seo` int(10) unsigned NOT NULL,
`id_seo_linked` int(10) unsigned NOT NULL,
UNIQUE KEY `id_seo` (`id_seo`, `id_seo_linked`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSTALL_SQL_DYN_FILE:
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_group_ID_SEARCH`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_group_ID_SEARCH` (
`id_criterion_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_search` int(10) unsigned NOT NULL,
`criterion_group_type` varchar(24) NOT NULL,
`sort_by` varchar(10) DEFAULT 'position',
`sort_way` varchar(4) DEFAULT 'ASC',
`id_criterion_group_linked` int(10) unsigned NOT NULL,
`display_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
`is_multicriteria` tinyint(3) unsigned NOT NULL DEFAULT '0',
`range` tinyint(3) unsigned NOT NULL DEFAULT '0',
`range_nb` decimal(10,2) unsigned NOT NULL DEFAULT '15',
`show_all_depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
`only_children` tinyint(3) unsigned NOT NULL DEFAULT '0',
`is_collapsed` tinyint(3) unsigned NOT NULL DEFAULT '0',
`hidden` tinyint(3) unsigned NOT NULL DEFAULT '0',
`max_display` tinyint(3) unsigned NOT NULL DEFAULT '0',
`width` smallint(4) unsigned NOT NULL DEFAULT '0',
`overflow_height` smallint(4) unsigned NOT NULL DEFAULT '0',
`position` tinyint(3) unsigned NOT NULL DEFAULT '0',
`visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_criterion_group`),
KEY `id_search` (`id_search`,`visible`,`position`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_group_ID_SEARCH_lang`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_group_ID_SEARCH_lang` (
`id_criterion_group` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(255) NOT NULL,
`icon` varchar(20) NOT NULL,
`range_sign` varchar(32) default NULL,
`range_interval` varchar(255) default NULL,
PRIMARY KEY `id_criterion_group` (`id_criterion_group`,`id_lang`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH` (
`id_criterion` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_criterion_group` int(10) unsigned NOT NULL,
`position` int(10) unsigned DEFAULT '0',
`color` varchar(255) DEFAULT NULL,
`single_value` varchar(32) DEFAULT NULL,
`level_depth` tinyint(3) unsigned NOT NULL DEFAULT '0',
`id_parent` int(10) unsigned DEFAULT NULL,
`visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
`is_custom` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`id_criterion`),
KEY `id_criterion_group` (`id_criterion_group`),
KEY `level_depth` (`level_depth`),
KEY `position` (`position`),
KEY `id_parent` (`id_parent`),
KEY `visible` (`visible`),
KEY `single_value` (`single_value`),
KEY `is_custom` (`is_custom`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_link`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_link` (
`id_criterion` int(10) unsigned NOT NULL,
`id_criterion_linked` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_criterion`, `id_criterion_linked`),
KEY `id_criterion` (`id_criterion`),
KEY `id_criterion_linked` (`id_criterion_linked`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_list`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_list` (
`id_criterion_parent` int(10) unsigned NOT NULL,
`id_criterion` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_criterion_parent`, `id_criterion`),
KEY `id_criterion_parent` (`id_criterion_parent`),
KEY `id_criterion` (`id_criterion`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_lang`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_criterion_ID_SEARCH_lang` (
`id_criterion` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`value` varchar(255) NOT NULL,
`icon` varchar(20) NOT NULL,
PRIMARY KEY `id_criterion` (`id_criterion`,`id_lang`),
KEY `value` (`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_cache_product_criterion_ID_SEARCH`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_cache_product_criterion_ID_SEARCH` (
`id_criterion` int(10) unsigned NOT NULL,
`id_cache_product` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_criterion`,`id_cache_product`),
KEY `id_criterion2` (`id_criterion`),
KEY `id_criterion` (`id_criterion`, `id_cache_product`),
KEY `id_cache_product` (`id_cache_product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_cache_product_ID_SEARCH`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_cache_product_ID_SEARCH` (
`id_cache_product` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_product` int(10) unsigned NOT NULL,
PRIMARY KEY (`id_cache_product`),
UNIQUE KEY `id_product` (`id_product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `PREFIX_pm_advancedsearch_product_price_ID_SEARCH`;
CREATE TABLE IF NOT EXISTS `PREFIX_pm_advancedsearch_product_price_ID_SEARCH` (
`id_cache_product` int(10) unsigned NOT NULL,
`id_criterion_group` int(10) unsigned NOT NULL,
`id_shop` int(10) unsigned NOT NULL DEFAULT '0',
`id_currency` int(10) unsigned NOT NULL,
`id_country` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
`price_wt` decimal(20,6) NOT NULL,
`reduction_amount` decimal(20,6) NULL,
`reduction_type` enum('amount','percentage') NULL DEFAULT NULL,
`from` datetime NOT NULL,
`to` datetime NOT NULL,
`is_specific` tinyint(3) unsigned NOT NULL DEFAULT '0',
`has_no_specific` tinyint(3) unsigned NOT NULL DEFAULT '0',
`id_specific_price` int(10) unsigned DEFAULT NULL,
`valid_id_specific_price` int(10) unsigned DEFAULT '0',
PRIMARY KEY (`id_cache_product`,`id_currency`,`id_country`,`id_group`,`price_wt`,`from`,`to`,`reduction_amount`),
KEY `id_cache_product` (`id_cache_product`),
KEY `is_specific` (`is_specific`),
KEY `has_no_specific` (`has_no_specific`),
KEY `valid_id_specific_price` (`valid_id_specific_price`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
А что делать дальше, не подскажете?