CREATE DATABASE [kufrik]
 CONTAINMENT = NONE
 ON  PRIMARY 
( NAME = N'kufrik', FILENAME = N'/var/opt/mssql/data/kufrik.mdf' , SIZE = 8192KB , FILEGROWTH = 65536KB )
 LOG ON 
( NAME = N'kufrik_log', FILENAME = N'/var/opt/mssql/data/kufrik_log.ldf' , SIZE = 8192KB , FILEGROWTH = 65536KB )
GO
ALTER DATABASE [kufrik] SET COMPATIBILITY_LEVEL = 150
GO

--user:
USE [master]
GO
CREATE LOGIN [kufrik] WITH PASSWORD=N'giteaKufrik_2024', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
use [master];
GO
USE [kufrik]
GO
CREATE USER [kufrik] FOR LOGIN [kufrik]
GO
USE [kufrik]
GO
ALTER USER [kufrik] WITH DEFAULT_SCHEMA=[dbo]
GO
USE [kufrik]
GO
ALTER ROLE [db_owner] ADD MEMBER [kufrik]
GO


