/****************************************************************************/
/* GF92 ( 画面項目定義ﾃｰﾌﾞﾙ )                                               */
/* Created : 2017/06/02 17:22:11                                            */
/****************************************************************************/

ALTER TABLE GF92 DROP CONSTRAINT GF92_UQ;
CREATE UNIQUE INDEX GF92_UQ ON GF92( UNIQ );

ALTER TABLE GF92 DROP CONSTRAINT GF92_LUQ;
CREATE UNIQUE INDEX GF92_LUQ ON GF92( SYSTEM_ID,PGID,NMSYORI,SEQ,CLM,TABLE_NAME,AS_TABLE );

DROP INDEX GF92_SA;
CREATE INDEX GF92_SA ON GF92( SYSTEM_ID,PGID,SEQ,CLM );

DROP INDEX GF92_SB;
CREATE INDEX GF92_SB ON GF92( SYSTEM_ID,TABLE_NAME );

DROP INDEX GF92_SC;
CREATE INDEX GF92_SC ON GF92( SYSTEM_ID,CLM );
