details: https://code.openbravo.com/erp/devel/pi/rev/234dc1964e6d changeset: 14256:234dc1964e6d user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Nov 15 12:18:34 2011 +0100 summary: related to issue 18878: isAdvanced col is mandatory and has check
details: https://code.openbravo.com/erp/devel/pi/rev/c61120f1c12c changeset: 14257:c61120f1c12c user: Asier Lostalé <asier.lostale <at> openbravo.com> date: Tue Nov 15 12:19:02 2011 +0100 summary: related to issue 18878: isAdvanced col is mandatory and has check diffstat: modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_IMPL.xml | 3 ++- src-db/database/model/tables/AD_FORM.xml | 3 ++- src-db/database/model/tables/AD_PROCESS.xml | 3 ++- src-db/database/model/tables/AD_WINDOW.xml | 1 + 4 files changed, 7 insertions(+), 3 deletions(-) diffs (71 lines): diff -r 15d911f25076 -r c61120f1c12c modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_IMPL.xml --- a/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_IMPL.xml Tue Nov 15 11:33:06 2011 +0100 +++ b/modules/org.openbravo.client.application/src-db/database/model/tables/OBUIAPP_VIEW_IMPL.xml Tue Nov 15 12:19:02 2011 +0100 @@ -53,7 +53,7 @@ <default/> <onCreateDefault/> </column> - <column name="ISADVANCEDFEATURE" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"> + <column name="ISADVANCEDFEATURE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> <default><![CDATA[N]]></default> <onCreateDefault><![CDATA['N']]></onCreateDefault> </column> @@ -74,6 +74,7 @@ <unique-column name="AD_MODULE_ID"/> <unique-column name="NAME"/> </unique> + <check name="OBUIAPP_ADV_CHCK"><![CDATA[ISADVANCEDFEATURE IN ('Y', 'N')]]></check> <check name="OBUIAPP_VI_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> </table> </database> diff -r 15d911f25076 -r c61120f1c12c src-db/database/model/tables/AD_FORM.xml --- a/src-db/database/model/tables/AD_FORM.xml Tue Nov 15 11:33:06 2011 +0100 +++ b/src-db/database/model/tables/AD_FORM.xml Tue Nov 15 12:19:02 2011 +0100 @@ -57,7 +57,7 @@ <default><![CDATA[0]]></default> <onCreateDefault><![CDATA[SELECT AD_MODULE_ID FROM AD_MODULE WHERE AD_MODULE_ID<>'0' AND TYPE='M']]></onCreateDefault> </column> - <column name="ISADVANCEDFEATURE" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"> + <column name="ISADVANCEDFEATURE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> <default><![CDATA[N]]></default> <onCreateDefault><![CDATA['N']]></onCreateDefault> </column> @@ -70,6 +70,7 @@ <foreign-key foreignTable="AD_ORG" name="AD_FORM_AD_ORG"> <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> </foreign-key> + <check name="AD_FORM_ADV_CHCK"><![CDATA[ISADVANCEDFEATURE IN ('Y', 'N')]]></check> <check name="AD_FORM_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> </table> </database> diff -r 15d911f25076 -r c61120f1c12c src-db/database/model/tables/AD_PROCESS.xml --- a/src-db/database/model/tables/AD_PROCESS.xml Tue Nov 15 11:33:06 2011 +0100 +++ b/src-db/database/model/tables/AD_PROCESS.xml Tue Nov 15 12:19:02 2011 +0100 @@ -105,7 +105,7 @@ <default><![CDATA[S]]></default> <onCreateDefault><![CDATA[CASE WHEN PROCEDURENAME IS NOT NULL THEN 'S' WHEN ISJASPER='Y' THEN 'S' ELSE 'M' END]]></onCreateDefault> </column> - <column name="ISADVANCEDFEATURE" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false"> + <column name="ISADVANCEDFEATURE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false"> <default><![CDATA[N]]></default> <onCreateDefault><![CDATA['N']]></onCreateDefault> </column> @@ -118,6 +118,7 @@ <foreign-key foreignTable="AD_ORG" name="AD_PROCESS_AD_ORG"> <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/> </foreign-key> + <check name="AD_PROCESS_ADV_CHCK"><![CDATA[ISADVANCEDFEATURE IN ('Y', 'N')]]></check> <check name="AD_PROCESS_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> <check name="AD_PROCESS_ISBACKGROUND_CHK"><![CDATA[ISBACKGROUND IN ('Y', 'N')]]></check> <check name="AD_PROCESS_ISDIRECTPRINT_CHK"><![CDATA[ISDIRECTPRINT IN ('Y', 'N')]]></check> diff -r 15d911f25076 -r c61120f1c12c src-db/database/model/tables/AD_WINDOW.xml --- a/src-db/database/model/tables/AD_WINDOW.xml Tue Nov 15 11:33:06 2011 +0100 +++ b/src-db/database/model/tables/AD_WINDOW.xml Tue Nov 15 12:19:02 2011 +0100 @@ -94,6 +94,7 @@ <unique-column name="NAME"/> <unique-column name="AD_MODULE_ID"/> </unique> + <check name="AD_WINDOW_ADV_CHCK"><![CDATA[ISADVANCEDFEATURE IN ('Y', 'N')]]></check> <check name="AD_WINDOW_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check> <check name="AD_WINDOW_ISSOTRX_CHK"><![CDATA[ISSOTRX IN ('Y', 'N')]]></check> <check name="AD_WINDOW_ISTHREADSAFE_CHK"><![CDATA[ISTHREADSAFE IN ('Y', 'N')]]></check> ------------------------------------------------------------------------------ RSA(R) Conference 2012 Save $700 by Nov 18 Register now http://p.sf.net/sfu/rsa-sfdev2dev1 _______________________________________________ Openbravo-commits mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/openbravo-commits
