fill in the ratenum. doesn't actually delete the rate itself, just all its data...
authorivan <ivan>
Thu, 20 Nov 2008 11:35:00 +0000 (11:35 +0000)
committerivan <ivan>
Thu, 20 Nov 2008 11:35:00 +0000 (11:35 +0000)
bin/rate.delete [new file with mode: 0644]

diff --git a/bin/rate.delete b/bin/rate.delete
new file mode 100644 (file)
index 0000000..7b7e4bc
--- /dev/null
@@ -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 );