\encoding UTF8;
/****************************************************************************/
/* GF77 ( ﾀｸﾞ検索ﾃｰﾌﾞﾙ )                                                    */
/* Created : 2021/06/29 14:03:51                                            */
/****************************************************************************/


ALTER TABLE GF77 DROP CONSTRAINT GF77_UQ;

alter table gf77 add constraint gf77_uq primary key ( uniq );


DROP INDEX GF77_SA;

create index gf77_sa on gf77( system_id,fgomit,tagname );


DROP INDEX GF77_SB;

create index gf77_sb on gf77( system_id );


DROP INDEX GF77_SC;

create index gf77_sc on gf77( system_id,tblsyu,address,filename,tagname );
