def METHOD_NAME() -> None:
    """Add optional frozen title."""
    op.rename_table('sponsor_membership', 'project_sponsor_membership')
    for old, new in renamed_constraints:
        op.execute(
            sa.text(
                f'ALTER TABLE project_sponsor_membership RENAME CONSTRAINT'
                f' "{old}" TO "{new}"'
            )
        )
    for old, new in renamed_indexes:
        op.execute(sa.text(f'ALTER INDEX "{old}" RENAME TO "{new}"'))
    op.add_column(
        'proposal_membership', sa.Column('title', sa.Unicode(), nullable=True)
    )
    op.create_check_constraint(
        'proposal_membership_title_check',
        'proposal_membership',
        "title <> ''",
    )
    op.add_column(
        'proposal_sponsor_membership', sa.Column('title', sa.Unicode(), nullable=True)
    )
    op.create_check_constraint(
        'proposal_sponsor_membership_title_check',
        'proposal_sponsor_membership',
        "title <> ''",
    )
    op.add_column(
        'project_sponsor_membership', sa.Column('title', sa.Unicode(), nullable=True)
    )
    op.create_check_constraint(
        'project_sponsor_membership_title_check',
        'project_sponsor_membership',
        "title <> ''",
    )