package com.wanda.desk.dao.mmapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;
/**
* @Classname KesuIdsMapper
* @Description TODO
* @Date 2021/6/16 19:05
* @Created by songlk
*/
@Mapper
public interface KesuIdsMapper {
@Update({"create table ${tableName}( " +
"`id` int(11) NOT NULL AUTO_INCREMENT," +
" `keId` int(11) NOT NULL COMMENT '客诉'," +
"`createUser` varchar(63) DEFAULT NULL COMMENT '创建人'," +
"`updateUser` varchar(63) DEFAULT NULL COMMENT '更新人'," +
"`owner` varchar(63) DEFAULT NULL COMMENT '所有人'," +
"`createTime` datetime DEFAULT NULL COMMENT '创建时间'," +
"`updateTime` datetime DEFAULT NULL COMMENT '更新时间'," +
" PRIMARY KEY (`id`),"+
"UNIQUE KEY `keId` (`keId`)"+
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='客诉管理员ids';"})
public void createTbKesuIds(@Param("tableName") String tableName);
@Update({"drop table if exists ${tableName}"})
public void dropExistTable(@Param("tableName") String tableName);
}
@SpringBootApplication(scanBasePackages = {"com.wanda.desk"})
@EnableScheduling
@MapperScan("com.wanda.desk.dao")
public class DeskApplication {
public static void main(String[] args) {
SpringApplication.run(DeskApplication.class, args);
}
}