mysql> desc xwikistatsdoc; +---------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------------+--------------+------+-----+---------+-------+ | XWS_ID | int(11) | NO | PRI | | | | XWS_NUMBER | int(11) | YES | | NULL | | | XWS_NAME | varchar(255) | NO | | | | | XWS_CLASSNAME | varchar(255) | NO | | | | | XWS_ACTION | varchar(255) | NO | | | | | XWS_PAGE_VIEWS | int(11) | YES | | NULL | | | XWS_UNIQUE_VISITORS | int(11) | YES | | NULL | | | XWS_PERIOD | int(11) | YES | | NULL | | | XWS_VISITS | int(11) | YES | | NULL | | +---------------------+--------------+------+-----+---------+-------+ mysql> desc xwikistatsreferer; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | XWR_ID | int(11) | NO | PRI | | | | XWR_NUMBER | int(11) | YES | | NULL | | | XWR_NAME | varchar(255) | NO | | | | | XWR_CLASSNAME | varchar(255) | NO | | | | | XWR_REFERER | varchar(255) | NO | | | | | XWR_PAGE_VIEWS | int(11) | YES | | NULL | | | XWR_PERIOD | int(11) | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+ mysql> desc xwikistatsvisit; +----------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------------+------+-----+---------+-------+ | XWV_ID | int(11) | NO | PRI | | | | XWV_NUMBER | int(11) | YES | | NULL | | | XWV_NAME | varchar(255) | NO | | | | | XWV_CLASSNAME | varchar(255) | NO | | | | | XWV_IP | varchar(32) | NO | | | | | XWV_USER_AGENT | varchar(255) | NO | | | | | XWV_COOKIE | varchar(255) | NO | | | | | XWV_UNIQUE_ID | varchar(255) | NO | | | | | XWV_PAGE_VIEWS | int(11) | YES | | NULL | | | XWV_PAGE_SAVES | int(11) | YES | | NULL | | | XWV_DOWNLOADS | int(11) | YES | | NULL | | | XWV_START_DATE | datetime | YES | | NULL | | | XWV_END_DATE | datetime | YES | | NULL | | +----------------+--------------+------+-----+---------+-------+