/**Begin D:\PDM_UPGRADE\PDM1\EB_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_EB_SCHEMECATALOG_L', 'T_EB_SCHEMECATALOG_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_EB_SCHEMEENTRY_L', 'T_EB_SCHEMEENTRY_L', 'FPKID', '1';

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


 EXEC P_ALTERPK 'PK_T_EB_SCHEMEDIMMAP', 'T_EB_SCHEMEDIMMAP', 'FENTRYID', '1';

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


 EXEC P_ALTERPK 'PK_T_EB_SCHEMEENTRY', 'T_EB_SCHEMEENTRY', 'FID', '1';

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

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_EB_SCHEMEENTRY_CATALOG') CREATE INDEX IDX_EB_SCHEMEENTRY_CATALOG ON T_EB_SCHEMEENTRY ( FSCHEMECATALOG );



/**End D:\PDM_UPGRADE\PDM1\EB_constraint.sql **/
