File: //opt/cloudlinux/alt-php54/root/usr/share/pear/RVSeagullMod/modules/block/data/constraints.oci.sql
-- ==============================================================
-- create foreign keys
-- ==============================================================
alter table block_assignment add constraint FK_block_assignment_block foreign key (block_id) references block (block_id);
alter table block_assignment add constraint FK_block_assignment_section foreign key (section_id) references section (section_id);
alter table block_role add constraint FK_block_role_block foreign key (block_id) references block (block_id) on delete cascade;
-- alter table block_role add constraint FK_block_role_role foreign key (role_id) references role (role_id) on delete cascade;