-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost:3306
-- Generation Time: Mar 26, 2016 at 03:19 PM
-- Server version: 5.5.45-cll-lve
-- PHP Version: 5.4.31

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `sftwrefc_money_transfer`
--

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

--
-- Table structure for table `cost`
--

CREATE TABLE IF NOT EXISTS `cost` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cost_name` varchar(8) COLLATE utf8_unicode_ci NOT NULL,
  `from_amount` double NOT NULL,
  `to_amount` double NOT NULL,
  `fee` double NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=35 ;

--
-- Dumping data for table `cost`
--

INSERT INTO `cost` (`id`, `cost_name`, `from_amount`, `to_amount`, `fee`) VALUES
(18, 'cost-1', 1, 25000, 250),
(19, 'cost-2', 25001, 50000, 450),
(20, 'cost-3', 50001, 75000, 600),
(21, 'cost-4', 75001, 100000, 800),
(22, 'cost-5', 100001, 125000, 1000),
(23, 'cost-6', 125001, 150000, 1200),
(24, 'cost-7', 150001, 200000, 1500),
(25, 'cost-8', 200001, 250000, 1800),
(26, 'cost-9', 250001, 300000, 2200),
(27, 'cost-10', 300001, 400000, 3000),
(28, 'cost-11', 400001, 500000, 4000),
(29, 'cost-12', 500001, 600000, 5000),
(30, 'cost-13', 600001, 700000, 6000),
(31, 'cost-14', 700001, 800000, 7000),
(32, 'cost-15', 800001, 900000, 8000),
(33, 'cost-16', 900001, 1000000, 8500),
(34, 'cost-17', 1000000, 99999999999, 8500);

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

--
-- Table structure for table `payment`
--

CREATE TABLE IF NOT EXISTS `payment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payment_type` enum('individual','organisation') COLLATE utf8_unicode_ci NOT NULL,
  `sending_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `date_of_sending` date NOT NULL,
  `sender_fullname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `shipping_city` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sender_phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payable_amount` double NOT NULL,
  `secret_question` text COLLATE utf8_unicode_ci,
  `secret_answer` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipent_fullname` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipent_passport` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passport_exp_date` date DEFAULT NULL,
  `payment_city` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Recipient_CNI` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Recipient_Phone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `Recipient_address` text COLLATE utf8_unicode_ci,
  `Distribution_Number` text COLLATE utf8_unicode_ci,
  `Name_of_project` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paying_date` date NOT NULL,
  `agent_id` int(11) NOT NULL,
  `trash` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
  `offline` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `sending_money`
--

CREATE TABLE IF NOT EXISTS `sending_money` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sending_type` enum('individual','organisation') COLLATE utf8_unicode_ci NOT NULL,
  `sending_code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `sending_date` date NOT NULL,
  `sender_fullname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `sender_city` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sender_passport` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `passport_exp_date` date DEFAULT NULL,
  `sending_amount` double NOT NULL,
  `cost` double NOT NULL,
  `total_amount` double NOT NULL,
  `telephone` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `secret_question` text COLLATE utf8_unicode_ci,
  `secret_answer` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipent_fullname` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `recipent_phone` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `recipent_city` varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
  `recipent_CNI` varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
  `org_address` text COLLATE utf8_unicode_ci,
  `distribution_number` text COLLATE utf8_unicode_ci,
  `name_of_project` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `agent_id` int(11) NOT NULL,
  `status` enum('sending','paid','cancle') COLLATE utf8_unicode_ci NOT NULL,
  `trash` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL,
  `offline` enum('yes','no') COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `sending_code` (`sending_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

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

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

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `settings` text COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=15 ;

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

INSERT INTO `settings` (`id`, `settings`, `value`) VALUES
(1, 'company_name', 'MFSEEIC'),
(2, 'company_email', 'demo@demo.com'),
(3, 'company_address', 'Nouakchott M3 = 147 FAAE Polyc.linique'),
(4, 'company_phone', '+8801254545151'),
(5, 'company_website', 'www.demo.com'),
(11, 'company_description', 'Women Mutual Solidarity Mutual Aid </br> Savings and Credit'),
(12, 'system_name', 'E-TRANSFER'),
(13, 'copyright', '<b>Copyright</b> © 2015 KennedyIT'),
(14, 'office_name', 'Bordereau d''Envoi AGENCE POLYCLINIQUE');

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

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

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `first_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
  `user_type` enum('admin','agent') COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL,
  `creation_date` date NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

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

INSERT INTO `users` (`id`, `first_name`, `last_name`, `username`, `email`, `password`, `user_type`, `status`, `creation_date`) VALUES
(1, 'kenedy', 'Rodrick', 'kennedy93', 'kennedyrodrick93@gmail.com', '827ccb0eea8a706c4c34a16891f84e7b', 'admin', 'active', '2016-02-23');

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