--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,
	400 as LastMachineID,
	1 as OperatorLoginSimultaneously,
	5 as DisplayOrder,
	100 as GrossUnitsMachineID,
	400 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,
	400 as NextMachines,
	0 as Root
UNION ALL
SELECT
	123 as LineID,
	300 as MachineID,
	3 as Sequence,
	1 as IsActive,
	0 as RootEventAttachDurationMin,
	1 as IncludeInCycleTimeCalc,
	1 as IncludeInAvailabilityCalc,
	400 as NextMachines,
	0 as Root
UNION ALL
SELECT
	123 as LineID,
	400 as MachineID,
	4 as Sequence,
	1 as IsActive,
	0 as RootEventAttachDurationMin,
	0 as IncludeInCycleTimeCalc,
	0 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
UNION ALL
SELECT
	567 as ID,
	123 as LineId,
	'Another Route' as ERPID,
	'bye bye' 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,
	1 as MachineBtwFirstAndLast,
	0 as IncludeInCycleTimeCalc,
	0 as IncludeInAvailabilityCalc,
	1 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,
	0 as GrossUnitsMachineID,
	0 as ReportedUnitsMachineID,
	0 as IncludeInWIP,
	NULL as ParallelUnitsSplit,
	2 as ParallelMachinesGroupID
UNION ALL
SELECT
	321 as RouteId,
	400 as MachineId,
	4 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,
	4 as ParallelMachinesGroupID

UNION ALL

SELECT
	567 as RouteId,
	100 as MachineId,
	1 as DisplayOrder,
	1 as FirstMachine,
	0 as LastMachine,
	NULL as LineSpeedID,
	NULL as LineSpeedName,
	1 as MachineBtwFirstAndLast,
	0 as IncludeInCycleTimeCalc,
	0 as IncludeInAvailabilityCalc,
	1 as GrossUnitsMachineID,
	0 as ReportedUnitsMachineID,
	0 as IncludeInWIP,
	NULL as ParallelUnitsSplit,
	1 as ParallelMachinesGroupID
UNION ALL
SELECT
	567 as RouteId,
	300 as MachineId,
	3 as DisplayOrder,
	0 as FirstMachine,
	1 as LastMachine,
	69420 as LineSpeedID,
	'CycleTime' as LineSpeedName,
	1 as MachineBtwFirstAndLast,
	1 as IncludeInCycleTimeCalc,
	1 as IncludeInAvailabilityCalc,
	0 as GrossUnitsMachineID,
	0 as ReportedUnitsMachineID,
	0 as IncludeInWIP,
	NULL as ParallelUnitsSplit,
	3 as ParallelMachinesGroupID
UNION ALL
SELECT
	567 as RouteId,
	400 as MachineId,
	4 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,
	4 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
UNION ALL
SELECT 4 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, 100 as SourceMachineID, 300 as TargetMachineID
UNION ALL
SELECT 123 as LineID, 200 as SourceMachineID, 400 as TargetMachineID
UNION ALL
SELECT 123 as LineID, 300 as SourceMachineID, 400 as TargetMachineID
UNION ALL
SELECT 123 as LineID, 400 as SourceMachineID, NULL as TargetMachineID