Skip to content

fix: postgresql和 mysql 初始化数据的脚本错误#123

Merged
Charles7c merged 1 commit intocontinew-org:devfrom
onekr-billy:dev
Jan 3, 2025
Merged

fix: postgresql和 mysql 初始化数据的脚本错误#123
Charles7c merged 1 commit intocontinew-org:devfrom
onekr-billy:dev

Conversation

@onekr-billy
Copy link
Copy Markdown
Contributor

PR 类型

  • 新 feature
  • Bug 修复
  • 功能增强
  • 文档变更
  • 代码样式变更
  • 重构
  • 性能改进
  • 单元测试
  • CI/CD
  • 其他

PR 目的

使用 postgresql 数据库,初次启动项目在执行liquibase的 sql 脚本时发生错误

解决方案

修正 src/main/resources/db/changelog/postgresql/main_data.sql 如下代码

# 修改前
INSERT INTO `sys_client`
(`id`, `client_id`, `client_key`, `client_secret`, `auth_type`, `client_type`, `active_timeout`, `timeout`, `status`, `create_user`, `create_time`)
VALUES
(1, 'ef51c9a3e9046c4f2ea45142c8a8344a', 'pc', 'dd77ab1e353a027e0d60ce3b151e8642', '[\"ACCOUNT\", \"EMAIL\", \"PHONE\", \"SOCIAL\"]', 'PC', 1800, 86400, 1, 1, NOW());

# 修改后
INSERT INTO `sys_client`
(`id`, `client_id`, `client_key`, `client_secret`, `auth_type`, `client_type`, `active_timeout`, `timeout`, `status`, `create_user`, `create_time`)
VALUES
(1, 'ef51c9a3e9046c4f2ea45142c8a8344a', 'pc', 'dd77ab1e353a027e0d60ce3b151e8642', '["ACCOUNT", "EMAIL", "PHONE", "SOCIAL"]', 'PC', 1800, 86400, 1, 1, NOW());

PR 测试

Changelog

模块 Changelog Related issues

其他信息

提交前确认

  • PR 代码经过了完整测试,并且通过了代码规范检查
  • 已经完整填写 Changelog,并链接到了相关 issues
  • PR 代码将要提交到 dev 分支

@CLAassistant
Copy link
Copy Markdown

CLAassistant commented Jan 3, 2025

CLA assistant check
All committers have signed the CLA.

@Charles7c Charles7c merged commit a305eac into continew-org:dev Jan 3, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants