View file magmail/magmail.sql

ALTER TABLE users ADD friends text;
ALTER TABLE users ADD mailtime varchar(14) NOT NULL default '';
ALTER TABLE users ADD subjectlen smallint not null;
CREATE TABLE `letters` (
  `num` int auto_increment primary key,
  `messtime` varchar(14) NOT NULL default '',
  `messtype` tinyint,
  `fromid` int,
  `toid` int,
  `fromnick` text,
  `tonick` text,
  `messtext` text,
  KEY `fromnick` (fromnick(10)),
  KEY `tonick` (tonick(10)),
  KEY `messtime` (`messtime`)
) TYPE=MyISAM;