代码拉取完成，页面将自动刷新
USE [shiroboot]
GO
/****** Object: StoredProcedure [dbo].[GetIdentity] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GetIdentity]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [dbo].[GetIdentity]
-- Add the parameters for the stored procedure here
@tablename varchar(50),
@needcount int
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
--select 1;
declare @t1 int
declare @rvalue int
select @t1=count(1) from GY_IDENTITY where tablename=@tablename
if @t1=0
begin
insert into GY_IDENTITY values(@tablename,@needcount)
select 1;
end
else
begin
update GY_IDENTITY set @rvalue=value=value+@needcount where tablename=@tablename
select @rvalue-@needcount+1
end
END
'
END
GO
/****** Object: Table [dbo].[CharlieRegional] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieRegional]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieRegional](
[recID] [uniqueidentifier] NOT NULL,
[RegionalCode] [nvarchar](50) NULL,
[SalesMan] [nvarchar](50) NULL
) ON [PRIMARY]
END
GO
INSERT [dbo].[CharlieRegional] ([recID], [RegionalCode], [SalesMan]) VALUES (N'b8696d57-e6cb-4ac3-b55f-4b6aac6ef37a', N'01', N'01')
/****** Object: Table [dbo].[CharlieQuotation] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQuotation]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQuotation](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuotationNo] [varchar](50) NULL,
[QtnTopic] [varchar](200) NULL,
[CardCode] [varchar](50) NULL,
[CardName] [varchar](255) NULL,
[Delivery] [varchar](100) NULL,
[QtnType] [varchar](50) NULL,
[TradeType] [varchar](50) NULL,
[UserName] [varchar](50) NULL,
[TrueName] [varchar](50) NULL,
[Department] [nvarchar](50) NULL,
[CreateTime] [datetime] NULL,
[TimeRequire] [varchar](50) NULL,
[OutMemo] [varchar](max) NULL,
[InMemo] [varchar](max) NULL,
[Total] [decimal](18, 2) NULL,
[ContractNo] [varchar](50) NULL,
[ContractAmt] [decimal](18, 2) NULL,
[ContractTime] [datetime] NULL,
[Status] [int] NULL,
CONSTRAINT [PK_CharlieQuotation] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQuotation] ON
INSERT [dbo].[CharlieQuotation] ([ID], [QuotationNo], [QtnTopic], [CardCode], [CardName], [Delivery], [QtnType], [TradeType], [UserName], [TrueName], [Department], [CreateTime], [TimeRequire], [OutMemo], [InMemo], [Total], [ContractNo], [ContractAmt], [ContractTime], [Status]) VALUES (1, N'JB2007001', N'机械报价', NULL, N'JP株式会社', N'船厂', N'JB', N'自制', N'XS007', N'hy', N'营销中心', CAST(0x0000ABA5009D2B28 AS DateTime), NULL, N'作为出口产品制作，', NULL, NULL, NULL, NULL, NULL, 4)
SET IDENTITY_INSERT [dbo].[CharlieQuotation] OFF
/****** Object: Table [dbo].[CharlieQtnTimes] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnTimes]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnTimes](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuotationID] [int] NULL,
[QuotationTimes] [int] NULL,
[UserTrueName] [varchar](50) NULL,
[UserID] [uniqueidentifier] NULL,
[CreateTime] [datetime] NULL,
[Status] [int] NULL,
[ContractNo] [varchar](50) NULL,
[ContractAmt] [decimal](18, 4) NULL,
CONSTRAINT [PK_CharlieQtnTimes] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnTimes] ON
INSERT [dbo].[CharlieQtnTimes] ([ID], [QuotationID], [QuotationTimes], [UserTrueName], [UserID], [CreateTime], [Status], [ContractNo], [ContractAmt]) VALUES (1, 1, 1, N'HY', N'39a75315-324d-4b0f-8897-4f592006ffb0', CAST(0x0000ABA5009D2B28 AS DateTime), 4, NULL, CAST(0.0000 AS Decimal(18, 4)))
SET IDENTITY_INSERT [dbo].[CharlieQtnTimes] OFF
/****** Object: Table [dbo].[CharlieQtnStatus] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnStatus]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnStatus](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuotationID] [int] NULL,
[QtnTimesID] [int] NULL,
[InputedTime] [datetime] NULL,
[InputedUser] [varchar](50) NULL,
[TechCheckedTime] [datetime] NULL,
[TechCheckedUser] [varchar](50) NULL,
[PriceFinishedTime] [datetime] NULL,
[PriceFinishedUser] [varchar](50) NULL,
[QtnFinishedTime] [datetime] NULL,
[QtnFinishedUser] [varchar](50) NULL,
[ContractSignedTime] [datetime] NULL,
[ContractSignedUser] [varchar](50) NULL,
[CancelTime] [datetime] NULL,
[CancelUser] [varchar](50) NULL,
CONSTRAINT [PK_CharlieQtnStatus] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnStatus] ON
INSERT [dbo].[CharlieQtnStatus] ([ID], [QuotationID], [QtnTimesID], [InputedTime], [InputedUser], [TechCheckedTime], [TechCheckedUser], [PriceFinishedTime], [PriceFinishedUser], [QtnFinishedTime], [QtnFinishedUser], [ContractSignedTime], [ContractSignedUser], [CancelTime], [CancelUser]) VALUES (1, 1, 1, CAST(0x0000ABA5009D2B28 AS DateTime), N'hy', CAST(0x0000ABB6008EC218 AS DateTime), N'zy', CAST(0x0000ABB600A2411C AS DateTime), N'fyy', CAST(0x0000ABB600ACD550 AS DateTime), N'管理员', NULL, NULL, NULL, NULL)
SET IDENTITY_INSERT [dbo].[CharlieQtnStatus] OFF
/****** Object: Table [dbo].[CharlieQtnProductCost] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnProductCost]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnProductCost](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuotationID] [int] NULL,
[ConfirmName] [nvarchar](50) NULL,
[Quantity] [int] NULL,
[CostItemName] [nvarchar](50) NULL,
[CostPrice] [decimal](18, 2) NULL,
[CostAmount] [decimal](18, 2) NULL,
[ProductId] [int] NULL,
[CostItemID] [int] NULL,
[UserName] [varchar](50) NULL,
[TrueName] [varchar](50) NULL,
[CreateTime] [datetime] NULL,
[CostType] [varchar](50) NULL,
CONSTRAINT [PK_CharlieQtnProductCost] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnProductCost] ON
INSERT [dbo].[CharlieQtnProductCost] ([ID], [QuotationID], [ConfirmName], [Quantity], [CostItemName], [CostPrice], [CostAmount], [ProductId], [CostItemID], [UserName], [TrueName], [CreateTime], [CostType]) VALUES (1, 2, N'HC-2t/8m液压回转起重机', 1, N'技术预算总计', CAST(169640.00 AS Decimal(18, 2)), CAST(169640.00 AS Decimal(18, 2)), 2, 1, N'JS002', N'周云', CAST(0x0000ABA600DE9D74 AS DateTime), N'按产品')
SET IDENTITY_INSERT [dbo].[CharlieQtnProductCost] OFF
/****** Object: Table [dbo].[CharlieQtnProduct] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnProduct]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnProduct](
[ID] [int] IDENTITY(1,1) NOT NULL,
[QuotationID] [int] NULL,
[ProductName] [varchar](100) NULL,
[ConfirmName] [varchar](100) NULL,
[ProductCode] [varchar](50) NULL,
[Specification] [varchar](100) NULL,
[Unit] [varchar](50) NULL,
[Quantity] [decimal](18, 2) NULL,
CONSTRAINT [PK_CharlieQtnProduct] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnProduct] ON
INSERT [dbo].[CharlieQtnProduct] ([ID], [QuotationID], [ProductName], [ConfirmName], [ProductCode], [Specification], [Unit], [Quantity]) VALUES (1, 1, N'38液压机及配件', N'38液压机及配件', NULL, NULL, N'台', CAST(1.00 AS Decimal(18, 2)))
SET IDENTITY_INSERT [dbo].[CharlieQtnProduct] OFF
/****** Object: Table [dbo].[CharlieQtnCostItem] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnCostItem]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnCostItem](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CostItemName] [varchar](255) NULL,
[SequenceNo] [int] NULL,
[Memo] [varchar](255) NULL,
[CreateTime] [datetime] NOT NULL,
[IsValid] [int] NULL,
[TrueName] [varchar](50) NULL,
[CostType] [varchar](50) NULL,
CONSTRAINT [PK_CharlieQtnCostItem] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnCostItem] ON
INSERT [dbo].[CharlieQtnCostItem] ([ID], [CostItemName], [SequenceNo], [Memo], [CreateTime], [IsValid], [TrueName], [CostType]) VALUES (1, N'技术预算总计', 1, NULL, CAST(0x0000ABA600D5FFFC AS DateTime), 1, N'D635E8AA-C461-4A62-B8A4-598F787F6138', N'按产品')
SET IDENTITY_INSERT [dbo].[CharlieQtnCostItem] OFF
/****** Object: Table [dbo].[CharlieQtnAttachment] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieQtnAttachment]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieQtnAttachment](
[ID] [int] IDENTITY(1,1) NOT NULL,
[FileName] [nvarchar](50) NULL,
[TransTime] [datetime] NULL,
[Url] [varchar](500) NULL,
[UserName] [varchar](50) NULL,
[TrueName] [varchar](50) NULL,
[QuotationID] [int] NULL,
CONSTRAINT [PK_CharlieQtnAttachment] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieQtnAttachment] ON
INSERT [dbo].[CharlieQtnAttachment] ([ID], [FileName], [TransTime], [Url], [UserName], [TrueName], [QuotationID]) VALUES (1, N'报价资料.docx', CAST(0x0000ABA5009D6CC8 AS DateTime), N'd:\quotation\JB2007001\报价资料.docx', N'XS007', N'XS007', 1)
SET IDENTITY_INSERT [dbo].[CharlieQtnAttachment] OFF
/****** Object: Table [dbo].[CharlieOuttb_user] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOuttb_user]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOuttb_user](
[userId] [int] IDENTITY(1,1) NOT NULL,
[username] [nvarchar](50) NOT NULL,
[truename] [nvarchar](50) NULL,
[mobile] [nvarchar](20) NOT NULL,
[password] [nvarchar](255) NULL,
[createTime] [datetime2](7) NULL,
CONSTRAINT [PK_CharlieOuttb_user] PRIMARY KEY CLUSTERED
(
[userId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOuttb_user] ON
INSERT [dbo].[CharlieOuttb_user] ([userId], [username], [truename], [mobile], [password], [createTime]) VALUES (1, N'admin', N'管理员', N'13888888888', N'25D55AD283AA400AF464C76D713C07AD', CAST(0x070037B1364F31390B AS DateTime2))
SET IDENTITY_INSERT [dbo].[CharlieOuttb_user] OFF
/****** Object: Table [dbo].[CharlieOuttb_token] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOuttb_token]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOuttb_token](
[userId] [bigint] IDENTITY(1,1) NOT NULL,
[token] [nvarchar](100) NOT NULL,
[expireTime] [datetime2](7) NULL,
[updateTime] [datetime2](7) NULL,
CONSTRAINT [PK_CharlieOuttb_token] PRIMARY KEY CLUSTERED
(
[userId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object: Table [dbo].[CharlieOutsys_user_role] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_user_role]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_user_role](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[userId] [bigint] NULL,
[roleId] [bigint] NULL,
CONSTRAINT [PK_CharlieOutsys_user_role] 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]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_user_role] ON
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (2, 1, 1)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (8, 4, 3)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (9, 5, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (10, 6, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (11, 7, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (16, 30, 6)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (19, 39, 8)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (21, 36, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (22, 35, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (23, 32, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (24, 29, 6)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (25, 28, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (26, 26, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (27, 25, 6)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (28, 23, 3)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (29, 19, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (30, 18, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (31, 16, 2)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (32, 15, 4)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (33, 13, 7)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (34, 10, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (36, 42, 7)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (37, 41, 8)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (38, 38, 8)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (39, 31, 5)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (40, 43, 9)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (41, 3, 2)
INSERT [dbo].[CharlieOutsys_user_role] ([id], [userId], [roleId]) VALUES (42, 47, 10)
SET IDENTITY_INSERT [dbo].[CharlieOutsys_user_role] OFF
/****** Object: Table [dbo].[CharlieOutsys_user] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_user]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_user](
[userId] [bigint] IDENTITY(1,1) NOT NULL,
[username] [nvarchar](50) NOT NULL,
[truename] [nvarchar](50) NULL,
[password] [nvarchar](100) NULL,
[department] [nvarchar](50) NULL,
[areaCode] [nvarchar](10) NULL,
[flowNo] [int] NULL,
[power] [int] NOT NULL,
[email] [nvarchar](100) NULL,
[mobile] [nvarchar](100) NULL,
[status] [numeric](3, 0) NULL,
[createUserId] [bigint] NULL,
[createTime] [datetime2](7) NULL,
CONSTRAINT [PK_CharlieOutsys_user] PRIMARY KEY CLUSTERED
(
[userId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_user] ON
INSERT [dbo].[CharlieOutsys_user] ([userId], [username], [truename], [password], [department], [areaCode], [flowNo], [power], [email], [mobile], [status], [createUserId], [createTime]) VALUES (1, N'admin', N'管理员', N'21232F297A57A5A743894A0E4A801FC3', N'无', N'99', 35, 3, N'100@qq.com', N'13666666666', CAST(1 AS Numeric(3, 0)), 0, CAST(0x0700E0996282E03C0B AS DateTime2))
SET IDENTITY_INSERT [dbo].[CharlieOutsys_user] OFF
/****** Object: Table [dbo].[CharlieOutsys_role_menu] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_role_menu]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_role_menu](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[roleId] [bigint] NULL,
[menuId] [bigint] NULL,
CONSTRAINT [PK_CharlieOutsys_role_menu] 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]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_role_menu] ON
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (1, 1, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (2, 1, 2)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (3, 1, 15)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (4, 1, 16)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (5, 1, 17)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (6, 1, 18)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (7, 1, 3)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (8, 1, 19)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (9, 1, 20)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (10, 1, 21)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (11, 1, 22)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (12, 1, 4)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (13, 1, 23)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (14, 1, 24)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (15, 1, 25)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (16, 1, 26)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (17, 1, 5)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (18, 1, 6)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (19, 1, 7)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (20, 1, 8)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (21, 1, 9)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (22, 1, 10)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (23, 1, 11)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (24, 1, 12)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (25, 1, 13)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (26, 1, 14)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (27, 1, 27)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (28, 1, 29)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (29, 1, 28)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (213, 3, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (214, 3, 2)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (215, 3, 15)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (216, 3, 3)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (217, 3, 19)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (218, 3, 4)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (219, 3, 23)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (220, 3, 29)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (221, 3, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (222, 3, 34)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (223, 3, 35)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (224, 3, 36)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (225, 3, 37)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (226, 3, 31)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (227, 3, 44)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (228, 3, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (229, 3, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (230, 3, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (231, 3, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (232, 3, 52)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (233, 3, 53)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (234, 3, 54)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (235, 3, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (236, 3, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (237, 3, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (238, 3, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (239, 3, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (240, 3, 60)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (241, 3, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (242, 3, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (243, 3, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (244, 3, 67)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (245, 3, 55)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (246, 3, 56)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (247, 3, 57)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (248, 3, 58)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (249, 3, 59)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (250, 3, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (251, 3, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (252, 3, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (285, 8, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (286, 8, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (287, 8, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (288, 8, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (289, 8, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (290, 8, 52)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (291, 8, 53)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (292, 8, 54)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (293, 8, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (294, 8, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (295, 8, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (296, 8, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (297, 8, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (298, 8, 60)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (299, 8, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (300, 8, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (301, 8, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (302, 8, 67)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (303, 8, 55)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (304, 8, 56)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (305, 8, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (306, 8, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (307, 8, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (315, 7, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (316, 7, 2)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (317, 7, 15)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (318, 7, 29)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (319, 7, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (320, 7, 34)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (321, 7, 35)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (322, 7, 36)
GO
print 'Processed 100 total records'
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (323, 7, 37)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (324, 7, 31)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (325, 7, 44)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (326, 7, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (327, 7, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (328, 7, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (329, 7, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (330, 7, 52)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (331, 7, 53)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (332, 7, 54)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (333, 7, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (334, 7, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (335, 7, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (336, 7, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (337, 7, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (338, 7, 60)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (339, 7, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (340, 7, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (341, 7, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (342, 7, 67)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (343, 7, 55)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (344, 7, 56)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (345, 7, 57)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (346, 7, 58)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (347, 7, 59)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (348, 7, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (349, 7, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (350, 7, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (378, 5, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (379, 5, 2)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (380, 5, 15)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (381, 5, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (382, 5, 34)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (383, 5, 36)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (384, 5, 37)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (385, 5, 31)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (386, 5, 44)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (387, 5, 72)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (388, 5, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (389, 5, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (390, 5, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (391, 5, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (392, 5, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (393, 5, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (394, 5, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (395, 5, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (396, 5, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (397, 5, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (398, 5, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (399, 5, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (400, 5, 57)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (401, 5, 58)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (402, 5, 59)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (403, 5, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (404, 5, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (405, 5, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (406, 6, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (407, 6, 2)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (408, 6, 15)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (409, 6, 4)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (410, 6, 23)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (411, 6, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (412, 6, 37)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (413, 6, 31)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (414, 6, 44)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (415, 6, 72)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (416, 6, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (417, 6, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (418, 6, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (419, 6, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (420, 6, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (421, 6, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (422, 6, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (423, 6, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (424, 6, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (425, 6, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (426, 6, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (427, 6, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (428, 6, 67)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (429, 6, 57)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (430, 6, 58)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (431, 6, 59)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (432, 6, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (433, 6, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (434, 6, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (435, 4, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (436, 4, 34)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (437, 4, 35)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (438, 4, 36)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (439, 4, 78)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (440, 4, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (441, 4, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (442, 4, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (467, 2, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (468, 2, 37)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (469, 2, 68)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (470, 2, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (471, 2, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (472, 2, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (473, 2, 74)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (474, 2, 75)
GO
print 'Processed 200 total records'
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (475, 2, 76)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (476, 10, 1)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (477, 10, 3)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (478, 10, 19)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (479, 10, 4)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (480, 10, 23)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (481, 10, 6)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (482, 10, 7)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (483, 10, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (484, 10, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (485, 10, 62)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (486, 10, 63)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (487, 10, 69)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (488, 10, 70)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (489, 10, 71)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (490, 10, 74)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (491, 10, 75)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (492, 10, 76)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (493, 10, 77)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (494, 10, 81)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (495, 10, 83)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (496, 10, 85)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (497, 10, 86)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (498, 9, 30)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (499, 9, 38)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (500, 9, 33)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (501, 9, 49)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (502, 9, 51)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (503, 9, 52)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (504, 9, 53)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (505, 9, 54)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (506, 9, 45)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (507, 9, 46)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (508, 9, 47)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (509, 9, 48)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (510, 9, 50)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (511, 9, 60)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (512, 9, 64)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (513, 9, 65)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (514, 9, 66)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (515, 9, 67)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (516, 9, 55)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (517, 9, 56)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (518, 9, 61)
INSERT [dbo].[CharlieOutsys_role_menu] ([id], [roleId], [menuId]) VALUES (519, 9, 70)
SET IDENTITY_INSERT [dbo].[CharlieOutsys_role_menu] OFF
/****** Object: Table [dbo].[CharlieOutsys_role] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_role]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_role](
[roleId] [bigint] IDENTITY(1,1) NOT NULL,
[roleName] [nvarchar](100) NULL,
[remark] [nvarchar](100) NULL,
[createUserId] [bigint] NULL,
[createTime] [datetime2](7) NULL,
CONSTRAINT [PK_CharlieOutsys_role] PRIMARY KEY CLUSTERED
(
[roleId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_role] ON
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (1, N'管理员', N'超级权限', 1, CAST(0x07E0EDF7E3509F410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (2, N'普通用户', N'一般权限', 1, CAST(0x07305B0B7C519F410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (3, N'高层管理', N'高层权限', 1, CAST(0x07F01014294EC9410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (4, N'采购经理', N'物资部', 1, CAST(0x07B00D2020A7D1410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (5, N'业务助理', N'业务员、助理', 1, CAST(0x0720BA461669D9410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (6, N'销售部门领导', N'销售部门领导', 1, CAST(0x07802A2E747BE0410B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (7, N'财务经理', N'财务部', 1, CAST(0x07C0E677205C02420B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (8, N'技术中心主任', N'技术中心', 1, CAST(0x07F099BA365C02420B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (9, N'仓管主管', N'仓管主管', 1, CAST(0x0760D50C414A42420B AS DateTime2))
INSERT [dbo].[CharlieOutsys_role] ([roleId], [roleName], [remark], [createUserId], [createTime]) VALUES (10, N'人事经理', N'人事经理', 1, CAST(0x077023F5337F8F420B AS DateTime2))
SET IDENTITY_INSERT [dbo].[CharlieOutsys_role] OFF
/****** Object: Table [dbo].[CharlieOutsys_menu] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_menu]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_menu](
[menuId] [bigint] IDENTITY(1,1) NOT NULL,
[parentId] [bigint] NULL,
[name] [nvarchar](50) NULL,
[url] [nvarchar](200) NULL,
[perms] [nvarchar](500) NULL,
[type] [int] NULL,
[icon] [nvarchar](50) NULL,
[orderNum] [int] NULL,
CONSTRAINT [PK_CharlieOutsys_menu] PRIMARY KEY CLUSTERED
(
[menuId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_menu] ON
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (1, 0, N'系统管理', NULL, NULL, 0, N'fa fa-cog', 1)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (2, 1, N'用户管理', N'sys/user.html', NULL, 1, N'fa fa-user', 2)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (3, 1, N'角色管理', N'sys/role.html', NULL, 1, N'fa fa-user-secret', 3)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (4, 1, N'菜单管理', N'sys/menu.html', NULL, 1, N'fa fa-th-list', 4)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (5, 1, N'SQL监控', N'druid/sql.html', NULL, 1, N'fa fa-bug', 5)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (6, 1, N'定时任务管理', N'sys/schedule.html', NULL, 1, N'fa fa-tasks', 6)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (7, 6, N'查看', NULL, N'sys:schedule:list,sys:schedule:info', 2, NULL, 7)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (8, 6, N'新增', NULL, N'sys:schedule:save', 2, NULL, 8)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (9, 6, N'修改', NULL, N'sys:schedule:update', 2, NULL, 9)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (10, 6, N'删除', NULL, N'sys:schedule:delete', 2, NULL, 10)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (11, 6, N'暂停', NULL, N'sys:schedule:pause', 2, NULL, 11)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (12, 6, N'恢复', NULL, N'sys:schedule:resume', 2, NULL, 12)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (13, 6, N'立即执行', NULL, N'sys:schedule:run', 2, NULL, 13)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (14, 6, N'日志列表', NULL, N'sys:schedule:log', 2, NULL, 14)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (15, 2, N'查看', NULL, N'sys:user:list,sys:user:info', 2, NULL, 15)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (16, 2, N'新增', NULL, N'sys:user:save,sys:role:select', 2, NULL, 16)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (17, 2, N'修改', NULL, N'sys:user:update,sys:role:select', 2, NULL, 17)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (18, 2, N'删除', NULL, N'sys:user:delete', 2, NULL, 18)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (19, 3, N'查看', NULL, N'sys:role:list,sys:role:info', 2, NULL, 19)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (20, 3, N'新增', NULL, N'sys:role:save,sys:menu:perms', 2, NULL, 20)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (21, 3, N'修改', NULL, N'sys:role:update,sys:menu:perms', 2, NULL, 21)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (22, 3, N'删除', NULL, N'sys:role:delete', 2, NULL, 22)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (23, 4, N'查看', NULL, N'sys:menu:list,sys:menu:info', 2, NULL, 23)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (24, 4, N'新增', NULL, N'sys:menu:save,sys:menu:select', 2, NULL, 24)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (25, 4, N'修改', NULL, N'sys:menu:update,sys:menu:select', 2, NULL, 25)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (26, 4, N'删除', NULL, N'sys:menu:delete', 2, NULL, 26)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (27, 1, N'参数管理', N'sys/config.html', N'sys:config:list,sys:config:info,sys:config:save,sys:config:update,sys:config:delete', 1, N'fa fa-sun-o', 27)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (28, 1, N'代码生成器', N'sys/generator.html', N'sys:generator:list,sys:generator:code', 1, N'fa fa-rocket', 28)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (29, 1, N'系统日志', N'sys/log.html', N'sys:log:list', 1, N'fa fa-file-text-o', 29)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (30, 0, N'业务管理', NULL, NULL, 0, N'fa fa-bank', 30)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (31, 37, N'月度数据', N'erp/salesInfo.html', N'erp:business:list', 1, N'fa fa-bar-chart', 31)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (33, 38, N'新增报价信息', N'erp/quotationAdd.html', N'erp:quotation:save', 1, N'fa fa-calendar', 41)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (34, 30, N'物资管理', NULL, NULL, 0, N'fa fa-car', 34)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (35, 34, N'评价数据上传', N'erp/supImportFile.html', N'erp:supplier:import', 1, N'fa fa-file-excel-o', 35)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (36, 34, N'评价结果查询', N'erp/supEvaluationResult.html', N'erp:supplier:result', 1, N'fa fa-search', 36)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (37, 30, N'营销管理', NULL, NULL, 0, N'fa fa-dollar', 37)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (38, 30, N'报价管理', NULL, NULL, 0, N'fa fa-file-text', 32)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (44, 37, N'应收账款查询', N'erp/accountReceive.html', N'erp:business:receive,erp:business:monthlyAR', 1, N'fa fa-id-card', 39)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (45, 38, N'报价单列表', N'erp/quotationList.html', N'erp:quotation:list', 1, N'fa fa-id-card', 48)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (46, 45, N'产品信息列表', NULL, N'erp:quotation:product:list', 2, NULL, 43)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (47, 45, N'新增报价信息', NULL, N'erp:quotation:head:save', 2, NULL, 44)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (48, 45, N'修改报价单附件', NULL, N'erp:quotation:attach', 2, NULL, 45)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (49, 33, N'新增产品信息', NULL, N'erp:quotation:product:save', 2, NULL, 46)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (50, 45, N'查询报价头', NULL, N'erp:quotation:head:queryID', 2, NULL, 47)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (51, 33, N'上传报价附件', NULL, N'erp:quotation:upload', 2, NULL, 51)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (52, 38, N'产品核价', N'erp/quotationCost.html', N'erp:quotation:cost:list', 1, N'fa fa-dollar', 42)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (53, 52, N'查看产品成本', NULL, N'erp:quotation:prodCost:list', 2, NULL, 52)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (54, 52, N'保存产品成本', NULL, N'erp:quotation:prodCost:save', 2, NULL, 53)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (55, 38, N'成本项目管理', N'erp/quotation/costItem', N'erp:quotation:costItem', 1, NULL, 50)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (56, 55, N'查看成本项目', NULL, N'erp:quotation:costItem:list', 2, NULL, 60)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (57, 37, N'客户评价', N'erp/card/eveluation', N'erp:card:eveluation', 0, N'fa fa-id-card', 49)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (58, 57, N'客户评价标准', N'erp/card/standard', N'erp:card:standard', 1, NULL, 54)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (59, 57, N'客户评价结果', N'erp/cusEvaluationResult.html', N'erp:card:evaluation', 1, NULL, 55)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (60, 45, N'删除产品', NULL, N'erp:quotation:product:delete', 2, NULL, 56)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (61, 30, N'数据中心', NULL, NULL, 0, N'fa fa-user', 57)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (62, 61, N'产品业务链', N'dataCenter/itemChain.html', NULL, 1, NULL, 58)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (63, 61, N'产品结构数据', N'dataCenter/itemDataList.html', NULL, 1, NULL, 59)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (64, 45, N'报价单附件上传文件', NULL, N'erp:quotation:attach:file', 2, NULL, 61)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (65, 45, N'上传报价单附件upload', NULL, N'erp:quotation:attach:upload', 2, NULL, 62)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (66, 45, N'报价头更新', NULL, N'erp:quotation:head:update', 2, NULL, 63)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (67, 45, N'报价产品更新', NULL, N'erp:quotation:product:update', 2, NULL, 64)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (68, 37, N'新应收样式', N'erp/receivables.html', NULL, 1, NULL, 62)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (69, 61, N'紧急订单跟踪', N'dataCenter/itemChainList.html', N'', 1, NULL, 65)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (70, 61, N'呆滞品列表', N'dataCenter/sluggishItem.html', NULL, 1, NULL, 70)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (71, 61, N'年度采购销售', N'dataCenter/yearlySummary.html', NULL, 1, NULL, 71)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (72, 37, N'产品客户销售统计', N'erp/salesItemCard.html', NULL, 1, N'fa fa-ship', 72)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (73, 34, N'月度、季度、年度表', N'erp/purchase/summary', NULL, 1, N'fa fa-bar-chart', 73)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (74, 30, N'生产管理', N'erp\produce', NULL, 0, N'fa fa-gears', 74)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (75, 74, N'工艺路线管理', N'erp/pruduce/process', NULL, 1, N'fa fa-road', 75)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (76, 74, N'计件统计', N'erp/produce/byPiece', NULL, 1, N'fa fa-cubes', 76)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (77, 74, N'物料清单BOM', N'produce/produce.html', NULL, 1, N'fa fa-book', 77)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (78, 34, N'采购统计表', N'erp/buy/buyInfo.html', NULL, 1, NULL, 78)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (81, 74, N'物料底层用量', N'produce/useage.html', NULL, 1, N'fa fa-flask', 82)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (82, 30, N'管理驾驶舱', N'cockpit/index.html', NULL, 1, N'fa fa-bar-chart', 83)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (83, 74, N'PLM与SAP物料对照', N'produce/reference.html', NULL, 1, N'fa fa-clone', 84)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (84, 3, N'ureport', NULL, N'admin:ureport:designer', 2, NULL, 0)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (85, 0, N'人力资源', NULL, NULL, 0, N'fa fa-user', 85)
INSERT [dbo].[CharlieOutsys_menu] ([menuId], [parentId], [name], [url], [perms], [type], [icon], [orderNum]) VALUES (86, 85, N'考勤统计', N'hr/checkAttendance.html', NULL, 1, N'fa fa-calendar', 86)
SET IDENTITY_INSERT [dbo].[CharlieOutsys_menu] OFF
/****** Object: Table [dbo].[CharlieOutsys_log] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_log]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_log](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[username] [nvarchar](50) NULL,
[operation] [nvarchar](50) NULL,
[method] [nvarchar](200) NULL,
[params] [ntext] NULL,
[ip] [nvarchar](64) NULL,
[createDate] [datetime2](7) NULL,
CONSTRAINT [PK_CharlieOutsys_log] 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] TEXTIMAGE_ON [PRIMARY]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_log] ON
INSERT [dbo].[CharlieOutsys_log] ([id], [username], [operation], [method], [params], [ip], [createDate]) VALUES (1098, N'admin', N'报价列表查询', N'com.cf.controller.ErpQuotationController.list()', N'{"cardName":"","quotationNo":""}', N'0:0:0:0:0:0:0:1', CAST(0x0770D6B93F7497430B AS DateTime2))
INSERT [dbo].[CharlieOutsys_log] ([id], [username], [operation], [method], [params], [ip], [createDate]) VALUES (1099, N'admin', N'报价列表查询', N'com.cf.controller.ErpQuotationController.list()', N'{"cardName":"","quotationNo":""}', N'0:0:0:0:0:0:0:1', CAST(0x07104E776A7497430B AS DateTime2))
SET IDENTITY_INSERT [dbo].[CharlieOutsys_log] OFF
/****** Object: Table [dbo].[CharlieOutsys_config] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutsys_config]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutsys_config](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[key] [nvarchar](50) NULL,
[value] [nvarchar](2000) NULL,
[status] [numeric](3, 0) NULL,
[remark] [nvarchar](500) NULL,
CONSTRAINT [PK_CharlieOutsys_config] 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]
END
GO
SET IDENTITY_INSERT [dbo].[CharlieOutsys_config] ON
INSERT [dbo].[CharlieOutsys_config] ([id], [key], [value], [status], [remark]) VALUES (1, N'CLOUD_STORAGE_CONFIG_KEY', N'{"aliyunAccessKeyId":"","aliyunAccessKeySecret":"","aliyunBucketName":"","aliyunDomain":"","aliyunEndPoint":"","aliyunPrefix":"","qcloudBucketName":"","qcloudDomain":"","qcloudPrefix":"","qcloudSecretId":"","qcloudSecretKey":"","qiniuAccessKey":"NrgMfABZxWLo5B-YYSjoE8-AZ1EISdi1Z3ubLOeZ","qiniuBucketName":"ios-app","qiniuDomain":"http://7xqbwh.dl1.z0.glb.clouddn.com","qiniuPrefix":"upload","qiniuSecretKey":"uIwJHevMRWU0VLxFvgy0tAcOdGqasdtVlJkdy6vV","type":1}', CAST(0 AS Numeric(3, 0)), N'云存储配置信息')
SET IDENTITY_INSERT [dbo].[CharlieOutsys_config] OFF
/****** Object: Table [dbo].[CharlieOutschedule_job_log] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutschedule_job_log]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutschedule_job_log](
[logId] [bigint] NOT NULL,
[jobId] [bigint] NOT NULL,
[beanName] [nvarchar](200) NULL,
[methodName] [nvarchar](100) NULL,
[params] [nvarchar](2000) NULL,
[status] [numeric](3, 0) NOT NULL,
[error] [nvarchar](2000) NULL,
[times] [int] NOT NULL,
[createTime] [datetime2](7) NULL
) ON [PRIMARY]
END
GO
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (721, 1, N'testTask', NULL, N'para', CAST(1 AS Numeric(3, 0)), N'java.lang.NullPointerException', 1, CAST(0x07901795419FE1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (722, 1, N'testTask', NULL, N'para', CAST(1 AS Numeric(3, 0)), N'java.lang.NullPointerException', 0, CAST(0x07904B7772A3E1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (1, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1032, CAST(0x0700E80A7E8E93410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (2, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1012, CAST(0x0790E9ED6F4B9F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (3, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1027, CAST(0x072022B6D1539F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (4, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1016, CAST(0x0780409902589F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (5, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1038, CAST(0x0730E55C64609F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (6, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1004, CAST(0x07209F3795649F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (7, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1009, CAST(0x07008519C6689F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (8, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1039, CAST(0x07205A03F76C9F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (9, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1003, CAST(0x07203BDE27719F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (10, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1006, CAST(0x0740BDC058759F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (11, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1005, CAST(0x07A06AA189799F410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (12, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1027, CAST(0x07D0A3AB8979A0410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (13, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1034, CAST(0x074051531C86A0410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (14, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1006, CAST(0x07B0612A4D8AA0410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (15, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1021, CAST(0x0740921CC668A1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (16, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1031, CAST(0x07308103F76CA1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (17, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1013, CAST(0x07208EE52771A1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (18, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1005, CAST(0x071048C05875A1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (19, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1058, CAST(0x07604D76EB81A1410B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job_log] ([logId], [jobId], [beanName], [methodName], [params], [status], [error], [times], [createTime]) VALUES (20, 1, N'testTask', N'test', N'para', CAST(0 AS Numeric(3, 0)), NULL, 1003, CAST(0x0700F1481C86A1410B AS DateTime2))
/****** Object: Table [dbo].[CharlieOutschedule_job] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieOutschedule_job]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieOutschedule_job](
[jobId] [bigint] NOT NULL,
[beanName] [nvarchar](200) NULL,
[method_name] [nvarchar](100) NULL,
[params] [nvarchar](2000) NULL,
[cronExpression] [nvarchar](100) NULL,
[status] [numeric](3, 0) NULL,
[remark] [nvarchar](255) NULL,
[createTime] [datetime2](7) NULL
) ON [PRIMARY]
END
GO
INSERT [dbo].[CharlieOutschedule_job] ([jobId], [beanName], [method_name], [params], [cronExpression], [status], [remark], [createTime]) VALUES (1, N'testTask', N'test', N'para', N'0 0/30 * * * ?', CAST(0 AS Numeric(3, 0)), N'有参数测试', CAST(0x0700C34420C3E03C0B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job] ([jobId], [beanName], [method_name], [params], [cronExpression], [status], [remark], [createTime]) VALUES (2, N'testTask', N'test2', NULL, N'0 0/30 * * * ?', CAST(1 AS Numeric(3, 0)), N'无参数测试', CAST(0x0700A612297DE23C0B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job] ([jobId], [beanName], [method_name], [params], [cronExpression], [status], [remark], [createTime]) VALUES (1, N'testTask', N'test', N'para', N'0 0/30 * * * ?', CAST(0 AS Numeric(3, 0)), N'有参数测试', CAST(0x0700C34420C3E03C0B AS DateTime2))
INSERT [dbo].[CharlieOutschedule_job] ([jobId], [beanName], [method_name], [params], [cronExpression], [status], [remark], [createTime]) VALUES (2, N'testTask', N'test2', NULL, N'0 0/30 * * * ?', CAST(1 AS Numeric(3, 0)), N'无参数测试', CAST(0x0700A612297DE23C0B AS DateTime2))
/****** Object: Table [dbo].[CharlieDepartment] Script Date: 02/14/2022 14:28:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CharlieDepartment]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CharlieDepartment](
[ID] [int] IDENTITY(1,1) NOT NULL,
[DeptName] [varchar](255) NOT NULL,
[Memo] [varchar](255) NULL,
[CreateTime] [datetime] NOT NULL,
[FID] [int] NULL,
[IsValid] [int] NOT NULL,
[SequenceNo] [int] NOT NULL,
[UserID] [uniqueidentifier] NULL,
CONSTRAINT [PK_CharlieDepartment] 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]
END
GO
SET ANSI_PADDING OFF
GO
SET IDENTITY_INSERT [dbo].[CharlieDepartment] ON
INSERT [dbo].[CharlieDepartment] ([ID], [DeptName], [Memo], [CreateTime], [FID], [IsValid], [SequenceNo], [UserID]) VALUES (1, N'部门', NULL, CAST(0x0000AB8A00AC51C7 AS DateTime), NULL, 1, 1, NULL)
SET IDENTITY_INSERT [dbo].[CharlieDepartment] OFF
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。