package system.srcserver;

/**
 * Contains all the constant info about the SrcServer <br>
 * Creation date: (18.1.00 14:37:31) <br>
 * @author: lex <br>
 */
public class SRCConstants {
	// init param's
	public final static String sCfgPath = "srcCfgPath";
	// http param's
	public final static String sReqType = "ReqType";
	public final static String sMarketKey = "marketKey";
	public final static String sSrcKey = "srcKey";
	public final static String sSrcString = "srcString";
	public final static String sSchedSrcKey = "schedSrcKey";
	public final static String sLangKey = "langKey";
	public final static String sTimeBase = "timeBase";
	public final static String sFrequence = "frequence";
	public final static String sKeepInPath = "keepInPath";
	public final static String sKeepInDomain = "keepInDomain";
	public final static String sGrabLevels = "grabLevels";
	public final static String sSrcTitle = "srcTitle";
	public final static String sParSrcKey = "parSrcKey";
	public final static String sName = "name";
	public final static String sValue = "value";
	public final static String sUserAgent = "userAgent";
	public final static String sSchedActive = "active";
	public final static String sReqMarketKey = "reqMarketKey";
	public final static String sProcTime = "procTime";
	public final static String sNumSrc = "numSrc";
	// 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 = '|';
	// DB constants
//	public final static String sDBName = "Src";
//	public final static String sDBDriverLocation = "org.gjt.mm.mysql.Driver";
//	public final static String sDBLocation = "jdbc:mysql://www.server.esof:3306/";
//	public final static String sDBUser = "root";
//	public final static String sDBPass = "";
	// table names
	public final static String sDBSrcTable = "Src";
	public final static String sDBMarketSrcRelTable = "marketSrcRel";
	public final static String sDBMarketSchedSrcTable = "marketSchedSrc";
	public final static String sDBSrcSrcRelTableBase = "SrcSrcRel_";
	// field types
	public final static String sDBFieldTypeTINYINT = "TINYINT";
	public final static String sDBFieldTypeSMALLINT = "SMALLINT";
	public final static String sDBFieldTypeINT = "INT";
	public final static String sDBFieldTypeBIGINT = "BIGINT";
	public final static String sDBFieldTypeCHAR100 = "CHAR(100)";
	public final static String sDBFieldTypeCHAR255 = "CHAR(255)";
	public final static String sDBFieldTypeDATE = "DATE";
	// field names
	public final static String sDBFieldSrcKey = "srcKey";
	public final static String sDBFieldLangKey = "langKey";
	public final static String sDBFieldSrcString = "srcString";
	public final static String sDBFieldSrcTitle = "srcTitle";
	public final static String sDBFieldSrcCounts = "srcCounts";
	public final static String sDBFieldSrcRegDate = "srcRegDate";
	public final static String sDBFieldSrcLastChecked = "srcLastChecked";
	public final static String sDBFieldSchedSrcKey = "schedSrcKey";
	public final static String sDBFieldMarketKey = "marketKey";
	public final static String sDBFieldMarketSrcCheckCounts = "marketSrcCheckCounts";
	public final static String sDBFieldMarketSrcRegDate = "marketSrcRegDate";
	public final static String sDBFieldMarketSrcLastChecked = "marketSrcLastChecked";
	public final static String sDBFieldCheckCounts = "checkCounts";
	public final static String sDBFieldSchedRegDate = "schedRegDate";
	public final static String sDBFieldSchedLastChecked = "schedLastChecked";
	public final static String sDBFieldTimeBase = "timeBase";
	public final static String sDBFieldFrequence = "frequence";
	public final static String sDBFieldKeepInPath = "keepInPath";
	public final static String sDBFieldKeepInDomain = "keepInDomain";
	public final static String sDBFieldGrabLevels = "grabLevels";
	public final static String sDBFieldActive = "active";
	public final static String sDBFieldDeactivation = "deactivation";
	public final static String sDBFieldUserAgent = "userAgent";
	public final static String sDBFieldSchedActive = "schedActive";
	public final static String sDBFieldLastProcTime = "lastProcTime";
	public final static String sDBFieldNumSrc = "numSrc";
	public final static String sDBFieldSrcSrcRelKey = "srcSrcRelKey";
	public final static String sDBFieldParSrcKey = "parSrcKey";
	public final static String sDBFieldChildSrcKey = "childSrcKey";
	public final static String sDBFieldLastChecked = "lastChecked";
	// SQL create statemants
	public final static String sSQLCreateSrc = "CREATE TABLE " +  sDBSrcTable + " (" + sDBFieldSrcKey + " " + sDBFieldTypeBIGINT + ", " + sDBFieldLangKey + " " + sDBFieldTypeSMALLINT + ", " + sDBFieldSrcString + " " + sDBFieldTypeCHAR255 + ", " + sDBFieldSrcTitle + " " + sDBFieldTypeCHAR255 + ", " + sDBFieldSrcCounts + " " + sDBFieldTypeBIGINT + ", " + sDBFieldSrcRegDate + " " + sDBFieldTypeDATE + ", " + sDBFieldSrcLastChecked  + " " + sDBFieldTypeDATE + ")";
	public final static String sSQLCreateMarketSrcRel = "CREATE TABLE " + sDBMarketSrcRelTable + " (" + sDBFieldSrcKey + " " + sDBFieldTypeBIGINT + ", " + sDBFieldSchedSrcKey + " " + sDBFieldTypeBIGINT + ", " + sDBFieldMarketKey + " " + sDBFieldTypeSMALLINT + ", " + sDBFieldMarketSrcCheckCounts + " " + sDBFieldTypeBIGINT + ", " + sDBFieldMarketSrcRegDate + " " + sDBFieldTypeDATE + ", " + sDBFieldMarketSrcLastChecked + " " + sDBFieldTypeDATE + ")";
	public final static String sSQLCreateMarketSchedSrc = "CREATE TABLE " + sDBMarketSchedSrcTable + " (" + sDBFieldSchedSrcKey + " " + sDBFieldTypeBIGINT + ", " + sDBFieldMarketKey + " " + sDBFieldTypeSMALLINT + ", " + sDBFieldCheckCounts + " " + sDBFieldTypeBIGINT + ", " + sDBFieldSchedRegDate + " " + sDBFieldTypeDATE + ", " + sDBFieldSchedLastChecked + " " + sDBFieldTypeDATE + ", " + sDBFieldTimeBase + " " + sDBFieldTypeBIGINT + ", " + sDBFieldFrequence + " " + sDBFieldTypeSMALLINT + ", " + sDBFieldKeepInPath + " " + sDBFieldTypeTINYINT + ", " + sDBFieldKeepInDomain + " " + sDBFieldTypeTINYINT + ", " + sDBFieldGrabLevels + " " + sDBFieldTypeTINYINT + ", " + sDBFieldActive + " " + sDBFieldTypeTINYINT + ", " + sDBFieldDeactivation + " " + sDBFieldTypeDATE + ", " + sDBFieldSchedActive + " " + sDBFieldTypeCHAR100 + ", " + sDBFieldUserAgent + " " + sDBFieldTypeTINYINT + ", " + sDBFieldLastProcTime + " " + sDBFieldTypeINT + ", " + sDBFieldNumSrc + " " + sDBFieldTypeINT + ")";
/**
 * Constants constructor comment.
 */
public SRCConstants() {
	super();
}
/**
 * Insert the method's description here.
 * Creation date: (8.6.00 18:48:47)
 * @param args java.lang.String[]
 */
public static void main(String[] args) {
	System.out.println(sSQLCreateMarketSrcRel);
}
}