The change will not affect existing content types.
EXCEPT acs_message_revision, table_name='CR_REVISIONS' will be changed to NULL
EXCEPT file_storage_objects, table_name='fs_root_folders' will be changed to NULL
and anyplace else that abuses the system to work around the fact that acs_object_types required a type specific table even if the object type did not have any unique attributes.