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

-- ???R?[?h??????

drop table if exists RecordKey cascade;

create table RecordKey (

  KeyNo decimal(2,0) unsigned not null comment '?L?[?R?[?h'

  ,   RecordNumber decimal(6,0) unsigned not null comment '???R?[?h???'

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

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

  , constraint RecordKey_PKC primary key (KeyNo, RecordNumber)

) comment '???R?[?h??????' ;

Insert recordkey Value (

  1

  , (

    SELECT

      IFNULL(MAX(RecordNumber), 0)

    From

      messageboarddata

  )

  , NOW()

  , NOW()

);

commit;