-- -- ------------------------------------------------------ -- Edit this. Replace ???? -- -- -- Database name -- -- SELECT @SC3DB:='????'; -- -- Event parameters publicID -- The publicID must be the same in the setting.xml -- -- SELECT @SC3DBParameters:='smi:igf.edu.pl/????#eventParameters'; -- -- End of definitions -- ------------------------------------------------------ -- MySQL dump 10.13 Distrib 5.5.44, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: SC3DB -- ------------------------------------------------------ -- Server version 5.5.44-0ubuntu0.14.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!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: `SC3DB` -- CREATE DATABASE IF NOT EXISTS @SC3DB /*!40100 DEFAULT CHARACTER SET latin1 */; USE @SC3DB; -- -- Table structure for table `Amplitude` -- DROP TABLE IF EXISTS `Amplitude`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Amplitude` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `type` char(16) COLLATE utf8_bin DEFAULT NULL, `amplitude_value` double DEFAULT NULL, `amplitude_uncertainty` double unsigned DEFAULT NULL, `amplitude_lowerUncertainty` double unsigned DEFAULT NULL, `amplitude_upperUncertainty` double unsigned DEFAULT NULL, `amplitude_confidenceLevel` double unsigned DEFAULT NULL, `amplitude_used` tinyint(1) NOT NULL DEFAULT '0', `timeWindow_reference` datetime DEFAULT NULL, `timeWindow_reference_ms` int(11) DEFAULT NULL, `timeWindow_begin` double DEFAULT NULL, `timeWindow_end` double DEFAULT NULL, `timeWindow_used` tinyint(1) NOT NULL DEFAULT '0', `period_value` double DEFAULT NULL, `period_uncertainty` double unsigned DEFAULT NULL, `period_lowerUncertainty` double unsigned DEFAULT NULL, `period_upperUncertainty` double unsigned DEFAULT NULL, `period_confidenceLevel` double unsigned DEFAULT NULL, `period_used` tinyint(1) NOT NULL DEFAULT '0', `snr` double DEFAULT NULL, `unit` varchar(255) COLLATE utf8_bin DEFAULT NULL, `pickID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_networkCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_stationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_locationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_channelCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_resourceURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_used` tinyint(1) NOT NULL DEFAULT '0', `filterID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `scalingTime_value` datetime DEFAULT NULL, `scalingTime_value_ms` int(11) DEFAULT NULL, `scalingTime_uncertainty` double unsigned DEFAULT NULL, `scalingTime_lowerUncertainty` double unsigned DEFAULT NULL, `scalingTime_upperUncertainty` double unsigned DEFAULT NULL, `scalingTime_confidenceLevel` double unsigned DEFAULT NULL, `scalingTime_used` tinyint(1) NOT NULL DEFAULT '0', `magnitudeHint` char(16) COLLATE utf8_bin DEFAULT NULL, `category` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `pickID` (`pickID`), KEY `parentID` (`parentID`), CONSTRAINT `Amplitude_ibfk_1` FOREIGN KEY (`pickID`) REFERENCES `Pick` (`publicID`) ON DELETE SET NULL, CONSTRAINT `Amplitude_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `AmplitudeReference` -- DROP TABLE IF EXISTS `AmplitudeReference`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `AmplitudeReference` ( `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `referenceID` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`parentID`,`referenceID`), KEY `referenceID` (`referenceID`), KEY `parentID` (`parentID`), CONSTRAINT `AmplitudeReference_ibfk_1` FOREIGN KEY (`referenceID`) REFERENCES `Amplitude` (`publicID`) ON DELETE CASCADE, CONSTRAINT `AmplitudeReference_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `StationMagnitude` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Arrival` -- DROP TABLE IF EXISTS `Arrival`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Arrival` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `pickID` varchar(255) COLLATE utf8_bin NOT NULL, `phase_code` char(32) COLLATE utf8_bin NOT NULL, `timeCorrection` double DEFAULT NULL, `azimuth` double DEFAULT NULL, `distance` double unsigned DEFAULT NULL, `takeOffAngle` double DEFAULT NULL, `timeResidual` double DEFAULT NULL, `horizontalSlownessResidual` double DEFAULT NULL, `backazimuthResidual` double DEFAULT NULL, `timeUsed` tinyint(1) DEFAULT NULL, `horizontalSlownessUsed` tinyint(1) DEFAULT NULL, `backazimuthUsed` tinyint(1) DEFAULT NULL, `weight` double unsigned DEFAULT NULL, `earthModelID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `preliminary` tinyint(1) DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', `timeWeight` double DEFAULT NULL, `takeoffAngle_value` double DEFAULT NULL, `takeoffAngle_uncertainty` double unsigned DEFAULT NULL, `takeoffAngle_lowerUncertainty` double unsigned DEFAULT NULL, `takeoffAngle_upperUncertainty` double unsigned DEFAULT NULL, `takeoffAngle_confidenceLevel` double unsigned DEFAULT NULL, `takeoffAngle_used` tinyint(1) NOT NULL DEFAULT '0', `incidenceAngle_value` double DEFAULT NULL, `incidenceAngle_uncertainty` double unsigned DEFAULT NULL, `incidenceAngle_lowerUncertainty` double unsigned DEFAULT NULL, `incidenceAngle_upperUncertainty` double unsigned DEFAULT NULL, `incidenceAngle_confidenceLevel` double unsigned DEFAULT NULL, `incidenceAngle_used` tinyint(1) NOT NULL DEFAULT '0', `backazimuthWeight` double unsigned DEFAULT NULL, `horizontalSlownessWeight` double unsigned DEFAULT NULL, PRIMARY KEY (`publicID`), UNIQUE KEY `_parentID_pickID` (`parentID`,`pickID`), KEY `pickID` (`pickID`), KEY `parentID` (`parentID`), CONSTRAINT `Arrival_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Origin` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Comment` -- DROP TABLE IF EXISTS `Comment`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Comment` ( `_oid` int(11) NOT NULL AUTO_INCREMENT, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `text` blob NOT NULL, `id` varchar(255) COLLATE utf8_bin DEFAULT NULL, `id_used` tinyint(1) NOT NULL DEFAULT '0', `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`_oid`), KEY `parentID` (`parentID`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `CompositeTime` -- DROP TABLE IF EXISTS `CompositeTime`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `CompositeTime` ( `_oid` int(11) NOT NULL AUTO_INCREMENT, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `year_value` int(11) DEFAULT NULL, `year_uncertainty` int(10) unsigned DEFAULT NULL, `year_lowerUncertainty` int(10) unsigned DEFAULT NULL, `year_upperUncertainty` int(10) unsigned DEFAULT NULL, `year_confidenceLevel` double unsigned DEFAULT NULL, `year_used` tinyint(1) NOT NULL DEFAULT '0', `month_value` int(11) DEFAULT NULL, `month_uncertainty` int(10) unsigned DEFAULT NULL, `month_lowerUncertainty` int(10) unsigned DEFAULT NULL, `month_upperUncertainty` int(10) unsigned DEFAULT NULL, `month_confidenceLevel` double unsigned DEFAULT NULL, `month_used` tinyint(1) NOT NULL DEFAULT '0', `day_value` int(11) DEFAULT NULL, `day_uncertainty` int(10) unsigned DEFAULT NULL, `day_lowerUncertainty` int(10) unsigned DEFAULT NULL, `day_upperUncertainty` int(10) unsigned DEFAULT NULL, `day_confidenceLevel` double unsigned DEFAULT NULL, `day_used` tinyint(1) NOT NULL DEFAULT '0', `hour_value` int(11) DEFAULT NULL, `hour_uncertainty` int(10) unsigned DEFAULT NULL, `hour_lowerUncertainty` int(10) unsigned DEFAULT NULL, `hour_upperUncertainty` int(10) unsigned DEFAULT NULL, `hour_confidenceLevel` double unsigned DEFAULT NULL, `hour_used` tinyint(1) NOT NULL DEFAULT '0', `minute_value` int(11) DEFAULT NULL, `minute_uncertainty` int(10) unsigned DEFAULT NULL, `minute_lowerUncertainty` int(10) unsigned DEFAULT NULL, `minute_upperUncertainty` int(10) unsigned DEFAULT NULL, `minute_confidenceLevel` double unsigned DEFAULT NULL, `minute_used` tinyint(1) NOT NULL DEFAULT '0', `second_value` double DEFAULT NULL, `second_uncertainty` double unsigned DEFAULT NULL, `second_lowerUncertainty` double unsigned DEFAULT NULL, `second_upperUncertainty` double unsigned DEFAULT NULL, `second_confidenceLevel` double unsigned DEFAULT NULL, `second_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`_oid`), KEY `parentID` (`parentID`), CONSTRAINT `CompositeTime_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Origin` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `DataUsed` -- DROP TABLE IF EXISTS `DataUsed`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `DataUsed` ( `_oid` int(11) NOT NULL AUTO_INCREMENT, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `waveType` varchar(64) COLLATE utf8_bin NOT NULL, `stationCount` int(10) unsigned DEFAULT NULL, `componentCount` int(10) unsigned DEFAULT NULL, `shortestPeriod` double DEFAULT NULL, `longestPeriod` double DEFAULT NULL, PRIMARY KEY (`_oid`), KEY `parentID` (`parentID`), CONSTRAINT `DataUsed_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `MomentTensor` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Event` -- DROP TABLE IF EXISTS `Event`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Event` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `parentID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `preferredOriginID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `preferredMagnitudeID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `preferredFocalMechanismID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `type` varchar(64) COLLATE utf8_bin DEFAULT NULL, `typeCertainty` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', `_author` varchar(45) COLLATE utf8_bin NOT NULL DEFAULT '', PRIMARY KEY (`publicID`), KEY `preferredOriginID` (`preferredOriginID`), KEY `preferredMagnitudeID` (`preferredMagnitudeID`), KEY `preferredFocalMechanismID` (`preferredFocalMechanismID`), KEY `parentID` (`parentID`), CONSTRAINT `Event_ibfk_1` FOREIGN KEY (`parentID`) REFERENCES `EventParameters` (`publicID`) ON DELETE SET NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; /*!50003 SET @saved_cs_client = @@character_set_client */ ; /*!50003 SET @saved_cs_results = @@character_set_results */ ; /*!50003 SET @saved_col_connection = @@collation_connection */ ; /*!50003 SET character_set_client = utf8 */ ; /*!50003 SET character_set_results = utf8 */ ; /*!50003 SET collation_connection = utf8_general_ci */ ; /*!50003 SET @saved_sql_mode = @@sql_mode */ ; /*!50003 SET sql_mode = '' */ ; DELIMITER ;; /*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 trigger Event_author before insert on Event for each row set new._author=user() */;; DELIMITER ; /*!50003 SET sql_mode = @saved_sql_mode */ ; /*!50003 SET character_set_client = @saved_cs_client */ ; /*!50003 SET character_set_results = @saved_cs_results */ ; /*!50003 SET collation_connection = @saved_col_connection */ ; -- -- Table structure for table `EventDescription` -- DROP TABLE IF EXISTS `EventDescription`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EventDescription` ( `_oid` int(11) NOT NULL AUTO_INCREMENT, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `text` varchar(128) COLLATE utf8_bin NOT NULL, `type` varchar(64) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`_oid`), UNIQUE KEY `parentID_type` (`parentID`,`type`), KEY `parentID` (`parentID`), CONSTRAINT `EventDescription_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `EventParameters` -- DROP TABLE IF EXISTS `EventParameters`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `EventParameters` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `description` varchar(1023) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `EventParameters` -- LOCK TABLES `EventParameters` WRITE; /*!40000 ALTER TABLE `EventParameters` DISABLE KEYS */; INSERT INTO `EventParameters` VALUES ('@SC3DBParameters','2017-12-07 13:45:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0); /*!40000 ALTER TABLE `EventParameters` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `FocalMechanism` -- DROP TABLE IF EXISTS `FocalMechanism`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `FocalMechanism` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `triggeringOriginID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `nodalPlanes_nodalPlane1_strike_value` double DEFAULT NULL, `nodalPlanes_nodalPlane1_strike_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_strike_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_strike_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_strike_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_dip_value` double DEFAULT NULL, `nodalPlanes_nodalPlane1_dip_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_dip_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_dip_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_dip_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_rake_value` double DEFAULT NULL, `nodalPlanes_nodalPlane1_rake_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_rake_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_rake_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_rake_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane1_used` tinyint(1) NOT NULL DEFAULT '0', `nodalPlanes_nodalPlane2_strike_value` double DEFAULT NULL, `nodalPlanes_nodalPlane2_strike_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_strike_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_strike_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_strike_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_dip_value` double DEFAULT NULL, `nodalPlanes_nodalPlane2_dip_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_dip_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_dip_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_dip_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_rake_value` double DEFAULT NULL, `nodalPlanes_nodalPlane2_rake_uncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_rake_lowerUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_rake_upperUncertainty` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_rake_confidenceLevel` double unsigned DEFAULT NULL, `nodalPlanes_nodalPlane2_used` tinyint(1) NOT NULL DEFAULT '0', `nodalPlanes_preferredPlane` int(11) DEFAULT NULL, `nodalPlanes_used` tinyint(1) NOT NULL DEFAULT '0', `principalAxes_tAxis_azimuth_value` double DEFAULT NULL, `principalAxes_tAxis_azimuth_uncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_azimuth_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_azimuth_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_azimuth_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_tAxis_plunge_value` double DEFAULT NULL, `principalAxes_tAxis_plunge_uncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_plunge_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_plunge_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_plunge_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_tAxis_length_value` double DEFAULT NULL, `principalAxes_tAxis_length_uncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_length_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_length_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_tAxis_length_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_pAxis_azimuth_value` double DEFAULT NULL, `principalAxes_pAxis_azimuth_uncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_azimuth_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_azimuth_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_azimuth_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_pAxis_plunge_value` double DEFAULT NULL, `principalAxes_pAxis_plunge_uncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_plunge_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_plunge_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_plunge_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_pAxis_length_value` double DEFAULT NULL, `principalAxes_pAxis_length_uncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_length_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_length_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_pAxis_length_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_nAxis_azimuth_value` double DEFAULT NULL, `principalAxes_nAxis_azimuth_uncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_azimuth_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_azimuth_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_azimuth_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_nAxis_plunge_value` double DEFAULT NULL, `principalAxes_nAxis_plunge_uncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_plunge_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_plunge_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_plunge_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_nAxis_length_value` double DEFAULT NULL, `principalAxes_nAxis_length_uncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_length_lowerUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_length_upperUncertainty` double unsigned DEFAULT NULL, `principalAxes_nAxis_length_confidenceLevel` double unsigned DEFAULT NULL, `principalAxes_nAxis_used` tinyint(1) NOT NULL DEFAULT '0', `principalAxes_used` tinyint(1) NOT NULL DEFAULT '0', `azimuthalGap` double unsigned DEFAULT NULL, `stationPolarityCount` int(10) unsigned DEFAULT NULL, `misfit` double unsigned DEFAULT NULL, `stationDistributionRatio` double unsigned DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `triggeringOriginID` (`triggeringOriginID`), KEY `parentID` (`parentID`), CONSTRAINT `FocalMechanism_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Magnitude` -- DROP TABLE IF EXISTS `Magnitude`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Magnitude` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `magnitude_value` double NOT NULL, `magnitude_uncertainty` double unsigned DEFAULT NULL, `magnitude_lowerUncertainty` double unsigned DEFAULT NULL, `magnitude_upperUncertainty` double unsigned DEFAULT NULL, `magnitude_confidenceLevel` double unsigned DEFAULT NULL, `type` char(16) COLLATE utf8_bin DEFAULT NULL, `originID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `stationCount` int(10) unsigned DEFAULT NULL, `azimuthalGap` double unsigned DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `parentID` (`parentID`), CONSTRAINT `Magnitude_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `MomentTensor` -- DROP TABLE IF EXISTS `MomentTensor`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `MomentTensor` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `derivedOriginID` varchar(255) COLLATE utf8_bin NOT NULL, `momentMagnitudeID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `scalarMoment_value` double DEFAULT NULL, `scalarMoment_uncertainty` double unsigned DEFAULT NULL, `scalarMoment_lowerUncertainty` double unsigned DEFAULT NULL, `scalarMoment_upperUncertainty` double unsigned DEFAULT NULL, `scalarMoment_confidenceLevel` double unsigned DEFAULT NULL, `scalarMoment_used` tinyint(1) NOT NULL DEFAULT '0', `tensor_Mrr_value` double DEFAULT NULL, `tensor_Mrr_uncertainty` double unsigned DEFAULT NULL, `tensor_Mrr_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mrr_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mrr_confidenceLevel` double unsigned DEFAULT NULL, `tensor_Mtt_value` double DEFAULT NULL, `tensor_Mtt_uncertainty` double unsigned DEFAULT NULL, `tensor_Mtt_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mtt_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mtt_confidenceLevel` double unsigned DEFAULT NULL, `tensor_Mpp_value` double DEFAULT NULL, `tensor_Mpp_uncertainty` double unsigned DEFAULT NULL, `tensor_Mpp_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mpp_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mpp_confidenceLevel` double unsigned DEFAULT NULL, `tensor_Mrt_value` double DEFAULT NULL, `tensor_Mrt_uncertainty` double unsigned DEFAULT NULL, `tensor_Mrt_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mrt_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mrt_confidenceLevel` double unsigned DEFAULT NULL, `tensor_Mrp_value` double DEFAULT NULL, `tensor_Mrp_uncertainty` double unsigned DEFAULT NULL, `tensor_Mrp_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mrp_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mrp_confidenceLevel` double unsigned DEFAULT NULL, `tensor_Mtp_value` double DEFAULT NULL, `tensor_Mtp_uncertainty` double unsigned DEFAULT NULL, `tensor_Mtp_lowerUncertainty` double unsigned DEFAULT NULL, `tensor_Mtp_upperUncertainty` double unsigned DEFAULT NULL, `tensor_Mtp_confidenceLevel` double unsigned DEFAULT NULL, `tensor_used` tinyint(1) NOT NULL DEFAULT '0', `variance` double DEFAULT NULL, `varianceReduction` double DEFAULT NULL, `doubleCouple` double DEFAULT NULL, `clvd` double DEFAULT NULL, `iso` double DEFAULT NULL, `greensFunctionID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `filterID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `sourceTimeFunction_type` varchar(64) COLLATE utf8_bin DEFAULT NULL, `sourceTimeFunction_duration` double DEFAULT NULL, `sourceTimeFunction_riseTime` double DEFAULT NULL, `sourceTimeFunction_decayTime` double DEFAULT NULL, `sourceTimeFunction_used` tinyint(1) NOT NULL DEFAULT '0', `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `inversionType` varchar(64) COLLATE utf8_bin DEFAULT NULL, `category` varchar(64) COLLATE utf8_bin DEFAULT NULL, `method` varchar(64) COLLATE utf8_bin DEFAULT NULL, `status` varchar(64) COLLATE utf8_bin DEFAULT NULL, `cmtName` varchar(80) COLLATE utf8_bin DEFAULT NULL, `cmtVersion` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `derivedOriginID` (`derivedOriginID`), KEY `parentID` (`parentID`), CONSTRAINT `MomentTensor_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `FocalMechanism` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Origin` -- DROP TABLE IF EXISTS `Origin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Origin` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `time_value` datetime NOT NULL, `time_value_ms` int(11) NOT NULL, `time_uncertainty` double unsigned DEFAULT NULL, `time_lowerUncertainty` double unsigned DEFAULT NULL, `time_upperUncertainty` double unsigned DEFAULT NULL, `time_confidenceLevel` double unsigned DEFAULT NULL, `latitude_value` double NOT NULL, `latitude_uncertainty` double unsigned DEFAULT NULL, `latitude_lowerUncertainty` double unsigned DEFAULT NULL, `latitude_upperUncertainty` double unsigned DEFAULT NULL, `latitude_confidenceLevel` double unsigned DEFAULT NULL, `longitude_value` double NOT NULL, `longitude_uncertainty` double unsigned DEFAULT NULL, `longitude_lowerUncertainty` double unsigned DEFAULT NULL, `longitude_upperUncertainty` double unsigned DEFAULT NULL, `longitude_confidenceLevel` double unsigned DEFAULT NULL, `depth_value` double DEFAULT NULL, `depth_uncertainty` double unsigned DEFAULT NULL, `depth_lowerUncertainty` double unsigned DEFAULT NULL, `depth_upperUncertainty` double unsigned DEFAULT NULL, `depth_confidenceLevel` double unsigned DEFAULT NULL, `depth_used` tinyint(1) NOT NULL DEFAULT '0', `depthType` varchar(64) COLLATE utf8_bin DEFAULT NULL, `timeFixed` tinyint(1) DEFAULT NULL, `epicenterFixed` tinyint(1) DEFAULT NULL, `region` varchar(255) COLLATE utf8_bin DEFAULT NULL, `referenceSystemID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `earthModelID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `quality_associatedPhaseCount` int(10) unsigned DEFAULT NULL, `quality_usedPhaseCount` int(10) unsigned DEFAULT NULL, `quality_associatedStationCount` int(10) unsigned DEFAULT NULL, `quality_usedStationCount` int(10) unsigned DEFAULT NULL, `quality_depthPhaseCount` int(10) unsigned DEFAULT NULL, `quality_standardError` double unsigned DEFAULT NULL, `quality_azimuthalGap` double unsigned DEFAULT NULL, `quality_secondaryAzimuthalGap` double unsigned DEFAULT NULL, `quality_groundTruthLevel` varchar(16) COLLATE utf8_bin DEFAULT NULL, `quality_maximumDistance` double unsigned DEFAULT NULL, `quality_minimumDistance` double unsigned DEFAULT NULL, `quality_medianDistance` double unsigned DEFAULT NULL, `quality_used` tinyint(1) NOT NULL DEFAULT '0', `uncertainty_horizontalUncertainty` double unsigned DEFAULT NULL, `uncertainty_minHorizontalUncertainty` double unsigned DEFAULT NULL, `uncertainty_maxHorizontalUncertainty` double unsigned DEFAULT NULL, `uncertainty_azimuthMaxHorizontalUncertainty` double unsigned DEFAULT NULL, `uncertainty_confidenceEllipsoid_semiMajorAxisLength` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_semiMinorAxisLength` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_semiIntermediateAxisLength` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_majorAxisPlunge` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_majorAxisAzimuth` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_majorAxisRotation` double DEFAULT NULL, `uncertainty_confidenceEllipsoid_used` tinyint(1) NOT NULL DEFAULT '0', `uncertainty_preferredDescription` varchar(64) COLLATE utf8_bin DEFAULT NULL, `uncertainty_used` tinyint(1) NOT NULL DEFAULT '0', `type` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `time_value` (`time_value`), KEY `time_value_ms` (`time_value_ms`), KEY `publicID` (`publicID`), KEY `Origin_ibfk_2` (`parentID`), CONSTRAINT `Origin_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `Pick` -- DROP TABLE IF EXISTS `Pick`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `Pick` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `time_value` datetime NOT NULL, `time_value_ms` int(11) NOT NULL, `time_uncertainty` double unsigned DEFAULT NULL, `time_lowerUncertainty` double unsigned DEFAULT NULL, `time_upperUncertainty` double unsigned DEFAULT NULL, `time_confidenceLevel` double unsigned DEFAULT NULL, `waveformID_networkCode` char(8) COLLATE utf8_bin NOT NULL, `waveformID_stationCode` char(8) COLLATE utf8_bin NOT NULL, `waveformID_locationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_channelCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_resourceURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `filterID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `horizontalSlowness_value` double DEFAULT NULL, `horizontalSlowness_uncertainty` double unsigned DEFAULT NULL, `horizontalSlowness_lowerUncertainty` double unsigned DEFAULT NULL, `horizontalSlowness_upperUncertainty` double unsigned DEFAULT NULL, `horizontalSlowness_confidenceLevel` double unsigned DEFAULT NULL, `horizontalSlowness_used` tinyint(1) NOT NULL DEFAULT '0', `backazimuth_value` double DEFAULT NULL, `backazimuth_uncertainty` double unsigned DEFAULT NULL, `backazimuth_lowerUncertainty` double unsigned DEFAULT NULL, `backazimuth_upperUncertainty` double unsigned DEFAULT NULL, `backazimuth_confidenceLevel` double unsigned DEFAULT NULL, `backazimuth_used` tinyint(1) NOT NULL DEFAULT '0', `incidenceAngle_value` double DEFAULT NULL, `incidenceAngle_uncertainty` double unsigned DEFAULT NULL, `incidenceAngle_lowerUncertainty` double unsigned DEFAULT NULL, `incidenceAngle_upperUncertainty` double unsigned DEFAULT NULL, `incidenceAngle_confidenceLevel` double unsigned DEFAULT NULL, `incidenceAngle_used` tinyint(1) NOT NULL DEFAULT '0', `slownessMethodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `onset` varchar(64) COLLATE utf8_bin DEFAULT NULL, `phaseHint_code` char(32) COLLATE utf8_bin DEFAULT NULL, `phaseHint_used` tinyint(1) NOT NULL DEFAULT '0', `polarity` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `time_value` (`time_value`), KEY `time_value_ms` (`time_value_ms`), KEY `parentID` (`parentID`), CONSTRAINT `Pick_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SpectralParameter` -- DROP TABLE IF EXISTS `SpectralParameter`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SpectralParameter` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '', `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `type` char(16) COLLATE utf8_bin DEFAULT NULL, `spectralLevel_value` double DEFAULT NULL, `spectralLevel_uncertainty` double unsigned DEFAULT NULL, `spectralLevel_lowerUncertainty` double unsigned DEFAULT NULL, `spectralLevel_upperUncertainty` double unsigned DEFAULT NULL, `spectralLevel_confidenceLevel` double unsigned DEFAULT NULL, `cornelFrequency1_value` double DEFAULT NULL, `cornelFrequency1_uncertainty` double unsigned DEFAULT NULL, `cornelFrequency1_lowerUncertainty` double unsigned DEFAULT NULL, `cornelFrequency1_upperUncertainty` double unsigned DEFAULT NULL, `cornelFrequency1_confidenceLevel` double unsigned DEFAULT NULL, `cornelFrequency1_used` tinyint(1) NOT NULL DEFAULT '0', `cornelFrequency2_value` double DEFAULT NULL, `cornelFrequency2_uncertainty` double unsigned DEFAULT NULL, `cornelFrequency2_lowerUncertainty` double unsigned DEFAULT NULL, `cornelFrequency2_upperUncertainty` double unsigned DEFAULT NULL, `cornelFrequency2_confidenceLevel` double unsigned DEFAULT NULL, `cornelFrequency2_used` tinyint(1) NOT NULL DEFAULT '0', `timeWindow_reference` datetime DEFAULT NULL, `timeWindow_reference_ms` int(11) DEFAULT NULL, `timeWindow_begin` double DEFAULT NULL, `timeWindow_end` double DEFAULT NULL, `timeWindow_used` tinyint(1) NOT NULL DEFAULT '0', `taperID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `period_value` double DEFAULT NULL, `period_uncertainty` double unsigned DEFAULT NULL, `period_lowerUncertainty` double unsigned DEFAULT NULL, `period_upperUncertainty` double unsigned DEFAULT NULL, `period_confidenceLevel` double unsigned DEFAULT NULL, `period_used` tinyint(1) NOT NULL DEFAULT '0', `snr` double DEFAULT NULL, `unit` varchar(255) COLLATE utf8_bin DEFAULT NULL, `pickID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_networkCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_stationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_locationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_channelCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_resourceURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_used` tinyint(1) NOT NULL DEFAULT '0', `filterID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `scalingTime_value` datetime DEFAULT NULL, `scalingTime_value_ms` int(11) DEFAULT NULL, `scalingTime_uncertainty` double unsigned DEFAULT NULL, `scalingTime_lowerUncertainty` double unsigned DEFAULT NULL, `scalingTime_upperUncertainty` double unsigned DEFAULT NULL, `scalingTime_confidenceLevel` double unsigned DEFAULT NULL, `scalingTime_used` tinyint(1) NOT NULL DEFAULT '0', `magnitudeHint` char(16) COLLATE utf8_bin DEFAULT NULL, `category` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationMode` varchar(64) COLLATE utf8_bin DEFAULT NULL, `evaluationStatus` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `pickID` (`pickID`), KEY `parentID` (`parentID`), CONSTRAINT `SpectralParameter_ibfk_1` FOREIGN KEY (`pickID`) REFERENCES `Pick` (`publicID`) ON DELETE SET NULL, CONSTRAINT `SpectralParameter_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `SpectralParameterReference` -- DROP TABLE IF EXISTS `SpectralParameterReference`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `SpectralParameterReference` ( `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `referenceID` varchar(255) COLLATE utf8_bin NOT NULL, PRIMARY KEY (`parentID`,`referenceID`), KEY `referenceID` (`referenceID`), KEY `parentID` (`parentID`), CONSTRAINT `SpectralParameterReference_ibfk_1` FOREIGN KEY (`referenceID`) REFERENCES `SpectralParameter` (`publicID`) ON DELETE CASCADE, CONSTRAINT `SpectralParameterReference_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `StationMagnitude` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `StationMagnitude` -- DROP TABLE IF EXISTS `StationMagnitude`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `StationMagnitude` ( `publicID` varchar(255) COLLATE utf8_bin NOT NULL, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `originID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `magnitude_value` double NOT NULL, `magnitude_uncertainty` double unsigned DEFAULT NULL, `magnitude_lowerUncertainty` double unsigned DEFAULT NULL, `magnitude_upperUncertainty` double unsigned DEFAULT NULL, `magnitude_confidenceLevel` double unsigned DEFAULT NULL, `type` char(16) COLLATE utf8_bin DEFAULT NULL, `methodID` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_networkCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_stationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_locationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_channelCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_resourceURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `waveformID_used` tinyint(1) NOT NULL DEFAULT '0', `creationInfo_agencyID` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_agencyURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_author` varchar(128) COLLATE utf8_bin DEFAULT NULL, `creationInfo_authorURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, `creationInfo_creationTime` datetime DEFAULT NULL, `creationInfo_creationTime_ms` int(11) DEFAULT NULL, `creationInfo_modificationTime` datetime DEFAULT NULL, `creationInfo_modificationTime_ms` int(11) DEFAULT NULL, `creationInfo_version` varchar(64) COLLATE utf8_bin DEFAULT NULL, `creationInfo_used` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`publicID`), KEY `parentID` (`parentID`), CONSTRAINT `StationMagnitude_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Event` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `StationMagnitudeContribution` -- DROP TABLE IF EXISTS `StationMagnitudeContribution`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `StationMagnitudeContribution` ( `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `stationMagnitudeID` varchar(255) COLLATE utf8_bin NOT NULL, `residual` double DEFAULT NULL, `weight` double unsigned DEFAULT NULL, PRIMARY KEY (`parentID`,`stationMagnitudeID`), KEY `StationMagnitudeContribution_ibfk_1` (`stationMagnitudeID`), CONSTRAINT `StationMagnitudeContribution_ibfk_1` FOREIGN KEY (`stationMagnitudeID`) REFERENCES `StationMagnitude` (`publicID`) ON DELETE CASCADE, CONSTRAINT `StationMagnitudeContribution_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `Magnitude` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `WaveformReference` -- DROP TABLE IF EXISTS `WaveformReference`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `WaveformReference` ( `_oid` int(11) NOT NULL AUTO_INCREMENT, `parentID` varchar(255) COLLATE utf8_bin NOT NULL, `_last_modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `waveformID_networkCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_stationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_locationCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_channelCode` char(8) COLLATE utf8_bin DEFAULT NULL, `waveformID_resourceURI` varchar(255) COLLATE utf8_bin DEFAULT NULL, PRIMARY KEY (`_oid`), KEY `parentID` (`parentID`), CONSTRAINT `WaveformReference_ibfk_2` FOREIGN KEY (`parentID`) REFERENCES `FocalMechanism` (`publicID`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_bin; /*!40101 SET character_set_client = @saved_cs_client */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Definision of SC3DB 2020.01.28