/**Begin D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFO', 'T_BDM_OPERATOR_INFO', 'FID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_NUMBER') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFO_NUMBER ON T_BDM_OPERATOR_INFO ( FNUMBER );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_MASTERID') CREATE INDEX IDX_BDM_OPERATOR_INFO_MASTERID ON T_BDM_OPERATOR_INFO ( FMASTERID );

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_CREATE') CREATE INDEX IDX_BDM_OPERATOR_INFO_CREATE ON T_BDM_OPERATOR_INFO ( FCREATEORGID );


 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFO_L', 'T_BDM_OPERATOR_INFO_L', 'FPKID', '0';

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

/**
 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFO_M', 'T_BDM_OPERATOR_INFO_M', 'FORGID', '0';

--  IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_M') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFO_M ON T_BDM_OPERATOR_INFO_M ( FIDX );


 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFO_R3', 'T_BDM_OPERATOR_INFO_R3', 'FID', '0';

--  IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_R3') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFO_R3 ON T_BDM_OPERATOR_INFO_R3 ( FIDX );


 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFO_U', 'T_BDM_OPERATOR_INFO_U', 'FDATAID,FUSEORGID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFO_U') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFO_U ON T_BDM_OPERATOR_INFO_U ( FUSEORGID );


 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFOEXC', 'T_BDM_OPERATOR_INFOEXC', 'FDATAID,FUSEORGID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFOEXC') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFOEXC ON T_BDM_OPERATOR_INFOEXC ( FUSEORGID );


 EXEC P_ALTERPK 'PK_T_BDM_OPERATOR_INFOUSEREG', 'T_BDM_OPERATOR_INFOUSEREG', 'FUSEORGID,FDATAID', '0';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_BDM_OPERATOR_INFOUSEREG') CREATE  CLUSTERED INDEX IDX_BDM_OPERATOR_INFOUSEREG ON T_BDM_OPERATOR_INFOUSEREG ( FDATAID );
**/


/**End D:\pdm\PDM_UPGRADE_1.1\PDM_UPGRADE\pdm1\BDM_constraint.sql **/
