Launchpad itself

  1. Bug #684112
  2. Comment #11

Comment 11 for bug 684112

Revision history for this message
Julian Edwards (julian-edwards) wrote : Re: [Bug 684112] Re: Link to PPA merged owner from +archivesubscriptions is broken

On Thursday 16 December 2010 05:47:24 you wrote:
> This might be the script to run one Edwin's merge fix is released:
> -- Deactivate all archives that belong to merged users.
> -- Set archive ito DELETING and disable it.
> -- This assumes all jobs are complete.
> update archive
> set
> status = 1,
> enabled = FALSE
> from
> person p
> where
> p.id = a.owner
> and p.merged is not null
> and a.status = 0;
> ;

Almost - we need to also delete and expire all its publications.