Merge lp:~intellectronica/launchpad/expectations-bug-556499-schema into lp:launchpad/db-devel

[Eleanor Berger]

DB schema patch for adding a bugtarget bug_acknowledgement_message field.

This is a db schema patch for adding a bug filing acknowledgement message to Distribution, DSP, Product and Project. The bug acknowledgement message is a free text field being displayed to users after they've filed a but, to set their expectations regarding the continuation of the bug's lifecycle.

[Björn Tillenius (bjornt)]

Looks good in general. In the comments for DistributionSourcePackage and Project, it makes sense to say whether their messages will override their parent object's message, or be in addition to it. I.e., what will be displayed if both a Product and the Product's Project have messages set?

Stuart needs to approve the patch as well.

review: Approve

[Björn Tillenius (bjornt)]

review: Approve (db)

[Stuart Bishop (stub)]

Fine. patch-2207-55-0.sql

review: Approve (db)

=== modified file 'database/schema/comments.sql'
--- database/schema/comments.sql	2010-04-28 13:58:04 +0000
+++ database/schema/comments.sql	2010-05-19 12:19:30 +0000
@@ -473,6 +473,7 @@
 COMMENT ON TABLE DistributionSourcePackage IS 'Representing a sourcepackage in a distribution across all distribution series.';
 COMMENT ON COLUMN DistributionSourcePackage.bug_reporting_guidelines IS 'Guidelines to the end user for reporting bugs on a particular a source package in a distribution.';
 COMMENT ON COLUMN DistributionSourcePackage.max_bug_heat IS 'The highest heat value across bugs for this source package.';
+COMMENT ON COLUMN DistributionSourcePackage.bug_reported_acknowledgement IS 'A message of acknowledgement to display to a bug reporter after they\'ve reported a new bug.';
 
 -- DistributionSourcePackageCache
 
@@ -624,6 +625,8 @@
 COMMENT ON COLUMN Product.remote_product IS 'The ID of this product on its remote bug tracker.';
 COMMENT ON COLUMN Product.max_bug_heat IS 'The highest heat value across bugs for this product.';
 COMMENT ON COLUMN Product.date_next_suggest_packaging IS 'The date when Launchpad can resume suggesting Ubuntu packages that the project provides.';
+COMMENT ON COLUMN Product.bug_reported_acknowledgement IS 'A message of acknowledgement to display to a bug reporter after they\'ve reported a new bug.';
+
 
 -- ProductLicense
 COMMENT ON TABLE ProductLicense IS 'The licenses that cover the software for a product.';
@@ -716,6 +719,8 @@
 COMMENT ON COLUMN Project.bug_reporting_guidelines IS 'Guidelines to the end user for reporting bugs on products in this project.';
 COMMENT ON COLUMN Project.reviewer_whiteboard IS 'A whiteboard for Launchpad admins, registry experts and the project owners to capture the state of current issues with the project.';
 COMMENT ON COLUMN Project.max_bug_heat IS 'The highest heat value across bugs for products in this project.';
+COMMENT ON COLUMN Project.bug_reported_acknowledgement IS 'A message of acknowledgement to display to a bug reporter after they\'ve reported a new bug.';
+
 
 -- ProjectRelationship
 COMMENT ON TABLE ProjectRelationship IS 'Project Relationships. This table stores information about the way projects are related to one another in the open source world. The actual nature of the relationship is stored in the ''label'' field, and possible values are given by the ProjectRelationship enum in dbschema.py. Examples are AGGREGATES ("the Gnome Project AGGREGATES EOG and Evolution and Gnumeric and AbiWord") and SIMILAR ("the Evolution project is SIMILAR to the Mutt project").';
@@ -980,6 +985,8 @@
 COMMENT ON COLUMN Distribution.bug_reporting_guidelines IS 'Guidelines to the end user for reporting bugs on this distribution.';
 COMMENT ON COLUMN Distribution.reviewer_whiteboard IS 'A whiteboard for Launchpad admins, registry experts and the project owners to capture the state of current issues with the project.';
 COMMENT ON COLUMN Distribution.max_bug_heat IS 'The highest heat value across bugs for this distribution.';
+COMMENT ON COLUMN Distribution.bug_reported_acknowledgement IS 'A message of acknowledgement to display to a bug reporter after they\'ve reported a new bug.';
+
 
 -- DistroSeries
 

=== added file 'database/schema/patch-2207-55-0.sql'
--- database/schema/patch-2207-55-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2207-55-0.sql	2010-05-19 12:19:30 +0000
@@ -0,0 +1,16 @@
+SET client_min_messages=ERROR;
+
+ALTER TABLE Distribution
+ADD COLUMN bug_reported_acknowledgement TEXT;
+
+ALTER TABLE DistributionSourcePackage
+ADD COLUMN bug_reported_acknowledgement TEXT;
+
+ALTER TABLE Product
+ADD COLUMN bug_reported_acknowledgement TEXT;
+
+ALTER TABLE Project
+ADD COLUMN bug_reported_acknowledgement TEXT;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 55, 0);
+