patch-categorylinks-cl_to-varbinary.sql
No OneTemporary
Actions

Size

949 B

Referenced Files

None

Subscribers

None

patch-categorylinks-cl_to-varbinary.sql
View Options

	CREATE TABLE /_/categorylinks_tmp (
	cl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
	cl_to BLOB DEFAULT '' NOT NULL,
	cl_sortkey BLOB DEFAULT '' NOT NULL,
	cl_sortkey_prefix BLOB DEFAULT '' NOT NULL,
	cl_timestamp DATETIME NOT NULL,
	cl_collation BLOB DEFAULT '' NOT NULL,
	cl_type TEXT DEFAULT 'page' NOT NULL,
	PRIMARY KEY(cl_from, cl_to)
	);


	INSERT INTO /_/categorylinks_tmp (cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type)
	SELECT cl_from, cl_to, cl_sortkey, cl_sortkey_prefix, cl_timestamp, cl_collation, cl_type
	FROM /_/categorylinks;
	DROP TABLE /_/categorylinks;
	ALTER TABLE /_/categorylinks_tmp RENAME TO /_/categorylinks;


	CREATE INDEX cl_sortkey ON /_/categorylinks (
	cl_to, cl_type, cl_sortkey, cl_from
	);

	CREATE INDEX cl_timestamp ON /_/categorylinks (cl_to, cl_timestamp);

	CREATE INDEX cl_collation_ext ON /_/categorylinks (
	cl_collation, cl_to, cl_type, cl_from
	);