-- phpMyAdmin SQL Dump
-- version 3.2.2.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 16, 2009 at 02:33 PM
-- Server version: 5.1.39
-- PHP Version: 5.2.11

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `texstarvss`
--

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

--
-- Table structure for table `photographers`
--

CREATE TABLE IF NOT EXISTS `photographers` (
  `Date` date NOT NULL,
  `Time` varchar(4) NOT NULL,
  `Available` int(1) NOT NULL,
  `CourtsPerHour` int(11) NOT NULL,
  `PlayersPerCourt` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `photographers`
--

INSERT INTO `photographers` (`Date`, `Time`, `Available`, `CourtsPerHour`, `PlayersPerCourt`) VALUES
('2009-12-05', '08AM', 1, 2, 2),
('2009-12-05', '09AM', 3, 2, 2),
('2009-12-05', '10AM', 4, 2, 3),
('2009-12-05', '11AM', 4, 3, 4);

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

--
-- Table structure for table `requests`
--

CREATE TABLE IF NOT EXISTS `requests` (
  `Date` date NOT NULL,
  `Time` varchar(4) NOT NULL,
  `Court` int(11) NOT NULL,
  `Team` varchar(30) NOT NULL,
  `Color` varchar(20) NOT NULL,
  `Uniform` varchar(2) NOT NULL,
  `Requestor` varchar(30) NOT NULL,
  `Notes` varchar(30) NOT NULL,
  `Age` varchar(3) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `requests`
--

INSERT INTO `requests` (`Date`, `Time`, `Court`, `Team`, `Color`, `Uniform`, `Requestor`, `Notes`, `Age`) VALUES
('2009-12-05', '08AM', 1, 'Austin Juniors', '', '1', 'Dan Radin', 'DIG  SERVE  HIT ', '12G'),
('2009-12-05', '09AM', 1, 'Austin Juniors', '', '1', 'Dan Radin', 'DIG PASS SERVE   ', '13G'),
('2009-12-05', '08AM', 17, 'Dallas Stars', '', '12', 'Dan Radin', 'DIG  SERVE  HIT ', '13G'),
('2009-12-05', '09AM', 11, 'Houston Rockets', '', '16', 'Dan Radin', 'DIG   BLOCK  ', '13G'),
('2009-12-05', '09AM', 11, 'Kansas City Chiefs', '', '14', 'Dan Radin', 'DIG     FACE', '14G'),
('2009-12-05', '11AM', 1, 'Austin Juniors', 'Red and Blue', '10', 'Dan Radin', 'DIG  SERVE  HIT ', '12G'),
('2009-12-05', '11AM', 1, 'Florida Marlins', 'Red and Blue', '10', 'Dan Radin', ' PASS    FACE', '12G'),
('2009-12-05', '11AM', 50, 'Vancouver Huskies', 'Red and Blud', '99', 'Dan Radin', 'DIG  SERVE  HIT ', '12G');