summaryrefslogtreecommitdiff
path: root/maintenance/archives/patch-log_user_text.sql
blob: 9a783d879176bb7871e6039bfba7d6d921b870f5 (plain)
1
2
3
4
5
6
7
8
ALTER TABLE /*$wgDBprefix*/logging 
	ADD log_user_text varchar(255) binary NOT NULL default '',
	ADD log_page int unsigned NULL,
	CHANGE log_type log_type varbinary(32) NOT NULL,
	CHANGE log_action log_action varbinary(32) NOT NULL;

CREATE INDEX /*i*/log_user_type_time ON /*_*/logging (log_user, log_type, log_timestamp);
CREATE INDEX /*i*/log_page_id_time ON /*_*/logging (log_page,log_timestamp);