package system.SDVServer;

/**
 * Contains all the constant info about the SDVServer <br>
 * Creation date: (06.2.2000 a. 22:22:16) <br>
 * @author: lex <br>
 */
public class SDVConstants {
	// init params
	public final static String sCfgPath = "sdvCfgPath";
	// http params
	public final static String sReqType = "ReqType";
	public final static String sMarketKey = "marketKey";
	public final static String sNumWord = "numWord";
	public final static String sRWKey = "rwKey";
	public final static String sRWCounts = "rwCounts";
	public final static String sName = "name";
	public final static String sValue = "value";
	// RsrServer constants
//	public final static String sRSRServerLocation = "http://www.server.esof/esofia/ResourceServer?";
	public final static String sRSRReqType = "ReqType";
	public final static String sRSRReqTypeValue = "10";
	public final static char   cInputSeparator = '|';
	// constants about the databases
//	public final static String sDBDriverLocation = "org.gjt.mm.mysql.Driver";
//	public final static String sDBNameRWDV = "rwDayValues";
//	public final static String sDBRWDVLocation = "jdbc:mysql://www.server.esof:3306/";
//	public final static String sDBRWDVUser = "root";
//	public final static String sDBRWDVPass = "";
//	public final static String sDBNameRWMarketDV = "rwMarketDayValues";
//	public final static String sDBRWMarketDVLocation = "jdbc:mysql://www.server.esof:3306/";
//	public final static String sDBRWMarketUser = "root";
//	public final static String sDBRWMarketPass = "";
	// names of the tables
	public final static String sDBRWDayValuesTable = "dc_";
	public final static String sDBRWMarketDayValuesTable = "dc_";
	// names of the db field types
	public final static String sDBFieldTypeTINYINT = "TINYINT";
	public final static String sDBFieldTypeINT = "INT";
	public final static String sDBFieldTypeBIGINT = "BIGINT";
	// names of the db fields
	public final static String sDBFieldRWKey = "rwKey";
	public final static String sDBFieldMarketKey = "marketKey";
	public final static String sDBFieldRWCounts = "rwCounts";
	public final static String sDBFieldRWVolatil = "rwVolatil";
	public final static String sDBFieldRWVulgarity = "rwVulgarity";
	public final static String sDBFieldRWAvgCounts = "rwAvgCounts";
	public final static String sDBFieldRWAvgVolatil = "rwAvgVolatil";
	public final static String sDBFieldRWAvgVulgarity = "rwAvgVulgarity";
	public final static String sDBFieldRWPercCounts = "rwPercCounts";
	public final static String sDBFieldRWPercVolatil = "rwPercVolatil";
	public final static String sDBFieldRWPercVulgarity = "rwPercVulgarity";
	public final static String sDBFieldRWCountValueHigh = "rwCountValueHigh";
	public final static String sDBFieldRWCountValueAvg = "rwCountValueAvg";
	public final static String sDBFieldRWCountValueLow = "rwCountValueLow";
	public final static String sDBFieldRWVolatValueHigh = "rwVolatValueHigh";
	public final static String sDBFieldRWVolatValueAvg = "rwVolatValueAvg";
	public final static String sDBFieldRWVolatValueLow = "rwVolatValueLow";
	public final static String sDBFieldRWVulgValueHigh = "rwVulgValueHigh";
	public final static String sDBFieldRWVulgValueAvg = "rwVulgValueAvg";
	public final static String sDBFieldRWVulgValueLow = "rwVulgValueLow";
	// create statemants
	public final static String sDBDVTableCreateDef = " (" + sDBFieldRWKey + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWCounts  + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWVolatil + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWVulgarity + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgCounts + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgVolatil + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgVulgarity + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWPercCounts + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWPercVolatil + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWPercVulgarity + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueLow + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueLow + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueLow + " " + sDBFieldTypeTINYINT + ")";
	public final static String sDBMarketDVTableCreateDef = " (" + sDBFieldRWKey  + " " + sDBFieldTypeBIGINT + ", " + sDBFieldMarketKey + " " + sDBFieldTypeINT + ", " + sDBFieldRWCounts  + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWVolatil + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWVulgarity + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgCounts + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgVolatil + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWAvgVulgarity + " " + sDBFieldTypeBIGINT + ", " + sDBFieldRWPercCounts + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWPercVolatil + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWPercVulgarity + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWCountValueLow + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVolatValueLow + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueHigh + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueAvg + " " + sDBFieldTypeTINYINT + ", " + sDBFieldRWVulgValueLow + " " + sDBFieldTypeTINYINT + ")";

/**
 * Constants constructor.
 */
public SDVConstants() {
	super();
}
}