[Aplaws-commit] r944 - trunk/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:11:43 +0200 (Mon, 03 Oct 2005)
New Revision: 944

Modified:
   trunk/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql
Log:
  Fixed postgres upgrade script, boolean is what we're after.


Modified: trunk/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql
===================================================================
--- trunk/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql	2005-09-30 11:22:34 UTC (rev 943)
+++ trunk/ccm-cms-types-formitem/sql/ccm-cms-types-formitem/postgres/upgrade/6.1.1-6.1.2/add-remote.sql	2005-10-03 10:11:43 UTC (rev 944)
@@ -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);