#----------------------------
# Table structure for messages
#----------------------------
CREATE TABLE IF NOT EXISTS `messages` (
  `msg_id` int(11) NOT NULL auto_increment,
  `msg_date` DECIMAL(20,0) NOT NULL default 0,
  `msg_type` decimal(1,0) default '0',
  `to_name` varchar(35) default NULL,
  `to_id` varchar(45) default NULL,
  `from_name` varchar(35) default NULL,
  `from_id` varchar(45) default NULL,
  `title` text NOT NULL,
  `message` text NOT NULL,
  `readflg` decimal(1,0) default '0',
  `delflg` decimal(1,0) default '0',
  PRIMARY KEY  (`msg_id`),
  KEY `key_msg_id` (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
