3Hv2q9d0

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
26DROP TABLE IF EXISTS `borrow_request`;
27
28CREATE 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
42LOCK TABLES `borrow_request` WRITE;
43/*!40000 ALTER TABLE `borrow_request` DISABLE KEYS */;
44
45INSERT INTO `borrow_request` (`id`, `Owner`, `Amount`, `Interest`, `Loantime`, `status`, `INSERT_DT`, `ORIG_ID`, `UPDATE_DT`, `amount_got`)
46VALUES
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 */;
51UNLOCK TABLES;
52
53
54# Dump of table invoice
55# ------------------------------------------------------------
56
57DROP TABLE IF EXISTS `invoice`;
58
59CREATE 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
76DROP TABLE IF EXISTS `new_users`;
77
78CREATE 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
93LOCK TABLES `new_users` WRITE;
94/*!40000 ALTER TABLE `new_users` DISABLE KEYS */;
95
96INSERT INTO `new_users` (`id`, `name`, `email`, `phone`, `password`, `ssn`, `currency`, `type_person`, `ORIG_ID`, `INSERT_DT`, `UPDATE_DT`)
97VALUES
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 */;
102UNLOCK TABLES;
103
104
105# Dump of table payment_plan
106# ------------------------------------------------------------
107
108DROP TABLE IF EXISTS `payment_plan`;
109
110CREATE 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
130DROP TABLE IF EXISTS `user_data`;
131
132CREATE 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
146LOCK TABLES `user_data` WRITE;
147/*!40000 ALTER TABLE `user_data` DISABLE KEYS */;
148
149INSERT INTO `user_data` (`id`, `Owner`, `job`, `salary`, `housing`, `validation`, `iban`, `points`, `INSERT_DT`, `UPDATE_DT`)
150VALUES
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 */;
154UNLOCK 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 */;