CREATE TABLE umm_msg msg_id int 11 NOT NULL auto_increment plan_id int

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
CREATE TABLE `umm_msg` (
`msg_id` int(11) NOT NULL auto_increment,
`plan_id` int(11) NOT NULL,
`owner_id` int(11) NOT NULL,
`to_id` int(11) NOT NULL,
`subject` char(255) NOT NULL,
`body` text NOT NULL,
`reply_id` int(11) NOT NULL default '0',
`if_system` tinyint(1) NOT NULL default '0',
`audio` char(12) default NULL,
PRIMARY KEY (`msg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Личные сообщения';