Merge lp:~stevenk/launchpad/db-job-json_data into lp:launchpad/db-devel

[Steve Kowalik]

Add two new columns to Job, Job.json_data and Job.job_type, to allow a new class of job that doesn't require separate DB tables.

Add two new columns to Job, Job.json_data and Job.job_type, to allow a new class of job that doesn't require separate DB tables.

[Stuart Bishop (stub)]

Ok.

This is going to make the json blobs on a lot of related tables redundant.

Seriously consider using the json datatype available in 9.1 rather than text - it will turn the blobs into actual query-able data, and may even make all the link tables redundant entirely.

review: Approve (db)

=== added file 'database/schema/patch-2209-47-0.sql'
--- database/schema/patch-2209-47-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-47-0.sql	2013-07-04 02:40:34 +0000
@@ -0,0 +1,9 @@
+-- Copyright 2013 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 job ADD COLUMN json_data TEXT;
+ALTER TABLE job ADD COLUMN job_type INTEGER;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 47, 0);