-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Nov 03, 2023 at 06:53 AM
-- Server version: 10.1.13-MariaDB
-- PHP Version: 5.6.20

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

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

--
-- Table structure for table `aboutus`
--

CREATE TABLE `aboutus` (
  `abid` int(11) NOT NULL,
  `about` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `additional_fees`
--

CREATE TABLE `additional_fees` (
  `id` int(11) NOT NULL,
  `get_id` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `fee` varchar(200) NOT NULL,
  `Amount` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `attachment`
--

CREATE TABLE `attachment` (
  `id` int(11) NOT NULL,
  `get_id` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `attached_file` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `backup`
--

CREATE TABLE `backup` (
  `id` int(11) NOT NULL,
  `tracking_id` varchar(200) NOT NULL,
  `amount` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `balance`
--

CREATE TABLE `balance` (
  `id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `balance`
--

INSERT INTO `balance` (`id`, `amount`, `data`) VALUES
(1, '8000.00', '2023-10-29 11:11:19');

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

--
-- Table structure for table `banner`
--

CREATE TABLE `banner` (
  `banaid` int(11) NOT NULL,
  `bannar` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `banner`
--

INSERT INTO `banner` (`banaid`, `bannar`) VALUES
(3, 'bannar/sld2.jpg');

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

--
-- Table structure for table `battachment`
--

CREATE TABLE `battachment` (
  `id` int(11) NOT NULL,
  `get_id` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `attached_file` text NOT NULL,
  `descricao` varchar(500) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `battachment`
--

INSERT INTO `battachment` (`id`, `get_id`, `tid`, `attached_file`, `descricao`, `date_time`) VALUES
(1, '1', 'Loan=84370581', 'bdocument/4463_File_CamScanner 12-10-2023 15.09_032149.pdf', '', '2023-11-03 05:49:39');

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

--
-- Table structure for table `borrowers`
--

CREATE TABLE `borrowers` (
  `id` int(11) NOT NULL,
  `fname` varchar(200) NOT NULL,
  `lname` varchar(200) NOT NULL,
  `data_nascimento` varchar(255) NOT NULL,
  `sexo` varchar(15) NOT NULL,
  `naturalidade` varchar(50) NOT NULL,
  `filiacao` varchar(500) NOT NULL,
  `estado_civil` varchar(20) NOT NULL,
  `residencia` text NOT NULL,
  `documento` varchar(20) NOT NULL,
  `numero_documento` varchar(25) NOT NULL,
  `nuit` varchar(50) NOT NULL,
  `emissao` varchar(255) NOT NULL,
  `validade` varchar(255) NOT NULL,
  `localEmit` varchar(255) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `contacto_alternativo` varchar(12) NOT NULL,
  `distrito` varchar(255) NOT NULL,
  `state` varchar(200) NOT NULL,
  `zip` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `beneficiario` varchar(255) NOT NULL,
  `membros` varchar(500) NOT NULL,
  `comment` text NOT NULL,
  `account` varchar(200) NOT NULL,
  `balance` varchar(200) NOT NULL,
  `image` varchar(200) NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `borrowers`
--

INSERT INTO `borrowers` (`id`, `fname`, `lname`, `data_nascimento`, `sexo`, `naturalidade`, `filiacao`, `estado_civil`, `residencia`, `documento`, `numero_documento`, `nuit`, `emissao`, `validade`, `localEmit`, `email`, `phone`, `contacto_alternativo`, `distrito`, `state`, `zip`, `country`, `beneficiario`, `membros`, `comment`, `account`, `balance`, `image`, `date_time`, `status`) VALUES
(1, 'Ivone', 'Waite', '2023-11-02', 'Masculino', 'Tete', 'Ivone Albino Waite', 'Solteiro/a', 'Bairro CHingodzi', 'BI', '050102705028B', '1457894', '2023-11-02', '2023-11-09', 'Cidade de Tete', 'ivone@gmail.com', '852134342', '852134342', 'dg', 'Niassa', '3300', 'MZ', 'Empreendedores', 'dghghhg', 'dgdghggh', '0133200836', '0.0', '', '2023-11-03 05:49:39', 'Completo'),
(2, 'Ivone', 'Waite', '2023-11-02', 'Masculino', 'gdjhjjmhm', 'sdgfddf', 'Solteiro/a', 'fsgfdfg', 'BI', '344222ddddddd', '232444434', '2023-11-02', '2023-11-02', 'zcxdghdg', 'sdsssdsdds@gmail.com', '43232323', '423424434', 'afsfssf', 'Niassa', '3300', 'MZ', 'Empreendedores', 'sdfsd', 'dsfsdf', '0133956970', '0.0', '', '2023-11-03 05:49:09', 'Pendente');

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

--
-- Table structure for table `cadeia_valores`
--

CREATE TABLE `cadeia_valores` (
  `id` int(11) NOT NULL,
  `cadeia_valores` varchar(255) NOT NULL,
  `tipo_credito` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cadeia_valores`
--

INSERT INTO `cadeia_valores` (`id`, `cadeia_valores`, `tipo_credito`) VALUES
(1, 'Rede de Pesca', 1),
(2, 'Barco', 1),
(3, 'Motor para Barco', 1),
(4, 'Maquina de Costura', 2),
(5, 'Tecidos', 2),
(6, 'Tesoura', 2),
(7, 'Linha de Costura', 2),
(8, 'Estante', 3);

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

--
-- Table structure for table `city`
--

CREATE TABLE `city` (
  `idcity` int(11) NOT NULL,
  `citydesc` varchar(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `collateral`
--

CREATE TABLE `collateral` (
  `id` int(11) NOT NULL,
  `idm` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `type_of_collateral` varchar(200) NOT NULL,
  `model` varchar(200) NOT NULL,
  `make` varchar(200) NOT NULL,
  `serial_number` varchar(200) NOT NULL,
  `estimated_price` varchar(200) NOT NULL,
  `proof_of_ownership` text NOT NULL,
  `cimage` text NOT NULL,
  `observation` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `name` varchar(50) NOT NULL DEFAULT '',
  `alpha_2` varchar(200) NOT NULL DEFAULT '',
  `alpha_3` varchar(200) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `name`, `alpha_2`, `alpha_3`) VALUES
(1, 'Afghanistan', 'fl', 'afg'),
(2, 'Aland Islands', 'ax', 'ala'),
(3, 'Albania', 'al', 'alb'),
(4, 'Algeria', 'dz', 'dza'),
(5, 'American Samoa', 'as', 'asm'),
(6, 'Andorra', 'ad', 'and'),
(7, 'Angola', 'ao', 'ago'),
(8, 'Anguilla', 'ai', 'aia'),
(9, 'Antarctica', 'aq', 'ata'),
(10, 'Antigua and Barbuda', 'ag', 'atg'),
(11, 'Argentina', 'ar', 'arg'),
(12, 'Armenia', 'am', 'arm'),
(13, 'Aruba', 'aw', 'abw'),
(14, 'Australia', 'au', 'aus'),
(15, 'Austria', 'at', 'aut'),
(16, 'Azerbaijan', 'az', 'aze'),
(17, 'Bahamas', 'bs', 'bhs'),
(18, 'Bahrain', 'bh', 'bhr'),
(19, 'Bangladesh', 'bd', 'bgd'),
(20, 'Barbados', 'bb', 'brb'),
(21, 'Belarus', 'by', 'blr'),
(22, 'Belgium', 'be', 'bel'),
(23, 'Belize', 'bz', 'blz'),
(24, 'Benin', 'bj', 'ben'),
(25, 'Bermuda', 'bm', 'bmu'),
(26, 'Bhutan', 'bt', 'btn'),
(27, 'Bolivia, Plurinational State of', 'bo', 'bol'),
(28, 'Bonaire, Sint Eustatius and Saba', 'bq', 'bes'),
(29, 'Bosnia and Herzegovina', 'ba', 'bih'),
(30, 'Botswana', 'bw', 'bwa'),
(31, 'Bouvet Island', 'bv', 'bvt'),
(32, 'Brazil', 'br', 'bra'),
(33, 'British Indian Ocean Territory', 'io', 'iot'),
(34, 'Brunei Darussalam', 'bn', 'brn'),
(35, 'Bulgaria', 'bg', 'bgr'),
(36, 'Burkina Faso', 'bf', 'bfa'),
(37, 'Burundi', 'bi', 'bdi'),
(38, 'Cambodia', 'kh', 'khm'),
(39, 'Cameroon', 'cm', 'cmr'),
(40, 'Canada', 'ca', 'can'),
(41, 'Cape Verde', 'cv', 'cpv'),
(42, 'Cayman Islands', 'ky', 'cym'),
(43, 'Central African Republic', 'cf', 'caf'),
(44, 'Chad', 'td', 'tcd'),
(45, 'Chile', 'cl', 'chl'),
(46, 'China', 'cn', 'chn'),
(47, 'Christmas Island', 'cx', 'cxr'),
(48, 'Cocos (Keeling) Islands', 'cc', 'cck'),
(49, 'Colombia', 'co', 'col'),
(50, 'Comoros', 'km', 'com'),
(51, 'Congo', 'cg', 'cog'),
(52, 'Congo, The Democratic Republic of the', 'cd', 'cod'),
(53, 'Cook Islands', 'ck', 'cok'),
(54, 'Costa Rica', 'cr', 'cri'),
(55, 'Cote d''Ivoire', 'ci', 'civ'),
(56, 'Croatia', 'hr', 'hrv'),
(57, 'Cuba', 'cu', 'cub'),
(58, 'Curacao', 'cw', 'cuw'),
(59, 'Cyprus', 'cy', 'cyp'),
(60, 'Czech Republic', 'cz', 'cze'),
(61, 'Denmark', 'dk', 'dnk'),
(62, 'Djibouti', 'dj', 'dji'),
(63, 'Dominica', 'dm', 'dma'),
(64, 'Dominican Republic', 'do', 'dom'),
(65, 'Ecuador', 'ec', 'ecu'),
(66, 'Egypt', 'eg', 'egy'),
(67, 'El Salvador', 'sv', 'slv'),
(68, 'Equatorial Guinea', 'gq', 'gnq'),
(69, 'Eritrea', 'er', 'eri'),
(70, 'Estonia', 'ee', 'est'),
(71, 'Ethiopia', 'et', 'eth'),
(72, 'Falkland Islands (Malvinas)', 'fk', 'flk'),
(73, 'Faroe Islands', 'fo', 'fro'),
(74, 'Fiji', 'fj', 'fji'),
(75, 'Finland', 'fi', 'fin'),
(76, 'France', 'fr', 'fra'),
(77, 'French Guiana', 'gf', 'guf'),
(78, 'French Polynesia', 'pf', 'pyf'),
(79, 'French Southern Territories', 'tf', 'atf'),
(80, 'Gabon', 'ga', 'gab'),
(81, 'Gambia', 'gm', 'gmb'),
(82, 'Georgia', 'ge', 'geo'),
(83, 'Germany', 'de', 'deu'),
(84, 'Ghana', 'gh', 'gha'),
(85, 'Gibraltar', 'gi', 'gib'),
(86, 'Greece', 'gr', 'grc'),
(87, 'Greenland', 'gl', 'grl'),
(88, 'Grenada', 'gd', 'grd'),
(89, 'Guadeloupe', 'gp', 'glp'),
(90, 'Guam', 'gu', 'gum'),
(91, 'Guatemala', 'gt', 'gtm'),
(92, 'Guernsey', 'gg', 'ggy'),
(93, 'Guinea', 'gn', 'gin'),
(94, 'Guinea-Bissau', 'gw', 'gnb'),
(95, 'Guyana', 'gy', 'guy'),
(96, 'Haiti', 'ht', 'hti'),
(97, 'Heard Island and McDonald Islands', 'hm', 'hmd'),
(98, 'Holy See (Vatican City State)', 'va', 'vat'),
(99, 'Honduras', 'hn', 'hnd'),
(100, 'Hong Kong', 'hk', 'hkg'),
(101, 'Hungary', 'hu', 'hun'),
(102, 'Iceland', 'is', 'isl'),
(103, 'India', 'in', 'ind'),
(104, 'Indonesia', 'id', 'idn'),
(105, 'Iran, Islamic Republic of', 'ir', 'irn'),
(106, 'Iraq', 'iq', 'irq'),
(107, 'Ireland', 'ie', 'irl'),
(108, 'Isle of Man', 'im', 'imn'),
(109, 'Israel', 'il', 'isr'),
(110, 'Italy', 'it', 'ita'),
(111, 'Jamaica', 'jm', 'jam'),
(112, 'Japan', 'jp', 'jpn'),
(113, 'Jersey', 'je', 'jey'),
(114, 'Jordan', 'jo', 'jor'),
(115, 'Kazakhstan', 'kz', 'kaz'),
(116, 'Kenya', 'ke', 'ken'),
(117, 'Kiribati', 'ki', 'kir'),
(118, 'Korea, Democratic People''s Republic of', 'kp', 'prk'),
(119, 'Korea, Republic of', 'kr', 'kor'),
(120, 'Kuwait', 'kw', 'kwt'),
(121, 'Kyrgyzstan', 'kg', 'kgz'),
(122, 'Lao People''s Democratic Republic', 'la', 'lao'),
(123, 'Latvia', 'lv', 'lva'),
(124, 'Lebanon', 'lb', 'lbn'),
(125, 'Lesotho', 'ls', 'lso'),
(126, 'Liberia', 'lr', 'lbr'),
(127, 'Libyan Arab Jamahiriya', 'ly', 'lby'),
(128, 'Liechtenstein', 'li', 'lie'),
(129, 'Lithuania', 'lt', 'ltu'),
(130, 'Luxembourg', 'lu', 'lux'),
(131, 'Macao', 'mo', 'mac'),
(132, 'Macedonia, The former Yugoslav Republic of', 'mk', 'mkd'),
(133, 'Madagascar', 'mg', 'mdg'),
(134, 'Malawi', 'mw', 'mwi'),
(135, 'Malaysia', 'my', 'mys'),
(136, 'Maldives', 'mv', 'mdv'),
(137, 'Mali', 'ml', 'mli'),
(138, 'Malta', 'mt', 'mlt'),
(139, 'Marshall Islands', 'mh', 'mhl'),
(140, 'Martinique', 'mq', 'mtq'),
(141, 'Mauritania', 'mr', 'mrt'),
(142, 'Mauritius', 'mu', 'mus'),
(143, 'Mayotte', 'yt', 'myt'),
(144, 'Mexico', 'mx', 'mex'),
(145, 'Micronesia, Federated States of', 'fm', 'fsm'),
(146, 'Moldova, Republic of', 'md', 'mda'),
(147, 'Monaco', 'mc', 'mco'),
(148, 'Mongolia', 'mn', 'mng'),
(149, 'Montenegro', 'me', 'mne'),
(150, 'Montserrat', 'ms', 'msr'),
(151, 'Morocco', 'ma', 'mar'),
(152, 'Mozambique', 'mz', 'moz'),
(153, 'Myanmar', 'mm', 'mmr'),
(154, 'Namibia', 'na', 'nam'),
(155, 'Nauru', 'nr', 'nru'),
(156, 'Nepal', 'np', 'npl'),
(157, 'Netherlands', 'nl', 'nld'),
(158, 'New Caledonia', 'nc', 'ncl'),
(159, 'New Zealand', 'nz', 'nzl'),
(160, 'Nicaragua', 'ni', 'nic'),
(161, 'Niger', 'ne', 'ner'),
(162, 'Nigeria', 'ng', 'nga'),
(163, 'Niue', 'nu', 'niu'),
(164, 'Norfolk Island', 'nf', 'nfk'),
(165, 'Northern Mariana Islands', 'mp', 'mnp'),
(166, 'Norway', 'no', 'nor'),
(167, 'Oman', 'om', 'omn'),
(168, 'Pakistan', 'pk', 'pak'),
(169, 'Palau', 'pw', 'plw'),
(170, 'Palestinian Territory, Occupied', 'ps', 'pse'),
(171, 'Panama', 'pa', 'pan'),
(172, 'Papua New Guinea', 'pg', 'png'),
(173, 'Paraguay', 'py', 'pry'),
(174, 'Peru', 'pe', 'per'),
(175, 'Philippines', 'ph', 'phl'),
(176, 'Pitcairn', 'pn', 'pcn'),
(177, 'Poland', 'pl', 'pol'),
(178, 'Portugal', 'pt', 'prt'),
(179, 'Puerto Rico', 'pr', 'pri'),
(180, 'Qatar', 'qa', 'qat'),
(181, 'Reunion', 're', 'reu'),
(182, 'Romania', 'ro', 'rou'),
(183, 'Russian Federation', 'ru', 'rus'),
(184, 'Rwanda', 'rw', 'rwa'),
(185, 'Saint Barthelemy', 'bl', 'blm'),
(186, 'Saint Helena, Ascension and Tristan Da Cunha', 'sh', 'shn'),
(187, 'Saint Kitts and Nevis', 'kn', 'kna'),
(188, 'Saint Lucia', 'lc', 'lca'),
(189, 'Saint Martin (French Part)', 'mf', 'maf'),
(190, 'Saint Pierre and Miquelon', 'pm', 'spm'),
(191, 'Saint Vincent and The Grenadines', 'vc', 'vct'),
(192, 'Samoa', 'ws', 'wsm'),
(193, 'San Marino', 'sm', 'smr'),
(194, 'Sao Tome and Principe', 'st', 'stp'),
(195, 'Saudi Arabia', 'sa', 'sau'),
(196, 'Senegal', 'sn', 'sen'),
(197, 'Serbia', 'rs', 'srb'),
(198, 'Seychelles', 'sc', 'syc'),
(199, 'Sierra Leone', 'sl', 'sle'),
(200, 'Singapore', 'sg', 'sgp'),
(201, 'Sint Maarten (Dutch Part)', 'sx', 'sxm'),
(202, 'Slovakia', 'sk', 'svk'),
(203, 'Slovenia', 'si', 'svn'),
(204, 'Solomon Islands', 'sb', 'slb'),
(205, 'Somalia', 'so', 'som'),
(206, 'South Africa', 'za', 'zaf'),
(207, 'South Georgia and The South Sandwich Islands', 'gs', 'sgs'),
(208, 'South Sudan', 'ss', 'ssd'),
(209, 'Spain', 'es', 'esp'),
(210, 'Sri Lanka', 'lk', 'lka'),
(211, 'Sudan', 'sd', 'sdn'),
(212, 'Suriname', 'sr', 'sur'),
(213, 'Svalbard and Jan Mayen', 'sj', 'sjm'),
(214, 'Swaziland', 'sz', 'swz'),
(215, 'Sweden', 'se', 'swe'),
(216, 'Switzerland', 'ch', 'che'),
(217, 'Syrian Arab Republic', 'sy', 'syr'),
(218, 'Taiwan, Province of China', 'tw', 'twn'),
(219, 'Tajikistan', 'tj', 'tjk'),
(220, 'Tanzania, United Republic of', 'tz', 'tza'),
(221, 'Thailand', 'th', 'tha'),
(222, 'Timor-Leste', 'tl', 'tls'),
(223, 'Togo', 'tg', 'tgo'),
(224, 'Tokelau', 'tk', 'tkl'),
(225, 'Tonga', 'to', 'ton'),
(226, 'Trinidad and Tobago', 'tt', 'tto'),
(227, 'Tunisia', 'tn', 'tun'),
(228, 'Turkey', 'tr', 'tur'),
(229, 'Turkmenistan', 'tm', 'tkm'),
(230, 'Turks and Caicos Islands', 'tc', 'tca'),
(231, 'Tuvalu', 'tv', 'tuv'),
(232, 'Uganda', 'ug', 'uga'),
(233, 'Ukraine', 'ua', 'ukr'),
(234, 'United Arab Emirates', 'ae', 'are'),
(235, 'United Kingdom', 'gb', 'gbr'),
(236, 'United States', 'us', 'usa'),
(237, 'United States Minor Outlying Islands', 'um', 'umi'),
(238, 'Uruguay', 'uy', 'ury'),
(239, 'Uzbekistan', 'uz', 'uzb'),
(240, 'Vanuatu', 'vu', 'vut'),
(241, 'Venezuela, Bolivarian Republic of', 've', 'ven'),
(242, 'Viet Nam', 'vn', 'vnm'),
(243, 'Virgin Islands, British', 'vg', 'vgb'),
(244, 'Virgin Islands, U.S.', 'vi', 'vir'),
(245, 'Wallis and Futuna', 'wf', 'wlf'),
(246, 'Western Sahara', 'eh', 'esh'),
(247, 'Yemen', 'ye', 'yem'),
(248, 'Zambia', 'zm', 'zmb'),
(249, 'Zimbabwe', 'zw', 'zwe');

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

--
-- Table structure for table `emp_permission`
--

CREATE TABLE `emp_permission` (
  `id` int(11) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `module_name` varchar(350) NOT NULL,
  `pcreate` varchar(20) NOT NULL,
  `pread` varchar(20) NOT NULL,
  `pupdate` varchar(20) NOT NULL,
  `pdelete` varchar(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `emp_permission`
--

INSERT INTO `emp_permission` (`id`, `tid`, `module_name`, `pcreate`, `pread`, `pupdate`, `pdelete`) VALUES
(46, 'Loan=21319580', 'Mutuarios', '1', '1', '1', '1'),
(47, 'Loan=21319580', 'Poupanca', '1', '1', '1', '1'),
(48, 'Loan=21319580', 'Emprestimos', '1', '1', '1', '1'),
(50, 'Loan=21319580', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(51, 'Loan=21319580', 'Pagamentos', '1', '1', '1', '1'),
(52, 'Loan=21319580', 'Funcionarios', '1', '1', '1', '1'),
(53, 'Loan=21319580', 'Permissao por Modulos', '1', '1', '1', '1'),
(55, 'Loan=21319580', 'Configuracoes Gerais', '1', '1', '1', '0'),
(100, 'Loan=128426597', '', '0', '0', '0', '0'),
(101, 'Loan=128426597', 'Mutuarios', '1', '1', '1', '1'),
(102, 'Loan=128426597', 'Poupanca', '1', '1', '1', '1'),
(103, 'Loan=128426597', 'Emprestimos', '1', '1', '1', '1'),
(104, 'Loan=128426597', '', '0', '0', '0', '0'),
(105, 'Loan=128426597', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(106, 'Loan=128426597', 'Pagamentos', '1', '1', '1', '1'),
(107, 'Loan=128426597', 'Funcionarios', '1', '1', '1', '1'),
(108, 'Loan=128426597', 'Permissao por Modulos', '1', '1', '1', '1'),
(109, 'Loan=128426597', '', '0', '0', '0', '0'),
(110, 'Loan=128426597', 'Configuracoes Gerais', '1', '1', '1', '1'),
(111, 'Loan=231606358', 'Mutuarios', '0', '0', '0', '0'),
(112, 'Loan=231606358', 'Poupanca', '0', '0', '0', '0'),
(113, 'Loan=231606358', 'Emprestimos', '0', '0', '0', '0'),
(114, 'Loan=231606358', 'Pagamentos em Atraso', '0', '0', '0', '0'),
(115, 'Loan=231606358', 'Pagamentos', '0', '0', '0', '0'),
(116, 'Loan=231606358', 'Funcionarios', '1', '1', '1', '0'),
(117, 'Loan=231606358', 'Permissao por Modulos', '0', '0', '0', '0'),
(118, 'Loan=231606358', 'Configuracoes Gerais', '0', '0', '0', '0'),
(119, 'Loan=84370581', 'Mutuarios', '1', '1', '1', '1'),
(120, 'Loan=84370581', 'Poupanca', '1', '1', '1', '1'),
(121, 'Loan=84370581', 'Emprestimos', '1', '1', '1', '1'),
(122, 'Loan=84370581', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(123, 'Loan=84370581', 'Pagamentos', '1', '1', '1', '1'),
(124, 'Loan=84370581', 'Funcionarios', '1', '1', '1', '1'),
(125, 'Loan=84370581', 'Permissao por Modulos', '1', '1', '1', '1'),
(126, 'Loan=84370581', 'Relatorios', '1', '1', '1', '1'),
(127, 'Loan=84370581', 'Configuracoes Gerais', '1', '1', '1', '1'),
(128, 'Loan=242385772', 'Mutuarios', '1', '1', '1', '1'),
(129, 'Loan=242385772', 'Poupanca', '1', '1', '1', '1'),
(130, 'Loan=242385772', 'Emprestimos', '1', '1', '1', '1'),
(131, 'Loan=242385772', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(132, 'Loan=242385772', 'Pagamentos', '1', '1', '1', '1'),
(133, 'Loan=242385772', 'Funcionarios', '1', '1', '1', '1'),
(134, 'Loan=242385772', 'Permissao por Modulos', '1', '1', '1', '1'),
(135, 'Loan=242385772', 'Relatorios', '1', '1', '1', '1'),
(136, 'Loan=242385772', 'Configuracoes Gerais', '1', '1', '1', '1'),
(137, 'Loan=105391828', 'Mutuarios', '1', '1', '1', '1'),
(138, 'Loan=105391828', 'Poupanca', '1', '1', '0', '1'),
(139, 'Loan=105391828', 'Emprestimos', '1', '1', '1', '1'),
(140, 'Loan=105391828', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(141, 'Loan=105391828', 'Pagamentos', '1', '1', '1', '1'),
(142, 'Loan=105391828', 'Funcionarios', '1', '1', '1', '1'),
(143, 'Loan=105391828', 'Permissao por Modulos', '1', '1', '1', '1'),
(144, 'Loan=105391828', 'Relatorios', '1', '1', '1', '1'),
(145, 'Loan=105391828', 'Configuracoes Gerais', '1', '1', '1', '1'),
(146, 'Loan=16520628', 'Mutuarios', '1', '1', '1', '1'),
(147, 'Loan=16520628', 'Poupanca', '1', '1', '1', '1'),
(148, 'Loan=16520628', 'Emprestimos', '1', '1', '1', '1'),
(149, 'Loan=16520628', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(150, 'Loan=16520628', 'Pagamentos', '1', '1', '1', '1'),
(151, 'Loan=16520628', 'Funcionarios', '1', '1', '1', '1'),
(152, 'Loan=16520628', 'Permissao por Modulos', '1', '1', '1', '1'),
(153, 'Loan=16520628', 'Relatorios', '1', '1', '1', '1'),
(154, 'Loan=16520628', 'Configuracoes Gerais', '1', '1', '1', '1'),
(155, 'Loan=25033270', 'Mutuarios', '1', '1', '1', '1'),
(156, 'Loan=25033270', 'Poupanca', '1', '1', '1', '1'),
(157, 'Loan=25033270', 'Emprestimos', '1', '1', '1', '1'),
(158, 'Loan=25033270', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(159, 'Loan=25033270', 'Pagamentos', '1', '1', '1', '1'),
(160, 'Loan=25033270', 'Funcionarios', '1', '1', '1', '1'),
(161, 'Loan=25033270', 'Permissao por Modulos', '1', '1', '1', '1'),
(162, 'Loan=25033270', 'Relatorios', '1', '1', '1', '1'),
(163, 'Loan=25033270', 'Configuracoes Gerais', '1', '1', '1', '1'),
(164, 'Loan=242385772', 'Mutuarios', '1', '1', '1', '1'),
(165, 'Loan=242385772', 'Poupanca', '1', '1', '1', '1'),
(166, 'Loan=242385772', 'Emprestimos', '1', '1', '1', '1'),
(167, 'Loan=242385772', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(168, 'Loan=242385772', 'Pagamentos', '1', '1', '1', '1'),
(169, 'Loan=242385772', 'Funcionarios', '1', '1', '1', '1'),
(170, 'Loan=242385772', 'Permissao por Modulos', '1', '1', '1', '1'),
(171, 'Loan=242385772', 'Relatorios', '1', '1', '1', '1'),
(172, 'Loan=242385772', 'Configuracoes Gerais', '1', '1', '1', '1'),
(173, 'Loan=312829108', 'Mutuarios', '1', '1', '1', '1'),
(174, 'Loan=312829108', 'Poupanca', '1', '1', '1', '1'),
(175, 'Loan=312829108', 'Emprestimos', '1', '1', '1', '1'),
(176, 'Loan=312829108', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(177, 'Loan=312829108', 'Pagamentos', '1', '1', '1', '1'),
(178, 'Loan=312829108', 'Funcionarios', '1', '1', '1', '1'),
(179, 'Loan=312829108', 'Permissao por Modulos', '1', '1', '1', '1'),
(180, 'Loan=312829108', 'Relatorios', '1', '1', '1', '1'),
(181, 'Loan=312829108', 'Configuracoes Gerais', '1', '1', '1', '1'),
(182, 'Loan=242385772', 'Mutuarios', '1', '1', '1', '1'),
(183, 'Loan=242385772', 'Poupanca', '1', '1', '1', '1'),
(184, 'Loan=242385772', 'Emprestimos', '1', '1', '1', '1'),
(185, 'Loan=242385772', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(186, 'Loan=242385772', 'Pagamentos', '1', '1', '1', '1'),
(187, 'Loan=242385772', 'Funcionarios', '1', '1', '1', '1'),
(188, 'Loan=242385772', 'Permissao por Modulos', '1', '1', '1', '1'),
(189, 'Loan=242385772', 'Relatorios', '1', '1', '1', '1'),
(190, 'Loan=242385772', 'Configuracoes Gerais', '1', '1', '1', '1'),
(191, 'Loan=97783784', 'Mutuarios', '1', '1', '1', '1'),
(192, 'Loan=97783784', 'Poupanca', '1', '1', '1', '1'),
(193, 'Loan=97783784', 'Emprestimos', '1', '1', '1', '1'),
(194, 'Loan=97783784', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(195, 'Loan=97783784', 'Pagamentos', '1', '1', '1', '1'),
(196, 'Loan=97783784', 'Funcionarios', '1', '1', '1', '1'),
(197, 'Loan=97783784', 'Permissao por Modulos', '1', '1', '1', '1'),
(198, 'Loan=97783784', 'Relatorios', '1', '1', '1', '1'),
(199, 'Loan=97783784', 'Configuracoes Gerais', '1', '1', '1', '1'),
(200, 'Loan=330208384', 'Mutuarios', '1', '1', '1', '1'),
(201, 'Loan=330208384', 'Poupanca', '1', '1', '1', '1'),
(202, 'Loan=330208384', 'Emprestimos', '1', '1', '1', '1'),
(203, 'Loan=330208384', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(204, 'Loan=330208384', 'Pagamentos', '1', '1', '1', '1'),
(205, 'Loan=330208384', 'Funcionarios', '1', '1', '1', '1'),
(206, 'Loan=330208384', 'Permissao por Modulos', '1', '1', '1', '1'),
(207, 'Loan=330208384', 'Relatorios', '1', '1', '1', '1'),
(208, 'Loan=330208384', 'Configuracoes Gerais', '1', '1', '1', '1'),
(209, 'Loan=321196976', 'Mutuarios', '1', '1', '1', '0'),
(210, 'Loan=321196976', 'Poupanca', '1', '1', '1', '0'),
(211, 'Loan=321196976', 'Emprestimos', '1', '1', '1', '0'),
(212, 'Loan=321196976', 'Pagamentos em Atraso', '1', '1', '1', '0'),
(213, 'Loan=321196976', 'Pagamentos', '1', '1', '0', '0'),
(214, 'Loan=321196976', 'Funcionarios', '0', '0', '0', '0'),
(215, 'Loan=321196976', 'Permissao por Modulos', '0', '0', '0', '0'),
(216, 'Loan=321196976', 'Relatorios', '1', '1', '0', '0'),
(217, 'Loan=321196976', 'Configuracoes Gerais', '0', '0', '0', '0'),
(218, 'Loan=321196976', 'Mutuarios', '1', '1', '1', '1'),
(219, 'Loan=321196976', 'Poupanca', '1', '1', '1', '1'),
(220, 'Loan=321196976', 'Emprestimos', '1', '1', '1', '1'),
(221, 'Loan=321196976', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(222, 'Loan=321196976', 'Pagamentos', '1', '1', '1', '1'),
(223, 'Loan=321196976', 'Funcionarios', '1', '1', '1', '1'),
(224, 'Loan=321196976', 'Permissao por Modulos', '1', '1', '1', '1'),
(225, 'Loan=321196976', 'Relatorios', '1', '1', '1', '1'),
(226, 'Loan=321196976', 'Configuracoes Gerais', '1', '1', '1', '1'),
(227, 'Loan=339003282', 'Mutuarios', '1', '1', '1', '1'),
(228, 'Loan=339003282', 'Poupanca', '1', '1', '1', '1'),
(229, 'Loan=339003282', 'Emprestimos', '1', '1', '1', '1'),
(230, 'Loan=339003282', 'Pagamentos em Atraso', '1', '1', '1', '1'),
(231, 'Loan=339003282', 'Pagamentos', '1', '1', '1', '1'),
(232, 'Loan=339003282', 'Funcionarios', '1', '1', '1', '1'),
(233, 'Loan=339003282', 'Permissao por Modulos', '1', '1', '1', '1'),
(234, 'Loan=339003282', 'Relatorios', '1', '1', '1', '1'),
(235, 'Loan=339003282', 'Configuracoes Gerais', '1', '1', '1', '1');

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

--
-- Table structure for table `emp_role`
--

CREATE TABLE `emp_role` (
  `id` int(11) NOT NULL,
  `role` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `etemplates`
--

CREATE TABLE `etemplates` (
  `id` int(11) NOT NULL,
  `sender` varchar(200) NOT NULL,
  `receiver_email` varchar(350) NOT NULL,
  `subject` varchar(350) NOT NULL,
  `msg` text NOT NULL,
  `time_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int(11) NOT NULL,
  `topic` text NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` (`id`, `topic`, `content`) VALUES
(1, 'Please type the subject here', '<p>Please Update Faqs Here</p>\r\n');

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

--
-- Table structure for table `fin_info`
--

CREATE TABLE `fin_info` (
  `id` int(11) NOT NULL,
  `get_id` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `occupation` text NOT NULL,
  `mincome` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `footer`
--

CREATE TABLE `footer` (
  `id` int(11) NOT NULL,
  `email` varchar(200) NOT NULL,
  `pho` varchar(200) NOT NULL,
  `face` varchar(200) NOT NULL,
  `webs` varchar(200) NOT NULL,
  `conh` varchar(200) NOT NULL,
  `twi` varchar(200) NOT NULL,
  `gplus` varchar(200) NOT NULL,
  `ins` varchar(200) NOT NULL,
  `yous` varchar(200) NOT NULL,
  `about` text NOT NULL,
  `apply` text NOT NULL,
  `mission` text NOT NULL,
  `objective` text NOT NULL,
  `map` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `footer`
--

INSERT INTO `footer` (`id`, `email`, `pho`, `face`, `webs`, `conh`, `twi`, `gplus`, `ins`, `yous`, `about`, `apply`, `mission`, `objective`, `map`) VALUES
(2, 'info@bequesters.com', '+233808883675466', 'www.facebook.com/info@bequesters', 'www.bequesters.com', 'Lasvegas USA', 'www.twitter.com/info@bequesters', 'www.googleplus.com/oinfo@bequesters', 'www.in.com/info@bequesters', 'www.youtube.com/info@bequesters', 'About the system here. Thanks, We are just testing the software and we discover that the software is errors free. Thanks once again.', 'Who may apply here. Thabnks', 'Mission here. Thanks', 'System OBJECTIVE HERE. Thanks', '');

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

--
-- Table structure for table `hiw`
--

CREATE TABLE `hiw` (
  `hid` int(11) NOT NULL,
  `hiw` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `hiw`
--

INSERT INTO `hiw` (`hid`, `hiw`) VALUES
(1, '<p>We Provide Loans For Individual, Coperate and Many</p>\r\n');

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

--
-- Table structure for table `loan_info`
--

CREATE TABLE `loan_info` (
  `id` int(11) NOT NULL,
  `borrower` varchar(200) NOT NULL,
  `baccount` varchar(200) NOT NULL,
  `credito` varchar(255) NOT NULL,
  `cadeia` varchar(255) NOT NULL,
  `desci` varchar(1500) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `juros` int(11) NOT NULL,
  `periodo` int(11) NOT NULL,
  `caucao` decimal(10,2) NOT NULL,
  `comparticipacao` decimal(10,2) NOT NULL,
  `date_release` varchar(200) NOT NULL,
  `agent` varchar(200) NOT NULL,
  `endereco` varchar(255) NOT NULL,
  `remarks` varchar(1500) NOT NULL DEFAULT 'Sem comentarios',
  `status` varchar(255) NOT NULL,
  `pay_date` varchar(200) NOT NULL,
  `amount_topay` decimal(10,2) NOT NULL,
  `amount_to_pay_invisible` decimal(10,2) NOT NULL,
  `contrato` varchar(200) NOT NULL,
  `tot_juros` decimal(10,2) NOT NULL,
  `tot_mes` decimal(10,2) NOT NULL,
  `teller` varchar(200) NOT NULL,
  `remark` varchar(1500) NOT NULL DEFAULT 'Sem comentarios',
  `upstatus` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `message`
--

CREATE TABLE `message` (
  `id` int(11) NOT NULL,
  `sender_id` varchar(200) NOT NULL,
  `sender_name` varchar(200) NOT NULL,
  `msg_to` varchar(200) NOT NULL,
  `subject` varchar(300) NOT NULL,
  `message` text NOT NULL,
  `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `mywallet`
--

CREATE TABLE `mywallet` (
  `id` int(11) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `t_to` varchar(200) NOT NULL,
  `Amount` varchar(200) NOT NULL,
  `Desc` varchar(200) NOT NULL,
  `wtype` varchar(200) NOT NULL,
  `tdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `notify`
--

CREATE TABLE `notify` (
  `id` int(11) NOT NULL,
  `notify` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `notify`
--

INSERT INTO `notify` (`id`, `notify`) VALUES
(1, 0);

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` int(11) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `account` varchar(200) NOT NULL DEFAULT '0',
  `account_no` varchar(200) NOT NULL,
  `customer` varchar(200) NOT NULL,
  `descricao` varchar(1000) NOT NULL,
  `loan` decimal(10,2) NOT NULL,
  `credito` int(11) NOT NULL,
  `cadeia` varchar(255) NOT NULL,
  `pay_date` varchar(200) NOT NULL,
  `amount_to_pay` decimal(10,2) NOT NULL,
  `referencia` varchar(255) NOT NULL,
  `conta` varchar(255) NOT NULL,
  `remarks` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `payment_schedule`
--

CREATE TABLE `payment_schedule` (
  `id` int(11) NOT NULL,
  `idm` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `term` varchar(200) NOT NULL,
  `day` varchar(200) NOT NULL,
  `schedule` varchar(200) NOT NULL,
  `interest` varchar(200) NOT NULL,
  `penalty` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pay_schedule`
--

CREATE TABLE `pay_schedule` (
  `id` int(11) NOT NULL,
  `get_id` varchar(200) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `schedule` varchar(200) NOT NULL,
  `balance` varchar(200) NOT NULL,
  `interest` varchar(200) NOT NULL,
  `payment` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `savings` (
  `id` int(11) NOT NULL,
  `id_borrowers` int(11) NOT NULL,
  `account` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `remarks` text NOT NULL,
  `user` varchar(255) NOT NULL,
  `data` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `savings`
--

INSERT INTO `savings` (`id`, `id_borrowers`, `account`, `amount`, `remarks`, `user`, `data`) VALUES
(3, 1, 133200836, '2000.00', 'fgdghg', 'Milagre Lazaro Nicodemos', '2023-11-02 17:26:34'),
(4, 1, 133200836, '6000.00', 'drturd', 'Milagre Lazaro Nicodemos', '2023-11-03 04:40:32');

--
-- Triggers `savings`
--
DELIMITER $$
CREATE TRIGGER `apagou` AFTER DELETE ON `savings` FOR EACH ROW UPDATE balance SET amount = amount - OLD.amount
$$
DELIMITER ;

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

--
-- Table structure for table `sms`
--

CREATE TABLE `sms` (
  `id` int(11) NOT NULL,
  `sms_gateway` text NOT NULL,
  `username` text NOT NULL,
  `password` text NOT NULL,
  `api` text NOT NULL,
  `status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `systemset`
--

CREATE TABLE `systemset` (
  `sysid` int(11) NOT NULL,
  `title` varchar(200) NOT NULL,
  `name` varchar(200) NOT NULL,
  `footer` text NOT NULL,
  `abb` varchar(200) NOT NULL,
  `fax` text NOT NULL,
  `currency` text NOT NULL,
  `website` text NOT NULL,
  `mobile` text NOT NULL,
  `image` varchar(200) NOT NULL,
  `address` text NOT NULL,
  `email` text NOT NULL,
  `map` text NOT NULL,
  `stamp` varchar(350) NOT NULL,
  `timezone` text NOT NULL,
  `sms_charges` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `systemset`
--

INSERT INTO `systemset` (`sysid`, `title`, `name`, `footer`, `abb`, `fax`, `currency`, `website`, `mobile`, `image`, `address`, `email`, `map`, `stamp`, `timezone`, `sms_charges`) VALUES
(2, 'ASCA - Associacao de Credito e Poupanca', 'ASCA', 'Todos os direitos reservados. 2021 (c)', 'SBD', '23459', 'Mtn ', 'http://iprojects.epizy.com/gestao_de_emprestimos/', '456384', '../img/lg.png', 'Cidade de Tete', 'teste@gmail.com', 'Map Code Here ', 'stamp.jpg', '2', '25');

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

--
-- Table structure for table `tipo_credito`
--

CREATE TABLE `tipo_credito` (
  `id` int(11) NOT NULL,
  `tipo_credito` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `tipo_credito`
--

INSERT INTO `tipo_credito` (`id`, `tipo_credito`) VALUES
(1, 'Material de Pesca'),
(2, 'Material de Costura'),
(3, 'Mobiliarios');

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

--
-- Table structure for table `transacoes`
--

CREATE TABLE `transacoes` (
  `id` int(11) NOT NULL,
  `mutuario` int(11) NOT NULL,
  `emprestimo` int(11) NOT NULL,
  `descricao` varchar(255) NOT NULL,
  `linha` int(11) NOT NULL,
  `referencia` varchar(255) NOT NULL,
  `debito` decimal(10,2) DEFAULT '0.00',
  `credito` decimal(10,2) NOT NULL DEFAULT '0.00',
  `saldo` decimal(10,2) NOT NULL DEFAULT '0.00',
  `data` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `twallet`
--

CREATE TABLE `twallet` (
  `id` int(11) NOT NULL,
  `tid` varchar(200) NOT NULL,
  `Total` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `user` (
  `userid` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` varchar(200) NOT NULL,
  `addr1` text NOT NULL,
  `addr2` text NOT NULL,
  `city` varchar(200) NOT NULL,
  `state` varchar(200) NOT NULL,
  `country` varchar(200) NOT NULL,
  `comment` varchar(200) NOT NULL,
  `username` varchar(200) NOT NULL,
  `password` text NOT NULL,
  `id` varchar(200) NOT NULL,
  `image` text NOT NULL,
  `role` varchar(200) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `user` (`userid`, `name`, `email`, `phone`, `addr1`, `addr2`, `city`, `state`, `country`, `comment`, `username`, `password`, `id`, `image`, `role`) VALUES
(1, 'Milagre Lazaro Nicodemos', 'milagrelazaro1@gmail.com', '84848482', 'Cidade de Tete', '', 'Tete', 'Tete', 'MZ', '', 'admin', '878884862', 'Loan=84370581', 'img/lg.png', 'admin'),
(2, 'Mauro', 'mauro@gmail.com', '844235312', 'Bairro Chingodzi', '', 'Tete', 'Tete', 'MZ', '', 'mauro', '844235312', 'Loan=321196976', 'img/input-onlinepngtools.png', 'admin'),
(3, 'Charles Viagem', 'charles.viagem@gmail.com', '848484848', 'Tete', 'Tete', 'Tete', 'Tete', 'MZ', '', 'charles', '844762274', 'Loan=339003282', 'img/', 'admin');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `aboutus`
--
ALTER TABLE `aboutus`
  ADD PRIMARY KEY (`abid`);

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

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

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

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

--
-- Indexes for table `banner`
--
ALTER TABLE `banner`
  ADD PRIMARY KEY (`banaid`);

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

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

--
-- Indexes for table `cadeia_valores`
--
ALTER TABLE `cadeia_valores`
  ADD PRIMARY KEY (`id`),
  ADD KEY `tipo_credito` (`tipo_credito`);

--
-- Indexes for table `city`
--
ALTER TABLE `city`
  ADD PRIMARY KEY (`idcity`);

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

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

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

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

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

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

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

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

--
-- Indexes for table `hiw`
--
ALTER TABLE `hiw`
  ADD PRIMARY KEY (`hid`);

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

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

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

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

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `referencia` (`referencia`);

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

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

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

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

--
-- Indexes for table `systemset`
--
ALTER TABLE `systemset`
  ADD PRIMARY KEY (`sysid`);

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

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

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

--
-- Indexes for table `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`userid`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `aboutus`
--
ALTER TABLE `aboutus`
  MODIFY `abid` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `additional_fees`
--
ALTER TABLE `additional_fees`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `attachment`
--
ALTER TABLE `attachment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `backup`
--
ALTER TABLE `backup`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `balance`
--
ALTER TABLE `balance`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `banner`
--
ALTER TABLE `banner`
  MODIFY `banaid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `battachment`
--
ALTER TABLE `battachment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `borrowers`
--
ALTER TABLE `borrowers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `cadeia_valores`
--
ALTER TABLE `cadeia_valores`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `collateral`
--
ALTER TABLE `collateral`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=250;
--
-- AUTO_INCREMENT for table `emp_permission`
--
ALTER TABLE `emp_permission`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=236;
--
-- AUTO_INCREMENT for table `emp_role`
--
ALTER TABLE `emp_role`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `etemplates`
--
ALTER TABLE `etemplates`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `fin_info`
--
ALTER TABLE `fin_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `footer`
--
ALTER TABLE `footer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `hiw`
--
ALTER TABLE `hiw`
  MODIFY `hid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `loan_info`
--
ALTER TABLE `loan_info`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `message`
--
ALTER TABLE `message`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `mywallet`
--
ALTER TABLE `mywallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `notify`
--
ALTER TABLE `notify`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payment_schedule`
--
ALTER TABLE `payment_schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `pay_schedule`
--
ALTER TABLE `pay_schedule`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `savings`
--
ALTER TABLE `savings`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `sms`
--
ALTER TABLE `sms`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `systemset`
--
ALTER TABLE `systemset`
  MODIFY `sysid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `tipo_credito`
--
ALTER TABLE `tipo_credito`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT for table `transacoes`
--
ALTER TABLE `transacoes`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `twallet`
--
ALTER TABLE `twallet`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `user`
--
ALTER TABLE `user`
  MODIFY `userid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `cadeia_valores`
--
ALTER TABLE `cadeia_valores`
  ADD CONSTRAINT `cadeia_valores_ibfk_1` FOREIGN KEY (`tipo_credito`) REFERENCES `tipo_credito` (`id`);

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