\encoding UTF8;
/****************************************************************************/
/* GE81 ( 新着情報ﾃｰﾌﾞﾙ )                                                   */
/* Created : 2021/06/29 13:33:22                                            */
/****************************************************************************/


ALTER TABLE GE81 DROP CONSTRAINT GE81_UQ;

alter table ge81 add constraint ge81_uq primary key ( uniq );


DROP INDEX GE81_SA;

create index ge81_sa on ge81( system_id,syscode,dystrd );


DROP INDEX GE81_SB;

create index ge81_sb on ge81( system_id,syscode,cddeg,dystrd );


DROP INDEX GE81_SC;

create index ge81_sc on ge81( system_id,syscode,tag );


DROP INDEX GE81_SD;

create index ge81_sd on ge81( system_id,syscode,mand );
