TRUNCATE `dmxd_action_log`;
TRUNCATE `dmxd_admin_code`;
TRUNCATE `dmxd_admin_history`;
TRUNCATE `dmxd_article`;
TRUNCATE `dmxd_article_category`;
TRUNCATE `dmxd_article_comment`;
TRUNCATE `dmxd_article_ext`;
TRUNCATE `dmxd_article_tag`;
TRUNCATE `dmxd_article_tag_list`;
TRUNCATE `dmxd_attachment`;
TRUNCATE `dmxd_collect`;
TRUNCATE `dmxd_coupon`;
TRUNCATE `dmxd_coupon_restrict`;
TRUNCATE `dmxd_cache_topic`;
TRUNCATE `dmxd_config_ip`;
TRUNCATE `dmxd_config_site`;
TRUNCATE `dmxd_config_sms`;
TRUNCATE `dmxd_finance_history`;
TRUNCATE `dmxd_message`;
TRUNCATE `dmxd_op_data`;
TRUNCATE `dmxd_page`;
TRUNCATE `dmxd_page_item`;
TRUNCATE `dmxd_payment_config`;
TRUNCATE `dmxd_pay_notify`;
TRUNCATE `dmxd_table_field`;
TRUNCATE `dmxd_table_field_append`;
TRUNCATE `dmxd_table_field_relation`;
TRUNCATE `dmxd_table_manage`;
TRUNCATE `dmxd_upload_file`;
TRUNCATE `dmxd_user`;
TRUNCATE `dmxd_user_address`;
TRUNCATE `dmxd_user_coupon`;
TRUNCATE `dmxd_user_data`;
TRUNCATE `dmxd_user_upload_file`;
TRUNCATE `dmxd_user_bankcard`;
TRUNCATE `dmxd_user_com_money_history`;
TRUNCATE `dmxd_user_config`;
TRUNCATE `dmxd_user_history`;
TRUNCATE `dmxd_user_info`;
TRUNCATE `dmxd_user_info_details`;
TRUNCATE `dmxd_user_integral`;
TRUNCATE `dmxd_user_integral_history`;
TRUNCATE `dmxd_user_integral_history_ext`;
TRUNCATE `dmxd_user_money`;
TRUNCATE `dmxd_user_money_history`;
TRUNCATE `dmxd_user_money_history_ext`;
TRUNCATE `dmxd_user_money_recharge`;
TRUNCATE `dmxd_user_money_recharge_ext`;
TRUNCATE `dmxd_user_money_withdraw`;
TRUNCATE `dmxd_user_tag`;
TRUNCATE `dmxd_user_tag_list`;
TRUNCATE `dmxd_user_token`;
TRUNCATE `dmxd_user_weixin`;
TRUNCATE `dmxd_user_weixin_from`;
TRUNCATE `dmxd_web_banner`;
TRUNCATE `dmxd_web_banner_type`;
TRUNCATE `dmxd_web_code`;
TRUNCATE `dmxd_web_link`;
TRUNCATE `dmxd_weixin`;
TRUNCATE `dmxd_weixin_act_qrcode`;
TRUNCATE `dmxd_weixin_keyreply`;
TRUNCATE `dmxd_weixin_material`;
TRUNCATE `dmxd_weixin_menu`;
TRUNCATE `dmxd_weixin_tpl`;
TRUNCATE `dmxd_weixin_tuwenreply`;
TRUNCATE `dmxd_order_track`;
TRUNCATE `dmxd_order_detail`;
TRUNCATE `dmxd_order`;
TRUNCATE `dmxd_user_sign`;
TRUNCATE `dmxd_product_browsing`;
TRUNCATE `dmxd_notice`;
TRUNCATE `dmxd_product`;

DELETE FROM `dmxd_auth_group_access` WHERE `group_id`>1;

ALTER TABLE `dmxd_user` AUTO_INCREMENT=1100;

ALTER TABLE `dmxd_user_info` AUTO_INCREMENT=1100;

ALTER TABLE `dmxd_user_address` AUTO_INCREMENT=1100;

ALTER TABLE `dmxd_user_bankcard` AUTO_INCREMENT=1100;

ALTER TABLE `dmxd_user_address` AUTO_INCREMENT=1100;

ALTER TABLE `dmxd_article` AUTO_INCREMENT=326;

UPDATE `dm8_base_kong`.`dmxd_finance` SET `u_receive` = '0', `u_pay` = '0', `u_amount` = '0', `c_receive` = '0', `c_pay` = '0', `c_amount` = '0', `total_comm_fee` = '0', `com_fee` = '0', `use_comm_fee` = '0' WHERE `dmxd_finance`.`id` = 1;