From: Kevin C. <ke...@us...> - 2005-04-25 14:25:03
|
Update of /cvsroot/mailmanager/mailmanager/sql In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22832/sql Modified Files: Tag: db-backend deleteCustomer.zsql Log Message: Delete Customer now also removes their registered email addresses Index: deleteCustomer.zsql =================================================================== RCS file: /cvsroot/mailmanager/mailmanager/sql/Attic/deleteCustomer.zsql,v retrieving revision 1.1.2.1 retrieving revision 1.1.2.2 diff -u -d -r1.1.2.1 -r1.1.2.2 --- deleteCustomer.zsql 21 Apr 2005 19:59:58 -0000 1.1.2.1 +++ deleteCustomer.zsql 25 Apr 2005 14:24:26 -0000 1.1.2.2 @@ -3,5 +3,8 @@ connection_id:mailmanager_db arguments:username </dtml-comment> +DELETE FROM <dtml-var schema>mm_customer_email +WHERE <dtml-sqltest username type="nb"> +<dtml-var sql_delimiter> DELETE FROM <dtml-var schema>mm_customer WHERE <dtml-sqltest username type="nb"> |