Script Para Inicializar Bases de Datos

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;

--[[Usuario:Cgrajales|Cgrajales]] 11:11 12 ene 2011 (COT)