|
7675.766.1
by Abel Deuring
DB schema patch added to set the restricted flag of LFA records beloning to bug attachments of private bugs. |
1 |
-- Copyright 2010 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
||
4 |
-- Update the flag restricted of LibraryFileAlias records which belong
|
|
5 |
-- to bug attachments of private bugs.
|
|
6 |
||
7 |
SET client_min_messages=ERROR; |
|
8 |
||
|
7675.395.116
by Stuart Bishop
Optimize patch-2207-79-0.sql |
9 |
UPDATE LibraryFileAlias SET restricted=TRUE |
10 |
FROM BugAttachment, Bug |
|
11 |
WHERE
|
|
12 |
LibraryFileAlias.id = BugAttachment.libraryfile |
|
13 |
AND Bug.id = BugAttachment.bug |
|
14 |
AND Bug.private IS TRUE |
|
15 |
AND restricted=FALSE; |
|
|
7675.766.1
by Abel Deuring
DB schema patch added to set the restricted flag of LFA records beloning to bug attachments of private bugs. |
16 |
|
|
7675.766.2
by Abel Deuring
renamed DB schema patch file |
17 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 79, 0); |