USE [gs1_qilu_sap]
GO
/****** Object:  Table [dbo].[basic_company]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_company](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[companyName] [nvarchar](100) NOT NULL,
	[companyPrefix] [varchar](100) NOT NULL,
	[estate] [tinyint] NOT NULL CONSTRAINT [DF__basic_com__estat__3B75D760]  DEFAULT ((0)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__basic_com__creat__3C69FB99]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__basic_com__updat__3D5E1FD2]  DEFAULT (getdate()),
	[flagBit] [tinyint] NOT NULL CONSTRAINT [DF__basic_com__flagB__3E52440B]  DEFAULT ((0)),
	[poPrefix] [varchar](50) NULL CONSTRAINT [DF__basic_com__poPre__3F466844]  DEFAULT ('OA'),
	[partialFilterValue] [tinyint] NOT NULL DEFAULT ((0)),
	[partialThreshold] [int] NOT NULL DEFAULT ((1000)),
	[partialControlCode] [varchar](100) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[basic_level]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_level](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[levelCode] [tinyint] NOT NULL,
	[levelName] [nvarchar](50) NOT NULL,
	[estate] [tinyint] NOT NULL DEFAULT ((0)),
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate()),
	[levelMark] [varchar](50) NULL,
	[comments] [nvarchar](100) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[basic_line]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_line](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[lineName] [nvarchar](50) NOT NULL,
	[lineCode] [nvarchar](50) NOT NULL,
	[plantId] [int] NOT NULL CONSTRAINT [DF__basic_lin__plant__182C9B23]  DEFAULT ((0)),
	[lineIp] [varchar](50) NULL,
	[comments] [varchar](100) NULL,
	[estate] [tinyint] NOT NULL CONSTRAINT [DF__basic_lin__estat__1A14E395]  DEFAULT ((0)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__basic_lin__creat__1B0907CE]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__basic_lin__updat__1BFD2C07]  DEFAULT (getdate())
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[basic_plant]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_plant](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[plantName] [nvarchar](50) NOT NULL,
	[plantCode] [varchar](50) NOT NULL,
	[licNumber] [varchar](50) NULL,
	[licAgency] [varchar](50) NULL,
	[licState] [varchar](50) NULL,
	[gln] [varchar](50) NOT NULL,
	[street1] [nvarchar](100) NULL,
	[street2] [nvarchar](100) NULL,
	[city] [nvarchar](50) NULL,
	[district] [nvarchar](50) NULL,
	[country] [nvarchar](50) NULL,
	[email] [varchar](100) NULL,
	[estate] [tinyint] NOT NULL CONSTRAINT [DF__basic_pla__estat__24927208]  DEFAULT ((0)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__basic_pla__creat__25869641]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__basic_pla__updat__267ABA7A]  DEFAULT (getdate()),
	[stateOrRegion] [nvarchar](100) NULL,
	[postCode] [varchar](50) NULL,
	[sgln] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[basic_product]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_product](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[companyId] [int] NOT NULL CONSTRAINT [DF__products__compan__619B8048]  DEFAULT ((0)),
	[plantId] [int] NOT NULL CONSTRAINT [DF__products__plantI__628FA481]  DEFAULT ((0)),
	[productName] [nvarchar](100) NOT NULL,
	[productCode] [varchar](100) NOT NULL,
	[ndc] [varchar](50) NOT NULL,
	[material] [varchar](50) NULL,
	[dosageForm] [varchar](50) NULL,
	[dosageUsage] [varchar](50) NULL,
	[strength] [varchar](50) NULL,
	[packageSize] [varchar](50) NULL,
	[generic] [varchar](50) NULL,
	[composition] [varchar](50) NULL,
	[unitPrice] [varchar](50) NULL,
	[description] [varchar](100) NULL,
	[scheduled] [tinyint] NOT NULL CONSTRAINT [DF__products__schedu__6477ECF3]  DEFAULT ((0)),
	[imageDir] [varchar](500) NULL,
	[receiverCode] [varchar](100) NULL,
	[remark] [varchar](1000) NULL,
	[primaryCount] [int] NOT NULL CONSTRAINT [DF__products__primar__656C112C]  DEFAULT ((0)),
	[productType] [tinyint] NOT NULL CONSTRAINT [DF__products__produc__66603565]  DEFAULT ((0)),
	[country] [varchar](50) NULL,
	[packageRules] [nvarchar](2000) NULL,
	[estate] [tinyint] NOT NULL CONSTRAINT [DF__products__estate__6754599E]  DEFAULT ((0)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__products__create__68487DD7]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__products__update__693CA210]  DEFAULT (getdate()),
	[packageRatio] [varchar](50) NOT NULL,
	[shelfLife] [int] NOT NULL CONSTRAINT [DF__basic_pro__shelf__31EC6D26]  DEFAULT ((0)),
	[productCodeType] [varchar](50) NULL,
	[productCodeValue] [varchar](50) NULL,
	[eancode] [varchar](50) NULL,
	[sendStatus] [int] NOT NULL DEFAULT ((0)),
	[dateFormat] [varchar](20) NULL DEFAULT ('YYYY/MM/DD'),
	[codeStyle] [varchar](50) NOT NULL DEFAULT ('tracelink'),
	[printFrom] [varchar](255) NULL,
	[printLogo] [varchar](255) NULL,
	[printMarket] [varchar](255) NULL,
	[packageSpec] [varchar](100) NULL,
	[recipeNo] [varchar](50) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[basic_product_gtin]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[basic_product_gtin](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[productCode] [varchar](100) NOT NULL,
	[resCode] [varchar](20) NULL,
	[levelCode] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ldap_config]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ldap_config](
	[host] [varchar](200) NOT NULL,
	[port] [varchar](200) NOT NULL,
	[base_dn] [varchar](200) NOT NULL,
	[username] [varchar](200) NOT NULL,
	[password] [varchar](200) NOT NULL,
	[id] [int] IDENTITY(1,1) NOT NULL,
	[flag] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_order]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_order](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dataID] [int] NOT NULL,
	[poNumber] [varchar](50) NOT NULL,
	[productId] [int] NOT NULL,
	[plantId] [int] NOT NULL,
	[lineId] [int] NOT NULL,
	[batchNo] [varchar](50) NOT NULL,
	[makeDate] [datetime] NOT NULL,
	[validDate] [datetime] NOT NULL,
	[planAmount] [int] NOT NULL,
	[actualAmount] [int] NOT NULL,
	[packageRules] [nvarchar](1000) NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[method] [tinyint] NOT NULL,
	[poPrefix] [varchar](50) NOT NULL,
	[generateFlag] [tinyint] NOT NULL,
	[printMarket] [varchar](200) NULL,
	[printFrom] [varchar](200) NULL,
	[printLogo] [varchar](200) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_order_proof]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_order_proof](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderId] [int] NOT NULL,
	[batchNo] [varchar](50) NOT NULL,
	[stationName] [varchar](100) NOT NULL,
	[stationId] [varchar](100) NOT NULL,
	[proofFinished] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_order_request]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_order_request](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[batchNo] [varchar](50) NOT NULL,
	[packageRules] [nvarchar](2000) NOT NULL,
	[totalLevel] [int] NOT NULL,
	[amount] [int] NOT NULL,
	[estate] [tinyint] NOT NULL,
	[waitFlag] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[poNumber] [varchar](100) NOT NULL,
	[orderId] [int] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_order_send_log]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_order_send_log](
	[orderRequestId] [int] NOT NULL,
	[sendFilePath] [varchar](255) NULL,
	[senfFileBas64Path] [varchar](255) NULL,
	[estate] [int] NULL,
	[createTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_order_transfer]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_order_transfer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderId] [int] NOT NULL,
	[batch] [varchar](200) NOT NULL,
	[poNumber] [varchar](50) NOT NULL,
	[deliverNo] [varchar](50) NULL,
	[typeName] [nvarchar](50) NOT NULL,
	[typeKey] [varchar](50) NOT NULL,
	[typeNo] [varchar](5) NOT NULL,
	[codeFlag] [tinyint] NOT NULL,
	[updFile] [nvarchar](500) NULL,
	[errMsg] [nvarchar](500) NULL,
	[statusFlag] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[produce_repacking]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[produce_repacking](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[poNumber] [varchar](100) NOT NULL,
	[productId] [int] NOT NULL,
	[batchNo] [varchar](100) NOT NULL,
	[orderId] [int] NOT NULL,
	[makeDate] [datetime] NOT NULL,
	[validDate] [datetime] NOT NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[mode] [varchar](20) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sn_code]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sn_code](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dataID] [int] NOT NULL,
	[fileID] [int] NOT NULL,
	[resCode] [varchar](20) NOT NULL,
	[filterValue] [tinyint] NOT NULL,
	[code] [varchar](50) NOT NULL,
	[snCode] [varchar](30) NOT NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[codeStyle] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sn_generate]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sn_generate](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[resCode] [varchar](50) NOT NULL,
	[endNo] [int] NOT NULL,
	[flagBit] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sn_record]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sn_record](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dataID] [int] NOT NULL,
	[plantId] [int] NOT NULL,
	[resCode] [varchar](20) NOT NULL,
	[filterValue] [tinyint] NOT NULL,
	[typeFlag] [int] NOT NULL,
	[amount] [int] NOT NULL,
	[freeAmount] [int] NOT NULL,
	[SNFile] [nvarchar](500) NOT NULL,
	[accountType] [varchar](10) NOT NULL,
	[uid] [int] NOT NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[codeStyle] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_deploy]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_deploy](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[deployName] [nvarchar](50) NOT NULL,
	[deployCode] [varchar](50) NOT NULL,
	[deployValue] [varchar](1000) NOT NULL,
	[estate] [tinyint] NOT NULL DEFAULT ((0)),
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_dictionary]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_dictionary](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dictName] [nvarchar](50) NOT NULL,
	[dictCode] [varchar](50) NOT NULL,
	[sortNumber] [int] NOT NULL,
	[comments] [varchar](100) NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_dictionary_data]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_dictionary_data](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dictDataName] [nvarchar](50) NOT NULL,
	[dictDataCode] [varchar](50) NOT NULL,
	[dictId] [int] NOT NULL,
	[sortNumber] [int] NOT NULL,
	[comments] [varchar](100) NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_history_password]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_history_password](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NOT NULL,
	[password] [varchar](255) NULL,
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_login_record]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_login_record](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NOT NULL,
	[nickname] [nvarchar](50) NULL,
	[clientIp] [varchar](50) NOT NULL CONSTRAINT [DF__sys_login__clien__6754599E]  DEFAULT ('127.0.0.1'),
	[device] [varchar](50) NULL,
	[os] [varchar](50) NULL,
	[browser] [varchar](50) NULL,
	[comments] [nvarchar](100) NULL,
	[loginType] [tinyint] NOT NULL CONSTRAINT [DF__sys_login__login__68487DD7]  DEFAULT ((0)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__sys_login__creat__693CA210]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__sys_login__updat__6A30C649]  DEFAULT (getdate()),
	[origin] [tinyint] NOT NULL CONSTRAINT [DF__sys_login__origi__6B24EA82]  DEFAULT ((2))
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_menu]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_menu](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[parentId] [int] NOT NULL DEFAULT ((0)),
	[title] [nvarchar](50) NOT NULL,
	[en_title] [varchar](100) NULL,
	[path] [varchar](50) NULL,
	[icon] [varchar](50) NULL,
	[component] [varchar](50) NULL,
	[menuType] [tinyint] NOT NULL DEFAULT ((0)),
	[authority] [varchar](50) NULL,
	[sortNumber] [int] NOT NULL DEFAULT ((0)),
	[hide] [tinyint] NOT NULL DEFAULT ((0)),
	[active] [varchar](50) NULL,
	[target] [varchar](50) NOT NULL DEFAULT ('_self'),
	[closeable] [tinyint] NOT NULL DEFAULT ((0)),
	[tabUnique] [tinyint] NOT NULL DEFAULT ((0)),
	[meta] [varchar](255) NULL,
	[color] [varchar](50) NULL,
	[hideFooter] [tinyint] NOT NULL DEFAULT ((1)),
	[hideSidebar] [tinyint] NOT NULL DEFAULT ((1)),
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate()),
	[origin] [tinyint] NOT NULL DEFAULT ((2)),
	[apiRoute] [varchar](100) NULL,
	[estate] [tinyint] NOT NULL DEFAULT ((0))
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_operate_record]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_operate_record](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NOT NULL,
	[nickname] [nvarchar](50) NULL,
	[clientIp] [varchar](50) NOT NULL,
	[device] [varchar](50) NULL,
	[os] [varchar](50) NULL,
	[browser] [varchar](50) NULL,
	[module] [varchar](100) NOT NULL,
	[means] [varchar](100) NULL,
	[direction] [varchar](100) NULL,
	[manner] [varchar](20) NULL,
	[spendTime] [int] NOT NULL,
	[modus] [varchar](500) NULL,
	[parameter] [nvarchar](max) NULL,
	[outcome] [nvarchar](max) NULL,
	[mistake] [nvarchar](500) NULL,
	[comments] [nvarchar](max) NULL,
	[estate] [tinyint] NOT NULL,
	[tenanId] [int] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[origin] [tinyint] NOT NULL,
	[keyword] [varchar](50) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_organization]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_organization](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[organizationName] [nvarchar](50) NOT NULL,
	[organizationFullName] [nvarchar](100) NOT NULL,
	[parentId] [int] NOT NULL,
	[organizationCode] [varchar](50) NULL,
	[organizationType] [varchar](50) NOT NULL,
	[sortNumber] [int] NOT NULL,
	[comments] [varchar](100) NULL,
	[tenantId] [int] NOT NULL,
	[leaderId] [int] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_role]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_role](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[roleName] [varchar](50) NOT NULL,
	[roleCode] [varchar](50) NOT NULL,
	[comments] [varchar](100) NULL,
	[estate] [tinyint] NOT NULL DEFAULT ((0)),
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_role_menu]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_role_menu](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[roleId] [int] NOT NULL,
	[menuId] [int] NOT NULL,
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[sys_user]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[sys_user](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[username] [varchar](50) NOT NULL,
	[password] [varchar](255) NULL,
	[nickname] [nvarchar](50) NOT NULL,
	[organizationId] [int] NOT NULL DEFAULT ((0)),
	[avatar] [varchar](255) NULL,
	[sex] [tinyint] NOT NULL DEFAULT ((0)),
	[phone] [varchar](50) NULL,
	[email] [varchar](50) NULL,
	[card] [varchar](50) NULL,
	[birthday] [datetime] NULL,
	[introduction] [nvarchar](100) NULL,
	[estate] [tinyint] NOT NULL DEFAULT ((0)),
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate()),
	[lastToken] [varchar](500) NULL,
	[lastLoginTime] [datetime] NULL,
	[inside] [tinyint] NOT NULL DEFAULT ((0))
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[sys_user_role]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[sys_user_role](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userId] [int] NOT NULL,
	[roleId] [int] NOT NULL,
	[createTime] [datetime] NOT NULL DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL DEFAULT (getdate())
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[transit_code]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
CREATE TABLE [dbo].[transit_code](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[dataID] [int] NOT NULL,
	[poNumber] [varchar](50) NOT NULL,
	[productCode] [varchar](100) NOT NULL,
	[orderId] [int] NOT NULL,
	[batchNo] [varchar](50) NOT NULL,
	[levelCode] [tinyint] NOT NULL,
	[levelName] [nvarchar](50) NOT NULL,
	[resCode] [varchar](20) NOT NULL,
	[snCode] [varchar](30) NOT NULL,
	[code] [varchar](50) NOT NULL,
	[amount] [int] NOT NULL,
	[parentCode] [varchar](50) NULL,
	[boxCode] [varchar](50) NULL,
	[palletCode] [varchar](50) NULL,
	[typeFlag] [tinyint] NOT NULL,
	[reqID] [int] NOT NULL,
	[codeFlag] [tinyint] NOT NULL,
	[boxFlag] [tinyint] NOT NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[fileID] [int] NOT NULL
) ON [PRIMARY]
SET ANSI_PADDING ON
ALTER TABLE [dbo].[transit_code] ADD [helperCode] [varchar](50) NULL
ALTER TABLE [dbo].[transit_code] ADD [zeroBox] [tinyint] NOT NULL
ALTER TABLE [dbo].[transit_code] ADD [qualityLevel] [varchar](50) NULL
ALTER TABLE [dbo].[transit_code] ADD [field1] [varchar](50) NULL
ALTER TABLE [dbo].[transit_code] ADD [field2] [varchar](50) NULL

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[transit_code_temporary]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[transit_code_temporary](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[orderId] [int] NOT NULL,
	[code] [varchar](50) NOT NULL,
	[levelCode] [int] NOT NULL,
	[amount] [int] NULL,
	[parentCode] [varchar](50) NULL,
	[boxCode] [varchar](50) NULL,
	[palletCode] [varchar](50) NULL,
	[boxFlag] [int] NOT NULL,
	[codeStatus] [int] NOT NULL,
	[codeFlag] [int] NOT NULL,
	[updateTime] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ware_code]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ware_code](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[wareCode] [varchar](50) NULL,
	[code] [varchar](50) NULL,
	[levelCode] [varchar](50) NULL,
	[leveName] [varchar](100) NULL,
	[typeFlag] [int] NULL,
	[productID] [int] NULL,
	[orderID] [int] NULL,
	[batchNo] [varchar](50) NULL,
	[poNumber] [varchar](50) NULL,
	[scanTime] [datetime] NULL,
	[createTime] [datetime] NULL,
	[wareID] [int] NULL,
	[type] [char](1) NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ware_customer]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ware_customer](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[cusCode] [varchar](50) NOT NULL,
	[parentCode] [varchar](50) NOT NULL DEFAULT ((0)),
	[cusName] [nvarchar](50) NOT NULL,
	[mobile] [varchar](50) NULL,
	[email] [nvarchar](50) NULL,
	[gln] [varchar](50) NULL,
	[postCode] [varchar](50) NOT NULL,
	[country] [varchar](100) NOT NULL,
	[state] [varchar](100) NOT NULL,
	[city] [varchar](100) NOT NULL,
	[district] [varchar](100) NOT NULL,
	[street] [varchar](100) NOT NULL,
	[typeFlag] [tinyint] NOT NULL CONSTRAINT [DF__ware_cust__typeF__1AD3FDA4]  DEFAULT ((0)),
	[estate] [tinyint] NOT NULL CONSTRAINT [DF__ware_cust__estat__1BC821DD]  DEFAULT ((1)),
	[createTime] [datetime] NOT NULL CONSTRAINT [DF__ware_cust__creat__1CBC4616]  DEFAULT (getdate()),
	[updateTime] [datetime] NOT NULL CONSTRAINT [DF__ware_cust__updat__1DB06A4F]  DEFAULT (getdate()),
	[sgln] [varchar](50) NOT NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[ware_order]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ware_order](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[plantId] [int] NULL,
	[wareCode] [varchar](50) NOT NULL,
	[wareHouseCode] [varchar](50) NOT NULL,
	[produceCode] [varchar](50) NULL,
	[cusCode] [varchar](50) NOT NULL,
	[receiverCode] [varchar](50) NOT NULL,
	[wareDate] [datetime] NOT NULL,
	[poNumber] [varchar](50) NOT NULL,
	[remark] [varchar](50) NULL,
	[batchList] [varchar](500) NOT NULL,
	[completeFlag] [tinyint] NOT NULL,
	[estate] [tinyint] NOT NULL,
	[createTime] [datetime] NOT NULL,
	[updateTime] [datetime] NOT NULL,
	[fileName] [nvarchar](500) NULL,
	[receiveMailbox] [varchar](1000) NULL,
	[orderType] [tinyint] NOT NULL,
	[outboundType] [varchar](20) NOT NULL,
	[channel] [int] NULL
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[wms_api_log]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[wms_api_log](
	[requestLog] [varchar](max) NULL,
	[responseLog] [varchar](max) NULL,
	[api] [varchar](max) NULL,
	[ip] [varchar](20) NULL,
	[createTime] [datetime] NULL,
	[result] [varchar](20) NULL,
	[errorMsg] [varchar](max) NULL,
	[type] [char](1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[basic_company] ON 

INSERT [dbo].[basic_company] ([id], [companyName], [companyPrefix], [estate], [createTime], [updateTime], [flagBit], [poPrefix], [partialFilterValue], [partialThreshold], [partialControlCode]) VALUES (2, N'TWi Pharmaceuticals USA, Inc.', N'0324979', 0, CAST(N'2024-04-01 10:55:51.083' AS DateTime), CAST(N'2024-04-15 23:07:18.920' AS DateTime), 0, N'', 0, 1000, NULL)
SET IDENTITY_INSERT [dbo].[basic_company] OFF
SET IDENTITY_INSERT [dbo].[basic_level] ON 

INSERT [dbo].[basic_level] ([id], [levelCode], [levelName], [estate], [createTime], [updateTime], [levelMark], [comments]) VALUES (1, 1, N'Primary', 0, CAST(N'2022-01-04 16:31:45.000' AS DateTime), CAST(N'2022-07-19 07:28:15.383' AS DateTime), N'EA', N'EA')
INSERT [dbo].[basic_level] ([id], [levelCode], [levelName], [estate], [createTime], [updateTime], [levelMark], [comments]) VALUES (3, 3, N'Case', 0, CAST(N'2022-01-04 16:36:31.000' AS DateTime), CAST(N'2023-12-26 21:07:40.213' AS DateTime), N'CA', N'CA')
INSERT [dbo].[basic_level] ([id], [levelCode], [levelName], [estate], [createTime], [updateTime], [levelMark], [comments]) VALUES (4, 4, N'Pallet', 0, CAST(N'2022-01-10 19:08:31.000' AS DateTime), CAST(N'2023-04-26 15:17:40.910' AS DateTime), N'PL', N'PL')
INSERT [dbo].[basic_level] ([id], [levelCode], [levelName], [estate], [createTime], [updateTime], [levelMark], [comments]) VALUES (5, 2, N'Shrink', 0, CAST(N'2023-12-26 21:08:46.590' AS DateTime), CAST(N'2023-12-26 21:08:46.590' AS DateTime), N'PK', N'PK')
SET IDENTITY_INSERT [dbo].[basic_level] OFF
SET IDENTITY_INSERT [dbo].[basic_line] ON 

INSERT [dbo].[basic_line] ([id], [lineName], [lineCode], [plantId], [lineIp], [comments], [estate], [createTime], [updateTime]) VALUES (1, N'Packaging Line - 001', N'C001', 1, N'127.0.0.1', NULL, 0, CAST(N'2023-10-27 14:09:58.813' AS DateTime), CAST(N'2023-12-26 16:37:50.863' AS DateTime))
SET IDENTITY_INSERT [dbo].[basic_line] OFF
SET IDENTITY_INSERT [dbo].[basic_plant] ON 

INSERT [dbo].[basic_plant] ([id], [plantName], [plantCode], [licNumber], [licAgency], [licState], [gln], [street1], [street2], [city], [district], [country], [email], [estate], [createTime], [updateTime], [stateOrRegion], [postCode], [sgln]) VALUES (1, N'QILU PHARMACEUTICAL(HAINAN)CO.，LTD', N'FAT04', NULL, NULL, NULL, N'6949384100019', N'N°273-A Nanhai Ave.', N'National High-Tech Zone Haikou', N'Haikou', N'Xiuying District', N'CN', NULL, 0, CAST(N'2023-12-26 16:17:44.633' AS DateTime), CAST(N'2024-04-11 09:42:13.780' AS DateTime), N'Hainan', N'570314', N'69493841.0001.9')
SET IDENTITY_INSERT [dbo].[basic_plant] OFF
SET IDENTITY_INSERT [dbo].[basic_product] ON 

INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (1, 2, 1, N'TADALAFIL TABLETS,USP 2.5 mg 30s', N'24979-727-0600001', N'24979-727-06', N'24979-727-06', NULL, NULL, N'TEST', N'2.5 mg 30s', N'TADALAFIL TABLETS,USP 2.5 mg', NULL, NULL, NULL, 0, NULL, NULL, N'2.5mg 30s', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979727066","amount":24,"materialCode":"72706","__is_add":false,"filterValue":"0","available":9500,"threshold":50000,"verify":12},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979727068","amount":275,"materialCode":"72706","__is_add":false,"filterValue":"6","available":9979,"threshold":30000,"verify":12},{"type":1,"indicator":"0","level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"72706","palletGTIN":"70324979727065","__is_add":false,"filterValue":"0","partialFilterValue":"0","threshold":1000,"verify":12,"partialCaseThreshold":100,"partialThreshold":"1000","available":6263}]', 3, CAST(N'2024-04-01 11:08:31.290' AS DateTime), CAST(N'2024-04-28 16:58:04.210' AS DateTime), N'1:275:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (3, 2, 1, N'TADALAFIL TABLETS,USP 5 mg 30s', N'24979-728-0600001', N'24979-728-06', N'24979-728-06', NULL, NULL, NULL, N'5 mg 30s', N'TADALAFIL TABLETS,USP 5 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979728063","amount":24,"materialCode":"72806","__is_add":false,"filterValue":"0","available":54908,"threshold":80000,"verify":20},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979728065","amount":275,"materialCode":"72806","__is_add":false,"filterValue":"6","available":52705,"threshold":50000,"verify":20},{"type":1,"indicator":8,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"72806","palletGTIN":"80324979728069","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6231,"threshold":3000,"verify":20}]', 3, CAST(N'2024-04-15 16:30:00.443' AS DateTime), CAST(N'2024-04-26 13:13:56.083' AS DateTime), N'1:275:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (4, 2, 1, N'TADALAFIL TABLETS,USP 5 mg 500s', N'24979-728-0200001', N'24979-728-02', N'24979-728-02', NULL, NULL, NULL, N'5 mg 500s', N'TADALAFIL TABLETS,USP 5 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"materialCode":"72802","GTIN":"00324979728025","amount":24,"level":1,"name":"Primary","__is_add":false,"filterValue":"0","available":10000,"threshold":50000,"verify":20},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979728027","amount":180,"materialCode":"72802","__is_add":false,"filterValue":"6","available":10000,"threshold":50000,"verify":20},{"type":1,"indicator":8,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"72802","palletGTIN":"80324979728021","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":1200,"threshold":3000,"verify":20}]', 3, CAST(N'2024-04-15 16:33:28.207' AS DateTime), CAST(N'2024-04-18 16:00:45.677' AS DateTime), N'1:180:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (5, 2, 1, N'TADALAFIL TABLETS,USP 20 mg 30s', N'24979-730-0600001', N'24979-730-06', N'24979-730-06', NULL, NULL, NULL, N'20 mg 30s', N'TADALAFIL TABLETS,USP 20 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979730066","amount":24,"materialCode":"73006","__is_add":false,"filterValue":"0","available":49500,"threshold":50000,"verify":20},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979730068","amount":275,"materialCode":"73006","__is_add":false,"filterValue":"6","available":58979,"threshold":30000,"verify":20},{"type":1,"indicator":8,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"73006","palletGTIN":"80324979730062","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6263,"threshold":3000,"verify":20}]', 3, CAST(N'2024-04-15 16:35:56.743' AS DateTime), CAST(N'2024-04-19 16:43:20.877' AS DateTime), N'1:275:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (9, 2, 1, N'TADALAFIL TABLETS,USP 10 mg 250s', N'24979-729-6900001', N'24979-729-69', N'24979-729-69', NULL, NULL, NULL, N'10 mg 250s', N'TADALAFIL TABLETS,USP 10 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979729695","amount":24,"materialCode":"72969","__is_add":false,"filterValue":"0","available":9500,"threshold":50000,"verify":20},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979729697","amount":180,"materialCode":"72969","__is_add":false,"filterValue":"6","available":9979,"threshold":30000,"verify":10},{"type":1,"indicator":0,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"72969","palletGTIN":"00324979729695","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6263,"threshold":3000,"verify":10}]', 3, CAST(N'2024-04-18 14:18:50.013' AS DateTime), CAST(N'2024-05-31 09:13:31.870' AS DateTime), N'1:180:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (7, 2, 1, N'TADALAFIL TABLETS,USP 2.5 mg 500s', N'24979-727-0200001', N'24979-727-02', N'24979-727-02', NULL, NULL, NULL, N'2.5 mg 500s', N'TADALAFIL TABLETS,USP 2.5 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979727028","amount":24,"materialCode":"72702","__is_add":false,"filterValue":"0","available":9500,"threshold":50000,"verify":10},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979727020","amount":180,"materialCode":"72702","__is_add":false,"filterValue":"6","available":9979,"threshold":30000,"verify":10},{"type":1,"indicator":0,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"72702","palletGTIN":"00324979727028","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6263,"threshold":3000,"verify":10}]', 3, CAST(N'2024-04-18 14:13:56.980' AS DateTime), CAST(N'2024-04-29 14:29:52.397' AS DateTime), N'1:180:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (10, 2, 1, N'TADALAFIL TABLETS,USP 20 mg 120s', N'24979-730-4400001', N'24979-730-44', N'24979-730-44', NULL, NULL, NULL, N'20 mg 120s', N'TADALAFIL TABLETS,USP 20 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979730448","amount":24,"materialCode":"73044","__is_add":false,"filterValue":"0","available":9500,"threshold":50000,"verify":10},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979730440","amount":180,"materialCode":"73044","__is_add":false,"filterValue":"6","available":9979,"threshold":30000,"verify":10},{"type":1,"indicator":9,"level":4,"name":"Pallet","GTIN":"0324979","amount":1,"materialCode":"73044","palletGTIN":"90324979730441","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6263,"threshold":3000,"verify":10}]', 3, CAST(N'2024-04-18 14:28:07.937' AS DateTime), CAST(N'2024-05-17 09:30:51.407' AS DateTime), N'1:180:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[basic_product] ([id], [companyId], [plantId], [productName], [productCode], [ndc], [material], [dosageForm], [dosageUsage], [strength], [packageSize], [generic], [composition], [unitPrice], [description], [scheduled], [imageDir], [receiverCode], [remark], [primaryCount], [productType], [country], [packageRules], [estate], [createTime], [updateTime], [packageRatio], [shelfLife], [productCodeType], [productCodeValue], [eancode], [sendStatus], [dateFormat], [codeStyle], [printFrom], [printLogo], [printMarket], [packageSpec], [recipeNo]) VALUES (8, 2, 1, N'TADALAFIL TABLETS,USP 10 mg 30s', N'24979-729-0600001', N'24979-729-06', N'24979-729-06', NULL, NULL, NULL, N'10 mg 30s', N'TADALAFIL TABLETS,USP 10 mg', NULL, NULL, NULL, 0, NULL, NULL, N'NA', 0, 0, NULL, N'[{"type":0,"indicator":0,"level":1,"name":"Primary","GTIN":"00324979729060","amount":24,"materialCode":"72906","__is_add":false,"filterValue":"0","available":9500,"threshold":50000,"verify":10},{"type":0,"indicator":6,"level":3,"name":"Case","GTIN":"60324979729062","amount":275,"materialCode":"72906","__is_add":false,"filterValue":"6","available":9979,"threshold":30000,"verify":10},{"type":1,"indicator":9,"GTIN":"0324979","amount":1,"materialCode":"72906","level":4,"name":"Pallet","palletGTIN":"90324979729063","__is_add":false,"filterValue":"0","partialFilterValue":"0","partialThreshold":"1000","available":6263,"threshold":3000,"verify":10}]', 3, CAST(N'2024-04-18 14:16:47.980' AS DateTime), CAST(N'2024-04-27 10:56:35.000' AS DateTime), N'1:275:24', 24, N'US_NDC532', NULL, NULL, 0, N'YYYY/MM/DD', N'sap', NULL, NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[basic_product] OFF
SET IDENTITY_INSERT [dbo].[basic_product_gtin] ON 

INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (1, N'43547-289-5000001', N'00343547289508', 1, CAST(N'2023-12-28 09:34:29.463' AS DateTime), CAST(N'2023-12-28 09:34:29.463' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (2, N'43547-289-5000001', N'30343547289509', 3, CAST(N'2023-12-28 09:34:29.463' AS DateTime), CAST(N'2023-12-28 09:34:29.463' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (3, N'43547-289-5000001', N'50343547289503', 4, CAST(N'2023-12-28 09:34:29.463' AS DateTime), CAST(N'2023-12-28 09:34:29.463' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (4, N'M01CF111200001', N'10240111233448', 1, CAST(N'2024-01-11 10:12:18.647' AS DateTime), CAST(N'2024-01-11 10:12:18.647' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (5, N'M01CF111200001', N'30240111233442', 3, CAST(N'2024-01-11 10:12:18.647' AS DateTime), CAST(N'2024-01-11 10:12:18.647' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (6, N'M01CF111200001', N'50240111233446', 4, CAST(N'2024-01-11 10:12:18.647' AS DateTime), CAST(N'2024-01-11 10:12:18.647' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (7, N'M1232311200001', N'10110001232335', 1, CAST(N'2024-01-22 16:02:35.590' AS DateTime), CAST(N'2024-01-22 16:02:35.590' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (8, N'M1232311200001', N'30110001232339', 3, CAST(N'2024-01-22 16:02:35.590' AS DateTime), CAST(N'2024-01-22 16:02:35.590' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (9, N'M1232311200001', N'50110001232333', 4, CAST(N'2024-01-22 16:02:35.590' AS DateTime), CAST(N'2024-01-22 16:02:35.590' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (10, N'M22022200001', N'10220002233207', 1, CAST(N'2024-01-22 16:16:58.090' AS DateTime), CAST(N'2024-01-22 16:16:58.090' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (11, N'M22022200001', N'30220002233201', 3, CAST(N'2024-01-22 16:16:58.090' AS DateTime), CAST(N'2024-01-22 16:16:58.090' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (12, N'M22022200001', N'50220002233205', 4, CAST(N'2024-01-22 16:16:58.090' AS DateTime), CAST(N'2024-01-22 16:16:58.090' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (13, N'43547-289-5000001', N'50343547289503', 3, CAST(N'2024-03-20 17:56:23.590' AS DateTime), CAST(N'2024-03-20 17:56:23.590' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (14, N'24979-727-0600001', N'00324979727066', 1, CAST(N'2024-04-01 11:08:31.310' AS DateTime), CAST(N'2024-04-01 11:08:31.310' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (15, N'24979-727-0600001', N'60324979727068', 3, CAST(N'2024-04-01 11:08:31.310' AS DateTime), CAST(N'2024-04-01 11:08:31.310' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (16, N'24979-727-0600001', N'70324979727065', 4, CAST(N'2024-04-01 11:08:31.310' AS DateTime), CAST(N'2024-04-01 11:08:31.310' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (17, N'2497900001', N'00235889454235', 1, CAST(N'2024-04-02 11:28:43.243' AS DateTime), CAST(N'2024-04-02 11:28:43.243' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (18, N'2497900001', N'20235889454239', 3, CAST(N'2024-04-02 11:28:43.243' AS DateTime), CAST(N'2024-04-02 11:28:43.243' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (19, N'2497900001', N'60235889454237', 4, CAST(N'2024-04-02 11:28:43.243' AS DateTime), CAST(N'2024-04-02 11:28:43.243' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (20, N'24979-728-0600001', N'00324979728063', 1, CAST(N'2024-04-15 16:30:00.477' AS DateTime), CAST(N'2024-04-15 16:30:00.477' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (21, N'24979-728-0600001', N'60324979728065', 3, CAST(N'2024-04-15 16:30:00.477' AS DateTime), CAST(N'2024-04-15 16:30:00.477' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (22, N'24979-728-0600001', N'80324979728069', 4, CAST(N'2024-04-15 16:30:00.477' AS DateTime), CAST(N'2024-04-15 16:30:00.477' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (23, N'24979-728-0200001', N'00324979728025', 1, CAST(N'2024-04-15 16:33:28.223' AS DateTime), CAST(N'2024-04-15 16:33:28.223' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (24, N'24979-728-0200001', N'60324979728027', 3, CAST(N'2024-04-15 16:33:28.223' AS DateTime), CAST(N'2024-04-15 16:33:28.223' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (25, N'24979-728-0200001', N'80324979728021', 4, CAST(N'2024-04-15 16:33:28.223' AS DateTime), CAST(N'2024-04-15 16:33:28.223' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (26, N'24979-730-0600001', N'00324979730066', 1, CAST(N'2024-04-15 16:35:56.743' AS DateTime), CAST(N'2024-04-15 16:35:56.743' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (27, N'24979-730-0600001', N'60324979730068', 3, CAST(N'2024-04-15 16:35:56.743' AS DateTime), CAST(N'2024-04-15 16:35:56.743' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (28, N'24979-730-0600001', N'80324979730062', 4, CAST(N'2024-04-15 16:35:56.743' AS DateTime), CAST(N'2024-04-15 16:35:56.743' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (29, N'24979-728-0200002', N'00324979728025', 1, CAST(N'2024-04-18 14:10:16.250' AS DateTime), CAST(N'2024-04-18 14:10:16.250' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (30, N'24979-728-0200002', N'60324979728027', 3, CAST(N'2024-04-18 14:10:16.250' AS DateTime), CAST(N'2024-04-18 14:10:16.250' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (31, N'24979-728-0200002', N'90324979728028', 4, CAST(N'2024-04-18 14:10:16.250' AS DateTime), CAST(N'2024-04-18 14:10:16.250' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (38, N'24979-729-6900001', N'00324979729695', 1, CAST(N'2024-04-18 14:18:50.030' AS DateTime), CAST(N'2024-04-18 14:18:50.030' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (39, N'24979-729-6900001', N'60324979729697', 3, CAST(N'2024-04-18 14:18:50.030' AS DateTime), CAST(N'2024-04-18 14:18:50.030' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (40, N'24979-729-6900001', N'00324979729695', 4, CAST(N'2024-04-18 14:18:50.030' AS DateTime), CAST(N'2024-04-18 14:18:50.030' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (41, N'24979-730-4400001', N'00324979730448', 1, CAST(N'2024-04-18 14:28:07.937' AS DateTime), CAST(N'2024-04-18 14:28:07.937' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (42, N'24979-730-4400001', N'60324979730440', 3, CAST(N'2024-04-18 14:28:07.937' AS DateTime), CAST(N'2024-04-18 14:28:07.937' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (43, N'24979-730-4400001', N'90324979730441', 4, CAST(N'2024-04-18 14:28:07.937' AS DateTime), CAST(N'2024-04-18 14:28:07.937' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (32, N'24979-727-0200001', N'00324979727028', 1, CAST(N'2024-04-18 14:13:56.980' AS DateTime), CAST(N'2024-04-18 14:13:56.980' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (33, N'24979-727-0200001', N'60324979727020', 3, CAST(N'2024-04-18 14:13:56.980' AS DateTime), CAST(N'2024-04-18 14:13:56.980' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (34, N'24979-727-0200001', N'00324979727028', 4, CAST(N'2024-04-18 14:13:56.980' AS DateTime), CAST(N'2024-04-18 14:13:56.980' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (35, N'24979-729-0600001', N'00324979729060', 1, CAST(N'2024-04-18 14:16:47.997' AS DateTime), CAST(N'2024-04-18 14:16:47.997' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (36, N'24979-729-0600001', N'60324979729062', 3, CAST(N'2024-04-18 14:16:47.997' AS DateTime), CAST(N'2024-04-18 14:16:47.997' AS DateTime))
INSERT [dbo].[basic_product_gtin] ([id], [productCode], [resCode], [levelCode], [createTime], [updateTime]) VALUES (37, N'24979-729-0600001', N'90324979729063', 4, CAST(N'2024-04-18 14:16:47.997' AS DateTime), CAST(N'2024-04-18 14:16:47.997' AS DateTime))
SET IDENTITY_INSERT [dbo].[basic_product_gtin] OFF
SET IDENTITY_INSERT [dbo].[sys_deploy] ON 

INSERT [dbo].[sys_deploy] ([id], [deployName], [deployCode], [deployValue], [estate], [createTime], [updateTime]) VALUES (1, N'Password Rule', N'password', N'{"minimum":7,"expiration":90,"reminder":7,"attempt":6,"duplicate":2,"contains":[3]}', 0, CAST(N'2023-12-27 15:11:27.810' AS DateTime), CAST(N'2024-04-29 15:50:43.633' AS DateTime))
INSERT [dbo].[sys_deploy] ([id], [deployName], [deployCode], [deployValue], [estate], [createTime], [updateTime]) VALUES (2, N'System Config', N'config', N'{"logout":7200}', 0, CAST(N'2023-12-27 15:11:40.047' AS DateTime), CAST(N'2023-12-27 15:11:40.047' AS DateTime))
INSERT [dbo].[sys_deploy] ([id], [deployName], [deployCode], [deployValue], [estate], [createTime], [updateTime]) VALUES (3, N'Webservice Account', N'webservice', N'{"username":"tl_soap+qiluhainan@tracelink.com","sender":6949384100019,"password":"rnTK3tp^vQGXVM7k","timearea":"+08:00","receiver":"0324979000008","environment":"https:\/\/api.tracelink.com:443\/soap\/snx\/snrequest?wsdl"}', 0, CAST(N'2023-12-27 15:12:19.460' AS DateTime), CAST(N'2024-04-15 16:51:10.780' AS DateTime))
INSERT [dbo].[sys_deploy] ([id], [deployName], [deployCode], [deployValue], [estate], [createTime], [updateTime]) VALUES (4, N'SFTP Account', N'sftp', N'{"host":"itestb2b-alt.tracelink.com","port":5022,"username":"solcohealttestssh","password":"GWXyNvW265@8P^sW3GWs","catalogue":"inbox\/SNX_DISPOSITION_ASSIGNED"}', 0, CAST(N'2023-12-27 15:12:44.920' AS DateTime), CAST(N'2023-12-27 15:12:44.920' AS DateTime))
SET IDENTITY_INSERT [dbo].[sys_deploy] OFF
SET IDENTITY_INSERT [dbo].[sys_history_password] ON 

INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (1, N'anora', N'$2y$10$/Ze6cDFUJIW4Ge4C4CHAQetSwmWzpxBbHwrR2CbspETtFIJhCDZeq', CAST(N'2023-10-27 16:30:56.750' AS DateTime), CAST(N'2023-10-27 16:30:56.750' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (2, N'fuqiuyan', N'$2y$10$SB1SAWKbkYc3bZbgPLiAIOr.9J7vVUxjaIiTWvlHZtzsXrXDzFvSO', CAST(N'2024-04-29 13:55:00.820' AS DateTime), CAST(N'2024-04-29 13:55:00.820' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (3, N'fuqiuyan', N'$2y$10$eZkpaPP3He00jKbJLIxPD.QmgKqLKJ2UgPRycF2caP4gu36N9SZYu', CAST(N'2024-04-29 13:55:12.090' AS DateTime), CAST(N'2024-04-29 13:55:12.090' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (4, N'fuqiuyan', N'$2y$10$8D.xVeDG8pO6jAqlEVWHKOLg646j.o1v0lQhv2lbnLDfPDL44gZ8C', CAST(N'2024-04-29 13:55:32.817' AS DateTime), CAST(N'2024-04-29 13:55:32.817' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (6, N'fuqiuyan', N'$2y$10$Zc5HZl5dDfI1C6GmX3Pu6Ods1SvQXSPeHGfZAbBcb66Kbr/uVyU9G', CAST(N'2024-04-29 13:56:23.913' AS DateTime), CAST(N'2024-04-29 13:56:23.913' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (8, N'fuqiuyan', N'$2y$10$20X0hPQUsMbgE7riPyh3NOHFze.EKxpsSh7dfZwIQ3leppxQjn5gq', CAST(N'2024-04-29 15:34:39.940' AS DateTime), CAST(N'2024-04-29 15:34:39.940' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (5, N'fuqiuyan', N'$2y$10$4T54VASZDT4iAVWMqRA9u.wdQQg1QO2wS1JxauIn74Gl.EYUH/dk2', CAST(N'2024-04-29 13:55:45.220' AS DateTime), CAST(N'2024-04-29 13:55:45.220' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (7, N'fuqiuyan', N'$2y$10$wwRVLDgtRLv67ImKgpMIy.TNjp9a.d8UL.R67J.VoVQrVJqyw5cei', CAST(N'2024-04-29 13:56:41.557' AS DateTime), CAST(N'2024-04-29 13:56:41.557' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (9, N'wuanxiang', N'$2y$10$l54kzwVheSJ9xK6l2uL3COogtgIwHIDyGzC5jWohFyILvwT1EMt9e', CAST(N'2024-04-29 15:50:21.187' AS DateTime), CAST(N'2024-04-29 15:50:21.187' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (11, N'QA', N'$2y$10$tTA./KR6rRAVXk5X.Bk1e.i2DQjY4iWrY4TtF2EULQRyjgcwU8FPO', CAST(N'2024-04-29 15:56:16.787' AS DateTime), CAST(N'2024-04-29 15:56:16.787' AS DateTime))
INSERT [dbo].[sys_history_password] ([id], [username], [password], [createTime], [updateTime]) VALUES (10, N'CR', N'$2y$10$Jnnp5CDIEpojky28e86pXutH.6YVFKtNxP4I0aagO748F/bt0dFAm', CAST(N'2024-04-29 15:53:15.333' AS DateTime), CAST(N'2024-04-29 15:53:15.333' AS DateTime))
SET IDENTITY_INSERT [dbo].[sys_history_password] OFF
SET IDENTITY_INSERT [dbo].[sys_login_record] ON 

INSERT [dbo].[sys_login_record] ([id], [username], [nickname], [clientIp], [device], [os], [browser], [comments], [loginType], [createTime], [updateTime], [origin]) VALUES (1, N'admin', N'Administrator', N'192.168.80.240', N'WebKit', N'Windows', N'Chrome83.0.4103.97', N'登陆成功', 0, CAST(N'2024-07-22 13:04:33.270' AS DateTime), CAST(N'2024-07-22 13:04:33.270' AS DateTime), 2)
INSERT [dbo].[sys_login_record] ([id], [username], [nickname], [clientIp], [device], [os], [browser], [comments], [loginType], [createTime], [updateTime], [origin]) VALUES (2, N'admin', N'Administrator', N'192.168.80.240', N'WebKit', N'Windows', N'Chrome83.0.4103.97', N'退出系统成功', 2, CAST(N'2024-07-22 13:17:30.530' AS DateTime), CAST(N'2024-07-22 13:17:30.530' AS DateTime), 2)
INSERT [dbo].[sys_login_record] ([id], [username], [nickname], [clientIp], [device], [os], [browser], [comments], [loginType], [createTime], [updateTime], [origin]) VALUES (3, N'admin', N'Administrator', N'192.168.80.240', N'WebKit', N'Windows', N'Chrome83.0.4103.97', N'登陆成功', 0, CAST(N'2024-07-22 13:23:38.373' AS DateTime), CAST(N'2024-07-22 13:23:38.373' AS DateTime), 2)
SET IDENTITY_INSERT [dbo].[sys_login_record] OFF
SET IDENTITY_INSERT [dbo].[sys_menu] ON 

INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (1, 0, N'系统管理', N'abilities.system.style', N'/system', N'el-icon-setting', NULL, 0, NULL, 5, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:51:23.000' AS DateTime), CAST(N'2022-08-20 01:30:47.213' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (2, 1, N'用户管理', N'abilities.system.child.user.style', N'/system/user', N'el-icon-_user-group', N'/system/user', 0, NULL, 1, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:51:55.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (3, 2, N'查询用户', N'abilities.system.child.user.action.list', NULL, NULL, NULL, 1, N'sys:user:list', 1, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:52:06.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (4, 2, N'添加用户', N'abilities.system.child.user.action.add', NULL, NULL, NULL, 1, N'sys:user:save', 2, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:52:26.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (5, 2, N'修改用户', N'abilities.system.child.user.action.edit', NULL, NULL, NULL, 1, N'sys:user:update', 3, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:52:50.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (6, 2, N'删除用户', N'abilities.system.child.user.action.delete', NULL, NULL, NULL, 1, N'sys:user:remove', 4, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-02-26 12:53:13.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (7, 1, N'角色管理', N'abilities.system.child.role.style', N'/system/role', N'el-icon-postcard', N'/system/role', 0, NULL, 2, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-03-13 13:29:08.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (8, 7, N'查询角色', N'abilities.system.child.role.action.list', NULL, NULL, NULL, 1, N'sys:role:list', 1, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-03-13 13:30:41.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (9, 7, N'添加角色', N'abilities.system.child.role.action.add', NULL, NULL, NULL, 1, N'sys:role:save', 2, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-03-15 13:02:07.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (10, 7, N'修改角色', N'abilities.system.child.role.action.edit', NULL, NULL, NULL, 1, N'sys:role:update', 3, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-03-15 13:02:49.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (11, 7, N'删除角色', N'abilities.system.child.role.action.delete', NULL, NULL, NULL, 1, N'sys:role:remove', 4, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2020-03-20 17:58:51.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (87, 0, N'基础管理', N'abilities.basic.style', N'/basic', N'el-icon-notebook-1', NULL, 0, NULL, 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-03 17:49:10.000' AS DateTime), CAST(N'2022-07-16 07:11:38.620' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (88, 87, N'产线管理', N'abilities.basic.child.line.style', N'/basic/line', N'el-icon-_component', N'/basic/line', 0, NULL, 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-03 17:54:38.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (89, 87, N'层级管理', N'abilities.basic.child.level.style', N'/basic/level', N'el-icon-_transfer', N'/basic/level', 0, NULL, 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-04 15:18:56.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (90, 87, N'工厂管理', N'abilities.basic.child.plant.style', N'/basic/plant', N'el-icon-_template', N'/basic/plant', 0, NULL, 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-05 09:22:40.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (102, 1, N'配置管理', N'abilities.system.child.deploy.style', N'/system/deploy', N'el-icon-_setting', N'/system/deploy', 0, NULL, 13, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2022-06-15 08:57:16.757' AS DateTime), CAST(N'2022-06-15 08:59:05.883' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (92, 87, N'公司管理', N'abilities.basic.child.company.style', N'/basic/company', N'el-icon-_prerogative', N'/basic/company', 0, NULL, 5, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-07 18:51:12.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (93, 87, N'产品管理', N'abilities.basic.child.product.style', N'/basic/product', N'el-icon-collection', N'/basic/product', 0, NULL, 6, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-01-07 19:38:19.000' AS DateTime), CAST(N'2021-05-21 17:56:27.000' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (100, 0, N'生产管理', N'abilities.produce.style', N'/produce', N'el-icon-_menu', NULL, 0, NULL, 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-05-27 08:14:26.987' AS DateTime), CAST(N'2022-08-20 01:30:11.477' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (96, 0, N'报表管理', N'abilities.report.style', N'/report', N'el-icon-files', NULL, 0, NULL, 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-04-06 17:06:16.000' AS DateTime), CAST(N'2022-08-20 01:30:25.507' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (97, 96, N'登陆日志报表', N'abilities.report.child.login_log.style', N'/report/login-record', N'el-icon-_mate', N'/report/login-record', 0, NULL, 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-04-06 17:06:16.000' AS DateTime), CAST(N'2022-07-06 23:43:20.100' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (98, 96, N'操作日志报表', N'abilities.report.child.operation_log.style', N'/report/operation-record', N'el-icon-collection', N'/report/operation-record', 0, NULL, 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-04-06 17:06:16.000' AS DateTime), CAST(N'2022-07-06 23:59:52.423' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (99, 96, N'批记录报表', N'abilities.report.child.batch_record.style', N'/report/batch-record', N'el-icon-data-line', N'/report/batch-record', 0, NULL, 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-04-06 17:06:16.000' AS DateTime), CAST(N'2022-07-06 23:45:16.990' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (101, 100, N'批次管理', N'abilities.produce.child.order.style', N'/produce/order', N'el-icon-data-line', N'/produce/order', 0, NULL, 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-05-27 08:15:05.487' AS DateTime), CAST(N'2022-05-28 07:21:21.580' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (103, 0, N'条码管理', N'abilities.sn.style', N'/code', N'el-icon-bank-card', NULL, 0, NULL, 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-06-18 18:47:13.953' AS DateTime), CAST(N'2022-08-20 01:29:47.910' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (104, 103, N'记录管理', N'abilities.sn.child.record.style', N'/code/record', N'el-icon-files', N'/code/record', 0, NULL, 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-06-18 18:49:40.517' AS DateTime), CAST(N'2022-06-18 18:49:40.517' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (115, 89, N'修改层级', N'abilities.basic.child.level.action.edit', NULL, NULL, NULL, 1, N'basic:level:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-08-20 18:59:41.780' AS DateTime), CAST(N'2022-08-20 11:02:38.050' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (118, 88, N'查询产线', N'abilities.basic.child.line.action.list', NULL, NULL, NULL, 1, N'basic:line:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:28:30.110' AS DateTime), CAST(N'2022-09-20 00:28:30.110' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (120, 88, N'修改产线', N'abilities.basic.child.line.action.edit', NULL, NULL, NULL, 1, N'basic:line:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:32:26.190' AS DateTime), CAST(N'2022-09-20 00:32:26.190' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (121, 88, N'删除产线', N'abilities.basic.child.line.action.delete', NULL, NULL, NULL, 1, N'basic:line:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:37:15.417' AS DateTime), CAST(N'2022-09-19 16:37:24.863' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (124, 90, N'修改工厂', N'abilities.basic.child.plant.action.edit', NULL, NULL, NULL, 1, N'basic:plant:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:39:23.067' AS DateTime), CAST(N'2022-09-28 08:49:15.833' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (125, 90, N'删除工厂', N'abilities.basic.child.plant.action.delete', NULL, NULL, NULL, 1, N'basic:plant:remove', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:40:00.247' AS DateTime), CAST(N'2022-09-28 08:48:50.667' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (126, 92, N'查询公司', N'abilities.basic.child.company.action.list', NULL, NULL, NULL, 1, N'basic:company:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:42:04.393' AS DateTime), CAST(N'2022-09-20 00:42:04.393' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (127, 92, N'新增公司', N'abilities.basic.child.company.action.add', NULL, NULL, NULL, 1, N'basic:company:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:42:38.107' AS DateTime), CAST(N'2022-09-20 00:42:38.107' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (128, 92, N'修改公司', N'abilities.basic.child.company.action.edit', NULL, NULL, NULL, 1, N'basic:company:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:43:16.730' AS DateTime), CAST(N'2022-09-20 00:43:16.730' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (130, 93, N'查询产品', N'abilities.basic.child.product.action.list', NULL, NULL, NULL, 1, N'basic:product:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:45:17.530' AS DateTime), CAST(N'2022-09-20 00:45:17.530' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (131, 93, N'新增产品', N'abilities.basic.child.product.action.add', NULL, NULL, NULL, 1, N'basic:product:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:46:43.847' AS DateTime), CAST(N'2022-09-20 00:46:43.847' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (116, 89, N'删除层级', N'abilities.basic.child.level.action.delete', NULL, NULL, NULL, 1, N'basic:level:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-08-20 19:00:27.407' AS DateTime), CAST(N'2022-08-20 11:02:44.233' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (117, 89, N'查询层级', N'abilities.basic.child.level.action.list', NULL, NULL, NULL, 1, N'basic:level:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-08-20 19:01:38.580' AS DateTime), CAST(N'2023-04-12 16:31:49.047' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (119, 88, N'新增产线', N'abilities.basic.child.line.action.add', NULL, NULL, NULL, 1, N'basic:line:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:29:16.623' AS DateTime), CAST(N'2022-09-19 16:29:54.393' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (122, 90, N'查询工厂', N'abilities.basic.child.plant.action.list', NULL, NULL, NULL, 1, N'basic:plant:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:37:59.713' AS DateTime), CAST(N'2022-09-28 08:48:59.203' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (132, 93, N'修改产品', N'abilities.basic.child.product.action.edit', NULL, NULL, NULL, 1, N'basic:product:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:47:25.130' AS DateTime), CAST(N'2022-09-20 00:47:25.130' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (133, 93, N'删除产品', N'abilities.basic.child.product.action.delete', NULL, NULL, NULL, 1, N'basic:product:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:48:15.873' AS DateTime), CAST(N'2022-09-19 16:52:33.933' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (134, 93, N'审核产品', N'abilities.basic.child.product.action.review', NULL, NULL, NULL, 1, N'basic:product:audit', 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:58:31.900' AS DateTime), CAST(N'2022-09-20 00:58:31.900' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (137, 104, N'查询条码', N'abilities.sn.child.record.action.list', NULL, NULL, NULL, 1, N'code:record:list', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 07:29:16.267' AS DateTime), CAST(N'2022-09-28 08:59:52.317' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (140, 101, N'修改批次', N'abilities.produce.child.order.action.edit', NULL, NULL, NULL, 1, N'produce:order:update', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 19:56:40.347' AS DateTime), CAST(N'2022-09-20 12:02:14.157' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (143, 172, N'修改码下发', N'abilities.produce.child.order_request.action.edit', NULL, NULL, NULL, 1, N'produce:order:allocation:update', 8, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 20:07:10.473' AS DateTime), CAST(N'2023-05-04 15:46:03.687' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (145, 101, N'结束批次', N'abilities.produce.child.order.action.close', NULL, NULL, NULL, 1, N'produce:order:finish', 6, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-21 02:35:15.103' AS DateTime), CAST(N'2022-09-20 18:37:26.340' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (149, 97, N'导出登陆日志报表', N'abilities.report.child.login_log.action.export', NULL, NULL, NULL, 1, N'report:login-record:export', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 18:32:47.827' AS DateTime), CAST(N'2022-09-28 18:32:47.827' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (150, 98, N'导出操作日志报表', N'abilities.report.child.operation_log.action.export', NULL, NULL, NULL, 1, N'report:operation-record:export', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 18:40:05.517' AS DateTime), CAST(N'2022-09-28 18:40:05.517' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (151, 99, N'导出批记录报表', N'abilities.report.child.batch_record.action.export', NULL, NULL, NULL, 1, N'report:batch-record:export', 0, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 18:40:46.730' AS DateTime), CAST(N'2022-09-28 18:40:46.730' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (123, 90, N'新增工厂', N'abilities.basic.child.plant.action.add', NULL, NULL, NULL, 1, N'basic:plant:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:38:58.137' AS DateTime), CAST(N'2022-09-28 08:49:08.373' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (129, 92, N'删除公司', N'abilities.basic.child.company.action.delete', NULL, NULL, NULL, 1, N'basic:company:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 00:43:42.860' AS DateTime), CAST(N'2022-09-20 00:43:42.860' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (139, 101, N'新增批次', N'abilities.produce.child.order.action.add', NULL, NULL, NULL, 1, N'produce:order:save', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 19:55:49.803' AS DateTime), CAST(N'2022-09-20 12:02:04.143' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (148, 172, N'批准码下发', N'abilities.produce.child.order_request.action.approve', NULL, NULL, NULL, 1, N'produce:order:allocation:approve', 11, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 17:23:00.163' AS DateTime), CAST(N'2023-05-04 15:45:26.180' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (135, 93, N'批准产品', N'abilities.basic.child.product.action.approve', NULL, NULL, NULL, 1, N'basic:product:approve', 5, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 06:53:27.857' AS DateTime), CAST(N'2022-09-28 08:57:24.057' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (136, 93, N'下码阈值', N'abilities.basic.child.product.action.threshold', NULL, NULL, NULL, 1, N'basic:product:threshold', 6, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 06:55:27.910' AS DateTime), CAST(N'2022-09-19 23:28:32.563' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (138, 101, N'查询批次', N'abilities.produce.child.order.action.list', NULL, NULL, NULL, 1, N'produce:order:list', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 19:54:56.710' AS DateTime), CAST(N'2022-09-20 12:01:50.977' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (141, 101, N'删除批次', N'abilities.produce.child.order.action.delete', NULL, NULL, NULL, 1, N'produce:order:remove', 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 19:57:16.660' AS DateTime), CAST(N'2022-09-20 12:02:20.020' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (142, 172, N'新增码下发', N'abilities.produce.child.order_request.action.add', NULL, NULL, NULL, 1, N'produce:order:allocation:save', 7, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-20 20:06:12.427' AS DateTime), CAST(N'2023-05-04 15:44:57.447' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (144, 101, N'上传批次', N'abilities.produce.child.order.action.upload', NULL, NULL, NULL, 1, N'produce:order:upload', 5, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-21 02:31:40.163' AS DateTime), CAST(N'2022-09-28 10:31:13.237' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (146, 172, N'删除码下发', N'abilities.produce.child.order_request.action.delete', NULL, NULL, NULL, 1, N'produce:order:allocation:remove', 9, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 17:18:42.437' AS DateTime), CAST(N'2023-05-04 15:45:16.413' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (147, 172, N'审核码下发', N'abilities.produce.child.order_request.action.review', NULL, NULL, NULL, 1, N'produce:order:allocation:audit', 10, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 17:22:10.547' AS DateTime), CAST(N'2023-05-04 15:46:14.647' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (168, 101, N'申请码管理', N'abilities.apply.style', N'/apply', NULL, NULL, 0, NULL, 12, 1, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-04-11 16:07:36.230' AS DateTime), CAST(N'2023-12-27 16:26:54.957' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (169, 168, N'码请求', N'abilities.apply.child.soap.style', NULL, NULL, NULL, 1, NULL, 1, 1, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-04-11 16:26:51.920' AS DateTime), CAST(N'2023-04-11 16:26:51.920' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (170, 168, N'码写入', N'abilities.apply.child.insert.style', NULL, NULL, NULL, 1, NULL, 2, 1, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-04-11 16:28:02.880' AS DateTime), CAST(N'2023-04-11 16:28:02.880' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (171, 89, N'新增层级', N'abilities.basic.child.level.action.add', NULL, NULL, NULL, 1, N'basic:level:add', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-04-12 16:31:21.343' AS DateTime), CAST(N'2023-04-12 16:31:21.343' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (172, 101, N'码下发管理', N'abilities.produce.child.order_request.style', N'/produce/order-request', N'el-icon-_prerogative', N'/produce/order-request', 0, NULL, 2, 1, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-05-04 15:43:48.090' AS DateTime), CAST(N'2023-12-27 16:26:22.027' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (189, 172, N'发送', N'abilities.produce.child.order_request.action.send', NULL, NULL, NULL, 1, N'produce:order:allocation:send', 12, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2022-09-28 17:18:42.437' AS DateTime), CAST(N'2023-08-22 15:55:51.667' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (185, 100, N'返工管理', N'abilities.produce.child.repacking.style', N'/produce/repacking', N'el-icon-box', N'/produce/repacking', 0, NULL, 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-05-27 14:27:06.267' AS DateTime), CAST(N'2023-05-27 14:27:06.267' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (186, 101, N'反结批', N'abilities.produce.child.order.action.reverse', NULL, NULL, NULL, 1, N'produce:order:reverse', 7, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-05-27 14:28:25.723' AS DateTime), CAST(N'2023-05-27 14:28:25.723' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (187, 185, N'查询返工', N'abilities.produce.child.repacking.action.list', NULL, NULL, NULL, 1, N'produce:repacking:list', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-05-27 14:29:06.490' AS DateTime), CAST(N'2023-05-27 14:29:06.490' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (188, 185, N'新增返工', N'abilities.produce.child.repacking.action.add', NULL, NULL, NULL, 1, N'produce:repacking:add', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-05-27 14:30:21.547' AS DateTime), CAST(N'2023-05-27 14:30:21.547' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (190, 1, N'菜单管理', N'abilities.system.child.menu.style', N'/system/menu', N'el-icon-s-operation', N'/system/menu', 0, NULL, 3, 0, NULL, N'_self', 1, 1, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:24:57.757' AS DateTime), CAST(N'2023-12-27 16:27:45.583' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (191, 190, N'查询菜单', N'abilities.system.child.menu.action.list', NULL, NULL, NULL, 1, N'sys:menu:list', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:28:27.820' AS DateTime), CAST(N'2023-12-27 16:28:27.820' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (198, 195, N'单据管理', N'abilities.logistics.child.invoice.style', N'/logistics/invoice', N'el-icon-collection', N'/logistics/invoice', 0, NULL, 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:35:57.253' AS DateTime), CAST(N'2023-12-27 16:35:57.253' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (200, 196, N'修改接收方', N'abilities.logistics.child.customer.action.edit_receiver', NULL, NULL, NULL, 1, N'logistics:customer:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:42:06.267' AS DateTime), CAST(N'2023-12-27 16:42:06.267' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (201, 196, N'删除接收方', N'abilities.logistics.child.customer.action.delete_receiver', NULL, NULL, NULL, 1, N'logistics:customer:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:42:38.330' AS DateTime), CAST(N'2023-12-27 16:42:38.330' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (202, 197, N'新增发货方', N'abilities.logistics.child.warehouse.action.add', NULL, NULL, NULL, 1, N'logistics:warehouse:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:44:09.450' AS DateTime), CAST(N'2023-12-27 16:44:09.450' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (203, 197, N'修改发货方', N'abilities.logistics.child.warehouse.action.add', NULL, NULL, NULL, 1, N'logistics:warehouse:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:44:36.987' AS DateTime), CAST(N'2023-12-27 16:44:36.987' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (204, 197, N'删除发货方', N'abilities.logistics.child.warehouse.action.delete', NULL, NULL, NULL, 1, N'logistics:warehouse:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:45:03.463' AS DateTime), CAST(N'2023-12-27 16:52:37.320' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (205, 198, N'新增单据', N'abilities.logistics.child.invoice.action.add', NULL, NULL, NULL, 1, N'logistics:invoice:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:01:08.940' AS DateTime), CAST(N'2022-09-28 19:01:08.940' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (206, 198, N'修改单据', N'abilities.logistics.child.invoice.action.edit', NULL, NULL, NULL, 1, N'logistics:invoice:update', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:04:06.920' AS DateTime), CAST(N'2022-09-28 19:04:06.920' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (207, 198, N'删除单据', N'abilities.logistics.child.invoice.action.delete', NULL, NULL, NULL, 1, N'logistics:invoice:remove', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:04:27.080' AS DateTime), CAST(N'2022-09-28 11:04:36.037' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (208, 198, N'上传单据', N'abilities.logistics.child.invoice.action.upload', NULL, NULL, NULL, 1, N'logistics:invoice:upload', 5, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:07:52.237' AS DateTime), CAST(N'2024-05-16 19:40:14.560' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (209, 198, N'下载单据', N'abilities.logistics.child.invoice.action.download', NULL, NULL, NULL, 1, N'logistics:invoice:download', 6, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:08:20.213' AS DateTime), CAST(N'2022-09-28 19:08:20.213' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (210, 198, N'预览单据', N'abilities.logistics.child.invoice.action.preview', NULL, NULL, NULL, 1, N'logistics:invoice:preview', 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2022-09-28 19:07:23.493' AS DateTime), CAST(N'2022-09-28 19:07:23.493' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (211, 196, N'新增收货地址', N'abilities.logistics.child.customer.action.add_shipping_address', NULL, NULL, NULL, 1, N'logistics:receiver:save', 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-28 06:02:52.493' AS DateTime), CAST(N'2023-12-28 06:02:52.493' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (212, 196, N'修改收货地址', N'abilities.logistics.child.customer.action.edit_shipping_address', NULL, NULL, NULL, 1, N'logistics:receiver:update', 5, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-28 06:03:36.177' AS DateTime), CAST(N'2023-12-28 06:04:36.767' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (213, 196, N'删除收货地址', N'abilities.logistics.child.customer.action.delete_shipping_address', NULL, NULL, NULL, 1, N'logistics:receiver:remove', 6, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-28 06:04:10.467' AS DateTime), CAST(N'2023-12-28 06:04:10.467' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (192, 190, N'添加菜单', N'abilities.system.child.menu.action.add', NULL, NULL, NULL, 1, N'sys:menu:save', 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:28:55.663' AS DateTime), CAST(N'2023-12-27 16:28:55.663' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (193, 190, N'修改菜单', N'abilities.system.child.menu.action.edit', NULL, NULL, NULL, 1, N'sys:menu:update', 3, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:29:24.910' AS DateTime), CAST(N'2023-12-27 16:29:24.910' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (194, 190, N'删除菜单', N'abilities.system.child.menu.action.delete', NULL, NULL, NULL, 1, N'sys:menu:remove', 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:29:52.687' AS DateTime), CAST(N'2023-12-27 16:29:52.687' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (195, 0, N'物流发货', N'abilities.logistics.style', N'/logistics', N'el-icon-_component', NULL, 0, NULL, 4, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:32:39.783' AS DateTime), CAST(N'2023-12-27 16:32:39.783' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (196, 195, N'接收方管理', N'abilities.logistics.child.customer.style', N'/logistics/customer', N'el-icon-_user-group', N'/logistics/customer', 0, NULL, 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:33:33.057' AS DateTime), CAST(N'2023-12-27 16:34:30.637' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (197, 195, N'发货方管理', N'abilities.logistics.child.warehouse.style', N'/logistics/warehouse', N'el-icon-_shop', N'/logistics/warehouse', 0, NULL, 2, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 0, CAST(N'2023-12-27 16:35:07.183' AS DateTime), CAST(N'2023-12-27 16:35:07.183' AS DateTime), 2, NULL, 0)
INSERT [dbo].[sys_menu] ([id], [parentId], [title], [en_title], [path], [icon], [component], [menuType], [authority], [sortNumber], [hide], [active], [target], [closeable], [tabUnique], [meta], [color], [hideFooter], [hideSidebar], [createTime], [updateTime], [origin], [apiRoute], [estate]) VALUES (199, 196, N'新增接收方', N'abilities.logistics.child.customer.action.add_receiver', NULL, NULL, NULL, 1, N'logistics:customer:save', 1, 0, NULL, N'_self', 0, 0, NULL, NULL, 1, 1, CAST(N'2023-12-27 16:41:32.260' AS DateTime), CAST(N'2023-12-27 16:41:32.260' AS DateTime), 2, NULL, 0)
SET IDENTITY_INSERT [dbo].[sys_menu] OFF
SET IDENTITY_INSERT [dbo].[sys_role] ON 

INSERT [dbo].[sys_role] ([id], [roleName], [roleCode], [comments], [estate], [createTime], [updateTime]) VALUES (1, N'Administrator', N'R001', N'administrator', 0, CAST(N'2023-10-27 16:29:27.157' AS DateTime), CAST(N'2023-10-27 16:29:27.157' AS DateTime))
INSERT [dbo].[sys_role] ([id], [roleName], [roleCode], [comments], [estate], [createTime], [updateTime]) VALUES (6, N'Operator', N'R002', NULL, 0, CAST(N'2024-04-29 13:46:22.827' AS DateTime), CAST(N'2024-04-29 13:46:22.827' AS DateTime))
INSERT [dbo].[sys_role] ([id], [roleName], [roleCode], [comments], [estate], [createTime], [updateTime]) VALUES (7, N'monitor', N'R003', NULL, 0, CAST(N'2024-04-29 13:50:19.573' AS DateTime), CAST(N'2024-04-29 13:50:19.573' AS DateTime))
INSERT [dbo].[sys_role] ([id], [roleName], [roleCode], [comments], [estate], [createTime], [updateTime]) VALUES (8, N'Craftsman', N'R004', NULL, 0, CAST(N'2024-04-29 13:51:11.297' AS DateTime), CAST(N'2024-04-29 13:51:11.297' AS DateTime))
INSERT [dbo].[sys_role] ([id], [roleName], [roleCode], [comments], [estate], [createTime], [updateTime]) VALUES (9, N'QA', N'R005', NULL, 0, CAST(N'2024-04-29 15:55:41.497' AS DateTime), CAST(N'2024-04-29 15:55:41.497' AS DateTime))
SET IDENTITY_INSERT [dbo].[sys_role] OFF
SET IDENTITY_INSERT [dbo].[sys_role_menu] ON 

INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (11, 1, 87, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (12, 1, 89, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (13, 1, 117, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (14, 1, 171, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (15, 1, 115, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (16, 1, 116, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (17, 1, 88, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (18, 1, 118, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (19, 1, 119, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (20, 1, 120, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (21, 1, 121, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (22, 1, 90, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (23, 1, 125, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (24, 1, 122, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (25, 1, 123, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (26, 1, 124, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (27, 1, 92, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (28, 1, 126, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (29, 1, 127, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (30, 1, 128, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (31, 1, 129, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (32, 1, 93, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (33, 1, 130, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (34, 1, 131, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (35, 1, 132, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (36, 1, 133, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (37, 1, 134, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (38, 1, 135, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (39, 1, 136, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (40, 1, 103, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (41, 1, 104, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (42, 1, 137, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (43, 1, 100, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (44, 1, 101, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (45, 1, 138, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (46, 1, 139, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (47, 1, 140, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (48, 1, 141, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (49, 1, 144, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (50, 1, 145, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (51, 1, 186, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (52, 1, 172, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (53, 1, 142, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (54, 1, 143, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (55, 1, 146, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (56, 1, 147, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (57, 1, 148, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (58, 1, 189, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (59, 1, 185, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (60, 1, 187, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (61, 1, 188, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (62, 1, 168, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (63, 1, 169, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (64, 1, 170, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (65, 1, 96, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (66, 1, 97, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (67, 1, 149, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (68, 1, 98, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (69, 1, 150, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (70, 1, 99, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (71, 1, 151, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (72, 1, 1, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (73, 1, 2, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (74, 1, 3, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (75, 1, 4, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (76, 1, 5, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (77, 1, 6, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (78, 1, 7, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (79, 1, 8, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (80, 1, 9, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (81, 1, 10, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (82, 1, 11, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (83, 1, 102, CAST(N'2023-12-04 19:29:27.213' AS DateTime), CAST(N'2023-12-04 19:29:27.213' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (367, 7, 93, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (368, 7, 130, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (369, 7, 131, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (370, 7, 132, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (371, 7, 133, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (372, 7, 134, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (373, 7, 135, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (374, 7, 136, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (375, 7, 103, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (376, 7, 104, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (377, 7, 137, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (378, 7, 138, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (379, 7, 172, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (380, 7, 142, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (381, 7, 143, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (382, 7, 146, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (383, 7, 147, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (384, 7, 148, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (385, 7, 189, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (386, 7, 139, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (387, 7, 140, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (388, 7, 141, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (389, 7, 145, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (390, 7, 186, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (391, 7, 185, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (392, 7, 187, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
GO
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (393, 7, 188, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (394, 7, 87, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (395, 7, 100, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (396, 7, 101, CAST(N'2024-05-31 15:10:10.967' AS DateTime), CAST(N'2024-05-31 15:10:10.967' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (126, 8, 87, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (127, 8, 89, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (128, 8, 117, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (129, 8, 171, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (130, 8, 115, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (131, 8, 116, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (132, 8, 88, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (133, 8, 118, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (134, 8, 119, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (135, 8, 120, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (136, 8, 121, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (137, 8, 90, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (138, 8, 125, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (139, 8, 122, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (140, 8, 123, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (141, 8, 124, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (142, 8, 92, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (143, 8, 126, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (144, 8, 127, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (145, 8, 128, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (146, 8, 129, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (147, 8, 93, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (148, 8, 130, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (149, 8, 131, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (150, 8, 132, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (151, 8, 133, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (152, 8, 134, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (153, 8, 135, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (154, 8, 136, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (155, 8, 103, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (156, 8, 104, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (157, 8, 137, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (158, 8, 148, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (159, 8, 96, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (160, 8, 97, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (161, 8, 149, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (162, 8, 98, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (163, 8, 150, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (164, 8, 99, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (165, 8, 151, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (166, 8, 100, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (167, 8, 101, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (168, 8, 172, CAST(N'2024-04-29 13:52:02.930' AS DateTime), CAST(N'2024-04-29 13:52:02.930' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (187, 9, 87, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (188, 9, 89, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (189, 9, 117, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (190, 9, 171, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (191, 9, 115, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (192, 9, 116, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (193, 9, 88, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (194, 9, 118, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (195, 9, 119, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (196, 9, 120, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (197, 9, 121, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (198, 9, 90, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (199, 9, 125, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (200, 9, 122, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (201, 9, 123, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (202, 9, 124, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (203, 9, 92, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (204, 9, 126, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (205, 9, 127, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (206, 9, 128, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (207, 9, 129, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (208, 9, 93, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (209, 9, 130, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (210, 9, 131, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (211, 9, 132, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (212, 9, 133, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (213, 9, 134, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (214, 9, 135, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (215, 9, 136, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (216, 9, 103, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (217, 9, 104, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (218, 9, 137, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (219, 9, 100, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (220, 9, 101, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (221, 9, 138, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (222, 9, 172, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (223, 9, 142, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (224, 9, 143, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (225, 9, 146, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (226, 9, 147, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (227, 9, 148, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (228, 9, 189, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (229, 9, 139, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (230, 9, 140, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (231, 9, 141, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (232, 9, 144, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (233, 9, 145, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (234, 9, 186, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (235, 9, 168, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (236, 9, 169, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (237, 9, 170, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (238, 9, 185, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (239, 9, 187, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
GO
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (240, 9, 188, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (241, 9, 96, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (242, 9, 97, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (243, 9, 149, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (244, 9, 98, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (245, 9, 150, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (246, 9, 99, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (247, 9, 151, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (248, 9, 195, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (249, 9, 196, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (250, 9, 199, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (251, 9, 200, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (252, 9, 201, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (253, 9, 211, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (254, 9, 212, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (255, 9, 213, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (256, 9, 197, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (257, 9, 202, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (258, 9, 203, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (259, 9, 204, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (260, 9, 198, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (261, 9, 205, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (262, 9, 206, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (263, 9, 207, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (264, 9, 210, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (265, 9, 208, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (266, 9, 209, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (267, 9, 1, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (268, 9, 2, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (269, 9, 3, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (270, 9, 4, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (271, 9, 5, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (272, 9, 6, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (273, 9, 7, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (274, 9, 8, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (275, 9, 9, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (276, 9, 10, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (277, 9, 11, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (278, 9, 190, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (279, 9, 191, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (280, 9, 192, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (281, 9, 193, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (282, 9, 194, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (283, 9, 102, CAST(N'2024-04-29 15:55:58.473' AS DateTime), CAST(N'2024-04-29 15:55:58.473' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (307, 6, 103, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (308, 6, 104, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (309, 6, 137, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (310, 6, 138, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (311, 6, 139, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (312, 6, 140, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (313, 6, 141, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (314, 6, 145, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (315, 6, 186, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (316, 6, 185, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (317, 6, 187, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (318, 6, 188, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (319, 6, 100, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
INSERT [dbo].[sys_role_menu] ([id], [roleId], [menuId], [createTime], [updateTime]) VALUES (320, 6, 101, CAST(N'2024-05-30 17:36:24.783' AS DateTime), CAST(N'2024-05-30 17:36:24.783' AS DateTime))
SET IDENTITY_INSERT [dbo].[sys_role_menu] OFF
SET IDENTITY_INSERT [dbo].[sys_user] ON 

INSERT [dbo].[sys_user] ([id], [username], [password], [nickname], [organizationId], [avatar], [sex], [phone], [email], [card], [birthday], [introduction], [estate], [createTime], [updateTime], [lastToken], [lastLoginTime], [inside]) VALUES (1, N'admin', N'$2y$10$sqCayCF62qnGgoM7lX2yous7Gmw2/cbeDPRLBn.5ozH9yiuuyeKtu', N'Administrator', 0, N'https://cdn.eleadmin.com/20200610/avatar.jpg', 0, N'12345678901', N'admin@admin.com', NULL, CAST(N'2022-06-05 00:00:00.000' AS DateTime), N'阳光，帅气，善良', 0, CAST(N'2022-06-08 07:14:14.463' AS DateTime), CAST(N'2024-07-22 13:23:38.380' AS DateTime), N'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vMTkyLjE2OC44MC4yNDA6OTk5OS9hcGkvbG9naW4iLCJpYXQiOjE3MjE2MjU4MTgsImV4cCI6MTcyMjA1NzgxOCwibmJmIjoxNzIxNjI1ODE4LCJqdGkiOiJtUkVuQ3BFRW54Tk1ocGlDIiwic3ViIjoiMSIsInBydiI6IjdjYzkzNmRiNmM5NmQzZDkwNDY3OTg5M2Q0Mzc4ZmNiYzc2ZTIxMWYifQ.hTDzToU5Yx4sTBdqJPUAPOUiC29YuZs2SGWMkf-kEf8', CAST(N'2023-12-01 13:55:31.910' AS DateTime), 1)
INSERT [dbo].[sys_user] ([id], [username], [password], [nickname], [organizationId], [avatar], [sex], [phone], [email], [card], [birthday], [introduction], [estate], [createTime], [updateTime], [lastToken], [lastLoginTime], [inside]) VALUES (3, N'fuqiuyan', N'$2y$10$hujxILOy3LAddeAsqGALg.bz3zTjZPv9nwM.Vqaq8L1wc6Akjv1jq', N'符秋艳', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2024-04-29 15:34:39.943' AS DateTime), CAST(N'2024-07-01 13:06:01.283' AS DateTime), N'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vMTkyLjE2OC44MC4yNDA6OTAwMC9hcGkvbG9naW4iLCJpYXQiOjE3MTk4MTAzNjEsImV4cCI6MTcyMDI0MjM2MSwibmJmIjoxNzE5ODEwMzYxLCJqdGkiOiI0R1VFenl4cVpZZ25ISGFzIiwic3ViIjoiMyIsInBydiI6IjdjYzkzNmRiNmM5NmQzZDkwNDY3OTg5M2Q0Mzc4ZmNiYzc2ZTIxMWYifQ.Y_SWy6M4T78MYDn7oi1YjnpFa0MzSYFB0xPdnbtbpNM', NULL, 0)
INSERT [dbo].[sys_user] ([id], [username], [password], [nickname], [organizationId], [avatar], [sex], [phone], [email], [card], [birthday], [introduction], [estate], [createTime], [updateTime], [lastToken], [lastLoginTime], [inside]) VALUES (4, N'wuanxiang', N'$2y$10$MAAMJCb.z5JfPZaiLKNgCeclxbIdXn8xKAuefz0Ea1MhXUju/bb7e', N'吴岸香', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2024-04-29 15:50:21.190' AS DateTime), CAST(N'2024-04-29 15:50:52.313' AS DateTime), NULL, NULL, 0)
INSERT [dbo].[sys_user] ([id], [username], [password], [nickname], [organizationId], [avatar], [sex], [phone], [email], [card], [birthday], [introduction], [estate], [createTime], [updateTime], [lastToken], [lastLoginTime], [inside]) VALUES (5, N'CR', N'$2y$10$Jnnp5CDIEpojky28e86pXutH.6YVFKtNxP4I0aagO748F/bt0dFAm', N'崔叡', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2024-04-29 15:53:15.337' AS DateTime), CAST(N'2024-05-31 15:13:23.130' AS DateTime), N'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vMTkyLjE2OC44MC4yNDA6OTAwMC9hcGkvbG9naW4iLCJpYXQiOjE3MTcxMzk2MDMsImV4cCI6MTcxNzU3MTYwMywibmJmIjoxNzE3MTM5NjAzLCJqdGkiOiJ6Qk5QYWJzUlFGUmlHVlp5Iiwic3ViIjoiNSIsInBydiI6IjdjYzkzNmRiNmM5NmQzZDkwNDY3OTg5M2Q0Mzc4ZmNiYzc2ZTIxMWYifQ.9-qk4HWpRXOyiB9MiXEqpZhi62DiSnvg5Xib-Sj0LQs', NULL, 0)
INSERT [dbo].[sys_user] ([id], [username], [password], [nickname], [organizationId], [avatar], [sex], [phone], [email], [card], [birthday], [introduction], [estate], [createTime], [updateTime], [lastToken], [lastLoginTime], [inside]) VALUES (6, N'QA', N'$2y$10$tTA./KR6rRAVXk5X.Bk1e.i2DQjY4iWrY4TtF2EULQRyjgcwU8FPO', N'QA', 0, NULL, 0, NULL, NULL, NULL, NULL, NULL, 0, CAST(N'2024-04-29 15:56:16.787' AS DateTime), CAST(N'2024-04-29 15:56:30.110' AS DateTime), N'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vMTkyLjE2OC44MC4yNDA6OTAwMC9hcGkvbG9naW4iLCJpYXQiOjE3MTQzNzczOTAsImV4cCI6MTcxNDgwOTM5MCwibmJmIjoxNzE0Mzc3MzkwLCJqdGkiOiJvWVpOMWhuZnhObmdpN0I1Iiwic3ViIjoiNiIsInBydiI6IjdjYzkzNmRiNmM5NmQzZDkwNDY3OTg5M2Q0Mzc4ZmNiYzc2ZTIxMWYifQ.jaaAslghFAF0O8gHBvRr-ryBEc2sQpSgENK9fc0RrEA', NULL, 0)
SET IDENTITY_INSERT [dbo].[sys_user] OFF
SET IDENTITY_INSERT [dbo].[sys_user_role] ON 

INSERT [dbo].[sys_user_role] ([id], [userId], [roleId], [createTime], [updateTime]) VALUES (2, 2, 1, CAST(N'2023-10-27 18:42:03.990' AS DateTime), CAST(N'2023-10-27 18:42:03.990' AS DateTime))
INSERT [dbo].[sys_user_role] ([id], [userId], [roleId], [createTime], [updateTime]) VALUES (4, 3, 6, CAST(N'2024-04-29 15:34:54.873' AS DateTime), CAST(N'2024-04-29 15:34:54.873' AS DateTime))
INSERT [dbo].[sys_user_role] ([id], [userId], [roleId], [createTime], [updateTime]) VALUES (5, 4, 6, CAST(N'2024-04-29 15:50:21.190' AS DateTime), CAST(N'2024-04-29 15:50:21.190' AS DateTime))
INSERT [dbo].[sys_user_role] ([id], [userId], [roleId], [createTime], [updateTime]) VALUES (6, 5, 7, CAST(N'2024-04-29 15:53:15.337' AS DateTime), CAST(N'2024-04-29 15:53:15.337' AS DateTime))
INSERT [dbo].[sys_user_role] ([id], [userId], [roleId], [createTime], [updateTime]) VALUES (7, 6, 9, CAST(N'2024-04-29 15:56:16.790' AS DateTime), CAST(N'2024-04-29 15:56:16.790' AS DateTime))
SET IDENTITY_INSERT [dbo].[sys_user_role] OFF
SET IDENTITY_INSERT [dbo].[ware_customer] ON 

INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (10, N'REC010', N'0', N'TWi Pharmaceuticals USA, Inc.', NULL, N'test', N'0324979000008', N'07652', N'US', N'NJ', N'Paramus', N'Suite 180', N'115 West Century Road', 1, 1, CAST(N'2024-05-16 13:20:24.660' AS DateTime), CAST(N'2024-05-16 13:20:24.660' AS DateTime), N'0324979.00000.1')
INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (11, N'REC011', N'REC010', N'EVERSANA Life Science Services, LLC', NULL, N'111', N'0842671145884', N'38141', N'US', N'TN', N'Memphis', N'Challenge Drive', N'5650', 1, 1, CAST(N'2024-05-16 13:21:39.040' AS DateTime), CAST(N'2024-05-16 13:21:39.040' AS DateTime), N'08426711.4588.0')
INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (12, N'REC012', N'REC010', N'Upsher-Smith Laboratories, LLC', NULL, N'1231', N'0302450000006', N'55369-6026', N'US', N'MN', N'Maple Grove', N'Minnesota', N'6701 Evenstad Dr N', 1, 1, CAST(N'2024-05-16 13:59:15.203' AS DateTime), CAST(N'2024-05-16 13:59:15.203' AS DateTime), N'030245.000000.0')
INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (4, N'SED004', N'0', N'TWi Pharmaceuticals USA, Inc.', NULL, NULL, N'0324979000008', N'07652', N'US', N'NJ', N'Paramus', N'Suite 180', N'115 West Century Road', 0, 1, CAST(N'2024-04-09 16:03:05.907' AS DateTime), CAST(N'2024-04-09 16:03:05.907' AS DateTime), N'0324979.00000.1')
INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (8, N'REC008', N'0', N'EVERSANA Life Science Services, LLC', NULL, N'11', N'0842671145884', N'38141', N'US', N'TN', N'Memphis', N'Challenge Drive', N'5650', 1, 1, CAST(N'2024-04-13 12:27:21.217' AS DateTime), CAST(N'2024-04-13 12:27:21.217' AS DateTime), N'08426711.4588.0')
INSERT [dbo].[ware_customer] ([id], [cusCode], [parentCode], [cusName], [mobile], [email], [gln], [postCode], [country], [state], [city], [district], [street], [typeFlag], [estate], [createTime], [updateTime], [sgln]) VALUES (9, N'REC009', N'REC008', N'EVERSANA Life Science Services, LLC', NULL, N'1111', N'0842671145884', N'38141', N'US', N'TN', N'Memphis', N'Challenge Drive', N'5650', 1, 1, CAST(N'2024-04-13 12:28:32.027' AS DateTime), CAST(N'2024-04-13 12:28:32.027' AS DateTime), N'08426711.4588.0')
SET IDENTITY_INSERT [dbo].[ware_customer] OFF
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__basic_co__4741D1291D7C8B8C]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[basic_company] ADD  CONSTRAINT [PK__basic_co__4741D1291D7C8B8C] PRIMARY KEY NONCLUSTERED 
(
	[companyPrefix] 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) ON [PRIMARY]
GO
/****** Object:  Index [PK__basic_le__BE500FE2158C1F06]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[basic_level] ADD PRIMARY KEY NONCLUSTERED 
(
	[levelCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__basic_li__69D6E9CBFF7D5231]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[basic_line] ADD  CONSTRAINT [PK__basic_li__69D6E9CBFF7D5231] PRIMARY KEY NONCLUSTERED 
(
	[lineCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__basic_pl__924CAA20FA18D38C]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[basic_plant] ADD  CONSTRAINT [PK__basic_pl__924CAA20FA18D38C] PRIMARY KEY NONCLUSTERED 
(
	[plantCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__products__C2068389AEEBA166]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[basic_product] ADD  CONSTRAINT [PK__products__C2068389AEEBA166] PRIMARY KEY NONCLUSTERED 
(
	[productCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__orders__78CD1049AC8DA072]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [PK__orders__78CD1049AC8DA072] PRIMARY KEY NONCLUSTERED 
(
	[batchNo] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sn_code__357D4CF977EC2103]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [PK__sn_code__357D4CF977EC2103] PRIMARY KEY NONCLUSTERED 
(
	[code] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_depl__1244714B947F8FA2]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_deploy] ADD PRIMARY KEY NONCLUSTERED 
(
	[deployCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_dict__A38B5D2DA71E6378]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_dictionary] ADD PRIMARY KEY NONCLUSTERED 
(
	[dictCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_dict__09A3E84DDD7092DA]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_dictionary_data] ADD PRIMARY KEY NONCLUSTERED 
(
	[dictDataCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_orga__A123FF11DC661DAF]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_organization] ADD PRIMARY KEY NONCLUSTERED 
(
	[organizationFullName] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_role__44FD4F90E5386D9E]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_role] ADD PRIMARY KEY NONCLUSTERED 
(
	[roleCode] 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) ON [PRIMARY]
GO
SET ANSI_PADDING ON

GO
/****** Object:  Index [PK__sys_user__F3DBC5722AC0E091]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[sys_user] ADD PRIMARY KEY NONCLUSTERED 
(
	[username] 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) ON [PRIMARY]
GO
/****** Object:  Index [PK__transit___357D4CF9B9D125AD]    Script Date: 2024/7/22 15:09:59 ******/
ALTER TABLE [dbo].[transit_code] ADD PRIMARY KEY NONCLUSTERED 
(
	[code] 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) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ldap_config] ADD  DEFAULT ((1)) FOR [flag]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF_t_orders_dataID]  DEFAULT ((0)) FOR [dataID]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__productI__6C190EBB]  DEFAULT ((0)) FOR [productId]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__plantId__6D0D32F4]  DEFAULT ((0)) FOR [plantId]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__lineId__6E01572D]  DEFAULT ((0)) FOR [lineId]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__planAmou__6EF57B66]  DEFAULT ((0)) FOR [planAmount]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__actualAm__6FE99F9F]  DEFAULT ((0)) FOR [actualAmount]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__estate__70DDC3D8]  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__createTi__71D1E811]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[produce_order] ADD  CONSTRAINT [DF__orders__updateTi__72C60C4A]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[produce_order] ADD  DEFAULT ((0)) FOR [method]
