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

1 files changed, 3 insertions, 0 deletions

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