kxmall-main/doc/sql/increment/20240804kxmall3.sql

INSERT INTO `sys_menu` VALUES (1790733695359579927, '活动管理', 1695650389696393218, 2, 'storeActivity', 'activity/storeActivity/index', NULL, 1, 0, 'C', '0', '0', 'event:storeEvent:list', '#', 'admin', '2024-05-15 21:21:09', 'admin', '2024-05-15 21:39:30', '活动菜单');
INSERT INTO `sys_menu` VALUES (1790733695359579928, '活动查询', 1790733695359579927, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivity:query', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359579930, '商品活动新增', 1790733695359579927, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivity:add', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359579931, '商品活动修改', 1790733695359579927, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivity:edit', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359579932, '商品活动删除', 1790733695359579927, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivity:remove', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695359579933, '商品活动导出', 1790733695359579927, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivity:export', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');

INSERT INTO `sys_menu` VALUES (1790733695369579927, '活动商品管理', 1695650389696393218, 2, 'storeActivityProduct', 'activity/storeActivityProduct/index', NULL, 1, 0, 'C', '0', '0', 'event:storeEvent:list', '#', 'admin', '2024-05-15 21:21:09', 'admin', '2024-05-15 21:39:30', '活动商品菜单');
INSERT INTO `sys_menu` VALUES (1790733695369579928, '活动查询', 1790733695369579927, 1, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivityProduct:query', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695369579930, '商品活动新增', 1790733695369579927, 2, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivityProduct:add', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695369579931, '商品活动修改', 1790733695369579927, 3, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivityProduct:edit', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695369579932, '商品活动删除', 1790733695369579927, 4, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivityProduct:remove', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');
INSERT INTO `sys_menu` VALUES (1790733695369579933, '商品活动导出', 1790733695369579927, 5, '#', '', NULL, 1, 0, 'F', '0', '0', 'activity:storeActivityProduct:export', '#', 'admin', '2024-05-15 21:21:09', '', NULL, '');



DROP TABLE IF EXISTS `kx_store_activity`;
CREATE TABLE `kx_store_activity` (
     `id` bigint(20)  AUTO_INCREMENT COMMENT '活动id',
     `title` varchar(100)  NOT NULL COMMENT '活动标题',
     `img_url` varchar(2000) NULL DEFAULT '' COMMENT '活动海报',
     `out_url` varchar(2000) NULL COMMENT '海报链接',
     `description` text NULL COMMENT '活动详情',
     `status` tinyint(1) NULL DEFAULT 1 COMMENT '状态(是否开启)',
     `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
     `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
     `create_time` datetime(0)  NULL COMMENT '创建时间',
     `update_time` datetime(0)  NULL COMMENT '更新时间',
     PRIMARY KEY (`id`) USING BTREE,
     KEY `title` (`title`)
) ENGINE=InnoDB  COMMENT='活动表';

DROP TABLE IF EXISTS `kx_store_activity_product`;
CREATE TABLE `kx_store_activity_product` (
     `id` bigint(20) NOT NULL AUTO_INCREMENT,
     `product_id` bigint(20) NOT NULL COMMENT '商品id',
     `activity_id` bigint(20) NOT NULL DEFAULT 1 COMMENT '活动id',
     `create_by` varchar(255) DEFAULT NULL COMMENT '创建人',
     `update_by` varchar(255) DEFAULT NULL COMMENT '更新人',
     `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
     `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
     PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=1792453957470806594 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='活动商品表';