ÿþUSE [master]

GO

/****** Object:  Database [YT_WIDESEA_WCS]    Script Date: 2026/2/9 12:34:30 ******/

CREATE DATABASE [YT_WIDESEA_WCS]

 CONTAINMENT = NONE

 ON  PRIMARY 

( NAME = N'YT_WIDESEA_WMS', FILENAME = N'E:\SQLserver\R\MSSQL15.MSSQLSERVER\MSSQL\DATA\YT_WIDESEA_WMS.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB )

 LOG ON 

( NAME = N'YT_WIDESEA_WMS_log', FILENAME = N'E:\SQLserver\R\MSSQL15.MSSQLSERVER\MSSQL\DATA\YT_WIDESEA_WMS_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB )

 WITH CATALOG_COLLATION = DATABASE_DEFAULT

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET COMPATIBILITY_LEVEL = 150

GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))

begin

EXEC [YT_WIDESEA_WCS].[dbo].[sp_fulltext_database] @action = 'enable'

end

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_NULL_DEFAULT OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_NULLS OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_PADDING OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_WARNINGS OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ARITHABORT OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_CLOSE OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_SHRINK OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_UPDATE_STATISTICS ON 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET CURSOR_CLOSE_ON_COMMIT OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET CURSOR_DEFAULT  GLOBAL 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET CONCAT_NULL_YIELDS_NULL OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET NUMERIC_ROUNDABORT OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET QUOTED_IDENTIFIER OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET RECURSIVE_TRIGGERS OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET  ENABLE_BROKER 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET DATE_CORRELATION_OPTIMIZATION OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET TRUSTWORTHY OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET ALLOW_SNAPSHOT_ISOLATION OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET PARAMETERIZATION SIMPLE 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET READ_COMMITTED_SNAPSHOT OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET HONOR_BROKER_PRIORITY OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET RECOVERY FULL 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET  MULTI_USER 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET PAGE_VERIFY CHECKSUM  

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET DB_CHAINING OFF 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF ) 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET TARGET_RECOVERY_TIME = 60 SECONDS 

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET DELAYED_DURABILITY = DISABLED 

GO

EXEC sys.sp_db_vardecimal_storage_format N'YT_WIDESEA_WCS', N'ON'

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET QUERY_STORE = OFF

GO

USE [YT_WIDESEA_WCS]

GO

USE [YT_WIDESEA_WCS]

GO

/****** Object:  Sequence [dbo].[SeqTaskNum]    Script Date: 2026/2/9 12:34:31 ******/

CREATE SEQUENCE [dbo].[SeqTaskNum] 

 AS [int]

 START WITH 1

 INCREMENT BY 1

 MINVALUE 1

 MAXVALUE 99999

 CYCLE 

 CACHE 

GO

