webspider.sql

基于com的网络爬虫程序

/****** Object:  Database WebSpider    Script Date: 02.02.2005 20:25:52 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'WebSpider')
	DROP DATABASE [WebSpider]
GO

CREATE DATABASE [WebSpider]  ON (NAME = N'WebSpider_Data', FILENAME = N'j:\Program Files\Microsoft SQL Server\MSSQL\data\WebSpider_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'WebSpider_Log', FILENAME = N'j:\Program Files\Microsoft SQL Server\MSSQL\data\WebSpider_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
GO

exec sp_dboption N'WebSpider', N'autoclose', N'false'
GO

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

exec sp_dboption N'WebSpider', N'trunc. log', N'false'
GO

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

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

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

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

exec sp_dboption N'WebSpider', N'autoshrink', N'false'
GO

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

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

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

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

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

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

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

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

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

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

use [WebSpider]
GO

/****** Object:  Trigger dbo.tri_ExportToSibscribe    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tri_ExportToSibscribe]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[tri_ExportToSibscribe]
GO

/****** Object:  Trigger dbo.tri_ClearOldSources    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[tri_ClearOldSources]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[tri_ClearOldSources]
GO

/****** Object:  Stored Procedure dbo.mp_ClearAll    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_ClearAll]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_ClearAll]
GO

/****** Object:  Stored Procedure dbo.mp_DeleteURL_1    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_DeleteURL_1]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_DeleteURL_1]
GO

/****** Object:  Stored Procedure dbo.mp_DeleteURL_2    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_DeleteURL_2]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_DeleteURL_2]
GO

/****** Object:  Stored Procedure dbo.mp_GetLinksExcepts    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetLinksExcepts]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetLinksExcepts]
GO

/****** Object:  Stored Procedure dbo.mp_GetLinksRegExps    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetLinksRegExps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetLinksRegExps]
GO

/****** Object:  Stored Procedure dbo.mp_GetNotParsedSources    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetNotParsedSources]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetNotParsedSources]
GO

/****** Object:  Stored Procedure dbo.mp_GetNotSearchedSources    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetNotSearchedSources]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetNotSearchedSources]
GO

/****** Object:  Stored Procedure dbo.mp_GetNotTreatedURLs    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetNotTreatedURLs]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetNotTreatedURLs]
GO

/****** Object:  Stored Procedure dbo.mp_GetOption    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetOption]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetOption]
GO

/****** Object:  Stored Procedure dbo.mp_GetSearchExcepts    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetSearchExcepts]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetSearchExcepts]
GO

/****** Object:  Stored Procedure dbo.mp_GetSearchRegExps    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetSearchRegExps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetSearchRegExps]
GO

/****** Object:  Stored Procedure dbo.mp_GetStatisticsByURL    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_GetStatisticsByURL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_GetStatisticsByURL]
GO

/****** Object:  Stored Procedure dbo.mp_InsertExceptionLinkRegExp    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_InsertExceptionLinkRegExp]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_InsertExceptionLinkRegExp]
GO

/****** Object:  Stored Procedure dbo.mp_InsertExceptionSearchRegExp    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_InsertExceptionSearchRegExp]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_InsertExceptionSearchRegExp]
GO

/****** Object:  Stored Procedure dbo.mp_InsertSearchResult    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_InsertSearchResult]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_InsertSearchResult]
GO

/****** Object:  Stored Procedure dbo.mp_InsertSource    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_InsertSource]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_InsertSource]
GO

/****** Object:  Stored Procedure dbo.mp_InsertURL    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_InsertURL]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_InsertURL]
GO

/****** Object:  Stored Procedure dbo.mp_IsExistsURLs    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_IsExistsURLs]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_IsExistsURLs]
GO

/****** Object:  Stored Procedure dbo.mp_MarkAsParsed    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_MarkAsParsed]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_MarkAsParsed]
GO

/****** Object:  Stored Procedure dbo.mp_MarkAsSearched    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_MarkAsSearched]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_MarkAsSearched]
GO

/****** Object:  Stored Procedure dbo.mp_MarkAsTreated    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_MarkAsTreated]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_MarkAsTreated]
GO

/****** Object:  Stored Procedure dbo.mp_SetOption    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mp_SetOption]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mp_SetOption]
GO

/****** Object:  Table [dbo].[Configuration]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Configuration]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Configuration]
GO

/****** Object:  Table [dbo].[ExceptionLinksRegExps]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExceptionLinksRegExps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExceptionLinksRegExps]
GO

/****** Object:  Table [dbo].[ExceptionSearchRegExps]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ExceptionSearchRegExps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[ExceptionSearchRegExps]
GO

/****** Object:  Table [dbo].[LinksExceptionsRelations]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LinksExceptionsRelations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LinksExceptionsRelations]
GO

/****** Object:  Table [dbo].[LinksRegExps]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[LinksRegExps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[LinksRegExps]
GO

/****** Object:  Table [dbo].[SearchExceptionsRelations]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SearchExceptionsRelations]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SearchExceptionsRelations]
GO

/****** Object:  Table [dbo].[SearchRegExps]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SearchRegExps]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SearchRegExps]
GO

/****** Object:  Table [dbo].[SearchResults]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SearchResults]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[SearchResults]
GO

/****** Object:  Table [dbo].[Sources]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Sources]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Sources]
GO

/****** Object:  Table [dbo].[URLs]    Script Date: 02.02.2005 20:26:24 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[URLs]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[URLs]
GO

/****** Object:  Table [dbo].[Configuration]    Script Date: 02.02.2005 20:26:31 ******/
CREATE TABLE [dbo].[Configuration] (
	[sName] [varchar] (512) NOT NULL ,
	[sValue] [varchar] (8000) NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[ExceptionLinksRegExps]    Script Date: 02.02.2005 20:26:35 ******/
CREATE TABLE [dbo].[ExceptionLinksRegExps] (
	[nId] [int] IDENTITY (1, 1) NOT NULL ,
	[sRegExp] [varchar] (8000) NOT NULL ,
	[bExcept] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[ExceptionSearchRegExps]    Script Date: 02.02.2005 20:26:36 ******/
CREATE TABLE [dbo].[ExceptionSearchRegExps] (
	[nId] [int] IDENTITY (1, 1) NOT NULL ,
	[sRegExp] [varchar] (8000) NOT NULL ,
	[bExcept] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LinksExceptionsRelations]    Script Date: 02.02.2005 20:26:37 ******/
CREATE TABLE [dbo].[LinksExceptionsRelations] (
	[nExceptId] [int] NOT NULL ,
	[nURLId] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[LinksRegExps]    Script Date: 02.02.2005 20:26:38 ******/
CREATE TABLE [dbo].[LinksRegExps] (
	[nId] [int] IDENTITY (1, 1) NOT NULL ,
	[sRegExp] [varchar] (8000) NOT NULL ,
	[nType] [int] NOT NULL ,
	[nSubMutchIndex] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[SearchExceptionsRelations]    Script Date: 02.02.2005 20:26:39 ******/
CREATE TABLE [dbo].[SearchExceptionsRelations] (
	[nExceptId] [int] NOT NULL ,
	[nURLId] [int] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[SearchRegExps]    Script Date: 02.02.2005 20:26:40 ******/
CREATE TABLE [dbo].[SearchRegExps] (
	[nId] [int] IDENTITY (1, 1) NOT NULL ,
	[sRegExp] [varchar] (8000) NOT NULL ,
	[nSubMutchIndex] [int] NOT NULL ,
	[bIgnoreCase] [bit] NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[SearchResults]    Script Date: 02.02.2005 20:26:41 ******/
CREATE TABLE [dbo].[SearchResults] (
	[nRegExpId] [int] NOT NULL ,
	[nURLId] [int] NOT NULL ,
	[sResult] [varchar] (8000) NOT NULL 
) ON [PRIMARY]
GO

/****** Object:  Table [dbo].[Sources]    Script Date: 02.02.2005 20:26:41 ******/
CREATE TABLE [dbo].[Sources] (
	[nId] [int] NOT NULL ,
	[sResult] [text] NULL ,
	[bParsed] [bit] NOT NULL ,
	[nTime] [int] NULL ,
	[bSearched] [bit] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/****** Object:  Table [dbo].[URLs]    Script Date: 02.02.2005 20:26:42 ******/
CREATE TABLE [dbo].[URLs] (
	[nId] [int] IDENTITY (1, 1) NOT NULL ,
	[sURL] [varchar] (900) NOT NULL ,
	[bTreated] [bit] NOT NULL ,
	[nTime] [int] NULL ,
	[nRegExpType] [int] NULL ,
	[nDownloadTime] [int] NULL ,
	[nParentURLId] [int] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[Configuration] WITH NOCHECK ADD 
	CONSTRAINT [PK_Configuration] PRIMARY KEY  CLUSTERED 
	(
		[sName]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ExceptionLinksRegExps] WITH NOCHECK ADD 
	CONSTRAINT [PK_ExceptionLinksRegExps] PRIMARY KEY  CLUSTERED 
	(
		[nId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[ExceptionSearchRegExps] WITH NOCHECK ADD 
	CONSTRAINT [PK_ExceptionResultsRegExps] PRIMARY KEY  CLUSTERED 
	(
		[nId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[LinksRegExps] WITH NOCHECK ADD 
	CONSTRAINT [PK_LinksRegExps] PRIMARY KEY  CLUSTERED 
	(
		[nId]
	)  ON [PRIMARY] 
GO

ALTER TABLE [dbo].[SearchRegExps] WITH NOCHECK ADD 
	CONSTRAINT [PK_SearchRegExps] PRIMARY KEY  CLUSTERED 
	(
		[nId]
	)  ON [PRIMARY] 
GO

 CREATE  UNIQUE  CLUSTERED  INDEX [IX_URLs] ON [dbo].[URLs]([sURL]) ON [PRIMARY]
GO

ALTER TABLE [dbo].[ExceptionLinksRegExps] WITH NOCHECK ADD 
	CONSTRAINT [DF_ExceptionLinksRegExps_bExcept] DEFAULT (1) FOR [bExcept]
GO

ALTER TABLE [dbo].[ExceptionSearchRegExps] WITH NOCHECK ADD 
	CONSTRAINT [DF_ExceptionResultsRegExps_bExcept] DEFAULT (1) FOR [bExcept]
GO

ALTER TABLE [dbo].[LinksRegExps] WITH NOCHECK ADD 
	CONSTRAINT [DF_LinksRegExps_nType] DEFAULT (0) FOR [nType],
	CONSTRAINT [DF_LinksRegExps_nSubMutchIndex] DEFAULT (0) FOR [nSubMutchIndex]
GO

ALTER TABLE [dbo].[SearchRegExps] WITH NOCHECK ADD 
	CONSTRAINT [DF_SearchRegExps_nSubMuchIndex] DEFAULT (0) FOR [nSubMutchIndex],
	CONSTRAINT [DF_SearchRegExps_bIgnoreCase] DEFAULT (1) FOR [bIgnoreCase]
GO

ALTER TABLE [dbo].[Sources] WITH NOCHECK ADD 
	CONSTRAINT [DF_TreatedURLs_bParsed] DEFAULT (0) FOR [bParsed],
	CONSTRAINT [DF_Sources_bSearched] DEFAULT (0) FOR [bSearched]
GO

ALTER TABLE [dbo].[URLs] WITH NOCHECK ADD 
	CONSTRAINT [DF_NotTreatedURLs_bTreating] DEFAULT (0) FOR [bTreated],
	CONSTRAINT [PK_URLs] PRIMARY KEY  NONCLUSTERED 
	(
		[nId]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.mp_ClearAll    Script Date: 02.02.2005 20:26:43 ******/
CREATE PROCEDURE mp_ClearAll
AS
DELETE FROM Sources
DELETE FROM URLs
DELETE FROM Sources
DELETE FROM URLs
DELETE FROM SearchResults
DELETE FROM SearchExceptionsRelations
DELETE FROM LinksExceptionsRelations
DELETE FROM ExceptionLinksRegExps
DELETE FROM ExceptionSearchRegExps

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.mp_DeleteURL_1    Script Date: 02.02.2005 20:26:43 ******/
CREATE PROCEDURE mp_DeleteURL_1
			(
			@sURL VARCHAR(1024)
			)
AS
IF EXISTS( SELECT * FROM URLs WHERE sURL=@sURL )
BEGIN
	DECLARE @nId INT;
	SELECT @nId=nId FROM URLs WHERE sURL=@sURL
	DECLARE @nExceptId INT;
	SELECT @nExceptId = nExceptId FROM LinksExceptionsRelations WHERE nURLId=@nId;
	DELETE FROM URLs WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId AND NOT nURLId=@nId);
	UPDATE URLs SET bTreated=1 WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId );
	DELETE FROM Sources WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId AND NOT nURLId=@nId);
END

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

/****** Object:  Stored Procedure dbo.mp_DeleteURL_2    Script Date: 02.02.2005 20:26:43 ******/
CREATE PROCEDURE mp_DeleteURL_2
			(
			@sURL VARCHAR(1024)
			)
AS
IF EXISTS( SELECT * FROM URLs WHERE sURL=@sURL )
BEGIN
	DECLARE @nId INT;
	SELECT @nId=nId FROM URLs WHERE sURL=@sURL
	DECLARE @nExceptId INT;
	SELECT @nExceptId = nExceptId FROM LinksExceptionsRelations WHERE nURLId=@nId;
	DELETE FROM URLs WHERE sURL=@sURL;
	DELETE FROM URLs WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId );
	UPDATE URLs SET bTreated=1 WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId );
	DELETE FROM Sources WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId );
	DELETE FROM URLs WHERE nId IN ( SELECT nURLId FROM  LinksExceptionsRelations WHERE @nExceptId = nExceptId );
	DELETE FROM ExceptionSearchRegExps WHERE nId IN ( SELECT nExceptId FROM SearchExceptionsRelations WHERE nURLId=@nId )
	DELETE FROM ExceptionLinksRegExps WHERE nId IN ( SELECT nExceptId FROM LinksExceptionsRelations WHERE nURLId=@nId )
	DELETE FROM SearchExceptionsRelations WHERE nURLId=@nId 
	DELETE FROM LinksExceptionsRelations WHERE nURLId=@nId 
END

GO

SET QUOTED_IDENTIFIER OFF 
GO