ÿþUSE [WIDESEAWCS_FG]

GO

/****** Object:  Table [dbo].[Dt_DeviceInfo]    Script Date: 2026/4/1 19:34:20 ******/

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](30) NOT NULL,

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

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

	[DevicePort] [int] NOT NULL,

	[DevicePlcType] [varchar](20) 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/4/1 19:34:20 ******/

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](10) 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/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_DeviceProtocolDetail](

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

	[DeviceType] [varchar](30) 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/4/1 19:34:20 ******/

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_Platform]    Script Date: 2026/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Platform](

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

	[PlatCode] [varchar](50) NULL,

	[PlatformName] [varchar](50) NULL,

	[Stacker] [varchar](50) NULL,

	[ExecutionMethod] [varchar](50) NULL,

	[PlatformType] [varchar](50) NULL,

	[Location] [varchar](50) NULL,

	[Capacity] [int] NULL,

	[Status] [varchar](50) NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[ProductionLine] [varchar](50) NULL,

	[DeviceCode] [varchar](50) NULL,

	[Roadway] [varchar](50) NULL,

 CONSTRAINT [PK_Dt_Platform_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_Router]    Script Date: 2026/4/1 19:34:20 ******/

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_StationManager]    Script Date: 2026/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_StationManager](

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

	[stationType] [int] NOT NULL,

	[stationDeviceCode] [varchar](50) NULL,

	[Roadway] [varchar](100) NULL,

	[stationChildCode] [varchar](255) NULL,

	[stationRemark] [varchar](255) NULL,

	[stationArea] [varchar](20) NULL,

	[stationLocation] [varchar](20) NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[remark] [varchar](255) NULL,

	[stationStatus] [varchar](20) NULL,

	[stationFloor] [varchar](255) NULL,

 CONSTRAINT [PK_Dt_StationManager_stationID] PRIMARY KEY CLUSTERED 

(

	[stationID] 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/4/1 19:34:20 ******/

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](50) NOT NULL,

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

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

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

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NOT NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[AGVSign] [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/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Dt_Task_Hty](

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

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

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

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

	[TaskType] [int] NOT NULL,

	[TaskState] [int] NOT NULL,

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

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

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

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

	[ExceptionMessage] [varchar](500) NULL,

	[Grade] [int] NOT NULL,

	[Dispatchertime] [datetime] NULL,

	[Remark] [varchar](255) NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

	[AGVSign] [varchar](255) NULL,

 CONSTRAINT [PK_Dt_Task_Hty_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_TaskExecuteDetail]    Script Date: 2026/4/1 19:34:20 ******/

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_Config]    Script Date: 2026/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Config](

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

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

	[ConfigValue] [text] NOT NULL,

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

	[Remark] [varchar](255) NULL,

	[SortCode] [int] NULL,

	[Status] [varchar](20) NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK_Sys_Config_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] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_DelLog]    Script Date: 2026/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_DelLog](

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

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

	[Url] [varchar](255) NULL,

	[IntervalTime] [int] NULL,

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

	[CreateDate] [datetime] NOT NULL,

	[Modifier] [varchar](255) NULL,

	[ModifyDate] [datetime] NULL,

 CONSTRAINT [PK__Sys_DelL__3214EC078D4DA87C] 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_Department]    Script Date: 2026/4/1 19:34:20 ******/

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

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Dictionary]    Script Date: 2026/4/1 19:34:20 ******/

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/4/1 19:34:20 ******/

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

) ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Log]    Script Date: 2026/4/1 19:34:20 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Sys_Log](

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

	[BeginDate] [datetime] NULL,

	[ElapsedTime] [int] NULL,

	[EndDate] [datetime] NULL,

	[RequestParam] [varchar](max) NULL,

	[ResponseParam] [varchar](max) NULL,

	[Success] [int] NULL,

	[Url] [varchar](max) NULL,

	[UserIP] [varchar](200) NULL,

	[UserName] [varchar](200) 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] TEXTIMAGE_ON [PRIMARY]

GO

