odboy/kenaito-conf
0
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
kenaito-conf/sql/kenaito_conf.sql
T
odboy 28c727501f fix(config): 统一历史记录与配置的数据库时间来源 
- saveHistory 接收调用方传入的数据库时间，不再使用 time.Now()
- 更新、删除、回滚先取 dao.Now()，避免取时间失败时产生无效历史
- 历史表 created_at 升级为 datetime(3)，新增迁移脚本
2026-09-18 21:14:53 +08:00

753 lines
27 KiB
SQL
Raw Permalink Blame History

-- Database export: kenaito_conf
-- Date: 2026-10-18 09:33:20
-- Generated by DBX
SET FOREIGN_KEY_CHECKS = 0;
CREATE TABLE `profile_extr_attr` (
`profile` varchar(32) NOT NULL,
`attr_name` varchar(50) NOT NULL,
`attr_value` varchar(100) DEFAULT NULL,
PRIMARY KEY (`profile`,`attr_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
CREATE TABLE `business_group` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) NOT NULL,
`master` varchar(255) DEFAULT NULL,
`remarks` text,
`enabled` tinyint(1) DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`created_by` varchar(32) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` varchar(32) DEFAULT NULL,
`master_uids` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
INSERT INTO `business_group` (`id`, `name`, `master`, `remarks`, `enabled`, `created_at`, `created_by`, `updated_at`, `updated_by`, `master_uids`) VALUES
(1, '默认组', 'admin,guest', '', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin', '1,5');
CREATE TABLE `client_instance` (
`id` int NOT NULL AUTO_INCREMENT,
`app_config_id` int DEFAULT NULL,
`app_name` varchar(64) DEFAULT NULL,
`env` varchar(32) DEFAULT NULL,
`ip` varchar(64) DEFAULT NULL,
`last_fetch_at` datetime DEFAULT NULL,
`last_fetch_type` varchar(16) DEFAULT NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`last_ping_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `UQE_client_instance_udx_aaei` (`app_config_id`,`app_name`,`env`,`ip`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8mb3;
CREATE TABLE `application` (
`id` int NOT NULL AUTO_INCREMENT,
`group_id` int DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`code` varchar(32) DEFAULT NULL,
`service_id` varchar(64) DEFAULT NULL,
`remarks` text,
`enabled` tinyint(1) DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`created_by` varchar(32) DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`updated_by` varchar(32) DEFAULT NULL,
`token` varchar(64) DEFAULT NULL,
`owner_ids` varchar(255) DEFAULT NULL,
`owner_names` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3;
INSERT INTO `application` (`id`, `group_id`, `name`, `code`, `service_id`, `remarks`, `enabled`, `created_at`, `created_by`, `updated_at`, `updated_by`, `token`, `owner_ids`, `owner_names`) VALUES
(1, 1, 'Java SpringBoot Demo', 'kenaito-springboot-demo', '', '', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin', '', '1,5', 'admin,guest');
CREATE TABLE `app_extr_attr` (
`app_id` int NOT NULL,
`env` varchar(16) NOT NULL,
`attr_name` varchar(32) NOT NULL,
`attr_value` varchar(100) DEFAULT NULL,
PRIMARY KEY (`app_id`,`env`,`attr_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;
CREATE TABLE `profile` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(32) DEFAULT NULL,
`alias` varchar(32) DEFAULT NULL,
`is_default` tinyint(1) DEFAULT '0',
`enabled` tinyint(1) DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3;
INSERT INTO `profile` (`id`, `name`, `alias`, `is_default`, `enabled`, `created_at`, `updated_at`) VALUES
(1, 'daily', '测试环境', 1, 1, NULL, NULL),
(2, 'stage', '预发布环境', 1, 1, NULL, NULL),
(3, 'online', '线上环境', 1, 1, NULL, NULL);
CREATE TABLE `app_config` (
`id` int NOT NULL AUTO_INCREMENT,
`group_id` int DEFAULT NULL,
`app_id` int DEFAULT NULL,
`app_code` varchar(32) DEFAULT NULL,
`env` varchar(16) DEFAULT NULL,
`version` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`type` smallint DEFAULT NULL,
`contents` text,
`enabled` tinyint(1) DEFAULT '1',
`created_at` datetime(3) DEFAULT NULL,
`created_by` varchar(32) DEFAULT NULL,
`updated_at` datetime(3) DEFAULT NULL,
`updated_by` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb3;
INSERT INTO `app_config` (`id`, `group_id`, `app_id`, `app_code`, `env`, `version`, `name`, `type`, `contents`, `enabled`, `created_at`, `created_by`, `updated_at`, `updated_by`) VALUES
(1, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=330674
database.name=kenaito_conf
database.password=1235555888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=777a
', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(2, 1, NULL, '', 'daily', 'latest', 'test.asc', 2, 'asdasdasdasd', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(3, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'topicid', 2, 'asdasdasd', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(4, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'aaaaa', 2, '啊啊啊啊啊啊', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(5, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', '人人人人', 2, 'sdfsdfsdf', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(6, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'rwerw', 2, 'dfsdfsdfs', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(7, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', '大撒打算大', 2, '撒打算大饭店发生的', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(8, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'wwwe', 2, '到付水电费水电费', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(9, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'wwwewe', 2, 'sdfsdfsdffdfd', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(10, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'wfffsdfsfsf', 2, '23424234234', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(11, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'dsfs', 2, 'dffsdfsdfsd', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(12, 1, NULL, '', 'daily', 'latest', 'hello.man1', 2, '是生生世世生生世世', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(13, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'hello.man2', 2, '撒撒打算大', 1, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(14, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'hello.man3', 2, '撒打算大撒打算大苏打水水电费水电费是', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(15, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'hello.man4', 2, '就会大富大贵地方得到的', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(16, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'hello.man5', 2, '水电费水电费不不不不不', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin'),
(17, 1, 1, 'kenaito-springboot-demo', 'daily', 'latest', 'hello.man6', 2, '多少分啥地方444分嘎嘎嘎嘎', 0, '2026-10-18 09:33:20', 'admin', '2026-10-18 09:33:20', 'admin');
CREATE TABLE `app_config_history` (
`id` int NOT NULL AUTO_INCREMENT,
`origin_id` int DEFAULT NULL,
`app_id` int DEFAULT NULL,
`app_name` varchar(32) DEFAULT NULL,
`app_names` varchar(64) DEFAULT NULL,
`env` varchar(16) DEFAULT NULL,
`version` varchar(32) DEFAULT NULL,
`name` varchar(32) DEFAULT NULL,
`type` smallint DEFAULT NULL,
`operate` varchar(16) DEFAULT NULL,
`contents` text,
`created_at` datetime(3) DEFAULT NULL,
`created_by` varchar(32) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb3;
INSERT INTO `app_config_history` (`id`, `origin_id`, `app_id`, `app_name`, `app_names`, `env`, `version`, `name`, `type`, `contents`, `created_at`, `created_by`) VALUES
(1, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8080
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=123456
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
', '2026-10-18 09:33:20', 'admin'),
(2, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8080
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=123456
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
', '2026-10-18 09:33:20', 'admin'),
(3, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=123456
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
', '2026-10-18 09:33:20', 'admin'),
(4, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=1234567
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
', '2026-10-18 09:33:20', 'admin'),
(5, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=12345678
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
', '2026-10-18 09:33:20', 'admin'),
(6, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.user=root
database.password=12345678
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(7, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345678
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 加密配置 ==========
crypto.secretKey=k9#mP2$vL7qR4xN8
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(8, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345678
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(9, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=1234567890
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(10, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345678
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(11, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=1234567822
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas
', '2026-10-18 09:33:20', 'admin'),
(12, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=1234567822
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大
', '2026-10-18 09:33:20', 'admin'),
(13, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大
', '2026-10-18 09:33:20', 'admin'),
(14, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大666
', '2026-10-18 09:33:20', 'admin'),
(15, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777
', '2026-10-18 09:33:20', 'admin'),
(16, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777
', '2026-10-18 09:33:20', 'admin'),
(17, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(18, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=12345675777
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(19, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=128888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(20, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=88887777
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(21, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=8888777799
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(22, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=88887777999880000
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(23, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=8888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(24, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=88889999
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(25, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=888899990000
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(26, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=123456
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(27, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=123456789
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(28, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=123
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(29, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=1235555
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(30, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=3306
database.name=kenaito_conf
database.password=1235555777
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(31, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=33067
database.name=kenaito_conf
database.password=1235555777
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(32, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=33067
database.name=kenaito_conf
database.password=1235555
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(33, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=33067
database.name=kenaito_conf
database.password=1235555888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=sdasdas是大大6667777888
', '2026-10-18 09:33:20', 'admin'),
(34, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=33067
database.name=kenaito_conf
database.password=1235555888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=666a
', '2026-10-18 09:33:20', 'admin'),
(35, 7, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', '大撒打算大', 2, '撒打算大', '2026-10-18 09:33:20', 'admin'),
(36, 1, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'application-dev.properties', 1, '# ========== 服务器配置 ==========
server.port=8084
# ========== 数据库配置 ==========
database.host=127.0.0.1
database.port=33067
database.name=kenaito_conf
database.password=1235555888
# ========== JWT 配置 ==========
jwt.secret=kenaito-conf-jwt-secret-2026
jwt.expireHours=24
# ========== 新增配置 ==========
config.test=777a
', '2026-10-18 09:33:20', 'admin'),
(37, 15, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'hello.man4', 2, '就会大富大贵地方', '2026-10-18 09:33:20', 'admin'),
(38, 14, 1, '', 'Java SpringBoot Demo(kenaito-springboot-demo)', 'daily', 'latest', 'hello.man3', 2, '撒打算大撒打算大苏打水', '2026-10-18 09:33:20', 'admin');
CREATE TABLE `user` (
`id` int NOT NULL AUTO_INCREMENT,
`group_id` int DEFAULT NULL,
`name` varchar(16) DEFAULT NULL,
`password` varchar(64) DEFAULT NULL,
`mobile` char(11) DEFAULT NULL,
`email` varchar(32) DEFAULT NULL,
`type` varchar(16) DEFAULT 'user',
`enabled` tinyint(1) DEFAULT '1',
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`last_logout_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3;
INSERT INTO `user` (`id`, `group_id`, `name`, `password`, `mobile`, `email`, `type`, `enabled`, `created_at`, `updated_at`, `last_logout_at`) VALUES
(1, NULL, 'admin', '$2a$10$uHzjUffJ6LI1JhE5eMc41e91bkpGa1jI0vHZX6DNEDi8Ci511Q6Dq', '18888888888', 'tianjun@odboy.cn', 'superAdmin', 1, '2026-10-18 09:33:20', '2026-10-18 09:33:20', '2026-10-18 09:33:20'),
(5, NULL, 'guest', '$2a$10$beUURwxRmvuRTfi.SyjHOusPUGc5SUF.8/RtVE.TykzzXrd6X3Qje', '18888888889', 'tianjun@odboy.cn', 'user', 1, '2026-10-18 09:33:20', NULL, '2026-10-18 09:33:20');
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink