|
--USE [pioner]
|
|
|
|
GO
|
|
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[components]') AND type in (N'U'))
|
|
BEGIN
|
|
DELETE FROM dbo.components WHERE name='mdb.ph_history'
|
|
END
|
|
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_UserName]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_UserName]
|
|
END
|
|
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_HostName]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_HostName]
|
|
END
|
|
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_ModifyDate]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_ModifyDate]
|
|
END
|
|
|
|
GO
|
|
|
|
IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[DF_hystory_OP_Code]') AND type = 'D')
|
|
BEGIN
|
|
ALTER TABLE [dbo].[PH_HISTORY] DROP CONSTRAINT [DF_hystory_OP_Code]
|
|
END
|
|
|
|
GO
|
|
|
|
/****** Object: Table [dbo].[PH_HISTORY] Script Date: 09/28/2012 15:06:28 ******/
|
|
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PH_HISTORY]') AND type in (N'U'))
|
|
DROP TABLE [dbo].[PH_HISTORY]
|
|
GO
|
|
|
|
/****** Object: Trigger [History_Updated] Script Date: 09/28/2012 14:36:46 ******/
|
|
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Updated]'))
|
|
DROP TRIGGER [dbo].[History_Updated]
|
|
GO
|
|
|
|
/****** Object: Trigger [History_Deleted] Script Date: 09/28/2012 14:38:48 ******/
|
|
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Deleted]'))
|
|
DROP TRIGGER [dbo].[History_Deleted]
|
|
GO
|
|
|
|
/****** Object: Trigger [History_Inserted] Script Date: 09/28/2012 14:39:02 ******/
|
|
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Inserted]'))
|
|
DROP TRIGGER [dbo].[History_Inserted]
|
|
GO
|
|
|
|
/****** Object: Trigger [History_Attr_Deleted] Script Date: 09/28/2012 14:39:02 ******/
|
|
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Attr_Deleted]'))
|
|
DROP TRIGGER [dbo].History_Attr_Deleted
|
|
GO
|
|
|
|
/****** Object: Trigger [History_Attr_Inserted] Script Date: 09/28/2012 14:39:02 ******/
|
|
IF EXISTS (SELECT * FROM sys.triggers WHERE object_id = OBJECT_ID(N'[dbo].[History_Attr_Inserted]'))
|
|
DROP TRIGGER [dbo].History_Attr_Inserted
|
|
GO
|
