Table: nornix_site.message

Structure
Name	Type	Null	Key	Default
User	varchar(64)	NO	MUL
TS	timestamp	NO		CURRENT_TIMESTAMP
Subject	varchar(127)	NO
From	varchar(80)	NO
Body	text	NO
Read	tinyint(1)	NO

Indexes
Non-unique	Key	Seq	Column	Collation	Cardinality	Sub part	Packed	Null	Type	Comment
1	User	1	User	A					BTREE

Information
Engine	Row format	Table collation	Create options
MyISAM	Dynamic	utf8_general_ci

CREATE TABLE `message` (
  `User` varchar(64) NOT NULL,
  `TS` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `Subject` varchar(127) NOT NULL,
  `From` varchar(80) NOT NULL,
  `Body` text NOT NULL,
  `Read` tinyint(1) NOT NULL,
  KEY `User` (`User`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8