9
/* Probar que no existan movimientos huerfanos (Querys deberian retornar 0 filas)*/
// actAccountEntry in (3391,3801,4590,4591,4594,4913, 3523) -- payPayment in (776) -- colAccountsReceivable in (1208)

select * from colAccountsReceivable where codConcept <> 110 and fldParentComponent = 'ComponentSalesNote';

SELECT * FROM actAccountEntry WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,colEarlyPayment AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyPayment' AND T1.cosComponentKey = T2.pkyEarlyPayment AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,colCollection AS T2 WHERE T1.fldParentComponent = 'ComponentCollection' AND T1.cosComponentKey = T2.pkyCollection AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,colAccountsReceivable AS T2 WHERE T1.fldParentComponent = 'ComponentAccountsReceivable' AND T1.cosComponentKey = T2.pkyAccountsReceivable AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,payEarlyCollection AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyCollection' AND T1.cosComponentKey = T2.pkyEarlyCollection AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,payAccountsPayable AS T2 WHERE T1.fldParentComponent = 'ComponentAccountsPayable' AND T1.cosComponentKey = T2.pkyAccountsPayable AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,payPayment AS T2 WHERE T1.fldParentComponent = 'ComponentPayment' AND T1.cosComponentKey = T2.pkyPayment AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,ptcCurrencyExchange AS T2 WHERE T1.fldParentComponent = 'ComponentCurrencyExchange' AND T1.cosComponentKey = T2.pkyCurrencyExchange AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,ptcPettyCashMovement AS T2 WHERE T1.fldParentComponent = 'ComponentPettyCashMovement' AND T1.cosComponentKey = T2.pkyPettyCashMovement AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,tryCheckDeposit AS T2 WHERE T1.fldParentComponent = 'ComponentCheckDeposit' AND T1.cosComponentKey = T2.pkyCheckDeposit AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,tryBankMovement AS T2 WHERE T1.fldParentComponent = 'ComponentBankMovement' AND T1.cosComponentKey = T2.pkyBankMovement AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,invItemMovement AS T2 WHERE T1.fldParentComponent = 'ComponentItemMovement' AND T1.cosComponentKey = T2.pkyItemMovement AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,prdProductionOrder AS T2 WHERE T1.fldParentComponent = 'ComponentProductionOrder' AND T1.cosComponentKey = T2.pkyProductionOrder AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,pchPayrollExpenses AS T2 WHERE T1.fldParentComponent = 'ComponentPayrollExpenses' AND T1.cosComponentKey = T2.pkyPayrollExpenses AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,pchReceiptOfGoods AS T2 WHERE T1.fldParentComponent = 'ComponentReceiptOfGoods' AND T1.cosComponentKey = T2.pkyReceiptOfGoods AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;
SELECT * FROM actAccountEntry AS T1,slsSalesNote AS T2 WHERE T1.fldParentComponent = 'ComponentSalesNote' AND T1.cosComponentKey = T2.pkySalesNote AND (T2.codAccountEntry IS NULL OR T2.codAccountEntry = 0) AND T2.sysEnabled = 1;

