ecshop数据字典（六）–留言,评价和回复

留言和评价表
CREATE TABLE IF NOT EXISTS `ecs_comment` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `id_value` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `email` varchar(60) NOT NULL DEFAULT '',
  `user_name` varchar(60) NOT NULL DEFAULT '',
  `content` text NOT NULL,
  `comment_rank` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `add_time` int(10) unsigned NOT NULL DEFAULT '0',
  `ip_address` varchar(15) NOT NULL DEFAULT '',
  `status` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`comment_id`),
  KEY `parent_id` (`parent_id`),
  KEY `id_value` (`id_value`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;







回复表
CREATE TABLE IF NOT EXISTS `ecs_feedback` (
  `msg_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` mediumint(8) unsigned NOT NULL DEFAULT '0',----父节点
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0',----用户id
  `user_name` varchar(60) NOT NULL DEFAULT '',----用户名
  `user_email` varchar(60) NOT NULL DEFAULT '',----用户email
  `msg_title` varchar(200) NOT NULL DEFAULT '',-----回复的title
  `msg_type` tinyint(1) unsigned NOT NULL DEFAULT '0',----留言类型
  `msg_status` tinyint(1) unsigned NOT NULL DEFAULT '0',--------状态
  `msg_content` text NOT NULL,---------内容
  `msg_time` int(10) unsigned NOT NULL DEFAULT '0',---------时间
  `message_img` varchar(255) NOT NULL DEFAULT '0',----------图片
  `order_id` int(11) unsigned NOT NULL DEFAULT '0',
  `msg_area` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`msg_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;