CREATE TABLE [dbo].[al_link_lic_metric_block]
(
[link_lm_block_id] [int] NOT NULL,
[license_id] [int] NULL,
[license_metric_id] [int] NULL,
[block_id] [int] NULL,
[license_or_metric] [smallint] NULL,
[license_index] [smallint] NULL,
[sp] [smallint] NULL CONSTRAINT [DF__al_link_lic___sp__23F5B58F] DEFAULT ('0'),
[mp] [smallint] NULL CONSTRAINT [DF__al_link_lic___mp__24E9D9C8] DEFAULT ('0'),
[ns] [smallint] NULL CONSTRAINT [DF__al_link_lic___ns__25DDFE01] DEFAULT ('0'),
[s] [smallint] NULL CONSTRAINT [DF__al_link_lic_m__s__26D2223A] DEFAULT ('0'),
[nf] [smallint] NULL CONSTRAINT [DF__al_link_lic___nf__27C64673] DEFAULT ('0'),
[f] [smallint] NULL CONSTRAINT [DF__al_link_lic_m__f__28BA6AAC] 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_l__versi__29AE8EE5] DEFAULT ('0')
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE TRIGGER dbo.al_c_new_prikey_licmet_block
   ON  dbo.al_link_lic_metric_block
   INSTEAD OF INSERT
AS
BEGIN
    SET NOCOUNT ON;

    DECLARE @unique_id int
    DECLARE @license_id int
    DECLARE    @license_metric_id int
    DECLARE @block_id int
    DECLARE @license_or_metric smallint
    DECLARE @lastupdateuser nvarchar(255)
    DECLARE @lastupdatedate int
    DECLARE @versionnumber int
    DECLARE @sp smallint
    DECLARE @mp smallint
    DECLARE @ns smallint
    DECLARE @s smallint
    DECLARE @nf smallint
    DECLARE @f smallint


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

    SELECT  @license_id = license_id,
            @license_metric_id = license_metric_id,
            @block_id = block_id,
            @license_or_metric = license_or_metric,
            @sp = sp,
            @mp = mp,
            @ns = ns,
            @s = s,
            @nf = nf,
            @f = f,
            @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_lic_metric_block (link_lm_block_id, license_id, license_metric_id, block_id, license_or_metric, sp, mp, ns, s, nf, f, last_update_user, last_update_date, version_number)
                                                values(@unique_id, @license_id, @license_metric_id, @block_id, @license_or_metric, @sp, @mp, @ns, @s, @nf, @f, 'process',null ,0)
END

GO
ALTER TABLE [dbo].[al_link_lic_metric_block] ADD CONSTRAINT [PK_al_link_lic_metric_block] PRIMARY KEY CLUSTERED ([link_lm_block_id]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [al_link_lic_metr_blk_idx_01] ON [dbo].[al_link_lic_metric_block] ([block_id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_link_lic_metric_block] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_lic_metric_block] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_lic_metric_block] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_lic_metric_block] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_link_lic_metric_block] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_link_lic_metric_block] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_link_lic_metric_block] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_link_lic_metric_block] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_link_lic_metric_block] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_link_lic_metric_block] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_link_lic_metric_block] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_link_lic_metric_block] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_link_lic_metric_block] TO [uapmreporting_group]
GO