alter table acs_permissions add 
    constraint acs_permiss_creat_user_f_hiyn9 foreign key (creation_user)
      references users(user_id);
alter table acs_permissions add 
    constraint acs_permissi_privilege_f_p76ev foreign key (privilege)
      references acs_privileges(privilege);
alter table acs_permissions add 
    constraint acs_permissio_grant_id_f_vmo0e foreign key (grantee_id)
      references parties(party_id);
alter table acs_permissions add 
    constraint acs_permissio_objec_id_f_5swtm foreign key (object_id)
      references acs_objects(object_id);
alter table acs_stylesheet_node_map add 
    constraint acs_sty_nod_map_nod_id_f_q55q3 foreign key (node_id)
      references site_nodes(node_id);
alter table acs_stylesheet_node_map add 
    constraint acs_sty_nod_map_sty_id_f_guej5 foreign key (stylesheet_id)
      references acs_stylesheets(stylesheet_id);
alter table acs_stylesheet_type_map add 
    constraint acs_sty_typ_map_pac_ty_f_emkua foreign key (package_type_id)
      references apm_package_types(package_type_id);
alter table acs_stylesheet_type_map add 
    constraint acs_sty_typ_map_sty_id_f_38x8p foreign key (stylesheet_id)
      references acs_stylesheets(stylesheet_id);
alter table acs_stylesheets add 
    constraint acs_stylesh_stylesh_id_f_2fiok foreign key (stylesheet_id)
      references acs_objects(object_id);
alter table acs_stylesheets add 
    constraint acs_styleshee_local_id_f_wjfrg foreign key (locale_id)
      references g11n_locales(locale_id);
alter table admin_app add 
    constraint admi_app_applicatio_id_f_e0r3b foreign key (application_id)
      references applications(application_id);
alter table agentportlets add 
    constraint agentport_superport_id_f_9z3yn foreign key (superportlet_id)
      references portlets(portlet_id);
alter table agentportlets add 
    constraint agentportlet_portle_id_f_vi1h4 foreign key (portlet_id)
      references portlets(portlet_id);
alter table apm_package_type_listener_map add 
    constraint apm_pac_typ_lis_map_li_f_i78gw foreign key (listener_id)
      references apm_listeners(listener_id);
alter table apm_package_type_listener_map add 
    constraint apm_pac_typ_lis_map_pa_f_0_qfw foreign key (package_type_id)
      references apm_package_types(package_type_id);
alter table apm_packages add 
    constraint apm_packa_packa_typ_id_f_adr4w foreign key (package_type_id)
      references apm_package_types(package_type_id);
alter table apm_packages add 
    constraint apm_package_package_id_f_46may foreign key (package_id)
      references acs_objects(object_id);
alter table apm_packages add 
    constraint apm_packages_locale_id_f_qlps4 foreign key (locale_id)
      references g11n_locales(locale_id);
alter table application_type_privilege_map add 
    constraint appl_typ_pri_map_app_t_f_kgrfj foreign key (application_type_id)
      references application_types(application_type_id);
alter table application_type_privilege_map add 
    constraint appl_typ_pri_map_privi_f_s3pwb foreign key (privilege)
      references acs_privileges(privilege);
alter table application_types add 
    constraint applica_typ_pac_typ_id_f_v80ma foreign key (package_type_id)
      references apm_package_types(package_type_id);
alter table application_types add 
    constraint applicat_typ_provid_id_f_bm274 foreign key (provider_id)
      references application_types(application_type_id);
alter table applications add 
    constraint applica_applica_typ_id_f_k2bi3 foreign key (application_type_id)
      references application_types(application_type_id);
alter table applications add 
    constraint applica_par_applica_id_f_hvxh7 foreign key (parent_application_id)
      references applications(application_id);
alter table applications add 
    constraint applicati_applicati_id_f_a35g2 foreign key (application_id)
      references acs_objects(object_id);
alter table applications add 
    constraint application_package_id_f_cdaho foreign key (package_id)
      references apm_packages(package_id);
alter table cat_categories add 
    constraint cat_categori_catego_id_f__xtwr foreign key (category_id)
      references acs_objects(object_id);
alter table cat_root_cat_object_map add 
    constraint cat_roo_cat_obj_map_ca_f_jqvmd foreign key (category_id)
      references cat_categories(category_id);
alter table cat_root_cat_object_map add 
    constraint cat_roo_cat_obj_map_ob_f_anfmx foreign key (object_id)
      references acs_objects(object_id);
alter table cms_image_mime_types add 
    constraint cms_ima_mim_typ_mim_ty_f_s0zsx foreign key (mime_type)
      references cms_mime_types(mime_type);
alter table cms_mime_extensions add 
    constraint cms_mim_exten_mim_type_f_7pwwd foreign key (mime_type)
      references cms_mime_types(mime_type);
alter table cms_text_mime_types add 
    constraint cms_tex_mim_typ_mim_ty_f__tubf foreign key (mime_type)
      references cms_mime_types(mime_type);
alter table cw_task_dependencies add 
    constraint cw_tas_depe_dep_tas_id_f_bn0m5 foreign key (dependent_task_id)
      references cw_tasks(task_id);
alter table cw_task_dependencies add 
    constraint cw_tas_dependen_tas_id_f_b1uoz foreign key (task_id)
      references cw_tasks(task_id);
alter table cw_task_group_assignees add 
    constraint cw_tas_gro_assi_gro_id_f_or5kj foreign key (group_id)
      references groups(group_id);
alter table cw_task_group_assignees add 
    constraint cw_tas_gro_assi_tas_id_f_mhi2k foreign key (task_id)
      references cw_user_tasks(task_id);
