Page MenuHomeWickedGov Phorge
Files F4114741

patch-ip_changes-pc_rev_timestamp-drop-default.sql
No OneTemporary
Actions

Size
526 B
Referenced Files
None
Subscribers
None

patch-ip_changes-pc_rev_timestamp-drop-default.sql
View Options

CREATE TABLE /*_*/ip_changes_tmp (
ipc_rev_id INTEGER UNSIGNED DEFAULT 0 NOT NULL,
ipc_rev_timestamp BLOB NOT NULL,
ipc_hex BLOB DEFAULT '' NOT NULL,
PRIMARY KEY(ipc_rev_id)
);
INSERT INTO /*_*/ip_changes_tmp
SELECT ipc_rev_id, ipc_rev_timestamp, ipc_hex
FROM /*_*/ip_changes;
DROP TABLE /*_*/ip_changes;
ALTER TABLE /*_*/ip_changes_tmp RENAME TO /*_*/ip_changes;
CREATE INDEX ipc_rev_timestamp ON /*_*/ip_changes (ipc_rev_timestamp);
CREATE INDEX ipc_hex_time ON /*_*/ip_changes (ipc_hex, ipc_rev_timestamp);

File Metadata

Mime Type
text/plain
Expires
Wed, Aug 19, 00:24 (1 w, 1 d ago)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
4b/28/0f79036c06df14f960034c9b1a69
Default Alt Text
patch-ip_changes-pc_rev_timestamp-drop-default.sql (526 B)

Event Timeline