--
-- "photos" database table structure, Chris Gregerson
-- http://www.phototour.minneapolis.mn.us/
--
-- MySQL dump 8.21
--
-- Host: localhost    Database: photos
---------------------------------------------------------
-- Server version	3.23.49

--
-- Table structure for table 'categories'
--

CREATE TABLE categories (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  title varchar(150) default NULL,
  color varchar(25) default NULL,
  description tinytext,
  keywords text,
  content text,
  photos text,
  avpd decimal(6,2) unsigned default NULL,
  UNIQUE KEY id (id)
) TYPE=MyISAM;


--
-- Table structure for table 'comments'
--

CREATE TABLE comments (
  id smallint(5) unsigned NOT NULL auto_increment,
  type enum('photo','page') NOT NULL default 'photo',
  photo smallint(5) unsigned NOT NULL default '0',
  name varchar(35) default NULL,
  posted date default NULL,
  residence varchar(50) default NULL,
  email varchar(50) default NULL,
  comment text NOT NULL,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'copyright'
--

CREATE TABLE copyright (
  id tinyint(2) NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  description tinytext,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'format'
--

CREATE TABLE format (
  taken date NOT NULL default '0000-00-00',
  format enum('35mm slide','35mm negative','1.2 megapixel(1280 x 960)','4 megapixel(2272 x 1704)') NOT NULL default '35mm negative',
  PRIMARY KEY  (taken)
) TYPE=MyISAM;



--
-- Table structure for table 'links'
--

CREATE TABLE links (
  id smallint(5) unsigned NOT NULL auto_increment,
  title tinytext,
  url tinytext,
  description tinytext,
  keywords tinytext,
  photos tinytext,
  pages tinytext,
  categories tinytext,
  date_checked date default NULL,
  status enum('','ok','404') default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;

--
-- Table structure for table 'pages'
--

CREATE TABLE pages (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(25) default NULL,
  handle varchar(25) default NULL,
  nav_order tinyint(2) unsigned default '99',
  folder varchar(50) default NULL,
  section tinyint(3) unsigned default NULL,
  type varchar(15) default NULL,
  parent varchar(5) NOT NULL default 'index',
  title tinytext,
  description tinytext,
  keywords text,
  content text,
  origin date default NULL,
  modified date default NULL,
  deleted enum('y','n') default 'n',
  avpd decimal(6,2) unsigned default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY path (name,folder)
) TYPE=MyISAM;


--
-- Table structure for table 'photos'
--

CREATE TABLE photos (
  id smallint(5) unsigned NOT NULL auto_increment,
  imagename varchar(50) NOT NULL default '',
  w smallint(5) unsigned default NULL,
  h smallint(5) unsigned default NULL,
  tw smallint(3) unsigned default NULL,
  th smallint(3) unsigned default NULL,
  title tinytext NOT NULL,
  taken date default NULL,
  keywords text,
  description text,
  address tinytext,
  deleted enum('y','n') NOT NULL default 'n',
  modified date default NULL,
  copyright tinyint(2) unsigned default NULL,
  print enum('y','n') default 'n',
  license enum('y','n') default 'y',
  avpd decimal(6,2) unsigned default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY imagename (imagename)
) TYPE=MyISAM;

--
-- Table structure for table 'sections'
--

CREATE TABLE sections (
  id tinyint(3) unsigned NOT NULL default '0',
  name varchar(50) NOT NULL default '',
  title varchar(150) default NULL,
  color varchar(25) default NULL,
  description tinytext,
  keywords tinytext,
  categories text,
  content text,
  avpd decimal(6,2) unsigned default NULL,
  PRIMARY KEY  (id),
  UNIQUE KEY name (name)
) TYPE=MyISAM;

--
-- Table structure for table 'shared_html'
--

CREATE TABLE shared_html (
  id tinyint(3) unsigned NOT NULL auto_increment,
  name varchar(50) NOT NULL default '',
  content text,
  UNIQUE KEY id (id)
) TYPE=MyISAM;


--
-- Table structure for table 'templates'
--

CREATE TABLE templates (
  id tinyint(3) unsigned NOT NULL auto_increment,
  folder varchar(50) default NULL,
  section tinyint(3) unsigned default NULL,
  type varchar(15) default NULL,
  content text,
  PRIMARY KEY  (id)
) TYPE=MyISAM;