
EXEC p_DropIdx 'IDX_FID_ROLEID', 'T_PERM_BIZROLECOMROLE';
EXEC p_DropIdx 'IDX_T_PERM_BIZROLECOMROLE_FID', 'T_PERM_BIZROLECOMROLE';
EXEC p_DropIdx 'IDX_BIZROLECOMROLE_FID', 'T_PERM_BIZROLECOMROLE';
EXEC p_DropIdx 'IDX_BIZROLECOMROLE_FROLEID', 'T_PERM_BIZROLECOMROLE';



IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_PERM_BIZROLECOMROLE' AND KSQL_INDNAME = 'IDX_BIZROLECOMROLE_FID')
CREATE INDEX IDX_BIZROLECOMROLE_FID ON T_PERM_BIZROLECOMROLE (FID );


IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_PERM_BIZROLECOMROLE' AND KSQL_INDNAME = 'IDX_BIZROLECOMROLE_FROLEID')
CREATE INDEX IDX_BIZROLECOMROLE_FROLEID ON T_PERM_BIZROLECOMROLE (FROLEID );

