GO
CREATE TABLE [dbo].[ZL_MisProcedure](
[ID] [int] IDENTITY(1,1) NOT NULL,
[ProcedureName] [nvarchar](50) NOT NULL,
[TypeID] [int] NULL,
[ClassID] [int] NULL,
[ModelID] [varchar](50) NULL,
[CommType] [int] NULL,
[AllowAttach] [int] NULL,
[AllowFlow] [int] NULL,
[Remind] [nvarchar](200) NULL,
[Status] [int] NULL,
[Sponsor] [nvarchar](300) NULL,
[NodeID] [int] NULL,
[SponsorGroup] [nvarchar](300) NULL,
[Manager] [text] NULL,
[FormType] [int] NULL,
[FormInfo] [ntext] NULL,
[CanEditField] [varchar](3000) NULL,
[DocAuth] [varchar](500) NULL,
[FlowTlp] [nvarchar](300) NULL,
[PrintTlp] [nvarchar](300) NULL,
[FirstStep] [ntext] NULL,
CONSTRAINT [PK_ZL_MisProcedure] PRIMARY KEY NONCLUSTERED
([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]

SET IDENTITY_INSERT [ZL_MisProcedure] ON
INSERT [ZL_MisProcedure] ([ID],[ProcedureName],[TypeID],[ClassID],[CommType],[AllowAttach],[AllowFlow],[Status],[NodeID],[SponsorGroup],[FormType],[FormInfo],[CanEditField],[FlowTlp],[PrintTlp],[FirstStep]) VALUES ( 1,N'收文流程',2,1,0,1,1,0,0,N'收文',0,N'35',N'*',N'rece',N'receprint',N'{"ID":0,"ProID":0,"OrginStepID":0,"stepNum":1,"stepName":null,"ReferUser":"","ReferGroup":"","CCUser":"","CCGroup":"","HelpUser":"","HQoption":0,"Qzzjoption":0,"HToption":0,"EmailAlert":"","EmailGroup":"","SmsAlert":"","SmsGroup":"","BackOption":0,"PublicAttachOption":1,"PrivateAttachOption":1,"Status":1,"CreateTime":"2016-12-28T10:42:17.601505+08:00","Remind":null,"SendMan":",,","CanEditField":"*","DocAuth":null,"NextOP":null,"ReferUser_Alias":"主办人","CCUser_Alias":"协办人","HelpUser_Alias":"辅办人","CCUser_Allow":1,"HelpUser_Allow":0,"StepAuth":{"RUser_ManageAttach":false,"RUser_ChangeUser":false,"CCUser_Write":true,"CCUser_HQ":false,"HUser_Write":true},"ParentID":0,"TbName":"ZL_MisProLevel","UP_Tables":"ZL_MisProLevel,ZL_OA_FreePro","PK":"ID"}')
INSERT [ZL_MisProcedure] ([ID],[ProcedureName],[TypeID],[ClassID],[CommType],[AllowAttach],[AllowFlow],[Status],[NodeID],[SponsorGroup],[FormType],[FormInfo],[CanEditField],[FlowTlp],[PrintTlp],[FirstStep]) VALUES ( 2,N'发文流程',2,1,0,1,1,0,0,N'发文',0,N'36',N'*',N'send',N'sendprint',N'{"ID":0,"ProID":0,"OrginStepID":0,"stepNum":1,"stepName":null,"ReferUser":"","ReferGroup":"","CCUser":"","CCGroup":"","HelpUser":"","HQoption":0,"Qzzjoption":0,"HToption":0,"EmailAlert":"","EmailGroup":"","SmsAlert":"","SmsGroup":"","BackOption":0,"PublicAttachOption":1,"PrivateAttachOption":1,"Status":1,"CreateTime":"2016-12-28T10:42:32.3153464+08:00","Remind":null,"SendMan":",,","CanEditField":"*","DocAuth":null,"NextOP":null,"ReferUser_Alias":"主办人","CCUser_Alias":"协办人","HelpUser_Alias":"辅办人","CCUser_Allow":1,"HelpUser_Allow":0,"StepAuth":{"RUser_ManageAttach":false,"RUser_ChangeUser":false,"CCUser_Write":true,"CCUser_HQ":false,"HUser_Write":true},"ParentID":0,"TbName":"ZL_MisProLevel","UP_Tables":"ZL_MisProLevel,ZL_OA_FreePro","PK":"ID"}')
INSERT [ZL_MisProcedure] ([ID],[ProcedureName],[TypeID],[ClassID],[CommType],[AllowAttach],[AllowFlow],[Status],[NodeID],[SponsorGroup],[FormType],[FormInfo],[CanEditField],[FlowTlp],[PrintTlp],[FirstStep]) VALUES ( 3,N'请假申请',1,1,0,1,1,0,0,N'请假',0,N'37',N'*',N'defTlp',N'defTlp',N'{"ID":0,"ProID":0,"OrginStepID":0,"stepNum":1,"stepName":null,"ReferUser":"","ReferGroup":"","CCUser":"","CCGroup":"","HelpUser":"","HQoption":0,"Qzzjoption":0,"HToption":0,"EmailAlert":"","EmailGroup":"","SmsAlert":"","SmsGroup":"","BackOption":0,"PublicAttachOption":1,"PrivateAttachOption":1,"Status":1,"CreateTime":"2016-12-28T10:42:36.7996031+08:00","Remind":null,"SendMan":",,","CanEditField":"*","DocAuth":null,"NextOP":null,"ReferUser_Alias":"主办人","CCUser_Alias":"协办人","HelpUser_Alias":"辅办人","CCUser_Allow":1,"HelpUser_Allow":0,"StepAuth":{"RUser_ManageAttach":false,"RUser_ChangeUser":false,"CCUser_Write":true,"CCUser_HQ":false,"HUser_Write":true},"ParentID":0,"TbName":"ZL_MisProLevel","UP_Tables":"ZL_MisProLevel,ZL_OA_FreePro","PK":"ID"}')
INSERT [ZL_MisProcedure] ([ID],[ProcedureName],[TypeID],[ClassID],[CommType],[AllowAttach],[AllowFlow],[Status],[NodeID],[SponsorGroup],[FormType],[FormInfo],[CanEditField],[FlowTlp],[PrintTlp],[FirstStep]) VALUES ( 4,N'会议流程',2,1,0,0,1,0,0,N'会议',0,N'38',N'*',N'defTlp',N'defTlp',N'{"ID":0,"ProID":0,"OrginStepID":0,"stepNum":1,"stepName":null,"ReferUser":"","ReferGroup":"","CCUser":"","CCGroup":"","HelpUser":"","HQoption":0,"Qzzjoption":0,"HToption":0,"EmailAlert":"","EmailGroup":"","SmsAlert":"","SmsGroup":"","BackOption":0,"PublicAttachOption":1,"PrivateAttachOption":1,"Status":1,"CreateTime":"2016-12-28T10:42:40.4458087+08:00","Remind":null,"SendMan":",,","CanEditField":"*","DocAuth":null,"NextOP":null,"ReferUser_Alias":"主办人","CCUser_Alias":"协办人","HelpUser_Alias":"辅办人","CCUser_Allow":1,"HelpUser_Allow":0,"StepAuth":{"RUser_ManageAttach":false,"RUser_ChangeUser":false,"CCUser_Write":true,"CCUser_HQ":false,"HUser_Write":true},"ParentID":0,"TbName":"ZL_MisProLevel","UP_Tables":"ZL_MisProLevel,ZL_OA_FreePro","PK":"ID"}')
SET IDENTITY_INSERT [ZL_MisProcedure] OFF