Malaria Online

#3802 Retiring กองทุนโลก and RAI2E funding source options from all 3 vector control dialogs

-- ============================================================
-- Retire funding-source minor codes: กองทูนโลก (02) and RAI2E (05)
-- Major = '26' (แหล่งเงินทุน / ActivityTypeCode)
--
-- Effect: these options will no longer appear in Add dialogs.
--         Edit dialogs for existing records will still display
--         the saved value via client-side AllFlag logic.
-- ============================================================

UPDATE TBL_MS_DEFINE_CODE
SET    Flag = '0'
WHERE  Major = '26'
  AND  Minor IN ('02', '05');

-- Verify:
-- SELECT Minor, DescriptionTh, Flag
-- FROM   TBL_MS_DEFINE_CODE
-- WHERE  Major = '26'
-- ORDER  BY Minor;
-- Expected: 02 = '0', 05 = '0'; 01/03/04 remain '1'