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

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

DROP TABLE IF EXISTS constructionledgerdetail_OLD;

CREATE TABLE constructionledgerdetail_OLD As Select * from constructionledgerdetail;

drop table if exists constructionledgerdetail cascade;

create table constructionledgerdetail (

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

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

  , LineCount decimal(4,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 '???????'

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

  , CompanyType decimal(1,0) not null comment '??????R?[?h?^?C?v'

  , CompanyCode decimal(8,0) not null comment '??????R?[?h'

  , CompanyName varchar(120) comment '?????????'

  , EstimatePrice decimal(12,0) not null comment '?\?Z?i????j???z'

  , ExecutionAmount decimal(12,0) not null comment '???s???z'

  , AmountConfigRate decimal(5,2) not null comment '???z?\????'

  , PaymentBurden decimal(12,0) not null comment '?x????U?z'

  , FixDataFlg decimal(1,0) not null comment '???f?[?^?t???O'

  , IndependentFlg decimal(1,0) not null comment '????f?[?^?t???O'

  , FluctuationFlg decimal(1,0) not null comment '?????f?[?^?t???O'

  , SalaryFlg decimal(1,0) not null comment '???^?U????'

  , SalaryDays decimal(4,0) not null comment '???^?U??????'

  , OperatingFlg decimal(1,0) not null comment '?S?????t???O'

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

  , JoinTitleFlg decimal(1,0) not null comment '?H??????^?C?g??'

  , SalaryOnRegist decimal(12,0) not null comment '?o?^?????z???^'

  , PurchaseOrderFlg decimal(2,0) not null comment '?????????s?t???O'

  , DetailCount decimal(4,0) unsigned not null comment '??????'

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

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

  , constraint constructionledgerdetail_PKC primary key (ConstructionCode,GroupCount,LineCount)

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

create index LedgerDetail_Index01

  on constructionledgerdetail(ConstructionCode);

create index LedgerDetail_Index02

  on constructionledgerdetail(GroupCount);

create index LedgerDetail_Index03

  on constructionledgerdetail(LineCount);

create index LedgerDetail_Index04

  on constructionledgerdetail(SourceCode);

create index LedgerDetail_Index05

  on constructionledgerdetail(DetailCount);

Insert INTO constructionledgerdetail

SELECT

  ConstructionCode

  , GroupCount

  , LineCount

  , ComponentCode

  , ItemCode

  , FirstString

  , SecondString

  , CompanyType

  , CompanyCode

  , CompanyName

  , EstimatePrice

  , ExecutionAmount

  , AmountConfigRate

  , PaymentBurden

  , FixDataFlg

  , IndependentFlg

  , FluctuationFlg

  , SalaryFlg

  , SalaryDays

  , OperatingFlg

  , SourceCode

  , JoinTitleFlg

  , SalaryOnRegist

  , PurchaseOrderFlg

  , 0

  , EntryDate

  , UpdateDate

FROM constructionledgerdetail_OLD

;

ALTER TABLE purchaseorderdetail 

CHANGE SourceCode SourceCode decimal(10,0) unsigned not null

COMMENT '???H?????';

ALTER TABLE purchaseorderdetail 

CHANGE SourceLineCnt SourceDetailCnt decimal(4,0) unsigned not null

COMMENT '????????';

ALTER TABLE constructionledgerexcute 

CHANGE LineCount LineCount decimal(4,0) unsigned not null

comment '?s???';

Truncate table paymentapprovalinfo;

Truncate table paymentdatadetail;

Truncate table billingdata;

Truncate table billingdatadetail;

Truncate table billingpaymentsummary;

commit;