CREATE TABLE [dbo].[al_link_product_block]
(
[link_product_block_id] [int] NOT NULL,
[product_uuid] [binary] (16) NOT NULL,
[block_id] [int] NOT NULL,
[product_index] [int] NULL,
[discovery_changed] [smallint] NULL,
[finite_instance] [int] NOT NULL CONSTRAINT [DF__AL_LINK_P__FINIT__457442E6] DEFAULT ('0 '),
[nonfinite_instance] [int] NOT NULL CONSTRAINT [DF__AL_LINK_P__NONFI__4668671F] DEFAULT ('0 '),
[last_update_user] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[last_update_date] [int] NULL,
[version_number] [int] NULL CONSTRAINT [DF__AL_LINK_P__VERSI__475C8B58] DEFAULT ('0 ')
) ON [PRIMARY]

GO
CREATE TRIGGER dbo.al_c_new_prikey_prod_block
   ON  dbo.al_link_product_block
   INSTEAD OF INSERT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @unique_id int
    DECLARE @product_uuid binary(16)
    DECLARE @block_id int
    DECLARE @finite_instance int
    DECLARE @lastupdateuser nvarchar(255)
    DECLARE @lastupdatedate int
    DECLARE @versionnumber int    
    declare @nonfinite_instance int

    select  @unique_id = max(link_product_block_id) from al_link_product_block
    if @unique_id is null
        set @unique_id = 0
    else
        set @unique_id = @unique_id + 1

    

    SELECT  @product_uuid = product_uuid,
            @block_id = block_id,
            @finite_instance = finite_instance,
            @nonfinite_instance = nonfinite_instance,
            @lastupdateuser = last_update_user,
            @lastupdatedate = last_update_date,
            @versionnumber = version_number
    FROM INSERTED

    select @lastupdatedate = (datediff(ss, '1/1/1970', getdate())+ 18000)

    insert into al_link_product_block (link_product_block_id, product_uuid, block_id, finite_instance, nonfinite_instance, last_update_user, last_update_date, version_number)
                                                values(@unique_id, @product_uuid, @block_id, @finite_instance, @nonfinite_instance, 'process',null ,0)
END
GO
ALTER TABLE [dbo].[al_link_product_block] ADD CONSTRAINT [pk_al_link_product_block] PRIMARY KEY CLUSTERED ([link_product_block_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [al_link_product_block_idx_01] ON [dbo].[al_link_product_block] ([block_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [al_link_product_block_idx_02] ON [dbo].[al_link_product_block] ([product_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_link_product_block] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_product_block] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_product_block] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_product_block] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_link_product_block] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_link_product_block] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_link_product_block] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_link_product_block] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_link_product_block] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_link_product_block] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_link_product_block] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_link_product_block] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_link_product_block] TO [uapmreporting_group]
GO