SELECT * FROM colEarlyPayment WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM colCollection WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM colAccountsReceivable WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM colAccountsReceivable AS T1,colEarlyPayment AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyPayment' AND T1.cosComponentKey = T2.pkyEarlyPayment AND (T2.codAccountsReceivable IS NULL OR T2.codAccountsReceivable = 0) AND T2.sysEnabled = 1;
SELECT * FROM colAccountsReceivable AS T1,slsSalesNote AS T2 WHERE T1.fldParentComponent = 'ComponentSalesNote' AND T1.cosComponentKey = T2.pkySalesNote AND (T2.codAccountReceivable IS NULL OR T2.codAccountReceivable = 0) AND T2.sysEnabled = 1;
SELECT * FROM payEarlyCollection WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM payPayment WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM payAccountsPayable WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM payAccountsPayable AS T1,payEarlyCollection AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyCollection' AND T1.cosComponentKey = T2.pkyEarlyCollection AND (T2.codAccountsPayable IS NULL OR T2.codAccountsPayable = 0) AND T2.sysEnabled = 1;
SELECT * FROM payAccountsPayable AS T1,pchPayrollExpenses AS T2 WHERE T1.fldParentComponent = 'ComponentPayrollExpenses' AND T1.cosComponentKey = T2.pkyPayrollExpenses AND (T2.codAccountPayable IS NULL OR T2.codAccountPayable = 0) AND T2.sysEnabled = 1;
SELECT * FROM payAccountsPayable AS T1,pchReceiptOfGoods AS T2 WHERE T1.fldParentComponent = 'ComponentReceiptOfGoods' AND T1.cosComponentKey = T2.pkyReceiptOfGoods AND (T2.codAccountPayable IS NULL OR T2.codAccountPayable = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcCurrencyExchange WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,colEarlyPayment AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyPayment' AND T1.cosComponentKey = T2.pkyEarlyPayment AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,colCollection AS T2 WHERE T1.fldParentComponent = 'ComponentCollection' AND T1.cosComponentKey = T2.pkyCollection AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,payEarlyCollection AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyCollection' AND T1.cosComponentKey = T2.pkyEarlyCollection AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;


SELECT * FROM ptcPettyCashMovement AS T1,ptcCurrencyExchange AS T2 WHERE T1.fldParentComponent = 'ComponentCurrencyExchange' AND T1.cosComponentKey = T2.pkyCurrencyExchange AND (T2.codPettyCashOutMovement IS NULL OR T2.codPettyCashOutMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,tryBankMovement AS T2 WHERE T1.fldParentComponent = 'ComponentBankMovement' AND T1.cosComponentKey = T2.pkyBankMovement AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,pchPayrollExpenses AS T2 WHERE T1.fldParentComponent = 'ComponentPayrollExpenses' AND T1.cosComponentKey = T2.pkyPayrollExpenses AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM ptcPettyCashMovement AS T1,slsSalesNote AS T2 WHERE T1.fldParentComponent = 'ComponentSalesNote' AND T1.cosComponentKey = T2.pkySalesNote AND (T2.codPettyCashMovement IS NULL OR T2.codPettyCashMovement = 0) AND T2.sysEnabled = 1;

SELECT * FROM tryCheckDeposit WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM tryBankMovement WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM tryBankMovement AS T1,colEarlyPayment AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyPayment' AND T1.cosComponentKey = T2.pkyEarlyPayment AND (T2.codBankMovement IS NULL OR T2.codBankMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM tryBankMovement AS T1,colCollection AS T2 WHERE T1.fldParentComponent = 'ComponentCollection' AND T1.cosComponentKey = T2.pkyCollection AND (T2.codBankMovement IS NULL OR T2.codBankMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM tryBankMovement AS T1,payEarlyCollection AS T2 WHERE T1.fldParentComponent = 'ComponentEarlyCollection' AND T1.cosComponentKey = T2.pkyEarlyCollection AND (T2.codBankMovement IS NULL OR T2.codBankMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM tryBankMovement AS T1,payPayment AS T2 WHERE T1.fldParentComponent = 'ComponentPayment' AND T1.cosComponentKey = T2.pkyPayment AND (T2.codBankMovement IS NULL OR T2.codBankMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM tryBankMovement AS T1,slsSalesNote AS T2 WHERE T1.fldParentComponent = 'ComponentSalesNote' AND T1.cosComponentKey = T2.pkySalesNote AND (T2.codBankMovement IS NULL OR T2.codBankMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM invItemMovement WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM invItemMovement AS T1,prdProductionOrder AS T2 WHERE T1.fldParentComponent = 'ComponentProductionOrder' AND T1.cosComponentKey = T2.pkyProductionOrder AND (T2.codItemMovementIn IS NULL OR T2.codItemMovementIn = 0) AND T2.sysEnabled = 1;
SELECT * FROM invItemMovement AS T1,prdProductionOrder AS T2 WHERE T1.fldParentComponent = 'ComponentProductionOrder' AND T1.cosComponentKey = T2.pkyProductionOrder AND (T2.codItemMovementOut IS NULL OR T2.codItemMovementOut = 0) AND T2.sysEnabled = 1;
SELECT * FROM invItemMovement AS T1,pchReceiptOfGoods AS T2 WHERE T1.fldParentComponent = 'ComponentReceiptOfGoods' AND T1.cosComponentKey = T2.pkyReceiptOfGoods AND (T2.codItemMovement IS NULL OR T2.codItemMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM invItemMovement AS T1,slsSalesNote AS T2 WHERE T1.fldParentComponent = 'ComponentSalesNote' AND T1.cosComponentKey = T2.pkySalesNote AND (T2.codItemMovement IS NULL OR T2.codItemMovement = 0) AND T2.sysEnabled = 1;
SELECT * FROM txsSalesLedger WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;
SELECT * FROM txsPurchasesLedger WHERE fldParentComponent <> '' AND fldParentComponent IS NOT NULL AND (cosComponentKey IS NULL OR cosComponentKey = '' OR cosComponentKey = '0') AND sysEnabled = 1;

select * from payPaymentDetail where codAccountsPayable IS NULL  and codAccountsReceivable IS NULL and sysEnabled = 1;
SELECT * FROM payAccountsPayable WHERE fldBalance < 0 and sysEnabled =1;
SELECT * FROM colAccountsReceivable WHERE fldBalance < 0 and sysEnabled =1;
select * from payPaymentDetail where codAccountsPayable in(select pkyAccountsPayable from payAccountsPayable where fldBalance < 0) and sysEnabled = 1;
select * from payPaymentDetail where codAccountsReceivable in(select pkyAccountsReceivable from colAccountsReceivable where fldBalance < 0) and sysEnabled = 1;

14903801.6250000000 
/* Copiar permisos de otro cliente */
INSERT INTO _AccessList  (SELECT NULL,10024,codSystemObject,fldRead FROM _AccessList WHERE codClient = 10011);

/* Agregar permisos */
INSERT INTO _AccessList  values (NULL,10001,107239,1);
INSERT INTO _AccessList  values (NULL,10001,108239,1);
INSERT INTO _AccessList  values (NULL,10001,107240,1);
INSERT INTO _AccessList  values (NULL,10001,108240,1);
INSERT INTO _AccessList  values (NULL,10001,107241,1);
INSERT INTO _AccessList  values (NULL,10001,108241,1);
INSERT INTO _AccessList  values (NULL,10001,107242,1);
INSERT INTO _AccessList  values (NULL,10001,108242,1);
INSERT INTO _AccessList  values (NULL,10001,107243,1);
INSERT INTO _AccessList  values (NULL,10001,108243,1);
INSERT INTO _AccessList  values (NULL,10001,107244,1);
INSERT INTO _AccessList  values (NULL,10001,108244,1);
INSERT INTO _AccessList  values (NULL,10001,107245,1);
INSERT INTO _AccessList  values (NULL,10001,108245,1);
INSERT INTO _AccessList  values (NULL,10001,107246,1);
INSERT INTO _AccessList  values (NULL,10001,108246,1);
INSERT INTO _AccessList  values (NULL,10001,107247,1);
INSERT INTO _AccessList  values (NULL,10001,108247,1);
INSERT INTO _AccessList  values (NULL,10001,107248,1);
INSERT INTO _AccessList  values (NULL,10001,108248,1);
INSERT INTO _AccessList  values (NULL,10001,107249,1);
INSERT INTO _AccessList  values (NULL,10001,108249,1);
INSERT INTO _AccessList  values (NULL,10001,107250,1);
INSERT INTO _AccessList  values (NULL,10001,108250,1);

INSERT INTO _AccessList  values (NULL,10001,205233,1);
INSERT INTO _AccessList  values (NULL,10001,205234,1);
INSERT INTO _AccessList  values (NULL,10001,205235,1);
INSERT INTO _AccessList  values (NULL,10001,205236,1);
INSERT INTO _AccessList  values (NULL,10001,205237,1);
INSERT INTO _AccessList  values (NULL,10001,205238,1);
INSERT INTO _AccessList  values (NULL,10001,205239,1);
INSERT INTO _AccessList  values (NULL,10001,205240,1);
INSERT INTO _AccessList  values (NULL,10001,205241,1);
INSERT INTO _AccessList  values (NULL,10001,205242,1);
INSERT INTO _AccessList  values (NULL,10001,205243,1);
INSERT INTO _AccessList  values (NULL,10001,205244,1);

/*Borrar transacciones */
DELETE FROM dbaUserLog;
DELETE FROM comMessage;
DELETE FROM accAuthorization;
DELETE FROM srvUserTask;
DELETE FROM srvTaskScheduler;
DELETE FROM slsSalesNote;
DELETE FROM slsOrderNote;
DELETE FROM slsOrderNoteTransfer;
DELETE FROM slsServiceProductRemoval;
UPDATE slsOrderNoteCounterfoilDetail SET codStatus = 5;
DELETE FROM vhcVehicleContract;
DELETE FROM hrsSalaryReimbursement;
UPDATE agnPerson SET codDocumentNumber = NULL;
DELETE FROM hrsEmployeeMovement;
DELETE FROM hrsTaxesForm;
DELETE FROM hrsVacation;
DELETE FROM hrsWorkedTime;
DELETE FROM hrsBonusDiscount;
DELETE FROM hrsOvertime;
DELETE FROM hrsSalaryPayroll;
DELETE FROM fasFixedAssetMovement;
DELETE FROM fasFixedAssetValueUpdate;
DELETE FROM fasFixedAssetDepreciation;
DELETE FROM fasFixedAsset;

DELETE FROM invTransferExpense;
DELETE FROM pchPurchaseRequest;
DELETE FROM pchRequestAuthorization;
DELETE FROM pchPayrollExpenses;
DELETE FROM pchReceiptOfGoods;
DELETE FROM pchImportDocument;
DELETE FROM pchPurchaseOrder;
DELETE FROM prdPreproductionNote;
DELETE FROM prdProductionOrder;
DELETE FROM prdProductionProjection;
DELETE FROM payPayment;
DELETE FROM payEarlyCollection;
DELETE FROM payAccountsPayable;
DELETE FROM pchImportDocument;
DELETE FROM colEarlyPayment;
DELETE FROM colCollection;
DELETE FROM colAccountsReceivable;

DELETE FROM txsBillingSalesPlace;
DELETE from txsPurchasesLedger;
DELETE from txsSalesLedger;
DELETE from txsTicket;
DELETE from txsDiscountsDevolutions;
DELETE FROM txsAuthorizationControl;

DELETE FROM tryCheckDeposit;
DELETE FROM tryCheck;
DELETE FROM tryBankMovement;
UPDATE tryBankDetail SET fldBalance = 0;
DELETE FROM ptcCurrencyExchange;
DELETE FROM ptcPettyCashMovement;
UPDATE ptcPettyCashDetail SET fldBalance = 0;
DELETE FROM invItemMovementConsolidated;
DELETE FROM invItemMovement;
DELETE FROM invItemBatch;
DELETE FROM actFiscalYearClosure; 
DELETE FROM actExchangeRateAdjustment;
DELETE FROM actAccountEntry;
DELETE FROM actFiscalYear;
DELETE FROM actExchangeRate;
DELETE FROM srvBlob;

1.0.6pre1
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=FALSE;
DROP TABLE slsPriceList;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.6pre2  **Arxen**
drop table slsOrderNoteCounterfoilDetail;
drop table slsOrderNoteCounterfoil;
delete from slsOrderNoteStatus;
drop table slsOrderNoteDetail;
drop table slsOrderNote;

1.0.6pre3
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM invItemMovementTypeConcept;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.6   
DELETE FROM srvComponent;
DROP TABLE slsOrderNoteCounterfoilDetail;
DROP TABLE slsOrderNoteCounterfoil;
DROP TABLE slsOrderNoteDetail;
DROP TABLE slsOrderNote;
DROP TABLE colAccountsReceivable;
DROP TABLE slsSalesPlace;
------------------------------------------
1.0.7pre1
/* Configuracion de ventas : Tipo de pedido por defecto, glosa por defecto, control de correlativo
   Transferencia de pedidos
   Ya no deberia colgarse al introducir varios pedidos 
   Se aumentó regla para que en el asiento del pedido prorratee tipo de centro de costo ciudad tomando en cuenta la ciudad del almacen*/
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM actTransactionApportionRule
DELETE FROM srvComponent
DELETE FROM slsOrderNoteStatus;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.7pre2   
/* Caja */
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM actTransactionApportionRule
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.7pre3    
/*Mov Banco*/
ALTER TABLE actExchangeRate ADD COLUMN fldExclusive BOOL NOT NULL DEFAULT '0'  AFTER fldTime;
CREATE INDEX indExchangeRateExclusive ON actExchangeRate (fldExclusive);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DROP TABLE tryBankDetail;
DROP TABLE tryBank;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.7  
Primero debe realizarse el upgrade y sincronizar la base 
luego lo siguiente :

(El siguiente parrafo todo en una linea )
/****/
ALTER TABLE agnCompany ADD COLUMN codChannel SMALLINT UNSIGNED NOT NULL DEFAULT '1'  AFTER codPriceList, 
  ADD CONSTRAINT fkyCompanyChannel FOREIGN KEY (codChannel) REFERENCES agnChannel (pkyChannel)
  ON DELETE RESTRICT ON UPDATE RESTRICT;
/****/

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM actTransactionApportionRule;
DELETE FROM tryCheckStatus;
DELETE FROM srvComponent;
DELETE FROM tryBankMovement;
DELETE FROM tryBankMovementTypeConcept;
SET FOREIGN_KEY_CHECKS=TRUE;

Sincronizar la base de nuevo

1.0.8pre1
/*
Cuentas x cobrar
*/
SET FOREIGN_KEY_CHECKS=FALSE;
DROP TABLE colCollectionDetail;
DROP TABLE colCollection;
DROP TABLE colAccountsReceivable;
DELETE FROM actTransactionApportionRule;
DELETE FROM srvComponent;
ALTER TABLE colAccountsReceivableConcept DROP FOREIGN KEY fkyAccountsReceivableConceptCostCenter;
ALTER TABLE colAccountsReceivableConcept CHANGE COLUMN codCostCenter codCostCenter MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL , 
  ADD CONSTRAINT fkyAccountsReceivableConceptCostCenter FOREIGN KEY (codCostCenter)
  REFERENCES actCostCenter (pkyCostCenter);
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.8pre2 
ALTER TABLE ptcPettyCashMovementTypeConcept DROP FOREIGN KEY fkyPettyCashMovementTypeConceptAccount;
ALTER TABLE ptcPettyCashMovementTypeConcept CHANGE COLUMN codAccount codAccount BIGINT(20) UNSIGNED NULL DEFAULT NULL  , 
  ADD CONSTRAINT fkyPettyCashMovementTypeConceptAccount
  FOREIGN KEY (codAccount)
  REFERENCES actAccount(pkyAccount);
ALTER TABLE colIncomeConcept DROP FOREIGN KEY fkyIncomeConceptAccount;
ALTER TABLE colIncomeConcept CHANGE COLUMN codAccount codAccount BIGINT(20) UNSIGNED NULL DEFAULT NULL, 
  ADD CONSTRAINT fkyIncomeConceptAccount
  FOREIGN KEY (codAccount)
  REFERENCES actAccount (pkyAccount);
SET FOREIGN_KEY_CHECKS=FALSE;
DROP TABLE slsSalesConfig;
DELETE FROM srvComponent;
DELETE FROM actTransactionApportionRule;
INSERT INTO colIncomeConcept VALUES(1,'Tarjeta de crédito',NULL,NULL,1,0,1,2,0,1);
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(2,2,'Egreso por anticipo',NULL,'Egreso por anticipo',1,0,1,2,0,1);
INSERT INTO tryBankMovementTypeConcept VALUES(1,1,'Abono desde caja',NULL,'Abono desde caja',1,0,1,2,0,1);  
INSERT INTO tryBankMovementTypeConcept VALUES(2,1,'Abono por CxC',NULL,'Abono por CxC',1,0,1,2,0,1);
INSERT INTO tryBankMovementTypeConcept VALUES(3,2,'Egreso por anticipo',NULL,'Egreso por anticipo',1,0,1,2,0,1);
INSERT INTO colIncomeConcept VALUES(2,'Anticipo',NULL,NULL,1,0,1,2,0,1);
DROP TABLE tryCheckDepositDetail;
DROP TABLE colCollectionDetail;
DROP TABLE colCollection;
DROP TABLE colEarlyPayment;
DROP TABLE tryCheck;
DELETE FROM slsOrderNote;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.8pre3
/*
Cuentas x cobrar
*/
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.8pre4
/*
Notas de preproduccion
*/

1.0.8 
/*
 Ordenes de produccion
 CxP
 */

DROP TABLE prdProductionOrderDetailRecipe;
DROP TABLE prdProductionOrderDetail;
DROP TABLE prdProductionOrder;
ALTER TABLE prdRecipeDetail CHANGE COLUMN fldQuantity fldQuantity DECIMAL(30,10) UNSIGNED NOT NULL DEFAULT '1'  ;
ALTER TABLE prdPreproductionNoteDetailRecipe CHANGE COLUMN fldQuantity fldQuantity DECIMAL(30,10) UNSIGNED NOT NULL DEFAULT '1'  ;
ALTER TABLE prdProductionOrderDetailRecipe CHANGE COLUMN fldQuantity fldQuantity DECIMAL(30,10) UNSIGNED NOT NULL DEFAULT '1'  ;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM invItemMovementTypeConcept;
DELETE FROM actTransactionApportionRule;
SET FOREIGN_KEY_CHECKS=TRUE;


1.0.9pre1 
/*
 Pagos
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DELETE FROM actTransactionApportionRule;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(3,2,'Egreso por CxP',NULL,'Egreso por CxP',1,0,1,2,0,1);
INSERT INTO tryBankMovementTypeConcept VALUES(4,2,'Egreso por CxP',NULL,'Egreso por CxP',1,0,1,2,0,1);
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.9pre2
/*
 Pagos
 */

ALTER TABLE payAccountsPayable ADD COLUMN codInvoice BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codAccountEntry ;
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayableInvoice FOREIGN KEY (codInvoice)
  REFERENCES txsPurchasesLedger (pkyPurchasesLedger) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyAccountsPayableInvoice (codInvoice ASC) ;
DELETE FROM payPaymentRoute WHERE pkyPaymentRoute = 4;

1.0.9 **Flor de Caña** 
/*
 Anticipo Pagos
 Anulacion Pagos
 Registro factura posterior
 */
/*** Renovar Licencia ***/

ALTER TABLE payExpensesConcept DROP FOREIGN KEY fkyExpensesConceptAccount;
ALTER TABLE payExpensesConcept CHANGE COLUMN codAccount codAccount BIGINT(20) UNSIGNED NULL DEFAULT NULL, 
  ADD CONSTRAINT fkyExpensesConceptAccount
  FOREIGN KEY (codAccount)
  REFERENCES actAccount (pkyAccount);
ALTER TABLE payAccountsPayable ADD COLUMN codPendingTaxAccountEntry BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codInvoice ;
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayablePendingTaxAccountEntry FOREIGN KEY (codPendingTaxAccountEntry)
  REFERENCES actAccountEntry (pkyAccountEntry) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyAccountsPayablePendingTaxAccountEntry (codPendingTaxAccountEntry ASC) ;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(4,1,'Ingreso por anticipo',NULL,'Ingreso por anticipo',1,0,1,2,0,1);
INSERT INTO payExpensesConcept VALUES(1,'Gasto X Anticipo',NULL,NULL,1,0,1,2,0,1);
INSERT INTO tryBankMovementTypeConcept VALUES(5,1,'Abono por anticipo',NULL,'Abono por anticipo',1,0,1,2,0,1);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DELETE FROM actTransactionApportionRule;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.10pre1 
/*
 Ordenes de compra
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=FALSE;

1.0.10pre2 
/*
 Ordenes de compra con CxP
 Recepciones
 */

DROP TABLE pchPurchasesConfig;
DROP TABLE pchReceiptOfGoodsDetail;
DROP TABLE pchReceiptOfGoods;
DROP TABLE pchPurchaseOrderDetail;
DROP TABLE pchPurchaseOrder;
ALTER TABLE payAccountsPayableConcept DROP FOREIGN KEY fkyAccountsPayableConceptCostCenter;
ALTER TABLE payAccountsPayableConcept CHANGE COLUMN codCostCenter codCostCenter MEDIUMINT UNSIGNED NULL DEFAULT NULL, 
  ADD CONSTRAINT fkyAccountsPayableConceptCostCenter
  FOREIGN KEY (codCostCenter)
  REFERENCES actCostCenter (pkyCostCenter);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM actTransactionApportionRule;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.10   
/*
 * Tipo de dscto en orden de compra
 * Datos de cliente para imbex
 */

ALTER TABLE agnCompany ADD COLUMN fldCreditDays MEDIUMINT UNSIGNED NOT NULL DEFAULT '0' AFTER codChannel ;
DROP TABLE pchReceiptOfGoodsDetail;
DROP TABLE pchReceiptOfGoods;
DROP TABLE pchPurchaseOrderDetail;
DROP TABLE pchPurchaseOrder;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM agnAddressType;
DELETE FROM agnPhoneType;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.11pre1  ** Imbex **
/*
 * Corrección de procesamiento de tipo de documento en mercadería recibidad
 * Datos de vehiculos
 * Asociacion de item en concepto de cxp y concepto de movimiento de mercaderia
 */

ALTER TABLE agnCompany ADD COLUMN fldMaxInvoiceReceptionDay TINYINT UNSIGNED NOT NULL DEFAULT '20' AFTER fldCreditDays ;
ALTER TABLE payAccountsPayableConcept ADD COLUMN codItem INTEGER UNSIGNED NULL DEFAULT NULL  AFTER codCostCenter ;
ALTER TABLE payAccountsPayableConcept ADD CONSTRAINT fkyAccountsPayableConceptItem FOREIGN KEY (codItem)
  REFERENCES invItem (pkyItem) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyAccountsPayableConceptItem (codItem ASC) ;
ALTER TABLE invItemMovementTypeConcept ADD COLUMN codItem INTEGER UNSIGNED NULL DEFAULT NULL  AFTER codAccount ;
ALTER TABLE invItemMovementTypeConcept ADD CONSTRAINT fkyItemMovementTypeConceptItem FOREIGN KEY (codItem)
  REFERENCES invItem (pkyItem) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyinvItemMovementTypeConcept (codItem ASC) ;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM invItemType;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.0.11pre2  
/*
 * Correcion de control de item
 */

ALTER TABLE payAccountsPayableConcept DROP FOREIGN KEY fkyAccountsPayableConceptItem ;
ALTER TABLE payAccountsPayableConcept DROP COLUMN codItem ;
ALTER TABLE payExpensesConcept ADD COLUMN fldItemControl TINYINT(1) NOT NULL DEFAULT '0'  AFTER codAccount ;
ALTER TABLE invItemMovementTypeConcept DROP FOREIGN KEY fkyItemMovementTypeConceptItem ;
ALTER TABLE invItemMovementTypeConcept CHANGE COLUMN codItem fldItemControl TINYINT(1) NOT NULL DEFAULT '0'  , 
  DROP INDEX fkyinvItemMovementTypeConcept;
ALTER TABLE payAccountsPayable ADD COLUMN codItem INTEGER UNSIGNED NULL DEFAULT NULL  AFTER codPendingTaxAccountEntry ;
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayableItem FOREIGN KEY (codItem)
  REFERENCES invItem (pkyItem) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyAccountsPayableItem (codItem ASC) ;
ALTER TABLE invItemMovement ADD COLUMN codItem INTEGER UNSIGNED NULL DEFAULT NULL AFTER codAccountEntry ;
ALTER TABLE invItemMovement ADD CONSTRAINT fkyItemMovementItem FOREIGN KEY (codItem)
  REFERENCES invItem (pkyItem) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyItemMovementItem (codItem ASC) ;
  
1.1.0 
// Bananoid  -- Sincronnizar PRIMERO !! --Licenciar
/*
 * Motor Reportes
 * Modelos de marcas
 * Año del vehiculo
 * Contratos de Vehiculos 
 */

DROP TABLE vhcVehicleDetail;
ALTER TABLE invItem CHANGE COLUMN fldStorageUnitCoefficient fldStorageUnitCoefficient INTEGER UNSIGNED NOT NULL DEFAULT '1';
ALTER TABLE invItem ADD COLUMN codBrandModel MEDIUMINT UNSIGNED NULL DEFAULT NULL AFTER codVolumeMeasureUnit;
ALTER TABLE invItem ADD CONSTRAINT fkyItemBrandModel FOREIGN KEY (codBrandModel)
  REFERENCES invBrandModel (pkyBrandModel) ON DELETE RESTRICT ON UPDATE RESTRICT,
  ADD INDEX fkyItemBrandModel (codBrandModel ASC) ;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DROP TABLE regCity;
DROP TABLE regState;
DROP TABLE regCountry;
SET FOREIGN_KEY_CHECKS=TRUE;

1.1.1
// Frutitis 
/*
 * Usurios y grupos
 * Mensajes y Avisos de mensajes
 */

ALTER TABLE accGroup ADD COLUMN fldIsPrivate BOOL NOT NULL DEFAULT 0 AFTER fldName;
UPDATE accGroup SET fldIsPrivate = 1;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(5,3,'Traspaso entre cajas',NULL,'Traspaso entre cajas',1,0,1,2,0,1);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.1.2
// Frutitis Revenge
/*
 * Varios Bugs
 */

1.2.0 Client
1.2.0 Server 
// Coconuts
/*
 * Planificacion de mensajes
 */

ALTER TABLE invItem ADD COLUMN fldInUse BOOL NOT NULL DEFAULT 0 AFTER blbIcon;
DROP TABLE srvUserTask;
DROP TABLE srvTaskScheduler;
DROP TABLE vhcContractVehicleInsurance;
DROP TABLE vhcVehicleContract;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvTaskType;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.1 Client  11-07-22
1.2.1 Server 
**Marco**
// Peanuts
/*
 * Campos varios en contratos de vehiculos
 * Correcion Anulacion de pagos y anticipos con Cheque
 */

DROP TABLE vhcContractVehicleInsurance;
DROP TABLE vhcVehicleContract;

1.2.2 Client  
1.2.2 Server 
// --LICENCIAR !!!

// Palta
/*
 * Cierre de contrato de vehiculos
 * Component de tareas
 * Arreglo de depositos
 */

ALTER TABLE vhcVehicleContract ADD COLUMN fldFuelPrice DECIMAL(30,10) UNSIGNED NOT NULL DEFAULT '0.00'  AFTER fldFuel;
ALTER TABLE vhcVehicleContract ADD COLUMN fldMileagePrice DECIMAL(30,10) UNSIGNED NOT NULL DEFAULT '0.00'  AFTER fldFuelPrice;
DROP TABLE vhcVehiclesConfig;
DROP TABLE vhcContractVehicleInsurance;
DROP TABLE vhcVehicleContract;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.3 Client  
1.2.3 Server 
// Onion
/*
 * Arreglo de movimientos de banco ( Ya es posible saber de quer caja se hizo el mov)
 * Cambio de CxP que admite varios gastos (Solo sin factura por el momento) 
 */

ALTER TABLE tryBankMovement ADD COLUMN codPettyCash MEDIUMINT UNSIGNED NULL DEFAULT NULL AFTER codAccountEntry;
ALTER TABLE payAccountsPayable DROP FOREIGN KEY fkyAccountsPayableItem, DROP FOREIGN KEY fkyAccountsPayableInvoice, DROP FOREIGN KEY fkyAccountsPayableExpensesConcept , DROP FOREIGN KEY fkyAccountsPayableDocumentType;
ALTER TABLE payAccountsPayable DROP COLUMN codItem, DROP COLUMN codInvoice , DROP COLUMN codDocumentType , DROP COLUMN codExpensesConcept, DROP INDEX fkyAccountsPayableItem 
, DROP INDEX fkyAccountsPayableInvoice
, DROP INDEX fkyAccountsPayableDocumentType
, DROP INDEX fkyAccountsPayableExpensesConcept;

1.2.4 Client
1.2.4 Server
// Potato
/* 
 * Cambio de CxP que admite varios gastos con factura 
 * Campos extra en contratos de vehiculos
 */

ALTER TABLE payAccountsPayableDetail ADD COLUMN codInvoice BIGINT UNSIGNED NULL DEFAULT NULL  AFTER fldAmount;
DROP TABLE vhcVehiclesConfig;
DROP TABLE vhcContractVehicleInsurance;
DROP TABLE vhcVehicleContract;

1.2.5 Client
1.2.5 Server
// --LICENCIAR !!!

// Porotus
/* 
 * Campos extra ( Color y autorización de viaje )
 * Tabla de equipamiento extra
 */

ALTER TABLE vhcVehicleDetail ADD COLUMN fldColor VARCHAR(20) NOT NULL  AFTER fldWeightCapacity;
ALTER TABLE vhcVehicleContract ADD COLUMN fldTravelAuthorization VARCHAR(100) NULL DEFAULT NULL  AFTER fldExtraTimeTotal;

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.6 Client
1.2.6 Server
// --LICENCIAR !!!

// Tomatito
/*  
 * Tabla de conducteres extra
 * Bugs
 * Hora ya graba  bien
 * Varias facturas en CxP
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.7 Client
1.2.7 Server
// 2011-08-28

// Lechuguito
/*   
 * Por fin retenciones !
 */

1.2.8 Client  ** Giangranco **
1.2.8 Server
// --LICENCIAR !!!
// 2011-09-09

// Jamoncio
/*   
 * Bugs, bugs y mas bugs
 * Control de Fechas en CxP y CxC
 * Duplicidad de facturas en compras y ventas
 * En anticipos de cliente, introducir funcionalidad para que permita préstamos de empleados
 * Tarjetas de credito en compras
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
INSERT INTO payExpensesConcept VALUES(2, 'Gasto X Préstamo',NULL,0,NULL,1,0,1,2,0,1);
ALTER TABLE payEarlyCollection DROP FOREIGN KEY fkyEarlyCollectionClient;
ALTER TABLE payEarlyCollection ADD COLUMN codEmployee INT UNSIGNED NULL DEFAULT NULL  AFTER codClient , CHANGE COLUMN codClient codClient MEDIUMINT(8) UNSIGNED NULL DEFAULT NULL  , 
  ADD CONSTRAINT fkyEarlyCollectionClient
  FOREIGN KEY (codClient )
  REFERENCES agnCompany (pkyCompany ), 
  ADD CONSTRAINT fkyEarlyCollectionEmployee
  FOREIGN KEY (codEmployee )
  REFERENCES agnPerson (pkyPerson )
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkyEarlyCollectionEmployee (codEmployee ASC) ;

1.2.9 Client  
1.2.9 Server
// --LICENCIAR !!!
// 2011-09-21

// Potato A La Carte
/*   
 * Dosificacion de impuesto
 * Asignacion a local de venta
 * Asteriscos en tarjetas de credito propias
 * Aumentar espacio para glosa en ventas
 * Manejo de espacios y enters en campos txt
 * Sucursal en empresa
 */

ALTER TABLE slsSalesConfig ADD COLUMN fldPrintPrice TINYINT(1) NOT NULL DEFAULT '1'  AFTER fldOrderNoteControl;
ALTER TABLE slsSalesConfig CHANGE COLUMN txtDefaultDescription txtDefaultDescription VARCHAR(2000) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;
ALTER TABLE slsOrderNote CHANGE COLUMN txtDescription txtDescription VARCHAR(2000) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;
DROP TABLE vhcVehicleContractExtra;
DROP TABLE vhcContractVehicleInsurance;
DROP TABLE vhcExtraDriver;
DROP TABLE vhcVehicleContract;

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.10 Client  
1.2.10 Server
// 2011-09-30   SVN 277

// Patatancia
/*   
 * Mejoras en contratos de vehículos
 * Ya no muestra conceptos de gastos e ingresos por defecto
 * Bugs y más bugs
 */

ALTER TABLE agnPerson ADD COLUMN fldCanSell TINYINT(1) NOT NULL DEFAULT '0'  AFTER fldHiringDate;
ALTER TABLE vhcVehicleContract DROP FOREIGN KEY fkyVehicleContractReplacedContract;
ALTER TABLE vhcVehicleContract CHANGE COLUMN codReplacedContract parReplacedContract INT(10) UNSIGNED NULL DEFAULT NULL  , 
  ADD CONSTRAINT fkyVehicleContractReplacedContract
  FOREIGN KEY (parReplacedContract )
  REFERENCES vhcVehicleContract (pkyVehicleContract )
  ON DELETE CASCADE
  ON UPDATE CASCADE
, DROP INDEX fkyVehicleContractReplacedContract
, ADD INDEX fkyVehicleContractReplacedContract (parReplacedContract ASC) ;

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM agnCompanyType;
DELETE FROM agnIdentityDocumentType;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.11 Client  
1.2.11 Server
// --LICENCIAR !!!
// 2011-10-21   SVN 283

// Adamantino
/*   
 * Mejoras en contratos de vehículos
 * Framework de planificador reescrito para que permita transaccionalidad
 * Bugs
 */

ALTER TABLE slsSalesConfig CHANGE COLUMN txtDefaultDescription txtDefaultDescription VARCHAR(5000);
ALTER TABLE slsOrderNote CHANGE COLUMN txtDescription txtDescription VARCHAR(5000);
ALTER TABLE vhcVehicleContract ADD COLUMN codContactType TINYINT(3) UNSIGNED NOT NULL DEFAULT '1' AFTER parReplacedContract, 
  ADD CONSTRAINT fkyVehicleContractContactType
  FOREIGN KEY (codContactType)
  REFERENCES agnContactType (pkyContactType)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkyVehicleContractContactType (codContactType ASC);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.12 Client  
1.2.12 Server
// --LICENCIAR !!!
// 2011-11-   SVN 293

// Esmeraldo
/*   
 * Contratos de vehiculos (Ultima Parte)
 * Reportes y vouchers varios
 * Ventas parte II
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.2.13 Client  
1.2.13 Server
// 2011-11-   SVN 293

// Topazito
/*   
 * Errores multiusuario
 * Descripcion corregida
 * Permite pagar al contado al comprar
 */

ALTER TABLE pchReceiptOfGoods ADD COLUMN codPettyCashMovement BIGINT UNSIGNED NULL AFTER codComponent, 
  ADD CONSTRAINT fkyReceiptOfGoodsPettyCashMovement
  FOREIGN KEY (codPettyCashMovement)
  REFERENCES ptcPettyCashMovement (pkyPettyCashMovement)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkyReceiptOfGoodsPettyCashMovement (codPettyCashMovement ASC) ;

1.3.0 Client  
1.3.0 Server
// 2012-02-15   SVN 301

// Peanuts
/*   
 * Error en compras
 * Nota de ventas completo ( Todas las combinaciones )
 * Anulaciones de notas de venta
 * Generacion de codigo de facturacion
 * Problemas en dosificaciones y facturas
 * Obliga aponer cta en cat item level 1
 * Reporte de Items y vouchers CxC y CxP
 */

DROP TABLE slsSalesNoteDetail;
DROP TABLE slsSalesNote;
INSERT INTO tryBankMovementTypeConcept VALUES(6,1,'Abono por Venta',NULL,'Abono por venta',1,0,1,2,0,1);
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(6,1,'Ingreso por Venta',NULL,'Ingreso por venta',1,0,1,2,0,1);
DELETE FROM actTransactionApportionRule;
ALTER TABLE txsAuthorizationControl ADD COLUMN fldNextNumber INTEGER UNSIGNED NOT NULL DEFAULT '1' AFTER fldActivated;
ALTER TABLE txsAuthorizationControl CHANGE COLUMN fldControlKey fldControlKey VARCHAR(256) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL;

1.4.0 Client  
1.4.0 Server
// --LICENCIAR !!!
// 2012-04-29   SVN  315

// Gorgory
/*
 * Espacios en tipo de asiento
 * Espacios en tipo de centros de costo
 * Fechas por defecto en personas
 * Concepto de gasto para compras
 * Mejoras a contratos de vehiculos
 * Adicion de contrato en ordenes de venta
 * Control de items en cuentas por cobrar
 * Arreglo de error en asientos de traspasos
 * Anulacion de traspasos
 * Evio de parametro usuario a todos los reportes y comprobantes
 * Comprobantes : orden de compra, factura, recepciones de mercadería, tipo de cambio, cobranza
 * Reportes : Cotizaciones por cliente, cotizaciones por item, CxC a fecha
 * Ya funciona Nota de venta jalando nota de pedido tipo CxC
 * Nota de venta en diferentes monedas
 * Pulzar no se cae cuando se intenta generar una nota de venta con factura sin previa dosificacion
 * En la factura se coloca tambien el codigo de la dosificacion
 * 
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
INSERT INTO payExpensesConcept VALUES(3,'Gasto X Compra',NULL,0,NULL,1,0,1,2,0,1);
INSERT INTO payExpensesConcept VALUES(4,'Gasto X Importación',NULL,0,NULL,1,0,1,2,0,1);
ALTER TABLE slsSalesNote ADD COLUMN codVehicleContract INTEGER UNSIGNED NULL DEFAULT NULL  AFTER codBankMovement, 
  ADD CONSTRAINT fkySalesNoteVehicleContract
  FOREIGN KEY (codVehicleContract)
  REFERENCES vhcVehicleContract (pkyVehicleContract)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkySalesNoteVehicleContract (codVehicleContract ASC);
ALTER TABLE vhcVehicleContract ADD COLUMN fldBilled BOOL NOT NULL DEFAULT '0' AFTER codContactType;
ALTER TABLE vhcVehicleContract ADD COLUMN fldDiscount DECIMAL(30,10) NOT NULL DEFAULT '0.00' AFTER fldBilled;
ALTER TABLE vhcVehicleContract CHANGE COLUMN fldTotalPayed fldTotalBilled DECIMAL(30,10) NOT NULL DEFAULT '0.0000000000';
ALTER TABLE payAccountsPayableDetail ADD COLUMN codItem INT UNSIGNED NULL DEFAULT NULL  AFTER codInvoice, 
  ADD CONSTRAINT fkyAccountsPayableDetailItem
  FOREIGN KEY (codItem)
  REFERENCES invItem(pkyItem)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkyAccountsPayableDetailItem(codItem ASC);
ALTER TABLE txsSalesLedger ADD COLUMN codAuthorizationControl INT UNSIGNED DEFAULT NULL  AFTER fldTaxDebit, 
  ADD CONSTRAINT fkySalesLedgerAuthorizatonControl
  FOREIGN KEY (codAuthorizationControl)
  REFERENCES txsAuthorizationControl (pkyAuthorizationControl)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkySalesLedgerAuthorizatonControl(codAuthorizationControl ASC);
DROP TABLE txsTaxesConfig;

1.5.0 Client  
1.5.0 Server
// 2012-06-04   SVN 321  
// Permisivo

/*
 * Comprobantes : Anticipo a rendir, Anticpo de cliente, Pago, Deposito de Cheque, 
 * 	          Mov bancario, Nota de preproducción, Orden de Producción
 * En catalogo de proveedor y lista de precios se puede ordenar
 * En detalles ya no se duplican filas (Catalogo, Lista de precios, banco, tipo mov banco,
 *                item, tipo mov inv, tipo mov caja, receta, contrato)
 * CxC sin factura en ventas
 * Accesos
 * En recepcion de mercaderia se pueden modificar cantidades si no se genero CxP
 * Reportes cargan si es que tiene acces al modulo
 * 
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
INSERT INTO slsSalesNoteType VALUES(7,'Cortesía Posterior',NULL,1,0,1,2,0,1);
ALTER TABLE accAccessComponent ADD COLUMN fldRead TINYINT(1) NOT NULL DEFAULT '0' AFTER codComponent, 
      ADD COLUMN fldWrite TINYINT(1)  NOT NULL DEFAULT '0'  AFTER fldRead;

1.5.1 Client  
1.5.1 Server
// 2012-06-14   SVN 326
// Primitivo

/*
 * En recepciones se puede colocar items con cantidad 0
 * En recepciones, correccion de precios cuando se modifica la cantidad
 * Arreglo del panel de busqueda cuando la cantidad de registros es mayor 100
 * En traspasos de caja no salia las cajas destino en el panel de busqueda
 * Opcion en la configuracion del modulo de ventas para determinar si se usara la glosa por defecto en la nota de venta
 * En nota de venta, al escoger contrato jala el cliente
 * Notas de venta acepta servicios y productos
 * En CxP el asiento genera correctamente cuando un gasto es con factura y con un monto excento de impuestos (ejm fac de luz )
 * En contratos, cuando se modifica semnas dias y meses actualiza la fecha si es que el estado es reserva o prereserva
 * En contratos, se modifico campo de descuento para aceptar montos negativos
 * Es posible introducir facturas duplicadas en compras si es que las demas estan anuladas
 * En mov mercaderia y ordenes de compra, ya se pueden introducir vehiculos
 * En cheques, los literales aceptan mas caracteres
 * Filtros de clientes ya salen correctamente
 * En contratos cerrados sale por defecto la opcion de imprimir todo.
 * En nota de venta se coloca el color naranja a los productos que tienen precio 0
 * En nota de venta al grabar ya no pide caja ni movv mercaderia
 */

ALTER TABLE slsSalesConfig ADD COLUMN fldUseDescription TINYINT(1) NOT NULL DEFAULT '1' AFTER codCardConcept ;
ALTER TABLE slsSalesConfig ADD COLUMN fldShowItemMovement TINYINT(1) NOT NULL DEFAULT '0' AFTER fldUseDescription;

1.5.2 Client  
1.5.1 Server
// 2012-06-29   SVN 328
// Puppy

/*
 * En configuracion de tamano de pagina se envia 1,2,3 
 * En CxP es posible introducir conceptos repetidos
 * Es posible ingresar en Nota de ventas items repetidos incluyendo bonificaciones 
 * Correcion de cheque en anticipos de y a empleados 
 * Al editar contratos graba los seguros y los extras
 * En prestamos lista clientes y proveedores
 */

ALTER TABLE invItem ALTER fldName DROP DEFAULT;
ALTER TABLE invItem CHANGE COLUMN fldName fldName VARCHAR(100) NULL AFTER pkyItem;

1.5.3 Client  
1.5.1 Server
// 2012-07-20   SVN 331
// Locoto

/*
 * En nota de venta ya no controla stock si es servicio
 * En nota de venta no incrementaba valor en caja
 * Problemas en lotes al anular 
 * Mas espacio en los totales en mov caja
 * Las compras ya anulan las facturas
 * Bugs en ordenes de pedido tipo cxc
 * Pedidos ya aceptan items duplicados
 * Tabs en contratos
 * Algunas mejores en la UI
 * Ya ordena en forma numerica en la clave primaria
 * Un click para todo
 * Pagos directamente en CXP
 * BUG en centros de costo cuando la ciudad era diferente a La Paz
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM regCity;
SET FOREIGN_KEY_CHECKS=TRUE;

1.6.0 Client  
1.6.0 Server
// 2012-08-22   SVN 
// Pimenton
// SINCRONIZAR 

/*
 * Importaciones Parte I - Planilla de gastos
 * Compilado en Visual Studio 2010
 * Reportes : Retenciones, Gastos x Item, Configuracion Modulos, Conf paramteros
 * Impresión de copia de factura
 * Alertas en contratos de vehiculos
 */

DELETE FROM actTransactionApportionRule;

1.6.1 Client  
1.6.1 Server
// 2012-09-12   SVN 
// Pimienta Fuxia
// LICENCIAR Y DESPUES SINCRONIZAR

/*
 * Importaciones Parte II - Planilla de gastos con impuestos y retenciones
 * Arreglo de bug en numero de transaccion de asiento
 * Hora en los mensajes
 */

DROP TABLE txsPurchaseRetentionDetail;
DROP TABLE pchPayrollExpensesDetail;
DROP TABLE pchPayrollExpenses;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(7,2,'Egreso por Importación',NULL,'Egreso por Importación',1,0,1,2,0,1);
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.6.2 Client  
1.6.1 Server
// 2012-09-18
// Pimienta Turulata

/*
 * Importaciones Parte III (FINAL) - Prorrateo correcto con impuestos y sin impuestos, además cambiando la cantidad. Asiento.
 * Cuando se realiza asiento manual, se verifica si se está usando la cuenta de crédito fiscal y permite introducir una factura
 */
/* PROBAR :
 *    Ordenes de compra en diferentes monedas,
 *    Varias planillas de gasto en diferentes monedas y con distintos tipos de prorateo ademos con diferentes tipos de impuesto
 *    Verificar que está realizando bien el prrateo en la recepción dew mercadería
 *    En la recepción de mercadería cambiar las cantidades y verificar el prorrateo
 *    Verificar asiento en planillas de gasto y recepcion de mercaderia
 *    Por si acaso probar recepcion sin planilla de gastos
 */

1.6.3 Client  
1.6.3 Server
// 2012-10-09
// Rabanito
// SINCRONIZAR 
/*
 * Arreglo de anulaciones en movimientos de mercadería en general
 * Abrir con Excel en reportes ( Se debe agregar el path de excel a la variable PATH del sistema)
 * Abrir con Firefox en reportes ( Se debe agregar el path de firefox  a la variable PATH del sistema)
 * Correccion de alarmas en contratos de vehiculos
 * Logs
 * El path de los reportes corresponde al nombre de la empresa sin espacios
 * Aumentar responsable en laconfiguracion del módulo de impuestos
 */

ALTER TABLE txsTaxesConfig ADD COLUMN codPerson INT UNSIGNED NULL DEFAULT NULL  AFTER codInvoiceSheetType, 
  ADD CONSTRAINT fkyTaxesConfigPerson
  FOREIGN KEY (codPerson)
  REFERENCES agnPerson (pkyPerson)
  ON DELETE RESTRICT
  ON UPDATE RESTRICT
, ADD INDEX fkyTaxesConfigPerson (codPerson ASC) ;

DROP TABLE dbaUserLog;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM regCity;
DELETE FROM actCostCenter;
SET FOREIGN_KEY_CHECKS=TRUE;

1.6.4 Client  
1.6.4 Server
// 2012-10-19
// Pokus
// LICENCIAR Y SINCRONIZAR
/*
 * BUG : Al pagar con cheque cuando se introduce uno nuevo, se borraba el campo de banco
 * En CxP se aumento un campo de ajuste para que cuadre perfectamente los decimales si es que se usan retenciones
 * BUG : Al desconectarse del sistema,no desconectaba la conexion a la base de datos 
 * En movimiento bancario selecciona por defecto la moneda de la cuenta de banco
 * El panel de busqueda ya funciona ( excepto con llaves foraneas y arboles (como plan de cuentas)) y ademas 
 *    ya se posciciona correctamente sin ocultarse. Usar el caracter * si es que se desean wildcards. NO FUNCIONA CON TRANSACCIONES
 * Cambio de moneda en modulo de caja : PROBAR !! verificar asiento anulaciones etc etc
 */

DELETE FROM actTransactionApportionRule;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(8,2,'Egreso por Cambio de Moneda',NULL,'Egreso por Cambio de Moneda',1,0,1,2,0,1);
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(9,1,'Ingreso por Cambio de Moneda',NULL,'Ingreso por Cambio de Moneda',1,0,1,2,0,1);

1.6.5 Client  
1.6.5 Server
// 2012-11-05
// Laberinto del Fauno
// SINCRONIZAR 

/*
 * BUG : Buscador jalaba mal el nombre de tabla y no se podia buscar nada
 * Orden de compas en factura de compras 
 * Se quito el signo $ en los campos de moneda porque causa confusión
 * Se mando URL a chrome y firefox en vez de generar archivo
 * Graba el grupo cuando se inserta o edita un registro
 * BUG : No se puede anular la planilla si se hizo alguna recepcion
 * BUG : El mov. de mercaderia ya jala el costo correctamente si existen planillas de gasto
 * En configuracion del Moudlo de Servidor se puede escoger la opcion de imprimir una transaccion inmediatamente despues de insertarla
 * Cuando se realiza un pago o cobranza se copia la glosa al mov bancario
 * Retenciones en recpciones de mercaderia
 * 
 */

ALTER TABLE pchReceiptOfGoods ADD COLUMN fldRetentions DECIMAL(30,10) NOT NULL DEFAULT '0.0000000000'  AFTER fldNetTotal;

1.7.0 Client  
1.7.0 Server
// 2012-12-02
// Correctilio
// LICENCIAR Y SINCRONIZAR 

/*
 * BUG: Creacion de tablas referidas a invItem
 * BUG: Al anular movimientos con cheques no jalaba bien la cuenta bancaria
 * BUG: Diversos bugs cuando la opcion de imprimir comprobante automaticamente estaba activada
 * Los campos de empresa y persona ya no se borran ( excepto en Cobros y Pagos que jala informacion y puede causar confusion 
 * Paso de variable de saldo al comprobante de pago
 * Revision de la validacion de todas las transacciones incluyendo anulaciones
 * Botón que permite acceder al registro padre ( el creador de la transacción ) en todas las transacciones
 *  * 
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

ALTER TABLE actAccountEntry ADD COLUMN codComponent MEDIUMINT UNSIGNED NULL DEFAULT NULL  AFTER codExchangeRate, ADD COLUMN cosComponentKey BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codComponent,
  ADD CONSTRAINT fkyAccountEntryComponent FOREIGN KEY (codComponent) REFERENCES srvComponent (pkyComponent)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyAccountEntryComponent (codComponent ASC) 
, ADD INDEX indAccountEntryComponentKey (cosComponentKey ASC) ;
ALTER TABLE actAccountEntry DROP FOREIGN KEY fkyAccountEntryComponent;
ALTER TABLE actAccountEntry DROP INDEX fkyAccountEntryComponent;
ALTER TABLE actAccountEntry CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE ptcPettyCashMovement ADD INDEX indPettyCashMovementComponentKey (cosComponentKey ASC) ;
ALTER TABLE ptcPettyCashMovement DROP FOREIGN KEY fkyPettyCashMovementComponent;
ALTER TABLE ptcPettyCashMovement DROP INDEX fkyPettyCashMovementComponent;
ALTER TABLE ptcPettyCashMovement CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;
INSERT INTO ptcPettyCashMovementTypeConcept VALUES(10,2,'Egreso por Abono Bancario',NULL,'Egreso por Abono Bancario',1,0,1,2,0,1);

ALTER TABLE ptcCurrencyExchange ADD INDEX indCurrencyExchangeComponentKey (cosComponentKey ASC) ;
ALTER TABLE ptcCurrencyExchange DROP FOREIGN KEY fkyCurrencyExchangeComponent;
ALTER TABLE ptcCurrencyExchange DROP INDEX fkyCurrencyExchangeComponent;
ALTER TABLE ptcCurrencyExchange CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE tryCheck DROP FOREIGN KEY fkyCheckComponent;
ALTER TABLE tryCheck DROP INDEX fkyCheckComponent;
ALTER TABLE tryCheck CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE tryBankMovement DROP FOREIGN KEY fkyBankMovementComponent;
ALTER TABLE tryBankMovement DROP INDEX fkyBankMovementComponent;
ALTER TABLE tryBankMovement CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;
ALTER TABLE tryBankMovement ADD COLUMN codPettyCashMovement BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codPettyCash, 
  ADD CONSTRAINT fkyBankMovementPettyCashMovement FOREIGN KEY (codPettyCashMovement) REFERENCES ptcPettyCashMovement (pkyPettyCashMovement)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyBankMovementPettyCashMovement (codPettyCashMovement ASC) ;

ALTER TABLE tryCheckDeposit DROP FOREIGN KEY fkyCheckDepositComponent;
ALTER TABLE tryCheckDeposit DROP INDEX fkyCheckDepositComponent;
ALTER TABLE tryCheckDeposit CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE colAccountsReceivable DROP FOREIGN KEY fkyAccountsReceivableComponent;
ALTER TABLE colAccountsReceivable DROP INDEX fkyAccountsReceivableComponent;
ALTER TABLE colAccountsReceivable CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE colEarlyPayment ADD COLUMN codComponent MEDIUMINT UNSIGNED NULL DEFAULT NULL  AFTER codPettyCashMovement, ADD COLUMN cosComponentKey BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codComponent,
  ADD CONSTRAINT fkyEarlyPaymentComponent FOREIGN KEY (codComponent) REFERENCES srvComponent (pkyComponent)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyEarlyPaymentComponent (codComponent ASC) 
, ADD INDEX indEarlyPaymentComponentKey (cosComponentKey ASC) ;
ALTER TABLE colEarlyPayment DROP FOREIGN KEY fkyEarlyPaymentComponent;
ALTER TABLE colEarlyPayment DROP INDEX fkyEarlyPaymentComponent;
ALTER TABLE colEarlyPayment CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE colCollection DROP FOREIGN KEY fkyCollectionComponent;
ALTER TABLE colCollection DROP INDEX fkyCollectionComponent;
ALTER TABLE colCollection CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE payAccountsPayable DROP FOREIGN KEY fkyAccountsPayableComponent;
ALTER TABLE payAccountsPayable DROP INDEX fkyAccountsPayableComponent;
ALTER TABLE payAccountsPayable CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE payEarlyCollection ADD COLUMN codComponent MEDIUMINT UNSIGNED NULL DEFAULT NULL  AFTER codPettyCashMovement, ADD COLUMN cosComponentKey BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codComponent,
  ADD CONSTRAINT fkyEarlyCollectionComponent FOREIGN KEY (codComponent) REFERENCES srvComponent (pkyComponent)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyEarlyCollectionComponent (codComponent ASC) 
, ADD INDEX indEarlyCollectionComponentKey (cosComponentKey ASC) ;
ALTER TABLE payEarlyCollection DROP FOREIGN KEY fkyEarlyCollectionComponent;
ALTER TABLE payEarlyCollection DROP INDEX fkyEarlyCollectionComponent;
ALTER TABLE payEarlyCollection CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE payPayment DROP FOREIGN KEY fkyPaymentComponent;
ALTER TABLE payPayment DROP INDEX fkyPaymentComponent;
ALTER TABLE payPayment CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE txsPurchasesLedger DROP FOREIGN KEY fkyPurchasesLedgerComponent;
ALTER TABLE txsPurchasesLedger DROP INDEX fkyPurchasesLedgerComponent;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE txsSalesLedger DROP FOREIGN KEY fkySalesLedgerComponent;
ALTER TABLE txsSalesLedger DROP INDEX fkySalesLedgerComponent;
ALTER TABLE txsSalesLedger CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

ALTER TABLE invItemMovement ADD COLUMN codComponent MEDIUMINT UNSIGNED NULL DEFAULT NULL  AFTER codItem, ADD COLUMN cosComponentKey BIGINT UNSIGNED NULL DEFAULT NULL  AFTER codComponent,
  ADD CONSTRAINT fkyItemMovementComponent FOREIGN KEY (codComponent) REFERENCES srvComponent (pkyComponent)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyItemMovementComponent (codComponent ASC) 
, ADD INDEX indItemMovementComponentKey (cosComponentKey ASC) ;
ALTER TABLE invItemMovement DROP FOREIGN KEY fkyItemMovementComponent;
ALTER TABLE invItemMovement DROP INDEX fkyItemMovementComponent;
ALTER TABLE invItemMovement CHANGE COLUMN codComponent fldParentComponent VARCHAR(40) NULL DEFAULT NULL;

1.7.1 Client  
1.7.1 Server
// 2012-12-08
// Semilio

/*
 * Revision de la validacion de todas las transacciones incluyendo anulaciones (FINAL)
*/

1.7.2 Client  
1.7.2 Server
// 2012-12-12
// Perla

/*
 * Diversos BUGS
 * Mejoras en contratos de vehículos
 */

1.7.3 Client  
1.7.3 Server
// 2012-12-
// Perla Negra
// LICENCIAR Y SINCRONIZAR 

/*
 * Pedidos de material
 * Autorizaciones de los pedidos
 * Reporte de log y voucher de log
 * En factura y nota de venta jala glosa del contrato
 * En recepcion de mercaderia se aumento anticipo, si este esta lleno se genera la cta por pagar al empleado del anticipo
 * Tabla de componentes tiene datos de nombre y nombre de modulos
 * Se agrego tipos de empresa Asociaciones y Cooperativas
 * Ajuste manual por tipo de cambio en recepciones para las retenciones
 * Primera transacción de una gestión que no sea la primera realizada, empieza con 3 para dejar campo a los asientos de apertura
 * BUG: Cuando se pagaba la totalidad del contrato ya no se podia extender el mismo
 * BUG: Al realizar un pago via banco no guarda bien el concepto en algunas ocasiones
 * BUG: El server no corre si la licencia esta expirada
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DELETE FROM agnCompanyType;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE srvComponent ADD COLUMN txtModuleDescription VARCHAR(200) NULL DEFAULT NULL AFTER txtDescription ;
ALTER TABLE pchReceiptOfGoods ADD COLUMN codEarlyPayment BIGINT UNSIGNED NULL DEFAULT NULL  AFTER fldRetentions, 
  ADD CONSTRAINT fkyReceiptOfGoodsEarlyPayment FOREIGN KEY (codEarlyPayment) REFERENCES colEarlyPayment (pkyEarlyPayment)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyReceiptOfGoodsEarlyPayment (codEarlyPayment ASC);

1.7.4 Client  
1.7.4 Server
// 2012-12-20
// Perlita Finiquita 
// SINCRONIZAR

/*
 * Ordenes de compra se pueden editar si esuqe no han sido usadas y si es que no se genero la CxP
 * En autorizaciones se aumenta pestaña donde se puede ver el consolidado del detalle
 * En autorizaciones se marca usado por linea y no toda la nota
 * En pedidos de material, aumentar campos de empleado y almacén
 * Si se cargan autorizaciones en la orden de compra entonces no se peuden aumentar filas
 * En orden de compra si es que se jala una autorización, entonces las cantidades no pueden modificarse hacia arriba, solo hacia abajo
 * Si la autorizacion de pedidos tiene filas con cantidad 0, no las toma en cuenta al jalar la orden de compra
 * En CxP se amplió el ancho de la columna de gasto
 * En autorizaciones de compra se cambió la columna vendedor a proveedor * 
 * BUG: Al realizar una CxP con factura en Usd. por ejm, la factura generaba sin realizar la conversión 
 * BUG: Al inicializar un componente que contiene foreignCombos de tipo Detail desde otro componente, se cuelga en la inicializacion
 * BUG: En cobranzas fallaba si se cobraba via banco sin haber abierto el registro de banco primero
 * BUG: Al editar items con muchas categorias se ponia demasiado lento, esta arreglado parcialmente el problema
 */

DROP TABLE pchRequestAuthorizationDetail;
DROP TABLE pchRequestAuthorization;
DROP TABLE pchPurchaseRequestDetail;
DROP TABLE pchPurchaseRequest;

1.7.5 Client  
1.7.5 Server
// 2012-12-27
// Almeja Gaucha 
// 

/*
 * BUG: En CxP cuando se usaba una moneda distinata a la de la contabilidad, no generaba bien el asiento
 * BUG: Arreglado el problema de colgadas en pagos
 * BUG: Dígitos en reportes
 * BUG: Después de grabar la primera transaccion en ciertos componentes, se deshabilitaban algunos controles
 * BUG: Ya no copia el texto en descripcion al ingresar un nuevo registro
 * Reportes de empresas y pèrsonas
 * Precios en autorizaciones de pedidos de material
 * En cobranzas campo manual para ajuste por dif de tipo de cambio
 * Preguntar antes de anular
 * Anticipo con tarjeta de crédito
 */

ALTER TABLE actAccountingConfig CHANGE COLUMN fldExchangeRateDecimalDigits fldReportDigits TINYINT(3) UNSIGNED NOT NULL DEFAULT '2';
DROP TABLE pchRequestAuthorizationDetail;
DROP TABLE pchRequestAuthorization;

1.7.6 Client  
1.7.6 Server
// 2013-03-15
// Colirius 
// 

/*
 * Campo extra en contrato para observaciones de cierre
 * Cuando el contrato esta cerrado no se puede cambiar la fecha de entrega ni el tiempo de alquiler
 * NIT 0 y nombre de la empresa en decripción por defecto
 * En autorizaciones de pedidos, si es que la cantidad a comprar es 0 entonces no obliga a poner proveedor
 * En autorizaciones de pedidos no se peude aeditar el registro si es que este fue autorizado previamente
 * BUG: En contratos en el campo de descuento ya acepta el signo +
 * BUG: Cuando se editaba transacciones que se habian hecho con banco o cheque, al agregar una nueva transaccion ya no dejaba escoger bien la cta
 * BUG: Corregidos nombres de ciudades
 * BUG: Plurales en descripcion de monedas (solo para nuevas implementaciones)
 */

ALTER TABLE vhcVehicleContract ADD COLUMN fldCloseObservations VARCHAR(200) NULL DEFAULT NULL  AFTER txtObservations;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DELETE FROM regCity;
SET FOREIGN_KEY_CHECKS=TRUE;

1.8.0 Client  
1.8.0 Server
// 2013-04-10 SVN: 384
// Planilus 
// LICENCIAR Y SINCRONIZAR 

/*
 * Varios componentes de Parámetros de Planillas 
 * Generador de codigo de control (ubicado en Mod.Impuestos componente : Algoritmo Impositivo )
 * En sucursal se añadió campo para el código de caja de salud
 * Reporte de almacenes, Comprobante de Pedido de materiales, Comprobante de Autorización de Pedidos
 * Al jalar los pedidos pega el precio sugerido en vez del que esta en el catálogo
 * Equipamiento de vehiculo por orden alfabetico
 * Se aumento el campo vendedor responsable en el registro de empresa ( solo si es cliente )
 * BUG: Cuando está habilitado el flag para imprimir transacciones, solo debe activarse para transacciones y no para todo tipo de registros
 * BUG: Al cargar item tarda mucho cuando hay muchas categorías
 */

DROP TABLE hrsSeniorityBonus;
DELETE FROM hrsPayrollConcept;
ALTER TABLE hrsHumanResourcesConfig DROP COLUMN fldHealthFundCode, DROP COLUMN fldIsHealthFundGlobal;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE agnCompanyBranch ADD COLUMN fldHealthFundCode VARCHAR(50) NULL DEFAULT NULL AFTER fldAddress;
ALTER TABLE agnCompany ADD COLUMN codSeller INT UNSIGNED NULL DEFAULT NULL  AFTER fldMaxInvoiceReceptionDay, 
  ADD CONSTRAINT fkyCompanySeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson)
  ON DELETE RESTRICT ON UPDATE RESTRICT, ADD INDEX fkyCompanySeller (codSeller ASC) ;

1.8.1 Client  
1.8.1 Server
// 2013-05-06 SVN: 388
// Pizzodromo
// LICENCIAR Y SINCRONIZAR 

/*
 * Asientos no permitía cuentas repetidas
 * Definición de descuentos en listas de precios
 * En las transacciones que tienen información de cliente o proveedor, copia la esta información a la glosa en los movimientos derivados
 * Actualizado script de conversion windows->linux
 * BUG: Archivo pdd de empresa, datos iniciales incorrectos
 * BUG: Al insertar un tipo de cambio modificado, no imprmía el comprobante original y no refrescaba su contenido
 * BUG: Glosa en anticipos con banco jalaba de mov. anteriores
 * BUG: Concepto de mov. bancario en ocasiones raras jalaba mal 
 * BUG: Errores varios cuando dos o mas usuarios trabajan en el mismo componente ak mismo tiempo
 */  

ALTER TABLE slsPriceListDetail ADD COLUMN fldDiscount DECIMAL(30,10) NOT NULL DEFAULT '0.0000000000'  AFTER fldPrice;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.8.2 Client  
1.8.2 Server
// 2013-05-24 SVN: 392
// Comicom
// SINCRONIZAR

/*
 * Comisiones completas
 * Mostrar codigo de CxP y CxC pen el pago para facilitar trabajo
 * En algunos movimientos escoge mal la cta de banco via cheque
 * Introducción de facturas sueltas via asientos
 * En movimientos cuya via es banco o cheque, la cuenta bancaria cambia la moneda por defecto
 * Las descripciones de mov. que generan caja chica, son copiadas a los mov. derivados
 * Adjuntar descripciones de pedidos en autorizaciones
 * Aumentar campo de descripción en el detalle de órdenes de compra
 * El buscador sirve para transacciones también
 * Es posible editar asientos que no fueron generados por otros módulos
 * BUG: Colgadas generadas por la anterior versión
 */

ALTER TABLE pchPurchaseOrderDetail ADD COLUMN txtDescription VARCHAR(200) NULL DEFAULT NULL  AFTER fldPackagedItemVolume ;
ALTER TABLE slsSalesConfig ADD COLUMN fldSalesCommission BOOL NOT NULL DEFAULT 0 AFTER fldShowItemMovement;
ALTER TABLE slsSalesConfig ADD COLUMN fldCollectionsCommission BOOL NOT NULL DEFAULT 0 AFTER fldSalesCommission;

1.8.3 Client  
1.8.3 Server
// 2013-06-04 SVN: 395
// Patchlandia
// SINCRONIZAR

/*
 * Código de categoría es mas amplio
 * Se puede copiar registro de receta 
 * BUG: Pagos, cobranzas y anticipos con cheques entra en un loop infinito
 * BUG: Cuando un usuario editaba el mismo componente que otro, y este estaba adicionando datos, entonces al aceptar la edicion borraba los datos que estaba introduciendo el otrro usuario
 */

ALTER TABLE invItemClassification DROP FOREIGN KEY fkyItemClassificationFamily;
ALTER TABLE invItemClassification DROP FOREIGN KEY fkyItemClassificationSubFamily;
ALTER TABLE invItemClassification DROP FOREIGN KEY fkyItemClassificationGroup;
ALTER TABLE invItemClassification DROP FOREIGN KEY fkyItemClassificationSubGroup;

ALTER TABLE invItem DROP FOREIGN KEY fkyItemFamily;
ALTER TABLE invItem DROP FOREIGN KEY fkyItemSubFamily;
ALTER TABLE invItem DROP FOREIGN KEY fkyItemGroup;
ALTER TABLE invItem DROP FOREIGN KEY fkyItemSubGroup;

ALTER TABLE invItemCategory ALTER pkyItemCategory DROP DEFAULT;
ALTER TABLE invItemCategory CHANGE COLUMN pkyItemCategory pkyItemCategory BIGINT UNSIGNED NOT NULL FIRST;

ALTER TABLE invItem CHANGE COLUMN codFamily codFamily BIGINT UNSIGNED NOT NULL;
ALTER TABLE invItem CHANGE COLUMN codSubFamily codSubFamily BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE invItem CHANGE COLUMN codGroup codGroup BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE invItem CHANGE COLUMN codSubGroup codSubGroup BIGINT UNSIGNED NULL DEFAULT NULL;

ALTER TABLE invItemClassification CHANGE COLUMN codFamily codFamily BIGINT UNSIGNED NOT NULL;
ALTER TABLE invItemClassification CHANGE COLUMN codSubFamily codSubFamily BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE invItemClassification CHANGE COLUMN codGroup codGroup BIGINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE invItemClassification CHANGE COLUMN codSubGroup codSubGroup BIGINT UNSIGNED NULL DEFAULT NULL;

ALTER TABLE invItem ADD CONSTRAINT fkyItemFamily FOREIGN KEY (codFamily) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItem ADD CONSTRAINT fkyItemSubFamily FOREIGN KEY (codSubFamily) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItem ADD CONSTRAINT fkyItemGroup FOREIGN KEY (codGroup) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItem ADD CONSTRAINT fkyItemSubGroup FOREIGN KEY (codSubGroup) REFERENCES invItemCategory (pkyItemCategory);

ALTER TABLE invItemClassification ADD CONSTRAINT fkyItemClassificationFamily FOREIGN KEY (codFamily) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItemClassification ADD CONSTRAINT fkyItemClassificationSubFamily FOREIGN KEY (codSubFamily) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItemClassification ADD CONSTRAINT fkyItemClassificationGroup FOREIGN KEY (codGroup) REFERENCES invItemCategory (pkyItemCategory);
ALTER TABLE invItemClassification ADD CONSTRAINT fkyItemClassificationSubGroup FOREIGN KEY (codSubGroup) REFERENCES invItemCategory (pkyItemCategory);

1.8.4 Client  
1.8.4 Server
// 2013-07-03 SVN: 399 
// Gorgoroth
// 

/*
 * Ahora si Comisiones completas
 * Notas de venta ya no exige direccion de cliente
 * Ventas Anuales
 * Se puede generar numero de notas de venta automaticamente escogiendo la opcion en el modulo
 * Cuando se anulan notas de pedido, vuelve a habilitar las lineas correspondientes en las autorizaciones
 * BUG: Al introducir cuentas de mayor con parientes nuevos existia error generado en la anterior version
 * BUG: En anticipos de cliente y cobros, cuando el cheque era cobrado en $us se cambiaba a la primera moneda que encontraba
 * 
 */
 
ALTER TABLE slsSalesNote CHANGE COLUMN codDeliveryAddress codDeliveryAddress MEDIUMINT UNSIGNED NULL DEFAULT NULL;
ALTER TABLE slsSalesConfig CHANGE COLUMN fldSalesCommission fldCommission TINYINT(1) NOT NULL DEFAULT '0', CHANGE COLUMN fldCollectionsCommission fldGenerateDocNumber TINYINT(1) NOT NULL DEFAULT '0';
ALTER TABLE slsSalesNote ADD INDEX indSalesNoteDate (fldDate ASC);
ALTER TABLE pchRequestAuthorizationDetail ADD COLUMN codPurchaseOrder BIGINT UNSIGNED NULL DEFAULT NULL AFTER fldUsed;
ALTER TABLE pchRequestAuthorizationDetail ADD CONSTRAINT fkyRequestAuthorizationDetailPurchaseOrder FOREIGN KEY (codPurchaseOrder) REFERENCES pchPurchaseOrder (pkyPurchaseOrder);

1.8.5 Client  
1.8.5 Server
// 2013-07-27 SVN:401
// Pesadilla Databasiana
// SINCRONIZAR

/*
 * Código de EMPRESA es mas amplio
 * Código de PERSONA es mas amplio
 * Generar número de nota de venta igual al de la factura siempre y cuando este esté vacío y la opción de generación de nota de venta
 *   correlativa en la configuración del módulo esté desactivada
 * Componente de configuración del módulo de Pagos
 * Componente de configuración del módulo de Cobranzas
 * Opción en el componente de Conf de CxP para copiar la glosa de la CxP al pago
 * Opción en el componente de Conf de CxC para copiar la glosa de la CxC al cobro
 * Cuando se inserta un registro de Persona ya no es necesario introducir direccion, teléfono ni mail
 * Se agregaron campos en el componente de item (invItem) : fldMaintenance ( Item en mantenimiento ?), fldMaintenanceStartDate ( Fecha inicial Mant.), fldMaintenanceEndDate ( Fecha final Mant. ) 
 * Reporte de Comisiones, Voucher Empresa, Voucher Persona
 * BUG: 3 pequeños bugs
 */

ALTER TABLE invItem ADD COLUMN fldMaintenance BOOL NOT NULL DEFAULT 0 AFTER fldInUse;
ALTER TABLE invItem ADD COLUMN fldMaintenanceStartDate DATE NULL DEFAULT NULL AFTER fldMaintenance;
ALTER TABLE invItem ADD COLUMN fldMaintenanceEndDate DATE NULL DEFAULT NULL AFTER fldMaintenanceStartDate;

ALTER TABLE pchPayrollExpenses DROP FOREIGN KEY fkyPayrollExpensesSupplier;
ALTER TABLE slsOrderNote DROP FOREIGN KEY fkyOrderNoteClient;
ALTER TABLE pchRequestAuthorizationDetail DROP FOREIGN KEY fkyRequestAuthorizationDetailSeller;
ALTER TABLE pchReceiptOfGoods DROP FOREIGN KEY fkyReceptionOfGoodsSupplier;
ALTER TABLE pchSupplierCatalog DROP FOREIGN KEY fkySupplierCatalogSupplier;
ALTER TABLE slsSalesNote DROP FOREIGN KEY fkySalesNoteClient;
ALTER TABLE pchPurchaseOrder DROP FOREIGN KEY fkyPurchaseOrderSupplier;
ALTER TABLE txsSalesLedger DROP FOREIGN KEY fkySalesLedgerClient;
ALTER TABLE txsPurchasesLedger DROP FOREIGN KEY fkyPurchasesLedgerClient;
ALTER TABLE slsSalesConfig DROP FOREIGN KEY fkySalesConfigCardSupplier;
ALTER TABLE payEarlyCollection DROP FOREIGN KEY fkyEarlyCollectionClient;
ALTER TABLE payPayment DROP FOREIGN KEY fkyPaymentClient;
ALTER TABLE tryCheck DROP FOREIGN KEY fkyCheckCompany;
ALTER TABLE colEarlyPayment DROP FOREIGN KEY fkyEarlyPaymentClient;
ALTER TABLE colAccountsReceivable DROP FOREIGN KEY fkyAccountsReceivableClient;
ALTER TABLE colCollection DROP FOREIGN KEY fkyCollectionClient;
ALTER TABLE payAccountsPayable DROP FOREIGN KEY fkyAccountsPayableSupplier;
ALTER TABLE agnCompanyMail DROP FOREIGN KEY fkyCompanyMailCompany;
ALTER TABLE agnCompanyAddress DROP FOREIGN KEY fkyCompanyAddressCompany;
ALTER TABLE agnCompanyBranch DROP FOREIGN KEY fkyCompanyBranchCompany;
ALTER TABLE agnCompanyPhone DROP FOREIGN KEY fkyCompanyPhoneCompany;
ALTER TABLE agnCompanyCreditCard DROP FOREIGN KEY fkyCompanyCreditCardCompany;
ALTER TABLE agnCompanyIdentityDocument DROP FOREIGN KEY fkyCompanyIdentityDocumentCompany;
ALTER TABLE hrsFixedDiscounts DROP FOREIGN KEY fkyFixedDiscountsCompany;
ALTER TABLE vhcVehicleContract DROP FOREIGN KEY fkyVehicleContractClient;
ALTER TABLE vhcVehicleContract DROP FOREIGN KEY fkyVehicleContractPromoter;
ALTER TABLE invBrand DROP FOREIGN KEY fkyBrandCompany;
ALTER TABLE vhcVehicleDetail DROP FOREIGN KEY fkyVehicleDetailOwner;
ALTER TABLE invItemMovement DROP FOREIGN KEY fkyItemMovementSupplier;

ALTER TABLE agnCompany CHANGE COLUMN pkyCompany pkyCompany BIGINT UNSIGNED NOT NULL FIRST;

ALTER TABLE pchPayrollExpenses CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsOrderNote CHANGE COLUMN codClient codClient BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchRequestAuthorizationDetail CHANGE COLUMN codSeller codSeller BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE pchReceiptOfGoods CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchSupplierCatalog CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsSalesNote CHANGE COLUMN codClient codClient BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchPurchaseOrder CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED NOT NULL;
ALTER TABLE txsSalesLedger CHANGE COLUMN codClient codClient BIGINT UNSIGNED NOT NULL;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsSalesConfig CHANGE COLUMN codCardSupplier codCardSupplier BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE payEarlyCollection CHANGE COLUMN codClient codClient BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE payPayment CHANGE COLUMN codClient codClient BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE tryCheck CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colEarlyPayment CHANGE COLUMN codClient codClient BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colAccountsReceivable CHANGE COLUMN codClient codClient BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colCollection CHANGE COLUMN codClient codClient BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE payAccountsPayable CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE agnCompanyMail CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompanyAddress CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompanyBranch CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompanyPhone CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompanyCreditCard CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompanyIdentityDocument CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE hrsFixedDiscounts CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleContract CHANGE COLUMN codClient codClient BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleContract CHANGE COLUMN codPromoter codPromoter BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE invBrand CHANGE COLUMN codCompany codCompany BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleDetail CHANGE COLUMN codOwner codOwner BIGINT UNSIGNED NOT NULL;
ALTER TABLE invItemMovement CHANGE COLUMN codSupplier codSupplier BIGINT UNSIGNED DEFAULT NULL;

ALTER TABLE pchPayrollExpenses ADD CONSTRAINT fkyPayrollExpensesSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE slsOrderNote ADD CONSTRAINT fkyOrderNoteClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE pchRequestAuthorizationDetail ADD CONSTRAINT fkyRequestAuthorizationDetailSeller FOREIGN KEY (codSeller) REFERENCES agnCompany (pkyCompany);
ALTER TABLE pchReceiptOfGoods ADD CONSTRAINT fkyReceptionOfGoodsSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE pchSupplierCatalog ADD CONSTRAINT fkySupplierCatalogSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE slsSalesNote ADD CONSTRAINT fkySalesNoteClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE pchPurchaseOrder ADD CONSTRAINT fkyPurchaseOrderSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE txsSalesLedger ADD CONSTRAINT fkySalesLedgerClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE txsPurchasesLedger ADD CONSTRAINT fkyPurchasesLedgerClient FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE slsSalesConfig ADD CONSTRAINT fkySalesConfigCardSupplier FOREIGN KEY (codCardSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE payEarlyCollection ADD CONSTRAINT fkyEarlyCollectionClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE payPayment ADD CONSTRAINT fkyPaymentClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE tryCheck ADD CONSTRAINT fkyCheckCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE colEarlyPayment ADD CONSTRAINT fkyEarlyPaymentClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE colAccountsReceivable ADD CONSTRAINT fkyAccountsReceivableClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE colCollection ADD CONSTRAINT fkyCollectionClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayableSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyMail ADD CONSTRAINT fkyCompanyMailCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyAddress ADD CONSTRAINT fkyCompanyAddressCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyBranch ADD CONSTRAINT fkyCompanyBranchCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyPhone ADD CONSTRAINT fkyCompanyPhoneCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyCreditCard ADD CONSTRAINT fkyCompanyCreditCardCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE agnCompanyIdentityDocument ADD CONSTRAINT fkyCompanyIdentityDocumentCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE hrsFixedDiscounts ADD CONSTRAINT fkyFixedDiscountsCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE vhcVehicleContract ADD CONSTRAINT fkyVehicleContractClient FOREIGN KEY (codClient) REFERENCES agnCompany (pkyCompany);
ALTER TABLE vhcVehicleContract ADD CONSTRAINT fkyVehicleContractPromoter FOREIGN KEY (codPromoter) REFERENCES agnCompany (pkyCompany);
ALTER TABLE invBrand ADD CONSTRAINT fkyBrandCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE vhcVehicleDetail ADD CONSTRAINT fkyVehicleDetailOwner FOREIGN KEY (codOwner) REFERENCES agnCompany (pkyCompany);
ALTER TABLE invItemMovement ADD CONSTRAINT fkyItemMovementSupplier FOREIGN KEY (codSupplier) REFERENCES agnCompany (pkyCompany);

ALTER TABLE slsOrderNote DROP FOREIGN KEY fkyOrderNoteSeller;
ALTER TABLE pchPurchaseRequest DROP FOREIGN KEY fkyPurchaseRequestEmployee;
ALTER TABLE slsSalesNote DROP FOREIGN KEY fkySalesNoteSeller;
ALTER TABLE txsTaxesConfig DROP FOREIGN KEY fkyTaxesConfigPerson;
ALTER TABLE slsOrderNoteCounterfoil DROP FOREIGN KEY fkyOrderNoteCounterfoilSeller;
ALTER TABLE payEarlyCollection DROP FOREIGN KEY fkyEarlyCollectionEmployee;
ALTER TABLE payPayment DROP FOREIGN KEY fkyPaymentEmployee;
ALTER TABLE tryCheck DROP FOREIGN KEY fkyCheckEmployee;
ALTER TABLE colEarlyPayment DROP FOREIGN KEY fkyEarlyPaymentEmployee;
ALTER TABLE colAccountsReceivable DROP FOREIGN KEY fkyAccountsReceivableEmployee;
ALTER TABLE colCollection DROP FOREIGN KEY fkyCollectionEmployee;
ALTER TABLE colCollection DROP FOREIGN KEY fkyCollectionCollector;
ALTER TABLE payAccountsPayable DROP FOREIGN KEY fkyAccountsPayableEmployee;
ALTER TABLE agnPersonMail DROP FOREIGN KEY fkyPersonMailPerson;
ALTER TABLE hrsDiscountException DROP FOREIGN KEY fkyDiscountExceptionEmployee;
ALTER TABLE agnCompany DROP FOREIGN KEY fkyCompanySeller;
ALTER TABLE agnPersonAddress DROP FOREIGN KEY fkyPersonAddressPerson;
ALTER TABLE agnPersonPhone DROP FOREIGN KEY fkyPersonPhonePerson;
ALTER TABLE hrsSalesCommission DROP FOREIGN KEY fkySalesCommissionEmployee;

ALTER TABLE agnPerson CHANGE COLUMN pkyPerson pkyPerson BIGINT UNSIGNED NOT NULL FIRST;

ALTER TABLE slsOrderNote CHANGE COLUMN codSeller codSeller BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchPurchaseRequest CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsSalesNote CHANGE COLUMN codSeller codSeller BIGINT UNSIGNED NOT NULL;
ALTER TABLE txsTaxesConfig CHANGE COLUMN codPerson codPerson BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE slsOrderNoteCounterfoil CHANGE COLUMN codSeller codSeller BIGINT UNSIGNED NOT NULL;
ALTER TABLE payEarlyCollection CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE payPayment CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE tryCheck CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colEarlyPayment CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colAccountsReceivable CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colCollection CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE colCollection CHANGE COLUMN codCollector codCollector BIGINT UNSIGNED NOT NULL;
ALTER TABLE payAccountsPayable CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE agnPersonMail CHANGE COLUMN codPerson codPerson BIGINT UNSIGNED NOT NULL;
ALTER TABLE hrsDiscountException CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnCompany CHANGE COLUMN codSeller codSeller BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE agnPersonAddress CHANGE COLUMN codPerson codPerson BIGINT UNSIGNED NOT NULL;
ALTER TABLE agnPersonPhone CHANGE COLUMN codPerson codPerson BIGINT UNSIGNED NOT NULL;
ALTER TABLE hrsSalesCommission CHANGE COLUMN codEmployee codEmployee BIGINT UNSIGNED NOT NULL;

ALTER TABLE slsOrderNote ADD CONSTRAINT fkyOrderNoteSeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson);
ALTER TABLE pchPurchaseRequest ADD CONSTRAINT fkyPurchaseRequestEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE slsSalesNote ADD CONSTRAINT fkySalesNoteSeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson);
ALTER TABLE txsTaxesConfig ADD CONSTRAINT fkyTaxesConfigPerson FOREIGN KEY (codPerson) REFERENCES agnPerson (pkyPerson);
ALTER TABLE slsOrderNoteCounterfoil ADD CONSTRAINT fkyOrderNoteCounterfoilSeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson);
ALTER TABLE payEarlyCollection ADD CONSTRAINT fkyEarlyCollectionEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE payPayment ADD CONSTRAINT fkyPaymentEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE tryCheck ADD CONSTRAINT fkyCheckEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE colEarlyPayment ADD CONSTRAINT fkyEarlyPaymentEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE colAccountsReceivable ADD CONSTRAINT fkyAccountsReceivableEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE colCollection ADD CONSTRAINT fkyCollectionEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE colCollection ADD CONSTRAINT fkyCollectionCollector FOREIGN KEY (codCollector) REFERENCES agnPerson (pkyPerson);
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayableEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE agnPersonMail ADD CONSTRAINT fkyPersonMailPerson FOREIGN KEY (codPerson) REFERENCES agnPerson (pkyPerson);
ALTER TABLE hrsDiscountException ADD CONSTRAINT fkyDiscountExceptionEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);
ALTER TABLE agnCompany ADD CONSTRAINT fkyCompanySeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson);
ALTER TABLE agnPersonAddress ADD CONSTRAINT fkyPersonAddressPerson FOREIGN KEY (codPerson) REFERENCES agnPerson (pkyPerson);
ALTER TABLE agnPersonPhone ADD CONSTRAINT fkyPersonPhonePerson FOREIGN KEY (codPerson) REFERENCES agnPerson (pkyPerson);
ALTER TABLE hrsSalesCommission ADD CONSTRAINT fkySalesCommissionEmployee FOREIGN KEY (codEmployee) REFERENCES agnPerson (pkyPerson);

