\encoding UTF8;
/****************************************************************************/
/* GF65 ( ﾌﾟﾛｼﾞｪｸﾄﾘｿｰｽ定義 )                                                */
/* Created : 2020/11/13 12:48:33                                            */
/****************************************************************************/


ALTER TABLE GF65 DROP CONSTRAINT GF65_UQ;

alter table gf65 add constraint gf65_uq primary key ( uniq );


ALTER TABLE GF65 DROP CONSTRAINT GF65_LUQ;

alter table gf65 add constraint gf65_luq unique( prjcode,resource_id );


DROP INDEX GF65_SA;

create index gf65_sa on gf65( prjcode,seq );
