数据库清档SQL语句

admin

1. 
   ! K; ]3 o9 I- {2 E* X6 t
2. 
   - J7 j' W* H* ?0 a
3. use account;
   
4. DELETE FROM C_IP_BAN;
   4 V1 z# E; l5 \( P9 I' d% ]
5. DELETE FROM C_IP_PERMIT;
   
6. DELETE FROM C_IP_PWD;
   
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   + y% _# Y6 h; \/ H& s
8. DELETE FROM C_SEQUENCE;
   9 L7 Z- `3 }4 r! a2 g
9. DELETE FROM CP_USER_PROFILE;
   # r7 D# {6 R6 g; w
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    - `3 X! J) h& H
12. DELETE FROM Tbl_user;
    & p  L8 T  i7 l9 P: r0 P( Y
13. DELETE FROM USER_CONNLOG_KEY;
    8 r5 F) m5 K. N
14. DELETE FROM USER_PROFILE;
    # H" |. `- O1 T8 U2 R9 b6 w; a
15. GO
    
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    
19. DELETE FROM dba_online_daily;
    
20. DELETE FROM dba_online_daily_notok;
    # X( y$ X: T5 J
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    
23. DELETE FROM user_account;
    : Q+ o6 x8 f: U& X
24. DELETE FROM user_charge_log;
    
25. DELETE FROM user_everyday_use_info;
    $ B3 M. c% I- E8 V* T6 O
26. DELETE FROM user_give_log;
    % b4 k; o/ y8 v& ]7 o
27. DELETE FROM user_use_log;
    . P- X1 S% \3 X; H( t
28. DELETE FROM user_use_log_bk;
    : v- P5 A% S/ W8 T
29. GO
    ; ~6 y1 x3 }* e$ c3 z
30. use cash;
    
31. DELETE FROM bl_error_log;
    8 J1 s0 ]4 Y9 \& G
32. DELETE FROM Tbl_Cash_zj;
    1 p$ ]8 c, q/ ]/ |' Y
33. DELETE FROM user_cash;
    + ?0 s) n2 c. h, v
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    8 M* y! J: L6 x9 p
36. GO
    ( S1 {& n+ V  r& b  a3 M$ V1 T
37. use character;
    4 }' J9 o- Z# t9 b1 g) S: H
38. DELETE FROM C_EVENT_ITEM_OP
    
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    9 C- p- ^' b- Y0 x. E
41. DELETE FROM CHAR_CONNLOG_KEY;
    7 y  }9 u1 T0 [
42. DELETE FROM DEL_USER_CHAR_LIST;
    6 \/ ]! j5 r6 ?
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    5 T  F' h7 S; }, B9 R
46. DELETE FROM GUILD_INFO
    0 h0 S& u  r: J7 d' L* U
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    . a8 o7 m' E" K, h
48. DELETE FROM GUILD_INFO_SECEDE;
    
49. DELETE FROM GUILD_PEERAGE
    , O: F; n1 k2 X# p1 {' _1 @% Z
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    
51. DELETE FROM MSSNGR_CHAR_LIST;
    
52. DELETE FROM SIEGE_INFO;
    
53. DELETE FROM SIEGE_RESULT_LOG;
    
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    
56. DELETE FROM user_bag_copy;
    6 u5 |9 o1 A& L, \8 @
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    
60. DELETE FROM user_character_secede;
    
61. DELETE FROM USER_POSTBOX;
    
62. DELETE FROM USER_POSTBOX_SECEDE;
    $ c% a1 Y- [* D
63. DELETE FROM User_Quest_Doing;
    
64. DELETE FROM user_quest_doing_secede;
    
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';
    & P. P% ^! y, P/ |
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    - Q3 M' P; s: u' ~0 w, E& w
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    & ]; a! u& |; p6 @- ?2 U
72. DELETE FROM user_storage;
    2 ^: K5 k+ O$ y3 e. s3 F! Z) L
73. DELETE FROM user_storage_copy;
    4 ~7 K; V8 F0 z+ Q5 F" z
74. DELETE FROM USER_STORE;
    
75. DELETE FROM USER_STORE_copy;
    
76. DELETE FROM USER_STORE_SECEDE;
    
77. DELETE FROM user_suit
    
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    / L9 e* I: M+ E+ \
79. DELETE FROM user_suit_copy;
    + a3 A% ^9 Y: F, ]" M0 E7 q2 ?2 H9 q
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

7 x. P5 O+ r# O/ i3 X% W

dxf0802

我是来学习的！

260072134

感谢楼主分享！！

cao121

干活学习

大张

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

admin

大张 发表于 2024-10-16 14:56
语句 出现 乱码 请  改正一下 哦  谢谢 了 ~~~~~~~~~~~~~~！

  ]/ \: h) _4 {1 o8 q. z& Y帖子里面有复制功能