-- Deleting TCONSTRAINTSRESULTADO... delete from tConstraintsResultado where constraintname='CKAGUAPOTABLE'; delete from tConstraintsResultado where constraintname='CKALCANTARILLADO'; delete from tConstraintsResultado where constraintname='CKBANIOPROPIO'; delete from tConstraintsResultado where constraintname='CKELECTRICIDAD'; delete from tConstraintsResultado where constraintname='CKESTUDIA'; delete from tConstraintsResultado where constraintname='CKTRABAJA'; delete from tConstraintsResultado where constraintname='FKESCID'; delete from tConstraintsResultado where constraintname='FKESCNIVEDU'; delete from tConstraintsResultado where constraintname='FKIDIESC'; delete from tConstraintsResultado where constraintname='FKIDITIPBANIO'; delete from tConstraintsResultado where constraintname='FKIDITIPCONST'; delete from tConstraintsResultado where constraintname='FKIDITIPHAB'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDA'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDESC'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDFREC'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDMON'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDTIPBANIO'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDTIPCONST'; delete from tConstraintsResultado where constraintname='FKNATNIVVIDTIPHAB'; delete from tConstraintsResultado where constraintname='FKTIPBANIOID'; delete from tConstraintsResultado where constraintname='FKTIPCONSTID'; delete from tConstraintsResultado where constraintname='FKTIPHABID'; delete from tConstraintsResultado where constraintname='IPKESCOLARIDAD'; delete from tConstraintsResultado where constraintname='IPKESCOLARIDADID'; delete from tConstraintsResultado where constraintname='IPKNATNIVELVIDA'; delete from tConstraintsResultado where constraintname='IPKTIPBANIO'; delete from tConstraintsResultado where constraintname='IPKTIPBANIOID'; delete from tConstraintsResultado where constraintname='IPKTIPCONSTRUC'; delete from tConstraintsResultado where constraintname='IPKTIPCONSTRUCID'; delete from tConstraintsResultado where constraintname='IPKTIPHAB'; delete from tConstraintsResultado where constraintname='IPKTIPHABID'; -- Deleting TCONSTRAINTSRESULTADOID... delete from tConstraintsResultadoId where constraintname='CKAGUAPOTABLE'; delete from tConstraintsResultadoId where constraintname='CKALCANTARILLADO'; delete from tConstraintsResultadoId where constraintname='CKBANIOPROPIO'; delete from tConstraintsResultadoId where constraintname='CKELECTRICIDAD'; delete from tConstraintsResultadoId where constraintname='CKESTUDIA'; delete from tConstraintsResultadoId where constraintname='CKTRABAJA'; delete from tConstraintsResultadoId where constraintname='FKESCID'; delete from tConstraintsResultadoId where constraintname='FKESCNIVEDU'; delete from tConstraintsResultadoId where constraintname='FKIDIESC'; delete from tConstraintsResultadoId where constraintname='FKIDITIPBANIO'; delete from tConstraintsResultadoId where constraintname='FKIDITIPCONST'; delete from tConstraintsResultadoId where constraintname='FKIDITIPHAB'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDA'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDESC'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDFREC'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDMON'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDTIPBANIO'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDTIPCONST'; delete from tConstraintsResultadoId where constraintname='FKNATNIVVIDTIPHAB'; delete from tConstraintsResultadoId where constraintname='FKTIPBANIOID'; delete from tConstraintsResultadoId where constraintname='FKTIPCONSTID'; delete from tConstraintsResultadoId where constraintname='FKTIPHABID'; delete from tConstraintsResultadoId where constraintname='IPKESCOLARIDAD'; delete from tConstraintsResultadoId where constraintname='IPKESCOLARIDADID'; delete from tConstraintsResultadoId where constraintname='IPKNATNIVELVIDA'; delete from tConstraintsResultadoId where constraintname='IPKTIPBANIO'; delete from tConstraintsResultadoId where constraintname='IPKTIPBANIOID'; delete from tConstraintsResultadoId where constraintname='IPKTIPCONSTRUC'; delete from tConstraintsResultadoId where constraintname='IPKTIPCONSTRUCID'; delete from tConstraintsResultadoId where constraintname='IPKTIPHAB'; delete from tConstraintsResultadoId where constraintname='IPKTIPHABID'; -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultadoId values('CKAGUAPOTABLE','2290','505248'); insert into tConstraintsResultadoId values('CKALCANTARILLADO','2290','505249'); insert into tConstraintsResultadoId values('CKBANIOPROPIO','2290','505250'); insert into tConstraintsResultadoId values('CKELECTRICIDAD','2290','505251'); insert into tConstraintsResultadoId values('CKESTUDIA','2290','505252'); insert into tConstraintsResultadoId values('CKTRABAJA','2290','505254'); insert into tConstraintsResultadoId values('FKESCID','2291','505255'); insert into tConstraintsResultadoId values('FKESCNIVEDU','2291','505256'); insert into tConstraintsResultadoId values('FKIDIESC','2291','505259'); insert into tConstraintsResultadoId values('FKIDITIPBANIO','2291','505260'); insert into tConstraintsResultadoId values('FKIDITIPCONST','2291','505261'); insert into tConstraintsResultadoId values('FKIDITIPHAB','2291','505262'); insert into tConstraintsResultadoId values('FKNATNIVVIDA','2291','505263'); insert into tConstraintsResultadoId values('FKNATNIVVIDESC','2291','505264'); insert into tConstraintsResultadoId values('FKNATNIVVIDFREC','2291','505265'); insert into tConstraintsResultadoId values('FKNATNIVVIDMON','2291','505266'); insert into tConstraintsResultadoId values('FKNATNIVVIDTIPBANIO','2291','505267'); insert into tConstraintsResultadoId values('FKNATNIVVIDTIPCONST','2291','505268'); insert into tConstraintsResultadoId values('FKNATNIVVIDTIPHAB','2291','505269'); insert into tConstraintsResultadoId values('FKTIPBANIOID','2291','505271'); insert into tConstraintsResultadoId values('FKTIPCONSTID','2291','505272'); insert into tConstraintsResultadoId values('FKTIPHABID','2291','505273'); insert into tConstraintsResultadoId values('IPKESCOLARIDAD','1','505274'); insert into tConstraintsResultadoId values('IPKESCOLARIDADID','1','505275'); insert into tConstraintsResultadoId values('IPKNATNIVELVIDA','1','505279'); insert into tConstraintsResultadoId values('IPKTIPBANIO','1','505280'); insert into tConstraintsResultadoId values('IPKTIPBANIOID','1','505281'); insert into tConstraintsResultadoId values('IPKTIPCONSTRUC','1','505282'); insert into tConstraintsResultadoId values('IPKTIPCONSTRUCID','1','505283'); insert into tConstraintsResultadoId values('IPKTIPHAB','1','505284'); insert into tConstraintsResultadoId values('IPKTIPHABID','1','505285'); -- Loading TCONSTRAINTSRESULTADO... insert into tConstraintsResultado values('ES','CKAGUAPOTABLE',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 TNATURALNIVELDEVIDA.AGUAPOTABLE = upper(AGUAPOTABLE) and AGUAPOTABLE in (1,0)'); insert into tConstraintsResultado values('ES','CKALCANTARILLADO',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 TNATURALNIVELDEVIDA.ALCANTARILLADO = upper(ALCANTARILLADO) and ALCANTARILLADO in (1'); insert into tConstraintsResultado values('ES','CKBANIOPROPIO',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 TNATURALNIVELDEVIDA.BANIOPROPIO = upper(BANIOPROPIO) and BANIOPROPIO in (1,0)'); insert into tConstraintsResultado values('ES','CKELECTRICIDAD',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 TNATURALNIVELDEVIDA.ELECTRICIDAD = upper(ELECTRICIDAD) and ELECTRICIDAD in (1,0)'); insert into tConstraintsResultado values('ES','CKESTUDIA',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 TNATURALNIVELDEVIDA.ESTUDIA = upper(ESTUDIA) and ESTUDIA in (1,0)'); insert into tConstraintsResultado values('ES','CKTRABAJA',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 TNATURALNIVELDEVIDA.TRABAJA = upper(TRABAJA) and TRABAJA in (1,0)'); insert into tConstraintsResultado values('ES','FKESCID',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 TESCOLARIDAD EN TESCOLARIDADID'); insert into tConstraintsResultado values('ES','FKESCNIVEDU',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 TESCOLARIDADID EN TNIVELESEDUCACIONID'); insert into tConstraintsResultado values('ES','FKIDIESC',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 TESCOLARIDAD EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKIDITIPBANIO',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 TTIPOSBANIO EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKIDITIPCONST',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 TTIPOSCONSTRUCCION EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKIDITIPHAB',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 TTIPOSHABITACION EN TIDIOMASID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDA',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 TNATURALNIVELDEVIDA EN TPERSONAID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDESC',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 TNATURALNIVELDEVIDA EN TESCOLARIDADID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDFREC',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 TNATURALNIVELDEVIDA EN TFRECUENCIASID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDMON',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 TNATURALNIVELDEVIDA EN TMONEDASID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDTIPBANIO',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 TNATURALNIVELDEVIDA EN TTIPOSBANIOID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDTIPCONST',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 TNATURALNIVELDEVIDA EN TTIPOSCONSTRUCCIONID'); insert into tConstraintsResultado values('ES','FKNATNIVVIDTIPHAB',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 TNATURALNIVELDEVIDA EN TTIPOSHABITACIONID'); insert into tConstraintsResultado values('ES','FKTIPBANIOID',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 TTIPOSBANIO EN TTIPOSBANIOID'); insert into tConstraintsResultado values('ES','FKTIPCONSTID',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 TTIPOSCONSTRUCCION EN TTIPOSCONSTRUCCIONID'); insert into tConstraintsResultado values('ES','FKTIPHABID',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 TTIPOSHABITACION EN TTIPOSHABITACIONID'); insert into tConstraintsResultado values('ES','IPKESCOLARIDAD',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 TESCOLARIDAD'); insert into tConstraintsResultado values('ES','IPKESCOLARIDADID',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 TESCOLARIDADID'); insert into tConstraintsResultado values('ES','IPKNATNIVELVIDA',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 TNATURALNIVELDEVIDA'); insert into tConstraintsResultado values('ES','IPKTIPBANIO',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 TTIPOSBANIO'); insert into tConstraintsResultado values('ES','IPKTIPBANIOID',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 TTIPOSBANIOID'); insert into tConstraintsResultado values('ES','IPKTIPCONSTRUC',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 TTIPOSCONSTRUCCION'); insert into tConstraintsResultado values('ES','IPKTIPCONSTRUCID',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 TTIPOSCONSTRUCCIONID'); insert into tConstraintsResultado values('ES','IPKTIPHAB',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 TTIPOSHABITACION'); insert into tConstraintsResultado values('ES','IPKTIPHABID',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 TTIPOSHABITACIONID'); commit; -- Done.