/**Begin D:\文档\DBA\PDM_UPGRADE\pdm1\SYS_constraint.sql **/
 EXEC P_ALTERPK 'PK_T_SVC_CUSTOMPARAM', 'T_SVC_CUSTOMPARAM', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SCUSTOMPARAM_NUM') CREATE UNIQUE INDEX IDX_SCUSTOMPARAM_NUM ON T_SVC_CUSTOMPARAM ( FNUMBER );

 EXEC P_ALTERPK 'PK_T_SVC_CUSTOMPARAM_L', 'T_SVC_CUSTOMPARAM_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_CUSTOMPARAM_L_N') CREATE UNIQUE INDEX IDX_CUSTOMPARAM_L_N ON T_SVC_CUSTOMPARAM_L ( FID ,FLOCALEID );


 EXEC P_ALTERPK 'PK_T_SVC_SYSPARAM_GROUP', 'T_SVC_SYSPARAM_GROUP', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SYSPARAM_GROUP_NUM') CREATE UNIQUE INDEX IDX_SYSPARAM_GROUP_NUM ON T_SVC_SYSPARAM_GROUP ( FNUMBER );

 EXEC P_ALTERPK 'PK_T_SVC_SYSPARAM_GROUP_L', 'T_SVC_SYSPARAM_GROUP_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_SYSPARAM_GROUP_U') CREATE UNIQUE INDEX IDX_SYSPARAM_GROUP_U ON T_SVC_SYSPARAM_GROUP_L ( FID ,FLOCALEID );

/**End D:\文档\DBA\PDM_UPGRADE\pdm1\SYS_constraint.sql **/
