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

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