CREATE TABLE `cmf_inquiry_shield_content` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `field_name` varchar(50) NOT NULL DEFAULT '' COMMENT '询盘字段名',
  `content` varchar(100) NOT NULL COMMENT '屏蔽内容',
  `times` int(11) NOT NULL COMMENT '出现次数',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='垃圾询盘屏蔽内容';
CREATE TABLE `cmf_inquiry_shield_ip` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ip` varchar(50) NOT NULL DEFAULT '' COMMENT 'IP',
  `create_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `update_time` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='垃圾询盘屏蔽IP';
ALTER TABLE `cmf_guestbook`
ADD COLUMN `is_garbage` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否垃圾询盘（1：是；0：不是）';