[icinga-checkins] icinga.org: icinga-web/master: 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: master
Commit: d188a87db611003cb2181d5ca74aa96a93d2589f
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=d188a87db611003cb2181d5ca74aa96a93d2589f

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

Conflicts:

	etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql
	etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql
	etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql

---

 etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql  |   11 +++++++++++
 etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql |   11 +++++++++++
 etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql  |   11 +++++++++++
 3 files changed, 33 insertions(+), 0 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
new file mode 100644
index 0000000..d1d733e
--- /dev/null
+++ b/etc/schema/updates/mysql_v1-7-1_to_v1-7-2.sql
@@ -0,0 +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
new file mode 100644
index 0000000..e057f03
--- /dev/null
+++ b/etc/schema/updates/oracle_v1-7-1_to_v1-7-2.sql
@@ -0,0 +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
new file mode 100644
index 0000000..d1d733e
--- /dev/null
+++ b/etc/schema/updates/pgsql_v1-7-1_to_v1-7-2.sql
@@ -0,0 +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'
+);





More information about the icinga-checkins mailing list