1.8.6 Client  
1.8.6 Server
// 2013-08-21 SVN:409
// Leucadio
// LICENCIAR Y SINCRONIZAR ( LA SINC. DEBE REALIZARSE ANTES DE LOS COMANDOS Y TAMBIEN DESPUES) !!!

/*
 * Planillas : Altas, bajas y trasferencias
 * Planillas : Campos en persona, reorganización del UI de persona
 * Inventario: Orden de Tab en mov de mercadería
 * Nuevos datos en tipos de empresa
 * Tipos de empleado (Eventual, Contrato, Permanente)
 * Idiomas que habla el empleado
 * Cursos que tomo el empleado
 * Documentos de empleado
 * Dependientes de empleado
 * BUG: En raras ocasiones no jalaba bien el concepto al hacer una venta en CxC y Mov.Bancos
 * BUG: Decimales en tipos de cambio. Corrección del texto.
 * BUG: En generación automática de número de doc. en la nota venta
 * BUG: En configuracion de base de datos
 */

ALTER TABLE actExchangeRateDetail CHANGE COLUMN fldRate fldRate DECIMAL(20,10) NOT NULL DEFAULT 1.00;
ALTER TABLE agnPerson ADD COLUMN fldBasicSalary DECIMAL(30,10) NOT NULL DEFAULT 0.00 AFTER blbImage;
ALTER TABLE agnPerson ADD COLUMN fldHealthFundCode VARCHAR(50) NULL DEFAULT NULL AFTER fldBasicSalary;
ALTER TABLE agnPerson ADD COLUMN fldRetirementPensionCode VARCHAR(50) NULL DEFAULT NULL AFTER fldHealthFundCode;
ALTER TABLE agnPerson ADD COLUMN codEmployeeType TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldRetirementPensionCode;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonEmployeeType FOREIGN KEY (codEmployeeType) REFERENCES agnEmployeeType (pkyEmployeeType);
ALTER TABLE agnPerson ADD COLUMN fldActive BOOL NOT NULL DEFAULT 0 AFTER codEmployeeType;
ALTER TABLE agnPerson ADD COLUMN codBranch MEDIUMINT UNSIGNED NULL DEFAULT NULL AFTER fldActive;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonEmployeeBranch FOREIGN KEY (codBranch) REFERENCES agnCompanyBranch (pkyCompanyBranch);
ALTER TABLE agnPerson ADD COLUMN fldRetirementAge TINYINT UNSIGNED NOT NULL DEFAULT 60 AFTER codBranch;

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
DELETE FROM regLanguage;
DELETE FROM agnIdentityDocumentType;
DELETE FROM agnCompanyType;
SET FOREIGN_KEY_CHECKS=TRUE;

