XS202109267088/数据库备份/20241121/wms.sql

-- --------------------------------------------------------
-- 主机:                           127.0.0.1
-- 服务器版本:                        10.9.7-MariaDB - mariadb.org binary distribution
-- 服务器操作系统:                      Win64
-- HeidiSQL 版本:                  12.3.0.6589
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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 */;


-- 导出 wms 的数据库结构
CREATE DATABASE IF NOT EXISTS `wms` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci */;
USE `wms`;

-- 导出  表 wms.asyncbehavior 结构
CREATE TABLE IF NOT EXISTS `asyncbehavior` (
  `Id` varchar(36) NOT NULL,
  `TaskID` varchar(255) NOT NULL,
  `AgvId` int(11) NOT NULL,
  `Behavior` int(11) NOT NULL,
  `Interval` int(11) NOT NULL,
  `MaxStepId` int(11) NOT NULL,
  `FirstStart` tinyint(1) NOT NULL,
  `AssemblyString` varchar(255) NOT NULL,
  `FullClassName` varchar(255) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.asyncbehavior 的数据：~0 rows (大约)
DELETE FROM `asyncbehavior`;

-- 导出  表 wms.materialbinding 结构
CREATE TABLE IF NOT EXISTS `materialbinding` (
  `TaskID` varchar(50) NOT NULL,
  `CarrierID` int(11) NOT NULL,
  `MaterialID` varchar(255) DEFAULT NULL,
  `MaterialName` varchar(255) DEFAULT NULL,
  `MaterialBarcode` varchar(255) DEFAULT NULL,
  `MaterialType` varchar(255) DEFAULT NULL,
  `MaterialNumber` varchar(255) DEFAULT NULL,
  `MaterialLevel` varchar(255) DEFAULT NULL,
  `MaterialWeight` varchar(255) DEFAULT NULL,
  `BatchNumber` varchar(255) DEFAULT NULL,
  `MaterialSpecifications` varchar(255) DEFAULT NULL,
  `Operator` varchar(255) DEFAULT NULL,
  `ModifyTime` varchar(255) DEFAULT NULL,
  `TaskBook` varchar(255) DEFAULT NULL,
  `StartWareHouse` varchar(255) DEFAULT NULL,
  `StartLocation` varchar(255) DEFAULT NULL,
  `EndWareHouse` varchar(255) DEFAULT NULL,
  `EndLocation` varchar(255) DEFAULT NULL,
  `CreateTime` datetime NOT NULL,
  `StartTime` datetime NOT NULL,
  `PickTime` datetime NOT NULL,
  `PlaceTime` datetime NOT NULL,
  `JsonInfo` longtext DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.materialbinding 的数据：~0 rows (大约)
DELETE FROM `materialbinding`;

-- 导出  表 wms.pmstaskinfo 结构
CREATE TABLE IF NOT EXISTS `pmstaskinfo` (
  `TaskID` varchar(50) NOT NULL,
  `WareHouseCode` varchar(50) DEFAULT NULL,
  `LocationCode` varchar(50) DEFAULT NULL,
  `MaterialId` varchar(50) DEFAULT NULL,
  `TargetWareHouseCode` varchar(50) DEFAULT NULL,
  `TargetLocationCode` varchar(50) DEFAULT NULL,
  `CreateTime` datetime NOT NULL,
  `Carrier` int(11) NOT NULL,
  `CarrierType` varchar(50) DEFAULT NULL,
  `Priority` int(11) NOT NULL,
  `Message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`TaskID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.pmstaskinfo 的数据：~0 rows (大约)
DELETE FROM `pmstaskinfo`;

-- 导出  表 wms.sys_areatraffic 结构
CREATE TABLE IF NOT EXISTS `sys_areatraffic` (
  `Id` varchar(255) NOT NULL,
  `FactoryId` varchar(255) NOT NULL,
  `AgvId` varchar(255) NOT NULL,
  `LastInTime` datetime NOT NULL,
  `LastOutTime` datetime NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.sys_areatraffic 的数据：~0 rows (大约)
DELETE FROM `sys_areatraffic`;

-- 导出  表 wms.t_wh_locationproperty 结构
CREATE TABLE IF NOT EXISTS `t_wh_locationproperty` (
  `LocationCode` varchar(255) NOT NULL,
  `WareHouseCode` varchar(255) NOT NULL,
  `Mark` int(11) NOT NULL,
  `Priority` int(11) NOT NULL,
  `Status` int(11) NOT NULL,
  `Active` varchar(255) DEFAULT NULL,
  `ModifyUser` varchar(255) DEFAULT NULL,
  `ModifyTime` varchar(255) DEFAULT NULL,
  `Area` varchar(255) DEFAULT NULL,
  `RowIndex` int(11) NOT NULL,
  `ColumnIndex` int(11) NOT NULL,
  `LayerIndex` int(11) NOT NULL,
  `Attribute3` varchar(255) DEFAULT NULL,
  `Attribute4` varchar(255) DEFAULT NULL,
  `Attribute5` varchar(255) DEFAULT NULL,
  `Attribute6` varchar(255) DEFAULT NULL,
  `Attribute7` varchar(255) DEFAULT NULL,
  `Attribute8` varchar(255) DEFAULT NULL,
  `Attribute9` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`LocationCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.t_wh_locationproperty 的数据：~53 rows (大约)
DELETE FROM `t_wh_locationproperty`;
INSERT INTO `t_wh_locationproperty` (`LocationCode`, `WareHouseCode`, `Mark`, `Priority`, `Status`, `Active`, `ModifyUser`, `ModifyTime`, `Area`, `RowIndex`, `ColumnIndex`, `LayerIndex`, `Attribute3`, `Attribute4`, `Attribute5`, `Attribute6`, `Attribute7`, `Attribute8`, `Attribute9`) VALUES
	('A01', '货架A', 52, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A02', '货架A', 53, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A03', '货架A', 54, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A04', '货架A', 55, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A05', '货架A', 56, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A06', '货架A', 57, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A07', '货架A', 58, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A08', '货架A', 59, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A09', '货架A', 60, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A10', '货架A', 61, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('A11', '货架A', 62, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架A', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B01', '货架B', 63, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B02', '货架B', 64, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B03', '货架B', 65, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B04', '货架B', 66, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B05', '货架B', 67, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B06', '货架B', 68, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B07', '货架B', 69, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B08', '货架B', 70, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B09', '货架B', 71, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B10', '货架B', 72, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('B11', '货架B', 73, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架B', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('仓库01', '仓库', 34, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '仓库', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('仓库02', '仓库', 35, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '仓库', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('仓库03', '仓库', 36, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '仓库', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('仓库04', '仓库', 37, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '仓库', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包01', '翻包区', 29, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包02', '翻包区', 30, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包03', '翻包区', 31, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包04', '翻包区', 32, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包05', '翻包区', 33, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包06', '翻包区', 24, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包07', '翻包区', 25, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包08', '翻包区', 26, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包09', '翻包区', 27, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包10', '翻包区', 28, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包11', '翻包区', 14, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包12', '翻包区', 15, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包13', '翻包区', 16, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包14', '翻包区', 17, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包15', '翻包区', 18, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包16', '翻包区', 9, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包17', '翻包区', 10, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包18', '翻包区', 11, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包19', '翻包区', 12, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包20', '翻包区', 13, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '翻包区', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包21', '参观翻包', 47, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '参观翻包', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包22', '参观翻包', 48, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '参观翻包', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包23', '参观翻包', 49, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '参观翻包', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包24', '参观翻包', 50, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '参观翻包', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('翻包25', '参观翻包', 51, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '参观翻包', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('货架等待01', '货架等待', 2, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架等待', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
	('货架等待02', '货架等待', 1, 0, 0, 'N', 'xjh', '2024-11-20 14:03:18', '货架等待', 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- 导出  表 wms.t_wh_materialdetail 结构
CREATE TABLE IF NOT EXISTS `t_wh_materialdetail` (
  `LocationCode` varchar(255) NOT NULL,
  `WareHouseCode` varchar(255) DEFAULT NULL,
  `MaterialName` varchar(255) DEFAULT NULL,
  `BatchNumber` varchar(255) DEFAULT NULL,
  `Attribute1` varchar(255) DEFAULT NULL,
  `Attribute2` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`LocationCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.t_wh_materialdetail 的数据：~0 rows (大约)
DELETE FROM `t_wh_materialdetail`;

-- 导出  表 wms.t_wh_warehouse 结构
CREATE TABLE IF NOT EXISTS `t_wh_warehouse` (
  `WareHouseCode` varchar(255) NOT NULL,
  `WareHouseName` varchar(255) NOT NULL,
  `WareHouseProperty` varchar(255) DEFAULT NULL,
  `TargetWareHouseCode` varchar(255) DEFAULT NULL,
  `SourceWareHouseCode` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`WareHouseCode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- 正在导出表  wms.t_wh_warehouse 的数据：~6 rows (大约)
DELETE FROM `t_wh_warehouse`;
INSERT INTO `t_wh_warehouse` (`WareHouseCode`, `WareHouseName`, `WareHouseProperty`, `TargetWareHouseCode`, `SourceWareHouseCode`) VALUES
	('仓库', '仓库', NULL, NULL, NULL),
	('参观翻包', '参观翻包', NULL, NULL, NULL),
	('翻包区', '翻包区', NULL, NULL, NULL),
	('货架A', '货架A', NULL, NULL, NULL),
	('货架B', '货架B', NULL, NULL, NULL),
	('货架等待', '货架等待', NULL, NULL, NULL);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;