Page Comparison

...

Code Block

language	sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `PREFIX_rating_option_vote`;
TRUNCATE TABLE `PREFIX_rating_option_vote_aggregated`;
TRUNCATE TABLE `PREFIX_review`;
TRUNCATE TABLE `PREFIX_review_detail`;
TRUNCATE TABLE `PREFIX_review_entity_summary`;
TRUNCATE TABLE `PREFIX_review_store`;

Code Block

language	sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE `PREFIX_customer_address_entity`;
TRUNCATE `PREFIX_customer_address_entity_datetime`;
TRUNCATE `PREFIX_customer_address_entity_decimal`;
TRUNCATE `PREFIX_customer_address_entity_int`;
TRUNCATE `PREFIX_customer_address_entity_text`;
TRUNCATE `PREFIX_customer_address_entity_varchar`;
TRUNCATE `PREFIX_customer_entity`;
TRUNCATE `PREFIX_customer_entity_datetime`;
TRUNCATE `PREFIX_customer_entity_decimal`;
TRUNCATE `PREFIX_customer_entity_int`;
TRUNCATE `PREFIX_customer_entity_text`;
TRUNCATE `PREFIX_customer_entity_varchar`;

ALTER TABLE `PREFIX_customer_address_entity` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_address_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_address_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_address_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_address_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_address_entity_varchar` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity_datetime` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity_decimal` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity_int` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity_text` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_customer_entity_varchar` AUTO_INCREMENT=1;

Code Block

language	sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `PREFIX_catalog_category_entity`;
TRUNCATE TABLE `PREFIX_catalog_category_entity_datetime`;
TRUNCATE TABLE `PREFIX_catalog_category_entity_decimal`;
TRUNCATE TABLE `PREFIX_catalog_category_entity_int`;
TRUNCATE TABLE `PREFIX_catalog_category_entity_text`;
TRUNCATE TABLE `PREFIX_catalog_category_entity_varchar`;
TRUNCATE TABLE `PREFIX_catalog_category_product`;
TRUNCATE TABLE `PREFIX_catalog_category_product_index`;
INSERT INTO `PREFIX_catalog_category_entity` (`entity_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES
(1, 0, 0, '2016-05-09 08:03:52', '2016-05-09 08:03:52', '1', 0, 0, 1),
(2, 3, 1, '2016-05-09 08:03:52', '2016-05-09 08:03:52', '1/2', 1, 1, 0);

Code Block

language	sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE `PREFIX_sales_order`;
TRUNCATE `PREFIX_sendfriend_log`;
TRUNCATE `PREFIX_wishlist`;
TRUNCATE `PREFIX_report_event`;

ALTER TABLE `PREFIX_sales_order` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_sendfriend_log` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_wishlist` AUTO_INCREMENT=1;
ALTER TABLE `PREFIX_report_event` AUTO_INCREMENT=1;

Code Block

language	sql

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE `PREFIX_catalogsearch_fulltext_scope1`;
TRUNCATE TABLE `PREFIX_catalogsearch_fulltext_scope2`;
TRUNCATE TABLE `PREFIX_search_query`;

Code Block

language	sql

TRUNCATE `PREFIX_eav_entity_store`;
ALTER TABLE `PREFIX_eav_entity_store` AUTO_INCREMENT=1;

...

Versions Compared

Old Version 2

New Version Current

Key