[Qa-debsources] patch-tracker DB schema

[Orestis Ioannou]

Hey,

On 03/12/2016 09:48 AM, Stefano Zacchiroli wrote:

>> With an index on source_package_id
>> and maybe an index on name as well so we can search a patch fast?
> 
> Looks good to me.
> 
> I think you will also want an UNIQUE constraint on (source_package_id,
> name), to avoid multiple patches with the same name on the same source
> package.
> 

ack

> Finally, don't we need an extra "order" column here? Otherwise how do we
> know the order in which patches are applied? (*Some* source package
> formats forces an alphabetical ordering---which maintainers then build
> upon using 00, 01, 02, etc---but not *all* of them do.)
> 

I was thinking reading the file series to do that on each request like
what we do now. But if you prefer adding that info in the DB then yeap
we need that column as well.

Cheers,

Orestis