# ************************************************************
# Sequel Pro SQL dump
# Version 4135
#
# http://www.sequelpro.com/
# http://code.google.com/p/sequel-pro/
#
# Host: localhost (MySQL 5.5.38)
# Database: moneymatch
# Generation Time: 2016-11-27 09:19:27 +0000
# ************************************************************


/*!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 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


# Dump of table borrow_request
# ------------------------------------------------------------

DROP TABLE IF EXISTS `borrow_request`;

CREATE TABLE `borrow_request` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `Owner` bigint(20) unsigned NOT NULL,
  `Amount` decimal(20,2) NOT NULL,
  `Interest` decimal(20,2) NOT NULL,
  `Loantime` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ORIG_ID` int(10) DEFAULT NULL,
  `UPDATE_DT` datetime DEFAULT NULL,
  `amount_got` decimal(20,2) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `borrow_request` WRITE;
/*!40000 ALTER TABLE `borrow_request` DISABLE KEYS */;

INSERT INTO `borrow_request` (`id`, `Owner`, `Amount`, `Interest`, `Loantime`, `status`, `INSERT_DT`, `ORIG_ID`, `UPDATE_DT`, `amount_got`)
VALUES
	(42,19,300.00,3.00,30,0,'2016-11-27 09:38:05',42,NULL,NULL),
	(43,19,100.00,2.00,30,0,'2016-11-27 09:38:10',43,NULL,NULL);

/*!40000 ALTER TABLE `borrow_request` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table invoice
# ------------------------------------------------------------

DROP TABLE IF EXISTS `invoice`;

CREATE TABLE `invoice` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `investor_id` bigint(20) unsigned NOT NULL,
  `Amount` decimal(20,2) NOT NULL,
  `duedate` date NOT NULL,
  `iban` varchar(200) DEFAULT NULL,
  `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ORIG_ID` int(10) DEFAULT NULL,
  `UPDATE_DT` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table new_users
# ------------------------------------------------------------

DROP TABLE IF EXISTS `new_users`;

CREATE TABLE `new_users` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `email` varchar(200) NOT NULL,
  `phone` int(20) NOT NULL,
  `password` varchar(20) NOT NULL,
  `ssn` varchar(20) NOT NULL,
  `currency` tinyint(4) unsigned NOT NULL,
  `type_person` tinyint(4) unsigned NOT NULL,
  `ORIG_ID` int(10) DEFAULT NULL,
  `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DT` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `new_users` WRITE;
/*!40000 ALTER TABLE `new_users` DISABLE KEYS */;

INSERT INTO `new_users` (`id`, `name`, `email`, `phone`, `password`, `ssn`, `currency`, `type_person`, `ORIG_ID`, `INSERT_DT`, `UPDATE_DT`)
VALUES
	(19,'Masnad Nehith','masnadhossain@live.com',465391604,'123456','170993-323M',1,1,19,'2016-11-27 09:37:33',NULL),
	(20,'investor','investor@hotmail.com',466144569,'123456','170993-323M',1,2,20,'2016-11-27 09:38:34',NULL);

/*!40000 ALTER TABLE `new_users` ENABLE KEYS */;
UNLOCK TABLES;


# Dump of table payment_plan
# ------------------------------------------------------------

DROP TABLE IF EXISTS `payment_plan`;

CREATE TABLE `payment_plan` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `borrower_request_id` bigint(20) unsigned NOT NULL,
  `investor_id` bigint(20) unsigned NOT NULL,
  `Amount` decimal(20,2) NOT NULL,
  `duedate` date NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ORIG_ID` int(10) DEFAULT NULL,
  `UPDATE_DT` datetime DEFAULT NULL,
  `amount_paid_back` decimal(20,2) DEFAULT NULL,
  `borrower_id` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;



# Dump of table user_data
# ------------------------------------------------------------

DROP TABLE IF EXISTS `user_data`;

CREATE TABLE `user_data` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `Owner` bigint(20) unsigned NOT NULL,
  `job` varchar(200) NOT NULL,
  `salary` decimal(20,2) NOT NULL,
  `housing` varchar(200) NOT NULL,
  `validation` tinyint(4) NOT NULL DEFAULT '0',
  `iban` varchar(200) NOT NULL,
  `points` varchar(200) NOT NULL,
  `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `UPDATE_DT` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

LOCK TABLES `user_data` WRITE;
/*!40000 ALTER TABLE `user_data` DISABLE KEYS */;

INSERT INTO `user_data` (`id`, `Owner`, `job`, `salary`, `housing`, `validation`, `iban`, `points`, `INSERT_DT`, `UPDATE_DT`)
VALUES
	(20,19,'Hacker',4000.00,'Permanent',0,'FI897435893745','0','2016-11-27 09:37:52',NULL);

/*!40000 ALTER TABLE `user_data` ENABLE KEYS */;
UNLOCK TABLES;



/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!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 */;