/** * 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Փ¨Úå