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

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

DROP TABLE IF EXISTS billingdatadetail_OLD;

CREATE TABLE billingdatadetail_OLD As Select * from billingdatadetail;

drop table if exists billingdatadetail cascade;

create table billingdatadetail (

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

  , TARGETDATE decimal(6,0) default '0' not null comment '???N??'

  , SEQNO decimal(3,0) default '0' not null comment '?A??'

  , LINECOUNT decimal(3,0) default '0' not null comment '?s???'

  , CONSTRUCTIONCODE decimal(10,0) comment '?H?????'

  , CONSTRUCTIONROWCNT decimal(3,0)  default '0' not null comment '?s???'

  , CONSTRUCTIONCOLCNT decimal(3,0)  default '0' not null comment '????'

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

  , BILLPRICE decimal(10,0) comment '???????z'

  , HIGHWPRICE decimal(10,0) comment '??????'

  , HARDWPRICE decimal(10,0) comment '??????'

  , INDSWASTETAX decimal(10,0) comment '?Y?p??'

  , NOTE varchar(120) comment '???l'

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

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

  , constraint billingdatadetail_PKC primary key (COMPANYCODE,TARGETDATE,SEQNO,LINECOUNT)

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

Insert INTO billingdatadetail

SELECT

  COMPANYCODE

  , TARGETDATE

  , SEQNO

  , LINECOUNT

  , CONSTRUCTIONCODE

  , 0

  , 0

  , FIELDNAME

  , BILLPRICE

  , HIGHWPRICE

  , HARDWPRICE

  , INDSWASTETAX

  , NOTE

  , ENTRYDATE

  , UPDATEDATE

FROM billingdatadetail_OLD

;

commit;

-- ?x??????f?[?^?X?V

update paymentdatadetail AS A set A.CNSTRPRICEEXIST = -1 where A.CNSTRPRICEEXIST is null;

commit;

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

drop table if exists attendancedailydata cascade;

create table attendancedailydata (

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

  , AttendanceDate date not null comment '???????'

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

  , ActionResult varchar(30) not null comment '?s??????'

  , StartTime datetime comment '?J?n????'

  , CompTime datetime comment '?I??????'

  , DayTimes decimal(4,1) not null comment '????????v????'

  , WorkingComment varchar(120) comment '?R?????g'

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

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

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

  , constraint attendancedailydata_PKC primary key (PersonCode,AttendanceDate,SeqNo)

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

create index AttendDaily_Index1

  on attendancedailydata(ActionResult);

create index AttendDaily_Index2

  on attendancedailydata(AttendanceDate);

-- ?H???{?H?\?Z?f?[?^

DROP TABLE IF EXISTS constructionbudget_OLD;

CREATE TABLE constructionbudget_OLD As Select * from constructionbudget;

drop table if exists constructionbudget cascade;

create table constructionbudget (

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

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

  , CreatorName varchar(60) comment '?????'

  , CreatorCosts decimal(11,0) not null comment '??????^'

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

  , AssistantName varchar(60) comment '???S?????'

  , AssistantCosts decimal(11,0) not null comment '???S??????^'

  , InstructorCode decimal(8,0) not null comment '?H???w?????R?[?h'

  , InstructorName varchar(60) comment '?H???w??????'

  , InstructorCosts decimal(11,0) not null comment '?H???w???????^'

  , CreateDate date not null comment '????'

  , ConstructionTimes decimal(5,2) not null comment '?H???i?P??E???j'

  , ConstructionStart date not null comment '?_??H???J?n'

  , ConstructionEnd date not null comment '?_??H??????'

  , InstructorTimes decimal(5,2) not null comment '?w???????????'

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

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

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

  , A_SalaryDays decimal(4,0) not null comment '???S????U??????'

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

  , I_SalaryDays decimal(4,0) not null comment '?w?????U??????'

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

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

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

  , constraint constructionbudget_PKC primary key (ConstructionCode)

) comment '?H???{?H?\?Z?f?[?^' ;

Insert INTO constructionbudget

SELECT

  ConstructionCode

  , CreatorCode

  , CreatorName

  , CreatorCosts

  , AssistantCode

  , AssistantName

  , AssistantCosts

  , InstructorCode

  , InstructorName

  , InstructorCosts

  , CreateDate

  , ConstructionTimes

  , ConstructionStart

  , ConstructionEnd

  , InstructorTimes

  , SalaryFlg

  , SalaryDays

  , A_SalaryFlg

  , A_SalaryDays

  , I_SalaryFlg

  , I_SalaryDays

  , 0

  , EntryDate

  , UpdateDate

FROM constructionbudget_OLD

;

commit;