-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Jan 07, 2022 at 06:21 AM
-- Server version: 5.7.36
-- PHP Version: 7.3.33

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: `robisear_mainerp`
--

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

--
-- Table structure for table `rolepermissionsactions`
--

CREATE TABLE `rolepermissionsactions` (
  `id` int(11) NOT NULL,
  `moduleid` varchar(100) NOT NULL,
  `userid` varchar(100) NOT NULL,
  `actionid` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rolepermissionsactions`
--

INSERT INTO `rolepermissionsactions` (`id`, `moduleid`, `userid`, `actionid`) VALUES
(1, 'sales', '4', 'add'),
(2, 'sales', '4', 'suspend'),
(3, 'sales', '4', 'printreceipt'),
(4, 'sales', '4', 'update'),
(5, 'sales', '4', 'cash'),
(6, 'sales', '4', 'delete'),
(7, 'sales', '4', 'moresales'),
(8, 'sales', '4', 'sale'),
(9, 'sales', '4', 'Logout'),
(10, 'sales', '4', 'mpesabalance'),
(11, 'sales', '4', 'discount'),
(12, 'sales', '4', 'reprint'),
(13, 'sales', '4', 'select'),
(14, 'sales', '4', 'printbill'),
(15, 'sales', '4', 'productdiscount'),
(16, 'sales', '4', 'mpesa'),
(17, 'sales', '4', 'order'),
(18, 'sales', '4', 'closebill'),
(19, 'sales', '4', 'viewbuyingprice'),
(20, 'sales', '4', 'editsellingprice'),
(21, 'sales', '4', 'updatepaymentmode'),
(22, 'sales', '4', 'card'),
(23, 'sales', '4', 'clearpayments'),
(24, 'sales', '4', 'cheque'),
(25, 'sales', '4', 'creditnote'),
(26, 'sales', '4', 'voucher'),
(27, 'sales', '4', 'salesbeyondbprice'),
(28, 'sales', '4', 'points'),
(29, 'sales', '4', 'credit'),
(30, 'sales', '4', 'selectroom'),
(31, 'sales', '4', 'dontprint'),
(32, 'sales', '4', 'accountlimit'),
(33, 'sales', '4', 'backdatesales'),
(34, 'sales', '4', 'recordcoins'),
(35, 'sales', '4', 'changetaxstatus'),
(36, 'sales', '4', 'leaseitems'),
(37, 'sales', '4', 'giveloyalityponts'),
(38, 'sales', '4', 'dontshowstock'),
(39, 'sales', '4', 'splitbill'),
(40, 'sales', '4', 'changeuomonsales'),
(41, 'sales', '4', 'selecttable'),
(42, 'sales', '4', 'printdelivery'),
(43, 'sales', '4', 'sendsms'),
(44, 'sales', '4', 'selectcurrency'),
(45, 'sales', '4', 'salesperson'),
(46, 'sales', '4', 'usekeyboard'),
(47, 'sales', '4', 'receiptno'),
(48, 'sales', '4', 'negativesales'),
(49, 'cashiersales', '4', 'entermpesacode'),
(50, 'cashiersales', '4', 'editmpesa'),
(51, 'cashiersales', '4', 'all'),
(52, 'cashiersales', '4', 'delete'),
(53, 'cashiersales', '4', 'cashiersales'),
(54, 'cashiersales', '4', 'editmpesadate'),
(55, 'cashiersales', '4', 'dontshowtotal'),
(56, 'cashiersales', '4', 'adddailycollection'),
(57, 'cashiersales', '4', 'viewtill'),
(58, 'cashiersales', '4', 'viewdailycollections'),
(59, 'cashiersales', '4', 'deletedailycollections'),
(60, 'cashiersales', '4', 'updatedailycollections'),
(61, 'cashiersales', '4', 'reversempesa'),
(62, 'cashiersales', '4', 'clearallsales'),
(63, 'cashiersales', '4', 'viewallcollections'),
(64, 'cashiersales', '4', 'viewallcounters'),
(65, 'cashiersales', '4', 'mpesapendingreport'),
(66, 'cashiersales', '4', 'mpesaverifiedreport'),
(67, 'cashiersales', '4', 'viewcommission'),
(68, 'cashiersales', '4', 'viewmpesamessages'),
(69, 'cashiersales', '4', 'dailysalesonly'),
(70, 'viewreturnsales', '4', 'add'),
(71, 'viewreturnsales', '4', 'update'),
(72, 'viewreturnsales', '4', 'delete'),
(73, 'viewreturnsales', '4', 'return'),
(74, 'viewreturnsales', '4', 'clear'),
(75, 'viewreturnsales', '4', 'moresales'),
(76, 'password', '4', 'change'),
(77, 'sales', '8', 'add'),
(78, 'sales', '8', 'suspend'),
(79, 'sales', '8', 'update'),
(80, 'sales', '8', 'cash'),
(81, 'sales', '8', 'moresales'),
(82, 'sales', '8', 'sale'),
(83, 'sales', '8', 'Logout'),
(84, 'sales', '8', 'displaycustomers'),
(85, 'sales', '8', 'select'),
(86, 'sales', '8', 'printbill'),
(87, 'sales', '8', 'productdiscount'),
(88, 'sales', '8', 'mpesa'),
(89, 'sales', '8', 'order'),
(90, 'sales', '8', 'closebill'),
(91, 'sales', '8', 'viewbuyingprice'),
(92, 'sales', '8', 'editsellingprice'),
(93, 'sales', '8', 'updatepaymentmode'),
(94, 'sales', '8', 'card'),
(95, 'sales', '8', 'clearpayments'),
(96, 'sales', '8', 'cheque'),
(97, 'sales', '8', 'creditnote'),
(98, 'sales', '8', 'voucher'),
(99, 'sales', '8', 'salesbeyondbprice'),
(100, 'sales', '8', 'points'),
(101, 'sales', '8', 'credit'),
(102, 'sales', '8', 'selectroom'),
(103, 'sales', '8', 'dontprint'),
(104, 'sales', '8', 'backdatesales'),
(105, 'sales', '8', 'recordcoins'),
(106, 'sales', '8', 'changetaxstatus'),
(107, 'sales', '8', 'giveloyalityponts'),
(108, 'sales', '8', 'dontshowstock'),
(109, 'sales', '8', 'splitbill'),
(110, 'sales', '8', 'changeuomonsales'),
(111, 'sales', '8', 'selecttable'),
(112, 'sales', '8', 'printdelivery'),
(113, 'sales', '8', 'sendsms'),
(114, 'sales', '8', 'selectcurrency'),
(115, 'sales', '8', 'salesperson'),
(116, 'sales', '8', 'usekeyboard'),
(117, 'sales', '8', 'receiptno'),
(118, 'cashiersales', '8', 'entermpesacode'),
(119, 'cashiersales', '8', 'editmpesa'),
(120, 'cashiersales', '8', 'all'),
(121, 'cashiersales', '8', 'cashiersales'),
(122, 'cashiersales', '8', 'editmpesadate'),
(123, 'cashiersales', '8', 'dontshowtotal'),
(124, 'cashiersales', '8', 'viewtill'),
(125, 'cashiersales', '8', 'viewdailycollections'),
(126, 'cashiersales', '8', 'updatedailycollections'),
(127, 'cashiersales', '8', 'viewallcounters'),
(128, 'cashiersales', '8', 'viewcommission'),
(129, 'cashiersales', '8', 'viewmpesamessages'),
(130, 'cashiersales', '8', 'dailysalesonly'),
(131, 'password', '8', 'change'),
(132, 'profile', '8', 'update'),
(133, 'sales', '1', 'add'),
(134, 'sales', '1', 'suspend'),
(135, 'sales', '1', 'selectmessage'),
(136, 'sales', '1', 'printreceipt'),
(137, 'sales', '1', 'update'),
(138, 'sales', '1', 'cash'),
(139, 'sales', '1', 'delete'),
(140, 'sales', '1', 'moresales'),
(141, 'sales', '1', 'sale'),
(142, 'sales', '1', 'Logout'),
(143, 'sales', '1', 'mpesabalance'),
(144, 'sales', '1', 'displaycustomers'),
(145, 'sales', '1', 'discount'),
(146, 'sales', '1', 'reprint'),
(147, 'sales', '1', 'select'),
(148, 'sales', '1', 'printbill'),
(149, 'sales', '1', 'productdiscount'),
(150, 'sales', '1', 'mpesa'),
(151, 'sales', '1', 'order'),
(152, 'sales', '1', 'closebill'),
(153, 'sales', '1', 'viewbuyingprice'),
(154, 'sales', '1', 'editsellingprice'),
(155, 'sales', '1', 'updatepaymentmode'),
(156, 'sales', '1', 'card'),
(157, 'sales', '1', 'clearpayments'),
(158, 'sales', '1', 'cheque'),
(159, 'sales', '1', 'creditnote'),
(160, 'sales', '1', 'voucher'),
(161, 'sales', '1', 'salesbeyondbprice'),
(162, 'sales', '1', 'points'),
(163, 'sales', '1', 'credit'),
(164, 'sales', '1', 'selectroom'),
(165, 'sales', '1', 'dontprint'),
(166, 'sales', '1', 'accountlimit'),
(167, 'sales', '1', 'backdatesales'),
(168, 'sales', '1', 'recordcoins'),
(169, 'sales', '1', 'changetaxstatus'),
(170, 'sales', '1', 'leaseitems'),
(171, 'sales', '1', 'giveloyalityponts'),
(172, 'sales', '1', 'dontshowstock'),
(173, 'sales', '1', 'splitbill'),
(174, 'sales', '1', 'changeuomonsales'),
(175, 'sales', '1', 'selecttable'),
(176, 'sales', '1', 'printdelivery'),
(177, 'sales', '1', 'sendsms'),
(178, 'sales', '1', 'selectcurrency'),
(179, 'sales', '1', 'salesperson'),
(180, 'sales', '1', 'usekeyboard'),
(181, 'sales', '1', 'receiptno'),
(182, 'sales', '1', 'negativesales'),
(183, 'wholesale', '1', 'sale'),
(184, 'wholesale', '1', 'add'),
(185, 'wholesale', '1', 'delete'),
(186, 'wholesale', '1', 'update'),
(187, 'cashiersales', '1', 'entermpesacode'),
(188, 'cashiersales', '1', 'editmpesa'),
(189, 'cashiersales', '1', 'all'),
(190, 'cashiersales', '1', 'delete'),
(191, 'cashiersales', '1', 'cashiersales'),
(192, 'cashiersales', '1', 'editmpesadate'),
(193, 'cashiersales', '1', 'dontshowtotal'),
(194, 'cashiersales', '1', 'adddailycollection'),
(195, 'cashiersales', '1', 'viewtill'),
(196, 'cashiersales', '1', 'viewdailycollections'),
(197, 'cashiersales', '1', 'deletedailycollections'),
(198, 'cashiersales', '1', 'updatedailycollections'),
(199, 'cashiersales', '1', 'reversempesa'),
(200, 'cashiersales', '1', 'clearallsales'),
(201, 'cashiersales', '1', 'viewallcollections'),
(202, 'cashiersales', '1', 'viewallcounters'),
(203, 'cashiersales', '1', 'mpesapendingreport'),
(204, 'cashiersales', '1', 'mpesaverifiedreport'),
(205, 'cashiersales', '1', 'viewcommission'),
(206, 'cashiersales', '1', 'viewmpesamessages'),
(207, 'cashiersales', '1', 'dailysalesonly'),
(208, 'recorddelivery', '1', 'add'),
(209, 'recorddelivery', '1', 'view'),
(210, 'recorddelivery', '1', 'update'),
(211, 'recorddelivery', '1', 'delete'),
(212, 'recorddelivery', '1', 'changestatus'),
(213, 'recorddelivery', '1', 'report'),
(214, 'recorddelivery', '1', 'Dispatched'),
(215, 'recorddelivery', '1', 'FailedDelivery'),
(216, 'recorddelivery', '1', 'ReturnedandReceived'),
(217, 'recorddelivery', '1', 'Delivered'),
(218, 'recorddelivery', '1', 'Claimraised'),
(219, 'recorddelivery', '1', 'ClaimOK'),
(220, 'recorddelivery', '1', 'ClaimDamaged'),
(221, 'purchases', '1', 'add'),
(222, 'purchases', '1', 'update'),
(223, 'purchases', '1', 'delete'),
(224, 'purchases', '1', 'updatebuyingprice'),
(225, 'purchases', '1', 'updatesellingprice'),
(226, 'purchases', '1', 'updateclosedinvoice'),
(227, 'purchases', '1', 'viewquotation'),
(228, 'purchases', '1', 'viewserials'),
(229, 'purchases', '1', 'viewdirectpurchases'),
(230, 'purchases', '1', 'viewpurchase'),
(231, 'purchases', '1', 'salesorder'),
(232, 'purchases', '1', 'budget'),
(233, 'purchases', '1', 'showdefaultserials'),
(234, 'purchases', '1', 'viewallcounters'),
(235, 'purchases', '1', 'approve'),
(236, 'purchases', '1', 'addbatchno'),
(237, 'purchases', '1', 'addexpirydate'),
(238, 'viewreturnsales', '1', 'add'),
(239, 'viewreturnsales', '1', 'update'),
(240, 'viewreturnsales', '1', 'delete'),
(241, 'viewreturnsales', '1', 'return'),
(242, 'viewreturnsales', '1', 'clear'),
(243, 'viewreturnsales', '1', 'moresales'),
(244, 'income', '1', 'View'),
(245, 'income', '1', 'add'),
(246, 'income', '1', 'wiewinvoices'),
(247, 'income', '1', 'detailedvatinvoice'),
(248, 'incomeexpenses', '1', 'add'),
(249, 'incomeexpenses', '1', 'closeexpense'),
(250, 'incomeexpenses', '1', 'update'),
(251, 'incomeexpenses', '1', 'updateclosedexpenses'),
(252, 'incomeexpenses', '1', 'wiewinvoices'),
(253, 'incomeexpenses', '1', 'viewbills'),
(254, 'incomeexpenses', '1', 'viewexpense'),
(255, 'incomeexpenses', '1', 'viewdebtors'),
(256, 'incomeexpenses', '1', 'viewcreditors'),
(257, 'incomeexpenses', '1', 'postrentalexpenses'),
(258, 'accomodation', '1', 'viewrooms'),
(259, 'accomodation', '1', 'addhouse'),
(260, 'accomodation', '1', 'dailysales'),
(261, 'accomodation', '1', 'viewhouse'),
(262, 'accomodation', '1', 'voucher'),
(263, 'accomodation', '1', 'mpesa'),
(264, 'accomodation', '1', 'points'),
(265, 'accomodation', '1', 'credit'),
(266, 'accomodation', '1', 'card'),
(267, 'accomodation', '1', 'cash'),
(268, 'accomodation', '1', 'cheque'),
(269, 'accomodation', '1', 'checkinroom'),
(270, 'accomodation', '1', 'checkoutroom'),
(271, 'accomodation', '1', 'addroom'),
(272, 'accomodation', '1', 'cancel'),
(273, 'accomodation', '1', 'checkin'),
(274, 'accomodation', '1', 'addcharges'),
(275, 'accomodation', '1', 'givediscount'),
(276, 'accomodation', '1', 'cleanrooms'),
(277, 'accomodation', '1', 'updatecharges'),
(278, 'accomodation', '1', 'updateroom'),
(279, 'accomodation', '1', 'postexpense'),
(280, 'accomodation', '1', 'updatehouse'),
(281, 'accomodation', '1', 'Post Bank Deposits'),
(282, 'accomodation', '1', 'managehotel'),
(283, 'accomodation', '1', 'assignrooms'),
(284, 'accomodation', '1', 'managerental'),
(285, 'accomodation', '1', 'changepayment'),
(286, 'accomodation', '1', 'housekeeping'),
(287, 'accomodation', '1', 'customerregister'),
(288, 'accomodation', '1', 'dailypayments'),
(289, 'accomodation', '1', 'advancebooking'),
(290, 'accomodation', '1', 'checkoutcustomerwithbalance'),
(291, 'accomodation', '1', 'managecustomer'),
(292, 'accomodation', '1', 'viewreports'),
(293, 'accomodation', '1', 'accomodationmanager'),
(294, 'accomodation', '1', 'accommodationcleaner'),
(295, 'accomodation', '1', 'accommodationreceiptionist'),
(296, 'accomodation', '1', 'config'),
(297, 'accomodation', '1', 'viewroomcleaned'),
(298, 'accomodation', '1', 'clearsales'),
(299, 'accomodation', '1', 'dailycollections'),
(300, 'branch', '1', 'add'),
(301, 'branch', '1', 'view'),
(302, 'branch', '1', 'update'),
(303, 'branch', '1', 'delete'),
(304, 'members', '1', 'add'),
(305, 'members', '1', 'update'),
(306, 'members', '1', 'deletepeople'),
(307, 'members', '1', 'opencloseshift'),
(308, 'users', '1', 'add'),
(309, 'users', '1', 'update'),
(310, 'users', '1', 'delete'),
(311, 'users', '1', 'deleteallroles'),
(312, 'productscategory', '1', 'add'),
(313, 'productscategory', '1', 'update'),
(314, 'productscategory', '1', 'delete'),
(315, 'productlist', '1', 'bulk'),
(316, 'productlist', '1', 'updatestock'),
(317, 'productlist', '1', 'move'),
(318, 'productlist', '1', 'more'),
(319, 'productlist', '1', 'transfer'),
(320, 'productlist', '1', 'addstock'),
(321, 'productlist', '1', 'delete'),
(322, 'productlist', '1', 'view'),
(323, 'productlist', '1', 'update'),
(324, 'productlist', '1', 'add'),
(325, 'productlist', '1', 'openclosestock'),
(326, 'productlist', '1', 'stocktaking'),
(327, 'productlist', '1', 'editstocktaken'),
(328, 'productlist', '1', 'editopenclosestock'),
(329, 'productlist', '1', 'changeserialstatus'),
(330, 'productlist', '1', 'viewserials'),
(331, 'productlist', '1', 'viewproductsfromallbranches'),
(332, 'productlist', '1', 'bulkpriceupdate'),
(333, 'productlist', '1', 'viewbprice'),
(334, 'products', '1', 'add'),
(335, 'products', '1', 'update'),
(336, 'products', '1', 'delete'),
(337, 'products', '1', 'addstock'),
(338, 'products', '1', 'more'),
(339, 'products', '1', 'bulk'),
(340, 'products', '1', 'deleteorder'),
(341, 'products', '1', 'dispatch'),
(342, 'products', '1', 'removestock'),
(343, 'products', '1', 'price'),
(344, 'products', '1', 'removeallstock'),
(345, 'products', '1', 'bulkpriceupdate'),
(346, 'products', '1', 'viewbprice'),
(347, 'incomingstock', '1', 'add'),
(348, 'incomingstock', '1', 'update'),
(349, 'incomingstock', '1', 'view'),
(350, 'incomingstock', '1', 'delete'),
(351, 'incomingstore', '1', 'add'),
(352, 'incomingstore', '1', 'delete'),
(353, 'incomingstore', '1', 'view'),
(354, 'lowstocklist', '1', 'add'),
(355, 'lowstocklist', '1', 'more'),
(356, 'lowstocklist', '1', 'view'),
(357, 'lowproducts', '1', 'add'),
(358, 'lowproducts', '1', 'update'),
(359, 'damagedproducts', '1', 'add'),
(360, 'damagedproducts', '1', 'update'),
(361, 'damagedproducts', '1', 'delete'),
(362, 'projectsmanagement', '1', 'view'),
(363, 'projectsmanagement', '1', 'add'),
(364, 'projectsmanagement', '1', 'update'),
(365, 'projectsmanagement', '1', 'delete'),
(366, 'assets', '1', 'add'),
(367, 'assets', '1', 'update'),
(368, 'assets', '1', 'delete'),
(369, 'accounting', '1', 'deletebank'),
(370, 'accounting', '1', 'deleteglaccount'),
(371, 'accounting', '1', 'view'),
(372, 'bankdeposits', '1', 'add'),
(373, 'bankdeposits', '1', 'update'),
(374, 'bankdeposits', '1', 'delete'),
(375, 'banktransfer', '1', 'add'),
(376, 'journalentry', '1', 'add'),
(377, 'accountingreports', '1', 'view'),
(378, 'peoplecategory', '1', 'add'),
(379, 'peoplecategory', '1', 'update'),
(380, 'peoplecategory', '1', 'delete'),
(381, 'labourrecords', '1', 'add'),
(382, 'payroll', '1', 'add'),
(383, 'reports', '1', 'view'),
(384, 'reports', '1', 'download'),
(385, 'reports', '1', 'delete'),
(386, 'reports', '1', 'update'),
(387, 'reports', '1', 'viewall'),
(388, 'displayreport', '1', 'view'),
(389, 'grouping', '1', 'add'),
(390, 'grouping', '1', 'update'),
(391, 'grouping', '1', 'delete'),
(392, 'sendsms', '1', 'add'),
(393, 'sendsms', '1', 'update'),
(394, 'sendsms', '1', 'delete'),
(395, 'sendsms', '1', 'transfersms'),
(396, 'documents', '1', 'add'),
(397, 'documents', '1', 'update'),
(398, 'documents', '1', 'delete'),
(399, 'documents', '1', 'viewalldocuments'),
(400, 'humanresource', '1', 'add'),
(401, 'humanresource', '1', 'approve'),
(402, 'humanresource', '1', 'update'),
(403, 'humanresource', '1', 'delete'),
(404, 'humanresource', '1', 'view'),
(405, 'humanresource', '1', 'allocate'),
(406, 'humanresource', '1', 'viewallpayroll'),
(407, 'humanresource', '1', 'leavesetup'),
(408, 'humanresource', '1', 'allleaves '),
(409, 'humanresource', '1', 'bioattendance'),
(410, 'taskscategory', '1', 'add'),
(411, 'taskscategory', '1', 'update'),
(412, 'taskscategory', '1', 'delete'),
(413, 'task', '1', 'add'),
(414, 'task', '1', 'update'),
(415, 'task', '1', 'viewall'),
(416, 'task', '1', 'delete'),
(417, 'task', '1', 'postspecifictask'),
(418, 'task', '1', 'postgeneraltask'),
(419, 'task', '1', 'viewothersspecifictask'),
(420, 'task', '1', 'viewothersgeneraltask'),
(421, 'task', '1', 'assigntask'),
(422, 'task', '1', 'posttaskforothers'),
(423, 'callcenter', '1', 'add'),
(424, 'callcenter', '1', 'upadate'),
(425, 'callcenter', '1', 'view'),
(426, 'callcenter', '1', 'download'),
(427, 'callcenter', '1', 'delete'),
(428, 'deals', '1', 'add'),
(429, 'deals', '1', 'update'),
(430, 'deals', '1', 'delete'),
(431, 'deals', '1', 'viewall'),
(432, 'complain', '1', 'add'),
(433, 'complain', '1', 'view'),
(434, 'complain', '1', 'update'),
(435, 'complain', '1', 'allcompalin'),
(436, 'complain', '1', 'delete'),
(437, 'events', '1', 'add'),
(438, 'events', '1', 'update'),
(439, 'events', '1', 'delete'),
(440, 'password', '1', 'change'),
(441, 'profile', '1', 'update'),
(442, 'ecommerce', '1', 'add'),
(443, 'ecommerce', '1', 'update'),
(444, 'ecommerce', '1', 'delete'),
(445, 'ecommerce', '1', 'vieworders'),
(446, 'ecommerce', '1', 'setup'),
(447, 'ecommerce', '1', 'approveorders'),
(448, 'config', '1', 'delete'),
(449, 'config', '1', 'add'),
(450, 'config', '1', 'update'),
(483, 'sales', '2', 'add'),
(484, 'sales', '2', 'suspend'),
(485, 'sales', '2', 'printreceipt'),
(486, 'sales', '2', 'update'),
(487, 'sales', '2', 'cash'),
(488, 'sales', '2', 'moresales'),
(489, 'sales', '2', 'sale'),
(490, 'sales', '2', 'mpesa'),
(491, 'sales', '2', 'updatepaymentmode'),
(492, 'sales', '2', 'card'),
(493, 'sales', '2', 'clearpayments'),
(494, 'sales', '2', 'cheque'),
(495, 'sales', '2', 'dontprint'),
(496, 'cashiersales', '2', 'entermpesacode'),
(497, 'cashiersales', '2', 'editmpesa'),
(498, 'cashiersales', '2', 'cashiersales'),
(499, 'cashiersales', '2', 'editmpesadate'),
(500, 'cashiersales', '2', 'dontshowtotal'),
(501, 'cashiersales', '2', 'adddailycollection'),
(502, 'cashiersales', '2', 'viewtill'),
(503, 'cashiersales', '2', 'viewdailycollections'),
(504, 'cashiersales', '2', 'updatedailycollections'),
(505, 'cashiersales', '2', 'viewallcounters'),
(506, 'cashiersales', '2', 'mpesapendingreport'),
(507, 'cashiersales', '2', 'mpesaverifiedreport'),
(508, 'cashiersales', '2', 'viewcommission'),
(509, 'cashiersales', '2', 'viewmpesamessages'),
(510, 'cashiersales', '2', 'dailysalesonly'),
(511, 'password', '2', 'change'),
(512, 'incomeexpenses', '5', 'add'),
(513, 'incomeexpenses', '5', 'closeexpense'),
(514, 'incomeexpenses', '5', 'update'),
(515, 'incomeexpenses', '5', 'updateclosedexpenses'),
(516, 'incomeexpenses', '5', 'wiewinvoices'),
(517, 'incomeexpenses', '5', 'viewbills'),
(518, 'incomeexpenses', '5', 'viewexpense'),
(519, 'incomeexpenses', '5', 'viewdebtors'),
(520, 'incomeexpenses', '5', 'viewcreditors'),
(521, 'incomeexpenses', '5', 'postrentalexpenses'),
(522, 'accounting', '5', 'deletebank'),
(523, 'accounting', '5', 'deleteglaccount'),
(524, 'accounting', '5', 'view'),
(525, 'bankdeposits', '5', 'add'),
(526, 'bankdeposits', '5', 'update'),
(527, 'bankdeposits', '5', 'delete'),
(528, 'banktransfer', '5', 'add'),
(529, 'accountingreports', '5', 'view');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `rolepermissionsactions`
--
ALTER TABLE `rolepermissionsactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=530;
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 */;
