1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / projects_ilium / db /
Filename : tbl_menu.sql
back
-- phpMyAdmin SQL Dump
-- version 5.1.3
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Aug 07, 2025 at 08:48 AM
-- Server version: 10.4.24-MariaDB
-- PHP Version: 7.4.29

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `projects_ilium_main`
--

-- --------------------------------------------------------

--
-- Table structure for table `tbl_menu`
--

CREATE TABLE `tbl_menu` (
  `id` int(11) NOT NULL,
  `menu_name` varchar(250) DEFAULT NULL,
  `menu_url` varchar(250) DEFAULT NULL,
  `menu_icon` varchar(250) DEFAULT NULL,
  `menu_order` int(11) DEFAULT NULL,
  `menu_nav` int(11) DEFAULT NULL COMMENT '0 - No, 1 - Yes',
  `menu_parent_id` int(11) DEFAULT NULL,
  `menu_admin` int(11) NOT NULL COMMENT '0 - No, 1 - Yes',
  `deleted` int(11) NOT NULL COMMENT '0 - No, 1 - Yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `tbl_menu`
--

INSERT INTO `tbl_menu` (`id`, `menu_name`, `menu_url`, `menu_icon`, `menu_order`, `menu_nav`, `menu_parent_id`, `menu_admin`, `deleted`) VALUES
(1, 'User Access', 'users_master', 'fas fa-user-cog', 1, 1, 0, 0, 0),
(2, 'User Account Type Master', 'tab_users_master', NULL, 1, 0, 1, 0, 0),
(3, 'User Account Privilege', 'users_account_privilege', NULL, 2, 0, 1, 0, 0),
(4, 'User Master', 'tab_users_master', NULL, 3, 0, 1, 0, 0),
(5, 'User Privilege', 'users_privilege', NULL, 4, 0, 1, 0, 0),
(6, 'Configuration', 'settings', 'fas fa-cogs', 2, 1, 0, 0, 0),
(7, 'Company Master', 'company_list', 'fas fa-industry', 1, 0, 6, 1, 0),
(8, 'Department Master', 'department_master', 'far fa-building', 2, 0, 6, 0, 0),
(9, 'Designation Master', 'designation_master', 'far fa-building', 3, 0, 6, 0, 0),
(10, 'Salary Master', 'salary_master', 'fas fa-rupee-sign', 4, 0, 6, 0, 0),
(11, 'Shift Timing Master', 'shift_timing_master', 'fas fa-clock', 5, 0, 6, 0, 0),
(12, 'VAT Master', 'vat_master', 'fas fa-users', 6, 0, 6, 0, 0),
(13, 'Financial Year Master', 'financial_year_master', 'fas fa-users', 7, 0, 6, 0, 0),
(14, 'Unit Master', 'unit_master', 'far fa-building', 8, 0, 6, 0, 0),
(15, 'Payment Terms', 'payment_terms', 'far fa-building', 9, 0, 6, 0, 0),
(16, 'Incoterms', 'Incoterms', 'far fa-building', 10, 0, 6, 0, 0),
(17, 'Transport Mode', 'transport', 'far fa-building', 11, 0, 6, 0, 0),
(18, 'Currency', 'currency', 'far fa-building', 12, 0, 6, 0, 0),
(19, 'Holidays', 'holiday_master', 'far fa-building', 13, 0, 6, 0, 0),
(20, 'HR', NULL, 'fas fa-users', 3, 1, 0, 0, 0),
(21, 'Employee Master', 'employee_master', 'far fa-circle', 1, 1, 20, 0, 0),
(22, 'Attendance Master', 'attendance_master', 'far fa-circle', 2, 1, 20, 0, 0),
(23, 'Salary Slip Master', 'salary_slip_master', 'far fa-circle', 3, 1, 20, 0, 0),
(24, 'Employee Performance', 'employee_perform_master', 'far fa-circle', 4, 1, 20, 0, 0),
(25, 'Loan Master', 'loan_master', 'far fa-circle', 5, 1, 20, 0, 0),
(26, 'Leave Approve Master', 'leave_approve_master', 'far fa-circle', 6, 1, 20, 0, 0),
(27, 'Leave Request Master', 'leave_request_master', 'far fa-circle', 7, 1, 20, 1, 0),
(28, 'Monthly Attendance', 'view_attendance_report', 'far fa-circle', 2, 1, 20, 0, 0),
(29, 'Leave Master', 'leave_category', 'far fa-circle', 14, 0, 6, 0, 0),
(30, 'Salary Details', 'salary_details', 'far fa-circle', 7, 1, 20, 0, 0),
(31, 'Pay Rol', 'pay_rol', 'far fa-circle', 7, 1, 20, 0, 0),
(32, 'Material Request', NULL, 'fas fa-recycle', 4, 1, 0, 0, 0),
(33, 'Material Request', 'material', 'far fa-circle', 1, 1, 32, 0, 0),
(34, 'Inventory Master', NULL, 'fas fa-money-check-alt', 5, 1, 0, 0, 0),
(35, 'Item Master', 'inventory_master', 'far fa-circle', 1, 1, 34, 0, 0),
(36, 'Assets', 'inventory_master/assets', 'far fa-circle', 2, 1, 34, 0, 0),
(37, 'Licenses', 'inventory_master/licenses', 'far fa-circle', 3, 1, 34, 0, 0),
(38, 'Purchase', NULL, 'fas fa-suitcase', 6, 1, 0, 0, 0),
(39, 'Purchase Quote', 'Purchase/purchasequote', 'far fa-circle', 1, 1, 38, 0, 0),
(40, 'Purchase Order', 'Purchase/purchaseorder', 'far fa-circle', 2, 1, 38, 0, 0),
(41, 'Purchase Invoice', 'Purchase/purchaseinvoice', 'far fa-circle', 4, 1, 38, 0, 0),
(42, 'Supplier Payment ', 'purchasevouchers', 'far fa-circle', 5, 1, 38, 0, 0),
(43, 'GRN', 'Accounts/grns', 'far fa-circle', 6, 1, 38, 0, 0),
(44, 'Quote Compare', 'Purchase/compare', 'far fa-circle', 7, 1, 38, 0, 0),
(45, 'Supplier Services Invoice', 'Purchase/list_serviceinvoice', 'far fa-circle', 8, 1, 38, 0, 0),
(46, 'Sales', NULL, 'fas fa-cart-arrow-down', 7, 1, 0, 0, 0),
(47, 'Sales Order', 'orders', 'far fa-circle', 1, 1, 46, 0, 0),
(48, 'Sales Invoice', 'invoices', 'far fa-circle', 2, 1, 46, 0, 0),
(49, 'Customer Receipt', 'salesvouchers', 'far fa-circle', 3, 1, 46, 0, 0),
(50, 'Credit Note', 'creaditnote', 'far fa-circle', 4, 1, 46, 0, 0),
(51, 'GDN <p style=\"font-size:13px\">(Goods Dispatch Notes)</p>', 'Accounts/gdn', 'far fa-circle', 5, 1, 46, 0, 0),
(52, 'Logistics', NULL, 'fas fa-bezier-curve', 12, 1, 0, 0, 0),
(53, 'Logistics Request', 'logistics', 'far fa-circle', 1, 1, 52, 0, 0),
(54, 'Forwarder', 'Forwarder', 'far fa-circle', 2, 1, 52, 0, 0),
(55, ' contact', 'web/contact', 'fas fa-user', 14, 1, 0, 0, 0),
(56, 'Finance', NULL, 'fas fa-building', 8, 1, 0, 0, 0),
(57, 'Chart Of Accounts', 'accountname', 'far fa-circle', 1, 1, 56, 0, 0),
(58, 'Voucher', 'vouchers', 'far fa-circle', 2, 1, 56, 0, 0),
(59, 'Balance Sheet', 'balancesheet', 'far fa-circle', 3, 1, 56, 0, 0),
(60, 'Profit & Loss', 'profitandloss', 'far fa-circle', 4, 1, 56, 0, 0),
(61, 'General Ledger', 'reports/ledger', 'far fa-circle', 5, 1, 56, 0, 0),
(62, 'General Ledger - Subcategory', '', 'far fa-circle', 6, 1, 56, 0, 0),
(63, 'Trial Balance', 'trialbalance', 'far fa-circle', 7, 1, 56, 0, 0),
(64, 'GST Form 5 Return', '', 'far fa-circle', 8, 1, 56, 0, 0),
(65, 'Bank Reconcilliation', NULL, 'fas fa-university', 9, 1, 0, 0, 0),
(66, 'Bank Entries', 'Bank/bank_form', 'far fa-circle', 1, 1, 65, 0, 0),
(67, 'Bank Entries Upload', 'Bank/bank_entries_upload', 'far fa-circle', 2, 1, 65, 0, 0),
(68, 'Bank Entries Final', 'Bank/Bank_Entries_Final', 'far fa-circle', 3, 1, 65, 0, 0),
(69, 'Bank Entries View', 'Bank/Bank_Entries_View', 'far fa-circle', 4, 1, 65, 0, 0),
(70, 'Aging Schedule', NULL, 'fas fa-money-bill-alt', 10, 1, 0, 0, 0),
(71, 'Aging - Invoice - Sales', '', 'far fa-circle', 1, 1, 70, 0, 0),
(72, 'Aging - Invoice - Purchase ', '', 'far fa-circle', 2, 1, 70, 0, 0),
(73, 'Aging - Voucher - Purchase ', '', 'far fa-circle', 3, 1, 70, 0, 0),
(74, 'Aging - Voucher - Sales', '', 'far fa-circle', 4, 1, 70, 0, 0),
(75, 'Reports', NULL, 'fas fa-newspaper', 11, 1, 0, 0, 0),
(76, 'Purchase Invoice', '', 'far fa-circle', 1, 1, 75, 0, 0),
(77, 'Sales Invoice', '', 'far fa-circle', 2, 1, 75, 0, 0),
(78, 'Quick Sales Invoice', '', 'far fa-circle', 3, 1, 75, 0, 0),
(79, 'Production', NULL, 'fas fa-cart-arrow-down', 13, 1, 0, 0, 0),
(80, 'BOM Import / Export', 'import_export', 'far fa-circle', 1, 1, 79, 0, 0),
(81, 'New BOM', 'production/bom_create', 'far fa-circle', 2, 1, 79, 0, 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `tbl_menu`
--
ALTER TABLE `tbl_menu`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=82;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;