-- ============================================================
-- DBAOps Futuristic Enterprise™ - FuturisticREPO Database
-- SOURCE OF TRUTH: CMS (Central Management Server)
-- Microsoft SQL Server & Azure focused
-- ============================================================
USE [master];
GO

IF NOT EXISTS (SELECT 1 FROM sys.databases WHERE name = 'FuturisticREPO')
BEGIN
    CREATE DATABASE [FuturisticREPO]
    ON PRIMARY (
        NAME = N'FuturisticREPO',
        FILENAME = N'M:\ProdDB\FuturisticREPO\FuturisticREPO.mdf',
        SIZE = 1024MB, FILEGROWTH = 256MB
    )
    LOG ON (
        NAME = N'FuturisticREPO_log',
        FILENAME = N'M:\ProdDB\FuturisticREPO\FuturisticREPO_log.ldf',
        SIZE = 512MB, FILEGROWTH = 128MB
    );
    PRINT 'Database FuturisticREPO created';
END
ELSE
    PRINT 'Database FuturisticREPO already exists';
GO

ALTER DATABASE [FuturisticREPO] SET RECOVERY FULL;
GO
