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

git at icinga.org git at icinga.org
Tue Apr 16 11:24:42 CEST 2013


Module: icinga-web
Branch: next
Commit: 925b48aaaa90d8d16b0d102f50bf8140f78a52b3
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=925b48aaaa90d8d16b0d102f50bf8140f78a52b3

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       |    9 ++++++++-
 1 files changed, 8 insertions(+), 1 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 dc592c0..ce47bcf 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,3 +1,6 @@
+--error handler
+whenever sqlerror exit failure
+
 -- Default version bump
 DELETE FROM nsm_db_version;
 INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.9.0', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
@@ -9,4 +12,8 @@ ALTER TABLE nsm_user
 -- Add unique constrain for target_name/NsmTarget (#3915)
 ALTER TABLE
   nsm_target
-  add constraint target_key_unique_target_name_uq UNIQUE (target_name);
\ No newline at end of file
+  add constraint target_key_unique_target_name_uq UNIQUE (target_name);
+
+--final commit 
+commit;
+





More information about the icinga-checkins mailing list