Database Cleanup


How do I cleanup extra columns in tables that are no longer in use?

"Inconsistent database table and entity definitions: column 'OSUSR_ko1_UserSubmission.ISDUPES' exists in database, but there is no corresponding attribute in entity 'UserSubmission'."

The "DBCleaner" (package) does not list these attributes and the DBCleaner API "Attribute_DropColumn(Integer)" in the refers to an integer but I have no idea what integer to use.



If you run DBCleaner as an application in your (cloud) environment, these extra columns should appear automatically:

And that's my point, they don't show up there at all.