Script Para Inicializar Bases de Datos

De ColombiaSoftware

Revisión de 11:10 12 ene 2011

delete from tb_trazabilidad; delete from tb_itematencionclienteestado; delete from tb_itematencionclientenovedad; delete from tb_itematencionclientepeso; delete from tb_atencioncliente; delete from tb_reportedestinoseguro; delete from tb_itemlegalizacionconceptoviaje; delete from tb_autorizacion; delete from tb_bitacora; delete from tb_itemliquidamanifiesto; delete from tb_liquidamanifiesto; delete from tb_liquidamanifiestocambio; delete from tb_liquidacion; delete from tb_itemcomprobanteegresocambio; delete from tb_itemcomprobanteegreso; delete from tb_comprobanteegresocambio; delete from tb_comprobanteegreso; delete from tb_itemingresocaja; delete from tb_ingresocajacambio; delete from tb_ingresocaja; delete from tb_movimientocaja; delete from tb_caja; delete from tb_bloqueomanifiesto; delete from tb_itemcajaministerio; delete from tb_cajaministerio; delete from tb_carguesolicitudtransporte; delete from tb_itemcartaporteinternacionalcarretera; delete from tb_cartaporteinternacionalcarretera; delete from tb_itemcarteracambio; delete from tb_carteracambio; delete from tb_itemcartera; delete from tb_cartera; delete from tb_itemcarteratransportador; delete from tb_itemcarteratransportadorcambio; delete from tb_carteratransportadorcambio; delete from tb_carteratransportador; delete from tb_itemcausacion; delete from tb_itemcausacioncambio; delete from tb_itemcausacionremesa; delete from tb_itemcausacionremesacambio; delete from tb_itemcausacionpagocambio; delete from tb_itemcausacionpago; delete from tb_causacioncambio; delete from tb_causacion; delete from tb_itemcomprobanteingresocambio; delete from tb_comprobanteingresocambio; delete from tb_itemcomprobanteingreso; delete from tb_comprobanteingreso; delete from tb_itementurnamiento; delete from tb_enturnamiento; delete from tb_itemcumplidomanifiesto; delete from tb_itemcumplidomanifiestoactivo; delete from tb_itemcumplidomanifiestocambio; delete from tb_itemcumplidomanifiestocontenedores; delete from tb_itemcumplidomanifiestoequipo; delete from tb_itemcumplidomanifiestoremesa; delete from tb_itemcumplidomanifiestosobreflete; delete from tb_itemcumplidomanifiestosobrefletecambio; delete from tb_cumplidomanifiestocambio; delete from tb_cumplidomanifiesto; delete from tb_itemmanifiestodocumento; delete from tb_itemremesacontenedor; delete from tb_itemmanifiestocambio; delete from tb_itemmanifiesto; delete from tb_manifiestocambio; delete from tb_itemmanifiestoimpuestocambio; delete from tb_itemmanifiestoimpuesto; delete from tb_itemmanifiestopagocambio; delete from tb_itemmanifiestopago; delete from tb_itemmanifiestoactivo; delete from tb_itemmanifiestoauxiliar; delete from tb_itemmanifiestoequipo; delete from tb_itemmanifiestoguia; delete from tb_itemmanifiestoruta; delete from tb_itemmanifiestoviaje; delete from tb_itemviaje; delete from tb_viaje; update tb_remesa set manifiesto_codigo=null; delete from tb_manifiesto; delete from tb_itemremesacambio; delete from tb_remesacambio; delete from tb_itemremesa; delete from tb_itemremesacontenedor; delete from tb_itemremesacosto; delete from tb_itemremesacostocambio; delete from tb_itemremesaequipo; delete from tb_itemremesavalor; delete from tb_itemremesavalorcambio; delete from tb_itemremesavehiculo; delete from tb_remesa; delete from tb_itemplanrecogida; delete from tb_planrecogidapendiente; delete from tb_planrecogida; delete from tb_itemordencarguecontenedor; delete from tb_itemordencargue; delete from tb_itemordencargueauxiliar; delete from tb_ordencargue; delete from tb_itemsolicitudtransporte; delete from tb_itemviaje; delete from tb_solicitudtransporte; delete from tb_itemvale; delete from tb_itemvalecambio; delete from tb_vale; delete from tb_itemnovedadtrafico; delete from tb_trafico; delete from tb_itemdespacho; delete from tb_despacho; delete from tb_itemcomodato; delete from tb_itemcomodatocostos; delete from tb_comodato; delete from tb_itemconfirmacion; delete from tb_confirmacion; delete from tb_itemcumplidoguia; delete from tb_itemcumplidoguiadescuento; delete from tb_itemcumplidoguiaequipo; delete from tb_cumplidoguia; delete from tb_declaraciontransitoaduanero; --delete from tb_despachador; delete from tb_itemdespacho; delete from tb_despacho; delete from tb_error; delete from tb_itemlegalizacionviaje; delete from tb_legalizacionviaje; delete from tb_viajeempresa; delete from tb_itemfactura; delete from tb_itemfacturaimpuesto; delete from tb_itemfacturaimpuestocambio; delete from tb_itemfacturacambio; delete from tb_facturacambio; delete from tb_factura; delete from tb_itemgiroimpuesto; delete from tb_itemgiroimpuestocambio; delete from tb_itemgiropago; delete from tb_itemgiropagocambio; delete from tb_giro; delete from tb_girocambio; delete from tb_itemguiaacompanamiento; delete from tb_itemguiaacompanamientocambio; delete from tb_itemguiaacompanamientoequipo; delete from tb_guiaacompanamiento; delete from tb_guiaacompanamientocambio; delete from tb_solicitudpagocambio; delete from tb_solicitudpago; delete from tb_digitalizado; delete from tb_historicoimpresion; delete from tb_itemhistoricomoneda; delete from tb_historicomoneda; delete from tb_huella; delete from tb_itemimpresion; delete from tb_impresion; delete from tb_iteminspeccioncontenedor; delete from tb_inspeccioncontenedor; delete from tb_inventario; delete from tb_inventariohistorico; delete from tb_itemdeclaraciontransitoaduanero; delete from tb_itemmanifiestocargainternacional; delete from tb_itemliquidamanifiestocambio; delete from tb_itemmantenimientoequipo; delete from tb_itemmemorando; delete from tb_itemordenservicio; delete from tb_itemordentrabajo; delete from tb_itemordenserviciotarea; delete from tb_ordenservicio; delete from tb_itemnotacontabilidad; delete from tb_itemrodamientohistoricoempresa; delete from tb_manifiestocargainternacional; delete from tb_memorando; delete from tb_memorandoarchivo; delete from tb_ministeriomanifiesto; delete from tb_ministerioremesa; delete from tb_ministeriotercero; delete from tb_ministeriovehiculo; delete from tb_moduloplancuenta; delete from tb_movimiento; delete from tb_movimientocaja; delete from tb_movimientocajacambio; delete from tb_notacontabilidad; delete from tb_novedadcartera; delete from tb_novedaddespacho; delete from tb_ordentrabajo; delete from tb_planillaurbana; delete from tb_presolicitudtransporte; delete from tb_rodamiento; delete from tb_rodamientooperacion; delete from tb_solicitudpagocambio; delete from tb_solicitudpago; delete from tb_consecutivo; delete from tb_eventodocumento; delete from tb_trazabilidad; delete from tb_log; delete from tb_ministerioremesa; delete from tb_ministeriotercero; delete from tb_ministeriovehiculo; delete from tb_resolucion; delete from tb_movimientobanco; delete from tb_movimientocaja; ALTER SEQUENCE "public"."sq_error" INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 RESTART 1 CACHE 1 NO CYCLE;