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

-- ??????????f?[?^

DROP TABLE IF EXISTS purchaseorderdetail_OLD;

CREATE TABLE purchaseorderdetail_OLD As Select * from purchaseorderdetail;

drop table if exists purchaseorderdetail cascade;

create table purchaseorderdetail (

  ConstructionCode decimal(10,0) unsigned not null comment '?H???R?[?h'

  , SeqNo decimal(3,0) unsigned not null comment '???????}??'

  , GroupCount decimal(1,0) not null comment '?O???[?v???'

  , LineCount decimal(3,0) unsigned not null comment '?s???'

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

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

  , FirstString varchar(120) comment '?H??E?i??'

  , SecondString varchar(120) comment '???e????'

  , UnitCount decimal(8,2) not null comment '????'

  , UnitName varchar(30) comment '?P??'

  , UnitPrice decimal(10,0) not null comment '?P??'

  , OrdersLinePrice decimal(12,0) comment '???z'

  , SourceCode decimal(10,0) unsigned not null comment '?\?Z?????H?????'

  , SourceLineCnt decimal(3,0) unsigned not null comment '?????????????s???'

  , DataTypeFlag decimal(1,0) unsigned not null comment '?f?[?^?^?C?v?t???O'

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

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

  , constraint purchaseorderdetail_PKC primary key (ConstructionCode,SeqNo,GroupCount,LineCount)

) comment '??????????f?[?^' ;

create index POrderDetail_Index1

  on purchaseorderdetail(SourceCode);

Insert INTO purchaseorderdetail

SELECT

  ConstructionCode

  , SeqNo

  , GroupCount

  , LineCount

  , ComponentCode

  , ItemCode

  , FirstString

  , SecondString

  , UnitCount

  , UnitName

  , UnitPrice

  , OrdersLinePrice

  , SourceCode

  , SourceLineCnt

  , 0

  , EntryDate

  , UpdateDate

FROM purchaseorderdetail_OLD

;

update purchaseorderdetail set DataTypeFlag = 1 where FirstString like '%?@??%';

commit;