On 12525 March 1977, Richard Darst wrote:
> Right now I would just do the main database, not the log tables,
> unless someone who knows more says that would be a good idea, too.
Dont blank logs.
--
bye, Joerg
Some AM after a mistake:
Sigh. One shouldn't AM in the early AM, as it were.
__
On Wed, Jun 29, 2011 at 06:11:11PM -0500, Gunnar Wolf wrote:
> In any case, if you do blank it, make sure we notify travel-sponsored
> people to fetch and enter that information again.
As moray pointed out, this isn't used for reimbursements anymore, and
in fact attendees can't enter, change, or
Richard Darst dijo [Tue, Jun 28, 2011 at 04:56:39PM -0400]:
> 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;
>
Richard Darst dijo [Tue, Jun 28, 2011 at 04:56:39PM -0400]:
> 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, a
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
On Tue, Jun 28, 2011 at 8:40 PM, Richard Darst wrote:
> Right now I would just do the main database, not the log tables,
> unless someone who knows more says that would be a good idea, too.
That sounds a good idea too, if it can be done safely.
For most data we have plausible reasons to keep the
Hi,
For a while I have had the idea for blanking all the bank information
in the penta database (via some sql code). This isn't used for
anything anymore, and I bet that most attendees would be willing to
enter it again in return for us not storing it. (It isn't even
attendee-visible anymore, so
