Resource/DB/MicroOA-Initial-database.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

--1.初始数据库导入，打开MS SQL Server 2008 R2控制面板，新建空白数据库
--2.在新建的数据库下，新建查询，把如下所有sql命令复制进去，执行命令

/****** Object:  Table [dbo].[WorkFlow]    Script Date: 01/07/2022 13:56:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[WorkFlow](
	[WFID] [int] IDENTITY(1,1) NOT NULL,
	[Sort] [int] NULL,
	[SaveDraft] [bit] NULL,
	[DateCreated] [datetime] NULL,
	[DateModified] [datetime] NULL,
	[FormID] [int] NULL,
	[ParentID] [int] NULL,
	[FlowName] [nvarchar](100) NULL,
	[FlowCode] [varchar](50) NULL,
	[Alias] [nvarchar](100) NULL,
	[EffectiveType] [varchar](100) NULL,
	[EffectiveIDStr] [varchar](4000) NULL,
	[IsConditionApproval] [bit] NULL,
	[OperField] [varchar](100) NULL,
	[Condition] [varchar](10) NULL,
	[OperValue] [varchar](100) NULL,
	[CustomConditions] [varchar](200) NULL,
	[ApprovalType] [varchar](100) NULL,
	[ApprovalIDStr] [varchar](200) NULL,
	[ApprovalByIDStr] [varchar](200) NULL,
	[IsSync] [bit] NULL,
	[Creator] [nvarchar](50) NULL,
	[DefaultFlow] [bit] NULL,
	[FixedNode] [bit] NULL,
	[Invalid] [bit] NULL,
	[Del] [bit] NULL,
	[IsAccept] [bit] NULL,
	[ApproversSelectedByDefault] [bit] NULL,
	[ExtraFunction] [varchar](500) NULL,
	[IsOptionalApproval] [bit] NULL,
	[IsSpecialApproval] [bit] NULL,
	[IsVerticalDirection] [bit] NULL,
	[Description] [nvarchar](4000) NULL,
	[FindRange] [bit] NULL,
	[FindGMOffice] [bit] NULL,
	[ApprovalIDStrSort] [bit] NULL,
	[ApprovalByIDStrSort] [bit] NULL,
 CONSTRAINT [PK__WorkFlow__FFE34A187C4F7684] PRIMARY KEY CLUSTERED 
(
	[WFID] 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
SET IDENTITY_INSERT [dbo].[WorkFlow] ON
INSERT [dbo].[WorkFlow] ([WFID], [Sort], [SaveDraft], [DateCreated], [DateModified], [FormID], [ParentID], [FlowName], [FlowCode], [Alias], [EffectiveType], [EffectiveIDStr], [IsConditionApproval], [OperField], [Condition], [OperValue], [CustomConditions], [ApprovalType], [ApprovalIDStr], [ApprovalByIDStr], [IsSync], [Creator], [DefaultFlow], [FixedNode], [Invalid], [Del], [IsAccept], [ApproversSelectedByDefault], [ExtraFunction], [IsOptionalApproval], [IsSpecialApproval], [IsVerticalDirection], [Description], [FindRange], [FindGMOffice], [ApprovalIDStrSort], [ApprovalByIDStrSort]) VALUES (1, 1, 0, CAST(0x0000AC1800CEE2A8 AS DateTime), CAST(0x0000AC1800CEE2A8 AS DateTime), 0, 0, N'NonApproval', N'', NULL, N'Dept', N'', 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, N'Admin (管理员)', 1, 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WorkFlow] ([WFID], [Sort], [SaveDraft], [DateCreated], [DateModified], [FormID], [ParentID], [FlowName], [FlowCode], [Alias], [EffectiveType], [EffectiveIDStr], [IsConditionApproval], [OperField], [Condition], [OperValue], [CustomConditions], [ApprovalType], [ApprovalIDStr], [ApprovalByIDStr], [IsSync], [Creator], [DefaultFlow], [FixedNode], [Invalid], [Del], [IsAccept], [ApproversSelectedByDefault], [ExtraFunction], [IsOptionalApproval], [IsSpecialApproval], [IsVerticalDirection], [Description], [FindRange], [FindGMOffice], [ApprovalIDStrSort], [ApprovalByIDStrSort]) VALUES (2, 0, 0, CAST(0x0000AC1800CEE2B9 AS DateTime), CAST(0x0000AC1800CEE2B9 AS DateTime), 0, 1, N'申请', N'Apply', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, N'', N'', N'', 0, N'Admin (管理员)', 0, 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
INSERT [dbo].[WorkFlow] ([WFID], [Sort], [SaveDraft], [DateCreated], [DateModified], [FormID], [ParentID], [FlowName], [FlowCode], [Alias], [EffectiveType], [EffectiveIDStr], [IsConditionApproval], [OperField], [Condition], [OperValue], [CustomConditions], [ApprovalType], [ApprovalIDStr], [ApprovalByIDStr], [IsSync], [Creator], [DefaultFlow], [FixedNode], [Invalid], [Del], [IsAccept], [ApproversSelectedByDefault], [ExtraFunction], [IsOptionalApproval], [IsSpecialApproval], [IsVerticalDirection], [Description], [FindRange], [FindGMOffice], [ApprovalIDStrSort], [ApprovalByIDStrSort]) VALUES (3, 888887, 0, CAST(0x0000AC1800CEE2B9 AS DateTime), CAST(0x0000AC1800CEE2B9 AS DateTime), 0, 1, N'受理', N'Accept', NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, N'', N'', N'', 0, N'Admin (管理员)', 0, 1, 0, 0, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)