1 CREATE TABLE image_tmp (
2 img_name BLOB DEFAULT '' NOT NULL,
3 img_size INTEGER UNSIGNED DEFAULT 0 NOT NULL,
4 img_width INTEGER DEFAULT 0 NOT NULL,
5 img_height INTEGER DEFAULT 0 NOT NULL,
6 img_metadata BLOB NOT NULL,
7 img_bits INTEGER DEFAULT 0 NOT NULL,
8 img_media_type TEXT DEFAULT NULL,
9 img_major_mime TEXT DEFAULT 'unknown' NOT NULL,
10 img_minor_mime BLOB DEFAULT 'unknown' NOT NULL,
11 img_description_id BIGINT UNSIGNED NOT NULL,
12 img_actor BIGINT UNSIGNED NOT NULL,
13 img_timestamp BLOB NOT NULL,
14 img_sha1 BLOB DEFAULT '' NOT NULL,
17 INSERT INTO /*_*/image_tmp (
18 img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime, img_minor_mime,
19 img_description_id, img_actor, img_timestamp, img_sha1)
20 SELECT img_name, img_size, img_width, img_height, img_metadata, img_bits, img_media_type, img_major_mime,
21 img_minor_mime, img_description_id, img_actor, img_timestamp, img_sha1
23 DROP TABLE /*_*/image;
24 ALTER TABLE /*_*/image_tmp RENAME TO /*_*/image;
25 CREATE INDEX img_actor_timestamp ON /*_*/image (img_actor, img_timestamp);
27 CREATE INDEX img_size ON /*_*/image (img_size);
29 CREATE INDEX img_timestamp ON /*_*/image (img_timestamp);
31 CREATE INDEX img_sha1 ON /*_*/image (img_sha1);
33 CREATE INDEX img_media_mime ON /*_*/image (
34 img_media_type, img_major_mime, img_minor_mime