Launchpad itself

Merge lp:~stevenk/launchpad/db-packagediff-requester-nullable into lp:launchpad/db-devel

  1. db-packagediff-requester-nullable
  2. Merge into db-devel
Proposed by Steve Kowalik
Status: Merged
Approved by: William Grant
Approved revision: no longer in the source branch.
Merged at revision: 12471
Proposed branch: lp:~stevenk/launchpad/db-packagediff-requester-nullable
Merge into: lp:launchpad/db-devel
Diff against target: 12 lines (+8/-0)
1 file modified
database/schema/patch-2209-47-1.sql (+8/-0)
To merge this branch: bzr merge lp:~stevenk/launchpad/db-packagediff-requester-nullable
Reviewer Review Type Date Requested Status
William Grant db Approve
Stuart Bishop db Pending
Review via email: mp+176677@code.launchpad.net

Commit message

Drop the NOT NULL constraint on packagediff.requester to make way for setting the requester of the packagediff to the right person from the packageupload, which might be no one.

Description of the change

Drop the NOT NULL constraint on packagediff.requester.

To post a comment you must log in.
Revision history for this message
William Grant (wgrant) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== added file 'database/schema/patch-2209-47-1.sql'
2--- database/schema/patch-2209-47-1.sql 1970-01-01 00:00:00 +0000
3+++ database/schema/patch-2209-47-1.sql 2013-07-24 12:54:29 +0000
4@@ -0,0 +1,8 @@
5+-- Copyright 2013 Canonical Ltd. This software is licensed under the
6+-- GNU Affero General Public License version 3 (see the file LICENSE).
7+
8+SET client_min_messages=ERROR;
9+
10+ALTER TABLE packagediff ALTER COLUMN requester DROP NOT NULL;
11+
12+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 47, 1);

Subscribers

People subscribed via source and target branches

to status/vote changes: