novas_permissoes_historico_padrao.sql

DELETE FROM AccountingTransactionDescriptionProfile;

INSERT INTO AccountingTransactionDescriptionProfile (id_descricao_transacao_contabil, id_perfil) SELECT 
    id_descricao_transacao_contabil, p.id_perfil
FROM
    AccountingTransactionDescriptionMainData
        LEFT JOIN  ProfileMainData p ON 1 = 1
WHERE
    p.id_perfil IN (62 , 146, 120, 117, 114, 98);
    
DELETE FROM AccountingTransactionDescriptionEnvironment;

INSERT INTO AccountingTransactionDescriptionEnvironment (id_descricao_transacao_contabil, id_empresa) SELECT 
    id_descricao_transacao_contabil, c.id_empresa
FROM
    AccountingTransactionDescriptionMainData
        LEFT JOIN  CorporationMainData c ON 1 = 1
WHERE
    c.niv_1 = 1;