zdqy_ibps/docker-compose/bin/init/mssql/sql/database-platform.sql

CREATE DATABASE ibps_platform
on primary
(
name = 'ibps_platform_data',
fileName = '/var/opt/mssql/data/ibps_platform.mdf',
size = 5MB,
maxsize = 100MB,
filegrowth = 15%
),
(
name = 'ibps_platform_data_2',
filename = '/var/opt/mssql/data/ibps_platform.ndf',
size = 20MB,
maxsize = 100MB,
filegrowth = 1MB
)
log on
(
name = 'ibps_platform_log',
filename = '/var/opt/mssql/data/ibps_platform_log.ldf',
size = 2MB,
filegrowth = 1MB
),
(
name = 'ibps_platform_log_2',
filename = '/var/opt/mssql/data/ibps_platform_log_2.ldf',
size = 10MB,
maxsize = 50MB,
filegrowth = 1MB
);
go
CREATE LOGIN ibps_platform  WITH PASSWORD = 'uij987eE90hgD';
go
CREATE USER ibps_platform FOR LOGIN ibps_platform;
go
EXEC ibps_platform.dbo.sp_changedbowner N'ibps_platform';
go
alter database ibps_platform collate Chinese_PRC_CI_AS;
go