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

-- ?H???S????X?????f?[?^

drop table if exists constrchgcharge cascade;

drop table if exists ChgConstrCharge cascade;

create table ChgConstrCharge (

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

  , Division decimal(1,0) not null comment '????'

  , SeqNo smallint(5) unsigned not null comment '?A??'

  , DepartmentCode decimal(5,0) unsigned not null comment '?????R?[?h'

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

  , StartDate date comment '?S???J?n?N????'

  , CompDate date comment '?S???I???N????'

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

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

  , constraint ChgConstrCharge_PKC primary key (ConstructionCode,Division,SeqNo)

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

-- ?\?Z???W?v?R?[?h?}?X?^

drop table if exists BudgetSumCode cascade; 

CREATE TABLE BudgetSumCode( 

  BlockCode DECIMAL (2, 0) UNSIGNED NOT NULL COMMENT '?u???b?N???'

  , GroupCode DECIMAL (2, 0) UNSIGNED NOT NULL COMMENT '?O???[?v???'

  , ComponentCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '?\???L?['

  , ItemCode DECIMAL (5, 0) UNSIGNED NOT NULL COMMENT '?H??L?['

  , ElementsName VARCHAR (100) NOT NULL COMMENT '?v?f????'

  , EntryDate DATETIME NOT NULL COMMENT '?o?^???t'

  , UpdateDate DATETIME NOT NULL COMMENT '?X?V???t'

  , CONSTRAINT BudgetSumCode_PKC PRIMARY KEY (BlockCode, GroupCode, ComponentCode, ItemCode)

) COMMENT '?\?Z???W?v?R?[?h?}?X?^'; 

-- ?H?????}?X?^

DROP TABLE IF EXISTS constructiontypemaster_OLD; 

CREATE TABLE constructiontypemaster_OLD As 

Select

  * 

from

  constructiontypemaster; 

drop table if exists constructiontypemaster cascade;

create table constructiontypemaster (

  TypeCode decimal(5,0) unsigned not null comment '?H?????R?[?h'

  , DisplayOrder decimal(5,0) unsigned not null comment '?\????'

  , NameString varchar(100) not null comment '????'

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

  , RepairFlg decimal(1,0) not null comment '?V?z?E???C?t???O'

  , SecRank decimal(1,0) not null comment '?????????N'

  , ExpensesLink decimal(1,0) not null comment '?o??g?p??'

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

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

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

  , constraint constructiontypemaster_PKC primary key (TypeCode)

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

Insert 

INTO constructiontypemaster 

Select

  TypeCode

  , DisplayOrder

  , NameString

  , PublicFlg

  , 0

  , SecRank

  , ExpensesLink

  , DeleteFlg

  , EntryDate

  , NOW()

from

  constructiontypemaster_OLD;