CREATE TABLE `photos` (
  `id` smallint(5) unsigned NOT NULL auto_increment,
  `location` varchar(255) NOT NULL default '',
  `description` mediumtext NOT NULL,
  `date_shot` date NOT NULL default '0000-00-00',
  `filename` varchar(255) NOT NULL default '',
  `mimetype` varchar(50) NOT NULL default '',
  `height` smallint(5) unsigned default NULL,
  `width` smallint(5) unsigned default NULL,
  `thumb_height` smallint(5) unsigned default NULL,
  `thumb_width` smallint(5) unsigned default NULL,
  `img_data` longblob,
  `category` smallint(5) unsigned default NULL,
  `access` enum('Public','Personal') default 'Personal',
  `title` varchar(255) default NULL,
  PRIMARY KEY  (`id`)
)