https://bugzilla.wikimedia.org/show_bug.cgi?id=33228
--- Comment #12 from Reedy <[email protected]> 2012-01-10 15:12:32 UTC --- (In reply to comment #10) > Created attachment 9824 [details] > Output of mysqldump --no-data > > Attached is the DB structure, which I got with > mysqldump --nodata > > Only 19 tables do have a primary key. And I don't know, if these are how they > should be). FYI (In reply to comment #2) > No PK (but has unique index): > categorylinks > change_tag > imagelinks > interwiki > iwlinks > langlinks > log_search > module_deps > msg_resource > msg_resource_links > page_props > oagelinks > protected_titles > querycache_info > searchindex > site_stats > tag_summary > templatelinks > transcache > user_former_groups > user_groups > > No PK or unique index: > archive > externallinks > hitcounter > l10n_cache > oldimage > querycache > querycachetwo > user_newtalk In your DB install, all these tables aren't needed (trackback is newly gone). Cleaned up in r108502 'blobs', // 1.4 'brokenlinks', // 1.4 'cur', // 1.4 'ip_blocks_old', // Temporary in 1.6 'links', // 1.4 'linkscc', // 1.4 'old', // 1.4 'trackback', // 1.19 'user_rights', // 1.5 'validate', // 1.6 Your text table is very out of date (numerous extra fields and indexes). I've added code in r108504 to tidy this up -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
