From cc0e1843143fd27afd39b278612919aabb7163e9 Mon Sep 17 00:00:00 2001 From: RuoYi <yzz_ivy@163.com> Date: Tue, 19 Jul 2022 16:08:11 +0800 Subject: [PATCH] 优化多个相同角色数据导致权限SQL重复问题 --- sql/ry_seata_20210128.sql | 9 +++++++++ 1 files changed, 9 insertions(+), 0 deletions(-) diff --git a/sql/ry_seata_20210128.sql b/sql/ry_seata_20210128.sql index 4662eb2..80aeeff 100644 --- a/sql/ry_seata_20210128.sql +++ b/sql/ry_seata_20210128.sql @@ -1,3 +1,12 @@ +DROP DATABASE IF EXISTS `ry-seata`; + +CREATE DATABASE `ry-seata` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; + +SET NAMES utf8mb4; +SET FOREIGN_KEY_CHECKS = 0; + +USE `ry-seata`; + -- -------------------------------- The script used when storeMode is 'db' -------------------------------- -- the table to store GlobalSession data CREATE TABLE IF NOT EXISTS `global_table` -- Gitblit v1.9.3