details: /erp/erp/devel/pi/rev/879929fa5af6 changeset: 4817:879929fa5af6 user: Antonio Moreno <antonio.moreno <at> openbravo.com> date: Fri Aug 21 10:27:31 2009 +0200 summary: Fixed issue 10368. Now the AD_SYSTEM table will not be deleted and refilled in each upgrade, and therefore the license will not be lost.
diffstat: src-db/database/build.xml | 10 ++-------- 1 files changed, 2 insertions(+), 8 deletions(-) diffs (27 lines): diff -r 66e4619adf0f -r 879929fa5af6 src-db/database/build.xml --- a/src-db/database/build.xml Fri Aug 21 09:00:20 2009 +0200 +++ b/src-db/database/build.xml Fri Aug 21 10:27:31 2009 +0200 @@ -367,11 +367,8 @@ </fileset> </classpath> <transaction> - DELETE FROM AD_SYSTEM; - INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_TRANSACTIONALRANGE, TAD_THEME) - VALUES ('0', '0', '0', 'Y', NOW(), '0', NOW(), '0', '?', 20, 100, 1, 'Default'); - UPDATE AD_SYSTEM_INFO SET CODE_REVISION=SUBSTR('${code.revision}',1,60); - CALL AD_UPDATE_SEQUENCE(); + UPDATE AD_SYSTEM_INFO SET CODE_REVISION=SUBSTR('${code.revision}',1,60); + CALL AD_UPDATE_SEQUENCE(); CALL AD_UPDATE_ACCESS(); UPDATE AD_MODULE SET ISINDEVELOPMENT='N', ISDEFAULT='N', SEQNO=NULL, STATUS='P', UPDATE_AVAILABLE=NULL, ISREGISTERED='N' WHERE STATUS IS NULL OR STATUS='I'; CALL AD_LANGUAGE_CREATE(NULL); @@ -388,9 +385,6 @@ </fileset> </classpath> <transaction> - DELETE FROM AD_SYSTEM; - INSERT INTO AD_SYSTEM (AD_SYSTEM_ID, AD_CLIENT_ID, AD_ORG_ID, ISACTIVE, CREATED, CREATEDBY, UPDATED, UPDATEDBY, NAME, TAD_RECORDRANGE, TAD_RECORDRANGE_INFO, TAD_TRANSACTIONALRANGE, TAD_THEME) - VALUES ('0', '0', '0', 'Y', NOW(), '0', NOW(), '0', '?', 20, 100, 1, 'Default'); UPDATE AD_SYSTEM_INFO SET CODE_REVISION=SUBSTR('${code.revision}',1,60); SELECT AD_UPDATE_SEQUENCE(); SELECT AD_UPDATE_ACCESS(); ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Openbravo-commits mailing list Openbravo-commits@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/openbravo-commits