/**许可校验日志加索引 **/
 EXEC P_ALTERPK 'PK_T_LIC_LICCHECKLOG', 'T_LIC_LICCHECKLOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_LIC_LICCHECKLOG_TRACEID') CREATE INDEX IDX_LIC_LICCHECKLOG_TRACEID ON T_LIC_LICCHECKLOG ( FTRACEID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_LIC_LICCHECKLOG_UAOID') CREATE INDEX IDX_LIC_LICCHECKLOG_UAOID ON T_LIC_LICCHECKLOG ( FUSERID ,FBIZAPPID ,FBIZOBJECTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_LIC_LICCHECKLOG_APPOBJECT') CREATE INDEX IDX_LIC_LICCHECKLOG_APPOBJECT ON T_LIC_LICCHECKLOG ( FBIZAPPID ,FBIZOBJECTID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_LIC_LICCHECKLOG_OBJECT') CREATE INDEX IDX_LIC_LICCHECKLOG_OBJECT ON T_LIC_LICCHECKLOG ( FBIZOBJECTID );


 EXEC P_ALTERPK 'PK_T_LIC_LICCHECKLOGENTRY', 'T_LIC_LICCHECKLOGENTRY', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_LIC_LICCHECKLOGENTRY_ID') CREATE INDEX IDX_LIC_LICCHECKLOGENTRY_ID ON T_LIC_LICCHECKLOGENTRY ( FID );