decodes.tsdb.TsdbDatabaseVersion Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of opendcs Show documentation
A collection of software for aggregatting and processing environmental data such as from NOAA GOES satellites.
The newest version!
package decodes.tsdb;

public class TsdbDatabaseVersion
{
	// V2: MY_DCP_TRANS_nn - add uplink carrier column
	//	uplinkcarrier varchar(2),
	// V2: Drop OTHER_DCP_TRANS_nn tables
	// Added column to my_dcp_trans_
	// But we don't need to do this because we're not support dcpmon
	// for anybody using version 1.
	public static final int VERSION_2 = 2;
	
	// Version 3:
	// Add SOURCE_ID column to CP_COMP_TASKLIST
	public static final int VERSION_3 = 3;
	
	// Version 4:
	// Add FAIL_TIME column to CP_COMP_TASKLIST
	public static final int VERSION_4 = 4;

	// Version 5:
	// - Supports groups. Several new tables.
	public static final int VERSION_5 = 5;
	
	/**
	 * Version 6:
	 * - refactor tsdb_group for inclusion with CWMS (several changes)
	 * - tsdb_group_member_other is used for version and statcode
	 * - tsdb_group_member_group has new 'include_group' attribute
	 * CP_COMPUTATION now has group_id
	 */ 
	public static final int VERSION_6 = 6;
	public static final String VERSION_6_DTK = "DCSTOOL 5.0 Dec 31, 2010";
	
	/** 7 is DCSTOOL 5.1 corresponding to CWMS 2.1
	 * - DB_OFFICE_CODE is added to the following tables:
	 *     o  CP_ALGORITHM
	 *     o  CP_COMPUTATION
	 * - It also has the additions to my_dcp_trans_xxx tables
	 */
	public static final int VERSION_7 = 7;
	public static final String VERSION_7_DTK = "DCSTOOL 5.1";
	
	/**
	 * VERSION 8 A few Modifications, mainly to support groups in HDB,
	 * also miscellaneous cleanup.
	 * - CP_COMP_TS_PARM no longer has GROUP_ID column.
	 * - CP_COMPUTATION added column GROUP_ID
	 * - CP_COMP_DEPENDS first column is called "TS_ID" only for HDB.
	 * - New table CP_COMP_DEPENDS_SCRATCHPAD for use by the new Java
	 *   daemon to keep CP_COMP_DEPENDS up to date.
	 * - For HDB DATATYPE_ID and DELTA_T_UNITS are added to CP_COMP_TS_PARM
	 * - New table CP_DEPENDS_NOTIFY for the new daemon
	 * - New HDB Table CP_TS_ID
	 * - CP_COMP_TS_PARM now has SITE_ID for future development.
	 */
	public static final int VERSION_8 = 8;
	public static final String VERSION_8_DTK = "DCSTOOL 5.2";
	
	
	/**
	 * Version 9 enhancements:
	 * - Added CP_COMP_TS_PARM.site_id
	 * - Tables my_dcp_trans_xx changed to dcp_trans_xx
	 * - All time stamps in the xmit tables are now long integer.
	 * 
	 * - CP_COMPUTATION.SEASON_ID
	 * - CP_COMP_TS_PARM.SITE_ID
	 * - INTERVAL_CODE (entire table - OpenTSDB only)
	 * - for CWMS, uses new set_ccp_session_ctx method rather than the 2.2 set_session_office_id
	 * - TSDB_GROUP_MEMBER_TS: the 2nd column's name was changed from DATA_ID to TS_ID.
	 *   (It is DATA_ID in CWMS 2.1. It is TS_ID in CWMS 3.0 and all versions of OpenDCS Schema).
	 */
	public static final int VERSION_9 = 9;
	public static final String VERSION_9_DTK = "OPENDCS 6.0";
	
	/**
	 * Version 10 = OpenDCS 6.1
	 * - new table CP_COMPOSITE_DIAGRAM
	 * - new table CP_COMPOSITE_MEMBER
	 * - drop table SEASON
	 * - drop CP_COMPUTATION.SEASON_ID
	 */
	public static final int VERSION_10 = 10;
	public static final String VERSION_10_DTK = "OPENDCS 6.1";
	
	// Waste 11 and 12 to bring DecodesDatabaseVersion into alignment with this.
	public static final int VERSION_11 = 11;
	public static final String VERSION_11_DTK = "UNUSED";
	public static final int VERSION_12 = 12;
	public static final String VERSION_12_DTK = "UNUSED";

	/**
	 * Version 13 schema changes corresponds to OpenDCS 6.2 RC01
	 * - For CWMS, don't use CWMS_SEQ for SCHEDULE_ENTRY_STATUS and DACQ_EVENT, instead
	 *   use the CCP-sequences SCHEDULE_ENTRY_STATUSIdSeq and DACQ_EVENTIdSeq
	 * - Addition of CP_ALGO_SCRIPT table
	 * - Removal of unused tables CP_COMPOSITE_DIAGRAM and CP_COMPOSITE_MEMBER.
	 */
	public static final int VERSION_13 = 13;
	public static final String VERSION_13_DTK = "OpenDCS 6.2 RC01";

	/**
	 * Version 14 schema corresponds to OpenDCS 6.3
	 * - For CWMS the DAOs that write computations and groups need to enqueue
	 *   an appropriate CP_DEPENDS_NOTIFY message for the CompDepend Updater daemon.
	 *   	 * - For CWMS, add db_office_code to cp_comp_depends, cp_comp_depends_scratchpad,
	 *   and cp_depends_notify
	 * - For CWMS, add cp_depends_notifyseq
	 */
	public static final int VERSION_14 = 14;
	public static final String VERSION_14_DTK = "OpenDCS 6.3";
	
	/**
	 * Version 15 schema corresponds to OpenDCS 6.4
	 * - Add column loading_application_id to dacq_event for all versions.
	 * - Added Azul Alarm tables.
	 */
	public static final int VERSION_15 = 15;
	public static final String VERSION_15_DTK = "OpenDCS 6.4";
	
	/**
	 * Version 16 schema corresponds to OpenDCS 6.5
	 * - See decodes.sql.DecodesDatabaseVersion.java for details.
	 */
	public static final int VERSION_16 = 16;
	public static final String VERSION_16_DTK = "OpenDCS 6.5";
	
	/**
	 * Version 17 schema corresponds to OpenDCS 6.6
	 * - See decodes.sql.DecodesDatabaseVersion.java for details.
	 */
	public static final int VERSION_17 = 17;
	public static final String VERSION_17_DTK = "OpenDCS 6.6";
	
	/**
	 * Version 67 schema corresponds to OpenDCS 6.7
	 * - See decodes.sql.DecodesDatabaseVersion.java for details.
	 */
	public static final int VERSION_67 = 67;
	public static final String VERSION_67_DTK = "OpenDCS 6.7";
	
	/**
	 * Version 66 schema corresponds to OpenDCS 6.8
	 * - See decodes.sql.DecodesDatabaseVersion.java for details.
	 */
	public static final int VERSION_68 = 68;
	public static final String VERSION_68_DTK = "OpenDCS 6.8";
}