diff options
author | Judd Vinet <judd@archlinux.org> | 2004-05-06 04:27:40 +0200 |
---|---|---|
committer | Judd Vinet <judd@archlinux.org> | 2004-05-06 04:27:40 +0200 |
commit | af7a8885d8095ac78c8d4f4a5f183bb038c5e17a (patch) | |
tree | ef47297c0aacd875f3c54de0ab2844e9161366f9 | |
parent | 985b10cd15a230a461a8482de6b7fe134c0046e3 (diff) | |
download | dbscripts-af7a8885d8095ac78c8d4f4a5f183bb038c5e17a.tar.gz dbscripts-af7a8885d8095ac78c8d4f4a5f183bb038c5e17a.tar.xz |
fixed package deletion with new todolist_pkgs table
-rwxr-xr-x | pkgdb | 5 |
1 files changed, 4 insertions, 1 deletions
@@ -1,5 +1,5 @@ #!/bin/bash -# $Id: pkgdb,v 1.13 2004/05/06 01:39:42 judd Exp $ +# $Id: pkgdb,v 1.14 2004/05/06 02:27:40 judd Exp $ tl=`pwd` @@ -25,6 +25,9 @@ deletepkg() mysql -u $dbuser -p$dbpass $dbname <<_EOF DELETE FROM packages WHERE id='$id'; _EOF + mysql -u $dbuser -p$dbpass $dbname <<_EOF +DELETE FROM todolist_pkgs WHERE pkgid='$id'; +_EOF } updatepkg() |