Launchpad itself

Merge lp:~abentley/launchpad/blueprint-info-type-db into lp:launchpad/db-devel

  1. blueprint-info-type-db
  2. Merge into db-devel
Proposed by Aaron Bentley
Status: Merged
Approved by: Stuart Bishop
Approved revision: no longer in the source branch.
Merged at revision: 11809
Proposed branch: lp:~abentley/launchpad/blueprint-info-type-db
Merge into: lp:launchpad/db-devel
Diff against target: 224 lines (+85/-76)
4 files modified
database/sampledata/current-dev.sql (+38/-38)
database/sampledata/current.sql (+38/-38)
database/schema/comments.sql (+1/-0)
database/schema/patch-2209-28-1.sql (+8/-0)
To merge this branch: bzr merge lp:~abentley/launchpad/blueprint-info-type-db
Reviewer Review Type Date Requested Status
Stuart Bishop (community) db Approve
Robert Collins db Pending
Review via email: mp+117979@code.launchpad.net

Commit message

Add information_type column to Specification.

Description of the change

= Summary =
Add information_type column to Specification
(next: https://code.launchpad.net/~abentley/launchpad/blueprint-info-type-idx/+merge/117980)

== Pre-implementation notes ==
Advised by lifeless & wgrant

== LOC Rationale ==
Part of Private Projects

== Implementation details ==
Column is created nullable, and then a default is assigned, so future rows will use the default.

== Tests ==
None

== Demo and Q/A ==
None

= Launchpad lint =

Checking for conflicts and issues in changed files.

Linting changed files:
  database/schema/patch-2209-28-1.sql
  database/schema/comments.sql

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

This is fine.

Timing on staging for 'alter table specification add column information integer not null default 1' is 10 seconds, so 20 seconds to do this all in one patch on production (or hopefully 10 seconds come Monday). This might be preferable to two shorter outages (this patch, and adding the NOT NULL) and the NDT updates.

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-07-24 08:47:26 +0000
3+++ database/sampledata/current-dev.sql 2012-08-03 19:25:25 +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) 9.1.3
8+-- Created using pg_dump (PostgreSQL) 9.1.4
9
10 SET check_function_bodies = false;
11 SET client_encoding = 'UTF8';
12@@ -2272,23 +2272,23 @@
13
14 ALTER TABLE archivepermission DISABLE TRIGGER ALL;
15
16-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (1, '2006-10-16 18:31:43.464753', 17, 1, 1, 3, NULL, NULL, false, NULL);
17-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (2, '2006-10-16 18:31:43.46438', 17, 1, 1, 2, NULL, NULL, false, NULL);
18-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (3, '2006-10-16 18:31:43.463125', 17, 1, 1, 1, NULL, NULL, false, NULL);
19-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (4, '2006-10-16 18:31:43.464753', 17, 1, 8, 3, NULL, NULL, false, NULL);
20-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (5, '2006-10-16 18:31:43.465111', 17, 1, 8, 1, NULL, NULL, false, NULL);
21-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (6, '2006-10-16 18:31:43.465111', 17, 2, 1, 1, NULL, NULL, false, NULL);
22-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (7, '2006-10-16 18:31:43.465111', 17, 2, 1, 2, NULL, NULL, false, NULL);
23-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (8, '2006-10-16 18:31:43.465111', 17, 2, 1, 3, NULL, NULL, false, NULL);
24-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (9, '2006-10-16 18:31:43.465111', 17, 2, 1, 5, NULL, NULL, false, NULL);
25-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (11, '2006-10-16 18:31:43.465111', 13, 1, 1, NULL, 1, NULL, false, NULL);
26-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (12, '2006-10-16 18:31:43.465111', 243620, 1, 12, 5, NULL, NULL, false, NULL);
27-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (13, '2006-10-16 18:31:43.465111', 12, 2, 1, 1, NULL, NULL, false, NULL);
28-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (14, '2006-10-16 18:31:43.465111', 12, 2, 1, 2, NULL, NULL, false, NULL);
29-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (15, '2006-10-16 18:31:43.465111', 12, 2, 1, 3, NULL, NULL, false, NULL);
30-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (16, '2006-10-16 18:31:43.465111', 12, 2, 1, 4, NULL, NULL, false, NULL);
31-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (17, '2006-10-16 18:31:43.465111', 243602, 2, 1, 3, NULL, NULL, false, NULL);
32-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (18, '2006-10-16 18:31:43.465111', 243602, 2, 1, 4, NULL, NULL, false, NULL);
33+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (1, '2006-10-16 18:31:43.464753', 17, 1, 1, 3, NULL, NULL, false, NULL, NULL);
34+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (2, '2006-10-16 18:31:43.46438', 17, 1, 1, 2, NULL, NULL, false, NULL, NULL);
35+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (3, '2006-10-16 18:31:43.463125', 17, 1, 1, 1, NULL, NULL, false, NULL, NULL);
36+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (4, '2006-10-16 18:31:43.464753', 17, 1, 8, 3, NULL, NULL, false, NULL, NULL);
37+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (5, '2006-10-16 18:31:43.465111', 17, 1, 8, 1, NULL, NULL, false, NULL, NULL);
38+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (6, '2006-10-16 18:31:43.465111', 17, 2, 1, 1, NULL, NULL, false, NULL, NULL);
39+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (7, '2006-10-16 18:31:43.465111', 17, 2, 1, 2, NULL, NULL, false, NULL, NULL);
40+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (8, '2006-10-16 18:31:43.465111', 17, 2, 1, 3, NULL, NULL, false, NULL, NULL);
41+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (9, '2006-10-16 18:31:43.465111', 17, 2, 1, 5, NULL, NULL, false, NULL, NULL);
42+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (11, '2006-10-16 18:31:43.465111', 13, 1, 1, NULL, 1, NULL, false, NULL, NULL);
43+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (12, '2006-10-16 18:31:43.465111', 243620, 1, 12, 5, NULL, NULL, false, NULL, NULL);
44+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (13, '2006-10-16 18:31:43.465111', 12, 2, 1, 1, NULL, NULL, false, NULL, NULL);
45+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (14, '2006-10-16 18:31:43.465111', 12, 2, 1, 2, NULL, NULL, false, NULL, NULL);
46+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (15, '2006-10-16 18:31:43.465111', 12, 2, 1, 3, NULL, NULL, false, NULL, NULL);
47+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (16, '2006-10-16 18:31:43.465111', 12, 2, 1, 4, NULL, NULL, false, NULL, NULL);
48+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (17, '2006-10-16 18:31:43.465111', 243602, 2, 1, 3, NULL, NULL, false, NULL, NULL);
49+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (18, '2006-10-16 18:31:43.465111', 243602, 2, 1, 4, NULL, NULL, false, NULL, NULL);
50
51
52 ALTER TABLE archivepermission ENABLE TRIGGER ALL;
53@@ -9609,26 +9609,26 @@
54
55 ALTER TABLE specification DISABLE TRIGGER ALL;
56
57-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);
58-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);
59-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);
60-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);
61-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);
62-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);
63-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.
64-
65-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);
66-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.
67-
68-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);
69-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.
70-
71-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);
72-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);
73-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.
74-
75-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);
76-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);
77+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, information_type) 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, 1);
78+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, information_type) 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, 1);
79+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, information_type) 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, 1);
80+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, information_type) 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, 1);
81+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, information_type) 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, 1);
82+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, information_type) 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, 1);
83+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, information_type) 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.
84+
85+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, 1);
86+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, information_type) 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.
87+
88+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, 1);
89+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, information_type) 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.
90+
91+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, 1);
92+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, information_type) 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, 1);
93+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, information_type) 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.
94+
95+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, 1);
96+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, information_type) 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, 1);
97
98
99 ALTER TABLE specification ENABLE TRIGGER ALL;
100
101=== modified file 'database/sampledata/current.sql'
102--- database/sampledata/current.sql 2012-07-24 08:47:26 +0000
103+++ database/sampledata/current.sql 2012-08-03 19:25:25 +0000
104@@ -1,6 +1,6 @@
105 -- Copyright 2010-2011 Canonical Ltd. This software is licensed under the
106 -- GNU Affero General Public License version 3 (see the file LICENSE).
107--- Created using pg_dump (PostgreSQL) 9.1.3
108+-- Created using pg_dump (PostgreSQL) 9.1.4
109
110 SET check_function_bodies = false;
111 SET client_encoding = 'UTF8';
112@@ -2267,23 +2267,23 @@
113
114 ALTER TABLE archivepermission DISABLE TRIGGER ALL;
115
116-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (1, '2006-10-16 18:31:43.464753', 17, 1, 1, 3, NULL, NULL, false, NULL);
117-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (2, '2006-10-16 18:31:43.46438', 17, 1, 1, 2, NULL, NULL, false, NULL);
118-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (3, '2006-10-16 18:31:43.463125', 17, 1, 1, 1, NULL, NULL, false, NULL);
119-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (4, '2006-10-16 18:31:43.464753', 17, 1, 8, 3, NULL, NULL, false, NULL);
120-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (5, '2006-10-16 18:31:43.465111', 17, 1, 8, 1, NULL, NULL, false, NULL);
121-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (6, '2006-10-16 18:31:43.465111', 17, 2, 1, 1, NULL, NULL, false, NULL);
122-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (7, '2006-10-16 18:31:43.465111', 17, 2, 1, 2, NULL, NULL, false, NULL);
123-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (8, '2006-10-16 18:31:43.465111', 17, 2, 1, 3, NULL, NULL, false, NULL);
124-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (10, '2006-10-16 18:31:43.465111', 17, 2, 1, 5, NULL, NULL, false, NULL);
125-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (11, '2006-10-16 18:31:43.465111', 13, 1, 1, NULL, 1, NULL, false, NULL);
126-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (12, '2006-10-16 18:31:43.465111', 243620, 1, 12, 5, NULL, NULL, false, NULL);
127-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (13, '2006-10-16 18:31:43.465111', 12, 2, 1, 1, NULL, NULL, false, NULL);
128-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (14, '2006-10-16 18:31:43.465111', 12, 2, 1, 2, NULL, NULL, false, NULL);
129-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (15, '2006-10-16 18:31:43.465111', 12, 2, 1, 3, NULL, NULL, false, NULL);
130-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (16, '2006-10-16 18:31:43.465111', 12, 2, 1, 4, NULL, NULL, false, NULL);
131-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (17, '2006-10-16 18:31:43.465111', 243602, 2, 1, 3, NULL, NULL, false, NULL);
132-INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket) VALUES (18, '2006-10-16 18:31:43.465111', 243602, 2, 1, 4, NULL, NULL, false, NULL);
133+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (1, '2006-10-16 18:31:43.464753', 17, 1, 1, 3, NULL, NULL, false, NULL, NULL);
134+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (2, '2006-10-16 18:31:43.46438', 17, 1, 1, 2, NULL, NULL, false, NULL, NULL);
135+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (3, '2006-10-16 18:31:43.463125', 17, 1, 1, 1, NULL, NULL, false, NULL, NULL);
136+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (4, '2006-10-16 18:31:43.464753', 17, 1, 8, 3, NULL, NULL, false, NULL, NULL);
137+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (5, '2006-10-16 18:31:43.465111', 17, 1, 8, 1, NULL, NULL, false, NULL, NULL);
138+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (6, '2006-10-16 18:31:43.465111', 17, 2, 1, 1, NULL, NULL, false, NULL, NULL);
139+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (7, '2006-10-16 18:31:43.465111', 17, 2, 1, 2, NULL, NULL, false, NULL, NULL);
140+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (8, '2006-10-16 18:31:43.465111', 17, 2, 1, 3, NULL, NULL, false, NULL, NULL);
141+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (10, '2006-10-16 18:31:43.465111', 17, 2, 1, 5, NULL, NULL, false, NULL, NULL);
142+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (11, '2006-10-16 18:31:43.465111', 13, 1, 1, NULL, 1, NULL, false, NULL, NULL);
143+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (12, '2006-10-16 18:31:43.465111', 243620, 1, 12, 5, NULL, NULL, false, NULL, NULL);
144+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (13, '2006-10-16 18:31:43.465111', 12, 2, 1, 1, NULL, NULL, false, NULL, NULL);
145+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (14, '2006-10-16 18:31:43.465111', 12, 2, 1, 2, NULL, NULL, false, NULL, NULL);
146+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (15, '2006-10-16 18:31:43.465111', 12, 2, 1, 3, NULL, NULL, false, NULL, NULL);
147+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (16, '2006-10-16 18:31:43.465111', 12, 2, 1, 4, NULL, NULL, false, NULL, NULL);
148+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (17, '2006-10-16 18:31:43.465111', 243602, 2, 1, 3, NULL, NULL, false, NULL, NULL);
149+INSERT INTO archivepermission (id, date_created, person, permission, archive, component, sourcepackagename, packageset, explicit, pocket, distroseries) VALUES (18, '2006-10-16 18:31:43.465111', 243602, 2, 1, 4, NULL, NULL, false, NULL, NULL);
150
151
152 ALTER TABLE archivepermission ENABLE TRIGGER ALL;
153@@ -9526,26 +9526,26 @@
154
155 ALTER TABLE specification DISABLE TRIGGER ALL;
156
157-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);
158-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);
159-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);
160-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);
161-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);
162-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);
163-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.
164-
165-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);
166-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.
167-
168-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);
169-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.
170-
171-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);
172-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);
173-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.
174-
175-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);
176-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);
177+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, information_type) 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, 1);
178+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, information_type) 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, 1);
179+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, information_type) 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, 1);
180+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, information_type) 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, 1);
181+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, information_type) 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, 1);
182+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, information_type) 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, 1);
183+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, information_type) 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.
184+
185+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, 1);
186+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, information_type) 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.
187+
188+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, 1);
189+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, information_type) 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.
190+
191+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, 1);
192+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, information_type) 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, 1);
193+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, information_type) 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.
194+
195+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, 1);
196+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, information_type) 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, 1);
197
198
199 ALTER TABLE specification ENABLE TRIGGER ALL;
200
201=== modified file 'database/schema/comments.sql'
202--- database/schema/comments.sql 2012-07-19 13:04:48 +0000
203+++ database/schema/comments.sql 2012-08-03 19:25:25 +0000
204@@ -1531,6 +1531,7 @@
205 -- Specification
206
207 COMMENT ON TABLE Specification IS 'A feature specification. At the moment we do not store the actual specification, we store a URL for the spec, which is managed in a wiki somewhere else. We store the overall state of the spec, as well as queueing information about who needs to review the spec, and why.';
208+COMMENT ON COLUMN Specification.information_type IS 'Enum describing what type of information is stored, such as type of private or security related data, and used to determine how to apply an access policy.';
209 COMMENT ON COLUMN Specification.assignee IS 'The person who has been assigned to implement this specification.';
210 COMMENT ON COLUMN Specification.drafter IS 'The person who has been asked to draft this specification. They are responsible for getting the spec to "approved" state.';
211 COMMENT ON COLUMN Specification.approver IS 'The person who is responsible for approving the specification in due course, and who will probably be required to review the code itself when it is being implemented.';
212
213=== added file 'database/schema/patch-2209-28-1.sql'
214--- database/schema/patch-2209-28-1.sql 1970-01-01 00:00:00 +0000
215+++ database/schema/patch-2209-28-1.sql 2012-08-03 19:25:25 +0000
216@@ -0,0 +1,8 @@
217+-- Copyright 2012 Canonical Ltd. This software is licensed under the
218+-- GNU Affero General Public License version 3 (see the file LICENSE).
219+
220+SET client_min_messages=ERROR;
221+
222+alter table specification add column information_type integer not null default 1;
223+
224+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 28, 1);

Subscribers

People subscribed via source and target branches

to status/vote changes: