用户存档表丢了,可以参考 install.sql 的标准表进行补充。
如 common_member_archive 的补充语句如下。
- CREATE TABLE pre_common_member_archive (
- uid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
- email char(40) NOT NULL DEFAULT '',
- username char(15) NOT NULL DEFAULT '',
- `password` char(32) NOT NULL DEFAULT '',
- `status` tinyint(1) NOT NULL DEFAULT '0',
- emailstatus tinyint(1) NOT NULL DEFAULT '0',
- avatarstatus tinyint(1) NOT NULL DEFAULT '0',
- videophotostatus tinyint(1) NOT NULL DEFAULT '0',
- adminid tinyint(1) NOT NULL DEFAULT '0',
- groupid smallint(6) unsigned NOT NULL DEFAULT '0',
- groupexpiry int(10) unsigned NOT NULL DEFAULT '0',
- extgroupids char(20) NOT NULL DEFAULT '',
- regdate int(10) unsigned NOT NULL DEFAULT '0',
- credits int(10) NOT NULL DEFAULT '0',
- notifysound tinyint(1) NOT NULL DEFAULT '0',
- timeoffset char(4) NOT NULL DEFAULT '',
- newpm smallint(6) unsigned NOT NULL DEFAULT '0',
- newprompt smallint(6) unsigned NOT NULL DEFAULT '0',
- accessmasks tinyint(1) NOT NULL DEFAULT '0',
- allowadmincp tinyint(1) NOT NULL DEFAULT '0',
- onlyacceptfriendpm tinyint(1) NOT NULL DEFAULT '0',
- conisbind tinyint(1) unsigned NOT NULL DEFAULT '0',
- freeze tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (uid),
- UNIQUE KEY username (username),
- KEY email (email),
- KEY groupid (groupid),
- KEY conisbind (conisbind),
- KEY regdate (regdate)
- ) TYPE=MyISAM;
复制代码 |