Prioritizing translation imports in the queue

[Данило Шеган]

We sometimes want to move certain import queue entries to the front of the translation import queue (for instance, we've got a backlog of 60k files right now, and we want to test firefox translations packaging; in other cases, we might need a latest template for ubuntu-specific package imported asap so translators can meet a deadline).

Today we do it by executing a query similar to the following:

-- move firefox natty import queue entries to the front
update translationimportqueueentry
  set dateimported='2010-12-01' -- date before all the other entries
  from distroseries, sourcepackagename
where distroseries.id=translationimportqueueentry.distroseries and
      sourcepackagename.id=translationimportqueueentry.sourcepackagename and
      sourcepackagename.name='firefox' and distroseries.name='natty';

For a nicer implementation, we wouldn't change the dateimported like this, but provide an orthogonal priority field instead.