https://bugzilla.wikimedia.org/show_bug.cgi?id=15441
Asher Feldman <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #16 from Asher Feldman <[email protected]> 2012-05-16 18:00:41 UTC --- (In reply to comment #2) The following tables in enwiki don't have a primary or unique key defined: mysql> select table_schema,table_name from information_schema.columns where table_schema='enwiki' group by table_name having sum(if(column_key in ('PRI','UNI'), 1,0)) = 0; +--------------+--------------------------------+ | table_schema | table_name | +--------------+--------------------------------+ | enwiki | archive | | enwiki | archive_old | | enwiki | change_tag | | enwiki | click_tracking | | enwiki | click_tracking_user_properties | | enwiki | edit_page_tracking | | enwiki | exarchive | | enwiki | exlogging | | enwiki | externallinks | | enwiki | hashs | | enwiki | hidden | | enwiki | hitcounter | | enwiki | l10n_cache | | enwiki | logging_old | | enwiki | long_run_profiling | | enwiki | namespaces | | enwiki | oldimage | | enwiki | oldimage_old | | enwiki | old_growth | | enwiki | querycache | | enwiki | querycachetwo | | enwiki | querycache_old | | enwiki | securepoll_lists | | enwiki | user_newtalk | | enwiki | user_properties | | enwiki | validate | +--------------+--------------------------------+ 26 rows in set (0.03 sec) This is especially vexing for the large tables (archive, externallinks) which I'd like to be able to perform online schema migrations against. -- 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
