· 9 years ago · Oct 02, 2016, 02:26 PM
1-- phpMyAdmin SQL Dump
2-- version 3.4.5
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Feb 19, 2013 at 02:01 PM
7-- Server version: 5.5.16
8-- PHP Version: 5.3.8
9
10SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
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
19--
20-- Database: `netbanking`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `accountmaster`
27--
28
29CREATE TABLE IF NOT EXISTS `accountmaster` (
30 `accounttype` varchar(25) NOT NULL,
31 `prefix` varchar(11) NOT NULL,
32 `minbalance` double(12,2) NOT NULL,
33 `interest` double(10,2) NOT NULL,
34 PRIMARY KEY (`accounttype`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `accountmaster`
39--
40
41INSERT INTO `accountmaster` (`accounttype`, `prefix`, `minbalance`, `interest`) VALUES
42('current', 'fd', 6000.00, 600.00),
43('dfd', 'gdf', 45.00, 7546.00),
44('salary account', 'SAL', 0.00, 10.00),
45('saving', 'sb', 4000.00, 500.00);
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `accounts`
51--
52
53CREATE TABLE IF NOT EXISTS `accounts` (
54 `accno` varchar(25) NOT NULL,
55 `customerid` int(10) NOT NULL,
56 `accstatus` varchar(25) NOT NULL,
57 `primaryacc` varchar(10) NOT NULL,
58 `accopendate` date NOT NULL,
59 `accounttype` varchar(25) NOT NULL,
60 `accountbalance` double(10,2) NOT NULL,
61 `unclearbalance` double(10,2) NOT NULL,
62 `accuredinterest` double(10,2) NOT NULL,
63 PRIMARY KEY (`accno`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65
66--
67-- Dumping data for table `accounts`
68--
69
70INSERT INTO `accounts` (`accno`, `customerid`, `accstatus`, `primaryacc`, `accopendate`, `accounttype`, `accountbalance`, `unclearbalance`, `accuredinterest`) VALUES
71('4666', 98683, 'active', '40000', '2013-02-11', 'sv', 100000.00, 100.00, 100.00);
72
73-- --------------------------------------------------------
74
75--
76-- Table structure for table `branch`
77--
78
79CREATE TABLE IF NOT EXISTS `branch` (
80 `ifsccode` varchar(25) NOT NULL,
81 `branchname` varchar(50) NOT NULL,
82 `city` varchar(25) NOT NULL,
83 `branchaddress` text NOT NULL,
84 `state` varchar(25) NOT NULL,
85 `country` varchar(25) NOT NULL,
86 PRIMARY KEY (`ifsccode`)
87) ENGINE=InnoDB DEFAULT CHARSET=latin1;
88
89--
90-- Dumping data for table `branch`
91--
92
93INSERT INTO `branch` (`ifsccode`, `branchname`, `city`, `branchaddress`, `state`, `country`) VALUES
94('5249898', 'Mangalore', 'gfhdh', 'hdjjj', 'PAKISTAN', 'MAHARASTRA'),
95('KARB0000404', 'karkala', 'karkala', 'NEAR BUS STAND,KARLA COMPLEX,1ST FLOOR,PB 19,KARKALA 574104,UDUPI DIST', 'KARNATAKA', 'india'),
96('tyg', 'yfy', 'fy', 'yfg', 'PAKISTAN', 'MAHARASTRA');
97
98-- --------------------------------------------------------
99
100--
101-- Table structure for table `customers`
102--
103
104CREATE TABLE IF NOT EXISTS `customers` (
105 `customerid` int(10) NOT NULL AUTO_INCREMENT,
106 `ifsccode` varchar(25) NOT NULL,
107 `firstname` varchar(25) NOT NULL,
108 `lastname` varchar(25) NOT NULL,
109 `loginid` varchar(25) NOT NULL,
110 `accpassword` varchar(50) NOT NULL,
111 `transpasword` varchar(50) NOT NULL,
112 `accstatus` varchar(25) NOT NULL,
113 `city` varchar(25) NOT NULL,
114 `state` varchar(25) NOT NULL,
115 `country` varchar(25) NOT NULL,
116 `accopendate` date NOT NULL,
117 `lastlogin` datetime NOT NULL,
118 PRIMARY KEY (`customerid`)
119) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=98684 ;
120
121--
122-- Dumping data for table `customers`
123--
124
125INSERT INTO `customers` (`customerid`, `ifsccode`, `firstname`, `lastname`, `loginid`, `accpassword`, `transpasword`, `accstatus`, `city`, `state`, `country`, `accopendate`, `lastlogin`) VALUES
126(98680, 'KARB0000404', 'sadf', 'werwe', '23432', 'fgdfg', 'werwe', 'ACTIVE', '23423', 'KARNATAKA', 'INDIA', '2013-02-02', '0000-00-00 00:00:00'),
127(98682, '5249898', 'Raj', 'kiran', '123456', '987654', '123456', 'ACTIVE', 'mangaloree', 'KARNATAKA', 'INDIA', '2013-02-02', '0000-00-00 00:00:00'),
128(98683, '5249898', 'john', 'mark', 'cust', 'cust', 'cust', 'ACTIVE', 'mangalore', 'KARNATAKA', 'INDIA', '2013-02-09', '2013-02-16 05:25:20');
129
130-- --------------------------------------------------------
131
132--
133-- Table structure for table `employees`
134--
135
136CREATE TABLE IF NOT EXISTS `employees` (
137 `empid` int(10) NOT NULL AUTO_INCREMENT,
138 `employee_name` varchar(25) NOT NULL,
139 `loginid` varchar(25) NOT NULL,
140 `password` varchar(25) NOT NULL,
141 `emailid` varchar(30) NOT NULL,
142 `contactno` varchar(30) NOT NULL,
143 `createdat` date NOT NULL,
144 `last_login` datetime NOT NULL,
145 PRIMARY KEY (`empid`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=313800 ;
147
148--
149-- Dumping data for table `employees`
150--
151
152INSERT INTO `employees` (`empid`, `employee_name`, `loginid`, `password`, `emailid`, `contactno`, `createdat`, `last_login`) VALUES
153(313786, 'soudhabanu', '445545', '125487', 'soudha_ban@52yahoo.com', '9535543313', '2012-12-15', '2012-12-03 11:27:00'),
154(313787, 'mahesh', 'mahesh', 'qwert', 'mahesh@gmail.com', '98478872783', '0000-00-00', '0000-00-00 00:00:00'),
155(313788, 'jyothi', '3535355', '3636', 'jyothi@yahoo.com', '95425422424', '2013-01-02', '0000-00-00 00:00:00'),
156(313791, 'admin', 'admin', 'admin', 'admin', 'admin', '2013-01-12', '2013-01-12 00:00:00'),
157(313798, 'raj', 'rajkiran', '123456', 'abc@gmail.com', '9874563210', '2013-02-02', '0000-00-00 00:00:00'),
158(313799, 'peter king', 'emp', 'emp', 'emp@gmail.com', '987456321', '2013-02-09', '0000-00-00 00:00:00');
159
160-- --------------------------------------------------------
161
162--
163-- Table structure for table `loan`
164--
165
166CREATE TABLE IF NOT EXISTS `loan` (
167 `loanid` int(10) NOT NULL AUTO_INCREMENT,
168 `loantype` varchar(25) NOT NULL,
169 `loanamt` varchar(25) NOT NULL,
170 `period` varchar(25) NOT NULL,
171 `interest` float(10,2) NOT NULL,
172 `startdate` date NOT NULL,
173 PRIMARY KEY (`loanid`)
174) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2147483647 ;
175
176--
177-- Dumping data for table `loan`
178--
179
180INSERT INTO `loan` (`loanid`, `loantype`, `loanamt`, `period`, `interest`, `startdate`) VALUES
181(2147483647, 'homeloan', '300000', 'monthly', 63.09, '2012-12-02');
182
183-- --------------------------------------------------------
184
185--
186-- Table structure for table `loanpayment`
187--
188
189CREATE TABLE IF NOT EXISTS `loanpayment` (
190 `paymentid` int(10) NOT NULL AUTO_INCREMENT,
191 `date` date NOT NULL,
192 `paidamt` float(10,2) NOT NULL,
193 `principleamt` float(10,2) NOT NULL,
194 `interestamt` float(10,2) NOT NULL,
195 `balance` float(10,2) NOT NULL,
196 PRIMARY KEY (`paymentid`)
197) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2147483647 ;
198
199--
200-- Dumping data for table `loanpayment`
201--
202
203INSERT INTO `loanpayment` (`paymentid`, `date`, `paidamt`, `principleamt`, `interestamt`, `balance`) VALUES
204(2147483647, '2012-01-03', 50000.00, 25000.00, 2500.50, 250000.00);
205
206-- --------------------------------------------------------
207
208--
209-- Table structure for table `loantype`
210--
211
212CREATE TABLE IF NOT EXISTS `loantype` (
213 `loantype` varchar(25) NOT NULL,
214 `prefix` varchar(25) NOT NULL,
215 `maximumamt` float(10,2) NOT NULL,
216 `minimumamt` float(10,2) NOT NULL,
217 `interest` float(10,2) NOT NULL,
218 `status` varchar(25) NOT NULL,
219 UNIQUE KEY `loantype` (`loantype`)
220) ENGINE=InnoDB DEFAULT CHARSET=latin1;
221
222--
223-- Dumping data for table `loantype`
224--
225
226INSERT INTO `loantype` (`loantype`, `prefix`, `maximumamt`, `minimumamt`, `interest`, `status`) VALUES
227('current', 'sb', 70000.00, 50000.00, 3000.00, 'active'),
228('homeloan', 'hl', 1000000.00, 50000.00, 65.09, 'active'),
229('sb', 'fd', 7000.00, 5000.00, 400.00, 'active');
230
231-- --------------------------------------------------------
232
233--
234-- Table structure for table `mail`
235--
236
237CREATE TABLE IF NOT EXISTS `mail` (
238 `mailid` int(10) NOT NULL AUTO_INCREMENT,
239 `subject` varchar(250) NOT NULL,
240 `message` text NOT NULL,
241 `mdatetime` datetime NOT NULL,
242 `senderid` varchar(25) NOT NULL,
243 `reciverid` varchar(25) NOT NULL,
244 PRIMARY KEY (`mailid`)
245) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
246
247--
248-- Dumping data for table `mail`
249--
250
251INSERT INTO `mail` (`mailid`, `subject`, `message`, `mdatetime`, `senderid`, `reciverid`) VALUES
252(10, 'sdfgfdg', 'dfgfdg', '2013-01-19 05:05:58', '0', 'admin'),
253(12, 'fdgdfsgsd', 'fgdsfgdsfg', '2013-02-02 05:32:29', 'admin', '98682'),
254(13, 'hello this is test pag', 'this is test page to all emp', '2013-02-02 05:33:00', 'admin', '98682'),
255(14, 'good morning raj kiran', 'this is welcome page', '2013-02-02 05:36:16', 'admin', '98682');
256
257-- --------------------------------------------------------
258
259--
260-- Table structure for table `registerdpayee`
261--
262
263CREATE TABLE IF NOT EXISTS `registerdpayee` (
264 `slno` int(11) NOT NULL AUTO_INCREMENT,
265 `payeename` varchar(25) NOT NULL,
266 `accountnumber` varchar(25) NOT NULL,
267 `accounttype` varchar(25) NOT NULL,
268 `bankname` varchar(25) NOT NULL,
269 `ifsccode` varchar(25) NOT NULL,
270 PRIMARY KEY (`slno`)
271) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=102 ;
272
273--
274-- Dumping data for table `registerdpayee`
275--
276
277INSERT INTO `registerdpayee` (`slno`, `payeename`, `accountnumber`, `accounttype`, `bankname`, `ifsccode`) VALUES
278(101, 'arpitha', '26548', 'saving', 'canarabank', 'KARB0000404');
279
280-- --------------------------------------------------------
281
282--
283-- Table structure for table `transaction`
284--
285
286CREATE TABLE IF NOT EXISTS `transaction` (
287 `transactionid` int(10) NOT NULL AUTO_INCREMENT,
288 `transactiondate` date NOT NULL,
289 `paymentdate` datetime NOT NULL,
290 `payeeid` int(25) NOT NULL,
291 `receiveid` int(10) NOT NULL,
292 `debitac` varchar(25) NOT NULL,
293 `amount` float(10,2) NOT NULL,
294 `paymentstat` varchar(25) NOT NULL,
295 PRIMARY KEY (`transactionid`)
296) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2147483647 ;
297
298--
299-- Dumping data for table `transaction`
300--
301
302INSERT INTO `transaction` (`transactionid`, `transactiondate`, `paymentdate`, `payeeid`, `receiveid`, `debitac`, `amount`, `paymentstat`) VALUES
303(2147483647, '2012-12-13', '2012-12-03 04:21:10', 111232154, 0, '150000', 100000.00, 'active');
304
305/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
306/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
307/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;