1 ALTER TABLE /*_*/recentchanges
2 ALTER COLUMN rc_user_text
SET DEFAULT '',
3 ADD COLUMN rc_actor
bigint unsigned
NOT NULL DEFAULT 0 AFTER rc_user_text
;
4 CREATE INDEX /*i*/rc_ns_actor
ON /*_*/recentchanges (rc_namespace
, rc_actor
);
5 CREATE INDEX /*i*/rc_actor
ON /*_*/recentchanges (rc_actor
, rc_timestamp
);