package system.rsrserver;

/**
 * Contains all the constant info about the RsrServer. <br>
 * Creation date: (18.1.00 14:37:31) <br>
 * @author: lex <br>
 */
public class RSRConstants {
	// init params
	public final static String sCfgPath = "rsrCfgPath";
	// http params
	public final static String sReqType = "ReqType";
	public final static String sMarketKey = "marketKey";
	public final static String sLangKey = "langKey";
	public final static String sLangName = "langName";
	public final static String sLangShortName = "langShortName";
	public final static String sMarketName = "marketName";
	public final static String sMarketDescr = "marketDescr";
	public final static String sName = "name";
	public final static String sValue = "value";		
	// constants about the db
//	public final static String sMYSQLDriver = "org.gjt.mm.mysql.Driver";
//	public final static String sDBName = "newRsr";
//	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 sDBMarketsTableName = "markets";
	public final static String sDBLanguagesTableName = "languages";
	// SQL fields' types
	public final static String sDBFieldTINYINT = "TINYINT";
	public final static String sDBFieldSMALLINT = "SMALLINT";
	public final static String sDBFieldCHAR255 = "CHAR(255)";
	public final static String sDBFieldDATE = "DATE";
	// tables' fields' names
	public final static String sDBFieldMarketKey = "marketKey";
	public final static String sDBFieldMarketName = "marketName";
	public final static String sDBFieldMarketDescr = "marketDescr";
	public final static String sDBFieldMarketActivationDate = "marketActivationDate";
	public final static String sDBFieldMarketDeactivationDate = "marketDeactivationDate";
	public final static String sDBFieldMarketStatus = "marketStatus";
	public final static String sDBFieldLangKey = "langKey";
	public final static String sDBFieldLangShortName = "langShortName";
	public final static String sDBFieldLangName = "langName";
	public final static String sDBFieldLangActive = "langActive";
	// SQL create table querys
	public final static String sSQLCreateMarkets = "CREATE TABLE " + sDBMarketsTableName + " (marketKey INT(2), marketName Char(255), marketDescr CHAR(255), marketActivationDate DATE, marketDeactivationDate DATE, marketStatus int(1))";
	public final static String sSQLCreateLanguages = "CREATE TABLE " + sDBLanguagesTableName + " (langKey INT(2), langShortName CHAR(3), langName CHAR(255), langActive int(1))";
/**
 * Constants constructor. <br>
 */
public RSRConstants() {
	super();
}
}