• Home
• org.beangle.ems
• beangle-ems-core_3
• 4.8.11
• source code
• 3-indices.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.postgresql.init.3-indices.sql Maven / Gradle / Ivy

create index idx_hoy2tgjrxebjvagxqmx2si8ni on ems.cfg_data_sources (app_id);
create index idx_pgw44gaecxm9xuoof339kk0lk on ems.cfg_dbs_properties (db_id);
create index idx_opepxkjkhbladb0xpr1872yea on ems.cfg_portalets_categories (portalet_id);
create index idx_e3q5c6y7hn6lgi1oyolmlrpk8 on ems.oa_docs_categories (doc_id);
create index idx_m9p3e4v2m389xtm186dgaomkp on ems.oa_notices_categories (notice_id);
create index idx_70rqx45v5adl1w9nmbikff5i6 on ems.oa_notices_docs (notice_id);
create index idx_fy9icugi55g32afdp7dpya5tl on ems.se_func_permissions (role_id);
create index idx_chjpjbdcov744gg5lq2de7rx3 on ems.se_menus (entry_id);
create index idx_epksu8lgd3h8wadnbbot7b7rx on ems.se_menus (parent_id);
create index idx_fdatks2vdh1idedyu5f6fb55l on ems.se_menus (app_id);
create index idx_7e3okgphh4xg8fc1b4tja9y4c on ems.se_menus_resources (menu_id);
create index idx_gmkv8u0xj7n6y30xyktoyrv4 on ems.usr_accounts (user_id);
create index idx_11e6s0dtw3vhdlw8deeqjyjmm on ems.usr_group_members (user_id);
create index idx_p2ie3eruw2n208yac0nconf86 on ems.usr_group_members (group_id);
create index idx_ipnyuvhd24x9n5xbrtpwocnol on ems.usr_groups (parent_id);
create index idx_i3prbvnl2ky3fs3w4o8jgq2ya on ems.usr_groups_properties (group_id);
create index idx_user_profile on ems.usr_profiles (user_id, domain_id);
create index idx_1jhdyxjnm417qgm96nwuinixt on ems.usr_profiles_properties (profile_id);
create index idx_kkhkte6jpxqrhc34y496ujdeg on ems.usr_role_members (role_id);
create index idx_role_member_user on ems.usr_role_members (user_id);
create index idx_ovw4p7sme2a30wkyoo7deyelo on ems.usr_roles (parent_id);
create index idx_owjdmrm6x6pqepg35o33y7bti on ems.usr_roles_properties (role_id);