~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-121-70-0.sql

  • Committer: Launchpad Patch Queue Manager
  • Date: 2008-06-27 22:24:30 UTC
  • mfrom: (6592.3.2 tm-status-transition)
  • Revision ID: launchpad@pqm.canonical.com-20080627222430-6zks60bxo8jr3vmy
[release-critical=kiko][r=kiko][r=stub][!log] Fix an OOPS by allowing
        TemMemberships to transition from [expired, declined, deactivated,
        invited] to admin and add two new columns to PersonLocation (locked and
        visible).

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
SET client_min_messages=ERROR;
 
2
 
 
3
ALTER TABLE PersonLocation 
 
4
    ADD COLUMN visible boolean DEFAULT TRUE,
 
5
    ADD COLUMN locked boolean DEFAULT FALSE;
 
6
 
 
7
INSERT INTO LaunchpadDatabaseRevision VALUES (121, 70, 0);