bargaining.sql

一个数据库的应用实例.....主用功能是一些常用的数据库操作和电子邮件的发送！

-- MySQL dump 10.11
--
-- Host: localhost    Database: bargaining
-- ------------------------------------------------------
-- Server version	5.0.67-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 */;

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `customer` (
  `customer_name` char(30) NOT NULL default '',
  `phone_number` char(15) default NULL,
  `E_mail` char(50) NOT NULL,
  PRIMARY KEY  (`customer_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES ('mjb','11111111111','[e-mail]'),('wjz','22222222222','[e-mail]');
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `manufacturer`
--

DROP TABLE IF EXISTS `manufacturer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `manufacturer` (
  `factory_name` char(30) NOT NULL default '',
  `phone_number` char(15) default NULL,
  `city` char(50) NOT NULL,
  PRIMARY KEY  (`factory_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `manufacturer`
--

LOCK TABLES `manufacturer` WRITE;
/*!40000 ALTER TABLE `manufacturer` DISABLE KEYS */;
INSERT INTO `manufacturer` VALUES ('guangqichang','11111111111','guangzhou'),('shenqichang','22222222222','shenzhen');
/*!40000 ALTER TABLE `manufacturer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `product` (
  `fitment_name` char(30) NOT NULL,
  `product_name` char(30) NOT NULL,
  `shelf_life` char(10) NOT NULL,
  `factory_name` char(30) NOT NULL,
  `customer_name` char(30) NOT NULL,
  `time` date NOT NULL,
  PRIMARY KEY  (`fitment_name`,`product_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES ('rubber_a','tyre_a','100','guangqichang','wjz','2007-11-03'),('rubber_b','tyre_b','1','shenqichang','mjb','2008-11-08'),('tyre_a','flange','100','guangqichang','wjz','2007-11-03'),('tyre_b','pedicab','1','shenqichang','mjb','2008-11-08');
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `repairer`
--

DROP TABLE IF EXISTS `repairer`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `repairer` (
  `repairer_name` char(30) NOT NULL,
  `product_name` char(30) NOT NULL,
  `factory_name` char(30) NOT NULL,
  `repair_time` char(3) default NULL,
  PRIMARY KEY  (`repairer_name`,`product_name`),
  KEY `factory_name` (`factory_name`),
  CONSTRAINT `repairer_ibfk_1` FOREIGN KEY (`factory_name`) REFERENCES `manufacturer` (`factory_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `repairer`
--

LOCK TABLES `repairer` WRITE;
/*!40000 ALTER TABLE `repairer` DISABLE KEYS */;
INSERT INTO `repairer` VALUES ('repairer_a','flange','guangqichang','0'),('repairer_a','rubber_a','guangqichang','0'),('repairer_a','tyre_a','guangqichang','0'),('repairer_b','pedicab','shenqichang','100'),('repairer_b','rubber_b','shenqichang','100'),('repairer_b','tyre_b','shenqichang','100');
/*!40000 ALTER TABLE `repairer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seller`
--

DROP TABLE IF EXISTS `seller`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `seller` (
  `seller_name` char(30) NOT NULL,
  `product_name` char(30) NOT NULL,
  `customer_name` char(30) NOT NULL,
  PRIMARY KEY  (`seller_name`,`product_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `seller`
--

LOCK TABLES `seller` WRITE;
/*!40000 ALTER TABLE `seller` DISABLE KEYS */;
INSERT INTO `seller` VALUES ('seller_a','flange','wjz'),('seller_a','rubber_a','wjz'),('seller_a','tyre_a','wjz'),('seller_b','pedicab','mjb'),('seller_b','rubber_b','mjb'),('seller_b','tyre_b','mjb');
/*!40000 ALTER TABLE `seller` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempa`
--

DROP TABLE IF EXISTS `tempa`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tempa` (
  `part_name` char(30) NOT NULL default '',
  `f_name` char(30) NOT NULL,
  PRIMARY KEY  (`part_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tempa`
--

LOCK TABLES `tempa` WRITE;
/*!40000 ALTER TABLE `tempa` DISABLE KEYS */;
/*!40000 ALTER TABLE `tempa` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempb`
--

DROP TABLE IF EXISTS `tempb`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tempb` (
  `part_name` char(30) NOT NULL default '',
  `f_name` char(30) NOT NULL,
  PRIMARY KEY  (`part_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tempb`
--

LOCK TABLES `tempb` WRITE;
/*!40000 ALTER TABLE `tempb` DISABLE KEYS */;
INSERT INTO `tempb` VALUES ('rubber_a','guangqichang'),('tyre_a','guangqichang');
/*!40000 ALTER TABLE `tempb` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempc`
--

DROP TABLE IF EXISTS `tempc`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tempc` (
  `part_name` char(30) NOT NULL default '',
  `f_name` char(30) NOT NULL,
  PRIMARY KEY  (`part_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tempc`
--

LOCK TABLES `tempc` WRITE;
/*!40000 ALTER TABLE `tempc` DISABLE KEYS */;
/*!40000 ALTER TABLE `tempc` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tempd`
--

DROP TABLE IF EXISTS `tempd`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `tempd` (
  `part_name` char(30) NOT NULL default '',
  `f_name` char(30) NOT NULL,
  PRIMARY KEY  (`part_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
SET character_set_client = @saved_cs_client;

--
-- Dumping data for table `tempd`
--

LOCK TABLES `tempd` WRITE;
/*!40000 ALTER TABLE `tempd` DISABLE KEYS */;
INSERT INTO `tempd` VALUES ('rubber_a','guangqichang'),('tyre_a','guangqichang');
/*!40000 ALTER TABLE `tempd` 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 2008-11-10  1:33:03