USE master
GO

DROP DATABASE IF EXISTS [HUMAN_RESOURCES]
GO

CREATE DATABASE [HUMAN_RESOURCES]
 CONTAINMENT = NONE
 ON  PRIMARY 
( 
NAME = N'HUMAN_RESOURCES_PRIMARY', 
FILENAME = N'D:\SQL2019DATAI1\HUMAN_RESOURCES\PRIMARY.mdf' ,  -- this is for system tables
SIZE = 520KB ,
 MAXSIZE = UNLIMITED, 
 FILEGROWTH = 64KB 
),
 FILEGROUP [HUMAN_RESOURCES_DATA] 
( 
NAME = N'EMPLOYEE_DATA1', 
FILENAME = N'D:\SQL2019DATAI1\HUMAN_RESOURCES\HUMAN_RESOURCES_DATA1.ndf' , -- this is for database tables
SIZE = 520KB , 
MAXSIZE = UNLIMITED, 
FILEGROWTH = 64KB
) 
LOG ON 
( 
NAME = N'HUMAN_RESOURCES_log', 
FILENAME = N'D:\SQL2019DATAI1\HUMAN_RESOURCES\HUMAN_RESOURCES_SALES_log.ldf' , -- this is for database logs
SIZE = 520KB ,
MAXSIZE = 800KB , 
FILEGROWTH = 64KB 
)
GO

ALTER DATABASE HUMAN_RESOURCES
SET SINGLE_USER
GO

ALTER DATABASE HUMAN_RESOURCES
ADD FILEGROUP HUMAN_RESOURCES_DATA_FG_2
GO

ALTER DATABASE HUMAN_RESOURCES
ADD FILE
( 
NAME = N'TRAINING_DATA', 
FILENAME = N'D:\SQL2019DATAI1\HUMAN_RESOURCES\TRAINING_DATA.ndf', 
SIZE = 520KB,MAXSIZE = UNLIMITED,FILEGROWTH = 64KB 
)
TO FILEGROUP HUMAN_RESOURCES_DATA_FG_2
GO

ALTER DATABASE HUMAN_RESOURCES
SET MULTI_USER
GO