Title: [opsview] [9988] Convert iOS change from using old schema numbers to new ones
Revision
9988
Author
tvoon
Date
2012-09-06 22:20:06 +0100 (Thu, 06 Sep 2012)

Log Message

Convert iOS change from using old schema numbers to new ones

Modified Paths


Modified: trunk/opsview-core/bin/db_opsview
===================================================================
--- trunk/opsview-core/bin/db_opsview	2012-09-06 21:16:48 UTC (rev 9987)
+++ trunk/opsview-core/bin/db_opsview	2012-09-06 21:20:06 UTC (rev 9988)
@@ -1220,6 +1220,7 @@
 	INSERT INTO schema_version (major_release, version) VALUES ('3.11', '15');
 	INSERT INTO schema_version (major_release, version) VALUES ('3.13', '12');
 	INSERT INTO schema_version (major_release, version) VALUES ('3.15', '12');
+    INSERT INTO schema_version (major_release, version, created_at) VALUES ('20120906ios', 'install', NOW());
 
 
 EOF

Modified: trunk/opsview-core/installer/upgradedb_opsview.pl
===================================================================
--- trunk/opsview-core/installer/upgradedb_opsview.pl	2012-09-06 21:16:48 UTC (rev 9987)
+++ trunk/opsview-core/installer/upgradedb_opsview.pl	2012-09-06 21:20:06 UTC (rev 9988)
@@ -4612,13 +4612,17 @@
     $db->updated;
 }
 
-if ( $db->is_lower("3.15.12") ) {
-    $db->print( "Adding IOS push notification profile" );
+unless (
+    $db->is_installed(
+        "20120906ios", "Adding iOS push notification profile", "all"
+    )
+  )
+{
     $dbh->do(
         q[
         INSERT into notificationmethods
         SET active      = 1,
-            name        = 'Push Notifications For IOS Mobile',
+            name        = 'Push Notifications For iOS Mobile',
             namespace   = 'com.opsview.notificationmethods.iospush',
             master      = 1,
             command     = 'notify_by_ios_push',

Modified: trunk/opsview-core/t/var/opsview.test.db
===================================================================
--- trunk/opsview-core/t/var/opsview.test.db	2012-09-06 21:16:48 UTC (rev 9987)
+++ trunk/opsview-core/t/var/opsview.test.db	2012-09-06 21:20:06 UTC (rev 9988)
@@ -1416,7 +1416,7 @@
 INSERT INTO `notificationmethods` VALUES (3,1,'Email','com.opsview.notificationmethods.email',0,'notify_by_email',1,0,'EMAIL');
 INSERT INTO `notificationmethods` VALUES (4,1,'RSS','com.opsview.notificationmethods.rss',1,'notify_by_rss',2000,0,'RSS_MAXIMUM_ITEMS,RSS_MAXIMUM_AGE,RSS_COLLAPSED');
 INSERT INTO `notificationmethods` VALUES (5,0,'unused','unused',1,'unused',1,0,'');
-INSERT INTO `notificationmethods` VALUES (6,1,'Push Notifications For IOS Mobile','com.opsview.notificationmethods.iospush',1,'notify_by_ios_push',1,0,NULL);
+INSERT INTO `notificationmethods` VALUES (6,1,'Push Notifications For iOS Mobile','com.opsview.notificationmethods.iospush',1,'notify_by_ios_push',1,0,NULL);
 /*!40000 ALTER TABLE `notificationmethods` ENABLE KEYS */;
 UNLOCK TABLES;
 
@@ -2055,11 +2055,12 @@
 INSERT INTO `schema_version` VALUES ('2.13','2',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('2.14','9',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('2.9','4',NULL,NULL,NULL);
+INSERT INTO `schema_version` VALUES ('20120906ios','all','Adding iOS push notification profile','2012-09-06 21:08:43',0);
 INSERT INTO `schema_version` VALUES ('3.0','4',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.1','4',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.11','15',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.13','12',NULL,NULL,NULL);
-INSERT INTO `schema_version` VALUES ('3.15','12',NULL,NULL,NULL);
+INSERT INTO `schema_version` VALUES ('3.15','11',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.3','9',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.5','4',NULL,NULL,NULL);
 INSERT INTO `schema_version` VALUES ('3.6','1',NULL,NULL,NULL);

_______________________________________________
Opsview-checkins mailing list
[email protected]
http://lists.opsview.org/lists/listinfo/opsview-checkins

Reply via email to