Page MenuHomeWickedGov Phorge
Files F1429375

patch-oldimage-oi_timestamp.sql
No OneTemporary
Actions

Size
2 KB
Referenced Files
None
Subscribers
None

patch-oldimage-oi_timestamp.sql
View Options

-- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
-- Source: sql/abstractSchemaChanges/patch-oldimage-oi_timestamp.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TEMPORARY TABLE /*_*/__temp__oldimage AS
SELECT
oi_name,
oi_archive_name,
oi_size,
oi_width,
oi_height,
oi_bits,
oi_description_id,
oi_actor,
oi_timestamp,
oi_metadata,
oi_media_type,
oi_major_mime,
oi_minor_mime,
oi_deleted,
oi_sha1
FROM /*_*/oldimage;
DROP TABLE /*_*/oldimage;
CREATE TABLE /*_*/oldimage (
oi_name BLOB DEFAULT '' NOT NULL, oi_archive_name BLOB DEFAULT '' NOT NULL,
oi_size INTEGER UNSIGNED DEFAULT 0 NOT NULL,
oi_width INTEGER DEFAULT 0 NOT NULL,
oi_height INTEGER DEFAULT 0 NOT NULL,
oi_bits INTEGER DEFAULT 0 NOT NULL,
oi_description_id BIGINT UNSIGNED NOT NULL,
oi_actor BIGINT UNSIGNED NOT NULL,
oi_timestamp BLOB NOT NULL, oi_metadata BLOB NOT NULL,
oi_media_type TEXT DEFAULT NULL, oi_major_mime TEXT DEFAULT 'unknown' NOT NULL,
oi_minor_mime BLOB DEFAULT 'unknown' NOT NULL,
oi_deleted SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
oi_sha1 BLOB DEFAULT '' NOT NULL
);
INSERT INTO /*_*/oldimage (
oi_name, oi_archive_name, oi_size,
oi_width, oi_height, oi_bits, oi_description_id,
oi_actor, oi_timestamp, oi_metadata,
oi_media_type, oi_major_mime, oi_minor_mime,
oi_deleted, oi_sha1
)
SELECT
oi_name,
oi_archive_name,
oi_size,
oi_width,
oi_height,
oi_bits,
oi_description_id,
oi_actor,
oi_timestamp,
oi_metadata,
oi_media_type,
oi_major_mime,
oi_minor_mime,
oi_deleted,
oi_sha1
FROM
/*_*/__temp__oldimage;
DROP TABLE /*_*/__temp__oldimage;
CREATE INDEX oi_actor_timestamp ON /*_*/oldimage (oi_actor, oi_timestamp);
CREATE INDEX oi_name_timestamp ON /*_*/oldimage (oi_name, oi_timestamp);
CREATE INDEX oi_name_archive_name ON /*_*/oldimage (oi_name, oi_archive_name);
CREATE INDEX oi_sha1 ON /*_*/oldimage (oi_sha1);
CREATE INDEX oi_timestamp ON /*_*/oldimage (oi_timestamp);

File Metadata

Mime Type
text/plain
Expires
Sat, May 16, 17:29 (8 h, 36 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
f4/2f/6464a5fe0b384aebd18891b88c1a
Default Alt Text
patch-oldimage-oi_timestamp.sql (2 KB)

Event Timeline