/**************************************************************************/
/* GF71 ( 画面関連状態テーブル )                                          */
/* Created : 2009/10/02 11:56:30                                          */
/**************************************************************************/

ALTER TABLE GF71 ADD CONSTRAINT GF71_UQ UNIQUE( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 128K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF71_SA ON GF71( SYSTEM_ID,FGOMIT,ADDRESS,FILENAME,TAGNAME )
TABLESPACE GEIDX01
STORAGE( INITIAL 192K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF71_SB ON GF71( SYSTEM_ID,FGOMIT,TO_GAMENID )
TABLESPACE GEIDX01
STORAGE( INITIAL 128K NEXT 16K PCTINCREASE 0 );

