-- phpMyAdmin SQL Dump
-- version 4.9.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: Dec 29, 2020 at 07:43 AM
-- Server version: 10.4.10-MariaDB
-- PHP Version: 5.6.40

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `erptesting`
--

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

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
CREATE TABLE IF NOT EXISTS `permissions` (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=MyISAM AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `created_at`, `updated_at`) VALUES
(28, 'STOCK LIST', '2019-12-03 02:16:29', '2019-12-03 02:16:29'),
(2, 'DASHBOARD', '2019-12-02 05:24:03', '2019-12-02 05:24:03'),
(3, 'ADD SALES INVOICE', '2019-12-02 05:24:45', '2019-12-02 05:24:45'),
(4, 'EDIT SALES INVOICE', '2019-12-02 05:24:59', '2019-12-02 05:24:59'),
(5, 'PRINT SALES INVOICE', '2019-12-02 05:25:41', '2019-12-02 05:25:41'),
(6, 'PRINT SALES DELIVERY ORDER', '2019-12-02 05:26:09', '2019-12-02 05:26:09'),
(7, 'CHECK SALES INVOICE', '2019-12-02 05:26:34', '2019-12-02 05:26:34'),
(8, 'ADD CUSTOMER', '2019-12-02 05:26:59', '2019-12-02 05:26:59'),
(9, 'CUSTOMER LIST', '2019-12-02 05:27:13', '2019-12-02 05:27:13'),
(10, 'EDIT CUSTOMER', '2019-12-02 05:27:26', '2019-12-02 05:27:26'),
(11, 'DELETE CUSTOMER', '2019-12-02 05:27:37', '2019-12-02 05:27:37'),
(12, 'VIEW CUSTOMER', '2019-12-02 05:27:54', '2019-12-02 05:27:54'),
(13, 'USER LIST', '2019-12-02 07:22:10', '2019-12-02 07:22:10'),
(14, 'ADD USER', '2019-12-02 07:22:18', '2019-12-02 07:22:18'),
(15, 'EDIT USER', '2019-12-02 07:22:25', '2019-12-02 07:22:25'),
(16, 'DELETE USER', '2019-12-02 07:22:32', '2019-12-02 07:22:32'),
(17, 'VIEW USER', '2019-12-02 07:22:53', '2019-12-02 07:22:53'),
(18, 'ROLE LIST', '2019-12-02 08:51:03', '2019-12-02 08:51:03'),
(19, 'ADD ROLE', '2019-12-02 08:51:10', '2019-12-02 08:51:10'),
(20, 'EDIT ROLE', '2019-12-02 08:51:26', '2019-12-02 08:51:26'),
(21, 'VIEW ROLE', '2019-12-02 08:51:38', '2019-12-02 08:51:38'),
(22, 'DELETE ROLE', '2019-12-02 08:51:55', '2019-12-02 08:51:55'),
(23, 'PERMISSION LIST', '2019-12-02 08:52:14', '2019-12-02 08:52:14'),
(24, 'ADD PERMISSION', '2019-12-02 08:52:23', '2019-12-02 08:52:23'),
(25, 'EDIT PERMISSION', '2019-12-02 08:52:32', '2019-12-02 08:52:32'),
(26, 'VIEW PERMISSION', '2019-12-02 08:52:39', '2019-12-02 08:52:39'),
(27, 'DELETE PERMISSION', '2019-12-02 08:52:45', '2019-12-02 08:52:45'),
(29, 'ADD STOCK', '2019-12-03 02:22:47', '2019-12-03 02:22:47'),
(30, 'EDIT STOCK', '2019-12-03 02:23:03', '2019-12-03 02:23:03'),
(31, 'VIEW STOCK', '2019-12-03 02:24:00', '2019-12-03 02:24:00'),
(32, 'DELETE STOCK', '2019-12-03 02:24:09', '2019-12-03 02:24:09'),
(33, 'SUPPLIER LIST', '2019-12-03 02:26:03', '2019-12-03 02:26:03'),
(34, 'ADD SUPPLIER', '2019-12-03 02:26:10', '2019-12-03 02:26:10'),
(35, 'EDIT SUPPLIER', '2019-12-03 02:26:18', '2019-12-03 02:26:18'),
(36, 'VIEW SUPPLIER', '2019-12-03 02:26:25', '2019-12-03 02:26:25'),
(37, 'DELETE SUPPLIER', '2019-12-03 02:26:32', '2019-12-03 02:26:32'),
(38, 'SALES INVOICE', '2019-12-03 02:48:45', '2019-12-03 02:48:45'),
(39, 'AREA LIST', '2019-12-03 02:57:12', '2019-12-03 02:57:12'),
(40, 'ADD AREA', '2019-12-03 02:57:19', '2019-12-03 02:57:19'),
(41, 'EDIT AREA', '2019-12-03 03:05:27', '2019-12-03 03:05:27'),
(42, 'VIEW AREA', '2019-12-03 03:05:37', '2019-12-03 03:05:37'),
(43, 'DELETE AREA', '2019-12-03 03:05:43', '2019-12-03 03:05:43'),
(44, 'TERM LIST', '2019-12-03 03:06:06', '2019-12-03 03:06:06'),
(45, 'ADD TERM', '2019-12-03 03:06:12', '2019-12-03 03:07:47'),
(46, 'EDIT TERM', '2019-12-03 03:07:57', '2019-12-03 03:07:57'),
(47, 'VIEW TERM', '2019-12-03 03:08:05', '2019-12-03 03:08:05'),
(48, 'DELETE TERM', '2019-12-03 03:08:12', '2019-12-03 03:08:12'),
(49, 'CUSTOMER CATEGORY LIST', '2019-12-03 03:08:44', '2019-12-03 03:08:44'),
(50, 'ADD CUSTOMER CATEGORY', '2019-12-03 03:08:55', '2019-12-03 03:08:55'),
(51, 'EDIT CUSTOMER CATEGORY', '2019-12-03 03:09:05', '2019-12-03 03:09:05'),
(52, 'VIEW CUSTOMER CATEGORY', '2019-12-03 03:09:14', '2019-12-03 03:09:14'),
(53, 'DELETE CUSTOMER CATEGORY', '2019-12-03 03:09:38', '2019-12-03 03:09:38'),
(54, 'BANK LIST', '2019-12-03 03:09:53', '2019-12-03 03:09:53'),
(55, 'ADD BANK', '2019-12-03 03:10:05', '2019-12-03 03:10:05'),
(56, 'EDIT BANK', '2019-12-03 03:10:14', '2019-12-03 03:10:14'),
(57, 'VIEW BANK', '2019-12-03 03:10:46', '2019-12-03 03:10:46'),
(58, 'DELETE BANK', '2019-12-03 03:10:53', '2019-12-03 03:10:53'),
(59, 'AGENT LIST', '2019-12-03 03:11:09', '2019-12-03 03:11:09'),
(60, 'ADD AGENT', '2019-12-03 03:11:17', '2019-12-03 03:11:17'),
(61, 'EDIT AGENT', '2019-12-03 03:11:26', '2019-12-03 03:11:26'),
(62, 'VIEW AGENT', '2019-12-03 03:11:39', '2019-12-03 03:11:39'),
(63, 'DELETE AGENT', '2019-12-03 03:11:47', '2019-12-03 03:11:47'),
(64, 'STAFF LIST', '2019-12-03 03:12:01', '2019-12-03 03:12:01'),
(65, 'ADD STAFF', '2019-12-03 03:12:09', '2019-12-03 03:12:09'),
(66, 'EDIT STAFF', '2019-12-03 03:12:16', '2019-12-03 03:12:16'),
(67, 'VIEW STAFF', '2019-12-03 03:12:23', '2019-12-03 03:12:23'),
(68, 'DELETE STAFF', '2019-12-03 03:12:35', '2019-12-03 03:12:35'),
(69, 'STOCK CATEGORY LIST', '2019-12-03 03:12:56', '2019-12-03 03:19:12'),
(70, 'ADD STOCK CATEGORY', '2019-12-03 03:13:08', '2019-12-03 03:13:08'),
(71, 'EDIT STOCK CATEGORY', '2019-12-03 03:13:16', '2019-12-03 03:13:16'),
(72, 'VIEW STOCK CATEGORY', '2019-12-03 03:13:29', '2019-12-03 03:13:29'),
(73, 'DELETE STOCK CATEGORY', '2019-12-03 03:13:41', '2019-12-03 03:13:41'),
(74, 'PROFILE', '2019-12-03 06:32:46', '2019-12-03 06:32:46'),
(75, 'RECEIVE PAYMENT', '2019-12-05 00:52:28', '2019-12-05 00:52:28'),
(76, 'ADD RECEIVE PAYMENT', '2019-12-05 00:52:50', '2019-12-05 00:52:50'),
(77, 'EDIT RECEIVE PAYMENT', '2019-12-05 00:53:04', '2019-12-05 00:53:04'),
(78, 'PRINT RECEIVE VOUCHER', '2019-12-05 00:54:45', '2019-12-05 00:54:45'),
(79, 'CHECK RECEIVE PAYMENT', '2019-12-05 00:55:47', '2019-12-05 00:55:47'),
(80, 'UOMS LIST', '2019-12-09 20:23:47', '2019-12-09 20:23:47'),
(81, 'ADD UOMS', '2019-12-09 20:24:01', '2019-12-09 20:24:01'),
(82, 'EDIT UOMS', '2019-12-09 20:24:21', '2019-12-09 20:24:21'),
(83, 'VIEW UOMS', '2019-12-09 20:24:31', '2019-12-09 20:24:31'),
(84, 'DELETE UOMS', '2019-12-09 20:24:40', '2019-12-09 20:24:40'),
(85, 'PAYMENT VOUCHER', '2019-12-10 16:45:57', '2019-12-10 16:48:56'),
(86, 'ADD PAYMENT VOUCHER', '2019-12-10 16:46:08', '2019-12-10 16:48:05'),
(87, 'EDIT PAYMENT VOUCHER', '2019-12-10 16:46:17', '2019-12-10 16:48:20'),
(88, 'PRINT PAYMENT VOUCHER', '2019-12-10 16:46:36', '2019-12-10 16:46:36'),
(89, 'CHECK PAYMENT VOUCHER', '2019-12-10 16:46:45', '2019-12-10 16:48:39'),
(90, 'ALLOW CHANGE DATE', '2019-12-11 08:33:20', '2019-12-11 08:33:20'),
(91, 'CREDIT NOTE', '2019-12-11 16:46:32', '2019-12-11 16:46:32'),
(92, 'ADD CREDIT NOTE', '2019-12-11 16:46:51', '2019-12-11 16:46:51'),
(93, 'EDIT CREDIT NOTE', '2019-12-11 16:46:59', '2019-12-11 16:46:59'),
(94, 'PRINT CREDIT NOTE', '2019-12-11 16:47:59', '2019-12-11 16:47:59'),
(95, 'CHECK CREDIT NOTE', '2019-12-11 16:48:19', '2019-12-11 16:48:19'),
(96, 'PURCHASE ORDER', '2019-12-11 21:17:21', '2019-12-11 21:17:21'),
(97, 'ADD PURCHASE ORDER', '2019-12-11 21:17:28', '2019-12-11 21:17:28'),
(98, 'EDIT PURCHASE ORDER', '2019-12-11 21:17:35', '2019-12-11 21:17:35'),
(99, 'PRINT PURCHASE ORDER', '2019-12-11 21:17:49', '2019-12-11 21:17:49'),
(100, 'CHECK PURCHASE ORDER', '2019-12-11 21:17:56', '2019-12-11 21:17:56'),
(101, 'ADMIN AUTHORITY', '2019-12-16 08:10:31', '2019-12-16 08:10:31'),
(102, 'OUTSTANDING REPORT', '2020-01-08 08:33:21', '2020-01-08 08:33:21'),
(103, 'DASHBOARD - SALES (MONTHLY)', '2020-01-09 06:36:59', '2020-01-09 06:36:59'),
(104, 'DASHBOARD - SALES (ANNUAL)', '2020-01-09 06:37:09', '2020-01-09 06:37:09'),
(105, 'DASHBOARD - RECEIVED PAYMENT (MONTHLY)', '2020-01-09 06:37:24', '2020-01-09 06:37:24'),
(106, 'DASHBOARD - RECEIVED PAYMENT (YEARLY)', '2020-01-09 06:37:46', '2020-01-09 06:37:46'),
(107, 'DASHBOARD - SALES OVERVIEW', '2020-01-09 06:37:57', '2020-01-09 06:37:57'),
(108, 'DASHBOARD - AREA SALES', '2020-01-09 06:38:13', '2020-01-09 06:38:13'),
(109, 'DASHBOARD - AREA OUTSTANDING', '2020-01-09 06:38:24', '2020-01-09 06:38:24'),
(110, 'RECEIPT REPORT', '2020-01-10 08:24:11', '2020-01-10 08:24:11'),
(111, 'SALES REPORT', '2020-01-13 08:53:17', '2020-01-13 08:53:17'),
(112, 'PRINT CUSTOMER/SUPPLIER STICKER', '2020-01-20 08:20:33', '2020-01-20 08:20:33'),
(113, 'CUSTOMER GROUP LIST', '2020-04-04 12:46:22', '2020-04-04 12:46:22'),
(114, 'ADD CUSTOMER GROUP', '2020-04-04 12:46:38', '2020-04-04 12:46:38'),
(115, 'EDIT CUSTOMER GROUP', '2020-04-04 12:46:51', '2020-04-04 12:46:51'),
(116, 'VIEW CUSTOMER GROUP', '2020-04-04 12:46:58', '2020-04-04 12:46:58'),
(117, 'DELETE CUSTOMER GROUP', '2020-04-04 12:47:04', '2020-04-04 12:47:04'),
(118, 'CUSTOMER SERVICE LIST', '2020-04-08 03:14:17', '2020-04-08 03:14:17'),
(119, 'ADD CUSTOMER SERVICE', '2020-04-08 03:14:28', '2020-04-08 03:14:28'),
(120, 'EDIT CUSTOMER SERVICE', '2020-04-08 03:14:39', '2020-04-08 03:14:39'),
(121, 'DELETE CUSTOMER SERVICE', '2020-04-08 03:14:51', '2020-04-08 03:14:51'),
(122, 'PWS PG APP SERVICE LIST', '2020-04-21 16:26:45', '2020-04-21 16:26:45'),
(123, 'ADD PWS PG APP SERVICE', '2020-04-21 16:27:02', '2020-04-21 16:27:02'),
(124, 'EDIT PWS PG APP SERVICE', '2020-04-21 16:27:17', '2020-04-21 16:27:17'),
(125, 'DELETE PWS PG APP SERVICE', '2020-04-21 16:27:34', '2020-04-21 16:27:34'),
(126, 'CUSTOMER SERVICE PRICE', '2020-04-22 02:35:28', '2020-04-22 02:35:28'),
(127, 'UPLOAD SYSTEM FILE', '2020-04-24 14:58:11', '2020-04-24 14:58:11'),
(128, 'CUSTOMER SALES DATA EXPORT (LHDN)', '2020-05-17 07:05:05', '2020-05-17 07:05:05'),
(129, 'SERVICE MAINTENANCE REPORT', '2020-06-05 09:38:27', '2020-06-05 09:38:27'),
(130, 'SYSTEM SETTING', '2020-10-30 08:59:24', '2020-10-30 08:59:24'),
(131, 'DASHBOARD - MAINTENANCE SERVICE', '2020-11-03 08:02:15', '2020-11-03 08:02:15'),
(132, 'SERVICES RATE PROFILE LIST', '2020-12-28 09:00:39', '2020-12-28 09:00:39'),
(133, 'ADD SERVICES RATE PROFILE', '2020-12-28 09:00:57', '2020-12-28 09:00:57'),
(134, 'EDIT SERVICES RATE PROFILE', '2020-12-28 09:01:07', '2020-12-28 09:01:07'),
(135, 'DELETE SERVICES RATE PROFILE', '2020-12-28 09:01:15', '2020-12-28 09:01:15'),
(136, 'VIEW SERVICES RATE PROFILE', '2020-12-28 09:01:22', '2020-12-28 09:01:22'),
(137, 'SOLUTION PROFILE LIST', '2020-12-29 06:27:41', '2020-12-29 06:27:41'),
(138, 'ADD SOLUTION PROFILE', '2020-12-29 06:27:46', '2020-12-29 06:27:46'),
(139, 'EDIT SOLUTION PROFILE', '2020-12-29 06:27:51', '2020-12-29 06:27:51'),
(140, 'DELETE SOLUTION PROFILE', '2020-12-29 06:27:57', '2020-12-29 06:27:57'),
(141, 'VIEW SOLUTION PROFILE', '2020-12-29 06:28:21', '2020-12-29 06:28:21');
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 */;
