/****************************************************************************/
/* GEA10 ( ﾕｰｻﾞｰ定義 )                                                      */
/* Created : 2014/08/09 15:22:59                                            */
/****************************************************************************/

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

DROP INDEX GEA10_SA;
CREATE INDEX GEA10_SA ON GEA10( SYSTEM_ID,USERID,ROLES,FGJ )
TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
