forest-mall-cloud/sql/表结构变化语句/qbsql.sql

CREATE TABLE `ums_menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) DEFAULT NULL COMMENT '父级ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `title` varchar(100) DEFAULT NULL COMMENT '菜单名称',
  `level` int(4) DEFAULT NULL COMMENT '菜单级数',
  `sort` int(4) DEFAULT NULL COMMENT '菜单排序',
  `name` varchar(100) DEFAULT NULL COMMENT '前端名称',
  `icon` varchar(200) DEFAULT NULL COMMENT '前端图标',
  `hidden` int(1) DEFAULT NULL COMMENT '前端隐藏 0 不隐藏 1 隐藏',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='后台菜单表';


INSERT INTO `ums_menu`(`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (16, 12, '2020-02-07 16:22:38', '品牌推荐', 1, 0, 'homeBrand', 'product-brand', 0);
INSERT INTO `ums_menu`(`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (17, 12, '2020-02-07 16:23:14', '新品推荐', 1, 0, 'homeNew', 'sms-new', 0);
INSERT INTO `ums_menu`(`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (18, 12, '2020-02-07 16:26:38', '优选推荐', 1, 0, 'homeHot', 'sms-hot', 0);
INSERT INTO `ums_menu`(`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (19, 12, '2020-02-07 16:28:16', '专题推荐', 1, 0, 'homeSubject', 'sms-subject', 0);
INSERT INTO `ums_menu`(`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES (20, 12, '2020-02-07 16:28:42', '广告列表', 1, 0, 'homeAdvertise', 'sms-ad', 0);



ALTER TABLE `sms_home_advertise`
ADD COLUMN `jump_time` bigint(20) NULL COMMENT '推广时间以毫秒为单位' AFTER `sort`;

ALTER TABLE `cms_subject`
ADD COLUMN `sort` bigint(20) NULL COMMENT '专题排序' AFTER `category_name`;


ALTER TABLE `cms_subject`
ADD COLUMN `del_flag` int(2) NULL COMMENT '删除标志：0-未删除，1-删除' AFTER `sort`;


ALTER TABLE `cms_subject_category`
ADD COLUMN `del_flag` int(2) NULL COMMENT '删除标志：0-未删除，1-删除' AFTER `sort`;