[icinga-checkins] icinga.org: icinga-web/tdressler/issue_3855: Oracle: add missed commit and error handler to upgrade v1.8.3 -to- v1.9.0

git at icinga.org git at icinga.org
Sat Apr 13 20:58:58 CEST 2013


Module: icinga-web
Branch: tdressler/issue_3855
Commit: aa778f127311836bb9a90e383893274eb3913abb
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=aa778f127311836bb9a90e383893274eb3913abb

Author: Thomas Dressler <tdressler at tdressler.net>
Date:   Sat Apr 13 20:42:57 2013 +0200

Oracle: add missed commit and error handler to upgrade v1.8.3 -to- v1.9.0

---

 .../updates/oracle/oracle_v1-8-3_to_v1-9.sql       |   13 ++++++++++---
 1 files changed, 10 insertions(+), 3 deletions(-)

diff --git a/etc/schema/updates/oracle/oracle_v1-8-3_to_v1-9.sql b/etc/schema/updates/oracle/oracle_v1-8-3_to_v1-9.sql
index 3ef4bbc..fdb097a 100644
--- a/etc/schema/updates/oracle/oracle_v1-8-3_to_v1-9.sql
+++ b/etc/schema/updates/oracle/oracle_v1-8-3_to_v1-9.sql
@@ -1,7 +1,14 @@
+--error handler
+whenever sqlerror exit failure
+
+-- User description attribute (#3923)
+ALTER TABLE nsm_user
+    ADD (user_description VARCHAR2(255));
+
 -- Default version bump
 DELETE FROM nsm_db_version;
 INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.9.0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
 
--- User description attribute (#3923)
-ALTER TABLE nsm_user
-    ADD (user_description VARCHAR2(255));
\ No newline at end of file
+--final commit 
+commit;
+





More information about the icinga-checkins mailing list