Modified: trunk/opsview-core/t/var/odw.db
===================================================================
--- trunk/opsview-core/t/var/odw.db 2010-11-08 16:33:46 UTC (rev 5333)
+++ trunk/opsview-core/t/var/odw.db 2010-11-08 16:38:02 UTC (rev 5334)
@@ -1,8 +1,3 @@
--- MySQL dump 10.11
---
--- Host: localhost Database: odw
--- ------------------------------------------------------
--- Server version 5.0.51a-24+lenny4-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@@ -15,17 +10,11 @@
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
---
--- Current Database: `odw`
---
CREATE DATABASE /*!32312 IF NOT EXISTS*/ `odw` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `odw`;
---
--- Table structure for table `acknowledgement_host`
---
DROP TABLE IF EXISTS `acknowledgement_host`;
SET @saved_cs_client = @@character_set_client;
@@ -44,18 +33,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `acknowledgement_host`
---
LOCK TABLES `acknowledgement_host` WRITE;
/*!40000 ALTER TABLE `acknowledgement_host` DISABLE KEYS */;
/*!40000 ALTER TABLE `acknowledgement_host` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `acknowledgement_service`
---
DROP TABLE IF EXISTS `acknowledgement_service`;
SET @saved_cs_client = @@character_set_client;
@@ -74,18 +57,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `acknowledgement_service`
---
LOCK TABLES `acknowledgement_service` WRITE;
/*!40000 ALTER TABLE `acknowledgement_service` DISABLE KEYS */;
/*!40000 ALTER TABLE `acknowledgement_service` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `availability`
---
DROP TABLE IF EXISTS `availability`;
SET @saved_cs_client = @@character_set_client;
@@ -104,18 +81,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `availability`
---
LOCK TABLES `availability` WRITE;
/*!40000 ALTER TABLE `availability` DISABLE KEYS */;
/*!40000 ALTER TABLE `availability` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `availability_host_summary`
---
DROP TABLE IF EXISTS `availability_host_summary`;
SET @saved_cs_client = @@character_set_client;
@@ -132,18 +103,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `availability_host_summary`
---
LOCK TABLES `availability_host_summary` WRITE;
/*!40000 ALTER TABLE `availability_host_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `availability_host_summary` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `availability_hostgroup_summary`
---
DROP TABLE IF EXISTS `availability_hostgroup_summary`;
SET @saved_cs_client = @@character_set_client;
@@ -160,18 +125,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `availability_hostgroup_summary`
---
LOCK TABLES `availability_hostgroup_summary` WRITE;
/*!40000 ALTER TABLE `availability_hostgroup_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `availability_hostgroup_summary` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `availability_summary`
---
DROP TABLE IF EXISTS `availability_summary`;
SET @saved_cs_client = @@character_set_client;
@@ -186,18 +145,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `availability_summary`
---
LOCK TABLES `availability_summary` WRITE;
/*!40000 ALTER TABLE `availability_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `availability_summary` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `database_version`
---
DROP TABLE IF EXISTS `database_version`;
SET @saved_cs_client = @@character_set_client;
@@ -207,9 +160,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `database_version`
---
LOCK TABLES `database_version` WRITE;
/*!40000 ALTER TABLE `database_version` DISABLE KEYS */;
@@ -217,9 +167,6 @@
/*!40000 ALTER TABLE `database_version` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `dataloads`
---
DROP TABLE IF EXISTS `dataloads`;
SET @saved_cs_client = @@character_set_client;
@@ -246,18 +193,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `dataloads`
---
LOCK TABLES `dataloads` WRITE;
/*!40000 ALTER TABLE `dataloads` DISABLE KEYS */;
/*!40000 ALTER TABLE `dataloads` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `downtime_host_history`
---
DROP TABLE IF EXISTS `downtime_host_history`;
SET @saved_cs_client = @@character_set_client;
@@ -282,18 +223,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `downtime_host_history`
---
LOCK TABLES `downtime_host_history` WRITE;
/*!40000 ALTER TABLE `downtime_host_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `downtime_host_history` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `downtime_service_history`
---
DROP TABLE IF EXISTS `downtime_service_history`;
SET @saved_cs_client = @@character_set_client;
@@ -318,18 +253,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `downtime_service_history`
---
LOCK TABLES `downtime_service_history` WRITE;
/*!40000 ALTER TABLE `downtime_service_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `downtime_service_history` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `events`
---
DROP TABLE IF EXISTS `events`;
SET @saved_cs_client = @@character_set_client;
@@ -351,18 +280,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `events`
---
LOCK TABLES `events` WRITE;
/*!40000 ALTER TABLE `events` DISABLE KEYS */;
/*!40000 ALTER TABLE `events` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `hosts`
---
DROP TABLE IF EXISTS `hosts`;
SET @saved_cs_client = @@character_set_client;
@@ -394,19 +317,13 @@
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `hosts`
---
LOCK TABLES `hosts` WRITE;
/*!40000 ALTER TABLE `hosts` DISABLE KEYS */;
-INSERT INTO `hosts` VALUES (1,'deletedhost','Host that has been deleted before storing into datawarehouse',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1289232758,NULL,1,1);
+INSERT INTO `hosts` VALUES (1,'deletedhost','Host that has been deleted before storing into datawarehouse',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,1289233280,NULL,1,1);
/*!40000 ALTER TABLE `hosts` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `locks`
---
DROP TABLE IF EXISTS `locks`;
SET @saved_cs_client = @@character_set_client;
@@ -418,9 +335,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `locks`
---
LOCK TABLES `locks` WRITE;
/*!40000 ALTER TABLE `locks` DISABLE KEYS */;
@@ -428,9 +342,6 @@
/*!40000 ALTER TABLE `locks` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `metadata`
---
DROP TABLE IF EXISTS `metadata`;
SET @saved_cs_client = @@character_set_client;
@@ -442,9 +353,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `metadata`
---
LOCK TABLES `metadata` WRITE;
/*!40000 ALTER TABLE `metadata` DISABLE KEYS */;
@@ -452,9 +360,6 @@
/*!40000 ALTER TABLE `metadata` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `notification_host_history`
---
DROP TABLE IF EXISTS `notification_host_history`;
SET @saved_cs_client = @@character_set_client;
@@ -474,18 +379,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `notification_host_history`
---
LOCK TABLES `notification_host_history` WRITE;
/*!40000 ALTER TABLE `notification_host_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_host_history` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `notification_service_history`
---
DROP TABLE IF EXISTS `notification_service_history`;
SET @saved_cs_client = @@character_set_client;
@@ -505,18 +404,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `notification_service_history`
---
LOCK TABLES `notification_service_history` WRITE;
/*!40000 ALTER TABLE `notification_service_history` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_service_history` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `performance_data`
---
DROP TABLE IF EXISTS `performance_data`;
SET @saved_cs_client = @@character_set_client;
@@ -531,18 +424,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=1000000000;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `performance_data`
---
LOCK TABLES `performance_data` WRITE;
/*!40000 ALTER TABLE `performance_data` DISABLE KEYS */;
/*!40000 ALTER TABLE `performance_data` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `performance_hourly_summary`
---
DROP TABLE IF EXISTS `performance_hourly_summary`;
SET @saved_cs_client = @@character_set_client;
@@ -559,23 +446,16 @@
`first` double NOT NULL,
`sum` double NOT NULL,
KEY `start_datetime` (`start_datetime`),
- KEY `performance_label` (`performance_label`),
- CONSTRAINT `performance_hourly_summary_performance_label_fk` FOREIGN KEY (`performance_label`) REFERENCES `performance_labels` (`id`)
+ KEY `performance_label` (`performance_label`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `performance_hourly_summary`
---
LOCK TABLES `performance_hourly_summary` WRITE;
/*!40000 ALTER TABLE `performance_hourly_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `performance_hourly_summary` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `performance_labels`
---
DROP TABLE IF EXISTS `performance_labels`;
SET @saved_cs_client = @@character_set_client;
@@ -594,9 +474,6 @@
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `performance_labels`
---
LOCK TABLES `performance_labels` WRITE;
/*!40000 ALTER TABLE `performance_labels` DISABLE KEYS */;
@@ -604,9 +481,6 @@
/*!40000 ALTER TABLE `performance_labels` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `report_comments`
---
DROP TABLE IF EXISTS `report_comments`;
SET @saved_cs_client = @@character_set_client;
@@ -618,18 +492,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `report_comments`
---
LOCK TABLES `report_comments` WRITE;
/*!40000 ALTER TABLE `report_comments` DISABLE KEYS */;
/*!40000 ALTER TABLE `report_comments` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `reports`
---
DROP TABLE IF EXISTS `reports`;
SET @saved_cs_client = @@character_set_client;
@@ -646,18 +514,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `reports`
---
LOCK TABLES `reports` WRITE;
/*!40000 ALTER TABLE `reports` DISABLE KEYS */;
/*!40000 ALTER TABLE `reports` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `schema_version`
---
DROP TABLE IF EXISTS `schema_version`;
SET @saved_cs_client = @@character_set_client;
@@ -668,19 +530,19 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `schema_version`
---
LOCK TABLES `schema_version` WRITE;
/*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
-INSERT INTO `schema_version` VALUES ('2.9','5'),('2.10','3'),('2.12','4'),('3.0','4'),('3.3','1'),('3.7','1'),('3.9','3');
+INSERT INTO `schema_version` VALUES ('2.9','5');
+INSERT INTO `schema_version` VALUES ('2.10','3');
+INSERT INTO `schema_version` VALUES ('2.12','4');
+INSERT INTO `schema_version` VALUES ('3.0','4');
+INSERT INTO `schema_version` VALUES ('3.3','1');
+INSERT INTO `schema_version` VALUES ('3.7','1');
+INSERT INTO `schema_version` VALUES ('3.9','3');
/*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `service_availability_hourly_summary`
---
DROP TABLE IF EXISTS `service_availability_hourly_summary`;
SET @saved_cs_client = @@character_set_client;
@@ -708,18 +570,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `service_availability_hourly_summary`
---
LOCK TABLES `service_availability_hourly_summary` WRITE;
/*!40000 ALTER TABLE `service_availability_hourly_summary` DISABLE KEYS */;
/*!40000 ALTER TABLE `service_availability_hourly_summary` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `service_outages`
---
DROP TABLE IF EXISTS `service_outages`;
SET @saved_cs_client = @@character_set_client;
@@ -746,18 +602,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `service_outages`
---
LOCK TABLES `service_outages` WRITE;
/*!40000 ALTER TABLE `service_outages` DISABLE KEYS */;
/*!40000 ALTER TABLE `service_outages` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `service_saved_state`
---
DROP TABLE IF EXISTS `service_saved_state`;
SET @saved_cs_client = @@character_set_client;
@@ -774,18 +624,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `service_saved_state`
---
LOCK TABLES `service_saved_state` WRITE;
/*!40000 ALTER TABLE `service_saved_state` DISABLE KEYS */;
/*!40000 ALTER TABLE `service_saved_state` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `servicecheck_results`
---
DROP TABLE IF EXISTS `servicecheck_results`;
SET @saved_cs_client = @@character_set_client;
@@ -805,18 +649,12 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1 MAX_ROWS=1000000000;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `servicecheck_results`
---
LOCK TABLES `servicecheck_results` WRITE;
/*!40000 ALTER TABLE `servicecheck_results` DISABLE KEYS */;
/*!40000 ALTER TABLE `servicecheck_results` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `servicechecks`
---
DROP TABLE IF EXISTS `servicechecks`;
SET @saved_cs_client = @@character_set_client;
@@ -841,19 +679,13 @@
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `servicechecks`
---
LOCK TABLES `servicechecks` WRITE;
/*!40000 ALTER TABLE `servicechecks` DISABLE KEYS */;
-INSERT INTO `servicechecks` VALUES (1,'','deletedservicecheck',1,0,'Servicecheck that has been deleted before storing into datawarehouse',NULL,NULL,1289232759,NULL,1);
+INSERT INTO `servicechecks` VALUES (1,'','deletedservicecheck',1,0,'Servicecheck that has been deleted before storing into datawarehouse',NULL,NULL,1289233280,NULL,1);
/*!40000 ALTER TABLE `servicechecks` ENABLE KEYS */;
UNLOCK TABLES;
---
--- Table structure for table `state_history`
---
DROP TABLE IF EXISTS `state_history`;
SET @saved_cs_client = @@character_set_client;
@@ -873,9 +705,6 @@
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;
---
--- Dumping data for table `state_history`
---
LOCK TABLES `state_history` WRITE;
/*!40000 ALTER TABLE `state_history` DISABLE KEYS */;
@@ -891,4 +720,3 @@
/*!40101 SET collation_connecti...@old_collation_connection */;
/*!40111 SET sql_not...@old_sql_notes */;
--- Dump completed on 2010-11-08 16:12:52
