\encoding UTF8;
/****************************************************************************/
/* GF62 ( ﾌﾟﾛｼﾞｪｸﾄﾏｽﾀ定義 )                                                 */
/* Created : 2020/11/13 12:48:33                                            */
/****************************************************************************/


ALTER TABLE GF62 DROP CONSTRAINT GF62_UQ;

alter table gf62 add constraint gf62_uq primary key ( uniq );


ALTER TABLE GF62 DROP CONSTRAINT GF62_LUQ;

alter table gf62 add constraint gf62_luq unique( prjcode );


DROP INDEX GF62_SA;

create index gf62_sa on gf62( name_ja );


DROP INDEX GF62_SB;

create index gf62_sb on gf62( view_date );
