/****************************************************************************/
/* GE31 ( 定型文ﾏｽﾀ )                                                       */
/* Created : 2014/01/09 16:35:06                                            */
/****************************************************************************/

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

ALTER TABLE GE31 DROP CONSTRAINT GE31_LUQ;
ALTER TABLE GE31 ADD CONSTRAINT GE31_LUQ UNIQUE( SYSTEM_ID,PTN_ID )
USING INDEX TABLESPACE GEIDX01
STORAGE( INITIAL 16K NEXT 16K PCTINCREASE 0 );
