DROP TABLE IF EXISTS FilterParameter; DROP TABLE IF EXISTS SimpleFilter; DROP TABLE IF EXISTS SimpleFilterChainMember; DROP TABLE IF EXISTS PeakMotion; DROP TABLE IF EXISTS Record; DROP TABLE IF EXISTS EventRecordReference; DROP TABLE IF EXISTS Rupture; DROP TABLE IF EXISTS StrongOriginDescription; INSERT INTO Object(_oid) VALUES (NULL); INSERT INTO PublicObject(_oid,publicID) VALUES (LAST_INSERT_ID(),'StrongMotionParameters'); CREATE TABLE FilterParameter ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, value_value DOUBLE NOT NULL, value_uncertainty DOUBLE UNSIGNED, value_lowerUncertainty DOUBLE UNSIGNED, value_upperUncertainty DOUBLE UNSIGNED, value_confidenceLevel DOUBLE UNSIGNED, value_pdf_variable_content BLOB, value_pdf_probability_content BLOB, value_pdf_used TINYINT(1) NOT NULL DEFAULT '0', name VARCHAR(255) NOT NULL, PRIMARY KEY(_oid), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE SimpleFilter ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, type VARCHAR(255) NOT NULL, PRIMARY KEY(_oid), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE SimpleFilterChainMember ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, sequenceNo INT UNSIGNED NOT NULL, simpleFilterID VARCHAR(255) NOT NULL, PRIMARY KEY(_oid), INDEX(simpleFilterID), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE, UNIQUE(_parent_oid,sequenceNo) ) ENGINE=INNODB; CREATE TABLE PeakMotion ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, motion_value DOUBLE NOT NULL, motion_uncertainty DOUBLE UNSIGNED, motion_lowerUncertainty DOUBLE UNSIGNED, motion_upperUncertainty DOUBLE UNSIGNED, motion_confidenceLevel DOUBLE UNSIGNED, motion_pdf_variable_content BLOB, motion_pdf_probability_content BLOB, motion_pdf_used TINYINT(1) NOT NULL DEFAULT '0', type VARCHAR(255) NOT NULL, period DOUBLE UNSIGNED, damping DOUBLE UNSIGNED, method VARCHAR(255), atTime_value DATETIME, atTime_value_ms INTEGER, atTime_uncertainty DOUBLE UNSIGNED, atTime_lowerUncertainty DOUBLE UNSIGNED, atTime_upperUncertainty DOUBLE UNSIGNED, atTime_confidenceLevel DOUBLE UNSIGNED, atTime_pdf_variable_content BLOB, atTime_pdf_probability_content BLOB, atTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0', atTime_used TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY(_oid), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE Record ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, creationInfo_agencyID VARCHAR(64), creationInfo_agencyURI VARCHAR(255), creationInfo_author VARCHAR(128), creationInfo_authorURI VARCHAR(255), creationInfo_creationTime DATETIME, creationInfo_creationTime_ms INTEGER, creationInfo_modificationTime DATETIME, creationInfo_modificationTime_ms INTEGER, creationInfo_version VARCHAR(64), creationInfo_used TINYINT(1) NOT NULL DEFAULT '0', gainUnit CHAR(20), duration DOUBLE, startTime_value DATETIME NOT NULL, startTime_value_ms INTEGER NOT NULL, startTime_uncertainty DOUBLE UNSIGNED, startTime_lowerUncertainty DOUBLE UNSIGNED, startTime_upperUncertainty DOUBLE UNSIGNED, startTime_confidenceLevel DOUBLE UNSIGNED, startTime_pdf_variable_content BLOB, startTime_pdf_probability_content BLOB, startTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0', owner_name VARCHAR(255), owner_forename VARCHAR(255), owner_agency VARCHAR(255), owner_department VARCHAR(255), owner_address VARCHAR(255), owner_phone VARCHAR(255), owner_email VARCHAR(255), owner_used TINYINT(1) NOT NULL DEFAULT '0', resampleRateNumerator INT UNSIGNED, resampleRateDenominator INT UNSIGNED, waveformID_networkCode CHAR(8) NOT NULL, waveformID_stationCode CHAR(8) NOT NULL, waveformID_locationCode CHAR(8), waveformID_channelCode CHAR(8), waveformID_resourceURI VARCHAR(255), waveformFile_creationInfo_agencyID VARCHAR(64), waveformFile_creationInfo_agencyURI VARCHAR(255), waveformFile_creationInfo_author VARCHAR(128), waveformFile_creationInfo_authorURI VARCHAR(255), waveformFile_creationInfo_creationTime DATETIME, waveformFile_creationInfo_creationTime_ms INTEGER, waveformFile_creationInfo_modificationTime DATETIME, waveformFile_creationInfo_modificationTime_ms INTEGER, waveformFile_creationInfo_version VARCHAR(64), waveformFile_creationInfo_used TINYINT(1) NOT NULL DEFAULT '0', waveformFile_class VARCHAR(255), waveformFile_type VARCHAR(255), waveformFile_filename VARCHAR(255), waveformFile_url VARCHAR(255), waveformFile_description VARCHAR(255), waveformFile_used TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY(_oid), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE EventRecordReference ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, recordID VARCHAR(255) NOT NULL, campbellDistance_value DOUBLE, campbellDistance_uncertainty DOUBLE UNSIGNED, campbellDistance_lowerUncertainty DOUBLE UNSIGNED, campbellDistance_upperUncertainty DOUBLE UNSIGNED, campbellDistance_confidenceLevel DOUBLE UNSIGNED, campbellDistance_pdf_variable_content BLOB, campbellDistance_pdf_probability_content BLOB, campbellDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0', campbellDistance_used TINYINT(1) NOT NULL DEFAULT '0', ruptureToStationAzimuth_value DOUBLE, ruptureToStationAzimuth_uncertainty DOUBLE UNSIGNED, ruptureToStationAzimuth_lowerUncertainty DOUBLE UNSIGNED, ruptureToStationAzimuth_upperUncertainty DOUBLE UNSIGNED, ruptureToStationAzimuth_confidenceLevel DOUBLE UNSIGNED, ruptureToStationAzimuth_pdf_variable_content BLOB, ruptureToStationAzimuth_pdf_probability_content BLOB, ruptureToStationAzimuth_pdf_used TINYINT(1) NOT NULL DEFAULT '0', ruptureToStationAzimuth_used TINYINT(1) NOT NULL DEFAULT '0', ruptureAreaDistance_value DOUBLE, ruptureAreaDistance_uncertainty DOUBLE UNSIGNED, ruptureAreaDistance_lowerUncertainty DOUBLE UNSIGNED, ruptureAreaDistance_upperUncertainty DOUBLE UNSIGNED, ruptureAreaDistance_confidenceLevel DOUBLE UNSIGNED, ruptureAreaDistance_pdf_variable_content BLOB, ruptureAreaDistance_pdf_probability_content BLOB, ruptureAreaDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0', ruptureAreaDistance_used TINYINT(1) NOT NULL DEFAULT '0', JoynerBooreDistance_value DOUBLE, JoynerBooreDistance_uncertainty DOUBLE UNSIGNED, JoynerBooreDistance_lowerUncertainty DOUBLE UNSIGNED, JoynerBooreDistance_upperUncertainty DOUBLE UNSIGNED, JoynerBooreDistance_confidenceLevel DOUBLE UNSIGNED, JoynerBooreDistance_pdf_variable_content BLOB, JoynerBooreDistance_pdf_probability_content BLOB, JoynerBooreDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0', JoynerBooreDistance_used TINYINT(1) NOT NULL DEFAULT '0', closestFaultDistance_value DOUBLE, closestFaultDistance_uncertainty DOUBLE UNSIGNED, closestFaultDistance_lowerUncertainty DOUBLE UNSIGNED, closestFaultDistance_upperUncertainty DOUBLE UNSIGNED, closestFaultDistance_confidenceLevel DOUBLE UNSIGNED, closestFaultDistance_pdf_variable_content BLOB, closestFaultDistance_pdf_probability_content BLOB, closestFaultDistance_pdf_used TINYINT(1) NOT NULL DEFAULT '0', closestFaultDistance_used TINYINT(1) NOT NULL DEFAULT '0', preEventLength DOUBLE, postEventLength DOUBLE, PRIMARY KEY(_oid), INDEX(recordID), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE Rupture ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, width_value DOUBLE, width_uncertainty DOUBLE UNSIGNED, width_lowerUncertainty DOUBLE UNSIGNED, width_upperUncertainty DOUBLE UNSIGNED, width_confidenceLevel DOUBLE UNSIGNED, width_pdf_variable_content BLOB, width_pdf_probability_content BLOB, width_pdf_used TINYINT(1) NOT NULL DEFAULT '0', width_used TINYINT(1) NOT NULL DEFAULT '0', displacement_value DOUBLE, displacement_uncertainty DOUBLE UNSIGNED, displacement_lowerUncertainty DOUBLE UNSIGNED, displacement_upperUncertainty DOUBLE UNSIGNED, displacement_confidenceLevel DOUBLE UNSIGNED, displacement_pdf_variable_content BLOB, displacement_pdf_probability_content BLOB, displacement_pdf_used TINYINT(1) NOT NULL DEFAULT '0', displacement_used TINYINT(1) NOT NULL DEFAULT '0', riseTime_value DOUBLE, riseTime_uncertainty DOUBLE UNSIGNED, riseTime_lowerUncertainty DOUBLE UNSIGNED, riseTime_upperUncertainty DOUBLE UNSIGNED, riseTime_confidenceLevel DOUBLE UNSIGNED, riseTime_pdf_variable_content BLOB, riseTime_pdf_probability_content BLOB, riseTime_pdf_used TINYINT(1) NOT NULL DEFAULT '0', riseTime_used TINYINT(1) NOT NULL DEFAULT '0', vt_to_vs_value DOUBLE, vt_to_vs_uncertainty DOUBLE UNSIGNED, vt_to_vs_lowerUncertainty DOUBLE UNSIGNED, vt_to_vs_upperUncertainty DOUBLE UNSIGNED, vt_to_vs_confidenceLevel DOUBLE UNSIGNED, vt_to_vs_pdf_variable_content BLOB, vt_to_vs_pdf_probability_content BLOB, vt_to_vs_pdf_used TINYINT(1) NOT NULL DEFAULT '0', vt_to_vs_used TINYINT(1) NOT NULL DEFAULT '0', shallowAsperityDepth_value DOUBLE, shallowAsperityDepth_uncertainty DOUBLE UNSIGNED, shallowAsperityDepth_lowerUncertainty DOUBLE UNSIGNED, shallowAsperityDepth_upperUncertainty DOUBLE UNSIGNED, shallowAsperityDepth_confidenceLevel DOUBLE UNSIGNED, shallowAsperityDepth_pdf_variable_content BLOB, shallowAsperityDepth_pdf_probability_content BLOB, shallowAsperityDepth_pdf_used TINYINT(1) NOT NULL DEFAULT '0', shallowAsperityDepth_used TINYINT(1) NOT NULL DEFAULT '0', shallowAsperity TINYINT(1), literatureSource_title VARCHAR(255), literatureSource_firstAuthorName VARCHAR(255), literatureSource_firstAuthorForename VARCHAR(255), literatureSource_secondaryAuthors VARCHAR(255), literatureSource_doi VARCHAR(255), literatureSource_year INT UNSIGNED, literatureSource_in_title VARCHAR(255), literatureSource_editor VARCHAR(255), literatureSource_place VARCHAR(255), literatureSource_language VARCHAR(255), literatureSource_tome INT UNSIGNED, literatureSource_page_from INT UNSIGNED, literatureSource_page_to INT UNSIGNED, literatureSource_used TINYINT(1) NOT NULL DEFAULT '0', slipVelocity_value DOUBLE, slipVelocity_uncertainty DOUBLE UNSIGNED, slipVelocity_lowerUncertainty DOUBLE UNSIGNED, slipVelocity_upperUncertainty DOUBLE UNSIGNED, slipVelocity_confidenceLevel DOUBLE UNSIGNED, slipVelocity_pdf_variable_content BLOB, slipVelocity_pdf_probability_content BLOB, slipVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0', slipVelocity_used TINYINT(1) NOT NULL DEFAULT '0', strike_value DOUBLE, strike_uncertainty DOUBLE UNSIGNED, strike_lowerUncertainty DOUBLE UNSIGNED, strike_upperUncertainty DOUBLE UNSIGNED, strike_confidenceLevel DOUBLE UNSIGNED, strike_pdf_variable_content BLOB, strike_pdf_probability_content BLOB, strike_pdf_used TINYINT(1) NOT NULL DEFAULT '0', strike_used TINYINT(1) NOT NULL DEFAULT '0', length_value DOUBLE, length_uncertainty DOUBLE UNSIGNED, length_lowerUncertainty DOUBLE UNSIGNED, length_upperUncertainty DOUBLE UNSIGNED, length_confidenceLevel DOUBLE UNSIGNED, length_pdf_variable_content BLOB, length_pdf_probability_content BLOB, length_pdf_used TINYINT(1) NOT NULL DEFAULT '0', length_used TINYINT(1) NOT NULL DEFAULT '0', area_value DOUBLE, area_uncertainty DOUBLE UNSIGNED, area_lowerUncertainty DOUBLE UNSIGNED, area_upperUncertainty DOUBLE UNSIGNED, area_confidenceLevel DOUBLE UNSIGNED, area_pdf_variable_content BLOB, area_pdf_probability_content BLOB, area_pdf_used TINYINT(1) NOT NULL DEFAULT '0', area_used TINYINT(1) NOT NULL DEFAULT '0', ruptureVelocity_value DOUBLE, ruptureVelocity_uncertainty DOUBLE UNSIGNED, ruptureVelocity_lowerUncertainty DOUBLE UNSIGNED, ruptureVelocity_upperUncertainty DOUBLE UNSIGNED, ruptureVelocity_confidenceLevel DOUBLE UNSIGNED, ruptureVelocity_pdf_variable_content BLOB, ruptureVelocity_pdf_probability_content BLOB, ruptureVelocity_pdf_used TINYINT(1) NOT NULL DEFAULT '0', ruptureVelocity_used TINYINT(1) NOT NULL DEFAULT '0', stressdrop_value DOUBLE, stressdrop_uncertainty DOUBLE UNSIGNED, stressdrop_lowerUncertainty DOUBLE UNSIGNED, stressdrop_upperUncertainty DOUBLE UNSIGNED, stressdrop_confidenceLevel DOUBLE UNSIGNED, stressdrop_pdf_variable_content BLOB, stressdrop_pdf_probability_content BLOB, stressdrop_pdf_used TINYINT(1) NOT NULL DEFAULT '0', stressdrop_used TINYINT(1) NOT NULL DEFAULT '0', momentReleaseTop5km_value DOUBLE, momentReleaseTop5km_uncertainty DOUBLE UNSIGNED, momentReleaseTop5km_lowerUncertainty DOUBLE UNSIGNED, momentReleaseTop5km_upperUncertainty DOUBLE UNSIGNED, momentReleaseTop5km_confidenceLevel DOUBLE UNSIGNED, momentReleaseTop5km_pdf_variable_content BLOB, momentReleaseTop5km_pdf_probability_content BLOB, momentReleaseTop5km_pdf_used TINYINT(1) NOT NULL DEFAULT '0', momentReleaseTop5km_used TINYINT(1) NOT NULL DEFAULT '0', fwHwIndicator VARCHAR(64), ruptureGeometryWKT VARCHAR(255), faultID VARCHAR(255) NOT NULL, surfaceRupture_observed TINYINT(1), surfaceRupture_evidence VARCHAR(255), surfaceRupture_literatureSource_title VARCHAR(255), surfaceRupture_literatureSource_firstAuthorName VARCHAR(255), surfaceRupture_literatureSource_firstAuthorForename VARCHAR(255), surfaceRupture_literatureSource_secondaryAuthors VARCHAR(255), surfaceRupture_literatureSource_doi VARCHAR(255), surfaceRupture_literatureSource_year INT UNSIGNED, surfaceRupture_literatureSource_in_title VARCHAR(255), surfaceRupture_literatureSource_editor VARCHAR(255), surfaceRupture_literatureSource_place VARCHAR(255), surfaceRupture_literatureSource_language VARCHAR(255), surfaceRupture_literatureSource_tome INT UNSIGNED, surfaceRupture_literatureSource_page_from INT UNSIGNED, surfaceRupture_literatureSource_page_to INT UNSIGNED, surfaceRupture_literatureSource_used TINYINT(1) NOT NULL DEFAULT '0', surfaceRupture_used TINYINT(1) NOT NULL DEFAULT '0', centroidReference VARCHAR(255), PRIMARY KEY(_oid), INDEX(ruptureGeometryWKT), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB; CREATE TABLE StrongOriginDescription ( _oid BIGINT(20) NOT NULL, _parent_oid BIGINT(20) NOT NULL, _last_modified TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, originID VARCHAR(255) NOT NULL, waveformCount INT UNSIGNED, creationInfo_agencyID VARCHAR(64), creationInfo_agencyURI VARCHAR(255), creationInfo_author VARCHAR(128), creationInfo_authorURI VARCHAR(255), creationInfo_creationTime DATETIME, creationInfo_creationTime_ms INTEGER, creationInfo_modificationTime DATETIME, creationInfo_modificationTime_ms INTEGER, creationInfo_version VARCHAR(64), creationInfo_used TINYINT(1) NOT NULL DEFAULT '0', PRIMARY KEY(_oid), INDEX(originID), FOREIGN KEY(_oid) REFERENCES Object(_oid) ON DELETE CASCADE, FOREIGN KEY(_parent_oid) REFERENCES Object(_oid) ON DELETE CASCADE ) ENGINE=INNODB;