CREATE TABLE [dbo].[al_link_assets]
(
[own_resource_uuid] [binary] (16) NOT NULL,
[dis_hw_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_a__versi__211948E4] DEFAULT ('0')
) ON [PRIMARY]
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE TRIGGER dbo.al_c_al_link_assets
ON dbo.al_link_assets
AFTER INSERT
AS
    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_assets)'
    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 own_resource_uuid, 'al_link_assets', 'dis_hw_uuid', 1, dis_hw_uuid, @user_name, @update_date, @user_name, @update_date from inserted

GO
CREATE TRIGGER dbo.al_d_al_link_assets
ON dbo.al_link_assets
AFTER DELETE
AS
    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_assets)'
    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 own_resource_uuid, 'al_link_assets', 'dis_hw_uuid', 2, dis_hw_uuid, @user_name, @update_date, @user_name, @update_date from deleted

GO
CREATE TRIGGER dbo.al_u_al_link_assets
ON dbo.al_link_assets
AFTER UPDATE
AS
    declare @update_date int
    set @update_date = datediff(ss, '1/1/1970', getutcdate())
    declare @user_name nvarchar(255)
    set @user_name = SYSTEM_USER + '(al_u_al_link_assets)'
    if update(dis_hw_uuid)
    begin
        insert into al_attribute_tracking (object_uuid, table_name, field_name, [action], old_value, new_value, creation_user, creation_date, last_update_user, last_update_date)
            select i.own_resource_uuid, 'al_link_assets', 'dis_hw_uuid', 0, d.dis_hw_uuid, i.dis_hw_uuid, @user_name, @update_date, @user_name, @update_date
                from inserted i inner join deleted d on (d.own_resource_uuid = i.own_resource_uuid and dbo.is_different(d.dis_hw_uuid, i.dis_hw_uuid) = 1)
    end

GO
ALTER TABLE [dbo].[al_link_assets] ADD CONSTRAINT [PK_al_link_assets] PRIMARY KEY CLUSTERED ([own_resource_uuid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [U_al_link_assets] ON [dbo].[al_link_assets] ([dis_hw_uuid]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_link_assets] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_link_assets] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_link_assets] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_link_assets] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_link_assets] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_link_assets] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_link_assets] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_link_assets] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_link_assets] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_link_assets] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_link_assets] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_link_assets] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_link_assets] TO [uapmreporting_group]
GO