/****************************************************************************/
/* GF90 ( 青紙ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2014/06/09 10:22:51                                            */
/****************************************************************************/

ALTER TABLE GF90 DROP INDEX GF90_UQ;
ALTER TABLE GF90 ADD CONSTRAINT GF90_UQ PRIMARY KEY ( UNIQ );

ALTER TABLE GF90 DROP INDEX GF90_LUQ;
ALTER TABLE GF90 ADD CONSTRAINT GF90_LUQ UNIQUE( SYSTEM_ID,PGID,CDSAKU );

ALTER TABLE GF90 DROP INDEX GF90_SA;
CREATE INDEX GF90_SA ON GF90( SYSTEM_ID,SEQ );

ALTER TABLE GF90 DROP INDEX GF90_SB;
CREATE INDEX GF90_SB ON GF90( SIYOSAKU );

ALTER TABLE GF90 DROP INDEX GF90_SC;
CREATE INDEX GF90_SC ON GF90( PGSAKU );

ALTER TABLE GF90 DROP INDEX GF90_SD;
CREATE INDEX GF90_SD ON GF90( PGKEN );

ALTER TABLE GF90 DROP INDEX GF90_SE;
CREATE INDEX GF90_SE ON GF90( CDSAKU );
