Thor cleaning list mysql server

DELETE FROM `categories`;

DELETE FROM `categories_description`;

DELETE FROM `products`;

DELETE FROM `products_attributes`;

DELETE FROM `products_attributes_download`;

DELETE FROM `products_description`;

DELETE FROM `products_notifications`;

DELETE FROM `products_options`;

DELETE FROM `products_options_values`;

DELETE FROM `products_options_values_to_products_options`;

DELETE FROM `products_to_categories`;

DELETE FROM `reviews`;

DELETE FROM `reviews_description`;

DELETE FROM `sessions`;

DELETE FROM `specials`;

DELETE FROM `whos_online`;

ALTER TABLE categories AUTO_INCREMENT = 1;

ALTER TABLE products AUTO_INCREMENT = 1;

ALTER TABLE products_attributes AUTO_INCREMENT = 1;

ALTER TABLE products_description AUTO_INCREMENT = 1;

ALTER TABLE products_options_values_to_products_options AUTO_INCREMENT = 1;

ALTER TABLE reviews AUTO_INCREMENT = 1;

ALTER TABLE specials AUTO_INCREMENT = 1;

You may also like...