gc: drop jobs tables whose table no longer exists #1644

Summary

A jobs table, ~~<name>, can outlive the auto-populated table it belongs to: #1601 shows it for drop(), and its comments show it for a cascading drop and for a drop through a virtual module. It also happens with tables dropped by an earlier release, by another process, or by hand. A jobs table left behind keeps its records and its primary key, and a table declared later under the same name inherits them (#1601).

Fixing drop() stops new leftovers, but not the ones already in existing schemas. A garbage-collection step would remove those too, whatever path left them, the same way dj.gc already handles orphaned objects in storage.

Proposal

A function in dj.gc, separate from GarbageCollector because jobs tables live in the database and not in a store:

dj.gc.collect_jobs_tables(schema)                 # report only (dry_run=True by default)
dj.gc.collect_jobs_tables(schema, dry_run=False)  # drop the orphans

• For each schema, list the ~~% tables and the Computed and Imported tables. A jobs table is orphaned when no Computed or Imported table has its name, after the tier prefix is stripped (__name or _name for ~~name).
• dry_run=True is a read-only report; dry_run=False drops the orphaned jobs tables, and nothing else.
• Return a report in the style of GarbageCollector.collect(): the number of jobs tables found, the orphaned ones by full name, the number dropped, and errors.

Out of scope

A jobs table whose table exists but whose primary key no longer matches it, after a table is re-declared under the same name. That is the check in AutoPopulate.jobs that #1601 proposes; a GC step cannot tell a stale jobs table from a current one by name alone.

Acceptance

• With dry_run=True nothing changes; the report lists every orphaned jobs table.
• With dry_run=False exactly those are dropped. Jobs tables of existing Computed and Imported tables are kept, along with their records.
• After Stage1.drop() cascades to Stage2 (the reproduction in drop() leaves the jobs table behind, and a table re-declared under the same name inherits it #1601's comments), both ~~stage1 and ~~stage2 are reported and dropped.
• Works on MySQL and on PostgreSQL.