liquid_feedback_core
changeset 308:5c98265b39a0 v2.1.0
Added missing DROP FUNCTION "vote_ratio" in update scripts
author | jbe |
---|---|
date | Sat Oct 06 23:34:03 2012 +0200 (2012-10-06) |
parents | 847d59f94ceb |
children | 3ab95ace7ffa 6529e423f8eb |
files | update/core-update.v2.0.11-v2.0.12.sql update/core-update.v2.0.12-v2.1.0.sql |
line diff
1.1 --- a/update/core-update.v2.0.11-v2.0.12.sql Fri Oct 05 13:45:37 2012 +0200 1.2 +++ b/update/core-update.v2.0.11-v2.0.12.sql Sat Oct 06 23:34:03 2012 +0200 1.3 @@ -306,4 +306,8 @@ 1.4 END; 1.5 $$; 1.6 1.7 +DROP FUNCTION IF EXISTS "vote_ratio" 1.8 + ( "initiative"."positive_votes"%TYPE, 1.9 + "initiative"."negative_votes"%TYPE ); 1.10 + 1.11 COMMIT;
2.1 --- a/update/core-update.v2.0.12-v2.1.0.sql Fri Oct 05 13:45:37 2012 +0200 2.2 +++ b/update/core-update.v2.0.12-v2.1.0.sql Sat Oct 06 23:34:03 2012 +0200 2.3 @@ -455,4 +455,13 @@ 2.4 COMMENT ON FUNCTION "delete_private_data"() IS 'Used by lf_export script. DO NOT USE on productive database, but only on a copy! This function deletes all data which should not be publicly available, and can be used to create a database dump for publication. See source code to see which data is deleted. If you need a different behaviour, copy this function and modify lf_export accordingly, to avoid data-leaks after updating.'; 2.5 2.6 2.7 +-- NOTE: The first version of the previous update script didn't 2.8 +-- remove the "vote_ratio" function. 2.9 +-- The function is therefore removed here as well, if existent. 2.10 + 2.11 +DROP FUNCTION IF EXISTS "vote_ratio" 2.12 + ( "initiative"."positive_votes"%TYPE, 2.13 + "initiative"."negative_votes"%TYPE ); 2.14 + 2.15 + 2.16 COMMIT;