CREATE TABLE /*_*/babel_tmp ( -- user id babel_user int UNSIGNED NOT NULL, -- language code babel_lang varbinary(35) NOT NULL, -- level (1-5, N) babel_level varbinary(2) NOT NULL, PRIMARY KEY ( babel_user, babel_lang ) ) /*$wgDBTableOptions*/; INSERT INTO /*_*/babel_tmp(babel_user, babel_lang, babel_level) SELECT babel_user, babel_lang, babel_level FROM /*_*/babel; DROP TABLE /*_*/babel; ALTER TABLE /*_*/babel_tmp RENAME TO /*_*/babel; -- Query all users who know a language at a specific level CREATE INDEX /*i*/babel_lang_level ON /*_*/babel (babel_lang, babel_level);