\encoding UTF8;
/****************************************************************************/
/* GE12 ( ｼｽﾃﾑﾊﾟﾗﾒｰﾀ定義 )                                                  */
/* Created : 2021/06/29 13:33:22                                            */
/****************************************************************************/


ALTER TABLE GE12 DROP CONSTRAINT GE12_UQ;

alter table ge12 add constraint ge12_uq primary key ( uniq );


ALTER TABLE GE12 DROP CONSTRAINT GE12_LUQ;

alter table ge12 add constraint ge12_luq unique( system_id,param_id,kbsaku,contxt_path,fgj );


DROP INDEX GE12_SA;

create index ge12_sa on ge12( system_id,contxt_path,fgj,kbsaku,seqno );


DROP INDEX GE12_SB;

create index ge12_sb on ge12( system_id,seqno );
