1. 消息数据表结构如下：
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `sp_message`
-- ----------------------------
DROP TABLE IF EXISTS `sp_message`;
CREATE TABLE `sp_message` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
`user_id` int(11) NOT NULL COMMENT '接收信息用户UID',
`status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1为未读，0为已读',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2384 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of sp_message
-- ----------------------------
INSERT INTO `sp_message` VALUES ('2059', '780', '0');
INSERT INTO `sp_message` VALUES ('2217', '770', '1');
INSERT INTO `sp_message` VALUES ('2061', '770', '1');
INSERT INTO `sp_message` VALUES ('2062', '780', '0');
INSERT INTO `sp_message` VALUES ('1868', '770', '0');
INSERT INTO `sp_message` VALUES ('1875', '770', '0');
INSERT INTO `sp_message` VALUES ('1952', '770', '1');
INSERT INTO `sp_message` VALUES ('2097', '770', '0');
INSERT INTO `sp_message` VALUES ('1973', '770', '1');
INSERT INTO `sp_message` VALUES ('1944', '770', '1');
INSERT INTO `sp_message` VALUES ('2069', '780', '0');
INSERT INTO `sp_message` VALUES ('2245', '770', '1');
INSERT INTO `sp_message` VALUES ('1976', '770', '1');
INSERT INTO `sp_message` VALUES ('1918', '770', '1');
INSERT INTO `sp_message` VALUES ('1960', '770', '1');
INSERT INTO `sp_message` VALUES ('1931', '770', '1');
INSERT INTO `sp_message` VALUES ('1989', '770', '1');
INSERT INTO `sp_message` VALUES ('2049', '780', '0');
INSERT INTO `sp_message` VALUES ('2210', '770', '1');
INSERT INTO `sp_message` VALUES ('2000', '770', '1');
INSERT INTO `sp_message` VALUES ('2002', '770', '1');
INSERT INTO `sp_message` VALUES ('2051', '770', '0');
INSERT INTO `sp_message` VALUES ('2014', '770', '1');
INSERT INTO `sp_message` VALUES ('2019', '770', '1');
INSERT INTO `sp_message` VALUES ('2029', '770', '0');
INSERT INTO `sp_message` VALUES ('2098', '780', '0');
INSERT INTO `sp_message` VALUES ('2038', '770', '0');
INSERT INTO `sp_message` VALUES ('2267', '770', '0');
INSERT INTO `sp_message` VALUES ('2139', '770', '0');
INSERT INTO `sp_message` VALUES ('2140', '780', '0');
INSERT INTO `sp_message` VALUES ('2221', '770', '0');
INSERT INTO `sp_message` VALUES ('2230', '780', '0');
INSERT INTO `sp_message` VALUES ('2239', '770', '0');
INSERT INTO `sp_message` VALUES ('2253', '770', '1');
INSERT INTO `sp_message` VALUES ('2262', '770', '0');
INSERT INTO `sp_message` VALUES ('2278', '770', '1');
INSERT INTO `sp_message` VALUES ('2285', '770', '0');
INSERT INTO `sp_message` VALUES ('2294', '770', '1');
INSERT INTO `sp_message` VALUES ('2302', '780', '0');
INSERT INTO `sp_message` VALUES ('2309', '770', '0');
INSERT INTO `sp_message` VALUES ('2327', '770', '0');
INSERT INTO `sp_message` VALUES ('2339', '770', '0');
SET FOREIGN_KEY_CHECKS=0;
-- -
