ALTER TABLE en_category MODIFY cat_hidden tinyint(3) unsigned NOT NULL DEFAULT '0';

ALTER TABLE en_interwiki ADD iw_wikiid varchar(64) NOT NULL;

ALTER TABLE en_ipblocks MODIFY ipb_allow_usertalk tinyint(1) NOT NULL DEFAULT '0';

ALTER TABLE en_iwlinks ADD CONSTRAINT iwl_from UNIQUE (iwl_from,iwl_prefix,iwl_title);

ALTER TABLE en_job DROP INDEX job_cmd;
ALTER TABLE en_job ADD KEY job_cmd (job_cmd, job_namespace, job_title, job_params(128));

ALTER TABLE en_logging MODIFY log_type varbinary(32) NOT NULL DEFAULT '';
ALTER TABLE en_logging MODIFY log_action varbinary(32) NOT NULL DEFAULT '';

ALTER TABLE en_objectcache DROP INDEX keyname;
ALTER TABLE en_objectcache ADD PRIMARY KEY (keyname);

ALTER TABLE en_page_props DROP PRIMARY KEY;
ALTER TABLE en_page_props ADD CONSTRAINT pp_page_propname UNIQUE (pp_page, pp_propname);

ALTER TABLE en_page_restrictions DROP PRIMARY KEY;
ALTER TABLE en_page_restrictions ADD PRIMARY KEY (pr_id);
ALTER TABLE en_page_restrictions DROP INDEX pr_id;
ALTER TABLE en_page_restrictions ADD CONSTRAINT pr_pagetype UNIQUE (pr_page, pr_type);

ALTER TABLE en_protected_titles DROP PRIMARY KEY;
ALTER TABLE en_protected_titles ADD CONSTRAINT pt_namespace_title UNIQUE (pt_namespace, pt_title);

ALTER TABLE en_revision DROP PRIMARY KEY;
ALTER TABLE en_revision ADD PRIMARY KEY (rev_id);
ALTER TABLE en_revision DROP INDEX rev_id;
ALTER TABLE en_revision ADD CONSTRAINT rev_page_id UNIQUE (rev_page, rev_id);

ALTER TABLE en_transcache MODIFY tc_time binary(14) NOT NULL;

ALTER TABLE en_user_groups DROP PRIMARY KEY;
ALTER TABLE en_user_groups ADD CONSTRAINT ug_user_group UNIQUE (ug_user, ug_group);

ALTER TABLE en_user_properties MODIFY up_property varbinary(255) NOT NULL;

ALTER TABLE en_msg_resource_links ADD CONSTRAINT mrl_message_resource UNIQUE (mrl_message, mrl_resource);
ALTER TABLE en_msg_resource_links DROP INDEX en_mrl_message_resource;

ALTER TABLE en_archive ADD KEY ar_usertext_timestamp (ar_user_text, ar_timestamp);
ALTER TABLE en_archive DROP INDEX usertext_timestamp;

ALTER TABLE en_user_newtalk ADD KEY un_user_id (user_id);
ALTER TABLE en_user_newtalk ADD KEY un_user_ip (user_ip);
ALTER TABLE en_user_newtalk DROP INDEX user_id;
ALTER TABLE en_user_newtalk DROP INDEX user_ip;
