/**Begin E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A000000_DYN', 'T_TCCIT_QYSDS_A000000_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A000000_DYN' AND KSQL_INDNAME = 'IDX_A000000_DYN_FSBBID') CREATE INDEX IDX_A000000_DYN_FSBBID ON T_TCCIT_QYSDS_A000000_DYN ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107011_DY1', 'T_TCCIT_QYSDS_A107011_DY1', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A107011_DY1' AND KSQL_INDNAME = 'IDX_A107011_DY1_FSBBID') CREATE INDEX IDX_A107011_DY1_FSBBID ON T_TCCIT_QYSDS_A107011_DY1 ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A107011_DYN', 'T_TCCIT_QYSDS_A107011_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A107011_DYN' AND KSQL_INDNAME = 'IDX_A107011_DYN_FSBBID') CREATE INDEX IDX_A107011_DYN_FSBBID ON T_TCCIT_QYSDS_A107011_DYN ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108000_DYN', 'T_TCCIT_QYSDS_A108000_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A108000_DYN' AND KSQL_INDNAME = 'IDX_A108000_DYN_FSBBID') CREATE INDEX IDX_A108000_DYN_FSBBID ON T_TCCIT_QYSDS_A108000_DYN ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108010_DYN', 'T_TCCIT_QYSDS_A108010_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A108010_DYN' AND KSQL_INDNAME = 'IDX_A108010_DYN_FSBBID') CREATE INDEX IDX_A108010_DYN_FSBBID ON T_TCCIT_QYSDS_A108010_DYN ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A108030_DYN', 'T_TCCIT_QYSDS_A108030_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A108030_DYN' AND KSQL_INDNAME = 'IDX_A108030_DYN_FSBBID') CREATE INDEX IDX_A108030_DYN_FSBBID ON T_TCCIT_QYSDS_A108030_DYN ( FSBBID );


 EXEC P_ALTERPK 'PK_TCCIT_QYSDS_A109010_DYN', 'T_TCCIT_QYSDS_A109010_DYN', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_TABNAME = 'T_TCCIT_QYSDS_A109010_DYN' AND KSQL_INDNAME = 'IDX_A109010_DYN_FSBBID') CREATE INDEX IDX_A109010_DYN_FSBBID ON T_TCCIT_QYSDS_A109010_DYN ( FSBBID );



/**End E:\NextERP_PDM\PDM_UPGRADE\PDMS\branch_lastest\pdm\TCCIT_constraint.sql **/
