USE [master] GO /****** Object: Database Script Date: 04/19/2007 14:35:07 ******/ CREATE DATABASE [TaskFilesDB] COLLATE Cyrillic_General_CI_AS GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) BEGIN EXEC [TaskFilesDB].[dbo].[sp_fulltext_database] @action = 'disable' END GO ALTER DATABASE [TaskFilesDB] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [TaskFilesDB] SET ANSI_NULLS OFF GO ALTER DATABASE [TaskFilesDB] SET ANSI_PADDING OFF GO ALTER DATABASE [TaskFilesDB] SET ANSI_WARNINGS OFF GO ALTER DATABASE [TaskFilesDB] SET ARITHABORT OFF GO ALTER DATABASE [TaskFilesDB] SET AUTO_CLOSE OFF GO ALTER DATABASE [TaskFilesDB] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [TaskFilesDB] SET AUTO_SHRINK OFF GO ALTER DATABASE [TaskFilesDB] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [TaskFilesDB] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [TaskFilesDB] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [TaskFilesDB] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [TaskFilesDB] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [TaskFilesDB] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [TaskFilesDB] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [TaskFilesDB] SET ENABLE_BROKER GO ALTER DATABASE [TaskFilesDB] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [TaskFilesDB] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [TaskFilesDB] SET TRUSTWORTHY OFF GO ALTER DATABASE [TaskFilesDB] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [TaskFilesDB] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [TaskFilesDB] SET READ_WRITE GO ALTER DATABASE [TaskFilesDB] SET RECOVERY FULL GO ALTER DATABASE [TaskFilesDB] SET MULTI_USER GO ALTER DATABASE [TaskFilesDB] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [TaskFilesDB] SET DB_CHAINING OFF GO USE [TaskFilesDB] GO IF NOT EXISTS (SELECT * FROM dbo.sysusers WHERE name = N'D10TaskUser' AND uid < 16382) BEGIN EXEC sp_grantdbaccess N'D10TaskUser', N'D10TaskUser' -- D10TaskUser - пользователь, от имени которого выполняется подключение сайта к базе END EXEC sp_addrolemember N'db_owner', N'D10TaskUser' GO --done ALTER DATABASE TaskFilesDB SET TRUSTWORTHY ON GO /****** Object: FullTextCatalog [UploadedFilesFTCatalog] Script Date: 06/20/2011 13:11:17 ******/ EXEC sp_fulltext_database 'enable' GO CREATE FULLTEXT CATALOG [UploadedFilesFTCatalog] GO IF OBJECT_ID('UploadFiles') IS NULL BEGIN /****** Object: Table [dbo].[UploadFiles] Script Date: 06/20/2011 13:11:13 ******/ CREATE TABLE [dbo].[UploadFiles]( [id] [int] IDENTITY(1,1) NOT NULL, [FileContent] [varbinary](max) NULL, [Ext] [varchar](128) NULL, [UserID] [int] NULL, [FileName] [varchar](200) NULL, [Compressed] [bit] NOT NULL DEFAULT 0 CONSTRAINT [PK_UploadFiles] PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE FULLTEXT INDEX ON [dbo].[UploadFiles]( [FileContent] TYPE COLUMN [Ext] LANGUAGE [English]) KEY INDEX [PK_UploadFiles] ON [UploadedFilesFTCatalog] WITH CHANGE_TRACKING AUTO END