手动执行下面的sql- CREATE TABLE `pre_common_member_archive` (9 J% q2 o7 p. K& N4 U$ P& T
- `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
/ O( @5 y* T* B3 ^, n - `email` char(40) NOT NULL DEFAULT '',
+ M* |0 b3 K D/ S! g3 \ - `username` char(15) NOT NULL DEFAULT ''," p% R/ |- z# v: k3 {0 }3 y
- `password` char(32) NOT NULL DEFAULT '',
4 z- z: }1 x* R2 D1 S- w - `status` tinyint(1) NOT NULL DEFAULT '0',
; [1 C% ~+ m5 A$ t9 z - `emailstatus` tinyint(1) NOT NULL DEFAULT '0',
6 H- ~) R6 u ^ H - `avatarstatus` tinyint(1) NOT NULL DEFAULT '0'," m/ x& Z4 B" U+ \- }3 d6 a
- `videophotostatus` tinyint(1) NOT NULL DEFAULT '0',
; ~9 @$ Z: H/ |' C5 s; M - `adminid` tinyint(1) NOT NULL DEFAULT '0',
% j3 @: H6 s2 X* m ~! y' c" t - `groupid` smallint(6) unsigned NOT NULL DEFAULT '0',
4 k, i5 P: Z! x9 P - `groupexpiry` int(10) unsigned NOT NULL DEFAULT '0',
8 [1 T$ F1 p. ]2 v; x - `extgroupids` char(20) NOT NULL DEFAULT '',! q4 i% {8 ~7 k( z
- `regdate` int(10) unsigned NOT NULL DEFAULT '0',! e- J1 g; _6 Z
- `credits` int(10) NOT NULL DEFAULT '0',7 s2 j4 a! a$ h' C. D1 W
- `notifysound` tinyint(1) NOT NULL DEFAULT '0',9 u6 V8 o! l* k6 ^2 g, I
- `timeoffset` char(4) NOT NULL DEFAULT '',
7 \* m' C2 ?& ?5 ` - `newpm` smallint(6) unsigned NOT NULL DEFAULT '0',
- W( o+ j! |9 \+ h/ R' g' H - `newprompt` smallint(6) unsigned NOT NULL DEFAULT '0',! q; \, |3 ~( ?
- `accessmasks` tinyint(1) NOT NULL DEFAULT '0',6 g# } O9 H/ T* K
- `allowadmincp` tinyint(1) NOT NULL DEFAULT '0',
Q& l2 u! K' t- w - `onlyacceptfriendpm` tinyint(1) NOT NULL DEFAULT '0',
% C3 Y8 u- X1 x2 B - `conisbind` tinyint(1) unsigned NOT NULL DEFAULT '0',! b) ]: S5 c' o g
- `wxaccount` char(40) NOT NULL DEFAULT '',6 J) m# E7 b5 G7 _4 Z+ d& X
- `zfbaccount` char(40) NOT NULL DEFAULT '',8 s' E4 H! X p! s: Z E
- PRIMARY KEY (`uid`),/ m v1 k4 J( W6 k! `/ h
- UNIQUE KEY `username` (`username`),
2 I; k7 s' ?4 u. T; P# d( W - KEY `email` (`email`),2 T9 d( I: e' F# r7 ~/ ]
- KEY `groupid` (`groupid`),
6 Y& B( u+ l6 q9 A5 w - KEY `conisbind` (`conisbind`)
# k) H* Q+ d% x5 b0 s, v - ) ENGINE=MyISAM
复制代码 |