/* * * Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved. * * This file is part of Entando software. * Entando is a free software; * You can redistribute it and/or modify it * under the terms of the GNU General Public License (GPL) as published by the Free Software Foundation; version 2. * * See the file License for the specific language governing permissions * and limitations under the License * * * * Copyright 2013 Entando S.r.l. (http://www.entando.com) All rights reserved. * */ package org.entando.entando.plugins.jpstats.aps.system.init.portdb; import com.j256.ormlite.field.DataType; import com.j256.ormlite.field.DatabaseField; import com.j256.ormlite.table.DatabaseTable; /** * @author E.Santoboni */ @DatabaseTable(tableName = Statistics.TABLE_NAME) public class Statistics { public Statistics() {} @DatabaseField(columnName = "ip", dataType = DataType.STRING, width = 19, canBeNull = false) private String _ip; @DatabaseField(columnName = "referer", dataType = DataType.LONG_STRING, canBeNull = true) private String _referer; @DatabaseField(columnName = "session_id", dataType = DataType.STRING, canBeNull = true) private String _sessionId; @DatabaseField(columnName = "role", dataType = DataType.STRING, canBeNull = true) private String _role; @DatabaseField(columnName = "timestamp", dataType = DataType.STRING, canBeNull = true) private String _timestamp; /* ip character varying(19), referer character varying, session_id character varying(254), "role" character varying(254), "timestamp" character varying(254), */ @DatabaseField(columnName = "year_value", dataType = DataType.STRING, width = 4, canBeNull = true) private String _yearValue; @DatabaseField(columnName = "month_value", dataType = DataType.STRING, width = 2, canBeNull = true) private String _monthValue; @DatabaseField(columnName = "day_value", dataType = DataType.STRING, width = 2, canBeNull = true) private String _dayValue; @DatabaseField(columnName = "hour_value", dataType = DataType.STRING, width = 8, canBeNull = true) private String _hourValue; /* year_value character(4), month_value character(2), day_value character(2), hour_value character(8), */ @DatabaseField(columnName = "pagecode", dataType = DataType.STRING, canBeNull = true) private String _pageCode; @DatabaseField(columnName = "langcode", dataType = DataType.STRING, width = 2, canBeNull = true) private String _langCode; @DatabaseField(columnName = "useragent", dataType = DataType.STRING, canBeNull = true) private String _useragent; @DatabaseField(columnName = "browserlang", dataType = DataType.STRING, canBeNull = true) private String _browserLang; @DatabaseField(columnName = "content", dataType = DataType.STRING, width = 16, canBeNull = true) private String _content; /* pagecode character varying(254), langcode character(2), useragent character varying, browserlang character varying(254), "content" character varying(16) */ public static final String TABLE_NAME = "jpstats_statistics"; } /* CREATE TABLE jpstats_statistics ( ip character varying(19), referer character varying, session_id character varying(254), "role" character varying(254), "timestamp" character varying(254), * year_value character(4), month_value character(2), day_value character(2), hour_value character(8), * pagecode character varying(254), langcode character(2), useragent character varying, browserlang character varying(254), "content" character varying(16) ); */