Re: Normalising UDD to some extend?
On 19/02/09 at 08:40 +0100, Andreas Tille wrote:
> I realised that UDD contains several entries in the packages
> table with only different architecture. Did I missed something
> or would it make sense to create a lookup table
> CREATE table package_architecture_lookup (
> package text,
> architecture text,
> and remove the architecture column from the packages table?
Packages can have different <put any other field here> on different
architectures, so you would lose information by doing that.
> Alternatively sources uses a space separated list in the field 'architecture'.
> IMHO the field name should rather be 'architectures'.
it's "Architecture:" in the Sources file, and we try to match the names
of the fields in Sources.
| Lucas Nussbaum
| email@example.com http://www.lucas-nussbaum.net/ |
| jabber: firstname.lastname@example.org GPG: 1024D/023B3F4F |