-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 25-Out-2022 às 17:04
-- Versão do servidor: 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: `epiz_31429424_credito`
--

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

--
-- Estrutura da tabela `aboutus`
--

DROP TABLE IF EXISTS `aboutus`;
CREATE TABLE IF NOT EXISTS `aboutus` (
  `abid` int(11) NOT NULL AUTO_INCREMENT,
  `about` text NOT NULL,
  PRIMARY KEY (`abid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `additional_fees`
--

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

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

--
-- Estrutura da tabela `attachment`
--

DROP TABLE IF EXISTS `attachment`;
CREATE TABLE IF NOT EXISTS `attachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `backup`
--

DROP TABLE IF EXISTS `backup`;
CREATE TABLE IF NOT EXISTS `backup` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `banner`
--

DROP TABLE IF EXISTS `banner`;
CREATE TABLE IF NOT EXISTS `banner` (
  `banaid` int(11) NOT NULL AUTO_INCREMENT,
  `bannar` text NOT NULL,
  PRIMARY KEY (`banaid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `banner`
--

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

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

--
-- Estrutura da tabela `battachment`
--

DROP TABLE IF EXISTS `battachment`;
CREATE TABLE IF NOT EXISTS `battachment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `battachment`
--

INSERT INTO `battachment` (`id`, `get_id`, `tid`, `attached_file`, `descricao`, `date_time`) VALUES
(2, '1', 'Loan=321196976', 'bdocument/7074_File_LogoOficial.pdf', 'gfdh', '2022-06-16 14:00:39'),
(3, '3', 'Loan=84370581', 'bdocument/1242_File_Seismograph-Tips.pdf', 'Contrato', '2022-07-10 14:54:37'),
(4, '3', 'Loan=84370581', 'bdocument/2565_File_Falcon-HR-Traffic-Safety-RADAR.pdf', 'Documentos pessoais', '2022-07-10 14:55:42');

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

--
-- Estrutura da tabela `borrowers`
--

DROP TABLE IF EXISTS `borrowers`;
CREATE TABLE IF NOT EXISTS `borrowers` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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, 'Sergio', 'Manuel', '2022-06-16', 'Masculino', 'Tete', 'Manuel', 'Solteiro/a', 'Tete', 'BI', '111111111111B', '343434343', '2022-06-16', '2022-06-16', 'Tete', 'manuel@gmail.com', '841234123', '', 'Tete', 'Tete', '2300', 'MZ', 'Empreendedores', '', '', '0134636177', '0.0', '', '2022-06-16 14:00:39', 'Completo'),
(2, 'Charles', 'Viagem', '2022-06-29', 'Masculino', 'Tete', 'Viagem', 'Solteiro/a', 'Tete', 'BI', '243435662424B', '763534352', '2022-06-29', '2022-06-29', 'Tete', 'charles.viagem@gmail.com', '874645554', '837474745', 'Tete', 'Tete', '2300', 'MZ', 'Empreendedores', 'Amsdgdgdg', 'jjshhss', '0133699377', '0.0', '', '2022-06-29 16:44:17', 'Pendente'),
(3, 'Rosario', 'Salvador', '2022-07-10', 'Masculino', 'Pemba', 'Salvador', 'Solteiro/a', 'Pemba', 'BI', '666666666666N', '666666666', '2022-07-10', '2022-07-10', 'Pemba', 'email@gmail.com', '8675433334', '', 'Pemba', 'Cabo Delgado', '3200', 'MZ', 'Empreendedores', '', 'sadfvvhgngngh', '0139470639', '0.0', '', '2022-07-10 14:54:37', 'Completo');

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

--
-- Estrutura da tabela `cadeia_valores`
--

DROP TABLE IF EXISTS `cadeia_valores`;
CREATE TABLE IF NOT EXISTS `cadeia_valores` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cadeia_valores` varchar(255) NOT NULL,
  `tipo_credito` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `tipo_credito` (`tipo_credito`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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);

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

--
-- Estrutura da tabela `city`
--

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

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

--
-- Estrutura da tabela `collateral`
--

DROP TABLE IF EXISTS `collateral`;
CREATE TABLE IF NOT EXISTS `collateral` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `countries`
--

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `alpha_2` varchar(200) NOT NULL DEFAULT '',
  `alpha_3` varchar(200) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=250 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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');

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

--
-- Estrutura da tabela `emp_permission`
--

DROP TABLE IF EXISTS `emp_permission`;
CREATE TABLE IF NOT EXISTS `emp_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=236 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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', 'Tipo de Credito', '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');

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

--
-- Estrutura da tabela `emp_role`
--

DROP TABLE IF EXISTS `emp_role`;
CREATE TABLE IF NOT EXISTS `emp_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `etemplates`
--

DROP TABLE IF EXISTS `etemplates`;
CREATE TABLE IF NOT EXISTS `etemplates` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `faqs`
--

DROP TABLE IF EXISTS `faqs`;
CREATE TABLE IF NOT EXISTS `faqs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topic` text NOT NULL,
  `content` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `faqs`
--

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

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

--
-- Estrutura da tabela `fin_info`
--

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

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

--
-- Estrutura da tabela `footer`
--

DROP TABLE IF EXISTS `footer`;
CREATE TABLE IF NOT EXISTS `footer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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', '');

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

--
-- Estrutura da tabela `hiw`
--

DROP TABLE IF EXISTS `hiw`;
CREATE TABLE IF NOT EXISTS `hiw` (
  `hid` int(11) NOT NULL AUTO_INCREMENT,
  `hiw` text NOT NULL,
  PRIMARY KEY (`hid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `hiw`
--

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

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

--
-- Estrutura da tabela `loan_info`
--

DROP TABLE IF EXISTS `loan_info`;
CREATE TABLE IF NOT EXISTS `loan_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `loan_info`
--

INSERT INTO `loan_info` (`id`, `borrower`, `baccount`, `credito`, `cadeia`, `desci`, `amount`, `juros`, `periodo`, `caucao`, `comparticipacao`, `date_release`, `agent`, `endereco`, `remarks`, `status`, `pay_date`, `amount_topay`, `amount_to_pay_invisible`, `contrato`, `tot_juros`, `tot_mes`, `teller`, `remark`, `upstatus`) VALUES
(1, '1', '0134636177', '1', 'Rede de Pesca', 'dhg', '15000.00', 5, 5, '0.00', '0.00', '06/27/2022', 'Mauro', 'ghkh', 'Sem comentarios', 'Approved', '2022-06-16', '15750.00', '15750.00', 'ugkhk', '750.00', '3150.00', 'Mauro', 'ghk', 'Pendente'),
(2, '1', '0134636177', '2', 'Tesoura', 'Emprestimo sobre Material de Costura', '5000.00', 20, 12, '0.00', '0.00', '06/28/2022', 'Milagre Lazaro Nicodemos', 'Cidade de Tete', 'Sem comentarios', 'Pendente', '2022-07-29', '4000.00', '6000.00', 'KFG456IO6', '1000.00', '500.00', 'Milagre Lazaro Nicodemos', 'rter', 'Pendente'),
(3, '2', '0133699377', '1', 'Barco', 'Emprestimo sobre Material de Pesca ', '5000.00', 20, 12, '0.00', '0.00', '06/29/2022', 'Milagre Lazaro Nicodemos', 'Tete', 'Sem comentarios', 'Approved', '2022-07-30', '4000.00', '6000.00', 'ABC2022', '1000.00', '500.00', 'Milagre Lazaro Nicodemos', 'a', 'Pendente'),
(4, '3', '0139470639', '3', 'Estante', 'Emprestimo sobre Mobiliarios', '5000.00', 20, 12, '0.00', '0.00', '07/10/2022', 'Milagre Lazaro Nicodemos', 'Pemba', 'Sem comentarios', 'Approved', '2022-09-20', '0.00', '6000.00', 'adjfhgh455', '1000.00', '500.00', 'Milagre Lazaro Nicodemos', '', 'Pendente');

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

--
-- Estrutura da tabela `message`
--

DROP TABLE IF EXISTS `message`;
CREATE TABLE IF NOT EXISTS `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `mywallet`
--

DROP TABLE IF EXISTS `mywallet`;
CREATE TABLE IF NOT EXISTS `mywallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `notify`
--

DROP TABLE IF EXISTS `notify`;
CREATE TABLE IF NOT EXISTS `notify` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `notify` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `notify`
--

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

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

--
-- Estrutura da tabela `payments`
--

DROP TABLE IF EXISTS `payments`;
CREATE TABLE IF NOT EXISTS `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `referencia` (`referencia`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `payments`
--

INSERT INTO `payments` (`id`, `tid`, `account`, `account_no`, `customer`, `descricao`, `loan`, `credito`, `cadeia`, `pay_date`, `amount_to_pay`, `referencia`, `conta`, `remarks`) VALUES
(1, 'Loan=84370581', '0', '0134636177', '1', '', '6000.00', 2, 'Tesoura', '2022-06-29', '2000.00', 'gyynhbgdvf', '477351510001', 'Pagamento 2'),
(2, 'Loan=84370581', '0', '0133699377', '2', '', '6000.00', 1, 'Barco', '2022-06-30', '2000.00', 'nshsggdfd', '477351510001', 'Pagamento da primeira parcela do emprestimo sobre material de pesca'),
(3, 'Loan=84370581', '0', '0139470639', '3', '', '6000.00', 3, 'Estante', '2022-07-10', '2000.00', 'bfdrgg564564455', '477351510001', 'Pagamento da primeira parcela do emprestimo sobre mobiliarios'),
(4, 'Loan=84370581', '0', '0139470639', '3', '', '4000.00', 3, 'Estante', '2022-07-24', '4000.00', 'gffffffcfj', '477351510001', 'Pagamento segunda parcela');

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

--
-- Estrutura da tabela `payment_schedule`
--

DROP TABLE IF EXISTS `payment_schedule`;
CREATE TABLE IF NOT EXISTS `payment_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `pay_schedule`
--

DROP TABLE IF EXISTS `pay_schedule`;
CREATE TABLE IF NOT EXISTS `pay_schedule` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `sms`
--

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

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

--
-- Estrutura da tabela `systemset`
--

DROP TABLE IF EXISTS `systemset`;
CREATE TABLE IF NOT EXISTS `systemset` (
  `sysid` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`sysid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `systemset`
--

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

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

--
-- Estrutura da tabela `tipo_credito`
--

DROP TABLE IF EXISTS `tipo_credito`;
CREATE TABLE IF NOT EXISTS `tipo_credito` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo_credito` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `tipo_credito`
--

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

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

--
-- Estrutura da tabela `transacoes`
--

DROP TABLE IF EXISTS `transacoes`;
CREATE TABLE IF NOT EXISTS `transacoes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `mutuario` 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `transacoes`
--

INSERT INTO `transacoes` (`id`, `mutuario`, `descricao`, `linha`, `referencia`, `debito`, `credito`, `saldo`, `data`) VALUES
(9, 1, 'dhg', 1, 'ugkhk', '15750.00', '0.00', '15750.00', '2022-06-16'),
(10, 1, 'Emprestimo sobre Material de Costura', 2, 'KFG456IO6', '6000.00', '0.00', '6000.00', '2022-06-29'),
(11, 1, 'Pagamento 2', 2, 'gyynhbgdvf', '0.00', '2000.00', '4000.00', '2022-06-29'),
(12, 2, 'Emprestimo sobre Material de Pesca ', 1, 'ABC2022', '6000.00', '0.00', '6000.00', '2022-06-30'),
(13, 2, 'Pagamento da primeira parcela do emprestimo sobre material de pesca', 1, 'nshsggdfd', '0.00', '2000.00', '4000.00', '2022-06-30'),
(14, 3, 'Emprestimo sobre Mobiliarios', 3, 'adjfhgh455', '6000.00', '0.00', '6000.00', '2022-07-20'),
(15, 3, 'Pagamento da primeira parcela do emprestimo sobre mobiliarios', 3, 'bfdrgg564564455', '0.00', '2000.00', '4000.00', '2022-07-10'),
(16, 3, 'Pagamento segunda parcela', 3, 'gffffffcfj', '0.00', '4000.00', '0.00', '2022-07-24');

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

--
-- Estrutura da tabela `twallet`
--

DROP TABLE IF EXISTS `twallet`;
CREATE TABLE IF NOT EXISTS `twallet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tid` varchar(200) NOT NULL,
  `Total` varchar(200) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Estrutura da tabela `user`
--

DROP TABLE IF EXISTS `user`;
CREATE TABLE IF NOT EXISTS `user` (
  `userid` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`userid`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Extraindo dados da tabela `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/Bios.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');

--
-- Constraints for dumped tables
--

--
-- Limitadores para a tabela `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 */;
