Fixes issue 26877: Api Changes in AD_PROCESS_REQUEST
authorRafa de Miguel <rafael.demiguel@openbravo.com>
Tue, 15 Jul 2014 10:31:03 +0200
changeset 565 be1d431cfe98
parent 564 7e96b012f728
child 566 4f64f24a7c0f
Fixes issue 26877: Api Changes in AD_PROCESS_REQUEST
model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml
--- a/model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Thu Jun 26 15:47:58 2014 +0200
+++ b/model/src-db/database/model/tables/AD_PROCESS_REQUEST.xml	Tue Jul 15 10:31:03 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>