--USE [pioner]

GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

/*
OP_Code для PH_HISTORY
0 - ph updated
1 - ph deleted
2 - ph inserted
3 - attrval deleted
4 - attrval inserted
*/

DECLARE @ver int
SET @ver = 3

IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[components]') AND type in (N'U'))
BEGIN
	IF EXISTS( SELECT veri FROM [components] WHERE name='mdb.ph_history' AND veri>=@ver )
	BEGIN
		PRINT N'Current PH_HISTORY version is equal or higher than '+ CAST(@ver AS varchar(10))
		--RAISERROR('Script terminated...',16,1) 
		RETURN	
	END		
END
ELSE
BEGIN
	PRINT N'Components table not found. Script exit'
	RETURN
END

--GO

BEGIN TRY

BEGIN TRAN

PRINT N'Script begin'

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

CREATE TABLE [dbo].[PH_HISTORY](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserName] [nvarchar](50) NULL,
	[HostName] [nvarchar](50) NULL,
	[ModifyDate] [datetime] NOT NULL,
	[OP_Code] [tinyint] NOT NULL,
	[PH_ID] [int] NOT NULL,
	[Name] [nvarchar](50) NULL,
	[Value] [nvarchar](max) NULL,
	[AttrVal_ID] [int] NULL,
 CONSTRAINT [PK_hystory] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

--GO

ALTER TABLE [dbo].[PH_HISTORY] ADD  CONSTRAINT [DF_hystory_UserName]  DEFAULT (suser_sname()) FOR [UserName]
--GO

ALTER TABLE [dbo].[PH_HISTORY] ADD  CONSTRAINT [DF_hystory_HostName]  DEFAULT (host_name()) FOR [HostName]
--GO

ALTER TABLE [dbo].[PH_HISTORY] ADD  CONSTRAINT [DF_hystory_ModifyDate]  DEFAULT (getdate()) FOR [ModifyDate]
--GO

ALTER TABLE [dbo].[PH_HISTORY] ADD  CONSTRAINT [DF_hystory_OP_Code]  DEFAULT ((0)) FOR [OP_Code]
--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]

