[Aplaws-commit] r292 - in ccm-core/trunk/sql/ccm-core: 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 14:09:20 +0100 (Tue, 22 Feb 2005)
New Revision: 292

Added:
   ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/
   ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql
   ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-search_content.sql
   ccm-core/trunk/sql/ccm-core/postgres/upgrade/6.1.0-6.1.1/
   ccm-core/trunk/sql/ccm-core/postgres/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql
Modified:
   ccm-core/trunk/sql/ccm-core/upgrade/oracle-se-6.1.0-6.1.1.sql
   ccm-core/trunk/sql/ccm-core/upgrade/postgres-6.1.0-6.1.1.sql
Log:
  Proper data upgrade scripts for core.


Added: ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql
===================================================================
--- ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql	2005-02-22 09:32:28 UTC (rev 291)
+++ ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql	2005-02-22 13:09:20 UTC (rev 292)
@@ -0,0 +1,2 @@
+
+alter table lucene_docs add (content_section varchar(300));


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

Added: ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-search_content.sql
===================================================================
--- ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-search_content.sql	2005-02-22 09:32:28 UTC (rev 291)
+++ ccm-core/trunk/sql/ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-search_content.sql	2005-02-22 13:09:20 UTC (rev 292)
@@ -0,0 +1,2 @@
+
+alter table search_content add (content_section varchar(300));


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

Added: ccm-core/trunk/sql/ccm-core/postgres/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql
===================================================================
--- ccm-core/trunk/sql/ccm-core/postgres/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql	2005-02-22 09:32:28 UTC (rev 291)
+++ ccm-core/trunk/sql/ccm-core/postgres/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql	2005-02-22 13:09:20 UTC (rev 292)
@@ -0,0 +1,6 @@
+
+begin;
+
+alter table lucene_docs add column content_section varchar(300);
+
+commit;


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

Modified: ccm-core/trunk/sql/ccm-core/upgrade/oracle-se-6.1.0-6.1.1.sql
===================================================================
--- ccm-core/trunk/sql/ccm-core/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-02-22 09:32:28 UTC (rev 291)
+++ ccm-core/trunk/sql/ccm-core/upgrade/oracle-se-6.1.0-6.1.1.sql	2005-02-22 13:09:20 UTC (rev 292)
@@ -18,11 +18,8 @@
 -- $Id$
 -- $DateTime: 2004/08/16 18:10:38 $
 
-\echo Red Hat WAF 6.1.0 -> 6.1.1 Upgrade Script (Oracle SE)
+PROMPT Red Hat WAF 6.1.0 -> 6.1.1 Upgrade Script (Oracle)
 
-begin;
+@@ ../../ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql
+@@ ../../ccm-core/oracle-se/upgrade/6.1.0-6.1.1/upgrade-search_content.sql
 
-alter table search_content add (content_section varchar(300));
-alter table lucene_docs add (content_section varchar(300));
-
-commit;

Modified: ccm-core/trunk/sql/ccm-core/upgrade/postgres-6.1.0-6.1.1.sql
===================================================================
--- ccm-core/trunk/sql/ccm-core/upgrade/postgres-6.1.0-6.1.1.sql	2005-02-22 09:32:28 UTC (rev 291)
+++ ccm-core/trunk/sql/ccm-core/upgrade/postgres-6.1.0-6.1.1.sql	2005-02-22 13:09:20 UTC (rev 292)
@@ -20,8 +20,4 @@
 
 \echo Red Hat WAF 6.1.0 -> 6.1.1 Upgrade Script (PostgreSQL)
 
-begin;
-
-alter table lucene_docs add column content_section varchar(300);
-
-commit;
+\i ../../ccm-core/postgres/upgrade/6.1.0-6.1.1/upgrade-lucene_docs.sql