USE [Scada] GO /****** Object: Table [dbo].[RTable] Script Date: 2019-06-01 20:55:05 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[RTable]( [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, [hist] [int] NOT NULL, [storedead] [float] NOT NULL, [storetime] [int] NOT NULL, [area] [int] NOT NULL, [alarm] [int] NOT NULL, [alarm_lo] [float] NOT NULL, [alarm_lolo] [float] NOT NULL, [alarm_hi] [float] NOT NULL, [alarm_hihi] [float] NOT NULL, [alarm_dead] [float] NOT NULL, CONSTRAINT [PK_RTable] 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].[RTable] ADD CONSTRAINT [DF_RTable_tagname] DEFAULT ('') FOR [tagname] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_tagvalue] DEFAULT ((0)) FOR [tagvalue] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_tagtype] DEFAULT ('Single') FOR [tagtype] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_digcount] DEFAULT ((0)) FOR [digcount] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_unit] DEFAULT ('') FOR [unit] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_description] DEFAULT ('') FOR [description] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_time] DEFAULT (getdate()) FOR [time] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_rangemax] DEFAULT ((100)) FOR [rangemax] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_rangemin] DEFAULT ((0)) FOR [rangemin] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_status] DEFAULT ((0)) FOR [status] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_hist] DEFAULT ((0)) FOR [hist] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_storedead] DEFAULT ((0.001)) FOR [storedead] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_Table_storetime] DEFAULT ((300)) FOR [storetime] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_area] DEFAULT ((0)) FOR [area] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm] DEFAULT ((0)) FOR [alarm] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm_lo] DEFAULT ((-10)) FOR [alarm_lo] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm_lolo] DEFAULT ((-20)) FOR [alarm_lolo] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm_hi] DEFAULT ((80)) FOR [alarm_hi] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm_hihi] DEFAULT ((100)) FOR [alarm_hihi] GO ALTER TABLE [dbo].[RTable] ADD CONSTRAINT [DF_RTable_alarm_dead] DEFAULT ((0)) FOR [alarm_dead] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'历史归档标志' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTable', @level2type=N'COLUMN',@level2name=N'hist' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'历史归档死区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTable', @level2type=N'COLUMN',@level2name=N'storedead' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'历史归档例外时间(秒)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTable', @level2type=N'COLUMN',@level2name=N'storetime' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'报警类型0不报警' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'RTable', @level2type=N'COLUMN',@level2name=N'alarm' GO