related to issue 26877: reapplied changes after q3 release
authorAsier Lostalé <asier.lostale@openbravo.com>
Wed, 06 Aug 2014 16:39:25 +0200
changeset 577 1d7351558170
parent 576 99de7d7493b2
child 578 ed44c24f64f1
related to issue 26877: reapplied changes after q3 release
model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml
--- a/model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Wed Aug 06 16:37:19 2014 +0200
+++ b/model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Wed Aug 06 16:39:25 2014 +0200
@@ -33,7 +33,7 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="AD_PROCESS_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+      <column name="AD_PROCESS_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault/>
       </column>
@@ -197,6 +197,14 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="AD_PROCESS_GROUP_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
+      <column name="ISGROUP" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault><![CDATA['N']]></onCreateDefault>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="AD_PROCESS_REQUEST_AD_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
@@ -209,5 +217,8 @@
       <foreign-key foreignTable="AD_USER" name="AD_PROCESS_REQUEST_AD_USER">
         <reference local="AD_USER_ID" foreign="AD_USER_ID"/>
       </foreign-key>
+      <check name="AD_PROCESS_REQUEST_GROUP_CHK"><![CDATA[((ISGROUP = 'Y') AND (AD_PROCESS_GROUP_ID IS NOT NULL)) OR ((ISGROUP = 'N') AND (AD_PROCESS_GROUP_ID IS NULL))]]></check>
+      <check name="AD_PROCESS_REQUEST_ISGROUP_CHK"><![CDATA[ISGROUP IN ('Y', 'N')]]></check>
+      <check name="AD_PROCESS_REQUEST_PROCESS_CHK"><![CDATA[((AD_PROCESS_ID IS NOT NULL) AND (AD_PROCESS_GROUP_ID IS NULL)) OR ((AD_PROCESS_GROUP_ID IS NOT NULL) AND (AD_PROCESS_ID IS NULL))]]></check>
     </table>
   </database>