/**Begin C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
 EXEC P_ALTERPK 'PK_SRC_BIZITEM', 'T_SRC_BIZITEM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIZITEM_FCREATETIME') CREATE INDEX IDX_SRC_BIZITEM_FCREATETIME ON T_SRC_BIZITEM ( FCREATETIME );

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

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


 EXEC P_ALTERPK 'PK_SRC_BIZSCHEME', 'T_SRC_BIZSCHEME', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIZSCHEME_FCREATETIME') CREATE INDEX IDX_SRC_BIZSCHEME_FCREATETIME ON T_SRC_BIZSCHEME ( FCREATETIME );

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

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


 EXEC P_ALTERPK 'PK_SRC_BIZSCHEMESRCTYPE', 'T_SRC_BIZSCHEMESRCTYPE', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIZSCHEMESRCFLOW', 'T_SRC_BIZSCHEMESRCFLOW', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_SRC_BIZITEM_L', 'T_SRC_BIZITEM_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIZITEM_L_FNAME') CREATE INDEX IDX_SRC_BIZITEM_L_FNAME ON T_SRC_BIZITEM_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_BIZSCHEME_L', 'T_SRC_BIZSCHEME_L', 'FPKID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SRC_BIZSCHEME_L_FNAME') CREATE INDEX IDX_SRC_BIZSCHEME_L_FNAME ON T_SRC_BIZSCHEME_L ( FNAME );


 EXEC P_ALTERPK 'PK_SRC_BIZSCHEMEENTRY', 'T_SRC_BIZSCHEMEENTRY', 'FENTRYID', '1';

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



/**End C:\PDM_UPGRADE\PDM1\SRC_constraint.sql **/
