diff options
author | ivan <ivan> | 2008-11-20 11:35:00 +0000 |
---|---|---|
committer | ivan <ivan> | 2008-11-20 11:35:00 +0000 |
commit | 770f5f713b9b56a104fe8cf3985887bb9d3121c8 (patch) | |
tree | 13557332535ff8e00fde9454f61754eae46038ba /bin | |
parent | 3c652480dea69c3191b968fe0c4101d6fd6aab45 (diff) |
fill in the ratenum. doesn't actually delete the rate itself, just all its data (the hard part)
Diffstat (limited to 'bin')
-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 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 ); |