-- MySQL dump 8.23
--
-- Host: localhost    Database: davis
---------------------------------------------------------
-- Server version	3.23.58-log

--
-- Table structure for table `photos`
--

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,
  page_height smallint(5) unsigned default NULL,
  page_width smallint(5) unsigned default NULL,
  category smallint(5) unsigned default NULL,
  access enum('Public','Personal') default 'Personal',
  title varchar(255) default NULL,
  video_mime_type varchar(255) default NULL,
  PRIMARY KEY  (id),
  KEY category (category),
  KEY access (access),
  KEY date_shot (date_shot)
) TYPE=MyISAM;