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

Reply via email to