Page MenuHomeWickedGov Phorge

patch-revision-rev_timestamp-drop-default.sql
No OneTemporary

Size
1 KB
Referenced Files
None
Subscribers
None

patch-revision-rev_timestamp-drop-default.sql

CREATE TABLE /*_*/revision_tmp (
rev_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
rev_page INTEGER UNSIGNED NOT NULL,
rev_comment_id BIGINT UNSIGNED DEFAULT 0 NOT NULL,
rev_actor BIGINT UNSIGNED DEFAULT 0 NOT NULL,
rev_timestamp BLOB NOT NULL,
rev_minor_edit SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
rev_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
rev_len INTEGER UNSIGNED DEFAULT NULL,
rev_parent_id INTEGER UNSIGNED DEFAULT NULL,
rev_sha1 BLOB DEFAULT '' NOT NULL
);
INSERT INTO /*_*/revision_tmp
SELECT rev_id, rev_page, rev_comment_id, rev_actor, rev_timestamp, rev_minor_edit, rev_deleted, rev_len, rev_parent_id, rev_sha1
FROM /*_*/revision;
DROP TABLE /*_*/revision;
ALTER TABLE /*_*/revision_tmp RENAME TO /*_*/revision;
CREATE INDEX rev_page_id ON /*_*/revision (rev_page, rev_id);
CREATE INDEX rev_timestamp ON /*_*/revision (rev_timestamp);
CREATE INDEX rev_page_timestamp ON /*_*/revision (rev_page, rev_timestamp);
CREATE INDEX rev_actor_timestamp ON /*_*/revision (rev_actor, rev_timestamp, rev_id);
CREATE INDEX rev_page_actor_timestamp ON /*_*/revision (
rev_page, rev_actor, rev_timestamp
);

File Metadata

Mime Type
text/plain
Expires
Fri, Jul 3, 21:18 (22 h, 11 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
a1/92/542e3ee56c5333e4ea3ba197d6b8
Default Alt Text
patch-revision-rev_timestamp-drop-default.sql (1 KB)

Event Timeline