details: https://code.openbravo.com/erp/devel/pi/rev/018aa4e83090
changeset: 35442:018aa4e83090
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Tue Feb 12 01:28:47 2019 +0530
summary: Fixes Issue 40119:Set two new columns in C_Invoice as nullable and
do not
set a default value
** Remove NOT NULL constraint for columns CREATEFROMORDERS, CREATEFROMINOUTS
** Avoid setting DEFAULT value N for above columns.
** Remove check constraint either Y or N for above columns.
diffstat:
src-db/database/model/tables/C_INVOICE.xml | 10 ++++------
src-db/database/sourcedata/AD_COLUMN.xml | 4 ++--
2 files changed, 6 insertions(+), 8 deletions(-)
diffs (50 lines):
diff -r 4d0df2352c16 -r 018aa4e83090 src-db/database/model/tables/C_INVOICE.xml
--- a/src-db/database/model/tables/C_INVOICE.xml Tue Feb 12 12:42:45
2019 +0100
+++ b/src-db/database/model/tables/C_INVOICE.xml Tue Feb 12 01:28:47
2019 +0530
@@ -277,12 +277,12 @@
<default><![CDATA[0]]></default>
<onCreateDefault><![CDATA[0]]></onCreateDefault>
</column>
- <column name="CREATEFROMORDERS" primaryKey="false" required="true"
type="CHAR" size="1" autoIncrement="false">
- <default><![CDATA[N]]></default>
+ <column name="CREATEFROMORDERS" primaryKey="false" required="false"
type="CHAR" size="1" autoIncrement="false">
+ <default/>
<onCreateDefault/>
</column>
- <column name="CREATEFROMINOUTS" primaryKey="false" required="true"
type="CHAR" size="1" autoIncrement="false">
- <default><![CDATA[N]]></default>
+ <column name="CREATEFROMINOUTS" primaryKey="false" required="false"
type="CHAR" size="1" autoIncrement="false">
+ <default/>
<onCreateDefault/>
</column>
<foreign-key foreignTable="C_BPARTNER_LOCATION"
name="C_BPLOCATION_CINVOICE">
@@ -391,8 +391,6 @@
<index-column name="UPDATED"/>
</index>
<check name="C_INVOICE_CREATEFROM_CHECK"><![CDATA[CREATEFROM IN ('Y',
'N')]]></check>
- <check name="C_INVOICE_CREATEFROMIO_CHEK"><![CDATA[CREATEFROMINOUTS IN
('Y', 'N')]]></check>
- <check name="C_INVOICE_CREATEFROMO_CHEK"><![CDATA[CREATEFROMORDERS IN
('Y', 'N')]]></check>
<check name="C_INVOICE_GENERATETO_CHECK"><![CDATA[GENERATETO IN ('Y',
'N')]]></check>
<check name="C_INVOICE_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y',
'N')]]></check>
<check name="C_INVOICE_ISCASHVAT_CH"><![CDATA[ISCASHVAT IN ('Y',
'N')]]></check>
diff -r 4d0df2352c16 -r 018aa4e83090 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Tue Feb 12 12:42:45 2019 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Tue Feb 12 01:28:47 2019 +0530
@@ -259942,7 +259942,7 @@
<!--35B6CA608E4544DABC461A352856483E-->
<FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
<!--35B6CA608E4544DABC461A352856483E--> <ISKEY><![CDATA[N]]></ISKEY>
<!--35B6CA608E4544DABC461A352856483E--> <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--35B6CA608E4544DABC461A352856483E-->
<ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--35B6CA608E4544DABC461A352856483E-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
<!--35B6CA608E4544DABC461A352856483E-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
<!--35B6CA608E4544DABC461A352856483E-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
<!--35B6CA608E4544DABC461A352856483E--> <SEQNO><![CDATA[880]]></SEQNO>
@@ -378863,7 +378863,7 @@
<!--E4657BAF62244FA786B4E5BD7C98E52B-->
<FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
<!--E4657BAF62244FA786B4E5BD7C98E52B--> <ISKEY><![CDATA[N]]></ISKEY>
<!--E4657BAF62244FA786B4E5BD7C98E52B--> <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--E4657BAF62244FA786B4E5BD7C98E52B-->
<ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--E4657BAF62244FA786B4E5BD7C98E52B-->
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
<!--E4657BAF62244FA786B4E5BD7C98E52B-->
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
<!--E4657BAF62244FA786B4E5BD7C98E52B-->
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
<!--E4657BAF62244FA786B4E5BD7C98E52B--> <SEQNO><![CDATA[870]]></SEQNO>
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
