CREATE TABLE `bilder` ( `id` int(11) NOT NULL auto_increment, `data` longblob NOT NULL, `type` enum('image/jpeg','image/gif','image/png') NOT NULL default 'image/jpeg', `resx` int(11) NOT NULL default '0', `resy` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ;