|
7675.1022.1
by Curtis Hovey
Added an admin column to nameblacklist. |
1 |
-- Copyright 2011 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
SET client_min_messages=ERROR; |
|
4 |
||
|
7675.1022.2
by Curtis Hovey
Added an optional user_id argument to name_blacklist_match and is_blacklisted_name. |
5 |
-- Add a column that identifies the person or team that is exempt from
|
6 |
-- the regexp check.
|
|
|
7675.1022.1
by Curtis Hovey
Added an admin column to nameblacklist. |
7 |
ALTER TABLE NameBlacklist |
8 |
ADD COLUMN admin |
|
9 |
INTEGER, |
|
10 |
ADD CONSTRAINT nameblacklist_admin_fk FOREIGN KEY ("admin") |
|
11 |
REFERENCES person (id) MATCH SIMPLE |
|
12 |
ON UPDATE NO ACTION ON DELETE NO ACTION; |
|
13 |
||
|
7675.1022.2
by Curtis Hovey
Added an optional user_id argument to name_blacklist_match and is_blacklisted_name. |
14 |
|
|
7675.1022.9
by Curtis Hovey
Renamed patch. |
15 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 36, 0); |