DROP DATABASE IF EXISTS [INVENTORY]
GO

CREATE DATABASE [INVENTORY]
 CONTAINMENT = NONE
 ON  PRIMARY 
( 
	NAME = N'INVENTORY', 
	FILENAME = N'D:\SQL2019DATAI1\INVENTORY\INVENTORY.mdf' , 
	SIZE = 1000KB ,
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 650KB 
), 
 FILEGROUP [INVENTORY_DATA] 
( 
	NAME = N'PRODUCT_DATA1', 
	FILENAME = N'D:\SQL2019DATAI1\INVENTORY\PRODUCT_DATA1.ndf' , 
	SIZE = 1000KB ,
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 650KB 
),
( 
	NAME = N'PRODUCT_DATA2', 
	FILENAME = N'D:\SQL2019DATAI1\INVENTORY\PRODUCT_DATA2.ndf' , 
	SIZE = 1000KB ,
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 650KB 
)
 LOG ON 
( 
	NAME = N'INVENTORY_log', 
	FILENAME = N'D:\SQL2019DATAI1\INVENTORY\INVENTORY_log.ldf' , 
	SIZE = 1000KB ,
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 650KB 
)
GO

ALTER DATABASE INVENTORY
ADD FILEGROUP PRODUCT_DATA
GO

ALTER DATABASE INVENTORY
ADD FILE
( 
	NAME = N'PRODUCT_DATA3', 
	FILENAME = N'D:\SQL2019DATAI1\INVENTORY\PRODUCT_DATA3.ndf' , 
	SIZE = 1000KB ,
	MAXSIZE = UNLIMITED, 
	FILEGROWTH = 650KB  
)
TO FILEGROUP PRODUCT_DATA
GO