洞悉互聯(lián)網(wǎng)前沿資訊,探尋網(wǎng)站營銷規(guī)律
作者:狐靈科技 | 2020-05-19 18:00 |點擊:
訂單相關(guān)表:
truncate dsc_back_goods;
truncate dsc_back_order;
truncate dsc_baitiao_log;
truncate dsc_delivery_goods;
truncate dsc_delivery_order;
truncate dsc_order_goods;
truncate dsc_order_info;
truncate dsc_order_invoice;
truncate dsc_order_return;
truncate dsc_order_return_extend;
truncate dsc_pay_log;
truncate dsc_return_action;
truncate dsc_return_goods;
truncate dsc_goods_article;
truncate dsc_order_action;
truncate dsc_store_order;
白條(訂單相關(guān)):
truncate dsc_stages;
truncate dsc_baitiao;
truncate dsc_baitiao_log;
訂單消費儲值卡:
truncate dsc_value_card_record;
訂單消費優(yōu)惠券:
truncate dsc_coupons;
truncate dsc_coupons_user;
訂單消費紅包:
truncate dsc_bonus_type;
truncate dsc_user_bonus;
賬單結(jié)算相關(guān)表:
truncate dsc_seller_bill_goods;
truncate dsc_seller_bill_order;
truncate dsc_seller_commission_bill;
禮品卡、訂單結(jié)算等日志表:
truncate dsc_gift_gard_log;
商品分類相關(guān)表:
truncate dsc_category;
truncate dsc_merchants_category;
商品相關(guān)表:
truncate dsc_goods;
truncate dsc_goods_activity;
truncate dsc_goods_article;
truncate dsc_goods_attr;
truncate dsc_goods_cat;
truncate dsc_goods_conshipping;
truncate dsc_goods_consumption;
truncate dsc_goods_extend;
truncate dsc_goods_gallery;
truncate dsc_goods_inventory_logs;
truncate dsc_goods_type;
truncate dsc_group_goods;
truncate dsc_attribute;
truncate dsc_attribute_img;
truncate dsc_warehouse_area_attr;
truncate dsc_warehouse_area_goods;
truncate dsc_warehouse_attr;
truncate dsc_warehouse_freight;
truncate dsc_warehouse_freight_tpl;
truncate dsc_warehouse_goods;
truncate dsc_exchange_goods;
truncate dsc_favourable_activity;
truncate dsc_presale_activity;
truncate dsc_presale_cat;
truncate dsc_products;
truncate dsc_products_area;
truncate dsc_products_warehouse;
truncate dsc_package_goods;
商品運費模板:
truncate dsc_goods_transport;
truncate dsc_goods_transport_express;
truncate dsc_goods_transport_extend;
truncate dsc_goods_transport_tpl;
眾籌商品相關(guān)表:
truncate dsc_zc_category;
truncate dsc_zc_focus;
truncate dsc_zc_goods;
truncate dsc_zc_initiator;
truncate dsc_zc_progress;
truncate dsc_zc_project;
truncate dsc_zc_rank_logo;
truncate dsc_zc_topic;
會員相關(guān)表:
truncate dsc_users;
truncate dsc_users_auth;
truncate dsc_users_paypwd;
truncate dsc_users_real;
truncate dsc_users_type;
truncate dsc_user_account;
truncate dsc_user_account_fields;
truncate dsc_user_address;
truncate dsc_user_bank;
truncate dsc_user_bonus;
truncate dsc_user_feed;
truncate dsc_user_gift_gard;
truncate dsc_user_rank;
truncate dsc_account_log;
商家資金記錄相關(guān)表:
truncate dsc_merchants_account_log;
truncate dsc_seller_account_log;
商家分類相關(guān)表:
truncate dsc_merchants_category;
truncate dsc_merchants_category_temporarydate;
商家信息相關(guān)表:
truncate dsc_merchants_shop_information;
truncate dsc_merchants_steps_fields;
truncate dsc_seller_domain;
truncate dsc_merchants_grade;
truncate dsc_seller_qrcode;
truncate dsc_seller_shopinfo_changelog;
truncate dsc_seller_apply_info;
truncate dsc_seller_shopinfo;
如果是測試數(shù)據(jù),可以在后臺執(zhí)行一下(平臺->數(shù)據(jù)->SQL查詢)