/****************************************************************************/
/* GF90 ( 青紙ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2014/05/21 18:36:35                                            */
/****************************************************************************/

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

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

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

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

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

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

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