Title: [opsview] [8273] Update two other columns in opsview_performance_metrics to be NOT NULL as well
- Revision
- 8273
- Author
- tvoon
- Date
- 2012-04-05 12:22:36 +0100 (Thu, 05 Apr 2012)
Log Message
Update two other columns in opsview_performance_metrics to be NOT NULL as well
Modified Paths
Modified: trunk/opsview-core/installer/upgradedb_runtime.pl
===================================================================
--- trunk/opsview-core/installer/upgradedb_runtime.pl 2012-04-05 10:29:10 UTC (rev 8272)
+++ trunk/opsview-core/installer/upgradedb_runtime.pl 2012-04-05 11:22:36 UTC (rev 8273)
@@ -912,7 +912,7 @@
$dbh->do("ALTER TABLE opsview_hostgroups MODIFY COLUMN name VARCHAR(128) NOT NULL DEFAULT ''");
- $dbh->do('ALTER TABLE opsview_performance_metrics MODIFY COLUMN metricname VARCHAR(128) NOT NULL DEFAULT "", MODIFY COLUMN uom VARCHAR(64) DEFAULT NULL');
+ $dbh->do('ALTER TABLE opsview_performance_metrics MODIFY COLUMN hostname VARCHAR(64) NOT NULL DEFAULT "", MODIFY COLUMN servicename VARCHAR(128) NOT NULL DEFAULT "", MODIFY COLUMN metricname VARCHAR(128) NOT NULL DEFAULT "", MODIFY COLUMN uom VARCHAR(64) DEFAULT NULL');
$dbh->do('ALTER TABLE opsview_monitoringclusters MODIFY COLUMN id INT NOT NULL DEFAULT 0, MODIFY COLUMN name VARCHAR(64) NOT NULL DEFAULT ""');
$dbh->do('ALTER TABLE opsview_monitoringclusternodes MODIFY COLUMN id INT NOT NULL DEFAULT 0, MODIFY COLUMN name VARCHAR(64) NOT NULL DEFAULT "", MODIFY COLUMN ip VARCHAR(255) NOT NULL DEFAULT ""');
$dbh->do("ALTER TABLE opsview_hosts MODIFY COLUMN id INT NOT NULL DEFAULT 0, MODIFY COLUMN ip VARCHAR(255) NOT NULL DEFAULT ''");
Modified: trunk/opsview-core/t/var/configdumpend.expected
===================================================================
--- trunk/opsview-core/t/var/configdumpend.expected 2012-04-05 10:29:10 UTC (rev 8272)
+++ trunk/opsview-core/t/var/configdumpend.expected 2012-04-05 11:22:36 UTC (rev 8273)
@@ -344,9 +344,9 @@
CREATE TABLE `opsview_performance_metrics` (
`service_object_id` int(11) default '0',
`id` int(11) NOT NULL auto_increment,
- `hostname` varchar(64) default NULL,
- `servicename` varchar(128) default NULL,
- `metricname` varchar(128) default NULL,
+ `hostname` varchar(64) NOT NULL default '',
+ `servicename` varchar(128) NOT NULL default '',
+ `metricname` varchar(128) NOT NULL default '',
`uom` varchar(64) default NULL,
PRIMARY KEY (`id`),
KEY `service_object_id` (`service_object_id`),
Modified: trunk/opsview-core/t/var/runtime.test.db
===================================================================
--- trunk/opsview-core/t/var/runtime.test.db 2012-04-05 10:29:10 UTC (rev 8272)
+++ trunk/opsview-core/t/var/runtime.test.db 2012-04-05 11:22:36 UTC (rev 8273)
@@ -12944,8 +12944,8 @@
CREATE TABLE `opsview_performance_metrics` (
`service_object_id` int(11) default '0',
`id` int(11) NOT NULL auto_increment,
- `hostname` varchar(64) default NULL,
- `servicename` varchar(128) default NULL,
+ `hostname` varchar(64) NOT NULL default '',
+ `servicename` varchar(128) NOT NULL default '',
`metricname` varchar(128) NOT NULL default '',
`uom` varchar(64) default NULL,
PRIMARY KEY (`id`),
_______________________________________________
Opsview-checkins mailing list
Opsview-checkins@lists.opsview.org
http://lists.opsview.org/lists/listinfo/opsview-checkins
