CREATE TABLE `pi_default_navigation` (
                                          `id` INT(11) NOT NULL AUTO_INCREMENT,
                                          `client_portal_id` INT(11) NULL DEFAULT NULL,
                                          `role_assosiation_id` INT(11) NULL DEFAULT NULL,
                                          `group_role_id` INT(11) NULL DEFAULT NULL,
                                          `module_id` INT(11) NULL DEFAULT NULL,
                                          `menu_id` INT(11) NULL DEFAULT NULL,
                                          `url` VARCHAR(100) NULL DEFAULT NULL,
                                          `client_id` INT(9) UNSIGNED NULL DEFAULT NULL,
                                          `created_at` TIMESTAMP NULL DEFAULT NULL,
                                          `updated_at` TIMESTAMP NULL DEFAULT NULL,
                                          `deleted_at` TIMESTAMP NULL DEFAULT NULL,
                                          `created_by` INT(9) UNSIGNED NULL DEFAULT NULL,
                                          `updated_by` INT(9) UNSIGNED NULL DEFAULT NULL,
                                          `deleted_by` INT(9) UNSIGNED NULL DEFAULT NULL,
                                          PRIMARY KEY (`id`) ,
                                          KEY `Foregin_key_default_navigation_created_by` (`created_by`) ,
                                          KEY `Foregin_key_default_navigation_updated_by` (`updated_by`),
                                          KEY `Foregin_key_default_navigation_deleted_by` (`deleted_by`),
                                          KEY `Foregin_key_default_navigation_client_id` (`client_id`) ,
                                          KEY `Foregin_key_default_navigation_client_portal_id` (`client_portal_id`) ,
                                          KEY `Foregin_key_default_navigation_role_association_id` (`role_assosiation_id`) ,
                                          KEY `Foregin_key_default_navigation_group_role_id` (`group_role_id`) ,
                                          KEY `Foregin_key_default_navigation_module_id` (`module_id`) ,
                                          KEY `Foregin_key_default_navigation_menu_id` (`menu_id`) ,
                                          CONSTRAINT `Foregin_key_default_navigation_client_portal_id` FOREIGN KEY (`client_portal_id`) REFERENCES `acm_client_portals` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_role_association_id` FOREIGN KEY (`role_assosiation_id`) REFERENCES `acm_group_role_association` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_group_role_id` FOREIGN KEY (`group_role_id`) REFERENCES `acm_group_roles` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_module_id` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_menu_id` FOREIGN KEY (`menu_id`) REFERENCES `acm_menus` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_client_id` FOREIGN KEY (`client_id`) REFERENCES `proll_client` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_created_by` FOREIGN KEY (`created_by`) REFERENCES `proll_employee` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_deleted_by` FOREIGN KEY (`deleted_by`) REFERENCES `proll_employee` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION,
                                          CONSTRAINT `Foregin_key_default_navigation_updated_by` FOREIGN KEY (`updated_by`) REFERENCES `proll_employee` (`id`) ON UPDATE NO ACTION ON DELETE NO ACTION
);

INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (1, 1, 1, 2, 1, 'emp_expense/emp_expense_detail/', 48, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (2, 2, 2, 2, 1, 'lm_expense_detail/', 48, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (3, 3, 3, 2, 1, 'hr_expense_apps/hr_expense_detail/', 48, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (1, 1, 1, 1, 1, 'lm_expense_detail/{id}', 48, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (2, 2, 2, 1, 1, 'lm_leave_apps/lm_leave_detail/', 48, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO `pi_default_navigation` (`client_portal_id`, `role_assosiation_id`, `group_role_id`, `module_id`, `menu_id`, `url`, `client_id`, `created_at`, `updated_at`, `deleted_at`, `created_by`, `updated_by`, `deleted_by`) VALUES (3, 3, 3, 1, 1, 'hr_leave_apps/hr_leave_detail/', 48, NULL, NULL, NULL, NULL, NULL, NULL);
