byp4a55 professor6T9

Linux premium133.web-hosting.com 4.18.0-553.44.1.lve.el8.x86_64 #1 SMP Thu Mar 13 14:29:12 UTC 2025 x86_64
LiteSpeed
162.0.232.69

Vcccul-sms (2).sql

-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Jun 08, 2023 at 02:44 PM
-- Server version: 10.4.27-MariaDB
-- PHP Version: 8.0.25

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

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

--
-- Table structure for table `a2a_transactions`
--

CREATE TABLE `a2a_transactions` (
  `id` int(11) NOT NULL,
  `acc2_debit` int(11) NOT NULL,
  `acc2_debit_type` varchar(255) NOT NULL,
  `acc2_credit` int(11) NOT NULL,
  `acc2_credit_type` varchar(255) NOT NULL,
  `amount` int(200) NOT NULL,
  `description` varchar(255) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `a2a_transactions`
--

INSERT INTO `a2a_transactions` (`id`, `acc2_debit`, `acc2_debit_type`, `acc2_credit`, `acc2_credit_type`, `amount`, `description`, `trans_code`, `date`, `executed_by`) VALUES
(3, 9999, 'Savings', 8888, 'Savings', 100000, 'SO', 'PR2131400035', 'Wednesday 17 May 2023', 43),
(4, 9999, 'Deposit', 8888, 'Savings', 100000, 'sewse', 'PR1303913678', 'Wednesday 17 May 2023', 43),
(5, 9999, 'Deposit', 8888, 'Deposit', 100000, '', 'PR2015841811', 'Wednesday 17 May 2023', 43),
(6, 9999, 'Deposit', 8888, 'Deposit', 100000, '', 'PR2051083232', 'Wednesday 17 May 2023', 43),
(7, 9999, 'Savings', 8888, 'Deposit', 100000, '', 'PR707400605', 'Wednesday 17 May 2023', 43),
(8, 9999, 'Savings', 8888, 'Savings', 200000, '', 'PR1732387490', 'Friday 19 May 2023', 42),
(9, 9999, 'Deposit', 88888, 'Savings', 10, '', 'PR1821249684', 'Friday 19 May 2023', 42),
(10, 9999, 'Savings', 8888, 'Deposit', 10000, '', 'PR196296458', 'Friday 19 May 2023', 42);

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

--
-- Table structure for table `bal_adjustmenst`
--

CREATE TABLE `bal_adjustmenst` (
  `id` int(11) NOT NULL,
  `acc_number` int(20) NOT NULL,
  `account_type` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `amount` int(100) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `bal_adjustmenst`
--

INSERT INTO `bal_adjustmenst` (`id`, `acc_number`, `account_type`, `date`, `amount`, `executed_by`) VALUES
(1, 9999, 'Savings', 'Friday 19 May 2023', 200, 42),
(2, 9999, 'Deposit', 'Friday 19 May 2023', 10, 42),
(3, 9999, 'Shares', 'Friday 19 May 2023', 1800, 42),
(4, 9999, 'Main Loan', 'Friday 19 May 2023', 100, 42);

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

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int(11) NOT NULL,
  `branch_name` varchar(255) NOT NULL,
  `branch_location` varchar(255) NOT NULL,
  `branch_manager` varchar(255) NOT NULL,
  `branch_manager_phone` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `branch_name`, `branch_location`, `branch_manager`, `branch_manager_phone`) VALUES
(4, 'Bota Branch', '', '', ''),
(5, 'Mile 4 Branch', '', '', ''),
(6, 'Idenau Branch', '', '', ''),
(7, 'New Town Branch', '', '', ''),
(8, 'Douala Branch', '', '', ''),
(9, 'Kribi Branch', '', '', ''),
(10, 'Yaounde Branch', '', '', ''),
(11, 'Bamenda Branch', '', '', '');

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

--
-- Table structure for table `emoluments`
--

CREATE TABLE `emoluments` (
  `id` int(11) NOT NULL,
  `emolument_code` varchar(255) NOT NULL,
  `emolument` varchar(255) NOT NULL,
  `intervals` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `emoluments`
--

INSERT INTO `emoluments` (`id`, `emolument_code`, `emolument`, `intervals`) VALUES
(9, 'ID:7329', 'OT/TEL', 'Monthly'),
(11, 'ID:43165', 'Remise', 'Quarterly'),
(12, 'ID:37266', 'SGS Prime Scanner', 'Quarterly'),
(13, 'ID:77454', 'Penalties ', ''),
(14, 'ID:27171', 'Fond Commen', 'Quarterly'),
(15, 'ID:50418', 'Forestier Prime', ''),
(16, 'ID:2828', 'Gardeniage Prime', ''),
(17, 'ID:24223', 'Protocal', ''),
(18, 'ID:90407', 'Prime Special', ''),
(19, 'ID:453', 'Prime Specific', ''),
(20, 'ID:65783', 'Others', '');

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

--
-- Table structure for table `emolument_transactions`
--

CREATE TABLE `emolument_transactions` (
  `id` int(11) NOT NULL,
  `acc_number` int(200) NOT NULL,
  `emolument` varchar(255) NOT NULL,
  `amount` int(200) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `emolument_transactions`
--

INSERT INTO `emolument_transactions` (`id`, `acc_number`, `emolument`, `amount`, `trans_code`, `date`, `executed_by`) VALUES
(1, 9999, 'OT/TEL', 10000, 'EM1604756329', 'Wednesday 17 May 2023', 43),
(2, 8888, 'OT/TEL', 32040, 'EM299818943', 'Friday 19 May 2023', 42),
(3, 8888, 'Penalties ', 74760, 'EM608002584', 'Friday 19 May 2023', 42),
(4, 9999, 'Fond Commen', 1000000, 'EM987133322', 'Friday 19 May 2023', 42),
(5, 9999, 'Protocal', 1000000, 'EM407923714', 'Friday 19 May 2023', 42),
(6, 9999, 'Forestier Prime', 200000, 'EM1521624737', 'Friday 19 May 2023', 42),
(7, 9999, 'Fond Commen', 3000, 'EM1133239372', 'Friday 19 May 2023', 42),
(8, 8888, 'Remise', 900, 'EM49206978', 'Friday 19 May 2023', 42),
(9, 9999, 'Others', 21000, 'EM2058364035', 'Friday 19 May 2023', 42),
(10, 9999, 'Protocal', 32040, 'EM1833720826', 'Tuesday 06 Jun 2023', 42),
(11, 9999, 'Forestier Prime', 74760, 'EM1592569357', 'Tuesday 06 Jun 2023', 42),
(12, 9999, 'Others', 29000, 'EM1551190644', 'Tuesday 06 Jun 2023', 42),
(13, 9999, 'Remise', 8000, 'EM187012321', 'Tuesday 06 Jun 2023', 42);

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

--
-- Table structure for table `interbranch_transactions`
--

CREATE TABLE `interbranch_transactions` (
  `id` int(11) NOT NULL,
  `acc_number` int(200) NOT NULL,
  `done_at` varchar(255) NOT NULL,
  `trans_type` varchar(255) NOT NULL,
  `account_type` varchar(255) NOT NULL,
  `amount` int(255) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `interbranch_transactions`
--

INSERT INTO `interbranch_transactions` (`id`, `acc_number`, `done_at`, `trans_type`, `account_type`, `amount`, `trans_code`, `date`, `executed_by`) VALUES
(1, 9999, 'Bota Branch', '', 'Savings', 1000, 'INT-br113939283', 'Wednesday 17 May 2023', 1),
(2, 9999, 'Bota Branch', 'Deposit', 'Savings', 74700, 'INT-br207987204', 'Wednesday 17 May 2023', 1),
(3, 9999, 'Mile 4 Branch', 'Deposit', 'Deposit', 100000, 'INT-br2078063438', 'Wednesday 17 May 2023', 1),
(4, 9999, 'Kribi Branch', 'Withdrawal', 'Savings', 74700, 'INT-br189974453', 'Wednesday 17 May 2023', 1),
(5, 9999, 'Bamenda Branch', 'Withdrawal', 'Deposit', 100000, 'INT-br1719540127', 'Wednesday 17 May 2023', 1),
(6, 9999, 'Mile 4 Branch', 'Deposit', 'Savings', 100000, 'INT-br2093920726', 'Friday 19 May 2023', 42),
(7, 9999, 'Idenau Branch', 'Withdrawal', 'Savings', 100000, 'INT-br8629524', 'Friday 19 May 2023', 42),
(8, 8888, 'Idenau Branch', 'Withdrawal', 'Deposit', 100000000, 'INT-br1100225692', 'Monday 22 May 2023', 42);

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

--
-- Table structure for table `loan`
--

CREATE TABLE `loan` (
  `id` int(11) NOT NULL,
  `acc_number` int(111) NOT NULL,
  `loan_name` varchar(255) NOT NULL,
  `repay_date` varchar(255) NOT NULL,
  `str_repay_date` int(200) NOT NULL,
  `loan_amount` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `deliquent_days` int(11) DEFAULT NULL,
  `reminded` int(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `loan`
--

INSERT INTO `loan` (`id`, `acc_number`, `loan_name`, `repay_date`, `str_repay_date`, `loan_amount`, `executed_by`, `trans_code`, `date`, `deliquent_days`, `reminded`) VALUES
(6, 9999, 'new loan', '2023-04-18', 1681768800, '100000', 43, 'LOAN477446165', 'Thursday 18 May 2023', -50, 4),
(7, 8888, 'onother one', '2023-05-16', 1684188000, '10000', 43, 'LOAN1735105520', 'Thursday 18 May 2023', -23, 2),
(8, 9999, 'Lury life style', '2023-06-04', 1685829600, '1000000', 42, 'LOAN464651683', 'Friday 19 May 2023', 16, NULL),
(9, 9999, 'Loan Now', '2023-05-31', 1685484000, '10000', 42, 'LOAN915725011', 'Friday 19 May 2023', -8, 1),
(10, 9999, 'ok naw', '2023-01-30', 1675033200, '100000', 42, 'LOAN1567288794', 'Friday 19 May 2023', -109, 1),
(11, 9999, 'Money man', '2023-01-31', 1675119600, '0', 42, 'LOAN246866416', 'Friday 19 May 2023', -108, 1),
(12, 9999, 'Money man ', '2023-01-22', 1674342000, '0', 42, 'LOAN1344618237', 'Friday 19 May 2023', -117, NULL),
(13, 8888, 'Stock the shop', '2023-05-20', 1684533600, '25000000', 42, 'LOAN1717535641', 'Friday 19 May 2023', 1, NULL),
(14, 8888, 'Stock shop for Dec', '2023-05-31', 1685484000, '10000000', 42, 'LOAN2145943687', 'Friday 19 May 2023', NULL, NULL);

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

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `id` int(11) NOT NULL,
  `content` varchar(500) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `is_group` int(11) NOT NULL,
  `is_contact` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `contact_id` int(11) NOT NULL,
  `is_sent` int(11) NOT NULL,
  `is_draft` int(11) NOT NULL,
  `is_bulk` int(11) NOT NULL,
  `date_sent` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `messages`
--

INSERT INTO `messages` (`id`, `content`, `subject`, `is_group`, `is_contact`, `group_id`, `contact_id`, `is_sent`, `is_draft`, `is_bulk`, `date_sent`) VALUES
(47, 'Hi man', 'Redirect not working ', 0, 1, 0, 1, 1, 0, 0, 'Monday 31 Oct 2022'),
(50, 'All is well now', 'User Logins', 0, 0, 0, 0, 1, 0, 1, 'Monday 31 Oct 2022'),
(51, 'Hi, greetings sir. This is Sama from Ohipopo Technologies. Please would want to find out if you are still interested in using our services so that we properly close October and enter November with a new itineraries. You can reply via: https://wa.me/message/4EES7TRFXDDPE1', 'Maflekumen University', 1, 0, 4, 0, 0, 1, 0, 'Monday 31 Oct 2022'),
(53, 'Lorem ipsum dolor sit amet consectetur adipisicing elit. Ex distinctio a consequatur error, dignissimos eligendi praesentium possimus expedita qui, assumenda blanditiis! Quod tempore repellendus ipsa odio ducimus earum dolorem sequi!', 'Redirect not working ', 0, 0, 0, 0, 1, 0, 653766939, 'Monday 31 Oct 2022'),
(54, 'ok boy', 'Main Testing', 0, 0, 0, 0, 1, 0, 653766939, 'Monday 31 Oct 2022'),
(61, 'Hey bi man. How are you doing today?', 'Hello Greetings', 0, 0, 0, 0, 1, 0, 653766939, 'Friday 04 Nov 2022'),
(62, 'Hey bi man. How are you doing today?', 'Hello Greetings', 0, 0, 0, 653766939, 0, 1, 0, 'Friday 04 Nov 2022'),
(64, 'Hello Main man, how are you doing today? Hope great.', 'Just for Testing ', 0, 0, 0, 0, 1, 0, 653766939, 'Friday 30 Dec 2022'),
(65, 'Hello, greeting Prince Enobi, this is Ohips-SMS marketing services. We will like to propose a great sms marketing campaigns to you. Please you get to us via https://wa.me/message/4EES7TRFXDDPE1', 'Marketing', 0, 0, 0, 0, 1, 0, 1, 'Friday 30 Dec 2022'),
(67, 'Hello, greetings Mac, this is Ohips-SMS marketing services. We will like to propose a great sms marketing campaigns with your brand name. Please you get to us via https://wa.me/message/4EES7TRFXDDPE1', 'Marketing', 0, 1, 0, 10, 1, 0, 0, 'Friday 30 Dec 2022'),
(68, 'Neo stoss, na me this... we fit do this for Uncle Oliva ei bank... how u see am', 'Showcase', 0, 1, 0, 12, 1, 0, 0, 'Friday 30 Dec 2022');

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

--
-- Table structure for table `payroll`
--

CREATE TABLE `payroll` (
  `id` int(11) NOT NULL,
  `acc_number` int(200) NOT NULL,
  `for_month` varchar(255) NOT NULL,
  `amount` int(200) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `done_date` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payroll`
--

INSERT INTO `payroll` (`id`, `acc_number`, `for_month`, `amount`, `trans_code`, `done_date`, `executed_by`) VALUES
(1, 9999, 'January', 10000, 'PR1120269748', 'Wednesday 17 May 2023', 43),
(2, 9999, 'January', 32040, 'PR2069317710', 'Friday 19 May 2023', 42),
(3, 9999, 'May', 200, 'PR2020904511', 'Friday 19 May 2023', 42),
(4, 9999, 'January', 80000, 'PR1841173482', 'Friday 19 May 2023', 42),
(5, 9999, 'December', 20000, 'PR4770059', 'Friday 19 May 2023', 42),
(6, 9999, 'April', 32040, 'PR1931108292', 'Friday 19 May 2023', 42),
(7, 8888, 'February', 10000000, 'PR1862716061', 'Friday 19 May 2023', 42),
(8, 9999, 'May', 80000000, 'PR1814989475', 'Friday 19 May 2023', 42),
(9, 9999, 'August', 1000000, 'PR265138209', 'Friday 19 May 2023', 42),
(10, 9999, 'January', 100000, 'PR731073833', 'Friday 19 May 2023', 42);

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

--
-- Table structure for table `pension`
--

CREATE TABLE `pension` (
  `id` int(11) NOT NULL,
  `acc_number` int(200) NOT NULL,
  `month` varchar(255) NOT NULL,
  `amount` int(200) NOT NULL,
  `trans_code` varchar(255) NOT NULL,
  `date` varchar(255) NOT NULL,
  `executed_by` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pension`
--

INSERT INTO `pension` (`id`, `acc_number`, `month`, `amount`, `trans_code`, `date`, `executed_by`) VALUES
(1, 9999, 'August', 10000, 'PR1569723357', 'Wednesday 17 May 2023', 43),
(2, 9999, 'May', 110000, 'PR864142844', 'Friday 19 May 2023', 42);

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

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `id` int(11) NOT NULL,
  `acc_number` int(200) DEFAULT NULL,
  `done_by` varchar(255) DEFAULT NULL,
  `loanID` int(11) DEFAULT NULL,
  `account_type` varchar(255) DEFAULT NULL,
  `charge_name` varchar(255) DEFAULT NULL,
  `done_date` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `amount` int(255) DEFAULT NULL,
  `is_debit` int(11) DEFAULT NULL,
  `is_credit` int(11) DEFAULT NULL,
  `executed_by` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `acc_number`, `done_by`, `loanID`, `account_type`, `charge_name`, `done_date`, `description`, `amount`, `is_debit`, `is_credit`, `executed_by`) VALUES
(92, 9999, NULL, 6, NULL, NULL, 'Saturday 20 May 2023', 'LRP912731594', 10000, 0, 1, 42),
(93, 9999, NULL, 8, NULL, NULL, 'Saturday 20 May 2023', 'LRP1163104135', 199000000, 0, 1, 42),
(94, 9999, NULL, 12, NULL, NULL, 'Saturday 20 May 2023', 'LRP736440787', 150000, 0, 1, 42),
(95, 9999, NULL, 11, NULL, NULL, 'Saturday 20 May 2023', 'LRP1679221891', 150000, 0, 1, 42),
(96, 8888, 'Sama', NULL, 'Deposits', NULL, 'Monday 22 May 2023', 'DEP1149707807', 12080, 0, 1, 42);

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `member_name` varchar(255) NOT NULL,
  `position` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `country` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `hobbies` varchar(255) NOT NULL,
  `id_no` varchar(255) NOT NULL,
  `start_date` varchar(255) NOT NULL,
  `code` varchar(20) NOT NULL,
  `phone` varchar(20) NOT NULL,
  `image` mediumblob NOT NULL,
  `employee_id` mediumblob DEFAULT NULL,
  `employee_application` varchar(255) DEFAULT NULL,
  `surety_name` varchar(255) NOT NULL,
  `surety_occupation` varchar(255) NOT NULL,
  `surety_phone` varchar(50) NOT NULL,
  `surety_id` varchar(255) NOT NULL,
  `surety_relationship` varchar(50) NOT NULL,
  `surety_address` varchar(50) NOT NULL,
  `surety_agreement` varchar(50) DEFAULT NULL,
  `username` varchar(100) NOT NULL,
  `password` varchar(255) NOT NULL,
  `other` varchar(255) DEFAULT NULL,
  `isUser` int(255) NOT NULL,
  `is_login` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `member_name`, `position`, `dob`, `country`, `gender`, `address`, `hobbies`, `id_no`, `start_date`, `code`, `phone`, `image`, `employee_id`, `employee_application`, `surety_name`, `surety_occupation`, `surety_phone`, `surety_id`, `surety_relationship`, `surety_address`, `surety_agreement`, `username`, `password`, `other`, `isUser`, `is_login`) VALUES
(42, 'Ohipopo Technologies', 'sms admin', '2019-07-15', 'Cameroon', 'Male', 'Mile 4 Limbe', 'Technology, IT', '1', '2022-11-01', '#U3357', '653766939', 0x393465306235353731313766663430663739616666643431353939623663306132633635623238332d61617373642e6a7067, '', '', 'Sama Yanick', 'Pastor', '653766939', '112219914', 'CEO', 'Limbe', '', 'sama0074', '4a7d1ed414474e4033ac29ccb8653d9b', '', 1, 0),
(43, 'Sama Yanick Ndasi', 'management', '2023-05-17', 'Cameroon', 'Male', 'Limbe\r\nMile 2', 'Praying, Singing, youtube, sleeping', '112219914', '2023-05-16', '#U3888', '653766939', 0x303030363930303465366335623432383539373663646239316232353231386164333235376566632d7465616d7a5f30312e6a7067, '', '', 'Sama Yvonne Neba', 'Business Woman', '671824509', '00022299111', 'Wife', 'Limbe', '', 'ceo', 'e10adc3949ba59abbe56e057f20f883e', '', 1, 0),
(44, 'Sam Yan Nda', 'management', '2023-05-20', 'Antigua and Barbuda', 'Male', 'SW Region, Ombe\r\nOmbe', 'ghkgh', 'srtrtrstrt', '2023-05-19', '#U6395', '653766939', 0x353139396132666334313635306631303063383337616234336637356263336461633165383132392d736473667364662e6a7067, '', '', 'Ayuk Hastings Ayuk', 'Pastor', '653766939', '1145000000000000000000', 'Spiritual Father', 'SW Region, Ombe', '', 'soweda', '4a7d1ed414474e4033ac29ccb8653d9b', '', 1, 0),
(46, 'Neba yvonnes', 'loans', '2023-06-10', 'Albania', 'Female', 'sokolo', 'covo', '332', '2023-06-08', '#U1855', '671824509', 0x373962363032336238363337643836323664636662616536383239313435613466323732613161332d494d475f303832332e6a7067, NULL, NULL, 'Sama Yanick Ndasi', 'IT', '653766939', 'ki', 'Husband', 'sokolo', NULL, 'sama', '4a7d1ed414474e4033ac29ccb8653d9b', NULL, 1, 0);

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

--
-- Table structure for table `u_sms`
--

CREATE TABLE `u_sms` (
  `id` int(11) NOT NULL,
  `to_user` int(11) NOT NULL,
  `from_user` int(11) NOT NULL,
  `content` varchar(255) NOT NULL,
  `today_date` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `u_sms`
--

INSERT INTO `u_sms` (`id`, `to_user`, `from_user`, `content`, `today_date`) VALUES
(4, 42, 43, 'Hello grand', 'Tuesday 16 May 2023'),
(5, 43, 43, 'Sama Congratulations', 'Wednesday 17 May 2023');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `a2a_transactions`
--
ALTER TABLE `a2a_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `bal_adjustmenst`
--
ALTER TABLE `bal_adjustmenst`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `emoluments`
--
ALTER TABLE `emoluments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `emolument_transactions`
--
ALTER TABLE `emolument_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `interbranch_transactions`
--
ALTER TABLE `interbranch_transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `loan`
--
ALTER TABLE `loan`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=69;

--
-- AUTO_INCREMENT for table `payroll`
--
ALTER TABLE `payroll`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `pension`
--
ALTER TABLE `pension`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=97;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

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

Name	Type	Size	Owner/Group	Permission	Last Modified	Actions
.	dir	-	mboniqkj/mboniqkj	0755	2024-08-01 07:28:13
..	dir	-	mboniqkj/nobody	0750	2026-02-27 08:52:37
Vcccul-sms (2).sql	text/plain	22.39 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:09:16
Vcccul-sms (3).sql	text/plain	22.39 KB	mboniqkj/mboniqkj	0644	2024-02-20 12:09:16
config.php	text/x-php	285 B	mboniqkj/mboniqkj	0644	2024-02-20 12:09:59
config2.php	text/x-php	390 B	mboniqkj/mboniqkj	0644	2024-02-20 12:10:22
sms_config.php	text/x-php	182 B	mboniqkj/mboniqkj	0644	2024-08-01 07:28:13

Team Anon Force

https://t.me/Professor6T9x