alter table cw_task_listeners add 
    constraint cw_tas_list_lis_tas_id_f_x1n02 foreign key (listener_task_id)
      references cw_tasks(task_id);
alter table cw_task_listeners add 
    constraint cw_tas_listener_tas_id_f_s2fj9 foreign key (task_id)
      references cw_tasks(task_id);
alter table cw_task_user_assignees add 
    constraint cw_tas_use_assi_tas_id_f_feri7 foreign key (task_id)
      references cw_user_tasks(task_id);
alter table cw_task_user_assignees add 
    constraint cw_tas_use_assi_use_id_f_w856_ foreign key (user_id)
      references users(user_id);
alter table forms_lstnr_rmt_svr_post add 
    constraint form_lst_rmt_svr_pos_l_f_59l2x foreign key (listener_id)
      references bebop_process_listeners(listener_id);
alter table group_member_map add 
    constraint grou_memb_map_membe_id_f_bs3u_ foreign key (member_id)
      references users(user_id);
alter table group_member_map add 
    constraint grou_membe_map_grou_id_f_d7lhm foreign key (group_id)
      references groups(group_id);
alter table group_subgroup_map add 
    constraint grou_subg_map_subgr_id_f_1jo4e foreign key (subgroup_id)
      references groups(group_id);
alter table group_subgroup_map add 
    constraint grou_subgro_map_gro_id_f_todnr foreign key (group_id)
      references groups(group_id);
alter table groups add 
    constraint groups_group_id_f_l4tvr foreign key (group_id)
      references parties(party_id);
alter table init_requirements add 
    constraint init_require_requ_init_f_i6rgg foreign key (required_init)
      references inits(class_name);
alter table init_requirements add 
    constraint init_requirements_init_f_cmmdn foreign key (init)
      references inits(class_name);
alter table lucene_ids add 
    constraint lucene_ids_host_id_f_fcxb8 foreign key (host_id)
      references web_hosts(host_id);
alter table object_container_map add 
    constraint obje_cont_map_conta_id_f_v66b1 foreign key (container_id)
      references acs_objects(object_id);
alter table object_container_map add 
    constraint obje_contai_map_obj_id_f_guads foreign key (object_id)
      references acs_objects(object_id);
alter table object_context add 
    constraint objec_contex_contex_id_f_crdh1 foreign key (context_id)
      references acs_objects(object_id);
alter table object_context add 
    constraint objec_contex_object_id_f_mbuxe foreign key (object_id)
      references acs_objects(object_id);
alter table parties add 
    constraint parties_party_id_f_j4k1i foreign key (party_id)
      references acs_objects(object_id);
alter table party_email_map add 
    constraint part_emai_map_party_id_f_7_00_ foreign key (party_id)
      references parties(party_id);
alter table portals add 
    constraint portals_portal_id_f_kbx1t foreign key (portal_id)
      references applications(application_id);
alter table portlets add 
    constraint portlets_portal_id_f_bombq foreign key (portal_id)
      references portals(portal_id);
alter table portlets add 
    constraint portlets_portlet_id_f_erf4o foreign key (portlet_id)
      references applications(application_id);
alter table roles add 
    constraint role_implicit_group_id_f_o6g0p foreign key (implicit_group_id)
      references groups(group_id);
alter table roles add 
    constraint roles_group_id_f_doyeu foreign key (group_id)
      references groups(group_id);
alter table site_nodes add 
    constraint site_nodes_node_id_f_n1m2y foreign key (node_id)
      references acs_objects(object_id);
alter table site_nodes add 
    constraint site_nodes_object_id_f_ked74 foreign key (object_id)
      references apm_packages(package_id);
alter table site_nodes add 
    constraint site_nodes_parent_id_f_sacav foreign key (parent_id)
      references site_nodes(node_id);
alter table sitemap_app add 
    constraint sitem_app_applicati_id_f_echq6 foreign key (application_id)
      references applications(application_id);
alter table user_authentication add 
    constraint user_authentica_aut_id_f_0bgpj foreign key (auth_id)
      references parties(party_id);
alter table user_authentication add 
    constraint user_authentica_use_id_f_z1jvj foreign key (user_id)
      references users(user_id);
alter table users add 
    constraint users_name_id_f_0xbbm foreign key (name_id)
      references person_names(name_id);
alter table users add 
    constraint users_user_id_f_t_lso foreign key (user_id)
      references parties(party_id);
alter table vcx_blob_operations add 
    constraint vcx_blob_operations_id_f_k6lvg foreign key (id)
      references vcx_operations(id);
alter table vcx_clob_operations add 
    constraint vcx_clob_operations_id_f_a0bts foreign key (id)
      references vcx_operations(id);
alter table vcx_generic_operations add 
    constraint vcx_gener_operation_id_f_ew93q foreign key (id)
      references vcx_operations(id);
alter table vcx_obj_changes add 
    constraint vcx_obj_changes_txn_id_f_e9wcq foreign key (txn_id)
      references vcx_txns(id);
alter table vcx_operations add 
    constraint vcx_operati_eve_typ_id_f_fiy80 foreign key (event_type_id)
      references vcx_event_types(id);
alter table vcx_operations add 
    constraint vcx_operation_chang_id_f_xkahi foreign key (change_id)
      references vcx_obj_changes(id);
alter table vcx_operations add 
    constraint vcx_operation_class_id_f_mqd9i foreign key (class_id)
      references vcx_java_classes(id);
alter table vcx_tags add 
    constraint vcx_tags_txn_id_f_ckn41 foreign key (txn_id)
      references vcx_txns(id);
alter table vcx_txns add 
    constraint vcx_txn_modifying_user_f_c9hs8 foreign key (modifying_user)
      references users(user_id);