/**************************************************************************/
/* GF79 ( リソース抜出テーブル )                                          */
/* Created : 2011/11/01 14:24:48                                          */
/**************************************************************************/

ALTER TABLE GF79 ADD CONSTRAINT GF79_UQ PRIMARY KEY ( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 320K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF79_SA ON GF79( SYSTEM_ID,SOURCE,FILENAME,TAGNAME )
TABLESPACE GEIDX01
STORAGE( INITIAL 1024K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF79_SB ON GF79( SYSTEM_ID,NAME_JA )
TABLESPACE GEIDX01
STORAGE( INITIAL 512K NEXT 16K PCTINCREASE 0 );

