USE [LegitimateKZN_QA_SO]
GO

/****** Insert E-Hailing Mode (ModeID = 6) ******/
-- This adds the E-Hailing mode to the Modes master table
-- Execute this FIRST before other scripts

INSERT INTO [Md].[Modes] 
(
    ModeID, 
    Description, 
    OlasServiceTypeID, 
    LtpsID, 
    IsCancelled, 
    ExceptionHandlerUserID
)
VALUES 
(
    6,              -- ModeID: E-Hailing (next sequential after Other = 5)
    'E-Hailing',    -- Description
    NULL,           -- OlasServiceTypeID (same as Metered Taxi)
    6,              -- LtpsID (assuming sequential pattern)
    0,              -- IsCancelled: Active mode
    1036            -- ExceptionHandlerUserID (consistent with other modes)
);
GO

-- Verify the insert
SELECT * FROM [Md].[Modes] WHERE ModeID = 6;
GO

