 
 /* Add Comments */
 ALTER TABLE Specimens COMMENT = 'Equivalent to O&M Sampling Feature Type "Specimen".  Describes physical samples or specimens.';
-
-
-/******************** Add Table: DataLoggerFiles ************************/
-
-/* Build Table Structure */
-CREATE TABLE DataLoggerFiles
-(
-	DataLoggerFileID INTEGER AUTO_INCREMENT PRIMARY KEY 
-		COMMENT 'Unique identifier for the datalogger file' NOT NULL,
-	ProgramID INTEGER 
-		COMMENT 'Foreign key identifier of the datalogger program that created the file' NOT NULL,
-	DataLoggerFileName VARCHAR(255) 
-		COMMENT 'Text name of the datalogger file' NOT NULL,
-	DataLoggerFileDescription VARCHAR(500) 
-		COMMENT 'Text description of the datalogger file' NULL,
-	DataLoggerFileLink VARCHAR(255) 
-		COMMENT 'File path to the datalogger file' NULL
-) ENGINE=InnoDB;
-
-/* Add Comments */
-ALTER TABLE DataLoggerFiles COMMENT = 'Destibes datalogger files created by a deployment action';
-
-
-/******************** Add Table: DataloggerProgramFiles ************************/
-
-/* Build Table Structure */
-CREATE TABLE DataloggerProgramFiles
-(
-	ProgramID INTEGER AUTO_INCREMENT PRIMARY KEY 
-		COMMENT 'Primary key identifier' NOT NULL,
-	AffiliationID INTEGER 
-		COMMENT 'Foreign key identifier of the person that created the program' NOT NULL,
-	ProgramName VARCHAR(255) 
-		COMMENT 'Text name of the datalogger program file' NOT NULL,
-	ProgramDescription VARCHAR(500) 
-		COMMENT 'Text description of the datalogger program file' NULL,
-	ProgramVersion VARCHAR(50) 
-		COMMENT 'Text description of the version of the datalogger program file' NULL,
-	ProgramFileLink VARCHAR(255) 
-		COMMENT 'URL or file path to the datalogger program file' NULL
-) ENGINE=InnoDB;
-
-/* Add Comments */
-ALTER TABLE DataloggerProgramFiles COMMENT = 'Information about datalogger program files';
-
-
-/******************** Add Table: DeploymentActions ************************/
-
-/* Build Table Structure */
-CREATE TABLE DeploymentActions
-(
-	ActionID INTEGER 
-		COMMENT 'Foreign key identifer for the Action that is the deployment' NOT NULL,
-	DeploymentTypeCV VARCHAR(255) 
-		COMMENT 'CV term that describes the type of the deployment' NOT NULL,
-	CurrentlyDeployed BOOLEAN 
-		COMMENT 'A boolean indicating whether a piece of equipment is currently deployed' NOT NULL
-) ENGINE=InnoDB;
-
-/* Add Primary Key */
-ALTER TABLE DeploymentActions ADD CONSTRAINT pkDeploymentActions
-	PRIMARY KEY (ActionID);
-
-/* Add Comments */
-ALTER TABLE DeploymentActions COMMENT = 'Describes actions that are deployment events';
-
-
-/******************** Add Table: DeploymentMeasuredVariables ************************/
-
-/* Build Table Structure */
-CREATE TABLE DeploymentMeasuredVariables
-(
-	DeploymentMeasuredVariableID INTEGER AUTO_INCREMENT PRIMARY KEY 
-		COMMENT 'Primary key identifier' NOT NULL,
-	ActionID INTEGER 
-		COMMENT 'Foreign key identifier of the Deployment Action associated with the DeploymentMeasuredVariable' NOT NULL,
-	InstrumentOutputVariableID INTEGER 
-		COMMENT 'Foreign key identifier of the InstrumentOutputVariable that is the DeploymentMeasuredVariable' NOT NULL,
-	DataloggerFileID INTEGER 
-		COMMENT 'Foreign key identifier of the DataloggerFile from in which the DeploymentMeasuredVariable is recorded' NOT NULL,
-	ColumnLabel VARCHAR(50) 
-		COMMENT 'Text label of the column within the DataloggerFile that is the DeploymentMeasuredVariable' NULL,
-	ColumnDescription VARCHAR(500) 
-		COMMENT 'Text description of hte column within the DataloggerFile that is the DeploymentMeasuredVariable' NULL,
-	MeasurementEquation VARCHAR(255) 
-		COMMENT 'Text string that gives the equation (if any) associated with the DeploymentMeasuredVariable' NULL,
-	ScanInterval FLOAT 
-		COMMENT 'Numeric value of the scan interval' NULL,
-	ScanIntervalUnitsID INTEGER 
-		COMMENT 'Foreign key identifier of the units of the scan interval' NULL,
-	RecordingInterval FLOAT 
-		COMMENT 'Numeric value of the recording interval' NULL,
-	RecordingIntervalUnitsID INTEGER 
-		COMMENT 'Foreign key identifier of the units for the recording interval' NULL,
-	AggregationStatisticCV VARCHAR(255) 
-		COMMENT 'Text aggregation statistic of the recorded value - chosen from a CV' NULL
-) ENGINE=InnoDB;
-
-/* Add Comments */
-ALTER TABLE DeploymentMeasuredVariables COMMENT = 'Inoformation about the variables measured by a deployment';
 
 
 

	EquipmentID INTEGER 
		COMMENT 'Foreign key identifier for a piece of Equipment' NOT NULL,
	RelationshipTypeCV VARCHAR(255) 
		COMMENT 'Text string indicating the type of relationship between two pieces of equipement' NOT NULL,
	RelatedEquipmentID INTEGER 
		COMMENT 'Foreign key identifier of the related piece of equipment' NOT NULL
) ENGINE=InnoDB;

/* Add Comments */

/* Add Foreign Key: fk_Specimens_SamplingFeatures */
ALTER TABLE Specimens ADD CONSTRAINT fk_Specimens_SamplingFeatures
	FOREIGN KEY (SamplingFeatureID) REFERENCES SamplingFeatures (SamplingFeatureID)
	ON UPDATE NO ACTION ON DELETE NO ACTION;