/****************************************************************************/
/* GF93 ( 画面項目ﾘﾝｸ )                                                     */
/* Created : 2014/06/09 10:22:45                                            */
/****************************************************************************/

ALTER TABLE GF93 DROP CONSTRAINT GF93_UQ;
ALTER TABLE GF93 ADD CONSTRAINT GF93_UQ PRIMARY KEY ( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

ALTER TABLE GF93 DROP CONSTRAINT GF93_LUQ;
ALTER TABLE GF93 ADD CONSTRAINT GF93_LUQ UNIQUE( SYSTEM_ID,PGID,SEQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

DROP INDEX GF93_SA;
CREATE INDEX GF93_SA ON GF93( SYSTEM_ID,PGID,NMSYORI,CLM,HREF )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
