ALTER TABLE dat_d_shukka ALTER COLUMN juchurirekino TYPE bigint;
ALTER TABLE dat_rd_shukka ALTER COLUMN juchurirekino TYPE bigint;


insert into mst_menu(menucd, oyamenucd, menumei, hyojikb, kinocd, hyojijun, gaiyo, sakuseiuserid, sakuseinichiji, koshinuserid, koshinnichiji, kengengrp, haishifg) select '1258', '0060', '在庫分析', '2', 'F000000009', 608, '在庫を分析します', 'admin', clock_timestamp(), 'admin', clock_timestamp(), '1', 0 where not exists (select 0 from mst_menu where menucd = '1258');