GO
ALTER TABLE [dbo].[produce_order] ADD  DEFAULT ('OA') FOR [poPrefix]
GO
ALTER TABLE [dbo].[produce_order] ADD  DEFAULT ((0)) FOR [generateFlag]
GO
ALTER TABLE [dbo].[produce_order_proof] ADD  DEFAULT ((0)) FOR [proofFinished]
GO
ALTER TABLE [dbo].[produce_order_proof] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[produce_order_proof] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT ((0)) FOR [totalLevel]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT ((0)) FOR [amount]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT ((0)) FOR [waitFlag]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[produce_order_request] ADD  CONSTRAINT [DF_produce_order_request_orderId]  DEFAULT ((0)) FOR [orderId]
GO
ALTER TABLE [dbo].[produce_order_transfer] ADD  CONSTRAINT [DF__produce_o__typeF__69C6B1F5]  DEFAULT ('DA') FOR [typeNo]
GO
ALTER TABLE [dbo].[produce_order_transfer] ADD  CONSTRAINT [DF_produce_order_transfer_codeFlag]  DEFAULT ((0)) FOR [codeFlag]
GO
ALTER TABLE [dbo].[produce_order_transfer] ADD  CONSTRAINT [DF__produce_o__statu__6ABAD62E]  DEFAULT ((0)) FOR [statusFlag]
GO
ALTER TABLE [dbo].[produce_order_transfer] ADD  CONSTRAINT [DF__produce_o__creat__6BAEFA67]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[produce_order_transfer] ADD  CONSTRAINT [DF__produce_o__updat__6CA31EA0]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[produce_repacking] ADD  DEFAULT ((0)) FOR [productId]
GO
ALTER TABLE [dbo].[produce_repacking] ADD  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[produce_repacking] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[produce_repacking] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF__sn_code__dataID__75A278F5]  DEFAULT ((0)) FOR [dataID]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF__sn_code__fileID__76969D2E]  DEFAULT ((0)) FOR [fileID]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF_sn_code_filterValue]  DEFAULT ((0)) FOR [filterValue]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF__sn_code__estate__778AC167]  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF__sn_code__createT__787EE5A0]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sn_code] ADD  CONSTRAINT [DF__sn_code__updateT__797309D9]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sn_code] ADD  DEFAULT ('tracelink') FOR [codeStyle]
GO
ALTER TABLE [dbo].[sn_generate] ADD  DEFAULT ((0)) FOR [endNo]
GO
ALTER TABLE [dbo].[sn_generate] ADD  CONSTRAINT [DF_sn_generate_flagBit]  DEFAULT ((0)) FOR [flagBit]
GO
ALTER TABLE [dbo].[sn_generate] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sn_generate] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__dataI__57DD0BE4]  DEFAULT ((0)) FOR [dataID]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__plant__58D1301D]  DEFAULT ((0)) FOR [plantId]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF_sn_record_filterValue]  DEFAULT ((0)) FOR [filterValue]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__typeF__59C55456]  DEFAULT ((0)) FOR [typeFlag]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__amoun__5AB9788F]  DEFAULT ((0)) FOR [amount]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__freeA__5BAD9CC8]  DEFAULT ((0)) FOR [freeAmount]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__accou__5CA1C101]  DEFAULT ('TEST') FOR [accountType]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__uid__5D95E53A]  DEFAULT ((0)) FOR [uid]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__estat__5E8A0973]  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__creat__5F7E2DAC]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__updat__607251E5]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sn_record] ADD  CONSTRAINT [DF__sn_record__codeS__4E53A1AA]  DEFAULT ('tracelink') FOR [codeStyle]
GO
ALTER TABLE [dbo].[sys_dictionary] ADD  DEFAULT ((0)) FOR [sortNumber]
GO
ALTER TABLE [dbo].[sys_dictionary] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sys_dictionary] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sys_dictionary_data] ADD  DEFAULT ((0)) FOR [dictId]
GO
ALTER TABLE [dbo].[sys_dictionary_data] ADD  DEFAULT ((0)) FOR [sortNumber]
GO
ALTER TABLE [dbo].[sys_dictionary_data] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sys_dictionary_data] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__sys_opera__clien__7A672E12]  DEFAULT ('127.0.0.1') FOR [clientIp]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__operate_l__spend__4316F928]  DEFAULT ((0)) FOR [spendTime]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__operate_l__estat__440B1D61]  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__operate_l__tenan__44FF419A]  DEFAULT ((0)) FOR [tenanId]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__operate_l__creat__45F365D3]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__operate_l__updat__46E78A0C]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF__sys_opera__origi__00200768]  DEFAULT ((2)) FOR [origin]
GO
ALTER TABLE [dbo].[sys_operate_record] ADD  CONSTRAINT [DF_sys_operate_record_keyWord]  DEFAULT ('') FOR [keyword]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT ((0)) FOR [parentId]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT ((0)) FOR [sortNumber]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT ((0)) FOR [tenantId]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT ((0)) FOR [leaderId]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[sys_organization] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [dataID]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [orderId]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [levelCode]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [amount]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [typeFlag]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [reqID]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [codeFlag]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [boxFlag]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [fileID]
GO
ALTER TABLE [dbo].[transit_code] ADD  DEFAULT ((0)) FOR [zeroBox]
GO
ALTER TABLE [dbo].[ware_code] ADD  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[ware_code] ADD  DEFAULT ((1)) FOR [type]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF_ware_order_plantID]  DEFAULT ((0)) FOR [plantId]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF_ware_order_completeFlag]  DEFAULT ((0)) FOR [completeFlag]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF__ware_orde__estat__1F98B2C1]  DEFAULT ((0)) FOR [estate]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF__ware_orde__creat__208CD6FA]  DEFAULT (getdate()) FOR [createTime]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF__ware_orde__updat__2180FB33]  DEFAULT (getdate()) FOR [updateTime]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF__ware_orde__order__4F47C5E3]  DEFAULT ((0)) FOR [orderType]
GO
ALTER TABLE [dbo].[ware_order] ADD  CONSTRAINT [DF__ware_orde__outbo__503BEA1C]  DEFAULT ('OA') FOR [outboundType]
GO
ALTER TABLE [dbo].[wms_api_log] ADD  DEFAULT (getdate()) FOR [createTime]
GO
/****** Object:  StoredProcedure [dbo].[demoProduce]    Script Date: 2024/7/22 15:09:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


CREATE PROCEDURE [dbo].[demoProduce] (@orderId int)
as 

declare @boxAmount int 
declare @primaryAmount int 

set @boxAmount = 2
set @primaryAmount = 3

declare @L1 int
declare @L3 int
declare @L4 int
 
select @L1 = sum((case when levelCode = 1 then 1 else 0 end)),@L3 = sum((case when levelCode = 3 then 1 else 0 end)),@L4 = sum((case when levelCode = 4 then 1 else 0 end)) from transit_code where orderId = @orderId and  codeFlag = 0

if @L4 < 1
begin 
select @L4 as r, '托盘数量不足' as t
return 
end 

if @L1 < @primaryAmount
begin 
select @L1 as r,@primaryAmount as a, '小盒码数量不足' as t
return 
end 

if @L3 < @boxAmount
begin 
select @L3 as r,@boxAmount as a, '大箱码数量不足' as t
return 
end 


declare @palletCode varchar(50)
select top 1 @palletCode = code from transit_code where orderId = @orderId and levelCode = 4  and codeFlag = 0 

--包装比例需要同步修改下面的语句
while @boxAmount>0
begin 
declare @boxCode varchar(50)
select top 1 @boxCode = code from transit_code where orderId = @orderId and levelCode = 3  and codeFlag = 0 

update transit_code set parentCode = @boxCode,boxCode = @boxCode,palletCode = @palletCode,updateTime = DATEADD(mi,2,createTime),codeFlag = 2 where id in 
(select top 5 id from transit_code where orderId = @orderId and levelCode = 1 and codeFlag = 0 )


update transit_code set parentCode = @palletCode,boxCode = @boxCode,amount = 5,palletCode = @palletCode,updateTime = DATEADD(mi,4,createTime),codeFlag = 2 where code = @boxCode
set @boxAmount-=1
end 

update transit_code set updateTime = DATEADD(mi,5,createTime),codeFlag = 2,amount = @boxAmount,palletCode = @palletCode where code = @palletCode

select 'success'






GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品代码类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'basic_product', @level2type=N'COLUMN',@level2name=N'productCodeType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'产品代码数值' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'basic_product', @level2type=N'COLUMN',@level2name=N'productCodeValue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0-未发送 1-已发送' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'basic_product', @level2type=N'COLUMN',@level2name=N'sendStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0：禁用；1：启用' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ldap_config', @level2type=N'COLUMN',@level2name=N'flag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1-成功 2失败' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'produce_order_send_log', @level2type=N'COLUMN',@level2name=N'estate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0:L1,   1:L2,   2:L3,     3:API' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'sys_operate_record', @level2type=N'COLUMN',@level2name=N'origin'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N' 0 整箱  1零箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'transit_code_temporary', @level2type=N'COLUMN',@level2name=N'boxFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'未使用9=>0    扫描0=>2  取样2=>3  废弃1=>4' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'transit_code_temporary', @level2type=N'COLUMN',@level2name=N'codeFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1-出入库类型 2 销毁类型 3抽检类型' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_code', @level2type=N'COLUMN',@level2name=N'type'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'工厂ID对应basic_plant表的ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'plantId'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'单据编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'wareCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应ware_customer表的cusCode,typeflag = 0' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'wareHouseCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应ware_customer表的cusCode,typeflag = 1,parentCode = ''''' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'cusCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'对应ware_customer表的cusCode,typeflag = 1,parentCode 不为空' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'receiverCode'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'出库日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'wareDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生产订单编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'poNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'批次列表   英文逗号分割' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'batchList'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'订单完成标志，默认为true' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'completeFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1 wms上传 2 pad上传' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ware_order', @level2type=N'COLUMN',@level2name=N'channel'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'1-请求日志 2 返回日志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'wms_api_log', @level2type=N'COLUMN',@level2name=N'type'
GO
