<?xml version='1.0' encoding='UTF-8'?>
<ROWSET tableName='GF69'>
/**************************************************************************/
/* GF69 ( 不具合対策管理テーブル )                                        */
/* Created : 2010/05/07 16:07:34                                          */
/**************************************************************************/

<EXEC_SQL>
ALTER TABLE GF69 ADD CONSTRAINT GF69_UQ UNIQUE( UNIQ )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 64K NEXT 16K PCTINCREASE 0 )
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF69_SA ON GF69( PRJCODE,PHASE,SEQNO )
TABLESPACE GEIDX01
STORAGE( INITIAL 64K NEXT 16K PCTINCREASE 0 )
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF69_SB ON GF69( PRJCODE,PHASE,DYYOTE )
TABLESPACE GEIDX01
STORAGE( INITIAL 64K NEXT 16K PCTINCREASE 0 )
</EXEC_SQL>

<EXEC_SQL>
CREATE INDEX GF69_SC ON GF69( RESOURCE_ID )
TABLESPACE GEIDX01
STORAGE( INITIAL 64K NEXT 16K PCTINCREASE 0 )
</EXEC_SQL>

</ROWSET>
