/**Begin D:\PDM_UPGRADE\PDM1\HRSS_constraint.sql **/

 EXEC p_DropIdx 'IDX_HRSS_USERSEARCHLOG', 'T_HRSS_USERSEARCHLOG';
 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_HRSS_USERSEARCHLOG' AND KSQL_INDNAME = 'IDX_HRSS_USERSEARCHLOG') CREATE INDEX IDX_HRSS_USERSEARCHLOG ON T_HRSS_USERSEARCHLOG ( FSEARCHSCENEID ,FSEARCHPAGEID ,FSEARCHKEY );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_HRSS_USERSEARCHLOG' AND KSQL_INDNAME = 'IDX_HRSS_USERSEARCHLOG_USER') CREATE INDEX IDX_HRSS_USERSEARCHLOG_USER ON T_HRSS_USERSEARCHLOG ( FUSERID );

 EXEC P_ALTERPK 'PK_HRSS_SYNCERRORLOG', 'T_HRSS_SYNCERRORLOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_HRSS_SYNCERRORLOG' AND KSQL_INDNAME = 'IDX_HRSS_SYNCERRORLOG') CREATE INDEX IDX_HRSS_SYNCERRORLOG ON T_HRSS_SYNCERRORLOG ( FESSYNRECORDID );



/**End D:\PDM_UPGRADE\PDM1\HRSS_constraint.sql **/
