数据库支持

提示

数据库支持MYsql、MSSql、Oracle，下一步将适配国产数据库。

mysql

提示

脚本是mysql 8 导出的，如果你用的是mysql7 需要填调整脚本：将 utf8mb4_0900_ai_ci 全部替换成 utf8mb4_general_ci

nacos 数据库

sql

 CREATE DATABASE IF NOT EXISTS `acuity_nacos` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

 CREATE DATABASE IF NOT EXISTS `acuity_nacos` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

SkyWalking 数据库

sql

 CREATE DATABASE IF NOT EXISTS `acuity_sw` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

 CREATE DATABASE IF NOT EXISTS `acuity_sw` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

acuity-cloud-pro-none 和 acuity-boot-pro-none 数据库

sql

CREATE DATABASE IF NOT EXISTS `acuity_none` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE DATABASE IF NOT EXISTS `acuity_none` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

acuity-cloud-pro-datasource-column 和 acuity-boot-pro-datasource-column 数据库

sql

- CREATE DATABASE IF NOT EXISTS `acuity_ds_c_defaults` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE DATABASE IF NOT EXISTS `acuity_base_1` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

- CREATE DATABASE IF NOT EXISTS `acuity_ds_c_defaults` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE DATABASE IF NOT EXISTS `acuity_base_1` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

acuity-cloud-pro-column 和 acuity-boot-pro-column 数据库

sql

CREATE DATABASE IF NOT EXISTS `acuity_column` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

CREATE DATABASE IF NOT EXISTS `acuity_column` CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

MSSql

提示

MSSql2019+

nacos 数据库

sql

CREATE DATABASE acuity_nacos COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_nacos COLLATE Chinese_PRC_CI_AS;
GO

SkyWalking 数据库

sql

CREATE DATABASE acuity_sw COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_sw COLLATE Chinese_PRC_CI_AS;
GO

acuity-cloud-pro-column 和 acuity-boot-pro-column 数据库

sql

CREATE DATABASE acuity_column COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_column COLLATE Chinese_PRC_CI_AS;
GO

Oracle

提示

Oracle 11g

nacos 数据库

sql

CREATE DATABASE acuity_nacos COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_nacos COLLATE Chinese_PRC_CI_AS;
GO

seata 数据库

sql

CREATE DATABASE acuity_seata COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_seata COLLATE Chinese_PRC_CI_AS;
GO

SkyWalking 数据库

sql

CREATE DATABASE acuity_sw COLLATE Chinese_PRC_CI_AS;
GO

CREATE DATABASE acuity_sw COLLATE Chinese_PRC_CI_AS;
GO

acuity-cloud-pro-column 和 acuity-boot-pro-column 数据库

sql

create user acuity_column identified by acuity_column;

create user acuity_column identified by acuity_column;

给用户授权

sql

grant create session,create table,create sequence,create view,resource to acuity_nacos;
grant create session,create table,create sequence,create view,resource to acuity_seata;
grant create session,create table,create sequence,create view,resource to acuity_sw;
grant create session,create table,create sequence,create view,resource to acuity_column;

grant create session,create table,create sequence,create view,resource to acuity_nacos;
grant create session,create table,create sequence,create view,resource to acuity_seata;
grant create session,create table,create sequence,create view,resource to acuity_sw;
grant create session,create table,create sequence,create view,resource to acuity_column;

表结构及数据脚本

提示

数据库结构及数据脚本请联系获取。

数据库支持 ​

mysql ​

MSSql ​

Oracle ​

表结构及数据脚本 ​

数据库支持

mysql

MSSql

Oracle

表结构及数据脚本