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

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

DROP TABLE IF EXISTS departmentmaster_OLD;

CREATE TABLE departmentmaster_OLD As Select * from departmentmaster;

drop table if exists departmentmaster cascade;

create table departmentmaster (

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

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

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

  , ActionScheduleFlg decimal(1,0) not null comment '?s???\??\???t???O'

  , StaffAssignFlg decimal(1,0) not null comment '?l???z?u?\???t???O'

  , StartDate datetime not null comment '?J?n???t'

  , CompDate datetime not null comment '?I?????t'

  , 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 departmentmaster_PKC primary key (DepartmentCode)

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

create index DepartmentMaster_index1

  on departmentmaster(DisplayOrder);

Insert INTO departmentmaster

SELECT

  DepartmentCode

  , DisplayOrder

  , DepartmentString

  , ActionScheduleFlg

  , StaffAssignFlg

  , NOW()

  , DATE('0001/01/01')

  , DeleteFlg

  , EntryDate

  , UpdateDate

From departmentmaster_OLD

;

commit;