数据库清档SQL语句

admin

1. 
   * `/ l8 J& s7 Z
2. 
   
3. use account;
   8 u$ U/ T/ G3 e0 n8 L' _0 |
4. DELETE FROM C_IP_BAN;
   , n6 P( ]3 b/ {3 V. l
5. DELETE FROM C_IP_PERMIT;
     L2 A1 |0 R2 l0 W
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   ! x9 }+ L* Q5 t7 w/ b
8. DELETE FROM C_SEQUENCE;
   + G% u) {- l3 O2 d
9. DELETE FROM CP_USER_PROFILE;
   ( j: G7 Z* b% Q+ y! V
10. DELETE FROM MB_USR_IP;
    : G8 @/ C9 L: g6 _# P0 K6 n+ O+ A- Z4 _# m
11. DELETE FROM MB_USR_PUN;
    ( x5 _" g% _, s5 F
12. DELETE FROM Tbl_user;
    9 N5 o! y1 }7 p+ F! X2 v8 l
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    ; E/ o6 `4 R; {$ ]- U# ?
20. DELETE FROM dba_online_daily_notok;
    6 \! D" U, t# h; L. @
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    ) H# O' o1 s) p) m- Y& d
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    ) M9 Y9 e$ U  L; Y0 l9 t
26. DELETE FROM user_give_log;
    . s3 S8 I2 \+ e; M
27. DELETE FROM user_use_log;
    
28. DELETE FROM user_use_log_bk;
    
29. GO
    6 o8 I; Y4 V' D- E+ R9 y5 w
30. use cash;
    
31. DELETE FROM bl_error_log;
    ' G( x+ l$ ~: E) P# h: ~
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    ! ]5 W3 d$ P2 E
34. DELETE FROM user_charge_log;
    / z$ v' X! U% A: a
35. DELETE FROM user_use_log;
    
36. GO
    $ `, E8 i0 T8 g( N& F
37. use character;
    / |4 |% u8 j# e" c/ d
38. DELETE FROM C_EVENT_ITEM_OP
    - k* y; ]+ W% L  i- {' C0 _
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    ) M5 f* L1 U; |# }) m; H
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    8 m! K( q- H$ J' s& P3 j1 E
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    ( M9 @: o1 R, p; i* X7 d+ B) x
45. DELETE FROM GUILD_CHAR_INFO;
    
46. DELETE FROM GUILD_INFO
    
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    
48. DELETE FROM GUILD_INFO_SECEDE;
    6 n$ u- Y% X$ E9 A& S+ b7 i
49. DELETE FROM GUILD_PEERAGE
    - S) J) ~9 E; a1 g1 E
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    # C  Q& ?# V- n! [4 ^, I( X" x
54. DELETE FROM user_bag
    ! d5 o" U5 B+ t# L8 x' }  A
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 P3 U7 T* H9 c  w; z, a- E5 W: |
56. DELETE FROM user_bag_copy;
    
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    & ?. k& j( m2 p! D+ I
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ' W. \. d, V) ?
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    0 g1 v& u* q9 s/ y9 [2 H
62. DELETE FROM USER_POSTBOX_SECEDE;
    , d) N  a2 E+ C7 R! i1 l+ |! S* U
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    # e6 F3 N* T  X1 H
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    1 p1 v- W$ }2 q( z; |
69. DELETE FROM user_skill_secede
    " z4 P1 h* T0 }0 n( A
70. DELETE FROM user_slot
    ; F3 t' ]& I+ n0 F! W' u8 C5 i
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    6 z0 g& D2 l# w  |) ^. T
72. DELETE FROM user_storage;
    
73. DELETE FROM user_storage_copy;
    % h4 Q2 X( E7 \2 W, S/ _
74. DELETE FROM USER_STORE;
    , i. g) L$ n* E# n: _
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    ( m+ @9 t; R6 q# a8 B; b
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    9 U7 x/ E! B0 A" I1 W
81. GO

复制代码

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

admin

大张 发表于 2024-10-16 14:56
, e8 U9 N( H  C* U' Y语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

! Y: I% B) ~1 ]帖子里面有复制功能