-- phpMyAdmin SQL Dump
-- version 2.10.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 03, 2009 at 05:36 PM
-- Server version: 5.0.45
-- PHP Version: 5.2.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

-- 
-- Database: `historical_storms`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `StormHeader`
-- 

CREATE TABLE `StormHeader` (
  `storm_id` int(10) unsigned NOT NULL auto_increment,
  `start_date` date NOT NULL,
  `storm_days` tinyint(3) unsigned NOT NULL,
  `storm_num` tinyint(3) unsigned NOT NULL,
  `total_storm_num` mediumint(8) unsigned NOT NULL,
  `storm_name` varchar(15) collate latin1_general_ci NOT NULL,
  `hit_US` tinyint(4) NOT NULL,
  `hit_US_cat` tinyint(4) NOT NULL,
  `last_storm` tinyint(4) NOT NULL,
  `max_intensity` varchar(2) collate latin1_general_ci NOT NULL,
  `basin` varchar(1) collate latin1_general_ci NOT NULL,
  `remarks` varchar(40) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`storm_id`),
  KEY `start_date` (`start_date`),
  KEY `storm_days` (`storm_days`),
  KEY `storm_num` (`storm_num`),
  KEY `storm_name` (`storm_name`),
  KEY `hit_US` (`hit_US`),
  KEY `hit_US_cat` (`hit_US_cat`),
  KEY `last_storm` (`last_storm`),
  KEY `max_intensity` (`max_intensity`),
  KEY `basin` (`basin`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ;

-- --------------------------------------------------------

-- 
-- Table structure for table `StormHeaderLocUS`
-- 

CREATE TABLE `StormHeaderLocUS` (
  `locUS_id` int(10) unsigned NOT NULL auto_increment,
  `storm_id` int(10) unsigned NOT NULL,
  `loc_US` varchar(3) collate latin1_general_ci NOT NULL,
  `cat_loc_US` tinyint(4) NOT NULL,
  PRIMARY KEY  (`locUS_id`),
  KEY `storm_id` (`storm_id`),
  KEY `loc_US` (`loc_US`),
  KEY `cat_loc_US` (`cat_loc_US`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci ;

-- --------------------------------------------------------

-- 
-- Table structure for table `StormObservations`
-- 

CREATE TABLE `StormObservations` (
  `stormobs_id` int(10) unsigned NOT NULL auto_increment,
  `storm_id` int(10) unsigned NOT NULL,
  `obs_date` datetime NOT NULL,
  `storm_type` varchar(1) collate latin1_general_ci NOT NULL,
  `latitude` decimal(3,1) NOT NULL,
  `longitude` decimal(4,1) NOT NULL,
  `wind_speed` smallint(5) unsigned NOT NULL,
  `central_pressure` smallint(5) unsigned NOT NULL,
  `translational_speed` tinyint(4) NOT NULL,
  `direction` smallint(6) NOT NULL,
  `coordinate` point NOT NULL,
  PRIMARY KEY  (`stormobs_id`),
  KEY `storm_id` (`storm_id`),
  KEY `obs_date` (`obs_date`),
  KEY `storm_type` (`storm_type`),
  KEY `wind_speed` (`wind_speed`),
  KEY `central_pressure` (`central_pressure`),
  KEY `translational_speed` (`translational_speed`),
  KEY `direction` (`direction`),
  SPATIAL KEY `coordinate` (`coordinate`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

