babel-babel_lang-length.sql
No OneTemporary
Actions

Size

593 B

Referenced Files

None

Subscribers

None

babel-babel_lang-length.sql
View Options

	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);