\encoding UTF8;
/****************************************************************************/
/* GF28 ( 対訳ﾃｰﾌﾞﾙ )                                                       */
/* Created : 2021/06/29 14:03:51                                            */
/****************************************************************************/


ALTER TABLE GF28 DROP CONSTRAINT GF28_UQ;

alter table gf28 add constraint gf28_uq primary key ( uniq );


DROP INDEX GF28_SA;

create index gf28_sa on gf28( system_id,genbun,lang_yaku,kbyaku,id,kbhoryu );


DROP INDEX GF28_SB;

create index gf28_sb on gf28( system_id,id );


DROP INDEX GF28_SC;

create index gf28_sc on gf28( keyword );
