| Name | Type | Null | Key | Default | Extra | Comment |
|---|---|---|---|---|---|---|
| TS | timestamp | NO | CURRENT_TIMESTAMP | |||
| Category | varchar(32) | NO | ||||
| Host | varchar(64) | NO | ||||
| Message | text | NO |
| Engine | Row format | Table collation | Create options |
|---|---|---|---|
| MyISAM | Dynamic | utf8_general_ci |
CREATE TABLE `errorlog` ( `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, `Category` varchar(32) NOT NULL, `Host` varchar(64) NOT NULL, `Message` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8