CREATE TABLE [dbo].[FA_CARD_STOCK] (
	[TRACKING_NUMBER] [varchar] ( 12 ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
	[T_NAME] [varchar] ( 8 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[T_NUMBER] [varchar] ( 4 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[GROUP_ID] [varchar] ( 4 ) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[SERIE_ID] [bigint] NULL ,
	[DENOMINATION] [int] NOT NULL ,
	[WHEN_PUT] [datetime] NOT NULL ,
	[STATUS] [tinyint] NULL ,
	[TYPE] [tinyint] NULL 
) ON [PRIMARY]
GO

ALTER TABLE [dbo].[FA_CARD_STOCK] WITH NOCHECK ADD 
	CONSTRAINT [PK_FA_CARD_STOCK] PRIMARY KEY  CLUSTERED 
	(
		[TRACKING_NUMBER]
	)  ON [PRIMARY] 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE TRIGGER TR_CARDSTOCK_INSERT ON dbo.FA_CARD_STOCK 
FOR INSERT 
AS
INSERT INTO FA_CARD_HISTORY
  SELECT 
    TRACKING_NUMBER,
       'stock',
         GETDATE(),
          DENOMINATION,
           SYSTEM_USER 
  from INSERTED
UPDATE
  FA_CARD_STOCK 
SET
 T_NAME = SUBSTRING(FA_CARD_STOCK.TRACKING_NUMBER, 1 , 8 ),
 T_NUMBER = SUBSTRING(FA_CARD_STOCK.TRACKING_NUMBER, 9 , 12 )
 FROM 
  FA_CARD_STOCK
    INNER JOIN INSERTED ON 
                   FA_CARD_STOCK.TRACKING_NUMBER=INSERTED.TRACKING_NUMBER


GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

CREATE TRIGGER TRI_CARDSTOCK_DEL
ON  FA_CARD_STOCK  
FOR DELETE
AS
INSERT INTO FA_CARD_HISTORY
  SELECT 
    TRACKING_NUMBER,
       'Taken from stock',
         GETDATE(),
          DENOMINATION,
           SYSTEM_USER 
  from DELETED 

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO