-- A technical room can contain a network cross-connect / patch field without
-- becoming a separate location type.
ALTER TABLE locations_locations
    ADD COLUMN IF NOT EXISTS has_cross_field BOOLEAN NOT NULL DEFAULT FALSE;

CREATE INDEX IF NOT EXISTS idx_locations_has_cross_field
    ON locations_locations(has_cross_field)
    WHERE has_cross_field = TRUE AND deleted_at IS NULL;