File indexing completed on 2024-04-21 06:00:36

0001 ALTER TABLE `project_rating`
0002     ADD COLUMN `comment_id` INT(11) NULL DEFAULT '0' COMMENT 'review for rating' AFTER `user_dislike`,
0003     ADD COLUMN `rating_active` INT(1) NULL DEFAULT '1' COMMENT 'active = 1, deleted = 0' AFTER `comment_id`;
0004 
0005 UPDATE `project_rating` `r`
0006 SET `r`.`rating_active` = 1;