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

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

DROP TABLE IF EXISTS billingdata_OLD;

CREATE TABLE billingdata_OLD As Select * from billingdata;

drop table if exists billingdata cascade;

create table billingdata (

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

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

  , PAYMENTKIND decimal(1,0) default '0' not null comment '?x????'

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

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

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

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

  , constraint billingdata_PKC primary key (COMPANYCODE,TARGETDATE,PAYMENTKIND,SEQNO)

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

Insert INTO billingdata

SELECT

  COMPANYCODE

  , TARGETDATE

  , 0

  , SEQNO

  , BILLPRICE

  , ENTRYDATE

  , UPDATEDATE

FROM billingdata_OLD

;

commit;

-- ??????????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??'

  , PAYMENTKIND decimal(1,0) default '0' not null comment '?x????'

  , 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,PAYMENTKIND,SEQNO,LINECOUNT)

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

Insert INTO billingdatadetail

SELECT

  COMPANYCODE

  , TARGETDATE

  , 0

  , SEQNO

  , LINECOUNT

  , CONSTRUCTIONCODE

  , CONSTRUCTIONROWCNT

  , CONSTRUCTIONCOLCNT

  , FIELDNAME

  , BILLPRICE

  , HIGHWPRICE

  , HARDWPRICE

  , INDSWASTETAX

  , NOTE

  , ENTRYDATE

  , UPDATEDATE

FROM billingdatadetail_OLD

;

commit;