diff options
| author | jenkins-bot <jenkins-bot@gerrit.wikimedia.org> | 2020-06-06 21:24:21 +0000 |
|---|---|---|
| committer | Gerrit Code Review <gerrit@wikimedia.org> | 2020-06-06 21:24:21 +0000 |
| commit | 74778ccd17eb37b4f5dd615076c991c331936f5c (patch) | |
| tree | 632ddd9826899e5faa52558c0fa4afe3b344799a /maintenance/postgres | |
| parent | fef790d5bbba8e313961e89e9c5cc5d0b0b163d4 (diff) | |
| parent | 39448a9cf6542883a89820c7fd0481c1c79d281e (diff) | |
| download | mediawikicore-74778ccd17eb37b4f5dd615076c991c331936f5c.tar.gz mediawikicore-74778ccd17eb37b4f5dd615076c991c331936f5c.zip | |
Merge "Remove ipb_anon_only from ipb_address_unique UNIQUE INDEX"
Diffstat (limited to 'maintenance/postgres')
| -rw-r--r-- | maintenance/postgres/tables.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/maintenance/postgres/tables.sql b/maintenance/postgres/tables.sql index d3d657be8b8f..a3dacd9b5478 100644 --- a/maintenance/postgres/tables.sql +++ b/maintenance/postgres/tables.sql @@ -411,7 +411,7 @@ CREATE TABLE ipblocks ( ipb_sitewide SMALLINT NOT NULL DEFAULT 1 ); ALTER SEQUENCE ipblocks_ipb_id_seq OWNED BY ipblocks.ipb_id; -CREATE UNIQUE INDEX ipb_address_unique ON ipblocks (ipb_address,ipb_user,ipb_auto,ipb_anon_only); +CREATE UNIQUE INDEX ipb_address_unique ON ipblocks (ipb_address,ipb_user,ipb_auto); CREATE INDEX ipb_user ON ipblocks (ipb_user); CREATE INDEX ipb_range ON ipblocks (ipb_range_start,ipb_range_end); CREATE INDEX ipb_parent_block_id ON ipblocks (ipb_parent_block_id); |