--INCLUI UMA CONTA CONTABIL
INSERT INTO ctb_conta_contabil
SELECT 111111111111, '', 5, 1111, 0, 0, '', 'N', 1
  FROM ctb_conta_contabil
 WHERE (SELECT xx.codigo FROM ctb_conta_contabil xx WHERE xx.codigo = 111111111111) IS NULL LIMIT 1;


--ALTERA AS CONTAS CONTABEIS ERRADAS
UPDATE ctb_lancamento SET conta_debito = 111111111111
WHERE NOT EXISTS (SELECT codigo FROM ctb_conta_contabil
WHERE ctb_conta_contabil.codigo = ctb_lancamento.conta_debito );


ALTER TABLE ctb_lancamento ADD CONSTRAINT fk_ctb_lancamento_conta_debito
FOREIGN KEY (conta_debito) REFERENCES ctb_conta_contabil (codigo)
ON DELETE RESTRICT ON UPDATE NO ACTION;