\encoding UTF8;
/****************************************************************************/
/* GE50 ( 帳票要求ﾃｰﾌﾞﾙ )                                                   */
/* Created : 2021/06/29 13:33:22                                            */
/****************************************************************************/


ALTER TABLE GE50 DROP CONSTRAINT GE50_UQ;

alter table ge50 add constraint ge50_uq primary key ( system_id,ykno );


DROP INDEX GE50_SA;

create index ge50_sa on ge50( system_id,listid,groupid,ykno );


DROP INDEX GE50_SB;

create index ge50_sb on ge50( fgj,fgkan );


DROP INDEX GE50_SC;

create index ge50_sc on ge50( system_id,dyset );
