-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb1ubuntu0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 02, 2011 at 08:44 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6-2ubuntu4.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `sunnybrook`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `UserName` varchar(20) NOT NULL,
  `Password` text NOT NULL,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  `AccessLevel` text NOT NULL COMMENT 'admin',
  `Notes` text,
  PRIMARY KEY  (`UserName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


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

--
-- Table structure for table `attendance`
--

CREATE TABLE IF NOT EXISTS `attendance` (
  `UKey` int(11) NOT NULL auto_increment,
  `ChildID` text NOT NULL,
  `Grade` text NOT NULL,
  `AgeGroup` text NOT NULL,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  `Date` text NOT NULL,
  `YearMonthDay` text COMMENT 'example 20110625',
  `DayOfYear` text NOT NULL COMMENT '0-365',
  `InTime` text NOT NULL COMMENT 'Check in Time',
  `OutTime` text NOT NULL COMMENT 'Check Out Time',
  `Event` text,
  `ParentEmail` text,
  PRIMARY KEY  (`UKey`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11422 ;


--
-- Table structure for table `child`
--

CREATE TABLE IF NOT EXISTS `child` (
  `ChildID` varchar(11) NOT NULL,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  `Address` text NOT NULL COMMENT 'House number where child lives',
  `City` text NOT NULL COMMENT 'street of house number',
  `Gender` text NOT NULL COMMENT 'Male or Female',
  `Grade` text NOT NULL COMMENT 'ex 4-5 year olds',
  `AgeGroup` text NOT NULL,
  `Birthday` text NOT NULL COMMENT '01/19/1985',
  `DateEntered` text NOT NULL COMMENT '01/19/1985',
  `Status` text NOT NULL COMMENT 'Checkedin',
  `StatusChange` text NOT NULL COMMENT 'Time of Status Change',
  `Allergies` text,
  `Notes` text,
  `ParentID1` text,
  `ParentID2` text,
  `ParentID3` text,
  `ParentID4` text,
  `ParentID5` text,
  `ParentID6` text,
  `ParentID7` text,
  `ParentID8` text,
  PRIMARY KEY  (`ChildID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


--
-- Table structure for table `parent`
--

CREATE TABLE IF NOT EXISTS `parent` (
  `ParentID` int(11) NOT NULL auto_increment,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  `Address` text NOT NULL,
  `City` text NOT NULL,
  `HomePhone` text NOT NULL,
  `CellPhone1` text,
  `Email` text,
  `VolunteerLocation` text,
  `VolunteerTitle` text,
  `ChildID1` text,
  `ChildID2` text,
  `ChildID3` text,
  `ChildID4` text,
  `ChildID5` text,
  `ChildID6` text,
  `ChildID7` text,
  `ChildID8` text,
  `ChildID9` text,
  `ChildID10` text,
  PRIMARY KEY  (`ParentID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1002 ;

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

--
-- Table structure for table `volunteerattendance`
--

CREATE TABLE IF NOT EXISTS `volunteerattendance` (
  `UKey` int(11) NOT NULL auto_increment,
  `ParentID` text NOT NULL,
  `VolunteerLocation` text,
  `VolunteerTitle` text,
  `FirstName` text NOT NULL,
  `LastName` text NOT NULL,
  `Date` text NOT NULL,
  `DayOfYear` text NOT NULL COMMENT '0-365',
  `InTime` text NOT NULL COMMENT 'Check in Time',
  `OutTime` text NOT NULL COMMENT 'Check Out Time',
  `Event` text,
  PRIMARY KEY  (`UKey`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2549 ;