/****** Object:  Table [dbo].[Dt_DeviceInfo]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceInfo](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceCode] [varchar](20) NOT NULL,

	[DeviceName] [varchar](50) NOT NULL,

	[DeviceType] [varchar](50) NOT NULL,

	[DeviceStatus] [varchar](20) NOT NULL,

	[DeviceIp] [varchar](20) NOT NULL,

	[DevicePort] [int] NOT NULL,

	[DevicePlcType] [varchar](50) NOT NULL,

	[DeviceRemark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[DispatchId] [int] NULL,

 CONSTRAINT [PK_Dt_DeviceInfo_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_DeviceProtocol]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceProtocol](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceId] [int] NOT NULL,

	[DeviceChildCode] [varchar](20) NOT NULL,

	[DeviceProDataBlock] [varchar](50) NOT NULL,

	[DeviceProOffset] [decimal](10, 1) NOT NULL,

	[DeviceProDataType] [varchar](10) NOT NULL,

	[DeviceProDataLength] [int] NOT NULL,

	[DeviceProParamName] [varchar](50) NOT NULL,

	[DeviceProParamType] [varchar](50) NOT NULL,

	[DeviceProParamDes] [varchar](50) NULL,

	[DeviceProRemark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DeviceProtocol_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_DeviceProtocolDetail]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceProtocolDetail](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[DeviceType] [varchar](20) NOT NULL,

	[DeviceProParamName] [varchar](255) NOT NULL,

	[ProtocolDetailType] [varchar](50) NOT NULL,

	[ProtocalDetailValue] [varchar](50) NOT NULL,

	[ProtocolDetailDes] [varchar](500) NULL,

	[Remark] [varchar](200) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DeviceProtocolDetail_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_DispatchInfo]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DispatchInfo](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[Name] [varchar](50) NOT NULL,

	[JobGroup] [varchar](50) NOT NULL,

	[AssemblyName] [varchar](50) NOT NULL,

	[ClassName] [varchar](50) NOT NULL,

	[IntervalSecond] [int] NOT NULL,

	[BeginTime] [datetime] NULL,

	[EndTime] [datetime] NULL,

	[Remark] [varchar](1000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_DispatchInfo_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_roadwayinfo]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_roadwayinfo](

	[Id] [int] NOT NULL,

	[WarehouseName] [varchar](255) NULL,

	[WarehouseNumber] [varchar](100) NULL,

	[WarehouseInvType] [varchar](100) NULL,

	[RoadwayNo] [nvarchar](20) NULL,

	[EnableStatus] [int] NULL,

	[InStationCode] [nvarchar](20) NULL,

	[InSCStationCode] [nvarchar](20) NULL,

	[OutStationCode] [nvarchar](20) NULL,

	[OutSCStationCode] [nvarchar](20) NULL,

	[Remark] [nvarchar](200) NULL,

	[Creater] [nvarchar](50) NULL,

	[CreateDate] [datetime2](0) NULL,

	[Modifier] [nvarchar](50) NULL,

	[ModifyDate] [datetime2](0) NULL,

 CONSTRAINT [PK__dt_roadw__3214EC07DCDD1448] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_Router]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Router](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[StartPosi] [varchar](50) NOT NULL,

	[NextPosi] [varchar](50) NOT NULL,

	[InOutType] [bigint] NOT NULL,

	[ChildPosi] [varchar](50) NOT NULL,

	[ChildPosiDeviceCode] [varchar](50) NOT NULL,

	[SrmRow] [int] NULL,

	[SrmColumn] [int] NULL,

	[SrmLayer] [int] NULL,

	[Depth] [int] NULL,

	[IsEnd] [bit] NOT NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Dt_Router_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_Task]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Task](

	[TaskId] [int] IDENTITY(1,1) NOT NULL,

	[TaskNum] [int] NOT NULL,

	[PalletCode] [varchar](50) NOT NULL,

	[Roadway] [varchar](10) NOT NULL,

	[TaskType] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[SourceAddress] [varchar](20) NOT NULL,

	[TargetAddress] [varchar](20) NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NULL,

	[WMSId] [int] NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[PalletCodequantity] [varchar](200) NULL,

	[WMStaskid] [varchar](200) NULL,

	[deviceuuid] [varchar](255) NULL,

 CONSTRAINT [PK_Dt_Task_TaskId] PRIMARY KEY CLUSTERED 

(

	[TaskId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_Task_hty]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Task_hty](

	[TaskId] [int] IDENTITY(1,1) NOT NULL,

	[TaskNum] [int] NOT NULL,

	[PalletCode] [varchar](50) NOT NULL,

	[Roadway] [varchar](10) NOT NULL,

	[TaskType] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[SourceAddress] [varchar](20) NOT NULL,

	[TargetAddress] [varchar](20) NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NULL,

	[WMSId] [int] NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[WMStaskid] [varchar](200) NULL,

	[deviceuuid] [varchar](200) NULL,

	[PalletCodequantity] [varchar](200) NULL,

 CONSTRAINT [PK_Dt_Task_TaskId_copy1] PRIMARY KEY CLUSTERED 

(

	[TaskId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Dt_TaskExecuteDetail]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_TaskExecuteDetail](

	[TaskDetailId] [int] IDENTITY(1,1) NOT NULL,

	[TaskId] [int] NOT NULL,

	[TaskNum] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

	[CurrentAddress] [varchar](20) NOT NULL,

	[NextAddress] [varchar](20) NOT NULL,

	[IsManual] [bit] NOT NULL,

	[IsNormal] [bit] NOT NULL,

	[Description] [varchar](max) NOT NULL,

	[Remark] [varchar](255) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Department]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Department](

	[DepartmentId] [int] IDENTITY(1,1) NOT NULL,

	[DepartmentName] [varchar](50) NULL,

	[DepartmentCode] [varchar](50) NULL,

	[ParentId] [int] NOT NULL,

	[DepartmentType] [varchar](50) NULL,

	[Enable] [int] NOT NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Department_DepartmentId] PRIMARY KEY CLUSTERED 

(

	[DepartmentId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Dictionary]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Dictionary](

	[DicId] [int] IDENTITY(1,1) NOT NULL,

	[Config] [varchar](200) NULL,

	[DBServer] [varchar](50) NULL,

	[DBSql] [varchar](500) NULL,

	[DicName] [varchar](50) NULL,

	[DicNo] [varchar](50) NULL,

	[Enable] [tinyint] NULL,

	[OrderNo] [int] NULL,

	[ParentId] [int] NULL,

	[Remark] [varchar](2000) NULL,

	[SystemType] [int] NOT NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Dictionary_DicId] PRIMARY KEY CLUSTERED 

(

	[DicId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_DictionaryList]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_DictionaryList](

	[DicListId] [int] IDENTITY(1,1) NOT NULL,

	[DicName] [varchar](50) NULL,

	[DicValue] [varchar](50) NULL,

	[DicId] [int] NOT NULL,

	[Enable] [tinyint] NULL,

	[OrderNo] [int] NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_DictionaryList_DicListId] PRIMARY KEY CLUSTERED 

(

	[DicListId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Log]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Log](

	[Id] [int] IDENTITY(1,1) NOT NULL,

	[BeginDate] [datetime] NULL,

	[ElapsedTime] [int] NULL,

	[EndDate] [datetime] NULL,

	[RequestParam] [varchar](2000) NULL,

	[ResponseParam] [varchar](2000) NULL,

	[Success] [int] NULL,

	[Url] [varchar](2000) NULL,

	[UserIP] [varchar](20) NULL,

	[UserName] [varchar](50) NULL,

	[User_Id] [int] NULL,

 CONSTRAINT [PK_Sys_Log_Id] PRIMARY KEY CLUSTERED 

(

	[Id] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Menu](

	[MenuId] [int] IDENTITY(1,1) NOT NULL,

	[MenuName] [varchar](50) NULL,

	[Auth] [varchar](2000) NULL,

	[Icon] [varchar](200) NULL,

	[Description] [varchar](2000) NULL,

	[Enable] [tinyint] NULL,

	[TableName] [varchar](50) NULL,

	[ParentId] [int] NOT NULL,

	[Url] [varchar](50) NULL,

	[OrderNo] [int] NULL,

	[MenuType] [int] NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Menu_MenuId] PRIMARY KEY CLUSTERED 

(

	[MenuId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Role]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Role](

	[RoleId] [int] IDENTITY(1,1) NOT NULL,

	[DeptId] [int] NULL,

	[Enable] [tinyint] NOT NULL,

	[ParentId] [int] NOT NULL,

	[RoleName] [varchar](50) NOT NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED 

(

	[RoleId] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_RoleAuth]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_RoleAuth](

	[AuthId] [int] IDENTITY(1,1) NOT NULL,

	[AuthValue] [varchar](500) NULL,

	[MenuId] [int] NOT NULL,

	[RoleId] [int] NULL,

	[UserId] [int] NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Tenant]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Tenant](

	[TenantId] [int] IDENTITY(1,1) NOT NULL,

	[TenantName] [varchar](200) NOT NULL,

	[TenantType] [int] NOT NULL,

	[DbType] [int] NOT NULL,

	[ConnectionString] [varchar](1000) NOT NULL,

	[Status] [int] NOT NULL,

	[Remark] [varchar](2000) NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_User]    Script Date: 2026/2/9 12:34:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_User](

	[User_Id] [int] IDENTITY(1,1) NOT NULL,

	[UserName] [varchar](100) NOT NULL,

	[Role_Id] [int] NOT NULL,

	[RoleName] [varchar](100) NULL,

	[PhoneNo] [varchar](11) NULL,

	[Remark] [varchar](200) NULL,

	[UserPwd] [varchar](200) NOT NULL,

	[UserTrueName] [varchar](100) NOT NULL,

	[DeptName] [varchar](100) NULL,

	[Dept_Id] [int] NULL,

	[Email] [varchar](100) NULL,

	[Enable] [tinyint] NOT NULL,

	[Gender] [int] NULL,

	[HeadImageUrl] [varchar](500) NULL,

	[LastModifyPwdDate] [datetime] NULL,

	[Address] [varchar](200) NULL,

	[AuditDate] [datetime] NULL,

	[AuditStatus] [int] NULL,

	[Auditor] [varchar](100) NULL,

	[Token] [varchar](500) NULL,

	[TenantId] [bigint] NOT NULL,

	[Creater] [varchar](255) NOT NULL,

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL

) ON [PRIMARY]

GO

SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] ON 



INSERT [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate], [DispatchId]) VALUES (1, N'SC01', N'1÷SXW:g', N'CommonStackerCrane', N'0', N'10.50.11.79', 102, N'SiemensS7', N'', N'1', CAST(N'2024-10-29T15:21:11.013' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.257' AS DateTime), 1)

INSERT [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate], [DispatchId]) VALUES (2, N'SC02', N'2÷SXW:g', N'CommonStackerCrane', N'0', N'10.50.11.69', 102, N'SiemensS7', N'1', N'1', CAST(N'2024-10-29T15:21:11.013' AS DateTime), N'admin', CAST(N'2024-10-29T16:03:59.823' AS DateTime), 1)

SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] OFF

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] ON 



INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, 1, N'SC01', N'DB106', CAST(2.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneStatus', N'StackerCraneStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.260' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, 1, N'SC01', N'DB106', CAST(3.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneAutoStatus', N'StackerCraneAutoStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.260' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, 1, N'SC01', N'DB106', CAST(18.0 AS Decimal(10, 1)), N'dint', 1, N'CurrentTaskNum', N'CurrentTaskNum', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, 1, N'SC01', N'DB106', CAST(22.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneWorkStatus', N'StackerCraneWorkStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, 1, N'SC01', N'DB105', CAST(2.0 AS Decimal(10, 1)), N'dint', 1, N'TaskNum', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, 1, N'SC01', N'DB105', CAST(6.0 AS Decimal(10, 1)), N'int', 1, N'WorkType', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, 1, N'SC01', N'DB105', CAST(8.0 AS Decimal(10, 1)), N'int', 1, N'TrayType', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, 1, N'SC01', N'DB105', CAST(10.0 AS Decimal(10, 1)), N'int', 1, N'StartRow', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, 1, N'SC01', N'DB105', CAST(12.0 AS Decimal(10, 1)), N'int', 1, N'StartColumn', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, 1, N'SC01', N'DB105', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'StartLayer', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, 1, N'SC01', N'DB105', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'EndRow', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, 1, N'SC01', N'DB105', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'EndColumn', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, 1, N'SC01', N'DB105', CAST(20.0 AS Decimal(10, 1)), N'int', 1, N'EndLayer', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime))

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, 1, N'SC01', N'DB105', CAST(22.0 AS Decimal(10, 1)), N'string', 25, N'Barcode', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime))

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] OFF

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] ON 



INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'CommonStackerCrane', N'StackerCraneStatus', N'Normal', N'1', N'¾Y¶r`(1:ck8^)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'CommonStackerCrane', N'StackerCraneStatus', N'Fault', N'2', N'¾Y¶r`(2:Ee)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'CommonStackerCrane', N'StackerCraneStatus', N'EmergencyStop', N'3', N'¾Y¶r`(3:%`\P)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Maintenance', N'0', N'å]\O!j_(0:ô~îO)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Manual', N'1', N'å]\O!j_(1:Kb¨R', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'SemiAutomatic', N'2', N'å]\O!j_(2:JSê¨R)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Automatic', N'3', N'å]\O!j_(3:ê¨R)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Standby', N'0', N'\ON¶r`(0:_:g)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUp', N'1', N'\ON¶r`(1:ÖS'-N)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUpCompleted', N'2', N'\ON¶r`(2:ÖS'[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Putting', N'4', N'\ON¶r`(4:>e'-N)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PutCompleted', N'5', N'\ON¶r`(5:>e'[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'WorkCompleted', N'6', N'\ON¶r`(6:ûN¡R[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'CommonConveyorLine', N'InteractiveSignal', N'RequestInbound', N'1', N'1', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'CommonConveyorLine', N'InteractiveSignal', N'RequestInNextAddress', N'2', N'2', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (32, N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineInFinish', N'3', N'3', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (34, N'CommonConveyorLine', N'IsOccupied', N'IsOccupied', N'0', N'0', NULL, N'1', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (35, N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutbound', N'4', N'4', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (36, N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutNextAddress', N'5', N'5', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (37, N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineOutFinish', N'6', N'6', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] OFF

SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] ON 



INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'XW:g¦^', N'CommonStackerCrane', N'WIDESEAWCS_Tasks', N'CommonStackerCraneJob', 1, NULL, NULL, NULL, N'1', CAST(N'2024-10-29T15:21:12.043' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1002, N'åe×_nd', N'LogJob', N'WIDESEAWCS_Tasks', N'LogJob', 1, NULL, NULL, N'43200', N'1', CAST(N'2024-12-24T21:21:11.000' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] OFF

INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'íp	N!jwQ^', N'ZR16', N'invmd', N'C', 1, N'1112', N'YMYL00103700220', N'1109', N'YMYL00103700320', NULL, N'1', CAST(N'2026-01-12T17:13:58.0000000' AS DateTime2), N'1', CAST(N'2026-01-12T17:14:03.0000000' AS DateTime2))

INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'íp	N¯Òv^', N'ZR17', N'invxh', N'B', 1, N'1108', N'YMYL00103700620', N'1105', N'YMYL00103700720', NULL, N'1', CAST(N'2026-01-12T17:15:15.0000000' AS DateTime2), NULL, NULL)

INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'íp	NxÒv^', N'ZR18', N'invsc', N'F', 1, N'1211', N'YMCP00104500306', N'1210', N'YMCP00104500206', NULL, N'1', CAST(N'2026-01-12T17:15:41.0000000' AS DateTime2), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Dt_Task] ON 



INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [PalletCodequantity], [WMStaskid], [deviceuuid]) VALUES (16738, 2, N'22004213289', N'W', 200, 200, N'W01-019-006', N'T07', N'W01-019-006', N'T07', NULL, 1, 0, NULL, NULL, N'System', CAST(N'2026-02-09T12:25:08.297' AS DateTime), NULL, NULL, NULL, NULL, N'3F72-A854-62DA-EE51')

SET IDENTITY_INSERT [dbo].[Dt_Task] OFF

SET IDENTITY_INSERT [dbo].[Sys_Dictionary] ON 



INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'{valueField: ''Enable'',

textField: ''Enable'',

 containField: null,

  handler: null }', N'1', NULL, N'/f&T<P', N'enable', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (30, N'{valueField: ''Success'',

 textField: ''Success'', 

 containField: null,

 handler: null }

', NULL, NULL, N'ÍT^¶r`', N'restatus', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-06-12T10:21:48.000' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (31, N'{valueField: ''LogType'',

 textField: ''LogType'', 

 containField: null,

 handler: null }

', NULL, NULL, N'åe×_{|W', N'log', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.927' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (32, N'{valueField: ''Role_Id'',

 textField: ''RoleName'', 

 containField: [''Role_Id'',''RoleName''],

 handler: null }

', NULL, N'SELECT RoleId as ''key'',RoleName as ''value'' FROM Sys_Role WHERE Enable=1', N'ÒrRh', N'roles', 1, 123, 0, N'sqlíåSkey,valueRÿLubMbýÑ~[pencn', 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-13T15:03:53.000' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (35, N'{

 valueField: ''AuditStatus'',

 textField: ''AuditStatus'',

  containField:null 

}', NULL, NULL, N'¡[8h¶r`', N'audit', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (49, N'{

 valueField: ''Gender'',

 textField: ''Gender'',

  containField:null 

}', NULL, NULL, N''`+R', N'gender', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (50, N'{

 valueField: ''Enable'',

 textField: ''Enable'',

  containField:null 

}', NULL, NULL, N'/T(u¶r`', N'status', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (59, N'{

 valueField: ''IsRegregisterPhone'',

 textField: ''IsRegregisterPhone'',

  containField:null 

}', NULL, NULL, N'Kb:g(u7b', N'isphone', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (66, NULL, NULL, N'SELECT RoleId AS id,parentId,RoleId AS [key],RoleName AS value FROM Sys_Role', N'§~TÒr', N'tree_roles', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:08:03.217' AS DateTime))

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (67, NULL, NULL, NULL, N'nav', N'nav', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (70, NULL, NULL, NULL, N'÷Bl¹e_', N'÷Bl¹e_', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (71, NULL, NULL, NULL, N'[öeûN¡R¶r`', N'[öeûN¡R¶r`', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (72, NULL, NULL, N'SELECT DepartmentId AS ''key'',DepartmentId AS ''id'',ParentId AS parentId,DepartmentName as ''value'' FROM Sys_Department', N'Ä~Ç~:gg', N'Ä~Ç~:gg', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (75, NULL, NULL, NULL, N'åe×_¶r`', N'LogState', 1, NULL, 0, NULL, 1, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_Dictionary] OFF

SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] ON 



INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'&T', N'0', 3, NULL, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'/f', N'1', 3, NULL, 1, NULL, N'xxx', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (22, N'vQÖN', N'0', 30, NULL, 10, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (23, N'bR', N'1', 30, NULL, 100, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (24, N'_8^', N'2', 30, NULL, 50, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (25, N'û|ß~', N'System', 31, NULL, 100, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.947' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (26, N'{vF', N'Login', 31, NULL, 90, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.947' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (27, N'°eú^', N'Add', 31, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (28, N' Rd', N'Del', 31, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (29, N'', N'Edit', 31, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (37, N'_¡[8h', N'0', 35, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (38, N'¡[8hÇ', N'1', 35, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (39, N'¡[8h-N', N'2', 35, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (71, N'_8^', N'Exception', 31, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (90, N'7u', N'0', 49, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (91, N'sY', N'1', 49, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (96, N'*g/T(u', N'0', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (97, N'ò]/T(u', N'1', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (98, N'ò] Rd', N'2', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (128, N'/f', N'1', 59, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (129, N'&T', N'0', 59, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (144, N'7R°eToken', N'ReplaceToeken', 31, NULL, 110, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.937' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (145, N'Info', N'3', 30, NULL, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (423, N'/f', N'1', 67, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (424, N'&T', N'0', 67, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (435, N'¡[8h*gÇ', N'3', 35, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (436, N'get', N'get', 70, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (437, N'post', N'post', 70, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (438, N'ck8^', N'0', 71, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (439, N'f\P', N'1', 71, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (442, N'sÞV', N'4', 35, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (443, N'y(u', N'DisEnable', 73, 1, 1, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'_ÑS', CAST(N'2023-07-14T14:17:01.037' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (444, N'/T(u', N'Enable', 73, 1, 0, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'_ÑS', CAST(N'2023-07-14T14:17:01.017' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (449, N'áOo`', N'Info', 75, 0, 1, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (450, N'bR', N'Sucess', 75, 0, 2, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (451, N'1Y%', N'Error', 75, 0, 3, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (452, N'1', N'1', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (453, N'2', N'2', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (454, N'3', N'3', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (455, N'4', N'4', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime))

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (456, N'*g¡[8h', N'OrderState_Unaudited', 84, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (457, N'ò]¡[8h', N'OrderState_Audited', 84, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] OFF

SET IDENTITY_INSERT [dbo].[Sys_Log] ON 



INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4662, CAST(N'2026-02-06T14:39:35.297' AS DateTime), 323, CAST(N'2026-02-06T14:39:35.623' AS DateTime), N'{"QueryString":"","BodyData":"{\n? ? \"taskType\": \"in\",\n? ? \"barCode\": \"0000000000001509634\",\n? ? \"original_barCode\": \"22004213289\",\n? ? \"from\": {\n? ? ? ? \"code\": \"W01-019-006\"\n? ? },\n? ? \"to\": {\n? ? ? ? \"code\": \"T07\"\n? ? },\n? ? \"device\": {\n? ? ? ? \"uuid\": \"3F72-A854-62DA-EE51\"\n? ? }\n}"}', N'{"success":true,"datas":null,"messages":["Íd\ObR"]}', NULL, N'http://127.0.0.1:9291/api/WMSTask/saveTask', N'127.0.0.1', N'', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4663, CAST(N'2026-02-06T14:49:44.833' AS DateTime), 155, CAST(N'2026-02-06T14:49:44.987' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"4960af55-e47a-4fca-8ee1-ed7e2e0a39ba\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"§~¡{tXT","img":""},"devMessage":null}', NULL, N'http://127.0.0.1:9291/api/User/login', N'127.0.0.1', N'', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4664, CAST(N'2026-02-06T14:50:30.950' AS DateTime), 741, CAST(N'2026-02-06T14:50:31.693' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"deviceType","config":"","data":[{"key":"CommonConveyorLine","value":"¿~"},{"key":"OtherDevice","value":"OtherDevice"},{"key":"ShuttleCar","value":"z­hf"},{"key":"CommonStackerCrane","value":"XW:g"},{"key":"SpeStackerCrane","value":"XW:g2"}],"saveCache":true},{"dicNo":"devicePlcType","config":"","data":[{"key":"AllenBrandlyEtherNetCommunicator","value":"WKQæ\(AB)EtherNet/IP(CIP)"},{"key":"InovanceTcp","value":"GlÝ]Tcp"},{"key":"ModbusTcp","value":"ModbusTcp"},{"key":"OmronEtherNetCommunicator","value":"'kÆYEtherNet/IP(CIP)"},{"key":"SiemensS7","value":"èP[S7"}],"saveCache":true},{"dicNo":"jobAssembly","config":"","data":[{"key":"WIDESEAWCS_Tasks","value":"WIDESEAWCS_Tasks"}],"saveCache":true},{"dicNo":"jobClassName","config":"","data":[{"key":"LogJob","value":"LogJob"},{"key":"CommonStackerCraneJob","value":"CommonStackerCraneJob"}],"saveCache":true},{"dicNo":"deviceStatus","config":"","data":[{"key":"0","value":"y(u"},{"key":"1","value":"/T(u"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"inOutType","config":"","data":[{"key":"1","value":"eQ^ï1u"},{"key":"2","value":"úQ^ï1u"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4665, CAST(N'2026-02-06T14:51:23.897' AS DateTime), 38, CAST(N'2026-02-06T14:51:23.933' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4666, CAST(N'2026-02-06T14:52:27.643' AS DateTime), 2, CAST(N'2026-02-06T14:52:27.647' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4667, CAST(N'2026-02-06T14:52:30.373' AS DateTime), 2, CAST(N'2026-02-06T14:52:30.377' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL)

SET IDENTITY_INSERT [dbo].[Sys_Log] OFF

SET IDENTITY_INSERT [dbo].[Sys_Menu] ON 



INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'(u7b¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-user', NULL, 1, N'.', 0, NULL, 4000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:07.567' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'(u7b¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_User', 1, N'/Sys_User', 2000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:14.030' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'CgP¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'ivu-icon ivu-icon-ios-boat', NULL, 1, N',', 1, N'/permission', 1000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:20.727' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'Òr¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Role', 1, N'/Sys_Role', 900, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:23.177' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'û|ß~¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-setting', NULL, 1, N'û|ß~¾n', 0, N'/', 0, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:38.703' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'ÜUS¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Menu', 5, N'/sysmenu', 10, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:42.007' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'NÉbFhÑ~[¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Dictionary', 5, N'/Sys_Dictionary', 10, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'åe×_¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'xxx', 0, N'/', 500, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'¥cãSåe×_', N'[{"text":"ågâ","value":"Search"}]', NULL, NULL, 0, N'Sys_Log', 8, N'/Sys_Log/Manager', 0, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-12-08T18:33:41.437' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'¾Y¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'', 0, N'/', 8000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'¾YáOo`', N'[{"text":"ågâ","value":"Search"},{"text":"","value":"Update"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceInfo', 10, N'/deviceInfo', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:20.613' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'ûN¡R¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'', 0, N'/', 7000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'ûN¡RáOo`', N'[{"text":"ågâ","value":"Search"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"}]', N'el-icon-date', NULL, 1, N'Dt_Task', 12, N'/task', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:54.960' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'¾YOS®áOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceProtocol', 10, N'/deviceProtocol', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:39.360' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'¾YOS®fÆ~áOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceProtocolDetail', 10, N'/deviceProtocolDetail', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:36.457' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (16, N'¦^
g¡RMnáOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DispatchInfo', 10, N'/dispatchInfo', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:44.470' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (17, N'úW@x¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 0, N'Dt_Router', 0, N'/', 7000, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:36:03.787' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'ï1uMnáOo`', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"},{"text":"ågwhQèï1u","value":"ViewAllRouter"},{"text":"ï1uMn","value":"AddRouters"}]', N'el-icon-date', NULL, 1, N'Dt_Router', 17, N'/router', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:35:35.280' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1001, N'åe×_e,g', N'[{"text":"ågâ","value":"Search"}]', N'', NULL, 1, N'txt_log', 8, N'/txt_log', 3, NULL, N'admin', CAST(N'2024-12-08T18:34:10.633' AS DateTime), N'admin', CAST(N'2024-12-08T18:37:08.167' AS DateTime))

SET IDENTITY_INSERT [dbo].[Sys_Menu] OFF

SET IDENTITY_INSERT [dbo].[Sys_Role] ON 



INSERT [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, 111, 1, 0, N'§~¡{tXT', N'§~¡{tXT', CAST(N'2024-10-29T15:21:07.510' AS DateTime), N'admin', CAST(N'2024-04-29T13:53:44.717' AS DateTime))

SET IDENTITY_INSERT [dbo].[Sys_Role] OFF

SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] ON 



INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (136, N'Search,Add,Delete,Update,Import,Export', 1, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (137, N'Search,Add,Delete,Update,Import,Export', 2, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:04:07.830' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (138, N'Search,Add,Delete,Update,Import,Export', 3, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (140, N'Search,Add,Delete,Update,Import,Export', 4, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (141, N'Search,Add,Delete,Update,Import,Export', 5, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (143, N'Search,Add,Delete,Update,Import,Export', 6, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (144, N'Search,Add,Delete,Update,Import,Export', 7, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:00:47.033' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (146, N'Search,Add,Delete,Update,Import,Export', 8, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:04:07.830' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (148, N'Search,Add,Delete,Update,Import,Export', 9, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (153, N'Search,Add,Delete,Update,Import,Export', 10, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (154, N'Search,Add,Delete,Update,Import,Export', 12, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (155, N'Search,Add,Delete,Update,Import,Export', 13, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (156, N'Search', 11, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (157, N'Search', 11, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (158, N'Search,Add,Delete,Update,Import,Export', 10, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] OFF

SET IDENTITY_INSERT [dbo].[Sys_User] ON 



INSERT [dbo].[Sys_User] ([User_Id], [UserName], [Role_Id], [RoleName], [PhoneNo], [Remark], [UserPwd], [UserTrueName], [DeptName], [Dept_Id], [Email], [Enable], [Gender], [HeadImageUrl], [LastModifyPwdDate], [Address], [AuditDate], [AuditStatus], [Auditor], [Token], [TenantId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'admin', 1, N'§~¡{tXT', N'', N'', N'j79rYYvCz4vdhcboB1Ausg==', N'§~¡{tXT', N'', 0, N'', 1, 1, N'', CAST(N'2024-04-16T19:58:55.000' AS DateTime), N'û|ß~
g¡RhV', CAST(N'2024-04-16T00:54:06.000' AS DateTime), 1, N'§~¡{tXT', N'', 0, N'û|ß~', CAST(N'2024-10-29T15:21:08.487' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_User] OFF

ALTER TABLE [dbo].[Dt_DeviceProtocol] ADD  DEFAULT ('1') FOR [DeviceProDataLength]

GO

ALTER TABLE [dbo].[Sys_User] ADD  DEFAULT ('0') FOR [TenantId]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceIp'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YïzãS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePort'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PLC{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePlcType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceRemark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YP[÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceChildCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OS®pencWW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataBlock'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OPûyÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProOffset'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataLength'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpeôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamDes'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProRemark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®ÂSpe
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceProParamName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ÖS<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocalDetailValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailDes'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Name'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RRÄ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'JobGroup'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(WDLLù[^vz^Æ
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'AssemblyName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(W{|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ClassName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gbLôöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'IntervalSecond'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'BeginTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'EndTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RÏcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¦^
g¡RMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^ãNx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseNumber'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseInvType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'RoadwayNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y(u¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'EnableStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'InStationCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:geQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'InSCStationCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'OutStationCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gúQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'OutSCStationCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'StartPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'È~¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'NextPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï1u{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'InOutType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosi'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn@b^\¾Y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosiDeviceCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'L' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmRow'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmColumn'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'B\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmLayer'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ñm¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Depth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/fgÈ~¹p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'IsEnd'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Yï1uMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Roadway'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'SourceAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TargetAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ExceptionMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Grade'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'WMSId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Dispatchertime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y(uW[µk' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCodequantity'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'WMStaskid'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YUID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'deviceuuid'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Roadway'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'SourceAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TargetAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ExceptionMessage'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Grade'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'WMSId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Dispatchertime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'WMStaskid'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YUID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'deviceuuid'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØvpeÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCodequantity'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskDetailId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskNum'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskState'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CurrentAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'NextAddress'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TºNå]Íd\O' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsManual'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&Tck8^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsNormal'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Description'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RgbLfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N§~Ä~Ç~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~¶gg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Mny' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Config'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^
g¡R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBServer'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SqlíåS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBSql'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'û|ß~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'SystemType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQpenc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQRhID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicListId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnText' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnValue' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'BeginDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'öe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ElapsedTime'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'EndDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷BlÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'RequestParam'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^ÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ResponseParam'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Success'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷Bl0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Url'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserIP'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'User_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Auth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'þVh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Icon'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Description'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'TableName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Url'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'OrderNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'DeptId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6rID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ParentId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òrh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bCgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'MenuId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'RoleId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'UserId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁ¡{t' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'DbType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þ¥cW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ConnectionString'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Status'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'User_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Role_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'RoleName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'5uÝ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'PhoneNo'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Æ[x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserPwd'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w[ÓY
T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserTrueName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'DeptName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èèID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Dept_Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'®±{' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Email'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Enable'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''`+R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Gender'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'4YÏP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'HeadImageUrl'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gTÆ[xîO9eöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'LastModifyPwdDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Address'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8höeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8h¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8hºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Auditor'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'äNLr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Token'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'TenantId'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Creater'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'CreateDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Modifier'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User'

GO

USE [master]

GO

ALTER DATABASE [YT_WIDESEA_WCS] SET  READ_WRITE 

GO

