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);
|
