projects
/
freeside.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
| inline |
side by side
(parent:
3c65248
)
fill in the ratenum. doesn't actually delete the rate itself, just all its data...
author
ivan
<ivan>
Thu, 20 Nov 2008 11:35:00 +0000
(11:35 +0000)
committer
ivan
<ivan>
Thu, 20 Nov 2008 11:35:00 +0000
(11:35 +0000)
bin/rate.delete
[new file with mode: 0644]
patch
|
blob
diff --git a/bin/rate.delete
b/bin/rate.delete
new file mode 100644
(file)
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 );