2449 lines
305 KiB
PL/PgSQL
2449 lines
305 KiB
PL/PgSQL
/**
|
||
* script 2016-11-10
|
||
*/
|
||
DECLARE @db_id int;
|
||
USE [master]
|
||
SET @db_id = DB_ID(N'DataPRO');
|
||
IF @db_id IS NOT NULL
|
||
BEGIN;
|
||
PRINT 'clearing existing db';
|
||
USE [master];
|
||
DROP DATABASE [DataPRO];
|
||
END;
|
||
ELSE
|
||
BEGIN
|
||
PRINT 'database not found, skipping db drop';
|
||
END
|
||
|
||
PRINT 'creating database';
|
||
CREATE DATABASE [DataPRO]
|
||
ALTER DATABASE [DataPRO] MODIFY FILE
|
||
( NAME = N'DataPRO', MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
|
||
GO
|
||
ALTER DATABASE [DataPRO] MODIFY FILE
|
||
( NAME = N'DataPRO_log', MAXSIZE = 2048GB , FILEGROWTH = 10%)
|
||
|
||
ALTER DATABASE [DataPRO] SET COMPATIBILITY_LEVEL = 100
|
||
GO
|
||
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
|
||
begin
|
||
EXEC [DataPRO].[dbo].[sp_fulltext_database] @action = 'enable'
|
||
end
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ANSI_NULL_DEFAULT OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ANSI_NULLS OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ANSI_PADDING OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ANSI_WARNINGS OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ARITHABORT OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET AUTO_CLOSE OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET AUTO_CREATE_STATISTICS ON
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET AUTO_SHRINK OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET AUTO_UPDATE_STATISTICS ON
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET CURSOR_CLOSE_ON_COMMIT OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET CURSOR_DEFAULT GLOBAL
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET CONCAT_NULL_YIELDS_NULL OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET NUMERIC_ROUNDABORT OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET QUOTED_IDENTIFIER OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET RECURSIVE_TRIGGERS OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET DISABLE_BROKER
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET DATE_CORRELATION_OPTIMIZATION OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET TRUSTWORTHY OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET ALLOW_SNAPSHOT_ISOLATION OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET PARAMETERIZATION SIMPLE
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET READ_COMMITTED_SNAPSHOT OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET HONOR_BROKER_PRIORITY OFF
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET RECOVERY SIMPLE
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET MULTI_USER
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET PAGE_VERIFY CHECKSUM
|
||
GO
|
||
ALTER DATABASE [DataPRO] SET DB_CHAINING OFF
|
||
GO
|
||
USE [DataPRO]
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblCustomerDetails] Script Date: 1/21/2016 8:27:58 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblCustomerDetails](
|
||
[Name] [nvarchar](255) NOT NULL,
|
||
[CustomerName] [nvarchar](255) NULL,
|
||
[CustomerTestRefNumber] [nvarchar](255) NULL,
|
||
[ProjectRefNumber] [nvarchar](255) NULL,
|
||
[CustomerOrderNumber] [nvarchar](255) NULL,
|
||
[CustomerCostUnit] [nvarchar](255) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[LastModified] [datetime] NULL,
|
||
[LastModifiedBy] [nvarchar](50) NULL,
|
||
[Version] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[Name] 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].[tblTags] Script Date: 3/18/2016 8:27:58 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTags](
|
||
[TagId] [int] IDENTITY(1,1) NOT NULL,
|
||
[TagText] [nvarchar](255) NOT NULL,
|
||
[Obsolete] [bit] NOT NULL,
|
||
[DbTimeStamp] [timestamp] NULL,
|
||
CONSTRAINT [PK_tblTags] PRIMARY KEY CLUSTERED
|
||
(
|
||
[TagId] 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
|
||
|
||
CREATE TABLE [dbo].[TagAssignments](
|
||
[ObjectID] [int] NOT NULL,
|
||
[ObjectType] [smallint] NOT NULL,
|
||
[TagID] [int] NOT NULL,
|
||
CONSTRAINT [IX_TagAssignments] UNIQUE NONCLUSTERED
|
||
(
|
||
[ObjectID] ASC,
|
||
[ObjectType] ASC,
|
||
[TagID] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[TagAssignments] WITH CHECK ADD CONSTRAINT [FK_TagAssignments_tblTags] FOREIGN KEY([TagID])
|
||
REFERENCES [dbo].[tblTags] ([TagId])
|
||
GO
|
||
ALTER TABLE [dbo].[TagAssignments] CHECK CONSTRAINT [FK_TagAssignments_tblTags]
|
||
GO
|
||
|
||
|
||
/****** Object: Table [dbo].[tblTestEngineerDetails] Script Date: 3/11/2016 4:18:58 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestEngineerDetails](
|
||
[Name] [nvarchar](255) NOT NULL,
|
||
[TestEngineerName] [nvarchar](255) NULL,
|
||
[TestEngineerPhone] [nvarchar](255) NULL,
|
||
[TestEngineerFax] [nvarchar](255) NULL,
|
||
[TestEngineerEmail] [nvarchar](255) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[LastModified] [datetime] NULL,
|
||
[LastModifiedBy] [nvarchar](50) NULL,
|
||
[Version] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[Name] 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
|
||
|
||
GO
|
||
/****** Object: Table [dbo].[tblDAS] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblDAS](
|
||
[SerialNumber] [nvarchar](50) NOT NULL,
|
||
[Type] [int] NOT NULL,
|
||
[MaxModules] [int] NULL,
|
||
[MaxMemory] [bigint] NULL,
|
||
[MaxSampleRate] [decimal](18, 0) NULL,
|
||
[MinSampleRate] [decimal](18, 0) NULL,
|
||
[FirmwareVersion] [nvarchar](50) NULL,
|
||
[CalDate] [datetime] NULL,
|
||
[ProtocolVersion] [int] NULL,
|
||
[LastModified] [datetime] NULL,
|
||
[LastModifiedBy] [nvarchar](50) NULL,
|
||
[Version] [int] NOT NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[LastUsed] [datetime] NULL,
|
||
[LastUsedBy] [nvarchar](50) NULL,
|
||
[Connection] [nvarchar](50) NULL,
|
||
[Channels] [int] NULL,
|
||
[Position] [nvarchar](50) NOT NULL,
|
||
[ChannelTypes] [nvarchar](255),
|
||
[Reprogramable] [bit] NOT NULL,
|
||
[Reconfigurable] [bit] NOT NULL,
|
||
[IsModule] [bit],
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[PositionOnDistributor] [smallint] NULL,
|
||
[PositionOnChain] [smallint] NULL,
|
||
[Port] [smallint] NULL,
|
||
[ParentDAS] [nvarchar](50) NULL
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblDASChannels] Script Date: 1/21/2016 8:29:58 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblDASChannels](
|
||
[HardwareId] [nvarchar](50) NULL,
|
||
[ChannelIdx] [int] NULL,
|
||
[SupportedBridges] [int] NULL,
|
||
[SupportedExcitations] [int] NULL,
|
||
[DASDisplayOrder] [int] NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[SupportedDigitalInputModes] [int] NULL,
|
||
[SupportedSquibFireModes] [int] NULL,
|
||
[SupportedDigitalOutputModes] [int] NULL,
|
||
[ModuleSerialNumber] [nvarchar](16) NULL,
|
||
[ModuleArrayIndex] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblDataPRODbVersion] Script Date: 1/21/2016 8:30:49 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblDataPRODbVersion](
|
||
[Version] [int] NOT NULL,
|
||
[Step] [int] NOT NULL,
|
||
[Date] [datetime] NOT NULL,
|
||
[Remarks] [text] NULL, /*To prevent TEXTIMAGE_ON error */
|
||
[UserField] [text] NULL /*To prevent TEXTIMAGE_ON error */
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[Version] ASC,
|
||
[Step] 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].[tblDbTableVersions] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
SET ANSI_PADDING ON
|
||
CREATE TABLE [dbo].[tblDbTableVersions](
|
||
[DatabaseTable] [varchar](50) NOT NULL,
|
||
[ProtocolVersion] [int] NOT NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[DatabaseTable] 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].[tblDigitalInputSetting] Script Date: 1/21/2016 8:31:48 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblDigitalInputSetting](
|
||
[SettingName] [nvarchar](50) NOT NULL,
|
||
[SettingMode] [int] NOT NULL,
|
||
[ScaleMultiplier] [nvarchar](50) NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[SensorId] [nvarchar](50) NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[UserValue1] [nvarchar](255) NULL,
|
||
[UserValue2] [nvarchar](255) NULL,
|
||
[UserValue3] [nvarchar](255) NULL,
|
||
[UserTags] [varbinary](MAX) NULL
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[SettingName] 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].[tblLabratoryDetails] Script Date: 1/21/2016 8:32:35 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblLabratoryDetails](
|
||
[Name] [nvarchar](255) NOT NULL,
|
||
[LabratoryName] [nvarchar](255) NULL,
|
||
[LabratoryContactName] [nvarchar](255) NULL,
|
||
[LabratoryContactPhone] [nvarchar](255) NULL,
|
||
[LabratoryContactFax] [nvarchar](255) NULL,
|
||
[LabratoryContactEmail] [nvarchar](255) NULL,
|
||
[LabratoryTestRefNumber] [nvarchar](255) NULL,
|
||
[LabratoryProjectRefNumber] [nvarchar](255) NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[Version] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[Name] 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].[tblMMEDirections] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEDirections](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[DIRECTION] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[DATE] [datetime] NULL,
|
||
[VERSION] [int] NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEFilterClasses] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEFilterClasses](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[FILTER_CLASS] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEFineLocations1] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEFineLocations1](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[FINE_LOC_1] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEFineLocations2] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEFineLocations2](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[FINE_LOC_2] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEFineLocations3] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEFineLocations3](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[FINE_LOC_3] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[PICTURE_SHORTNAME] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEMainLocations] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEMainLocations](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[TYPE] [nvarchar](50) NULL,
|
||
[TRANS_MAIN_LOC] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[PICTURE_SHORTNAME] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEPhysicalDimensions] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEPhysicalDimensions](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[PHYSICAL_DIMENSION] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[DEFAULT_UNIT] [nvarchar](50) NULL,
|
||
[LENGTH_EXP] [int] NULL,
|
||
[TIME_EXP] [int] NULL,
|
||
[MASS_EXP] [int] NULL,
|
||
[ELECTRIC_CURRENT_EXP] [int] NULL,
|
||
[TEMPERATURE_EXP] [int] NULL,
|
||
[LUMINOUS_INTENSITY_EXP] [int] NULL,
|
||
[AMOUNT_OFSUBSTANCE_EXP] [int] NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEPositions] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEPositions](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[POSITION] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblMMEPossibleChannels] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMEPossibleChannels](
|
||
[ID] [bigint] IDENTITY(1,1) NOT NULL,
|
||
[TYPE] [nvarchar](50) NULL,
|
||
[TEST_OBJECT] [nvarchar](50) NULL,
|
||
[POSITION] [nvarchar](50) NULL,
|
||
[TRANS_MAIN_LOC] [nvarchar](50) NULL,
|
||
[FINE_LOC_1] [nvarchar](50) NULL,
|
||
[FINE_LOC_2] [nvarchar](50) NULL,
|
||
[FINE_LOC_3] [nvarchar](50) NULL,
|
||
[PHYSICAL_DIMENSION] [nvarchar](50) NULL,
|
||
[DIRECTION] [nvarchar](50) NULL,
|
||
[DEFAULT_FILTER_CLASS] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](100) NULL,
|
||
[TEXT_L2] [nvarchar](100) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[PICTURE_SHORTNAME] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
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].[tblMMETestObjects] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblMMETestObjects](
|
||
[s_GUID] [nvarchar](50) NOT NULL,
|
||
[TEST_OBJECT] [nvarchar](50) NULL,
|
||
[TEXT_L1] [nvarchar](50) NULL,
|
||
[TEXT_L2] [nvarchar](50) NULL,
|
||
[VERSION] [int] NULL,
|
||
[DATE] [datetime] NULL,
|
||
[REMARKS] [nvarchar](50) NULL,
|
||
[EXPIRED] [bit] NULL,
|
||
[SORTKEY] [nvarchar](50) NULL,
|
||
[LAST_CHANGE] [datetime] NULL,
|
||
[LAST_CHANGE_TEXT] [nvarchar](50) NULL,
|
||
[HISTORY] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[s_GUID] 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].[tblSensorCalibrations] Script Date: 1/21/2016 8:38:31 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblSensorCalibrations](
|
||
[SerialNumber] [nvarchar](50) NOT NULL,
|
||
[CalibrationDate] [datetime] NOT NULL,
|
||
[Username] [nvarchar](50) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[NonLinear] [bit] NOT NULL,
|
||
[CalibrationRecords] [nvarchar](255) NOT NULL,
|
||
[ModifyDate] [datetime] NOT NULL,
|
||
[IsProportional] [bit] NOT NULL,
|
||
[RemoveOffset] [bit] NOT NULL,
|
||
[ZeroMethod] [nvarchar](255) NOT NULL,
|
||
[CertificationDocuments] [nvarchar](2048) NOT NULL,
|
||
[InitialOffset] [nvarchar](50) NOT NULL,
|
||
[DbTimeStamp] [TimeStamp] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblSensorModels] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblSensorModels](
|
||
[Model] [nvarchar](50) NOT NULL,
|
||
[Manufacturer] [nvarchar](50) NOT NULL,
|
||
[UserPartNumber] [nvarchar](50) NOT NULL,
|
||
[Capacity] [float] NOT NULL,
|
||
[OffsetToleranceLow] [float] NOT NULL,
|
||
[OffsetToleranceHigh] [float] NOT NULL,
|
||
[MeasurementUnit] [nvarchar](50) NOT NULL,
|
||
[Bridge] [smallint] NOT NULL,
|
||
[Shunt] [smallint] NOT NULL,
|
||
[BridgeResistance] [float] NOT NULL,
|
||
[FilterClass] [nvarchar](50) NOT NULL,
|
||
[UniPolar] [bit] NOT NULL,
|
||
[IgnoreRange] [bit] NOT NULL,
|
||
[CouplingMode] [smallint] NOT NULL,
|
||
[Version] [int] NOT NULL,
|
||
[RangeLow] [float] NOT NULL,
|
||
[RangeAve] [float] NOT NULL,
|
||
[RangeHigh] [float] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[ModifiedBy] [nvarchar](50) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[NumberOfAxes] [smallint] NOT NULL,
|
||
[CalInterval] [int] NOT NULL,
|
||
[AxisNumber] [smallint] NOT NULL,
|
||
[Polarity] [nvarchar](10) NOT NULL,
|
||
[Invert] [bit] NOT NULL,
|
||
[CheckOffset] [bit] NOT NULL,
|
||
[CalibrationRecord] [nvarchar](255) NOT NULL,
|
||
[ISOCode] [nvarchar](20) NOT NULL,
|
||
[SupportedExcitation] [nvarchar](255) NOT NULL,
|
||
[InitialEU] [float],
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
/****** Object: Table [dbo].[tblSensors] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblSensors](
|
||
[SerialNumber] [nvarchar](50) NOT NULL,
|
||
[UserSerialNumber] [nvarchar](50) NOT NULL,
|
||
[Model] [nvarchar](50) NULL,
|
||
[Manufacturer] [nvarchar](50) NULL,
|
||
[Status] [nvarchar](50) NOT NULL,
|
||
[MeasurementUnit] [nvarchar](50) NOT NULL,
|
||
[OffsetToleranceLow] [float] NOT NULL,
|
||
[OffsetToleranceHigh] [float] NOT NULL,
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[Capacity] [float] NOT NULL,
|
||
[Comment] [nvarchar](255) NOT NULL,
|
||
[BridgeType] [smallint] NOT NULL,
|
||
[BridgeLegMode] [smallint] NOT NULL,
|
||
[Shunt] [smallint] NOT NULL,
|
||
[Invert] [bit] NOT NULL,
|
||
[UserValue1] [nvarchar](50) NULL,
|
||
[UserValue2] [nvarchar](50) NULL,
|
||
[UserValue3] [nvarchar](50) NULL,
|
||
[FilterClass] [nvarchar](50) NOT NULL,
|
||
[BridgeResistance] [float] NOT NULL,
|
||
[IsoCode] [nvarchar](50) NOT NULL,
|
||
[CheckOffset] [bit] NOT NULL,
|
||
[SupportedExcitation] [nvarchar](50) NOT NULL,
|
||
[InitialEU] [float],
|
||
[CalInterval] [int] NOT NULL,
|
||
[CalibrationSignal] [bit] NOT NULL,
|
||
[InternalShuntResistance] [float] NOT NULL,
|
||
[ExternalShuntResistance] [float] NOT NULL,
|
||
[UniPolar] [bit] NOT NULL,
|
||
[RangeLow] [float] NOT NULL,
|
||
[RangeAve] [float] NOT NULL,
|
||
[RangeHigh] [float] NOT NULL,
|
||
[Created] [datetime] NOT NULL,
|
||
[TimesUsed] [bigint] NOT NULL,
|
||
[SensorCategory] [int] NOT NULL,
|
||
[BypassFilter] [bit] NOT NULL,
|
||
[CouplingMode] [smallint] NOT NULL,
|
||
[Version] [int] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[ModifiedBy] [nvarchar](50) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[AxisNumber] [smallint] NOT NULL,
|
||
[NumberOfAxes] [smallint] NOT NULL,
|
||
[UserTags] [varbinary](MAX) NULL,
|
||
[DbTimeStamp] [TimeStamp] NULL,
|
||
[DoNotUse] bit NOT NULL,
|
||
[Broken] bit NOT NULL
|
||
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[SerialNumber] 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].[tblSettings] Script Date: 1/21/2016 8:42:12 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblSettings](
|
||
[PropertyId] [nvarchar](255) NOT NULL,
|
||
[PropertyType] [int] NOT NULL,
|
||
[PropertyValue] [nvarchar](255) NOT NULL,
|
||
[UserId] [nvarchar](255) NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTemplateChannels] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTemplateChannels](
|
||
[TestObjectNumber] [nvarchar](50) NULL,
|
||
[NameOfTheChannel] [nvarchar](100) NULL,
|
||
[LaboratoryChannelCode] [nvarchar](50) NULL,
|
||
[CustomerChannelCode] [nvarchar](50) NULL,
|
||
[Comments1] [nvarchar](50) NULL,
|
||
[Location] [nvarchar](50) NULL,
|
||
[Dimension] [nvarchar](50) NULL,
|
||
[Direction] [nvarchar](50) NULL,
|
||
[ChannelFrequencyClass] [nvarchar](50) NULL,
|
||
[Unit] [nvarchar](50) NULL,
|
||
[ReferenceSystem] [nvarchar](50) NULL,
|
||
[TransducerType] [nvarchar](50) NULL,
|
||
[TransducerId] [nvarchar](50) NULL,
|
||
[PreFilterType] [nvarchar](50) NULL,
|
||
[CutOffFrequency] [nvarchar](50) NULL,
|
||
[ChannelAmplitudeClass] [nvarchar](50) NULL,
|
||
[ReferenceChannel] [nvarchar](50) NULL,
|
||
[ReferenceChannelName] [nvarchar](50) NULL,
|
||
[DataSource] [nvarchar](50) NULL,
|
||
[DataStatus] [nvarchar](50) NULL,
|
||
[SamplingInterval] [nvarchar](50) NULL,
|
||
[BitResolution] [nvarchar](50) NULL,
|
||
[TimeOfFirstSample] [nvarchar](50) NULL,
|
||
[NumberOfSamples] [nvarchar](50) NULL,
|
||
[OffsetPostTest] [nvarchar](50) NULL,
|
||
[TransducerNaturalFrequency] [nvarchar](50) NULL,
|
||
[TransducerDampingRatio] [nvarchar](50) NULL,
|
||
[Comments] [nvarchar](50) NULL,
|
||
[FirstGlobalMaximumValue] [nvarchar](50) NULL,
|
||
[TimeOfMaximumValue] [nvarchar](50) NULL,
|
||
[FirstGlobalMinimumValue] [nvarchar](50) NULL,
|
||
[TimeOfMinimumValue] [nvarchar](50) NULL,
|
||
[StartOffsetInterval] [nvarchar](50) NULL,
|
||
[EndOffsetInterval] [nvarchar](50) NULL,
|
||
[Required] [bit] NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[MMEChannelId] [bigint] NULL,
|
||
[MMEChannelType] [int] NULL,
|
||
[TemplateName] [nvarchar](255) NULL,
|
||
[DisplayOrder] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTemplateRegions] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTemplateRegions](
|
||
[TemplateName] [nvarchar](255) NULL,
|
||
[RegionNumber] [int] NULL,
|
||
[RegionName] [nvarchar](50) NULL,
|
||
[RegionDescription] [nvarchar](50) NULL,
|
||
[TestObject] [nvarchar](50) NULL,
|
||
[Position] [nvarchar](50) NULL,
|
||
[MainLocation] [nvarchar](50) NULL,
|
||
[FineLocation1] [nvarchar](50) NULL,
|
||
[FineLocation2] [nvarchar](50) NULL,
|
||
[FineLocation3] [nvarchar](50) NULL,
|
||
[PhysicalDimension] [nvarchar](50) NULL,
|
||
[Direction] [nvarchar](50) NULL,
|
||
[FilterClass] [nvarchar](50) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[UpperLeftX] [nvarchar](50) NULL,
|
||
[UpperLeftY] [nvarchar](50) NULL,
|
||
[LowerRightX] [nvarchar](50) NULL,
|
||
[LowerRightY] [nvarchar](50) NULL,
|
||
[ZoneName] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
/****** Object: Table [dbo].[tblTemplateZones] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTemplateZones](
|
||
[TemplateName] [nvarchar](255) NULL,
|
||
[ZoneName] [nvarchar](50) NULL,
|
||
[ZoneDescription] [nvarchar](50) NULL,
|
||
[Picture] [nvarchar](50) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestChannelSettings] Script Date: 1/21/2016 8:44:33 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestChannelSettings](
|
||
[TestName] [nvarchar](255) NOT NULL,
|
||
[TestObjectName] [nvarchar](255) NOT NULL,
|
||
[ChannelId] [nvarchar](255) NOT NULL,
|
||
[Setting] [nvarchar](255) NULL,
|
||
[SensorSerial] [nvarchar](255) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestGraphs] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTestGraphs](
|
||
[GraphName] [nvarchar](50) NOT NULL,
|
||
[GraphDescription] [nvarchar](50) NOT NULL,
|
||
[TemplateName] [nvarchar](255) NOT NULL,
|
||
[Channels] [nvarchar](2048) NOT NULL,
|
||
[UseDomainMin] [bit] NOT NULL,
|
||
[DomainMin] [float] NOT NULL,
|
||
[UseDomainMax] [bit] NOT NULL,
|
||
[DomainMax] [float] NOT NULL,
|
||
[UseRangeMin] [bit] NOT NULL,
|
||
[RangeMin] [float] NOT NULL,
|
||
[UseRangeMax] [bit] NOT NULL,
|
||
[RangeMax] [float] NOT NULL,
|
||
[Thresholds] [nvarchar](2048) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestObjectChannelSettings] Script Date: 1/21/2016 8:45:34 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestObjectChannelSettings](
|
||
[TestObjectSerial] [nvarchar](255) NOT NULL,
|
||
[ChannelId] [nvarchar](255) NOT NULL,
|
||
[Setting] [nvarchar](255) NULL,
|
||
[SensorSerial] [nvarchar](255) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestObjectHardware] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTestObjectHardware](
|
||
[TestObject] [nvarchar](255) NOT NULL,
|
||
[HardwareId] [nvarchar](255) NOT NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestObjects] Script Date: 1/21/2016 8:46:35 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestObjects](
|
||
[SerialNumber] [nvarchar](255) NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[Template] [nvarchar](255) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[ParentObject] [nvarchar](255) NULL,
|
||
[SysBuilt] [bit] NULL,
|
||
[OrigSerialNumber] [nvarchar](255) NULL,
|
||
[OrigTemplate] [nvarchar](255) NULL,
|
||
[Embedded] [bit] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[Dirty] [bit] NULL,
|
||
[Complete] [bit] NULL,
|
||
[ErrorMessage] [nvarchar](max) NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[SerialNumber] 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].[tblTestObjectSensors] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTestObjectSensors](
|
||
[TestObjectId] [nvarchar](255) NOT NULL,
|
||
[UIChannelID] [nvarchar](255) NOT NULL,
|
||
[SensorId] [nvarchar](50) NOT NULL,
|
||
[ZoneId] [nvarchar](50) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[HardwareId] [nvarchar](255) NULL,
|
||
[ChannelIdx] [int] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestObjectTemplates] Script Date: 1/21/2016 8:47:40 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestObjectTemplates](
|
||
[TemplateName] [nvarchar](255) NOT NULL,
|
||
[Icon] [nvarchar](50) NULL,
|
||
[Description] [nvarchar](50) NULL,
|
||
[LocalOnly] [bit] NULL,
|
||
[Version] [int] NULL,
|
||
[LastModifiedBy] [nvarchar](50) NULL,
|
||
[CRC32] [int] NULL,
|
||
[TestObject] [nvarchar](255) NOT NULL,
|
||
[TestObjectType] [nvarchar](255) NULL,
|
||
[LastModified] [datetime] NULL,
|
||
[ParentTemplate] [nvarchar](50) NULL,
|
||
[SysBuilt] [bit] NULL,
|
||
[OrigTemplateName] [nvarchar](255) NULL,
|
||
[Embedded] [bit] NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestSetupDASSettings] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTestSetupDASSettings](
|
||
[DASSerialNumber] [nvarchar](50) NOT NULL,
|
||
[TestSetupName] [nvarchar](50) NOT NULL,
|
||
[TargetSampleRate] [float] NOT NULL,
|
||
[ExcitationWarmupTimeMS] [int] NOT NULL,
|
||
[AAFilterRate] [float] NOT NULL,
|
||
[PreTriggerSeconds] [float] NOT NULL,
|
||
[PostTriggerSeconds] [float] NOT NULL,
|
||
[StatusLineCheck] [bit] NOT NULL,
|
||
[BatteryCheck] [bit] NOT NULL,
|
||
[InputVoltageMin] [float] NOT NULL,
|
||
[InputVoltageMax] [float] NOT NULL,
|
||
[BatteryVoltageMin] [float] NOT NULL,
|
||
[BatteryVoltageMax] [float] NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestSetupHardware] Script Date: 1/21/2016 8:48:42 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestSetupHardware](
|
||
[TestSetupName] [nvarchar](255) NOT NULL,
|
||
[HardwareId] [nvarchar](255) NOT NULL,
|
||
[AddOrRemove] [bit] NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestSetupObjectMetaData] Script Date: 1/21/2016 8:49:17 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
SET ANSI_PADDING ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestSetupObjectMetaData](
|
||
[SetupName] [nvarchar](255) NOT NULL,
|
||
[TestObject] [char](1) NOT NULL,
|
||
[PropName] [nvarchar](255) NOT NULL,
|
||
[PropValue] [nvarchar](255) NOT NULL,
|
||
[Optional] [bit] NOT NULL,
|
||
[Version] [float] NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestSetupObjects] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTestSetupObjects](
|
||
[TestObjectSerialNumber] [nvarchar](255) NOT NULL,
|
||
[TestSetupName] [nvarchar](255) NOT NULL,
|
||
[TargetSampleRate] [float] NOT NULL,
|
||
[ExcitationWarmupTimeMS] [int] NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[TestObjectType] [nvarchar](50) NOT NULL,
|
||
[TestObjectPosition] [nvarchar](50) NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblLevelTriggers] Script Date: 4/13/2016 10:45:45 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblLevelTriggers](
|
||
[TestSetupName] [nvarchar](255) NOT NULL,
|
||
[GroupSerialNumber] [nvarchar](255) NOT NULL,
|
||
[TestObjectChannelId] [nvarchar](255) NOT NULL,
|
||
[HardwareChannelId] [nvarchar](255) NOT NULL,
|
||
[SensorSerialNumber] [nvarchar](255) NOT NULL,
|
||
[GreaterThanEnabled] [bit] NOT NULL,
|
||
[GreaterThanEU] [FLOAT] NOT NULL,
|
||
[LessThanEnabled] [BIT] NOT NULL,
|
||
[LessThanEU] [FLOAT] NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[InsideUpperEU] [FLOAT] NULL,
|
||
[InsideLowerEU] [FLOAT] NULL,
|
||
[OutsideUpperEU] [FLOAT] NULL,
|
||
[OutsideLowerEU] [FLOAT] NULL,
|
||
[TriggerInside] [BIT] NULL,
|
||
[TriggerOutside] [BIT] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblCalculatedChannels] Script Date: 5/25/2016 10:45:45 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblCalculatedChannels](
|
||
[Id] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
|
||
[Operation] [int],
|
||
[CalculatedChannelValueCode] [nvarchar](255),
|
||
[InputChannelIds] [varbinary](MAX),
|
||
[CFCForInputChannels] [nvarchar](255),
|
||
[CFCForOutput] [nvarchar](255),
|
||
[TestSetupName] [nvarchar](255),
|
||
[CCName] [nvarchar](255),
|
||
[DbTimeStamp] [TimeStamp] NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
/****** Object: Table [dbo].[tblTestSetups] Script Date: 1/21/2016 9:02:37 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTestSetups](
|
||
[SetupName] [nvarchar](50) NOT NULL,
|
||
[SetupDescription] [nvarchar](50) NOT NULL,
|
||
[AutomaticTestProgression] [bit] NOT NULL,
|
||
[AutomaticProgressionDelayMS] [int] NOT NULL,
|
||
[InvertTrigger] [bit] NOT NULL,
|
||
[InvertStart] [bit] NOT NULL,
|
||
[ViewDiagnostics] [bit] NOT NULL,
|
||
[VerifyChannels] [bit] NOT NULL,
|
||
[AutoVerifyChannels] [bit] NOT NULL,
|
||
[VerifyChannelsDelayMS] [int] NOT NULL,
|
||
[RecordingMode] [smallint] NOT NULL,
|
||
[SamplesPerSecond] [float] NOT NULL,
|
||
[PreTriggerSeconds] [float] NOT NULL,
|
||
[PostTriggerSeconds] [float] NOT NULL,
|
||
[StrictDiagnostics] [bit] NOT NULL,
|
||
[RequireConfirmationOnErrors] [bit] NOT NULL,
|
||
[ROIDownload] [bit] NOT NULL,
|
||
[ViewROIDownload] [bit] NOT NULL,
|
||
[DownloadAll] [bit] NOT NULL,
|
||
[ViewRealtime] [bit] NOT NULL,
|
||
[RealtimePlotCount] [smallint] NOT NULL,
|
||
[ROIStart] [float] NOT NULL,
|
||
[ROIEnd] [float] NOT NULL,
|
||
[ViewDownloadAll] [bit] NOT NULL,
|
||
[Export] [bit] NOT NULL,
|
||
[ExportFormat] [bigint] NOT NULL,
|
||
[LabDetails] [nvarchar](50),
|
||
[UseLabDetails] [bit] NOT NULL,
|
||
[CustomerDetails] [nvarchar](50),
|
||
[UseCustomerDetails] [bit] NOT NULL,
|
||
[AllowMissingSensors] [bit] NOT NULL,
|
||
[AllowSensorIdToBlankChannel] [bit] NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[TurnOffExcitation] [bit] NOT NULL,
|
||
[TriggerCheckRealtime] [bit] NOT NULL,
|
||
[TriggerCheckStep] [bit] NOT NULL,
|
||
[PostTestDiagnostics] [int] NOT NULL,
|
||
[ExportFolder] [nvarchar](150) NOT NULL,
|
||
[DownloadFolder] [nvarchar](150) NOT NULL,
|
||
[CommonStatusLine] [bit] NULL,
|
||
[SameAsDownloadFolder] [bit] NULL,
|
||
[UploadData] [bit] NULL,
|
||
[UploadDataFolder] [nvarchar](150) NOT NULL,
|
||
[Settings] [nvarchar](MAX) NOT NULL,
|
||
[WarnOnBatteryFail] [bit] NOT NULL,
|
||
[Dirty] [bit] NOT NULL,
|
||
[Complete] [bit] NOT NULL,
|
||
[ErrorMessage] [nvarchar](255),
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[TestEngineerDetails] [nvarchar](50),
|
||
[UseTestEngineerDetails] [bit] NOT NULL,
|
||
[UserTags] [varbinary](MAX) NULL,
|
||
[DoAutoArm] [bit] NOT NULL,
|
||
[CheckoutMode] [bit] NULL,
|
||
[QuitTestWithoutWarning] [bit] NULL,
|
||
[ISFFile] [nvarchar](4000) NULL,
|
||
[NotAllChannelsRealTime] [bit] NULL,
|
||
[NotAllChannelsViewer] [bit] NULL,
|
||
[SuppressMissingSensorsWarning] [bit] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[SetupName] 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].[tblTOMDigitalChannels] Script Date: 1/21/2016 8:51:52 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[tblTOMDigitalChannels](
|
||
[ChannelDescription] [nvarchar](50) NOT NULL,
|
||
[DelayMS] [float] NOT NULL,
|
||
[DurationMS] [smallint] NOT NULL,
|
||
[OutputMode] [smallint] NOT NULL,
|
||
[LimitDuration] [bit] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[Version] [int] NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[DurationMSFloat] [float] NOT NULL,
|
||
[UserTags] [varbinary](MAX) NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[ChannelDescription] 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].[tblTOMSquibChannels] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[tblTOMSquibChannels](
|
||
[SquibDescription] [nvarchar](50) NOT NULL,
|
||
[BypassCurrentFilter] [bit] NOT NULL,
|
||
[BypassVoltageFilter] [bit] NOT NULL,
|
||
[DelayMS] [float] NOT NULL,
|
||
[DurationMS] [float] NOT NULL,
|
||
[FireMode] [smallint] NOT NULL,
|
||
[ISOCode] [nvarchar](50) NOT NULL,
|
||
[MeasurementType] [smallint] NOT NULL,
|
||
[SquibOutputCurrent] [float] NOT NULL,
|
||
[SquibToleranceLow] [float] NOT NULL,
|
||
[SquibToleranceHigh] [float] NOT NULL,
|
||
[LimitDuration] [bit] NOT NULL,
|
||
[ArticleId] [nvarchar](50) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
[Version] [int] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[DbTimeStamp] [TIMESTAMP] NULL,
|
||
[UserValue1] [nvarchar](255) NULL,
|
||
[UserValue2] [nvarchar](255) NULL,
|
||
[UserValue3] [nvarchar](255) NULL,
|
||
[UserTags] [varbinary](MAX) NULL
|
||
PRIMARY KEY CLUSTERED
|
||
(
|
||
[SquibDescription] 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].[tblUsers] Script Date: 6/4/2014 4:58:45 PM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[DataPROUsers](
|
||
[ID] [int] IDENTITY(1,1) NOT NULL,
|
||
[UserName] [nvarchar](50) NOT NULL,
|
||
[DisplayName] [nvarchar](50) NOT NULL,
|
||
[Password] [nvarchar](2048) NOT NULL,
|
||
[Role] [smallint] NOT NULL,
|
||
[LastModified] [datetime] NOT NULL,
|
||
[LastModifiedBy] [nvarchar](50) NOT NULL,
|
||
[LocalOnly] [bit] NOT NULL,
|
||
CONSTRAINT [PK_DataPROUsers] 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
|
||
CREATE TABLE [dbo].[DefaultProperties](
|
||
[PropertyId] [int] NOT NULL,
|
||
[PropertyName] [nvarchar](max) NOT NULL,
|
||
[DefaultValue] [nvarchar](max) NOT NULL,
|
||
CONSTRAINT [PK_DefaultProperties] PRIMARY KEY CLUSTERED
|
||
(
|
||
[PropertyId] 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
|
||
CREATE TABLE [dbo].[UserProperties](
|
||
[UserId] [int] NOT NULL,
|
||
[PropertyId] [int] NOT NULL,
|
||
[PropertyValue] [nvarchar](max) NOT NULL,
|
||
CONSTRAINT [IX_UserProperties] UNIQUE NONCLUSTERED
|
||
(
|
||
[UserId] ASC,
|
||
[PropertyId] 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
|
||
CREATE TABLE [dbo].[LastUsedHardware](
|
||
[UserID] [int] NOT NULL,
|
||
[HardwareID] [nvarchar](50) NOT NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[LastUsedHardware] WITH CHECK ADD CONSTRAINT [FK_LastUsedHardware_DataPROUsers] FOREIGN KEY([UserID])
|
||
REFERENCES [dbo].[DataPROUsers] ([ID])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[LastUsedHardware] CHECK CONSTRAINT [FK_LastUsedHardware_DataPROUsers]
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
/****** Object: Table [dbo].[UIItems] Script Date: 2/24/2017 11:30:45 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[UIItems](
|
||
[ID] [bigint] IDENTITY(1,1) NOT NULL,
|
||
[NAME] [nvarchar](max) NOT NULL,
|
||
CONSTRAINT [PK_UIItems] 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].[UserUIItemSettings] Script Date: 2/24/2017 11:30:45 AM ******/
|
||
SET ANSI_NULLS ON
|
||
GO
|
||
SET QUOTED_IDENTIFIER ON
|
||
GO
|
||
CREATE TABLE [dbo].[UserUIItemSettings](
|
||
[UserID] [int] NOT NULL,
|
||
[UIItemID] [bigint] NOT NULL,
|
||
[Permission] [smallint] NOT NULL,
|
||
[Visible] [bit] NOT NULL
|
||
) ON [PRIMARY]
|
||
|
||
GO
|
||
/****** Object: Index [IX_DataPROUsers_UserName] Script Date: 2/24/2017 11:30:45 AM ******/
|
||
CREATE UNIQUE NONCLUSTERED INDEX [IX_DataPROUsers_UserName] ON [dbo].[DataPROUsers]
|
||
(
|
||
[ID] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
GO
|
||
/****** Object: Index [IX_UIItems_NAME] Script Date: 2/24/2017 11:30:45 AM ******/
|
||
CREATE UNIQUE NONCLUSTERED INDEX [IX_UIItems_NAME] ON [dbo].[UIItems]
|
||
(
|
||
[ID] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
GO
|
||
/****** Object: Index [IX_UserUIItemSettings] Script Date: 2/24/2017 11:30:45 AM ******/
|
||
CREATE NONCLUSTERED INDEX [IX_UserUIItemSettings] ON [dbo].[UserUIItemSettings]
|
||
(
|
||
[UserID] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
|
||
GO
|
||
ALTER TABLE [dbo].[UserUIItemSettings] WITH CHECK ADD CONSTRAINT [FK_UserUIItemSettings_DataPROUsers] FOREIGN KEY([UserID])
|
||
REFERENCES [dbo].[DataPROUsers] ([ID])
|
||
GO
|
||
ALTER TABLE [dbo].[UserUIItemSettings] CHECK CONSTRAINT [FK_UserUIItemSettings_DataPROUsers]
|
||
GO
|
||
ALTER TABLE [dbo].[UserUIItemSettings] WITH CHECK ADD CONSTRAINT [FK_UserUIItemSettings_UIItems] FOREIGN KEY([UIItemID])
|
||
REFERENCES [dbo].[UIItems] ([ID])
|
||
GO
|
||
ALTER TABLE [dbo].[UserUIItemSettings] CHECK CONSTRAINT [FK_UserUIItemSettings_UIItems]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[UserProperties] WITH CHECK ADD CONSTRAINT [FK_UserProperties_DataPROUsers] FOREIGN KEY([UserId])
|
||
REFERENCES [dbo].[DataPROUsers] ([ID])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[UserProperties] CHECK CONSTRAINT [FK_UserProperties_DataPROUsers]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[UserProperties] WITH CHECK ADD CONSTRAINT [FK_UserProperties_DefaultProperties] FOREIGN KEY([PropertyId])
|
||
REFERENCES [dbo].[DefaultProperties] ([PropertyId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[UserProperties] CHECK CONSTRAINT [FK_UserProperties_DefaultProperties]
|
||
GO
|
||
|
||
USE [master]
|
||
GO
|
||
|
||
/** For security reasons the login is created disabled and with a random password. **/
|
||
if not Exists(select * from master.dbo.syslogins where name = 'DataPROUser' )
|
||
BEGIN
|
||
PRINT 'login does not exist, creating.';
|
||
CREATE LOGIN [DataPROUser] WITH PASSWORD=N'hܯFÕ ¨Úå<z³{0 fDñ¤ñFU)üM', DEFAULT_DATABASE=[DataPRO], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON;
|
||
ALTER LOGIN [DataPROUser] ENABLE;
|
||
USE [DataPRO];
|
||
CREATE USER [DataPROUser] FOR LOGIN [DataPROUser] WITH DEFAULT_SCHEMA=[dbo];
|
||
END;
|
||
ELSE
|
||
BEGIN
|
||
PRINT 'DataPROUser login already exists, skipping create';
|
||
END
|
||
|
||
if not exists(select * from sys.database_principals where name = 'DataPROUser' )
|
||
BEGIN
|
||
PRINT 'principal user does not exist, creating';
|
||
CREATE USER [DataPROUser] FOR LOGIN [DataPROUser];
|
||
END
|
||
ELSE
|
||
BEGIN
|
||
PRINT 'principal user already exists, skipping';
|
||
END
|
||
|
||
USE [DataPRO]
|
||
PRINT 'adding user to DataPRO database';
|
||
CREATE USER [DataPROUser] for Login [DataPROUser];
|
||
PRINT 'granting access to DataPROUser';
|
||
ALTER ROLE [db_owner] ADD MEMBER [DataPROUser]
|
||
GO
|
||
GRANT CONNECT TO [DataPROUser] AS [dbo]
|
||
GO
|
||
|
||
INSERT INTO [dbo].[tblDataPRODbVersion]
|
||
([Version]
|
||
,[Step]
|
||
,[Date]
|
||
,[Remarks]
|
||
,[UserField])
|
||
VALUES
|
||
(61
|
||
,0
|
||
,CURRENT_TIMESTAMP
|
||
,''
|
||
,'SYSTEM')
|
||
GO
|
||
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICEPRO Prototype',8,6,16106127360,600000,100,'A1J4',CURRENT_TIMESTAMP, 145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',18,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',1,1,0)
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE1 Prototype',0,8,8000000,100000,50,'00M3',CURRENT_TIMESTAMP,9,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Nano Prototype',18,8,8000000,100000,50,'00M3',CURRENT_TIMESTAMP,9,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Micro Prototype',17,8,8000000,100000,50,'00M3',CURRENT_TIMESTAMP,9,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE+ Prototype',16,7,1353711597,400000,100,'B1A7',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('G5 VDS Prototype',12,4,16000000,100000,50,'01U5',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',48,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('G5 iPort Prototype',22,4,16000000,100000,50,'01U5',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',48,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('G5 InDummy Prototype',23,4,16000000,100000,50,'01U5',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',32,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('TDASPRO Rack 4M Prototype',3,4,0,61000,50,'08D7',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('TDAS PRO Lab Rack',31,6,0,61000,50,'08D7',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('TDASPro Rack 8M Prototype',3,8,0,61000,50,'08D7',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE ECM Prototype',24,0,0,4294967295,0,'00A8',CURRENT_TIMESTAMP,4,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','192.168.0.10',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE6Db Prototype',33,0,0,4294967295,0,'00A0',CURRENT_TIMESTAMP,4,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','192.168.0.10',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE PRO Lab Ethernet Prototype',26,0,0,4294967295,0,'00A8',CURRENT_TIMESTAMP,4,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','192.168.2.10',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Distributor Prototype',2,0,0,4294967295,0,'00A6',CURRENT_TIMESTAMP,4,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','192.168.1.208',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Pro DIM',20,6,16106127360,600000,100,'A1J4',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',18,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE PRO Lab DIM',30,6,16106127360,600000,100,'A1J4',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',18,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Pro SIM',19,6,16106127360,600000,100,'A1J4',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',18,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE PRO Lab SIM',19,6,16106127360,600000,100,'A1J4',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',18,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE Pro TOM',21,8,907367754,600000,100,'D0D7',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',16,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE PRO Lab TOM',29,8,907367754,600000,100,'D0D7',CURRENT_TIMESTAMP,145,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',16,'Prototype','0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE6 Prototype',32,2,16106127360,600000,200000,'00A1',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',6,'Prototype','0,0,0,0,0,0',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE MICRO BASE+ Prototype',25,7,1353711597,400000,100,'B1A7',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDAS] ([SerialNumber],[Type],[MaxModules],[MaxMemory],[MaxSampleRate],[MinSampleRate],[FirmwareVersion],[CalDate],[ProtocolVersion],[LastModified]
|
||
,[LastModifiedBy],[Version],[LocalOnly],[LastUsed],[LastUsedBy],[Connection],[Channels],[Position],[ChannelTypes],[Reprogramable],[Reconfigurable],[IsModule]/*,[DbTimeStamp]*/)
|
||
VALUES('SLICE G5 Prototype',28,6,1353711597,120000,100,'A1J4',CURRENT_TIMESTAMP,1,CURRENT_TIMESTAMP,'DATAPRO_SYSTEM',1,0,CURRENT_TIMESTAMP,'','',0,'Prototype','',0,0,0);
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',0,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',1,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',2,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',3,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',4,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',5,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',6,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',7,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',8,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',9,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',10,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',11,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',12,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',13,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',14,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',15,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',16,12,15,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE G5 Prototype_28',17,12,15,'-1',0,30,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',0,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',1,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',2,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',3,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',4,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',5,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',6,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',7,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',8,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',9,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',10,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',11,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',12,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',13,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',14,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',15,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',16,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICEPRO Prototype_8',17,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',0,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',1,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',2,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',3,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',4,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',5,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',6,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',7,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',8,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',9,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',10,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',11,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',12,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',13,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',14,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',15,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',16,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',17,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',18,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',19,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',20,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',21,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',22,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',23,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',24,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',25,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',26,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',27,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',28,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',29,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',30,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',31,12,18,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',32,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',33,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',34,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',35,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',36,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',37,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',38,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',39,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',40,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',41,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',42,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',43,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',44,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',45,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',46,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 VDS Prototype_12',47,16,16,'-1',0,8,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',0,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',1,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',2,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',3,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',4,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',5,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',6,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',7,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',8,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',9,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',10,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',11,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',12,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',13,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',14,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',15,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',16,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',17,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',18,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',19,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',20,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',21,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',22,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',23,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',24,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',25,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',26,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',27,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',28,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',29,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',30,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 iPort Prototype_22',31,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',0,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',1,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',2,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',3,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',4,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',5,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',6,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',7,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',8,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',9,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',10,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',11,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',12,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',13,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',14,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',15,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',16,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',17,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',18,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',19,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',20,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',21,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',22,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',23,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',24,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',25,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',26,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',27,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',28,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',29,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',30,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('G5 InDummy Prototype_23',31,12,16,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',0,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',1,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',2,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',3,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',4,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',5,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',6,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',7,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',8,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',9,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',10,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',11,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',12,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',13,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',14,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',15,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',16,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro DIM_20',17,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',0,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',1,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',2,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',3,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',4,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',5,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',6,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',7,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',8,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',9,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',10,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',11,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',12,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',13,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',14,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',15,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',16,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro SIM_19',17,15,50,'-1',0,30,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',0,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',1,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',2,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',3,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',4,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',5,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',6,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',7,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',8,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',9,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',10,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',11,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',12,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',13,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',14,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',15,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',16,15,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab SIM_27',17,15,50,'-1',0,30,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',0,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',1,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',2,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',3,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',4,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',5,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',6,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',7,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',8,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',9,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',10,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',11,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',12,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',13,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',14,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE Pro TOM_21',15,64,16,'-1',0,16,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',0,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',1,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',2,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',3,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',4,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',5,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',6,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',7,32,16,'-1',0,16,7,0,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',8,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',9,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',10,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',11,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',12,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',13,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',14,64,16,'-1',0,16,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab TOM_29',15,64,16,'-1',0,16,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',0,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',1,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',2,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',3,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',4,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',5,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',6,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',7,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',8,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',9,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',10,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',11,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',12,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',13,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',14,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',15,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',16,16,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE PRO Lab DIM_30',17,16,50,'-1',0,30,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',0,8,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',1,8,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',2,8,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',3,8,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',4,8,50,'-1',0,30,1,10,'','');
|
||
INSERT INTO [dbo].[tblDASChannels] ([HardwareId],[ChannelIdx],[SupportedBridges],[SupportedExcitations],[DASDisplayOrder],[LocalOnly],[SupportedDigitalInputModes],
|
||
[SupportedSquibFireModes],[SupportedDigitalOutputModes],[ModuleSerialNumber],[ModuleArrayIndex])
|
||
VALUES('SLICE6_32',5,8,50,'-1',0,30,1,10,'','');
|
||
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('NonLinearDisplayFormat',2,'N8','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('IsoSupportLevel',2,'ISO_ONLY','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('AutomaticModeDelayMS',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TESTSETUP_WARNBATFAIL',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_Count',2,8,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_0',2,200,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_1',2,100,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_2',2,50,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_3',2,20,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_4',2,10,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_5',2,5,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_6',2,1,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Graphs_PFSZoomValues_x_7',2,'0.1','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ISOSupport_Allow_Transitional',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ISOSupport_Allow_NonISO',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SensitivityDisplayFormat',2,'N8','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TestSetupDefaultAutomaticMode',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TriggerCheckQuickMode',2,'True','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TestSetup_AllowQuickTestSetup',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TESTSETUPDEFAULT_DONTALLOWOUTOFCALSENSOR',2,'False','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Diagnostics_TDAS_TimeoutSec',2,480,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Diagnostics_SLICE_TimeoutSec',2,240,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ResolveChannels_TDAS_QueryDownloadTimeoutSec',2,240,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ResolveChannels_SLICE_QueryDownloadTimeoutSec',2,120,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ResolveChannels_TDAS_QueryConfigTimeoutSec',2,50,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('ResolveChannels_SLICE_QueryConfigTimeoutSec',2,120,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TDAS_CONNECT_ALLOWED_SECONDS',2,45,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SLICE_CONNECT_ALLOWED_SECONDS',2,90,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDICE_COUNT',2,24,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_0',2,5,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_1',2,50,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_2',2,100,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_3',2,200,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_4',2,250,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_5',2,500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_6',2,1000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_7',2,2000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_8',2,2500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_9',2,5000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_10',2,8000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_11',2,10000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_12',2,12500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_13',2,20000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_14',2,25000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_15',2,40000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_16',2,50000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_17',2,60000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_18',2,75000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_19',2,100000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_20',2,150000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_21',2,300000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_22',2,400000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('SPSINDEX_23',2,500000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_5',2,1,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_50',2,10,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_100',2,20,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_200',2,40,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_250',2,50,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_500',2,100,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_1000',2,200,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_2000',2,400,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_2500',2,500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_5000',2,1000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_8000',2,1600,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_10000',2,2000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_12500',2,2500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_20000',2,4000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_25000',2,5000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_40000',2,8000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_50000',2,10000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_60000',2,12000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_75000',2,15000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_100000',2,20000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_150000',2,30000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_300000',2,60000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_400000',2,80000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('1_x_500000',2,100000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TDAS_MAXAAFRATE',2,4300,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('G5_MAXAAFRATE',2,3620,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_250',2,50,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_500',2,100,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_1000',2,200,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_2000',2,500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_2500',2,500,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_5000',2,1000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_8000',2,2000,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_10000',2,2900,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_12500',2,2900,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_20000',2,2900,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_25000',2,3620,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_40000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_50000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_60000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_75000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_100000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_150000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('0_x_300000',2,0,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TDASCalPeriod',2,365,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('G5CalPeriod',2,365,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Slice1CalPeriod',2,365,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Slice1_5CalPeriod',2,365,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('Slice2_CalPeriod',2,365,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('CalWarningPeriod',2,30,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('CalHWGracePeriod',2,30,'SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('StartingTestSetup',2,'','SYSTEM');
|
||
INSERT INTO [dbo].[tblSettings] ([PropertyId],[PropertyType],[PropertyValue],[UserId]) VALUES('TriggerSecondsDisplayFormat',2,'N4','SYSTEM');
|
||
GO
|
||
|
||
PRINT 'done' |