logistic.sql

实现一个用JSP、Servlet技术实现的小型物流网站系统。实现功能如下：管理员通过登录该系统

  `SeatsName` varchar(20) NOT NULL COMMENT '商品位名称',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SeatsId` (`SeatsId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `goodsseatstable`
--

LOCK TABLES `goodsseatstable` WRITE;
/*!40000 ALTER TABLE `goodsseatstable` DISABLE KEYS */;
INSERT INTO `goodsseatstable` VALUES (1,'1001','一号'),(2,'1002','二号'),(3,'1003','三号'),(4,'1004','四号'),(5,'1005','五号'),(6,'1006','六号'),(7,'1007','七号'),(8,'1008','八号'),(9,'1009','九号'),(10,'1010','十号'),(11,'1011','十一号'),(12,'1012','十二号'),(13,'1013','十三号'),(14,'1014','十四号'),(15,'1015','十五号'),(16,'1016','十六号'),(17,'1017','十七号'),(18,'1018','十八号'),(19,'1019','十九号'),(20,'1020','二十号');
/*!40000 ALTER TABLE `goodsseatstable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobsinfotable`
--

DROP TABLE IF EXISTS `jobsinfotable`;
CREATE TABLE `jobsinfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '职务信息表自动ID',
  `JobsId` varchar(20) NOT NULL COMMENT '职务Id',
  `JobsName` varchar(20) NOT NULL COMMENT '职务名称',
  `DescribleJobs` varchar(50) default NULL COMMENT '职务描述',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `jobsinfotable`
--

LOCK TABLES `jobsinfotable` WRITE;
/*!40000 ALTER TABLE `jobsinfotable` DISABLE KEYS */;
INSERT INTO `jobsinfotable` VALUES (1,'1001','总经理','负责公司战略规划'),(2,'1002','副总经理','辅助总经历工作'),(3,'1003','工程师','技术研发和实施支持'),(4,'1004','技术员',''),(5,'1005','销售员',NULL),(6,'1006','采购员',NULL),(7,'1007','库管员',NULL),(8,'1008','储备干部',NULL),(9,'1009','售后服务员',NULL),(10,'1010','汽车司机',NULL),(11,'1011','清洁工','打扫卫生');
/*!40000 ALTER TABLE `jobsinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `logintable`
--

DROP TABLE IF EXISTS `logintable`;
CREATE TABLE `logintable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '登陆管理表自动ID',
  `LoginId` varchar(20) NOT NULL COMMENT '登陆职员编号Id',
  `LoginName` varchar(20) NOT NULL COMMENT '登陆职员姓名',
  `LoginPassword` varchar(20) NOT NULL COMMENT '登陆职员密码',
  `LoginPower` varchar(20) NOT NULL COMMENT '登陆职员权限',
  `EmployeeId` varchar(20) default NULL COMMENT '职员编号',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `LoginName` (`LoginName`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `logintable`
--

LOCK TABLES `logintable` WRITE;
/*!40000 ALTER TABLE `logintable` DISABLE KEYS */;
INSERT INTO `logintable` VALUES (1,'10001','陈凯','ckjava','admin','10005'),(2,'10002','张冠军','ckjava','admin','10006'),(3,'10003','程传林','1111','admin','10008'),(4,'10004','肖雷','1111','superadmin','10009');
/*!40000 ALTER TABLE `logintable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `messageinfotable`
--

DROP TABLE IF EXISTS `messageinfotable`;
CREATE TABLE `messageinfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '公告信息表自动ID',
  `MessageId` varchar(20) NOT NULL COMMENT '公告信息Id',
  `EmployeeId` varchar(20) NOT NULL COMMENT '发布公告的职员Id',
  `MessageTitle` varchar(50) NOT NULL COMMENT '公告标题',
  `MessageTime` varchar(20) NOT NULL COMMENT '公告发布时间',
  `MessageContent` varchar(500) NOT NULL COMMENT '公告内容',
  PRIMARY KEY  (`ID`),
  KEY `FK_messageinfotable_employee` (`EmployeeId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `messageinfotable`
--

LOCK TABLES `messageinfotable` WRITE;
/*!40000 ALTER TABLE `messageinfotable` DISABLE KEYS */;
INSERT INTO `messageinfotable` VALUES (3,'10001','10005','我昨天晚上到的家','2007-04-25 14:41:11','有什么事情给我打电话好了！'),(4,'10002','10006','我是老张，最近工作有点忙！','2007-04-25 14:50:06','天天维护服务器，过两天我回学校请大家吃饭！'),(5,'10003','10005','快五一了兄弟们准备去哪里玩呀？','2007-04-29 15:23:55','我现在一直在家呆着，看书做设计！');
/*!40000 ALTER TABLE `messageinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockininfotable`
--

DROP TABLE IF EXISTS `stockininfotable`;
CREATE TABLE `stockininfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '入库单信息表自动ID',
  `StockInId` varchar(20) NOT NULL COMMENT '入库单Id',
  `StockInDate` varchar(20) NOT NULL COMMENT '入库单生成时间',
  `ChargeId` varchar(20) NOT NULL COMMENT '负责人Id',
  `GoodsId` varchar(20) NOT NULL COMMENT '入库商品Id',
  `GoodsInNumber` int(8) NOT NULL COMMENT '商品入库量',
  `TypeId` varchar(20) NOT NULL COMMENT '入库商品型号Id',
  `CommodityId` varchar(20) NOT NULL COMMENT '入库商品分类Id',
  `GoodsInMemo` varchar(100) default NULL COMMENT '入库备注信息',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `StockInId` (`StockInId`),
  KEY `FK_stockininfotable` (`TypeId`),
  CONSTRAINT `stockininfotable_ibfk_1` FOREIGN KEY (`TypeId`) REFERENCES `typetable` (`TypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `stockininfotable`
--

LOCK TABLES `stockininfotable` WRITE;
/*!40000 ALTER TABLE `stockininfotable` DISABLE KEYS */;
INSERT INTO `stockininfotable` VALUES (1,'10003','2007-04-29 15:31:50','10005','10001',20,'10002','10001',''),(3,'10005','2007-04-29 15:50:53','10006','10001',10,'10002','10001','张冠军于2007年4月29日录入长虹34寸液晶彩电10台，型号：SDET－23－4');
/*!40000 ALTER TABLE `stockininfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockoutinfotable`
--

DROP TABLE IF EXISTS `stockoutinfotable`;
CREATE TABLE `stockoutinfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '出库单信息表自动ID',
  `StockOutId` varchar(20) NOT NULL COMMENT '出库单Id',
  `StockOutDate` varchar(20) NOT NULL COMMENT '出库单生成日期',
  `ChargeId` varchar(20) NOT NULL COMMENT '出库单负责人',
  `GoodsId` varchar(20) NOT NULL COMMENT '出库商品Id',
  `GoodsOutNumber` int(8) NOT NULL COMMENT '商品出库量',
  `GoodsReceiveId` varchar(20) NOT NULL COMMENT '商品接受人Id',
  `TypeId` varchar(20) NOT NULL COMMENT '商品型号Id',
  `CommodityId` varchar(20) NOT NULL COMMENT '商品分类Id',
  `GoodsOutMemo` varchar(100) default NULL COMMENT '出库单备注信息',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `StockOutId` (`StockOutId`),
  KEY `FK_stockoutinfotable` (`TypeId`),
  CONSTRAINT `stockoutinfotable_ibfk_1` FOREIGN KEY (`TypeId`) REFERENCES `typetable` (`TypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `stockoutinfotable`
--

LOCK TABLES `stockoutinfotable` WRITE;
/*!40000 ALTER TABLE `stockoutinfotable` DISABLE KEYS */;
INSERT INTO `stockoutinfotable` VALUES (1,'10001','2007-04-29 20:26:36','10003','10001',5,'10005','10002','10001','陈凯于2007年4月29日提长虹34寸液晶彩电5台，型号为SDET-23-4,出库负责人苏长城。'),(2,'10002','2007-04-29 20:28:30','10006','10001',5,'10003','10002','10001','');
/*!40000 ALTER TABLE `stockoutinfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stockregioninfotable`
--

DROP TABLE IF EXISTS `stockregioninfotable`;
CREATE TABLE `stockregioninfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品库中储存位置信息表自动ID',
  `StockRegionId` varchar(20) character set gbk collate gbk_bin NOT NULL COMMENT '储存位置Id',
  `StockRegionName` varchar(20) character set gbk collate gbk_bin NOT NULL COMMENT '储存位置名称',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `StockRegionId` (`StockRegionId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `stockregioninfotable`
--

LOCK TABLES `stockregioninfotable` WRITE;
/*!40000 ALTER TABLE `stockregioninfotable` DISABLE KEYS */;
INSERT INTO `stockregioninfotable` VALUES (3,'10001','东三区--二排--四号'),(4,'10002','东四区--三排--六号'),(5,'10003','东三区--六排--五号'),(6,'10004','西一区--六排--六号');
/*!40000 ALTER TABLE `stockregioninfotable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `supplytable`
--

DROP TABLE IF EXISTS `supplytable`;
CREATE TABLE `supplytable` (
  `ID` int(8) NOT NULL auto_increment COMMENT '供应商信息表自动ID',
  `SupplyId` varchar(20) NOT NULL COMMENT '供应商Id',
  `SupplyName` varchar(50) NOT NULL COMMENT '供应商名称',
  `SupplyCharge` varchar(30) NOT NULL COMMENT '供应商负责人',
  `SupplyAddress` varchar(50) NOT NULL COMMENT '供应商地址',
  `SupplyPhone` varchar(20) NOT NULL COMMENT '供应商固定电话',
  `SupplyMobile` varchar(20) NOT NULL COMMENT '供应商移动电话',
  `SupplyFax` varchar(20) default NULL COMMENT '供应商传真',
  `SupplyEmail` varchar(50) default NULL COMMENT '供应商电子邮件',
  `SupplyHttp` varchar(50) default NULL COMMENT '供应商网址',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `SupplyId` (`SupplyId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `supplytable`
--

LOCK TABLES `supplytable` WRITE;
/*!40000 ALTER TABLE `supplytable` DISABLE KEYS */;
INSERT INTO `supplytable` VALUES (1,'10001','长虹集体','陈凯','四川省长虹集团','037163982910','13837178301','037163982910','[e-mail]','http://ckdesignjava.blog.163.com'),(2,'10002','海尔集团','苏长城','天津市海尔集体工业园区','037163982910','13837178301','037163982910','[e-mail]','http://www\n\n.baidu.com'),(3,'10003','联想集团','张冠军','北京市高新技术工业园区','057187808033','13837178301','057187808045','[e-mail]','http://www.supor.com.c\n\nn');
/*!40000 ALTER TABLE `supplytable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `typetable`
--

DROP TABLE IF EXISTS `typetable`;
CREATE TABLE `typetable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '商品型号信息表自动ID',
  `TypeId` varchar(20) NOT NULL COMMENT '商品型号Id',
  `TypeName` varchar(20) NOT NULL COMMENT '商品型号名称',
  `CategoryId` varchar(20) default NULL COMMENT '商品分类Id',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `TypeId` (`TypeId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `typetable`
--

LOCK TABLES `typetable` WRITE;
/*!40000 ALTER TABLE `typetable` DISABLE KEYS */;
INSERT INTO `typetable` VALUES (1,'10001','SQT-123','10001'),(2,'10002','SDET-23-4','10001'),(3,'10003','F-YT-354','10001'),(4,'10004','LL-IOU-98','10001');
/*!40000 ALTER TABLE `typetable` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `warehouseinfotable`
--

DROP TABLE IF EXISTS `warehouseinfotable`;
CREATE TABLE `warehouseinfotable` (
  `ID` int(4) NOT NULL auto_increment COMMENT '仓库位置信息表自动ID',
  `WareHouseId` varchar(20) NOT NULL COMMENT '仓库Id',
  `WareHouseName` varchar(20) NOT NULL COMMENT '仓库名称',
  `ChargeId` varchar(20) NOT NULL COMMENT '仓库负责人Id',
  `WareHouseAdd` varchar(100) NOT NULL COMMENT '仓库地址',
  PRIMARY KEY  (`ID`),
  UNIQUE KEY `WareHouseId` (`WareHouseId`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `warehouseinfotable`
--

LOCK TABLES `warehouseinfotable` WRITE;
/*!40000 ALTER TABLE `warehouseinfotable` DISABLE KEYS */;
INSERT INTO `warehouseinfotable` VALUES (1,'10001','商城路储备库','10005','郑州市商城路48号-13'),(2,'10002','货栈街储备库','10005','郑州市货栈街55号-42');
/*!40000 ALTER TABLE `warehouseinfotable` 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-05-16  5:53:09