/****************************************************************************/
/* GF28 ( 対訳ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2014/08/09 15:23:02                                            */
/****************************************************************************/

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

ALTER TABLE GF28 DROP CONSTRAINT GF28_LUQ;
ALTER TABLE GF28 ADD CONSTRAINT GF28_LUQ UNIQUE( GENBUN,LANG_YAKU )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

DROP INDEX GF28_SA;
CREATE INDEX GF28_SA ON GF28( ID )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
