/****************************************************************************/
/* GEA08 ( 項目名称定義(ﾗﾍﾞﾙ) )                                             */
/* Created : 2021/06/29 13:32:29                                            */
/****************************************************************************/


ALTER TABLE GEA08 DROP CONSTRAINT GEA08_UQ;

ALTER TABLE GEA08 ADD CONSTRAINT GEA08_UQ PRIMARY KEY ( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


DROP INDEX GEA08_SA;

CREATE INDEX GEA08_SA ON GEA08( SYSTEM_ID,LANG,CLM,KBSAKU,FGJ )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K )
;


DROP INDEX GEA08_SB;

CREATE INDEX GEA08_SB ON GEA08( SYSTEM_ID,FGJ,LANG,KBSAKU,CLM )
TABLESPACE GFTBL01
STORAGE( INITIAL 64K )
;
