/****************************************************************************/
/* GF43 ( 集計表ｻﾝﾌﾟﾙ )                                                     */
/* Created : 2014/08/09 15:23:02                                            */
/****************************************************************************/

ALTER TABLE GF43 DROP CONSTRAINT GF43_UQ;
ALTER TABLE GF43 ADD CONSTRAINT GF43_UQ PRIMARY KEY ( YYYY,MM,BLOCK,BRANCH )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );

DROP INDEX GF43_SA;
CREATE INDEX GF43_SA ON GF43( BLOCK,BRANCH )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
