-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='FKIDIMOTRECH'; delete from tConstraintsResultado where constraintname='FKIDITIPVERDAT'; delete from tConstraintsResultado where constraintname='FKMOTRECHID'; delete from tConstraintsResultado where constraintname='FKTIPVERDATID'; delete from tConstraintsResultado where constraintname='FKVERIFMOTRECH'; delete from tConstraintsResultado where constraintname='FKVERIFTIPVER'; delete from tConstraintsResultado where constraintname='IPKMOTRECH'; delete from tConstraintsResultado where constraintname='IPKMOTRECHID'; delete from tConstraintsResultado where constraintname='IPKTIPVERDAT'; delete from tConstraintsResultado where constraintname='IPKTIPVERDATID'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='FKIDIMOTRECH'; delete from tConstraintsResultadoId where constraintname='FKIDITIPVERDAT'; delete from tConstraintsResultadoId where constraintname='FKMOTRECHID'; delete from tConstraintsResultadoId where constraintname='FKTIPVERDATID'; delete from tConstraintsResultadoId where constraintname='FKVERIFMOTRECH'; delete from tConstraintsResultadoId where constraintname='FKVERIFTIPVER'; delete from tConstraintsResultadoId where constraintname='IPKMOTRECH'; delete from tConstraintsResultadoId where constraintname='IPKMOTRECHID'; delete from tConstraintsResultadoId where constraintname='IPKTIPVERDAT'; delete from tConstraintsResultadoId where constraintname='IPKTIPVERDATID'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('FKIDIMOTRECH','2291','505317'); insert into tConstraintsResultadoId values('FKIDITIPVERDAT','2291','505318'); insert into tConstraintsResultadoId values('FKMOTRECHID','2291','505319'); insert into tConstraintsResultadoId values('FKTIPVERDATID','2291','505320'); insert into tConstraintsResultadoId values('FKVERIFMOTRECH','2291','505321'); insert into tConstraintsResultadoId values('FKVERIFTIPVER','2291','505322'); insert into tConstraintsResultadoId values('IPKMOTRECH','1','505323'); insert into tConstraintsResultadoId values('IPKMOTRECHID','1','505324'); insert into tConstraintsResultadoId values('IPKTIPVERDAT','1','505326'); insert into tConstraintsResultadoId values('IPKTIPVERDATID','1','505327'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKIDIMOTRECH',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 TMOTIVOSRECHAZO EN TIDIOMASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKIDITIPVERDAT',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 TTIPOSVERIFICACION EN TIDIOMASID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKMOTRECHID',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 TMOTIVOSRECHAZO EN TMOTIVOSRECHAZOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKTIPVERDATID',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 TTIPOSVERIFICACION EN TTIPOSVERIFICACIONID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKVERIFMOTRECH',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 TPERSONAVERIFICACIONDATOS EN TMOTIVOSRECHAZOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','FKVERIFTIPVER',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 TPERSONAVERIFICACIONDATOS EN TTIPOSVERIFICACIONID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKMOTRECH',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TMOTIVOSRECHAZO'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKMOTRECHID',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TMOTIVOSRECHAZOID'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPVERDAT',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTIPOSVERIFICACION'); insert into tConstraintsResultado (CIDIOMA,CONSTRAINTNAME,FHASTA,VERSIONCONTROL,FDESDE,DESCRIPCION) values('ES','IPKTIPVERDATID',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'),'REGISTRO DUPLICADO CLAVE PRINCIPAL DE TTIPOSVERIFICACIONID'); commit; -- Done.