| 1 | -- SPDX-License-Identifier: AGPL-3.0-or-later |
| 2 | -- |
| 3 | -- Enable the citext extension. Used by users.username and user_emails.email |
| 4 | -- so case-insensitive uniqueness is enforced at the type level (no |
| 5 | -- lower(col) functional indexes, no application-side normalization). |
| 6 | |
| 7 | -- +goose Up |
| 8 | CREATE EXTENSION IF NOT EXISTS citext; |
| 9 | |
| 10 | -- +goose Down |
| 11 | -- Intentionally left empty: dropping citext would cascade across columns |
| 12 | -- created in later migrations. If a full down-migration is required, drop |
| 13 | -- the dependent tables first. |
| 14 |