# Nucleus DB
INSERT INTO `pc_menu_groups` (`name`, `description`, `permission_code`, `is_active`, `code`, `order`, `module`, `url`,
                              `menu_icon`, `created_by`, `created_date`, `updated_by`, `updated_date`)
VALUES ('Settings', 'Settings', 'SETTINGS', '1', 'SETTINGS', '4', NULL, '/settings', 'settings', NULL, NULL, NULL,
        NULL);

# Nucleus DB
INSERT INTO `pc_menu_items` (`name`, `permission_code`, `order`, `description`, `code`, `is_active`,
                             `parent_menu_item_id`, `module`, `url`, `menu_icon`, `created_by`, `created_date`,
                             `updated_by`, `updated_date`)
VALUES ('User Permission Management', 'USER_PERMISSION_MANAGEMENT', '1', 'User permission management',
        'USER_PERMISSION_MANAGEMENT', '1', NULL, NULL, 'user-permission-management', NULL, NULL, NULL, NULL, NULL),
       ('Assign Roles', 'ASSIGN_ROLES', '2', 'Assign roles to user', 'ASSIGN_ROLES', '1', NULL, NULL, 'assign-roles',
        NULL, NULL, NULL, NULL, NULL),
       ('Manage Roles', 'MANAGE_ROLES', '3', 'Create,edit or delete roles', 'MANAGE_ROLES', '1', NULL, NULL,
        'manage-roles', NULL, NULL, NULL, NULL, NULL);


# College db

INSERT INTO `auth_permission` (`display_name`, `code`, `module`, `created_by`, `updated_by`, `created_date`,
                               `updated_date`)
VALUES ('Assign User Permission', 'USER_PERMISSION_MANAGEMENT', 'PRODUCT_CONFIGURATION', '0', '0',
        '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
       ('Settings', 'SETTINGS', 'PRODUCT_CONFIGURATION', '0', '0', '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
       ('Assign Roles', 'ASSIGN_ROLES', 'PRODUCT_CONFIGURATION', '0', '0', '0000-00-00 00:00:00',
        '0000-00-00 00:00:00'),
       ('Manage Roles', 'MANAGE_ROLES', 'PRODUCT_CONFIGURATION', '0', '0', '0000-00-00 00:00:00',
        '0000-00-00 00:00:00');


INSERT INTO `roles` (`name`, `code`, `description`, `is_active`, `created_by`, `created_date`, `updated_by`,
                     `updated_date`)
VALUES ('Super Admin', 'SUPER_ADMIN', 'This admin can access all the features in Linways AMS', '1', NULL, NULL, '314',
        '2021-03-29 10:44:17');

# Do not execute without changing the correct values
INSERT INTO `user_account_roles` ( `user_id`, `user_type`, `role_id`, `created_by`, `created_date`, `updated_by`, `updated_date`) VALUES
( '105', 'STAFF', '3', '314', '2021-03-27 19:51:45', '314', '2021-03-27 19:51:45');