query add permission

-- insert menu roles

INSERT INTO menu_roles (type, position, parent_id, name, icon, link, sort, "createdAt", "updatedAt") VALUES (2, 2, 26, 'History Order Devp', null, '/history-pay-devp', 107, '2023-10-21 14:22:25.964000 +00:00', '2023-11-05 10:41:43.719000 +00:00');
INSERT INTO menu_roles (type, position, parent_id, name, icon, link, sort, "createdAt", "updatedAt") VALUES (2, 2, 26, 'History Order Corp', null, '/history-pay-corp', 106, '2023-10-21 14:22:25.964000 +00:00', '2023-11-05 10:41:43.719000 +00:00');
INSERT INTO menu_roles (type, position, parent_id, name, icon, link, sort, "createdAt", "updatedAt") VALUES (2, 2, 26, 'History Order Indi', null, '/history-pay-indi', 105, '2023-10-21 14:22:25.964000 +00:00', '2023-11-05 10:41:43.719000 +00:00');
INSERT INTO menu_roles (type, position, parent_id, name, icon, link, sort, "createdAt", "updatedAt") VALUES (2, 2, 26, 'History Order FSBO', null, '/history-pay-fsbo', 104, '2023-10-21 14:22:25.964000 +00:00', '2023-11-05 10:41:43.719000 +00:00');


--- insert permission

INSERT INTO permissions (role_id, menu_id, "createdAt", "updatedAt")
VALUES
(
    17,
    (SELECT id FROM menu_roles WHERE name = 'History Order Devp' AND link = '/history-pay-devp'),
    '2024-03-24 15:45:48.379000 +00:00',
    '2024-03-24 16:00:02.746000 +00:00'
);

INSERT INTO permissions (role_id, menu_id, "createdAt", "updatedAt")
VALUES
(
    17,
    (SELECT id FROM menu_roles WHERE name = 'History Order Corp' AND link = '/history-pay-corp'),
    '2024-03-24 15:45:48.379000 +00:00',
    '2024-03-24 16:00:02.746000 +00:00'
);

INSERT INTO permissions (role_id, menu_id, "createdAt", "updatedAt")
VALUES
(
    17,
    (SELECT id FROM menu_roles WHERE name = 'History Order Indi' AND link = '/history-pay-indi'),
    '2024-03-24 15:45:48.379000 +00:00',
    '2024-03-24 16:00:02.746000 +00:00'
);

INSERT INTO permissions (role_id, menu_id, "createdAt", "updatedAt")
VALUES
(
    17,
    (SELECT id FROM menu_roles WHERE name = 'History Order FSBO' AND link = '/history-pay-fsbo'),
    '2024-03-24 15:45:48.379000 +00:00',
    '2024-03-24 16:00:02.746000 +00:00'
);