-- phpMyAdmin SQL Dump
-- version 2.6.1-pl2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 20, 2005 at 03:57 PM
-- Server version: 4.0.23
-- PHP Version: 4.3.10
-- 
-- Database: `lampsig_lampmysqlclass`
-- 

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

-- 
-- Table structure for table `addressType`
-- 

DROP TABLE IF EXISTS `addressType`;
CREATE TABLE IF NOT EXISTS `addressType` (
  `addressTypeID` int(11) NOT NULL auto_increment,
  `addressType` enum('mailing','street','work','other') NOT NULL default 'mailing',
  PRIMARY KEY  (`addressTypeID`),
  KEY `addressType` (`addressType`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `addressType`
-- 

INSERT INTO `addressType` VALUES (1, 'mailing');
INSERT INTO `addressType` VALUES (2, 'street');
INSERT INTO `addressType` VALUES (3, 'work');
INSERT INTO `addressType` VALUES (4, 'other');

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

-- 
-- Table structure for table `category`
-- 

DROP TABLE IF EXISTS `category`;
CREATE TABLE IF NOT EXISTS `category` (
  `categoryID` int(11) NOT NULL auto_increment,
  `category` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`categoryID`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `category`
-- 

INSERT INTO `category` VALUES (1, 'database');
INSERT INTO `category` VALUES (2, 'programming');
INSERT INTO `category` VALUES (3, 'ecommerce');
INSERT INTO `category` VALUES (4, 'administration');

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

-- 
-- Table structure for table `contactType`
-- 

DROP TABLE IF EXISTS `contactType`;
CREATE TABLE IF NOT EXISTS `contactType` (
  `contactTypeID` int(11) NOT NULL auto_increment,
  `contactType` enum('home','work','cell','pager','email','other') NOT NULL default 'home',
  PRIMARY KEY  (`contactTypeID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `contactType`
-- 

INSERT INTO `contactType` VALUES (1, 'home');
INSERT INTO `contactType` VALUES (2, 'work');
INSERT INTO `contactType` VALUES (3, 'cell');
INSERT INTO `contactType` VALUES (4, 'pager');
INSERT INTO `contactType` VALUES (5, 'email');
INSERT INTO `contactType` VALUES (6, 'other');

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

-- 
-- Table structure for table `contacts`
-- 

DROP TABLE IF EXISTS `contacts`;
CREATE TABLE IF NOT EXISTS `contacts` (
  `contactID` int(11) NOT NULL auto_increment,
  `contactPersonID` int(11) NOT NULL default '0',
  `contactTypeID` int(11) NOT NULL default '0',
  `contactInformation` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`contactID`,`contactPersonID`),
  KEY `contactPersonID` (`contactPersonID`,`contactTypeID`)
) TYPE=MyISAM AUTO_INCREMENT=24 ;

-- 
-- Dumping data for table `contacts`
-- 

INSERT INTO `contacts` VALUES (1, 1, 1, '(323) 555-1234');
INSERT INTO `contacts` VALUES (2, 2, 5, 'j.smith@isp.com');
INSERT INTO `contacts` VALUES (3, 2, 3, '(213) 555-1234');
INSERT INTO `contacts` VALUES (4, 2, 5, 'doe@gmail.com');
INSERT INTO `contacts` VALUES (5, 3, 1, '(323) 555-7894');
INSERT INTO `contacts` VALUES (6, 3, 3, '(213) 555-6541');
INSERT INTO `contacts` VALUES (7, 3, 5, 'lakes@somewhere.com');
INSERT INTO `contacts` VALUES (8, 1, 3, '(323) 555-4321');
INSERT INTO `contacts` VALUES (9, 4, 3, '(818) 555-4561');
INSERT INTO `contacts` VALUES (10, 4, 2, '(818) 555-8945');
INSERT INTO `contacts` VALUES (11, 4, 5, 'schange@yahoo.com');
INSERT INTO `contacts` VALUES (12, 5, 1, '(213) 555-9632');
INSERT INTO `contacts` VALUES (13, 6, 4, '(310) 555-7894');
INSERT INTO `contacts` VALUES (14, 6, 5, 'emailme@email.com');
INSERT INTO `contacts` VALUES (15, 7, 1, '(818) 555-7412');
INSERT INTO `contacts` VALUES (16, 7, 5, 'valleygirl@valleyisp.com');
INSERT INTO `contacts` VALUES (17, 8, 5, 'theoldprez@headquarters.gov');
INSERT INTO `contacts` VALUES (18, 9, 1, '(310) 555-9998');
INSERT INTO `contacts` VALUES (19, 9, 3, '(310) 555-4455');
INSERT INTO `contacts` VALUES (20, 10, 5, 'snookums@isp.com');
INSERT INTO `contacts` VALUES (21, 4, 5, 'pete@peterbenjamin.com');
INSERT INTO `contacts` VALUES (22, 2, 5, 'david@gizmola.com');
INSERT INTO `contacts` VALUES (23, 1, 3, '(818) 555-4561');

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

-- 
-- Table structure for table `instructor`
-- 

DROP TABLE IF EXISTS `instructor`;
CREATE TABLE IF NOT EXISTS `instructor` (
  `instructorID` int(11) NOT NULL auto_increment,
  `lastName` varchar(50) NOT NULL default '',
  `firstName` varchar(50) default NULL,
  PRIMARY KEY  (`instructorID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `instructor`
-- 

INSERT INTO `instructor` VALUES (1, 'Chang', 'Solomon');
INSERT INTO `instructor` VALUES (2, 'Gizmola', '');
INSERT INTO `instructor` VALUES (3, 'Thompson', 'Christopher');
INSERT INTO `instructor` VALUES (4, 'Benjamin', 'Peter');
INSERT INTO `instructor` VALUES (5, 'Benjamin', 'David');
INSERT INTO `instructor` VALUES (6, 'Christopher', 'Smith');

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

-- 
-- Table structure for table `seminar`
-- 

DROP TABLE IF EXISTS `seminar`;
CREATE TABLE IF NOT EXISTS `seminar` (
  `seminarID` int(11) NOT NULL auto_increment,
  `seminarName` varchar(50) NOT NULL default '',
  `seminarDescription` varchar(100) NOT NULL default '',
  `date` date NOT NULL default '0000-00-00',
  `startTime` time NOT NULL default '00:00:00',
  `endTime` time NOT NULL default '00:00:00',
  `totalSeatsAvail` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`seminarID`),
  KEY `seminarName` (`seminarName`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `seminar`
-- 

INSERT INTO `seminar` VALUES (1, 'MySQL', 'Learning MySQL', '2005-06-23', '19:00:00', '21:00:00', 7);
INSERT INTO `seminar` VALUES (2, 'PHP OO', 'Programming with OO PHP', '2005-06-24', '19:00:00', '21:00:00', 10);
INSERT INTO `seminar` VALUES (3, 'Intro PHP', 'An Introduction to programming with PHP', '2005-06-25', '19:00:00', '21:00:00', 5);
INSERT INTO `seminar` VALUES (4, 'Intro PERL', 'An Introduction to programming with PERL', '2005-06-23', '19:00:00', '21:00:00', 5);
INSERT INTO `seminar` VALUES (5, 'Apache', 'Configuring Apache Webserver', '2005-06-27', '19:00:00', '21:00:00', 10);
INSERT INTO `seminar` VALUES (6, 'Postgres', 'Learning Postgres', '2005-06-28', '19:00:00', '21:00:00', 12);
INSERT INTO `seminar` VALUES (7, 'LAMP', 'Setting up LAMP (Linux Apache MySQL PHP or PERL)', '2005-06-29', '17:00:00', '20:00:00', 5);
INSERT INTO `seminar` VALUES (8, 'Advanced PHP', 'An Advanced PHP for Applications', '2005-06-30', '19:00:00', '21:00:00', 10);
INSERT INTO `seminar` VALUES (9, 'Inventory Setup', 'Using a database and PHP to create an Ecommerce inventory', '2005-07-01', '19:00:00', '21:00:00', 5);
INSERT INTO `seminar` VALUES (10, 'Ecommerce', 'Zen Shopping Cart Installation', '2005-06-23', '13:00:00', '15:00:00', 6);

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

-- 
-- Table structure for table `seminarCategory`
-- 

DROP TABLE IF EXISTS `seminarCategory`;
CREATE TABLE IF NOT EXISTS `seminarCategory` (
  `seminarID` int(11) NOT NULL default '0',
  `categoryID` int(11) NOT NULL default '0',
  KEY `seminarID` (`seminarID`,`categoryID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `seminarCategory`
-- 

INSERT INTO `seminarCategory` VALUES (1, 1);
INSERT INTO `seminarCategory` VALUES (2, 2);
INSERT INTO `seminarCategory` VALUES (3, 2);
INSERT INTO `seminarCategory` VALUES (4, 2);
INSERT INTO `seminarCategory` VALUES (5, 4);
INSERT INTO `seminarCategory` VALUES (6, 1);
INSERT INTO `seminarCategory` VALUES (7, 4);
INSERT INTO `seminarCategory` VALUES (8, 2);
INSERT INTO `seminarCategory` VALUES (9, 1);
INSERT INTO `seminarCategory` VALUES (9, 2);
INSERT INTO `seminarCategory` VALUES (9, 3);
INSERT INTO `seminarCategory` VALUES (10, 3);

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

-- 
-- Table structure for table `seminarInstructor`
-- 

DROP TABLE IF EXISTS `seminarInstructor`;
CREATE TABLE IF NOT EXISTS `seminarInstructor` (
  `instructorID` int(11) NOT NULL default '0',
  `seminarID` int(11) NOT NULL default '0',
  KEY `instructorID` (`instructorID`,`seminarID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `seminarInstructor`
-- 

INSERT INTO `seminarInstructor` VALUES (1, 1);
INSERT INTO `seminarInstructor` VALUES (2, 2);
INSERT INTO `seminarInstructor` VALUES (2, 8);
INSERT INTO `seminarInstructor` VALUES (2, 10);
INSERT INTO `seminarInstructor` VALUES (3, 3);
INSERT INTO `seminarInstructor` VALUES (4, 4);
INSERT INTO `seminarInstructor` VALUES (4, 5);
INSERT INTO `seminarInstructor` VALUES (4, 7);
INSERT INTO `seminarInstructor` VALUES (5, 9);
INSERT INTO `seminarInstructor` VALUES (6, 6);

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

-- 
-- Table structure for table `seminarStudent`
-- 

DROP TABLE IF EXISTS `seminarStudent`;
CREATE TABLE IF NOT EXISTS `seminarStudent` (
  `studentID` int(11) NOT NULL default '0',
  `seminarID` int(11) NOT NULL default '0',
  KEY `studentID` (`studentID`,`seminarID`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `seminarStudent`
-- 

INSERT INTO `seminarStudent` VALUES (1, 1);
INSERT INTO `seminarStudent` VALUES (1, 3);
INSERT INTO `seminarStudent` VALUES (1, 4);
INSERT INTO `seminarStudent` VALUES (1, 8);
INSERT INTO `seminarStudent` VALUES (2, 9);
INSERT INTO `seminarStudent` VALUES (2, 10);
INSERT INTO `seminarStudent` VALUES (3, 6);
INSERT INTO `seminarStudent` VALUES (4, 2);
INSERT INTO `seminarStudent` VALUES (5, 3);
INSERT INTO `seminarStudent` VALUES (5, 4);
INSERT INTO `seminarStudent` VALUES (5, 5);
INSERT INTO `seminarStudent` VALUES (7, 1);
INSERT INTO `seminarStudent` VALUES (7, 2);
INSERT INTO `seminarStudent` VALUES (7, 3);
INSERT INTO `seminarStudent` VALUES (7, 8);
INSERT INTO `seminarStudent` VALUES (7, 9);
INSERT INTO `seminarStudent` VALUES (7, 10);
INSERT INTO `seminarStudent` VALUES (9, 1);
INSERT INTO `seminarStudent` VALUES (9, 5);
INSERT INTO `seminarStudent` VALUES (9, 8);
INSERT INTO `seminarStudent` VALUES (9, 10);
INSERT INTO `seminarStudent` VALUES (10, 1);

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

-- 
-- Table structure for table `student`
-- 

DROP TABLE IF EXISTS `student`;
CREATE TABLE IF NOT EXISTS `student` (
  `studentID` int(11) NOT NULL auto_increment,
  `lastName` varchar(50) default NULL,
  `fname` varchar(50) default NULL,
  PRIMARY KEY  (`studentID`)
) TYPE=MyISAM AUTO_INCREMENT=11 ;

-- 
-- Dumping data for table `student`
-- 

INSERT INTO `student` VALUES (1, 'Smith', 'John');
INSERT INTO `student` VALUES (2, 'Doe', 'Jane');
INSERT INTO `student` VALUES (3, 'Lake', 'Sharon');
INSERT INTO `student` VALUES (4, 'Chang', 'Solomon');
INSERT INTO `student` VALUES (5, 'Wyrick', 'Ken');
INSERT INTO `student` VALUES (6, 'Glasser', 'Steve');
INSERT INTO `student` VALUES (7, 'Dow', 'Christina');
INSERT INTO `student` VALUES (8, 'Washington', 'George');
INSERT INTO `student` VALUES (9, 'Manny', 'Moe');
INSERT INTO `student` VALUES (10, 'Ryan', 'Jane');

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

-- 
-- Table structure for table `studentAddress`
-- 

DROP TABLE IF EXISTS `studentAddress`;
CREATE TABLE IF NOT EXISTS `studentAddress` (
  `addressID` int(11) NOT NULL auto_increment,
  `studentID` int(11) NOT NULL default '0',
  `addressTypeID` int(11) NOT NULL default '0',
  `address` varchar(100) default NULL,
  `city` varchar(50) default NULL,
  `state` char(2) default NULL,
  `zip` varchar(10) default NULL,
  PRIMARY KEY  (`addressID`),
  KEY `studentID` (`studentID`,`addressTypeID`)
) TYPE=MyISAM AUTO_INCREMENT=13 ;

-- 
-- Dumping data for table `studentAddress`
-- 

INSERT INTO `studentAddress` VALUES (1, 1, 1, '555 Main St.', 'Santa Monica', 'CA', '90010');
INSERT INTO `studentAddress` VALUES (2, 2, 1, 'P.O. Box 555', 'Los Angeles', 'CA', '90034');
INSERT INTO `studentAddress` VALUES (3, 2, 2, '555 Main Ave', 'Los Angeles', 'CA', '90028');
INSERT INTO `studentAddress` VALUES (4, 3, 1, 'Melrose and Fairfax', 'Los Angeles', 'CA', '90046');
INSERT INTO `studentAddress` VALUES (5, 4, 1, '444 Hoover Ave.', 'Los Angeles', 'CA', '90010');
INSERT INTO `studentAddress` VALUES (6, 4, 2, '567 Vermont Ave.', 'Hollywood', 'CA', '90028');
INSERT INTO `studentAddress` VALUES (7, 5, 1, '444 Hoover Ave.', 'Los Angeles', 'CA', '90010');
INSERT INTO `studentAddress` VALUES (8, 6, 1, '445566 Valley Street', 'Toluca Lake', 'CA', '90256');
INSERT INTO `studentAddress` VALUES (9, 7, 1, 'c/o Frank Smith 4567 Valley Vista Drive', 'Atwater', 'CA', '90045');
INSERT INTO `studentAddress` VALUES (10, 8, 1, '1600 Pensalvania Blvd', 'Washington', 'DC', '10001');
INSERT INTO `studentAddress` VALUES (11, 9, 1, '6789 Pico Blvd.', 'Beverly HIlls', 'CA', '90678');
INSERT INTO `studentAddress` VALUES (12, 10, 1, '4567 Beverly Blvd.', 'Los Angeles', 'CA', '90567');

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

-- 
-- Table structure for table `studentSSN`
-- 

DROP TABLE IF EXISTS `studentSSN`;
CREATE TABLE IF NOT EXISTS `studentSSN` (
  `studentID` int(11) NOT NULL default '0',
  `ssn` varchar(11) NOT NULL default '',
  PRIMARY KEY  (`studentID`),
  UNIQUE KEY `ssn` (`ssn`)
) TYPE=MyISAM;

-- 
-- Dumping data for table `studentSSN`
-- 

INSERT INTO `studentSSN` VALUES (1, '555-55-5555');
INSERT INTO `studentSSN` VALUES (2, '222-22-2222');
INSERT INTO `studentSSN` VALUES (3, '111-11-1111');
INSERT INTO `studentSSN` VALUES (4, '333-33-3333');
INSERT INTO `studentSSN` VALUES (5, '444-44-4444');
INSERT INTO `studentSSN` VALUES (6, '777-77-7777');
INSERT INTO `studentSSN` VALUES (7, '222-33-3333');
INSERT INTO `studentSSN` VALUES (9, '888-88-8888');
INSERT INTO `studentSSN` VALUES (10, '999-88-777');