--
...
-- ------------------------------------------------------
...
-- 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