[Paul M]

CREATE TABLE pmtext (
pmtextid INT UNSIGNED NOT NULL AUTO_INCREMENT,
fromuserid INT UNSIGNED NOT NULL DEFAULT '0',
fromusername VARCHAR(100) NOT NULL DEFAULT '',
title VARCHAR(250) NOT NULL DEFAULT '',
message MEDIUMTEXT,
touserarray MEDIUMTEXT,
iconid SMALLINT UNSIGNED NOT NULL DEFAULT '0',
dateline INT UNSIGNED NOT NULL DEFAULT '0',
showsignature SMALLINT UNSIGNED NOT NULL DEFAULT '0',
allowsmilie SMALLINT UNSIGNED NOT NULL DEFAULT '1',
PRIMARY KEY (pmtextid),
KEY fromuserid (fromuserid, dateline)
) ;