/**业务分类 索引 **/
 EXEC P_ALTERPK 'PK_T_ER_PROJECTTYPE', 'T_ER_PROJECTTYPE', 'FID', '1';

 EXEC P_ALTERPK 'PK_T_ER_PROJECTTYPE_L', 'T_ER_PROJECTTYPE_L', 'FPKID', '1';

 EXEC P_ALTERPK 'PK_T_ER_PROJECTTYPEITEM', 'T_ER_PROJECTTYPEITEM', 'FENTRYID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PROJECTTYPE_FLONGNUMBER') CREATE INDEX IDX_ER_PROJECTTYPE_FLONGNUMBER ON T_ER_PROJECTTYPE ( FLONGNUMBER );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PROJECTTYPE_FLOCALEID') CREATE INDEX IDX_ER_PROJECTTYPE_FLOCALEID ON T_ER_PROJECTTYPE_L ( FLOCALEID );

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_ER_PROJECTTYPEITEM_FSEQ') CREATE INDEX IDX_ER_PROJECTTYPEITEM_FSEQ ON T_ER_PROJECTTYPEITEM ( FSEQ );
