Please report any other irregularities here.
As we're cleaning out the database of addons we are going to leave orphaned translations. At the end of it all we should write a script to clean out orphaned translations. This might be tricky but we can check if the translations.id is used in all of our FKs and if not, delete it. This SQL shows all the contraints on translations: SELECT k.table_name, k.constraint_name FROM information_schema.KEY_COLUMN_USAGE k WHERE k.CONSTRAINT_SCHEMA = 'zamboni' AND k.referenced_table_name IS NOT NULL AND k.referenced_table_name = 'translations' ORDER BY k.table_name, k.constraint_name ;
Status: NEW → RESOLVED
Last Resolved: 2 years ago
Resolution: --- → WONTFIX
Whiteboard: [repoman][clean-up] → [repoman][clean-up][marketplace-transition]
You need to log in before you can comment on or make changes to this bug.