关于大商创安装默认数据清空说明

大商创文档小组· 2019-10-31 11:06:50 阅读:228

883cf7f68faca79902a622d60500f533.gif

订单相关表:
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;

白条(订单相关):
truncate dsc_stages;
truncate dsc_baitiao;
truncate dsc_baitiao_log;
truncate dsc_baitiao_pay_log;
 
储值卡:
truncate dsc_value_card_type;
truncate dsc_value_card;

订单消费储值卡:
truncate dsc_value_card_record;

订单消费优惠券:
truncate dsc_coupons;
truncate dsc_coupons_user;

订单消费红包:
truncate dsc_bonus_type;
truncate dsc_user_bonus;

账单结算相关表:
truncate dsc_seller_bill_goods;
truncate dsc_seller_bill_order;
truncate dsc_seller_commission_bill;

负账单相关表【x版 v1.4.1】:
truncate dsc_seller_negative_bill;
truncate dsc_seller_negative_order;


礼品卡、订单结算等日志表:
truncate dsc_gift_gard_log;

商品分类相关表:
truncate dsc_category;
truncate dsc_merchants_category;

商品相关表:
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;

众筹商品相关表:
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;

会员相关表:
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;

商家资金记录相关表:
truncate dsc_merchants_account_log;
truncate dsc_seller_account_log;

商家分类相关表:
truncate dsc_merchants_category;
truncate dsc_merchants_category_temporarydate;

商家信息相关表:
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;
truncate dsc_seller_shopinfo_changelog;
truncate dsc_seller_apply_info;

如果是测试数据,可以在后台执行一下(平台->数据->SQL查询),如图:


如有真实数据,备份好表数据再清空,慎重操作执行。

大商创https://www.dscmall.cn/多用户商城系统是一款可以满足 B2B2C 、S2B2C、B2B、O2O、B2C等多种电商模式的新零售商城系统,覆盖PC端+ 微商城 + 小程序 +APP,将多端数据打通并同步,并且基于社交电商的用户优势,实现多场景营销,打造一个真正的生态化电商平台

咨询大商创,了解更多
一键咨询
咨询电话
4001-021-758
QQ咨询

QQ咨询

在线咨询

电话咨询

合作代理

微信咨询

返回顶部

服务热线

4001-021-758

功能和特性

价格和优惠

获取内部资料

添加微信咨询

关于大商创安装默认数据清空说明

大商创文档小组· 2019-10-31 11:06:50 阅读:228

883cf7f68faca79902a622d60500f533.gif

订单相关表:
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;

白条(订单相关):
truncate dsc_stages;
truncate dsc_baitiao;
truncate dsc_baitiao_log;
truncate dsc_baitiao_pay_log;
 
储值卡:
truncate dsc_value_card_type;
truncate dsc_value_card;

订单消费储值卡:
truncate dsc_value_card_record;

订单消费优惠券:
truncate dsc_coupons;
truncate dsc_coupons_user;

订单消费红包:
truncate dsc_bonus_type;
truncate dsc_user_bonus;

账单结算相关表:
truncate dsc_seller_bill_goods;
truncate dsc_seller_bill_order;
truncate dsc_seller_commission_bill;

负账单相关表【x版 v1.4.1】:
truncate dsc_seller_negative_bill;
truncate dsc_seller_negative_order;


礼品卡、订单结算等日志表:
truncate dsc_gift_gard_log;

商品分类相关表:
truncate dsc_category;
truncate dsc_merchants_category;

商品相关表:
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;

众筹商品相关表:
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;

会员相关表:
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;

商家资金记录相关表:
truncate dsc_merchants_account_log;
truncate dsc_seller_account_log;

商家分类相关表:
truncate dsc_merchants_category;
truncate dsc_merchants_category_temporarydate;

商家信息相关表:
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;
truncate dsc_seller_shopinfo_changelog;
truncate dsc_seller_apply_info;

如果是测试数据,可以在后台执行一下(平台->数据->SQL查询),如图:


如有真实数据,备份好表数据再清空,慎重操作执行。

大商创https://www.dscmall.cn/多用户商城系统是一款可以满足 B2B2C 、S2B2C、B2B、O2O、B2C等多种电商模式的新零售商城系统,覆盖PC端+ 微商城 + 小程序 +APP,将多端数据打通并同步,并且基于社交电商的用户优势,实现多场景营销,打造一个真正的生态化电商平台

最新文章