-- Seed data for: cwsn (the ~19,000 bulk-imported legacy records)
-- 18981 rows.
-- A few source values needed cleanup to satisfy the stricter MySQL ENUM columns
-- (Firestore had no such constraint), applied consistently with this app's own
-- conventions:
--   * aadhaar/contact_no/pin: stripped to digits only (some source rows had
--     'NNNN NNNN NNNN'-style spacing that would overflow the column otherwise)
--   * dis_certi_valid_yn: blank -> 'NOT APPLICABLE' when dis_certi_yn = 'NO'
--     (matches the app's own convention); 'Expired'/'EXPIRED' -> 'NO'
--   * therapy_provide_yn: same NOT APPLICABLE rule when therapy_reqd_yn = 'NO';
--     the literal string 'NULL' in the source data -> real NULL
--   * status: '1' = deleted, anything else = '0' (active/complete) -- these are
--     legacy records, never '2' (incomplete), since that status only applies
--     to records saved through the new wizard
-- References clrc, cluster, disability, school, spledu (all already loaded).
-- appliance, bank, awc, block are NOT in any seed file yet -- FOREIGN_KEY_CHECKS
-- is disabled so this loads regardless, but import those tables too when you can
-- for full referential integrity.