/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2026/4/1 19:34:20 ******/

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/4/1 19:34:20 ******/

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/4/1 19:34:20 ******/

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/4/1 19:34:20 ******/

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/4/1 19:34:20 ******/

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'OtherDevice', N'
NMO:g', N'OtherDevice', N'1', N'127.0.0.1', 502, N'ModbusTcp', NULL, N'System', CAST(N'2025-09-22T10:47:31.000' AS DateTime), NULL, NULL, 1)

SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] OFF

GO

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'OtherDevice', N'500', CAST(0.0 AS Decimal(10, 1)), N'int', 1, N'Heart', N'ReadDeviceCommand', N'Ã_ó', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, 1, N'OtherDevice', N'502', CAST(2.0 AS Decimal(10, 1)), N'int', 1, N'FaultBit', N'ReadDeviceCommand', N'Ee¶r`hÆ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, 1, N'OtherDevice', N'504', CAST(4.0 AS Decimal(10, 1)), N'int', 1, N'FaultCode', N'ReadDeviceCommand', N'Eex', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, 1, N'OtherDevice', N'1000', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'UpPosition', N'ReadDeviceCommand', N'
NeMOnáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, 1, N'OtherDevice', N'1002', CAST(0.0 AS Decimal(10, 1)), N'int', 1, N'UpRequest', N'ReadDeviceCommand', N'
Ne÷Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, 1, N'OtherDevice', N'1004', CAST(2.0 AS Decimal(10, 1)), N'int', 1, N'UpReplyRequest', N'DeviceCommand', N'ÞV
Y÷Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, 1, N'OtherDevice', N'1006', CAST(4.0 AS Decimal(10, 1)), N'int', 1, N'RequestPut', N'DeviceCommand', N'÷Bl
Ne:g>ee', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, 1, N'OtherDevice', N'1008', CAST(6.0 AS Decimal(10, 1)), N'int', 1, N'AllowPut', N'ReadDeviceCommand', N'
Ne:gAQ¸>ee', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, 1, N'OtherDevice', N'1010', CAST(8.0 AS Decimal(10, 1)), N'int', 1, N'PutFinish', N'DeviceCommand', N'AGV>ee[b', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, 1, N'OtherDevice', N'1012', CAST(10.0 AS Decimal(10, 1)), N'int', 1, N'UpFaultBit', N'ReadDeviceCommand', N'Ee¶r`hÆ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, 1, N'OtherDevice', N'1014', CAST(12.0 AS Decimal(10, 1)), N'int', 1, N'UpFaultCode', N'ReadDeviceCommand', N'Eex', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, 1, N'OtherDevice', N'1016', CAST(14.0 AS Decimal(10, 1)), N'string', 25, N'UpBarcode', N'ReadDeviceCommand', N'agxáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, 1, N'OtherDevice', N'1067', CAST(16.0 AS Decimal(10, 1)), N'string', 1, N'UpErrorMessage', N'ReadDeviceCommand', N'_8^mo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, 1, N'OtherDevice', N'2000', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'DownPosition', N'DeviceCommand', N'NeMOnáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, 1, N'OtherDevice', N'2002', CAST(24.0 AS Decimal(10, 1)), N'int', 1, N'DownRequest', N'Reset', N'Ne÷Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (45, 1, N'OtherDevice', N'2004', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'DownReplyRequest', N'DeviceCommand', N'ÞV
Y÷Bl', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (46, 1, N'OtherDevice', N'2006', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'RequestPickUp', N'DeviceCommand', N'÷Bl
Ne:gÖSe', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (47, 1, N'OtherDevice', N'2008', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'AllowPickUp', N'DeviceCommand', N'
Ne:gAQ¸ÖSe', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (48, 1, N'OtherDevice', N'2010', CAST(24.0 AS Decimal(10, 1)), N'int', 1, N'PickUpFinish', N'Reset', N'AGVÖSe[b', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (50, 1, N'OtherDevice', N'2012', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'DownFaultBit', N'DeviceCommand', N'Ee¶r`hÆ', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (51, 1, N'OtherDevice', N'2014', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'DownFaultCode', N'DeviceCommand', N'Eex', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (52, 1, N'OtherDevice', N'2016', CAST(18.0 AS Decimal(10, 1)), N'string', 25, N'DownBarcode', N'DeviceCommand', N'agxáOo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (53, 1, N'OtherDevice', N'2067', CAST(24.0 AS Decimal(10, 1)), N'string', 1, N'DownErrorMessage', N'Reset', N'_8^mo`', N'', N'admin', CAST(N'2025-09-22T10:50:39.000' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] OFF

GO

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'OtherDevice', N'StackerCraneAutoStatus', N'ShutDown', N'0', N'å]\O!j_(0:\P:g)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'OtherDevice', N'StackerCraneAutoStatus', N'Manual', N'1', N'å]\O!j_(1:Kb¨R	ÿ', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'OtherDevice', N'StackerCraneAutoStatus', N'Automatic', N'2', N'å]\O!j_(2:ê¨R)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'OtherDevice', N'StackerCraneAutoStatus', N'ComputerMode', N'3', N'å]\O!j_(3:5u!j_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'OtherDevice', N'StackerCraneWorkStatus', N'Standby', N'0', N'¾Y¶r`(0:_:g)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUpWalk', N'1', N'¾Y¶r`(1:ÖS'Lp)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUpWait', N'2', N'¾Y¶r`(2:ÖS'I{_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'OtherDevice', N'StackerCraneWorkStatus', N'PickUp', N'3', N'¾Y¶r`(3:ÖS'-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'OtherDevice', N'StackerCraneWorkStatus', N'PutWalk', N'4', N'¾Y¶r`(4:>e'Lp)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'OtherDevice', N'StackerCraneWorkStatus', N'PutWait', N'5', N'¾Y¶r`(5:>e'I{_)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'OtherDevice', N'StackerCraneWorkStatus', N'Puting', N'6', N'¾Y¶r`(6:>e'-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'OtherDevice', N'StackerCraneWorkStatus', N'ReturnOrigin', N'7', N'¾Y¶r`(7:ÞVS¹p)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'OtherDevice', N'StackerCraneWorkStatus', N'ReverseOrigin', N'8', N'¾Y¶r`(8:ÞVÍSS¹p)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'OtherDevice', N'StackerCraneWorkStatus', N'Walking', N'9', N'¾Y¶r`(9:pL-N)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'OtherDevice', N'StackerCraneWorkStatus', N'WorkCompleted', N'10', N'¾Y¶r`(10:ûN¡R[b)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (16, N'OtherDevice', N'StackerCraneWorkStatus', N'InStockStandby', N'11', N'¾Y¶r`(11:	g'_}T)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (17, N'OtherDevice', N'StackerCraneWorkStatus', N'Warning', N'99', N'¾Y¶r`(99:¥bf)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'OtherDevice', N'StackerCraneWorkStatus', N'Maintenance', N'100', N'¾Y¶r`(100:ô~îO)', NULL, N'admin', CAST(N'2024-09-02T15:11:51.770' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] OFF

GO

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'
NMO:g', N'OtherDevice', N'WIDESEAWCS_Tasks', N'CommonOtherDevicesJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime))

INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'¿~', N'CommonConveyorLine', N'WIDESEAWCS_Tasks', N'CommonConveyorLineJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime))

INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'åe×_', N'DelLog', N'WIDESEAWCS_Tasks', N'CommonDeleteLogJob', 86400, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime))

INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'AGV', N'AGVTask', N'WIDESEAWCS_Tasks', N'CommonAGVJob', 2, NULL, NULL, NULL, N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime), N'admin', CAST(N'2025-09-26T10:21:57.300' AS DateTime))

SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] OFF

GO

SET IDENTITY_INSERT [dbo].[Sys_Config] ON 



INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'WMSIPBASE', N'http://127.0.0.1:5000', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'AGVIPBASE', N'http://10.31.1.188:7000', N'SYS_IPAddress', NULL, NULL, NULL, N'admin', CAST(N'2025-09-24T08:59:26.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'GetAGVTask', N'/ics/out/task/getTaskOrderStatus', N'SYS_IPAddress', N'AGVûN¡Rågâ¥cãS', NULL, NULL, N'admin', CAST(N'2025-09-24T09:00:49.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'SendAGVTask', N'/ics/taskOrder/addTask', N'SYS_IPAddress', N'AGVûN¡RNÑS', NULL, NULL, N'admin', CAST(N'2025-09-24T09:03:05.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'ContinueAGVTask', N'/ics/out/task/continueTask', N'SYS_IPAddress', N'AGVûN¡Rç~í~', NULL, NULL, N'admin', CAST(N'2025-09-24T09:05:17.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'CancelAVTask', N'/ics/out/task/cancelTask', N'SYS_IPAddress', N'AGVÖSmûN¡R', NULL, NULL, N'admin', CAST(N'2025-09-24T09:06:21.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'GetAVGStatus', N'/ics/out/device/list/deviceInfo', N'SYS_IPAddress', N'·ÖSAGV¶r`', NULL, NULL, N'admin', CAST(N'2025-09-24T09:08:35.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'PauseAGVTask', N'/ics/out/controlDevice', N'SYS_IPAddress', N'f\P/b`
YAGV', NULL, NULL, N'admin', CAST(N'2025-09-24T09:10:08.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'AcrossFloorTask', N'/api/Task/AcrossFloorTaskAsync', N'SYS_IPAddress', N'·ÖSè|iB\2ûN¡R', NULL, NULL, N'admin', CAST(N'2025-10-09T20:42:12.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'CompleteTask', N'/api/Task/CompleteTaskAsync', N'SYS_IPAddress', N'ûN¡R[b', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'UpdateTaskStatus', N'/api/Task/UpdateTaskStatus', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (19, N'AcrossFloorTask', N'/api/Task/AcrossFloorTaskAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (20, N'StackerIsNeedRelocation', N'/api/Task/StackerIsNeedRelocationAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (21, N'AGVIsNeedRelocation', N'/api/Task/AGVIsNeedRelocationAsync', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (22, N'UpdateStartLocationInfo', N'/api/Task/UpdateStartLocationInfo', N'SYS_IPAddress', N'', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (23, N'RequestLocation', N'/api/Task/RequestLocation', N'SYS_IPAddress', N'÷Bl'MO', 1, N'1', N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime))

SET IDENTITY_INSERT [dbo].[Sys_Config] OFF

GO

SET IDENTITY_INSERT [dbo].[Sys_DelLog] ON 



INSERT [dbo].[Sys_DelLog] ([Id], [FileName], [Url], [IntervalTime], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'Log', NULL, 180, N'admin', CAST(N'2025-09-24T09:48:53.000' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DelLog] ([Id], [FileName], [Url], [IntervalTime], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'Log_PLCReadWrite', NULL, 180, N'admin', CAST(N'2025-09-24T09:52:45.000' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_DelLog] OFF

GO

SET IDENTITY_INSERT [dbo].[Sys_Department] ON 



INSERT [dbo].[Sys_Department] ([DepartmentId], [DepartmentName], [DepartmentCode], [ParentId], [DepartmentType], [Enable], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'Ym_lRè', N'1', 1, NULL, 1, NULL, N'admin', CAST(N'2025-04-02T14:36:09.000' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_Department] OFF

GO

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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' 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-09-02T15:11:30.070' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1003, NULL, NULL, NULL, N'¾Y¶r`', N'deviceStatus', 1, NULL, 0, NULL, 0, N'admin', CAST(N'2024-12-24T13:29:22.223' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_Dictionary] OFF

GO

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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' 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-09-02T15:11:31.613' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1003, N'y(u', N'0', 1003, NULL, NULL, NULL, N'admin', CAST(N'2024-12-24T13:29:22.230' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1004, N'/T(u', N'1', 1003, NULL, NULL, NULL, N'admin', CAST(N'2024-12-24T13:29:22.230' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1005, N'ZJ-5', N'ZJ-5', 1004, 1, NULL, NULL, N'xy', CAST(N'2025-02-12T16:54:39.823' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1006, N'ZJ-6', N'ZJ-6', 1004, 1, NULL, NULL, N'xy', CAST(N'2025-02-12T16:54:39.823' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1007, N'ZJ-7', N'ZJ-7', 1004, 1, NULL, NULL, N'xy', CAST(N'2025-02-12T16:54:39.823' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1008, N'ZJ-8', N'ZJ-8', 1004, 1, NULL, NULL, N'xy', CAST(N'2025-02-12T16:54:39.823' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1009, N'/T(u', N'Active', 1005, NULL, NULL, NULL, N'admin', CAST(N'2025-03-04T14:09:46.300' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1010, N'y(u', N'No', 1005, NULL, NULL, NULL, N'admin', CAST(N'2025-03-04T14:09:46.313' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] OFF

GO

SET IDENTITY_INSERT [dbo].[Sys_Log] ON 



INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (1, CAST(N'2026-03-24T10:16:08.470' AS DateTime), 537, CAST(N'2026-03-24T10:16:09.007' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'Status Code: 404; Not Found                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ', NULL, N'http://127.0.0.1:9291/api/Sys_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 (2, CAST(N'2026-03-24T10:16:17.777' AS DateTime), 1, CAST(N'2026-03-24T10:16:17.777' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"f2d7a5a0-97b1-4b33-9e06-53f1386fb5fb\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'Status Code: 404; Not Found                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ', NULL, N'http://127.0.0.1:9291/api/Sys_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 (3, CAST(N'2026-03-24T10:16:26.433' AS DateTime), 0, CAST(N'2026-03-24T10:16:26.433' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"c770e6ed-6bb4-4230-9b67-a91e913539c6\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'Status Code: 404; Not Found                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    ', NULL, N'http://127.0.0.1:9291/api/Sys_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 (4, CAST(N'2026-03-24T10:17:16.893' AS DateTime), 462, CAST(N'2026-03-24T10:17:17.357' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"4c2b6378-65ed-4357-bf65-064e1ed55e5e\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (5, CAST(N'2026-03-24T10:22:26.360' AS DateTime), 63, CAST(N'2026-03-24T10:22:26.423' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"af745be0-2ae5-4877-adef-13f6566563be\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (6, CAST(N'2026-03-24T10:23:17.803' AS DateTime), 829, CAST(N'2026-03-24T10:23:18.633' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (7, CAST(N'2026-03-24T10:47:41.253' AS DateTime), 157, CAST(N'2026-03-24T10:47:41.410' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"b15667b0-1657-4a29-bf0d-1c5be30f6e0a\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (1002, CAST(N'2026-03-27T10:40:51.173' AS DateTime), 180, CAST(N'2026-03-27T10:40:51.353' AS DateTime), N'{"QueryString":"","BodyData":"{\"UUID\":\"95d655b4-42f7-4045-bd0c-6c67e4e2ab14\",\"passWord\":\"123456\",\"userName\":\"admin\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (2002, CAST(N'2026-03-30T12:13:32.870' AS DateTime), 193, CAST(N'2026-03-30T12:13:33.063' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"3d0ef551-6164-4d14-8efd-2c9ac6b4e9be\"}"}', N'{"status":false,"code":0,"message":"àe{vU_CgP","data":null,"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 (2003, CAST(N'2026-03-30T12:13:36.523' AS DateTime), 62, CAST(N'2026-03-30T12:13:36.587' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"4ac5fddf-f3c9-486d-b517-3abc7683c754\"}"}', N'{"status":false,"code":0,"message":"àe{vU_CgP","data":null,"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 (2004, CAST(N'2026-03-30T12:13:37.227' AS DateTime), 44, CAST(N'2026-03-30T12:13:37.270' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"4486e9e9-3393-4904-b0a2-a9b14823897f\"}"}', N'{"status":false,"code":0,"message":"àe{vU_CgP","data":null,"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 (2005, CAST(N'2026-03-30T12:13:37.847' AS DateTime), 39, CAST(N'2026-03-30T12:13:37.883' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"f046c942-47bd-48fb-b913-85b57c33245b\"}"}', N'{"status":false,"code":0,"message":"àe{vU_CgP","data":null,"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 (2006, CAST(N'2026-03-30T12:19:18.230' AS DateTime), 9868, CAST(N'2026-03-30T12:19:28.097' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (2007, CAST(N'2026-03-30T12:25:03.717' AS DateTime), 5557, CAST(N'2026-03-30T12:25:09.273' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"0cd6619d-7d8d-4e03-bd2b-c780f7d5149f\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (2008, CAST(N'2026-03-30T12:29:18.930' AS DateTime), 34, CAST(N'2026-03-30T12:29:18.963' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"ea74e375-2ae9-4fd8-993a-7e09ace6eac4\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"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 (2009, CAST(N'2026-03-30T14:19:25.920' AS DateTime), 486, CAST(N'2026-03-30T14:19:26.407' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"24501cf4-0d53-4f75-81e1-adc34e6609b7\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"[REDACTED],"userName":"admin","img":null},"devMessage":null}', NULL, N'http://localhost:9291/api/User/login', N'::1', N'', NULL)

INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (2010, CAST(N'2026-03-30T14:34:43.987' AS DateTime), 5376, CAST(N'2026-03-30T14:34:49.363' AS DateTime), N'{"QueryString":"","BodyData":"{\"name\":\"admin\",\"pwd\":\"123456\"}"}', N'{"result":true}', NULL, N'http://localhost:9291/api/User/swgLogin', N'::1', N'admin', NULL)

SET IDENTITY_INSERT [dbo].[Sys_Log] OFF

GO

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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Log', 8, N'/Sys_Log/Manager', 0, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-11-10T09:32:44.977' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-02-15T14:31:54.180' 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, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' 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"},{"text":"ü[úQ","value":"Export"},{"text":"ÞVÚn0R
NNek","value":"Previous"},{"text":"ól0RNNek","value":"Next"}]', N'el-icon-date', NULL, 1, N'Dt_Task', 12, N'/task', 500, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-02-18T10:46:07.377' 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, 2, N'Dt_DeviceProtocol', 10, N'/deviceProtocol', 500, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-11-03T10:10:06.000' 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, 2, N'Dt_DeviceProtocolDetail', 10, N'/deviceProtocolDetail', 500, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-11-03T10:10:03.340' 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, 2, N'Dt_DispatchInfo', 10, N'/dispatchInfo', 500, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-11-03T10:10:00.503' 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'/', 0, N'/', 7000, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-11-03T10:09:48.010' 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":"ågwhQèï1u","value":"ViewAllRouter"},{"text":"ï1uMn","value":"AddRouters"}]', N'el-icon-date', NULL, 1, N'Dt_Router', 17, N'/router', 500, 0, N'admin', CAST(N'2024-09-02T15:11:32.987' AS DateTime), N'admin', CAST(N'2025-02-11T17:02:25.490' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1001, N'¾Y¡{t', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-coin', NULL, 0, N'/', 0, N'/', 0, 0, N'admin', CAST(N'2025-01-04T15:51:10.383' AS DateTime), N'admin', CAST(N'2025-11-10T09:26:27.810' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1002, N'¾YáOo`', N'[{"text":"ågâ","value":"Search"}]', N'', NULL, 1, N'indexLibrary', 1001, N'/indexLibrary', 0, 0, N'admin', CAST(N'2025-01-04T15:52:06.730' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1005, N'ûN¡RSòSáOo`', N'[{"text":"ågâ","value":"Search"}]', N'', N'', 1, N'/task_hty', 12, N'task_hty', 0, 0, N'admin', CAST(N'2024-12-16T14:26:25.010' AS DateTime), N'', CAST(N'1900-01-01T00:00:00.000' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1008, N'eQ^', N'[{"text":"ågâ","value":"Search"}]', N'search', NULL, 1, N'/', 29, N'pages/Inbound/Inbound', 2000, 1, N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime), N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1009, N'úQ^', N'[{"text":"ågâ","value":"Search"}]', N'search', NULL, 1, N'/', 29, N'pages/Outbound/Outbound', 2000, 1, N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime), N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1010, N'zzXb¡{t', N'[{"text":"ågâ","value":"Search"}]', N'search', NULL, 1, N'/', 29, N'pages/Empty/Empty', 2000, 1, N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime), N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1011, N'¹pù[¹p,dÐ', N'[{"text":"ågâ","value":"Search"}]', N'search', NULL, 1, N'/', 29, N'pages/Point/Point', 2000, 1, N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime), N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime))

INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1012, N'(ÀhûN¡R', N'[{"text":"ågâ","value":"Search"}]', N'search', NULL, 1, N'/', 29, N'pages/Quality/Quality', 2000, 1, N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime), N'§~¡{tXT', CAST(N'2024-08-23T16:38:18.000' AS DateTime))

SET IDENTITY_INSERT [dbo].[Sys_Menu] OFF

GO

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-09-02T15:11:34.210' AS DateTime), N'admin', CAST(N'2024-04-29T13:53:44.717' AS DateTime))

INSERT [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1001, NULL, 1, 1, N'1§~CgP', N'admin', CAST(N'2025-05-19T13:44:11.170' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1002, NULL, 1, 1, N'2§~CgP', N'admin', CAST(N'2025-05-19T13:44:20.103' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1003, NULL, 1, 1, N'3§~CgP', N'admin', CAST(N'2025-05-19T13:44:32.693' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_Role] OFF

GO

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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' 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-09-02T15:11:35.220' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1136, N'Search', 10, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.057' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1137, N'Search', 13, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.057' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1138, N'Search', 11, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.057' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1139, N'Search', 14, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.057' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1140, N'Search', 15, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.060' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1141, N'Search', 1005, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.060' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1142, N'Search', 1006, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.060' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1143, N'Search', 1007, 1001, NULL, N'admin', CAST(N'2025-05-19T13:44:58.060' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1144, N'Search,Add,Delete,Update,Import,Export', 10, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.443' AS DateTime), N'admin', CAST(N'2025-06-26T19:42:37.400' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1145, N'Search,Add,Delete,Update', 12, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.447' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.937' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1146, N'Search,Delete,Update', 17, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.447' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.937' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1147, N'Search,Delete,Update,Previous,Next', 13, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.447' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.937' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1148, N'Update', 11, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.450' AS DateTime), N'admin', CAST(N'2025-06-26T19:42:37.407' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1149, N'', 14, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.450' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.960' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1150, N'', 15, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.453' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.963' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1151, N'', 16, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.453' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.963' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1152, N'Search', 1005, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.453' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1153, N'Add,Update', 1006, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.453' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.937' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1154, N'Update', 1007, 1002, NULL, N'admin', CAST(N'2025-05-19T13:45:25.453' AS DateTime), N'admin', CAST(N'2025-06-26T19:44:24.937' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1155, N'Import,Export', 10, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.750' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1156, N'Search,Delete', 12, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.750' AS DateTime), N'admin', CAST(N'2025-05-23T19:43:14.737' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1157, N'Search,Delete,Update,Export,Next', 13, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), N'admin', CAST(N'2025-05-23T19:43:14.737' AS DateTime))

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1158, N'Search', 11, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1159, N'Search', 14, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1160, N'Search', 15, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1161, N'Search', 16, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1162, N'Search', 1005, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1163, N'Search,Add', 1006, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.757' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1164, N'Search', 1007, 1003, NULL, N'admin', CAST(N'2025-05-19T13:46:32.757' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1165, N'Search', 12, 1001, NULL, N'admin', CAST(N'2025-05-19T18:09:14.550' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1166, N'Search,Delete,Update,Import,Export', 12, 1003, NULL, N'admin', CAST(N'2025-05-23T19:41:35.077' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1169, N'Search,Add,Delete,Update,Import,Export', 10, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.427' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1170, N'Search,Delete,Update,Import,Export', 12, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.430' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1171, N'Search,Delete,Update,Import,Export', 17, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.433' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1172, N'Search', 1, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.433' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1173, N'Search,Add,Delete,Update,Import', 3, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.433' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1174, N'Search,Add,Delete,Update,Import', 4, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.437' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1175, N'Search,Delete,Export,Previous,Next', 13, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.437' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1176, N'Update', 11, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.437' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1177, N'Search,Update', 1006, 1002, NULL, N'admin', CAST(N'2025-06-26T19:42:37.437' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1178, N'Search,Add,Delete,Update', 12, 1002, NULL, N'admin', CAST(N'2025-06-26T19:44:24.950' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1179, N'Search,Delete,Update', 17, 1002, NULL, N'admin', CAST(N'2025-06-26T19:44:24.950' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1180, N'Search,Delete,Update,Previous,Next', 13, 1002, NULL, N'admin', CAST(N'2025-06-26T19:44:24.953' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1181, N'Add,Update', 1006, 1002, NULL, N'admin', CAST(N'2025-06-26T19:44:24.953' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1182, N'Update', 1007, 1002, NULL, N'admin', CAST(N'2025-06-26T19:44:24.953' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1167, N'Search,Delete', 12, 1003, NULL, N'admin', CAST(N'2025-05-23T19:43:14.753' AS DateTime), NULL, NULL)

INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1168, N'Search,Delete,Update,Export,Next', 13, 1003, NULL, N'admin', CAST(N'2025-05-23T19:43:14.753' AS DateTime), NULL, NULL)

SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] OFF

GO

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, NULL, NULL, NULL, N'j79rYYvCz4vdhcboB1Ausg==', N'admin', NULL, NULL, NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'admin', CAST(N'2025-05-19T13:43:06.000' AS DateTime), N'admin', CAST(N'2025-07-02T21:03:03.997' AS DateTime))

SET IDENTITY_INSERT [dbo].[Sys_User] OFF

GO

SET ANSI_PADDING ON

GO

/****** Object:  Index [XbØv÷S]    Script Date: 2026/4/1 19:34:20 ******/

ALTER TABLE [dbo].[Dt_Task] ADD  CONSTRAINT [XbØv÷S] UNIQUE NONCLUSTERED 

(

	[PalletCode] ASC

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

GO

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'¦^ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DispatchId'

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_Platform', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS÷Sÿ/UNhÆÏk*NÙzðSv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'PlatCode'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'PlatformName'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ù[^XW:g' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'Stacker'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gbL¹eÕl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'ExecutionMethod'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'PlatformType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðSMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'Location'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS¹[Ï' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'Capacity'

GO

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

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @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_Platform', @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_Platform', @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_Platform', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'u§N§N¿~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'ProductionLine'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ù[^PLC÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform', @level2type=N'COLUMN',@level2name=N'DeviceCode'

GO

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

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Yå]zÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Platform'

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_StationManager', @level2type=N'COLUMN',@level2name=N'stationID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÙzðS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationType'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'@b^\PLC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationDeviceCode'

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_StationManager', @level2type=N'COLUMN',@level2name=N'Roadway'

GO

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

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_StationManager', @level2type=N'COLUMN',@level2name=N'stationRemark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y:SßW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationArea'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PWh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationLocation'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @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_StationManager', @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_StationManager', @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_StationManager', @level2type=N'COLUMN',@level2name=N'ModifyDate'

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_StationManager', @level2type=N'COLUMN',@level2name=N'remark'

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'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationStatus'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'|iB\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_StationManager', @level2type=N'COLUMN',@level2name=N'stationFloor'

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_StationManager'

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'û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'ÖS>e'hÆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'AGVSign'

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'û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'ÖS>e'hÆ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_Hty', @level2type=N'COLUMN',@level2name=N'AGVSign'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RSòSá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';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'Id'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Mn.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'ConfigKey'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Mn<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'ConfigValue'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'R{|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'Category'

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_Config', @level2type=N'COLUMN',@level2name=N'Remark'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @level2type=N'COLUMN',@level2name=N'SortCode'

GO

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

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config', @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_Config', @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_Config', @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_Config', @level2type=N'COLUMN',@level2name=N'ModifyDate'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'û|ß~Mnh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Config'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eöN9Y
Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DelLog', @level2type=N'COLUMN',@level2name=N'FileName'

GO

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

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ôöeôÿUSMOÿdd	ÿ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DelLog', @level2type=N'COLUMN',@level2name=N'IntervalTime'

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

