手动执行下面的sql- CREATE TABLE `pre_common_member_archive` (% k2 w( |& g2 t
- `uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,- s, L9 C/ [" S5 h' s' D0 D
- `email` char(40) NOT NULL DEFAULT '',
* g3 q7 y; n: F3 g( a - `username` char(15) NOT NULL DEFAULT '',( d: F+ _; ]4 `! X/ ~: ^
- `password` char(32) NOT NULL DEFAULT '',
9 s+ y! R8 T, K: k - `status` tinyint(1) NOT NULL DEFAULT '0',7 c) t& B7 F0 }) D, S
- `emailstatus` tinyint(1) NOT NULL DEFAULT '0',% j Z& p# q8 k/ K/ {" H
- `avatarstatus` tinyint(1) NOT NULL DEFAULT '0',$ [' c* |& a( \: u; C' B
- `videophotostatus` tinyint(1) NOT NULL DEFAULT '0', M" H* `- q) B6 Z8 c- `
- `adminid` tinyint(1) NOT NULL DEFAULT '0',
4 E \- {' u/ [ - `groupid` smallint(6) unsigned NOT NULL DEFAULT '0'," ]8 a# Z6 C5 X3 M* b
- `groupexpiry` int(10) unsigned NOT NULL DEFAULT '0',& ]8 e: x# O0 _+ x, t; A
- `extgroupids` char(20) NOT NULL DEFAULT ''," U4 J) n- O' a" U. S! r
- `regdate` int(10) unsigned NOT NULL DEFAULT '0',
: Y3 y0 `" x u! V6 H+ W1 N5 p - `credits` int(10) NOT NULL DEFAULT '0',
$ x, b6 g( v/ O) F8 P l - `notifysound` tinyint(1) NOT NULL DEFAULT '0',$ g+ g a6 G1 E/ L- t* ? X
- `timeoffset` char(4) NOT NULL DEFAULT '',6 r+ v: t. L% H u( O
- `newpm` smallint(6) unsigned NOT NULL DEFAULT '0',3 Z) C" N8 l2 k' @
- `newprompt` smallint(6) unsigned NOT NULL DEFAULT '0',
; E4 E3 K- ?. f - `accessmasks` tinyint(1) NOT NULL DEFAULT '0',7 d- u. ]5 O: d' s
- `allowadmincp` tinyint(1) NOT NULL DEFAULT '0',
2 @: o9 j, p7 J - `onlyacceptfriendpm` tinyint(1) NOT NULL DEFAULT '0',
2 R( H2 `6 g7 V - `conisbind` tinyint(1) unsigned NOT NULL DEFAULT '0',
6 h2 `4 s% ?: S4 A) o, g+ L - `wxaccount` char(40) NOT NULL DEFAULT '',
3 o- \/ O2 X3 y- a! O - `zfbaccount` char(40) NOT NULL DEFAULT '',; C6 q! D. a8 F2 o( S$ G
- PRIMARY KEY (`uid`),, n( f. G# n/ _* g& @& X+ J2 g2 r
- UNIQUE KEY `username` (`username`),
- t8 m- O. e6 l, z - KEY `email` (`email`),( B1 L4 d& H& j8 m% Z: _
- KEY `groupid` (`groupid`),( |# H+ _! l2 E4 `* Z' c. M# ~
- KEY `conisbind` (`conisbind`)+ d) ^" d$ B' N3 B5 u
- ) ENGINE=MyISAM
复制代码 |