/*
ALTER DATABASE [HOBBY_SHOP]
SET SINGLE_USER;
GO

DROP DATABASE IF EXISTS [HOBBY_SHOP]
GO
*/

-- took 13 seconds to create 

CREATE DATABASE [HOBBY_SHOP]
 CONTAINMENT = NONE
 ON  PRIMARY 
( 
	NAME = N'HOBBY_SHOP', 
	FILENAME = N'D:\SQL2019DATAI1\HOBBY_SHOP\HOBBY_SHOP.mdf' , 
	SIZE = 500MB ,
	 MAXSIZE = 1GB, 
	 FILEGROWTH = 100MB 
),
 FILEGROUP [HOBBY_SHOP_DATA_FG] 
( 
	NAME = N'HOBBY_SHOP_DATA1', 
	FILENAME = N'D:\SQL2019DATAI1\HOBBY_SHOP\HOBBY_SHOP_DATA.ndf' , 
	SIZE = 1000MB, 
	MAXSIZE = 10000MB, 
	FILEGROWTH = 500MB 
)
 LOG ON 
( 
	NAME = N'HOBBY_SHOP_log', 
	FILENAME = N'D:\SQL2019DATAI1\HOBBY_SHOP\HOBBY_SHOP_log.ldf' , 
	SIZE = 1GB,
	MAXSIZE = 5GB, 
	FILEGROWTH = 1GB 
)
GO

USE [HOBBY_SHOP]
GO

CREATE SCHEMA [SALES]
GO