/****** Object:  Table [dbo].[HistDict]    Script Date: 12/09/2015 15:30:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HistDict](
	[TAGNAME] [char](48) NULL,
	[TABLENAME] [char](40) NULL,
	[LOGFMT] [int] NULL,
	[VALUECOL] [char](40) NULL,
	[NAMECOL] [char](64) NULL,
	[SEQCOL] [char](64) NULL,
	[TIMECOL] [char](64) NULL,
	[QUALITYCOL] [char](64) NULL,
	[CREATETIME] [datetime] NULL
) ON [PRIMARY]

GO

/****** Object:  Index [HistDict_INDEX1]    Script Date: 12/09/2015 15:30:24 ******/
CREATE NONCLUSTERED INDEX [HistDict_INDEX1] ON [dbo].[HistDict] 
(
	[TAGNAME] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO

/****** Object:  Index [HistDict_INDEX2]    Script Date: 12/09/2015 15:30:24 ******/
CREATE UNIQUE NONCLUSTERED INDEX [HistDict_INDEX2] ON [dbo].[HistDict] 
(
	[TAGNAME] ASC,
	[TABLENAME] ASC,
	[LOGFMT] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
GO