[Aplaws-commit] r947 - releases/1.0.3/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2

[<ssk...@vh...>]

Author: sskracic
Date: 2005-10-03 12:28:29 +0200 (Mon, 03 Oct 2005)
New Revision: 947

Modified:
   releases/1.0.3/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql
Log:
  Integrated r944 on release 1.0.3 branch (postgres upgrade script fix).


Modified: releases/1.0.3/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql
===================================================================
--- releases/1.0.3/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql	2005-10-03 10:25:11 UTC (rev 946)
+++ releases/1.0.3/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql	2005-10-03 10:28:29 UTC (rev 947)
@@ -1,12 +1,11 @@
 
 begin;
-  alter table cms_form_item add remote_action char(1);
-  alter table cms_form_item add constraint cms_form_item_remt_act_ck check (remote_action in ('0', '1'));
+  alter table cms_form_item add remote_action boolean;
 
   alter table cms_form_item add remote_url varchar(700);
 
   alter table cms_form_item drop constraint CMS_FORM_ITEM_FRM_FK;
-  
+
   alter table cms_form_item add constraint CMS_FORM_ITEM_FORM_ID_F_FRZIF
   foreign key (FORM_ID) references BEBOP_FORM_SECTIONS(FORM_SECTION_ID);