# HG changeset patch
# User jbe
# Date 1349559243 -7200
# Node ID 5c98265b39a0a060bce247eef343691cf44c1d7f
# Parent  847d59f94ceb71073f2ab9064ae35e7b515fb43f
Added missing DROP FUNCTION "vote_ratio" in update scripts

diff -r 847d59f94ceb -r 5c98265b39a0 update/core-update.v2.0.11-v2.0.12.sql
--- a/update/core-update.v2.0.11-v2.0.12.sql	Fri Oct 05 13:45:37 2012 +0200
+++ b/update/core-update.v2.0.11-v2.0.12.sql	Sat Oct 06 23:34:03 2012 +0200
@@ -306,4 +306,8 @@
     END;
   $$;
 
+DROP FUNCTION IF EXISTS "vote_ratio"
+  ( "initiative"."positive_votes"%TYPE,
+    "initiative"."negative_votes"%TYPE );
+
 COMMIT;
diff -r 847d59f94ceb -r 5c98265b39a0 update/core-update.v2.0.12-v2.1.0.sql
--- a/update/core-update.v2.0.12-v2.1.0.sql	Fri Oct 05 13:45:37 2012 +0200
+++ b/update/core-update.v2.0.12-v2.1.0.sql	Sat Oct 06 23:34:03 2012 +0200
@@ -455,4 +455,13 @@
 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.';
 
 
+-- NOTE: The first version of the previous update script didn't
+-- remove the "vote_ratio" function.
+-- The function is therefore removed here as well, if existent.
+
+DROP FUNCTION IF EXISTS "vote_ratio"
+  ( "initiative"."positive_votes"%TYPE,
+    "initiative"."negative_votes"%TYPE );
+
+
 COMMIT;