\encoding UTF8;
/****************************************************************************/
/* GF84 ( 移行DB一覧 )                                                      */
/* Created : 2021/06/29 14:03:51                                            */
/****************************************************************************/


ALTER TABLE GF84 DROP CONSTRAINT GF84_UQ;

alter table gf84 add constraint gf84_uq primary key ( uniq );


ALTER TABLE GF84 DROP CONSTRAINT GF84_LUQ;

alter table gf84 add constraint gf84_luq unique( system_id,nojun,table_name );


DROP INDEX GF84_SA;

create index gf84_sa on gf84( system_id,table_name );


DROP INDEX GF84_SB;

create index gf84_sb on gf84( system_id,cdikou,nojun );
