楼主是不是从0.4版本升级到0.6版本,升级到0.5部分SQL没有执行,再执行一下以下的SQL,错误的行则跳过。
ALTER TABLE `aws_invitation` DROP `object_type`;
ALTER TABLE `aws_invitation` DROP `object_id`;
DROP TABLE `aws_users_apply`;
DROP TABLE `aws_admin_menu`;
ALTER TABLE `aws_system_setting` DROP `desc`,DROP `detail`,DROP `groupid`,DROP `sort`,DROP `type`,DROP `status`;
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES
('db_version', ''),
('statistic_code', 's:0:"";'),
('upload_enable', 's:1:"Y";'),
('answer_length_lower', 's:1:"0";'),
('quick_publish', 's:1:"Y";'),
('invite_reg_only', 's:1:"N";'),
('question_title_limit', 's:3:"100";');
CREATE TABLE `aws_question_comments` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`question_id` int(11) DEFAULT '0',
`uid` int(11) DEFAULT '0',
`message` varchar(255) DEFAULT NULL,
`time` int(10) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `question_id` (`question_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `aws_users` ADD `level` TINYINT( 3 ) NULL DEFAULT '0' COMMENT '用户声望级别' AFTER `admin_id`;
CREATE TABLE IF NOT EXISTS `aws_users_group` (
`group_id` int(11) NOT NULL AUTO_INCREMENT,
`type` tinyint(3) DEFAULT '0',
`group_name` varchar(50) NOT NULL,
`reputation_lower` int(11) DEFAULT '0',
`reputation_higer` int(11) DEFAULT '0',
`stars` tinyint(3) DEFAULT '0',
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `aws_users_group` (`group_id`, `type`, `group_name`, `reputation_lower`, `reputation_higer`, `stars`) VALUES
(1, 0, '初级会员', 0, 10, 0),
(2, 0, 'VIP_1', 10, 50, 1),
(3, 0, 'VIP_2', 50, 200, 2),
(4, 0, 'VIP_3', 200, 500, 3),
(5, 0, 'VIP_4', 500, 1000, 4),
(6, 0, 'VIP_5', 1000, 99999, 5);
阅读全文
收起全文