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

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 ('33', '21', '2020-12-22 11:27:12', '专题管理', '1', '0', 'subject', 'tree', '0');
INSERT INTO `ums_menu` (`id`, `parent_id`, `create_time`, `title`, `level`, `sort`, `name`, `icon`, `hidden`) VALUES ('35', '12', '2020-12-25 14:24:50', '购买滚动', '1', '0', 'rollbuy', 'tree', '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`;

INSERT INTO `cms_subject` (`id`, `category_id`, `title`, `pic`, `product_count`, `recommend_status`, `create_time`, `collect_count`, `read_count`, `comment_count`, `album_pics`, `description`, `show_status`, `content`, `forward_count`, `category_name`, `sort`, `del_flag`) VALUES ('9', '1', '热销商品', 'http://fqn.hongweisoft.com/0/1/20201224152107000000002.png', '0', NULL, '2020-12-23 14:44:50', '0', '0', '0', NULL, '林产品专题', NULL, NULL, NULL, '林产品专题', NULL, '0');
INSERT INTO `cms_subject` (`id`, `category_id`, `title`, `pic`, `product_count`, `recommend_status`, `create_time`, `collect_count`, `read_count`, `comment_count`, `album_pics`, `description`, `show_status`, `content`, `forward_count`, `category_name`, `sort`, `del_flag`) VALUES ('10', '1', '折扣商品', 'http://fqn.hongweisoft.com/0/1/20201224152218000000003.png', '0', NULL, '2020-12-23 14:45:30', '0', '0', '0', NULL, '林产品', NULL, NULL, NULL, '林产品专题', NULL, '0');
INSERT INTO `cms_subject` (`id`, `category_id`, `title`, `pic`, `product_count`, `recommend_status`, `create_time`, `collect_count`, `read_count`, `comment_count`, `album_pics`, `description`, `show_status`, `content`, `forward_count`, `category_name`, `sort`, `del_flag`) VALUES ('11', '1', '扶贫产品', 'http://fqn.hongweisoft.com/0/1/20201224152316000000004.png', '0', NULL, '2020-12-23 14:46:24', '0', '0', '0', NULL, '林产品', NULL, NULL, NULL, '林产品专题', NULL, '0');
INSERT INTO `cms_subject` (`id`, `category_id`, `title`, `pic`, `product_count`, `recommend_status`, `create_time`, `collect_count`, `read_count`, `comment_count`, `album_pics`, `description`, `show_status`, `content`, `forward_count`, `category_name`, `sort`, `del_flag`) VALUES ('12', '1', '养生专区', 'http://fqn.hongweisoft.com/0/1/20201224152403000000005.png', '0', NULL, '2020-12-23 14:46:52', '0', '0', '0', NULL, '专题描述吗', NULL, NULL, NULL, '林产品专题', NULL, '0');


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


-- ----------------------------
-- Table structure for ums_roll_buy
-- ----------------------------
DROP TABLE IF EXISTS `ums_roll_buy`;
CREATE TABLE `ums_roll_buy` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '序列号',
  `member_id` bigint(20) DEFAULT NULL COMMENT '成员id',
  `member_name` varchar(300) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '成员名称',
  `money` decimal(15,2) DEFAULT NULL COMMENT '花费',
  `product_id` bigint(20) DEFAULT NULL COMMENT '产品id',
  `product_name` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '产品名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `comp_name` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '供应商名称',
  `comp_id` bigint(20) DEFAULT NULL COMMENT '供应商id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;