details: https://code.openbravo.com/erp/devel/pi/rev/0136b85e15e3
changeset: 20192:0136b85e15e3
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Wed Apr 24 01:20:49 2013 +0200
summary: Fixes issue 23164: It is possible to create a two price list versions
with same name and same valid from date
diffstat:
src-db/database/model/tables/M_PRICELIST_VERSION.xml | 5 +++++
1 files changed, 5 insertions(+), 0 deletions(-)
diffs (15 lines):
diff -r fe669254024a -r 0136b85e15e3
src-db/database/model/tables/M_PRICELIST_VERSION.xml
--- a/src-db/database/model/tables/M_PRICELIST_VERSION.xml Wed Apr 24
00:58:21 2013 +0200
+++ b/src-db/database/model/tables/M_PRICELIST_VERSION.xml Wed Apr 24
01:20:49 2013 +0200
@@ -80,6 +80,11 @@
<foreign-key foreignTable="M_PRICELIST"
name="M_PRICELIST_VERSION_M_PRICELIS" onDelete="cascade">
<reference local="M_PRICELIST_ID" foreign="M_PRICELIST_ID"/>
</foreign-key>
+ <unique name="M_PRICELIST_NAME_VALIDFROM">
+ <unique-column name="NAME"/>
+ <unique-column name="VALIDFROM"/>
+ <unique-column name="M_PRICELIST_ID"/>
+ </unique>
<check name="M_PRICELIST_VERSION_ISACTI_CHK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
<check
name="M_PRICELIST_VERSION_M_PRIC_CHK"><![CDATA[M_PRICELIST_VERSION_GENERATE IN
('Y', 'N')]]></check>
</table>
------------------------------------------------------------------------------
Try New Relic Now & We'll Send You this Cool Shirt
New Relic is the only SaaS-based application performance monitoring service
that delivers powerful full stack analytics. Optimize and monitor your
browser, app, & servers with just a few lines of code. Try New Relic
and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_apr
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
