blob: b10377d6acc27d361621f32debd32f900148dcb9 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
|
CREATE TABLE /*_*/babel (
-- 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);
|