-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKMICROEMPRESACLA'; delete from tConstraintsResultado where constraintname='CKMICROEMPRESATIP'; delete from tConstraintsResultado where constraintname='FKJURBASFRECREU'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKMICROEMPRESACLA'; delete from tConstraintsResultadoId where constraintname='CKMICROEMPRESATIP'; delete from tConstraintsResultadoId where constraintname='FKJURBASFRECREU'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKMICROEMPRESACLA','2290','505301'); insert into tConstraintsResultadoId values('CKMICROEMPRESATIP','2290','505299'); insert into tConstraintsResultadoId values('FKJURBASFRECREU','2291','505300'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKMICROEMPRESACLA',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TCLASESEMPRESAID.MICROEMPRESA = upper(MICROEMPRESA) and MICROEMPRESA in (1,0)'); insert into tConstraintsResultado values('ES','CKMICROEMPRESATIP',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'FUERA DE LOS VALORES PERMITIDOS PARA TTIPOSEMPRESAID.MICROEMPRESA = upper(MICROEMPRESA) and MICROEMPRESA in (1,0)'); insert into tConstraintsResultado values('ES','FKJURBASFRECREU',to_timestamp('2999-12-31 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),0,to_timestamp('2002-05-01 00:00:00.000000','yyyy-mm-dd hh24:mi:ss.ff'),'NO EXISTE REFERENCIA DE TJURIDICOINFORMACIONBASICA EN TFRECUENCIASID'); commit; -- Done.