blade-common/src/main/java/org/springblade/common/constant/LauncherConstant.java
@@ -42,22 +42,22 @@ /** * nacos å¯ç */ String NACOS_PASSWORD = "nacos"; String NACOS_PASSWORD = "QW_nacos_!@#$"; /** * nacos dev å°å */ String NACOS_DEV_ADDR = "127.0.0.1:8848"; String NACOS_DEV_ADDR = "127.0.0.1:18848"; /** * nacos prod å°å */ String NACOS_PROD_ADDR = "172.30.0.48:8848"; String NACOS_PROD_ADDR = "127.0.0.1:8848"; /** * nacos test å°å */ String NACOS_TEST_ADDR = "172.30.0.48:8848"; String NACOS_TEST_ADDR = "127.0.0.1:8848"; /** * sentinel dev å°å blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/MachineGroupService.java
ÎļþÒÑɾ³ý blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/MachineService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,59 @@ package org.springblade.mdm.basesetting.machine; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Constants; import org.springblade.core.mp.base.BaseServiceImpl; import org.springblade.core.mp.base.BizServiceImpl; import org.springblade.core.mp.support.Condition; import org.springblade.core.tool.utils.BeanUtil; import org.springblade.mdm.basesetting.machine.entity.Machine; import org.springblade.mdm.basesetting.machine.mapper.MachineMapper; import org.springblade.mdm.basesetting.machine.vo.MachineQueryVO; import org.springblade.mdm.basesetting.machine.vo.MachineSaveVO; import org.springblade.mdm.basesetting.machine.vo.MachineVO; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; @Service public class MachineService extends BizServiceImpl<MachineMapper, Machine> { @Transactional public void saveMachine(MachineSaveVO vo){ //TODO Machine machine = new Machine(); BeanUtil.copyProperties(vo, machine); this.save(machine); } public boolean updateMachine(MachineSaveVO vo) { Machine machine = this.getById(vo.getId()); machine.setMachineSpec(vo.getMachineSpec()); return this.updateById(machine); } @Transactional public void removeMachines(List<Long> ids) { for(Long id : ids){ this.removeById(id); } } public IPage<MachineVO> pageQuery(MachineQueryVO query) { LambdaQueryWrapper<Machine> queryWrapper = new LambdaQueryWrapper<>(); queryWrapper.eq(query.getMachineGroupId()!=null, Machine::getMachineGroupId, query.getMachineGroupId()); IPage<MachineVO> page = this.getBaseMapper().pageQuery(Condition.getPage(query),queryWrapper); return page; } } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/controller/MachineController.javacopy from blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/controller/MachineGroupController.java copy to blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/controller/MachineController.java
Îļþ´Ó blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/controller/MachineGroupController.java ¸´ÖÆ @@ -10,30 +10,31 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.mdm.basesetting.machine.MachineGroupService; import org.springblade.mdm.basesetting.machine.entity.MachineGroup; import org.springblade.mdm.basesetting.machine.MachineService; import org.springblade.mdm.basesetting.machine.vo.MachineQueryVO; import org.springblade.mdm.basesetting.machine.vo.MachineSaveVO; import org.springblade.mdm.basesetting.machine.vo.MachineVO; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.Map; @Slf4j @RestController @RequestMapping("/machinegroup") @Tag(name = "æºåºç»", description = "æºåºç»") public class MachineGroupController { @RequestMapping("/machine") @Tag(name = "æºåº", description = "æºåº") public class MachineController { @Autowired private MachineGroupService grpService; private MachineService service; /** * æ°å¢ */ @PostMapping("/save") @Operation(summary = "æ°å¢", description = "æºåºç»ä¿¡æ¯") public R<Boolean> save(@RequestBody MachineGroup grp) { public R<Boolean> save(@RequestBody MachineSaveVO vo) { return R.<Boolean>status(grpService.save(grp)); service.saveMachine(vo); return R.<Boolean>status(true); } /** @@ -41,9 +42,9 @@ */ @Operation(summary = "ä¿®æ¹", description = "æºåºç»ä¿¡æ¯") @PostMapping("/update") public R<Boolean> update(@RequestBody MachineGroup grp) { public R<Boolean> update(@RequestBody MachineSaveVO vo) { return R.<Boolean>status(grpService.updateById(grp)); return R.<Boolean>status(service.updateMachine(vo)); } /** @@ -53,7 +54,7 @@ @PostMapping("/remove") public R<Void> remove(@RequestParam String ids) { try { grpService.removeGroups(Func.toLongList(ids)); service.removeMachines(Func.toLongList(ids)); } catch (Exception e) { log.error("å é¤å¼å¸¸",e); return R.fail(e.getMessage()); @@ -66,8 +67,8 @@ */ @Operation(summary = "å页æ¥è¯¢", description = "åç§°æç¼ç ") @GetMapping("/page") public R<IPage<MachineGroup>> page(String keyword, Query query) { public R<IPage<MachineVO>> page(MachineQueryVO query) { /* LambdaQueryWrapper<MachineGroup> wrapper = new LambdaQueryWrapper<>(); //wrapper.like(StringUtils.isNotBlank(keyword),MachineGroup::getName, "%"+keyword+"%"); wrapper.and(StringUtils.isNotBlank(keyword),(w1)->{ @@ -75,7 +76,9 @@ .or().like(MachineGroup::getCode,"%"+keyword+"%"); }); IPage<MachineGroup> pages = grpService.page(Condition.getPage(query), wrapper); */ IPage<MachineVO> pages = service.pageQuery(query); return R.data(pages); } } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/entity/Machine.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,56 @@ package org.springblade.mdm.basesetting.machine.entity; import com.baomidou.mybatisplus.annotation.TableName; import lombok.Getter; import lombok.Setter; import org.springblade.core.mp.base.BaseEntity; import org.springblade.core.mp.base.BizEntity; @Setter @Getter @TableName("mdm_machine") public class Machine extends BizEntity { private String name; private String code; /** * æå±æºåºç»ID */ private Long machineGroupId; /** * æºå¨è§æ ¼:01车åº/02é£åº,å¨ä¸å¡åå ¸é ç½®ï¼key=machine_specï¼ */ private String machineSpec; /** * æä½åï¼ææ¬å½å ¥ */ private String operator; /** * æå±åä½/ç»ç» */ private Long ownerDept; /** * 'ç产å' */ private String manufacturer; /** * æ£æ¥ç¨åºåä¼ ç轮询æ¶é´ï¼å°æ¶ï¼ */ private Integer pollingHours; /** * æ§å¶ç³»ç»ï¼å¦åé£ç§ï¼ï¼å¨ä¸å¡åå ¸é ç½®(key=machine_controll_system)ï¼ä½¿ç¨è±æåæ¯ */ private String controlSystem; /** * ç¨åºä¸åç®å½ */ private String progSendDir; /** * ç¨åºåä¼ ç®å½', */ private String progReceiveDir; /** * 夿³¨ */ private String remark; } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineGroupMapper.java
ÎļþÒÑɾ³ý blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,16 @@ package org.springblade.mdm.basesetting.machine.mapper; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.core.toolkit.Constants; import org.apache.ibatis.annotations.Param; import org.springblade.core.mp.mapper.BladeMapper; import org.springblade.mdm.basesetting.machine.entity.Machine; import org.springblade.mdm.basesetting.machine.vo.MachineVO; public interface MachineMapper extends BladeMapper<Machine> { IPage<MachineVO> pageQuery(IPage<Machine> page, @Param(Constants.WRAPPER)LambdaQueryWrapper<Machine> queryWrapper); //pageMachine } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineMapper.xmlcopy from blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineGroupMapper.xml copy to blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineMapper.xml
Îļþ´Ó blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineGroupMapper.xml ¸´ÖÆ @@ -1,9 +1,9 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.springblade.mdm.basesetting.machine.mapper.MachineGroupMapper"> <mapper namespace="org.springblade.mdm.basesetting.machine.mapper.MachineMapper"> <!-- éç¨æ¥è¯¢æ å°ç»æ --> <resultMap id="BaseResultMap" type="org.springblade.mdm.basesetting.machine.entity.MachineGroup"> <resultMap id="BaseResultMap" type="org.springblade.mdm.basesetting.machine.entity.Machine"> <id column="id" property="id"/> <result column="code" property="code"/> <result column="name" property="name"/> @@ -13,9 +13,14 @@ <result column="updateTime" property="update_time"/> <result column="is_deleted" property="isDeleted"/> </resultMap> <select id="pageQuery" resultType="org.springblade.mdm.basesetting.machine.vo.MachineVO"> select m.id,m.name,m.code,g.name group_name,m.machine_spec,m.manufacturer,m.operator from mdm_machine m join mdm_machine_group g on m.machine_group_id=g.id ${ew.customSqlSegment} </select> <!-- <select id="parentTree" resultMap="treeNodeResultMap">--> <!-- <select id="parentTree" resultMap="treeNodeResultMap">--> <!-- select id, parent_id, dict_value as title, id as "value", id as "key" from blade_dict where is_deleted = 0 and parent_id = 0--> <!-- </select>--> blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/vo/MachineQueryVO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,13 @@ package org.springblade.mdm.basesetting.machine.vo; import lombok.Getter; import lombok.Setter; import org.springblade.core.mp.support.Query; @Setter @Getter public class MachineQueryVO extends Query { private String keyword; private Long machineGroupId; } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/vo/MachineSaveVO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,50 @@ package org.springblade.mdm.basesetting.machine.vo; import lombok.Getter; import lombok.Setter; import org.springblade.mdm.commons.vo.BaseVO; @Setter @Getter public class MachineSaveVO extends BaseVO { private String code; private String name; /** * æå±æºåºç»ID */ private Long machineGroupId; /** * æºå¨è§æ ¼:01车åº/02é£åº,å¨ä¸å¡åå ¸é ç½®ï¼key=machine_specï¼ */ private String machineSpec; /** * æä½åï¼ææ¬å½å ¥ */ private String operator; /** * æå±åä½/ç»ç» */ private Long ownerDept; /** * 'ç产å' */ private String manufacturer; /** * æ£æ¥ç¨åºåä¼ ç轮询æ¶é´ï¼å°æ¶ï¼ */ private Integer pollingHours; /** * æ§å¶ç³»ç»ï¼å¦åé£ç§ï¼ï¼å¨ä¸å¡åå ¸é ç½®(key=machine_controll_system)ï¼ä½¿ç¨è±æåæ¯ */ private String controlSystem; /** * ç¨åºä¸åç®å½ */ private String progSendDir; /** * ç¨åºåä¼ ç®å½', */ private String progReceiveDir; private String remark; } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/vo/MachineVO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,50 @@ package org.springblade.mdm.basesetting.machine.vo; import lombok.Getter; import lombok.Setter; import org.springblade.mdm.commons.vo.BaseVO; @Setter @Getter public class MachineVO extends BaseVO { private String code; private String name; /** * æå±æºåºç»ID */ private Long machineGroupId; /** * æºå¨è§æ ¼:01车åº/02é£åº,å¨ä¸å¡åå ¸é ç½®ï¼key=machine_specï¼ */ private String machineSpec; /** * æä½åï¼ææ¬å½å ¥ */ private String operator; /** * æå±åä½/ç»ç» */ private Long ownerDept; /** * 'ç产å' */ private String manufacturer; /** * æ£æ¥ç¨åºåä¼ ç轮询æ¶é´ï¼å°æ¶ï¼ */ private Integer pollingHours; /** * æ§å¶ç³»ç»ï¼å¦åé£ç§ï¼ï¼å¨ä¸å¡åå ¸é ç½®(key=machine_controll_system)ï¼ä½¿ç¨è±æåæ¯ */ private String controlSystem; /** * ç¨åºä¸åç®å½ */ private String progSendDir; /** * ç¨åºåä¼ ç®å½', */ private String progReceiveDir; private String remark; } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machinegroup/MachineGroupService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,23 @@ package org.springblade.mdm.basesetting.machinegroup; import org.springblade.core.mp.base.BaseServiceImpl; import org.springblade.core.mp.base.BizServiceImpl; import org.springblade.mdm.basesetting.machinegroup.entity.MachineGroup; import org.springblade.mdm.basesetting.machinegroup.mapper.MachineGroupMapper; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.List; @Service public class MachineGroupService extends BizServiceImpl<MachineGroupMapper, MachineGroup> { @Transactional public void removeGroups(List<Long> ids){ //TODO æ£æ¥ä¸é¢æ¯å¦ææºå¨ for(Long id : ids){ this.removeById(id); } } } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machinegroup/controller/MachineGroupController.java
ÎļþÃû´Ó blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/controller/MachineGroupController.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package org.springblade.mdm.basesetting.machine.controller; package org.springblade.mdm.basesetting.machinegroup.controller; import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; @@ -10,12 +10,11 @@ import org.springblade.core.mp.support.Query; import org.springblade.core.tool.api.R; import org.springblade.core.tool.utils.Func; import org.springblade.mdm.basesetting.machine.MachineGroupService; import org.springblade.mdm.basesetting.machine.entity.MachineGroup; import org.springblade.mdm.basesetting.machine.MachineService; import org.springblade.mdm.basesetting.machinegroup.MachineGroupService; import org.springblade.mdm.basesetting.machinegroup.entity.MachineGroup; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.web.bind.annotation.*; import java.util.Map; @Slf4j @RestController blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machinegroup/entity/MachineGroup.java
ÎļþÃû´Ó blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/entity/MachineGroup.java ÐÞ¸Ä @@ -1,10 +1,11 @@ package org.springblade.mdm.basesetting.machine.entity; package org.springblade.mdm.basesetting.machinegroup.entity; import com.baomidou.mybatisplus.annotation.TableName; import org.springblade.core.mp.base.BaseEntity; import org.springblade.core.mp.base.BizEntity; @TableName("mdm_machine_group") public class MachineGroup extends BaseEntity { public class MachineGroup extends BizEntity { private String name; private String code; blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machinegroup/mapper/MachineGroupMapper.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,7 @@ package org.springblade.mdm.basesetting.machinegroup.mapper; import org.springblade.core.mp.mapper.BladeMapper; import org.springblade.mdm.basesetting.machinegroup.entity.MachineGroup; public interface MachineGroupMapper extends BladeMapper<MachineGroup> { } blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machinegroup/mapper/MachineGroupMapper.xml
ÎļþÃû´Ó blade-service/blade-mdm/src/main/java/org/springblade/mdm/basesetting/machine/mapper/MachineGroupMapper.xml ÐÞ¸Ä @@ -1,9 +1,9 @@ <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> <mapper namespace="org.springblade.mdm.basesetting.machine.mapper.MachineGroupMapper"> <mapper namespace="org.springblade.mdm.basesetting.machinegroup.mapper.MachineGroupMapper"> <!-- éç¨æ¥è¯¢æ å°ç»æ --> <resultMap id="BaseResultMap" type="org.springblade.mdm.basesetting.machine.entity.MachineGroup"> <resultMap id="BaseResultMap" type="org.springblade.mdm.basesetting.machinegroup.entity.MachineGroup"> <id column="id" property="id"/> <result column="code" property="code"/> <result column="name" property="name"/> blade-service/blade-mdm/src/main/java/org/springblade/mdm/commons/vo/BaseVO.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,15 @@ package org.springblade.mdm.commons.vo; import lombok.Getter; import lombok.Setter; import java.util.Date; @Setter @Getter public class BaseVO { private Long id; private Integer status; private Date createTime; } doc/sql/mdm/mdm.all.create.sql
@@ -1,8 +1,8 @@ CREATE TABLE `mdm_machine_group` ( `id` bigint NOT NULL COMMENT '主é®', `tenant_id` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '000000' COMMENT 'ç§æ·ID', `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'æºåºç»åç§°', `code` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'æºåºç»ç¼å·', `name` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'æºåºç»åç§°', `code` varchar(20) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'æºåºç»ç¼å·', `create_user` bigint DEFAULT NULL COMMENT 'å建人', `create_dept` bigint DEFAULT NULL COMMENT 'å建é¨é¨', `create_time` datetime DEFAULT NULL COMMENT 'å建æ¶é´', @@ -11,26 +11,35 @@ `status` int DEFAULT '1' COMMENT 'ç¶æ', `is_deleted` int DEFAULT '0' COMMENT 'æ¯å¦å·²å é¤', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='æºåºç»'; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='æºåºç»'; CREATE TABLE `mdm_machine` ( `id` bigint NOT NULL, `tenant_id` varchar(6) DEFAULT NULL COMMENT 'æå±ç§æ·', `code` varchar(100) NOT NULL COMMENT 'æºåºç¼å·', `name` varchar(100) CHARACTER SET gbk COLLATE gbk_chinese_ci NOT NULL COMMENT 'æºåºåç§°', `avatar` varchar(1000) DEFAULT NULL COMMENT 'å¾çå°å', `machine_group_id` bigint DEFAULT NULL COMMENT 'æå±æºåºç»ID', `status` int DEFAULT NULL COMMENT 'ä¸å¡ç¶æ', `name` varchar(100) NOT NULL COMMENT 'æºåºæè¿°/åå·', `avatar` varchar(400) DEFAULT NULL COMMENT 'å¾çå°å', `machine_group_id` bigint NOT NULL COMMENT 'æå±æºåºç»ID', `machine_spec` varchar(20) DEFAULT NULL COMMENT 'æºå¨è§æ ¼:01车åº/02é£åº,å¨ä¸å¡åå ¸é ç½®ï¼key=machine_specï¼', `operator` varchar(100) COMMENT 'æä½åï¼ææ¬å½å ¥', `owner_dept` bigint DEFAULT NULL COMMENT 'æå±åä½/ç»ç»', `manufacturer` varchar(100) COMMENT 'ç产å', `polling_hours` int(11) COMMENT 'æ£æ¥ç¨åºåä¼ ç轮询æ¶é´ï¼å°æ¶ï¼', `control_system` varchar(20) DEFAULT NULL COMMENT 'æ§å¶ç³»ç»ï¼å¦åé£ç§ï¼ï¼å¨ä¸å¡åå ¸é ç½®(key=machine_controll_system)ï¼ä½¿ç¨è±æåæ¯', `prog_send_dir` varchar(100) COMMENT 'ç¨åºä¸åç®å½', `prog_receive_dir` varchar(100) COMMENT 'ç¨åºåä¼ ç®å½', `remark` varchar(200) COMMENT '夿³¨', `status` int DEFAULT NULL COMMENT 'ä¸å¡ç¶æï¼1ï¼å¯ç¨ï¼0ç¦ç¨', `create_dept` bigint DEFAULT NULL COMMENT 'å建åä½', `is_deleted` int DEFAULT NULL, `create_time` datetime DEFAULT NULL COMMENT 'å建æ¶é´', `create_user` bigint DEFAULT NULL COMMENT 'å建人', `update_time` datetime DEFAULT NULL COMMENT 'æ´æ°æ¶é´', `update_user` bigint DEFAULT NULL COMMENT 'æ´æ°äºº' `update_user` bigint DEFAULT NULL COMMENT 'æ´æ°äºº', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='æºåº'; UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='æºåº'; CREATE TABLE `mdm_nc_program` ( @@ -50,7 +59,7 @@ `update_user` bigint DEFAULT NULL COMMENT 'æ´æ°äºº' PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uniqueCodeIndex` (`code`,`is_deleted`) USING BTREE, ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC COMMENT='æ°æ§ç¨åº'; ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='æ°æ§ç¨åº'; CREATE TABLE `mdm_task_receive` (