CREATE TABLE [dbo].[RealData](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[tagname] [varchar](50) NOT NULL,
	[tagvalue] [varchar](50) NOT NULL,
	[tagtype] [varchar](50) NOT NULL,
	[digcount] [int] NOT NULL,
	[unit] [varchar](50) NOT NULL,
	[description] [varchar](250) NOT NULL,
	[time] [datetime] NOT NULL,
	[rangemax] [float] NOT NULL,
	[rangemin] [float] NOT NULL,
	[status] [int] NOT NULL,
 CONSTRAINT [PK_RealTable] 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

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_tagname]  DEFAULT ('') FOR [tagname]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_tagvalue]  DEFAULT ((0)) FOR [tagvalue]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_tagtype]  DEFAULT ('Single') FOR [tagtype]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_digcount]  DEFAULT ((0)) FOR [digcount]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_unit]  DEFAULT ('') FOR [unit]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_description]  DEFAULT ('') FOR [description]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_time]  DEFAULT (getdate()) FOR [time]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_rangemax]  DEFAULT ((100)) FOR [rangemax]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_rangemin]  DEFAULT ((0)) FOR [rangemin]
GO

ALTER TABLE [dbo].[RealData] ADD  CONSTRAINT [DF_RealTable_status]  DEFAULT ((0)) FOR [status]
GO