20140315.md

database

为了点赞不管是实名回答还是匿名回答的回答都有消息提示

CREATE TABLE IF NOT EXISTS `seu_agree_message` (
  `id` int(9) unsigned NOT NULL auto_increment,
  `a_id` int(9) unsigned NOT NULL,
  `u_id` int(9) unsigned NOT NULL,
  `from_id` int(9) unsigned NoT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;

alter table seu_agree_message add q_id int(9) not null default 0;

在个人中心中显示自己被赞的次数

alter table seu_user add agree_count int(9) not null default 0;