-- MySQL dump 10.10
--
-- Host: localhost    Database: cap
-- ------------------------------------------------------
-- Server version	5.0.27-community-nt

/*!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 */;

--
-- Current Database: `cap`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `cap` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `cap`;

--
-- Table structure for table `agents`
--

DROP TABLE IF EXISTS `agents`;
CREATE TABLE `agents` (
  `aid` char(3) NOT NULL,
  `aname` varchar(20) default NULL,
  `city` varchar(20) default NULL,
  `percent` int(11) default NULL,
  PRIMARY KEY  (`aid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `agents`
--

LOCK TABLES `agents` WRITE;
/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
INSERT INTO `agents` VALUES ('a01','Smith','New York',6),('a02','Jones','Newark',6),('a03','Brown','Tokyo',7),('a04','Gray','New York',6),('a05','Otasi','Duluth',5),('a06','Smith','Dallas',5);
/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
CREATE TABLE `customers` (
  `cid` char(4) NOT NULL,
  `cname` varchar(20) default NULL,
  `city` varchar(20) default NULL,
  `discnt` double default NULL,
  PRIMARY KEY  (`cid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
INSERT INTO `customers` VALUES ('c001','Tiptop','Duluth',10),('c002','Basics','Dallas',12),('c003','Allied','Dallas',8),('c004','ACME','Duluth',8),('c006','ACME','Kyoto',0);
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `ordno` int(11) NOT NULL,
  `month` char(3) default NULL,
  `cid` char(4) default NULL,
  `aid` char(3) default NULL,
  `pid` char(3) default NULL,
  `qty` int(11) default NULL,
  `dollars` decimal(20,2) default NULL,
  PRIMARY KEY  (`ordno`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
INSERT INTO `orders` VALUES (1011,'jan','c001','a01','p01',1000,'450.00'),(1012,'jan','c001','a01','p01',1000,'450.00'),(1019,'feb','c001','a02','p02',400,'180.00'),(1017,'feb','c001','a06','p03',600,'540.00'),(1018,'feb','c001','a03','p04',600,'540.00'),(1023,'mar','c001','a04','p05',500,'450.00'),(1022,'mar','c001','a05','p06',400,'720.00'),(1025,'apr','c001','a05','p07',800,'720.00'),(1013,'jan','c002','a03','p03',1000,'880.00'),(1026,'may','c002','a05','p03',800,'704.00'),(1015,'jan','c003','a03','p05',1200,'1104.00'),(1014,'jan','c003','a03','p05',1200,'1104.00'),(1021,'feb','c004','a06','p01',1000,'460.00'),(1016,'jan','c006','a01','p01',1000,'500.00'),(1020,'feb','c006','a03','p07',600,'600.00'),(1024,'mar','c006','a06','p01',800,'400.00');
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `pid` char(3) NOT NULL,
  `pname` varchar(20) default NULL,
  `city` varchar(20) default NULL,
  `quantity` int(11) default NULL,
  `price` decimal(20,2) default NULL,
  PRIMARY KEY  (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES ('p01','comb','Dallas',111400,'0.50'),('p02','brush','Newark',203000,'0.50'),('p03','razor','Duluth',150600,'1.00'),('p04','pen','Duluth',125300,'1.00'),('p05','pencil','Dallas',221400,'1.00'),('p06','folder','Dallas',123100,'2.00'),('p07','case','Newark',100500,'1.00');
/*!40000 ALTER TABLE `products` 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 2007-03-12 20:03:29