数据库清档SQL语句

admin

1. 
   
2. 
   & H2 |: v4 c9 S) q" e5 }8 m6 K
3. use account;
   
4. DELETE FROM C_IP_BAN;
   
5. DELETE FROM C_IP_PERMIT;
   0 A* t$ l9 d# X6 y8 p% z
6. DELETE FROM C_IP_PWD;
   / u" \: q# `# P. W5 M
7. DELETE FROM C_LOGINIPBLOCK_LOG;
   
8. DELETE FROM C_SEQUENCE;
   
9. DELETE FROM CP_USER_PROFILE;
   4 H8 r* e/ y4 ~& H! r  e$ |
10. DELETE FROM MB_USR_IP;
    
11. DELETE FROM MB_USR_PUN;
    
12. DELETE FROM Tbl_user;
    
13. DELETE FROM USER_CONNLOG_KEY;
    
14. DELETE FROM USER_PROFILE;
    ; ]% i- N% x4 _6 }" N5 b! @2 {
15. GO
    3 T0 }0 G7 W8 d1 ?' b" O4 H, z
16. use billing;
    
17. DELETE FROM bl_error_log;
    
18. DELETE FROM c_sequence;
    1 O* o7 I' P: c$ F) C  _4 ?& G
19. DELETE FROM dba_online_daily;
    8 ^& z, u3 v4 B) L! z/ H- g
20. DELETE FROM dba_online_daily_notok;
    
21. DELETE FROM Tbl_KeepId;
    
22. DELETE FROM user_account;
    $ t  _& Y7 r; q) N& H, \5 r: v
23. DELETE FROM user_account;
    
24. DELETE FROM user_charge_log;
    + ^  F! L3 V% h) h4 k
25. DELETE FROM user_everyday_use_info;
      I, |2 x! c& Q) N
26. DELETE FROM user_give_log;
    ' D/ Z2 Z7 M! l" k" g. R; J
27. DELETE FROM user_use_log;
    ( o5 ~. W9 \& C& a2 w6 T9 f$ C
28. DELETE FROM user_use_log_bk;
    
29. GO
    + ^4 V' V; H. V1 c
30. use cash;
    
31. DELETE FROM bl_error_log;
    6 G/ q% f- z0 u; H8 s# A
32. DELETE FROM Tbl_Cash_zj;
    
33. DELETE FROM user_cash;
    
34. DELETE FROM user_charge_log;
    
35. DELETE FROM user_use_log;
    6 _- l: g/ a  ~. F7 s, Y* }
36. GO
    
37. use character;
    * r, j5 e3 n* H- Q+ F
38. DELETE FROM C_EVENT_ITEM_OP
    1 U! `; m, Q8 N5 S$ v
39. DELETE FROM c_restword;
    
40. DELETE FROM char_connlog;
    ( L, M  |3 \. m+ b) G. ]
41. DELETE FROM CHAR_CONNLOG_KEY;
    
42. DELETE FROM DEL_USER_CHAR_LIST;
    
43. DELETE FROM DEL_USER_CHAR_LIST_SECEDE;
    
44. DELETE FROM GM_ITEM_MST;
    
45. DELETE FROM GUILD_CHAR_INFO;
    , z' `4 b9 Q8 N$ I/ C, k
46. DELETE FROM GUILD_INFO
    : {& z+ W8 g  e4 V6 O
47. WHERE guild_code NOT LIKE 'MASTERCODE';
    " m$ \3 h0 n1 g' }( h8 V6 _
48. DELETE FROM GUILD_INFO_SECEDE;
    : F$ Y% ]& e# E& L+ {; t# {
49. DELETE FROM GUILD_PEERAGE
    7 k" J, ?  j+ u
50. WHERE guild_code NOT LIKE 'MASTERCODE';
    9 b0 E2 R9 }5 z3 A0 B
51. DELETE FROM MSSNGR_CHAR_LIST;
    " ~& T4 I) L  l
52. DELETE FROM SIEGE_INFO;
    * B' t3 U* a5 V3 x$ L5 d, ]) B
53. DELETE FROM SIEGE_RESULT_LOG;
    # R  s# r, m3 X. k6 g! ^
54. DELETE FROM user_bag
    
55. WHERE character_no NOT LIKE 'DEKARON_000001';
    " N' H/ `, A+ z# E7 w) N
56. DELETE FROM user_bag_copy;
    8 E% F6 Y; V# L' j0 s/ j5 p
57. DELETE FROM user_bag_secede;
    
58. DELETE FROM user_character
    
59. WHERE character_no NOT LIKE 'DEKARON_000001';
    ( @) }: ]' ~* ^. p. i
60. DELETE FROM user_character_secede;
    ) v! W( F" k7 t( d8 D: d
61. DELETE FROM USER_POSTBOX;
    ) J' C: o6 N% [1 j% B2 G3 b
62. DELETE FROM USER_POSTBOX_SECEDE;
    
63. DELETE FROM User_Quest_Doing;
    " U( n( d1 ^3 [, ]* @' o
64. DELETE FROM user_quest_doing_secede;
    # z5 J6 Q  i7 F1 ~/ p
65. DELETE FROM User_Quest_Done;
    
66. DELETE FROM user_quest_done_secede;
    
67. DELETE FROM user_skill
    % d  E5 [9 r/ y/ K$ w
68. WHERE character_no NOT LIKE 'DEKARON_000001';
    * ]) {, S2 n% G9 _- O  y
69. DELETE FROM user_skill_secede
    
70. DELETE FROM user_slot
    , @, }" q8 M  P: x2 V
71. WHERE character_no NOT LIKE 'DEKARON_000001';
    
72. DELETE FROM user_storage;
    5 E7 R& m* T/ O/ T# u; N1 U' a* i
73. DELETE FROM user_storage_copy;
    " L+ z- c& b# Q- _2 ^1 }
74. DELETE FROM USER_STORE;
    9 N0 e( i9 Q5 @' Q# R: |, ?1 D8 t6 {
75. DELETE FROM USER_STORE_copy;
    1 L- V6 \6 p0 A
76. DELETE FROM USER_STORE_SECEDE;
    9 J" z3 X! p, e
77. DELETE FROM user_suit
    ; c  n5 @" B' Q$ c6 K$ [, A
78. WHERE character_no NOT LIKE 'DEKARON_000001';
    ) F+ ~- ]/ Q3 _  K6 j. _/ R
79. DELETE FROM user_suit_copy;
    
80. DELETE FROM user_suit_secede;
    
81. GO

复制代码

+ y7 d! C8 L& V/ n# H2 N

dxf0802

我是来学习的！

260072134

感谢楼主分享！！