ALTER TABLE tx_besoin_particulier_number DROP FOREIGN KEY FK_A995044EED4AA709;
DROP INDEX IDX_A995044EED4AA709 ON tx_besoin_particulier_number;
ALTER TABLE tx_besoin_particulier_number DROP PRIMARY KEY;
ALTER TABLE tx_besoin_particulier_number ADD tx_reservation_libre_id INT NOT NULL, DROP tx_resr;
ALTER TABLE tx_besoin_particulier_number ADD CONSTRAINT FK_A995044EE82A079A FOREIGN KEY (tx_reservation_libre_id) REFERENCES tx_reservation_libre (id);
CREATE INDEX IDX_A995044EE82A079A ON tx_besoin_particulier_number (tx_reservation_libre_id);
ALTER TABLE tx_besoin_particulier_number ADD PRIMARY KEY (tx_besoin_particulier_id, tx_reservation_id, tx_reservation_libre_id);
