package buzzerproxy.db.view;

/**
 * @author Master
 * 
 */
public class DatabaseEntry extends BaseEntry {

	/**
     * 
     */
	private static final long serialVersionUID = 1L;

	private String search;
	private String datetime;
	private String filetype;
	private String ip;
	private String type;
	private String resultcount;
	private String clientversion;
	private String id;
	
	public void setid(String id){
		this.id = id;
	}
	public String getid(){
		return this.id;
	}
	public String getclientversion() {
		return this.clientversion;
	}

	public void setclientversion(String s) {
		this.clientversion = s;
	}

	public void setresultcount(String s) {
		this.resultcount = s;
	}

	public String getresultcount() {
		return this.resultcount;
	}

	public void settype(String s) {
		this.type = s;
	}

	public String gettype() {
		return this.type;
	}

	public void setip(String s) {
		this.ip = s;
	}

	public String getip() {
		return this.ip;
	}

	public void setfiletype(String s) {
		this.filetype = s;
	}

	public String getfiletype() {
		return this.filetype;
	}

	public void setdatetime(String datetime) {
		StringBuffer sb = new StringBuffer();
		sb.append(System.currentTimeMillis());
		this.datetime = sb.toString();
	}

	public String getdatetime() {
		return this.datetime;
	}

	public void setsearch(String s) {
		this.search = s;
	}

	public String getsearch() {
		return this.search;
	}

	 
	@Override
	public String createTable() {
		StringBuffer sb = new StringBuffer();
		sb.append("CREATE TABLE IF NOT EXISTS logging ( ");
		sb.append("id varchar(100) NOT NULL,");
		sb.append("search text NOT NULL,");
		sb.append("filetype varchar(255) NOT NULL,");
		sb.append("ip varchar(20) NOT NULL,");
		sb.append("type varchar(30) NOT NULL,");
		sb.append("resultcount varchar(10) NOT NULL,");
		sb.append("clientversion varchar(20) NOT NULL,");
		sb.append("datetime varchar(30) NOT NULL)");
		return sb.toString();
	}
}


//
//sb.append("CREATE TABLE IF NOT EXISTS LOGGING (");
//sb.append("id varchar(100) COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("search text COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("filetype varchar(255) COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("ip varchar(20) COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("type varchar(30) COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("resultcount varchar(10) NOT NULL,");
//sb.append("clientversion varchar(20) COLLATE utf8_unicode_ci NOT NULL,");
//sb.append("datetime varchar(30) COLLATE utf8_unicode_ci NOT NULL)");