patch-templatelinks-tl_title-varbinary.sql
No OneTemporary
Actions

Size

684 B

Referenced Files

None

Subscribers

None

patch-templatelinks-tl_title-varbinary.sql
View Options

	CREATE TABLE /_/templatelinks_tmp (
	tl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
	tl_namespace INTEGER DEFAULT 0 NOT NULL,
	tl_title BLOB DEFAULT '' NOT NULL,
	tl_from_namespace INTEGER DEFAULT 0 NOT NULL,
	PRIMARY KEY(tl_from, tl_namespace, tl_title)
	);

	INSERT INTO /_/templatelinks_tmp
	SELECT tl_from, tl_namespace, tl_title, tl_from_namespace
	FROM /_/templatelinks;
	DROP TABLE /_/templatelinks;
	ALTER TABLE /_/templatelinks_tmp RENAME TO /_/templatelinks;

	CREATE INDEX tl_namespace ON /_/templatelinks (tl_namespace, tl_title, tl_from);

	CREATE INDEX tl_backlinks_namespace ON /_/templatelinks (
	tl_from_namespace, tl_namespace,
	tl_title, tl_from
	);