/****************************************************************************/
/* GF63 ( ﾘｿｰｽﾏｽﾀ定義 )                                                     */
/* Created : 2014/06/09 10:22:45                                            */
/****************************************************************************/

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

ALTER TABLE GF63 DROP CONSTRAINT GF63_LUQ;
ALTER TABLE GF63 ADD CONSTRAINT GF63_LUQ UNIQUE( RESOURCE_ID )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

DROP INDEX GF63_SA;
CREATE INDEX GF63_SA ON GF63( CDBUN,CDRSC )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
