-- phpMyAdmin SQL Dump
-- version 2.8.2-Debian-0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Feb 28, 2007 at 01:04 PM
-- Server version: 5.0.24
-- PHP Version: 5.1.6
-- 
-- Database: `eilika`
-- 

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

-- 
-- Table structure for table `BF2006`
-- 

CREATE TABLE `BF2006` (
  `Record` int(11) NOT NULL auto_increment,
  `SCA` mediumtext NOT NULL,
  `Last` mediumtext NOT NULL,
  `First` mediumtext NOT NULL,
  `CampingWith` mediumtext NOT NULL,
  `Email` mediumtext NOT NULL,
  `Phone` mediumtext NOT NULL,
  `Title` mediumtext NOT NULL,
  `Sponsor` mediumtext NOT NULL,
  `Type` tinytext NOT NULL,
  `Description` longtext NOT NULL,
  `Area` tinytext NOT NULL,
  `NumPartic` mediumint(9) NOT NULL default '0',
  `AgeLimit` tinytext,
  `YearsOld` mediumint(9) default '0',
  `Hours` tinyint(4) NOT NULL default '0',
  `EntryReqs` mediumtext,
  `Waterbearers` tinytext,
  `Chirurgeon` tinytext,
  `Cars` tinytext,
  `Day1` tinyint(4) NOT NULL default '0',
  `Time1` tinytext NOT NULL,
  `Day2` tinyint(4) default '0',
  `Time2` tinytext,
  `Day3` tinyint(4) default '0',
  `Time3` tinytext,
  `Special` longtext,
  PRIMARY KEY  (`Record`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;

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

-- 
-- Table structure for table `Main`
-- 

CREATE TABLE `Main` (
  `Record` int(11) NOT NULL auto_increment,
  `SCA` mediumtext NOT NULL,
  `Last` mediumtext NOT NULL,
  `First` mediumtext NOT NULL,
  `CampingWith` mediumtext NOT NULL,
  `Email` mediumtext NOT NULL,
  `Phone` mediumtext NOT NULL,
  `Title` mediumtext NOT NULL,
  `Sponsor` mediumtext NOT NULL,
  `Type` tinytext NOT NULL,
  `Description` longtext NOT NULL,
  `Area` tinytext NOT NULL,
  `NumPartic` mediumint(9) NOT NULL default '0',
  `AgeLimit` tinytext,
  `YearsOld` mediumint(9) default '0',
  `Hours` tinyint(4) NOT NULL default '0',
  `EntryReqs` mediumtext,
  `Waterbearers` tinytext,
  `Chirurgeon` tinytext,
  `Cars` tinytext,
  `Day1` tinyint(4) NOT NULL default '0',
  `Time1` tinytext NOT NULL,
  `Day2` tinyint(4) default '0',
  `Time2` tinytext,
  `Day3` tinyint(4) default '0',
  `Time3` tinytext,
  `Special` longtext,
  PRIMARY KEY  (`Record`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;

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

-- 
-- Table structure for table `Pav2006`
-- 

CREATE TABLE `Pav2006` (
  `Record` tinyint(4) NOT NULL auto_increment,
  `Kingdom` mediumtext NOT NULL,
  `SCA` mediumtext NOT NULL,
  `CampingWith` mediumtext NOT NULL,
  `First` mediumtext NOT NULL,
  `Last` mediumtext NOT NULL,
  `Email` mediumtext NOT NULL,
  `Phone` mediumtext NOT NULL,
  `Size1` mediumtext NOT NULL,
  `Place1` mediumtext NOT NULL,
  `Purpose1` mediumtext NOT NULL,
  `OtherDesc1` mediumtext,
  `Size2` mediumtext,
  `Place2` mediumtext,
  `Purpose2` mediumtext,
  `OtherDesc2` mediumtext,
  `Size3` mediumtext,
  `Place3` mediumtext,
  `Purpose3` mediumtext,
  `OtherDesc3` mediumtext,
  PRIMARY KEY  (`Record`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;