===20120702===
====Agregado de atributo de Medicion en Obra [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`vidquoten1` 
	ADD COLUMN `VidQuoteMedCheck` CHAR(1) NULL DEFAULT 0 AFTER `VidQuoteACom`;
</pre>
*20120926.1616 [[File:checked.png|20px]]

====Actualización de dato de Vigencia de Documentos [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`contactos`
	CHANGE COLUMN `CoeficienteAC` `CoeficienteAC` DECIMAL(5,2) NULL DEFAULT 1,
	CHANGE COLUMN `VigenciaDocs` `VigenciaDocs` INT(2) NULL DEFAULT 15;
UPDATE `fzggestion`.`contactos`
	SET `VigenciaDocs` = 15
	WHERE `VigenciaDocs`= 0 OR ISNULL(`VigenciaDocs`);
</pre>
*20120926.1634 [[File:checked.png|20px]]

====Actualización de datos para el control de Cobranzas [[File:checked.png|20px]]====
ALTER TABLE `fzggestion`.`accreceiv` 
	ADD COLUMN `ClienteAR` CHAR(8) NULL DEFAULT NULL  AFTER `ImporteAR`,
	DROP PRIMARY KEY,
	ADD PRIMARY KEY (`TTransaccion`, `NTransaccion`);
*20120926.1651 [[File:checked.png|20px]]

====Crear [[VISTA:vistranscrm]] [[File:checked.png|20px]]====
*2012092616.55 [[File:checked.png|20px]]

====Crear [[TABLA:clientescrmqry]] [[File:checked.png|20px]] ====
*20120926 [[File:checked.png|20px]]

====Crear [[VISTA:chqactivos]] [[File:checked.png|20px]]====
*20120926.1758 [[File:checked.png|20px]]

====Crear [[TABLA:accpayab]] [[File:checked.png|20px]]====
<pre>
delimiter $$
CREATE TABLE `accpayab` (
  `TTransaccion` char(2) NOT NULL DEFAULT 'AP',
  `NTransaccion` int(11) NOT NULL AUTO_INCREMENT,
  `FechaAutAP` date DEFAULT NULL,
  `FechaAP` date DEFAULT NULL,
  `FormaAP` char(3) DEFAULT NULL,
  `ImporteAP` decimal(10,2) DEFAULT NULL,
  `ProveedAP` char(8) DEFAULT NULL,
  `TDocumentoOrg` char(2) DEFAULT NULL,
  `NDocumentoOrg` int(11) DEFAULT NULL,
  `DDocumentoOrg` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`TTransaccion`,`NTransaccion`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1$$

CREATE TRIGGER `fzggestion`.`Alta_Pago`
BEFORE INSERT ON `fzggestion`.`accpayab`
FOR EACH ROW
BEGIN
	SET NEW.FechaAutAP = CURDATE();
END
$$
</pre>
*20120926.1804 [[File:checked.png|20px]]

====Modifica [[TABLA:fPago]] [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`fpago`
	ADD COLUMN `FPagoAR` CHAR(1) NULL AFTER `FPagoDSC`,
	ADD COLUMN `FPagoAP` CHAR(1) NULL AFTER `FPagoAR`;
</pre>
*20120926.1808 [[File:checked.png|20px]]

====Rediseña [[TABLA:tdocumento]]====

====Crea [[VISTA:vischtdisp]] [[File:checked.png|20px]]====
*20120926.1835 [[File:checked.png|20px]]

====Crea [[VISTA:vistotprod]] [[File:checked.png|20px]]====
*20120926.1836 [[File:checked.png|20px]]

====Crea [[TABLA:vidquoten3tmp]] [[File:checked.png|20px]]====
*20120926.1902 [[File:checked.png|20px]]

====Reemplazar todos los ElementoPM en Componentes por los nuevos valores [[File:checked.png|20px]]====
<pre>
UPDATE fzggestion.composicion SET ElementoPM=2 WHERE ElementoPM=0;
UPDATE fzggestion.composicion SET ElementoPM=0 WHERE ElementoPM=1;
</pre>
*20120926.1908 [[File:checked.png|20px]]
===20120831===

====Agregar Nombre de Usuario [[TABLA:precios]] [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`precios` 
	ADD COLUMN `UserModificacion` VARCHAR(20) NULL AFTER `HoraModificacion` ;
ALTER TABLE `fzggestion`.`precios` 
	CHANGE COLUMN `FechaModificacion` `FechaEvento` DATE NULL DEFAULT NULL,
	CHANGE COLUMN `HoraModificacion` `HoraEvento` TIME NULL DEFAULT NULL,
	CHANGE COLUMN `UserModificacion` `UserEvento` VARCHAR(20) NULL DEFAULT NULL;
</pre>
*20120926.1915 [[File:checked.png|20px]]

====Modificación de Triggers [[TABLA:precios]] [[File:checked.png|20px]]====
<pre>
DELIMITER $$

USE `fzggestion`$$

CREATE
DEFINER=`sas_admin`@`%`
TRIGGER `fzggestion`.`Alta_Precio`
BEFORE INSERT ON `fzggestion`.`precios`
FOR EACH ROW
BEGIN
	SET
	NEW.FechaEvento = CURDATE(),
	NEW.HoraEvento = CURTIME(),
	NEW.UserEvento	= USER();
END$$

CREATE
DEFINER=`sas_admin`@`%`
TRIGGER `fzggestion`.`Actualiza_Precio`
BEFORE UPDATE ON `fzggestion`.`precios`
FOR EACH ROW
BEGIN
	SET
	NEW.FechaEvento = CURDATE(),
	NEW.HoraEvento = CURTIME(),
	NEW.UserEvento	= USER();
END$$
</pre>
*20120926.1924 [[File:checked.png|20px]]

====Modificacion de Estructura [[TABLA:contactos]] [[File:checked.png|20px]]====
<pre>
UPDATE contactos SET ClienteTag=1 WHERE ClienteTag="x";
UPDATE contactos SET ProveedorTag=1 WHERE ProveedorTag="x";
UPDATE contactos SET AComercialTag=1 WHERE AComercialTag="x";
UPDATE contactos SET OtrosTag=1 WHERE OtrosTag="x";
ALTER TABLE `fzggestion`.`contactos` 
	CHANGE COLUMN `ClienteTag` `ClienteTag` INT(1) NULL DEFAULT NULL,
	CHANGE COLUMN `ProveedorTag` `ProveedorTag` INT(1) NULL DEFAULT NULL, 
	CHANGE COLUMN `AComercialTag` `AComercialTag` INT(1) NULL DEFAULT NULL,
	CHANGE COLUMN `OtrosTag` `OtrosTag` INT(1) NULL DEFAULT NULL;
</pre>
*20120926.1927 [[File:checked.png|20px]]
Verificar los casos que no coincidan con los prefijos establecidos: 0->Cliente, 3->Proveedor, 5->Otros, 8->Agentes Comerciales
*20120926.1928 No se verificó [[File:warning-icon-hi.png|20px]]

====Agrega Atributo [[TABLA:contactos]] [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`contactos` ADD COLUMN `ImgContacto` BLOB NULL  AFTER `VigenciaDocs` ;
</pre>
*20120926.1939 [[File:checked.png|20px]]
====Cambio de Condición para [[VISTA:clientes]] [[File:checked.png|20px]]====
*20120926.1942 [[File:checked.png|20px]]

====Alta de Tabla [[TABLA:telemecomp]] [[File:checked.png|20px]]====
*20120926.1957
** Alta generada [[File:checked.png|20px]]
** Falta ingresar los datos [[File:warning-icon-hi.png|20px]]

====Actualizar Routine [[PROC:DuplicaProductoCompo]] en DB [[File:checked.png|20px]]====
*20120926.2007 [[File:checked.png|20px]]

====Agregar atributo ComposicID a [[TABLA:vidquoten3]] [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`vidquoten3` 
CHANGE COLUMN `VidQuoteElementoID` `VidQuoteElementoID` CHAR(8) NOT NULL AFTER `VidQuoteProdID`,
CHANGE COLUMN `VidQuoteLPre` `VidQuoteLPre` INT(1) NULL DEFAULT NULL AFTER `VidQuoteElementoID;

ALTER TABLE `fzggestion`.`vidquoten3`
ADD COLUMN `VidQuoteComposicID` INT NOT NULL AFTER `VidQuoteElementoID` ,
DROP PRIMARY KEY , ADD PRIMARY KEY (`VidQuoteID`,
                                    `VidQuoteItem`,
                                    `VidQuoteProdID`,
                                    `VidQuoteElementoID`,
                                    `VidQuoteComposicID`) ;
</pre>
*20120927.2014 [[File:checked.png|20px]]

====Agregar atributo ComposicID a [[TABLA:vidquoten3tmp]] [[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`vidquoten3tmp` 
CHANGE COLUMN `VidQuoteElementoID` `VidQuoteElementoID` CHAR(8) NOT NULL AFTER `VidQuoteProdID`,
CHANGE COLUMN `VidQuoteProdCantidad` `VidQuoteProdCantidad` INT(5) NULL DEFAULT NULL  AFTER `VidQuoteElementoID`;

ALTER TABLE `fzggestion`.`vidquoten3tmp`
ADD COLUMN `VidQuoteComposicID` INT NOT NULL AFTER `VidQuoteElementoID` ,
DROP PRIMARY KEY , ADD PRIMARY KEY (`VidQuoteID`,
                                    `VidQuoteItem`,
                                    `VidQuoteProdID`,
                                    `VidQuoteElementoID`,
                                    `VidQuoteComposicID`) ;
</pre>
*20120926.2015 [[File:checked.png|20px]]

====Agregar atributo ElementoPM a [[TABLA:vidquoten3tmp]][[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`vidquoten3tmp` ADD COLUMN `VidQuoteElementoPM` INT(1) NULL  AFTER `VidQuoteComposicID` ;
</pre>
*[[20121004.1617]][[File:checked.png|20px]]

====Agregar atributo ElementoPM a [[TABLA:vidquoten3]][[File:checked.png|20px]]====
<pre>
ALTER TABLE `fzggestion`.`vidquoten3` ADD COLUMN `VidQuoteElementoPM` INT(1) NULL  AFTER `VidQuoteComposicID` ;
</pre>
*20121004.1621 [[File:checked.png|20px]]

====Reemplazar el código de [[PROC:GrabaItemPresupuestoTmp]][[File:checked.png|20px]] y [[PROC:AltaItemPresupuestoTmp]][[File:checked.png|20px]]====
Incluye las modificaciones de inclusión de ElementoPM
*20121004.1625 [[PROC:GrabaItemPresupuestoTmp]][[File:checked.png|20px]]
*20121004.1630 [[PROC:GrabaItemPresupuestoTmp]][[File:checked.png|20px]]

====Crea [[PROC:ResetEdicionItemTmp]][[File:checked.png|20px]]====
*20121004.1655 [[File:checked.png|20px]]

====Cambiar [[VISTA:acomerciales]][[File:checked.png|20px]]====
Refleja el cambio de la estructura de la [[TABLA:contactos]]
*20121004.1657 [[File:checked.png|20px]]

====Agregar en [[TABLA:contactos]]====
Agregar atributo que responde al imagen asociada al contacto.
<pre>
ALTER TABLE `fzggestion`.`contactos` ADD COLUMN `ImgContacto` BLOB NULL  AFTER `VigenciaDocs` ;
</pre>
====Alta del [[TRIG:Actualiza_Item_Presupuesto]]====
====Renovación del [[PROC:ActualizaPreciosPresupuesto]]====
====Renovación del [[PROC:ActualizaItemPresupuesto]]====
====Renovación del [[PROC:CopiaPresupuesto]]====
====Cambios estructura del [[PROC:GrabaItemPresupuestoTmp]][[File:checked.png|20px]]====
*20121004.1625 [[File:checked.png|20px]]