1 files changed, 67 insertions, 0 deletions
diff --git a/sql/db.sql.template b/sql/db.sql.template
new file mode 100644
index 0000000..09e3d4b
--- /dev/null
+++ b/sql/db.sql.template
@@ -0,0 +1,67 @@
+IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'@initial.catalog@')
+	DROP DATABASE [@initial.catalog@]
+GO
+
+CREATE DATABASE [@initial.catalog@] ON  PRIMARY 
+( NAME = N'@initial.catalog@_Data', FILENAME = N'@database.path@\@initial.catalog@.mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
+ LOG ON 
+( NAME = N'@initial.catalog@_Log', FILENAME = N'@database.path@\@initial.catalog@.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
+GO
+EXEC dbo.sp_dbcmptlevel @dbname=N'@initial.catalog@', @new_cmptlevel=90
+GO
+IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
+begin
+EXEC [@initial.catalog@].[dbo].[sp_fulltext_database] @action = 'enable'
+end
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_NULL_DEFAULT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_NULLS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_PADDING OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ANSI_WARNINGS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ARITHABORT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_CLOSE OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_CREATE_STATISTICS ON 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_SHRINK OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS ON 
+GO
+ALTER DATABASE [@initial.catalog@] SET CURSOR_CLOSE_ON_COMMIT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET CURSOR_DEFAULT  GLOBAL 
+GO
+ALTER DATABASE [@initial.catalog@] SET CONCAT_NULL_YIELDS_NULL OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET NUMERIC_ROUNDABORT OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET QUOTED_IDENTIFIER OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET RECURSIVE_TRIGGERS OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET  DISABLE_BROKER 
+GO
+ALTER DATABASE [@initial.catalog@] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET DATE_CORRELATION_OPTIMIZATION OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET TRUSTWORTHY OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET ALLOW_SNAPSHOT_ISOLATION OFF 
+GO
+ALTER DATABASE [@initial.catalog@] SET PARAMETERIZATION SIMPLE 
+GO
+ALTER DATABASE [@initial.catalog@] SET  READ_WRITE 
+GO
+ALTER DATABASE [@initial.catalog@] SET RECOVERY SIMPLE 
+GO
+ALTER DATABASE [@initial.catalog@] SET  MULTI_USER 
+GO
+ALTER DATABASE [@initial.catalog@] SET PAGE_VERIFY CHECKSUM  
+GO
+ALTER DATABASE [@initial.catalog@] SET DB_CHAINING OFF 
+\ No newline at end of file