Files
DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/50/50e3bf82e484d9503bb55da7850ebab24ef0be6f.svn-base

131 lines
9.5 KiB
Plaintext
Raw Permalink Normal View History

2026-04-17 14:55:32 -04:00
--Thermocoupler x 24
--Module 1
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 0, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 1, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 2, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 3, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 4, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 5, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 6, 8, 50, -1, 0, 0, 0, 0, '', 0)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 7, 8, 50, -1, 0, 0, 0, 0, '', 0)
--Module 2
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 8, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 9, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 10, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 11, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 12, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 13, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 14, 8, 50, -1, 0, 0, 0, 0, '', 1)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 15, 8, 50, -1, 0, 0, 0, 0, '', 1)
--Module 3
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 16, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 17, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 18, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 19, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 20, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 21, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 22, 8, 50, -1, 0, 0, 0, 0, '', 2)
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 23, 8, 50, -1, 0, 0, 0, 0, '', 2)
--Stream out channel
INSERT INTO [dbo].[DASChannels]
([DASId], [ChannelIdx], [SupportedBridges], [SupportedExcitations], [DASDisplayOrder], [LocalOnly], [SupportedDigitalInputModes], [SupportedSquibFireModes], [SupportedDigitalOutputModes], [ModuleSerialNumber], [ModuleArrayIndex])
VALUES
((SELECT DASId FROM [dbo].[DAS] WHERE SerialNumber = 'SLICE TC Prototype'), 24, 1024, 1, -1, 0, 0, 0, 0, '', 3)