执行SQL，错误的行绕过，直到全部执行过一遍。
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('qq_login_enabled', 's:1:"N";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('qq_login_app_id', '');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('qq_login_app_key', '');
ALTER TABLE `aws_users_qq` ADD `type` VARCHAR( 20 ) NULL DEFAULT NULL COMMENT '类别' AFTER `uid`;
UPDATE `aws_users_qq` SET type = 'weibo';
ALTER TABLE `aws_users` DROP `district`;
ALTER TABLE `aws_work_experience` DROP `district`;
ALTER TABLE `aws_question` ADD `last_answer` INT( 11 ) NULL DEFAULT '0';
ALTER TABLE `aws_attach` ADD KEY ( `is_image` );
ALTER TABLE `aws_users` ADD KEY ( `last_active` );
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('logout_search_avail', 's:1:"N";');
UPDATE `aws_notification` SET read_flag = 1 WHERE read_flag > 0;
ALTER TABLE `aws_notification` CHANGE `read_flag` `read_flag` TINYINT( 1 ) NULL DEFAULT '0' COMMENT '阅读状态';
ALTER TABLE `aws_system_setting` CHANGE `varname` `varname` VARCHAR( 255 ) NOT NULL COMMENT '字段名';
UPDATE `aws_system_setting` SET `varname` = 'request_route_custom' WHERE `varname` = 'request_route';
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('request_route', 's:2:"99";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('request_route_sys_1', 's:226:"/home/explore/category-(:num)===/catexgory/(:num)\n/home/explore/===/explore/\n/home/explore/guest===/guest\n/home/users/===/users/\n/account/login/===/login/\n/account/logout/===/logout/\n/account/setting/(:any)/===/setting/(:any)/";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('request_route_sys_2', 's:315:"/question/(:any)===/q_(:any)\n/topic/(:any)===/t_(:any).html\n/people/(:any)===/p_(:any).html\n/home/explore/category-(:num)===/c_(:num).html\n/home/explore/===/explore/\n/home/explore/guest===/guest\n/home/users/===/users/\n/account/login/===/login/\n/account/logout/===/logout/\n/account/setting/(:any)/===/setting/(:any)/";');
CREATE TABLE `aws_feature` (
`id` INT( 11 ) NULL AUTO_INCREMENT ,
`title` VARCHAR( 200 ) NULL DEFAULT NULL COMMENT '专题标题',
`description` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT '专题描述',
`icon` VARCHAR( 255 ) NULL DEFAULT NULL COMMENT '专题图标',
`topic_count` INT( 11 ) NULL DEFAULT '0' COMMENT '话题计数',
`css` TEXT NULL DEFAULT NULL COMMENT '自定义CSS',
PRIMARY KEY ( `id` )
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `aws_feature_topic` (
`id` INT( 11 ) NULL AUTO_INCREMENT ,
`feature_id` INT( 11 ) NULL DEFAULT '0' COMMENT '专题ID',
`topic_id` INT( 11 ) NULL DEFAULT '0' COMMENT '话题ID',
PRIMARY KEY ( `id` ),
KEY `feature_id` (`feature_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_enabled', 's:1:"N";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_register', 's:4:"2000";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_profile', 's:3:"100";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_invite', 's:3:"200";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_best_answer', 's:3:"200";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_answer_fold', 's:3:"-50";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_new_question', 's:3:"-20";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_new_answer', 's:2:"-5";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_thanks', 's:3:"-10";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_system_config_invite_answer', 's:3:"-10";');
ALTER TABLE `aws_users` ADD `integral` INT( 11 ) NULL DEFAULT '0';
CREATE TABLE `aws_integral_log` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(11) DEFAULT '0',
`action` varchar(16) DEFAULT NULL,
`integral` int(11) DEFAULT NULL,
`note` varchar(128) DEFAULT NULL,
`balance` int(11) DEFAULT '0',
`time` int(10) DEFAULT '0',
PRIMARY KEY (`id`),
KEY `uid` (`uid`),
KEY `action` (`action`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `aws_integral_log` (
`uid` ,
`action`,
`integral`,
`note`,
`balance`,
`time`
)
SELECT `uid` , 'REGISTER' , '2000', '初始资本', '2000' , `reg_time` FROM `aws_users`;
UPDATE `aws_users` SET `integral` = 2000;
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 '是否锁定';
DELETE FROM `aws_question_keyword` WHERE `keyword` IN('?', '、', '。', '“', '”', '《', '》', '！', '，', '：', '；', '？', '末', '啊', '阿', '哎', '哎呀', '哎哟', '唉', '俺', '俺们', '按', '按照', '吧', '吧哒', '把', '罢了', '被', '本', '本着', '比', '比方', '比如', '鄙人', '彼', '彼此', '边', '别', '别的', '别说', '并', '并且', '不比', '不成', '不单', '不但', '不独', '不管', '不光', '不过', '不仅', '不拘', '不论', '不怕', '不然', '不如', '不特', '不惟', '不问', '不只', '朝', '朝着', '趁', '趁着', '乘', '冲', '除', '除此之外', '除非', '除了', '此', '此间', '此外', '从', '从而', '打', '待', '但', '但是', '当', '当着', '到', '得', '的', '的话', '等', '等等', '地', '第', '叮咚', '对', '对于', '多', '多少', '而', '而况', '而且', '而是', '而外', '而言', '而已', '尔后', '反过来', '反过来说', '反之', '非但', '非徒', '否则', '嘎', '嘎登', '该', '赶', '个', '各', '各个', '各位', '各种', '各自', '给', '根据', '跟', '故', '故此', '固然', '关于', '管', '归', '果然', '果真', '过', '哈', '哈哈', '呵', '和', '何', '何处', '何况', '何时', '嘿', '哼', '哼唷', '呼哧', '乎', '哗', '还是', '还有', '换句话说', '换言之', '或', '或是', '或者', '极了', '及', '及其', '及至', '即', '即便', '即或', '即令', '即若', '即使', '几', '几时', '己', '既', '既然', '既是', '继而', '加之', '假如', '假若', '假使', '鉴于', '将', '较', '较之', '叫', '接着', '结果', '借', '紧接着', '进而', '尽', '尽管', '经', '经过', '就', '就是', '就是说', '据', '具体地说', '具体说来', '开始', '开外', '靠', '咳', '可', '可见', '可是', '可以', '况且', '啦', '来', '来着', '离', '例如', '哩', '连', '连同', '两者', '了', '临', '另', '另外', '另一方面', '论', '嘛', '吗', '慢说', '漫说', '冒', '么', '每', '每当', '们', '莫若', '某', '某个', '某些', '拿', '哪', '哪边', '哪儿', '哪个', '哪里', '哪年', '哪怕', '哪天', '哪些', '哪样', '那', '那边', '那儿', '那个', '那会儿', '那里', '那么', '那么些', '那么样', '那时', '那些', '那样', '乃', '乃至', '呢', '能', '你', '你们', '您', '宁', '宁可', '宁肯', '宁愿', '哦', '呕', '啪达', '旁人', '呸', '凭', '凭借', '其', '其次', '其二', '其他', '其它', '其一', '其余', '其中', '起', '起见', '起见', '岂但', '恰恰相反', '前后', '前者', '且', '然而', '然后', '然则', '让', '人家', '任', '任何', '任凭', '如', '如此', '如果', '如何', '如其', '如若', '如上所述', '若', '若非', '若是', '啥', '上下', '尚且', '设若', '设使', '甚而', '甚么', '甚至', '省得', '时候', '什么', '什么样', '使得', '是', '是的', '首先', '谁', '谁知', '顺', '顺着', '似的', '虽', '虽然', '虽说', '虽则', '随', '随着', '所', '所以', '他', '他们', '他人', '它', '它们', '她', '她们', '倘', '倘或', '倘然', '倘若', '倘使', '腾', '替', '通过', '同', '同时', '哇', '万一', '往', '望', '为', '为何', '为了', '为什么', '为着', '喂', '嗡嗡', '我', '我们', '呜', '呜呼', '乌乎', '无论', '无宁', '毋宁', '嘻', '吓', '相对而言', '像', '向', '向着', '嘘', '呀', '焉', '沿', '沿着', '要', '要不', '要不然', '要不是', '要么', '要是', '也', '也罢', '也好', '一', '一般', '一旦', '一方面', '一来', '一切', '一样', '一则', '依', '依照', '矣', '以', '以便', '以及', '以免', '以至', '以至于', '以致', '抑或', '因', '因此', '因而', '因为', '哟', '用', '由', '由此可见', '由于', '有', '有的', '有关', '有些', '又', '于', '于是', '于是乎', '与', '与此同时', '与否', '与其', '越是', '云云', '哉', '再说', '再者', '在', '在下', '咱', '咱们', '则', '怎', '怎么', '怎么办', '怎么样', '怎样', '咋', '照', '照着', '者', '这', '这边', '这儿', '这个', '这会儿', '这就是说', '这里', '这么', '这么点儿', '这么些', '这么样', '这时', '这些', '这样', '正如', '吱', '之', '之类', '之所以', '之一', '只是', '只限', '只要', '只有', '至', '至于', '诸位', '着', '着呢', '自', '自从', '自个儿', '自各儿', '自己', '自家', '自身', '综上所述', '总的来看', '总的来说', '总的说来', '总而言之', '总之', '纵', '纵令', '纵然', '纵使', '遵照', '作为', '兮', '呃', '呗', '咚', '咦', '喏', '啐', '喔唷', '嗬', '嗯', '嗳');
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`;
ALTER TABLE `aws_users` DROP `user_type`;
ALTER TABLE `aws_users` DROP `user_status`;
ALTER TABLE `aws_topic` DROP `add_uid`;
ALTER TABLE `aws_users` DROP `edit_count`;
ALTER TABLE `aws_users` DROP `topic_count`;
ALTER TABLE `aws_users` DROP `ext_group_ids`;
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('username_rule', 's:1:"1";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('username_length_min', 's:1:"2";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('username_length_max', 's:2:"14";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('category_enable', 's:1:"Y";');
CREATE TABLE `aws_nav_menu` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`title` varchar(128) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`type` varchar(16) DEFAULT NULL,
`type_id` int(11) DEFAULT '0',
`link` varchar(255) DEFAULT NULL COMMENT '链接',
`icon` varchar(255) DEFAULT NULL COMMENT '图标',
`sort` smallint(6) DEFAULT '0' COMMENT '排序',
PRIMARY KEY (`id`),
KEY `parent_id` (`link`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
ALTER TABLE `aws_question` CHANGE `popular_value` `popular_value` DOUBLE NULL DEFAULT '0';
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('welcome_recommend_users', 's:0:"";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('integral_unit', 's:6:"金币";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('nav_menu_show_child', 's:1:"1";');
INSERT INTO `aws_system_setting` (`varname`, `value`) VALUES ('anonymous_enable', 's:1:"Y";');
INSERT INTO `aws_nav_menu` (
`title` ,
`description` ,
`type`,
`type_id`
)
SELECT `title` , `description` , (SELECT 'category') AS `type`, `id` FROM `aws_category`;
阅读全文
收起全文
