Open eunja511005 opened 1 year ago
Common Code는 추가 안되므로 ZTHH_MENU, ZTHH_MENUCONTROL 테이블 이관 해 주면 됨
INSERT INTO ZTHH_MENU
(ID, CATEGORY, MENU_LEVEL, MENU_ID, MENU_PATH, MENU_ICON, MENU_ORDER, PARENT_MENU_ID, DEL_YN, CREATE_ID, CREATE_DT, UPDATE_ID, UPDATE_DT, MENU_AUTH)
VALUES('menu_5422abfb-10c6-44da-9c44-a55c4e48f1b3', 'Interface', 2, 'menu.jsonStringToDTO', '/jsonStringToDTO/list', 'N/A', 10, 'layout', 'N', NULL, TIMESTAMP '2023-08-12 06:29:31.707180', NULL, TIMESTAMP '2023-08-12 06:29:31.707180', 'ROLE_ANY');
INSERT INTO ZTHH_MENUCONTROL
(ID, URL, "METHOD", ROLE_ID, DEL_YN, CREATE_ID, CREATE_DT, UPDATE_ID, UPDATE_DT, LOG_YN, LOG_DATA_YN)
VALUES('menuControl_e4743f6e-6fa1-4d50-a5ba-cedae6ab5c5f', '/jsonStringToDTO/conversion', 'POST', 'ANY', 'N', 'autoCoding1', TIMESTAMP '2023-08-12 08:37:32.761148', 'autoCoding1', TIMESTAMP '2023-08-12 08:37:32.761148', 'Y', 'N');
INSERT INTO WASADMIN.ZTHH_MENUCONTROL
(ID, URL, "METHOD", ROLE_ID, DEL_YN, CREATE_ID, CREATE_DT, UPDATE_ID, UPDATE_DT, LOG_YN, LOG_DATA_YN)
VALUES('menuControl_e92684ae-3b88-4c2e-9542-dc8ea3ba5b1b', '/jsonStringToDTO/list', 'GET', 'ANY', 'N', 'autoCoding1', TIMESTAMP '2023-08-12 07:08:25.534201', 'autoCoding1', TIMESTAMP '2023-08-12 07:08:25.534201', 'Y', 'N');