/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\IM_constraint.sql **/
-- 界面配置-界面按钮配置表索引
EXEC P_ALTERPK 'PK_T_IM_WB_INTERFACECFG_BT_E', 'T_IM_WB_INTERFACECFG_BT_E', 'FENTRYID', '1';

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

 
-- 工作台最近操作记录表索引
EXEC P_ALTERPK 'PK_T_IM_WB_RECENT_OP_RECORD', 'T_IM_WB_RECENT_OP_RECORD', 'FID', '1';

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_IM_WB_RECENT_OP_RECORD' AND KSQL_INDNAME = 'IDX_IM_WB_RECENT_OP_RECORD_CR_INTCFG') CREATE INDEX IDX_IM_WB_RECENT_OP_RECORD_CR_INTCFG ON T_IM_WB_RECENT_OP_RECORD ( FCREATORID,FINTERFACECFGID );


/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\IM_constraint.sql **/