[Aplaws-commit] r293 - in ccm-cms/trunk/sql/ccm-cms: oracle-se/upgrade oracle-se/upgrade/6.1.0-6.1.1 postgres/upgrade postgres/upgrade/6.1.0-6.1.1 upgrade

[<ssk...@re...>]

Author: sskracic
Date: 2005-02-22 16:10:39 +0100 (Tue, 22 Feb 2005)
New Revision: 293

Added:
   ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/
   ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
   ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/
   ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
Modified:
   ccm-cms/trunk/sql/ccm-cms/upgrade/oracle-se-6.1.0-6.1.1.sql
   ccm-cms/trunk/sql/ccm-cms/upgrade/postgres-6.1.0-6.1.1.sql
Log:
  Proper CMS upgrade scripts.


Added: ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
===================================================================
--- ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql	2005-02-22 13:09:20 UTC (rev 292)
+++ ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql	2005-02-22 15:10:39 UTC (rev 293)
@@ -0,0 +1,2 @@
+
+alter table cms_files add (length int);


Property changes on: ccm-cms/trunk/sql/ccm-cms/oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL

Added: ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
===================================================================
--- ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql	2005-02-22 13:09:20 UTC (rev 292)
+++ ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql	2005-02-22 15:10:39 UTC (rev 293)
@@ -0,0 +1,2 @@
+
+alter table cms_files add column length int;


Property changes on: ccm-cms/trunk/sql/ccm-cms/postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
___________________________________________________________________
Name: svn:keywords
   + Id Author URL

Modified: ccm-cms/trunk/sql/ccm-cms/upgrade/oracle-se-6.1.0-6.1.1.sql
===================================================================
--- ccm-cms/trunk/sql/ccm-cms/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-02-22 13:09:20 UTC (rev 292)
+++ ccm-cms/trunk/sql/ccm-cms/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-02-22 15:10:39 UTC (rev 293)
@@ -18,10 +18,7 @@
 -- $Id$
 -- $DateTime: 2004/08/16 18:10:38 $
 
-\echo Red Hat Enterprise CMS 6.1.0 -> 6.1.1 Upgrade Script (Oracle SE)
+PROMPT Red Hat Enterprise CMS 6.1.0 -> 6.1.1 Upgrade Script (Oracle)
 
-begin;
+@@ ../oracle-se/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
 
-alter table cms_files add (length int);
-
-commit;

Modified: ccm-cms/trunk/sql/ccm-cms/upgrade/postgres-6.1.0-6.1.1.sql
===================================================================
--- ccm-cms/trunk/sql/ccm-cms/upgrade/postgres-6.1.0-6.1.1.sql	2005-02-22 13:09:20 UTC (rev 292)
+++ ccm-cms/trunk/sql/ccm-cms/upgrade/postgres-6.1.0-6.1.1.sql	2005-02-22 15:10:39 UTC (rev 293)
@@ -22,6 +22,6 @@
 
 begin;
 
-alter table cms_files add column length int;
+\i ../postgres/upgrade/6.1.0-6.1.1/upgrade-cms_files.sql
 
 commit;