-- phpMyAdmin SQL Dump
-- version 2.10.0.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 27, 2009 at 12:51 PM
-- Server version: 5.0.22
-- PHP Version: 5.1.2
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `cis236shared`
--
-- --------------------------------------------------------
--
-- Table structure for table `campers`
--
CREATE TABLE `campers` (
`camperID` char(20) NOT NULL,
`FirstName` char(20) default NULL,
`LastName` char(20) default NULL,
`StreetAddress` char(50) default NULL,
`City` char(20) default NULL,
`State` char(2) default NULL,
`Zip` char(5) default NULL,
`Phone` char(20) default NULL,
`Email` char(30) default NULL,
`camperPASS` char(20) default NULL,
PRIMARY KEY (`camperID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `campers`
--
INSERT INTO `campers` (`camperID`, `FirstName`, `LastName`, `StreetAddress`,
`City`, `State`, `Zip`, `Phone`, `Email`, `camperPASS`) VALUES
('sc4camper', 'SC4', 'Camper', '323 Erie St', 'Port Huron', 'MI',
'48060', '810 984-3881', 'sc4camper@stu.sc4.edu', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `rates`
--
CREATE TABLE `rates` (
`SiteType` varchar(1) NOT NULL,
`SiteDesc` varchar(30) NOT NULL,
`NightlyRate` decimal(19,2) NOT NULL,
`WeeklyRate` decimal(19,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `rates`
--
INSERT INTO `rates` (`SiteType`, `SiteDesc`, `NightlyRate`, `WeeklyRate`)
VALUES
('E', 'Electric Only', '25.00', '0.00'),
('W', 'Water and Electric', '30.00', '0.00'),
('F', 'Full = water+sewer+electric', '40.00', '0.00'),
('P', 'Primitive', '20.00', '0.00');
-- --------------------------------------------------------
--
-- Table structure for table `sites`
--
CREATE TABLE `sites` (
`siteNum` varchar(4) NOT NULL,
`siteType` varchar(1) NOT NULL,
`Notes` varchar(80) NOT NULL,
PRIMARY KEY (`siteNum`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
--
-- Dumping data for table `sites`
--
INSERT INTO `sites` (`siteNum`, `siteType`, `Notes`) VALUES
('100', 'F', 'Waterfront site');
|
