/**Begin D:\pdm\PDM_UPGRADE\pdm_new\BDM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BDM_BLACKLIST_CONFIG', 'T_BDM_BLACKLIST_CONFIG', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_BLACKLIST') CREATE INDEX IDX_BDM_BLACKLIST ON T_BDM_BLACKLIST_CONFIG ( FNUMBER ,FNAME );


 EXEC P_ALTERPK 'PK_T_BDM_BLACKLIST_CONFIG_L', 'T_BDM_BLACKLIST_CONFIG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_BDM_SENSITIVE_WORDLIST', 'T_BDM_SENSITIVE_WORDLIST', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_SENSITIVE') CREATE INDEX IDX_BDM_SENSITIVE ON T_BDM_SENSITIVE_WORDLIST ( FNUMBER ,FNAME );


 EXEC P_ALTERPK 'PK_T_BDM_SENSITIVE_WORDLIST_L', 'T_BDM_SENSITIVE_WORDLIST_L', 'FPKID', '1';

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



/**End D:\pdm\PDM_UPGRADE\pdm_new\BDM_constraint.sql **/
