重建表吧- DROP TABLE IF EXISTS pre_forum_medal;
- CREATE TABLE pre_forum_medal (
- medalid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(50) NOT NULL DEFAULT '',
- available tinyint(1) NOT NULL DEFAULT '0',
- image varchar(255) NOT NULL DEFAULT '',
- `type` tinyint(1) NOT NULL DEFAULT '0',
- displayorder tinyint(3) NOT NULL DEFAULT '0',
- description varchar(255) NOT NULL,
- expiration smallint(6) unsigned NOT NULL DEFAULT '0',
- permission mediumtext NOT NULL,
- PRIMARY KEY (medalid),
- KEY displayorder (displayorder),
- KEY available (available,displayorder)
- ) TYPE=MyISAM;
复制代码 |