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

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