You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
db-schema/db_scripts/diff/15216.down

14 lines
399 B

set autocommit=0;
USE provisioning;
ALTER TABLE provisioning.rtc_session
DROP FOREIGN KEY tl_subscriber_ref,
DROP KEY subscriber_idx;
ALTER TABLE provisioning.rtc_session
ADD UNIQUE KEY subscriber_idx (subscriber_id),
ADD CONSTRAINT tl_subscriber_ref FOREIGN KEY subscriber_idx (subscriber_id)
REFERENCES voip_subscribers (id) ON DELETE CASCADE ON UPDATE CASCADE;
commit;