Table: nornix_site.accesslog
Structure | Name | Type | Null | Key | Default | Extra | Comment |
|---|
| TS | timestamp | NO | | CURRENT_TIMESTAMP | | |
|---|
| DocumentNo | int(10) unsigned | NO | | | | |
|---|
| Referer | varchar(120) | YES | | | | |
|---|
| Ip | int(11) | YES | | | | |
|---|
| UserAgent | varchar(200) | YES | | | | |
|---|
Information| Engine | Row format | Table collation | Create options |
|---|
| MyISAM | Dynamic | utf8_general_ci | |
CREATE TABLE `accesslog` (
`TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`DocumentNo` int(10) unsigned NOT NULL,
`Referer` varchar(120) default NULL,
`Ip` int(11) default NULL,
`UserAgent` varchar(200) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8