~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-79-99-1.sql

  • Committer: Brad Crittenden
  • Date: 2007-05-14 18:38:36 UTC
  • mfrom: (4212.1.1 pending-db-changes)
  • mto: This revision was merged to the branch mainline in revision 4248.
  • Revision ID: bac@canonical.com-20070514183836-x0l2t6lkj5uw177h
Post-review changes

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
SET client_min_messages=ERROR;
2
 
 
3
 
ALTER TABLE ProductReleaseFile
4
 
    ADD COLUMN uploader int4;
5
 
 
6
 
UPDATE ProductReleaseFile
7
 
SET uploader=(SELECT owner FROM ProductRelease WHERE ProductRelease.id = ProductReleaseFile.productrelease);
8
 
 
9
 
ALTER TABLE ProductReleaseFile ALTER COLUMN uploader
10
 
    SET NOT NULL;
11
 
 
12
 
ALTER TABLE ProductReleaseFile
13
 
    ADD CONSTRAINT productreleasefile__uploader__fk
14
 
        FOREIGN KEY (uploader) REFERENCES person(id);
15
 
 
16
 
ALTER TABLE ProductReleaseFile
17
 
    ADD COLUMN dateuploaded timestamp without time zone;
18
 
UPDATE ProductReleaseFile
19
 
SET dateuploaded=(SELECT datecreated FROM ProductRelease
20
 
                         WHERE ProductRelease.id = ProductReleaseFile.productrelease);
21
 
 
22
 
ALTER TABLE ProductReleaseFile ALTER COLUMN dateuploaded
23
 
    SET DEFAULT (CURRENT_TIMESTAMP AT TIME ZONE 'UTC');
24
 
ALTER TABLE ProductReleaseFile ALTER COLUMN dateuploaded
25
 
    SET NOT NULL;
26
 
 
27
 
INSERT INTO LaunchpadDatabaseRevision VALUES(79, 99, 1);