Cgrajales en 11:32 12 ene 2011

2011-01-12T11:32:41Z

← Revisión anterior		Revisión de 11:32 12 ene 2011
Línea 111:		Línea 111:
	delete from tb_remesa;		delete from tb_remesa;

-	[[~~link en el medio~~]]	+	[[Clientes]]

Cgrajales en 11:31 12 ene 2011

2011-01-12T11:31:33Z

← Revisión anterior		Revisión de 11:31 12 ene 2011
Línea 110:		Línea 110:
	delete from tb_itemremesavehiculo;		delete from tb_itemremesavehiculo;
	delete from tb_remesa;		delete from tb_remesa;
		+
		+	[[link en el medio]]
		+

	delete from tb_itemplanrecogida;		delete from tb_itemplanrecogida;

Cgrajales en 11:12 12 ene 2011

2011-01-12T11:12:16Z

← Revisión anterior		Revisión de 11:12 12 ene 2011
Línea 250:		Línea 250:
	delete from tb_movimientocaja;		delete from tb_movimientocaja;

-	ALTER SEQUENCE sq_error	+	ALTER SEQUENCE sq_error INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 RESTART 1 CACHE 1 NO CYCLE;
-	INCREMENT 1 MINVALUE 1	+
-	MAXVALUE 9223372036854775807 RESTART 1	+
-	CACHE 1 NO CYCLE;	+

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

Cgrajales en 11:11 12 ene 2011

2011-01-12T11:11:33Z

← Revisión anterior		Revisión de 11:11 12 ene 2011
Línea 250:		Línea 250:
	delete from tb_movimientocaja;		delete from tb_movimientocaja;

-	ALTER SEQUENCE ~~"public"."~~sq_error"	+	ALTER SEQUENCE sq_error
	INCREMENT 1 MINVALUE 1		INCREMENT 1 MINVALUE 1
	MAXVALUE 9223372036854775807 RESTART 1		MAXVALUE 9223372036854775807 RESTART 1

Cgrajales en 11:11 12 ene 2011

2011-01-12T11:11:00Z

← Revisión anterior		Revisión de 11:11 12 ene 2011
Línea 1:		Línea 1:
-	~~<nowiki>~~delete from tb_trazabilidad;	+	delete from tb_trazabilidad;
	delete from tb_itematencionclienteestado;		delete from tb_itematencionclienteestado;
	delete from tb_itematencionclientenovedad;		delete from tb_itematencionclientenovedad;
Línea 254:		Línea 254:
	MAXVALUE 9223372036854775807 RESTART 1		MAXVALUE 9223372036854775807 RESTART 1
	CACHE 1 NO CYCLE;		CACHE 1 NO CYCLE;
-	~~</nowiki>~~	+
		+	--[[Usuario:Cgrajales\|Cgrajales]] 11:11 12 ene 2011 (COT)

Cgrajales en 11:10 12 ene 2011

2011-01-12T11:10:24Z

← Revisión anterior		Revisión de 11:10 12 ene 2011
Línea 1:		Línea 1:
-	delete from tb_trazabilidad;	+	<nowiki>delete from tb_trazabilidad;
	delete from tb_itematencionclienteestado;		delete from tb_itematencionclienteestado;
	delete from tb_itematencionclientenovedad;		delete from tb_itematencionclientenovedad;
Línea 250:		Línea 250:
	delete from tb_movimientocaja;		delete from tb_movimientocaja;

-
-	~~-- se reinicia la secuencia de la tabla error~~
	ALTER SEQUENCE "public"."sq_error"		ALTER SEQUENCE "public"."sq_error"
	INCREMENT 1 MINVALUE 1		INCREMENT 1 MINVALUE 1
	MAXVALUE 9223372036854775807 RESTART 1		MAXVALUE 9223372036854775807 RESTART 1
	CACHE 1 NO CYCLE;		CACHE 1 NO CYCLE;
		+	</nowiki>

Cgrajales: Página creada con 'delete from tb_trazabilidad; delete from tb_itematencionclienteestado; delete from tb_itematencionclientenovedad; delete from tb_itematencionclientepeso; delete from tb_atencion...'

2011-01-12T11:09:01Z

Página creada con 'delete from tb_trazabilidad; delete from tb_itematencionclienteestado; delete from tb_itematencionclientenovedad; delete from tb_itematencionclientepeso; delete from tb_atencion...'

Página nueva

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;

-- se reinicia la secuencia de la tabla error
ALTER SEQUENCE "public"."sq_error"
INCREMENT 1 MINVALUE 1
MAXVALUE 9223372036854775807 RESTART 1
CACHE 1 NO CYCLE;

Script Para Inicializar Bases de Datos - Historial de revisiones

Cgrajales en 11:32 12 ene 2011

Cgrajales en 11:31 12 ene 2011

Cgrajales en 11:12 12 ene 2011

Cgrajales en 11:11 12 ene 2011

Cgrajales en 11:11 12 ene 2011

Cgrajales en 11:10 12 ene 2011

Cgrajales: Página creada con 'delete from tb_trazabilidad; delete from tb_itematencionclienteestado; delete from tb_itematencionclientenovedad; delete from tb_itematencionclientepeso; delete from tb_atencion...'