# File name: C:\Documents and Settings\Joe Tinker\My Documents\PC Clients\RU CME\Crab-Jon\lss.sql
# Creation date: 12/10/2007
# Created by Access to MySQL Pro 3.3 
# --------------------------------------------------
# More conversion tools at http://www.convert-in.com

#
# Table structure for table 'Lss'
#

DROP TABLE IF EXISTS `Lss`;
CREATE TABLE `Lss` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `First_Name` VARCHAR(50),
  `Last_Name` VARCHAR(50),
  `Offering` VARCHAR(50),
  `Date` CHAR(19),
  `E_mail` VARCHAR(50),
  `Phone` VARCHAR(50),
  `Company` VARCHAR(50),
  `US_Citizen` TINYINT,
  `Citizenship` VARCHAR(50),
  INDEX `id` (`id`),
  PRIMARY KEY (`id`)
) TYPE=InnoDB;

#
# Dumping data for table 'Lss'
#

INSERT INTO `Lss` VALUES(1, 'Bette', 'Farber', 'GB', '2008-01-14', 'bette.farber@lmco.com', '856-999-1234', 'Lockheed Martin', -1, "");
INSERT INTO `Lss` VALUES(2, 'Ray', 'Compari', 'GB', '2008-01-14', 'rcompari@camden.rutgers.edu', '856-225-1111', 'Rutgers U.', -1, "");
INSERT INTO `Lss` VALUES(3, 'John', 'Busca', 'BB', '2008-05-15', 'john.busca@lmco.com', '856-888-7676', 'Lockheed Martin', -1, "");
INSERT INTO `Lss` VALUES(4, 'Jonathan', 'Lane', 'BB', '2008-05-15', 'jonlane@camden.rutgers.edu', '856-555-1212', 'Campbells Soup', 0, 'Bulgaria');
ALTER TABLE `Lss` CHANGE `Date` `Date` DATE;

#
# Table structure for table 'Lss2'
#

DROP TABLE IF EXISTS `Lss2`;
CREATE TABLE `Lss2` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `First_Name` VARCHAR(50),
  `Last_Name` VARCHAR(50),
  `Offering` VARCHAR(50),
  `Date` CHAR(19),
  `E_mail` VARCHAR(50),
  `Phone` VARCHAR(50),
  `Company` VARCHAR(50),
  `US_Citizen` TINYINT,
  `Citizenship` VARCHAR(50),
  `RutgersMBA` TINYINT,
  `WDP` TINYINT,
  INDEX `id` (`id`),
  PRIMARY KEY (`id`)
) TYPE=InnoDB;

#
# Dumping data for table 'Lss2'
#

INSERT INTO `Lss2` VALUES(1, 'Bette', 'Farber', 'GB', '2008-01-14', 'bette.farber@lmco.com', '856-999-1234', 'Lockheed Martin', -1, "", 0, 0);
INSERT INTO `Lss2` VALUES(2, 'Ray', 'Compari', 'GB', '2008-01-14', 'rcompari@camden.rutgers.edu', '856-225-1111', 'Rutgers U.', -1, "", 0, 0);
INSERT INTO `Lss2` VALUES(3, 'John', 'Busca', 'BB', '2008-05-15', 'john.busca@lmco.com', '856-888-7676', 'Lockheed Martin', -1, "", 0, 0);
INSERT INTO `Lss2` VALUES(4, 'Jonathan', 'Lane', 'BB', '2008-05-15', 'jonlane@camden.rutgers.edu', '856-555-1212', 'Campbells Soup', 0, 'Bulgaria', 0, 0);
INSERT INTO `Lss2` VALUES(5, 'Bill', 'Reynolds', 'GB', '2008-02-08', 'wwr@camden.rutgers.edu', '856-225-6987', 'RCTC', 0, 'Haddonfield', -1, 0);
INSERT INTO `Lss2` VALUES(6, 'Joanne', 'Stevenson', 'BB', '2008-11-10', 'jms@camden.rutgers.edu', '856-225-6666', 'IMED', -1, "", 0, -1);
ALTER TABLE `Lss2` CHANGE `Date` `Date` DATE;

