HEX
Server: Apache
System: Linux sg241.singhost.net 2.6.32-896.16.1.lve1.4.51.el6.x86_64 #1 SMP Wed Jan 17 13:19:23 EST 2018 x86_64
User: honghock (909)
PHP: 8.0.30
Disabled: passthru,system,shell_exec,show_source,exec,popen,proc_open
Upload Files
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;