Freelog 100/FreelogNo100-NovembreDecembre2010.iso/GestionFichiers/Mo-Search/Install_Mo-Search_3.1.1_Beta2.exe/MoSearch3__MSSQL.sql

Text (UTF-16) | 2010-08-11 | 147KB | 5,131 lines

USE [master]
GO
-- index defrag
--        EXEC usp_DefragIndex

/************************************************************************************************************
                                                CREATE DATABASE
************************************************************************************************************/
CREATE DATABASE [Mo-Search311] ON  PRIMARY
( NAME       = N'Mo-Search311_dat',
  FILENAME   = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Mo-Search311.mdf',
  SIZE       = 300MB ,
  MAXSIZE    = UNLIMITED,
  FILEGROWTH = 102400KB )    -- 100 MB
 LOG ON
( NAME       = N'Mo-Search311_log',
  FILENAME   = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\Mo-Search311.ldf',
  SIZE       = 100MB,
  MAXSIZE    = 2048GB,
  FILEGROWTH = 10%)
GO
EXEC dbo.sp_dbcmptlevel @dbname=N'Mo-Search', @new_cmptlevel=90
GO

-- set DB to use known good defaults
ALTER DATABASE [Mo-Search311] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [Mo-Search311] SET ANSI_NULLS OFF
GO
ALTER DATABASE [Mo-Search311] SET ANSI_PADDING OFF
GO
ALTER DATABASE [Mo-Search311] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [Mo-Search311] SET ARITHABORT OFF
GO
ALTER DATABASE [Mo-Search311] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [Mo-Search311] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [Mo-Search311] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [Mo-Search311] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [Mo-Search311] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [Mo-Search311] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [Mo-Search311] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [Mo-Search311] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [Mo-Search311] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [Mo-Search311] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [Mo-Search311] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [Mo-Search311] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [Mo-Search311] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [Mo-Search311] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [Mo-Search311] SET  READ_WRITE
GO
ALTER DATABASE [Mo-Search311] SET RECOVERY FULL
GO
ALTER DATABASE [Mo-Search311] SET  MULTI_USER
GO
ALTER DATABASE [Mo-Search311] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [Mo-Search311] SET DB_CHAINING OFF
GO

-- set non-default options
ALTER DATABASE [Mo-Search311] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO

