patch-archive-ar_title-varbinary.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-archive-ar_title-varbinary.sql
View Options

	CREATE TABLE archive_tmp (
	ar_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
	ar_namespace INTEGER DEFAULT 0 NOT NULL,
	ar_title BLOB DEFAULT '' NOT NULL, ar_comment_id BIGINT UNSIGNED NOT NULL,
	ar_actor BIGINT UNSIGNED NOT NULL,
	ar_timestamp BLOB NOT NULL, ar_minor_edit SMALLINT DEFAULT 0 NOT NULL,
	ar_rev_id INTEGER UNSIGNED NOT NULL,
	ar_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
	ar_len INTEGER UNSIGNED DEFAULT NULL,
	ar_page_id INTEGER UNSIGNED DEFAULT NULL,
	ar_parent_id INTEGER UNSIGNED DEFAULT NULL,
	ar_sha1 BLOB DEFAULT '' NOT NULL
	);
	INSERT INTO /_/archive_tmp (
	ar_id, ar_namespace, ar_title, ar_comment_id, ar_actor, ar_timestamp, ar_minor_edit, ar_rev_id,
	ar_deleted, ar_len, ar_page_id, ar_parent_id, ar_sha1)
	SELECT ar_id, ar_namespace, ar_title, ar_comment_id, ar_actor, ar_timestamp, ar_minor_edit, ar_rev_id, ar_deleted,
	ar_len, ar_page_id, ar_parent_id, ar_sha1
	FROM /_/archive;
	DROP TABLE /_/archive;
	ALTER TABLE /_/archive_tmp RENAME TO /_/archive;

	CREATE INDEX ar_name_title_timestamp ON /_/archive (
	ar_namespace, ar_title, ar_timestamp
	);

	CREATE INDEX ar_actor_timestamp ON /_/archive (ar_actor, ar_timestamp);

	CREATE UNIQUE INDEX ar_revid_uniq ON /_/archive (ar_rev_id);