[arch-dev-public] Website updated- package maintainer changes

[K. Piche]

On Mon, 2010-03-29 at 20:00 -0500, Dan McGee wrote:
> On Mon, Mar 29, 2010 at 2:06 AM, Pierre Schmitz <pierre at archlinux.de> wrote:
> > Am Montag, 29. März 2010 00:01:03 schrieb Dan McGee:
> >> Let me (and the list) know if you have any questions.
> >
> > Thanks for your work! Just one suggestion: Would it be possible to chagne the
> > pacakge list view on the dev site to just operate on pkgbase and ignore the
> > different pkgnames and architectures? This would managing package assignments
> > and orphans a lot easier.
> 
> Agreed, I'll keep that in mind as I work on the website in the coming
> weeks. Until then, here is that magic list.
> 
> mysql> select count(*), r.name, p.pkgbase, username from packages p
> left join repos r on p.repo_id = r.id left join
> packages_packagerelation pr on p.pkgbase = pr.pkgbase left join
> auth_user u on pr.user_id = u.id where username is NULL and p.repo_id
> in (1,2) group by r.name, p.pkgbase, username order by r.name,
> p.pkgbase, count(*);
> +----------+-------+------------------------------------+----------+
> | count(*) | name  | pkgbase                            | username |
> +----------+-------+------------------------------------+----------+

> |        2 | Extra | gift                               | NULL     |
> |        2 | Extra | gift-fasttrack                     | NULL     |
> |        2 | Extra | gift-gnutella                      | NULL     |
> |        2 | Extra | gift-openft                        | NULL     |

I think we can safely throw these out along with bmp/bmpx if there are
no objections.

> +----------+-------+------------------------------------+----------+
> 478 rows in set (0.23 sec)

-- 
K. Piche <kpiche at rogers.com>