← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/archive/patch-2208-82-1.sql

  • Committer: Steve Kowalik
  • Date: 2011-08-07 04:05:52 UTC
  • mto: This revision was merged to the branch mainline in revision 13626.
  • Revision ID: stevenk@ubuntu.com-20110807040552-mwnxo0flmhvl35e8
Correct the notification based on review comments, and remove request{,ed}
from the function names, switching to create{,d}.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/archive/patch-2208-82-1.sql
1
 
SET client_min_messages=ERROR;
2
 
 
3
 
ALTER TABLE SourcePackagePublishingHistory
4
 
    ADD COLUMN creator INTEGER
5
 
        CONSTRAINT sourcepackagepublishinghistory__creator__fk
6
 
            REFERENCES Person;
7
 
 
8
 
CREATE INDEX sourcepackagepublishinghistory__creator__idx
9
 
    ON SourcePackagePublishingHistory(creator)
10
 
        WHERE creator is not Null;
11
 
 
12
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 82, 1);