V1_0_0__create_database.sql 708 B

123456
  1. USE [master]
  2. IF NOT EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') CREATE DATABASE [callmaster]
  3. IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] MODIFY FILE ( NAME = N'callmaster' , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  4. IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] MODIFY FILE ( NAME = N'callmaster_log' , MAXSIZE = UNLIMITED , FILEGROWTH = 10%)
  5. IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] SET AUTO_SHRINK ON
  6. IF EXISTS (SELECT name FROM sys.databases WHERE name = N'callmaster') ALTER DATABASE [callmaster] SET RECOVERY SIMPLE