0.database-qwoss_v001.sql

CRM源码This file describes some issues that should be implemented in future and how it should be imple

IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'qwoss')
        DROP DATABASE [qwoss]
GO

CREATE DATABASE [qwoss]  ON (NAME = N'qwoss_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\qwoss_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'qwoss_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\qwoss_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
 COLLATE Latin1_General_CI_AS
GO

exec sp_dboption N'qwoss', N'autoclose', N'true'
GO

exec sp_dboption N'qwoss', N'bulkcopy', N'false'
GO

exec sp_dboption N'qwoss', N'trunc. log', N'true'
GO

exec sp_dboption N'qwoss', N'torn page detection', N'true'
GO

exec sp_dboption N'qwoss', N'read only', N'false'
GO

exec sp_dboption N'qwoss', N'dbo use', N'false'
GO

exec sp_dboption N'qwoss', N'single', N'false'
GO

exec sp_dboption N'qwoss', N'autoshrink', N'true'
GO

exec sp_dboption N'qwoss', N'ANSI null default', N'false'
GO

exec sp_dboption N'qwoss', N'recursive triggers', N'false'
GO

exec sp_dboption N'qwoss', N'ANSI nulls', N'false'
GO

exec sp_dboption N'qwoss', N'concat null yields null', N'false'
GO

exec sp_dboption N'qwoss', N'cursor close on commit', N'false'
GO

exec sp_dboption N'qwoss', N'default to local cursor', N'false'
GO

exec sp_dboption N'qwoss', N'quoted identifier', N'false'
GO

exec sp_dboption N'qwoss', N'ANSI warnings', N'false'
GO

exec sp_dboption N'qwoss', N'auto create statistics', N'true'
GO

exec sp_dboption N'qwoss', N'auto update statistics', N'true'
GO

if( ( (@@microsoftversion / power(2, 24) = 8) and (@@microsoftversion & 0xffff >= 724) ) or ( (@@microsoftversion / power(2, 24) = 7) and (@@microsoftversion & 0xffff >= 1082) ) )
        exec sp_dboption N'qwoss', N'db chaining', N'false'
GO