Merge lp:~cjwatson/launchpad/db-packageset-score into lp:launchpad/db-devel

[Colin Watson]

Add Packageset.score column.

== Summary ==

We'd like more flexible ways to control package build scores in the distribution, so that packages which are on community-flavour CDs can be prioritised above random stuff in universe even though they don't get the component bonus for main. Consensus seems to be that per-packageset scoring would be sensible.

== Proposed fix ==

Add a score column to Packageset so that a later code change can use it.

== LOC Rationale ==

+8; I'll see about offsetting this in the code change.

[Stuart Bishop (stub)]

Seems good. There are <150 rows in PackageSet at the moment, so we can afford to set the default value as part of the DB patch.

If you deal in LOC futures, this is actually +1 (if it counts at all) as we will eventually remove the DB patch and it will end up as a single new line in a new snapshot of the production database schema :-)

review: Approve (db)

[Stuart Bishop (stub)]

review: Approve

[Stuart Bishop (stub)]

review: Approve (db)

=== added file 'database/schema/patch-2209-18-0.sql'
--- database/schema/patch-2209-18-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-18-0.sql	2012-05-08 19:20:25 +0000
@@ -0,0 +1,8 @@
+-- Copyright 2012 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE Packageset ADD COLUMN score INTEGER DEFAULT 0 NOT NULL;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 18, 0);