1.8.7 Client  
1.8.7 Server
// 2013-09-19 SVN:410
// Vaquita Chachona
// LICENCIAR Y SINCRONIZAR

/*
 * Planillas : Anulacion correcta en movimientos de empleados
 * Planillas : Datos por defecto en bonos de antiguedad
 * Inventario : Lotes
 * Inventario : Codigo item BIGINT
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
DROP TABLE hrsEmployeeMovement;
DROP TABLE invItemMovementDetailBatch;
ALTER TABLE invInventoryConfig CHANGE COLUMN fldCostDecimalDigits fldUseBatches BOOL NOT NULL DEFAULT 0;
UPDATE invInventoryConfig SET fldUseBatches = 0;

ALTER TABLE payAccountsPayableDetail DROP FOREIGN KEY fkyAccountsPayableDetailItem;
ALTER TABLE invItemMovementConsolidated DROP FOREIGN KEY fkyItemMovementConsolidatedItem;
ALTER TABLE invItemMovementDetail DROP FOREIGN KEY fkyItemMovementDetailItem;
ALTER TABLE invItemMovement DROP FOREIGN KEY fkyItemMovementItem;
ALTER TABLE slsOrderNoteDetail DROP FOREIGN KEY fkyOrderNoteDetailItem;
ALTER TABLE prdPreproductionNoteDetail DROP FOREIGN KEY fkyPreproductionNoteDetailItem;
ALTER TABLE prdPreproductionNoteDetailRecipe DROP FOREIGN KEY fkyPreproductionNoteDetailRecipeItem;
ALTER TABLE slsPriceListDetail DROP FOREIGN KEY fkyPriceListDetailItem;
ALTER TABLE prdProductionOrderDetail DROP FOREIGN KEY fkyProductionOrderDetailItem;
ALTER TABLE prdProductionOrderDetailRecipe DROP FOREIGN KEY fkyProductionOrderDetailRecipeItem;
ALTER TABLE pchPurchaseOrderDetail DROP FOREIGN KEY fkyPurchaseOrderDetailItem;
ALTER TABLE pchPurchaseRequestDetail DROP FOREIGN KEY fkyPurchaseRequestDetailItem;
ALTER TABLE pchReceiptOfGoodsDetail DROP FOREIGN KEY fkyReceiptOfGoodsDetailItem;
ALTER TABLE prdRecipeDetail DROP FOREIGN KEY fkyRecipeDetailItem;
ALTER TABLE prdRecipe DROP FOREIGN KEY fkyRecipeItem;
ALTER TABLE pchRequestAuthorizationDetail DROP FOREIGN KEY fkyRequestAuthorizationDetailItem;
ALTER TABLE hrsSalesCommission DROP FOREIGN KEY fkySalesCommissionItem;
ALTER TABLE slsSalesNoteDetail DROP FOREIGN KEY fkySalesNoteDetailItem;
ALTER TABLE pchSupplierCatalog DROP FOREIGN KEY fkySupplierCatalogItem;
ALTER TABLE vhcVehicleContract DROP FOREIGN KEY fkyVehicleContractVehicle;
ALTER TABLE vhcVehicleDetail DROP FOREIGN KEY fkyVehicleDetailItem;
ALTER TABLE vhcVehicleEquipmentDetail DROP FOREIGN KEY fkyVehicleEquipmentDetailItem;
ALTER TABLE vhcVehiclesConfig DROP FOREIGN KEY fkyVehiclesConfigFuelItem;
ALTER TABLE vhcVehiclesConfig DROP FOREIGN KEY fkyVehiclesConfigMileageItem;
ALTER TABLE vhcVehiclesConfig DROP FOREIGN KEY fkyVehiclesConfigHourItem;
ALTER TABLE vhcVehiclesConfig DROP FOREIGN KEY fkyVehiclesConfigDayItem;

ALTER TABLE invItem CHANGE COLUMN pkyItem pkyItem BIGINT UNSIGNED NOT NULL FIRST;

ALTER TABLE payAccountsPayableDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE invItemMovementConsolidated CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE invItemMovementDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE invItemMovement CHANGE COLUMN codItem codItem BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE slsOrderNoteDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdPreproductionNoteDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdPreproductionNoteDetailRecipe CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsPriceListDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdProductionOrderDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdProductionOrderDetailRecipe CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchPurchaseOrderDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchPurchaseRequestDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchReceiptOfGoodsDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdRecipeDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE prdRecipe CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchRequestAuthorizationDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE hrsSalesCommission CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE slsSalesNoteDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE pchSupplierCatalog CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleContract CHANGE COLUMN codVehicle codVehicle BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehicleEquipmentDetail CHANGE COLUMN codItem codItem BIGINT UNSIGNED NOT NULL;
ALTER TABLE vhcVehiclesConfig CHANGE COLUMN codFuelItem codFuelItem BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE vhcVehiclesConfig CHANGE COLUMN codMileageItem codMileageItem BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE vhcVehiclesConfig CHANGE COLUMN codHourItem codHourItem BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE vhcVehiclesConfig CHANGE COLUMN codDayItem codDayItem BIGINT UNSIGNED DEFAULT NULL;

ALTER TABLE payAccountsPayableDetail ADD CONSTRAINT fkyAccountsPayableDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE invItemMovementConsolidated ADD CONSTRAINT fkyItemMovementConsolidatedItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE invItemMovementDetail ADD CONSTRAINT fkyItemMovementDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE invItemMovement ADD CONSTRAINT fkyItemMovementItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE slsOrderNoteDetail ADD CONSTRAINT fkyOrderNoteDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdPreproductionNoteDetail ADD CONSTRAINT fkyPreproductionNoteDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdPreproductionNoteDetailRecipe ADD CONSTRAINT fkyPreproductionNoteDetailRecipeItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE slsPriceListDetail ADD CONSTRAINT fkyPriceListDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdProductionOrderDetail ADD CONSTRAINT fkyProductionOrderDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdProductionOrderDetailRecipe ADD CONSTRAINT fkyProductionOrderDetailRecipeItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE pchPurchaseOrderDetail ADD CONSTRAINT fkyPurchaseOrderDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE pchPurchaseRequestDetail ADD CONSTRAINT fkyPurchaseRequestDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE pchReceiptOfGoodsDetail ADD CONSTRAINT fkyReceiptOfGoodsDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdRecipeDetail ADD CONSTRAINT fkyRecipeDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE prdRecipe ADD CONSTRAINT fkyRecipeItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE pchRequestAuthorizationDetail ADD CONSTRAINT fkyRequestAuthorizationDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE hrsSalesCommission ADD CONSTRAINT fkySalesCommissionItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE slsSalesNoteDetail ADD CONSTRAINT fkySalesNoteDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE pchSupplierCatalog ADD CONSTRAINT fkySupplierCatalogItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehicleContract ADD CONSTRAINT fkyVehicleContractVehicle FOREIGN KEY (codVehicle) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehicleDetail ADD CONSTRAINT fkyVehicleDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehicleEquipmentDetail ADD CONSTRAINT fkyVehicleEquipmentDetailItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehiclesConfig ADD CONSTRAINT fkyVehiclesConfigFuelItem FOREIGN KEY (codFuelItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehiclesConfig ADD CONSTRAINT fkyVehiclesConfigMileageItem FOREIGN KEY (codMileageItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehiclesConfig ADD CONSTRAINT fkyVehiclesConfigHourItem FOREIGN KEY (codHourItem) REFERENCES invItem (pkyItem);
ALTER TABLE vhcVehiclesConfig ADD CONSTRAINT fkyVehiclesConfigDayItem FOREIGN KEY (codDayItem) REFERENCES invItem (pkyItem);

1.9.0 Client  
1.9.0 Server
// 2013-10-08 SVN:411
// Lotero

/*
 * Inventario : Lotes Completos incluyendo produccion, anulacion y validacion
 * Inventario : Cada familia tiene una cuenta de costo asociada ( Ya no se usa la cuenta de costo del local de venta ) * 
 * Tesoreria : Impresion de comprobante de cheques 
 * Ventas : Acepta generacion de facturas con impuestos 0 
 * Agenda : BUG al inicializar nueva base
 * Pagos : BUG que impedia realizar algunas liquidaciones
 * Pagos : BUG al pagar con banco a veces pedia validaba saldo en caja chica
 */

