/****************************************************************************/
/* GF28 ( 対訳ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2014/02/06 11:03:29                                            */
/****************************************************************************/

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 )
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 );
