代码升级方面就不细说了,git同步最新代码,然后mvn clean install,启动本机的starter试试,不行的话再来一次mvn clean install,可以了就从tomcat下面把war包复制到你的服务器上,然后该备份备份,该替换替换。下面记录一下这次升级修改的数据库相关字段。改动很少,说明海哥从一开始就把这些都考虑清楚了,怪不得很多人说数据库不用改。

ALTER TABLE `article`   
  CHANGE `thumbnail` `thumbnail` VARCHAR(512) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '缩略图',
  CHANGE `order_number` `order_number` INT(11) DEFAULT 0 NULL COMMENT '排序编号', 
  ADD  INDEX `order_number` (`order_number`);

ALTER TABLE `article_category`   
  CHANGE `user_id` `user_id` INT(11) UNSIGNED NULL COMMENT '分类创建的用户ID';
  
ALTER TABLE `article_comment`   
  CHANGE `order_number` `order_number` INT(11) DEFAULT 0 NULL COMMENT '排序编号,常用语置顶等';

ALTER TABLE `attachment`   
  CHANGE `order_number` `order_number` INT(11) DEFAULT 0 NULL COMMENT '排序字段';

ALTER TABLE `single_page`   
  CHANGE `meta_keywords` `meta_keywords` VARCHAR(512) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'SEO关键字',
  CHANGE `meta_description` `meta_description` VARCHAR(512) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT 'SEO描述信息';

ALTER TABLE `user`   
  CHANGE `username` `username` VARCHAR(128) CHARSET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '登录名',
  CHANGE `logged` `logged` DATETIME NULL COMMENT '最后的登录时间';

ALTER TABLE `wechat_menu`   
  CHANGE `order_number` `order_number` INT(11) DEFAULT 0 NULL COMMENT '排序字段';

 

 

最后修改于 2019-05-29 14:32:35
如果觉得我的文章对你有用,请随意赞赏
扫一扫支付
上一篇