Formal changes in PostgreSQL
authorAntonio Moreno <antonio.moreno@openbravo.com>
Fri, 21 Nov 2008 15:03:56 +0000
changeset 2067 c73cf7263093
parent 2066 f7b3a8f2f667
child 2068 07c54091f6d2
Formal changes in PostgreSQL
src-db/database/model/tables/AD_SYSTEM_INFO.xml
src-db/database/model/triggers/AD_SYSTEM_INFO_TRG2.xml
src-db/database/model/views/AD_PROCESS_RUN_V.xml
--- a/src-db/database/model/tables/AD_SYSTEM_INFO.xml	Fri Nov 21 14:55:12 2008 +0000
+++ b/src-db/database/model/tables/AD_SYSTEM_INFO.xml	Fri Nov 21 15:03:56 2008 +0000
@@ -97,8 +97,6 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
-      <check name="ADSYSTEMINFO_CUSTOMALLOW_CHECK"><![CDATA[
-CUSTOMIZATION_ALLOWED IN ('Y', 'N')
-]]></check>
+      <check name="ADSYSTEMINFO_CUSTOMALLOW_CHECK"><![CDATA[CUSTOMIZATION_ALLOWED IN ('Y', 'N')]]></check>
     </table>
   </database>
--- a/src-db/database/model/triggers/AD_SYSTEM_INFO_TRG2.xml	Fri Nov 21 14:55:12 2008 +0000
+++ b/src-db/database/model/triggers/AD_SYSTEM_INFO_TRG2.xml	Fri Nov 21 15:03:56 2008 +0000
@@ -20,7 +20,7 @@
 * Contributor(s):  ______________________________________.
 ************************************************************************/
 
-exist NUMBER := 0;
+exist NUMBER:= 0;
 indTempName NVARCHAR2(50) := 'System Customization';
 indTempPackage NVARCHAR2(50) := 'mySystem.CustomizationTemplate';
 
--- a/src-db/database/model/views/AD_PROCESS_RUN_V.xml	Fri Nov 21 14:55:12 2008 +0000
+++ b/src-db/database/model/views/AD_PROCESS_RUN_V.xml	Fri Nov 21 15:03:56 2008 +0000
@@ -1,7 +1,6 @@
 <?xml version="1.0"?>
   <database name="VIEW AD_PROCESS_RUN_V">
     <view name="AD_PROCESS_RUN_V"><![CDATA[SELECT rn.ad_process_run_id, rn.ad_client_id, rn.ad_org_id, rn.isactive, rn.created, rn.createdby, rn.updated, rn.updatedby, rq.ad_user_id, rn.status, rn.start_time, rn.end_time, rn.runtime, rn.log, rn.result, rq.params, rn.report, rq.channel, rq.ad_process_id, rn.ad_process_request_id
-FROM ad_process_run rn
-LEFT JOIN ad_process_request rq
-ON rn.ad_process_request_id = rq.ad_process_request_id]]></view>
+   FROM ad_process_run rn
+   LEFT JOIN ad_process_request rq ON rn.ad_process_request_id = rq.ad_process_request_id]]></view>
   </database>