shop.sql
上传用户:flow_meter
上传日期:2022-03-21
资源大小:40k
文件大小:10k
- -- MySQL dump 10.13 Distrib 5.1.26-rc, for Win32 (ia32)
- --
- -- Host: localhost Database: shop
- -- ------------------------------------------------------
- -- Server version 5.1.26-rc-community
- /*!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_id` int(8) NOT NULL DEFAULT '0',
- `customer_name` char(30) DEFAULT NULL,
- `customer_address` char(50) DEFAULT NULL,
- `customer_call` char(20) DEFAULT NULL,
- `customer_mail` char(30) DEFAULT NULL,
- `customer_register` datetime DEFAULT NULL,
- PRIMARY KEY (`customer_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- 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 (1,'李四','广州','020-020','shop@yahoo.com.cn','2008-10-26 00:00:00');
- /*!40000 ALTER TABLE `customer` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `fitting`
- --
- DROP TABLE IF EXISTS `fitting`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `fitting` (
- `produce_id` int(8) NOT NULL,
- `parent_produce_id` int(8) DEFAULT NULL,
- PRIMARY KEY (`produce_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `fitting`
- --
- LOCK TABLES `fitting` WRITE;
- /*!40000 ALTER TABLE `fitting` DISABLE KEYS */;
- INSERT INTO `fitting` VALUES (1,0),(2,1),(3,1),(4,2);
- /*!40000 ALTER TABLE `fitting` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `newtemp`
- --
- DROP TABLE IF EXISTS `newtemp`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `newtemp` (
- `id` int(8) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `newtemp`
- --
- LOCK TABLES `newtemp` WRITE;
- /*!40000 ALTER TABLE `newtemp` DISABLE KEYS */;
- /*!40000 ALTER TABLE `newtemp` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `produce`
- --
- DROP TABLE IF EXISTS `produce`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `produce` (
- `produce_id` int(8) NOT NULL AUTO_INCREMENT,
- `produce_name` char(30) DEFAULT NULL,
- `produce_funtion` char(200) DEFAULT NULL,
- `produce_price` double DEFAULT NULL,
- `produce_sort` char(30) DEFAULT NULL,
- `producer_id` int(8) DEFAULT NULL,
- PRIMARY KEY (`produce_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `produce`
- --
- LOCK TABLES `produce` WRITE;
- /*!40000 ALTER TABLE `produce` DISABLE KEYS */;
- INSERT INTO `produce` VALUES (1,'联想笔记本','处理器类型:Core 2 Duo T8100标称主频(MHz):2100n标准内存容量(MB):2048硬盘容量:160GB',9500,'IT产品',1),(2,' Intel pentium D 805(盒)','cpu',670,'IT',1);
- /*!40000 ALTER TABLE `produce` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `producer`
- --
- DROP TABLE IF EXISTS `producer`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `producer` (
- `producer_id` int(8) NOT NULL AUTO_INCREMENT,
- `producer_name` char(30) NOT NULL,
- `producer_address` char(50) DEFAULT NULL,
- `producer_call` char(20) DEFAULT NULL,
- `producer_describe` char(200) DEFAULT NULL,
- PRIMARY KEY (`producer_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `producer`
- --
- LOCK TABLES `producer` WRITE;
- /*!40000 ALTER TABLE `producer` DISABLE KEYS */;
- INSERT INTO `producer` VALUES (1,'联想集团','中国北京','020-020','信息产业领域内多元化发展的大型企业');
- /*!40000 ALTER TABLE `producer` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `repair`
- --
- DROP TABLE IF EXISTS `repair`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `repair` (
- `repair_id` int(8) NOT NULL AUTO_INCREMENT,
- `repair_customer_id` int(8) DEFAULT NULL,
- `repair_produce_id` int(8) DEFAULT NULL,
- `repair_repair_shop_id` int(8) DEFAULT NULL,
- `repair_time` datetime DEFAULT NULL,
- `repair_information` char(200) DEFAULT NULL,
- PRIMARY KEY (`repair_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `repair`
- --
- LOCK TABLES `repair` WRITE;
- /*!40000 ALTER TABLE `repair` DISABLE KEYS */;
- INSERT INTO `repair` VALUES (1,1,1,1,'2008-10-10 00:00:00','电源故障');
- /*!40000 ALTER TABLE `repair` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `repair_shop`
- --
- DROP TABLE IF EXISTS `repair_shop`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `repair_shop` (
- `repair_shop_id` int(8) NOT NULL AUTO_INCREMENT,
- `repair_shop_name` char(30) NOT NULL,
- `repair_shop_address` char(50) DEFAULT NULL,
- `repair_shop_keeper` char(30) DEFAULT NULL,
- `repair_shop_call` char(20) DEFAULT NULL,
- PRIMARY KEY (`repair_shop_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `repair_shop`
- --
- LOCK TABLES `repair_shop` WRITE;
- /*!40000 ALTER TABLE `repair_shop` DISABLE KEYS */;
- INSERT INTO `repair_shop` VALUES (1,'联想电脑维修点','南京市','王五','111-111');
- /*!40000 ALTER TABLE `repair_shop` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `result`
- --
- DROP TABLE IF EXISTS `result`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `result` (
- `id` int(8) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `result`
- --
- LOCK TABLES `result` WRITE;
- /*!40000 ALTER TABLE `result` DISABLE KEYS */;
- INSERT INTO `result` VALUES (1),(2),(3),(4);
- /*!40000 ALTER TABLE `result` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `sell`
- --
- DROP TABLE IF EXISTS `sell`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `sell` (
- `sell_id` int(8) NOT NULL AUTO_INCREMENT,
- `sell_store_id` int(8) DEFAULT NULL,
- `sell_produce_id` int(8) DEFAULT NULL,
- `sell_customer_id` int(8) DEFAULT NULL,
- `sell_amount` int(8) DEFAULT NULL,
- `sell_time` datetime DEFAULT NULL,
- PRIMARY KEY (`sell_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `sell`
- --
- LOCK TABLES `sell` WRITE;
- /*!40000 ALTER TABLE `sell` DISABLE KEYS */;
- INSERT INTO `sell` VALUES (1,1,1,1,2,'2008-10-27 00:00:00');
- /*!40000 ALTER TABLE `sell` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `store`
- --
- DROP TABLE IF EXISTS `store`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `store` (
- `store_id` int(8) NOT NULL AUTO_INCREMENT,
- `store_name` char(50) DEFAULT NULL,
- `store_address` char(50) DEFAULT NULL,
- `store_keeper` char(30) DEFAULT NULL,
- `store_call` char(20) DEFAULT NULL,
- PRIMARY KEY (`store_id`)
- ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `store`
- --
- LOCK TABLES `store` WRITE;
- /*!40000 ALTER TABLE `store` DISABLE KEYS */;
- INSERT INTO `store` VALUES (1,'南京联想电脑专卖店','南京','张三','010-010');
- /*!40000 ALTER TABLE `store` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `temp`
- --
- DROP TABLE IF EXISTS `temp`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `temp` (
- `id` int(8) DEFAULT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `temp`
- --
- LOCK TABLES `temp` WRITE;
- /*!40000 ALTER TABLE `temp` DISABLE KEYS */;
- /*!40000 ALTER TABLE `temp` ENABLE KEYS */;
- UNLOCK TABLES;
- --
- -- Table structure for table `user`
- --
- DROP TABLE IF EXISTS `user`;
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE `user` (
- `user_id` char(20) NOT NULL DEFAULT '',
- `user_password` char(20) DEFAULT NULL,
- `user_level` int(11) DEFAULT NULL,
- PRIMARY KEY (`user_id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
- SET character_set_client = @saved_cs_client;
- --
- -- Dumping data for table `user`
- --
- LOCK TABLES `user` WRITE;
- /*!40000 ALTER TABLE `user` DISABLE KEYS */;
- INSERT INTO `user` VALUES ('2006','guo',0),('root','root',1);
- /*!40000 ALTER TABLE `user` 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 9:50:41