database/sql/AthenaNumber20180128.sql

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

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

USE [Athena]
GO
/****** Object:  Table [dbo].[workflownodeoperator]    Script Date: 01/28/2018 20:05:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[workflownodeoperator](
	[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[nodeactionid] [int] NOT NULL,
	[operatorid] [int] NOT NULL,
	[operatortype] [int] NOT NULL,
	[begintime] [datetime] NULL,
	[endtime] [datetime] NULL,
	[operatorstatus] [int] NULL,
	[operatorlock] [int] NULL,
	[nodeoperator] [nvarchar](256) NULL,
 CONSTRAINT [PK_workflownodeoperator] 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 IDENTITY_INSERT [dbo].[workflownodeoperator] ON
INSERT [dbo].[workflownodeoperator] ([id], [nodeactionid], [operatorid], [operatortype], [begintime], [endtime], [operatorstatus], [operatorlock], [nodeoperator]) VALUES (70, 47, 0, 1, NULL, NULL, 1, 1, N'28')
INSERT [dbo].[workflownodeoperator] ([id], [nodeactionid], [operatorid], [operatortype], [begintime], [endtime], [operatorstatus], [operatorlock], [nodeoperator]) VALUES (71, 48, 0, 1, NULL, NULL, 1, 1, N'26')
INSERT [dbo].[workflownodeoperator] ([id], [nodeactionid], [operatorid], [operatortype], [begintime], [endtime], [operatorstatus], [operatorlock], [nodeoperator]) VALUES (72, 49, 0, 1, NULL, NULL, 1, 1, N'41')
SET IDENTITY_INSERT [dbo].[workflownodeoperator] OFF
/****** Object:  Table [dbo].[workflownodeaction]    Script Date: 01/28/2018 20:05:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[workflownodeaction](
	[id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,
	[wfid] [int] NULL,
	[actionid] [int] NULL,
	[nodeactionname] [nvarchar](50) NULL,
	[nodeactionmemo] [nvarchar](256) NULL,
	[currentnodeid] [int] NOT NULL,
	[nextnodeid] [int] NOT NULL,
	[nastatus] [int] NULL,
	[begintime] [datetime] NULL,
	[endtime] [datetime] NULL,
	[nacondition] [nvarchar](1024) NULL,
	[nalock] [int] NULL,
	[nodeactioncode] [int] NULL,
	[nodetype] [int] NULL,
 CONSTRAINT [PK_wfstep_auth] 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 IDENTITY_INSERT [dbo].[workflownodeaction] ON
INSERT [dbo].[workflownodeaction] ([id], [wfid], [actionid], [nodeactionname], [nodeactionmemo], [currentnodeid], [nextnodeid], [nastatus], [begintime], [endtime], [nacondition], [nalock], [nodeactioncode], [nodetype]) VALUES (47, 40, 34, NULL, NULL, 137, 138, NULL, NULL, NULL, NULL, NULL, NULL, 1)
INSERT [dbo].[workflownodeaction] ([id], [wfid], [actionid], [nodeactionname], [nodeactionmemo], [currentnodeid], [nextnodeid], [nastatus], [begintime], [endtime], [nacondition], [nalock], [nodeactioncode], [nodetype]) VALUES (48, 40, 35, NULL, NULL, 138, 139, NULL, NULL, NULL, NULL, NULL, NULL, 1)
INSERT [dbo].[workflownodeaction] ([id], [wfid], [actionid], [nodeactionname], [nodeactionmemo], [currentnodeid], [nextnodeid], [nastatus], [begintime], [endtime], [nacondition], [nalock], [nodeactioncode], [nodetype]) VALUES (49, 40, 35, NULL, NULL, 139, 140, NULL, NULL, NULL, NULL, NULL, NULL, 1)
SET IDENTITY_INSERT [dbo].[workflownodeaction] OFF
/****** Object:  Table [dbo].[workflownode]    Script Date: 01/28/2018 20:05:33 ******/