-- 
-- MosP - Mind Open Source Project    http://www.mosp.jp/
-- Copyright (C) MIND Co., Ltd.       http://www.e-mind.co.jp/
-- 
-- This program is free software; you can redistribute it and/or
-- modify it under the terms of the GNU General Public License
-- as published by the Free Software Foundation; either version 2
-- of the License, or (at your option) any later version.
-- 
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
-- GNU General Public License for more details.
-- 
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
-- 
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='インポートフィールドマスタ';
