-- FuturisticREPO - Create Schemas
-- DBAOps Futuristic Enterprise™
USE [FuturisticREPO];
GO

IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'config') EXEC('CREATE SCHEMA [config] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'license') EXEC('CREATE SCHEMA [license] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'discovery') EXEC('CREATE SCHEMA [discovery] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'compliance') EXEC('CREATE SCHEMA [compliance] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'audit') EXEC('CREATE SCHEMA [audit] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'fact') EXEC('CREATE SCHEMA [fact] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'alert') EXEC('CREATE SCHEMA [alert] AUTHORIZATION [dbo]');
IF NOT EXISTS (SELECT 1 FROM sys.schemas WHERE name = 'admin') EXEC('CREATE SCHEMA [admin] AUTHORIZATION [dbo]');
GO
