← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-69-0.sql

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-05-23 18:43:31 UTC
  • mfrom: (13084.2.6 page-match-rewrite-url)
  • Revision ID: launchpad@pqm.canonical.com-20110523184331-dhd2c7cgfuu49epw
[r=sinzui][bug=784273] Adds facility to the PageMatch to handle bad
        URIs

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-69-0.sql
1
 
 
2
 
SET client_min_messages=ERROR;
3
 
 
4
 
ALTER TABLE QuestionMessage ADD COLUMN owner int;
5
 
CREATE INDEX questionmessage__owner__idx ON QuestionMessage(owner);
6
 
 
7
 
UPDATE QuestionMessage SET owner = (
8
 
    SELECT owner FROM Message WHERE Message.id=QuestionMessage.message);
9
 
 
10
 
ALTER TABLE QuestionMessage ALTER COLUMN owner SET NOT NULL;
11
 
 
12
 
CREATE TRIGGER questionmessage__owner__mirror
13
 
    AFTER UPDATE OR INSERT ON questionmessage
14
 
    FOR EACH ROW EXECUTE PROCEDURE questionmessage_copy_owner_from_message();
15
 
CREATE TRIGGER message__owner__mirror__questionmessage AFTER UPDATE ON message
16
 
    FOR EACH ROW EXECUTE PROCEDURE message_copy_owner_to_questionmessage();
17
 
 
18
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 69, 0);