USE [BN_PATP]
GO
/****** Object:  Trigger [dbo].    [duplicate]Script Date: 02/03/2014 14:34:08 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].  
    [duplicate]ON  [dbo].[SYS_DEV_DirtyData]
    AFTER INSERT
AS  
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

     -- Insert statements for trigger here
    INSERT INTO NavMessages SELECT device_code as DeviceCode,lat as Lat,long as Lng, speed as Speed, tele_time as [Time],direction as Direction FROM inserted
END

USE [bn_patp_dob]
GO

/****** Object:  Table [dbo].[No19Sens_devices]    Script Date: 03.02.2014 14:49:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[No19Sens_devices](
     [id] [int]IDENTITY(1,1) NOT NULL,
    [device_code] [varchar](16) NOT NULL,
  CONSTRAINT [PK_No19Sens_devices] 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

SET ANSI_PADDING OFF
GO

USE [bn_patp_dob]
GO
/****** Object:  Trigger [dbo].[No19Sens]    Script Date: 03.02.2014 14:50:28 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[No19Sens]
    ON  [dbo].[SYS_DEV_DirtyData]  
    AFTER INSERT
AS  
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

     -- Insert statements for trigger here
    update DD  
    set dd.[digit_sens_num] =  case when i.digit_sens_num&power(2,19-1)>0 then i.digit_sens_num^power(2,19-1) else i.digit_sens_num end    
     
    FROM inserted as i  
    inner join [dbo].[SYS_DEV_DirtyData] as dd on dd.id=i.id
    inner join [dbo].[No19Sens_devices] as No19 on No19.device_code=i.device_code
END

USE [bn_patp_dob]
GO
/****** Object:  Trigger [dbo].[No19Sens]    Script Date: 04.02.2014 8:41:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[No19Sens]
    ON  [dbo].[SYS_DEV_DirtyData]  
    AFTER INSERT
AS  
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

     -- Insert statements for trigger here
    update DD  
--   set dd.[digit_sens_num] =  case when i.digit_sens_num&power(2,19-1)>0 then i.digit_sens_num^power(2,19-1) else i.digit_sens_num end    
    set dd.[digit_sens_num] =  0    
     
    FROM inserted as i  
    inner join [dbo].[SYS_DEV_DirtyData] as dd on dd.id=i.id
    inner join [dbo].[No19Sens_devices] as No19 on No19.device_code=i.device_code
END