thinkphp6按月新增数据表

代码如下：

/*
 * 按月新建数据表
 * */
public function create_tables(){
    //获取年月
    $year_time = date('Ym');
    $db = Db::connect('log');
    Db::startTrans();
    try {
        $sql = "CREATE TABLE `$year_time`  (
          `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '自增ID',
          `api` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL COMMENT '请求API',
          `qs` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' COMMENT '参数',
          `time` int(10) UNSIGNED NOT NULL COMMENT '请求时间',
          `resp` json NOT NULL COMMENT '返回的JSON结果',
          PRIMARY KEY (`id`) USING BTREE,
          INDEX `idx_request`(`api`, `qs`, `time`) USING BTREE
        ) ENGINE = MyISAM AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '接口请求记录表' ROW_FORMAT = Dynamic;";
       $db->query($sql);
        // 提交事务
        Db::commit();
    } catch (\Exception $e) {
        // 回滚事务
        Db::rollback();
    }
}