在phpmyadmin执行SQL,错误的行绕过,直到全部都执行。
ALTER TABLE `aws_question` ADD `popular_value` INT( 11 ) NULL DEFAULT '0';
ALTER TABLE `aws_question` ADD `popular_value_update` INT( 10 ) NULL DEFAULT '0';
ALTER TABLE `aws_question` ADD `lock` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '是否锁定';
ALTER TABLE `aws_integral_log` ADD `item_id` INT( 11 ) NULL DEFAULT '0';
INSERT INTO `aws_users_group` (
`group_id` ,
`type` ,
`custom` ,
`group_name` ,
`reputation_lower` ,
`reputation_higer` ,
`reputation_factor` ,
`permission`
)
VALUES (
'99', '0', '0', '游客', '0', '0', '0', 'a:6:{s:13:"visit_explore";s:1:"1";s:12:"search_avail";s:1:"1";s:14:"visit_question";s:1:"1";s:11:"visit_topic";s:1:"1";s:13:"visit_feature";s:1:"1";s:12:"visit_people";s:1:"1";}'
);
DELETE FROM `aws_system_setting` WHERE `varname` = 'logout_search_avail';
DELETE FROM `aws_system_setting` WHERE `varname` = 'guest_explorer';
ALTER TABLE `aws_question` ADD `anonymous` TINYINT( 1 ) NULL DEFAULT '0';
ALTER TABLE `aws_answer` ADD `anonymous` TINYINT( 1 ) NULL DEFAULT '0';
ALTER TABLE `aws_question` CHANGE `answer_count` `answer_count` INT( 11 ) NULL DEFAULT '0' COMMENT '回答计数';
UPDATE `aws_question` SET `answer_count` = 0 WHERE `answer_count` IS NULL;
ALTER TABLE `aws_user_action_history` ADD `anonymous` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '是否匿名';
DROP TABLE `aws_user_associate_index`;
ALTER TABLE `aws_question` DROP `modify_time`;
ALTER TABLE `aws_question` DROP `modify_uid`;
ALTER TABLE `aws_question` DROP `last_action`;
ALTER TABLE `aws_question` DROP `last_uid`;
ALTER TABLE `aws_answer` DROP `modify_time`;
阅读全文
收起全文