/****** 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]

/****** 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]

/****** 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

/****** 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

EXEC sp_executesql 
N'
CREATE TRIGGER [dbo].[History_Updated]
ON [dbo].[PH]
AFTER UPDATE
AS 
BEGIN
	DECLARE 
	@del_id [int],
	@del_Name [varchar](260),
	@del_FileName [varchar](260),
	@del_Duration [int],
	@del_Type [int],
	@del_Intro [int],
	@del_Outro [int],
	@del_FadeIn [int],
	@del_FadeOut [int],
	@del_StartNext [int],
	@del_Ph_Start [int],
	@del_Ph_Stop [int],
	@del_Cmd [int],
	@del_Freq [int],
	@del_SmplSize [int],
	@del_RadioID [int],
	--@del_RemoteCmd [int],
	--@del_AddDate [datetime],
	--@del_LastPlayTime [datetime],
	--@del_ModifyDate [datetime],
	@del_Deleted [int],
	--@del_JM_pos [int],
	--@del_SubjText [text],
	@del_ID_Number [varchar](32),
	--@del_EndCode [varchar](10),
	--@del_FirstReportLine [varchar](260),
	--@del_LastReportLine [varchar](260),
	--@del_MaxLvl [real],
	--@del_MaxLvlOk [int],
	--@del_Gain [real],
	--@del_CDId [varchar](10),
	--@del_CDTrackId [int],
	--@del_Album [varchar](260),
	--@del_SongYear [int],
	@del_ModifyFT [bigint],
	--@del_RmtList [varchar](2048),
	@del_DDB_Owner [varchar](64),
	@del_Version [int],
	@del_DDB_ID [int],
	--@del_CRC32 [int],
	--@del_SCH_UsedCount [int],
	@del_Intro2 [int],
	@del_Intro3 [int],
	--@del_Comment [varchar](3000),
	--@del_FadeInType] [int],
	--@del_FadeOutType [int],
	--@del_Mood [int],
	--@del_ActivateDate [datetime],
	--@del_ENERGY [int],
	--@del_TEMPO [int],
	--@del_TEXTURE [int],
	--@del_TEMPO_END [int],
	--@del_TEXTURE_END [int],
	@del_StartThis [int],
	@del_Archive [int],
	--@del_NextPlayTime [datetime],
	--@del_UserModifyTime [datetime],
	--@del_DayRestrictions [binary](168),
	@del_ReadyOnAir [int],
	--@del_Headline [varchar](256),
	--@del_CasseteStartFPS [int],
	--@del_CasseteLengthFPS [int],
	--@del_BackupTapeName [varchar](32),
	--@del_BackupTimeCode [int],
	--@del_KeyFrame [int],
	--@del_KeyIcon [image],
	--@del_TmStamp [timestamp],
	--@del_BackupLength [int],
	--@del_ProtyagFirst [int],
	--@del_ProtyagLast [int],
	--@del_LeftRightCh [int],
	@del_LcCode [varchar](64),
	@del_Publisher [varchar](64),
	--@del_Rds [varchar](512),
	@del_Cmd2 [int],
	@del_TextSizeMs [int],
	@del_PhonoType [int]
	--@del_OwnerName [varchar](64),
	--@del_DdbTmStamp [bigint],
	--@del_nc_root [text],	
	
	DECLARE 
	@ins_id [int],
	@ins_Name [varchar](260),
	@ins_FileName [varchar](260),
	@ins_Duration [int],
	@ins_Type [int],
	@ins_Intro [int],
	@ins_Outro [int],
	@ins_FadeIn [int],
	@ins_FadeOut [int],
	@ins_StartNext [int],
	@ins_Ph_Start [int],
	@ins_Ph_Stop [int],
	@ins_Cmd [int],
	@ins_Freq [int],
	@ins_SmplSize [int],
	@ins_RadioID [int],
	--@ins_RemoteCmd [int],
	--@ins_AddDate [datetime],
	--@ins_LastPlayTime [datetime],
	--@ins_ModifyDate [datetime],
	@ins_Deleted [int],
	--@ins_JM_pos [int],
	--@ins_SubjText [text],
	@ins_ID_Number [varchar](32),
	--@ins_EndCode [varchar](10),
	--@ins_FirstReportLine [varchar](260),
	--@ins_LastReportLine [varchar](260),
	--@ins_MaxLvl [real],
	--@ins_MaxLvlOk [int],
	--@ins_Gain [real],
	--@ins_CDId [varchar](10),
	--@ins_CDTrackId [int],
	--@ins_Album [varchar](260),
	--@ins_SongYear [int],
	@ins_ModifyFT [bigint],
	--@ins_RmtList [varchar](2048),
	@ins_DDB_Owner [varchar](64),
	@ins_Version [int],
	@ins_DDB_ID [int],
	--@ins_CRC32 [int],
	--@ins_SCH_UsedCount [int],
	@ins_Intro2 [int],
	@ins_Intro3 [int],
	--@ins_Comment [varchar](3000),
	--@ins_FadeInType] [int],
	--@ins_FadeOutType [int],
	--@ins_Mood [int],
	--@ins_ActivateDate [datetime],
	--@ins_ENERGY [int],
	--@ins_TEMPO [int],
	--@ins_TEXTURE [int],
	--@ins_TEMPO_END [int],
	--@ins_TEXTURE_END [int],
	@ins_StartThis [int],
	@ins_Archive [int],
	--@ins_NextPlayTime [datetime],
	--@ins_UserModifyTime [datetime],
	--@ins_DayRestrictions [binary](168),
	@ins_ReadyOnAir [int],
	--@ins_Headline [varchar](256),
	--@ins_CasseteStartFPS [int],
	--@ins_CasseteLengthFPS [int],
	--@ins_BackupTapeName [varchar](32),
	--@ins_BackupTimeCode [int],
	--@ins_KeyFrame [int],
	--@ins_KeyIcon [image],
	--@ins_TmStamp [timestamp],
	--@ins_BackupLength [int],
	--@ins_ProtyagFirst [int],
	--@ins_ProtyagLast [int],
	--@ins_LeftRightCh [int],
	@ins_LcCode [varchar](64),
	@ins_Publisher [varchar](64),
	--@ins_Rds [varchar](512),
	@ins_Cmd2 [int],
	@ins_TextSizeMs [int],
	@ins_PhonoType [int]
	--@ins_OwnerName [varchar](64),
	--@ins_DdbTmStamp [bigint],
	--@ins_nc_root [text],	
	
	DECLARE del_cursor CURSOR READ_ONLY  
	FOR  
	SELECT
	id,
	Name,
	[FileName],
	Duration,
	[Type],
	Intro,
	Outro,
	FadeIn,
	FadeOut,
	StartNext,
	Ph_Start,
	Ph_Stop,
	Cmd,
	Freq,
	SmplSize,
	RadioID,
	--RemoteCmd,
	--AddDate,
	--LastPlayTime,
	--ModifyDate,
	Deleted,
	--JM_pos,
	--SubjText,
	ID_Number,
	--EndCode,
	--FirstReportLine,
	--LastReportLine,
	--MaxLvl,
	--MaxLvlOk,
	--Gain,
	--CDId,
	--CDTrackId,
	--Album,
	--SongYear,
	ModifyFT,
	--RmtList,
	DDB_Owner,
	[Version],
	DDB_ID,
	--CRC32,
	--SCH_UsedCount,
	Intro2,
	Intro3,
	--Comment,
	--FadeInType,
	--FadeOutType,
	--Mood,
	--ActivateDate,
	--ENERGY,
	--TEMPO,
	--TEXTURE,
	--TEMPO_END,
	--TEXTURE_END,
	StartThis,
	Archive,
	--NextPlayTime,
	--UserModifyTime,
	--DayRestrictions,
	ReadyOnAir,
	--Headline,
	--CasseteStartFPS,
	--CasseteLengthFPS,
	--BackupTapeName,
	--BackupTimeCode,
	--KeyFrame,
	--KeyIcon,
	--TmStamp,
	--BackupLength,
	--ProtyagFirst,
	--ProtyagLast,
	--LeftRightCh,
	LcCode,
	Publisher,
	--Rds,
	Cmd2,
	TextSizeMs,
	PhonoType
	--OwnerName,
	--DdbTmStamp,
	--nc_root,	
	 
	FROM DELETED
	
	DECLARE ins_cursor CURSOR READ_ONLY  
	FOR  
	SELECT
	id,
	Name,
	[FileName],
	Duration,
	[Type],
	Intro,
	Outro,
	FadeIn,
	FadeOut,
	StartNext,
	Ph_Start,
	Ph_Stop,
	Cmd,
	Freq,
	SmplSize,
	RadioID,
	--RemoteCmd,
	--AddDate,
	--LastPlayTime,
	--ModifyDate,
	Deleted,
	--JM_pos,
	--SubjText,
	ID_Number,
	--EndCode,
	--FirstReportLine,
	--LastReportLine,
	--MaxLvl,
	--MaxLvlOk,
	--Gain,
	--CDId,
	--CDTrackId,
	--Album,
	--SongYear,
	ModifyFT,
	--RmtList,
	DDB_Owner,
	[Version],
	DDB_ID,
	--CRC32,
	--SCH_UsedCount,
	Intro2,
	Intro3,
	--Comment,
	--FadeInType,
	--FadeOutType,
	--Mood,
	--ActivateDate,
	--ENERGY,
	--TEMPO,
	--TEXTURE,
	--TEMPO_END,
	--TEXTURE_END,
	StartThis,
	Archive,
	--NextPlayTime,
	--UserModifyTime,
	--DayRestrictions,
	ReadyOnAir,
	--Headline,
	--CasseteStartFPS,
	--CasseteLengthFPS,
	--BackupTapeName,
	--BackupTimeCode,
	--KeyFrame,
	--KeyIcon,
	--TmStamp,
	--BackupLength,
	--ProtyagFirst,
	--ProtyagLast,
	--LeftRightCh,
	LcCode,
	Publisher,
	--Rds,
	Cmd2,
	TextSizeMs,
	PhonoType
	--OwnerName,
	--DdbTmStamp,
	--nc_root,	
	 
	FROM INSERTED	
	
	OPEN del_cursor;
	OPEN ins_cursor;

	FETCH NEXT FROM del_cursor INTO 		
		@del_id,
		@del_Name,
		@del_FileName,
		@del_Duration,
		@del_Type,
		@del_Intro,
		@del_Outro,
		@del_FadeIn,
		@del_FadeOut,
		@del_StartNext,
		@del_Ph_Start,
		@del_Ph_Stop,
		@del_Cmd,
		@del_Freq,
		@del_SmplSize,
		@del_RadioID,
		--@del_RemoteCmd,
		--@del_AddDate,
		--@del_LastPlayTime,
		--@del_ModifyDate,
		@del_Deleted,
		--@del_JM_pos,
		--@del_SubjText,
		@del_ID_Number,
		--@del_EndCode,
		--@del_FirstReportLine,
		--@del_LastReportLine,
		--@del_MaxLvl,
		--@del_MaxLvlOk,
		--@del_Gain,
		--@del_CDId,
		--@del_CDTrackId,
		--@del_Album,
		--@del_SongYear,
		@del_ModifyFT,
		--@del_RmtList,
		@del_DDB_Owner,
		@del_Version,
		@del_DDB_ID,
		--@del_CRC32,
		--@del_SCH_UsedCount,
		@del_Intro2,
		@del_Intro3,
		--@del_Comment,
		--@del_FadeInType,
		--@del_FadeOutType,
		--@del_Mood,
		--@del_ActivateDate,
		--@del_ENERGY,
		--@del_TEMPO,
		--@del_TEXTURE,
		--@del_TEMPO_END,
		--@del_TEXTURE_END,
		@del_StartThis,
		@del_Archive,
		--@del_NextPlayTime,
		--@del_UserModifyTime,
		--@del_DayRestrictions,
		@del_ReadyOnAir,
		--@del_Headline,
		--@del_CasseteStartFPS,
		--@del_CasseteLengthFPS,
		--@del_BackupTapeName,
		--@del_BackupTimeCode,
		--@del_KeyFrame,
		--@del_KeyIcon,
		--@del_TmStamp,
		--@del_BackupLength,
		--@del_ProtyagFirst,
		--@del_ProtyagLast,
		--@del_LeftRightCh,
		@del_LcCode,
		@del_Publisher,
		--@del_Rds,
		@del_Cmd2,
		@del_TextSizeMs,
		@del_PhonoType
		--@del_OwnerName,
		--@del_DdbTmStamp,
		--@del_nc_root,			
	
	FETCH NEXT FROM ins_cursor INTO 
		@ins_id,
		@ins_Name,
		@ins_FileName,
		@ins_Duration,
		@ins_Type,
		@ins_Intro,
		@ins_Outro,
		@ins_FadeIn,
		@ins_FadeOut,
		@ins_StartNext,
		@ins_Ph_Start,
		@ins_Ph_Stop,
		@ins_Cmd,
		@ins_Freq,
		@ins_SmplSize,
		@ins_RadioID,
		--@ins_RemoteCmd,
		--@ins_AddDate,
		--@ins_LastPlayTime,
		--@ins_ModifyDate,
		@ins_Deleted,
		--@ins_JM_pos,
		--@ins_SubjText,
		@ins_ID_Number,
		--@ins_EndCode,
		--@ins_FirstReportLine,
		--@ins_LastReportLine,
		--@ins_MaxLvl,
		--@ins_MaxLvlOk,
		--@ins_Gain,
		--@ins_CDId,
		--@ins_CDTrackId,
		--@ins_Album,
		--@ins_SongYear,
		@ins_ModifyFT,
		--@ins_RmtList,
		@ins_DDB_Owner,
		@ins_Version,
		@ins_DDB_ID,
		--@ins_CRC32,
		--@ins_SCH_UsedCount,
		@ins_Intro2,
		@ins_Intro3,
		--@ins_Comment,
		--@ins_FadeInType,
		--@ins_FadeOutType,
		--@ins_Mood,
		--@ins_ActivateDate,
		--@ins_ENERGY,
		--@ins_TEMPO,
		--@ins_TEXTURE,
		--@ins_TEMPO_END,
		--@ins_TEXTURE_END,
		@ins_StartThis,
		@ins_Archive,
		--@ins_NextPlayTime,
		--@ins_UserModifyTime,
		--@ins_DayRestrictions,
		@ins_ReadyOnAir,
		--@ins_Headline,
		--@ins_CasseteStartFPS,
		--@ins_CasseteLengthFPS,
		--@ins_BackupTapeName,
		--@ins_BackupTimeCode,
		--@ins_KeyFrame,
		--@ins_KeyIcon,
		--@ins_TmStamp,
		--@ins_BackupLength,
		--@ins_ProtyagFirst,
		--@ins_ProtyagLast,
		--@ins_LeftRightCh,
		@ins_LcCode,
		@ins_Publisher,
		--@ins_Rds,
		@ins_Cmd2,
		@ins_TextSizeMs,
		@ins_PhonoType
		--@ins_OwnerName,
		--@ins_DdbTmStamp,
		--@ins_nc_root,			
		

	WHILE @@FETCH_STATUS = 0
	BEGIN
		
		IF @del_id = @ins_id
		BEGIN
			IF @del_Name != @ins_Name
				INSERT INTO dbo.PH_HISTORY (PH_ID, [Name], Value) VALUES(@ins_id, ''Name'', @ins_Name);
				
			IF @del_FileName != @ins_FileName
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''FileName'', @ins_FileName);

			IF @del_Duration != @ins_Duration
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Duration'', @ins_Duration);
				
			IF @del_Type != @ins_Type
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Type'', @ins_Type);
				
			IF @del_Intro != @ins_Intro
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Intro'', @ins_Intro);
				
			IF @del_Outro != @ins_Outro
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Outro'', @ins_Outro);

			IF @del_FadeIn != @ins_FadeIn
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''FadeIn'', @ins_FadeIn);

			IF @del_FadeOut != @ins_FadeOut
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''FadeOut'', @ins_FadeOut);

			IF @del_StartNext != @ins_StartNext
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''StartNext'', @ins_StartNext);

			IF @del_Ph_Start != @ins_Ph_Start
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Ph_Start'', @ins_Ph_Start);

			IF @del_Ph_Stop != @ins_Ph_Stop
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Ph_Stop'', @ins_Ph_Stop);
				
			IF @del_Cmd != @ins_Cmd
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Cmd'', @ins_Cmd);				

			IF @del_Freq != @ins_Freq
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Freq'', @ins_Freq);				

			IF @del_SmplSize != @ins_SmplSize
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''SmplSize'', @ins_SmplSize);				

			IF @del_RadioID != @ins_RadioID
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''RadioID'', @ins_RadioID);				
				
			IF @del_Deleted != @ins_Deleted
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Deleted'', @ins_Deleted);				
				
			IF @del_ID_Number != @ins_ID_Number
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''ID_Number'', @ins_ID_Number);				

			IF @del_ModifyFT != @ins_ModifyFT
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''ModifyFT'', @ins_ModifyFT);				

			IF @del_DDB_Owner != @ins_DDB_Owner
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''DDB_Owner'', @ins_DDB_Owner);				

			IF @del_Version != @ins_Version
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Version'', @ins_Version);				

			IF @del_DDB_ID != @ins_DDB_ID
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''DDB_ID'', @ins_DDB_ID);				
				
			IF @del_Intro2 != @ins_Intro2
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Intro2'', @ins_Intro2);				
				
			IF @del_Intro3 != @ins_Intro3
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Intro3'', @ins_Intro3);				

			IF @del_StartThis != @ins_StartThis
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''StartThis'', @ins_StartThis);				

			IF @del_Archive != @ins_Archive
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Archive'', @ins_Archive);				

			IF @del_ReadyOnAir != @ins_ReadyOnAir
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''ReadyOnAir'', @ins_ReadyOnAir);				

			IF @del_LcCode != @ins_LcCode
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''LcCode'', @ins_LcCode);				

			IF @del_Publisher != @ins_Publisher
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Publisher'', @ins_Publisher);				

			IF @del_Cmd2 != @ins_Cmd2
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''Cmd2'', @ins_Cmd2);				

			IF @del_TextSizeMs != @ins_TextSizeMs
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''TextSizeMs'', @ins_TextSizeMs);				

			IF @del_PhonoType != @ins_PhonoType
				INSERT INTO dbo.PH_HISTORY (PH_ID, Name, Value) VALUES(@ins_id, ''PhonoType'', @ins_PhonoType);				

		END
		
		FETCH NEXT FROM del_cursor INTO 
			@del_id,
			@del_Name,
			@del_FileName,
			@del_Duration,
			@del_Type,
			@del_Intro,
			@del_Outro,
			@del_FadeIn,
			@del_FadeOut,
			@del_StartNext,
			@del_Ph_Start,
			@del_Ph_Stop,
			@del_Cmd,
			@del_Freq,
			@del_SmplSize,
			@del_RadioID,
			--@del_RemoteCmd,
			--@del_AddDate,
			--@del_LastPlayTime,
			--@del_ModifyDate,
			@del_Deleted,
			--@del_JM_pos,
			--@del_SubjText,
			@del_ID_Number,
			--@del_EndCode,
			--@del_FirstReportLine,
			--@del_LastReportLine,
			--@del_MaxLvl,
			--@del_MaxLvlOk,
			--@del_Gain,
			--@del_CDId,
			--@del_CDTrackId,
			--@del_Album,
			--@del_SongYear,
			@del_ModifyFT,
			--@del_RmtList,
			@del_DDB_Owner,
			@del_Version,
			@del_DDB_ID,
			--@del_CRC32,
			--@del_SCH_UsedCount,
			@del_Intro2,
			@del_Intro3,
			--@del_Comment,
			--@del_FadeInType,
			--@del_FadeOutType,
			--@del_Mood,
			--@del_ActivateDate,
			--@del_ENERGY,
			--@del_TEMPO,
			--@del_TEXTURE,
			--@del_TEMPO_END,
			--@del_TEXTURE_END,
			@del_StartThis,
			@del_Archive,
			--@del_NextPlayTime,
			--@del_UserModifyTime,
			--@del_DayRestrictions,
			@del_ReadyOnAir,
			--@del_Headline,
			--@del_CasseteStartFPS,
			--@del_CasseteLengthFPS,
			--@del_BackupTapeName,
			--@del_BackupTimeCode,
			--@del_KeyFrame,
			--@del_KeyIcon,
			--@del_TmStamp,
			--@del_BackupLength,
			--@del_ProtyagFirst,
			--@del_ProtyagLast,
			--@del_LeftRightCh,
			@del_LcCode,
			@del_Publisher,
			--@del_Rds,
			@del_Cmd2,
			@del_TextSizeMs,
			@del_PhonoType
			--@del_OwnerName,
			--@del_DdbTmStamp,
			--@del_nc_root,			
		
		FETCH NEXT FROM ins_cursor INTO 
			@ins_id,
			@ins_Name,
			@ins_FileName,
			@ins_Duration,
			@ins_Type,
			@ins_Intro,
			@ins_Outro,
			@ins_FadeIn,
			@ins_FadeOut,
			@ins_StartNext,
			@ins_Ph_Start,
			@ins_Ph_Stop,
			@ins_Cmd,
			@ins_Freq,
			@ins_SmplSize,
			@ins_RadioID,
			--@ins_RemoteCmd,
			--@ins_AddDate,
			--@ins_LastPlayTime,
			--@ins_ModifyDate,
			@ins_Deleted,
			--@ins_JM_pos,
			--@ins_SubjText,
			@ins_ID_Number,
			--@ins_EndCode,
			--@ins_FirstReportLine,
			--@ins_LastReportLine,
			--@ins_MaxLvl,
			--@ins_MaxLvlOk,
			--@ins_Gain,
			--@ins_CDId,
			--@ins_CDTrackId,
			--@ins_Album,
			--@ins_SongYear,
			@ins_ModifyFT,
			--@ins_RmtList,
			@ins_DDB_Owner,
			@ins_Version,
			@ins_DDB_ID,
			--@ins_CRC32,
			--@ins_SCH_UsedCount,
			@ins_Intro2,
			@ins_Intro3,
			--@ins_Comment,
			--@ins_FadeInType,
			--@ins_FadeOutType,
			--@ins_Mood,
			--@ins_ActivateDate,
			--@ins_ENERGY,
			--@ins_TEMPO,
			--@ins_TEXTURE,
			--@ins_TEMPO_END,
			--@ins_TEXTURE_END,
			@ins_StartThis,
			@ins_Archive,
			--@ins_NextPlayTime,
			--@ins_UserModifyTime,
			--@ins_DayRestrictions,
			@ins_ReadyOnAir,
			--@ins_Headline,
			--@ins_CasseteStartFPS,
			--@ins_CasseteLengthFPS,
			--@ins_BackupTapeName,
			--@ins_BackupTimeCode,
			--@ins_KeyFrame,
			--@ins_KeyIcon,
			--@ins_TmStamp,
			--@ins_BackupLength,
			--@ins_ProtyagFirst,
			--@ins_ProtyagLast,
			--@ins_LeftRightCh,
			@ins_LcCode,
			@ins_Publisher,
			--@ins_Rds,
			@ins_Cmd2,
			@ins_TextSizeMs,
			@ins_PhonoType
			--@ins_OwnerName,
			--@ins_DdbTmStamp,
			--@ins_nc_root,			
		
	END
	
	CLOSE del_cursor;
	CLOSE ins_cursor;
	DEALLOCATE del_cursor;	
	DEALLOCATE ins_cursor;	

END
'
--GO
--GO

EXEC sp_executesql 
N'
CREATE TRIGGER [dbo].[History_Deleted]
ON [dbo].[PH]
AFTER DELETE
AS 
BEGIN
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code) SELECT id, 1 FROM DELETED 
END
'
--GO

EXEC sp_executesql 
N'
CREATE TRIGGER [dbo].[History_Inserted]
ON [dbo].[PH]
AFTER INSERT
AS 
BEGIN
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, Name, Value) SELECT id, 2, ''Type'', [Type] FROM INSERTED 
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, Name, Value) SELECT id, 2, ''Name'', [Name] FROM INSERTED 
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, Name, Value) SELECT id, 2, ''FileName'', [FileName] FROM INSERTED 
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, Name, Value) SELECT id, 2, ''ID_Number'', [ID_Number] FROM INSERTED 
END
'

--GO
EXEC sp_executesql 
N'
CREATE TRIGGER [dbo].History_Attr_Deleted
ON [dbo].[PH_TO_ATTRVALS]
AFTER DELETE
AS 
BEGIN
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, AttrVal_ID) SELECT ph_id, 3, attrval_id FROM DELETED 
END
'
--GO

EXEC sp_executesql 
N'
CREATE TRIGGER [dbo].History_Attr_Inserted
ON [dbo].[PH_TO_ATTRVALS]
AFTER INSERT
AS 
BEGIN
	INSERT INTO dbo.PH_HISTORY (PH_ID, OP_Code, AttrVal_ID) SELECT ph_id, 4, attrval_id FROM INSERTED 
END
PRINT ''create TRIGGER [dbo].History_Attr_Inserted''
'
--GO

--DELETE FROM dbo.components WHERE name='mdb.ph_history'
--INSERT INTO dbo.components (name, vers, veri) VALUES('mdb.ph_history', '', @ver)

IF EXISTS( SELECT id FROM [components] WHERE name='mdb.ph_history' )
	UPDATE dbo.components set veri = @ver WHERE name='mdb.ph_history'
ELSE
	INSERT INTO dbo.components (name, vers, veri) VALUES('mdb.ph_history', '', @ver)

COMMIT TRAN

PRINT N'Script end!'

END TRY
BEGIN CATCH
	ROLLBACK TRAN
	PRINT N'Script error'
END CATCH;