DONATE:MySQL Dump version2

From Openitware
Jump to: navigation, search
-- -- MySQL dump 10.13  Distrib 5.1.41, for Win32 (ia32)
--
-- Host: localhost    Database: donate
-- ------------------------------------------------------
-- Server version	5.1.41
 
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 
--
-- Table structure for table `donation`
--
 
DROP TABLE IF EXISTS `donation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `donation` (
  `donationID` int(11) NOT NULL AUTO_INCREMENT,
  `donorID` int(11) DEFAULT NULL,
  `donationDate` date NOT NULL,
  `eventID` int(11) DEFAULT NULL,
  PRIMARY KEY (`donationID`),
  KEY `donorID` (`donorID`),
  KEY `eventID` (`eventID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `donation`
--
 
LOCK TABLES `donation` WRITE;
/*!40000 ALTER TABLE `donation` DISABLE KEYS */;
INSERT INTO `donation` VALUES (1,1,'2010-12-03',3),(2,2,'2010-12-03',2),(3,3,'2010-12-03',1),(4,4,'2010-12-03',1),(5,5,'2010-12-03',4),(6,6,'2010-12-03',2),(7,7,'2010-12-03',3),(8,8,'2010-12-03',1),(9,9,'2010-12-03',4);
/*!40000 ALTER TABLE `donation` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `donor`
--
 
DROP TABLE IF EXISTS `donor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `donor` (
  `donorID` int(11) NOT NULL AUTO_INCREMENT,
  `street` varchar(25) DEFAULT NULL,
  `city` varchar(15) DEFAULT NULL,
  `state` varchar(2) DEFAULT NULL,
  `zip` varchar(13) DEFAULT NULL,
  `phone` varchar(13) DEFAULT NULL,
  `fax` varchar(13) DEFAULT NULL,
  `email` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`donorID`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `donor`
--
 
LOCK TABLES `donor` WRITE;
/*!40000 ALTER TABLE `donor` DISABLE KEYS */;
INSERT INTO `donor` VALUES (1,'a','b','c','d','e','f','g'),(2,'22 Caliber Drive','Somewhere','NH','12345','603-555-1111','603-555-1112','person@place.com'),(3,'1600 Penn. Ave.','Whocares','ME','78201','603-555-2222','603-555-2232','important@person.com'),(4,'1 Am Right','Behind You','MA','71891','603-555-3333','603-555-3334','sneaky@person.com'),(5,'123 Home Street','Niceville','NJ','93846','133-555-9999','133-555-9998','MrNiceGuy@howdy.com'),(6,'321 Bling Street','Krunktown','MI','73628','434-555-8882','434-555-8889','rapstar@rhythm.com'),(7,'45 South Willow Street','Manchester','NH','03101','603-672-3336','603-672-3337','store@calm.com'),(8,'2 Robin Hood Lane','Sherwood','ME','12321','884-867-5309','884-867-5310','industry@work.com'),(9,'87 Loco Drive','Winchesterton','IA','98765','576-342-8987','576-342-8986','busypeople@work.com');
/*!40000 ALTER TABLE `donor` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `event`
--
 
DROP TABLE IF EXISTS `event`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `event` (
  `eventID` int(11) NOT NULL AUTO_INCREMENT,
  `eventName` varchar(50) NOT NULL,
  `eventDate` date DEFAULT NULL,
  `street` varchar(25) DEFAULT NULL,
  `city` varchar(15) DEFAULT NULL,
  `state` varchar(2) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`eventID`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `event`
--
 
LOCK TABLES `event` WRITE;
/*!40000 ALTER TABLE `event` DISABLE KEYS */;
INSERT INTO `event` VALUES (1,'Renaissance Festival','2010-12-03','65 Pleasant Blvd.','Awesometown','NJ','72819'),(2,'Star Trek Convention','2010-12-03','267 Ash Street','Milford','MD','28374'),(3,'4th of July BBQ','2010-12-03','52 Runner Road','Mooseland','NV','28823'),(4,'Fashion Show','2010-12-03','36 Rust Road','Quincy','AL','83838');
/*!40000 ALTER TABLE `event` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `individual`
--
 
DROP TABLE IF EXISTS `individual`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `individual` (
  `donorID` int(11) NOT NULL,
  `firstName` varchar(20) DEFAULT NULL,
  `lastName` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`donorID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `individual`
--
 
LOCK TABLES `individual` WRITE;
/*!40000 ALTER TABLE `individual` DISABLE KEYS */;
INSERT INTO `individual` VALUES (1,'Jones','Bob'),(2,'Trautman','Gregg'),(3,'Gevraldi','Tony'),(4,'Becker','John'),(5,'Deere','Charles');
/*!40000 ALTER TABLE `individual` ENABLE KEYS */;
UNLOCK TABLES;
 
--
-- Table structure for table `organization`
--
 
DROP TABLE IF EXISTS `organization`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `organization` (
  `donorID` int(11) NOT NULL,
  `organizationName` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`donorID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
 
--
-- Dumping data for table `organization`
--
 
LOCK TABLES `organization` WRITE;
/*!40000 ALTER TABLE `organization` DISABLE KEYS */;
INSERT INTO `organization` VALUES (7,'Awesome Stuff LLC.'),(8,'Big Deal'),(9,'People Eating Tasty Animals');
/*!40000 ALTER TABLE `organization` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 
-- Dump completed on 2010-12-03 14:57:26