ALTER TABLE tx_horaire DROP FOREIGN KEY FK_FDF12FFB7C436EFD;
DROP INDEX IDX_FDF12FFB7C436EFD ON tx_horaire;
ALTER TABLE tx_horaire CHANGE tx_vhc_cat_id tx_rdc_id INT DEFAULT NULL;
ALTER TABLE tx_horaire ADD CONSTRAINT FK_FDF12FFB7BA5AC84 FOREIGN KEY (tx_rdc_id) REFERENCES tx_reduction (id) ON DELETE SET NULL;
CREATE INDEX IDX_FDF12FFB7BA5AC84 ON tx_horaire (tx_rdc_id);