-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version 5.1.12-beta-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 */;
/*!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' */;
--
-- Create schema zc_db
--
CREATE DATABASE IF NOT EXISTS zc_db;
USE zc_db;
--
-- Definition of table `comployee`
--
DROP TABLE IF EXISTS `comployee`;
CREATE TABLE `comployee` (
`comployee_no` varchar(30) NOT NULL,
`comployee_name` varchar(25) NOT NULL,
`sex` varchar(5) NOT NULL,
`age` int(10) unsigned NOT NULL,
`dept` varchar(45) NOT NULL,
`profession` varchar(20) NOT NULL,
`address` varchar(60) NOT NULL,
`phone` varchar(20) NOT NULL,
`comployee_status` varchar(10) NOT NULL,
PRIMARY KEY (`comployee_no`),
KEY `fk_comployee_dept` (`dept`),
CONSTRAINT `fk_comployee_dept` FOREIGN KEY (`dept`) REFERENCES `department` (`dept`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `comployee`
--
/*!40000 ALTER TABLE `comployee` DISABLE KEYS */;
INSERT INTO `comployee` (`comployee_no`,`comployee_name`,`sex`,`age`,`dept`,`profession`,`address`,`phone`,`comployee_status`) VALUES
('0001','于谦','男',28,'保安部','职员','上海','13236489654','在职'),
('0002','李明','男',32,'保安部','处长','上海','13164987452','在职'),
('0003','张刚','男',22,'设备管理部','职员','上海','13112546985','休假'),
('0004','王利','男',26,'外贸部','职员','上海','13569845215','在职'),
('0005','王霞','女',33,'总务处','职员','上海','135649852487','休假'),
('1000','www','男',24,'设备管理部','处长','上海','13265412365','在职'),
('2000','xxx','男',24,'总务处','处长','上海','13569845215','休假'),
('3000','yyy','女',24,'设备管理部','职员','上海','13965445665','在职');
/*!40000 ALTER TABLE `comployee` ENABLE KEYS */;
--
-- Definition of table `department`
--
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
`dept` varchar(45) NOT NULL,
PRIMARY KEY (`dept`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `department`
--
/*!40000 ALTER TABLE `department` DISABLE KEYS */;
INSERT INTO `department` (`dept`) VALUES
('保安部'),
('科技组'),
('人力资源部'),
('设备管理部'),
('外贸部'),
('总务处');
/*!40000 ALTER TABLE `department` ENABLE KEYS */;
--
-- Definition of table `user_info`
--
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`userName` varchar(30) NOT NULL,
`pwd` varchar(100) NOT NULL,
`comployee_no` varchar(30) NOT NULL,
`competence` varchar(15) NOT NULL,
PRIMARY KEY (`userName`),
KEY `fk_userinfo_comployee` (`comployee_no`),
CONSTRAINT `fk_userinfo_comployee` FOREIGN KEY (`comployee_no`) REFERENCES `comployee` (`comployee_no`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `user_info`
--
/*!40000 ALTER TABLE `user_info` DISABLE KEYS */;
INSERT INTO `user_info` (`userName`,`pwd`,`comployee_no`,`competence`) VALUES
('niuys','niuys','1000','管理员'),
('于谦','yuqian','0001','管理员'),
('xxx','x','2000','管理员'),
('yyy','yyy','3000','操作员');
/*!40000 ALTER TABLE `user_info` ENABLE KEYS */;
--
-- Definition of table `zc_info`
--
DROP TABLE IF EXISTS `zc_info`;
CREATE TABLE `zc_info` (
`zc_id` varchar(30) NOT NULL,
`zc_no` varchar(30) NOT NULL,
`zc_name` varchar(50) NOT NULL,
`zc_price` float NOT NULL,
`zc_factory` varchar(50) NOT NULL,
`zc_produceTime` varchar(20) NOT NULL DEFAULT '2008-01-01',
`zc_buyTime` varchar(20) NOT NULL DEFAULT '2008-01-01',
`zc_buyer` varchar(15) NOT NULL,
`zc_type` varchar(20) NOT NULL,
`zc_status` varchar(15) NOT NULL,
`zc_bzxx` varchar(255) DEFAULT NULL,
PRIMARY KEY (`zc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `zc_info`
--
/*!40000 ALTER TABLE `zc_info` DISABLE KEYS */;
INSERT INTO `zc_info` (`zc_id`,`zc_no`,`zc_name`,`zc_price`,`zc_factory`,`zc_produceTime`,`zc_buyTime`,`zc_buyer`,`zc_type`,`zc_status`,`zc_bzxx`) VALUES
('C2KS@_1','C2KS','山特UPS电源',5320,'山特','2007-12-09','2008-08-13','Sonic','拓展配件','维修',''),
('C2KS@_4','C2KS','山特UPS电源',5320,'山特','2007-12-09','2008-08-13','Sonic','笔记本','正常',''),
('kk300@_1','kk300','卡巴斯基7.0',100,'HR_gd','1990-04-07','2008-08-15','Rose','电脑软件','正常',NULL),
('kk300@_2','kk300','卡巴斯基7.0',100,'HR_gd','1990-04-07','2008-08-15','Rose','服务器','维修',NULL),
('KLV-40V380A@_5','KLV-40V380A','索尼液晶电视',8490,'索尼','2008-07-25','2008-08-15','John','数码配件','正常',NULL),
('t300@_3','t300','卡巴斯基6.0',100,'HR','1990-04-08','2008-08-15','Sonic','服务器','正常',NULL),
('T300@_4','T300','索尼数码照相机',2500,'索尼','2008-08-05','2008-08-13','David','数码产品','正常',NULL),
('T300@_5','T300','索尼数码照相机',2500,'索尼','2008-08-05','2008-08-13','David','数码产品','借出',NULL),
('V3906TX@_6','V3906TX','惠普 Compaq Presario',5700,'惠普','2008-07-04','2008-08-15','Sonic','笔记本','报废',NULL),
('V3906TX@_7','V3906TX','惠普 Compaq Presario',5700,'惠普','2008-07-04','2008-08-15','Sonic','笔记本','维修',NULL),
('V3906TX@_8','V3906TX','惠普 Compaq Presario',5700,'惠普','2008-07-04','2008-08-15','Sonic','笔记本','正常',NULL);
/*!40000 ALTER TABLE `zc_info` ENABLE KEYS */;
--
-- Definition of table `zc_inout`
--
DROP TABLE IF EXISTS `zc_inout`;
CREATE TABLE `zc_inout` (
`inout_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
`zc_id` varchar(30) NOT NULL,
`comployee_no` varchar(30) NOT NULL,
`out_time` varchar(20) NOT NULL,
`should_time` varchar(20) NOT NULL,
`back_time` varchar(20) DEFAULT NULL,
PRIMARY KEY (`inout_no`),
KEY `fk_zcinfo_zcinout` (`zc_id`),
CONSTRAINT `FK_zc_inout_1` FOREIGN KEY (`zc_id`) REFERENCES `zc_info` (`zc_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
--
-- Dumping data for table `zc_inout`
--
/*!40000 ALTER TABLE `zc_inout` DISABLE KEYS */;
INSERT INTO `zc_inout` (`inout_no`,`zc_id`,`comployee_no`,`out_time`,`should_time`,`back_time`) VALUES
(3,'C2KS@_1','0002','2008-08-14','2008-09-14','2008-08-14'),
(4,'C2KS@_4','0001','2008-08-14','2008-09-14','2010-04-08'),
(6,'kk300@_1','0002','2008-08-14','2008-09-14','2008-08-14'),
(7,'kk300@_2','0002','2008-08-14','2008-09-14','2008-08-14'),
(8,'KLV-40V380A@_5','0001','2008-08-14','2008-09-14','2008-08-14'),
(9,'KLV-40V380A@_5','0001','2008-08-14','2008-09-14','2008-08-14'),
(11,'t300@_3','0002','2008-08-14','2008-09-14','2008-08-15'),
(12,'C2KS@_1','0005','2008-08-14','2008-09-14','2010-04-08'),
(13,'T300@_4','0002','2008-08-15','2008-09-15','2010-04-08'),
(14,'T300@_5','0003','2008-08-15','2008-11-15',''),
(15,'V3906TX@_6','0002','2008-08-15','2008-09-15',''),
(16,'V3906TX@_7','0001','2008-08-15','2008-1015',''),
(17,'C2KS@_1 ','1000','2010-04-11','2010-6-11',NULL);
/*!40000 ALTER TABLE `zc_inout` ENABLE KEYS */;
--
-- Definition of table `zc_wx`
--
DROP TABLE IF EXISTS `zc_wx`;
CREATE TABLE `zc_wx` (
`repair_no` int(10) unsigned NOT NULL AUTO_INCREMENT,
`zc_id` varchar(30) NOT NULL,
`send_time` varchar(30) NOT NULL,
`sender` varchar(50) NOT NULL,
`login_user` varchar(50) NOT NULL,
`reason` varchar(50) DEFAULT NULL,
`wx_time` varchar(30) DEFAULT NULL,
`wx_result` varchar(45) DEFAULT NULL,
`cost` float DEFAULT NULL,
`wx_comment` varchar(45) DEFAULT NULL,
PRIMARY KEY (`repair_no`),
KEY `fk_zcinfo_zcwx` (`zc_id`),
CONSTRAINT `fk_zcinfo_zcwx` FOREIGN KEY (`zc_id`) REFERENCES `zc_info` (`zc_id`)
) ENGINE=InnoDB DEFAULT CHARSET