diff options
Diffstat (limited to 'bin/rate.delete')
| -rw-r--r-- | bin/rate.delete | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/bin/rate.delete b/bin/rate.delete new file mode 100644 index 0000000..7b7e4bc --- /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 ); |