Openbravo Issue Tracking System - Retail Modules
View Issue Details
0040168Retail ModulesWeb POSpublic2019-02-06 18:252019-02-21 15:39
asiermartirena 
asiermartirena 
normalmajoralways
closedfixed 
5
 
RR19Q2 
marvintm
No
0040168: Some db colums shouldn't be mandatory
The columns 'obposPrepaymentlimitamt' and 'obposPrepaymentlaylimitamt' in the c_order shouldn't be NOT NULL columns. This causes a severe performance issue when doing an upgrade.
Those columns shouldn't also have a default value.
Check the
No tags attached.
depends on backport 0040188RR19Q1 closed asiermartirena Some db colums shouldn't be mandatory 
Issue History
2019-02-06 18:25asiermartirenaNew Issue
2019-02-06 18:25asiermartirenaAssigned To => asiermartirena
2019-02-06 18:25asiermartirenaTriggers an Emergency Pack => No
2019-02-11 08:51guillermogilResolution time => 1551222000
2019-02-11 08:51guillermogilReproducibilityhave not tried => always
2019-02-13 09:07hgbotCheckin
2019-02-13 09:07hgbotNote Added: 0109790
2019-02-13 09:07hgbotStatusnew => resolved
2019-02-13 09:07hgbotResolutionopen => fixed
2019-02-13 09:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^]
2019-02-13 09:11asiermartirenaStatusresolved => new
2019-02-13 09:11asiermartirenaResolutionfixed => open
2019-02-13 09:12asiermartirenaStatusnew => scheduled
2019-02-13 09:12asiermartirenaStatusscheduled => resolved
2019-02-13 09:12asiermartirenaResolutionopen => fixed
2019-02-13 09:18hgbotCheckin
2019-02-13 09:18hgbotNote Added: 0109794
2019-02-13 09:18hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^] => http://code.openbravo.com/retail/backports/3.0RR19Q1/org.openbravo.retail.posterminal/rev/4fddf7fb527b78525dd2e6912f1fe9ea377ce3c1 [^]
2019-02-13 09:19asiermartirenaNote Deleted: 0109794
2019-02-21 15:39marvintmReview Assigned To => marvintm
2019-02-21 15:39marvintmStatusresolved => closed
2019-02-21 15:39marvintmFixed in Version => RR19Q2

Notes
(0109790)
hgbot   
2019-02-13 09:07   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: f41faf2f3572fea27708c9c27b0161cf370dc78a
Author: Asier Martirena <asier.martirena <at> openbravo.com>
Date: Mon Feb 11 09:15:01 2019 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/f41faf2f3572fea27708c9c27b0161cf370dc78a [^]

Fixed issue 40168: Some db colums shouldn't be mandatory

---
M src-db/database/model/modifiedTables/C_ORDER.xml
---