DELETE FROM `PM_DETAIL_PT` WHERE `PM_DETAIL_PT`.`DETAIL_CODE` = 'PT018';
INSERT INTO `PM_DETAIL_PT` VALUES ('PT018','1.00割増','1.00割増',0,' (R L,2, [ PT018 ] / 60 ) ',2,1,1,'1971-01-01 00:00:00','','1971-01-01 00:00:00','');
DELETE FROM `PM_DETAIL_PA` WHERE `PM_DETAIL_PA`.`DETAIL_CODE` = 'PA004';
INSERT INTO `PM_DETAIL_PA` VALUES ('PA004','残深休手当','残深休手当',0,0,0,0,0,0,0,0,0,' ( ( [ PT004 ] # [ PT018 ] ) / 60 * [ PA0041 ] ) + (R L,0, [ PT005 ] / 60 * [ PA0042 ] ) + (R L,0, [ PT006 ] / 60 * [ PA0043 ] ) ',0,1,0,'1971-01-01 00:00:00','','1971-01-01 00:00:00','');
DELETE FROM `PM_DETAIL_PB` WHERE `PM_DETAIL_PB`.`DETAIL_CODE` = 'PA0041';
INSERT INTO `PM_DETAIL_PB` VALUES ('PA0041','残業手当','残業手当','PA004',0,0,0,' ( ( [ PT004 ] # [ PT018 ] ) / 60 * [ PA0041 ] ) ',1,1,0,'1971-01-01 00:00:00','','1971-01-01 00:00:00','');

DROP TABLE IF EXISTS `M_IMPORT`;
CREATE TABLE `M_IMPORT` (
  `ICODE` varchar(10) NOT NULL default '' COMMENT 'インポートコード',
  `INAME` varchar(12) NOT NULL default '' COMMENT 'インポート名称',
  `ITABLE` varchar(50) NOT NULL default '' COMMENT 'インポートテーブル',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`ICODE`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='インポートマスタ';


DROP TABLE IF EXISTS `M_IMPORT_FIELD`;
CREATE TABLE `M_IMPORT_FIELD` (
  `ICODE` varchar(10) NOT NULL default '' COMMENT 'インポートコード',
  `IFIELD` varchar(50) NOT NULL default '' COMMENT 'インポートフィールド',
  `IORDER` int NOT NULL default '0' COMMENT '並び順',
  `ADDDT` datetime NOT NULL COMMENT '登録日',
  `ADDCD` varchar(10) NOT NULL default '' COMMENT '登録者',
  `UPDDT` timestamp NOT NULL COMMENT '更新日',
  `UPDCD` varchar(10) NOT NULL default '' COMMENT '更新者',
  PRIMARY KEY  (`ICODE`, `IFIELD`)
) ENGINE=InnoDB DEFAULT CHARSET=cp932 COMMENT='インポートフィールドマスタ';
