Script Para Inicializar Bases de Datos

De ColombiaSoftware

Última versión de 11:32 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;

Clientes

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 sq_error INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 RESTART 1 CACHE 1 NO CYCLE;

--Cgrajales 11:11 12 ene 2011 (COT)