[icinga-checkins] icinga.org: icinga-web/r1.7: Fixes schema upgrade from 1.7.1 to 1.7.2

git at icinga.org git at icinga.org
Thu Aug 23 10:30:09 CEST 2012


Module: icinga-web
Branch: r1.7
Commit: 070b1212f19cc1564594bb99564cae6ef1fe7fac
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=070b1212f19cc1564594bb99564cae6ef1fe7fac

Author: Marius Hein <marius.hein at netways.de>
Date:   Thu Aug 23 10:27:18 2012 +0200

Fixes schema upgrade from 1.7.1 to 1.7.2

fixes #3002

---

 etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql  |    9 +++++++++
 etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql |    9 +++++++++
 etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql  |   11 ++++++++++-
 3 files changed, 28 insertions(+), 1 deletions(-)

diff --git a/etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql b/etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql
index ca854a6..d1d733e 100644
--- a/etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql
+++ b/etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql
@@ -1,2 +1,11 @@
 DELETE FROM nsm_db_version;
 INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.7.2', NOW(), NOW());
+
+INSERT INTO nsm_target
+    (target_name,target_description,target_class,target_type) 
+VALUES (
+    'icinga.cronk.admin',
+    'Allow user edit and delete all cronks',
+    '',
+    'credential'
+);
diff --git a/etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql b/etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql
index 41f366e..e057f03 100644
--- a/etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql
+++ b/etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql
@@ -1,2 +1,11 @@
 DELETE FROM nsm_db_version;
 INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.7.2', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
+
+INSERT INTO nsm_target
+    (target_name,target_description,target_class,target_type) 
+VALUES (
+    'icinga.cronk.admin',
+    'Allow user edit and delete all cronks',
+    '',
+    'credential'
+);
diff --git a/etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql b/etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql
index 8c8731d..d1d733e 100644
--- a/etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql
+++ b/etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql
@@ -1,2 +1,11 @@
 DELETE FROM nsm_db_version;
-INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.7.2', NOW(), NOW());
\ No newline at end of file
+INSERT INTO nsm_db_version VALUES ('1','icinga-web/v1.7.2', NOW(), NOW());
+
+INSERT INTO nsm_target
+    (target_name,target_description,target_class,target_type) 
+VALUES (
+    'icinga.cronk.admin',
+    'Allow user edit and delete all cronks',
+    '',
+    'credential'
+);





More information about the icinga-checkins mailing list