ALTER TABLE invItemCategory DROP FOREIGN KEY fkyItemCategoryCostCenter;
ALTER TABLE invItemCategory CHANGE COLUMN codCostCenter codCostAccount BIGINT UNSIGNED DEFAULT NULL;
ALTER TABLE invItemCategory ADD CONSTRAINT fkyItemCategoryCostAccount FOREIGN KEY (codCostAccount) REFERENCES actAccount (pkyAccount);
UPDATE invItemCategory SET codCostAccount = (SELECT codItemCostAccount FROM slsSalesPlace LIMIT 1,1) WHERE fldLevel = 1;
DROP TABLE invItemMovementDetailBatch;
DROP TABLE invItemBatch;

1.9.1 Client  
1.9.1 Server
// 2013-10-17 SVN:413
// Polizonte
// LICENCIAR

/*
 * Pagos : Polizas
 * Impuestos : Porcentaje por defecto para impuestos de importaciones
 * Ventas : Voucher lista de precios
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

ALTER TABLE txsTaxesConfig ADD COLUMN fldImportPercent DECIMAL(13,10) NOT NULL DEFAULT 0.00 AFTER codPerson;
ALTER TABLE payAccountsPayableDetail ADD COLUMN codImportDocument BIGINT UNSIGNED DEFAULT NULL AFTER codItem;
ALTER TABLE payAccountsPayableDetail ADD CONSTRAINT fkyAccountsPayableDetailImportDocument FOREIGN KEY (codImportDocument) REFERENCES pchImportDocument (pkyImportDocument);

1.9.2 Client  
1.9.2 Server
// 2013-10-22 SVN: 415
// Chancho calancho
// LICENCIAR

/*
 * Inventario : Gastos en traspasos ( incluyendo lotes, anulacion y asiento )
 * Ventas : BUG en notas de venta cuando items eran todos de servicio
 * CxP: BUG en generacion de cuentas
 * General: BUG probable solucion al problema de registros duplicados en el panel de busqueda
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

ALTER TABLE pchPayrollExpenses ADD COLUMN fldUsed BOOL NOT NULL DEFAULT 0 AFTER codPendingTaxAccountEntry;
CREATE INDEX indPayrollExpensesUsed ON pchPayrollExpenses (fldUsed);
ALTER TABLE pchPayrollExpenses CHANGE COLUMN codPurchaseOrder codPurchaseOrder BIGINT UNSIGNED DEFAULT NULL;
UPDATE pchPayrollExpenses SET fldUsed = 1;
ALTER TABLE invItemMovementDetail ADD COLUMN fldExtraCost DECIMAL(30,10) NOT NULL DEFAULT 0.00 AFTER fldCost;

1.9.3 Client  
1.9.3 Server
// 2013- SVN: 
// Dos pollitos sucios

/*
 * Ventas : Restringir uso de almacén en ventas para usuarios
 * General : Copia de glosa a todos los movimientos hijos
 * General : BUG Arreglado problema de la glosa que se replicaba al introducir un nuevo registro * 
 */

ALTER TABLE accUser ADD COLUMN codWarehouse MEDIUMINT UNSIGNED DEFAULT NULL AFTER fldAlternativeKey;
ALTER TABLE accUser ADD CONSTRAINT fkyUserWarehouse FOREIGN KEY (codWarehouse) REFERENCES invWarehouse (pkyWarehouse);

1.9.4 Client  
1.9.4 Server
// 2013-11-26 SVN:420
// Noe no era marinero

/*
 * RRHH : Retroactivos
 * Inventario BUG: En item permite introducir el caracter '/'
 * CxP BUG: Anulación de CxP con tipo poliza
 * Compras BUG: Asiento de Planilla de gastos acepta con impuesto IVA = 0
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
DROP TABLE hrsSalaryReimbursement;

1.9.5 Client  
1.9.5 Server
// 2013-12-06 SVN:423
// Sapo Canalla

/*
 * Ventas: BUG de repetición de  número de factura
 * Accesos: Es posible deshabilitar usuarios ( Anulandolos )
 * Planilla de Gastos: Al grabar, cuando pide llenar las facturas, es posible cancelar sin necesidad de llenar todos los datos
 * Planilla de Gastos: Si se tienen facturas con excento, entonces calcula correctamente el costo
 * CxP: Al grabar, cuando pide llenar las facturas, es posible cancelar sin necesidad de llenar todos los datos * 
 */

ALTER TABLE pchPayrollExpensesDetail ADD COLUMN fldNetAmount DECIMAL(40,10) NOT NULL DEFAULT 0.00 AFTER codInvoice;

1.9.6 Client  
1.9.6 Server
// 2014-01-16 SVN: 430
// Sapo Canalla II (La Venganza)

/*
 * Ventas: BUG La nota de venta suporpone el nro. de factura introducido cuando la dosificación es de tipo Manual
 * Ventas: BUG Diferentes problemas en la anulaciond e la nota de venta
 * Inventario: BUG Cuando se hace un traspaso con gastos y en la sesion no se inicializo el componente de recepciones, Pulzar se tira
 * Core: BUG Cuando se usan filtros en la introducción de registros, el sistema cae.
 * Producción: Proyección de producción
 * Producción: Jalar costos de producción indirectos en la orden de producción
 * Agenda: Campo para ciudad de origen
 * Ventas: Flag para impresión de datos de cabecera
 * Contabilidad: Cuando se introduce una factura directamente por asiento, es posible cambiar el total con el excento
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
DROP TABLE hrsHumanResourcesConfig;
DROP TABLE hrsEmployeeDocument;
ALTER TABLE prdProductionOrder ADD COLUMN codProjection BIGINT UNSIGNED DEFAULT NULL AFTER codItemMovementIn;
ALTER TABLE prdProductionOrder ADD CONSTRAINT fkyprdProductionOrderProjection FOREIGN KEY (codProjection) REFERENCES prdProductionProjection (pkyProductionProjection);
ALTER TABLE prdProductionOrder ADD COLUMN codAccountEntry BIGINT UNSIGNED DEFAULT NULL AFTER codProjection;
ALTER TABLE prdProductionOrder ADD CONSTRAINT fkyprdProductionOrderAccountEntry FOREIGN KEY (codAccountEntry) REFERENCES actAccountEntry (pkyAccountEntry);

1.10.0 Client  
1.10.0 Server
// 2014-02-14 SVN:430
// Rococo hipopotamoso

/*
 * Producción: Costos indirectos y proyectados
 */

ALTER TABLE prdProductionOrderDetail ADD COLUMN fldExtraCost DECIMAL(40,10) NOT NULL DEFAULT 0.00 AFTER fldQuantity;
DROP TABLE prdProductionOrderConcept;
ALTER TABLE prdProductionOrder ADD COLUMN codExchangeRate BIGINT UNSIGNED NOT NULL  AFTER codAccountEntry;
UPDATE prdProductionOrder SET codExchangeRate = (SELECT MAX(pkyExchangeRate) FROM actExchangeRate WHERE sysEnabled = 1) ;
ALTER TABLE prdProductionOrder ADD CONSTRAINT fkyProductionOrderExchangeRate FOREIGN KEY (codExchangeRate) REFERENCES actExchangeRate (pkyExchangeRate);

1.10.1 Client  
1.10.1 Server
// 2014-02-27 SVN: 433
// La oruga de Jacinto

/*
 * General: Anulación funciona con permisos restringidos
 * Inventario: Solo se puede hacer movimientos con el almacén asignado
 * Inventario: Flag para imprimir costo disponible en la configuración del módulo
 * Ventas: En configuración del módulo es posible bloquear el cambio de precios
 * Compras: Error al anular planillas de gasto no jala la orden de compra correctamente
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE slsSalesConfig ADD COLUMN fldBlockPrice TINYINT(1) NOT NULL DEFAULT 0.00 AFTER fldGenerateDocNumber;
ALTER TABLE invInventoryConfig ADD COLUMN fldPrintCost BOOL NOT NULL DEFAULT 1 AFTER fldUseBatches;

1.10.2 Client  
1.10.2 Server
// 2014-03-27 SVN: 
// La Cerdita Peppa
// SINCRONIZAR

/*
 * Contabilidad: Cierre de gestión
 * Contabilidad: Ajuste X Tipo de cambio
 * Producción: Insumos Extra
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.10.3 Client  
1.10.3 Server
// 2014-04-24 SVN:435
// Cucurucucuuuuuuuu x 3
// SINCRONIZAR

/*
 * Accesos: Generar accesos para anulación de comprobantes
 * Caja: Agregar opción para que usuarios normales puedan revisar los kardex de todas las cajas
 * General: Las ventanas emergentes (hijas) tienen un boton para minimizar
 * Voucher: De proyección y receta de producción
 * BUG: Doble click en aceptar a raras ocasiones genera dobles transacciones de hijos
 * BUG: Gastos en inventarios no controla que la planilla de gastos no haya sido usada
 * BUG: En producción no deja usar proyecciones usadas
 * BUG: Nombre de empleado invierte los apellidos en transacciones
 */

ALTER TABLE ptcPettyCashConfig ADD COLUMN fldReportRestriction BOOL NOT NULL DEFAULT 0 AFTER codExchangeRateAccount;
ALTER TABLE accAccessComponent ADD COLUMN fldDisable BOOL NOT NULL DEFAULT 1 AFTER fldWrite;

1.10.4 Client  
1.10.4 Server
// 2014-05-20 SVN:
// Alboroto Kid
// SINCRONIZAR

