liquid_feedback_core

diff core.sql @ 378:e88d0606891f

Bugfix regarding "proportional_order" of suggestions:
Use NULL values explicitly to be sorted last
(includes new suggestions as well as suggestions without any individual rankings)
author jbe
date Mon Mar 18 09:36:21 2013 +0100 (2013-03-18)
parents 47965760b1b8
children 1c991490f075
line diff
     1.1 --- a/core.sql	Mon Mar 18 09:24:51 2013 +0100
     1.2 +++ b/core.sql	Mon Mar 18 09:36:21 2013 +0100
     1.3 @@ -792,7 +792,7 @@
     1.4  COMMENT ON COLUMN "suggestion"."plus1_fulfilled_count"    IS 'Calculated from table "direct_supporter_snapshot", not requiring informed supporters';
     1.5  COMMENT ON COLUMN "suggestion"."plus2_unfulfilled_count"  IS 'Calculated from table "direct_supporter_snapshot", not requiring informed supporters';
     1.6  COMMENT ON COLUMN "suggestion"."plus2_fulfilled_count"    IS 'Calculated from table "direct_supporter_snapshot", not requiring informed supporters';
     1.7 -COMMENT ON COLUMN "suggestion"."proportional_order"       IS 'To be used for sorting suggestions within an initiative; updated by "lf_update_suggestion_order"';
     1.8 +COMMENT ON COLUMN "suggestion"."proportional_order"       IS 'To be used for sorting suggestions within an initiative; NULL values sort last; updated by "lf_update_suggestion_order"';
     1.9  
    1.10  
    1.11  CREATE TABLE "rendered_suggestion" (

Impressum / About Us