· 6 years ago · Jul 16, 2019, 04:58 PM
1Host: http://devfyn.s3-ap-southeast-1.amazonaws.com
2
3
4
5hpMyAdmin SQL Dump
6-- version 4.0.10deb1
7-- http://www.phpmyadmin.net
8--
9-- Host: localhost
10-- Generation Time: Sep 23, 2017 at 01:47 PM
11-- Server version: 5.7.19
12-- PHP Version: 5.5.9-1ubuntu4.22
13
14SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
15SET time_zone = "+00:00";
16
17
18/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
19/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
20/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
21/*!40101 SET NAMES utf8 */;
22
23--
24-- Database: `fund_live`
25--
26
27-- --------------------------------------------------------
28
29--
30-- Table structure for table `announcements`
31--
32
33CREATE TABLE IF NOT EXISTS `announcements` (
34 `announcement_id` int(11) NOT NULL AUTO_INCREMENT,
35 `announcement_from` varchar(45) DEFAULT NULL,
36 `announcement_datetime` datetime DEFAULT NULL,
37 `announcement_text` varchar(2000) DEFAULT NULL,
38 `announcementscol` varchar(45) DEFAULT NULL,
39 `announce_to_user` int(11) DEFAULT NULL,
40 `read_status` int(11) DEFAULT NULL,
41 PRIMARY KEY (`announcement_id`)
42) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
43
44-- --------------------------------------------------------
45
46--
47-- Table structure for table `borrowers`
48--
49
50CREATE TABLE IF NOT EXISTS `borrowers` (
51 `borrower_id` int(11) NOT NULL AUTO_INCREMENT,
52 `user_id` int(11) NOT NULL,
53 `business_name` varchar(60) DEFAULT NULL,
54 `business_organisation` varchar(100) DEFAULT NULL,
55 `bo_id` int(11) DEFAULT NULL,
56 `industry` varchar(50) DEFAULT NULL,
57 `date_of_incorporation` date DEFAULT NULL,
58 `business_registration_number` varchar(100) DEFAULT NULL,
59 `contact_person` varchar(100) DEFAULT NULL,
60 `contact_person_email` varchar(255) DEFAULT NULL,
61 `contact_person_mobile` varchar(45) DEFAULT NULL,
62 `paid_up_capital` decimal(20,8) DEFAULT NULL,
63 `paid_up_capital_currency` varchar(4) DEFAULT NULL,
64 `number_of_employees` int(11) DEFAULT NULL,
65 `operation_since` date DEFAULT NULL,
66 `risk_industry` varchar(2000) DEFAULT NULL,
67 `risk_strength` varchar(2000) DEFAULT NULL,
68 `risk_weakness` varchar(2000) DEFAULT NULL,
69 `borrower_risk_grade` varchar(1) DEFAULT NULL,
70 `registered_address` varchar(1000) DEFAULT NULL,
71 `mailing_address` varchar(1000) DEFAULT NULL,
72 `company_profile` varchar(2000) DEFAULT NULL,
73 `company_aboutus` varchar(2000) DEFAULT NULL,
74 `oAuthType` varchar(45) DEFAULT NULL,
75 `oAuth_login_id` varchar(255) DEFAULT NULL,
76 `comments` longtext,
77 `status` int(11) DEFAULT NULL COMMENT '1 - New Profile2 - For Approval3 - Corrections Required4 - Verified',
78 `company_image` varchar(255) DEFAULT NULL,
79 `company_image_thumbnail` varchar(255) DEFAULT NULL,
80 `company_video_url` varchar(255) DEFAULT NULL,
81 `register_datetime` datetime DEFAULT NULL,
82 `approval_datetime` datetime DEFAULT NULL,
83 `acra_profile_doc_url` varchar(255) DEFAULT NULL,
84 `moa_doc_url` varchar(255) DEFAULT NULL,
85 `financial_doc_url` varchar(255) DEFAULT NULL,
86 PRIMARY KEY (`borrower_id`,`user_id`),
87 KEY `fk_borrowers_users_idx` (`user_id`)
88) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;
89
90--
91-- Dumping data for table `borrowers`
92--
93
94INSERT INTO `borrowers` (`borrower_id`, `user_id`, `business_name`, `business_organisation`, `bo_id`, `industry`, `date_of_incorporation`, `business_registration_number`, `contact_person`, `contact_person_email`, `contact_person_mobile`, `paid_up_capital`, `paid_up_capital_currency`, `number_of_employees`, `operation_since`, `risk_industry`, `risk_strength`, `risk_weakness`, `borrower_risk_grade`, `registered_address`, `mailing_address`, `company_profile`, `company_aboutus`, `oAuthType`, `oAuth_login_id`, `comments`, `status`, `company_image`, `company_image_thumbnail`, `company_video_url`, `register_datetime`, `approval_datetime`, `acra_profile_doc_url`, `moa_doc_url`, `financial_doc_url`) VALUES
95(1, 229, 'VRT', NULL, 3, 'Food Industry', '2017-02-03', '12345', 'Ram', NULL, '9965956952', 500000.00000000, NULL, 45, '2017-02-04', NULL, NULL, NULL, NULL, 'ABC', 'ABC', 'Loreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuem', 'Loreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuemLoreum psuem', NULL, NULL, NULL, 4, 'uploads/borrower/1/profile_image_logo-p.png', 'uploads/borrower/1/thumbnail_logo-p.png', NULL, '2017-02-03 13:07:01', '2017-02-03 13:08:28', 'uploads/borrower/1/ACRA_Bus_pro_FYN.png', 'uploads/borrower/1/MAOA_Screen_Shot_2016-12-23_at_15.16.51.png', 'uploads/borrower/1/FNLRO_contents.doc'),
96(2, 230, 'Harshaan Co Ltd', NULL, 3, 'Food Industry', '2012-12-03', 'REGD/CRWD/2017/02/06', 'Sathya', NULL, '9087669245', 100000.00000000, NULL, 5, '2012-12-03', NULL, NULL, NULL, NULL, 'No 27 Abiya Nagar Thiruvanmiyur, chennai - 600044', 'No 27 Abiya Nagar Thiruvanmiyur, chennai - 600044', '"Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.', 'Sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur', NULL, NULL, NULL, 4, 'uploads/borrower/2/profile_image_profile4.jpg', 'uploads/borrower/2/profile_image_profile4.jpg', NULL, '2017-02-06 06:43:29', '2017-02-06 07:04:22', 'uploads/borrower/2/ACRA_Bus_pro_jwt_settings.php', 'uploads/borrower/2/MAOA_temp.txt', 'uploads/borrower/2/FNLRO_temp.txt'),
97(3, 231, 'CPC', NULL, 3, 'Food Industry', '2017-02-07', '32432423', 'Dharan', NULL, '9510000305', 6700000.00000000, NULL, 45, '2017-02-07', NULL, NULL, NULL, NULL, 'XXX,\r\nYYYY,\r\nZZZZ', 'XXXX,\r\nYYY', 'infosdfsdfsdaf', 'info', NULL, NULL, NULL, 4, 'uploads/borrower/3/profile_image_ambalam.png',
98
99
100
101Table structure for table `borrower_banks`
102--
103
104CREATE TABLE IF NOT EXISTS `borrower_banks` (
105 `borrower_bankid` int(11) NOT NULL AUTO_INCREMENT,
106 `borrower_id` int(11) NOT NULL,
107 `bank_code` varchar(45) NOT NULL,
108 `bank_name` varchar(100) NOT NULL,
109 `branch_code` varchar(100) NOT NULL,
110 `bank_account_number` varchar(100) DEFAULT NULL,
111 `verified_status` int(11) NOT NULL COMMENT '1 -> Not verified2 -> Verified',
112 `active_status` int(11) NOT NULL COMMENT '1 -> Active2 -> Inactive',
113 `bank_statement_url` varchar(255) DEFAULT NULL,
114 PRIMARY KEY (`borrower_bankid`),
115 KEY `fk_borrower_banks_borrowers1_idx` (`borrower_id`)
116) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
117
118--
119-- Dumping data for table `borrower_banks`
120--
121
122INSERT INTO `borrower_banks` (`borrower_bankid`, `borrower_id`, `bank_code`, `bank_name`, `branch_code`, `bank_account_number`, `verified_status`, `active_status`, `bank_statement_url`) VALUES
123(1, 1, '5007', 'GDFC', 'G5007', '12345007', 1, 1, 'uploads/borrower/1/bank_stat_1_Screen_Shot_2016-12-23_at_15.19.26.png'),
124(2, 2, '100000000', 'Andhra Bank', '20000000', '4388234456781234', 1, 1, 'uploads/borrower/2/bank_stat_2_green-smiley.png'),
125(3, 4, '12345', 'abc bank', '32948', '34989', 1, 1, 'uploads/borrower/4/bank_stat_3_ACRA_Bus_pro_boss-512.png'),
126(4, 5, '213424', 'abcde', '21342314', '12342134', 1, 1, 'uploads/borrower/5/bank_stat_4_sample13.jpg'),
127(5, 7, '600091', 'Andhra Bank', 'OPS1', '78216376271', 1, 1, 'uploads/borrower/7/bank_stat_5_BankAndChequeReport.xls'),
128(6, 8, '234324', 'Andhra Bank', '3532', '234523', 1, 1, 'uploads/borrower/8/bank_stat_6_document.docx'),
129(7, 10, '123456', 'icici bank', '432432', '3432', 1, 1, 'uploads/borrower/10/bank_stat_7_pic.png'),
130(8, 13, '34324324', 'rtretrtrt', 'ererewrew', '3243242342343', 1, 1, 'uploads/borrower/13/bank_stat_8_Screenshot_from_2017-07-25_12:25:06.png');
131
132-- --------------------------------------------------------
133
134--
135-- Table structure for table `borrower_directors`
136--
137
138CREATE TABLE IF NOT EXISTS `borrower_directors` (
139 `id` int(11) NOT NULL AUTO_INCREMENT,
140 `borrower_id` int(11) NOT NULL,
141 `slno` int(11) NOT NULL,
142 `name` varchar(60) DEFAULT NULL,
143 `age` varchar(10) DEFAULT NULL,
144 `period_in_this_business` varchar(20) DEFAULT NULL,
145 `overall_experience` varchar(20) DEFAULT NULL,
146 `accomplishments` varchar(2000) DEFAULT NULL,
147 `directors_profile` varchar(2000) DEFAULT NULL,
148 `identity_card_front` varchar(255) DEFAULT NULL,
149 `identity_card_back` varchar(255) DEFAULT NULL,
150 PRIMARY KEY (`id`,`borrower_id`),
151 KEY `fk_borrower_promotors_borrowers1_idx` (`borrower_id`)
152) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=63 ;
153
154--
155-- Dumping data for table `borrower_directors`
156--
157
158INSERT INTO `borrower_directors` (`id`, `borrower_id`, `slno`, `name`, `age`, `period_in_this_business`, `overall_experience`, `accomplishments`, `directors_profile`, `identity_card_front`, `identity_card_back`) VALUES
159(15, 4, 1, 'George ', '40', '5', '15', NULL, 'George is originally from Princeton BC where he developed his love for film and comics at an early age. George has lived in Prince George since his teen years and he is an alumni of both College of New Caledonia & UNBC University of Northern British Columbia. He is currently the owner of The Scene PG arts & entertainment magazine and founding director of UNLTD Media & Events which he started this past August. George spent several years at the Prince George Citizen as a media account manager where he won several national awards for the projects he led. It was during this time that Geroge\r\n and frequent collaborator Kyle Bachman (Northland Dodge) jumpstarted celebrity appearances in Prince George with a live signing by Georges St-Pierre at Northland Hyundai.It was based on this success that Norm founded the Citizen Special Events division. The GSP event was a catalyst which led to other appearances by Kim Coates and Ron Perlman as part of an initiative with Alex Huber and the British Columbia Northern Exhibition.', NULL, NULL),
160(16, 4, 2, 'John', '45', '10', '20', NULL, 'John is an award-winning writer, performer, filmmaker, educator, and creative activist. Fusing his distinct storytelling with a subversive humor and radical love of justice, John''s work has been featured in the New York Times, Huffington Post, and on his 13-year-old nephew Brian Silverstein''s Youtube page -- where it has almost 27 "likes." A regular performer on NPR’s Snap Judgment, he has performed and led workshops at UC-Berkeley, Harvard, Michigan, NYU, and over 200 colleges, high schools, and conferences across the country. The former program director for Youth Speaks, John spearheaded spoken word and youth organizing programs across the country through the Brave New Voices international youth poetry slam. John currently directs the Culture Shift program for Movement Generation, producing comedic videos and creative interventions for racial justice and climate resilience in the Bay Area and beyond. He is currently producing a new web series called The North Pole, a dramatic comedy about gentrification, global warming, and gluten-free donuts. Born and raised in DC, John lives in Oakland, CA. He plays a mean game of spades.', NULL, NULL),
161(17, 4, 3, 'Ryan', '30', '2', '6', NULL, 'Until I was 17 I had never even come close to the world of app or game development especially on the level of Augmented Reality. In grade 12 I had an idea called Swell Clock - A smartphone app that only wakes you up when the conditions are right. I approached my schoolmate Long to work with me to bring this to life. We submitted this idea to a local entrepreneurial competition, which we won. After that, I knew I needed to find something to launch my entrepreneurial flare. When the opportunity of Genesis fell into my lap, I knew we were destined for great things.', NULL, NULL),
162(18, 11, 1, 'name1r', '23', NULL, '12', '<p>yuyuyuy<br></p>', '<p>yuyuyu<br></p>', NULL, NULL),
163(19, 11, 2, 'rerwer', '232', NULL, '2', '<p>dfdf<br></p>', '<p>dfdsf<br></p>', NULL, NULL),
164(20, 12, 1, 'fsdfdsdff', '23', NULL, '4', '<p>dfdsfdsf<br></p>', '<p>dfdsfsfd<br></p>', NULL, NULL),
165(24, 13, 1, 'erewrwer', '23', NULL, '3', '<p>erewrwerew<br></p>', '<p>errwerewrewrewr<br></p>', NULL, NULL),
166(25, 13, 2, 'ghfghfghg', '34', NULL, '4', 'rtretertre', 'rtretretre', 'uploads/borrower/13/dir_iden_front_25_Screenshot_from_2017-07-25_12:25:46.png', NULL),
167(26, 12, 2, 'erewr', '14', NULL, '2', '<p>3424dfsdf<br></p>', '<p>erewrew<br></p>', 'uploads/borrower/12/dir_iden_front_26_Screenshot_from_2017-07-25_12:25:06.png', NULL),
168(27, 14, 1, 'Optimus Prime', '5678', NULL, '3000', '<p>Bring <span style="font-family: Roboto, Helvetica, Tahoma, sans-serif; font-size: 16px;">peace to galaxy</span></p>', '<p><span style="color: rgb(34, 34, 34); font-family: sans-serif;">Optimus Prime (formerly </span><b style="color: rgb(34, 34, 34); font-family: sans-serif;">Orion Pax</b><span style="color: rgb(34, 34, 34); font-family: sans-serif;">) is constantly, if not always depicted as having strong </span><a href="https://en.wikipedia.org/wiki/Moral_character" title="Moral character" style="color: rgb(11, 0, 128); background: none rgb(255, 255, 255); font-family: sans-serif;">moral character</a><span style="color: rgb(34, 34, 34); font-family: sans-serif;">, excellent </span><a href="https://en.wikipedia.org/wiki/Leadership" title="Leadership" style="color: rgb(11, 0, 128); background: none rgb(255, 255, 255); font-family: sans-serif;">leadership</a><span style="color: rgb(34, 34, 34); font-family: sans-serif;">, and sound </span><a href="https://en.wikipedia.org/wiki/Decision-making" title="Decision-making" style="color: rgb(11, 0, 128); background: none rgb(255, 255, 255); font-family: sans-serif;">decision-making</a><span style="color: rgb(34, 34, 34); font-family: sans-serif;"> skills, and possesses brilliant </span><a href="https://en.wikipedia.org/wiki/Military_tactics" title="Military tactics" style="color: rgb(11, 0, 128); background: none rgb(255, 255, 255); font-family: sans-serif;">military tactics</a><span style="color: rgb(34, 34, 34); font-family: sans-serif;">, powerful </span><a href="https://en.wikipedia.org/wiki/Martial_arts" title="Martial arts" style="color: rgb(11, 0, 128); background: none rgb(255, 255, 255); font-family: sans-serif;">martial arts</a><span style="color: rgb(34, 34, 34); font-family: sans-serif;">, and advanced extra-terrestrial weaponry.</span><br></p>', NULL, NULL),
169(28, 20, 1, 'sdsd', '23', NULL, '2', '<p>dsdsa<br></p>', '<p>sdasdasda<br></p>', 'uploads/borrower/20/dir_iden_front_28_Screenshot_from_2017-09-04_12:14:55.png', NULL),
170(29, 21, 1, 'Someone', '1000', NULL, '5000', '<p>2</p>', '<p>1</p>', NULL, NULL),