Fix of syntax.
authorIoritz Cia <ioritz.cia@openbravo.com>
Mon, 27 Feb 2012 10:30:45 +0100
changeset 15623 14313dc2eac4
parent 15622 b5f38705d906
child 15624 5d04ccfa2cd8
Fix of syntax.
src-db/database/model/tables/S_TIMEEXPENSE.xml
--- a/src-db/database/model/tables/S_TIMEEXPENSE.xml	Sun Feb 26 17:25:02 2012 +0100
+++ b/src-db/database/model/tables/S_TIMEEXPENSE.xml	Mon Feb 27 10:30:45 2012 +0100
@@ -54,7 +54,7 @@
         <onCreateDefault/>
       </column>
       <column name="PROCESSED" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
-        <default><![CDATA['N'::character(1)]]></default>
+        <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
       <column name="M_PRICELIST_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
@@ -85,6 +85,7 @@
         <reference local="M_WAREHOUSE_ID" foreign="M_WAREHOUSE_ID"/>
       </foreign-key>
       <check name="S_TIMEEXPENSE_ISACTIVE_CHK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
-      <check name="S_TIMEEXPENSE_PROCESSING_CHK"><![CDATA[PROCESSING IN 'Y', 'N']]></check>
+      <check name="S_TIMEEXPENSE_PROCESSING_CHK"><![CDATA[PROCESSING IN ('Y', 'N')]]></check>
+      <check name="S_TIMEEXPENSE_PROCESSED_CHK"><![CDATA[PROCESSED IN ('Y', 'N')]]></check>
     </table>
   </database>