[icinga-checkins] icinga.org: icinga-core/mfriedrich/clob: idoutils: fix header, footer and missing final commit in oracle-upgrade.sql

[git at icinga.org]

Module: icinga-core
Branch: mfriedrich/clob
Commit: cd40b7098af107182554246e1e8564b74c8a5277
URL:    https://git.icinga.org/?p=icinga-core.git;a=commit;h=cd40b7098af107182554246e1e8564b74c8a5277

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Thu Nov  1 18:59:41 2012 +0100

idoutils: fix header, footer and missing final commit in oracle-upgrade.sql

---

 .../db/oracle/upgrade/oracle-upgrade-1.9.0.sql     |   12 +++++++-----
 1 files changed, 7 insertions(+), 5 deletions(-)

diff --git a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.9.0.sql b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.9.0.sql
index a5518a1..8e19d06 100644
--- a/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.9.0.sql
+++ b/module/idoutils/db/oracle/upgrade/oracle-upgrade-1.9.0.sql
@@ -1,10 +1,11 @@
 -- -----------------------------------------
 -- upgrade path for Icinga IDOUtils 1.9.0
 --
--- run it as icinga database user whithin  current directory 
--- sqlplus icinga@<instance> @ oracle-upgrade.1.9.0.sql
+-- run it as icinga database user from whithin current directory
+-- sqlplus icinga@<instance> @ oracle-upgrade-1.9.0.sql
+
 -- -----------------------------------------
--- Copyright (c) 2010-2012 Icinga Development Team (http://www.icinga.org)
+-- Copyright (c) 2012-2013 Icinga Development Team (http://www.icinga.org)
 --
 -- Please check http://docs.icinga.org for upgrading information!
 -- -----------------------------------------
@@ -107,9 +108,10 @@ alter table systemcommands drop column o_old;
 MERGE INTO dbversion
 	USING DUAL ON (name='idoutils')
 	WHEN MATCHED THEN
-		UPDATE SET version='&&ICINGA_VERSION'
+		UPDATE SET version='&&ICINGA_VERSION', modify_time=CURRENT_TIMESTAMP
 	WHEN NOT MATCHED THEN
-		INSERT (id, name, version) VALUES ('1', 'idoutils', '&&ICINGA_VERSION');
+		INSERT (id, name, version, create_time, modify_time) VALUES ('1', 'idoutils', '&&ICINGA_VERSION', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
+commit;
 
 /* last check */
 select object_name,object_type,status  from user_objects where status !='VALID';