[Aplaws-commit] r1088 - in contrib/ccm-ldn-camden-consultation/trunk: . sql/ccm-ldn-camden-consultation/upgrade

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

Author: sskracic
Date: 2006-02-02 11:32:15 +0100 (Thu, 02 Feb 2006)
New Revision: 1088

Modified:
   contrib/ccm-ldn-camden-consultation/trunk/application.xml
   contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.3-1.1.0.sql
Log:
  Providing default value for not null column, so that the upgrade is painless.


Modified: contrib/ccm-ldn-camden-consultation/trunk/application.xml
===================================================================
--- contrib/ccm-ldn-camden-consultation/trunk/application.xml	2006-02-01 14:21:50 UTC (rev 1087)
+++ contrib/ccm-ldn-camden-consultation/trunk/application.xml	2006-02-02 10:32:15 UTC (rev 1088)
@@ -3,7 +3,7 @@
   name="ccm-ldn-camden-consultation"
   prettyName="Red Hat CCM Content Types"
   version="1.1.0"
-  release="7"
+  release="8"
   webapp="ROOT">
   <ccm:dependencies>
     <ccm:requires name="ccm-core" version="6.1.1" relation="ge"/>

Modified: contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.3-1.1.0.sql
===================================================================
--- contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.3-1.1.0.sql	2006-02-01 14:21:50 UTC (rev 1087)
+++ contrib/ccm-ldn-camden-consultation/trunk/sql/ccm-ldn-camden-consultation/upgrade/oracle-se-1.0.3-1.1.0.sql	2006-02-02 10:32:15 UTC (rev 1088)
@@ -5,7 +5,7 @@
 alter table cam_consultation_alerts
     add constraint cam_con_ale_mob_confir_c_3cz1u
           check(mobile_confirmed in ('0', '1'));
-alter table cam_consultations add sms_alert_sent CHAR(1);
+alter table cam_consultations add sms_alert_sent CHAR(1) DEFAULT '0';
 
 update cam_consultations set
     sms_alert_sent = alert_sent;