--SELECT * FROM TblLines

SELECT
    123 AS ID,
    'Line1' AS LName,
    'Line1' AS EName,
    10 AS Department,
    'Line one.' AS ERPID,
    'Some descr' AS Description,
    1 AS IsActive,
    1 AS MultiJobActivation,
    0 AS MultiSetupEnd,
    1 AS MultiUnitsInCycleChange,
    5 AS RootEventAttachDurationMin,
    100 AS FirstMachineID,
    300 AS LastMachineID,
    1 AS OperatorLoginSimultaneously,
    5 AS DisplayOrder,
    200 AS GrossUnitsMachineID,
    300 AS ReportedUnitsMachineID,
    1337 AS LineSpeedID,
    'CycleTime' AS LineSpeedName

--SELECT * FROM TblLineMachines

SELECT
    123 AS LineID,
    100 AS MachineID,
    1 AS SEQUENCE,
    1 AS IsActive,
    5 AS RootEventAttachDurationMin,
    0 AS IncludeInCycleTimeCalc,
    0 AS IncludeInAvailabilityCalc,
    200 AS NextMachines,
    0 AS Root
    UNION ALL
SELECT
    123 AS LineID,
    200 AS MachineID,
    2 AS SEQUENCE,
    1 AS IsActive,
    0 AS RootEventAttachDurationMin,
    1 AS IncludeInCycleTimeCalc,
    1 AS IncludeInAvailabilityCalc,
    300 AS NextMachines,
    0 AS Root
    UNION ALL
SELECT
    123 AS LineID,
    300 AS MachineID,
    3 AS SEQUENCE,
    1 AS IsActive,
    0 AS RootEventAttachDurationMin,
    0 AS IncludeInCycleTimeCalc,
    1 AS IncludeInAvailabilityCalc,
    NULL AS NextMachines,
    0 AS Root


--SELECT * FROM TblRoutes

SELECT
    321 AS ID,
    123 AS LineId,
    'Some Route' AS ERPID,
    'Hello' AS Description,
    1111 AS UserID,
    '2024-11-27' AS LastUpdate


--SELECT * FROM TblRouteDetails

SELECT
    321 AS RouteId,
    100 AS MachineId,
    1 AS DisplayOrder,
    1 AS FirstMachine,
    0 AS LastMachine,
    NULL AS LineSpeedID,
    NULL AS LineSpeedName,
    0 AS MachineBtwFirstAndLast,
    0 AS IncludeInCycleTimeCalc,
    0 AS IncludeInAvailabilityCalc,
    0 AS GrossUnitsMachineID,
    0 AS ReportedUnitsMachineID,
    0 AS IncludeInWIP,
    NULL AS ParallelUnitsSplit,
    1 AS ParallelMachinesGroupID
UNION ALL
SELECT
    321 AS RouteId,
    200 AS MachineId,
    2 AS DisplayOrder,
    0 AS FirstMachine,
    0 AS LastMachine,
    1337 AS LineSpeedID,
    'CycleTime' AS LineSpeedName,
    1 AS MachineBtwFirstAndLast,
    1 AS IncludeInCycleTimeCalc,
    1 AS IncludeInAvailabilityCalc,
    1 AS GrossUnitsMachineID,
    0 AS ReportedUnitsMachineID,
    0 AS IncludeInWIP,
    NULL AS ParallelUnitsSplit,
    2 AS ParallelMachinesGroupID
UNION ALL
SELECT
    321 AS RouteId,
    300 AS MachineId,
    3 AS DisplayOrder,
    0 AS FirstMachine,
    1 AS LastMachine,
    NULL AS LineSpeedID,
    NULL AS LineSpeedName,
    1 AS MachineBtwFirstAndLast,
    0 AS IncludeInCycleTimeCalc,
    1 AS IncludeInAvailabilityCalc,
    0 AS GrossUnitsMachineID,
    1 AS ReportedUnitsMachineID,
    0 AS IncludeInWIP,
    NULL AS ParallelUnitsSplit,
    3 AS ParallelMachinesGroupID

--SELECT * FROM TblParallelMachineGroupInLine

SELECT 1 AS ID, 123 AS LineID, 321 AS RouteID
UNION ALL
SELECT 2 AS ID, 123 AS LineID, 321 AS RouteID
UNION ALL
SELECT 3 AS ID, 123 AS LineID, 321 AS RouteID


--SELECT * FROM TblLineRoute

SELECT 123 AS LineID, 100 AS SourceMachineID, 200 AS TargetMachineID
UNION ALL
SELECT 123 AS LineID, 200 AS SourceMachineID, 300 AS TargetMachineID
UNION ALL
SELECT 123 AS LineID, 300 AS SourceMachineID, NULL AS TargetMachineID