Re: [Debconf-team] blanking bank information from penta

[Richard Darst <rkd@zgib.net>]

On Tue, Jun 28, 2011 at 03:40:32PM -0400, Richard Darst wrote:

> If people say "yes" I will make SQL code and get someone to apply it.

And here is the code:

BEGIN;
UPDATE person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
COMMIT;

To blank logs, too:
BEGIN;
UPDATE log.person SET iban=NULL, bic=NULL, bank_name=NULL, account_owner=NULL;
COMMIT;

It might be wise for someone who claims to know SQL (not me) check
these.  I'm also not sure if I missed something obvious here making
the code invalid...

- richard

-- 
| Richard Darst  -  rkd@          -  boltzmann: up 707 days, 17:42
|            http://rkd.zgib.net  -  pgp 0xBD356740
| "Ye shall know the truth and -- the truth shall make you free"