/* Начало ноября 2015 */
ALTER TABLE `shop_product` ADD `k2type_import` VARCHAR(75) NOT NULL AFTER `sku_count`, ADD `k2keyimport` VARCHAR(75) NOT NULL AFTER `k2type_import`;

ALTER TABLE `shop_product` ADD INDEX(`k2type_import`);
ALTER TABLE `shop_product` ADD INDEX(`k2keyimport`);

ALTER TABLE `shop_category` ADD `k2type_import` VARCHAR(75), ADD `k2keyimport` VARCHAR(75);


/* 13.11.2015 */
CREATE TABLE `k2anticapcha` (
  `hashid` VARCHAR(150) COLLATE utf8_bin NOT NULL,
  `decode_capcha` VARCHAR(150) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`hashid`) USING BTREE
) ENGINE=InnoDB
CHARACTER SET 'utf8' COLLATE 'utf8_bin'
;


/* 15.11.2015 */
/* Ключевые слова детально */
CREATE TABLE `k2keywords` (
  `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `keyid` VARCHAR(75) NOT NULL,
  `keyrazrez` VARCHAR(75) NOT NULL,
  `keyword` VARCHAR(1024) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;


ALTER TABLE `k2keywords` ADD INDEX  (`keyrazrez`);

ALTER TABLE `k2keywords` ADD INDEX `k2keywords_idx1` (`keyid`, `keyrazrez`);


/* Ключевые слова суммарно */
CREATE TABLE `k2keys` (
  `k2keys` BIGINT(20) NOT NULL AUTO_INCREMENT,
  `keysid` VARCHAR(75) DEFAULT NULL,
  `keyrazrez` VARCHAR(75) DEFAULT NULL,
  `keywords` VARCHAR(10240) DEFAULT NULL,
  PRIMARY KEY (`k2keys`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;


ALTER TABLE `k2keys` ADD INDEX `k2keys_idx1` (`keysid`, `keyrazrez`);

ALTER TABLE `k2keys` ADD COLUMN `resurs` VARCHAR(75) DEFAULT NULL;

ALTER TABLE `k2keys` ADD INDEX `k2keys_idx2` (`resurs`);

ALTER TABLE `shop_product` ADD COLUMN `cnt_keywords` INTEGER(11) DEFAULT NULL;

ALTER TABLE `shop_product` ADD COLUMN `cnt_razrez_keywords` INTEGER(11) DEFAULT NULL;


ALTER TABLE `k2keys` ENGINE=InnoDB, CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

ALTER TABLE `k2keywords` ENGINE=InnoDB, CHARACTER SET 'utf8' COLLATE 'utf8_general_ci';

ALTER TABLE `k2keywords` ENGINE=MyISAM;

ALTER TABLE `k2keywords` MODIFY COLUMN `keyid` VARCHAR(75) COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `k2keywords` MODIFY COLUMN `keyrazrez` VARCHAR(75) COLLATE utf8_general_ci NOT NULL;

ALTER TABLE `k2keywords` MODIFY COLUMN `keyword` VARCHAR(1024) COLLATE utf8_general_ci DEFAULT NULL;


ALTER TABLE `k2keywords` ENGINE=InnoDB;

ALTER TABLE `k2keys` MODIFY COLUMN `keysid` VARCHAR(75) COLLATE utf8_general_ci DEFAULT NULL;

ALTER TABLE `k2keys` MODIFY COLUMN `keyrazrez` VARCHAR(75) COLLATE utf8_general_ci DEFAULT NULL;

ALTER TABLE `k2keys` MODIFY COLUMN `keywords` VARCHAR(10240) COLLATE utf8_general_ci DEFAULT NULL;

ALTER TABLE `k2keys` MODIFY COLUMN `resurs` VARCHAR(75) COLLATE utf8_general_ci DEFAULT NULL;



ALTER TABLE `shop_category_products` ADD `k2type_import` VARCHAR(75), ADD `k2keyimport` VARCHAR(75);
ALTER TABLE `shop_product_skus` ADD `k2type_import` VARCHAR(75), ADD `k2keyimport` VARCHAR(75);

ALTER TABLE `shop_category` ADD INDEX `shop_category_idx_keyimp` (`k2type_import`, `k2keyimport`);

ALTER TABLE `shop_category_products` ADD INDEX `shop_category_products_idx_keyimp` (`k2type_import`, `k2keyimport`);
ALTER TABLE `shop_product_skus` ADD INDEX `shop_product_skus_idx_keyimp` (`k2type_import`, `k2keyimport`);

ALTER TABLE `shop_product` ADD COLUMN `k2import_url` VARCHAR(2048) DEFAULT NULL;

/* 11.11.2015 */
CREATE TABLE `k2razrez_keywords` (
  `idrazrez` VARCHAR(75) NOT NULL UNIQUE,
  `name_razrez` VARCHAR(250) DEFAULT NULL,
  `comment` VARCHAR(250) DEFAULT NULL,
  PRIMARY KEY (`idrazrez`)
) ENGINE=InnoDB
CHECKSUM=0
DELAY_KEY_WRITE=0
PACK_KEYS=0
AUTO_INCREMENT=0
AVG_ROW_LENGTH=0
MIN_ROWS=0
MAX_ROWS=0
ROW_FORMAT=DEFAULT
KEY_BLOCK_SIZE=0;



/* Перевод магазина ShopScript на движек InnoDB */


ALTER TABLE `blog_blog` ENGINE=InnoDB;

ALTER TABLE `blog_category` ENGINE=InnoDB;

ALTER TABLE `blog_comment` ENGINE=InnoDB;

ALTER TABLE `blog_emailsubscription` ENGINE=InnoDB;

ALTER TABLE `blog_emailsubscription_log` ENGINE=InnoDB;

ALTER TABLE `blog_favorite` ENGINE=InnoDB;

ALTER TABLE `blog_page` ENGINE=InnoDB;

ALTER TABLE `blog_page_params` ENGINE=InnoDB;

ALTER TABLE `blog_post` ENGINE=InnoDB;

ALTER TABLE `blog_post_category` ENGINE=InnoDB;

ALTER TABLE `blog_post_params` ENGINE=InnoDB;

ALTER TABLE `blog_post_tag` ENGINE=InnoDB;

ALTER TABLE `blog_tag` ENGINE=InnoDB;

ALTER TABLE `blog_voting` ENGINE=InnoDB;

ALTER TABLE `checklists_list` ENGINE=InnoDB;

ALTER TABLE `checklists_list_items` ENGINE=InnoDB;

ALTER TABLE `contacts_history` ENGINE=InnoDB;

ALTER TABLE `contacts_rights` ENGINE=InnoDB;

ALTER TABLE `photos_album` ENGINE=InnoDB;

ALTER TABLE `photos_album_count` ENGINE=InnoDB;

ALTER TABLE `photos_album_params` ENGINE=InnoDB;

ALTER TABLE `photos_album_photos` ENGINE=InnoDB;

ALTER TABLE `photos_album_rights` ENGINE=InnoDB;

ALTER TABLE `photos_comment` ENGINE=InnoDB;

ALTER TABLE `photos_page` ENGINE=InnoDB;

ALTER TABLE `photos_page_params` ENGINE=InnoDB;

ALTER TABLE `photos_photo` ENGINE=InnoDB;

ALTER TABLE `photos_photo_exif` ENGINE=InnoDB;

ALTER TABLE `photos_photo_rights` ENGINE=InnoDB;

ALTER TABLE `photos_photo_tags` ENGINE=InnoDB;

ALTER TABLE `photos_publicgallery_vote` ENGINE=InnoDB;

ALTER TABLE `photos_tag` ENGINE=InnoDB;

ALTER TABLE `shop_abtest` ENGINE=InnoDB;

ALTER TABLE `shop_abtest_variants` ENGINE=InnoDB;

ALTER TABLE `shop_affiliate_transaction` ENGINE=InnoDB;

ALTER TABLE `shop_callb_request` ENGINE=InnoDB;

ALTER TABLE `shop_cart_items` ENGINE=InnoDB;

ALTER TABLE `shop_category` ENGINE=InnoDB;

ALTER TABLE `shop_category_images` ENGINE=InnoDB;

ALTER TABLE `shop_category_og` ENGINE=InnoDB;

ALTER TABLE `shop_category_params` ENGINE=InnoDB;

ALTER TABLE `shop_category_products` ENGINE=InnoDB;

ALTER TABLE `shop_category_routes` ENGINE=InnoDB;

ALTER TABLE `shop_checkout_flow` ENGINE=InnoDB;

ALTER TABLE `shop_contact_category_discount` ENGINE=InnoDB;

ALTER TABLE `shop_coupon` ENGINE=InnoDB;

ALTER TABLE `shop_coupon_plugin_template` ENGINE=InnoDB;

ALTER TABLE `shop_currency` ENGINE=InnoDB;

ALTER TABLE `shop_customer` ENGINE=InnoDB;

ALTER TABLE `shop_customernotes_notes` ENGINE=InnoDB;

ALTER TABLE `shop_customers_filter` ENGINE=InnoDB;

ALTER TABLE `shop_discount_by_sum` ENGINE=InnoDB;

ALTER TABLE `shop_expense` ENGINE=InnoDB;

ALTER TABLE `shop_favoriteproducts` ENGINE=InnoDB;

ALTER TABLE `shop_feature` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_color` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_dimension` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_double` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_range` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_text` ENGINE=InnoDB;

ALTER TABLE `shop_feature_values_varchar` ENGINE=InnoDB;

ALTER TABLE `shop_followup` ENGINE=InnoDB;

ALTER TABLE `shop_importexport` ENGINE=InnoDB;

ALTER TABLE `shop_kmcollectemails_email` ENGINE=InnoDB;

ALTER TABLE `shop_notification` ENGINE=InnoDB;

ALTER TABLE `shop_notification_params` ENGINE=InnoDB;

ALTER TABLE `shop_order` ENGINE=InnoDB;

ALTER TABLE `shop_order_items` ENGINE=InnoDB;

ALTER TABLE `shop_order_log` ENGINE=InnoDB;

ALTER TABLE `shop_order_log_params` ENGINE=InnoDB;

ALTER TABLE `shop_order_params` ENGINE=InnoDB;

ALTER TABLE `shop_page` ENGINE=InnoDB;

ALTER TABLE `shop_page_params` ENGINE=InnoDB;

ALTER TABLE `shop_plugin` ENGINE=InnoDB;

ALTER TABLE `shop_plugin_settings` ENGINE=InnoDB;

ALTER TABLE `shop_product` ENGINE=InnoDB;

ALTER TABLE `shop_product_features` ENGINE=InnoDB;

ALTER TABLE `shop_product_features_selectable` ENGINE=InnoDB;

ALTER TABLE `shop_product_images` ENGINE=InnoDB;

ALTER TABLE `shop_product_og` ENGINE=InnoDB;

ALTER TABLE `shop_product_pages` ENGINE=InnoDB;

ALTER TABLE `shop_product_params` ENGINE=InnoDB;

ALTER TABLE `shop_product_related` ENGINE=InnoDB;

ALTER TABLE `shop_product_reviews` ENGINE=InnoDB;

ALTER TABLE `shop_product_services` ENGINE=InnoDB;

ALTER TABLE `shop_product_skus` ENGINE=InnoDB;

ALTER TABLE `shop_product_stocks` ENGINE=InnoDB;

ALTER TABLE `shop_product_stocks_log` ENGINE=InnoDB;

ALTER TABLE `shop_product_tags` ENGINE=InnoDB;

ALTER TABLE `shop_productbrands` ENGINE=InnoDB;

ALTER TABLE `shop_promo` ENGINE=InnoDB;

ALTER TABLE `shop_promo_routes` ENGINE=InnoDB;

ALTER TABLE `shop_sales` ENGINE=InnoDB;

ALTER TABLE `shop_search_index` ENGINE=InnoDB;

ALTER TABLE `shop_search_word` ENGINE=InnoDB;

ALTER TABLE `shop_service` ENGINE=InnoDB;

ALTER TABLE `shop_service_variants` ENGINE=InnoDB;

ALTER TABLE `shop_set` ENGINE=InnoDB;

ALTER TABLE `shop_set_products` ENGINE=InnoDB;

ALTER TABLE `shop_stock` ENGINE=InnoDB;

ALTER TABLE `shop_tag` ENGINE=InnoDB;

ALTER TABLE `shop_tax` ENGINE=InnoDB;

ALTER TABLE `shop_tax_regions` ENGINE=InnoDB;

ALTER TABLE `shop_tax_zip_codes` ENGINE=InnoDB;

ALTER TABLE `shop_type` ENGINE=InnoDB;

ALTER TABLE `shop_type_features` ENGINE=InnoDB;

ALTER TABLE `shop_type_services` ENGINE=InnoDB;

ALTER TABLE `shop_type_upselling` ENGINE=InnoDB;

ALTER TABLE `site_block` ENGINE=InnoDB;

ALTER TABLE `site_domain` ENGINE=InnoDB;

ALTER TABLE `site_page` ENGINE=InnoDB;

ALTER TABLE `site_page_params` ENGINE=InnoDB;

ALTER TABLE `site_search_plugin_index` ENGINE=InnoDB;

ALTER TABLE `site_search_plugin_word` ENGINE=InnoDB;

ALTER TABLE `stickies_sheet` ENGINE=InnoDB;

ALTER TABLE `stickies_sticky` ENGINE=InnoDB;

ALTER TABLE `wa_announcement` ENGINE=InnoDB;

ALTER TABLE `wa_api_auth_codes` ENGINE=InnoDB;

ALTER TABLE `wa_api_tokens` ENGINE=InnoDB;

ALTER TABLE `wa_app_settings` ENGINE=InnoDB;

ALTER TABLE `wa_contact` ENGINE=InnoDB;

ALTER TABLE `wa_contact_categories` ENGINE=InnoDB;

ALTER TABLE `wa_contact_category` ENGINE=InnoDB;

ALTER TABLE `wa_contact_data` ENGINE=InnoDB;

ALTER TABLE `wa_contact_data_text` ENGINE=InnoDB;

ALTER TABLE `wa_contact_emails` ENGINE=InnoDB;

ALTER TABLE `wa_contact_field_values` ENGINE=InnoDB;

ALTER TABLE `wa_contact_rights` ENGINE=InnoDB;

ALTER TABLE `wa_contact_settings` ENGINE=InnoDB;

ALTER TABLE `wa_country` ENGINE=InnoDB;

ALTER TABLE `wa_dashboard` ENGINE=InnoDB;

ALTER TABLE `wa_group` ENGINE=InnoDB;

ALTER TABLE `wa_log` ENGINE=InnoDB;

ALTER TABLE `wa_login_log` ENGINE=InnoDB;

ALTER TABLE `wa_region` ENGINE=InnoDB;

ALTER TABLE `wa_transaction` ENGINE=InnoDB;

ALTER TABLE `wa_transaction_data` ENGINE=InnoDB;

ALTER TABLE `wa_user_groups` ENGINE=InnoDB;

ALTER TABLE `wa_widget` ENGINE=InnoDB;

ALTER TABLE `wa_widget_params` ENGINE=InnoDB;







ALTER TABLE `k2anticapcha` ENGINE=InnoDB;

ALTER TABLE `k2keys` ENGINE=InnoDB;

ALTER TABLE `k2keywords` ENGINE=InnoDB;

ALTER TABLE `k2razrez_keywords` ENGINE=InnoDB;