CLIENT SUPPORT » HINO Bugs

??-- ================================================

-- Template generated from Template Explorer using:

-- Create Procedure (New Menu).SQL

--

-- Use the Specify Values for Template Parameters 

-- command (Ctrl-Shift-M) to fill in the parameter 

-- values below.

--

-- This block of comments will not be included in

-- the definition of the procedure.

-- ================================================

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

-- =============================================

-- Author:		<Author,,Name>

-- Create date: <Create Date,,>

-- Description:	<Description,,>

-- =============================================

CREATE PROCEDURE [WFCreateHISTable]

	-- Add the parameters for the stored procedure here	

AS

BEGIN

	-- SET NOCOUNT ON added to prevent extra result sets from

	-- interfering with SELECT statements.

	SET ANSI_NULLS ON

IF OBJECT_ID('[dbo].[PCMWFHISAPPR]', 'u') IS NOT NULL 

	DROP TABLE [dbo].[PCMWFHISAPPR]

CREATE TABLE [dbo].[PCMWFHISAPPR](

	[RegID] [bigint] NOT NULL,

	[Sequence] [int] NOT NULL,

	[EmployeeID] [varchar](18) NOT NULL,

	[Groups] [varchar](50) NULL,

	[Position] [varchar](50) NULL,

	[FlowType] [varchar](3) NULL,

	[CreateDate] [varchar](14) NULL,

 CONSTRAINT [PK_PCMWFHISAPPR] PRIMARY KEY CLUSTERED 

(

	[RegID] ASC,

	[Sequence] ASC,

	[EmployeeID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

IF OBJECT_ID('[dbo].[PCMWFHISATTACHMENT]', 'u') IS NOT NULL 

	DROP TABLE [dbo].[PCMWFHISATTACHMENT]

CREATE TABLE [dbo].[PCMWFHISATTACHMENT](

	[RegID] [bigint] NOT NULL,

	[Sequence] [int] NOT NULL,

	[FileSequence] [int] NOT NULL,

	[GuidID] [varchar](100) NULL,

	[Title] [varchar](150) NULL,

	[FileName] [varchar](200) NULL,

	[FileData] [varbinary](max) NULL,

	[FileType] [varchar](200) NULL,

	[IsPrivate] [varchar](1) NULL,

	[Size] [bigint] NULL,

	[Notes] [varchar](500) NULL,

	[CreateEmployeeID] [varchar](18) NULL,

	[CreateDate] [varchar](14) NULL,

 CONSTRAINT [PK_PCMWFHISATTACHMENT] PRIMARY KEY CLUSTERED 

(

	[RegID] ASC,

	[Sequence] ASC,

	[FileSequence] 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]

IF OBJECT_ID('[dbo].[PCMWFHISBIZDATA]', 'u') IS NOT NULL 

	DROP TABLE [dbo].[PCMWFHISBIZDATA]

CREATE TABLE [dbo].[PCMWFHISBIZDATA](

	[RegID] [bigint] NOT NULL,

	[Sequence] [int] NOT NULL,

	[BizProcessID] [varchar](50) NOT NULL,

	[TableReference] [varchar](30) NULL,

	[FieldID] [varchar](50) NOT NULL,

	[DataSequence] [int] NOT NULL,

	[Value] [varchar](500) NULL,

 CONSTRAINT [PK_PCMWFHISBIZDATA] PRIMARY KEY CLUSTERED 

(

	[RegID] ASC,

	[Sequence] ASC,

	[BizProcessID] ASC,

	[FieldID] ASC,

	[DataSequence] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

IF OBJECT_ID('[dbo].[PCMWFHISCOMMENT]', 'u') IS NOT NULL 

	DROP TABLE [dbo].[PCMWFHISCOMMENT]

CREATE TABLE [dbo].[PCMWFHISCOMMENT](

	[RegID] [bigint] NOT NULL,

	[Sequence] [int] NOT NULL,

	[CommentID] [bigint] NOT NULL,

	[Text] [varchar](500) NOT NULL,

	[CreateAt] [varchar](14) NOT NULL,

	[ChangeAt] [varchar](14) NULL,

	[EmployeeIDApprover] [varchar](8) NULL,

	[MessageIsPrivate] [bigint] NULL,

 CONSTRAINT [PK_PCMWFHISCOMMENT] PRIMARY KEY CLUSTERED 

(

	[RegID] ASC,

	[Sequence] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

IF OBJECT_ID('[dbo].[PCMWFHISINBOXLOCK]', 'u') IS NOT NULL

	DROP TABLE [dbo].[PCMWFHISINBOXLOCK]

CREATE TABLE [dbo].[PCMWFHISINBOXLOCK](