/**Begin D:\tool\PDM_UPGRADE\PDM1\HBSS_constraint.sql **/
 EXEC P_ALTERPK 'PK_HBSS_LOGINSCENE', 'T_HBSS_LOGINSCENE', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_LOGINSCENE_NUMBER') CREATE INDEX IDX_HBSS_LOGINSCENE_NUMBER ON T_HBSS_LOGINSCENE ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_LOGINSCENE_L', 'T_HBSS_LOGINSCENE_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_LOGINSCENE_L') CREATE INDEX IDX_HBSS_LOGINSCENE_L ON T_HBSS_LOGINSCENE_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_SAFEURICONFIG', 'T_HBSS_SAFEURICONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_SAFEURICONFIG_NUMBER') CREATE INDEX IDX_HBSS_SAFEURICONFIG_NUMBER ON T_HBSS_SAFEURICONFIG ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_SAFEURICONFIG_L', 'T_HBSS_SAFEURICONFIG_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_SAFEURICONFIG_L') CREATE INDEX IDX_HBSS_SAFEURICONFIG_L ON T_HBSS_SAFEURICONFIG_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_VERIFYCODELOG', 'T_HBSS_VERIFYCODELOG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_VERIFYCODELOG_NUMBER') CREATE INDEX IDX_HBSS_VERIFYCODELOG_NUMBER ON T_HBSS_VERIFYCODELOG ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_VERIFYCODELOG_L', 'T_HBSS_VERIFYCODELOG_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_VERIFYCODELOG_L') CREATE INDEX IDX_HBSS_VERIFYCODELOG_L ON T_HBSS_VERIFYCODELOG_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_SAFEURI', 'T_HBSS_SAFEURI', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_HBSS_SAFEURI_NUMBER') CREATE INDEX IDX_T_HBSS_SAFEURI_NUMBER ON T_HBSS_SAFEURI ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_SAFEURI_L', 'T_HBSS_SAFEURI_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_SAFEURI_L') CREATE INDEX IDX_HBSS_SAFEURI_L ON T_HBSS_SAFEURI_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_HBSS_LOGINCONFIG', 'T_HBSS_LOGINCONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_LOGINCONFIG_NUMBER') CREATE INDEX IDX_HBSS_LOGINCONFIG_NUMBER ON T_HBSS_LOGINCONFIG ( FNUMBER );


 EXEC P_ALTERPK 'PK_HBSS_LOGINCONFIG_L', 'T_HBSS_LOGINCONFIG_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HBSS_LOGINCONFIG_L') CREATE INDEX IDX_HBSS_LOGINCONFIG_L ON T_HBSS_LOGINCONFIG_L ( FID ,FLOCALEID );



/**End D:\tool\PDM_UPGRADE\PDM1\HBSS_constraint.sql **/
