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__589C25F3] DEFAULT ('0 '),
[mp] [smallint] NULL CONSTRAINT [DF__AL_LINK_LIC___MP__59904A2C] DEFAULT ('0 '),
[ns] [smallint] NULL CONSTRAINT [DF__AL_LINK_LIC___NS__5A846E65] DEFAULT ('0 '),
[s] [smallint] NULL CONSTRAINT [DF__AL_LINK_LIC_M__S__5B78929E] DEFAULT ('0 '),
[nf] [smallint] NULL CONSTRAINT [DF__AL_LINK_LIC___NF__5C6CB6D7] DEFAULT ('0 '),
[f] [smallint] NULL CONSTRAINT [DF__AL_LINK_LIC_M__F__5D60DB10] 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__5E54FF49] DEFAULT ('0 ')
) ON [PRIMARY]

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