执行下面的重建语句,操作前备份好数据
- DROP TABLE IF EXISTS uc_pm_members;
- CREATE TABLE uc_pm_members (
- plid mediumint(8) unsigned NOT NULL default '0',
- uid mediumint(8) unsigned NOT NULL default '0',
- isnew tinyint(1) unsigned NOT NULL default '0',
- pmnum int(10) unsigned NOT NULL default '0',
- lastupdate int(10) unsigned NOT NULL default '0',
- lastdateline int(10) unsigned NOT NULL default '0',
- PRIMARY KEY (plid,uid),
- KEY isnew (isnew),
- KEY lastdateline (uid,lastdateline),
- KEY lastupdate (uid,lastupdate)
- ) TYPE=MyISAM;
复制代码 注意:修改表前缀为你的实际表前缀 |