Page MenuHomeWickedGov Phorge
Files F4143864

patch-drop-ct_tag.sql
No OneTemporary
Actions

Size
1010 B
Referenced Files
None
Subscribers
None

patch-drop-ct_tag.sql
View Options

CREATE TEMPORARY TABLE /*_*/__temp__change_tag AS SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id FROM /*_*/change_tag;
DROP TABLE /*_*/change_tag;
CREATE TABLE /*_*/change_tag (ct_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, ct_rc_id INTEGER UNSIGNED DEFAULT NULL, ct_log_id INTEGER UNSIGNED DEFAULT NULL, ct_rev_id INTEGER UNSIGNED DEFAULT NULL, ct_params BLOB DEFAULT NULL, ct_tag_id INTEGER UNSIGNED NOT NULL);
INSERT INTO /*_*/change_tag (ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id) SELECT ct_id, ct_rc_id, ct_log_id, ct_rev_id, ct_params, ct_tag_id FROM /*_*/__temp__change_tag;
DROP TABLE /*_*/__temp__change_tag;
CREATE UNIQUE INDEX change_tag_rc_tag_id ON /*_*/change_tag (ct_rc_id, ct_tag_id);
CREATE UNIQUE INDEX change_tag_log_tag_id ON /*_*/change_tag (ct_log_id, ct_tag_id);
CREATE UNIQUE INDEX change_tag_rev_tag_id ON /*_*/change_tag (ct_rev_id, ct_tag_id);
CREATE INDEX change_tag_tag_id_id ON /*_*/change_tag (ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id);

File Metadata

Mime Type
text/plain
Expires
Aug 19 2026, 16:59 (4 w, 4 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
a1/42/55a09621d8cbf941b9a5c298161a
Default Alt Text
patch-drop-ct_tag.sql (1010 B)

Event Timeline