kreta/Kreta.DataAccess.Migrations/DBScripts/Database/create.schemas.sql
2024-03-13 00:33:46 +01:00

19 lines
354 B
Transact-SQL

IF SCHEMA_ID('dev') IS NULL BEGIN
EXEC sp_executesql N'CREATE SCHEMA dev'
END
GO
IF SCHEMA_ID('auditlog') IS NULL BEGIN
EXEC sp_executesql N'CREATE SCHEMA auditlog'
END
GO
IF SCHEMA_ID('core') IS NULL BEGIN
EXEC sp_executesql N'CREATE SCHEMA core'
END
GO
IF SCHEMA_ID('tmp') IS NULL BEGIN
EXEC sp_executesql N'CREATE SCHEMA tmp'
END
GO