create table smd__thumb (
	fileID INT UNSIGNED NOT NULL,
	size INT NOT NULL,
	thumbType VARCHAR(30) NOT NULL,
	width SMALLINT NOT NULL,
	height SMALLINT NOT NULL,
	url varchar(255) NOT NULL,
	PRIMARY KEY(fileID, thumbType),
  	CONSTRAINT thumb__file_static FOREIGN KEY (fileID) REFERENCES cms__file_static (fileID) ON DELETE CASCADE ON UPDATE CASCADE,
  	KEY index_thumbType (thumbType) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE utf8mb4_general_ci;