← Back to team overview

launchpad-reviewers team mailing list archive

[Merge] lp:~wgrant/launchpad/drop-accountish-bits into lp:launchpad/db-devel

 

William Grant has proposed merging lp:~wgrant/launchpad/drop-accountish-bits into lp:launchpad/db-devel with lp:launchpad as a prerequisite.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)
Related bugs:
  Bug #629172 in Launchpad itself: "Drop EmailAddress.account"
  https://bugs.launchpad.net/launchpad/+bug/629172
  Bug #644105 in Launchpad itself: "remove basic auth (and passwords) - neither are used outside of the test suite"
  https://bugs.launchpad.net/launchpad/+bug/644105

For more details, see:
https://code.launchpad.net/~wgrant/launchpad/drop-accountish-bits/+merge/90062

Drop unused EmailAddress.account and AccountPassword.
-- 
https://code.launchpad.net/~wgrant/launchpad/drop-accountish-bits/+merge/90062
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~wgrant/launchpad/drop-accountish-bits into lp:launchpad/db-devel.
=== modified file 'database/sampledata/current-dev.sql'
--- database/sampledata/current-dev.sql	2012-01-17 23:55:44 +0000
+++ database/sampledata/current-dev.sql	2012-01-25 09:58:44 +0000
@@ -1,6 +1,6 @@
 -- Copyright 2010-2011 Canonical Ltd.  This software is licensed under the
 -- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 8.4.9
+-- Created using pg_dump (PostgreSQL) 8.4.10
 
 SET check_function_bodies = false;
 SET client_encoding = 'UTF8';
@@ -759,9 +759,6 @@
 
 
 
-
-
-
 SET SESSION AUTHORIZATION DEFAULT;
 
 ALTER TABLE account DISABLE TRIGGER ALL;
@@ -2043,64 +2040,6 @@
 ALTER TABLE accesspolicygrant ENABLE TRIGGER ALL;
 
 
-ALTER TABLE accountpassword DISABLE TRIGGER ALL;
-
-INSERT INTO accountpassword (id, account, password) VALUES (1, 11, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (2, 21, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (4, 41, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (6, 61, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (8, 81, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (11, 111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (12, 121, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (13, 131, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (14, 141, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (16, 161, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (22, 221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (23, 231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (27, 271, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (28, 281, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (29, 291, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (33, 331, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (34, 341, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (35, 351, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (36, 361, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (37, 371, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (38, 381, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (39, 391, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (40, 401, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (41, 411, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (42, 421, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (43, 431, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (44, 441, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (45, 451, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (46, 461, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (47, 471, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (48, 481, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (49, 491, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (50, 501, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (51, 511, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (52, 521, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (55, 551, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (56, 561, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (58, 581, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (63, 631, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (68, 681, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243602, 2436021, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243603, 2436031, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243610, 2436101, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243611, 2436111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243617, 2436171, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243622, 2436221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243623, 2436231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243624, 261, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243625, 71, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243626, 31, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243629, 2436242, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-
-
-ALTER TABLE accountpassword 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);
@@ -4008,86 +3947,86 @@
 
 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
 
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582', 11);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (2, 'robertc@xxxxxxxxxxxxxxxxx', 2, 4, '2006-10-16 18:31:43.542552', 21);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (3, 'carlos@xxxxxxxxxxxxx', 13, 4, '2006-10-16 18:31:43.542954', 131);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (4, 'daf@xxxxxxxxxxxxx', 14, 4, '2006-10-16 18:31:43.543302', 141);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (6, 'foo.bar@xxxxxxxxxxxxx', 16, 4, '2006-10-16 18:31:43.543649', 161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (7, 'steve.alexander@xxxxxxxxxxxxxxx', 11, 4, '2006-10-16 18:31:43.543996', 111);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (8, 'colin.watson@xxxxxxxxxxxxxxx', 4, 4, '2006-10-16 18:31:43.544344', 41);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (9, 'scott.james.remnant@xxxxxxxxxxxxxxx', 5, 1, '2006-10-16 18:31:43.544693', 51);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (10, 'andrew.bennetts@xxxxxxxxxxxxxxx', 7, 4, '2006-10-16 18:31:43.54507', 71);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (11, 'james.blackwell@xxxxxxxxxxxxxxx', 8, 4, '2006-10-16 18:31:43.54542', 81);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (12, 'christian.reis@xxxxxxxxxxxxxxx', 9, 4, '2006-10-16 18:31:43.54577', 91);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (13, 'jeff.waugh@xxxxxxxxxxxxxxx', 6, 4, '2006-10-16 18:31:43.54612', 61);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (14, 'dave.miller@xxxxxxxxxxxxxxx', 3, 4, '2006-10-16 18:31:43.546658', 31);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (15, 'justdave@xxxxxxxxxxxx', 3, 1, '2006-10-16 18:31:43.547068', 31);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (16, 'test@xxxxxxxxxxxxx', 12, 4, '2006-10-16 18:31:43.547451', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (17, 'testtest@xxxxxxxxxxxxx', 12, 1, '2006-10-16 18:31:43.547829', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (18, 'testtesttest@xxxxxxxxxxxxx', 12, 3, '2006-10-16 18:31:43.54821', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (19, 'testing@xxxxxxxxxxxxx', 12, 2, '2006-10-16 18:31:43.548591', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (20, 'stuart.bishop@xxxxxxxxxxxxx', 22, 4, '2006-10-16 18:31:43.548972', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (21, 'david.allouche@xxxxxxxxxxxxx', 23, 4, '2006-10-16 18:31:43.549353', 231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (22, 'david@xxxxxxxxxxxxx', 23, 2, '2006-10-16 18:31:43.549732', 231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (23, 'daniel.debonzi@xxxxxxxxxxxxx', 27, 4, '2006-10-16 18:31:43.550113', 271);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (24, 'celso.providelo@xxxxxxxxxxxxx', 28, 4, '2006-10-16 18:31:43.608939', 281);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (25, 'guilherme.salgado@xxxxxxxxxxxxx', 29, 4, '2006-10-16 18:31:43.609431', 291);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (26, 'edgar@xxxxxxxxxxxxxxxx', 33, 4, '2006-10-16 18:31:43.609819', 331);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (27, 'jvprat@xxxxxxxxxx', 34, 1, '2006-10-16 18:31:43.610202', 341);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (28, 'sigurd-ubuntu@xxxxxxxxxx', 35, 1, '2006-10-16 18:31:43.6147', 351);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (29, 'skacel@xxxxxxxxx', 36, 1, '2006-10-16 18:31:43.615107', 361);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (30, 'danner@xxxxxxxxxxx', 37, 1, '2006-10-16 18:31:43.61549', 371);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (31, 'martin.pitt@xxxxxxxxxxxxx', 38, 1, '2006-10-16 18:31:43.615874', 381);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (32, 'nsv@xxxxx', 39, 1, '2006-10-16 18:31:43.616257', 391);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (33, 'callipeo@xxxxxxxxx', 40, 1, '2006-10-16 18:31:43.616673', 401);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (34, 'jorge.gonzalez.gonzalez@xxxxxxxxxxxxx', 41, 1, '2006-10-16 18:31:43.617057', 411);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (35, 'barbier@xxxxxxxxxxx', 42, 1, '2006-10-16 18:31:43.617465', 421);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (36, 'andrelop@xxxxxxxxxx', 43, 1, '2006-10-16 18:31:43.61785', 431);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (37, 'valyag@xxxxxxxxxxxxxxxx', 44, 1, '2006-10-16 18:31:43.618232', 441);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (38, 'luk.claes@xxxxxxxx', 45, 1, '2006-10-16 18:31:43.618658', 451);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (39, 'kurem@xxxxxxxxx', 46, 4, '2006-10-16 18:31:43.619039', 461);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (40, 'morten@xxxxxx', 47, 1, '2006-10-16 18:31:43.619421', 471);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (41, 'mpo@xxxxxx', 48, 1, '2006-10-16 18:31:43.619815', 481);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (42, 'kebil@xxxxxxxxxxxxxx', 49, 1, '2006-10-16 18:31:43.620196', 491);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (43, 'tsukimi@xxxxxxxxxx', 50, 4, '2006-10-16 18:31:43.620578', 501);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (44, 'kreutzm@xxxxxxxxxxxxxxxxxxx', 51, 4, '2006-10-16 18:31:43.620959', 511);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (45, 'support@xxxxxxxxxx', 17, 4, '2006-10-16 18:31:43.621341', NULL);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (46, 'no-priv@xxxxxxxxxxxxx', 52, 4, '2006-10-16 18:31:43.621725', 521);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (47, 'stuart@xxxxxxxxxxxxxxxx', 22, 2, '2006-10-16 18:31:43.622107', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (48, 'zen@xxxxxxxxxxxxxxxxxxxxxxxxx', 22, 3, '2006-10-16 18:31:43.6241', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (49, 'stub@xxxxxxxxxxx', 22, 1, '2006-10-16 18:31:43.6245', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (50, 'marilize@xxxxxxx', 55, 4, '2006-10-16 18:31:43.624885', 551);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (51, 'jordi@xxxxxxxxxx', 56, 4, '2006-10-16 18:31:43.625266', 561);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (52, 'daniel.silverstone@xxxxxxxxxxxxx', 26, 4, '2006-10-16 18:31:43.625647', 261);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (53, 'bug-importer@xxxxxxxxxxxxx', 58, 4, '2006-10-16 18:31:43.62603', 581);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (54, 'rosetta@xxxxxxxxxxxxx', 30, 4, '2006-10-16 18:31:43.626521', NULL);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (55, 'salgado@xxxxxxxxxx', 29, 1, '2006-10-16 18:31:43.626932', 291);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (56, 'cprov@xxxxxxxxxx', 28, 2, '2006-10-16 18:31:43.627318', 281);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (57, 'bugwatch@xxxxxxxxxxxxxxxxxx', 62, 4, '2006-10-16 18:31:43.62774', 621);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (58, 'karl@xxxxxxxxxxxxx', 63, 4, '2006-10-16 18:31:43.628123', 631);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (59, 'limi@xxxxxxxxx', 10, 4, '2006-10-16 18:31:43.628504', 101);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (60, 'janitor@xxxxxxxxxxxxx', 65, 4, '2006-10-17 23:23:23.232323', 651);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (61, 'matsubara@xxxxxxxxxxxx', 66, 1, '2006-12-13 21:19:06.369142', 661);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (62, 'no-team-memberships@xxxxxxxx', 243602, 4, '2007-02-19 11:17:57.755666', 2436021);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (63, 'one-membership@xxxxxxxx', 243603, 4, '2007-02-21 10:53:59.700105', 2436031);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (64, 'beta-admin@xxxxxxxxxxxxx', 68, 4, '2007-01-31 06:56:25.096519', 681);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (66, 'launchpad@xxxxxxxxxxxxxxxxxx', 243606, 1, '2007-08-09 21:25:37.832976', 2436061);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (67, 'doc@xxxxxxxxxxxxxxxx', 243608, 1, '2007-11-12 15:23:19.847132', 2436081);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (68, 'carlos@xxxxxxxx', 13, 2, '2006-10-16 18:31:43.548591', 131);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (69, 'archive@xxxxxxxxxx', 243609, 4, '2007-12-07 13:43:20.393704', 2436091);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (70, 'member@xxxxxxxxxxxxx', 243610, 4, '2007-12-14 16:52:15.403833', 2436101);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (71, 'owner@xxxxxxxxxxxxx', 243611, 4, '2007-12-14 16:52:15.403833', 2436111);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (72, 'jbuhl_nospam@xxxxxx', 243614, 1, '2007-12-18 16:31:34.790641', 2436141);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (73, 'sjoerd@xxxxxxxxxxxxxxx', 243615, 1, '2007-12-18 16:31:34.790641', 2436151);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (74, 'mpitt@xxxxxxxxxx', 243616, 1, '2007-12-18 16:31:34.790641', 2436161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (75, 'tim@xxxxxxxxxxxxx', 243617, 4, '2008-03-06 09:55:27.289842', 2436171);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (76, 'commercial-member@xxxxxxxxxxxxx', 243622, 4, '2008-05-12 17:38:38.798696', 2436221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (77, 'former-user@xxxxxxxxxxxxx', 70, 3, '2006-05-12 17:38:38.798696', 701);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (78, 'bac@xxxxxxxxxxxxx', 243623, 4, '2008-06-27 14:49:11.149508', 2436231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (79, 'admin@xxxxxxxxxxxxx', 16, 2, '2008-08-05 12:01:32.086327', 161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843', 2436241);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407', 2436243);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885', 243637);
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (2, 'robertc@xxxxxxxxxxxxxxxxx', 2, 4, '2006-10-16 18:31:43.542552');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (3, 'carlos@xxxxxxxxxxxxx', 13, 4, '2006-10-16 18:31:43.542954');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (4, 'daf@xxxxxxxxxxxxx', 14, 4, '2006-10-16 18:31:43.543302');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (6, 'foo.bar@xxxxxxxxxxxxx', 16, 4, '2006-10-16 18:31:43.543649');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (7, 'steve.alexander@xxxxxxxxxxxxxxx', 11, 4, '2006-10-16 18:31:43.543996');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (8, 'colin.watson@xxxxxxxxxxxxxxx', 4, 4, '2006-10-16 18:31:43.544344');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (9, 'scott.james.remnant@xxxxxxxxxxxxxxx', 5, 1, '2006-10-16 18:31:43.544693');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (10, 'andrew.bennetts@xxxxxxxxxxxxxxx', 7, 4, '2006-10-16 18:31:43.54507');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (11, 'james.blackwell@xxxxxxxxxxxxxxx', 8, 4, '2006-10-16 18:31:43.54542');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (12, 'christian.reis@xxxxxxxxxxxxxxx', 9, 4, '2006-10-16 18:31:43.54577');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (13, 'jeff.waugh@xxxxxxxxxxxxxxx', 6, 4, '2006-10-16 18:31:43.54612');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (14, 'dave.miller@xxxxxxxxxxxxxxx', 3, 4, '2006-10-16 18:31:43.546658');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (15, 'justdave@xxxxxxxxxxxx', 3, 1, '2006-10-16 18:31:43.547068');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (16, 'test@xxxxxxxxxxxxx', 12, 4, '2006-10-16 18:31:43.547451');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (17, 'testtest@xxxxxxxxxxxxx', 12, 1, '2006-10-16 18:31:43.547829');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (18, 'testtesttest@xxxxxxxxxxxxx', 12, 3, '2006-10-16 18:31:43.54821');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (19, 'testing@xxxxxxxxxxxxx', 12, 2, '2006-10-16 18:31:43.548591');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (20, 'stuart.bishop@xxxxxxxxxxxxx', 22, 4, '2006-10-16 18:31:43.548972');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (21, 'david.allouche@xxxxxxxxxxxxx', 23, 4, '2006-10-16 18:31:43.549353');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (22, 'david@xxxxxxxxxxxxx', 23, 2, '2006-10-16 18:31:43.549732');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (23, 'daniel.debonzi@xxxxxxxxxxxxx', 27, 4, '2006-10-16 18:31:43.550113');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (24, 'celso.providelo@xxxxxxxxxxxxx', 28, 4, '2006-10-16 18:31:43.608939');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (25, 'guilherme.salgado@xxxxxxxxxxxxx', 29, 4, '2006-10-16 18:31:43.609431');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (26, 'edgar@xxxxxxxxxxxxxxxx', 33, 4, '2006-10-16 18:31:43.609819');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (27, 'jvprat@xxxxxxxxxx', 34, 1, '2006-10-16 18:31:43.610202');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (28, 'sigurd-ubuntu@xxxxxxxxxx', 35, 1, '2006-10-16 18:31:43.6147');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (29, 'skacel@xxxxxxxxx', 36, 1, '2006-10-16 18:31:43.615107');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (30, 'danner@xxxxxxxxxxx', 37, 1, '2006-10-16 18:31:43.61549');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (31, 'martin.pitt@xxxxxxxxxxxxx', 38, 1, '2006-10-16 18:31:43.615874');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (32, 'nsv@xxxxx', 39, 1, '2006-10-16 18:31:43.616257');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (33, 'callipeo@xxxxxxxxx', 40, 1, '2006-10-16 18:31:43.616673');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (34, 'jorge.gonzalez.gonzalez@xxxxxxxxxxxxx', 41, 1, '2006-10-16 18:31:43.617057');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (35, 'barbier@xxxxxxxxxxx', 42, 1, '2006-10-16 18:31:43.617465');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (36, 'andrelop@xxxxxxxxxx', 43, 1, '2006-10-16 18:31:43.61785');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (37, 'valyag@xxxxxxxxxxxxxxxx', 44, 1, '2006-10-16 18:31:43.618232');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (38, 'luk.claes@xxxxxxxx', 45, 1, '2006-10-16 18:31:43.618658');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (39, 'kurem@xxxxxxxxx', 46, 4, '2006-10-16 18:31:43.619039');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (40, 'morten@xxxxxx', 47, 1, '2006-10-16 18:31:43.619421');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (41, 'mpo@xxxxxx', 48, 1, '2006-10-16 18:31:43.619815');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (42, 'kebil@xxxxxxxxxxxxxx', 49, 1, '2006-10-16 18:31:43.620196');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (43, 'tsukimi@xxxxxxxxxx', 50, 4, '2006-10-16 18:31:43.620578');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (44, 'kreutzm@xxxxxxxxxxxxxxxxxxx', 51, 4, '2006-10-16 18:31:43.620959');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (45, 'support@xxxxxxxxxx', 17, 4, '2006-10-16 18:31:43.621341');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (46, 'no-priv@xxxxxxxxxxxxx', 52, 4, '2006-10-16 18:31:43.621725');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (47, 'stuart@xxxxxxxxxxxxxxxx', 22, 2, '2006-10-16 18:31:43.622107');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (48, 'zen@xxxxxxxxxxxxxxxxxxxxxxxxx', 22, 3, '2006-10-16 18:31:43.6241');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (49, 'stub@xxxxxxxxxxx', 22, 1, '2006-10-16 18:31:43.6245');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (50, 'marilize@xxxxxxx', 55, 4, '2006-10-16 18:31:43.624885');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (51, 'jordi@xxxxxxxxxx', 56, 4, '2006-10-16 18:31:43.625266');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (52, 'daniel.silverstone@xxxxxxxxxxxxx', 26, 4, '2006-10-16 18:31:43.625647');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (53, 'bug-importer@xxxxxxxxxxxxx', 58, 4, '2006-10-16 18:31:43.62603');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (54, 'rosetta@xxxxxxxxxxxxx', 30, 4, '2006-10-16 18:31:43.626521');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (55, 'salgado@xxxxxxxxxx', 29, 1, '2006-10-16 18:31:43.626932');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (56, 'cprov@xxxxxxxxxx', 28, 2, '2006-10-16 18:31:43.627318');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (57, 'bugwatch@xxxxxxxxxxxxxxxxxx', 62, 4, '2006-10-16 18:31:43.62774');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (58, 'karl@xxxxxxxxxxxxx', 63, 4, '2006-10-16 18:31:43.628123');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (59, 'limi@xxxxxxxxx', 10, 4, '2006-10-16 18:31:43.628504');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (60, 'janitor@xxxxxxxxxxxxx', 65, 4, '2006-10-17 23:23:23.232323');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (61, 'matsubara@xxxxxxxxxxxx', 66, 1, '2006-12-13 21:19:06.369142');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (62, 'no-team-memberships@xxxxxxxx', 243602, 4, '2007-02-19 11:17:57.755666');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (63, 'one-membership@xxxxxxxx', 243603, 4, '2007-02-21 10:53:59.700105');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (64, 'beta-admin@xxxxxxxxxxxxx', 68, 4, '2007-01-31 06:56:25.096519');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (66, 'launchpad@xxxxxxxxxxxxxxxxxx', 243606, 1, '2007-08-09 21:25:37.832976');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (67, 'doc@xxxxxxxxxxxxxxxx', 243608, 1, '2007-11-12 15:23:19.847132');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (68, 'carlos@xxxxxxxx', 13, 2, '2006-10-16 18:31:43.548591');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (69, 'archive@xxxxxxxxxx', 243609, 4, '2007-12-07 13:43:20.393704');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (70, 'member@xxxxxxxxxxxxx', 243610, 4, '2007-12-14 16:52:15.403833');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (71, 'owner@xxxxxxxxxxxxx', 243611, 4, '2007-12-14 16:52:15.403833');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (72, 'jbuhl_nospam@xxxxxx', 243614, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (73, 'sjoerd@xxxxxxxxxxxxxxx', 243615, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (74, 'mpitt@xxxxxxxxxx', 243616, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (75, 'tim@xxxxxxxxxxxxx', 243617, 4, '2008-03-06 09:55:27.289842');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (76, 'commercial-member@xxxxxxxxxxxxx', 243622, 4, '2008-05-12 17:38:38.798696');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (77, 'former-user@xxxxxxxxxxxxx', 70, 3, '2006-05-12 17:38:38.798696');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (78, 'bac@xxxxxxxxxxxxx', 243623, 4, '2008-06-27 14:49:11.149508');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (79, 'admin@xxxxxxxxxxxxx', 16, 2, '2008-08-05 12:01:32.086327');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885');
 
 
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
@@ -10078,40 +10017,40 @@
 
 ALTER TABLE sourcepackagepublishinghistory DISABLE TRIGGER ALL;
 
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (1, 14, 1, 1, 1, 3, '2004-09-27 11:57:13', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (2, 15, 3, 2, 1, 3, '2004-09-27 11:57:13', '2004-09-27 11:57:13', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 9, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (4, 17, 1, 2, 1, 1, '2004-03-14 18:00:00', '2004-03-14 18:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 10, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (5, 16, 3, 2, 1, 2, '2004-03-10 16:30:00', '2004-03-10 16:30:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 10, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (8, 20, 3, 3, 1, 1, '2005-04-18 17:34:15.308434', '2005-04-18 17:34:15.308434', '2005-08-24 17:01:15.308434', 21, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 14, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (9, 21, 3, 2, 1, 3, '2005-08-24 17:01:15.308434', '2005-08-24 17:01:15.308434', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 14, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (10, 23, 1, 2, 1, 1, '2005-09-15 11:42:02.870714', '2005-09-15 11:42:02.870714', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (11, 24, 8, 2, 1, 2, '2005-09-15 11:42:21.070926', '2005-09-15 11:42:21.070926', NULL, NULL, NULL, NULL, NULL, 0, 3, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (12, 25, 3, 2, 1, 1, '2005-09-15 11:43:00.05741', '2005-09-15 11:43:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (13, 26, 3, 2, 3, 1, '2005-12-22 18:19:00.05741', '2005-12-22 18:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 20, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (14, 24, 3, 3, 1, 3, '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', 25, '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', 0, 1, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (15, 24, 1, 2, 1, 1, '2005-09-16 11:42:02.870714', '2005-09-16 11:42:02.870714', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (16, 27, 3, 2, 1, 1, '2005-02-10 12:19:00.05741', '2005-02-10 12:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 21, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (17, 28, 3, 2, 1, 1, '2005-02-10 12:19:00.05741', '2005-02-10 12:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 22, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (18, 14, 1, 2, 1, 2, '2006-02-13 12:19:00.05741', '2006-02-13 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (19, 28, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 22, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (20, 25, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (21, 24, 11, 4, 1, 3, '2006-09-14 11:44:00.10654', '2006-09-14 11:44:00', '2006-09-14 11:44:01', 25, '2006-09-14 11:45:00', '2006-09-14 11:45:00', '2006-09-15 11:45:00', 0, 8, 1, 'does anyone like ? I did not think so.', NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (22, 32, 1, 4, 1, 3, '2006-12-01 13:44:00.10654', '2006-12-01 11:44:00', NULL, NULL, NULL, NULL, '2006-12-02 11:44:00', 0, 1, 28, 'I do not like it.', NULL, 23, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (23, 33, 1, 2, 1, 3, '2006-12-01 13:44:00.10654', '2006-12-01 11:44:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 24, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (24, 14, 1, 2, 1, 2, '2006-02-19 11:57:13', '2007-02-19 11:57:13', NULL, NULL, NULL, NULL, NULL, 0, 8, NULL, NULL, NULL, 1, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (25, 33, 10, 2, 1, 3, '2007-04-25 13:44:00.10654', '2007-04-25 14:14:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 24, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (26, 35, 1, 2, 1, 3, '2006-04-11 12:00:00', '2006-04-11 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 26, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (27, 33, 10, 2, 1, 3, '2007-07-09 13:44:00.10654', '2007-07-09 14:14:00', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 24, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (28, 35, 1, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 26, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (29, 20, 1, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 14, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (30, 36, 10, 2, 5, 7, '2007-08-09 21:28:12.106187', NULL, NULL, NULL, NULL, NULL, NULL, 0, 12, NULL, NULL, NULL, 27, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (31, 35, 10, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 10, NULL, NULL, NULL, 26, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (32, 38, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 19, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (33, 39, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 9, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (34, 40, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 9, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (35, 41, 1, 1, 1, 3, '2006-08-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (36, 41, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 1, NULL);
-INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator) VALUES (37, 43, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 9, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (1, 14, 1, 1, 1, 3, '2004-09-27 11:57:13', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (2, 15, 3, 2, 1, 3, '2004-09-27 11:57:13', '2004-09-27 11:57:13', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 9, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (4, 17, 1, 2, 1, 1, '2004-03-14 18:00:00', '2004-03-14 18:00:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 10, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (5, 16, 3, 2, 1, 2, '2004-03-10 16:30:00', '2004-03-10 16:30:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 10, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (8, 20, 3, 3, 1, 1, '2005-04-18 17:34:15.308434', '2005-04-18 17:34:15.308434', '2005-08-24 17:01:15.308434', 21, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 14, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (9, 21, 3, 2, 1, 3, '2005-08-24 17:01:15.308434', '2005-08-24 17:01:15.308434', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 14, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (10, 23, 1, 2, 1, 1, '2005-09-15 11:42:02.870714', '2005-09-15 11:42:02.870714', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (11, 24, 8, 2, 1, 2, '2005-09-15 11:42:21.070926', '2005-09-15 11:42:21.070926', NULL, NULL, NULL, NULL, NULL, 0, 3, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (12, 25, 3, 2, 1, 1, '2005-09-15 11:43:00.05741', '2005-09-15 11:43:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (13, 26, 3, 2, 3, 1, '2005-12-22 18:19:00.05741', '2005-12-22 18:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 20, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (14, 24, 3, 3, 1, 3, '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', 25, '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', '2005-09-15 11:44:00.10654', 0, 1, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (15, 24, 1, 2, 1, 1, '2005-09-16 11:42:02.870714', '2005-09-16 11:42:02.870714', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (16, 27, 3, 2, 1, 1, '2005-02-10 12:19:00.05741', '2005-02-10 12:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 21, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (17, 28, 3, 2, 1, 1, '2005-02-10 12:19:00.05741', '2005-02-10 12:20:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 22, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (18, 14, 1, 2, 1, 2, '2006-02-13 12:19:00.05741', '2006-02-13 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (19, 28, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 22, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (20, 25, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (21, 24, 11, 4, 1, 3, '2006-09-14 11:44:00.10654', '2006-09-14 11:44:00', '2006-09-14 11:44:01', 25, '2006-09-14 11:45:00', '2006-09-14 11:45:00', '2006-09-15 11:45:00', 0, 8, 1, 'does anyone like ? I did not think so.', NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (22, 32, 1, 4, 1, 3, '2006-12-01 13:44:00.10654', '2006-12-01 11:44:00', NULL, NULL, NULL, NULL, '2006-12-02 11:44:00', 0, 1, 28, 'I do not like it.', NULL, 23, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (23, 33, 1, 2, 1, 3, '2006-12-01 13:44:00.10654', '2006-12-01 11:44:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 24, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (24, 14, 1, 2, 1, 2, '2006-02-19 11:57:13', '2007-02-19 11:57:13', NULL, NULL, NULL, NULL, NULL, 0, 8, NULL, NULL, NULL, 1, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (25, 33, 10, 2, 1, 3, '2007-04-25 13:44:00.10654', '2007-04-25 14:14:00', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 24, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (26, 35, 1, 2, 1, 3, '2006-04-11 12:00:00', '2006-04-11 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 26, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (27, 33, 10, 2, 1, 3, '2007-07-09 13:44:00.10654', '2007-07-09 14:14:00', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 24, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (28, 35, 1, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 26, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (29, 20, 1, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 9, NULL, NULL, NULL, 14, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (30, 36, 10, 2, 5, 7, '2007-08-09 21:28:12.106187', NULL, NULL, NULL, NULL, NULL, NULL, 0, 12, NULL, NULL, NULL, 27, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (31, 35, 10, 2, 1, 3, '2007-07-09 12:00:00', '2007-07-09 12:00:01', NULL, NULL, NULL, NULL, NULL, 0, 10, NULL, NULL, NULL, 26, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (32, 38, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 19, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (33, 39, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 9, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (34, 40, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 9, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (35, 41, 1, 1, 1, 3, '2006-08-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 1, NULL, NULL, NULL, 1, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (36, 41, 14, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 1, NULL, NULL);
+INSERT INTO sourcepackagepublishinghistory (id, sourcepackagerelease, distroseries, status, component, section, datecreated, datepublished, datesuperseded, supersededby, datemadepending, scheduleddeletiondate, dateremoved, pocket, archive, removed_by, removal_comment, ancestor, sourcepackagename, creator, sponsor) VALUES (37, 43, 1, 1, 1, 3, '2006-02-15 12:19:00.05741', NULL, NULL, NULL, NULL, NULL, NULL, 0, 16, NULL, NULL, NULL, 9, NULL, NULL);
 
 
 ALTER TABLE sourcepackagepublishinghistory ENABLE TRIGGER ALL;
@@ -10168,26 +10107,26 @@
 
 ALTER TABLE specification DISABLE TRIGGER ALL;
 
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (1, 'extension-manager-upgrades', 'Extension Manager Upgrades', 'Simplify the way extensions are installed and registered so that: 1. third party applications can easily register and deregister extensions that live with their code. 2. developers can easily register extensions that they are developing out of a location apart from their build (e.g. their home directory), and  3. developers can easily install extensions for testing.', 16, 13, NULL, 1, '2005-08-24 16:03:46.479655', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://wiki.mozilla.org/Firefox:1.1_Product_Team', NULL, NULL, false, NULL, 95, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (2, 'canvas', 'Support <canvas> Objects', 'With the Firefox 1.1 Developer Preview Release, Firefox includes a new HTML element for programmable graphics. <canvas> is based on the WhatWG canvas specification (http://www.whatwg.org/specs/web-apps/current-work/#graphics), which itself is based on Apple''s <canvas> implemented in Safari. It can be used for rendering graphs, UI elements, and other custom graphics on the client.', 16, NULL, NULL, NULL, '2005-08-24 16:05:03.406307', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://developer.mozilla.org/en/docs/Drawing_Graphics_with_Canvas', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (3, 'svg-support', 'Support Native SVG Objects', 'Scalable Vector Graphics (SVG) is an XML markup language for describing two-dimensional vector graphics. Mozilla should natively support embedded SVG images in HTML documents, or SVG served directly, much as PNG or JPEG images can be served.', 16, 13, 2, 28, '2005-08-24 16:10:05.078543', 4, NULL, NULL, NULL, NULL, 10, 70, 'http://developer.mozilla.org/en/docs/SVG', NULL, NULL, true, NULL, 75, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (4, 'e4x', 'Support E4X in EcmaScript', 'E4X adds native XML datatypes to the ECMAScript language, extends the semantics of familiar ECMAScript operators for manipulating XML objects and adds a small set of new operators for common XML operations, such as searching and filtering. It also adds support for XML literals, namespaces, qualified names and other mechanisms to facilitate XML processing.', 16, 14, 28, NULL, '2005-08-24 16:11:37.431981', 4, NULL, NULL, NULL, 1, 20, 0, 'http://www.ecma-international.org/publications/standards/Ecma-357.htm', 'This is the status whiteboard. Dig it?', NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (5, 'mergewin', 'Merge Open Browser Windows with "Consolidate Windows"', 'It should be possible to merge multiple open browser windows with a "Consolidate Windows" menu option.', 16, NULL, NULL, NULL, '2005-10-19 18:03:59.900723', 4, NULL, NULL, NULL, NULL, 40, 50, NULL, NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (6, 'media-integrity-check', 'CD Media Integrity Check', 'Sometimes, problems installing Ubuntu from CD are caused by bad sectors on the CD media itself. It should be easy to check the quality of the CD directly from within the installer.', 12, NULL, NULL, NULL, '2005-11-02 15:14:22.177596', NULL, NULL, 1, NULL, NULL, 35, 5, 'https://wiki.ubuntu.com/MediaIntegrityCheck', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (7, 'cluster-installation', 'Facilitate mass installs  of Ubuntu using Netboot configuration', 'We want to enable users to easily perform mass installations of Ubuntu on a pool of machines. We develop a console tool to intelligently manage dhcpd and syslinux configuration, and provide a GUI frontend for easy point and click configuration.
-
-N.B. We use the term ''cluster'' to mean ''a pool of machines''. While this could be a pool of cluster compute nodes, it doesn''t have to be. Because the mass-install infrastructure also provides generic netboot management, a more accurate name for this specification would be NetbootManagement.', 1, 8, 6, 33, '2006-04-12 07:34:37.765691', NULL, NULL, 5, 12, NULL, 10, 90, 'https://wiki.ubuntu.com/NetbootManagement', NULL, NULL, false, NULL, 65, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:34:37.765691', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (8, 'revu', 'The REVU Review Tracking System', 'Revu2 is a tool for assisting MOTUs to review packages. Packages are created mainly be contributors, but also by other tools.
-
-In future, REVU functionality will be integrated directly into Launchpad, to ensure a tight integration of both social and technical processes in the distribution.', 1, 14, NULL, 37, '2006-04-12 07:38:20.162251', NULL, NULL, 5, 12, NULL, 10, 70, 'https://wiki.ubuntu.com/REVU2Spec', NULL, NULL, false, NULL, 75, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:38:20.162251', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (9, 'usplash-on-hibernation', 'Activating Usplash during Hibernation', 'In order to conceal scary kernel messages, and provide some instruction and indication of progress to the user, usplash could be activated during the hibernation process.
-
-Progress indication is likely to be limited with the current swsusp implementation, and the question of when to power off the display should be considered.', 1, 14, NULL, 33, '2006-04-12 07:40:52.80865', NULL, NULL, 5, 12, NULL, 10, 10, 'http://wiki.ubuntu.com/UsplashHibernation', 'mark: mjg59 may want to be involved in the implementation too.', NULL, false, NULL, 95, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:40:52.80865', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (10, 'thinclient-local-devices', 'Support for local devices on Ubuntu thin clients', 'Provide support for locally-attached devices on thin clients, such as USB devices and floppy drives.', 1, 8, NULL, 6, '2006-04-12 07:44:42.314166', NULL, NULL, 5, 12, NULL, 10, 50, 'http://wiki.ubuntu.com/ThinClientLocalDevices', NULL, NULL, false, NULL, 90, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:44:42.314166', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (11, 'kde-desktopfile-langpacks', 'KDE Desktop File Language Packs', 'As of Kubuntu 5.10, language packs cannot provide updated translations for .desktop and .directory files (used for menu entries). We should make this possible.
-
-This spec deals with the KDE side; there is a separate spec for Gnome.', 1, 8, NULL, NULL, '2006-04-12 07:55:03.711218', NULL, NULL, 5, 12, NULL, 20, 5, 'https://wiki.ubuntu.com/LangpacksDesktopfilesKDE', 'mark - Do you think we can get this in for Krunch?', NULL, true, NULL, 0, 30, NULL, 1, '2006-08-06 16:11:59.8599', NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (12, 'krunch-desktop-plan', 'The Krunch Desktop Plan', 'This specification describes the plan for the Krunch Desktop. It will identify specific areas where additional polish will be added to ensure that Kapper is, in fact, krunchy.', 1, 33, NULL, NULL, '2006-04-12 07:57:24.675444', NULL, NULL, 5, 12, NULL, 35, 0, 'https://wiki.ubuntu.com/KrunchDesktopPlan', NULL, NULL, false, NULL, 0, 20, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:57:24.675444', NULL, NULL, NULL, NULL, false);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (1, 'extension-manager-upgrades', 'Extension Manager Upgrades', 'Simplify the way extensions are installed and registered so that: 1. third party applications can easily register and deregister extensions that live with their code. 2. developers can easily register extensions that they are developing out of a location apart from their build (e.g. their home directory), and  3. developers can easily install extensions for testing.', 16, 13, NULL, 1, '2005-08-24 16:03:46.479655', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://wiki.mozilla.org/Firefox:1.1_Product_Team', NULL, NULL, false, NULL, 95, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.293157', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (2, 'canvas', 'Support <canvas> Objects', 'With the Firefox 1.1 Developer Preview Release, Firefox includes a new HTML element for programmable graphics. <canvas> is based on the WhatWG canvas specification (http://www.whatwg.org/specs/web-apps/current-work/#graphics), which itself is based on Apple''s <canvas> implemented in Safari. It can be used for rendering graphs, UI elements, and other custom graphics on the client.', 16, NULL, NULL, NULL, '2005-08-24 16:05:03.406307', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://developer.mozilla.org/en/docs/Drawing_Graphics_with_Canvas', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.294647', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (3, 'svg-support', 'Support Native SVG Objects', 'Scalable Vector Graphics (SVG) is an XML markup language for describing two-dimensional vector graphics. Mozilla should natively support embedded SVG images in HTML documents, or SVG served directly, much as PNG or JPEG images can be served.', 16, 13, 2, 28, '2005-08-24 16:10:05.078543', 4, NULL, NULL, NULL, NULL, 10, 70, 'http://developer.mozilla.org/en/docs/SVG', NULL, NULL, true, NULL, 75, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:55:07.296002', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (4, 'e4x', 'Support E4X in EcmaScript', 'E4X adds native XML datatypes to the ECMAScript language, extends the semantics of familiar ECMAScript operators for manipulating XML objects and adds a small set of new operators for common XML operations, such as searching and filtering. It also adds support for XML literals, namespaces, qualified names and other mechanisms to facilitate XML processing.', 16, 14, 28, NULL, '2005-08-24 16:11:37.431981', 4, NULL, NULL, NULL, 1, 20, 0, 'http://www.ecma-international.org/publications/standards/Ecma-357.htm', 'This is the status whiteboard. Dig it?', NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.296486', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (5, 'mergewin', 'Merge Open Browser Windows with "Consolidate Windows"', 'It should be possible to merge multiple open browser windows with a "Consolidate Windows" menu option.', 16, NULL, NULL, NULL, '2005-10-19 18:03:59.900723', 4, NULL, NULL, NULL, NULL, 40, 50, NULL, NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.296921', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (6, 'media-integrity-check', 'CD Media Integrity Check', 'Sometimes, problems installing Ubuntu from CD are caused by bad sectors on the CD media itself. It should be easy to check the quality of the CD directly from within the installer.', 12, NULL, NULL, NULL, '2005-11-02 15:14:22.177596', NULL, NULL, 1, NULL, NULL, 35, 5, 'https://wiki.ubuntu.com/MediaIntegrityCheck', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.297353', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (7, 'cluster-installation', 'Facilitate mass installs  of Ubuntu using Netboot configuration', 'We want to enable users to easily perform mass installations of Ubuntu on a pool of machines. We develop a console tool to intelligently manage dhcpd and syslinux configuration, and provide a GUI frontend for easy point and click configuration.
+
+N.B. We use the term ''cluster'' to mean ''a pool of machines''. While this could be a pool of cluster compute nodes, it doesn''t have to be. Because the mass-install infrastructure also provides generic netboot management, a more accurate name for this specification would be NetbootManagement.', 1, 8, 6, 33, '2006-04-12 07:34:37.765691', NULL, NULL, 5, 12, NULL, 10, 90, 'https://wiki.ubuntu.com/NetbootManagement', NULL, NULL, false, NULL, 65, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:34:37.765691', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:55:07.297787', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (8, 'revu', 'The REVU Review Tracking System', 'Revu2 is a tool for assisting MOTUs to review packages. Packages are created mainly be contributors, but also by other tools.
+
+In future, REVU functionality will be integrated directly into Launchpad, to ensure a tight integration of both social and technical processes in the distribution.', 1, 14, NULL, 37, '2006-04-12 07:38:20.162251', NULL, NULL, 5, 12, NULL, 10, 70, 'https://wiki.ubuntu.com/REVU2Spec', NULL, NULL, false, NULL, 75, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:38:20.162251', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:55:07.298242', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (9, 'usplash-on-hibernation', 'Activating Usplash during Hibernation', 'In order to conceal scary kernel messages, and provide some instruction and indication of progress to the user, usplash could be activated during the hibernation process.
+
+Progress indication is likely to be limited with the current swsusp implementation, and the question of when to power off the display should be considered.', 1, 14, NULL, 33, '2006-04-12 07:40:52.80865', NULL, NULL, 5, 12, NULL, 10, 10, 'http://wiki.ubuntu.com/UsplashHibernation', 'mark: mjg59 may want to be involved in the implementation too.', NULL, false, NULL, 95, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:40:52.80865', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:55:07.298693', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (10, 'thinclient-local-devices', 'Support for local devices on Ubuntu thin clients', 'Provide support for locally-attached devices on thin clients, such as USB devices and floppy drives.', 1, 8, NULL, 6, '2006-04-12 07:44:42.314166', NULL, NULL, 5, 12, NULL, 10, 50, 'http://wiki.ubuntu.com/ThinClientLocalDevices', NULL, NULL, false, NULL, 90, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:44:42.314166', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:55:07.299129', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (11, 'kde-desktopfile-langpacks', 'KDE Desktop File Language Packs', 'As of Kubuntu 5.10, language packs cannot provide updated translations for .desktop and .directory files (used for menu entries). We should make this possible.
+
+This spec deals with the KDE side; there is a separate spec for Gnome.', 1, 8, NULL, NULL, '2006-04-12 07:55:03.711218', NULL, NULL, 5, 12, NULL, 20, 5, 'https://wiki.ubuntu.com/LangpacksDesktopfilesKDE', 'mark - Do you think we can get this in for Krunch?', NULL, true, NULL, 0, 30, NULL, 1, '2006-08-06 16:11:59.8599', NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.29956', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (12, 'krunch-desktop-plan', 'The Krunch Desktop Plan', 'This specification describes the plan for the Krunch Desktop. It will identify specific areas where additional polish will be added to ensure that Kapper is, in fact, krunchy.', 1, 33, NULL, NULL, '2006-04-12 07:57:24.675444', NULL, NULL, 5, 12, NULL, 35, 0, 'https://wiki.ubuntu.com/KrunchDesktopPlan', NULL, NULL, false, NULL, 0, 20, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:57:24.675444', NULL, NULL, NULL, NULL, false, '2012-01-25 05:55:07.300046', NULL);
 
 
 ALTER TABLE specification ENABLE TRIGGER ALL;

=== modified file 'database/sampledata/current.sql'
--- database/sampledata/current.sql	2012-01-19 22:34:39 +0000
+++ database/sampledata/current.sql	2012-01-25 09:58:44 +0000
@@ -1,6 +1,6 @@
--- Copyright 2010-2012 Canonical Ltd.  This software is licensed under the
+-- Copyright 2010-2011 Canonical Ltd.  This software is licensed under the
 -- GNU Affero General Public License version 3 (see the file LICENSE).
--- Created using pg_dump (PostgreSQL) 8.4.9
+-- Created using pg_dump (PostgreSQL) 8.4.10
 
 SET check_function_bodies = false;
 SET client_encoding = 'UTF8';
@@ -759,9 +759,6 @@
 
 
 
-
-
-
 SET SESSION AUTHORIZATION DEFAULT;
 
 ALTER TABLE account DISABLE TRIGGER ALL;
@@ -2041,64 +2038,6 @@
 ALTER TABLE accesspolicygrant ENABLE TRIGGER ALL;
 
 
-ALTER TABLE accountpassword DISABLE TRIGGER ALL;
-
-INSERT INTO accountpassword (id, account, password) VALUES (1, 11, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (2, 21, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (4, 41, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (6, 61, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (8, 81, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (11, 111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (12, 121, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (13, 131, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (14, 141, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (16, 161, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (22, 221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (23, 231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (27, 271, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (28, 281, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (29, 291, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (33, 331, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (34, 341, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (35, 351, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (36, 361, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (37, 371, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (38, 381, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (39, 391, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (40, 401, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (41, 411, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (42, 421, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (43, 431, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (44, 441, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (45, 451, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (46, 461, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (47, 471, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (48, 481, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (49, 491, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (50, 501, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (51, 511, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (52, 521, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (55, 551, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (56, 561, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (58, 581, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (63, 631, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (68, 681, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243602, 2436021, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243603, 2436031, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243610, 2436101, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243611, 2436111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243617, 2436171, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243622, 2436221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243623, 2436231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243624, 261, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243625, 71, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243626, 31, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-INSERT INTO accountpassword (id, account, password) VALUES (243629, 2436242, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
-
-
-ALTER TABLE accountpassword 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);
@@ -3941,86 +3880,86 @@
 
 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
 
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582', 11);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (2, 'robertc@xxxxxxxxxxxxxxxxx', 2, 4, '2006-10-16 18:31:43.542552', 21);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (3, 'carlos@xxxxxxxxxxxxx', 13, 4, '2006-10-16 18:31:43.542954', 131);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (4, 'daf@xxxxxxxxxxxxx', 14, 4, '2006-10-16 18:31:43.543302', 141);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (6, 'foo.bar@xxxxxxxxxxxxx', 16, 4, '2006-10-16 18:31:43.543649', 161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (7, 'steve.alexander@xxxxxxxxxxxxxxx', 11, 4, '2006-10-16 18:31:43.543996', 111);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (8, 'colin.watson@xxxxxxxxxxxxxxx', 4, 4, '2006-10-16 18:31:43.544344', 41);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (9, 'scott.james.remnant@xxxxxxxxxxxxxxx', 5, 1, '2006-10-16 18:31:43.544693', 51);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (10, 'andrew.bennetts@xxxxxxxxxxxxxxx', 7, 4, '2006-10-16 18:31:43.54507', 71);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (11, 'james.blackwell@xxxxxxxxxxxxxxx', 8, 4, '2006-10-16 18:31:43.54542', 81);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (12, 'christian.reis@xxxxxxxxxxxxxxx', 9, 4, '2006-10-16 18:31:43.54577', 91);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (13, 'jeff.waugh@xxxxxxxxxxxxxxx', 6, 4, '2006-10-16 18:31:43.54612', 61);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (14, 'dave.miller@xxxxxxxxxxxxxxx', 3, 4, '2006-10-16 18:31:43.546658', 31);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (15, 'justdave@xxxxxxxxxxxx', 3, 1, '2006-10-16 18:31:43.547068', 31);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (16, 'test@xxxxxxxxxxxxx', 12, 4, '2006-10-16 18:31:43.547451', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (17, 'testtest@xxxxxxxxxxxxx', 12, 1, '2006-10-16 18:31:43.547829', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (18, 'testtesttest@xxxxxxxxxxxxx', 12, 3, '2006-10-16 18:31:43.54821', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (19, 'testing@xxxxxxxxxxxxx', 12, 2, '2006-10-16 18:31:43.548591', 121);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (20, 'stuart.bishop@xxxxxxxxxxxxx', 22, 4, '2006-10-16 18:31:43.548972', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (21, 'david.allouche@xxxxxxxxxxxxx', 23, 4, '2006-10-16 18:31:43.549353', 231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (22, 'david@xxxxxxxxxxxxx', 23, 2, '2006-10-16 18:31:43.549732', 231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (23, 'daniel.debonzi@xxxxxxxxxxxxx', 27, 4, '2006-10-16 18:31:43.550113', 271);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (24, 'celso.providelo@xxxxxxxxxxxxx', 28, 4, '2006-10-16 18:31:43.608939', 281);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (25, 'guilherme.salgado@xxxxxxxxxxxxx', 29, 4, '2006-10-16 18:31:43.609431', 291);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (26, 'edgar@xxxxxxxxxxxxxxxx', 33, 4, '2006-10-16 18:31:43.609819', 331);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (27, 'jvprat@xxxxxxxxxx', 34, 1, '2006-10-16 18:31:43.610202', 341);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (28, 'sigurd-ubuntu@xxxxxxxxxx', 35, 1, '2006-10-16 18:31:43.6147', 351);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (29, 'skacel@xxxxxxxxx', 36, 1, '2006-10-16 18:31:43.615107', 361);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (30, 'danner@xxxxxxxxxxx', 37, 1, '2006-10-16 18:31:43.61549', 371);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (31, 'martin.pitt@xxxxxxxxxxxxx', 38, 1, '2006-10-16 18:31:43.615874', 381);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (32, 'nsv@xxxxx', 39, 1, '2006-10-16 18:31:43.616257', 391);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (33, 'callipeo@xxxxxxxxx', 40, 1, '2006-10-16 18:31:43.616673', 401);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (34, 'jorge.gonzalez.gonzalez@xxxxxxxxxxxxx', 41, 1, '2006-10-16 18:31:43.617057', 411);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (35, 'barbier@xxxxxxxxxxx', 42, 1, '2006-10-16 18:31:43.617465', 421);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (36, 'andrelop@xxxxxxxxxx', 43, 1, '2006-10-16 18:31:43.61785', 431);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (37, 'valyag@xxxxxxxxxxxxxxxx', 44, 1, '2006-10-16 18:31:43.618232', 441);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (38, 'luk.claes@xxxxxxxx', 45, 1, '2006-10-16 18:31:43.618658', 451);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (39, 'kurem@xxxxxxxxx', 46, 4, '2006-10-16 18:31:43.619039', 461);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (40, 'morten@xxxxxx', 47, 1, '2006-10-16 18:31:43.619421', 471);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (41, 'mpo@xxxxxx', 48, 1, '2006-10-16 18:31:43.619815', 481);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (42, 'kebil@xxxxxxxxxxxxxx', 49, 1, '2006-10-16 18:31:43.620196', 491);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (43, 'tsukimi@xxxxxxxxxx', 50, 4, '2006-10-16 18:31:43.620578', 501);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (44, 'kreutzm@xxxxxxxxxxxxxxxxxxx', 51, 4, '2006-10-16 18:31:43.620959', 511);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (45, 'support@xxxxxxxxxx', 17, 4, '2006-10-16 18:31:43.621341', NULL);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (46, 'no-priv@xxxxxxxxxxxxx', 52, 4, '2006-10-16 18:31:43.621725', 521);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (47, 'stuart@xxxxxxxxxxxxxxxx', 22, 2, '2006-10-16 18:31:43.622107', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (48, 'zen@xxxxxxxxxxxxxxxxxxxxxxxxx', 22, 3, '2006-10-16 18:31:43.6241', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (49, 'stub@xxxxxxxxxxx', 22, 1, '2006-10-16 18:31:43.6245', 221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (50, 'marilize@xxxxxxx', 55, 4, '2006-10-16 18:31:43.624885', 551);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (51, 'jordi@xxxxxxxxxx', 56, 4, '2006-10-16 18:31:43.625266', 561);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (52, 'daniel.silverstone@xxxxxxxxxxxxx', 26, 4, '2006-10-16 18:31:43.625647', 261);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (53, 'bug-importer@xxxxxxxxxxxxx', 58, 4, '2006-10-16 18:31:43.62603', 581);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (54, 'rosetta@xxxxxxxxxxxxx', 30, 4, '2006-10-16 18:31:43.626521', NULL);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (55, 'salgado@xxxxxxxxxx', 29, 1, '2006-10-16 18:31:43.626932', 291);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (56, 'cprov@xxxxxxxxxx', 28, 2, '2006-10-16 18:31:43.627318', 281);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (57, 'bugwatch@xxxxxxxxxxxxxxxxxx', 62, 4, '2006-10-16 18:31:43.62774', 621);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (58, 'karl@xxxxxxxxxxxxx', 63, 4, '2006-10-16 18:31:43.628123', 631);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (59, 'limi@xxxxxxxxx', 10, 4, '2006-10-16 18:31:43.628504', 101);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (60, 'janitor@xxxxxxxxxxxxx', 65, 4, '2006-10-17 23:23:23.232323', 651);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (61, 'matsubara@xxxxxxxxxxxx', 66, 1, '2006-12-13 21:19:06.369142', 661);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (62, 'no-team-memberships@xxxxxxxx', 243602, 4, '2007-02-19 11:17:57.755666', 2436021);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (63, 'one-membership@xxxxxxxx', 243603, 4, '2007-02-21 10:53:59.700105', 2436031);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (64, 'beta-admin@xxxxxxxxxxxxx', 68, 4, '2007-01-31 06:56:25.096519', 681);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (66, 'launchpad@xxxxxxxxxxxxxxxxxx', 243606, 1, '2007-08-09 21:25:37.832976', 2436061);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (67, 'doc@xxxxxxxxxxxxxxxx', 243608, 1, '2007-11-12 15:23:19.847132', 2436081);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (68, 'carlos@xxxxxxxx', 13, 2, '2006-10-16 18:31:43.548591', 131);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (69, 'archive@xxxxxxxxxx', 243609, 4, '2007-12-07 13:43:20.393704', 2436091);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (70, 'member@xxxxxxxxxxxxx', 243610, 4, '2007-12-14 16:52:15.403833', 2436101);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (71, 'owner@xxxxxxxxxxxxx', 243611, 4, '2007-12-14 16:52:15.403833', 2436111);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (72, 'jbuhl_nospam@xxxxxx', 243614, 1, '2007-12-18 16:31:34.790641', 2436141);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (73, 'sjoerd@xxxxxxxxxxxxxxx', 243615, 1, '2007-12-18 16:31:34.790641', 2436151);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (74, 'mpitt@xxxxxxxxxx', 243616, 1, '2007-12-18 16:31:34.790641', 2436161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (75, 'tim@xxxxxxxxxxxxx', 243617, 4, '2008-03-06 09:55:27.289842', 2436171);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (76, 'commercial-member@xxxxxxxxxxxxx', 243622, 4, '2008-05-12 17:38:38.798696', 2436221);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (77, 'former-user@xxxxxxxxxxxxx', 70, 3, '2006-05-12 17:38:38.798696', 701);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (78, 'bac@xxxxxxxxxxxxx', 243623, 4, '2008-06-27 14:49:11.149508', 2436231);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (79, 'admin@xxxxxxxxxxxxx', 16, 2, '2008-08-05 12:01:32.086327', 161);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843', 2436241);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407', 2436243);
-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885', 243637);
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@xxxxxxxxxxx', 1, 4, '2006-10-16 18:31:43.540582');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (2, 'robertc@xxxxxxxxxxxxxxxxx', 2, 4, '2006-10-16 18:31:43.542552');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (3, 'carlos@xxxxxxxxxxxxx', 13, 4, '2006-10-16 18:31:43.542954');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (4, 'daf@xxxxxxxxxxxxx', 14, 4, '2006-10-16 18:31:43.543302');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (6, 'foo.bar@xxxxxxxxxxxxx', 16, 4, '2006-10-16 18:31:43.543649');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (7, 'steve.alexander@xxxxxxxxxxxxxxx', 11, 4, '2006-10-16 18:31:43.543996');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (8, 'colin.watson@xxxxxxxxxxxxxxx', 4, 4, '2006-10-16 18:31:43.544344');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (9, 'scott.james.remnant@xxxxxxxxxxxxxxx', 5, 1, '2006-10-16 18:31:43.544693');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (10, 'andrew.bennetts@xxxxxxxxxxxxxxx', 7, 4, '2006-10-16 18:31:43.54507');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (11, 'james.blackwell@xxxxxxxxxxxxxxx', 8, 4, '2006-10-16 18:31:43.54542');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (12, 'christian.reis@xxxxxxxxxxxxxxx', 9, 4, '2006-10-16 18:31:43.54577');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (13, 'jeff.waugh@xxxxxxxxxxxxxxx', 6, 4, '2006-10-16 18:31:43.54612');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (14, 'dave.miller@xxxxxxxxxxxxxxx', 3, 4, '2006-10-16 18:31:43.546658');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (15, 'justdave@xxxxxxxxxxxx', 3, 1, '2006-10-16 18:31:43.547068');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (16, 'test@xxxxxxxxxxxxx', 12, 4, '2006-10-16 18:31:43.547451');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (17, 'testtest@xxxxxxxxxxxxx', 12, 1, '2006-10-16 18:31:43.547829');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (18, 'testtesttest@xxxxxxxxxxxxx', 12, 3, '2006-10-16 18:31:43.54821');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (19, 'testing@xxxxxxxxxxxxx', 12, 2, '2006-10-16 18:31:43.548591');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (20, 'stuart.bishop@xxxxxxxxxxxxx', 22, 4, '2006-10-16 18:31:43.548972');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (21, 'david.allouche@xxxxxxxxxxxxx', 23, 4, '2006-10-16 18:31:43.549353');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (22, 'david@xxxxxxxxxxxxx', 23, 2, '2006-10-16 18:31:43.549732');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (23, 'daniel.debonzi@xxxxxxxxxxxxx', 27, 4, '2006-10-16 18:31:43.550113');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (24, 'celso.providelo@xxxxxxxxxxxxx', 28, 4, '2006-10-16 18:31:43.608939');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (25, 'guilherme.salgado@xxxxxxxxxxxxx', 29, 4, '2006-10-16 18:31:43.609431');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (26, 'edgar@xxxxxxxxxxxxxxxx', 33, 4, '2006-10-16 18:31:43.609819');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (27, 'jvprat@xxxxxxxxxx', 34, 1, '2006-10-16 18:31:43.610202');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (28, 'sigurd-ubuntu@xxxxxxxxxx', 35, 1, '2006-10-16 18:31:43.6147');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (29, 'skacel@xxxxxxxxx', 36, 1, '2006-10-16 18:31:43.615107');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (30, 'danner@xxxxxxxxxxx', 37, 1, '2006-10-16 18:31:43.61549');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (31, 'martin.pitt@xxxxxxxxxxxxx', 38, 1, '2006-10-16 18:31:43.615874');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (32, 'nsv@xxxxx', 39, 1, '2006-10-16 18:31:43.616257');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (33, 'callipeo@xxxxxxxxx', 40, 1, '2006-10-16 18:31:43.616673');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (34, 'jorge.gonzalez.gonzalez@xxxxxxxxxxxxx', 41, 1, '2006-10-16 18:31:43.617057');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (35, 'barbier@xxxxxxxxxxx', 42, 1, '2006-10-16 18:31:43.617465');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (36, 'andrelop@xxxxxxxxxx', 43, 1, '2006-10-16 18:31:43.61785');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (37, 'valyag@xxxxxxxxxxxxxxxx', 44, 1, '2006-10-16 18:31:43.618232');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (38, 'luk.claes@xxxxxxxx', 45, 1, '2006-10-16 18:31:43.618658');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (39, 'kurem@xxxxxxxxx', 46, 4, '2006-10-16 18:31:43.619039');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (40, 'morten@xxxxxx', 47, 1, '2006-10-16 18:31:43.619421');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (41, 'mpo@xxxxxx', 48, 1, '2006-10-16 18:31:43.619815');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (42, 'kebil@xxxxxxxxxxxxxx', 49, 1, '2006-10-16 18:31:43.620196');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (43, 'tsukimi@xxxxxxxxxx', 50, 4, '2006-10-16 18:31:43.620578');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (44, 'kreutzm@xxxxxxxxxxxxxxxxxxx', 51, 4, '2006-10-16 18:31:43.620959');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (45, 'support@xxxxxxxxxx', 17, 4, '2006-10-16 18:31:43.621341');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (46, 'no-priv@xxxxxxxxxxxxx', 52, 4, '2006-10-16 18:31:43.621725');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (47, 'stuart@xxxxxxxxxxxxxxxx', 22, 2, '2006-10-16 18:31:43.622107');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (48, 'zen@xxxxxxxxxxxxxxxxxxxxxxxxx', 22, 3, '2006-10-16 18:31:43.6241');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (49, 'stub@xxxxxxxxxxx', 22, 1, '2006-10-16 18:31:43.6245');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (50, 'marilize@xxxxxxx', 55, 4, '2006-10-16 18:31:43.624885');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (51, 'jordi@xxxxxxxxxx', 56, 4, '2006-10-16 18:31:43.625266');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (52, 'daniel.silverstone@xxxxxxxxxxxxx', 26, 4, '2006-10-16 18:31:43.625647');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (53, 'bug-importer@xxxxxxxxxxxxx', 58, 4, '2006-10-16 18:31:43.62603');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (54, 'rosetta@xxxxxxxxxxxxx', 30, 4, '2006-10-16 18:31:43.626521');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (55, 'salgado@xxxxxxxxxx', 29, 1, '2006-10-16 18:31:43.626932');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (56, 'cprov@xxxxxxxxxx', 28, 2, '2006-10-16 18:31:43.627318');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (57, 'bugwatch@xxxxxxxxxxxxxxxxxx', 62, 4, '2006-10-16 18:31:43.62774');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (58, 'karl@xxxxxxxxxxxxx', 63, 4, '2006-10-16 18:31:43.628123');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (59, 'limi@xxxxxxxxx', 10, 4, '2006-10-16 18:31:43.628504');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (60, 'janitor@xxxxxxxxxxxxx', 65, 4, '2006-10-17 23:23:23.232323');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (61, 'matsubara@xxxxxxxxxxxx', 66, 1, '2006-12-13 21:19:06.369142');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (62, 'no-team-memberships@xxxxxxxx', 243602, 4, '2007-02-19 11:17:57.755666');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (63, 'one-membership@xxxxxxxx', 243603, 4, '2007-02-21 10:53:59.700105');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (64, 'beta-admin@xxxxxxxxxxxxx', 68, 4, '2007-01-31 06:56:25.096519');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (66, 'launchpad@xxxxxxxxxxxxxxxxxx', 243606, 1, '2007-08-09 21:25:37.832976');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (67, 'doc@xxxxxxxxxxxxxxxx', 243608, 1, '2007-11-12 15:23:19.847132');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (68, 'carlos@xxxxxxxx', 13, 2, '2006-10-16 18:31:43.548591');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (69, 'archive@xxxxxxxxxx', 243609, 4, '2007-12-07 13:43:20.393704');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (70, 'member@xxxxxxxxxxxxx', 243610, 4, '2007-12-14 16:52:15.403833');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (71, 'owner@xxxxxxxxxxxxx', 243611, 4, '2007-12-14 16:52:15.403833');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (72, 'jbuhl_nospam@xxxxxx', 243614, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (73, 'sjoerd@xxxxxxxxxxxxxxx', 243615, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (74, 'mpitt@xxxxxxxxxx', 243616, 1, '2007-12-18 16:31:34.790641');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (75, 'tim@xxxxxxxxxxxxx', 243617, 4, '2008-03-06 09:55:27.289842');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (76, 'commercial-member@xxxxxxxxxxxxx', 243622, 4, '2008-05-12 17:38:38.798696');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (77, 'former-user@xxxxxxxxxxxxx', 70, 3, '2006-05-12 17:38:38.798696');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (78, 'bac@xxxxxxxxxxxxx', 243623, 4, '2008-06-27 14:49:11.149508');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (79, 'admin@xxxxxxxxxxxxx', 16, 2, '2008-08-05 12:01:32.086327');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@xxxxxxxxxxxxx', 243625, 4, '2008-11-04 12:59:26.965843');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@xxxxxxxxxxx', 243631, 4, '2009-08-04 10:50:39.383407');
+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@xxxxxxxxxxx', 243651, 4, '2010-07-12 09:48:27.198885');
 
 
 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
@@ -10092,26 +10031,26 @@
 
 ALTER TABLE specification DISABLE TRIGGER ALL;
 
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (1, 'extension-manager-upgrades', 'Extension Manager Upgrades', 'Simplify the way extensions are installed and registered so that: 1. third party applications can easily register and deregister extensions that live with their code. 2. developers can easily register extensions that they are developing out of a location apart from their build (e.g. their home directory), and  3. developers can easily install extensions for testing.', 16, 13, NULL, 1, '2005-08-24 16:03:46.479655', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://wiki.mozilla.org/Firefox:1.1_Product_Team', NULL, NULL, false, NULL, 95, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (2, 'canvas', 'Support <canvas> Objects', 'With the Firefox 1.1 Developer Preview Release, Firefox includes a new HTML element for programmable graphics. <canvas> is based on the WhatWG canvas specification (http://www.whatwg.org/specs/web-apps/current-work/#graphics), which itself is based on Apple''s <canvas> implemented in Safari. It can be used for rendering graphs, UI elements, and other custom graphics on the client.', 16, NULL, NULL, NULL, '2005-08-24 16:05:03.406307', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://developer.mozilla.org/en/docs/Drawing_Graphics_with_Canvas', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (3, 'svg-support', 'Support Native SVG Objects', 'Scalable Vector Graphics (SVG) is an XML markup language for describing two-dimensional vector graphics. Mozilla should natively support embedded SVG images in HTML documents, or SVG served directly, much as PNG or JPEG images can be served.', 16, 13, 2, 28, '2005-08-24 16:10:05.078543', 4, NULL, NULL, NULL, NULL, 10, 70, 'http://developer.mozilla.org/en/docs/SVG', NULL, NULL, true, NULL, 75, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (4, 'e4x', 'Support E4X in EcmaScript', 'E4X adds native XML datatypes to the ECMAScript language, extends the semantics of familiar ECMAScript operators for manipulating XML objects and adds a small set of new operators for common XML operations, such as searching and filtering. It also adds support for XML literals, namespaces, qualified names and other mechanisms to facilitate XML processing.', 16, 14, 28, NULL, '2005-08-24 16:11:37.431981', 4, NULL, NULL, NULL, 1, 20, 0, 'http://www.ecma-international.org/publications/standards/Ecma-357.htm', 'This is the status whiteboard. Dig it?', NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (5, 'mergewin', 'Merge Open Browser Windows with "Consolidate Windows"', 'It should be possible to merge multiple open browser windows with a "Consolidate Windows" menu option.', 16, NULL, NULL, NULL, '2005-10-19 18:03:59.900723', 4, NULL, NULL, NULL, NULL, 40, 50, NULL, NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (6, 'media-integrity-check', 'CD Media Integrity Check', 'Sometimes, problems installing Ubuntu from CD are caused by bad sectors on the CD media itself. It should be easy to check the quality of the CD directly from within the installer.', 12, NULL, NULL, NULL, '2005-11-02 15:14:22.177596', NULL, NULL, 1, NULL, NULL, 35, 5, 'https://wiki.ubuntu.com/MediaIntegrityCheck', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (7, 'cluster-installation', 'Facilitate mass installs  of Ubuntu using Netboot configuration', 'We want to enable users to easily perform mass installations of Ubuntu on a pool of machines. We develop a console tool to intelligently manage dhcpd and syslinux configuration, and provide a GUI frontend for easy point and click configuration.
-
-N.B. We use the term ''cluster'' to mean ''a pool of machines''. While this could be a pool of cluster compute nodes, it doesn''t have to be. Because the mass-install infrastructure also provides generic netboot management, a more accurate name for this specification would be NetbootManagement.', 1, 8, 6, 33, '2006-04-12 07:34:37.765691', NULL, NULL, 5, 12, NULL, 10, 90, 'https://wiki.ubuntu.com/NetbootManagement', NULL, NULL, false, NULL, 65, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:34:37.765691', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (8, 'revu', 'The REVU Review Tracking System', 'Revu2 is a tool for assisting MOTUs to review packages. Packages are created mainly be contributors, but also by other tools.
-
-In future, REVU functionality will be integrated directly into Launchpad, to ensure a tight integration of both social and technical processes in the distribution.', 1, 14, NULL, 37, '2006-04-12 07:38:20.162251', NULL, NULL, 5, 12, NULL, 10, 70, 'https://wiki.ubuntu.com/REVU2Spec', NULL, NULL, false, NULL, 75, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:38:20.162251', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (9, 'usplash-on-hibernation', 'Activating Usplash during Hibernation', 'In order to conceal scary kernel messages, and provide some instruction and indication of progress to the user, usplash could be activated during the hibernation process.
-
-Progress indication is likely to be limited with the current swsusp implementation, and the question of when to power off the display should be considered.', 1, 14, NULL, 33, '2006-04-12 07:40:52.80865', NULL, NULL, 5, 12, NULL, 10, 10, 'http://wiki.ubuntu.com/UsplashHibernation', 'mark: mjg59 may want to be involved in the implementation too.', NULL, false, NULL, 95, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:40:52.80865', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (10, 'thinclient-local-devices', 'Support for local devices on Ubuntu thin clients', 'Provide support for locally-attached devices on thin clients, such as USB devices and floppy drives.', 1, 8, NULL, 6, '2006-04-12 07:44:42.314166', NULL, NULL, 5, 12, NULL, 10, 50, 'http://wiki.ubuntu.com/ThinClientLocalDevices', NULL, NULL, false, NULL, 90, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:44:42.314166', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (11, 'kde-desktopfile-langpacks', 'KDE Desktop File Language Packs', 'As of Kubuntu 5.10, language packs cannot provide updated translations for .desktop and .directory files (used for menu entries). We should make this possible.
-
-This spec deals with the KDE side; there is a separate spec for Gnome.', 1, 8, NULL, NULL, '2006-04-12 07:55:03.711218', NULL, NULL, 5, 12, NULL, 20, 5, 'https://wiki.ubuntu.com/LangpacksDesktopfilesKDE', 'mark - Do you think we can get this in for Krunch?', NULL, true, NULL, 0, 30, NULL, 1, '2006-08-06 16:11:59.8599', NULL, NULL, NULL, NULL, NULL, NULL, false);
-INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private) VALUES (12, 'krunch-desktop-plan', 'The Krunch Desktop Plan', 'This specification describes the plan for the Krunch Desktop. It will identify specific areas where additional polish will be added to ensure that Kapper is, in fact, krunchy.', 1, 33, NULL, NULL, '2006-04-12 07:57:24.675444', NULL, NULL, 5, 12, NULL, 35, 0, 'https://wiki.ubuntu.com/KrunchDesktopPlan', NULL, NULL, false, NULL, 0, 20, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:57:24.675444', NULL, NULL, NULL, NULL, false);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (1, 'extension-manager-upgrades', 'Extension Manager Upgrades', 'Simplify the way extensions are installed and registered so that: 1. third party applications can easily register and deregister extensions that live with their code. 2. developers can easily register extensions that they are developing out of a location apart from their build (e.g. their home directory), and  3. developers can easily install extensions for testing.', 16, 13, NULL, 1, '2005-08-24 16:03:46.479655', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://wiki.mozilla.org/Firefox:1.1_Product_Team', NULL, NULL, false, NULL, 95, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.866469', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (2, 'canvas', 'Support <canvas> Objects', 'With the Firefox 1.1 Developer Preview Release, Firefox includes a new HTML element for programmable graphics. <canvas> is based on the WhatWG canvas specification (http://www.whatwg.org/specs/web-apps/current-work/#graphics), which itself is based on Apple''s <canvas> implemented in Safari. It can be used for rendering graphs, UI elements, and other custom graphics on the client.', 16, NULL, NULL, NULL, '2005-08-24 16:05:03.406307', 4, NULL, NULL, NULL, NULL, 40, 50, 'http://developer.mozilla.org/en/docs/Drawing_Graphics_with_Canvas', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.868001', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (3, 'svg-support', 'Support Native SVG Objects', 'Scalable Vector Graphics (SVG) is an XML markup language for describing two-dimensional vector graphics. Mozilla should natively support embedded SVG images in HTML documents, or SVG served directly, much as PNG or JPEG images can be served.', 16, 13, 2, 28, '2005-08-24 16:10:05.078543', 4, NULL, NULL, NULL, NULL, 10, 70, 'http://developer.mozilla.org/en/docs/SVG', NULL, NULL, true, NULL, 75, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 13, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:54:58.869242', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (4, 'e4x', 'Support E4X in EcmaScript', 'E4X adds native XML datatypes to the ECMAScript language, extends the semantics of familiar ECMAScript operators for manipulating XML objects and adds a small set of new operators for common XML operations, such as searching and filtering. It also adds support for XML literals, namespaces, qualified names and other mechanisms to facilitate XML processing.', 16, 14, 28, NULL, '2005-08-24 16:11:37.431981', 4, NULL, NULL, NULL, 1, 20, 0, 'http://www.ecma-international.org/publications/standards/Ecma-357.htm', 'This is the status whiteboard. Dig it?', NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.869702', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (5, 'mergewin', 'Merge Open Browser Windows with "Consolidate Windows"', 'It should be possible to merge multiple open browser windows with a "Consolidate Windows" menu option.', 16, NULL, NULL, NULL, '2005-10-19 18:03:59.900723', 4, NULL, NULL, NULL, NULL, 40, 50, NULL, NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.870136', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (6, 'media-integrity-check', 'CD Media Integrity Check', 'Sometimes, problems installing Ubuntu from CD are caused by bad sectors on the CD media itself. It should be easy to check the quality of the CD directly from within the installer.', 12, NULL, NULL, NULL, '2005-11-02 15:14:22.177596', NULL, NULL, 1, NULL, NULL, 35, 5, 'https://wiki.ubuntu.com/MediaIntegrityCheck', NULL, NULL, false, NULL, 0, 30, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.870537', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (7, 'cluster-installation', 'Facilitate mass installs  of Ubuntu using Netboot configuration', 'We want to enable users to easily perform mass installations of Ubuntu on a pool of machines. We develop a console tool to intelligently manage dhcpd and syslinux configuration, and provide a GUI frontend for easy point and click configuration.
+
+N.B. We use the term ''cluster'' to mean ''a pool of machines''. While this could be a pool of cluster compute nodes, it doesn''t have to be. Because the mass-install infrastructure also provides generic netboot management, a more accurate name for this specification would be NetbootManagement.', 1, 8, 6, 33, '2006-04-12 07:34:37.765691', NULL, NULL, 5, 12, NULL, 10, 90, 'https://wiki.ubuntu.com/NetbootManagement', NULL, NULL, false, NULL, 65, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:34:37.765691', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:54:58.87097', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (8, 'revu', 'The REVU Review Tracking System', 'Revu2 is a tool for assisting MOTUs to review packages. Packages are created mainly be contributors, but also by other tools.
+
+In future, REVU functionality will be integrated directly into Launchpad, to ensure a tight integration of both social and technical processes in the distribution.', 1, 14, NULL, 37, '2006-04-12 07:38:20.162251', NULL, NULL, 5, 12, NULL, 10, 70, 'https://wiki.ubuntu.com/REVU2Spec', NULL, NULL, false, NULL, 75, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:38:20.162251', NULL, NULL, 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:54:58.871428', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (9, 'usplash-on-hibernation', 'Activating Usplash during Hibernation', 'In order to conceal scary kernel messages, and provide some instruction and indication of progress to the user, usplash could be activated during the hibernation process.
+
+Progress indication is likely to be limited with the current swsusp implementation, and the question of when to power off the display should be considered.', 1, 14, NULL, 33, '2006-04-12 07:40:52.80865', NULL, NULL, 5, 12, NULL, 10, 10, 'http://wiki.ubuntu.com/UsplashHibernation', 'mark: mjg59 may want to be involved in the implementation too.', NULL, false, NULL, 95, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:40:52.80865', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:54:58.872028', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (10, 'thinclient-local-devices', 'Support for local devices on Ubuntu thin clients', 'Provide support for locally-attached devices on thin clients, such as USB devices and floppy drives.', 1, 8, NULL, 6, '2006-04-12 07:44:42.314166', NULL, NULL, 5, 12, NULL, 10, 50, 'http://wiki.ubuntu.com/ThinClientLocalDevices', NULL, NULL, false, NULL, 90, 10, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:44:42.314166', 1, '2006-08-07 22:52:08.419316', 1, '2006-08-10 22:04:23.681392', false, '2012-01-25 05:54:58.872477', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (11, 'kde-desktopfile-langpacks', 'KDE Desktop File Language Packs', 'As of Kubuntu 5.10, language packs cannot provide updated translations for .desktop and .directory files (used for menu entries). We should make this possible.
+
+This spec deals with the KDE side; there is a separate spec for Gnome.', 1, 8, NULL, NULL, '2006-04-12 07:55:03.711218', NULL, NULL, 5, 12, NULL, 20, 5, 'https://wiki.ubuntu.com/LangpacksDesktopfilesKDE', 'mark - Do you think we can get this in for Krunch?', NULL, true, NULL, 0, 30, NULL, 1, '2006-08-06 16:11:59.8599', NULL, NULL, NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.872922', NULL);
+INSERT INTO specification (id, name, title, summary, owner, assignee, drafter, approver, datecreated, product, productseries, distribution, distroseries, milestone, definition_status, priority, specurl, whiteboard, superseded_by, direction_approved, man_days, implementation_status, goalstatus, fti, goal_proposer, date_goal_proposed, goal_decider, date_goal_decided, completer, date_completed, starter, date_started, private, date_last_changed, last_changed_by) VALUES (12, 'krunch-desktop-plan', 'The Krunch Desktop Plan', 'This specification describes the plan for the Krunch Desktop. It will identify specific areas where additional polish will be added to ensure that Kapper is, in fact, krunchy.', 1, 33, NULL, NULL, '2006-04-12 07:57:24.675444', NULL, NULL, 5, 12, NULL, 35, 0, 'https://wiki.ubuntu.com/KrunchDesktopPlan', NULL, NULL, false, NULL, 0, 20, NULL, 1, '2006-08-06 16:11:59.8599', 1, '2006-04-12 07:57:24.675444', NULL, NULL, NULL, NULL, false, '2012-01-25 05:54:58.873415', NULL);
 
 
 ALTER TABLE specification ENABLE TRIGGER ALL;

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2012-01-17 04:38:41 +0000
+++ database/schema/comments.sql	2012-01-25 09:58:44 +0000
@@ -615,7 +615,6 @@
 
 COMMENT ON COLUMN EmailAddress.email IS 'An email address used by a Person. The email address is stored in a casesensitive way, but must be case insensitivly unique.';
 COMMENT ON INDEX emailaddress__person__key IS 'Ensures that a Person only has one preferred email address';
-COMMENT ON INDEX emailaddress__account__key IS 'Ensures that an Account only has one preferred email address';
 
 
 -- FeaturedProject
@@ -1261,11 +1260,6 @@
 COMMENT ON COLUMN Account.displayname IS 'Name to display when rendering information about this account.';
 
 
--- AccountPassword
-COMMENT ON TABLE AccountPassword IS 'A password used to authenticate an Account.';
-COMMENT ON COLUMN AccountPassword.password IS 'SSHA digest encrypted password.';
-
-
 -- Person
 COMMENT ON TABLE Person IS 'A row represents a person if teamowner is NULL, and represents a team if teamowner is set.';
 COMMENT ON COLUMN Person.account IS 'The Account linked to this Person, if there is one.';

=== added file 'database/schema/patch-2209-01-1.sql'
--- database/schema/patch-2209-01-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-01-1.sql	2012-01-25 09:58:44 +0000
@@ -0,0 +1,10 @@
+-- Copyright 2012 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+SET client_min_messages=ERROR;
+
+ALTER TABLE accountpassword SET SCHEMA todrop;
+
+ALTER TABLE emailaddress ALTER COLUMN person SET NOT NULL;
+ALTER TABLE emailaddress DROP COLUMN account;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 01, 1);

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2012-01-18 17:16:39 +0000
+++ database/schema/security.cfg	2012-01-25 09:58:44 +0000
@@ -109,7 +109,6 @@
 public.accesspolicyartifact             = SELECT, INSERT, UPDATE, DELETE
 public.accesspolicygrant                = SELECT, INSERT, UPDATE, DELETE
 public.account                          = SELECT, INSERT, UPDATE, DELETE
-public.accountpassword                  = SELECT, INSERT, UPDATE, DELETE
 public.announcement                     = SELECT, INSERT, UPDATE, DELETE
 public.answercontact                    = SELECT, INSERT, UPDATE, DELETE
 public.apportjob                        = SELECT, INSERT, UPDATE, DELETE
@@ -549,7 +548,6 @@
 [checkwatches]
 groups=script
 public.account                          = SELECT, INSERT
-public.accountpassword                  = SELECT, INSERT
 public.answercontact                    = SELECT
 public.archive                          = SELECT
 public.binarypackagebuild               = SELECT
@@ -619,7 +617,6 @@
 [branchscanner]
 groups=write, script
 public.account                            = SELECT, INSERT
-public.accountpassword                    = SELECT, INSERT
 public.branch                             = SELECT, UPDATE
 public.branchjob                          = SELECT, INSERT, UPDATE, DELETE
 public.branchmergeproposal                = SELECT, UPDATE
@@ -811,7 +808,6 @@
 [gina]
 groups=write,script
 public.account                                = SELECT, INSERT
-public.accountpassword                        = SELECT, INSERT
 public.archive                                = SELECT, UPDATE
 public.archivearch                            = SELECT, UPDATE
 public.binarypackagepublishinghistory         = SELECT, INSERT, UPDATE, DELETE
@@ -1103,7 +1099,6 @@
 
 [write]
 public.account                          = SELECT, INSERT, UPDATE
-public.accountpassword                  = SELECT, INSERT
 public.archive                          = SELECT, INSERT, UPDATE
 public.archivearch                      = SELECT, INSERT, UPDATE, DELETE
 public.archivejob                       = SELECT, INSERT
@@ -1213,7 +1208,6 @@
 [answertracker]
 groups=script
 public.account                          = SELECT, INSERT
-public.accountpassword                  = SELECT, INSERT
 public.answercontact                    = SELECT
 public.bug                              = SELECT
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
@@ -1249,7 +1243,6 @@
 
 [uploading]
 public.account                          = SELECT, INSERT
-public.accountpassword                  = SELECT, INSERT
 public.answercontact                    = SELECT
 public.archive                          = SELECT, INSERT, UPDATE
 public.archivearch                      = SELECT, INSERT, UPDATE
@@ -1652,7 +1645,6 @@
 [processmail]
 groups=script
 public.account                          = SELECT, INSERT
-public.accountpassword                  = SELECT, INSERT
 public.answercontact                    = SELECT
 public.archive                          = SELECT
 public.archivearch                      = SELECT
@@ -1809,7 +1801,6 @@
 [create-merge-proposals]
 groups=script
 public.account                          = SELECT
-public.accountpassword                  = SELECT
 public.branch                           = SELECT, INSERT, UPDATE
 public.branchjob                        = SELECT, INSERT
 public.branchmergeproposal              = SELECT, INSERT, UPDATE
@@ -1844,7 +1835,6 @@
 [merge-proposal-jobs]
 groups=script
 public.account                          = SELECT
-public.accountpassword                  = SELECT
 public.branch                           = SELECT
 public.branchjob                        = SELECT
 public.branchmergeproposal              = SELECT, INSERT, UPDATE
@@ -1893,7 +1883,6 @@
 [send-branch-mail]
 groups=script
 public.account                          = SELECT
-public.accountpassword                  = SELECT
 public.branch                           = SELECT
 public.branchjob                        = SELECT
 public.branchmergeproposal              = SELECT, INSERT, UPDATE
@@ -1935,7 +1924,6 @@
 [updateremoteproduct]
 groups=script
 public.account                          = SELECT, INSERT, UPDATE
-public.accountpassword                  = SELECT, INSERT
 public.bug                              = SELECT, INSERT, UPDATE
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
 public.bugjob                           = SELECT, INSERT
@@ -2298,6 +2286,4 @@
 [pgmetrics]
 type=user
 groups=read
-public.accountpassword = SELECT
-public.oauthnonce = SELECT
 public.openidconsumernonce = SELECT

=== modified file 'database/schema/security.py'
--- database/schema/security.py	2011-12-30 06:47:17 +0000
+++ database/schema/security.py	2012-01-25 09:58:44 +0000
@@ -29,8 +29,6 @@
 # tables. This is to stop the ro user being given access to secrurity
 # sensitive information that interactive sessions don't need.
 SECURE_TABLES = set((
-    'public.accountpassword',
-    'public.accountpassword_id_seq',
     'public.oauthnonce',
     'public.oauthnonce_id_seq',
     'public.openidnonce',


Follow ups