CREATE TABLE [dbo].[al_link_dis_hw_contact]
(
[dis_hw_uuid] [binary] (16) NOT NULL,
[contact_uuid] [binary] (16) NOT NULL,
[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_d__versi__1F660A9C] DEFAULT ('0')
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE TRIGGER dbo.al_c_al_link_dis_hw_contact
ON dbo.al_link_dis_hw_contact
AFTER INSERT
AS
    if dbo.is_installed(2022) = 0
        return
    declare @update_date int
    set @update_date = datediff(ss, '1/1/1970', getutcdate())    
    declare @user_name nvarchar(255)
    set @user_name = SYSTEM_USER + '(al_c_al_link_dis_hw_contact)'
    insert into al_attribute_tracking (object_uuid, table_name, field_name, [action], new_value, creation_user, creation_date, last_update_user, last_update_date)
        select dis_hw_uuid, 'al_link_dis_hw_contact', 'contact_uuid', 1, contact_uuid, @user_name, @update_date, @user_name, @update_date from inserted


GO

CREATE TRIGGER dbo.al_d_al_link_dis_hw_contact
ON dbo.al_link_dis_hw_contact
AFTER DELETE
AS
    if dbo.is_installed(2022) = 0
        return
    declare @update_date int
    set @update_date = datediff(ss, '1/1/1970', getutcdate())    
    declare @user_name nvarchar(255)
    set @user_name = SYSTEM_USER + '(al_d_al_link_dis_hw_contact)'
    insert into al_attribute_tracking (object_uuid, table_name, field_name, [action], old_value, creation_user, creation_date, last_update_user, last_update_date)
        select dis_hw_uuid, 'al_link_dis_hw_contact', 'contact_uuid', 2, contact_uuid, @user_name, @update_date, @user_name, @update_date from deleted


GO
ALTER TABLE [dbo].[al_link_dis_hw_contact] ADD CONSTRAINT [PK_al_link_dis_hw_contact] PRIMARY KEY CLUSTERED ([dis_hw_uuid], [contact_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [U_al_link_dis_hw_contact] ON [dbo].[al_link_dis_hw_contact] ([dis_hw_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_link_dis_hw_contact] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_dis_hw_contact] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_dis_hw_contact] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_dis_hw_contact] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_link_dis_hw_contact] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_link_dis_hw_contact] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_link_dis_hw_contact] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_link_dis_hw_contact] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_link_dis_hw_contact] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_link_dis_hw_contact] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_link_dis_hw_contact] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_link_dis_hw_contact] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_link_dis_hw_contact] TO [uapmreporting_group]
GO