206 Star 413 Fork 193

ZKEASOFT/ASP.NET-MVC-CMS

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
CreateDataBase.sql 4.06 KB
一键复制 编辑 原始数据 按行查看 历史
Wayne 提交于 2015-09-11 09:12 +08:00 . rename
CREATE DATABASE [$(dataBase)] ON PRIMARY
( NAME = N'$(dataBase)', FILENAME = N'$(dbPath)\$(dataBase).mdf' , SIZE = 5120KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
LOG ON
( NAME = N'$(dataBase)_log', FILENAME = N'$(dbPath)\$(dataBase)_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [$(dataBase)].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [$(dataBase)] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [$(dataBase)] SET ANSI_NULLS OFF
GO
ALTER DATABASE [$(dataBase)] SET ANSI_PADDING OFF
GO
ALTER DATABASE [$(dataBase)] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [$(dataBase)] SET ARITHABORT OFF
GO
ALTER DATABASE [$(dataBase)] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [$(dataBase)] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [$(dataBase)] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [$(dataBase)] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [$(dataBase)] SET CURSOR_DEFAULT GLOBAL
GO
ALTER DATABASE [$(dataBase)] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [$(dataBase)] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [$(dataBase)] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [$(dataBase)] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [$(dataBase)] SET DISABLE_BROKER
GO
ALTER DATABASE [$(dataBase)] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [$(dataBase)] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [$(dataBase)] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [$(dataBase)] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [$(dataBase)] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [$(dataBase)] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [$(dataBase)] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [$(dataBase)] SET RECOVERY SIMPLE
GO
ALTER DATABASE [$(dataBase)] SET MULTI_USER
GO
ALTER DATABASE [$(dataBase)] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [$(dataBase)] SET DB_CHAINING OFF
GO
ALTER DATABASE [$(dataBase)] SET READ_WRITE
GO
Loading...
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
C#
1
https://gitee.com/seriawei/ASP.NET-MVC-CMS.git
git@gitee.com:seriawei/ASP.NET-MVC-CMS.git
seriawei
ASP.NET-MVC-CMS
ASP.NET-MVC-CMS
master

搜索帮助