工事管理システム製品化対応

-- ?H????????

DROP TABLE IF EXISTS constructionmaterialinfo_OLD;

CREATE TABLE constructionmaterialinfo_OLD As Select * from constructionmaterialinfo ;

drop table if exists constructionmaterialinfo cascade;

create table constructionmaterialinfo (

  CONSTRUCTIONCODE int(10) unsigned default 0 not null comment '?H?????'

  , MATERIALITEMCODE smallint(5) unsigned default 0 not null comment '????i??R?[?h'

  , PROCESSDATE	datetime comment '?????N????'

  , RENTCOUNT smallint(5) unsigned comment '??o??'

  , REPAYCOUNT smallint(5) unsigned comment '??p??'

  , JUNKCOUNT smallint(5) unsigned comment '?j????'

  , COMPLETEFLG tinyint(3) unsigned comment '?????t???O'

  , ENTRYDATE datetime comment '?o?^???t'

  , UPDATEDATE datetime comment '?X?V???t'

  , constraint constructionmaterialinfo_PKC primary key (CONSTRUCTIONCODE,MATERIALITEMCODE,PROCESSDATE)

) comment '?H????????' ;

Insert INTO constructionmaterialinfo

SELECT

  CONSTRUCTIONCODE

  , MATERIALITEMCODE

  , DATE(ENTRYDATE)

  , RENTCOUNT

  , REPAYCOUNT

  , 0

  , COMPLETEFLG

  , ENTRYDATE

  , UPDATEDATE

FROM constructionmaterialinfo_OLD

;

commit;