SHARE
TWEET

Untitled

a guest Nov 27th, 2016 108 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # ************************************************************
  2. # Sequel Pro SQL dump
  3. # Version 4135
  4. #
  5. # http://www.sequelpro.com/
  6. # http://code.google.com/p/sequel-pro/
  7. #
  8. # Host: localhost (MySQL 5.5.38)
  9. # Database: moneymatch
  10. # Generation Time: 2016-11-27 09:19:27 +0000
  11. # ************************************************************
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  19. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  20. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  21.  
  22.  
  23. # Dump of table borrow_request
  24. # ------------------------------------------------------------
  25.  
  26. DROP TABLE IF EXISTS `borrow_request`;
  27.  
  28. CREATE TABLE `borrow_request` (
  29.   `id` int(10) NOT NULL AUTO_INCREMENT,
  30.   `Owner` bigint(20) unsigned NOT NULL,
  31.   `Amount` decimal(20,2) NOT NULL,
  32.   `Interest` decimal(20,2) NOT NULL,
  33.   `Loantime` int(11) NOT NULL,
  34.   `status` tinyint(4) NOT NULL DEFAULT '0',
  35.   `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  36.   `ORIG_ID` int(10) DEFAULT NULL,
  37.   `UPDATE_DT` datetime DEFAULT NULL,
  38.   `amount_got` decimal(20,2) DEFAULT NULL,
  39.   PRIMARY KEY (`id`)
  40. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  41.  
  42. LOCK TABLES `borrow_request` WRITE;
  43. /*!40000 ALTER TABLE `borrow_request` DISABLE KEYS */;
  44.  
  45. INSERT INTO `borrow_request` (`id`, `Owner`, `Amount`, `Interest`, `Loantime`, `status`, `INSERT_DT`, `ORIG_ID`, `UPDATE_DT`, `amount_got`)
  46. VALUES
  47.     (42,19,300.00,3.00,30,0,'2016-11-27 09:38:05',42,NULL,NULL),
  48.     (43,19,100.00,2.00,30,0,'2016-11-27 09:38:10',43,NULL,NULL);
  49.  
  50. /*!40000 ALTER TABLE `borrow_request` ENABLE KEYS */;
  51. UNLOCK TABLES;
  52.  
  53.  
  54. # Dump of table invoice
  55. # ------------------------------------------------------------
  56.  
  57. DROP TABLE IF EXISTS `invoice`;
  58.  
  59. CREATE TABLE `invoice` (
  60.   `id` int(10) NOT NULL AUTO_INCREMENT,
  61.   `investor_id` bigint(20) unsigned NOT NULL,
  62.   `Amount` decimal(20,2) NOT NULL,
  63.   `duedate` date NOT NULL,
  64.   `iban` varchar(200) DEFAULT NULL,
  65.   `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  66.   `ORIG_ID` int(10) DEFAULT NULL,
  67.   `UPDATE_DT` datetime DEFAULT NULL,
  68.   PRIMARY KEY (`id`)
  69. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  70.  
  71.  
  72.  
  73. # Dump of table new_users
  74. # ------------------------------------------------------------
  75.  
  76. DROP TABLE IF EXISTS `new_users`;
  77.  
  78. CREATE TABLE `new_users` (
  79.   `id` int(10) NOT NULL AUTO_INCREMENT,
  80.   `name` varchar(200) NOT NULL,
  81.   `email` varchar(200) NOT NULL,
  82.   `phone` int(20) NOT NULL,
  83.   `password` varchar(20) NOT NULL,
  84.   `ssn` varchar(20) NOT NULL,
  85.   `currency` tinyint(4) unsigned NOT NULL,
  86.   `type_person` tinyint(4) unsigned NOT NULL,
  87.   `ORIG_ID` int(10) DEFAULT NULL,
  88.   `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  89.   `UPDATE_DT` datetime DEFAULT NULL,
  90.   PRIMARY KEY (`id`)
  91. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  92.  
  93. LOCK TABLES `new_users` WRITE;
  94. /*!40000 ALTER TABLE `new_users` DISABLE KEYS */;
  95.  
  96. INSERT INTO `new_users` (`id`, `name`, `email`, `phone`, `password`, `ssn`, `currency`, `type_person`, `ORIG_ID`, `INSERT_DT`, `UPDATE_DT`)
  97. VALUES
  98.     (19,'Masnad Nehith','masnadhossain@live.com',465391604,'123456','170993-323M',1,1,19,'2016-11-27 09:37:33',NULL),
  99.     (20,'investor','investor@hotmail.com',466144569,'123456','170993-323M',1,2,20,'2016-11-27 09:38:34',NULL);
  100.  
  101. /*!40000 ALTER TABLE `new_users` ENABLE KEYS */;
  102. UNLOCK TABLES;
  103.  
  104.  
  105. # Dump of table payment_plan
  106. # ------------------------------------------------------------
  107.  
  108. DROP TABLE IF EXISTS `payment_plan`;
  109.  
  110. CREATE TABLE `payment_plan` (
  111.   `id` int(10) NOT NULL AUTO_INCREMENT,
  112.   `borrower_request_id` bigint(20) unsigned NOT NULL,
  113.   `investor_id` bigint(20) unsigned NOT NULL,
  114.   `Amount` decimal(20,2) NOT NULL,
  115.   `duedate` date NOT NULL,
  116.   `status` tinyint(4) NOT NULL DEFAULT '0',
  117.   `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  118.   `ORIG_ID` int(10) DEFAULT NULL,
  119.   `UPDATE_DT` datetime DEFAULT NULL,
  120.   `amount_paid_back` decimal(20,2) DEFAULT NULL,
  121.   `borrower_id` bigint(20) DEFAULT NULL,
  122.   PRIMARY KEY (`id`)
  123. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  124.  
  125.  
  126.  
  127. # Dump of table user_data
  128. # ------------------------------------------------------------
  129.  
  130. DROP TABLE IF EXISTS `user_data`;
  131.  
  132. CREATE TABLE `user_data` (
  133.   `id` int(10) NOT NULL AUTO_INCREMENT,
  134.   `Owner` bigint(20) unsigned NOT NULL,
  135.   `job` varchar(200) NOT NULL,
  136.   `salary` decimal(20,2) NOT NULL,
  137.   `housing` varchar(200) NOT NULL,
  138.   `validation` tinyint(4) NOT NULL DEFAULT '0',
  139.   `iban` varchar(200) NOT NULL,
  140.   `points` varchar(200) NOT NULL,
  141.   `INSERT_DT` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  142.   `UPDATE_DT` datetime DEFAULT NULL,
  143.   PRIMARY KEY (`id`)
  144. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  145.  
  146. LOCK TABLES `user_data` WRITE;
  147. /*!40000 ALTER TABLE `user_data` DISABLE KEYS */;
  148.  
  149. INSERT INTO `user_data` (`id`, `Owner`, `job`, `salary`, `housing`, `validation`, `iban`, `points`, `INSERT_DT`, `UPDATE_DT`)
  150. VALUES
  151.     (20,19,'Hacker',4000.00,'Permanent',0,'FI897435893745','0','2016-11-27 09:37:52',NULL);
  152.  
  153. /*!40000 ALTER TABLE `user_data` ENABLE KEYS */;
  154. UNLOCK TABLES;
  155.  
  156.  
  157.  
  158. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  159. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  160. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  161. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  162. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  163. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top