def METHOD_NAME():
    op.create_table(
        "systemmanager",
        sa.Column("id", sa.String(length=255), nullable=False),
        sa.Column(
            "created_at",
            sa.DateTime(timezone=True),
            server_default=sa.text("now()"),
            nullable=True,
        ),
        sa.Column(
            "updated_at",
            sa.DateTime(timezone=True),
            server_default=sa.text("now()"),
            nullable=True,
        ),
        sa.Column("user_id", sa.String(), nullable=False),
        sa.Column("system_id", sa.String(), nullable=False),
        sa.ForeignKeyConstraint(["system_id"], ["ctl_systems.id"], ondelete="CASCADE"),
        sa.ForeignKeyConstraint(["user_id"], ["fidesuser.id"], ondelete="CASCADE"),
        sa.PrimaryKeyConstraint("id", "user_id", "system_id"),
    )
    op.create_index(op.f("ix_systemmanager_id"), "systemmanager", ["id"], unique=False)
    op.add_column(
        "client",
        sa.Column(
            "systems", sa.ARRAY(sa.String()), server_default="{}", nullable=False
        ),
    )
    bind = op.get_bind()
    def add_new_scopes_to_fides_user_permissions(
        matched_rows: ResultProxy, new_scopes: List[str]
    ):
        """Helper method to tack on new scopes to the fidesuserpermissions.scopes if user has existing scope."""
        for row in matched_rows:
            scopes: List[str] = row["scopes"] or []
            scopes.extend(new_scopes)
            add_new_scopes_query: TextClause = text(
                "UPDATE fidesuserpermissions SET scopes= :scopes WHERE id= :id"
            )
            bind.execute(
                add_new_scopes_query,
                {"scopes": sorted(list(set(scopes))), "id": row["id"]},
            )
    def add_new_scopes_to_client(matched_rows: ResultProxy, new_scopes: List[str]):
        """Helper method to tack on new scopes to the client.scopes if user has existing scope."""
        for row in matched_rows:
            scopes: List[str] = row["scopes"] or []
            scopes.extend(new_scopes)
            add_new_scopes_query: TextClause = text(
                "UPDATE client SET scopes= :scopes WHERE id= :id"
            )
            bind.execute(
                add_new_scopes_query,
                {"scopes": sorted(list(set(scopes))), "id": row["id"]},
            )
    add_new_scopes_to_fides_user_permissions(
        matched_rows=bind.execute(
            text(
                "SELECT * FROM fidesuserpermissions WHERE 'cli-objects:create' = ANY(scopes);"
            )
        ),
        new_scopes=new_create_scopes,
    )
    add_new_scopes_to_client(
        matched_rows=bind.execute(
            text("SELECT * FROM client WHERE 'cli-objects:create' = ANY(scopes);")
        ),
        new_scopes=new_create_scopes,
    )
    add_new_scopes_to_fides_user_permissions(
        matched_rows=bind.execute(
            text(
                "SELECT * FROM fidesuserpermissions WHERE 'cli-objects:read' = ANY(scopes);"
            )
        ),
        new_scopes=new_read_scopes,
    )
    add_new_scopes_to_client(
        matched_rows=bind.execute(
            text("SELECT * FROM client WHERE 'cli-objects:read' = ANY(scopes);")
        ),
        new_scopes=new_read_scopes,
    )
    add_new_scopes_to_fides_user_permissions(
        matched_rows=bind.execute(
            text(
                "SELECT * FROM fidesuserpermissions WHERE 'cli-objects:update' = ANY(scopes);"
            )
        ),
        new_scopes=new_update_scopes,
    )
    add_new_scopes_to_client(
        matched_rows=bind.execute(
            text("SELECT * FROM client WHERE 'cli-objects:update' = ANY(scopes);")
        ),
        new_scopes=new_update_scopes,
    )
    add_new_scopes_to_fides_user_permissions(
        matched_rows=bind.execute(
            text(
                "SELECT * FROM fidesuserpermissions WHERE 'cli-objects:delete' = ANY(scopes);"
            )
        ),
        new_scopes=new_delete_scopes,
    )
    add_new_scopes_to_client(
        matched_rows=bind.execute(
            text("SELECT * FROM client WHERE 'cli-objects:delete' = ANY(scopes);")
        ),
        new_scopes=new_delete_scopes,
    )