zencart 清空产品订单客户 sql语句

最新推荐文章于 2018-01-06 15:31:15 发布

LINZHENYU1996

最新推荐文章于 2018-01-06 15:31:15 发布

阅读量2.5k

点赞数

分类专栏： zencart php 文章标签： sql zencart sql语句

本文链接：https://blog.csdn.net/LINZHENYU1996/article/details/60479108

版权

php 同时被 2 个专栏收录

7 篇文章 0 订阅

订阅专栏

zencart

2 篇文章 0 订阅

订阅专栏

TRUNCATE TABLE categories;
TRUNCATE TABLE categories_description;
TRUNCATE TABLE product_music_extra;
TRUNCATE TABLE product_types_to_category;
TRUNCATE TABLE products;
TRUNCATE TABLE products_attributes;
TRUNCATE TABLE products_attributes_download;
TRUNCATE TABLE products_description;
TRUNCATE TABLE products_discount_quantity;
TRUNCATE TABLE products_notifications;
TRUNCATE TABLE products_options;
TRUNCATE TABLE products_options_types;
TRUNCATE TABLE products_options_values;
TRUNCATE TABLE products_options_values_to_products_options;
TRUNCATE TABLE products_to_categories;
TRUNCATE TABLE meta_tags_categories_description;
TRUNCATE TABLE meta_tags_products_description;
TRUNCATE TABLE featured;
TRUNCATE TABLE salemaker_sales;
TRUNCATE TABLE specials;
TRUNCATE TABLE group_pricing;
TRUNCATE TABLE manufacturers;
TRUNCATE TABLE manufacturers_info;
TRUNCATE TABLE customers;
TRUNCATE TABLE customers_info;
TRUNCATE TABLE orders;
TRUNCATE TABLE orders_products;
TRUNCATE TABLE orders_products_attributes;
TRUNCATE TABLE seo_cache;
TRUNCATE TABLE sessions;
TRUNCATE TABLE whos_online;
TRUNCATE TABLE orders_total;
TRUNCATE TABLE orders_status_history;
TRUNCATE TABLE address_book;
TRUNCATE TABLE admin_activity_log;
TRUNCATE TABLE banners_history;
TRUNCATE TABLE counter;
TRUNCATE TABLE counter_history;
TRUNCATE TABLE coupon_redeem_track;
TRUNCATE TABLE customers_basket;
TRUNCATE TABLE customers_basket_attributes;