create procedure sp_enableTenantTriggers(@flag int)
/* this script disables the tenant trigger after schema installation */
/* the trigger will be enabled by the anderson installation postinstall */

as
begin
    declare @cfg int;

    set @cfg = (select count(*) from ca_settings where set_id = 1000);
    if ( @cfg = 0)
    begin
        insert into ca_settings (set_id , set_val_lng, set_val_text)
                values ( 1000, @flag, 'Tenant trigger configuration enabled');
    end;

    update ca_settings set set_val_lng = @flag
                where set_id = 1000;

    if (@flag = 0)
    begin
        /* disable triggers */
        disable trigger r_assetsource4tenant on ca_asset_source;
        disable trigger r_locicalasset4tenant on ca_logical_asset;
        disable trigger r_new_agent4tenant on ca_agent;
        disable trigger r_upd_asset4tenant on ca_asset;
        disable trigger r_upd_dhw_assetsrcuid on ca_discovered_hardware;
        disable trigger r_upd_dishwtid on ca_discovered_hardware;
        disable trigger r_upd_tenantid on ca_discovered_hardware;
        return;
    end;

    /* enable the triggers */

    enable trigger r_assetsource4tenant on ca_asset_source;
    enable trigger r_locicalasset4tenant on ca_logical_asset;
    enable trigger r_new_agent4tenant on ca_agent;
    enable trigger r_upd_asset4tenant on ca_asset;
    enable trigger r_upd_dhw_assetsrcuid on ca_discovered_hardware;
    enable trigger r_upd_dishwtid on ca_discovered_hardware;
    enable trigger r_upd_tenantid on ca_discovered_hardware;
    return;
end
GO
GRANT EXECUTE ON  [dbo].[sp_enableTenantTriggers] TO [ca_itrm_group]
GO