ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS mode VARCHAR(32) NOT NULL DEFAULT '';
ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS result_json TEXT NULL DEFAULT NULL;
ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS passed TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS test_type VARCHAR(32) NOT NULL DEFAULT '';
ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS status VARCHAR(16) NOT NULL DEFAULT 'unknown';
ALTER TABLE cable_test_results ADD COLUMN IF NOT EXISTS result_data JSON NULL DEFAULT NULL;
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS mode VARCHAR(32) NOT NULL DEFAULT '';
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS result_json TEXT NULL DEFAULT NULL;
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS passed TINYINT(1) NOT NULL DEFAULT 0;
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS test_type VARCHAR(32) NOT NULL DEFAULT '';
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS status VARCHAR(16) NOT NULL DEFAULT 'unknown';
ALTER TABLE ftt_cable_test_results ADD COLUMN IF NOT EXISTS result_data JSON NULL DEFAULT NULL;
