1
SET client_min_messages=ERROR;
3
ALTER TABLE ProductReleaseFile
4
ADD COLUMN uploader int4;
6
UPDATE ProductReleaseFile
7
SET uploader=(SELECT owner FROM ProductRelease WHERE ProductRelease.id = ProductReleaseFile.productrelease);
9
ALTER TABLE ProductReleaseFile ALTER COLUMN uploader
12
ALTER TABLE ProductReleaseFile
13
ADD CONSTRAINT productreleasefile__uploader__fk
14
FOREIGN KEY (uploader) REFERENCES person(id);
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);
22
ALTER TABLE ProductReleaseFile ALTER COLUMN dateuploaded
23
SET DEFAULT (CURRENT_TIMESTAMP AT TIME ZONE 'UTC');
24
ALTER TABLE ProductReleaseFile ALTER COLUMN dateuploaded
27
INSERT INTO LaunchpadDatabaseRevision VALUES(79, 99, 1);