\encoding UTF8;
/****************************************************************************/
/* GE80 ( FAQﾃｰﾌﾞﾙ )                                                        */
/* Created : 2021/06/29 13:33:22                                            */
/****************************************************************************/


ALTER TABLE GE80 DROP CONSTRAINT GE80_UQ;

alter table ge80 add constraint ge80_uq primary key ( uniq );


DROP INDEX GE80_SA;

create index ge80_sa on ge80( system_id,syscode,seqno );


DROP INDEX GE80_SB;

create index ge80_sb on ge80( system_id,syscode,kbfaq,qano );


DROP INDEX GE80_SC;

create index ge80_sc on ge80( system_id,syscode,title );


DROP INDEX GE80_SD;

create index ge80_sd on ge80( system_id,syscode,tag );
