Merge lp:~stevenk/launchpad/db-no-not-null-pf into lp:launchpad/db-devel

[Steve Kowalik]

Set NOT NULL on Processor.restricted, DistroArchSeries.processor and ArchiveArch.processor; drop NOT NULL on the obsolete columns.

Now that the new columns have been added and populated, we can update sampledata, SET NOT NULL on the new columns, and DROP NOT NULL on the old columns in preparation for the next branch which will stop setting them.

[Stuart Bishop (stub)]

No probs.

review: Approve (db)

=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2013-07-23 08:46:17 +0000
+++ database/sampledata/current-dev.sql	2013-09-19 01:08:29 +0000
@@ -1,6 +1,6 @@
 -- Copyright 2010-2013 Canonical Ltd.  This software is licensed under the
 -- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 9.1.4
+-- Created using pg_dump (PostgreSQL) 9.1.9
 
 SET check_function_bodies = false;
 SET client_encoding = 'UTF8';
@@ -12,750 +12,6 @@
 SET search_path = public, pg_catalog;
 
 
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
 SET SESSION AUTHORIZATION DEFAULT;
 
 ALTER TABLE account DISABLE TRIGGER ALL;
@@ -1725,16 +981,26 @@
 ALTER TABLE processorfamily ENABLE TRIGGER ALL;
 
 
