-- phpMyAdmin SQL Dump
-- version 4.7.4
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Mar 29, 2024 at 10:31 AM
-- Server version: 10.1.28-MariaDB
-- PHP Version: 5.6.32

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

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

--
-- Table structure for table `bankcodes`
--

CREATE TABLE `bankcodes` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `code` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `status` varchar(20) NOT NULL,
  `sort_order` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bankcodes`
--

INSERT INTO `bankcodes` (`id`, `name`, `code`, `description`, `status`, `sort_order`) VALUES
(1, 'MAYFAIR BANK LIMITED', '1', 'MAYFAIR BANK LIMITED', 'Y', '1'),
(2, 'M-PAYMENT', '2', 'M-PAYMENT', 'Y', '2'),
(3, 'KENYA POST OFFICE SAVINGS BANK', '3', 'KENYA POST OFFICE SAVINGS BANK', 'Y', '3'),
(4, 'FIRST COMMUNITY BANKS LIMITED', '4', 'FIRST COMMUNITY BANKS LIMITED', 'Y', '4'),
(5, 'GULF AFRICAN BANK LTD', '5', 'GULF AFRICAN BANK LTD', 'Y', '5'),
(6, 'FAMILY BANK LTD', '6', 'FAMILY BANK LTD', 'Y', '6'),
(7, 'EQUITY BANK LIMITED', '7', 'EQUITY BANK LIMITED', 'Y', '7'),
(8, 'SIDIAN BANK LIMITED', '8', 'SIDIAN BANK LIMITED', 'Y', '8'),
(9, 'DIAMOND TRUST BANK LIMITED', '9', 'DIAMOND TRUST BANK LIMITED', 'Y', '9'),
(10, 'HOUSING FINANCE BANK', '10', 'HOUSING FINANCE BANK', 'Y', '10'),
(11, 'SBM BANK (KENYA) LIMITED', '11', 'SBM BANK (KENYA) LIMITED', 'Y', '11'),
(12, 'DEVELOPMENT BANK OF KENYA LIMITED', '12', 'DEVELOPMENT BANK OF KENYA LIMITED', 'Y', '12'),
(13, 'I&M BANK LIMITED', '13', 'I&M BANK LIMITED', 'Y', '13'),
(14, 'GUARDIAN BANK LIMITED', '14', 'GUARDIAN BANK LIMITED', 'Y', '14'),
(15, 'VICTORIA COMMERCIAL BANK LIMITED', '15', 'VICTORIA COMMERCIAL BANK LIMITED', 'Y', '15'),
(16, 'GUARANTY TRUST BANK KENYA LIMITED', '16', 'GUARANTY TRUST BANK KENYA LIMITED', 'Y', '16'),
(17, 'JAMII BORA BANK', '17', 'JAMII BORA BANK', 'Y', '17'),
(18, 'PARAMOUNT UNIVERSAL BANK LIMITED', '18', 'PARAMOUNT UNIVERSAL BANK LIMITED', 'Y', '18'),
(19, 'EQUATORIAL COMMERCIAL HOLDING LIMITED', '19', 'EQUATORIAL COMMERCIAL HOLDING LIMITED', 'Y', '19'),
(20, 'GIRO COMMERCIAL BANK LIMITED', '20', 'GIRO COMMERCIAL BANK LIMITED', 'Y', '20'),
(21, 'NIC BANK LIMITED', '21', 'NIC BANK LIMITED', 'Y', '21'),
(22, 'IMPERIAL BANK LIMITED', '22', 'IMPERIAL BANK LIMITED', 'Y', '22'),
(23, 'CFC STANBIC BANK KENYA LIMITED', '23', 'CFC STANBIC BANK KENYA LIMITED', 'Y', '23'),
(24, 'CHASE BANK LIMITED', '24', 'CHASE BANK LIMITED', 'Y', '24'),
(25, 'ACCESS BANK (KENYA) PLC', '25', 'ACCESS BANK (KENYA) PLC', 'Y', '25'),
(26, 'CREDIT BANK LIMITED', '26', 'CREDIT BANK LIMITED', 'Y', '26'),
(27, 'CONSOLIDATED BANK OF KENYA LIMITED', '27', 'CONSOLIDATED BANK OF KENYA LIMITED', 'Y', '27'),
(28, 'DUBAI BANK KENYA LIMITED', '28', 'DUBAI BANK KENYA LIMITED', 'Y', '28'),
(29, 'BANK OF AFRICA KENYA LIMITED', '29', 'BANK OF AFRICA KENYA LIMITED', 'Y', '29'),
(30, 'MIDDLE EAST BANK KENYA LIMITED', '30', 'MIDDLE EAST BANK KENYA LIMITED', 'Y', '30'),
(31, 'HABIB BANK A.G. ZURICH', '31', 'HABIB BANK A.G. ZURICH', 'Y', '31'),
(32, 'CITIBANK N.A.', '32', 'CITIBANK N.A.', 'Y', '32'),
(33, 'ORIENTAL COMMERCIAL BANK LIMITED', '33', 'ORIENTAL COMMERCIAL BANK LIMITED', 'Y', '33'),
(34, 'NATIONAL BANK OF KENYA LTD', '34', 'NATIONAL BANK OF KENYA LTD', 'Y', '34'),
(35, 'PRIME BANK LIMITED', '35', 'PRIME BANK LIMITED', 'Y', '35'),
(36, 'CENTRAL BANK OF KENYA', '36', 'CENTRAL BANK OF KENYA', 'Y', '36'),
(37, 'HABIB BANK LIMITED', '37', 'HABIB BANK LIMITED', 'Y', '37'),
(38, 'COMMERCIAL BANK OF AFRICA LIMITED', '38', 'COMMERCIAL BANK OF AFRICA LIMITED', 'Y', '38'),
(39, 'BANK OF BARODA KENYA LIMITED', '39', 'BANK OF BARODA KENYA LIMITED', 'Y', '39'),
(40, 'BANK OF INDIA', '40', 'BANK OF INDIA', 'Y', '40'),
(41, 'ABSA BANK KENYA PLC', '41', 'ABSA BANK KENYA PLC', 'Y', '41'),
(42, 'STANDARD CHARTERED BANK KENYA LIMITED', '42', 'STANDARD CHARTERED BANK KENYA LIMITED', 'Y', '42'),
(43, 'KENYA COMMERCIAL BANK LTD', '43', 'KENYA COMMERCIAL BANK LTD', 'Y', '43'),
(44, 'AFRICAN BANKING CORP BANK LTD', '44', 'AFRICAN BANKING CORP BANK LTD', 'Y', '44'),
(45, 'ECO BANK LIMITED', '45', 'ECO BANK LIMITED', 'Y', '45'),
(46, 'UBA KENYA BANK LTD', '46', 'UBA KENYA BANK LTD', 'Y', '46'),
(47, 'CO-OPERATIVE BANK OF KENYA LIMITED', '47', 'CO-OPERATIVE BANK OF KENYA LIMITED', 'Y', '47');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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