/****************************************************************************/
/* GF90 ( 青紙ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2013/09/03 10:23:35                                            */
/****************************************************************************/

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

ALTER TABLE GF90 ADD CONSTRAINT GF90_LUQ UNIQUE( SYSTEM_ID,PGID,CDSAKU )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF90_SA ON GF90( SYSTEM_ID,SEQ )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF90_SB ON GF90( SIYOSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF90_SC ON GF90( PGSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF90_SD ON GF90( PGKEN )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

CREATE INDEX GF90_SE ON GF90( CDSAKU )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