+ALTER TABLE processor DISABLE TRIGGER ALL;
+
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (1, 1, '386', 'Intel 386', 'Intel 386 and its many derivatives and clones, the basic 32-bit chip in the x86 family', false);
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (2, 3, 'amd64', 'AMD 64bit', 'AMD 64bit', false);
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (3, 4, 'hppa', 'HPPA Processor', 'HPPA Processor', false);
+
+
+ALTER TABLE processor ENABLE TRIGGER ALL;
+
+
 ALTER TABLE distroarchseries DISABLE TRIGGER ALL;
 
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (1, 1, 1, 'i386', 1, true, 5, '2006-10-16 18:31:43.454475', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (6, 3, 1, 'i386', 1, true, 1, '2006-10-16 18:31:43.456532', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (7, 6, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457028', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (8, 10, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457484', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (9, 13, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457938', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (10, 13, 3, 'amd64', 1, true, 0, '2006-10-16 18:31:43.458434', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (11, 3, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.458892', false, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (12, 1, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.459349', false, true);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (1, 1, 1, 'i386', 1, true, 5, '2006-10-16 18:31:43.454475', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (6, 3, 1, 'i386', 1, true, 1, '2006-10-16 18:31:43.456532', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (7, 6, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457028', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (8, 10, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457484', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (9, 13, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457938', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (10, 13, 3, 'amd64', 1, true, 0, '2006-10-16 18:31:43.458434', true, true, 2);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (11, 3, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.458892', false, true, 3);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (12, 1, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.459349', false, true, 3);
 
 
 ALTER TABLE distroarchseries ENABLE TRIGGER ALL;
@@ -2117,6 +1383,9 @@
 ALTER TABLE accessartifact ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE accessartifactgrant DISABLE TRIGGER ALL;
 
 INSERT INTO accessartifactgrant (artifact, grantee, grantor, date_created) VALUES (1, 14, 65, '2007-08-09 11:39:16.836856');
@@ -2203,6 +1472,9 @@
 ALTER TABLE accesspolicy ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE accesspolicyartifact DISABLE TRIGGER ALL;
 
 INSERT INTO accesspolicyartifact (artifact, policy) VALUES (1, 2);
@@ -2235,6 +1507,12 @@
 ALTER TABLE accesspolicygrantflat ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE announcement DISABLE TRIGGER ALL;
 
 INSERT INTO announcement (id, date_created, date_announced, registrant, product, distribution, project, title, summary, url, active, date_updated) VALUES (1, '2007-11-25 00:44:32.186178', '2007-11-20 03:00:00', 1, NULL, 1, NULL, 'Every Macedonian Student to Use Ubuntu-Powered Computer Workstations', 'The Macedonia Ministry of Education and Science will deploy more than 180,000 workstations running Canonical’s Edubuntu 7.04 as part of its "Computer for Every Child" project.', 'http://www.ubuntu.com/news/macedonia-school-computers', true, NULL);
@@ -2292,6 +1570,9 @@
 ALTER TABLE announcement ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE answercontact DISABLE TRIGGER ALL;
 
 INSERT INTO answercontact (id, product, distribution, sourcepackagename, person, date_created) VALUES (1, NULL, 1, 1, 16, '2007-03-14 20:07:25.233772');
@@ -2303,10 +1584,13 @@
 ALTER TABLE answercontact ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE job DISABLE TRIGGER ALL;
 
-INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL);
-INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished) VALUES (2, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 10:14:12.820778', NULL, NULL);
+INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL, NULL, NULL);
+INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (2, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 10:14:12.820778', NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE job ENABLE TRIGGER ALL;
@@ -2326,6 +1610,9 @@
 ALTER TABLE apportjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE gpgkey DISABLE TRIGGER ALL;
 
 INSERT INTO gpgkey (id, owner, keyid, fingerprint, active, algorithm, keysize, can_encrypt, date_created) VALUES (1, 16, '12345678', 'ABCDEF0123456789ABCDDCBA0000111112345678', true, 17, 1024, true, '2006-10-16 18:31:43.631499');
@@ -2355,6 +1642,9 @@
 ALTER TABLE archive ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivearch DISABLE TRIGGER ALL;
 
 
@@ -2362,6 +1652,9 @@
 ALTER TABLE archivearch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archiveauthtoken DISABLE TRIGGER ALL;
 
 
@@ -2369,6 +1662,9 @@
 ALTER TABLE archiveauthtoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE component DISABLE TRIGGER ALL;
 
 INSERT INTO component (id, name, description) VALUES (1, 'main', NULL);
@@ -2388,6 +1684,9 @@
 ALTER TABLE archivedependency ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -2395,6 +1694,9 @@
 ALTER TABLE archivejob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagesetgroup DISABLE TRIGGER ALL;
 
 
@@ -2433,6 +1735,9 @@
 ALTER TABLE archivepermission ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivesubscriber DISABLE TRIGGER ALL;
 
 
@@ -2440,14 +1745,7 @@
 ALTER TABLE archivesubscriber ENABLE TRIGGER ALL;
 
 
-ALTER TABLE processor DISABLE TRIGGER ALL;
-
-INSERT INTO processor (id, family, name, title, description) VALUES (1, 1, '386', 'Intel 386', 'Intel 386 and its many derivatives and clones, the basic 32-bit chip in the x86 family');
-INSERT INTO processor (id, family, name, title, description) VALUES (2, 3, 'amd64', 'AMD 64bit', 'AMD 64bit');
-INSERT INTO processor (id, family, name, title, description) VALUES (3, 4, 'hppa', 'HPPA Processor', 'HPPA Processor');
-
-
-ALTER TABLE processor ENABLE TRIGGER ALL;
+
 
 
 ALTER TABLE builder DISABLE TRIGGER ALL;
@@ -2714,6 +2012,9 @@
 ALTER TABLE binarypackagebuild ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE binarypackagename DISABLE TRIGGER ALL;
 
 INSERT INTO binarypackagename (id, name) VALUES (6, 'foobar');
@@ -2767,6 +2068,12 @@
 ALTER TABLE binarypackagefile ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE binarypackagepath DISABLE TRIGGER ALL;
 
 
@@ -2774,6 +2081,9 @@
 ALTER TABLE binarypackagepath ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE binarypackagepublishinghistory DISABLE TRIGGER ALL;
 
 INSERT INTO binarypackagepublishinghistory (id, binarypackagerelease, distroarchseries, status, component, section, priority, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, binarypackagename, phased_update_percentage) VALUES (9, 12, 1, 2, 1, 1, 10, '2005-05-05 00:00:00', '2005-06-18 00:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, 8, NULL);
@@ -2807,6 +2117,12 @@
 ALTER TABLE binarypackagepublishinghistory ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE binarypackagereleasecontents DISABLE TRIGGER ALL;
 
 
@@ -3082,6 +2398,12 @@
 ALTER TABLE binarypackagereleasedownloadcount ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE branchjob DISABLE TRIGGER ALL;
 
 
@@ -3089,6 +2411,9 @@
 ALTER TABLE branchjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE branchmergeproposal DISABLE TRIGGER ALL;
 
 
@@ -3096,6 +2421,9 @@
 ALTER TABLE branchmergeproposal ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE branchmergeproposaljob DISABLE TRIGGER ALL;
 
 
@@ -3103,6 +2431,12 @@
 ALTER TABLE branchmergeproposaljob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE revisionauthor DISABLE TRIGGER ALL;
 
 INSERT INTO revisionauthor (id, name, email, person) VALUES (1, 'mark.shuttleworth', NULL, NULL);
@@ -3179,6 +2513,12 @@
 ALTER TABLE branchsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugactivity DISABLE TRIGGER ALL;
 
 INSERT INTO bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (1, 1, '2004-09-24 00:00:00', 1, 'title', 'A silly problem', 'An odd problem', 'Decided problem wasn''t silly after all');
@@ -3222,6 +2562,9 @@
 ALTER TABLE bugactivity ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugaffectsperson DISABLE TRIGGER ALL;
 
 
@@ -3229,6 +2572,9 @@
 ALTER TABLE bugaffectsperson ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE message DISABLE TRIGGER ALL;
 
 INSERT INTO message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible) VALUES (1, '2004-09-24 20:58:04.684057', 'PEBCAK', 16, NULL, NULL, '[e-mail]-332342--1231', NULL, NULL, true);
@@ -3294,6 +2640,9 @@
 ALTER TABLE bugattachment ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugbranch DISABLE TRIGGER ALL;
 
 INSERT INTO bugbranch (id, datecreated, bug, branch, revision_hint, whiteboard, registrant) VALUES (1, '2006-03-22 18:44:27.438982', 5, 1, NULL, NULL, 12);
@@ -3304,6 +2653,9 @@
 ALTER TABLE bugbranch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE cve DISABLE TRIGGER ALL;
 
 INSERT INTO cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
@@ -3330,6 +2682,9 @@
 ALTER TABLE bugcve ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugwatch DISABLE TRIGGER ALL;
 
 INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
@@ -3392,6 +2747,9 @@
 ALTER TABLE bugmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugmute DISABLE TRIGGER ALL;
 
 
@@ -3410,6 +2768,9 @@
 ALTER TABLE bugnomination ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotification DISABLE TRIGGER ALL;
 
 
@@ -3417,6 +2778,9 @@
 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
 
 
@@ -3431,6 +2795,9 @@
 ALTER TABLE bugnotificationattachment ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE structuralsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO structuralsubscription (id, product, productseries, project, milestone, distribution, distroseries, sourcepackagename, subscriber, subscribed_by, date_created, date_last_updated) VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, 1, 16, 16, '2008-01-29 15:12:34.581468', '2008-01-29 15:12:34.581468');
@@ -3467,6 +2834,9 @@
 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
 
 
@@ -3496,6 +2866,12 @@
 ALTER TABLE bugsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugsubscriptionfilterimportance DISABLE TRIGGER ALL;
 
 
@@ -3531,6 +2907,9 @@
 ALTER TABLE bugsubscriptionfiltertag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugsummary DISABLE TRIGGER ALL;
 
 INSERT INTO bugsummary (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy) VALUES (65, 1, 20, NULL, NULL, NULL, NULL, 14, 'lunch-money', 10, NULL, 5, false, NULL);
@@ -3604,6 +2983,9 @@
 ALTER TABLE bugsummary ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugsummaryjournal DISABLE TRIGGER ALL;
 
 
@@ -3611,6 +2993,9 @@
 ALTER TABLE bugsummaryjournal ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtag DISABLE TRIGGER ALL;
 
 INSERT INTO bugtag (id, bug, tag) VALUES (1, 9, 'crash');
@@ -3626,6 +3011,9 @@
 ALTER TABLE bugtag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtask DISABLE TRIGGER ALL;
 
 INSERT INTO bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
@@ -3661,6 +3049,9 @@
 ALTER TABLE bugtask ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
 
 INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL);
@@ -3696,6 +3087,9 @@
 ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
 
 INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
@@ -3707,6 +3101,9 @@
 ALTER TABLE bugtrackeralias ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtrackercomponentgroup DISABLE TRIGGER ALL;
 
 
@@ -3721,6 +3118,12 @@
 ALTER TABLE bugtrackercomponent ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugtrackerperson DISABLE TRIGGER ALL;
 
 
@@ -3728,6 +3131,12 @@
 ALTER TABLE bugtrackerperson ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugwatchactivity DISABLE TRIGGER ALL;
 
 
@@ -3735,6 +3144,15 @@
 ALTER TABLE bugwatchactivity ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE buildpackagejob DISABLE TRIGGER ALL;
 
 INSERT INTO buildpackagejob (id, job, build) VALUES (1, 1, 8);
@@ -3744,6 +3162,9 @@
 ALTER TABLE buildpackagejob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE buildqueue DISABLE TRIGGER ALL;
 
 INSERT INTO buildqueue (id, builder, logtail, lastscore, manual, job, job_type, estimated_duration, processor, virtualized) VALUES (1, 1, 'Dummy sampledata entry, not processing', 1, false, 1, 1, '00:00:00', 1, false);
@@ -3753,6 +3174,9 @@
 ALTER TABLE buildqueue ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimport DISABLE TRIGGER ALL;
 
 INSERT INTO codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk');
@@ -3762,6 +3186,9 @@
 ALTER TABLE codeimport ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimportmachine DISABLE TRIGGER ALL;
 
 INSERT INTO codeimportmachine (id, date_created, hostname, state, heartbeat) VALUES (1, '2007-08-02 16:36:17.817407', 'bazaar-importer', 20, NULL);
@@ -3777,6 +3204,9 @@
 ALTER TABLE codeimportevent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimporteventdata DISABLE TRIGGER ALL;
 
 
@@ -3784,6 +3214,9 @@
 ALTER TABLE codeimporteventdata ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimportjob DISABLE TRIGGER ALL;
 
 INSERT INTO codeimportjob (id, date_created, code_import, machine, date_due, state, requesting_user, ordering, heartbeat, logtail, date_started) VALUES (1, '2007-12-05 16:07:57.276112', 1, NULL, '2007-12-05 16:07:57.276112', 10, NULL, NULL, NULL, NULL, NULL);
@@ -3792,6 +3225,12 @@
 ALTER TABLE codeimportjob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE codeimportresult DISABLE TRIGGER ALL;
 
 
@@ -3799,6 +3238,9 @@
 ALTER TABLE codeimportresult ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codereviewmessage DISABLE TRIGGER ALL;
 
 
@@ -3806,6 +3248,9 @@
 ALTER TABLE codereviewmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codereviewvote DISABLE TRIGGER ALL;
 
 
@@ -3813,6 +3258,9 @@
 ALTER TABLE codereviewvote ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE commercialsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2022-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
@@ -3822,6 +3270,12 @@
 ALTER TABLE commercialsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE componentselection DISABLE TRIGGER ALL;
 
 INSERT INTO componentselection (id, distroseries, component, date_created) VALUES (1, 3, 1, '2006-10-16 18:31:43.257508');
@@ -3843,6 +3297,15 @@
 ALTER TABLE componentselection ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE customlanguagecode DISABLE TRIGGER ALL;
 
 
@@ -3850,6 +3313,12 @@
 ALTER TABLE customlanguagecode ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE cvereference DISABLE TRIGGER ALL;
 
 INSERT INTO cvereference (id, cve, source, content, url, date_created) VALUES (1, 1, 'NAI', 'Known problem #234234', 'http://nai.com/testing/foobar/', '2006-10-16 18:31:43.386902');
@@ -3895,6 +3364,9 @@
 ALTER TABLE cvereference ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE databasecpustats DISABLE TRIGGER ALL;
 
 
@@ -3930,6 +3402,12 @@
 ALTER TABLE diff ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE distributionjob DISABLE TRIGGER ALL;
 
 
@@ -3937,6 +3415,9 @@
 ALTER TABLE distributionjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionmirror DISABLE TRIGGER ALL;
 
 INSERT INTO distributionmirror (id, distribution, name, http_base_url, ftp_base_url, rsync_base_url, displayname, description, owner, speed, country, content, official_candidate, enabled, date_created, whiteboard, status, date_reviewed, reviewer, country_dns_mirror) VALUES (1, 1, 'archive-mirror', 'http://localhost:11375/valid-mirror/', NULL, NULL, NULL, NULL, 1, 10, 75, 1, true, true, '2006-10-16 18:31:43.434567', NULL, 30, NULL, NULL, false);
@@ -3954,6 +3435,9 @@
 ALTER TABLE distributionmirror ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
 
 
@@ -3961,6 +3445,9 @@
 ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionsourcepackagecache DISABLE TRIGGER ALL;
 
 INSERT INTO distributionsourcepackagecache (id, distribution, sourcepackagename, name, binpkgnames, binpkgsummaries, binpkgdescriptions, fti, changelog, archive) VALUES (1, 3, 19, 'alsa-utils', '', '', '', NULL, NULL, 1);
@@ -3989,6 +3476,15 @@
 ALTER TABLE distributionsourcepackagecache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE packagediff DISABLE TRIGGER ALL;
 
 INSERT INTO packagediff (id, date_requested, requester, from_source, to_source, date_fulfilled, diff_content, status) VALUES (1, '2011-03-22 13:27:38.178011', 16, 43, 40, NULL, NULL, 0);
@@ -4008,6 +3504,9 @@
 ALTER TABLE distroseriesdifference ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriesdifferencemessage DISABLE TRIGGER ALL;
 
 INSERT INTO distroseriesdifferencemessage (id, distro_series_difference, message) VALUES (1, 1, 50);
@@ -4018,6 +3517,9 @@
 ALTER TABLE distroseriesdifferencemessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroserieslanguage DISABLE TRIGGER ALL;
 
 INSERT INTO distroserieslanguage (id, distroseries, language, currentcount, updatescount, rosettacount, contributorcount, dateupdated, unreviewed_count) VALUES (1, 3, 68, 62, 0, 0, 1, '2007-01-15 17:58:40.839938', 0);
@@ -4044,6 +3546,9 @@
 ALTER TABLE distroserieslanguage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriespackagecache DISABLE TRIGGER ALL;
 
 INSERT INTO distroseriespackagecache (id, distroseries, binarypackagename, name, summary, description, summaries, descriptions, fti, archive) VALUES (1, 3, 13, 'pmount', 'pmount shortdesc', 'pmount description', 'pmount shortdesc', 'pmount description', NULL, 1);
@@ -4057,6 +3562,9 @@
 ALTER TABLE distroseriespackagecache ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriesparent DISABLE TRIGGER ALL;
 
 
@@ -4064,6 +3572,9 @@
 ALTER TABLE distroseriesparent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
 
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, '[e-mail]', 1, 4, '2006-10-16 18:31:43.540582');
@@ -4151,6 +3662,9 @@
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE faq DISABLE TRIGGER ALL;
 
 INSERT INTO faq (id, title, tags, content, product, distribution, owner, date_created, last_updated_by, date_last_updated, fti) VALUES (1, 'Wireless Networking Documentation', 'wifi', 'Installation instructions for many wireless cards can be found at:
@@ -4217,6 +3731,9 @@
 ALTER TABLE faq ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE pillarname DISABLE TRIGGER ALL;
 
 INSERT INTO pillarname (id, name, product, project, distribution, active, alias_for) VALUES (1, 'ubuntu', NULL, NULL, 1, true, NULL);
@@ -4281,6 +3798,9 @@
 ALTER TABLE featuredproject ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE featureflag DISABLE TRIGGER ALL;
 
 INSERT INTO featureflag (scope, priority, flag, value, date_modified) VALUES ('default', 0, 'js.combo_loader.enabled', 'true', '2012-05-18 07:34:39.239649');
@@ -4298,6 +3818,9 @@
 ALTER TABLE featureflagchangelogentry ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE flatpackagesetinclusion DISABLE TRIGGER ALL;
 
 
@@ -4310,6 +3833,12 @@
 
 
 
+
+
+
+
+
+
 ALTER TABLE garbojobstate DISABLE TRIGGER ALL;
 
 
@@ -4317,6 +3846,9 @@
 ALTER TABLE garbojobstate ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwvendorname DISABLE TRIGGER ALL;
 
 INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI');
@@ -4357,6 +3889,9 @@
 ALTER TABLE hwdevice ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdeviceclass DISABLE TRIGGER ALL;
 
 
@@ -4364,6 +3899,9 @@
 ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdriver DISABLE TRIGGER ALL;
 
 INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL);
@@ -4403,6 +3941,9 @@
 ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdevicenamevariant DISABLE TRIGGER ALL;
 
 
@@ -4410,6 +3951,9 @@
 ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL;
 
 INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600');
@@ -4435,6 +3979,9 @@
 ALTER TABLE hwdmihandle ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdmivalue DISABLE TRIGGER ALL;
 
 
@@ -4442,6 +3989,15 @@
 ALTER TABLE hwdmivalue ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE hwsubmissionbug DISABLE TRIGGER ALL;
 
 
@@ -4449,6 +4005,9 @@
 ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL;
 
 INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11);
@@ -4477,6 +4036,12 @@
 ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE hwtest DISABLE TRIGGER ALL;
 
 
@@ -4484,6 +4049,9 @@
 ALTER TABLE hwtest ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswerchoice DISABLE TRIGGER ALL;
 
 
@@ -4498,6 +4066,12 @@
 ALTER TABLE hwtestanswer ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE hwtestanswercount DISABLE TRIGGER ALL;
 
 
@@ -4505,6 +4079,9 @@
 ALTER TABLE hwtestanswercount ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswercountdevice DISABLE TRIGGER ALL;
 
 
@@ -4512,6 +4089,9 @@
 ALTER TABLE hwtestanswercountdevice ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswerdevice DISABLE TRIGGER ALL;
 
 
@@ -4519,6 +4099,15 @@
 ALTER TABLE hwtestanswerdevice ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE incrementaldiff DISABLE TRIGGER ALL;
 
 
@@ -4526,6 +4115,9 @@
 ALTER TABLE incrementaldiff ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE ircid DISABLE TRIGGER ALL;
 
 INSERT INTO ircid (id, person, network, nickname) VALUES (1, 1, 'irc.freenode.net', 'mark');
@@ -4542,6 +4134,9 @@
 ALTER TABLE ircid ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE jabberid DISABLE TRIGGER ALL;
 
 INSERT INTO jabberid (id, person, jabberid) VALUES (1, 1, '[e-mail]');
@@ -4559,6 +4154,12 @@
 ALTER TABLE jabberid ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmacategory DISABLE TRIGGER ALL;
 
 INSERT INTO karmacategory (id, name, title, summary) VALUES (2, 'bugs', 'Bug Management', 'This karma category covers work in the Malone bug tracking system, such as filing, closing and otherwise working with bugs.');
@@ -4711,6 +4312,12 @@
 ALTER TABLE karma ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmacache DISABLE TRIGGER ALL;
 
 INSERT INTO karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
@@ -4776,6 +4383,12 @@
 ALTER TABLE karmacache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmatotalcache DISABLE TRIGGER ALL;
 
 INSERT INTO karmatotalcache (id, person, karma_total) VALUES (78, 12, 138);
@@ -4787,6 +4400,12 @@
 ALTER TABLE karmatotalcache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE languagepack DISABLE TRIGGER ALL;
 
 INSERT INTO languagepack (id, file, date_exported, date_last_used, distroseries, type, updates) VALUES (1, 71, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', 3, 1, NULL);
@@ -4798,6 +4417,9 @@
 ALTER TABLE languagepack ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagecopyjob DISABLE TRIGGER ALL;
 
 
@@ -4908,6 +4530,9 @@
 ALTER TABLE latestpersonsourcepackagereleasecache ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE launchpaddatabaserevision DISABLE TRIGGER ALL;
 
 
@@ -4922,6 +4547,9 @@
 ALTER TABLE launchpaddatabaseupdatelog ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE launchpadstatistic DISABLE TRIGGER ALL;
 
 INSERT INTO launchpadstatistic (id, name, value, dateupdated) VALUES (1, 'potemplate_count', 10, '2007-03-18 17:27:46.221219');
@@ -4955,6 +4583,15 @@
 ALTER TABLE launchpadstatistic ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE libraryfiledownloadcount DISABLE TRIGGER ALL;
 
 
@@ -4962,6 +4599,9 @@
 ALTER TABLE libraryfiledownloadcount ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE logintoken DISABLE TRIGGER ALL;
 
 INSERT INTO logintoken (id, requester, requesteremail, email, created, tokentype, token, fingerprint, redirection_url, date_consumed) VALUES (1, NULL, NULL, '[e-mail]', '2008-06-27 14:48:38.308457', 3, 'mzsJ6LBvNKjFqP1Csfw7', NULL, 'http://launchpad.dev', '2008-06-27 14:49:11.149508');
@@ -4971,6 +4611,9 @@
 ALTER TABLE logintoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE lp_account DISABLE TRIGGER ALL;
 
 INSERT INTO lp_account (id, openid_identifier) VALUES (11, 'mark_oid');
@@ -5450,6 +5093,9 @@
 ALTER TABLE mailinglist ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mailinglistsubscription DISABLE TRIGGER ALL;
 
 
@@ -5457,6 +5103,9 @@
 ALTER TABLE mailinglistsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mergedirectivejob DISABLE TRIGGER ALL;
 
 
@@ -5464,6 +5113,12 @@
 ALTER TABLE mergedirectivejob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE messageapproval DISABLE TRIGGER ALL;
 
 
@@ -5471,6 +5126,9 @@
 ALTER TABLE messageapproval ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE messagechunk DISABLE TRIGGER ALL;
 
 INSERT INTO messagechunk (id, message, sequence, content, blob, fti) VALUES (1, 7, 1, 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', NULL, NULL);
@@ -5924,6 +5582,12 @@
 ALTER TABLE messagechunk ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE milestonetag DISABLE TRIGGER ALL;
 
 
@@ -5931,6 +5595,9 @@
 ALTER TABLE milestonetag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirror DISABLE TRIGGER ALL;
 
 
@@ -5938,6 +5605,9 @@
 ALTER TABLE mirror ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorcdimagedistroseries DISABLE TRIGGER ALL;
 
 INSERT INTO mirrorcdimagedistroseries (id, distribution_mirror, distroseries, flavour, date_created) VALUES (1, 6, 1, 'ubuntu', '2006-10-16 18:31:44.303183');
@@ -5949,6 +5619,9 @@
 ALTER TABLE mirrorcdimagedistroseries ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorcontent DISABLE TRIGGER ALL;
 
 
@@ -5956,6 +5629,9 @@
 ALTER TABLE mirrorcontent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrordistroarchseries DISABLE TRIGGER ALL;
 
 INSERT INTO mirrordistroarchseries (id, distribution_mirror, distroarchseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 2, 10, 1, '2006-10-16 18:31:44.309753');
@@ -5967,6 +5643,9 @@
 ALTER TABLE mirrordistroarchseries ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrordistroseriessource DISABLE TRIGGER ALL;
 
 INSERT INTO mirrordistroseriessource (id, distribution_mirror, distroseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 1, 10, 1, '2006-10-16 18:31:44.314175');
@@ -5979,6 +5658,9 @@
 ALTER TABLE mirrordistroseriessource ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorproberecord DISABLE TRIGGER ALL;
 
 INSERT INTO mirrorproberecord (id, distribution_mirror, log_file, date_created) VALUES (1, 6, 46, '2006-05-24 17:11:59.37369');
@@ -5988,6 +5670,9 @@
 ALTER TABLE mirrorproberecord ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorsourcecontent DISABLE TRIGGER ALL;
 
 
@@ -5995,6 +5680,9 @@
 ALTER TABLE mirrorsourcecontent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE nameblacklist DISABLE TRIGGER ALL;
 
 INSERT INTO nameblacklist (id, regexp, comment, admin) VALUES (1, 'blacklist', 'For testing purposes', NULL);
@@ -6004,6 +5692,9 @@
 ALTER TABLE nameblacklist ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE oauthconsumer DISABLE TRIGGER ALL;
 
 INSERT INTO oauthconsumer (id, date_created, disabled, key, secret) VALUES (1, '2008-03-18 20:57:19.108004', false, 'foobar123451432', '');
@@ -6023,6 +5714,12 @@
 ALTER TABLE oauthaccesstoken ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE oauthnonce DISABLE TRIGGER ALL;
 
 
@@ -6037,6 +5734,9 @@
 ALTER TABLE oauthrequesttoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE officialbugtag DISABLE TRIGGER ALL;
 
 
@@ -6044,6 +5744,9 @@
 ALTER TABLE officialbugtag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE openidconsumerassociation DISABLE TRIGGER ALL;
 
 
@@ -6133,6 +5836,9 @@
 ALTER TABLE openididentifier ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagecopyrequest DISABLE TRIGGER ALL;
 
 
@@ -6140,6 +5846,18 @@
 ALTER TABLE packagecopyrequest ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
+
+
+
 ALTER TABLE packagesetinclusion DISABLE TRIGGER ALL;
 
 
@@ -6147,6 +5865,9 @@
 ALTER TABLE packagesetinclusion ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagesetsources DISABLE TRIGGER ALL;
 
 
@@ -6154,6 +5875,12 @@
 ALTER TABLE packagesetsources ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE packageuploadbuild DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadbuild (id, packageupload, build, date_created) VALUES (1, 1, 18, '2006-10-16 18:31:43.529327');
@@ -6164,6 +5891,9 @@
 ALTER TABLE packageuploadbuild ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packageuploadcustom DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadcustom (id, packageupload, customformat, libraryfilealias, date_created) VALUES (1, 5, 1, 1, '2006-10-16 18:31:43.532702');
@@ -6175,6 +5905,9 @@
 ALTER TABLE packageuploadcustom ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packageuploadsource DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadsource (id, packageupload, sourcepackagerelease, date_created) VALUES (1, 3, 17, '2006-10-16 18:31:43.536296');
@@ -6190,6 +5923,9 @@
 ALTER TABLE packageuploadsource ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packaging DISABLE TRIGGER ALL;
 
 INSERT INTO packaging (packaging, id, sourcepackagename, distroseries, productseries, datecreated, owner, date_created) VALUES (1, 1, 1, 3, 2, '2005-07-05 14:20:26.577312', NULL, '2006-10-16 18:31:44.336247');
@@ -6206,6 +5942,9 @@
 ALTER TABLE packaging ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE potemplate DISABLE TRIGGER ALL;
 
 INSERT INTO potemplate (id, priority, description, copyright, datecreated, path, iscurrent, messagecount, owner, sourcepackagename, distroseries, sourcepackageversion, header, binarypackagename, languagepack, productseries, from_sourcepackagename, date_last_updated, source_file, source_file_format, name, translation_domain) VALUES (1, 0, 'Template for evolution in hoary', NULL, '2005-03-18 18:20:12.273149', 'po/evolution-2.2.pot', true, 22, 30, NULL, NULL, NULL, 'Project-Id-Version: PACKAGE VERSION
@@ -6319,6 +6058,9 @@
 ALTER TABLE packagingjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE parsedapachelog DISABLE TRIGGER ALL;
 
 
@@ -6326,6 +6068,12 @@
 ALTER TABLE parsedapachelog ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE personlanguage DISABLE TRIGGER ALL;
 
 INSERT INTO personlanguage (id, person, language, date_created) VALUES (1, 13, 387, '2006-10-16 18:31:44.536264');
@@ -6343,6 +6091,9 @@
 ALTER TABLE personlanguage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE personlocation DISABLE TRIGGER ALL;
 
 INSERT INTO personlocation (id, date_created, person, latitude, longitude, time_zone, last_modified_by, date_last_modified, visible, locked) VALUES (1, '2007-06-05 18:34:52.127945', 12, NULL, NULL, 'Australia/Perth', 12, '2007-06-05 18:34:52.127945', true, false);
@@ -6356,6 +6107,9 @@
 ALTER TABLE personlocation ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE personnotification DISABLE TRIGGER ALL;
 
 
@@ -6363,6 +6117,9 @@
 ALTER TABLE personnotification ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE personsettings DISABLE TRIGGER ALL;
 
 INSERT INTO personsettings (person, selfgenerated_bugnotifications) VALUES (1, true);
@@ -6472,6 +6229,12 @@
 ALTER TABLE persontransferjob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE pocketchroot DISABLE TRIGGER ALL;
 
 
@@ -6479,6 +6242,9 @@
 ALTER TABLE pocketchroot ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE pofile DISABLE TRIGGER ALL;
 
 INSERT INTO pofile (id, potemplate, language, description, topcomment, header, fuzzyheader, lasttranslator, currentcount, updatescount, rosettacount, lastparsed, owner, path, datecreated, from_sourcepackagename, unreviewed_count, date_changed) VALUES (1, 1, 387, 'Spanish translation for evolution in hoary', ' traducción de es.po al Spanish
@@ -7091,6 +6857,12 @@
 ALTER TABLE poexportrequest ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE pofilestatsjob DISABLE TRIGGER ALL;
 
 
@@ -7140,6 +6912,9 @@
 ALTER TABLE pofiletranslator ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE poll DISABLE TRIGGER ALL;
 
 INSERT INTO poll (id, team, name, title, dateopens, datecloses, proposition, type, allowspoilt, secrecy, date_created) VALUES (1, 17, 'director-2004', '2004 Director''s Elections', '2004-01-01 00:00:00', '2004-01-15 00:00:00', 'Who''s going to be the next director?', 2, true, 3, '2006-10-16 18:31:44.605729');
@@ -7154,6 +6929,9 @@
 ALTER TABLE poll ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE polloption DISABLE TRIGGER ALL;
 
 INSERT INTO polloption (id, poll, name, title, active, date_created) VALUES (1, 1, 'A', 'A', true, '2006-10-16 18:31:44.620851');
@@ -7185,6 +6963,9 @@
 ALTER TABLE polloption ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE pomsgid DISABLE TRIGGER ALL;
 
 INSERT INTO pomsgid (id, msgid) VALUES (1, 'evolution addressbook');
@@ -7499,6 +7280,12 @@
 ALTER TABLE pomsgid ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE potmsgset DISABLE TRIGGER ALL;
 
 INSERT INTO potmsgset (id, msgid_singular, commenttext, filereferences, sourcecomment, flagscomment, context, msgid_plural) VALUES (1, 1, '', 'a11y/addressbook/ea-addressbook-view.c:94
@@ -7725,6 +7512,9 @@
 ALTER TABLE potmsgset ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE potranslation DISABLE TRIGGER ALL;
 
 INSERT INTO potranslation (id, translation) VALUES (1, 'libreta de direcciones de Evolution');
@@ -9085,6 +8875,9 @@
 ALTER TABLE potranslation ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE previewdiff DISABLE TRIGGER ALL;
 
 
@@ -9092,6 +8885,9 @@
 ALTER TABLE previewdiff ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE processacceptedbugsjob DISABLE TRIGGER ALL;
 
 
@@ -9099,6 +8895,15 @@
 ALTER TABLE processacceptedbugsjob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE productjob DISABLE TRIGGER ALL;
 
 
@@ -9106,6 +8911,9 @@
 ALTER TABLE productjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE productlicense DISABLE TRIGGER ALL;
 
 INSERT INTO productlicense (id, product, license) VALUES (1, 1, 10);
@@ -9141,6 +8949,9 @@
 ALTER TABLE productlicense ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE productrelease DISABLE TRIGGER ALL;
 
 INSERT INTO productrelease (id, datereleased, release_notes, changelog, owner, datecreated, milestone) VALUES (1, '2004-06-28 00:00:00', '', '', 12, '2005-06-06 08:59:51.930201', 7);
@@ -9313,6 +9124,9 @@
 ALTER TABLE productrelease ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE productreleasefile DISABLE TRIGGER ALL;
 
 INSERT INTO productreleasefile (productrelease, libraryfile, filetype, id, description, uploader, date_uploaded, fti, signature) VALUES (5, 3, 1, 2, NULL, 16, '2005-06-06 08:59:51.926792', NULL, NULL);
@@ -9330,6 +9144,15 @@
 ALTER TABLE productreleasefile ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE publisherconfig DISABLE TRIGGER ALL;
 
 INSERT INTO publisherconfig (id, distribution, root_dir, base_url, copy_base_url) VALUES (1, 1, '/var/tmp/archive', 'http://archive.launchpad.dev/', 'http://rebuild-test.internal/');
@@ -9339,6 +9162,9 @@
 ALTER TABLE publisherconfig ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE question DISABLE TRIGGER ALL;
 
 INSERT INTO question (id, owner, title, description, assignee, answerer, product, distribution, sourcepackagename, status, priority, datecreated, datelastquery, dateaccepted, datedue, datelastresponse, date_solved, dateclosed, whiteboard, fti, answer, language, faq) VALUES (1, 11, 'Firefox cannot render Bank Site', 'Hello, I''m trying to access http://www.citibank.com/ and the page is not rendering correctly. Is there a setting I can use to get it right? Thanks.', NULL, NULL, 4, NULL, NULL, 10, 10, '2005-09-05 18:46:07.392021', '2005-09-05 18:46:07.392021', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 119, NULL);
@@ -9379,6 +9205,9 @@
 ALTER TABLE question ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE questionbug DISABLE TRIGGER ALL;
 
 
@@ -9386,6 +9215,9 @@
 ALTER TABLE questionbug ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE questionjob DISABLE TRIGGER ALL;
 
 
@@ -9393,6 +9225,9 @@
 ALTER TABLE questionjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE questionmessage DISABLE TRIGGER ALL;
 
 INSERT INTO questionmessage (id, question, message, action, new_status, owner) VALUES (1, 6, 12, 35, 18, 16);
@@ -9408,6 +9243,9 @@
 ALTER TABLE questionmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE questionreopening DISABLE TRIGGER ALL;
 
 
@@ -9415,6 +9253,9 @@
 ALTER TABLE questionreopening ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE questionsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO questionsubscription (id, question, person, date_created) VALUES (1, 7, 16, '2006-10-16 18:31:53.201104');
@@ -9431,6 +9272,15 @@
 ALTER TABLE questionsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE revisioncache DISABLE TRIGGER ALL;
 
 
@@ -9438,6 +9288,9 @@
 ALTER TABLE revisioncache ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE revisionparent DISABLE TRIGGER ALL;
 
 INSERT INTO revisionparent (id, sequence, revision, parent_id) VALUES (1, 0, 5, '[e-mail]-20051031165248-6f1bb97973c2b4f4');
@@ -9455,6 +9308,9 @@
 ALTER TABLE revisionparent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE revisionproperty DISABLE TRIGGER ALL;
 
 INSERT INTO revisionproperty (id, revision, name, value) VALUES (1, 11, 'lp:foo', 'extended value');
@@ -9464,6 +9320,9 @@
 ALTER TABLE revisionproperty ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE scriptactivity DISABLE TRIGGER ALL;
 
 INSERT INTO scriptactivity (id, name, hostname, date_started, date_completed) VALUES (1, 'launchpad-targetnamecacheupdater', 'whatever', '2007-08-08 17:02:22.963565', '2007-08-08 17:02:23.869575');
@@ -9473,6 +9332,12 @@
 ALTER TABLE scriptactivity ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE sectionselection DISABLE TRIGGER ALL;
 
 INSERT INTO sectionselection (id, distroseries, section, date_created) VALUES (1, 3, 3, '2006-10-16 18:31:52.554214');
@@ -9563,6 +9428,9 @@
 ALTER TABLE sectionselection ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE seriessourcepackagebranch DISABLE TRIGGER ALL;
 
 
@@ -9570,6 +9438,9 @@
 ALTER TABLE seriessourcepackagebranch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sharingjob DISABLE TRIGGER ALL;
 
 
@@ -9577,6 +9448,9 @@
 ALTER TABLE sharingjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE signedcodeofconduct DISABLE TRIGGER ALL;
 
 INSERT INTO signedcodeofconduct (id, owner, signingkey, datecreated, signedcode, recipient, active, admincomment) VALUES (1, 16, 1, '2005-09-27 10:01:13', 'Sampledata signedcode', NULL, true, NULL);
@@ -9585,6 +9459,9 @@
 ALTER TABLE signedcodeofconduct ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sourcepackageformatselection DISABLE TRIGGER ALL;
 
 INSERT INTO sourcepackageformatselection (id, distroseries, format) VALUES (1, 1, 0);
@@ -9605,6 +9482,21 @@
 ALTER TABLE sourcepackageformatselection ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
 ALTER TABLE sourcepackagerecipebuildjob DISABLE TRIGGER ALL;
 
 
@@ -9612,6 +9504,9 @@
 ALTER TABLE sourcepackagerecipebuildjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sourcepackagerecipedata DISABLE TRIGGER ALL;
 
 
@@ -9619,6 +9514,9 @@
 ALTER TABLE sourcepackagerecipedata ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sourcepackagerecipedatainstruction DISABLE TRIGGER ALL;
 
 
@@ -9626,6 +9524,9 @@
 ALTER TABLE sourcepackagerecipedatainstruction ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sourcepackagerecipedistroseries DISABLE TRIGGER ALL;
 
 
@@ -9633,6 +9534,12 @@
 ALTER TABLE sourcepackagerecipedistroseries ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE sourcepackagereleasefile DISABLE TRIGGER ALL;
 
 INSERT INTO sourcepackagereleasefile (sourcepackagerelease, libraryfile, filetype, id) VALUES (14, 3, 6, 6);
@@ -9654,6 +9561,12 @@
 ALTER TABLE sourcepackagereleasefile ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE specificationbranch DISABLE TRIGGER ALL;
 
 INSERT INTO specificationbranch (id, datecreated, specification, branch, summary, registrant) VALUES (1, '2006-11-02 09:07:48.389829', 6, 20, 'This branch should fix the issue', 12);
@@ -9662,6 +9575,9 @@
 ALTER TABLE specificationbranch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationbug DISABLE TRIGGER ALL;
 
 INSERT INTO specificationbug (id, specification, bug) VALUES (1, 3, 1);
@@ -9670,6 +9586,9 @@
 ALTER TABLE specificationbug ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationdependency DISABLE TRIGGER ALL;
 
 INSERT INTO specificationdependency (id, specification, dependency, date_created) VALUES (1, 4, 3, '2006-10-16 18:31:52.855436');
@@ -9679,6 +9598,9 @@
 ALTER TABLE specificationdependency ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationmessage DISABLE TRIGGER ALL;
 
 
@@ -9686,6 +9608,9 @@
 ALTER TABLE specificationmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO specificationsubscription (id, specification, person, essential, date_created) VALUES (1, 3, 16, false, '2006-10-16 18:31:52.870628');
@@ -9698,6 +9623,9 @@
 ALTER TABLE specificationsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationworkitem DISABLE TRIGGER ALL;
 
 
@@ -9705,6 +9633,9 @@
 ALTER TABLE specificationworkitem ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationworkitemchange DISABLE TRIGGER ALL;
 
 
@@ -9712,6 +9643,9 @@
 ALTER TABLE specificationworkitemchange ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE specificationworkitemstats DISABLE TRIGGER ALL;
 
 
@@ -9719,6 +9653,9 @@
 ALTER TABLE specificationworkitemstats ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE spokenin DISABLE TRIGGER ALL;
 
 INSERT INTO spokenin (language, country, id) VALUES (1, 60, 165);
@@ -10003,6 +9940,9 @@
 ALTER TABLE spokenin ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sprint DISABLE TRIGGER ALL;
 
 INSERT INTO sprint (id, owner, name, title, summary, home_page, address, time_zone, time_starts, time_ends, datecreated, driver, homepage_content, icon, mugshot, logo) VALUES (1, 12, 'ubz', 'Ubuntu Below Zero', 'This is the next Ubuntu developer Summit. Join us in Montreal for discussions around Ubuntu and Launchpad. The focus will be the road to Dapper, our April 2006 release, focused on the enterprise.', 'http://wiki.ubuntu.com/UbuntuBelowZero', 'Montreal, Canada', 'US/Eastern', '2005-10-07 23:30:00', '2005-11-17 00:11:00', '2005-09-15 09:04:01.762108', NULL, NULL, NULL, NULL, NULL);
@@ -10014,6 +9954,9 @@
 ALTER TABLE sprint ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sprintattendance DISABLE TRIGGER ALL;
 
 
@@ -10021,6 +9964,9 @@
 ALTER TABLE sprintattendance ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sprintspecification DISABLE TRIGGER ALL;
 
 INSERT INTO sprintspecification (id, sprint, specification, status, whiteboard, registrant, date_created, decider, date_decided) VALUES (1, 1, 3, 10, NULL, 16, '2006-08-05 23:54:10.835093', 12, '2006-08-05 23:54:10.835093');
@@ -10033,6 +9979,9 @@
 ALTER TABLE sprintspecification ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE sshkey DISABLE TRIGGER ALL;
 
 INSERT INTO sshkey (id, person, keytype, keytext, comment, date_created) VALUES (1, 12, 2, 'AAAAB3NzaC1kc3MAAAEBAPfhCA15ZaT08brwVXwpJjcZT6QFIipzF1sGy57HY7QPi/W+uljr1VcCHzWdlSmda7YpTCTx0NFYYQIccQRGX6zYL8v1w9FSRCAnxxUJmqEhsUDFYFdVTa9uLCrs3MSbmh7wwFPdRrGrO6X5x7T4dMZQwykSZrOVdpLcCHRgrMZslLomIAjERn6OAQNiGFz7B2tEi/3Soqd52bGJwOtGymRiAXkPSLbH7KfzSCe34ytdh6BD+4SrgSoa+TL3VDV70QAdlOFXD42ZHl3Sc0Tde4LbZeYq2Uf84DOATLZBbOYpRSqTLkM9XngpnvCRVb6dxEQfgODDw783tEuPpySLj2EAAAAVANpUVgivDjt9gFibN/AXfYy1meeBAAABAB6FtnMywmWZg2lr2I3nDfE5U5QbGUQB/ZEP98ZkSkhOcF29VlnGOxyb2/VZbVTLa/btlPF82L4An/c8VKtKZnel7LnAlMoArdgzQNXGVQQVtnaWwM26ydgDzkSSIes3elNZgsfnPRBvaF0ol9Tqju0rNGKjnr3ZOX/NX+42bxpjRnxYj1h56yP2jKKeGfjorI6JK1YfqBAiTxzaDMzSpknnrbztaKJoh7IFqMMOp9ANSFh7H106pEaCv3ebCTJZprtWqNKjb2zum7OQPRz3upA0qx22ocTokjv4itXJ6yj/BvGu9qdOIQFXuB2rsFtLZtS8ATueOly0GzyeiZBx/AEAAAEBAO8jRYjL7tAYnVlO1p6UzPOicAuGCFWfNbBEDRAXoSgLNdj451jStw+eUc9ZVz7tG/XRVZsiavtFHb2cbrcfX1YOd69xi0m+IY6mo3yKt3irQRokDtt376sHoUdHgj2ozySZJgG8IJndtoS+VQQy6NdClA3fNFb96bF865eNaRYoHJO9ZI84lkWQL++MLzIuyFfCs1hSlapyyuHC8kFmF7AQdrVZvbohSbnWs+w53nIW8nAA7z21wAukvE1Pl6AQyG0e7U1sYS8Pc8dtmzJvdtVZWBl02/gqQJ7f06mFvnsN45rR1Uyxnrwl6rbFwqabZDlyD5Ac6Icbvz9SG1gBOiI=', 'andrew@trogdor', '2006-10-16 18:31:53.030784');
@@ -10042,6 +9991,12 @@
 ALTER TABLE sshkey ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE subunitstream DISABLE TRIGGER ALL;
 
 
@@ -10049,6 +10004,9 @@
 ALTER TABLE subunitstream ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE suggestivepotemplate DISABLE TRIGGER ALL;
 
 
@@ -10164,6 +10122,9 @@
 ALTER TABLE teammembership ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE teamparticipation DISABLE TRIGGER ALL;
 
 INSERT INTO teamparticipation (id, team, person) VALUES (1, 17, 1);
@@ -10371,6 +10332,15 @@
 ALTER TABLE teamparticipation ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE translationimportqueueentry DISABLE TRIGGER ALL;
 
 INSERT INTO translationimportqueueentry (id, path, content, importer, dateimported, distroseries, sourcepackagename, productseries, by_maintainer, pofile, potemplate, status, date_status_changed, format, error_output) VALUES (1, 'po/evolution-2.2-test.pot', 57, 16, '2006-12-13 21:17:56.241901', NULL, NULL, 3, true, NULL, 6, 2, '2006-12-13 21:18:40.885499', 1, NULL);
@@ -10380,6 +10350,9 @@
 ALTER TABLE translationimportqueueentry ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE translationmessage DISABLE TRIGGER ALL;
 
 INSERT INTO translationmessage (id, potmsgset, date_created, submitter, date_reviewed, reviewer, msgstr0, msgstr1, msgstr2, msgstr3, comment, origin, validation_status, is_current_ubuntu, is_fuzzy, is_current_upstream, was_obsolete_in_last_import, was_fuzzy_in_last_import, msgstr4, msgstr5, potemplate, language) VALUES (1, 1, '2005-04-07 13:19:17.601068', 13, '2005-04-07 13:19:17.601068', 13, 1, NULL, NULL, NULL, '', 1, 1, true, false, true, false, false, NULL, NULL, 1, 387);
@@ -11042,6 +11015,9 @@
 ALTER TABLE translationmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE translationrelicensingagreement DISABLE TRIGGER ALL;
 
 INSERT INTO translationrelicensingagreement (id, person, allow_relicensing, date_decided) VALUES (201, 58, true, '2008-05-23 16:29:22.319166');
@@ -11110,6 +11086,9 @@
 ALTER TABLE translationrelicensingagreement ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE translationtemplateitem DISABLE TRIGGER ALL;
 
 INSERT INTO translationtemplateitem (id, potemplate, sequence, potmsgset) VALUES (1, 1, 1, 1);
@@ -11313,6 +11292,9 @@
 ALTER TABLE translationtemplateitem ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE translationtemplatesbuild DISABLE TRIGGER ALL;
 
 
@@ -11320,6 +11302,9 @@
 ALTER TABLE translationtemplatesbuild ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE translator DISABLE TRIGGER ALL;
 
 INSERT INTO translator (id, translationgroup, language, translator, datecreated, style_guide_url) VALUES (1, 1, 387, 53, '2005-07-13 13:14:19.748396', NULL);
@@ -11328,6 +11313,9 @@
 ALTER TABLE translator ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE usertouseremail DISABLE TRIGGER ALL;
 
 
@@ -11335,6 +11323,9 @@
 ALTER TABLE usertouseremail ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE vote DISABLE TRIGGER ALL;
 
 INSERT INTO vote (id, person, poll, preference, option, token) VALUES (1, NULL, 1, 1, 4, '9WjxQq2V9p');
@@ -11370,6 +11361,9 @@
 ALTER TABLE vote ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE votecast DISABLE TRIGGER ALL;
 
 INSERT INTO votecast (id, person, poll) VALUES (1, 6, 1);
@@ -11387,6 +11381,9 @@
 ALTER TABLE votecast ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE wikiname DISABLE TRIGGER ALL;
 
 INSERT INTO wikiname (id, person, wiki, wikiname) VALUES (1, 1, 'https://wiki.ubuntu.com/', 'MarkShuttleworth');
@@ -11396,3 +11393,6 @@
 ALTER TABLE wikiname ENABLE TRIGGER ALL;
 
 
+
+
+
 
=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2013-07-23 08:46:17 +0000
+++ database/sampledata/current.sql	2013-09-19 01:08:29 +0000
@@ -1,6 +1,6 @@
 -- Copyright 2010-2013 Canonical Ltd.  This software is licensed under the
 -- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 9.1.4
+-- Created using pg_dump (PostgreSQL) 9.1.9
 
 SET check_function_bodies = false;
 SET client_encoding = 'UTF8';
@@ -12,750 +12,6 @@
 SET search_path = public, pg_catalog;
 
 
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
 SET SESSION AUTHORIZATION DEFAULT;
 
 ALTER TABLE account DISABLE TRIGGER ALL;
@@ -1725,16 +981,26 @@
 ALTER TABLE processorfamily ENABLE TRIGGER ALL;
 
 
+ALTER TABLE processor DISABLE TRIGGER ALL;
+
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (1, 1, '386', 'Intel 386', 'Intel 386 and its many derivatives and clones, the basic 32-bit chip in the x86 family', false);
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (2, 3, 'amd64', 'AMD 64bit', 'AMD 64bit', false);
+INSERT INTO processor (id, family, name, title, description, restricted) VALUES (3, 4, 'hppa', 'HPPA Processor', 'HPPA Processor', false);
+
+
+ALTER TABLE processor ENABLE TRIGGER ALL;
+
+
 ALTER TABLE distroarchseries DISABLE TRIGGER ALL;
 
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (1, 1, 1, 'i386', 1, true, 5, '2006-10-16 18:31:43.454475', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (6, 3, 1, 'i386', 1, true, 1, '2006-10-16 18:31:43.456532', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (7, 6, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457028', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (8, 10, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457484', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (9, 13, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457938', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (10, 13, 3, 'amd64', 1, true, 0, '2006-10-16 18:31:43.458434', true, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (11, 3, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.458892', false, true);
-INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled) VALUES (12, 1, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.459349', false, true);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (1, 1, 1, 'i386', 1, true, 5, '2006-10-16 18:31:43.454475', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (6, 3, 1, 'i386', 1, true, 1, '2006-10-16 18:31:43.456532', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (7, 6, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457028', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (8, 10, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457484', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (9, 13, 1, 'i386', 1, true, 0, '2006-10-16 18:31:43.457938', true, true, 1);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (10, 13, 3, 'amd64', 1, true, 0, '2006-10-16 18:31:43.458434', true, true, 2);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (11, 3, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.458892', false, true, 3);
+INSERT INTO distroarchseries (id, distroseries, processorfamily, architecturetag, owner, official, package_count, date_created, supports_virtualized, enabled, processor) VALUES (12, 1, 4, 'hppa', 1, false, 0, '2006-10-16 18:31:43.459349', false, true, 3);
 
 
 ALTER TABLE distroarchseries ENABLE TRIGGER ALL;
@@ -2115,6 +1381,9 @@
 ALTER TABLE accessartifact ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE accessartifactgrant DISABLE TRIGGER ALL;
 
 INSERT INTO accessartifactgrant (artifact, grantee, grantor, date_created) VALUES (1, 14, 65, '2007-08-09 11:39:16.836856');
@@ -2199,6 +1468,9 @@
 ALTER TABLE accesspolicy ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE accesspolicyartifact DISABLE TRIGGER ALL;
 
 INSERT INTO accesspolicyartifact (artifact, policy) VALUES (1, 2);
@@ -2231,6 +1503,12 @@
 ALTER TABLE accesspolicygrantflat ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE announcement DISABLE TRIGGER ALL;
 
 INSERT INTO announcement (id, date_created, date_announced, registrant, product, distribution, project, title, summary, url, active, date_updated) VALUES (1, '2007-11-25 00:44:32.186178', '2007-11-20 03:00:00', 1, NULL, 1, NULL, 'Every Macedonian Student to Use Ubuntu-Powered Computer Workstations', 'The Macedonia Ministry of Education and Science will deploy more than 180,000 workstations running Canonical’s Edubuntu 7.04 as part of its "Computer for Every Child" project.', 'http://www.ubuntu.com/news/macedonia-school-computers', true, NULL);
@@ -2288,6 +1566,9 @@
 ALTER TABLE announcement ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE answercontact DISABLE TRIGGER ALL;
 
 INSERT INTO answercontact (id, product, distribution, sourcepackagename, person, date_created) VALUES (1, NULL, 1, 1, 16, '2007-03-14 20:07:25.233772');
@@ -2299,10 +1580,13 @@
 ALTER TABLE answercontact ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE job DISABLE TRIGGER ALL;
 
-INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL);
-INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished) VALUES (2, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 10:14:12.820778', NULL, NULL);
+INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (1, NULL, NULL, 1, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 09:14:12.820778', '2005-06-15 09:20:12.820778', NULL, NULL, NULL);
+INSERT INTO job (id, requester, reason, status, progress, last_report_seen, next_report_due, attempt_count, max_retries, log, scheduled_start, lease_expires, date_created, date_started, date_finished, json_data, job_type) VALUES (2, NULL, NULL, 0, NULL, NULL, NULL, 0, 0, NULL, NULL, NULL, '2005-06-15 10:14:12.820778', NULL, NULL, NULL, NULL);
 
 
 ALTER TABLE job ENABLE TRIGGER ALL;
@@ -2322,6 +1606,9 @@
 ALTER TABLE apportjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE gpgkey DISABLE TRIGGER ALL;
 
 INSERT INTO gpgkey (id, owner, keyid, fingerprint, active, algorithm, keysize, can_encrypt, date_created) VALUES (1, 16, '12345678', 'ABCDEF0123456789ABCDDCBA0000111112345678', true, 17, 1024, true, '2006-10-16 18:31:43.631499');
@@ -2350,6 +1637,9 @@
 ALTER TABLE archive ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivearch DISABLE TRIGGER ALL;
 
 
@@ -2357,6 +1647,9 @@
 ALTER TABLE archivearch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archiveauthtoken DISABLE TRIGGER ALL;
 
 
@@ -2364,6 +1657,9 @@
 ALTER TABLE archiveauthtoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE component DISABLE TRIGGER ALL;
 
 INSERT INTO component (id, name, description) VALUES (1, 'main', NULL);
@@ -2383,6 +1679,9 @@
 ALTER TABLE archivedependency ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivejob DISABLE TRIGGER ALL;
 
 
@@ -2390,6 +1689,9 @@
 ALTER TABLE archivejob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagesetgroup DISABLE TRIGGER ALL;
 
 
@@ -2428,6 +1730,9 @@
 ALTER TABLE archivepermission ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE archivesubscriber DISABLE TRIGGER ALL;
 
 
@@ -2435,14 +1740,7 @@
 ALTER TABLE archivesubscriber ENABLE TRIGGER ALL;
 
 
-ALTER TABLE processor DISABLE TRIGGER ALL;
-
-INSERT INTO processor (id, family, name, title, description) VALUES (1, 1, '386', 'Intel 386', 'Intel 386 and its many derivatives and clones, the basic 32-bit chip in the x86 family');
-INSERT INTO processor (id, family, name, title, description) VALUES (2, 3, 'amd64', 'AMD 64bit', 'AMD 64bit');
-INSERT INTO processor (id, family, name, title, description) VALUES (3, 4, 'hppa', 'HPPA Processor', 'HPPA Processor');
-
-
-ALTER TABLE processor ENABLE TRIGGER ALL;
+
 
 
 ALTER TABLE builder DISABLE TRIGGER ALL;
@@ -2651,6 +1949,9 @@
 ALTER TABLE binarypackagebuild ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE binarypackagename DISABLE TRIGGER ALL;
 
 INSERT INTO binarypackagename (id, name) VALUES (6, 'foobar');
@@ -2704,6 +2005,12 @@
 ALTER TABLE binarypackagefile ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE binarypackagepath DISABLE TRIGGER ALL;
 
 
@@ -2711,6 +2018,9 @@
 ALTER TABLE binarypackagepath ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE binarypackagepublishinghistory DISABLE TRIGGER ALL;
 
 INSERT INTO binarypackagepublishinghistory (id, binarypackagerelease, distroarchseries, status, component, section, priority, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, binarypackagename, phased_update_percentage) VALUES (9, 12, 1, 2, 1, 1, 10, '2005-05-05 00:00:00', '2005-06-18 00:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, 8, NULL);
@@ -2744,6 +2054,12 @@
 ALTER TABLE binarypackagepublishinghistory ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE binarypackagereleasecontents DISABLE TRIGGER ALL;
 
 
@@ -3019,6 +2335,12 @@
 ALTER TABLE binarypackagereleasedownloadcount ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE branchjob DISABLE TRIGGER ALL;
 
 
@@ -3026,6 +2348,9 @@
 ALTER TABLE branchjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE branchmergeproposal DISABLE TRIGGER ALL;
 
 
@@ -3033,6 +2358,9 @@
 ALTER TABLE branchmergeproposal ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE branchmergeproposaljob DISABLE TRIGGER ALL;
 
 
@@ -3040,6 +2368,12 @@
 ALTER TABLE branchmergeproposaljob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE revisionauthor DISABLE TRIGGER ALL;
 
 INSERT INTO revisionauthor (id, name, email, person) VALUES (1, 'mark.shuttleworth', NULL, NULL);
@@ -3116,6 +2450,12 @@
 ALTER TABLE branchsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugactivity DISABLE TRIGGER ALL;
 
 INSERT INTO bugactivity (id, bug, datechanged, person, whatchanged, oldvalue, newvalue, message) VALUES (1, 1, '2004-09-24 00:00:00', 1, 'title', 'A silly problem', 'An odd problem', 'Decided problem wasn''t silly after all');
@@ -3159,6 +2499,9 @@
 ALTER TABLE bugactivity ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugaffectsperson DISABLE TRIGGER ALL;
 
 
@@ -3166,6 +2509,9 @@
 ALTER TABLE bugaffectsperson ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE message DISABLE TRIGGER ALL;
 
 INSERT INTO message (id, datecreated, subject, owner, parent, distribution, rfc822msgid, fti, raw, visible) VALUES (1, '2004-09-24 20:58:04.684057', 'PEBCAK', 16, NULL, NULL, '[e-mail]-332342--1231', NULL, NULL, true);
@@ -3228,6 +2574,9 @@
 ALTER TABLE bugattachment ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugbranch DISABLE TRIGGER ALL;
 
 INSERT INTO bugbranch (id, datecreated, bug, branch, revision_hint, whiteboard, registrant) VALUES (1, '2006-03-22 18:44:27.438982', 5, 1, NULL, NULL, 12);
@@ -3238,6 +2587,9 @@
 ALTER TABLE bugbranch ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE cve DISABLE TRIGGER ALL;
 
 INSERT INTO cve (id, sequence, status, description, datecreated, datemodified, fti) VALUES (1, '1999-8979', 2, 'Firefox crashes all the time', '2005-09-07 19:00:32.944561', '2005-09-13 14:00:03.508959', NULL);
@@ -3264,6 +2616,9 @@
 ALTER TABLE bugcve ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugwatch DISABLE TRIGGER ALL;
 
 INSERT INTO bugwatch (id, bug, bugtracker, remotebug, remotestatus, lastchanged, lastchecked, datecreated, owner, last_error_type, remote_importance, remote_lp_bug_id, next_check) VALUES (1, 2, 1, '42', 'FUBAR', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', '2004-09-24 20:58:04.740841', 12, NULL, 'BAZBAZ', NULL, NULL);
@@ -3326,6 +2681,9 @@
 ALTER TABLE bugmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugmute DISABLE TRIGGER ALL;
 
 
@@ -3344,6 +2702,9 @@
 ALTER TABLE bugnomination ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotification DISABLE TRIGGER ALL;
 
 
@@ -3351,6 +2712,9 @@
 ALTER TABLE bugnotification ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotificationarchive DISABLE TRIGGER ALL;
 
 
@@ -3365,6 +2729,9 @@
 ALTER TABLE bugnotificationattachment ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE structuralsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO structuralsubscription (id, product, productseries, project, milestone, distribution, distroseries, sourcepackagename, subscriber, subscribed_by, date_created, date_last_updated) VALUES (1, NULL, NULL, NULL, NULL, 1, NULL, 1, 16, 16, '2008-01-29 15:12:34.581468', '2008-01-29 15:12:34.581468');
@@ -3401,6 +2768,9 @@
 ALTER TABLE bugnotificationrecipient ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugnotificationrecipientarchive DISABLE TRIGGER ALL;
 
 
@@ -3430,6 +2800,12 @@
 ALTER TABLE bugsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugsubscriptionfilterimportance DISABLE TRIGGER ALL;
 
 
@@ -3465,6 +2841,9 @@
 ALTER TABLE bugsubscriptionfiltertag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugsummary DISABLE TRIGGER ALL;
 
 INSERT INTO bugsummary (id, count, product, productseries, distribution, distroseries, sourcepackagename, viewed_by, tag, status, milestone, importance, has_patch, access_policy) VALUES (65, 1, 20, NULL, NULL, NULL, NULL, 14, 'lunch-money', 10, NULL, 5, false, NULL);
@@ -3538,6 +2917,9 @@
 ALTER TABLE bugsummary ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugsummaryjournal DISABLE TRIGGER ALL;
 
 
@@ -3545,6 +2927,9 @@
 ALTER TABLE bugsummaryjournal ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtag DISABLE TRIGGER ALL;
 
 INSERT INTO bugtag (id, bug, tag) VALUES (1, 9, 'crash');
@@ -3560,6 +2945,9 @@
 ALTER TABLE bugtag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtask DISABLE TRIGGER ALL;
 
 INSERT INTO bugtask (id, bug, product, distribution, distroseries, sourcepackagename, status, importance, assignee, date_assigned, datecreated, owner, milestone, bugwatch, targetnamecache, date_confirmed, date_inprogress, date_closed, productseries, date_incomplete, date_left_new, date_triaged, date_fix_committed, date_fix_released, date_left_closed, date_milestone_set) VALUES (2, 1, 4, NULL, NULL, NULL, 10, 20, 1, '2005-01-02 11:07:20.330975', '2004-01-02 03:49:22.910878', 12, NULL, NULL, 'Mozilla Firefox', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
@@ -3595,6 +2983,9 @@
 ALTER TABLE bugtask ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtaskflat DISABLE TRIGGER ALL;
 
 INSERT INTO bugtaskflat (bugtask, bug, datecreated, duplicateof, bug_owner, fti, information_type, date_last_updated, heat, product, productseries, distribution, distroseries, sourcepackagename, status, importance, assignee, milestone, owner, active, access_policies, access_grants, latest_patch_uploaded, date_closed) VALUES (2, 1, '2004-01-02 03:49:22.910878', NULL, 12, NULL, 1, '2006-05-19 06:37:40.344941', 0, 4, NULL, NULL, NULL, NULL, 10, 20, 1, NULL, 12, true, NULL, NULL, NULL, NULL);
@@ -3630,6 +3021,9 @@
 ALTER TABLE bugtaskflat ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtrackeralias DISABLE TRIGGER ALL;
 
 INSERT INTO bugtrackeralias (id, bugtracker, base_url) VALUES (1, 7, 'http://savannah.nognu.org/');
@@ -3641,6 +3035,9 @@
 ALTER TABLE bugtrackeralias ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE bugtrackercomponentgroup DISABLE TRIGGER ALL;
 
 
@@ -3655,6 +3052,12 @@
 ALTER TABLE bugtrackercomponent ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugtrackerperson DISABLE TRIGGER ALL;
 
 
@@ -3662,6 +3065,12 @@
 ALTER TABLE bugtrackerperson ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE bugwatchactivity DISABLE TRIGGER ALL;
 
 
@@ -3669,6 +3078,15 @@
 ALTER TABLE bugwatchactivity ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE buildpackagejob DISABLE TRIGGER ALL;
 
 INSERT INTO buildpackagejob (id, job, build) VALUES (1, 1, 8);
@@ -3678,6 +3096,9 @@
 ALTER TABLE buildpackagejob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE buildqueue DISABLE TRIGGER ALL;
 
 INSERT INTO buildqueue (id, builder, logtail, lastscore, manual, job, job_type, estimated_duration, processor, virtualized) VALUES (1, 1, 'Dummy sampledata entry, not processing', 1, false, 1, 1, '00:00:00', 1, false);
@@ -3687,6 +3108,9 @@
 ALTER TABLE buildqueue ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimport DISABLE TRIGGER ALL;
 
 INSERT INTO codeimport (id, branch, date_created, registrant, rcs_type, cvs_root, cvs_module, review_status, date_last_successful, owner, assignee, update_interval, url) VALUES (1, 75, '2007-06-25 20:04:04.226605', 52, 2, NULL, NULL, 20, NULL, 52, NULL, NULL, 'http://svn.example.org/svnroot/gnome-terminal/trunk');
@@ -3696,6 +3120,9 @@
 ALTER TABLE codeimport ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimportmachine DISABLE TRIGGER ALL;
 
 INSERT INTO codeimportmachine (id, date_created, hostname, state, heartbeat) VALUES (1, '2007-08-02 16:36:17.817407', 'bazaar-importer', 20, NULL);
@@ -3711,6 +3138,9 @@
 ALTER TABLE codeimportevent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimporteventdata DISABLE TRIGGER ALL;
 
 
@@ -3718,6 +3148,9 @@
 ALTER TABLE codeimporteventdata ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codeimportjob DISABLE TRIGGER ALL;
 
 INSERT INTO codeimportjob (id, date_created, code_import, machine, date_due, state, requesting_user, ordering, heartbeat, logtail, date_started) VALUES (1, '2007-12-05 16:07:57.276112', 1, NULL, '2007-12-05 16:07:57.276112', 10, NULL, NULL, NULL, NULL, NULL);
@@ -3726,6 +3159,12 @@
 ALTER TABLE codeimportjob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE codeimportresult DISABLE TRIGGER ALL;
 
 
@@ -3733,6 +3172,9 @@
 ALTER TABLE codeimportresult ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codereviewmessage DISABLE TRIGGER ALL;
 
 
@@ -3740,6 +3182,9 @@
 ALTER TABLE codereviewmessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE codereviewvote DISABLE TRIGGER ALL;
 
 
@@ -3747,6 +3192,9 @@
 ALTER TABLE codereviewvote ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE commercialsubscription DISABLE TRIGGER ALL;
 
 INSERT INTO commercialsubscription (id, date_created, date_last_modified, date_starts, date_expires, status, product, registrant, purchaser, whiteboard, sales_system_id) VALUES (1, '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.75983', '2012-10-08 11:09:37.838229', '2022-01-01 00:00:00', 10, 16, 65, 65, 'Complimentary 30 day subscription. -- Launchpad 2012-10-08', 'complimentary-30-day-2012-10-08 11:09:37.838229+00:00');
@@ -3756,6 +3204,12 @@
 ALTER TABLE commercialsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE componentselection DISABLE TRIGGER ALL;
 
 INSERT INTO componentselection (id, distroseries, component, date_created) VALUES (1, 3, 1, '2006-10-16 18:31:43.257508');
@@ -3782,6 +3236,15 @@
 ALTER TABLE componentselection ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE customlanguagecode DISABLE TRIGGER ALL;
 
 
@@ -3789,6 +3252,12 @@
 ALTER TABLE customlanguagecode ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE cvereference DISABLE TRIGGER ALL;
 
 INSERT INTO cvereference (id, cve, source, content, url, date_created) VALUES (1, 1, 'NAI', 'Known problem #234234', 'http://nai.com/testing/foobar/', '2006-10-16 18:31:43.386902');
@@ -3834,6 +3303,9 @@
 ALTER TABLE cvereference ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE databasecpustats DISABLE TRIGGER ALL;
 
 
@@ -3869,6 +3341,12 @@
 ALTER TABLE diff ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE distributionjob DISABLE TRIGGER ALL;
 
 
@@ -3876,6 +3354,9 @@
 ALTER TABLE distributionjob ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionmirror DISABLE TRIGGER ALL;
 
 INSERT INTO distributionmirror (id, distribution, name, http_base_url, ftp_base_url, rsync_base_url, displayname, description, owner, speed, country, content, official_candidate, enabled, date_created, whiteboard, status, date_reviewed, reviewer, country_dns_mirror) VALUES (1, 1, 'archive-mirror', 'http://localhost:11375/valid-mirror/', NULL, NULL, NULL, NULL, 1, 10, 75, 1, true, true, '2006-10-16 18:31:43.434567', NULL, 30, NULL, NULL, false);
@@ -3893,6 +3374,9 @@
 ALTER TABLE distributionmirror ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionsourcepackage DISABLE TRIGGER ALL;
 
 
@@ -3900,6 +3384,9 @@
 ALTER TABLE distributionsourcepackage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distributionsourcepackagecache DISABLE TRIGGER ALL;
 
 INSERT INTO distributionsourcepackagecache (id, distribution, sourcepackagename, name, binpkgnames, binpkgsummaries, binpkgdescriptions, fti, changelog, archive) VALUES (1, 3, 19, 'alsa-utils', '', '', '', NULL, NULL, 1);
@@ -3928,6 +3415,15 @@
 ALTER TABLE distributionsourcepackagecache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE packagediff DISABLE TRIGGER ALL;
 
 
@@ -3942,6 +3438,9 @@
 ALTER TABLE distroseriesdifference ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriesdifferencemessage DISABLE TRIGGER ALL;
 
 
@@ -3949,6 +3448,9 @@
 ALTER TABLE distroseriesdifferencemessage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroserieslanguage DISABLE TRIGGER ALL;
 
 INSERT INTO distroserieslanguage (id, distroseries, language, currentcount, updatescount, rosettacount, contributorcount, dateupdated, unreviewed_count) VALUES (1, 3, 68, 62, 0, 0, 1, '2007-01-15 17:58:40.839938', 0);
@@ -3975,6 +3477,9 @@
 ALTER TABLE distroserieslanguage ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriespackagecache DISABLE TRIGGER ALL;
 
 INSERT INTO distroseriespackagecache (id, distroseries, binarypackagename, name, summary, description, summaries, descriptions, fti, archive) VALUES (1, 3, 13, 'pmount', 'pmount shortdesc', 'pmount description', 'pmount shortdesc', 'pmount description', NULL, 1);
@@ -3988,6 +3493,9 @@
 ALTER TABLE distroseriespackagecache ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE distroseriesparent DISABLE TRIGGER ALL;
 
 
@@ -3995,6 +3503,9 @@
 ALTER TABLE distroseriesparent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
 
 INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, '[e-mail]', 1, 4, '2006-10-16 18:31:43.540582');
@@ -4082,6 +3593,9 @@
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE faq DISABLE TRIGGER ALL;
 
 INSERT INTO faq (id, title, tags, content, product, distribution, owner, date_created, last_updated_by, date_last_updated, fti) VALUES (1, 'Wireless Networking Documentation', 'wifi', 'Installation instructions for many wireless cards can be found at:
@@ -4148,6 +3662,9 @@
 ALTER TABLE faq ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE pillarname DISABLE TRIGGER ALL;
 
 INSERT INTO pillarname (id, name, product, project, distribution, active, alias_for) VALUES (1, 'ubuntu', NULL, NULL, 1, true, NULL);
@@ -4211,6 +3728,9 @@
 ALTER TABLE featuredproject ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE featureflag DISABLE TRIGGER ALL;
 
 
@@ -4225,6 +3745,9 @@
 ALTER TABLE featureflagchangelogentry ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE flatpackagesetinclusion DISABLE TRIGGER ALL;
 
 
@@ -4237,6 +3760,12 @@
 
 
 
+
+
+
+
+
+
 ALTER TABLE garbojobstate DISABLE TRIGGER ALL;
 
 
@@ -4244,6 +3773,9 @@
 ALTER TABLE garbojobstate ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwvendorname DISABLE TRIGGER ALL;
 
 INSERT INTO hwvendorname (id, name) VALUES (1, 'MSI');
@@ -4284,6 +3816,9 @@
 ALTER TABLE hwdevice ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdeviceclass DISABLE TRIGGER ALL;
 
 
@@ -4291,6 +3826,9 @@
 ALTER TABLE hwdeviceclass ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdriver DISABLE TRIGGER ALL;
 
 INSERT INTO hwdriver (id, package_name, name, license) VALUES (1, 'linux-image-2.6.24-19-generic', 'ehci_hcd', NULL);
@@ -4330,6 +3868,9 @@
 ALTER TABLE hwdevicedriverlink ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdevicenamevariant DISABLE TRIGGER ALL;
 
 
@@ -4337,6 +3878,9 @@
 ALTER TABLE hwdevicenamevariant ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwsystemfingerprint DISABLE TRIGGER ALL;
 
 INSERT INTO hwsystemfingerprint (id, fingerprint) VALUES (1, 'TONKA TUFFBOOK2600');
@@ -4362,6 +3906,9 @@
 ALTER TABLE hwdmihandle ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwdmivalue DISABLE TRIGGER ALL;
 
 
@@ -4369,6 +3916,15 @@
 ALTER TABLE hwdmivalue ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE hwsubmissionbug DISABLE TRIGGER ALL;
 
 
@@ -4376,6 +3932,9 @@
 ALTER TABLE hwsubmissionbug ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwsubmissiondevice DISABLE TRIGGER ALL;
 
 INSERT INTO hwsubmissiondevice (id, device_driver_link, submission, parent, hal_device_id) VALUES (1, 1, 2, NULL, 11);
@@ -4404,6 +3963,12 @@
 ALTER TABLE hwsubmissiondevice ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE hwtest DISABLE TRIGGER ALL;
 
 
@@ -4411,6 +3976,9 @@
 ALTER TABLE hwtest ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswerchoice DISABLE TRIGGER ALL;
 
 
@@ -4425,6 +3993,12 @@
 ALTER TABLE hwtestanswer ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE hwtestanswercount DISABLE TRIGGER ALL;
 
 
@@ -4432,6 +4006,9 @@
 ALTER TABLE hwtestanswercount ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswercountdevice DISABLE TRIGGER ALL;
 
 
@@ -4439,6 +4016,9 @@
 ALTER TABLE hwtestanswercountdevice ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE hwtestanswerdevice DISABLE TRIGGER ALL;
 
 
@@ -4446,6 +4026,15 @@
 ALTER TABLE hwtestanswerdevice ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE incrementaldiff DISABLE TRIGGER ALL;
 
 
@@ -4453,6 +4042,9 @@
 ALTER TABLE incrementaldiff ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE ircid DISABLE TRIGGER ALL;
 
 INSERT INTO ircid (id, person, network, nickname) VALUES (1, 1, 'irc.freenode.net', 'mark');
@@ -4469,6 +4061,9 @@
 ALTER TABLE ircid ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE jabberid DISABLE TRIGGER ALL;
 
 INSERT INTO jabberid (id, person, jabberid) VALUES (1, 1, '[e-mail]');
@@ -4486,6 +4081,12 @@
 ALTER TABLE jabberid ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmacategory DISABLE TRIGGER ALL;
 
 INSERT INTO karmacategory (id, name, title, summary) VALUES (2, 'bugs', 'Bug Management', 'This karma category covers work in the Malone bug tracking system, such as filing, closing and otherwise working with bugs.');
@@ -4638,6 +4239,12 @@
 ALTER TABLE karma ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmacache DISABLE TRIGGER ALL;
 
 INSERT INTO karmacache (id, person, category, karmavalue, product, distribution, sourcepackagename, project) VALUES (1423, 12, 6, 22, 6, NULL, NULL, NULL);
@@ -4703,6 +4310,12 @@
 ALTER TABLE karmacache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE karmatotalcache DISABLE TRIGGER ALL;
 
 INSERT INTO karmatotalcache (id, person, karma_total) VALUES (78, 12, 138);
@@ -4714,6 +4327,12 @@
 ALTER TABLE karmatotalcache ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE languagepack DISABLE TRIGGER ALL;
 
 INSERT INTO languagepack (id, file, date_exported, date_last_used, distroseries, type, updates) VALUES (1, 71, '2007-09-10 19:14:26.037382', '2007-09-10 19:14:26.037382', 3, 1, NULL);
@@ -4725,6 +4344,9 @@
 ALTER TABLE languagepack ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagecopyjob DISABLE TRIGGER ALL;
 
 
@@ -4825,6 +4447,9 @@
 ALTER TABLE latestpersonsourcepackagereleasecache ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE launchpaddatabaserevision DISABLE TRIGGER ALL;
 
 
@@ -4839,6 +4464,9 @@
 ALTER TABLE launchpaddatabaseupdatelog ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE launchpadstatistic DISABLE TRIGGER ALL;
 
 INSERT INTO launchpadstatistic (id, name, value, dateupdated) VALUES (1, 'potemplate_count', 10, '2007-03-18 17:27:46.221219');
@@ -4872,6 +4500,15 @@
 ALTER TABLE launchpadstatistic ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
 ALTER TABLE libraryfiledownloadcount DISABLE TRIGGER ALL;
 
 
@@ -4879,6 +4516,9 @@
 ALTER TABLE libraryfiledownloadcount ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE logintoken DISABLE TRIGGER ALL;
 
 INSERT INTO logintoken (id, requester, requesteremail, email, created, tokentype, token, fingerprint, redirection_url, date_consumed) VALUES (1, NULL, NULL, '[e-mail]', '2008-06-27 14:48:38.308457', 3, 'mzsJ6LBvNKjFqP1Csfw7', NULL, 'http://launchpad.dev', '2008-06-27 14:49:11.149508');
@@ -4888,6 +4528,9 @@
 ALTER TABLE logintoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE lp_account DISABLE TRIGGER ALL;
 
 INSERT INTO lp_account (id, openid_identifier) VALUES (11, 'mark_oid');
@@ -5367,6 +5010,9 @@
 ALTER TABLE mailinglist ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mailinglistsubscription DISABLE TRIGGER ALL;
 
 
@@ -5374,6 +5020,9 @@
 ALTER TABLE mailinglistsubscription ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mergedirectivejob DISABLE TRIGGER ALL;
 
 
@@ -5381,6 +5030,12 @@
 ALTER TABLE mergedirectivejob ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE messageapproval DISABLE TRIGGER ALL;
 
 
@@ -5388,6 +5043,9 @@
 ALTER TABLE messageapproval ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE messagechunk DISABLE TRIGGER ALL;
 
 INSERT INTO messagechunk (id, message, sequence, content, blob, fti) VALUES (1, 7, 1, 'Malone pages that use more complex layouts with portlets and fancy CSS are sometimes not getting properly reflowed after rendering.', NULL, NULL);
@@ -5841,6 +5499,12 @@
 ALTER TABLE messagechunk ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE milestonetag DISABLE TRIGGER ALL;
 
 
@@ -5848,6 +5512,9 @@
 ALTER TABLE milestonetag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirror DISABLE TRIGGER ALL;
 
 
@@ -5855,6 +5522,9 @@
 ALTER TABLE mirror ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorcdimagedistroseries DISABLE TRIGGER ALL;
 
 INSERT INTO mirrorcdimagedistroseries (id, distribution_mirror, distroseries, flavour, date_created) VALUES (1, 6, 1, 'ubuntu', '2006-10-16 18:31:44.303183');
@@ -5866,6 +5536,9 @@
 ALTER TABLE mirrorcdimagedistroseries ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorcontent DISABLE TRIGGER ALL;
 
 
@@ -5873,6 +5546,9 @@
 ALTER TABLE mirrorcontent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrordistroarchseries DISABLE TRIGGER ALL;
 
 INSERT INTO mirrordistroarchseries (id, distribution_mirror, distroarchseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 2, 10, 1, '2006-10-16 18:31:44.309753');
@@ -5884,6 +5560,9 @@
 ALTER TABLE mirrordistroarchseries ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrordistroseriessource DISABLE TRIGGER ALL;
 
 INSERT INTO mirrordistroseriessource (id, distribution_mirror, distroseries, freshness, pocket, component, date_created) VALUES (1, 7, 1, 1, 10, 1, '2006-10-16 18:31:44.314175');
@@ -5896,6 +5575,9 @@
 ALTER TABLE mirrordistroseriessource ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorproberecord DISABLE TRIGGER ALL;
 
 INSERT INTO mirrorproberecord (id, distribution_mirror, log_file, date_created) VALUES (1, 6, 46, '2006-05-24 17:11:59.37369');
@@ -5905,6 +5587,9 @@
 ALTER TABLE mirrorproberecord ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE mirrorsourcecontent DISABLE TRIGGER ALL;
 
 
@@ -5912,6 +5597,9 @@
 ALTER TABLE mirrorsourcecontent ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE nameblacklist DISABLE TRIGGER ALL;
 
 INSERT INTO nameblacklist (id, regexp, comment, admin) VALUES (1, 'blacklist', 'For testing purposes', NULL);
@@ -5921,6 +5609,9 @@
 ALTER TABLE nameblacklist ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE oauthconsumer DISABLE TRIGGER ALL;
 
 INSERT INTO oauthconsumer (id, date_created, disabled, key, secret) VALUES (1, '2008-03-18 20:57:19.108004', false, 'foobar123451432', '');
@@ -5940,6 +5631,12 @@
 ALTER TABLE oauthaccesstoken ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE oauthnonce DISABLE TRIGGER ALL;
 
 
@@ -5954,6 +5651,9 @@
 ALTER TABLE oauthrequesttoken ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE officialbugtag DISABLE TRIGGER ALL;
 
 
@@ -5961,6 +5661,9 @@
 ALTER TABLE officialbugtag ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE openidconsumerassociation DISABLE TRIGGER ALL;
 
 
@@ -6050,6 +5753,9 @@
 ALTER TABLE openididentifier ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagecopyrequest DISABLE TRIGGER ALL;
 
 
@@ -6057,6 +5763,18 @@
 ALTER TABLE packagecopyrequest ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
+
+
+
+
+
+
 ALTER TABLE packagesetinclusion DISABLE TRIGGER ALL;
 
 
@@ -6064,6 +5782,9 @@
 ALTER TABLE packagesetinclusion ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packagesetsources DISABLE TRIGGER ALL;
 
 
@@ -6071,6 +5792,12 @@
 ALTER TABLE packagesetsources ENABLE TRIGGER ALL;
 
 
+
+
+
+
+
+
 ALTER TABLE packageuploadbuild DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadbuild (id, packageupload, build, date_created) VALUES (1, 1, 18, '2006-10-16 18:31:43.529327');
@@ -6081,6 +5808,9 @@
 ALTER TABLE packageuploadbuild ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packageuploadcustom DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadcustom (id, packageupload, customformat, libraryfilealias, date_created) VALUES (1, 5, 1, 1, '2006-10-16 18:31:43.532702');
@@ -6092,6 +5822,9 @@
 ALTER TABLE packageuploadcustom ENABLE TRIGGER ALL;
 
 
+
+
+
 ALTER TABLE packageuploadsource DISABLE TRIGGER ALL;
 
 INSERT INTO packageuploadsource (id, packageupload, sourcepackagerelease, date_created) VALUES (1, 3, 17, '2006-10-16 18:31:43.536296');