# phpMyAdmin SQL Dump
# version 2.5.2-pl1
# http://www.phpmyadmin.net
#
# Host: aya.metalbat.com
# Generation Time: Aug 09, 2004 at 08:13 AM
# Server version: 4.0.20
# PHP Version: 4.3.5
# 
# Database : `aya`
# 
CREATE DATABASE `aya`;
USE aya;

# --------------------------------------------------------

#
# Table structure for table `Comments`
#
# Creation: Dec 04, 2003 at 06:33 AM
# Last update: Aug 09, 2004 at 02:17 AM
# Last check: Aug 09, 2004 at 04:13 AM
#

CREATE TABLE `Comments` (
  `ID` int(11) NOT NULL default '0',
  `IDPhotos` int(11) NOT NULL default '0',
  `Submitted` datetime NOT NULL default '0000-00-00 00:00:00',
  `Name` varchar(64) NOT NULL default '',
  `Blurb` text NOT NULL,
  `IP` varchar(32) NOT NULL default '',
  KEY `ID` (`ID`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `Contributors`
#
# Creation: Aug 29, 2003 at 04:04 AM
# Last update: Aug 29, 2003 at 04:05 AM
# Last check: Aug 09, 2004 at 04:13 AM
#

CREATE TABLE `Contributors` (
  `ID` int(11) NOT NULL default '0',
  `Name` varchar(64) NOT NULL default '',
  `Primary` char(1) default NULL,
  KEY `ID` (`ID`)
) TYPE=MyISAM;

# --------------------------------------------------------

#
# Table structure for table `Photos`
#
# Creation: Apr 17, 2004 at 10:04 AM
# Last update: Aug 09, 2004 at 03:58 AM
# Last check: Aug 09, 2004 at 04:13 AM
#

CREATE TABLE `Photos` (
  `ID` int(11) NOT NULL auto_increment,
  `Submitted` datetime default NULL,
  `Location` varchar(16) default NULL,
  `IDContributors` smallint(6) NOT NULL default '0',
  `Caption` varchar(255) default NULL,
  `Blurb` text,
  `Photo` char(1) default NULL,
  KEY `ID` (`ID`),
  FULLTEXT KEY `Location` (`Location`,`Caption`,`Blurb`)
) TYPE=MyISAM;