CREATE TABLE /*$wgDBprefix*/langlinks ( -- page_id of the referring page ll_from int(8) unsigned NOT NULL default '0', -- Language code of the target ll_lang varchar(10) binary NOT NULL default '', -- Title of the target, including namespace ll_title varchar(255) binary NOT NULL default '', UNIQUE KEY (ll_from, ll_lang), KEY (ll_lang, ll_title) ) TYPE=InnoDB;