From 770f5f713b9b56a104fe8cf3985887bb9d3121c8 Mon Sep 17 00:00:00 2001
From: ivan <ivan>
Date: Thu, 20 Nov 2008 11:35:00 +0000
Subject: [PATCH] fill in the ratenum.  doesn't actually delete the rate
 itself, just all its data (the hard part)

---
 bin/rate.delete | 3 +++
 1 file changed, 3 insertions(+)
 create mode 100644 bin/rate.delete

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 );
-- 
2.20.1