-- phpMyAdmin SQL Dump
-- version 4.1.14
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Mar 14, 2022 at 08:47 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.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 utf8 */;

--
-- Database: `julius`
--

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

--
-- Table structure for table `custmarried`
--

CREATE TABLE IF NOT EXISTS `custmarried` (
  `custmarried_id` int(11) NOT NULL AUTO_INCREMENT,
  `custmarried_status` varchar(15) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`custmarried_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;

--
-- Dumping data for table `custmarried`
--

INSERT INTO `custmarried` (`custmarried_id`, `custmarried_status`) VALUES
(1, 'Single'),
(2, 'Married'),
(3, 'Widowed'),
(4, 'Divorced'),
(5, 'N/A');

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `cust_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_no` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cust_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `cust_dob` int(11) DEFAULT NULL,
  `custsex_id` int(11) DEFAULT NULL,
  `cust_address` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `cust_phone` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cust_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `cust_occup` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `custmarried_id` int(11) DEFAULT NULL,
  `cust_heir` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `cust_heirrel` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `cust_lengthres` int(11) DEFAULT NULL,
  `cust_since` int(11) DEFAULT NULL,
  `custsick_id` int(11) DEFAULT NULL,
  `cust_lastsub` int(11) DEFAULT NULL,
  `cust_active` int(1) NOT NULL DEFAULT '0',
  `cust_lastupd` int(11) DEFAULT NULL,
  `cust_pic` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`cust_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;

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

--
-- Table structure for table `custsex`
--

CREATE TABLE IF NOT EXISTS `custsex` (
  `custsex_id` int(11) NOT NULL AUTO_INCREMENT,
  `custsex_name` varchar(50) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`custsex_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=8 ;

--
-- Dumping data for table `custsex`
--

INSERT INTO `custsex` (`custsex_id`, `custsex_name`) VALUES
(1, 'Male'),
(2, 'Female'),
(3, 'Couple'),
(4, 'Family'),
(5, 'Group'),
(6, 'Institution'),
(7, 'Business');

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

--
-- Table structure for table `custsick`
--

CREATE TABLE IF NOT EXISTS `custsick` (
  `custsick_id` int(11) NOT NULL AUTO_INCREMENT,
  `custsick_name` varchar(50) COLLATE utf8_bin NOT NULL,
  `custsick_risk` int(11) NOT NULL,
  PRIMARY KEY (`custsick_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=7 ;

--
-- Dumping data for table `custsick`
--

INSERT INTO `custsick` (`custsick_id`, `custsick_name`, `custsick_risk`) VALUES
(1, 'Permanent', 1),
(3, 'probation', 3),
(4, 'Contract', 3),
(6, 'None', 0);

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

--
-- Table structure for table `emplmarried`
--

CREATE TABLE IF NOT EXISTS `emplmarried` (
  `emplmarried_id` int(11) NOT NULL AUTO_INCREMENT,
  `emplmarried_status` varchar(15) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`emplmarried_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=5 ;

--
-- Dumping data for table `emplmarried`
--

INSERT INTO `emplmarried` (`emplmarried_id`, `emplmarried_status`) VALUES
(1, 'Single'),
(2, 'Married'),
(3, 'Widowed'),
(4, 'Divorced');

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

--
-- Table structure for table `employee`
--

CREATE TABLE IF NOT EXISTS `employee` (
  `empl_id` int(11) NOT NULL AUTO_INCREMENT,
  `empl_no` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `empl_name` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `empl_dob` int(11) DEFAULT NULL,
  `emplsex_id` int(11) NOT NULL DEFAULT '1',
  `emplmarried_id` int(11) NOT NULL,
  `empl_position` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `empl_salary` int(11) DEFAULT NULL,
  `empl_address` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `empl_phone` varchar(50) COLLATE utf8_bin DEFAULT NULL,
  `empl_email` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `empl_in` int(11) DEFAULT NULL,
  `empl_out` int(11) DEFAULT NULL,
  `empl_lastupd` int(11) NOT NULL,
  `empl_active` int(1) NOT NULL DEFAULT '0',
  `empl_pic` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`empl_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`empl_id`, `empl_no`, `empl_name`, `empl_dob`, `emplsex_id`, `emplmarried_id`, `empl_position`, `empl_salary`, `empl_address`, `empl_phone`, `empl_email`, `empl_in`, `empl_out`, `empl_lastupd`, `empl_active`, `empl_pic`, `user_id`) VALUES
(1, '0', NULL, 0, 0, 0, '', 0, NULL, NULL, NULL, NULL, NULL, 0, 0, NULL, 1);

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

--
-- Table structure for table `emplsex`
--

CREATE TABLE IF NOT EXISTS `emplsex` (
  `emplsex_id` int(11) NOT NULL AUTO_INCREMENT,
  `emplsex_name` varchar(20) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`emplsex_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `emplsex`
--

INSERT INTO `emplsex` (`emplsex_id`, `emplsex_name`) VALUES
(1, 'Male'),
(2, 'Female');

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

--
-- Table structure for table `expenses`
--

CREATE TABLE IF NOT EXISTS `expenses` (
  `exp_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(6) DEFAULT NULL,
  `exptype_id` int(11) NOT NULL,
  `exp_amount` int(11) NOT NULL,
  `exp_date` int(15) DEFAULT NULL,
  `exp_text` varchar(100) COLLATE utf8_bin DEFAULT NULL,
  `exp_recipient` varchar(75) COLLATE utf8_bin DEFAULT NULL,
  `exp_receipt` int(11) DEFAULT NULL,
  `exp_voucher` int(11) DEFAULT NULL,
  `exp_created` int(11) DEFAULT NULL,
  `user_id` int(6) DEFAULT NULL,
  PRIMARY KEY (`exp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `exptype`
--

CREATE TABLE IF NOT EXISTS `exptype` (
  `exptype_id` int(11) NOT NULL AUTO_INCREMENT,
  `exptype_type` varchar(50) COLLATE utf8_bin NOT NULL,
  `exptype_short` varchar(8) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`exptype_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=20 ;

--
-- Dumping data for table `exptype`
--

INSERT INTO `exptype` (`exptype_id`, `exptype_type`, `exptype_short`) VALUES
(1, 'Airtime', 'EXP_AIT'),
(2, 'Bank Charges', 'EXP_BCH'),
(3, 'Committee Welfare', 'EXP_COW'),
(4, 'Electricity', 'EXP_ELC'),
(5, 'Gifts', 'EXP_GFT'),
(6, 'Internet', 'EXP_ITN'),
(7, 'IT', 'EXP_ITC'),
(10, 'Petty Cash', 'EXP_PCA'),
(11, 'Rent', 'EXP_RNT'),
(12, 'Staff Facilitation', 'EXP_SFC'),
(13, 'Staff Welfare', 'EXP_SWF'),
(14, 'Stationery', 'EXP_STN'),
(15, 'Tax', 'EXP_TAX'),
(16, 'Transport', 'EXP_TRN'),
(17, 'Insurance', 'EXP_INS'),
(18, 'Share Dividend', 'EXP_SHD'),
(19, 'Savings Interest', 'EXP_INT');

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

--
-- Table structure for table `fees`
--

CREATE TABLE IF NOT EXISTS `fees` (
  `fee_id` int(11) NOT NULL AUTO_INCREMENT,
  `fee_name` varchar(50) COLLATE utf8_bin NOT NULL,
  `fee_short` varchar(8) COLLATE utf8_bin NOT NULL,
  `fee_value` float DEFAULT NULL,
  PRIMARY KEY (`fee_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;

--
-- Dumping data for table `fees`
--

INSERT INTO `fees` (`fee_id`, `fee_name`, `fee_short`, `fee_value`) VALUES
(1, 'Entrance Fee', 'FEE_ENT', 0),
(2, 'Withdrawal Fee', 'FEE_WDL', 0),
(3, 'Stationery Sales', 'FEE_STS', 0),
(4, 'Anual Subscription', 'FEE_ASB', 0),
(5, 'Loan Fee', 'FEE_LOF', 0),
(6, 'Loan Application Fee', 'FEE_LAP', 5000),
(7, 'Loan Default Fine', 'FEE_LDF', 0),
(8, 'Loan Interest Rate', 'FEE_LIR', 5),
(9, 'Loan Insurance', 'FEE_INS', 0),
(10, 'Loan Stationery', 'FEE_XL1', 0);

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

--
-- Table structure for table `incomes`
--

CREATE TABLE IF NOT EXISTS `incomes` (
  `inc_id` int(11) NOT NULL AUTO_INCREMENT,
  `inctype_id` int(11) NOT NULL,
  `cust_id` int(11) DEFAULT NULL,
  `loan_id` int(11) DEFAULT NULL,
  `ltrans_id` int(11) DEFAULT NULL,
  `sav_id` int(11) DEFAULT NULL,
  `inc_amount` int(11) NOT NULL,
  `inc_date` int(15) NOT NULL,
  `inc_receipt` int(11) NOT NULL,
  `inc_text` varchar(200) COLLATE utf8_bin NOT NULL,
  `inc_created` int(11) NOT NULL,
  `user_id` int(6) NOT NULL,
  PRIMARY KEY (`inc_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=59 ;

--
-- Dumping data for table `incomes`
--

INSERT INTO `incomes` (`inc_id`, `inctype_id`, `cust_id`, `loan_id`, `ltrans_id`, `sav_id`, `inc_amount`, `inc_date`, `inc_receipt`, `inc_text`, `inc_created`, `user_id`) VALUES
(27, 10, 3, 6, NULL, NULL, 0, 1646607600, 0, '', 1646657257, 2),
(28, 7, 2, 7, NULL, NULL, 20000, 1646607600, 11, '', 1646657488, 2),
(29, 3, 2, 7, NULL, NULL, 1000, 1646607600, 0, '', 1646657527, 2),
(30, 10, 2, 7, NULL, NULL, 0, 1646607600, 0, '', 1646657527, 2),
(31, 1, 7, NULL, NULL, NULL, 0, 1646607600, 64, '', 1646658415, 2),
(32, 6, 7, NULL, NULL, NULL, 0, 1646607600, 64, '', 1646658415, 2),
(33, 7, 6, 8, NULL, NULL, 20000, 1646607600, 55, '', 1646658904, 2),
(34, 3, 6, 8, NULL, NULL, 1000, 1646607600, 0, '', 1646658946, 2),
(35, 10, 6, 8, NULL, NULL, 0, 1646607600, 0, '', 1646658946, 2),
(36, 7, 2, 9, NULL, NULL, 20000, 1646607600, 77, '', 1646662801, 2),
(37, 3, 2, 9, NULL, NULL, 1000, 1646607600, 0, '', 1646662835, 2),
(38, 10, 2, 9, NULL, NULL, 0, 1646607600, 0, '', 1646662835, 2),
(39, 4, 3, NULL, 9, NULL, 30000, 1646694000, 870, '', 1646716266, 2),
(40, 7, 2, 10, NULL, NULL, 20000, 1646780400, 709, '', 1646813940, 2),
(41, 3, 2, 10, NULL, NULL, 1000, 1646780400, 0, '', 1646813985, 2),
(42, 10, 2, 10, NULL, NULL, 0, 1646780400, 0, '', 1646813985, 2),
(46, 4, 3, NULL, 10, NULL, 20000, 1646780400, 989, '', 1646897695, 2),
(48, 1, 8, NULL, NULL, NULL, 0, 1646866800, 494, '', 1646912219, 2),
(49, 6, 8, NULL, NULL, NULL, 0, 1646866800, 494, '', 1646912219, 2),
(50, 1, 9, NULL, NULL, NULL, 0, 1646866800, 92022, '', 1646912788, 2),
(51, 6, 9, NULL, NULL, NULL, 0, 1646866800, 92022, '', 1646912788, 2),
(52, 1, 10, NULL, NULL, NULL, 0, 1646866800, 10, '', 1646913109, 2),
(53, 6, 10, NULL, NULL, NULL, 0, 1646866800, 10, '', 1646913109, 2),
(54, 7, 8, 12, NULL, NULL, 20000, 1646002800, 90, '', 1646913709, 2),
(55, 3, 8, 12, NULL, NULL, 2000, 1646002800, 0, '', 1646913803, 2),
(56, 10, 8, 12, NULL, NULL, 0, 1646002800, 0, '', 1646913803, 2),
(57, 1, 11, NULL, NULL, NULL, 0, 1646348400, 112022, '', 1646915776, 2),
(58, 6, 11, NULL, NULL, NULL, 0, 1646348400, 112022, '', 1646915776, 2);

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

--
-- Table structure for table `inctype`
--

CREATE TABLE IF NOT EXISTS `inctype` (
  `inctype_id` int(11) NOT NULL AUTO_INCREMENT,
  `inctype_type` varchar(50) COLLATE utf8_bin NOT NULL,
  `inctype_short` varchar(8) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`inctype_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=12 ;

--
-- Dumping data for table `inctype`
--

INSERT INTO `inctype` (`inctype_id`, `inctype_type`, `inctype_short`) VALUES
(1, 'Entrance Fee', 'INC_ENF'),
(2, 'Withdrawal Fee', 'INC_WDF'),
(3, 'Loan Fee', 'INC_LOF'),
(4, 'Loan Interest', 'INC_INT'),
(5, 'Loan Default Fine', 'INC_LDF'),
(6, 'Stationery Sales', 'INC_STS'),
(7, 'Loan Application Fee', 'INC_LAF'),
(8, 'Subscription Fee', 'INC_SUF'),
(9, 'Other', 'INC_OTH'),
(10, 'Insurance', 'INC_INS'),
(11, 'Loan Stationery', 'INC_XL1');

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

--
-- Table structure for table `loans`
--

CREATE TABLE IF NOT EXISTS `loans` (
  `loan_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) NOT NULL,
  `loanstatus_id` int(11) NOT NULL,
  `loan_no` varchar(20) COLLATE utf8_bin NOT NULL,
  `loan_date` int(15) NOT NULL,
  `loan_dateout` int(11) NOT NULL,
  `loan_issued` int(2) NOT NULL,
  `loan_principal` int(11) NOT NULL,
  `loan_principalapproved` int(11) NOT NULL,
  `loan_interest` float NOT NULL,
  `loan_appfee_receipt` int(11) NOT NULL,
  `loan_fee` int(11) NOT NULL,
  `loan_fee_receipt` int(11) NOT NULL,
  `loan_insurance` int(11) NOT NULL,
  `loan_insurance_receipt` int(11) NOT NULL,
  `loan_rate` decimal(11,0) NOT NULL,
  `loan_period` int(11) NOT NULL,
  `loan_repaytotal` int(11) NOT NULL,
  `loan_purpose` varchar(250) COLLATE utf8_bin NOT NULL,
  `loan_guarant1` int(11) NOT NULL,
  `loan_guarant2` int(11) NOT NULL,
  `loan_guarant3` int(11) NOT NULL,
  `loan_feepaid` int(1) NOT NULL DEFAULT '0',
  `loan_created` int(15) DEFAULT NULL,
  `loan_xtra1` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `loan_xtraFee1` int(11) DEFAULT NULL,
  `user_id` int(6) NOT NULL,
  PRIMARY KEY (`loan_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=14 ;

--
-- Dumping data for table `loans`
--

INSERT INTO `loans` (`loan_id`, `cust_id`, `loanstatus_id`, `loan_no`, `loan_date`, `loan_dateout`, `loan_issued`, `loan_principal`, `loan_principalapproved`, `loan_interest`, `loan_appfee_receipt`, `loan_fee`, `loan_fee_receipt`, `loan_insurance`, `loan_insurance_receipt`, `loan_rate`, `loan_period`, `loan_repaytotal`, `loan_purpose`, `loan_guarant1`, `loan_guarant2`, `loan_guarant3`, `loan_feepaid`, `loan_created`, `loan_xtra1`, `loan_xtraFee1`, `user_id`) VALUES
(11, 5, 2, 'L-5/2022-1', 1646780400, 1646780400, 1, 100000, 100000, 0.76, 546, 1000, 0, 0, 0, '4760', 26, 119800, 'business', 3, 7, 0, 0, 1646814638, 'john', 0, 2),
(13, 6, 2, 'L-6/2022-3', 1646866800, 1646866800, 1, 100000, 100000, 7.5, 908, 0, 0, 0, 0, '32500', 4, 130000, 'busines growth', 8, 9, 0, 0, 1646921702, 'jane', 0, 2);

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

--
-- Table structure for table `loanstatus`
--

CREATE TABLE IF NOT EXISTS `loanstatus` (
  `loanstatus_id` int(11) NOT NULL AUTO_INCREMENT,
  `loanstatus_status` varchar(50) COLLATE utf8_bin NOT NULL,
  `loanstatus_short` varchar(8) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`loanstatus_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=6 ;

--
-- Dumping data for table `loanstatus`
--

INSERT INTO `loanstatus` (`loanstatus_id`, `loanstatus_status`, `loanstatus_short`) VALUES
(1, 'Pending', 'LST_PEN'),
(2, 'Approved', 'LST_APP'),
(3, 'Refused', 'LST_REF'),
(4, 'Abandoned', 'LST_ABN'),
(5, 'Cleared', 'LST_CLR');

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

--
-- Table structure for table `logrec`
--

CREATE TABLE IF NOT EXISTS `logrec` (
  `logrec_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `logrec_start` int(11) DEFAULT NULL,
  `logrec_end` int(11) DEFAULT NULL,
  `logrec_logout` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`logrec_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=49 ;

--
-- Dumping data for table `logrec`
--

INSERT INTO `logrec` (`logrec_id`, `user_id`, `logrec_start`, `logrec_end`, `logrec_logout`) VALUES
(1, 2, 1646145109, 1646146984, 1),
(2, 2, 1646155736, 1646157777, 0),
(3, 2, 1646157777, 1646157804, 1),
(4, 2, 1646157947, 1646159512, 1),
(5, 2, 1646198853, 1646199099, 1),
(6, 2, 1646199209, 1646200949, 1),
(7, 3, 1646201192, 1646205381, 1),
(8, 2, 1646205612, 1646205796, 1),
(9, 2, 1646205940, 1646205948, 1),
(10, 2, 1646206025, 1646206030, 1),
(11, 2, 1646221091, 1646221818, 0),
(12, 2, 1646221818, 1646221955, 1),
(13, 2, 1646222399, 1646232888, 1),
(14, 2, 1646238103, 1646239608, 1),
(15, 3, 1646239637, 1646240971, 1),
(16, 2, 1646241394, 1646245998, 1),
(17, 2, 1646402741, 1646403085, 1),
(18, 2, 1646403523, 1646405366, 1),
(19, 2, 1646405425, 1646405562, 1),
(20, 2, 1646420200, 1646420291, 1),
(21, 2, 1646420361, 1646420441, 1),
(22, 2, 1646420469, 1646422871, 1),
(23, 2, 1646458631, 1646460115, 1),
(24, 2, 1646461708, 1646464211, 0),
(25, 2, 1646464211, 1646472150, 0),
(26, 2, 1646472150, 1646473223, 0),
(27, 2, 1646473223, 1646473815, 1),
(28, 2, 1646474058, 1646478847, 1),
(29, 2, 1646628513, 1646628680, 0),
(30, 2, 1646628680, 1646648011, 0),
(31, 2, 1646648011, 1646658782, 0),
(32, 2, 1646658782, 1646662615, 0),
(33, 2, 1646662615, 1646663990, 1),
(34, 2, 1646667741, 1646668139, 1),
(35, 2, 1646714782, 1646719386, 1),
(36, 2, 1646728893, 1646745793, 0),
(37, 2, 1646745793, 1646748540, 1),
(38, 2, 1646751186, 1646763256, 1),
(39, 2, 1646763302, 1646768199, 1),
(40, 2, 1646806011, 1646808866, 1),
(41, 2, 1646811802, 1646814453, 0),
(42, 2, 1646814453, 1646816493, 1),
(43, 2, 1646896349, 1646909656, 1),
(44, 2, 1646911375, 1646922273, 1),
(45, 2, 1646926761, 1646927739, 1),
(46, 2, 1646974345, 1646974529, 0),
(47, 2, 1646974529, 1646975692, 1),
(48, 2, 1647232660, 1647236647, 1);

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

--
-- Table structure for table `ltrans`
--

CREATE TABLE IF NOT EXISTS `ltrans` (
  `ltrans_id` int(11) NOT NULL AUTO_INCREMENT,
  `loan_id` int(11) NOT NULL,
  `ltrans_due` int(11) DEFAULT NULL,
  `ltrans_date` int(15) DEFAULT NULL,
  `ltrans_principaldue` int(11) DEFAULT NULL,
  `ltrans_principal` int(15) DEFAULT NULL,
  `ltrans_interestdue` int(11) DEFAULT NULL,
  `ltrans_interest` int(11) DEFAULT NULL,
  `ltrans_fined` int(1) NOT NULL DEFAULT '0',
  `ltrans_receipt` int(11) DEFAULT NULL,
  `ltrans_created` int(15) DEFAULT NULL,
  `user_id` int(6) NOT NULL,
  PRIMARY KEY (`ltrans_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=158 ;

--
-- Dumping data for table `ltrans`
--

INSERT INTO `ltrans` (`ltrans_id`, `loan_id`, `ltrans_due`, `ltrans_date`, `ltrans_principaldue`, `ltrans_principal`, `ltrans_interestdue`, `ltrans_interest`, `ltrans_fined`, `ltrans_receipt`, `ltrans_created`, `user_id`) VALUES
(26, 6, 1648162800, NULL, 3000, NULL, 12600, NULL, 0, NULL, NULL, 2),
(27, 6, 1648249200, NULL, 3000, NULL, 11700, NULL, 0, NULL, NULL, 2),
(28, 6, 1648335600, NULL, 3000, NULL, 10800, NULL, 0, NULL, NULL, 2),
(29, 6, 1648422000, NULL, 3000, NULL, 9900, NULL, 0, NULL, NULL, 2),
(30, 6, 1648508400, NULL, 3000, NULL, 9000, NULL, 0, NULL, NULL, 2),
(31, 6, 1648594800, NULL, 3000, NULL, 8100, NULL, 0, NULL, NULL, 2),
(32, 6, 1648681200, NULL, 3000, NULL, 7200, NULL, 0, NULL, NULL, 2),
(33, 6, 1648767600, NULL, 3000, NULL, 6300, NULL, 0, NULL, NULL, 2),
(34, 6, 1648854000, NULL, 3000, NULL, 5400, NULL, 0, NULL, NULL, 2),
(35, 6, 1648940400, NULL, 3000, NULL, 4500, NULL, 0, NULL, NULL, 2),
(36, 6, 1649026800, NULL, 3000, NULL, 3600, NULL, 0, NULL, NULL, 2),
(37, 6, 1649113200, NULL, 3000, NULL, 2700, NULL, 0, NULL, NULL, 2),
(38, 6, 1649199600, NULL, 3000, NULL, 1800, NULL, 0, NULL, NULL, 2),
(39, 6, 1649286000, NULL, 3000, NULL, 900, NULL, 0, NULL, NULL, 2),
(40, 7, 1646694000, NULL, 25000, NULL, 30000, NULL, 0, NULL, NULL, 2),
(41, 7, 1646780400, NULL, 25000, NULL, 22500, NULL, 0, NULL, NULL, 2),
(42, 7, 1646866800, NULL, 25000, NULL, 15000, NULL, 0, NULL, NULL, 2),
(43, 7, 1646953200, NULL, 25000, NULL, 7500, NULL, 0, NULL, NULL, 2),
(44, 8, 1647212400, NULL, 25000, NULL, 5000, NULL, 0, NULL, NULL, 2),
(45, 8, 1647817200, NULL, 25000, NULL, 3750, NULL, 0, NULL, NULL, 2),
(46, 8, 1648422000, NULL, 25000, NULL, 2500, NULL, 0, NULL, NULL, 2),
(47, 8, 1649026800, NULL, 25000, NULL, 1250, NULL, 0, NULL, NULL, 2),
(48, 9, 1647212400, NULL, 0, NULL, 800, NULL, 0, NULL, NULL, 2),
(49, 9, 1647817200, NULL, 4000, NULL, 800, NULL, 0, NULL, NULL, 2),
(50, 9, 1648422000, NULL, 4000, NULL, 768, NULL, 0, NULL, NULL, 2),
(51, 9, 1649026800, NULL, 4000, NULL, 736, NULL, 0, NULL, NULL, 2),
(52, 9, 1649631600, NULL, 4000, NULL, 704, NULL, 0, NULL, NULL, 2),
(53, 9, 1650236400, NULL, 4000, NULL, 672, NULL, 0, NULL, NULL, 2),
(54, 9, 1650841200, NULL, 4000, NULL, 640, NULL, 0, NULL, NULL, 2),
(55, 9, 1651446000, NULL, 4000, NULL, 608, NULL, 0, NULL, NULL, 2),
(56, 9, 1652050800, NULL, 4000, NULL, 576, NULL, 0, NULL, NULL, 2),
(57, 9, 1652655600, NULL, 4000, NULL, 544, NULL, 0, NULL, NULL, 2),
(58, 9, 1653260400, NULL, 4000, NULL, 512, NULL, 0, NULL, NULL, 2),
(59, 9, 1653865200, NULL, 4000, NULL, 480, NULL, 0, NULL, NULL, 2),
(60, 9, 1654470000, NULL, 4000, NULL, 448, NULL, 0, NULL, NULL, 2),
(61, 9, 1655074800, NULL, 4000, NULL, 416, NULL, 0, NULL, NULL, 2),
(62, 9, 1655679600, NULL, 4000, NULL, 384, NULL, 0, NULL, NULL, 2),
(63, 9, 1656284400, NULL, 4000, NULL, 352, NULL, 0, NULL, NULL, 2),
(64, 9, 1656889200, NULL, 4000, NULL, 320, NULL, 0, NULL, NULL, 2),
(65, 9, 1657494000, NULL, 4000, NULL, 288, NULL, 0, NULL, NULL, 2),
(66, 9, 1658098800, NULL, 4000, NULL, 256, NULL, 0, NULL, NULL, 2),
(67, 9, 1658703600, NULL, 4000, NULL, 224, NULL, 0, NULL, NULL, 2),
(68, 9, 1659308400, NULL, 4000, NULL, 192, NULL, 0, NULL, NULL, 2),
(69, 9, 1659913200, NULL, 4000, NULL, 160, NULL, 0, NULL, NULL, 2),
(70, 9, 1660518000, NULL, 4000, NULL, 128, NULL, 0, NULL, NULL, 2),
(71, 9, 1661122800, NULL, 4000, NULL, 96, NULL, 0, NULL, NULL, 2),
(72, 9, 1661727600, NULL, 4000, NULL, 64, NULL, 0, NULL, NULL, 2),
(73, 9, 1662332400, NULL, 4000, NULL, 32, NULL, 0, NULL, NULL, 2),
(74, 10, 1649458800, NULL, 0, NULL, 800, NULL, 0, NULL, NULL, 2),
(75, 10, 1652137200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(76, 10, 1654815600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(77, 10, 1657494000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(78, 10, 1660172400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(79, 10, 1662850800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(80, 10, 1665529200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(81, 10, 1668207600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(82, 10, 1670886000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(83, 10, 1673564400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(84, 10, 1676242800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(85, 10, 1678921200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(86, 10, 1681599600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(87, 10, 1684278000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(88, 10, 1686956400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(89, 10, 1689634800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(90, 10, 1692313200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(91, 10, 1694991600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(92, 10, 1697670000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(93, 10, 1700348400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(94, 10, 1703026800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(95, 10, 1705705200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(96, 10, 1708383600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(97, 10, 1711062000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(98, 10, 1713740400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(99, 10, 1716418800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(101, 11, 1646953200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(102, 11, 1647039600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(103, 11, 1647126000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(104, 11, 1647212400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(105, 11, 1647298800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(106, 11, 1647385200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(107, 11, 1647471600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(108, 11, 1647558000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(109, 11, 1647644400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(110, 11, 1647730800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(111, 11, 1647817200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(112, 11, 1647903600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(113, 11, 1647990000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(114, 11, 1648076400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(115, 11, 1648162800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(116, 11, 1648249200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(117, 11, 1648335600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(118, 11, 1648422000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(119, 11, 1648508400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(120, 11, 1648594800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(121, 11, 1648681200, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(122, 11, 1648767600, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(123, 11, 1648854000, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(124, 11, 1648940400, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(125, 11, 1649026800, NULL, 4000, NULL, 760, NULL, 0, NULL, NULL, 2),
(126, 12, 1646089200, NULL, 11000, NULL, 2170, NULL, 0, NULL, NULL, 2),
(127, 12, 1646175600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(128, 12, 1646262000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(129, 12, 1646348400, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(130, 12, 1646434800, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(131, 12, 1646521200, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(132, 12, 1646607600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(133, 12, 1646694000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(134, 12, 1646780400, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(135, 12, 1646866800, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(136, 12, 1646953200, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(137, 12, 1647039600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(138, 12, 1647126000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(139, 12, 1647212400, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(140, 12, 1647298800, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(141, 12, 1647385200, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(142, 12, 1647471600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(143, 12, 1647558000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(144, 12, 1647644400, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(145, 12, 1647730800, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(146, 12, 1647817200, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(147, 12, 1647903600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(148, 12, 1647990000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(149, 12, 1648076400, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(150, 12, 1648162800, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(151, 12, 1648249200, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(152, 12, 1648335600, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(153, 12, 1648422000, NULL, 7000, NULL, 2140, NULL, 0, NULL, NULL, 2),
(154, 13, 1646953200, NULL, 25000, NULL, 7500, NULL, 0, NULL, NULL, 2),
(155, 13, 1647039600, NULL, 25000, NULL, 7500, NULL, 0, NULL, NULL, 2),
(156, 13, 1647126000, NULL, 25000, NULL, 7500, NULL, 0, NULL, NULL, 2),
(157, 13, 1647212400, NULL, 25000, NULL, 7500, NULL, 0, NULL, NULL, 2);

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

--
-- Table structure for table `savbalance`
--

CREATE TABLE IF NOT EXISTS `savbalance` (
  `savbal_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) NOT NULL,
  `savbal_balance` int(11) NOT NULL,
  `savbal_fixed` int(11) NOT NULL,
  `savbal_date` int(11) NOT NULL,
  `savbal_created` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`savbal_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=11 ;

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

--
-- Table structure for table `savings`
--

CREATE TABLE IF NOT EXISTS `savings` (
  `sav_id` int(11) NOT NULL AUTO_INCREMENT,
  `savtype_id` int(11) NOT NULL,
  `sav_mother` int(11) DEFAULT NULL,
  `cust_id` int(11) NOT NULL,
  `ltrans_id` int(11) DEFAULT NULL,
  `sav_date` int(15) NOT NULL,
  `sav_amount` int(15) NOT NULL DEFAULT '0',
  `sav_receipt` int(11) DEFAULT NULL,
  `sav_slip` int(10) NOT NULL,
  `sav_payer` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `sav_fixed` int(11) DEFAULT NULL,
  `sav_created` int(15) DEFAULT NULL,
  `user_id` int(6) NOT NULL,
  PRIMARY KEY (`sav_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `savtype`
--

CREATE TABLE IF NOT EXISTS `savtype` (
  `savtype_id` int(11) NOT NULL AUTO_INCREMENT,
  `savtype_type` varchar(20) COLLATE utf8_bin NOT NULL,
  `savtype_short` varchar(8) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`savtype_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=10 ;

--
-- Dumping data for table `savtype`
--

INSERT INTO `savtype` (`savtype_id`, `savtype_type`, `savtype_short`) VALUES
(1, 'Deposit', 'SAV_DEP'),
(2, 'Withdrawal', 'SAV_WDL'),
(3, 'Savings Interest', 'SAV_INT'),
(4, 'W/drawal Fee', 'SAV_WDF'),
(5, 'Subscription Fee', 'SAV_SUF'),
(6, 'Loan Default Fine', 'SAV_LDF'),
(7, 'Loan Fee', 'SAV_LOF'),
(8, 'Loan Repayment', 'SAV_LRP'),
(9, 'Share Dividend', 'SAV_SHD');

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

--
-- Table structure for table `securities`
--

CREATE TABLE IF NOT EXISTS `securities` (
  `sec_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(8) NOT NULL,
  `loan_id` int(8) NOT NULL,
  `sec_no` varchar(50) COLLATE utf8_bin NOT NULL,
  `sec_name` varchar(100) COLLATE utf8_bin NOT NULL,
  `sec_value` int(11) NOT NULL,
  `sec_path` varchar(200) COLLATE utf8_bin NOT NULL,
  `sec_returned` int(1) NOT NULL DEFAULT '0',
  `sec_date` int(11) NOT NULL,
  `sec_returned_date` int(11) NOT NULL,
  `sec_lastupd` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`sec_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=20 ;

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

--
-- Table structure for table `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `set_id` int(11) NOT NULL AUTO_INCREMENT,
  `set_name` varchar(100) COLLATE utf8_bin NOT NULL,
  `set_short` varchar(8) COLLATE utf8_bin NOT NULL,
  `set_value` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`set_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=18 ;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`set_id`, `set_name`, `set_short`, `set_value`) VALUES
(1, 'Minimum Savings Balance', 'SET_MSB', ''),
(2, 'Minimum Loan Principal', 'SET_MLP', '50000'),
(3, 'Maximum Loan Principal', 'SET_XLP', '500000'),
(4, 'Currency Abbreviation', 'SET_CUR', 'UGX'),
(5, 'Auto-fine Defaulters', 'SET_AUF', '1'),
(6, 'Account Deactivation', 'SET_DEA', '1'),
(7, 'Dashboard Left', 'SET_DBL', 'dashboard/dash_subscr.php'),
(8, 'Dashboard Right', 'SET_DBR', 'dashboard/dash_loandefaults.php'),
(9, 'Interest Calculation', 'SET_ICL', 'modules/mod_inter_fixed.php'),
(10, 'Guarantor Limit', 'SET_GUA', '2'),
(11, 'Minimum Membership', 'SET_MEM', '1'),
(12, 'Maximum Principal-Savings Ratio', 'SET_PSR', '25000'),
(13, 'Customer Number Format', 'SET_CNO', '%N%/%Y'),
(14, 'Employee Number Format', 'SET_ENO', '%N%-%Y'),
(15, 'Additional Field Loans', 'SET_XL1', 'Spouse'),
(16, 'Fixed Savings', 'SET_SFX', '0'),
(17, 'Customer Search by ID', 'SET_CSI', '1');

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

--
-- Table structure for table `shares`
--

CREATE TABLE IF NOT EXISTS `shares` (
  `share_id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` int(11) NOT NULL,
  `share_date` int(11) NOT NULL,
  `share_amount` int(11) NOT NULL,
  `share_value` int(11) NOT NULL,
  `share_receipt` int(11) NOT NULL,
  `share_trans` int(2) NOT NULL,
  `share_transfrom` int(11) DEFAULT NULL,
  `share_created` int(15) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  PRIMARY KEY (`share_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=13 ;

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

--
-- Table structure for table `shareval`
--

CREATE TABLE IF NOT EXISTS `shareval` (
  `shareval_id` int(11) NOT NULL AUTO_INCREMENT,
  `shareval_date` int(11) NOT NULL,
  `shareval_value` int(11) NOT NULL,
  PRIMARY KEY (`shareval_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;

--
-- Dumping data for table `shareval`
--

INSERT INTO `shareval` (`shareval_id`, `shareval_date`, `shareval_value`) VALUES
(1, 1646422263, 10000),
(2, 1646469111, 100000),
(3, 1646912315, 5000);

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

--
-- Table structure for table `ugroup`
--

CREATE TABLE IF NOT EXISTS `ugroup` (
  `ugroup_id` int(11) NOT NULL AUTO_INCREMENT,
  `ugroup_name` varchar(100) COLLATE utf8_bin NOT NULL,
  `ugroup_admin` int(11) NOT NULL,
  `ugroup_delete` int(2) NOT NULL,
  `ugroup_report` int(11) NOT NULL,
  `ugroup_created` int(15) NOT NULL,
  PRIMARY KEY (`ugroup_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ugroup`
--

INSERT INTO `ugroup` (`ugroup_id`, `ugroup_name`, `ugroup_admin`, `ugroup_delete`, `ugroup_report`, `ugroup_created`) VALUES
(1, 'Administrator', 1, 1, 1, 1453123220),
(2, 'loans offficers', 1, 0, 1, 1646239531);

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

--
-- Table structure for table `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(200) COLLATE utf8_bin NOT NULL,
  `user_pw` varchar(255) COLLATE utf8_bin NOT NULL,
  `ugroup_id` int(11) NOT NULL,
  `empl_id` int(11) NOT NULL,
  `user_created` int(15) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=4 ;

--
-- Dumping data for table `user`
--

INSERT INTO `user` (`user_id`, `user_name`, `user_pw`, `ugroup_id`, `empl_id`, `user_created`) VALUES
(1, '', '', 0, 0, 0),
(2, 'julius', '$2y$10$xYm9qZU3SCW3eI.GNhB0gu/c1AjRWBA/bMYzkXx4g9AojfxowP.32', 1, 0, 1646145079),
(3, 'jolly@gmail.com', '$2y$10$o010MEcpiWRn7lxMJ0AUCuEtc4tk1LeHU5y1b0dBor0VlaNFNlts6', 2, 2, 1646239597);

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