-- MySQL dump 10.11
--
-- Host: localhost    Database: water
-- ------------------------------------------------------
-- Server version	5.0.45


-- water-structure.sql - used to hold a water collection
-- Eric Lease Morgan <eric_morgan@infomotions.com>
-- September 2, 2009


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `collectors`
--

DROP TABLE IF EXISTS `collectors`;
CREATE TABLE `collectors` (
  `collector_id` int(2) NOT NULL auto_increment,
  `first_name` varchar(255) NOT NULL default '',
  `middle_name` varchar(255) NOT NULL default '',
  `last_name` varchar(255) NOT NULL default '',
  `note` text NOT NULL,
  PRIMARY KEY  (`collector_id`),
  FULLTEXT KEY `first_name` (`first_name`,`middle_name`,`last_name`,`note`),
  FULLTEXT KEY `first_name_2` (`first_name`),
  FULLTEXT KEY `middle_name` (`middle_name`),
  FULLTEXT KEY `last_name` (`last_name`),
  FULLTEXT KEY `note` (`note`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;

--
-- Table structure for table `items_for_collectors`
--

DROP TABLE IF EXISTS `items_for_collectors`;
CREATE TABLE `items_for_collectors` (
  `id` int(2) NOT NULL auto_increment,
  `collector_id` int(2) NOT NULL default '0',
  `water_id` int(2) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=340 DEFAULT CHARSET=latin1;

--
-- Table structure for table `metadata`
--

DROP TABLE IF EXISTS `metadata`;
CREATE TABLE `metadata` (
  `metadata_id` int(2) NOT NULL default '0',
  `creator` varchar(255) NOT NULL default '',
  `date_created` date NOT NULL default '0000-00-00',
  `email` varchar(255) NOT NULL default '',
  `short_blurb` text NOT NULL,
  `long_blurb` text NOT NULL,
  `home_page` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `subjects` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Table structure for table `waters`
--

DROP TABLE IF EXISTS `waters`;
CREATE TABLE `waters` (
  `water_id` int(2) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '',
  `year` year(4) default NULL,
  `month` int(2) default NULL,
  `day` int(2) default NULL,
  `description` text NOT NULL,
  `image` mediumblob NOT NULL,
  `lat` float default NULL,
  `lng` float default NULL,
  PRIMARY KEY  (`water_id`),
  FULLTEXT KEY `name` (`name`,`description`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `name_2` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2009-09-03  0:56:33