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

-- ???P???}?X?^

drop table if exists constructionspecunitprice_OLD cascade;

CREATE TABLE constructionspecunitprice_OLD As Select * from constructionspecunitprice;

drop table if exists constructionspecunitprice cascade;

create table constructionspecunitprice (

  ConstructionTypeCode mediumint(8) unsigned not null comment '?H?????R?[?h'

  , ComponentCode decimal(5,0) unsigned not null comment '?\???L?['

  , ItemCode decimal(5,0) unsigned not null comment '?H??L?['

  , SpecCode decimal(5,0) unsigned not null comment '???L?['

  , UnitPrice decimal(9,2) not null comment '?P??'

  , EntryDate datetime not null comment '?o?^???t'

  , UpdateDate datetime not null comment '?X?V???t'

  , constraint constructionspecunitprice_PKC primary key (ConstructionTypeCode,ComponentCode,ItemCode,SpecCode)

) comment '???P???}?X?^' ;

create index constructionspecunitprice_Index1

  on constructionspecunitprice(ConstructionTypeCode,ComponentCode,ItemCode);

create index constructionspecunitprice_Index2

  on constructionspecunitprice(ItemCode,SpecCode);

Insert INTO constructionspecunitprice

SELECT

  ConstructionTypeCode

  , ComponentCode

  , ItemCode

  , SpecCode

  , UnitPrice

  , EntryDate

  , UpdateDate

FROM constructionspecunitprice_OLD

;

commit;