/*
 * CxP: Campo para cerrar proyecciones
 * CxP: Boletos de avión
 * Produccion: En el comprobante agregar opcion para ocultar costos indirectos
 * Ventas: Copiar glosa de orden de venta a la nota
 * Vehiculos: Aumentar tamano en campo de km acordados
 * BUG: En el movimiento de egreso de inventario generado por una orden de producción, en el total no suma el costo extra
 * BUG: Agrandar descripciones de pagos y asientos
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE payAccountsPayable ADD COLUMN codProductionProjection BIGINT UNSIGNED DEFAULT NULL AFTER codPendingTaxAccountEntry;
ALTER TABLE payAccountsPayable ADD CONSTRAINT fkyAccountsPayableProductionProjection FOREIGN KEY (codProductionProjection) REFERENCES prdProductionProjection (pkyProductionProjection);
ALTER TABLE payPayment CHANGE COLUMN txtDescription txtDescription VARCHAR(300) NULL DEFAULT NULL;
ALTER TABLE actAccountEntry CHANGE COLUMN txtDescription txtDescription VARCHAR(500) NULL DEFAULT NULL;
ALTER TABLE vhcVehicleContract CHANGE COLUMN fldMileageRented fldMileageRented MEDIUMINT NOT NULL DEFAULT 1;

1.10.5 Client  
1.10.5 Server
// 2014-06- SVN:
// Alborotero (La Venganza)
// SINCRONIZAR

/*
 * BUG: Al grabar el 2do movimiento en una CxP de tipo Posterior, el asiento lo graba con la fecha del movimiento inicial y no con el de la factura
 * BUG: En ventas no jala el precio si es el primer movimiento
 * BUG: No permite guiones en nombres de item ya que existen problemas en las producciones con proyecciones
 * BUG: Al anular pagos, a veces no anula los mov. generados
 * BUG: Al insertar registros o parámetros, si existe error en la base ya no es posible insertar o editar mas del mismo componente
 * BUG: Cuando se imprime cabecera en ventas, se debe volver a cambiar el setea al añadir nuevo registro o editar 
 * Ventas: Distintos tipos de control de escritura en campos de  descuento y precio de la nota de venta
 * Tesorería: Parámetros para la generación de la CxP del ITF 
 * Pagos: Generacion automática del ITF
 */

ALTER TABLE agnPerson ADD COLUMN fldMinimumUnit BOOL NOT NULL DEFAULT 0 AFTER fldRetirementAge;
ALTER TABLE hrsHumanResourcesConfig ADD fldManWorkingHours SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER codSalaryReimbursementExpenseConcept;
ALTER TABLE hrsHumanResourcesConfig ADD fldWomanWorkingHours SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldManWorkingHours;
ALTER TABLE hrsHumanResourcesConfig ADD fldManWorkingDays SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldWomanWorkingHours;
ALTER TABLE hrsHumanResourcesConfig ADD fldWomanWorkingDays SMALLINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldManWorkingDays;
ALTER TABLE slsSalesConfig ADD COLUMN fldDisableDetailDiscount BOOL NOT NULL DEFAULT 0 AFTER txtDefaultDescription;
ALTER TABLE slsSalesConfig ADD COLUMN fldDisableGlobalDiscount BOOL NOT NULL DEFAULT 0 AFTER fldDisableDetailDiscount;
ALTER TABLE slsSalesConfig ADD COLUMN fldPriceListLimit BOOL NOT NULL DEFAULT 0 AFTER fldDisableGlobalDiscount;
ALTER TABLE actAccountingConfig ADD COLUMN fldSalesRoundDigits BOOL NOT NULL DEFAULT 0 AFTER fldAccountEntryDecimalDigits;
ALTER TABLE actAccountingConfig ADD COLUMN codRoundUpAccount BIGINT UNSIGNED DEFAULT NULL AFTER fldSalesRoundDigits;
ALTER TABLE actAccountingConfig ADD CONSTRAINT fkyAccountingConfigRoundUpAccount FOREIGN KEY (codRoundUpAccount) REFERENCES actAccount (pkyAccount);
ALTER TABLE tryTreasuryConfig ADD COLUMN codBankTaxConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codCheckReturnIncomeConcept;
ALTER TABLE tryTreasuryConfig ADD COLUMN codBankTaxApplication SMALLINT UNSIGNED DEFAULT NULL AFTER codBankTaxConcept;
ALTER TABLE tryTreasuryConfig ADD COLUMN fldBankTaxPercent  DECIMAL(40,10) NOT NULL DEFAULT 0.00 AFTER codBankTaxApplication;
ALTER TABLE tryTreasuryConfig ADD CONSTRAINT fkyTreasuryConfigBankTaxConcept FOREIGN KEY (codBankTaxConcept) REFERENCES payAccountsPayableConcept (pkyAccountsPayableConcept);
ALTER TABLE tryTreasuryConfig ADD CONSTRAINT fkyTreasuryConfigBankTaxApplication FOREIGN KEY (codBankTaxApplication) REFERENCES payExpensesConcept (pkyExpensesConcept);

1.10.6 Client  
1.10.6 Server
// 2014-07-16 SVN:
// The Cat Lady
// SINCRONIZAR

/*
 * BUG: En la nota de venta, en algunas ocasiones graba la CxC con el concepto de ingreso incorrecto 
 * BUG: Traspasos en caja no genera asiento correcto
 * Compras: Cuando se anula autorizaciones de requerimientos, estos ya pueden escogerse nuevamente
 * ARREGLOS VARIOS
 */

ALTER TABLE tryBank ADD COLUMN codCompany BIGINT UNSIGNED DEFAULT NULL AFTER fldName;
ALTER TABLE tryBank ADD CONSTRAINT fkyBankCompany FOREIGN KEY (codCompany) REFERENCES agnCompany (pkyCompany);
ALTER TABLE pchPurchaseRequest ADD COLUMN codRequestAuthorization BIGINT UNSIGNED DEFAULT NULL AFTER fldUsed;
ALTER TABLE pchPurchaseRequest ADD CONSTRAINT fkyPurchaseRequestAuthorization FOREIGN KEY (codRequestAuthorization) REFERENCES pchRequestAuthorization (pkyRequestAuthorization);

1.10.7 Client  
1.10.7 Server
// 2014-07- SVN:
// Bugless
// SINCRONIZAR

/*
 * BUG: En accesos de usuarios graba varias veces el mismo registro cuando se graba un registro
 * BUG: Descripción de algunos movimientos de caja y CxC no deja grabar porque son muy largos
 * BUG: Cuando el código de un cmponente tipo registr es muy grande, los detalles no pueden capturar el codigo
 * RRHH: Vacaciones
 * RRHH: Tiempo trabajado
 * RRHH: Planilla de empleado Parte 1/4
 */

ALTER TABLE colAccountsReceivable CHANGE COLUMN txtDescription txtDescription VARCHAR(350) NULL DEFAULT NULL;
ALTER TABLE ptcPettyCashMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(350) NULL DEFAULT NULL;

1.10.8 Client  
1.10.8 Server
// 2014-09-21 SVN:
// Bugless II
// SINCRONIZAR

/*
 * RRHH: En formulario de impuestos, calcular el IVA  redondeado 
 * RRHH: Agregar faltas en tiempo trabajado
 * RRHH: Agregar parámetro de horas extra recargo (%)
 * RRHH: Coeficiente para horas extras
 * Produccion: Totales en detalle de produccion
 * BUG: Cuando otra persona mete nota de venta, borra la glosa de la otra que está introduciendo el registro
 * BUG: Pago no se puede anular cuando es una liquidación de tipo efectivo
 * BUG: Cuando la cuenta de CxP y CxC de una liquidación es la misma, no puede generar el asiento
 * BUG: Pago en dolares genera ITF del pago del ITF
 * BUG: En algunas ocasiones en la venta,no copia el numero de documento a la CxC
 * BUG: En movimientos que usan banco, en raras ocasiones pedían caja
 * BUG: En raras ocasiones, en ventas escoge mal el concepto de CxC
 * BUG: Al editar contrato de vehículo no jala el total extra gastado de gasolina
 * BUG: Al editar proyecciones en raras ocasiones duplica items
 */

DROP TABLE hrsTaxesFormDetail;
DROP TABLE hrsWorkedTimeDetail;
DROP TABLE hrsHumanResourcesConfig;
ALTER TABLE agnPerson ADD COLUMN codMaritalStatus TINYINT UNSIGNED NOT NULL DEFAULT 2 AFTER fldMinimumUnit;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonMaritalStatus FOREIGN KEY (codMaritalStatus) REFERENCES agnMaritalStatus (pkyMaritalStatus);

1.11.0 Client  
1.11.0 Server
// 2015-01-12 SVN:470
// Don Rococo
// SINCRONIZAR

/*
 * Agenda: Permitir parentesis y nombres largos en agenda y facturas
 * Ventas: Control de items repetidos excepto en bonificaciones
 * Ventas: Descuento global se calcula en base el descuento parcial y no al total bruto original
 * Ventas: Agregar campo de descuento en facturas y modificar el ingreso de todos los componentes que usan facturas de venta
 * Compras: Agregar campo de descuento en facturas y modificar el ingreso de todos los componentes que usan facturas de compra
 * CxP: Posibilidad de ocultar registros para usuarios normales
 * General: Glosas ya no se borran cuando otro cliente realiza un registro usando el mismo componente
 * Activos Fijos: Creación de la clasificación y de la activación de activos fijos
 * Activos Fijos: Registro de Activo Fijo
 * BUG: En la clasificación de items no se podía grabar dos veces seguidas
 * BUG: En contrato de vehículos no se puede meter kilometraje a rentar más de 9999 Km
 * BUG: En contrato de vehículos no se puede cerrar contrato con 0 litros
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE txsSalesLedger CHANGE COLUMN fldName fldName VARCHAR(100) NOT NULL;
ALTER TABLE agnCompany CHANGE COLUMN fldName fldName VARCHAR(100) NOT NULL;
ALTER TABLE agnPerson ADD COLUMN codDocumentNumber BIGINT UNSIGNED DEFAULT NULL AFTER codMaritalStatus;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonDocumentNumber FOREIGN KEY (codDocumentNumber) REFERENCES hrsEmployeeMovement (pkyEmployeeMovement);
ALTER TABLE txsPurchasesLedger ADD COLUMN fldDiscount DECIMAL(30,10) NOT NULL DEFAULT 0.00 AFTER fldTaxCredit;
ALTER TABLE txsSalesLedger ADD COLUMN fldDiscount DECIMAL(30,10) NOT NULL DEFAULT 0.00 AFTER codAuthorizationControl;

1.11.1 Client  
1.11.1 Server
// 2015-02-12 SVN:470
// Morosito
// SINCRONIZAR

/*
 * BUG: Crash cuando se factura tipo posterior 
 * Facturas: En compras el nombre se amplio a 100 caracteres
 * Activos Fijos: Altas activos fijos
 */

ALTER TABLE txsPurchasesLedger CHANGE COLUMN fldName fldName VARCHAR(100) NOT NULL;

1.11.2 Client  
1.11.2 Server
// Paramecio Rechoncho
// 2015-05- SVN:
// 
// SINCRONIZAR

/*
 * Activos Fijos: Altas, Actulización de valor, Depreciación
 * CxP: Gestion de concepto de gasto de tipo activo fijo
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
DROP TABLE fasFixedAssetMovement;
DROP TABLE fasFixedAsset;
DROP TABLE fasFixedAssetsConfig;
INSERT INTO payExpensesConcept VALUES(20,'Activo Fijo en Tránsito',NULL,0,NULL,1,0,1,2,0,1);
ALTER TABLE fasFixedAssetCategory ADD COLUMN fldDepreciationTime SMALLINT UNSIGNED DEFAULT '1' AFTER codRevaluationAccount;

1.12.1 Client  
1.12.1 Server
// El cienpíes de tres piés
// 2015-06- SVN:
// 
// SINCRONIZAR

/*
 * Activos Fijos: Bajas, traspasos, controles, Actualización de valor, Depreciación, anulación
 */

ALTER TABLE fasFixedAsset ADD COLUMN fldUpdatedAccumulatedDepreciationValue DECIMAL(30,10) DEFAULT 0 AFTER fldYearDepreciationValue;
ALTER TABLE fasFixedAssetCategory ADD COLUMN fldIsDepreciated BOOL DEFAULT 0 AFTER fldDepreciationTime;
ALTER TABLE payAccountsPayableDetail DROP FOREIGN KEY fkyAccountsPayableDetailInvoice;

ALTER TABLE fasFixedAssetDepreciation ADD COLUMN codFamily BIGINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE fasFixedAssetDepreciation ADD CONSTRAINT fkyFixedAssetDepreciationFamily FOREIGN KEY (codFamily) REFERENCES fasFixedAssetCategory (pkyFixedAssetCategory);

1.12.2 Client  
1.12.2 Server
// Caracolio
// 2015-07- SVN:
// 

/*
 * Activos Fijos: Cierre de año
 * General: Panel de búsqueda permite búsquedas dinámicas
 * Ventas: Calcular el cambio en nota de venta
 * Ventas: Agregar cliente nuevo desde nota de venta 
 * Produccion: copiar el numero de documento
 */

 ALTER TABLE agnCompany DROP INDEX inuCompanyName; 
 
1.12.3 Client  
1.12.3 Server
// Merluzo
// 2015-07- SVN:
// 

/* 
 * Recepciones: Generar correctamente CxP cuando hay descuentos en orden de compra
 * Recepciones: Generar correctamente CxP cuando hay retenciones
 * Compras: Generacion de CxP con moneda igual al de la orden de compra
 * CxP: No permite la generación de facturas del mes anterior
 * AF: Varios campos extras para reportes
 */
 
ALTER TABLE agnCompany DROP INDEX inuCompanyAlternativeKey;
ALTER TABLE fasFixedAssetDepreciationDetail ADD COLUMN fldAccumulatedValue DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldValue;
ALTER TABLE fasFixedAssetValueUpdateDetail ADD COLUMN fldPreviousUpdatedValue DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldAccumulatedDepreciation,
  ADD COLUMN fldPreviousAccumulatedDepreciation DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldPreviousUpdatedValue;

1.12.4 Client  
1.12.4 Server
// Ogrito Agrito
// 2015-08- SVN:
// 

/* 
 * AF: Campo para prevenir que algunos items se actualicen
 * AF: Calculo de depreciación cuando valor final igual a 1
 * Contablidad: Arreglar cierre de año fiscal para gestiones que no empiezan en enero
 * Producción: Arreglar fecha de cierre en proyecciones 
 * Ventas: Al agregar nuevo cliente el sistema cae porque no puede acceder a la lista de precios
 * Ventas: Considerar el caso en que el NIT sea 0 y cliente repetido
 * Filtros de clientes y caja arreglados
 * Planillas de Gasto: Cuando se hace de tipo posterior, traspasar el tipo a la CxP
 * Server: Keep alive cada 60 segundos para que la base no se duerma
 */

ALTER TABLE fasFixedAsset ADD COLUMN fldUpdateValue TINYINT(1) NOT NULL DEFAULT '1' AFTER fldUpdatedAccumulatedDepreciationValue;

1.13.0 Client  
1.13.0 Server
// Almeja Pomposa
// 2015-11-20 SVN:
// 
/* 
 * CxP: Anulacion con polizas y erroes en campos de factura e item
 * CxP: Sistema se cae cuando se intenta grabar una fac posterior
 * Ventas:  Punto de venta completo
 * Item: Salen todas las categorias sin filtrar
 * Ventas: Lista de precios, en el detalle yo no existe la opción de borrar (traía problemas), si es que se quiere quitar poner precio 0
 * Vouchers y reportes varios
 * Activos: Concepto de produccion para proyección
 * Activos: Valor original y fecha de ingreso
 * Ventas: Grabar directo todos los movimientos alternos sin que se desplieguen
 * Ventas: Acumulado de venta de cada cliente
 * Ventas: Posibilidad de imprimir directo la factura al grabar transacción
 * Ventas: Cambiar nombre de clientes agregados in situ
 * Ventas: En descuento global, posibilidad de introducir dcto absoluto en además del porcentual
 * Ventas: Cuando se realizan Dcto Global y parcial el asiento no salía bien
 * TODOS LOS BUGS REPORTADOS
 */
ALTER TABLE payAccountsPayableDetail
  DROP FOREIGN KEY fkyAccountsPayableDetailImportDocument,
  DROP FOREIGN KEY fkyAccountsPayableDetailItem;
ALTER TABLE payAccountsPayableDetail
  DROP INDEX fkyAccountsPayableDetailInvoice,
  DROP INDEX fkyAccountsPayableDetailItem,
  DROP INDEX fkyAccountsPayableDetailImportDocument;
ALTER TABLE payAccountsPayableDetail CHANGE COLUMN codInvoice fldInvoice BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER fldAmount,
  CHANGE COLUMN codItem fldItem BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER fldInvoice,
  CHANGE COLUMN codImportDocument fldImportDocument BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER fldItem;
ALTER TABLE accUser ADD COLUMN codSalesPlace MEDIUMINT UNSIGNED DEFAULT NULL AFTER codWarehouse;
ALTER TABLE accUser ADD CONSTRAINT fkyUserSalesPlace FOREIGN KEY (codSalesPlace) REFERENCES slsSalesPlace (pkySalesPlace);
ALTER TABLE accUser ADD COLUMN codPriceList SMALLINT UNSIGNED DEFAULT NULL AFTER codSalesPlace;
ALTER TABLE accUser ADD CONSTRAINT fkyUserPriceList FOREIGN KEY (codPriceList) REFERENCES slsPriceList (pkyPriceList);
ALTER TABLE accUser ADD COLUMN codSeller BIGINT UNSIGNED DEFAULT NULL AFTER codPriceList;
ALTER TABLE accUser ADD CONSTRAINT fkyUserSeller FOREIGN KEY (codSeller) REFERENCES agnPerson (pkyPerson);
ALTER TABLE accUser ADD COLUMN codPettyCash MEDIUMINT UNSIGNED DEFAULT NULL AFTER codSeller;
ALTER TABLE accUser ADD CONSTRAINT fkyUserPettyCash FOREIGN KEY (codPettyCash) REFERENCES ptcPettyCash (pkyPettyCash);

