USE [openMIC] GO /****** Object: Table [dbo].[AccessLog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AccessLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](200) NOT NULL, [AccessGranted] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, CONSTRAINT [PK_AccessLog] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Alarm] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[Alarm]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [TagName] [varchar](200) NOT NULL, [SignalID] [uniqueidentifier] NOT NULL, [AssociatedMeasurementID] [uniqueidentifier] NULL, [Description] [varchar](max) NULL, [Severity] [int] NOT NULL, [Operation] [int] NOT NULL, [SetPoint] [float] NULL, [Tolerance] [float] NULL, [Delay] [float] NULL, [Hysteresis] [float] NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_Alarm] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[AlarmLog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[AlarmLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [SignalID] [uniqueidentifier] NOT NULL, [PreviousState] [int] NULL, [NewState] [int] NULL, [Ticks] [bigint] NOT NULL, [Timestamp] [datetime2](7) NOT NULL, [Value] [float] NOT NULL, CONSTRAINT [PK_AlarmLog] 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] GO /****** Object: Table [dbo].[ApplicationRole] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ApplicationRole]( [ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_ApplicationRole_ID] DEFAULT (newid()), [Name] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [NodeID] [uniqueidentifier] NOT NULL, [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_ApplicationRole_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_ApplicationRole_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_ApplicationRole_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_ApplicationRole_UpdatedBy] DEFAULT (getutcdate()), CONSTRAINT [PK_ApplicationRole] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ApplicationRoleSecurityGroup] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ApplicationRoleSecurityGroup]( [ApplicationRoleID] [uniqueidentifier] NOT NULL, [SecurityGroupID] [uniqueidentifier] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[ApplicationRoleUserAccount] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[ApplicationRoleUserAccount]( [ApplicationRoleID] [uniqueidentifier] NOT NULL, [UserAccountID] [uniqueidentifier] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[AuditLog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[AuditLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [TableName] [varchar](200) NOT NULL, [PrimaryKeyColumn] [varchar](200) NOT NULL, [PrimaryKeyValue] [varchar](max) NOT NULL, [ColumnName] [varchar](200) NOT NULL, [OriginalValue] [varchar](max) NULL, [NewValue] [varchar](max) NULL, [Deleted] [bit] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, CONSTRAINT [PK_AuditLog] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[CalculatedMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CalculatedMeasurement]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [ConnectionString] [varchar](max) NULL, [ConfigSection] [varchar](200) NULL, [InputMeasurements] [varchar](max) NULL, [OutputMeasurements] [varchar](max) NULL, [MinimumMeasurementsToUse] [int] NOT NULL, [FramesPerSecond] [int] NOT NULL, [LagTime] [float] NOT NULL, [LeadTime] [float] NOT NULL, [UseLocalClockAsRealTime] [bit] NOT NULL, [AllowSortsByArrival] [bit] NOT NULL, [IgnoreBadTimeStamps] [bit] NOT NULL, [TimeResolution] [int] NOT NULL, [AllowPreemptivePublishing] [bit] NOT NULL, [PerformTimeReasonabilityCheck] [bit] NOT NULL, [DownsamplingMethod] [varchar](15) NOT NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_CalculatedMeasurement] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Company] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Company]( [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [MapAcronym] [nchar](10) NOT NULL, [Name] [varchar](200) NOT NULL, [URL] [varchar](max) NULL, [LoadOrder] [int] NOT NULL CONSTRAINT [DF_Company_LoadOrder] DEFAULT ((0)), [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_Company_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Company_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_Company_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Company_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_Company] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ConfigurationEntity] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ConfigurationEntity]( [SourceName] [varchar](200) NOT NULL, [RuntimeName] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [LoadOrder] [int] NOT NULL CONSTRAINT [DF_ConfigurationEntity_LoadOrder] DEFAULT ((0)), [Enabled] [bit] NOT NULL CONSTRAINT [DF_ConfigurationEntity_Enabled] DEFAULT ((0)) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ConnectionProfile] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[ConnectionProfile]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NOT NULL, [DefaultTaskQueueID] [int] NULL, [Description] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_ConnectionProfile] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ConnectionProfileTask] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[ConnectionProfileTask]( [ID] [int] IDENTITY(1,1) NOT NULL, [ConnectionProfileID] [int] NOT NULL, [Name] [varchar](200) NOT NULL, [Settings] [varchar](max) NULL, [LoadOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_ConnectionProfileTask] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ConnectionProfileTaskQueue] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[ConnectionProfileTaskQueue]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NOT NULL, [MaxThreadCount] [int] NOT NULL, [UseBackgroundThreads] [bit] NOT NULL, [Description] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_ConnectionProfileTaskQueue] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[CustomActionAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CustomActionAdapter]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [AdapterName] [varchar](200) NOT NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [ConnectionString] [varchar](max) NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_CustomActionAdapter] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[CustomInputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[CustomInputAdapter]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [AdapterName] [varchar](200) NOT NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [ConnectionString] [varchar](max) NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_CustomInputAdapter] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[CustomOutputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[CustomOutputAdapter]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [AdapterName] [varchar](200) NOT NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [ConnectionString] [varchar](max) NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_CustomOutputAdapter] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[DataOperation] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[DataOperation]( [NodeID] [uniqueidentifier] NULL, [Description] [varchar](max) NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [MethodName] [varchar](200) NOT NULL, [Arguments] [varchar](max) NULL, [LoadOrder] [int] NOT NULL CONSTRAINT [DF_DataOperation_LoadOrder] DEFAULT ((0)), [Enabled] [bit] NOT NULL CONSTRAINT [DF_DataOperation_Enabled] DEFAULT ((0)) ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Device] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Device]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [ParentID] [int] NULL, [UniqueID] [uniqueidentifier] NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [OriginalSource] [varchar](200) NULL, [IsConcentrator] [bit] NOT NULL, [CompanyID] [int] NULL, [HistorianID] [int] NULL, [AccessID] [int] NOT NULL, [VendorDeviceID] [int] NULL, [ProtocolID] [int] NULL, [Longitude] [decimal](9, 6) NULL, [Latitude] [decimal](9, 6) NULL, [InterconnectionID] [int] NULL, [ConnectionString] [varchar](max) NULL, [TimeZone] [varchar](200) NULL, [FramesPerSecond] [int] NULL, [TimeAdjustmentTicks] [bigint] NOT NULL, [DataLossInterval] [float] NOT NULL, [AllowedParsingExceptions] [int] NOT NULL, [ParsingExceptionWindow] [float] NOT NULL, [DelayedConnectionInterval] [float] NOT NULL, [AllowUseOfCachedConfiguration] [bit] NOT NULL, [AutoStartDataParsingSequence] [bit] NOT NULL, [SkipDisableRealTimeData] [bit] NOT NULL, [MeasurementReportingInterval] [int] NOT NULL, [ConnectOnDemand] [bit] NOT NULL, [ContactList] [nvarchar](max) NULL, [MeasuredLines] [int] NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](50) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](50) NOT NULL, CONSTRAINT [PK_Device] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[DownloadedFile] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DownloadedFile]( [ID] [int] IDENTITY(1,1) NOT NULL, [DeviceID] [int] NOT NULL, [FilePath] [nvarchar](200) NOT NULL, [Timestamp] [datetime2](7) NOT NULL, [CreationTime] [datetime] NOT NULL, [LastWriteTime] [datetime] NOT NULL, [LastAccessTime] [datetime] NOT NULL, [FileSize] [int] NOT NULL, CONSTRAINT [PK_DownloadedFile] 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 /****** Object: Table [dbo].[ErrorLog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ErrorLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [Source] [varchar](200) NOT NULL, [Type] [varchar](max) NULL, [Message] [varchar](max) NOT NULL, [Detail] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL, CONSTRAINT [PK_ErrorLog] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Historian] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Historian]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [AssemblyName] [varchar](max) NULL, [TypeName] [varchar](max) NULL, [ConnectionString] [varchar](max) NULL, [IsLocal] [bit] NOT NULL CONSTRAINT [DF_Historian_IsLocal] DEFAULT ((1)), [MeasurementReportingInterval] [int] NOT NULL CONSTRAINT [DF_Historian_MeasurementReportingInterval] DEFAULT ((100000)), [Description] [varchar](max) NULL, [LoadOrder] [int] NOT NULL CONSTRAINT [DF_Historian_LoadOrder] DEFAULT ((0)), [Enabled] [bit] NOT NULL CONSTRAINT [DF_Historian_Enabled] DEFAULT ((0)), [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_Historian_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Historian_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_Historian_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Historian_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_Historian] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[ImportedMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[ImportedMeasurement]( [NodeID] [uniqueidentifier] NULL, [SourceNodeID] [uniqueidentifier] NULL, [SignalID] [uniqueidentifier] NULL, [Source] [varchar](200) NOT NULL, [PointID] [int] NOT NULL, [PointTag] [varchar](200) NOT NULL, [AlternateTag] [varchar](200) NULL, [SignalTypeAcronym] [varchar](4) NULL, [SignalReference] [varchar](200) NOT NULL, [FramesPerSecond] [int] NULL, [ProtocolAcronym] [varchar](200) NULL, [ProtocolType] [varchar](200) NOT NULL, [PhasorID] [int] NULL, [PhasorType] [nchar](1) NULL, [Phase] [nchar](1) NULL, [Adder] [float] NOT NULL, [Multiplier] [float] NOT NULL, [CompanyAcronym] [varchar](200) NULL, [Longitude] [decimal](9, 6) NULL, [Latitude] [decimal](9, 6) NULL, [Description] [varchar](max) NULL, [Enabled] [bit] NOT NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Interconnection] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Interconnection]( [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](50) NOT NULL, [Name] [varchar](100) NOT NULL, [LoadOrder] [int] NULL CONSTRAINT [DF_Interconnection_LoadOrder] DEFAULT ((0)), CONSTRAINT [PK_Interconnection] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Measurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Measurement]( [PointID] [int] IDENTITY(1,1) NOT NULL, [SignalID] [uniqueidentifier] NOT NULL, [HistorianID] [int] NULL, [DeviceID] [int] NULL, [PointTag] [varchar](200) NOT NULL, [AlternateTag] [varchar](max) NULL, [SignalTypeID] [int] NOT NULL, [PhasorSourceIndex] [int] NULL, [SignalReference] [varchar](200) NOT NULL, [Adder] [float] NOT NULL, [Multiplier] [float] NOT NULL, [Description] [varchar](max) NULL, [Internal] [bit] NOT NULL, [Subscribed] [bit] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_Measurement] PRIMARY KEY CLUSTERED ( [SignalID] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[MeasurementGroup] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[MeasurementGroup]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [FilterExpression] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_MeasurementGroup_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_MeasurementGroup_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_MeasurementGroup_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_MeasurementGroup_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_MeasurementGroup] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[MeasurementGroupMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[MeasurementGroupMeasurement]( [NodeID] [uniqueidentifier] NOT NULL, [MeasurementGroupID] [int] NOT NULL, [SignalID] [uniqueidentifier] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_MeasurementGroupMeasurement] PRIMARY KEY CLUSTERED ( [NodeID] ASC, [MeasurementGroupID] ASC, [SignalID] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Node] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Node]( [ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_Node_ID] DEFAULT (newid()), [Name] [varchar](200) NOT NULL, [CompanyID] [int] NULL, [Longitude] [decimal](9, 6) NULL, [Latitude] [decimal](9, 6) NULL, [Description] [varchar](max) NULL, [ImagePath] [varchar](max) NULL, [Settings] [varchar](max) NULL, [MenuType] [varchar](200) NOT NULL CONSTRAINT [DF_Node_MenuType] DEFAULT (N'File'), [MenuData] [varchar](max) NOT NULL CONSTRAINT [DF_Node_MenuData] DEFAULT (N'Menu.xml'), [Master] [bit] NOT NULL CONSTRAINT [DF_Node_Master] DEFAULT ((0)), [LoadOrder] [int] NOT NULL CONSTRAINT [DF_Node_LoadOrder] DEFAULT ((0)), [Enabled] [bit] NOT NULL CONSTRAINT [DF_Node_Enabled] DEFAULT ((0)), [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_Node_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Node_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_Node_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Node_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_Node] 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] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OtherDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OtherDevice]( [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [IsConcentrator] [bit] NOT NULL, [CompanyID] [int] NULL, [VendorDeviceID] [int] NULL, [Longitude] [decimal](9, 6) NULL, [Latitude] [decimal](9, 6) NULL, [InterconnectionID] [int] NULL, [Planned] [bit] NOT NULL, [Desired] [bit] NOT NULL, [InProgress] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OtherDevice] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStream] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStream]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [Type] [int] NOT NULL, [ConnectionString] [varchar](max) NULL, [DataChannel] [varchar](max) NULL, [CommandChannel] [varchar](max) NULL, [IDCode] [int] NOT NULL, [AutoPublishConfigFrame] [bit] NOT NULL, [AutoStartDataChannel] [bit] NOT NULL, [NominalFrequency] [int] NOT NULL, [FramesPerSecond] [int] NOT NULL, [LagTime] [float] NOT NULL, [LeadTime] [float] NOT NULL, [UseLocalClockAsRealTime] [bit] NOT NULL, [AllowSortsByArrival] [bit] NOT NULL, [IgnoreBadTimeStamps] [bit] NOT NULL, [TimeResolution] [int] NOT NULL, [AllowPreemptivePublishing] [bit] NOT NULL, [PerformTimeReasonabilityCheck] [bit] NOT NULL, [DownsamplingMethod] [varchar](15) NOT NULL, [DataFormat] [varchar](15) NOT NULL, [CoordinateFormat] [varchar](15) NOT NULL, [CurrentScalingValue] [int] NOT NULL, [VoltageScalingValue] [int] NOT NULL, [AnalogScalingValue] [int] NOT NULL, [DigitalMaskValue] [int] NOT NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStream] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStreamDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStreamDevice]( [NodeID] [uniqueidentifier] NOT NULL, [AdapterID] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [IDCode] [int] NOT NULL, [Acronym] [varchar](200) NOT NULL, [BpaAcronym] [varchar](4) NULL, [Name] [varchar](200) NOT NULL, [PhasorDataFormat] [varchar](15) NULL, [FrequencyDataFormat] [varchar](15) NULL, [AnalogDataFormat] [varchar](15) NULL, [CoordinateFormat] [varchar](15) NULL, [LoadOrder] [int] NOT NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStreamDevice] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStreamDeviceAnalog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStreamDeviceAnalog]( [NodeID] [uniqueidentifier] NOT NULL, [OutputStreamDeviceID] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Label] [varchar](16) NOT NULL, [Type] [int] NOT NULL, [ScalingValue] [int] NOT NULL, [LoadOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStreamDeviceAnalog] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStreamDeviceDigital] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStreamDeviceDigital]( [NodeID] [uniqueidentifier] NOT NULL, [OutputStreamDeviceID] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Label] [varchar](max) NOT NULL, [MaskValue] [int] NOT NULL, [LoadOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStreamDeviceDigital] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStreamDevicePhasor] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStreamDevicePhasor]( [NodeID] [uniqueidentifier] NOT NULL, [OutputStreamDeviceID] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [Label] [varchar](200) NOT NULL, [Type] [nchar](1) NOT NULL, [Phase] [nchar](1) NOT NULL, [ScalingValue] [int] NOT NULL, [LoadOrder] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStreamDevicePhasor] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[OutputStreamMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[OutputStreamMeasurement]( [NodeID] [uniqueidentifier] NOT NULL, [AdapterID] [int] NOT NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [HistorianID] [int] NULL, [PointID] [int] NOT NULL, [SignalReference] [varchar](200) NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_OutputStreamMeasurement] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Phasor] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Phasor]( [ID] [int] IDENTITY(1,1) NOT NULL, [DeviceID] [int] NOT NULL, [Label] [varchar](200) NOT NULL, [Type] [nchar](1) NOT NULL, [Phase] [nchar](1) NOT NULL, [DestinationPhasorID] [int] NULL, [SourceIndex] [int] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_Phasor] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[PowerCalculation] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING OFF GO CREATE TABLE [dbo].[PowerCalculation]( [NodeID] [uniqueidentifier] NULL, [ID] [int] IDENTITY(1,1) NOT NULL, [CircuitDescription] [varchar](max) NULL, [VoltageAngleSignalID] [uniqueidentifier] NOT NULL, [VoltageMagSignalID] [uniqueidentifier] NOT NULL, [CurrentAngleSignalID] [uniqueidentifier] NOT NULL, [CurrentMagSignalID] [uniqueidentifier] NOT NULL, [ActivePowerOutputSignalID] [uniqueidentifier] NULL, [ReactivePowerOutputSignalID] [uniqueidentifier] NULL, [ApparentPowerOutputSignalID] [uniqueidentifier] NULL, [Enabled] [bit] NOT NULL, CONSTRAINT [PK_PowerCalculation] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Protocol] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Protocol]( [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NOT NULL, [Type] [varchar](200) NOT NULL CONSTRAINT [DF_Protocol_Type] DEFAULT (N'Frame'), [Category] [varchar](200) NOT NULL CONSTRAINT [DF_Protocol_Category] DEFAULT (N'Phasor'), [AssemblyName] [varchar](1024) NOT NULL CONSTRAINT [DF_Protocol_AssemblyName] DEFAULT (N'PhasorProtocolAdapters.dll'), [TypeName] [varchar](200) NOT NULL CONSTRAINT [DF_Protocol_TypeName] DEFAULT (N'PhasorProtocolAdapters.PhasorMeasurementMapper'), [LoadOrder] [int] NOT NULL CONSTRAINT [DF_Protocol_LoadOrder] DEFAULT ((0)), CONSTRAINT [PK_Protocol] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Runtime] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Runtime]( [ID] [int] IDENTITY(1,1) NOT NULL, [SourceID] [int] NOT NULL, [SourceTable] [varchar](200) NOT NULL, CONSTRAINT [PK_Runtime] PRIMARY KEY CLUSTERED ( [SourceID] ASC, [SourceTable] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SecurityGroup] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SecurityGroup]( [ID] [uniqueidentifier] NOT NULL, [Name] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_SecurityGroup] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SecurityGroupUserAccount] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SecurityGroupUserAccount]( [SecurityGroupID] [uniqueidentifier] NOT NULL, [UserAccountID] [uniqueidentifier] NOT NULL ) ON [PRIMARY] GO /****** Object: Table [dbo].[SentEmail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SentEmail]( [ID] [int] IDENTITY(1,1) NOT NULL, [DeviceID] [int] NOT NULL, [Message] [nvarchar](max) NOT NULL, [Timestamp] [datetime2](7) NOT NULL, CONSTRAINT [PK_SentEmail] 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] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[SignalType] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SignalType]( [ID] [int] IDENTITY(1,1) NOT NULL, [Name] [varchar](200) NOT NULL, [Acronym] [varchar](4) NOT NULL, [Suffix] [varchar](2) NOT NULL, [Abbreviation] [varchar](2) NOT NULL, [LongAcronym] [varchar](200) NOT NULL DEFAULT ('Undefined'), [Source] [varchar](10) NOT NULL, [EngineeringUnits] [varchar](10) NULL, CONSTRAINT [PK_SignalType] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Statistic] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Statistic]( [ID] [int] IDENTITY(1,1) NOT NULL, [Source] [varchar](20) NOT NULL, [SignalIndex] [int] NOT NULL, [Name] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [AssemblyName] [varchar](max) NOT NULL, [TypeName] [varchar](max) NOT NULL, [MethodName] [varchar](200) NOT NULL, [Arguments] [varchar](max) NULL, [Enabled] [bit] NOT NULL CONSTRAINT [DF_Statistic_Enabled] DEFAULT ((0)), [DataType] [varchar](200) NULL, [DisplayFormat] [varchar](200) NULL, [IsConnectedState] [bit] NOT NULL CONSTRAINT [DF_Statistic_IsConnectedState] DEFAULT ((0)), [LoadOrder] [int] NOT NULL CONSTRAINT [DF_Statistic_LoadOrder] DEFAULT ((0)), CONSTRAINT [PK_Statistic] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[StatusLog] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[StatusLog]( [ID] [int] IDENTITY(1,1) NOT NULL, [DeviceID] [int] NOT NULL, [LastDownloadedFileID] [int] NULL, [LastOutcome] [nvarchar](50) NULL, [LastRun] [datetime2](7) NULL, [LastFailure] [datetime2](7) NULL, [LastErrorMessage] [nvarchar](max) NULL, [LastDownloadStartTime] [datetime2](7) NULL, [LastDownloadEndTime] [datetime2](7) NULL, [LastDownloadFileCount] [int] NULL, CONSTRAINT [PK_StatusLog] 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] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Subscriber] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Subscriber]( [NodeID] [uniqueidentifier] NOT NULL, [ID] [uniqueidentifier] NOT NULL, [Acronym] [varchar](200) NOT NULL, [Name] [varchar](200) NULL, [SharedSecret] [varchar](200) NULL, [AuthKey] [varchar](max) NULL, [ValidIPAddresses] [varchar](max) NULL, [RemoteCertificateFile] [varchar](500) NULL, [ValidPolicyErrors] [varchar](200) NULL, [ValidChainFlags] [varchar](500) NULL, [AccessControlFilter] [varchar](max) NULL, [Enabled] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_Subscriber] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SubscriberMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SubscriberMeasurement]( [NodeID] [uniqueidentifier] NOT NULL, [SubscriberID] [uniqueidentifier] NOT NULL, [SignalID] [uniqueidentifier] NOT NULL, [Allowed] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_SubscriberMeasurement] PRIMARY KEY CLUSTERED ( [NodeID] ASC, [SubscriberID] ASC, [SignalID] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[SubscriberMeasurementGroup] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[SubscriberMeasurementGroup]( [NodeID] [uniqueidentifier] NOT NULL, [SubscriberID] [uniqueidentifier] NOT NULL, [MeasurementGroupID] [int] NOT NULL, [Allowed] [bit] NOT NULL, [CreatedOn] [datetime] NOT NULL, [CreatedBy] [varchar](200) NOT NULL, [UpdatedOn] [datetime] NOT NULL, [UpdatedBy] [varchar](200) NOT NULL, CONSTRAINT [PK_SubscriberMeasurementGroup] PRIMARY KEY CLUSTERED ( [NodeID] ASC, [SubscriberID] ASC, [MeasurementGroupID] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[TrackedChange] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[TrackedChange]( [ID] [bigint] IDENTITY(1,1) NOT NULL, [TableName] [varchar](200) NOT NULL, [PrimaryKeyColumn] [varchar](200) NOT NULL, [PrimaryKeyValue] [varchar](max) NULL, CONSTRAINT [PK_TrackedChange] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[UserAccount] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[UserAccount]( [ID] [uniqueidentifier] NOT NULL CONSTRAINT [DF_UserAccount_ID] DEFAULT (newid()), [Name] [varchar](200) NOT NULL, [Password] [varchar](200) NULL, [FirstName] [varchar](200) NULL, [LastName] [varchar](200) NULL, [DefaultNodeID] [uniqueidentifier] NOT NULL, [Phone] [varchar](200) NULL, [Email] [varchar](200) NULL, [LockedOut] [bit] NOT NULL CONSTRAINT [DF_UserAccount_LockedOut] DEFAULT ((0)), [UseADAuthentication] [bit] NOT NULL CONSTRAINT [DF_UserAccount_UseADAuthentication] DEFAULT ((1)), [ChangePasswordOn] [datetime] NULL CONSTRAINT [DF_UserAccount_ChangePasswordOn] DEFAULT (dateadd(day,(90),getutcdate())), [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_UserAccount_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](50) NOT NULL CONSTRAINT [DF_UserAccount_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_UserAccount_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](50) NOT NULL CONSTRAINT [DF_UserAccount_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_UserAccount] 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 SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[Vendor] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[Vendor]( [ID] [int] IDENTITY(1,1) NOT NULL, [Acronym] [varchar](200) NULL, [Name] [varchar](200) NOT NULL, [PhoneNumber] [varchar](200) NULL, [ContactEmail] [varchar](200) NULL, [URL] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_Vendor_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Vendor_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_Vendor_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_Vendor_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_Vendor] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: Table [dbo].[VendorDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[VendorDevice]( [ID] [int] IDENTITY(1,1) NOT NULL, [VendorID] [int] NOT NULL CONSTRAINT [DF_VendorDevice_VendorID] DEFAULT ((10)), [Name] [varchar](200) NOT NULL, [Description] [varchar](max) NULL, [URL] [varchar](max) NULL, [CreatedOn] [datetime] NOT NULL CONSTRAINT [DF_VendorDevice_CreatedOn] DEFAULT (getutcdate()), [CreatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_VendorDevice_CreatedBy] DEFAULT (suser_name()), [UpdatedOn] [datetime] NOT NULL CONSTRAINT [DF_VendorDevice_UpdatedOn] DEFAULT (getutcdate()), [UpdatedBy] [varchar](200) NOT NULL CONSTRAINT [DF_VendorDevice_UpdatedBy] DEFAULT (suser_name()), CONSTRAINT [PK_VendorDevice] 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] TEXTIMAGE_ON [PRIMARY] GO SET ANSI_PADDING OFF GO /****** Object: View [dbo].[RuntimeCalculatedMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeCalculatedMeasurement] AS SELECT TOP (100) PERCENT dbo.CalculatedMeasurement.NodeID, dbo.Runtime.ID, dbo.CalculatedMeasurement.Acronym AS AdapterName, LTRIM(RTRIM(dbo.CalculatedMeasurement.AssemblyName)) AS AssemblyName, LTRIM(RTRIM(dbo.CalculatedMeasurement.TypeName)) AS TypeName, CASE WHEN dbo.CalculatedMeasurement.ConnectionString IS NULL THEN N'' ELSE dbo.CalculatedMeasurement.ConnectionString + N'; ' END + CASE WHEN ConfigSection IS NULL THEN N'' ELSE N'configurationSection=' + ConfigSection + N'; ' END + N'minimumMeasurementsToUse=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.MinimumMeasurementsToUse) + N'; framesPerSecond=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.FramesPerSecond) + N'; lagTime=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.LagTime) + N'; leadTime=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.LeadTime) + CASE WHEN InputMeasurements IS NULL THEN N'' ELSE N'; inputMeasurementKeys={' + InputMeasurements + '}' END + CASE WHEN OutputMeasurements IS NULL THEN N'' ELSE N'; outputMeasurements={' + OutputMeasurements + '}' END + N'; ignoreBadTimestamps=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.IgnoreBadTimeStamps) + N'; timeResolution=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.TimeResolution) + N'; allowPreemptivePublishing=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.AllowPreemptivePublishing) + N'; performTimestampReasonabilityCheck=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.PerformTimeReasonabilityCheck) + N'; downsamplingMethod=' + dbo.CalculatedMeasurement.DownsamplingMethod + N'; useLocalClockAsRealTime=' + CONVERT(NVARCHAR(10), dbo.CalculatedMeasurement.UseLocalClockAsRealTime) AS ConnectionString FROM dbo.CalculatedMeasurement WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.CalculatedMeasurement.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'CalculatedMeasurement' WHERE (dbo.CalculatedMeasurement.Enabled <> 0) ORDER BY dbo.CalculatedMeasurement.LoadOrder GO /****** Object: View [dbo].[RuntimeCustomActionAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeCustomActionAdapter] AS SELECT TOP (100) PERCENT dbo.CustomActionAdapter.NodeID, dbo.Runtime.ID, dbo.CustomActionAdapter.AdapterName, LTRIM(RTRIM(dbo.CustomActionAdapter.AssemblyName)) AS AssemblyName, LTRIM(RTRIM(dbo.CustomActionAdapter.TypeName)) AS TypeName, dbo.CustomActionAdapter.ConnectionString FROM dbo.CustomActionAdapter WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.CustomActionAdapter.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'CustomActionAdapter' WHERE (dbo.CustomActionAdapter.Enabled <> 0) ORDER BY dbo.CustomActionAdapter.LoadOrder GO /****** Object: View [dbo].[RuntimeOutputStream] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeOutputStream] AS SELECT TOP (100) PERCENT dbo.OutputStream.NodeID, dbo.Runtime.ID, dbo.OutputStream.Acronym AS AdapterName, N'PhasorProtocolAdapters.dll' AS AssemblyName, CASE Type WHEN 1 THEN N'PhasorProtocolAdapters.BpaPdcStream.Concentrator' WHEN 2 THEN N'PhasorProtocolAdapters.Iec61850_90_5.Concentrator' ELSE N'PhasorProtocolAdapters.IeeeC37_118.Concentrator' END AS TypeName, CASE WHEN dbo.OutputStream.ConnectionString IS NULL THEN N'' ELSE dbo.OutputStream.ConnectionString + N'; ' END + CASE WHEN dbo.OutputStream.DataChannel IS NULL THEN N'' ELSE N'dataChannel={' + dbo.OutputStream.DataChannel + N'}' END + CASE WHEN dbo.OutputStream.CommandChannel IS NULL THEN N'' ELSE N'; commandChannel={' + dbo.OutputStream.CommandChannel + N'}' END + N'; idCode=' + CONVERT(NVARCHAR(10), dbo.OutputStream.IDCode) + N'; autoPublishConfigFrame=' + CONVERT(NVARCHAR(10), dbo.OutputStream.AutoPublishConfigFrame) + N'; autoStartDataChannel=' + CONVERT(NVARCHAR(10), dbo.OutputStream.AutoStartDataChannel) + N'; nominalFrequency=' + CONVERT(NVARCHAR(10), dbo.OutputStream.NominalFrequency) + N'; lagTime=' + CONVERT(NVARCHAR(10), dbo.OutputStream.LagTime) + N'; leadTime=' + CONVERT(NVARCHAR(10), dbo.OutputStream.LeadTime) + N'; framesPerSecond=' + CONVERT(NVARCHAR(10), dbo.OutputStream.FramesPerSecond) + N'; useLocalClockAsRealTime=' + CONVERT(NVARCHAR(10), dbo.OutputStream.UseLocalClockAsRealTime) + N'; allowSortsByArrival=' + CONVERT(NVARCHAR(10), dbo.OutputStream.AllowSortsByArrival) + N'; ignoreBadTimestamps=' + CONVERT(NVARCHAR(10), dbo.OutputStream.IgnoreBadTimestamps) + N'; timeResolution=' + CONVERT(NVARCHAR(10), dbo.OutputStream.TimeResolution) + N'; allowPreemptivePublishing=' + CONVERT(NVARCHAR(10), dbo.OutputStream.AllowPreemptivePublishing) + N'; performTimestampReasonabilityCheck=' + CONVERT(NVARCHAR(10), dbo.OutputStream.PerformTimeReasonabilityCheck) + N'; downsamplingMethod=' + dbo.OutputStream.DownsamplingMethod + N'; dataFormat=' + dbo.OutputStream.DataFormat + N'; coordinateFormat=' + dbo.OutputStream.CoordinateFormat + N'; currentScalingValue=' + CONVERT(NVARCHAR(10), dbo.OutputStream.CurrentScalingValue) + N'; voltageScalingValue=' + CONVERT(NVARCHAR(10), dbo.OutputStream.VoltageScalingValue) + N'; analogScalingValue=' + CONVERT(NVARCHAR(10), dbo.OutputStream.AnalogScalingValue) + N'; digitalMaskValue=' + CONVERT(NVARCHAR(10), dbo.OutputStream.DigitalMaskValue) AS ConnectionString FROM dbo.OutputStream WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.OutputStream.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'OutputStream' WHERE (dbo.OutputStream.Enabled <> 0) ORDER BY dbo.OutputStream.LoadOrder GO /****** Object: View [dbo].[IaonActionAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[IaonActionAdapter] AS SELECT Node.ID AS NodeID, 0 AS ID, N'PHASOR!SERVICES' AS AdapterName, N'PhasorProtocolAdapters.dll' AS AssemblyName, N'PhasorProtocolAdapters.CommonPhasorServices' AS TypeName, N'' AS ConnectionString FROM dbo.Node WITH (NOLOCK) UNION SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeOutputStream WITH (NOLOCK) UNION SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeCalculatedMeasurement WITH (NOLOCK) UNION SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeCustomActionAdapter WITH (NOLOCK) GO /****** Object: View [dbo].[RuntimeCustomInputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeCustomInputAdapter] AS SELECT TOP (100) PERCENT dbo.CustomInputAdapter.NodeID, dbo.Runtime.ID, dbo.CustomInputAdapter.AdapterName, LTRIM(RTRIM(dbo.CustomInputAdapter.AssemblyName)) AS AssemblyName, LTRIM(RTRIM(dbo.CustomInputAdapter.TypeName)) AS TypeName, dbo.CustomInputAdapter.ConnectionString FROM dbo.CustomInputAdapter WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.CustomInputAdapter.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'CustomInputAdapter' WHERE (dbo.CustomInputAdapter.Enabled <> 0) ORDER BY dbo.CustomInputAdapter.LoadOrder GO /****** Object: View [dbo].[RuntimeDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeDevice] AS SELECT TOP (100) PERCENT dbo.Device.NodeID, dbo.Runtime.ID, dbo.Device.Acronym AS AdapterName, dbo.Protocol.AssemblyName, dbo.Protocol.TypeName, CASE WHEN dbo.Device.ConnectionString IS NULL THEN N'' ELSE dbo.Device.ConnectionString END + N'; isConcentrator=' + CONVERT(NVARCHAR(10), dbo.Device.IsConcentrator) + N'; accessID=' + CONVERT(NVARCHAR(10), dbo.Device.AccessID) + CASE WHEN dbo.Device.TimeZone IS NULL THEN N'' ELSE N'; timeZone=' + dbo.Device.TimeZone END + N'; timeAdjustmentTicks=' + CONVERT(NVARCHAR(30), dbo.Device.TimeAdjustmentTicks) + CASE WHEN dbo.Protocol.Acronym IS NULL THEN N'' ELSE N'; phasorProtocol=' + dbo.Protocol.Acronym END + N'; dataLossInterval=' + CONVERT(NVARCHAR(10), dbo.Device.DataLossInterval) + N'; allowedParsingExceptions=' + CONVERT(NVARCHAR(10), dbo.Device.AllowedParsingExceptions) + N'; parsingExceptionWindow=' + CONVERT(NVARCHAR(10), dbo.Device.ParsingExceptionWindow) + N'; delayedConnectionInterval=' + CONVERT(NVARCHAR(10), dbo.Device.DelayedConnectionInterval) + N'; allowUseOfCachedConfiguration=' + CONVERT (NVARCHAR(10), dbo.Device.AllowUseOfCachedConfiguration) + N'; autoStartDataParsingSequence=' + CONVERT(NVARCHAR(10), dbo.Device.AutoStartDataParsingSequence) + N'; skipDisableRealTimeData=' + CONVERT(NVARCHAR(10), dbo.Device.SkipDisableRealTimeData) + N'; measurementReportingInterval=' + CONVERT(NVARCHAR(10), dbo.Device.MeasurementReportingInterval) + N'; connectOnDemand=' + CONVERT(NVARCHAR(10), dbo.Device.ConnectOnDemand) AS ConnectionString FROM dbo.Device WITH (NOLOCK) LEFT OUTER JOIN dbo.Protocol WITH (NOLOCK) ON dbo.Device.ProtocolID = dbo.Protocol.ID LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.Device.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'Device' WHERE (dbo.Device.Enabled <> 0 AND Device.ParentID IS NULL) ORDER BY dbo.Device.LoadOrder GO /****** Object: View [dbo].[IaonInputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[IaonInputAdapter] AS SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeDevice WITH (NOLOCK) UNION SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeCustomInputAdapter WITH (NOLOCK) GO /****** Object: View [dbo].[RuntimeCustomOutputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeCustomOutputAdapter] AS SELECT TOP (100) PERCENT dbo.CustomOutputAdapter.NodeID, dbo.Runtime.ID, dbo.CustomOutputAdapter.AdapterName, LTRIM(RTRIM(dbo.CustomOutputAdapter.AssemblyName)) AS AssemblyName, LTRIM(RTRIM(dbo.CustomOutputAdapter.TypeName)) AS TypeName, dbo.CustomOutputAdapter.ConnectionString FROM dbo.CustomOutputAdapter WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.CustomOutputAdapter.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'CustomOutputAdapter' WHERE (dbo.CustomOutputAdapter.Enabled <> 0) ORDER BY dbo.CustomOutputAdapter.LoadOrder GO /****** Object: View [dbo].[RuntimeHistorian] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeHistorian] AS SELECT TOP (100) PERCENT dbo.Historian.NodeID, dbo.Runtime.ID, dbo.Historian.Acronym AS AdapterName, COALESCE (NULLIF(LTRIM(RTRIM(dbo.Historian.AssemblyName)), ''), N'HistorianAdapters.dll') AS AssemblyName, COALESCE (NULLIF(LTRIM(RTRIM(dbo.Historian.TypeName)), ''), CASE dbo.Historian.IsLocal WHEN 1 THEN N'HistorianAdapters.LocalOutputAdapter' ELSE N'HistorianAdapters.RemoteOutputAdapter' END) AS TypeName, CASE WHEN Historian.ConnectionString IS NULL THEN N'' ELSE Historian.ConnectionString + N'; ' END + N'instanceName=' + dbo.Historian.Acronym + N'; sourceids=' + dbo.Historian.Acronym + N'; measurementReportingInterval=' + CONVERT(NVARCHAR(10), dbo.Historian.MeasurementReportingInterval) AS ConnectionString FROM dbo.Historian WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.Historian.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'Historian' WHERE (dbo.Historian.Enabled <> 0) ORDER BY dbo.Historian.LoadOrder GO /****** Object: View [dbo].[IaonOutputAdapter] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[IaonOutputAdapter] AS SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeHistorian WITH (NOLOCK) UNION SELECT NodeID, ID, AdapterName, AssemblyName, TypeName, ConnectionString FROM dbo.RuntimeCustomOutputAdapter WITH (NOLOCK) GO /****** Object: View [dbo].[IaonTreeView] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[IaonTreeView] AS SELECT 'Action Adapters' AS AdapterType, NodeID, ID, AdapterName, AssemblyName, TypeName, ISNULL(ConnectionString, '') AS ConnectionString FROM dbo.IaonActionAdapter WITH (NOLOCK) UNION ALL SELECT 'Input Adapters' AS AdapterType, NodeID, ID, AdapterName, AssemblyName, TypeName, ISNULL(ConnectionString, '') AS ConnectionString FROM dbo.IaonInputAdapter WITH (NOLOCK) UNION ALL SELECT 'Output Adapters' AS AdapterType, NodeID, ID, AdapterName, AssemblyName, TypeName, ISNULL(ConnectionString, '') AS ConnectionString FROM dbo.IaonOutputAdapter WITH (NOLOCK) GO /****** Object: View [dbo].[VendorDeviceDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[VendorDeviceDetail] AS SELECT VD.ID, VD.VendorID, VD.Name, ISNULL(VD.Description, '') AS Description, ISNULL(VD.URL, '') AS URL, V.Name AS VendorName, V.Acronym AS VendorAcronym FROM dbo.VendorDevice AS VD WITH (NOLOCK) INNER JOIN dbo.Vendor AS V WITH (NOLOCK) ON VD.VendorID = V.ID GO /****** Object: View [dbo].[DeviceDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[DeviceDetail] AS SELECT D.NodeID, D.ID, D.ParentID, D.UniqueID, D.Acronym, ISNULL(D.Name, '') AS Name, D.OriginalSource, D.IsConcentrator, D.CompanyID, D.HistorianID, D.AccessID, D.VendorDeviceID, D.ProtocolID, D.Longitude, D.Latitude, D.InterconnectionID, ISNULL(D.ConnectionString, '') AS ConnectionString, ISNULL(D.TimeZone, '') AS TimeZone, ISNULL(D.FramesPerSecond, 30) AS FramesPerSecond, D.TimeAdjustmentTicks, D.DataLossInterval, D.ConnectOnDemand, ISNULL(D.ContactList, '') AS ContactList, D.MeasuredLines, D.LoadOrder, D.Enabled, ISNULL(C.Name, '') AS CompanyName, ISNULL(C.Acronym, '') AS CompanyAcronym, ISNULL(C.MapAcronym, '') AS CompanyMapAcronym, ISNULL(H.Acronym, '') AS HistorianAcronym, ISNULL(VD.VendorAcronym, '') AS VendorAcronym, ISNULL(VD.Name, '') AS VendorDeviceName, ISNULL(P.Name, '') AS ProtocolName, P.Type AS ProtocolType, P.Category, ISNULL(I.Name, '') AS InterconnectionName, N.Name AS NodeName, ISNULL(PD.Acronym, '') AS ParentAcronym, D.CreatedOn, D.AllowedParsingExceptions, D.ParsingExceptionWindow, D.DelayedConnectionInterval, D.AllowUseOfCachedConfiguration, D.AutoStartDataParsingSequence, D.SkipDisableRealTimeData, D.MeasurementReportingInterval, D.UpdatedOn FROM dbo.Device AS D WITH (NOLOCK) LEFT OUTER JOIN dbo.Company AS C WITH (NOLOCK) ON C.ID = D.CompanyID LEFT OUTER JOIN dbo.Historian AS H WITH (NOLOCK) ON H.ID = D.HistorianID LEFT OUTER JOIN dbo.VendorDeviceDetail AS VD WITH (NOLOCK) ON VD.ID = D.VendorDeviceID LEFT OUTER JOIN dbo.Protocol AS P WITH (NOLOCK) ON P.ID = D.ProtocolID LEFT OUTER JOIN dbo.Interconnection AS I WITH (NOLOCK) ON I.ID = D.InterconnectionID LEFT OUTER JOIN dbo.Node AS N WITH (NOLOCK) ON N.ID = D.NodeID LEFT OUTER JOIN dbo.Device AS PD WITH (NOLOCK) ON PD.ID = D.ParentID GO /****** Object: View [dbo].[OtherDeviceDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[OtherDeviceDetail] AS SELECT OD.ID, OD.Acronym, ISNULL(OD.Name, '') AS Name, OD.IsConcentrator, OD.CompanyID, OD.VendorDeviceID, OD.Longitude, OD.Latitude, OD.InterconnectionID, OD.Planned, OD.Desired, OD.InProgress, ISNULL(C.Name, '') AS CompanyName, ISNULL(C.Acronym, '') AS CompanyAcronym, ISNULL(C.MapAcronym, '') AS CompanyMapAcronym, ISNULL(VD.Name, '') AS VendorDeviceName, ISNULL(I.Name, '') AS InterconnectionName FROM dbo.OtherDevice AS OD WITH (NOLOCK) LEFT OUTER JOIN dbo.Company AS C WITH (NOLOCK) ON OD.CompanyID = C.ID LEFT OUTER JOIN dbo.VendorDevice AS VD WITH (NOLOCK) ON OD.VendorDeviceID = VD.ID LEFT OUTER JOIN dbo.Interconnection AS I WITH (NOLOCK) ON OD.InterconnectionID = I.ID GO /****** Object: View [dbo].[MapData] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[MapData] AS SELECT 'Device' AS DeviceType, NodeID, ID, Acronym, ISNULL(Name, '') AS Name, CompanyMapAcronym, CompanyName, VendorDeviceName, Longitude, Latitude, CONVERT(BIT, '1') AS Reporting, CONVERT(BIT, '0') AS Inprogress, CONVERT(BIT, '0') AS Planned, CONVERT(BIT, '0') AS Desired FROM dbo.DeviceDetail AS D WITH (NOLOCK) UNION ALL SELECT 'OtherDevice' AS DeviceType, NULL AS NodeID, ID, Acronym, ISNULL(Name, '') AS Name, CompanyMapAcronym, CompanyName, VendorDeviceName, Longitude, Latitude, CONVERT(BIT, '0') AS Reporting, CONVERT(BIT, '1') AS Inprogress, CONVERT(BIT, '1') AS Planned, CONVERT(BIT, '1') AS Desired FROM dbo.OtherDeviceDetail AS OD WITH (NOLOCK) GO /****** Object: View [dbo].[MeasurementDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[MeasurementDetail] AS SELECT dbo.Device.CompanyID, dbo.Company.Acronym AS CompanyAcronym, dbo.Company.Name AS CompanyName, dbo.Measurement.SignalID, dbo.Measurement.HistorianID, dbo.Historian.Acronym AS HistorianAcronym, dbo.Historian.ConnectionString AS HistorianConnectionString, dbo.Measurement.PointID, dbo.Measurement.PointTag, dbo.Measurement.AlternateTag, dbo.Measurement.DeviceID, COALESCE (dbo.Device.NodeID, dbo.Historian.NodeID) AS NodeID, dbo.Device.Acronym AS DeviceAcronym, dbo.Device.Name AS DeviceName, COALESCE(dbo.Device.FramesPerSecond, 30) AS FramesPerSecond, dbo.Device.Enabled AS DeviceEnabled, dbo.Device.ContactList, dbo.Device.VendorDeviceID, dbo.VendorDevice.Name AS VendorDeviceName, dbo.VendorDevice.Description AS VendorDeviceDescription, dbo.Device.ProtocolID, dbo.Protocol.Acronym AS ProtocolAcronym, dbo.Protocol.Name AS ProtocolName, dbo.Measurement.SignalTypeID, dbo.Measurement.PhasorSourceIndex, dbo.Phasor.Label AS PhasorLabel, dbo.Phasor.Type AS PhasorType, dbo.Phasor.Phase, dbo.Measurement.SignalReference, dbo.Measurement.Adder, dbo.Measurement.Multiplier, dbo.Measurement.Description, dbo.Measurement.Subscribed, dbo.Measurement.Internal, dbo.Measurement.Enabled, COALESCE (dbo.SignalType.EngineeringUnits, N'') AS EngineeringUnits, dbo.SignalType.Source, dbo.SignalType.Acronym AS SignalAcronym, dbo.SignalType.Name AS SignalName, dbo.SignalType.Suffix AS SignalTypeSuffix, dbo.Device.Longitude, dbo.Device.Latitude, COALESCE(Historian.Acronym, Device.Acronym, '__') + ':' + CONVERT(NVARCHAR(10), Measurement.PointID) AS ID, Measurement.UpdatedOn FROM dbo.Company WITH (NOLOCK) RIGHT OUTER JOIN dbo.Device WITH (NOLOCK) ON dbo.Company.ID = dbo.Device.CompanyID RIGHT OUTER JOIN dbo.Measurement WITH (NOLOCK) LEFT OUTER JOIN dbo.SignalType WITH (NOLOCK) ON dbo.Measurement.SignalTypeID = dbo.SignalType.ID ON dbo.Device.ID = dbo.Measurement.DeviceID LEFT OUTER JOIN dbo.Phasor WITH (NOLOCK) ON dbo.Measurement.DeviceID = dbo.Phasor.DeviceID AND dbo.Measurement.PhasorSourceIndex = dbo.Phasor.SourceIndex LEFT OUTER JOIN dbo.VendorDevice WITH (NOLOCK) ON dbo.Device.VendorDeviceID = dbo.VendorDevice.ID LEFT OUTER JOIN dbo.Protocol WITH (NOLOCK) ON dbo.Device.ProtocolID = dbo.Protocol.ID LEFT OUTER JOIN dbo.Historian WITH (NOLOCK) ON dbo.Measurement.HistorianID = dbo.Historian.ID GO /****** Object: View [dbo].[StatisticMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[StatisticMeasurement] AS SELECT * FROM MeasurementDetail WITH (NOLOCK) WHERE SignalAcronym = 'STAT' GO /****** Object: View [dbo].[HistorianMetadata] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[HistorianMetadata] AS SELECT HistorianID = PointID, DataType = CASE SignalAcronym WHEN 'DIGI' THEN 1 ELSE 0 END, [Name] = PointTag, Synonym1 = SignalReference, Synonym2 = SignalAcronym, Synonym3 = AlternateTag, Description = Description, HardwareInfo = VendorDeviceDescription, Remarks = '', PlantCode = HistorianAcronym, UnitNumber = 1, SystemName = DeviceAcronym, SourceID = ProtocolID, Enabled = Enabled, ScanRate = 1.0 / FramesPerSecond, CompressionMinTime = 0, CompressionMaxTime = 0, EngineeringUnits = EngineeringUnits, LowWarning = CASE SignalAcronym WHEN 'FREQ' THEN 59.95 WHEN 'VPHM' THEN 475000 WHEN 'IPHM' THEN 0 WHEN 'VPHA' THEN -181 WHEN 'IPHA' THEN -181 ELSE 0 END, HighWarning = CASE SignalAcronym WHEN 'FREQ' THEN 60.05 WHEN 'VPHM' THEN 525000 WHEN 'IPHM' THEN 3150 WHEN 'VPHA' THEN 181 WHEN 'IPHA' THEN 181 ELSE 0 END, LowAlarm = CASE SignalAcronym WHEN 'FREQ' THEN 59.90 WHEN 'VPHM' THEN 450000 WHEN 'IPHM' THEN 0 WHEN 'VPHA' THEN -181 WHEN 'IPHA' THEN -181 ELSE 0 END, HighAlarm = CASE SignalAcronym WHEN 'FREQ' THEN 60.10 WHEN 'VPHM' THEN 550000 WHEN 'IPHM' THEN 3300 WHEN 'VPHA' THEN 181 WHEN 'IPHA' THEN 181 ELSE 0 END, LowRange = CASE SignalAcronym WHEN 'FREQ' THEN 59.95 WHEN 'VPHM' THEN 475000 WHEN 'IPHM' THEN 0 WHEN 'VPHA' THEN -180 WHEN 'IPHA' THEN -180 ELSE 0 END, HighRange = CASE SignalAcronym WHEN 'FREQ' THEN 60.05 WHEN 'VPHM' THEN 525000 WHEN 'IPHM' THEN 3000 WHEN 'VPHA' THEN 180 WHEN 'IPHA' THEN 180 ELSE 0 END, CompressionLimit = 0.0, ExceptionLimit = 0.0, DisplayDigits = CASE SignalAcronym WHEN 'DIGI' THEN 0 ELSE 7 END, SetDescription = '', ClearDescription = '', AlarmState = 0, ChangeSecurity = 5, AccessSecurity = 0, StepCheck = 0, AlarmEnabled = 0, AlarmFlags = 0, AlarmDelay = 0, AlarmToFile = 0, AlarmByEmail = 0, AlarmByPager = 0, AlarmByPhone = 0, AlarmEmails = MeasurementDetail.ContactList, AlarmPagers = '', AlarmPhones = '' FROM [dbo].[MeasurementDetail] WITH (NOLOCK) GO /****** Object: View [dbo].[ActiveMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[ActiveMeasurement] AS SELECT dbo.Node.ID AS NodeID, COALESCE(dbo.Device.NodeID, dbo.Historian.NodeID) AS SourceNodeID, COALESCE(dbo.Historian.Acronym, dbo.Device.Acronym, '__') + ':' + CONVERT(NVARCHAR(10), dbo.Measurement.PointID) AS ID, dbo.Measurement.SignalID, dbo.Measurement.PointTag, dbo.Measurement.AlternateTag, dbo.Measurement.SignalReference, dbo.Measurement.Internal, dbo.Measurement.Subscribed, dbo.Device.Acronym AS Device, CASE WHEN dbo.Device.IsConcentrator = 0 AND dbo.Device.ParentID IS NOT NULL THEN RuntimeP.ID ELSE dbo.Runtime.ID END AS DeviceID, COALESCE(dbo.Device.FramesPerSecond, 30) AS FramesPerSecond, dbo.Protocol.Acronym AS Protocol, dbo.Protocol.Type AS ProtocolType, dbo.SignalType.Acronym AS SignalType, dbo.SignalType.EngineeringUnits, dbo.Phasor.ID AS PhasorID, dbo.Phasor.Type AS PhasorType, dbo.Phasor.Phase, dbo.Measurement.Adder, dbo.Measurement.Multiplier, dbo.Company.Acronym AS Company, dbo.Device.Longitude, dbo.Device.Latitude, dbo.Measurement.Description, dbo.Measurement.UpdatedOn FROM dbo.Company WITH (NOLOCK) RIGHT OUTER JOIN dbo.Device WITH (NOLOCK) ON dbo.Company.ID = dbo.Device.CompanyID RIGHT OUTER JOIN dbo.Measurement WITH (NOLOCK) LEFT OUTER JOIN dbo.SignalType WITH (NOLOCK) ON dbo.Measurement.SignalTypeID = dbo.SignalType.ID ON dbo.Device.ID = dbo.Measurement.DeviceID LEFT OUTER JOIN dbo.Phasor WITH (NOLOCK) ON dbo.Measurement.DeviceID = dbo.Phasor.DeviceID AND dbo.Measurement.PhasorSourceIndex = dbo.Phasor.SourceIndex LEFT OUTER JOIN dbo.Protocol WITH (NOLOCK) ON dbo.Device.ProtocolID = dbo.Protocol.ID LEFT OUTER JOIN dbo.Historian WITH (NOLOCK) ON dbo.Measurement.HistorianID = dbo.Historian.ID LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.Device.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'Device' LEFT OUTER JOIN dbo.Runtime AS RuntimeP WITH (NOLOCK) ON RuntimeP.SourceID = dbo.Device.ParentID AND RuntimeP.SourceTable = N'Device' CROSS JOIN dbo.Node WITH (NOLOCK) WHERE (dbo.Device.Enabled <> 0 OR dbo.Device.Enabled IS NULL) AND (dbo.Measurement.Enabled <> 0) UNION ALL SELECT NodeID, SourceNodeID, Source + ':' + CONVERT(NVARCHAR(10), PointID) AS ID, SignalID, PointTag, AlternateTag, SignalReference, 0 AS Internal, 1 AS Subscribed, NULL AS Device, NULL AS DeviceID, FramesPerSecond, ProtocolAcronym AS Protocol, ProtocolType, SignalTypeAcronym AS SignalType, '' AS EngineeringUnits, PhasorID, PhasorType, Phase, Adder, Multiplier, CompanyAcronym AS Company, Longitude, Latitude, Description, getutcdate() AS UpdatedOn FROM dbo.ImportedMeasurement WITH (NOLOCK) WHERE dbo.ImportedMeasurement.Enabled <> 0 GO /****** Object: View [dbo].[AppRoleSecurityGroupDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[AppRoleSecurityGroupDetail] AS SELECT ApplicationRoleSecurityGroup.ApplicationRoleID, ApplicationRoleSecurityGroup.SecurityGroupID, ApplicationRole.Name AS ApplicationRoleName, ApplicationRole.Description AS ApplicationRoleDescription, SecurityGroup.Name AS SecurityGroupName, SecurityGroup.Description AS SecurityGroupDescription FROM ApplicationRoleSecurityGroup WITH (NOLOCK), ApplicationRole WITH (NOLOCK), SecurityGroup WITH (NOLOCK) WHERE ApplicationRoleSecurityGroup.ApplicationRoleID = ApplicationRole.ID AND ApplicationRoleSecurityGroup.SecurityGroupID = SecurityGroup.ID GO /****** Object: View [dbo].[AppRoleUserAccountDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[AppRoleUserAccountDetail] AS SELECT dbo.ApplicationRoleUserAccount.ApplicationRoleID, dbo.ApplicationRoleUserAccount.UserAccountID, UserAccount.Name AS UserName, UserAccount.FirstName, UserAccount.LastName, UserAccount.Email, dbo.ApplicationRole.Name AS ApplicationRoleName, dbo.ApplicationRole.Description AS ApplicationRoleDescription FROM dbo.ApplicationRoleUserAccount WITH (NOLOCK) INNER JOIN dbo.ApplicationRole WITH (NOLOCK) ON dbo.ApplicationRoleUserAccount.ApplicationRoleID = dbo.ApplicationRole.ID INNER JOIN UserAccount WITH (NOLOCK) ON dbo.ApplicationRoleUserAccount.UserAccountID = UserAccount.ID GO /****** Object: View [dbo].[CalculatedMeasurementDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[CalculatedMeasurementDetail] AS SELECT CM.NodeID, CM.ID, CM.Acronym, ISNULL(CM.Name, '') AS Name, CM.AssemblyName, CM.TypeName, ISNULL(CM.ConnectionString, '') AS ConnectionString, ISNULL(CM.ConfigSection, '') AS ConfigSection, ISNULL(CM.InputMeasurements, '') AS InputMeasurements, ISNULL(CM.OutputMeasurements, '') AS OutputMeasurements, CM.MinimumMeasurementsToUse, CM.FramesPerSecond, CM.LagTime, CM.LeadTime, CM.UseLocalClockAsRealTime, CM.AllowSortsByArrival, CM.LoadOrder, CM.Enabled, N.Name AS NodeName, CM.IgnoreBadTimeStamps, CM.TimeResolution, CM.AllowPreemptivePublishing, ISNULL(CM.DownsamplingMethod, '') AS DownsamplingMethod, CM.PerformTimeReasonabilityCheck FROM CalculatedMeasurement CM WITH (NOLOCK), Node N WITH (NOLOCK) WHERE CM.NodeID = N.ID GO /****** Object: View [dbo].[CurrentAlarmState] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[CurrentAlarmState] AS SELECT SignalsWithAlarms.SignalID, CurrentState.NewState AS State, CurrentState.Timestamp, CurrentState.Value FROM ( SELECT DISTINCT Measurement.SignalID FROM Measurement JOIN Alarm ON Measurement.SignalID = Alarm.SignalID WHERE Alarm.Enabled <> 0 ) AS SignalsWithAlarms LEFT OUTER JOIN ( SELECT Log1.SignalID, Log1.NewState, Log1.Timestamp, Log1.Value FROM AlarmLog AS Log1 LEFT OUTER JOIN AlarmLog AS Log2 ON Log1.SignalID = Log2.SignalID AND Log1.Ticks < Log2.Ticks WHERE Log2.ID IS NULL ) AS CurrentState ON SignalsWithAlarms.SignalID = CurrentState.SignalID GO /****** Object: View [dbo].[CustomActionAdapterDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[CustomActionAdapterDetail] AS SELECT CA.NodeID, CA.ID, CA.AdapterName, CA.AssemblyName, CA.TypeName, ISNULL(CA.ConnectionString, '') AS ConnectionString, CA.LoadOrder, CA.Enabled, N.Name AS NodeName FROM dbo.CustomActionAdapter AS CA WITH (NOLOCK) INNER JOIN dbo.Node AS N WITH (NOLOCK) ON CA.NodeID = N.ID GO /****** Object: View [dbo].[CustomInputAdapterDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[CustomInputAdapterDetail] AS SELECT CA.NodeID, CA.ID, CA.AdapterName, CA.AssemblyName, CA.TypeName, ISNULL(CA.ConnectionString, '') AS ConnectionString, CA.LoadOrder, CA.Enabled, N.Name AS NodeName FROM dbo.CustomInputAdapter AS CA WITH (NOLOCK) INNER JOIN dbo.Node AS N WITH (NOLOCK) ON CA.NodeID = N.ID GO /****** Object: View [dbo].[CustomOutputAdapterDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[CustomOutputAdapterDetail] AS SELECT CA.NodeID, CA.ID, CA.AdapterName, CA.AssemblyName, CA.TypeName, ISNULL(CA.ConnectionString, '') AS ConnectionString, CA.LoadOrder, CA.Enabled, N.Name AS NodeName FROM dbo.CustomOutputAdapter AS CA WITH (NOLOCK) INNER JOIN dbo.Node AS N WITH (NOLOCK) ON CA.NodeID = N.ID GO /****** Object: View [dbo].[HistorianDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[HistorianDetail] AS SELECT H.NodeID, H.ID, H.Acronym, ISNULL(H.Name, '') AS Name, ISNULL(H.AssemblyName, '') AS AssemblyName, ISNULL(H.TypeName, '') AS TypeName, ISNULL(H.ConnectionString, '') AS ConnectionString, H.IsLocal, ISNULL(H.Description, '') AS Description, H.LoadOrder, H.Enabled, N.Name AS NodeName, H.MeasurementReportingInterval FROM dbo.Historian AS H WITH (NOLOCK) INNER JOIN dbo.Node AS N WITH (NOLOCK) ON H.NodeID = N.ID GO /****** Object: View [dbo].[LocalSchemaVersion] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[LocalSchemaVersion] AS SELECT 2 AS VersionNumber GO /****** Object: View [dbo].[MeasurementGroupMeasDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[MeasurementGroupMeasDetail] AS SELECT MeasurementGroupMeasurement.MeasurementGroupID AS MeasurementGroupID, MeasurementGroup.Name AS MeasurementGroupName, MeasurementGroupMeasurement.SignalID AS SignalID, Measurement.PointID AS PointID, Measurement.PointTag AS PointTag, Measurement.SignalReference AS SignalReference FROM ((MeasurementGroupMeasurement WITH (NOLOCK) JOIN MeasurementGroup WITH (NOLOCK) ON (MeasurementGroupMeasurement.MeasurementGroupID = MeasurementGroup.ID)) JOIN Measurement WITH (NOLOCK) ON (MeasurementGroupMeasurement.SignalID = Measurement.SignalID)); GO /****** Object: View [dbo].[NodeDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[NodeDetail] AS SELECT N.ID, N.Name, ISNULL(N.CompanyID, 0) AS CompanyID, ISNULL(N.Longitude, 0) AS Longitude, ISNULL(N.Latitude, 0) AS Latitude, ISNULL(N.Description, '') AS Description, ISNULL(N.ImagePath, '') AS ImagePath, ISNULL(N.Settings, '') AS Settings, N.MenuType, N.MenuData, N.Master, N.LoadOrder, N.Enabled, ISNULL(C.Name, '') AS CompanyName FROM Node N WITH (NOLOCK) LEFT JOIN Company C WITH (NOLOCK) ON N.CompanyID = C.ID GO /****** Object: View [dbo].[NodeInfo] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[NodeInfo] AS SELECT dbo.Node.ID AS NodeID, dbo.Node.Name, dbo.Company.Name AS CompanyName, dbo.Node.Longitude, dbo.Node.Latitude, dbo.Node.Description, dbo.Node.ImagePath, dbo.Node.Settings, dbo.Node.MenuType, dbo.Node.MenuData, dbo.Node.Master, dbo.Node.Enabled FROM dbo.Node WITH (NOLOCK) LEFT OUTER JOIN dbo.Company WITH (NOLOCK) ON dbo.Node.CompanyID = dbo.Company.ID GO /****** Object: View [dbo].[OutputStreamDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[OutputStreamDetail] AS SELECT OS.NodeID, OS.ID, OS.Acronym, ISNULL(OS.Name, '') AS Name, OS.Type, ISNULL(OS.ConnectionString, '') AS ConnectionString, OS.IDCode, ISNULL(OS.CommandChannel, '') AS CommandChannel, ISNULL(OS.DataChannel, '') AS DataChannel, OS.AutoPublishConfigFrame, OS.AutoStartDataChannel, OS.NominalFrequency, OS.FramesPerSecond, OS.LagTime, OS.LeadTime, OS.UseLocalClockAsRealTime, OS.AllowSortsByArrival, OS.LoadOrder, OS.Enabled, N.Name AS NodeName, OS.DigitalMaskValue, OS.AnalogScalingValue, OS.VoltageScalingValue, OS.CurrentScalingValue, OS.CoordinateFormat, OS.DataFormat, OS.DownsamplingMethod, OS.AllowPreemptivePublishing, OS.TimeResolution, OS.IgnoreBadTimeStamps, OS.PerformTimeReasonabilityCheck FROM dbo.OutputStream AS OS WITH (NOLOCK) INNER JOIN dbo.Node AS N WITH (NOLOCK) ON OS.NodeID = N.ID GO /****** Object: View [dbo].[OutputStreamDeviceDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[OutputStreamDeviceDetail] AS SELECT NodeID, AdapterID, ID, Acronym, ISNULL(BpaAcronym, '') AS BpaAcronym, Name, LoadOrder, Enabled, ISNULL(PhasorDataFormat, '') AS PhasorDataFormat, ISNULL(FrequencyDataFormat, '') AS FrequencyDataFormat, ISNULL(AnalogDataFormat, '') AS AnalogDataFormat, ISNULL(CoordinateFormat, '') AS CoordinateFormat, IDCode, CASE WHEN EXISTS (SELECT Acronym FROM Device WITH (NOLOCK) WHERE Acronym = OSD.Acronym) THEN CONVERT(bit, 0) ELSE CONVERT(bit, 1) END AS Virtual FROM dbo.OutputStreamDevice AS OSD WITH (NOLOCK) GO /****** Object: View [dbo].[OutputStreamMeasurementDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[OutputStreamMeasurementDetail] AS SELECT OSM.NodeID, OSM.AdapterID, OSM.ID, OSM.HistorianID, OSM.PointID, OSM.SignalReference, M.PointTag AS SourcePointTag, ISNULL(H.Acronym, '') AS HistorianAcronym FROM dbo.OutputStreamMeasurement AS OSM WITH (NOLOCK) INNER JOIN dbo.Measurement AS M WITH (NOLOCK) ON M.PointID = OSM.PointID LEFT OUTER JOIN dbo.Historian AS H WITH (NOLOCK) ON H.ID = OSM.HistorianID GO /****** Object: View [dbo].[PhasorDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[PhasorDetail] AS SELECT P.*, ISNULL(DP.Label, '') AS DestinationPhasorLabel, D.Acronym AS DeviceAcronym FROM Phasor P WITH (NOLOCK) LEFT OUTER JOIN Phasor DP WITH (NOLOCK) ON P.DestinationPhasorID = DP.ID LEFT OUTER JOIN Device D WITH (NOLOCK) ON P.DeviceID = D.ID GO /****** Object: View [dbo].[RuntimeInputStreamDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeInputStreamDevice] AS SELECT TOP (100) PERCENT dbo.Device.NodeID, Runtime_P.ID AS ParentID, dbo.Runtime.ID, dbo.Device.Acronym, dbo.Device.Name, dbo.Device.AccessID FROM dbo.Device WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.Device.ID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'Device' LEFT OUTER JOIN dbo.Runtime AS Runtime_P WITH (NOLOCK) ON dbo.Device.ParentID = Runtime_P.SourceID AND Runtime_P.SourceTable = N'Device' WHERE (dbo.Device.IsConcentrator = 0) AND (dbo.Device.Enabled <> 0) AND (dbo.Device.ParentID IS NOT NULL) ORDER BY dbo.Device.LoadOrder GO /****** Object: View [dbo].[RuntimeOutputStreamDevice] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeOutputStreamDevice] AS SELECT TOP (100) PERCENT dbo.OutputStreamDevice.NodeID, dbo.Runtime.ID AS ParentID, dbo.OutputStreamDevice.ID, dbo.OutputStreamDevice.IDCode, dbo.OutputStreamDevice.Acronym, dbo.OutputStreamDevice.BpaAcronym, dbo.OutputStreamDevice.Name, NULLIF(dbo.OutputStreamDevice.PhasorDataFormat, '') AS PhasorDataFormat, NULLIF(dbo.OutputStreamDevice.FrequencyDataFormat, '') AS FrequencyDataFormat, NULLIF(dbo.OutputStreamDevice.AnalogDataFormat, '') AS AnalogDataFormat, NULLIF(dbo.OutputStreamDevice.CoordinateFormat, '') AS CoordinateFormat, dbo.OutputStreamDevice.LoadOrder FROM dbo.OutputStreamDevice WITH (NOLOCK) LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.OutputStreamDevice.AdapterID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'OutputStream' WHERE (dbo.OutputStreamDevice.Enabled <> 0) ORDER BY dbo.OutputStreamDevice.LoadOrder GO /****** Object: View [dbo].[RuntimeOutputStreamMeasurement] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeOutputStreamMeasurement] AS SELECT TOP (100) PERCENT dbo.OutputStreamMeasurement.NodeID, dbo.Runtime.ID AS AdapterID, dbo.Historian.Acronym AS Historian, dbo.OutputStreamMeasurement.PointID, dbo.OutputStreamMeasurement.SignalReference FROM dbo.OutputStreamMeasurement WITH (NOLOCK) LEFT OUTER JOIN dbo.Historian WITH (NOLOCK) ON dbo.OutputStreamMeasurement.HistorianID = dbo.Historian.ID LEFT OUTER JOIN dbo.Runtime WITH (NOLOCK) ON dbo.OutputStreamMeasurement.AdapterID = dbo.Runtime.SourceID AND dbo.Runtime.SourceTable = N'OutputStream' ORDER BY dbo.OutputStreamMeasurement.HistorianID, dbo.OutputStreamMeasurement.PointID GO /****** Object: View [dbo].[RuntimeStatistic] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[RuntimeStatistic] AS SELECT dbo.Node.ID AS NodeID, dbo.Statistic.ID AS ID, dbo.Statistic.Source, dbo.Statistic.SignalIndex, dbo.Statistic.Name, dbo.Statistic.Description, dbo.Statistic.AssemblyName, dbo.Statistic.TypeName, dbo.Statistic.MethodName, dbo.Statistic.Arguments, dbo.Statistic.IsConnectedState, dbo.Statistic.DataType, dbo.Statistic.DisplayFormat, dbo.Statistic.Enabled FROM dbo.Statistic WITH (NOLOCK), dbo.Node WITH (NOLOCK) GO /****** Object: View [dbo].[SchemaVersion] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[SchemaVersion] AS SELECT 5 AS VersionNumber GO /****** Object: View [dbo].[SecurityGroupUserAccountDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[SecurityGroupUserAccountDetail] AS SELECT dbo.SecurityGroupUserAccount.SecurityGroupID, dbo.SecurityGroupUserAccount.UserAccountID, UserAccount.Name AS UserName, UserAccount.FirstName, UserAccount.LastName, UserAccount.Email, dbo.SecurityGroup.Name AS SecurityGroupName, dbo.SecurityGroup.Description AS SecurityGroupDescription FROM dbo.SecurityGroupUserAccount WITH (NOLOCK) INNER JOIN dbo.SecurityGroup WITH (NOLOCK) ON dbo.SecurityGroupUserAccount.SecurityGroupID = dbo.SecurityGroup.ID INNER JOIN UserAccount WITH (NOLOCK) ON dbo.SecurityGroupUserAccount.UserAccountID = UserAccount.ID GO /****** Object: View [dbo].[SubscriberMeasGroupDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[SubscriberMeasGroupDetail] AS SELECT SubscriberMeasurementGroup.NodeID AS NodeID, SubscriberMeasurementGroup.SubscriberID AS SubscriberID, Subscriber.Acronym AS SubscriberAcronym, COALESCE(Subscriber.Name, '') AS SubscriberName, SubscriberMeasurementGroup.MeasurementGroupID AS MeasurementGroupID, SubscriberMeasurementGroup.Allowed AS Allowed, MeasurementGroup.Name AS MeasurementGroupName FROM ((SubscriberMeasurementGroup WITH (NOLOCK) JOIN Subscriber WITH (NOLOCK) ON (SubscriberMeasurementGroup.SubscriberID = Subscriber.ID)) JOIN MeasurementGroup WITH (NOLOCK) ON (SubscriberMeasurementGroup.MeasurementGroupID = MeasurementGroup.ID)); GO /****** Object: View [dbo].[SubscriberMeasurementDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[SubscriberMeasurementDetail] AS SELECT SubscriberMeasurement.NodeID AS NodeID, SubscriberMeasurement.SubscriberID AS SubscriberID, Subscriber.Acronym AS SubscriberAcronym, COALESCE(Subscriber.Name, '') AS SubscriberName, SubscriberMeasurement.SignalID AS SignalID, SubscriberMeasurement.Allowed AS Allowed, Measurement.PointID AS PointID, Measurement.PointTag AS PointTag, Measurement.SignalReference AS SignalReference FROM ((SubscriberMeasurement WITH (NOLOCK) JOIN Subscriber WITH (NOLOCK) ON (SubscriberMeasurement.SubscriberID = Subscriber.ID)) JOIN Measurement WITH (NOLOCK) ON (SubscriberMeasurement.SignalID = Measurement.SignalID)); GO /****** Object: View [dbo].[TrackedTable] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[TrackedTable] AS SELECT 'Measurement' AS Name UNION SELECT 'ActiveMeasurement' AS Name UNION SELECT 'Device' AS Name UNION SELECT 'OutputStream' AS Name UNION SELECT 'OutputStreamDevice' AS Name UNION SELECT 'OutputStreamMeasurement' AS Name GO /****** Object: View [dbo].[VendorDetail] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[VendorDetail] AS Select ID, ISNULL(Acronym, '') AS Acronym, Name, ISNULL(PhoneNumber, '') AS PhoneNumber, ISNULL(ContactEmail, '') AS ContactEmail, ISNULL(URL, '') AS URL FROM Vendor WITH (NOLOCK) GO /****** Object: View [dbo].[VendorDeviceDistribution] Script Date: 9/20/2017 9:19:30 AM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE VIEW [dbo].[VendorDeviceDistribution] AS SELECT dbo.Device.NodeID, dbo.Vendor.Name AS VendorName, COUNT(*) AS DeviceCount FROM dbo.Device WITH (NOLOCK) LEFT OUTER JOIN dbo.VendorDevice WITH (NOLOCK) ON dbo.Device.VendorDeviceID = dbo.VendorDevice.ID INNER JOIN dbo.Vendor WITH (NOLOCK) ON dbo.VendorDevice.VendorID = dbo.Vendor.ID GROUP BY dbo.Device.NodeID, dbo.Vendor.Name GO ALTER TABLE [dbo].[AccessLog] ADD CONSTRAINT [DF_AccessLog_Timestamp] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[Alarm] ADD CONSTRAINT [DF_Alarm_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[AuditLog] ADD CONSTRAINT [DF_AuditLog_Deleted] DEFAULT ((0)) FOR [Deleted] GO ALTER TABLE [dbo].[AuditLog] ADD CONSTRAINT [DF_AuditLog_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[AuditLog] ADD CONSTRAINT [DF_AuditLog_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_MinimumMeasurementsToUse] DEFAULT ((-1)) FOR [MinimumMeasurementsToUse] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_FramesPerSecond] DEFAULT ((30)) FOR [FramesPerSecond] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_LagTime] DEFAULT ((3.0)) FOR [LagTime] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_LeadTime] DEFAULT ((1.0)) FOR [LeadTime] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_UseLocalClockAsRealTime] DEFAULT ((0)) FOR [UseLocalClockAsRealTime] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_AllowSortsByArrival] DEFAULT ((1)) FOR [AllowSortsByArrival] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_IgnoreBadTimeStamps] DEFAULT ((0)) FOR [IgnoreBadTimeStamps] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_TimeResolution] DEFAULT ((10000)) FOR [TimeResolution] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_AllowPreemptivePublishing] DEFAULT ((1)) FOR [AllowPreemptivePublishing] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_PerformTimestampReasonabilityCheck] DEFAULT ((1)) FOR [PerformTimeReasonabilityCheck] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_DownsamplingMethod] DEFAULT (N'LastReceived') FOR [DownsamplingMethod] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[CalculatedMeasurement] ADD CONSTRAINT [DF_CalculatedMeasurement_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[ConnectionProfile] ADD CONSTRAINT [DF_ConnectionProfile_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[ConnectionProfile] ADD CONSTRAINT [DF_ConnectionProfile_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[ConnectionProfile] ADD CONSTRAINT [DF_ConnectionProfile_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[ConnectionProfile] ADD CONSTRAINT [DF_ConnectionProfile_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_ConnectionProfileID] DEFAULT ((0)) FOR [ConnectionProfileID] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[ConnectionProfileTask] ADD CONSTRAINT [DF_ConnectionProfileTask_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_MaxThreadCount] DEFAULT ((0)) FOR [MaxThreadCount] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_UseBackgroundThreads] DEFAULT ((0)) FOR [UseBackgroundThreads] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[ConnectionProfileTaskQueue] ADD CONSTRAINT [DF_ConnectionProfileTaskQueue_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[CustomActionAdapter] ADD CONSTRAINT [DF_CustomActionAdapter_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[CustomInputAdapter] ADD CONSTRAINT [DF_CustomInputAdapter_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[CustomOutputAdapter] ADD CONSTRAINT [DF_CustomOutputAdapter_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_UniqueID] DEFAULT (newid()) FOR [UniqueID] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_IsConcentrator] DEFAULT ((0)) FOR [IsConcentrator] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_AccessID] DEFAULT ((0)) FOR [AccessID] GO ALTER TABLE [dbo].[Device] ADD DEFAULT ((30)) FOR [FramesPerSecond] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_TimeAdjustmentTicks] DEFAULT ((0)) FOR [TimeAdjustmentTicks] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_DataLossInterval] DEFAULT ((5)) FOR [DataLossInterval] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_AllowedParsingExceptions] DEFAULT ((10)) FOR [AllowedParsingExceptions] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_ParsingExceptionWindow] DEFAULT ((5)) FOR [ParsingExceptionWindow] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_DelayedConnectionInterval] DEFAULT ((5)) FOR [DelayedConnectionInterval] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_AllowUseOfCachedConfiguration] DEFAULT ((1)) FOR [AllowUseOfCachedConfiguration] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_AutoStartDataParsingSequence] DEFAULT ((1)) FOR [AutoStartDataParsingSequence] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_SkipDisableRealTimeData] DEFAULT ((0)) FOR [SkipDisableRealTimeData] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_MeasurementReportingInterval] DEFAULT ((100000)) FOR [MeasurementReportingInterval] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_ConnectOnDemand] DEFAULT ((1)) FOR [ConnectOnDemand] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[Device] ADD CONSTRAINT [DF_Device_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[ErrorLog] ADD CONSTRAINT [DF_ErrorLog_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[ImportedMeasurement] ADD CONSTRAINT [DF_ImportedMeasurement_ProtocolType] DEFAULT ('Frame') FOR [ProtocolType] GO ALTER TABLE [dbo].[ImportedMeasurement] ADD CONSTRAINT [DF_ImportedMeasurement_Adder] DEFAULT ((0.0)) FOR [Adder] GO ALTER TABLE [dbo].[ImportedMeasurement] ADD CONSTRAINT [DF_ImportedMeasurement_Multiplier] DEFAULT ((1.0)) FOR [Multiplier] GO ALTER TABLE [dbo].[ImportedMeasurement] ADD CONSTRAINT [DF_ImportedMeasurement_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_SignalID] DEFAULT (newid()) FOR [SignalID] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_Adder] DEFAULT ((0.0)) FOR [Adder] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_Multiplier] DEFAULT ((1.0)) FOR [Multiplier] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_Internal] DEFAULT ((1)) FOR [Internal] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_Subscribed] DEFAULT ((0)) FOR [Subscribed] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[Measurement] ADD CONSTRAINT [DF_Measurement_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] ADD CONSTRAINT [DF_MeasurementGroupMeasurement_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] ADD CONSTRAINT [DF_MeasurementGroupMeasurement_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] ADD CONSTRAINT [DF_MeasurementGroupMeasurement_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] ADD CONSTRAINT [DF_MeasurementGroupMeasurement_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevices_IsConcentrator] DEFAULT ((0)) FOR [IsConcentrator] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevices_Planned] DEFAULT ((0)) FOR [Planned] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevices_Desired] DEFAULT ((0)) FOR [Desired] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevices_InProgress] DEFAULT ((0)) FOR [InProgress] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevice_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevice_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevice_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OtherDevice] ADD CONSTRAINT [DF_OtherDevice_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_Type] DEFAULT ((0)) FOR [Type] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_IDCode] DEFAULT ((0)) FOR [IDCode] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_AutoPublishConfigFrame] DEFAULT ((0)) FOR [AutoPublishConfigFrame] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_AutoStartDataChannel] DEFAULT ((1)) FOR [AutoStartDataChannel] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_NominalFrequency] DEFAULT ((60)) FOR [NominalFrequency] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_FramesPerSecond] DEFAULT ((30)) FOR [FramesPerSecond] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_LagTime] DEFAULT ((3.0)) FOR [LagTime] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_LeadTime] DEFAULT ((1.0)) FOR [LeadTime] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_UseLocalClockAsRealTime] DEFAULT ((0)) FOR [UseLocalClockAsRealTime] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_AllowSortsByArrival] DEFAULT ((1)) FOR [AllowSortsByArrival] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_IgnoreBadTimeStamps] DEFAULT ((0)) FOR [IgnoreBadTimeStamps] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_TimeResolution] DEFAULT ((330000)) FOR [TimeResolution] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_AllowPreemptivePublishing] DEFAULT ((1)) FOR [AllowPreemptivePublishing] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_PerformTimestampReasonabilityCheck] DEFAULT ((1)) FOR [PerformTimeReasonabilityCheck] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_DownsamplingMethod] DEFAULT (N'LastReceived') FOR [DownsamplingMethod] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_DataFormat] DEFAULT (N'FloatingPoint') FOR [DataFormat] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_CoordinateFormat] DEFAULT (N'Polar') FOR [CoordinateFormat] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_CurrentScalingValue] DEFAULT ((2423)) FOR [CurrentScalingValue] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_VoltageScalingValue] DEFAULT ((2725785)) FOR [VoltageScalingValue] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_AnalogScalingValue] DEFAULT ((1373291)) FOR [AnalogScalingValue] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_DigitMaskValue] DEFAULT ((-65536)) FOR [DigitalMaskValue] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStream] ADD CONSTRAINT [DF_OutputStream_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevices_IDCode] DEFAULT ((0)) FOR [IDCode] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevices_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevices_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevice_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevice_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevice_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStreamDevice] ADD CONSTRAINT [DF_OutputStreamDevice_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_Type] DEFAULT ((0)) FOR [Type] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_ScalingValue] DEFAULT ((0)) FOR [ScalingValue] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] ADD CONSTRAINT [DF_OutputStreamDeviceAnalog_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_MaskValue] DEFAULT ((0)) FOR [MaskValue] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] ADD CONSTRAINT [DF_OutputStreamDeviceDigital_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_Type] DEFAULT (N'V') FOR [Type] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_Phase] DEFAULT (N'+') FOR [Phase] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_ScalingValue] DEFAULT ((0)) FOR [ScalingValue] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_LoadOrder] DEFAULT ((0)) FOR [LoadOrder] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] ADD CONSTRAINT [DF_OutputStreamDevicePhasor_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[OutputStreamMeasurement] ADD CONSTRAINT [DF_OutputStreamMeasurement_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[OutputStreamMeasurement] ADD CONSTRAINT [DF_OutputStreamMeasurement_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[OutputStreamMeasurement] ADD CONSTRAINT [DF_OutputStreamMeasurement_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[OutputStreamMeasurement] ADD CONSTRAINT [DF_OutputStreamMeasurement_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_Type] DEFAULT (N'V') FOR [Type] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_Phase] DEFAULT (N'+') FOR [Phase] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_SourceIndex] DEFAULT ((0)) FOR [SourceIndex] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[Phasor] ADD CONSTRAINT [DF_Phasor_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[SecurityGroup] ADD CONSTRAINT [DF_SecurityGroup_ID] DEFAULT (newid()) FOR [ID] GO ALTER TABLE [dbo].[SecurityGroup] ADD CONSTRAINT [DF_SecurityGroup_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[SecurityGroup] ADD CONSTRAINT [DF_SecurityGroup_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[SecurityGroup] ADD CONSTRAINT [DF_SecurityGroup_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[SecurityGroup] ADD CONSTRAINT [DF_SecurityGroup_UpdatedBy] DEFAULT (getutcdate()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_ID] DEFAULT (newid()) FOR [ID] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_Enabled] DEFAULT ((0)) FOR [Enabled] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[Subscriber] ADD CONSTRAINT [DF_Subscriber_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[SubscriberMeasurement] ADD CONSTRAINT [DF_SubscriberMeasurement_Allowed] DEFAULT ((0)) FOR [Allowed] GO ALTER TABLE [dbo].[SubscriberMeasurement] ADD CONSTRAINT [DF_SubscriberMeasurement_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[SubscriberMeasurement] ADD CONSTRAINT [DF_SubscriberMeasurement_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[SubscriberMeasurement] ADD CONSTRAINT [DF_SubscriberMeasurement_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[SubscriberMeasurement] ADD CONSTRAINT [DF_SubscriberMeasurement_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] ADD CONSTRAINT [DF_SubscriberMeasurementGroup_Allowed] DEFAULT ((0)) FOR [Allowed] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] ADD CONSTRAINT [DF_SubscriberMeasurementGroup_CreatedOn] DEFAULT (getutcdate()) FOR [CreatedOn] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] ADD CONSTRAINT [DF_SubscriberMeasurementGroup_CreatedBy] DEFAULT (suser_name()) FOR [CreatedBy] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] ADD CONSTRAINT [DF_SubscriberMeasurementGroup_UpdatedOn] DEFAULT (getutcdate()) FOR [UpdatedOn] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] ADD CONSTRAINT [DF_SubscriberMeasurementGroup_UpdatedBy] DEFAULT (suser_name()) FOR [UpdatedBy] GO ALTER TABLE [dbo].[Alarm] WITH CHECK ADD CONSTRAINT [FK_Alarm_Measurement_AssociatedMeasurementID] FOREIGN KEY([SignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[Alarm] CHECK CONSTRAINT [FK_Alarm_Measurement_AssociatedMeasurementID] GO ALTER TABLE [dbo].[Alarm] WITH CHECK ADD CONSTRAINT [FK_Alarm_Measurement_SignalID] FOREIGN KEY([SignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[Alarm] CHECK CONSTRAINT [FK_Alarm_Measurement_SignalID] GO ALTER TABLE [dbo].[Alarm] WITH CHECK ADD CONSTRAINT [FK_Alarm_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[Alarm] CHECK CONSTRAINT [FK_Alarm_Node] GO ALTER TABLE [dbo].[AlarmLog] WITH CHECK ADD CONSTRAINT [FK_AlarmLog_Alarm_NewState] FOREIGN KEY([NewState]) REFERENCES [dbo].[Alarm] ([ID]) GO ALTER TABLE [dbo].[AlarmLog] CHECK CONSTRAINT [FK_AlarmLog_Alarm_NewState] GO ALTER TABLE [dbo].[AlarmLog] WITH CHECK ADD CONSTRAINT [FK_AlarmLog_Alarm_PreviousState] FOREIGN KEY([PreviousState]) REFERENCES [dbo].[Alarm] ([ID]) GO ALTER TABLE [dbo].[AlarmLog] CHECK CONSTRAINT [FK_AlarmLog_Alarm_PreviousState] GO ALTER TABLE [dbo].[AlarmLog] WITH CHECK ADD CONSTRAINT [FK_AlarmLog_Measurement] FOREIGN KEY([SignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[AlarmLog] CHECK CONSTRAINT [FK_AlarmLog_Measurement] GO ALTER TABLE [dbo].[ApplicationRole] WITH CHECK ADD CONSTRAINT [FK_ApplicationRole_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ApplicationRole] CHECK CONSTRAINT [FK_ApplicationRole_Node] GO ALTER TABLE [dbo].[ApplicationRoleSecurityGroup] WITH CHECK ADD CONSTRAINT [FK_ApplicationRoleSecurityGroup_ApplicationRole] FOREIGN KEY([ApplicationRoleID]) REFERENCES [dbo].[ApplicationRole] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ApplicationRoleSecurityGroup] CHECK CONSTRAINT [FK_ApplicationRoleSecurityGroup_ApplicationRole] GO ALTER TABLE [dbo].[ApplicationRoleSecurityGroup] WITH CHECK ADD CONSTRAINT [FK_ApplicationRoleSecurityGroup_SecurityGroup] FOREIGN KEY([SecurityGroupID]) REFERENCES [dbo].[SecurityGroup] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ApplicationRoleSecurityGroup] CHECK CONSTRAINT [FK_ApplicationRoleSecurityGroup_SecurityGroup] GO ALTER TABLE [dbo].[ApplicationRoleUserAccount] WITH CHECK ADD CONSTRAINT [FK_ApplicationRoleUserAccount_ApplicationRole] FOREIGN KEY([ApplicationRoleID]) REFERENCES [dbo].[ApplicationRole] ([ID]) GO ALTER TABLE [dbo].[ApplicationRoleUserAccount] CHECK CONSTRAINT [FK_ApplicationRoleUserAccount_ApplicationRole] GO ALTER TABLE [dbo].[ApplicationRoleUserAccount] WITH CHECK ADD CONSTRAINT [FK_ApplicationRoleUserAccount_UserAccount] FOREIGN KEY([UserAccountID]) REFERENCES [dbo].[UserAccount] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ApplicationRoleUserAccount] CHECK CONSTRAINT [FK_ApplicationRoleUserAccount_UserAccount] GO ALTER TABLE [dbo].[CalculatedMeasurement] WITH CHECK ADD CONSTRAINT [FK_CalculatedMeasurement_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CalculatedMeasurement] CHECK CONSTRAINT [FK_CalculatedMeasurement_Node] GO ALTER TABLE [dbo].[ConnectionProfile] WITH CHECK ADD CONSTRAINT [FK_ConnectionProfile_ConnectionProfileTaskQueue] FOREIGN KEY([DefaultTaskQueueID]) REFERENCES [dbo].[ConnectionProfileTaskQueue] ([ID]) GO ALTER TABLE [dbo].[ConnectionProfile] CHECK CONSTRAINT [FK_ConnectionProfile_ConnectionProfileTaskQueue] GO ALTER TABLE [dbo].[ConnectionProfileTask] WITH CHECK ADD CONSTRAINT [FK_ConnectionProfileTask_ConnectionProfile] FOREIGN KEY([ConnectionProfileID]) REFERENCES [dbo].[ConnectionProfile] ([ID]) GO ALTER TABLE [dbo].[ConnectionProfileTask] CHECK CONSTRAINT [FK_ConnectionProfileTask_ConnectionProfile] GO ALTER TABLE [dbo].[CustomActionAdapter] WITH CHECK ADD CONSTRAINT [FK_CustomActionAdapter_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CustomActionAdapter] CHECK CONSTRAINT [FK_CustomActionAdapter_Node] GO ALTER TABLE [dbo].[CustomInputAdapter] WITH CHECK ADD CONSTRAINT [FK_CustomInputAdapter_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CustomInputAdapter] CHECK CONSTRAINT [FK_CustomInputAdapter_Node] GO ALTER TABLE [dbo].[CustomOutputAdapter] WITH CHECK ADD CONSTRAINT [FK_CustomOutputAdapter_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[CustomOutputAdapter] CHECK CONSTRAINT [FK_CustomOutputAdapter_Node] GO ALTER TABLE [dbo].[DataOperation] WITH CHECK ADD CONSTRAINT [FK_DataOperation_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[DataOperation] CHECK CONSTRAINT [FK_DataOperation_Node] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_Company] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Company] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_Company] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_Device] FOREIGN KEY([ParentID]) REFERENCES [dbo].[Device] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_Device] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_Interconnection] FOREIGN KEY([InterconnectionID]) REFERENCES [dbo].[Interconnection] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_Interconnection] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_Node] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_Protocol] FOREIGN KEY([ProtocolID]) REFERENCES [dbo].[Protocol] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_Protocol] GO ALTER TABLE [dbo].[Device] WITH CHECK ADD CONSTRAINT [FK_Device_VendorDevice] FOREIGN KEY([VendorDeviceID]) REFERENCES [dbo].[VendorDevice] ([ID]) GO ALTER TABLE [dbo].[Device] CHECK CONSTRAINT [FK_Device_VendorDevice] GO ALTER TABLE [dbo].[Historian] WITH CHECK ADD CONSTRAINT [FK_Historian_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[Historian] CHECK CONSTRAINT [FK_Historian_Node] GO ALTER TABLE [dbo].[ImportedMeasurement] WITH CHECK ADD CONSTRAINT [FK_ImportedMeasurement_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[ImportedMeasurement] CHECK CONSTRAINT [FK_ImportedMeasurement_Node] GO ALTER TABLE [dbo].[Measurement] WITH CHECK ADD CONSTRAINT [FK_Measurement_Device] FOREIGN KEY([DeviceID]) REFERENCES [dbo].[Device] ([ID]) GO ALTER TABLE [dbo].[Measurement] CHECK CONSTRAINT [FK_Measurement_Device] GO ALTER TABLE [dbo].[Measurement] WITH CHECK ADD CONSTRAINT [FK_Measurement_SignalType] FOREIGN KEY([SignalTypeID]) REFERENCES [dbo].[SignalType] ([ID]) GO ALTER TABLE [dbo].[Measurement] CHECK CONSTRAINT [FK_Measurement_SignalType] GO ALTER TABLE [dbo].[MeasurementGroup] WITH CHECK ADD CONSTRAINT [FK_MeasurementGroup_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[MeasurementGroup] CHECK CONSTRAINT [FK_MeasurementGroup_Node] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] WITH CHECK ADD CONSTRAINT [FK_MeasurementGroupMeasurement_Measurement] FOREIGN KEY([SignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] CHECK CONSTRAINT [FK_MeasurementGroupMeasurement_Measurement] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] WITH CHECK ADD CONSTRAINT [FK_MeasurementGroupMeasurement_MeasurementGroup] FOREIGN KEY([MeasurementGroupID]) REFERENCES [dbo].[MeasurementGroup] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] CHECK CONSTRAINT [FK_MeasurementGroupMeasurement_MeasurementGroup] GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] WITH CHECK ADD CONSTRAINT [FK_MeasurementGroupMeasurement_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[MeasurementGroupMeasurement] CHECK CONSTRAINT [FK_MeasurementGroupMeasurement_Node] GO ALTER TABLE [dbo].[Node] WITH CHECK ADD CONSTRAINT [FK_Node_Company] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Company] ([ID]) GO ALTER TABLE [dbo].[Node] CHECK CONSTRAINT [FK_Node_Company] GO ALTER TABLE [dbo].[OtherDevice] WITH CHECK ADD CONSTRAINT [FK_OtherDevice_Company] FOREIGN KEY([CompanyID]) REFERENCES [dbo].[Company] ([ID]) GO ALTER TABLE [dbo].[OtherDevice] CHECK CONSTRAINT [FK_OtherDevice_Company] GO ALTER TABLE [dbo].[OtherDevice] WITH CHECK ADD CONSTRAINT [FK_OtherDevice_Interconnection] FOREIGN KEY([InterconnectionID]) REFERENCES [dbo].[Interconnection] ([ID]) GO ALTER TABLE [dbo].[OtherDevice] CHECK CONSTRAINT [FK_OtherDevice_Interconnection] GO ALTER TABLE [dbo].[OtherDevice] WITH CHECK ADD CONSTRAINT [FK_OtherDevice_VendorDevice] FOREIGN KEY([VendorDeviceID]) REFERENCES [dbo].[VendorDevice] ([ID]) GO ALTER TABLE [dbo].[OtherDevice] CHECK CONSTRAINT [FK_OtherDevice_VendorDevice] GO ALTER TABLE [dbo].[OutputStream] WITH CHECK ADD CONSTRAINT [FK_OutputStream_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStream] CHECK CONSTRAINT [FK_OutputStream_Node] GO ALTER TABLE [dbo].[OutputStreamDevice] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDevice_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[OutputStreamDevice] CHECK CONSTRAINT [FK_OutputStreamDevice_Node] GO ALTER TABLE [dbo].[OutputStreamDevice] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDevice_OutputStream] FOREIGN KEY([AdapterID]) REFERENCES [dbo].[OutputStream] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStreamDevice] CHECK CONSTRAINT [FK_OutputStreamDevice_OutputStream] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDeviceAnalog_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] CHECK CONSTRAINT [FK_OutputStreamDeviceAnalog_Node] GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDeviceAnalog_OutputStreamDevice] FOREIGN KEY([OutputStreamDeviceID]) REFERENCES [dbo].[OutputStreamDevice] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStreamDeviceAnalog] CHECK CONSTRAINT [FK_OutputStreamDeviceAnalog_OutputStreamDevice] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDeviceDigital_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] CHECK CONSTRAINT [FK_OutputStreamDeviceDigital_Node] GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDeviceDigital_OutputStreamDevice] FOREIGN KEY([OutputStreamDeviceID]) REFERENCES [dbo].[OutputStreamDevice] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStreamDeviceDigital] CHECK CONSTRAINT [FK_OutputStreamDeviceDigital_OutputStreamDevice] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDevicePhasor_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] CHECK CONSTRAINT [FK_OutputStreamDevicePhasor_Node] GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] WITH CHECK ADD CONSTRAINT [FK_OutputStreamDevicePhasor_OutputStreamDevice] FOREIGN KEY([OutputStreamDeviceID]) REFERENCES [dbo].[OutputStreamDevice] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStreamDevicePhasor] CHECK CONSTRAINT [FK_OutputStreamDevicePhasor_OutputStreamDevice] GO ALTER TABLE [dbo].[OutputStreamMeasurement] WITH CHECK ADD CONSTRAINT [FK_OutputStreamMeasurement_Historian] FOREIGN KEY([HistorianID]) REFERENCES [dbo].[Historian] ([ID]) GO ALTER TABLE [dbo].[OutputStreamMeasurement] CHECK CONSTRAINT [FK_OutputStreamMeasurement_Historian] GO ALTER TABLE [dbo].[OutputStreamMeasurement] WITH CHECK ADD CONSTRAINT [FK_OutputStreamMeasurement_Measurement] FOREIGN KEY([PointID]) REFERENCES [dbo].[Measurement] ([PointID]) GO ALTER TABLE [dbo].[OutputStreamMeasurement] CHECK CONSTRAINT [FK_OutputStreamMeasurement_Measurement] GO ALTER TABLE [dbo].[OutputStreamMeasurement] WITH CHECK ADD CONSTRAINT [FK_OutputStreamMeasurement_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[OutputStreamMeasurement] CHECK CONSTRAINT [FK_OutputStreamMeasurement_Node] GO ALTER TABLE [dbo].[OutputStreamMeasurement] WITH CHECK ADD CONSTRAINT [FK_OutputStreamMeasurement_OutputStream] FOREIGN KEY([AdapterID]) REFERENCES [dbo].[OutputStream] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[OutputStreamMeasurement] CHECK CONSTRAINT [FK_OutputStreamMeasurement_OutputStream] GO ALTER TABLE [dbo].[Phasor] WITH CHECK ADD CONSTRAINT [FK_Phasor_Device] FOREIGN KEY([DeviceID]) REFERENCES [dbo].[Device] ([ID]) ON DELETE CASCADE GO ALTER TABLE [dbo].[Phasor] CHECK CONSTRAINT [FK_Phasor_Device] GO ALTER TABLE [dbo].[Phasor] WITH CHECK ADD CONSTRAINT [FK_Phasor_Phasor] FOREIGN KEY([DestinationPhasorID]) REFERENCES [dbo].[Phasor] ([ID]) GO ALTER TABLE [dbo].[Phasor] CHECK CONSTRAINT [FK_Phasor_Phasor] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement1] FOREIGN KEY([ApparentPowerOutputSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement1] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement2] FOREIGN KEY([CurrentAngleSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement2] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement3] FOREIGN KEY([CurrentMagSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement3] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement4] FOREIGN KEY([ReactivePowerOutputSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement4] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement5] FOREIGN KEY([ActivePowerOutputSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement5] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement6] FOREIGN KEY([VoltageAngleSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement6] GO ALTER TABLE [dbo].[PowerCalculation] WITH CHECK ADD CONSTRAINT [FK_PowerCalculation_Measurement7] FOREIGN KEY([VoltageMagSignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[PowerCalculation] CHECK CONSTRAINT [FK_PowerCalculation_Measurement7] GO ALTER TABLE [dbo].[SecurityGroupUserAccount] WITH CHECK ADD CONSTRAINT [FK_SecurityGroupUserAccount_SecurityGroup] FOREIGN KEY([SecurityGroupID]) REFERENCES [dbo].[SecurityGroup] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[SecurityGroupUserAccount] CHECK CONSTRAINT [FK_SecurityGroupUserAccount_SecurityGroup] GO ALTER TABLE [dbo].[SecurityGroupUserAccount] WITH CHECK ADD CONSTRAINT [FK_SecurityGroupUserAccount_UserAccount] FOREIGN KEY([UserAccountID]) REFERENCES [dbo].[UserAccount] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[SecurityGroupUserAccount] CHECK CONSTRAINT [FK_SecurityGroupUserAccount_UserAccount] GO ALTER TABLE [dbo].[Subscriber] WITH CHECK ADD CONSTRAINT [FK_Subscriber_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[Subscriber] CHECK CONSTRAINT [FK_Subscriber_Node] GO ALTER TABLE [dbo].[SubscriberMeasurement] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurement_Measurement] FOREIGN KEY([SignalID]) REFERENCES [dbo].[Measurement] ([SignalID]) GO ALTER TABLE [dbo].[SubscriberMeasurement] CHECK CONSTRAINT [FK_SubscriberMeasurement_Measurement] GO ALTER TABLE [dbo].[SubscriberMeasurement] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurement_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[SubscriberMeasurement] CHECK CONSTRAINT [FK_SubscriberMeasurement_Node] GO ALTER TABLE [dbo].[SubscriberMeasurement] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurement_Subscriber] FOREIGN KEY([SubscriberID]) REFERENCES [dbo].[Subscriber] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[SubscriberMeasurement] CHECK CONSTRAINT [FK_SubscriberMeasurement_Subscriber] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurementGroup_MeasurementGroup] FOREIGN KEY([MeasurementGroupID]) REFERENCES [dbo].[MeasurementGroup] ([ID]) GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] CHECK CONSTRAINT [FK_SubscriberMeasurementGroup_MeasurementGroup] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurementGroup_Node] FOREIGN KEY([NodeID]) REFERENCES [dbo].[Node] ([ID]) GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] CHECK CONSTRAINT [FK_SubscriberMeasurementGroup_Node] GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] WITH CHECK ADD CONSTRAINT [FK_SubscriberMeasurementGroup_Subscriber] FOREIGN KEY([SubscriberID]) REFERENCES [dbo].[Subscriber] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[SubscriberMeasurementGroup] CHECK CONSTRAINT [FK_SubscriberMeasurementGroup_Subscriber] GO ALTER TABLE [dbo].[UserAccount] WITH CHECK ADD CONSTRAINT [FK_UserAccount_Node] FOREIGN KEY([DefaultNodeID]) REFERENCES [dbo].[Node] ([ID]) ON UPDATE CASCADE ON DELETE CASCADE GO ALTER TABLE [dbo].[UserAccount] CHECK CONSTRAINT [FK_UserAccount_Node] GO ALTER TABLE [dbo].[VendorDevice] WITH CHECK ADD CONSTRAINT [FK_VendorDevice_Vendor] FOREIGN KEY([VendorID]) REFERENCES [dbo].[Vendor] ([ID]) GO ALTER TABLE [dbo].[VendorDevice] CHECK CONSTRAINT [FK_VendorDevice_Vendor] GO