[Aplaws-commit] r885 - trunk/ccm-cms-types-agenda/sql/ccm-cms-types-agenda/upgrade

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

Author: sskracic
Date: 2005-09-21 14:31:41 +0200 (Wed, 21 Sep 2005)
New Revision: 885

Modified:
   trunk/ccm-cms-types-agenda/sql/ccm-cms-types-agenda/upgrade/oracle-se-6.1.0-6.1.1.sql
Log:
  Upgrade script for Oracle not needed, since DATE contains time portion as well.


Modified: trunk/ccm-cms-types-agenda/sql/ccm-cms-types-agenda/upgrade/oracle-se-6.1.0-6.1.1.sql
===================================================================
--- trunk/ccm-cms-types-agenda/sql/ccm-cms-types-agenda/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-09-21 08:38:09 UTC (rev 884)
+++ trunk/ccm-cms-types-agenda/sql/ccm-cms-types-agenda/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-09-21 12:31:41 UTC (rev 885)
@@ -18,16 +18,4 @@
 -- $Id$
 -- $DateTime: 2004/08/16 18:10:38 $
 
-\echo Agenda content-type 6.1.0 -> 6.1.1 Upgrade Script (Oracle SE)
-
-begin;
-
-alter table ct_agendas rename column agenda_date to agenda_date_old;
-
-alter table ct_agendas add agenda_date TIMESTAMP;
-
-update ct_agendas set agenda_date = agenda_date_old;
-
-alter table ct_agendas drop column agenda_date_old;
-
-commit;
+PROMPT Agenda content-type 6.1.0 -> 6.1.1 Upgrade Script (Oracle SE)