query menu

-- insert menu roles

INSERT INTO menu_roles (type, position, parent_id, name, icon, link, sort, "createdAt", "updatedAt") VALUES (2, 2, 21, 'KPR', 'fa-solid fa-gears', '/content/data/kpr', 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, 21, 'Footer', 'fa-solid fa-gears', '/content/data/footer', 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, 21, 'Premium Ads', 'fa-solid fa-gears', '/config/ads-premium', 105, '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 = 'KPR' AND link = '/content/data/kpr'),
    '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 = 'Footer' AND link = '/content/data/footer'),
    '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 = 'Premium Ads' AND link = '/config/ads-premium'),
    '2024-03-24 15:45:48.379000 +00:00',
    '2024-03-24 16:00:02.746000 +00:00'
);