File indexing completed on 2024-04-14 05:53:07 

0001 ALTER TABLE project_rating
0002         ADD COLUMN score int(2) COMMENT 'vote up = 8 votedown = 3' AFTER user_dislike;
0003         
0004 select * from project_rating where user_like >1;
0005 
0006 update project_rating set score = 8 where user_like = 1 ;
0007 update project_rating set score = 3 where user_dislike = 1 ;
0008 
0009 // out of date. refer 20190514_score.sql 
0010 update project_rating set score = round((user_like*8+user_dislike*3+2*5)/(user_like+user_dislike+2),0) where user_like > 1 ;