SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteTopic    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteTopic]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteTopic]
GO

--==========================================================
--==Ŀǰбͬ Topic ϵ FollowUp
--==ɾ Topic ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-01-21
--==========================================================

CREATE TRIGGER TriggerDeleteTopic ON dbo.Topic

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ FollowUp ¼
--========================================================
delete from dbo.FollowUp where TopicID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteForum    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteForum]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteForum]
GO

--==========================================================
--==Ŀǰбͬ Forum ϵ ForumContent, Topic
--==ɾ Forum ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-01-27
--==========================================================

CREATE TRIGGER TriggerDeleteForum ON dbo.Forum

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ ForumContent ¼
--========================================================
delete from dbo.ForumContent where ForumID in (select [ID] from deleted)

--========================================================
--==ɾӦ Topic ¼
--========================================================
delete from dbo.Topic where ForumID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteCommunity    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteCommunity]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteCommunity]
GO

--==========================================================
--==Ŀǰбͬ Community ϵ CommunityContent, Forum
--==ɾ Community ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-01-27
--==========================================================

CREATE TRIGGER TriggerDeleteCommunity ON dbo.Community

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ CommunityContent ¼
--========================================================
delete from dbo.CommunityContent where CommunityID in (select [ID] from deleted)

--========================================================
--==ɾӦ Forum ¼
--========================================================
delete from dbo.Forum where CommunityID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteSubDirectory    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteSubDirectory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteSubDirectory]
GO

--==========================================================
--==Ŀǰбͬ SubDirectory ϵ SubDirectoryContent, PageDirectory
--==ɾ SubDirectory ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-04-20
--==========================================================

CREATE TRIGGER TriggerDeleteSubDirectory ON dbo.SubDirectory

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ SubDirectoryContent ¼
--========================================================
delete from dbo.SubDirectoryContent where SubDirectoryID in (select [ID] from deleted)

--========================================================
--==ɾӦ PageDirectory ¼
--========================================================
delete from dbo.PageDirectory where SubDirectoryID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteKnowledge    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteKnowledge]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteKnowledge]
GO

--==========================================================
--==Ŀǰбͬ Knowledge ϵ KnowledgeContent
--==ɾ Knowledge ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-04-20
--==========================================================

CREATE TRIGGER TriggerDeleteKnowledge ON dbo.Knowledge

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ KnowledgeContent ¼
--========================================================
delete from dbo.KnowledgeContent where KnowledgeID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteMainDirectory    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteMainDirectory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteMainDirectory]
GO

--==========================================================
--==Ŀǰбͬ MainDirectory ϵ MainDirectoryContent, SubDirectory
--==ɾ MainDirectory ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-04-20
--==========================================================

CREATE TRIGGER TriggerDeleteMainDirectory ON dbo.MainDirectory

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ MainDirectoryContent ¼
--========================================================
delete from dbo.MainDirectoryContent where MainDirectoryID in (select [ID] from deleted)

--========================================================
--==ɾӦ SubDirectory ¼
--========================================================
delete from dbo.SubDirectory where MainDirectoryID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeletePageDirectory    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeletePageDirectory]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeletePageDirectory]
GO

--==========================================================
--==Ŀǰбͬ PageDirectory ϵ PageDirectoryContent, Knowledge
--==ɾ PageDirectory ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2005 
--==޸ 2005-04-20
--==========================================================

CREATE TRIGGER TriggerDeletePageDirectory ON dbo.PageDirectory

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ PageDirectoryContent ¼
--========================================================
delete from dbo.PageDirectoryContent where PageDirectoryID in (select [ID] from deleted)

--========================================================
--==ɾӦ Knowledge ¼
--========================================================
delete from dbo.Knowledge where PageDirectoryID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteResources    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteResources]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteResources]
GO

--==========================================================
--==Ŀǰбͬ Resources ϵ ResourcesTags
--==ɾ Resources ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2009 CMS  www.zhuzhicms.com
--==޸ 2009-04-12
--==========================================================

CREATE TRIGGER TriggerDeleteResources ON dbo.Resources

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ ResourcesTags ¼
--========================================================
delete from dbo.ResourcesTags  where ResourcesID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteUserGroup    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteUserGroup]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteUserGroup]
GO

--==========================================================
--==Ŀǰбͬ UserGroup ϵ UserGroups
--==ɾ UserGroup ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2009 CMS - www.zhuzhicms.com
--==޸ 2009-04-12
--==========================================================

CREATE TRIGGER TriggerDeleteUserGroup ON dbo.UserGroup

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ UserGroups ¼
--========================================================
delete from dbo.UserGroups where UserGroupID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ


GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

/****** Object:  Trigger dbo.TriggerDeleteKnowledgeContent    Script Date: 2009-7-10 19:03:45 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TriggerDeleteKnowledgeContent]') and OBJECTPROPERTY(id, N'IsTrigger') = 1)
drop trigger [dbo].[TriggerDeleteKnowledgeContent]
GO

--==========================================================
--==Ŀǰбͬ KnowledgeContent ϵ KnowledgeComments
--==ɾ KnowledgeContent ¼֮ӱеļ¼ҲӦɾ
--==========================================================
--==Ȩ 2001-2007 
--==޸ 2007-03-19
--==========================================================

CREATE TRIGGER TriggerDeleteKnowledgeContent ON dbo.KnowledgeContent

FOR DELETE 

AS

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

--========================================================
--== Trigger 棬Ӧʼʹ SET NOCOUNT ON
--========================================================
SET NOCOUNT ON 

--========================================================
--==ɾӦ KnowledgeComments ¼
--========================================================
delete from dbo.KnowledgeComments  where KnowledgeContentID in (select [ID] from deleted)

--ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