/************************************************************************************************************
                                                CREATE Tables + Indexes
************************************************************************************************************/
USE [Mo-Search311]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[DomainGroup](
    [DgID] [int] IDENTITY(1,1) NOT NULL,
    [Grp] [nvarchar](50) NOT NULL,
    [Inc] [bit] NOT NULL DEFAULT ((1)),
 CONSTRAINT [PK_DomainGroup] PRIMARY KEY CLUSTERED
(
    [DgID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_DomainGroup_Grp] ON [dbo].[DomainGroup]
(
    [Grp] ASC
)
GO

CREATE TABLE [dbo].[ErrorType](
    [ErrorTypeID] [int] NOT NULL DEFAULT ((0)),
    [ErrorTypeDesc] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_ErrorType] PRIMARY KEY CLUSTERED
(
    [ErrorTypeID] ASC
))
GO
-- v3.1.1 unused b/c this overlaps with the PK
-- CREATE UNIQUE NONCLUSTERED INDEX [UDX_ErrorType_ErrorTypeID] ON [dbo].[ErrorType]
--(
--    [ErrorTypeID] ASC
--)

CREATE TABLE [dbo].[FtsNoiseWord](
    [WordID] [int] IDENTITY(1,1) NOT NULL,
    [WordText] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_FtsNoiseWord] PRIMARY KEY CLUSTERED
(
    [WordID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_FtsNoiseWord_WordText] ON [dbo].[FtsNoiseWord]
(
    [WordText] ASC
)
GO

CREATE TABLE [dbo].[FtsWordUsage](
    [WordID] [int] NOT NULL,
    [WordUsage] [int] NOT NULL,
    [WordText] [nvarchar](255) NOT NULL
)
GO
-- v3.1.1 unused b/c this overlaps with the PK
--CREATE NONCLUSTERED INDEX [WordID] ON [dbo].[FtsWordUsage]
--(
--    [WordID] ASC
--)
CREATE UNIQUE NONCLUSTERED INDEX [UDX_FtsWordUsage_WordText] ON [dbo].[FtsWordUsage]
(
    [WordText] ASC
)
GO

CREATE TABLE [dbo].[IndexHistory](
    [IndexHistoryID] [int] IDENTITY(1,1) NOT NULL,
    [MachineName] [nvarchar](255) NOT NULL,
    [RootDirectory] [nvarchar](255) NOT NULL,
    [StartDate] [datetime] NOT NULL,
    [Duration_MS] [int] NOT NULL,
    [Result] [nvarchar](128) NOT NULL,
    [FilenamesOnly] [bit] NOT NULL DEFAULT ((0)),
    [CtFilesAdded] [int] NOT NULL,
    [CtFilesDeleted] [int] NOT NULL,
    [CtFilesModified] [int] NOT NULL,
    [CtErrors] [int] NOT NULL,
    [CtWarnings] [int] NOT NULL,
 CONSTRAINT [PK_IndexHistory] PRIMARY KEY CLUSTERED
(
    [IndexHistoryID] ASC
))
GO

CREATE TABLE [dbo].[IndexInfo](
    [CreatedDate] [datetime] NULL,
    [ModifiedDate] [datetime] NULL,
    [Status] [nvarchar](255) NULL,
    [IndexedCountNow] [int] NOT NULL DEFAULT ((0)),
    [DbVersion] [int] NOT NULL DEFAULT ((1)),
    [LastStatsCalculate] [datetime] NOT NULL,
    [LastIndexChange] [datetime] NOT NULL,
    [LastIndexClean] [datetime] NOT NULL
)
GO

CREATE TABLE [dbo].[LockAccessDb](
    [LockID] [int] IDENTITY(1,1) NOT NULL,
    [LockSemaphore] [nvarchar](255) NOT NULL,
    [LockIPAddress] [nvarchar](64) NOT NULL,
    [WinLogin] [nvarchar](128) NOT NULL,
    [DateLocked] [datetime] NOT NULL,
    [IsLockResolved] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_LockAccessDb] PRIMARY KEY CLUSTERED
(
    [LockID] ASC
))
GO

CREATE TABLE [dbo].[Path](
    [PathID] [int] IDENTITY(1,1) NOT NULL,
    [Path] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_Path] PRIMARY KEY CLUSTERED
(
    [PathID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_Path_Path] ON [dbo].[Path]
(
    [Path] ASC
)
GO

CREATE TABLE [dbo].[SettingPath](
    [IdxPathID] [int] IDENTITY(1,1) NOT NULL,
    [IdxPath] [nvarchar](255) NOT NULL,
    [IncludeFiles] [bit] NOT NULL DEFAULT ((1)),
 CONSTRAINT [PK_SettingPath] PRIMARY KEY CLUSTERED
(
    [IdxPathID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_SettingPath_IndexPath] ON [dbo].[SettingPath]
(
    [IdxPath] ASC
)
GO

CREATE TABLE [dbo].[SettingPathOmit](
    [IdxPathID] [int] IDENTITY(1,1) NOT NULL,
    [IdxPath] [nvarchar](255) NOT NULL,
 CONSTRAINT [PK_SettingPathOmit] PRIMARY KEY CLUSTERED
(
    [IdxPathID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_SettingPathOmit_IdxPath] ON [dbo].[SettingPathOmit]
(
    [IdxPath] ASC
)
GO

CREATE TABLE [dbo].[SysSetting](
    [SettingID] [int] NOT NULL DEFAULT ((0)),
    [Value] [nvarchar](50) NULL,
 CONSTRAINT [PK_SysSetting] PRIMARY KEY CLUSTERED
(
    [SettingID] ASC
))
GO


CREATE TABLE [dbo].[FtsWord](
    [WordID] [int] IDENTITY(1,1) NOT NULL,
    [WordText] [nvarchar](48) NOT NULL,
 CONSTRAINT [PK_FtsWord] PRIMARY KEY CLUSTERED
(
    [WordID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_FtsWord_WordText] ON [dbo].[FtsWord]
(
    [WordText] ASC
)
INCLUDE ([WordID])
GO

CREATE TABLE [dbo].[FtsWordCount_Cache](
    [WordID] [int] NOT NULL DEFAULT ((0)),
    [FileID] [int] NOT NULL DEFAULT ((0)),
    [UseCt] [smallint] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_FtsWordCount_Cache] PRIMARY KEY CLUSTERED
(
    [WordID] ASC,
    [FileID] ASC
))
GO
CREATE NONCLUSTERED INDEX [IDX_FtsWordCount_Cache_FileID] ON [dbo].[FtsWordCount_Cache]
(
    [FileID] ASC
)
GO
-- v3.1.1 unused b/c this overlaps with the PK
-- CREATE NONCLUSTERED INDEX [WordID] ON [dbo].[FtsWordCount_Cache]
--(
--    [WordID] ASC
--)

CREATE TABLE [dbo].[FtsApp](
    [FtsAppID] [int] NOT NULL DEFAULT ((0)),
    [FtsAppDesc] [nvarchar](50) NOT NULL,
    [FtsAppOverview] [nvarchar](255) NULL,
 CONSTRAINT [PK_FtsApp] PRIMARY KEY CLUSTERED
(
    [FtsAppID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_FtsApp_TestAppDesc] ON [dbo].[FtsApp]
(
    [FtsAppDesc] ASC
)
GO
-- v3.1.1 unused b/c this overlaps with the PK
--CREATE UNIQUE NONCLUSTERED INDEX [TextAppID] ON [dbo].[FtsApp]
--(
--    [FtsAppID] ASC
--)

CREATE TABLE [dbo].[ErrorLog](
    [ErrorID] [int] IDENTITY(1,1) NOT NULL,
    [ErrorTypeID] [int] NOT NULL DEFAULT ((0)),
    [ErrorText] [nvarchar](50) NOT NULL,
 CONSTRAINT [PK_ErrorLog] PRIMARY KEY CLUSTERED
(
    [ErrorID] ASC
))
GO
CREATE NONCLUSTERED INDEX [IDX_ErrorLog_ErrorTypeID] ON [dbo].[ErrorLog]
(
    [ErrorTypeID] ASC
)
GO

CREATE TABLE [dbo].[DomainExt](
    [DgID] [int] NOT NULL DEFAULT ((0)),
    [ExtID] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_DomainExt] PRIMARY KEY CLUSTERED
(
    [DgID] ASC,
    [ExtID] ASC
))
GO
-- v3.1.1 unused b/c this overlaps with the PK
--CREATE NONCLUSTERED INDEX [DomainGroupID] ON [dbo].[DomainExt]
--(
--    [DgID] ASC
--)
CREATE NONCLUSTERED INDEX [IDX_DomainExt_ExtID] ON [dbo].[DomainExt]
(
    [ExtID] ASC
)
GO

CREATE TABLE [dbo].[FtsExt](
    [ftsExtID] [int] IDENTITY(1,1) NOT NULL,
    [ExtID] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_FtsExt] PRIMARY KEY CLUSTERED
(
    [ftsExtID] ASC
))
GO
CREATE NONCLUSTERED INDEX [IDX_FtsExt_ExtID] ON [dbo].[FtsExt]
(
    [ExtID] ASC
)
GO

CREATE TABLE [dbo].[Uri](
    [FileID] [int] IDENTITY(1,1) NOT NULL,
    [PathID] [int] NOT NULL DEFAULT ((0)),
    [Uri] [nvarchar](255) NOT NULL,
    [SizeBytes] [int] NOT NULL DEFAULT ((0)),
    [SizeKB] [int] NOT NULL DEFAULT ((0)),
    [Modified] [datetime] NOT NULL,
    [Created] [datetime] NOT NULL,
    [ExtID] [int] NOT NULL DEFAULT ((0)),
    [FtsAppID] [int] NOT NULL DEFAULT ((0)),
    [IdxWords_SumCt] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_Uri] PRIMARY KEY CLUSTERED
(
    [FileID] ASC
))
GO
-- v3.1.1 aparently never needed
--CREATE NONCLUSTERED INDEX [FtsAppID] ON [dbo].[Uri]
--(
--    [FtsAppID] ASC
--)
CREATE NONCLUSTERED INDEX [IDX_Uri_PathFile] ON [dbo].[Uri]
(
    [PathID] ASC
)
GO
-- v3.1.1 missing index
CREATE NONCLUSTERED INDEX [IDX_Uri_ExtID] ON [dbo].[Uri]
(
    [ExtID] ASC
)
INCLUDE ([FileID])
GO

CREATE TABLE [dbo].[Extension](
    [ExtID] [int] IDENTITY(1,1) NOT NULL,
    [ExtText] [nvarchar](19) NOT NULL,
    [NoSearch] [bit] NOT NULL DEFAULT ((0)),
    [FtsAppID] [int] NOT NULL DEFAULT ((0)),
    [FtsMaxSizeKb] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_Extension] PRIMARY KEY CLUSTERED
(
    [ExtID] ASC
))
GO
CREATE UNIQUE NONCLUSTERED INDEX [UDX_Extension_ExtText] ON [dbo].[Extension]
(
    [ExtText] ASC
)
GO
CREATE NONCLUSTERED INDEX [IDX_Extension_FtsAppID] ON [dbo].[Extension]
(
    [FtsAppID] ASC
)
GO
CREATE NONCLUSTERED INDEX [IDX_Extension_MaxFtsSizeKb] ON [dbo].[Extension]
(
    [FtsMaxSizeKb] ASC
)
GO

CREATE TABLE [dbo].[FileIndex](
    [FileID] [int] NOT NULL DEFAULT ((0)),
    [IdxMd] [datetime] NOT NULL,
-- opt 3.1.1    [IdxCr] [datetime] NOT NULL,
    [IdxRead_FileIoDur] [int] NOT NULL DEFAULT ((0)),
-- opt 3.1.1    [IdxRead_DbIoDur] [int] NOT NULL DEFAULT ((0)),
    [IdxWrite_DbIoDur] [int] NOT NULL DEFAULT ((0)),
    [IdxRead_FileIo] [int] NOT NULL DEFAULT ((0)),
    [IdxRead_DbIo] [int] NOT NULL DEFAULT ((0)),
    [IdxWrite_DbIo] [int] NOT NULL DEFAULT ((0)),
-- opt 3.1.1    [Idx_FileIo] [bit] NOT NULL DEFAULT ((0)),
-- opt 3.1.1    [Idx_DbIo] [bit] NOT NULL DEFAULT ((0)),
    [IdxWords_Distinct] [int] NOT NULL DEFAULT ((0)),
-- opt 3.1.1    [IdxWords_SumCt] [int] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_FileIndex] PRIMARY KEY CLUSTERED
(
    [FileID] ASC
))
GO

CREATE TABLE [dbo].[FtsWordCount](
    [WordID] [int] NOT NULL DEFAULT ((0)),
    [FileID] [int] NOT NULL DEFAULT ((0)),
    [UseCt] [smallint] NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_FtsWordCount] PRIMARY KEY CLUSTERED
(
    [WordID] ASC,
    [FileID] ASC
))
GO
CREATE NONCLUSTERED INDEX [IDX_FtsWordCount_FileID] ON [dbo].[FtsWordCount]
(
    [FileID] ASC
)
GO
-- v3.1.1 unused b/c this overlaps with the PK
--CREATE NONCLUSTERED INDEX [WordID] ON [dbo].[FtsWordCount]
--(
--    [WordID] ASC
--)

/************************************************************************************************************
                                        CREATE Foreign Keys
************************************************************************************************************/
ALTER TABLE [dbo].[DomainExt]  WITH CHECK ADD  CONSTRAINT [DomainExt_FK00] FOREIGN KEY([ExtID])
REFERENCES [dbo].[Extension] ([ExtID])
GO
ALTER TABLE [dbo].[DomainExt] CHECK CONSTRAINT [DomainExt_FK00]
GO

ALTER TABLE [dbo].[ErrorLog]  WITH CHECK ADD  CONSTRAINT [ErrorLog_FK00] FOREIGN KEY([ErrorTypeID])
REFERENCES [dbo].[ErrorType] ([ErrorTypeID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ErrorLog] CHECK CONSTRAINT [ErrorLog_FK00]
GO

ALTER TABLE [dbo].[Extension]  WITH CHECK ADD  CONSTRAINT [Extension_FK00] FOREIGN KEY([FtsAppID])
REFERENCES [dbo].[FtsApp] ([FtsAppID])
GO
ALTER TABLE [dbo].[Extension] CHECK CONSTRAINT [Extension_FK00]
GO

ALTER TABLE [dbo].[FileIndex]  WITH CHECK ADD  CONSTRAINT [FileIndex_FK00] FOREIGN KEY([FileID])
REFERENCES [dbo].[Uri] ([FileID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FileIndex] CHECK CONSTRAINT [FileIndex_FK00]
GO

ALTER TABLE [dbo].[FtsExt]  WITH CHECK ADD  CONSTRAINT [FtsExt_FK00] FOREIGN KEY([ExtID])
REFERENCES [dbo].[Extension] ([ExtID])
GO
ALTER TABLE [dbo].[FtsExt] CHECK CONSTRAINT [FtsExt_FK00]
GO

ALTER TABLE [dbo].[FtsWordCount]  WITH CHECK ADD  CONSTRAINT [FtsWordCount_FK00] FOREIGN KEY([WordID])
REFERENCES [dbo].[FtsWord] ([WordID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FtsWordCount] CHECK CONSTRAINT [FtsWordCount_FK00]
GO

ALTER TABLE [dbo].[FtsWordCount]  WITH CHECK ADD  CONSTRAINT [FtsWordCount_FK01] FOREIGN KEY([FileID])
REFERENCES [dbo].[Uri] ([FileID])
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[FtsWordCount] CHECK CONSTRAINT [FtsWordCount_FK01]
GO

ALTER TABLE [dbo].[Uri]  WITH CHECK ADD  CONSTRAINT [Uri_FK00] FOREIGN KEY([ExtID])
REFERENCES [dbo].[Extension] ([ExtID])
GO
ALTER TABLE [dbo].[Uri] CHECK CONSTRAINT [Uri_FK00]
GO

ALTER TABLE [dbo].[Uri]  WITH CHECK ADD  CONSTRAINT [Uri_FK01] FOREIGN KEY([FtsAppID])
REFERENCES [dbo].[FtsApp] ([FtsAppID])
GO
ALTER TABLE [dbo].[Uri] CHECK CONSTRAINT [Uri_FK01]
GO

ALTER TABLE [dbo].[Uri]  WITH CHECK ADD  CONSTRAINT [Uri_FK02] FOREIGN KEY([PathID])
REFERENCES [dbo].[Path] ([PathID])
GO
ALTER TABLE [dbo].[Uri] CHECK CONSTRAINT [Uri_FK02]
GO

/*
 Object:        usp_DefragIndex
 Overview:        Defragment SQL 2005 indexes
 Based on:        http://weblogs.sqlteam.com/tarad/archive/2007/03/07/60130.aspx
 Depends on:   sys.dm_db_index_physical_stats,
                sys.objects,
                sys.schemas,
                sys.indexes,
                sys.partitions
 Test
    EXEC usp_DefragIndex
 drop proc usp_DefragIndex
*/
CREATE PROC dbo.usp_DefragIndex
(
    @statsMode      varchar(8)  = 'SAMPLED', /* mode to use for sys.dm_db_index_physical_stats (SAMPLED or DETAILED) */
    @defragType     varchar(10) = 'REBUILD', /* REORGANIZE (INDEXDEFRAG) or REBUILD (DBREINDEX) */
    @minFragPercent int         = 25,         /* min fragmentation level */
    @minRowCount    int            = 0             /* minimum row count */
)
AS
BEGIN
    SET NOCOUNT ON

    DECLARE @dbName sysname
    SELECT  @dbName = DB_NAME()

    DECLARE
        @i int, @objectId int, @objectName sysname, @indexId int, @indexName sysname,
        @schemaName sysname, @partitionNumber int, @partitionCount int, @recordCount bigint,
        @sql nvarchar(4000), @edition int, @parmDef nvarchar(500)

    SELECT @i = 1, @edition = CONVERT(int, SERVERPROPERTY('EngineEdition'))

    SELECT
        IDENTITY(int, 1, 1) AS FragIndexId,
        [object_id] AS ObjectId,
        index_id AS IndexId,
        avg_fragmentation_in_percent AS FragPercent,
        record_count AS RecordCount,
        partition_number AS PartitionNumber
    INTO #FragIndex
    FROM sys.dm_db_index_physical_stats (DB_ID(@dbName), NULL, NULL, NULL, @statsMode)
    WHERE
        avg_fragmentation_in_percent > @minFragPercent AND
        index_id > 0 AND
        record_count > @minRowCount
    ORDER BY ObjectId

    SELECT
        @objectId = ObjectId,
        @indexId = IndexId,
        @recordCount = RecordCount
    FROM #FragIndex
    WHERE FragIndexId = @i

    WHILE @@ROWCOUNT <> 0
    BEGIN
        SET @sql = '
            SELECT @objectName = o.[name], @schemaName = s.[name]
            FROM [' + @dbName + '].sys.objects o
            JOIN [' + @dbName + '].sys.schemas s
            ON s.schema_id = o.schema_id
            WHERE o.[object_id] = @objectId'

        SET @parmDef = N'@objectId int, @objectName sysname OUTPUT, @schemaName sysname OUTPUT'

        --PRINT('@sql1='+@sql)
        EXEC sp_executesql
            @sql, @parmDef, @objectId = @objectId,
            @objectName = @objectName OUTPUT, @schemaName = @schemaName OUTPUT
        SET @sql = '
            SELECT @indexName = [name]
            FROM [' + @dbName + '].sys.indexes
            WHERE [object_id] = @objectId AND index_id = @indexId AND is_disabled = 0'

        SET @parmDef = N'@objectId int, @indexId int, @indexName sysname OUTPUT'

        --PRINT('@sql2='+@sql)
        EXEC sp_executesql
            @sql, @parmDef, @objectId = @objectId, @indexId = @indexId,
            @indexName = @indexName OUTPUT

        SET @sql = '
            SELECT @partitionCount = COUNT(*)
            FROM [' + @dbName + '].sys.partitions
            WHERE [object_id] = @objectId AND index_id = @indexId'

        SET @parmDef = N'@objectId int, @indexId int, @partitionCount int OUTPUT'

        --PRINT('@sql3='+@sql)
        EXEC sp_executesql
            @sql, @parmDef, @objectId = @objectId, @indexId = @indexId,
            @partitionCount = @partitionCount OUTPUT

        SET @sql = 'ALTER INDEX [' + @indexName + '] ON [' + @dbName + '].[' +
            @schemaName + '].[' + @objectName + '] ' + @defragType

        /* Developer and Enterprise have the ONLINE = ON option for REBUILD */
        IF @defragType = 'REBUILD'
        BEGIN
            SET @sql = @sql + ' WITH (FILLFACTOR=80'
            IF (@edition = 3)
                SET @sql = @sql + ', ONLINE = ON'
            SET @sql = @sql + ')'
        END

        IF @partitionCount > 1
            SET @sql = @sql + ' PARTITION = ' + CAST(@partitionNumber AS varchar(10))

        PRINT(@sql)
        EXEC (@SQL)

        SET @i = @i + 1

        SELECT
            @objectId = ObjectId,
            @indexId = IndexId,
            @recordCount = RecordCount
        FROM #FragIndex
        WHERE FragIndexId = @i
    END

    DROP TABLE #FragIndex
END
GO

-- v3.1.1 fix: so we don't get this error:
-- The query has exceeded the maximum number of result sets that can be displayed in the Execution Plan pane. Only the first 250 result sets are displayed in the Execution Plan pane.
SET NOCOUNT ON

INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(0,
'None',
'No Text Indexing')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(100,
'Text',
'Text Index the filename and path, plus content of a typical text file')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(200,
'Adobe: Acrobat',
'Text Index the filename and path, plus content using Adobe Acrobat Full (Sorry: not compatible with Adobe Acrobat Reader)')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(300,
'Microsoft: Excel',
'Text Index the filename and path, plus content using Microsoft Excel')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(301,
'Microsoft: PowerPoint',
'Text Index the filename and path, plus content using Microsoft PowerPoint')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(302,
'Microsoft: Word',
'Text Index the filename and path, plus content using Microsoft Word')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(400,
'Binary: Executable',
'Text Index the filename and path, plus Executable content of a binary file (Experimental)')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(401,
'Binary: Document',
'Text Index the filename and path, plus Document content of a binary file (Experimental)')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(500,
'Media',
'Text Index the filename and path')
GO
INSERT INTO [FtsApp] ([FtsAppID],
[FtsAppDesc],
[FtsAppOverview])
VALUES(700,
'iFilter',
'Text Index the filename and path, plus content using the Microsoft iFilter')
GO


SET IDENTITY_INSERT [Extension] ON
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(1,
'.doc',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(2,
'.dot',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(3,
'.wpd',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(4,
'.csv',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(5,
'.xls',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(6,
'.txt',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(7,
'.xlt',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(8,
'.html',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(9,
'.htm',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(10,
'.pdf',
0,
200,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(11,
'.mp3',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(12,
'.wma',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(13,
'.jpg',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(14,
'.jpeg',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(15,
'.jpe',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(16,
'.bmp',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(17,
'.tif',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(18,
'.tiff',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(19,
'.asf',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(20,
'.asx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(132,
'.avi',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(133,
'.mov',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(134,
'.mpg',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(135,
'.mpeg',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(136,
'.ram',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(137,
'.rm',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(138,
'.qt',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(139,
'.wmv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(140,
'.ico',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(141,
'.ini',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(142,
'.dsw',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(143,
'.dsp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(144,
'.mdb',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(145,
'.mde',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(146,
'.manifest',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(147,
'.rc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(148,
'.rc2',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(149,
'.sln',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(150,
'.xml',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(151,
'.c',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(152,
'.cpp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(153,
'.h',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(154,
'.hpp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(155,
'.hxx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(156,
'.nsi',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(157,
'.aps',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(158,
'.clw',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(159,
'.exp',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(160,
'.idb',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(161,
'.ilk',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(162,
'.map',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(163,
'.ncb',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(164,
'.obj',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(165,
'.opt',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(166,
'.pcc',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(167,
'.pch',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(168,
'.pdb',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(169,
'.plg',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(170,
'.res',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(171,
'.scc',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(172,
'.tlb',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(173,
'.tlh',
1,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(174,
'.tli',
1,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(175,
'.asm',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(176,
'.cxx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(177,
'.cc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(178,
'.hh',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(179,
'.inl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(180,
'.idl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(181,
'.resx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(182,
'',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(183,
'.chk',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(184,
'.tmp',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(185,
'.zip',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(186,
'.temp',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(187,
'.inc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(188,
'.mak',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(189,
'.mk',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(190,
'.dib',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(191,
'.gif',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(192,
'.emf',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(193,
'.wmf',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(194,
'.lnk',
1,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(195,
'.pps',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(196,
'.ppt',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(197,
'.pot',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(198,
'.cs',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(199,
'.inf',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(201,
'.mqv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(202,
'.fli',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(203,
'.fle',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(204,
'.dv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(205,
'.dif',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(206,
'.aac',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(207,
'.mp4',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(208,
'.au',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(209,
'.cdda',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(210,
'.ulw',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(211,
'.qcp',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(212,
'.sd2',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(213,
'.gsm',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(214,
'.amr',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(215,
'.adts',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(216,
'.caf',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(217,
'.m4v',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(218,
'.sdv',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(219,
'.3g2',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(220,
'.pkg',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(221,
'.aa',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(222,
'.acp',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(223,
'.ans',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(224,
'.asp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(225,
'.aspx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(226,
'.asmx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(227,
'.java',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(228,
'.cda',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(229,
'.cgm',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(230,
'.jfif',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(231,
'.m1v',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(232,
'.m2v',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(233,
'.m3u',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(234,
'.m4a',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(235,
'.m4b',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(236,
'.m4e',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(237,
'.m4p',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(238,
'.mka',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(239,
'.mkv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(240,
'.mp2',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(241,
'.mp2v',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(242,
'.mpa',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(243,
'.mpe',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(244,
'.mpga',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(245,
'.mpv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(246,
'.mpv2',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(247,
'.ogg',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(248,
'.ogm',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(249,
'.pas',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(250,
'.pct',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(251,
'.pcx',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(252,
'.pic',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(253,
'.pict',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(254,
'.pls',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(255,
'.png',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(256,
'.pnt',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(257,
'.pntg',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(258,
'.psd',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(259,
'.ra',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(260,
'.rar',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(261,
'.cab',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(262,
'.arj',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(263,
'.lzh',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(264,
'.ace',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(265,
'.7z',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(266,
'.tar',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(267,
'.gz',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(268,
'.uu',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(269,
'.uue',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(270,
'.xxe',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(271,
'.z',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(272,
'.tgz',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(273,
'.tbz2',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(274,
'.tbz',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(275,
'.taz',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(276,
'.jar',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(277,
'.iso',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(278,
'.bz',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(279,
'.bz2',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(280,
'.r01',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(281,
'.r02',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(282,
'.r03',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(283,
'.r04',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(284,
'.r05',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(285,
'.r06',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(286,
'.r07',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(287,
'.r08',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(288,
'.r09',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(289,
'.r10',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(290,
'.r11',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(291,
'.r12',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(292,
'.r13',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(293,
'.r14',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(294,
'.r15',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(295,
'.r16',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(296,
'.r17',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(297,
'.r18',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(298,
'.r19',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(299,
'.r20',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(300,
'.r21',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(301,
'.r22',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(302,
'.r23',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(303,
'.r24',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(304,
'.r25',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(305,
'.r26',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(306,
'.r27',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(307,
'.r28',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(308,
'.r29',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(309,
'.rv',
0,
500,
-1)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(310,
'.xsl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(311,
'.xslt',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(312,
'.mpcpl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(313,
'.wmx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(315,
'.xpl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(316,
'.wpl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(318,
'.vcproj',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(319,
'.adb',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(320,
'.ads',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(321,
'.ada',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(322,
'.ora',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(323,
'.sql',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(324,
'.pco',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(325,
'.cob',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(326,
'.pad',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(327,
'.pfo',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(328,
'.for',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(329,
'.pc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(330,
'.ppl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(331,
'.pl1',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(332,
'.ppa',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(334,
'.fun',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(335,
'.pkb',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(336,
'.pks',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(337,
'.prc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(338,
'.xsd',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(340,
'.conf',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(341,
'.config',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(342,
'.xmlp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(343,
'.def',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(344,
'.properties',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(345,
'.oraconfig',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(346,
'.orc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(347,
'.asc',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(348,
'.bas',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(349,
'.csa',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(350,
'.faq',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(351,
'.jsl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(352,
'.url',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(356,
'.plb',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(357,
'.sp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(358,
'.spp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(359,
'.sf',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(360,
'.sam',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(361,
'.sample',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(362,
'.wri',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(363,
'.rtf',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(364,
'.xlw',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(365,
'.xla',
0,
700,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(366,
'.par',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(367,
'.reg',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(368,
'.lst',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(369,
'.bat',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(370,
'.cgi',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(371,
'.css',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(372,
'.udl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(373,
'.log',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(374,
'.out',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(375,
'.vb',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(376,
'.vba',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(377,
'.vbd',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(378,
'.vbe',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(379,
'.vbg',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(380,
'.vbp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(381,
'.vbs',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(382,
'.vbw',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(383,
'.jav',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(384,
'.js',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(385,
'.jsp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(386,
'.pl',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(387,
'.awk',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(388,
'.l',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(389,
'.ll',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(390,
'.y',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(391,
'.bcp',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(392,
'.cmd',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(393,
'.nws',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(394,
'.cls',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(395,
'.dic',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(396,
'.lic',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(397,
'.sh',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(398,
'.spb',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(399,
'.sps',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(400,
'.vmsd',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(401,
'.in',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(402,
'.vmx',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(404,
'.dat',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(405,
'.mht',
0,
100,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(406,
'.img',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(407,
'.exe',
0,
400,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(408,
'.ocx',
0,
400,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(409,
'.dll',
0,
400,
8192)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(411,
'.mdf',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(412,
'.ldf',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(413,
'.bak',
0,
0,
0)
GO
INSERT INTO [Extension] ([ExtID],
[ExtText],
[NoSearch],
[FtsAppID],
[FtsMaxSizeKb])
VALUES(414,
'.frm',
0,
100,
0)
GO
SET IDENTITY_INSERT [Extension] OFF
GO


SET IDENTITY_INSERT [DomainGroup] ON
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(1,
'Microsoft Word',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(2,
'Media: Audio',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(3,
'Media: Photo',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(4,
'Media: Video',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(5,
'Development: C/C++/Cno',
0)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(6,
'Development: Resource',
0)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(7,
'Microsoft PowerPoint',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(8,
'Microsoft Excel',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(9,
'Adobe Acrobat',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(11,
'Archive',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(12,
'Oracle',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(13,
'Microsoft SQL Server',
1)
GO
INSERT INTO [DomainGroup] ([DgID],
[Grp],
[Inc])
VALUES(14,
'Development: Temp',
0)
GO
SET IDENTITY_INSERT [DomainGroup] OFF
GO

INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(1,
1)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(1,
2)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
11)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
12)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
206)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
207)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
208)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
209)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
210)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
211)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
212)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
213)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
214)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
215)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
216)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
221)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
222)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
228)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
233)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
234)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
235)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
237)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
238)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(2,
244)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
13)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
14)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
15)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
16)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
17)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
18)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
190)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
191)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
192)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
193)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
229)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
230)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
250)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
251)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
252)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
253)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
254)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
256)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
257)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
258)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(3,
259)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
19)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
20)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
132)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
133)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
134)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
135)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
136)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
137)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
138)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
139)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
201)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
202)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
203)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
204)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
205)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
217)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
218)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
219)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
231)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
232)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
236)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
237)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
239)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
240)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
241)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
242)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
243)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
245)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
246)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
247)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
248)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(4,
309)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
151)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
152)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
153)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
154)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
155)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
156)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
175)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
176)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
177)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
178)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
179)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
187)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
188)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(5,
189)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
13)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
16)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
140)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
141)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
142)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
143)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
144)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
145)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
146)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
147)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
148)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
149)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
150)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(6,
181)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(7,
195)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(7,
196)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(7,
197)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(8,
5)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(8,
7)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(9,
10)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
185)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
260)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
261)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
262)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
263)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
264)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
265)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
266)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
267)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
268)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
269)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
270)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
271)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
272)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
273)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
274)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
275)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
276)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
277)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
278)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
279)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
280)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
281)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
282)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
283)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
284)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
285)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
286)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
287)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
288)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
289)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
290)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
291)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
292)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
293)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
294)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
295)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
296)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
297)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
298)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
299)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
300)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
301)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
302)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
303)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
304)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
305)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
306)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
307)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
308)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(11,
406)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
6)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
220)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
254)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
322)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
323)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
334)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
335)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
336)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
337)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
357)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(12,
358)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(13,
411)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(13,
412)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(13,
413)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
157)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
158)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
159)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
160)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
161)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
162)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
163)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
164)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
165)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
166)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
167)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
168)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
169)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
170)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
171)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
172)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
173)
GO
INSERT INTO [DomainExt] ([DgID],
[ExtID])
VALUES(14,
174)
GO









INSERT INTO [IndexInfo] ([CreatedDate],
[ModifiedDate],
[Status],
[IndexedCountNow],
[DbVersion],
[LastStatsCalculate],
[LastIndexChange],
[LastIndexClean])
VALUES('',
'',
'',
0,
13,
'1/1/2008',
'1/2/2008',
'1/1/2008')
GO





INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1,
'1')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(2,
'148')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(3,
'2048')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(4,
'1')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(6,
'1')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(9,
'1')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(10,
'1')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(11,
'0')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1000,
'0')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1001,
'0')
GO

INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1003,
'0')
GO

INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1005,
'0')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1006,
'0')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1007,
'0')
GO
INSERT INTO [SysSetting] ([SettingID],
[Value])
VALUES(1008,
'0')
GO

SET NOCOUNT OFF