-- phpMyAdmin SQL Dump
-- version 4.4.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: May 08, 2025 at 04:58 AM
-- Server version: 5.6.26
-- PHP Version: 5.6.12

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

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

--
-- Table structure for table `modulesactions`
--

CREATE TABLE IF NOT EXISTS `modulesactions` (
  `actionid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `moduleid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `sort` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `modulesactions`
--

INSERT INTO `modulesactions` (`actionid`, `moduleid`, `name`, `sort`) VALUES
('accommodationcleaner', 'accomodation', 'Tick ONLY if Cleaner', 26),
('accommodationreceiptionist', 'accomodation', 'Tick  ONLY if Receptionist', 27),
('accomodationmanager', 'accomodation', 'Tick  ONLY if manager', 25),
('accountlimit', 'sales', 'Enforce Daily Sales Limit', 16),
('add', 'assets', 'Add asset', 1),
('add', 'bankdeposits', 'add', 1),
('add', 'banktransfer', 'add', 1),
('add', 'biometricrecords', 'add', 1),
('add', 'branch', 'Add Baranch', 1),
('add', 'callcenter', 'Add Calls', 1),
('add', 'chequemanagemant', 'Post Cheque', 1),
('add', 'complain', 'Add complain', 2),
('add', 'config', 'add', 1),
('add', 'damagedproducts', 'add', 1),
('add', 'deals', 'add', 1),
('add', 'departments', 'add', 1),
('add', 'documents', 'add', 1),
('add', 'ecommerce', 'Add', 1),
('add', 'events', 'add', 1),
('add', 'grouping', 'add', 1),
('add', 'humanresource', 'Add Expense Request Form', 1),
('add', 'income', 'add', 2),
('add', 'incomeexpenses', 'add', 1),
('add', 'incomingstock', 'add', 1),
('add', 'incomingstore', 'Add incoming', 1),
('add', 'journalentry', 'add', 1),
('add', 'labourrecords', 'add', 1),
('add', 'leavemanagement', 'add', 0),
('add', 'lowproducts', 'add', 1),
('add', 'lowstocklist', 'add', 6),
('add', 'loyalitycards', 'add', 1),
('add', 'members', 'add', 1),
('add', 'payroll', 'add', 1),
('add', 'payrollsetup', 'add', 1),
('add', 'peoplecategory', 'add', 1),
('add', 'productlist', 'Add Products', 7),
('add', 'products', 'add', 1),
('add', 'productscategory', 'add', 1),
('add', 'projectsmanagement', 'Create New Project', 2),
('add', 'purchases', 'add', 1),
('add', 'quotation', 'Add Quotaion', 1),
('add', 'recorddelivery', 'Add Delivery', 1),
('add', 'sales', 'add', 1),
('add', 'salesorder', 'Create Sales Order', 1),
('add', 'sendsms', 'add', 1),
('add', 'task', 'add', 1),
('add', 'taskscategory', 'add', 1),
('add', 'users', 'add', 1),
('add', 'viewreturnsales', 'add', 1),
('add', 'wholesale', 'add', 1),
('AddAgents', 'deals', 'Add Agents', 30),
('addbatchno', 'purchases', 'Add batch No', 33),
('addcharges', 'accomodation', 'Add Room Chaerges', 4),
('adddailycollection', 'cashiersales', 'Add Daily Collection', 7),
('addexpirydate', 'purchases', 'Add Expiry Date', 34),
('addhouse', 'accomodation', 'Add House', 1),
('addpossiblefeedback', 'deals', 'Add Possible feedback', 20),
('addroom', 'accomodation', 'Add Room', 3),
('addstock', 'productlist', 'Add stock', 4),
('addstock', 'products', 'addstock', 4),
('advancebooking', 'accomodation', 'advance booking', 11),
('all', 'cashiersales', 'View all Cashier sales', 4),
('allcompalin', 'complain', 'View Others Complain', 11),
('allleaves ', 'humanresource', 'View all leaves', 20),
('allocate', 'humanresource', 'Allocate Money', 5),
('allowdiscountdropdown', 'sales', 'Allow Discount Drop Down', 7),
('approve', 'humanresource', 'Make Approval', 2),
('approve', 'purchases', 'Approve Purchase order', 22),
('approveorders', 'ecommerce', 'Approve New orders', 7),
('assignproduction', 'productlist', 'Assign Production Items', 62),
('assignrooms', 'accomodation', 'Asign Cleaning rooms', 7),
('assigntask', 'task', 'Assign Task', 10),
('backdatesales', 'sales', 'Back date sales', 17),
('bioattendance', 'humanresource', 'Biometric Attendance', 30),
('budget', 'purchases', 'View Budget', 10),
('bulk', 'productlist', 'Upload bulk stock', 1),
('bulk', 'products', 'bulk', 5),
('bulkcheckin', 'accomodation', 'Bulk Checkin', 58),
('bulkpriceupdate', 'productlist', 'Bulk Price Update', 33),
('bulkpriceupdate', 'products', 'Bulk Price Update', 33),
('bulkreservation', 'accomodation', 'Bulk Reservation', 59),
('bulkstatuschange', 'accomodation', 'Bulk Room Status Change', 60),
('cancel', 'accomodation', 'Cancel Payment/Bookings', 3),
('card', 'accomodation', 'Sale in Visa Card', 2),
('card', 'sales', 'Card Sales', 7),
('cash', 'accomodation', 'Sale in Cash', 2),
('cash', 'sales', 'Sell in Cash', 3),
('cashiersales', 'cashiersales', 'View Sales', 5),
('change', 'password', 'change', 1),
('changepayment', 'accomodation', 'Change payment', 9),
('changeserialstatus', 'productlist', 'Change Serial Status', 20),
('changestatus', 'cashiersales', 'Approve Till Collections', 68),
('changestatus', 'recorddelivery', 'Change Status', 6),
('changetaxstatus', 'sales', 'Change Tax Status', 30),
('changeuomonsales', 'sales', 'Change Unit Of Measurement', 33),
('checkin', 'accomodation', 'View Room window', 4),
('checkinroom', 'accomodation', 'Check in Rooms', 2),
('checkoutcustomerwithbalance', 'accomodation', 'Check out customer with balance', 20),
('checkoutroom', 'accomodation', 'Check out Room', 3),
('cheque', 'accomodation', 'Sale in Cheque/Bank', 2),
('cheque', 'sales', 'Cheque/Bank sales', 8),
('ClaimDamaged', 'recorddelivery', 'Change to Claim Damaged', 17),
('claimmpesacode', 'sales', 'Claim Mpesa Code', 67),
('ClaimOK', 'recorddelivery', 'Cahange to Claim OK', 16),
('Claimraised', 'recorddelivery', 'Change to Claim raised', 15),
('cleanrooms', 'accomodation', 'Clean Rooms', 4),
('clear', 'viewreturnsales', 'Clear Sales', 5),
('clearallsales', 'cashiersales', 'Clear all sales for others', 10),
('clearpayments', 'sales', 'Clear/Add payments', 7),
('clearsales', 'accomodation', 'Clear room sales', 40),
('clearsalesisdefault', 'cashiersales', 'Enable Clear-Sales Page As Default', 79),
('closebill', 'sales', ' Close Bill', 6),
('closeexpense', 'incomeexpenses', 'Close Expense', 3),
('config', 'accomodation', 'Accommodation Settings', 33),
('credit', 'accomodation', 'Sale in Credit', 2),
('credit', 'sales', 'Credit sales', 10),
('creditnote', 'sales', 'Credit Note', 8),
('customerregister', 'accomodation', 'Customer Register', 10),
('dailycollections', 'accomodation', 'Daily Collections', 56),
('dailypayments', 'accomodation', 'View Daily Payments', 10),
('dailysales', 'accomodation', ' Daily Sales', 1),
('dailysalesonly', 'cashiersales', 'View Only Daily sales Report', 40),
('deactivateserialstatus', 'wholesale', 'Dont Change Barcord/Serial Status to Used', 9),
('delete', 'assets', 'Delete', 5),
('delete', 'bankdeposits', 'delete', 3),
('delete', 'branch', 'Delete Branch', 5),
('delete', 'callcenter', 'Delete calls', 5),
('delete', 'cashiersales', 'Delete Sales', 4),
('delete', 'complain', 'Delete Complain', 11),
('delete', 'config', 'delete', 0),
('delete', 'damagedproducts', 'delete', 3),
('delete', 'deals', 'delete', 3),
('delete', 'documents', 'delete', 3),
('delete', 'ecommerce', 'delete', 3),
('delete', 'events', 'delete', 3),
('delete', 'grouping', 'delete', 3),
('delete', 'humanresource', 'Delete Expense Request Form', 3),
('delete', 'incomingstock', 'delete', 3),
('delete', 'incomingstore', 'Delete incoming', 3),
('delete', 'peoplecategory', 'delete', 3),
('delete', 'productlist', 'Delete Products', 4),
('delete', 'products', 'delete', 3),
('delete', 'productscategory', 'delete', 3),
('delete', 'projectsmanagement', 'Delete Products', 5),
('delete', 'purchases', 'delete', 3),
('delete', 'quotation', 'Delete', 3),
('delete', 'recorddelivery', 'Delete Delivery', 5),
('delete', 'reports', 'Delete sales', 3),
('delete', 'sales', 'delete', 3),
('delete', 'sendsms', 'delete', 3),
('delete', 'task', 'delete', 3),
('delete', 'taskscategory', 'delete', 3),
('delete', 'users', 'delete', 3),
('delete', 'viewreturnsales', 'delete', 3),
('delete', 'wholesale', 'delete', 2),
('deleteallroles', 'users', 'Delete all Roles', 5),
('deletebank', 'accounting', 'Delete Bank Account', 2),
('deletedailycollections', 'cashiersales', 'Delete Daily Collections', 9),
('deleteglaccount', 'accounting', 'Delete GL Account', 4),
('deleteorder', 'products', 'Delete Order', 5),
('deletepeople', 'members', 'Delete Contacts', 5),
('deleteproductionitem', 'productlist', 'Delete Production Item', 63),
('Delivered', 'recorddelivery', 'Change to Delivered', 14),
('detailedvatinvoice', 'income', 'Show Detailed Vat Invoice', 5),
('discount', 'sales', 'Print Discount', 5),
('dispatch', 'products', 'Dispatch Products', 6),
('Dispatched', 'recorddelivery', 'Change to Dispatched', 10),
('displaybeforevat', 'income', 'Display price before Vat', 6),
('displaycustomers', 'sales', 'Display employees using buttons', 5),
('displaypreviousbalance', 'sales', 'Display Previous Bal on Invoice', 65),
('dontprint', 'sales', 'Display Dont Print Button', 15),
('dontreceivepartialpayment', 'income', 'Do Not Receive partial payment', 9),
('dontshowbp', 'reports', 'Dont Show B.Price', 7),
('dontshowprofit', 'reports', 'Don Not Show Profit', 10),
('dontshowstock', 'productlist', 'Dont show stock', 82),
('dontshowstock', 'products', 'Dont show stock', 80),
('dontshowstock', 'sales', 'Dont show stock balance during sales', 30),
('dontshowtotal', 'cashiersales', 'Do Not Show grand Total', 6),
('download', 'callcenter', 'download calls', 4),
('download', 'reports', 'download', 2),
('downloaddeals', 'deals', 'Download deals', 20),
('editmpesa', 'cashiersales', 'Enter Mpesa Amount Directly', 3),
('editmpesadate', 'cashiersales', 'Edit Mpesa Entry date', 5),
('editopenclosestock', 'productlist', 'Update Closing and Opening stock', 10),
('editsellingprice', 'sales', 'Change Selling Price', 7),
('editstocktaken', 'productlist', 'Change closed and stock taken', 9),
('entermpesacode', 'cashiersales', 'Enter Mpesa Code', 3),
('entermpesacode', 'sales', 'Enter Mpesa Code', 40),
('FailedDelivery', 'recorddelivery', 'Change to Failed Delivery', 12),
('givediscount', 'accomodation', 'Give Discount', 4),
('giveloyalityponts', 'sales', 'Give Poinsts', 30),
('hold', 'sales', 'hold sales', 7),
('housekeeping', 'accomodation', 'House Keeping', 9),
('leaseitems', 'sales', 'Lease Items', 30),
('leavesetup', 'humanresource', 'Add Leave setup', 8),
('linksalesorders', 'openclose', 'Link Order and sales', 4),
('Logout', 'sales', 'Log out After printing', 5),
('managecustomer', 'accomodation', 'Manager Customer', 22),
('managehotel', 'accomodation', 'Manage Hotel', 6),
('managerental', 'accomodation', 'Manage Rental Houses', 8),
('mergebill', 'sales', 'Merge Bill:', 32),
('meterreading', 'accomodation', 'Meter Reading', 30),
('more', 'lowstocklist', 'View more', 6),
('more', 'productlist', 'View Added stock', 2),
('more', 'products', 'more', 4),
('moresales', 'sales', 'Add More Sales', 4),
('moresales', 'viewreturnsales', 'Add more Sales', 5),
('move', 'productlist', 'Move stock/ Break/Distribute', 2),
('mpesa', 'accomodation', 'Sale in mpesa', 2),
('mpesa', 'sales', 'Sale in Mpesa', 6),
('mpesabalance', 'sales', 'Bank /Mpesa Balance', 5),
('mpesapendingreport', 'cashiersales', 'View All Pending Mpesa Report', 20),
('mpesaverifiedreport', 'cashiersales', 'View All Verified Mpesa Report', 21),
('negativesales', 'sales', 'Make Negative sales', 60),
('negativestockadjustment', 'productlist', 'Negative Stock Adjustment', 51),
('negativestockadjustment', 'products', 'Negative Stock Adjustment', 51),
('Novatsales', 'config', 'No Vat Sales', 20),
('opencloseshift', 'members', 'Open and Close Employee Shift', 26),
('openclosestock', 'productlist', 'Open and Close stock', 8),
('order', 'sales', 'User Order Button', 6),
('overalclearingpendingtasks', 'task', 'Clear Overal pending tasks for anyone', 20),
('pendingisdefault', 'cashiersales', 'Enable Pending Page As Default', 69),
('plotexpenses', 'accomodation', 'Plot Expenses', 63),
('points', 'accomodation', 'Sale in Loyality Points', 2),
('points', 'sales', 'Loyality Point sales', 9),
('Post Bank Deposits', 'accomodation', 'bankdeposits', 6),
('postemployeenoteforothers', 'task', 'Post Employee Notes for others', 20),
('postexpense', 'accomodation', 'Post Expense', 5),
('postgeneraltask', 'task', 'Post General Task', 5),
('postrentalexpenses', 'incomeexpenses', 'Post rental Expeses', 20),
('postspecifictask', 'task', 'Post Specific Task', 3),
('posttaskforothers', 'task', 'Post task for others', 11),
('price', 'products', 'change price', 7),
('printbill', 'sales', ' Print Bill', 6),
('printdelivery', 'sales', 'Print delivery', 38),
('printreceipt', 'sales', 'Print Receipt', 1),
('productcode', 'config', 'Display Product code in receipt', 5),
('productdiscount', 'sales', 'Give discount Product', 6),
('receiptno', 'sales', 'Enter Receipt No Directly', 50),
('receivedublicatecodes', 'income', 'Receive Dublicate Cheque / Transaction codes', 8),
('receiveoverpayment', 'income', 'Receive overpayment', 7),
('recordcoins', 'sales', 'Record Savings/Coins', 26),
('removeallstock', 'products', 'View all outgoing stock', 7),
('removestock', 'products', 'Issue stock from store', 6),
('report', 'recorddelivery', 'Delivery Report', 9),
('reprint', 'sales', 'Reprint Receipt', 5),
('restrictbillprintingtotwo', 'sales', 'Restrict Bill Printing to 2', 66),
('return', 'viewreturnsales', 'Return Sales', 4),
('returnclearedsales', 'viewreturnsales', 'Return Cleared/ Closed Sales', 7),
('ReturnedandReceived', 'recorddelivery', 'Change to Returned and Received', 13),
('reversempesa', 'cashiersales', 'Reverse Mpesa', 9),
('sale', 'sales', 'sale', 4),
('sale', 'wholesale', 'sale', 0),
('salebelowbprice', 'sales', 'Can sell below set b.price', 10),
('salesbeyondbprice', 'sales', 'Can sell below set s.price', 9),
('salesorder', 'purchases', 'Sales Order', 10),
('salesperson', 'sales', 'Choose Sales person', 50),
('select', 'sales', 'Select Customers', 5),
('selectcurrency', 'sales', 'Select Currency', 50),
('selectmessage', 'sales', 'Select Order Message', 1),
('selectroom', 'sales', 'Select Room', 12),
('selecttable', 'sales', 'Select Table', 35),
('sell', 'openclose', 'Sell', 1),
('sellusingserialonly', 'wholesale', 'Sell Using Serial Only', 10),
('sendsms', 'sales', 'Send Digital Receipt/Sms', 40),
('setup', 'ecommerce', 'Setup E-commerce', 6),
('showdefaultserials', 'purchases', 'Generate with default Serial Numbers', 20),
('showsitemmovement', 'cashiersales', 'show item movement', 80),
('splitbill', 'sales', 'Split Bill', 31),
('stocktaking', 'productlist', 'Do stock Taking', 8),
('suspend', 'sales', 'Suspend/Cancel Sales', 1),
('swapsales', 'sales', 'Swap Sales', 80),
('transfer', 'productlist', 'Transfer Products', 3),
('transferdeals', 'deals', 'Transfer Deals', 30),
('transfersms', 'sendsms', 'Transfer sms to others', 5),
('upadate', 'callcenter', 'Update', 2),
('update', 'assets', 'Update', 2),
('update', 'bankdeposits', 'update', 2),
('update', 'branch', 'Update Branch', 3),
('update', 'complain', 'Update Complain', 6),
('update', 'config', 'update', 2),
('update', 'damagedproducts', 'update', 2),
('update', 'deals', 'update', 2),
('update', 'documents', 'update', 2),
('update', 'ecommerce', 'Upadate Data', 2),
('update', 'events', 'update', 2),
('update', 'grouping', 'update', 2),
('update', 'humanresource', 'Update Expense Request Form', 2),
('update', 'incomeexpenses', 'update', 3),
('update', 'incomingstock', 'update', 2),
('update', 'lowproducts', 'update', 1),
('update', 'loyalitycards', 'update', 2),
('update', 'members', 'update', 2),
('update', 'peoplecategory', 'update', 2),
('update', 'productlist', 'Update Product', 6),
('update', 'products', 'update', 2),
('update', 'productscategory', 'update', 2),
('update', 'profile', 'update', 1),
('update', 'projectsmanagement', 'Edit Projects', 4),
('update', 'purchases', 'update', 2),
('update', 'quotation', 'Update', 2),
('update', 'recorddelivery', 'Update Delivery', 3),
('update', 'reports', 'update sales', 4),
('update', 'sales', 'update', 2),
('update', 'salesorder', 'Update Sales Order', 4),
('update', 'sendsms', 'update', 2),
('update', 'task', 'update', 2),
('update', 'taskscategory', 'update', 2),
('update', 'users', 'update', 2),
('update', 'viewreturnsales', 'update', 2),
('update', 'wholesale', 'update', 4),
('updatebuyingprice', 'purchases', 'update buying price', 4),
('updatecharges', 'accomodation', 'Update Room Charges', 4),
('updateclosedexpenses', 'incomeexpenses', 'Edit closed expenses', 4),
('updateclosedinvoice', 'purchases', 'update closed invoice', 6),
('updatedailycollections', 'cashiersales', 'Update Daily Collection', 9),
('updatehouse', 'accomodation', 'Update House', 5),
('updatepaymentmode', 'sales', 'Update Payment Mode', 7),
('updateproductionitem', 'productlist', 'Update Production Item', 64),
('updateqtysales', 'sales', 'Update Quantity on sales Window', 61),
('UpdateRenewal', 'members', 'Update Renewal', 30),
('updateroom', 'accomodation', 'Update  Room', 5),
('updatesellingprice', 'purchases', 'update selling price', 5),
('updateserial', 'purchases', 'Update Serial', 35),
('updatestock', 'productlist', 'Update Stock (Cl.Stock)', 2),
('uploadexpenses', 'incomeexpenses', 'Upload Expenses', 30),
('usekeyboard', 'sales', 'Use Internal Keyboard', 50),
('view', 'accounting', 'View Accounting', 4),
('view', 'accountingreports', 'view', 1),
('view', 'branch', 'View Branch', 2),
('view', 'callcenter', 'View Calls', 3),
('view', 'chequemanagemant', 'View Cheques', 2),
('view', 'complain', 'View Complain', 5),
('view', 'displayreport', 'Display Report', 1),
('view', 'humanresource', 'View Expense Request Form', 4),
('View', 'income', 'View', 1),
('view', 'incomingstock', 'View Incoming store products', 2),
('view', 'incomingstore', 'View Incoming store products', 4),
('view', 'lowstocklist', 'View', 6),
('view', 'productlist', 'View Products', 5),
('view', 'projectsmanagement', 'View Projects', 1),
('view', 'quotation', 'View', 5),
('view', 'recorddelivery', 'View Delivery', 2),
('view', 'reports', 'view', 1),
('view', 'salesorder', 'View Sales Order', 3),
('View others contact', 'deals', 'viewcontact', 20),
('viewall', 'deals', 'View other people''s deals', 5),
('viewall', 'quotation', 'View others quoation', 10),
('viewall', 'reports', 'View all Branches', 6),
('viewall', 'salesorder', 'View others Sales Order', 5),
('viewall', 'task', 'View other people''s tasks', 2),
('viewallcollections', 'cashiersales', 'View Others Daily Collection', 16),
('viewallcounters', 'cashiersales', 'View All Counters', 20),
('viewallcounters', 'purchases', 'View All Counters', 20),
('viewalldocuments', 'documents', 'View all Documents', 5),
('viewallpayroll', 'humanresource', 'View Payroll For everyone', 5),
('viewbills', 'incomeexpenses', 'View Bills', 6),
('viewbprice', 'productlist', 'Dont View Bprice', 88),
('viewbprice', 'products', 'Dont View Bprice', 88),
('viewbuyingprice', 'sales', 'view buying price', 7),
('viewcommission', 'cashiersales', 'View Commision', 31),
('viewcreditors', 'incomeexpenses', 'VIew creditors', 8),
('viewdailycollections', 'cashiersales', 'View Daily Collection', 8),
('viewdebtors', 'incomeexpenses', 'View Deptors', 7),
('viewdirectpurchases', 'purchases', 'View Direct Purchase', 8),
('viewexpense', 'incomeexpenses', 'View Expense', 6),
('viewhouse', 'accomodation', 'View House', 1),
('viewmpesamessages', 'cashiersales', 'View Mpesa Messages', 40),
('vieworders', 'ecommerce', 'View Orders', 4),
('viewothersgeneraltask', 'task', 'View Others General Task', 9),
('viewothersspecifictask', 'task', 'View Others Specific Task', 7),
('viewproduction', 'productlist', 'View Production', 60),
('viewproductsfromallbranches', 'productlist', 'View Products From All Branches', 30),
('viewpurchase', 'purchases', 'Purchase Order', 9),
('viewquotation', 'purchases', 'View Quotation', 7),
('viewreport', 'openclose', 'view open and close report', 3),
('viewreports', 'accomodation', 'View Reports', 22),
('viewroomcleaned', 'accomodation', 'View Room Cleaned', 33),
('viewrooms', 'accomodation', 'View All Rooms', 1),
('viewserials', 'productlist', 'View serial Number', 20),
('viewserials', 'purchases', 'View serial Numbers', 8),
('viewtill', 'cashiersales', 'View Till Collections', 8),
('voucher', 'accomodation', 'Sale in Voucher', 2),
('voucher', 'sales', 'Gift Voucher sales', 9),
('wiewinvoices', 'incomeexpenses', 'View all Expenses', 5);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `modulesactions`
--
ALTER TABLE `modulesactions`
  ADD PRIMARY KEY (`actionid`,`moduleid`),
  ADD KEY `phppos_modules_actions_ibfk_1` (`moduleid`);

/*!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 */;
