patch-image-img_name-varbinary.sql
No OneTemporary
Actions

Size

1 KB

Referenced Files

None

Subscribers

None

patch-image-img_name-varbinary.sql
View Options

	CREATE TABLE image_tmp (
	img_name BLOB DEFAULT '' NOT NULL,
	img_size INTEGER UNSIGNED DEFAULT 0 NOT NULL,
	img_width INTEGER DEFAULT 0 NOT NULL,
	img_height INTEGER DEFAULT 0 NOT NULL,
	img_metadata BLOB NOT NULL,
	img_bits INTEGER DEFAULT 0 NOT NULL,
	img_media_type TEXT DEFAULT NULL,
	img_major_mime TEXT DEFAULT 'unknown' NOT NULL,
	img_minor_mime BLOB DEFAULT 'unknown' NOT NULL,
	img_description_id BIGINT UNSIGNED NOT NULL,
	img_actor BIGINT UNSIGNED NOT NULL,
	img_timestamp BLOB NOT NULL,
	img_sha1 BLOB DEFAULT '' NOT NULL,
	PRIMARY KEY(img_name)
	);
	INSERT INTO /_/image_tmp (
	img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime,
	img_description_id, img_actor, img_timestamp, img_sha1)
	SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime,
	img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1
	FROM /_/image;
	DROP TABLE /_/image;
	ALTER TABLE /_/image_tmp RENAME TO /_/image;
	CREATE INDEX img_actor_timestamp ON /_/image (img_actor, img_timestamp);

	CREATE INDEX img_size ON /_/image (img_size);

	CREATE INDEX img_timestamp ON /_/image (img_timestamp);

	CREATE INDEX img_sha1 ON /_/image (img_sha1);

	CREATE INDEX img_media_mime ON /_/image (
	img_media_type, img_major_mime, img_minor_mime
	);