alter table catalog drop constraint aa;

alter table catalog add constraint
       ( foreign key (stock_num, manu_code) references stock
       on delete cascade constraint ab);