← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2209-00-1.sql

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-12-14 21:42:34 UTC
  • mfrom: (7675.1253.5 db-849683-notnull)
  • mto: This revision was merged to the branch mainline in revision 14593.
  • Revision ID: launchpad@pqm.canonical.com-20111214214234-8ot8i3m19ozwx5es
[r=lifeless, stub][bug=849683] NOT NULL constraints on {Binary,
 Source}PackagePublishingHistory.{binary, source}packagename.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2209-00-1.sql
 
1
-- Copyright 2011 Canonical Ltd.  This software is licensed under the
 
2
-- GNU Affero General Public License version 3 (see the file LICENSE).
 
3
SET client_min_messages=ERROR;
 
4
 
 
5
ALTER TABLE SourcePackagePublishingHistory
 
6
ALTER COLUMN sourcepackagename SET NOT NULL;
 
7
ALTER TABLE BinaryPackagePublishingHistory
 
8
ALTER COLUMN binarypackagename SET NOT NULL;
 
9
 
 
10
INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 00, 1);