Launchpad itself

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

  1. drop-accountish-bits
  2. Merge into db-devel
Proposed by William Grant
Status: Merged
Merged at revision: 11326
Proposed branch: lp:~wgrant/launchpad/drop-accountish-bits
Merge into: lp:launchpad/db-devel
Prerequisite: lp:launchpad
Diff against target: 836 lines (+247/-380)
6 files modified
database/sampledata/current-dev.sql (+135/-196)
database/sampledata/current.sql (+102/-163)
database/schema/comments.sql (+0/-6)
database/schema/patch-2209-01-1.sql (+10/-0)
database/schema/security.cfg (+0/-13)
database/schema/security.py (+0/-2)
To merge this branch: bzr merge lp:~wgrant/launchpad/drop-accountish-bits
Reviewer Review Type Date Requested Status
Stuart Bishop (community) db Approve
Robert Collins db Pending
Launchpad code reviewers Pending
Review via email: mp+90062@code.launchpad.net

Commit message

Drop unused EmailAddress.account and AccountPassword.

Description of the change

Drop unused EmailAddress.account and AccountPassword.

To post a comment you must log in.
Revision history for this message
Stuart Bishop (stub) wrote :

Yay. Thanks for this.

review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/sampledata/current-dev.sql'
2--- database/sampledata/current-dev.sql 2012-01-17 23:55:44 +0000
3+++ database/sampledata/current-dev.sql 2012-01-25 10:05:33 +0000
4@@ -1,6 +1,6 @@
5 -- Copyright 2010-2011 Canonical Ltd. This software is licensed under the
6 -- GNU Affero General Public License version 3 (see the file LICENSE).
7--- Created using pg_dump (PostgreSQL) 8.4.9
8+-- Created using pg_dump (PostgreSQL) 8.4.10
9
10 SET check_function_bodies = false;
11 SET client_encoding = 'UTF8';
12@@ -759,9 +759,6 @@
13
14
15
16-
17-
18-
19 SET SESSION AUTHORIZATION DEFAULT;
20
21 ALTER TABLE account DISABLE TRIGGER ALL;
22@@ -2043,64 +2040,6 @@
23 ALTER TABLE accesspolicygrant ENABLE TRIGGER ALL;
24
25
26-ALTER TABLE accountpassword DISABLE TRIGGER ALL;
27-
28-INSERT INTO accountpassword (id, account, password) VALUES (1, 11, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
29-INSERT INTO accountpassword (id, account, password) VALUES (2, 21, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
30-INSERT INTO accountpassword (id, account, password) VALUES (4, 41, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
31-INSERT INTO accountpassword (id, account, password) VALUES (6, 61, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
32-INSERT INTO accountpassword (id, account, password) VALUES (8, 81, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
33-INSERT INTO accountpassword (id, account, password) VALUES (11, 111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
34-INSERT INTO accountpassword (id, account, password) VALUES (12, 121, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
35-INSERT INTO accountpassword (id, account, password) VALUES (13, 131, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
36-INSERT INTO accountpassword (id, account, password) VALUES (14, 141, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
37-INSERT INTO accountpassword (id, account, password) VALUES (16, 161, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
38-INSERT INTO accountpassword (id, account, password) VALUES (22, 221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
39-INSERT INTO accountpassword (id, account, password) VALUES (23, 231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
40-INSERT INTO accountpassword (id, account, password) VALUES (27, 271, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
41-INSERT INTO accountpassword (id, account, password) VALUES (28, 281, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
42-INSERT INTO accountpassword (id, account, password) VALUES (29, 291, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
43-INSERT INTO accountpassword (id, account, password) VALUES (33, 331, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
44-INSERT INTO accountpassword (id, account, password) VALUES (34, 341, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
45-INSERT INTO accountpassword (id, account, password) VALUES (35, 351, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
46-INSERT INTO accountpassword (id, account, password) VALUES (36, 361, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
47-INSERT INTO accountpassword (id, account, password) VALUES (37, 371, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
48-INSERT INTO accountpassword (id, account, password) VALUES (38, 381, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
49-INSERT INTO accountpassword (id, account, password) VALUES (39, 391, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
50-INSERT INTO accountpassword (id, account, password) VALUES (40, 401, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
51-INSERT INTO accountpassword (id, account, password) VALUES (41, 411, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
52-INSERT INTO accountpassword (id, account, password) VALUES (42, 421, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
53-INSERT INTO accountpassword (id, account, password) VALUES (43, 431, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
54-INSERT INTO accountpassword (id, account, password) VALUES (44, 441, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
55-INSERT INTO accountpassword (id, account, password) VALUES (45, 451, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
56-INSERT INTO accountpassword (id, account, password) VALUES (46, 461, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
57-INSERT INTO accountpassword (id, account, password) VALUES (47, 471, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
58-INSERT INTO accountpassword (id, account, password) VALUES (48, 481, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
59-INSERT INTO accountpassword (id, account, password) VALUES (49, 491, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
60-INSERT INTO accountpassword (id, account, password) VALUES (50, 501, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
61-INSERT INTO accountpassword (id, account, password) VALUES (51, 511, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
62-INSERT INTO accountpassword (id, account, password) VALUES (52, 521, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
63-INSERT INTO accountpassword (id, account, password) VALUES (55, 551, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
64-INSERT INTO accountpassword (id, account, password) VALUES (56, 561, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
65-INSERT INTO accountpassword (id, account, password) VALUES (58, 581, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
66-INSERT INTO accountpassword (id, account, password) VALUES (63, 631, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
67-INSERT INTO accountpassword (id, account, password) VALUES (68, 681, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
68-INSERT INTO accountpassword (id, account, password) VALUES (243602, 2436021, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
69-INSERT INTO accountpassword (id, account, password) VALUES (243603, 2436031, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
70-INSERT INTO accountpassword (id, account, password) VALUES (243610, 2436101, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
71-INSERT INTO accountpassword (id, account, password) VALUES (243611, 2436111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
72-INSERT INTO accountpassword (id, account, password) VALUES (243617, 2436171, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
73-INSERT INTO accountpassword (id, account, password) VALUES (243622, 2436221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
74-INSERT INTO accountpassword (id, account, password) VALUES (243623, 2436231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
75-INSERT INTO accountpassword (id, account, password) VALUES (243624, 261, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
76-INSERT INTO accountpassword (id, account, password) VALUES (243625, 71, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
77-INSERT INTO accountpassword (id, account, password) VALUES (243626, 31, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
78-INSERT INTO accountpassword (id, account, password) VALUES (243629, 2436242, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
79-
80-
81-ALTER TABLE accountpassword ENABLE TRIGGER ALL;
82-
83-
84 ALTER TABLE announcement DISABLE TRIGGER ALL;
85
86 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);
87@@ -4008,86 +3947,86 @@
88
89 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
90
91-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (1, 'mark@example.com', 1, 4, '2006-10-16 18:31:43.540582', 11);
92-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (2, 'robertc@robertcollins.net', 2, 4, '2006-10-16 18:31:43.542552', 21);
93-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (3, 'carlos@canonical.com', 13, 4, '2006-10-16 18:31:43.542954', 131);
94-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (4, 'daf@canonical.com', 14, 4, '2006-10-16 18:31:43.543302', 141);
95-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (6, 'foo.bar@canonical.com', 16, 4, '2006-10-16 18:31:43.543649', 161);
96-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (7, 'steve.alexander@ubuntulinux.com', 11, 4, '2006-10-16 18:31:43.543996', 111);
97-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (8, 'colin.watson@ubuntulinux.com', 4, 4, '2006-10-16 18:31:43.544344', 41);
98-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (9, 'scott.james.remnant@ubuntulinux.com', 5, 1, '2006-10-16 18:31:43.544693', 51);
99-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (10, 'andrew.bennetts@ubuntulinux.com', 7, 4, '2006-10-16 18:31:43.54507', 71);
100-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (11, 'james.blackwell@ubuntulinux.com', 8, 4, '2006-10-16 18:31:43.54542', 81);
101-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (12, 'christian.reis@ubuntulinux.com', 9, 4, '2006-10-16 18:31:43.54577', 91);
102-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (13, 'jeff.waugh@ubuntulinux.com', 6, 4, '2006-10-16 18:31:43.54612', 61);
103-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (14, 'dave.miller@ubuntulinux.com', 3, 4, '2006-10-16 18:31:43.546658', 31);
104-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (15, 'justdave@bugzilla.org', 3, 1, '2006-10-16 18:31:43.547068', 31);
105-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (16, 'test@canonical.com', 12, 4, '2006-10-16 18:31:43.547451', 121);
106-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (17, 'testtest@canonical.com', 12, 1, '2006-10-16 18:31:43.547829', 121);
107-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (18, 'testtesttest@canonical.com', 12, 3, '2006-10-16 18:31:43.54821', 121);
108-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (19, 'testing@canonical.com', 12, 2, '2006-10-16 18:31:43.548591', 121);
109-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (20, 'stuart.bishop@canonical.com', 22, 4, '2006-10-16 18:31:43.548972', 221);
110-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (21, 'david.allouche@canonical.com', 23, 4, '2006-10-16 18:31:43.549353', 231);
111-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (22, 'david@canonical.com', 23, 2, '2006-10-16 18:31:43.549732', 231);
112-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (23, 'daniel.debonzi@canonical.com', 27, 4, '2006-10-16 18:31:43.550113', 271);
113-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (24, 'celso.providelo@canonical.com', 28, 4, '2006-10-16 18:31:43.608939', 281);
114-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (25, 'guilherme.salgado@canonical.com', 29, 4, '2006-10-16 18:31:43.609431', 291);
115-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (26, 'edgar@monteparadiso.hr', 33, 4, '2006-10-16 18:31:43.609819', 331);
116-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (27, 'jvprat@wanadoo.es', 34, 1, '2006-10-16 18:31:43.610202', 341);
117-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (28, 'sigurd-ubuntu@brogar.org', 35, 1, '2006-10-16 18:31:43.6147', 351);
118-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (29, 'skacel@svtech.cz', 36, 1, '2006-10-16 18:31:43.615107', 361);
119-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (30, 'danner@mixmail.com', 37, 1, '2006-10-16 18:31:43.61549', 371);
120-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (31, 'martin.pitt@canonical.com', 38, 1, '2006-10-16 18:31:43.615874', 381);
121-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (32, 'nsv@fr.st', 39, 1, '2006-10-16 18:31:43.616257', 391);
122-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (33, 'callipeo@libero.it', 40, 1, '2006-10-16 18:31:43.616673', 401);
123-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (34, 'jorge.gonzalez.gonzalez@hispalinux.es', 41, 1, '2006-10-16 18:31:43.617057', 411);
124-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (35, 'barbier@linuxfr.org', 42, 1, '2006-10-16 18:31:43.617465', 421);
125-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (36, 'andrelop@debian.org', 43, 1, '2006-10-16 18:31:43.61785', 431);
126-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (37, 'valyag@dat.etsit.upm.es', 44, 1, '2006-10-16 18:31:43.618232', 441);
127-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (38, 'luk.claes@ugent.be', 45, 1, '2006-10-16 18:31:43.618658', 451);
128-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (39, 'kurem@debian.cz', 46, 4, '2006-10-16 18:31:43.619039', 461);
129-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (40, 'morten@wtf.dk', 47, 1, '2006-10-16 18:31:43.619421', 471);
130-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (41, 'mpo@iki.fi', 48, 1, '2006-10-16 18:31:43.619815', 481);
131-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (42, 'kebil@kaunas.init.lt', 49, 1, '2006-10-16 18:31:43.620196', 491);
132-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (43, 'tsukimi@quaqua.net', 50, 4, '2006-10-16 18:31:43.620578', 501);
133-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (44, 'kreutzm@itp.uni-hannover.de', 51, 4, '2006-10-16 18:31:43.620959', 511);
134-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (45, 'support@ubuntu.com', 17, 4, '2006-10-16 18:31:43.621341', NULL);
135-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (46, 'no-priv@canonical.com', 52, 4, '2006-10-16 18:31:43.621725', 521);
136-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (47, 'stuart@stuartbishop.net', 22, 2, '2006-10-16 18:31:43.622107', 221);
137-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (48, 'zen@shangri-la.dropbear.id.au', 22, 3, '2006-10-16 18:31:43.6241', 221);
138-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (49, 'stub@fastmail.fm', 22, 1, '2006-10-16 18:31:43.6245', 221);
139-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (50, 'marilize@hbd.com', 55, 4, '2006-10-16 18:31:43.624885', 551);
140-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (51, 'jordi@ubuntu.com', 56, 4, '2006-10-16 18:31:43.625266', 561);
141-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (52, 'daniel.silverstone@canonical.com', 26, 4, '2006-10-16 18:31:43.625647', 261);
142-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (53, 'bug-importer@launchpad.net', 58, 4, '2006-10-16 18:31:43.62603', 581);
143-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (54, 'rosetta@launchpad.net', 30, 4, '2006-10-16 18:31:43.626521', NULL);
144-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (55, 'salgado@ubuntu.com', 29, 1, '2006-10-16 18:31:43.626932', 291);
145-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (56, 'cprov@ubuntu.com', 28, 2, '2006-10-16 18:31:43.627318', 281);
146-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (57, 'bugwatch@bugs.launchpad.net', 62, 4, '2006-10-16 18:31:43.62774', 621);
147-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (58, 'karl@canonical.com', 63, 4, '2006-10-16 18:31:43.628123', 631);
148-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (59, 'limi@plone.org', 10, 4, '2006-10-16 18:31:43.628504', 101);
149-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (60, 'janitor@launchpad.net', 65, 4, '2006-10-17 23:23:23.232323', 651);
150-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (61, 'matsubara@async.com.br', 66, 1, '2006-12-13 21:19:06.369142', 661);
151-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (62, 'no-team-memberships@test.com', 243602, 4, '2007-02-19 11:17:57.755666', 2436021);
152-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (63, 'one-membership@test.com', 243603, 4, '2007-02-21 10:53:59.700105', 2436031);
153-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (64, 'beta-admin@launchpad.net', 68, 4, '2007-01-31 06:56:25.096519', 681);
154-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (66, 'launchpad@julian-edwards.com', 243606, 1, '2007-08-09 21:25:37.832976', 2436061);
155-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (67, 'doc@lists.ubuntu.com', 243608, 1, '2007-11-12 15:23:19.847132', 2436081);
156-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (68, 'carlos@test.com', 13, 2, '2006-10-16 18:31:43.548591', 131);
157-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (69, 'archive@ubuntu.com', 243609, 4, '2007-12-07 13:43:20.393704', 2436091);
158-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (70, 'member@canonical.com', 243610, 4, '2007-12-14 16:52:15.403833', 2436101);
159-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (71, 'owner@canonical.com', 243611, 4, '2007-12-14 16:52:15.403833', 2436111);
160-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (72, 'jbuhl_nospam@gmx.de', 243614, 1, '2007-12-18 16:31:34.790641', 2436141);
161-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (73, 'sjoerd@spring.luon.net', 243615, 1, '2007-12-18 16:31:34.790641', 2436151);
162-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (74, 'mpitt@debian.org', 243616, 1, '2007-12-18 16:31:34.790641', 2436161);
163-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (75, 'tim@canonical.com', 243617, 4, '2008-03-06 09:55:27.289842', 2436171);
164-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (76, 'commercial-member@canonical.com', 243622, 4, '2008-05-12 17:38:38.798696', 2436221);
165-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (77, 'former-user@canonical.com', 70, 3, '2006-05-12 17:38:38.798696', 701);
166-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (78, 'bac@canonical.com', 243623, 4, '2008-06-27 14:49:11.149508', 2436231);
167-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (79, 'admin@canonical.com', 16, 2, '2008-08-05 12:01:32.086327', 161);
168-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843', 2436241);
169-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407', 2436243);
170-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885', 243637);
171+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@example.com', 1, 4, '2006-10-16 18:31:43.540582');
172+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (2, 'robertc@robertcollins.net', 2, 4, '2006-10-16 18:31:43.542552');
173+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (3, 'carlos@canonical.com', 13, 4, '2006-10-16 18:31:43.542954');
174+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (4, 'daf@canonical.com', 14, 4, '2006-10-16 18:31:43.543302');
175+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (6, 'foo.bar@canonical.com', 16, 4, '2006-10-16 18:31:43.543649');
176+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (7, 'steve.alexander@ubuntulinux.com', 11, 4, '2006-10-16 18:31:43.543996');
177+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (8, 'colin.watson@ubuntulinux.com', 4, 4, '2006-10-16 18:31:43.544344');
178+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (9, 'scott.james.remnant@ubuntulinux.com', 5, 1, '2006-10-16 18:31:43.544693');
179+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (10, 'andrew.bennetts@ubuntulinux.com', 7, 4, '2006-10-16 18:31:43.54507');
180+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (11, 'james.blackwell@ubuntulinux.com', 8, 4, '2006-10-16 18:31:43.54542');
181+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (12, 'christian.reis@ubuntulinux.com', 9, 4, '2006-10-16 18:31:43.54577');
182+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (13, 'jeff.waugh@ubuntulinux.com', 6, 4, '2006-10-16 18:31:43.54612');
183+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (14, 'dave.miller@ubuntulinux.com', 3, 4, '2006-10-16 18:31:43.546658');
184+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (15, 'justdave@bugzilla.org', 3, 1, '2006-10-16 18:31:43.547068');
185+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (16, 'test@canonical.com', 12, 4, '2006-10-16 18:31:43.547451');
186+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (17, 'testtest@canonical.com', 12, 1, '2006-10-16 18:31:43.547829');
187+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (18, 'testtesttest@canonical.com', 12, 3, '2006-10-16 18:31:43.54821');
188+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (19, 'testing@canonical.com', 12, 2, '2006-10-16 18:31:43.548591');
189+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (20, 'stuart.bishop@canonical.com', 22, 4, '2006-10-16 18:31:43.548972');
190+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (21, 'david.allouche@canonical.com', 23, 4, '2006-10-16 18:31:43.549353');
191+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (22, 'david@canonical.com', 23, 2, '2006-10-16 18:31:43.549732');
192+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (23, 'daniel.debonzi@canonical.com', 27, 4, '2006-10-16 18:31:43.550113');
193+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (24, 'celso.providelo@canonical.com', 28, 4, '2006-10-16 18:31:43.608939');
194+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (25, 'guilherme.salgado@canonical.com', 29, 4, '2006-10-16 18:31:43.609431');
195+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (26, 'edgar@monteparadiso.hr', 33, 4, '2006-10-16 18:31:43.609819');
196+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (27, 'jvprat@wanadoo.es', 34, 1, '2006-10-16 18:31:43.610202');
197+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (28, 'sigurd-ubuntu@brogar.org', 35, 1, '2006-10-16 18:31:43.6147');
198+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (29, 'skacel@svtech.cz', 36, 1, '2006-10-16 18:31:43.615107');
199+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (30, 'danner@mixmail.com', 37, 1, '2006-10-16 18:31:43.61549');
200+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (31, 'martin.pitt@canonical.com', 38, 1, '2006-10-16 18:31:43.615874');
201+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (32, 'nsv@fr.st', 39, 1, '2006-10-16 18:31:43.616257');
202+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (33, 'callipeo@libero.it', 40, 1, '2006-10-16 18:31:43.616673');
203+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (34, 'jorge.gonzalez.gonzalez@hispalinux.es', 41, 1, '2006-10-16 18:31:43.617057');
204+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (35, 'barbier@linuxfr.org', 42, 1, '2006-10-16 18:31:43.617465');
205+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (36, 'andrelop@debian.org', 43, 1, '2006-10-16 18:31:43.61785');
206+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (37, 'valyag@dat.etsit.upm.es', 44, 1, '2006-10-16 18:31:43.618232');
207+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (38, 'luk.claes@ugent.be', 45, 1, '2006-10-16 18:31:43.618658');
208+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (39, 'kurem@debian.cz', 46, 4, '2006-10-16 18:31:43.619039');
209+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (40, 'morten@wtf.dk', 47, 1, '2006-10-16 18:31:43.619421');
210+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (41, 'mpo@iki.fi', 48, 1, '2006-10-16 18:31:43.619815');
211+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (42, 'kebil@kaunas.init.lt', 49, 1, '2006-10-16 18:31:43.620196');
212+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (43, 'tsukimi@quaqua.net', 50, 4, '2006-10-16 18:31:43.620578');
213+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (44, 'kreutzm@itp.uni-hannover.de', 51, 4, '2006-10-16 18:31:43.620959');
214+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (45, 'support@ubuntu.com', 17, 4, '2006-10-16 18:31:43.621341');
215+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (46, 'no-priv@canonical.com', 52, 4, '2006-10-16 18:31:43.621725');
216+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (47, 'stuart@stuartbishop.net', 22, 2, '2006-10-16 18:31:43.622107');
217+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (48, 'zen@shangri-la.dropbear.id.au', 22, 3, '2006-10-16 18:31:43.6241');
218+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (49, 'stub@fastmail.fm', 22, 1, '2006-10-16 18:31:43.6245');
219+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (50, 'marilize@hbd.com', 55, 4, '2006-10-16 18:31:43.624885');
220+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (51, 'jordi@ubuntu.com', 56, 4, '2006-10-16 18:31:43.625266');
221+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (52, 'daniel.silverstone@canonical.com', 26, 4, '2006-10-16 18:31:43.625647');
222+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (53, 'bug-importer@launchpad.net', 58, 4, '2006-10-16 18:31:43.62603');
223+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (54, 'rosetta@launchpad.net', 30, 4, '2006-10-16 18:31:43.626521');
224+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (55, 'salgado@ubuntu.com', 29, 1, '2006-10-16 18:31:43.626932');
225+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (56, 'cprov@ubuntu.com', 28, 2, '2006-10-16 18:31:43.627318');
226+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (57, 'bugwatch@bugs.launchpad.net', 62, 4, '2006-10-16 18:31:43.62774');
227+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (58, 'karl@canonical.com', 63, 4, '2006-10-16 18:31:43.628123');
228+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (59, 'limi@plone.org', 10, 4, '2006-10-16 18:31:43.628504');
229+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (60, 'janitor@launchpad.net', 65, 4, '2006-10-17 23:23:23.232323');
230+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (61, 'matsubara@async.com.br', 66, 1, '2006-12-13 21:19:06.369142');
231+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (62, 'no-team-memberships@test.com', 243602, 4, '2007-02-19 11:17:57.755666');
232+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (63, 'one-membership@test.com', 243603, 4, '2007-02-21 10:53:59.700105');
233+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (64, 'beta-admin@launchpad.net', 68, 4, '2007-01-31 06:56:25.096519');
234+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (66, 'launchpad@julian-edwards.com', 243606, 1, '2007-08-09 21:25:37.832976');
235+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (67, 'doc@lists.ubuntu.com', 243608, 1, '2007-11-12 15:23:19.847132');
236+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (68, 'carlos@test.com', 13, 2, '2006-10-16 18:31:43.548591');
237+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (69, 'archive@ubuntu.com', 243609, 4, '2007-12-07 13:43:20.393704');
238+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (70, 'member@canonical.com', 243610, 4, '2007-12-14 16:52:15.403833');
239+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (71, 'owner@canonical.com', 243611, 4, '2007-12-14 16:52:15.403833');
240+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (72, 'jbuhl_nospam@gmx.de', 243614, 1, '2007-12-18 16:31:34.790641');
241+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (73, 'sjoerd@spring.luon.net', 243615, 1, '2007-12-18 16:31:34.790641');
242+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (74, 'mpitt@debian.org', 243616, 1, '2007-12-18 16:31:34.790641');
243+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (75, 'tim@canonical.com', 243617, 4, '2008-03-06 09:55:27.289842');
244+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (76, 'commercial-member@canonical.com', 243622, 4, '2008-05-12 17:38:38.798696');
245+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (77, 'former-user@canonical.com', 70, 3, '2006-05-12 17:38:38.798696');
246+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (78, 'bac@canonical.com', 243623, 4, '2008-06-27 14:49:11.149508');
247+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (79, 'admin@canonical.com', 16, 2, '2008-08-05 12:01:32.086327');
248+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843');
249+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407');
250+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885');
251
252
253 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
254@@ -10078,40 +10017,40 @@
255
256 ALTER TABLE sourcepackagepublishinghistory DISABLE TRIGGER ALL;
257
258-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);
259-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);
260-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);
261-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);
262-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);
263-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);
264-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);
265-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);
266-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);
267-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);
268-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);
269-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);
270-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);
271-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);
272-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);
273-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);
274-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);
275-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);
276-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);
277-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);
278-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);
279-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);
280-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);
281-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);
282-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);
283-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);
284-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);
285-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);
286-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);
287-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);
288-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);
289-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);
290-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);
291-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);
292+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);
293+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);
294+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);
295+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);
296+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);
297+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);
298+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);
299+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);
300+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);
301+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);
302+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);
303+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);
304+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);
305+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);
306+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);
307+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);
308+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);
309+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);
310+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);
311+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);
312+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);
313+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);
314+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);
315+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);
316+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);
317+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);
318+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);
319+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);
320+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);
321+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);
322+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);
323+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);
324+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);
325+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);
326
327
328 ALTER TABLE sourcepackagepublishinghistory ENABLE TRIGGER ALL;
329@@ -10168,26 +10107,26 @@
330
331 ALTER TABLE specification DISABLE TRIGGER ALL;
332
333-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);
334-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);
335-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);
336-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);
337-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);
338-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);
339-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.
340-
341-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);
342-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.
343-
344-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);
345-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.
346-
347-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);
348-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);
349-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.
350-
351-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);
352-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);
353+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);
354+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);
355+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);
356+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);
357+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);
358+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);
359+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.
360+
361+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);
362+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.
363+
364+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);
365+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.
366+
367+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);
368+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);
369+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.
370+
371+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);
372+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);
373
374
375 ALTER TABLE specification ENABLE TRIGGER ALL;
376
377=== modified file 'database/sampledata/current.sql'
378--- database/sampledata/current.sql 2012-01-19 22:34:39 +0000
379+++ database/sampledata/current.sql 2012-01-25 10:05:33 +0000
380@@ -1,6 +1,6 @@
381--- Copyright 2010-2012 Canonical Ltd. This software is licensed under the
382+-- Copyright 2010-2011 Canonical Ltd. This software is licensed under the
383 -- GNU Affero General Public License version 3 (see the file LICENSE).
384--- Created using pg_dump (PostgreSQL) 8.4.9
385+-- Created using pg_dump (PostgreSQL) 8.4.10
386
387 SET check_function_bodies = false;
388 SET client_encoding = 'UTF8';
389@@ -759,9 +759,6 @@
390
391
392
393-
394-
395-
396 SET SESSION AUTHORIZATION DEFAULT;
397
398 ALTER TABLE account DISABLE TRIGGER ALL;
399@@ -2041,64 +2038,6 @@
400 ALTER TABLE accesspolicygrant ENABLE TRIGGER ALL;
401
402
403-ALTER TABLE accountpassword DISABLE TRIGGER ALL;
404-
405-INSERT INTO accountpassword (id, account, password) VALUES (1, 11, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
406-INSERT INTO accountpassword (id, account, password) VALUES (2, 21, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
407-INSERT INTO accountpassword (id, account, password) VALUES (4, 41, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
408-INSERT INTO accountpassword (id, account, password) VALUES (6, 61, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
409-INSERT INTO accountpassword (id, account, password) VALUES (8, 81, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
410-INSERT INTO accountpassword (id, account, password) VALUES (11, 111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
411-INSERT INTO accountpassword (id, account, password) VALUES (12, 121, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
412-INSERT INTO accountpassword (id, account, password) VALUES (13, 131, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
413-INSERT INTO accountpassword (id, account, password) VALUES (14, 141, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
414-INSERT INTO accountpassword (id, account, password) VALUES (16, 161, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
415-INSERT INTO accountpassword (id, account, password) VALUES (22, 221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
416-INSERT INTO accountpassword (id, account, password) VALUES (23, 231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
417-INSERT INTO accountpassword (id, account, password) VALUES (27, 271, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
418-INSERT INTO accountpassword (id, account, password) VALUES (28, 281, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
419-INSERT INTO accountpassword (id, account, password) VALUES (29, 291, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
420-INSERT INTO accountpassword (id, account, password) VALUES (33, 331, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
421-INSERT INTO accountpassword (id, account, password) VALUES (34, 341, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
422-INSERT INTO accountpassword (id, account, password) VALUES (35, 351, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
423-INSERT INTO accountpassword (id, account, password) VALUES (36, 361, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
424-INSERT INTO accountpassword (id, account, password) VALUES (37, 371, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
425-INSERT INTO accountpassword (id, account, password) VALUES (38, 381, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
426-INSERT INTO accountpassword (id, account, password) VALUES (39, 391, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
427-INSERT INTO accountpassword (id, account, password) VALUES (40, 401, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
428-INSERT INTO accountpassword (id, account, password) VALUES (41, 411, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
429-INSERT INTO accountpassword (id, account, password) VALUES (42, 421, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
430-INSERT INTO accountpassword (id, account, password) VALUES (43, 431, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
431-INSERT INTO accountpassword (id, account, password) VALUES (44, 441, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
432-INSERT INTO accountpassword (id, account, password) VALUES (45, 451, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
433-INSERT INTO accountpassword (id, account, password) VALUES (46, 461, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
434-INSERT INTO accountpassword (id, account, password) VALUES (47, 471, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
435-INSERT INTO accountpassword (id, account, password) VALUES (48, 481, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
436-INSERT INTO accountpassword (id, account, password) VALUES (49, 491, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
437-INSERT INTO accountpassword (id, account, password) VALUES (50, 501, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
438-INSERT INTO accountpassword (id, account, password) VALUES (51, 511, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
439-INSERT INTO accountpassword (id, account, password) VALUES (52, 521, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
440-INSERT INTO accountpassword (id, account, password) VALUES (55, 551, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
441-INSERT INTO accountpassword (id, account, password) VALUES (56, 561, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
442-INSERT INTO accountpassword (id, account, password) VALUES (58, 581, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
443-INSERT INTO accountpassword (id, account, password) VALUES (63, 631, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
444-INSERT INTO accountpassword (id, account, password) VALUES (68, 681, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
445-INSERT INTO accountpassword (id, account, password) VALUES (243602, 2436021, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
446-INSERT INTO accountpassword (id, account, password) VALUES (243603, 2436031, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
447-INSERT INTO accountpassword (id, account, password) VALUES (243610, 2436101, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
448-INSERT INTO accountpassword (id, account, password) VALUES (243611, 2436111, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
449-INSERT INTO accountpassword (id, account, password) VALUES (243617, 2436171, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
450-INSERT INTO accountpassword (id, account, password) VALUES (243622, 2436221, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
451-INSERT INTO accountpassword (id, account, password) VALUES (243623, 2436231, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
452-INSERT INTO accountpassword (id, account, password) VALUES (243624, 261, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
453-INSERT INTO accountpassword (id, account, password) VALUES (243625, 71, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
454-INSERT INTO accountpassword (id, account, password) VALUES (243626, 31, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
455-INSERT INTO accountpassword (id, account, password) VALUES (243629, 2436242, 'K7Qmeansl6RbuPfulfcmyDQOzp70OxVh5Fcf');
456-
457-
458-ALTER TABLE accountpassword ENABLE TRIGGER ALL;
459-
460-
461 ALTER TABLE announcement DISABLE TRIGGER ALL;
462
463 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);
464@@ -3941,86 +3880,86 @@
465
466 ALTER TABLE emailaddress DISABLE TRIGGER ALL;
467
468-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (1, 'mark@example.com', 1, 4, '2006-10-16 18:31:43.540582', 11);
469-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (2, 'robertc@robertcollins.net', 2, 4, '2006-10-16 18:31:43.542552', 21);
470-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (3, 'carlos@canonical.com', 13, 4, '2006-10-16 18:31:43.542954', 131);
471-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (4, 'daf@canonical.com', 14, 4, '2006-10-16 18:31:43.543302', 141);
472-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (6, 'foo.bar@canonical.com', 16, 4, '2006-10-16 18:31:43.543649', 161);
473-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (7, 'steve.alexander@ubuntulinux.com', 11, 4, '2006-10-16 18:31:43.543996', 111);
474-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (8, 'colin.watson@ubuntulinux.com', 4, 4, '2006-10-16 18:31:43.544344', 41);
475-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (9, 'scott.james.remnant@ubuntulinux.com', 5, 1, '2006-10-16 18:31:43.544693', 51);
476-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (10, 'andrew.bennetts@ubuntulinux.com', 7, 4, '2006-10-16 18:31:43.54507', 71);
477-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (11, 'james.blackwell@ubuntulinux.com', 8, 4, '2006-10-16 18:31:43.54542', 81);
478-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (12, 'christian.reis@ubuntulinux.com', 9, 4, '2006-10-16 18:31:43.54577', 91);
479-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (13, 'jeff.waugh@ubuntulinux.com', 6, 4, '2006-10-16 18:31:43.54612', 61);
480-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (14, 'dave.miller@ubuntulinux.com', 3, 4, '2006-10-16 18:31:43.546658', 31);
481-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (15, 'justdave@bugzilla.org', 3, 1, '2006-10-16 18:31:43.547068', 31);
482-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (16, 'test@canonical.com', 12, 4, '2006-10-16 18:31:43.547451', 121);
483-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (17, 'testtest@canonical.com', 12, 1, '2006-10-16 18:31:43.547829', 121);
484-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (18, 'testtesttest@canonical.com', 12, 3, '2006-10-16 18:31:43.54821', 121);
485-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (19, 'testing@canonical.com', 12, 2, '2006-10-16 18:31:43.548591', 121);
486-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (20, 'stuart.bishop@canonical.com', 22, 4, '2006-10-16 18:31:43.548972', 221);
487-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (21, 'david.allouche@canonical.com', 23, 4, '2006-10-16 18:31:43.549353', 231);
488-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (22, 'david@canonical.com', 23, 2, '2006-10-16 18:31:43.549732', 231);
489-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (23, 'daniel.debonzi@canonical.com', 27, 4, '2006-10-16 18:31:43.550113', 271);
490-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (24, 'celso.providelo@canonical.com', 28, 4, '2006-10-16 18:31:43.608939', 281);
491-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (25, 'guilherme.salgado@canonical.com', 29, 4, '2006-10-16 18:31:43.609431', 291);
492-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (26, 'edgar@monteparadiso.hr', 33, 4, '2006-10-16 18:31:43.609819', 331);
493-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (27, 'jvprat@wanadoo.es', 34, 1, '2006-10-16 18:31:43.610202', 341);
494-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (28, 'sigurd-ubuntu@brogar.org', 35, 1, '2006-10-16 18:31:43.6147', 351);
495-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (29, 'skacel@svtech.cz', 36, 1, '2006-10-16 18:31:43.615107', 361);
496-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (30, 'danner@mixmail.com', 37, 1, '2006-10-16 18:31:43.61549', 371);
497-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (31, 'martin.pitt@canonical.com', 38, 1, '2006-10-16 18:31:43.615874', 381);
498-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (32, 'nsv@fr.st', 39, 1, '2006-10-16 18:31:43.616257', 391);
499-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (33, 'callipeo@libero.it', 40, 1, '2006-10-16 18:31:43.616673', 401);
500-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (34, 'jorge.gonzalez.gonzalez@hispalinux.es', 41, 1, '2006-10-16 18:31:43.617057', 411);
501-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (35, 'barbier@linuxfr.org', 42, 1, '2006-10-16 18:31:43.617465', 421);
502-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (36, 'andrelop@debian.org', 43, 1, '2006-10-16 18:31:43.61785', 431);
503-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (37, 'valyag@dat.etsit.upm.es', 44, 1, '2006-10-16 18:31:43.618232', 441);
504-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (38, 'luk.claes@ugent.be', 45, 1, '2006-10-16 18:31:43.618658', 451);
505-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (39, 'kurem@debian.cz', 46, 4, '2006-10-16 18:31:43.619039', 461);
506-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (40, 'morten@wtf.dk', 47, 1, '2006-10-16 18:31:43.619421', 471);
507-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (41, 'mpo@iki.fi', 48, 1, '2006-10-16 18:31:43.619815', 481);
508-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (42, 'kebil@kaunas.init.lt', 49, 1, '2006-10-16 18:31:43.620196', 491);
509-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (43, 'tsukimi@quaqua.net', 50, 4, '2006-10-16 18:31:43.620578', 501);
510-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (44, 'kreutzm@itp.uni-hannover.de', 51, 4, '2006-10-16 18:31:43.620959', 511);
511-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (45, 'support@ubuntu.com', 17, 4, '2006-10-16 18:31:43.621341', NULL);
512-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (46, 'no-priv@canonical.com', 52, 4, '2006-10-16 18:31:43.621725', 521);
513-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (47, 'stuart@stuartbishop.net', 22, 2, '2006-10-16 18:31:43.622107', 221);
514-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (48, 'zen@shangri-la.dropbear.id.au', 22, 3, '2006-10-16 18:31:43.6241', 221);
515-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (49, 'stub@fastmail.fm', 22, 1, '2006-10-16 18:31:43.6245', 221);
516-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (50, 'marilize@hbd.com', 55, 4, '2006-10-16 18:31:43.624885', 551);
517-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (51, 'jordi@ubuntu.com', 56, 4, '2006-10-16 18:31:43.625266', 561);
518-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (52, 'daniel.silverstone@canonical.com', 26, 4, '2006-10-16 18:31:43.625647', 261);
519-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (53, 'bug-importer@launchpad.net', 58, 4, '2006-10-16 18:31:43.62603', 581);
520-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (54, 'rosetta@launchpad.net', 30, 4, '2006-10-16 18:31:43.626521', NULL);
521-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (55, 'salgado@ubuntu.com', 29, 1, '2006-10-16 18:31:43.626932', 291);
522-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (56, 'cprov@ubuntu.com', 28, 2, '2006-10-16 18:31:43.627318', 281);
523-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (57, 'bugwatch@bugs.launchpad.net', 62, 4, '2006-10-16 18:31:43.62774', 621);
524-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (58, 'karl@canonical.com', 63, 4, '2006-10-16 18:31:43.628123', 631);
525-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (59, 'limi@plone.org', 10, 4, '2006-10-16 18:31:43.628504', 101);
526-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (60, 'janitor@launchpad.net', 65, 4, '2006-10-17 23:23:23.232323', 651);
527-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (61, 'matsubara@async.com.br', 66, 1, '2006-12-13 21:19:06.369142', 661);
528-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (62, 'no-team-memberships@test.com', 243602, 4, '2007-02-19 11:17:57.755666', 2436021);
529-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (63, 'one-membership@test.com', 243603, 4, '2007-02-21 10:53:59.700105', 2436031);
530-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (64, 'beta-admin@launchpad.net', 68, 4, '2007-01-31 06:56:25.096519', 681);
531-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (66, 'launchpad@julian-edwards.com', 243606, 1, '2007-08-09 21:25:37.832976', 2436061);
532-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (67, 'doc@lists.ubuntu.com', 243608, 1, '2007-11-12 15:23:19.847132', 2436081);
533-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (68, 'carlos@test.com', 13, 2, '2006-10-16 18:31:43.548591', 131);
534-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (69, 'archive@ubuntu.com', 243609, 4, '2007-12-07 13:43:20.393704', 2436091);
535-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (70, 'member@canonical.com', 243610, 4, '2007-12-14 16:52:15.403833', 2436101);
536-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (71, 'owner@canonical.com', 243611, 4, '2007-12-14 16:52:15.403833', 2436111);
537-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (72, 'jbuhl_nospam@gmx.de', 243614, 1, '2007-12-18 16:31:34.790641', 2436141);
538-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (73, 'sjoerd@spring.luon.net', 243615, 1, '2007-12-18 16:31:34.790641', 2436151);
539-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (74, 'mpitt@debian.org', 243616, 1, '2007-12-18 16:31:34.790641', 2436161);
540-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (75, 'tim@canonical.com', 243617, 4, '2008-03-06 09:55:27.289842', 2436171);
541-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (76, 'commercial-member@canonical.com', 243622, 4, '2008-05-12 17:38:38.798696', 2436221);
542-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (77, 'former-user@canonical.com', 70, 3, '2006-05-12 17:38:38.798696', 701);
543-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (78, 'bac@canonical.com', 243623, 4, '2008-06-27 14:49:11.149508', 2436231);
544-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (79, 'admin@canonical.com', 16, 2, '2008-08-05 12:01:32.086327', 161);
545-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843', 2436241);
546-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407', 2436243);
547-INSERT INTO emailaddress (id, email, person, status, date_created, account) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885', 243637);
548+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (1, 'mark@example.com', 1, 4, '2006-10-16 18:31:43.540582');
549+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (2, 'robertc@robertcollins.net', 2, 4, '2006-10-16 18:31:43.542552');
550+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (3, 'carlos@canonical.com', 13, 4, '2006-10-16 18:31:43.542954');
551+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (4, 'daf@canonical.com', 14, 4, '2006-10-16 18:31:43.543302');
552+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (6, 'foo.bar@canonical.com', 16, 4, '2006-10-16 18:31:43.543649');
553+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (7, 'steve.alexander@ubuntulinux.com', 11, 4, '2006-10-16 18:31:43.543996');
554+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (8, 'colin.watson@ubuntulinux.com', 4, 4, '2006-10-16 18:31:43.544344');
555+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (9, 'scott.james.remnant@ubuntulinux.com', 5, 1, '2006-10-16 18:31:43.544693');
556+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (10, 'andrew.bennetts@ubuntulinux.com', 7, 4, '2006-10-16 18:31:43.54507');
557+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (11, 'james.blackwell@ubuntulinux.com', 8, 4, '2006-10-16 18:31:43.54542');
558+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (12, 'christian.reis@ubuntulinux.com', 9, 4, '2006-10-16 18:31:43.54577');
559+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (13, 'jeff.waugh@ubuntulinux.com', 6, 4, '2006-10-16 18:31:43.54612');
560+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (14, 'dave.miller@ubuntulinux.com', 3, 4, '2006-10-16 18:31:43.546658');
561+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (15, 'justdave@bugzilla.org', 3, 1, '2006-10-16 18:31:43.547068');
562+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (16, 'test@canonical.com', 12, 4, '2006-10-16 18:31:43.547451');
563+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (17, 'testtest@canonical.com', 12, 1, '2006-10-16 18:31:43.547829');
564+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (18, 'testtesttest@canonical.com', 12, 3, '2006-10-16 18:31:43.54821');
565+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (19, 'testing@canonical.com', 12, 2, '2006-10-16 18:31:43.548591');
566+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (20, 'stuart.bishop@canonical.com', 22, 4, '2006-10-16 18:31:43.548972');
567+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (21, 'david.allouche@canonical.com', 23, 4, '2006-10-16 18:31:43.549353');
568+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (22, 'david@canonical.com', 23, 2, '2006-10-16 18:31:43.549732');
569+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (23, 'daniel.debonzi@canonical.com', 27, 4, '2006-10-16 18:31:43.550113');
570+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (24, 'celso.providelo@canonical.com', 28, 4, '2006-10-16 18:31:43.608939');
571+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (25, 'guilherme.salgado@canonical.com', 29, 4, '2006-10-16 18:31:43.609431');
572+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (26, 'edgar@monteparadiso.hr', 33, 4, '2006-10-16 18:31:43.609819');
573+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (27, 'jvprat@wanadoo.es', 34, 1, '2006-10-16 18:31:43.610202');
574+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (28, 'sigurd-ubuntu@brogar.org', 35, 1, '2006-10-16 18:31:43.6147');
575+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (29, 'skacel@svtech.cz', 36, 1, '2006-10-16 18:31:43.615107');
576+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (30, 'danner@mixmail.com', 37, 1, '2006-10-16 18:31:43.61549');
577+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (31, 'martin.pitt@canonical.com', 38, 1, '2006-10-16 18:31:43.615874');
578+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (32, 'nsv@fr.st', 39, 1, '2006-10-16 18:31:43.616257');
579+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (33, 'callipeo@libero.it', 40, 1, '2006-10-16 18:31:43.616673');
580+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (34, 'jorge.gonzalez.gonzalez@hispalinux.es', 41, 1, '2006-10-16 18:31:43.617057');
581+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (35, 'barbier@linuxfr.org', 42, 1, '2006-10-16 18:31:43.617465');
582+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (36, 'andrelop@debian.org', 43, 1, '2006-10-16 18:31:43.61785');
583+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (37, 'valyag@dat.etsit.upm.es', 44, 1, '2006-10-16 18:31:43.618232');
584+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (38, 'luk.claes@ugent.be', 45, 1, '2006-10-16 18:31:43.618658');
585+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (39, 'kurem@debian.cz', 46, 4, '2006-10-16 18:31:43.619039');
586+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (40, 'morten@wtf.dk', 47, 1, '2006-10-16 18:31:43.619421');
587+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (41, 'mpo@iki.fi', 48, 1, '2006-10-16 18:31:43.619815');
588+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (42, 'kebil@kaunas.init.lt', 49, 1, '2006-10-16 18:31:43.620196');
589+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (43, 'tsukimi@quaqua.net', 50, 4, '2006-10-16 18:31:43.620578');
590+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (44, 'kreutzm@itp.uni-hannover.de', 51, 4, '2006-10-16 18:31:43.620959');
591+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (45, 'support@ubuntu.com', 17, 4, '2006-10-16 18:31:43.621341');
592+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (46, 'no-priv@canonical.com', 52, 4, '2006-10-16 18:31:43.621725');
593+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (47, 'stuart@stuartbishop.net', 22, 2, '2006-10-16 18:31:43.622107');
594+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (48, 'zen@shangri-la.dropbear.id.au', 22, 3, '2006-10-16 18:31:43.6241');
595+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (49, 'stub@fastmail.fm', 22, 1, '2006-10-16 18:31:43.6245');
596+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (50, 'marilize@hbd.com', 55, 4, '2006-10-16 18:31:43.624885');
597+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (51, 'jordi@ubuntu.com', 56, 4, '2006-10-16 18:31:43.625266');
598+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (52, 'daniel.silverstone@canonical.com', 26, 4, '2006-10-16 18:31:43.625647');
599+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (53, 'bug-importer@launchpad.net', 58, 4, '2006-10-16 18:31:43.62603');
600+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (54, 'rosetta@launchpad.net', 30, 4, '2006-10-16 18:31:43.626521');
601+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (55, 'salgado@ubuntu.com', 29, 1, '2006-10-16 18:31:43.626932');
602+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (56, 'cprov@ubuntu.com', 28, 2, '2006-10-16 18:31:43.627318');
603+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (57, 'bugwatch@bugs.launchpad.net', 62, 4, '2006-10-16 18:31:43.62774');
604+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (58, 'karl@canonical.com', 63, 4, '2006-10-16 18:31:43.628123');
605+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (59, 'limi@plone.org', 10, 4, '2006-10-16 18:31:43.628504');
606+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (60, 'janitor@launchpad.net', 65, 4, '2006-10-17 23:23:23.232323');
607+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (61, 'matsubara@async.com.br', 66, 1, '2006-12-13 21:19:06.369142');
608+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (62, 'no-team-memberships@test.com', 243602, 4, '2007-02-19 11:17:57.755666');
609+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (63, 'one-membership@test.com', 243603, 4, '2007-02-21 10:53:59.700105');
610+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (64, 'beta-admin@launchpad.net', 68, 4, '2007-01-31 06:56:25.096519');
611+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (66, 'launchpad@julian-edwards.com', 243606, 1, '2007-08-09 21:25:37.832976');
612+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (67, 'doc@lists.ubuntu.com', 243608, 1, '2007-11-12 15:23:19.847132');
613+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (68, 'carlos@test.com', 13, 2, '2006-10-16 18:31:43.548591');
614+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (69, 'archive@ubuntu.com', 243609, 4, '2007-12-07 13:43:20.393704');
615+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (70, 'member@canonical.com', 243610, 4, '2007-12-14 16:52:15.403833');
616+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (71, 'owner@canonical.com', 243611, 4, '2007-12-14 16:52:15.403833');
617+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (72, 'jbuhl_nospam@gmx.de', 243614, 1, '2007-12-18 16:31:34.790641');
618+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (73, 'sjoerd@spring.luon.net', 243615, 1, '2007-12-18 16:31:34.790641');
619+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (74, 'mpitt@debian.org', 243616, 1, '2007-12-18 16:31:34.790641');
620+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (75, 'tim@canonical.com', 243617, 4, '2008-03-06 09:55:27.289842');
621+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (76, 'commercial-member@canonical.com', 243622, 4, '2008-05-12 17:38:38.798696');
622+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (77, 'former-user@canonical.com', 70, 3, '2006-05-12 17:38:38.798696');
623+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (78, 'bac@canonical.com', 243623, 4, '2008-06-27 14:49:11.149508');
624+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (79, 'admin@canonical.com', 16, 2, '2008-08-05 12:01:32.086327');
625+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (80, 'ppa-key-guard@launchpad.net', 243625, 4, '2008-11-04 12:59:26.965843');
626+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (82, 'techboard-owner@example.com', 243631, 4, '2009-08-04 10:50:39.383407');
627+INSERT INTO emailaddress (id, email, person, status, date_created) VALUES (93, 'software-center-agent@example.com', 243651, 4, '2010-07-12 09:48:27.198885');
628
629
630 ALTER TABLE emailaddress ENABLE TRIGGER ALL;
631@@ -10092,26 +10031,26 @@
632
633 ALTER TABLE specification DISABLE TRIGGER ALL;
634
635-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);
636-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);
637-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);
638-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);
639-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);
640-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);
641-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.
642-
643-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);
644-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.
645-
646-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);
647-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.
648-
649-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);
650-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);
651-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.
652-
653-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);
654-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);
655+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);
656+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);
657+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);
658+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);
659+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);
660+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);
661+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.
662+
663+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);
664+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.
665+
666+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);
667+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.
668+
669+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);
670+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);
671+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.
672+
673+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);
674+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);
675
676
677 ALTER TABLE specification ENABLE TRIGGER ALL;
678
679=== modified file 'database/schema/comments.sql'
680--- database/schema/comments.sql 2012-01-17 04:38:41 +0000
681+++ database/schema/comments.sql 2012-01-25 10:05:33 +0000
682@@ -615,7 +615,6 @@
683
684 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.';
685 COMMENT ON INDEX emailaddress__person__key IS 'Ensures that a Person only has one preferred email address';
686-COMMENT ON INDEX emailaddress__account__key IS 'Ensures that an Account only has one preferred email address';
687
688
689 -- FeaturedProject
690@@ -1261,11 +1260,6 @@
691 COMMENT ON COLUMN Account.displayname IS 'Name to display when rendering information about this account.';
692
693
694--- AccountPassword
695-COMMENT ON TABLE AccountPassword IS 'A password used to authenticate an Account.';
696-COMMENT ON COLUMN AccountPassword.password IS 'SSHA digest encrypted password.';
697-
698-
699 -- Person
700 COMMENT ON TABLE Person IS 'A row represents a person if teamowner is NULL, and represents a team if teamowner is set.';
701 COMMENT ON COLUMN Person.account IS 'The Account linked to this Person, if there is one.';
702
703=== added file 'database/schema/patch-2209-01-1.sql'
704--- database/schema/patch-2209-01-1.sql 1970-01-01 00:00:00 +0000
705+++ database/schema/patch-2209-01-1.sql 2012-01-25 10:05:33 +0000
706@@ -0,0 +1,10 @@
707+-- Copyright 2012 Canonical Ltd. This software is licensed under the
708+-- GNU Affero General Public License version 3 (see the file LICENSE).
709+SET client_min_messages=ERROR;
710+
711+ALTER TABLE accountpassword SET SCHEMA todrop;
712+
713+ALTER TABLE emailaddress ALTER COLUMN person SET NOT NULL;
714+ALTER TABLE emailaddress DROP COLUMN account;
715+
716+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 01, 1);
717
718=== modified file 'database/schema/security.cfg'
719--- database/schema/security.cfg 2012-01-18 17:16:39 +0000
720+++ database/schema/security.cfg 2012-01-25 10:05:33 +0000
721@@ -109,7 +109,6 @@
722 public.accesspolicyartifact = SELECT, INSERT, UPDATE, DELETE
723 public.accesspolicygrant = SELECT, INSERT, UPDATE, DELETE
724 public.account = SELECT, INSERT, UPDATE, DELETE
725-public.accountpassword = SELECT, INSERT, UPDATE, DELETE
726 public.announcement = SELECT, INSERT, UPDATE, DELETE
727 public.answercontact = SELECT, INSERT, UPDATE, DELETE
728 public.apportjob = SELECT, INSERT, UPDATE, DELETE
729@@ -549,7 +548,6 @@
730 [checkwatches]
731 groups=script
732 public.account = SELECT, INSERT
733-public.accountpassword = SELECT, INSERT
734 public.answercontact = SELECT
735 public.archive = SELECT
736 public.binarypackagebuild = SELECT
737@@ -619,7 +617,6 @@
738 [branchscanner]
739 groups=write, script
740 public.account = SELECT, INSERT
741-public.accountpassword = SELECT, INSERT
742 public.branch = SELECT, UPDATE
743 public.branchjob = SELECT, INSERT, UPDATE, DELETE
744 public.branchmergeproposal = SELECT, UPDATE
745@@ -811,7 +808,6 @@
746 [gina]
747 groups=write,script
748 public.account = SELECT, INSERT
749-public.accountpassword = SELECT, INSERT
750 public.archive = SELECT, UPDATE
751 public.archivearch = SELECT, UPDATE
752 public.binarypackagepublishinghistory = SELECT, INSERT, UPDATE, DELETE
753@@ -1103,7 +1099,6 @@
754
755 [write]
756 public.account = SELECT, INSERT, UPDATE
757-public.accountpassword = SELECT, INSERT
758 public.archive = SELECT, INSERT, UPDATE
759 public.archivearch = SELECT, INSERT, UPDATE, DELETE
760 public.archivejob = SELECT, INSERT
761@@ -1213,7 +1208,6 @@
762 [answertracker]
763 groups=script
764 public.account = SELECT, INSERT
765-public.accountpassword = SELECT, INSERT
766 public.answercontact = SELECT
767 public.bug = SELECT
768 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
769@@ -1249,7 +1243,6 @@
770
771 [uploading]
772 public.account = SELECT, INSERT
773-public.accountpassword = SELECT, INSERT
774 public.answercontact = SELECT
775 public.archive = SELECT, INSERT, UPDATE
776 public.archivearch = SELECT, INSERT, UPDATE
777@@ -1652,7 +1645,6 @@
778 [processmail]
779 groups=script
780 public.account = SELECT, INSERT
781-public.accountpassword = SELECT, INSERT
782 public.answercontact = SELECT
783 public.archive = SELECT
784 public.archivearch = SELECT
785@@ -1809,7 +1801,6 @@
786 [create-merge-proposals]
787 groups=script
788 public.account = SELECT
789-public.accountpassword = SELECT
790 public.branch = SELECT, INSERT, UPDATE
791 public.branchjob = SELECT, INSERT
792 public.branchmergeproposal = SELECT, INSERT, UPDATE
793@@ -1844,7 +1835,6 @@
794 [merge-proposal-jobs]
795 groups=script
796 public.account = SELECT
797-public.accountpassword = SELECT
798 public.branch = SELECT
799 public.branchjob = SELECT
800 public.branchmergeproposal = SELECT, INSERT, UPDATE
801@@ -1893,7 +1883,6 @@
802 [send-branch-mail]
803 groups=script
804 public.account = SELECT
805-public.accountpassword = SELECT
806 public.branch = SELECT
807 public.branchjob = SELECT
808 public.branchmergeproposal = SELECT, INSERT, UPDATE
809@@ -1935,7 +1924,6 @@
810 [updateremoteproduct]
811 groups=script
812 public.account = SELECT, INSERT, UPDATE
813-public.accountpassword = SELECT, INSERT
814 public.bug = SELECT, INSERT, UPDATE
815 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
816 public.bugjob = SELECT, INSERT
817@@ -2298,6 +2286,5 @@
818 [pgmetrics]
819 type=user
820 groups=read
821-public.accountpassword = SELECT
822 public.oauthnonce = SELECT
823 public.openidconsumernonce = SELECT
824
825=== modified file 'database/schema/security.py'
826--- database/schema/security.py 2011-12-30 06:47:17 +0000
827+++ database/schema/security.py 2012-01-25 10:05:33 +0000
828@@ -29,8 +29,6 @@
829 # tables. This is to stop the ro user being given access to secrurity
830 # sensitive information that interactive sessions don't need.
831 SECURE_TABLES = set((
832- 'public.accountpassword',
833- 'public.accountpassword_id_seq',
834 'public.oauthnonce',
835 'public.oauthnonce_id_seq',
836 'public.openidnonce',

Subscribers

People subscribed via source and target branches

to status/vote changes: