File indexing completed on 2024-04-28 17:16:07 

0001 
0002 DROP FUNCTION IF EXISTS `laplace_score`;
0003 
0004 DELIMITER $$
0005 USE `pling`$$
0006 CREATE
0007     DEFINER = CURRENT_USER FUNCTION `laplace_score`(`upvotes` INT, `downvotes` INT) RETURNS int(11) DETERMINISTIC
0008 BEGIN
0009     DECLARE `score` INT(10);
0010     SET `score` = (round(((`upvotes` + 6) / ((`upvotes` + `downvotes`) + 12)), 2) * 100);
0011     RETURN `score`;
0012 END$$
0013 
0014 DELIMITER ;