clear.sql 1.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051
  1. TRUNCATE TABLE wz_visit_statistics_by_day;
  2. TRUNCATE TABLE wz_user_withdraw;
  3. TRUNCATE TABLE wz_user_vip_order;
  4. TRUNCATE TABLE wz_user_vip_coupon;
  5. TRUNCATE TABLE wz_user_token;
  6. TRUNCATE TABLE wz_user_stars;
  7. TRUNCATE TABLE wz_user_report;
  8. TRUNCATE TABLE wz_user_point_log;
  9. TRUNCATE TABLE wz_user_org;
  10. TRUNCATE TABLE wz_user_open_auth;
  11. TRUNCATE TABLE wz_user_num;
  12. TRUNCATE TABLE wz_user_money_log;
  13. TRUNCATE TABLE wz_user_login_log;
  14. TRUNCATE TABLE wz_user_history;
  15. TRUNCATE TABLE wz_user_group_menu;
  16. TRUNCATE TABLE wz_user_favorite;
  17. TRUNCATE TABLE wz_user_coin_log;
  18. TRUNCATE TABLE wz_user_apply_cert;
  19. TRUNCATE TABLE wz_tag;
  20. TRUNCATE TABLE wz_tag_data;
  21. TRUNCATE TABLE wz_shopping_paycode;
  22. TRUNCATE TABLE wz_shopping_orderlog;
  23. TRUNCATE TABLE wz_shopping_order;
  24. TRUNCATE TABLE wz_shopping_commission_log;
  25. TRUNCATE TABLE wz_shopping_address;
  26. TRUNCATE TABLE wz_share_log;
  27. TRUNCATE TABLE wz_search_record;
  28. TRUNCATE TABLE wz_position_data;
  29. TRUNCATE TABLE wz_mp_msg;
  30. TRUNCATE TABLE wz_mobile_msg;
  31. TRUNCATE TABLE wz_message;
  32. TRUNCATE TABLE wz_message_read;
  33. TRUNCATE TABLE wz_login_times;
  34. TRUNCATE TABLE wz_ip_banned;
  35. TRUNCATE TABLE wz_friend_link;
  36. TRUNCATE TABLE wz_email_record;
  37. TRUNCATE TABLE wz_email_cert;
  38. TRUNCATE TABLE wz_doc_real_data;
  39. TRUNCATE TABLE wz_doc_real;
  40. TRUNCATE TABLE wz_doc_packfile;
  41. TRUNCATE TABLE wz_doc_data;
  42. TRUNCATE TABLE wz_doc_col;
  43. TRUNCATE TABLE wz_doc_auditlog;
  44. TRUNCATE TABLE wz_doc;
  45. TRUNCATE TABLE wz_copy_from;
  46. TRUNCATE TABLE wz_base64_img;
  47. TRUNCATE TABLE wz_bad_word;
  48. TRUNCATE TABLE wz_attachment_trash;
  49. TRUNCATE TABLE wz_attachment_index;
  50. TRUNCATE TABLE wz_attachment;
  51. TRUNCATE TABLE wz_adminlog;