ALTER TABLE slsSalesConfig ADD COLUMN fldPrintInvoice TINYINT(1) NOT NULL DEFAULT '0' AFTER fldPriceListLimit;
ALTER TABLE agnCompany ADD COLUMN fldTotalSold DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER codSeller;
ALTER TABLE fasFixedAssetsConfig ADD COLUMN codExpensesConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codRevaluationCurrency;
ALTER TABLE fasFixedAssetsConfig ADD CONSTRAINT fkyFixedAssetsConfigExpensesConcept FOREIGN KEY (codExpensesConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE slsSalesNote ADD COLUMN fldTotalGlobalDiscount DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER codVehicleContract;
UPDATE slsSalesNote SET fldTotalGlobalDiscount = fldGrossTotal - fldNetTotal;
ALTER TABLE fasFixedAsset ADD COLUMN fldOriginalValue DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldUpdateValue;
ALTER TABLE fasFixedAsset ADD COLUMN fldIncomingDate DATE NULL DEFAULT NULL AFTER fldOriginalValue;

1.13.1 Client  
1.13.1 Server
// Mama Maní  
//
/* 
 * CxP: En campo item no permite buscar 
 * Ventas: Agrear opción en configuración para definir si al cambiar el NIT jala el código de cliente o no
 * Inventario: Posibilidad de configurar almacenes que acepten inventario negativo
 * Compras: Importación de ordenes desde un archivo de texto CVS
 * Lista de precios: Importación de lista de precios desde un archivo de texto CVS (Crea item si es necesario)
 * Factura compras: Agregar campo de descuento a las facturas de compra que vengan de CxP, Planilla de gasto o Recepciones
 * Ventas: Agregar descuento a facturas de venta
 * Ventas: Error cuando se usa facturación manual con punto de venta
 * RRHH: Agregar campo de monto
 * RRHH: Releacionar concepto de bono o descuento con conepto de planilla
 * Server: Agregagado role tipo "CompleteCustom" para busquedas customizadas
 * Activo Fijos: Si se dá de baja un vehículo pone el campo sysAuthorized en 0
 * Impuestos: Bloquear campo de cod. Cliente para edición en facturas
 * Contabilidad: Posibilidad de borrar tipos de cambio no usados
 * Activos: Cruce de depreciaciones con proyección de producción
 */
 
ALTER TABLE payAccountsPayableDetail CHANGE COLUMN fldItem codItem BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER fldInvoice;
ALTER TABLE payAccountsPayableDetail ADD CONSTRAINT fkyAccountsPayableDetailItem FOREIGN KEY (codItem) REFERENCES invItem(pkyItem);
ALTER TABLE slsSalesConfig ADD COLUMN fldLoadClientFromID TINYINT(1) NOT NULL DEFAULT '0' AFTER fldPrintInvoice;

ALTER TABLE invWarehouse ADD COLUMN fldAcceptNegative TINYINT(1) NOT NULL DEFAULT '0' AFTER codAccount;
ALTER TABLE pchPurchaseOrder CHANGE COLUMN codAddress codAddress MEDIUMINT UNSIGNED NULL DEFAULT NULL AFTER codSupplier;
ALTER TABLE pchPayrollExpensesDetail ADD COLUMN fldDiscount DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldAmount;
ALTER TABLE pchPayrollExpensesDetail ADD COLUMN fldRealTotal DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldDiscount;
UPDATE pchPayrollExpensesDetail SET fldRealTotal = fldAmount;
ALTER TABLE hrsBonusDiscountConcept ADD COLUMN fldAmount DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldIsDiscount;
ALTER TABLE hrsPayrollConceptDetail DROP INDEX inuPayrollConceptDetailName;
ALTER TABLE hrsPayrollConceptDetail DROP COLUMN fldName;
ALTER TABLE hrsPayrollConceptDetail ADD COLUMN codBonusDiscountConcept SMALLINT UNSIGNED NOT NULL AFTER codPayrollConcept;
ALTER TABLE hrsPayrollConceptDetail ADD CONSTRAINT fkyPayrollConceptDetailBonusDiscountConcept FOREIGN KEY (codBonusDiscountConcept) REFERENCES hrsBonusDiscountConcept (pkyBonusDiscountConcept);
ALTER TABLE hrsFixedDiscounts DROP FOREIGN KEY fkyFixedDiscountsWageConcept;
ALTER TABLE hrsFixedDiscounts DROP INDEX fkyFixedDiscountsWageConcept;
ALTER TABLE hrsFixedDiscounts DROP COLUMN codWageConcept;
ALTER TABLE hrsFixedDiscounts ADD COLUMN codPayrollConcept SMALLINT UNSIGNED NOT NULL AFTER codPaymentConcept;
ALTER TABLE hrsFixedDiscounts ADD CONSTRAINT fkyFixedDiscountsPayrollConcept FOREIGN KEY (codPayrollConcept) REFERENCES hrsPayrollConcept (pkyPayrollConcept);
DROP TABLE hrsHumanResourcesConfig;
ALTER TABLE hrsFixedDiscounts ADD COLUMN fldIsLaboral TINYINT(1) NOT NULL DEFAULT '1' AFTER fldIsFixed;
ALTER TABLE prdProductionConcept ADD COLUMN fldFixedAsset TINYINT(1) NOT NULL DEFAULT '0' AFTER codAccount;

1.13.2 Client  
1.13.2 Server
// Papa Maní  
//
/* LICENCIAR!!!
 * Planillas: Anulación de faturas tipo posterior sin fallas
 * Facturas de compra: Posibilidad de editar descuento
 * Impuestos: Modificaciones en facturas de compra y ventas para nueva modalidad de impuestos
 * Impuestos: Modificaciones en polizas y boletos para nueva modalidad de impuestos
 * Ventas: Flag que permite escoger si es que NIT jala cliente 
 */
 
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE txsPurchasesLedger ADD COLUMN codType TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldDiscount;
ALTER TABLE txsPurchasesLedger ADD CONSTRAINT fkyPurchasesLedgerType FOREIGN KEY (codType) REFERENCES txsPurchaseInvoiceType (pkyPurchaseInvoiceType);
ALTER TABLE txsSalesLedger ADD COLUMN codStatus TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldDiscount;
ALTER TABLE txsSalesLedger ADD CONSTRAINT fkySalesLedgerStatus FOREIGN KEY (codStatus) REFERENCES txsSalesInvoiceStatus (pkySalesInvoiceStatus);
ALTER TABLE txsAuthorizationControl ADD COLUMN fldClosed TINYINT(1) NOT NULL DEFAULT '0' AFTER fldNextNumber;
ALTER TABLE txsAuthorizationControl ADD COLUMN fldContingency TINYINT(1) NOT NULL DEFAULT '0' AFTER fldClosed;
ALTER TABLE txsSalesLedger CHANGE COLUMN fldName fldName VARCHAR(150) NOT NULL;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN fldName fldName VARCHAR(150) NOT NULL;

UPDATE txsSalesLedger SET codStatus = 2 WHERE sysEnabled = 0;
ALTER TABLE txsTicket ADD COLUMN codType TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldTaxCredit;
ALTER TABLE txsTicket ADD CONSTRAINT fkyTicketType FOREIGN KEY (codType) REFERENCES txsPurchaseInvoiceType (pkyPurchaseInvoiceType);
ALTER TABLE pchImportDocument ADD COLUMN codType TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldNIT;
ALTER TABLE pchImportDocument ADD CONSTRAINT fkyImportDocumentType FOREIGN KEY(codType) REFERENCES txsPurchaseInvoiceType (pkyPurchaseInvoiceType);
ALTER TABLE fasFixedAssetDepreciation ADD COLUMN codExpensesConcept SMALLINT UNSIGNED NULL DEFAULT NULL AFTER codFamily;
ALTER TABLE fasFixedAssetDepreciation ADD CONSTRAINT fkyfasFixedAssetDepreciationExpensesConcept FOREIGN KEY (codExpensesConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);

1.14.0 Client  
1.14.0 Server
// Macaco Monono  
//
/* LICENCIAR!!!
 * Ventas: Recetas de servicio en notas de venta
 * Ventas: Bajas de items por servicios
 * Producción: Posibilidad de añadir recetas de servicios
 * RRHH: Conceptos de gasto individuales para cada empleado
 * RRHH: En transaccion de bonos y dctos. jala automáticamente el importe del concepto de bono o dcto. correspondiente
 * RRHH: En formulario de impuestos validar importe 0 y redondear importe y el correspondiente impuesto 
 * RRHH: En movimiento de empleado para bajas y transferencias, jalar datos anteriores
 * RRHH: En movimiento de empleado para altas, jalar por defecto salario básico definido en configuración RRHH
 * RRHH: BUG - Conceptos de bono o dcto. no recupera los valores correctamente
 * RRHH: BUG - Conceptos de dcto. fijo no recupera los valores correctamente
 */
ALTER TABLE agnPerson ADD COLUMN codWagesExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codDocumentNumber;
ALTER TABLE agnPerson ADD COLUMN codSecondBonusExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codWagesExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codBonusExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codSecondBonusExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codCompensationExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codBonusExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codEmployerContributionsExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codCompensationExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codSalaryReimbursementExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codEmployerContributionsExpenseConcept;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonWagesExpenseConcept FOREIGN KEY (codWagesExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonSecondBonusExpenseConcept FOREIGN KEY (codSecondBonusExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonBonusExpenseConcept FOREIGN KEY (codBonusExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonCompensationExpenseConcept FOREIGN KEY (codCompensationExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonEmployerContributionsExpenseConcept FOREIGN KEY (codEmployerContributionsExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonSalaryReimbursementExpenseConcept FOREIGN KEY (codSalaryReimbursementExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE slsSalesConfig ADD COLUMN fldLoadRecipe TINYINT(1) NOT NULL DEFAULT '0' AFTER fldLoadClientFromID;

ALTER TABLE fasFixedAsset ADD COLUMN fldRemovalDate DATE NULL DEFAULT NULL AFTER fldIncomingDate;
INSERT INTO invItemMovementTypeConcept VALUES(800,2,'Egreso Para Servicios',\N,0,'Egreso Para Servicios',1,0,1,2,0,1);
ALTER TABLE hrsTaxesFormDetail CHANGE COLUMN fldAmount fldAmount BIGINT(20) UNSIGNED NOT NULL DEFAULT 1;
ALTER TABLE hrsEmployeeMovement CHANGE COLUMN fldBasicSalary fldBasicSalary DECIMAL(30,10) NOT NULL DEFAULT '1';

1.14.1 Client  
1.14.1 Server
// 
// Mamarracho Cibernético 2
/* LICENCIAR!!!
 * RRRH: Nuevos componentes:Exepción de reintegros, días de trabajo y feriados
 */
 
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.15.0 Client  
1.15.0 Server
// 
// Papayita
/* LICENCIAR!!!
 * Interfaz: Terminada
 * RRRH: Nuevos componentes: Registro de horas extra
 * RRHH: En altas de empleado no se debe controlar el año fiscal
 * BUG: Algunos movimientos que incluyem banco y caja chica no anula al banco o caja correcta
 * BUG!!!: En muy raras ocasiones, las transacciones no generan bien  las transacciones hijas cuando se pone aceptar en dos diferentes componentes (pero relacionados) al mismo tiempo. Ahora al colocar aceptar no es posible realizar ninguna acción hasta que lleguen los datos confirmados
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
DROP TABLE hrsWorkedTimeDetail;
DROP TABLE hrsSalaryPayrollDetail;
DROP TABLE hrsHoliday;
ALTER TABLE invItem ADD COLUMN fldTax DECIMAL(30,10) NOT NULL DEFAULT '-1' AFTER fldMaintenanceEndDate;
ALTER TABLE invItem ADD COLUMN fldExempt DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldMaintenanceEndDate;
ALTER TABLE slsSalesNoteDetail ADD COLUMN fldTax DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldCommission;
ALTER TABLE slsSalesNoteDetail ADD COLUMN fldExempt DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldCommission;

UPDATE invItem SET fldTax = '-1';
ALTER TABLE actAccount CHANGE COLUMN fldName fldName VARCHAR(60) NOT NULL;

1.15.1 Client  
1.15.1 Server
// 
// Papayita Junior
/* 
 * BUGS: MILLONES DE BUGS
 * Server: Posibilidad de crear índices únicos para dos campos
 */

ALTER TABLE txsSalesLedger DROP INDEX indSalesLedgerNumber;
ALTER TABLE txsSalesLedger ADD UNIQUE INDEX indSalesLedgerNumberAuthorizationControl (fldNumber, codAuthorizationControl);

1.15.2 Client  
1.15.2 Server
// 
// Papayita Junior II
/* 
 * Amaszonas: Factura de compras con nuevos campos
 * Amaszonas: Cambio de RUC x NIT solo si está configurado para Paraguay
 * Amaszonas: Número en factura de compras alfanumérico
 * Amaszonas: Cálculo de los impuestos al 10% y 5% en la factura de compras
 * Amaszonas: Generación de asientos con el cálculo de los impuestos al 10% y 5% 
 * Notas de venta, CxC, mov banco, etc: en núemro de documento jalar el número de factura
 */
 
ALTER TABLE txsPurchasesLedger ADD COLUMN fldEmissionDate DATE NOT NULL AFTER codType;
ALTER TABLE txsPurchasesLedger ADD COLUMN fldTaxCreditAlternative DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldEmissionDate;
ALTER TABLE txsPurchasesLedger ADD COLUMN fldNetTotalAlternative DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldTaxCreditAlternative;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN fldControlCode fldControlCode VARCHAR(30) NULL DEFAULT NULL;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN fldNumber fldNumber VARCHAR(30) NOT NULL;

1.15.3 Client  
1.15.3 Server
// 
// Papayita Junior III
/* 
 * BUGS Varios
 * Factura de compra guarda en la moneda original y el asiento lo transforma a la moneda de la contabilidad
 * Plan de cuentas plano. Es posible buscar cuentas en el buscador
 * Dosificación con nuevos campos: Formato de factura, Actividad económica
 */
 
 ALTER TABLE slsOrderNote CHANGE COLUMN codDeliveryAddress codDeliveryAddress MEDIUMINT UNSIGNED NULL DEFAULT NULL;
 ALTER TABLE txsAuthorizationControl ADD COLUMN codInvoiceSheetType TINYINT UNSIGNED NOT NULL DEFAULT 1 AFTER fldContingency;
 ALTER TABLE txsAuthorizationControl ADD CONSTRAINT fkyAuthorizationControlInvoiceSheetType FOREIGN KEY(codInvoiceSheetType) REFERENCES txsPurchaseInvoiceType (pkyPurchaseInvoiceType); 
 ALTER TABLE txsAuthorizationControl ADD COLUMN fldEconomicActivity VARCHAR(150) NULL DEFAULT NULL AFTER codInvoiceSheetType;
 
1.15.4 Client  
1.15.4 Server
// 
// Papayita Junior IV
/* 
 * Keepalive del cliente al server cada 20 segundos 
 * Notas de crédito emitidas y recibidas
 * Agregar moneda y tipo de cambio en factura de compra
 * Notas de credito recibidas
 * Control de fecha al anular en todas las transacciones
 * En pagos, que las Cxp y CxC no tengan fecha mayor a la del pago
 */
 
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE txsPurchasesLedger ADD COLUMN codCurrency TINYINT UNSIGNED DEFAULT NULL AFTER fldNetTotalAlternative;
ALTER TABLE txsPurchasesLedger ADD CONSTRAINT fkyPurchasesLedgerCurrency FOREIGN KEY(codCurrency) REFERENCES actCurrency (pkyCurrency); 
ALTER TABLE txsPurchasesLedger ADD COLUMN codExchangeRate BIGINT UNSIGNED DEFAULT NULL AFTER codCurrency;
ALTER TABLE txsPurchasesLedger ADD CONSTRAINT fkyPurchasesLedgerExchangeRate FOREIGN KEY(codExchangeRate) REFERENCES actExchangeRate (pkyExchangeRate); 
ALTER TABLE txsTaxesConfig ADD COLUMN codDevolutionsConcept SMALLINT UNSIGNED DEFAULT NULL AFTER fldImportPercent;
ALTER TABLE txsTaxesConfig ADD CONSTRAINT fkyTaxesConfigDevolutionsConcept FOREIGN KEY(codDevolutionsConcept) REFERENCES colAccountsReceivableConcept (pkyAccountsReceivableConcept); 
ALTER TABLE txsTaxesConfig ADD COLUMN codIncomeDevolutionsConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codDevolutionsConcept;
ALTER TABLE txsTaxesConfig ADD CONSTRAINT fkyTaxesConfigIncomeDevolutionsConcept FOREIGN KEY(codIncomeDevolutionsConcept) REFERENCES colIncomeConcept (pkyIncomeConcept); 
  
1.15.5 Client  
1.15.5 Server
// 
// Papayita Master
/* 
 * Detalle en notas de crédito emitidas
 * Lector QR para facturas de compra
 * Solucionado  posibles causas de colgadas
 */
 
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;

1.15.6 Client  
1.15.5 Server
// 
// Papaya Master
/* 
 * Impide correer dos Pulzar (que puede causar problemas)
 * BUG: Bugs, bugs, y bugs
 * BUG: Tipo de cambio no se acorta uando la region es Bolivia
 * BUG: Facturas de compra y venta no pueden llamar al componente que los creó
 * Posibilidad de añadir dosificaciones con la misma autorización (Para notas de crédito)
 */
 
UPDATE slsSalesNoteType SET fldName = 'Transf.Bancaria' WHERE pkySalesNoteType = 4;
UPDATE colCollectionRoute SET fldName = 'Transf.Bancaria' WHERE pkyCollectionRoute = 3;
UPDATE payPaymentRoute SET fldName = 'Transf.Bancaria' WHERE pkyPaymentRoute = 3;
ALTER TABLE txsAuthorizationControl DROP INDEX inuAuthorizationControlAuthorization, ADD INDEX inuAuthorizationControlAuthorization (fldAuthorization);
	
1.15.7 Client  
1.15.7 Server
// 
// Master Chan
/* 
 * Varios
 */
	
1.16.0 Client  
1.16.0 Server
// 
// Master Chon Chon
/* 
 * Varios
 * BUG: No sale en el concepto de gasto del detalle de una CxP los conceptos con candadito 1,2,3,4,5 (Activo Fijo en Transito)
 * Un buscador de conceptos (CxP, CxC y gasto) como el que hay en empresa donde anotas o que se pueda adicionar ciertos conceptos a cada usuario  
 * Validador en código de control
 * Calculo del exento automático a partir de un porcentaje dado
 * Cálculo de las retenciones automático, que calcule el grossing up
 * Retenciones en ventas (Paraguay)
 * Todo Amaszonas
 */
	
ALTER TABLE payAccountsPayable CHANGE COLUMN txtDescription txtDescription VARCHAR(500) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;
ALTER TABLE tryCheck CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;
ALTER TABLE invItemMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) CHARACTER SET 'utf8' COLLATE 'utf8_bin' NULL DEFAULT NULL  ;
ALTER TABLE payExpensesConcept ADD COLUMN fldExempt DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldItemControl;
INSERT INTO payExpensesConcept VALUES(6,'Retención',NULL,0,0,NULL,1,0,1,2,0,1);

ALTER TABLE slsSalesConfig ADD COLUMN fldShowBarcode BOOL NOT NULL DEFAULT '0' AFTER fldLoadRecipe;
ALTER TABLE slsSalesConfig ADD COLUMN fldShowUnit BOOL NOT NULL DEFAULT '0' AFTER fldShowBarcode;
ALTER TABLE slsSalesConfig ADD COLUMN fldBatchID BOOL NOT NULL DEFAULT '0' AFTER fldShowUnit;
ALTER TABLE slsSalesConfig ADD COLUMN fldHidePrice BOOL NOT NULL DEFAULT '0' AFTER fldBatchID;

1.16.1 Client  
1.16.1 Server
// 
// Exquisite
/* 
 * Cambio de engine para realizar asientos 100% compatibles con centros de costo
 * Errores pequeños varios
 */
 
1.16.2 Client
1.16.2 Server
// 
// Exquisite II
/* 
 * Aplicación del nuevo engine de asientos para todas las transacciones
 * Errores pequeños varios
 */
  
1.16.3 Client  
1.16.3 Server
// 
// Exquisite III
/* 
 * Campos de glosa en transacciones mas grande
 * Factura Grupal en CxP
 */
 
ALTER TABLE hrsBonusDiscount CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsTaxesForm CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsEmployeeMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsSalaryReimbursement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsSalaryPayroll CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsWorkedTime CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsOvertime CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsVacation CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchRequestAuthorization CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchPurchaseOrder CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchPurchaseRequest CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchPayrollExpenses CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchImportDocument CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE pchReceiptOfGoods CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE slsServiceProductRemoval CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE txsBillingSalesPlace CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE txsTicket CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE txsDiscountsDevolutions CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE txsPurchasesLedger CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE txsSalesLedger CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE actAccountEntry CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE colEarlyPayment CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE colCollection CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE colAccountsReceivable CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE payEarlyCollection CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE payAccountsPayable CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE payPayment CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE ptcCurrencyExchange CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE ptcPettyCashMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE tryCheckDeposit CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE tryBankMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE fasFixedAssetValueUpdate CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE fasFixedAssetDepreciation CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE fasFixedAssetMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE invItemMovement CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE prdPreproductionNote CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE prdProductionOrder CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE prdProductionProjection CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;

INSERT INTO txsDocumentType VALUES(7,'Factura Grupo',NULL,1,0,1,2,0,1);

1.16.4 Client  
1.16.4 Server
// 
// Exquisite III
/* 
 * Arreglos varios interfaz Amaszonas
 * Posibilidad de correr un clinte Pulzar por empresa en la misma máquina
 * ITF
 * Busqueda en persona por apellido paterno
 */

ALTER TABLE hrsJob CHANGE COLUMN txtDescription txtDescription VARCHAR(1000) NULL DEFAULT NULL;
ALTER TABLE hrsJob CHANGE COLUMN fldName fldName VARCHAR(100) NOT NULL;
 
1.16.5 Client  
1.16.4 Server
// 
// Exquisite V
/* 
 * Pago automático ITF
 */
 
1.17.0 Client  
1.17.0 Server
// Pañales, pañales y más pañales
// LICENCIAR!
/* 
 * Varias facturas para compensar tipo de documento posterior
 * Contexto: Es posible añadir varios contextos de tal manera que en cada transacción se pueda escoger uno de ellos
 * Servidor sincroniza siempre que se levanta (ya no es necesario intervención manual)
 * Se guarda la versión del Server en la tabla agnCompany, el registro con codigo 1 en el campo fldAlternativeKey
 */
 
 
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE payAccountsPayableDetail ADD COLUMN fldAmountRedeemed DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldImportDocument;
ALTER TABLE srvServerConfig ADD COLUMN fldUseDefaultContext BOOL NOT NULL DEFAULT '1' AFTER fldPrintTransaction;

1.17.1 Client  
1.17.1 Server
// OooOooO

/* 
 * BUG: Retenciones con grossing up solucionados
 * BUGS varios
 * Creación de recepción de mercadería o traspasos controlan si es que existen planillas de gasto  con fecha posterior a la misma
 */
 

1.17.2 Client  
1.17.2 Server
// VooodOooOooO
/*
 * Facturas en dolares convierte a Bs (solo para Bolivia)
 * Bancarización: Si en CxP se una límea excede 50000 Bs entonces debe controlar que solo se pueda meter una línea
 * Bancarización: Parámetro en config. Tesoreria que define el monto mínimo a bancarizar
 * Bancarización completa
 */
 
ALTER TABLE tryTreasuryConfig ADD COLUMN fldBankingThreshold  DECIMAL(40,10) NOT NULL DEFAULT 0.00 AFTER fldBankTaxPercent;
ALTER TABLE payAccountsPayable ADD COLUMN fldContract VARCHAR(30) NOT NULL DEFAULT '0' AFTER codProductionProjection;
ALTER TABLE payAccountsPayable ADD COLUMN fldBanking BOOL NOT NULL DEFAULT 0 AFTER codProductionProjection;
ALTER TABLE colAccountsReceivable ADD COLUMN fldContract VARCHAR(30) NOT NULL DEFAULT '0' AFTER codAccountEntry;
ALTER TABLE colAccountsReceivable ADD COLUMN fldBanking BOOL NOT NULL DEFAULT 0 AFTER codAccountEntry;
 
ALTER TABLE payPayment ADD COLUMN codType TINYINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE payPayment ADD CONSTRAINT fkyPaymentType FOREIGN KEY(codType) REFERENCES pchPurchaseType (pkyPurchaseType); 
ALTER TABLE colCollection ADD COLUMN codType TINYINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE colCollection ADD CONSTRAINT fkyCollectionType FOREIGN KEY(codType) REFERENCES slsSalesType (pkySalesType); 
ALTER TABLE pchPurchaseType CHANGE COLUMN fldName fldName VARCHAR(50) NOT NULL;
ALTER TABLE slsSalesType CHANGE COLUMN fldName fldName VARCHAR(50) NOT NULL;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM pchPurchaseType;
DELETE FROM slsSalesType;
SET FOREIGN_KEY_CHECKS=TRUE;

1.18.1 Client  
1.18.1 Server
// BOOM! BOOM!
/* LICENCIAR!
 * Provisiones para Paraguay
 * Nuevo engine para Lotes
 * Copiar registro y detalle en Bonos y descuentos
 * Agregar AFP para cada empleado
 * Campo en empleado para el número de Cta. bancaria
 * Generación de planilla
 * Facturas grupales son permitidas para bancarización
 */

ALTER TABLE hrsVacationDetail ADD COLUMN fldSplit VARCHAR(200) NOT NULL AFTER fldPaidLeave;
ALTER TABLE agnCompanyBranch CHANGE COLUMN fldName fldName VARCHAR(150) NOT NULL;
ALTER TABLE hrsWorkedTimeDetail ADD COLUMN fldSundayAbsences SMALLINT UNSIGNED NOT NULL DEFAULT '0'  AFTER fldAbsences;
DROP TABLE hrsSalaryPayrollDetail;
DROP TABLE hrsSalaryPayroll;
SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE agnPerson ADD COLUMN fldBankAccount VARCHAR(30) DEFAULT NULL AFTER codSalaryReimbursementExpenseConcept;

1.18.2 Client  
1.18.2 Server
// BOOM! BOOM! BOOM!
/* Planillas: Campos extras para conceptos de gasto usados en asientos y CxP
 * Planillas: Por sucursal.
 * Botón para la generación
 */

ALTER TABLE agnPerson ADD COLUMN codExtraHoursExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER fldBankAccount;
ALTER TABLE agnPerson ADD COLUMN codChargeHoursExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codExtraHoursExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codSundayHoursExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codChargeHoursExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codExtraordinaryHoursExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codSundayHoursExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codHolidayHoursExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codExtraordinaryHoursExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN codSeniorityExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codHolidayHoursExpenseConcept;

ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonExtraHoursExpenseConcept FOREIGN KEY (codExtraHoursExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonChargeHoursExpenseConcept FOREIGN KEY (codChargeHoursExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkySundayHoursExpenseConcept FOREIGN KEY (codSundayHoursExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyExtraordinaryHoursExpenseConcept FOREIGN KEY (codExtraordinaryHoursExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkyHolidayHoursExpenseConcept FOREIGN KEY (codHolidayHoursExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
ALTER TABLE agnPerson ADD CONSTRAINT fkySeniorityExpenseConcept FOREIGN KEY (codSeniorityExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept);
 
ALTER TABLE hrsWorkedTime ADD COLUMN codCompanyBranch MEDIUMINT UNSIGNED DEFAULT NULL AFTER fldUsed;
ALTER TABLE hrsSalaryPayroll ADD COLUMN codCompanyBranch MEDIUMINT UNSIGNED DEFAULT NULL AFTER codExchangeRate;
ALTER TABLE hrsWorkedTime ADD CONSTRAINT fkyWorkedTimeCompanyBranch FOREIGN KEY (codCompanyBranch) REFERENCES agnCompanyBranch (pkyCompanyBranch);
ALTER TABLE hrsSalaryPayroll ADD CONSTRAINT fkySalaryPayrollCompanyBranch FOREIGN KEY (codCompanyBranch) REFERENCES agnCompanyBranch (pkyCompanyBranch);

1.18.3 Client  
1.18.3 Server
// SPLASH!

/* LICENCIAR!!!
/* Planillas: Cálculo de RC IVA y Aporte Solidario
 * Planillas: Se agregaron campos en Persona de Vacaciones acumuladas y RC IVA acumulado
 * Planillas: Tiempo extra solamente se llena una planilla por mes y además es posible copiar los datos
 * Planillas: Prorrateo en el cáclulo del bono de antigüedad
 * Vehículos: Aumentar flag en configuración del módulo para poder deshabilitar controles
 * Vehículos: Aumentar combustible y kilometrajes intermedios tanto de salida como de llegada
 * Persona: Aumentar banco
 * Impuestos: Posibilidad de ocultar la glosa en la impresión de la factura
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE agnPerson ADD COLUMN fldAccumulatedVacation DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER codSeniorityExpenseConcept;
ALTER TABLE agnPerson ADD COLUMN fldAccumulatedVAT INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER fldAccumulatedVacation;
ALTER TABLE hrsEmployeeMovement ADD COLUMN fldAccumulatedVacation DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER cosComponentKey;
ALTER TABLE hrsEmployeeMovement ADD COLUMN fldAccumulatedVAT INTEGER UNSIGNED NOT NULL DEFAULT '0' AFTER fldAccumulatedVacation;
ALTER TABLE hrsSalaryPayrollDetail DROP COLUMN fldOtherDiscounts;
ALTER TABLE hrsSalaryPayrollDetail ADD COLUMN fldAccumulatedVAT DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldSpecialDiscounts;
ALTER TABLE hrsOvertime DROP FOREIGN KEY fkyOvertimeEmployee;
ALTER TABLE hrsOvertime DROP COLUMN codEmployee;
ALTER TABLE hrsOvertime DROP FOREIGN KEY fkyOvertimeType;
ALTER TABLE hrsOvertime DROP COLUMN codType;
ALTER TABLE hrsOvertime DROP COLUMN fldHours;
ALTER TABLE hrsOvertime ADD COLUMN fldUsed BOOL NOT NULL DEFAULT 0 AFTER fldDate;
ALTER TABLE agnPerson ADD COLUMN codBank MEDIUMINT UNSIGNED DEFAULT NULL AFTER fldAccumulatedVAT;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonBank FOREIGN KEY (codBank) REFERENCES tryBank (pkyBank);
ALTER TABLE vhcVehiclesConfig ADD COLUMN fldControlsEnabled BOOL NOT NULL DEFAULT '1'  AFTER codDayItem;
ALTER TABLE vhcVehicleContract ADD COLUMN fldDeliveredMileage MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldCloseObservations;
ALTER TABLE vhcVehicleContract ADD COLUMN fldReceivedMileage MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldDeliveredMileage;
ALTER TABLE vhcVehicleContract ADD COLUMN fldDeliveredFuel MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldReceivedMileage;
ALTER TABLE vhcVehicleContract ADD COLUMN fldReceivedFuel MEDIUMINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldDeliveredFuel;
ALTER TABLE vhcVehicleContract CHANGE COLUMN codAddress codAddress MEDIUMINT UNSIGNED DEFAULT NULL;
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN fldSeniorityBonusApportion BOOL NOT NULL DEFAULT 0  AFTER fldExtraHoursMultiplier;
ALTER TABLE txsTaxesConfig ADD COLUMN fldShowDescription BOOL NOT NULL DEFAULT '1'  AFTER codIncomeDevolutionsConcept;

1.18.4 Client  
1.18.4 Server
// SPLASH! PLASH!

/* BUG: Pagos: Arreglado bug que no permitía realizar anulación en liquidaciones
 * Planillas: RC IVA actualización
 * Planillas: Campo end Dcto.Fijo para el formato (0 = NA, 1 = Prevision, 2 = Futuro)
 * Agenda: Campos extra en persona
 * Activos Fijos: Copiar glosa de mov alta al activo fijo
 * Activos Fijos: En asiento generear en la glosa descripción del tipo de movimiento 
 * Activos Fijos: Generar a partir de item
 */
 
ALTER TABLE hrsSalaryPayrollDetail ADD COLUMN fldVATAdjust DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldAccumulatedVAT;
ALTER TABLE hrsSalaryPayrollDetail ADD COLUMN fldAdjustedVAT DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldVATAdjust;
ALTER TABLE agnPerson ADD COLUMN fldMarriedLastName VARCHAR(60) DEFAULT NULL AFTER codBank;
ALTER TABLE agnPerson ADD COLUMN fldOtherNames VARCHAR(60) DEFAULT NULL AFTER fldMarriedLastName;
ALTER TABLE agnPerson ADD COLUMN fldRetired BOOL NOT NULL DEFAULT 0  AFTER fldOtherNames;
ALTER TABLE hrsFixedDiscounts ADD COLUMN fldFormat TINYINT UNSIGNED NOT NULL DEFAULT 0 AFTER fldNonTaxableMin;
ALTER TABLE fasFixedAssetMovement ADD COLUMN codItem BIGINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE fasFixedAssetMovement ADD CONSTRAINT fkyFixedAssetMovementItem FOREIGN KEY (codItem) REFERENCES invItem (pkyItem);
ALTER TABLE fasFixedAssetMovement ADD COLUMN codItemMovement BIGINT UNSIGNED DEFAULT NULL AFTER codItem;
ALTER TABLE fasFixedAssetMovement ADD CONSTRAINT fkyFixedAssetMovementItemMovement FOREIGN KEY (codItemMovement) REFERENCES invItemMovement (pkyItemMovement);
INSERT INTO invItemMovementTypeConcept VALUES (804,2,'Egreso Para Activo Fijo',NULL,0,'Egreso Para Activo Fijo',1,2,1,2,0,2);

1.18.5 Client  
1.18.5 Server
// One to go ...

/* 
 * Planillas: Asiento y bugs 
 */

ALTER TABLE hrsHumanResourcesConfig ADD COLUMN codVATAccount BIGINT UNSIGNED DEFAULT NULL AFTER fldSeniorityBonusApportion;
ALTER TABLE hrsHumanResourcesConfig ADD CONSTRAINT fkyHumanResourcesConfigVATAccount FOREIGN KEY (codVATAccount) REFERENCES actAccount (pkyAccount);
ALTER TABLE hrsSalaryPayroll ADD COLUMN codAccountEntry BIGINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE hrsSalaryPayroll ADD CONSTRAINT fkySalaryPayrollAccountEntry FOREIGN KEY (codAccountEntry) REFERENCES actAccountEntry (pkyAccountEntry);
UPDATE agnPerson SET fldMinimumUnit = 0;


1.18.6 Client  
1.18.6 Server
// Forgotten

/* 
 * BUGS BUGS BUGS
 * Planillas: Ahora es posible escoger las fechas para la actualización del RC IVA
 * Planillas: Reporte de movimiento de empleados
 * Planillas: Al dar de baja al empleado no desactiva el flag de empleado simplemente lo inhabilita ( a fin de poder pagar liquidaciones por ejm)
 * Activos Fijos: Posibilidad de filtrar por sucursal en depreciociones y actualizaciones
 */

ALTER TABLE hrsSalaryPayroll ADD COLUMN fldPreviousDate DATE NULL DEFAULT NULL AFTER codAccountEntry;
ALTER TABLE fasFixedAssetDepreciation ADD COLUMN codCompanyBranch MEDIUMINT UNSIGNED DEFAULT NULL AFTER codExpensesConcept;
ALTER TABLE fasFixedAssetValueUpdate ADD COLUMN codCompanyBranch MEDIUMINT UNSIGNED DEFAULT NULL AFTER cosComponentKey;
ALTER TABLE fasFixedAssetDepreciation ADD CONSTRAINT fkyFixedAssetDepreciationCompanyBranch FOREIGN KEY (codCompanyBranch) REFERENCES agnCompanyBranch (pkyCompanyBranch);
ALTER TABLE fasFixedAssetValueUpdate ADD CONSTRAINT fkyFixedAssetValueUpdateCompanyBranch FOREIGN KEY (codCompanyBranch) REFERENCES agnCompanyBranch (pkyCompanyBranch); 
 
1.18.7 Client  
1.18.7 Server
// Unforgotten

/* 
 * Planillas: Asiento incluye indemnizacion, aguinaldo, prima
 */

ALTER TABLE hrsHumanResourcesConfig ADD COLUMN codSpecialPayableConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codVATAccount;
ALTER TABLE hrsHumanResourcesConfig ADD CONSTRAINT fkyHumanResourcesConfigSpecialPayableConcept FOREIGN KEY (codSpecialPayableConcept) REFERENCES payAccountsPayableConcept (pkyAccountsPayableConcept); 
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN codPrimaPayableConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codSpecialPayableConcept;
ALTER TABLE hrsHumanResourcesConfig ADD CONSTRAINT fkyHumanResourcesConfigPrimaPayableConcept FOREIGN KEY (codPrimaPayableConcept) REFERENCES payAccountsPayableConcept (pkyAccountsPayableConcept); 
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN codSpecialExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codPrimaPayableConcept;
ALTER TABLE hrsHumanResourcesConfig ADD CONSTRAINT fkyHumanResourcesConfigSpecialExpenseConcept FOREIGN KEY (codSpecialExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept); 
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN codPrimaExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codSpecialExpenseConcept;
ALTER TABLE hrsHumanResourcesConfig ADD CONSTRAINT fkyHumanResourcesConfigPrimaExpenseConcept FOREIGN KEY (codPrimaExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept); 

ALTER TABLE agnPerson ADD COLUMN codSpecialExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER fldRetired;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonSpecialExpenseConcept FOREIGN KEY (codSpecialExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept); 
ALTER TABLE agnPerson ADD COLUMN codPrimaExpenseConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codSpecialExpenseConcept;
ALTER TABLE agnPerson ADD CONSTRAINT fkyPersonPrimaExpenseConcept FOREIGN KEY (codPrimaExpenseConcept) REFERENCES payExpensesConcept (pkyExpensesConcept); 


1.18.8 Client  
1.18.8 Server
// Unforgotten II

/* 
 * Planillas: Bugs y bugs
 * Planillas: Habilitación de campos de configuración de RRHH para calculo de históricos
 * CxP: Controla que no se introduzca 2 veces la misma factura sin que esté grabada en la base
 * CxP: Control de polizas repetidas
 * Opción de imprimir asiento en todas las transacciones donde aplica
 * Panel de búsqueda puede cambiarse de tamaño 
 */

ALTER TABLE hrsSalaryPayroll ADD COLUMN fldMinimumWage DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldPreviousDate;
ALTER TABLE hrsSalaryPayroll ADD COLUMN fldTaxableWage DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER fldMinimumWage;
ALTER TABLE hrsSalaryPayroll ADD COLUMN fldManWorkingHours SMALLINT NOT NULL DEFAULT '0' AFTER fldTaxableWage;
ALTER TABLE hrsSalaryPayroll ADD COLUMN fldWomanWorkingHours SMALLINT NOT NULL DEFAULT '0' AFTER fldManWorkingHours;
ALTER TABLE hrsSalaryPayroll ADD COLUMN fldManWorkingDays SMALLINT NOT NULL DEFAULT '0' AFTER fldWomanWorkingHours;
ALTER TABLE hrsSalaryPayroll ADD COLUMN fldWomanWorkingDays SMALLINT NOT NULL DEFAULT '0' AFTER fldManWorkingDays;

    
2.0.0 Client  
1.18.8 Server
// 57
// Cute 5
// LICENCIAR!!
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/*
 * glare garbage before dad fan foster sock strong wife relief write account
 * door arrive bronze also rib ketchup  law stage alley skin void region
 * Upgrade a Qt5 : PROBAR TODO!!!
 
 * Orden de Compra: Extender glosa a 5000 caracteres
 * Planillas: Asiento complteo prevision indemnizacion, 2do aguinaldo, prima
 * Planillas: CxP genredas automáticamente
 * Retenciones:  BUG donde generaba mal cuando habian muchas retenciones en una sola CxP
 * 
 */
 
ALTER TABLE pchPurchaseOrder CHANGE COLUMN txtDescription txtDescription VARCHAR(5000);

2.0.1 Client  
1.18.8 Server
// 57
// Cute 5++
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/*
 * Bug: Anulación de facturas de compra
 * Bug: Validación cuando se usa CxP en USD con boletos
 * Bug: Al cambiar cantidad en la recepcion de mercaderia la Cxp se genera correctamente en todos los casos (Preforsa)
 * Bug: Varios en Reintegro de planillas
 */
 

2.0.2 Client  
1.19.0 Server
// 62
// Cucuuuu cantó la rana
// REQUIERE WIN 7,8,10 (32 o 64 bits)

ALTER TABLE txsTaxesConfig ADD COLUMN codDebitAccount BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER fldShowDescription;
ALTER TABLE txsTaxesConfig ADD CONSTRAINT fkyTaxesConfigDebitAccount FOREIGN KEY (codDebitAccount) REFERENCES actAccount (pkyAccount); 

/*
 * Planillas: Tiempo trabajado por contexto
 * Planillas: El 13% de 2 salarios mínimos se arrastra para el iva acumulado
 * Compras: Descuentos se plasma en el asiento
 * Venta: Descuentos se plasma en el asiento
 * CxP: Descuentos se plasma en el asiento 
 */

2.1.0 Client  
1.19.0 Server
// 63
// Cucuuuu cantaba la rana Parte II
// REQUIERE WIN 7,8,10 (32 o 64 bits)

 * Compras: Descuentos se plasma en el asiento (Modificado)
 * Venta: Descuentos se plasma en el asiento (Modificado)
 * Producción: Se permite ponderar familias en proyecciones para el costeo de producción
 */

2.2.0 Client  
1.19.1 Server
// 72
// Vertcoin to the moooon
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/*
 * BUG: Asientos arreglados con descuentos y deducción impositiva
 * RRHH: VAT mínimo arreglado
 * Contabilidad: Asiento de cierre genera centros de costo
 * Planillas: Generación opcional de RC IVA extra para algunas empresas
 */

ALTER TABLE slsSalesPlace CHANGE COLUMN codTaxDebitDeductionAccount codTaxDebitDeductionAccount BIGINT(20) UNSIGNED NULL DEFAULT NULL AFTER codTaxExpenseAccount;
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN fldAccumulatedVAT BOOL NOT NULL DEFAULT 0  AFTER codPrimaExpenseConcept;
ALTER TABLE agnPerson CHANGE COLUMN fldAccumulatedVAT fldAccumulatedVAT DECIMAL(30,2) UNSIGNED NOT NULL DEFAULT '0' AFTER fldAccumulatedVacation;

2.3.0 Client  
1.20.0 Server
// 78
// Vertcoin to the moooon II
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/*
 * Inventario: Refactoring de Clasificación de Items
 * Planillas: Guarda histórico de descuentos fijos usados en cada planilla
 * Recepciones: BUG que impedía introducir facturas con descuento y con lotes habilitados
 */
 
2.4.0 Client  
1.20.0 Server
// 79
// Vertpig
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Planillas: BUG: Asiento no realizaba bien cuando empleados trabajaban menos días
 * Contabilidad: Parte I, nuevo engine de centros de costo
 */
 
2.5.0 Client  
1.20.0 Server
// 80
// Vertpig II
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Planillas: BUG: Asiento corregido
 */

2.6.0 Client  
1.30.0 Server
// 84
// Vertpig III
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Ajuste x inflación
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE;
ALTER TABLE actAccount ADD COLUMN fldForInflationAdjustment BOOL NOT NULL DEFAULT 0  AFTER codUse;
ALTER TABLE actAccountingConfig ADD COLUMN codInflationCurrency TINYINT UNSIGNED DEFAULT 4 NOT NULL AFTER codRoundUpAccount;
ALTER TABLE actAccountingConfig ADD CONSTRAINT fkyAccountingConfigInflationCurrency FOREIGN KEY(codInflationCurrency) REFERENCES actCurrency (pkyCurrency); 
 
2.6.1 Client  
1.30.0 Server
// 87
// Starter II
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * BUG en asiento de planillas en la parte de sueldos
 * Controles de fecha en depreciaciones y actualizaciones
 */

2.6.2 Client  
1.30.0 Server
// 87
// Vert
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Controles en actualizaciones y depreciociones para que no proceso activos introducidos posteriormente a la fecha
 */

2.7.0 Client  
1.30.1 Server
// 99
// Neon Blade
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Ajustes por inflación y patrimonio pueden calcularse desde la fecha de la transacción
 * Producción: Costos indirectos se pueden calcular en base a factores
 * Ventas: Replicar númerode nota de venta a los demás componentes cuando no se factura
 * Actualización a Qt 5.10.1
 */

SET FOREIGN_KEY_CHECKS=FALSE;
DELETE FROM srvComponent;
SET FOREIGN_KEY_CHECKS=TRUE; 
DROP TABLE  IF EXISTS actEquityAdjustment;
DROP TABLE  IF EXISTS actInflationAdjustment;
ALTER TABLE prdProductionOrderConcept ADD COLUMN codExpensesConcept SMALLINT UNSIGNED DEFAULT NULL AFTER codItem;
ALTER TABLE prdProductionOrderConcept ADD CONSTRAINT fkyProductionOrderConceptExpensesConcept FOREIGN KEY (codExpensesConcept) REFERENCES payExpensesConcept (pkyExpensesConcept); 
ALTER TABLE prdProductionOrderConcept ADD COLUMN fldFactor DECIMAL(30,10) NOT NULL DEFAULT '0' AFTER codExpensesConcept;
ALTER TABLE payAccountsPayable ADD COLUMN fldProductionPeriod DATE NOT NULL DEFAULT '2000-01-01' AFTER fldContract;
ALTER TABLE payAccountsPayable ADD INDEX indAccountsPayableProductionPeriod (fldProductionPeriod);

2.7.1 Client  
1.30.1 Server
// 104
// Neon Blade II
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * Ventas: No ocultar columnas de exento, stock e impuestos al adicionar registro
 * Stock: No ocultar columnas de exento, stock e impuestos al adicionar registro
 * Base: Arreglo en como los detalles procesaban la info (_componentObjectModel en vez de _proxyModel para setear datos)
 */

2.8.0 Client
1.31.0 Server
// 107
// Neon Blade III
// REQUIERE WIN 7,8,10 (32 o 64 bits)

/* 
 * RRHH: Aumentar parámetro para definir multiplicador por trabajo en domingos
 * Base: TODAS las posibles combinaciones: Arreglo en como los detalles procesaban la info (_componentObjectModel en vez de _proxyModel para setear datos)
 * Recepciones: El valor de  ingreso de mercadería ahora coincide con el valor restanndo el impuesto si es que tiene exento
 * Factores de producción: Arregla bug de items repetidos
 * Contabilidad: Nuevo engine de centros de costo
 * Compras: Agregar flag para determinar si se usa el concepto de compras locales o extranjeras en la planilla de gastos
 * Compras: Orden de compra se puede editar si es que no se la usó
 */
 
DROP TABLE hrsSalaryReimbursementDetail;
DROP TABLE hrsSalaryReimbursement;
ALTER TABLE hrsHumanResourcesConfig ADD COLUMN fldSundayMultiplier DECIMAL(30,10) NOT NULL DEFAULT '1' AFTER fldAccumulatedVAT;
INSERT INTO regCity VALUES(4293,1,1,'El Alto, La Paz',-4,1010100,'El Alto, La Paz',1,0,1,2,0,1)