From: ivan <ivan>
Date: Thu, 20 Nov 2008 11:35:00 +0000 (+0000)
Subject: fill in the ratenum.  doesn't actually delete the rate itself, just all its data... 
X-Git-Tag: root_of_webpay_support~249
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=770f5f713b9b56a104fe8cf3985887bb9d3121c8

fill in the ratenum.  doesn't actually delete the rate itself, just all its data (the hard part)
---

diff --git a/bin/rate.delete b/bin/rate.delete
new file mode 100644
index 000000000..7b7e4bcf5
--- /dev/null
+++ b/bin/rate.delete
@@ -0,0 +1,3 @@
+#delete from rate_detail where ratenum = 18;
+#delete from rate_region where 0 = ( select count(*) from rate_detail where  rate_region.regionnum = rate_detail.dest_regionnum );
+#delete from rate_prefix where 0 = ( select count(*) from rate_region where rate_prefix.regionnum = rate_region.regionnum );